RolledTubeColligateJudgeFrm.cs 84 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750
  1. using Core.Mes.Client.Comm.Control;
  2. using Core.Mes.Client.Comm.Server;
  3. using Core.Mes.Client.Comm.Tool;
  4. using Core.StlMes.Client.Judge.Commons;
  5. using Core.StlMes.Client.Judge.Controls;
  6. using CoreFS.CA06;
  7. using Infragistics.Win.UltraWinGrid;
  8. using System;
  9. using System.Collections.Generic;
  10. using System.Data;
  11. using System.Drawing;
  12. using System.Linq;
  13. using System.Windows.Forms;
  14. namespace Core.StlMes.Client.Judge.Forms
  15. {
  16. public partial class RolledTubeColligateJudgeFrm : FrmBase
  17. {
  18. private QcmZgColligateJudgeApplyCtrl _zgJudgeApplyCtrl;
  19. private QcmBcJudgeCtrl _bcJudgeCtrl;
  20. private QcmBcPassApplyCtrl _bcPassApply;
  21. private QcmBcPassFlowCtrl _bcPassFlowCtrl;
  22. private QcmZcAllChemPhyCtrl _zcAllChemPhyCtrl;
  23. private Dal _d;
  24. //单线程
  25. System.Windows.Forms.Timer timer = null;
  26. public RolledTubeColligateJudgeFrm()
  27. {
  28. InitializeComponent();
  29. IsLoadUserView = true;
  30. }
  31. private void labelDateTimePicker1_CheckBox_CheckedChanged(object sender, EventArgs e)
  32. {
  33. labelDateTimePicker2.DateTimePicker.Enabled = labelDateTimePicker1.Checked;
  34. }
  35. protected override void OnLoad(EventArgs e)
  36. {
  37. base.OnLoad(e);
  38. if (_zcAllChemPhyCtrl == null) return;
  39. _zcAllChemPhyCtrl.SetChemPhyResultError();
  40. ultraLabel3.Appearance.BackColor = labelComboBox2.BackColor;
  41. ultraLabel4.Appearance.BackColor = labelComboBox2.BackColor;
  42. ultraLabel5.Appearance.BackColor = labelComboBox2.BackColor;
  43. }
  44. private string processCode = "";
  45. private string passInfo = "";
  46. private DataTable _dtPline = null;
  47. private void SteelMakingColligateJudgeFrm_Load(object sender, EventArgs e)
  48. {
  49. processCode = CustomInfo.Substring(0, 1);
  50. passInfo = CustomInfo.Length > 2 ? CustomInfo.Substring(2) : "";
  51. _zgJudgeApplyCtrl = new QcmZgColligateJudgeApplyCtrl(splitContainer3.Panel1, ob, JudgeType.SteelMakingColligate, passInfo, processCode,UserInfo);
  52. _zgJudgeApplyCtrl.UltraGrid1.DisplayLayout.Override.AllowDelete = Infragistics.Win.DefaultableBoolean.False;
  53. _zgJudgeApplyCtrl.UltraGrid1.AfterRowActivate += gpJudgeApplyCtrl_AfterRowActivate;
  54. if (processCode != "F")
  55. {
  56. _zgJudgeApplyCtrl.UltraGrid1.DisplayLayout.Bands[0].Columns["lotNoGroup"].Hidden = true;
  57. }
  58. _zcAllChemPhyCtrl = new QcmZcAllChemPhyCtrl(ultraExpandableGroupBoxPanel2, ob, _zgJudgeApplyCtrl.UltraGrid1, processCode, "bcJudge");
  59. _bcJudgeCtrl = new QcmBcJudgeCtrl(ultraTabPageControl6, ob);
  60. _bcJudgeCtrl.EntityGrid1.StyleGrid.DisplayLayout.Override.AllowDelete = Infragistics.Win.DefaultableBoolean.False;
  61. _bcJudgeCtrl.EntityGrid1.StyleGrid.DisplayLayout.Override.AllowUpdate = Infragistics.Win.DefaultableBoolean.False;
  62. _bcPassApply = new QcmBcPassApplyCtrl(splitContainer2.Panel1, ob, UserInfo.GetDeptid());
  63. _bcPassApply.UltraGrid1.AfterRowActivate += gpPassApply_AfterRowActivate;
  64. _bcPassFlowCtrl = new QcmBcPassFlowCtrl(splitContainer2.Panel2, ob);
  65. _d = new Dal(ob);
  66. dataTable1.Clear();
  67. dataTable1.Rows.Add("00", "编制中");
  68. dataTable1.Rows.Add("10", "已下发");
  69. dataTable1.Rows.Add("20", "生产中");
  70. dataTable1.Rows.Add("30", "已生产");
  71. dataTable1.Rows.Add("40", "关闭");
  72. string[] datePurviewIds = this.ValidDataPurviewIds;
  73. if (CustomInfo.Contains("WG"))
  74. {
  75. datePurviewIds = new string[] { "002001001001" };//计划科
  76. }
  77. _dtPline = _d.GetTableByXmlId("JudgeBaseInfo.Query", new object[] { new string[] { processCode } });
  78. DataTable dtDeptPline = _d.GetTableByXmlId("JdgComBasePline.getPlineByDept", new object[] { datePurviewIds });
  79. for (int i = _dtPline.Rows.Count - 1; i >= 0; i--)
  80. {
  81. if (dtDeptPline.Select("plinecode = '" + _dtPline.Rows[i]["plinecode"].ToString() + "'").Length == 0)
  82. {
  83. _dtPline.Rows[i].Delete();
  84. }
  85. }
  86. _dtPline.AcceptChanges();
  87. string strPlineNames = string.Join(",", _dtPline.Rows.Cast<DataRow>().Select(a => a["plineName"].ToString()).ToArray());
  88. string strPineCodes = string.Join(",", _dtPline.Rows.Cast<DataRow>().Select(a => a["plineCode"].ToString()).ToArray());
  89. ultraTextEditor1.Text = strPlineNames;
  90. ultraTextEditor1.Tag = strPineCodes;
  91. ultraTextEditor3.Text = strPlineNames;
  92. ultraTextEditor3.Tag = strPineCodes;
  93. ultraTextEditor4.Text = strPlineNames;
  94. ultraTextEditor4.Tag = strPineCodes;
  95. ClsBaseInfo.FillComBaseInfo(labelComboBox2.ComboBox, "407407", ob, false);
  96. //判定结果只显示内控合格和不合格。 40740101内控合格 40740102内控不合格
  97. DataTable dt = (DataTable)labelComboBox2.ComboBox.DataSource;
  98. DataRow dr = dt.NewRow();
  99. dr["BASECODE"] = "1";
  100. dr["BASENAME"] = "已判";
  101. dt.Rows.InsertAt(dr, 0);
  102. dr = dt.NewRow();
  103. dr["BASECODE"] = "0";
  104. dr["BASENAME"] = "未判";
  105. dt.Rows.InsertAt(dr, 0);
  106. dt.AcceptChanges();
  107. dt.DefaultView.RowFilter = "BASECODE IN ('0', '1', '40740701', '40740704', '40740709')";
  108. ClsBaseInfo.SetComboItemHeight(labelComboBox2.ComboBox);
  109. ClsBaseInfo.FillComBaseInfo(labelComboBox3.ComboBox, "407407", ob, false);
  110. ClsBaseInfo.SetComboItemHeight(labelComboBox3.ComboBox);
  111. //labelDateTimePicker1.Checked = true;
  112. labelDateTimePicker1.DateTimePicker.Value = DateTime.Now.Date.AddDays(-3);
  113. labelDateTimePicker2.DateTimePicker.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1);
  114. labelDateTimePicker4.Checked = true;
  115. labelDateTimePicker4.DateTimePicker.Value = DateTime.Now.Date.AddDays(-3);
  116. labelDateTimePicker3.DateTimePicker.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1);
  117. labelDateTimePicker6.Checked = true;
  118. labelDateTimePicker6.DateTimePicker.Value = DateTime.Now.Date.AddDays(-3);
  119. labelDateTimePicker5.DateTimePicker.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1);
  120. labelDateTimePicker8.DateTimePicker.Value = DateTime.Now.Date.AddDays(-3);
  121. labelDateTimePicker7.DateTimePicker.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1);
  122. ultraComboEditor3.SelectedIndex = 0;
  123. ultraComboEditor4.SelectedIndex = 0;
  124. if (passInfo.Contains("Quality") || passInfo.Contains("Urgent"))
  125. {
  126. ultraTabControl2.Tabs[1].Visible = false;
  127. //_gpJudgeApplyCtrl.UltraGrid1.DisplayLayout.Bands[0].Columns["passType2"].Hidden = true;
  128. if (passInfo.Contains("Quality"))
  129. {
  130. labelComboBox2.ComboBox.Items[3].CheckState = CheckState.Checked;
  131. labelComboBox2.Checked = true;
  132. labelComboBox9.ComboBox.SelectedIndex = 1;
  133. labelComboBox9.Checked = true;
  134. labelComboBox1.Checked = true;
  135. labelComboBox1.ComboBox.SelectedIndex = 1;
  136. }
  137. if (passInfo.Contains("Urgent"))
  138. {
  139. labelComboBox2.ComboBox.Items[0].CheckState = CheckState.Checked;
  140. labelComboBox2.Checked = true;
  141. labelComboBox9.ComboBox.SelectedIndex = 0;
  142. labelComboBox9.Checked = true;
  143. panel1.Visible = false;
  144. panel6.Visible = true;
  145. }
  146. }
  147. else
  148. {
  149. labelComboBox2.Checked = true;
  150. labelComboBox2.ComboBox.Items[0].CheckState = CheckState.Checked;
  151. labelComboBox9.ComboBox.SelectedIndex = 0;
  152. labelComboBox9.Checked = true;
  153. if (!CustomInfo.Contains("WG"))
  154. {
  155. labelComboBox1.Checked = true;
  156. labelComboBox1.ComboBox.SelectedIndex = 1;
  157. }
  158. }
  159. if (this.CustomInfo.Equals("G_refreshStatus"))
  160. {
  161. startRefreshStatus();
  162. }
  163. }
  164. void gpPassApply_AfterRowActivate(object sender, EventArgs e)
  165. {
  166. try
  167. {
  168. this.Cursor = Cursors.WaitCursor;
  169. var row = _bcPassApply.UltraGrid1.ActiveRow;
  170. //_zgJudgeApplyDtlCtrl2.Query(row.GetValue("jugdeApplyCode"), row.GetValue("judgeStoveNo"), row.GetValue("batchNo"));
  171. _bcPassFlowCtrl.Query(row.GetValue("passApplyNo"));
  172. }
  173. finally
  174. {
  175. this.Cursor = Cursors.Default;
  176. }
  177. }
  178. public override void ToolBar_Click(object sender, string ToolbarKey)
  179. {
  180. base.ToolBar_Click(sender, ToolbarKey);
  181. switch (ToolbarKey)
  182. {
  183. case "Query":
  184. Query();
  185. break;
  186. case "Judge":
  187. Judge("1");
  188. break;
  189. case "GapJudge":
  190. Judge("0");
  191. break;
  192. case "refreshStatus":
  193. refreshStatus("1");
  194. break;
  195. case "PassApply":
  196. PassApply();
  197. break;
  198. case "DeletePassApply":
  199. DeletePassApply();
  200. break;
  201. case "DeleteJudge":
  202. DeleteJudge();
  203. break;
  204. case "ReviewGpCertificate":
  205. ReviewGpCertificate();
  206. break;
  207. case "UpdateMemo":
  208. UpdateMemo();
  209. break;
  210. case "ApplyRepeatSpline":
  211. ApplyRepeatSpline();
  212. break;
  213. case "DeleteRepeatSpline":
  214. DeleteRepeatSpline();
  215. break;
  216. case "FoldQuery":
  217. FoldQuery();
  218. break;
  219. case "RefreshGroup":
  220. RefreshGroup();
  221. break;
  222. case "RefreshCraft":
  223. RefreshCraft();
  224. break;
  225. case "CopyZgData":
  226. CopyZgData();
  227. break;
  228. case "CopyRclData":
  229. CopyRclData();
  230. break;
  231. case "Export":
  232. if (ultraTabControl2.ActiveTab.Key == "Judge")
  233. {
  234. GridHelper.ulGridToExcel(_zgJudgeApplyCtrl.UltraGrid1, "工序判定信息");
  235. }
  236. else if (ultraTabControl2.ActiveTab.Key == "JudgeRecord")
  237. {
  238. GridHelper.ulGridToExcel(_bcJudgeCtrl.EntityGrid1, "工序判定记录");
  239. }
  240. else if (ultraTabControl2.ActiveTab.Key == "PassRecord")
  241. {
  242. GridHelper.ulGridToExcel(_bcPassApply.UltraGrid1, "放行记录");
  243. }
  244. break;
  245. case "RefreshZbs":
  246. RefreshZbs();
  247. break;
  248. case "ZbsLock":
  249. UpdateZbsLock();
  250. break;
  251. case "startRefreshStatus":
  252. startRefreshStatus();
  253. break;
  254. case "endRefreshStatus":
  255. timer.Stop();
  256. MessageUtil.ShowTips("关闭执行刷新条件!");
  257. break;
  258. case "BatchDownload":
  259. BatchDownload();
  260. break;
  261. }
  262. }
  263. private void BatchDownload()
  264. {
  265. var chkRows = _zgJudgeApplyCtrl.UltraGrid1.Rows.Where(a => a.GetValue("Chk") == "True");
  266. if (chkRows.Count() == 0)
  267. {
  268. MessageUtil.ShowWarning("请选择需要导出的记录!");
  269. return;
  270. }
  271. WaitingForm2 wf = new WaitingForm2("文件检索中....");
  272. List<string> judgeStoveNos = new List<string>();
  273. List<string> pathList = new List<string>();
  274. string key = _zcAllChemPhyCtrl.ultraTabControl1.ActiveTab.Key;
  275. string key1 = "";
  276. switch (key)
  277. {
  278. case "A":
  279. key1 = _zcAllChemPhyCtrl.ZgChemPhyLgCtrl.ultraTabControl2.ActiveTab.Key;
  280. break;
  281. case "D":
  282. key1 = _zcAllChemPhyCtrl.ZgChemPhyZgCtrl.ultraTabControl2.ActiveTab.Key;
  283. break;
  284. case "E":
  285. key1 = _zcAllChemPhyCtrl.ZgChemPhyDbkCtrl.ultraTabControl2.ActiveTab.Key;
  286. break;
  287. case "F":
  288. key1 = _zcAllChemPhyCtrl.ZgChemPhyRclCtrl.ultraTabControl2.ActiveTab.Key;
  289. break;
  290. case "G":
  291. key1 = _zcAllChemPhyCtrl.ZgChemPhyJgxCtrl.ultraTabControl2.ActiveTab.Key;
  292. break;
  293. case "H":
  294. key1 = _zcAllChemPhyCtrl.ZgChemPhyJgCtrl.ultraTabControl2.ActiveTab.Key;
  295. break;
  296. }
  297. foreach (var row in chkRows)
  298. {
  299. DataTable dt = null;
  300. switch (key1)
  301. {
  302. case "water":
  303. if (key == "G")
  304. {
  305. dt = _d.GetTableByXmlId("JdgMchWatergageResult.getInfo", row.GetValue("judgeStoveNo"), row.GetValue("batchNo"));
  306. }
  307. else
  308. {
  309. dt = _d.GetTableByXmlId("JdgMchWatergageResult.getZgInfo", row.GetValue("judgeStoveNo"), row.GetValue("batchNo"), key);
  310. }
  311. for (int i = 0; i < dt.Rows.Count; i++)
  312. {
  313. pathList.Add(row.GetValue("judgeStoveNo") + "_" + row.GetValue("batchNo") + ";" + dt.Rows[i]["REPORTPATH"].ToString2());
  314. }
  315. break;
  316. case "finalCheck":
  317. dt = _d.GetTableByXmlId("JdgMchFinalChekResult.getInfo", row.GetValue("judgeStoveNo"), row.GetValue("batchNo"), key);
  318. for (int i = 0; i < dt.Rows.Count; i++)
  319. {
  320. pathList.Add(row.GetValue("judgeStoveNo") + "_" + row.GetValue("batchNo") + ";" + dt.Rows[i]["REPORTPATH"].ToString2());
  321. }
  322. break;
  323. case "jgDetect":
  324. dt = _d.GetTableByXmlId("JdgCouplingInSpectionResult.Query", row.GetValue("judgeStoveNo"), row.GetValue("batchNo"), row.GetValue("proOrderId"));
  325. for (int i = 0; i < dt.Rows.Count; i++)
  326. {
  327. pathList.Add(row.GetValue("judgeStoveNo") + "_" + row.GetValue("batchNo") + ";" + dt.Rows[i]["REPORTPATH"].ToString2());
  328. }
  329. break;
  330. case "detec":
  331. CoreClientParam ccp = _d.Set("com.steering.pss.judge.Bll.BllZcColligateJudge.getDetectInfo",
  332. row.GetValue("judgeStoveNo"), row.GetValue("batchNo"), key, "");
  333. if (ccp.ReturnInfo.ToString2() != "")
  334. {
  335. MessageUtil.ShowWarning(ccp.ReturnInfo.ToString2());
  336. return;
  337. }
  338. dt = JsonHelper.toTable(ccp.ReturnObject.ToString2());
  339. for (int i = 0; i < dt.Rows.Count; i++)
  340. {
  341. pathList.Add(row.GetValue("judgeStoveNo") + "_" + row.GetValue("batchNo") + ";" + dt.Rows[i]["REPORTPATH"].ToString2());
  342. }
  343. break;
  344. default:
  345. dt = _d.GetTableByXmlId("QcmZgJugdeApplyDAL.getReportPath", row.GetValue("judgeStoveNo"), row.GetValue("batchNo"));
  346. for (int i = 0; i < dt.Rows.Count; i++)
  347. {
  348. pathList.Add(row.GetValue("judgeStoveNo") + "_" + row.GetValue("batchNo") + ";" + dt.Rows[i][0].ToString2());
  349. }
  350. break;
  351. }
  352. }
  353. wf.Close();
  354. dlgOrderAskDown down = new dlgOrderAskDown(this.ob, pathList, "2", judgeStoveNos);
  355. down.DeleteButton.Visible = false;
  356. down.ShowDialog();
  357. //打开下载后的文件夹
  358. if (down.Pic != "")
  359. System.Diagnostics.Process.Start("Explorer.exe", down.Pic);
  360. }
  361. private void startRefreshStatus()
  362. {
  363. timer = new System.Windows.Forms.Timer();
  364. //执行事件
  365. timer.Tick += (s, e1) =>
  366. {
  367. labelComboBox2.Checked = false;
  368. labelComboBox1.Checked = true;
  369. labelComboBox1.ComboBox.SelectedIndex = 0;
  370. Query();
  371. foreach (var row in _zgJudgeApplyCtrl.UltraGrid1.Rows)
  372. {
  373. row.Cells["Chk"].Value = true;
  374. }
  375. refreshStatus("0");
  376. };
  377. //开始执行
  378. timer.Start();
  379. //间隔
  380. timer.Interval = 1000 * 60 * 10;
  381. MessageUtil.ShowTips("开始执行刷新条件!");
  382. }
  383. private void UpdateZbsLock()
  384. {
  385. var row = _zgJudgeApplyCtrl.UltraGrid1.ActiveRow;
  386. if (row == null)
  387. {
  388. MessageUtil.ShowWarning("请选择申请判定记录!");
  389. return;
  390. }
  391. string judgeStoveNo = row.GetValue("judgeStoveNo");
  392. string batchNo = row.GetValue("batchNo");
  393. string applyCode = row.GetValue("jugdeApplyCode");
  394. string zbsLockFlag = row.GetValue("zbsLockFlag").Equals("1") ? "0" : "1";
  395. var result = _d.Set("com.steering.pss.judge.Bll.BllCreateZbsInfo.UpdateZbsLock",
  396. applyCode, judgeStoveNo, batchNo, zbsLockFlag);
  397. if (result.ReturnInfo.ToString2() != "")
  398. {
  399. MessageUtil.ShowWarning(result.ReturnInfo);
  400. return;
  401. }
  402. if ("0".Equals(zbsLockFlag))
  403. {
  404. MessageUtil.ShowTips("解锁成功!");
  405. }
  406. else
  407. {
  408. MessageUtil.ShowTips("锁定成功!");
  409. }
  410. Query();
  411. }
  412. private void DeleteRepeatSpline()
  413. {
  414. var chkRows = _zgJudgeApplyCtrl.UltraGrid1.Rows.Where(a => a.GetValue("Chk") == "True");
  415. if (_zgJudgeApplyCtrl.UltraGrid1.ActiveRow == null)
  416. {
  417. MessageUtil.ShowWarning("没有需要撤销的记录!");
  418. return;
  419. }
  420. if (chkRows.Count() == 0)
  421. {
  422. MessageUtil.ShowWarning("请选择申请判定记录!", _zgJudgeApplyCtrl.UltraGrid1, _zgJudgeApplyCtrl.UltraGrid1.ActiveRow.Cells["Chk"]);
  423. return;
  424. }
  425. string judgeApplyCode = "";
  426. string lotNo = "";
  427. string judgeStoveNo = "";
  428. string batchNo = "";
  429. foreach (var row in chkRows)
  430. {
  431. judgeApplyCode = row.GetValue("jugdeApplyCode");
  432. lotNo = row.GetValue("lotNo");
  433. judgeStoveNo = row.GetValue("judgeStoveNo");
  434. batchNo = row.GetValue("batchNo");
  435. DataRow drCheckNoQualified = _d.GetRow("com.steering.pss.judge.Bll.BllRolledTubeColligateJudge.getCheckNoQualifiedCnt",
  436. new object[] { lotNo, judgeStoveNo, batchNo, new string[] { "0" } });
  437. DataRow drCheckNoQualified2 = _d.GetRow("com.steering.pss.judge.Bll.BllRolledTubeColligateJudge.getCheckNoQualifiedCnt",
  438. new object[] { lotNo, judgeStoveNo, batchNo, new string[] { "0", "1", "2" } });
  439. if (drCheckNoQualified2["count"].ToString() == "0")
  440. {
  441. MessageUtil.ShowWarning("该记录没有申请复取样,不需要撤销!");
  442. return;
  443. }
  444. else
  445. {
  446. if (drCheckNoQualified["count"].ToString() == "0")
  447. {
  448. MessageUtil.ShowWarning("该记录的申请复取样已被确认,不能撤销!");
  449. return;
  450. }
  451. }
  452. //DataRow drExistJudge = _d.GetRowByXmlId("QcmZgJugdeApplyDAL.existJudgeQualified", row.GetValue("jugdeApplyCode"),
  453. // row.GetValue("judgeStoveNo"), row.GetValue("batchNo"), processCode);
  454. //if (drExistJudge["judgeResultCode"].ToString() == "40740701" || drExistJudge["judgeResultCode"].ToString() == "40740706"
  455. // || drExistJudge["judgeResultCode"].ToString() == "40740707") //如果已经判定则不判。 AND T.JUDGE_RESULT_CODE IN ('40740701', '40740702')
  456. //{
  457. // MessageUtil.ShowWarning("该记录已经判定" + drExistJudge["judgeResult"].ToString() + ",不允许撤销复取样!", _zgJudgeApplyCtrl.UltraGrid1, row);
  458. // return;
  459. //}
  460. //有放行申请单的不允许判定。
  461. DataRow drPassApply = _d.GetRowByXmlId("JdgQcmBcPassApplyDAL.queryByBatchNo", row.GetValue("jugdeApplyCode"),
  462. row.GetValue("judgeStoveNo"), row.GetValue("batchNo"), processCode, "0");
  463. if (drPassApply != null)
  464. {
  465. if (drPassApply["TYPE"].ToString() == "0")
  466. {
  467. if (drPassApply["auditResult"].ToString() == "")
  468. {
  469. MessageUtil.ShowWarning("该炉号处于放行审核状态,不允许申请复取样!", _zgJudgeApplyCtrl.UltraGrid1, row);
  470. return;
  471. }
  472. if (drPassApply["auditResult"].ToString() == "407504")
  473. {
  474. MessageUtil.ShowWarning("该炉号放行处置结果为降级/改判,请操作撤销判定!", _zgJudgeApplyCtrl.UltraGrid1, row);
  475. return;
  476. }
  477. if (drPassApply["auditResult"].ToString() == "407505")
  478. {
  479. MessageUtil.ShowWarning("该炉号放行处置结果为报废,请操作撤销判定!", _zgJudgeApplyCtrl.UltraGrid1, row);
  480. return;
  481. }
  482. if (drPassApply["auditResult"].ToString() == "407506")
  483. {
  484. MessageUtil.ShowWarning("该炉号放行处置结果为返工,请操作撤销判定!", _zgJudgeApplyCtrl.UltraGrid1, row);
  485. return;
  486. }
  487. }
  488. }
  489. }
  490. if (MessageUtil.ShowYesNoAndQuestion("是否确认撤销复取样?") == System.Windows.Forms.DialogResult.No)
  491. {
  492. return;
  493. }
  494. List<string> judgeStoveNos = new List<string>();
  495. foreach (var row in chkRows)
  496. {
  497. if (judgeStoveNos.Contains(row.GetValue("judgeStoveNo"))) continue;
  498. judgeStoveNos.Add(row.GetValue("judgeStoveNo"));
  499. var ccp = _d.Set("com.steering.pss.judge.Bll.BllRolledTubeColligateJudge.deleteRepeatSpline", lotNo,
  500. judgeStoveNo, batchNo, UserInfo.GetUserName());
  501. if (ccp.ReturnInfo != "")
  502. {
  503. MessageUtil.ShowWarning(ccp.ReturnInfo);
  504. return;
  505. }
  506. }
  507. MessageUtil.ShowTips("撤销复取样成功!");
  508. Relocate(judgeApplyCode, judgeStoveNo, batchNo);
  509. }
  510. private void ApplyRepeatSpline()
  511. {
  512. var chkRows = _zgJudgeApplyCtrl.UltraGrid1.Rows.Where(a => a.GetValue("Chk") == "True");
  513. if (_zgJudgeApplyCtrl.UltraGrid1.ActiveRow == null)
  514. {
  515. MessageUtil.ShowWarning("没有需要申请复取样的记录!");
  516. return;
  517. }
  518. if (chkRows.Count() == 0)
  519. {
  520. MessageUtil.ShowWarning("请选择申请判定记录!", _zgJudgeApplyCtrl.UltraGrid1, _zgJudgeApplyCtrl.UltraGrid1.ActiveRow.Cells["Chk"]);
  521. return;
  522. }
  523. string judgeApplyCode = "";
  524. string judgeStoveNo = "";
  525. string batchNo = "";
  526. foreach (var row in chkRows)
  527. {
  528. judgeApplyCode = row.GetValue("jugdeApplyCode");
  529. judgeStoveNo = row.GetValue("judgeStoveNo");
  530. batchNo = row.GetValue("batchNo");
  531. DataRow drExistJudge = _d.GetRowByXmlId("QcmZgJugdeApplyDAL.existJudgeQualified", row.GetValue("jugdeApplyCode"),
  532. row.GetValue("judgeStoveNo"), row.GetValue("batchNo"), processCode);
  533. if (drExistJudge["judgeResultCode"].ToString() == "40740701" || drExistJudge["judgeResultCode"].ToString() == "40740706"
  534. || drExistJudge["judgeResultCode"].ToString() == "40740707") //如果已经判定则不判。 AND T.JUDGE_RESULT_CODE IN ('40740701', '40740702')
  535. {
  536. //MessageUtil.ShowWarning("该记录已经判定" + drExistJudge["judgeResult"].ToString() + ",不允许申请复取样!", _zgJudgeApplyCtrl.UltraGrid1, row);
  537. //return;
  538. }
  539. //有放行申请单的不允许判定。
  540. DataRow drPassApply = _d.GetRowByXmlId("JdgQcmBcPassApplyDAL.queryByBatchNo", row.GetValue("jugdeApplyCode"),
  541. row.GetValue("judgeStoveNo"), row.GetValue("batchNo"), processCode, "0");
  542. if (drPassApply != null)
  543. {
  544. if (drPassApply["TYPE"].ToString() == "0")
  545. {
  546. if (drPassApply["auditResult"].ToString() == "")
  547. {
  548. MessageUtil.ShowWarning("该炉号处于放行审核状态,不允许申请复取样!", _zgJudgeApplyCtrl.UltraGrid1, row);
  549. return;
  550. }
  551. if (drPassApply["auditResult"].ToString() == "407504")
  552. {
  553. MessageUtil.ShowWarning("该炉号放行处置结果为降级/改判,请操作撤销判定!", _zgJudgeApplyCtrl.UltraGrid1, row);
  554. return;
  555. }
  556. if (drPassApply["auditResult"].ToString() == "407505")
  557. {
  558. MessageUtil.ShowWarning("该炉号放行处置结果为报废,请操作撤销判定!", _zgJudgeApplyCtrl.UltraGrid1, row);
  559. return;
  560. }
  561. if (drPassApply["auditResult"].ToString() == "407506")
  562. {
  563. MessageUtil.ShowWarning("该炉号放行处置结果为返工,请操作撤销判定!", _zgJudgeApplyCtrl.UltraGrid1, row);
  564. return;
  565. }
  566. }
  567. }
  568. }
  569. if (MessageUtil.ShowYesNoAndQuestion("是否确认申请复取样?") == System.Windows.Forms.DialogResult.No)
  570. {
  571. return;
  572. }
  573. List<string> judgeStoveNos = new List<string>();
  574. foreach (var row in chkRows)
  575. {
  576. if (judgeStoveNos.Contains(row.GetValue("judgeStoveNo"))) continue;
  577. judgeStoveNos.Add(row.GetValue("judgeStoveNo"));
  578. var ccp = _d.Set("com.steering.pss.judge.Bll.BllRolledTubeColligateJudge.applyRepeatSpline", row.GetValue("jugdeApplyCode"),
  579. row.GetValue("judgeStoveNo"), row.GetValue("batchNo"), UserInfo.GetUserName());
  580. if (ccp.ReturnInfo != "")
  581. {
  582. MessageUtil.ShowWarning(ccp.ReturnInfo);
  583. return;
  584. }
  585. }
  586. MessageUtil.ShowTips("申请复取样成功!");
  587. Relocate(judgeApplyCode, judgeStoveNo, batchNo);
  588. }
  589. private void UpdateMemo()
  590. {
  591. if (_zgJudgeApplyCtrl.UltraGrid1.ActiveRow == null)
  592. {
  593. MessageUtil.ShowWarning("没有需要修改的记录!");
  594. return;
  595. }
  596. var chkRows = _zgJudgeApplyCtrl.UltraGrid1.Rows.Where(a => a.GetValue("Chk") == "True");
  597. if (chkRows.Count() == 0)
  598. {
  599. if (_zgJudgeApplyCtrl.UltraGrid1.ActiveRow == null)
  600. {
  601. MessageUtil.ShowWarning("请选择申请判定记录!", _zgJudgeApplyCtrl.UltraGrid1);
  602. }
  603. else
  604. {
  605. MessageUtil.ShowWarning("请选择申请判定记录!", _zgJudgeApplyCtrl.UltraGrid1, _zgJudgeApplyCtrl.UltraGrid1.ActiveRow.Cells["Chk"]);
  606. }
  607. return;
  608. }
  609. string judgeApplyCode = "";
  610. string judgeStoveNo = "";
  611. string batchNo = "";
  612. List<string[]> parms = new List<string[]>();
  613. foreach (var row in chkRows)
  614. {
  615. judgeApplyCode = row.GetValue("jugdeApplyCode");
  616. judgeStoveNo = row.GetValue("judgeStoveNo");
  617. batchNo = row.GetValue("batchNo");
  618. //DataRow drJudgeCnt = _d.GetRowByXmlId("JdgQcmBcJudge.queryCntByJudgeStoveNo", judgeStoveNo, batchNo, processCode);
  619. //if (drJudgeCnt[0].ToString() == "0")
  620. //{
  621. // MessageUtil.ShowWarning("该记录还没有判定不能修改备注信息!");
  622. // return;
  623. //}
  624. parms.Add(new string[] { judgeApplyCode, judgeStoveNo, batchNo, processCode, row.GetValue("memo"), row.GetValue("judgeMemo") });
  625. }
  626. if (MessageUtil.ShowYesNoAndQuestion("是否确认修改备注?") == System.Windows.Forms.DialogResult.No)
  627. {
  628. return;
  629. }
  630. var ccp = _d.Set("com.steering.pss.judge.Bll.BllRolledTubeColligateJudge.UpdateMemo", parms);
  631. if (ccp.ReturnInfo != "")
  632. {
  633. MessageUtil.ShowError(ccp.ReturnInfo);
  634. return;
  635. }
  636. else
  637. {
  638. MessageUtil.ShowTips("操作成功!");
  639. }
  640. Relocate(judgeApplyCode, judgeStoveNo, batchNo);
  641. }
  642. private void DeleteJudge()
  643. {
  644. var chkRows = _zgJudgeApplyCtrl.UltraGrid1.Rows.Where(a => a.GetValue("Chk") == "True");
  645. if (_zgJudgeApplyCtrl.UltraGrid1.ActiveRow == null)
  646. {
  647. MessageUtil.ShowWarning("没有需要撤销的记录!");
  648. return;
  649. }
  650. if (chkRows.Count() == 0)
  651. {
  652. MessageUtil.ShowWarning("请选择申请判定记录!", _zgJudgeApplyCtrl.UltraGrid1, _zgJudgeApplyCtrl.UltraGrid1.ActiveRow.Cells["Chk"]);
  653. return;
  654. }
  655. string judgeApplyCode = "";
  656. string lotNo = "";
  657. string judgeStoveNo = "";
  658. string bathcNo = "";
  659. bool deleteJudgeTiped = false;
  660. foreach (var row in chkRows)
  661. {
  662. judgeApplyCode = row.GetValue("jugdeApplyCode");
  663. lotNo = row.GetValue("lotNo");
  664. judgeStoveNo = row.GetValue("judgeStoveNo");
  665. bathcNo = row.GetValue("batchNo");
  666. ////判断是否可以撤销
  667. //DataRow zyMRow = null;
  668. //if (processCode == "D")
  669. //{
  670. // zyMRow = _d.GetRowByXmlId("JdgPlnZyZgM.queryByJudgeStoveNo", judgeStoveNo);
  671. //}
  672. //else if (processCode == "E")
  673. //{
  674. // zyMRow = _d.GetRowByXmlId("JdgPlnZyDbkM.queryByJudgeStoveNo", judgeStoveNo);
  675. //}
  676. //else if (processCode == "F")
  677. //{
  678. // zyMRow = _d.GetRowByXmlId("JdgPlnZyRclM.queryByJudgeStoveNo", judgeStoveNo);
  679. //}
  680. //else if (processCode == "G")
  681. //{
  682. // zyMRow = _d.GetRowByXmlId("JdgPlnZyJgxM.queryByJudgeStoveNo", judgeStoveNo);
  683. //}
  684. DataRow drGpApply = _d.GetRowByXmlId("QcmZgJugdeApplyDAL.QueryByBatchNo", row.GetValue("jugdeApplyCode"),
  685. row.GetValue("judgeStoveNo"), row.GetValue("batchNo"));
  686. DataRow drPassApply = _d.GetRowByXmlId("JdgQcmBcPassApplyDAL.queryByBatchNo", row.GetValue("jugdeApplyCode"),
  687. row.GetValue("judgeStoveNo"), row.GetValue("batchNo"), processCode, "0");
  688. if (drGpApply != null && drGpApply["judgeResultCode"].ToString() == "40740704"
  689. && drPassApply != null && drPassApply["TYPE"].ToString() == "0")
  690. {
  691. if (drPassApply["auditResult"].ToString() == "407502" || drPassApply["auditResult"].ToString() == "407503")
  692. {
  693. deleteJudgeTiped = true;
  694. if (MessageUtil.ShowYesNoAndQuestion("炉号" + judgeStoveNo + " 放行处置结果为让步接收,是否确认撤销判定?") == System.Windows.Forms.DialogResult.No)
  695. {
  696. return;
  697. }
  698. }
  699. }
  700. }
  701. if (deleteJudgeTiped == false)
  702. {
  703. if (MessageUtil.ShowYesNoAndQuestion("是否确认进行撤销判定?") == System.Windows.Forms.DialogResult.No)
  704. {
  705. return;
  706. }
  707. }
  708. List<string> judgeStoveNos = new List<string>();
  709. foreach (var row in chkRows)
  710. {
  711. if (judgeStoveNos.Contains(row.GetValue("judgeStoveNo"))) continue;
  712. judgeStoveNos.Add(row.GetValue("judgeStoveNo"));
  713. var ccp = _d.Set("com.steering.pss.judge.Bll.BllRolledTubeColligateJudge.deleteJudge", row.GetValue("jugdeApplyCode"),
  714. row.GetValue("judgeStoveNo"), row.GetValue("batchNo"), processCode, UserInfo.GetUserName());
  715. if (ccp.ReturnInfo != "")
  716. {
  717. MessageUtil.ShowWarning(ccp.ReturnInfo);
  718. return;
  719. }
  720. }
  721. MessageUtil.ShowTips("操作成功!");
  722. Relocate(judgeApplyCode, judgeStoveNo, bathcNo);
  723. }
  724. private void DeletePassApply()
  725. {
  726. var chkRows = _bcPassApply.UltraGrid1.Rows.Where(a => a.GetValue("Chk") == "True");
  727. if (chkRows.Count() == 0)
  728. {
  729. MessageUtil.ShowWarning("请选择一行记录");
  730. return;
  731. }
  732. List<string> passApplyNos = new List<string>();
  733. string passApplyNo = "";
  734. string passApplySeq = "";
  735. foreach (var row in chkRows)
  736. {
  737. DataRow drPassApply = _d.GetRowByXmlId("JdgQcmBcPassApplyDAL.queryByPassApplyNo", row.GetValue("passApplyNo"));
  738. if (drPassApply == null)
  739. {
  740. MessageUtil.ShowWarning("此炉号不需要删除放行申请单!");
  741. return;
  742. }
  743. DataRow drZgJudgeApply = _d.GetRowByXmlId("QcmZgJugdeApplyDAL.QueryByBatchNo", row.GetValue("jugdeApplyCode"),
  744. row.GetValue("judgeStoveNo"), row.GetValue("batchNo"));
  745. if (drZgJudgeApply != null && drPassApply["type"].ToString() == "0")
  746. {
  747. if (drZgJudgeApply["judgeResultCode"].ToString() != "40740704" && drZgJudgeApply["judgeResultCode"].ToString() != "40740708")
  748. {
  749. MessageUtil.ShowWarning("只能删除判定不合格状态的放行申请单!", _zgJudgeApplyCtrl.UltraGrid1, row);
  750. return;
  751. }
  752. if (drZgJudgeApply["auditResult"].ToString() == "407504" || drZgJudgeApply["auditResult"].ToString() == "407505"
  753. || drZgJudgeApply["auditResult"].ToString() == "407506")
  754. {
  755. MessageUtil.ShowWarning("此炉号已退回炼钢,不能删除!", _zgJudgeApplyCtrl.UltraGrid1, row);
  756. return;
  757. }
  758. }
  759. else
  760. {
  761. if (drPassApply["auditResult"].ToString() == "1")
  762. {
  763. MessageUtil.ShowWarning("此炉号已经通过紧急放行,不能删除申请放行单!");
  764. return;
  765. }
  766. }
  767. //DataRow drPassApply = _d.GetRowByXmlId("QcmGpPassApplyDAL.queryByPassApplyNo", row.GetValue("passApplyNo"));
  768. //if (drPassApply["auditResult"].ToString() == "1" && drPassApply["auditResult2"].ToString() == "")
  769. //{
  770. // MessageUtil.ShowWarning("不能删除正在审核的申请放行单!");
  771. // return;
  772. //}
  773. //else if (drPassApply["auditResult"].ToString() == "1" && drPassApply["auditResult2"].ToString() == "1")
  774. //{
  775. // MessageUtil.ShowWarning("不能删除审核通过的申请放行单!");
  776. // return;
  777. //}
  778. passApplyNos.Add(row.GetValue("PassApplyNo"));
  779. passApplyNo = row.GetValue("PassApplyNo");
  780. passApplySeq = row.GetValue("passApplySeq");
  781. }
  782. if (MessageUtil.ShowYesNoAndQuestion("是否确认删除申请放行?") == System.Windows.Forms.DialogResult.No)
  783. {
  784. return;
  785. }
  786. var ccp = _d.Set("com.steering.pss.judge.Bll.BllRolledTubePassApply.delete", passApplyNos, UserInfo.GetUserName());
  787. if (ccp.ReturnInfo != "")
  788. {
  789. MessageUtil.ShowError(ccp.ReturnInfo);
  790. return;
  791. }
  792. else
  793. {
  794. MessageUtil.ShowTips("操作成功!");
  795. }
  796. Query();
  797. var rowRelocate = _bcPassApply.UltraGrid1.Rows.Where(a => a.GetValue("PassApplyNo") == passApplyNo
  798. && a.GetValue("passApplySeq") == passApplySeq).FirstOrDefault();
  799. if (rowRelocate != null)
  800. {
  801. rowRelocate.Activate();
  802. }
  803. }
  804. private void PassApply()
  805. {
  806. if (_zgJudgeApplyCtrl.UltraGrid1.ActiveRow == null)
  807. {
  808. MessageUtil.ShowWarning("没有需要放行申请的记录!");
  809. return;
  810. }
  811. var chkRows = _zgJudgeApplyCtrl.UltraGrid1.Rows.Where(a => a.GetValue("Chk") == "True");
  812. if (chkRows.Count() == 0)
  813. {
  814. if (_zgJudgeApplyCtrl.UltraGrid1.ActiveRow == null)
  815. {
  816. MessageUtil.ShowWarning("请选择申请判定记录!", _zgJudgeApplyCtrl.UltraGrid1);
  817. }
  818. else
  819. {
  820. MessageUtil.ShowWarning("请选择申请判定记录!", _zgJudgeApplyCtrl.UltraGrid1, _zgJudgeApplyCtrl.UltraGrid1.ActiveRow.Cells["Chk"]);
  821. }
  822. return;
  823. }
  824. List<string[]> parms = new List<string[]>();
  825. string judgeApplyCode = "";
  826. string judgeStoveNo = "";
  827. string batchNo = "";
  828. string passType = passInfo == "Quality" ? "0" : "1";
  829. foreach (var row in chkRows)
  830. {
  831. judgeApplyCode = row.GetValue("jugdeApplyCode");
  832. judgeStoveNo = row.GetValue("judgeStoveNo");
  833. batchNo = row.GetValue("batchNo");
  834. DataRow drZgJudgeApply = _d.GetRowByXmlId("QcmZgJugdeApplyDAL.QueryByBatchNo", row.GetValue("jugdeApplyCode"),
  835. row.GetValue("judgeStoveNo"), row.GetValue("batchNo"));
  836. if (passInfo == "Quality")
  837. {
  838. if (drZgJudgeApply["judgeResultCode"].ToString() != "40740704" && drZgJudgeApply["judgeResultCode"].ToString() != "40740707"
  839. && drZgJudgeApply["judgeResultCode"].ToString() != "40740708")
  840. {
  841. MessageUtil.ShowWarning("只有判定不合格的记录,才能申请质量放行!", _zgJudgeApplyCtrl.UltraGrid1, row);
  842. return;
  843. }
  844. }
  845. else if (passInfo == "Urgent")
  846. {
  847. if (drZgJudgeApply["judgeResultCode"].ToString() != "")
  848. {
  849. MessageUtil.ShowWarning("只有未判定的记录,才能申请紧急放行!", _zgJudgeApplyCtrl.UltraGrid1, row);
  850. return;
  851. }
  852. }
  853. DataRow drPassApply = _d.GetRowByXmlId("JdgQcmBcPassApplyDAL.queryByBatchNo", row.GetValue("jugdeApplyCode"),
  854. row.GetValue("judgeStoveNo"), row.GetValue("batchNo"), processCode, passType);
  855. if (drPassApply != null)
  856. {
  857. MessageUtil.ShowWarning("该记录已生成放行申请单,不能重复生成!", _zgJudgeApplyCtrl.UltraGrid1, row);
  858. return;
  859. }
  860. string[] parm = new string[] { judgeApplyCode, judgeStoveNo, batchNo };
  861. parms.Add(parm);
  862. }
  863. PopupSubmit popupSubmit = new PopupSubmit("是否确认放行申请?", true, "请输入放行申请原因!");
  864. if (popupSubmit.ShowDialog() != System.Windows.Forms.DialogResult.Yes)
  865. {
  866. return;
  867. }
  868. var ccp = _d.Set("com.steering.pss.judge.Bll.BllRolledTubeColligateJudge.passApply", parms, processCode,
  869. UserInfo.GetUserName(), UserInfo.GetDeptid(), UserInfo.GetDepartment(), popupSubmit.TxtAudit.Text.Trim(), passType);
  870. if (ccp.ReturnInfo != "")
  871. {
  872. MessageUtil.ShowError(ccp.ReturnInfo);
  873. return;
  874. }
  875. else
  876. {
  877. MessageUtil.ShowTips("操作成功!");
  878. }
  879. Relocate(judgeApplyCode, judgeStoveNo, batchNo);
  880. }
  881. private void Judge(string judgeFlag)
  882. {
  883. var chkRows = _zgJudgeApplyCtrl.UltraGrid1.Rows.Where(a => a.GetValue("Chk") == "True");
  884. if (_zgJudgeApplyCtrl.UltraGrid1.ActiveRow == null)
  885. {
  886. MessageUtil.ShowWarning("没有需要判定的记录!");
  887. return;
  888. }
  889. if (chkRows.Count() == 0)
  890. {
  891. MessageUtil.ShowWarning("请选择申请判定记录!", _zgJudgeApplyCtrl.UltraGrid1, _zgJudgeApplyCtrl.UltraGrid1.ActiveRow.Cells["Chk"]);
  892. return;
  893. }
  894. string judgeApplyCode = "";
  895. string judgeStoveNo = "";
  896. string batchNo = "";
  897. bool asked = false;
  898. foreach (var row in chkRows)
  899. {
  900. judgeApplyCode = row.GetValue("jugdeApplyCode");
  901. judgeStoveNo = row.GetValue("judgeStoveNo");
  902. batchNo = row.GetValue("batchNo");
  903. //var ccp = _d.Set("com.steering.pss.judge.Bll.BllDbkSpecJudge.judge", judgeApplyCode, judgeStoveNo, batchNo);
  904. //if (ccp.ReturnInfo != "")
  905. //{
  906. // MessageUtil.ShowWarning(ccp.ReturnInfo);
  907. // return;
  908. //}
  909. DataRow drExistJudge = _d.GetRowByXmlId("QcmZgJugdeApplyDAL.existJudgeQualified", row.GetValue("jugdeApplyCode"),
  910. row.GetValue("judgeStoveNo"), row.GetValue("batchNo"), processCode);
  911. if (drExistJudge["judgeResultCode"].ToString() == "40740701" || drExistJudge["judgeResultCode"].ToString() == "40740706"
  912. || drExistJudge["judgeResultCode"].ToString() == "40740707") //如果已经判定则不判。 AND T.JUDGE_RESULT_CODE IN ('40740701', '40740702')
  913. {
  914. MessageUtil.ShowWarning("该记录已经" + drExistJudge["judgeResult"].ToString() + ",不允许重复判定!", _zgJudgeApplyCtrl.UltraGrid1, row);
  915. return;
  916. }
  917. CoreClientParam ccpDetect = _d.Set("com.steering.pss.judge.Bll.BllRolledTubeColligateJudge.checkDetect", row.GetValue("jugdeApplyCode"),
  918. row.GetValue("judgeStoveNo"), row.GetValue("batchNo"));
  919. if (ccpDetect.ReturnInfo.ToString2() != "")
  920. {
  921. MessageUtil.ShowWarning(ccpDetect.ReturnInfo.ToString2());
  922. return;
  923. }
  924. else
  925. {
  926. if (ccpDetect.ReturnObject.ToString2() != "")
  927. {
  928. if (MessageUtil.ShowYesNoAndQuestion(ccpDetect.ReturnObject.ToString2() + "\r\n是否继续判定?") == System.Windows.Forms.DialogResult.No)
  929. {
  930. return;
  931. }
  932. asked = true;
  933. }
  934. }
  935. //验证是否复取样,如果复取样则不自动判定
  936. //CoreClientParam checkFsample = _d.Set("com.steering.pss.judge.Bll.BllRolledTubeColligateJudge.checkFsample", row.GetValue("jugdeApplyCode"),
  937. //row.GetValue("judgeStoveNo"), row.GetValue("batchNo"), processCode);
  938. //if (checkFsample.ReturnInfo.ToString2() != "")
  939. //{
  940. // MessageUtil.ShowWarning(checkFsample.ReturnInfo.ToString2());
  941. // return;
  942. //}
  943. //else
  944. //{
  945. // if (checkFsample.ReturnObject.ToString2() != "")
  946. // {
  947. // if (MessageUtil.ShowYesNoAndQuestion(checkFsample.ReturnObject.ToString2() + "\r\n是否继续判定?") == System.Windows.Forms.DialogResult.No)
  948. // {
  949. // return;
  950. // }
  951. // asked = true;
  952. // }
  953. //}
  954. //验证是否符合取样数量
  955. CoreClientParam ccp = new CoreClientParam();
  956. ccp.ServerName = "com.steering.pss.judge.Bll.BllRolledTubeColligateJudge";
  957. ccp.MethodName = "checkSampleCount";
  958. ccp.ServerParams = new object[] { row.GetValue("jugdeApplyCode"), row.GetValue("judgeStoveNo"),
  959. row.GetValue("batchNo"), "0"};
  960. ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
  961. CoreClientParam ccpFd = new CoreClientParam();
  962. ccpFd.ServerName = "com.steering.pss.judge.Bll.BllRolledTubeColligateJudge";
  963. ccpFd.MethodName = "checkSampleCount";
  964. ccpFd.ServerParams = new object[] { row.GetValue("jugdeApplyCode"), row.GetValue("judgeStoveNo"),
  965. row.GetValue("batchNo"), "1"};
  966. ccpFd = ob.ExecuteNonQuery(ccpFd, CoreInvokeType.Internal);
  967. if (ccp.ReturnObject.ToString2() != "")
  968. {
  969. if (MessageUtil.ShowYesNoAndQuestion(ccp.ReturnObject.ToString2() + "\r\n是否继续判定?") == System.Windows.Forms.DialogResult.No)
  970. {
  971. return;
  972. }
  973. }
  974. else if (processCode == "F" && ccpFd.ReturnObject.ToString2() != "")
  975. {
  976. if (MessageUtil.ShowYesNoAndQuestion(ccpFd.ReturnObject.ToString2() + "\r\n是否继续判定?") == System.Windows.Forms.DialogResult.No)
  977. {
  978. return;
  979. }
  980. }
  981. else if (ccp.ReturnInfo.ToString2() != "")
  982. {
  983. MessageUtil.ShowError(ccp.ReturnInfo);
  984. return;
  985. }
  986. }
  987. if (!asked)
  988. {
  989. if (MessageUtil.ShowYesNoAndQuestion("是否确认进行判定?") == System.Windows.Forms.DialogResult.No)
  990. {
  991. return;
  992. }
  993. }
  994. List<string> judgeStoveNos = new List<string>();
  995. foreach (var row in chkRows)
  996. {
  997. if (judgeStoveNos.Contains(row.GetValue("judgeStoveNo"))) continue;
  998. judgeStoveNos.Add(row.GetValue("judgeStoveNo"));
  999. //人工修改利库炉号判定结果
  1000. List<string> checkDetailJsons = GetCheckDetailsJsons(_zcAllChemPhyCtrl);
  1001. CoreClientParam ccp = _d.Set("com.steering.pss.judge.Bll.BllRolledTubeColligateJudge.judge", row.GetValue("jugdeApplyCode"),
  1002. row.GetValue("judgeStoveNo"), row.GetValue("batchNo"), processCode, UserInfo.GetUserName(), UserInfo.GetUserOrderText(),
  1003. UserInfo.GetUserGroupText(), row.GetValue("memo"), row.GetValue("judgeMemo"), judgeFlag, checkDetailJsons);
  1004. if (ccp.ReturnInfo != "")
  1005. {
  1006. MessageUtil.ShowWarning(ccp.ReturnInfo);
  1007. return;
  1008. }
  1009. }
  1010. MessageUtil.ShowTips("判定成功!");
  1011. Relocate(judgeApplyCode, judgeStoveNo, batchNo);
  1012. }
  1013. private void refreshStatus(String isShowTips)
  1014. {
  1015. var chkRows = _zgJudgeApplyCtrl.UltraGrid1.Rows.Where(a => a.GetValue("Chk") == "True");
  1016. if (_zgJudgeApplyCtrl.UltraGrid1.ActiveRow == null)
  1017. {
  1018. MessageUtil.ShowWarning("没有需要刷新的记录!");
  1019. return;
  1020. }
  1021. if (chkRows.Count() == 0)
  1022. {
  1023. MessageUtil.ShowWarning("请选择需要刷新的记录!", _zgJudgeApplyCtrl.UltraGrid1, _zgJudgeApplyCtrl.UltraGrid1.ActiveRow.Cells["Chk"]);
  1024. return;
  1025. }
  1026. List<string> judgeStoveNos = new List<string>();
  1027. foreach (var row in chkRows)
  1028. {
  1029. if (judgeStoveNos.Contains(row.GetValue("judgeStoveNo"))) continue;
  1030. judgeStoveNos.Add(row.GetValue("judgeStoveNo"));
  1031. CoreClientParam ccp = _d.Set("com.steering.pss.judge.Bll.BllRolledTubeColligateJudge.refreshStatus", row.GetValue("jugdeApplyCode"),
  1032. row.GetValue("judgeStoveNo"), row.GetValue("batchNo"), UserInfo.GetUserName());
  1033. if (ccp.ReturnInfo != "")
  1034. {
  1035. MessageUtil.ShowWarning(ccp.ReturnInfo);
  1036. return;
  1037. }
  1038. }
  1039. if (isShowTips.Equals("1"))
  1040. {
  1041. MessageUtil.ShowTips("刷新成功!");
  1042. }
  1043. }
  1044. public static List<string> GetCheckDetailsJsons(QcmZcAllChemPhyCtrl zcAllChemPhyCtrl)
  1045. {
  1046. //人工修改利库炉号判定结果
  1047. List<string> checkDetailJsons = new List<string>();
  1048. foreach(DataRow checkRow in zcAllChemPhyCtrl.ZgChemPhyLgCtrl.JhyPhySplineCtrl.DataTable1.Rows)
  1049. {
  1050. if (checkRow["chk"].ToString() == "True")
  1051. {
  1052. checkDetailJsons.Add(JsonHelper.ToJson(checkRow));
  1053. }
  1054. }
  1055. foreach (DataRow checkRow in zcAllChemPhyCtrl.ZgChemPhyZgCtrl.JhyPhySplineCtrl.DataTable1.Rows)
  1056. {
  1057. if (checkRow["chk"].ToString() == "True")
  1058. {
  1059. checkDetailJsons.Add(JsonHelper.ToJson(checkRow));
  1060. }
  1061. }
  1062. foreach (DataRow checkRow in zcAllChemPhyCtrl.ZgChemPhyDbkCtrl.JhyPhySplineCtrl.DataTable1.Rows)
  1063. {
  1064. if (checkRow["chk"].ToString() == "True")
  1065. {
  1066. checkDetailJsons.Add(JsonHelper.ToJson(checkRow));
  1067. }
  1068. }
  1069. foreach (DataRow checkRow in zcAllChemPhyCtrl.ZgChemPhyRclCtrl.JhyPhySplineCtrl.DataTable1.Rows)
  1070. {
  1071. if (checkRow["chk"].ToString() == "True")
  1072. {
  1073. checkDetailJsons.Add(JsonHelper.ToJson(checkRow));
  1074. }
  1075. }
  1076. foreach (DataRow checkRow in zcAllChemPhyCtrl.ZgChemPhyJgxCtrl.JhyPhySplineCtrl.DataTable1.Rows)
  1077. {
  1078. if (checkRow["chk"].ToString() == "True")
  1079. {
  1080. checkDetailJsons.Add(JsonHelper.ToJson(checkRow));
  1081. }
  1082. }
  1083. foreach (DataRow checkRow in zcAllChemPhyCtrl.ZgChemPhyJgCtrl.JhyPhySplineCtrl.DataTable1.Rows)
  1084. {
  1085. if (checkRow["chk"].ToString() == "True")
  1086. {
  1087. checkDetailJsons.Add(JsonHelper.ToJson(checkRow));
  1088. }
  1089. }
  1090. return checkDetailJsons;
  1091. }
  1092. private void RefreshZbs()
  1093. {
  1094. WaitingForm2 wf = new WaitingForm2("正在刷新,请稍后....");
  1095. try
  1096. {
  1097. var chkRows = _zgJudgeApplyCtrl.UltraGrid1.Rows.Where(a => a.GetValue("Chk") == "True");
  1098. if (chkRows.Count() == 0)
  1099. {
  1100. MessageUtil.ShowWarning("请选择申请判定记录!", _zgJudgeApplyCtrl.UltraGrid1, _zgJudgeApplyCtrl.UltraGrid1.ActiveRow.Cells["Chk"]);
  1101. return;
  1102. }
  1103. string zbsFlag = "";//空表示不修改质保书打印方式
  1104. foreach (var row in chkRows)
  1105. {
  1106. string judgeApplyCode = row.GetValue("jugdeApplyCode");
  1107. string judgeStoveNo = row.GetValue("judgeStoveNo");
  1108. string batchNo = row.GetValue("batchNo");
  1109. CoreClientParam ccp = _d.Set("com.steering.pss.judge.Bll.BllCreateZbsInfo.Create", judgeApplyCode, judgeStoveNo, batchNo, zbsFlag);
  1110. if (ccp.ReturnInfo.ToString2() != "")
  1111. {
  1112. MessageUtil.ShowWarning("炉号:" + judgeStoveNo + "批号:" + batchNo + " " + ccp.ReturnInfo);
  1113. return;
  1114. }
  1115. }
  1116. }
  1117. finally
  1118. {
  1119. wf.Close();
  1120. }
  1121. MessageUtil.ShowTips("刷新成功!");
  1122. }
  1123. private void ReviewGpCertificate()
  1124. {
  1125. try
  1126. {
  1127. this.Cursor = Cursors.WaitCursor;
  1128. var row = _zgJudgeApplyCtrl.UltraGrid1.ActiveRow;
  1129. if (row == null)
  1130. {
  1131. MessageUtil.ShowWarning("请选择一行记录!");
  1132. return;
  1133. }
  1134. string judgeApplyCode = row.Cells["jugdeApplyCode"].Value.ToString();
  1135. string judgeStoveNo = row.Cells["judgeStoveNo"].Value.ToString();
  1136. string batchNo = row.Cells["batchNo"].Value.ToString();
  1137. DataRow drZgApply = _d.GetRowByXmlId("QcmZgJugdeApplyDAL.QueryByBatchNo", row.GetValue("jugdeApplyCode"),
  1138. row.GetValue("judgeStoveNo"), row.GetValue("batchNo"));
  1139. string craftSource = "0";
  1140. string lgJudgeStoveNo = drZgApply["loadJudgeStoveNo"].ToString();
  1141. DataRow drLgJudge = _d.GetRowByXmlId("QcmLgJudgeDAL.queryByJudgeStoveNo", lgJudgeStoveNo, "B");
  1142. if (drLgJudge == null)
  1143. {
  1144. DataRow drGpChange = _d.GetRowByXmlId("JdgQcmGpJudgeChange.getJudgeStoveNo", lgJudgeStoveNo, "B");
  1145. if (drGpChange != null)
  1146. {
  1147. lgJudgeStoveNo = drGpChange["judgeStoveNo"].ToString();
  1148. }
  1149. }
  1150. //Dictionary<string, DataRow> tmpApplyDic = QcmZcAllChemPhyCtrl.GetAllJudgeApply(row.GetValue("jugdeApplyCode"), row.GetValue("judgeStoveNo"), row.GetValue("batchNo"),
  1151. // row.GetValue("processCode"),row.GetValue("heatPlanNo"),row.GetValue("processCode"), null, null, _d);
  1152. //String batchNop = "";
  1153. //if (tmpApplyDic.Keys.Contains("G"))
  1154. //{
  1155. // batchNop = tmpApplyDic["G"]["batchNo"].ToString();
  1156. //}
  1157. //else if (tmpApplyDic.Keys.Contains("F"))
  1158. //{
  1159. // batchNop = tmpApplyDic["F"]["batchNo"].ToString();
  1160. //}
  1161. //else if (tmpApplyDic.Keys.Contains("E"))
  1162. //{
  1163. // batchNop = tmpApplyDic["E"]["batchNo"].ToString();
  1164. //}
  1165. //else if (tmpApplyDic.Keys.Contains("D"))
  1166. //{
  1167. // batchNop = tmpApplyDic["D"]["batchNo"].ToString();
  1168. //}
  1169. //else if (tmpApplyDic.Keys.Contains("A"))
  1170. //{
  1171. // batchNop = tmpApplyDic["A"]["batchNo"].ToString();
  1172. //}
  1173. //+ "&BATCH_NO_P=" + batchNop
  1174. string strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepCertificateZG.cpt&op=view&bypagesize=false" + "&JUGDE_APPLY_CODE="
  1175. + judgeApplyCode + "&JUDGE_STOVE_NO=" + judgeStoveNo + "&BATCH_NO=" + batchNo + "&PROCESS_CODE=" + processCode + "&CRAFT_SOURCE=" + craftSource
  1176. + "&LG_JUDGE_STOVE_NO=" + lgJudgeStoveNo ;
  1177. FrmOrderRepExcel fBug = new FrmOrderRepExcel(ob, strurl);
  1178. fBug.AutoSize = true;
  1179. fBug.MaximumSize = new Size(Screen.PrimaryScreen.WorkingArea.Width, Screen.PrimaryScreen.WorkingArea.Height);
  1180. fBug.WindowState = FormWindowState.Maximized;
  1181. fBug.Text = "管材判定书";
  1182. fBug.Show();
  1183. }
  1184. finally
  1185. {
  1186. this.Cursor = Cursors.Default;
  1187. }
  1188. }
  1189. private void Relocate(string judgeApplyCode, string judgeStoveNo, string batchNo)
  1190. {
  1191. if (_gpApplyQuery)
  1192. {
  1193. Query();
  1194. var rowJudgeApply = _zgJudgeApplyCtrl.UltraGrid1.Rows.Where(a => a.GetValue("jugdeApplyCode") == judgeApplyCode
  1195. && a.GetValue("judgeStoveNo") == judgeStoveNo && a.GetValue("batchNo") == batchNo).FirstOrDefault();
  1196. if (rowJudgeApply != null)
  1197. {
  1198. rowJudgeApply.Activate();
  1199. }
  1200. }
  1201. else
  1202. {
  1203. //ultraTextEditor2_EditorButtonClick(null, null);
  1204. //var rowSteelMaking = _meltingStoveNoCtrl.UltraGrid1.Rows.Where(a => a.GetValue("stoveNo") == stoveNo).FirstOrDefault();
  1205. //if (rowSteelMaking != null)
  1206. //{
  1207. // rowSteelMaking.Activate();
  1208. //}
  1209. }
  1210. }
  1211. private bool _gpApplyQuery = true;
  1212. private void Query()
  1213. {
  1214. try
  1215. {
  1216. //测试生成组炉委托
  1217. //_d.Set("com.steering.pss.judge.Bll.BllCreateGroupStoveInfo.Create", "F", "C0232019070135", "790739", "23001", "C02380140120190709000003");
  1218. //测试生成利库委托
  1219. //_d.Set("com.steering.pss.judge.Bll.BllCreateGroupStoveInfo.Create", "F", "C0542018120490", "888302", "54001", "RCL20180700669",
  1220. // "3", "RCL20180700669004", "");
  1221. this.Cursor = Cursors.WaitCursor;
  1222. string timeType = ultraComboEditor3.Value.ToString2();
  1223. string timeB = labelDateTimePicker1.Checked ? labelDateTimePicker1.Value.ToString("yyyy-MM-dd HH:mm:ss") : "";
  1224. string timeE = labelDateTimePicker1.Checked ? labelDateTimePicker2.Value.ToString("yyyy-MM-dd HH:mm:ss") : "";
  1225. string[] judgeStates;
  1226. if (labelComboBox2.ComboBox.Value == null || !labelComboBox2.Checked)
  1227. {
  1228. judgeStates = new string[0];
  1229. }
  1230. else
  1231. {
  1232. judgeStates = ((List<object>)labelComboBox2.ComboBox.Value).Select(a => a.ToString()).ToArray();
  1233. }
  1234. string judgeCondition = labelComboBox1.Checked ? labelComboBox1.ComboBox.Value.ToString2() : "";
  1235. string stoveNo = labelTextBox1.Checked ? labelTextBox1.Text.Trim() : "";
  1236. string judgeStoveNo = labelTextBox4.Checked ? labelTextBox4.Text.Trim() : "";
  1237. string lotNo = labelTextBox1.Checked ? labelTextBox1.Text.Trim() : "";
  1238. string orderMngNo = labelTextBox10.Checked ? labelTextBox10.Text.Trim() : "";
  1239. string[] plines = ultraTextEditor1.Tag.ToString2().Split(',');
  1240. switch (ultraTabControl2.SelectedTab.Text)
  1241. {
  1242. case "综合判定":
  1243. _gpApplyQuery = true;
  1244. _zcAllChemPhyCtrl.ClearChemPhyData();
  1245. _zgJudgeApplyCtrl.Clear();
  1246. if (passInfo == "Quality")
  1247. {
  1248. _zgJudgeApplyCtrl.QueryBcQuality(lotNo, judgeStoveNo, judgeStates, timeB, timeE, plines,
  1249. processCode, judgeCondition, orderMngNo, timeType);
  1250. }
  1251. else if (passInfo == "Urgent")
  1252. {
  1253. string uTimeType = ultraComboEditor4.Value.ToString2();
  1254. string uTimeB = labelDateTimePicker8.Checked ? labelDateTimePicker8.Value.ToString("yyyy-MM-dd HH:mm:ss") : "";
  1255. string uTimeE = labelDateTimePicker8.Checked ? labelDateTimePicker7.Value.ToString("yyyy-MM-dd HH:mm:ss") : "";
  1256. string uJudgeState = labelComboBox9.Checked ? labelComboBox9.ComboBox.Value.ToString2() : "";
  1257. string uJudgeCondition = labelComboBox10.Checked ? labelComboBox10.ComboBox.Value.ToString2() : "";
  1258. string uJudgeStoveNo = labelTextBox2.Checked ? labelTextBox2.Text.Trim() : "";
  1259. string uLotNo = labelTextBox8.Checked ? labelTextBox8.Text.Trim() : "";
  1260. string[] uPlines = ultraTextEditor3.Tag.ToString2().Split(',');
  1261. string uOrderMngNo = labelTextBox9.Checked ? labelTextBox9.Text.Trim() : "";
  1262. string uOrderNo = "";
  1263. string uOrderSeq = "";
  1264. if (uOrderMngNo.Contains("/"))
  1265. {
  1266. uOrderNo = uOrderMngNo.Split('/')[0].Trim();
  1267. uOrderSeq = uOrderMngNo.Split('/')[1].Trim();
  1268. }
  1269. else
  1270. {
  1271. uOrderNo = uOrderMngNo;
  1272. }
  1273. _zgJudgeApplyCtrl.QueryBcUrgent(uLotNo, uJudgeStoveNo, uJudgeState, uTimeB, uTimeE, uPlines,
  1274. processCode, uJudgeCondition, uOrderNo, uOrderSeq, uTimeType);
  1275. }
  1276. else
  1277. {
  1278. _zgJudgeApplyCtrl.QueryBcColligate(lotNo, judgeStoveNo, judgeStates, timeType, timeB, timeE, plines,
  1279. judgeCondition, orderMngNo);
  1280. }
  1281. break;
  1282. case "判定记录":
  1283. string batchNo2 = labelTextBox3.Checked ? labelTextBox3.Text.Trim() : "";
  1284. string judgeStoveNo2 = labelTextBox7.Checked ? labelTextBox7.Text.Trim() : "";
  1285. string judgeResult2 = labelComboBox3.Checked ? labelComboBox3.SelecteValue.ToString2() : "";
  1286. string timeBegin = labelDateTimePicker4.Checked ? labelDateTimePicker4.DateTimePicker.Value.ToString("yyyy-MM-dd HH:mm:ss") : "";
  1287. string timeEnd = labelDateTimePicker3.Checked ? labelDateTimePicker3.DateTimePicker.Value.ToString("yyyy-MM-dd HH:mm:ss") : "";
  1288. string[] plines2 = ultraTextEditor4.Tag.ToString2().Split(',');
  1289. orderMngNo = labelTextBox11.Checked ? labelTextBox11.Text.Trim() : "";
  1290. _bcJudgeCtrl.Query(batchNo2, judgeStoveNo2, judgeResult2, timeBegin, timeEnd, plines2, orderMngNo);
  1291. break;
  1292. case "不合格评审记录":
  1293. string batchNo3 = labelTextBox5.Checked ? labelTextBox5.Text.Trim() : "";
  1294. string judgeStoveNo3 = labelTextBox6.Checked ? labelTextBox6.Text.Trim() : "";
  1295. string timeB3 = labelDateTimePicker6.Checked ? labelDateTimePicker6.Value.ToString("yyyy-MM-dd HH:mm:ss") : "";
  1296. string timeE3 = labelDateTimePicker6.Checked ? labelDateTimePicker5.Value.ToString("yyyy-MM-dd HH:mm:ss") : "";
  1297. string validflag = labelCheckBox1.Checked ? "0" : "1";
  1298. //_zgJudgeApplyDtlCtrl2.Clear();
  1299. _bcPassFlowCtrl.Clear();
  1300. _bcPassApply.AllQuery(judgeStoveNo3, batchNo3, timeB3, timeE3, passInfo, validflag, processCode);
  1301. break;
  1302. }
  1303. }
  1304. finally
  1305. {
  1306. this.Cursor = Cursors.Default;
  1307. }
  1308. }
  1309. void steelMakingCtrl_AfterRowActivate(object sender, EventArgs e)
  1310. {
  1311. //try
  1312. //{
  1313. // this.Cursor = Cursors.WaitCursor;
  1314. // _jhyElementsCtrl.ClearData();
  1315. // _jhyPhyDbResultCtrl.ClearData();
  1316. // _gpJudgeApplyDtlCtrl.Clear();
  1317. // _faceFileCtrl.ClearData();
  1318. // var row = _meltingStoveNoCtrl.UltraGrid1.ActiveRow;
  1319. // _zgJudgeApplyCtrl.qu.QuerySteelMakingP(row.GetValue("StoveNo"));
  1320. //}
  1321. //finally
  1322. //{
  1323. // this.Cursor = Cursors.Default;
  1324. //}
  1325. }
  1326. void gpJudgeApplyCtrl_AfterRowActivate(object sender, EventArgs e)
  1327. {
  1328. try
  1329. {
  1330. this.Cursor = Cursors.WaitCursor;
  1331. _zcAllChemPhyCtrl.UltraTabControl2_SelectedTabChanged(null, null);
  1332. }
  1333. finally
  1334. {
  1335. this.Cursor = Cursors.Default;
  1336. }
  1337. }
  1338. public DataTable GetCraftCic(UltraGridRow zgJudgeApplyRow)
  1339. {
  1340. DataRow drZgJudgeApply = _d.GetRowByXmlId("QcmZgJugdeApplyDAL.QueryByBatchNo", zgJudgeApplyRow.GetValue("jugdeApplyCode"),
  1341. zgJudgeApplyRow.GetValue("judgeStoveNo"), zgJudgeApplyRow.GetValue("batchNo"));
  1342. string[] zgProPlanIds = new string[1];
  1343. zgProPlanIds[0] = drZgJudgeApply["proOrderId"].ToString() + drZgJudgeApply["gxPlanNo"].ToString();
  1344. DataTable dtCraftCic = null;
  1345. string judgeStoveNo = zgJudgeApplyRow.GetValue("judgeStoveNo");
  1346. if (zgProPlanIds[0].StartsWith("ZG"))
  1347. {
  1348. dtCraftCic = _d.GetTableByXmlId("JdgPlnOrderZgS.queryZgCraftCicByZgProPlanId", new object[] { zgProPlanIds, judgeStoveNo });
  1349. }
  1350. else if (zgProPlanIds[0].StartsWith("DBK"))
  1351. {
  1352. dtCraftCic = _d.GetTableByXmlId("JdgPlnOrderDbkS.queryCraftCicByProPlanId", new object[] { zgProPlanIds, judgeStoveNo });
  1353. }
  1354. else if (zgProPlanIds[0].StartsWith("RCL"))
  1355. {
  1356. dtCraftCic = _d.GetTableByXmlId("JdgPlnOrderRclS.queryCraftCicByProPlanId", new object[] { zgProPlanIds, judgeStoveNo });
  1357. }
  1358. else
  1359. {
  1360. dtCraftCic = _d.GetTableByXmlId("JdgPlnOrderJgxS.queryCraftCicByProPlanId", new object[] { zgProPlanIds, judgeStoveNo });
  1361. }
  1362. return dtCraftCic;
  1363. }
  1364. public DataTable GetCraftPic(UltraGridRow zgJudgeApplyRow)
  1365. {
  1366. DataRow drZgJudgeApply = _d.GetRowByXmlId("QcmZgJugdeApplyDAL.QueryByBatchNo", zgJudgeApplyRow.GetValue("jugdeApplyCode"),
  1367. zgJudgeApplyRow.GetValue("judgeStoveNo"), zgJudgeApplyRow.GetValue("batchNo"));
  1368. string[] zgProPlanIds = new string[1];
  1369. zgProPlanIds[0] = drZgJudgeApply["proOrderId"].ToString() + drZgJudgeApply["gxPlanNo"].ToString();
  1370. DataTable dtCraftCic = null;
  1371. string judgeStoveNo = drZgJudgeApply["judgeStoveNo"].ToString();
  1372. if (zgProPlanIds[0].StartsWith("ZG"))
  1373. {
  1374. dtCraftCic = _d.GetTableByXmlId("JdgPlnOrderZgS.queryZgCraftPicByZgProPlanId", new object[] { zgProPlanIds, judgeStoveNo });
  1375. }
  1376. else if (zgProPlanIds[0].StartsWith("DBK"))
  1377. {
  1378. dtCraftCic = _d.GetTableByXmlId("JdgPlnOrderDbkS.queryCraftPicByProPlanId", new object[] { zgProPlanIds, judgeStoveNo });
  1379. }
  1380. else if (zgProPlanIds[0].StartsWith("RCL"))
  1381. {
  1382. dtCraftCic = _d.GetTableByXmlId("JdgPlnOrderRclS.queryCraftPicByProPlanId", new object[] { zgProPlanIds, judgeStoveNo });
  1383. }
  1384. else
  1385. {
  1386. dtCraftCic = _d.GetTableByXmlId("JdgPlnOrderJgxS.queryCraftPicByProPlanId", new object[] { zgProPlanIds, judgeStoveNo });
  1387. }
  1388. return dtCraftCic;
  1389. }
  1390. private void labelDateTimePicker4_CheckBox_CheckedChanged(object sender, EventArgs e)
  1391. {
  1392. labelDateTimePicker3.DateTimePicker.Enabled = labelDateTimePicker4.Checked;
  1393. }
  1394. private void ultraTabControl2_SelectedTabChanged(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e)
  1395. {
  1396. if (toolMenu == null || toolMenu.Toolbars.Count == 0) return;
  1397. switch (ultraTabControl2.ActiveTab.Key)
  1398. {
  1399. case "Judge":
  1400. if (this.toolMenu.Toolbars[0].Tools.Exists("Judge")) this.toolMenu.Toolbars[0].Tools["Judge"].SharedProps.Visible = true;
  1401. if (this.toolMenu.Toolbars[0].Tools.Exists("PassApply")) this.toolMenu.Toolbars[0].Tools["PassApply"].SharedProps.Visible = true;
  1402. if (this.toolMenu.Toolbars[0].Tools.Exists("UrgentPassApply")) this.toolMenu.Toolbars[0].Tools["UrgentPassApply"].SharedProps.Visible = true;
  1403. if (this.toolMenu.Toolbars[0].Tools.Exists("DeletePassApply")) this.toolMenu.Toolbars[0].Tools["DeletePassApply"].SharedProps.Visible = false;
  1404. if (this.toolMenu.Toolbars[0].Tools.Exists("DeleteJudge")) this.toolMenu.Toolbars[0].Tools["DeleteJudge"].SharedProps.Visible = true;
  1405. if (this.toolMenu.Toolbars[0].Tools.Exists("UpdateMemo")) this.toolMenu.Toolbars[0].Tools["UpdateMemo"].SharedProps.Visible = true;
  1406. if (this.toolMenu.Toolbars[0].Tools.Exists("Export")) this.toolMenu.Toolbars[0].Tools["Export"].SharedProps.Visible = true;
  1407. if (this.toolMenu.Toolbars[0].Tools.Exists("FoldQuery")) this.toolMenu.Toolbars[0].Tools["FoldQuery"].SharedProps.Visible = true;
  1408. if (this.toolMenu.Toolbars[0].Tools.Exists("GapJudge")) this.toolMenu.Toolbars[0].Tools["GapJudge"].SharedProps.Visible = true;
  1409. if (this.toolMenu.Toolbars[0].Tools.Exists("RefreshGroup")) this.toolMenu.Toolbars[0].Tools["RefreshGroup"].SharedProps.Visible = true;
  1410. if (this.toolMenu.Toolbars[0].Tools.Exists("RefreshZbs")) this.toolMenu.Toolbars[0].Tools["RefreshZbs"].SharedProps.Visible = true;
  1411. if (this.toolMenu.Toolbars[0].Tools.Exists("ReviewGpCertificate")) this.toolMenu.Toolbars[0].Tools["ReviewGpCertificate"].SharedProps.Visible = true;
  1412. break;
  1413. case "JudgeRecord":
  1414. if (this.toolMenu.Toolbars[0].Tools.Exists("Judge")) this.toolMenu.Toolbars[0].Tools["Judge"].SharedProps.Visible = false;
  1415. if (this.toolMenu.Toolbars[0].Tools.Exists("PassApply")) this.toolMenu.Toolbars[0].Tools["PassApply"].SharedProps.Visible = false;
  1416. if (this.toolMenu.Toolbars[0].Tools.Exists("UrgentPassApply")) this.toolMenu.Toolbars[0].Tools["UrgentPassApply"].SharedProps.Visible = false;
  1417. if (this.toolMenu.Toolbars[0].Tools.Exists("DeletePassApply")) this.toolMenu.Toolbars[0].Tools["DeletePassApply"].SharedProps.Visible = false;
  1418. if (this.toolMenu.Toolbars[0].Tools.Exists("DeleteJudge")) this.toolMenu.Toolbars[0].Tools["DeleteJudge"].SharedProps.Visible = false;
  1419. if (this.toolMenu.Toolbars[0].Tools.Exists("UpdateMemo")) this.toolMenu.Toolbars[0].Tools["UpdateMemo"].SharedProps.Visible = false;
  1420. if (this.toolMenu.Toolbars[0].Tools.Exists("Export")) this.toolMenu.Toolbars[0].Tools["Export"].SharedProps.Visible = true;
  1421. if (this.toolMenu.Toolbars[0].Tools.Exists("FoldQuery")) this.toolMenu.Toolbars[0].Tools["FoldQuery"].SharedProps.Visible = false;
  1422. if (this.toolMenu.Toolbars[0].Tools.Exists("GapJudge")) this.toolMenu.Toolbars[0].Tools["GapJudge"].SharedProps.Visible = false;
  1423. if (this.toolMenu.Toolbars[0].Tools.Exists("RefreshGroup")) this.toolMenu.Toolbars[0].Tools["RefreshGroup"].SharedProps.Visible = false;
  1424. if (this.toolMenu.Toolbars[0].Tools.Exists("RefreshZbs")) this.toolMenu.Toolbars[0].Tools["RefreshZbs"].SharedProps.Visible = false;
  1425. if (this.toolMenu.Toolbars[0].Tools.Exists("ReviewGpCertificate")) this.toolMenu.Toolbars[0].Tools["ReviewGpCertificate"].SharedProps.Visible = false;
  1426. break;
  1427. case "PassRecord":
  1428. if (this.toolMenu.Toolbars[0].Tools.Exists("Judge")) this.toolMenu.Toolbars[0].Tools["Judge"].SharedProps.Visible = false;
  1429. if (this.toolMenu.Toolbars[0].Tools.Exists("PassApply")) this.toolMenu.Toolbars[0].Tools["PassApply"].SharedProps.Visible = false;
  1430. if (this.toolMenu.Toolbars[0].Tools.Exists("UrgentPassApply")) this.toolMenu.Toolbars[0].Tools["UrgentPassApply"].SharedProps.Visible = false;
  1431. if (this.toolMenu.Toolbars[0].Tools.Exists("DeletePassApply")) this.toolMenu.Toolbars[0].Tools["DeletePassApply"].SharedProps.Visible = true;
  1432. if (this.toolMenu.Toolbars[0].Tools.Exists("DeleteJudge")) this.toolMenu.Toolbars[0].Tools["DeleteJudge"].SharedProps.Visible = false;
  1433. if (this.toolMenu.Toolbars[0].Tools.Exists("UpdateMemo")) this.toolMenu.Toolbars[0].Tools["UpdateMemo"].SharedProps.Visible = false;
  1434. if (this.toolMenu.Toolbars[0].Tools.Exists("Export")) this.toolMenu.Toolbars[0].Tools["Export"].SharedProps.Visible = true;
  1435. if (this.toolMenu.Toolbars[0].Tools.Exists("FoldQuery")) this.toolMenu.Toolbars[0].Tools["FoldQuery"].SharedProps.Visible = false;
  1436. if (this.toolMenu.Toolbars[0].Tools.Exists("GapJudge")) this.toolMenu.Toolbars[0].Tools["GapJudge"].SharedProps.Visible = false;
  1437. if (this.toolMenu.Toolbars[0].Tools.Exists("RefreshGroup")) this.toolMenu.Toolbars[0].Tools["RefreshGroup"].SharedProps.Visible = false;
  1438. if (this.toolMenu.Toolbars[0].Tools.Exists("RefreshZbs")) this.toolMenu.Toolbars[0].Tools["RefreshZbs"].SharedProps.Visible = false;
  1439. if (this.toolMenu.Toolbars[0].Tools.Exists("ReviewGpCertificate")) this.toolMenu.Toolbars[0].Tools["ReviewGpCertificate"].SharedProps.Visible = false;
  1440. break;
  1441. }
  1442. }
  1443. private void SteelMakingColligateJudgeFrm_Shown(object sender, EventArgs e)
  1444. {
  1445. ultraTabControl2_SelectedTabChanged(null, null);
  1446. FoldQuery();
  1447. }
  1448. private void labelDateTimePicker6_CheckBox_CheckedChanged(object sender, EventArgs e)
  1449. {
  1450. labelDateTimePicker5.DateTimeEnabled = labelDateTimePicker6.Checked;
  1451. }
  1452. private void labelTextBox4_TextBox_KeyDown(object sender, KeyEventArgs e)
  1453. {
  1454. if (e.KeyData == Keys.Enter)
  1455. {
  1456. Query();
  1457. }
  1458. }
  1459. private void labelTextBox6_TextBox_KeyDown(object sender, KeyEventArgs e)
  1460. {
  1461. if (e.KeyData == Keys.Enter)
  1462. {
  1463. Query();
  1464. }
  1465. }
  1466. private void labelTextBox7_TextBox_KeyDown(object sender, KeyEventArgs e)
  1467. {
  1468. if (e.KeyData == Keys.Enter)
  1469. {
  1470. Query();
  1471. }
  1472. }
  1473. private void ultraExpandableGroupBox2_ExpandedStateChanged(object sender, EventArgs e)
  1474. {
  1475. if (!ultraExpandableGroupBox2.Expanded)
  1476. {
  1477. ultraExpandableGroupBox2.Dock = DockStyle.Bottom;
  1478. splitContainer3.Panel1.Controls.Add(ultraExpandableGroupBox2);
  1479. ultraExpandableGroupBox2.BringToFront();
  1480. splitContainer3.Panel2Collapsed = true;
  1481. }
  1482. else
  1483. {
  1484. ultraExpandableGroupBox2.Dock = DockStyle.Fill;
  1485. splitContainer3.Panel2.Controls.Add(ultraExpandableGroupBox2);
  1486. splitContainer3.Panel2Collapsed = false;
  1487. }
  1488. }
  1489. private void FoldQuery()
  1490. {
  1491. if (!this.toolMenu.Toolbars[0].Tools.Exists("FoldQuery")) return;
  1492. if (passInfo == "Urgent")
  1493. {
  1494. panel6.Visible = !panel6.Visible;
  1495. }
  1496. else
  1497. {
  1498. panel1.Visible = !panel1.Visible;
  1499. }
  1500. if (panel1.Visible || panel1.Visible)
  1501. {
  1502. this.toolMenu.Toolbars[0].Tools["FoldQuery"].SharedProps.Caption = "折叠查询区域";
  1503. }
  1504. else
  1505. {
  1506. this.toolMenu.Toolbars[0].Tools["FoldQuery"].SharedProps.Caption = "展开查询区域";
  1507. }
  1508. }
  1509. private void RefreshGroup()
  1510. {
  1511. var chkRows = _zgJudgeApplyCtrl.UltraGrid1.Rows.Where(a => a.GetValue("Chk") == "True");
  1512. if (chkRows.Count() == 0)
  1513. {
  1514. MessageUtil.ShowWarning("请选择申请判定记录!", _zgJudgeApplyCtrl.UltraGrid1, _zgJudgeApplyCtrl.UltraGrid1.ActiveRow.Cells["Chk"]);
  1515. return;
  1516. }
  1517. foreach (var row in chkRows)
  1518. {
  1519. string lotNo = row.GetValue("lotNo");
  1520. string judgeStoveNo = row.GetValue("judgeStoveNo");
  1521. string batchNo = row.GetValue("batchNo");
  1522. string applyCode = row.GetValue("jugdeApplyCode");
  1523. DataRow drZgJudgeApply = _d.GetRowByXmlId("QcmZgJugdeApplyDAL.QueryByBatchNo", applyCode, judgeStoveNo, batchNo);
  1524. string processCode = drZgJudgeApply["processCode"].ToString();
  1525. if (drZgJudgeApply["judgeResultCode"].ToString() == "40740701")
  1526. {
  1527. MessageUtil.ShowWarning("该记录已经有综合判定结果,不能刷新!");
  1528. return;
  1529. }
  1530. _d.Set("com.steering.pss.judge.Bll.BllCreateGroupStoveInfo.Create", processCode, lotNo, judgeStoveNo, batchNo, applyCode);
  1531. }
  1532. MessageUtil.ShowTips("刷新成功!");
  1533. }
  1534. private void RefreshCraft()
  1535. {
  1536. WaitingForm2 wf = new WaitingForm2("正在刷新,请稍后....");
  1537. try
  1538. {
  1539. var chkRows = _zgJudgeApplyCtrl.UltraGrid1.Rows.Where(a => a.GetValue("Chk") == "True");
  1540. if (chkRows.Count() == 0)
  1541. {
  1542. MessageUtil.ShowWarning("请选择申请判定记录!", _zgJudgeApplyCtrl.UltraGrid1, _zgJudgeApplyCtrl.UltraGrid1.ActiveRow.Cells["Chk"]);
  1543. return;
  1544. }
  1545. foreach (var row in chkRows)
  1546. {
  1547. string judgeApplyCode = row.GetValue("jugdeApplyCode");
  1548. string judgeStoveNo = row.GetValue("judgeStoveNo");
  1549. string batchNo = row.GetValue("batchNo");
  1550. CoreClientParam ccp = _d.Set("com.steering.pss.judge.Bll.BllZcColligateJudge.refreshCraft", judgeApplyCode, judgeStoveNo, batchNo);
  1551. if (ccp.ReturnInfo.ToString2() != "")
  1552. {
  1553. MessageUtil.ShowWarning("炉号:" + judgeStoveNo + "批号:" + batchNo + " " + ccp.ReturnInfo);
  1554. return;
  1555. }
  1556. }
  1557. }
  1558. finally
  1559. {
  1560. wf.Close();
  1561. }
  1562. MessageUtil.ShowTips("获取成功!");
  1563. }
  1564. private void CopyZgData()
  1565. {
  1566. var chkRows = _zgJudgeApplyCtrl.UltraGrid1.Rows.Where(a => a.GetValue("Chk") == "True");
  1567. if (chkRows.Count() == 0)
  1568. {
  1569. MessageUtil.ShowWarning("请选择申请判定记录!", _zgJudgeApplyCtrl.UltraGrid1, _zgJudgeApplyCtrl.UltraGrid1.ActiveRow.Cells["Chk"]);
  1570. return;
  1571. }
  1572. string applyCode = "";
  1573. string judgeStoveNo = "";
  1574. string batchNo = "";
  1575. foreach (var row in chkRows)
  1576. {
  1577. string lotNo = row.GetValue("lotNo");
  1578. judgeStoveNo = row.GetValue("judgeStoveNo");
  1579. batchNo = row.GetValue("batchNo");
  1580. applyCode = row.GetValue("jugdeApplyCode");
  1581. var result = _d.Set("com.steering.pss.judge.Bll.BllRolledTubeColligateJudge.CopyZgJhyData",
  1582. applyCode, judgeStoveNo, batchNo, processCode);
  1583. if (result.ReturnInfo.ToString2() != "")
  1584. {
  1585. MessageUtil.ShowWarning(result.ReturnInfo);
  1586. return;
  1587. }
  1588. }
  1589. MessageUtil.ShowTips("复制成功!");
  1590. Relocate(applyCode, judgeStoveNo, batchNo);
  1591. }
  1592. private void CopyRclData()
  1593. {
  1594. var chkRows = _zgJudgeApplyCtrl.UltraGrid1.Rows.Where(a => a.GetValue("Chk") == "True");
  1595. if (chkRows.Count() == 0)
  1596. {
  1597. MessageUtil.ShowWarning("请选择申请判定记录!", _zgJudgeApplyCtrl.UltraGrid1, _zgJudgeApplyCtrl.UltraGrid1.ActiveRow.Cells["Chk"]);
  1598. return;
  1599. }
  1600. string applyCode = "";
  1601. string judgeStoveNo = "";
  1602. string batchNo = "";
  1603. foreach (var row in chkRows)
  1604. {
  1605. string lotNo = row.GetValue("lotNo");
  1606. judgeStoveNo = row.GetValue("judgeStoveNo");
  1607. batchNo = row.GetValue("batchNo");
  1608. applyCode = row.GetValue("jugdeApplyCode");
  1609. var result = _d.Set("com.steering.pss.judge.Bll.BllRolledTubeColligateJudge.CopyRclJhyData",
  1610. applyCode, judgeStoveNo, batchNo, processCode);
  1611. if (result.ReturnInfo.ToString2() != "")
  1612. {
  1613. MessageUtil.ShowWarning(result.ReturnInfo);
  1614. return;
  1615. }
  1616. }
  1617. MessageUtil.ShowTips("复制成功!");
  1618. Relocate(applyCode, judgeStoveNo, batchNo);
  1619. }
  1620. private void labelDateTimePicker8_CheckBox_CheckedChanged(object sender, EventArgs e)
  1621. {
  1622. labelDateTimePicker7.DateTimeEnabled = labelDateTimePicker8.Checked;
  1623. }
  1624. private void ultraTextEditor1_EditorButtonClick(object sender, Infragistics.Win.UltraWinEditors.EditorButtonEventArgs e)
  1625. {
  1626. ChoicePlineFrm frm = new ChoicePlineFrm(_dtPline, ultraTextEditor1.Tag.ToString2(), _d.Ob);
  1627. if (frm.ShowDialog() == System.Windows.Forms.DialogResult.OK)
  1628. {
  1629. ultraTextEditor1.Text = frm.ChoicePlineName;
  1630. ultraTextEditor1.Tag = frm.ChoicePlineCode;
  1631. }
  1632. }
  1633. private void ultraTextEditor3_EditorButtonClick(object sender, Infragistics.Win.UltraWinEditors.EditorButtonEventArgs e)
  1634. {
  1635. ChoicePlineFrm frm = new ChoicePlineFrm(_dtPline, ultraTextEditor3.Tag.ToString2(), _d.Ob);
  1636. if (frm.ShowDialog() == System.Windows.Forms.DialogResult.OK)
  1637. {
  1638. ultraTextEditor3.Text = frm.ChoicePlineName;
  1639. ultraTextEditor3.Tag = frm.ChoicePlineCode;
  1640. }
  1641. }
  1642. private void ultraTextEditor4_EditorButtonClick(object sender, Infragistics.Win.UltraWinEditors.EditorButtonEventArgs e)
  1643. {
  1644. ChoicePlineFrm frm = new ChoicePlineFrm(_dtPline, ultraTextEditor4.Tag.ToString2(), _d.Ob);
  1645. if (frm.ShowDialog() == System.Windows.Forms.DialogResult.OK)
  1646. {
  1647. ultraTextEditor4.Text = frm.ChoicePlineName;
  1648. ultraTextEditor4.Tag = frm.ChoicePlineCode;
  1649. }
  1650. }
  1651. }
  1652. }