public IEnumerable <sys_user> List(userparm parm, out int recordcount)
{
using (LocalDB db = new LocalDB())
{
StringBuilder sql = new StringBuilder();
sql.Append("select * from sys_user where 1=1 ");
DynamicParameters q = new DynamicParameters();
if (!string.IsNullOrEmpty(parm.key))
{
sql.AppendFormat(" and username like @username ");
q.Add("username", "%" + parm.key + "%");
}
if (!string.IsNullOrEmpty(parm.company_id))
{
sql.AppendFormat(" and company_id=@company_id ");
q.Add("company_id", parm.company_id);
}
if (!string.IsNullOrEmpty(parm.user_code))
{
sql.AppendFormat(" and usercode=@usercode ");
q.Add("usercode", parm.user_code);
}
var list = db.Current_Conn.Query <sys_user>(sql.ToString(), q).OrderByDescending(t => t.id).ToPagedList(parm.pageindex, parm.pagesize);
recordcount = list.TotalItemCount;
return(list);
}
}
public IHttpActionResult UserList(userparm parm)
{
int cnt = 0;
try
{
UserService us = new UserService();
var list = us.List(parm, out cnt);
return(Json(new { code = 1, msg = "ok", list = list, recordcount = cnt }));
}
catch (Exception e)
{
return(Json(new { code = 0, msg = e.Message, recordcount = cnt }));
}
}
