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 static MaterialInDtlModel GetMaterialInDtl(int Code)
{
MaterialInDtlModel model;
SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString());
try
{
model = new MaterialInDtlBLL().GetModel(Code, connection);
}
catch (Exception exception)
{
throw exception;
}
finally
{
if (connection != null)
{
connection.Dispose();
}
}
return(model);
}
