/// <summary>
/// 预约进度表
/// </summary>
/// <param name="page"></param>
/// <param name="dwbh"></param>
/// <param name="pqstart"></param>
/// <param name="pqend"></param>
/// <returns></returns>
public ActionResult YyJdb(int page = 1, string dwbh = "", string pqstart = "", string pqend = "")
{
ReportQyService rs = new ReportQyService();
ViewBag.jsyrs = rs.GetHomejryrs(GLYadmin.YYID, 1); //首页今日预约人数
List <string> jsList = rs.GetHometjzryyjd(GLYadmin.YYID); //今日预约总进度
ViewBag.jsyyzjd = jsList[0];
ViewBag.jsyyzjdsz = jsList[1];
//今日到检总进度
List <string> jsDjList = rs.GetHometjdjzjd(GLYadmin.YYID);
ViewBag.jsDjzjd = jsDjList[0];
ViewBag.jsDjzjdsz = jsDjList[1];
QyyyService qs = new QyyyService();
int count = 0;
List <QyyyModel> list = qs.GetQyygjbxxList(GLYadmin.YYID, dwbh, pqstart, pqend, page, PageSize, ref count);
int recordCount = count; //总记录数
ViewBag.Pager = PagingNewHelper.ShowFPageForBootstrapAdmin(page, PageSize, count); //生成分页条
if (Request.IsAjaxRequest())
{
return(PartialView("YyJdbPart", list));
}
else
{
List <KeyValueModel> liQy = new QyjbxxService().GetqyList(GLYadmin.YYID);
ViewBag.QyList = liQy;
}
return(View(list));
}
// GET: YbpQy
public ActionResult Index()
{
ReportQyService rs = new ReportQyService();
ViewBag.zjqys = rs.GetZjqys(GLYadmin.YYID); //在检企业数
ViewBag.jsyrs = rs.GetHomejryrs(GLYadmin.YYID, 1); //首页今日预约人数
ViewBag.zryrs = rs.GetHomezryrs(GLYadmin.YYID, 1); //首页昨日预约人数
List <string> jsList = rs.GetHometjzryyjd(GLYadmin.YYID); //今日预约总进度
ViewBag.jsyyzjd = jsList[0];
ViewBag.jsyyzjdsz = jsList[1];
ViewBag.yyrhb = rs.GetHomeryyrhb(GLYadmin.YYID, 1);//预约日环比
//今日到检总进度
List <string> jsDjList = rs.GetHometjdjzjd(GLYadmin.YYID);
ViewBag.jsDjzjd = jsDjList[0];
ViewBag.jsDjzjdsz = jsDjList[1];
ViewBag.djrhb = rs.GetHomeTjDjrhb(GLYadmin.YYID);//到检日环比
//top 5到检进度
QyyyService qyy = new QyyyService();
ViewBag.top5 = qyy.GetQyygjbxxHome(GLYadmin.YYID);
ViewBag.day = qyy.GetVipDdDay(GLYadmin.YYID); //vip 当天
ViewBag.week = qyy.GetVipDdDay(GLYadmin.YYID); //vip 当周
return(View());
}
/// <summary>
/// 团检排期报表甘特图
/// </summary>
/// <returns></returns>
public ActionResult TjPqGtt()
{
ReportQyService rs = new ReportQyService();
ViewBag.QyList = rs.GetPqqy(GLYadmin.YYID);
ViewBag.QyTotal = rs.GetPqqyList(GLYadmin.YYID);
ViewBag.QyHj = rs.GetPqqyRsList(GLYadmin.YYID);
return(View());
}
/// <summary>
/// 导出
/// </summary>
/// <param name="start"></param>
/// <param name="end"></param>
/// <returns></returns>
public FileResult JsExportExcel(string dwbh)
{
ReportQyService sr = new ReportQyService();
DataTable dtExport = sr.GetTjJsExport(GLYadmin.YYID, dwbh);
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);
}
}
