/// <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); }