/// <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));
}