public List <infos> HomeInfosByZuFang()
{
List <HomeInfo> homeInfos = bll.Show();
homeInfos = homeInfos.Where(c => c.HomeInfo_InfoType == 2).ToList();
List <infos> infos = new List <infos>();
foreach (var item in homeInfos)
{
infos info = new infos
{
id = item.HomeInfo_Id,
title = item.HomeInfo_Xq_Name,
district = item.HomeInfo_PosiTion,
payment_method = item.HomeInfo_Area,
wages = item.HomeInfo_AvgPrice,
category = item.HomeInfo_PhotoPath,
created_at = item.HomeInfo_CreateTime,
home_details = item.HomeInfo_IntroDuce,
contact_Name = item.HomeInfo_Contact,
contact_Phone = item.HomeInfo_Phone
};
infos.Add(info);
}
return(infos);
}
/// <summary>
/// 删除记录
/// </summary>
/// <param name="infos">实体</param>
/// <returns>返回是否成功</returns>
public bool Del_infos(infos _infos)
{
try
{
DbHelperSQL.Delete(_infos);
return(true);
}
catch { return(false); }
}
/// <summary>
/// 更新对象
/// </summary>
/// <param name="infos">实体</param>
/// <returns>返回是否成功</returns>
public bool Update_infos(infos _infos)
{
try
{
DbHelperSQL.Update(_infos);
return(true);
}
catch { return(false); }
}
/// <summary>
/// 添加新纪录
/// </summary>
/// <param name="infos">实体</param>
/// <returns>返回是否成功</returns>
public bool Add_infos(infos _infos)
{
try
{
DbHelperSQL.Insert(_infos);
return(true);
}
catch { return(false); }
}
public infos HomeInfosById(int id)
{
HomeInfo homeInfo = bll.ShowById(id);
infos info = new infos
{
id = homeInfo.HomeInfo_Id,
title = homeInfo.HomeInfo_Xq_Name,
district = homeInfo.HomeInfo_PosiTion,
payment_method = homeInfo.HomeInfo_Area,
wages = homeInfo.HomeInfo_InfoType == 1 ? homeInfo.HomeInfo_Price : homeInfo.HomeInfo_AvgPrice,
category = homeInfo.HomeInfo_PhotoPath,
created_at = homeInfo.HomeInfo_CreateTime,
home_details = homeInfo.HomeInfo_IntroDuce,
contact_Name = homeInfo.HomeInfo_Contact,
contact_Phone = homeInfo.HomeInfo_Phone
};
return(info);
}
public List <infos> HomeInfos()
{
redisConn = GetRedisConn();
var db = redisConn.GetDatabase(0);
List <HomeInfo> homes = bll.Show();
string strResult = JsonConvert.SerializeObject(homes);
if (!db.KeyExists("HomeInfo"))
{
db.StringSet("HomeInfo", strResult);
db.KeyExpire("HomeInfo", DateTime.Now.AddMinutes(2));
}
homes = JsonConvert.DeserializeObject <List <HomeInfo> >(db.StringGet("HomeInfo"));
List <HomeInfo> homeInfos = homes;
homeInfos = homeInfos.Where(c => c.HomeInfo_InfoType == 1).ToList();
List <infos> infos = new List <infos>();
foreach (var item in homeInfos)
{
infos info = new infos
{
id = item.HomeInfo_Id,
title = item.HomeInfo_Xq_Name,
district = item.HomeInfo_PosiTion,
payment_method = item.HomeInfo_Area,
wages = item.HomeInfo_Price,
category = item.HomeInfo_PhotoPath,
created_at = item.HomeInfo_CreateTime,
home_details = item.HomeInfo_IntroDuce,
contact_Name = item.HomeInfo_Contact,
contact_Phone = item.HomeInfo_Phone
};
infos.Add(info);
}
return(infos);
}
public List <infos> ShowHomeIds(int userId)
{
List <Attention> attentions = attBll.Show().Where(c => c.Attention_Uid == userId).ToList();
List <HomeInfo> homeInfos = bll.Show();
homeInfos = homeInfos.Where(c => c.HomeInfo_InfoType == 2).ToList();
List <infos> infos = new List <infos>();
foreach (var item in homeInfos)
{
infos info = new infos
{
id = item.HomeInfo_Id,
title = item.HomeInfo_Xq_Name,
district = item.HomeInfo_PosiTion,
payment_method = item.HomeInfo_Area,
wages = item.HomeInfo_Price,
category = item.HomeInfo_PhotoPath,
state = attentions.Select(c => c.Attention_Infoids == item.HomeInfo_Id).Count() > 0 ? 1 : 0
};
infos.Add(info);
}
return(infos);
}
/// <summary>
/// 根据id查找相应的一条记录
/// </summary>
/// <param name="id">要查找的ID号</param>
/// <returns>返回值</returns>
public infos FindById_infos(int id)
{
infos model = new infos();
return(Common <infos> .Dt2Model(model, DbHelperSQL.FindByConditions(model, " " + Common <object> .GetModelInfo(model)[1] + "=" + id.ToString())));
}
/// <summary>
/// 更新记录
/// </summary>
/// <param name="infos">实体</param>
/// <returns>是否更新成功</returns>
public bool Update_infos(infos _infos)
{
return(_infosDao.Update_infos(_infos));
}
/// <summary>
/// 删除记录
/// </summary>
/// <param name="infos">实体</param>
/// <returns>是否删除成功</returns>
public bool Del_infos(infos _infos)
{
return(_infosDao.Del_infos(_infos));
}
/// <summary>
/// 添加新纪录
/// </summary>
/// <param name="infos">实体</param>
/// <returns>是否添加成功</returns>
public bool Add_infos(infos _infos)
{
return(_infosDao.Add_infos(_infos));
}
