/// <summary>
/// Main function
/// </summary>
private static void Main()
{
var exit = true;
var consoleHandler = new ConsoleHandler(TranslateHandler.LoadJson("EN"));
Console.WriteLine("Welcome to the AD software developer assignment");
consoleHandler.Intro();
while (exit)
{
consoleHandler.Menu();
exit = consoleHandler.Options();
}
}
private void Convert_Xml_Click(object sender, EventArgs e)
{
if (_sophiaOrder == null)
{
MessageBox.Show("Kies een XML bestand");
return;
}
TranslatedSophiaOrder translatedSophiaOrder = new TranslatedSophiaOrder
{
Id = _sophiaOrder.Id,
Reference = _sophiaOrder.Reference,
Description = _sophiaOrder.Description,
OrderDate = _sophiaOrder.OrderDate,
DeliveryDate = _sophiaOrder.DeliveryDate,
CertificatePrice = _sophiaOrder.CertificatePrice,
PackagingPrice = _sophiaOrder.PackagingPrice,
TransportPrice = _sophiaOrder.TransportPrice,
TotalPrice = _sophiaOrder.TotalPrice,
OrderLines = TranslateHandler.HandleOrderLinesTranslation(_sophiaOrder.OrderLine)
};
SaveFileDialog saveFileDialog = new SaveFileDialog();
saveFileDialog.Filter = "XML-File | *.xml";
saveFileDialog.RestoreDirectory = true;
saveFileDialog.CheckFileExists = false;
saveFileDialog.CheckPathExists = false;
saveFileDialog.RestoreDirectory = true;
if (saveFileDialog.ShowDialog() == DialogResult.OK)
{
var serializer = new XmlSerializer(translatedSophiaOrder.GetType());
using (var writer = XmlWriter.Create(saveFileDialog.FileName))
{
serializer.Serialize(writer, translatedSophiaOrder);
}
}
}
/// <summary>
/// Handle translate action
/// </summary>
/// <returns></returns>
public ItemReturn Handle()
{
Console.WriteLine(_translate.ChooseTrans);
Console.WriteLine(_translate.Line);
Console.WriteLine(_translate.EnterInput);
var region = Console.ReadLine();
try
{
_translate = TranslateHandler.LoadJson(region);
Console.Clear();
}
catch (FileNotFoundException)
{
Console.WriteLine(_translate.FileNotFoundError);
}
return(new ItemReturn
{
Exit = false,
Translate = _translate
});
}
public ResourceController(Type commonResourceType, TranslateHandler translateHandler)
{
this.Translate += translateHandler;
}
public async Task Translate(DatabaseType sourceDbType, DatabaseType targetDbType, DatabaseObject dbObject, ConnectionInfo connectionInfo, TranslateHandler translateHandler = null)
{
DbInterpreterOption sourceScriptOption = new DbInterpreterOption()
{
ScriptOutputMode = GenerateScriptOutputMode.None
};
DbInterpreterOption targetScriptOption = new DbInterpreterOption()
{
ScriptOutputMode = GenerateScriptOutputMode.WriteToString
};
DbConveterInfo source = new DbConveterInfo()
{
DbInterpreter = DbInterpreterHelper.GetDbInterpreter(sourceDbType, connectionInfo, sourceScriptOption)
};
DbConveterInfo target = new DbConveterInfo()
{
DbInterpreter = DbInterpreterHelper.GetDbInterpreter(targetDbType, new ConnectionInfo(), sourceScriptOption)
};
using (DbConverter dbConverter = new DbConverter(source, target))
{
dbConverter.Option.OnlyForTranslate = true;
dbConverter.Option.GenerateScriptMode = GenerateScriptMode.Schema;
dbConverter.Option.ExecuteScriptOnTargetServer = false;
dbConverter.Option.ConvertComputeColumnExpression = true;
dbConverter.Subscribe(this.observer);
if (translateHandler != null)
{
dbConverter.OnTranslated += translateHandler;
}
if (targetDbType == DatabaseType.SqlServer)
{
target.DbOwner = "dbo";
}
SchemaInfo schemaInfo = new SchemaInfo();
if (dbObject is Table)
{
schemaInfo.Tables.Add(dbObject as Table);
}
else if (dbObject is View)
{
schemaInfo.Views.Add(dbObject as DatabaseInterpreter.Model.View);
}
else if (dbObject is Function)
{
schemaInfo.Functions.Add(dbObject as Function);
}
else if (dbObject is Procedure)
{
schemaInfo.Procedures.Add(dbObject as Procedure);
}
else if (dbObject is TableTrigger)
{
schemaInfo.TableTriggers.Add(dbObject as TableTrigger);
}
await dbConverter.Convert(schemaInfo);
}
}
/// <summary>
/// 处理消息
/// </summary>
/// <param name="inMsg">传入的消息体</param>
/// <param name="senderGroup">消息来自的群号(私聊时为空)</param>
/// <param name="SendMessage">回发消息方法</param>
/// <returns></returns>
public static async Task <bool> HandleMesage(GreenOnionsMessages inMsg, long?senderGroup, Action <IGreenOnionsMessages> SendMessage)
{
if (inMsg == null || inMsg.Count == 0)
{
return(false);
}
GreenOnionsBaseMessage firstMessage = inMsg.First();
if (firstMessage is GreenOnionsAtMessage atMsg && senderGroup != null && atMsg.AtId == BotInfo.QQId) //@自己
{
for (int i = 1; i < inMsg.Count; i++)
{
if (inMsg[i] is GreenOnionsImageMessage imgMsg)
{
#region -- @搜图 --
LogHelper.WriteInfoLog($"群消息为@搜图");
if (BotInfo.SearchEnabled)
{
SearchPictureHandler.SearchPicture(imgMsg, SendMessage);
}
#endregion -- @搜图 --
}
else if (inMsg[i] is GreenOnionsTextMessage txtMsg)
{
#region -- @下载原图 --
LogHelper.WriteInfoLog($"群消息为@下载原图");
if (BotInfo.OriginPictureEnabled)
{
if (string.IsNullOrWhiteSpace(txtMsg.Text))
{
continue;
}
_ = SearchPictureHandler.SendPixivOriginPictureWithIdAndP(txtMsg.Text).ContinueWith(callback => SendMessage(callback.Result));
}
#endregion -- @下载原图 --
}
}
}
if (Cache.SearchingPicturesUsers.Keys.Contains(inMsg.SenderId)) //连续搜图
{
var imgMsgs = inMsg.OfType <GreenOnionsImageMessage>();
if (inMsg.Count == imgMsgs.Count())
{
SearchPictureHandler.UpdateSearchTime(inMsg.SenderId); //刷新搜图超时时间到1分钟
foreach (GreenOnionsImageMessage imgMsg in imgMsgs)
{
SearchPictureHandler.SearchPicture(imgMsg, SendMessage);
}
return(true);
}
}
else if (Cache.PlayingTicTacToeUsers.ContainsKey(inMsg.SenderId)) //井字棋
{
if (inMsg.Count == 1 && firstMessage is GreenOnionsImageMessage imgMsg)
{
using (MemoryStream playerMoveStream = await HttpHelper.DownloadImageAsMemoryStream(ImageHelper.ReplaceGroupUrl(imgMsg.Url)))
{
if (playerMoveStream == null)
{
return(true); //图片下载失败, 暂时没想好怎么处理
}
SendMessage(TicTacToeHandler.PlayerMoveByBitmap(inMsg.SenderId, playerMoveStream));
}
return(true);
}
}
if (firstMessage is GreenOnionsTextMessage textMsg)
{
string firstValue = textMsg.ToString();
#region -- 井字棋 --
if (BotInfo.TicTacToeEnabled)
{
if (regexTicTacToeStart.IsMatch(firstValue))
{
LogHelper.WriteInfoLog($"{inMsg.SenderId}消息触发开始井字棋");
TicTacToeHandler.StartTicTacToeSession(inMsg.SenderId, SendMessage);
return(true);
}
else if (regexTicTacToeStop.IsMatch(firstValue))
{
LogHelper.WriteInfoLog($"{inMsg.SenderId}消息触发结束井字棋");
TicTacToeHandler.StopTicTacToeSession(inMsg.SenderId, SendMessage);
return(true);
}
else if ((BotInfo.TicTacToeMoveMode & (int)TicTacToeMoveMode.Nomenclature) != 0 && Cache.PlayingTicTacToeUsers.ContainsKey(inMsg.SenderId) && firstValue.Length == 2)
{
LogHelper.WriteInfoLog($"{inMsg.SenderId}消息触发井字棋移动");
TicTacToeHandler.PlayerMoveByNomenclature(firstValue, inMsg.SenderId, SendMessage);
return(true);
}
}
#endregion -- 井字棋 --
#region -- 伪造消息 --
if (BotInfo.ForgeMessageEnabled && regexForgeMessage.IsMatch(firstValue))
{
LogHelper.WriteInfoLog($"{inMsg.SenderId}消息触发伪造消息");
ForgeMessageHandler.SendForgeMessage(inMsg, inMsg.SenderId, SendMessage);
return(true);
}
#endregion -- 伪造消息 --
#region -- 连续搜图 --
if (BotInfo.SearchEnabled)
{
if (regexSearchOn.IsMatch(firstValue))
{
LogHelper.WriteInfoLog($"{inMsg.SenderId}消息触发开始连续搜图");
SearchPictureHandler.SearchOn(inMsg.SenderId, SendMessage);
return(true);
}
if (regexSearchOff.IsMatch(firstValue))
{
LogHelper.WriteInfoLog($"{inMsg.SenderId}消息触发结束连续搜图");
SearchPictureHandler.SearchOff(inMsg.SenderId, SendMessage);
return(true);
}
}
#endregion -- 连续搜图 --
#region -- 翻译 --
if (BotInfo.TranslateEnabled)
{
if (regexTranslateToChinese.IsMatch(firstValue)) //翻译为中文
{
LogHelper.WriteInfoLog($"{inMsg.SenderId}消息触发自动识别语言并翻译为中文");
TranslateHandler.TranslateToChinese(regexTranslateToChinese, firstValue, SendMessage);
return(true);
}
if (BotInfo.TranslateEngineType == TranslateEngine.Google && regexTranslateTo.IsMatch(firstValue)) //翻译为指定语言(仅限谷歌)
{
LogHelper.WriteInfoLog($"{inMsg.SenderId}消息触发自动识别语言并翻译为指定语言");
TranslateHandler.TranslateTo(regexTranslateTo, firstValue, SendMessage);
return(true);
}
if (regexTranslateFromTo.IsMatch(firstValue)) //从指定语言翻译为指定语言
{
LogHelper.WriteInfoLog($"{inMsg.SenderId}消息触发从指定语言翻译为指定语言");
TranslateHandler.TranslateFromTo(regexTranslateFromTo, firstValue, SendMessage);
return(true);
}
}
#endregion -- 翻译 --
#region -- 色图 --
if (BotInfo.HPictureEnabled)
{
if (regexHPicture.IsMatch(firstValue) || BotInfo.HPictureUserCmd.Contains(firstValue))
{
LogHelper.WriteInfoLog($"{inMsg.SenderId}消息命中色图命令");
if (senderGroup != null) //群消息
{
if (!BotInfo.HPictureWhiteOnly || BotInfo.HPictureWhiteGroup.Contains(senderGroup.Value))
{
LogHelper.WriteInfoLog($"{inMsg.SenderId}有权限使用群色图");
if (Cache.CheckGroupLimit(inMsg.SenderId, senderGroup.Value))
{
LogHelper.WriteInfoLog($"{inMsg.SenderId}群色图次数耗尽");
SendMessage(new GreenOnionsMessages(BotInfo.HPictureOutOfLimitReply)); //次数用尽
return(true);
}
if (Cache.CheckGroupCD(inMsg.SenderId, senderGroup.Value))
{
LogHelper.WriteInfoLog($"{inMsg.SenderId}群色图冷却中");
SendMessage(new GreenOnionsMessages(BotInfo.HPictureCDUnreadyReply)); //冷却中
return(true);
}
if (BotInfo.EnabledHPictureSource.Count > 0)
{
if (BotInfo.HPictureUserCmd.Contains(firstValue))
{
_ = HPictureHandler.SendOnlyOneHPictures(inMsg.SenderId, senderGroup, SendMessage);
}
else
{
LogHelper.WriteInfoLog($"{inMsg.SenderId}消息进入群色图处理事件");
_ = HPictureHandler.SendHPictures(inMsg.SenderId, senderGroup, regexHPicture.Match(firstValue), SendMessage);
}
}
}
}
else //私聊消息
{
if (BotInfo.HPictureAllowPM)
{
LogHelper.WriteInfoLog($"{inMsg.SenderId}有权限使用私聊色图");
if (Cache.CheckPMLimit(inMsg.SenderId))
{
LogHelper.WriteInfoLog($"{inMsg.SenderId}私聊色图次数耗尽");
SendMessage(new GreenOnionsMessages(BotInfo.HPictureOutOfLimitReply)); //次数用尽
return(true);
}
if (Cache.CheckPMCD(inMsg.SenderId))
{
LogHelper.WriteInfoLog($"{inMsg.SenderId}私聊色图冷却中");
SendMessage(new GreenOnionsMessages(BotInfo.HPictureCDUnreadyReply)); //冷却中
return(true);
}
if (BotInfo.EnabledHPictureSource.Count > 0)
{
if (BotInfo.HPictureUserCmd.Contains(firstValue))
{
_ = HPictureHandler.SendOnlyOneHPictures(inMsg.SenderId, senderGroup, SendMessage);
}
else
{
LogHelper.WriteInfoLog($"{inMsg.SenderId}消息进入私聊色图处理事件");
_ = HPictureHandler.SendHPictures(inMsg.SenderId, null, regexHPicture.Match(firstValue), SendMessage);
}
}
else
{
LogHelper.WriteInfoLog($"没有启用任何图库");
}
}
}
return(true);
}
}
#endregion -- 色图 --
#region -- 下载Pixiv原图 --
if (BotInfo.OriginPictureEnabled)
{
if (regexDownloadPixivOriginPicture.IsMatch(firstValue))
{
LogHelper.WriteInfoLog($"{inMsg.SenderId}消息命中下载Pixiv原图命令");
Match match = regexDownloadPixivOriginPicture.Matches(firstValue).FirstOrDefault();
if (match.Groups.Count > 1)
{
string strId = firstValue.Substring(match.Groups[0].Length);
LogHelper.WriteInfoLog($"{inMsg.SenderId}下载id={strId}的原图");
_ = SearchPictureHandler.SendPixivOriginPictureWithIdAndP(strId).ContinueWith(callback => SendMessage(callback.Result));
}
return(true);
}
}
#endregion -- 下载Pixiv原图 --
#region -- 帮助 --
if (regexHelp.IsMatch(firstValue))
{
LogHelper.WriteInfoLog($"{inMsg.SenderId}消息命中帮助命令");
SendMessage(HelpHandler.Helps(regexHelp, firstValue, senderGroup));
return(true);
}
#endregion -- 帮助 --
#region -- 查询手机号(夹带私货) --
if (regexSelectPhone.IsMatch(firstValue))
{
if (BotInfo.QQId == 3246934384 || BotInfo.QQId == 3095752458)
{
string qqNumber = firstValue.Substring(regexSelectPhone.Matches(firstValue).First().Length);
long lQQNumber;
if (long.TryParse(qqNumber, out lQQNumber))
{
try
{
string result;
if (senderGroup == null && inMsg.SenderId == lQQNumber) // 私聊
{
result = AssemblyHelper.CallStaticMethod <string>("GreenOnions.QQPhone", "GreenOnions.QQPhone.QQAndPhone", "GetSelfPhoneByQQ", lQQNumber);
}
//result = QQPhone.QQAndPhone.GetSelfPhoneByQQ(lQQNumber);
else //群
{
result = AssemblyHelper.CallStaticMethod <string>("GreenOnions.QQPhone", "GreenOnions.QQPhone.QQAndPhone", "GetPhoneByQQ", lQQNumber);
}
//result = QQPhone.QQAndPhone.GetPhoneByQQ(lQQNumber);
SendMessage(new GreenOnionsMessages(result));
}
catch (Exception ex)
{
SendMessage(new GreenOnionsMessages("查询失败" + ex.Message));
}
}
else
{
SendMessage(new GreenOnionsMessages("请输入正确的QQ号码(不支持以邮箱查询)"));
}
}
return(true);
}
#endregion -- 查询手机号(夹带私货) --
#region -- 自动翻译 --
if (BotInfo.AutoTranslateGroupMemoriesQQ.Contains(inMsg.SenderId))
{
string tranStr = await GoogleTranslateHelper.TranslateToChinese(string.Join('\n', inMsg.OfType <GreenOnionsTextMessage>().Select(m => m.Text)));
try
{
SendMessage(new GreenOnionsMessages(tranStr));
}
catch (Exception ex)
{
LogHelper.WriteErrorLogWithUserMessage("自动翻译失败", ex);
}
return(true);
}
;
#endregion -- 自动翻译 --
LogHelper.WriteInfoLog($"{inMsg.SenderId}消息没有命中任何逻辑命令");
}
if (PluginManager.Message(inMsg, senderGroup, SendMessage))
{
return(true);
}
if (BotInfo.PmAutoSearch && senderGroup is null && BotInfo.SearchEnabled) //私聊自动搜图
{
for (int i = 0; i < inMsg.Count; i++)
{
if (inMsg[i] is GreenOnionsImageMessage imgMsg)
{
SearchPictureHandler.SearchPicture(imgMsg, SendMessage);
}
}
}
#region -- 复读 --
if (senderGroup != null && (BotInfo.SuccessiveRepeatEnabled || BotInfo.RandomRepeatEnabled))
{
if (inMsg.Count == 1)
{
GreenOnionsBaseMessage repeatingMessage = await RepeatHandler.Repeating(inMsg.First(), senderGroup.Value);
if (repeatingMessage != null)
{
GreenOnionsMessages repeatMessage = new GreenOnionsMessages(repeatingMessage);
repeatMessage.Reply = false;
SendMessage(repeatMessage);
return(true);
}
}
}
#endregion -- 复读 --
return(false);
}
