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