public JsonResult AddHouseUser(HouseUserModel model) { JsonModel jm = new JsonModel(); //如果表单验证成功 if (ModelState.IsValid) { IHouseUserBLL houseUserBll = BLLFactory <IHouseUserBLL> .GetBLL("HouseUserBLL"); T_HouseUser houseuser = new T_HouseUser() { Name = model.Name, Phone = model.Phone, Gender = model.Gender, DoorId = model.DoorId, Desc = model.Desc, PayDesc = model.PayDesc, ServiceDesc = model.ServiceDesc, PropertyPlaceId = GetSessionModel().PropertyPlaceId.Value, }; //保存 houseUserBll.Save(houseuser); //日志记录 jm.Content = PropertyUtils.ModelToJsonString(model); } else { jm.Msg = ConstantParam.JSON_RESULT_MODEL_CHECK_ERROR; } return(Json(jm, JsonRequestBehavior.AllowGet)); }
public ActionResult EditHouseUser(int id) { IHouseUserBLL houseUserBll = BLLFactory <IHouseUserBLL> .GetBLL("HouseUserBLL"); //获取要编辑的住宅业主 T_HouseUser houseUser = houseUserBll.GetEntity(m => m.Id == id && m.DelFlag == ConstantParam.DEL_FLAG_DEFAULT); if (houseUser != null) { //初始化返回页面模型 HouseUserModel model = new HouseUserModel() { Name = houseUser.Name, Phone = houseUser.Phone, BuildId = houseUser.BuildDoor.BuildUnit.BuildId, BuildList = GetBuildList(), UnitId = houseUser.BuildDoor.UnitId, UnitList = GetUnitList(houseUser.BuildDoor.BuildUnit.BuildId), DoorId = houseUser.DoorId, DoorList = GetDoorList(houseUser.BuildDoor.UnitId), Gender = houseUser.Gender, GenderList = GetGenderList(), Desc = houseUser.Desc, PayDesc = houseUser.PayDesc, ServiceDesc = houseUser.ServiceDesc }; return(View(model)); } else { return(RedirectToAction("HouseUserList")); } }
public ActionResult DetailHouseUser(int id) { IHouseUserBLL houseUserBll = BLLFactory <IHouseUserBLL> .GetBLL("HouseUserBLL"); //获取要查看的住宅业主 T_HouseUser houseUser = houseUserBll.GetEntity(m => m.Id == id && m.DelFlag == ConstantParam.DEL_FLAG_DEFAULT); if (houseUser != null) { return(View(houseUser)); } else { return(RedirectToAction("HouseUserList")); } }
public JsonResult EditHouseUser(HouseUserModel model) { JsonModel jm = new JsonModel(); //如果表单验证成功 if (ModelState.IsValid) { IHouseUserBLL houseUserBll = BLLFactory <IHouseUserBLL> .GetBLL("HouseUserBLL"); T_HouseUser houseUser = houseUserBll.GetEntity(m => m.Id == model.Id && m.DelFlag == ConstantParam.DEL_FLAG_DEFAULT); if (houseUser != null) { houseUser.Name = model.Name; houseUser.Phone = model.Phone; houseUser.PropertyPlaceId = GetSessionModel().PropertyPlaceId.Value; houseUser.BuildDoor.BuildUnit.BuildId = model.BuildId; houseUser.BuildDoor.UnitId = model.UnitId; houseUser.DoorId = model.DoorId; houseUser.Gender = model.Gender; houseUser.Desc = model.Desc; houseUser.PayDesc = model.PayDesc; houseUser.ServiceDesc = model.ServiceDesc; //保存到数据库 if (houseUserBll.Update(houseUser)) { //日志记录 jm.Content = PropertyUtils.ModelToJsonString(model); } else { jm.Msg = "编辑失败"; } } else { jm.Msg = "该住宅业主不存在"; } } else { jm.Msg = ConstantParam.JSON_RESULT_MODEL_CHECK_ERROR; } return(Json(jm, JsonRequestBehavior.AllowGet)); }
public JsonResult DeleteHouseUser(int id) { JsonModel jm = new JsonModel(); //获取要删除的住宅业主 IHouseUserBLL houseUserBll = BLLFactory <IHouseUserBLL> .GetBLL("HouseUserBLL"); T_HouseUser houseUser = houseUserBll.GetEntity(m => m.Id == id && m.DelFlag == ConstantParam.DEL_FLAG_DEFAULT); if (houseUser == null) { jm.Msg = "该住宅业主不存在"; } else { //修改住宅业主的已删除标识 houseUser.DelFlag = ConstantParam.DEL_FLAG_DELETE; //更新数据库 houseUserBll.Update(houseUser); //操作日志 jm.Content = "删除住宅业主" + houseUser.Name; } return(Json(jm, JsonRequestBehavior.AllowGet)); }
public JsonResult ImportHouseUsers(ImportUsersModel Model) { JsonModel jm = new JsonModel(); HttpPostedFileBase file = Model.file; //Model.file //存入的文件名 string FileName; //存入的文件路径 string savePath; string filename = Path.GetFileName(file.FileName); string fileEx = System.IO.Path.GetExtension(filename); //获取上传文件的扩展名 //string NoFileName = System.IO.Path.GetFileNameWithoutExtension(filename);//获取无扩展名的文件名 string FileType = ".xls,.xlsx"; //定义上传文件的类型字符串 if (!FileType.Contains(fileEx)) { jm.Msg = "文件类型只能是xlsx格式的文件"; jm.Code = "error"; return(Json(jm, JsonRequestBehavior.AllowGet)); } FileName = DateTime.Now.ToString("yyyyMMddHHmmss") + fileEx; //存一份及时要导入的数据文件 string path = AppDomain.CurrentDomain.BaseDirectory + "ImportData/ImportHouseUserData/"; if (!Directory.Exists(path)) { Directory.CreateDirectory(path); } savePath = Path.Combine(path, FileName); file.SaveAs(savePath); //住宅业主接口 IHouseUserBLL houseUserBll = BLLFactory <IHouseUserBLL> .GetBLL("HouseUserBLL"); //当前物业小区Id var placePropertyId = GetSessionModel().PropertyPlaceId.Value; //读取存在的要导入的EXCEL数据文件 DataTable dtHouseUser = ImportExcelFile(savePath); //如果文件中没有内容 if (dtHouseUser.Rows.Count == 0) { jm.Msg = "文件内无业主信息"; return(Json(jm, JsonRequestBehavior.AllowGet)); } //有效业主信息列表 var validateHouseUserlist = new List <T_HouseUser>(); //无效业主信息列表 var invalidateHouseUserList = new List <ImportHouseUserModel>(); for (int i = 0; i < dtHouseUser.Rows.Count; i++) { //是否有效标记 bool isValidated = true; var houseUserModel = new ImportHouseUserModel(); //为导入的ImportHouseUserModel赋值,以便用于无效业主列表 if (dtHouseUser.Rows[i][0] != DBNull.Value) { houseUserModel.Name = dtHouseUser.Rows[i][0].ToString().Trim(); } if (dtHouseUser.Rows[i][1] != DBNull.Value) { houseUserModel.Gender = dtHouseUser.Rows[i][1].ToString().Trim(); } if (dtHouseUser.Rows[i][2] != DBNull.Value) { houseUserModel.Phone = dtHouseUser.Rows[i][2].ToString().Trim(); } if (dtHouseUser.Rows[i][3] != DBNull.Value) { houseUserModel.BuildName = dtHouseUser.Rows[i][3].ToString().Trim(); } if (dtHouseUser.Rows[i][4] != DBNull.Value) { houseUserModel.UnitName = dtHouseUser.Rows[i][4].ToString().Trim(); } if (dtHouseUser.Rows[i][5] != DBNull.Value) { houseUserModel.DoorName = dtHouseUser.Rows[i][5].ToString().Trim(); } if (dtHouseUser.Rows[i][6] != DBNull.Value) { houseUserModel.Desc = dtHouseUser.Rows[i][6].ToString().Trim(); } //如果业主姓名没有就是无效 if (string.IsNullOrEmpty(houseUserModel.Name)) { isValidated = false; } //如果电话没有或者填写不正确就是无效 if (string.IsNullOrEmpty(houseUserModel.Phone) || !CheckPhoneValidate(houseUserModel.Phone)) { isValidated = false; } //如果楼座名称没有就是无效 if (string.IsNullOrEmpty(houseUserModel.BuildName)) { isValidated = false; } //如果单元名称没有就是无效 if (string.IsNullOrEmpty(houseUserModel.UnitName)) { isValidated = false; } //如果单元户名字没有就是无效 if (string.IsNullOrEmpty(houseUserModel.DoorName)) { isValidated = false; } //获取楼座ID,如果没有将新建 int buildId = GetBuildId(houseUserModel.BuildName, placePropertyId); //获取单元ID,如果没有将新建 int unitId = GetBuildUnitId(houseUserModel.UnitName, buildId); //获取单元户ID,如果没有将新建 int doorId = GetBuildDoorId(houseUserModel.DoorName, unitId); //楼座,单元,单元户有一个为0,就是无效数据 if (buildId == 0 || unitId == 0 || doorId == 0) { isValidated = false; } //如果单元户已经存在也是无效 if (CheckUserExist(doorId, 0)) { isValidated = false; } if (isValidated) { var houseuser = new T_HouseUser(); //当前物业小区Id houseuser.PropertyPlaceId = placePropertyId; //业主姓名 houseuser.Name = houseUserModel.Name; //业主电话 houseuser.Phone = houseUserModel.Phone; //业主单元户 houseuser.DoorId = doorId; //业主备注 houseuser.Desc = houseUserModel.Desc; //业主性别(男,女) if (houseUserModel.Gender == "男") { houseuser.Gender = 1; } if (houseUserModel.Gender == "女") { houseuser.Gender = 0; } //将有效的业主加入到有效的列表里面 validateHouseUserlist.Add(houseuser); } else { //将无效的业主加入到无效的列表里面 invalidateHouseUserList.Add(houseUserModel); } } bool check = true; //前符合要求的导入数据库 if (validateHouseUserlist.Count > 0) { check = houseUserBll.ImportHouseUsers(validateHouseUserlist); } //如果有业主信息导入成功 if (validateHouseUserlist.Count > 0 && check) { //部分导入失败 if (invalidateHouseUserList.Count > 0) { jm.Msg = string.Format("业主信息导入成功{0}条,失败{1}条", validateHouseUserlist.Count, invalidateHouseUserList.Count); jm.Content = GenerateInvalidateDataExcel(invalidateHouseUserList); } else { jm.Content = string.Format("{0}条业主信息全部导入成功", validateHouseUserlist.Count); } } else { jm.Msg = "业主信息全部导入失败"; } return(Json(jm, JsonRequestBehavior.AllowGet)); }