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)); }