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.Mes.Client.Common; namespace Core.LgMes.Client.LgIntegrationQuery { public partial class frmPerformanceLog : Core.Mes.Client.Common.frmStyleBase { public frmPerformanceLog() { InitializeComponent(); } public string _devNum = ""; private void frmPerformanceLog_Load(object sender, EventArgs e) { this.uldtBeginTime.Value = DateTime.Today.ToString("yyyy-MM-dd") + " 00:00"; this.uldtEndTime.Value = DateTime.Today.ToString("yyyy-MM-dd") + " 23:59"; this.ultraMaskedEdit1.Enabled = false; this.cmbPosition.Enabled = false; chkTime.Checked = true; //初始化UltraDropDown控件 //InitUltraDropDown(); cmbPosition.SelectedIndex = 0; QueryData(); } private void ckbTime_CheckedChanged(object sender, EventArgs e) { uldtBeginTime.Enabled = chkTime.Checked; uldtEndTime.Enabled = chkTime.Checked; } private void chkSmeltId_CheckedChanged(object sender, EventArgs e) { ultraMaskedEdit1.Enabled = chkSmeltId.Checked; } private void chkPosition_CheckedChanged(object sender, EventArgs e) { cmbPosition.Enabled = chkPosition.Checked; } public override void ToolBar_Click(object sender, string ToolbarKey) { switch (ToolbarKey) { case "Query": QueryData(); break; case "Export": if (ultraGrid.Rows.Count > 0) { ExportExcel(); } else MessageBox.Show("没有实绩修改信息。", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); break; case "Exit": this.Close(); break; default: break; } } /// /// 获取渣样信息 /// private void QueryData() { string strStartTime = ""; string strEndTime = ""; string strHeatno = ""; string strStacode = ""; string strErr = ""; if (chkTime.Checked == true) { if (Convert.ToDateTime(uldtBeginTime.Value) > Convert.ToDateTime(uldtEndTime.Value)) { MessageBox.Show("时间条件的开始时间不能大于结束时间!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); return; } else { strStartTime = this.uldtBeginTime.DateTime.ToString("yyyy-MM-dd"); strEndTime = this.uldtEndTime.DateTime.ToString("yyyy-MM-dd"); } } if (chkSmeltId.Checked == true) { if (this.ultraMaskedEdit1.Text == "") { MessageBox.Show("熔炼号不能为空!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); return; } else { if (!string.IsNullOrEmpty(ultraMaskedEdit1.Text)) strHeatno = ultraMaskedEdit1.Text.ToString(); } } //if (chkPosition.Checked == true) //{ // 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(_devNum); 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(); //清空原有行 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(); dataSet.Tables[0].Rows.Add(dr1); } } } private void ultraMaskedEdit1_EditorButtonClick(object sender, Infragistics.Win.UltraWinEditors.EditorButtonEventArgs e) { UltraMaskedEdit ume = (UltraMaskedEdit)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; 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); } /// /// 导出Excel /// private void ExportExcel() { try { string StrfileName = System.Windows.Forms.Application.StartupPath + "\\Report\\实绩修改日志.xls"; this.ultraGridExcelExporter1.Export(this.ultraGrid, StrfileName); ProcessStartInfo p = new ProcessStartInfo(StrfileName); p.WindowStyle = System.Diagnostics.ProcessWindowStyle.Maximized; p.WorkingDirectory = Path.GetDirectoryName(StrfileName); Process.Start(p); } catch (Exception ex) { MessageBox.Show(ex.Message); } } /// /// 初始化UltraDropDown控件(岗位) /// private void InitUltraDropDown() { string strErr = ""; ArrayList arry = new ArrayList(); arry.Add("FrmYCJJB_Process.select"); CommonClientToServer cctos = new CommonClientToServer(); cctos.ob = this.ob; DataSet ds = cctos.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBQuery", "doSimpleQuery", arry, out strErr); if (strErr == "" && ds != null) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { cmbPosition.Items.Add(i); cmbPosition.Items[i].DisplayText = ds.Tables[0].Rows[i]["DESCRIPTION"].ToString(); cmbPosition.Items[i].DataValue = ds.Tables[0].Rows[i]["NAME_"].ToString(); } } } 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(); } } }