FrmPlnOrderZzS.cs 17 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474
  1. using System;
  2. using System.Collections;
  3. using System.Collections.Generic;
  4. using System.ComponentModel;
  5. using System.Data;
  6. using System.Drawing;
  7. using System.Linq;
  8. using System.Text;
  9. using System.Windows.Forms;
  10. using Core.Mes.Client.Comm.Control;
  11. using Core.Mes.Client.Comm.Format;
  12. using Core.Mes.Client.Comm.Tool;
  13. using Core.StlMes.Client.PlnSaleOrd.BaseMethod;
  14. using Core.StlMes.Client.PlnSaleOrd.工序排产;
  15. using Core.StlMes.Client.PlnSaleOrd.工序排产.entity;
  16. using CoreFS.CA06;
  17. using Infragistics.Win;
  18. using Infragistics.Win.UltraWinGrid;
  19. namespace Core.StlMes.Client.PlnSaleOrd
  20. {
  21. public partial class FrmPlnOrderZzS : FrmBase
  22. {
  23. /// <summary>
  24. /// 订单编号
  25. /// </summary>
  26. private string _ProPlanId = "";
  27. /// <summary>
  28. /// 排产序号
  29. /// </summary>
  30. private string _GxPlanNo = "";
  31. /// <summary>
  32. /// 行首背景色
  33. /// </summary>
  34. private Color _BackColor = new Color();
  35. /// <summary>
  36. /// 调整行集合
  37. /// </summary>
  38. private ArrayList _EntityList = null;
  39. public FrmPlnOrderZzS()
  40. {
  41. this.IsLoadUserView = true;
  42. InitializeComponent();
  43. }
  44. private void FrmPlnOrderZzS_Load(object sender, EventArgs e)
  45. {
  46. if (CustomInfo == null) { CustomInfo = ""; }
  47. //设置列头名称
  48. EntityHelper.ShowGridCaption<PlnOrderCastOSEntity>(ultraGridZz.DisplayLayout.Bands[0]);
  49. BaseHelper.setOtherColumnReadOnly(ultraGridZz, new string[] { "CHC", "PlineCode", "PlanTimeB", "RepairType", "PlanUsetime" });
  50. BaseHelper.setColumnBackColor(ultraGridZz, new string[] { "PlineCode" });
  51. BaseHelper.InitCellPosition(ultraGridZz, new string[] { "GxPlanNo", "OrderSeq", "DeliveryNo", "PlanWtS", "PlanNumS", "PlanUsetime", "GxProSeq",
  52. "PlnDivideId", "DiameterLz","LenGpSingle","CutNumGp","CutLoseLen","LengthLz","WtCastOne","CastNumCalc","FurnaceNumCalc","FurnaceWt","PlanedWt","PlanedNum",
  53. "Finishweight","FinishNum","CastNum","FurnaceNum","AddWtBegin","AddWtEnd","AddWtAhead","ProcessingCostA","TotalCostA","ProcessingCostB","TotalCostB"});
  54. BaseHelper.setUltraGridColumnMaxInput(ultraGridZz, new string[] { "PlanWtS" });
  55. PlanHelper.InitDropPline("B", "", comPline, this.ob);
  56. PlanHelper.InitRepairType(ultraGridZz, this);
  57. PlanHelper.InitEditPline("B", "", ultraGridZz, this);
  58. if (CustomInfo != "0") { BaseHelper.ForbidSort(ultraGridZz); }
  59. BaseHelper.GridColumnSum(ultraGridZz, new string[] { "PlanWtS" });
  60. BaseHelper.GridColumnCount(ultraGridZz, new string[] { "PlanNumS" });
  61. BaseHelper.InitCellPositionMiddle(ultraGridZz, new string[] { "IsRepairPln", "IsPlanOk", "IfConnectAhead", "IfConnectNext", "IfMonitorLg" });
  62. _BackColor = ultraGridZz.DisplayLayout.Override.RowSelectorAppearance.BackColor;
  63. }
  64. public override void ToolBar_Click(object sender, string ToolbarKey)
  65. {
  66. base.ToolBar_Click(sender, ToolbarKey);
  67. switch (ToolbarKey)
  68. {
  69. case "Query"://查询
  70. Query();
  71. break;
  72. case "Capacity"://产线能力维护
  73. Capacity();
  74. break;
  75. case "AddRepairPlan"://检修计划
  76. AddRepairPlan();
  77. break;
  78. case "DeleteRepairPlan"://删除检修计划
  79. DeleteRepairPlan();
  80. break;
  81. case "PlineChange"://产线调整
  82. PlineChange();
  83. break;
  84. case "TimeChange"://时间调整
  85. TimeChange();
  86. break;
  87. case "StatusChange"://状态调整
  88. StatusChange();
  89. break;
  90. case "InitData"://耗时初始化
  91. Init();
  92. break;
  93. case "Spit"://拆分订单
  94. Spit();
  95. break;
  96. case "Merge"://合并订单
  97. Merge();
  98. break;
  99. case "Issued"://下发
  100. Issued("0");
  101. break;
  102. case "CancelIssued"://取消下发
  103. Issued("1");
  104. break;
  105. case "Export": //导出
  106. GridHelper.ulGridToExcel(ultraGridZz, "铸造排产信息");
  107. break;
  108. default:
  109. break;
  110. }
  111. }
  112. private void chcPline_CheckedChanged(object sender, EventArgs e)
  113. {
  114. if (chcPline.Checked) { comPline.ReadOnly = false; } else { comPline.ReadOnly = true; }
  115. if (chcProPlanId.Checked) { txtProPlanId.ReadOnly = false; } else { txtProPlanId.ReadOnly = true; }
  116. }
  117. private void ultraGridZz_InitializeRow(object sender, InitializeRowEventArgs e)
  118. {
  119. PlanHelper.ControlCellEdit(e.Row);
  120. }
  121. /// <summary>
  122. /// 查询
  123. /// </summary>
  124. private void Query()
  125. {
  126. //产线
  127. string plineCode = "";
  128. if (chcPline.Checked) { plineCode = comPline.Value == null ? "" : comPline.Value.ToString(); }
  129. //如果是排产界面,则下拉框的产线不能为空,需要排序
  130. if (!CustomInfo.Equals("0") && plineCode.Equals("")) { MessageUtil.ShowTips("请选择产线!"); return; }
  131. //执行状态
  132. string[] statusArr = new string[4] { "", "", "", "" };
  133. if (ultraCheckEditor1.Checked) { statusArr[0] = "0"; }
  134. if (ultraCheckEditor2.Checked) { statusArr[1] = "1"; }
  135. if (ultraCheckEditor3.Checked) { statusArr[2] = "2"; }
  136. if (ultraCheckEditor3.Checked) { statusArr[3] = "3"; }
  137. //订单编号
  138. string proPlanId = "";
  139. if (chcProPlanId.Checked) { proPlanId = txtProPlanId.Text.Trim(); }
  140. List<PlnOrderCastOSEntity> listSource = EntityHelper.GetData<PlnOrderCastOSEntity>
  141. ("com.steering.pss.plnsaleord.processOrder.base.ProducHelper.queryPlanOrderB", new object[] { plineCode, proPlanId, statusArr }, this.ob);
  142. plnOrderCastOSEntityBindingSource.DataSource = listSource;
  143. //激活操作行代码
  144. if ((!_ProPlanId.Equals("") && !_GxPlanNo.Equals("")) || _EntityList != null)
  145. foreach (UltraGridRow ugr in ultraGridZz.Rows)
  146. {
  147. if (!_ProPlanId.Equals("") && !_GxPlanNo.Equals(""))
  148. {
  149. if (ugr.Cells["ProPlanId"].Text.Trim().Equals(_ProPlanId) && ugr.Cells["GxPlanNo"].Text.Trim().Equals(_GxPlanNo))
  150. {
  151. ugr.Activate();
  152. break;
  153. }
  154. }
  155. if (_EntityList != null)
  156. {
  157. for (int i = 0; i < _EntityList.Count; i++)
  158. {
  159. PlnOrderCastSEntity jgxsEntity = (PlnOrderCastSEntity)_EntityList[i];
  160. if (ugr.Cells["ProPlanId"].Text.Trim().Equals(jgxsEntity.ProPlanId) && ugr.Cells["GxPlanNo"].Text.Trim().Equals(jgxsEntity.GxPlanNo))
  161. {
  162. ugr.Appearance.BackColor = Color.Wheat;
  163. ugr.Activate();
  164. }
  165. }
  166. }
  167. }
  168. _EntityList = null;
  169. _ProPlanId = "";
  170. _ProPlanId = "";
  171. }
  172. /// <summary>
  173. /// 产线能力维护
  174. /// </summary>
  175. private void Capacity()
  176. {
  177. UltraGridRow ugr = ultraGridZz.ActiveRow;
  178. if (ugr == null)
  179. {
  180. return;
  181. }
  182. string inMaterialNo = ugr.Cells["WlidIn"].Text;
  183. string outMaterialNo = ugr.Cells["MaterialNo"].Text;
  184. string plineCode = ugr.Cells["PlineCode"].Value.ToString();
  185. FrmBaseMaterialBPl frmBaseMaterialBPl = new FrmBaseMaterialBPl(inMaterialNo, outMaterialNo, plineCode, this.ob);
  186. frmBaseMaterialBPl.ShowDialog();
  187. }
  188. /// <summary>
  189. /// 新增检修计划
  190. /// </summary>
  191. private void AddRepairPlan()
  192. {
  193. if (comPline.Value == null || comPline.Value.ToString().Equals(""))
  194. {
  195. MessageUtil.ShowTips("请选择产线!");
  196. return;
  197. }
  198. FrmJxjh frmJxjh = new FrmJxjh(this.ob, comPline.Value.ToString(), "B");
  199. frmJxjh.ShowDialog();
  200. Query();
  201. }
  202. /// <summary>
  203. /// 折分订单
  204. /// </summary>
  205. private void Spit()
  206. {
  207. ArrayList list = ProducHelper.GetChcRows<PlnOrderCastSEntity>(ultraGridZz);
  208. bool flag = ProducHelper.SpitPlanOrder(list,"B",this.ob);
  209. if (flag)
  210. {
  211. _ProPlanId = ((PlnOrderCastSEntity)list[0]).ProPlanId;
  212. _GxPlanNo = ((PlnOrderCastSEntity)list[0]).GxPlanNo;
  213. Query();
  214. }
  215. }
  216. /// <summary>
  217. /// 合并订单
  218. /// </summary>
  219. private void Merge()
  220. {
  221. ArrayList list = ProducHelper.GetChcRows<PlnOrderCastSEntity>(ultraGridZz);
  222. bool flag = ProducHelper.MergePlanOrder(list,"B",this.ob);
  223. if (flag)
  224. {
  225. _ProPlanId = ((PlnOrderCastSEntity)list[0]).ProPlanId;
  226. _GxPlanNo = ((PlnOrderCastSEntity)list[0]).GxPlanNo;
  227. Query();
  228. }
  229. }
  230. /// <summary>
  231. /// 产线调整
  232. /// </summary>
  233. private void PlineChange()
  234. {
  235. ArrayList list = ProducHelper.GetChcRows<PlnOrderCastSEntity>(ultraGridZz);
  236. bool flag = ProducHelper.PlineChange(list,"B",this.ob);
  237. if (flag)
  238. {
  239. _ProPlanId = ((PlnOrderCastSEntity)list[0]).ProPlanId;
  240. _GxPlanNo = ((PlnOrderCastSEntity)list[0]).GxPlanNo;
  241. Query();
  242. }
  243. }
  244. /// <summary>
  245. /// 初始化
  246. /// </summary>
  247. private void Init()
  248. {
  249. ArrayList list = ProducHelper.GetChcRows<PlnOrderCastSEntity>(ultraGridZz);
  250. bool flag = ProducHelper.InitData(list, "B", this.ob);
  251. if (flag)
  252. {
  253. _ProPlanId = ((PlnOrderCastSEntity)list[0]).ProPlanId;
  254. _GxPlanNo = ((PlnOrderCastSEntity)list[0]).GxPlanNo;
  255. Query();
  256. }
  257. }
  258. /// <summary>
  259. /// 状态调整
  260. /// </summary>
  261. private void StatusChange()
  262. {
  263. ArrayList list = ProducHelper.GetChcRows<PlnOrderCastSEntity>(ultraGridZz);
  264. bool flag = ProducHelper.StatusChange(list,"B",this.ob);
  265. if (flag)
  266. {
  267. _ProPlanId = ((PlnOrderCastSEntity)list[0]).ProPlanId;
  268. _GxPlanNo = ((PlnOrderCastSEntity)list[0]).GxPlanNo;
  269. Query();
  270. }
  271. }
  272. /// <summary>
  273. /// 时间调整
  274. /// </summary>
  275. private void TimeChange()
  276. {
  277. ArrayList list = ProducHelper.GetChcRows<PlnOrderCastSEntity>(ultraGridZz);
  278. bool flag = ProducHelper.TimeChange(list, "B", this.ob);
  279. if (flag)
  280. {
  281. _ProPlanId = ((PlnOrderCastSEntity)list[0]).ProPlanId;
  282. _GxPlanNo = ((PlnOrderCastSEntity)list[0]).GxPlanNo;
  283. Query();
  284. }
  285. }
  286. /// <summary>
  287. /// 排序
  288. /// </summary>
  289. /// <param name="sender"></param>
  290. /// <param name="e"></param>
  291. private void ultraGridZzS_MouseDown(object sender, MouseEventArgs e)
  292. {
  293. //排产查询界面,不能排序
  294. if (CustomInfo.Equals("0"))
  295. { return;}
  296. try
  297. { ultraGridZz.UpdateData();}
  298. catch (Exception)
  299. { MessageUtil.ShowWarning("数据异常,请刷新数据!");return;
  300. }
  301. if (e.Button == MouseButtons.Right)
  302. {
  303. //移动行
  304. ArrayList entityList = ProducHelper.GetChcRows<PlnOrderCastSEntity>(ultraGridZz);
  305. if (entityList == null || entityList.Count == 0)
  306. { return;
  307. }
  308. //定位行
  309. UIElement myUIElement = ultraGridZz.DisplayLayout.UIElement.ElementFromPoint(new Point(e.X, e.Y));
  310. UltraGridCell myCell = (UltraGridCell)myUIElement.GetContext(typeof(UltraGridCell));
  311. if (myCell == null){ return ; }
  312. UltraGridRow ugr = myCell.Row;
  313. if (ugr == null){ return ; }
  314. PlnOrderCastSEntity entityD = (PlnOrderCastSEntity)ugr.ListObject;
  315. bool flag = ProducHelper.SortPlanOrder(entityList, entityD, "B", "",this.ob);
  316. if (flag) {
  317. _EntityList = entityList;
  318. Query();
  319. }
  320. }
  321. }
  322. private void ultraGridZzS_AfterRowActivate(object sender, EventArgs e)
  323. {
  324. UltraGridRow ugrAc = ultraGridZz.ActiveRow;
  325. if (ugrAc == null)
  326. {
  327. return;
  328. }
  329. foreach (UltraGridRow ugr in ultraGridZz.Rows)
  330. {
  331. if (ugr.Cells["ProPlanId"].Text.Equals(ugrAc.Cells["ProPlanId"].Text))
  332. {
  333. ugr.RowSelectorAppearance.BackColor = Color.LightGreen;
  334. }
  335. else
  336. {
  337. ugr.RowSelectorAppearance.BackColor = _BackColor;
  338. }
  339. if (ugr.Cells["PlanUsetime"].Value == null || ugr.Cells["PlanUsetime"].Value.ToString().Equals("") || Convert.ToDouble(ugr.Cells["PlanUsetime"].Value.ToString()) <= 0)
  340. {
  341. ugr.Cells["PlanUsetime"].Appearance.BackColor = Color.MistyRose;
  342. }
  343. if (ugr.Cells["ExeStatus"].Value.ToString().Equals("生产中"))
  344. {
  345. ugr.Cells["PlanTimeB"].Appearance.BackColor = System.Drawing.Color.FromArgb(255, 255, 128);
  346. }
  347. if (ugr.Cells["IsRepairPln"].Text.Equals("Y"))
  348. {
  349. ugr.Cells["PlanUsetime"].Appearance.BackColor = System.Drawing.Color.FromArgb(255, 255, 128);
  350. ugr.Cells["RepairType"].Appearance.BackColor = System.Drawing.Color.FromArgb(255, 255, 128);
  351. }
  352. }
  353. }
  354. private void ultraGridZzS_CellChange(object sender, CellEventArgs e)
  355. {
  356. try
  357. {
  358. ultraGridZz.UpdateData();
  359. if (e.Cell.Column.Key.Equals("PlineCode"))
  360. {
  361. IQueryable<UltraGridRow> chcRows = ultraGridZz.Rows.AsQueryable().Where(a => a.GetValue("CHC") == "True");
  362. if (CustomInfo.Equals("0"))
  363. {
  364. e.Cell.Row.Cells["PlineName"].Value = e.Cell.Text;
  365. }
  366. else
  367. {
  368. if (chcRows != null && chcRows.Count() > 0)
  369. {
  370. foreach (UltraGridRow ugr in chcRows)
  371. {
  372. ugr.Cells["PlineCode"].Value = e.Cell.Value.ToString();
  373. ugr.Cells["PlineName"].Value = e.Cell.Text;
  374. }
  375. }
  376. }
  377. }
  378. }
  379. catch (Exception)
  380. {
  381. }
  382. }
  383. /// <summary>
  384. /// 删除检修计划
  385. /// </summary>
  386. public void DeleteRepairPlan()
  387. {
  388. ArrayList list = ProducHelper.GetChcRows<PlnOrderCastSEntity>(ultraGridZz);
  389. bool flag = ProducHelper.DeleteRepairPlan(list, "B", this.ob);
  390. if (flag)
  391. {
  392. _ProPlanId = ((PlnOrderCastSEntity)list[0]).ProPlanId;
  393. _GxPlanNo = ((PlnOrderCastSEntity)list[0]).GxPlanNo;
  394. Query();
  395. }
  396. }
  397. private void comPline_ValueChanged(object sender, EventArgs e)
  398. {
  399. if (comPline == null)
  400. {
  401. return;
  402. }
  403. else
  404. {
  405. if (!CustomInfo.Equals("0"))
  406. {
  407. Query();
  408. }
  409. }
  410. }
  411. /// <summary>
  412. /// 下发(取消)
  413. /// </summary>
  414. private void Issued(string isFlag)
  415. {
  416. ArrayList list = ProducHelper.GetChcRows<PlnOrderCastSEntity>(ultraGridZz);
  417. bool flag = ProducHelper.issuedPlanOrder(list, UserInfo.GetUserName(), isFlag, "B", this.ob);
  418. if (flag)
  419. {
  420. _ProPlanId = ((PlnOrderCastSEntity)list[0]).ProPlanId;
  421. _GxPlanNo = ((PlnOrderCastSEntity)list[0]).GxPlanNo;
  422. Query();
  423. }
  424. }
  425. private void ultraGridZz_AfterSelectChange(object sender, AfterSelectChangeEventArgs e)
  426. {
  427. foreach (UltraGridRow uRow in ultraGridZz.Selected.Rows)
  428. {
  429. if (uRow.GetType() != typeof(Infragistics.Win.UltraWinGrid.UltraGridGroupByRow))
  430. {
  431. uRow.Cells["CHC"].Value = true;
  432. }
  433. }
  434. }
  435. }
  436. }