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 DoUpdateIQC(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.DoUpdate<tinpiqc>(iqc);
List<MESParameterInfo> lstParameter = new List<MESParameterInfo>()
{
new MESParameterInfo(){ ParamName="iqcsysid", ParamValue=iqc.iqcsysid}
};
List<tinpiqcreturn> lstOldReturn = iqcDal.GetSelectedObjects<tinpiqcreturn>(lstParameter);
for (int i = 0; i < lstOldReturn.Count; i++)
{
iqcDal.RecoverCartonStatus(lstOldReturn[i].custorderno, lstOldReturn[i].cartonno);
}
iqcDal.DoDelete<tinpiqcfail>(lstParameter);
iqcDal.DoDelete<tinpiqcreturn>(lstParameter);
historyBll.RemoveHistory("IQCReturn", iqc.iqcsysid);
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();
}
}