public ActionResult DetailEvalsatisfy(int mo, int endStat, string hallno, int pageIndex = 1, int pageSize = 20)
{
//STAT_STAFF_QUEUE_BUSI_D
//STAT_STAFF_QUEUE_BUSI_D
var endMoyear = endStat / 100;
var year = mo / 100;
var beginMo = Convert.ToDateTime(year.ToString() + "-" + (mo - year * 100).ToString() + "-1");
var endMo = Convert.ToDateTime(endMoyear.ToString() + "-" + (endStat - year * 100).ToString() + "-1").AddMonths(1).AddSeconds(-1);
var list = STAT_STAFF_BUSI_TOT_D_DAL.GetListBubByHall(beginMo, endMo, hallno, pageIndex, pageSize);
return(View(list));
}
public ActionResult Index(DateTime?beginTime, DateTime?endTime, string orgid, int pageIndex = 1, int pageSize = 20, bool export = false)
{
CHK_AUTH(); //判断权限
base.DateTimeInit(ref beginTime, ref endTime); //时间初始化
ViewBag.beginTime = beginTime == null ? "" : beginTime.Value.ToString("yyyy-MM-dd");
ViewBag.endTime = endTime == null ? "" : endTime.Value.ToString("yyyy-MM-dd");
ViewBag.NAM = LV.ToString();
var userorg = DalUser.GetUserORG(UserState.UserID);
ViewBag.UserORG = new SelectList(userorg.Where(obj => obj.ORG_LEVEL == 4)
, "ORG_ID", "ORG_NAM", orgid);
if (LV == ENUM_STATLV.省市)
{
ViewBag.NAMLink = "/STAT/StatStaffCall?t=2";//如果是省级，点击进入市级
}
if (LV == ENUM_STATLV.务厅)
{
ViewBag.NAMLink = "/STAT/StatStaffCall?t=3";//如果是省级，点击进入员工报表
}
string subTitle = GetStatTitle(orgid, beginTime, endTime);
ViewBag.subTitle = subTitle;
List <dynamic> data = null;
if (LV == ENUM_STATLV.省市)
{
data = new STAT_STAFF_BUSI_TOT_D_DAL().Q_STATDATA_GROUP_CITY(null, beginTime, endTime);
}
if (LV == ENUM_STATLV.务厅)
{
var halllist = new SYS_HALL_DAL().GetOrgHallAndChild(orgid).ToArray();
data = new STAT_STAFF_BUSI_TOT_D_DAL().Q_STATDATA_GROUP_HALL(halllist, beginTime, endTime);
}
if (LV == ENUM_STATLV.员工)
{
var halllist = new SYS_HALL_DAL().GetOrgHallAndChild(orgid).ToArray();
data = new STAT_STAFF_BUSI_TOT_D_DAL().Q_STATDATA_GROUP_STAFF(halllist, beginTime, endTime);
}
if (export)//导出
{
return(ExportData(StatNAM + "－" + LV.ToString(), subTitle, data));
}
else
{
DataSet ds = new DataSet();
DataTable dt = new DataTable();
ds.Tables.Add(dt);
dt.Columns.Add("NAM", typeof(string));
dt.Columns.Add("呼叫量,P", typeof(string));
dt.Columns.Add("办理量,P", typeof(string));
dt.Columns.Add("弃号量,S", typeof(string));
foreach (var item in data)
{
DataRow r = dt.NewRow();
r["NAM"] = item.NAM;
r["呼叫量,P"] = item.CALL_CNT + ";JavaScript:showCNT(\\\"CALLCNT\\\", \\\"" + Request.QueryString["orgid"] + "\\\")";
r["办理量,P"] = item.HANDLE_CNT + ";JavaScript:showCNT(\\\"HANDLECNT\\\", \\\"" + Request.QueryString["orgid"] + "\\\")";
r["弃号量,S"] = item.ABANDON_CNT + ";JavaScript:showCNT(\\\"ABANDONCNT\\\", \\\"" + Request.QueryString["orgid"] + "\\\")";
dt.Rows.Add(r);
}
subTitle = subTitle.Replace("<span style='font-size:12px;'>", "")
.Replace("</span>", "").Replace(StatNAM, "");
ViewBag.ChartColumn3DXML = CreateMSColumn3DChart(StatNAM, ds.Tables[0], 420, subTitle, true);
ViewBag.ChartSplineXML = CreateMSSplineChart(StatNAM, ds, 420, null, null, subTitle);
var page = new Page <dynamic>()
{
Items = data.Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList(), ItemsPerPage = pageSize, CurrentPage = pageIndex, TotalItems = data.Count
};
return(View("Index", page));
}
}
public ActionResult ShowSingDialog(DateTime?beginTime, DateTime?endTime, string orgid, string serid, int pageIndex = 1, int pageSize = 20)
{
var list = new STAT_STAFF_BUSI_TOT_D_DAL().GetSTATDetails(pageIndex, pageSize, null, beginTime, endTime, serid);
return(View(list));
}
public ActionResult ShowCNT(string ct, DateTime?btime, DateTime?etime, string staffid, string orgid)
{
var dataDT = new STAT_STAFF_BUSI_TOT_D_DAL().GetSTATList_FULLDT(staffid, ref btime, ref etime, orgid);
string caption = "";
if (ct == "CALLCNT")
{
caption = "排队业务报表--呼叫量";
}
if (ct == "HANDLECNT")
{
caption = "排队业务报表--办理量";
}
if (ct == "OVERTIMECNT")
{
caption = "排队业务报表--等候超时量";
}
if (ct == "SECONDCNT")
{
caption = "排队业务报表--二次办税量";
}
if (ct == "WAITPERCENT")
{
caption = "排队业务报表--平均等候时间";
}
if (ct == "LOCALCNT")
{
caption = "排队业务报表--同城受理量";
}
if (ct == "VOTECNT")
{
caption = "排队业务报表--一票多业务量";
}
if (ct == "ABANDONCNT")
{
caption = "排队业务报表--弃号量";
}
if (ct == "CALLCNT")
{
dataDT.Columns[1].SetOrdinal(1);
}
if (ct == "HANDLECNT")
{
dataDT.Columns[2].SetOrdinal(1);
}
if (ct == "OVERTIMECNT")
{
dataDT.Columns[11].SetOrdinal(1);
}
if (ct == "SECONDCNT")
{
dataDT.Columns[12].SetOrdinal(1);
}
if (ct == "WAITPERCENT")
{
dataDT.Columns[13].SetOrdinal(1);
}
if (ct == "LOCALCNT")
{
dataDT.Columns[4].SetOrdinal(1);
}
if (ct == "VOTECNT")
{
dataDT.Columns[5].SetOrdinal(1);
}
if (ct == "ABANDONCNT")
{
dataDT.Columns[3].SetOrdinal(1);
}
while (dataDT.Columns.Count > 2)
{
dataDT.Columns.RemoveAt(2);
}
var orgall = DalUser.GetUserORG(UserState.UserID);
string MainTitle = "";
if (!string.IsNullOrEmpty(orgid))
{
MainTitle += orgall.FirstOrDefault((o => o.ORG_ID == orgid)).ORG_NAM;
}
else
{
MainTitle += orgall.OrderBy(o => o.ORG_LEVEL).FirstOrDefault().ORG_NAM;
}
if (!string.IsNullOrEmpty(staffid))
{
var staff = DaoStaff.GetEntity("STAFF_ID", staffid);
if (null != staff)
{
MainTitle = staff.STAFF_NAM;
}
}
MainTitle += "<span style='font-size:12px;'>（" + btime.Value.ToString("yyyy年MM月dd日");
MainTitle += " - " + etime.Value.ToString("yyyy年MM月dd日") + "）</span>";
ViewBag.MainTitle = MainTitle;
MainTitle = MainTitle.Replace("<span style='font-size:12px;'>", "")
.Replace("</span>", "");
if (ct == "WAITPERCENT")
{
ViewBag.ChartXml = CreateMSColumn3DChart(caption, dataDT, 580, MainTitle, true, true, "秒", "60", "分");
ViewBag.ChartSplineXML = CreateMSSplineChart(caption, dataDT, 550, null, null, MainTitle, true, "秒", "60", "分");
}
else
{
ViewBag.ChartXml = CreateMSColumn3DChart(caption, dataDT, 580, MainTitle, true);
ViewBag.ChartSplineXML = CreateMSSplineChart(caption, dataDT, 550, null, null, MainTitle);
}
return(View());
}
