/// <summary>
/// 插入限购配置
/// </summary>
/// <param name="config"></param>
/// <returns></returns>
public bool InsertBankMRActivityLimitConfig(BankMRActivityLimitConfig config, string operateUser)
{
bool result = false;
try
{
TuhuGrouponDbScopeManager.Execute(conn => result = BankMRActivityDal.InsertBankMRActivityLimitConfig(conn, config));
UpdateBankMRActivityRoundLimitCount(config.ActivityId, config.RoundLimit);
var log = new BeautyOprLog
{
LogType = "InsertBankMRActivityLimitConfig",
IdentityID = config.ActivityId.ToString(),
OldValue = null,
NewValue = JsonConvert.SerializeObject(config),
Remarks = $"插入银行美容限购配置,活动ID：{config.ActivityId}",
OperateUser = operateUser,
};
LoggerManager.InsertLog("BeautyOprLog", log);
}
catch (Exception ex)
{
Logger.Error(ex.Message, ex);
};
return(result);
}
public ActionResult UpsertBankMRActivityLimitConfig(BankMRActivityLimitConfig config)
{
var result = false;
if (config != null)
{
var operateUser = HttpContext.User.Identity.Name;
if (config.PKID > 0)
{
result = manager.UpdateBankMRActivityLimitConfig(config, operateUser);
}
else
{
result = manager.InsertBankMRActivityLimitConfig(config, operateUser);
}
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 更新限购配置
/// </summary>
/// <param name="config"></param>
/// <returns></returns>
public static bool UpdateBankMRActivityLimitConfig(SqlConnection conn, BankMRActivityLimitConfig config)
{
var sql = @"UPDATE Tuhu_groupon..BankMRActivityLimitConfig
SET DaysOfMonth = @DaysOfMonth ,
DaysOfWeek = @DaysOfWeek ,
DayLimit = @DayLimit ,
ProvinceIds = @ProvinceIds ,
CityIds = @CityIds ,
UpdateTime = GETDATE()
WHERE ActivityId = @ActivityId;";
var sqlParameters = new SqlParameter[]
{
new SqlParameter("@ActivityId", config.ActivityId),
new SqlParameter("@DaysOfMonth", config.DaysOfMonth),
new SqlParameter("@DaysOfWeek", config.DaysOfWeek),
new SqlParameter("@DayLimit", config.DayLimit),
new SqlParameter("@ProvinceIds", config.ProvinceIds),
new SqlParameter("@CityIds", config.CityIds)
};
return(SqlHelper.ExecuteNonQuery(conn, CommandType.Text, sql, sqlParameters) > 0);
}
/// <summary>
/// 插入限购配置
/// </summary>
/// <param name="config"></param>
/// <returns></returns>
public static bool InsertBankMRActivityLimitConfig(SqlConnection conn, BankMRActivityLimitConfig config)
{
var sql = @"INSERT INTO Tuhu_groupon..BankMRActivityLimitConfig
( ActivityId ,
DaysOfMonth ,
DaysOfWeek ,
DayLimit ,
ProvinceIds ,
CityIds ,
CardLimitType ,
CardLimitValue ,
StartTime
)
VALUES ( @ActivityId ,
@DaysOfMonth ,
@DaysOfWeek ,
@DayLimit ,
@ProvinceIds ,
@CityIds ,
@CardLimitType ,
@CardLimitValue ,
@StartTime
);";
var sqlParameters = new SqlParameter[]
{
new SqlParameter("@ActivityId", config.ActivityId),
new SqlParameter("@DaysOfMonth", config.DaysOfMonth),
new SqlParameter("@DaysOfWeek", config.DaysOfWeek),
new SqlParameter("@DayLimit", config.DayLimit),
new SqlParameter("@ProvinceIds", config.ProvinceIds),
new SqlParameter("@CityIds", config.CityIds),
new SqlParameter("@CardLimitType", config.CardLimitType),
new SqlParameter("@CardLimitValue", config.CardLimitValue),
new SqlParameter("@StartTime", config.StartTime)
};
return(SqlHelper.ExecuteNonQuery(conn, CommandType.Text, sql, sqlParameters) > 0);
}
/// <summary>
/// 获取限购配置
/// </summary>
/// <param name="activityId"></param>
/// <returns></returns>
public BankMRActivityLimitConfig FetchBankMRActivityLimitConfig(Guid activityId)
{
BankMRActivityLimitConfig result = null;
try
{
TuhuGrouponDbScopeManagerReadOnly.Execute(conn => result = BankMRActivityDal.FetchBankMRActivityLimitConfig(conn, activityId));
var roundConfig = GetBankMRActivityRoundConfigsByActivityId(activityId);
if (roundConfig != null)
{
if (result == null)
{
result = new BankMRActivityLimitConfig();
}
result.RoundLimit = roundConfig.FirstOrDefault()?.LimitCount ?? 0;
}
}
catch (Exception ex)
{
Logger.Error(ex.Message, ex);
};
return(result);
}
