/// <summary> /// 分页获取黑名单组信息 /// </summary> /// <param name="pageInfo"></param> /// <param name="tableName"></param> /// <param name="columns"></param> /// <param name="condition"></param> /// <param name="key"></param> /// <returns></returns> public static IList <BlackGroupModel> GetBlackGroups(Model.Other.PaginationModel pageInfo, string tableName, string columns, string condition, string key) { SqlParameter[] ps = new SqlParameter[] { new SqlParameter("@tableName", tableName), new SqlParameter("@key", key), new SqlParameter("@comlums", columns), new SqlParameter("@condition", condition), new SqlParameter("@start", pageInfo.GetPageDate()), new SqlParameter("@end", pageInfo.GetEndDate()), new SqlParameter("@DataCount", pageInfo.DataCount) }; ps[6].Direction = ParameterDirection.Output; ps[6].Size = 10; SqlDataReader reader = DBHelper.ExecuteReader("GetDataPagePagination", ps, CommandType.StoredProcedure); IList <BlackGroupModel> blacks = null; if (reader.HasRows) { blacks = new List <BlackGroupModel>(); while (reader.Read()) { BlackGroupModel black = new BlackGroupModel(reader.GetInt32(0)); black.IntGroupType = reader.GetInt32(1); black.IntGroupValue = reader.GetString(2); blacks.Add(black); } reader.NextResult(); pageInfo.DataCount = Convert.ToInt32(ps[6].Value.ToString()); } reader.Close(); return(blacks); }
/// <summary> /// 分页获取黑名单设置 /// </summary> /// <param name="pageInfo">分页帮助类</param> /// <param name="condition">分页条件</param> /// <param name="tableName">表名</param> /// <param name="columns">列名</param> /// <param name="key">分页键</param> /// <returns></returns> public static IList <BlacklistModel> GetBlackList(Model.Other.PaginationModel pageInfo, string condition, string tableName, string columns, string key) { SqlParameter[] ps = new SqlParameter[] { new SqlParameter("@tableName", tableName), new SqlParameter("@key", key), new SqlParameter("@comlums", columns), new SqlParameter("@condition", condition), new SqlParameter("@start", pageInfo.GetPageDate()), new SqlParameter("@end", pageInfo.GetEndDate()), new SqlParameter("@DataCount", pageInfo.DataCount) }; ps[6].Direction = ParameterDirection.Output; ps[6].Size = 10; SqlDataReader dr = DBHelper.ExecuteReader("GetDataPagePagination", ps, CommandType.StoredProcedure); IList <BlacklistModel> blacks = null; //DataTable blacks = SqlDataReaderHelp.GetDataTable(pageInfo, tableName, key, columns, condition); if (dr.HasRows) { blacks = new List <BlacklistModel>(); while (dr.Read()) { BlacklistModel black = new BlacklistModel(dr.GetInt32(0)); black.UserID = dr.GetString(1); black.State = dr.GetByte(2); black.UserType = dr.GetByte(3); black.UserIP = dr.GetString(4); black.GroupID = dr.GetInt32(5); black.BlackDate = dr.GetDateTime(6); black.OperateIP = dr.GetString(7); black.OperateBH = dr.GetString(8); blacks.Add(black); } dr.NextResult(); pageInfo.DataCount = Convert.ToInt32(ps[6].Value.ToString()); } dr.Close(); return(blacks); }
/// <summary> /// 根据条件分页获取黑名单组信息 /// </summary> /// <param name="pageInfo">分页帮助类</param> /// <param name="tableName">表名</param> /// <param name="columns">列名</param> /// <param name="condition">过滤条件</param> /// <param name="key">分页条件列</param> /// <returns>DataTable 数据</returns> public static DataTable GetBlackGroups2(Model.Other.PaginationModel pageInfo, string tableName, string columns, string condition, string key) { DataTable dt = SqlDataReaderHelp.GetDataTable(pageInfo, tableName, key, columns, condition); return(dt); }
public static DataTable GetBlackListDataTable(Model.Other.PaginationModel pageInfo, string condition, string tableName, string columns, string key) { return(SqlDataReaderHelp.GetDataTable(pageInfo, tableName, key, columns, condition)); }