FrmScrapHtt.cs 27 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663
  1. using com.steering.mes.mcp.entity;
  2. using Core.Mes.Client.Comm.Control;
  3. using Core.Mes.Client.Comm.Server;
  4. using Core.Mes.Client.Comm.Tool;
  5. using Core.StlMes.Client.Mcp.Control;
  6. using CoreFS.CA06;
  7. using Infragistics.Win;
  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. using Core.Mes.Client.Comm.Format;
  19. using Core.StlMes.Client.Mcp.Control.Entity;
  20. namespace Core.StlMes.Client.Mcp.Control
  21. {
  22. public partial class FrmScrapHtt : FrmBase
  23. {
  24. private ArrayList list = null;
  25. private string plineCode = "";
  26. private string SLGx = "";
  27. private string heatPlanNo = "";
  28. private string resultNo = "";
  29. public string reslNo = "";
  30. public string Open = "";
  31. private string save = "0";
  32. private string Fenum = "";
  33. public FrmScrapHtt(string heatNo,string slgx,string pline_Code,string ResultNo,string open,string fenum,OpeBase ob)
  34. {
  35. InitializeComponent();
  36. //list = arr;
  37. this.ob = ob;
  38. plineCode = pline_Code;
  39. SLGx = slgx;
  40. heatPlanNo = heatNo;
  41. resultNo = ResultNo;
  42. Open = open;
  43. Fenum = fenum;
  44. }
  45. /// <summary>
  46. /// 查询所有合格管序号
  47. /// </summary>
  48. //private void QuerySeq(ArrayList list)
  49. //{
  50. // DataTable ds = ServerHelper.GetData("com.steering.mes.zgmil.coup.EddyCurrentTestingResult.doQuerySeq", new object[] { list }, ob);
  51. // GridHelper.CopyDataToDatatable(ref ds, ref dataTable4, true);
  52. //}
  53. public string alamNum = "";
  54. public string scrapNum = "";
  55. public string testOfflineNum = "";
  56. private void ultraToolbarsManager1_ToolClick(object sender, Infragistics.Win.UltraWinToolbars.ToolClickEventArgs e)
  57. {
  58. switch (e.Tool.Key)
  59. {
  60. case "Save":
  61. Save();
  62. break;
  63. case "Close":
  64. CloseFrm();
  65. break;
  66. }
  67. }
  68. public static int alarmTotalNum = 0;//可疑总支数
  69. public static int scarpTotalNum = 0;//废品总支数
  70. public static string dobiousName = "";//可疑原因
  71. public static string failName = "";//废品原因
  72. int offlineTotalNum = 0;//下线总支数
  73. public static ArrayList dName = null;//怀疑
  74. public static ArrayList fName = null;//废品
  75. private void CloseFrm()
  76. {
  77. alamNum = alarmTotalNum.ToString();
  78. scrapNum = scarpTotalNum.ToString();
  79. testOfflineNum = offlineTotalNum.ToString();
  80. this.DialogResult = System.Windows.Forms.DialogResult.OK;
  81. this.Close();
  82. }
  83. /// <summary>
  84. /// 保存可疑、剔除品
  85. /// </summary>
  86. private void Save()
  87. {
  88. this.ultraGridDetailDes1.UpdateData();
  89. this.ultraGridDetailDes2.UpdateData();
  90. // this.ultraGridDetailDes3.UpdateData();
  91. // string strInbound = "800707";//入库类型
  92. //string strInMemo = "";
  93. alarmTotalNum = 0;
  94. scarpTotalNum = 0;
  95. offlineTotalNum = 0;
  96. IQueryable<UltraGridRow> checkAlarmRows = this.ultraGridDetailDes1.Rows.AsQueryable().Where(" CHK = 'True'");
  97. IQueryable<UltraGridRow> checkScrapRows = this.ultraGridDetailDes2.Rows.AsQueryable().Where(" CHK = 'True'");
  98. // IQueryable<UltraGridRow> checkOffineRow = this.ultraGridDetailDes3.Rows.AsQueryable().Where(" CHK = 'True'");
  99. ArrayList alarmlist = new ArrayList();
  100. ArrayList scraplist = new ArrayList();
  101. //ArrayList offlinelist = new ArrayList();
  102. foreach (UltraGridRow uRow in checkAlarmRows)
  103. {
  104. ArrayList list1 = new ArrayList();
  105. if (uRow.Cells["DEF_FILL_NAME"].Text.ToString() == "")
  106. {
  107. MessageUtil.ShowTips("可疑支数原因不能为空,请选择!");
  108. return;
  109. }
  110. if (uRow.Cells["DEF_FILL_NUM"].Value.ToString() == "" || uRow.Cells["DEF_FILL_NUM"].Value.ToString() == "0")
  111. {
  112. MessageUtil.ShowTips("可疑支数不能为空或者为零支,请输入!");
  113. return;
  114. }
  115. if (!uRow.Cells["DEF_FILL_NUM"].Value.ToString().TryParseInt())
  116. {
  117. MessageUtil.ShowTips("可疑支数请输入整数!");
  118. return;
  119. } if (Convert.ToInt32(Fenum) < Convert.ToInt32(uRow.Cells["DEF_FILL_NUM"].Value.ToString()))
  120. {
  121. MessageUtil.ShowTips("可疑支数不能大于加工支数!");
  122. return;
  123. }
  124. alarmTotalNum = alarmTotalNum + int.Parse(uRow.Cells["DEF_FILL_NUM"].Value.ToString3());
  125. //list1.Add(uRow.Cells["FAIL_TYPE_NAME"].Text.Trim());
  126. //list1.Add(uRow.Cells["FAIL_NUM"].Value.ToString3());
  127. //list1.Add(alarmTotalNum.ToString());
  128. //alarmlist.Add(list1);
  129. HttWasteResultEntity resultD = getRowData(uRow);
  130. resultD.ResultNo = uRow.Cells["DEF_SERIAL_ITEM"].Value.ToString();
  131. alarmlist.Add(JSONFormat.Format(resultD));
  132. }
  133. dName = alarmlist;
  134. //int n = 0;
  135. //foreach (UltraGridRow ugr in checkScrapRows)
  136. //{
  137. // //string alarmReason = ugr.Cells["REASON1"].Text.Trim();
  138. // int num = 0;
  139. // foreach (UltraGridRow ugr1 in checkAlarmRows)
  140. // {
  141. // if (ugr1.Cells["FAIL_TYPE_NAME"].Text.Trim().Equals(alarmReason))
  142. // {
  143. // num = num + int.Parse(ugr1.Cells["FAIL_NUM"].Value.ToString3());
  144. // }
  145. // }
  146. // if (num < int.Parse(ugr.Cells["FAIL_NUM"].Value.ToString3()))
  147. // {
  148. // n = n + 1;
  149. // }
  150. //}
  151. //if (n > 0)
  152. //{
  153. // MessageUtil.ShowTips("废品支数不能超出对应的报警原因下的支数!");
  154. // return;
  155. //}
  156. foreach (UltraGridRow row in checkScrapRows)
  157. {
  158. ArrayList list2 = new ArrayList();
  159. //if (row.Cells["REASON1"].Value.ToString2() == "")
  160. //{
  161. // MessageUtil.ShowTips("报警原因不能为空,请选择!");
  162. // return;
  163. //}
  164. if (row.Cells["DEF_FILL_NAME"].Text.ToString() == "")
  165. {
  166. MessageUtil.ShowTips("废品原因不能为空,请选择!");
  167. return;
  168. }
  169. if (row.Cells["DEF_FILL_NUM"].Value.ToString() == "" || row.Cells["DEF_FILL_NUM"].Value.ToString() == "0")
  170. {
  171. MessageUtil.ShowTips("废品支数不能为空或者为零支,请输入!");
  172. return;
  173. }
  174. if (!row.Cells["DEF_FILL_NUM"].Value.ToString().TryParseInt())
  175. {
  176. MessageUtil.ShowTips("废品支数请输入整数!");
  177. return;
  178. }
  179. if (Convert.ToInt32(Fenum) < Convert.ToInt32(row.Cells["DEF_FILL_NUM"].Value.ToString()))
  180. {
  181. MessageUtil.ShowTips("废品支数不能大于加工支数!");
  182. return;
  183. }
  184. scarpTotalNum = scarpTotalNum + int.Parse(row.Cells["DEF_FILL_NUM"].Value.ToString3());
  185. //list2.Add(row.Cells["FAIL_TYPE_NAME"].Text.Trim());
  186. //list2.Add(row.Cells["FAIL_NUM"].Value.ToString3());
  187. //list2.Add(scarpTotalNum.ToString());
  188. ////list2.Add(row.Cells["REASON1"].Text.Trim());
  189. //scraplist.Add(list2);
  190. HttWasteResultEntity resultD = getRowData(row);
  191. resultD.ResultNo = row.Cells["DEF_SERIAL_ITEM"].Value.ToString();
  192. scraplist.Add((JSONFormat.Format(resultD)));
  193. }
  194. fName = scraplist;
  195. if(dName.Count!=0||fName.Count!=0)
  196. {
  197. MessageUtil.ShowTips("添加成功!");
  198. save = "1";
  199. alamNum = alarmTotalNum.ToString();
  200. scrapNum = scarpTotalNum.ToString();
  201. this.DialogResult = System.Windows.Forms.DialogResult.OK;
  202. }
  203. //CoreClientParam ccp = new CoreClientParam();
  204. //ccp.ServerName = "com.steering.mes.mcp.heatTreatment.FrmHttBugD";
  205. //ccp.MethodName = "addPerson";
  206. //ccp.ServerParams = new object[] { alarmlist, scraplist, SLGx, plineCode, heatPlanNo };
  207. //ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
  208. //if (ccp.ReturnCode != -1)
  209. //{
  210. // MessageUtil.ShowTips(ccp.ReturnInfo);
  211. // if (ccp.ReturnInfo.Equals("保存成功!"))
  212. // {
  213. // save = "1";
  214. // alamNum = alarmTotalNum.ToString();
  215. // scrapNum = scarpTotalNum.ToString();
  216. // //testOfflineNum = offlineTotalNum.ToString();
  217. // //UltraGridRow urg = ultraGridDetailDes2.ActiveRow;
  218. // //if(urg!=null)
  219. // //{
  220. // // reslNo = urg.Cells["RESULT_NO"].Value.ToString();
  221. // //}
  222. // this.DialogResult = System.Windows.Forms.DialogResult.OK;
  223. // }
  224. // else
  225. // {
  226. // MessageUtil.ShowTips(ccp.ReturnInfo);
  227. // }
  228. //}
  229. }
  230. public HttWasteResultEntity getRowData(UltraGridRow checkrow)
  231. {
  232. HttWasteResultEntity resultD = new HttWasteResultEntity();
  233. resultD.DefFillName = checkrow.Cells["DEF_FILL_NAME"].Text.ToString().Trim();
  234. resultD.DefFillNum = decimal.Parse(checkrow.Cells["DEF_FILL_NUM"].Value.ToString2().Trim());
  235. return resultD;
  236. }
  237. /// <summary>
  238. /// 查询仓库信息
  239. /// </summary>
  240. /// <param name="plineCode"></param>
  241. /// <returns></returns>
  242. private DataTable getStoreNo(string plineCode)
  243. {
  244. DataTable ds = ServerHelper.GetData("com.steering.mes.signature.FrmInOnlineStore.doQueryStoreNo", new object[] { plineCode }, ob);
  245. if (ds.Rows.Count > 0)
  246. {
  247. return ds;
  248. }
  249. else
  250. {
  251. return null;
  252. }
  253. }
  254. private void FrmScrap_Load(object sender, EventArgs e)
  255. {
  256. // Init(plineCode);
  257. doQuery();
  258. if (Open == "0")
  259. {
  260. ultraGroupBox2.Hide();
  261. }
  262. //QuerySeq(list);
  263. }
  264. public void Init(string plineCode)
  265. {
  266. ValueList va1 = new ValueList();
  267. ValueList va2 = new ValueList();
  268. ValueList va3 = new ValueList();
  269. ValueList va4 = new ValueList();
  270. if (plineCode != null)
  271. {
  272. if (plineCode.Equals("C009") || plineCode.Equals("C017") || plineCode.Equals("C008"))
  273. {
  274. va1.ValueListItems.Add("");
  275. va1.ValueListItems.Add("LOD");
  276. va1.ValueListItems.Add("LID");
  277. va1.ValueListItems.Add("TOD");
  278. va1.ValueListItems.Add("TID");
  279. va4.ValueListItems.Add("");
  280. va4.ValueListItems.Add("LOD");
  281. va4.ValueListItems.Add("LID");
  282. va4.ValueListItems.Add("TOD");
  283. va4.ValueListItems.Add("TID");
  284. va2.ValueListItems.Add("");
  285. va2.ValueListItems.Add("内折");
  286. va2.ValueListItems.Add("内结疤");
  287. va2.ValueListItems.Add("内划伤");
  288. va2.ValueListItems.Add("拉凹");
  289. va2.ValueListItems.Add("内棱");
  290. va2.ValueListItems.Add("取样废");
  291. va2.ValueListItems.Add("内壁伤");
  292. va2.ValueListItems.Add("内鼓包");
  293. va2.ValueListItems.Add("外折");
  294. va2.ValueListItems.Add("外结疤");
  295. va2.ValueListItems.Add("外划伤");
  296. va2.ValueListItems.Add("裂纹");
  297. va2.ValueListItems.Add("靑线");
  298. va2.ValueListItems.Add("轧折");
  299. va2.ValueListItems.Add("碰伤");
  300. va2.ValueListItems.Add("孔洞");
  301. va2.ValueListItems.Add("其他");
  302. va3.ValueListItems.Add("");
  303. va3.ValueListItems.Add("内折");
  304. va3.ValueListItems.Add("内结疤");
  305. va3.ValueListItems.Add("内划伤");
  306. va3.ValueListItems.Add("拉凹");
  307. va3.ValueListItems.Add("内棱");
  308. va3.ValueListItems.Add("取样废");
  309. va3.ValueListItems.Add("内壁伤");
  310. va3.ValueListItems.Add("内鼓包");
  311. va3.ValueListItems.Add("外折");
  312. va3.ValueListItems.Add("外结疤");
  313. va3.ValueListItems.Add("外划伤");
  314. va3.ValueListItems.Add("裂纹");
  315. va3.ValueListItems.Add("靑线");
  316. va3.ValueListItems.Add("轧折");
  317. va3.ValueListItems.Add("碰伤");
  318. va3.ValueListItems.Add("孔洞");
  319. va3.ValueListItems.Add("其他");
  320. }
  321. else if (plineCode.Equals("C010"))
  322. {
  323. va1.ValueListItems.Add("");
  324. va1.ValueListItems.Add("孔洞");
  325. va1.ValueListItems.Add("外折");
  326. va1.ValueListItems.Add("划伤");
  327. va1.ValueListItems.Add("内伤");
  328. va1.ValueListItems.Add("误报");
  329. va2.ValueListItems.Add("");
  330. va2.ValueListItems.Add("孔洞");
  331. va2.ValueListItems.Add("外折");
  332. va2.ValueListItems.Add("内伤");
  333. va3.ValueListItems.Add("");
  334. va3.ValueListItems.Add("孔洞");
  335. va3.ValueListItems.Add("外折");
  336. va3.ValueListItems.Add("内伤");
  337. va4.ValueListItems.Add("");
  338. va4.ValueListItems.Add("孔洞");
  339. va4.ValueListItems.Add("外折");
  340. va4.ValueListItems.Add("划伤");
  341. va4.ValueListItems.Add("内伤");
  342. va4.ValueListItems.Add("误报");
  343. //this.ultraGridDetailDes2.DisplayLayout.Bands[0].Columns["REASON1"].Hidden = true;
  344. }
  345. }
  346. this.ultraGridDetailDes1.DisplayLayout.Bands[0].Columns["REASON"].ValueList = va1;
  347. this.ultraGridDetailDes2.DisplayLayout.Bands[0].Columns["REASON"].ValueList = va2;
  348. // this.ultraGridDetailDes3.DisplayLayout.Bands[0].Columns["REASON"].ValueList = va3;
  349. this.ultraGridDetailDes2.DisplayLayout.Bands[0].Columns["REASON1"].ValueList = va4;
  350. }
  351. /// <summary>
  352. /// 查询可疑品、剔除品
  353. /// </summary>
  354. public void doQuery()
  355. {
  356. dataTable1.Clear();
  357. dataTable2.Clear();
  358. dataTable3.Clear();
  359. //查询可疑支数
  360. //DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.Mch.FrmMchBugD.doQueryAlarmNum", new object[] { heatPlanNo,resultNo }, ob);
  361. //GridHelper.CopyDataToDatatable(ref dt,ref dataTable1,true);
  362. //查询废品支数
  363. //DataTable ds = ServerHelper.GetData("com.steering.mes.mcp.Mch.FrmMchBugD.doQueryScrapNum", new object[] { heatPlanNo, resultNo }, ob);
  364. //GridHelper.CopyDataToDatatable(ref ds, ref dataTable2, true);
  365. //DataTable dd = ServerHelper.GetData("com.steering.mes.zgmil.coup.EddyCurrentTestingResult.doQueryOffineNum", new object[] { list }, ob);
  366. //GridHelper.CopyDataToDatatable(ref dd, ref dataTable3, true);
  367. //下拉选探伤废品原因
  368. DataTable dt2 = ServerHelper.GetData("com.steering.mes.mcp.Mch.FrmCrackDetectResult.getQuerybase", new object[] { "7004" }, this.ob);
  369. //comm.FilComboboxAdd(standard, dt2, "BASECODE", "BASENAME", "validflag NOT in ('0')", false, "全部", "");
  370. kreason.DataSource = dt2;
  371. kreason.DisplayMember = "BASENAME";
  372. kreason.ValueMember = "BASECODE";
  373. YdmBaseClass.SetComboItemHeight(kreason);
  374. reason.DataSource = dt2;
  375. reason.DisplayMember = "BASENAME";
  376. reason.ValueMember = "BASECODE";
  377. YdmBaseClass.SetComboItemHeight(reason);
  378. foreach (UltraGridRow urg in ultraGridDetailDes1.Rows)
  379. {
  380. GridEdite(urg);
  381. }
  382. foreach (UltraGridRow urg in ultraGridDetailDes2.Rows)
  383. {
  384. GridEdite(urg);
  385. }
  386. }
  387. private void ultraGridDetailDes1_CellChange(object sender, Infragistics.Win.UltraWinGrid.CellEventArgs e)
  388. {
  389. this.ultraGridDetailDes1.UpdateData();
  390. GridEdite(e.Cell.Row);
  391. //UltraGrid ug = (UltraGrid)sender;
  392. //this.ultraGridDetailDes1.UpdateData();
  393. //if (e.Cell.Column.Key == "REASON")
  394. //{
  395. // if (e.Cell.Value == "")
  396. // {
  397. // MessageBox.Show("您未选择任何选项,请重新选择", "提示:", MessageBoxButtons.OK, MessageBoxIcon.Warning);
  398. // return;
  399. // }
  400. // int temp = 0;
  401. // //for (int i = 0; i < ug.Rows.Count(); i++)
  402. // //{
  403. // // UltraGridRow ugr = ug.Rows[i];
  404. // // if (e.Cell.Value.ToString().Equals(ugr.Cells["REASON"].Value.ToString()))
  405. // // {
  406. // // temp = temp + 1;
  407. // // }
  408. // //}
  409. // //if (temp > 1)
  410. // //{
  411. // // MessageBox.Show(e.Cell.Value.ToString() + "选项已被选取,请重新选择", "提示:", MessageBoxButtons.OK, MessageBoxIcon.Warning);
  412. // // e.Cell.Row.Cells["REASON"].Value = "";
  413. // //}
  414. //}
  415. //if(e.Cell.Column.Key == "ACT_COUNT")
  416. //{
  417. // int total = 0;
  418. // foreach(UltraGridRow row in this.ultraGridDetailDes1.Rows)
  419. // {
  420. // if (Convert.ToBoolean(row.Cells["CHK"].Text) == true)
  421. // {
  422. // total = total + int.Parse(row.Cells["ACT_COUNT"].Value.ToString3());
  423. // }
  424. // }
  425. // ultraGrid1.BeginUpdate();
  426. // foreach (UltraGridRow uRow in this.ultraGrid1.Rows)
  427. // {
  428. // if (total >= uRow.Index + 1)
  429. // {
  430. // uRow.Cells["CHK1"].Value = true;
  431. // }
  432. // else
  433. // {
  434. // uRow.Cells["CHK1"].Value = false;
  435. // }
  436. // }
  437. // ultraGrid1.EndUpdate();
  438. //}
  439. }
  440. private void ultraGridDetailDes2_CellChange(object sender, CellEventArgs e)
  441. {
  442. this.ultraGridDetailDes2.UpdateData();
  443. GridEdite(e.Cell.Row);
  444. //UltraGrid ug = (UltraGrid)sender;
  445. //this.ultraGridDetailDes2.UpdateData();
  446. //if (e.Cell.Column.Key == "REASON")
  447. //{
  448. // if (e.Cell.Value == "")
  449. // {
  450. // MessageBox.Show("您未选择任何选项,请重新选择", "提示:", MessageBoxButtons.OK, MessageBoxIcon.Warning);
  451. // return;
  452. // }
  453. // int temp = 0;
  454. // for (int i = 0; i < ug.Rows.Count(); i++)
  455. // {
  456. // UltraGridRow ugr = ug.Rows[i];
  457. // if (e.Cell.Value.ToString().Equals(ugr.Cells["REASON"].Value.ToString()) && e.Cell.Row.Cells["REASON1"].Value.ToString2().Equals(ugr.Cells["REASON1"].Value.ToString2()))
  458. // {
  459. // temp = temp + 1;
  460. // }
  461. // }
  462. // if (temp > 1)
  463. // {
  464. // MessageBox.Show(e.Cell.Value.ToString() + "选项已被选取,请重新选择", "提示:", MessageBoxButtons.OK, MessageBoxIcon.Warning);
  465. // e.Cell.Row.Cells["REASON"].Value = "";
  466. // }
  467. //}
  468. //if (e.Cell.Column.Key == "REASON1")
  469. //{
  470. // if (e.Cell.Value == "")
  471. // {
  472. // MessageBox.Show("您未选择任何选项,请重新选择", "提示:", MessageBoxButtons.OK, MessageBoxIcon.Warning);
  473. // return;
  474. // }
  475. // int temp1 = 0;
  476. // for (int i = 0; i < ug.Rows.Count(); i++)
  477. // {
  478. // UltraGridRow ugr = ug.Rows[i];
  479. // if (e.Cell.Value.ToString().Equals(ugr.Cells["REASON1"].Value.ToString()) && e.Cell.Row.Cells["REASON"].Value.ToString2().Equals(ugr.Cells["REASON"].Value.ToString2()))
  480. // {
  481. // temp1 = temp1 + 1;
  482. // }
  483. // }
  484. // if (temp1 > 1)
  485. // {
  486. // MessageBox.Show(e.Cell.Value.ToString() + "选项已被选取,请重新选择", "提示:", MessageBoxButtons.OK, MessageBoxIcon.Warning);
  487. // e.Cell.Row.Cells["REASON"].Value = "";
  488. // }
  489. //}
  490. //if (e.Cell.Column.Key == "ACT_COUNT")
  491. //{
  492. // int total = 0;
  493. // foreach (UltraGridRow row in this.ultraGridDetailDes2.Rows)
  494. // {
  495. // if (Convert.ToBoolean(row.Cells["CHK"].Text) == true)
  496. // {
  497. // total = total + int.Parse(row.Cells["ACT_COUNT"].Value.ToString3());
  498. // }
  499. // }
  500. // ultraGrid1.BeginUpdate();
  501. // IQueryable<UltraGridRow> checkAlarmRows = this.ultraGrid1.Rows.AsQueryable().Where(" CHK1 = 'True' and CHK3 = 'False' ORDER BY TO_NUMBER(SEQ) ASC");
  502. // if (checkAlarmRows.Count() < total)
  503. // {
  504. // MessageUtil.ShowTips("废品总支数不能大于报警总支数");
  505. // return;
  506. // }
  507. // else
  508. // {
  509. // int i = 1;
  510. // foreach (UltraGridRow uRow in checkAlarmRows)
  511. // {
  512. // uRow.Cells["CHK2"].Value = false;
  513. // if (i <= total)
  514. // {
  515. // uRow.Cells["CHK2"].Value = true;
  516. // }
  517. // i++;
  518. // }
  519. // }
  520. // ultraGrid1.EndUpdate();
  521. //}
  522. }
  523. private void FrmScrap_FormClosing(object sender, FormClosingEventArgs e)
  524. {
  525. UltraGridRow urg = ultraGridDetailDes2.ActiveRow;
  526. if (urg != null)
  527. {
  528. if (Convert.ToBoolean(urg.Cells["CHK"].Text) == true && urg.Cells["DEF_FILL_NAME"].Text != "")
  529. {
  530. if (save == "0")
  531. {
  532. MessageUtil.ShowTips("请点保存按钮!");
  533. e.Cancel = true;
  534. }
  535. }
  536. }
  537. }
  538. /// <summary>
  539. ///
  540. /// ulltragrid控件受勾影响(打钩可编辑,不打勾不能编辑)**
  541. /// </summary>
  542. /// <param name="row"></param>
  543. private void GridEdite(UltraGridRow row)
  544. {
  545. if (row.GetValue("CHK") == "True")
  546. {
  547. foreach (UltraGridCell cell in row.Cells)
  548. {
  549. if (cell.Column.CellActivation == Activation.AllowEdit)
  550. {
  551. cell.Activation = Activation.AllowEdit;
  552. }
  553. }
  554. }
  555. else
  556. {
  557. foreach (UltraGridCell cell in row.Cells)
  558. {
  559. if (cell.Column.Key.Contains("CHK")) continue;
  560. if (cell.Column.CellActivation == Activation.AllowEdit)
  561. {
  562. cell.Activation = Activation.ActivateOnly;
  563. }
  564. }
  565. }
  566. ultraGridDetailDes1.UpdateData();
  567. ultraGridDetailDes2.UpdateData();
  568. }
  569. private void ultraGridDetailDes1_AfterRowInsert(object sender, RowEventArgs e)
  570. {
  571. this.ultraGridDetailDes1.UpdateData();
  572. GridEdite(e.Row);
  573. }
  574. private void ultraGridDetailDes2_AfterRowInsert(object sender, RowEventArgs e)
  575. {
  576. this.ultraGridDetailDes2.UpdateData();
  577. GridEdite(e.Row);
  578. }
  579. //private void ultraGridDetailDes3_CellChange(object sender, CellEventArgs e)
  580. //{
  581. // UltraGrid ug = (UltraGrid)sender;
  582. // this.ultraGridDetailDes3.UpdateData();
  583. // if (e.Cell.Column.Key == "REASON")
  584. // {
  585. // if (e.Cell.Value == "")
  586. // {
  587. // MessageBox.Show("您未选择任何选项,请重新选择", "提示:", MessageBoxButtons.OK, MessageBoxIcon.Warning);
  588. // return;
  589. // }
  590. // int temp = 0;
  591. // for (int i = 0; i < ug.Rows.Count(); i++)
  592. // {
  593. // UltraGridRow ugr = ug.Rows[i];
  594. // if (e.Cell.Value.ToString().Equals(ugr.Cells["REASON"].Value.ToString()))
  595. // {
  596. // temp = temp + 1;
  597. // }
  598. // }
  599. // if (temp > 1)
  600. // {
  601. // MessageBox.Show(e.Cell.Value.ToString() + "选项已被选取,请重新选择", "提示:", MessageBoxButtons.OK, MessageBoxIcon.Warning);
  602. // e.Cell.Row.Cells["REASON"].Value = "";
  603. // }
  604. // }
  605. //}
  606. //private void FrmScrap_Leave(object sender, EventArgs e)
  607. //{
  608. // FrmTestingResult frmTestingResult = new FrmTestingResult();
  609. // frmTestingResult.ETResultSave();
  610. //}
  611. }
  612. }