public static int AddHousePrice(HousePriceEnt priceEnt) { var sql = @"insert into houseprice(HouseID,TotalPrice,FirstPrice) values(@HouseID,@TotalPrice,@FirstPrice);"; return(DBHelper.Conn.Execute(sql, new { HouseID = priceEnt.HouseID, TotalPrice = priceEnt.TotalPrice, FirstPrice = priceEnt.FirstPrice })); }
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) }); }