private void button2_Click(object sender, EventArgs e)
{
if (textBox1.Text == string.Empty)
{
MessageBox.Show(@"新密码不能为空!");
return;
}
try
{
TYDB.TySqLite.Init(out var err);
if (err != string.Empty)
{
MessageBox.Show(err);
}
else
{
if (TYDB.TySqLite.ChangePwd(textBox1.Text))
{
MessageBox.Show(@"密码修改成功!");
}
TyLog.Wlog($@"修改数据库密码为:{textBox1.Text}", false);
}
}
catch (Exception exception)
{
MessageBox.Show(exception.Message);
TyLog.Wlog(exception);
}
}
public void TestInsert( )
{
var k = 0;
for (var i = 0; i < 100; i++)
{
Task.Factory.StartNew(() =>
{
try
{
GlobalVar.DbHelper.BeginTransaction();
var model = new BS_Template
{
id = Guid.NewGuid().ToString(),
code = k.ToString(),
name = "测试" + k,
remarks = "测试" + k,
type = "1"
};
Insert(model);
GlobalVar.DbHelper.CommitTransaction();
k++;
}
catch (Exception ex)
{
GlobalVar.DbHelper.RollbackTransaction();
TyLog.WriteError(ex.Message);
}
});
}
}
/// <summary>
/// 测试数据库连接情况
/// </summary>
private static bool Test()
{
try
{
Query("select name from sqlite_master");
return(true);
}
catch (Exception ex)
{
TyLog.Wlog(ex);
throw new Exception("连接数据库异常:" + ex.Message);
}
}
/// <summary>
/// 修改数据库密码
/// </summary>
/// <param name="pwd">不给此参数是删除密码</param>
/// <returns></returns>
public static bool ChangePwd(string pwd = "")
{
using (SQLiteConnection conn = GetSqLiteConnection())
{
try
{
conn.Open();
conn.ChangePassword(pwd);
}
catch (Exception ex)
{
TyLog.Wlog(ex);
throw new Exception("连接数据库异常:" + ex.Message);
}
}
return(true);
}
//测试删除
public void TestDelete(string[] ids)
{
try
{
GlobalVar.DbHelper.BeginTransaction();
foreach (var t in ids)
{
Del(t);
}
GlobalVar.DbHelper.CommitTransaction();
}
catch (Exception ex)
{
GlobalVar.DbHelper.RollbackTransaction();
TyLog.WriteError(ex.Message);
}
}
private static string ReflexFunction(string functionName, string jsonData)
{
string responseStr;
try
{
var dll = Environment.CurrentDirectory + @"\TYService.dll";
const string className = @"TYService.Index";
var assembly = Assembly.LoadFile(dll);
var type = assembly.GetType(className);
responseStr = $@"1|{(string)type.InvokeMember(functionName, BindingFlags.Default | BindingFlags.InvokeMethod, null, null, new object[] { jsonData })}";
}
catch (Exception e)
{
TyLog.Wlog(e);
responseStr = $@"0|TYService.Index.{functionName} 未找到 请确认在程序根目录存在TYService.dll 并且其中Index类中存在方法{functionName}";
}
return(responseStr);
}
//发送消息到服务器接收反馈
private bool Send(string message, out string refData, out IPAddress ip)
{
try
{
var requestData = Encoding.UTF8.GetBytes(message);
_client.Send(requestData, requestData.Length, new IPEndPoint(ServiceIp, 2875));
var serverEp = new IPEndPoint(IPAddress.Broadcast, 0);
var serverResponseData = _client.Receive(ref serverEp);
ip = serverEp.Address;
refData = Encoding.UTF8.GetString(serverResponseData);
return(true);
}
catch (Exception ex)
{
TyLog.Wlog(ex);
ip = IPAddress.Broadcast;
refData = ex.ToString();
return(false);
}
}
//执行方法 json形式
public string Fun(string functionName, string jsonData)
{
string responseStr;
var serviceName = System.Configuration.ConfigurationManager.AppSettings["ServiceName"];
try
{
var dll = AppDomain.CurrentDomain.BaseDirectory + $@"{serviceName}.dll";
var className = $@"{serviceName}.Index";
var assembly = Assembly.LoadFile(dll);
var type = assembly.GetType(className);
responseStr = $@"{(string)type.InvokeMember(functionName, BindingFlags.Default | BindingFlags.InvokeMethod, null, null, new object[] { jsonData })}";
}
catch (Exception e)
{
TyLog.WriteError(e);
responseStr = string.Empty;
}
return(responseStr);
}
//测试修改
public void TestUpdate(List <BS_Template> lb)
{
var rnd = new Random();
try
{
//GlobalVar.DbHelper.BeginTransaction();
foreach (var t in lb)
{
t.remarks = "测试" + rnd.Next(1, 9999).ToString("0000");
Update(t);
}
//GlobalVar.DbHelper.CommitTransaction();
}
catch (Exception ex)
{
GlobalVar.DbHelper.RollbackTransaction();
TyLog.WriteError(ex.Message);
}
}
private static void Main()
{
TyCore.DeleteExit();//禁用关闭按钮
if (!File.Exists(AppDomain.CurrentDomain.BaseDirectory + "TYExServiceCore.exe.config"))
{
File.WriteAllText(AppDomain.CurrentDomain.BaseDirectory + "TYExServiceCore.exe.config", Properties.Resources.TYExServiceCore_exe);
}
var host = new ServiceHost(typeof(TyService));
host.Opened += delegate
{
Console.WriteLine($@"服务已开启 ... ... {Environment.NewLine}时间:{DateTime.Now}");
};
host.Closed += delegate
{
Console.WriteLine($@"服务已关闭 ... ...{Environment.NewLine}时间:{DateTime.Now}");
};
try
{
host.Open();
if (ConfigurationManager.AppSettings["ServiceDeBug"] == "false")
{
TyCore.ShowConsole(0);
TyCore.AutoStart(@"TYExServiceCore");
}
}
catch (Exception e)
{
Console.WriteLine(@"服务开启异常,请检查服务器配置!");
TyLog.WriteError(e);
Console.Read();
return;
}
while (true)
{
Console.Read();
}
}
private void button1_Click(object sender, EventArgs e)
{
try
{
TYDB.TySqLite.Init(out var err); if (err != string.Empty)
{
MessageBox.Show(err);
}
else
{
if (!TYDB.TySqLite.ChangePwd())
{
return;
}
MessageBox.Show(@"密码删除成功!");
TyLog.Wlog(@"数据库密码删除成功", false);
}
}
catch (Exception exception)
{
MessageBox.Show(exception.Message);
TyLog.Wlog(exception);
}
}
/// <summary>
/// 服务开启
/// </summary>
public static void ServiceOpen()
{
//标识UDP信息的加密GUID
const string broadcastMsg = "825C7B29-5B62-4242-AF76-EBDB489A6090";
//------这里检查局域网内是否开启了多个服务器
var client = new UdpClient
{
Client = { ReceiveTimeout = 1000 },
EnableBroadcast = true
};
IPAddress ip;
var refData = string.Empty;
try
{
var requestData = Encoding.UTF8.GetBytes($"{broadcastMsg}|GetServiceIp");
client.Send(requestData, requestData.Length, new IPEndPoint(IPAddress.Broadcast, 2875));
var serverEp = new IPEndPoint(IPAddress.Broadcast, 0);
var serverResponseData = client.Receive(ref serverEp);
ip = serverEp.Address;
refData = Encoding.UTF8.GetString(serverResponseData);
}
catch
{
ip = IPAddress.Broadcast;
}
if (!ip.Equals(IPAddress.Broadcast) && refData.Equals("true"))
{
Console.Write($@"当前局域网内已有服务器运行{Environment.NewLine}若要以当前机器为服务器请关闭 {ip} 上的服务器程序 !");
Console.Read();
return;
}
//------检查完毕
//服务器默认端口
var server = new UdpClient(2875);
Console.Write("服务器运行中 ... ");
//服务器端死循环监控消息
while (true)
{
try
{
var clientEp = new IPEndPoint(IPAddress.Any, 0);
var clientRequestData = server.Receive(ref clientEp);
var clientRequest = Encoding.UTF8.GetString(clientRequestData);
if (string.IsNullOrWhiteSpace(clientRequest))
{
continue;
}
var tmp = clientRequest.Split('|');
if (tmp[0] != broadcastMsg)
{
continue;
}
if (tmp[1] == "GetServiceIp")
{
var responseData = Encoding.UTF8.GetBytes("true");
server.Send(responseData, responseData.Length, clientEp);
}
else
{
OnCallback?.Invoke(tmp[1], tmp[2]);
var responseData = Encoding.UTF8.GetBytes(ReflexFunction(tmp[1], tmp[2]));
server.Send(responseData, responseData.Length, clientEp);
}
}
catch (Exception e)
{
Console.Write("服务器异常,详细错误请看日志文件 !");
TyLog.Wlog(e);
return;
}
}
}
