frmqxgl.cs

本系统属于小型的餐饮管理系统

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace MrCy
{
    public partial class frmQxGl : Form
    {
        public frmQxGl()
        {
            InitializeComponent();
        }

        private void frmQxGl_Load(object sender, EventArgs e)
        {
            SqlConnection conn = BaseClass.DBConn.CyCon();
            conn.Open();
            SqlCommand cmd = new SqlCommand("select * from tb_User",conn);
            SqlDataReader sdr = cmd.ExecuteReader();
            while (sdr.Read())
            {
                comboBox1.Items.Add(sdr["UserName"].ToString().Trim());
            }
            comboBox1.SelectedIndex = 0;
            sdr.Close();
            comboBox2.SelectedIndex = 0;
            conn.Close();

        }

        private void button1_Click(object sender, EventArgs e)
        {
            string userpower="";
            switch (comboBox2.SelectedItem.ToString())
            {
                case "超级管理员": userpower = "0"; break;
                case "经理": userpower = "1"; break;
                case "一般用户": userpower = "2"; break;
            }
            SqlConnection conn = BaseClass.DBConn.CyCon();
            conn.Open();
            SqlCommand cmd = new SqlCommand("update tb_User set power='"+userpower+"'",conn);
            cmd.ExecuteNonQuery();
            if (MessageBox.Show("权限修改成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation) == DialogResult.OK)
            {
                this.Close();
            }
        }
    }
}