public int UpdateMaterialOutDtlList(SqlTransaction Transaction, List <MaterialOutDtlModel> mObjs, int MaterialOutCode) { try { MaterialOutDtlDAL ldal = new MaterialOutDtlDAL(Transaction); Hashtable hashtable = new Hashtable(); foreach (MaterialOutDtlModel model in ldal.GetMaterialOutDtlListByMaterialOutCode(MaterialOutCode)) { if (!hashtable.Contains(model.MaterialInDtlCode)) { hashtable.Add(model.MaterialInDtlCode, model.MaterialInDtlCode); } if (FindModel(mObjs, model.MaterialOutDtlCode.ToString()) == null) { ldal.Delete(model.MaterialOutDtlCode); } } foreach (MaterialOutDtlModel model2 in mObjs) { if (!hashtable.Contains(model2.MaterialInDtlCode)) { hashtable.Add(model2.MaterialInDtlCode, model2.MaterialInDtlCode); } if (model2.MaterialOutDtlCode <= 0) { model2.MaterialOutDtlCode = int.Parse(SystemManageDAO.GetNewSysCode("MaterialOutDtlCode")); model2.MaterialOutCode = MaterialOutCode; ldal.Insert(model2); continue; } ldal.Update(model2); } IEnumerator enumerator = hashtable.Keys.GetEnumerator(); try { while (enumerator.MoveNext()) { int current = (int)enumerator.Current; string commandText = "update MaterialInDtl set OutQty = (select sum(isnull(OutQty, 0)) from MaterialOutDtl where MaterialInDtlCode = MaterialInDtl.MaterialInDtlCode)"; ldal._DataProcess.RunSql(commandText); } } finally { IDisposable disposable = enumerator as IDisposable; if (disposable != null) { disposable.Dispose(); } } } catch (Exception exception) { throw exception; } return(1); }
public List <MaterialOutDtlModel> GetModels(SqlTransaction Transaction) { List <MaterialOutDtlModel> list; try { list = new MaterialOutDtlDAL(Transaction).Select(); } catch (Exception exception) { throw exception; } return(list); }
public MaterialOutDtlModel GetModel(int Code, SqlTransaction Transaction) { MaterialOutDtlModel model; try { model = new MaterialOutDtlDAL(Transaction).GetModel(Code); } catch (Exception exception) { throw exception; } return(model); }
public int Update(MaterialOutDtlModel ObjModel, SqlTransaction Transaction) { int num; try { num = new MaterialOutDtlDAL(Transaction).Update(ObjModel); } catch (Exception exception) { throw exception; } return(num); }
public List <MaterialOutDtlModel> GetModels(MaterialOutDtlQueryModel ObjQueryModel, SqlConnection Connection) { List <MaterialOutDtlModel> list; try { list = new MaterialOutDtlDAL(Connection).Select(ObjQueryModel); } catch (Exception exception) { throw exception; } return(list); }
public int Delete(int Code, SqlTransaction Transaction) { int num; try { num = new MaterialOutDtlDAL(Transaction).Delete(Code); } catch (Exception exception) { throw exception; } return(num); }
public static List <MaterialOutDtlModel> GetMaterialOutDtlListByContract(string ContractCode) { List <MaterialOutDtlModel> materialOutDtlListByContract; using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString())) { try { materialOutDtlListByContract = new MaterialOutDtlDAL(connection).GetMaterialOutDtlListByContract(ContractCode); } catch (Exception exception) { throw exception; } finally { connection.Close(); } } return(materialOutDtlListByContract); }
public List <MaterialOutDtlModel> GetMaterialOutDtlList(int MaterialOutCode) { List <MaterialOutDtlModel> materialOutDtlListByMaterialOutCode; using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString())) { try { materialOutDtlListByMaterialOutCode = new MaterialOutDtlDAL(connection).GetMaterialOutDtlListByMaterialOutCode(MaterialOutCode); } catch (SqlException exception) { throw exception; } finally { connection.Close(); } } return(materialOutDtlListByMaterialOutCode); }
public int Delete(int Code, SqlTransaction Transaction) { int num; try { MaterialOutDAL tdal = new MaterialOutDAL(Transaction); MaterialOutDtlDAL ldal = new MaterialOutDtlDAL(Transaction); MaterialOutDtlQueryModel qmObj = new MaterialOutDtlQueryModel(); qmObj.MaterialOutCodeEqual = Code.ToString(); foreach (MaterialOutDtlModel model2 in ldal.Select(qmObj)) { ldal.Delete(model2.MaterialOutDtlCode); } num = tdal.Delete(Code); } catch (Exception exception) { throw exception; } return(num); }