예제 #1
0
파일: Main.cs 프로젝트: xinhvatra/app
        private void Main_Load(object sender, EventArgs e)
        {
            MySqlConnection conn = Function.GetConnection();

            conn.Open();
            string       sql = "";
            MySqlCommand cm;


            sql = "SELECT TIME FROM cus_deal ORDER BY TIME DESC LIMIT 1";
            cm  = new MySqlCommand(sql, conn);
            DateTime time = DateTime.Now;

            using (DbDataReader reader = cm.ExecuteReader())
            {
                if (reader.HasRows)
                {
                    while (reader.Read())
                    {
                        time = (DateTime)reader.GetValue(0);
                    }
                }
            }
            if (!time.ToString("dd/MM/yyyy").Equals(DateTime.Now.ToString("dd/MM/yyyy")))
            {
                sql = "update services set current_cus =id*1000";
                cm  = new MySqlCommand(sql, conn);
                cm.ExecuteNonQuery();

                sql = "truncate table cus_wait";
                cm  = new MySqlCommand(sql, conn);
                cm.ExecuteNonQuery();
            }
            conn.Close();
            clients = new Dictionary <int, int>();
            Thread t = new Thread(sound);

            t.Start();
            SocketRun.SocketCreate();
        }
예제 #2
0
파일: Main.cs 프로젝트: xinhvatra/app
        public static void processData(string st)
        {
            isProcess = true;

            //try
            //{
            String[] arrRs = st.Split('|');
            if (arrRs[0] == "login")
            {
                MySqlConnection conn = Function.GetConnection();
                conn.Open();
                string       sql = "select * from client where lower(ipcas) like '" + arrRs[1] + "'";
                MySqlCommand cmd = new MySqlCommand(sql, conn);
                using (DbDataReader reader = cmd.ExecuteReader())
                {
                    if (reader.HasRows)
                    {
                        while (reader.Read())
                        {
                            SocketRun.sendData("login", (int)reader.GetValue(0), (int)reader.GetValue(2), (string)reader.GetValue(3), (int)reader.GetValue(4), 0, Function.data_services);
                        }
                    }
                }
                sql = "UPDATE client SET idle=1, active=1, ip_address ='" + SocketRun.ip + "' WHERE  ipcas like '" + arrRs[1] + "'";
                cmd = new MySqlCommand(sql, conn);
                cmd.ExecuteNonQuery();
                conn.Close();
            }
            else if (arrRs[0] == "logout")
            {
                MySqlConnection conn = Function.GetConnection();
                conn.Open();
                String       sql = "UPDATE client SET idle=0, active=0 WHERE id=" + arrRs[1];
                MySqlCommand cmd = new MySqlCommand(sql, conn);
                cmd.ExecuteNonQuery();
                conn.Close();
            }
            else if (arrRs[0] == "question")
            {
                loadQuestion();
                SocketRun.sendData("question", 0, 0, "android", 0, 0, questionList);
            }
            else if (arrRs[0] == "idle")
            {
                MySqlConnection conn = Function.GetConnection();
                conn.Open();
                String       sql = "UPDATE client SET idle=1 WHERE id=" + arrRs[1];
                MySqlCommand cmd = new MySqlCommand(sql, conn);
                cmd.ExecuteNonQuery();
                conn.Close();
                SocketRun.sendData("idle", Int32.Parse(arrRs[1]), 0, "", 0, 0, "");
            }
            else if (arrRs[0] == "notidle")
            {
                MySqlConnection conn = Function.GetConnection();
                conn.Open();
                String       sql = "UPDATE client SET idle=0 WHERE id=" + arrRs[1];
                MySqlCommand cmd = new MySqlCommand(sql, conn);
                cmd.ExecuteNonQuery();
                conn.Close();
                SocketRun.sendData("notidle", Int32.Parse(arrRs[1]), 0, "", 0, 0, "");
            }

            else if (arrRs[0] == "data")
            {
                //MessageBox.Show("xu ly tin nhan tu client: " + st);
                bool            isAdd = false;
                int             cus_id = 0;
                int             client_id = 0, service_id = 0, gate = 0;
                MySqlConnection conn = Function.GetConnection();
                conn.Open();
                string       sql = "SELECT * FROM cus_wait AS cus  INNER JOIN `client` AS cl  ON cus.service_id=cl.service_id AND (cus.`receive_client_id`=" + arrRs[1] + " OR cus.`receive_client_id`=0) AND cl.active=1 AND cl.id= " + arrRs[1] + " ORDER BY cus.`priority` DESC, cus.cus_id ASC LIMIT 1";
                MySqlCommand cm  = new MySqlCommand(sql, conn);
                using (DbDataReader reader = cm.ExecuteReader())
                {
                    if (reader.HasRows)
                    {
                        while (reader.Read())
                        {
                            if (!clients.ContainsValue((int)reader.GetValue(8)))                             //nếu khách đang chờ thì để gọi vào cổng thì không nhận nữa
                            {
                                clients.Add((int)reader.GetValue(0), (int)reader.GetValue(8));
                                cus_id     = (int)reader.GetValue(0);
                                client_id  = (int)reader.GetValue(4);
                                service_id = (int)reader.GetValue(6);
                                gate       = (int)reader.GetValue(8);
                                isAdd      = true;
                                SocketRun.sendData("data", (int)reader.GetValue(4), (int)reader.GetValue(6), reader.GetValue(7).ToString(), (int)reader.GetValue(8), (int)reader.GetValue(0), "");
                            }
                        }
                    }
                }
                //cập nhật trạng thái tiếp khách client
                sql = "UPDATE client SET idle=0 WHERE id=" + arrRs[1];
                MySqlCommand cmd = new MySqlCommand(sql, conn);
                cmd.ExecuteNonQuery();

                if (isAdd)                //xóa khách khỏi bảng chờ
                {
                    sql = "Delete FROM cus_wait WHERE cus_id = " + cus_id;
                    cmd = new MySqlCommand(sql, conn);
                    cmd.ExecuteNonQuery();

                    //ghi lịch sử giao dịch
                    sql             = "insert into cus_deal(cus_id,client_id,service_id,gate,question) values(@cus_id,@client_id,@service_id,@gate,@question)";
                    cmd             = new MySqlCommand();
                    cmd.Connection  = conn;
                    cmd.CommandText = sql;

                    cmd.Parameters.Add("@cus_id", MySqlDbType.Int32).Value     = cus_id;
                    cmd.Parameters.Add("@client_id", MySqlDbType.Int32).Value  = client_id;
                    cmd.Parameters.Add("@service_id", MySqlDbType.Int32).Value = service_id;
                    cmd.Parameters.Add("@gate", MySqlDbType.Int32).Value       = gate;
                    cmd.Parameters.Add("@question", MySqlDbType.Int32).Value   = 1;
                    cmd.ExecuteNonQuery();
                }
                conn.Close();
            }
            else if (arrRs[0] == "switch")
            {
                MySqlConnection conn = Function.GetConnection();
                conn.Open();
                string       sql  = "select * from client where service_id = " + arrRs[2] + " AND active = 1 AND id NOT IN (SELECT id FROM CLIENT WHERE id = " + arrRs[1] + ")";
                MySqlCommand cmd  = new MySqlCommand(sql, conn);
                string       data = "";
                using (DbDataReader reader = cmd.ExecuteReader())
                {
                    if (reader.HasRows)
                    {
                        while (reader.Read())
                        {
                            data += "|" + reader.GetValue(0).ToString() + "_" + reader.GetValue(3).ToString() + "_" + reader.GetValue(4) + "_" + reader.GetValue(5);
                        }
                    }
                    SocketRun.sendData("switch", Int32.Parse(arrRs[1]), 0, "", 0, 0, data);
                }
                conn.Close();
            }
            else if (arrRs[0] == "pass")
            {
                MySqlConnection conn = Function.GetConnection();
                conn.Open();

                string       sql = "insert into cus_wait(cus_id,service_id,receive_client_id,priority) values(@cus_id,@service_id,@receive_client_id,@priority)";
                MySqlCommand cmd = new MySqlCommand();
                cmd             = new MySqlCommand();
                cmd.Connection  = conn;
                cmd.CommandText = sql;

                cmd.Parameters.Add("@cus_id", MySqlDbType.Int32).Value            = arrRs[4];
                cmd.Parameters.Add("@service_id", MySqlDbType.Int32).Value        = arrRs[2];
                cmd.Parameters.Add("@receive_client_id", MySqlDbType.Int32).Value = arrRs[3];
                cmd.Parameters.Add("@priority", MySqlDbType.Int32).Value          = 1;
                cmd.ExecuteNonQuery();
                SocketRun.sendData("pass", Int32.Parse(arrRs[1]), 0, "", 0, 0, "");
                //cập nhật trạng thái tiếp khách client
                sql = "UPDATE client SET idle=1 WHERE id=" + arrRs[1];
                cmd = new MySqlCommand(sql, conn);
                cmd.ExecuteNonQuery();

                sql = "select name,ip_address from client where id = " + arrRs[3];
                MySqlDataAdapter adap = new MySqlDataAdapter(sql, conn);
                DataTable        dt   = new DataTable();
                adap.Fill(dt);
                if (dt.Rows.Count > 0)
                {
                    using (adap)
                    {
                        string send_name, receive_ip;
                        receive_ip = dt.Rows[0][1].ToString();
                        send_name  = dt.Rows[0][0].ToString();
                        SocketRun.connectClient(receive_ip, send_name, Int32.Parse(arrRs[4]));
                    }
                }

                conn.Close();
                //SocketRun.connectClient("tétts", Int32.Parse(arrRs[4]));
            }
            else if (arrRs[0] == "forcecustomer")
            {
                bool            isAdd = false;
                int             cus_id = 0;
                int             client_id = 0, service_id = 0, gate = 0;
                MySqlConnection conn = Function.GetConnection();
                conn.Open();
                string       sql = "SELECT * FROM cus_wait AS cus  INNER JOIN `client` AS cl  ON cus.service_id=cl.service_id AND cus.`receive_client_id`= " + arrRs[1] + " AND cl.active=1 AND cl.id= " + arrRs[1] + " ORDER BY cus.`priority` DESC, cus.cus_id ASC LIMIT 1";
                MySqlCommand cm  = new MySqlCommand(sql, conn);
                using (DbDataReader reader = cm.ExecuteReader())
                {
                    if (reader.HasRows)
                    {
                        while (reader.Read())
                        {
                            if (!clients.ContainsValue((int)reader.GetValue(8)))                             //nếu khách đang chờ thì để gọi vào cổng thì không nhận nữa
                            {
                                clients.Add((int)reader.GetValue(0), (int)reader.GetValue(8));
                                cus_id     = (int)reader.GetValue(0);
                                client_id  = (int)reader.GetValue(4);
                                service_id = (int)reader.GetValue(6);
                                gate       = (int)reader.GetValue(8);
                                isAdd      = true;
                                SocketRun.sendData("data", client_id, service_id, reader.GetValue(7).ToString(), gate, cus_id, "");
                            }
                        }
                    }
                }

                //cập nhật trạng thái tiếp khách client
                sql = "UPDATE client SET idle=0 WHERE id=" + arrRs[1];
                MySqlCommand cmd = new MySqlCommand(sql, conn);
                cmd.ExecuteNonQuery();

                if (isAdd)                //xóa khách khỏi bảng chờ
                {
                    sql = "Delete FROM cus_wait WHERE cus_id = " + cus_id;
                    cmd = new MySqlCommand(sql, conn);
                    cmd.ExecuteNonQuery();

                    //ghi lịch sử giao dịch
                    sql             = "insert into cus_deal(cus_id,client_id,service_id,gate,question) values(@cus_id,@client_id,@service_id,@gate,@question)";
                    cmd             = new MySqlCommand();
                    cmd.Connection  = conn;
                    cmd.CommandText = sql;

                    cmd.Parameters.Add("@cus_id", MySqlDbType.Int32).Value     = cus_id;
                    cmd.Parameters.Add("@client_id", MySqlDbType.Int32).Value  = client_id;
                    cmd.Parameters.Add("@service_id", MySqlDbType.Int32).Value = service_id;
                    cmd.Parameters.Add("@gate", MySqlDbType.Int32).Value       = gate;
                    cmd.Parameters.Add("@question", MySqlDbType.Int32).Value   = 1;
                    cmd.ExecuteNonQuery();

                    //ghi đánh giá của khách hàng
                    sql             = "insert into cus_vote_data(cus_id,question_id,question_attr_id,data) values(@cus_id,@question_id,@question_attr_id,@data)";
                    cmd             = new MySqlCommand();
                    cmd.Connection  = conn;
                    cmd.CommandText = sql;

                    //cmd.Parameters.Add("@cus_id", MySqlDbType.Int32).Value = cus_id;
                    //cmd.Parameters.Add("@question_id", MySqlDbType.Int32).Value = question_id;
                    //cmd.Parameters.Add("@question_attr_id", MySqlDbType.Int32).Value = question_attr_id;
                    //cmd.Parameters.Add("@data", MySqlDbType.Int32).Value = data;
                    cmd.ExecuteNonQuery();
                }
                conn.Close();
            }
        }