public static void SIN(Socket accept)
        {
            byte[] receive = new byte[1024];
            byte[] clear_Receive;
            string back_Code            = "";
            MySQLConnectionClass mySQLC = new MySQLConnectionClass();

            accept.Send(Encoding.UTF8.GetBytes("OK"));
            journal += "\n" + DateTime.Now.ToString() + ":";
            journal += accept.RemoteEndPoint.ToString() + ",Action:Send 'OK'\n";
            int len = accept.Receive(receive);

            clear_Receive = receive.Take(len).ToArray();
            back_Code     = Encoding.UTF8.GetString(clear_Receive);
            journal      += "\n" + DateTime.Now.ToString() + ":";
            journal      += accept.RemoteEndPoint.ToString() + ",Action:Receive '" + back_Code + "'\n";
            string[] tmp         = back_Code.Split("#");
            int      user_Id     = Convert.ToInt32(tmp[0]);
            bool     is_Password = mySQLC.is_Password(user_Id, tmp[1]);

            if (is_Password)
            {
                accept.Send(Encoding.UTF8.GetBytes("OK"));
                journal += "\n" + DateTime.Now.ToString() + ":";
                journal += accept.RemoteEndPoint.ToString() + ",Action:Send 'OK'\n";
            }
            else
            {
                accept.Send(Encoding.UTF8.GetBytes("NO"));
                journal += "\n" + DateTime.Now.ToString() + ":";
                journal += accept.RemoteEndPoint.ToString() + ",Action:Send 'NO'\n";
            }
            mySQLC.stop_Connect_To_DB();
        }
        public static void RSW(Socket accept)
        {
            byte[] receive = new byte[1024];
            byte[] clear_Receive;
            int    data_Count           = 0;
            string back_Code            = "";
            MySQLConnectionClass mySQLC = new MySQLConnectionClass();

            accept.Send(Encoding.UTF8.GetBytes("OK"));
            journal += "\n" + DateTime.Now.ToString() + ":";
            journal += accept.RemoteEndPoint.ToString() + ",Action:Send 'OK'\n";
            int len = accept.Receive(receive);

            clear_Receive = receive.Take(len).ToArray();
            back_Code     = Encoding.UTF8.GetString(clear_Receive);
            journal      += "\n" + DateTime.Now.ToString() + ":";
            journal      += accept.RemoteEndPoint.ToString() + ",Action:Receive '" + back_Code + "'\n";
            string[] tmp                  = back_Code.Split("#");
            string   temp_Name            = tmp[0];
            int      temp_Data_Set_Serial = Convert.ToInt32(tmp[1]);
            int      temp_Item_Count      = Convert.ToInt32(tmp[2]);
            int      temp_Cubage          = Convert.ToInt32(tmp[3]);
            int      temp_Max_Result      = Convert.ToInt32(tmp[4]);

            try
            {
                mySQLC.write_To_resultsurface(temp_Name, temp_Data_Set_Serial, temp_Item_Count, temp_Cubage, temp_Max_Result);
            }catch (Exception e)
            {
            }
            accept.Send(Encoding.UTF8.GetBytes("OK"));

            journal += "\n" + DateTime.Now.ToString() + ":";
            journal += accept.RemoteEndPoint.ToString() + ",Action:Send 'OK'\n";
        }
        public static void DSD(Socket accept)
        {
            byte[] receive = new byte[1024];
            byte[] clear_Receive;
            string back_Code            = "";
            MySQLConnectionClass mySQLC = new MySQLConnectionClass();

            accept.Send(Encoding.UTF8.GetBytes("OK"));
            journal += "\n" + DateTime.Now.ToString() + ":";
            journal += accept.RemoteEndPoint.ToString() + ",Action:Send 'OK'\n";
            int len = accept.Receive(receive);

            clear_Receive = receive.Take(len).ToArray();
            back_Code     = Encoding.UTF8.GetString(clear_Receive);
            journal      += "\n" + DateTime.Now.ToString() + ":";
            journal      += accept.RemoteEndPoint.ToString() + ",Action:Receive '" + back_Code + "'\n";
            string[] tmp             = back_Code.Split("#");
            string   file_Name       = tmp[0];
            int      data_Set_Serial = Convert.ToInt32(tmp[1]);

            mySQLC.delete_Data_Set_Data(file_Name, data_Set_Serial);
            accept.Send(Encoding.UTF8.GetBytes("OK"));
            journal += "\n" + DateTime.Now.ToString() + ":";
            journal += accept.RemoteEndPoint.ToString() + ",Action:Send 'OK'\n";
        }
