/// <summary>
/// 读取记录列表。
/// </summary>
/// <param name="db">数据库操作对象</param>
/// <param name="columns">需要返回的列，不提供任何列名时默认将返回所有列</param>
public IList <VWProductFineEntity> GetProductFineList(int pagesize, int pageindex, ref int recordCount, int finetype)
{
string where = " where 1=1 ";
if (finetype != -1)
{
where += " and FineModuleId=@FineModuleId ";
}
string sql = @"SELECT [Id],[ProductDetailId],[Sort],[BeginTime],[EndTime],[IsActive],[FineModuleId]
FROM
(SELECT ROW_NUMBER() OVER (ORDER BY Id desc) AS ROWNUMBER,
[Id],[ProductDetailId],[Sort],[BeginTime],[EndTime],[IsActive],[FineModuleId] from dbo.[ProductFine] WITH(NOLOCK)
" + where + @" ) as temp
where rownumber BETWEEN ((@PageIndex - 1) * @PageSize + 1) AND @PageIndex * @PageSize" ;
string sql2 = @"Select count(1) from dbo.[ProductFine] with (nolock) " + where;
IList <VWProductFineEntity> entityList = new List <VWProductFineEntity>();
DbCommand cmd = db.GetSqlStringCommand(sql);
db.AddInParameter(cmd, "@PageIndex", DbType.Int32, pageindex);
db.AddInParameter(cmd, "@PageSize", DbType.Int32, pagesize);
if (finetype != -1)
{
db.AddInParameter(cmd, "@FineModuleId", DbType.Int32, finetype);
}
using (IDataReader reader = db.ExecuteReader(cmd))
{
while (reader.Read())
{
VWProductFineEntity entity = new VWProductFineEntity();
entity.Id = StringUtils.GetDbInt(reader["Id"]);
entity.ProductDetailId = StringUtils.GetDbInt(reader["ProductDetailId"]);
entity.Sort = StringUtils.GetDbInt(reader["Sort"]);
entity.BeginTime = StringUtils.GetDbDateTime(reader["BeginTime"]);
entity.EndTime = StringUtils.GetDbDateTime(reader["EndTime"]);
entity.IsActive = StringUtils.GetDbInt(reader["IsActive"]);
entity.FineModuleId = StringUtils.GetDbInt(reader["FineModuleId"]);
entityList.Add(entity);
}
}
cmd = db.GetSqlStringCommand(sql2);
if (finetype != -1)
{
db.AddInParameter(cmd, "@FineModuleId", DbType.Int32, finetype);
}
using (IDataReader reader = db.ExecuteReader(cmd))
{
if (reader.Read())
{
recordCount = StringUtils.GetDbInt(reader[0]);
}
else
{
recordCount = 0;
}
}
return(entityList);
}
public IList <VWProductFineEntity> GetProductFineTopNum(int finetype, int num)
{
string where = " where 1=1 ";
if (finetype != -1)
{
where += " and FineModuleId=@FineModuleId ";
}
string sql = @"SELECT top " + num + @"
[Id],[ProductDetailId],[Sort],[BeginTime],[EndTime],[IsActive],[FineModuleId] from dbo.[ProductFine] WITH(NOLOCK)
" + where + " Order By Sort Desc ";
IList <VWProductFineEntity> entityList = new List <VWProductFineEntity>();
DbCommand cmd = db.GetSqlStringCommand(sql);
if (finetype != -1)
{
db.AddInParameter(cmd, "@FineModuleId", DbType.Int32, finetype);
}
using (IDataReader reader = db.ExecuteReader(cmd))
{
while (reader.Read())
{
VWProductFineEntity entity = new VWProductFineEntity();
entity.Id = StringUtils.GetDbInt(reader["Id"]);
entity.ProductDetailId = StringUtils.GetDbInt(reader["ProductDetailId"]);
entity.Sort = StringUtils.GetDbInt(reader["Sort"]);
entity.BeginTime = StringUtils.GetDbDateTime(reader["BeginTime"]);
entity.EndTime = StringUtils.GetDbDateTime(reader["EndTime"]);
entity.IsActive = StringUtils.GetDbInt(reader["IsActive"]);
entity.FineModuleId = StringUtils.GetDbInt(reader["FineModuleId"]);
entityList.Add(entity);
}
}
return(entityList);
}
