public IEnumerable <sys_menu> List(menuparm parm, out int recordcount) { using (LocalDB db = new LocalDB()) { StringBuilder sql = new StringBuilder(); DynamicParameters p = new DynamicParameters(); sql.Append("SELECT * FROM dbo.sys_menu WHERE 1=1 \n"); if (!string.IsNullOrEmpty(parm.pid)) { sql.AppendFormat(" and pid = @pid "); p.Add("pid", parm.pid); } if (!string.IsNullOrEmpty(parm.key)) { sql.AppendFormat(" and title like @title "); p.Add("title", "%" + parm.key + "%"); } if (parm.menutype > 0) { sql.Append(" and menutype=@menutype \n"); p.Add("menutype", parm.menutype); } if (!string.IsNullOrEmpty(parm.url)) { sql.Append(" and path=@url \n"); p.Add("url", parm.url); } var list = db.Current_Conn.Query <sys_menu>(sql.ToString(), p).OrderByDescending(t => t.id).ToPagedList(parm.pageindex, parm.pagesize); recordcount = list.TotalItemCount; return(list); } }
public IHttpActionResult MenuList(menuparm parm) { try { int recordcount = 0; MenuService ms = new MenuService(); var list = ms.List(parm, out recordcount); return(Json(new { code = 1, msg = "ok", list = list, recordcount = recordcount })); } catch (Exception e) { return(Json(new { code = 0, msg = e.Message })); } }