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.UIE { public partial class UIE041050 : FrmBase { public UIE041050() { InitializeComponent(); } public override void ToolBar_Click(object sender, string ToolbarKey) { switch (ToolbarKey) { case "Query": this.DoQuery(); break; } } public string Condition { set { string[] array = value.Trim().Split(new char[]{'|'}); if (array.Length < 2) return; this.textOrdNO.Text = array[0]; this.comboOrdSeq.Value = array[1]; this.DoQuery(); } } public void getOrdSeq() { try { string ordNO = this.textOrdNO.Text; DataTable dt = new DataTable(); ArrayList paramArray = new ArrayList(); paramArray.Add("UIECOMM00_SELECT.ORD_SEQ"); paramArray.Add(ordNO); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "UIB.COM.ComDBQuery"; ccp.MethodName = "doSimpleQuery"; ccp.ServerParams = new object[] { paramArray }; ccp.SourceDataTable = dt; this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); Core.LZMes.Client.UIE.UIE041.UIEBase.Init_ComboControl(this.comboOrdSeq, ref dt, "ORD_SEQ"); } catch (Exception EX) { MessageBox.Show(EX.ToString()); } } private void DoQuery() { System.Collections.ArrayList arrayParam = new System.Collections.ArrayList(); //合同号 string ordNO = Convert.ToString(Common.FixDBManager.CheckNullStr(this.textOrdNO.Text)); arrayParam.Add(ordNO); //订单号 string ordSeq = Convert.ToString(Common.FixDBManager.CheckNullStr(this.comboOrdSeq.Value)); arrayParam.Add(ordSeq); if (ordNO == "" || ordSeq == "") { System.Windows.Forms.MessageBox.Show("订单号或则订单序号不能为空!"); return; } try { CoreClientParam ccp = new CoreClientParam(); DataTable dttb = new DataTable(); //ccp.ServerName = "UIE.UIE01.UIE042020"; //ccp.MethodName = "query01"; //ccp.ServerParams = arrayParam.ToArray(); //ccp.SourceDataTable = dttb; //this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); ccp.ServerName = "UIB.COM.ComDBQuery"; ccp.MethodName = "doSimpleQuery"; ArrayList paramArray = new ArrayList(); paramArray.Add("UIE041050.OrdPrc.Select"); paramArray.Add(ordNO); paramArray.Add(ordSeq); ccp.ServerParams = new object[] { paramArray }; ccp.SourceDataTable = dttb; this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); string ORD_PROG_CD = Convert.ToString(Common.FixDBManager.CheckNullStr(dttb.Rows[0]["ORD_PROG_CD"])); string PRODNM_CD = Convert.ToString(Common.FixDBManager.CheckNullStr(dttb.Rows[0]["PRODNM_CD"])); string CUST_CD = Convert.ToString(Common.FixDBManager.CheckNullStr(dttb.Rows[0]["CUST_CD"])); string RCVORD_CLF = Convert.ToString(Common.FixDBManager.CheckNullStr(dttb.Rows[0]["RCVORD_CLF"])); string DEL_TO_DATE = Convert.ToString(Common.FixDBManager.CheckNullStr(dttb.Rows[0]["DEL_TO_DATE"])); string ABNOR_ORD_CD = Convert.ToString(Common.FixDBManager.CheckNullStr(dttb.Rows[0]["ABNOR_ORD_CD"])); string SMS_DUE_DATE = Convert.ToString(Common.FixDBManager.CheckNullStr(dttb.Rows[0]["SMS_DUE_DATE"])); string MILL_DUE_DATE = Convert.ToString(Common.FixDBManager.CheckNullStr(dttb.Rows[0]["MILL_DUE_DATE"])); string PLTCM_DUE_DATE = Convert.ToString(Common.FixDBManager.CheckNullStr(dttb.Rows[0]["PLTCM_DUE_DATE"])); string CAL_DUE_DATE = Convert.ToString(Common.FixDBManager.CheckNullStr(dttb.Rows[0]["CAL_DUE_DATE"])); string PROD_HOLD_CD = Convert.ToString(Common.FixDBManager.CheckNullStr(dttb.Rows[0]["PROD_HOLD_CD"])); string PROD_HOLD_DTIME = Convert.ToString(Common.FixDBManager.CheckNullStr(dttb.Rows[0]["PROD_HOLD_DTIME"])); string PROD_END_GP = Convert.ToString(Common.FixDBManager.CheckNullStr(dttb.Rows[0]["PROD_END_GP"])); string PROD_END_DATE = Convert.ToString(Common.FixDBManager.CheckNullStr(dttb.Rows[0]["PROD_END_DATE"])); string SHIP_END_DATE = Convert.ToString(Common.FixDBManager.CheckNullStr(dttb.Rows[0]["SHIP_END_DATE"])); string ORD_WGT = Convert.ToString(Common.FixDBManager.CheckNullStr(dttb.Rows[0]["ORD_WGT"])); string DESIGN_SLAB_WGT = Convert.ToString(Common.FixDBManager.CheckNullStr(dttb.Rows[0]["DESIGN_SLAB_WGT"])); string ORD_PRC_WGT = Convert.ToString(Common.FixDBManager.CheckNullStr(dttb.Rows[0]["ORD_PRC_WGT"])); string ORD_REM_WGT = Convert.ToString(Common.FixDBManager.CheckNullStr(dttb.Rows[0]["ORD_REM_WGT"])); string PROD_END_WGT = Convert.ToString(Common.FixDBManager.CheckNullStr(dttb.Rows[0]["PROD_END_WGT"])); string SHIP_END_WGT = Convert.ToString(Common.FixDBManager.CheckNullStr(dttb.Rows[0]["SHIP_END_WGT"])); this.text_ORD_PROG_CD.Text = ORD_PROG_CD; this.text_PRODNM_CD.Text = PRODNM_CD; this.text_CUST_CD.Text = CUST_CD; this.text_RCVORD_CLF.Text = RCVORD_CLF; this.text_DEL_TO_DATE.Text = DEL_TO_DATE; this.text_ABNOR_ORD_CD.Text = ABNOR_ORD_CD; this.text_SMS_DUE_DATE.Text = SMS_DUE_DATE; this.text_MILL_DUE_DATE.Text = MILL_DUE_DATE; this.text_PLTCM_DUE_DATE.Text = PLTCM_DUE_DATE; this.text_CAL_DUE_DATE.Text = CAL_DUE_DATE; this.text_PROD_HOLD_CD.Text = PROD_HOLD_CD; this.text_PROD_HOLD_DTIME.Text = PROD_HOLD_DTIME; this.text_PROD_END_GP.Text = PROD_END_GP; this.text_PROD_END_DATE.Text = PROD_END_DATE; this.text_SHIP_END_DATE.Text = SHIP_END_DATE; this.text_ORD_WGT.Text = ORD_WGT; this.text_ORD_PRC_WGT.Text = ORD_PRC_WGT; this.text_ORD_REM_WGT.Text = ORD_REM_WGT; this.text_PROD_END_WGT.Text = PROD_END_WGT; this.text_SHIP_END_WGT.Text = SHIP_END_WGT; this.dataSet1.Tables[0].Clear(); ccp = new CoreClientParam(); ccp.ServerName = "UIB.COM.ComDBQuery"; ccp.MethodName = "doSimpleQuery"; paramArray = new ArrayList(); paramArray.Add("UIE041050.OrdPrcDet.Select"); paramArray.Add(ordNO); paramArray.Add(ordSeq); ccp.ServerParams = new object[] { paramArray }; ccp.SourceDataTable = this.dataSet1.Tables[0]; this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); } catch (Exception EX) { MessageBox.Show(EX.ToString()); } } //订单整理 private void ultraButton5_Click(object sender, EventArgs e) { string ordNO = Convert.ToString(Common.FixDBManager.CheckNullStr(this.textOrdNO.Text)); string ordSeq = Convert.ToString(Common.FixDBManager.CheckNullStr(this.comboOrdSeq.Value)); string regID = this.UserInfo.GetUserID(); string pgmID = "UIE041050"; Hashtable paramHsmp = new Hashtable(); paramHsmp.Add("i1", ordNO); paramHsmp.Add("i2", ordSeq); paramHsmp.Add("i3", pgmID); paramHsmp.Add("i4", regID); if (ordNO == "" || ordSeq == "") { System.Windows.Forms.MessageBox.Show("订单号或则订单序号不能为空!"); return; } try { CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "UIB.COM.ComDBProcedure"; ccp.MethodName = "doXmlProcedure"; ccp.ServerParams = new Object[] { "UIE041050_OSREARRANGE.call", paramHsmp }; this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); System.Diagnostics.Debug.WriteLine(this.dataSet1.Tables[0]); this.DoQuery(); } catch (Exception EX) { MessageBox.Show(EX.ToString()); } } private void textOrdNO_Leave(object sender, EventArgs e) { getOrdSeq(); } #region /// /// 点击进程量,弹出物料详细信息界面,获取详细的物料进程信息 /// /// 控件 /// private void ultraGrid1_AfterCellActivate(object sender, EventArgs e) { Infragistics.Win.UltraWinGrid.UltraGrid tt = (Infragistics.Win.UltraWinGrid.UltraGrid)sender; string procCD = Convert.ToString(Common.FixDBManager.CheckNullStr(tt.ActiveRow.Cells["PROC_CD"].Value)); string procWgt = Convert.ToString(Common.FixDBManager.CheckNullStr(tt.ActiveCell.Value)); string clickNO = Convert.ToString(Common.FixDBManager.CheckNullStr(this.textOrdNO.Text)); string clickColumnID = Convert.ToString(Common.FixDBManager.CheckNullStr(tt.ActiveCell.Column.Key)); string clickColumnWGT = Convert.ToString(Common.FixDBManager.CheckNullStr(tt.ActiveCell.Value)); string clickSeq = Convert.ToString(Common.FixDBManager.CheckNullStr(this.comboOrdSeq.Value)); //指示待机 if (clickColumnID.Equals("INS_WGT")) { procCD = procCD + "A"; }//作业待机 else if (clickColumnID.Equals("WRK_WGT")) { procCD = procCD + "B"; }//判定待机 else if (clickColumnID.Equals("EST_WGT")) { procCD = procCD + "D"; }//作业完成 else if (clickColumnID.Equals("END_WGT")) { procCD = procCD + "F"; } else { return; } if (clickColumnWGT == null || clickColumnWGT == "" || clickColumnWGT == "0") return; if (clickNO == null || clickNO == "") return; if (clickSeq == null || clickSeq == "") return; if (procCD == null || procCD == "") return; if (procWgt == null || procCD == "") return; UIE041070 frm = new UIE041070(); frm.ob = this.ob; frm.Condition = clickNO + "|" + clickSeq + "|" + procCD; frm.ShowDialog(); } #endregion; //订单详细信息查询 private void ultraButton4_Click(object sender, EventArgs e) { } //生产结束指定 private void ultraButton3_Click(object sender, EventArgs e) { } //生产保留指定 private void ultraButton1_Click(object sender, EventArgs e) { } //紧急订单指定 private void ultraButton2_Click(object sender, EventArgs e) { } } }