| 12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484148514861487148814891490149114921493149414951496149714981499150015011502150315041505150615071508150915101511151215131514151515161517151815191520152115221523152415251526152715281529153015311532153315341535153615371538153915401541154215431544154515461547154815491550155115521553155415551556155715581559156015611562156315641565156615671568156915701571157215731574157515761577157815791580158115821583158415851586158715881589159015911592159315941595159615971598159916001601160216031604160516061607160816091610161116121613161416151616161716181619162016211622162316241625162616271628162916301631163216331634163516361637163816391640164116421643164416451646164716481649165016511652165316541655165616571658165916601661166216631664166516661667166816691670167116721673167416751676167716781679168016811682168316841685168616871688168916901691169216931694169516961697169816991700170117021703170417051706170717081709171017111712171317141715171617171718171917201721172217231724172517261727172817291730173117321733173417351736173717381739174017411742174317441745174617471748174917501751175217531754175517561757175817591760176117621763176417651766176717681769177017711772177317741775177617771778177917801781178217831784178517861787178817891790179117921793179417951796179717981799180018011802180318041805180618071808180918101811181218131814181518161817181818191820182118221823182418251826182718281829183018311832183318341835183618371838183918401841184218431844184518461847184818491850185118521853185418551856185718581859186018611862186318641865186618671868186918701871187218731874187518761877187818791880188118821883188418851886188718881889189018911892189318941895189618971898189919001901190219031904190519061907190819091910191119121913191419151916191719181919192019211922192319241925192619271928192919301931193219331934193519361937193819391940194119421943194419451946194719481949195019511952195319541955195619571958195919601961196219631964196519661967196819691970197119721973197419751976197719781979198019811982198319841985198619871988198919901991199219931994199519961997199819992000200120022003200420052006200720082009201020112012201320142015201620172018201920202021202220232024202520262027202820292030203120322033203420352036203720382039204020412042204320442045204620472048204920502051205220532054205520562057205820592060206120622063206420652066206720682069207020712072207320742075207620772078207920802081208220832084208520862087208820892090209120922093209420952096209720982099210021012102210321042105210621072108210921102111211221132114211521162117211821192120212121222123212421252126212721282129213021312132213321342135213621372138213921402141214221432144214521462147214821492150215121522153215421552156215721582159216021612162216321642165216621672168216921702171217221732174217521762177217821792180218121822183218421852186218721882189219021912192219321942195219621972198219922002201220222032204220522062207220822092210221122122213221422152216221722182219222022212222222322242225222622272228222922302231223222332234223522362237223822392240224122422243224422452246224722482249225022512252225322542255225622572258225922602261226222632264226522662267226822692270227122722273227422752276227722782279228022812282228322842285228622872288228922902291229222932294229522962297229822992300230123022303230423052306230723082309231023112312231323142315231623172318231923202321232223232324232523262327232823292330233123322333233423352336233723382339234023412342234323442345234623472348234923502351235223532354235523562357235823592360236123622363236423652366236723682369237023712372237323742375237623772378237923802381238223832384238523862387238823892390239123922393239423952396239723982399240024012402240324042405240624072408240924102411241224132414241524162417241824192420242124222423242424252426242724282429243024312432243324342435243624372438243924402441244224432444244524462447244824492450245124522453245424552456245724582459246024612462246324642465246624672468246924702471247224732474247524762477247824792480248124822483 |
- using System;
- using System.Collections;
- using System.Collections.Generic;
- using System.ComponentModel;
- using System.Data;
- using System.Drawing;
- using System.Linq;
- using System.Text;
- using System.Windows.Forms;
- using CoreFS.CA06;
- using Core.Mes.Client.Comm.Server;
- using Core.Mes.Client.Comm.Control;
- using Core.StlMes.Client.Mcp;
- using com.steering.mes.mcp.entity;
- using Infragistics.Win.UltraWinGrid;
- using Core.StlMes.Client.Mcp.Control;
- using Core.StlMes.Client.Mcp.Common;
- using Core.StlMes.Client.Mcp.Entity;
- using Core.Mes.Client.Comm.Tool;
- using Core.StlMes.Client.Mcp.CollarMaterial;
- using Infragistics.Win;
- using Core.StlMes.Client.Mcp.Coupling;
- namespace Core.StlMes.Client.Coup
- {
- public partial class FrmPerformanceResult : FrmBase
- {
- private string departm = "";//获取部门ID
- private string[] plineCode = null;//获取产线代码
- private string cutGx = "";//切管工序
- private string embGx = "";//压印工序
- //private string rouGx = "";//粗加工工序
- private string csGx = "";//车丝工序
- private string PsGx = "";//喷砂工序
- private string LiXian = "";
- public FrmPerformanceResult()
- {
- InitializeComponent();
- this.IsLoadUserView = true;
- }
- protected override void OnLoad(EventArgs e)
- {
- base.OnLoad(e);
- //禁控件过滤
- this.coupWoIdPlanControl1.Grid.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
- //设置计划区控件只读
- //this.coupWoIdPlanControl1.SetAllColumnsActiveOnly();
- coupWoIdPlanControl1.Ob = this.ob;
- }
- private void FrmPerformanceResult_Load(object sender, EventArgs e)
- {
- departm = UserInfo.GetDeptid();
- plineCode = McpBaseHelper.GetPCodePline(departm, this.ob);
- // McpBaseHelper.InitPlineUnit(cmbCname, plineCode, this.ob);
- //McpBaseHelper.InitPlineUnit(cmbCname, plineCode, this.ob,"H");
- #region 切管
- //获取废品原因
- DataTable dt1 = ServerHelper.GetData("com.steering.mes.mcp.coup.CoupCutService.getCutResultFp", new object[] { "7002" }, this.ob);
- cmbReason.DataSource = dt1;
- cmbReason.ValueMember = "BASENAME";
- YdmBaseClass.SetComboItemHeight(cmbReason);
- txtBz.Value = UserInfo.GetUserGroup();
- txtBC.Value = UserInfo.GetUserOrder();
- txtUser.Text = UserInfo.GetUserName();
- //获取切管工序
- DataTable dt2 = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryGX", new object[] { "700302" }, this.ob);
- if (dt2.Rows.Count > 0)
- {
- cutGx = dt2.Rows[0]["BASECODE"].ToString();
- }
- //获取压印工序
- DataTable dt3 = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryGX", new object[] { "700304" }, this.ob);
- if (dt3.Rows.Count > 0)
- {
- embGx = dt3.Rows[0]["BASECODE"].ToString();
- }
- //获取粗加工工序
- //DataTable dt4 = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryGX", new object[] { "700303" }, this.ob);
- //if (dt4.Rows.Count > 0)
- //{
- // rouGx = dt4.Rows[0]["BASECODE"].ToString();
- //}
- #endregion
- #region 车丝
-
- //获取废品原因
- DataTable dtcs = ServerHelper.GetData("com.steering.mes.mcp.coup.CoupCutService.getCutResultFp", new object[] { "7004" }, this.ob);
- txtCsFp.DataSource = dtcs;
- txtCsFp.ValueMember = "BASENAME";
- YdmBaseClass.SetComboItemHeight(txtCsFp);
- txtCsBz.Value = UserInfo.GetUserGroup();
- txtCsBc.Value = UserInfo.GetUserOrder();
- txtUserCs.Text = UserInfo.GetUserName();
- //获取车丝工序
- DataTable dtcsgx = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryGX", new object[] { "700305" }, this.ob);
- if (dtcsgx.Rows.Count > 0)
- {
- csGx = dtcsgx.Rows[0]["BASECODE"].ToString();
- }
- #endregion
- #region 喷砂
- //获取工序
- DataTable dtps = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryGX", new object[] { "700308" }, this.ob);
- if (dtps.Rows.Count > 0)
- {
- PsGx = dt2.Rows[0]["BASECODE"].ToString();
- }
- txtPsbc.Value = this.UserInfo.GetUserOrder();
- txtPsbz.Value = this.UserInfo.GetUserGroup();
- txtUserPs.Text = this.UserInfo.GetUserName();
- //获取废品原因
- DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.coup.CoupCutService.getCutResultFp", new object[] { "7007" }, this.ob);
- cmbFpPs.DataSource = dt;
- cmbFpPs.ValueMember = "BASENAME";
- YdmBaseClass.SetComboItemHeight(cmbFpPs);
- //获取喷料
- DataTable dt1ps = ServerHelper.GetData("com.steering.mes.mcp.coup.CoupCutService.getCutResultFp", new object[] { "7005" }, this.ob);
- cmbPsSpray.DataSource = dt1ps;
- cmbPsSpray.ValueMember = "BASENAME";
- YdmBaseClass.SetComboItemHeight(cmbPsSpray);
- //获取喷砂设备
- DataTable dt3ps = ServerHelper.GetData("com.steering.mes.mcp.coup.CoupCutService.getCutResultFp", new object[] { "7006" }, this.ob);
- cmbPsEquipment.DataSource = dt3ps;
- cmbPsEquipment.ValueMember = "BASENAME";
- YdmBaseClass.SetComboItemHeight(cmbPsEquipment);
- #endregion
- }
- public override void ToolBar_Click(object sender, string ToolbarKey)
- {
- switch (ToolbarKey)
- {
- case "DoQuery":
- QuerySinglePlan();
- break;
- case "DoSave":
- DoSave();
- break;
- case "DoUpdate":
- DoUpdate();
- break;
- case "DoDelete":
- DoDelete();
- break;
- case "DoBeside"://结炉
- DoBeside();
- break;
- case "UndoBeside"://撤销结炉
- UndoBeside();
- break;
- case "Offline"://离线
- Offline();
- break;
- case "unOffline":
- unOffline();
- break;
- case "DoClose":
- this.Close();
- break;
- }
- }
- private void Offline()
- {
- if (ultraTabControl3.SelectedTab.Key.Equals("0"))
- {
- OfflineQg();
- }
- else if (ultraTabControl3.SelectedTab.Key.Equals("1"))
- {
- OfflineCs();
- }
- else
- {
- OfflinePs();
- }
- }
- //撤销离线
- private void unOffline()
- {
- if (ultraTabControl3.SelectedTab.Key.Equals("0"))
- {
- unOfflineQg();
- }
- else if (ultraTabControl3.SelectedTab.Key.Equals("1"))
- {
- unOfflineCs();
- }
- else
- {
- unOfflinePs();
- }
- }
- private void unOfflineQg()
- {
- ultraCut.UpdateData();
- UltraGridRow uRow = this.ultraCut.ActiveRow;
- if (uRow == null) { MessageUtil.ShowTips("锯切实绩无数据!"); return; }
- UltraGridRow row = this.ultraGrid2.ActiveRow;
- if (uRow == null)
- {
- MessageUtil.ShowTips("无工单信息,不允许此操作!");
- }
- if (row.Cells["ZY_BILL_STATUS"].Value.ToString() == "生产完成")
- {
- MessageUtil.ShowTips("此炉次计划整体已生产完成,不允许此操作!");
- return;
- }
- string zYgNo = uRow.Cells["ZY_PLAN_ID"].Value.ToString();
- string woId = uRow.Cells["WO_ID"].Value.ToString();
- DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryWoIdDetails", new object[] { woId, zYgNo }, this.ob);
- if (dt.Rows[0]["CUT_STATUS"].ToString().Equals("生产完成"))
- {
- MessageUtil.ShowTips("此工单工序点已结炉,不允许此操作!");
- return;
- }
- //if(!QueryStatusGd(row.Cells["WO_ID"].Value.ToString(), row.Cells["ZY_PLAN_ID"].Value.ToString())) return;
- ArrayList list1 = new ArrayList();
- int UpdaCount = 0;
- foreach (UltraGridRow ugr in ultraCut.Rows)
- {
- if (Convert.ToBoolean(ugr.Cells["CHECK"].Text) == true)
- {
- UpdaCount += 1;
- ArrayList list = new ArrayList();
- list.Add(ugr.Cells["RESULT_NO"].Text.ToString());
- list1.Add(list);
- }
- }
- if (UpdaCount == 0) { MessageUtil.ShowTips("请选择离线数据!"); return; }
- if (MessageUtil.ShowYesNoAndQuestion("是否撤销离线?") == DialogResult.No)
- {
- return;
- }
- CoreClientParam ccp = new CoreClientParam();
- try
- {
- this.Cursor = Cursors.WaitCursor; //控制鼠标的样式为等待
- if (Constant.WaitingForm == null)
- {
- Constant.WaitingForm = new WaitingForm();
- }
- Constant.WaitingForm.ShowToUser = true;
- Constant.WaitingForm.Show();
- Constant.WaitingForm.Update();
- ccp.ServerName = "com.steering.mes.mcp.coup.CoupCutService";
- ccp.MethodName = "unlixianThreadingResult";
- ccp.ServerParams = new object[] { list1, row.Cells["ZY_PLAN_ID"].Text.ToString(), row.Cells["WO_ID"].Text.ToString() };
- ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
- this.Cursor = Cursors.Default;
- Constant.WaitingForm.ShowToUser = false;
- Constant.WaitingForm.Close();
- Constant.WaitingForm = null;
- }
- catch (Exception ex)
- {
- this.Cursor = Cursors.Default;
- Constant.WaitingForm.ShowToUser = false;
- Constant.WaitingForm.Close();
- Constant.WaitingForm = null;
- }
- if (ccp.ReturnCode == -1) return;
- MessageUtil.ShowTips(ccp.ReturnInfo);
- if (ccp.ReturnInfo.Equals("撤销离线成功!"))
- {
- QuerySinglePlan();
- }
- }
- private void unOfflinePs()
- {
- ultraPs.UpdateData();
- UltraGridRow uRow = this.ultraPs.ActiveRow;
- if (uRow == null) { MessageUtil.ShowTips("喷砂实绩无数据!"); return; }
- UltraGridRow row = this.ultraGrid2.ActiveRow;
- if (uRow == null)
- {
- MessageUtil.ShowTips("无工单信息,不允许此操作!");
- }
- if (row.Cells["ZY_BILL_STATUS"].Value.ToString() == "生产完成")
- {
- MessageUtil.ShowTips("此炉次计划整体已生产完成,不允许此操作!");
- return;
- }
- string zYgNo = uRow.Cells["ZY_PLAN_ID"].Value.ToString();
- string woId = uRow.Cells["WO_ID"].Value.ToString();
- DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryWoIdDetails", new object[] { woId, zYgNo }, this.ob);
- if (dt.Rows[0]["BLAST_STATUS"].ToString().Equals("生产完成"))
- {
- MessageUtil.ShowTips("此工单工序点已结炉,不允许此操作!");
- return;
- }
- //if(!QueryStatusGd(row.Cells["WO_ID"].Value.ToString(), row.Cells["ZY_PLAN_ID"].Value.ToString())) return;
- ArrayList list1 = new ArrayList();
- int UpdaCount = 0;
- foreach (UltraGridRow ugr in ultraPs.Rows)
- {
- if (Convert.ToBoolean(ugr.Cells["CHK"].Text) == true)
- {
- UpdaCount += 1;
- ArrayList list = new ArrayList();
- list.Add(ugr.Cells["RESULT_NO"].Text.ToString());
- list1.Add(list);
- }
- }
- if (UpdaCount == 0) { MessageUtil.ShowTips("请选择离线数据!"); return; }
- if (MessageUtil.ShowYesNoAndQuestion("是否撤销离线?") == DialogResult.No)
- {
- return;
- }
- CoreClientParam ccp = new CoreClientParam();
- try
- {
- this.Cursor = Cursors.WaitCursor; //控制鼠标的样式为等待
- if (Constant.WaitingForm == null)
- {
- Constant.WaitingForm = new WaitingForm();
- }
- Constant.WaitingForm.ShowToUser = true;
- Constant.WaitingForm.Show();
- Constant.WaitingForm.Update();
- ccp.ServerName = "com.steering.mes.mcp.coup.FrmSandBlast";
- ccp.MethodName = "unlixianThreadingResult";
- ccp.ServerParams = new object[] { list1, row.Cells["ZY_PLAN_ID"].Text.ToString(), row.Cells["WO_ID"].Text.ToString() };
- ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
- this.Cursor = Cursors.Default;
- Constant.WaitingForm.ShowToUser = false;
- Constant.WaitingForm.Close();
- Constant.WaitingForm = null;
- }
- catch (Exception ex)
- {
- this.Cursor = Cursors.Default;
- Constant.WaitingForm.ShowToUser = false;
- Constant.WaitingForm.Close();
- Constant.WaitingForm = null;
- }
- if (ccp.ReturnCode == -1) return;
- MessageUtil.ShowTips(ccp.ReturnInfo);
- if (ccp.ReturnInfo.Equals("撤销离线成功!"))
- {
- QuerySinglePlan();
- }
- }
- private void unOfflineCs()
- {
- ultraCs.UpdateData();
- UltraGridRow uRow = this.ultraCs.ActiveRow;
- if (uRow == null) { MessageUtil.ShowTips("车丝实绩无数据!"); return; }
- UltraGridRow row = this.ultraGrid2.ActiveRow;
- if (uRow == null)
- {
- MessageUtil.ShowTips("无工单信息,不允许此操作!");
- }
- if (row.Cells["ZY_BILL_STATUS"].Value.ToString() == "生产完成")
- {
- MessageUtil.ShowTips("此炉次计划整体已生产完成,不允许此操作!");
- return;
- }
- string zYgNo = uRow.Cells["ZY_PLAN_ID"].Value.ToString();
- string woId = uRow.Cells["WO_ID"].Value.ToString();
- DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryWoIdDetails", new object[] { woId, zYgNo }, this.ob);
- if (dt.Rows[0]["LATHE_STATUS"].ToString().Equals("生产完成"))
- {
- MessageUtil.ShowTips("此工单工序点已结炉,不允许此操作!");
- return;
- }
- //if(!QueryStatusGd(row.Cells["WO_ID"].Value.ToString(), row.Cells["ZY_PLAN_ID"].Value.ToString())) return;
- ArrayList list1 = new ArrayList();
- int UpdaCount = 0;
- foreach (UltraGridRow ugr in ultraCs.Rows)
- {
- if (Convert.ToBoolean(ugr.Cells["CHECK"].Text) == true)
- {
- UpdaCount += 1;
- ArrayList list = new ArrayList();
- list.Add(ugr.Cells["RESULT_NO"].Text.ToString());
- list1.Add(list);
- }
- }
- if (UpdaCount == 0) { MessageUtil.ShowTips("请选择离线数据!"); return; }
- if (MessageUtil.ShowYesNoAndQuestion("是否撤销离线?") == DialogResult.No)
- {
- return;
- }
- CoreClientParam ccp = new CoreClientParam();
- try
- {
- this.Cursor = Cursors.WaitCursor; //控制鼠标的样式为等待
- if (Constant.WaitingForm == null)
- {
- Constant.WaitingForm = new WaitingForm();
- }
- Constant.WaitingForm.ShowToUser = true;
- Constant.WaitingForm.Show();
- Constant.WaitingForm.Update();
- ccp.ServerName = "com.steering.mes.mcp.coup.CoupThreadingService";
- ccp.MethodName = "unlixianThreadingResult";
- ccp.ServerParams = new object[] { list1, row.Cells["ZY_PLAN_ID"].Text.ToString(), row.Cells["WO_ID"].Text.ToString() };
- ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
- this.Cursor = Cursors.Default;
- Constant.WaitingForm.ShowToUser = false;
- Constant.WaitingForm.Close();
- Constant.WaitingForm = null;
- }
- catch (Exception ex)
- {
- this.Cursor = Cursors.Default;
- Constant.WaitingForm.ShowToUser = false;
- Constant.WaitingForm.Close();
- Constant.WaitingForm = null;
- }
- if (ccp.ReturnCode == -1) return;
- MessageUtil.ShowTips(ccp.ReturnInfo);
- if (ccp.ReturnInfo.Equals("撤销离线成功!"))
- {
- QuerySinglePlan();
- }
- }
- private void OfflineQg()
- {
- string _strat = "";
- OffLine frm = new OffLine();
- frm.ShowDialog();
- LiXian = frm.StrNum;
- _strat = frm.Strat;
- if (_strat.Equals("2")) return;
- if (LiXian.Equals("") || LiXian.Equals("0")) { MessageUtil.ShowTips("离线支数不能为空!"); return; }
- UltraGridRow row = ultraGrid2.ActiveRow;
- if (row == null) return;
- if (row.Cells["ZY_BILL_STATUS"].Value.ToString()=="生产完成")
- {
- MessageUtil.ShowTips("此工单状态已生产完成,不允许此操作!");
- return;
- }
- string zYgNo = row.Cells["ZY_PLAN_ID"].Value.ToString();
- string woId = row.Cells["WO_ID"].Value.ToString();
- DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryWoIdDetails", new object[] { woId, zYgNo }, this.ob);
- if (dt.Rows[0]["CUT_STATUS"].ToString().Equals("生产完成"))
- {
- MessageUtil.ShowTips("此工单工序点已结炉,不允许此操作!");
- return;
- }
- string time = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
- ArrayList list = new ArrayList();
- list.Add(LiXian);
- list.Add(row.Cells["WO_ID"].Text.ToString());
- list.Add(row.Cells["JUDGE_STOVE_NO"].Text.ToString());
- list.Add(row.Cells["BATCH_NO"].Text.ToString());
- list.Add(row.Cells["PLINE_CODE"].Text.ToString());
- list.Add(row.Cells["ZY_PLAN_ID"].Text.ToString());
- list.Add(row.Cells["PLINE_NAME"].Text.ToString());
- list.Add(this.UserInfo.GetUserName());
- list.Add(this.UserInfo.GetUserOrder());
- list.Add(this.UserInfo.GetUserGroup());
- list.Add(time);
- CoreClientParam ccp = new CoreClientParam();
- try
- {
- this.Cursor = Cursors.WaitCursor; //控制鼠标的样式为等待
- if (Constant.WaitingForm == null)
- {
- Constant.WaitingForm = new WaitingForm();
- }
- Constant.WaitingForm.ShowToUser = true;
- Constant.WaitingForm.Show();
- Constant.WaitingForm.Update();
- ccp.ServerName = "com.steering.mes.mcp.coup.CoupCutService";
- ccp.MethodName = "lixianThreadingResult";
- ccp.ServerParams = new object[] { list, cutGx };
- ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
- this.Cursor = Cursors.Default;
- Constant.WaitingForm.ShowToUser = false;
- Constant.WaitingForm.Close();
- Constant.WaitingForm = null;
- }
- catch (Exception ex)
- {
- this.Cursor = Cursors.Default;
- Constant.WaitingForm.ShowToUser = false;
- Constant.WaitingForm.Close();
- Constant.WaitingForm = null;
- }
- if (ccp.ReturnCode != -1)
- {
- MessageUtil.ShowTips(ccp.ReturnInfo);
- if (ccp.ReturnInfo.Equals("离线成功!"))
- {
- QuerySinglePlan();
- DoClean();
- }
- }
- }
- private void OfflineCs()
- {
- string _strat = "";
- OffLine frm = new OffLine();
- frm.ShowDialog();
- LiXian = frm.StrNum;
- _strat = frm.Strat;
- if (_strat.Equals("2")) return;
- if (LiXian.Equals("") || LiXian.Equals("0")) { MessageUtil.ShowTips("离线支数不能为空!"); return; }
- UltraGridRow row = ultraGrid2.ActiveRow;
- if (row == null) return;
- if (row.Cells["ZY_BILL_STATUS"].Value.ToString() == "生产完成")
- {
- MessageUtil.ShowTips("此工单状态已生产完成,不允许此操作!");
- return;
- }
- string zYgNo = row.Cells["ZY_PLAN_ID"].Value.ToString();
- string woId = row.Cells["WO_ID"].Value.ToString();
- DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryWoIdDetails", new object[] { woId, zYgNo }, this.ob);
- if (dt.Rows[0]["LATHE_STATUS"].ToString().Equals("生产完成"))
- {
- MessageUtil.ShowTips("此工单车丝工序点已结炉,不允许此操作!");
- return;
- }
- string time = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
- ArrayList list = new ArrayList();
- list.Add(LiXian);
- list.Add(row.Cells["WO_ID"].Text.ToString());
- list.Add(row.Cells["JUDGE_STOVE_NO"].Text.ToString());
- list.Add(row.Cells["BATCH_NO"].Text.ToString());
- list.Add(row.Cells["PLINE_CODE"].Text.ToString());
- list.Add(row.Cells["ZY_PLAN_ID"].Text.ToString());
- list.Add(row.Cells["PLINE_NAME"].Text.ToString());
- list.Add(this.UserInfo.GetUserName());
- list.Add(this.UserInfo.GetUserOrder());
- list.Add(this.UserInfo.GetUserGroup());
- list.Add(time);
- CoreClientParam ccp = new CoreClientParam();
- try
- {
- this.Cursor = Cursors.WaitCursor; //控制鼠标的样式为等待
- if (Constant.WaitingForm == null)
- {
- Constant.WaitingForm = new WaitingForm();
- }
- Constant.WaitingForm.ShowToUser = true;
- Constant.WaitingForm.Show();
- Constant.WaitingForm.Update();
- //ccp.ServerName = "com.steering.mes.mcp.coup.CoupThreadingService";
- //ccp.MethodName = "lixianThreadingResult";
- ccp.ServerName = "com.steering.mes.mcp.coup.CoupThreadingService";
- ccp.MethodName = "lixianThreadingResult";
- ccp.ServerParams = new object[] { list, csGx };
- ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
- this.Cursor = Cursors.Default;
- Constant.WaitingForm.ShowToUser = false;
- Constant.WaitingForm.Close();
- Constant.WaitingForm = null;
- }
- catch (Exception ex)
- {
- this.Cursor = Cursors.Default;
- Constant.WaitingForm.ShowToUser = false;
- Constant.WaitingForm.Close();
- Constant.WaitingForm = null;
- }
- if (ccp.ReturnCode != -1)
- {
- MessageUtil.ShowTips(ccp.ReturnInfo);
- if (ccp.ReturnInfo.Equals("离线成功!"))
- {
- QuerySinglePlan();
- DoClean();
- }
- }
- }
- private void OfflinePs()
- {
- string _strat = "";
- OffLine frm = new OffLine();
- frm.ShowDialog();
- LiXian = frm.StrNum;
- _strat = frm.Strat;
- if (_strat.Equals("2")) return;
- if (LiXian.Equals("") || LiXian.Equals("0")) { MessageUtil.ShowTips("离线支数不能为空!"); return; }
- UltraGridRow row = ultraGrid2.ActiveRow;
- if (row == null) return;
- string zYgNo = row.Cells["ZY_PLAN_ID"].Value.ToString();
- string woId = row.Cells["WO_ID"].Value.ToString();
- DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryWoIdDetails", new object[] { woId, zYgNo }, this.ob);
- if (dt.Rows[0]["BLAST_STATUS"].ToString().Equals("生产完成"))
- {
- MessageUtil.ShowTips("此工单喷砂工序点已结炉,不允许此操作!");
- return;
- }
- string time = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
- ArrayList list = new ArrayList();
- list.Add(LiXian);
- list.Add(row.Cells["WO_ID"].Text.ToString());
- list.Add(row.Cells["JUDGE_STOVE_NO"].Text.ToString());
- list.Add(row.Cells["BATCH_NO"].Text.ToString());
- list.Add(row.Cells["PLINE_CODE"].Text.ToString());
- list.Add(row.Cells["ZY_PLAN_ID"].Text.ToString());
- list.Add(row.Cells["PLINE_NAME"].Text.ToString());
- list.Add(this.UserInfo.GetUserName());
- list.Add(this.UserInfo.GetUserOrder());
- list.Add(this.UserInfo.GetUserGroup());
- list.Add(time);
- CoreClientParam ccp = new CoreClientParam();
- try
- {
- this.Cursor = Cursors.WaitCursor; //控制鼠标的样式为等待
- if (Constant.WaitingForm == null)
- {
- Constant.WaitingForm = new WaitingForm();
- }
- Constant.WaitingForm.ShowToUser = true;
- Constant.WaitingForm.Show();
- Constant.WaitingForm.Update();
- //ccp.ServerName = "com.steering.mes.mcp.coup.CoupThreadingService";
- //ccp.MethodName = "lixianThreadingResult";
- ccp.ServerName = "com.steering.mes.mcp.coup.FrmSandBlast";
- ccp.MethodName = "lixianThreadingResult";
- ccp.ServerParams = new object[] { list, PsGx };
- ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
- this.Cursor = Cursors.Default;
- Constant.WaitingForm.ShowToUser = false;
- Constant.WaitingForm.Close();
- Constant.WaitingForm = null;
- }
- catch (Exception ex)
- {
- this.Cursor = Cursors.Default;
- Constant.WaitingForm.ShowToUser = false;
- Constant.WaitingForm.Close();
- Constant.WaitingForm = null;
- }
- if (ccp.ReturnCode != -1)
- {
- MessageUtil.ShowTips(ccp.ReturnInfo);
- if (ccp.ReturnInfo.Equals("离线成功!"))
- {
- QuerySinglePlan();
- DoClean();
- }
- }
- }
- /// <summary>
- /// 查询作业计划
- /// </summary>
- private void QuerySinglePlan()
- {
- string woId = "";
- string[] starts = { };
- string judgeStoveNo = "";
- string plnNo = "";
- #region 条件
- if (chkStarts.Checked)
- {
- if (string.IsNullOrEmpty(cmbStarts.Text.Trim()))
- {
- MessageUtil.ShowTips("请选择工单状态!");
- return;
- }
- else
- {
- starts = (cmbStarts.Value as List<object>).Select(p => p.ToString().Trim()).ToArray();
- }
- }
- if (chkwoId.Checked && string.IsNullOrEmpty(txtWoId.Text.Trim()))
- {
- MessageUtil.ShowTips("请输入工单号!");
- return;
- }
- else
- {
- woId = txtWoId.Text.ToString().Trim();
- }
- if (chkPlnNo.Checked && string.IsNullOrEmpty(txtPlnNo.Text.Trim()))
- {
- MessageUtil.ShowTips("请输入炉次计划号!");
- return;
- }
- else
- {
- plnNo = txtPlnNo.Text.ToString().Trim();
- }
- if (chkJuNo.Checked && string.IsNullOrEmpty(txtJudgeStoveNO.Text.Trim()))
- {
- MessageUtil.ShowTips("请输入炉号!");
- return;
- }
- else
- {
- judgeStoveNo = txtJudgeStoveNO.Text.ToString().Trim();
- }
- #endregion
- ArrayList list = new ArrayList();
- list.Add(woId);
- list.Add(plnNo);
- list.Add(judgeStoveNo);
- list.Add(starts);
- DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryWoId", new object[] { list, plineCode[0].ToString() }, this.ob);
- GridHelper.CopyDataToDatatable(ref dt, ref dtProcessPlan, true);
- // GridHelper.RefreshAndAutoSize(ultraGridWoId);
- //string pliNo = "";
- //if (cmbCname.SelectedIndex != -1) { pliNo = cmbCname.Value.ToString(); } else { pliNo = ""; }
- //string judgeStoveNo = this.txtJudgeStoveNO.Text.ToString();
- //string batchNo = this.txtBatchNO.Text;
- //string zYgNo = this.txtLotNo.Text.Trim();
- //ArrayList list = new ArrayList();
- //list.Add(zYgNo);
- //list.Add(judgeStoveNo);
- //list.Add(batchNo);
- //DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.coup.CoupCutService.doQueryZygNo", new object[] { list, pliNo }, this.ob);
- //GridHelper.CopyDataToDatatable(ref dt, ref dtPlan, true);
- Information();
- }
- private void Information()
- {
- string woId = "";
- string starts = "";
- string judgeStoveNo = "";
- string plnNo = "";
- ArrayList list = new ArrayList();
- list.Add(woId);
- list.Add(plnNo);
- list.Add(judgeStoveNo);
- list.Add(starts);
- DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.ulgetQueryWoId", new object[] { list, plineCode[0].ToString() }, this.ob);
- GridHelper.CopyDataToDatatable(ref dt, ref dataTable2, true);
- GridHelper.RefreshAndAutoSize(ultraGrid3);
- }
- private void ultraGrid2_AfterRowActivate(object sender, EventArgs e)
- {
- this.ultraGrid2AfterRowActivate();
- }
- /// <summary>
- /// 作业计划详情
- /// </summary>
- private void ultraGrid2AfterRowActivate()
- {
- UltraGridRow row = ultraGrid2.ActiveRow;
- ////获取上料实绩
- string zYgNo = row.Cells["ZY_PLAN_ID"].Value.ToString();
- string woId = row.Cells["WO_ID"].Value.ToString();
- //string plNo = row.Cells["PLINE_CODE"].Value.ToString();
- //DataTable dt1 = ServerHelper.GetData("com.steering.mes.mcp.coup.CoupCutService.getCoupLingById", new object[] { zYgNo, plNo }, this.ob);
- //GridHelper.CopyDataToDatatable(ref dt1, ref dtLoadRecord, true);
- //GridHelper.RefreshAndAutoSize(ultraGrid1);
- //获取计划
- getJGCutPlan(zYgNo, woId);
- #region 切管
- //获取机床编号
- ArrayList list = new ArrayList();
- list.Add(cutGx);
- list.Add(row.Cells["PLINE_CODE"].Text.ToString());
- list.Add(row.Cells["CUT_MACH_GRP_NM"].Text.ToString());
- DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.coup.CoupCutService.getMachine", new object[] { list }, this.ob);
- cmbJcCode.DataSource = dt;
- cmbJcCode.ValueMember = "MACHINE_NAME";
- YdmBaseClass.SetComboItemHeight(cmbJcCode);
- cmbEmbossed.Text = row.Cells["IF_IMPRESS"].Text.ToString();//压印
- #endregion
- #region 车丝
- //获取机床编号
- ArrayList list1 = new ArrayList();
- list1.Add(csGx);
- list1.Add(row.Cells["PLINE_CODE"].Text.ToString());
- list1.Add(row.Cells["LATHE_GRP_NM"].Text.ToString());
- DataTable dt2 = ServerHelper.GetData("com.steering.mes.mcp.coup.CoupThreadingService.getMachine", new object[] { list1 }, this.ob);
- txtJcCs.DataSource = dt2;
- txtJcCs.ValueMember = "MACHINE_NAME";
- YdmBaseClass.SetComboItemHeight(txtJcCs);
- #endregion
-
- if (ultraTabControl3.SelectedTab.Key.Equals("0"))
- {
- //获取切管实绩
- this.getCoupCutResult(zYgNo, woId);
- }
- else if (ultraTabControl3.SelectedTab.Key.Equals("1"))
- { //获取车丝实绩
- this.getCoupThreadingResult(zYgNo, woId);
- }
- else
- { //获取喷砂实绩
- this.getCoupSandBlast(zYgNo, woId);
- }
- }
- /// <summary>
- /// 机床编号改变事件
- /// </summary>
- /// <param name="sender"></param>
- /// <param name="e"></param>
- ///查询操作工,根据机床编号
- private void cmbJcCode_TextChanged(object sender, EventArgs e)
- {
- UltraGridRow row = this.ultraGrid2.ActiveRow;
- if (row == null) return;
- 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);
- cmbOperator.DataSource = dt;
- cmbOperator.ValueMember = "MACHINE_USER1";
- YdmBaseClass.SetComboItemHeight(cmbOperator);
- }
- private void txtJcCs_TextChanged(object sender, EventArgs e)
- {
- UltraGridRow row = this.ultraGrid2.ActiveRow;
- if (row == null) return;
- 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);
- txtOpeCs.DataSource = dt;
- txtOpeCs.ValueMember = "MACHINE_USER1";
- YdmBaseClass.SetComboItemHeight(txtOpeCs);
- Operator();
- }
- private void Operator()
- {
- UltraGridRow row = this.ultraGrid2.ActiveRow;
- if (row == null) return;
- 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);
- txtOpeCs1.DataSource = dt;
- txtOpeCs1.ValueMember = "MACHINE_USER2";
- YdmBaseClass.SetComboItemHeight(txtOpeCs1);
- }
-
- private void ultraTabControl3_SelectedTabChanged(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e)
- {
- UltraGridRow row = ultraGrid2.ActiveRow;
- if (row == null) return;
- string zYgNo = row.Cells["ZY_PLAN_ID"].Value.ToString();
- string woId = row.Cells["WO_ID"].Value.ToString();
- if (ultraTabControl3.SelectedTab.Key.Equals("0"))
- {
- //获取切管实绩
- this.getCoupCutResult(zYgNo, woId);
- }
- else if (ultraTabControl3.SelectedTab.Key.Equals("1"))
- { //获取车丝实绩
- this.getCoupThreadingResult(zYgNo, woId);
- }
- else
- { //获取喷砂实绩
- this.getCoupSandBlast(zYgNo, woId);
- }
- }
-
- /// <summary>
- /// 接箍计划详细
- /// </summary>
- /// <param name="planNO"></param>
- private void getJGCutPlan(string planNo, string woId)
- {
- DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryWoIdDetails", new object[] { woId, planNo }, this.ob);
- if (dt != null && dt.Rows.Count > 0)
- {
- this.coupWoIdPlanControl1.Value.PlineName = dt.Rows[0]["PLINE_NAME"].ToString();
- this.coupWoIdPlanControl1.Value.CutMachGrpNm = dt.Rows[0]["CUT_MACH_GRP_NM"].ToString();
- this.coupWoIdPlanControl1.Value.Memo = dt.Rows[0]["MEMO"].ToString();
- this.coupWoIdPlanControl1.Value.ZyPlanId = dt.Rows[0]["ZY_PLAN_ID"].ToString();
- this.coupWoIdPlanControl1.Value.IfMonitorJg = dt.Rows[0]["IF_MONITOR_JG"].ToString();
- this.coupWoIdPlanControl1.Value.LoadPieces = dt.Rows[0]["LOAD_PIECES"].ToString();
- this.coupWoIdPlanControl1.Value.LoadWeight = dt.Rows[0]["LOAD_WEIGHT"].ToString();
- this.coupWoIdPlanControl1.Value.ProPlanId = dt.Rows[0]["PRO_PLAN_ID"].ToString();
- this.coupWoIdPlanControl1.Value.Steelname = dt.Rows[0]["STEELNAME"].ToString();
- this.coupWoIdPlanControl1.Value.Gradename = dt.Rows[0]["GRADENAME"].ToString();
- this.coupWoIdPlanControl1.Value.JglDesc = dt.Rows[0]["JGL_DESC"].ToString();
- this.coupWoIdPlanControl1.Value.CodeJg = dt.Rows[0]["CODE_JG"].ToString();
- this.coupWoIdPlanControl1.Value.ModelDesc = dt.Rows[0]["MODEL_DESC"].ToString();
- this.coupWoIdPlanControl1.Value.SpecJgDesc = dt.Rows[0]["SPEC_JG_DESC"].ToString();
- this.coupWoIdPlanControl1.Value.StyleJg = dt.Rows[0]["STYLE_JG"].ToString();
- this.coupWoIdPlanControl1.Value.PlanJgNum = dt.Rows[0]["PLAN_JG_NUM"].ToString();
- this.coupWoIdPlanControl1.Value.CsJgNum = dt.Rows[0]["CS_JG_NUM"].ToString();
- this.coupWoIdPlanControl1.Value.XqJgNum = dt.Rows[0]["XQ_JG_NUM"].ToString();
- this.coupWoIdPlanControl1.Value.InstoreNum = dt.Rows[0]["INSTORE_NUM"].ToString();
- this.coupWoIdPlanControl1.Value.BlWlDesc = dt.Rows[0]["BL_WL_DESC"].ToString();
- //this.coupWoIdPlanControl1.Value.LoadWeight = "";
- this.coupWoIdPlanControl1.UpdateData();
- }
- }
- /// <summary>
- /// 结炉
- /// </summary>
- private void DoBeside()
- {
- if (ultraTabControl3.SelectedTab.Key.Equals("0"))
- {
- DoBesideQg();
- }
- else if (ultraTabControl3.SelectedTab.Key.Equals("1"))
- {
- DoBesideCs();
- }
- else
- {
- DoComplete();
- }
- }
- /// <summary>
- /// 撤销结炉
- /// </summary>
- private void UndoBeside()
- {
- if (ultraTabControl3.SelectedTab.Key.Equals("0"))
- {
- UndoBesideQg();
- }
- else if (ultraTabControl3.SelectedTab.Key.Equals("1"))
- {
- UndoBesideCs();
- }
- else
- {
- UnDoComplete();
- }
- }
- /// <summary>
- /// 保存
- /// </summary>
- private void DoSave()
- {
- if (ultraTabControl3.SelectedTab.Key.Equals("0"))
- {
- DoSaveQg();
- }
- else if (ultraTabControl3.SelectedTab.Key.Equals("1"))
- {
- DoSaveCs();
- }
- else
- {
- DoSavePs();
- }
- }
- /// <summary>
- /// 修改
- /// </summary>
- private void DoUpdate()
- {
- if (ultraTabControl3.SelectedTab.Key.Equals("0"))
- {
- DoUpdateQg();
- }
- else if (ultraTabControl3.SelectedTab.Key.Equals("1"))
- {
- DoUpdateCs();
- }
- else
- {
- DoUpdatePs();
- }
- }
- /// <summary>
- /// 删除
- /// </summary>
- private void DoDelete()
- {
- if (ultraTabControl3.SelectedTab.Key.Equals("0"))
- {
- DoDeleteQg();
- }
- else if (ultraTabControl3.SelectedTab.Key.Equals("1"))
- {
- DoDeleteCs();
- }
- else
- {
- DoDeletePs();
- }
- }
- #region 切管
- /// <summary>
- /// 切管结炉
- /// </summary>
- private void DoBesideQg()
- {
- UltraGridRow uRow = this.ultraGrid2.ActiveRow;
- if (uRow == null)
- {
- MessageUtil.ShowTips("请选择需要结炉的作业工单号!");
- return;
- }
- string zYgNo = uRow.Cells["ZY_PLAN_ID"].Value.ToString();
- string woId = uRow.Cells["WO_ID"].Value.ToString();
- DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryWoIdDetails", new object[] { woId, zYgNo }, this.ob);
- if (dt.Rows[0]["CUT_STATUS"].ToString().Equals("生产完成"))
- {
- MessageUtil.ShowTips("此工单工序点已结炉,不允许此操作!");
- return;
- }
- if (dt.Rows[0]["ZY_BILL_STATUS"].ToString().Equals("生产完成"))
- {
- MessageUtil.ShowTips("此工单已结炉,不允许此操作!");
- return;
- }
- ArrayList list = new ArrayList();
- list.Add(zYgNo);
- list.Add(cutGx);
- list.Add(embGx);
- list.Add(woId);
- //list.Add(rouGx);
- if (MessageUtil.ShowYesNoAndQuestion("是否结炉?") == DialogResult.No)
- {
- return;
- }
- CoreClientParam ccp = new CoreClientParam();
- ccp.ServerName = "com.steering.mes.mcp.coup.CoupCutService";
- ccp.MethodName = "doBeside";
- ccp.ServerParams = new object[] { list};
- ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
- if (ccp.ReturnCode != -1)
- {
- MessageUtil.ShowTips(ccp.ReturnInfo);
- if (ccp.ReturnInfo.Equals("结炉成功!"))
- {
- QuerySinglePlan();
-
- }
- }
- }
- /// <summary>
- /// 撤销结炉
- /// </summary>
- private void UndoBesideQg()
- {
- UltraGridRow uRow = this.ultraGrid2.ActiveRow;
- if (uRow == null)
- {
- MessageUtil.ShowTips("请选择需要撤销结炉的作业工单号!");
- return;
- }
- string zYgNo = uRow.Cells["ZY_PLAN_ID"].Value.ToString();
- string woId = uRow.Cells["WO_ID"].Value.ToString();
- DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryWoIdDetails", new object[] { woId, zYgNo }, this.ob);
- if (!dt.Rows[0]["CUT_STATUS"].ToString().Equals("生产完成"))
- {
- MessageUtil.ShowTips("此工单工序点未结炉,不允许此操作!");
- return;
- }
- if (dt.Rows[0]["ZY_BILL_STATUS"].ToString().Equals("生产完成"))
- {
- MessageUtil.ShowTips("此工单状态生产完成,不允许此操作!");
- return;
- }
- ArrayList list = new ArrayList();
- list.Add(zYgNo);
- list.Add(cutGx);
- list.Add(embGx);
- list.Add(woId);
- //list.Add(rouGx);
- if (MessageUtil.ShowYesNoAndQuestion("是否撤销结炉?") == DialogResult.No)
- {
- return;
- }
- CoreClientParam ccp = new CoreClientParam();
- ccp.ServerName = "com.steering.mes.mcp.coup.CoupCutService";
- ccp.MethodName = "undoBeside";
- ccp.ServerParams = new object[] { list };
- ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
- if (ccp.ReturnCode != -1)
- {
- MessageUtil.ShowTips(ccp.ReturnInfo);
- if (ccp.ReturnInfo.Equals("撤销结炉成功!"))
- {
- QuerySinglePlan();
- }
- }
- }
- /// <summary>
- /// 查询接箍切断实绩
- /// </summary>
- /// <param name="planNO"></param>
- private void getCoupCutResult(string planNO,string woId)
- {
- DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.coup.FrmPerformanceResult.getCutResultByPlanNo", new object[] { planNO, woId }, this.ob);
- GridHelper.CopyDataToDatatable(ref dt, ref dataTable1, true);
- }
-
-
- /// <summary>
- /// 作业实绩保存
- /// </summary>
- private void DoSaveQg()
- {
- UltraGridRow uRow = this.ultraGrid2.ActiveRow;
- if (uRow == null)
- {
- MessageUtil.ShowTips("无工单信息,不允许此操作!");
- return;
- }
- if (uRow.Cells["ZY_BILL_STATUS"].Value.ToString() == "生产完成")
- {
- MessageUtil.ShowTips("此工单已生产完成,不允许此操作!");
- return;
- }
- string zYgNo = uRow.Cells["ZY_PLAN_ID"].Value.ToString();
- string woId = uRow.Cells["WO_ID"].Value.ToString();
- DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryWoIdDetails", new object[] { woId, zYgNo }, this.ob);
- if (dt.Rows[0]["IF_ALL_OUT_WORK"].ToString().Equals("是"))
- {
- MessageUtil.ShowTips("此工序已经离线,不允许此操作!");
- return;
- }
- if (dt.Rows[0]["CUT_STATUS"].ToString().Equals("生产完成"))
- {
- MessageUtil.ShowTips("此工单工序点已结炉,不允许此操作!");
- return;
- }
- if (double.Parse(numQualified.Value.ToString()) < double.Parse(numRejected.Value.ToString()))
- {
- MessageUtil.ShowTips("废品个数不能大于切管个数!");
- return;
- }
- CutResult cut = new CutResult();
- cut.MachineNo = cmbJcCode.Text.Trim();
- cut.CutPieces = numPieces.Value.ToString();
- cut.QualifiedNumber = numQualified.Value.ToString();
- cut.RejectedPieces = numRejected.Value.ToString();
- cut.RejectedReason = cmbReason.Text.Trim();
- cut.LvalidLength = numLength.Value.ToString();
- cut.ColOperator = cmbOperator.Text.Trim();
- cut.ColShft = txtBC.Value.ToString();
- cut.ColGroup = txtBz.Value.ToString();
- cut.ColUser = txtUser.Text.ToString();
- cut.IsEmbossed = cmbEmbossed.Value.ToString();
- cut.EmbCount = numEmbossed.Value.ToString();
- cut.EmbContent = txtEmbossed.Text.Trim();
- cut.PlanNo = uRow.Cells["ZY_PLAN_ID"].Text.ToString();
- cut.PlineCode = uRow.Cells["PLINE_CODE"].Text.ToString();
- cut.WoId = uRow.Cells["WO_ID"].Text.ToString();
- double PlnCount=0;//计划切割个数
- double CutCount=0;//实际切割个数
- DataTable dt1 = ServerHelper.GetData("com.steering.mes.mcp.coup.PhosphateResultService.queryPlanJg", new Object[] { uRow.Cells["ZY_PLAN_ID"].Text.ToString() }, ob);
- if (dt1.Rows.Count>0)
- {
- PlnCount = Double.Parse(dt1.Rows[0]["CUT_PLN_NUMB"].ToString());
- CutCount = Double.Parse(dt1.Rows[0]["CUT_OK_NUM"].ToString());
- }
- // + Double.Parse(numQualified.Value.ToString())
- if (CutCount > PlnCount)
- {
- if (MessageUtil.ShowYesNoAndQuestion("实际切管个数超过计划切管个数是否新增!") == DialogResult.No) { return; }
- }
- if (MessageUtil.ShowYesNoAndQuestion("是否保存切管记录?") == DialogResult.No)
- {
- return;
- }
- CoreClientParam ccp = new CoreClientParam();
- try
- {
- this.Cursor = Cursors.WaitCursor; //控制鼠标的样式为等待
- if (Constant.WaitingForm == null)
- {
- Constant.WaitingForm = new WaitingForm();
- }
- Constant.WaitingForm.ShowToUser = true;
- Constant.WaitingForm.Show();
- Constant.WaitingForm.Update();
- ccp.ServerName = "com.steering.mes.mcp.coup.CoupCutService";
- ccp.MethodName = "addCutResult";
- ccp.ServerParams = new object[] { cut, cutGx, embGx };
- ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
- this.Cursor = Cursors.Default;
- Constant.WaitingForm.ShowToUser = false;
- Constant.WaitingForm.Close();
- Constant.WaitingForm = null;
- }
- catch (Exception ex)
- {
- this.Cursor = Cursors.Default;
- Constant.WaitingForm.ShowToUser = false;
- Constant.WaitingForm.Close();
- Constant.WaitingForm = null;
- }
- if (ccp.ReturnCode != -1)
- {
- if (ccp.ReturnInfo.Equals("保存成功!"))
- {
- QuerySinglePlan();
- MessageUtil.ShowTips(ccp.ReturnInfo);
- DoClean();
- }
- else
- {
- MessageUtil.ShowTips(ccp.ReturnInfo);
- }
- }
- }
- /// <summary>
- /// 修改
- /// </summary>
- private void DoUpdateQg()
- {
- ultraCut.UpdateData();
- UltraGridRow uRow = this.ultraCut.ActiveRow;
- if (uRow == null) { MessageUtil.ShowTips("切管实绩无数据!"); return; }
- if (uRow.Cells["IF_ALL_OUT_WORK"].Value.ToString().Equals("是"))
- {
- MessageUtil.ShowTips("此工序已经离线,不允许此操作!");
- return;
- }
- UltraGridRow row = this.ultraGrid2.ActiveRow;
- if (row == null)
- {
- MessageUtil.ShowTips("无工单信息,不允许此操作!");
- }
- if (row.Cells["ZY_BILL_STATUS"].Value.ToString() == "生产完成")
- {
- MessageUtil.ShowTips("此工单已生产完成,不允许此操作!");
- return;
- }
- string zYgNo = uRow.Cells["ZY_PLAN_ID"].Value.ToString();
- string woId = uRow.Cells["WO_ID"].Value.ToString();
- DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryWoIdDetails", new object[] { woId, zYgNo }, this.ob);
- if (dt.Rows[0]["CUT_STATUS"].ToString().Equals("生产完成"))
- {
- MessageUtil.ShowTips("此工单工序点已结炉,不允许此操作!");
- return;
- }
- if (double.Parse(numQualified.Value.ToString()) < double.Parse(numRejected.Value.ToString()))
- {
- MessageUtil.ShowTips("废品个数不能大于切管个数!");
- return;
- }
- ArrayList list = new ArrayList();
- list.Add(uRow.Cells["RESULT_NO"].Text.ToString());
- list.Add(uRow.Cells["ZY_PLAN_ID"].Text.ToString());
- list.Add(numQualified.Value.ToString());//加工个数
- list.Add(numPieces.Value.ToString());//加工支数
- list.Add(numRejected.Value.ToString());
- list.Add(cmbReason.Text.ToString());
- list.Add(txtBC.Value.ToString());
- list.Add(txtBz.Value.ToString());
- list.Add(cmbJcCode.Text.Trim());
- list.Add(numLength.Value.ToString());
- list.Add(cmbOperator.Text.Trim());
- list.Add(txtEmbossed.Text.Trim());
- list.Add(numEmbossed.Value.ToString());
- list.Add(uRow.Cells["WO_ID"].Text.ToString());
- double PlnCount = 0;//计划切割个数
- double CutCount = 0;//实际切割个数
- DataTable dt1 = ServerHelper.GetData("com.steering.mes.mcp.coup.PhosphateResultService.queryPlanJg", new Object[] { row.Cells["ZY_PLAN_ID"].Text.ToString() }, ob);
- if (dt1.Rows.Count > 0)
- {
- PlnCount = Double.Parse(dt1.Rows[0]["CUT_PLN_NUMB"].ToString());
- CutCount = Double.Parse(dt1.Rows[0]["CUT_OK_NUM"].ToString());
- }
- // + Double.Parse(numQualified.Value.ToString())
- if (CutCount > PlnCount)
- {
- if (MessageUtil.ShowYesNoAndQuestion("实际切管个数超过计划切管个数是否修改!") == DialogResult.No) { return; }
- }
- if (MessageUtil.ShowYesNoAndQuestion("是否修改切管记录?") == DialogResult.No)
- {
- return;
- }
- CoreClientParam ccp = new CoreClientParam();
- try
- {
- this.Cursor = Cursors.WaitCursor; //控制鼠标的样式为等待
- if (Constant.WaitingForm == null)
- {
- Constant.WaitingForm = new WaitingForm();
- }
- Constant.WaitingForm.ShowToUser = true;
- Constant.WaitingForm.Show();
- Constant.WaitingForm.Update();
- ccp.ServerName = "com.steering.mes.mcp.coup.FrmPerformanceResult";
- ccp.MethodName = "updateCutResult";
- ccp.ServerParams = new object[] { list, cutGx, embGx, row.Cells["ZY_PLAN_ID"].Text.ToString() };
- ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
- this.Cursor = Cursors.Default;
- Constant.WaitingForm.ShowToUser = false;
- Constant.WaitingForm.Close();
- Constant.WaitingForm = null;
- }
- catch (Exception ex)
- {
- this.Cursor = Cursors.Default;
- Constant.WaitingForm.ShowToUser = false;
- Constant.WaitingForm.Close();
- Constant.WaitingForm = null;
- }
- if (ccp.ReturnCode == -1) return;
- MessageUtil.ShowTips(ccp.ReturnInfo);
- if (ccp.ReturnInfo.Equals("修改切管实绩成功!"))
- {
- QuerySinglePlan();
- }
- }
- /// <summary>
- /// 删除
- /// </summary>
- private void DoDeleteQg()
- {
- ultraCut.UpdateData();
- UltraGridRow uRow = this.ultraCut.ActiveRow;
- if (uRow == null) { MessageUtil.ShowTips("切管实绩无数据!"); return; }
-
- UltraGridRow row = this.ultraGrid2.ActiveRow;
- if (uRow == null)
- {
- MessageUtil.ShowTips("无工单信息,不允许此操作!");
- }
- if (row.Cells["ZY_BILL_STATUS"].Value.ToString() == "生产完成")
- {
- MessageUtil.ShowTips("此工单已生产完成,不允许此操作!");
- return;
- }
- string zYgNo = row.Cells["ZY_PLAN_ID"].Value.ToString();
- string woId = row.Cells["WO_ID"].Value.ToString();
- DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryWoIdDetails", new object[] { woId, zYgNo }, this.ob);
- if (dt.Rows[0]["CUT_STATUS"].ToString().Equals("生产完成"))
- {
- MessageUtil.ShowTips("此工单工序点已结炉,不允许此操作!");
- return;
- }
- ArrayList list1 = new ArrayList();
- int UpdaCount = 0;
- foreach (UltraGridRow ugr in ultraCut.Rows)
- {
- if (Convert.ToBoolean(ugr.Cells["CHECK"].Text) == true)
- {
- if (ugr.Cells["IF_ALL_OUT_WORK"].Value.ToString().Equals("是"))
- {
- MessageUtil.ShowTips("此工序已经离线,不允许此操作!");
- return;
- }
- UpdaCount += 1;
- ArrayList list = new ArrayList();
- list.Add(ugr.Cells["RESULT_NO"].Text.ToString());
- list1.Add(list);
- }
- }
- if (UpdaCount == 0) { MessageUtil.ShowTips("请选择切管数据!"); return; }
- if (MessageUtil.ShowYesNoAndQuestion("是否删除切管记录?") == DialogResult.No)
- {
- return;
- }
- CoreClientParam ccp = new CoreClientParam();
- try
- {
- this.Cursor = Cursors.WaitCursor; //控制鼠标的样式为等待
- if (Constant.WaitingForm == null)
- {
- Constant.WaitingForm = new WaitingForm();
- }
- Constant.WaitingForm.ShowToUser = true;
- Constant.WaitingForm.Show();
- Constant.WaitingForm.Update();
- ccp.ServerName = "com.steering.mes.mcp.coup.CoupCutService";
- ccp.MethodName = "deleteCutResult";
- ccp.ServerParams = new object[] { list1, row.Cells["ZY_PLAN_ID"].Text.ToString(), row.Cells["WO_ID"].Text.ToString() };
- ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
- this.Cursor = Cursors.Default;
- Constant.WaitingForm.ShowToUser = false;
- Constant.WaitingForm.Close();
- Constant.WaitingForm = null;
- }
- catch (Exception ex)
- {
- this.Cursor = Cursors.Default;
- Constant.WaitingForm.ShowToUser = false;
- Constant.WaitingForm.Close();
- Constant.WaitingForm = null;
- }
- if (ccp.ReturnCode == -1) return;
- MessageUtil.ShowTips(ccp.ReturnInfo);
- if (ccp.ReturnInfo.Equals("删除锯切实绩成功!"))
- {
- QuerySinglePlan();
- }
- }
- /// <summary>
- /// 托选
- /// </summary>
- /// <param name="sender"></param>
- /// <param name="e"></param>
- private void ultraGrid4_AfterSelectChange(object sender, AfterSelectChangeEventArgs e)
- {
- try
- {
- ultraPs.UpdateData();
- foreach (UltraGridRow row in ultraCut.Rows)
- {
- row.Cells["CHECK"].Value = row.Selected;
- }
- }
- catch { }
- }
-
- /// <summary>
- /// 是否压印
- /// </summary>
- /// <param name="sender"></param>
- /// <param name="e"></param>
- private void cmbEmbossed_TextChanged(object sender, EventArgs e)
- {
- if (cmbEmbossed.Text.Equals("是"))
- {
- numEmbossed.Enabled = true;
- txtEmbossed.Enabled = true;
- }
- else
- {
- numEmbossed.Enabled = false;
- txtEmbossed.Enabled = false;
- }
- }
- /// <summary>
- /// 废品
- /// </summary>
- /// <param name="sender"></param>
- /// <param name="e"></param>
- private void numRejected_ValueChanged(object sender, EventArgs e)
- {
- if (numRejected.Value.ToString().Equals("0"))
- {
- cmbReason.Enabled = false;
- }
- else
- {
- cmbReason.Enabled = true;
- }
- }
- private void DoClean()
- {
- cmbJcCode.Text = "";
- cmbOperator.Text = "";
- numPieces.Value = 0;
- numQualified.Value = 0;
- numRejected.Value = 0;
- cmbReason.Text = "";
- txtBC.Value = this.UserInfo.GetUserOrder();
- txtBz.Value = this.UserInfo.GetUserGroup();
- numLength.Value = 0;
- numEmbossed.Value = 0;
- txtEmbossed.Text = "";
- }
- private void numQualified_ValueChanged(object sender, EventArgs e)
- {
- if (cmbEmbossed.Text.ToString().Equals("是")) { numEmbossed.Value = numQualified.Value.ToString(); }
- }
- #endregion
- #region 车丝
- /// <summary>
- /// 车丝实绩保存
- /// </summary>
- private void DoSaveCs()
- {
-
- UltraGridRow urg = this.ultraGrid2.ActiveRow;
- if (urg == null)
- {
- MessageUtil.ShowTips("无工单信息,不允许此操作!");
- return;
- }
- if (urg.Cells["ZY_BILL_STATUS"].Value.ToString() == "生产完成")
- {
- MessageUtil.ShowTips("此工单已生产完成,不允许此操作!");
- return;
- }
- string zYgNo = urg.Cells["ZY_PLAN_ID"].Value.ToString();
- string woId = urg.Cells["WO_ID"].Value.ToString();
- DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryWoIdDetails", new object[] { woId, zYgNo }, this.ob);
- if (dt.Rows[0]["LATHE_STATUS"].ToString().Equals("生产完成"))
- {
- MessageUtil.ShowTips("此工单车丝工序点已结炉,不允许此操作!");
- return;
- }
- if (Convert.ToInt32(numCsCount.Value.ToString()) != Convert.ToInt32(numCsHg.Value.ToString()) + Convert.ToInt32(numCsFp.Value.ToString()))
- {
- MessageBox.Show("车丝个数=合格个数+废品个数,请查验 ", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
- return;
- }
- ThreadingResult result = new ThreadingResult();
- result.PlanNo = urg.Cells["ZY_PLAN_ID"].Value.ToString();
- result.PlineCode = urg.Cells["PLINE_CODE"].Value.ToString();
- result.ColGroup = txtCsBz.Value.ToString();
- result.ColShft = txtCsBc.Value.ToString();
- result.ColUser = txtUserCs.Text.ToString();
- result.MachineNo = txtJcCs.Text.ToString();
- result.ProducedPcs = numCsCount.Value.ToString();
- result.Producer = cmbCsProducer.Text.ToString();
- result.WoId = urg.Cells["WO_ID"].Value.ToString();
- if (cmbCsProducer.Text.ToString().Trim().Equals(""))
- {
- result.ProducerTime = "";
- }
- else
- {
- result.ProducerTime = ProducerTimeCs.Value.ToString();
- }
- result.ColOperator1 = txtOpeCs.Text.ToString();
- result.ColOperator2 = txtOpeCs1.Text.ToString();
- result.QualiriedPcs = numCsHg.Value.ToString();
- result.RejectedPieces = numCsFp.Value.ToString();
- result.RejectedReason = txtCsFp.Text.ToString();
- double PlnCount = 0;//计划个数
- double CutCount = 0;//实际个数
- DataTable dt1 = ServerHelper.GetData("com.steering.mes.mcp.coup.PhosphateResultService.queryPlanJg", new Object[] { urg.Cells["ZY_PLAN_ID"].Text.ToString() }, ob);
- if (dt1.Rows.Count > 0)
- {
- PlnCount = Double.Parse(dt1.Rows[0]["LATHE_PLN_NUM"].ToString());
- CutCount = Double.Parse(dt1.Rows[0]["LATHE_OK_NUM"].ToString());
- }
- // + Double.Parse(numQualified.Value.ToString())
- if (CutCount > PlnCount)
- {
- if (MessageUtil.ShowYesNoAndQuestion("实际车丝个数超过计划车丝个数是否新增!") == DialogResult.No) { return; }
- }
- if (MessageUtil.ShowYesNoAndQuestion("是否保存车丝记录?") == DialogResult.No)
- {
- return;
- }
- CoreClientParam ccp = new CoreClientParam();
- try
- {
- this.Cursor = Cursors.WaitCursor; //控制鼠标的样式为等待
- if (Constant.WaitingForm == null)
- {
- Constant.WaitingForm = new WaitingForm();
- }
- Constant.WaitingForm.ShowToUser = true;
- Constant.WaitingForm.Show();
- Constant.WaitingForm.Update();
- ccp.ServerName = "com.steering.mes.mcp.coup.CoupThreadingService";
- ccp.MethodName = "addThreadingResult";
- ccp.ServerParams = new object[] { result, csGx };
- ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
- this.Cursor = Cursors.Default;
- Constant.WaitingForm.ShowToUser = false;
- Constant.WaitingForm.Close();
- Constant.WaitingForm = null;
- }
- catch (Exception ex)
- {
- this.Cursor = Cursors.Default;
- Constant.WaitingForm.ShowToUser = false;
- Constant.WaitingForm.Close();
- Constant.WaitingForm = null;
- }
- if (ccp.ReturnCode != -1)
- {
- MessageUtil.ShowTips(ccp.ReturnInfo);
- if (ccp.ReturnInfo.Equals("保存成功!"))
- {
- QuerySinglePlan();
- }
- }
- }
- /// <summary>
- /// 修改
- /// </summary>
- private void DoUpdateCs()
- {
- ultraCs.UpdateData();
- UltraGridRow uRow = this.ultraCs.ActiveRow;
- if (uRow == null) { MessageUtil.ShowTips("车丝实绩无数据!"); return; }
- if (uRow.Cells["IF_ALL_OUT_WORK"].Value.ToString().Equals("是"))
- {
- MessageUtil.ShowTips("此工序已经离线,不允许此操作!");
- return;
- }
- UltraGridRow row = this.ultraGrid2.ActiveRow;
- if (uRow == null)
- {
- MessageUtil.ShowTips("无工单信息,不允许此操作!");
- }
- if (row.Cells["ZY_BILL_STATUS"].Value.ToString() == "生产完成")
- {
- MessageUtil.ShowTips("此工单已生产完成,不允许此操作!");
- return;
- }
- string zYgNo = uRow.Cells["ZY_PLAN_ID"].Value.ToString();
- string woId = uRow.Cells["WO_ID"].Value.ToString();
- DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryWoIdDetails", new object[] { woId, zYgNo }, this.ob);
- if (dt.Rows[0]["LATHE_STATUS"].ToString().Equals("生产完成"))
- {
- MessageUtil.ShowTips("此工单车丝工序点已结炉,不允许此操作!");
- return;
- }
- ArrayList list = new ArrayList();
- if (Convert.ToInt32(numCsCount.Value.ToString()) != Convert.ToInt32(numCsHg.Value.ToString()) + Convert.ToInt32(numCsFp.Value.ToString()))
- {
- MessageBox.Show("车丝个数=合格个数+废品个数,请查验 ", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
- return;
- }
-
- list.Add(uRow.Cells["RESULT_NO"].Text.ToString());
- list.Add(uRow.Cells["ZY_PLAN_ID"].Text.ToString());
- list.Add(numCsCount.Value.ToString());
- list.Add(numCsHg.Value.ToString());
- list.Add(numCsFp.Text.Trim().ToString());
- list.Add(txtCsFp.Text.ToString());
- list.Add(txtCsBc.Value.ToString());
- list.Add(txtCsBz.Value.ToString());
- list.Add(txtJcCs.Text.ToString());
- list.Add(txtOpeCs.Text.ToString());
- list.Add(txtOpeCs1.Text.ToString());
- list.Add(cmbCsProducer.Text.ToString());
- if (cmbCsProducer.Text.ToString().Equals(""))
- {
- list.Add("");
- }
- else
- {
- list.Add(ProducerTimeCs.Value.ToString());
- }
- list.Add(uRow.Cells["WO_ID"].Text.ToString());
- double PlnCount = 0;//计划个数
- double CutCount = 0;//实际个数
- DataTable dt1 = ServerHelper.GetData("com.steering.mes.mcp.coup.PhosphateResultService.queryPlanJg", new Object[] { row.Cells["ZY_PLAN_ID"].Text.ToString() }, ob);
- if (dt1.Rows.Count > 0)
- {
- PlnCount = Double.Parse(dt1.Rows[0]["LATHE_PLN_NUM"].ToString());
- CutCount = Double.Parse(dt1.Rows[0]["LATHE_OK_NUM"].ToString());
- }
- // + Double.Parse(numQualified.Value.ToString())
- if (CutCount > PlnCount)
- {
- if (MessageUtil.ShowYesNoAndQuestion("实际车丝个数超过计划车丝个数是否修改!") == DialogResult.No) { return; }
- }
- if (MessageUtil.ShowYesNoAndQuestion("是否修改车丝记录?") == DialogResult.No)
- {
- return;
- }
- CoreClientParam ccp = new CoreClientParam();
- try
- {
- this.Cursor = Cursors.WaitCursor; //控制鼠标的样式为等待
- if (Constant.WaitingForm == null)
- {
- Constant.WaitingForm = new WaitingForm();
- }
- Constant.WaitingForm.ShowToUser = true;
- Constant.WaitingForm.Show();
- Constant.WaitingForm.Update();
- ccp.ServerName = "com.steering.mes.mcp.coup.FrmPerformanceResult";
- ccp.MethodName = "updateThreadingResult";
- ccp.ServerParams = new object[] { list, csGx, row.Cells["ZY_PLAN_ID"].Text.ToString() };
- ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
- this.Cursor = Cursors.Default;
- Constant.WaitingForm.ShowToUser = false;
- Constant.WaitingForm.Close();
- Constant.WaitingForm = null;
- }
- catch (Exception ex)
- {
- this.Cursor = Cursors.Default;
- Constant.WaitingForm.ShowToUser = false;
- Constant.WaitingForm.Close();
- Constant.WaitingForm = null;
- }
- if (ccp.ReturnCode == -1) return;
- MessageUtil.ShowTips(ccp.ReturnInfo);
- if (ccp.ReturnInfo.Equals("修改车丝实绩成功!"))
- {
- QuerySinglePlan();
- }
- }
- /// <summary>
- /// 删除
- /// </summary>
- private void DoDeleteCs()
- {
- ultraGrid2.UpdateData();
- UltraGridRow uRow = this.ultraCs.ActiveRow;
- if (uRow == null) { MessageUtil.ShowTips("车丝实绩无数据!"); return; }
- UltraGridRow row = this.ultraGrid2.ActiveRow;
- if (row == null)
- {
- MessageUtil.ShowTips("无工单信息,不允许此操作!");
- }
- if (row.Cells["ZY_BILL_STATUS"].Value.ToString() == "生产完成")
- {
- MessageUtil.ShowTips("此工单已生产完成,不允许此操作!");
- return;
- }
- string zYgNo = uRow.Cells["ZY_PLAN_ID"].Value.ToString();
- string woId = uRow.Cells["WO_ID"].Value.ToString();
- DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryWoIdDetails", new object[] { woId, zYgNo }, this.ob);
- if (dt.Rows[0]["LATHE_STATUS"].ToString().Equals("生产完成"))
- {
- MessageUtil.ShowTips("此工单车丝工序点已结炉,不允许此操作!");
- return;
- }
- ArrayList list1 = new ArrayList();
- int UpdaCount = 0;
- foreach (UltraGridRow ugr in ultraCs.Rows)
- {
- if (Convert.ToBoolean(ugr.Cells["CHECK"].Text) == true)
- {
- if (ugr.Cells["IF_ALL_OUT_WORK"].Value.ToString().Equals("是"))
- {
- MessageUtil.ShowTips("此工序已经离线,不允许此操作!");
- return;
- }
- UpdaCount += 1;
- ArrayList list = new ArrayList();
- list.Add(ugr.Cells["RESULT_NO"].Text.ToString());
- list1.Add(list);
- }
- }
- if (UpdaCount == 0) { MessageUtil.ShowTips("请选择车丝数据!"); return; }
- if (MessageUtil.ShowYesNoAndQuestion("是否删除车丝记录?") == DialogResult.No)
- {
- return;
- }
- CoreClientParam ccp = new CoreClientParam();
- try
- {
- this.Cursor = Cursors.WaitCursor; //控制鼠标的样式为等待
- if (Constant.WaitingForm == null)
- {
- Constant.WaitingForm = new WaitingForm();
- }
- Constant.WaitingForm.ShowToUser = true;
- Constant.WaitingForm.Show();
- Constant.WaitingForm.Update();
- ccp.ServerName = "com.steering.mes.mcp.coup.CoupThreadingService";
- ccp.MethodName = "deleteThreadingResult";
- ccp.ServerParams = new object[] { list1, row.Cells["ZY_PLAN_ID"].Text.ToString(), csGx, row.Cells["WO_ID"].Text.ToString() };
- ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
- this.Cursor = Cursors.Default;
- Constant.WaitingForm.ShowToUser = false;
- Constant.WaitingForm.Close();
- Constant.WaitingForm = null;
- }
- catch (Exception ex)
- {
- this.Cursor = Cursors.Default;
- Constant.WaitingForm.ShowToUser = false;
- Constant.WaitingForm.Close();
- Constant.WaitingForm = null;
- }
- if (ccp.ReturnCode == -1) return;
- MessageUtil.ShowTips(ccp.ReturnInfo);
- if (ccp.ReturnInfo.Equals("删除车丝实绩成功!"))
- {
- QuerySinglePlan();
- }
- }
- /// <summary>
- /// 结炉
- /// </summary>
- private void DoBesideCs()
- {
- UltraGridRow uRow = this.ultraGrid2.ActiveRow;
- if (uRow == null)
- {
- MessageUtil.ShowTips("请选择需要结炉的工单信息!");
- return;
- }
- string zYgNo = uRow.Cells["ZY_PLAN_ID"].Value.ToString();
- string woId = uRow.Cells["WO_ID"].Value.ToString();
- DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryWoIdDetails", new object[] { woId, zYgNo }, this.ob);
- if (dt.Rows[0]["LATHE_STATUS"].ToString().Equals("生产完成"))
- {
- MessageUtil.ShowTips("此工单车丝工序点已结炉,不允许此操作!");
- return;
- } if (dt.Rows[0]["ZY_BILL_STATUS"].ToString().Equals("生产完成"))
- {
- MessageUtil.ShowTips("此工单已结炉,不允许此操作!");
- return;
- }
- ArrayList list = new ArrayList();
- list.Add(zYgNo);
- list.Add(csGx);
- list.Add(woId);
- if (MessageUtil.ShowYesNoAndQuestion("是否结炉?") == DialogResult.No)
- {
- return;
- }
- CoreClientParam ccp = new CoreClientParam();
- ccp.ServerName = "com.steering.mes.mcp.coup.CoupThreadingService";
- ccp.MethodName = "doBeside";
- ccp.ServerParams = new object[] { list };
- ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
- if (ccp.ReturnCode != -1)
- {
- MessageUtil.ShowTips(ccp.ReturnInfo);
- if (ccp.ReturnInfo.Equals("结炉成功!"))
- {
- QuerySinglePlan();
- }
- }
- }
- /// <summary>
- /// 撤销结炉
- /// </summary>
- private void UndoBesideCs()
- {
- UltraGridRow uRow = this.ultraGrid2.ActiveRow;
- if (uRow == null)
- {
- MessageUtil.ShowTips("请选择需要撤销结炉的工单信息!");
- return;
- }
- string zYgNo = uRow.Cells["ZY_PLAN_ID"].Value.ToString();
- string woId = uRow.Cells["WO_ID"].Value.ToString();
- DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryWoIdDetails", new object[] { woId, zYgNo }, this.ob);
- if (!dt.Rows[0]["LATHE_STATUS"].ToString().Equals("生产完成"))
- {
- MessageUtil.ShowTips("此工单车丝工序点未结炉,不允许此操作!");
- return;
- }
- if (dt.Rows[0]["ZY_BILL_STATUS"].ToString().Equals("生产完成"))
- {
- MessageUtil.ShowTips("此工单已结炉,不允许此操作!");
- return;
- }
- ArrayList list = new ArrayList();
- list.Add(zYgNo);
- list.Add(csGx);
- list.Add(woId);
- if (MessageUtil.ShowYesNoAndQuestion("是否撤销结炉?") == DialogResult.No)
- {
- return;
- }
- CoreClientParam ccp = new CoreClientParam();
- ccp.ServerName = "com.steering.mes.mcp.coup.CoupThreadingService";
- ccp.MethodName = "undoBeside";
- ccp.ServerParams = new object[] { list };
- ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
- if (ccp.ReturnCode != -1)
- {
- MessageUtil.ShowTips(ccp.ReturnInfo);
- if (ccp.ReturnInfo.Equals("撤销结炉成功!"))
- {
- QuerySinglePlan();
- }
- }
- }
- /// <summary>
- /// 车丝实绩查询
- /// </summary>
- /// <param name="planNo"></param>
- private void getCoupThreadingResult(string planNo, string woId)
- {
- DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.coup.FrmPerformanceResult.getThreadingResult", new object[] { planNo, woId }, this.ob);
- GridHelper.CopyDataToDatatable(ref dt, ref dtSelfChecked, true);
- }
-
- private void ultraCs_AfterRowActivate(object sender, EventArgs e)
- {
- UltraGridRow ugr = ultraCs.ActiveRow;
- if (ugr == null) return;
- if (ugr.Cells["IF_ALL_OUT_WORK"].Value.ToString().Equals("否"))
- {
- numCsCount.Value = ugr.Cells["PRODUCED_PCS"].Value.ToString();
- numCsHg.Value = ugr.Cells["QUALIRIED_PCS"].Value.ToString();
- numCsFp.Value = ugr.Cells["REJECTED_PCS"].Value.ToString();
- txtCsFp.Text = ugr.Cells["REJECTED_REASON"].Value.ToString();
- txtCsBc.Text = ugr.Cells["COL_SHIFT"].Value.ToString();
- txtCsBz.Text = ugr.Cells["COL_GROUP"].Value.ToString();
- txtJcCs.Text = ugr.Cells["MACHINE_NO"].Value.ToString();
- txtOpeCs.Text = ugr.Cells["COL_OPERATOR1"].Value.ToString();
- txtOpeCs1.Text = ugr.Cells["COL_OPERATOR2"].Value.ToString();
- cmbCsProducer.Text = ugr.Cells["PRODUCER"].Value.ToString();
- }
- if (!ugr.Cells["PRODUCER"].Value.ToString().Equals(""))
- {
- ProducerTimeCs.Value = DateTime.Parse(ugr.Cells["PRODUCER_TIME"].Value.ToString());
- }
- }
- private void numCsFp_ValueChanged(object sender, EventArgs e)
- {
- if (numCsFp.Value.ToString().Equals("0"))
- {
- txtCsFp.Enabled = false;
- }
- else
- {
- txtCsFp.Enabled = true;
- }
- }
- #endregion
- #region 喷标
- /// <summary>
- /// 查询喷砂实绩
- /// </summary>
- /// <param name="planNo"></param>
- private void getCoupSandBlast(string planNo, string woId)
- {
- DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.coup.FrmPerformanceResult.getCoupSandBlast", new object[] { planNo, woId }, this.ob);
- GridHelper.CopyDataToDatatable(ref dt, ref dataTable4, true);
- }
- /// <summary>
- /// 保存
- /// </summary>
- private void DoSavePs()
- {
- UltraGridRow row = this.ultraGrid2.ActiveRow;
- if (row == null)
- {
- MessageUtil.ShowTips("无工单信息,不允许此操作!");
- return;
- }
- string zYgNo = row.Cells["ZY_PLAN_ID"].Value.ToString();
- string woId = row.Cells["WO_ID"].Value.ToString();
- DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryWoIdDetails", new object[] { woId, zYgNo }, this.ob);
- if (dt.Rows[0]["BLAST_STATUS"].ToString().Equals("生产完成"))
- {
- MessageUtil.ShowTips("此工单喷砂工序点已结炉,不允许此操作!");
- return;
- }
- if (row.Cells["ZY_BILL_STATUS"].Value.ToString().Equals("生产完成"))
- {
- MessageUtil.ShowTips("此炉次计划号整体已生产完成,不允许此操作!");
- return;
- }
- if (row.Cells["IF_OUT_BLAST"].Text.ToString().Equals("无喷砂"))
- {
- MessageUtil.ShowTips("不需要进行此工序!");
- return;
- }
- if (Convert.ToInt32(numCountPs.Value.ToString()) != Convert.ToInt32(numHgPs.Value.ToString()) + Convert.ToInt32(numFpPs.Value.ToString()))
- {
- MessageBox.Show("喷标个数=合格个数+废品总个数,请查验 ", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
- return;
- }
- CouplingSandblastResultEntity sand = new CouplingSandblastResultEntity();
- sand.SprayCount = numCountPs.Value.ToString();
- sand.QualiriedPcs = numHgPs.Value.ToString();
- sand.RejectedPcs = numFpPs.Value.ToString();
- sand.RejectedReason = cmbFpPs.Text.Trim();
- sand.SprayMaterial = cmbPsSpray.Text.ToString();
- sand.ColOperator = txtOpePs.Text.Trim();
- sand.ColShift = txtPsbc.Value.ToString();
- sand.ColGroup = txtPsbz.Value.ToString();
- sand.ColUser = txtUserPs.Text.ToString();
- sand.SprayThick = numCZDPs.Value.ToString();
- sand.SprayEquipment = cmbPsEquipment.Text.ToString();
- sand.SprayPressure = numPsPressure.Value.ToString();
- sand.Memo = txtPsMemo.Text.ToString();
- //sand.IfAllOutWork = row.Cells["IF_ALL_OUT_WORK"].Text.ToString();
- sand.ZyPlanId = row.Cells["ZY_PLAN_ID"].Text.ToString();
- sand.PlineCode = row.Cells["PLINE_CODE"].Text.ToString();
- sand.WoId = row.Cells["WO_ID"].Text.ToString();
- double PlnCount = 0;//计划个数
- double CutCount = 0;//实际个数
- DataTable dt1 = ServerHelper.GetData("com.steering.mes.mcp.coup.PhosphateResultService.queryPlanJg", new Object[] { row.Cells["ZY_PLAN_ID"].Text.ToString() }, ob);
- if (dt1.Rows.Count > 0)
- {
- PlnCount = Double.Parse(dt1.Rows[0]["BLAST_PLN_NUM"].ToString());
- CutCount = Double.Parse(dt1.Rows[0]["BLAST_OK_NUM"].ToString());
- }
- // + Double.Parse(numQualified.Value.ToString())
- if (CutCount > PlnCount)
- {
- if (MessageUtil.ShowYesNoAndQuestion("实际喷砂个数超过计划喷砂个数是否新增!") == DialogResult.No) { return; }
- }
- if (MessageUtil.ShowYesNoAndQuestion("是否保存喷砂记录?") == DialogResult.No)
- {
- return;
- }
- CoreClientParam ccp = new CoreClientParam();
- try
- {
- this.Cursor = Cursors.WaitCursor; //控制鼠标的样式为等待
- if (Constant.WaitingForm == null)
- {
- Constant.WaitingForm = new WaitingForm();
- }
- Constant.WaitingForm.ShowToUser = true;
- Constant.WaitingForm.Show();
- Constant.WaitingForm.Update();
- ccp.ServerName = "com.steering.mes.mcp.coup.FrmSandBlast";
- ccp.MethodName = "addSandResult";
- ccp.ServerParams = new object[] { sand, PsGx };
- ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
- this.Cursor = Cursors.Default;
- Constant.WaitingForm.ShowToUser = false;
- Constant.WaitingForm.Close();
- Constant.WaitingForm = null;
- }
- catch (Exception ex)
- {
- this.Cursor = Cursors.Default;
- Constant.WaitingForm.ShowToUser = false;
- Constant.WaitingForm.Close();
- Constant.WaitingForm = null;
- }
- if (ccp.ReturnCode != -1)
- {
- MessageUtil.ShowTips(ccp.ReturnInfo);
- if (ccp.ReturnInfo.Equals("保存成功!"))
- {
- QuerySinglePlan();
- DoClean();
- }
- }
- }
- /// <summary>
- /// 修改
- /// </summary>
- private void DoUpdatePs()
- {
- UltraGridRow row = this.ultraGrid2.ActiveRow;
- if (row == null)
- {
- MessageUtil.ShowTips("无工单信息,不允许此操作!");
- return;
- }
- UltraGridRow urg = this.ultraPs.ActiveRow;
- if (urg == null)
- {
- MessageUtil.ShowTips("无接箍喷砂实绩,不允许此操作!");
- return;
- }
- if (urg.Cells["IF_ALL_OUT_WORK"].Value.ToString().Equals("是"))
- {
- MessageUtil.ShowTips("此工序已经离线,不允许此操作!");
- return;
- }
- string zYgNo = row.Cells["ZY_PLAN_ID"].Value.ToString();
- string woId = row.Cells["WO_ID"].Value.ToString();
- DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryWoIdDetails", new object[] { woId, zYgNo }, this.ob);
- if (dt.Rows[0]["BLAST_STATUS"].ToString().Equals("生产完成"))
- {
- MessageUtil.ShowTips("此工单喷砂工序点已结炉,不允许此操作!");
- return;
- }
- string time = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
- if (Convert.ToInt32(numPieces.Value.ToString()) != Convert.ToInt32(numQualified.Value.ToString()) + Convert.ToInt32(numRejected.Value.ToString()))
- {
- MessageBox.Show("喷标个数=合格个数+废品总个数,请查验 ", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
- return;
- }
- string resNo = "";
- if (Convert.ToBoolean(urg.Cells["CHK"].Text) == true)
- {
- resNo = urg.Cells["RESULT_NO"].Text.ToString();
- }
- else
- {
- }
- CouplingSandblastResultEntity sand = new CouplingSandblastResultEntity();
- sand.SprayCount = numCountPs.Value.ToString();
- sand.QualiriedPcs = numHgPs.Value.ToString();
- sand.RejectedPcs = numFpPs.Value.ToString();
- sand.RejectedReason = cmbFpPs.Text.Trim();
- sand.SprayMaterial = cmbPsSpray.Text.ToString();
- sand.ColOperator = txtOpePs.Text.Trim();
- sand.ColShift = txtPsbc.Value.ToString();
- sand.ColGroup = txtPsbz.Value.ToString();
- sand.SprayThick = numCZDPs.Value.ToString();
- sand.SprayEquipment = cmbPsEquipment.Text.ToString();
- sand.SprayPressure = numPsPressure.Value.ToString();
- sand.Memo = txtPsMemo.Text.ToString();
- sand.UpdateName = this.UserInfo.GetUserName();
- sand.UpdateTime = time;
- //sand.IfAllOutWork = row.Cells["IF_ALL_OUT_WORK"].Text.ToString();
- sand.ZyPlanId = urg.Cells["ZY_PLAN_ID"].Text.ToString();
- sand.PlineCode = urg.Cells["PLINE_CODE"].Text.ToString();
- sand.ResultNo = urg.Cells["RESULT_NO"].Text.ToString();
- sand.WoId = urg.Cells["WO_ID"].Text.ToString();
- double PlnCount = 0;//计划个数
- double CutCount = 0;//实际个数
- DataTable dt1 = ServerHelper.GetData("com.steering.mes.mcp.coup.PhosphateResultService.queryPlanJg", new Object[] { row.Cells["ZY_PLAN_ID"].Text.ToString() }, ob);
- if (dt1.Rows.Count > 0)
- {
- PlnCount = Double.Parse(dt1.Rows[0]["BLAST_PLN_NUM"].ToString());
- CutCount = Double.Parse(dt1.Rows[0]["BLAST_OK_NUM"].ToString());
- }
- // + Double.Parse(numQualified.Value.ToString())
- if (CutCount > PlnCount)
- {
- if (MessageUtil.ShowYesNoAndQuestion("实际喷砂个数超过计划喷砂个数是否修改!") == DialogResult.No) { return; }
- }
- if (MessageUtil.ShowYesNoAndQuestion("是否修改喷砂记录?") == DialogResult.No)
- {
- return;
- }
- CoreClientParam ccp = new CoreClientParam();
- try
- {
- this.Cursor = Cursors.WaitCursor; //控制鼠标的样式为等待
- if (Constant.WaitingForm == null)
- {
- Constant.WaitingForm = new WaitingForm();
- }
- Constant.WaitingForm.ShowToUser = true;
- Constant.WaitingForm.Show();
- Constant.WaitingForm.Update();
- ccp.ServerName = "com.steering.mes.mcp.coup.FrmSandBlast";
- ccp.MethodName = "updateSandResult";
- ccp.ServerParams = new object[] { sand, PsGx };
- ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
- this.Cursor = Cursors.Default;
- Constant.WaitingForm.ShowToUser = false;
- Constant.WaitingForm.Close();
- Constant.WaitingForm = null;
- }
- catch (Exception ex)
- {
- this.Cursor = Cursors.Default;
- Constant.WaitingForm.ShowToUser = false;
- Constant.WaitingForm.Close();
- Constant.WaitingForm = null;
- }
- if (ccp.ReturnCode != -1)
- {
- MessageUtil.ShowTips(ccp.ReturnInfo);
- if (ccp.ReturnInfo.Equals("修改喷砂实绩成功!"))
- {
- QuerySinglePlan();
- DoClean();
- }
- }
- }
- /// <summary>
- /// 删除
- /// </summary>
- private void DoDeletePs()
- {
- UltraGridRow uRow = this.ultraPs.ActiveRow;
- if (uRow == null) { MessageUtil.ShowTips("喷砂实绩无数据!"); return; }
- UltraGridRow row = this.ultraGrid2.ActiveRow;
- if (uRow == null)
- {
- MessageUtil.ShowTips("无工单信息,不允许此操作!");
- }
- string zYgNo = row.Cells["ZY_PLAN_ID"].Value.ToString();
- string woId = row.Cells["WO_ID"].Value.ToString();
- DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryWoIdDetails", new object[] { woId, zYgNo }, this.ob);
- if (dt.Rows[0]["BLAST_STATUS"].ToString().Equals("生产完成"))
- {
- MessageUtil.ShowTips("此工单喷砂工序点已结炉,不允许此操作!");
- return;
- }
- ArrayList list1 = new ArrayList();
- int UpdaCount = 0;
- foreach (UltraGridRow ugr in ultraPs.Rows)
- {
- if (Convert.ToBoolean(ugr.Cells["CHK"].Text) == true)
- {
- if (ugr.Cells["IF_ALL_OUT_WORK"].Value.ToString().Equals("是"))
- {
- MessageUtil.ShowTips("此工序已经离线,不允许此操作!");
- return;
- }
- UpdaCount += 1;
- ArrayList list = new ArrayList();
- list.Add(ugr.Cells["RESULT_NO"].Text.ToString());
- list1.Add(list);
- }
- }
- if (UpdaCount == 0) { MessageUtil.ShowTips("请选择喷砂数据!"); return; }
- if (MessageUtil.ShowYesNoAndQuestion("是否删除喷砂实绩记录?") == DialogResult.No)
- {
- return;
- }
- CoreClientParam ccp = new CoreClientParam();
- try
- {
- this.Cursor = Cursors.WaitCursor; //控制鼠标的样式为等待
- if (Constant.WaitingForm == null)
- {
- Constant.WaitingForm = new WaitingForm();
- }
- Constant.WaitingForm.ShowToUser = true;
- Constant.WaitingForm.Show();
- Constant.WaitingForm.Update();
- ccp.ServerName = "com.steering.mes.mcp.coup.FrmSandBlast";
- ccp.MethodName = "deleteSandResult";
- ccp.ServerParams = new object[] { list1, PsGx, row.Cells["ZY_PLAN_ID"].Text.ToString(), row.Cells["WO_ID"].Text.ToString() };
- ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
- this.Cursor = Cursors.Default;
- Constant.WaitingForm.ShowToUser = false;
- Constant.WaitingForm.Close();
- Constant.WaitingForm = null;
- }
- catch (Exception ex)
- {
- this.Cursor = Cursors.Default;
- Constant.WaitingForm.ShowToUser = false;
- Constant.WaitingForm.Close();
- Constant.WaitingForm = null;
- }
- if (ccp.ReturnCode != -1)
- {
- MessageUtil.ShowTips(ccp.ReturnInfo);
- if (ccp.ReturnInfo.Equals("删除喷砂实绩成功!"))
- {
- QuerySinglePlan();
- DoClean();
- }
- }
- }
- /// <summary>
- /// 结炉
- /// </summary>
- private void DoComplete()
- {
- UltraGridRow uRow = this.ultraGrid2.ActiveRow;
- if (uRow == null)
- {
- MessageUtil.ShowTips("请选择需要结炉的作业工单号!");
- return;
- }
- string zYgNo = uRow.Cells["ZY_PLAN_ID"].Value.ToString();
- string woId = uRow.Cells["WO_ID"].Value.ToString();
- DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryWoIdDetails", new object[] { woId, zYgNo }, this.ob);
- if (dt.Rows[0]["BLAST_STATUS"].ToString().Equals("生产完成"))
- {
- MessageUtil.ShowTips("此工单喷砂工序点已结炉,不允许此操作!");
- return;
- }
- if (dt.Rows[0]["ZY_BILL_STATUS"].ToString().Equals("生产完成"))
- {
- MessageUtil.ShowTips("此工单已结炉,不允许此操作!");
- return;
- }
- ArrayList list = new ArrayList();
- list.Add(zYgNo);
- list.Add(PsGx);
- list.Add(woId);
- if (MessageUtil.ShowYesNoAndQuestion("是否结炉?") == DialogResult.No)
- {
- return;
- }
- CoreClientParam ccp = new CoreClientParam();
- ccp.ServerName = "com.steering.mes.mcp.coup.FrmSandBlast";
- ccp.MethodName = "doBeside";
- ccp.ServerParams = new object[] { list };
- ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
- if (ccp.ReturnCode != -1)
- {
- MessageUtil.ShowTips(ccp.ReturnInfo);
- if (ccp.ReturnInfo.Equals("结炉成功!"))
- {
- QuerySinglePlan();
- }
- }
- }
- /// <summary>
- /// 撤销结炉
- /// </summary>
- private void UnDoComplete()
- {
- UltraGridRow uRow = this.ultraGrid2.ActiveRow;
- if (uRow == null)
- {
- MessageUtil.ShowTips("请选择需要结炉的作业工单号!");
- return;
- }
- string zYgNo = uRow.Cells["ZY_PLAN_ID"].Value.ToString();
- string woId = uRow.Cells["WO_ID"].Value.ToString();
- DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryWoIdDetails", new object[] { woId, zYgNo }, this.ob);
- if (!dt.Rows[0]["BLAST_STATUS"].ToString().Equals("生产完成"))
- {
- MessageUtil.ShowTips("此工单喷砂工序点未结炉,不允许此操作!");
- return;
- } if (dt.Rows[0]["ZY_BILL_STATUS"].ToString().Equals("生产完成"))
- {
- MessageUtil.ShowTips("此工单已结炉,不允许此操作!");
- return;
- }
- ArrayList list = new ArrayList();
- list.Add(zYgNo);
- list.Add(PsGx);
- list.Add(woId);
- if (MessageUtil.ShowYesNoAndQuestion("是否撤销结炉?") == DialogResult.No)
- {
- return;
- }
- CoreClientParam ccp = new CoreClientParam();
- ccp.ServerName = "com.steering.mes.mcp.coup.FrmSandBlast";
- ccp.MethodName = "undoBeside";
- ccp.ServerParams = new object[] { list };
- ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
- if (ccp.ReturnCode != -1)
- {
- MessageUtil.ShowTips(ccp.ReturnInfo);
- if (ccp.ReturnInfo.Equals("撤销结炉成功!"))
- {
- QuerySinglePlan();
- }
- }
- }
- private void numFpPs_ValueChanged(object sender, EventArgs e)
- {
- }
- private void ultraPs_AfterRowActivate(object sender, EventArgs e)
- {
- UltraGridRow ugr = this.ultraPs.ActiveRow;
- if (ugr == null) return;
- if (ugr.Cells["IF_ALL_OUT_WORK"].Value.ToString().Equals("否"))
- {
- numCountPs.Value = ugr.Cells["SPRAY_COUNT"].Text.ToString();
- numHgPs.Value = ugr.Cells["QUALIRIED_PCS"].Text.ToString();
- numFpPs.Value = ugr.Cells["REJECTED_PCS"].Text.ToString();
- cmbFpPs.Text = ugr.Cells["REJECTED_REASON"].Text.ToString();
- cmbPsSpray.Text = ugr.Cells["SPRAY_MATERIAL"].Text.ToString();
- txtOpePs.Text = ugr.Cells["COL_OPERATOR"].Text.ToString();
- txtPsbc.Text = ugr.Cells["COL_SHIFT"].Value.ToString();
- txtPsbz.Text = ugr.Cells["COL_GROUP"].Value.ToString();
- txtUserPs.Text = ugr.Cells["COL_USER"].Text.ToString();
- numCZDPs.Value = ugr.Cells["SPRAY_THICK"].Text.ToString();
- cmbPsEquipment.Text = ugr.Cells["SPRAY_EQUIPMENT"].Text.ToString();
- numPsPressure.Value = ugr.Cells["SPRAY_PRESSURE"].Text.ToString();
- txtPsMemo.Text = ugr.Cells["MEMO"].Text.ToString();
- }
- else
- {
- DoClean();
- }
- }
- #endregion
- /// <summary>
- /// 按回车键触发查询按钮
- /// </summary>
- /// <param name="sender"></param>
- /// <param name="e"></param>
- private void ContPublic_KeyDown(object sender, KeyEventArgs e)
- {
- if (e.KeyCode == Keys.Enter)
- {
- QuerySinglePlan();
- }
- }
- private void chkStarts_CheckedChanged(object sender, EventArgs e)
- {
- if (chkStarts.Checked) { cmbStarts.Enabled = true; } else { cmbStarts.Enabled = false; }
- if (chkJuNo.Checked) { txtJudgeStoveNO.Enabled = true; } else { txtJudgeStoveNO.Enabled = false; }
- if (chkPlnNo.Checked) { txtPlnNo.Enabled = true; } else { txtPlnNo.Enabled = false; }
- if (chkwoId.Checked) { txtWoId.Enabled = true; } else { txtWoId.Enabled = false; }
- }
- private void ultraCut_AfterRowActivate(object sender, EventArgs e)
- {
- UltraGridRow uRow = this.ultraCut.ActiveRow;
- if (uRow == null) return;
- if (uRow.Cells["IF_ALL_OUT_WORK"].Value.ToString().Equals("否"))
- {
- cmbJcCode.Text = uRow.Cells["MACHINE_NO"].Value.ToString();
- numPieces.Value = uRow.Cells["CUT_PIECES"].Value.ToString();
- numQualified.Value = uRow.Cells["QUALIFIED_NUMBER"].Value.ToString();
- numRejected.Value = uRow.Cells["REJECTED_PCS"].Value.ToString();
- cmbReason.Text = uRow.Cells["REJECTED_REASON"].Value.ToString();
- numLength.Value = uRow.Cells["LVALID_LENGTH"].Value.ToString();
- cmbOperator.Text = uRow.Cells["COL_OPERATOR"].Value.ToString();
- txtBC.Text = uRow.Cells["COL_SHIFT"].Value.ToString();
- txtBz.Text = uRow.Cells["COL_GROUP"].Value.ToString();
- txtUser.Text = uRow.Cells["COL_USER"].Value.ToString();
- cmbEmbossed.Value = uRow.Cells["IS_EMBOSSED"].Value.ToString();
- numEmbossed.Value = uRow.Cells["EMB_COUNT"].Value.ToString();
- txtEmbossed.Text = uRow.Cells["EMB_CONTENT"].Value.ToString();
- }
- }
- }
- }
|