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