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));
}
public List <MaterialInDtlModel> GetModels(SqlTransaction Transaction)
{
List <MaterialInDtlModel> list;
try
{
list = new MaterialInDtlDAL(Transaction).Select();
}
catch (Exception exception)
{
throw exception;
}
return(list);
}
public MaterialInDtlModel GetModel(int Code, SqlTransaction Transaction)
{
MaterialInDtlModel model;
try
{
model = new MaterialInDtlDAL(Transaction).GetModel(Code);
}
catch (Exception exception)
{
throw exception;
}
return(model);
}
public int Update(MaterialInDtlModel ObjModel, SqlTransaction Transaction)
{
int num;
try
{
num = new MaterialInDtlDAL(Transaction).Update(ObjModel);
}
catch (Exception exception)
{
throw exception;
}
return(num);
}
public List <MaterialInDtlModel> GetModels(MaterialInDtlQueryModel ObjQueryModel, SqlConnection Connection)
{
List <MaterialInDtlModel> list;
try
{
list = new MaterialInDtlDAL(Connection).Select(ObjQueryModel);
}
catch (Exception exception)
{
throw exception;
}
return(list);
}
public int Delete(int Code, SqlTransaction Transaction)
{
int num;
try
{
num = new MaterialInDtlDAL(Transaction).Delete(Code);
}
catch (Exception exception)
{
throw exception;
}
return(num);
}
public List <MaterialInDtlModel> GetMaterialInDtlList(int MaterialInCode)
{
List <MaterialInDtlModel> materialInDtlListByMaterialInCode;
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
try
{
materialInDtlListByMaterialInCode = new MaterialInDtlDAL(connection).GetMaterialInDtlListByMaterialInCode(MaterialInCode);
}
catch (Exception exception)
{
throw exception;
}
finally
{
connection.Close();
}
}
return(materialInDtlListByMaterialInCode);
}
public static List <MaterialInDtlModel> GetMaterialInDtlListByContract(string ContractCode, int MaterialCode)
{
List <MaterialInDtlModel> materialInDtlListByContract;
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
try
{
materialInDtlListByContract = new MaterialInDtlDAL(connection).GetMaterialInDtlListByContract(ContractCode, MaterialCode);
}
catch (Exception exception)
{
throw exception;
}
finally
{
connection.Close();
}
}
return(materialInDtlListByContract);
}
