set_user.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 set_user : Form
    {
        public set_user()
        {
            InitializeComponent();
        }
        public void ini_data()
        {
            OleDbConnection myconn = new OleDbConnection(data.connstr);
            string ini_str = "select user_name as 用户名,pwd as 密码 from zd_user order by user_id";
            OleDbCommand ini_cmd = new OleDbCommand(ini_str, myconn);
            OleDbDataAdapter ini_da = new OleDbDataAdapter(ini_cmd);
            try
            {
                myconn.Open();
                DataSet ini_ds = new DataSet();
                ini_da.Fill(ini_ds);
                if (ini_ds.Tables[0].Rows.Count == 0)
                {
                    DataTable mytable = new DataTable();
                    mytable.Columns.Add("用户名");
                    mytable.Columns.Add("密码");
                    mytable.Rows.Add(mytable.NewRow());
                    dataGridView1.DataSource = mytable.DefaultView;
                }
                else
                {
                    dataGridView1.DataSource = ini_ds.Tables[0].DefaultView;
                }
            }
            catch (Exception t)
            {
                MessageBox.Show(t.ToString());
            }
        }

        private void set_user_Load(object sender, EventArgs e)
        {
            ini_data();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            OleDbConnection myconn = new OleDbConnection(data.connstr);
            string ck_str = "select * from zd_user where user_name=@iuser_name";
            OleDbCommand ck_cmd = new OleDbCommand(ck_str, myconn);
            ck_cmd.Parameters.Add("iuser_name", OleDbType.VarChar).Value = TB_user.Text.Trim();
            ck_cmd.Parameters.Add("ipwd", OleDbType.VarChar).Value = TB_pwd.Text.Trim();
            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.Text.Trim() + "1试试!");
                    return;
                }
                else
                {
                    myconn.Close();
                    string ins_str = "insert into zd_user(user_name,pwd) values(@iuser_name,@ipwd)";
                    OleDbCommand ins_cmd = new OleDbCommand(ins_str, myconn);
                    ins_cmd.Parameters.Add("iuser_name", OleDbType.VarChar).Value = TB_user.Text.Trim();
                    ins_cmd.Parameters.Add("ipwd", OleDbType.VarChar).Value = TB_pwd.Text.Trim();
                    try
                    {
                        myconn.Open();
                        ins_cmd.ExecuteNonQuery();
                        myconn.Close();
                        ini_data();
                        MessageBox.Show("保存成功");
                    }
                    catch(Exception t)
                    {
                        MessageBox.Show(t.ToString());
                    }
                }
            }
            catch (Exception t)
            {
                MessageBox.Show(t.ToString());
            }
            

        }

        private void dataGridView1_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
        {
            int rows = Convert.ToInt32(dataGridView1.CurrentRow.Index);
            string user_name = dataGridView1.Rows[rows].Cells[0].Value.ToString().Trim();
            if (MessageBox.Show("您确定要删除'" + user_name + "'吗？", "删除用户", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
            {
                string del_str = "delete from zd_user where user_name=@iuser_name";
                OleDbConnection myconn = new OleDbConnection(data.connstr);
                OleDbCommand del_cmd = new OleDbCommand(del_str, myconn);
                del_cmd.Parameters.Add("iuser_name", OleDbType.VarChar).Value = user_name;
                try
                {
                    myconn.Open();
                    if ((int)del_cmd.ExecuteNonQuery() == 1)
                    {
                        MessageBox.Show("删除成功!");
                        ini_data();
                    }
                    else
                    {
                        MessageBox.Show("删除失败，请尝试重新启动程序");
                    }
                }
                catch (Exception t)
                {
                    MessageBox.Show(t.ToString());
                }
            }
        }
    }
}