/// <summary>
/// 获取本月费用明细报表
/// </summary>
public Tuple <List <decimal>, List <decimal> > GetMonthReport(CostReportRequest request)
{
var dayS = DateTime.Now.AddDays(1 - DateTime.Now.Day).Date;
var dayE = DateTime.Now.AddDays(1 - DateTime.Now.Day).Date.AddMonths(1).AddSeconds(-1);
string ProjectId = "";
if (!string.IsNullOrEmpty(request.ProjectId))
{
ProjectId = request.ProjectId;
}
SqlParameter[] par = new SqlParameter[]
{
new SqlParameter("@DateS", dayS),
new SqlParameter("@DateE", dayE),
new SqlParameter("@ProjectId", ProjectId),
};
try
{
var list = Db.Context.FromProc("CostMonthReport_Proc").AddParameter(par).ToList <decimal>();
return(GetData(list));
}
catch (Exception)
{
return(new Tuple <List <decimal>, List <decimal> >(null, null));
}
}
/// <summary>
/// 获取订单费用明细报表
/// </summary>
public Tuple <List <decimal>, List <decimal> > GetOrderReport(CostReportRequest request)
{
string ProjectId = "";
string SiteCode = "";
if (!string.IsNullOrEmpty(request.ProjectId))
{
ProjectId = request.ProjectId;
}
if (!string.IsNullOrEmpty(request.SiteCode))
{
SiteCode = request.SiteCode;
}
SqlParameter[] par = new SqlParameter[]
{
new SqlParameter("@OrderCode", request.OrderCode),
new SqlParameter("@SiteCode", SiteCode),
new SqlParameter("@ProjectId", ProjectId),
};
try
{
var list = Db.Context.FromProc("CostOrderReport_Proc").AddParameter(par).ToList <decimal>();
return(GetData(list));
}
catch (Exception)
{
return(new Tuple <List <decimal>, List <decimal> >(null, null));
}
}
/// <summary>
/// 获取分页列表数据(订单)
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public PageModel GetDataListForPage(CostReportRequest request)
{
#region 模糊搜索条件
var where = new Where <TbWorkOrder>();
if (!string.IsNullOrWhiteSpace(request.SiteCode))
{
List <string> SiteList = _workOrderLogic.GetCompanyWorkAreaOrSiteList(request.SiteCode, 5);
where.And(p => p.SiteCode.In(SiteList));
}
if (!string.IsNullOrEmpty(request.ProjectId))
{
where.And(p => p.ProjectId == request.ProjectId);
}
#endregion
try
{
var data = Db.Context.From <TbWorkOrder>()
.Select(
TbWorkOrder._.OrderCode
, TbWorkOrder._.SiteCode
, TbWorkOrder._.TypeCode
, TbWorkOrder._.TypeName
, TbCompany._.CompanyFullName)
.LeftJoin <TbCompany>((a, c) => a.SiteCode == c.CompanyCode)
.Where(where)
.OrderByDescending(p => p.ID)
.ToPageList(request.rows, request.page);
return(data);
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// 获取本月费用明细报表
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public ActionResult GetMonthReport(CostReportRequest request)
{
var data = _costReport.GetMonthReport(request);
return(Content(data.ToJson()));
}
/// <summary>
/// 获取分页列表数据(订单)
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public ActionResult GetOrderGridJson(CostReportRequest request)
{
var data = _costReport.GetDataListForPage(request);
return(Content(data.ToJson()));
}