FrmVrpDownLineManage.cs 64 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576
  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.Mcp.Control;
  6. using Core.StlMes.Client.Mcp.Control.Base;
  7. using Core.StlMes.Client.Mcp.VRP.Entity;
  8. using CoreFS.CA06;
  9. using Infragistics.Win;
  10. using Infragistics.Win.UltraWinGrid;
  11. using System;
  12. using System.Collections;
  13. using System.Collections.Generic;
  14. using System.ComponentModel;
  15. using System.Data;
  16. using System.Drawing;
  17. using System.Linq;
  18. using System.Text;
  19. using System.Windows.Forms;
  20. namespace Core.StlMes.Client.Mcp.VRP.Vrp
  21. {
  22. public partial class FrmVrpDownLineManage : FrmBase
  23. {
  24. private string departm = "";
  25. private string plineCode = "";
  26. private string gxsl = "1";
  27. private string gxdj = "0";
  28. private string gxcld = "0";
  29. private string gxxk = "0";
  30. private string gxyz = "0";
  31. private string gxbj = "0";
  32. private string storageNo = "";
  33. private string feedGx = "";
  34. private string[] plineCodes;
  35. private string zlJudNO = "";//组炉炉号
  36. private string zlBatchNo = "";//组炉批号
  37. public static string station = "";
  38. private OpeBase pssOb = null;
  39. public FrmVrpDownLineManage()
  40. {
  41. InitializeComponent();
  42. }
  43. private void FrmVrpDownLineManage_Load(object sender, EventArgs e)
  44. {
  45. DateTime now = DateTime.Now;
  46. DateTime dt1 = new DateTime(now.Year, now.Month, 1);//当月第一天
  47. DateTime dt2 = dt1.AddMonths(1).AddDays(-1);//当月最后一天
  48. this.StartTime.Value = DateTime.Parse(dt1.ToString("yyyy-MM-dd") + " 00:00:00");
  49. this.EndTime.Value = DateTime.Parse(dt2.ToString("yyyy-MM-dd") + " 23:59:59");
  50. departm = UserInfo.GetDepartment();
  51. plineCode = YdmBaseClass.GetPCode(departm, this.ob);//获取 用户 对应的产线
  52. plineCodes = comm.GetPlineCode(this.ValidDataPurviewIds, "E", ob);
  53. EntityHelper.ShowGridCaption<VrpOfflineResultEntity>(ultraGrid1.DisplayLayout.Bands[0]);
  54. EntityHelper.ShowGridCaption<VrpOfflineResultEntity>(ultraGrid2.DisplayLayout.Bands[0]);
  55. EntityHelper.ShowGridCaption<VrpOfflineResultEntity>(ultraGrid3.DisplayLayout.Bands[0]);
  56. pssOb = new OpeBase { MainUrl = CoreCommon.coreCommon.UrlList["pssserver"].Url };
  57. string sortcode = "";
  58. if (plineCode == "C070")//热扩
  59. {
  60. sortcode = "6507";
  61. }
  62. else if (plineCode == "C018")//720旋扩
  63. {
  64. sortcode = "6501";
  65. }
  66. else if (plineCode == "C021")//镦粗
  67. {
  68. sortcode = "6504";
  69. }
  70. else if (plineCode == "C014")//冷拔
  71. {
  72. sortcode = "6505";
  73. }
  74. else if (plineCode == "C013")//冷轧
  75. {
  76. sortcode = "6506";
  77. }
  78. else
  79. {
  80. sortcode = "6504";
  81. }
  82. DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.Vrp.FrmVrpDownLineManage.doQuery", new object[] { sortcode }, ob);
  83. cmbGx.DataSource = dt;
  84. cmbGx.DisplayMember = "BASENAME";
  85. cmbGx.ValueMember = "BASECODE";
  86. ReturnGX.DataSource = dt;
  87. ReturnGX.DisplayMember = "BASENAME";
  88. ReturnGX.ValueMember = "BASECODE";
  89. if (dt.Rows.Count > 0)
  90. {
  91. feedGx = dt.Rows[0]["BASECODE"].ToString();
  92. }
  93. DataTable dt3 = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getStorageDep", new object[] { this.UserInfo.GetDeptid(), Core.Mes.Client.Comm.Server.ClsBaseInfo.GetDepartIdBySectionId(this.UserInfo.GetDeptid(), this.ob), "800202", "800302" }, this.ob);
  94. if (dt3.Rows.Count > 0)
  95. {
  96. storageNo = dt3.Rows[0]["STORAGE_NO"].ToString();
  97. }
  98. }
  99. /// <summary>
  100. /// 重写基类方法
  101. /// </summary>
  102. /// <param name="sender"></param>
  103. /// <param name="ToolbarKey"></param>
  104. public override void ToolBar_Click(object sender, string ToolbarKey)
  105. {
  106. switch (ToolbarKey)
  107. {
  108. case "Query":
  109. DoQuery();
  110. break;
  111. case "SetFurnace":
  112. DoSetFurnace();
  113. break;
  114. case "CancelFurnace":
  115. DoCancelFurnace();
  116. break;
  117. case "OnlineComm":
  118. DoOnlineComm();
  119. break;
  120. case "ReturnLine":
  121. DoReturnLine();
  122. break;
  123. case "ReturnInstore":
  124. DoReturnLine("1");
  125. break;
  126. case "CancelReturnLine":
  127. DoCancelReturnLine();
  128. break;
  129. case "OutSourc":
  130. DoOutSourc();
  131. break;
  132. case "CancelOutSourc":
  133. DoCancelOutSourc();
  134. break;
  135. case "OrdersSourc":
  136. //DoOrdersSourc();委托单打印
  137. break;
  138. case "UpdateFalg":
  139. DoUpdateStoveNo();
  140. break;
  141. case "Take":
  142. doTake();
  143. break;
  144. case "Export":
  145. ExportData();
  146. break;
  147. case "Close":
  148. this.Close();
  149. break;
  150. }
  151. }
  152. /// <summary>
  153. /// 导出
  154. /// </summary>
  155. private void ExportData()
  156. {
  157. if (this.ultraTabControl1.Tabs[0].Active)
  158. {
  159. GridHelper.ulGridToExcel(ultraGrid1, "离线实绩");
  160. }
  161. else if (this.ultraTabControl1.Tabs[1].Active)
  162. {
  163. GridHelper.ulGridToExcel(ultraGrid2, "组炉实绩");
  164. }
  165. else if (this.ultraTabControl1.Tabs[2].Active)
  166. {
  167. GridHelper.ulGridToExcel(ultraGrid3, "返线实绩");
  168. }
  169. else if (this.ultraTabControl1.Tabs[3].Active)
  170. {
  171. GridHelper.ulGridToExcel(ultraGrid4, "委外实绩");
  172. }
  173. }
  174. /// <summary>
  175. /// 脱单
  176. /// </summary>
  177. private void doTake()
  178. {
  179. this.ultraGrid1.UpdateData();
  180. ArrayList parm = new ArrayList();
  181. IQueryable<UltraGridRow> checkMagRows = this.ultraGrid1.Rows.AsQueryable().Where(" CHK = 'True'");
  182. if (checkMagRows.Count() == 0)
  183. {
  184. MessageUtil.ShowTips("请勾选需要脱单的炉批信息!");
  185. return;
  186. }
  187. foreach (UltraGridRow row in checkMagRows)
  188. {
  189. VrpOfflineResultEntity milOfflineResultEntity = (VrpOfflineResultEntity)row.ListObject;
  190. if (milOfflineResultEntity.GroupLog.ToString() == "已组炉")
  191. {
  192. MessageUtil.ShowTips("炉号" + milOfflineResultEntity.JudgeStoveNo.ToString() + "是其他炉批组炉批出来的,不允许脱单!");
  193. return;
  194. }
  195. string milOffTity = JSONFormat.Format(milOfflineResultEntity);
  196. parm.Add(milOffTity);
  197. }
  198. if (MessageUtil.ShowYesNoAndQuestion("是否确认脱单?") == DialogResult.No) return;
  199. CoreClientParam ccp = new CoreClientParam();
  200. ccp.ServerName = "com.steering.mes.mcp.Vrp.FrmVrpDownLineManage";
  201. ccp.MethodName = "doTake";
  202. ccp.ServerParams = new object[] { parm, this.UserInfo.GetUserName() };
  203. ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
  204. if (ccp.ReturnCode != -1)
  205. {
  206. if (ccp.ReturnInfo.Equals("脱单成功!"))
  207. {
  208. DoQuery();
  209. MessageUtil.ShowTips(ccp.ReturnInfo);
  210. }
  211. else
  212. {
  213. MessageUtil.ShowTips(ccp.ReturnInfo);
  214. }
  215. }
  216. }
  217. /// <summary>
  218. /// 查询
  219. /// </summary>
  220. private void DoQuery()
  221. {
  222. if (!CheckQuery()) return;
  223. if (ultraTabControl1.SelectedTab.Key.Equals("0"))
  224. {
  225. DoQueryOffLine();
  226. }
  227. else if (ultraTabControl1.SelectedTab.Key.Equals("1"))
  228. {
  229. DoQueryOffLineGroup();
  230. }
  231. else if (ultraTabControl1.SelectedTab.Key.Equals("2"))
  232. {
  233. DoQueryReturnLine();
  234. }
  235. else
  236. {
  237. DoQueryOutSourc();
  238. }
  239. }
  240. /// <summary>
  241. /// 查询离线实绩
  242. /// </summary>
  243. private void DoQueryOffLine()
  244. {
  245. string startTime = "";
  246. string endTime = "";
  247. string judgeNo = "";
  248. string batchNo = "";
  249. string gx = "";
  250. if (chkTim.Checked)
  251. {
  252. startTime = StartTime.Value.ToString();
  253. endTime = EndTime.Value.ToString();
  254. }
  255. if (chkJugeHeatNo.Checked)
  256. {
  257. judgeNo = txtJugeNo.Text.ToString().Trim();
  258. }
  259. if (chkBatch.Checked)
  260. {
  261. batchNo = txtBatch.Text.ToString().Trim();
  262. }
  263. if (chkGx.Checked)
  264. {
  265. gx = cmbGx.Value.ToString();
  266. }
  267. ArrayList list = new ArrayList();
  268. list.Add(startTime);
  269. list.Add(endTime);
  270. list.Add(judgeNo);
  271. list.Add(batchNo);
  272. list.Add(gx);
  273. List<VrpOfflineResultEntity> listSource = EntityHelper.GetData<VrpOfflineResultEntity>(
  274. "com.steering.mes.mcp.Vrp.FrmVrpDownLineManage.doQueryOffLine", new object[] { list, plineCodes }, this.ob);
  275. VrpOfflineResultEntitybindingSource.DataSource = listSource;
  276. }
  277. /// <summary>
  278. /// 查询组炉实绩
  279. /// </summary>
  280. private void DoQueryOffLineGroup()
  281. {
  282. string startTime = "";
  283. string endTime = "";
  284. string judgeNo = "";
  285. string batchNo = "";
  286. string gx = "";
  287. if (chkTim.Checked)
  288. {
  289. startTime = StartTime.Value.ToString();
  290. endTime = EndTime.Value.ToString();
  291. }
  292. if (chkJugeHeatNo.Checked)
  293. {
  294. judgeNo = txtJugeNo.Text.ToString().Trim();
  295. }
  296. if (chkBatch.Checked)
  297. {
  298. batchNo = txtBatch.Text.ToString().Trim();
  299. }
  300. if (chkGx.Checked)
  301. {
  302. gx = cmbGx.Value.ToString();
  303. }
  304. ArrayList list = new ArrayList();
  305. list.Add(startTime);
  306. list.Add(endTime);
  307. list.Add(judgeNo);
  308. list.Add(batchNo);
  309. list.Add(gx);
  310. List<VrpOfflineResultEntity> listSource = EntityHelper.GetData<VrpOfflineResultEntity>(
  311. "com.steering.mes.mcp.Vrp.FrmVrpDownLineManage.doQueryOffLineGroup", new object[] { list, plineCodes }, this.ob);
  312. VrpOfflineResultEntitybindingSourc2.DataSource = listSource;
  313. }
  314. /// <summary>
  315. /// 返线实绩
  316. /// </summary>
  317. private void DoQueryReturnLine()
  318. {
  319. string startTime = "";
  320. string endTime = "";
  321. string judgeNo = "";
  322. string batchNo = "";
  323. string gx = "";
  324. if (chkTim.Checked)
  325. {
  326. startTime = StartTime.Value.ToString();
  327. endTime = EndTime.Value.ToString();
  328. }
  329. if (chkJugeHeatNo.Checked)
  330. {
  331. judgeNo = txtJugeNo.Text.ToString().Trim();
  332. }
  333. if (chkBatch.Checked)
  334. {
  335. batchNo = txtBatch.Text.ToString().Trim();
  336. }
  337. if (chkGx.Checked)
  338. {
  339. gx = cmbGx.Value.ToString();
  340. }
  341. ArrayList list = new ArrayList();
  342. list.Add(startTime);
  343. list.Add(endTime);
  344. list.Add(judgeNo);
  345. list.Add(batchNo);
  346. list.Add(gx);
  347. List<VrpOfflineResultEntity> listSource = EntityHelper.GetData<VrpOfflineResultEntity>(
  348. "com.steering.mes.mcp.Vrp.FrmVrpDownLineManage.doQueryReturnLine", new object[] { list, plineCodes }, this.ob);
  349. VrpOfflineResultEntitybindingSourc3.DataSource = listSource;
  350. }
  351. /// <summary>
  352. /// 委外实绩
  353. ///
  354. /// </summary>
  355. private void DoQueryOutSourc()
  356. {
  357. string startTime = "";
  358. string endTime = "";
  359. string judgeNo = "";
  360. string batchNo = "";
  361. string strat = "";
  362. if (chkTim.Checked)
  363. {
  364. startTime = StartTime.Value.ToString();
  365. endTime = EndTime.Value.ToString();
  366. }
  367. if (chkJugeHeatNo.Checked)
  368. {
  369. judgeNo = txtJugeNo.Text.ToString().Trim();
  370. }
  371. if (chkBatch.Checked)
  372. {
  373. batchNo = txtBatch.Text.ToString().Trim();
  374. }
  375. if (chkStrat.Checked)
  376. {
  377. strat = cmbStrat.Value.ToString();
  378. }
  379. ArrayList list = new ArrayList();
  380. list.Add(startTime);
  381. list.Add(endTime);
  382. list.Add(judgeNo);
  383. list.Add(batchNo);
  384. list.Add(strat);
  385. DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.Vrp.FrmVrpDownLineManage.doQueryOutSourc", new object[] { list, plineCodes }, this.ob);
  386. GridHelper.CopyDataToDatatable(ref dt, ref dataTable2, true);
  387. }
  388. /// <summary>
  389. /// 组炉
  390. /// </summary>
  391. private void DoSetFurnace()
  392. {
  393. this.ultraGrid1.UpdateData();
  394. //string jugeNo = "";
  395. //string lotNo = "";
  396. int m = 0;
  397. int n = 0;
  398. IQueryable<UltraGridRow> checkMagRows = this.ultraGrid1.Rows.AsQueryable().Where(" CHK = 'True'");
  399. IQueryable<UltraGridRow> checkRows = this.ultraGrid1.Rows.AsQueryable().Where(a => a.GetValue("CHK1") == "True");
  400. if (checkMagRows.Count() == 0)
  401. {
  402. MessageUtil.ShowTips("请勾选需要组炉的炉批信息!");
  403. return;
  404. }
  405. if (checkRows.Count() != 1)
  406. {
  407. MessageUtil.ShowTips("组炉主炉号只允许选择一条!");
  408. return;
  409. }
  410. //if (txtJudgeStoveNo.Text.Trim().Equals(""))
  411. //{
  412. // MessageUtil.ShowTips("组炉新炉号不能为空!");
  413. // return;
  414. //}
  415. //else
  416. //{
  417. // jugeNo = txtJudgeStoveNo.Text.Trim();
  418. //}
  419. //foreach (UltraGridRow row1 in checkRows)
  420. //{
  421. // if (txtLotNo.Text.Trim().Equals(""))
  422. // {
  423. // lotNo = row1.Cells["ZyBatchId"].Text.ToString();
  424. // }
  425. // else
  426. // {
  427. // lotNo = txtLotNo.Text.Trim();
  428. // }
  429. //}
  430. ArrayList parm = new ArrayList();
  431. ArrayList parm1 = new ArrayList();
  432. ArrayList parm2 = new ArrayList();
  433. foreach (UltraGridRow row in checkMagRows)
  434. {
  435. VrpOfflineResultEntity milOfflineResultEntity = (VrpOfflineResultEntity)row.ListObject;
  436. if (milOfflineResultEntity.OfflineBranch.ToString() == "")
  437. {
  438. MessageUtil.ShowTips("可编辑支不能为空!");
  439. return;
  440. }
  441. if (int.Parse(milOfflineResultEntity.OfflineBranch.ToString()) <= 0)
  442. {
  443. MessageUtil.ShowTips("输入的操作支数需为正整数!");
  444. return;
  445. }
  446. if (int.Parse(milOfflineResultEntity.OfflineBranch.ToString()) - int.Parse(milOfflineResultEntity.Totalcount.ToString()) > 0)
  447. {
  448. MessageUtil.ShowTips("组炉时操作支数不能大于离线剩余支数!");
  449. return;
  450. }
  451. if (milOfflineResultEntity.GroupLog.ToString() == "已组炉")
  452. {
  453. MessageUtil.ShowTips("炉号" + milOfflineResultEntity.JudgeStoveNo.ToString() + "是其他炉批组炉批出来的,不允许重复组炉批!");
  454. return;
  455. }
  456. if (!milOfflineResultEntity.OfflineBranch.Equals(milOfflineResultEntity.Totalcount))
  457. {
  458. MessageUtil.ShowTips("离线数据不允许拆分组炉批!");
  459. return;
  460. }
  461. //if (milOfflineResultEntity.StationDesc.Equals("矫直"))
  462. //{
  463. // n = n + 1;
  464. //}
  465. //if (int.Parse(row.Cells["InstorageNum"].Value.ToString3()) > 0)
  466. //{
  467. // m = m + 1;
  468. //}
  469. string milOffTity = JSONFormat.Format(milOfflineResultEntity);
  470. parm.Add(milOffTity);
  471. }
  472. //if (m > 0)
  473. //{
  474. // MessageUtil.ShowTips("有炉已进行入在线库,不允许进行组炉批!");
  475. // return;
  476. //}
  477. //if (n > 0)
  478. //{
  479. // MessageUtil.ShowTips("矫直离线数据不允许进行组炉批!");
  480. // return;
  481. //}
  482. int offlinePro = checkMagRows.GroupBy(a => a.GetValue("stationCode")).Count();
  483. if (offlinePro > 1)
  484. {
  485. MessageUtil.ShowTips("只有同工序的炉信息,才能进行组炉批!");
  486. return;
  487. }
  488. int offlineType = checkMagRows.GroupBy(a => a.GetValue("PlineCode")).Count();
  489. if (offlineType > 1)
  490. {
  491. MessageUtil.ShowTips("只有同一产线才能进行组炉!");
  492. return;
  493. }
  494. int steel = checkMagRows.GroupBy(a => a.GetValue("Steelname")).Count();
  495. if (steel > 1)
  496. {
  497. MessageUtil.ShowTips("只有同钢级的炉信息,才能进行组炉批!");
  498. return;
  499. }
  500. int grade = checkMagRows.GroupBy(a => a.GetValue("Gradecode")).Count();
  501. if (grade > 1)
  502. {
  503. MessageUtil.ShowTips("只有同钢种的炉信息,才能进行组炉批!");
  504. return;
  505. }
  506. int actLengthMax = checkMagRows.GroupBy(a => a.GetValue("ActLenMax")).Count();
  507. int actLengthMin = checkMagRows.GroupBy(a => a.GetValue("ActLenMin")).Count();
  508. if (actLengthMax > 1 && actLengthMin>1)
  509. {
  510. MessageUtil.ShowTips("只有同长度上下限的炉信息,才能进行组炉批!");
  511. return;
  512. }
  513. int pipeSizeD = checkMagRows.GroupBy(a => a.GetValue("ActDimater")).Count();
  514. int pipeSizeH = checkMagRows.GroupBy(a => a.GetValue("ActHeight")).Count();
  515. if (pipeSizeD > 1 && pipeSizeH>1)
  516. {
  517. MessageUtil.ShowTips("只有同外径,壁厚的炉信息,才能进行组炉批!");
  518. return;
  519. }
  520. foreach (UltraGridRow uRow in checkRows)
  521. {
  522. VrpOfflineResultEntity milOfflineResultEntity1 = (VrpOfflineResultEntity)uRow.ListObject;
  523. string milOffTity1 = JSONFormat.Format(milOfflineResultEntity1);
  524. parm1.Add(milOffTity1);
  525. }
  526. FrmRentFurnace furnace = new FrmRentFurnace();
  527. furnace.ShowDialog();
  528. if (furnace.DialogResult == System.Windows.Forms.DialogResult.OK)
  529. {
  530. //获取弹出窗体的属性值
  531. //zlJudNO = furnace.JudNo;
  532. //zlBatchNo = furnace.BatchNo;
  533. foreach (UltraGridRow uRow in checkRows)
  534. {
  535. VrpOfflineResultEntity milFurnacesReslutEntity = (VrpOfflineResultEntity)uRow.ListObject;
  536. if (milFurnacesReslutEntity.JudgeStoveNo.Length == 11)
  537. {
  538. if (milFurnacesReslutEntity.PlineCode.Equals("C018"))
  539. {
  540. zlJudNO = milFurnacesReslutEntity.JudgeStoveNo.Substring(0, 10) + "P";
  541. }
  542. else if (milFurnacesReslutEntity.PlineCode.Equals("C070"))
  543. {
  544. zlJudNO = milFurnacesReslutEntity.JudgeStoveNo.Substring(0, 10) + "S";
  545. }
  546. zlBatchNo = milFurnacesReslutEntity.ZyBatchId;
  547. }
  548. else
  549. {
  550. zlJudNO = furnace.JudNo;
  551. zlBatchNo = furnace.BatchNo;
  552. }
  553. }
  554. }
  555. else
  556. {
  557. //MessageUtil.ShowTips("请输入组炉炉号,组炉批号!");
  558. return;
  559. }
  560. parm2.Add(zlJudNO);
  561. parm2.Add(zlBatchNo);
  562. parm2.Add(this.UserInfo.GetUserName());
  563. parm2.Add(this.UserInfo.GetUserGroup());
  564. parm2.Add(this.UserInfo.GetUserOrder());
  565. if (MessageUtil.ShowYesNoAndQuestion("是否确认组炉?") == DialogResult.No) return;
  566. CoreClientParam ccp = new CoreClientParam();
  567. ccp.ServerName = "com.steering.mes.mcp.Vrp.FrmVrpDownLineManage";
  568. ccp.MethodName = "doFurnace";
  569. ccp.ServerParams = new object[] { parm, parm1, parm2 };
  570. ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
  571. if (ccp.ReturnCode != -1)
  572. {
  573. MessageUtil.ShowTips(ccp.ReturnInfo);
  574. if (ccp.ReturnInfo.Equals("组炉成功!"))
  575. {
  576. DoQuery();
  577. }
  578. }
  579. }
  580. /// <summary>
  581. /// 撤销组炉
  582. /// </summary>
  583. private void DoCancelFurnace()
  584. {
  585. this.ultraGrid2.UpdateData();
  586. IQueryable<UltraGridRow> checkMagRows = this.ultraGrid2.Rows.AsQueryable().Where(" CHK = 'True'");
  587. if (checkMagRows.Count() == 0)
  588. {
  589. MessageUtil.ShowTips("请勾选需要撤销的组炉信息!");
  590. return;
  591. }
  592. ArrayList parm = new ArrayList();
  593. foreach (UltraGridRow row in checkMagRows)
  594. {
  595. VrpOfflineResultEntity milOfflineResultEntity = (VrpOfflineResultEntity)row.ListObject;
  596. string milOffTity = JSONFormat.Format(milOfflineResultEntity);
  597. parm.Add(milOffTity);
  598. }
  599. if (MessageUtil.ShowYesNoAndQuestion("是否确认撤销组炉?") == DialogResult.No) return;
  600. CoreClientParam ccp = new CoreClientParam();
  601. ccp.ServerName = "com.steering.mes.mcp.Vrp.FrmVrpDownLineManage";
  602. ccp.MethodName = "doCancelFurnace";
  603. ccp.ServerParams = new object[] { parm };
  604. ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
  605. if (ccp.ReturnCode != -1)
  606. {
  607. MessageUtil.ShowTips(ccp.ReturnInfo);
  608. if (ccp.ReturnInfo.Equals("撤销组炉成功!"))
  609. {
  610. DoQuery();
  611. }
  612. }
  613. }
  614. /// <summary>
  615. /// 在线改判
  616. /// </summary>
  617. private void DoOnlineComm()
  618. {
  619. this.ultraGrid1.UpdateData();
  620. IQueryable<UltraGridRow> checkMagRows = this.ultraGrid1.Rows.AsQueryable().Where(" CHK = 'True'");
  621. if (checkMagRows.Count() == 0)
  622. {
  623. MessageUtil.ShowTips("请勾选需要改判的信息!");
  624. return;
  625. }
  626. ArrayList parm = new ArrayList();
  627. ArrayList parm1 = new ArrayList();
  628. foreach (UltraGridRow row in checkMagRows)
  629. {
  630. VrpOfflineResultEntity milOfflineResultEntity = (VrpOfflineResultEntity)row.ListObject;
  631. if (milOfflineResultEntity.GroupLog.ToString().Equals("未组炉"))
  632. {
  633. MessageUtil.ShowTips("不是组炉数据不允许改判!");
  634. return;
  635. }
  636. string milOffTity = JSONFormat.Format(milOfflineResultEntity);
  637. parm.Add(milOffTity);
  638. }
  639. parm1.Add(this.UserInfo.GetUserName());
  640. parm1.Add(this.UserInfo.GetUserGroup());
  641. parm1.Add(this.UserInfo.GetUserOrder());
  642. if (MessageUtil.ShowYesNoAndQuestion("是否确认在线改判?") == DialogResult.No) return;
  643. CoreClientParam ccp = new CoreClientParam();
  644. ccp.ServerName = "com.steering.mes.mcp.Vrp.FrmVrpDownLineManage";
  645. ccp.MethodName = "doOnlineComm";
  646. ccp.ServerParams = new object[] { parm, parm1 };
  647. ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
  648. if (ccp.ReturnCode != -1)
  649. {
  650. MessageUtil.ShowTips(ccp.ReturnInfo);
  651. if (ccp.ReturnInfo.Equals("在线改判成功!"))
  652. {
  653. DoQuery();
  654. }
  655. }
  656. }
  657. /// <summary>
  658. /// 返线
  659. /// </summary>
  660. private void DoReturnLine(string Instore = "0")
  661. {
  662. this.ultraGrid1.UpdateData();
  663. string pointGx = "";
  664. string pointGxName = "";
  665. int totalNum = 0;
  666. UltraGridRow row1 = ultraGrid1.ActiveRow;
  667. if(row1!=null)
  668. {
  669. pointGx = row1.Cells["StationCode"].Value.ToString();
  670. pointGxName = row1.Cells["StationDesc"].Value.ToString();
  671. totalNum = int.Parse(row1.Cells["Totalcount"].Value.ToString());
  672. }
  673. IQueryable<UltraGridRow> checkMagRows = this.ultraGrid1.Rows.AsQueryable().Where(" CHK = 'True'");
  674. if (checkMagRows.Count() == 0)
  675. {
  676. MessageUtil.ShowTips("请勾选需要返线的炉批信息!");
  677. return;
  678. }
  679. int offlinePro = checkMagRows.GroupBy(a => a.GetValue("stationCode")).Count();
  680. if (offlinePro > 1)
  681. {
  682. MessageUtil.ShowTips("只有同工序的炉信息,才能进行返线!");
  683. return;
  684. }
  685. //string sortcode = "";
  686. //if (plineCode == "C070")//热扩
  687. //{
  688. // sortcode = "6507";
  689. //}
  690. //else if (plineCode == "C018")//720旋扩
  691. //{
  692. // sortcode = "6501";
  693. //}
  694. //else if (plineCode == "C021")//镦粗
  695. //{
  696. // sortcode = "6504";
  697. //}
  698. //else if (plineCode == "C014")//冷拔
  699. //{
  700. // sortcode = "6505";
  701. //}
  702. //else if (plineCode == "C013")//冷轧
  703. //{
  704. // sortcode = "6506";
  705. //}
  706. //FrmReturnCon line = new FrmReturnCon(plineCode, ob, sortcode);
  707. //line.ShowDialog();
  708. //if (line.DialogResult == System.Windows.Forms.DialogResult.OK)
  709. //{
  710. // //获取弹出窗体的属性值
  711. // pointGx = line.RetPro;
  712. // pointGxName = line.RetProNmae;
  713. //}
  714. //else
  715. //{
  716. // //MessageUtil.ShowTips("请选择返线经过工序点!");
  717. // return;
  718. //}
  719. ArrayList parm = new ArrayList();
  720. ArrayList parm2 = new ArrayList();
  721. foreach (UltraGridRow row in checkMagRows)
  722. {
  723. VrpOfflineResultEntity milOfflineResultEntity = (VrpOfflineResultEntity)row.ListObject;
  724. if (milOfflineResultEntity.OfflineBranch.ToString() == "")
  725. {
  726. MessageUtil.ShowTips("可编辑支不能为空!");
  727. return;
  728. }
  729. if (int.Parse(milOfflineResultEntity.OfflineBranch.ToString()) <= 0)
  730. {
  731. MessageUtil.ShowTips("输入的操作支数需为正整数!");
  732. return;
  733. }
  734. //if (int.Parse(milOfflineResultEntity.OfflineBranch.ToString()) - int.Parse(milOfflineResultEntity.Totalcount.ToString()) > 0)
  735. //{
  736. // MessageUtil.ShowTips("返线时操作支数不能大于剩余支数!");
  737. // return;
  738. //}
  739. if (int.Parse(pointGx) > int.Parse(milOfflineResultEntity.StationCode))
  740. {
  741. MessageUtil.ShowTips("返线工序点不能在离线工序点之后!");
  742. return;
  743. }
  744. string milOffTity = JSONFormat.Format(milOfflineResultEntity);
  745. parm.Add(milOffTity);
  746. }
  747. if (MessageUtil.ShowYesNoAndQuestion("是否确认返线?") == DialogResult.No) return;
  748. #region 根据选择返线工序点默认经过工序点
  749. if (plineCode == "C070")//热扩
  750. {
  751. if (pointGx.Equals("650701"))
  752. {
  753. gxsl= "3";
  754. gxcld = "3";
  755. gxbj = "3";
  756. }
  757. else if (pointGx.Equals("650702"))
  758. {
  759. gxsl = "1";
  760. gxcld = "3";
  761. gxbj = "3";
  762. }
  763. else
  764. {
  765. gxsl = "1";
  766. gxcld = "1";
  767. gxbj = "3";
  768. }
  769. }
  770. else if (plineCode == "C018")//720旋扩
  771. {
  772. if (pointGx.Equals("650101"))
  773. {
  774. gxsl= "3";
  775. gxxk = "3";
  776. gxyz = "3";
  777. gxdj = "3";
  778. gxbj = "3";
  779. }
  780. else if (pointGx.Equals("650102"))
  781. {
  782. gxsl = "1";
  783. gxxk = "3";
  784. gxyz = "3";
  785. gxdj = "3";
  786. gxbj = "3";
  787. }
  788. else if (pointGx.Equals("650103"))
  789. {
  790. gxsl = "1";
  791. gxxk = "1";
  792. gxyz = "3";
  793. gxdj = "3";
  794. gxbj = "3";
  795. }
  796. else if (pointGx.Equals("650104"))
  797. {
  798. gxsl = "1";
  799. gxxk = "1";
  800. gxyz = "1";
  801. gxdj = "3";
  802. gxbj = "3";
  803. }
  804. else
  805. {
  806. gxsl = "1";
  807. gxxk = "1";
  808. gxyz = "1";
  809. gxdj = "1";
  810. gxbj = "3";
  811. }
  812. }
  813. else if (plineCode == "C021")//镦粗
  814. {
  815. if (pointGx.Equals("650401"))
  816. {
  817. gxsl = "3";
  818. gxcld = "3";
  819. gxbj = "3";
  820. }
  821. else if (pointGx.Equals("650402"))
  822. {
  823. gxsl = "1";
  824. gxcld = "3";
  825. gxbj = "3";
  826. }
  827. else
  828. {
  829. gxsl = "1";
  830. gxcld = "1";
  831. gxbj = "3";
  832. }
  833. }
  834. else if (plineCode == "C014")//冷拔
  835. {
  836. if (pointGx.Equals("650501"))
  837. {
  838. gxsl = "3";
  839. gxcld = "3";
  840. gxbj = "3";
  841. }
  842. else if (pointGx.Equals("650502"))
  843. {
  844. gxsl = "1";
  845. gxcld = "3";
  846. gxbj = "3";
  847. }
  848. else
  849. {
  850. gxsl = "1";
  851. gxcld = "1";
  852. gxbj = "3";
  853. }
  854. }
  855. else if (plineCode == "C013")//冷轧
  856. {
  857. if (pointGx.Equals("650601"))
  858. {
  859. gxsl = "3";
  860. gxcld = "3";
  861. gxbj = "3";
  862. }
  863. else if (pointGx.Equals("650602"))
  864. {
  865. gxsl = "1";
  866. gxcld = "3";
  867. gxbj = "3";
  868. }
  869. else
  870. {
  871. gxsl = "1";
  872. gxcld = "1";
  873. gxbj = "3";
  874. }
  875. }
  876. #endregion
  877. parm2.Add(plineCode);
  878. parm2.Add(this.UserInfo.GetUserName());
  879. parm2.Add(this.UserInfo.GetUserGroup());
  880. parm2.Add(this.UserInfo.GetUserOrder());
  881. parm2.Add(pointGx);
  882. parm2.Add(storageNo);
  883. parm2.Add(UserInfo.GetDepartment());
  884. parm2.Add(UserInfo.GetDeptid());
  885. parm2.Add(pointGxName);
  886. parm2.Add(gxsl);
  887. parm2.Add(gxxk);
  888. parm2.Add(gxbj);
  889. parm2.Add(gxdj);
  890. parm2.Add(gxyz);
  891. parm2.Add(gxcld);
  892. parm2.Add(Instore);
  893. CoreClientParam ccp = new CoreClientParam();
  894. ccp.ServerName = "com.steering.mes.mcp.Vrp.FrmVrpDownLineManage";
  895. ccp.MethodName = "doReturnLine";
  896. ccp.ServerParams = new object[] { parm, parm2, totalNum };
  897. ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
  898. if (ccp.ReturnCode != -1)
  899. {
  900. if (ccp.ReturnInfo.Equals("返线成功!"))
  901. {
  902. ArrayList List = ccp.ReturnObject as ArrayList;
  903. if (List != null && List.Count > 0)
  904. {
  905. for (int i = 0; i < List.Count; i++)
  906. {
  907. try
  908. {
  909. string[] para = List[i].ToString2().Split(',');
  910. if (para.Length < 3) continue;
  911. ccp.ServerName = "com.steering.pss.plnsaleord.stove.PlanFurnProduction";
  912. ccp.MethodName = "addPlnFurn";
  913. ccp.ServerParams = new object[] { para[1], para[2], this.UserInfo.GetUserName(), para[0], "E", "1" };
  914. ccp = pssOb.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
  915. if (ccp.ReturnInfo != "")
  916. {
  917. MessageBox.Show("生成下工序炉计划失败! \n" + ccp.ReturnInfo, "提示", MessageBoxButtons.OK,
  918. MessageBoxIcon.Asterisk);
  919. return;
  920. }
  921. }
  922. catch (Exception ex)
  923. {
  924. MessageBox.Show("生成下工序炉计划失败!\n" + ex.Message, "提示", MessageBoxButtons.OK,
  925. MessageBoxIcon.Asterisk);
  926. }
  927. }
  928. }
  929. MessageUtil.ShowTips("返线成功");
  930. DoQuery();
  931. }
  932. else
  933. {
  934. MessageUtil.ShowTips(ccp.ReturnInfo);
  935. }
  936. }
  937. }
  938. /// <summary>
  939. /// 撤销返线
  940. /// </summary>
  941. private void DoCancelReturnLine()
  942. {
  943. this.ultraGrid3.UpdateData();
  944. IQueryable<UltraGridRow> checkMagRows = this.ultraGrid3.Rows.AsQueryable().Where(" CHK = 'True'");
  945. if (checkMagRows.Count() == 0)
  946. {
  947. MessageUtil.ShowTips("请勾选需要撤销的返线炉批信息!");
  948. return;
  949. }
  950. ArrayList parm = new ArrayList();
  951. ArrayList parm2 = new ArrayList();
  952. //ArrayList parm1 = new ArrayList();
  953. foreach (UltraGridRow row in checkMagRows)
  954. {
  955. //ArrayList parm3 = new ArrayList();
  956. VrpOfflineResultEntity milOfflineResultEntity = (VrpOfflineResultEntity)row.ListObject;
  957. #region 修改工艺路径
  958. if (milOfflineResultEntity.PlineCode.Equals("C018"))//720旋扩
  959. {
  960. if (milOfflineResultEntity.StationCode.Equals("650102"))
  961. {
  962. milOfflineResultEntity.Gxsl = "1";
  963. milOfflineResultEntity.Gxxk = "2";
  964. milOfflineResultEntity.Gxyz = "0";
  965. milOfflineResultEntity.Gxdj = "0";
  966. milOfflineResultEntity.Gxbj = "0";
  967. }
  968. else if (milOfflineResultEntity.StationCode.Equals("650103"))
  969. {
  970. milOfflineResultEntity.Gxsl = "1";
  971. milOfflineResultEntity.Gxxk = "1";
  972. milOfflineResultEntity.Gxyz = "2";
  973. milOfflineResultEntity.Gxdj = "0";
  974. milOfflineResultEntity.Gxbj = "0";
  975. }
  976. else if (milOfflineResultEntity.StationCode.Equals("650104"))
  977. {
  978. milOfflineResultEntity.Gxsl = "1";
  979. milOfflineResultEntity.Gxxk = "1";
  980. milOfflineResultEntity.Gxyz = "1";
  981. milOfflineResultEntity.Gxdj = "2";
  982. milOfflineResultEntity.Gxbj = "0";
  983. }
  984. else if (milOfflineResultEntity.StationCode.Equals("650106"))
  985. {
  986. milOfflineResultEntity.Gxsl = "1";
  987. milOfflineResultEntity.Gxxk = "1";
  988. milOfflineResultEntity.Gxyz = "1";
  989. milOfflineResultEntity.Gxdj = "1";
  990. milOfflineResultEntity.Gxbj = "2";
  991. }
  992. }
  993. else if (milOfflineResultEntity.PlineCode.Equals("C070"))//热扩
  994. {
  995. if (milOfflineResultEntity.StationCode.Equals("650702"))
  996. {
  997. milOfflineResultEntity.Gxsl = "1";
  998. milOfflineResultEntity.Gxcld = "2";
  999. milOfflineResultEntity.Gxbj = "0";
  1000. }
  1001. else if (milOfflineResultEntity.StationCode.Equals("650704"))
  1002. {
  1003. milOfflineResultEntity.Gxsl = "1";
  1004. milOfflineResultEntity.Gxcld = "1";
  1005. milOfflineResultEntity.Gxbj = "2";
  1006. }
  1007. }
  1008. else if (milOfflineResultEntity.PlineCode.Equals("C021"))//镦粗
  1009. {
  1010. if (milOfflineResultEntity.StationCode.Equals("650402"))
  1011. {
  1012. milOfflineResultEntity.Gxsl = "1";
  1013. milOfflineResultEntity.Gxcld = "2";
  1014. milOfflineResultEntity.Gxbj = "0";
  1015. }
  1016. else if (milOfflineResultEntity.StationCode.Equals("650404"))
  1017. {
  1018. milOfflineResultEntity.Gxsl = "1";
  1019. milOfflineResultEntity.Gxcld = "1";
  1020. milOfflineResultEntity.Gxbj = "2";
  1021. }
  1022. }
  1023. else if (milOfflineResultEntity.PlineCode.Equals("C013"))//冷扎
  1024. {
  1025. if (milOfflineResultEntity.StationCode.Equals("650602"))
  1026. {
  1027. milOfflineResultEntity.Gxsl = "1";
  1028. milOfflineResultEntity.Gxcld = "2";
  1029. milOfflineResultEntity.Gxbj = "0";
  1030. }
  1031. else if (milOfflineResultEntity.StationCode.Equals("650604"))
  1032. {
  1033. milOfflineResultEntity.Gxsl = "1";
  1034. milOfflineResultEntity.Gxcld = "1";
  1035. milOfflineResultEntity.Gxbj = "2";
  1036. }
  1037. }
  1038. else if (milOfflineResultEntity.PlineCode.Equals("C014"))//冷拔
  1039. {
  1040. if (milOfflineResultEntity.StationCode.Equals("650502"))
  1041. {
  1042. milOfflineResultEntity.Gxsl = "1";
  1043. milOfflineResultEntity.Gxcld = "2";
  1044. milOfflineResultEntity.Gxbj = "0";
  1045. }
  1046. else if (milOfflineResultEntity.StationCode.Equals("650504"))
  1047. {
  1048. milOfflineResultEntity.Gxsl = "1";
  1049. milOfflineResultEntity.Gxcld = "1";
  1050. milOfflineResultEntity.Gxbj = "2";
  1051. }
  1052. }
  1053. #endregion
  1054. string milOffTity = JSONFormat.Format(milOfflineResultEntity);
  1055. parm.Add(milOffTity);
  1056. }
  1057. parm2.Add(plineCode);
  1058. parm2.Add(this.UserInfo.GetUserName());
  1059. parm2.Add(this.UserInfo.GetUserGroup());
  1060. parm2.Add(this.UserInfo.GetUserOrder());
  1061. parm2.Add(storageNo);
  1062. parm2.Add(feedGx);
  1063. if (MessageUtil.ShowYesNoAndQuestion("是否确认撤销返线?") == DialogResult.No) return;
  1064. CoreClientParam ccp = new CoreClientParam();
  1065. ccp.ServerName = "com.steering.mes.mcp.Vrp.FrmVrpDownLineManage";
  1066. ccp.MethodName = "doCancelReturnLine";
  1067. ccp.ServerParams = new object[] { parm, parm2 };
  1068. ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
  1069. if (ccp.ReturnCode != -1)
  1070. {
  1071. MessageUtil.ShowTips(ccp.ReturnInfo);
  1072. if (ccp.ReturnInfo.Equals("撤销返线成功!"))
  1073. {
  1074. DoQuery();
  1075. }
  1076. }
  1077. }
  1078. /// <summary>
  1079. /// 委外加工
  1080. /// </summary>
  1081. private void DoOutSourc()
  1082. {
  1083. this.ultraGrid1.UpdateData();
  1084. IQueryable<UltraGridRow> checkMagRows = this.ultraGrid1.Rows.AsQueryable().Where(" CHK = 'True'");
  1085. if (checkMagRows.Count() == 0)
  1086. {
  1087. MessageUtil.ShowTips("请勾选需要委外加工的主信息!");
  1088. return;
  1089. }
  1090. ArrayList parm = new ArrayList();
  1091. ArrayList parm2 = new ArrayList();
  1092. foreach (UltraGridRow row in checkMagRows)
  1093. {
  1094. VrpOfflineResultEntity milOfflineResultEntity = (VrpOfflineResultEntity)row.ListObject;
  1095. string milOffTity = JSONFormat.Format(milOfflineResultEntity);
  1096. parm.Add(milOffTity);
  1097. }
  1098. string remark = "";
  1099. string subPlinecode = "";
  1100. string sunPlineName = "";
  1101. string subType = "";
  1102. string subGx = "";
  1103. FrmOutSouType type = new FrmOutSouType(this.ob);
  1104. if (type.ShowDialog() == DialogResult.OK)
  1105. {
  1106. remark=type.Remark;//委外说明
  1107. subPlinecode = type.PlinCode;
  1108. sunPlineName = type.PlineName;
  1109. subType = type.SubconType;
  1110. subGx = type.SubconGx;
  1111. }
  1112. else
  1113. {
  1114. return;
  1115. }
  1116. if (MessageUtil.ShowYesNoAndQuestion("是否确认委外加工?") == DialogResult.No) return;
  1117. parm2.Add(remark);
  1118. parm2.Add(plineCode);
  1119. parm2.Add(this.UserInfo.GetUserName());
  1120. parm2.Add(this.UserInfo.GetUserGroup());
  1121. parm2.Add(this.UserInfo.GetUserOrder());
  1122. parm2.Add(storageNo);
  1123. parm2.Add(subPlinecode);
  1124. parm2.Add(sunPlineName);
  1125. parm2.Add(subType);
  1126. parm2.Add(subGx);
  1127. CoreClientParam ccp = new CoreClientParam();
  1128. ccp.ServerName = "com.steering.mes.mcp.Vrp.FrmVrpDownLineManage";
  1129. ccp.MethodName = "doOutSourc";
  1130. ccp.ServerParams = new object[] { parm, parm2 };
  1131. ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
  1132. if (ccp.ReturnCode != -1)
  1133. {
  1134. MessageUtil.ShowTips(ccp.ReturnInfo);
  1135. if (ccp.ReturnInfo.Equals("委外加工成功!"))
  1136. {
  1137. DoQuery();
  1138. }
  1139. }
  1140. }
  1141. /// <summary>
  1142. /// 撤销委外加工
  1143. /// </summary>
  1144. private void DoCancelOutSourc()
  1145. {
  1146. this.ultraGrid4.UpdateData();
  1147. IQueryable<UltraGridRow> checkMagRows = this.ultraGrid4.Rows.AsQueryable().Where(" CHK = 'True'");
  1148. if (checkMagRows.Count() == 0)
  1149. {
  1150. MessageUtil.ShowTips("请勾选需要撤销的委外加工信息!");
  1151. return;
  1152. }
  1153. ArrayList parm2 = new ArrayList();
  1154. foreach (UltraGridRow row in checkMagRows)
  1155. {
  1156. ArrayList parm = new ArrayList();
  1157. parm.Add(row.Cells["RESULT_NO"].Text.ToString());
  1158. parm.Add(row.Cells["SUBCONTRACT_NO"].Text.ToString());
  1159. parm.Add(row.Cells["SUBCONTRACT_NO_SEQ"].Text.ToString());
  1160. parm.Add(plineCode);
  1161. parm.Add(this.UserInfo.GetUserName());
  1162. parm.Add(this.UserInfo.GetUserGroup());
  1163. parm.Add(this.UserInfo.GetUserOrder());
  1164. parm.Add(storageNo);
  1165. parm2.Add(parm);
  1166. }
  1167. if (MessageUtil.ShowYesNoAndQuestion("是否确认撤销委外加工?") == DialogResult.No) return;
  1168. CoreClientParam ccp = new CoreClientParam();
  1169. ccp.ServerName = "com.steering.mes.mcp.Vrp.FrmVrpDownLineManage";
  1170. ccp.MethodName = "doCancelOutSourc";
  1171. ccp.ServerParams = new object[] {parm2 };
  1172. ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
  1173. if (ccp.ReturnCode != -1)
  1174. {
  1175. MessageUtil.ShowTips(ccp.ReturnInfo);
  1176. if (ccp.ReturnInfo.Equals("撤销委外加工成功!"))
  1177. {
  1178. DoQuery();
  1179. }
  1180. }
  1181. }
  1182. /// <summary>
  1183. /// 修改标识炉号
  1184. /// </summary>
  1185. private void DoUpdateStoveNo()
  1186. {
  1187. this.ultraGrid1.UpdateData();
  1188. IQueryable<UltraGridRow> checkMagRows = this.ultraGrid1.Rows.AsQueryable().Where(" CHK = 'True'");
  1189. if (checkMagRows.Count() == 0)
  1190. {
  1191. MessageUtil.ShowTips("请勾选需要修改的主信息!");
  1192. return;
  1193. }
  1194. ArrayList parm = new ArrayList();
  1195. ArrayList parm2 = new ArrayList();
  1196. foreach (UltraGridRow row in checkMagRows)
  1197. {
  1198. ArrayList list = new ArrayList();
  1199. list.Add(row.Cells["FlagStoveNo"].Text.ToString().Trim());
  1200. list.Add(row.Cells["ResultNo"].Text.ToString());
  1201. parm.Add(list);
  1202. }
  1203. if (MessageUtil.ShowYesNoAndQuestion("是否修改标识炉号?") == DialogResult.No) return;
  1204. CoreClientParam ccp = new CoreClientParam();
  1205. ccp.ServerName = "com.steering.mes.mcp.Vrp.FrmVrpDownLineManage";
  1206. ccp.MethodName = "doUpdateFlagStoveNo";
  1207. ccp.ServerParams = new object[] { parm };
  1208. ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
  1209. if (ccp.ReturnCode != -1)
  1210. {
  1211. MessageUtil.ShowTips(ccp.ReturnInfo);
  1212. if (ccp.ReturnInfo.Equals("标识炉号修改成功!"))
  1213. {
  1214. DoQuery();
  1215. }
  1216. }
  1217. }
  1218. /// <summary>
  1219. /// 数据验证
  1220. /// </summary>
  1221. /// <returns></returns>
  1222. private bool CheckQuery()
  1223. {
  1224. if (DataTimeUtil.JudgeTime(DateTime.Parse(StartTime.Value.ToString()), DateTime.Parse(EndTime.Value.ToString())) == 0)
  1225. {
  1226. MessageUtil.ShowTips("您所选择的日期区域不对,请重新选择!");
  1227. return false;
  1228. }
  1229. if (this.chkJugeHeatNo.Checked && string.IsNullOrEmpty(this.txtJugeNo.Text.Trim()))
  1230. {
  1231. MessageUtil.ShowWarning("请输入炉号!");
  1232. return false;
  1233. }
  1234. if (this.chkBatch.Checked && string.IsNullOrEmpty(this.txtBatch.Text.Trim()))
  1235. {
  1236. MessageUtil.ShowWarning("请输入生产批号!");
  1237. return false;
  1238. }
  1239. if (this.chkGx.Checked && string.IsNullOrEmpty(this.cmbGx.Text.Trim()))
  1240. {
  1241. MessageUtil.ShowWarning("请选择工序点!");
  1242. return false;
  1243. }
  1244. if (this.chkStrat.Checked && string.IsNullOrEmpty(this.cmbStrat.Text.Trim()))
  1245. {
  1246. MessageUtil.ShowWarning("请选择委外状态!");
  1247. return false;
  1248. }
  1249. return true;
  1250. }
  1251. private void chkTim_CheckedChanged(object sender, EventArgs e)
  1252. {
  1253. if (chkTim.Checked) { StartTime.Enabled = true; EndTime.Enabled = true; } else { StartTime.Enabled = false; EndTime.Enabled = false; }
  1254. if (chkJugeHeatNo.Checked) { txtJugeNo.Enabled = true; } else { txtJugeNo.Enabled = false; }
  1255. if (chkBatch.Checked) { txtBatch.Enabled = true; } else { txtBatch.Enabled = false; }
  1256. if (chkGx.Checked) { cmbGx.Enabled = true; } else { cmbGx.Enabled = false; }
  1257. if (chkStrat.Checked) { cmbStrat.Enabled = true; } else { cmbStrat.Enabled = false; }
  1258. }
  1259. private void ultraGrid1_ClickCellButton(object sender, Infragistics.Win.UltraWinGrid.CellEventArgs e)
  1260. {
  1261. UltraGridRow row =ultraGrid1.ActiveRow;
  1262. this.ultraGrid1.UpdateData();
  1263. if (e.Cell.Column.Key == "ProcessOrder")
  1264. {
  1265. FrmOrderDialog orderZg = new FrmOrderDialog(this.ob, row.Cells["PlineCode"].Text.ToString(), row.Cells["ProPlanId"].Text.ToString(), row.Cells["GxPlanNo"].Text.ToString(), row.Cells["ActDimater"].Text.ToString(), row.Cells["ActHeight"].Text.ToString());
  1266. orderZg.ShowDialog();
  1267. SlmOrderLineEntity slmEntity = orderZg.SlmEntity;
  1268. if (slmEntity == null)
  1269. {
  1270. return;
  1271. }
  1272. e.Cell.Row.Cells["ProcessOrder"].Value = slmEntity.OrderNo + "/" + slmEntity.OrderSeq + "/"+slmEntity.DeliveryNo;
  1273. e.Cell.Row.Cells["OrderNo"].Value = slmEntity.OrderNo;
  1274. e.Cell.Row.Cells["OrderSeq"].Value = slmEntity.OrderSeq;
  1275. e.Cell.Row.Cells["DeliveryNo"].Value = slmEntity.DeliveryNo;
  1276. e.Cell.Row.Cells["OrdLnDlyPk"].Value = slmEntity.OrdLnDlyPk;
  1277. //e.Cell.Row.Cells["PRO_PLAN_ID"].Value = slmEntity.ProPlanId;
  1278. e.Cell.Row.Cells["Producname"].Value = slmEntity.Producname;
  1279. e.Cell.Row.Cells["Produccode"].Value = slmEntity.Produccode;
  1280. e.Cell.Row.Cells["Steelcode"].Value = slmEntity.Steelcode;
  1281. e.Cell.Row.Cells["Steelname"].Value = slmEntity.Steelname;
  1282. //e.Cell.Row.Cells["SpecName"].Value = slmEntity.SpecName;
  1283. e.Cell.Row.Cells["ModelCode"].Value = slmEntity.ModelCode;
  1284. e.Cell.Row.Cells["ModelDesc"].Value = slmEntity.ModelDesc;
  1285. e.Cell.Row.Cells["StdStyle"].Value = slmEntity.StdStyle;
  1286. e.Cell.Row.Cells["StdStyleDesc"].Value = slmEntity.StdStyleDesc;
  1287. e.Cell.Row.Cells["StdCode"].Value = slmEntity.StdCode;
  1288. e.Cell.Row.Cells["StdName"].Value = slmEntity.StdName;
  1289. string[] str = slmEntity.SpecName.ToString().Split('x');
  1290. e.Cell.Row.Cells["ActDimater"].Value = slmEntity.Dimater;
  1291. e.Cell.Row.Cells["ActHeight"].Value = slmEntity.Height;
  1292. e.Cell.Row.Cells["ProPlanId"].Value = slmEntity.ProPlanId;
  1293. e.Cell.Row.Cells["GxPlanNo"].Value = slmEntity.GxPlanNo;
  1294. }
  1295. }
  1296. private void FrmVrpDownLineManage_Shown(object sender, EventArgs e)
  1297. {
  1298. if (toolMenu.Toolbars[0].Tools.Exists("CancelFurnace"))
  1299. {
  1300. toolMenu.Toolbars[0].Tools["CancelFurnace"].InstanceProps.Visible = DefaultableBoolean.False;
  1301. }
  1302. if (toolMenu.Toolbars[0].Tools.Exists("CancelReturnLine"))
  1303. {
  1304. toolMenu.Toolbars[0].Tools["CancelReturnLine"].InstanceProps.Visible = DefaultableBoolean.False;
  1305. }
  1306. if (toolMenu.Toolbars[0].Tools.Exists("CancelOutSourc"))
  1307. {
  1308. toolMenu.Toolbars[0].Tools["CancelOutSourc"].InstanceProps.Visible = DefaultableBoolean.False;
  1309. }
  1310. if (toolMenu.Toolbars[0].Tools.Exists("OrdersSourc"))
  1311. {
  1312. toolMenu.Toolbars[0].Tools["OrdersSourc"].InstanceProps.Visible = DefaultableBoolean.False;
  1313. }
  1314. }
  1315. private void ultraTabControl1_SelectedTabChanged(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e)
  1316. {
  1317. if (toolMenu == null) return;
  1318. if (ultraTabControl1.SelectedTab.Key == "0")
  1319. {
  1320. if (toolMenu.Toolbars[0].Tools.Exists("SetFurnace"))
  1321. {
  1322. toolMenu.Toolbars[0].Tools["SetFurnace"].InstanceProps.Visible = DefaultableBoolean.True;
  1323. }
  1324. if (toolMenu.Toolbars[0].Tools.Exists("CancelFurnace"))
  1325. {
  1326. toolMenu.Toolbars[0].Tools["CancelFurnace"].InstanceProps.Visible = DefaultableBoolean.False;
  1327. }
  1328. if (toolMenu.Toolbars[0].Tools.Exists("OnlineComm"))
  1329. {
  1330. toolMenu.Toolbars[0].Tools["OnlineComm"].InstanceProps.Visible = DefaultableBoolean.True;
  1331. }
  1332. if (toolMenu.Toolbars[0].Tools.Exists("ReturnLine"))
  1333. {
  1334. toolMenu.Toolbars[0].Tools["ReturnLine"].InstanceProps.Visible = DefaultableBoolean.True;
  1335. }
  1336. if (toolMenu.Toolbars[0].Tools.Exists("ReturnInstore"))
  1337. {
  1338. toolMenu.Toolbars[0].Tools["ReturnInstore"].InstanceProps.Visible = DefaultableBoolean.True;
  1339. }
  1340. if (toolMenu.Toolbars[0].Tools.Exists("CancelReturnLine"))
  1341. {
  1342. toolMenu.Toolbars[0].Tools["CancelReturnLine"].InstanceProps.Visible = DefaultableBoolean.False;
  1343. }
  1344. if (toolMenu.Toolbars[0].Tools.Exists("OutSourc"))
  1345. {
  1346. toolMenu.Toolbars[0].Tools["OutSourc"].InstanceProps.Visible = DefaultableBoolean.True;
  1347. }
  1348. if (toolMenu.Toolbars[0].Tools.Exists("CancelOutSourc"))
  1349. {
  1350. toolMenu.Toolbars[0].Tools["CancelOutSourc"].InstanceProps.Visible = DefaultableBoolean.False;
  1351. }
  1352. if (toolMenu.Toolbars[0].Tools.Exists("OrdersSourc"))
  1353. {
  1354. toolMenu.Toolbars[0].Tools["OrdersSourc"].InstanceProps.Visible = DefaultableBoolean.False;
  1355. }
  1356. if (toolMenu.Toolbars[0].Tools.Exists("UpdateFalg"))
  1357. {
  1358. toolMenu.Toolbars[0].Tools["UpdateFalg"].InstanceProps.Visible = DefaultableBoolean.True;
  1359. }
  1360. chkTim.Text = "离线日期";
  1361. chkGx.Visible = true;
  1362. cmbGx.Visible = true;
  1363. chkStrat.Visible = false;
  1364. cmbStrat.Visible = false;
  1365. chkGx.Checked = false;
  1366. chkStrat.Checked = false;
  1367. }
  1368. else if (ultraTabControl1.SelectedTab.Key == "1")
  1369. {
  1370. if (toolMenu.Toolbars[0].Tools.Exists("SetFurnace"))
  1371. {
  1372. toolMenu.Toolbars[0].Tools["SetFurnace"].InstanceProps.Visible = DefaultableBoolean.False;
  1373. }
  1374. if (toolMenu.Toolbars[0].Tools.Exists("CancelFurnace"))
  1375. {
  1376. toolMenu.Toolbars[0].Tools["CancelFurnace"].InstanceProps.Visible = DefaultableBoolean.True;
  1377. }
  1378. if (toolMenu.Toolbars[0].Tools.Exists("OnlineComm"))
  1379. {
  1380. toolMenu.Toolbars[0].Tools["OnlineComm"].InstanceProps.Visible = DefaultableBoolean.False;
  1381. }
  1382. if (toolMenu.Toolbars[0].Tools.Exists("ReturnLine"))
  1383. {
  1384. toolMenu.Toolbars[0].Tools["ReturnLine"].InstanceProps.Visible = DefaultableBoolean.False;
  1385. }
  1386. if (toolMenu.Toolbars[0].Tools.Exists("ReturnInstore"))
  1387. {
  1388. toolMenu.Toolbars[0].Tools["ReturnInstore"].InstanceProps.Visible = DefaultableBoolean.False;
  1389. }
  1390. if (toolMenu.Toolbars[0].Tools.Exists("CancelReturnLine"))
  1391. {
  1392. toolMenu.Toolbars[0].Tools["CancelReturnLine"].InstanceProps.Visible = DefaultableBoolean.False;
  1393. }
  1394. if (toolMenu.Toolbars[0].Tools.Exists("OutSourc"))
  1395. {
  1396. toolMenu.Toolbars[0].Tools["OutSourc"].InstanceProps.Visible = DefaultableBoolean.False;
  1397. }
  1398. if (toolMenu.Toolbars[0].Tools.Exists("CancelOutSourc"))
  1399. {
  1400. toolMenu.Toolbars[0].Tools["CancelOutSourc"].InstanceProps.Visible = DefaultableBoolean.False;
  1401. }
  1402. if (toolMenu.Toolbars[0].Tools.Exists("OrdersSourc"))
  1403. {
  1404. toolMenu.Toolbars[0].Tools["OrdersSourc"].InstanceProps.Visible = DefaultableBoolean.False;
  1405. }
  1406. if (toolMenu.Toolbars[0].Tools.Exists("UpdateFalg"))
  1407. {
  1408. toolMenu.Toolbars[0].Tools["UpdateFalg"].InstanceProps.Visible = DefaultableBoolean.False;
  1409. }
  1410. chkTim.Text = "组炉日期";
  1411. chkGx.Visible = true;
  1412. cmbGx.Visible = true;
  1413. chkStrat.Visible = false;
  1414. cmbStrat.Visible = false;
  1415. chkGx.Checked = false;
  1416. chkStrat.Checked = false;
  1417. }
  1418. else if (ultraTabControl1.SelectedTab.Key == "2")
  1419. {
  1420. if (toolMenu.Toolbars[0].Tools.Exists("SetFurnace"))
  1421. {
  1422. toolMenu.Toolbars[0].Tools["SetFurnace"].InstanceProps.Visible = DefaultableBoolean.False;
  1423. }
  1424. if (toolMenu.Toolbars[0].Tools.Exists("CancelFurnace"))
  1425. {
  1426. toolMenu.Toolbars[0].Tools["CancelFurnace"].InstanceProps.Visible = DefaultableBoolean.False;
  1427. }
  1428. if (toolMenu.Toolbars[0].Tools.Exists("OnlineComm"))
  1429. {
  1430. toolMenu.Toolbars[0].Tools["OnlineComm"].InstanceProps.Visible = DefaultableBoolean.False;
  1431. }
  1432. if (toolMenu.Toolbars[0].Tools.Exists("ReturnLine"))
  1433. {
  1434. toolMenu.Toolbars[0].Tools["ReturnLine"].InstanceProps.Visible = DefaultableBoolean.False;
  1435. }
  1436. if (toolMenu.Toolbars[0].Tools.Exists("CancelReturnLine"))
  1437. {
  1438. toolMenu.Toolbars[0].Tools["CancelReturnLine"].InstanceProps.Visible = DefaultableBoolean.True;
  1439. }
  1440. if (toolMenu.Toolbars[0].Tools.Exists("OutSourc"))
  1441. {
  1442. toolMenu.Toolbars[0].Tools["OutSourc"].InstanceProps.Visible = DefaultableBoolean.False;
  1443. }
  1444. if (toolMenu.Toolbars[0].Tools.Exists("CancelOutSourc"))
  1445. {
  1446. toolMenu.Toolbars[0].Tools["CancelOutSourc"].InstanceProps.Visible = DefaultableBoolean.False;
  1447. }
  1448. if (toolMenu.Toolbars[0].Tools.Exists("OrdersSourc"))
  1449. {
  1450. toolMenu.Toolbars[0].Tools["OrdersSourc"].InstanceProps.Visible = DefaultableBoolean.False;
  1451. }
  1452. if (toolMenu.Toolbars[0].Tools.Exists("UpdateFalg"))
  1453. {
  1454. toolMenu.Toolbars[0].Tools["UpdateFalg"].InstanceProps.Visible = DefaultableBoolean.False;
  1455. }
  1456. chkTim.Text = "返线日期";
  1457. chkGx.Visible = true;
  1458. cmbGx.Visible = true;
  1459. chkStrat.Visible = false;
  1460. cmbStrat.Visible = false;
  1461. chkGx.Checked = false;
  1462. chkStrat.Checked = false;
  1463. }
  1464. else if (ultraTabControl1.SelectedTab.Key == "3")
  1465. {
  1466. if (toolMenu.Toolbars[0].Tools.Exists("SetFurnace"))
  1467. {
  1468. toolMenu.Toolbars[0].Tools["SetFurnace"].InstanceProps.Visible = DefaultableBoolean.False;
  1469. }
  1470. if (toolMenu.Toolbars[0].Tools.Exists("CancelFurnace"))
  1471. {
  1472. toolMenu.Toolbars[0].Tools["CancelFurnace"].InstanceProps.Visible = DefaultableBoolean.False;
  1473. }
  1474. if (toolMenu.Toolbars[0].Tools.Exists("OnlineComm"))
  1475. {
  1476. toolMenu.Toolbars[0].Tools["OnlineComm"].InstanceProps.Visible = DefaultableBoolean.False;
  1477. }
  1478. if (toolMenu.Toolbars[0].Tools.Exists("ReturnLine"))
  1479. {
  1480. toolMenu.Toolbars[0].Tools["ReturnLine"].InstanceProps.Visible = DefaultableBoolean.False;
  1481. }
  1482. if (toolMenu.Toolbars[0].Tools.Exists("ReturnInstore"))
  1483. {
  1484. toolMenu.Toolbars[0].Tools["ReturnInstore"].InstanceProps.Visible = DefaultableBoolean.False;
  1485. }
  1486. if (toolMenu.Toolbars[0].Tools.Exists("CancelReturnLine"))
  1487. {
  1488. toolMenu.Toolbars[0].Tools["CancelReturnLine"].InstanceProps.Visible = DefaultableBoolean.False;
  1489. }
  1490. if (toolMenu.Toolbars[0].Tools.Exists("OutSourc"))
  1491. {
  1492. toolMenu.Toolbars[0].Tools["OutSourc"].InstanceProps.Visible = DefaultableBoolean.False;
  1493. }
  1494. if (toolMenu.Toolbars[0].Tools.Exists("CancelOutSourc"))
  1495. {
  1496. toolMenu.Toolbars[0].Tools["CancelOutSourc"].InstanceProps.Visible = DefaultableBoolean.True;
  1497. }
  1498. if (toolMenu.Toolbars[0].Tools.Exists("OrdersSourc"))
  1499. {
  1500. toolMenu.Toolbars[0].Tools["OrdersSourc"].InstanceProps.Visible = DefaultableBoolean.True;
  1501. }
  1502. if (toolMenu.Toolbars[0].Tools.Exists("UpdateFalg"))
  1503. {
  1504. toolMenu.Toolbars[0].Tools["UpdateFalg"].InstanceProps.Visible = DefaultableBoolean.False;
  1505. }
  1506. chkTim.Text = "委外日期";
  1507. chkGx.Visible = false;
  1508. cmbGx.Visible = false;
  1509. chkStrat.Visible = true;
  1510. cmbStrat.Visible = true;
  1511. chkGx.Checked = false;
  1512. chkStrat.Checked = false;
  1513. }
  1514. }
  1515. private void ultraGrid3_InitializeRow(object sender, InitializeRowEventArgs e)
  1516. {
  1517. VrpOfflineResultEntity VrpOfflineResultEntity = e.Row.ListObject as VrpOfflineResultEntity;
  1518. if (VrpOfflineResultEntity != null && VrpOfflineResultEntity.Flag=="1")
  1519. {
  1520. e.Row.Appearance.BackColor = Color.Gray;
  1521. }
  1522. }
  1523. }
  1524. }