FrmSteelChangeOrderDetail.cs 22 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491
  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 Core.Mes.Client.Comm.Control;
  10. using Core.Mes.Client.Comm.Format;
  11. using Core.Mes.Client.Comm.Tool;
  12. using Core.StlMes.Client.PlnSaleOrd.BaseMethod;
  13. using Core.StlMes.Client.PlnSaleOrd.炼钢计划.entity;
  14. using CoreFS.CA06;
  15. using Infragistics.Win.UltraWinGrid;
  16. using NPOI.Util;
  17. namespace Core.StlMes.Client.PlnSaleOrd.炼钢计划
  18. {
  19. public partial class FrmSteelChangeOrderDetail : FrmBase
  20. {
  21. public FrmSteelChangeOrderDetail()
  22. {
  23. InitializeComponent();
  24. }
  25. public string Furnaceno1 { get; set; }
  26. public string Furnaceno2 { get; set; }
  27. private void FrmSteelChangeOrderDetail_Load(object sender, EventArgs e)
  28. {
  29. EntityHelper.ShowGridCaption<PlnSteelforOrdNewEntity>(ugOrder.DisplayLayout.Bands[0]);
  30. BaseHelper.setOtherColumnReadOnly(ugOrder, new[] { "CHC", "ChangeNum", "ChangeWeight" });
  31. EntityHelper.ShowGridCaption<PlnSteelforMergeEntity>(ugOrder.DisplayLayout.Bands[1]);
  32. BaseHelper.setOtherColumnReadOnly(ugOrder2, new[] { "CHC", "ChangeNum", "ChangeWeight" });
  33. EntityHelper.ShowGridCaption<PlnSteelforOrdNewEntity>(ugOrder2.DisplayLayout.Bands[0]);
  34. EntityHelper.ShowGridCaption<PlnSteelforMergeEntity>(ugOrder2.DisplayLayout.Bands[1]);
  35. //绑定Valuelist 根据实体类值显示
  36. var list = SteelManagementHelper.GetValuelistLogic();
  37. SteelManagementHelper.SetGridValuelist(ref ugOrder, "IfSurplusAlloted", ref list);
  38. list = SteelManagementHelper.GetStatus();
  39. SteelManagementHelper.SetGridValuelist(ref ugOrder, "Status", ref list);
  40. list = SteelManagementHelper.GetValuelistLogic();
  41. SteelManagementHelper.SetGridValuelist(ref ugOrder, "Surplusflag", ref list);
  42. list = SteelManagementHelper.GetSurplusType();
  43. SteelManagementHelper.SetGridValuelist(ref ugOrder, "SurplusType", ref list);
  44. list = SteelManagementHelper.GetCastingtype();
  45. SteelManagementHelper.SetGridValuelist(ref ugOrder, "Castingtype", ref list);
  46. list = SteelManagementHelper.GetSurplusflag();
  47. SteelManagementHelper.SetGridValuelist(ref ugOrder, "GetSurplusflag", ref list);
  48. //绑定Valuelist 根据实体类值显示
  49. list = SteelManagementHelper.GetValuelistLogic();
  50. SteelManagementHelper.SetGridValuelist(ref ugOrder2, "IfSurplusAlloted", ref list);
  51. list = SteelManagementHelper.GetStatus();
  52. SteelManagementHelper.SetGridValuelist(ref ugOrder2, "Status", ref list);
  53. list = SteelManagementHelper.GetValuelistLogic();
  54. SteelManagementHelper.SetGridValuelist(ref ugOrder2, "Surplusflag", ref list);
  55. list = SteelManagementHelper.GetSurplusType();
  56. SteelManagementHelper.SetGridValuelist(ref ugOrder2, "SurplusType", ref list);
  57. list = SteelManagementHelper.GetCastingtype();
  58. SteelManagementHelper.SetGridValuelist(ref ugOrder2, "Castingtype", ref list);
  59. list = SteelManagementHelper.GetSurplusflag();
  60. SteelManagementHelper.SetGridValuelist(ref ugOrder2, "GetSurplusflag", ref list);
  61. Reresh();
  62. }
  63. private void Reresh()
  64. {
  65. plnSteelforOrdNewEntityBindingSource1.DataSource = GetOrderAndMerge(Furnaceno1);
  66. GridHelper.RefreshAndAutoSize(ugOrder);
  67. plnSteelforOrdNewEntityBindingSource2.DataSource = GetOrderAndMerge(Furnaceno2);
  68. GridHelper.RefreshAndAutoSize(ugOrder2);
  69. this.ugOrder.Rows.ExpandAll(true);
  70. this.ugOrder2.Rows.ExpandAll(true);
  71. }
  72. private List<PlnSteelforOrdNewEntityAndMerge> GetOrderAndMerge(string Furnaceno)
  73. {
  74. List<PlnSteelforOrdNewEntityAndMerge> listSource = EntityHelper.GetData<PlnSteelforOrdNewEntityAndMerge>
  75. ("com.steering.pss.plnsaleord.steelMarkingPlan.FrmSteelManagement.SelectPlnSteelforOrdEntityByfurnaceno",
  76. new object[]
  77. { Furnaceno },
  78. ob);
  79. listSource = listSource.Where(p => p.SurplusType != "2" && p.SurplusType != "3").ToList();
  80. List<string> MergeNo =
  81. listSource.Where(p => !string.IsNullOrEmpty(p.MergeNo)).Select(p => p.MergeNo).Distinct().ToList();
  82. if (MergeNo.Any())
  83. {
  84. List<PlnSteelforMergeEntity> listSource2 = EntityHelper.GetData<PlnSteelforMergeEntity>
  85. ("com.steering.pss.plnsaleord.steelMarkingPlan.FrmSteelManagement.SelectPlnSteelforMergeEntity",
  86. new object[]
  87. {MergeNo},
  88. ob);
  89. foreach (PlnSteelforOrdNewEntityAndMerge data in listSource.Where(p => !string.IsNullOrEmpty(p.MergeNo)))
  90. {
  91. data.MergeList = listSource2.Where(p => p.MergeNo == data.MergeNo).Select(p =>
  92. {
  93. p.Furnaceno = data.Furnaceno;
  94. p.Sequenceno = data.Sequenceno;
  95. return p;
  96. }).ToList();
  97. }
  98. }
  99. return listSource;
  100. }
  101. private void ugOrder_CellChange(object sender, Infragistics.Win.UltraWinGrid.CellEventArgs e)
  102. {
  103. try
  104. {
  105. (sender as UltraGrid).UpdateData();
  106. if (e.Cell.Column.Key.Equals("ChangeNum"))
  107. {
  108. if (e.Cell.Value == null || string.IsNullOrEmpty(e.Cell.Value.ToString())) e.Cell.Row.Cells["ChangeWeight"].Value = null;
  109. else if (long.Parse(e.Cell.Value.ToString()) >=long.Parse(e.Cell.Row.Cells["TotMumM"].Value.ToString()))
  110. {
  111. e.Cell.Row.Cells["ChangeNum"].Value = e.Cell.Row.Cells["TotMumM"].Value;
  112. e.Cell.Row.Cells["ChangeWeight"].Value = e.Cell.Row.Cells["TotWeightM"].Value;
  113. }
  114. else
  115. {
  116. e.Cell.Row.Cells["ChangeWeight"].Value = double.Parse(e.Cell.Value.ToString()) *
  117. double.Parse(e.Cell.Row.Cells["WeightGpOne"].Value.ToString()) * double.Parse(e.Cell.Row.Cells["CutNumGp"].Value.ToString());
  118. }
  119. }
  120. if (e.Cell.Column.Key.Equals("ChangeWeight"))
  121. {
  122. if (e.Cell.Value == null || string.IsNullOrEmpty(e.Cell.Value.ToString())) e.Cell.Row.Cells["ChangeNum"].Value = null;
  123. else if (double.Parse(e.Cell.Value.ToString()) - double.Parse(e.Cell.Row.Cells["TotWeightM"].Value.ToString()) <0.001)
  124. {
  125. e.Cell.Row.Cells["ChangeNum"].Value = e.Cell.Row.Cells["TotMumM"].Value;
  126. e.Cell.Row.Cells["ChangeWeight"].Value = e.Cell.Row.Cells["TotWeightM"].Value;
  127. }
  128. else
  129. {
  130. e.Cell.Row.Cells["ChangeNum"].Value = Math.Ceiling(double.Parse(e.Cell.Value.ToString()) /
  131. (double.Parse(e.Cell.Row.Cells["WeightGpOne"].Value.ToString()) * double.Parse(e.Cell.Row.Cells["CutNumGp"].Value.ToString())));
  132. }
  133. }
  134. if (e.Cell.Row.HasParent())
  135. {
  136. long sum = e.Cell.Row.ParentCollection.Select(p => p.Cells["ChangeNum"].Value == null || string.IsNullOrEmpty(p.Cells["ChangeNum"].Value.ToString()) ? 0 : long.Parse(p.Cells["ChangeNum"].Value.ToString())).Sum();
  137. if (sum <= 0)
  138. {
  139. e.Cell.Row.ParentRow.Cells["ChangeNum"].Value = null;
  140. e.Cell.Row.ParentRow.Cells["ChangeWeight"].Value = null;
  141. }
  142. else
  143. {
  144. e.Cell.Row.ParentRow.Cells["ChangeNum"].Value = sum;
  145. e.Cell.Row.ParentRow.Cells["ChangeWeight"].Value = sum *
  146. double.Parse(e.Cell.Row.Cells["WeightGpOne"].Value.ToString()) * double.Parse(e.Cell.Row.Cells["CutNumGp"].Value.ToString());
  147. }
  148. }
  149. }
  150. catch (Exception)
  151. {
  152. }
  153. try
  154. {
  155. if (e.Cell.Row.HasParent())
  156. {
  157. e.Cell.Row.ParentRow.Cells["CHC"].Value = e.Cell.Row.ParentRow.Cells["ChangeNum"].Value != null &&
  158. !string.IsNullOrEmpty(
  159. e.Cell.Row.ParentRow.Cells["ChangeNum"].Value.ToString
  160. ());
  161. }
  162. else
  163. {
  164. e.Cell.Row.Cells["CHC"].Value = e.Cell.Row.Cells["ChangeNum"].Value != null &&
  165. !string.IsNullOrEmpty(
  166. e.Cell.Row.Cells["ChangeNum"].Value.ToString
  167. ());
  168. }
  169. }
  170. catch (Exception)
  171. {
  172. }
  173. }
  174. private void ugOrder_InitializeRow(object sender, InitializeRowEventArgs e)
  175. {
  176. var PlnSteelforOrdNewEntityAndMerge = e.Row.ListObject as PlnSteelforOrdNewEntityAndMerge;
  177. if (PlnSteelforOrdNewEntityAndMerge != null && PlnSteelforOrdNewEntityAndMerge.MergeList!=null && PlnSteelforOrdNewEntityAndMerge.MergeList.Any())
  178. {
  179. e.Row.Cells["ChangeNum"].Activation = Activation.ActivateOnly;
  180. e.Row.Cells["ChangeNum"].IgnoreRowColActivation = true;
  181. e.Row.Cells["ChangeNum"].Appearance.ResetBackColor();
  182. e.Row.Cells["ChangeWeight"].Activation = Activation.ActivateOnly;
  183. e.Row.Cells["ChangeWeight"].IgnoreRowColActivation = true;
  184. e.Row.Cells["ChangeWeight"].Appearance.ResetBackColor();
  185. }
  186. }
  187. private void btnDown_Click(object sender, EventArgs e)
  188. {
  189. Change(ugOrder, ugOrder2);
  190. }
  191. private void btnUp_Click(object sender, EventArgs e)
  192. {
  193. Change(ugOrder2, ugOrder);
  194. }
  195. private void Change(UltraGrid ug1, UltraGrid ug2)
  196. {
  197. var rows = ug1.Rows.Where(p => (bool) p.Cells["CHC"].Value).ToList();
  198. if (rows.Count <= 0)
  199. {
  200. MessageUtil.ShowWarning("请选择需要转分切订单!");
  201. return;
  202. }
  203. if (rows.Any(p => p.Cells["ChangeNum"].Value == null || p.Cells["ChangeWeight"].Value == null
  204. || int.Parse(p.Cells["ChangeNum"].Value.ToString()) == 0 || double.Parse(p.Cells["ChangeWeight"].Value.ToString()) < 0.0001))
  205. {
  206. MessageUtil.ShowWarning("请选择需要转分切订单的支数或者重量!");
  207. return;
  208. }
  209. BindingSource bs1 = ug1.DataSource as BindingSource;
  210. BindingSource bs2 = ug2.DataSource as BindingSource;
  211. if (bs1 == null || bs2 == null)
  212. {
  213. MessageUtil.ShowWarning("数据源异常!");
  214. return;
  215. }
  216. List<PlnSteelforOrdNewEntityAndMerge> OriginSourceEntity = bs1.DataSource as List<PlnSteelforOrdNewEntityAndMerge>;
  217. List<PlnSteelforOrdNewEntityAndMerge> TargetSourceEntity = bs2.DataSource as List<PlnSteelforOrdNewEntityAndMerge>;
  218. if(OriginSourceEntity==null || TargetSourceEntity==null)
  219. {
  220. MessageUtil.ShowWarning("数据源异常!");
  221. return;
  222. }
  223. foreach (UltraGridRow row in rows)
  224. {
  225. row.Cells["CHC"].Value = false;
  226. PlnSteelforOrdNewEntityAndMerge PlnSteelforOrdNewEntityAndMerge =
  227. row.ListObject as PlnSteelforOrdNewEntityAndMerge;
  228. PlnSteelforOrdNewEntityAndMerge NeedChange = new PlnSteelforOrdNewEntityAndMerge();
  229. if(PlnSteelforOrdNewEntityAndMerge==null) continue;
  230. int Num =row.Cells["ChangeNum"].Value==null?0: int.Parse(row.Cells["ChangeNum"].Value.ToString());
  231. int ToltalNum = (int) PlnSteelforOrdNewEntityAndMerge.TotMumM;
  232. double ToltalWeight = (double)PlnSteelforOrdNewEntityAndMerge.TotMumM;
  233. double Weight = row.Cells["ChangeWeight"].Value == null ? 0 : Num == ToltalNum ? ToltalWeight : (Num * (double)PlnSteelforOrdNewEntityAndMerge.WeightM);
  234. row.Cells["ChangeNum"].Value = null;
  235. row.Cells["ChangeWeight"].Value = null;
  236. if (Num> ToltalNum)
  237. {
  238. MessageUtil.ShowWarning("输入的转分切支数需要小于总支数!");
  239. return;
  240. }
  241. else if (Num ==ToltalNum)
  242. {
  243. NeedChange = PlnSteelforOrdNewEntityAndMerge;
  244. OriginSourceEntity.Remove(PlnSteelforOrdNewEntityAndMerge);
  245. }
  246. else
  247. {
  248. NeedChange = PlnSteelforOrdNewEntityAndMerge.Clone() as PlnSteelforOrdNewEntityAndMerge;
  249. if (row.ChildBands[0].Rows.Any())
  250. {
  251. List<PlnSteelforMergeEntity> newMergeList = new List<PlnSteelforMergeEntity>();
  252. List<PlnSteelforMergeEntity> oldMergeList = new List<PlnSteelforMergeEntity>();
  253. foreach (UltraGridRow childRow in row.GetChild(ChildRow.First).ParentCollection)
  254. {
  255. PlnSteelforMergeEntity PlnSteelforMergeEntity =
  256. childRow.ListObject as PlnSteelforMergeEntity;
  257. if(PlnSteelforMergeEntity==null) continue;
  258. int childNum = childRow.Cells["ChangeNum"].Value == null || string.IsNullOrEmpty(childRow.Cells["ChangeNum"].Value.ToString())? 0 : int.Parse(childRow.Cells["ChangeNum"].Value.ToString());
  259. int childToltalNum = (int)PlnSteelforMergeEntity.TotMumM;
  260. double childToltaWeight = (double)PlnSteelforMergeEntity.TotWeightM;
  261. double childWeight = childRow.Cells["ChangeWeight"].Value == null || string.IsNullOrEmpty(childRow.Cells["ChangeWeight"].Value.ToString()) ? 0 :
  262. childNum == childToltalNum ? childToltaWeight : (childNum * (double)PlnSteelforMergeEntity.WeightGpOne * (double)PlnSteelforMergeEntity.CutNumGp);
  263. childRow.Cells["ChangeNum"].Value =null;
  264. childRow.Cells["ChangeWeight"].Value = null;
  265. PlnSteelforMergeEntity.TotMumM = childToltalNum - childNum;
  266. PlnSteelforMergeEntity.TotWeightM = (childToltaWeight - childWeight);
  267. PlnSteelforMergeEntity PlnSteelforMergeEntityClone = PlnSteelforMergeEntity.Clone() as PlnSteelforMergeEntity;
  268. PlnSteelforMergeEntityClone.TotMumM = childNum;
  269. PlnSteelforMergeEntityClone.TotWeightM = childWeight;
  270. if(PlnSteelforMergeEntity.TotMumM>0)
  271. oldMergeList.Add(PlnSteelforMergeEntity);
  272. if(PlnSteelforMergeEntityClone.TotMumM>0)
  273. newMergeList.Add(PlnSteelforMergeEntityClone);
  274. }
  275. NeedChange.MergeList = newMergeList;
  276. PlnSteelforOrdNewEntityAndMerge.MergeList = oldMergeList;
  277. PlnSteelforOrdNewEntityAndMerge.Update();
  278. NeedChange.Update();
  279. if (PlnSteelforOrdNewEntityAndMerge.MergeList != null &&
  280. PlnSteelforOrdNewEntityAndMerge.MergeList.Count > 0
  281. && NeedChange.MergeList != null && NeedChange.MergeList.Count > 0)
  282. {
  283. NeedChange.MergeNo = "NEW";
  284. }
  285. }
  286. else
  287. {
  288. NeedChange.TotMumM = Num;
  289. NeedChange.TotWeightM = Weight;
  290. PlnSteelforOrdNewEntityAndMerge.TotMumM = PlnSteelforOrdNewEntityAndMerge.TotMumM - Num;
  291. PlnSteelforOrdNewEntityAndMerge.TotWeightM = PlnSteelforOrdNewEntityAndMerge.TotWeightM -
  292. Weight;
  293. if (PlnSteelforOrdNewEntityAndMerge.TotMumM==0) OriginSourceEntity.Remove(PlnSteelforOrdNewEntityAndMerge);
  294. }
  295. }
  296. bool bMerge = false;
  297. if (NeedChange.Surplusflag == "0")
  298. {
  299. if (TargetSourceEntity.Any(
  300. p =>
  301. p.LenGpSingle == NeedChange.LenGpSingle &&
  302. p.LengthM == NeedChange.LengthM &&
  303. p.GowhereName == NeedChange.GowhereName))
  304. {
  305. bMerge = MessageUtil.ShowYesNoAndTips("有同定尺,同去向订单,是否合并") == DialogResult.Yes;
  306. }
  307. if (bMerge)
  308. {
  309. List<PlnSteelforOrdNewEntityAndMerge> plnSteelforOrdNewEntityAndMergeList =
  310. TargetSourceEntity.Where(p => p.LenGpSingle == NeedChange.LenGpSingle &&
  311. p.LengthM == NeedChange.LengthM &&
  312. p.GowhereName == NeedChange.GowhereName).ToList();
  313. if (plnSteelforOrdNewEntityAndMergeList.Any())
  314. {
  315. var plnSteelforOrdNewEntityAndMerge1 =
  316. plnSteelforOrdNewEntityAndMergeList.FirstOrDefault(
  317. p => p.ProPlanId == NeedChange.ProPlanId && p.GxPlanNo == NeedChange.GxPlanNo);
  318. if (plnSteelforOrdNewEntityAndMerge1 == null)
  319. {
  320. plnSteelforOrdNewEntityAndMerge1 =
  321. plnSteelforOrdNewEntityAndMergeList.FirstOrDefault(
  322. p => p.MergeList != null && p.MergeList.Any(q => q.ProPlanId == NeedChange.ProPlanId &&
  323. q.GxPlanNo == NeedChange.GxPlanNo));
  324. if (plnSteelforOrdNewEntityAndMerge1 == null)
  325. {
  326. plnSteelforOrdNewEntityAndMerge1 =
  327. plnSteelforOrdNewEntityAndMergeList.FirstOrDefault();
  328. }
  329. }
  330. if (plnSteelforOrdNewEntityAndMerge1 != null)
  331. plnSteelforOrdNewEntityAndMerge1.Merge(NeedChange);
  332. }
  333. }
  334. else
  335. {
  336. TargetSourceEntity.Add(NeedChange);
  337. }
  338. }
  339. else
  340. {
  341. TargetSourceEntity.Add(NeedChange);
  342. }
  343. }
  344. bs1.ResetBindings(false);
  345. bs2.ResetBindings(false);
  346. GridHelper.RefreshAndAutoSize(ug1);
  347. GridHelper.RefreshAndAutoSize(ug2);
  348. ug1.Rows.ExpandAll(true);
  349. ug2.Rows.ExpandAll(true);
  350. //plnSteelforOrdNewEntityBindingSource1.DataSource = OriginSourceEntity;
  351. /* bs1.Clear();
  352. bs1.DataSource = OriginSourceEntity;
  353. bs2.DataSource = TargetSourceEntity;*/
  354. }
  355. private void ultraToolbarsManager1_ToolClick(object sender, Infragistics.Win.UltraWinToolbars.ToolClickEventArgs e)
  356. {
  357. switch (e.Tool.Key)
  358. {
  359. case "Refresh": // ButtonTool
  360. Reresh();
  361. break;
  362. case "Close": // ButtonTool
  363. DialogResult = DialogResult.Cancel;
  364. // Place code here
  365. break;
  366. case "Query": // ButtonTool
  367. if (MessageUtil.ShowYesNoAndQuestion("是否确认转分切!") ==
  368. DialogResult.No)
  369. return;
  370. List<PlnSteelforOrdNewEntityAndMerge> OriginSourceEntity = plnSteelforOrdNewEntityBindingSource1.DataSource as List<PlnSteelforOrdNewEntityAndMerge>;
  371. List<PlnSteelforOrdNewEntityAndMerge> TargetSourceEntity = plnSteelforOrdNewEntityBindingSource2.DataSource as List<PlnSteelforOrdNewEntityAndMerge>;
  372. OriginSourceEntity.ForEach(p=>p.UpdateSaveData());
  373. TargetSourceEntity.ForEach(p=>p.UpdateSaveData());
  374. var param =
  375. SteelHelper.SetData(
  376. "com.steering.pss.plnsaleord.steelMarkingPlan.FrmSteelManagement.ChangeOrderPlan", new object[]
  377. {
  378. Furnaceno1, OriginSourceEntity,Furnaceno2, TargetSourceEntity
  379. , UserInfo.GetUserName()
  380. }, ob);
  381. if (param != null)
  382. {
  383. DialogResult = DialogResult.OK;
  384. }
  385. break;
  386. }
  387. }
  388. }
  389. }