Ejemplo n.º 1
0
        public ActionResult GetList()
        {
            int    pageindex = int.Parse(Request["PageIndex"]);
            int    pagesize  = int.Parse(Request["PageSize"]);
            string sqlcount  = "select id from builds ";
            // = _baseExtensionB.GetModelsByValue(sqlstr, param);
            //多产品操作信息
            QueryM queryM = new QueryM()
            {
                PageNum  = pageindex,
                PageSize = pagesize,
                Where    = "",
                Params   = null
            };
            List <Model.Content.Builds> builds = BD.GetListAsync(queryM);
            var totalCount = BD.GetModelsByValue(sqlcount, null);

            return(Json(new { list = builds, RowCount = totalCount.Count(), PageIndex = pageindex, PageCount = (int)Math.Ceiling(totalCount.Count() * 1.0 / 10) }, JsonRequestBehavior.DenyGet));
        }
Ejemplo n.º 2
0
        public List <T> GetListAsync(QueryM q)
        {
            try
            {
                var orderBy = q.OrderBy ?? _entityM.Identity + " DESC";
                var where = string.IsNullOrEmpty(q.Where) ? "" : " " + q.Where;
                var str = $@"SELECT * FROM 
                            (
	                            SELECT ROW_NUMBER() OVER(ORDER BY {orderBy}) AS rank, {string.Join(",", _entityM.Fields.Keys)}
                                
                                FROM {_entityM.TableFullName} {where}
                            )a
                            WHERE a.rank BETWEEN {(q.PageNum - 1) * q.PageSize+1} AND {q.PageSize*q.PageNum}";
                return(_conn.Query <T>(str, q.Params) as List <T>);
            }
            catch (Exception)
            {
                return(null);
            }
        }
Ejemplo n.º 3
0
 public List <T> GetListAsync(QueryM q)
 {
     return(_dao.GetListAsync(q));
 }