/// <summary>
/// 用户查询
/// </summary>
/// <param name="comParas"></param>
/// <returns></returns>
public static Dm_ResultList Query(Dm_Paging comParas)
{
try
{
try
{
using (IDbConnection conn = new MySqlConnection(DapperHelper.CONNECTIONSTRING))
{
int recordCount = 0;
List <User_Info_Entity> lst = User_InfoDAO.GetList(conn, comParas, out recordCount);
if (lst == null)
{
lst = new List <User_Info_Entity>();
}
return(new Dm_ResultList()
{
Result = 1, ResultList = lst, TotalRecords = recordCount, ResultDesc = "用户列表查询成功"
});
}
}
catch (Exception ex)
{
throw ex;
}
}
catch (Exception e)
{
throw e;
}
}
public object ALL(Dm_Paging value)
{
try
{
Dm_ResultList result = User_InfoBLO.Query(value);
return(result);
}
catch (Exception e)
{
throw e;
}
}
/// <summary>
/// 用户查询
/// </summary>
/// <param name="conn"></param>
/// <param name="comparam"></param>
/// <param name="recordCount"></param>
/// <returns></returns>
public static List <User_Info_Entity> GetList(IDbConnection conn, Dm_Paging comparam, out int recordCount)
{
var dynamicParams = new DynamicParameters();
string strWhere = " where user_state=1 ";
string strOrderBy = " order by crt_date ";
foreach (var item in comparam.ilist)
{
if (item.Title?.Trim().ToLower() == "user_mobile" && !string.IsNullOrWhiteSpace(item.Content))
{
strWhere += " and user_mobile = @user_mobile";
dynamicParams.Add("user_mobile", item.Content);
}
if (item.Title?.Trim().ToLower() == "user_name" && !string.IsNullOrWhiteSpace(item.Content))
{
strWhere += " and user_name like @user_name";
dynamicParams.Add("user_name", "%" + item.Content + "%");
}
if (item.Title?.Trim().ToLower() == "user_nickname" && !string.IsNullOrWhiteSpace(item.Content))
{
strWhere += " and user_nickname = @user_nickname";
dynamicParams.Add("user_nickname", item.Content);
}
if (item.Title?.Trim().ToLower() == "login_ip" && !string.IsNullOrWhiteSpace(item.Content))
{
strWhere += " and login_ip = @login_ip";
dynamicParams.Add("login_ip", item.Content);
}
if (item.Title?.Trim().ToLower() == "login_firsttime" && !string.IsNullOrWhiteSpace(item.Content))
{
strWhere += " and login_firsttime = @login_firsttime";
dynamicParams.Add("login_firsttime", item.Content);
}
if (item.Title?.Trim().ToLower() == "login_lasttime" && !string.IsNullOrWhiteSpace(item.Content))
{
strWhere += " and login_lasttime = @login_lasttime";
dynamicParams.Add("login_lasttime", item.Content);
}
}
recordCount = conn.RecordCount <User_Info_Entity>();
if (comparam.PageSize > 0 && comparam.PageIndex > 0)
{
strOrderBy += $" limit {(comparam.PageIndex - 1) * comparam.PageSize}, {comparam.PageSize}";
}
var rst = conn.GetList <User_Info_Entity>(strWhere + strOrderBy, dynamicParams).ToList();
return(rst);
}
