public List <YF_AssetManageModel> GetYF_AssetManageList(string SortColumns, int StartRecord, int MaxRecords, int CodeEqual, string FacilityNameEqual, string AreaEqual, string ProducerEqual, string BuyCorpEqual, string ModelNOEqual, string LayCorpEqual, string TypeEqual, string CountsEqual, string UseDeptEqual, string LayPlaceEqual, string CountUnitEqual, string ProdAreaEqual, string SortNOEqual, string SortTypeEqual, string FreeMainEqual, string EquiTypeEqual, string ProviderEqual, DateTime BuyDateEqual, decimal PriceEqual, string RegisterEqual, string MainCardPlaceEqual, string StoreStatusEqual, string RemarkEqual, string StatusEqual, string DeptUnitEqual, DateTime BookINTimeEqual, string BuyTypeEqual, string CodeNOEqual, DateTime StartTimeEqual, DateTime EndTimeEqual)
{
List <YF_AssetManageModel> models = new List <YF_AssetManageModel>();
YF_AssetManageQueryModel objQueryModel = new YF_AssetManageQueryModel();
objQueryModel.StartRecord = StartRecord;
objQueryModel.MaxRecords = MaxRecords;
objQueryModel.SortColumns = SortColumns;
objQueryModel.CodeEqual = CodeEqual;
objQueryModel.FacilityNameEqual = FacilityNameEqual;
objQueryModel.AreaEqual = AreaEqual;
objQueryModel.ProducerEqual = ProducerEqual;
objQueryModel.BuyCorpEqual = BuyCorpEqual;
objQueryModel.ModelNOEqual = ModelNOEqual;
objQueryModel.LayCorpEqual = LayCorpEqual;
objQueryModel.TypeEqual = TypeEqual;
objQueryModel.CountsEqual = CountsEqual;
objQueryModel.UseDeptEqual = UseDeptEqual;
objQueryModel.LayPlaceEqual = LayPlaceEqual;
objQueryModel.CountUnitEqual = CountUnitEqual;
objQueryModel.ProdAreaEqual = ProdAreaEqual;
objQueryModel.SortNOEqual = SortNOEqual;
objQueryModel.SortTypeEqual = SortTypeEqual;
objQueryModel.FreeMainEqual = FreeMainEqual;
objQueryModel.EquiTypeEqual = EquiTypeEqual;
objQueryModel.ProviderEqual = ProviderEqual;
objQueryModel.BuyDateEqual = BuyDateEqual;
objQueryModel.PriceEqual = PriceEqual;
objQueryModel.RegisterEqual = RegisterEqual;
objQueryModel.MainCardPlaceEqual = MainCardPlaceEqual;
objQueryModel.StoreStatusEqual = StoreStatusEqual;
objQueryModel.RemarkEqual = RemarkEqual;
objQueryModel.StatusEqual = StatusEqual;
objQueryModel.DeptUnitEqual = DeptUnitEqual;
objQueryModel.BookINTimeEqual = BookINTimeEqual;
objQueryModel.BuyTypeEqual = BuyTypeEqual;
objQueryModel.CodeNOEqual = CodeNOEqual;
objQueryModel.QueryStartTimeEqual = StartTimeEqual;
objQueryModel.QueryEndTimeEqual = EndTimeEqual;
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
try
{
connection.Open();
models = new YF_AssetManageBLL().GetModels(objQueryModel, connection);
connection.Close();
}
catch (SqlException exception)
{
throw exception;
}
}
return(models);
}
private List <YF_AssetManageModel> _Select(YF_AssetManageQueryModel qmObj)
{
List <YF_AssetManageModel> list = new List <YF_AssetManageModel>();
StringBuilder builder = new StringBuilder();
builder.Append("select * from YF_AssetManage ");
builder.Append(qmObj.QueryConditionStr);
if (qmObj.SortColumns.Length == 0)
{
builder.Append(" ORDER BY Code 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
{
try
{
sqlDataReader = this._DataProcess.GetSqlDataReader();
while (sqlDataReader.Read())
{
if ((num >= qmObj.StartRecord) && ((list.Count < qmObj.MaxRecords) || (qmObj.MaxRecords == -1)))
{
YF_AssetManageModel model = new YF_AssetManageModel();
this.Initialize(sqlDataReader, model);
list.Add(model);
}
num++;
}
}
catch (SqlException exception)
{
throw exception;
}
}
finally
{
if (sqlDataReader != null)
{
sqlDataReader.Close();
}
}
return(list);
}
public List <YF_AssetManageModel> GetYF_AssetManageList(YF_AssetManageQueryModel QueryModel)
{
List <YF_AssetManageModel> models = new List <YF_AssetManageModel>();
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
try
{
connection.Open();
if (QueryModel == null)
{
QueryModel = new YF_AssetManageQueryModel();
}
models = new YF_AssetManageBLL().GetModels(QueryModel, connection);
connection.Close();
}
catch (SqlException exception)
{
throw exception;
}
}
return(models);
}
public List <YF_AssetManageModel> GetModels(YF_AssetManageQueryModel ObjQueryModel, SqlTransaction Transaction)
{
YF_AssetManageDAL edal = new YF_AssetManageDAL(Transaction);
return(edal.Select(ObjQueryModel));
}
public List <YF_AssetManageModel> Select(YF_AssetManageQueryModel qmObj)
{
return(this._Select(qmObj));
}
public List <YF_AssetManageModel> Select()
{
YF_AssetManageQueryModel qmObj = new YF_AssetManageQueryModel();
return(this._Select(qmObj));
}