dl.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;
using System.Configuration;

namespace CarManage
{
    public partial class DL : Form
    {
        public DL()
        {
            InitializeComponent();
        }
        #region 清空
        private void btnClear_Click(object sender, EventArgs e)
        {
            this.Close();
        }
        #endregion

        #region 登陆
        private void btn_login_Click_1(object sender, EventArgs e)
        {
            //获取用户输入的用户名和密码
            string UserName = this.txt_name.Text.ToString().Trim();
            string UserPwd = this.txt_pwd.Text.ToString().Trim();
            //SqlConnection con = new SqlConnection("server=.;database=login;uid=sa;pwd=;");
            SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["sqlString"]);
            SqlCommand cmd = new SqlCommand("select * from db_user where user_account = '" + UserName + "' and user_pwd = '" + UserPwd + "'", con);
            con.Open();
            SqlDataReader sdr = cmd.ExecuteReader();
            if (sdr.Read())
            {
                cs_operate.U_name = UserName;
                string Power = sdr["user_power"].ToString();
                this.Hide();
                switch (Power)
                {
                    case "经理":
                        JL_Main jlm = new JL_Main();
                        jlm.ShowDialog();
                        break;
                    case "财务":
                        CW_Main cwm = new CW_Main();
                        cwm.ShowDialog();
                        break;
                    case "调度":
                        DD_Main ddm = new DD_Main();
                        ddm.ShowDialog();
                        break;
                    case "员工":
                        PT_Main ygm = new PT_Main();
                        ygm.ShowDialog();
                        break;
                }

            }
            else
            {
                MessageBox.Show("用户名或密码错误!请重新输入!", "错误", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                this.txt_name.Clear();
                this.txt_pwd.Clear();
                //设置输入焦点
                this.txt_name.Focus();
            }
        }
        #endregion


    }
}