FrmJgMPlnZy.cs 27 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733
  1. using Core.Mes.Client.Comm.Format;
  2. using Core.Mes.Client.Comm.Server;
  3. using Core.Mes.Client.Comm.Tool;
  4. using Core.StlMes.Client.PlnSaleOrd.JGGXPln.Entity;
  5. using Core.StlMes.Client.PlnSaleOrd.JGGXPln.model;
  6. using CoreFS.CA06;
  7. using Infragistics.Win.UltraWinEditors;
  8. using Infragistics.Win.UltraWinGrid;
  9. using System;
  10. using System.Collections;
  11. using System.Collections.Generic;
  12. using System.ComponentModel;
  13. using System.Data;
  14. using System.Drawing;
  15. using System.Linq;
  16. using System.Text;
  17. using System.Windows.Forms;
  18. namespace Core.StlMes.Client.PlnSaleOrd.JGGXPln
  19. {
  20. /// <summary>
  21. /// 接箍订单炉次作业工单计划
  22. /// </summary>
  23. public partial class FrmJgMPlnZy : FrmBase
  24. {
  25. private UltraComboEditor comboJgMPline = null;
  26. private UltraComboEditor comboCodeJgBl = null;
  27. private UltraComboEditor comboPline = null;
  28. private int _splitterDistance1 = 0;
  29. private bool _groupBox1ExpandedChanged = false;
  30. public FrmJgMPlnZy()
  31. {
  32. this.IsLoadUserView = true;
  33. InitializeComponent();
  34. EntityHelper.ShowGridCaption<FrmPlnGxJgMEntity>(ultraGridJgGxM.DisplayLayout.Bands[0]);
  35. EntityHelper.ShowGridCaption<PlnGxJgPropEntity>(ultraGridJgGxProP.DisplayLayout.Bands[0]);
  36. EntityHelper.ShowGridCaption<FrmPlnZyJgEntity>(ultraGridPlnJgZy.DisplayLayout.Bands[0]);
  37. System.Threading.Thread t = new System.Threading.Thread(setGridColunmName);
  38. t.Start();
  39. }
  40. private void setGridColunmName()
  41. {
  42. System.Threading.Thread.Sleep(3000);
  43. if (!this.IsDisposed)
  44. {
  45. EntityHelper.ShowGridCaption<FrmPlnGxJgMEntity>(ultraGridJgGxM.DisplayLayout.Bands[0]);
  46. EntityHelper.ShowGridCaption<PlnGxJgPropEntity>(ultraGridJgGxProP.DisplayLayout.Bands[0]);
  47. EntityHelper.ShowGridCaption<FrmPlnZyJgEntity>(ultraGridPlnJgZy.DisplayLayout.Bands[0]);
  48. }
  49. }
  50. public override void ToolBar_Click(object sender, string ToolbarKey)
  51. {
  52. base.ToolBar_Click(sender, ToolbarKey);
  53. switch (ToolbarKey)
  54. {
  55. case "Query":
  56. DoQuery();
  57. break;
  58. case "ModifyJgM":
  59. DoModifyJgM();
  60. break;
  61. case "BoundJg":
  62. DoBoundJg();
  63. break;
  64. case "AddZyJg":
  65. DoAddZyJg();
  66. break;
  67. case "CanCelZy":
  68. DoCanCelZy();
  69. break;
  70. case "ModifyZyJg":
  71. DoModifyZyJg();
  72. break;
  73. case "RefresDate":
  74. RefresDate();
  75. break;
  76. case "Close":
  77. this.Close();
  78. break;
  79. default:
  80. break;
  81. }
  82. }
  83. private void FrmJgMPlnZy_Load(object sender, EventArgs e)
  84. {
  85. Init();
  86. RefresDate();
  87. }
  88. private void Init()
  89. {
  90. PlanComm.setGridActivation(ultraGridJgGxM.DisplayLayout.Bands[0], "CHC", "PlineCode", "CodeJgBl");
  91. PlanComm.setGridDigitalCol(ultraGridJgGxM.DisplayLayout.Bands[0], 5, 2,
  92. "Outdiameter", "Wallthick", "Aimlength", "Singleweight", "Diameter", "DiameterJg",
  93. "CheckJVal", "MinD", "MinH", "BlMinDOut", "BlMaxDIn", "AimlengthBl", "HeightJg",
  94. "DiameterPl", "HeightPl", "LengthMin", "LengthMax", "LengthJg", "WeightJg",
  95. "MinDCp", "MaxDCp", "LengthMin", "LengthMax", "MinHCp", "MaxHCp", "MinDJg", "MaxDJg");
  96. PlanComm.setGridDigitalCol(ultraGridJgGxM.DisplayLayout.Bands[0], 5, 3, "BlWeight");
  97. PlanComm.setGridDigitalCol(ultraGridJgGxM.DisplayLayout.Bands[0], 5, 0,
  98. "ProducedNum", "ZyplanNum", "BlNum", "PlanNum", "JgwtBlreq", "Buyplannum", "Matchnum");
  99. PlanComm.setGridActivation(ultraGridJgGxProP.DisplayLayout.Bands[0]);
  100. PlanComm.setGridDigitalCol(ultraGridJgGxProP.DisplayLayout.Bands[0], 5, 3, "GroupBlWt");
  101. PlanComm.setGridDigitalCol(ultraGridJgGxProP.DisplayLayout.Bands[0], 5, 0,
  102. "GroupNum", "SingleCutNun", "GroupBlNum", "ProducedNum");
  103. PlanComm.setGridDigitalCol(ultraGridJgGxProP.DisplayLayout.Bands[0], 5, 2,
  104. "MinD", "MinH", "AimlengthBl", "AimCutLen", "LengthMin", "LengthMax");
  105. PlanComm.setGridActivation(ultraGridPlnJgZy.DisplayLayout.Bands[0], "CHC", "IfOutCut",
  106. "IfOutCjg", "IfOutImpress", "IfOutLathe", "IfOutDetect", "IfOutBlast", "IfOutPltCu",
  107. "IfOutPhos");
  108. comboJgMPline = new UltraComboEditor();
  109. comboCodeJgBl = new UltraComboEditor();
  110. comboPline = new UltraComboEditor();
  111. this.Controls.Add(comboJgMPline);
  112. this.Controls.Add(comboCodeJgBl);
  113. this.Controls.Add(comboPline);
  114. comboJgMPline.Visible = false;
  115. comboCodeJgBl.Visible = false;
  116. comboPline.Visible = false;
  117. ultraGridJgGxM.DisplayLayout.Bands[0].Columns["PlineCode"].Style =
  118. Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;
  119. ultraGridJgGxM.DisplayLayout.Bands[0].Columns["CodeJgBl"].Style =
  120. Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;
  121. }
  122. /// <summary>
  123. /// 刷新
  124. /// </summary>
  125. private void RefresDate()
  126. {
  127. DataTable dtPine = ServerHelper.GetData("com.steering.pss.plnsaleord.jggxpln.CoreJgMPlnZy.getJgPine",
  128. new object[] { }, this.ob);
  129. comboPline.DataSource = dtPine;
  130. comboPline.ValueMember = "PLINE_CODE";
  131. comboPline.DisplayMember = "PLINE_NAME";
  132. ultraGridJgGxM.DisplayLayout.Bands[0].Columns["PlineCode"].EditorComponent = comboPline;
  133. DataTable dtDd = ServerHelper.GetData("com.steering.pss.plnsaleord.jggxpln.CoreJgMPlnZy.queryJgGxMNo",
  134. new object[] { }, this.ob);
  135. if (dtDd != null && dtDd.Rows.Count > 0)
  136. {
  137. DataRow dr = dtDd.NewRow();
  138. dtDd.Rows.InsertAt(dr, 0);
  139. }
  140. ultraComboJgDdNo.DataSource = dtDd;
  141. ultraComboJgDdNo.DisplayMember = "PRO_PLAN_ID";
  142. ultraComboJgDdNo.ValueMember = "PRO_PLAN_ID";
  143. ultraComboJgDdNo.SelectedIndex = 0;
  144. if (dtPine != null && dtPine.Rows.Count > 0)
  145. {
  146. DataRow dr = dtPine.NewRow();
  147. dtPine.Rows.InsertAt(dr, 0);
  148. }
  149. ultraComboJgPine.DataSource = dtPine;
  150. ultraComboJgPine.ValueMember = "PLINE_CODE";
  151. ultraComboJgPine.DisplayMember = "PLINE_NAME";
  152. ultraComboJgPine.SelectedIndex = 0;
  153. }
  154. /// <summary>
  155. /// 查询
  156. /// </summary>
  157. private void DoQuery()
  158. {
  159. ArrayList paramJgM = new ArrayList();
  160. if (checkBoxJgDdNo.Checked)
  161. {
  162. paramJgM.Add(ultraComboJgDdNo.Text.Trim());
  163. }
  164. else
  165. {
  166. paramJgM.Add("");
  167. }
  168. if (this.checkBoxJgPline.Checked)
  169. {
  170. paramJgM.Add(this.ultraComboJgPine.Value.ToString());
  171. }
  172. else
  173. {
  174. paramJgM.Add("");
  175. }
  176. if (this.checkBoxSpec.Checked)
  177. {
  178. paramJgM.Add(this.ultraTextEditorSpec.Text.Trim());
  179. }
  180. else
  181. {
  182. paramJgM.Add("");
  183. }
  184. if (this.checkBoxProduce.Checked)
  185. {
  186. paramJgM.Add(ultraTextEditorProduce.Text.Trim());
  187. }
  188. else
  189. {
  190. paramJgM.Add("");
  191. }
  192. if (this.checkBoxSteel.Checked)
  193. {
  194. paramJgM.Add(this.ultraTextEditorSteel.Text.Trim());
  195. }
  196. else
  197. {
  198. paramJgM.Add("");
  199. }
  200. if (this.checkBoxModel.Checked)
  201. {
  202. paramJgM.Add(this.ultraTextEditorModel.Text.Trim());
  203. }
  204. else
  205. {
  206. paramJgM.Add("");
  207. }
  208. bindingSourcePlnGxJgPropEntity.Clear();
  209. bindingSourcePlnZyJgEntity.Clear();
  210. List<FrmPlnGxJgMEntity> listSource1 = EntityHelper.GetData<FrmPlnGxJgMEntity>(
  211. "com.steering.pss.plnsaleord.jggxpln.CoreJgMPlnZy.queryGxJgM", new object[] { paramJgM }, this.ob);
  212. bindingSourcePlnGxJgMEntity.DataSource = listSource1;
  213. }
  214. /// <summary>
  215. /// 修改接箍订单
  216. /// </summary>
  217. private void DoModifyJgM()
  218. {
  219. ultraGridJgGxM.UpdateData();
  220. CoreClientParam ccp = null;
  221. ArrayList list = new ArrayList();
  222. IQueryable<UltraGridRow> ugrs = ultraGridJgGxM.Rows.AsQueryable().Where("CHC = 'True'");
  223. if (ugrs.Count() == 0)
  224. {
  225. MessageUtil.ShowTips("未勾选任何接箍订单。");
  226. return;
  227. }
  228. foreach (UltraGridRow ugr in ugrs)
  229. {
  230. PlnGxJgMEntity jgMEntity = new PlnGxJgMEntity();
  231. jgMEntity.ProPlanId = ugr.Cells["ProPlanId"].Value.ToString();
  232. jgMEntity.PlineCode = ugr.Cells["PlineCode"].Value.ToString();
  233. jgMEntity.PlineName = ugr.Cells["PlineCode"].Text.Trim();
  234. jgMEntity.CodeJgBl = ugr.Cells["CodeJgBl"].Value.ToString();
  235. jgMEntity.CodeJg = ugr.Cells["CodeJg"].Value.ToString();
  236. list.Add(JSONFormat.Format(jgMEntity));
  237. }
  238. ccp = new CoreClientParam();
  239. ccp.ServerName = "com.steering.pss.plnsaleord.jggxpln.CoreJgMPlnZy";
  240. ccp.MethodName = "doModifyJgM";
  241. ccp.ServerParams = new object[] { list };
  242. ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
  243. if (ccp.ReturnCode != -1)
  244. {
  245. if (ccp.ReturnObject != null)
  246. {
  247. MessageUtil.ShowTips(ccp.ReturnObject.ToString());
  248. }
  249. }
  250. DoQuery();
  251. }
  252. /// <summary>
  253. /// 接箍利库
  254. /// </summary>
  255. private void DoBoundJg()
  256. {
  257. string proPlanId = "";
  258. string jgGroupId = "";
  259. UltraGridRow ugr = ultraGridJgGxProP.ActiveRow;
  260. if (ugr == null)
  261. {
  262. return;
  263. }
  264. FrmJgUseStock jgUseStock = null;
  265. DataTable dt = null;
  266. proPlanId = ugr.Cells["ProPlanId"].Value.ToString();
  267. jgGroupId = ugr.Cells["JgGroupId"].Value.ToString();
  268. dt = ServerHelper.GetData("com.steering.pss.plnsaleord.jggxpln.CoreJgMPlnZy.getPlnGxJgMStatus",
  269. new object[] { proPlanId, jgGroupId }, this.ob);
  270. if (dt == null || dt.Rows.Count < 0)
  271. {
  272. MessageUtil.ShowTips("未找到订单" + proPlanId + "。");
  273. return;
  274. }
  275. if (!dt.Rows[0]["PLANSTATUS"].ToString().Trim().Equals("0"))
  276. {
  277. MessageUtil.ShowTips("订单:" + proPlanId + "已经下发了。");
  278. return;
  279. }
  280. if (!dt.Rows[0]["GROUP_STATUS"].ToString().Trim().Equals("0"))
  281. {
  282. MessageUtil.ShowTips("订单:" + proPlanId + " 分组:"
  283. + jgGroupId + "不在计划状态。");
  284. return;
  285. }
  286. jgUseStock = new FrmJgUseStock(proPlanId, jgGroupId, this.ob);
  287. jgUseStock.ShowDialog();
  288. if (jgUseStock.IsChecked)
  289. {
  290. DoQuery();
  291. return;
  292. }
  293. }
  294. /// <summary>
  295. /// 接箍炉次计划
  296. /// </summary>
  297. private void DoAddZyJg()
  298. {
  299. string proPlanId = "";
  300. string jgGroupId = "";
  301. FrmMatZcM matZcM = null;
  302. int jgNum = 0;//接箍个数
  303. int matchNum = 0;//利库个数
  304. double lenJg = 0;//接箍长度
  305. double lenBlsum = 0;//接箍料总长度
  306. UltraGridRow ugr = ultraGridJgGxProP.ActiveRow;
  307. if (ugr == null)
  308. {
  309. return;
  310. }
  311. proPlanId = ugr.Cells["ProPlanId"].Value.ToString();
  312. jgGroupId = ugr.Cells["JgGroupId"].Value.ToString();
  313. DataTable dt = ServerHelper.GetData("com.steering.pss.plnsaleord.jggxpln.CoreJgMPlnZy.getPlnGxJgMStatus",
  314. new object[] { proPlanId, jgGroupId }, this.ob);
  315. if (dt == null || dt.Rows.Count < 0)
  316. {
  317. MessageUtil.ShowTips("未找到订单" + proPlanId + "。");
  318. return;
  319. }
  320. if (dt.Rows[0]["PLINE_CODE"].ToString().Trim().Equals(""))
  321. {
  322. MessageUtil.ShowTips("订单:" + proPlanId + "没有指定产线。");
  323. return;
  324. }
  325. if (dt.Rows[0]["CODE_JG_BL"].ToString().Trim().Equals(""))
  326. {
  327. MessageUtil.ShowTips("订单:" + proPlanId + "没有找到对应接箍备料码。(接箍码"
  328. + dt.Rows[0]["CODE_JG"].ToString() + ")");
  329. return;
  330. }
  331. if (dt.Rows[0]["GROUP_NUM"] == null ||
  332. !int.TryParse(dt.Rows[0]["GROUP_NUM"].ToString(), out jgNum))
  333. {
  334. MessageUtil.ShowTips("订单:" + proPlanId + " 分组" + ugr.Cells["JgGroupId"].Value.ToString()
  335. + "接箍个数未知。");
  336. return;
  337. }
  338. if (dt.Rows[0]["LENGTH_JG"] == null ||
  339. !double.TryParse(dt.Rows[0]["LENGTH_JG"].ToString(), out lenJg))
  340. {
  341. MessageUtil.ShowTips("接箍" + dt.Rows[0]["CODE_JG"].ToString() + "的长度未知。");
  342. return;
  343. }
  344. if (lenJg <= 0)
  345. {
  346. MessageUtil.ShowTips("接箍" + dt.Rows[0]["CODE_JG"].ToString() + "的长度必须大于零。");
  347. return;
  348. }
  349. int.TryParse(dt.Rows[0]["MATCHNUM_JG"].ToString(), out matchNum);
  350. if (jgNum - matchNum > 0)
  351. {
  352. lenBlsum = (lenJg + 10) / 1000 * (jgNum - matchNum);
  353. }
  354. else
  355. {
  356. lenBlsum = 0;
  357. }
  358. matZcM = new FrmMatZcM(proPlanId, jgGroupId, this.ob);
  359. matZcM.UltraNumericLenBl.Value = lenBlsum;
  360. matZcM.ShowDialog();
  361. if (matZcM.IsChecked)
  362. {
  363. DoQuery();
  364. return;
  365. }
  366. }
  367. /// <summary>
  368. /// 修改炉次计划
  369. /// </summary>
  370. private void DoModifyZyJg()
  371. {
  372. UltraGridRow ugr = ultraGridPlnJgZy.ActiveRow;
  373. if (ugr == null)
  374. {
  375. MessageUtil.ShowTips("没有指定修改的炉次计划。");
  376. return;
  377. }
  378. int jgNum = 0;//接箍个数
  379. double lenJg = 0;//接箍长度
  380. int matchNum = 0;//利库个数
  381. double lenBlsum = 0;//接箍料总长度
  382. string zyPlanId = ugr.Cells["ZyPlanId"].Value.ToString();
  383. string proPlanId = ugr.Cells["ProPlanId"].Value.ToString();
  384. string jgGroupId = ugr.Cells["JgGroupId"].Value.ToString();
  385. DataTable dt = ServerHelper.GetData("com.steering.pss.plnsaleord.jggxpln.CoreJgMPlnZy.getPlnGxJgMStatus",
  386. new object[] { proPlanId, jgGroupId }, this.ob);
  387. if (dt == null || dt.Rows.Count < 0)
  388. {
  389. MessageUtil.ShowTips("未找到订单" + proPlanId + "。");
  390. return;
  391. }
  392. if (dt.Rows[0]["PLINE_CODE"].ToString().Trim().Equals(""))
  393. {
  394. MessageUtil.ShowTips("订单:" + proPlanId + "没有指定产线。");
  395. return;
  396. }
  397. if (dt.Rows[0]["CODE_JG_BL"].ToString().Trim().Equals(""))
  398. {
  399. MessageUtil.ShowTips("订单:" + proPlanId + "没有找到对应接箍备料码。(接箍码"
  400. + dt.Rows[0]["CODE_JG"].ToString() + ")");
  401. return;
  402. }
  403. if (dt.Rows[0]["GROUP_NUM"] == null ||
  404. !int.TryParse(dt.Rows[0]["GROUP_NUM"].ToString(), out jgNum))
  405. {
  406. MessageUtil.ShowTips("订单:" + proPlanId + " 分组" + ugr.Cells["JgGroupId"].Value.ToString()
  407. + "接箍个数未知。");
  408. return;
  409. }
  410. if (dt.Rows[0]["LENGTH_JG"] == null ||
  411. !double.TryParse(dt.Rows[0]["LENGTH_JG"].ToString(), out lenJg))
  412. {
  413. MessageUtil.ShowTips("接箍" + dt.Rows[0]["CODE_JG"].ToString() + "的长度未知。");
  414. return;
  415. }
  416. if (lenJg <= 0)
  417. {
  418. MessageUtil.ShowTips("接箍" + dt.Rows[0]["CODE_JG"].ToString() + "的长度必须大于零。");
  419. return;
  420. }
  421. int.TryParse(dt.Rows[0]["MATCHNUM_JG"].ToString(), out matchNum);
  422. if (jgNum - matchNum > 0)
  423. {
  424. lenBlsum = (lenJg + 10) / 1000 * (jgNum - matchNum);
  425. }
  426. else
  427. {
  428. lenBlsum = 0;
  429. }
  430. FrmMatZcM matZcM = new FrmMatZcM(zyPlanId, this.ob);
  431. matZcM.UltraNumericLenBl.Value = lenBlsum;
  432. matZcM.ShowDialog();
  433. if (matZcM.IsChecked)
  434. {
  435. DoQuery();
  436. return;
  437. }
  438. }
  439. /// <summary>
  440. /// 取消炉次作业
  441. /// </summary>
  442. private void DoCanCelZy()
  443. {
  444. ultraGridPlnJgZy.UpdateData();
  445. ArrayList list = new ArrayList();
  446. IQueryable<UltraGridRow> ugrs = ultraGridPlnJgZy.Rows.AsQueryable().Where(" CHC = 'True' ");
  447. if (ugrs.Count() == 0)
  448. {
  449. MessageUtil.ShowTips("未勾选任何作业工单。");
  450. return;
  451. }
  452. foreach (UltraGridRow ugr in ugrs)
  453. {
  454. list.Add(ugr.Cells["ZyPlanId"].Value.ToString());
  455. }
  456. CoreClientParam ccp = new CoreClientParam();
  457. ccp.ServerName = "com.steering.pss.plnsaleord.jggxpln.CoreJgMPlnZy";
  458. ccp.MethodName = "canCelJgZy";
  459. ccp.ServerParams = new object[] { list };
  460. ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
  461. if (ccp.ReturnCode != -1)
  462. {
  463. if (ccp.ReturnObject != null)
  464. {
  465. MessageUtil.ShowTips(ccp.ReturnObject.ToString());
  466. }
  467. }
  468. DoQuery();
  469. }
  470. /// <summary>
  471. /// 查询炉次作业
  472. /// </summary>
  473. /// <param name="proPlanId"></param>
  474. /// <param name="jgGroupId"></param>
  475. private void DoQueryZyJg(string proPlanId, string jgGroupId)
  476. {
  477. List<FrmPlnZyJgEntity> listSource2 = EntityHelper.GetData<FrmPlnZyJgEntity>(
  478. "com.steering.pss.plnsaleord.jggxpln.CoreJgMPlnZy.queryPlnZyJg",
  479. new object[] { proPlanId, jgGroupId }, this.ob);
  480. bindingSourcePlnZyJgEntity.DataSource = listSource2;
  481. }
  482. /// <summary>
  483. /// 接箍订单
  484. /// </summary>
  485. private void DoBindJgMBLPine()
  486. {
  487. UltraGridRow ugr = ultraGridJgGxM.ActiveRow;
  488. if (ugr == null)
  489. {
  490. return;
  491. }
  492. string codeJg = ugr.Cells["CodeJg"].Value.ToString();
  493. string codeBl = ugr.Cells["CodeJgBl"].Value.ToString();
  494. DataTable dtBl = ServerHelper.GetData("com.steering.pss.plnsaleord.jggxpln.CoreJgMPlnZy.getPlnJgMBlCode",
  495. new object[] { codeJg, ugr.Cells["CustAlphaNo"].Value.ToString(),
  496. ugr.Cells["AlphaCode"].Value.ToString() }, this.ob);
  497. DataTable dtPine = ServerHelper.GetData("com.steering.pss.plnsaleord.jggxpln.CoreJgMPlnZy.getPlnJgMPine",
  498. new object[] { codeJg, codeBl }, this.ob);
  499. comboCodeJgBl.DataSource = dtBl;
  500. comboCodeJgBl.ValueMember = "PSC_BL";
  501. comboCodeJgBl.DisplayMember = "PSC_BL";
  502. ugr.Cells["CodeJgBl"].EditorComponent = comboCodeJgBl;
  503. comboJgMPline.DataSource = dtPine;
  504. comboJgMPline.ValueMember = "PLINE_CODE";
  505. comboJgMPline.DisplayMember = "PLINE_NAME";
  506. ugr.Cells["PlineCode"].EditorComponent = comboJgMPline;
  507. IQueryable<UltraGridRow> urows = ultraGridJgGxM.Rows.AsQueryable().Where(
  508. "ProPlanId != '" + ugr.Cells["ProPlanId"].Value.ToString() + "'");
  509. foreach (UltraGridRow urow in urows)
  510. {
  511. urow.Cells["PlineCode"].EditorComponent = comboPline;
  512. }
  513. }
  514. private void ultraGridJgGxM_CellChange(object sender, CellEventArgs e)
  515. {
  516. UltraGridRow ugr = e.Cell.Row;
  517. if (ugr == null)
  518. {
  519. return;
  520. }
  521. ugr.Update();
  522. if (e.Cell.Column.Key.Equals("PlineCode"))
  523. {
  524. ugr.Cells["PlineName"].Value = ugr.Cells["PlineCode"].Text.Trim();
  525. }
  526. if (e.Cell.Column.Key.Equals("CodeJgBl"))
  527. {
  528. string codeJg = ugr.Cells["CodeJg"].Value.ToString();
  529. string codeBl = ugr.Cells["CodeJgBl"].Value.ToString();
  530. DataTable dtPine = ServerHelper.GetData("com.steering.pss.plnsaleord.jggxpln.CoreJgMPlnZy.getPlnJgMPine",
  531. new object[] { codeJg, codeBl }, this.ob);
  532. comboJgMPline.DataSource = dtPine;
  533. comboJgMPline.ValueMember = "PLINE_CODE";
  534. comboJgMPline.DisplayMember = "PLINE_NAME";
  535. ugr.Cells["PlineCode"].EditorComponent = comboJgMPline;
  536. IQueryable<UltraGridRow> urows = ultraGridJgGxM.Rows.AsQueryable().Where(
  537. "ProPlanId != '" + ugr.Cells["ProPlanId"].Value.ToString() + "'");
  538. foreach (UltraGridRow urow in urows)
  539. {
  540. urow.Cells["PlineCode"].EditorComponent = comboPline;
  541. }
  542. }
  543. }
  544. private void ultraGridJgGxM_AfterRowActivate(object sender, EventArgs e)
  545. {
  546. UltraGridRow ugr = ultraGridJgGxM.ActiveRow;
  547. if (ugr == null)
  548. {
  549. return;
  550. }
  551. bindingSourcePlnGxJgPropEntity.DataSource = EntityHelper.GetData<PlnGxJgPropEntity>(
  552. "com.steering.pss.plnsaleord.jggxpln.CorePlnJgOrdToDd.queryJgGxProp",
  553. new object[] { ugr.Cells["ProPlanId"].Value.ToString() }, this.ob);
  554. DoBindJgMBLPine();
  555. }
  556. #region 事件
  557. private void checkBoxJgDdNo_CheckedChanged(object sender, EventArgs e)
  558. {
  559. if (checkBoxJgDdNo.Checked)
  560. {
  561. ultraComboJgDdNo.Enabled = true;
  562. }
  563. else
  564. {
  565. ultraComboJgDdNo.Enabled = false;
  566. }
  567. }
  568. private void checkBoxJgPline_CheckedChanged(object sender, EventArgs e)
  569. {
  570. if (checkBoxJgPline.Checked)
  571. {
  572. ultraComboJgPine.Enabled = true;
  573. }
  574. else
  575. {
  576. ultraComboJgPine.Enabled = false;
  577. }
  578. }
  579. private void checkBoxSpec_CheckedChanged(object sender, EventArgs e)
  580. {
  581. if (checkBoxSpec.Checked)
  582. {
  583. this.ultraTextEditorSpec.Enabled = true;
  584. }
  585. else
  586. {
  587. ultraTextEditorSpec.Enabled = false;
  588. }
  589. }
  590. private void checkBoxSteel_CheckedChanged(object sender, EventArgs e)
  591. {
  592. if (checkBoxSteel.Checked)
  593. {
  594. this.ultraTextEditorSteel.Enabled = true;
  595. }
  596. else
  597. {
  598. ultraTextEditorSteel.Enabled = false;
  599. }
  600. }
  601. private void checkBoxProduce_CheckedChanged(object sender, EventArgs e)
  602. {
  603. if (checkBoxProduce.Checked)
  604. {
  605. this.ultraTextEditorProduce.Enabled = true;
  606. }
  607. else
  608. {
  609. ultraTextEditorProduce.Enabled = false;
  610. }
  611. }
  612. private void checkBoxModel_CheckedChanged(object sender, EventArgs e)
  613. {
  614. if (checkBoxModel.Checked)
  615. {
  616. this.ultraTextEditorModel.Enabled = true;
  617. }
  618. else
  619. {
  620. ultraTextEditorModel.Enabled = false;
  621. }
  622. }
  623. private void ultraExpandableJgGxProP_ExpandedStateChanged(object sender, EventArgs e)
  624. {
  625. _groupBox1ExpandedChanged = true;
  626. if (ultraExpandableJgGxProP.Expanded == false)
  627. {
  628. splitContainer2.SplitterDistance = this.Width;
  629. }
  630. else
  631. {
  632. splitContainer2.SplitterDistance = _splitterDistance1;
  633. }
  634. _groupBox1ExpandedChanged = false;
  635. }
  636. private void splitContainer2_SplitterMoved(object sender, SplitterEventArgs e)
  637. {
  638. if (_groupBox1ExpandedChanged == false)
  639. {
  640. _splitterDistance1 = splitContainer2.SplitterDistance;
  641. if (splitContainer2.SplitterDistance < splitContainer2.Parent.Width - 35)
  642. {
  643. ultraExpandableJgGxProP.Expanded = true;
  644. }
  645. else
  646. {
  647. ultraExpandableJgGxProP.Expanded = false;
  648. }
  649. }
  650. }
  651. private void ultraGridJgGxM_AfterSelectChange(object sender, AfterSelectChangeEventArgs e)
  652. {
  653. foreach (UltraGridRow uRow in ultraGridJgGxM.Selected.Rows)
  654. {
  655. if (uRow.GetType() != typeof(Infragistics.Win.UltraWinGrid.UltraGridGroupByRow))
  656. {
  657. uRow.Cells["CHC"].Value = true;
  658. }
  659. }
  660. }
  661. private void ultraGridPlnJgZy_AfterSelectChange(object sender, AfterSelectChangeEventArgs e)
  662. {
  663. foreach (UltraGridRow uRow in ultraGridPlnJgZy.Selected.Rows)
  664. {
  665. if (uRow.GetType() != typeof(Infragistics.Win.UltraWinGrid.UltraGridGroupByRow))
  666. {
  667. uRow.Cells["CHC"].Value = true;
  668. }
  669. }
  670. }
  671. private void ultraGridJgGxProP_AfterRowActivate(object sender, EventArgs e)
  672. {
  673. UltraGridRow ugr = ultraGridJgGxProP.ActiveRow;
  674. if (ugr == null)
  675. {
  676. return;
  677. }
  678. DoQueryZyJg(ugr.Cells["ProPlanId"].Value.ToString(), ugr.Cells["JgGroupId"].Value.ToString());
  679. }
  680. #endregion
  681. }
  682. }