// 注册
public int Reister(LandingModel reister)
{
string pwd = EncryptionHelper.Sha1(reister.Pwd);
string sql = $"insert into Landing values('{reister.Name}','{pwd}') ";
return(DapperHelper <ReisterModel> .Execute(sql, null));
}
/// <summary>
/// 通过Id查询单条信息，详情显示
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public List <HouseCollectModel> GetSecondHouseById(int id)
{
DapperHelper <HouseCollectModel> .Execute("update houseCollect set HouseNumber = HouseNumber+1 where Id=" + id, null);
return(DapperHelper <HouseCollectModel> .Query("select * from HouseCollect hc join HouseType ht on hc.HouseType = ht.TId where hc.Id = " + id, null));
}
//删除商家信息
public int DelCommodity(int id)
{
return(DapperHelper <CommodityModel> .Execute("delete from Commodity where Id=" + id, null));
}
//添加商家信息
public int AddCommodity(CommodityModel cdm)
{
return(DapperHelper <CommodityModel> .Execute($"insert into Commodity values('{cdm.CommodityName}','{cdm.CommodityPhone}','{cdm.CommoditySite}','{cdm.CommodityArgot}','{cdm.CommodityState}')", null));
}
//删除经纪人信息
public int DelPrincipal(int id)
{
return(DapperHelper <PrincipalModel> .Execute("delete from Principal where Id=" + id, null));
}
/// <summary>
/// 添加经纪人信息
/// </summary>
/// <param name="principalModel"></param>
/// <returns></returns>
public int AddPrincipal(PrincipalModel principalModel)
{
return(DapperHelper <PrincipalModel> .Execute($"insert into Principal values('{principalModel.PrincipalName}','{principalModel.PrincipalPhone}',{principalModel.CommodityId},'{principalModel.Enter}','{principalModel.PrImage}','{principalModel.Email}','{principalModel.QQ}','{principalModel.WeChat}')", null));
}
/// <summary>
/// 添加新房源
/// </summary>
/// <param name="house"></param>
/// <returns></returns>
public int AddNewH(HouseCollectModel house)
{
string sql = $"insert into HouseCollect values('{house.HouseName}','{house.HouseSite}','{house.HouseInfo}',{house.HouseType},{house.HouseGradation},{house.HouseSum},{house.HousePrice},{house.HouseArea},'Hxlimage/{house.HouseImage}','{house.HouseIntro}',{house.HouseModel},{house.HouseTenement},{house.HouseNumber})";
return(DapperHelper <HouseCollectModel> .Execute(sql, null));
}
/// <summary>
/// 删除新房源
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public int DelHouse(int id)
{
string sql = $"Delete from HouseCollect where Id={id}";
return(DapperHelper <HouseCollectModel> .Execute(sql, null));
}
/// <summary>
/// 添加房源
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int AddHouse(HouseCollectModel model)
{
string sql = $"insert into HouseCollect values('{model.HouseName}','{model.HouseSite}','{model.HouseInfo}',{model.HouseType},{model.HouseGradation},{model.HouseSum},{model.HousePrice},{model.HouseArea},'Wybimages/{model.HouseImage}','{model.HouseIntro}',{model.HouseModel},'{model.HouseTenement}/m²',{model.HouseNumber})";
return(DapperHelper <HouseCollectModel> .Execute(sql, null));
}
//添加客户信息
public int AddClientInfo(ClientInfoModel cm)
{
return(DapperHelper <ClientInfoModel> .Execute($"insert into ClientInfo values('{cm.ClientName}','{cm.ClientPhone}',{cm.ClientSex})", null));
}
//删除客户信息
public int DelClientInfo(int id)
{
return(DapperHelper <ClientInfoModel> .Execute("delete from ClientInfo where Id=" + id, null));
}
