public JsonResult UpdateActivity(T_Activity_xhrModel model) { string managerId = this.Request.Headers["Authorization"];//Header中的token var result = ActivityManager.UpdateActivity(model, managerId); return(Json(result, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 修改活动信息 /// </summary> /// <param name="request"></param> /// <returns></returns> public static async Task <bool> UpdateActivityAsync(T_Activity_xhrModel request) { string sql = @" UPDATE [Activity].[dbo].[T_Activity_xhr] SET [Title] = @Title ,[ActivityContent]=@ActivityContent ,[StartTime]=@StartTime ,[EndTime]=@EndTime ,[Picture]=@Picture ,[ActStatus]=@ActStatus ,[EditTime]=GETDATE() ,[EditUser]='xhr' WHERE [ActivityID] = @ActivityID;" ; using (var cmd = new SqlCommand(sql)) { cmd.CommandType = CommandType.Text; cmd.Parameters.AddWithValue("@Title", request.Title); cmd.Parameters.AddWithValue("@ActivityContent", request.ActivityContent); cmd.Parameters.AddWithValue("@StartTime", request.StartTime); cmd.Parameters.AddWithValue("@EndTime", request.EndTime); cmd.Parameters.AddWithValue("@Picture", request.Picture); cmd.Parameters.AddWithValue("@ActStatus", request.ActStatus); cmd.Parameters.AddWithValue("@ActivityID", request.ActivityId); return((await DbHelper.ExecuteNonQueryAsync(cmd)) > 0); } }
/// <summary> /// 修改活动信息 /// </summary> /// <param name="request"></param> /// <returns></returns> public static async Task <bool> UpdateActivityAsync(T_Activity_xhrModel request) { using (var hashClient = CacheHelper.CreateHashClient("GetAllActivity")) { try { var result = await DalActivity.UpdateActivityAsync(request); hashClient.RemoveSelf(); return(result); } catch (Exception ex) { Logger.Error($"UpdateActivityAsync -> {JsonConvert.SerializeObject(request)}", ex); throw ex; } } }
/// <summary> /// 修改活动信息 /// </summary> /// <param name="request"></param> /// <returns></returns> public async Task <OperationResult <bool> > UpdateActivityAsync(T_Activity_xhrModel request) { if (string.IsNullOrWhiteSpace(request.Title)) { return(OperationResult.FromError <bool>("-31", string.Format(Resource.ParameterError_IsRequired, "标题"))); } if (string.IsNullOrWhiteSpace(request.ActivityContent)) { return(OperationResult.FromError <bool>("-31", string.Format(Resource.ParameterError_IsRequired, "内容"))); } if (request.StartTime >= request.EndTime || request.StartTime == DateTime.MinValue || request.EndTime == DateTime.MinValue) { return(OperationResult.FromError <bool>("-31", "时间参数错误")); } if (string.IsNullOrWhiteSpace(request.Picture)) { return(OperationResult.FromError <bool>("-31", string.Format(Resource.ParameterError_IsRequired, "图片地址"))); } return(OperationResult.FromResult <bool>(await ActivityManager.UpdateActivityAsync(request))); }
/// <summary> /// 新增活动 /// </summary> /// <param name="request"></param> /// <returns></returns> public static async Task <bool> AddActivityAsync(T_Activity_xhrModel request) { string sql = @" INSERT INTO Activity.dbo.T_Activity_xhr ( [Title], [ActivityContent], [StartTime], [EndTime], [Picture], [CreateTime], [CreateUser], [ActStatus] ) VALUES ( @Title, @ActivityContent, @StartTime, @EndTime, @Picture, GETDATE(), 'xhr', 1 );"; using (var cmd = new SqlCommand(sql)) { cmd.CommandType = CommandType.Text; cmd.Parameters.AddWithValue("@Title", request.Title); cmd.Parameters.AddWithValue("@ActivityContent", request.ActivityContent); cmd.Parameters.AddWithValue("@StartTime", request.StartTime); cmd.Parameters.AddWithValue("@EndTime", request.EndTime); cmd.Parameters.AddWithValue("@Picture", request.Picture); return((await DbHelper.ExecuteNonQueryAsync(cmd)) > 0); } }
///<summary>修改活动信息</summary> public Task <OperationResult <bool> > UpdateActivityAsync(T_Activity_xhrModel request) => InvokeAsync(_ => _.UpdateActivityAsync(request));
///<summary>修改活动信息</summary> public OperationResult <bool> UpdateActivity(T_Activity_xhrModel request) => Invoke(_ => _.UpdateActivity(request));
/// <summary> /// 修改活动 /// </summary> /// <returns></returns> public Reseponse <bool> UpdateActivity(T_Activity_xhrModel model, string managerId) { var result = new Reseponse <bool>(); if (string.IsNullOrWhiteSpace(model.Title)) { result.status = 0; result.Message = "标题不能为空!"; return(result); } if (string.IsNullOrWhiteSpace(model.ActivityContent)) { result.status = 0; result.Message = "内容不能为空!"; return(result); } if (string.IsNullOrWhiteSpace(model.StartTime)) { result.status = 0; result.Message = "开始时间不能为空!"; return(result); } if (string.IsNullOrWhiteSpace(model.EndTime)) { result.status = 0; result.Message = "结束时间不能为空!"; return(result); } if (string.IsNullOrWhiteSpace(model.Picture)) { result.status = 0; result.Message = "图片地址不能为空!"; return(result); } if (model.ActStatus < 0) { result.status = 0; result.Message = "请选择正确的活动状态!"; return(result); } if (string.IsNullOrWhiteSpace(managerId)) { result.status = 0; result.Message = "请先登录!"; return(result); } int userid = int.Parse(TuhuCryption.Decrypt(managerId)); DateTimeFormatInfo dtFormat = new DateTimeFormatInfo(); dtFormat.ShortDatePattern = "yyyy-MM-dd"; try { using (var client = new ActivityClient()) { var checkresult = client.CheckLoginAsync(userid); if (!checkresult.Result.Success) { result.status = 0; result.Message = "请先登录!"; return(result); } var request = new Tuhu.Service.Activity.Models.T_Activity_xhrModel() { Title = model.Title, ActivityContent = model.ActivityContent, StartTime = Convert.ToDateTime(model.StartTime, dtFormat), EndTime = Convert.ToDateTime(model.EndTime, dtFormat), Picture = model.Picture, ActStatus = model.ActStatus, ActivityId = model.ActivityID }; var addresult = client.UpdateActivityAsync(request); result.status = addresult.Result.Success ? 1 : 0; result.Message = addresult.Result.ErrorMessage; result.data = addresult.Result.Success; } } catch (Exception e) { Logger.Error($"UpdateActivity -> {JsonConvert.SerializeObject(model)}", e); throw; } return(result); }