using System; using System.Collections; using System.ComponentModel; using System.IO; using System.Diagnostics; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; using CoreFS.CA06; using Infragistics.Win.UltraWinMaskedEdit; using Infragistics.Win.UltraWinGrid; using Infragistics.Win; using Core.StlMes.Client.LgCommon; using Core.Mes.Client.Comm.Control; namespace Core.StlMes.Client.LgIntegrationQuery { public partial class frmPerformanceLog : frmStyleBase { public string _devNum = ""; public string workShopNo = ""; public frmPerformanceLog() { InitializeComponent(); } private void frmPerformanceLog_Load(object sender, EventArgs e) { workShopNo = this.CustomInfo; this.uldtBeginTime.Value = DateTime.Today.ToString("yyyy-MM-dd") + " 00:00"; this.uldtEndTime.Value = DateTime.Today.ToString("yyyy-MM-dd") + " 23:59"; this.ultraMaskedEdit2.Enabled = false; this.cmbPosition.Enabled = false; initPos(); cmbPosition.SelectedIndex = 0; QueryData(); } // 初始化岗位 /// /// 初始化岗位 /// public void initPos() { cmbPosition.Items.Clear(); cmbPosition.Items.Add("B01", "1#脱硫站"); cmbPosition.Items.Add("C01", "1#转炉"); cmbPosition.Items.Add("C02", "2#转炉"); cmbPosition.Items.Add("C03", "3#转炉"); cmbPosition.Items.Add("C04", "4#转炉"); cmbPosition.Items.Add("C05", "5#转炉"); cmbPosition.Items.Add("D01", "1#吹氩站"); cmbPosition.Items.Add("D02", "2#吹氩站"); cmbPosition.Items.Add("D03", "3#吹氩站"); cmbPosition.Items.Add("D04", "4#吹氩站"); cmbPosition.Items.Add("D05", "5#吹氩站"); cmbPosition.Items.Add("E01", "1#精炼炉"); cmbPosition.Items.Add("E02", "2#精炼炉"); cmbPosition.Items.Add("E03", "3#精炼炉"); cmbPosition.Items.Add("G01", "1#连铸机"); cmbPosition.Items.Add("G02", "2#连铸机"); cmbPosition.Items.Add("G03", "3#连铸机"); cmbPosition.Items.Add("G04", "4#连铸机"); cmbPosition.Items.Add("G05", "5#连铸机"); //if (workShopNo == "1") //{ // cmbPosition.Items.Add("A01", "1#脱硫站"); // cmbPosition.Items.Add("B01", "1#转炉"); // cmbPosition.Items.Add("B02", "2#转炉"); // cmbPosition.Items.Add("E01", "1#吹氩站"); // cmbPosition.Items.Add("E02", "2#吹氩站"); // cmbPosition.Items.Add("F01", "1#精炼炉"); // cmbPosition.Items.Add("G01", "1#连铸机"); // cmbPosition.Items.Add("G02", "2#连铸机"); //} //else //{ // cmbPosition.Items.Add("B03", "3#转炉"); // cmbPosition.Items.Add("B04", "4#转炉"); // cmbPosition.Items.Add("B05", "5#转炉"); // cmbPosition.Items.Add("E03", "3#吹氩站"); // cmbPosition.Items.Add("E04", "4#吹氩站"); // cmbPosition.Items.Add("E05", "5#吹氩站"); // cmbPosition.Items.Add("F02", "2#精炼炉"); // cmbPosition.Items.Add("F03", "3#精炼炉"); // cmbPosition.Items.Add("G03", "3#连铸机"); // cmbPosition.Items.Add("G04", "4#连铸机"); // cmbPosition.Items.Add("G05", "5#连铸机"); //} } // 根据编码获得岗位信息 /// /// 根据编码获得岗位信息 /// /// public Hashtable getPos() { Hashtable pos_table = new Hashtable(); pos_table.Clear(); pos_table.Add("B01", "1#脱硫站"); pos_table.Add("B02", "2#脱硫站"); pos_table.Add("C01", "1#转炉"); pos_table.Add("C02", "2#转炉"); pos_table.Add("C03", "3#转炉"); pos_table.Add("C04", "4#转炉"); pos_table.Add("C05", "5#转炉"); pos_table.Add("D01", "1#吹氩站"); pos_table.Add("D02", "2#吹氩站"); pos_table.Add("D03", "3#吹氩站"); pos_table.Add("D04", "4#吹氩站"); pos_table.Add("D05", "5#吹氩站"); pos_table.Add("E01", "1#精炼炉"); pos_table.Add("E02", "2#精炼炉"); pos_table.Add("E03", "3#精炼炉"); pos_table.Add("G01", "1#连铸机"); pos_table.Add("G02", "2#连铸机"); pos_table.Add("G03", "3#连铸机"); pos_table.Add("G04", "4#连铸机"); pos_table.Add("G05", "5#连铸机"); return pos_table; } public override void ToolBar_Click(object sender, string ToolbarKey) { switch (ToolbarKey) { case "Query": QueryData(); break; case "Export": try { //Core.Mes.Client.Common.Globals.ulGridToExcel(ultraGrid, Text); GridHelper.ulGridToExcel(ultraGrid, Text); } catch (Exception ex) { MessageBox.Show(ex.Message); } break; case "Exit": this.Close(); break; default: break; } } // 获取实绩修改信息 /// /// 获取实绩修改信息 /// private void QueryData() { try { string strStartTime = ""; string strEndTime = ""; string strHeatno = ""; string strStacode = ""; string strErr = ""; if (Convert.ToDateTime(uldtBeginTime.Value) > Convert.ToDateTime(uldtEndTime.Value)) { MessageBox.Show("时间条件的开始时间不能大于结束时间!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); return; } else { strStartTime = this.uldtBeginTime.DateTime.ToString("yyyyMMddHHmmss"); strEndTime = this.uldtEndTime.DateTime.ToString("yyyyMMddHHmmss"); } if (chkSmeltId.Checked == true) { if (this.ultraMaskedEdit2.Text == "") { ultraMaskedEdit2.Focus(); MessageBox.Show("熔炼号不能为空!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); return; } else { if (!string.IsNullOrEmpty(ultraMaskedEdit2.Text)) strHeatno = ultraMaskedEdit2.Text.ToString(); } } if (chkPosition.Checked) { if (this.cmbPosition.SelectedIndex<0) { cmbPosition.Focus(); MessageBox.Show("岗位不能为空!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); return; } strStacode = cmbPosition.Value.ToString(); } //获取实绩修改日志信息 string NowTime = DateTime.Now.ToString("yyyy-MM-dd"); ArrayList arry = new ArrayList(); arry.Add("frmPerformanceLog.select"); arry.Add(strHeatno); arry.Add(strStacode); arry.Add(strStartTime == "" ? NowTime : strStartTime); arry.Add(strEndTime == "" ? NowTime : strEndTime); CommonClientToServer cctos = new CommonClientToServer(); cctos.ob = this.ob; DataSet ds = cctos.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBQuery", "doSimpleQuery", arry, out strErr); dataSet.Clear(); //清空原有行 Hashtable p_table = getPos(); if (strErr == "" && ds != null) { foreach (DataRow Dr in ds.Tables[0].Rows) { DataRow dr1 = dataSet.Tables[0].NewRow(); dr1["HEATNO"] = Dr["HEATNO"].ToString(); dr1["DISPOSALTIME"] = Dr["DISPOSALTIME"].ToString(); //dr1["DESCRIPTION"] = Dr["DESCRIPTION"].ToString(); dr1["MODIFYNAME"] = Dr["MODIFYNAME"].ToString(); dr1["MODIFYDATE"] = Dr["MODIFYDATE"].ToString(); dr1["ID"] = Dr["ID"].ToString(); dr1["MODIFYCOLUMNCAPTION"] = Dr["MODIFYCOLUMNCAPTION"].ToString(); dr1["MODIFYBEFORE"] = Dr["MODIFYBEFORE"].ToString(); dr1["MODIFYAFTER"] = Dr["MODIFYAFTER"].ToString(); dr1["MODIFYCOLUMNNAME"] = Dr["MODIFYCOLUMNNAME"].ToString(); if (p_table.Contains(Dr["STATIONCODE"].ToString())) { dr1["STATIONCODE"] = p_table[Dr["STATIONCODE"].ToString()].ToString(); } else { dr1["STATIONCODE"] = Dr["STATIONCODE"].ToString(); } dataSet.Tables[0].Rows.Add(dr1); } } PublicMethod.RefreshAndAutoSize(ultraGrid); } catch (Exception e) { MessageBox.Show(e.Message); } } private void ultraMaskedEdit1_EditorButtonClick(object sender, Infragistics.Win.UltraWinEditors.EditorButtonEventArgs e) { Infragistics.Win.UltraWinEditors.UltraTextEditor ume = (Infragistics.Win.UltraWinEditors.UltraTextEditor)sender; switch (e.Button.Key) { case "edit": frmNumberWriter frm = new frmNumberWriter(); frm._strText = ume.Text.Trim(); frm.Location = GetChildWindowLocation(frm.Size); frm.ShowDialog(); ume.Text = frm._strText; ultraMaskedEdit2.SelectionStart = ultraMaskedEdit2.Text.ToString().Length; break; case "clear": if (ume.Text.Trim().Length > 0) { ume.Tag = ume.Text.Trim(); ume.Text = ""; } else { if (ume.Tag != null) ume.Text = ume.Tag.ToString(); } break; } } // 获取子窗体弹出的位置坐标 /// /// 获取子窗体弹出的位置坐标 /// private Point GetChildWindowLocation(Size ChildWindowSize) { int width = Cursor.Position.X + ChildWindowSize.Width - Screen.PrimaryScreen.Bounds.Width; int height = Cursor.Position.Y + ChildWindowSize.Height - Screen.PrimaryScreen.Bounds.Height + 30; if (width > 0) width = Cursor.Position.X - width; else width = Cursor.Position.X; if (height > 0) height = Cursor.Position.Y - height + 10; else height = Cursor.Position.Y + 10; return new Point(width, height); } private void cmbPosition_ValueChanged(object sender, EventArgs e) { switch (this.cmbPosition.SelectedIndex) //edit on 2009-04-23 { case 0: _devNum = "X00"; //调度岗位 break; case 1: _devNum = "B01"; break; case 2: _devNum = "B02"; break; case 3: _devNum = "C01"; break; case 4: _devNum = "C02"; break; case 5: _devNum = "D01"; break; case 6: _devNum = "D02"; break; case 7: _devNum = "E01"; break; case 8: _devNum = "E02"; break; case 9: _devNum = "F01"; break; case 10: _devNum = "I01"; break; case 11: _devNum = "G01"; break; case 12: _devNum = "G02"; break; case 13: _devNum = "G03"; break; default: break; } QueryData(); } private void chkSmeltId_CheckedChanged(object sender, EventArgs e) { ultraMaskedEdit2.Enabled = chkSmeltId.Checked; if (ultraMaskedEdit2.Enabled == false) { ultraMaskedEdit2.BackColor = Color.WhiteSmoke; } } private void chkPosition_CheckedChanged(object sender, EventArgs e) { cmbPosition.Enabled = chkPosition.Checked; } private void ultraMaskedEdit1_KeyPress(object sender, KeyPressEventArgs e) { if (!(Char.IsNumber(e.KeyChar) || e.KeyChar == '\b')) { e.Handled = true; } } } }