/// <summary>
/// 分页查询
/// </summary>
/// <returns></returns>
public string GetVillageInfo()
{
int pageIndex = Convert.ToInt32(Request["page"]);
int pageSize = Convert.ToInt32(Request["limit"]);
//获取文本框的值:有可能为null ，有可能为"" ，有可能为其他字符串
string selectInfo = Request["selectInfo"];
//设置总条数，默认值为0
int count = 0;
//使用json.net序列化数据
List <VillageInfo> list = VillageInfoService.GetPageList(pageIndex, pageSize, out count, selectInfo);
IsoDateTimeConverter timeConverter = new IsoDateTimeConverter
{
DateTimeFormat = "yyyy'-'MM'-'dd hh':'mm':'ss"//格式化时间，默认是ISO8601格式
};
string strjson = JsonConvert.SerializeObject(list, Formatting.Indented, timeConverter);
//字符串拼接，构造与layui规则相同的json对象数组字符串
string str = "{\"code\": 0 ,\"msg\": \"\",\"count\": " + count + " ,\"data\":";
str += strjson + "}";
return(str);
}
/// <summary>
/// 添加页面
/// </summary>
/// <returns></returns>
public ActionResult HouseAdd()
{
List <VillageInfo> model = VillageInfoService.GetVillageInfo();
List <FloorInfo> floorInfos = FloorInfoService.GetFloorInfo();
ViewBag.Village = model;
ViewBag.FloorInfo = floorInfos;
return(View());
}
/// <summary>
/// 修改页面
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public ActionResult VillageUpdate(int id)
{
//根据传过来的id获取选中账号的信息,并把查到的数据赋值给viewbag，以便页面绑定数据
VillageInfo model = VillageInfoService.GetModelByID(id);
if (model != null)
{
ViewBag.model = model;
}
return(View());
}
public string Delete(Array id)
{
if (VillageInfoService.Delete(id))
{
return("ok");
}
else
{
return("no");
}
}
/// <summary>
/// 检查是否已存在
/// </summary>
/// <param name="value"></param>
/// <returns></returns>
public string CheckRepeat(string value)
{
if (VillageInfoService.CheckRepeat(value))
{
//说明小区信息已存在--告诉前端，不合法
return("no");
}
else
{
return("ok");
}
}
/// <summary>
/// 添加方法
/// </summary>
/// <param name="VillageInfoJson">前端返回的JSON数据</param>
/// <returns></returns>
public string VillageInfoAdd(string VillageInfoJson)
{
//添加数据
//Json转实体类
VillageInfoInputDTO villageInfo = JsonConvert.DeserializeObject <VillageInfoInputDTO>(VillageInfoJson);
if (VillageInfoService.DTOAdd(villageInfo))
{
return("ok");
}
else
{
return("no");
}
}
/// <summary>
/// 修改方法
/// </summary>
/// <param name="VillageInfoJson">前端返回的JSON数据</param>
/// <returns></returns>
public string VillageInfoUpdate(string VillageInfoJson)
{
int outID;
//Json转实体类
VillageInfoInputDTO villageInfo = JsonConvert.DeserializeObject <VillageInfoInputDTO>(VillageInfoJson);
if (VillageInfoService.DTOUpdate(villageInfo, out outID) > 0)
{
return("ok");
}
else
{
return("no");
}
}
/// <summary>
/// 修改页面
/// </summary>
/// <returns></returns>
public ActionResult HouseUpdate(int ID)
{
List <VillageInfo> model = VillageInfoService.GetVillageInfo();
List <FloorInfo> floorInfos = FloorInfoService.GetFloorInfo();
List <UserInfo> userInfos = UserInfoService.GetUserInfo();
ViewBag.Village = model;
ViewBag.FloorInfo = floorInfos;
ViewBag.UserInfo = userInfos;
HouseInfo houseInfo = HouseInfoService.GetHouseInfoByID(ID);
ViewBag.HouseInfo = houseInfo;
return(View());
}
/// <summary>
/// 分页查询
/// </summary>
/// <returns></returns>
public string GetHouseInfo()
{
List <VillageInfo> model = VillageInfoService.GetVillageInfo();
List <FloorInfo> floorInfos = FloorInfoService.GetFloorInfo();
ViewBag.Village = model;
ViewBag.FloorInfo = floorInfos;
//分页查询
//拿到前端传来的数据-->第几页，每页显示多少条
int pageIndex = Convert.ToInt32(Request["page"]);
int pageSize = Convert.ToInt32(Request["limit"]);
//获取文本框的值:有可能为null ，有可能为"" ，有可能为其他字符串
string VillageID = Request["VillageID"];
string selectInfo = Request["selectInfo"];
//string FloorID = Request["FloorID"];
string State = Request["State"];
//设置总条数，默认值为0
int count = 0;
//使用json.net序列化数据
//List<HouseOutput> list = HouseInfoService.GetPageList(pageIndex, pageSize, out count, VillageID,selectInfo, State);
//DTO
List <HouseInfoOutputDTO> list = HouseInfoService.DTOGetPageList(pageIndex, pageSize, out count, VillageID, selectInfo, State);
IsoDateTimeConverter timeConverter = new IsoDateTimeConverter
{
DateTimeFormat = "yyyy'-'MM'-'dd hh':'mm':'ss"//格式化时间，默认是ISO8601格式
};
string strjson = JsonConvert.SerializeObject(list, Formatting.Indented, timeConverter);
//字符串拼接，构造与layui规则相同的json对象数组字符串
string str = "{\"code\": 0 ,\"msg\": \"\",\"count\": " + count + " ,\"data\":";
str += strjson + "}";
return(str);
}
