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