public APIReturn Post_insert([FromForm] ulong?Last_posts_id, [FromForm] ulong?Owner_users_id, [FromForm] int?Count_posts, [FromForm] uint?Count_views, [FromForm] string Title, [FromForm] ulong?Top, [FromForm] uint[] mn_Tags, [FromForm] ulong[] mn_Users)
{
TopicsInfo item = new TopicsInfo();
item.Last_posts_id = Last_posts_id;
item.Owner_users_id = Owner_users_id;
item.Count_posts = Count_posts;
item.Count_views = Count_views;
item.Create_time = DateTime.Now;
item.Title = Title;
item.Top = Top;
item.Update_time = DateTime.Now;
item = Topics.Insert(item);
//关联 Tags
foreach (uint mn_Tags_in in mn_Tags)
{
item.FlagTags(mn_Tags_in);
}
//关联 Users
foreach (ulong mn_Users_in in mn_Users)
{
item.FlagUsers(mn_Users_in);
}
return(new APIReturn(0, "成功", "item", item.ToBson()));
}
public IActionResult 发布话题([FromForm] string tab, [FromForm] string title, [FromForm] string t_content, [FromForm] uint[] topic_tags, [FromForm] string _csrf)
{
SqlHelper.Transaction(() => {
TopicsInfo topic = Topics.Insert(new TopicsInfo {
Title = title,
Count_posts = 0,
Count_views = 0,
Create_time = DateTime.Now,
Owner_users_id = LoginUser.Id,
Top = 0
});
PostsInfo post = Posts.Insert(new PostsInfo {
Content = t_content,
Count_good = 0,
Count_notgood = 0,
Create_time = DateTime.Now,
Topics_id = topic.Id,
Users_id = LoginUser.Id,
Index = 1
});
var tags_id = topic_tags.ToList();
TagsInfo tag = Tags.GetItemByKeyname(tab);
if (tag.Id > 1)
{
tags_id.Add(tag.Id.Value);
}
foreach (uint tagid in tags_id)
{
topic.FlagTags(tagid);
}
});
RedisHelper.Remove("author_nonereply", "indextopics_all1", "indextopics_all2", "indextopics_all3", "indextopics_all4",
"indextopics_good1", "indextopics_good2", "indextopics_good3", "indextopics_good4",
"indextopics_share1", "indextopics_share2", "indextopics_share3", "indextopics_share4",
"indextopics_ask1", "indextopics_ask2", "indextopics_ask3", "indextopics_ask4",
"indextopics_job1", "indextopics_job2", "indextopics_job3", "indextopics_job4");
return(new RedirectResult("/"));
}
public APIReturn Put_update(ulong?Id, [FromForm] ulong?Last_posts_id, [FromForm] ulong?Owner_users_id, [FromForm] int?Count_posts, [FromForm] uint?Count_views, [FromForm] string Title, [FromForm] ulong?Top, [FromForm] uint[] mn_Tags, [FromForm] ulong[] mn_Users)
{
TopicsInfo item = new TopicsInfo();
item.Id = Id;
item.Last_posts_id = Last_posts_id;
item.Owner_users_id = Owner_users_id;
item.Count_posts = Count_posts;
item.Count_views = Count_views;
item.Create_time = DateTime.Now;
item.Title = Title;
item.Top = Top;
item.Update_time = DateTime.Now;
int affrows = Topics.Update(item);
//关联 Tags
if (mn_Tags.Length == 0)
{
item.UnflagTagsALL();
}
else
{
List <uint> mn_Tags_list = mn_Tags.ToList();
foreach (TagsInfo Obj_tags in item.Obj_tagss)
{
int idx = mn_Tags_list.FindIndex(a => a == Obj_tags.Id);
if (idx == -1)
{
item.UnflagTags(Obj_tags.Id);
}
else
{
mn_Tags_list.RemoveAt(idx);
}
}
mn_Tags_list.ForEach(a => item.FlagTags(a));
}
//关联 Users
if (mn_Users.Length == 0)
{
item.UnflagUsersALL();
}
else
{
List <ulong> mn_Users_list = mn_Users.ToList();
foreach (UsersInfo Obj_users in item.Obj_userss)
{
int idx = mn_Users_list.FindIndex(a => a == Obj_users.Id);
if (idx == -1)
{
item.UnflagUsers(Obj_users.Id);
}
else
{
mn_Users_list.RemoveAt(idx);
}
}
mn_Users_list.ForEach(a => item.FlagUsers(a));
}
if (affrows > 0)
{
return(new APIReturn(0, "成功"));
}
return(new APIReturn(99, "失败"));
}