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 CoreFS.CA06; using Core.LZMes.Client.UIE; using System.Collections; namespace Core.LZMes.Client.UIM { public partial class UIM010290 : FrmBase { public UIM010290() { InitializeComponent(); } private void init() { string commCodeCd = "M01001"; DataTable dt = new DataTable(); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "UIB.COM.ComDBQuery"; ccp.MethodName = "doSimpleQuery"; System.Collections.ArrayList paramArray = new System.Collections.ArrayList(); paramArray.Add("UIECOMM00_SELECT.COMM_CODE"); paramArray.Add(commCodeCd); ccp.ServerParams = new object[] { paramArray }; ccp.SourceDataTable = dt; this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); Core.LZMes.Client.UIE.UIE041.UIEBase.Init_ComboControl(this.ComboOrdProc, ref dt, "M01001"); } public override void ToolBar_Click(object sender, string ToolbarKey) { switch (ToolbarKey) { case "Query": this.DoQuery(); break; case "Save": this.DoSave(); break; case "setDefectiveCoil": this.setDefectiveCoil(); break; case "unsetDefectiveCoil": this.unsetDefectiveCoil(); break; } } /// /// 查询待入库钢卷 /// private void DoQuery() { try { this.dataSet1.Tables[0].Clear(); string procuctedTime = ultraDateTimeEditor1.Value != null ? ultraDateTimeEditor1.DateTime.ToString("yyyyMMdd") : ""; string procuctedTime2 = ultraDateTimeEditor1.Value != null ? ultraDateTimeEditor2.DateTime.ToString("yyyyMMdd") : ""; string coilNo = textBox9.Text.Trim(); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "UIB.COM.ComDBQuery"; ccp.MethodName = "doSimpleQuery"; System.Collections.ArrayList paramArray = new System.Collections.ArrayList(); if (this.CustomInfo=="2") paramArray.Add("UIM010290_04.SELECT"); else paramArray.Add("UIM010290_03.SELECT"); paramArray.Add(coilNo); paramArray.Add(procuctedTime); paramArray.Add(procuctedTime2); paramArray.Add(coilNo); ccp.ServerParams = new object[] { paramArray }; ccp.SourceDataTable = this.dataSet1.Tables[0]; this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); textBox1.Text = ""; } catch (Exception EX) { MessageBox.Show(EX.ToString()); } } /// /// 待处理钢卷保存 /// private void DoSave() { string entryShift = UserInfo.GetUserOrder();//入库班次 string entryGroup = UserInfo.GetUserGroup();//入库班组 string reg_id = UserInfo.GetUserID();//操作人 string mdType = Common.FixDBManager.CheckNullStr(Convert.ToString(this.ComboOrdProc.Value));//操作类型 string coilno = Common.FixDBManager.CheckNullStr(Convert.ToString(this.textBox1.Text));//操作类型 string fbreason = Common.FixDBManager.CheckNullStr(Convert.ToString(this.textBox2.Text));//封闭原因 string msg = ""; string line = ""; if (this.CustomInfo == "2") line = "S"; else line = "L"; this.ultraGrid1.UpdateData(); StringBuilder strBf = new StringBuilder(); DataRow[] selectedRows = this.dataSet1.Tables[0].Select("CHK ='True'"); for (int i = 0; i < selectedRows.Length; i++) { strBf.Append(selectedRows[i]["COIL_NO"]).Append("|"); } Hashtable paramHsmp = new Hashtable(); paramHsmp.Add("i1", reg_id); paramHsmp.Add("i2", entryShift); paramHsmp.Add("i3", entryGroup); paramHsmp.Add("i4", mdType); paramHsmp.Add("i5", strBf.ToString()); paramHsmp.Add("i6", line); paramHsmp.Add("i7", fbreason); paramHsmp.Add("o8", msg); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "UIB.COM.ComDBProcedure"; ccp.MethodName = "doXmlProcedure"; ccp.ServerParams = new object[] { "UIM010290_03.CALL", paramHsmp }; ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (0 == ccp.ReturnCode) { MessageBox.Show("操作成功!"); } DoQuery(); } /// /// 次品卷指定 /// private void setDefectiveCoil() { /* for (int i = 0; i < this.ultraGrid1.Rows.Count; i++) { if(this.ultraGrid1.Rows[i].Cells["CHK"].Value.Equals("Y")) { str.Append(this.ultraGrid1.Rows[i].Cells["COIL_NO"].Value).Append(","); } }*/ this.ultraGrid1.UpdateData(); StringBuilder strBf = new StringBuilder(); DataRow[] selectedRows = this.dataSet1.Tables[0].Select("CHK ='True'"); for (int i = 0; i < selectedRows.Length; i++) { strBf.Append(selectedRows[i]["COIL_NO"]).Append("|"); } string entryShift = UserInfo.GetUserOrder();//入库班次 string entryGroup = UserInfo.GetUserGroup();//入库班组 string reg_id = UserInfo.GetUserID();//操作人 string mdType = Common.FixDBManager.CheckNullStr(Convert.ToString(this.ComboOrdProc.Value));//操作类型 //string coilno = Common.FixDBManager.CheckNullStr(Convert.ToString(this.textBox1.Text));//操作类型 string msg = ""; string line = ""; if (this.CustomInfo == "2") line = "S"; else line = "L"; Hashtable paramHsmp = new Hashtable(); paramHsmp.Add("i1", reg_id); paramHsmp.Add("i2", entryShift); paramHsmp.Add("i3", entryGroup); paramHsmp.Add("i4", "02"); // M01002 01:取消 02:指定 paramHsmp.Add("i5", strBf.ToString()); paramHsmp.Add("i6", line); paramHsmp.Add("o7", msg); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "UIB.COM.ComDBProcedure"; ccp.MethodName = "doXmlProcedure"; ccp.ServerParams = new object[] { "UIM010290_04.CALL", paramHsmp }; ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (0 == ccp.ReturnCode) { MessageBox.Show("操作成功!"); } DoQuery(); } /// /// 次品卷指定 /// private void unsetDefectiveCoil() { /* String str = ""; for (int i = 0; i < this.ultraGrid1.Rows.Count; i++) { if (this.ultraGrid1.Rows[i].Cells["CHK"].Value.Equals("Y")) { str = str + this.ultraGrid1.Rows[i].Cells[""].Value + ","; } }*/ this.ultraGrid1.UpdateData(); StringBuilder strBf = new StringBuilder(); DataRow[] selectedRows = this.dataSet1.Tables[0].Select("CHK ='True'"); for (int i = 0; i < selectedRows.Length; i++) { strBf.Append(selectedRows[i]["COIL_NO"]).Append("|"); } string entryShift = UserInfo.GetUserOrder();//入库班次 string entryGroup = UserInfo.GetUserGroup();//入库班组 string reg_id = UserInfo.GetUserID();//操作人 string mdType = Common.FixDBManager.CheckNullStr(Convert.ToString(this.ComboOrdProc.Value));//操作类型 //string coilno = Common.FixDBManager.CheckNullStr(Convert.ToString(this.textBox1.Text));//操作类型 string msg = ""; string line = ""; if (this.CustomInfo == "2") line = "S"; else line = "L"; Hashtable paramHsmp = new Hashtable(); paramHsmp.Add("i1", reg_id); paramHsmp.Add("i2", entryShift); paramHsmp.Add("i3", entryGroup); paramHsmp.Add("i4", "01"); // M01002 01:取消 02:指定 paramHsmp.Add("i5", strBf.ToString()); paramHsmp.Add("i6", line); paramHsmp.Add("o7", msg); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "UIB.COM.ComDBProcedure"; ccp.MethodName = "doXmlProcedure"; ccp.ServerParams = new object[] { "UIM010290_04.CALL", paramHsmp }; ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (0 == ccp.ReturnCode) { MessageBox.Show("操作成功!"); } DoQuery(); } private void ultraGrid1_CellChange(object sender, Infragistics.Win.UltraWinGrid.CellEventArgs e) { } private void UIM010290_Load(object sender, EventArgs e) { init(); } private void ultraGrid1_MouseDoubleClick(object sender, Infragistics.Win.UltraWinGrid.DoubleClickRowEventArgs e) { textBox1.Text = e.Row.Cells["COIL_NO"].Value.ToString(); } private void button1_Click(object sender, EventArgs e) { int jx = 1; string mod_name = this.UserInfo.GetUserName(); DataRow[] selectedRows = dataSet1.Tables[0].Select("CHK ='True'"); for (int i = 0; i < selectedRows.Length; i++) { string coilno = Convert.ToString(Common.FixDBManager.CheckNullStr(selectedRows[i]["COIL_NO"])); string ycscczyj = Convert.ToString(Common.FixDBManager.CheckNullStr(selectedRows[i]["YCSCCZYJ"])); string ycjsczyj = Convert.ToString(Common.FixDBManager.CheckNullStr(selectedRows[i]["YCJSCZYJ"])); Hashtable ht = new Hashtable(); ht.Add("i" + jx, coilno); jx++;//卷号 ht.Add("i" + jx, ycscczyj); jx++;//生产意见 ht.Add("i" + jx, ycjsczyj); jx++;//技术意见 ht.Add("i" + jx, mod_name); jx++;//变更人 ht.Add("o" + jx, ""); jx = 1; CoreClientParam ccp1 = new CoreClientParam(); ccp1.ServerName = "UIB.COM.ComDBProcedure"; ccp1.MethodName = "doXmlProcedure"; ccp1.ServerParams = new object[] { "UIM010290_06.CALL", ht }; this.ExecuteNonQuery(ccp1, CoreInvokeType.Internal); ArrayList all = ccp1.ReturnObject as ArrayList; if (all[0].ToString() != "YY")//确认是否存在问题 { MessageBox.Show(all[0].ToString(), "提示"); return; } } MessageBox.Show("录入成功", "提示"); DoQuery(); } } }