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 Core.Mes.Client.Comm.Tool; using com.steering.pss.plnsaleord.order.model; using System.Collections; using Infragistics.Win.UltraWinGrid; using Core.Mes.Client.Comm.Server; using Core.Mes.Client.Comm; using Core.Mes.Client.Comm.Control; namespace Core.StlMes.Client.PlnSaleOrd { public partial class FrmQueryOrdProcInf : FrmBase { public FrmQueryOrdProcInf() { this.IsLoadUserView = true; InitializeComponent(); System.Threading.Thread t = new System.Threading.Thread(setGridColunmName); t.Start(); } private void setGridColunmName() { System.Threading.Thread.Sleep(3000); if (!this.IsDisposed) { Init(); } } public override void ToolBar_Click(object sender, string ToolbarKey) { base.ToolBar_Click(sender, ToolbarKey); switch (ToolbarKey) { case "Query": //查询 DoQuery(GetQueryCondition()); break; case "LookCraftFile"://查看工艺文件 DoLookCraftFile(); break; case "Export": GridHelper.ulGridToExcel(ultraGridSaleOrderProc, "排产综合信息"); break; case "MonthStatist"://统计报表 DoMonthStatist(); break; case "Close": //关闭 this.Close(); break; } } private void Init() { EntityHelper.ShowGridCaption(ultraGridSaleOrderProc.DisplayLayout.Bands[0]); ultraGridSaleOrderProc.DisplayLayout.Bands[0].Columns["OrderAddDesc"].EditorComponent = ultraFileLook; ultraGridSaleOrderProc.DisplayLayout.Bands[0].Columns["OrderAddDesc"].ButtonDisplayStyle = Infragistics.Win.UltraWinGrid.ButtonDisplayStyle.Always; PlanComm.setGridActivation(this.ultraGridSaleOrderProc.DisplayLayout.Bands[0]); PlanComm.setGridDigitalCol(ultraGridSaleOrderProc.DisplayLayout.Bands[0], 7, 3, "OrderQtyD", "PlanWtD", "FinishWt", "planWtBegin", "PlanPMain", "Lengthmax", "Lengthmin"); PlanComm.setGridDigitalCol(ultraGridSaleOrderProc.DisplayLayout.Bands[0], 5, 2, "Outdiameter", "Wallthick", "TotLenOneP", "LenRollMin", "LenRollMax", "HeightNkMin", "HeightNkMax", "LenToendMin", "LenToendMax", "LengthJg", "DimaterYlg", "HeightYlg", "HeightOrdMax", "HeightOrdMin", "AimWallthick", "RollLength", "ShrtLenRato", "LongLenRato"); PlanComm.setGridDigitalCol(ultraGridSaleOrderProc.DisplayLayout.Bands[0], 5, 3, "AimLenEnd", "AimLenRoll", "SiglLen", "EndlenSpecstd", "DifrncLenMax", "AvgLenMin", "Longest", "Shortest", "ZOrderweight"); PlanComm.setGridDigitalCol(ultraGridSaleOrderProc.DisplayLayout.Bands[0], 5, 0, "PlanNumD", "planNumBegin", "CutNumP", "ZOrdernum"); PlanComm.setGridDigitalCol(ultraGridSaleOrderProc.DisplayLayout.Bands[0], 3, 6, "WeightPerM"); PlanComm.setGridSummarySet(ultraGridSaleOrderProc, 0, "PlanNumD"); PlanComm.setGridSummarySet(ultraGridSaleOrderProc, 3, "OrderQtyD", "PlanWtD", "FinishWt", "planWtBegin", "PlanPMain"); } private void FrmQueryOrdProcInf_Load(object sender, EventArgs e) { comQueryPanlInf1.ctrlForQueryPORDERSTATUS.Items.Add("1", "已接收"); comQueryPanlInf1.ctrlForQueryPORDERSTATUS.Items.Add("2", "已下发"); comQueryPanlInf1.ctrlForQueryPORDERSTATUS.Items.Add("3", "生产中"); comQueryPanlInf1.ctrlForQueryPORDERSTATUS.Items.Add("4", "生产完成"); comQueryPanlInf1.ctrlForQueryPORDERSTATUS.Items.Add("5", "缴库完毕"); comQueryPanlInf1.ctrlForQueryPORDERSTATUS.SelectedIndex = 0; comQueryPanlInf1.ultraDateTimeRollMonth.DateTime = DateTime.Now; comQueryPanlInf1.ultraTextEditorAcceptNo.Value = "X" + DateTime.Now.ToString("yyyyMMdd"); DateTime now = DateTime.Now; DateTime dt1 = new DateTime(now.Year, now.Month, 1);//当月第一天 DateTime dt2 = dt1.AddMonths(1).AddDays(-1);//当月最后一天 this.RegStartTime.Value = DateTime.Parse(dt1.ToString("yyyy-MM-dd") + " 00:00:00"); this.RegEndTime.Value = DateTime.Parse(dt2.ToString("yyyy-MM-dd") + " 23:59:59"); Init(); } /// /// 获取查询条件信息 /// /// 查询条件信息 private ArrayList GetQueryCondition() { ArrayList ary = new ArrayList(); string strRollmonth = ""; string strAcceptNo = "";//接收批次号 string strOrderNo = ""; //合同号 string strOrderStatus = ""; //合同状态 string ordSource = "";//合同来源 if (comQueryPanlInf1.checkBoxAcceptNo.Checked) { strAcceptNo = comQueryPanlInf1.ultraTextEditorAcceptNo.Text.Trim(); } if (comQueryPanlInf1.checkBoxForReqORDER_NO.Checked) { strOrderNo = comQueryPanlInf1.ctrlForQueryORDER_NO.Text.Trim(); } if (comQueryPanlInf1.checkBoxForReqPORDERSTATUS.Checked) { strOrderStatus = comQueryPanlInf1.ctrlForQueryPORDERSTATUS.Value.ToString(); } if (comQueryPanlInf1.checkBoxRollMonth.Checked) { strRollmonth = comQueryPanlInf1.ultraDateTimeRollMonth.DateTime.ToString("yyyy-MM"); } if (comQueryPanlInf1.checkBoxOrdSource.Checked) { ordSource = comQueryPanlInf1.ultraComboOrdSource.Value.ToString(); } ary.Add(comQueryPanlInf1.checkBoxHvJg.Checked); ary.Add(comQueryPanlInf1.checkBoxAddZz.Checked); ary.Add(comQueryPanlInf1.checkBoxBk.Checked); ary.Add(comQueryPanlInf1.checkBoxDc.Checked); ary.Add(comQueryPanlInf1.checkBoxInSpec.Checked); ary.Add(strRollmonth); ary.Add(strAcceptNo); ary.Add(strOrderNo); ary.Add(strOrderStatus); ary.Add(ordSource); return ary; } /// /// 查询 /// private void DoQuery(ArrayList ary) { string startTim = ""; string endTime = ""; if (this.ultraCheckEditor1.Checked) { startTim = this.RegStartTime.Value.ToString("yyyy-MM-dd HH:mm:ss"); endTime = this.RegEndTime.Value.ToString("yyyy-MM-dd HH:mm:ss"); } slmSaleOrderEntitybindingSource.DataSource = EntityHelper.GetData( "com.steering.pss.plnsaleord.order.CoreQueryOrdProcInf.queryOrdProcInf", new object[] { ary,startTim,endTime }, this.ob); } /// /// 查看上传工艺文件 /// private void DoLookCraftFile() { UltraGridRow ugr = this.ultraGridSaleOrderProc.ActiveRow; if (ugr == null) { return; } DataTable dtPath = ServerHelper.GetData("com.steering.pss.plnsaleord.order.CoreSaleOrderReceive.queryCraftFilePath", new object[] { ugr.Cells["OrdLnDlyPk"].Value.ToString(), ugr.Cells["PlnDivideId"].Value.ToString() }, this.ob); if (dtPath != null && dtPath.Rows.Count > 0) { ArrayList listPIC = new ArrayList(); foreach (DataRow dr in dtPath.Rows) { listPIC.Add(dr["CRAFT_PATH"].ToString()); } dlgOrderAskLook orderAsk = new dlgOrderAskLook(this.ob, listPIC); orderAsk.Text = "查看上传工艺文件"; orderAsk.Show(); } } /// /// 排产月统计查询 /// private void DoMonthStatist() { FrmReqRollMonth outPut = new FrmReqRollMonth(); outPut.Show(); } private void ultraFileLook_EditorButtonClick(object sender, Infragistics.Win.UltraWinEditors.EditorButtonEventArgs e) { try { UltraGridRow ugr = ultraGridSaleOrderProc.ActiveRow; if (ugr == null) { return; } string askNo = ugr.Cells["AddAskNo"].Value.ToString(); ArrayList listPIC = new ArrayList(); DataTable dt = ServerHelper.GetData("com.steering.pss.plnsaleord.order.CorePlnSaleOrder.queryAddAsk", new object[] { askNo }, this.ob); if (dt != null && dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { listPIC.Add(dr["PIC"].ToString()); } } dlgOrderAskLook orderAsk = new dlgOrderAskLook(this.ob, listPIC); orderAsk.Show(); } catch (Exception ex) { if (!(ex is MESException)) { MessageBox.Show(ex.Message); } } } private void ultraCheckEditor1_CheckedChanged(object sender, EventArgs e) { this.RegStartTime.Enabled = this.RegEndTime.Enabled = this.ultraCheckEditor1.Checked; } } }