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 System.Collections; using Infragistics.Win.UltraWinGrid; namespace Core.LZMes.Client.UIK { public partial class UIK050101 : FrmBase { public UIK050101() { InitializeComponent(); } public override void ToolBar_Click(object sender, string ToolbarKey) { switch (ToolbarKey) { case "Query"://查询 this.DoQuery(); break; case "Insert"://添加换下轧辊实绩 this.DoInsert(); break; case "Update"://下发换下轧辊实绩 this.DoUpdate(); break; } } private void DoQuery() { try { string zgNum = ""; string beginTime = ""; string endTime = ""; bool flag = false; CoreClientParam ccp = new CoreClientParam(); CoreClientParam ccp2 = new CoreClientParam(); DataTable dt = new DataTable(); DataTable dt2 = new DataTable(); if (this.ultraCheckEditor1.Checked) { //this.ultraTextzgNum.Clear(); //this.ultraCheckEditor1.Checked = false; //ccp.ServerName = "UIK.UIK05.UIK050030"; //ccp.MethodName = "DoQueryShang"; //ccp.ServerParams = new object[] { zgNum, flag ,beginTime,endTime}; //ccp.SourceDataTable = dt; //this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); //this.ultraGrid1.DataSource = dt; //CoreClientParam ccp = new CoreClientParam(); //ccp.ServerName = "UIM.UIM010040"; //ccp.MethodName = "queryCoilStatus"; //ccp.ServerParams = new object[] { coilNo }; //ccp.SourceDataTable = this.dataSet1.Tables[0]; //this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); //if (dt.Rows.Count <= 0) //{ // MessageBox.Show("暂无记录！"); //} //return; } else { zgNum = this.ultraTextzgNum.Text; beginTime = ultraDateTimeEditor1.Value != null ? ultraDateTimeEditor1.DateTime.ToString("yyyyMMdd") : ""; endTime = ultraDateTimeEditor2.Value != null ? ultraDateTimeEditor2.DateTime.ToString("yyyyMMdd") : ""; this.dataSet1.Clear(); // this.ultraTextzgNum.Clear(); // this.ultraCheckEditor1.Checked = false; ccp.ServerName = "UIK.UIK05.UIK050101"; ccp.MethodName = "DoQuery"; ccp.ServerParams = new object[] { zgNum, beginTime, endTime, beginTime, endTime }; ccp.SourceDataTable = this.dataSet1.Tables[0]; this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); } } // } catch (Exception Ex) { MessageBox.Show(Ex.ToString()); } } private void ultraCheckEditor1_CheckedChanged(object sender, EventArgs e) { try { if (this.ultraCheckEditor1.Checked) { this.ultraTextzgNum.Enabled = false; } if (!this.ultraCheckEditor1.Checked) { this.ultraTextzgNum.Enabled = true; } } catch (Exception Ex) { MessageBox.Show(Ex.ToString()); } } private void DoInsert() { try { if (this.ultraTextStand_id.Text == "") { MessageBox.Show("轧辊编号必须填写！"); } else { // string spec_No = this.ultraTextSpec_no.Text; string roll_num = this.ultraTextStand_id.Text; //轧辊编号 string daima = this.ultraTextEditor3.Text;// string cucaodu = this.ultraTextEditor6.Text; //轧辊区域 string kaishizhijing = this.ultraTextShangID.Text;//上编号 string jieshuzhijing = this.ultraTextXiaBian.Text;//下编号 string ruandian = this.ultraTextEditor2.Text;//时间 string moxueliang = this.ultraTextEditor4.Text;//原因 ------ string chuangbianhao = this.ultraTextEditor5.Text;//轧制长度 string yingdu = this.ultraTextEditor1.Text;//轧制量 string kaishi = this.ultraCalendarDis_time.Value != null ? ultraDateTimeEditor1.DateTime.ToString("yyyyMMdd") : ""; //this.ultraCalendarDis_time.Text.ToString(); string jieshu = this.dateTimePicker1.Value != null ? ultraDateTimeEditor1.DateTime.ToString("yyyyMMdd") : ""; //this.dateTimePicker1.Text.ToString(); string gunxing=this.ultraTextEditor9.Text; string yuandu=this.ultraTextEditor7.Text; string liewen = this.ultraTextEditor8.Text; System.DateTime dtt = System.DateTime.Now; string spec_No = (string.Format("{0:yyyyMMddHHmmss}", dtt)).Substring(8,6); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "UIK.UIK05.UIK050101"; ccp.MethodName = "PlanAdd"; ccp.ServerParams = new object[] { roll_num, daima, cucaodu, kaishizhijing, jieshuzhijing, ruandian, moxueliang, chuangbianhao, yingdu, kaishi, jieshu ,gunxing,yuandu,liewen}; ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); //if (0 != ccp.ReturnCode) return; if (0 != ccp.ReturnCode) { MessageBox.Show("添加失败"); } else { MessageBox.Show("添加成功"); this.ultraTextStand_id.Clear(); //this.ultraComboType.Clear(); // this.ultraComboArea.Clear(); this.ultraTextShangID.Clear(); this.ultraTextXiaBian.Clear(); //this.ultraComboEditor1.Clear(); this.ultraTextEditor2.Clear(); this.ultraTextEditor1.Clear(); } // } } } catch (Exception Ex) { MessageBox.Show(Ex.ToString()); } } private void ultraGrid1_DoubleClickRow(object sender, DoubleClickRowEventArgs e) { Infragistics.Win.UltraWinGrid.UltraGrid uGrid = (Infragistics.Win.UltraWinGrid.UltraGrid)sender; ultraTextStand_id.Text = uGrid.ActiveRow.Cells["ROLL_NUMBER"].Text; ultraTextEditor3.Text = uGrid.ActiveRow.Cells["PROGRAM_NUMBE"].Text;//磨削程序代码 ultraTextEditor6.Text = uGrid.ActiveRow.Cells["ROUGHNESS"].Text;//粗糙度 ultraTextShangID.Text = uGrid.ActiveRow.Cells["ROLL_DIAMETER_MD_BEFORE"].Text;//磨前直径 ultraTextEditor2.Text = uGrid.ActiveRow.Cells["BRUISEMAX"].Text;//软点 ultraTextEditor4.Text = uGrid.ActiveRow.Cells["GRIND_AMOUNT"].Text;//磨削量 ultraTextEditor5.Text = uGrid.ActiveRow.Cells["STATION_NO"].Text;//辊床编号 ultraTextXiaBian.Text = uGrid.ActiveRow.Cells["ROLL_DIAMETER_MD_AFTER"].Text;//磨后直径 ultraTextEditor1.Text = uGrid.ActiveRow.Cells["HARDNESS_MD"].Text;//硬度 //ultraCalendarDis_time.Text = uGrid.ActiveRow.Cells["GRIND_START_TIME"].Text;//磨前直径 //dateTimePicker1.Text = uGrid.ActiveRow.Cells["GRIND_END_TIME"].Text;//软点 ultraTextEditor9.Text = uGrid.ActiveRow.Cells["ROLL_TYPE"].Text;//辊型 ultraTextEditor7.Text = uGrid.ActiveRow.Cells["ROLL_ROUNDNESS"].Text;//圆度 ultraTextEditor8.Text = uGrid.ActiveRow.Cells["CRACKMAX"].Text;//裂纹 } private void DoUpdate() { try { ArrayList al = new ArrayList(); ArrayList list = new ArrayList(); list.Add("UIK050101_01.UPDATE"); string roll_num = this.ultraTextStand_id.Text; //轧辊编号 string daima = this.ultraTextEditor3.Text;// string cucaodu = this.ultraTextEditor6.Text; //轧辊区域 string kaishizhijing = this.ultraTextShangID.Text;//上编号 string jieshuzhijing = this.ultraTextXiaBian.Text;//下编号 string ruandian = this.ultraTextEditor2.Text;//软点 string moxueliang = this.ultraTextEditor4.Text;//原因 ------ string chuangbianhao = this.ultraTextEditor5.Text;//轧制长度 string yingdu = this.ultraTextEditor1.Text;//轧制量 // string kaishi = this.ultraCalendarDis_time.Value != null ? ultraDateTimeEditor1.DateTime.ToString("yyyyMMdd") : ""; //this.ultraCalendarDis_time.Text.ToString(); // string jieshu = this.dateTimePicker1.Value != null ? ultraDateTimeEditor1.DateTime.ToString("yyyyMMdd") : ""; //this.dateTimePicker1.Text.ToString(); string gunxing = this.ultraTextEditor9.Text; string yuandu = this.ultraTextEditor7.Text; string liewen = this.ultraTextEditor8.Text; string beginTime = ultraDateTimeEditor1.Value != null ? ultraDateTimeEditor1.DateTime.ToString("yyyyMMdd") : ""; string endTime = ultraDateTimeEditor2.Value != null ? ultraDateTimeEditor2.DateTime.ToString("yyyyMMdd") : ""; // list.Add(daima); list.Add(cucaodu); list.Add(kaishizhijing); list.Add(ruandian); list.Add(moxueliang); list.Add(chuangbianhao); list.Add(jieshuzhijing); list.Add(yingdu); list.Add(gunxing); list.Add(yuandu); list.Add(liewen); list.Add(roll_num); list.Add(beginTime); list.Add(endTime); al.Add(list); if (al.Count == 0) { MessageBox.Show("请勾选数据再做保存操作！", "提示"); return; } CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "UIB.COM.ComDBSave"; ccp.MethodName = "doXmlSave"; ccp.ServerParams = new object[] { al }; ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); this.DoQuery(); //CoreClientParam ccp2 = new CoreClientParam(); //ccp2.ServerName = "UIK.UIK05.UIK050030"; //ccp2.MethodName = "DoUpdate"; ////ccp2.ServerParams = new object[] { spec_No, sand_Id, roll_Type, roll_Area, roll_Id_up, roll_Id_lo, z_time, reason, banci, banbie, s_chang, s_liang, s_shi, x_chang, x_liang, x_shi, create_time, uid }; //ccp2.ServerParams = new object[] { reason, zhazhiliang, zhazhicd, timexg, number, iddown, idup, namerg }; //ccp2 = this.ExecuteNonQuery(ccp2, CoreInvokeType.Internal); if (0 != ccp.ReturnCode) { MessageBox.Show("保存失败！"); } else { MessageBox.Show("保存成功！"); } } catch (Exception Ex) { MessageBox.Show(Ex.ToString()); } } private void UIK050101_Load(object sender, EventArgs e) { } } }