load.cs

铁路电务信号设备维修记录系统 c#+acce

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.OleDb;

namespace D_Equipment_Mis
{
    public partial class load : Form
    {
        public load()
        {
            InitializeComponent();
            this.skinEngine1.SkinFile = "MP10.ssk";
        }

        private void load_Load(object sender, EventArgs e)
        {
            TB_user.Focus();   
        }

        private void button1_Click(object sender, EventArgs e)
        {
            string user_name = TB_user.Text.Trim();
            string pwd = TB_pwd.Text.Trim();
            if (user_name == "" || pwd == "")
            {
                MessageBox.Show("请输入完整信息");
                return;
            }
            OleDbConnection myconn = new OleDbConnection(data.connstr);            
            string ck_str = "select * from zd_user where user_name=@iuser_name and pwd=@ipwd";            
            OleDbCommand ck_cmd = new OleDbCommand(ck_str, myconn);
            ck_cmd.Parameters.Add("iuser_name", OleDbType.VarChar).Value = user_name;
            ck_cmd.Parameters.Add("ipwd", OleDbType.VarChar).Value = pwd;
            OleDbDataAdapter ck_da = new OleDbDataAdapter(ck_cmd);
            try
            {
                myconn.Open();
                DataSet ck_ds = new DataSet();
                ck_da.Fill(ck_ds);
                if (ck_ds.Tables[0].Rows.Count == 0)
                {
                    MessageBox.Show("用户名或密码有误，请重新输入!");
                    TB_user.Focus();
                }
                else
                {
                    myconn.Close();
                    string get_cj_str = "select * from zd_workshop";
                    OleDbCommand get_cj_cmd = new OleDbCommand(get_cj_str, myconn);
                    OleDbDataAdapter get_cj_da = new OleDbDataAdapter(get_cj_cmd);
                    try
                    {
                        myconn.Open();
                        DataSet myds = new DataSet();
                        get_cj_da.Fill(myds);
                        if (myds.Tables[0].Rows.Count == 0)
                            MessageBox.Show("还没有设置车间名称，请先进行车间名称的设置!");
                        else
                            data.workshop_name = myds.Tables[0].Rows[0]["workshop_name"].ToString();
                    }
                    catch (Exception t)
                    {
                        MessageBox.Show(t.ToString());
                    }                    
                    main main_form = new main();
                    main_form.Show();
                    main_form.Text = "电务设备检维修记录系统    " + data.workshop_name;
                    this.Hide();
                }
            }
            catch (Exception t)
            {
                MessageBox.Show(t.ToString());
            }           
        }

        private void TB_user_Enter(object sender, EventArgs e)
        {
            TB_user.SelectAll();
        }

        private void TB_pwd_Enter(object sender, EventArgs e)
        {
            TB_pwd.SelectAll();
        }

        private void TB_pwd_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyCode == Keys.Enter)
            {
                button1.Focus();
            }
        }
    }
}