/// <summary>
/// 房屋列表页面
/// </summary>
/// <param name="house"></param>
/// <param name="page"></param>
/// <param name="size"></param>
/// <returns></returns>
public ActionResult HouseList(House_Info house, int delete = 0, int page = 1, int size = 8)
{
if (HasHouseUser())
{
string username = "";
int pages = 0, count = 0;
bool isdelete = false;
if (delete == 1)
{
isdelete = true;
}
User_Info user = GetUser();
if (user.UserRole == EnumCode.UserRole.Normal)
{
username = user.LoginName;
}
List <House_Info> list = _houseService.GetHouseList(house, isdelete, username, page, size, out pages, out count);
ViewBag.house = house;
ViewBag.count = count;
ViewBag.pages = pages;
ViewBag.page = page;
ViewBag.delete = delete;
return(View(list));
}
return(RedirectToAction("Login", "User"));
}
public bool EditHouse(House_Info house)
{
try
{
House_Info Info = GetHouseById(house.HouseId);
if (Info != null)
{
Info.HouseName = house.HouseName;
Info.HouseStatus = house.HouseStatus;
Info.AreaCode = house.AreaCode;
Info.Community = house.Community;
Info.Building = house.Building;
Info.Unit = house.Unit;
Info.RoomNumber = house.RoomNumber;
Info.Toward = house.Toward;
Info.HouseType = house.HouseType;
Info.AreaSize = house.AreaSize;
Info.DegreeOfDecoration = house.DegreeOfDecoration;
Info.MonthlyRcnt = house.MonthlyRcnt;
Info.UpdateDate = DateTime.Now;
db.SaveChanges();
return(true);
}
return(false);
}
catch (Exception ex)
{
return(false);
}
}
public JsonResult EditHouseSubmit(House_Info house)
{
string message = "";
bool flag = _houseService.EditHouse(house, out message);
return(Json(new { Flag = flag, Message = message }));
}
/// <summary>
/// 房屋管理分页
/// </summary>
/// <param name="user">搜索参数</param>
/// <param name="page">当前页</param>
/// <param name="size">每页数量</param>
/// <param name="pages">总页数</param>
/// <param name="count">总数量</param>
/// <returns></returns>
public List <House_Info> GetHouseList(House_Info house, bool delete, string username, int page, int size, out int pages, out int count)
{
count = db.House_Info.Where(m => (string.IsNullOrEmpty(house.Community) || m.Community.Contains(house.Community)) && (string.IsNullOrEmpty(username) || m.LandlordName == username) && m.DeleteStatus == delete).Count();
pages = count % size == 0 ? count / size : count / size + 1;
page = page <= 1 ? 1 : page;
page = page >= pages && pages > 0 ? pages : page;
return(db.House_Info.Where(m => (string.IsNullOrEmpty(house.Community) || m.Community.Contains(house.Community)) && (string.IsNullOrEmpty(username) || m.LandlordName == username) && m.DeleteStatus == delete).OrderBy(m => m.HouseId).Skip(size * (page - 1)).Take(size).ToList());
}
public JsonResult AddHouseSubmit(House_Info house)
{
User_Info user = GetUser();
if (user.UserRole == EnumCode.UserRole.Normal)
{
house.LandlordName = user.LoginName;
}
string message = "";
bool flag = _houseService.AddHouse(house, out message);
return(Json(new { Flag = flag, Message = message }));
}
public bool DeleteHouse(House_Info house)
{
try
{
house.DeleteStatus = true;
db.SaveChanges();
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public bool AddHouse(House_Info house)
{
try
{
db.House_Info.Add(house);
db.SaveChanges();
return(true);
}
catch (Exception ex)
{
string message = ex.Message;
return(false);
}
}
public bool DeleteHouse(int houseId, out string message)
{
House_Info house = _houseRepositiry.GetHouseById(houseId);
if (house != null)
{
if (_houseRepositiry.DeleteHouse(house))
{
message = "删除成功";
return(true);
}
}
message = "删除失败";
return(false);
}
public bool AddHouse(House_Info house, out string message)
{
house.DeleteStatus = false;
house.CreateDate = DateTime.Now;
house.HouseStatus = false;
if (_houseRepositiry.AddHouse(house))
{
message = "添加成功";
return(true);
}
else
{
message = "添加失败";
return(false);
}
}
public bool EditHouse(House_Info house, out string message)
{
if (_houseRepositiry.GetHouseById(house.HouseId) != null)
{
if (_houseRepositiry.EditHouse(house))
{
message = "修改成功";
return(true);
}
else
{
message = "修改失败";
return(false);
}
}
else
{
message = "房屋不存在";
return(false);
}
}
//编辑房屋页面
public ActionResult EditHouse(int houseId)
{
House_Info house = _houseService.GetHouseById(houseId);
return(View(house));
}
public List <House_Info> GetHouseList(House_Info house, bool delete, string username, int page, int size, out int pages, out int count)
{
return(_houseRepositiry.GetHouseList(house, delete, username, page, size, out pages, out count));
}
