/// <summary> /// 远程验证批量添加单元 /// </summary> /// <param name="model"></param> /// <param name="BuildId"></param> /// <returns></returns> public string RemoteCheck(BuildUnitBatchAddModel model) { IBuildUnitBLL unitBll = BLLFactory <IBuildUnitBLL> .GetBLL("BuildUnitBLL"); var lamdaList = new List <Expression <Func <T_BuildUnit, bool> > >(); foreach (var name in model.UnitName) { lamdaList.Add(r => r.UnitName == name); } Expression <Func <T_BuildUnit, bool> > lamda = p => false; Expression <Func <T_BuildUnit, bool> > lamda1 = r => (r.BuildId == model.BuildId); foreach (var expression in lamdaList) { lamda = PredicateBuilder.Or <T_BuildUnit>(lamda, expression); } lamda = PredicateBuilder.And(lamda, lamda1); var unitlist = unitBll.GetList(lamda);//查询 if (unitlist.Count() > 0) { // 校验不通过 return(string.Join(",", unitlist.ToList().Select(q => q.UnitName).Distinct().ToArray())); } else { // 校验通过 return(""); } }
public JsonResult GetUnitList(int buildId) { IBuildUnitBLL buildUnitBll = BLLFactory <IBuildUnitBLL> .GetBLL("BuildUnitBLL"); var list = buildUnitBll.GetList(u => u.BuildId == buildId); //转换为下拉列表 List <SelectListItem> buildUnitList = list.Select(c => new SelectListItem() { Text = c.UnitName, Value = c.Id.ToString(), Selected = false, }).ToList(); return(Json(buildUnitList, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 获取单元列表 /// </summary> /// <returns>单元列表</returns> private List <SelectListItem> GetUnitList(int buildId) { //获取单元列表 IBuildUnitBLL UnitBll = BLLFactory <IBuildUnitBLL> .GetBLL("BuildUnitBLL"); var sortModel = this.SettingSorting("Id", true); var list = UnitBll.GetList(u => u.BuildId == buildId, sortModel.SortName, sortModel.IsAsc); //转换为下拉列表并返回 return(list.Select(m => new SelectListItem() { Text = m.UnitName, Value = m.Id.ToString(), Selected = false }).ToList()); }
public JsonResult GetUnitList(int?buildId) { List <object> list = new List <object>(); if (buildId == null) { return(Json(list, JsonRequestBehavior.AllowGet)); } IBuildUnitBLL bll = BLLFactory <IBuildUnitBLL> .GetBLL("BuildUnitBLL"); foreach (var item in bll.GetList(m => m.BuildId == buildId.Value).ToList()) { list.Add(new { Value = item.Id.ToString(), Text = item.UnitName }); } return(Json(list, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 根据楼座ID加载单元列表 /// </summary> /// <param name="buildId">楼座Id</param> /// <returns></returns> public JsonResult AjaxGetUnits(int?buildId) { List <SelectListItem> unitList = new List <SelectListItem>(); if (buildId.HasValue && buildId.Value > 0) { IBuildUnitBLL unitBll = FactoryBLL.BLLFactory <IBuildUnitBLL> .GetBLL("BuildUnitBLL"); unitList.Add(new SelectListItem() { Text = "选择单元", Value = string.Empty, Selected = true }); var units = unitBll.GetList(u => u.BuildId == buildId.Value).OrderBy(u => u.UnitName).Select(u => new SelectListItem() { Text = u.UnitName, Value = u.Id.ToString() }).ToList(); unitList.AddRange(units); } return(Json(unitList)); }
public ActionResult ExpenseSettings(ExpenseSettingsModel model) { var currentPropertyPlaceId = GetSessionModel().PropertyPlaceId.Value; if (model.NotificationDate == null) { model.NotificationDate = DateTime.Now.AddDays(1); } IBuildBLL buildBLL = BLLFactory <IBuildBLL> .GetBLL("BuildBLL"); //绑定楼座下拉列表 var buildList = buildBLL.GetList(b => b.PropertyPlaceId == currentPropertyPlaceId, "BuildName", true).ToList(); model.BuildList = buildList.Select(b => new SelectListItem() { Text = b.BuildName, Value = b.Id.ToString() }).ToList(); List <SelectListItem> unitList = new List <SelectListItem>(); unitList.Add(new SelectListItem() { Text = "选择单元", Value = string.Empty }); //绑定单元下拉列表 if (model.BuildId > 0) { IBuildUnitBLL unitBll = FactoryBLL.BLLFactory <IBuildUnitBLL> .GetBLL("BuildUnitBLL"); var units = unitBll.GetList(u => u.BuildId == model.BuildId).OrderBy(u => u.UnitName).Select(u => new SelectListItem() { Text = u.UnitName, Value = u.Id.ToString(), Selected = (u.Id == model.UnitId) }).ToList(); unitList.AddRange(units); } model.UnitList = unitList; //绑定缴费种类名称下拉列表 IPropertyExpenseTypeBLL typeBLL = BLLFactory <IPropertyExpenseTypeBLL> .GetBLL("PropertyExpenseTypeBLL"); model.ExpenseTypeList = typeBLL.GetList(t => t.IsFixed == model.ExpenseClassId && t.PropertyPlaceId == currentPropertyPlaceId).OrderBy(t => t.Name).Select(t => new SelectListItem() { Text = t.Name, Value = t.Id.ToString() }).ToList(); //绑定缴费明细 IBuildUnitBLL unitBLL = BLLFactory <IBuildUnitBLL> .GetBLL("BuildUnitBLL"); if (model.BuildId > 0) { var unit = unitBLL.GetEntity(u => u.BuildId == model.BuildId && u.Id == model.UnitId); if (unit != null) { var doorList = unit.BuildDoors.OrderBy(u => u.DoorName).ToList(); var doorIds = doorList.Select(d => d.Id); IHouseUserExpenseTemplateBLL expenseTemplateBLL = BLLFactory <IHouseUserExpenseTemplateBLL> .GetBLL("HouseUserExpenseTemplateBLL"); var allDoorExpenseByExpenseType = expenseTemplateBLL.GetList(e => e.ExpenseTypeId == model.ExpenseTypeId && e.BuildDoorId != null && doorIds.Contains(e.BuildDoorId.Value)); var houseUserExpenseTemplateList = new List <HouseUserExpenseTemplateModel>(); if (allDoorExpenseByExpenseType.Count() > 0) { var doorExpense = allDoorExpenseByExpenseType.FirstOrDefault(); model.ExpenseCircleId = doorExpense.ExpenseCycleId; model.NotificationDate = doorExpense.NotificationDate; } foreach (var door in doorList) { var houseUserExpenseTemplateModel = new HouseUserExpenseTemplateModel(); houseUserExpenseTemplateModel.DoorId = door.Id; houseUserExpenseTemplateModel.DoorName = door.DoorName; var doorExpense = allDoorExpenseByExpenseType.FirstOrDefault(e => e.BuildDoorId == door.Id); if (doorExpense != null) { houseUserExpenseTemplateModel.Expense = doorExpense.Expense.ToString(); } houseUserExpenseTemplateList.Add(houseUserExpenseTemplateModel); } model.HouseUserExpenseTemplateList = houseUserExpenseTemplateList; } } return(View(model)); }