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; namespace Core.LZMes.Client.UIK { public partial class UIK010040 : FrmBase { public UIK010040() { 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() { if (this.ultraCalendarENDTIME.Enabled == false && this.ultraCalendarSTRATTIME.Enabled == false) { this.ultraCalendarENDTIME.Text = ""; this.ultraCalendarSTRATTIME.Text = ""; } try { string starttiem = this.ultraCalendarSTRATTIME.Text.ToString(); string endtime = this.ultraCalendarENDTIME.Text.ToString(); bool flag = false; CoreClientParam ccp = new CoreClientParam(); //DataTable dt = new DataTable(); if (this.ultraCheckEditor1.Checked == false && this.ultraCheckAll.Checked == false) { MessageBox.Show("请选择查询条件！"); } else { if (this.ultraCheckAll.Checked) { this.dataSet1.Tables[0].Clear(); this.ultraCheckAll.Checked = false; ccp.ServerName = "UIK.UIK01.UIK010040"; ccp.MethodName = "DoQuery"; ccp.ServerParams = new object[] { starttiem, endtime, flag }; ccp.SourceDataTable = this.dataSet1.Tables[0]; this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); DataRowCollection drc = this.dataSet1.Tables[0].Rows; if (drc.Count <= 0) { MessageBox.Show("暂无酸洗液记录！"); } this.ultraCalendarENDTIME.Enabled = false; this.ultraCalendarSTRATTIME.Enabled = false; return; } if (this.ultraCheckEditor1.Checked) { flag = true; this.dataSet1.Tables[0].Clear(); ccp.ServerName = "UIK.UIK01.UIK010040"; ccp.MethodName = "DoQuery"; ccp.ServerParams = new object[] { starttiem, endtime, flag }; ccp.SourceDataTable = this.dataSet1.Tables[0]; this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); DataRowCollection drc = this.dataSet1.Tables[0].Rows; if (drc.Count <= 0) { MessageBox.Show("暂无酸洗液记录！"); } this.ultraCheckAll.Checked = false; this.ultraCalendarENDTIME.Enabled = false; this.ultraCalendarSTRATTIME.Enabled = false; return; } } } catch (Exception Ex) { MessageBox.Show(Ex.ToString()); } } private void UIK010040_Load(object sender, EventArgs e) { this.ultraCalendarENDTIME.Enabled = false; this.ultraCalendarSTRATTIME.Enabled = false; this.ultraTextREG_DTIME.Enabled = false; this.ultraTextREG_ID.Enabled = false; } private void ultraCheckEditor1_CheckedChanged(object sender, EventArgs e) { if (this.ultraCheckEditor1.Checked) { this.ultraCalendarENDTIME.Enabled = true; this.ultraCalendarSTRATTIME.Enabled = true; this.ultraCheckAll.Checked = false; } if (!this.ultraCheckEditor1.Checked) { this.ultraCalendarENDTIME.Enabled = false; this.ultraCalendarSTRATTIME.Enabled = false; } } private void ultraCheckAll_CheckedChanged(object sender, EventArgs e) { try { if (this.ultraCheckAll.Checked) { this.ultraCheckEditor1.Checked = false; this.ultraCalendarSTRATTIME.Enabled = false; this.ultraCalendarENDTIME.Enabled = false; } } catch (Exception Ex) { MessageBox.Show(Ex.ToString()); } } private void DoUpdate() { if (MessageBox.Show("您确认要修改？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.Yes) { try { Infragistics.Win.UltraWinGrid.UltraGridRow ugr = this.ultraGrid1.ActiveRow; if (ugr.Cells["SELECT_ITEM"].Text.ToString() == "True") { string IACID_CONCENT_1, ITEMPERATURE_1, IFE_CONCENT_1, IACID_CONCENT_2, ITEMPERATURE_2, IFE_CONCENT_2, IACID_CONCENT_3, ITEMPERATURE_3, IFE_CONCENT_3, IREG_ID, IREG_DTIME, IALTER_DTIME, IREG_ACID,IREG_FE,INEW_ACID,IDIS_ACID,IDIS_FE,ISAM_TATE,ISAM_TIME,ISAM_ADDRESS,ICL; IREG_ID = this.ultraTextREG_ID.Text; IREG_DTIME = this.ultraTextREG_DTIME.Text; IACID_CONCENT_1 = this.ultraTextACID_CONCENT_1.Text; IACID_CONCENT_2 = this.ultraTextACID_CONCENT_2.Text; IACID_CONCENT_3 = this.ultraTextACID_CONCENT_3.Text; IFE_CONCENT_1 = this.ultraTextFE_CONCENT_1.Text; IFE_CONCENT_3 = this.ultraTextFE_CONCENT_3.Text; IFE_CONCENT_2 = this.ultraTextFE_CONCENT_2.Text; ITEMPERATURE_1 = this.ultraTextTEMPERATURE_1.Text; ITEMPERATURE_2 = this.ultraTextTEMPERATURE_2.Text; ITEMPERATURE_3 = this.ultraTextTEMPERATURE_3.Text; IALTER_DTIME = DateTime.Now.ToString(); IREG_ACID = this.ultraTextREG_ACID.Text; IREG_FE = this.ultraTextREG_FE.Text; INEW_ACID = this.ultraTextNEW_ACID.Text; IDIS_ACID = this.ultraTextDIS_ACID.Text; IDIS_FE = this.ultraTextDIS_FE.Text; ISAM_TATE = this.ultraCalendarSAM_TATE.Text.ToString(); ISAM_TIME = this.ultraTextSAM_TIME.Text; ISAM_ADDRESS = this.ultraTextSAM_ADDRESS.Text; ICL = this.ultraTextCL.Text; CoreClientParam ccp2 = new CoreClientParam(); ccp2.ServerName = "UIK.UIK01.UIK010040"; ccp2.MethodName = "DoUpdate"; ccp2.ServerParams = new object[] { IACID_CONCENT_1, ITEMPERATURE_1, IFE_CONCENT_1, IACID_CONCENT_2, ITEMPERATURE_2, IFE_CONCENT_2, IACID_CONCENT_3, ITEMPERATURE_3, IFE_CONCENT_3, IREG_ID, IALTER_DTIME, IREG_DTIME, IREG_ACID, IREG_FE, INEW_ACID, IDIS_ACID, IDIS_FE, ISAM_TATE, ISAM_TIME, ISAM_ADDRESS, ICL }; ccp2 = this.ExecuteNonQuery(ccp2, CoreInvokeType.Internal); if (0 != ccp2.ReturnCode) { MessageBox.Show("修改失败！"); } else { MessageBox.Show("修改成功！"); this.ultraTextREG_ID.Clear(); this.ultraTextREG_DTIME.Clear(); this.ultraTextACID_CONCENT_1.Clear(); this.ultraTextACID_CONCENT_2.Clear(); this.ultraTextACID_CONCENT_3.Clear(); this.ultraTextFE_CONCENT_1.Clear(); this.ultraTextFE_CONCENT_3.Clear(); this.ultraTextFE_CONCENT_2.Clear(); this.ultraTextTEMPERATURE_1.Clear(); this.ultraTextTEMPERATURE_2.Clear(); this.ultraTextTEMPERATURE_3.Clear(); this.ultraTextSAM_TIME.Clear(); this.ultraTextREG_ACID.Clear(); this.ultraTextREG_FE.Clear(); this.ultraTextNEW_ACID.Clear(); this.ultraTextDIS_ACID.Clear(); this.ultraTextDIS_FE.Clear(); this.ultraTextSAM_ADDRESS.Clear(); this.ultraTextCL.Clear(); } } else { MessageBox.Show("请选择修改行！"); } } catch (Exception Ex) { MessageBox.Show(Ex.ToString()); } } } private void ultraGrid1_CellChange(object sender, Infragistics.Win.UltraWinGrid.CellEventArgs e) { if (e.Cell.Column.Key == "SELECT_ITEM") { if (e.Cell.Text == "True") { string ireg_datetime; ireg_datetime = e.Cell.Row.Cells["REG_DTIME"].Text.ToString(); this.ultraTextREG_DTIME.Enabled = false; /*for循环控制单选*/ int i = this.ultraGrid1.Rows.Count; for (int j = 0; j < i; j++) { if (this.ultraGrid1.Rows[j].Cells["REG_DTIME"].Text != ireg_datetime) { this.ultraGrid1.Rows[j].Cells["SELECT_ITEM"].Value = false; } } DataTable dt = new DataTable(); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "UIK.UIK01.UIK010040"; ccp.MethodName = "DoSelect"; ccp.ServerParams = new object[] { ireg_datetime }; ccp.SourceDataTable = dt; this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); foreach (DataRow dr in dt.Rows) { this.ultraTextREG_ID.Text = dr["REG_ID"].ToString(); this.ultraTextREG_DTIME.Text = dr["REG_DTIME"].ToString(); this.ultraTextACID_CONCENT_1.Text = dr["ACID_CONCENT_1"].ToString(); this.ultraTextACID_CONCENT_2.Text = dr["ACID_CONCENT_2"].ToString(); this.ultraTextACID_CONCENT_3.Text = dr["ACID_CONCENT_3"].ToString(); this.ultraTextFE_CONCENT_1.Text = dr["FE_CONCENT_1"].ToString(); this.ultraTextFE_CONCENT_3.Text = dr["FE_CONCENT_3"].ToString(); this.ultraTextFE_CONCENT_2.Text = dr["FE_CONCENT_2"].ToString(); this.ultraTextTEMPERATURE_1.Text = dr["TEMPERATURE_1"].ToString(); this.ultraTextTEMPERATURE_2.Text = dr["TEMPERATURE_2"].ToString(); this.ultraTextTEMPERATURE_3.Text = dr["TEMPERATURE_3"].ToString(); this.ultraCalendarSAM_TATE.Text = dr["SAM_TATE"].ToString(); this.ultraTextSAM_TIME.Text = dr["SAM_TIME"].ToString(); this.ultraTextREG_ACID.Text = dr["REG_ACID"].ToString(); this.ultraTextREG_FE.Text = dr["REG_FE"].ToString(); this.ultraTextNEW_ACID.Text = dr["NEW_ACID"].ToString(); this.ultraTextDIS_ACID.Text = dr["DIS_ACID"].ToString(); this.ultraTextDIS_FE.Text = dr["DIS_FE"].ToString(); this.ultraTextSAM_ADDRESS.Text = dr["SAM_ADDRESS"].ToString(); this.ultraTextCL.Text = dr["CL_DEEP"].ToString(); } } else { this.ultraTextREG_ID.Clear(); this.ultraTextREG_DTIME.Clear(); this.ultraTextACID_CONCENT_1.Clear(); this.ultraTextACID_CONCENT_2.Clear(); this.ultraTextACID_CONCENT_3.Clear(); this.ultraTextFE_CONCENT_1.Clear(); this.ultraTextFE_CONCENT_3.Clear(); this.ultraTextFE_CONCENT_2.Clear(); this.ultraTextTEMPERATURE_1.Clear(); this.ultraTextTEMPERATURE_2.Clear(); this.ultraTextTEMPERATURE_3.Clear(); this.ultraTextSAM_TIME.Clear(); this.ultraTextREG_ACID.Clear(); this.ultraTextREG_FE.Clear(); this.ultraTextNEW_ACID.Clear(); this.ultraTextDIS_ACID.Clear(); this.ultraTextDIS_FE.Clear(); this.ultraTextSAM_ADDRESS.Clear(); this.ultraTextCL.Clear(); } } } private void DoInsert() { if (MessageBox.Show("您确认要添加信息吗？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.Yes) { string IACID_CONCENT_1, ITEMPERATURE_1, IFE_CONCENT_1, IACID_CONCENT_2, ITEMPERATURE_2, IFE_CONCENT_2, IACID_CONCENT_3, ITEMPERATURE_3, IFE_CONCENT_3, IREG_ID, IREG_DTIME, IREG_ACID,IREG_FE,INEW_ACID,IDIS_ACID,IDIS_FE,ISAM_TATE,ISAM_TIME,ISAM_ADDRESS,ICL; IREG_ID = this.UserInfo.GetUserID(); IACID_CONCENT_1 = this.ultraTextACID_CONCENT_1.Text; IACID_CONCENT_2 = this.ultraTextACID_CONCENT_2.Text; IACID_CONCENT_3 = this.ultraTextACID_CONCENT_3.Text; IFE_CONCENT_1 = this.ultraTextFE_CONCENT_1.Text; IFE_CONCENT_3 = this.ultraTextFE_CONCENT_3.Text; IFE_CONCENT_2 = this.ultraTextFE_CONCENT_2.Text; ITEMPERATURE_1 = this.ultraTextTEMPERATURE_1.Text; ITEMPERATURE_2 = this.ultraTextTEMPERATURE_2.Text; ITEMPERATURE_3 = this.ultraTextTEMPERATURE_3.Text; IREG_DTIME = DateTime.Now.ToString(); IREG_ACID = this.ultraTextREG_ACID.Text; IREG_FE = this.ultraTextREG_FE.Text; INEW_ACID = this.ultraTextNEW_ACID.Text; IDIS_ACID = this.ultraTextDIS_ACID.Text; IDIS_FE = this.ultraTextDIS_FE.Text; ISAM_TATE = this.ultraCalendarSAM_TATE.Text.ToString(); ISAM_TIME = this.ultraTextSAM_TIME.Text; ISAM_ADDRESS = this.ultraTextSAM_ADDRESS.Text; ICL = this.ultraTextCL.Text; CoreClientParam ccp2 = new CoreClientParam(); ccp2.ServerName = "UIK.UIK01.UIK010040"; ccp2.MethodName = "DoInsert"; ccp2.ServerParams = new object[] { IACID_CONCENT_1, ITEMPERATURE_1, IFE_CONCENT_1, IACID_CONCENT_2, ITEMPERATURE_2, IFE_CONCENT_2, IACID_CONCENT_3, ITEMPERATURE_3, IFE_CONCENT_3, IREG_ID, IREG_DTIME, IREG_ACID, IREG_FE, INEW_ACID, IDIS_ACID, IDIS_FE, ISAM_TATE, ISAM_TIME, ISAM_ADDRESS,ICL }; ccp2 = this.ExecuteNonQuery(ccp2, CoreInvokeType.Internal); if (0 != ccp2.ReturnCode) { MessageBox.Show("添加失败！"); } else { MessageBox.Show("添加成功！"); this.ultraTextREG_ID.Clear(); this.ultraTextREG_DTIME.Clear(); this.ultraTextACID_CONCENT_1.Clear(); this.ultraTextACID_CONCENT_2.Clear(); this.ultraTextACID_CONCENT_3.Clear(); this.ultraTextFE_CONCENT_1.Clear(); this.ultraTextFE_CONCENT_3.Clear(); this.ultraTextFE_CONCENT_2.Clear(); this.ultraTextTEMPERATURE_1.Clear(); this.ultraTextTEMPERATURE_2.Clear(); this.ultraTextTEMPERATURE_3.Clear(); this.ultraTextSAM_TIME.Clear(); this.ultraTextREG_ACID.Clear(); this.ultraTextREG_FE.Clear(); this.ultraTextNEW_ACID.Clear(); this.ultraTextDIS_ACID.Clear(); this.ultraTextDIS_FE.Clear(); this.ultraTextSAM_ADDRESS.Clear(); this.ultraTextCL.Clear(); } } } } }