public void Save(TPackage package)
{
IDictionary <string, string> dict = getParameterList();
foreach (KeyValuePair <string, string> item in dict)
{
PropertyInfo pinfo = package.GetType().GetProperty(item.Key.Substring(1));
if (pinfo != null)
{
_command.Parameters[item.Key].Value = pinfo.GetValue(package, null);
}
}
try
{
if (_connection.State != ConnectionState.Open)
{
_connection.Open();
}
_command.ExecuteNonQuery();
_connection.Close();
}
catch (SqlException ex)
{
Toos.Msg_Error("错误:SQL数据库{0}\n", ex.Message);
}
catch (Exception exp)
{
Toos.Msg_Error("错误:{0}!\n", exp.ToString());
}
}
public IActionResult Edit([FromBody] CrudViewModel <TPackage> payload)
{
TPackage package = payload.value;
_context.TPackage.Update(package);
_context.SaveChanges();
return(Ok(package));
}
public IActionResult Remove([FromBody] CrudViewModel <TPackage> payload)
{
TPackage package = _context.TPackage
.Where(x => x.packageID == (int)payload.key)
.FirstOrDefault();
_context.TPackage.Remove(package);
_context.SaveChanges();
return(Ok(package));
}
public void ThreadCallBack(Object obj)
{
_clinet = obj as ThreadTcpClinet;
_networkstream = _clinet.TcpClinet.GetStream();
_formatter = new BinaryFormatter();
bool running = true;
TSqlAdapter SqlAdapter = new TSqlAdapter();
try
{
while (running)
{
_package = (TPackage)_formatter.Deserialize(
_networkstream);
if (_package.MagicId == 0)
{
running = false;
Toos.Msg_Warn("客户端{0:D5}[{1}]请求结束会话\n",
_clinet.ThreadId, _clinet.TcpClinet.Client.RemoteEndPoint.ToString());
break;
}
SqlAdapter.Save(_package);
Toos.Msg_Message("{0}=>{1}#{2};{3};{4}\n",
_clinet.TcpClinet.Client.RemoteEndPoint.ToString(),
Toos.GetLocalIP(), _package.NickFrom, _package.NickTo, _package.Text);
}
}
catch (Exception ex)
{
Toos.Msg_Error("错误:{0}\n", ex.StackTrace);
}
finally
{
Toos.Msg_Warn("线程{0:D5},远程{1} 结束 [OK] .\n",
_clinet.ThreadId, _clinet.TcpClinet.Client.RemoteEndPoint.ToString());
_networkstream.Close();
}
}
public void Dispose()
{
if (Builder != null)
{
BlockParser.ReturnStringBuilder(Builder);
Builder = null;
}
if (ContentBuilder != null)
{
BlockParser.ReturnStringBuilder(ContentBuilder);
ContentBuilder = null;
}
PrefixPriorities = null;
Rules = null;
Generator = null;
TagDelimiters = null;
Cache = null;
Package = null;
CurrentBlock = null;
}
public static void Main(string[] args)
{
string ipString;
int port = 8888;
TPackage _package;
IFormatter _formater = new BinaryFormatter();
NetworkStream _networkstream;
Random rand = new Random();
IPAddress ipaddress = new IPAddress(0);
if (args.Length > 0 && IPAddress.TryParse(args[0], out ipaddress))
{
ipString = args[0];
Toos.Msg_Message("远程服务器地址:{0}", ipString);
}
else
{
Toos.Msg_Message("请输远程服务器地址:");
ipString = Console.ReadLine();
}
TcpClient clinet = new TcpClient();
clinet.Connect(new IPEndPoint(IPAddress.Parse(ipString), port));
Toos.Msg_Message("发送超时：{0:D}；接受超时{1:D}", clinet.SendTimeout, clinet.ReceiveTimeout);
_networkstream = clinet.GetStream();
Toos.Msg_Error("正在连接{0}:{1} ...\n", ipString, port);
Toos.Msg_Message("程序运行中按任意键退出:D\n");
while (!Console.KeyAvailable)
{
_package = new TPackage()
{
NickFrom = "发送:" + rand.Next(),
NickTo = "接收:" + rand.Next(),
Text = "数据:" + rand.Next(),
QQTo = rand.Next().ToString(),
QQFrom = rand.Next().ToString(),
DTime = DateTime.Now,
MagicId = 1
};
System.Threading.Thread.Sleep(500);
try
{
_formater.Serialize(_networkstream, _package);
Toos.Msg_Message("{0}=>{1}#{2};{3};{4}\n",
Toos.GetLocalIP(),
ipString, _package.NickFrom, _package.NickTo, _package.Text);
}
catch (Exception ex)
{
Toos.Msg_Error("错误:{0}\n", ex.Message);
}
}
//发送魔术包！
_package = new TPackage()
{
NickFrom = "准备" + rand.Next(),
NickTo = "结束" + rand.Next(),
Text = "通讯" + rand.Next(),
DTime = DateTime.Now,
MagicId = 0
};
_formater.Serialize(_networkstream, _package);
_networkstream.Close();
clinet.Close();
}