student.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.IO;

namespace BMS
{
    public partial class student : Form
    {
        public student()
        {
            InitializeComponent();
        }

        #region 验证输入数据
        public bool yanzhen()
        {
            if (Stname.Text == "")
            {
                MessageBox.Show("请填写姓名");
                Stname.Focus();
                return false;
            }
            if (kahao.Text == "")
            {
                MessageBox.Show("请填写卡号");
                kahao.Focus();
                return false;
            }
            if (Identify.IdentifyCard(shengfenzheng.Text) == false)
            {
                MessageBox.Show("身份证应为１５位或１８位");
                shengfenzheng.Text = "";
                shengfenzheng.Focus();
                return false;
            }
            if (Identify.Phone(telephone.Text) == false)
            {
                MessageBox.Show("座机为11位或12位，手机为11位");
                telephone.Text = "";
                telephone.Focus();
                return false;
            }
            if (Identify.Pwd(mima.Text))
            {
                MessageBox.Show("密码为六位");
                mima.Text = "";
                mima.Focus();
                return false;
            }
            else
            {

                //验证卡号是否由数字组成
                try
                {
                    int bid = Int32.Parse(kahao.Text);
                }
                catch (System.FormatException)
                {
                    MessageBox.Show("卡号应由数字组成");
                 
                    return false;
                }
                return true;
            }
        }
        #endregion

        #region 验证卡号是否存在

        public bool kidNull()
        {
            string s = "select * from Reader where readerid='" +kahao.Text + "'";
            
            if (Operator.select(s)>0)
            {
                MessageBox.Show("卡号已存在");
               kahao.Text = "";
                return false;
            }
            else
                return true;

        }
        #endregion

        private void button1_Click(object sender, EventArgs e)
        {
            try
            {
                bool l=yanzhen();
                string sex;
                if (radioButton1.Checked == true)
                    sex = "男";
                else
                    sex = "女";
                bool kaho = kidNull();
                if (l == true)
                {
                    if (kaho == true)
                    {
                        //定义字符串用来添加学生信息
                        string m = "insert into Reader values('" + kahao.Text + "','" + Stname.Text.Trim() + "','" + mima.Text + "','" + sex + "','" + Stxi.Text + "','" + banji.Text + "','" + telephone.Text + "','" + shengfenzheng.Text + "','" + caozuoyuan.Text + "',getdate())";
                        if (Operator.ExecuteSql(m) > 0)
                        {
                            MessageBox.Show("添加成功");
                            string sel = "select * from Reader where readerid='" + kahao.Text + "'";

                            dataGridView1.DataSource = Operator.Datafill(sel);
                            Stname.Text = "";
                            telephone.Text = "";
                            shengfenzheng.Text = "";

                        }
                        else
                            MessageBox.Show("添加不成功");
                    }
                }
            }
            catch (Exception ea)
            {
                MessageBox.Show(ea.ToString());
            }
        }


        #region 查询全部
        public void data()
        {
            string selec = "select * from Reader";
            dataGridView1.DataSource = Operator.Datafill(selec);
        }
        #endregion
        private void student_Load(object sender, EventArgs e)
        {
            data();
            caozuoyuan.Text = Value.CurrentLoger;
           
        }
        private void 编辑ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            updatestudent up = new updatestudent();
            up.Tag = dataGridView1.CurrentRow.Cells[0].Value.ToString();
            up.ShowDialog(this);
        }

        private void 删除ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            string delete = "delete from Reader where readerid='" +dataGridView1.CurrentRow.Cells[0].Value.ToString() + "'";
            if (Operator.ExecuteSql(delete) > 0)
            {
                MessageBox.Show("删除成功");
                data();
               
               
            }
            else
                MessageBox.Show("删除不成功");
        }

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

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