private List <GK_OA_CapitalAssertAcountModel> _Select(GK_OA_CapitalAssertAcountQueryModel qmObj)
{
List <GK_OA_CapitalAssertAcountModel> list = new List <GK_OA_CapitalAssertAcountModel>();
StringBuilder builder = new StringBuilder();
builder.Append("select * from GK_OA_CapitalAssertAcount ");
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_CapitalAssertAcountModel model = new GK_OA_CapitalAssertAcountModel();
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_CapitalAssertAcountModel> GetGK_OA_CapitalAssertAcountList(string SortColumns, int StartRecord, int MaxRecords, int CodeEqual, string NameEqual, string TypeEqual, string NumberEqual, DateTime BuydateEqual, int BuyCountEqual, decimal PriceEqual, string UnitEqual, string DeptEqual, string TransferRecordEqual, string UserNameEqual, string PlaceEqual, string RemarkEqual, string QualityNOEqual, string SNRuleEqual, string StatusEqual, DateTime StartDay, DateTime EndDay)
{
List <GK_OA_CapitalAssertAcountModel> models = new List <GK_OA_CapitalAssertAcountModel>();
GK_OA_CapitalAssertAcountQueryModel objQueryModel = new GK_OA_CapitalAssertAcountQueryModel();
objQueryModel.StartRecord = StartRecord;
objQueryModel.MaxRecords = MaxRecords;
objQueryModel.SortColumns = SortColumns;
objQueryModel.CodeEqual = CodeEqual;
objQueryModel.NameEqual = NameEqual;
objQueryModel.TypeEqual = TypeEqual;
objQueryModel.NumberEqual = NumberEqual;
objQueryModel.BuydateEqual = BuydateEqual;
objQueryModel.BuyCountEqual = BuyCountEqual;
objQueryModel.PriceEqual = PriceEqual;
objQueryModel.UnitEqual = UnitEqual;
objQueryModel.DeptEqual = DeptEqual;
objQueryModel.TransferRecordEqual = TransferRecordEqual;
objQueryModel.UserNameEqual = UserNameEqual;
objQueryModel.PlaceEqual = PlaceEqual;
objQueryModel.RemarkEqual = RemarkEqual;
objQueryModel.QualityNOEqual = QualityNOEqual;
objQueryModel.SNRuleEqual = SNRuleEqual;
objQueryModel.StatusEqual = StatusEqual;
objQueryModel.StartDayEqual = StartDay;
objQueryModel.EndDayEqual = EndDay;
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
try
{
connection.Open();
models = new GK_OA_CapitalAssertAcountBLL().GetModels(objQueryModel, connection);
connection.Close();
}
catch (SqlException exception)
{
throw exception;
}
}
return(models);
}
public List <GK_OA_CapitalAssertAcountModel> GetGK_OA_CapitalAssertAcountList(GK_OA_CapitalAssertAcountQueryModel QueryModel)
{
List <GK_OA_CapitalAssertAcountModel> models = new List <GK_OA_CapitalAssertAcountModel>();
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
try
{
connection.Open();
if (QueryModel == null)
{
QueryModel = new GK_OA_CapitalAssertAcountQueryModel();
}
models = new GK_OA_CapitalAssertAcountBLL().GetModels(QueryModel, connection);
connection.Close();
}
catch (SqlException exception)
{
throw exception;
}
}
return(models);
}
public List <GK_OA_CapitalAssertAcountModel> GetModels(GK_OA_CapitalAssertAcountQueryModel ObjQueryModel, SqlTransaction Transaction)
{
GK_OA_CapitalAssertAcountDAL tdal = new GK_OA_CapitalAssertAcountDAL(Transaction);
return(tdal.Select(ObjQueryModel));
}
public List <GK_OA_CapitalAssertAcountModel> Select(GK_OA_CapitalAssertAcountQueryModel qmObj)
{
return(this._Select(qmObj));
}
public List <GK_OA_CapitalAssertAcountModel> Select()
{
GK_OA_CapitalAssertAcountQueryModel qmObj = new GK_OA_CapitalAssertAcountQueryModel();
return(this._Select(qmObj));
}
