/// <summary> /// 异步事务工作事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void backgroundWorker1_DoWork(object sender, DoWorkEventArgs e) { backgroundWorker1.ReportProgress(PubConstant.WaitMessageStatus.START); try { switch (e.Argument.ToString()) { case "SearchData": using (SRQZData.QZDataServiceClient client = new SRQZData.QZDataServiceClient()) { e.Result = client.GetCraftsTable(context.SessionID); } break; default: break; } } catch (System.ServiceModel.FaultException <SRQZData.CustomFaultMessage> fex) { Utils.Logger.Error(fex.ToString()); backgroundWorker1.ReportProgress(PubConstant.WaitMessageStatus.ERROR, fex.Message); } catch (Exception ex) { Utils.Logger.Error(ex.ToString()); backgroundWorker1.ReportProgress(PubConstant.WaitMessageStatus.ERROR, ex.Message); } backgroundWorker1.ReportProgress(PubConstant.WaitMessageStatus.END); }
private void BgWaitStockArea_DoWork(object sender, DoWorkEventArgs e) { try { switch (e.Argument.ToString()) { case "GetInitRFIDData": using (var Client = new SRQZData.QZDataServiceClient()) { DataTable MYFunColor = Client.GetQZFunColor(context.SessionID); //获取勤哲基础颜色设置 RFIDData = Client.GetRFIDData(context.SessionID); TestRfidData = RFIDData.DefaultView; TestRfidDistinct = TestRfidData.ToTable(true, "颜色代码", "配方名称"); for (int i = 0; i < MYFunColor.Rows.Count; i++) { imageList2.Images.Add(ImageProcess.GetFillrectangleBitmap(28, 28, System.Drawing.ColorTranslator.FromHtml(MYFunColor.Rows[i]["颜色代码"].ToString()), "", Color.Black)); } } e.Result = "GetInitRFIDData"; break; } } catch (Exception ex) { Utils.Logger.Error(ex.ToString()); } }
private void frmPullDetectionReg_Load(object sender, EventArgs e) { try { ProcessTypeSpinEdit.Properties.DataSource = TProcessType; AddFun(); this.BeginInvoke((MethodInvoker) delegate() { using (SRQZData.QZDataServiceClient client = new SRQZData.QZDataServiceClient()) { var data = client.GetQualityInspector(context.SessionID); this.Invoke((MethodInvoker) delegate() { QualityInspectorTextEdit.Properties.DataSource = data; }); dtPullRule = client.GetPullCompute(context.SessionID); } }); } catch (Exception ex) { ClsMsg.ShowErrMsg(ex.Message); Utils.Logger.Error(ex.ToString()); } }
private object TestQueryWeight(SRQZData.QZDataServiceClient QZclient, DataTable Newret, int StartLocation) { decimal queryWeight; var retWeight = QZclient.GetQZWeight(context.SessionID, Convert.ToDateTime(Newret.Rows[StartLocation]["生产周期开始"].ToString()), Convert.ToDateTime(Newret.Rows[StartLocation]["生产周期结束"].ToString()), Newret.Rows[StartLocation]["品种"].ToString(), Newret.Rows[StartLocation]["品种类型"].ToString()); // var queryWeight = retWeight.Compute("sum(weightA)", ""); if (retWeight.Rows.Count > 0 && retWeight != null) { queryWeight = Math.Round(Convert.ToDecimal(retWeight.Compute("sum(weightA)", "")), MidpointRounding.AwayFromZero) / 1000; } else { queryWeight = 0; } return(queryWeight); }
/// <summary> /// 左上角跟右上角思路处理定时器更新时统一去除viewlist控件的数据同时统一add该控件的数据 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void BgWaitDrumDry_DoWork(object sender, DoWorkEventArgs e) { try { switch (e.Argument.ToString()) { case "GetInitDrumDryData": using (var Client = new SRQZData.QZDataServiceClient()) { QZFunColor = Client.GetQZFunColor(context.SessionID); //获取勤哲基础颜色设置 for (int i = 0; i < QZFunColor.Rows.Count; i++) { imageList1.Images.Add(ImageProcess.GetFillEllipseBitmap(28, 28, System.Drawing.ColorTranslator.FromHtml(QZFunColor.Rows[i]["颜色代码"].ToString()), "", Color.Black)); ColorDataArray[i] = QZFunColor.Rows[i]["颜色代码"].ToString(); } //转鼓号,转鼓状态,转鼓颜色 DrumDryData = Client.GetZGStatus(context.SessionID); //获取转鼓状态 TestZGData = DrumDryData.DefaultView; TestZGDistinct = TestZGData.ToTable(true, "FormulaCode"); //获取唯一性配方名称 e.Result = "GetInitDrumDryData"; } break; case "GetDrumDryData": using (var Client = new SRQZData.QZDataServiceClient()) { DrumDryData = Client.GetZGStatus(context.SessionID); e.Result = "GetDrumDryData"; } break; } } catch (Exception ex) { Utils.Logger.Error(ex.ToString()); } }
private void backgroundWorker1_DoWork(object sender, DoWorkEventArgs e) { backgroundWorker1.ReportProgress(0); try { switch (e.Argument.ToString()) { case "SearchData": int CurrPage = (int)page.CurrentPage; int PageSize = (int)page.PageSize; //Tuple<string, object[]> tWhere = null; //if (ChecktextEdit.Text.IsNullOrEmpty() == false) //{a // string strWhere = "1=1 and ( 明细ID.Contains(@0) ) "; // tWhere = Tuple.Create<string, object[]>(strWhere, new object[] { ChecktextEdit.Text });ref int iTotalNum //} var dtWhere = FilterProcess.CreateFilterTable(); FilterProcess.MergeFilterCondition("明细ID", ChecktextEdit.Text, ref dtWhere, strCompare: "like"); using (SRQZData.QZDataServiceClient client = new SRQZData.QZDataServiceClient()) { int TotalNum = 0; var ret = client.GetOrderSchData(context.SessionID, dtWhere, PageSize, CurrPage, ref TotalNum); page.CurrentPage = CurrPage; page.RowCount = TotalNum; e.Result = ret; } break; default: break; } } catch (Exception ex) { backgroundWorker1.ReportProgress(102, ex.Message); } backgroundWorker1.ReportProgress(100); }
private void CylinderBgWait_DoWork(object sender, DoWorkEventArgs e) { try { switch (e.Argument.ToString()) { case "GetZKLData": using (var Client = new SRQZData.QZDataServiceClient()) { TestData4 = Client.GetL4Data1(context.SessionID); TestData5 = Client.GetL5Data1(context.SessionID); } e.Result = "GetZKLData"; break; } } catch (Exception ex) { Utils.Logger.Error(ex.ToString()); } }
private void BgWait_DoWork(object sender, DoWorkEventArgs e) { BgWait.ReportProgress(PubConstant.WaitMessageStatus.START); try { switch (e.Argument.ToString()) { case "SearchRFID": using (var QZclient = new SRQZData.QZDataServiceClient()) { var ret = QZclient.GetQZRFIDCodeData(context.SessionID, RFIDCodeTextEdit.Text); var Newret = QZclient.GetNewQZRFIDCodeData(context.SessionID, RFIDCodeTextEdit.Text); if (Newret != null && Newret.Rows.Count > 0) { //该位置应存储过磅单号,RFID卡号,配方编号,配方名称,合计重量 //vw_DurmsUpFeedingModel.RFIDCode = ret.Rows[0][0].ToString(); //vw_DurmsUpFeedingModel.FormulaName = ret.Rows[0][9].ToString(); //vw_DurmsUpFeedingModel.MaterialVouchCode = ret.Rows[0][10].ToString(); //vw_DurmsUpFeedingModel.InputWeight = Decimal.Parse(ret.Rows[0][2].ToString()); NewCraftsName.Text = "上料"; vw_DurmsUpFeedingModel.RFIDCode = Newret.Rows[0]["RFID卡号"].ToString(); vw_DurmsUpFeedingModel.FormulaName = Newret.Rows[0]["配方名称"].ToString(); vw_DurmsUpFeedingModel.ProPlanNum = Newret.Rows[0]["参数表编码"].ToString(); vw_DurmsUpFeedingModel.MaterialVouchCode = Newret.Rows[0]["过磅单号"].ToString(); vw_DurmsUpFeedingModel.FormulaCode = Newret.Rows[0]["配方单号"].ToString(); vw_DurmsUpFeedingModel.InputWeight = Decimal.Parse(Newret.Rows[0]["每鼓合计重量"].ToString()); } else { ClsMsg.ShowErrMsg("没有该卡号信息,请重新刷卡"); BgWait.ReportProgress(PubConstant.WaitMessageStatus.END); return; } } using (var MESclient = new SRCfPExecute.CfPExecuteServiceClient()) { // GetCfPExecuteByArrangedVouchCode WorkbrachName var ArrRet = MESclient.GetCfPExecuteByArrangedVouchCode(context.SessionID, vw_DurmsUpFeedingModel.ArrangedVouchCode); vw_DurmsUpFeedingModel.WorkbrachCode = ArrRet.Data.WorkbrachCode; vw_DurmsUpFeedingModel.ExecuteOrder = ArrRet.Data.ExecuteOrder; vw_DurmsUpFeedingModel.ExecuteStatus = ArrRet.Data.ExecuteStatus;//暂定用于判断保存时数据是否被后台或同一时间进行了修正 vw_DurmsUpFeedingModel.CraftsName = ArrRet.Data.CraftsName; vw_DurmsUpFeedingModel.CraftsCode = ArrRet.Data.CraftsCode; vw_DurmsUpFeedingModel.ArrangedVouchCode = ArrRet.Data.ArrangedVouchCode; if (vw_DurmsUpFeedingModel.CraftsName != "上料" && vw_DurmsUpFeedingModel.CraftsName != "空鼓") { ClsMsg.ShowErrMsg("本转鼓不处于空鼓或上料开始阶段,无法使用保存功能"); vw_DurmsUpFeedingModel.WorkbrachCode = ""; RFIDCodeTextEdit.Properties.ReadOnly = true; } else if (vw_DurmsUpFeedingModel.CraftsName == "空鼓") { vw_DurmsUpFeedingModel.ArrangedVouchCode = ""; OperatDescEdit.Text = "上料开始"; NewCraftsName.Text = "上料"; RFIDCodeTextEdit.Properties.ReadOnly = true; } else if (vw_DurmsUpFeedingModel.CraftsName == "上料" && ArrRet.Data.ExecuteStatus != 2) { vw_DurmsUpFeedingModel.ArrangedVouchCode = ArrRet.Data.ArrangedVouchCode; OperatDescEdit.Text = "原料扫卡绑定"; NewCraftsName.Text = "上料"; RFIDCodeTextEdit.Properties.ReadOnly = false; } else { ClsMsg.ShowErrMsg("本转鼓不处于空鼓或上料开始阶段,无法使用保存功能"); vw_DurmsUpFeedingModel.WorkbrachCode = ""; RFIDCodeTextEdit.Properties.ReadOnly = true; } } using (var MESclient = new SRCfPExecute.CfPExecuteServiceClient()) { var ret = MESclient.GetArrangedVouchLogByCode(context.SessionID, ArrangedVouchCodeTextEdit.Text); if (ret.Data != null) { e.Result = ret.Data; } else { BgWait.ReportProgress(PubConstant.WaitMessageStatus.WARNING, ret.Message); } } break; case "SearchDevStatus": using (var MESclient = new SRCfPExecute.CfPExecuteServiceClient()) { var ret = MESclient.GetDurmsUpFeedingByDevCode(context.SessionID, WorkbrachNameTextEdit.Text); if (ret.Data != null) { DeveUseStatusSpinEdit.EditValue = ret.Data[0].DeveUseStatus.ToString(); vw_DurmsUpFeedingModel.DevName = ret.Data[0].DevName; vw_DurmsUpFeedingModel.WorkbrachName = ret.Data[0].DevName; vw_DurmsUpFeedingModel.WorkbrachCode = ret.Data[0].DevCode; } else { ClsMsg.ShowErrMsg("无该设备状态数据,请跟管理员沟通"); } //vw_DurmsUpFeedingModel.WorkbrachName = ret.Data[0].DevCode; var Proret = MESclient.GeCraftsProcessdByWorkbrachName(context.SessionID, WorkbrachNameTextEdit.Text); // vw_DurmsUpFeedingModel.WorkbrachName = Proret.Data.WorkbrachName; vw_DurmsUpFeedingModel.ExecuteOrder = Proret.Data.ExecuteOrder; vw_DurmsUpFeedingModel.ExecuteStatus = Proret.Data.ExecuteStatus; //暂定用于判断保存时数据是否被后台或同一时间进行了修正 vw_DurmsUpFeedingModel.CraftsName = Proret.Data.CraftsName; vw_DurmsUpFeedingModel.RFIDCode = ""; vw_DurmsUpFeedingModel.FormulaName = ""; vw_DurmsUpFeedingModel.InputWeight = null; if (vw_DurmsUpFeedingModel.CraftsName != "上料" && vw_DurmsUpFeedingModel.CraftsName != "空鼓") { ClsMsg.ShowErrMsg("本转鼓不处于空鼓或上料开始阶段,无法使用保存功能"); vw_DurmsUpFeedingModel.WorkbrachCode = ""; RFIDCodeTextEdit.Properties.ReadOnly = true; } else if (vw_DurmsUpFeedingModel.CraftsName == "空鼓") { vw_DurmsUpFeedingModel.ArrangedVouchCode = ""; OperatDescEdit.Text = "上料开始"; NewCraftsName.Text = "上料"; RFIDCodeTextEdit.Properties.ReadOnly = true; } else if (vw_DurmsUpFeedingModel.CraftsName == "上料" && Proret.Data.ExecuteStatus != 2) { vw_DurmsUpFeedingModel.ArrangedVouchCode = Proret.Data.ArrangedVouchCode; // OperatDescEdit.Text = "原料扫卡绑定"; NewCraftsName.Text = "上料"; RFIDCodeTextEdit.Properties.ReadOnly = false; } else { ClsMsg.ShowErrMsg("本转鼓不处于空鼓或上料开始阶段,无法使用保存功能"); vw_DurmsUpFeedingModel.WorkbrachCode = ""; RFIDCodeTextEdit.Properties.ReadOnly = true; } using (var MESclientLog = new SRCfPExecute.CfPExecuteServiceClient()) { var retLog = MESclientLog.GetArrangedVouchLogByCode(context.SessionID, ArrangedVouchCodeTextEdit.Text); if (retLog.Data != null) { e.Result = retLog.Data; } else { BgWait.ReportProgress(PubConstant.WaitMessageStatus.WARNING, retLog.Message); } } } vw_DurmsUpFeedingModel.CreateTime = DateTime.Now; break; case "SearchArrangedVouchLogCode": using (var MESclient = new SRCfPExecute.CfPExecuteServiceClient()) { var ret = MESclient.GetArrangedVouchLogByCode(context.SessionID, ArrangedVouchCodeTextEdit.Text); if (ret.Data != null) { e.Result = ret.Data; } else { BgWait.ReportProgress(PubConstant.WaitMessageStatus.WARNING, ret.Message); } } break; case "InsterArrangedVouchCode": using (var MESclient = new SRCfPExecute.CfPExecuteServiceClient()) { var ret = MESclient.InsterArrVouchByVw(context.SessionID, vw_DurmsUpFeedingModel); //保存排配单数据 if (ret.IsSuccess) { var logModel = new SRCfPExecute.ArrangedVouchLog() { ArrangedVouchCode = ret.Data.ArrangedVouchCode, OperatingTime = vw_DurmsUpFeedingModel.CreateTime, OperatDesc = OperatDescEdit.Text, Operator = OperatorEdit.Text, Frequency = FrequencyEdit.Text, CraftsName = CraftsNameTextEdit.Text, }; vw_DurmsUpFeedingModel.ArrangedVouchCode = ret.Data.ArrangedVouchCode; MESclient.InsterArrVouchLog(context.SessionID, logModel); //保存操作日志数据 BgWait.ReportProgress(99, "保存成功!"); vw_DurmsUpFeedingModel.WorkbrachCode = ""; OperatDescEdit.Text = ""; RFIDCodeTextEdit.Properties.ReadOnly = false; vw_DurmsUpFeedingModel.CreateTime = DateTime.Now; vw_DurmsUpFeedingModel.Creator = context.UserName; using (var MESclientLog = new SRCfPExecute.CfPExecuteServiceClient()) { var retLog = MESclientLog.GetArrangedVouchLogByCode(context.SessionID, ArrangedVouchCodeTextEdit.Text); if (retLog.Data != null) { e.Result = retLog.Data; } else { BgWait.ReportProgress(PubConstant.WaitMessageStatus.WARNING, retLog.Message); } } } } break; case "InsterCraProDataById": using (var MESclient = new SRCfPExecute.CfPExecuteServiceClient()) { var ret = MESclient.UpdateCraftsProcessData(context.SessionID, "CSGH17011", vw_DurmsUpFeedingModel); //保存排配单数据 if (ret.IsSuccess) { BgWait.ReportProgress(99, "保存成功!"); } else { BgWait.ReportProgress(PubConstant.WaitMessageStatus.WARNING, ret.Message); } } break; case "UpdateArrangedVouchCode": using (var MESclient = new SRCfPExecute.CfPExecuteServiceClient()) { var ret = MESclient.UpdateArrangedVouchCode(context.SessionID, vw_DurmsUpFeedingModel); //保存排配单数据 var retTail = MESclient.UpdateCraftsProcessData(context.SessionID, vw_DurmsUpFeedingModel.ProPlanNum, vw_DurmsUpFeedingModel); //修改执行子表跟主表数据 var TestRet = MESclient.UpdateCraftsProcessExecute(context.SessionID, vw_DurmsUpFeedingModel.ArrangedVouchCode, 1, 2); if (ret.IsSuccess) { var logModel = new SRCfPExecute.ArrangedVouchLog() { ArrangedVouchCode = ret.Data.ArrangedVouchCode, OperatingTime = vw_DurmsUpFeedingModel.CreateTime, OperatDesc = OperatDescEdit.Text, Operator = OperatorEdit.Text, Frequency = FrequencyEdit.Text, CraftsName = CraftsNameTextEdit.Text, }; MESclient.InsterArrVouchLog(context.SessionID, logModel); //保存操作日志数据 BgWait.ReportProgress(99, "保存成功!"); vw_DurmsUpFeedingModel.WorkbrachCode = ""; OperatDescEdit.Text = ""; RFIDCodeTextEdit.Properties.ReadOnly = true; vw_DurmsUpFeedingModel.CreateTime = DateTime.Now; vw_DurmsUpFeedingModel.Creator = context.UserName; using (var MESclientLog = new SRCfPExecute.CfPExecuteServiceClient()) { var retLog = MESclientLog.GetArrangedVouchLogByCode(context.SessionID, ArrangedVouchCodeTextEdit.Text); if (retLog.Data != null) { e.Result = retLog.Data; } else { BgWait.ReportProgress(PubConstant.WaitMessageStatus.WARNING, retLog.Message); } } } } break; default: break; } } catch (Exception ex) { BgWait.ReportProgress(PubConstant.WaitMessageStatus.ERROR, ex.Message); } BgWait.ReportProgress(PubConstant.WaitMessageStatus.END); }
private void BgWaitDrumDry_RunWorkerCompleted(object sender, RunWorkerCompletedEventArgs e) { if (e.Result == "GetDrumDryData") { using (var Client = new SRQZData.QZDataServiceClient()) { for (int i = 0; i < DrumDryData.Rows.Count; i++) { if (DrumDryData.Rows[i]["FormulaCode"].ToString() == null || DrumDryData.Rows[i]["FormulaCode"].ToString() == "") { DataTable NullZGStatus = Client.GetNullZGColor(context.SessionID); for (int j = 0; j < QZFunColor.Rows.Count; j++) { if (ColorDataArray[j].ToString() == NullZGStatus.Rows[0]["颜色代码"].ToString()) { listView1.Items[i].ImageIndex = j; // listView1.Items[i].ImageIndex = 0; break; } } } else { DrumColor = Client.GetColorData(context.SessionID, DrumDryData.Rows[i]["FormulaCode"].ToString()); //根据转鼓状态中的配方单号获取该转鼓的颜色代码 for (int j = 0; j < QZFunColor.Rows.Count; j++) { if (ColorDataArray[j].ToString() == DrumColor.Rows[0]["颜色代码"].ToString()) { listView1.Items[i].ImageIndex = j; break; } else if (ColorDataArray[j].ToString() != DrumColor.Rows[0]["颜色代码"].ToString() && j == QZFunColor.Rows.Count - 1) { imageList1.Images.Add(ImageProcess.GetFillEllipseBitmap(28, 28, System.Drawing.ColorTranslator.FromHtml(DrumColor.Rows[0]["颜色代码"].ToString()), "", Color.Black)); ColorDataArray[imageList1.Images.Count] = DrumColor.Rows[0]["颜色代码"].ToString(); // listView1.Items.Add(string.Format("{0}#", Convert.ToInt32(DrumDryData.Rows[i][0].ToString().Substring(DrumDryData.Rows[i][0].ToString().Length - 2))), 0); } } } } } } else if (e.Result == "GetInitDrumDryData") { using (var Client = new SRQZData.QZDataServiceClient()) { DataTable NullZGFunStatus = Client.GetNullZGColor(context.SessionID); for (int j = 0; j < QZFunColor.Rows.Count; j++) { if (ColorDataArray[j].ToString() == NullZGFunStatus.Rows[0]["颜色代码"].ToString()) { ZGNullColor.Items.Add(NullZGFunStatus.Rows[0]["品种"].ToString(), j); break; } } for (int i = 0; i < TestZGDistinct.Rows.Count; i++) { if (TestZGDistinct.Rows[i]["FormulaCode"].ToString() == null || TestZGDistinct.Rows[i]["FormulaCode"].ToString() == "") { } else { DataTable DrumFunColor = Client.GetColorData(context.SessionID, TestZGDistinct.Rows[i]["FormulaCode"].ToString()); if (DrumFunColor.Rows.Count > 0 && DrumFunColor != null) { for (int j = 0; j < QZFunColor.Rows.Count; j++) { if (ColorDataArray[j].ToString() == DrumFunColor.Rows[0]["颜色代码"].ToString()) { ZGFundaVW.Items.Add(DrumFunColor.Rows[0]["配方名称"].ToString(), j); } else { } } } } } for (int i = 0; i < DrumDryData.Rows.Count; i++) { if (DrumDryData.Rows[i]["FormulaCode"].ToString() == null || DrumDryData.Rows[i]["FormulaCode"].ToString() == "") { DataTable NullZGStatus = Client.GetNullZGColor(context.SessionID); for (int j = 0; j < QZFunColor.Rows.Count; j++) { if (ColorDataArray[j].ToString() == NullZGStatus.Rows[0]["颜色代码"].ToString()) { // listView1.Items[i].ImageIndex = j; // listView1.Items[i].ImageIndex = 0; listView1.Items.Add(string.Format("{0}#", Convert.ToInt32(DrumDryData.Rows[i]["DevCode"].ToString().Substring(DrumDryData.Rows[i]["DevCode"].ToString().Length - 2))), j); break; } } } else { DrumColor = Client.GetColorData(context.SessionID, DrumDryData.Rows[i]["FormulaCode"].ToString()); //根据转鼓状态中的配方单号获取该转鼓的颜色代码 if (DrumColor.Rows.Count > 0 && DrumColor != null) { for (int j = 0; j < QZFunColor.Rows.Count; j++) { if (ColorDataArray[j].ToString() == DrumColor.Rows[0]["颜色代码"].ToString()) { listView1.Items.Add(string.Format("{0}#", Convert.ToInt32(DrumDryData.Rows[i]["DevCode"].ToString().Substring(DrumDryData.Rows[i]["DevCode"].ToString().Length - 2))), j); } else { // listView1.Items.Add(string.Format("{0}#", Convert.ToInt32(DrumDryData.Rows[i][0].ToString().Substring(DrumDryData.Rows[i][0].ToString().Length - 2))), 0); } } } } } } } }
/// <summary> /// 获取更新左下角看板数据 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void BgWait_DoWork(object sender, DoWorkEventArgs e) { try { switch (e.Argument.ToString()) { case "GetWeight": e.Result = "GetWeight"; break; case "GetCrafData": e.Result = "GetCrafData"; using (var QZclient = new SRQZData.QZDataServiceClient()) { // var Newret = QZclient.GetQZZGData(context.SessionID, DateTime.Now); Newret = QZclient.GetQZZGData(context.SessionID, DateTime.Now); try { try { if (Newret != null && Newret.Rows.Count > 0) { if (Newret.Rows[0] != null) { ArrInputWeight11 = 0; ArrInputWeight21 = 0; using (var Arrclient = new SRArrangedVouch.ArrangedVServiceClient()) { var NewArr2 = Arrclient.GetArrangedVouchByMulaCode(context.SessionID, Newret.Rows[0]["配方单号"].ToString(), 100); if (NewArr2.Data != null) { ArrInputWeight21 = NewArr2.Data.Sum(t => t.InputWeight) / 1000; } var NewArr1 = Arrclient.GetArrangedVouchByMulaCode(context.SessionID, Newret.Rows[0]["配方单号"].ToString(), 1); if (NewArr1.Data != null) { ArrInputWeight11 = NewArr1.Data.Sum(t => t.InputWeight) / 1000; } } var RFIDWeight1 = QZclient.GetRFIDWeight(context.SessionID, Newret.Rows[0]["配方单号"].ToString()); queryWeight1 = TestQueryWeight(QZclient, Newret, 0); query1 = RFIDWeight1.Compute("sum(每鼓合计重量)/1000", "1=1"); if (query1.ToString() == "") { query1 = 0; } setGridKanbanCallbak(queryWeight1, ArrInputWeight11, ArrInputWeight21, query1, 0, 0); } if (Newret.Rows[1] != null) { ArrInputWeight12 = 0; ArrInputWeight22 = 0; using (var Arrclient = new SRArrangedVouch.ArrangedVServiceClient()) { var NewArr2 = Arrclient.GetArrangedVouchByMulaCode(context.SessionID, Newret.Rows[1]["配方单号"].ToString(), 100); if (NewArr2.Data != null) { ArrInputWeight22 = NewArr2.Data.Sum(t => t.InputWeight) / 1000; } var NewArr1 = Arrclient.GetArrangedVouchByMulaCode(context.SessionID, Newret.Rows[1]["配方单号"].ToString(), 1); if (NewArr1.Data != null) { ArrInputWeight12 = NewArr1.Data.Sum(t => t.InputWeight) / 1000; } var RFIDWeight = QZclient.GetRFIDWeight(context.SessionID, Newret.Rows[1]["配方单号"].ToString()); queryWeight2 = TestQueryWeight(QZclient, Newret, 1); query2 = RFIDWeight.Compute("sum(每鼓合计重量)/1000", "1=1"); if (query2.ToString() == "") { query2 = 0; } // DataTableAssign(Newret, queryWeight1, ArrInputWeight1, ArrInputWeight2, query1, 5, 1); setGridKanbanCallbak(queryWeight2, ArrInputWeight12, ArrInputWeight22, query2, 5, 1); } } } else { MessageBox.Show("没有该备料数据信息"); } } catch (Exception ex) { // ClsMsg.ShowErrMsg(ex.Message); Utils.Logger.Error(ex.ToString()); } // }); //} } catch (Exception ex) { // ClsMsg.ShowErrMsg(ex.Message); Utils.Logger.Error(ex.ToString()); // Utils.Logger.Error(ex.ToString()); } } break; } } catch (Exception ex) { // Utils.Logger.Error(ex.ToString()); Utils.Logger.Error(ex.ToString()); } }