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