public JsonResult QueryRemotelyOpenGateData() { try { List <string> parkingIds = new List <string>(); if (!string.IsNullOrWhiteSpace(Request.Params["parkingId"])) { parkingIds.Add(Request.Params["parkingId"]); } else { List <BaseParkinfo> parkings = ParkingServices.QueryParkingByVillageIds(GetLoginUserVillages.Select(p => p.VID).ToList()); if (parkings.Count > 0) { parkingIds.AddRange(parkings.Select(p => p.PKID)); } } string areaId = Request.Params["areaId"]; string boxId = Request.Params["boxId"]; int page = string.IsNullOrEmpty(Request.Params["page"]) ? 0 : int.Parse(Request.Params["page"]); int rows = 15; int recordTotalCount = 0; List <RemotelyOpenGateView> models = ParkGateServices.QueryRemotelyOpenGate(parkingIds, areaId, boxId, page, rows, out recordTotalCount); return(Json(MyResult.Success("", models))); } catch (Exception ex) { ExceptionsServices.AddExceptions(ex, "微信获取远程开闸数据失败"); return(Json(MyResult.Error("获取失败"))); } }
public ActionResult Index() { List <BaseParkinfo> parings = ParkingServices.QueryParkingByVillageIds(GetLoginUserVillages.Select(p => p.VID).ToList()); ViewBag.StartTime = DateTime.Now.AddDays(-7).Date.AddSeconds(1).ToString("yyyy-MM-dd HH:mm:ss").Replace(" ", "T"); ViewBag.EndTime = DateTime.Now.Date.AddDays(1).AddSeconds(-1).ToString("yyyy-MM-dd HH:mm:ss").Replace(" ", "T"); return(View(parings)); }
/// <summary> /// 获得所有车场 /// </summary> /// <returns></returns> public JsonResult GetParks() { JsonResult json = new JsonResult(); try { json.Data = ParkingServices.QueryParkingByVillageIds(base.GetLoginUserVillages.Select(u => u.VID).ToList()); } catch (Exception ex) { } return(json); }
public string GetPrakAreaTreeData() { try { StringBuilder strAreaTree = new StringBuilder(); List <BaseParkinfo> parkings = ParkingServices.QueryParkingByVillageIds(GetLoginUserVillages.Select(p => p.VID).ToList()); if (parkings.Count == 0) { return(string.Empty); } List <ParkArea> parkAreas = ParkAreaServices.GetParkAreaByParkingIds(parkings.Select(p => p.PKID).ToList()); strAreaTree.Append("["); int index = 1; foreach (var item in GetLoginUserVillages) { BaseCompany company = GetLoginUserRoleCompany.FirstOrDefault(p => p.CPID == item.CPID); if (company == null) { continue; } string text = string.Format("{0}【{1}】", item.VName, company.CPName); strAreaTree.Append("{\"id\":\"" + item.VID + "\","); strAreaTree.Append("\"iconCls\":\"my-village-icon\","); strAreaTree.Append("\"attributes\":{\"type\":0},"); strAreaTree.Append("\"text\":\"" + text + "\""); GetParkingTreeData(parkings, parkAreas, item.VID, strAreaTree); strAreaTree.Append("}"); if (index != GetLoginUserVillages.Count) { strAreaTree.Append(","); } index++; } strAreaTree.Append("]"); return(strAreaTree.ToString()); } catch (Exception ex) { ExceptionsServices.AddExceptions(ex, "构建车场区域树失败"); return(string.Empty); } }
public string GetParkingTreeData() { try { StringBuilder strParkingTree = new StringBuilder(); if (GetLoginUserVillages.Count == 0) { return(strParkingTree.ToString()); } List <BaseParkinfo> parkings = ParkingServices.QueryParkingByVillageIds(GetLoginUserVillages.Select(p => p.VID).ToList()); strParkingTree.Append("["); int index = 1; foreach (var obj in GetLoginUserRoleCompany) { //List<BaseVillage> childVillages = GetLoginUserVillages.Where(p => p.CPID == obj.CPID).ToList(); //if (childVillages.Count == 0) continue; //List<BaseParkinfo> childParkings = parkings.Where(p => childVillages.Select(o => o.VID).Contains(p.VID)).ToList(); //if (childParkings.Count == 0) continue; //if (index != 1) //{ // strParkingTree.Append(","); //} if (index != 1) { strParkingTree.Append(","); } strParkingTree.Append("{\"id\":\"" + obj.CPID + "\","); strParkingTree.Append("\"iconCls\":\"my-company-icon\","); strParkingTree.Append("\"attributes\":{\"type\":0},"); strParkingTree.Append("\"text\":\"" + obj.CPName + "\""); GetVillageTreeData(obj.CPID, parkings, strParkingTree); strParkingTree.Append("}"); index++; } strParkingTree.Append("]"); return(strParkingTree.ToString()); } catch (Exception ex) { ExceptionsServices.AddExceptions(ex, "构建车场树异常"); return(string.Empty); } }
/// <summary> /// 访客信息 /// </summary> /// <param name="parkingid"></param> /// <param name="cardtype"></param> /// <param name="platenumber"></param> /// <param name="addr"></param> /// <param name="mobile"></param> /// <param name="pageindex"></param> /// <param name="pagesize"></param> public void Params_ParkVisitorInfo() { int page = string.IsNullOrEmpty(Request.Params["page"]) ? 0 : int.Parse(Request.Params["page"]); int rows = string.IsNullOrEmpty(Request.Params["rows"]) ? 0 : int.Parse(Request.Params["rows"]); VisitorReportCondition paras = new VisitorReportCondition(); if (string.IsNullOrWhiteSpace(Request.Params["ParkingId"]) || Request.Params["ParkingId"].ToString() == "-1") { List <BaseParkinfo> parkings = ParkingServices.QueryParkingByVillageIds(base.GetLoginUserVillages.Select(u => u.VID).ToList()); if (parkings.Count > 0) { paras.ParkingIds = parkings.Select(p => p.PKID).ToList(); } } else { paras.ParkingIds = new List <string>() { Request.Params["ParkingId"].ToString() }; } paras.PlateNumber = Request.Params["PlateNumber"].ToString(); paras.MoblieOrName = Request.Params["MoblieOrName"].ToString(); paras.BeginTime = DateTime.Parse(Request.Params["BeginTime"].ToString()); paras.EndTime = DateTime.Parse(Request.Params["EndTime"].ToString()); if (!string.IsNullOrWhiteSpace(Request.Params["VisitorSource"]) && Request.Params["VisitorSource"].ToString() != "-1") { paras.VisitorSource = int.Parse(Request.Params["VisitorSource"].ToString()); } if (!string.IsNullOrWhiteSpace(Request.Params["VisitorState"]) && Request.Params["VisitorState"].ToString() != "-1") { paras.VisitorState = int.Parse(Request.Params["VisitorState"].ToString()); } System.Web.HttpContext.Current.Session["VisitorReportCondition"] = paras; System.Web.HttpContext.Current.Session["QueryParams"] = new InParams { PageIndex = page, PageSize = rows, ReportType = ReportType.ParkVisitorInfo }; }
public string GetOnlyParkingTreeData() { try { StringBuilder strParkingTree = new StringBuilder(); if (GetLoginUserVillages.Count == 0) { return(strParkingTree.ToString()); } List <BaseParkinfo> parkings = ParkingServices.QueryParkingByVillageIds(GetLoginUserVillages.Select(p => p.VID).ToList()); strParkingTree.Append("["); int index = 1; foreach (var item in parkings) { strParkingTree.Append("{"); strParkingTree.AppendFormat("\"id\":\"{0}\"", item.PKID); strParkingTree.Append(",\"iconCls\":\"my-parking-icon\""); strParkingTree.AppendFormat(",\"text\":\"{0}\"", item.PKName); strParkingTree.Append(",\"attributes\":{\"type\":1}"); strParkingTree.Append("}"); if (index != parkings.Count()) { strParkingTree.Append(","); } index++; } strParkingTree.Append("]"); return(strParkingTree.ToString()); } catch (Exception ex) { ExceptionsServices.AddExceptions(ex, "构建车场树异常"); return(string.Empty); } }
/// <summary> /// 获得首页数据 /// </summary> /// <returns></returns> public static HomeResult GetHomeData(List <string> villages) { HomeResult homeresult = new HomeResult(); try { IStatistics factory = StatisticsFactory.GetFactory(); DateTime dtNow = DateTime.Now; DateTime StartTime = dtNow.Date.AddDays(-14); DateTime EndTime = dtNow; List <BaseParkinfo> parkinfos = ParkingServices.QueryParkingByVillageIds(villages); List <Statistics_Gather> gatherlistdaily15 = null; if (parkinfos != null && parkinfos.Count > 0) { gatherlistdaily15 = factory.GetStatisticsGroupByDay(parkinfos.Select(u => u.PKID).ToList(), StartTime, EndTime); } //如果少于15天,则补足15天 if (gatherlistdaily15 != null) { if (gatherlistdaily15.Count <= 15) { for (int i = 0; i < 15; i++) { var v = gatherlistdaily15.Find(u => u.KeyName == dtNow.AddDays(-i).ToString("yyyy-MM-dd")); if (v == null) { gatherlistdaily15.Add(new Statistics_Gather { KeyName = dtNow.AddDays(-i).ToString("MM-dd"), GatherTime = dtNow.AddDays(-i) }); } else { v.KeyName = dtNow.AddDays(-i).ToString("MM-dd"); } } } } else { for (int i = 0; i < 15; i++) { gatherlistdaily15.Add(new Statistics_Gather { KeyName = dtNow.AddDays(-i).ToString("MM-dd"), GatherTime = dtNow.AddDays(-i) }); } } gatherlistdaily15 = gatherlistdaily15.OrderBy(u => u.KeyName).ToList(); homeresult.GatherDaily30 = gatherlistdaily15; int vipcard = gatherlistdaily15.Select(u => u.VIPCard).Sum(); int stordcard = gatherlistdaily15.Select(u => u.StordCard).Sum(); int monthcard = gatherlistdaily15.Select(u => u.MonthCard).Sum(); int jobcard = gatherlistdaily15.Select(u => u.JobCard).Sum(); int tempcard = gatherlistdaily15.Select(u => u.TempCard).Sum(); int sumnormal = gatherlistdaily15.Select(u => u.ReleaseType_Normal).Sum(); int sumcatch = gatherlistdaily15.Select(u => u.ReleaseType_Catch).Sum(); int sumfree = gatherlistdaily15.Select(u => u.ReleaseType_Free).Sum(); int sumcharge = gatherlistdaily15.Select(u => u.ReleaseType_Charge).Sum(); //进场类型 homeresult.EntranceCardType.Add(new KeyValue { KeyName = "贵宾卡", Key_Value = vipcard, KeyValue2 = vipcard }); homeresult.EntranceCardType.Add(new KeyValue { KeyName = "储值卡", Key_Value = stordcard, KeyValue2 = stordcard }); homeresult.EntranceCardType.Add(new KeyValue { KeyName = "月卡", Key_Value = monthcard, KeyValue2 = monthcard }); homeresult.EntranceCardType.Add(new KeyValue { KeyName = "临时卡", Key_Value = tempcard, KeyValue2 = tempcard }); homeresult.EntranceCardType.Add(new KeyValue { KeyName = "工作卡", Key_Value = jobcard, KeyValue2 = jobcard }); //放行类型 homeresult.ReleaseType.Add(new KeyValue { KeyName = "正常放行", Key_Value = sumnormal, KeyValue2 = sumnormal }); homeresult.ReleaseType.Add(new KeyValue { KeyName = "免费放行", Key_Value = sumfree, KeyValue2 = sumfree }); homeresult.ReleaseType.Add(new KeyValue { KeyName = "收费放行", Key_Value = sumcharge, KeyValue2 = sumcharge }); homeresult.ReleaseType.Add(new KeyValue { KeyName = "异常放行", Key_Value = sumcatch, KeyValue2 = sumcatch }); List <Statistics_Gather> gathertop5 = null; if (parkinfos != null && parkinfos.Count > 0) { gathertop5 = factory.GetParkingTempTop5(parkinfos.Select(u => u.PKID).ToList(), StartTime, EndTime); } List <KeyValue> parkingtop5 = new List <KeyValue> (); if (gathertop5 != null) { foreach (var v in gathertop5) { parkingtop5.Add(new KeyValue { Key_Value = v.TempCard, KeyName = v.ParkingName }); } int num = gathertop5.Count; if (num < 5) { for (int i = 0; i < 5 - num; i++) { parkingtop5.Add(new KeyValue { KeyName = "", Key_Value = 0 }); } } } else { if (gathertop5.Count < 5) { int n = gathertop5.Count; for (int i = 0; i < 5 - n; i++) { parkingtop5.Add(new KeyValue { KeyName = "", Key_Value = 0 }); } } } homeresult.ParkTempTop5 = parkingtop5.OrderBy(u => u.Key_Value).ToList(); StartTime = DateTime.Parse(dtNow.ToString("yyyy-MM-01")).AddMonths(-5); List <Statistics_Gather> gatherlistmonth12 = null; if (parkinfos != null && parkinfos.Count > 0) { gatherlistmonth12 = factory.GetStatisticsGroupByMonth(parkinfos.Select(u => u.PKID).ToList(), StartTime, EndTime); } if (gatherlistmonth12 != null) { if (gatherlistmonth12.Count < 6) { for (int i = 0; i < 6; i++) { var v = gatherlistmonth12.Find(u => u.KeyName == dtNow.AddMonths(-i).ToString("yyyy-MM")); if (v == null) { gatherlistmonth12.Add(new Statistics_Gather { KeyName = DateTime.Parse(dtNow.ToString("yyyy-MM")).AddMonths(-i).ToString("yyyy-MM"), GatherTime = DateTime.Parse(dtNow.ToString("yyyy-MM-01")).AddMonths(-i) }); } } } } else { for (int i = 0; i < 6; i++) { gatherlistmonth12.Add(new Statistics_Gather { KeyName = DateTime.Parse(dtNow.ToString("yyyy-MM")).AddMonths(-i).ToString("yyyy-MM"), GatherTime = DateTime.Parse(dtNow.ToString("yyyy-MM-01")).AddMonths(-i) }); } } homeresult.GatherMonth12 = gatherlistmonth12.OrderBy(u => u.KeyName).ToList(); } catch (Exception ex) { Common.Services.TxtLogServices.WriteTxtLog("打开首页异常 异常信息:", ex.Message); } return(homeresult); }
public ActionResult GetAduitMonthlyCarApplyData() { try { List <string> parkingIds = new List <string>(); if (!string.IsNullOrEmpty(Request.Params["parkingId"])) { parkingIds.Add(Request.Params["parkingId"].ToString()); } else { List <BaseParkinfo> parings = ParkingServices.QueryParkingByVillageIds(GetLoginUserVillages.Select(p => p.VID).ToList()); parkingIds = parings.Select(p => p.PKID).ToList(); } if (parkingIds.Count == 0) { throw new MyException("获取车场编号失败"); } string applyInfo = Request.Params["applyInfo"]; DateTime startTime = DateTime.Parse(Request.Params["starttime"]); DateTime endTime = DateTime.Parse(Request.Params["endtime"]); MonthlyCarApplyStatus?status = null; int intStatus = 0; if (!string.IsNullOrWhiteSpace(Request.Params["status"]) && int.TryParse(Request.Params["status"].ToString(), out intStatus)) { status = (MonthlyCarApplyStatus)intStatus; } int page = string.IsNullOrEmpty(Request.Params["page"]) ? 0 : int.Parse(Request.Params["page"]); int rows = 15; int total = 0; List <ParkMonthlyCarApply> models = ParkMonthlyCarApplyServices.QueryPage(parkingIds, applyInfo, status, startTime, endTime, rows, page, out total); var result = from p in models select new { ID = p.ID, RecordID = p.RecordID, PKID = p.PKID, CarTypeID = p.CarTypeID, CarModelID = p.CarModelID, ApplyName = p.ApplyName, ApplyMoblie = p.ApplyMoblie, PlateNo = GetNullToEmpty(p.PlateNo), PKLot = GetNullToEmpty(p.PKLot), FamilyAddress = GetNullToEmpty(p.FamilyAddress), ApplyRemark = GetNullToEmpty(p.ApplyRemark), ApplyStatus = (int)p.ApplyStatus, ApplyStatusDes = p.ApplyStatus.GetDescription(), AuditRemark = GetNullToEmpty(p.AuditRemark), ApplyDateTime = p.ApplyDateTime.ToString("yyyy-MM-dd HH:mm:ss"), CarTypeName = p.CarTypeName, CarModelName = p.CarModelName, PKName = p.PKName, }; return(Json(MyResult.Success("", result))); } catch (Exception ex) { ExceptionsServices.AddExceptionToDbAndTxt("AdminAduitCarApply", "获取月租车申请信息失败", ex, LogFrom.WeiXin); return(Json(MyResult.Error("获取月租车申请信息失败"))); } }
public ActionResult Passed(string recordId) { try { List <BaseVillage> villages = VillageServices.QueryVillageByEmployeeMobilePhone(WeiXinUser.MobilePhone); List <EnumContext> parkContexts = new List <EnumContext>(); if (villages.Count > 0) { List <BaseParkinfo> parkings = ParkingServices.QueryParkingByVillageIds(villages.Select(p => p.VID).ToList()); foreach (var item in parkings) { EnumContext model = new EnumContext(); model.Description = item.PKName; model.EnumString = item.PKID; parkContexts.Add(model); } } ViewBag.ParkContexts = parkContexts; ParkMonthlyCarApply monthlyCarApply = ParkMonthlyCarApplyServices.QueryByRecordID(recordId); if (monthlyCarApply == null) { throw new MyException("申请信息不存在"); } List <ParkArea> areas = ParkAreaServices.GetParkAreaByParkingId(monthlyCarApply.PKID); List <EnumContext> areaContexts = new List <EnumContext>(); foreach (var item in areas) { EnumContext model = new EnumContext(); model.Description = item.AreaName; model.EnumString = item.AreaID; areaContexts.Add(model); } ViewBag.AreaContexts = areaContexts; List <EnumContext> gateContexts = new List <EnumContext>(); foreach (var item in areaContexts) { List <ParkGate> gates = ParkGateServices.QueryByParkAreaRecordIds(new List <string>() { item.EnumString }); foreach (var gate in gates) { EnumContext model = new EnumContext(); model.Description = gate.GateName; model.EnumString = string.Format("{0}|{1}", gate.GateID, item.EnumString); gateContexts.Add(model); } } ViewBag.GateContexts = gateContexts; return(View(monthlyCarApply)); } catch (Exception ex) { ExceptionsServices.AddExceptionToDbAndTxt("AdminAduitCarApply", "查看月租车申请详情失败", ex, LogFrom.WeiXin); return(RedirectToAction("Index", "AdminAduitCarApply", new { RemindUserContent = "审核失败" })); } }