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