/// <summary> /// 得到数据总数 /// </summary> /// <param name="query"></param> /// <returns></returns> public ActionResult Count(BillsQuery query) { Expression <Func <Bills, bool> > expression = p => p.UpdateTime >= query.StartDateTime && p.UpdateTime <= query.EndDateTime; if (query.BillsTypeId > 0) { expression = expression.And(p => p.BillsTypeId == query.BillsTypeId); } return(Content(commonbll.Count <Bills>(expression).ToString())); }
/// <summary> /// 查询 /// </summary> /// <param name="query"></param> /// <returns></returns> public ActionResult FindList(BillsQuery query) { query.Pagination.Page += 1; query.Pagination.Sord = "desc"; query.Pagination.Sidx = "UpdateTime"; var data = billsbll.FindPageList(query, query.Pagination); var result = new { code = 0, msg = "", count = data.Total, data = data.Data }; return(Json(result)); }
public PaginationDTO <IEnumerable <BillsDTO> > FindPageList(BillsQuery query, PaginationQuery pagination) { var where = string.Empty; if (query.StartDateTime.HasValue) { where += "AND (a.UpdateTime BETWEEN @StartDateTime AND @EndDateTime)"; } if (query.BillsTypeId.HasValue) { where += " AND a.BillsTypeId =@BillsTypeId"; } var sql = @" SELECT a.*,a.UpdateTime AS DateTime,b.Name AS BillsTypeName FROM Bills a JOIN BillsType b ON a.BillsTypeId =b.Id WHERE 1=1 {0} ".FormatMe(where); return(db.FindPageList <BillsDTO>(sql, pagination, new { StartDateTime = query.StartDateTime, EndDateTime = query.EndDateTime, BillsTypeId = query.BillsTypeId })); }
/// <summary> /// 当月数据 /// </summary> /// <returns></returns> public IEnumerable <BillsDTO> FindMonth(BillsQuery query) { var where = string.Empty; if (query.StartDateTime.HasValue) { where += "AND (a.UpdateTime BETWEEN @StartDateTime AND @EndDateTime)"; } var sql = @" SELECT a.* , b.Name AS BillsTypeName FROM Bills a JOIN BillsType b ON a.BillsTypeId =b.Id WHERE a.UserId =@UserId {0} ".FormatMe(where); return(db.FindList <BillsDTO>(sql, new { StartDateTime = query.StartDateTime, EndDateTime = query.EndDateTime, UserId = CookieHelper.UserId.ToString() })); }
public IEnumerable <BillsDTO> FindMonth(BillsQuery query) { return(dal.FindMonth(query)); }
/// <summary> /// 分页查询 /// </summary> /// <param name="query"></param> /// <param name="pagination"></param> /// <returns></returns> public PaginationDTO <IEnumerable <BillsDTO> > FindPageList(BillsQuery query, PaginationQuery pagination) { return(dal.FindPageList(query, pagination)); }