async void LoadPost(long p_id) { _fv.Data = await AtPublish.First <Post>("文章-编辑", new { id = p_id }); LoadKeyword(p_id); LoadAlbum(p_id); }
async void OnSave(object sender, Mi e) { if (await AtPublish.Save(_fv.Data.To <Album>())) { _needRefresh = true; _fv.Data = await Create(); } }
async Task <Album> Create() { return(new Album( ID: await AtPublish.NewID(), Name: "新专辑", Creator: Kit.UserName, Ctime: Kit.Now)); }
async void OnDelPostKeyword(object sender, Mi e) { Postkeyword pk = new Postkeyword(PostID: _fv.Row.ID, Keyword: e.Row.Str(0)); if (await AtPublish.Delete(pk)) { LoadKeyword(_fv.Row.ID); } }
async void OnDelPostAlbum(object sender, Mi e) { var pa = new Postalbum(PostID: _fv.Row.ID, AlbumID: e.Row.ID); if (await AtPublish.Delete(pa)) { LoadAlbum(_fv.Row.ID); } }
async Task <bool> IsUsed(string p_keyword) { int cnt = await AtPublish.GetScalar <int>("发布-关键字引用数", new { keyword = p_keyword }); if (cnt > 0) { Kit.Warn("关键字已被引用,无法修改或删除!"); return(true); } return(false); }
async Task <bool> IsUsed(long p_id) { int cnt = await AtPublish.GetScalar <int>("发布-专辑引用数", new { AlbumID = p_id }); if (cnt > 0) { Kit.Warn("专辑已被引用,无法修改或删除!"); return(true); } return(false); }
async void OnSearch(object sender, string e) { if (e == "#全部") { LoadAll(); } else if (!string.IsNullOrEmpty(e)) { _lv.Data = await AtPublish.Query <Keyword>("发布-模糊查询关键字", new { id = $"%{e}%" }); } SelectTab("列表"); }
public async Task <bool> Show(Album p_keyword) { if (p_keyword != null) { _fv.Data = await AtPublish.GetByID <Album>(p_keyword.ID); } else { _fv.Data = await Create(); } await ShowAsync(); return(_needRefresh); }
async void OnAddPost(object sender, Mi e) { var post = new Post( ID: await AtPublish.NewID(), Title: "新文章", TempType: 0, Dispidx: await AtPublish.NewSeq("sq_post"), CreatorID: Kit.UserID, Creator: Kit.UserName, Ctime: Kit.Now); _fv.Data = post; _lvKeyword.Data = null; _lvAlbum.Data = null; }
internal async Task <bool> SavePost() { Post post = (Post)_fv.Data; if (post == null || !post.IsValid()) { return(false); } post.Url = await AtPublish.SavePost(post); _fv.Row.AcceptChanges(); LoadAll(); Kit.Msg("保存成功"); return(true); }
async void OnDelPost(object sender, Mi e) { Post post = (Post)_fv.Data; if (!await Kit.Confirm($"确认要删除[{post.Title}]吗?")) { Kit.Msg("已取消删除!"); return; } if (await AtPublish.Delete(post)) { LoadAll(); _fv.Data = null; _lvKeyword.Data = null; _lvAlbum.Data = null; } }
async void OnDel(object sender, Mi e) { var key = e.Data.To <Keyword>(); if (await IsUsed(key.ID)) { return; } if (!await Kit.Confirm($"确认要删除[{key.ID}]吗?")) { Kit.Msg("已取消删除!"); return; } if (await AtPublish.Delete(key)) { LoadAll(); } }
async void OnDel(object sender, Mi e) { var album = e.Data.To <Album>(); if (await IsUsed(album.ID)) { return; } if (!await Kit.Confirm($"确认要删除[{album.Name}]吗?")) { Kit.Msg("已取消删除!"); return; } if (await AtPublish.Delete(album)) { LoadAll(); } }
async void OnSelect(object sender, Mi e) { var selected = _lv.SelectedRows.ToList(); if (selected.Count == 0) { Kit.Warn("未选择专辑!"); return; } var ls = new List <Postalbum>(); foreach (var row in selected) { ls.Add(new Postalbum(PostID: _postID, AlbumID: row.ID)); } if (await AtPublish.BatchSave(ls)) { Close(true); } }
async void OnSelect(object sender, Mi e) { var selected = _lv.SelectedRows.ToList(); if (selected.Count == 0) { Kit.Warn("未选择关键字!"); return; } List <Postkeyword> ls = new List <Postkeyword>(); foreach (var row in selected) { ls.Add(new Postkeyword(PostID: _postID, Keyword: row.Str("id"))); } if (await AtPublish.BatchSave(ls)) { Close(true); } }
async void LoadAll() { _lv.Data = await AtPublish.Query <Album>("发布-所有专辑"); }
async void LoadAlbum(long p_id) { _lvAlbum.Data = await AtPublish.Query("文章-已选专辑", new { postid = p_id }); }
async void LoadKeyword(long p_id) { _lvKeyword.Data = await AtPublish.Query("文章-已选关键字", new { postid = p_id }); }
async void LoadAll() { _lv.Data = await AtPublish.Query <Keyword>("发布-所有关键字"); }
async void OnSearch(object sender, string e) { _lvPost.Data = await AtPublish.Query <Post>("文章-模糊查询", new { input = $"%{e}%" }); }
async void LoadAll() { _lvPost.Data = await AtPublish.Query <Post>("文章-管理列表"); }
async void OnLoadTest(object sender, RoutedEventArgs e) { _lv.Data = await AtPublish.Query("select id,Title,Cover,Summary,Url,TempType,AllowCoverClick,AllowComment from pub_post where id=@id", new { id = _testID }); }
async void OnNextPage(PageData e) { var ls = await AtPublish.Query("select id,Title,Cover,Summary,Url,TempType,AllowCoverClick,AllowComment from pub_post where IsPublish=1 order by Dispidx desc"); e.LoadPageData(ls); }
async void LoadData() { _lv.Data = await AtPublish.Query("文章-未选关键字", new { postid = _postID }); }