/// <summary>
/// 删除配置
/// </summary>
/// <param name="group"></param>
/// <param name="account"></param>
/// <param name="type"></param>
/// <returns></returns>
public async Task <int> RemoveConfigAsync(string group, string account, GroupConfigTypes type)
{
return(await PikachuDataContext.Database.ExecuteSqlCommandAsync($@"
UPDATE groupconfigs
SET
Enable=0
WHERE Account = {account} AND Group = {group} AND Enable = 1 AND GetGroupConfigType = {(int) type}
"));
}
private async Task <bool> RemoveInfo(string groupNo, string account, GroupConfigTypes type)
{
if (await _groupConfigService.RemoveConfigAsync(groupNo, account, type) > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 添加配置 [单值]
/// </summary>
/// <param name="group"></param>
/// <param name="account"></param>
/// <param name="type"></param>
/// <returns></returns>
public int AddSingleInfo(string group, string account, string info, GroupConfigTypes type)
{
var old = PikachuDataContext.GroupConfigs.FirstOrDefault(u =>
u.Enable && u.GetGroupConfigType == type && u.Group.Equals(group) && u.Account.Equals(account));
if (old != null)
{
old.Value = info;
old.UpdateTime = DateTime.Now;
}
else
{
PikachuDataContext.GroupConfigs.Add(new Data.Pikachu.Models.GroupConfig()
{
Account = account,
Group = group,
Enable = true,
Value = info,
GetGroupConfigType = type,
});
}
return(PikachuDataContext.SaveChanges());
}
public int RemoveConfig(string group, string account, GroupConfigTypes type)
{
return(PikachuDataContext.Database.ExecuteSqlCommand("UPDATE "));
}
/// <summary>
/// 获取信息[单配置]
/// </summary>
/// <param name="account"></param>
/// <param name="group"></param>
/// <param name="type"></param>
/// <returns></returns>
public Task <GroupConfig> GetSingle(string account, string group, GroupConfigTypes type)
{
return(PikachuDataContext.GroupConfigs.FirstOrDefaultAsync(u =>
u.Enable && u.GetGroupConfigType == GroupConfigTypes.DefaultConfirm &&
u.Account.Equals(account) && u.Group.Equals(group)));
}
private async Task <bool> AddInfo(string info, string groupNo, string account, GroupConfigTypes type)
{
if (!string.IsNullOrWhiteSpace(info) &&
await _groupConfigService.AddSingleInfoAsync(groupNo, account, info, type) > 0)
{
return(true);
}
else
{
return(false);
}
}
