コード例 #1
0
ファイル: OrganizeService.cs プロジェクト: devide023/gkapi
        public IEnumerable <sys_organize> List(organizeparm parm, out int recordcount)
        {
            DynamicParameters p   = new DynamicParameters();
            StringBuilder     sql = new StringBuilder();

            sql.Append("SELECT * FROM dbo.sys_organize WHERE 1=1");
            if (!string.IsNullOrEmpty(parm.code))
            {
                sql.Append(" and code like @code ");
                p.Add("code", '%' + parm.code + '%');
            }
            if (!string.IsNullOrEmpty(parm.key))
            {
                sql.Append(" and title like @key ");
                p.Add("key", '%' + parm.key + '%');
            }
            if (!string.IsNullOrEmpty(parm.pid))
            {
                sql.Append(" and pid = @pid ");
                p.Add("pid", parm.pid);
            }
            using (LocalDB db = new LocalDB())
            {
                var list = db.Current_Conn.Query <sys_organize>(sql.ToString(), p).OrderByDescending(t => t.id).ToPagedList(parm.pageindex, parm.pagesize);
                recordcount = list.TotalItemCount;
                return(list);
            }
        }
コード例 #2
0
 public IHttpActionResult List(organizeparm parm)
 {
     try
     {
         int             recordcount = 0;
         OrganizeService os          = new OrganizeService();
         var             list        = os.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 }));
     }
 }