public long Add(AdPlaceConfigEntity model) { var description = "添加广告位配置"; try { var sql = @"INSERT INTO [dbo].[AdPlaceConfig]([ProductUserId],[Total],[Remain]) Values(@ProductUserId,@Total,@Remain);select @@Identity;"; var sqlParameter = new List <SqlParameter> { new SqlParameter("@ProductUserId", SqlDbType.BigInt) { Value = model.ProductUserId }, new SqlParameter("@Total", SqlDbType.Int) { Value = model.Total }, new SqlParameter("@Remain", SqlDbType.Int) { Value = model.Remain } }; RPoney.Log.LoggerManager.Debug(GetType().Name, $"{description}sql:{sql},参数:model{model.SerializeToJSON()}"); return(DataBaseManager.MainDb().ExecuteScalar(sql, sqlParameter.ToArray()).CLong(0, false)); } catch (Exception ex) { RPoney.Log.LoggerManager.Error(GetType().Name, $"{description}异常", ex); return(-1); } }
public AdPlaceConfigEntity GetOrInsert(long productUserId) { var adPlaceConfig = Get(productUserId); if (null != adPlaceConfig) { return(adPlaceConfig); } var initAdPlaceCoung = _systemDicBll.Value.Get(Model.PublicEnum.SystemDicEnum.InitAdPlaceCount.GetSettingKey())? .Value.CInt(0, false); adPlaceConfig = new AdPlaceConfigEntity() { ProductUserId = productUserId, Total = initAdPlaceCoung.GetValueOrDefault(), Remain = initAdPlaceCoung.GetValueOrDefault() }; adPlaceConfig.Id = Add(adPlaceConfig); if (adPlaceConfig.Id > 0) { return(adPlaceConfig); } return(null); }
public long Add(AdPlaceConfigEntity model) { return(_adPlaceConfigDal.Value.Add(model)); }