public JsonResult GetApplySubList(int userID, int applyMainID = 0) { Thread.Sleep(500); LycJsonResult lycResult = new LycJsonResult(); try { using (FDB = new FamilyCaiWuDBEntities()) { //查询出用户的银行信息 List <UserBank> ubList = FDB.UserBanks.Where(c => c.UserID == userID).ToList(); var result = (from s in FDB.Apply_Sub join sc in FDB.Apply_Sub_CashChange on s.ID equals sc.Apply_Sub_ID into ssc from left1 in ssc.DefaultIfEmpty() where s.ApplyMain_BillCode == applyMainID select new { ApplySubID = s.ID, ApplyMainID = s.ApplyMain_BillCode, CashOrBank = s.CashOrBank, FlowTypeID = s.FlowTypeID, FlowTypeName = s.FlowTypeName, InoutType = s.InOutType, FeeItemID = s.FeeItemID == null ? 0 : s.FeeItemID.Value, FeeItemName = s.FeeItemName, iMoney = s.iMoney, UserBankID = s.UserBankID == null ? 0 : s.UserBankID.Value, BChange = s.BChange, InUserBankID = left1.InUserBankID == null ? 0 : left1.InUserBankID.Value, OutUserBankID = left1.OutUserBankID == null ? 0 : left1.OutUserBankID.Value, CAdd = s.CAdd, CreateDate_date = s.CreateDate.Value }).ToList(); List <QueryApplySubModel> list = new List <QueryApplySubModel>(); foreach (var s in result) { QueryApplySubModel asm = new QueryApplySubModel(); asm.CreateDate = s.CreateDate_date.ToString("yyyy-MM-dd"); asm.ApplySubID = s.ApplySubID; asm.ApplyMainID = s.ApplyMainID; asm.CashOrBank = s.CashOrBank; asm.FlowTypeID = s.FlowTypeID; asm.FlowTypeName = s.FlowTypeName; asm.InoutType = s.InoutType; asm.FeeItemID = s.FeeItemID; asm.FeeItemName = s.FeeItemName; asm.iMoney = s.iMoney.ToString(); asm.UserBankID = s.UserBankID; asm.UserBankName = ""; asm.BChange = s.BChange; asm.InUserBankID = s.InUserBankID; asm.InUserBankName = ""; asm.OutUserBankID = s.OutUserBankID; asm.OutUserBankName = ""; asm.CAdd = s.CAdd; foreach (var bank in ubList) { if (asm.UserBankID == bank.ID) { asm.UserBankName = bank.BankName; } if (asm.InUserBankID == bank.ID) { asm.InUserBankName = bank.BankName; } if (asm.OutUserBankID == bank.ID) { asm.OutUserBankName = bank.BankName; } } list.Add(asm); } lycResult.Data = new JsonResultModel(true, "账单明细成功!", list); } } catch { lycResult.Data = new JsonResultModel(false, "账单查询失败!", new object { }); } return(lycResult); }
public JsonResult GetApplySubList(int userID, int applyMainID = 0) { Thread.Sleep(500); LycJsonResult lycResult = new LycJsonResult(); try { using (FDB = new FamilyCaiWuDBEntities()) { //查询出用户的银行信息 List<UserBank> ubList = FDB.UserBanks.Where(c => c.UserID == userID).ToList(); var result = (from s in FDB.Apply_Sub join sc in FDB.Apply_Sub_CashChange on s.ID equals sc.Apply_Sub_ID into ssc from left1 in ssc.DefaultIfEmpty() where s.ApplyMain_BillCode == applyMainID select new { ApplySubID = s.ID, ApplyMainID = s.ApplyMain_BillCode, CashOrBank = s.CashOrBank, FlowTypeID = s.FlowTypeID, FlowTypeName = s.FlowTypeName, InoutType = s.InOutType, FeeItemID = s.FeeItemID == null ? 0 : s.FeeItemID.Value, FeeItemName = s.FeeItemName, iMoney = s.iMoney, UserBankID = s.UserBankID == null ? 0 : s.UserBankID.Value, BChange = s.BChange, InUserBankID = left1.InUserBankID == null ? 0 : left1.InUserBankID.Value, OutUserBankID = left1.OutUserBankID == null ? 0 : left1.OutUserBankID.Value, CAdd = s.CAdd, CreateDate_date = s.CreateDate.Value }).ToList(); List<QueryApplySubModel> list = new List<QueryApplySubModel>(); foreach (var s in result) { QueryApplySubModel asm = new QueryApplySubModel(); asm.CreateDate = s.CreateDate_date.ToString("yyyy-MM-dd"); asm.ApplySubID = s.ApplySubID; asm.ApplyMainID = s.ApplyMainID; asm.CashOrBank = s.CashOrBank; asm.FlowTypeID = s.FlowTypeID; asm.FlowTypeName = s.FlowTypeName; asm.InoutType = s.InoutType; asm.FeeItemID = s.FeeItemID; asm.FeeItemName = s.FeeItemName; asm.iMoney = s.iMoney.ToString(); asm.UserBankID = s.UserBankID; asm.UserBankName = ""; asm.BChange = s.BChange; asm.InUserBankID = s.InUserBankID; asm.InUserBankName = ""; asm.OutUserBankID = s.OutUserBankID; asm.OutUserBankName = ""; asm.CAdd = s.CAdd; foreach (var bank in ubList) { if (asm.UserBankID == bank.ID) { asm.UserBankName = bank.BankName; } if (asm.InUserBankID == bank.ID) { asm.InUserBankName = bank.BankName; } if (asm.OutUserBankID == bank.ID) { asm.OutUserBankName = bank.BankName; } } list.Add(asm); } lycResult.Data = new JsonResultModel(true, "账单明细成功!", list); } } catch { lycResult.Data = new JsonResultModel(false, "账单查询失败!", new object { }); } return lycResult; }