/// <summary>
///
/// </summary>
/// <param name="param"></param>
/// <returns></returns>
public IList<saRoleInfo> GetPageList(QueryRoleParams param)
{
string fields = @" * ";
string table = @" saRole A with(nolock) ";
StringBuilder where = new StringBuilder();
where.Append(" 1=1 ");
if (!param.sRoleName.IsNullOrWhiteSpace())
{
where.Append(" and A.sName like '%{0}%'".FormatEx(param.sRoleName.Trim()));
}
string order = "A.iSort Asc ";
int pages = 0;
int records = 0;
DataTable dt = new DbServer().PageQuery(table, fields.ToString(), order.ToString(), where.ToString(), string.Empty, string.Empty, param.PageControl.PageSize, param.PageControl.PageIndex, 0, out pages, out records);
param.PageControl.TotalPageCount = pages;
param.PageControl.TotalRecordCount = records;
IList<saRoleInfo> list = new List<saRoleInfo>();
foreach (DataRow row in dt.Rows)
{
list.Add(DataRowBind(row));
}
return list;
}
/// <summary>
///
/// </summary>
/// <param name="param"></param>
/// <returns></returns>
public DataTable GetPageList(QueryUserParams param)
{
string fields = @" * ";
string table = @" saUser A with(nolock) ";
StringBuilder where = new StringBuilder();
where.Append(" 1=1 ");
if (!param.sUserNo.IsNullOrWhiteSpace())
{
where.Append(" and A.sUserNo like '%{0}%'".FormatEx(param.sUserNo.Trim()));
}
if (!param.sUserName.IsNullOrWhiteSpace())
{
where.Append(" and A.sUserName like '%{0}%'".FormatEx(param.sUserName.Trim()));
}
string order = "A.sUserNo Asc ";
int pages = 0;
int records = 0;
DataTable dt = new DbServer().PageQuery(table, fields.ToString(), order.ToString(), where.ToString(), string.Empty, string.Empty, param.PageControl.PageSize, param.PageControl.PageIndex, 0, out pages, out records);
param.PageControl.TotalPageCount = pages;
param.PageControl.TotalRecordCount = records;
return dt;
}