public ActionResult TiresActivityInfo(Guid?activityId)
{
var result = new TiresActivityModel();
ViewBag.ActivityId = activityId ?? Guid.Empty;
if (activityId != null && activityId.Value != Guid.Empty)
{
result = manager.SelectTiresActivity("", null, null, activityId, 1, 20).FirstOrDefault();
}
return(View(result));
}
public static int UpdateTiresActivityConfig(SqlConnection conn, TiresActivityModel data, string user)
{
const string sql = @"
UPDATE Configuration..TiresActivityConfig
SET WXUrl = @WXUrl ,
AppUrl = @AppUrl ,
ShareImg = @ShareImg ,
ShareTitle = @ShareTitle ,
ShareDes = @ShareDes ,
ActivityName = @ActivityName ,
IsAdaptationVehicle = @IsAdaptationVehicle ,
IsShowInstallmentPrice = @IsShowInstallmentPrice ,
StartTime = @StartTime ,
EndTime = @EndTime ,
ActivityRules = @ActivityRules ,
ActivityRulesImg = @ActivityRulesImg ,
HeadImg = @HeadImg ,
NoAdaptationImg = @NoAdaptationImg ,
BackgroundColor = @BackgroundColor ,
Owner = @Owner ,
LastUpdateDateTime = GETDATE(),
UpdateUser = @UpdateUser
WHERE ActivityId = @ActivityId;";
return(conn.Execute(sql, new
{
ActivityId = data.ActivityId,
ActivityName = data.ActivityName,
WXUrl = data.WXUrl,
AppUrl = data.AppUrl,
ShareImg = data.ShareImg,
ShareTitle = data.ShareTitle,
ShareDes = data.ShareDes,
IsAdaptationVehicle = data.IsAdaptationVehicle,
IsShowInstallmentPrice = data.IsShowInstallmentPrice,
ActivityRules = data.ActivityRules,
ActivityRulesImg = data.ActivityRulesImg,
HeadImg = data.HeadImg,
NoAdaptationImg = data.NoAdaptationImg,
BackgroundColor = data.BackgroundColor,
Owner = data.Owner,
StartTime = data.StartTime,
EndTime = data.EndTime,
UpdateUser = user
}, commandType: CommandType.Text));
}
public bool UpserTiresActivity(TiresActivityModel data, string user)
{
var result = false;
var msg = string.Empty;
var isAdd = false;
try
{
dbScopeManager.Execute(conn =>
{
if (data == null || data.ActivityId == Guid.Empty)
{
isAdd = true;
msg = "增加轮胎活动";
data.ActivityId = Guid.NewGuid();
result = DALTiresActivity.InsertTiresActivityConfig(conn, data, user) > 0;
}
else
{
msg = "修改轮胎活动";
result = DALTiresActivity.UpdateTiresActivityConfig(conn, data, user) > 0;
}
});
}
catch (Exception ex)
{
logger.Error(ex);
}
if (result)
{
InsertLog("UpserTiresActivity", data.ActivityId, JsonConvert.SerializeObject(data), msg, user, LogType);
if (isAdd)
{
CallCRMService.NewAddActivity(data.ActivityName, data.StartTime.GetValueOrDefault(), data.EndTime.GetValueOrDefault(), "", data.ActivityRules, data.ActivityId.ToString(), CRMSourceType.TiresActivityTwo, user);
}
else
{
CallCRMService.NewUpdateActivity(data.ActivityName, data.StartTime.GetValueOrDefault(), data.EndTime.GetValueOrDefault(), "", data.ActivityRules, data.ActivityId.ToString(), CRMSourceType.TiresActivityTwo, user);
}
}
return(result);
}
public static int InsertTiresActivityConfig(SqlConnection conn, TiresActivityModel data, string user)
{
const string sql = @"INSERT INTO Configuration..TiresActivityConfig
( ActivityId ,
ActivityName ,
WXUrl ,
AppUrl ,
ShareImg ,
ShareTitle ,
ShareDes ,
IsAdaptationVehicle ,
IsShowInstallmentPrice ,
StartTime ,
EndTime ,
ActivityRules ,
ActivityRulesImg ,
HeadImg ,
NoAdaptationImg ,
BackgroundColor ,
Owner ,
CreateDateTime ,
CreateUser
)
VALUES ( @ActivityId ,
@ActivityName ,
@WXUrl ,
@AppUrl ,
@ShareImg ,
@ShareTitle ,
@ShareDes ,
@IsAdaptationVehicle ,
@IsShowInstallmentPrice ,
@StartTime ,
@EndTime ,
@ActivityRules ,
@ActivityRulesImg ,
@HeadImg ,
@NoAdaptationImg ,
@BackgroundColor ,
@Owner ,
GETDATE() ,
@CreateUser
)";
return(conn.Execute(sql, new
{
ActivityId = data.ActivityId,
ActivityName = data.ActivityName,
WXUrl = data.WXUrl,
AppUrl = data.AppUrl,
ShareImg = data.ShareImg,
ShareTitle = data.ShareTitle,
ShareDes = data.ShareDes,
IsAdaptationVehicle = data.IsAdaptationVehicle,
IsShowInstallmentPrice = data.IsShowInstallmentPrice,
StartTime = data.StartTime,
ActivityRules = data.ActivityRules,
ActivityRulesImg = data.ActivityRulesImg,
HeadImg = data.HeadImg,
NoAdaptationImg = data.NoAdaptationImg,
BackgroundColor = data.BackgroundColor,
Owner = data.Owner,
EndTime = data.EndTime,
CreateUser = user
}, commandType: CommandType.Text));
}
