frmOrderInfomationNext.cs 14 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404
  1. using System;
  2. using System.Collections.Generic;
  3. using System.ComponentModel;
  4. using System.Data;
  5. using System.Drawing;
  6. using System.Linq;
  7. using System.Text;
  8. using System.Windows.Forms;
  9. using CoreFS.CA06;
  10. using Core.Mes.Client.Comm.Tool;
  11. using Core.Mes.Client.Comm.Server;
  12. using System.Collections;
  13. using Infragistics.Win.UltraWinGrid;
  14. using Core.Mes.Client.Comm.Control;
  15. namespace Core.StlMes.Client.SaleOrder.ReviewForm
  16. {
  17. public partial class frmOrderInfomationNext : FrmBase
  18. {
  19. //private int disWidth1 = 0;
  20. //private int disWidth2 = 0;
  21. public frmOrderInfomationNext()
  22. {
  23. //F1 F2功能
  24. IsLoadUserView = true;
  25. InitializeComponent();
  26. }
  27. private void frmOrderInfomationNext_Load(object sender, EventArgs e)
  28. {
  29. EntityHelper.ShowGridCaption<orderInfomationNextEntity>(ultraGridOrderInfo.DisplayLayout.Bands[0]);
  30. EntityHelper.ShowGridCaption<SlmOrderLineDeliveryEntity>(ultraGrid2.DisplayLayout.Bands[0]);
  31. EntityHelper.ShowGridCaption<SlmOrderDeliveryTransitEntity>(ultraGrid3.DisplayLayout.Bands[0]);
  32. EntityHelper.ShowGridCaption<SlmOrdDesignStsTklgLstEntity>(ultraGrid4.DisplayLayout.Bands[0]);
  33. InitDate();
  34. DoRefresh();
  35. }
  36. /// <summary>
  37. /// 重写基类toolBar方法
  38. /// </summary>
  39. /// <param name="sender"></param>
  40. /// <param name="ToolbarKey"></param>
  41. public override void ToolBar_Click(object sender, string ToolbarKey)
  42. {
  43. switch (ToolbarKey)
  44. {
  45. case "Query":
  46. DoQuery();
  47. break;
  48. case "Export":
  49. GridHelper.ulGridToExcel(ultraGridOrderInfo, "合同行信息");
  50. break;
  51. case "Refresh":
  52. DoRefresh();
  53. break;
  54. case "Link":
  55. DoLink();
  56. break;
  57. case "CraftFile":
  58. CraftFileQuery();
  59. break;
  60. case "Close":
  61. this.Close();
  62. break;
  63. }
  64. }
  65. /// <summary>
  66. /// 工艺文件查询
  67. /// </summary>
  68. private void CraftFileQuery()
  69. {
  70. ultraGridOrderInfo.UpdateData();
  71. UltraGridRow ugr = ultraGridOrderInfo.ActiveRow;
  72. if (ugr == null)
  73. {
  74. MessageUtil.ShowWarning("请选择您要查询的合同行!");
  75. return;
  76. }
  77. string ordLnPk = ugr.Cells["ORDLNPK"].Value.ToString();
  78. string strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepOrderCraft.cpt&__bypagesize__=false" + "&lnpk=" + ordLnPk;
  79. FrmOrderRepExcel fBug = new FrmOrderRepExcel(ob, strurl);
  80. fBug.AutoSize = true;
  81. fBug.MaximumSize = new Size(Screen.PrimaryScreen.WorkingArea.Width, Screen.PrimaryScreen.WorkingArea.Height);
  82. fBug.WindowState = FormWindowState.Maximized;
  83. fBug.Text = "工艺文件";
  84. fBug.Show();
  85. }
  86. /// <summary>
  87. /// 初始时间
  88. /// </summary>
  89. private void InitDate()
  90. {
  91. ultraCheckOrderNo.Checked = true;
  92. ultraCheckCreatime.Checked = true;
  93. ultraDateBegin.Value = DateTime.Now.AddDays(-60);
  94. ultraDateEnd.Value = DateTime.Now.AddDays(1).AddSeconds(-1);
  95. }
  96. private void DoRefresh()
  97. {
  98. if (ultraDateBegin.Value == null || ultraDateEnd.Value == null)
  99. {
  100. MessageUtil.ShowWarning("请选择正确的时间");
  101. return;
  102. }
  103. ultraTextOrderNo.DataSource = null;
  104. String beginTime = ultraDateBegin.Value.ToString();
  105. String endTime = ultraDateEnd.Value.ToString();
  106. DataTable dt = ServerHelper.GetData("com.steering.pss.sale.order.CoreConReviewInfo.getOrdNoByTime", new Object[] { beginTime, endTime }, this.ob);
  107. ultraTextOrderNo.DataSource = dt;
  108. }
  109. private void DoQuery()
  110. {
  111. ArrayList param = new ArrayList();
  112. if (ultraCheckOrderNo.Checked)
  113. {
  114. param.Add(ultraTextOrderNo.Text.Trim());
  115. }
  116. else
  117. {
  118. param.Add("");
  119. }
  120. if (ultraCheckCustomerMN.Checked)
  121. {
  122. param.Add(ultraTextCustomerMN.Text.Trim());
  123. }
  124. else
  125. {
  126. param.Add("");
  127. }
  128. if (ultraCheckStlmtUnit.Checked)
  129. {
  130. param.Add(ultraTextStlmtUnit.Text.Trim());
  131. }
  132. else
  133. {
  134. param.Add("");
  135. }
  136. if (ulGlOrderNo.Checked)
  137. {
  138. param.Add(utGlOrderNo.Text.Trim());
  139. }
  140. else
  141. {
  142. param.Add("");
  143. }
  144. string beginTime = "1000-01-01 00:00:01";
  145. string endTime = "9999-01-01 00:00:01";
  146. if (ultraCheckCreatime.Checked)
  147. {
  148. if (ultraDateBegin.Value == null || ultraDateEnd.Value == null)
  149. {
  150. MessageUtil.ShowWarning("请选择正确的时间");
  151. return;
  152. }
  153. beginTime = Convert.ToDateTime(ultraDateBegin.Value).ToString("yyyy-MM-dd") + " 00:00:01";
  154. endTime = Convert.ToDateTime(ultraDateEnd.Value).ToString("yyyy-MM-dd") + " 23:59:59";
  155. }
  156. param.Add(beginTime);
  157. param.Add(endTime);
  158. string effectBeginTime = "";
  159. string effectEndTime = "";
  160. if (chkEffect.Checked)
  161. {
  162. if (effectDateBegin.Value == null || effectDateEnd.Value == null)
  163. {
  164. MessageUtil.ShowWarning("请选择正确的时间");
  165. return;
  166. }
  167. effectBeginTime = Convert.ToDateTime(effectDateBegin.Value).ToString("yyyy-MM-dd") + " 00:00:01";
  168. effectEndTime = Convert.ToDateTime(effectDateEnd.Value).ToString("yyyy-MM-dd") + " 23:59:59";
  169. }
  170. string customInfo = !String.IsNullOrEmpty(CustomInfo.ToString2()) ? CustomInfo.ToString2() : "";
  171. List<orderInfomationNextEntity> listSource = EntityHelper.GetData<orderInfomationNextEntity>(
  172. "com.steering.pss.sale.order.CoreOrderInfomation.getOrderInfoNext", new object[] { param, this.ValidDataPurviewIds, customInfo, effectBeginTime, effectEndTime }, this.ob);
  173. orderInfomationNextEntityBindingSource.DataSource = listSource;
  174. MergedCell(ultraGridOrderInfo, new string[] { "OrderNo", "CreateName" });
  175. if (listSource == null || listSource.Count == 0)
  176. {
  177. DoQueryDelivry("");
  178. DoQuerygTranSit("");
  179. DoQueryQualityInfo("");
  180. designStatus1.DoClear();
  181. }
  182. }
  183. private void DoQueryDelivry(String ordLnPk)
  184. {
  185. List<SlmOrderLineDeliveryEntity> listSorce = EntityHelper.GetData<SlmOrderLineDeliveryEntity>(
  186. "com.steering.pss.sale.order.CoreOrderInfomation.getOrderDelivyInfo", new object[] { ordLnPk }, this.ob);
  187. slmOrderLineDeliveryEntityBindingSource.DataSource = listSorce;
  188. }
  189. private void DoQuerygTranSit(String ordLnDlyPk)
  190. {
  191. List<SlmOrderDeliveryTransitEntity> listSorce = EntityHelper.GetData<SlmOrderDeliveryTransitEntity>(
  192. "com.steering.pss.sale.order.CoreOrderInfomation.getOrderTranSit", new object[] { ordLnDlyPk }, this.ob);
  193. slmOrderDeliveryTransitEntityBindingSource.DataSource = listSorce;
  194. }
  195. private void DoQueryQualityInfo(String ordLnPk)
  196. {
  197. List<SlmOrdDesignStsTklgLstEntity> listSorce = EntityHelper.GetData<SlmOrdDesignStsTklgLstEntity>(
  198. "com.steering.pss.sale.order.CoreOrderInfomation.getOrderQualityInfo", new object[] { ordLnPk }, this.ob);
  199. slmOrdDesignStsTklgLstEntityBindingSource.DataSource = listSorce;
  200. SetColor(ultraGrid4, "Validflag", "0");
  201. }
  202. private void ultraCheckOrderNo_CheckedChanged(object sender, EventArgs e)
  203. {
  204. if (ultraCheckOrderNo.Checked)
  205. {
  206. ultraTextOrderNo.Enabled = true;
  207. }
  208. else
  209. {
  210. ultraTextOrderNo.Enabled = false;
  211. }
  212. }
  213. private void ultraCheckCustomerMN_CheckedChanged(object sender, EventArgs e)
  214. {
  215. if (ultraCheckCustomerMN.Checked)
  216. {
  217. ultraTextCustomerMN.Enabled = true;
  218. }
  219. else
  220. {
  221. ultraTextCustomerMN.Enabled = false;
  222. }
  223. }
  224. private void ultraCheckStlmtUnit_CheckedChanged(object sender, EventArgs e)
  225. {
  226. if (ultraCheckStlmtUnit.Checked)
  227. {
  228. ultraTextStlmtUnit.Enabled = true;
  229. }
  230. else
  231. {
  232. ultraTextStlmtUnit.Enabled = false;
  233. }
  234. }
  235. private void ultraGrid1_AfterRowActivate(object sender, EventArgs e)
  236. {
  237. ultraGridOrderInfo.UpdateData();
  238. UltraGridRow ugr = ultraGridOrderInfo.ActiveRow;
  239. if (ugr != null)
  240. {
  241. designStatus1.DoQuery(ugr.Cells["OrderNo"].Text.Trim(), ugr.Cells["OrdLnPk"].Text.Trim(), this.ob);
  242. DoQueryDelivry(ugr.Cells["OrdLnPk"].Text.Trim());
  243. DoQueryQualityInfo(ugr.Cells["OrdLnPk"].Text.Trim());
  244. }
  245. }
  246. private void ultraGrid2_AfterRowActivate(object sender, EventArgs e)
  247. {
  248. ultraGridOrderInfo.UpdateData();
  249. UltraGridRow ugr = ultraGrid2.ActiveRow;
  250. if (ugr != null)
  251. {
  252. DoQuerygTranSit(ugr.Cells["OrdLnDlyPk"].Text.Trim());
  253. }
  254. }
  255. private void SetColor(UltraGrid ug, String key, String value)
  256. {
  257. foreach (UltraGridRow ugr in ug.Rows)
  258. {
  259. if (ugr.Cells[key].Value.ToString().Equals(value))
  260. {
  261. ugr.Appearance.ForeColor = Color.Red;
  262. }
  263. }
  264. }
  265. private void DoLink()
  266. {
  267. UltraGridRow ugr = ultraGridOrderInfo.ActiveRow;
  268. if (ugr == null)
  269. {
  270. MessageUtil.ShowWarning("请选择合同行");
  271. return;
  272. }
  273. String orderNo = ugr.Cells["OrderNo"].Text.Trim();
  274. //调用系统默认的浏览器
  275. //System.Diagnostics.Process.Start("http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepInterTrade.cpt&__bypagesize__=false" + "&cmbOrder=" + strOrder);
  276. FrmOrderRepExcel fBug = new FrmOrderRepExcel(this.ob, "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepInterTrade.cpt&__bypagesize__=false" + "&cmbOrder=" + orderNo);
  277. fBug.AutoSize = true;
  278. fBug.MaximumSize = new Size(Screen.PrimaryScreen.WorkingArea.Width, Screen.PrimaryScreen.WorkingArea.Height);
  279. fBug.WindowState = FormWindowState.Maximized;
  280. fBug.Show();
  281. }
  282. private void ultraTextOrderNo_KeyPress(object sender, KeyPressEventArgs e)
  283. {
  284. if (e.KeyChar == 13)
  285. {
  286. DoQuery();
  287. }
  288. }
  289. //private void ultraExpandableGroupBox1_ExpandedStateChanged(object sender, EventArgs e)
  290. //{
  291. // if (disWidth1 == 0)
  292. // {
  293. // disWidth1 = splitContainer2.SplitterDistance;
  294. // }
  295. // if (ultraExpandableGroupBox1.Expanded)
  296. // {
  297. // splitContainer2.SplitterDistance = disWidth1;
  298. // }
  299. // else
  300. // splitContainer2.SplitterDistance = this.Width;
  301. //}
  302. //private void ultraExpandableGroupBox2_ExpandedStateChanged(object sender, EventArgs e)
  303. //{
  304. // if (disWidth2 == 0)
  305. // {
  306. // disWidth2 = splitContainer3.SplitterDistance;
  307. // }
  308. // if (ultraExpandableGroupBox2.Expanded)
  309. // {
  310. // splitContainer3.SplitterDistance = disWidth2;
  311. // }
  312. // else
  313. // splitContainer3.SplitterDistance = this.Width;
  314. //}
  315. /// <summary>
  316. /// 合并单元格
  317. /// </summary>
  318. /// <param name="ug"></param>
  319. /// <param name="columnKeys"></param>
  320. private void MergedCell(UltraGrid ug, string[] columnKeys)
  321. {
  322. if (columnKeys.Length == 0)
  323. {
  324. return;
  325. }
  326. ug.DisplayLayout.Override.MergedCellStyle = MergedCellStyle.Never;
  327. for (int i = 0; i < columnKeys.Length; i++)
  328. {
  329. ug.DisplayLayout.Bands[0].Columns[columnKeys[i]].MergedCellStyle = MergedCellStyle.Always;
  330. }
  331. }
  332. private void ultraCheckCreatime_CheckedChanged(object sender, EventArgs e)
  333. {
  334. if (ultraCheckCreatime.Checked)
  335. {
  336. ultraDateBegin.Enabled = true;
  337. ultraDateEnd.Enabled = true;
  338. }
  339. else
  340. {
  341. ultraDateBegin.Enabled = false;
  342. ultraDateEnd.Enabled = false;
  343. }
  344. }
  345. /// <summary>
  346. /// 还原GRID筛选条件
  347. /// </summary>
  348. /// <param name="sender"></param>
  349. /// <param name="e"></param>
  350. private void btnReset_Click(object sender, EventArgs e)
  351. {
  352. ultraGridOrderInfo.DisplayLayout.Bands[0].ColumnFilters.ClearAllFilters();
  353. }
  354. private void ulGlOrderNo_CheckedChanged(object sender, EventArgs e)
  355. {
  356. utGlOrderNo.Enabled = ulGlOrderNo.Checked;
  357. }
  358. }
  359. }