FrmPerformanceResult.cs 102 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484148514861487148814891490149114921493149414951496149714981499150015011502150315041505150615071508150915101511151215131514151515161517151815191520152115221523152415251526152715281529153015311532153315341535153615371538153915401541154215431544154515461547154815491550155115521553155415551556155715581559156015611562156315641565156615671568156915701571157215731574157515761577157815791580158115821583158415851586158715881589159015911592159315941595159615971598159916001601160216031604160516061607160816091610161116121613161416151616161716181619162016211622162316241625162616271628162916301631163216331634163516361637163816391640164116421643164416451646164716481649165016511652165316541655165616571658165916601661166216631664166516661667166816691670167116721673167416751676167716781679168016811682168316841685168616871688168916901691169216931694169516961697169816991700170117021703170417051706170717081709171017111712171317141715171617171718171917201721172217231724172517261727172817291730173117321733173417351736173717381739174017411742174317441745174617471748174917501751175217531754175517561757175817591760176117621763176417651766176717681769177017711772177317741775177617771778177917801781178217831784178517861787178817891790179117921793179417951796179717981799180018011802180318041805180618071808180918101811181218131814181518161817181818191820182118221823182418251826182718281829183018311832183318341835183618371838183918401841184218431844184518461847184818491850185118521853185418551856185718581859186018611862186318641865186618671868186918701871187218731874187518761877187818791880188118821883188418851886188718881889189018911892189318941895189618971898189919001901190219031904190519061907190819091910191119121913191419151916191719181919192019211922192319241925192619271928192919301931193219331934193519361937193819391940194119421943194419451946194719481949195019511952195319541955195619571958195919601961196219631964196519661967196819691970197119721973197419751976197719781979198019811982198319841985198619871988198919901991199219931994199519961997199819992000200120022003200420052006200720082009201020112012201320142015201620172018201920202021202220232024202520262027202820292030203120322033203420352036203720382039204020412042204320442045204620472048204920502051205220532054205520562057205820592060206120622063206420652066206720682069207020712072207320742075207620772078207920802081208220832084208520862087208820892090209120922093209420952096209720982099210021012102210321042105210621072108210921102111211221132114211521162117211821192120212121222123212421252126212721282129213021312132213321342135213621372138213921402141214221432144214521462147214821492150215121522153215421552156215721582159216021612162216321642165216621672168216921702171217221732174217521762177217821792180218121822183218421852186218721882189219021912192219321942195219621972198219922002201220222032204220522062207220822092210221122122213221422152216221722182219222022212222222322242225222622272228222922302231223222332234223522362237223822392240224122422243224422452246224722482249225022512252225322542255225622572258225922602261226222632264226522662267226822692270227122722273227422752276227722782279228022812282228322842285228622872288228922902291229222932294229522962297229822992300230123022303230423052306230723082309231023112312231323142315231623172318231923202321232223232324232523262327232823292330233123322333233423352336233723382339234023412342234323442345234623472348234923502351235223532354235523562357235823592360236123622363236423652366236723682369237023712372237323742375237623772378237923802381238223832384238523862387238823892390239123922393239423952396239723982399240024012402240324042405240624072408240924102411241224132414241524162417241824192420242124222423242424252426242724282429243024312432243324342435243624372438243924402441244224432444244524462447244824492450245124522453245424552456245724582459246024612462246324642465246624672468246924702471247224732474247524762477247824792480248124822483
  1. using System;
  2. using System.Collections;
  3. using System.Collections.Generic;
  4. using System.ComponentModel;
  5. using System.Data;
  6. using System.Drawing;
  7. using System.Linq;
  8. using System.Text;
  9. using System.Windows.Forms;
  10. using CoreFS.CA06;
  11. using Core.Mes.Client.Comm.Server;
  12. using Core.Mes.Client.Comm.Control;
  13. using Core.StlMes.Client.Mcp;
  14. using com.steering.mes.mcp.entity;
  15. using Infragistics.Win.UltraWinGrid;
  16. using Core.StlMes.Client.Mcp.Control;
  17. using Core.StlMes.Client.Mcp.Common;
  18. using Core.StlMes.Client.Mcp.Entity;
  19. using Core.Mes.Client.Comm.Tool;
  20. using Core.StlMes.Client.Mcp.CollarMaterial;
  21. using Infragistics.Win;
  22. using Core.StlMes.Client.Mcp.Coupling;
  23. namespace Core.StlMes.Client.Coup
  24. {
  25. public partial class FrmPerformanceResult : FrmBase
  26. {
  27. private string departm = "";//获取部门ID
  28. private string[] plineCode = null;//获取产线代码
  29. private string cutGx = "";//切管工序
  30. private string embGx = "";//压印工序
  31. //private string rouGx = "";//粗加工工序
  32. private string csGx = "";//车丝工序
  33. private string PsGx = "";//喷砂工序
  34. private string LiXian = "";
  35. public FrmPerformanceResult()
  36. {
  37. InitializeComponent();
  38. this.IsLoadUserView = true;
  39. }
  40. protected override void OnLoad(EventArgs e)
  41. {
  42. base.OnLoad(e);
  43. //禁控件过滤
  44. this.coupWoIdPlanControl1.Grid.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
  45. //设置计划区控件只读
  46. //this.coupWoIdPlanControl1.SetAllColumnsActiveOnly();
  47. coupWoIdPlanControl1.Ob = this.ob;
  48. }
  49. private void FrmPerformanceResult_Load(object sender, EventArgs e)
  50. {
  51. departm = UserInfo.GetDeptid();
  52. plineCode = McpBaseHelper.GetPCodePline(departm, this.ob);
  53. // McpBaseHelper.InitPlineUnit(cmbCname, plineCode, this.ob);
  54. //McpBaseHelper.InitPlineUnit(cmbCname, plineCode, this.ob,"H");
  55. #region 切管
  56. //获取废品原因
  57. DataTable dt1 = ServerHelper.GetData("com.steering.mes.mcp.coup.CoupCutService.getCutResultFp", new object[] { "7002" }, this.ob);
  58. cmbReason.DataSource = dt1;
  59. cmbReason.ValueMember = "BASENAME";
  60. YdmBaseClass.SetComboItemHeight(cmbReason);
  61. txtBz.Value = UserInfo.GetUserGroup();
  62. txtBC.Value = UserInfo.GetUserOrder();
  63. txtUser.Text = UserInfo.GetUserName();
  64. //获取切管工序
  65. DataTable dt2 = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryGX", new object[] { "700302" }, this.ob);
  66. if (dt2.Rows.Count > 0)
  67. {
  68. cutGx = dt2.Rows[0]["BASECODE"].ToString();
  69. }
  70. //获取压印工序
  71. DataTable dt3 = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryGX", new object[] { "700304" }, this.ob);
  72. if (dt3.Rows.Count > 0)
  73. {
  74. embGx = dt3.Rows[0]["BASECODE"].ToString();
  75. }
  76. //获取粗加工工序
  77. //DataTable dt4 = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryGX", new object[] { "700303" }, this.ob);
  78. //if (dt4.Rows.Count > 0)
  79. //{
  80. // rouGx = dt4.Rows[0]["BASECODE"].ToString();
  81. //}
  82. #endregion
  83. #region 车丝
  84. //获取废品原因
  85. DataTable dtcs = ServerHelper.GetData("com.steering.mes.mcp.coup.CoupCutService.getCutResultFp", new object[] { "7004" }, this.ob);
  86. txtCsFp.DataSource = dtcs;
  87. txtCsFp.ValueMember = "BASENAME";
  88. YdmBaseClass.SetComboItemHeight(txtCsFp);
  89. txtCsBz.Value = UserInfo.GetUserGroup();
  90. txtCsBc.Value = UserInfo.GetUserOrder();
  91. txtUserCs.Text = UserInfo.GetUserName();
  92. //获取车丝工序
  93. DataTable dtcsgx = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryGX", new object[] { "700305" }, this.ob);
  94. if (dtcsgx.Rows.Count > 0)
  95. {
  96. csGx = dtcsgx.Rows[0]["BASECODE"].ToString();
  97. }
  98. #endregion
  99. #region 喷砂
  100. //获取工序
  101. DataTable dtps = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryGX", new object[] { "700308" }, this.ob);
  102. if (dtps.Rows.Count > 0)
  103. {
  104. PsGx = dt2.Rows[0]["BASECODE"].ToString();
  105. }
  106. txtPsbc.Value = this.UserInfo.GetUserOrder();
  107. txtPsbz.Value = this.UserInfo.GetUserGroup();
  108. txtUserPs.Text = this.UserInfo.GetUserName();
  109. //获取废品原因
  110. DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.coup.CoupCutService.getCutResultFp", new object[] { "7007" }, this.ob);
  111. cmbFpPs.DataSource = dt;
  112. cmbFpPs.ValueMember = "BASENAME";
  113. YdmBaseClass.SetComboItemHeight(cmbFpPs);
  114. //获取喷料
  115. DataTable dt1ps = ServerHelper.GetData("com.steering.mes.mcp.coup.CoupCutService.getCutResultFp", new object[] { "7005" }, this.ob);
  116. cmbPsSpray.DataSource = dt1ps;
  117. cmbPsSpray.ValueMember = "BASENAME";
  118. YdmBaseClass.SetComboItemHeight(cmbPsSpray);
  119. //获取喷砂设备
  120. DataTable dt3ps = ServerHelper.GetData("com.steering.mes.mcp.coup.CoupCutService.getCutResultFp", new object[] { "7006" }, this.ob);
  121. cmbPsEquipment.DataSource = dt3ps;
  122. cmbPsEquipment.ValueMember = "BASENAME";
  123. YdmBaseClass.SetComboItemHeight(cmbPsEquipment);
  124. #endregion
  125. }
  126. public override void ToolBar_Click(object sender, string ToolbarKey)
  127. {
  128. switch (ToolbarKey)
  129. {
  130. case "DoQuery":
  131. QuerySinglePlan();
  132. break;
  133. case "DoSave":
  134. DoSave();
  135. break;
  136. case "DoUpdate":
  137. DoUpdate();
  138. break;
  139. case "DoDelete":
  140. DoDelete();
  141. break;
  142. case "DoBeside"://结炉
  143. DoBeside();
  144. break;
  145. case "UndoBeside"://撤销结炉
  146. UndoBeside();
  147. break;
  148. case "Offline"://离线
  149. Offline();
  150. break;
  151. case "unOffline":
  152. unOffline();
  153. break;
  154. case "DoClose":
  155. this.Close();
  156. break;
  157. }
  158. }
  159. private void Offline()
  160. {
  161. if (ultraTabControl3.SelectedTab.Key.Equals("0"))
  162. {
  163. OfflineQg();
  164. }
  165. else if (ultraTabControl3.SelectedTab.Key.Equals("1"))
  166. {
  167. OfflineCs();
  168. }
  169. else
  170. {
  171. OfflinePs();
  172. }
  173. }
  174. //撤销离线
  175. private void unOffline()
  176. {
  177. if (ultraTabControl3.SelectedTab.Key.Equals("0"))
  178. {
  179. unOfflineQg();
  180. }
  181. else if (ultraTabControl3.SelectedTab.Key.Equals("1"))
  182. {
  183. unOfflineCs();
  184. }
  185. else
  186. {
  187. unOfflinePs();
  188. }
  189. }
  190. private void unOfflineQg()
  191. {
  192. ultraCut.UpdateData();
  193. UltraGridRow uRow = this.ultraCut.ActiveRow;
  194. if (uRow == null) { MessageUtil.ShowTips("锯切实绩无数据!"); return; }
  195. UltraGridRow row = this.ultraGrid2.ActiveRow;
  196. if (uRow == null)
  197. {
  198. MessageUtil.ShowTips("无工单信息,不允许此操作!");
  199. }
  200. if (row.Cells["ZY_BILL_STATUS"].Value.ToString() == "生产完成")
  201. {
  202. MessageUtil.ShowTips("此炉次计划整体已生产完成,不允许此操作!");
  203. return;
  204. }
  205. string zYgNo = uRow.Cells["ZY_PLAN_ID"].Value.ToString();
  206. string woId = uRow.Cells["WO_ID"].Value.ToString();
  207. DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryWoIdDetails", new object[] { woId, zYgNo }, this.ob);
  208. if (dt.Rows[0]["CUT_STATUS"].ToString().Equals("生产完成"))
  209. {
  210. MessageUtil.ShowTips("此工单工序点已结炉,不允许此操作!");
  211. return;
  212. }
  213. //if(!QueryStatusGd(row.Cells["WO_ID"].Value.ToString(), row.Cells["ZY_PLAN_ID"].Value.ToString())) return;
  214. ArrayList list1 = new ArrayList();
  215. int UpdaCount = 0;
  216. foreach (UltraGridRow ugr in ultraCut.Rows)
  217. {
  218. if (Convert.ToBoolean(ugr.Cells["CHECK"].Text) == true)
  219. {
  220. UpdaCount += 1;
  221. ArrayList list = new ArrayList();
  222. list.Add(ugr.Cells["RESULT_NO"].Text.ToString());
  223. list1.Add(list);
  224. }
  225. }
  226. if (UpdaCount == 0) { MessageUtil.ShowTips("请选择离线数据!"); return; }
  227. if (MessageUtil.ShowYesNoAndQuestion("是否撤销离线?") == DialogResult.No)
  228. {
  229. return;
  230. }
  231. CoreClientParam ccp = new CoreClientParam();
  232. try
  233. {
  234. this.Cursor = Cursors.WaitCursor; //控制鼠标的样式为等待
  235. if (Constant.WaitingForm == null)
  236. {
  237. Constant.WaitingForm = new WaitingForm();
  238. }
  239. Constant.WaitingForm.ShowToUser = true;
  240. Constant.WaitingForm.Show();
  241. Constant.WaitingForm.Update();
  242. ccp.ServerName = "com.steering.mes.mcp.coup.CoupCutService";
  243. ccp.MethodName = "unlixianThreadingResult";
  244. ccp.ServerParams = new object[] { list1, row.Cells["ZY_PLAN_ID"].Text.ToString(), row.Cells["WO_ID"].Text.ToString() };
  245. ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
  246. this.Cursor = Cursors.Default;
  247. Constant.WaitingForm.ShowToUser = false;
  248. Constant.WaitingForm.Close();
  249. Constant.WaitingForm = null;
  250. }
  251. catch (Exception ex)
  252. {
  253. this.Cursor = Cursors.Default;
  254. Constant.WaitingForm.ShowToUser = false;
  255. Constant.WaitingForm.Close();
  256. Constant.WaitingForm = null;
  257. }
  258. if (ccp.ReturnCode == -1) return;
  259. MessageUtil.ShowTips(ccp.ReturnInfo);
  260. if (ccp.ReturnInfo.Equals("撤销离线成功!"))
  261. {
  262. QuerySinglePlan();
  263. }
  264. }
  265. private void unOfflinePs()
  266. {
  267. ultraPs.UpdateData();
  268. UltraGridRow uRow = this.ultraPs.ActiveRow;
  269. if (uRow == null) { MessageUtil.ShowTips("喷砂实绩无数据!"); return; }
  270. UltraGridRow row = this.ultraGrid2.ActiveRow;
  271. if (uRow == null)
  272. {
  273. MessageUtil.ShowTips("无工单信息,不允许此操作!");
  274. }
  275. if (row.Cells["ZY_BILL_STATUS"].Value.ToString() == "生产完成")
  276. {
  277. MessageUtil.ShowTips("此炉次计划整体已生产完成,不允许此操作!");
  278. return;
  279. }
  280. string zYgNo = uRow.Cells["ZY_PLAN_ID"].Value.ToString();
  281. string woId = uRow.Cells["WO_ID"].Value.ToString();
  282. DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryWoIdDetails", new object[] { woId, zYgNo }, this.ob);
  283. if (dt.Rows[0]["BLAST_STATUS"].ToString().Equals("生产完成"))
  284. {
  285. MessageUtil.ShowTips("此工单工序点已结炉,不允许此操作!");
  286. return;
  287. }
  288. //if(!QueryStatusGd(row.Cells["WO_ID"].Value.ToString(), row.Cells["ZY_PLAN_ID"].Value.ToString())) return;
  289. ArrayList list1 = new ArrayList();
  290. int UpdaCount = 0;
  291. foreach (UltraGridRow ugr in ultraPs.Rows)
  292. {
  293. if (Convert.ToBoolean(ugr.Cells["CHK"].Text) == true)
  294. {
  295. UpdaCount += 1;
  296. ArrayList list = new ArrayList();
  297. list.Add(ugr.Cells["RESULT_NO"].Text.ToString());
  298. list1.Add(list);
  299. }
  300. }
  301. if (UpdaCount == 0) { MessageUtil.ShowTips("请选择离线数据!"); return; }
  302. if (MessageUtil.ShowYesNoAndQuestion("是否撤销离线?") == DialogResult.No)
  303. {
  304. return;
  305. }
  306. CoreClientParam ccp = new CoreClientParam();
  307. try
  308. {
  309. this.Cursor = Cursors.WaitCursor; //控制鼠标的样式为等待
  310. if (Constant.WaitingForm == null)
  311. {
  312. Constant.WaitingForm = new WaitingForm();
  313. }
  314. Constant.WaitingForm.ShowToUser = true;
  315. Constant.WaitingForm.Show();
  316. Constant.WaitingForm.Update();
  317. ccp.ServerName = "com.steering.mes.mcp.coup.FrmSandBlast";
  318. ccp.MethodName = "unlixianThreadingResult";
  319. ccp.ServerParams = new object[] { list1, row.Cells["ZY_PLAN_ID"].Text.ToString(), row.Cells["WO_ID"].Text.ToString() };
  320. ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
  321. this.Cursor = Cursors.Default;
  322. Constant.WaitingForm.ShowToUser = false;
  323. Constant.WaitingForm.Close();
  324. Constant.WaitingForm = null;
  325. }
  326. catch (Exception ex)
  327. {
  328. this.Cursor = Cursors.Default;
  329. Constant.WaitingForm.ShowToUser = false;
  330. Constant.WaitingForm.Close();
  331. Constant.WaitingForm = null;
  332. }
  333. if (ccp.ReturnCode == -1) return;
  334. MessageUtil.ShowTips(ccp.ReturnInfo);
  335. if (ccp.ReturnInfo.Equals("撤销离线成功!"))
  336. {
  337. QuerySinglePlan();
  338. }
  339. }
  340. private void unOfflineCs()
  341. {
  342. ultraCs.UpdateData();
  343. UltraGridRow uRow = this.ultraCs.ActiveRow;
  344. if (uRow == null) { MessageUtil.ShowTips("车丝实绩无数据!"); return; }
  345. UltraGridRow row = this.ultraGrid2.ActiveRow;
  346. if (uRow == null)
  347. {
  348. MessageUtil.ShowTips("无工单信息,不允许此操作!");
  349. }
  350. if (row.Cells["ZY_BILL_STATUS"].Value.ToString() == "生产完成")
  351. {
  352. MessageUtil.ShowTips("此炉次计划整体已生产完成,不允许此操作!");
  353. return;
  354. }
  355. string zYgNo = uRow.Cells["ZY_PLAN_ID"].Value.ToString();
  356. string woId = uRow.Cells["WO_ID"].Value.ToString();
  357. DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryWoIdDetails", new object[] { woId, zYgNo }, this.ob);
  358. if (dt.Rows[0]["LATHE_STATUS"].ToString().Equals("生产完成"))
  359. {
  360. MessageUtil.ShowTips("此工单工序点已结炉,不允许此操作!");
  361. return;
  362. }
  363. //if(!QueryStatusGd(row.Cells["WO_ID"].Value.ToString(), row.Cells["ZY_PLAN_ID"].Value.ToString())) return;
  364. ArrayList list1 = new ArrayList();
  365. int UpdaCount = 0;
  366. foreach (UltraGridRow ugr in ultraCs.Rows)
  367. {
  368. if (Convert.ToBoolean(ugr.Cells["CHECK"].Text) == true)
  369. {
  370. UpdaCount += 1;
  371. ArrayList list = new ArrayList();
  372. list.Add(ugr.Cells["RESULT_NO"].Text.ToString());
  373. list1.Add(list);
  374. }
  375. }
  376. if (UpdaCount == 0) { MessageUtil.ShowTips("请选择离线数据!"); return; }
  377. if (MessageUtil.ShowYesNoAndQuestion("是否撤销离线?") == DialogResult.No)
  378. {
  379. return;
  380. }
  381. CoreClientParam ccp = new CoreClientParam();
  382. try
  383. {
  384. this.Cursor = Cursors.WaitCursor; //控制鼠标的样式为等待
  385. if (Constant.WaitingForm == null)
  386. {
  387. Constant.WaitingForm = new WaitingForm();
  388. }
  389. Constant.WaitingForm.ShowToUser = true;
  390. Constant.WaitingForm.Show();
  391. Constant.WaitingForm.Update();
  392. ccp.ServerName = "com.steering.mes.mcp.coup.CoupThreadingService";
  393. ccp.MethodName = "unlixianThreadingResult";
  394. ccp.ServerParams = new object[] { list1, row.Cells["ZY_PLAN_ID"].Text.ToString(), row.Cells["WO_ID"].Text.ToString() };
  395. ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
  396. this.Cursor = Cursors.Default;
  397. Constant.WaitingForm.ShowToUser = false;
  398. Constant.WaitingForm.Close();
  399. Constant.WaitingForm = null;
  400. }
  401. catch (Exception ex)
  402. {
  403. this.Cursor = Cursors.Default;
  404. Constant.WaitingForm.ShowToUser = false;
  405. Constant.WaitingForm.Close();
  406. Constant.WaitingForm = null;
  407. }
  408. if (ccp.ReturnCode == -1) return;
  409. MessageUtil.ShowTips(ccp.ReturnInfo);
  410. if (ccp.ReturnInfo.Equals("撤销离线成功!"))
  411. {
  412. QuerySinglePlan();
  413. }
  414. }
  415. private void OfflineQg()
  416. {
  417. string _strat = "";
  418. OffLine frm = new OffLine();
  419. frm.ShowDialog();
  420. LiXian = frm.StrNum;
  421. _strat = frm.Strat;
  422. if (_strat.Equals("2")) return;
  423. if (LiXian.Equals("") || LiXian.Equals("0")) { MessageUtil.ShowTips("离线支数不能为空!"); return; }
  424. UltraGridRow row = ultraGrid2.ActiveRow;
  425. if (row == null) return;
  426. if (row.Cells["ZY_BILL_STATUS"].Value.ToString()=="生产完成")
  427. {
  428. MessageUtil.ShowTips("此工单状态已生产完成,不允许此操作!");
  429. return;
  430. }
  431. string zYgNo = row.Cells["ZY_PLAN_ID"].Value.ToString();
  432. string woId = row.Cells["WO_ID"].Value.ToString();
  433. DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryWoIdDetails", new object[] { woId, zYgNo }, this.ob);
  434. if (dt.Rows[0]["CUT_STATUS"].ToString().Equals("生产完成"))
  435. {
  436. MessageUtil.ShowTips("此工单工序点已结炉,不允许此操作!");
  437. return;
  438. }
  439. string time = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
  440. ArrayList list = new ArrayList();
  441. list.Add(LiXian);
  442. list.Add(row.Cells["WO_ID"].Text.ToString());
  443. list.Add(row.Cells["JUDGE_STOVE_NO"].Text.ToString());
  444. list.Add(row.Cells["BATCH_NO"].Text.ToString());
  445. list.Add(row.Cells["PLINE_CODE"].Text.ToString());
  446. list.Add(row.Cells["ZY_PLAN_ID"].Text.ToString());
  447. list.Add(row.Cells["PLINE_NAME"].Text.ToString());
  448. list.Add(this.UserInfo.GetUserName());
  449. list.Add(this.UserInfo.GetUserOrder());
  450. list.Add(this.UserInfo.GetUserGroup());
  451. list.Add(time);
  452. CoreClientParam ccp = new CoreClientParam();
  453. try
  454. {
  455. this.Cursor = Cursors.WaitCursor; //控制鼠标的样式为等待
  456. if (Constant.WaitingForm == null)
  457. {
  458. Constant.WaitingForm = new WaitingForm();
  459. }
  460. Constant.WaitingForm.ShowToUser = true;
  461. Constant.WaitingForm.Show();
  462. Constant.WaitingForm.Update();
  463. ccp.ServerName = "com.steering.mes.mcp.coup.CoupCutService";
  464. ccp.MethodName = "lixianThreadingResult";
  465. ccp.ServerParams = new object[] { list, cutGx };
  466. ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
  467. this.Cursor = Cursors.Default;
  468. Constant.WaitingForm.ShowToUser = false;
  469. Constant.WaitingForm.Close();
  470. Constant.WaitingForm = null;
  471. }
  472. catch (Exception ex)
  473. {
  474. this.Cursor = Cursors.Default;
  475. Constant.WaitingForm.ShowToUser = false;
  476. Constant.WaitingForm.Close();
  477. Constant.WaitingForm = null;
  478. }
  479. if (ccp.ReturnCode != -1)
  480. {
  481. MessageUtil.ShowTips(ccp.ReturnInfo);
  482. if (ccp.ReturnInfo.Equals("离线成功!"))
  483. {
  484. QuerySinglePlan();
  485. DoClean();
  486. }
  487. }
  488. }
  489. private void OfflineCs()
  490. {
  491. string _strat = "";
  492. OffLine frm = new OffLine();
  493. frm.ShowDialog();
  494. LiXian = frm.StrNum;
  495. _strat = frm.Strat;
  496. if (_strat.Equals("2")) return;
  497. if (LiXian.Equals("") || LiXian.Equals("0")) { MessageUtil.ShowTips("离线支数不能为空!"); return; }
  498. UltraGridRow row = ultraGrid2.ActiveRow;
  499. if (row == null) return;
  500. if (row.Cells["ZY_BILL_STATUS"].Value.ToString() == "生产完成")
  501. {
  502. MessageUtil.ShowTips("此工单状态已生产完成,不允许此操作!");
  503. return;
  504. }
  505. string zYgNo = row.Cells["ZY_PLAN_ID"].Value.ToString();
  506. string woId = row.Cells["WO_ID"].Value.ToString();
  507. DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryWoIdDetails", new object[] { woId, zYgNo }, this.ob);
  508. if (dt.Rows[0]["LATHE_STATUS"].ToString().Equals("生产完成"))
  509. {
  510. MessageUtil.ShowTips("此工单车丝工序点已结炉,不允许此操作!");
  511. return;
  512. }
  513. string time = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
  514. ArrayList list = new ArrayList();
  515. list.Add(LiXian);
  516. list.Add(row.Cells["WO_ID"].Text.ToString());
  517. list.Add(row.Cells["JUDGE_STOVE_NO"].Text.ToString());
  518. list.Add(row.Cells["BATCH_NO"].Text.ToString());
  519. list.Add(row.Cells["PLINE_CODE"].Text.ToString());
  520. list.Add(row.Cells["ZY_PLAN_ID"].Text.ToString());
  521. list.Add(row.Cells["PLINE_NAME"].Text.ToString());
  522. list.Add(this.UserInfo.GetUserName());
  523. list.Add(this.UserInfo.GetUserOrder());
  524. list.Add(this.UserInfo.GetUserGroup());
  525. list.Add(time);
  526. CoreClientParam ccp = new CoreClientParam();
  527. try
  528. {
  529. this.Cursor = Cursors.WaitCursor; //控制鼠标的样式为等待
  530. if (Constant.WaitingForm == null)
  531. {
  532. Constant.WaitingForm = new WaitingForm();
  533. }
  534. Constant.WaitingForm.ShowToUser = true;
  535. Constant.WaitingForm.Show();
  536. Constant.WaitingForm.Update();
  537. //ccp.ServerName = "com.steering.mes.mcp.coup.CoupThreadingService";
  538. //ccp.MethodName = "lixianThreadingResult";
  539. ccp.ServerName = "com.steering.mes.mcp.coup.CoupThreadingService";
  540. ccp.MethodName = "lixianThreadingResult";
  541. ccp.ServerParams = new object[] { list, csGx };
  542. ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
  543. this.Cursor = Cursors.Default;
  544. Constant.WaitingForm.ShowToUser = false;
  545. Constant.WaitingForm.Close();
  546. Constant.WaitingForm = null;
  547. }
  548. catch (Exception ex)
  549. {
  550. this.Cursor = Cursors.Default;
  551. Constant.WaitingForm.ShowToUser = false;
  552. Constant.WaitingForm.Close();
  553. Constant.WaitingForm = null;
  554. }
  555. if (ccp.ReturnCode != -1)
  556. {
  557. MessageUtil.ShowTips(ccp.ReturnInfo);
  558. if (ccp.ReturnInfo.Equals("离线成功!"))
  559. {
  560. QuerySinglePlan();
  561. DoClean();
  562. }
  563. }
  564. }
  565. private void OfflinePs()
  566. {
  567. string _strat = "";
  568. OffLine frm = new OffLine();
  569. frm.ShowDialog();
  570. LiXian = frm.StrNum;
  571. _strat = frm.Strat;
  572. if (_strat.Equals("2")) return;
  573. if (LiXian.Equals("") || LiXian.Equals("0")) { MessageUtil.ShowTips("离线支数不能为空!"); return; }
  574. UltraGridRow row = ultraGrid2.ActiveRow;
  575. if (row == null) return;
  576. string zYgNo = row.Cells["ZY_PLAN_ID"].Value.ToString();
  577. string woId = row.Cells["WO_ID"].Value.ToString();
  578. DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryWoIdDetails", new object[] { woId, zYgNo }, this.ob);
  579. if (dt.Rows[0]["BLAST_STATUS"].ToString().Equals("生产完成"))
  580. {
  581. MessageUtil.ShowTips("此工单喷砂工序点已结炉,不允许此操作!");
  582. return;
  583. }
  584. string time = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
  585. ArrayList list = new ArrayList();
  586. list.Add(LiXian);
  587. list.Add(row.Cells["WO_ID"].Text.ToString());
  588. list.Add(row.Cells["JUDGE_STOVE_NO"].Text.ToString());
  589. list.Add(row.Cells["BATCH_NO"].Text.ToString());
  590. list.Add(row.Cells["PLINE_CODE"].Text.ToString());
  591. list.Add(row.Cells["ZY_PLAN_ID"].Text.ToString());
  592. list.Add(row.Cells["PLINE_NAME"].Text.ToString());
  593. list.Add(this.UserInfo.GetUserName());
  594. list.Add(this.UserInfo.GetUserOrder());
  595. list.Add(this.UserInfo.GetUserGroup());
  596. list.Add(time);
  597. CoreClientParam ccp = new CoreClientParam();
  598. try
  599. {
  600. this.Cursor = Cursors.WaitCursor; //控制鼠标的样式为等待
  601. if (Constant.WaitingForm == null)
  602. {
  603. Constant.WaitingForm = new WaitingForm();
  604. }
  605. Constant.WaitingForm.ShowToUser = true;
  606. Constant.WaitingForm.Show();
  607. Constant.WaitingForm.Update();
  608. //ccp.ServerName = "com.steering.mes.mcp.coup.CoupThreadingService";
  609. //ccp.MethodName = "lixianThreadingResult";
  610. ccp.ServerName = "com.steering.mes.mcp.coup.FrmSandBlast";
  611. ccp.MethodName = "lixianThreadingResult";
  612. ccp.ServerParams = new object[] { list, PsGx };
  613. ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
  614. this.Cursor = Cursors.Default;
  615. Constant.WaitingForm.ShowToUser = false;
  616. Constant.WaitingForm.Close();
  617. Constant.WaitingForm = null;
  618. }
  619. catch (Exception ex)
  620. {
  621. this.Cursor = Cursors.Default;
  622. Constant.WaitingForm.ShowToUser = false;
  623. Constant.WaitingForm.Close();
  624. Constant.WaitingForm = null;
  625. }
  626. if (ccp.ReturnCode != -1)
  627. {
  628. MessageUtil.ShowTips(ccp.ReturnInfo);
  629. if (ccp.ReturnInfo.Equals("离线成功!"))
  630. {
  631. QuerySinglePlan();
  632. DoClean();
  633. }
  634. }
  635. }
  636. /// <summary>
  637. /// 查询作业计划
  638. /// </summary>
  639. private void QuerySinglePlan()
  640. {
  641. string woId = "";
  642. string[] starts = { };
  643. string judgeStoveNo = "";
  644. string plnNo = "";
  645. #region 条件
  646. if (chkStarts.Checked)
  647. {
  648. if (string.IsNullOrEmpty(cmbStarts.Text.Trim()))
  649. {
  650. MessageUtil.ShowTips("请选择工单状态!");
  651. return;
  652. }
  653. else
  654. {
  655. starts = (cmbStarts.Value as List<object>).Select(p => p.ToString().Trim()).ToArray();
  656. }
  657. }
  658. if (chkwoId.Checked && string.IsNullOrEmpty(txtWoId.Text.Trim()))
  659. {
  660. MessageUtil.ShowTips("请输入工单号!");
  661. return;
  662. }
  663. else
  664. {
  665. woId = txtWoId.Text.ToString().Trim();
  666. }
  667. if (chkPlnNo.Checked && string.IsNullOrEmpty(txtPlnNo.Text.Trim()))
  668. {
  669. MessageUtil.ShowTips("请输入炉次计划号!");
  670. return;
  671. }
  672. else
  673. {
  674. plnNo = txtPlnNo.Text.ToString().Trim();
  675. }
  676. if (chkJuNo.Checked && string.IsNullOrEmpty(txtJudgeStoveNO.Text.Trim()))
  677. {
  678. MessageUtil.ShowTips("请输入炉号!");
  679. return;
  680. }
  681. else
  682. {
  683. judgeStoveNo = txtJudgeStoveNO.Text.ToString().Trim();
  684. }
  685. #endregion
  686. ArrayList list = new ArrayList();
  687. list.Add(woId);
  688. list.Add(plnNo);
  689. list.Add(judgeStoveNo);
  690. list.Add(starts);
  691. DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryWoId", new object[] { list, plineCode[0].ToString() }, this.ob);
  692. GridHelper.CopyDataToDatatable(ref dt, ref dtProcessPlan, true);
  693. // GridHelper.RefreshAndAutoSize(ultraGridWoId);
  694. //string pliNo = "";
  695. //if (cmbCname.SelectedIndex != -1) { pliNo = cmbCname.Value.ToString(); } else { pliNo = ""; }
  696. //string judgeStoveNo = this.txtJudgeStoveNO.Text.ToString();
  697. //string batchNo = this.txtBatchNO.Text;
  698. //string zYgNo = this.txtLotNo.Text.Trim();
  699. //ArrayList list = new ArrayList();
  700. //list.Add(zYgNo);
  701. //list.Add(judgeStoveNo);
  702. //list.Add(batchNo);
  703. //DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.coup.CoupCutService.doQueryZygNo", new object[] { list, pliNo }, this.ob);
  704. //GridHelper.CopyDataToDatatable(ref dt, ref dtPlan, true);
  705. Information();
  706. }
  707. private void Information()
  708. {
  709. string woId = "";
  710. string starts = "";
  711. string judgeStoveNo = "";
  712. string plnNo = "";
  713. ArrayList list = new ArrayList();
  714. list.Add(woId);
  715. list.Add(plnNo);
  716. list.Add(judgeStoveNo);
  717. list.Add(starts);
  718. DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.ulgetQueryWoId", new object[] { list, plineCode[0].ToString() }, this.ob);
  719. GridHelper.CopyDataToDatatable(ref dt, ref dataTable2, true);
  720. GridHelper.RefreshAndAutoSize(ultraGrid3);
  721. }
  722. private void ultraGrid2_AfterRowActivate(object sender, EventArgs e)
  723. {
  724. this.ultraGrid2AfterRowActivate();
  725. }
  726. /// <summary>
  727. /// 作业计划详情
  728. /// </summary>
  729. private void ultraGrid2AfterRowActivate()
  730. {
  731. UltraGridRow row = ultraGrid2.ActiveRow;
  732. ////获取上料实绩
  733. string zYgNo = row.Cells["ZY_PLAN_ID"].Value.ToString();
  734. string woId = row.Cells["WO_ID"].Value.ToString();
  735. //string plNo = row.Cells["PLINE_CODE"].Value.ToString();
  736. //DataTable dt1 = ServerHelper.GetData("com.steering.mes.mcp.coup.CoupCutService.getCoupLingById", new object[] { zYgNo, plNo }, this.ob);
  737. //GridHelper.CopyDataToDatatable(ref dt1, ref dtLoadRecord, true);
  738. //GridHelper.RefreshAndAutoSize(ultraGrid1);
  739. //获取计划
  740. getJGCutPlan(zYgNo, woId);
  741. #region 切管
  742. //获取机床编号
  743. ArrayList list = new ArrayList();
  744. list.Add(cutGx);
  745. list.Add(row.Cells["PLINE_CODE"].Text.ToString());
  746. list.Add(row.Cells["CUT_MACH_GRP_NM"].Text.ToString());
  747. DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.coup.CoupCutService.getMachine", new object[] { list }, this.ob);
  748. cmbJcCode.DataSource = dt;
  749. cmbJcCode.ValueMember = "MACHINE_NAME";
  750. YdmBaseClass.SetComboItemHeight(cmbJcCode);
  751. cmbEmbossed.Text = row.Cells["IF_IMPRESS"].Text.ToString();//压印
  752. #endregion
  753. #region 车丝
  754. //获取机床编号
  755. ArrayList list1 = new ArrayList();
  756. list1.Add(csGx);
  757. list1.Add(row.Cells["PLINE_CODE"].Text.ToString());
  758. list1.Add(row.Cells["LATHE_GRP_NM"].Text.ToString());
  759. DataTable dt2 = ServerHelper.GetData("com.steering.mes.mcp.coup.CoupThreadingService.getMachine", new object[] { list1 }, this.ob);
  760. txtJcCs.DataSource = dt2;
  761. txtJcCs.ValueMember = "MACHINE_NAME";
  762. YdmBaseClass.SetComboItemHeight(txtJcCs);
  763. #endregion
  764. if (ultraTabControl3.SelectedTab.Key.Equals("0"))
  765. {
  766. //获取切管实绩
  767. this.getCoupCutResult(zYgNo, woId);
  768. }
  769. else if (ultraTabControl3.SelectedTab.Key.Equals("1"))
  770. { //获取车丝实绩
  771. this.getCoupThreadingResult(zYgNo, woId);
  772. }
  773. else
  774. { //获取喷砂实绩
  775. this.getCoupSandBlast(zYgNo, woId);
  776. }
  777. }
  778. /// <summary>
  779. /// 机床编号改变事件
  780. /// </summary>
  781. /// <param name="sender"></param>
  782. /// <param name="e"></param>
  783. ///查询操作工,根据机床编号
  784. private void cmbJcCode_TextChanged(object sender, EventArgs e)
  785. {
  786. UltraGridRow row = this.ultraGrid2.ActiveRow;
  787. if (row == null) return;
  788. DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.coup.CoupCutService.getMachUser", new object[] { cmbJcCode.Text.ToString(), cutGx, row.Cells["PLINE_CODE"].Text.Trim(), row.Cells["CUT_MACH_GRP_NM"].Text.ToString() }, this.ob);
  789. cmbOperator.DataSource = dt;
  790. cmbOperator.ValueMember = "MACHINE_USER1";
  791. YdmBaseClass.SetComboItemHeight(cmbOperator);
  792. }
  793. private void txtJcCs_TextChanged(object sender, EventArgs e)
  794. {
  795. UltraGridRow row = this.ultraGrid2.ActiveRow;
  796. if (row == null) return;
  797. DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.coup.CoupThreadingService.getMachUser", new object[] { txtJcCs.Text.ToString(), csGx, row.Cells["PLINE_CODE"].Text.Trim(), row.Cells["LATHE_GRP_NM"].Text.ToString() }, this.ob);
  798. txtOpeCs.DataSource = dt;
  799. txtOpeCs.ValueMember = "MACHINE_USER1";
  800. YdmBaseClass.SetComboItemHeight(txtOpeCs);
  801. Operator();
  802. }
  803. private void Operator()
  804. {
  805. UltraGridRow row = this.ultraGrid2.ActiveRow;
  806. if (row == null) return;
  807. DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.coup.CoupThreadingService.getMachUser1", new object[] { txtJcCs.Text.ToString(), csGx, row.Cells["PLINE_CODE"].Text.Trim(), row.Cells["LATHE_GRP_NM"].Text.ToString() }, this.ob);
  808. txtOpeCs1.DataSource = dt;
  809. txtOpeCs1.ValueMember = "MACHINE_USER2";
  810. YdmBaseClass.SetComboItemHeight(txtOpeCs1);
  811. }
  812. private void ultraTabControl3_SelectedTabChanged(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e)
  813. {
  814. UltraGridRow row = ultraGrid2.ActiveRow;
  815. if (row == null) return;
  816. string zYgNo = row.Cells["ZY_PLAN_ID"].Value.ToString();
  817. string woId = row.Cells["WO_ID"].Value.ToString();
  818. if (ultraTabControl3.SelectedTab.Key.Equals("0"))
  819. {
  820. //获取切管实绩
  821. this.getCoupCutResult(zYgNo, woId);
  822. }
  823. else if (ultraTabControl3.SelectedTab.Key.Equals("1"))
  824. { //获取车丝实绩
  825. this.getCoupThreadingResult(zYgNo, woId);
  826. }
  827. else
  828. { //获取喷砂实绩
  829. this.getCoupSandBlast(zYgNo, woId);
  830. }
  831. }
  832. /// <summary>
  833. /// 接箍计划详细
  834. /// </summary>
  835. /// <param name="planNO"></param>
  836. private void getJGCutPlan(string planNo, string woId)
  837. {
  838. DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryWoIdDetails", new object[] { woId, planNo }, this.ob);
  839. if (dt != null && dt.Rows.Count > 0)
  840. {
  841. this.coupWoIdPlanControl1.Value.PlineName = dt.Rows[0]["PLINE_NAME"].ToString();
  842. this.coupWoIdPlanControl1.Value.CutMachGrpNm = dt.Rows[0]["CUT_MACH_GRP_NM"].ToString();
  843. this.coupWoIdPlanControl1.Value.Memo = dt.Rows[0]["MEMO"].ToString();
  844. this.coupWoIdPlanControl1.Value.ZyPlanId = dt.Rows[0]["ZY_PLAN_ID"].ToString();
  845. this.coupWoIdPlanControl1.Value.IfMonitorJg = dt.Rows[0]["IF_MONITOR_JG"].ToString();
  846. this.coupWoIdPlanControl1.Value.LoadPieces = dt.Rows[0]["LOAD_PIECES"].ToString();
  847. this.coupWoIdPlanControl1.Value.LoadWeight = dt.Rows[0]["LOAD_WEIGHT"].ToString();
  848. this.coupWoIdPlanControl1.Value.ProPlanId = dt.Rows[0]["PRO_PLAN_ID"].ToString();
  849. this.coupWoIdPlanControl1.Value.Steelname = dt.Rows[0]["STEELNAME"].ToString();
  850. this.coupWoIdPlanControl1.Value.Gradename = dt.Rows[0]["GRADENAME"].ToString();
  851. this.coupWoIdPlanControl1.Value.JglDesc = dt.Rows[0]["JGL_DESC"].ToString();
  852. this.coupWoIdPlanControl1.Value.CodeJg = dt.Rows[0]["CODE_JG"].ToString();
  853. this.coupWoIdPlanControl1.Value.ModelDesc = dt.Rows[0]["MODEL_DESC"].ToString();
  854. this.coupWoIdPlanControl1.Value.SpecJgDesc = dt.Rows[0]["SPEC_JG_DESC"].ToString();
  855. this.coupWoIdPlanControl1.Value.StyleJg = dt.Rows[0]["STYLE_JG"].ToString();
  856. this.coupWoIdPlanControl1.Value.PlanJgNum = dt.Rows[0]["PLAN_JG_NUM"].ToString();
  857. this.coupWoIdPlanControl1.Value.CsJgNum = dt.Rows[0]["CS_JG_NUM"].ToString();
  858. this.coupWoIdPlanControl1.Value.XqJgNum = dt.Rows[0]["XQ_JG_NUM"].ToString();
  859. this.coupWoIdPlanControl1.Value.InstoreNum = dt.Rows[0]["INSTORE_NUM"].ToString();
  860. this.coupWoIdPlanControl1.Value.BlWlDesc = dt.Rows[0]["BL_WL_DESC"].ToString();
  861. //this.coupWoIdPlanControl1.Value.LoadWeight = "";
  862. this.coupWoIdPlanControl1.UpdateData();
  863. }
  864. }
  865. /// <summary>
  866. /// 结炉
  867. /// </summary>
  868. private void DoBeside()
  869. {
  870. if (ultraTabControl3.SelectedTab.Key.Equals("0"))
  871. {
  872. DoBesideQg();
  873. }
  874. else if (ultraTabControl3.SelectedTab.Key.Equals("1"))
  875. {
  876. DoBesideCs();
  877. }
  878. else
  879. {
  880. DoComplete();
  881. }
  882. }
  883. /// <summary>
  884. /// 撤销结炉
  885. /// </summary>
  886. private void UndoBeside()
  887. {
  888. if (ultraTabControl3.SelectedTab.Key.Equals("0"))
  889. {
  890. UndoBesideQg();
  891. }
  892. else if (ultraTabControl3.SelectedTab.Key.Equals("1"))
  893. {
  894. UndoBesideCs();
  895. }
  896. else
  897. {
  898. UnDoComplete();
  899. }
  900. }
  901. /// <summary>
  902. /// 保存
  903. /// </summary>
  904. private void DoSave()
  905. {
  906. if (ultraTabControl3.SelectedTab.Key.Equals("0"))
  907. {
  908. DoSaveQg();
  909. }
  910. else if (ultraTabControl3.SelectedTab.Key.Equals("1"))
  911. {
  912. DoSaveCs();
  913. }
  914. else
  915. {
  916. DoSavePs();
  917. }
  918. }
  919. /// <summary>
  920. /// 修改
  921. /// </summary>
  922. private void DoUpdate()
  923. {
  924. if (ultraTabControl3.SelectedTab.Key.Equals("0"))
  925. {
  926. DoUpdateQg();
  927. }
  928. else if (ultraTabControl3.SelectedTab.Key.Equals("1"))
  929. {
  930. DoUpdateCs();
  931. }
  932. else
  933. {
  934. DoUpdatePs();
  935. }
  936. }
  937. /// <summary>
  938. /// 删除
  939. /// </summary>
  940. private void DoDelete()
  941. {
  942. if (ultraTabControl3.SelectedTab.Key.Equals("0"))
  943. {
  944. DoDeleteQg();
  945. }
  946. else if (ultraTabControl3.SelectedTab.Key.Equals("1"))
  947. {
  948. DoDeleteCs();
  949. }
  950. else
  951. {
  952. DoDeletePs();
  953. }
  954. }
  955. #region 切管
  956. /// <summary>
  957. /// 切管结炉
  958. /// </summary>
  959. private void DoBesideQg()
  960. {
  961. UltraGridRow uRow = this.ultraGrid2.ActiveRow;
  962. if (uRow == null)
  963. {
  964. MessageUtil.ShowTips("请选择需要结炉的作业工单号!");
  965. return;
  966. }
  967. string zYgNo = uRow.Cells["ZY_PLAN_ID"].Value.ToString();
  968. string woId = uRow.Cells["WO_ID"].Value.ToString();
  969. DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryWoIdDetails", new object[] { woId, zYgNo }, this.ob);
  970. if (dt.Rows[0]["CUT_STATUS"].ToString().Equals("生产完成"))
  971. {
  972. MessageUtil.ShowTips("此工单工序点已结炉,不允许此操作!");
  973. return;
  974. }
  975. if (dt.Rows[0]["ZY_BILL_STATUS"].ToString().Equals("生产完成"))
  976. {
  977. MessageUtil.ShowTips("此工单已结炉,不允许此操作!");
  978. return;
  979. }
  980. ArrayList list = new ArrayList();
  981. list.Add(zYgNo);
  982. list.Add(cutGx);
  983. list.Add(embGx);
  984. list.Add(woId);
  985. //list.Add(rouGx);
  986. if (MessageUtil.ShowYesNoAndQuestion("是否结炉?") == DialogResult.No)
  987. {
  988. return;
  989. }
  990. CoreClientParam ccp = new CoreClientParam();
  991. ccp.ServerName = "com.steering.mes.mcp.coup.CoupCutService";
  992. ccp.MethodName = "doBeside";
  993. ccp.ServerParams = new object[] { list};
  994. ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
  995. if (ccp.ReturnCode != -1)
  996. {
  997. MessageUtil.ShowTips(ccp.ReturnInfo);
  998. if (ccp.ReturnInfo.Equals("结炉成功!"))
  999. {
  1000. QuerySinglePlan();
  1001. }
  1002. }
  1003. }
  1004. /// <summary>
  1005. /// 撤销结炉
  1006. /// </summary>
  1007. private void UndoBesideQg()
  1008. {
  1009. UltraGridRow uRow = this.ultraGrid2.ActiveRow;
  1010. if (uRow == null)
  1011. {
  1012. MessageUtil.ShowTips("请选择需要撤销结炉的作业工单号!");
  1013. return;
  1014. }
  1015. string zYgNo = uRow.Cells["ZY_PLAN_ID"].Value.ToString();
  1016. string woId = uRow.Cells["WO_ID"].Value.ToString();
  1017. DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryWoIdDetails", new object[] { woId, zYgNo }, this.ob);
  1018. if (!dt.Rows[0]["CUT_STATUS"].ToString().Equals("生产完成"))
  1019. {
  1020. MessageUtil.ShowTips("此工单工序点未结炉,不允许此操作!");
  1021. return;
  1022. }
  1023. if (dt.Rows[0]["ZY_BILL_STATUS"].ToString().Equals("生产完成"))
  1024. {
  1025. MessageUtil.ShowTips("此工单状态生产完成,不允许此操作!");
  1026. return;
  1027. }
  1028. ArrayList list = new ArrayList();
  1029. list.Add(zYgNo);
  1030. list.Add(cutGx);
  1031. list.Add(embGx);
  1032. list.Add(woId);
  1033. //list.Add(rouGx);
  1034. if (MessageUtil.ShowYesNoAndQuestion("是否撤销结炉?") == DialogResult.No)
  1035. {
  1036. return;
  1037. }
  1038. CoreClientParam ccp = new CoreClientParam();
  1039. ccp.ServerName = "com.steering.mes.mcp.coup.CoupCutService";
  1040. ccp.MethodName = "undoBeside";
  1041. ccp.ServerParams = new object[] { list };
  1042. ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
  1043. if (ccp.ReturnCode != -1)
  1044. {
  1045. MessageUtil.ShowTips(ccp.ReturnInfo);
  1046. if (ccp.ReturnInfo.Equals("撤销结炉成功!"))
  1047. {
  1048. QuerySinglePlan();
  1049. }
  1050. }
  1051. }
  1052. /// <summary>
  1053. /// 查询接箍切断实绩
  1054. /// </summary>
  1055. /// <param name="planNO"></param>
  1056. private void getCoupCutResult(string planNO,string woId)
  1057. {
  1058. DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.coup.FrmPerformanceResult.getCutResultByPlanNo", new object[] { planNO, woId }, this.ob);
  1059. GridHelper.CopyDataToDatatable(ref dt, ref dataTable1, true);
  1060. }
  1061. /// <summary>
  1062. /// 作业实绩保存
  1063. /// </summary>
  1064. private void DoSaveQg()
  1065. {
  1066. UltraGridRow uRow = this.ultraGrid2.ActiveRow;
  1067. if (uRow == null)
  1068. {
  1069. MessageUtil.ShowTips("无工单信息,不允许此操作!");
  1070. return;
  1071. }
  1072. if (uRow.Cells["ZY_BILL_STATUS"].Value.ToString() == "生产完成")
  1073. {
  1074. MessageUtil.ShowTips("此工单已生产完成,不允许此操作!");
  1075. return;
  1076. }
  1077. string zYgNo = uRow.Cells["ZY_PLAN_ID"].Value.ToString();
  1078. string woId = uRow.Cells["WO_ID"].Value.ToString();
  1079. DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryWoIdDetails", new object[] { woId, zYgNo }, this.ob);
  1080. if (dt.Rows[0]["IF_ALL_OUT_WORK"].ToString().Equals("是"))
  1081. {
  1082. MessageUtil.ShowTips("此工序已经离线,不允许此操作!");
  1083. return;
  1084. }
  1085. if (dt.Rows[0]["CUT_STATUS"].ToString().Equals("生产完成"))
  1086. {
  1087. MessageUtil.ShowTips("此工单工序点已结炉,不允许此操作!");
  1088. return;
  1089. }
  1090. if (double.Parse(numQualified.Value.ToString()) < double.Parse(numRejected.Value.ToString()))
  1091. {
  1092. MessageUtil.ShowTips("废品个数不能大于切管个数!");
  1093. return;
  1094. }
  1095. CutResult cut = new CutResult();
  1096. cut.MachineNo = cmbJcCode.Text.Trim();
  1097. cut.CutPieces = numPieces.Value.ToString();
  1098. cut.QualifiedNumber = numQualified.Value.ToString();
  1099. cut.RejectedPieces = numRejected.Value.ToString();
  1100. cut.RejectedReason = cmbReason.Text.Trim();
  1101. cut.LvalidLength = numLength.Value.ToString();
  1102. cut.ColOperator = cmbOperator.Text.Trim();
  1103. cut.ColShft = txtBC.Value.ToString();
  1104. cut.ColGroup = txtBz.Value.ToString();
  1105. cut.ColUser = txtUser.Text.ToString();
  1106. cut.IsEmbossed = cmbEmbossed.Value.ToString();
  1107. cut.EmbCount = numEmbossed.Value.ToString();
  1108. cut.EmbContent = txtEmbossed.Text.Trim();
  1109. cut.PlanNo = uRow.Cells["ZY_PLAN_ID"].Text.ToString();
  1110. cut.PlineCode = uRow.Cells["PLINE_CODE"].Text.ToString();
  1111. cut.WoId = uRow.Cells["WO_ID"].Text.ToString();
  1112. double PlnCount=0;//计划切割个数
  1113. double CutCount=0;//实际切割个数
  1114. DataTable dt1 = ServerHelper.GetData("com.steering.mes.mcp.coup.PhosphateResultService.queryPlanJg", new Object[] { uRow.Cells["ZY_PLAN_ID"].Text.ToString() }, ob);
  1115. if (dt1.Rows.Count>0)
  1116. {
  1117. PlnCount = Double.Parse(dt1.Rows[0]["CUT_PLN_NUMB"].ToString());
  1118. CutCount = Double.Parse(dt1.Rows[0]["CUT_OK_NUM"].ToString());
  1119. }
  1120. // + Double.Parse(numQualified.Value.ToString())
  1121. if (CutCount > PlnCount)
  1122. {
  1123. if (MessageUtil.ShowYesNoAndQuestion("实际切管个数超过计划切管个数是否新增!") == DialogResult.No) { return; }
  1124. }
  1125. if (MessageUtil.ShowYesNoAndQuestion("是否保存切管记录?") == DialogResult.No)
  1126. {
  1127. return;
  1128. }
  1129. CoreClientParam ccp = new CoreClientParam();
  1130. try
  1131. {
  1132. this.Cursor = Cursors.WaitCursor; //控制鼠标的样式为等待
  1133. if (Constant.WaitingForm == null)
  1134. {
  1135. Constant.WaitingForm = new WaitingForm();
  1136. }
  1137. Constant.WaitingForm.ShowToUser = true;
  1138. Constant.WaitingForm.Show();
  1139. Constant.WaitingForm.Update();
  1140. ccp.ServerName = "com.steering.mes.mcp.coup.CoupCutService";
  1141. ccp.MethodName = "addCutResult";
  1142. ccp.ServerParams = new object[] { cut, cutGx, embGx };
  1143. ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
  1144. this.Cursor = Cursors.Default;
  1145. Constant.WaitingForm.ShowToUser = false;
  1146. Constant.WaitingForm.Close();
  1147. Constant.WaitingForm = null;
  1148. }
  1149. catch (Exception ex)
  1150. {
  1151. this.Cursor = Cursors.Default;
  1152. Constant.WaitingForm.ShowToUser = false;
  1153. Constant.WaitingForm.Close();
  1154. Constant.WaitingForm = null;
  1155. }
  1156. if (ccp.ReturnCode != -1)
  1157. {
  1158. if (ccp.ReturnInfo.Equals("保存成功!"))
  1159. {
  1160. QuerySinglePlan();
  1161. MessageUtil.ShowTips(ccp.ReturnInfo);
  1162. DoClean();
  1163. }
  1164. else
  1165. {
  1166. MessageUtil.ShowTips(ccp.ReturnInfo);
  1167. }
  1168. }
  1169. }
  1170. /// <summary>
  1171. /// 修改
  1172. /// </summary>
  1173. private void DoUpdateQg()
  1174. {
  1175. ultraCut.UpdateData();
  1176. UltraGridRow uRow = this.ultraCut.ActiveRow;
  1177. if (uRow == null) { MessageUtil.ShowTips("切管实绩无数据!"); return; }
  1178. if (uRow.Cells["IF_ALL_OUT_WORK"].Value.ToString().Equals("是"))
  1179. {
  1180. MessageUtil.ShowTips("此工序已经离线,不允许此操作!");
  1181. return;
  1182. }
  1183. UltraGridRow row = this.ultraGrid2.ActiveRow;
  1184. if (row == null)
  1185. {
  1186. MessageUtil.ShowTips("无工单信息,不允许此操作!");
  1187. }
  1188. if (row.Cells["ZY_BILL_STATUS"].Value.ToString() == "生产完成")
  1189. {
  1190. MessageUtil.ShowTips("此工单已生产完成,不允许此操作!");
  1191. return;
  1192. }
  1193. string zYgNo = uRow.Cells["ZY_PLAN_ID"].Value.ToString();
  1194. string woId = uRow.Cells["WO_ID"].Value.ToString();
  1195. DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryWoIdDetails", new object[] { woId, zYgNo }, this.ob);
  1196. if (dt.Rows[0]["CUT_STATUS"].ToString().Equals("生产完成"))
  1197. {
  1198. MessageUtil.ShowTips("此工单工序点已结炉,不允许此操作!");
  1199. return;
  1200. }
  1201. if (double.Parse(numQualified.Value.ToString()) < double.Parse(numRejected.Value.ToString()))
  1202. {
  1203. MessageUtil.ShowTips("废品个数不能大于切管个数!");
  1204. return;
  1205. }
  1206. ArrayList list = new ArrayList();
  1207. list.Add(uRow.Cells["RESULT_NO"].Text.ToString());
  1208. list.Add(uRow.Cells["ZY_PLAN_ID"].Text.ToString());
  1209. list.Add(numQualified.Value.ToString());//加工个数
  1210. list.Add(numPieces.Value.ToString());//加工支数
  1211. list.Add(numRejected.Value.ToString());
  1212. list.Add(cmbReason.Text.ToString());
  1213. list.Add(txtBC.Value.ToString());
  1214. list.Add(txtBz.Value.ToString());
  1215. list.Add(cmbJcCode.Text.Trim());
  1216. list.Add(numLength.Value.ToString());
  1217. list.Add(cmbOperator.Text.Trim());
  1218. list.Add(txtEmbossed.Text.Trim());
  1219. list.Add(numEmbossed.Value.ToString());
  1220. list.Add(uRow.Cells["WO_ID"].Text.ToString());
  1221. double PlnCount = 0;//计划切割个数
  1222. double CutCount = 0;//实际切割个数
  1223. DataTable dt1 = ServerHelper.GetData("com.steering.mes.mcp.coup.PhosphateResultService.queryPlanJg", new Object[] { row.Cells["ZY_PLAN_ID"].Text.ToString() }, ob);
  1224. if (dt1.Rows.Count > 0)
  1225. {
  1226. PlnCount = Double.Parse(dt1.Rows[0]["CUT_PLN_NUMB"].ToString());
  1227. CutCount = Double.Parse(dt1.Rows[0]["CUT_OK_NUM"].ToString());
  1228. }
  1229. // + Double.Parse(numQualified.Value.ToString())
  1230. if (CutCount > PlnCount)
  1231. {
  1232. if (MessageUtil.ShowYesNoAndQuestion("实际切管个数超过计划切管个数是否修改!") == DialogResult.No) { return; }
  1233. }
  1234. if (MessageUtil.ShowYesNoAndQuestion("是否修改切管记录?") == DialogResult.No)
  1235. {
  1236. return;
  1237. }
  1238. CoreClientParam ccp = new CoreClientParam();
  1239. try
  1240. {
  1241. this.Cursor = Cursors.WaitCursor; //控制鼠标的样式为等待
  1242. if (Constant.WaitingForm == null)
  1243. {
  1244. Constant.WaitingForm = new WaitingForm();
  1245. }
  1246. Constant.WaitingForm.ShowToUser = true;
  1247. Constant.WaitingForm.Show();
  1248. Constant.WaitingForm.Update();
  1249. ccp.ServerName = "com.steering.mes.mcp.coup.FrmPerformanceResult";
  1250. ccp.MethodName = "updateCutResult";
  1251. ccp.ServerParams = new object[] { list, cutGx, embGx, row.Cells["ZY_PLAN_ID"].Text.ToString() };
  1252. ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
  1253. this.Cursor = Cursors.Default;
  1254. Constant.WaitingForm.ShowToUser = false;
  1255. Constant.WaitingForm.Close();
  1256. Constant.WaitingForm = null;
  1257. }
  1258. catch (Exception ex)
  1259. {
  1260. this.Cursor = Cursors.Default;
  1261. Constant.WaitingForm.ShowToUser = false;
  1262. Constant.WaitingForm.Close();
  1263. Constant.WaitingForm = null;
  1264. }
  1265. if (ccp.ReturnCode == -1) return;
  1266. MessageUtil.ShowTips(ccp.ReturnInfo);
  1267. if (ccp.ReturnInfo.Equals("修改切管实绩成功!"))
  1268. {
  1269. QuerySinglePlan();
  1270. }
  1271. }
  1272. /// <summary>
  1273. /// 删除
  1274. /// </summary>
  1275. private void DoDeleteQg()
  1276. {
  1277. ultraCut.UpdateData();
  1278. UltraGridRow uRow = this.ultraCut.ActiveRow;
  1279. if (uRow == null) { MessageUtil.ShowTips("切管实绩无数据!"); return; }
  1280. UltraGridRow row = this.ultraGrid2.ActiveRow;
  1281. if (uRow == null)
  1282. {
  1283. MessageUtil.ShowTips("无工单信息,不允许此操作!");
  1284. }
  1285. if (row.Cells["ZY_BILL_STATUS"].Value.ToString() == "生产完成")
  1286. {
  1287. MessageUtil.ShowTips("此工单已生产完成,不允许此操作!");
  1288. return;
  1289. }
  1290. string zYgNo = row.Cells["ZY_PLAN_ID"].Value.ToString();
  1291. string woId = row.Cells["WO_ID"].Value.ToString();
  1292. DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryWoIdDetails", new object[] { woId, zYgNo }, this.ob);
  1293. if (dt.Rows[0]["CUT_STATUS"].ToString().Equals("生产完成"))
  1294. {
  1295. MessageUtil.ShowTips("此工单工序点已结炉,不允许此操作!");
  1296. return;
  1297. }
  1298. ArrayList list1 = new ArrayList();
  1299. int UpdaCount = 0;
  1300. foreach (UltraGridRow ugr in ultraCut.Rows)
  1301. {
  1302. if (Convert.ToBoolean(ugr.Cells["CHECK"].Text) == true)
  1303. {
  1304. if (ugr.Cells["IF_ALL_OUT_WORK"].Value.ToString().Equals("是"))
  1305. {
  1306. MessageUtil.ShowTips("此工序已经离线,不允许此操作!");
  1307. return;
  1308. }
  1309. UpdaCount += 1;
  1310. ArrayList list = new ArrayList();
  1311. list.Add(ugr.Cells["RESULT_NO"].Text.ToString());
  1312. list1.Add(list);
  1313. }
  1314. }
  1315. if (UpdaCount == 0) { MessageUtil.ShowTips("请选择切管数据!"); return; }
  1316. if (MessageUtil.ShowYesNoAndQuestion("是否删除切管记录?") == DialogResult.No)
  1317. {
  1318. return;
  1319. }
  1320. CoreClientParam ccp = new CoreClientParam();
  1321. try
  1322. {
  1323. this.Cursor = Cursors.WaitCursor; //控制鼠标的样式为等待
  1324. if (Constant.WaitingForm == null)
  1325. {
  1326. Constant.WaitingForm = new WaitingForm();
  1327. }
  1328. Constant.WaitingForm.ShowToUser = true;
  1329. Constant.WaitingForm.Show();
  1330. Constant.WaitingForm.Update();
  1331. ccp.ServerName = "com.steering.mes.mcp.coup.CoupCutService";
  1332. ccp.MethodName = "deleteCutResult";
  1333. ccp.ServerParams = new object[] { list1, row.Cells["ZY_PLAN_ID"].Text.ToString(), row.Cells["WO_ID"].Text.ToString() };
  1334. ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
  1335. this.Cursor = Cursors.Default;
  1336. Constant.WaitingForm.ShowToUser = false;
  1337. Constant.WaitingForm.Close();
  1338. Constant.WaitingForm = null;
  1339. }
  1340. catch (Exception ex)
  1341. {
  1342. this.Cursor = Cursors.Default;
  1343. Constant.WaitingForm.ShowToUser = false;
  1344. Constant.WaitingForm.Close();
  1345. Constant.WaitingForm = null;
  1346. }
  1347. if (ccp.ReturnCode == -1) return;
  1348. MessageUtil.ShowTips(ccp.ReturnInfo);
  1349. if (ccp.ReturnInfo.Equals("删除锯切实绩成功!"))
  1350. {
  1351. QuerySinglePlan();
  1352. }
  1353. }
  1354. /// <summary>
  1355. /// 托选
  1356. /// </summary>
  1357. /// <param name="sender"></param>
  1358. /// <param name="e"></param>
  1359. private void ultraGrid4_AfterSelectChange(object sender, AfterSelectChangeEventArgs e)
  1360. {
  1361. try
  1362. {
  1363. ultraPs.UpdateData();
  1364. foreach (UltraGridRow row in ultraCut.Rows)
  1365. {
  1366. row.Cells["CHECK"].Value = row.Selected;
  1367. }
  1368. }
  1369. catch { }
  1370. }
  1371. /// <summary>
  1372. /// 是否压印
  1373. /// </summary>
  1374. /// <param name="sender"></param>
  1375. /// <param name="e"></param>
  1376. private void cmbEmbossed_TextChanged(object sender, EventArgs e)
  1377. {
  1378. if (cmbEmbossed.Text.Equals("是"))
  1379. {
  1380. numEmbossed.Enabled = true;
  1381. txtEmbossed.Enabled = true;
  1382. }
  1383. else
  1384. {
  1385. numEmbossed.Enabled = false;
  1386. txtEmbossed.Enabled = false;
  1387. }
  1388. }
  1389. /// <summary>
  1390. /// 废品
  1391. /// </summary>
  1392. /// <param name="sender"></param>
  1393. /// <param name="e"></param>
  1394. private void numRejected_ValueChanged(object sender, EventArgs e)
  1395. {
  1396. if (numRejected.Value.ToString().Equals("0"))
  1397. {
  1398. cmbReason.Enabled = false;
  1399. }
  1400. else
  1401. {
  1402. cmbReason.Enabled = true;
  1403. }
  1404. }
  1405. private void DoClean()
  1406. {
  1407. cmbJcCode.Text = "";
  1408. cmbOperator.Text = "";
  1409. numPieces.Value = 0;
  1410. numQualified.Value = 0;
  1411. numRejected.Value = 0;
  1412. cmbReason.Text = "";
  1413. txtBC.Value = this.UserInfo.GetUserOrder();
  1414. txtBz.Value = this.UserInfo.GetUserGroup();
  1415. numLength.Value = 0;
  1416. numEmbossed.Value = 0;
  1417. txtEmbossed.Text = "";
  1418. }
  1419. private void numQualified_ValueChanged(object sender, EventArgs e)
  1420. {
  1421. if (cmbEmbossed.Text.ToString().Equals("是")) { numEmbossed.Value = numQualified.Value.ToString(); }
  1422. }
  1423. #endregion
  1424. #region 车丝
  1425. /// <summary>
  1426. /// 车丝实绩保存
  1427. /// </summary>
  1428. private void DoSaveCs()
  1429. {
  1430. UltraGridRow urg = this.ultraGrid2.ActiveRow;
  1431. if (urg == null)
  1432. {
  1433. MessageUtil.ShowTips("无工单信息,不允许此操作!");
  1434. return;
  1435. }
  1436. if (urg.Cells["ZY_BILL_STATUS"].Value.ToString() == "生产完成")
  1437. {
  1438. MessageUtil.ShowTips("此工单已生产完成,不允许此操作!");
  1439. return;
  1440. }
  1441. string zYgNo = urg.Cells["ZY_PLAN_ID"].Value.ToString();
  1442. string woId = urg.Cells["WO_ID"].Value.ToString();
  1443. DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryWoIdDetails", new object[] { woId, zYgNo }, this.ob);
  1444. if (dt.Rows[0]["LATHE_STATUS"].ToString().Equals("生产完成"))
  1445. {
  1446. MessageUtil.ShowTips("此工单车丝工序点已结炉,不允许此操作!");
  1447. return;
  1448. }
  1449. if (Convert.ToInt32(numCsCount.Value.ToString()) != Convert.ToInt32(numCsHg.Value.ToString()) + Convert.ToInt32(numCsFp.Value.ToString()))
  1450. {
  1451. MessageBox.Show("车丝个数=合格个数+废品个数,请查验 ", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
  1452. return;
  1453. }
  1454. ThreadingResult result = new ThreadingResult();
  1455. result.PlanNo = urg.Cells["ZY_PLAN_ID"].Value.ToString();
  1456. result.PlineCode = urg.Cells["PLINE_CODE"].Value.ToString();
  1457. result.ColGroup = txtCsBz.Value.ToString();
  1458. result.ColShft = txtCsBc.Value.ToString();
  1459. result.ColUser = txtUserCs.Text.ToString();
  1460. result.MachineNo = txtJcCs.Text.ToString();
  1461. result.ProducedPcs = numCsCount.Value.ToString();
  1462. result.Producer = cmbCsProducer.Text.ToString();
  1463. result.WoId = urg.Cells["WO_ID"].Value.ToString();
  1464. if (cmbCsProducer.Text.ToString().Trim().Equals(""))
  1465. {
  1466. result.ProducerTime = "";
  1467. }
  1468. else
  1469. {
  1470. result.ProducerTime = ProducerTimeCs.Value.ToString();
  1471. }
  1472. result.ColOperator1 = txtOpeCs.Text.ToString();
  1473. result.ColOperator2 = txtOpeCs1.Text.ToString();
  1474. result.QualiriedPcs = numCsHg.Value.ToString();
  1475. result.RejectedPieces = numCsFp.Value.ToString();
  1476. result.RejectedReason = txtCsFp.Text.ToString();
  1477. double PlnCount = 0;//计划个数
  1478. double CutCount = 0;//实际个数
  1479. DataTable dt1 = ServerHelper.GetData("com.steering.mes.mcp.coup.PhosphateResultService.queryPlanJg", new Object[] { urg.Cells["ZY_PLAN_ID"].Text.ToString() }, ob);
  1480. if (dt1.Rows.Count > 0)
  1481. {
  1482. PlnCount = Double.Parse(dt1.Rows[0]["LATHE_PLN_NUM"].ToString());
  1483. CutCount = Double.Parse(dt1.Rows[0]["LATHE_OK_NUM"].ToString());
  1484. }
  1485. // + Double.Parse(numQualified.Value.ToString())
  1486. if (CutCount > PlnCount)
  1487. {
  1488. if (MessageUtil.ShowYesNoAndQuestion("实际车丝个数超过计划车丝个数是否新增!") == DialogResult.No) { return; }
  1489. }
  1490. if (MessageUtil.ShowYesNoAndQuestion("是否保存车丝记录?") == DialogResult.No)
  1491. {
  1492. return;
  1493. }
  1494. CoreClientParam ccp = new CoreClientParam();
  1495. try
  1496. {
  1497. this.Cursor = Cursors.WaitCursor; //控制鼠标的样式为等待
  1498. if (Constant.WaitingForm == null)
  1499. {
  1500. Constant.WaitingForm = new WaitingForm();
  1501. }
  1502. Constant.WaitingForm.ShowToUser = true;
  1503. Constant.WaitingForm.Show();
  1504. Constant.WaitingForm.Update();
  1505. ccp.ServerName = "com.steering.mes.mcp.coup.CoupThreadingService";
  1506. ccp.MethodName = "addThreadingResult";
  1507. ccp.ServerParams = new object[] { result, csGx };
  1508. ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
  1509. this.Cursor = Cursors.Default;
  1510. Constant.WaitingForm.ShowToUser = false;
  1511. Constant.WaitingForm.Close();
  1512. Constant.WaitingForm = null;
  1513. }
  1514. catch (Exception ex)
  1515. {
  1516. this.Cursor = Cursors.Default;
  1517. Constant.WaitingForm.ShowToUser = false;
  1518. Constant.WaitingForm.Close();
  1519. Constant.WaitingForm = null;
  1520. }
  1521. if (ccp.ReturnCode != -1)
  1522. {
  1523. MessageUtil.ShowTips(ccp.ReturnInfo);
  1524. if (ccp.ReturnInfo.Equals("保存成功!"))
  1525. {
  1526. QuerySinglePlan();
  1527. }
  1528. }
  1529. }
  1530. /// <summary>
  1531. /// 修改
  1532. /// </summary>
  1533. private void DoUpdateCs()
  1534. {
  1535. ultraCs.UpdateData();
  1536. UltraGridRow uRow = this.ultraCs.ActiveRow;
  1537. if (uRow == null) { MessageUtil.ShowTips("车丝实绩无数据!"); return; }
  1538. if (uRow.Cells["IF_ALL_OUT_WORK"].Value.ToString().Equals("是"))
  1539. {
  1540. MessageUtil.ShowTips("此工序已经离线,不允许此操作!");
  1541. return;
  1542. }
  1543. UltraGridRow row = this.ultraGrid2.ActiveRow;
  1544. if (uRow == null)
  1545. {
  1546. MessageUtil.ShowTips("无工单信息,不允许此操作!");
  1547. }
  1548. if (row.Cells["ZY_BILL_STATUS"].Value.ToString() == "生产完成")
  1549. {
  1550. MessageUtil.ShowTips("此工单已生产完成,不允许此操作!");
  1551. return;
  1552. }
  1553. string zYgNo = uRow.Cells["ZY_PLAN_ID"].Value.ToString();
  1554. string woId = uRow.Cells["WO_ID"].Value.ToString();
  1555. DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryWoIdDetails", new object[] { woId, zYgNo }, this.ob);
  1556. if (dt.Rows[0]["LATHE_STATUS"].ToString().Equals("生产完成"))
  1557. {
  1558. MessageUtil.ShowTips("此工单车丝工序点已结炉,不允许此操作!");
  1559. return;
  1560. }
  1561. ArrayList list = new ArrayList();
  1562. if (Convert.ToInt32(numCsCount.Value.ToString()) != Convert.ToInt32(numCsHg.Value.ToString()) + Convert.ToInt32(numCsFp.Value.ToString()))
  1563. {
  1564. MessageBox.Show("车丝个数=合格个数+废品个数,请查验 ", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
  1565. return;
  1566. }
  1567. list.Add(uRow.Cells["RESULT_NO"].Text.ToString());
  1568. list.Add(uRow.Cells["ZY_PLAN_ID"].Text.ToString());
  1569. list.Add(numCsCount.Value.ToString());
  1570. list.Add(numCsHg.Value.ToString());
  1571. list.Add(numCsFp.Text.Trim().ToString());
  1572. list.Add(txtCsFp.Text.ToString());
  1573. list.Add(txtCsBc.Value.ToString());
  1574. list.Add(txtCsBz.Value.ToString());
  1575. list.Add(txtJcCs.Text.ToString());
  1576. list.Add(txtOpeCs.Text.ToString());
  1577. list.Add(txtOpeCs1.Text.ToString());
  1578. list.Add(cmbCsProducer.Text.ToString());
  1579. if (cmbCsProducer.Text.ToString().Equals(""))
  1580. {
  1581. list.Add("");
  1582. }
  1583. else
  1584. {
  1585. list.Add(ProducerTimeCs.Value.ToString());
  1586. }
  1587. list.Add(uRow.Cells["WO_ID"].Text.ToString());
  1588. double PlnCount = 0;//计划个数
  1589. double CutCount = 0;//实际个数
  1590. DataTable dt1 = ServerHelper.GetData("com.steering.mes.mcp.coup.PhosphateResultService.queryPlanJg", new Object[] { row.Cells["ZY_PLAN_ID"].Text.ToString() }, ob);
  1591. if (dt1.Rows.Count > 0)
  1592. {
  1593. PlnCount = Double.Parse(dt1.Rows[0]["LATHE_PLN_NUM"].ToString());
  1594. CutCount = Double.Parse(dt1.Rows[0]["LATHE_OK_NUM"].ToString());
  1595. }
  1596. // + Double.Parse(numQualified.Value.ToString())
  1597. if (CutCount > PlnCount)
  1598. {
  1599. if (MessageUtil.ShowYesNoAndQuestion("实际车丝个数超过计划车丝个数是否修改!") == DialogResult.No) { return; }
  1600. }
  1601. if (MessageUtil.ShowYesNoAndQuestion("是否修改车丝记录?") == DialogResult.No)
  1602. {
  1603. return;
  1604. }
  1605. CoreClientParam ccp = new CoreClientParam();
  1606. try
  1607. {
  1608. this.Cursor = Cursors.WaitCursor; //控制鼠标的样式为等待
  1609. if (Constant.WaitingForm == null)
  1610. {
  1611. Constant.WaitingForm = new WaitingForm();
  1612. }
  1613. Constant.WaitingForm.ShowToUser = true;
  1614. Constant.WaitingForm.Show();
  1615. Constant.WaitingForm.Update();
  1616. ccp.ServerName = "com.steering.mes.mcp.coup.FrmPerformanceResult";
  1617. ccp.MethodName = "updateThreadingResult";
  1618. ccp.ServerParams = new object[] { list, csGx, row.Cells["ZY_PLAN_ID"].Text.ToString() };
  1619. ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
  1620. this.Cursor = Cursors.Default;
  1621. Constant.WaitingForm.ShowToUser = false;
  1622. Constant.WaitingForm.Close();
  1623. Constant.WaitingForm = null;
  1624. }
  1625. catch (Exception ex)
  1626. {
  1627. this.Cursor = Cursors.Default;
  1628. Constant.WaitingForm.ShowToUser = false;
  1629. Constant.WaitingForm.Close();
  1630. Constant.WaitingForm = null;
  1631. }
  1632. if (ccp.ReturnCode == -1) return;
  1633. MessageUtil.ShowTips(ccp.ReturnInfo);
  1634. if (ccp.ReturnInfo.Equals("修改车丝实绩成功!"))
  1635. {
  1636. QuerySinglePlan();
  1637. }
  1638. }
  1639. /// <summary>
  1640. /// 删除
  1641. /// </summary>
  1642. private void DoDeleteCs()
  1643. {
  1644. ultraGrid2.UpdateData();
  1645. UltraGridRow uRow = this.ultraCs.ActiveRow;
  1646. if (uRow == null) { MessageUtil.ShowTips("车丝实绩无数据!"); return; }
  1647. UltraGridRow row = this.ultraGrid2.ActiveRow;
  1648. if (row == null)
  1649. {
  1650. MessageUtil.ShowTips("无工单信息,不允许此操作!");
  1651. }
  1652. if (row.Cells["ZY_BILL_STATUS"].Value.ToString() == "生产完成")
  1653. {
  1654. MessageUtil.ShowTips("此工单已生产完成,不允许此操作!");
  1655. return;
  1656. }
  1657. string zYgNo = uRow.Cells["ZY_PLAN_ID"].Value.ToString();
  1658. string woId = uRow.Cells["WO_ID"].Value.ToString();
  1659. DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryWoIdDetails", new object[] { woId, zYgNo }, this.ob);
  1660. if (dt.Rows[0]["LATHE_STATUS"].ToString().Equals("生产完成"))
  1661. {
  1662. MessageUtil.ShowTips("此工单车丝工序点已结炉,不允许此操作!");
  1663. return;
  1664. }
  1665. ArrayList list1 = new ArrayList();
  1666. int UpdaCount = 0;
  1667. foreach (UltraGridRow ugr in ultraCs.Rows)
  1668. {
  1669. if (Convert.ToBoolean(ugr.Cells["CHECK"].Text) == true)
  1670. {
  1671. if (ugr.Cells["IF_ALL_OUT_WORK"].Value.ToString().Equals("是"))
  1672. {
  1673. MessageUtil.ShowTips("此工序已经离线,不允许此操作!");
  1674. return;
  1675. }
  1676. UpdaCount += 1;
  1677. ArrayList list = new ArrayList();
  1678. list.Add(ugr.Cells["RESULT_NO"].Text.ToString());
  1679. list1.Add(list);
  1680. }
  1681. }
  1682. if (UpdaCount == 0) { MessageUtil.ShowTips("请选择车丝数据!"); return; }
  1683. if (MessageUtil.ShowYesNoAndQuestion("是否删除车丝记录?") == DialogResult.No)
  1684. {
  1685. return;
  1686. }
  1687. CoreClientParam ccp = new CoreClientParam();
  1688. try
  1689. {
  1690. this.Cursor = Cursors.WaitCursor; //控制鼠标的样式为等待
  1691. if (Constant.WaitingForm == null)
  1692. {
  1693. Constant.WaitingForm = new WaitingForm();
  1694. }
  1695. Constant.WaitingForm.ShowToUser = true;
  1696. Constant.WaitingForm.Show();
  1697. Constant.WaitingForm.Update();
  1698. ccp.ServerName = "com.steering.mes.mcp.coup.CoupThreadingService";
  1699. ccp.MethodName = "deleteThreadingResult";
  1700. ccp.ServerParams = new object[] { list1, row.Cells["ZY_PLAN_ID"].Text.ToString(), csGx, row.Cells["WO_ID"].Text.ToString() };
  1701. ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
  1702. this.Cursor = Cursors.Default;
  1703. Constant.WaitingForm.ShowToUser = false;
  1704. Constant.WaitingForm.Close();
  1705. Constant.WaitingForm = null;
  1706. }
  1707. catch (Exception ex)
  1708. {
  1709. this.Cursor = Cursors.Default;
  1710. Constant.WaitingForm.ShowToUser = false;
  1711. Constant.WaitingForm.Close();
  1712. Constant.WaitingForm = null;
  1713. }
  1714. if (ccp.ReturnCode == -1) return;
  1715. MessageUtil.ShowTips(ccp.ReturnInfo);
  1716. if (ccp.ReturnInfo.Equals("删除车丝实绩成功!"))
  1717. {
  1718. QuerySinglePlan();
  1719. }
  1720. }
  1721. /// <summary>
  1722. /// 结炉
  1723. /// </summary>
  1724. private void DoBesideCs()
  1725. {
  1726. UltraGridRow uRow = this.ultraGrid2.ActiveRow;
  1727. if (uRow == null)
  1728. {
  1729. MessageUtil.ShowTips("请选择需要结炉的工单信息!");
  1730. return;
  1731. }
  1732. string zYgNo = uRow.Cells["ZY_PLAN_ID"].Value.ToString();
  1733. string woId = uRow.Cells["WO_ID"].Value.ToString();
  1734. DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryWoIdDetails", new object[] { woId, zYgNo }, this.ob);
  1735. if (dt.Rows[0]["LATHE_STATUS"].ToString().Equals("生产完成"))
  1736. {
  1737. MessageUtil.ShowTips("此工单车丝工序点已结炉,不允许此操作!");
  1738. return;
  1739. } if (dt.Rows[0]["ZY_BILL_STATUS"].ToString().Equals("生产完成"))
  1740. {
  1741. MessageUtil.ShowTips("此工单已结炉,不允许此操作!");
  1742. return;
  1743. }
  1744. ArrayList list = new ArrayList();
  1745. list.Add(zYgNo);
  1746. list.Add(csGx);
  1747. list.Add(woId);
  1748. if (MessageUtil.ShowYesNoAndQuestion("是否结炉?") == DialogResult.No)
  1749. {
  1750. return;
  1751. }
  1752. CoreClientParam ccp = new CoreClientParam();
  1753. ccp.ServerName = "com.steering.mes.mcp.coup.CoupThreadingService";
  1754. ccp.MethodName = "doBeside";
  1755. ccp.ServerParams = new object[] { list };
  1756. ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
  1757. if (ccp.ReturnCode != -1)
  1758. {
  1759. MessageUtil.ShowTips(ccp.ReturnInfo);
  1760. if (ccp.ReturnInfo.Equals("结炉成功!"))
  1761. {
  1762. QuerySinglePlan();
  1763. }
  1764. }
  1765. }
  1766. /// <summary>
  1767. /// 撤销结炉
  1768. /// </summary>
  1769. private void UndoBesideCs()
  1770. {
  1771. UltraGridRow uRow = this.ultraGrid2.ActiveRow;
  1772. if (uRow == null)
  1773. {
  1774. MessageUtil.ShowTips("请选择需要撤销结炉的工单信息!");
  1775. return;
  1776. }
  1777. string zYgNo = uRow.Cells["ZY_PLAN_ID"].Value.ToString();
  1778. string woId = uRow.Cells["WO_ID"].Value.ToString();
  1779. DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryWoIdDetails", new object[] { woId, zYgNo }, this.ob);
  1780. if (!dt.Rows[0]["LATHE_STATUS"].ToString().Equals("生产完成"))
  1781. {
  1782. MessageUtil.ShowTips("此工单车丝工序点未结炉,不允许此操作!");
  1783. return;
  1784. }
  1785. if (dt.Rows[0]["ZY_BILL_STATUS"].ToString().Equals("生产完成"))
  1786. {
  1787. MessageUtil.ShowTips("此工单已结炉,不允许此操作!");
  1788. return;
  1789. }
  1790. ArrayList list = new ArrayList();
  1791. list.Add(zYgNo);
  1792. list.Add(csGx);
  1793. list.Add(woId);
  1794. if (MessageUtil.ShowYesNoAndQuestion("是否撤销结炉?") == DialogResult.No)
  1795. {
  1796. return;
  1797. }
  1798. CoreClientParam ccp = new CoreClientParam();
  1799. ccp.ServerName = "com.steering.mes.mcp.coup.CoupThreadingService";
  1800. ccp.MethodName = "undoBeside";
  1801. ccp.ServerParams = new object[] { list };
  1802. ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
  1803. if (ccp.ReturnCode != -1)
  1804. {
  1805. MessageUtil.ShowTips(ccp.ReturnInfo);
  1806. if (ccp.ReturnInfo.Equals("撤销结炉成功!"))
  1807. {
  1808. QuerySinglePlan();
  1809. }
  1810. }
  1811. }
  1812. /// <summary>
  1813. /// 车丝实绩查询
  1814. /// </summary>
  1815. /// <param name="planNo"></param>
  1816. private void getCoupThreadingResult(string planNo, string woId)
  1817. {
  1818. DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.coup.FrmPerformanceResult.getThreadingResult", new object[] { planNo, woId }, this.ob);
  1819. GridHelper.CopyDataToDatatable(ref dt, ref dtSelfChecked, true);
  1820. }
  1821. private void ultraCs_AfterRowActivate(object sender, EventArgs e)
  1822. {
  1823. UltraGridRow ugr = ultraCs.ActiveRow;
  1824. if (ugr == null) return;
  1825. if (ugr.Cells["IF_ALL_OUT_WORK"].Value.ToString().Equals("否"))
  1826. {
  1827. numCsCount.Value = ugr.Cells["PRODUCED_PCS"].Value.ToString();
  1828. numCsHg.Value = ugr.Cells["QUALIRIED_PCS"].Value.ToString();
  1829. numCsFp.Value = ugr.Cells["REJECTED_PCS"].Value.ToString();
  1830. txtCsFp.Text = ugr.Cells["REJECTED_REASON"].Value.ToString();
  1831. txtCsBc.Text = ugr.Cells["COL_SHIFT"].Value.ToString();
  1832. txtCsBz.Text = ugr.Cells["COL_GROUP"].Value.ToString();
  1833. txtJcCs.Text = ugr.Cells["MACHINE_NO"].Value.ToString();
  1834. txtOpeCs.Text = ugr.Cells["COL_OPERATOR1"].Value.ToString();
  1835. txtOpeCs1.Text = ugr.Cells["COL_OPERATOR2"].Value.ToString();
  1836. cmbCsProducer.Text = ugr.Cells["PRODUCER"].Value.ToString();
  1837. }
  1838. if (!ugr.Cells["PRODUCER"].Value.ToString().Equals(""))
  1839. {
  1840. ProducerTimeCs.Value = DateTime.Parse(ugr.Cells["PRODUCER_TIME"].Value.ToString());
  1841. }
  1842. }
  1843. private void numCsFp_ValueChanged(object sender, EventArgs e)
  1844. {
  1845. if (numCsFp.Value.ToString().Equals("0"))
  1846. {
  1847. txtCsFp.Enabled = false;
  1848. }
  1849. else
  1850. {
  1851. txtCsFp.Enabled = true;
  1852. }
  1853. }
  1854. #endregion
  1855. #region 喷标
  1856. /// <summary>
  1857. /// 查询喷砂实绩
  1858. /// </summary>
  1859. /// <param name="planNo"></param>
  1860. private void getCoupSandBlast(string planNo, string woId)
  1861. {
  1862. DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.coup.FrmPerformanceResult.getCoupSandBlast", new object[] { planNo, woId }, this.ob);
  1863. GridHelper.CopyDataToDatatable(ref dt, ref dataTable4, true);
  1864. }
  1865. /// <summary>
  1866. /// 保存
  1867. /// </summary>
  1868. private void DoSavePs()
  1869. {
  1870. UltraGridRow row = this.ultraGrid2.ActiveRow;
  1871. if (row == null)
  1872. {
  1873. MessageUtil.ShowTips("无工单信息,不允许此操作!");
  1874. return;
  1875. }
  1876. string zYgNo = row.Cells["ZY_PLAN_ID"].Value.ToString();
  1877. string woId = row.Cells["WO_ID"].Value.ToString();
  1878. DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryWoIdDetails", new object[] { woId, zYgNo }, this.ob);
  1879. if (dt.Rows[0]["BLAST_STATUS"].ToString().Equals("生产完成"))
  1880. {
  1881. MessageUtil.ShowTips("此工单喷砂工序点已结炉,不允许此操作!");
  1882. return;
  1883. }
  1884. if (row.Cells["ZY_BILL_STATUS"].Value.ToString().Equals("生产完成"))
  1885. {
  1886. MessageUtil.ShowTips("此炉次计划号整体已生产完成,不允许此操作!");
  1887. return;
  1888. }
  1889. if (row.Cells["IF_OUT_BLAST"].Text.ToString().Equals("无喷砂"))
  1890. {
  1891. MessageUtil.ShowTips("不需要进行此工序!");
  1892. return;
  1893. }
  1894. if (Convert.ToInt32(numCountPs.Value.ToString()) != Convert.ToInt32(numHgPs.Value.ToString()) + Convert.ToInt32(numFpPs.Value.ToString()))
  1895. {
  1896. MessageBox.Show("喷标个数=合格个数+废品总个数,请查验 ", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
  1897. return;
  1898. }
  1899. CouplingSandblastResultEntity sand = new CouplingSandblastResultEntity();
  1900. sand.SprayCount = numCountPs.Value.ToString();
  1901. sand.QualiriedPcs = numHgPs.Value.ToString();
  1902. sand.RejectedPcs = numFpPs.Value.ToString();
  1903. sand.RejectedReason = cmbFpPs.Text.Trim();
  1904. sand.SprayMaterial = cmbPsSpray.Text.ToString();
  1905. sand.ColOperator = txtOpePs.Text.Trim();
  1906. sand.ColShift = txtPsbc.Value.ToString();
  1907. sand.ColGroup = txtPsbz.Value.ToString();
  1908. sand.ColUser = txtUserPs.Text.ToString();
  1909. sand.SprayThick = numCZDPs.Value.ToString();
  1910. sand.SprayEquipment = cmbPsEquipment.Text.ToString();
  1911. sand.SprayPressure = numPsPressure.Value.ToString();
  1912. sand.Memo = txtPsMemo.Text.ToString();
  1913. //sand.IfAllOutWork = row.Cells["IF_ALL_OUT_WORK"].Text.ToString();
  1914. sand.ZyPlanId = row.Cells["ZY_PLAN_ID"].Text.ToString();
  1915. sand.PlineCode = row.Cells["PLINE_CODE"].Text.ToString();
  1916. sand.WoId = row.Cells["WO_ID"].Text.ToString();
  1917. double PlnCount = 0;//计划个数
  1918. double CutCount = 0;//实际个数
  1919. DataTable dt1 = ServerHelper.GetData("com.steering.mes.mcp.coup.PhosphateResultService.queryPlanJg", new Object[] { row.Cells["ZY_PLAN_ID"].Text.ToString() }, ob);
  1920. if (dt1.Rows.Count > 0)
  1921. {
  1922. PlnCount = Double.Parse(dt1.Rows[0]["BLAST_PLN_NUM"].ToString());
  1923. CutCount = Double.Parse(dt1.Rows[0]["BLAST_OK_NUM"].ToString());
  1924. }
  1925. // + Double.Parse(numQualified.Value.ToString())
  1926. if (CutCount > PlnCount)
  1927. {
  1928. if (MessageUtil.ShowYesNoAndQuestion("实际喷砂个数超过计划喷砂个数是否新增!") == DialogResult.No) { return; }
  1929. }
  1930. if (MessageUtil.ShowYesNoAndQuestion("是否保存喷砂记录?") == DialogResult.No)
  1931. {
  1932. return;
  1933. }
  1934. CoreClientParam ccp = new CoreClientParam();
  1935. try
  1936. {
  1937. this.Cursor = Cursors.WaitCursor; //控制鼠标的样式为等待
  1938. if (Constant.WaitingForm == null)
  1939. {
  1940. Constant.WaitingForm = new WaitingForm();
  1941. }
  1942. Constant.WaitingForm.ShowToUser = true;
  1943. Constant.WaitingForm.Show();
  1944. Constant.WaitingForm.Update();
  1945. ccp.ServerName = "com.steering.mes.mcp.coup.FrmSandBlast";
  1946. ccp.MethodName = "addSandResult";
  1947. ccp.ServerParams = new object[] { sand, PsGx };
  1948. ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
  1949. this.Cursor = Cursors.Default;
  1950. Constant.WaitingForm.ShowToUser = false;
  1951. Constant.WaitingForm.Close();
  1952. Constant.WaitingForm = null;
  1953. }
  1954. catch (Exception ex)
  1955. {
  1956. this.Cursor = Cursors.Default;
  1957. Constant.WaitingForm.ShowToUser = false;
  1958. Constant.WaitingForm.Close();
  1959. Constant.WaitingForm = null;
  1960. }
  1961. if (ccp.ReturnCode != -1)
  1962. {
  1963. MessageUtil.ShowTips(ccp.ReturnInfo);
  1964. if (ccp.ReturnInfo.Equals("保存成功!"))
  1965. {
  1966. QuerySinglePlan();
  1967. DoClean();
  1968. }
  1969. }
  1970. }
  1971. /// <summary>
  1972. /// 修改
  1973. /// </summary>
  1974. private void DoUpdatePs()
  1975. {
  1976. UltraGridRow row = this.ultraGrid2.ActiveRow;
  1977. if (row == null)
  1978. {
  1979. MessageUtil.ShowTips("无工单信息,不允许此操作!");
  1980. return;
  1981. }
  1982. UltraGridRow urg = this.ultraPs.ActiveRow;
  1983. if (urg == null)
  1984. {
  1985. MessageUtil.ShowTips("无接箍喷砂实绩,不允许此操作!");
  1986. return;
  1987. }
  1988. if (urg.Cells["IF_ALL_OUT_WORK"].Value.ToString().Equals("是"))
  1989. {
  1990. MessageUtil.ShowTips("此工序已经离线,不允许此操作!");
  1991. return;
  1992. }
  1993. string zYgNo = row.Cells["ZY_PLAN_ID"].Value.ToString();
  1994. string woId = row.Cells["WO_ID"].Value.ToString();
  1995. DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryWoIdDetails", new object[] { woId, zYgNo }, this.ob);
  1996. if (dt.Rows[0]["BLAST_STATUS"].ToString().Equals("生产完成"))
  1997. {
  1998. MessageUtil.ShowTips("此工单喷砂工序点已结炉,不允许此操作!");
  1999. return;
  2000. }
  2001. string time = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
  2002. if (Convert.ToInt32(numPieces.Value.ToString()) != Convert.ToInt32(numQualified.Value.ToString()) + Convert.ToInt32(numRejected.Value.ToString()))
  2003. {
  2004. MessageBox.Show("喷标个数=合格个数+废品总个数,请查验 ", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
  2005. return;
  2006. }
  2007. string resNo = "";
  2008. if (Convert.ToBoolean(urg.Cells["CHK"].Text) == true)
  2009. {
  2010. resNo = urg.Cells["RESULT_NO"].Text.ToString();
  2011. }
  2012. else
  2013. {
  2014. }
  2015. CouplingSandblastResultEntity sand = new CouplingSandblastResultEntity();
  2016. sand.SprayCount = numCountPs.Value.ToString();
  2017. sand.QualiriedPcs = numHgPs.Value.ToString();
  2018. sand.RejectedPcs = numFpPs.Value.ToString();
  2019. sand.RejectedReason = cmbFpPs.Text.Trim();
  2020. sand.SprayMaterial = cmbPsSpray.Text.ToString();
  2021. sand.ColOperator = txtOpePs.Text.Trim();
  2022. sand.ColShift = txtPsbc.Value.ToString();
  2023. sand.ColGroup = txtPsbz.Value.ToString();
  2024. sand.SprayThick = numCZDPs.Value.ToString();
  2025. sand.SprayEquipment = cmbPsEquipment.Text.ToString();
  2026. sand.SprayPressure = numPsPressure.Value.ToString();
  2027. sand.Memo = txtPsMemo.Text.ToString();
  2028. sand.UpdateName = this.UserInfo.GetUserName();
  2029. sand.UpdateTime = time;
  2030. //sand.IfAllOutWork = row.Cells["IF_ALL_OUT_WORK"].Text.ToString();
  2031. sand.ZyPlanId = urg.Cells["ZY_PLAN_ID"].Text.ToString();
  2032. sand.PlineCode = urg.Cells["PLINE_CODE"].Text.ToString();
  2033. sand.ResultNo = urg.Cells["RESULT_NO"].Text.ToString();
  2034. sand.WoId = urg.Cells["WO_ID"].Text.ToString();
  2035. double PlnCount = 0;//计划个数
  2036. double CutCount = 0;//实际个数
  2037. DataTable dt1 = ServerHelper.GetData("com.steering.mes.mcp.coup.PhosphateResultService.queryPlanJg", new Object[] { row.Cells["ZY_PLAN_ID"].Text.ToString() }, ob);
  2038. if (dt1.Rows.Count > 0)
  2039. {
  2040. PlnCount = Double.Parse(dt1.Rows[0]["BLAST_PLN_NUM"].ToString());
  2041. CutCount = Double.Parse(dt1.Rows[0]["BLAST_OK_NUM"].ToString());
  2042. }
  2043. // + Double.Parse(numQualified.Value.ToString())
  2044. if (CutCount > PlnCount)
  2045. {
  2046. if (MessageUtil.ShowYesNoAndQuestion("实际喷砂个数超过计划喷砂个数是否修改!") == DialogResult.No) { return; }
  2047. }
  2048. if (MessageUtil.ShowYesNoAndQuestion("是否修改喷砂记录?") == DialogResult.No)
  2049. {
  2050. return;
  2051. }
  2052. CoreClientParam ccp = new CoreClientParam();
  2053. try
  2054. {
  2055. this.Cursor = Cursors.WaitCursor; //控制鼠标的样式为等待
  2056. if (Constant.WaitingForm == null)
  2057. {
  2058. Constant.WaitingForm = new WaitingForm();
  2059. }
  2060. Constant.WaitingForm.ShowToUser = true;
  2061. Constant.WaitingForm.Show();
  2062. Constant.WaitingForm.Update();
  2063. ccp.ServerName = "com.steering.mes.mcp.coup.FrmSandBlast";
  2064. ccp.MethodName = "updateSandResult";
  2065. ccp.ServerParams = new object[] { sand, PsGx };
  2066. ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
  2067. this.Cursor = Cursors.Default;
  2068. Constant.WaitingForm.ShowToUser = false;
  2069. Constant.WaitingForm.Close();
  2070. Constant.WaitingForm = null;
  2071. }
  2072. catch (Exception ex)
  2073. {
  2074. this.Cursor = Cursors.Default;
  2075. Constant.WaitingForm.ShowToUser = false;
  2076. Constant.WaitingForm.Close();
  2077. Constant.WaitingForm = null;
  2078. }
  2079. if (ccp.ReturnCode != -1)
  2080. {
  2081. MessageUtil.ShowTips(ccp.ReturnInfo);
  2082. if (ccp.ReturnInfo.Equals("修改喷砂实绩成功!"))
  2083. {
  2084. QuerySinglePlan();
  2085. DoClean();
  2086. }
  2087. }
  2088. }
  2089. /// <summary>
  2090. /// 删除
  2091. /// </summary>
  2092. private void DoDeletePs()
  2093. {
  2094. UltraGridRow uRow = this.ultraPs.ActiveRow;
  2095. if (uRow == null) { MessageUtil.ShowTips("喷砂实绩无数据!"); return; }
  2096. UltraGridRow row = this.ultraGrid2.ActiveRow;
  2097. if (uRow == null)
  2098. {
  2099. MessageUtil.ShowTips("无工单信息,不允许此操作!");
  2100. }
  2101. string zYgNo = row.Cells["ZY_PLAN_ID"].Value.ToString();
  2102. string woId = row.Cells["WO_ID"].Value.ToString();
  2103. DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryWoIdDetails", new object[] { woId, zYgNo }, this.ob);
  2104. if (dt.Rows[0]["BLAST_STATUS"].ToString().Equals("生产完成"))
  2105. {
  2106. MessageUtil.ShowTips("此工单喷砂工序点已结炉,不允许此操作!");
  2107. return;
  2108. }
  2109. ArrayList list1 = new ArrayList();
  2110. int UpdaCount = 0;
  2111. foreach (UltraGridRow ugr in ultraPs.Rows)
  2112. {
  2113. if (Convert.ToBoolean(ugr.Cells["CHK"].Text) == true)
  2114. {
  2115. if (ugr.Cells["IF_ALL_OUT_WORK"].Value.ToString().Equals("是"))
  2116. {
  2117. MessageUtil.ShowTips("此工序已经离线,不允许此操作!");
  2118. return;
  2119. }
  2120. UpdaCount += 1;
  2121. ArrayList list = new ArrayList();
  2122. list.Add(ugr.Cells["RESULT_NO"].Text.ToString());
  2123. list1.Add(list);
  2124. }
  2125. }
  2126. if (UpdaCount == 0) { MessageUtil.ShowTips("请选择喷砂数据!"); return; }
  2127. if (MessageUtil.ShowYesNoAndQuestion("是否删除喷砂实绩记录?") == DialogResult.No)
  2128. {
  2129. return;
  2130. }
  2131. CoreClientParam ccp = new CoreClientParam();
  2132. try
  2133. {
  2134. this.Cursor = Cursors.WaitCursor; //控制鼠标的样式为等待
  2135. if (Constant.WaitingForm == null)
  2136. {
  2137. Constant.WaitingForm = new WaitingForm();
  2138. }
  2139. Constant.WaitingForm.ShowToUser = true;
  2140. Constant.WaitingForm.Show();
  2141. Constant.WaitingForm.Update();
  2142. ccp.ServerName = "com.steering.mes.mcp.coup.FrmSandBlast";
  2143. ccp.MethodName = "deleteSandResult";
  2144. ccp.ServerParams = new object[] { list1, PsGx, row.Cells["ZY_PLAN_ID"].Text.ToString(), row.Cells["WO_ID"].Text.ToString() };
  2145. ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
  2146. this.Cursor = Cursors.Default;
  2147. Constant.WaitingForm.ShowToUser = false;
  2148. Constant.WaitingForm.Close();
  2149. Constant.WaitingForm = null;
  2150. }
  2151. catch (Exception ex)
  2152. {
  2153. this.Cursor = Cursors.Default;
  2154. Constant.WaitingForm.ShowToUser = false;
  2155. Constant.WaitingForm.Close();
  2156. Constant.WaitingForm = null;
  2157. }
  2158. if (ccp.ReturnCode != -1)
  2159. {
  2160. MessageUtil.ShowTips(ccp.ReturnInfo);
  2161. if (ccp.ReturnInfo.Equals("删除喷砂实绩成功!"))
  2162. {
  2163. QuerySinglePlan();
  2164. DoClean();
  2165. }
  2166. }
  2167. }
  2168. /// <summary>
  2169. /// 结炉
  2170. /// </summary>
  2171. private void DoComplete()
  2172. {
  2173. UltraGridRow uRow = this.ultraGrid2.ActiveRow;
  2174. if (uRow == null)
  2175. {
  2176. MessageUtil.ShowTips("请选择需要结炉的作业工单号!");
  2177. return;
  2178. }
  2179. string zYgNo = uRow.Cells["ZY_PLAN_ID"].Value.ToString();
  2180. string woId = uRow.Cells["WO_ID"].Value.ToString();
  2181. DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryWoIdDetails", new object[] { woId, zYgNo }, this.ob);
  2182. if (dt.Rows[0]["BLAST_STATUS"].ToString().Equals("生产完成"))
  2183. {
  2184. MessageUtil.ShowTips("此工单喷砂工序点已结炉,不允许此操作!");
  2185. return;
  2186. }
  2187. if (dt.Rows[0]["ZY_BILL_STATUS"].ToString().Equals("生产完成"))
  2188. {
  2189. MessageUtil.ShowTips("此工单已结炉,不允许此操作!");
  2190. return;
  2191. }
  2192. ArrayList list = new ArrayList();
  2193. list.Add(zYgNo);
  2194. list.Add(PsGx);
  2195. list.Add(woId);
  2196. if (MessageUtil.ShowYesNoAndQuestion("是否结炉?") == DialogResult.No)
  2197. {
  2198. return;
  2199. }
  2200. CoreClientParam ccp = new CoreClientParam();
  2201. ccp.ServerName = "com.steering.mes.mcp.coup.FrmSandBlast";
  2202. ccp.MethodName = "doBeside";
  2203. ccp.ServerParams = new object[] { list };
  2204. ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
  2205. if (ccp.ReturnCode != -1)
  2206. {
  2207. MessageUtil.ShowTips(ccp.ReturnInfo);
  2208. if (ccp.ReturnInfo.Equals("结炉成功!"))
  2209. {
  2210. QuerySinglePlan();
  2211. }
  2212. }
  2213. }
  2214. /// <summary>
  2215. /// 撤销结炉
  2216. /// </summary>
  2217. private void UnDoComplete()
  2218. {
  2219. UltraGridRow uRow = this.ultraGrid2.ActiveRow;
  2220. if (uRow == null)
  2221. {
  2222. MessageUtil.ShowTips("请选择需要结炉的作业工单号!");
  2223. return;
  2224. }
  2225. string zYgNo = uRow.Cells["ZY_PLAN_ID"].Value.ToString();
  2226. string woId = uRow.Cells["WO_ID"].Value.ToString();
  2227. DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryWoIdDetails", new object[] { woId, zYgNo }, this.ob);
  2228. if (!dt.Rows[0]["BLAST_STATUS"].ToString().Equals("生产完成"))
  2229. {
  2230. MessageUtil.ShowTips("此工单喷砂工序点未结炉,不允许此操作!");
  2231. return;
  2232. } if (dt.Rows[0]["ZY_BILL_STATUS"].ToString().Equals("生产完成"))
  2233. {
  2234. MessageUtil.ShowTips("此工单已结炉,不允许此操作!");
  2235. return;
  2236. }
  2237. ArrayList list = new ArrayList();
  2238. list.Add(zYgNo);
  2239. list.Add(PsGx);
  2240. list.Add(woId);
  2241. if (MessageUtil.ShowYesNoAndQuestion("是否撤销结炉?") == DialogResult.No)
  2242. {
  2243. return;
  2244. }
  2245. CoreClientParam ccp = new CoreClientParam();
  2246. ccp.ServerName = "com.steering.mes.mcp.coup.FrmSandBlast";
  2247. ccp.MethodName = "undoBeside";
  2248. ccp.ServerParams = new object[] { list };
  2249. ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
  2250. if (ccp.ReturnCode != -1)
  2251. {
  2252. MessageUtil.ShowTips(ccp.ReturnInfo);
  2253. if (ccp.ReturnInfo.Equals("撤销结炉成功!"))
  2254. {
  2255. QuerySinglePlan();
  2256. }
  2257. }
  2258. }
  2259. private void numFpPs_ValueChanged(object sender, EventArgs e)
  2260. {
  2261. }
  2262. private void ultraPs_AfterRowActivate(object sender, EventArgs e)
  2263. {
  2264. UltraGridRow ugr = this.ultraPs.ActiveRow;
  2265. if (ugr == null) return;
  2266. if (ugr.Cells["IF_ALL_OUT_WORK"].Value.ToString().Equals("否"))
  2267. {
  2268. numCountPs.Value = ugr.Cells["SPRAY_COUNT"].Text.ToString();
  2269. numHgPs.Value = ugr.Cells["QUALIRIED_PCS"].Text.ToString();
  2270. numFpPs.Value = ugr.Cells["REJECTED_PCS"].Text.ToString();
  2271. cmbFpPs.Text = ugr.Cells["REJECTED_REASON"].Text.ToString();
  2272. cmbPsSpray.Text = ugr.Cells["SPRAY_MATERIAL"].Text.ToString();
  2273. txtOpePs.Text = ugr.Cells["COL_OPERATOR"].Text.ToString();
  2274. txtPsbc.Text = ugr.Cells["COL_SHIFT"].Value.ToString();
  2275. txtPsbz.Text = ugr.Cells["COL_GROUP"].Value.ToString();
  2276. txtUserPs.Text = ugr.Cells["COL_USER"].Text.ToString();
  2277. numCZDPs.Value = ugr.Cells["SPRAY_THICK"].Text.ToString();
  2278. cmbPsEquipment.Text = ugr.Cells["SPRAY_EQUIPMENT"].Text.ToString();
  2279. numPsPressure.Value = ugr.Cells["SPRAY_PRESSURE"].Text.ToString();
  2280. txtPsMemo.Text = ugr.Cells["MEMO"].Text.ToString();
  2281. }
  2282. else
  2283. {
  2284. DoClean();
  2285. }
  2286. }
  2287. #endregion
  2288. /// <summary>
  2289. /// 按回车键触发查询按钮
  2290. /// </summary>
  2291. /// <param name="sender"></param>
  2292. /// <param name="e"></param>
  2293. private void ContPublic_KeyDown(object sender, KeyEventArgs e)
  2294. {
  2295. if (e.KeyCode == Keys.Enter)
  2296. {
  2297. QuerySinglePlan();
  2298. }
  2299. }
  2300. private void chkStarts_CheckedChanged(object sender, EventArgs e)
  2301. {
  2302. if (chkStarts.Checked) { cmbStarts.Enabled = true; } else { cmbStarts.Enabled = false; }
  2303. if (chkJuNo.Checked) { txtJudgeStoveNO.Enabled = true; } else { txtJudgeStoveNO.Enabled = false; }
  2304. if (chkPlnNo.Checked) { txtPlnNo.Enabled = true; } else { txtPlnNo.Enabled = false; }
  2305. if (chkwoId.Checked) { txtWoId.Enabled = true; } else { txtWoId.Enabled = false; }
  2306. }
  2307. private void ultraCut_AfterRowActivate(object sender, EventArgs e)
  2308. {
  2309. UltraGridRow uRow = this.ultraCut.ActiveRow;
  2310. if (uRow == null) return;
  2311. if (uRow.Cells["IF_ALL_OUT_WORK"].Value.ToString().Equals("否"))
  2312. {
  2313. cmbJcCode.Text = uRow.Cells["MACHINE_NO"].Value.ToString();
  2314. numPieces.Value = uRow.Cells["CUT_PIECES"].Value.ToString();
  2315. numQualified.Value = uRow.Cells["QUALIFIED_NUMBER"].Value.ToString();
  2316. numRejected.Value = uRow.Cells["REJECTED_PCS"].Value.ToString();
  2317. cmbReason.Text = uRow.Cells["REJECTED_REASON"].Value.ToString();
  2318. numLength.Value = uRow.Cells["LVALID_LENGTH"].Value.ToString();
  2319. cmbOperator.Text = uRow.Cells["COL_OPERATOR"].Value.ToString();
  2320. txtBC.Text = uRow.Cells["COL_SHIFT"].Value.ToString();
  2321. txtBz.Text = uRow.Cells["COL_GROUP"].Value.ToString();
  2322. txtUser.Text = uRow.Cells["COL_USER"].Value.ToString();
  2323. cmbEmbossed.Value = uRow.Cells["IS_EMBOSSED"].Value.ToString();
  2324. numEmbossed.Value = uRow.Cells["EMB_COUNT"].Value.ToString();
  2325. txtEmbossed.Text = uRow.Cells["EMB_CONTENT"].Value.ToString();
  2326. }
  2327. }
  2328. }
  2329. }