// 注册 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)); }