SteelMakingColligateJudgeFrm.cs 58 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209
  1. using Core.Mes.Client.Comm.Server;
  2. using Core.Mes.Client.Comm.Tool;
  3. using Core.StlMes.Client.Judge.Commons;
  4. using Core.StlMes.Client.Judge.Controls;
  5. using CoreFS.CA06;
  6. using System;
  7. using System.Collections.Generic;
  8. using System.Data;
  9. using System.Drawing;
  10. using System.Linq;
  11. using System.Windows.Forms;
  12. namespace Core.StlMes.Client.Judge.Forms
  13. {
  14. public partial class SteelMakingColligateJudgeFrm : FrmBase
  15. {
  16. private MeltingStoveNoCtrl _meltingStoveNoCtrl;
  17. private QcmGpJudgeApplyCtrl _gpJudgeApplyCtrl;
  18. private QcmJhyElementsCtrl _jhyElementsCtrl;
  19. private QcmJhyPhyDbResultCtrl _jhyPhyDbResultCtrl;
  20. private QcmLgJudgeCtrl _lgJudgeCtrl;
  21. private FaceFileCtrl _faceFileCtrl;
  22. private DetectFileCtrl _detectFileCtrl;
  23. private QcmGpPassApplyCtrl _gpPassApply;
  24. private QcmGpJudgeApplyDtlCtrl _gpJudgeApplyDtlCtrl2;
  25. private QcmGpJudgeApplyDtlCtrl _gpJudgeApplyDtlCtrl;
  26. private Dal _d;
  27. private string cusInfoEnd;
  28. private string cusInfoStart;
  29. public string CusInfoEnd
  30. {
  31. get { return cusInfoEnd; }
  32. set { cusInfoEnd = value; }
  33. }
  34. public SteelMakingColligateJudgeFrm()
  35. {
  36. InitializeComponent();
  37. IsLoadUserView = true;
  38. }
  39. private void labelDateTimePicker1_CheckBox_CheckedChanged(object sender, EventArgs e)
  40. {
  41. labelDateTimePicker2.DateTimePicker.Enabled = labelDateTimePicker1.Checked;
  42. }
  43. protected override void OnLoad(EventArgs e)
  44. {
  45. base.OnLoad(e);
  46. if (_meltingStoveNoCtrl == null) return;
  47. _meltingStoveNoCtrl.UltraGrid1.DisplayLayout.Override.CellClickAction = Infragistics.Win.UltraWinGrid.CellClickAction.RowSelect;
  48. _meltingStoveNoCtrl.UltraGrid1.DisplayLayout.Override.SelectedRowAppearance.BackColor = Color.FromArgb(164, 211, 238);
  49. _meltingStoveNoCtrl.UltraGrid1.DisplayLayout.Override.ActiveRowAppearance.ForeColor = Color.Black;
  50. if (_jhyElementsCtrl == null) return;
  51. _jhyElementsCtrl.UltraGrid1.DisplayLayout.Override.SupportDataErrorInfo = Infragistics.Win.UltraWinGrid.SupportDataErrorInfo.RowsAndCells;
  52. _jhyPhyDbResultCtrl.UltraGrid1.DisplayLayout.Override.SupportDataErrorInfo = Infragistics.Win.UltraWinGrid.SupportDataErrorInfo.RowsAndCells;
  53. }
  54. private void SteelMakingColligateJudgeFrm_Load(object sender, EventArgs e)
  55. {
  56. _meltingStoveNoCtrl = new MeltingStoveNoCtrl(ultraExpandableGroupBoxPanel1, ob);
  57. _meltingStoveNoCtrl.UltraGrid1.AfterRowActivate += steelMakingCtrl_AfterRowActivate;
  58. _meltingStoveNoCtrl.UltraGrid1.DisplayLayout.Override.AllowUpdate = Infragistics.Win.DefaultableBoolean.False;
  59. _meltingStoveNoCtrl.UltraGrid1.DisplayLayout.Override.AllowDelete = Infragistics.Win.DefaultableBoolean.False;
  60. _gpJudgeApplyCtrl = new QcmGpJudgeApplyCtrl(splitContainer1.Panel1, ob, JudgeType.SteelMakingColligate);
  61. _gpJudgeApplyCtrl.UltraGrid1.DisplayLayout.Override.AllowDelete = Infragistics.Win.DefaultableBoolean.False;
  62. _gpJudgeApplyCtrl.UltraGrid1.AfterRowActivate += gpJudgeApplyCtrl_AfterRowActivate;
  63. _gpJudgeApplyDtlCtrl = new QcmGpJudgeApplyDtlCtrl(splitContainer1.Panel2, ob);
  64. _jhyElementsCtrl = new QcmJhyElementsCtrl(ultraTabPageControl1, ob, false);
  65. _jhyElementsCtrl.UltraGrid1.DisplayLayout.Override.AllowDelete = Infragistics.Win.DefaultableBoolean.False;
  66. _jhyPhyDbResultCtrl = new QcmJhyPhyDbResultCtrl(ultraTabPageControl2, ob);
  67. _jhyPhyDbResultCtrl.UltraGrid1.DisplayLayout.Override.AllowDelete = Infragistics.Win.DefaultableBoolean.False;
  68. _lgJudgeCtrl = new QcmLgJudgeCtrl(ultraTabPageControl6, ob);
  69. _lgJudgeCtrl.EntityGrid1.StyleGrid.DisplayLayout.Override.AllowDelete = Infragistics.Win.DefaultableBoolean.False;
  70. _lgJudgeCtrl.EntityGrid1.StyleGrid.DisplayLayout.Override.AllowUpdate = Infragistics.Win.DefaultableBoolean.False;
  71. _faceFileCtrl = new FaceFileCtrl(ultraTabPageControl4, ob, false);
  72. _detectFileCtrl = new DetectFileCtrl(ultraTabPageControl3, ob, false);
  73. _gpPassApply = new QcmGpPassApplyCtrl(splitContainer2.Panel1, ob, new string[] { });
  74. _gpPassApply.UltraGrid1.AfterRowActivate += gpPassApply_AfterRowActivate;
  75. _gpJudgeApplyDtlCtrl2 = new QcmGpJudgeApplyDtlCtrl(splitContainer2.Panel2, ob);
  76. _d = new Dal(ob);
  77. dataTable1.Clear();
  78. dataTable1.Rows.Add("00", "编制中");
  79. dataTable1.Rows.Add("10", "已下发");
  80. dataTable1.Rows.Add("20", "生产中");
  81. dataTable1.Rows.Add("30", "已生产");
  82. dataTable1.Rows.Add("40", "关闭");
  83. JudgeBaseInfo.LoadPlineName(ultraComboEditor2, ob, true, "A");
  84. JudgeBaseInfo.LoadPlineName(labelComboBox1.ComboBox, ob, false, "A");
  85. JudgeBaseInfo.LoadPlineName(labelComboBox5.ComboBox, ob, false, "B", "C");
  86. JudgeBaseInfo.LoadPlineName(labelComboBox4.ComboBox, ob, false, "B", "C");
  87. ClsBaseInfo.FillComBaseInfo(labelComboBox2.ComboBox, "407407", ob, false);
  88. //判定结果只显示内控合格和不合格。 40740101内控合格 40740102内控不合格
  89. DataTable dt = (DataTable)labelComboBox2.ComboBox.DataSource;
  90. DataRow dr = dt.NewRow();
  91. dr["BASECODE"] = "1";
  92. dr["BASENAME"] = "已判";
  93. dt.Rows.InsertAt(dr, 0);
  94. dr = dt.NewRow();
  95. dr["BASECODE"] = "0";
  96. dr["BASENAME"] = "未判";
  97. dt.Rows.InsertAt(dr, 0);
  98. dt.AcceptChanges();
  99. dt.DefaultView.RowFilter = "BASECODE NOT IN ('40740703', '40740706')";
  100. ClsBaseInfo.SetComboItemHeight(labelComboBox2.ComboBox);
  101. ClsBaseInfo.FillComBaseInfo(labelComboBox3.ComboBox, "407407", ob, false);
  102. ClsBaseInfo.SetComboItemHeight(labelComboBox3.ComboBox);
  103. labelDateTimePicker1.Checked = true;
  104. labelDateTimePicker1.DateTimePicker.Value = DateTime.Now.Date.AddDays(-3);
  105. labelDateTimePicker2.DateTimePicker.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1);
  106. labelDateTimePicker4.Checked = true;
  107. labelDateTimePicker4.DateTimePicker.Value = DateTime.Now.Date.AddDays(-3);
  108. labelDateTimePicker3.DateTimePicker.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1);
  109. labelDateTimePicker6.Checked = true;
  110. labelDateTimePicker6.DateTimePicker.Value = DateTime.Now.Date.AddDays(-3);
  111. labelDateTimePicker5.DateTimePicker.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1);
  112. checkBox3.Checked = true;
  113. dateTimePicker1.Value = DateTime.Now.Date.AddDays(-3);
  114. dateTimePicker2.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1);
  115. cusInfoStart = CustomInfo.Split('_')[0];
  116. if (CustomInfo.Split('_').Length > 1)
  117. cusInfoEnd = CustomInfo.Split('_')[1];
  118. if (cusInfoStart == "Quality" || cusInfoStart == "Urgent")
  119. {
  120. ultraExpandableGroupBox1.Visible = false;
  121. ultraTabControl2.Tabs[1].Visible = false;
  122. //_gpJudgeApplyCtrl.UltraGrid1.DisplayLayout.Bands[0].Columns["passType2"].Hidden = true;
  123. if (cusInfoStart == "Quality")
  124. {
  125. labelComboBox2.SelecteValue = "40740704";
  126. labelComboBox2.Checked = true;
  127. }
  128. if (cusInfoStart == "Urgent")
  129. {
  130. labelComboBox2.SelecteValue = "0";
  131. labelComboBox2.Checked = true;
  132. }
  133. }
  134. else
  135. {
  136. //_gpJudgeApplyCtrl.UltraGrid1.DisplayLayout.Bands[0].Columns["passType2"].Hidden = true;
  137. //_gpJudgeApplyCtrl.UltraGrid1.DisplayLayout.Bands[0].Columns["auditState"].Hidden = true;
  138. //_gpJudgeApplyCtrl.UltraGrid1.DisplayLayout.Bands[0].Columns["passType"].Hidden = true;
  139. }
  140. if (cusInfoEnd == "120504")
  141. {
  142. labelTextBox1.Visible = true;
  143. }
  144. labelTextBox8.Text = UserInfo.GetUserName();
  145. if ("Quality_120501_WG".Equals(CustomInfo))
  146. {
  147. labelComboBox5.Visible = false;
  148. ultraLabel4.Visible = false;
  149. ultraOptionSet3.Visible = false;
  150. ultraOptionSet3.Value = 2;
  151. }
  152. }
  153. void gpPassApply_AfterRowActivate(object sender, EventArgs e)
  154. {
  155. try
  156. {
  157. this.Cursor = Cursors.WaitCursor;
  158. var row = _gpPassApply.UltraGrid1.ActiveRow;
  159. _gpJudgeApplyDtlCtrl2.Query(row.GetValue("jugdeApplyCode"), row.GetValue("jugdeApplySqe"), row.GetValue("judgeStoveNo"));
  160. }
  161. finally
  162. {
  163. this.Cursor = Cursors.Default;
  164. }
  165. }
  166. public override void ToolBar_Click(object sender, string ToolbarKey)
  167. {
  168. base.ToolBar_Click(sender, ToolbarKey);
  169. switch (ToolbarKey)
  170. {
  171. case "Query":
  172. Query();
  173. break;
  174. case "Judge":
  175. Judge();
  176. break;
  177. case "refresh":
  178. refresh();
  179. break;
  180. case "PassApply":
  181. PassApply();
  182. break;
  183. case "UrgentPassApply":
  184. UrgentPassApply();
  185. break;
  186. case "DeletePassApply":
  187. DeletePassApply();
  188. break;
  189. case "DeleteJudge":
  190. DeleteJudge();
  191. break;
  192. case "ReviewGpCertificate":
  193. ReviewGpCertificate();
  194. break;
  195. case "UpdateMemo":
  196. UpdateMemo();
  197. break;
  198. case "refreshDB":
  199. refreshDB();
  200. break;
  201. }
  202. }
  203. private void refreshDB()
  204. {
  205. var row =_gpJudgeApplyCtrl.UltraGrid1.ActiveRow;
  206. var ccp = _d.Set("com.steering.pss.judge.Bll.BllSteelMakingColligateJudge.refreshDB", row.GetValue("jugdeApplyCode"),
  207. row.GetValue("jugdeApplySqe"), row.GetValue("judgeStoveNo"), UserInfo.GetUserName(), row.GetValue("judgeMemo"));
  208. if (ccp.ReturnInfo != "")
  209. {
  210. MessageUtil.ShowError(ccp.ReturnInfo);
  211. return;
  212. }
  213. else
  214. {
  215. MessageUtil.ShowTips("操作成功!");
  216. Query();
  217. }
  218. }
  219. private void UpdateMemo()
  220. {
  221. if (_gpJudgeApplyCtrl.UltraGrid1.ActiveRow == null)
  222. {
  223. MessageUtil.ShowWarning("没有需要修改的记录!");
  224. return;
  225. }
  226. var chkRows = _gpJudgeApplyCtrl.UltraGrid1.Rows.Where(a => a.GetValue("Chk") == "True");
  227. if (chkRows.Count() == 0)
  228. {
  229. if (_gpJudgeApplyCtrl.UltraGrid1.ActiveRow == null)
  230. {
  231. MessageUtil.ShowWarning("请选择申请判定记录!", _gpJudgeApplyCtrl.UltraGrid1);
  232. }
  233. else
  234. {
  235. MessageUtil.ShowWarning("请选择申请判定记录!", _gpJudgeApplyCtrl.UltraGrid1, _gpJudgeApplyCtrl.UltraGrid1.ActiveRow.Cells["Chk"]);
  236. }
  237. return;
  238. }
  239. string judgeApplyCode = "";
  240. string judgeApplySeq = "";
  241. string judgeStoveNo = "";
  242. string stoveNo = "";
  243. List<string[]> parms = new List<string[]>();
  244. foreach (var row in chkRows)
  245. {
  246. judgeApplyCode = row.GetValue("jugdeApplyCode");
  247. judgeApplySeq = row.GetValue("jugdeApplySqe");
  248. judgeStoveNo = row.GetValue("judgeStoveNo");
  249. stoveNo = row.GetValue("stoveNo");
  250. DataRow drJudgeCnt = _d.GetRowByXmlId("QcmLgJudgeDAL.queryCntByJudgeStoveNo", judgeStoveNo, "B");
  251. if (drJudgeCnt[0].ToString() == "0")
  252. {
  253. MessageUtil.ShowWarning("该记录还没有判定不能修改备注信息!");
  254. return;
  255. }
  256. parms.Add(new string[] { judgeApplyCode, judgeApplySeq, judgeStoveNo, row.GetValue("judgeMemo"), row.GetValue("judgeMemo2") });
  257. }
  258. if (MessageUtil.ShowYesNoAndQuestion("是否确认修改备注?") == System.Windows.Forms.DialogResult.No)
  259. {
  260. return;
  261. }
  262. var ccp = _d.Set("com.steering.pss.judge.Bll.BllSteelMakingColligateJudge.UpdateMemo", parms);
  263. if (ccp.ReturnInfo != "")
  264. {
  265. MessageUtil.ShowError(ccp.ReturnInfo);
  266. return;
  267. }
  268. else
  269. {
  270. MessageUtil.ShowTips("操作成功!");
  271. }
  272. Relocate(judgeApplyCode, judgeApplySeq, judgeStoveNo, stoveNo);
  273. }
  274. private void DeleteJudge()
  275. {
  276. var chkRows = _gpJudgeApplyCtrl.UltraGrid1.Rows.Where(a => a.GetValue("Chk") == "True");
  277. if (_gpJudgeApplyCtrl.UltraGrid1.ActiveRow == null)
  278. {
  279. MessageUtil.ShowWarning("没有需要撤销的记录!");
  280. return;
  281. }
  282. if (chkRows.Count() == 0)
  283. {
  284. MessageUtil.ShowWarning("请选择申请判定记录!", _gpJudgeApplyCtrl.UltraGrid1, _gpJudgeApplyCtrl.UltraGrid1.ActiveRow.Cells["Chk"]);
  285. return;
  286. }
  287. string judgeApplyCode = "";
  288. string judgeApplySqe = "";
  289. string judgeStoveNo = "";
  290. string stoveNo = "";
  291. bool deleteJudgeTiped = false;
  292. foreach (var row in chkRows)
  293. {
  294. judgeApplyCode = row.GetValue("jugdeApplyCode");
  295. judgeApplySqe = row.GetValue("jugdeApplySqe");
  296. judgeStoveNo = row.GetValue("judgeStoveNo");
  297. stoveNo = row.GetValue("stoveNo");
  298. DataRow drGpApply = _d.GetRowByXmlId("QcmGpJugdeApplyDAL.queryGpApplyByJudgeStoveNo", row.GetValue("jugdeApplyCode"),
  299. row.GetValue("jugdeApplySqe"), row.GetValue("JudgeStoveNo"));
  300. DataRow drPassApply = _d.GetRowByXmlId("QcmGpPassApplyDAL.queryByGpJudgeApplyPk", row.GetValue("jugdeApplyCode"),
  301. row.GetValue("jugdeApplySqe"), row.GetValue("judgeStoveNo"));
  302. if (drGpApply != null && drGpApply["judgeResultCode"].ToString() == "40740704"
  303. && drPassApply != null && drPassApply["TYPE"].ToString() == "0")
  304. {
  305. if (drPassApply["auditResult2"].ToString() == "407502" || drPassApply["auditResult2"].ToString() == "407503")
  306. {
  307. deleteJudgeTiped = true;
  308. if (MessageUtil.ShowYesNoAndQuestion("炉号" + judgeStoveNo + " 放行处置结果为让步接收,是否确认撤销判定?") == System.Windows.Forms.DialogResult.No)
  309. {
  310. return;
  311. }
  312. }
  313. }
  314. }
  315. if (deleteJudgeTiped == false)
  316. {
  317. if (MessageUtil.ShowYesNoAndQuestion("是否确认进行撤销判定?") == System.Windows.Forms.DialogResult.No)
  318. {
  319. return;
  320. }
  321. }
  322. List<string> judgeStoveNos = new List<string>();
  323. foreach (var row in chkRows)
  324. {
  325. if (judgeStoveNos.Contains(row.GetValue("judgeStoveNo"))) continue;
  326. judgeStoveNos.Add(row.GetValue("judgeStoveNo"));
  327. var ccp = _d.Set("com.steering.pss.judge.Bll.BllSteelMakingColligateJudge.deleteJudge", row.GetValue("jugdeApplyCode"),
  328. row.GetValue("jugdeApplySqe"), row.GetValue("judgeStoveNo"), UserInfo.GetUserName());
  329. if (ccp.ReturnInfo != "")
  330. {
  331. MessageUtil.ShowWarning(ccp.ReturnInfo);
  332. return;
  333. }
  334. }
  335. MessageUtil.ShowTips("操作成功!");
  336. Relocate(judgeApplyCode, judgeApplySqe, judgeStoveNo, stoveNo);
  337. }
  338. private void DeletePassApply()
  339. {
  340. var chkRows = _gpPassApply.UltraGrid1.Rows.Where(a => a.GetValue("Chk") == "True");
  341. if (chkRows.Count() == 0)
  342. {
  343. MessageUtil.ShowWarning("请选择一行记录");
  344. return;
  345. }
  346. List<string> passApplyNos = new List<string>();
  347. string passApplyNo = "";
  348. string passApplySeq = "";
  349. foreach (var row in chkRows)
  350. {
  351. DataRow drPassApply = _d.GetRowByXmlId("QcmGpPassApplyDAL.queryByPassApplyNo", row.GetValue("passApplyNo"));
  352. if (drPassApply == null)
  353. {
  354. MessageUtil.ShowWarning("此炉号不需要删除放行申请单!");
  355. return;
  356. }
  357. if (drPassApply["type"].ToString() == "0")
  358. {
  359. DataRow drGpJudgeApply = _d.GetRowByXmlId("QcmGpJugdeApplyDAL.queryGpApplyByJudgeStoveNo", row.GetValue("jugdeApplyCode"),
  360. row.GetValue("jugdeApplySqe"), row.GetValue("judgeStoveNo"));
  361. if (drGpJudgeApply["judgeResultCode"].ToString() != "40740704")
  362. {
  363. MessageUtil.ShowWarning("只能删除判定不合格状态的放行申请单!", _gpJudgeApplyCtrl.UltraGrid1, row);
  364. return;
  365. }
  366. }
  367. else
  368. {
  369. if (drPassApply["auditResult"].ToString() == "1")
  370. {
  371. MessageUtil.ShowWarning("此炉号已经通过紧急放行,不能删除申请放行单!");
  372. return;
  373. }
  374. }
  375. //DataRow drPassApply = _d.GetRowByXmlId("QcmGpPassApplyDAL.queryByPassApplyNo", row.GetValue("passApplyNo"));
  376. //if (drPassApply["auditResult"].ToString() == "1" && drPassApply["auditResult2"].ToString() == "")
  377. //{
  378. // MessageUtil.ShowWarning("不能删除正在审核的申请放行单!");
  379. // return;
  380. //}
  381. //else if (drPassApply["auditResult"].ToString() == "1" && drPassApply["auditResult2"].ToString() == "1")
  382. //{
  383. // MessageUtil.ShowWarning("不能删除审核通过的申请放行单!");
  384. // return;
  385. //}
  386. passApplyNos.Add(row.GetValue("PassApplyNo"));
  387. passApplyNo = row.GetValue("PassApplyNo");
  388. passApplySeq = row.GetValue("passApplySeq");
  389. }
  390. if (MessageUtil.ShowYesNoAndQuestion("是否确认删除申请放行?") == System.Windows.Forms.DialogResult.No)
  391. {
  392. return;
  393. }
  394. var ccp = _d.Set("com.steering.pss.judge.Bll.BllSteelMakingPassApply.delete", passApplyNos, UserInfo.GetUserName());
  395. if (ccp.ReturnInfo != "")
  396. {
  397. MessageUtil.ShowError(ccp.ReturnInfo);
  398. return;
  399. }
  400. else
  401. {
  402. MessageUtil.ShowTips("操作成功!");
  403. }
  404. Query();
  405. var rowRelocate = _gpPassApply.UltraGrid1.Rows.Where(a => a.GetValue("PassApplyNo") == passApplyNo
  406. && a.GetValue("passApplySeq") == passApplySeq).FirstOrDefault();
  407. if (rowRelocate != null)
  408. {
  409. rowRelocate.Activate();
  410. }
  411. }
  412. private void PassApply()
  413. {
  414. if (_gpJudgeApplyCtrl.UltraGrid1.ActiveRow == null)
  415. {
  416. MessageUtil.ShowWarning("没有需要放行申请的记录!");
  417. return;
  418. }
  419. var chkRows = _gpJudgeApplyCtrl.UltraGrid1.Rows.Where(a => a.GetValue("Chk") == "True");
  420. if (chkRows.Count() == 0)
  421. {
  422. if (_gpJudgeApplyCtrl.UltraGrid1.ActiveRow == null)
  423. {
  424. MessageUtil.ShowWarning("请选择申请判定记录!", _gpJudgeApplyCtrl.UltraGrid1);
  425. }
  426. else
  427. {
  428. MessageUtil.ShowWarning("请选择申请判定记录!", _gpJudgeApplyCtrl.UltraGrid1, _gpJudgeApplyCtrl.UltraGrid1.ActiveRow.Cells["Chk"]);
  429. }
  430. return;
  431. }
  432. List<string> gpJudgeApplyJsons = new List<string>();
  433. string judgeApplyCode = "";
  434. string judgeApplySeq = "";
  435. string judgeStoveNo = "";
  436. string stoveNo = "";
  437. foreach (var row in chkRows)
  438. {
  439. DataRow drGpJudgeApply = _d.GetRowByXmlId("QcmGpJugdeApplyDAL.queryGpApplyByJudgeStoveNo", row.GetValue("jugdeApplyCode"),
  440. row.GetValue("jugdeApplySqe"), row.GetValue("judgeStoveNo"));
  441. if (drGpJudgeApply["judgeResultCode"].ToString() != "40740704")
  442. {
  443. MessageUtil.ShowWarning("只有判定不合格的记录,才能申请质量放行!", _gpJudgeApplyCtrl.UltraGrid1, row);
  444. return;
  445. }
  446. DataRow drPassApply = _d.GetRowByXmlId("QcmGpPassApplyDAL.queryByGpJudgeApplyPk", row.GetValue("jugdeApplyCode"),
  447. row.GetValue("jugdeApplySqe"), row.GetValue("judgeStoveNo"));
  448. if (drPassApply != null && drPassApply["type"].ToString() == "0")
  449. {
  450. MessageUtil.ShowWarning("该记录已生成放行申请单,不能重复生成!", _gpJudgeApplyCtrl.UltraGrid1, row);
  451. return;
  452. }
  453. gpJudgeApplyJsons.Add(JsonHelper.ToJson(row));
  454. judgeApplyCode = row.GetValue("jugdeApplyCode");
  455. judgeApplySeq = row.GetValue("jugdeApplySqe");
  456. judgeStoveNo = row.GetValue("judgeStoveNo");
  457. stoveNo = row.GetValue("stoveNo");
  458. }
  459. PopupSubmit popupSubmit = new PopupSubmit("是否确认放行申请?", false, "");
  460. if (popupSubmit.ShowDialog() != System.Windows.Forms.DialogResult.Yes)
  461. {
  462. return;
  463. }
  464. var ccp = _d.Set("com.steering.pss.judge.Bll.BllSteelMakingColligateJudge.passApply", gpJudgeApplyJsons,
  465. UserInfo.GetUserName(), UserInfo.GetDeptid(), popupSubmit.TxtAudit.Text.Trim());
  466. if (ccp.ReturnInfo != "")
  467. {
  468. MessageUtil.ShowError(ccp.ReturnInfo);
  469. return;
  470. }
  471. else
  472. {
  473. MessageUtil.ShowTips("操作成功!");
  474. }
  475. Relocate(judgeApplyCode, judgeApplySeq, judgeStoveNo, stoveNo);
  476. }
  477. private void UrgentPassApply()
  478. {
  479. if (_gpJudgeApplyCtrl.UltraGrid1.ActiveRow == null)
  480. {
  481. MessageUtil.ShowWarning("没有需要放行申请的记录!");
  482. return;
  483. }
  484. var chkRows = _gpJudgeApplyCtrl.UltraGrid1.Rows.Where(a => a.GetValue("Chk") == "True");
  485. if (chkRows.Count() == 0)
  486. {
  487. if (_gpJudgeApplyCtrl.UltraGrid1.ActiveRow == null)
  488. {
  489. MessageUtil.ShowWarning("请选择申请判定记录!", _gpJudgeApplyCtrl.UltraGrid1);
  490. }
  491. else
  492. {
  493. MessageUtil.ShowWarning("请选择申请判定记录!", _gpJudgeApplyCtrl.UltraGrid1, _gpJudgeApplyCtrl.UltraGrid1.ActiveRow.Cells["Chk"]);
  494. }
  495. return;
  496. }
  497. List<string> gpJudgeApplyJsons = new List<string>();
  498. string judgeApplyCode = "";
  499. string judgeApplySeq = "";
  500. string judgeStoveNo = "";
  501. string stoveNo = "";
  502. foreach (var row in chkRows)
  503. {
  504. DataRow drGpJudgeApply = _d.GetRowByXmlId("QcmGpJugdeApplyDAL.queryGpApplyByJudgeStoveNo", row.GetValue("jugdeApplyCode"),
  505. row.GetValue("jugdeApplySqe"), row.GetValue("judgeStoveNo"));
  506. if (drGpJudgeApply["judgeResultCode"].ToString() != "")
  507. {
  508. MessageUtil.ShowWarning("已判定的记录不能申请紧急放行!", _gpJudgeApplyCtrl.UltraGrid1, row);
  509. return;
  510. }
  511. DataRow drPassApply = _d.GetRowByXmlId("QcmGpPassApplyDAL.queryCntByGpJudgeApplyPk",
  512. row.GetValue("jugdeApplyCode"), row.GetValue("jugdeApplySqe"), row.GetValue("judgeStoveNo"));
  513. if (drPassApply[0].ToString() != "0")
  514. {
  515. MessageUtil.ShowWarning("该记录已生成放行申请单,不能重复生成!", _gpJudgeApplyCtrl.UltraGrid1, row);
  516. return;
  517. }
  518. gpJudgeApplyJsons.Add(JsonHelper.ToJson(row));
  519. judgeApplyCode = row.GetValue("jugdeApplyCode");
  520. judgeApplySeq = row.GetValue("jugdeApplySqe");
  521. judgeStoveNo = row.GetValue("judgeStoveNo");
  522. stoveNo = row.GetValue("stoveNo");
  523. }
  524. PopupSubmit popupSubmit = new PopupSubmit("是否确认放行申请?", false, "");
  525. if (popupSubmit.ShowDialog() != System.Windows.Forms.DialogResult.Yes)
  526. {
  527. return;
  528. }
  529. var ccp = _d.Set("com.steering.pss.judge.Bll.BllSteelMakingColligateJudge.urgentPassApply", gpJudgeApplyJsons,
  530. UserInfo.GetUserName(), UserInfo.GetDeptid(), popupSubmit.TxtAudit.Text.Trim());
  531. if (ccp.ReturnInfo != "")
  532. {
  533. MessageUtil.ShowError(ccp.ReturnInfo);
  534. return;
  535. }
  536. else
  537. {
  538. MessageUtil.ShowTips("操作成功!");
  539. }
  540. Relocate(judgeApplyCode, judgeApplySeq, judgeStoveNo, stoveNo);
  541. }
  542. private void Judge()
  543. {
  544. var chkRows = _gpJudgeApplyCtrl.UltraGrid1.Rows.Where(a => a.GetValue("Chk") == "True");
  545. if (_gpJudgeApplyCtrl.UltraGrid1.ActiveRow == null)
  546. {
  547. MessageUtil.ShowWarning("没有需要判定的记录!");
  548. return;
  549. }
  550. if (chkRows.Count() == 0)
  551. {
  552. MessageUtil.ShowWarning("请选择申请判定记录!", _gpJudgeApplyCtrl.UltraGrid1, _gpJudgeApplyCtrl.UltraGrid1.ActiveRow.Cells["Chk"]);
  553. return;
  554. }
  555. string judgeApplyCode = "";
  556. string judgeApplySqe = "";
  557. string judgeStoveNo = "";
  558. string stoveNo = "";
  559. bool asked = false;
  560. foreach (var row in chkRows)
  561. {
  562. judgeApplyCode = row.GetValue("jugdeApplyCode");
  563. judgeApplySqe = row.GetValue("jugdeApplySqe");
  564. judgeStoveNo = row.GetValue("judgeStoveNo");
  565. stoveNo = row.GetValue("stoveNo");
  566. DataRow drChemJudge = _d.GetRowByXmlId("QcmLgJudgeDAL.getChemJudge", judgeStoveNo, "B");
  567. if (drChemJudge == null)
  568. {
  569. MessageUtil.ShowWarning("没有找到成分判定记录,请先进行成分判定!");
  570. return;
  571. }
  572. DataRow drExistJudge = _d.GetRowByXmlId("QcmGpJugdeApplyDAL.existJudgeQualified", row.GetValue("jugdeApplyCode"),
  573. row.GetValue("jugdeApplySqe"), row.GetValue("judgeStoveNo"));
  574. if (drExistJudge["judgeResultCode"].ToString() == "40740701" || drExistJudge["judgeResultCode"].ToString() == "40740702"
  575. || drExistJudge["judgeResultCode"].ToString() == "40740706") //如果已经判定则不判。 AND T.JUDGE_RESULT_CODE IN ('40740701', '40740702')
  576. {
  577. MessageUtil.ShowWarning("该记录已经" + drExistJudge["judgeResult"].ToString() + ",不允许重复判定!", _gpJudgeApplyCtrl.UltraGrid1, row);
  578. return;
  579. }
  580. //有放行申请单的不允许判定。
  581. DataRow drPassApply = _d.GetRowByXmlId("QcmGpPassApplyDAL.queryByGpJudgeApplyPk", row.GetValue("jugdeApplyCode"),
  582. row.GetValue("jugdeApplySqe"), row.GetValue("judgeStoveNo"));
  583. if (drPassApply != null)
  584. {
  585. if (drPassApply["TYPE"].ToString() == "0")
  586. {
  587. if (drPassApply["auditResult2"].ToString() == "")
  588. {
  589. MessageUtil.ShowWarning("该炉号处于放行审核状态,不允许判定!", _gpJudgeApplyCtrl.UltraGrid1, row);
  590. return;
  591. }
  592. if (drPassApply["auditResult2"].ToString() == "407504")
  593. {
  594. MessageUtil.ShowWarning("该炉号放行处置结果为降级/改判,请操作撤销判定!", _gpJudgeApplyCtrl.UltraGrid1, row);
  595. return;
  596. }
  597. if (drPassApply["auditResult2"].ToString() == "407505")
  598. {
  599. MessageUtil.ShowWarning("该炉号放行处置结果为报废,请操作撤销判定!", _gpJudgeApplyCtrl.UltraGrid1, row);
  600. return;
  601. }
  602. if (drPassApply["auditResult2"].ToString() == "407506")
  603. {
  604. MessageUtil.ShowWarning("该炉号放行处置结果为返工,请操作撤销判定!", _gpJudgeApplyCtrl.UltraGrid1, row);
  605. return;
  606. }
  607. }
  608. else
  609. {
  610. if (drPassApply["auditResult"].ToString() == "")
  611. {
  612. MessageUtil.ShowWarning("该炉号处于放行审核状态,不允许判定!", _gpJudgeApplyCtrl.UltraGrid1, row);
  613. return;
  614. }
  615. }
  616. }
  617. DataRow chemResult = _d.GetRowByXmlId("JdgQcmLgChemResult.getJfFail", judgeStoveNo);
  618. if (chemResult != null)
  619. {
  620. if (MessageUtil.ShowYesNoAndQuestion("判定炉号【" + judgeStoveNo + "】不符合交付标准,是否确认继续判定?") == System.Windows.Forms.DialogResult.No)
  621. {
  622. return;
  623. }
  624. asked = true;
  625. }
  626. }
  627. if (!asked)
  628. {
  629. if (MessageUtil.ShowYesNoAndQuestion("是否确认进行判定?") == System.Windows.Forms.DialogResult.No)
  630. {
  631. return;
  632. }
  633. }
  634. List<string> judgeStoveNos = new List<string>();
  635. foreach (var row in chkRows)
  636. {
  637. if (judgeStoveNos.Contains(row.GetValue("judgeStoveNo"))) continue;
  638. judgeStoveNos.Add(row.GetValue("judgeStoveNo"));
  639. //QcmLgJudgeEntity lgJudge = new QcmLgJudgeEntity();
  640. //lgJudge.CreateName = UserInfo.GetUserName();
  641. //lgJudge.Memo = row.GetValue("judgeMemo");
  642. //lgJudge.Judgeresult = row.GetValue("judgeResultCode");
  643. var ccp = _d.Set("com.steering.pss.judge.Bll.BllSteelMakingColligateJudge.JudgeSteelMaking", row.GetValue("jugdeApplyCode"),
  644. row.GetValue("jugdeApplySqe"), row.GetValue("judgeStoveNo"), UserInfo.GetUserName(), UserInfo.GetUserOrderText(),
  645. UserInfo.GetUserGroupText(), row.GetValue("judgeMemo"), row.GetValue("judgeMemo2"),
  646. ((int)JudgeType.SteelMakingColligate).ToString());
  647. if (ccp.ReturnInfo != "")
  648. {
  649. MessageUtil.ShowWarning(ccp.ReturnInfo);
  650. return;
  651. }
  652. }
  653. MessageUtil.ShowTips("判定成功!");
  654. Relocate(judgeApplyCode, judgeApplySqe, judgeStoveNo, stoveNo);
  655. }
  656. private void refresh()
  657. {
  658. var chkRows = _gpJudgeApplyCtrl.UltraGrid1.Rows.Where(a => a.GetValue("Chk") == "True");
  659. if (_gpJudgeApplyCtrl.UltraGrid1.ActiveRow == null)
  660. {
  661. MessageUtil.ShowWarning("没有需要刷新的记录!");
  662. return;
  663. }
  664. if (chkRows.Count() == 0)
  665. {
  666. MessageUtil.ShowWarning("请选择申请判定记录!", _gpJudgeApplyCtrl.UltraGrid1, _gpJudgeApplyCtrl.UltraGrid1.ActiveRow.Cells["Chk"]);
  667. return;
  668. }
  669. string judgeApplyCode = "";
  670. string judgeApplySqe = "";
  671. string judgeStoveNo = "";
  672. string stoveNo = "";
  673. bool asked = false;
  674. foreach (var row in chkRows)
  675. {
  676. judgeApplyCode = row.GetValue("jugdeApplyCode");
  677. judgeApplySqe = row.GetValue("jugdeApplySqe");
  678. judgeStoveNo = row.GetValue("judgeStoveNo");
  679. stoveNo = row.GetValue("stoveNo");
  680. DataRow drChemJudge = _d.GetRowByXmlId("QcmLgJudgeDAL.getChemJudge", judgeStoveNo, "B");
  681. if (drChemJudge == null)
  682. {
  683. MessageUtil.ShowWarning("没有找到成分判定记录,请先进行成分判定!");
  684. return;
  685. }
  686. DataRow drExistJudge = _d.GetRowByXmlId("QcmGpJugdeApplyDAL.existJudgeQualified", row.GetValue("jugdeApplyCode"),
  687. row.GetValue("jugdeApplySqe"), row.GetValue("judgeStoveNo"));
  688. if (drExistJudge["judgeResultCode"].ToString() == "40740701" || drExistJudge["judgeResultCode"].ToString() == "40740702"
  689. || drExistJudge["judgeResultCode"].ToString() == "40740706") //如果已经判定则不判。 AND T.JUDGE_RESULT_CODE IN ('40740701', '40740702')
  690. {
  691. }
  692. else
  693. {
  694. MessageUtil.ShowWarning("该记录未判定或判定不合格,不允许刷新!", _gpJudgeApplyCtrl.UltraGrid1, row);
  695. return;
  696. }
  697. }
  698. List<string> judgeStoveNos = new List<string>();
  699. foreach (var row in chkRows)
  700. {
  701. if (judgeStoveNos.Contains(row.GetValue("judgeStoveNo"))) continue;
  702. judgeStoveNos.Add(row.GetValue("judgeStoveNo"));
  703. var ccp = _d.Set("com.steering.pss.judge.Bll.BllSteelMakingColligateJudge.refreshZbsInfo", row.GetValue("jugdeApplyCode"),
  704. row.GetValue("jugdeApplySqe"), row.GetValue("judgeStoveNo"));
  705. if (ccp.ReturnInfo != "")
  706. {
  707. MessageUtil.ShowWarning(ccp.ReturnInfo);
  708. return;
  709. }
  710. }
  711. MessageUtil.ShowTips("刷新成功!");
  712. Relocate(judgeApplyCode, judgeApplySqe, judgeStoveNo, stoveNo);
  713. }
  714. private void ReviewGpCertificate()
  715. {
  716. try
  717. {
  718. this.Cursor = Cursors.WaitCursor;
  719. if (cusInfoEnd == "120501")
  720. {
  721. var row = _gpJudgeApplyCtrl.UltraGrid1.ActiveRow;
  722. if (row == null)
  723. {
  724. MessageUtil.ShowWarning("请选择一行记录!");
  725. return;
  726. }
  727. string judgeApplyCode = row.Cells["jugdeApplyCode"].Value.ToString();
  728. string judgeApplySeq = row.Cells["jugdeApplySqe"].Value.ToString();
  729. string judgeStoveNo = row.Cells["judgeStoveNo"].Value.ToString();
  730. string strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepGpCertificate.cpt&_bypagesize__=false" + "&JUGDE_APPLY_CODE="
  731. + judgeApplyCode + judgeApplySeq + "&JUDGE_STOVE_NO=" + judgeStoveNo;
  732. FrmOrderRepExcel fBug = new FrmOrderRepExcel(ob, strurl);
  733. fBug.AutoSize = true;
  734. fBug.MaximumSize = new Size(Screen.PrimaryScreen.WorkingArea.Width, Screen.PrimaryScreen.WorkingArea.Height);
  735. fBug.WindowState = FormWindowState.Maximized;
  736. fBug.Text = "管坯判定书";
  737. fBug.Show();
  738. }
  739. else
  740. {
  741. var chkRows = _gpJudgeApplyCtrl.UltraGrid1.Rows.Where(a => a.GetValue("Chk") == "True");
  742. if (chkRows.Count() == 0)
  743. {
  744. MessageUtil.ShowWarning("请选择一行记录!");
  745. return;
  746. }
  747. String listParm = "";
  748. foreach (var row in chkRows)
  749. {
  750. string judgeApplyCode = row.Cells["jugdeApplyCode"].Value.ToString();
  751. string judgeApplySeq = row.Cells["jugdeApplySqe"].Value.ToString();
  752. if (listParm != "")
  753. listParm += "','";
  754. listParm += judgeApplyCode + judgeApplySeq ;
  755. }
  756. string strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepGpCertificateTH.cpt&_bypagesize__=false" + "&JUGDE_APPLY_CODE="
  757. + listParm ;
  758. FrmOrderRepExcel fBug = new FrmOrderRepExcel(ob, strurl);
  759. fBug.AutoSize = true;
  760. fBug.MaximumSize = new Size(Screen.PrimaryScreen.WorkingArea.Width, Screen.PrimaryScreen.WorkingArea.Height);
  761. fBug.WindowState = FormWindowState.Maximized;
  762. fBug.Text = "管坯判定书";
  763. fBug.Show();
  764. }
  765. }
  766. finally
  767. {
  768. this.Cursor = Cursors.Default;
  769. }
  770. }
  771. private void Relocate(string judgeApplyCode, string judgeApplySqe, string judgeStoveNo, string stoveNo)
  772. {
  773. if (_gpApplyQuery)
  774. {
  775. Query();
  776. var rowJudgeApply = _gpJudgeApplyCtrl.UltraGrid1.Rows.Where(a => a.GetValue("jugdeApplyCode") == judgeApplyCode
  777. && a.GetValue("jugdeApplySqe") == judgeApplySqe && a.GetValue("judgeStoveNo") == judgeStoveNo).FirstOrDefault();
  778. if (rowJudgeApply != null)
  779. {
  780. rowJudgeApply.Activate();
  781. }
  782. }
  783. else
  784. {
  785. ultraTextEditor2_EditorButtonClick(null, null);
  786. var rowSteelMaking = _meltingStoveNoCtrl.UltraGrid1.Rows.Where(a => a.GetValue("stoveNo") == stoveNo).FirstOrDefault();
  787. if (rowSteelMaking != null)
  788. {
  789. rowSteelMaking.Activate();
  790. }
  791. }
  792. }
  793. private bool _gpApplyQuery = true;
  794. private void Query()
  795. {
  796. try
  797. {
  798. this.Cursor = Cursors.WaitCursor;
  799. string realBeginTime = labelDateTimePicker1.Checked ? labelDateTimePicker1.Value.ToString("yyyy-MM-dd HH:mm:ss") : "";
  800. string realEndTime = labelDateTimePicker1.Checked ? labelDateTimePicker2.Value.ToString("yyyy-MM-dd HH:mm:ss") : "";
  801. string judgeState = labelComboBox2.Checked ? labelComboBox2.SelecteValue.ToString2() : "";
  802. string stoveNo = labelTextBox1.Checked ? labelTextBox1.Text.Trim() : "";
  803. string judgeStoveNo = labelTextBox4.Checked ? labelTextBox4.Text.Trim() : "";
  804. string proOrdId = labelTextBox2.Checked ? labelTextBox2.Text.Trim() : "";
  805. string[] plines;
  806. if (labelComboBox1.ComboBox.Value == null || !labelComboBox1.Checked)
  807. {
  808. plines = new string[0];
  809. }
  810. else
  811. {
  812. plines = ((List<object>)labelComboBox1.ComboBox.Value).Select(a => a.ToString()).ToArray();
  813. }
  814. string gpSource = ultraOptionSet3.Value.ToString2();
  815. string[] plinesGp;
  816. if (labelComboBox5.ComboBox.Value == null || !labelComboBox5.Checked)
  817. {
  818. plinesGp = new string[0];
  819. }
  820. else
  821. {
  822. plinesGp = ((List<object>)labelComboBox5.ComboBox.Value).Select(a => a.ToString()).ToArray();
  823. }
  824. switch (ultraTabControl2.SelectedTab.Text)
  825. {
  826. case "综合判定":
  827. _gpApplyQuery = true;
  828. _gpJudgeApplyCtrl.ClearData();
  829. _jhyElementsCtrl.ClearData();
  830. _jhyPhyDbResultCtrl.ClearData();
  831. _gpJudgeApplyDtlCtrl.Clear();
  832. //_lgJudgeCtrl.ClearData();
  833. _faceFileCtrl.ClearData();
  834. _gpJudgeApplyCtrl.QuerySteelMakingP(stoveNo, judgeStoveNo, realBeginTime, realEndTime, proOrdId,
  835. judgeState, plines, gpSource, plinesGp, cusInfoEnd);
  836. break;
  837. case "判定记录":
  838. string stoveNo2 = labelTextBox3.Checked ? labelTextBox3.Text.Trim() : "";
  839. string judgeStoveNo2 = labelTextBox7.Checked ? labelTextBox7.Text.Trim() : "";
  840. string judgeResult = labelComboBox3.Checked ? labelComboBox3.SelecteValue.ToString2() : "";
  841. string timeBegin = labelDateTimePicker4.Checked ? labelDateTimePicker4.DateTimePicker.Value.ToString("yyyy-MM-dd HH:mm:ss") : "";
  842. string timeEnd = labelDateTimePicker3.Checked ? labelDateTimePicker3.DateTimePicker.Value.ToString("yyyy-MM-dd HH:mm:ss") : "";
  843. string judgeName = labelTextBox8.Checked ? labelTextBox8.Text.Trim() : "";
  844. string[] plines2;
  845. if (labelComboBox4.ComboBox.Value == null || !labelComboBox4.Checked)
  846. {
  847. plines2 = new string[0];
  848. }
  849. else
  850. {
  851. plines2 = ((List<object>)labelComboBox4.ComboBox.Value).Select(a => a.ToString()).ToArray();
  852. }
  853. _lgJudgeCtrl.Query(stoveNo2, judgeStoveNo2, judgeResult, timeBegin, timeEnd, plines2, judgeName, cusInfoEnd);
  854. break;
  855. case "不合格评审记录":
  856. string stoveNo3 = labelTextBox5.Checked ? labelTextBox5.Text.Trim() : "";
  857. string judgeStoveNo3 = labelTextBox6.Checked ? labelTextBox6.Text.Trim() : "";
  858. string timeB3 = labelDateTimePicker6.Checked ? labelDateTimePicker6.Value.ToString("yyyy-MM-dd HH:mm:ss") : "";
  859. string timeE3 = labelDateTimePicker6.Checked ? labelDateTimePicker5.Value.ToString("yyyy-MM-dd HH:mm:ss") : "";
  860. string validflag = labelCheckBox1.Checked ? "0" : "1";
  861. _gpJudgeApplyDtlCtrl2.Clear();
  862. string prmCustomInfo = cusInfoStart == "" ? "" : cusInfoStart + "2";
  863. _gpPassApply.AuditeQuery(stoveNo3, judgeStoveNo3, timeB3, timeE3, prmCustomInfo, "", validflag, cusInfoEnd);
  864. break;
  865. }
  866. }
  867. finally
  868. {
  869. this.Cursor = Cursors.Default;
  870. }
  871. }
  872. void steelMakingCtrl_AfterRowActivate(object sender, EventArgs e)
  873. {
  874. try
  875. {
  876. this.Cursor = Cursors.WaitCursor;
  877. _jhyElementsCtrl.ClearData();
  878. _jhyPhyDbResultCtrl.ClearData();
  879. _gpJudgeApplyDtlCtrl.Clear();
  880. _faceFileCtrl.ClearData();
  881. var row = _meltingStoveNoCtrl.UltraGrid1.ActiveRow;
  882. _gpJudgeApplyCtrl.QuerySteelMakingP(row.GetValue("StoveNo"), cusInfoEnd);
  883. }
  884. finally
  885. {
  886. this.Cursor = Cursors.Default;
  887. }
  888. }
  889. void gpJudgeApplyCtrl_AfterRowActivate(object sender, EventArgs e)
  890. {
  891. try
  892. {
  893. this.Cursor = Cursors.WaitCursor;
  894. //查询倍尺、长度、重量等信息
  895. var row = _gpJudgeApplyCtrl.UltraGrid1.ActiveRow;
  896. _gpJudgeApplyDtlCtrl.Query(row.GetValue("jugdeApplyCode"), row.GetValue("jugdeApplySqe"), row.GetValue("judgeStoveNo"));
  897. //设置Tab
  898. //string designKey = dtCraft["desginKey"].ToString();
  899. //string cic = dtCraft["cic"].ToString();
  900. //string mscPline = dtCraft["mscPline"].ToString();
  901. //string pic = dtCraft["pic"].ToString();
  902. //DataRow drCic = _d.GetRowByXmlId("CraftOrdDesignStdCic.existCicLgColligate", designKey, mscPline);
  903. //if (drCic[0].ToString() == "0")
  904. //{
  905. // ultraTabControl1.Tabs[0].Visible = false;
  906. //}
  907. //else
  908. //{
  909. // ultraTabControl1.Tabs[0].Visible = true;
  910. //}
  911. DataRow craftDbCnt = _d.GetRowByXmlId("QcmJhyPhyDbResultDAL.queryJhyDbCnt", row.GetValue("judgeStoveNo"));
  912. if (craftDbCnt["COUNT"].ToString() == "0" && !row.GetValue("steelStandrad").Contains("PIC"))
  913. {
  914. ultraTabControl1.Tabs[1].Visible = false;
  915. }
  916. else
  917. {
  918. ultraTabControl1.Tabs[1].Visible = true;
  919. }
  920. DataRow drGpApply = _d.GetRowByXmlId("QcmGpJugdeApplyDAL.queryGpApplyByJudgeStoveNo", row.GetValue("jugdeApplyCode"),
  921. row.GetValue("jugdeApplySqe"), row.GetValue("JudgeStoveNo"));
  922. if (drGpApply != null && drGpApply["DetectResultPath"].ToString() != "")
  923. {
  924. ultraTabControl1.Tabs[2].Visible = true;
  925. }
  926. else
  927. {
  928. ultraTabControl1.Tabs[2].Visible = false;
  929. }
  930. QueryGpJudgeApplyDown(drGpApply);
  931. }
  932. finally
  933. {
  934. this.Cursor = Cursors.Default;
  935. }
  936. }
  937. private void QueryGpJudgeApplyDown(DataRow drGpApply)
  938. {
  939. if (_gpJudgeApplyCtrl == null) return;
  940. var row = _gpJudgeApplyCtrl.UltraGrid1.ActiveRow;
  941. if (row == null) return;
  942. switch (ultraTabControl1.SelectedTab.Text)
  943. {
  944. case "成分信息":
  945. _jhyElementsCtrl.ClearData();
  946. string[] zgProPlanIds = SteelMakingChemJudgeFrm.GetGpJudgeApplyZgPlanId(row.GetValue("jugdeApplyCode"),
  947. row.GetValue("jugdeApplySqe"), row.GetValue("judgeStoveNo"), row.GetValue("stoveNo"), _d.Ob);
  948. DataRow drPlnCic = _d.GetRowByXmlId("PlnSteelforOrdDAL.getCicByJudgeStoveNo", row.GetValue("judgeStoveNo"));
  949. string[] cics = new string[] { drGpApply["cic"].ToString() };
  950. if (drPlnCic != null)
  951. {
  952. cics = drPlnCic["cic"].ToString().Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
  953. }
  954. DataTable dtCraftCic = _d.GetTableByXmlId("JdgPlnOrderZgS.queryCraftCicByZgProPlanId", new object[] { zgProPlanIds, cics.Length, cics });
  955. //增加余材获取成分
  956. if (dtCraftCic.Rows.Count <= 0)
  957. {
  958. drPlnCic = _d.GetRowByXmlId("PlnSteelforOrdDAL.getCicByProPlanId", new object[] { zgProPlanIds });
  959. cics = new string[1];
  960. if (drPlnCic != null)
  961. {
  962. cics = drPlnCic["cic"].ToString().Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
  963. }
  964. else if (drGpApply != null)
  965. {
  966. cics[0] = drGpApply["cic"].ToString();
  967. }
  968. dtCraftCic = _d.GetTableByXmlId("JdgPlnOrderZgS.queryCraftCicByZgProPlanId", new object[] { zgProPlanIds, cics.Length, cics });
  969. if (dtCraftCic.Rows.Count <= 0)
  970. {
  971. dtCraftCic = _d.GetTableByXmlId("JdgPlnOrderZgS.queryCraftCicByZgProPlanIdNew", new object[] { zgProPlanIds });
  972. }
  973. }
  974. _jhyElementsCtrl.SteelMakingColligateQuery(row.GetValue("stoveNo"), row.GetValue("judgeStoveNo"), dtCraftCic, "A", zgProPlanIds);
  975. break;
  976. case "低倍信息":
  977. _jhyPhyDbResultCtrl.ClearData();
  978. //drCraft = _d.GetRowByXmlId("QcmGpJugdeApplyDAL.queryCraftDesignKey", zgProPlanId, zgGxPlanNo);
  979. //if (drCraft == null) return;
  980. //designKey = drCraft["desginKey"].ToString();
  981. //pic = drCraft["PIC"].ToString();
  982. //mscPline = drCraft["mscPline"].ToString();
  983. string lgJudgeStoveNo = row.GetValue("judgeStoveNo");
  984. if (drGpApply["judgeStoveNoLg"].ToString() != "")
  985. {
  986. lgJudgeStoveNo = drGpApply["judgeStoveNoLg"].ToString();
  987. }
  988. _jhyPhyDbResultCtrl.Query(lgJudgeStoveNo);
  989. break;
  990. case "探伤信息":
  991. _detectFileCtrl.Query(row.GetValue("judgeStoveNo"));
  992. break;
  993. case "表检尺寸":
  994. _faceFileCtrl.Query(row.GetValue("judgeStoveNo"));
  995. break;
  996. }
  997. }
  998. private void FillLkCic(DataRow drGpApply, DataTable dtCraftCic)
  999. {
  1000. if (drGpApply != null && drGpApply["Cic"].ToString() != "" && drGpApply["LkFlag"].ToString() == "1")
  1001. {
  1002. bool sameCic = false;
  1003. foreach (DataRow drCraftCic in dtCraftCic.Rows)
  1004. {
  1005. if (drCraftCic["cic"].ToString() == drGpApply["cic"].ToString())
  1006. {
  1007. sameCic = true;
  1008. }
  1009. }
  1010. if (!sameCic)
  1011. {
  1012. foreach (DataRow drCraftCic in dtCraftCic.Rows)
  1013. {
  1014. drCraftCic["cic"] = drGpApply["cic"].ToString();
  1015. }
  1016. }
  1017. }
  1018. }
  1019. private void ultraTabControl1_SelectedTabChanged(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e)
  1020. {
  1021. try
  1022. {
  1023. this.Cursor = Cursors.WaitCursor;
  1024. if (_gpJudgeApplyCtrl == null || _gpJudgeApplyCtrl.UltraGrid1.ActiveRow == null) return;
  1025. var row = _gpJudgeApplyCtrl.UltraGrid1.ActiveRow;
  1026. DataRow drGpApply = _d.GetRowByXmlId("QcmGpJugdeApplyDAL.queryGpApplyByJudgeStoveNo", row.GetValue("jugdeApplyCode"),
  1027. row.GetValue("jugdeApplySqe"), row.GetValue("JudgeStoveNo"));
  1028. QueryGpJudgeApplyDown(drGpApply);
  1029. }
  1030. finally
  1031. {
  1032. this.Cursor = Cursors.Default;
  1033. }
  1034. }
  1035. private void ultraTextEditor2_EditorButtonClick(object sender, Infragistics.Win.UltraWinEditors.EditorButtonEventArgs e)
  1036. {
  1037. _gpApplyQuery = false;
  1038. string[] values;
  1039. if (ultraComboEditor1.Value == null || !checkBox1.Checked)
  1040. {
  1041. values = new string[0];
  1042. }
  1043. else
  1044. {
  1045. values = ((List<object>)ultraComboEditor1.Value).Select(a => a.ToString()).ToArray();
  1046. }
  1047. _gpJudgeApplyCtrl.ClearData();
  1048. _jhyElementsCtrl.ClearData();
  1049. _faceFileCtrl.ClearData();
  1050. _jhyPhyDbResultCtrl.ClearData();
  1051. string stoveNo = ultraTextEditor2.Text.Trim();
  1052. string plineCode = ultraComboEditor2.Value.ToString2();
  1053. string judgeState = ultraOptionSet1.Value.ToString();
  1054. string timeB = checkBox3.Checked ? dateTimePicker1.Value.ToString("yyy-MM-dd HH:mm:ss") : "";
  1055. string timeE = checkBox3.Checked ? dateTimePicker2.Value.ToString("yyy-MM-dd HH:mm:ss") : "";
  1056. _meltingStoveNoCtrl.LgColligateQuery(stoveNo, values, plineCode, judgeState, timeB, timeE);
  1057. }
  1058. private void labelDateTimePicker4_CheckBox_CheckedChanged(object sender, EventArgs e)
  1059. {
  1060. labelDateTimePicker3.DateTimePicker.Enabled = labelDateTimePicker4.Checked;
  1061. }
  1062. private void ultraTabControl2_SelectedTabChanged(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e)
  1063. {
  1064. if (toolMenu == null || toolMenu.Toolbars.Count == 0) return;
  1065. switch (ultraTabControl2.ActiveTab.Index)
  1066. {
  1067. case 0:
  1068. if (this.toolMenu.Toolbars[0].Tools.Exists("Judge")) this.toolMenu.Toolbars[0].Tools["Judge"].SharedProps.Visible = true;
  1069. if (this.toolMenu.Toolbars[0].Tools.Exists("PassApply")) this.toolMenu.Toolbars[0].Tools["PassApply"].SharedProps.Visible = true;
  1070. if (this.toolMenu.Toolbars[0].Tools.Exists("UrgentPassApply")) this.toolMenu.Toolbars[0].Tools["UrgentPassApply"].SharedProps.Visible = true;
  1071. if (this.toolMenu.Toolbars[0].Tools.Exists("DeletePassApply")) this.toolMenu.Toolbars[0].Tools["DeletePassApply"].SharedProps.Visible = false;
  1072. if (this.toolMenu.Toolbars[0].Tools.Exists("DeleteJudge")) this.toolMenu.Toolbars[0].Tools["DeleteJudge"].SharedProps.Visible = true;
  1073. if (this.toolMenu.Toolbars[0].Tools.Exists("UpdateMemo")) this.toolMenu.Toolbars[0].Tools["UpdateMemo"].SharedProps.Visible = true;
  1074. break;
  1075. case 1:
  1076. if (this.toolMenu.Toolbars[0].Tools.Exists("Judge")) this.toolMenu.Toolbars[0].Tools["Judge"].SharedProps.Visible = false;
  1077. if (this.toolMenu.Toolbars[0].Tools.Exists("PassApply")) this.toolMenu.Toolbars[0].Tools["PassApply"].SharedProps.Visible = false;
  1078. if (this.toolMenu.Toolbars[0].Tools.Exists("UrgentPassApply")) this.toolMenu.Toolbars[0].Tools["UrgentPassApply"].SharedProps.Visible = false;
  1079. if (this.toolMenu.Toolbars[0].Tools.Exists("DeletePassApply")) this.toolMenu.Toolbars[0].Tools["DeletePassApply"].SharedProps.Visible = false;
  1080. if (this.toolMenu.Toolbars[0].Tools.Exists("DeleteJudge")) this.toolMenu.Toolbars[0].Tools["DeleteJudge"].SharedProps.Visible = false;
  1081. if (this.toolMenu.Toolbars[0].Tools.Exists("UpdateMemo")) this.toolMenu.Toolbars[0].Tools["UpdateMemo"].SharedProps.Visible = false;
  1082. break;
  1083. case 2:
  1084. if (this.toolMenu.Toolbars[0].Tools.Exists("Judge")) this.toolMenu.Toolbars[0].Tools["Judge"].SharedProps.Visible = false;
  1085. if (this.toolMenu.Toolbars[0].Tools.Exists("PassApply")) this.toolMenu.Toolbars[0].Tools["PassApply"].SharedProps.Visible = false;
  1086. if (this.toolMenu.Toolbars[0].Tools.Exists("UrgentPassApply")) this.toolMenu.Toolbars[0].Tools["UrgentPassApply"].SharedProps.Visible = false;
  1087. if (this.toolMenu.Toolbars[0].Tools.Exists("DeletePassApply")) this.toolMenu.Toolbars[0].Tools["DeletePassApply"].SharedProps.Visible = true;
  1088. if (this.toolMenu.Toolbars[0].Tools.Exists("DeleteJudge")) this.toolMenu.Toolbars[0].Tools["DeleteJudge"].SharedProps.Visible = false;
  1089. if (this.toolMenu.Toolbars[0].Tools.Exists("UpdateMemo")) this.toolMenu.Toolbars[0].Tools["UpdateMemo"].SharedProps.Visible = false;
  1090. break;
  1091. }
  1092. }
  1093. private void SteelMakingColligateJudgeFrm_Shown(object sender, EventArgs e)
  1094. {
  1095. ultraTabControl2_SelectedTabChanged(null, null);
  1096. }
  1097. private void labelDateTimePicker6_CheckBox_CheckedChanged(object sender, EventArgs e)
  1098. {
  1099. labelDateTimePicker5.DateTimeEnabled = labelDateTimePicker6.Checked;
  1100. }
  1101. private void checkBox1_CheckedChanged(object sender, EventArgs e)
  1102. {
  1103. ultraComboEditor1.Enabled = checkBox1.Checked;
  1104. }
  1105. private void checkBox3_CheckedChanged(object sender, EventArgs e)
  1106. {
  1107. dateTimePicker1.Enabled = dateTimePicker2.Enabled = checkBox3.Checked;
  1108. }
  1109. private void checkBox2_CheckedChanged(object sender, EventArgs e)
  1110. {
  1111. ultraComboEditor2.Enabled = checkBox2.Checked;
  1112. }
  1113. private void labelTextBox4_TextBox_KeyDown(object sender, KeyEventArgs e)
  1114. {
  1115. if (e.KeyData == Keys.Enter)
  1116. {
  1117. Query();
  1118. }
  1119. }
  1120. private void ultraTextEditor2_KeyDown(object sender, KeyEventArgs e)
  1121. {
  1122. if (e.KeyData == Keys.Enter)
  1123. {
  1124. ultraTextEditor2_EditorButtonClick(null, null);
  1125. }
  1126. }
  1127. private void labelTextBox6_TextBox_KeyDown(object sender, KeyEventArgs e)
  1128. {
  1129. if (e.KeyData == Keys.Enter)
  1130. {
  1131. Query();
  1132. }
  1133. }
  1134. private void labelTextBox7_TextBox_KeyDown(object sender, KeyEventArgs e)
  1135. {
  1136. if (e.KeyData == Keys.Enter)
  1137. {
  1138. Query();
  1139. }
  1140. }
  1141. }
  1142. }