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; using Core.LZMes.Client.QCM.QCM03; using System.Diagnostics; using Infragistics.Win.UltraWinEditors; using Infragistics.Win; namespace Core.LZMes.Client.QCM { public partial class QCM030725 : FrmBase { private string judge_type = "";//用于区分1检测中心和2轧钢厂 public QCM030725() { InitializeComponent(); } public override void ToolBar_Click(object sender, string ToolbarKey) { switch (ToolbarKey) { case "Query": this.DoQuery(); break; case "Exit": this.Close(); break; case "Unlock": this.Judge(); break; case "Export": this.DoExport(); break; case "CancelFy": CancelFy(); break; } } private void CancelFy() { if (MessageBox.Show(this, "是否审批不通过?", "删除", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.No) { return; } List lists = new List(); foreach (UltraGridRow ugr in this.ultraGrid9.Rows) { if (ugr.Cells["CHECK"].Text.ToString() == "True") { ArrayList al = new ArrayList(); string apply_id = ugr.Cells["APPLY_ID"].Value.ToString(); string handle_memo = this.textBox2.Text.Trim().ToString();//审批处理备注 if (!string.IsNullOrEmpty(handle_memo)) { DoUpdate(apply_id, handle_memo); } string username = this.UserInfo.GetUserName(); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "QCM.QCM03.QCM0307.QcmRejudgeApplyServiceImpl"; ccp.MethodName = "ApplyBack"; ccp.ServerParams = new object[] {username, apply_id }; ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode == -1) { return; } lists.Add(ugr); } } for (int i = 0; i < lists.Count; i++) { lists[i].Delete(false); } MessageBox.Show("操作成功!"); } private void DoUpdate(String apply_id, String handle_memo) { try { CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "QCM.QCM03.QCM0307.QcmRejudgeApplyServiceImpl"; ccp.MethodName = "updatememo"; ccp.ServerParams = new object[] { apply_id, handle_memo }; ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); } catch (Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); MessageBox.Show("系统出错请联系管理人员", "警告"); } } private void Judge() { if (this.ultraGrid9.Selected.Rows.Count == 0) this.ultraGrid9.ActiveRow.Selected = true; List lists = new List(); if (MessageBox.Show(this, "是否对申请做审批通过操作?", "删除", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.No) { return; } foreach (UltraGridRow ugr in this.ultraGrid9.Rows) { if (ugr.Cells["CHECK"].Text.ToString() == "True") { ArrayList al = new ArrayList(); string material = ugr.Cells["MATERIAL_NO"].Value.ToString(); string lock_seq = ugr.Cells["LOCK_SEQ"].Value.ToString(); string lock_type_code = ugr.Cells["LOCK_TYPE_CODE"].Value.ToString(); string prodline = ugr.Cells["PLINE_CODE"].Value.ToString(); string unlock_type_code = "0"; string username = this.UserInfo.GetUserName(); string lock_id = ugr.Cells["LOCK_ID"].Value.ToString(); string apply_id = ugr.Cells["APPLY_ID"].Value.ToString(); string handle_memo = this.textBox2.Text.ToString();//审批处理备注 al.Add(material); al.Add(lock_seq); al.Add(lock_type_code); al.Add(unlock_type_code); al.Add(username); al.Add(lock_id); al.Add(prodline); al.Add(apply_id); al.Add(handle_memo); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "QCM.QCM03.QCM0307.QcmRejudgeApplyServiceImpl"; ccp.MethodName = "doApplyFx"; ccp.ServerParams = new object[] { al }; ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode == -1) { return; } lists.Add(ugr); } } for (int i = 0; i < lists.Count; i++) { lists[i].Delete(false); } MessageBox.Show("异常处置成功!"); } private void DoQuery() { if (this.ultraTabControl1.Tabs[0].Selected) //待判信息 { DoQueryMe(); } if (this.ultraTabControl1.Tabs[1].Selected) //判定记录 { DoQueryRe(); } } private void DoQueryMe() { try { this.dataSet1.Clear(); this.dataSet8.Clear(); string ebatchno = ""; string sbatchno = BatchNo.Text.Trim(); if (BatchNo1.Text.ToString() == "") { ebatchno = this.BatchNo.Text.Trim(); } else { ebatchno = BatchNo1.Text.Trim(); } string orderno = this.OrderNo.Text.Trim(); string psc = this.PscDesc.Text.Trim(); string prodline = this.comboBox3.Text.ToString(); string lock_type_desc = this.comboBox2.Text.ToString(); string heat_no = textBox1.Text.ToString(); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "QCM.QCM03.QCM0307.QcmRejudgeApplyServiceImpl"; if (String.IsNullOrEmpty(judge_type)) { ccp.MethodName = "getInformationHS"; ccp.ServerParams = new object[] { this.dateTimePicker1.Value.ToString("yyyyMMdd"), this.dateTimePicker2.Value.ToString("yyyyMMdd"), sbatchno, ebatchno, orderno, psc, "1", prodline, lock_type_desc, heat_no, "1" }; } else { ccp.MethodName = "getInformation2HS"; ccp.ServerParams = new object[] { this.dateTimePicker1.Value.ToString("yyyyMMdd"), this.dateTimePicker2.Value.ToString("yyyyMMdd"), sbatchno, ebatchno, orderno, psc, "1", prodline, judge_type, lock_type_desc, heat_no, "1" }; } ccp.SourceDataTable = this.dataSet1.Tables[0]; this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); } catch (Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); MessageBox.Show("系统出错,请联系管理人员", "警告"); } } private void DoQueryRe() { try { this.dataSet2.Clear(); string ebatchno = ""; string sbatchno = BatchNo.Text.Trim(); if (BatchNo1.Text.ToString() == "") { ebatchno = this.BatchNo.Text.Trim(); } else { ebatchno = BatchNo1.Text.Trim(); } string orderno = this.OrderNo.Text.Trim(); string psc = this.PscDesc.Text.Trim(); string prodline = this.comboBox3.Text.ToString(); string lock_type_desc = this.comboBox2.Text.ToString(); string heat_no = textBox1.Text.ToString(); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "QCM.QCM03.QCM0307.QcmRejudgeApplyServiceImpl"; if (String.IsNullOrEmpty(judge_type)) { ccp.MethodName = "getAbnormalRecordInfoHS"; ccp.ServerParams = new object[] { this.dateTimePicker1.Value.ToString("yyyyMMdd"), this.dateTimePicker2.Value.ToString("yyyyMMdd"), sbatchno, ebatchno, orderno, psc, "1", prodline, lock_type_desc, heat_no, "1" }; } else { ccp.MethodName = "getAbnormalRecordInfo2HS"; ccp.ServerParams = new object[] { this.dateTimePicker1.Value.ToString("yyyyMMdd"), this.dateTimePicker2.Value.ToString("yyyyMMdd"), sbatchno, ebatchno, orderno, psc, "1", prodline, judge_type, lock_type_desc, heat_no, "1" }; } ccp.SourceDataTable = this.dataSet2.Tables[0]; this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); } catch (Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); MessageBox.Show("系统出错,请联系管理人员", "警告"); } } private void label1_Click(object sender, EventArgs e) { } private void panel4_Paint(object sender, PaintEventArgs e) { } private void panel2_Paint(object sender, PaintEventArgs e) { } private void DoQueryC() { try { UltraGridRow ugr = this.ultraGrid9.ActiveRow; if (ugr == null) return; this.dataSet4.Clear(); string design_key = ugr.Cells["design_key"].Value.ToString(); string smp_no = ugr.Cells["smp_no"].Value.ToString(); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "QCM.QCM03.QCM0301.QcmJhyElementsServiceImpl"; ccp.MethodName = "GetChemeInfo"; ccp.ServerParams = new object[] { design_key, smp_no}; ccp.SourceDataTable = this.dataSet4.Tables[0]; this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); } catch (Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); MessageBox.Show("系统出错,请联系管理人员", "警告"); } } private void ultraGrid9_DoubleClickCell(object sender, DoubleClickCellEventArgs e) { UltraGridRow ugr = e.Cell.Row; string lock_id = ugr.Cells["LOCK_ID"].Value.ToString(); if (ugr.Cells["LOCK_TYPE_CODE"].Value.ToString() == "F") { QCM030705 dlg = new QCM030705(); dlg.lock_id = lock_id; dlg.ob = this.ob; dlg.ShowDialog(); } else if (ugr.Cells["LOCK_TYPE_CODE"].Value.ToString() == "D") { QCM030704 dlg = new QCM030704(); dlg.lock_id = lock_id; dlg.ob = this.ob; dlg.ShowDialog(); } else if (ugr.Cells["LOCK_TYPE_CODE"].Value.ToString() == "C") { QCM030701 dlg = new QCM030701(); dlg.lock_id = lock_id; dlg.ob = this.ob; dlg.ShowDialog(); } else if (ugr.Cells["LOCK_TYPE_CODE"].Value.ToString() == "P") { QCM030702 dlg = new QCM030702(); dlg.lock_id = lock_id; dlg.ob = this.ob; dlg.ShowDialog(); } else if (ugr.Cells["LOCK_TYPE_CODE"].Value.ToString() == "S") { QCM030716 dlg = new QCM030716(); dlg.lock_id = lock_id; dlg.ob = this.ob; dlg.ShowDialog(); } } private void button1_Click(object sender, EventArgs e) { UltraGridRow ugr = this.ultraGrid9.ActiveRow; if (ugr == null) return; string material_no = ugr.Cells["MATERIAL_NO"].Text.ToString(); string std_code = ugr.Cells["STD_CODE"].Text.ToString(); string steel_code = ugr.Cells["STEEL_CODE"].Text.ToString(); string delivery_state_code = ugr.Cells["DELIVERY_STATE_DESC"].Text.ToString(); string thick = ugr.Cells["THICK"].Text.ToString(); string PSC = ugr.Cells["PSC"].Text.ToString(); string WIDTH = ugr.Cells["WIDTH"].Text.ToString(); string LENGTH = ugr.Cells["LENGTH"].Text.ToString(); string PRODLINE = ugr.Cells["PLINE_CODE"].Text.ToString(); QCM030709 dlg = new QCM030709(); dlg.MATERIAL_NO = material_no; dlg.STD_CODE = std_code; dlg.STEELCODE = steel_code; dlg.DELIVERY_STATE_CODE = delivery_state_code; dlg.HEIGHT = thick; dlg.PSC = PSC; dlg.WIDTH = WIDTH; dlg.LENGTH = LENGTH; dlg.PROD_LINE = PRODLINE; dlg.ob = this.ob; dlg.ShowDialog(); } public static bool SetUltraComboEditor(ref UltraComboEditor cbEdt, ref ValueList vlist, bool bNull) { if (cbEdt == null || vlist == null) return false; cbEdt.Items.Clear(); if (bNull) cbEdt.Items.Add(null, ""); for (int i = 0; i < vlist.ValueListItems.Count; i++) { try { cbEdt.Items.Add(vlist.ValueListItems[i].DataValue, vlist.ValueListItems[i].DisplayText); } catch { } } return true; } public static ValueList GeneralValuelist(ref DataTable table, string strKey, string strText) { if (table == null || !table.Columns.Contains(strKey) || !table.Columns.Contains(strText)) return null; ArrayList alist = new ArrayList(); ValueList vlist = new ValueList(); for (int i = 0; i < table.Rows.Count; i++) { try { if (!alist.Contains(table.Rows[i][strKey])) { alist.Add(table.Rows[i][strKey]); vlist.ValueListItems.Add(table.Rows[i][strKey], Convert.ToString(table.Rows[i][strText])); } } catch { } } return vlist; } private void QCM0307_Load(object sender, EventArgs e) { this.comboBox3.SelectedIndex = 0; this.ultraGrid9.DisplayLayout.Override.FilterUIType = FilterUIType.HeaderIcons; this.ultraGrid2.DisplayLayout.Override.FilterUIType = FilterUIType.HeaderIcons; this.dateTimePicker1.Value = System.DateTime.Now.AddDays(-7); judge_type = String.IsNullOrEmpty(this.CustomInfo) ? "" : this.CustomInfo; CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "QCM.QCM01.QCM0106.QueryDefect"; ccp.MethodName = "QueryMemo"; ccp.ServerParams = new object[] { "JB1" }; ccp = this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); DataTable table2 = ccp.SourceDataTable; ValueList valueList2 = GeneralValuelist(ref table2, "MEMO_CODE", "MEMO"); } private void ultraGrid2_DoubleClickCell(object sender, DoubleClickCellEventArgs e) { UltraGridRow ugr = e.Cell.Row; string lock_id = ugr.Cells["LOCK_ID"].Value.ToString(); if (ugr.Cells["LOCK_TYPE_CODE"].Value.ToString() == "F") { QCM030705 dlg = new QCM030705(); dlg.lock_id = lock_id; dlg.ob = this.ob; dlg.ShowDialog(); } else if (ugr.Cells["LOCK_TYPE_CODE"].Value.ToString() == "D") { QCM030704 dlg = new QCM030704(); dlg.lock_id = lock_id; dlg.ob = this.ob; dlg.ShowDialog(); } else if (ugr.Cells["LOCK_TYPE_CODE"].Value.ToString() == "C") { QCM030701 dlg = new QCM030701(); dlg.lock_id = lock_id; dlg.ob = this.ob; dlg.ShowDialog(); } else if (ugr.Cells["LOCK_TYPE_CODE"].Value.ToString() == "P") { QCM030702 dlg = new QCM030702(); dlg.lock_id = lock_id; dlg.ob = this.ob; dlg.ShowDialog(); } else if (ugr.Cells["LOCK_TYPE_CODE"].Value.ToString() == "S") { QCM030703 dlg = new QCM030703(); dlg.lock_id = lock_id; dlg.ob = this.ob; dlg.ShowDialog(); } } private void ultraTabControl1_Click(object sender, EventArgs e) { if (this.ultraTabControl1.Tabs[1].Selected) //判定记录 { this.label9.Text = "处置时间"; } if (this.ultraTabControl1.Tabs[0].Selected) //判定记录 { this.label9.Text = "封锁时间"; } } private void DoExport() { if (this.ultraTabControl1.Tabs[0].Selected) //待判信息 { try { if (this.ultraGrid9.Rows.Count == 0) { MessageBox.Show("没有可以导出的数据", "提示"); return; } if (this.saveFileDialog1.ShowDialog(this) == DialogResult.OK) { string fName = this.saveFileDialog1.FileName; this.ultraGridExcelExporter1.Export(this.ultraGrid9, fName); Process.Start(fName); } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); } } if (this.ultraTabControl1.Tabs[1].Selected) //判定记录 { try { if (this.ultraGrid2.Rows.Count == 0) { MessageBox.Show("没有可以导出的数据", "提示"); return; } if (this.saveFileDialog1.ShowDialog(this) == DialogResult.OK) { string fName = this.saveFileDialog1.FileName; this.ultraGridExcelExporter1.Export(this.ultraGrid2, fName); Process.Start(fName); } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); } } } private void label11_Click(object sender, EventArgs e) { //获取勾选的批次 ultraGrid9.UpdateData(); DataRow[] rows = dataTable1.Copy().Select("CHECK = 'True'"); if (this.ultraGrid9.Rows.Count == 0 || rows.Length == 0) { return; } DataRow[] rows2 = rows.CopyToDataTable().Select("BATCH_NO = '" + rows[0]["BATCH_NO"].ToString() + "'"); if (rows2.Length != rows.Length) { MessageBox.Show("选择了多个批次信息!"); return; } foreach (UltraGridRow ugr in this.ultraGrid9.Rows) { if (ugr.Cells["BATCH_NO"].Text.ToString() == rows[0]["BATCH_NO"].ToString()) { ugr.Cells["CHECK"].Value = "True"; } } } private void checkBox2_CheckedChanged(object sender, EventArgs e) { foreach (UltraGridRow ugr in this.ultraGrid9.Rows.Where(p => p.IsFilteredOut == false).ToList()) { if (checkBox2.Checked) { ugr.Cells["CHECK"].Value = "True"; } else { ugr.Cells["CHECK"].Value = "False"; } } } } }