public int UpdateMaterialInDtlList(SqlTransaction Transaction, List <MaterialInDtlModel> mObjs, int MaterialInCode) { try { MaterialInDtlDAL ldal = new MaterialInDtlDAL(Transaction); foreach (MaterialInDtlModel model in ldal.GetMaterialInDtlListByMaterialInCode(MaterialInCode)) { if (FindModel(mObjs, model.MaterialInDtlCode.ToString()) == null) { ldal.Delete(model.MaterialInDtlCode); } } foreach (MaterialInDtlModel model2 in mObjs) { if (model2.MaterialInDtlCode <= 0) { model2.MaterialInDtlCode = int.Parse(SystemManageDAO.GetNewSysCode("MaterialInDtlCode")); model2.MaterialInCode = MaterialInCode; ldal.Insert(model2); continue; } ldal.Update(model2); } } catch (Exception exception) { throw exception; } return(1); }
public int Delete(int Code, SqlTransaction Transaction) { MaterialInDAL ndal = new MaterialInDAL(Transaction); MaterialInDtlDAL ldal = new MaterialInDtlDAL(Transaction); MaterialInDtlQueryModel qmObj = new MaterialInDtlQueryModel(); qmObj.MaterialInCodeEqual = Code.ToString(); foreach (MaterialInDtlModel model2 in ldal.Select(qmObj)) { ldal.Delete(model2.MaterialInDtlCode); } return(ndal.Delete(Code)); }