Beispiel #4
0
 public Form1()
 {
     InitializeComponent();
     networkReceptionData = new NetworkReceptionData();
     ThreadPool.QueueUserWorkItem((obj) =>
     {
         MySQLConnectionClass mySQL = new MySQLConnectionClass();
         networkReceptionData.start_Listen_From_Client();
     });
 }
        public static void DSR(Socket accept)
        {
            byte[] receive = new byte[1024];
            byte[] clear_Receive;
            string back_Code            = "";
            MySQLConnectionClass mySQLC = new MySQLConnectionClass();

            accept.Send(Encoding.UTF8.GetBytes("OK"));
            journal += "\n" + DateTime.Now.ToString() + ":";
            journal += accept.RemoteEndPoint.ToString() + ",Action:Send 'OK'\n";
            int len = accept.Receive(receive);

            clear_Receive = receive.Take(len).ToArray();
            back_Code     = Encoding.UTF8.GetString(clear_Receive);
            journal      += "\n" + DateTime.Now.ToString() + ":";
            journal      += accept.RemoteEndPoint.ToString() + ",Action:Receive '" + back_Code + "'\n";
            string[] tmp             = back_Code.Split("#");
            string   file_Name       = tmp[0];
            int      data_Set_Serial = Convert.ToInt32(tmp[1]);

            accept.Send(Encoding.UTF8.GetBytes("OK"));
            journal      += "\n" + DateTime.Now.ToString() + ":";
            journal      += accept.RemoteEndPoint.ToString() + ",Action:Send 'OK'\n";
            len           = accept.Receive(receive);
            clear_Receive = receive.Take(len).ToArray();
            back_Code     = Encoding.UTF8.GetString(clear_Receive);
            journal      += "\n" + DateTime.Now.ToString() + ":";
            journal      += accept.RemoteEndPoint.ToString() + ",Action:Receive '" + back_Code + "'\n";
            if (back_Code.Equals("OK"))
            {
                using (MySqlDataReader reader = mySQLC.get_Data_Set_Reader(file_Name, data_Set_Serial))
                {
                    while (reader.Read() && back_Code.Equals("OK"))
                    {
                        string send = reader.GetString("ItemSetSerial") + "#";
                        send += reader.GetString("Profit") + "#";
                        send += reader.GetString("Weight") + "#";
                        send += reader.GetString("Radio");
                        accept.Send(Encoding.UTF8.GetBytes(send));
                        journal      += "\n" + DateTime.Now.ToString() + ":";
                        journal      += accept.RemoteEndPoint.ToString() + ",Action:Send '" + send + "'\n";
                        len           = accept.Receive(receive);
                        clear_Receive = receive.Take(len).ToArray();
                        back_Code     = Encoding.UTF8.GetString(clear_Receive);
                        journal      += "\n" + DateTime.Now.ToString() + ":";
                        journal      += accept.RemoteEndPoint.ToString() + ",Action:Receive '" + back_Code + "'\n";
                    }
                    accept.Send(Encoding.UTF8.GetBytes("NO"));
                    journal += "\n" + DateTime.Now.ToString() + ":";
                    journal += accept.RemoteEndPoint.ToString() + ",Action:Send 'NO'\n";
                }
            }
        }
        public static void RSR(Socket accept)
        {
            byte[] receive = new byte[1024];
            byte[] clear_Receive;
            string back_Code            = "";
            MySQLConnectionClass mySQLC = new MySQLConnectionClass();

            accept.Send(Encoding.UTF8.GetBytes("OK"));
            journal += "\n" + DateTime.Now.ToString() + ":";
            journal += accept.RemoteEndPoint.ToString() + ",Action:Send 'OK'\n";
            int len = accept.Receive(receive);

            journal      += "\n" + DateTime.Now.ToString() + ":";
            journal      += accept.RemoteEndPoint.ToString() + ",Action:Receive '" + back_Code + "'\n";
            clear_Receive = receive.Take(len).ToArray();
            back_Code     = Encoding.UTF8.GetString(clear_Receive);
            string[] tmp             = back_Code.Split("#");
            string   file_Name       = tmp[0];
            int      data_Set_Serial = Convert.ToInt32(tmp[1]);

            using (MySqlDataReader reader = mySQLC.get_Result_Surface_Reader(file_Name, data_Set_Serial))
            {
                if (reader.Read())
                {
                    accept.Send(Encoding.UTF8.GetBytes("OK"));
                    journal      += "\n" + DateTime.Now.ToString() + ":";
                    journal      += accept.RemoteEndPoint.ToString() + ",Action:Send 'OK'\n";
                    len           = accept.Receive(receive);
                    clear_Receive = receive.Take(len).ToArray();
                    back_Code     = Encoding.UTF8.GetString(clear_Receive);
                    journal      += "\n" + DateTime.Now.ToString() + ":";
                    journal      += accept.RemoteEndPoint.ToString() + ",Action:Receive '" + back_Code + "'\n";
                    if (back_Code.Equals("OK"))
                    {
                        int    temp_Item_Count = Convert.ToInt32(reader.GetString("ItemCount"));
                        int    temp_Cubage     = Convert.ToInt32(reader.GetString("Cubage"));
                        int    temp_Max_Result = Convert.ToInt32(reader.GetString("MaxResult"));
                        string send_Message    = temp_Item_Count.ToString() + "#";
                        send_Message += temp_Cubage.ToString() + "#";
                        send_Message += temp_Max_Result.ToString();
                        accept.Send(Encoding.UTF8.GetBytes(send_Message));
                        journal += "\n" + DateTime.Now.ToString() + ":";
                        journal += accept.RemoteEndPoint.ToString() + ",Action:Send '" + send_Message + "'\n";
                    }
                }
                else
                {
                    accept.Send(Encoding.UTF8.GetBytes("NO"));
                    journal += "\n" + DateTime.Now.ToString() + ":";
                    journal += accept.RemoteEndPoint.ToString() + ",Action:Send 'NO'\n";
                }
            }
        }
        public static void DSW(Socket accept)
        {
            byte[] receive = new byte[1024];
            byte[] clear_Receive;
            int    data_Count           = 0;
            string back_Code            = "";
            MySQLConnectionClass mySQLC = new MySQLConnectionClass();

            accept.Send(Encoding.UTF8.GetBytes("OK"));
            journal += "\n" + DateTime.Now.ToString() + ":";
            journal += accept.RemoteEndPoint.ToString() + ",Action:Send 'OK'\n";
            int len = accept.Receive(receive);

            clear_Receive = receive.Take(len).ToArray();
            back_Code     = Encoding.UTF8.GetString(clear_Receive);
            journal      += "\n" + DateTime.Now.ToString() + ":";
            journal      += accept.RemoteEndPoint.ToString() + ",Action:Receive '" + back_Code + "'\n";
            data_Count    = Convert.ToInt32(back_Code);
            accept.Send(Encoding.UTF8.GetBytes("OK"));
            journal += "\n" + DateTime.Now.ToString() + ":";
            journal += accept.RemoteEndPoint.ToString() + ",Action:Send 'OK'\n";
            for (int i = 0; i < data_Count; i++)
            {
                len           = accept.Receive(receive);
                clear_Receive = receive.Take(len).ToArray();
                back_Code     = Encoding.UTF8.GetString(clear_Receive);
                journal      += "\n" + DateTime.Now.ToString() + ":";
                journal      += accept.RemoteEndPoint.ToString() + ",Action:Receive '" + back_Code + "'\n";
                string[] tmp                  = back_Code.Split("#");
                string   temp_Name            = tmp[0];
                int      temp_Data_Set_Serial = Convert.ToInt32(tmp[1]);
                int      temp_Item_Set_Serial = Convert.ToInt32(tmp[2]);
                int      temp_Profit          = Convert.ToInt32(tmp[3]);
                int      temp_Weight          = Convert.ToInt32(tmp[4]);
                decimal  temp_Radio           = Convert.ToDecimal(tmp[5]);
                try
                {
                    mySQLC.write_To_Data_Set_DB(temp_Name, temp_Data_Set_Serial, temp_Item_Set_Serial, temp_Profit, temp_Weight, temp_Radio);
                }
                finally
                {
                    accept.Send(Encoding.UTF8.GetBytes("OK"));
                    journal += "\n" + DateTime.Now.ToString() + ":";
                    journal += accept.RemoteEndPoint.ToString() + ",Action:Send 'OK'\n";
                }
            }
        }
        public static void REG(Socket accept)
        {
            byte[] receive = new byte[1024];
            byte[] clear_Receive;
            MySQLConnectionClass mySQLC = new MySQLConnectionClass();
            string back_Code            = "";

            accept.Send(Encoding.UTF8.GetBytes("OK"));
            journal += "\n" + DateTime.Now.ToString() + ":";
            journal += accept.RemoteEndPoint.ToString() + ",Action:Send 'OK'\n";
            int len = accept.Receive(receive);

            clear_Receive = receive.Take(len).ToArray();
            back_Code     = Encoding.UTF8.GetString(clear_Receive);
            journal      += "\n" + DateTime.Now.ToString() + ":";
            journal      += accept.RemoteEndPoint.ToString() + ",Action:Receive '" + back_Code + "'\n";
            string[] tmp           = back_Code.Split("#");
            string   temp_Name     = tmp[0];
            int      temp_ID       = Convert.ToInt32(tmp[1]);
            string   temp_Password = tmp[2];

            bool have = mySQLC.search_User(temp_ID);

            if (have)
            {
                accept.Send(Encoding.UTF8.GetBytes("NO"));

                journal += "\n" + DateTime.Now.ToString() + ":";
                journal += accept.RemoteEndPoint.ToString() + ",Action:Send 'NO'\n";
                return;
            }
            else
            {
                mySQLC.write_To_usertable(temp_Name, temp_ID, temp_Password);
                accept.Send(Encoding.UTF8.GetBytes("OK"));
                journal += "\n" + DateTime.Now.ToString() + ":";
                journal += accept.RemoteEndPoint.ToString() + ",Action:Send 'OK'\n";
            }
            mySQLC.stop_Connect_To_DB();
        }
        public string[] get_Result_Items()
        {
            MySQLConnectionClass mySQLC = new MySQLConnectionClass();

            return(mySQLC.get_All_Result_Str().Split("@"));
        }