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);
}
