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