public void DoDeleteIQC(List<MESParameterInfo> lstParameters) { IQCDal iqcDal = new IQCDal(dbInstance); CustOrderHistoryBll historyBll = new CustOrderHistoryBll(dbInstance, CurrentContextInfo); string eventGroup = Function.GetGUID(); try { dbInstance.BeginTransaction(); List<tinpiqcreturn> lstOldReturn = iqcDal.GetSelectedObjects<tinpiqcreturn>(lstParameters); for (int i = 0; i < lstOldReturn.Count; i++) { iqcDal.RecoverCartonStatus(lstOldReturn[i].custorderno, lstOldReturn[i].cartonno); } baseDal.DoDelete<tinpiqcfail>(lstParameters); baseDal.DoDelete<tinpiqcreturn>(lstParameters); baseDal.DoDelete<tinpiqc>(lstParameters); historyBll.RemoveHistory("IQCReturn", lstParameters[0].ParamValue); dbInstance.Commit(); } catch (Exception ex) { dbInstance.Rollback(); throw ex; } finally { dbInstance.CloseConnection(); } }
public void DoInsertIQC(tinpiqc iqc,List<tinpiqcfail> lstFail, List<tinpiqcreturn> lstReturn) { IQCDal iqcDal = new IQCDal(dbInstance); CustOrderHistoryBll historyBll = new CustOrderHistoryBll(dbInstance, CurrentContextInfo); string eventGroup = Function.GetGUID(); try { dbInstance.BeginTransaction(); iqcDal.DoInsert<tinpiqc>(iqc); for (int i = 0; i < lstFail.Count; i++) { iqcDal.DoInsert<tinpiqcfail>(lstFail[i]); } for (int i = 0; i < lstReturn.Count; i++) { iqcDal.DoInsert<tinpiqcreturn>(lstReturn[i]); iqcDal.UpdateCartonStatus(lstReturn[i].custorderno, lstReturn[i].cartonno); List<MESParameterInfo> lstParam = new List<MESParameterInfo>() { new MESParameterInfo(){ParamName="custorderno",ParamValue=lstReturn[i].custorderno}, new MESParameterInfo(){ParamName="cartonno",ParamValue=lstReturn[i].cartonno} }; List<tinpreceivingctndtl> ctlDtl = baseDal.GetSelectedObjects<tinpreceivingctndtl>(lstParam); if (ctlDtl.Count > 0) { historyBll.WriteHistory("IQCReturn", eventGroup,iqc.customerid, lstReturn[i].custorderno, lstReturn[i].cartonno, ctlDtl[0].styleno, ctlDtl[0].color, ctlDtl[0].size, 1, ctlDtl[0].pairqty, iqc.iqcsysid, iqc.remark); } else { historyBll.WriteHistory("IQCReturn", eventGroup,iqc.customerid, lstReturn[i].custorderno, lstReturn[i].cartonno, string.Empty, string.Empty, string.Empty, 1, 0, iqc.iqcsysid, iqc.remark); } } dbInstance.Commit(); } catch (Exception ex) { dbInstance.Rollback(); throw ex; } finally { dbInstance.CloseConnection(); } }
public DataSet GetValidIQC(string customerid) { IQCDal dal = new IQCDal(dbInstance); return dal.GetValidIQC(customerid); }
public DataSet GetIQCReturn(string iqcsysid, string styleno) { IQCDal dal = new IQCDal(dbInstance); return dal.GetIQCReturn(iqcsysid, styleno); }
public DataSet GetIQCRecords(List<MESParameterInfo> lstParameters) { IQCDal dal = new IQCDal(dbInstance); return dal.GetIQCRecords(lstParameters); }
public DataSet GetIQCFail(string iqcsysid) { IQCDal dal = new IQCDal(dbInstance); return dal.GetIQCFail(iqcsysid); }
public IQCBll(ContextInfo contextInfo) : base(contextInfo) { baseDal = new IQCDal(dbInstance); }