/// <summary>
/// 创建活动页
/// </summary>
/// <param name="conn"></param>
/// <param name="model"></param>
/// <returns></returns>
public static bool CreateActivityUrl(SqlConnection conn, RegionVehicleIdActivityUrlConfig model)
{
var sql = @"INSERT INTO Configuration..RegionVehicleIdActivityUrlConfig
( ActivityId ,
TargetUrl ,
WxappUrl ,
IsDefault ,
VehicleId ,
RegionId ,
CreateDateTime ,
LastUpdateDateTime
)
VALUES ( @ActivityId ,
@TargetUrl,
@WxappUrl ,
@IsDefault,
@VehicleId,
@RegionId,
GETDATE(),
GETDATE()
);";
var parameters = new SqlParameter[]
{
new SqlParameter("@ActivityId", model.ActivityId),
new SqlParameter("@TargetUrl", model.TargetUrl ?? string.Empty),
new SqlParameter("@WxappUrl", model.WxappUrl),
new SqlParameter("@IsDefault", model.IsDefault),
new SqlParameter("@VehicleId", model.VehicleId),
new SqlParameter("@RegionId", model.RegionId)
};
var count = SqlHelper.ExecuteNonQuery(conn, CommandType.Text, sql, parameters);
return(count > 0);
}
public ActionResult UpdateActivityUrl(RegionVehicleIdActivityUrlConfig model, string h5OldUrl, string wxOldUrl, string vehicleIds, string regionIds)
{
if (model == null || model.ActivityId == Guid.Empty)
{
return(Json(new { Status = false, Msg = "未知的更新对象" }));
}
if (string.IsNullOrWhiteSpace(model.TargetUrl) && string.IsNullOrWhiteSpace(model.WxappUrl))
{
return(Json(new { Status = false, Msg = "活动页面地址不能全为空" }));
}
if (model.IsDefault != 0 && model.IsDefault != 1)
{
return(Json(new { Status = false, Msg = "是否默认页面字段出错" }));
}
if (model.IsDefault != 1 && string.IsNullOrWhiteSpace(vehicleIds) && string.IsNullOrWhiteSpace(regionIds))
{
return(Json(new { Status = false, Msg = "车型或地区不能为空" }));
}
if (string.IsNullOrWhiteSpace(h5OldUrl) && string.IsNullOrWhiteSpace(wxOldUrl))
{
return(Json(new { Status = false, Msg = "原有活动页链接为空" }));
}
if (!string.IsNullOrWhiteSpace(model.TargetUrl) && !string.Equals(h5OldUrl, model.TargetUrl))
{
var isExist = cityActivityConfig.IsExistActivityTargetUrl(model.ActivityId, model.TargetUrl);
if (isExist)
{
return(Json(new { Status = false, Msg = "已存在该H5活动页" }));
}
}
if (!string.IsNullOrWhiteSpace(model.WxappUrl) && !string.Equals(wxOldUrl, model.WxappUrl))
{
var isExist = cityActivityConfig.IsExistActivityWxappUrl(model.ActivityId, model.WxappUrl);
if (isExist)
{
return(Json(new { Status = false, Msg = "已存在该小程序活动页" }));
}
}
var user = User.Identity.Name;
var result = cityActivityConfig.UpdateActivityUrl(model, h5OldUrl, wxOldUrl, vehicleIds, regionIds);
if (result)
{
int id = cityActivityConfig.GetActivityPKIDByActivityId(model.ActivityId);
var AfterValue = $"H5活动页地址:{h5OldUrl}改为{model.TargetUrl}" +
$",小程序活动页地址:{wxOldUrl}改为{model.WxappUrl}" +
$",是否默认页面:{model.IsDefault},车型ID:{vehicleIds},城市ID:{regionIds}";//适配日志重构
var log = new ConfigHistory()
{
AfterValue = AfterValue,
Author = user,
Operation = $"{model.ActivityId.ToString()}更新活动页",
ObjectType = "CVPage",
ObjectID = id.ToString()
};
LoggerManager.InsertOplog(log);
}
return(Json(new { Status = result, Msg = $"活动页更新{(result ? "成功" : "失败")}" }));
}
/// <summary>
/// 创建活动页
/// </summary>
/// <param name="model"></param>
/// <param name="vehicleIds"></param>
/// <param name="regionIds"></param>
/// <returns></returns>
public bool CreateActivityUrl(RegionVehicleIdActivityUrlConfig model, string vehicleIds, string regionIds)
{
var result = false;
try
{
result = ConfigurationDb.Execute(conn => CreateActivityUrlConfig(conn, model, vehicleIds, regionIds));
}
catch (Exception ex)
{
result = false;
Logger.Error("CreateActivityUrl", ex);
}
return(result);
}
public ActionResult CreateActivityUrl(RegionVehicleIdActivityUrlConfig model, string vehicleIds, string regionIds)
{
if (model == null || model.ActivityId == Guid.Empty)
{
return(Json(new { Status = false, Msg = "未知的创建对象" }));
}
if (string.IsNullOrWhiteSpace(model.TargetUrl) && string.IsNullOrWhiteSpace(model.WxappUrl))
{
return(Json(new { Status = false, Msg = "活动页面地址不能全为空" }));
}
if (model.IsDefault != 0 && model.IsDefault != 1)
{
return(Json(new { Status = false, Msg = "是否默认页面字段出错" }));
}
if (model.IsDefault != 1 && string.IsNullOrWhiteSpace(vehicleIds) && string.IsNullOrWhiteSpace(regionIds))
{
return(Json(new { Status = false, Msg = "车型或地区不能为空" }));
}
if (!string.IsNullOrWhiteSpace(model.TargetUrl) && cityActivityConfig.IsExistActivityTargetUrl(model.ActivityId, model.TargetUrl))
{
return(Json(new { Status = false, Msg = "该H5活动页已存在，请勿重复添加" }));
}
if (!string.IsNullOrWhiteSpace(model.WxappUrl) && cityActivityConfig.IsExistActivityWxappUrl(model.ActivityId, model.WxappUrl))
{
return(Json(new { Status = false, Msg = "该小程序活动页已存在，请勿重复添加" }));
}
var result = cityActivityConfig.CreateActivityUrl(model, vehicleIds, regionIds);
if (result)
{
int id = cityActivityConfig.GetActivityPKIDByActivityId(model.ActivityId);//适配日志重构
var AfterValue = $"H5活动页地址:{model.TargetUrl}" +
$",小程序活动页地址:{model.WxappUrl}" +
$",是否默认页面:{model.IsDefault},车型ID:{vehicleIds},城市ID:{regionIds}";
var log = new ConfigHistory()
{
AfterValue = AfterValue,
Author = User.Identity.Name,
Operation = $"{model.ActivityId}新增活动页",
ObjectType = "CVPage",
ObjectID = id.ToString()
};
LoggerManager.InsertOplog(log);
}
return(Json(new { Status = result, Msg = $"活动页添加{(result ? "成功" : "失败")}" }));
}
/// <summary>
/// 更新活动页配置
/// </summary>
/// <param name="model"></param>
/// <param name="oldTargetUrl"></param>
/// <param name="oldWxappUrl"></param>
/// <param name="vehicleIds"></param>
/// <param name="regionIds"></param>
/// <returns></returns>
public bool UpdateActivityUrl(RegionVehicleIdActivityUrlConfig model, string oldTargetUrl, string oldWxappUrl, string vehicleIds, string regionIds)
{
bool result = false;
try
{
ConfigurationDb.CreateTransaction(conn =>
{
if (!DalCityActivityPageConfig.DeleteActivityUrlByActivityIdUrl(conn, model.ActivityId, oldTargetUrl, oldWxappUrl))
{
result = false;
}
else
{
result = CreateActivityUrlConfig(conn, model, vehicleIds, regionIds);
}
});
}
catch (Exception ex)
{
Logger.Error("UpdateActivityUrl", ex);
}
return(result);
}
/// <summary>
/// 创建活动页
/// </summary>
/// <param name="activityId"></param>
/// <param name="targetUrl"></param>
/// <param name="isDefault"></param>
/// <param name="vehicleIds"></param>
/// <param name="regionIds"></param>
/// <returns></returns>
private bool CreateActivityUrlConfig(SqlConnection conn, RegionVehicleIdActivityUrlConfig model, string vehicleIds, string regionIds)
{
var result = false;
var vehicleIdArr = vehicleIds.Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries).Distinct().ToList();
var regionIdArr = regionIds.Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries).Distinct().ToList();
//默认页面
if (model.IsDefault == 1 || !(vehicleIdArr.Any() || regionIdArr.Any()))
{
result = DalCityActivityPageConfig.CreateActivityUrl(conn, model);
if (!result)
{
throw new Exception($"CreateActivityUrl失败,插入失败数据{JsonConvert.SerializeObject(model)}");
}
}
else
{
var models = new List <RegionVehicleIdActivityUrlConfig>();
foreach (var vehicleId in vehicleIdArr)
{
var config = new RegionVehicleIdActivityUrlConfig()
{
ActivityId = model.ActivityId,
TargetUrl = model.TargetUrl,
WxappUrl = model.WxappUrl,
IsDefault = model.IsDefault,
VehicleId = vehicleId,
RegionId = 0,
};
models.Add(config);
}
foreach (var regionIdStr in regionIdArr)
{
var regionId = 0;
if (int.TryParse(regionIdStr, out regionId))
{
var config = new RegionVehicleIdActivityUrlConfig()
{
ActivityId = model.ActivityId,
TargetUrl = model.TargetUrl,
WxappUrl = model.WxappUrl,
IsDefault = model.IsDefault,
VehicleId = string.Empty,
RegionId = regionId
};
models.Add(config);
}
}
if (models.Any())
{
foreach (var urlConfig in models)
{
var isCreated = DalCityActivityPageConfig.CreateActivityUrl(conn, urlConfig);
if (!isCreated)
{
throw new Exception($"CreateActivityUrlConfig失败,插入失败数据{JsonConvert.SerializeObject(urlConfig)}");
}
}
result = true;
}
}
return(result);
}
