FrmFeedLoadResult.cs 25 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664
  1. using com.steering.mes.zgmil.entity;
  2. using Core.Mes.Client.Comm.Control;
  3. using Core.Mes.Client.Comm.Format;
  4. using Core.Mes.Client.Comm.Server;
  5. using Core.Mes.Client.Comm.Tool;
  6. using Core.StlMes.Client.ZGMil.Common;
  7. using Core.StlMes.Client.ZGMil.Entity;
  8. using Core.StlMes.Client.ZGMil.NodeResultQuery;
  9. using Core.StlMes.Client.ZGMil.Popup;
  10. using Core.StlMes.Client.ZGMil.ResultConrtrol;
  11. using CoreFS.CA06;
  12. using Infragistics.Win.UltraWinGrid;
  13. using System;
  14. using System.Collections;
  15. using System.Collections.Generic;
  16. using System.ComponentModel;
  17. using System.Data;
  18. using System.Drawing;
  19. using System.Linq;
  20. using System.Text;
  21. using System.Windows.Forms;
  22. namespace Core.StlMes.Client.ZGMil.Result
  23. {
  24. public partial class FrmFeedLoadResult : FrmBase
  25. {
  26. private string departm = "";
  27. private string plineCode = "";
  28. private string user = "";
  29. private string bc = "";
  30. private string bz = "";
  31. private string Shift = "";
  32. private string Group = "";
  33. private string[] pCode;
  34. private string[] arr;
  35. FeedRowPlan Feedplan = new FeedRowPlan();
  36. private string proPlanId = null;//轧管订单编号
  37. private string gxPlanNo = null;//工序排产序号
  38. private string lotNo = null;//生产批号
  39. private string Departm = "";//部门
  40. private string PlineCode = "";//产线
  41. private string _UserName = ""; //签名 姓名
  42. private string _Url = ""; //签名 Url
  43. private string _UserID = ""; //签名 签名ID
  44. //private string plineCode = "";
  45. public FrmFeedLoadResult()
  46. {
  47. InitializeComponent();
  48. this.IsLoadUserView = true;
  49. //NativeMethodNew na = new NativeMethodNew(this.ob);
  50. //departm = UserInfo.GetDepartment();
  51. //PlineCode = na.GetPCode(departm); //获取 用户 对应的产线
  52. StartTime.Value = DateTime.Parse(DateTime.Now.AddDays(-10).ToString("yyyy-MM-dd"));
  53. }
  54. public override void ToolBar_Click(object sender, string ToolbarKey)
  55. {
  56. switch (ToolbarKey)
  57. {
  58. case "Query":
  59. doQuery();
  60. break;
  61. //case "Add":
  62. // add();
  63. // break;
  64. //case "Delete":
  65. // delete();
  66. // break;
  67. case "DoTryRollingMaterial":
  68. DoTryRollingMaterial();
  69. break;
  70. case "DoUpdateDate":
  71. UpdateDatePlan();
  72. break;
  73. case "Node":
  74. node();
  75. break;
  76. case "NodeBack":
  77. nodeBack();
  78. break;
  79. case "DoSign":
  80. Sign();
  81. break;
  82. case "DoPrint":
  83. DoPrint();
  84. break;
  85. case "Close":
  86. this.Close();
  87. break;
  88. }
  89. }
  90. #region 方法
  91. /// <summary>
  92. /// 页面开启事件
  93. /// </summary>
  94. /// <param name="e"></param>
  95. protected override void OnShown(EventArgs e)
  96. {
  97. base.OnShown(e);
  98. Sign();
  99. }
  100. /// <summary>
  101. /// 签名
  102. /// </summary>
  103. private void Sign()
  104. {
  105. ColUserName col = new ColUserName();
  106. col.StationId = "13";
  107. col.PlineCode = PlineCode;
  108. col.ColGroup = Group;
  109. col.Ob = this.ob;
  110. col.ShowDialog();
  111. _UserID = col.getUserId();
  112. _UserName = col.getUserName();
  113. }
  114. private void DoPrint()
  115. {
  116. this.ultraGrid1.UpdateData();
  117. string plineCode = "";
  118. UltraGridRow uRow = ultraGrid1.ActiveRow;
  119. if (uRow == null)
  120. {
  121. MessageUtil.ShowTips("请选择需要打印的炉信息!");
  122. return;
  123. }
  124. plineCode = uRow.Cells["PLINE_CODE"].Value.ToString();
  125. string strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepMilLoad.cpt&op=view&PLINE_CODE=" + plineCode;
  126. FrmExcel fre = new FrmExcel(this.ob, strurl);
  127. fre.AutoSize = true;
  128. fre.MaximumSize = new Size(Screen.PrimaryScreen.WorkingArea.Width, Screen.PrimaryScreen.WorkingArea.Height);
  129. fre.WindowState = FormWindowState.Maximized;
  130. fre.Show();
  131. }
  132. /// <summary>
  133. /// 更改girdRow颜色
  134. /// </summary>
  135. public void ChangeGridColor()
  136. {
  137. if (ultraGrid1.Rows.Count > 0)
  138. {
  139. foreach (UltraGridRow ugr in ultraGrid1.Rows)
  140. {
  141. if (int.Parse(ugr.Cells["REAL_INDOUBLE_NUM"].Value.ToString()) > 0)
  142. {
  143. ugr.Appearance.BackColor = Color.YellowGreen;
  144. }
  145. }
  146. }
  147. }
  148. /// <summary>
  149. /// 上料支都到了投料库Grid1变颜色
  150. /// </summary>
  151. //public void ChangeGrid1Color()
  152. //{
  153. // int a = 0;
  154. // int b = 0;
  155. // string tlk = "";
  156. // switch (PlineCode)
  157. // {
  158. // case "C008":
  159. // tlk = "250投料库";
  160. // break;
  161. // case "C009":
  162. // tlk = "258投料库";
  163. // break;
  164. // case "C010":
  165. // tlk = "168投料库";
  166. // break;
  167. // case "C017":
  168. // tlk = "460投料库";
  169. // break;
  170. // }
  171. // if (ultraGrid2.Rows.Count > 0)
  172. // {
  173. // foreach (UltraGridRow uRow in ultraGrid2.Rows)
  174. // {
  175. // a += int.Parse(uRow.Cells["ACT_COUNT"].Value.ToString3()) ;
  176. // }
  177. // }
  178. // if (ultraGrid5.Rows.Count > 0)
  179. // {
  180. // foreach (UltraGridRow uRow in ultraGrid5.Rows)
  181. // {
  182. // if (tlk == uRow.Cells["STORAGE_NO"].Value.ToString())
  183. // {
  184. // b += int.Parse(uRow.Cells["ACT_COUNT"].Value.ToString3());
  185. // }
  186. // }
  187. // }
  188. // if (a == b)
  189. // {
  190. // ultraGrid1.ActiveRow.Appearance.BackColor = Color.LimeGreen;
  191. // }
  192. //}
  193. /// <summary>
  194. /// 数据同步
  195. /// </summary>
  196. public void UpdateDatePlan()
  197. {
  198. SyncPro frm = new SyncPro(this.ob, plineCode);
  199. frm.ShowDialog();
  200. //int count = ServerHelper.SetData("com.steering.mes.zgmil.coup.GetSQLDate.getPlanQuery", new object[] { }, this.ob);
  201. //MessageBox.Show("计划同步完成!", "提示:", MessageBoxButtons.OK, MessageBoxIcon.Warning);
  202. doQuery();
  203. }
  204. /// <summary>
  205. /// 试轧料
  206. /// </summary>
  207. private void DoTryRollingMaterial()
  208. {
  209. string Shift = UserInfo.GetUserOrder();
  210. string Group = UserInfo.GetUserGroup();
  211. FrmTryRollingMaterial FrmBS = new FrmTryRollingMaterial(Shift, Shift, _UserName, this.ob, PlineCode, arr, pCode);
  212. FrmBS.ShowDialog();
  213. doQuery();
  214. }
  215. /// <summary>
  216. /// 上料回退
  217. /// </summary>
  218. private void nodeBack()
  219. {
  220. ArrayList parm = new ArrayList();
  221. ArrayList parm2 = new ArrayList();
  222. UltraGridRow ugr = ultraGrid1.ActiveRow;
  223. IQueryable<UltraGridRow> uGrid = ultraGrid2.Rows.AsQueryable().Where(" CHK = 'True'");
  224. if (uGrid.Count() == 0)
  225. {
  226. MessageUtil.ShowTips("请选择要上料回退的数据!");
  227. return;
  228. }
  229. if (ultraGrid2.Rows.Count > 0)
  230. {
  231. foreach (UltraGridRow uRow in uGrid)
  232. {
  233. if (int.Parse(uRow.Cells["ACT_COUNT"].Value.ToString3()) > int.Parse(uRow.Cells["REAL_INDOUBLE_NUM"].Value.ToString3()))
  234. {
  235. MessageUtil.ShowTips("输入的支数不能大于已上料支数!");
  236. return;
  237. }
  238. if (!StringUtil.IsInt(uRow.Cells["ACT_COUNT"].Value.ToString3()))
  239. {
  240. MessageUtil.ShowTips("输入的操作支不为整数,请重新输入!");
  241. return;
  242. }
  243. ArrayList list = new ArrayList();
  244. list.Add(uRow.Cells["JUDGE_STOVE_NO"].Value.ToString());
  245. list.Add(uRow.Cells["JUGDE_APPLY_CODE"].Value.ToString());
  246. list.Add(uRow.Cells["REAL_INDOUBLE_NUM"].Text.ToString3()); //已上料支
  247. list.Add(uRow.Cells["CUT_NUM_GP"].Value.ToString3());
  248. list.Add(ugr.Cells["PRO_PLAN_ID"].Value.ToString());
  249. list.Add(ugr.Cells["GX_PLAN_NO"].Value.ToString());
  250. list.Add(uRow.Cells["FEED_LENGTH"].Value.ToString3());
  251. list.Add(uRow.Cells["CUT_TARGET"].Value.ToString()); //切损去向
  252. list.Add(uRow.Cells["CUT_LENGTH"].Value.ToString3()); //切损长度
  253. list.Add(uRow.Cells["CUT_WEIGHT"].Value.ToString3()); //切损重量
  254. parm.Add(list);
  255. }
  256. }
  257. else
  258. {
  259. MessageUtil.ShowTips("没有可上料回退的数据!");
  260. return;
  261. }
  262. if (int.Parse(ugr.Cells["REAL_INDOUBLE_NUM"].Value.ToString()) == 0)
  263. {
  264. MessageUtil.ShowTips("此炉未上料,不能上料回退!");
  265. return;
  266. }
  267. parm2.Add(ugr.Cells["FEED_HEAT_NO"].Value.ToString());
  268. parm2.Add(ugr.Cells["PRO_PLAN_ID"].Value.ToString());
  269. parm2.Add(ugr.Cells["GX_PLAN_NO"].Value.ToString());
  270. parm2.Add(ugr.Cells["PLINE_CODE"].Value.ToString());
  271. parm2.Add(ugr.Cells["HEAT_PLAN_NO"].Value.ToString());
  272. CoreClientParam ccp = new CoreClientParam();
  273. ccp.ServerName = "com.steering.mes.zgmil.coup.FrmFeedLoad";
  274. ccp.MethodName = "nodeBack";
  275. ccp.ServerParams = new object[] { parm, parm2 };
  276. ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
  277. if (ccp.ReturnInfo == "上料回退成功!")
  278. {
  279. MessageUtil.ShowTips("上料回退成功!");
  280. doQuery();
  281. }
  282. else
  283. {
  284. MessageUtil.ShowTips(ccp.ReturnInfo);
  285. }
  286. }
  287. /// <summary>
  288. /// 上料确认
  289. /// </summary>
  290. private void node()
  291. {
  292. ArrayList parm = new ArrayList();
  293. ArrayList parm2 = new ArrayList();
  294. UltraGridRow ultragrid = ultraGrid1.ActiveRow;
  295. if (ultragrid.Cells["INWL_DESC"].Value.ToString() == "" || ultragrid.Cells["OUTWL_DESC"].Value.ToString() == "")
  296. {
  297. MessageUtil.ShowTips("缺少物料码,请联系计划员重新做计划!");
  298. return;
  299. }
  300. IQueryable<UltraGridRow> uGrid = ultraGrid2.Rows.AsQueryable().Where(" CHK = 'True'");
  301. if (uGrid.Count() == 0)
  302. {
  303. MessageUtil.ShowTips("请选择要上料的数据!");
  304. return;
  305. }
  306. IQueryable<UltraGridRow> uGrid2 = ultraGrid2.Rows.AsQueryable().Where(" CHK = 'False'");
  307. if (uGrid2.Count() > 0)
  308. {
  309. MessageUtil.ShowTips("有上料行没有打勾,请联系计划删除不用上料的计划行!");
  310. return;
  311. }
  312. if (ultraGrid2.Rows.Count > 0)
  313. {
  314. int a = 0;
  315. double b = 0.0;
  316. foreach (UltraGridRow uRow in uGrid)
  317. {
  318. if (int.Parse(uRow.Cells["ACT_COUNT"].Value.ToString3()) > int.Parse(uRow.Cells["PLAN_INDOUBLE_NUM"].Value.ToString3()))
  319. {
  320. MessageUtil.ShowTips("输入的上料支不能大于计划上料支!");
  321. return;
  322. }
  323. if (!StringUtil.IsInt(uRow.Cells["ACT_COUNT"].Value.ToString3()))
  324. {
  325. MessageUtil.ShowTips("输入的上料支不为整数,请重新输入!");
  326. return;
  327. }
  328. if (int.Parse(uRow.Cells["ACT_COUNT"].Value.ToString3()) < 1)
  329. {
  330. MessageUtil.ShowTips("存在不上料的计划行,请通知计划重新下计划!");
  331. return;
  332. }
  333. //if(!uRow.Cells["STORAGE_NO"].Text.ToString3().Contains("投料库"))
  334. //{
  335. // MessageUtil.ShowTips("还有管坯未到投料库,不能上料!");
  336. // return;
  337. //}
  338. a += int.Parse(uRow.Cells["ACT_COUNT"].Value.ToString3()) * int.Parse(uRow.Cells["CUT_NUM_GP"].Value.ToString3());
  339. if (int.Parse(uRow.Cells["PLAN_INDOUBLE_NUM"].Value.ToString3()) == int.Parse(uRow.Cells["ACT_COUNT"].Value.ToString3()))
  340. {
  341. b += double.Parse(uRow.Cells["PLAN_INDOUBLE_WT"].Value.ToString3());
  342. }
  343. else
  344. {
  345. b += int.Parse(uRow.Cells["ACT_COUNT"].Value.ToString3()) * double.Parse(uRow.Cells["WEIGHT_M"].Value.ToString3());
  346. }
  347. ArrayList list = new ArrayList();
  348. list.Add(uRow.Cells["JUDGE_STOVE_NO"].Value.ToString());
  349. list.Add(uRow.Cells["JUGDE_APPLY_CODE"].Text.ToString());
  350. list.Add(uRow.Cells["ACT_COUNT"].Value.ToString3()); //实绩上料支
  351. list.Add(uRow.Cells["CUT_NUM_GP"].Value.ToString3());
  352. list.Add(ultragrid.Cells["PRO_PLAN_ID"].Value.ToString());
  353. list.Add(ultragrid.Cells["GX_PLAN_NO"].Value.ToString());
  354. list.Add(uRow.Cells["FEED_LENGTH"].Value.ToString3());
  355. list.Add(uRow.Cells["HEAT_PLAN_SQE"].Value.ToString()); //上料行ID
  356. list.Add(uRow.Cells["CUT_TARGET"].Value.ToString()); //切损去向
  357. list.Add(uRow.Cells["CUT_LENGTH"].Value.ToString3()); //切损长度
  358. list.Add(uRow.Cells["CUT_WEIGHT"].Value.ToString3()); //切损重量
  359. list.Add(uRow.Cells["PLAN_INDOUBLE_NUM"].Value.ToString()); //计划上料支
  360. parm.Add(list);
  361. }
  362. actualNum.Value = a;
  363. actualWeight.Value = b;
  364. }
  365. else {
  366. MessageUtil.ShowTips("没有可上料的数据!");
  367. return;
  368. }
  369. UltraGridRow ugr = ultraGrid1.ActiveRow;
  370. if (int.Parse(ugr.Cells["REAL_INDOUBLE_NUM"].Value.ToString()) > 0)
  371. {
  372. MessageUtil.ShowTips("此炉已上料!");
  373. return;
  374. }
  375. parm2.Add(ugr.Cells["FEED_HEAT_NO"].Value.ToString());
  376. parm2.Add(ugr.Cells["PRO_PLAN_ID"].Value.ToString());
  377. parm2.Add(ugr.Cells["GX_PLAN_NO"].Value.ToString());
  378. parm2.Add(ugr.Cells["PLINE_CODE"].Value.ToString());
  379. parm2.Add(Shift);
  380. parm2.Add(Group);
  381. parm2.Add(_UserName);
  382. parm2.Add(_UserID);
  383. parm2.Add(actualNum.Value.ToString());
  384. parm2.Add(actualWeight.Value.ToString());
  385. parm2.Add(ugr.Cells["HEAT_PLAN_NO"].Value.ToString());
  386. Feedplan.ResultNo = ugr.Cells["HEAT_PLAN_NO"].Value.ToString();
  387. Feedplan.LotNo = ugr.Cells["ZY_BATCH_ID"].Value.ToString();
  388. Feedplan.JudgeStoveNo = ugr.Cells["FEED_HEAT_NO"].Value.ToString() + "-01";
  389. Feedplan.StoveNo = "";
  390. Feedplan.PlineCode = ugr.Cells["PLINE_CODE"].Value.ToString();
  391. Feedplan.ProPlanId = ugr.Cells["PRO_PLAN_ID"].Value.ToString();
  392. Feedplan.GxPlanNo = ugr.Cells["GX_PLAN_NO"].Value.ToString();
  393. Feedplan.CutTarget = ugr.Cells["DECISION"].Value.ToString();//判定字头A B C
  394. string[] arr = BaseMethod.WarehousePermissionsStore( this.ValidDataPurviewIds, this.ob);
  395. CoreClientParam ccp = new CoreClientParam();
  396. ccp.ServerName = "com.steering.mes.zgmil.coup.FrmFeedLoad";
  397. ccp.MethodName = "node";
  398. ccp.ServerParams = new object[] { parm, parm2, arr, Feedplan };
  399. ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
  400. if (ccp.ReturnInfo == "上料确认成功!")
  401. {
  402. MessageUtil.ShowTips("上料确认成功!");
  403. doQuery();
  404. }
  405. else
  406. {
  407. MessageUtil.ShowTips(ccp.ReturnInfo);
  408. }
  409. }
  410. /// <summary>
  411. /// 查询
  412. /// </summary>
  413. private void doQuery()
  414. {
  415. string JudgeStoveNo = "";
  416. string FeedHeatNo = "";
  417. string LotNo = "";
  418. string IsLoad = "0";
  419. string startTime = "";
  420. string endTime = "";
  421. if (chkJudgeStoveNo.Checked)
  422. {
  423. if (uteJudgeStoveNo.Text.Trim() == "")
  424. {
  425. JudgeStoveNo = "";
  426. }
  427. else
  428. {
  429. JudgeStoveNo = uteJudgeStoveNo.Value.ToString();
  430. }
  431. }
  432. if (chkFEED_HEAT_NO.Checked)
  433. {
  434. if (ultraFEED_HEAT_NO.Text.Trim() == "")
  435. {
  436. FeedHeatNo = "";
  437. }
  438. else
  439. {
  440. FeedHeatNo = ultraFEED_HEAT_NO.Value.ToString();
  441. }
  442. }
  443. if (chkLotNo.Checked)
  444. {
  445. if (uteLotNo.Text.Trim() == "")
  446. {
  447. LotNo = "";
  448. }
  449. else
  450. {
  451. LotNo = uteLotNo.Value.ToString();
  452. }
  453. }
  454. if (ultraIsLoad.Checked)
  455. {
  456. IsLoad = "1";
  457. startTime = StartTime.Value.ToString();
  458. endTime = EndTime.Value.ToString();
  459. }
  460. ArrayList alist = new ArrayList();
  461. alist.Add(JudgeStoveNo);
  462. alist.Add(LotNo);
  463. alist.Add(IsLoad);
  464. alist.Add(FeedHeatNo);
  465. alist.Add(startTime);
  466. alist.Add(endTime);
  467. //string[] arr = BaseMethod.WarehousePermissionsStore(this.ValidDataPurviewIds, this.ob);
  468. WaitingForm2 wf = new WaitingForm2("正在加载,请稍候....");
  469. DataTable dt = ServerHelper.GetData("com.steering.mes.zgmil.coup.FrmFeedLoad.doQueryData", new Object[] { alist, pCode}, this.ob);
  470. GridHelper.CopyDataToDatatable(dt, this.dataTable1, true);
  471. GridHelper.RefreshAndAutoSize(this.ultraGrid1);
  472. wf.Close();
  473. ChangeGridColor();
  474. if (ultraGrid1.Rows.Count == 0)
  475. {
  476. dataTable2.Rows.Clear();
  477. dataTable3.Rows.Clear();
  478. dataTable4.Rows.Clear();
  479. return;
  480. }
  481. }
  482. #endregion
  483. #region 事件
  484. private void FrmFeedLoadResult_Load(object sender, EventArgs e)
  485. {
  486. NativeMethodNew na = new NativeMethodNew(this.ob);
  487. departm = UserInfo.GetDepartment();
  488. arr = BaseMethod.WarehousePermissionsStore(this.ValidDataPurviewIds, this.ob);
  489. pCode = BaseMethod.GetPlineCode(this.ValidDataPurviewIds, this.ob);//获取 用户 对应的产线
  490. PlineCode = pCode[0];
  491. //PlineCode = na.GetPCode(departm); //获取 用户 对应的产线
  492. planWeight.Value = UserInfo.GetUserOrderText();
  493. actualWeight.Value = UserInfo.GetUserGroupText();
  494. user = UserInfo.GetUserName();
  495. bc = UserInfo.GetUserOrderText();
  496. bz = UserInfo.GetUserGroupText();
  497. Shift = UserInfo.GetUserOrder();
  498. Group = UserInfo.GetUserGroup();
  499. EntityHelper.ShowGridCaption<MilPlanEntity5>(ultraGrid1.DisplayLayout.Bands[0]);
  500. EntityHelper.ShowGridCaption<MilPlanEntity5>(ultraGrid2.DisplayLayout.Bands[0]);
  501. //doQuery();
  502. }
  503. private void ultraGrid1_AfterRowActivate(object sender, EventArgs e)
  504. {
  505. string IsLoad = "0";
  506. if (ultraIsLoad.Checked)
  507. {
  508. IsLoad = "1";
  509. }
  510. UltraGridRow ugr = ultraGrid1.ActiveRow;
  511. string judgeStoveNo = ugr.Cells["JUDGE_STOVE_NO"].Value.ToString();
  512. string lotNo = ugr.Cells["ZY_BATCH_ID"].Value.ToString();
  513. string plineCode = ugr.Cells["PLINE_CODE"].Value.ToString();
  514. string heatPlanNo = ugr.Cells["HEAT_PLAN_NO"].Value.ToString();
  515. string jugdeApplyCode = ugr.Cells["JUGDE_APPLY_CODE"].Value.ToString();
  516. string feedHeatNo = ugr.Cells["FEED_HEAT_NO"].Value.ToString();
  517. string PRO_PLAN_ID = ugr.Cells["PRO_PLAN_ID"].Value.ToString();
  518. string GX_PLAN_NO = ugr.Cells["GX_PLAN_NO"].Value.ToString();
  519. //左边上料信息
  520. DataTable dt = ServerHelper.GetData("com.steering.mes.zgmil.coup.FrmFeedLoad.doQueryMatData", new Object[] { heatPlanNo, plineCode,IsLoad,PRO_PLAN_ID,GX_PLAN_NO, arr }, this.ob);
  521. GridHelper.CopyDataToDatatable(dt, this.dataTable2, true);
  522. GridHelper.RefreshAndAutoSize(this.ultraGrid2);
  523. //右边库存信息
  524. DataTable dt1 = ServerHelper.GetData("com.steering.mes.zgmil.coup.FrmFeedLoad.doQueryMatData2", new Object[] { judgeStoveNo, PRO_PLAN_ID, GX_PLAN_NO, IsLoad }, this.ob);
  525. GridHelper.CopyDataToDatatable(dt1, this.dataTable4, true);
  526. GridHelper.RefreshAndAutoSize(this.ultraGrid5);
  527. int a = 0;
  528. double b = 0.0;
  529. if (ultraGrid2.Rows.Count > 0)
  530. {
  531. foreach (UltraGridRow uRow in ultraGrid2.Rows)
  532. {
  533. uRow.Cells["CHK"].Value = true;
  534. a += int.Parse(uRow.Cells["ACT_COUNT"].Value.ToString3()) * int.Parse(uRow.Cells["CUT_NUM_GP"].Value.ToString3());
  535. b += int.Parse(uRow.Cells["ACT_COUNT"].Value.ToString3()) * double.Parse(uRow.Cells["PLAN_INDOUBLE_WT"].Value.ToString3()) / int.Parse(uRow.Cells["PLAN_INDOUBLE_NUM"].Value.ToString3());
  536. //uRow.Cells["PLAN_INDOUBLE_WT"].Value = int.Parse(uRow.Cells["PLAN_INDOUBLE_NUM"].Value.ToString3()) * double.Parse(uRow.Cells["WEIGHT_M"].Value.ToString3());
  537. }
  538. }
  539. planNum.Value = a;
  540. actualNum.Value = a;
  541. planWeight.Value = b;
  542. actualWeight.Value = b;
  543. //下面判定信息
  544. DataTable dt2 = ServerHelper.GetData("com.steering.mes.zgmil.coup.FrmFeedLoad.doQueryApplyData", new Object[] { judgeStoveNo, jugdeApplyCode, plineCode }, this.ob);
  545. GridHelper.CopyDataToDatatable(dt2, this.dataTable3, true);
  546. GridHelper.RefreshAndAutoSize(this.ultraGrid3);
  547. //ChangeGrid1Color();
  548. }
  549. private void ultraGrid2_CellChange(object sender, CellEventArgs e)
  550. {
  551. e.Cell.Row.Update();
  552. int a = 0;
  553. double b = 0.0;
  554. if (ultraGrid2.Rows.Count > 0)
  555. {
  556. foreach (UltraGridRow uRow in ultraGrid2.Rows)
  557. {
  558. a += int.Parse(uRow.Cells["ACT_COUNT"].Value.ToString3()) * int.Parse(uRow.Cells["CUT_NUM_GP"].Value.ToString3());
  559. b += int.Parse(uRow.Cells["ACT_COUNT"].Value.ToString3()) * double.Parse(uRow.Cells["PLAN_INDOUBLE_WT"].Value.ToString3()) / int.Parse(uRow.Cells["PLAN_INDOUBLE_NUM"].Value.ToString3());
  560. }
  561. }
  562. actualNum.Value = a;
  563. actualWeight.Value = b;
  564. }
  565. private void chkLotNo_CheckedChanged(object sender, EventArgs e)
  566. {
  567. if (chkLotNo.Checked) { uteLotNo.Enabled = true; } else { uteLotNo.Enabled = false; }
  568. if (chkJudgeStoveNo.Checked) { uteJudgeStoveNo.Enabled = true; } else { uteJudgeStoveNo.Enabled = false; }
  569. if (chkFEED_HEAT_NO.Checked) { ultraFEED_HEAT_NO.Enabled = true; } else { ultraFEED_HEAT_NO.Enabled = false; }
  570. if (ultraIsLoad.Checked)
  571. {
  572. StartTime.Visible = true;
  573. label1.Visible = true;
  574. EndTime.Visible = true;
  575. }
  576. else
  577. {
  578. StartTime.Visible = false;
  579. label1.Visible = false;
  580. EndTime.Visible = false;
  581. }
  582. }
  583. #endregion
  584. private void uteLotNo_KeyPress(object sender, KeyPressEventArgs e)
  585. {
  586. if (e.KeyChar == 13)
  587. {
  588. doQuery();
  589. }
  590. }
  591. }
  592. }