/// <summary>
/// 更新服务状态到数据库
/// </summary>
public virtual void UpdateServerStatus()
{
try
{
SplashScreenService.ShowSplashScreen();
string sqlStr;
if (serverState == "O")
{
serverState = "C";
}
else
{
serverState = "O";
}
sqlStr = $"UPDATE tb_ServerConfig SET ServerStatus='{serverState}'";
if (SQLHelper.UpDateSQL(sqlStr))
{
SetServerStatus();
}
SplashScreenService.HideSplashScreen();
}
catch (Exception ex)
{
SplashScreenService.HideSplashScreen();
MessageBoxService.ShowMessage($"更新服务状态出错：{ex.Message}", "提示信息", MessageButton.OK, MessageIcon.Error);
}
}
public void ShowSplashScreen()
{
if (!SplashScreenService.IsSplashScreenActive)
{
SplashScreenService.ShowSplashScreen();
}
}
public virtual void Copy()
{
var ii = new ImageOperator();
var destinationDir = new DirectoryInfo(ResultPath);
var dirList = new List <string>();
if (UnInstallationFolder)
{
dirList.Add("Фото_демонтажа");
}
if (InstallationFolder)
{
dirList.Add("Фото_монтажа");
}
if (ConnectionFolder)
{
dirList.Add("Фото_подключения");
}
if (RepairsFolder)
{
dirList.Add("Фото_ремонта");
}
if (LightFolder)
{
dirList.Add("Фото_свет");
}
WindowService.Hide();
SplashScreenService.ShowSplashScreen();
ii.CopyByNumbers(SourceDir, destinationDir, UNIUs, dirList, RenameToSubdirs, CopyToSubdirs, OverlayText);
SplashScreenService.HideSplashScreen();
WindowService.Close();
}
public void Calculate()
{
#if SILVERLIGHT
SplashScreenService.ShowSplashScreen().ContinueWith(x => {
Thread.Sleep(TimeSpan.FromSeconds(5));
SplashScreenService.HideSplashScreen();
});
#else
SplashScreenService.ShowSplashScreen();
Thread.Sleep(TimeSpan.FromSeconds(5));
SplashScreenService.HideSplashScreen();
#endif
}
/// <summary>
/// 获取服务器运行的日志信息
/// </summary>
public virtual void GetServerLogs()
{
try
{
SplashScreenService.ShowSplashScreen();
string sqlStr = $"SELECT [dttm],[result] FROM [db_SFI].[dbo].[tb_SystemLog] WHERE [AGid]=1 AND (CONVERT(varchar(10),dttm,112) = '{ServerLogDate.ToString("yyyyMMdd")}') ORDER BY int_id DESC ";
IEnumerable <SystemLog> logs = SQLHelper.GetObject <SystemLog>(sqlStr);
foreach (SystemLog log in logs)
{
Logs.Add(log);
}
GetServerStatus();
SplashScreenService.HideSplashScreen();
}
catch (Exception ex)
{
SplashScreenService.HideSplashScreen();
MessageBoxService.ShowMessage($"刷新日志信息出错：{ex.Message}", "提示信息", MessageButton.OK, MessageIcon.Error);
}
}
public virtual void SaveAgentInfo()
{
try
{
#region 验证重复
if (string.IsNullOrWhiteSpace(SelectedAgent.vchar_AGname))
{
MessageBoxService.ShowMessage("商业伙伴名称不能为空", "提示信息", MessageButton.OK, MessageIcon.Error);
return;
}
if (string.IsNullOrWhiteSpace(SelectedAgent.vchar_AGcontect))
{
MessageBoxService.ShowMessage("联系方式不能为空", "提示信息", MessageButton.OK, MessageIcon.Error);
return;
}
if (string.IsNullOrWhiteSpace(SelectedAgent.vchar_AGLinkMan))
{
MessageBoxService.ShowMessage("联系人不能为空", "提示信息", MessageButton.OK, MessageIcon.Error);
return;
}
if (string.IsNullOrWhiteSpace(SelectedAgent.vchar_AGcode))
{
MessageBoxService.ShowMessage("商业伙伴代码不能为空", "提示信息", MessageButton.OK, MessageIcon.Error);
return;
}
string sqlStr = string.Empty;
if (SelectedAgent.bit_synOpen)
{
if (string.IsNullOrWhiteSpace(SelectedAgent.vchar_synVerify) || string.IsNullOrWhiteSpace(SelectedAgent.vchar_synStopKeyWord))
{
MessageBoxService.ShowMessage("检查点同步信息不可为空", "提示信息", MessageButton.OK, MessageIcon.Error);
return;
}
sqlStr = $"SELECT [vchar_AGcode],[vchar_synVerify] FROM [dbo].[tb_Agent] WHERE [vchar_AGcode]='{SelectedAgent.vchar_AGcode}' OR [vchar_synVerify]='{SelectedAgent.vchar_synVerify}'";
IList <Agent> agents = (SQLHelper.GetObject <Agent>(sqlStr)).ToList();
if (agents.Count != 0)
{
Agent agent = agents.FirstOrDefault();
if (SelectedAgent.vchar_AGcode == agent.vchar_AGcode)
{
MessageBoxService.ShowMessage("与其他商业伙伴代码重复，请更换", "提示信息", MessageButton.OK, MessageIcon.Error);
return;
}
if (SelectedAgent.vchar_synVerify == agent.vchar_synVerify)
{
MessageBoxService.ShowMessage("与其他商业伙伴同步接口校验码重复，请更换", "提示信息", MessageButton.OK, MessageIcon.Error);
return;
}
}
}
if (SelectedAgent.bit_synQuery)
{
if (string.IsNullOrWhiteSpace(SelectedAgent.vchar_QueryVerify))
{
MessageBoxService.ShowMessage("检查点查询信息不可为空", "提示信息", MessageButton.OK, MessageIcon.Error);
return;
}
sqlStr = $"SELECT [vchar_QueryVerify] FROM [dbo].[tb_Agent] WHERE [vchar_QueryVerify]='{SelectedAgent.vchar_QueryVerify}'";
IList <Agent> agents = (SQLHelper.GetObject <Agent>(sqlStr)).ToList();
if (agents.Count != 0)
{
Agent agent = agents.FirstOrDefault();
if (SelectedAgent.vchar_QueryVerify == agent.vchar_QueryVerify)
{
MessageBoxService.ShowMessage("与其他商业伙伴查询接口校验码重复，请更换", "提示信息", MessageButton.OK, MessageIcon.Error);
return;
}
}
}
if (SelectedAgent.bit_synPush)
{
if (string.IsNullOrWhiteSpace(SelectedAgent.vchar_PushUser) || string.IsNullOrWhiteSpace(SelectedAgent.vchar_PushVerify))
{
MessageBoxService.ShowMessage("检查点推送信息不可为空", "提示信息", MessageButton.OK, MessageIcon.Error);
return;
}
sqlStr = $"SELECT [vchar_PushUser],[vchar_PushVerify] FROM [dbo].[tb_Agent] WHERE [vchar_PushUser]='{SelectedAgent.vchar_PushUser}' OR [vchar_PushVerify]='{SelectedAgent.vchar_PushVerify}'";
IList <Agent> agents = (SQLHelper.GetObject <Agent>(sqlStr)).ToList();
if (agents.Count != 0)
{
Agent agent = agents.FirstOrDefault();
if (SelectedAgent.vchar_PushUser == agent.vchar_PushUser)
{
MessageBoxService.ShowMessage("与其他商业伙伴推送接口用户重复，请更换", "提示信息", MessageButton.OK, MessageIcon.Error);
return;
}
if (SelectedAgent.vchar_PushVerify == agent.vchar_PushVerify)
{
MessageBoxService.ShowMessage("与其他商业伙伴推送接口校验码重复，请更换", "提示信息", MessageButton.OK, MessageIcon.Error);
return;
}
}
}
#endregion
#region 插入数据
SplashScreenService.ShowSplashScreen();
if (SelectedAgent.int_AGid == 0)
{
if (SelectedAgent.int_AGtype == "检查点提供方")
{
sqlStr = $"INSERT INTO tb_Agent (vchar_AGcode, vchar_AGname, vchar_AGLinkMan, vchar_AGcontect, int_AGtype, bit_synOpen, vchar_synVerify,vchar_synStopKeyWord,int_synSpacing)VALUES ('{SelectedAgent.vchar_AGcode}', N'{SelectedAgent.vchar_AGname}', N'{SelectedAgent.vchar_AGLinkMan}', '{SelectedAgent.vchar_AGcontect}', 0, {(SelectedAgent.bit_synOpen ? 1 : 0)}, '{SelectedAgent.vchar_synVerify}', N'{SelectedAgent.vchar_synStopKeyWord}',{SelectedAgent.int_synSpacing}) ";
}
else if (SelectedAgent.int_AGtype == "检查点查询方")
{
sqlStr = $"INSERT INTO tb_Agent(vchar_AGcode, vchar_AGname, vchar_AGLinkMan, vchar_AGcontect, int_AGtype, bit_synQuery, vchar_QueryVerify)VALUES ('{SelectedAgent.vchar_AGcode}', N'{SelectedAgent.vchar_AGname}',N'{SelectedAgent.vchar_AGLinkMan}', '{SelectedAgent.vchar_AGcontect}', 1, {(SelectedAgent.bit_synQuery ? 1 : 0)}, '{SelectedAgent.vchar_QueryVerify}') ";
}
else if (SelectedAgent.int_AGtype == "检查点推送接收方")
{
sqlStr = $"INSERT INTO tb_Agent(vchar_AGcode, vchar_AGname, vchar_AGLinkMan, vchar_AGcontect, int_AGtype,bit_synPush, vchar_PushUser, vchar_PushVerify) VALUES ('{SelectedAgent.vchar_AGcode}', N'{SelectedAgent.vchar_AGname}', N'{SelectedAgent.vchar_AGLinkMan}', '{SelectedAgent.vchar_AGcontect}', 2, {(SelectedAgent.bit_synPush ? 1 : 0)}, '{SelectedAgent.vchar_PushUser}', '{SelectedAgent.vchar_PushVerify}') ";
}
if (SQLHelper.UpDateSQL(sqlStr))
{
MessageBoxService.ShowMessage("保存成功", "提示信息", MessageButton.OK, MessageIcon.Information);
}
else
{
MessageBoxService.ShowMessage("保存失败", "提示信息", MessageButton.OK, MessageIcon.Error);
}
Agents.Add(SelectedAgent);
}
else
{
if (SelectedAgent.int_AGtype == "检查点提供方")
{
sqlStr = $"UPDATE tb_Agent SET vchar_AGcode = '{SelectedAgent.vchar_AGcode}', vchar_AGname = N'{SelectedAgent.vchar_AGname}', vchar_AGLinkMan = N'{SelectedAgent.vchar_AGLinkMan}', vchar_AGcontect = '{SelectedAgent.vchar_AGcontect}',int_AGtype = 0, bit_synOpen = {(SelectedAgent.bit_synOpen ? 1 : 0)}, vchar_synVerify = '{SelectedAgent.vchar_synVerify}', vchar_synStopKeyWord = N'{SelectedAgent.vchar_synStopKeyWord}', bit_synQuery = 0,vchar_QueryVerify = NULL, bit_synPush = 0, vchar_PushUser = NULL, vchar_PushVerify = NULL,int_synSpacing= {SelectedAgent.int_synSpacing} WHERE [int_AGid]={SelectedAgent.int_AGid}";
}
else if (SelectedAgent.int_AGtype == "检查点查询方")
{
sqlStr = $"UPDATE tb_Agent SET vchar_AGcode = '{SelectedAgent.vchar_AGcode}', vchar_AGname = N'{SelectedAgent.vchar_AGname}', vchar_AGLinkMan = N'{SelectedAgent.vchar_AGLinkMan}', vchar_AGcontect = '{SelectedAgent.vchar_AGcontect}', int_AGtype = 1, bit_synOpen = 0, vchar_synVerify = NULL, vchar_synStopKeyWord = NULL, bit_synQuery = {(SelectedAgent.bit_synQuery ? 1 : 0)}, vchar_QueryVerify = '{SelectedAgent.vchar_QueryVerify}', bit_synPush = 0, vchar_PushUser = NULL, vchar_PushVerify = NULL WHERE [int_AGid]={SelectedAgent.int_AGid}";
}
else if (SelectedAgent.int_AGtype == "检查点推送接收方")
{
sqlStr = $"UPDATE tb_Agent SET vchar_AGcode ='{SelectedAgent.vchar_AGcode}', vchar_AGname = N'{SelectedAgent.vchar_AGname}', vchar_AGLinkMan = N'{SelectedAgent.vchar_AGLinkMan}', vchar_AGcontect ='{SelectedAgent.vchar_AGcontect}',int_AGtype =2, bit_synOpen = 0, vchar_synVerify = NULL, vchar_synStopKeyWord = NULL, bit_synQuery = 0, vchar_QueryVerify = NULL, bit_synPush = {(SelectedAgent.bit_synPush ? 1 : 0)}, vchar_PushUser = '******', vchar_PushVerify = '{SelectedAgent.vchar_PushVerify}' WHERE [int_AGid]={SelectedAgent.int_AGid}";
}
if (SQLHelper.UpDateSQL(sqlStr))
{
MessageBoxService.ShowMessage("保存成功", "提示信息", MessageButton.OK, MessageIcon.Information);
}
else
{
MessageBoxService.ShowMessage("保存失败", "提示信息", MessageButton.OK, MessageIcon.Error);
}
var item = Agents.FirstOrDefault(a => a.int_AGid == SelectedAgent.int_AGid);
if (item != null)
{
item = SelectedAgent;
}
}
SplashScreenService.HideSplashScreen();
#endregion
}
catch (Exception ex)
{
SplashScreenService.HideSplashScreen();
MessageBoxService.ShowMessage($"保存失败:{ex.Message}", "提示信息", MessageButton.OK, MessageIcon.Error);
}
}