Backup/NetBarManageSystem/Form_hysj.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;

namespace NetBarManageSystem_lihang
{
    public partial class Form_hysj : Form
    {
        //定义全局变量。用于上机成功后，刷新上机信息
        public From_main sj;
        public Form_hysj()
        {
            InitializeComponent();
        }


        private void button2_Click(object sender, EventArgs e)
        {
            this.Close();
        }

        private void timer_kssj_Tick(object sender, EventArgs e)
        {
            this.txt_kssj.Text = DateTime.Now + "";
        }

        private void button1_Click(object sender, EventArgs e)
        {
            //先判断可不可以上机
            //1.验证会员名和密码是否正确

            string sql1 = "select *from cardInfo where cardNumber='"+this.txt_hyh.Text+"' and cardPassword='"+this.txt_pwd.Text+"'";

            DataTable table = sql_zsgc.cx(sql1);

            if (table.Rows.Count > 0)
            {
                //用户名密码正确，继续判断余额是否足够

                string sql2="select *from cardInfo where cardNumber='"+this.txt_hyh.Text+"'";
                DataTable table_ye=sql_zsgc.cx(sql2);
                float ye=float.Parse(table.Rows[0]["cardBalance"]+"");

                if(ye>=1)
                {
                    //余额足够，继续判断此会员卡是否在上机中

                    //查询出会员卡的编号

                    string sql3 = "select * from cardInfo where cardNumber='" + this.txt_hyh.Text + "'";
                    
                    DataTable table_cardId=sql_zsgc.cx(sql3);

                    //绑定cardId
                    this.txt_cardId.Text=table_cardId.Rows[0]["cardId"]+"";