/// <summary> /// 查询拼接 /// </summary> /// <typeparam name="T"></typeparam> /// <param name="query"></param> /// <param name="ivm"></param> /// <param name="ovm"></param> public static void QueryJoin <T>(IQueryable <T> query, QueryDataInputVM ivm, ref QueryDataOutputVM ovm) { //总条数 ovm.total = query.Count(); if (ovm.total <= 0) { return; } //排序 if (!string.IsNullOrWhiteSpace(ivm.sort)) { query = QueryableTo.OrderBy(query, ivm.sort, ivm.order); } //分页 if (ivm.pagination == 1) { query = query.Skip((ivm.page - 1) * ivm.rows).Take(ivm.rows); } //数据 var data = query.ToList(); ovm.data = data; }
/// <summary> /// 查询拼接 /// </summary> /// <typeparam name="T"></typeparam> /// <param name="query"></param> /// <param name="ivm"></param> /// <param name="ovm"></param> public static void QueryJoin <T>(IQueryable <T> query, QueryDataInputVM ivm, ref QueryDataOutputVM ovm) { //总条数 ovm.Total = query.Count(); //排序 if (!string.IsNullOrWhiteSpace(ivm.Sort)) { query = QueryableTo.OrderBy(query, ivm.Sort, ivm.Order); } //分页 if (ivm.Pagination == 1) { query = query.Skip((ivm.Page - 1) * ivm.Rows).Take(ivm.Rows); } var sql = query.ToQueryString(); Console.WriteLine(sql); //数据 var data = query.ToList(); ovm.Data = data; }
public string WriteList(string sort, string order, int page = 1, int rows = 30, string pe1 = null) { string result = string.Empty; var pag = new PaginationVM { PageNumber = page, PageSize = rows }; int uid = new UserAuthAid(HttpContext).Get().UserId; using var db = new ContextBase(); var query = from a in db.UserWriting where a.Uid == uid select new { a.UwId, a.UwTitle, a.UwCreateTime, a.UwUpdateTime, a.UwReadNum, a.UwReplyNum, a.UwOpen, a.UwStatus, a.UwLaud, a.UwMark, a.UwCategory }; if (!string.IsNullOrWhiteSpace(pe1)) { query = query.Where(x => x.UwTitle.Contains(pe1)); } query = QueryableTo.OrderBy(query, sort, order); pag.Total = query.Count(); var list = query.Skip((pag.PageNumber - 1) * pag.PageSize).Take(pag.PageSize).ToList(); result = new { data = list, total = pag.Total }.ToJson(); return(result); }
/// <summary> /// 查询拼接 /// </summary> /// <typeparam name="T"></typeparam> /// <param name="query"></param> /// <param name="ivm"></param> /// <param name="db"></param> /// <param name="ovm"></param> public static void QueryJoin <T>(IQueryable <T> query, QueryDataInputVM ivm, ContextBase db, ref QueryDataOutputVM ovm) { //条件 query = QueryWhere(query, ivm); //总条数 ovm.Total = query.Count(); //排序 if (!string.IsNullOrWhiteSpace(ivm.Sort)) { query = QueryableTo.OrderBy(query, ivm.Sort, ivm.Order); } //分页 if (ivm.Pagination == 1) { query = query.Skip((Math.Max(ivm.Page, 1) - 1) * ivm.Rows).Take(ivm.Rows); } //查询SQL ovm.QuerySql = query.ToQueryString(); //数据 var data = query.ToList(); ovm.Data = data; //导出时,存储数据表格 if (ivm.HandleType == "export") { ovm.Table = ToDataTableForString(data); } //列 if (ivm.ColumnsExists != 1) { ovm.Columns = db.SysTableConfig.Where(x => x.TableName == ivm.TableName).OrderBy(x => x.ColOrder).ToList(); } }