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)
{
}
}
}