userinfomanange.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 图书馆
{
    public partial class UserInfoManange : Form
    {
        string id;
        string name;
        string sex;
        string type;
        string dept;
        DateTime login;
        DateTime logout;
        string certype;
        string cernum;
        int islost;
        int modify = 0;//是否更改
        public UserInfoManange()
        {
            InitializeComponent();
        }
        private void SetModifyMode(bool blnEdit)
        {
            //设置文本框和下拉列表框属性
            textBox3.ReadOnly = !blnEdit;
            textBox4.ReadOnly = !blnEdit;
            textBox5.ReadOnly = !blnEdit;
            textBox6.ReadOnly = !blnEdit;
            comboBox1.Enabled = blnEdit;
            comboBox2.Enabled = blnEdit;
            comboBox3.Enabled = blnEdit;
            comboBox4.Enabled = blnEdit;
            comboBox5.Enabled = blnEdit;
            checkBox1.Enabled = blnEdit;
            btnSearch.Enabled = !blnEdit;

        }

        private void label3_Click(object sender, EventArgs e)
        {

        }

        private void toolStrip1_ItemClicked(object sender, ToolStripItemClickedEventArgs e)
        {

        }

        private void UserInfoManange_Load(object sender, EventArgs e)
        {
            sqlDataAdapter1.Fill(userDataSet11);
            //为数据集添加数据项浏览控制
            cmOrders = (CurrencyManager)BindingContext[userDataSet11, "UserInfoManange"];
        }
        //
        //新增
        //
        private void toolStripButton1_Click(object sender, EventArgs e)
        {
            SetModifyMode(true);
        }
        //
        //修改
        //
        private void toolStripButton2_Click(object sender, EventArgs e)
        {
            SetModifyMode(true);
            modify = 1;
        }
        //
        //删除
        //
        private void toolStripButton3_Click(object sender, EventArgs e)
        {
            DialogResult result = MessageBox.Show("确认删除？", "删除数据", MessageBoxButtons.OKCancel);
            if (result == DialogResult.OK)
                if (cmOrders.Count > 0)//立即从数据集中删除
                {
                    cmOrders.RemoveAt(cmOrders.Position);
                    sqlDataAdapter1.Update(userDataSet11);
                }
                else
                    MessageBox.Show("表中为空，已无可删除数据", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
        }
        //
        //提交
        //

        private void toolStripButton4_Click(object sender, EventArgs e)
        {
            int allownewrow = 1;
            id = this.textBox3.Text.ToString();
            name = this.textBox4.Text.ToString();
            sex = this.comboBox1.Text.ToString();
            dept = this.textBox5.Text.ToString();
            type = this.comboBox2.Text.ToString();
            login = DateTime.Parse(this.comboBox3.Text.ToString());
            logout = DateTime.Parse(this.comboBox4.Text.ToString());
            certype = this.comboBox5.Text.ToString();
            cernum = this.textBox6.Text.ToString();
            if (checkBox1.Checked)
                islost = 1;
            else islost = 0;

            if (modify == 1)
            {
                cmOrders.RemoveAt(cmOrders.Position);
                sqlDataAdapter1.Update(userDataSet11);
            }
            DataRow[] foundRows = userDataSet11.Tables["UserInfoManange"].Select();
            int n = foundRows.Length;
            for (int i = 0; i < n; i++)
            {
                if (foundRows[i]["ReaderID"].Equals(id))
                {
                    MessageBox.Show("用户ID不能重复", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    allownewrow = 0;

                }
            }
            if (allownewrow == 1)
            {
                DataRow newTypeRow = userDataSet11.Tables["UserInfoManange"].NewRow();
                newTypeRow["ReaderID"] = id;
                newTypeRow["Readername"] = name;
                newTypeRow["Readertype"] = type;
                newTypeRow["Readerdept"] = dept;
                newTypeRow["Readersex"] = sex;
                newTypeRow["Logindate"] = login;
                newTypeRow["Logoutdate"] = logout;
                newTypeRow["CertificateType"] = certype;
                newTypeRow["CertificateNum"] = cernum;
                newTypeRow["Islost"] = islost;

                userDataSet11.Tables["UserInfoManange"].Rows.Add(newTypeRow);
                /*if (textBox1.Text.Trim() == "")//检查非空字段
                {
                    MessageBox.Show("类型名称不能为空", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    return;
                }

                if (textBox2.Text.Trim() == "")//检查非空字段
                {
                    MessageBox.Show("借阅天数不能为空", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    return;
                }*/
            }

                cmOrders.EndCurrentEdit();
                sqlDataAdapter1.Update(userDataSet11);
                SetModifyMode(false);
                modify = 0;
            
        }

        

        

        private void comboBox3_SelectedIndexChanged(object sender, EventArgs e)
        {

        }

        private void comboBox3_Leave(object sender, EventArgs e)
        {
            monthCalendar1.Visible = false;
        }

        private void comboBox4_Leave(object sender, EventArgs e)
        {
            monthCalendar1.Visible = false;
        }

        private void comboBox3_DropDown(object sender, EventArgs e)
        {
            selectDate(comboBox3);
        }

        private void comboBox4_DropDown(object sender, EventArgs e)
        {
            selectDate(comboBox4);
        }

        

        private void monthCalendar1_DateSelected(object sender, DateRangeEventArgs e)
        {
            if (monthCalendar1.Left == comboBox3.Left)
                comboBox3.Text = monthCalendar1.SelectionEnd.ToString();
            if (monthCalendar1.Left == comboBox4.Left)
                comboBox4.Text = monthCalendar1.SelectionEnd.ToString();
        }

        private void selectDate(ComboBox cb)
        {
            monthCalendar1.Left = cb.Left;//设置日期控件的位置
            monthCalendar1.Top = cb.Top - monthCalendar1.Height - 10;
            monthCalendar1.SelectionStart = Convert.ToDateTime(cb.Text);//日历显示的时间为数据时间
            monthCalendar1.SelectionEnd = Convert.ToDateTime(cb.Text);

            monthCalendar1.Visible = true;//显示日期
            monthCalendar1.Show();
        }

        private void btnSearch_Click(object sender, EventArgs e)
        {
           /*if (textBox1.Text != "")
            {
                DataTable searchtable = new DataTable();
                string expression = "ReaderID=" + textBox1.Text.ToString();
                DataRow[] foundRows = userDataSet11.Tables["UserInfoManange"].Select(expression);
                int n = foundRows.Length;
                for (int i = 0; i < n; i++)
                {
                    searchtable.Rows.Add(foundRows[i]);
                }

                sqlDataAdapter1.Fill(searchtable);
            }*/
         /*  sqlDataAdapter1.SelectCommand.Parameters[0].Value = "%%";
            if (textBox1.Text != "")
            {
                sqlDataAdapter1.SelectCommand.Parameters[0].Value = "%" + textBox1.Text + "%";
            }
            userDataSet11.UserInfoManange.Clear();
            sqlDataAdapter1.Fill(userDataSet11);*/
          /* string str = "select * from UserInfoManange where ReaderID='" + textBox1.Text.ToString()+"'";
            //DataTable dt= new DataTable();
            SqlDataAdapter da1 = new SqlDataAdapter(str, sqlConnection1);
            
            //dataGridView1.DataMember = "UserInfoManange";
           da1.Fill(userDataSet11);
            dataGridView1.DataSource = userDataSet11;*/
            
           
           //dataGridView1.DataBindings();

          /* DataTable dt= new DataTable();
           string str1 = "ReaderID='" + textBox1.Text.ToString() + "'";
           DataRow[] ReadIDRow = userDataSet11.Tables["UserInfoManange"].Select(str1);
           //DataRow newRow = userDataSet11.Tables["UserInfoManange"].NewRow();

           DataRow newRow = ReadIDRow[0];
               dt.Rows.Add(newRow);
           sqlDataAdapter1.Fill(dt);*/
  
           
        }
    }
}