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