public async Task <ResultModel> Run(AcceptParam acceptParam, AppSetting appSetting, HttpContext context, long userId)
{
var req = acceptParam.AnalyzeParam <CreateArticleReq>();
if (req == null)
{
return(ResultModel.GetNullErrorModel(string.Empty));
}
string msg;
if ((msg = req.ValidInfo()) != string.Empty)
{
return(ResultModel.GetNullErrorModel(string.Empty, msg));
}
var createArticleParam = (CreateArticleParam)req;
createArticleParam.UserId = userId;
var mysqlConn = appSetting.GetMysqlConn();
var dbConnection = context.GetConnection(mysqlConn.FlagKey, mysqlConn.ConnStr);
var result =
await DapperTools.CreateItem(dbConnection, EntityTools.GetTableName <ArticleInfo>(), createArticleParam);
return(ResultModel.GetSuccessModel(string.Empty, result));
}
public async Task <ResultModel> Run(AcceptParam acceptParam, AppSetting appSetting, HttpContext context)
{
var createUserInfoDto = acceptParam.AnalyzeParam <CreateUserInfoReq>();
string msg;
if (createUserInfoDto == null)
{
return(ResultModel.GetNullErrorModel(string.Empty));
}
//设置默认显示名为登录名
createUserInfoDto.DisplayName = createUserInfoDto.UserName;
if ((msg = createUserInfoDto.ValidInfo()) != string.Empty)
{
return(ResultModel.GetParamErrorModel(string.Empty, msg));
}
var conn = appSetting.GetMysqlConn(context);
var userNameField = EntityTools.GetField <UserInfo>(nameof(UserInfo.UserName));
//查看用户名是否已存在
var isExists = await DapperTools.IsExists(conn, EntityTools.GetTableName <UserInfo>(), new List <string>()
{
$"{userNameField} = @{userNameField}"
}, new { createUserInfoDto.UserName });
if (isExists)
{
return(ResultModel.GetParamErrorModel(string.Empty, "用户名已存在！"));
}
// Predicates.Field<UserInfo>(u => u.Id > 0, Operator.Eq, true);
// Predicates.Exists<>()
var result = await DapperTools.CreateItem(conn, EntityTools.GetTableName <UserInfo>(), createUserInfoDto);
return(ResultModel.GetSuccessModel(string.Empty, result));
}
public async Task <ResultModel> Run(AcceptParam acceptParam, AppSetting appSetting, HttpContext context, long userId)
{
var req = acceptParam.AnalyzeParam <CreateArticleCommentReq>();
if (req == null)
{
return(ResultModel.GetNullErrorModel());
}
var msg = req.ValidInfo();
if (msg != string.Empty)
{
return(ResultModel.GetParamErrorModel(msg));
}
var param = (CreateCommentParam)req;
param.ActionUser = userId;
var conn = appSetting.GetMysqlConn(context);
var result = await DapperTools.CreateItem(conn, EntityTools.GetTableName <CommentInfo>(), param);
if (result > 0)
{
// var task = new BaseSendMsgDeal().Run(new SendMsgReq()
// {
// Content = "收到一条评论信息，请赶快查看吧~",
// MsgType = MsgTypeMenu.Comment,
// Receiver = req.JoinKey,
// Sender = userId
// }, appSetting, context);
}
return(ResultModel.GetSuccessModel(result));
}
public async Task <ResultModel> Run(AcceptParam acceptParam, AppSetting appSetting, HttpContext context, long userId)
{
var req = acceptParam.AnalyzeParam <AttentionUserReq>();
if (req == null)
{
return(ResultModel.GetNullErrorModel());
}
var msg = req.ValidInfo();
if (msg != string.Empty)
{
return(ResultModel.GetParamErrorModel(msg));
}
if (req.AttentionUser == userId)
{
return(ResultModel.GetParamErrorModel());
}
var conn = appSetting.GetMysqlConn(context);
AttentionInfo oldInfo = await DapperTools.GetItem <AttentionInfo>(conn, EntityTools.GetTableName <AttentionInfo>(),
new[]
{
$"{EntityTools.GetField<AttentionInfo>(nameof(AttentionInfo.AttentionUser))} ={req.AttentionUser}",
$"{EntityTools.GetField<AttentionInfo>(nameof(AttentionInfo.UserId))} ={userId}",
},
new[]
{
nameof(BaseModel.Id),
});
// var isExists = await DapperTools.IsExists(conn, EntityTools.GetTableName<AttentionInfo>(),
// new[]
// {
// $"{EntityTools.GetField<AttentionInfo>(nameof(AttentionInfo.AttentionUser))} ={req.AttentionUser}",
// $"{EntityTools.GetField<AttentionInfo>(nameof(AttentionInfo.UserId))} ={userId}",
// });
if (oldInfo == null)
{
var param = (CreateAttentionParam)req;
param.UserId = userId;
var result = await DapperTools.CreateItem(conn, EntityTools.GetTableName <AttentionInfo>(), param);
return(ResultModel.GetSuccessModel(result));
}
else
{
var editParam = new
{
UpdateTime = DateTime.Now,
ValidFlag = (int)ValidFlagMenu.UseFul,
req.Description,
req.GroupKey,
};
var setFieldList = new List <string>();
setFieldList.Add(nameof(BaseModel.UpdateTime));
setFieldList.Add(nameof(BaseModel.ValidFlag));
var result = await DapperTools.Edit(conn, EntityTools.GetTableName <AttentionInfo>(), new[]
{
$"{nameof(BaseModel.Id)}={oldInfo.Id}"
}, null, editParam);
return(ResultModel.GetSuccessModel(result));
}
}
public async Task <ResultModel> Run(AcceptParam acceptParam, AppSetting appSetting, HttpContext context, long userId)
{
var req = acceptParam.AnalyzeParam <SingleActionArticleReq>();
if (req == null)
{
return(ResultModel.GetNullErrorModel());
}
string msg;
if ((msg = req.ValidInfo()) != string.Empty)
{
return(ResultModel.GetParamErrorModel(msg));
}
if (Enum.TryParse(req.ActionKey, true, out ArticleOptMenu opt))
{
var conn = appSetting.GetMysqlConn(context);
var info = await DapperTools.GetItem <ArticleOptInfo>(conn, EntityTools.GetTableName <ArticleOptInfo>(),
new List <string>()
{
$"{EntityTools.GetField<ArticleOptInfo>(nameof(ArticleOptInfo.OptionType))} = {(int) opt}",
$"{EntityTools.GetField<ArticleOptInfo>(nameof(ArticleOptInfo.RelationKey))} = {req.ArticleId}",
$"{EntityTools.GetField<ArticleOptInfo>(nameof(ArticleOptInfo.ActionUser))} = {userId}",
}, new[]
{
nameof(BaseModel.Id),
nameof(BaseModel.ValidFlag)
}, null);
// var validFlag = await DapperTools.SelectSingle<int?>(conn, EntityTools.GetTableName<ArticleOptInfo>(),
// new List<string>()
// {
// $"{nameof(BaseModel.Id)} = {req.ArticleId}",
// $"{EntityTools.GetField<ArticleOptInfo>(nameof(ArticleOptInfo.OptionType))} = {(int) opt}",
// $"{EntityTools.GetField<ArticleOptInfo>(nameof(ArticleOptInfo.RelationKey))} = {req.ArticleId}",
// }, nameof(BaseModel.ValidFlag));
if (info != null)
{
EditValidFlagParam param = new EditValidFlagParam()
{
Id = info.Id,
UpdateTime = DateTime.Now
};
if (info.ValidFlag == (int)ValidFlagMenu.UnUseFul)
{
param.ValidFlag = ValidFlagMenu.UseFul;
}
else
{
param.ValidFlag = ValidFlagMenu.UnUseFul;
}
var result = await DapperTools.Edit(conn, EntityTools.GetTableName <ArticleOptInfo>(), new[]
{
$"{nameof(BaseModel.Id)} = {info.Id}",
$"{EntityTools.GetField<ArticleOptInfo>(nameof(ArticleOptInfo.ActionUser))} = {userId}",
}, null, param);
return(ResultModel.GetSuccessModel(null, $"修改成功-{result}"));
}
else
{
var param = new CreateArticleOptInfoParam()
{
ActionKey = opt.ToString(),
Count = 1,
OptionType = (int)opt,
RelationKey = req.ArticleId,
ActionUser = userId
};
var result = await DapperTools.CreateItem(conn, EntityTools.GetTableName <ArticleOptInfo>(), param);
return(ResultModel.GetSuccessModel(null, $"添加成功-{result}"));
}
// return ResultModel.GetSuccessModel(validFlag);
// if (await DapperTools.IsExists(conn, EntityTools.GetTableName<ArticleOptInfo>(), new List<string>()
// {
// $"{nameof(BaseModel.Id)} = {req.ArticleId}",
// $"{EntityTools.GetField<ArticleOptInfo>(nameof(ArticleOptInfo.OptionType))} = {(int)opt}",
// $"{EntityTools.GetField<ArticleOptInfo>(nameof(ArticleOptInfo.RelationKey))} = {req.ArticleId}",
// }))
// {
// return ResultModel.GetDealErrorModel("请勿重复操作！");
// }
// else
// {
//
// var param = new CreateArticleOptInfoParam()
// {
// ActionKey = opt.ToString(),
// Count = 1,
// OptionType = (int) opt,
// RelationKey = req.ArticleId
// };
//
// var result = await DapperTools.CreateItem(conn, EntityTools.GetTableName<ArticleOptInfo>(), param);
//
// return ResultModel.GetSuccessModel(result);
//
// }
}
else
{
return(ResultModel.GetDealErrorModel($"操作<{req.ActionKey}>不存在！"));
}
}
