using Core.Mes.Client.Comm.Control; using Core.Mes.Client.Comm.Server; using Core.Mes.Client.Comm.Tool; using Core.StlMes.Client.Judge.Commons; using Core.StlMes.Client.Judge.Forms; using CoreFS.CA06; using CoreFS.SA06; using Infragistics.Win; using Infragistics.Win.UltraWinGrid; using System; using System.Collections.Generic; using System.Data; using System.Drawing; using System.Windows.Forms; namespace Core.StlMes.Client.Judge.Controls { public partial class QcmZcColligateJudgeApplyCtrl : UserControl { private OpeBase _ob; private JudgeType _judgeType; private Dal _d; private CoreUserInfo _UserInfo; public QcmZcColligateJudgeApplyCtrl(Control container, OpeBase ob, JudgeType judgeType, CoreUserInfo UserInfo) { InitializeComponent(); this._ob = ob; _judgeType = judgeType; _UserInfo = UserInfo; container.Controls.Add(this); this.Dock = DockStyle.Fill; this.BringToFront(); _d = new Dal(ob); ClsBaseInfo.FillComBaseInfo(ultraComboEditor1, "407401", ob, false); //判定结果只显示内控合格和不合格。 40740101内控合格 40740102内控不合格 DataTable dt = (DataTable)ultraComboEditor1.DataSource; for (int i = 0; i < dt.Rows.Count; i++) { if (dt.Rows[i]["BASECODE"].ToString() != "40740101" && dt.Rows[i]["BASECODE"].ToString() != "40740102") { dt.Rows[i].Delete(); } } dt.AcceptChanges(); ClsBaseInfo.SetComboItemHeight(ultraComboEditor1); ClsBaseInfo.FillComBaseInfo(ultraComboEditor2, "407402", ob, false); ClsBaseInfo.FillComBaseInfo(ultraComboEditor3, "407407", ob, false); ClsBaseInfo.FillComBaseInfo(ultraComboEditor4, "407404", ob, false); ClsBaseInfo.FillComBaseInfo(ultraComboEditor5, "407406", ob, false); ValueList lkFlag = new ValueList(); lkFlag.ValueListItems.Add("0", "正常"); lkFlag.ValueListItems.Add("1", "利库"); lkFlag.ValueListItems.Add("2", "利库"); lkFlag.ValueListItems.Add("3", "销售成品利库"); lkFlag.ValueListItems.Add("6", "接箍转成品"); ultraGrid1.DisplayLayout.Bands[0].Columns["lkFlag"].ValueList = lkFlag; ValueList detectList = new ValueList(); detectList.ValueListItems.Add("0", "否"); detectList.ValueListItems.Add("1", "是"); ultraGrid1.DisplayLayout.Bands[0].Columns["ifOutDetect"].ValueList = detectList; ValueList coatList = new ValueList(); coatList.ValueListItems.Add("0", "否"); coatList.ValueListItems.Add("1", "镀铜"); coatList.ValueListItems.Add("2", "磷化"); ultraGrid1.DisplayLayout.Bands[0].Columns["ifOutCoat"].ValueList = coatList; ValueList impressList = new ValueList(); impressList.ValueListItems.Add("0", "否"); impressList.ValueListItems.Add("1", "是"); ultraGrid1.DisplayLayout.Bands[0].Columns["ifOutImpress"].ValueList = impressList; ValueList blastList = new ValueList(); blastList.ValueListItems.Add("0", "否"); blastList.ValueListItems.Add("1", "是"); ultraGrid1.DisplayLayout.Bands[0].Columns["ifOutBlast"].ValueList = blastList; ClsBaseInfo.FillComBaseInfo(ultraComboEditor6, "4100", ob, false); } public void QueryZcColligate(string lotNo, string judgeStoveNo, string[] judgeStates, string judgeTimeB, string judgeTimeE, string[] plines, string orderMngNo, string timeType, string judgeCondition, string[] judgeType) { string orderNo = ""; string orderSeq = ""; string[] mngOrderNos = orderMngNo.Split('/'); if (mngOrderNos.Length >= 2) { orderNo = mngOrderNos[0]; orderSeq = mngOrderNos[1]; } else if (mngOrderNos.Length >= 1) { orderNo = mngOrderNos[0]; } DataTable dt = _d.GetTableByXmlId("QcmZgJugdeApplyDAL.QueryZcColligate", lotNo, judgeStoveNo, judgeStates.Length, judgeStates, judgeTimeB, judgeTimeE, plines.Length, plines, orderNo, orderSeq, timeType, judgeCondition, judgeType); GridHelper.CopyDataToDatatable(dt, dataTable1, true); GridHelper.RefreshAndAutoSizeExceptColumns(ultraGrid1, "memo", "judgeMemo"); foreach (UltraGridRow row in ultraGrid1.Rows) { row.Cells["deliveryStateName"].Activation = Activation.ActivateOnly; } } public void Clear() { dataTable1.Clear(); } private void ultraTextEditor2_EditorButtonClick(object sender, Infragistics.Win.UltraWinEditors.EditorButtonEventArgs e) { PopupTextBox popupText = new PopupTextBox(ultraGrid1.ActiveCell.Value.ToString(), 2000); if (popupText.ShowDialog() == System.Windows.Forms.DialogResult.OK) { ultraGrid1.ActiveCell.Value = popupText.TextInfo.Trim(); ultraGrid1.ActiveRow.Update(); } } private void ultraGrid1_CellChange(object sender, Infragistics.Win.UltraWinGrid.CellEventArgs e) { String oldDeliveryState = ultraGrid1.ActiveCell.Value.ToString(); e.Cell.Row.Update(); if (e.Cell.Row.Cells["Chk"].Value.ToString().ToUpper() == "TRUE") { e.Cell.Row.Cells["deliveryStateName"].Activation = Activation.AllowEdit; } else { e.Cell.Row.Cells["deliveryStateName"].Activation = Activation.ActivateOnly; } if (e.Cell.Column.Key == "deliveryStateName") { updateDeliveryStateName(oldDeliveryState); } //if (e.Cell.Column.Key == "Chk") //{ // UltraGridRow chkRow = e.Cell.Row; // foreach (UltraGridRow row in ultraGrid1.Rows) // { // if (row.Cells["Chk"].Value.ToString() == "True" && row != chkRow) // { // row.Cells["Chk"].Value = "False"; // row.Update(); // } // } //} } private void updateDeliveryStateName(String oldDeliveryState) { ultraGrid1.ActiveCell.Value.ToString(); var row = ultraGrid1.ActiveRow; string judgeStoveNo = row.Cells["judgeStoveNo"].Value.ToString(); string batchNo = row.Cells["batchNo"].Value.ToString(); string process = row.GetValue("processCode"); String[] parm = new String[] { judgeStoveNo, batchNo, process, ultraGrid1.ActiveCell.Value.ToString(), oldDeliveryState, _judgeType.ToString(), _UserInfo.GetUserName(), "id", "5" }; ServerHelper.SetData("com.steering.pss.judge.Bll.BllZcColligateJudge.updateDeliveryStateZG", new object[] { parm }, _ob); ultraGrid1.ActiveRow.Update(); } private void ultraTextEditor1_EditorButtonClick(object sender, Infragistics.Win.UltraWinEditors.EditorButtonEventArgs e) { try { this.Cursor = Cursors.WaitCursor; var row = ultraGrid1.ActiveRow; if (row == null) { MessageUtil.ShowWarning("请选择一行记录!"); return; } string judgeApplyCode = row.Cells["jugdeApplyCode"].Value.ToString(); string judgeStoveNo = row.Cells["judgeStoveNo"].Value.ToString(); string batchNo = row.Cells["batchNo"].Value.ToString(); string process = row.GetValue("processCode"); DataRow drPassApply = _d.GetRowByXmlId("JdgQcmZcPassApplyDAL.queryByBatchNo", judgeApplyCode, judgeStoveNo, batchNo, process); if (drPassApply == null || drPassApply["type"].ToString() == "1" || drPassApply["type"].ToString() == "0" && drPassApply["auditResult"].ToString() == "") { MessageUtil.ShowWarning("没有不合格品评审单可查看!"); return; } else { if (drPassApply["type"].ToString() == "1") { MessageUtil.ShowWarning("紧急放行!"); return; } } string strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepZGRejectDisposalListZc.cpt" + "&JUDGE_STOVE_NO=" + judgeStoveNo + "&BATCH_NO=" + batchNo + "&JUGDE_APPLY_CODE=" + judgeApplyCode + "&PROCESS_CODE=" + process; FrmOrderRepExcel fBug = new FrmOrderRepExcel(_ob, strurl); fBug.AutoSize = true; fBug.MaximumSize = new Size(Screen.PrimaryScreen.WorkingArea.Width, Screen.PrimaryScreen.WorkingArea.Height); fBug.WindowState = FormWindowState.Maximized; fBug.Text = "不合格品评审处置单"; fBug.Show(); } finally { this.Cursor = Cursors.Default; } } private void ultraGrid1_InitializeRow(object sender, Infragistics.Win.UltraWinGrid.InitializeRowEventArgs e) { Color red = Color.FromArgb(255, 106, 106); if (e.Row.GetValue("resultCode") == "40740704") { e.Row.Cells["resultName"].Appearance.BackColor = red; } } private void ultraTextEditor3_EditorButtonClick(object sender, Infragistics.Win.UltraWinEditors.EditorButtonEventArgs e) { if (e.Button.Key.Equals("bj")) { //if (!"admin".Equals(_UserInfo.GetUserName()) && !"屈松山".Equals(_UserInfo.GetUserName())) //{ // throw new Exception("您没有该权限!"); //} PopupTextBox popupText = new PopupTextBox(ultraGrid1.ActiveCell.Value.ToString(), 40); if (popupText.ShowDialog() == System.Windows.Forms.DialogResult.OK) { var row = ultraGrid1.ActiveRow; string judgeStoveNo = row.Cells["judgeStoveNo"].Value.ToString(); string batchNo = row.Cells["batchNo"].Value.ToString(); string process = row.GetValue("processCode"); String[] parm = new String[] { judgeStoveNo, batchNo, process, popupText.TextInfo.Trim(), ultraGrid1.ActiveCell.Value.ToString(), _judgeType.ToString(), _UserInfo.GetUserName(), "id" ,"2"}; ServerHelper.SetData("com.steering.pss.judge.Bll.BllZcColligateJudge.updateLotNo", new object[] { parm }, _ob); ultraGrid1.ActiveCell.Value = popupText.TextInfo.Trim(); ultraGrid1.ActiveRow.Update(); } return; } LotNoGroupInfoQueryFrm frm = new LotNoGroupInfoQueryFrm(ultraGrid1.GetActiveRowValue("lotNo"), _d.Ob); frm.ShowDialog(); } private void ultraTextEditor4_EditorButtonClick(object sender, Infragistics.Win.UltraWinEditors.EditorButtonEventArgs e) { //if (!"admin".Equals(_UserInfo.GetUserName()) && !"屈松山".Equals(_UserInfo.GetUserName())) //{ // throw new Exception("您没有该权限!"); //} PopupTextBox popupText = new PopupTextBox(ultraGrid1.ActiveCell.Value.ToString(), 40); if (popupText.ShowDialog() == System.Windows.Forms.DialogResult.OK) { var row = ultraGrid1.ActiveRow; string judgeStoveNo = row.Cells["judgeStoveNo"].Value.ToString(); string batchNo = row.Cells["batchNo"].Value.ToString(); string process = row.GetValue("processCode"); String[] parm = new String[] { judgeStoveNo, batchNo, process,popupText.TextInfo.Trim(), ultraGrid1.ActiveCell.Value.ToString(), _judgeType.ToString(), _UserInfo.GetUserName(),"id","1" }; ServerHelper.SetData("com.steering.pss.judge.Bll.BllZcColligateJudge.updateLotNo", new object[] { parm }, _ob); ultraGrid1.ActiveCell.Value = popupText.TextInfo.Trim(); ultraGrid1.ActiveRow.Update(); } } private void ultraComboEditor6_ValueChanged(object sender, EventArgs e) { ultraGrid1.ActiveCell.Value.ToString(); } } }