/// <summary>
/// 营收报表
/// </summary>
/// <param name="start"></param>
/// <param name="end"></param>
/// <returns></returns>
public ActionResult YsList(string start = "", string end = "")
{
Service.ReportQdService sr = new ReportQdService();
if (Request.IsAjaxRequest())
{
List <Model.Dto.ReportQd.YyYsReport> li = sr.ReporYyYsList(start, end, GLYadmin.YYID);
return(PartialView("YsPartList", li));
}
else
{
List <Model.Dto.ReportQd.YyYsReport> li = sr.ReporYyYsList(DateTime.Now.AddDays(-30).ToString("yyyy-MM-dd"), DateTime.Now.ToString("yyyy-MM-dd"), GLYadmin.YYID);
ViewBag.Yye30 = sr.Get30Yye(GLYadmin.YYID);
ViewBag.Yye = sr.GetdrYye(GLYadmin.YYID);
ViewBag.Yyedy = sr.GetdyYye(GLYadmin.YYID);
List <QuDaoJbxx> liQd = new QuDaoJbxxService().GetYyQudao(GLYadmin.YYID, "");
List <KeyValueModel> liQdReturn = new List <KeyValueModel>();
foreach (QuDaoJbxx model in liQd)
{
liQdReturn.Add(new KeyValueModel()
{
key = model.Bh.ToString(), values = model.Mc
});
}
ViewBag.QdList = liQdReturn;
return(View(li));
}
}
public JsonResult Ys(int qdId = 0)
{
Service.ReportQdService sr = new ReportQdService();
string Yye30 = sr.Get30Yye(GLYadmin.YYID, qdId);
string Yye = sr.GetdrYye(GLYadmin.YYID, qdId);
string Yyedy = sr.GetdyYye(GLYadmin.YYID, qdId);
return(Json(new { flag = true, Yye30 = Yye30, Yye = Yye, Yyedy = Yyedy }, JsonRequestBehavior.AllowGet));
}
public ActionResult Ybp()
{
ReportQdService rs = new ReportQdService();
ViewBag.zryye = rs.GetzrYye(GLYadmin.YYID); //昨日营业额
ViewBag.dryye = rs.GetdrYye(GLYadmin.YYID); //当日营业额
ViewBag.rhb = rs.GetHomerhb(GLYadmin.YYID); //日环比
ViewBag.jsyrs = rs.GetHomejryrs(GLYadmin.YYID); //首页今日预约人数
ViewBag.zryrs = rs.GetHomezryrs(GLYadmin.YYID); //首页昨日预约人数
ViewBag.yyjd = rs.GetHomezryyjd(GLYadmin.YYID); //今日预约总进度
ViewBag.yyrhb = rs.GetHomeryyrhb(GLYadmin.YYID); //预约日环比
return(View());
}
/// <summary>
/// 导出
/// </summary>
/// <param name="start"></param>
/// <param name="end"></param>
/// <returns></returns>
public FileResult ExportExcel(int qdid, string start = "", string end = "")
{
Service.ReportQdService sr = new ReportQdService();
DataTable dtExport = sr.GetYsExport(start, end, GLYadmin.YYID, qdid);
if (dtExport.Rows.Count > 0)
{
dtExport.TableName = "报表数据";
MemoryStream ms = Common.ExcelTool.RenderToExcel(dtExport);
ms.Seek(0, SeekOrigin.Begin);
return(File(ms, "application/vnd.ms-excel", "订单名细.xls"));
}
else
{
return(null);
}
}
