/// <summary>
/// 修改报名信息
/// </summary>
/// <returns></returns>
public static async Task <bool> UpdateActivitiesUserAsync(ActivityUserInfo_xhrRequest request)
{
var sql = @"
UPDATE [Activity].[dbo].[T_ActivityUserInfo_xhr]
SET [UserName] = @UserName
,[UserTell] = @UserTell
,[AreaID] = @AreaID
,[PassStatus] = @PassStatus
,[EditTime]=GETDATE()
,[EditUser]='xhr'
WHERE [UserID] = @UserId
";
using (var cmd = new SqlCommand(sql))
{
cmd.AddParameter("@UserName", request.UserName);
cmd.AddParameter("@UserId", request.UserId);
cmd.AddParameter("@UserTell", request.UserTell);
cmd.AddParameter("@AreaID", request.AreaID);
cmd.AddParameter("@PassStatus", request.PassStatus);
var result = await DbHelper.ExecuteNonQueryAsync(cmd);
return(result > 0);
}
}
/// <summary>
/// 修改报名信息
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public static async Task <bool> UpdateActivitiesUserAsync(ActivityUserInfo_xhrRequest request)
{
try
{
return(await DalActivity.UpdateActivitiesUserAsync(request));
}
catch (Exception ex)
{
Logger.Error($"UpdateActivitiesUserAsync -> {JsonConvert.SerializeObject(request)}", ex);
throw ex;
}
}
/// <summary>
/// 活动报名
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public async Task <OperationResult <bool> > AddActivitiesUserAsync(ActivityUserInfo_xhrRequest request)
{
if (string.IsNullOrWhiteSpace(request.UserName))
{
return(OperationResult.FromError <bool>("-31", string.Format(Resource.ParameterError_IsRequired, "UserName")));
}
if (request.AreaID == 0)
{
return(OperationResult.FromError <bool>("-31", string.Format(Resource.ParameterError_IsRequired, "AreaID")));
}
var regex = new Regex("^1[0-9]{10}$");
if (string.IsNullOrWhiteSpace(request.UserTell) || !regex.IsMatch(request.UserTell))
{
return(OperationResult.FromError <bool>("-31", string.Format(Resource.ParameterError_NotConformityRule, "UserTell")));
}
return(OperationResult.FromResult <bool>(await ActivityManager.AddActivitiesUserAsync(request)));
}
/// <summary>
/// 活动报名
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public static async Task <bool> AddActivitiesUserAsync(ActivityUserInfo_xhrRequest request)
{
string sql = @"
INSERT INTO [Activity].[dbo].[T_ActivityUserInfo_xhr]
(
[UserName],
[UserTell],
[AreaID],
[PassStatus],
[ActID],
[CreateTime],
[CreateUser],
[UserStatus]
)
VALUES
( @UserName,
@UserTell,
@AreaID,
@PassStatus,
@ActID,
GETDATE(),
'xhr',
1
);SELECT SCOPE_IDENTITY();";
using (var cmd = new SqlCommand(sql))
{
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@UserName", request.UserName);
cmd.Parameters.AddWithValue("@UserTell", request.UserTell);
cmd.Parameters.AddWithValue("@AreaID", request.AreaID);
cmd.Parameters.AddWithValue("@PassStatus", 0);
cmd.Parameters.AddWithValue("@ActID", request.ActID);
return((await DbHelper.ExecuteNonQueryAsync(cmd)) > 0);
}
}
///<summary>修改报名信息</summary> public Task <OperationResult <bool> > UpdateActivitiesUserAsync(ActivityUserInfo_xhrRequest request) => InvokeAsync(_ => _.UpdateActivitiesUserAsync(request));
///<summary>修改报名信息</summary> public OperationResult <bool> UpdateActivitiesUser(ActivityUserInfo_xhrRequest request) => Invoke(_ => _.UpdateActivitiesUser(request));
