public void DoInsertWorkOrder(tinpworkorder workorder,
List<tinpworkorderdtl> lstDtl)
{
try
{
dbInstance.BeginTransaction();
baseDal.DoInsert(workorder);
WorkOrderDtlDal dtlDal = new WorkOrderDtlDal(dbInstance);
CustOrderDal custOrderDal = new CustOrderDal(dbInstance);
for (int i = 0; i < lstDtl.Count; i++)
{
dtlDal.DoInsert<tinpworkorderdtl>(lstDtl[i]);
}
dbInstance.Commit();
}
catch (Exception ex)
{
dbInstance.Rollback();
throw ex;
}
finally
{
dbInstance.CloseConnection();
}
}
public void DoUpdateWorkOrder(tinpworkorder workorder,
List<tinpworkorderdtl> lstDtl)
{
try
{
dbInstance.BeginTransaction();
baseDal.DoUpdate(workorder);
WorkOrderDtlDal dtlDal = new WorkOrderDtlDal(dbInstance);
CustOrderDal custOrderDal = new CustOrderDal(dbInstance);
for (int i = 0; i < lstDtl.Count; i++)
{
List<MESParameterInfo> lstParams = new List<MESParameterInfo>() {
new MESParameterInfo(){ParamName="custorderno",ParamValue=lstDtl[i].custorderno},
new MESParameterInfo(){ParamName="styleno",ParamValue=lstDtl[i].styleno},
new MESParameterInfo(){ParamName="checktype",ParamValue=lstDtl[i].checktype}
};
#region check work order detail
List<tinpworkorderdtl> lstWorkOrderDtl = baseDal.GetSelectedObjects<tinpworkorderdtl>(lstParams, string.Empty, true, -1);
if (lstWorkOrderDtl.Count <= 0)
{
//insert
dtlDal.DoInsert<tinpworkorderdtl>(lstDtl[i]);
}
else
{
//update
lstWorkOrderDtl[0].schcartonqty = lstDtl[i].schcartonqty;
lstWorkOrderDtl[0].checktype = lstDtl[i].checktype;
lstWorkOrderDtl[0].completedtime = lstDtl[i].completedtime;
lstWorkOrderDtl[0].completeduser = lstDtl[i].completeduser;
lstWorkOrderDtl[0].schshpdate = lstDtl[i].schshpdate;
lstWorkOrderDtl[0].custorderno = lstDtl[i].custorderno;
lstWorkOrderDtl[0].schdlydate = lstDtl[i].schdlydate;
lstWorkOrderDtl[0].schpairqty = lstDtl[i].schpairqty;
lstWorkOrderDtl[0].remark = lstDtl[i].remark;
lstWorkOrderDtl[0].styleno = lstDtl[i].styleno;
lstWorkOrderDtl[0].workorderlineno = lstDtl[i].workorderlineno;
lstWorkOrderDtl[0].workordersysid = lstDtl[i].workordersysid;
dtlDal.DoUpdate<tinpworkorderdtl>(lstWorkOrderDtl[0]);
}
#endregion
}
#region check delete
CheckDelete(custOrderDal, dtlDal, workorder, lstDtl);
#endregion
dbInstance.Commit();
}
catch (Exception ex)
{
dbInstance.Rollback();
throw ex;
}
finally
{
dbInstance.CloseConnection();
}
}
