private List <GK_OA_AssetTransferModel> _Select(GK_OA_AssetTransferQueryModel qmObj)
{
List <GK_OA_AssetTransferModel> list = new List <GK_OA_AssetTransferModel>();
StringBuilder builder = new StringBuilder();
builder.Append("select * from GK_OA_AssetTransfer ");
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)))
{
GK_OA_AssetTransferModel model = new GK_OA_AssetTransferModel();
this.Initialize(sqlDataReader, model);
list.Add(model);
}
num++;
}
}
catch (SqlException exception)
{
throw exception;
}
}
finally
{
if (sqlDataReader != null)
{
sqlDataReader.Close();
}
}
return(list);
}
public List <GK_OA_AssetTransferModel> GetGK_OA_AssetTransferList(string SortColumns, int StartRecord, int MaxRecords, int CodeEqual, string NameEqual, string SortEqual, string NumberEqual, string NumUnitEqual, string ReasonEqual, string PreUserEqual, string PreDeptEqual, string PostUserEqual, string PostDeptEqual, string QualityNOEqual, string SNRuleEqual, string SubmiterEqual, DateTime SubTimeEqual, string StatusEqual, decimal OriginalPriceEqual, DateTime StartEqual, DateTime EndEqual)
{
List <GK_OA_AssetTransferModel> models = new List <GK_OA_AssetTransferModel>();
GK_OA_AssetTransferQueryModel objQueryModel = new GK_OA_AssetTransferQueryModel();
objQueryModel.StartRecord = StartRecord;
objQueryModel.MaxRecords = MaxRecords;
objQueryModel.SortColumns = SortColumns;
objQueryModel.CodeEqual = CodeEqual;
objQueryModel.NameEqual = NameEqual;
objQueryModel.SortEqual = SortEqual;
objQueryModel.NumberEqual = NumberEqual;
objQueryModel.NumUnitEqual = NumUnitEqual;
objQueryModel.ReasonEqual = ReasonEqual;
objQueryModel.PreUserEqual = PreUserEqual;
objQueryModel.PreDeptEqual = PreDeptEqual;
objQueryModel.PostUserEqual = PostUserEqual;
objQueryModel.PostDeptEqual = PostDeptEqual;
objQueryModel.QualityNOEqual = QualityNOEqual;
objQueryModel.SNRuleEqual = SNRuleEqual;
objQueryModel.SubmiterEqual = SubmiterEqual;
objQueryModel.SubTimeEqual = SubTimeEqual;
objQueryModel.StatusEqual = StatusEqual;
objQueryModel.OriginalPriceEqual = OriginalPriceEqual;
objQueryModel.StartSubTimeEqual = StartEqual;
objQueryModel.EndSubTimeEqual = EndEqual;
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
try
{
connection.Open();
models = new GK_OA_AssetTransferBLL().GetModels(objQueryModel, connection);
connection.Close();
}
catch (SqlException exception)
{
throw exception;
}
}
return(models);
}
public List <GK_OA_AssetTransferModel> GetGK_OA_AssetTransferList(GK_OA_AssetTransferQueryModel QueryModel)
{
List <GK_OA_AssetTransferModel> models = new List <GK_OA_AssetTransferModel>();
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
try
{
connection.Open();
if (QueryModel == null)
{
QueryModel = new GK_OA_AssetTransferQueryModel();
}
models = new GK_OA_AssetTransferBLL().GetModels(QueryModel, connection);
connection.Close();
}
catch (SqlException exception)
{
throw exception;
}
}
return(models);
}
public List <GK_OA_AssetTransferModel> GetModels(GK_OA_AssetTransferQueryModel ObjQueryModel, SqlTransaction Transaction)
{
GK_OA_AssetTransferDAL rdal = new GK_OA_AssetTransferDAL(Transaction);
return(rdal.Select(ObjQueryModel));
}
public List <GK_OA_AssetTransferModel> Select(GK_OA_AssetTransferQueryModel qmObj)
{
return(this._Select(qmObj));
}
public List <GK_OA_AssetTransferModel> Select()
{
GK_OA_AssetTransferQueryModel qmObj = new GK_OA_AssetTransferQueryModel();
return(this._Select(qmObj));
}
