public AddGymDetailResponse AddGymDetail(AddGymDetailRequest request)
{
var result = base.CreateResponse <AddGymDetailResponse>("新建场馆");
try
{
using (var con = new DbConnectionProvider(dbName).GetOpenConnection())
{
var parms = new DynamicParameters();
parms.Add("P_CityID", request.GymDetail.CityID, DbType.Int32);
parms.Add("P_DistrictID", request.GymDetail.DistrictID, DbType.Int32);
parms.Add("P_GymName", request.GymDetail.GymName, DbType.String);
parms.Add("P_GymAddress", request.GymDetail.GymAddress, DbType.String);
parms.Add("P_GymDesc", request.GymDetail.GymDesc, DbType.String);
parms.Add("P_Phone", request.GymDetail.Phone, DbType.String);
parms.Add("P_Longitude", request.GymDetail.Longitude, DbType.Decimal);
parms.Add("P_Latitude", request.GymDetail.Latitude, DbType.Decimal);
parms.Add("P_StarLevel", request.GymDetail.StarLevel, DbType.SByte);
parms.Add("P_Photos_Json", request.GymDetail.Photos != null && request.GymDetail.Photos.Count > 0 ? JsonConvert.SerializeObject(request.GymDetail.Photos) : string.Empty
, DbType.String);
result.GymID = con.ExecuteScalar <int>("sp_AddGymDetail"
, parms
, CommandType.StoredProcedure);
}
}
catch (Exception ex)
{
base.HandleResponseException(ref result, ex);
}
return(result);
}
public AddGymDetailResponse AddGymDetail(AddGymDetailRequest request)
{
return(BasicDataManager.GetInstance().AddGymDetail(request));
}
