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