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