智能咖啡厅系统设计与实现

string connString = "server=自己的电脑设备名\\SQLEXPRESS; database=数据库名称 ;integrated security=SSPI";
string sqlString = "select account,password from 数据表名称 where account='" + textzhanghao + "'and password='" + textmima + "' ";

 if (cishu >= 3)
{
       MessageBox.Show("输入密码次数超过三次");
       Form2.pForm2.Photograph_Click(sender,e);
       cishu = 1;
 }
 else
{
       Form2.pForm2.btnClose_Click_1(sender, e);
       if (sqlDataReader.HasRows)
       {
                    cishu = 0;
                    frm3.Show();
                    this.Hide();
        }
        else{
                    cishu++;
                    MessageBox.Show("账号密码不正确");
             }
}

string sex = "";
            if (radioButton1.Checked)
            {
                sex = "男";
            }
            else
            {
                sex = "女";
            }
            string connString = "Data Source=设备名\\SQLEXPRESS;Integrated Security=True";
            string sqlString = "insert into 数据表(sno,sname,RFIDNumber,sex,college)values('" + textBox1.Text + "','" + textBox2.Text + "','" + textBox3.Text + "','" + sex + "','" + textBox4.Text + "')";
            master = new SqlConnection(connString);//建立连接对象
            master.Open();
            cmd = new SqlCommand(sqlString, master);//建立数据命令对象
            cmd.ExecuteNonQuery();
            MessageBox.Show("插入记录成功！");
            textBox1.Text = textBox2.Text = textBox3.Text = textBox4.Text = "";//清空各文本框

	private string GetIpAddress()
        {
            string hostName = Dns.GetHostName();   //获取本机名
            IPHostEntry localhost = Dns.GetHostByName(hostName);    
            localhost = Dns.GetHostEntry(hostName);   //获取IPv6地址
            IPAddress localaddr = localhost.AddressList[0];

            return localaddr.ToString();
        }

        public void UdpSend()
        {
            //Parse()把十进制iP转化成IPAddress类，绑定IP地址和端口
            remoteIPEp = new IPEndPoint(IPAddress.Parse("1IP地址"), CLIENT_UDP_PORT);
            //创建发送数据 Socket 对象与数据缓冲区
            udpSendDataBuf = new byte[1024];
            skUdpSend = new Socket(AddressFamily.InterNetwork,
            SocketType.Dgram, ProtocolType.Udp);

            //为false，等待执行
            mreUdpShutDown = new ManualResetEvent(false);
            mreUdpSend = new ManualResetEvent(false);
            whUdp = new WaitHandle[2];
            whUdp[0] = mreUdpShutDown;//UDP结束命令
            whUdp[1] = mreUdpSend; //UDP服务结束命令 

            int iWaitRetCode;
            iWaitRetCode = WaitHandle.WaitAny(whUdp, 1000);   //等待指定数组中的任意元素接收信号，同时使用 TimeSpan 指定时间间隔
            byte[] b_txt;
            int iByteLen;

            //满足条件
            while (iWaitRetCode != 0)
            {
                switch (iWaitRetCode)
                {
                    case 1://发送数据 
                        b_txt = Encoding.UTF8.GetBytes(strSendTxt);
                        iByteLen = b_txt.Length;
                        //初始化缓存数据
                        Array.Clear(udpSendDataBuf, iWaitRetCode, iByteLen);
                        //复制数组
                        Array.Copy(b_txt, udpSendDataBuf, iByteLen);
                        //发送到指定IP
                        skUdpSend.SendTo(udpSendDataBuf, remoteIPEp);
                        //消费掉一次事件
                        mreUdpSend.Reset();
                        break;
                    case WaitHandle.WaitTimeout://超时
                        break;
                }
                //继续下次事件检测
                iWaitRetCode = WaitHandle.WaitAny(whUdp, 1000);
            }
            skUdpSend.Close();
            skUdpSend = null;
        }
        #endregion    UDP发送线程线程 
        public static string strSendTxt;
        private void button1_Click(object sender, EventArgs e)
        {
            mreUdpShutDown.Set();
        }

        private void button2_Click(object sender, EventArgs e)
        {
            strSendTxt = GetIpAddress() +"："+ textBox1.Text + "\r\n";
            mreUdpSend.Set();
        }

            if (btn_diancisuo.Text == "打开")
            {
                foreach (SensorBase sensor in Relays)
                {
                    byte[] data = sensor.Data;
                    data = new byte[] { data[0], data[1], data[2], 0x01, data[4] };
                    gateWay.SendData(sensor.Type, sensor.Addr, data);
                    ShowMessage(string.Format("电磁锁打开成功！", Converts.ByteToString(sensor.Addr)));
                }
                btn_diancisuo.Text = "关闭";
                lb_ElectromagneticDoor.Text = "打开";
            }
            else
            {
                foreach (SensorBase sensor in Relays)
                {
                    byte[] data = sensor.Data;
                    data = new byte[] { data[0], data[1], data[2], 0x00, data[4] };
                    gateWay.SendData(sensor.Type, sensor.Addr, data);
                    ShowMessage(string.Format("电磁锁关闭成功！", Converts.ByteToString(sensor.Addr)));
                }
                btn_diancisuo.Text = "打开";
                lb_ElectromagneticDoor.Text = "关闭";
            }