using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using Core.Mes.Client.Comm.Server;
using CoreFS.CA06;
using System.Collections;
using Core.Mes.Client.Comm.Control;
using Infragistics.Win.UltraWinGrid;
using Core.Mes.Client.Comm.Tool;
using Infragistics.Win;
using Infragistics.Win.UltraWinEditors;
using Core.StlMes.Client.Mcp.Entity;
using Core.StlMes.Client.Mcp.Control;
namespace Core.StlMes.Client.Mcp.Coupling
{
public partial class FrmCouplingConfirm : FrmBase
{
public FrmCouplingConfirm()
{
InitializeComponent();
this.IsLoadUserView = true;
}
public override void ToolBar_Click(object sender, string ToolbarKey)
{
switch (ToolbarKey)
{
case "DoQuery":
DoQuery();
break;
case "Confirm":
Confirm();
break;
case "CancelConfirm":
cancelConfirm();
break;
case "DoDelete":
DoDelete();
break;
case "Export":
GridHelper.ulGridToExcel(ultraGrid1, "接箍入库确认");
break;
case "DoClose":
this.Close();
break;
}
}
///
/// 查询
///
private void DoQuery()
{
string[] starts = { };
string woId = "";//工单号
string judgeStoveNo = "";//炉号
string txtShift = "";//班次
string txtConfirm = "";//是否确认
string startTim = "";
string endTim = "";
#region 条件
if (chkTim2.Checked)
{
if (DateTime.Parse(this.StartTime.Value.ToString()) > DateTime.Parse(EndTime.Value.ToString()))
{
MessageUtil.ShowTips("选择的前面时间不能大于后面的时间!");
return;
}
else
{
startTim = this.StartTime.Value.ToString("yyyy-MM-dd HH:mm:ss");
endTim = this.EndTime.Value.ToString("yyyy-MM-dd HH:mm:ss");
}
}
if (chkStarts.Checked)
{
if (string.IsNullOrEmpty(cmbStarts.Text.Trim()))
{
MessageUtil.ShowTips("请选择工单状态!");
return;
}
else
{
starts = (cmbStarts.Value as List).Select(p => p.ToString().Trim()).ToArray();
}
}
if (chkwoId.Checked)
{
if (chkwoId.Checked && string.IsNullOrEmpty(txtWoId.Text.Trim()))
{
MessageUtil.ShowTips("请输入工单号!");
return;
}
else
{
woId = txtWoId.Text.ToString().Trim();
}
}
if (chkJuNo.Checked)
{
if (chkJuNo.Checked && string.IsNullOrEmpty(txtJudgeStoveNO.Text.Trim()))
{
MessageUtil.ShowTips("请输入炉号!");
return;
}
else
{
judgeStoveNo = txtJudgeStoveNO.Text.ToString().Trim();
}
}
if (chkshift.Checked)
{
if (chkshift.Checked && string.IsNullOrEmpty(shift.Text.Trim()))
{
MessageUtil.ShowTips("请输入班次!");
return;
}
else
{
if (string.IsNullOrEmpty(shift.Text.Trim()))
{
txtShift = "";
}
else
{
txtShift = shift.Value.ToString().Trim();
}
}
}
if (chkconfirm.Checked && string.IsNullOrEmpty(confirm.Text.Trim()))
{
MessageUtil.ShowTips("请选择是否确认!");
return;
}
else
{
if(confirm.Text.ToString().Trim().Equals("确认"))
{
txtConfirm = "1";
}
else if (confirm.Text.ToString().Trim().Equals("未确认"))
{
txtConfirm = "0";
}
else
{
txtConfirm = "";
}
}
#endregion
List listSource1 = EntityHelper.GetData
("com.steering.mes.mcp.coup.PhosphateResultService.getphosInResult", new object[] { startTim, endTim,starts, woId, judgeStoveNo, txtShift, txtConfirm }, this.ob);
couplingbindingSource.DataSource = listSource1;
GridHelper.RefreshAndAutoSize(ultraGrid1);
foreach (UltraGridRow urg in ultraGrid1.Rows)
{
if (urg.Cells["Matconfirm"].Value.Equals("确认"))
{
urg.Appearance.BackColor = Color.LightGreen;
}
}
}
///
/// 确认
///
private void Confirm()
{
ultraGrid1.UpdateData();
UltraGridRow uRow = this.ultraGrid1.ActiveRow;
if (uRow == null) { MessageUtil.ShowTips("无数据!"); return; }
ArrayList list1 = new ArrayList();
int UpdaCount = 0;
foreach (UltraGridRow ugr in ultraGrid1.Rows)
{
if (Convert.ToBoolean(ugr.Cells["CHK"].Text) == true)
{
if (ugr.Cells["Matconfirm"].Value.ToString().Equals("1"))
{
MessageUtil.ShowTips("选中有已确认实绩,不允许再次确认!");
return;
}
string firm = "";
string shift = "";
if (ugr.Cells["Matconfirm"].Value.ToString().Equals("确认"))
{
firm = "1";
}
else
{
firm = "0";
}
if (ugr.Cells["ColShift"].Value.ToString().Equals("早班"))
{
shift = "1";
}
else if (ugr.Cells["ColShift"].Value.ToString().Equals("中班"))
{
shift = "2";
}
else if (ugr.Cells["ColShift"].Value.ToString().Equals("晚班"))
{
shift = "3";
}
else
{
shift = "4";
}
UpdaCount += 1;
ArrayList list = new ArrayList();
list.Add(ugr.Cells["WoId"].Text.ToString());
list.Add(shift);
list.Add(ugr.Cells["JudgeStoveNo"].Value.ToString());
list.Add(ugr.Cells["BatchNo"].Value.ToString());
list.Add(firm);
list.Add(UserInfo.GetUserName());
list.Add(DateTime.Now.ToString());
list.Add(ugr.Cells["CreateTime"].Value.ToString());
//list.Add(ugr.Cells[""])
list1.Add(list);
}
}
if (UpdaCount == 0) { MessageUtil.ShowTips("请选择确认数据!"); return; }
if (MessageUtil.ShowYesNoAndQuestion("是否确认?") == DialogResult.No)
{
return;
}
CoreClientParam ccp = new CoreClientParam();
try
{
this.Cursor = Cursors.WaitCursor; //控制鼠标的样式为等待
if (Constant.WaitingForm == null)
{
Constant.WaitingForm = new WaitingForm();
}
Constant.WaitingForm.ShowToUser = true;
Constant.WaitingForm.Show();
Constant.WaitingForm.Update();
ccp.ServerName = "com.steering.mes.mcp.coup.PhosphateResultService";
ccp.MethodName = "getMatConfirm";
ccp.ServerParams = new object[] { list1 };
ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
this.Cursor = Cursors.Default;
Constant.WaitingForm.ShowToUser = false;
Constant.WaitingForm.Close();
Constant.WaitingForm = null;
}
catch (Exception ex)
{
this.Cursor = Cursors.Default;
Constant.WaitingForm.ShowToUser = false;
Constant.WaitingForm.Close();
Constant.WaitingForm = null;
}
if (ccp.ReturnCode != -1)
{
MessageUtil.ShowTips(ccp.ReturnInfo);
if (ccp.ReturnInfo.Equals("确认成功!"))
{
DoQuery();
}
}
}
///
/// 取消确认
///
private void cancelConfirm()
{
ultraGrid1.UpdateData();
UltraGridRow uRow = this.ultraGrid1.ActiveRow;
if (uRow == null) { MessageUtil.ShowTips("无数据!"); return; }
ArrayList list1 = new ArrayList();
int UpdaCount = 0;
foreach (UltraGridRow ugr in ultraGrid1.Rows)
{
if (Convert.ToBoolean(ugr.Cells["CHK"].Text) == true)
{
if (ugr.Cells["Matconfirm"].Value.ToString().Equals("0"))
{
MessageUtil.ShowTips("选中有没确认实绩,不允许取消确认!");
return;
}
UpdaCount += 1;
string firm = "";
string shift = "";
if (ugr.Cells["Matconfirm"].Value.ToString().Equals("确认"))
{
firm = "1";
}
else
{
firm = "0";
}
if (ugr.Cells["ColShift"].Value.ToString().Equals("早班"))
{
shift = "1";
}
else if (ugr.Cells["ColShift"].Value.ToString().Equals("中班"))
{
shift = "2";
}
else
{
shift = "3";
}
ArrayList list = new ArrayList();
list.Add(ugr.Cells["WoId"].Text.ToString());
list.Add(shift);
list.Add(ugr.Cells["JudgeStoveNo"].Value.ToString());
list.Add(ugr.Cells["BatchNo"].Value.ToString());
list.Add(firm);
list.Add(UserInfo.GetUserName());
list.Add(DateTime.Today.ToString());
list.Add(ugr.Cells["CreateTime"].Value.ToString());
list1.Add(list);
}
}
if (UpdaCount == 0) { MessageUtil.ShowTips("请选择取消数据!"); return; }
if (MessageUtil.ShowYesNoAndQuestion("是否取消确认?") == DialogResult.No)
{
return;
}
CoreClientParam ccp = new CoreClientParam();
try
{
this.Cursor = Cursors.WaitCursor; //控制鼠标的样式为等待
if (Constant.WaitingForm == null)
{
Constant.WaitingForm = new WaitingForm();
}
Constant.WaitingForm.ShowToUser = true;
Constant.WaitingForm.Show();
Constant.WaitingForm.Update();
ccp.ServerName = "com.steering.mes.mcp.coup.PhosphateResultService";
ccp.MethodName = "getCancelMatConfirm";
ccp.ServerParams = new object[] { list1 };
ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
this.Cursor = Cursors.Default;
Constant.WaitingForm.ShowToUser = false;
Constant.WaitingForm.Close();
Constant.WaitingForm = null;
}
catch (Exception ex)
{
this.Cursor = Cursors.Default;
Constant.WaitingForm.ShowToUser = false;
Constant.WaitingForm.Close();
Constant.WaitingForm = null;
}
if (ccp.ReturnCode != -1)
{
MessageUtil.ShowTips(ccp.ReturnInfo);
if (ccp.ReturnInfo.Equals("取消确认成功!"))
{
DoQuery();
}
}
}
///
/// 修改
///
private void DoUpdate()
{
ultraGrid1.UpdateData();
int updateCount = 0;
ArrayList list1 = new ArrayList();
string dtime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
string flag = "";
foreach (UltraGridRow ugr in ultraGrid1.Rows)
{
if (Convert.ToBoolean(ugr.Cells["CHK"].Text) == true)
{
flag = "1";
if (ugr.Cells["MACHINE_NO"].Text.Trim().Equals("")) { MessageUtil.ShowTips("请输入机床编号!"); return; }
updateCount += 1;
ArrayList list = new ArrayList();
list.Add(ugr.Cells["MACHINE_NO"].Text.ToString());
list.Add(this.UserInfo.GetUserName());
list.Add(dtime);
list.Add(ugr.Cells["MACHINE_NO"].Value.ToString());
list.Add(ugr.Cells["MACHINE_NO"].Value.ToString());
list1.Add(list);
}
}
ArrayList list2 = new ArrayList();
foreach (UltraGridRow ugr in ultraGrid1.Rows)
{
if (Convert.ToBoolean(ugr.Cells["CHK"].Text) == true)
{
flag = "2";
updateCount += 1;
UltraGridRow row = ultraGrid1.ActiveRow;
if (row == null) { MessageUtil.ShowTips("机床信息不能为空"); return; }
ArrayList list = new ArrayList();
if (ugr.Cells["PRO_BZ"].Text.ToString().Equals(""))
{
MessageUtil.ShowTips("班组不能为空");
return;
}
list.Add(row.Cells["MACHINE_NO"].Value.ToString());
//list.Add(row.Cells["PLINE_NO"].Value.ToString());
list.Add("700305");
list.Add(ugr.Cells["MACHINE_USER1"].Text.Trim().ToString());
list.Add(ugr.Cells["MACHINE_USER2"].Text.Trim().ToString());
list.Add(ugr.Cells["PRO_BZ"].Value.ToString());
list.Add(this.UserInfo.GetUserName());
list.Add(dtime);
list.Add(ugr.Cells["ID"].Value.ToString());
list2.Add(list);
}
}
if (updateCount == 0) { MessageUtil.ShowTips("请选择修改数据!"); return; }
if (MessageUtil.ShowYesNoAndQuestion("是否修改?") == DialogResult.No) { return; }
CoreClientParam ccp = new CoreClientParam();
ccp.ServerName = "com.steering.mes.mcp.coup.FrmMachine";
ccp.MethodName = "getUpdatePhosphateItem";
ccp.ServerParams = new object[] { list1, list2, flag };
ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
if (ccp.ReturnCode == -1) return;
MessageUtil.ShowTips(ccp.ReturnInfo);
if (ccp.ReturnInfo.Equals("修改成功!"))
{
DoQuery();
}
}
///
/// 删除
///
private void DoDelete()
{
ultraGrid1.UpdateData();
int updateCount = 0;
ArrayList list1 = new ArrayList();
ArrayList list2 = new ArrayList();
string flag = "";
foreach (UltraGridRow ugr in ultraGrid1.Rows)
{
if (Convert.ToBoolean(ugr.Cells["CHK"].Text) == true)
{
flag = "1";
updateCount += 1;
ArrayList list = new ArrayList();
list.Add(ugr.Cells["MACHINE_NO"].Value.ToString());
//list.Add(ugr.Cells["PLINE_NO"].Value.ToString());
list.Add("700305");
list1.Add(list);
}
}
foreach (UltraGridRow ugr in ultraGrid1.Rows)
{
if (Convert.ToBoolean(ugr.Cells["CHK"].Text) == true)
{
flag = "2";
updateCount += 1;
ArrayList list = new ArrayList();
list.Add(ugr.Cells["ID"].Value.ToString());
list2.Add(list);
}
}
if (updateCount == 0) { MessageUtil.ShowTips("请选择要删除的数据!"); return; }
if (MessageUtil.ShowYesNoAndQuestion("是否删除?") == DialogResult.No) { return; }
CoreClientParam ccp = new CoreClientParam();
ccp.ServerName = "com.steering.mes.mcp.coup.FrmMachine";
ccp.MethodName = "getDeletePhosphateItem";
ccp.ServerParams = new object[] { list1,list2, flag };
ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
if (ccp.ReturnCode == -1) return;
MessageUtil.ShowTips(ccp.ReturnInfo);
if (ccp.ReturnInfo.Equals("删除成功!"))
{
DoQuery();
}
}
private void FrmCouplingConfirm_Load(object sender, EventArgs e)
{
EntityHelper.ShowGridCaption(ultraGrid1.DisplayLayout.Bands[0]);
PipeManageClass.setUltraGridColumnInput(ultraGrid1, new string[] { "LhNum" });//支数
this.IsLoadUserView = true;
}
private void chkStarts_CheckedChanged(object sender, EventArgs e)
{
if (chkStarts.Checked) { cmbStarts.Enabled = true; } else { cmbStarts.Enabled = false; }
if (chkJuNo.Checked) { txtJudgeStoveNO.Enabled = true; } else { txtJudgeStoveNO.Enabled = false; }
if (chkshift.Checked) { shift.Enabled = true; } else { shift.Enabled = false; }
if (chkwoId.Checked) { txtWoId.Enabled = true; } else { txtWoId.Enabled = false; }
}
}
}