public MemberCommands(SystemStore systems, MemberStore members, EmbedService embeds, ProxyCacheService proxyCache)
{
_systems = systems;
_members = members;
_embeds = embeds;
_proxyCache = proxyCache;
}
public DataFileService(SystemStore systems, MemberStore members, SwitchStore switches, ILogger logger)
{
_systems = systems;
_members = members;
_switches = switches;
_logger = logger.ForContext <DataFileService>();
}
public SystemController(SystemStore systems, MemberStore members, SwitchStore switches, DbConnectionFactory conn, TokenAuthService auth)
{
_systems = systems;
_members = members;
_switches = switches;
_conn = conn;
_auth = auth;
}
public SystemCommands(SystemStore systems, MemberStore members, SwitchStore switches, EmbedService embeds, ProxyCacheService proxyCache)
{
_systems = systems;
_members = members;
_switches = switches;
_embeds = embeds;
_proxyCache = proxyCache;
}
public EmbedService(SystemStore systems, MemberStore members, IDiscordClient client, SwitchStore switches, MessageStore messages)
{
_systems = systems;
_members = members;
_client = client;
_switches = switches;
_messages = messages;
}
/// <summary>
/// 调用从库存储过程
/// </summary>
/// <returns></returns>
public virtual int TestData()
{
DbCommand dc = this.SystemStore.GetStoredProcCommand("EyouSoft_GetSingleCount");
this.SystemStore.AddInParameter(dc, "OperationID", DbType.Int32, 329);
this.SystemStore.AddOutParameter(dc, "RowCount", DbType.Int32, 8);
DbHelper.RunProcedure(dc, this.SystemStore);
return(Convert.ToInt32(SystemStore.GetParameterValue(dc, "RowCount")));
}
public Context(IServiceProvider provider, SocketUserMessage message, int commandParseOffset,
PKSystem senderSystem)
{
_client = provider.GetRequiredService <IDiscordClient>() as DiscordShardedClient;
_message = message;
_systems = provider.GetRequiredService <SystemStore>();
_members = provider.GetRequiredService <MemberStore>();
_senderSystem = senderSystem;
_provider = provider;
_parameters = new Parameters(message.Content.Substring(commandParseOffset));
}
public PeriodicStatCollector(IDiscordClient client, IMetrics metrics, SystemStore systems, MemberStore members, SwitchStore switches, MessageStore messages, ILogger logger, WebhookCacheService webhookCache, DbConnectionCountHolder countHolder)
{
_client = (DiscordShardedClient)client;
_metrics = metrics;
_systems = systems;
_members = members;
_switches = switches;
_messages = messages;
_webhookCache = webhookCache;
_countHolder = countHolder;
_logger = logger.ForContext <PeriodicStatCollector>();
}
/// <summary>
/// 获取包含某线路区域的所有分站（销售城市）
/// </summary>
/// <param name="areaId">线路区域编号</param>
/// <returns></returns>
public IList <Model.SystemStructure.CityBase> GetSalesCityByArea(int areaId)
{
IList <Model.SystemStructure.CityBase> list = null;
if (areaId <= 0)
{
return(list);
}
var strSql = new StringBuilder();
strSql.Append(
@" select sa.CityId,sc.CityName,sc.ProvinceId,sp.ProvinceName
from tbl_SysCityAreaControl as sa left join tbl_SysCity as sc on sa.CityId = sc.Id
left join tbl_SysProvince as sp on sa.ProvinceId = sp.Id
where sa.AreaId = @AreaId ");
DbCommand dc = SystemStore.GetSqlStringCommand(strSql.ToString());
SystemStore.AddInParameter(dc, "AreaId", DbType.Int32, areaId);
using (IDataReader dr = DbHelper.ExecuteReader(dc, SystemStore))
{
list = new List <Model.SystemStructure.CityBase>();
while (dr.Read())
{
list.Add(new Model.SystemStructure.CityBase
{
CityId = dr.IsDBNull(0) ? 0 : dr.GetInt32(0),
CityName = dr.IsDBNull(1) ? string.Empty : dr.GetString(1),
ProvinceId = dr.IsDBNull(2) ? 0 : dr.GetInt32(2),
ProvinceName = dr.IsDBNull(3) ? string.Empty : dr.GetString(3)
});
}
}
return(list);
}
/// <summary>
/// 设置平台配置，返回1成功，其它失败
/// </summary>
/// <param name="info">配置信息</param>
/// <param name="removeKeys">不处理的键组</param>
/// <returns></returns>
public virtual int SetSysSettings(EyouSoft.Model.SystemStructure.MSysSettingInfo info, string[] removeKeys)
{
string orderSmsCompanyTypes = string.Empty;
string orderSmsOrderTypes = string.Empty;
if (info.OrderSmsCompanyTypes != null && info.OrderSmsCompanyTypes.Length > 0)
{
foreach (var item in info.OrderSmsCompanyTypes)
{
orderSmsCompanyTypes += "," + (int)item;
}
orderSmsCompanyTypes = orderSmsCompanyTypes.Substring(1);
}
if (info.OrderSmsOrderTypes != null && info.OrderSmsOrderTypes.Length > 0)
{
foreach (var item in info.OrderSmsOrderTypes)
{
orderSmsOrderTypes += "," + (int)item;
}
orderSmsOrderTypes = orderSmsOrderTypes.Substring(1);
}
DbCommand cmd = SystemStore.GetSqlStringCommand("PRINT 1");
StringBuilder cmdText = new StringBuilder();
if (!removeKeys.Contains(SettingKey_OrderSmsCompanyId))
{
cmdText.AppendFormat(SQL_SET_SetSysSettings, SettingKey_OrderSmsCompanyId);
SystemStore.AddInParameter(cmd, "Key" + SettingKey_OrderSmsCompanyId, DbType.AnsiString, SettingKey_OrderSmsCompanyId);
SystemStore.AddInParameter(cmd, "Value" + SettingKey_OrderSmsCompanyId, DbType.String, info.OrderSmsCompanyId);
}
if (!removeKeys.Contains(SettingKey_OrderSmsCompanyType))
{
cmdText.AppendFormat(SQL_SET_SetSysSettings, SettingKey_OrderSmsCompanyType);
SystemStore.AddInParameter(cmd, "Key" + SettingKey_OrderSmsCompanyType, DbType.AnsiString, SettingKey_OrderSmsCompanyType);
SystemStore.AddInParameter(cmd, "Value" + SettingKey_OrderSmsCompanyType, DbType.String, orderSmsCompanyTypes);
}
if (!removeKeys.Contains(SettingKey_OrderSmsIsEnable))
{
cmdText.AppendFormat(SQL_SET_SetSysSettings, SettingKey_OrderSmsIsEnable);
SystemStore.AddInParameter(cmd, "Key" + SettingKey_OrderSmsIsEnable, DbType.AnsiString, SettingKey_OrderSmsIsEnable);
SystemStore.AddInParameter(cmd, "Value" + SettingKey_OrderSmsIsEnable, DbType.String, info.OrderSmsIsEnable ? "1" : "0");
}
if (!removeKeys.Contains(SettingKey_OrderSmsOrderType))
{
cmdText.AppendFormat(SQL_SET_SetSysSettings, SettingKey_OrderSmsOrderType);
SystemStore.AddInParameter(cmd, "Key" + SettingKey_OrderSmsOrderType, DbType.AnsiString, SettingKey_OrderSmsOrderType);
SystemStore.AddInParameter(cmd, "Value" + SettingKey_OrderSmsOrderType, DbType.String, orderSmsOrderTypes);
}
if (!removeKeys.Contains(SettingKey_OrderSmsTemplate))
{
cmdText.AppendFormat(SQL_SET_SetSysSettings, SettingKey_OrderSmsTemplate);
SystemStore.AddInParameter(cmd, "Key" + SettingKey_OrderSmsTemplate, DbType.AnsiString, SettingKey_OrderSmsTemplate);
SystemStore.AddInParameter(cmd, "Value" + SettingKey_OrderSmsTemplate, DbType.String, info.OrderSmsTemplate);
}
if (!removeKeys.Contains(SettingKey_OrderSmsUserId))
{
cmdText.AppendFormat(SQL_SET_SetSysSettings, SettingKey_OrderSmsUserId);
SystemStore.AddInParameter(cmd, "Key" + SettingKey_OrderSmsUserId, DbType.AnsiString, SettingKey_OrderSmsUserId);
SystemStore.AddInParameter(cmd, "Value" + SettingKey_OrderSmsUserId, DbType.String, info.OrderSmsUserId);
}
if (!removeKeys.Contains(SettingKey_OrderSmsChannelIndex))
{
cmdText.AppendFormat(SQL_SET_SetSysSettings, SettingKey_OrderSmsChannelIndex);
SystemStore.AddInParameter(cmd, "Key" + SettingKey_OrderSmsChannelIndex, DbType.AnsiString, SettingKey_OrderSmsChannelIndex);
SystemStore.AddInParameter(cmd, "Value" + SettingKey_OrderSmsChannelIndex, DbType.String, info.OrderSmsChannelIndex);
}
if (string.IsNullOrEmpty(cmdText.ToString()))
{
return(1);
}
cmd.CommandText = cmdText.ToString();
return(DbHelper.ExecuteSql(cmd, SystemStore) > 0 ? 1 : 0);
}
public LinkCommands(SystemStore systems)
{
_systems = systems;
}
public AccountController(SystemStore systems)
{
_systems = systems;
}
/// <summary>
/// 获取用户后台所有的（已启用的）权限
/// </summary>
/// <param name="companyTypes">用户公司类型集合</param>
/// <returns></returns>
public Model.SystemStructure.SysPermissionCategory GetAllPermissionByUser(Model.CompanyStructure.CompanyType[] companyTypes)
{
var strSql = new StringBuilder();
strSql.Append(" declare @Category int; ");
//个人中心（用户后台）
strSql.AppendFormat(" select @Category = [Id] from tbl_SysPermissionCategory where [TypeId] = {0} and IsEnable = '1'; ", 2);
strSql.Append(" select * from tbl_SysPermissionCategory where [Id] = @Category; ");
strSql.Append(" select * ");
strSql.Append(
" ,(select * FROM tbl_SysPermissionList list WHERE list.CategoryId = @Category AND list.IsEnable = '1' and list.ClassId = tbl_SysPermissionClass.Id for xml raw,root('Root')) as PermissionList ");
strSql.Append(" from tbl_SysPermissionClass where CategoryId = @Category and IsEnable = '1' ");
//营销工具 = 97, 系统设置 = 98, 我的网店 = 99
//营销工具、系统设置、我的网店 所有身份公司都有这些权限
strSql.Append(" and tbl_SysPermissionClass.Id in (97,98,99 ");
if (companyTypes != null && companyTypes.Any())
{
foreach (var t in companyTypes)
{
switch (t)
{
case Model.CompanyStructure.CompanyType.专线:
case Model.CompanyStructure.CompanyType.组团:
case Model.CompanyStructure.CompanyType.地接:
case Model.CompanyStructure.CompanyType.景区:
strSql.AppendFormat(" ,{0} ", (int)t);
break;
default:
continue;
}
}
}
strSql.Append(" ) ; ");
DbCommand dc = SystemStore.GetSqlStringCommand(strSql.ToString());
var model = new Model.SystemStructure.SysPermissionCategory();
using (IDataReader dr = DbHelper.ExecuteReader(dc, SystemStore))
{
if (dr.Read())
{
if (!dr.IsDBNull(dr.GetOrdinal("Id")))
{
model.Id = dr.GetInt32(dr.GetOrdinal("Id"));
}
if (!dr.IsDBNull(dr.GetOrdinal("TypeId")))
{
model.TypeId = dr.GetInt32(dr.GetOrdinal("TypeId"));
}
if (!dr.IsDBNull(dr.GetOrdinal("CategoryName")))
{
model.CategoryName = dr.GetString(dr.GetOrdinal("CategoryName"));
}
if (!dr.IsDBNull(dr.GetOrdinal("SortId")))
{
model.SortId = dr.GetInt32(dr.GetOrdinal("SortId"));
}
if (!dr.IsDBNull(dr.GetOrdinal("IsEnable")))
{
if (dr.GetString(dr.GetOrdinal("IsEnable")) == "1" || dr.GetString(dr.GetOrdinal("IsEnable")).ToLower() == "ture")
{
model.IsEnable = true;
}
}
}
dr.NextResult();
model.SysPermissionClass = new List <Model.SystemStructure.SysPermissionClass>();
Model.SystemStructure.SysPermissionClass classModel;
while (dr.Read())
{
classModel = new Model.SystemStructure.SysPermissionClass();
if (!dr.IsDBNull(dr.GetOrdinal("Id")))
{
classModel.Id = dr.GetInt32(dr.GetOrdinal("Id"));
}
if (!dr.IsDBNull(dr.GetOrdinal("CategoryId")))
{
classModel.CategoryId = dr.GetInt32(dr.GetOrdinal("CategoryId"));
}
if (!dr.IsDBNull(dr.GetOrdinal("SortId")))
{
classModel.SortId = dr.GetInt32(dr.GetOrdinal("SortId"));
}
if (!dr.IsDBNull(dr.GetOrdinal("ClassName")))
{
classModel.ClassName = dr.GetString(dr.GetOrdinal("ClassName"));
}
if (!dr.IsDBNull(dr.GetOrdinal("IsEnable")))
{
if (dr.GetString(dr.GetOrdinal("IsEnable")) == "1" || dr.GetString(dr.GetOrdinal("IsEnable")).ToLower() == "ture")
{
classModel.IsEnable = true;
}
}
if (!dr.IsDBNull(dr.GetOrdinal("PermissionList")))
{
var xRoot = XElement.Parse(dr.GetString(dr.GetOrdinal("PermissionList")));
var xRows = Common.Utility.GetXElements(xRoot, "row");
if (xRows != null && xRows.Any())
{
classModel.SysPermission = new List <Model.SystemStructure.SysPermission>();
foreach (var t in xRows)
{
if (t == null)
{
continue;
}
var tmp = new Model.SystemStructure.SysPermission
{
CategoryId = model.Id,
ClassId = classModel.Id,
Id = Common.Utility.GetInt(Common.Utility.GetXAttributeValue(t, "Id")),
PermissionName =
Common.Utility.GetXAttributeValue(t, "PermissionName"),
SortId =
Common.Utility.GetInt(Common.Utility.GetXAttributeValue(t,
"SortId"))
};
string strt = Common.Utility.GetXAttributeValue(t, "IsEnable");
if (!string.IsNullOrEmpty(strt) && (strt == "1" || strt.ToLower() == "true"))
{
tmp.IsEnable = true;
}
classModel.SysPermission.Add(tmp);
}
}
}
model.SysPermissionClass.Add(classModel);
}
}
return(model);
}
/// <summary>
/// 获取平台配置
/// </summary>
/// <returns></returns>
public virtual EyouSoft.Model.SystemStructure.MSysSettingInfo GetSysSetting()
{
EyouSoft.Model.SystemStructure.MSysSettingInfo info = null;
DbCommand cmd = SystemStore.GetSqlStringCommand(SQL_SELECT_GetSysSetting);
using (IDataReader rdr = DbHelper.ExecuteReader(cmd, SystemStore))
{
while (rdr.Read())
{
info = info ?? new EyouSoft.Model.SystemStructure.MSysSettingInfo();
string key = rdr.GetString(0);
string value = rdr.GetString(1);
switch (key)
{
case SettingKey_OrderSmsCompanyId:
info.OrderSmsCompanyId = value;
break;
case SettingKey_OrderSmsCompanyType:
string[] _items1 = value.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
if (_items1 != null && _items1.Length > 0)
{
int length = _items1.Length;
info.OrderSmsCompanyTypes = new EyouSoft.Model.CompanyStructure.CompanyLev[length];
for (int i = 0; i < length; i++)
{
info.OrderSmsCompanyTypes[i] = (EyouSoft.Model.CompanyStructure.CompanyLev) int.Parse(_items1[i]);
}
}
break;
case SettingKey_OrderSmsIsEnable:
info.OrderSmsIsEnable = value == "1";
break;
case SettingKey_OrderSmsOrderType:
string[] _items2 = value.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
if (_items2 != null && _items2.Length > 0)
{
int length = _items2.Length;
info.OrderSmsOrderTypes = new Model.NewTourStructure.OrderSource[length];
for (int i = 0; i < length; i++)
{
info.OrderSmsOrderTypes[i] = (EyouSoft.Model.NewTourStructure.OrderSource) int.Parse(_items2[i]);
}
}
break;
case SettingKey_OrderSmsTemplate:
info.OrderSmsTemplate = value;
break;
case SettingKey_OrderSmsUserId:
info.OrderSmsUserId = value;
break;
case SettingKey_OrderSmsChannelIndex:
info.OrderSmsChannelIndex = byte.Parse(value);
break;
default: break;
}
}
}
return(info);
}
public APICommands(SystemStore systems)
{
_systems = systems;
}
public TokenAuthService(SystemStore systems)
{
_systems = systems;
}
async Task <TypeReaderResult> FindSystemByAccountHelper(ulong id, IDiscordClient client, SystemStore systems)
{
var foundByAccountId = await systems.GetByAccount(id);
if (foundByAccountId != null)
{
return(TypeReaderResult.FromSuccess(foundByAccountId));
}
// We didn't find any, so we try to resolve the user ID to find the associated account,
// so we can print their username.
var user = await client.GetUserAsync(id);
// Return descriptive errors based on whether we found the user or not.
if (user == null)
{
return(TypeReaderResult.FromError(CommandError.ObjectNotFound, $"System or account with ID `{id}` not found."));
}
return(TypeReaderResult.FromError(CommandError.ObjectNotFound, $"Account **{user.Username}#{user.Discriminator}** not found."));
}
public ViewSystem(SystemStore systems, MemberStore members)
{
_systems = systems;
_members = members;
}
