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

namespace BMS
{
    public partial class AddAdmin : Form
    {
        public AddAdmin()
        {
            InitializeComponent();
        }
        #region 验证输入数据
        public bool yanzhen()
        {
            if (adname.Text == "")
            {
                MessageBox.Show("请填写姓名");
                adname.Focus();
                return false;
            }
            if (adid.Text == "")
            {
                MessageBox.Show("请填写管理员编号");
                adid.Focus();
                return false;
            }
            if (Identify.IdentifyCard(adegree.Text) == false)
            {
                MessageBox.Show("身份证号码应为15位或18位");
                adegree.Text = "";
                adegree.Focus();
                return false;
            }
            if (Identify.Pwd(adpwd.Text) == false)
            {
                MessageBox.Show("请输入六位密码");
                adpwd.Text = "";
                adpwd.Focus();
                return false;
            }
            else
            {
                try
                {
                    int id1 = Int32.Parse(adid.Text);

                }
                catch (System.FormatException)
                {
                    MessageBox.Show("管理员编号应由数字组成");
                    return false;

                }
                return true;
            }
        }
        #endregion 
        #region 验证管理员编号是否存在
        public bool aidNull()
        {
            string aid = "select * from Admin where Ad_id='" + adid.Text + "'";
            if (Operator.select(aid) > 0)
            {
                MessageBox.Show("管理员编号已存在。");
                adid.Text = "";
                return false;
            }
            else
                return true;
        }
   #endregion 
        private void button1_Click(object sender, EventArgs e)
        {
          try
            {
                bool y = yanzhen();

               
                bool adminid = aidNull();
                if (y == true)
                {
                    if (adminid == true)
                    {
                        string sql = "insert into Admin(Ad_id,Ad_pwd,Ad_sex,Ad_name,Ad_degree,Ad_address,Ad_phone,Ad_people,Ad_date) values(@ida,@passworda,@sexa,@namea,@degreenuma,@addressa,@phonea,@addpeoplea,@addatea)";
                        string constr = Properties.Settings.Default.Book_manageConnectionString;
                        //string constr = Properties.Settings.Default.Book_manageConnectionString;
                        SqlConnection con = new SqlConnection(constr);
                        SqlCommand com = new SqlCommand(sql, con);
                        com.Parameters.Add("@ida", SqlDbType.VarChar).Value = adid.Text;
                        com.Parameters.Add("@passworda", SqlDbType.VarChar).Value = adpwd.Text;
                        com.Parameters.Add("@namea", SqlDbType.Char).Value = adname.Text;
                        com.Parameters.Add("@sexa", SqlDbType.Char).Value = adsexcom.Text;

                        com.Parameters.Add("@degreenuma", SqlDbType.Char).Value = adegree.Text;
                        com.Parameters.Add("@addressa", SqlDbType.Char).Value = ad_addre.Text;
                        com.Parameters.Add("@phonea", SqlDbType.Char).Value = adphone.Text;
                        com.Parameters.Add("@addpeoplea", SqlDbType.Char).Value = ad_people.Text;
                        com.Parameters.Add("@addatea", SqlDbType.Char).Value = DateTime.Today;


                        con.Open();
                        com.ExecuteNonQuery();
                        con.Close();
                        MessageBox.Show("添加成功！");
                        string se = "select * from Admin";
                        dataGridView1.DataSource = Operator.Datafill(se);
                        ad_date.Text = dataGridView1.CurrentRow.Cells[8].Value.ToString();
                    }
                    else
                    {
                        return;
                    }
                }
                else
                {
                    return;
                }
            }
            catch (Exception el)
            {
                //MessageBox.Show("不能打开数据库连接");
                MessageBox.Show(el.ToString());

                
            }  
        }

        private void AddAdmin_Load(object sender, EventArgs e)
        {
            // TODO: 这行代码将数据加载到表“book_manageDataSet1.Admin”中。您可以根据需要移动或移除它。
            this.adminTableAdapter.Fill(this.book_manageDataSet1.Admin);
            // TODO: 这行代码将数据加载到表“book_manageDataSet.Admin”中。您可以根据需要移动或移除它。
            //this.adminTableAdapter.Fill(this.book_manageDataSet.Admin);
            ad_people.Text = Value.CurrentLoger;

           
        }

        private void adegree_KeyPress(object sender, KeyPressEventArgs e)
        {
            e.Handled = !Check.Integer(e);
        }

        private void adphone_KeyPress(object sender, KeyPressEventArgs e)
        {
            e.Handled = !Check.Integer(e);
        }

       

       
    }
}