/// <summary>
/// (分页查询)从数据库中获取用户列表
/// </summary>
/// <param name="queryModel">查询条件</param>
/// <returns>返回用户列表</returns>
public DataTable GetUsersList(Entity.System.view.QueryModelUser queryModel)
{
try
{
var userName = queryModel.userName ?? "";
var pageNumber = queryModel.offset / queryModel.limit + 1;
var pageSize = queryModel.limit;
var strSql = new StringBuilder();
strSql.Append("select t.*,COUNT(*) OVER () RESULT_COUNT from userinfo t where t.f_name like '%'||:userName||'%'");
OracleParameter[] parameters =
{
new OracleParameter(":userName", userName)
};
var dbapi = new DbAPI();
dbapi.OpenConn("");
var rst = dbapi.GetDataTable(DbAPI.GeneratePagingSql(strSql.ToString(), pageNumber, pageSize), parameters);
dbapi.CloseConn();
return(rst);
}
catch (Exception ex)
{
LogBN.WriteLog(typeof(USERINFO_BN), "(分页查询)从数据库中获取用户列表GetUsersList 程序段的异常" + ex);
return(null);
}
}
public Entity.MonitorLog.BootstrapTableDataModel GetUserList([FromUri] Entity.System.view.QueryModelUser queryModel)
{
var bn = new USERINFO_BN();
var rows = bn.GetUsersList(queryModel);
var rst = new Entity.MonitorLog.BootstrapTableDataModel
{
rows = rows,
total = rows.Rows.Count > 0 ? Convert.ToInt32(rows.Rows[0]["RESULT_COUNT"]) : 0
};
return(rst);
}
/// <summary>
/// 导出用户列表到Excel
/// </summary>
/// <param name="queryModel">查询参数</param>
public DataTable GetExcelListUsers(Entity.System.view.QueryModelUser queryModel)
{
try
{
var userName = string.IsNullOrWhiteSpace(queryModel.userName) ? "" : queryModel.userName;
var strSql = "SELECT f_name \"用户名\", f_realname \"真实姓名\", f_email \"邮箱\", f_phone \"固话\", f_tel \"手机\", f_description \"说明\", f_address \"住址\" FROM userinfo where f_name like '%' || :userName || '%'";
OracleParameter[] parameters =
{
new OracleParameter(":userName", userName)
};
var dbapi = new DbAPI();
dbapi.OpenConn("");
var rst = dbapi.GetDataTable(strSql, parameters);
dbapi.CloseConn();
return(rst);
}
catch (Exception ex)
{
LogBN.WriteLog(typeof(MonitorLog), "导出用户列表到Excel方法GetExcelList 程序段的异常" + ex);
return(null);
}
}