Backup/NetBarManageSystem/Form_hyk.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_hyk : Form
    {
        public Form_hyk()
        {
            InitializeComponent();    
        }
        public void hykload()
        {
            
            //查询会员卡信息
            string sql = "select * from cardInfo";

            //执行查询
            DataTable table = sql_zsgc.cx(sql);

            //绑定数据
            this.dgv_hykxx.AutoGenerateColumns = false;//不允许自动添加列
            this.dgv_hykxx.DataSource = table;

        }
        private void dgv_hykxx_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
        {
            /*
            //查询当前登陆的用户名和权限
            string sql="select * from userInfo where userUse=1 and userQx=1";

            DataTable table =sql_zsgc.cx(sql);

            if (table.Rows.Count > 0)
            {
                if (MessageBox.Show("确认删除会员卡吗？", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Question) == DialogResult.OK)
                {
                    string sql_sc = "delete from cardInfo where cardId=1015";//删除会员卡，需删除营业记录
                    MessageBox.Show("s");
                    DataTable table_sc = sql_zsgc.cx(sql_sc);

                    if (table_sc.Rows.Count > 0)
                    {

                        MessageBox.Show("恭喜您，删除会员卡成功！", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                        Form_hyk_Shown(null,null);

                    }
                    else
                    {
                        MessageBox.Show("抱歉，删除会员卡数据操作失败！", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    }
                }