form1.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 报刊管理.类;
using System.Diagnostics;

namespace 报刊管理
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }
        SqlBaseClass SqlExecute = new SqlBaseClass();    //声明类对象
        WinOperationClass WinFormClass = new WinOperationClass();
        PropertyClass Property = new PropertyClass();
        string int_status;

        private void button2_Click(object sender, EventArgs e)
        {
            Form f1 = new 欢迎界面();
            this.Hide();
            f1.Show();
        }

        private void button3_Click(object sender, EventArgs e)
        {
            Form f1 = new Form2();
            this.Hide();
            f1.Show();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            if (this.textBox1.Text.Length == 0)
            {
                MessageBox.Show("用户名不能为空！", "登录提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
            if (this.radioButton1.Checked) 
            {
                int_status = "用户";
            }
            if (this.radioButton2.Checked) 
            {
                int_status = "管理员";
            }
            if (!this.radioButton1.Checked && !this.radioButton2.Checked) 
            {
                MessageBox.Show("请先选择登陆身份！", "登录提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
            string sqlcmd = "SELECT * FROM N_User WHERE UserID='" + this.textBox1.Text.Trim() + "'";
            sqlcmd += "AND UserPsw='" + this.textBox2.Text.Trim() + "' AND Popedom='" + int_status + "'";
            SqlDataReader Sdr = SqlExecute.GetReader(sqlcmd);
            Sdr.Read();
            if (Sdr.HasRows)
            {
                Mainform mainform = new Mainform();
                this.Hide();
                PropertyClass.SendPopedomValue = Sdr["Popedom"].ToString();
                PropertyClass.SendNameValue = Sdr["UserID"].ToString();
                PropertyClass.SavePassword = Sdr["UserPsw"].ToString();
                mainform.Show();
            }
            else
            {
                MessageBox.Show("用户名、密码或身份不正确！", "登录提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Information);
                Sdr.Close();
            }
            Sdr.Close();
        }

      
    }
}