loginform.cs

一个不错的文档

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using MySchoolPrj.Entity;
using System.Data.SqlClient;
using MySchoolPrj.DAO;

namespace MySchoolPrj.Login
{
    public partial class LoginForm : Form
    {
        public LoginForm()
        {
            InitializeComponent();
            
        }
        private userInfo us = new userInfo();        

        public userInfo Us
        {
          get { return us; }
          set { us = value; }
        }
        //设置登陆风格
        public void boxType()
        {
            if (this.rbtnBlue.Checked)
            {
                Program.skinEngine1.SkinFile = "DiamondBlue.ssk";
            }
            else if (this.rbtnGreen.Checked)
            {
                Program.skinEngine1.SkinFile = "DiamondGreen.ssk";
            }
            else
            {
                Program.skinEngine1.SkinFile = "DeepOrange.ssk";
            }
        }

        //设置非空判断数值的长度不能为0
        public bool Judge()
        {
            string str = txtName.Text.Trim();
            string pwd = txtPwd.Text;
            if (str.Length == 0 || pwd.Length == 0)
            {               
                MessageBox.Show("用户名密码不能为空！", "提示！");
                txtName.Text = "";
                txtPwd.Text = "";
                return false;  
            }
            else {
                return true;
            }
         }
        //提交数据
        private void btnOK_Click(object sender, EventArgs e)
        {
            if (Judge())
            {
                
                try
                {
                    UserHelper.loginId = txtName.Text;
                    string userName = txtName.Text;
                    UserHelper.psw = txtPwd.Text;
                    int grade = -1;

                    DBHelper.con.Open();
                    SqlCommand cmd = new SqlCommand();
                    cmd.Connection = DBHelper.con;
                    cmd.CommandType = CommandType.Text;
                    string sql = string.Format("select * from userInfo where userName='{0}'and pwd='{1}'" ,UserHelper.loginId,UserHelper.psw);
                    cmd.CommandText = sql;
                    cmd.ExecuteNonQuery();
                    SqlDataReader reader = cmd.ExecuteReader();
                    if (reader.HasRows)
                    {
                        reader.Read();
                        grade = Convert.ToInt32(reader["grade"]);
                        Us.UserName = UserHelper.loginId;
                        Us.Pwd = UserHelper.psw;
                        Us.Grade = grade;
                        UserHelper.grade = grade;
                        
                        Mainfrm form = new Mainfrm();
                        form.Ui = us;
                        boxType();
                        DialogResult = DialogResult.OK;
                        
                        
                    }
                    else
                    {
                        MessageBox.Show("您输入的帐号密码有误！", "提示！");
                        txtName.Text = "";
                        txtPwd.Text = "";
                    }
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message);
                }
                finally
                {
                    DBHelper.con.Close();
                }
            }
        }
        //关闭窗体
        private void btnCancel_Click(object sender, EventArgs e)
        {
            DialogResult = DialogResult.Cancel;
            //Application.Exit();
           
        }
        //窗体风格
        private void rbtnGreen_CheckedChanged(object sender, EventArgs e)
        {
            Program.skinEngine1.SkinFile = "DiamondGreen.ssk";
        }
        //窗体风格
        private void rbtnBlue_CheckedChanged(object sender, EventArgs e)
        {
            Program.skinEngine1.SkinFile = "DiamondBlue.ssk";
        }
        //窗体风格
        private void rbtnOrange_CheckedChanged(object sender, EventArgs e)
        {
            Program.skinEngine1.SkinFile = "DeepOrange.ssk";
        }
        //窗体风格
        private void LoginForm_Load(object sender, EventArgs e)
        {
            this.rbtnGreen.Checked = true;
            Program.skinEngine1.SkinFile = "DiamondGreen.ssk";
        }
        //窗体风格
        private void LoginForm_FormClosed(object sender, FormClosedEventArgs e)
        {
            //skinEngine1.Dispose();
        }
        /// <summary>
        /// 右下角小图标退出事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void tsmiClose_Click(object sender, EventArgs e)
        {
            Application.Exit();
        }
    } 
}