//获取当前开户银行的所有卡号 public ActionResult GetAllFaHuoBakCardNumber() { string fhb = Request["FHB"]; var cardNum = T_JieKuanBillService.LoadEntities(x => x.OpenHang == fhb).DefaultIfEmpty().ToList(); List <T_JieKuanBill> sb = new List <T_JieKuanBill>(); if (cardNum.Count <= 1) { sb.AddRange(cardNum); } else { var a = cardNum.Where((x, i) => cardNum.FindIndex(z => z.CardNumber == x.CardNumber) == i).ToList(); sb.AddRange(a); } List <BaoXiaoLR> list = new List <BaoXiaoLR>(); foreach (var a in sb) { if (a == null || a.CardNumber == null) { continue; } BaoXiaoLR bxlr = new BaoXiaoLR(); bxlr.ID = a.ID; bxlr.Text = a.CardNumber; list.Add(bxlr); } return(Json(list, JsonRequestBehavior.AllowGet)); }
//获取借款部门下所有收款单位 public ActionResult GetBuMenAllSKDW() { int bmid = Convert.ToInt32(Request["BMID"]); var temp = T_JieKuanBillService.LoadEntities(x => x.BuMenid == bmid).DefaultIfEmpty().ToList(); List <T_JieKuanBill> sb = new List <T_JieKuanBill>(); if (temp.Count <= 1) { sb.AddRange(temp); } else { var a = temp.Where((x, i) => temp.FindIndex(z => z.SkdwName == x.SkdwName) == i).ToList(); sb.AddRange(a); } List <BaoXiaoLR> list = new List <BaoXiaoLR>(); foreach (var a in sb) { if (a == null || a.SkdwName == null) { continue; } BaoXiaoLR bxlr = new BaoXiaoLR(); bxlr.ID = a.ID; bxlr.Text = a.SkdwName; list.Add(bxlr); } return(Json(list, JsonRequestBehavior.AllowGet)); }
//获取当前收款单位所有开户行 public ActionResult GetAllFaHuoBak() { string skdw = Request["SKDW"]; var temp = T_JieKuanBillService.LoadEntities(x => x.SkdwName == skdw).DefaultIfEmpty().ToList(); List <T_JieKuanBill> sb = new List <T_JieKuanBill>(); if (temp.Count <= 1) { sb.AddRange(temp); } else { var a = temp.Where((x, i) => temp.FindIndex(z => z.OpenHang == x.OpenHang) == i).ToList(); sb.AddRange(a); } List <BaoXiaoLR> list = new List <BaoXiaoLR>(); foreach (var a in sb) { if (a == null || a.OpenHang == null) { continue; } BaoXiaoLR bxlr = new BaoXiaoLR(); bxlr.ID = a.ID; bxlr.Text = a.OpenHang; list.Add(bxlr); } return(Json(list, JsonRequestBehavior.AllowGet)); }
//获取所有报销内容 public ActionResult GetBaoXiaoall() { //获取所有本用户创建过的报销内容 int uid = LoginUser.ID; var tempBXB = T_BaoXiaoBillService.LoadEntities(x => x.AddUserID == uid && x.Del == 0).DefaultIfEmpty(); List <BaoXiaoLR> list = new List <BaoXiaoLR>(); if (tempBXB.First() == null) { BaoXiaoLR bxlr = new BaoXiaoLR(); bxlr.ID = 0; bxlr.Text = ""; list.Add(bxlr); return(Json(list, JsonRequestBehavior.AllowGet)); } List <T_BaoxiaoItems> bilist = new List <T_BaoxiaoItems>(); foreach (var a in tempBXB) { var tempBXI = T_BaoxiaoItemsService.LoadEntities(x => x.BaoXiaoID == a.ID).DefaultIfEmpty().ToList(); foreach (var d in tempBXI) { if (d == null || d.BaoXiaoName == null) { continue; } else { bilist.Add(d); } } } List <T_BaoxiaoItems> sb1 = new List <T_BaoxiaoItems>(); if (bilist.Count <= 1) { sb1.AddRange(bilist); } else { sb1 = bilist.Where((x, i) => bilist.FindIndex(z => z.BaoXiaoName == x.BaoXiaoName) == i).ToList(); } Random rd = new Random(); foreach (var c in sb1) { BaoXiaoLR bxlr = new BaoXiaoLR(); bxlr.ID = c.ID + rd.Next(100, 10000); bxlr.Text = c.BaoXiaoName; list.Add(bxlr); } //获取所有本部门创建过得借款单内容 var tempJKB = T_JieKuanBillService.LoadEntities(x => x.UserAdd == uid && x.Del == 0).DefaultIfEmpty().ToList(); List <T_JieKuanBill> sb2 = new List <T_JieKuanBill>(); if (tempJKB.Count <= 1) { sb2.AddRange(tempJKB); } else { sb2 = tempJKB.Where((x, i) => tempJKB.FindIndex(z => z.SkdwName == x.SkdwName) == i).ToList(); } List <BaoXiaoLR> JKBLR = new List <BaoXiaoLR>(); foreach (var d in sb2) { if (d == null || d.SkdwName == null) { continue; } else { BaoXiaoLR jklr = new BaoXiaoLR(); jklr.ID = d.ID; jklr.Text = d.SkdwName; JKBLR.Add(jklr); } } list.AddRange(JKBLR); //users.Where((x, i) => users.FindIndex(z => z.name == x.name) == i).ToList();拉姆达表达式去重 return(Json(list, JsonRequestBehavior.AllowGet)); }