| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404 |
- 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<orderInfomationNextEntity>(ultraGridOrderInfo.DisplayLayout.Bands[0]);
- EntityHelper.ShowGridCaption<SlmOrderLineDeliveryEntity>(ultraGrid2.DisplayLayout.Bands[0]);
- EntityHelper.ShowGridCaption<SlmOrderDeliveryTransitEntity>(ultraGrid3.DisplayLayout.Bands[0]);
- EntityHelper.ShowGridCaption<SlmOrdDesignStsTklgLstEntity>(ultraGrid4.DisplayLayout.Bands[0]);
- InitDate();
- DoRefresh();
- }
- /// <summary>
- /// 重写基类toolBar方法
- /// </summary>
- /// <param name="sender"></param>
- /// <param name="ToolbarKey"></param>
- 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;
- }
- }
- /// <summary>
- /// 工艺文件查询
- /// </summary>
- 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();
- }
- /// <summary>
- /// 初始时间
- /// </summary>
- 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<orderInfomationNextEntity> listSource = EntityHelper.GetData<orderInfomationNextEntity>(
- "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<SlmOrderLineDeliveryEntity> listSorce = EntityHelper.GetData<SlmOrderLineDeliveryEntity>(
- "com.steering.pss.sale.order.CoreOrderInfomation.getOrderDelivyInfo", new object[] { ordLnPk }, this.ob);
- slmOrderLineDeliveryEntityBindingSource.DataSource = listSorce;
- }
- private void DoQuerygTranSit(String ordLnDlyPk)
- {
- List<SlmOrderDeliveryTransitEntity> listSorce = EntityHelper.GetData<SlmOrderDeliveryTransitEntity>(
- "com.steering.pss.sale.order.CoreOrderInfomation.getOrderTranSit", new object[] { ordLnDlyPk }, this.ob);
- slmOrderDeliveryTransitEntityBindingSource.DataSource = listSorce;
- }
- private void DoQueryQualityInfo(String ordLnPk)
- {
- List<SlmOrdDesignStsTklgLstEntity> listSorce = EntityHelper.GetData<SlmOrdDesignStsTklgLstEntity>(
- "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;
- //}
- /// <summary>
- /// 合并单元格
- /// </summary>
- /// <param name="ug"></param>
- /// <param name="columnKeys"></param>
- 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;
- }
- }
- /// <summary>
- /// 还原GRID筛选条件
- /// </summary>
- /// <param name="sender"></param>
- /// <param name="e"></param>
- 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;
- }
- }
- }
|