public List <MaterialInDtlModel> GetMaterialInDtlListByMaterialInCode(int MaterialInCode)
{
MaterialInDtlQueryModel qmObj = new MaterialInDtlQueryModel();
qmObj.StartRecord = 0;
qmObj.MaxRecords = -1;
qmObj.SortColumns = "MaterialInDtlCode";
qmObj.MaterialInCodeEqual = (MaterialInCode.ToString() == "0") ? "-1" : MaterialInCode.ToString();
return(this._Select(qmObj));
}
public List <MaterialInDtlModel> GetMaterialInDtlListByContract(string ContractCode)
{
MaterialInDtlQueryModel qmObj = new MaterialInDtlQueryModel();
qmObj.StartRecord = 0;
qmObj.MaxRecords = -1;
qmObj.SortColumns = "MaterialInDtlCode";
qmObj.ContractCodeEqual = (ContractCode == "") ? "-1" : ContractCode.ToString();
return(this._Select(qmObj));
}
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> SelectMaterialInDtlList(string SortColumns, int StartRecord, int MaxRecords, string AccessRange, string MaterialInDtlCodeEqual, string MaterialInCodeEqual, string MaterialCodeEqual, string InQtyEqual, string InPriceEqual, string InMoneyEqual, string OutQtyEqual, string MaterialNameEqual, string SpecEqual, string UnitEqual, string GroupCodeEqual, string GroupNameEqual, string GroupFullIDEqual, string GroupSortIDEqual, string InvQtyEqual, string InvMoneyEqual, string MaterialInIDEqual, string InDateRange1, string InDateRange2, string ContractCodeEqual, string InGroupCodeEqual, string InGroupNameEqual, string ProjectCodeEqual)
{
List <MaterialInDtlModel> models;
MaterialInDtlQueryModel objQueryModel = new MaterialInDtlQueryModel();
objQueryModel.StartRecord = StartRecord;
objQueryModel.MaxRecords = MaxRecords;
objQueryModel.SortColumns = SortColumns;
objQueryModel.AccessRange = AccessRange;
objQueryModel.MaterialInDtlCodeEqual = MaterialInDtlCodeEqual;
objQueryModel.MaterialInCodeEqual = MaterialInCodeEqual;
objQueryModel.MaterialCodeEqual = MaterialCodeEqual;
objQueryModel.InQtyEqual = InQtyEqual;
objQueryModel.InPriceEqual = InPriceEqual;
objQueryModel.InMoneyEqual = InMoneyEqual;
objQueryModel.OutQtyEqual = OutQtyEqual;
objQueryModel.MaterialNameEqual = MaterialNameEqual;
objQueryModel.SpecEqual = SpecEqual;
objQueryModel.UnitEqual = UnitEqual;
objQueryModel.GroupCodeEqual = GroupCodeEqual;
objQueryModel.GroupNameEqual = GroupNameEqual;
objQueryModel.GroupFullIDEqual = GroupFullIDEqual;
objQueryModel.GroupSortIDEqual = GroupSortIDEqual;
objQueryModel.InvQtyEqual = InvQtyEqual;
objQueryModel.InvMoneyEqual = InvMoneyEqual;
objQueryModel.MaterialInIDEqual = MaterialInIDEqual;
objQueryModel.InDateRange1 = InDateRange1;
objQueryModel.InDateRange2 = InDateRange2;
objQueryModel.ContractCodeEqual = ContractCodeEqual;
objQueryModel.InGroupCodeEqual = InGroupCodeEqual;
objQueryModel.InGroupNameEqual = InGroupNameEqual;
objQueryModel.ProjectCodeEqual = ProjectCodeEqual;
SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString());
try
{
models = new MaterialInDtlBLL().GetModels(objQueryModel, connection);
}
catch (Exception exception)
{
throw exception;
}
finally
{
if (connection != null)
{
connection.Dispose();
}
}
return(models);
}
public List <MaterialInDtlModel> GetModels(MaterialInDtlQueryModel ObjQueryModel, SqlTransaction Transaction)
{
List <MaterialInDtlModel> list;
try
{
list = new MaterialInDtlDAL(Transaction).Select(ObjQueryModel);
}
catch (Exception exception)
{
throw exception;
}
return(list);
}
private List <MaterialInDtlModel> _Select(MaterialInDtlQueryModel qmObj)
{
List <MaterialInDtlModel> list = new List <MaterialInDtlModel>();
StringBuilder builder = new StringBuilder();
builder.Append("select * from V_MaterialInDtl as MaterialInDtl ");
builder.Append(qmObj.QueryConditionStr);
if ((qmObj.SortColumns == null) || (qmObj.SortColumns.Length == 0))
{
builder.Append(" ORDER BY MaterialInDtlCode desc");
}
else
{
builder.Append(" ORDER BY " + qmObj.SortColumns);
}
this._DataProcess.CommandText = builder.ToString();
this._DataProcess.SqlParameters = qmObj.Parameters;
SqlDataReader sqlDataReader = null;
int num = 0;
try
{
sqlDataReader = this._DataProcess.GetSqlDataReader();
while (sqlDataReader.Read())
{
if ((num >= qmObj.StartRecord) && ((list.Count < qmObj.MaxRecords) || (qmObj.MaxRecords == -1)))
{
MaterialInDtlModel model = new MaterialInDtlModel();
this.Initialize(sqlDataReader, model);
list.Add(model);
}
num++;
}
}
catch (SqlException exception)
{
throw exception;
}
finally
{
if (sqlDataReader != null)
{
sqlDataReader.Close();
}
}
return(list);
}
public List <MaterialInDtlModel> Select(MaterialInDtlQueryModel qmObj)
{
return(this._Select(qmObj));
}
public List <MaterialInDtlModel> Select()
{
MaterialInDtlQueryModel qmObj = new MaterialInDtlQueryModel();
return(this._Select(qmObj));
}
