//微信用获取工票信息 public ActionResult GetGPtopInfo() { int pageIndex = Request["page"] != null?int.Parse(Request["page"]) : 1; int pageSize = Request["rows"] != null?int.Parse(Request["rows"]) : 15; int toalcount = 0; var temp = new List <YSGPtop>(); var rtmp = new List <GPtop>(); var userList = UserInfoService.LoadEntities(x => x.ID > 0).DefaultIfEmpty().ToList(); int uid = Convert.ToInt32(Request["uid"]); string uidStr = Request["uid"]; temp = YSGPtopService.LoadPageEntities(pageIndex, pageSize, out toalcount, x => x.Del_f == 0 && (x.AddUser == uid || x.PGperson.Contains(uidStr)), x => x.GPtime, false).DefaultIfEmpty().ToList(); if (temp != null && temp[0] != null) { foreach (var a in temp) { GPtop gt = new GPtop(); gt.ID = a.ID; gt.GPtime = a.GPtime; gt.PGbumen = a.BumenInfoSet.Name; if (a.PGperson.IndexOf("|") == -1) { int id = Convert.ToInt32(a.PGperson); var userinfo = userList.Where(x => x.ID == id).FirstOrDefault(); gt.PGperson = userinfo.PerSonName; } else { string userStr = ""; var ary = a.PGperson.Split('|'); foreach (var b in ary) { int sid = Convert.ToInt32(b.Trim()); var userinfo = userList.Where(x => x.ID == sid).FirstOrDefault(); userStr = userStr == "" ? userinfo.PerSonName : userStr + "、" + userinfo.PerSonName; } gt.PGperson = userStr; } gt.StartTime = a.StartTime; gt.EndTime = a.EndTime; gt.WorkTime = a.WorkTime; gt.PGpersonAllWages = a.PGpersonAllWages; gt.SettlementAmount = a.SettlementAmount; gt.gpInfo = a.WorkInfo; gt.WorkAddress = a.BumenInfoSet1.Name; gt.GPState = T_BoolItemService.LoadEntities(x => x.ItemsID == 9 && x.@int == a.GPState).First().str; gt.GPStateNum = a.GPState; gt.pingJiaStateNum = a.pingjiaState; gt.pingJiaState = a.pingjiaState == 0 ? "满意" : a.pingjiaState == 1 ? "一般" : "不满意"; rtmp.Add(gt); } } return(Json(new { rows = rtmp, total = toalcount }, JsonRequestBehavior.AllowGet)); }
//获取工票头信息 public ActionResult GetAllGPtopInfo() { int pageIndex = Request["page"] != null?int.Parse(Request["page"]) : 1; int pageSize = Request["rows"] != null?int.Parse(Request["rows"]) : 15; int bumenID = Request["BMID"] != null && Request["BMID"].Trim().Length > 0 ? int.Parse(Request["BMID"]) : 0; string uid = Request["uid"] != null && Request["uid"].Trim().Length > 0 ? Request["uid"] : "0"; string startDate = Request["startDate"] != null && Request["startDate"].Trim().Length > 0 ? Request["startDate"] : "0"; string endDate = Request["endDate"] != null && Request["endDate"].Trim().Length > 0 ? Request["endDate"] : "0"; int toalcount = 0; var temp = new List <YSGPtop>(); var rtmp = new List <GPtop>(); var userList = UserInfoService.LoadEntities(x => x.ID > 0).DefaultIfEmpty().ToList(); if (bumenID == 0 && uid == "0") { temp = YSGPtopService.LoadPageEntities(pageIndex, pageSize, out toalcount, x => x.Del_f == 0 && x.GPState == 2, x => x.GPtime, false).DefaultIfEmpty().ToList(); } else if (bumenID != 0 && uid == "0") { temp = YSGPtopService.LoadEntities(x => x.Del_f == 0 && x.PGbumen == bumenID && x.GPState == 2).DefaultIfEmpty().OrderBy(x => x.GPtime).ToList(); } else if (bumenID != 0 && uid != "0") { temp = YSGPtopService.LoadEntities(x => x.Del_f == 0 && x.PGperson.Contains(uid) && x.GPState == 2).DefaultIfEmpty().OrderBy(x => x.GPtime).ToList(); } if (startDate != "0" && endDate != "0") { DateTime start = Convert.ToDateTime(startDate); DateTime end = Convert.ToDateTime(endDate); temp = temp.Where(x => x.GPtime >= start && x.GPtime <= end).DefaultIfEmpty().ToList(); } if (temp != null && temp[0] != null) { foreach (var a in temp) { GPtop gt = new GPtop(); gt.ID = a.ID; gt.GPtime = a.GPtime; gt.PGbumen = a.BumenInfoSet.Name; if (a.PGperson.IndexOf("|") == -1) { int id = Convert.ToInt32(a.PGperson); var userinfo = userList.Where(x => x.ID == id).FirstOrDefault(); gt.PGperson = userinfo.PerSonName; } else { string userStr = ""; var ary = a.PGperson.Split('|'); foreach (var b in ary) { int sid = Convert.ToInt32(b.Trim()); var userinfo = userList.Where(x => x.ID == sid).FirstOrDefault(); userStr = userStr == "" ? userinfo.PerSonName : userStr + "、" + userinfo.PerSonName; } gt.PGperson = userStr; } gt.StartTime = a.StartTime; gt.EndTime = a.EndTime; gt.WorkTime = a.WorkTime; gt.PGpersonAllWages = a.PGpersonAllWages; gt.SettlementAmount = a.SettlementAmount; gt.gpInfo = a.WorkInfo; gt.WorkAddress = a.BumenInfoSet1.Name; gt.pingJiaStateNum = a.pingjiaState; gt.pingJiaState = a.pingjiaState == 0 ? "满意" : a.pingjiaState == 1 ? "一般" : "不满意"; rtmp.Add(gt); } } return(Json(new { rows = rtmp, total = toalcount }, JsonRequestBehavior.AllowGet)); }