FrmDeleteMatBcM.cs 40 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977
  1. using Core.Mes.Client.Comm.Control;
  2. using Core.Mes.Client.Comm.Format;
  3. using Core.Mes.Client.Comm.Server;
  4. using Core.Mes.Client.Comm.Tool;
  5. using Core.StlMes.Client.YdmBcPipeManage.Entity;
  6. using CoreFS.CA06;
  7. using Infragistics.Win;
  8. using Infragistics.Win.UltraWinEditors;
  9. using Infragistics.Win.UltraWinGrid;
  10. using System;
  11. using System.Collections;
  12. using System.Collections.Generic;
  13. using System.ComponentModel;
  14. using System.Data;
  15. using System.Drawing;
  16. using System.Linq;
  17. using System.Text;
  18. using System.Windows.Forms;
  19. namespace Core.StlMes.Client.YdmBcPipeManage
  20. {
  21. public partial class FrmDeleteMatBcM : FrmBase
  22. {
  23. public FrmDeleteMatBcM()
  24. {
  25. InitializeComponent();
  26. this.IsLoadUserView = true;
  27. }
  28. private void FrmDeleteMatBcM_Load(object sender, EventArgs e)
  29. {
  30. DateTime d1 = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1);
  31. this.StartTime.Value = DateTime.Parse(DateTime.Now.ToString("yyyy-MM"));
  32. EntityHelper.ShowGridCaption<MatBcMEntity1>(ultraGrid1.DisplayLayout.Bands[0]);
  33. EntityHelper.ShowGridCaption<YdmBcScrapoutlistEntity>(ultraGrid2.DisplayLayout.Bands[0]);
  34. EntityHelper.ShowGridCaption<YdmBcOutlistEntity>(ultraGrid3.DisplayLayout.Bands[0]);
  35. initStorageNo();
  36. initReasonInfo();
  37. initPline();
  38. initBelong();
  39. EntityHelper.setColumnShowOrHidden(ultraGrid1, new string[] { "Reason", "DelvryEdate" }, false);//显示列
  40. }
  41. DataTable reasonDT = null;
  42. /// <summary>
  43. /// 加载所属权
  44. /// </summary>
  45. private void initBelong()
  46. {
  47. DataTable ds = ServerHelper.GetData("com.steering.ydm.bc.FrmDeleteMatBcM.doQueryBelong", new object[] { }, ob);
  48. if (ds.Rows.Count > 0)
  49. {
  50. this.cmbBelong.DataSource = ds;
  51. cmbBelong.DisplayMember = "BELONG_NAME";
  52. cmbBelong.ValueMember = "BELONG_CODE";
  53. }
  54. }
  55. /// <summary>
  56. /// 加载产线
  57. /// </summary>
  58. private void initPline()
  59. {
  60. DataTable ds = ServerHelper.GetData("com.steering.ydm.bc.FrmDeleteMatBcM.doPline", new object[] { }, ob);
  61. if (ds.Rows.Count > 0)
  62. {
  63. this.cheBelongCode.DataSource = ds;
  64. cheBelongCode.DisplayMember = "PLINE_NAME";
  65. cheBelongCode.ValueMember = "PLINE_CODE";
  66. }
  67. }
  68. /// <summary>
  69. /// 加载仓库
  70. /// </summary>
  71. private void initStorageNo()
  72. {
  73. BaseMethod.InitStorageNo(cmbStorageNo, ob);
  74. BaseMethod.InitStorageNo(cmbLoadStorage, ob);
  75. DataTable ds = ServerHelper.GetData("com.steering.ydm.bc.FrmDeleteMatBcM.doQueryDepartM", new object[] { }, ob);
  76. if (ds.Rows.Count > 0)
  77. {
  78. this.cmbDepartMent.DataSource = ds;
  79. cmbDepartMent.DisplayMember = "DEPARTMENT_NAME_P";
  80. cmbDepartMent.ValueMember = "DEPARTMENT_CODE_P";
  81. }
  82. }
  83. /// <summary>
  84. /// 离线原因
  85. /// </summary>
  86. private void initReasonInfo()
  87. {
  88. reasonDT = ServerHelper.GetData("com.steering.ydm.bc.FrmDeleteMatBcM.doQueryReason", new object[] { }, ob);
  89. if (reasonDT.Rows.Count > 0)
  90. {
  91. this.cheReason.DataSource = reasonDT;
  92. cheReason.DisplayMember = "REASON_NAME3";
  93. cheReason.ValueMember = "REASON_CODE3";
  94. }
  95. }
  96. /// <summary>
  97. /// 重写基类方法
  98. /// </summary>
  99. /// <param name="sender"></param>
  100. /// <param name="ToolbarKey"></param>
  101. public override void ToolBar_Click(object sender, string ToolbarKey)
  102. {
  103. switch (ToolbarKey)
  104. {
  105. case "DoQuery":
  106. doQuery();
  107. break;
  108. case "Delete":
  109. deleteMatBcMData();
  110. break;
  111. case"TakeBill":
  112. takeBill();
  113. break;
  114. case"LoadMat":
  115. loadMatData();
  116. break;
  117. case"AdjustStorage":
  118. adjustStorageNo();
  119. break;
  120. case"SetUpIntial":
  121. setUpIntial();
  122. break;
  123. case"UpdateMaterial":
  124. updateMaterial();
  125. break;
  126. case"UpdateMemo":
  127. updateMemo();
  128. break;
  129. case "UpdateReason":
  130. updateReason();
  131. break;
  132. case"ScrapOut":
  133. scrapOut();
  134. break;
  135. case"CancelScrapOut":
  136. cancelScrapOut();
  137. break;
  138. case"CancelScrapJudgeNo":
  139. cancelScrapJudgeNo();
  140. break;
  141. case"UpdatePorssWgt":
  142. updatePorssWgt();;
  143. break;
  144. case"BelongResponse":
  145. belongResponse();
  146. break;
  147. case "UpdateBelongResponse":
  148. UpdateBelongResponse();
  149. break;
  150. case"UpdateFlagStoveNo":
  151. updateFlagStoveNo();
  152. break;
  153. case "Export":
  154. exportData();
  155. break;
  156. case "Close":
  157. this.Close();
  158. break;
  159. }
  160. }
  161. /// <summary>
  162. /// 脱单成余材
  163. /// </summary>
  164. private void takeBill()
  165. {
  166. this.ultraGrid1.UpdateData();
  167. IQueryable<UltraGridRow> checkMagRows = this.ultraGrid1.Rows.AsQueryable().Where(" CHK = 'True'");
  168. if (checkMagRows.Count() == 0)
  169. {
  170. MessageUtil.ShowTips("请选择需要置余材的库存信息!");
  171. return;
  172. }
  173. ArrayList parmList = new ArrayList();
  174. foreach (UltraGridRow row in checkMagRows)
  175. {
  176. MatBcMEntity1 matBcTity = (MatBcMEntity1)row.ListObject;
  177. if (matBcTity.QcmStaus.Equals("判废") || matBcTity.QcmStaus.Equals("待处理"))
  178. {
  179. MessageUtil.ShowTips("只有合格品才能置余材!");
  180. return;
  181. }
  182. string matBcEntity = JSONFormat.Format(matBcTity);
  183. parmList.Add(matBcEntity);
  184. }
  185. CoreClientParam ccp = new CoreClientParam();
  186. ccp.ServerName = "com.steering.ydm.bc.FrmDeleteMatBcM";
  187. ccp.MethodName = "takeBill";
  188. ccp.ServerParams = new object[] { parmList };
  189. ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
  190. if (ccp.ReturnCode != -1)
  191. {
  192. if (ccp.ReturnInfo.Equals("置余材成功!"))
  193. {
  194. doQuery();
  195. MessageUtil.ShowTips(ccp.ReturnInfo);
  196. }
  197. else
  198. {
  199. MessageUtil.ShowTips(ccp.ReturnInfo);
  200. }
  201. }
  202. }
  203. /// <summary>
  204. /// 撤销废品出库(逐炉)
  205. /// </summary>
  206. private void cancelScrapJudgeNo()
  207. {
  208. this.ultraGrid3.UpdateData();
  209. IQueryable<UltraGridRow> checkMagRows = this.ultraGrid3.Rows.AsQueryable().Where(" CHK = 'True'");
  210. if (checkMagRows.Count() == 0)
  211. {
  212. MessageUtil.ShowTips("请选择需要撤销的出库信息!");
  213. return;
  214. }
  215. ArrayList parmList = new ArrayList();
  216. foreach (UltraGridRow row in checkMagRows)
  217. {
  218. YdmBcOutlistEntity ydmTity = (YdmBcOutlistEntity)row.ListObject;
  219. string ydmEntity = JSONFormat.Format(ydmTity);
  220. parmList.Add(ydmEntity);
  221. }
  222. CoreClientParam ccp = new CoreClientParam();
  223. ccp.ServerName = "com.steering.ydm.bc.FrmDeleteMatBcM";
  224. ccp.MethodName = "cancelScrapJudgeNo";
  225. ccp.ServerParams = new object[] { parmList, UserInfo.GetUserName() };
  226. ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
  227. if (ccp.ReturnCode != -1)
  228. {
  229. if (ccp.ReturnInfo.Equals("撤销成功!"))
  230. {
  231. doQuery();
  232. MessageUtil.ShowTips(ccp.ReturnInfo);
  233. }
  234. else
  235. {
  236. MessageUtil.ShowTips(ccp.ReturnInfo);
  237. }
  238. }
  239. }
  240. /// <summary>
  241. /// 撤销废品出库(整单)
  242. /// </summary>
  243. private void cancelScrapOut()
  244. {
  245. this.ultraGrid2.UpdateData();
  246. IQueryable<UltraGridRow> checkMagRows = this.ultraGrid2.Rows.AsQueryable().Where(" CHK = 'True'");
  247. if(checkMagRows.Count() == 0)
  248. {
  249. MessageUtil.ShowTips("请选择需要撤销的出库单!");
  250. return;
  251. }
  252. ArrayList parmList = new ArrayList();
  253. foreach(UltraGridRow row in checkMagRows)
  254. {
  255. YdmBcScrapoutlistEntity ydmTity = (YdmBcScrapoutlistEntity)row.ListObject;
  256. string ydmEntity = JSONFormat.Format(ydmTity);
  257. parmList.Add(ydmEntity);
  258. }
  259. CoreClientParam ccp = new CoreClientParam();
  260. ccp.ServerName = "com.steering.ydm.bc.FrmDeleteMatBcM";
  261. ccp.MethodName = "cancelScrapOut";
  262. ccp.ServerParams = new object[] { parmList,UserInfo.GetUserName() };
  263. ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
  264. if (ccp.ReturnCode != -1)
  265. {
  266. if (ccp.ReturnInfo.Equals("撤销成功!"))
  267. {
  268. doQuery();
  269. MessageUtil.ShowTips(ccp.ReturnInfo);
  270. }
  271. else
  272. {
  273. MessageUtil.ShowTips(ccp.ReturnInfo);
  274. }
  275. }
  276. }
  277. /// <summary>
  278. /// 责任单位划分
  279. /// </summary>
  280. private void belongResponse()
  281. {
  282. this.ultraGrid3.UpdateData();
  283. IQueryable<UltraGridRow> checkMagRows = this.ultraGrid3.Rows.AsQueryable().Where(" CHK = 'True'");
  284. if (checkMagRows.Count() == 0)
  285. {
  286. MessageUtil.ShowTips("请选择需要修改责任单位的废品信息!");
  287. return;
  288. }
  289. ArrayList parmList = new ArrayList();
  290. foreach (UltraGridRow row in checkMagRows)
  291. {
  292. YdmBcOutlistEntity ydmTity = (YdmBcOutlistEntity)row.ListObject;
  293. ydmTity.BelongCodeResponse = row.Cells["BelongCodeResponse"].Value.ToString();
  294. ydmTity.BelongNameResponse = row.Cells["BelongCodeResponse"].Text;
  295. string ydmEntity = JSONFormat.Format(ydmTity);
  296. parmList.Add(ydmEntity);
  297. }
  298. CoreClientParam ccp = new CoreClientParam();
  299. ccp.ServerName = "com.steering.ydm.bc.FrmDeleteMatBcM";
  300. ccp.MethodName = "belongResponse";
  301. ccp.ServerParams = new object[] { parmList };
  302. ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
  303. if (ccp.ReturnCode != -1)
  304. {
  305. if (ccp.ReturnInfo.Equals("修改成功!"))
  306. {
  307. doQuery();
  308. MessageUtil.ShowTips(ccp.ReturnInfo);
  309. }
  310. else
  311. {
  312. MessageUtil.ShowTips(ccp.ReturnInfo);
  313. }
  314. }
  315. }
  316. /// <summary>
  317. /// 回报过磅重量
  318. /// </summary>
  319. private void updatePorssWgt()
  320. {
  321. this.ultraGrid2.UpdateData();
  322. IQueryable<UltraGridRow> checkMagRows = this.ultraGrid2.Rows.AsQueryable().Where(" CHK = 'True'");
  323. if (checkMagRows.Count() == 0)
  324. {
  325. MessageUtil.ShowTips("请选择需要回报过磅量的废品信息!");
  326. return;
  327. }
  328. ArrayList parmList = new ArrayList();
  329. foreach(UltraGridRow row in checkMagRows)
  330. {
  331. YdmBcScrapoutlistEntity ydmScrapTity = (YdmBcScrapoutlistEntity)row.ListObject;
  332. if(ydmScrapTity.PonderGrossWt.ToString3() == "")
  333. {
  334. MessageUtil.ShowTips("过磅量不能为空!");
  335. return;
  336. }
  337. string ydmScrapEntity = JSONFormat.Format(ydmScrapTity);
  338. parmList.Add(ydmScrapEntity);
  339. }
  340. CoreClientParam ccp = new CoreClientParam();
  341. ccp.ServerName = "com.steering.ydm.bc.FrmDeleteMatBcM";
  342. ccp.MethodName = "updatePorssWgt";
  343. ccp.ServerParams = new object[] { parmList };
  344. ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
  345. if (ccp.ReturnCode != -1)
  346. {
  347. if (ccp.ReturnInfo.Equals("回报成功!"))
  348. {
  349. doQuery();
  350. MessageUtil.ShowTips(ccp.ReturnInfo);
  351. }
  352. else
  353. {
  354. MessageUtil.ShowTips(ccp.ReturnInfo);
  355. }
  356. }
  357. }
  358. /// <summary>
  359. /// 废品出库
  360. /// </summary>
  361. private void scrapOut()
  362. {
  363. this.ultraGrid1.UpdateData();
  364. IQueryable<UltraGridRow> checkMagRows = this.ultraGrid1.Rows.AsQueryable().Where(" CHK = 'True'");
  365. if (checkMagRows.Count() == 0)
  366. {
  367. MessageUtil.ShowTips("请选择需要出库的废品信息!");
  368. return;
  369. }
  370. int belongNum = checkMagRows.GroupBy(p => p.GetValue("BelongCode")).Count();
  371. if (belongNum > 1)
  372. {
  373. MessageUtil.ShowTips("废品出库时只能同所属权单位才能成一单!");
  374. return;
  375. }
  376. int flagStoveNoCount = checkMagRows.GroupBy(p => p.GetValue("FlagStoveNoZg")).Count();
  377. if (flagStoveNoCount > 1)
  378. {
  379. MessageUtil.ShowTips("不同标识炉号的信息,不允许出库成一单!");
  380. return;
  381. }
  382. if (this.cmbLoadStorage.Text == "")
  383. {
  384. MessageUtil.ShowTips("废品出库请选择去向!");
  385. return;
  386. }
  387. ArrayList parmList = new ArrayList();
  388. foreach (UltraGridRow row in checkMagRows)
  389. {
  390. MatBcMEntity1 matBcTity = (MatBcMEntity1)row.ListObject;
  391. if (!matBcTity.QcmStaus.Equals("判废") || !matBcTity.ScrapFrimFlag.Equals("已审核"))
  392. {
  393. MessageUtil.ShowTips("只有废品已审核判定后才允许出库,请刷新页面!");
  394. return;
  395. }
  396. string matBcEntity = JSONFormat.Format(matBcTity);
  397. parmList.Add(matBcEntity);
  398. }
  399. CoreClientParam ccp = new CoreClientParam();
  400. ccp.ServerName = "com.steering.ydm.bc.FrmDeleteMatBcM";
  401. ccp.MethodName = "scrapOut";
  402. ccp.ServerParams = new object[] { parmList,cmbLoadStorage.Value.ToString(),cmbLoadStorage.Text,UserInfo.GetUserName() };
  403. ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
  404. if (ccp.ReturnCode != -1)
  405. {
  406. if (ccp.ReturnInfo.Equals("出库成功!"))
  407. {
  408. doQuery();
  409. MessageUtil.ShowTips(ccp.ReturnInfo);
  410. }
  411. else
  412. {
  413. MessageUtil.ShowTips(ccp.ReturnInfo);
  414. }
  415. }
  416. }
  417. /// <summary>
  418. /// 修改备注
  419. /// </summary>
  420. private void updateMemo()
  421. {
  422. this.ultraGrid1.UpdateData();
  423. IQueryable<UltraGridRow> checkMagRows = this.ultraGrid1.Rows.AsQueryable().Where(" CHK = 'True'");
  424. if (checkMagRows.Count() == 0)
  425. {
  426. MessageUtil.ShowTips("请选择需要修改的库存信息!");
  427. return;
  428. }
  429. ArrayList parmList = new ArrayList();
  430. foreach (UltraGridRow row in checkMagRows)
  431. {
  432. MatBcMEntity1 matBcEntity = (MatBcMEntity1)row.ListObject;
  433. string matBcTity = JSONFormat.Format(matBcEntity);
  434. parmList.Add(matBcTity);
  435. }
  436. CoreClientParam ccp = new CoreClientParam();
  437. ccp.ServerName = "com.steering.ydm.bc.FrmDeleteMatBcM";
  438. ccp.MethodName = "updateMemo";
  439. ccp.ServerParams = new object[] { parmList };
  440. ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
  441. if (ccp.ReturnCode != -1)
  442. {
  443. if (ccp.ReturnInfo.Equals("修改成功!"))
  444. {
  445. doQuery();
  446. MessageUtil.ShowTips(ccp.ReturnInfo);
  447. }
  448. else
  449. {
  450. MessageUtil.ShowTips(ccp.ReturnInfo);
  451. }
  452. }
  453. }
  454. /// <summary>
  455. /// 修改离线原因
  456. /// </summary>
  457. private void updateReason()
  458. {
  459. this.ultraGrid1.UpdateData();
  460. IQueryable<UltraGridRow> checkMagRows = this.ultraGrid1.Rows.AsQueryable().Where(" CHK = 'True'");
  461. if (checkMagRows.Count() == 0)
  462. {
  463. MessageUtil.ShowTips("请选择需要修改的库存信息!");
  464. return;
  465. }
  466. ArrayList parmList = new ArrayList();
  467. foreach (UltraGridRow row in checkMagRows)
  468. {
  469. MatBcMEntity1 matBcEntity = (MatBcMEntity1)row.ListObject;
  470. if (matBcEntity.QcmStaus != "待处理")
  471. {
  472. MessageUtil.ShowTips("请选择缴库状态为待处理的库存信息!");
  473. return;
  474. }
  475. MatBcMEntity4 matBcMEntity4 = new MatBcMEntity4();
  476. ClsLoad.CopyModel(matBcEntity, matBcMEntity4);
  477. DataRow[] reasons = reasonDT.Select("REASON_CODE3 = " + row.Cells["reason"].Value.ToString3());
  478. matBcMEntity4.Reason1 = reasons[0]["REASON_CODE1"].ToString3();
  479. matBcMEntity4.Reason2 = reasons[0]["REASON_CODE2"].ToString3();
  480. matBcMEntity4.Reason3 = reasons[0]["REASON_CODE3"].ToString3();
  481. string matBcTity = JSONFormat.Format(matBcMEntity4);
  482. parmList.Add(matBcTity);
  483. }
  484. CoreClientParam ccp = new CoreClientParam();
  485. ccp.ServerName = "com.steering.ydm.bc.FrmDeleteMatBcM";
  486. ccp.MethodName = "updateReason";
  487. ccp.ServerParams = new object[] { parmList };
  488. ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
  489. if (ccp.ReturnCode != -1)
  490. {
  491. if (ccp.ReturnInfo.Equals("修改成功!"))
  492. {
  493. doQuery();
  494. MessageUtil.ShowTips(ccp.ReturnInfo);
  495. }
  496. else
  497. {
  498. MessageUtil.ShowTips(ccp.ReturnInfo);
  499. }
  500. }
  501. }
  502. /// <summary>
  503. /// 保存责任单位
  504. /// </summary>
  505. private void UpdateBelongResponse()
  506. {
  507. this.ultraGrid1.UpdateData();
  508. IQueryable<UltraGridRow> checkMagRows = this.ultraGrid1.Rows.AsQueryable().Where(" CHK = 'True'");
  509. if (checkMagRows.Count() == 0)
  510. {
  511. MessageUtil.ShowTips("请选择需要修改的库存信息!");
  512. return;
  513. }
  514. ArrayList parmList = new ArrayList();
  515. foreach (UltraGridRow row in checkMagRows)
  516. {
  517. MatBcMEntity1 matBcEntity = (MatBcMEntity1)row.ListObject;
  518. if (matBcEntity.QcmStaus != "待处理")
  519. {
  520. MessageUtil.ShowTips("请选择缴库状态为待处理的库存信息!");
  521. return;
  522. }
  523. matBcEntity.BelongNameResponse = row.Cells["BelongCodeResponse"].Text.ToString3();
  524. matBcEntity.BelongCodeResponse = row.Cells["BelongCodeResponse"].Value.ToString3();
  525. string matBcTity = JSONFormat.Format(matBcEntity);
  526. parmList.Add(matBcTity);
  527. }
  528. CoreClientParam ccp = new CoreClientParam();
  529. ccp.ServerName = "com.steering.ydm.bc.FrmDeleteMatBcM";
  530. ccp.MethodName = "updateBelongCodeResponse";
  531. ccp.ServerParams = new object[] { parmList };
  532. ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
  533. if (ccp.ReturnCode != -1)
  534. {
  535. if (ccp.ReturnInfo.Equals("修改成功!"))
  536. {
  537. doQuery();
  538. MessageUtil.ShowTips(ccp.ReturnInfo);
  539. }
  540. else
  541. {
  542. MessageUtil.ShowTips(ccp.ReturnInfo);
  543. }
  544. }
  545. }
  546. /// <summary>
  547. /// 修改物料
  548. /// </summary>
  549. private void updateMaterial()
  550. {
  551. this.ultraGrid1.UpdateData();
  552. IQueryable<UltraGridRow> checkMagRows = this.ultraGrid1.Rows.AsQueryable().Where(" CHK = 'True'");
  553. if (checkMagRows.Count() == 0)
  554. {
  555. MessageUtil.ShowTips("请选择需要修改的库存信息!");
  556. return;
  557. }
  558. ArrayList parmList = new ArrayList();
  559. foreach(UltraGridRow row in checkMagRows)
  560. {
  561. MatBcMEntity1 matBcEntity = (MatBcMEntity1)row.ListObject;
  562. string matBcTity = JSONFormat.Format(matBcEntity);
  563. parmList.Add(matBcTity);
  564. }
  565. CoreClientParam ccp = new CoreClientParam();
  566. ccp.ServerName = "com.steering.ydm.bc.FrmDeleteMatBcM";
  567. ccp.MethodName = "updateMaterial";
  568. ccp.ServerParams = new object[] { parmList,UserInfo.GetUserName() };
  569. ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
  570. if (ccp.ReturnCode != -1)
  571. {
  572. if (ccp.ReturnInfo.Equals("修改成功!"))
  573. {
  574. doQuery();
  575. MessageUtil.ShowTips(ccp.ReturnInfo);
  576. }
  577. else
  578. {
  579. MessageUtil.ShowTips(ccp.ReturnInfo);
  580. }
  581. }
  582. }
  583. /// <summary>
  584. /// 建立期初
  585. /// </summary>
  586. private void setUpIntial()
  587. {
  588. CoreClientParam ccp = new CoreClientParam();
  589. ccp.ServerName = "com.steering.ydm.bc.FrmDeleteMatBcM";
  590. ccp.MethodName = "setUpIntial";
  591. ccp.ServerParams = new object[] { };
  592. ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
  593. if (ccp.ReturnCode != -1)
  594. {
  595. if (ccp.ReturnInfo.Equals("期初建立成功!"))
  596. {
  597. MessageUtil.ShowTips(ccp.ReturnInfo);
  598. }
  599. else
  600. {
  601. MessageUtil.ShowTips(ccp.ReturnInfo);
  602. }
  603. }
  604. }
  605. /// <summary>
  606. /// 导出
  607. /// </summary>
  608. private void exportData()
  609. {
  610. GridHelper.ulGridToExcel(ultraGrid1, "半成品库存数据汇总");
  611. }
  612. /// <summary>
  613. /// 查询
  614. /// </summary>
  615. private void doQuery()
  616. {
  617. string bathYear = "";
  618. string judgeNo = "";
  619. string belongCode = "";
  620. string[] belongCodes = new string[0];
  621. if(this.chkTim.Checked)
  622. {
  623. bathYear = this.StartTime.Value.ToString("yyyyMM");
  624. }
  625. if (this.chkJugeHeatNo.Checked && this.txtJugeNo.Text.Trim() != "")
  626. {
  627. judgeNo = this.txtJugeNo.Text.Trim();
  628. }
  629. if(this.chkBelong.Checked && this.cmbBelong.Text !="")
  630. {
  631. belongCode = this.cmbBelong.Value.ToString3();
  632. belongCodes = this.cmbBelong.CheckedItems.Select(p => p.DataValue.ToString()).ToArray();
  633. }
  634. ArrayList parmList = new ArrayList();
  635. parmList.Add(bathYear);
  636. parmList.Add(judgeNo);
  637. parmList.Add(belongCode);
  638. ArrayList scrapList = new ArrayList();
  639. scrapList.Add(bathYear);
  640. if(ultraTabControl1.SelectedTab.Key == "0")
  641. {
  642. List<MatBcMEntity1> listSource = EntityHelper.GetData<MatBcMEntity1>(
  643. "com.steering.ydm.bc.FrmDeleteMatBcM.doQuery", new object[] { parmList, BaseMethod.getPCodePline(this.ValidDataPurviewIds, ob), belongCodes }, this.ob);
  644. MatBcMEntity1bindingSource.DataSource = listSource;
  645. }
  646. else if (ultraTabControl1.SelectedTab.Key == "1")
  647. {
  648. List<YdmBcScrapoutlistEntity> listSource = EntityHelper.GetData<YdmBcScrapoutlistEntity>(
  649. "com.steering.ydm.bc.FrmDeleteMatBcM.doQueryScrapList", new object[] { scrapList }, this.ob);
  650. ydmBcScrapoutlistEntityBindingSource.DataSource = listSource;
  651. }
  652. }
  653. /// <summary>
  654. /// 消亡数据
  655. /// </summary>
  656. private void deleteMatBcMData()
  657. {
  658. this.ultraGrid1.UpdateData();
  659. IQueryable<UltraGridRow> checkMagRows = this.ultraGrid1.Rows.AsQueryable().Where(" CHK = 'True'");
  660. if (checkMagRows.Count() == 0)
  661. {
  662. MessageUtil.ShowTips("请选择需要消亡的库存信息!");
  663. return;
  664. }
  665. ArrayList parmList = new ArrayList();
  666. foreach (UltraGridRow row in checkMagRows)
  667. {
  668. MatBcMEntity1 matBcEntity = (MatBcMEntity1)row.ListObject;
  669. string matBcTity = JSONFormat.Format(matBcEntity);
  670. parmList.Add(matBcTity);
  671. }
  672. if (MessageUtil.ShowYesNoAndQuestion("消亡库存数据不可逆,是否继续消亡?") == DialogResult.No)
  673. {
  674. return;
  675. }
  676. CoreClientParam ccp = new CoreClientParam();
  677. ccp.ServerName = "com.steering.ydm.bc.FrmDeleteMatBcM";
  678. ccp.MethodName = "deleteMatBcMData";
  679. ccp.ServerParams = new object[] { parmList };
  680. ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
  681. if (ccp.ReturnCode != -1)
  682. {
  683. if (ccp.ReturnInfo.Equals("删除成功!"))
  684. {
  685. doQuery();
  686. MessageUtil.ShowTips(ccp.ReturnInfo);
  687. }
  688. else
  689. {
  690. MessageUtil.ShowTips(ccp.ReturnInfo);
  691. }
  692. }
  693. }
  694. /// <summary>
  695. /// 修改标识炉号
  696. /// </summary>
  697. private void updateFlagStoveNo()
  698. {
  699. this.ultraGrid1.UpdateData();
  700. IQueryable<UltraGridRow> checkMagRows = this.ultraGrid1.Rows.AsQueryable().Where(" CHK = 'True'");
  701. if (checkMagRows.Count() == 0)
  702. {
  703. MessageUtil.ShowTips("请选择需要修改标识炉号的库存信息!");
  704. return;
  705. }
  706. ArrayList parmList = new ArrayList();
  707. foreach (UltraGridRow row in checkMagRows)
  708. {
  709. MatBcMEntity1 matBcEntity = (MatBcMEntity1)row.ListObject;
  710. string matBcTity = JSONFormat.Format(matBcEntity);
  711. parmList.Add(matBcTity);
  712. }
  713. CoreClientParam ccp = new CoreClientParam();
  714. ccp.ServerName = "com.steering.ydm.bc.FrmDeleteMatBcM";
  715. ccp.MethodName = "updateFlagStoveNo";
  716. ccp.ServerParams = new object[] { parmList };
  717. ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
  718. if (ccp.ReturnCode != -1)
  719. {
  720. if (ccp.ReturnInfo.Equals("修改成功!"))
  721. {
  722. doQuery();
  723. MessageUtil.ShowTips(ccp.ReturnInfo);
  724. }
  725. else
  726. {
  727. MessageUtil.ShowTips(ccp.ReturnInfo);
  728. }
  729. }
  730. }
  731. /// <summary>
  732. /// 调整仓库位置
  733. /// </summary>
  734. private void adjustStorageNo()
  735. {
  736. this.ultraGrid1.UpdateData();
  737. IQueryable<UltraGridRow> checkMagRows = this.ultraGrid1.Rows.AsQueryable().Where(" CHK = 'True'");
  738. if (checkMagRows.Count() == 0)
  739. {
  740. MessageUtil.ShowTips("请选择需要调整位置的库存信息!");
  741. return;
  742. }
  743. if(this.cmbStorageNo.Value.ToString2() == "")
  744. {
  745. MessageUtil.ShowTips("请选择需要调整库存位置的仓库!");
  746. return;
  747. }
  748. ArrayList parmList = new ArrayList();
  749. foreach (UltraGridRow row in checkMagRows)
  750. {
  751. MatBcMEntity1 matBcEntity = (MatBcMEntity1)row.ListObject;
  752. string matBcTity = JSONFormat.Format(matBcEntity);
  753. parmList.Add(matBcTity);
  754. }
  755. CoreClientParam ccp = new CoreClientParam();
  756. ccp.ServerName = "com.steering.ydm.bc.FrmDeleteMatBcM";
  757. ccp.MethodName = "adjustStorageNo";
  758. ccp.ServerParams = new object[] { parmList,this.cmbStorageNo.Value.ToString2() };
  759. ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
  760. if (ccp.ReturnCode != -1)
  761. {
  762. if (ccp.ReturnInfo.Equals("调整成功!"))
  763. {
  764. doQuery();
  765. MessageUtil.ShowTips(ccp.ReturnInfo);
  766. }
  767. else
  768. {
  769. MessageUtil.ShowTips(ccp.ReturnInfo);
  770. }
  771. }
  772. }
  773. /// <summary>
  774. /// 上料
  775. /// </summary>
  776. private void loadMatData()
  777. {
  778. this.ultraGrid1.UpdateData();
  779. IQueryable<UltraGridRow> checkMagRows = this.ultraGrid1.Rows.AsQueryable().Where(" CHK = 'True'");
  780. if (checkMagRows.Count() == 0)
  781. {
  782. MessageUtil.ShowTips("请选择需要上料的库存信息!");
  783. return;
  784. }
  785. ArrayList parmList = new ArrayList();
  786. foreach (UltraGridRow row in checkMagRows)
  787. {
  788. MatBcMEntity1 matBcEntity = (MatBcMEntity1)row.ListObject;
  789. string matBcTity = JSONFormat.Format(matBcEntity);
  790. parmList.Add(matBcTity);
  791. }
  792. CoreClientParam ccp = new CoreClientParam();
  793. ccp.ServerName = "com.steering.ydm.bc.FrmDeleteMatBcM";
  794. ccp.MethodName = "loadMatData";
  795. ccp.ServerParams = new object[] { parmList };
  796. ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
  797. if (ccp.ReturnCode != -1)
  798. {
  799. if (ccp.ReturnInfo.Equals("上料成功!"))
  800. {
  801. doQuery();
  802. MessageUtil.ShowTips(ccp.ReturnInfo);
  803. }
  804. else
  805. {
  806. MessageUtil.ShowTips(ccp.ReturnInfo);
  807. }
  808. }
  809. }
  810. private void chkTim_CheckedChanged(object sender, EventArgs e)
  811. {
  812. this.StartTime.Enabled = this.chkTim.Checked;
  813. }
  814. private void chkJugeHeatNo_CheckedChanged(object sender, EventArgs e)
  815. {
  816. this.txtJugeNo.Enabled = this.chkJugeHeatNo.Checked;
  817. }
  818. private void chkBelong_CheckedChanged(object sender, EventArgs e)
  819. {
  820. this.cmbBelong.Enabled = this.chkBelong.Checked;
  821. }
  822. private void ultraGrid1_AfterSelectChange(object sender, AfterSelectChangeEventArgs e)
  823. {
  824. foreach (UltraGridRow uRow in ultraGrid1.Selected.Rows)
  825. {
  826. if (uRow.GetType() != typeof(Infragistics.Win.UltraWinGrid.UltraGridGroupByRow))
  827. {
  828. uRow.Cells["CHK"].Value = true;
  829. }
  830. }
  831. }
  832. private void ultraGrid1_CellChange(object sender, CellEventArgs e)
  833. {
  834. this.ultraGrid1.UpdateData();
  835. UltraGridRow row = this.ultraGrid1.ActiveRow;
  836. MatBcMEntity1 matGp = (MatBcMEntity1)row.ListObject;
  837. if (matGp.ActCount.Equals("") || matGp.ActCount == null)
  838. {
  839. matGp.ActCount = 0;
  840. }
  841. string matGpEntity = JSONFormat.Format(matGp);
  842. if (e.Cell.Column.Key == "ActCount")
  843. {
  844. DataTable ds = ServerHelper.GetData("com.steering.ydm.bc.FrmDeleteMatBcM.doQueryWeight", new object[] { matGpEntity }, ob);
  845. if (ds.Rows.Count > 0)
  846. {
  847. ultraGrid1.ActiveRow.Cells["ActWeight"].Value = ds.Rows[0][0].ToString();
  848. }
  849. }
  850. }
  851. private void cmbMaterial_EditorButtonClick(object sender, Infragistics.Win.UltraWinEditors.EditorButtonEventArgs e)
  852. {
  853. this.ultraGrid1.UpdateData();
  854. DataTable dt = ServerHelper.GetData("com.steering.ydm.bc.FrmDeleteMatBcM.getProcessMaterial",
  855. new object[] { }, ob);
  856. dt.Columns["BASENAME"].Caption = "物料名称";
  857. BaseInfoPopup baseInfo = new BaseInfoPopup(dt, "BASENAME", "BASECODE");
  858. baseInfo.Shown += new EventHandler((a, b) =>
  859. {
  860. var actRow = baseInfo.UltraGrid1.Rows.AsQueryable().Where(
  861. c => c.GetValue("BASECODE") == this.cmbMaterial.Tag.ToString2()).FirstOrDefault();
  862. if (actRow != null) actRow.Activate();
  863. });
  864. if (baseInfo.ShowDialog() == System.Windows.Forms.DialogResult.OK)
  865. {
  866. //cmbLocationNo.Tag = baseInfo.ChoicedRow.GetValue("LOCATION_NO");
  867. //cmbLocationNo.Text = baseInfo.ChoicedRow.GetValue("LOCATION_NAME");
  868. this.ultraGrid1.ActiveCell.Value = baseInfo.ChoicedRow.GetValue("BASENAME");
  869. this.ultraGrid1.ActiveCell.Row.Cells["MaterialNo"].Value = baseInfo.ChoicedRow.GetValue("BASECODE");
  870. }
  871. }
  872. private void txtMemo_EditorButtonClick(object sender, Infragistics.Win.UltraWinEditors.EditorButtonEventArgs e)
  873. {
  874. UltraTextEditor textEditor = (UltraTextEditor)sender;
  875. PopupTextBox popupText = new PopupTextBox(textEditor.Text, 500);
  876. if (popupText.ShowDialog() == System.Windows.Forms.DialogResult.OK)
  877. {
  878. textEditor.Text = popupText.TextInfo.Trim();
  879. }
  880. this.ultraGrid1.ActiveCell.Value = textEditor.Text;
  881. this.ultraGrid1.ActiveRow.Update();
  882. }
  883. private void ultraGrid2_AfterRowActivate(object sender, EventArgs e)
  884. {
  885. this.ultraGrid2.UpdateData();
  886. UltraGridRow row = this.ultraGrid2.ActiveRow;
  887. if (row == null) return;
  888. doQueryScrapOutList(row);
  889. }
  890. /// <summary>
  891. /// 查询废品出库记录
  892. /// </summary>
  893. /// <param name="row"></param>
  894. private void doQueryScrapOutList(UltraGridRow row)
  895. {
  896. List<YdmBcOutlistEntity> listSource = EntityHelper.GetData<YdmBcOutlistEntity>(
  897. "com.steering.ydm.bc.FrmDeleteMatBcM.doQueryScrapOutList", new object[] { row.Cells["OutstockDoc"].Text }, this.ob);
  898. ydmBcOutlistEntityBindingSource.DataSource = listSource;
  899. }
  900. private void ultraTabControl1_SelectedTabChanged(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e)
  901. {
  902. if (toolMenu == null) return;
  903. if (toolMenu.Toolbars[0].Tools.Exists("Delete")) { toolMenu.Toolbars[0].Tools["Delete"].InstanceProps.Visible = this.ultraTabControl1.SelectedTab.Index == 0 ? DefaultableBoolean.True : DefaultableBoolean.False; }
  904. if (toolMenu.Toolbars[0].Tools.Exists("LoadMat")) { toolMenu.Toolbars[0].Tools["LoadMat"].InstanceProps.Visible = this.ultraTabControl1.SelectedTab.Index == 0 ? DefaultableBoolean.True : DefaultableBoolean.False; }
  905. if (toolMenu.Toolbars[0].Tools.Exists("TakeBill")) { toolMenu.Toolbars[0].Tools["TakeBill"].InstanceProps.Visible = this.ultraTabControl1.SelectedTab.Index == 0 ? DefaultableBoolean.True : DefaultableBoolean.False; }
  906. if (toolMenu.Toolbars[0].Tools.Exists("AdjustStorage")) { toolMenu.Toolbars[0].Tools["AdjustStorage"].InstanceProps.Visible = this.ultraTabControl1.SelectedTab.Index == 0 ? DefaultableBoolean.True : DefaultableBoolean.False; }
  907. if (toolMenu.Toolbars[0].Tools.Exists("SetUpIntial")) { toolMenu.Toolbars[0].Tools["SetUpIntial"].InstanceProps.Visible = this.ultraTabControl1.SelectedTab.Index == 0 ? DefaultableBoolean.True : DefaultableBoolean.False; }
  908. if (toolMenu.Toolbars[0].Tools.Exists("UpdateMaterial")) { toolMenu.Toolbars[0].Tools["UpdateMaterial"].InstanceProps.Visible = this.ultraTabControl1.SelectedTab.Index == 0 ? DefaultableBoolean.True : DefaultableBoolean.False; }
  909. if (toolMenu.Toolbars[0].Tools.Exists("UpdateMemo")) { toolMenu.Toolbars[0].Tools["UpdateMemo"].InstanceProps.Visible = this.ultraTabControl1.SelectedTab.Index == 0 ? DefaultableBoolean.True : DefaultableBoolean.False; }
  910. if (toolMenu.Toolbars[0].Tools.Exists("ScrapOut")) { toolMenu.Toolbars[0].Tools["ScrapOut"].InstanceProps.Visible = this.ultraTabControl1.SelectedTab.Index == 0 ? DefaultableBoolean.True : DefaultableBoolean.False; }
  911. if (toolMenu.Toolbars[0].Tools.Exists("Export")) { toolMenu.Toolbars[0].Tools["Export"].InstanceProps.Visible = this.ultraTabControl1.SelectedTab.Index == 0 ? DefaultableBoolean.True : DefaultableBoolean.False; }
  912. if (toolMenu.Toolbars[0].Tools.Exists("UpdateReason")) { toolMenu.Toolbars[0].Tools["UpdateReason"].InstanceProps.Visible = this.ultraTabControl1.SelectedTab.Index == 0 ? DefaultableBoolean.True : DefaultableBoolean.False; }
  913. if (toolMenu.Toolbars[0].Tools.Exists("UpdateBelongResponse")) { toolMenu.Toolbars[0].Tools["UpdateBelongResponse"].InstanceProps.Visible = this.ultraTabControl1.SelectedTab.Index == 0 ? DefaultableBoolean.True : DefaultableBoolean.False; }
  914. if (toolMenu.Toolbars[0].Tools.Exists("UpdatePorssWgt")) { toolMenu.Toolbars[0].Tools["UpdatePorssWgt"].InstanceProps.Visible = this.ultraTabControl1.SelectedTab.Index == 1 ? DefaultableBoolean.True : DefaultableBoolean.False; }
  915. if (toolMenu.Toolbars[0].Tools.Exists("BelongResponse")) { toolMenu.Toolbars[0].Tools["BelongResponse"].InstanceProps.Visible = this.ultraTabControl1.SelectedTab.Index == 1 ? DefaultableBoolean.True : DefaultableBoolean.False; }
  916. if (toolMenu.Toolbars[0].Tools.Exists("CancelScrapOut")) { toolMenu.Toolbars[0].Tools["CancelScrapOut"].InstanceProps.Visible = this.ultraTabControl1.SelectedTab.Index == 1 ? DefaultableBoolean.True : DefaultableBoolean.False; }
  917. if (toolMenu.Toolbars[0].Tools.Exists("CancelScrapJudgeNo")) { toolMenu.Toolbars[0].Tools["CancelScrapJudgeNo"].InstanceProps.Visible = this.ultraTabControl1.SelectedTab.Index == 1 ? DefaultableBoolean.True : DefaultableBoolean.False; }
  918. if (toolMenu.Toolbars[0].Tools.Exists("UpdateFlagStoveNo")) { toolMenu.Toolbars[0].Tools["UpdateFlagStoveNo"].InstanceProps.Visible = this.ultraTabControl1.SelectedTab.Index == 0 ? DefaultableBoolean.True : DefaultableBoolean.False; }
  919. }
  920. private void FrmDeleteMatBcM_Shown(object sender, EventArgs e)
  921. {
  922. if (toolMenu == null) return;
  923. if (toolMenu.Toolbars[0].Tools.Exists("UpdatePorssWgt"))
  924. {
  925. toolMenu.Toolbars[0].Tools["UpdatePorssWgt"].InstanceProps.Visible = DefaultableBoolean.False;
  926. }
  927. if (toolMenu.Toolbars[0].Tools.Exists("BelongResponse"))
  928. {
  929. toolMenu.Toolbars[0].Tools["BelongResponse"].InstanceProps.Visible = DefaultableBoolean.False;
  930. }
  931. if (toolMenu.Toolbars[0].Tools.Exists("CancelScrapOut"))
  932. {
  933. toolMenu.Toolbars[0].Tools["CancelScrapOut"].InstanceProps.Visible = DefaultableBoolean.False;
  934. }
  935. if (toolMenu.Toolbars[0].Tools.Exists("CancelScrapJudgeNo"))
  936. {
  937. toolMenu.Toolbars[0].Tools["CancelScrapJudgeNo"].InstanceProps.Visible = DefaultableBoolean.False;
  938. }
  939. }
  940. }
  941. }