/// <summary> /// Create a new tinprepairhis object. /// </summary> /// <param name="repsysid">Initial value of the repsysid 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> public static tinprepairhis Createtinprepairhis(global::System.String repsysid, global::System.String custorderno, global::System.String styleno, global::System.String color, global::System.String size) { tinprepairhis tinprepairhis = new tinprepairhis(); tinprepairhis.repsysid = repsysid; tinprepairhis.custorderno = custorderno; tinprepairhis.styleno = styleno; tinprepairhis.color = color; tinprepairhis.size = size; return tinprepairhis; }
private void DoRepair(bool closeFlag) { wsINP.IwsINPClient client = new wsINP.IwsINPClient(); try{ baseForm.SetCursor(); baseForm.ValidateData(this); if (this.numRepairQty.Value > Convert.ToInt16(this.txtPairQty.Text)) { throw new Exception(UtilCulture.GetString("Msg.R01014", UtilCulture.GetString("Label.R02026"), UtilCulture.GetString("Label.R02036"))); } tinprepairhis his = new tinprepairhis(); his.repsysid = Function.GetGUID(); his.workgroup = ((ValueInfo)this.cmbWorkGroup.SelectedItem).ValueField; his.step = ((ValueInfo)this.cmbStep.SelectedItem).ValueField; his.reptype = MES_RepairType.ToRepair.ToString(); his.customerid = this.ucmbCustOrderNo.SelectedRow.Cells["customerid"].Value.ToString(); his.custorderno = this.ucmbCustOrderNo.Value.ToString(); his.styleno = this.txtStyleNo.Text; his.color = this.txtColor.Text; his.size = this.txtSize.Text; his.checktype = this.ucmbCustOrderNo.SelectedRow.Cells["checktype"].Value.ToString(); his.isfirst = this.ckIsFirst.Checked ? MES_Misc.Y.ToString() : MES_Misc.N.ToString(); his.pairqty = this.numRepairQty.Value; his.claimtime = Function.GetCurrentTime(); his.claimuser = Function.GetCurrentUser(); 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.R02036"))); } 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); } } if (this.numRepairQty.Value == 0) { throw new Exception(UtilCulture.GetString("Msg.R01016", UtilCulture.GetString("Label.R02036"))); } if (lstreasoncode.Count == 0) { throw new Exception(UtilCulture.GetString("Msg.R01015")); } client.DoInsertRepair(baseForm.CurrentContextInfo, his, lstreasoncode.ToArray<tinprepairfail>()); baseForm.CreateMessageBox(Public_MessageBox.Information, MessageBoxButtons.OK, null, UtilCulture.GetString("Msg.R00002")); if (closeFlag) { this.Close(); } else { Clean(); } } catch (Exception ex) { baseForm.CreateMessageBox(Public_MessageBox.Error, MessageBoxButtons.OK, null, ex.Message); } finally { baseForm.ResetCursor(); baseForm.CloseWCF(client); } }
/// <summary> /// Deprecated Method for adding a new object to the tinprepairhis EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead. /// </summary> public void AddTotinprepairhis(tinprepairhis tinprepairhis) { base.AddObject("tinprepairhis", tinprepairhis); }
private void ucToolbar1_AdjustEventHandler(object sender, EventArgs e) { frmRepairAdjust f = new frmRepairAdjust(); tinprepairhis repairhis = new tinprepairhis(); repairhis.repsysid = this.grdQuery.ActiveRow.Cells["repsysid"].Value.ToString(); repairhis.customerid = this.grdQuery.ActiveRow.Cells["customerid"].Value.ToString(); repairhis.custorderno = this.grdQuery.ActiveRow.Cells["custorderno"].Value.ToString(); repairhis.styleno = this.grdQuery.ActiveRow.Cells["styleno"].Value.ToString(); repairhis.size = this.grdQuery.ActiveRow.Cells["size"].Value.ToString(); repairhis.color = this.grdQuery.ActiveRow.Cells["color"].Value.ToString(); repairhis.pairqty = Convert.ToInt16(this.grdQuery.ActiveRow.Cells["pairqty"].Value.ToString()); repairhis.step = this.grdQuery.ActiveRow.Cells["step"].Value.ToString(); repairhis.workgroup = this.grdQuery.ActiveRow.Cells["workgroup"].Value.ToString(); repairhis.reptype = this.grdQuery.ActiveRow.Cells["reptype"].Value.ToString(); f.Customer = this.grdQuery.ActiveRow.Cells["customername"].Value.ToString(); f.ReaseanCode = this.grdQuery.ActiveRow.Cells["reasoncode"].Value.ToString(); f.RepairHis = repairhis; f.ShowDialog(); RefreshGrid(); }
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(); } }
public void DoInsertRepair(ContextInfo contextInfo, tinprepairhis repairhis, List<tinprepairfail> lstreasoncode) { contextInfo.Action = MES_ActionType.Insert; RepairStockBll bll = new RepairStockBll(contextInfo); bll.CallAccessControl(); bll.DoInsertRepair(repairhis, lstreasoncode); GC.Collect(); }