/// <summary> /// 打印扣费信息 /// </summary> /// <param name="IntFeeID">客户编号</param> /// <returns></returns> public ActionResult PrintTicketDetail(int IntFeeID) { var endcode = Session["EndCode"] ?? "0"; var DtStart = Request["WHC_DtStart"] ?? DateTime.Now.ToString(); var Dtend = Request["WHC_DtEnd"] ?? DateTime.Now.ToString();; var custinfo = new DbServiceReference.Customer(); var dt = new DbServiceReference.ServiceDbClient().Account_GetPaymentDetail(endcode.ToString().ToInt(), IntFeeID, DtStart.ToDateTime(), Dtend.ToDateTime(), custinfo); if (dt.Rows.Count > 0) { ViewBag.IntCustNo = dt.Rows[0]["IntCustNo"].ToString(); ViewBag.NvcName = dt.Rows[0]["NvcName"].ToString(); ViewBag.VcRoomNum = dt.Rows[0]["VcRoomNum"].ToString(); ViewBag.NvcVillage = dt.Rows[0]["NvcVillage"].ToString(); ViewBag.NvcAddr = dt.Rows[0]["NvcAddr"].ToString(); ViewBag.IntYearMon = dt.Rows[0]["IntYearMon"].ToString(); ViewBag.DteFee = dt.Rows[0]["DteFee"].ToString(); var MonFee = dt.Rows[0]["MonFee"].ToString().ToDouble(); ViewBag.MonFee = MonFee.ToString("#0.00"); var MonPenalty = dt.Rows[0]["MonPenalty"].ToString().ToDouble(); ViewBag.MonPenalty = MonPenalty.ToString("#0.00");; ViewBag.IntDays = dt.Rows[0]["IntDays"].ToString(); ViewBag.VcFlowNo = dt.Rows[0]["VcFlowNo"].ToString(); ViewBag.IntPayUnit = dt.Rows[0]["IntPayUnit"].ToString(); ViewBag.VcChargeNo = dt.Rows[0]["VcChargeNo"].ToString(); } return(View()); }
public ActionResult CollectChartJson() { var start = Request["dtStart"].ToDateTime(); var end = Request["dtEnd"].ToDateTime(); var endcode = Session["EndCode"] ?? ""; var customerinfo = new DbServiceReference.Customer(); var dt = new DbServiceReference.ServiceDbClient().CollectData_Qry(endcode.ToString().ToInt(), customerinfo, start, end); var chart = new ChartDataSimple() { categories = new List <string>(), series = new List <ChartDataSimple.SeriesItem>() }; var si = new ChartDataSimple.SeriesItem() { data = new List <decimal?>(), name = "用量" }; for (var now = start; now <= end; now = now.AddDays(1)) { chart.categories.Add(now.ToYyyyMMdd()); var rows = dt.Select("DteFreeze='{0}'".FormatWith(now.ToYyyyMMdd())); if (rows.Count() > 0) { si.data.Add(rows[0]["NumReading"].ToString().ToDecimalOrZero()); } else { si.data.Add(0); } } chart.series.Add(si); return(ToJsonContentDate(chart)); }
public ActionResult CollectStatJsonTotal_Server() { CommonResult result = new CommonResult(); var endcode = Session["EndCode"] ?? ""; var WHC_StartDteFreeze = Request["WHC_StratDteFreeze"].ToDateTime(); var WHC_EndDteFreeze = Request["WHC_EndDteFreeze"].ToDateTime(); var fuji = Request["WHC_Fuji"]; var Text = Request["WHC_Text"]; var Strlevel = Request["WHC_Treelevel"]; var ParentText = Request["WHC_TreePrentText"]; var customerinfo = new DbServiceReference.Customer() { NvcName = Request["WHC_NvcName"] ?? "", VcMobile = Request["WHC_VcMobile"] ?? "", }; var custno = Request["WHC_IntCustNo"] ?? "0"; customerinfo.IntNo = custno == "" ? 0 : custno.ToInt(); if (Strlevel == "1") { customerinfo.NvcVillage = "所有小区"; } ; if (Strlevel == "2") { customerinfo.NvcVillage = Text; } if (Strlevel == "3") { customerinfo.NvcVillage = fuji; customerinfo.VcBuilding = Text; } if (Strlevel == "4") { customerinfo.NvcVillage = ParentText; customerinfo.VcBuilding = fuji; customerinfo.VcUnitNum = Text; } //调用后台服务获取集中器信息 var dts = new DbServiceReference.ServiceDbClient().CollectStatus_Qry(endcode.ToString().ToInt(), customerinfo, WHC_StartDteFreeze, WHC_EndDteFreeze); var m = new CollectStatModel(); foreach (DataRow item in dts.Rows) { m.Used += item["Reading"].ToString().ToDecimalOrZero(); } result.Data1 = dts.Rows.Count.ToString(); result.Data2 = m.Used.ToString(); return(ToJsonContentDate(result)); }
/// <summary> /// 获取未收财务 /// </summary> /// <returns></returns> public ActionResult GetPaymentNoticeList_Server() { var endcode = Session["IntEndCode"] ?? "0"; var CustNo = Request["WHC_IntCustNo"] ?? ""; var NvcName = Request["WHC_NvcName"] ?? ""; var NvcAddr = Request["WHC_NvcAddr"] ?? ""; var VcMobile = Request["WHC_VcMobile"] ?? ""; var custinfo = new DbServiceReference.Customer { IntNo = CustNo == "" ? 0 : CustNo.ToInt(), NvcName = NvcName, NvcAddr = NvcAddr, VcMobile = VcMobile }; var dt = new DbServiceReference.ServiceDbClient().Account_GetPaymentNotice(endcode.ToString().ToInt(), custinfo); var result = new { total = dt.Rows.Count, rows = dt }; return(ToJsonContentDate(result)); }
public ActionResult PaymentNoticeExport() { var endcode = Session["IntEndCode"] ?? "0"; var CustNo = Request["WHC_IntCustNo"]; var NvcName = Request["WHC_NvcName"]; var NvcAddr = Request["WHC_NvcAddr"]; var VcMobile = Request["WHC_VcMobile"]; var custinfo = new DbServiceReference.Customer { IntNo = CustNo == "" ? 0 : CustNo.ToInt(), NvcName = NvcName, NvcAddr = NvcAddr, VcMobile = VcMobile }; var dt = new DbServiceReference.ServiceDbClient().Account_GetPaymentNotice(endcode.ToString().ToInt(), custinfo); if (dt.Rows.Count > 0) { //导出目录创建与清空 var root = Server.MapPath("~\\"); var dir = new System.IO.DirectoryInfo(root + "temp\\"); if (dir.Exists == false) { dir.Create(); } try { foreach (var item in dir.GetFiles()) { item.Delete(); } } catch { } var filename = dir + Guid.NewGuid().ToString() + ".xls"; var ds = new System.Data.DataSet(); ds.Tables.Add(dt); ExcelHelper.DataSetToExcel(ds, filename); return(Redirect(filename.Replace(root, "/").Replace("\\", "/"))); } return(View()); }
public ActionResult CounterReverseData_Server() { var endcode = Session["EndCode"] ?? "0"; var CustNo = Request["WHC_IntCustNo"] ?? ""; var NvcName = Request["WHC_NvcName"] ?? ""; var NvcAddr = Request["WHC_NvcAddr"] ?? ""; var VcMobile = Request["WHC_VcMobile"] ?? DateTime.Now.ToString(); var DtStart = Request["WHC_DtStart"] ?? DateTime.Now.ToString(); var Dtend = Request["WHC_DtEnd"] ?? ""; var custinfo = new DbServiceReference.Customer { IntNo = CustNo == "" ? 0 : CustNo.ToInt(), NvcName = NvcName, NvcAddr = NvcAddr, VcMobile = VcMobile }; var dt = new DbServiceReference.ServiceDbClient().Account_GetPaymentDetail(endcode.ToString().ToInt(), 0, DtStart.ToDateTime(), Dtend.ToDateTime(), custinfo); var result = new { total = dt.Rows.Count, rows = dt }; return(ToJsonContentDate(result)); }
public ActionResult ListJson_Server() { var endcode = Session["EndCode"] ?? ""; var WHC_StartDteFreeze = Request["WHC_StratDteFreeze"].ToDateTime(); var WHC_EndDteFreeze = Request["WHC_EndDteFreeze"].ToDateTime(); var fuji = Request["WHC_Fuji"]; var Text = Request["WHC_Text"]; var Strlevel = Request["WHC_Treelevel"]; var ParentText = Request["WHC_TreePrentText"]; var customerinfo = new DbServiceReference.Customer() { NvcName = Request["WHC_NvcName"] ?? "", VcMobile = Request["WHC_VcMobile"] ?? "", }; var custno = Request["WHC_IntCustNo"] ?? "0"; customerinfo.IntNo = custno == "" ? 0 : custno.ToInt(); if (Strlevel == "1") { customerinfo.NvcVillage = "所有小区"; } ; if (Strlevel == "2") { customerinfo.NvcVillage = Text; } if (Strlevel == "3") { customerinfo.NvcVillage = fuji; customerinfo.VcBuilding = Text; } if (Strlevel == "4") { customerinfo.NvcVillage = ParentText; customerinfo.VcBuilding = fuji; customerinfo.VcUnitNum = Text; } //调用后台服务获取集中器信息 var dts = new DbServiceReference.ServiceDbClient().CollectData_Qry(endcode.ToString().ToInt(), customerinfo, WHC_StartDteFreeze, WHC_EndDteFreeze); int rows = Request["rows"] == null ? 10 : int.Parse(Request["rows"]); int page = Request["page"] == null ? 1 : int.Parse(Request["page"]); DataTable dat = new DataTable(); //复制源的架构和约束 dat = dts.Clone(); // 清除目标的所有数据 dat.Clear(); //对数据进行分页 for (int i = (page - 1) * rows; i < page * rows && i < dts.Rows.Count; i++) { dat.ImportRow(dts.Rows[i]); } //最重要的是在后台取数据放在json中要添加个参数total来存放数据的总行数,如果没有这个参数则不能分页 int total = dts.Rows.Count; var result = new { total = total, rows = dat }; return(ToJsonContentDate(result)); }