public ModelResult AddHouse(HouseRequest request)
{
var houseEnt = new HouseEnt
{
AreaId = request.AreaID,
Community = request.Community,
Type = request.Type,
FloorType = request.FloorType,
Direction = request.Direction,
DecorateType = request.DecorateType,
Area = request.Area,
Age = request.Age,
CreateUserType = request.CreateUserType,
CreateUserID = request.CreateUserID,
CreateTime = request.CreateTime,
ContactMobile = request.ContactMobile,
Memo = request.Memo
};
houseEnt.ID = HouseRepository.AddHouse(houseEnt);
var housePriceEnt = new HousePriceEnt
{
HouseID = houseEnt.ID,
FirstPrice = request.FirstPrice,
TotalPrice = request.TotalPrice
};
HouseRepository.AddHousePrice(housePriceEnt);
var houseRoom = new HouseRoomEnt
{
HouseID = houseEnt.ID,
BathroomCount = request.BathroomCount,
BedroomCount = request.BedroomCount,
KitchenCount = request.KitchenCount,
LivingroomCount = request.LivingroomCount
};
HouseRepository.AddHouseRoom(houseRoom);
var houseImages = request.HouseImages.Select(x => new HouseImageEnt {
HouseID = houseEnt.ID, Image = x
}).ToList();
HouseRepository.AddHouseImage(houseImages);
return(new ModelResult {
Data = HouseRepository.QueryHouseByID(houseEnt.ID)
});
}
public static int AddHouse(HouseEnt houseEnt)
{
var sql = @"insert into house(AreaID,Community,Type,FloorType,Direction,DecorateType,Area,Age,CreateUserType,CreateUserID,CreateTime,ContactMobile,Memo)
values(@AreaID,@Community,@Type,@FloorType,@Direction,@DecorateType,@Area,@Age,@CreateUserType,@CreateUserID,@CreateTime,@ContactMobile,@Memo);
select @@IDENTITY;";
return(DBHelper.Conn.ExecuteScalar <int>(sql,
new
{
houseEnt.AreaId,
houseEnt.Community,
houseEnt.Type,
houseEnt.FloorType,
houseEnt.Direction,
houseEnt.DecorateType,
houseEnt.Area,
houseEnt.Age,
houseEnt.CreateUserType,
houseEnt.CreateUserID,
houseEnt.CreateTime,
houseEnt.ContactMobile,
houseEnt.Memo
}));
}
