/// <summary> /// Deprecated Method for adding a new object to the tinprepairstock EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead. /// </summary> public void AddTotinprepairstock(tinprepairstock tinprepairstock) { base.AddObject("tinprepairstock", tinprepairstock); }
/// <summary> /// Create a new tinprepairstock object. /// </summary> /// <param name="customerid">Initial value of the customerid property.</param> /// <param name="custorderno">Initial value of the custorderno property.</param> /// <param name="styleno">Initial value of the styleno property.</param> /// <param name="color">Initial value of the color property.</param> /// <param name="size">Initial value of the size property.</param> /// <param name="checktype">Initial value of the checktype property.</param> /// <param name="workgroup">Initial value of the workgroup property.</param> /// <param name="step">Initial value of the step property.</param> public static tinprepairstock Createtinprepairstock(global::System.String customerid, global::System.String custorderno, global::System.String styleno, global::System.String color, global::System.String size, global::System.String checktype, global::System.String workgroup, global::System.String step) { tinprepairstock tinprepairstock = new tinprepairstock(); tinprepairstock.customerid = customerid; tinprepairstock.custorderno = custorderno; tinprepairstock.styleno = styleno; tinprepairstock.color = color; tinprepairstock.size = size; tinprepairstock.checktype = checktype; tinprepairstock.workgroup = workgroup; tinprepairstock.step = step; return tinprepairstock; }
private void DoRepair() { wsINP.IwsINPClient client = new wsINP.IwsINPClient(); try { baseForm.SetCursor(); baseForm.ValidateData(this); if (((ValueInfo)this.cmbJointType.SelectedItem).ValueField != "") { if (((ValueInfo)this.cmbJointType.SelectedItem).ValueField.Equals("签名") && this.txtSignature.Text.Trim() == "") { throw new Exception(UtilCulture.GetString("Msg.R01020", UtilCulture.GetString("Label.R010763"))); } if (this.numFailedQty.Value > 0) { throw new Exception(UtilCulture.GetString("Msg.R01014", UtilCulture.GetString("Label.R01076"), "0")); } } if (this.numSuccessQty.Value == 0 && this.numFailedQty.Value == 0) { throw new Exception(UtilCulture.GetString("Msg.R01017", UtilCulture.GetString("Label.R01075"), UtilCulture.GetString("Label.R01076"))); } if ((this.numSuccessQty.Value + this.numFailedQty.Value) > RepairStock.curpairqty) { throw new Exception(UtilCulture.GetString("Msg.R01014", UtilCulture.GetString("Label.R01075") + "+" + UtilCulture.GetString("Label.R01076"), UtilCulture.GetString("Label.R01074"))); } tinprepairstock repairstock = new tinprepairstock(); repairstock.customerid = RepairStock.customerid; repairstock.custorderno = this.txtCustOrderNo.Text; repairstock.styleno = this.txtStyleNo.Text; repairstock.color = this.txtColor.Text; repairstock.size = this.txtSize.Text; repairstock.checktype = RepairStock.checktype; repairstock.ttlpairgoodqty = this.numSuccessQty.Value; repairstock.ttlbadqty = this.numFailedQty.Value; repairstock.step = ((ValueInfo)this.cmbToStep.SelectedItem).ValueField; repairstock.workgroup = ((ValueInfo)this.cmbWorkGroup.SelectedItem).ValueField; List<tinprepairfail> lstreasoncode = new List<tinprepairfail>(); foreach (UltraGridRow row in this.grdDetail.Rows) { if (row.Cells["ck"].Value.ToString().Equals("Y")) { if (Convert.ToDecimal(row.Cells["pairqty"].Value) == 0) { throw new Exception(UtilCulture.GetString("Msg.R01016", UtilCulture.GetString("Label.R010761"))); } tinprepairfail repairfail = new tinprepairfail(); repairfail.reasoncode = row.Cells["reasoncode"].Value.ToString(); repairfail.remark = row.Cells["remark"].Value.ToString(); repairfail.pairqty = Convert.ToDecimal(row.Cells["pairqty"].Value); lstreasoncode.Add(repairfail); } } client.DoRepairBack(baseForm.CurrentContextInfo, repairstock, lstreasoncode.ToArray<tinprepairfail>(), ((ValueInfo)this.cmbJointType.SelectedItem).ValueField,this.txtSignature.Text.Trim()); baseForm.CreateMessageBox(Public_MessageBox.Information, MessageBoxButtons.OK, null, UtilCulture.GetString("Msg.R00002")); this.Close(); } catch (Exception ex) { baseForm.CreateMessageBox(Public_MessageBox.Error, MessageBoxButtons.OK, null, ex.Message); } finally { baseForm.ResetCursor(); baseForm.CloseWCF(client); } }
public void DoInsertRepair(tinprepairhis repairhis,List<tinprepairfail> lstreasoncode) { try { dbInstance.BeginTransaction(); repairHisDal.DoInsert(repairhis); foreach (tinprepairfail repairfail in lstreasoncode) { repairfail.repsysid = repairhis.repsysid; repairFailDal.DoInsert(repairfail); } List<MESParameterInfo> lstParams = new List<MESParameterInfo>() { new MESParameterInfo(){ParamName="customerid",ParamValue=repairhis.customerid}, new MESParameterInfo(){ParamName="custorderno",ParamValue=repairhis.custorderno}, new MESParameterInfo(){ParamName="styleno",ParamValue=repairhis.styleno}, new MESParameterInfo(){ParamName="color",ParamValue=repairhis.color}, new MESParameterInfo(){ParamName="size",ParamValue=repairhis.size}, new MESParameterInfo(){ParamName="checktype",ParamValue=repairhis.checktype}, new MESParameterInfo(){ParamName="workgroup",ParamValue=repairhis.workgroup}, new MESParameterInfo(){ParamName="step",ParamValue=repairhis.step} }; List<tinprepairstock> lstRepairStock = baseDal.GetSelectedObjects<tinprepairstock>(lstParams, string.Empty, true, -1); if (lstRepairStock.Count > 0) { tinprepairstock repairStock = lstRepairStock[0]; repairStock.curpairqty = repairStock.curpairqty + repairhis.pairqty; baseDal.DoUpdate(repairStock); } else { tinprepairstock repairStock = new tinprepairstock(); repairStock.customerid = repairhis.customerid; repairStock.custorderno = repairhis.custorderno; repairStock.styleno = repairhis.styleno; repairStock.color = repairhis.color; repairStock.size = repairhis.size; repairStock.checktype = repairhis.checktype; repairStock.curpairqty = repairhis.pairqty; repairStock.ttlbadqty = 0; repairStock.ttlpairgoodqty = 0; repairStock.workgroup = repairhis.workgroup; repairStock.step = repairhis.step; repairStock.lastupdatetime = Function.GetCurrentTime(); baseDal.DoInsert(repairStock); } #region Update WIP wipDal.SaveOrUpdate(repairhis.customerid, repairhis.custorderno, repairhis.styleno, repairhis.color, repairhis.size, repairhis.step, repairhis.workgroup, Convert.ToInt16(-repairhis.pairqty), repairhis.checktype); wipDal.SaveOrUpdate(repairhis.customerid, repairhis.custorderno, repairhis.styleno, repairhis.color, repairhis.size, MES_WIPStatus.Repair.ToString(), repairhis.workgroup, Convert.ToInt16(repairhis.pairqty), repairhis.checktype); #endregion #region Update CustomerOrder History tinpcustorderhistory history = new tinpcustorderhistory(); history.customerid = ""; history.cartonno = ""; history.cartonqty = 0; history.custorderno = repairhis.custorderno; history.size = repairhis.size; history.styleno = repairhis.styleno; history.color = repairhis.color; history.eventgroup = Function.GetGUID(); history.eventname = "To Repair"; history.pairqty = repairhis.pairqty; history.refsysid = repairhis.repsysid; history.remark = ""; history.eventtime = Function.GetCurrentTime(); history.eventuser = CurrentContextInfo.CurrentUser; history.ohsysid = Function.GetGUID(); history.shift = CurrentContextInfo.Shift; history.workgroup = CurrentContextInfo.WorkGroup; custOrderHistoryDal.DoInsert<tinpcustorderhistory>(history); #endregion dbInstance.Commit(); } catch (Exception ex) { dbInstance.Rollback(); throw ex; } finally { dbInstance.CloseConnection(); } }
public void DoRepairBack(tinprepairstock repairstock, List<tinprepairfail> lstreasoncode, string jointtype, string signature) { try { dbInstance.BeginTransaction(); #region repairhis tinprepairhis goodhis = new tinprepairhis(); if (repairstock.ttlpairgoodqty > 0) { goodhis.repsysid = Function.GetGUID(); goodhis.workgroup = repairstock.workgroup; goodhis.step = repairstock.step; goodhis.reptype = MES_RepairType.RepairSuccess.ToString(); goodhis.customerid = repairstock.customerid; goodhis.custorderno = repairstock.custorderno; goodhis.styleno = repairstock.styleno; goodhis.color = repairstock.color; goodhis.size = repairstock.size; goodhis.checktype = repairstock.checktype; goodhis.pairqty = repairstock.ttlpairgoodqty; goodhis.claimtime = Function.GetCurrentTime(); goodhis.claimuser = CurrentContextInfo.CurrentUser; if (jointtype != null && signature != null) { goodhis.jointtype = jointtype; goodhis.signature = signature; } repairHisDal.DoInsert(goodhis); } tinprepairhis badhis = new tinprepairhis(); if (repairstock.ttlbadqty > 0) { badhis.repsysid = Function.GetGUID(); badhis.workgroup = repairstock.workgroup; badhis.step = repairstock.step; badhis.reptype = MES_RepairType.RepairFail.ToString(); badhis.customerid = repairstock.customerid; badhis.custorderno = repairstock.custorderno; badhis.styleno = repairstock.styleno; badhis.color = repairstock.color; badhis.size = repairstock.size; badhis.checktype = repairstock.checktype; badhis.pairqty = repairstock.ttlbadqty; badhis.claimtime = Function.GetCurrentTime(); badhis.claimuser = CurrentContextInfo.CurrentUser; repairHisDal.DoInsert(badhis); foreach (tinprepairfail repairfail in lstreasoncode) { repairfail.repsysid = badhis.repsysid; repairFailDal.DoInsert(repairfail); } } #endregion List<MESParameterInfo> lstParams = new List<MESParameterInfo>() { new MESParameterInfo(){ParamName="customerid",ParamValue=repairstock.customerid}, new MESParameterInfo(){ParamName="custorderno",ParamValue=repairstock.custorderno}, new MESParameterInfo(){ParamName="styleno",ParamValue=repairstock.styleno}, new MESParameterInfo(){ParamName="color",ParamValue=repairstock.color}, new MESParameterInfo(){ParamName="size",ParamValue=repairstock.size}, new MESParameterInfo(){ParamName="checktype",ParamValue=repairstock.checktype}, new MESParameterInfo(){ParamName="step",ParamValue=repairstock.step}, new MESParameterInfo(){ParamName="workgroup",ParamValue=repairstock.workgroup} }; List<tinprepairstock> lstRepairStock = baseDal.GetSelectedObjects<tinprepairstock>(lstParams, string.Empty, true, -1); if (lstRepairStock.Count > 0) { tinprepairstock rsk = lstRepairStock[0]; rsk.curpairqty = rsk.curpairqty - repairstock.ttlpairgoodqty - repairstock.ttlbadqty; rsk.ttlbadqty = rsk.ttlbadqty + repairstock.ttlbadqty; rsk.ttlpairgoodqty = rsk.ttlpairgoodqty + repairstock.ttlpairgoodqty; rsk.lastupdatetime = Function.GetCurrentTime(); baseDal.DoUpdate(rsk); } #region Update WIP wipDal.SaveOrUpdate(repairstock.customerid, repairstock.custorderno, repairstock.styleno, repairstock.color, repairstock.size, repairstock.step, repairstock.workgroup, Convert.ToInt16(repairstock.ttlpairgoodqty), repairstock.checktype); wipDal.SaveOrUpdate(repairstock.customerid, repairstock.custorderno, repairstock.styleno, repairstock.color, repairstock.size, MES_WIPStatus.BAD.ToString(), MES_Misc.BadStock.ToString(), Convert.ToInt16(repairstock.ttlbadqty), repairstock.checktype); wipDal.SaveOrUpdate(repairstock.customerid, repairstock.custorderno, repairstock.styleno, repairstock.color, repairstock.size, MES_WIPStatus.Repair.ToString(), repairstock.workgroup, -Convert.ToInt16(repairstock.ttlpairgoodqty + repairstock.ttlbadqty), repairstock.checktype); #endregion #region Update CustomerOrder History string eventgroup = Function.GetGUID(); if (goodhis.pairqty > 0) { tinpcustorderhistory goodhistory = new tinpcustorderhistory(); goodhistory.customerid = goodhis.customerid; goodhistory.cartonno = ""; goodhistory.cartonqty = 0; goodhistory.custorderno = goodhis.custorderno; goodhistory.size = goodhis.size; goodhistory.styleno = goodhis.styleno; goodhistory.color = goodhis.color; goodhistory.eventgroup = eventgroup; goodhistory.eventname = "Repair"; goodhistory.pairqty = goodhis.pairqty; goodhistory.refsysid = goodhis.repsysid; goodhistory.remark = ""; goodhistory.eventtime = Function.GetCurrentTime(); goodhistory.eventuser = CurrentContextInfo.CurrentUser; goodhistory.ohsysid = Function.GetGUID(); goodhistory.shift = CurrentContextInfo.Shift; goodhistory.workgroup = CurrentContextInfo.WorkGroup; custOrderHistoryDal.DoInsert<tinpcustorderhistory>(goodhistory); } if (badhis.pairqty > 0) { tinpcustorderhistory badhistory = new tinpcustorderhistory(); badhistory.customerid = badhis.customerid; badhistory.cartonno = ""; badhistory.cartonqty = 0; badhistory.custorderno = badhis.custorderno; badhistory.size = badhis.size; badhistory.styleno = badhis.styleno; badhistory.color = badhis.color; badhistory.eventgroup = eventgroup; badhistory.eventname = "Repair"; badhistory.pairqty = badhis.pairqty; badhistory.refsysid = badhis.repsysid; badhistory.remark = ""; badhistory.eventtime = Function.GetCurrentTime(); badhistory.eventuser = CurrentContextInfo.CurrentUser; badhistory.ohsysid = Function.GetGUID(); badhistory.shift = CurrentContextInfo.Shift; badhistory.workgroup = CurrentContextInfo.WorkGroup; custOrderHistoryDal.DoInsert<tinpcustorderhistory>(badhistory); } #endregion dbInstance.Commit(); } catch (Exception ex) { dbInstance.Rollback(); throw ex; } finally { dbInstance.CloseConnection(); } }
private void ucToolbar1_RepairEventHandler(object sender, EventArgs e) { if (this.grdQuery.ActiveRow != null) { frmRepair f = new frmRepair(); tinprepairstock repairstock = new tinprepairstock(); repairstock.customerid = this.grdQuery.ActiveRow.Cells["customerid"].Value.ToString(); repairstock.custorderno = this.grdQuery.ActiveRow.Cells["custorderno"].Value.ToString(); repairstock.styleno = this.grdQuery.ActiveRow.Cells["styleno"].Value.ToString(); repairstock.size = this.grdQuery.ActiveRow.Cells["size"].Value.ToString(); repairstock.color = this.grdQuery.ActiveRow.Cells["color"].Value.ToString(); repairstock.checktype = this.grdQuery.ActiveRow.Cells["checktype"].Value.ToString(); repairstock.curpairqty = Convert.ToInt16(this.grdQuery.ActiveRow.Cells["curpairqty"].Value.ToString()); repairstock.step = this.grdQuery.ActiveRow.Cells["step"].Value.ToString(); repairstock.workgroup = this.grdQuery.ActiveRow.Cells["workgroup"].Value.ToString(); f.Customer = this.grdQuery.ActiveRow.Cells["customername"].Value.ToString(); f.RepairStock = repairstock; f.ShowDialog(); RefreshGrid(); } }
public void DoRepairBack(ContextInfo contextInfo, tinprepairstock repairstock, List<tinprepairfail> lstreasoncode, string jointtype, string signature) { contextInfo.Action = MES_ActionType.Insert; RepairStockBll bll = new RepairStockBll(contextInfo); bll.CallAccessControl(); bll.DoRepairBack(repairstock, lstreasoncode, jointtype, signature); GC.Collect(); }