Esempio n. 1
0
        //public void OnClientConnect(IAsyncResult asyn)
        //{
        //    ////original
        //    //m_socWorker = m_socListener.EndAccept(asyn);
        //    //WaitForData(m_socWorker);

        //    if (!stopClick && asyn.AsyncState == null)
        //    {
        //        //TcpClient client = listener.AcceptTcpClient(); // Get client connection
        //        m_socWorker = m_socListener.EndAccept(asyn);
        //    }

        //    //Begin: send data to client
        //    if (m_socWorker != null && m_socWorker.Connected)
        //    {
        //        DataTable table = GetData();
        //        int byteSend = m_socWorker.Send(Utilities.SerializeData(table));
        //    }
        //    WaitForData(m_socWorker);
        //    //End
        //}

        //public void WaitForData(Socket socket)
        //{
        //    if (pfnWorkerCallBack == null)
        //    {
        //        pfnWorkerCallBack = new AsyncCallback(OnDataReceived);
        //    }
        //    CSocketPacket theSocPkt = new CSocketPacket();

        //    if (socket != null)
        //    {
        //        theSocPkt.thisSocket = socket;
        //        // now start to listen for any data...
        //        socket.BeginReceive(theSocPkt.dataBuffer, 0, theSocPkt.dataBuffer.Length, SocketFlags.None, pfnWorkerCallBack, theSocPkt);
        //    }
        //}

        //public void OnDataReceived(IAsyncResult asyn)
        //{
        //    //CSocketPacket theSockId = (CSocketPacket)asyn.AsyncState;
        //    ////end receive...
        //    //int iRx = 0;
        //    //iRx = theSockId.thisSocket.EndReceive(asyn);
        //    //char[] chars = new char[iRx + 1];
        //    ////Decoder decoder = Encoding.Unicode.GetDecoder();
        //    //Decoder decoder = Encoding.UTF8.GetDecoder();
        //    //int charLen = decoder.GetChars(theSockId.dataBuffer, 0, iRx, chars, 0);
        //    //String strData = new System.String(chars);

        //    //txtDataReceive.Invoke(new MethodInvoker(delegate
        //    //{
        //    //    txtDataReceive.Text = txtDataReceive.Text + strData;
        //    //}));
        //    //WaitForData(m_socWorker);

        //    //
        //    CSocketPacket theSockId = (CSocketPacket)asyn.AsyncState;
        //    //end receive...
        //    byte[] data = new byte[1024 * 5000];
        //    int receivedDataLength = theSockId.thisSocket.Receive(data);
        //    string stringData = Encoding.ASCII.GetString(data, 0, receivedDataLength);
        //    txtDataReceive.Invoke(new MethodInvoker(delegate
        //    {
        //        txtDataReceive.Text = txtDataReceive.Text + stringData;
        //    }));
        //    WaitForData(m_socWorker);

        //    //int bytesRead;
        //    //while ((bytesRead = theSockId.thisSocket.Receive(data)) > 0)
        //    //{
        //    //    //string stringData = Encoding.ASCII.GetString(data, 0, receivedDataLength);
        //    //}

        //    //delete record
        //    bool ret = false;
        //    if (stringData.Contains("DELETE "))
        //    {
        //        ret = DeleteRecord(stringData);
        //    }

        //    if (ret)
        //    {
        //        txtDataReceive.Invoke(new MethodInvoker(delegate
        //        {
        //            txtDataReceive.Text = txtDataReceive.Text + "One record was deleted..." + Environment.NewLine;
        //        }));
        //    }

        //    //if (theSockId.thisSocket.Available > 0) // .Connected)
        //    //{
        //    //    iRx = theSockId.thisSocket.EndReceive(asyn);
        //    //    char[] chars = new char[iRx + 1];
        //    //    System.Text.Decoder d = System.Text.Encoding.UTF8.GetDecoder();
        //    //    int charLen = d.GetChars(theSockId.dataBuffer, 0, iRx, chars, 0);
        //    //    String strData = new System.String(chars);

        //    //    txtDataReceive.Invoke(new MethodInvoker(delegate
        //    //    {
        //    //        txtDataReceive.Text = txtDataReceive.Text + strData;
        //    //    }));
        //    //    WaitForData(m_socWorker);
        //    //}
        //}

        private bool DeleteRecord(string query)
        {
            bool ret = false;

            DataInteractor dataUtils = new DataInteractor();

            ret = dataUtils.NoneQuery(query);

            return(ret);
        }
Esempio n. 2
0
        private DataTable GetData()
        {
            DataTable dt = new DataTable();

            string         query     = @"SELECT 
                                [IntergerValue]
                                ,[StringValue]
                                ,[DateTimeValue]
                                ,[BooleanValue] 
                            FROM Sample";
            DataInteractor dataUtils = new DataInteractor();

            dt = dataUtils.LoadData(query);

            return(dt);
        }