private void Close()
{
ConnHelper.CloseConnection(mysqlConn);
if (clientSocket != null)
{
clientSocket.Close();
}
server.RemoveClient(this);
}
protected void btnImportCourse_Click(object sender, EventArgs e)//导入原始授课信息 导入到 原始表
{
Clear();
string department = "";//和表名称是一致的
department = ddlDepartmentName.SelectedItem.ToString();
if (department == "" || department == null)
{
lblMessage2.Text = "部门不能为空！";
}
else
{
if (filecourse.HasFile == true) //有文件，即大小不为0
{
this.KuoZhanName = filecourse.PostedFile.FileName.Substring(filecourse.PostedFile.FileName.LastIndexOf(".") + 1); //扩展名
if (KuoZhanName == "xls" || KuoZhanName == "xlsx")
{
string FinalPathAndName = UpLoad("TeacherInfo\\", filecourse); //传到服务器上
DataTable dt = InsertToSQLServer(FinalPathAndName, department); //获得Excel表，放在dt里，下一步进行
//DBHelper.SQLBulkCopy(dt, "原始表");//参数获得表然后用BulkCopy不做任何字符处理直接导入到数据库的 原始表 中
//拆分 任课教师 拆为 教师工号+教师姓名
//是 " ",不是NULL
DataTable dt1 = InsertToSQLServer(FinalPathAndName, department);
StringBuilder sb = new StringBuilder();
for (int i = 0; i < dt1.Rows.Count; i++)
{
sb.Append(dt1.Rows[i]["任课教师"].ToString()); //所有的 任课教师 列的拼接 [001]张三[002]李四
}
string[] ChaiFen = sb.ToString().Split(new char[] { '[', ']' }, StringSplitOptions.RemoveEmptyEntries); //拆分完了，放在了ChaiFen数组里 偶数工号，奇数姓名
StringBuilder sb1 = new StringBuilder();
/*for (int i = 0; i < ChaiFen.Length; i = i + 2)//导入数据库后数据顺序有些问题，等做完别的拆分，再看看
* {
* sb1.Append("insert into [TabAllCourses](教师工号,教师姓名) values ('" + ChaiFen[i] + "','" + ChaiFen[i + 1] + "');");
* }*/
for (int i = 0; i < dt1.Rows.Count; i++)//因为偶数（包括0）是ID，奇数是Name，所以可以用 2*i 和 2*i+1 表示
{
sb1.Append("insert into [TabAllCourses] values('" + dt1.Rows[i][0].ToString() + "','" + ChaiFen[2 * i].ToString() + "','" + ChaiFen[2 * i + 1].ToString() + "','" + dt1.Rows[i][2].ToString() + "','" + dt1.Rows[i][3].ToString() + "','" + dt1.Rows[i][4].ToString() + "','" + dt1.Rows[i][5].ToString() + "','" + dt1.Rows[i][6].ToString() + "','" + dt1.Rows[i][7].ToString() + "','" + dt1.Rows[i][8].ToString() + "','" + dt1.Rows[i][9].ToString() + "','" + dt1.Rows[i][10].ToString() + "','" + dt1.Rows[i][11].ToString() + "','" + dt1.Rows[i][12].ToString() + "','" + dt1.Rows[i][13].ToString() + "','" + dt1.Rows[i][14].ToString() + "');");
}
ConnHelper.ZSGC(sb1.ToString());//连接数据库导入
lblMessage2.Text = "导入SQLServer数据库成功!";
}
else
{
lblMessage2.Text = "只能上传Excel文件！";
}
}
else
{
lblMessage2.Text = "请先选择Excel文件！";
}
}
}
public static void InsertOrder(OrdersItem order)
{
// 这里应该不会有 SQL 注入问题
string sql = "INSERT INTO orders(orderid,account,money,starttime,endtime,remark,state,userid) VALUES (@orderid,@account,@money,@starttime,@endtime,@remark,@state,@userid)";
MySqlParameter[] sqlParameter = GetParameterArray(new string[] { "@orderid", "@account", "@money", "@starttime", "@endtime", "@remark", "@state", "@userid" },
new object[] { order.OrderId, order.Account, order.Amount, DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss"), DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss"), "", "3", ConfigurationManager.AppSettings["acount"] });
ConnHelper.GetcomPara(sql, sqlParameter);
}
public ClientPeer()
{
this.ReceiveArgs = new SocketAsyncEventArgs();
this.ReceiveArgs.UserToken = this;
this.ReceiveArgs.SetBuffer(new byte[1024], 0, 1024);
this.SendArgs = new SocketAsyncEventArgs();
this.SendArgs.Completed += SendArgs_Completed;
mySqlConn = ConnHelper.Connect();
}
public void Close()
{
ConnHelper.CloseConnection(conn);//关闭数据库的链接
if (clientSocket != null)
{
clientSocket.Close();
}
server.Remove(this);
}
public void Start()
{
serverSocket = new Socket(AddressFamily.InterNetwork, SocketType.Stream, ProtocolType.Tcp);
serverSocket.Bind(ipEndPoint);
serverSocket.Listen(0);
cardEffectDict = ConnHelper.GetCardEffectDict();
buffInfoDict = ConnHelper.GetBuffInfoDict();
allHeroCardDict = ConnHelper.GetAllHeroCardDict();
skillDict = ConnHelper.GetSkillInfoDict();
serverSocket.BeginAccept(AcceptCallBack, null);
}
private void Close()
{
ConnHelper.Close(mySqlCon);
if (clientSocket != null)
{
clientSocket.Close();
}
string key = Util.GetClientKey(ip, port);
server.RemoveClient(key);
}
public void Close()
{
ConnHelper.CloseConnection(sqlConn);
if (clientSocket == null)
{
return;
}
clientSocket.Close();
//从Server类中的List中移除Client对象
server.RemoveClient(this);
}
/// <summary>
/// 批量更新数据表
/// </summary>
/// <param name="dt"></param>
/// <param name="Tname"></param>
/// <returns></returns>
public static bool UpdateDT4Copy(DataTable dt, string Tname)
{
try
{
ConnHelper.SQLBulkCopy(dt, Tname);
return(true);
}
catch (Exception)
{
return(false);
}
}
public static bool InsertTabTeachers(string TabName, string str1, string str2, string str3, string str4, string str5, string str6, string str7, string str8, string str9, string str10, string str11, string str12, string str13, string str14)
{
try
{
ConnHelper.ZSGC("insert into " + TabName + " values('" + str1 + "','" + str2 + "','" + str3 + "','" + str4 + "','" + str5 + "','" + str6 + "','" + str7 + "','" + str8 + "','" + str9 + "','" + str10 + "','" + str11 + "','" + str12 + "','" + str13 + "','" + str14 + "')");
return(true);
}
catch
{
return(false);
}
}
public static bool InsertTabPassword(string UserID, string UserPWD, string Time)
{
try
{
ConnHelper.ZSGC("insert into [TabPassword] values('" + UserID + "','" + UserPWD + "','" + Time + "')");
return(true);
}
catch
{
return(false);
}
}
public static bool InsertTabTeachers(string TabName, string str1, string str2)
{
try
{
ConnHelper.ZSGC("insert into " + TabName + " values('" + str1 + "','" + str2 + "')");
return(true);
}
catch
{
return(false);
}
}
public static bool DeleteTabTeachers(string TabName)
{
try
{
ConnHelper.ZSGC("delete from " + TabName + "");
return(true);
}
catch
{
return(false);
}
}
/// <summary>
/// 清空第一次导入数据库数据
/// </summary>
/// <returns></returns>
public static bool ClearExcel()
{
bool clearTabTeachers, clearTabOtherTeachers, clearTabCalendar, clearTabAllCourses;//记录删除成果
clearTabTeachers = ConnHelper.ExecuteNoneQueryOperation("truncate table TabAllCourses");
clearTabOtherTeachers = ConnHelper.ExecuteNoneQueryOperation("truncate table TabTeachers");
clearTabCalendar = ConnHelper.ExecuteNoneQueryOperation("truncate table TabCalendar");
clearTabAllCourses = ConnHelper.ExecuteNoneQueryOperation("truncate table TabOtherTeachers");
ConnHelper.ExecuteNoneQueryOperation("delete from TabAllCourses");//可找回但速度慢
return(clearTabTeachers && clearTabOtherTeachers && clearTabCalendar && clearTabAllCourses);
}
private void End()
{
if (session != null)
{
session.Close();
session = null;
ConnHelper.Disconnect(mySqlConn);
mySqlConn = null;
OnEnd?.Invoke(this);
ConsoleUtility.WriteLine("Disconnect: " + RemoteEndPoint.ToString(), ConsoleColor.Red);
}
}
private static string AddOrder(ShopCarViewModel shopCarViewModel)
{
string str = "";
var db = ConnHelper.CreateDb();
Random random = new Random();
var orderId = DateTime.Now.ToString("yyyyMMddHHmmssfff") + random.Next(0, 9);
List <GoodsMessage> items;
if (shopCarViewModel.CardInfo.Count == 0)
{
items = shopCarViewModel.TicketInfo;
str = "购买票";
}
else
{
items = shopCarViewModel.CardInfo;
str = "购买年卡";
}
foreach (var item in items)
{
if (item.SumCount == 0)
{
continue;
}
var orderInfoEntity = new Order_Info();
orderInfoEntity.ClassID = item.ClassId;
orderInfoEntity.Cred = "身份证";
orderInfoEntity.CredNo = shopCarViewModel.UserInfo.UserCard;
orderInfoEntity.Cren = 0;
orderInfoEntity.Email = "";
orderInfoEntity.Isfs = 0;
orderInfoEntity.IsLingPiao = 0;
orderInfoEntity.Lren = 0;
orderInfoEntity.Mobile = shopCarViewModel.UserInfo.Phone;
orderInfoEntity.MunPrice = item.SumPrice;
orderInfoEntity.OrderID = orderId;
orderInfoEntity.RTime = shopCarViewModel.UserInfo.GoDate.ToShortDateString();
orderInfoEntity.Rtong = item.SumCount;
orderInfoEntity.State = 0;
orderInfoEntity.Ticket = shopCarViewModel.UserInfo.Name;
orderInfoEntity.Ticketer = shopCarViewModel.UserInfo.Name;
orderInfoEntity.Type = 0;
orderInfoEntity.AddTime = DateTime.Now;
orderInfoEntity.Detail = "手机网站";
orderInfoEntity.IsPost = 0;
orderInfoEntity.IsSMPost = 0;
db.Order_Info.Add(orderInfoEntity);
}
db.SaveChanges();
LogHelper.CreateLog("游客开始在官方网站下订单->当前未支付！(" + str + ")", orderId.ToString());
return(orderId.ToString());
}
private void Close()
{
ConnHelper.CloseConnection(mysqlConn);//关闭数据库连接
if (clientSocket != null)
{
clientSocket.Close(); //关闭了clientSocket还需要关闭服务端对客户端的管理的引用,我们在Server类添加一个移出对客户端的引用
}
if (room != null) //关闭房间需要在移出客户端志强，防止一些客户端类方法的调用 2019年10月7日
{
room.CloseRoom(this);
}
server.RemoveClient(this);
}
private void Close()
{
ConnHelper.CloseConnection(mysqlConn);
if (clientSocket != null)
{
clientSocket.Close();
}
if (room != null)
{
room.QuitRoom(this);
}
server.RemoveClient(this); //移除自身
}
//释放当前套接字
public void Close()
{
ConnHelper.CloseConnection(mySqlConn);//释放与数据库的连接
if (clientSocket != null)
{
clientSocket.Close();//关闭套接字
}
if (room != null)
{
room.QuitRoom(this); //将当前客户端移除房间
}
server.RemoveClient(this); //销毁当前Client对象
}
private void Close()
{
if (ClientSocket != null)
{
ClientSocket.Close();
if (room != null)
{
room.ClientQuitRoom(this);
}
server.RemoveClient(this);
ConnHelper.CloseConnect(mySqlConnection);
Console.WriteLine("客户端关闭");
}
}
public ClientPeer(Socket _socket, MainServer _server)
{
mMsg = new MessageTool();
mClientSock = _socket;
this.mServer = _server;
mMysqlConn = ConnHelper.Connect();
ImgPathDic = new Dictionary <int, string>()
{
{ 1001, "iiefrqwrief" },
{ 1002, "iiefrqwrief" },
{ 1003, "iiefrqwrief" },
{ 1004, "iiefrqwrief" },
};
}
/// <summary>
/// 关闭会话
/// </summary>
public void Close()
{
try
{
ConnHelper.CloseConnection(mMysqlConn);
//关闭数据的接受和发送
mClientSock.Shutdown(SocketShutdown.Both);
}
catch (Exception) { }
if (mClientSock != null)
{
mClientSock.Close();
}
}
// This method gets called by the runtime. Use this method to add services to the container.
public void ConfigureServices(IServiceCollection services)
{
services.AddHangfire(x => x.UsePostgreSqlStorage(ConnHelper.GetConnectionString(YamlConfiguration.Config.Postgres.DatabaseNames.Hangfire)));
services.AddHangfireServer();
services.AddTransient <HttpClient>();
services.AddTransient <DataRetrievalService>();
services.AddTransient <FootballDataApiRetrievalService>();
services.AddTransient <ApiFootballRetrievalService>();
services.AddTransient <PlayerRetriever>();
services.AddTransient <FootballDataRetriever>();
services.AddTransient <FootballDataUpdaterService>();
services.AddTransient <PlayerUpdaterService>();
services.AddMvc().SetCompatibilityVersion(CompatibilityVersion.Version_2_2);
}
//public static DataTable IsLogin(string strUsername,string strUserPwd)
//{
// string strSQL = "select * from myConn where (username='******' and userpassword='******')";
// DataTable dt = ConnHelper.getDT(strSQL);
// return dt;
//}
//public static DataTable Reboll(string strSQL)
//{
// DataTable dt = ConnHelper.getDT(strSQL);
// return dt;
//}
public static int check(string name, string password)
{
string strSQL = "select * from myConn where username='******'";
DataTable dt = ConnHelper.getDT(strSQL);
if (dt.Rows[0]["username"].ToString() == name && dt.Rows[0]["userpassword"].ToString() == password)
{
return((int)dt.Rows[0]["ID"]);
}
else
{
return(5);
}
}
/// <summary>
/// 客户端与服务器端断开连接
/// </summary>
private void Close()
{
ConnHelper.CloseConnDB(mysqlConn);
if (clientScoket != null)
{
clientScoket.Close();
}
if (room != null)
{
room.QuitRoom(this);
}
//Socket要最后关
server.RemoveClient(this);
}
private void Close()
{
ConnHelper.CloseConnection(mysqlConn);
if (clientSocket != null)
{
clientSocket.Close();
}
if (room != null)
{
room.QuitRoom(this);
}
server.RemoveClient(this);
Console.WriteLine("当前客户端数量：{0}", server.clientList.Count);
}
////粘包拆包问题 ： 解决决策 ：消息头和消息尾。
//// 比如 发送的数据： 12345
//void test()
//{
// byte[] bt = Encoding.Default.GetBytes("12345");
// //怎么构造
// //头：消息的长度 bt.Length
// //尾：具体的消息 bt
// int length = bt.Length;
// byte[] bt1 = BitConverter.GetBytes(length);
// //得到消息就是：bt1 + bt
// ///怎么读取
// //int length = 前四个字节转成int类型
// //然后读取 这个长度的数据
//}
#endregion
#region 断开连接
/// <summary>
/// 断开连接
/// </summary>
public void Disconnect()
{
//清空数据
dataCache.Clear();
isReceiveProcess = false;
sendQueue.Clear();
isSendProcess = false;
ClientSocket.Shutdown(SocketShutdown.Both);
ClientSocket.Close();
ClientSocket = null;
ConnHelper.CLose(mySqlConn);
}
/// <summary>
/// 更新订单的状态信息
///
/// 更新最后的时间和状态，根据订单编号
/// </summary>
/// <param name="order"></param>
public static void UpdateOrder(OrdersItem order, string state, string remark)
{
// 这里应该不会有 SQL 注入问题
string sql = "UPDATE orders SET endtime=@endtime,remark=@remark,state=@state WHERE orderid=@orderid";
MySqlParameter[] sqlParameter = GetParameterArray(new string[] { "@endtime", "@remark", "@state", "@orderid" },
new object[] { DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss"), remark, state, order.OrderId });
ConnHelper.GetcomPara(sql, sqlParameter);
//string sql = "UPDATE orders SET account=@account,money=@money,endtime=@endtime,remark=@remark,state=@state WHERE orderid=@orderid";
//MySqlParameter[] sqlParameter = getParameterArray(new string[] { "@account", "@money", "@endtime", "@remark", "@state", "@orderid" },
//new object[] { order.Account, order.Amount, DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss"), "", state, order.OrderId });
}
/// <summary>
/// 断开与服务器的连接
/// </summary>
private void CloseConnectionWithServer()
{
//先关闭和数据库的连接
ConnHelper.CloseConnetcion(MysqlConn);
if (_clientSocket != null)
{
//关闭与服务器的连接，并从服务器连接客户端列表中移除
_clientSocket.Close();
_currentServer.RemoveClientFromClientList(this);
}
if (currentEnteredRoom != null)
{
//移除该Client的房间
currentEnteredRoom.Close(this);
}
}
public void Start()
{
try
{
sqlConn = ConnHelper.Connect();
serverSocket = new Socket(AddressFamily.InterNetwork
, SocketType.Stream, ProtocolType.Tcp);
serverSocket.Bind(ipEndPoint);
serverSocket.Listen(0);
serverSocket.BeginAccept(AcceptCallBack, null);
}
catch (Exception e)
{
Console.WriteLine("服务器启动失败：" + e);
}
}
