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 Core.Mes.Client.Comm.Server; using System.Collections; using Infragistics.Win.UltraWinGrid; using Core.Mes.Client.Comm.Control; namespace Core.StlMes.Client.SaleOrder.ReviewForm { public partial class frmOrderInfomationNext : FrmBase { //private int disWidth1 = 0; //private int disWidth2 = 0; public frmOrderInfomationNext() { //F1 F2功能 IsLoadUserView = true; InitializeComponent(); } private void frmOrderInfomationNext_Load(object sender, EventArgs e) { EntityHelper.ShowGridCaption(ultraGridOrderInfo.DisplayLayout.Bands[0]); EntityHelper.ShowGridCaption(ultraGrid2.DisplayLayout.Bands[0]); EntityHelper.ShowGridCaption(ultraGrid3.DisplayLayout.Bands[0]); EntityHelper.ShowGridCaption(ultraGrid4.DisplayLayout.Bands[0]); InitDate(); DoRefresh(); } /// /// 重写基类toolBar方法 /// /// /// public override void ToolBar_Click(object sender, string ToolbarKey) { switch (ToolbarKey) { case "Query": DoQuery(); break; case "Export": GridHelper.ulGridToExcel(ultraGridOrderInfo, "合同行信息"); break; case "Refresh": DoRefresh(); break; case "Link": DoLink(); break; case "CraftFile": CraftFileQuery(); break; case "Close": this.Close(); break; } } /// /// 工艺文件查询 /// private void CraftFileQuery() { ultraGridOrderInfo.UpdateData(); UltraGridRow ugr = ultraGridOrderInfo.ActiveRow; if (ugr == null) { MessageUtil.ShowWarning("请选择您要查询的合同行!"); return; } string ordLnPk = ugr.Cells["ORDLNPK"].Value.ToString(); string strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepOrderCraft.cpt&__bypagesize__=false" + "&lnpk=" + ordLnPk; 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(); } /// /// 初始时间 /// private void InitDate() { ultraCheckOrderNo.Checked = true; ultraCheckCreatime.Checked = true; ultraDateBegin.Value = DateTime.Now.AddDays(-60); ultraDateEnd.Value = DateTime.Now.AddDays(1).AddSeconds(-1); } private void DoRefresh() { if (ultraDateBegin.Value == null || ultraDateEnd.Value == null) { MessageUtil.ShowWarning("请选择正确的时间"); return; } ultraTextOrderNo.DataSource = null; String beginTime = ultraDateBegin.Value.ToString(); String endTime = ultraDateEnd.Value.ToString(); DataTable dt = ServerHelper.GetData("com.steering.pss.sale.order.CoreConReviewInfo.getOrdNoByTime", new Object[] { beginTime, endTime }, this.ob); ultraTextOrderNo.DataSource = dt; } private void DoQuery() { ArrayList param = new ArrayList(); if (ultraCheckOrderNo.Checked) { param.Add(ultraTextOrderNo.Text.Trim()); } else { param.Add(""); } if (ultraCheckCustomerMN.Checked) { param.Add(ultraTextCustomerMN.Text.Trim()); } else { param.Add(""); } if (ultraCheckStlmtUnit.Checked) { param.Add(ultraTextStlmtUnit.Text.Trim()); } else { param.Add(""); } if (ulGlOrderNo.Checked) { param.Add(utGlOrderNo.Text.Trim()); } else { param.Add(""); } string beginTime = "1000-01-01 00:00:01"; string endTime = "9999-01-01 00:00:01"; if (ultraCheckCreatime.Checked) { if (ultraDateBegin.Value == null || ultraDateEnd.Value == null) { MessageUtil.ShowWarning("请选择正确的时间"); return; } beginTime = Convert.ToDateTime(ultraDateBegin.Value).ToString("yyyy-MM-dd") + " 00:00:01"; endTime = Convert.ToDateTime(ultraDateEnd.Value).ToString("yyyy-MM-dd") + " 23:59:59"; } param.Add(beginTime); param.Add(endTime); string effectBeginTime = ""; string effectEndTime = ""; if (chkEffect.Checked) { if (effectDateBegin.Value == null || effectDateEnd.Value == null) { MessageUtil.ShowWarning("请选择正确的时间"); return; } effectBeginTime = Convert.ToDateTime(effectDateBegin.Value).ToString("yyyy-MM-dd") + " 00:00:01"; effectEndTime = Convert.ToDateTime(effectDateEnd.Value).ToString("yyyy-MM-dd") + " 23:59:59"; } string customInfo = !String.IsNullOrEmpty(CustomInfo.ToString2()) ? CustomInfo.ToString2() : ""; List listSource = EntityHelper.GetData( "com.steering.pss.sale.order.CoreOrderInfomation.getOrderInfoNext", new object[] { param, this.ValidDataPurviewIds, customInfo, effectBeginTime, effectEndTime }, this.ob); orderInfomationNextEntityBindingSource.DataSource = listSource; MergedCell(ultraGridOrderInfo, new string[] { "OrderNo", "CreateName" }); if (listSource == null || listSource.Count == 0) { DoQueryDelivry(""); DoQuerygTranSit(""); DoQueryQualityInfo(""); designStatus1.DoClear(); } } private void DoQueryDelivry(String ordLnPk) { List listSorce = EntityHelper.GetData( "com.steering.pss.sale.order.CoreOrderInfomation.getOrderDelivyInfo", new object[] { ordLnPk }, this.ob); slmOrderLineDeliveryEntityBindingSource.DataSource = listSorce; } private void DoQuerygTranSit(String ordLnDlyPk) { List listSorce = EntityHelper.GetData( "com.steering.pss.sale.order.CoreOrderInfomation.getOrderTranSit", new object[] { ordLnDlyPk }, this.ob); slmOrderDeliveryTransitEntityBindingSource.DataSource = listSorce; } private void DoQueryQualityInfo(String ordLnPk) { List listSorce = EntityHelper.GetData( "com.steering.pss.sale.order.CoreOrderInfomation.getOrderQualityInfo", new object[] { ordLnPk }, this.ob); slmOrdDesignStsTklgLstEntityBindingSource.DataSource = listSorce; SetColor(ultraGrid4, "Validflag", "0"); } private void ultraCheckOrderNo_CheckedChanged(object sender, EventArgs e) { if (ultraCheckOrderNo.Checked) { ultraTextOrderNo.Enabled = true; } else { ultraTextOrderNo.Enabled = false; } } private void ultraCheckCustomerMN_CheckedChanged(object sender, EventArgs e) { if (ultraCheckCustomerMN.Checked) { ultraTextCustomerMN.Enabled = true; } else { ultraTextCustomerMN.Enabled = false; } } private void ultraCheckStlmtUnit_CheckedChanged(object sender, EventArgs e) { if (ultraCheckStlmtUnit.Checked) { ultraTextStlmtUnit.Enabled = true; } else { ultraTextStlmtUnit.Enabled = false; } } private void ultraGrid1_AfterRowActivate(object sender, EventArgs e) { ultraGridOrderInfo.UpdateData(); UltraGridRow ugr = ultraGridOrderInfo.ActiveRow; if (ugr != null) { designStatus1.DoQuery(ugr.Cells["OrderNo"].Text.Trim(), ugr.Cells["OrdLnPk"].Text.Trim(), this.ob); DoQueryDelivry(ugr.Cells["OrdLnPk"].Text.Trim()); DoQueryQualityInfo(ugr.Cells["OrdLnPk"].Text.Trim()); } } private void ultraGrid2_AfterRowActivate(object sender, EventArgs e) { ultraGridOrderInfo.UpdateData(); UltraGridRow ugr = ultraGrid2.ActiveRow; if (ugr != null) { DoQuerygTranSit(ugr.Cells["OrdLnDlyPk"].Text.Trim()); } } private void SetColor(UltraGrid ug, String key, String value) { foreach (UltraGridRow ugr in ug.Rows) { if (ugr.Cells[key].Value.ToString().Equals(value)) { ugr.Appearance.ForeColor = Color.Red; } } } private void DoLink() { UltraGridRow ugr = ultraGridOrderInfo.ActiveRow; if (ugr == null) { MessageUtil.ShowWarning("请选择合同行"); return; } String orderNo = ugr.Cells["OrderNo"].Text.Trim(); //调用系统默认的浏览器 //System.Diagnostics.Process.Start("http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepInterTrade.cpt&__bypagesize__=false" + "&cmbOrder=" + strOrder); FrmOrderRepExcel fBug = new FrmOrderRepExcel(this.ob, "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepInterTrade.cpt&__bypagesize__=false" + "&cmbOrder=" + orderNo); fBug.AutoSize = true; fBug.MaximumSize = new Size(Screen.PrimaryScreen.WorkingArea.Width, Screen.PrimaryScreen.WorkingArea.Height); fBug.WindowState = FormWindowState.Maximized; fBug.Show(); } private void ultraTextOrderNo_KeyPress(object sender, KeyPressEventArgs e) { if (e.KeyChar == 13) { DoQuery(); } } //private void ultraExpandableGroupBox1_ExpandedStateChanged(object sender, EventArgs e) //{ // if (disWidth1 == 0) // { // disWidth1 = splitContainer2.SplitterDistance; // } // if (ultraExpandableGroupBox1.Expanded) // { // splitContainer2.SplitterDistance = disWidth1; // } // else // splitContainer2.SplitterDistance = this.Width; //} //private void ultraExpandableGroupBox2_ExpandedStateChanged(object sender, EventArgs e) //{ // if (disWidth2 == 0) // { // disWidth2 = splitContainer3.SplitterDistance; // } // if (ultraExpandableGroupBox2.Expanded) // { // splitContainer3.SplitterDistance = disWidth2; // } // else // splitContainer3.SplitterDistance = this.Width; //} /// /// 合并单元格 /// /// /// private void MergedCell(UltraGrid ug, string[] columnKeys) { if (columnKeys.Length == 0) { return; } ug.DisplayLayout.Override.MergedCellStyle = MergedCellStyle.Never; for (int i = 0; i < columnKeys.Length; i++) { ug.DisplayLayout.Bands[0].Columns[columnKeys[i]].MergedCellStyle = MergedCellStyle.Always; } } private void ultraCheckCreatime_CheckedChanged(object sender, EventArgs e) { if (ultraCheckCreatime.Checked) { ultraDateBegin.Enabled = true; ultraDateEnd.Enabled = true; } else { ultraDateBegin.Enabled = false; ultraDateEnd.Enabled = false; } } /// /// 还原GRID筛选条件 /// /// /// private void btnReset_Click(object sender, EventArgs e) { ultraGridOrderInfo.DisplayLayout.Bands[0].ColumnFilters.ClearAllFilters(); } private void ulGlOrderNo_CheckedChanged(object sender, EventArgs e) { utGlOrderNo.Enabled = ulGlOrderNo.Checked; } } }