typesetting.cs

一个图书管理系统

using System;
using System.Collections;

using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;

namespace 图书馆
{
    public partial class TypeSetting : Form
    {
        string typename;
        int day;
        int modify = 0;//是否更改
        public TypeSetting()
        {
            InitializeComponent();
        }

        private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {

        }

        //新增

        private void toolStripButton1_Click(object sender, EventArgs e)
        {
            /*cmOrders.AddNew();
            SetModifyMode(true);*/
          // dataGridView1.Columns["Typename"].Visible = false;
           /* string[] rowArray = new string[] { "警察", "5" };//被绑定了，无法以编程方式添加数据
            dataGridView1.Rows.Add(rowArray);*/
           // dataGridView1.Columns.Remove("Bookdays");
         /* int n1 =  dataGridView1.Rows.Count;
          cmOrders.AddNew();

          int n2 = dataGridView1.Rows.Count;
          cmOrders.AddNew();*/
          /*  DataTable newTable = new DataTable("table");
            newTable.Columns.Add("ID", typeof(int));
            newTable.Columns.Add("Name", typeof(string));
            dataSet.Tables.Add(newTable);*/
         
    // Get Each DataTable in the DataTableCollection and 
    // print each row value.
            SetModifyMode(true);

            /*DataRow newTypeRow = readertypeDataSet11.Tables["Readertype"].NewRow();
            newTypeRow["Typename"] = "请输入读者";
            newTypeRow["BookDays"] = 0;
            readertypeDataSet11.Tables["Readertype"].Rows.Add(newTypeRow);*/

            /*newCustomersRow["Typename"] = this.textBox1.Text;
            newCustomersRow["BookDays"] = this.textBox2.Text;

            readertypeDataSet11.Tables["Readertype"].Rows.Add(newCustomersRow);*/
            /*DataRow[] TypeRow = readertypeDataSet11.Tables["Readertype"].Select("Typename = '请输入读者'");

            TypeRow[0]["Typename"] = this.textBox1.Text;
            TypeRow[0]["BookDays"] = this.textBox2.Text;*/






        }

        private void SetModifyMode(bool blnEdit)
        {
            //设置文本框和下拉列表框属性
            textBox1.ReadOnly = !blnEdit;
            textBox2.ReadOnly = !blnEdit;
           
            
        }

        //修改

        private void toolStripButton2_Click(object sender, EventArgs e)
        {

            textBox1.ReadOnly = true;
            textBox2.ReadOnly = false;
            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(readertypeDataSet11);
                }
                else
                    MessageBox.Show("表中为空，已无可删除数据", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
        }

        //提交

        private void toolStripButton5_Click(object sender, EventArgs e)
        {
            int allownewrow=1;
            typename = this.textBox1.Text.ToString();
            day = Int16.Parse(this.textBox2.Text.ToString());
            if (modify == 1)
            {
                cmOrders.RemoveAt(cmOrders.Position);
                sqlDataAdapter1.Update(readertypeDataSet11);
            }
            DataRow[] foundRows = readertypeDataSet11.Tables["Readertype"].Select();
            int n = foundRows.Length;
            for (int i = 0; i < n; i++)
            {
                if (foundRows[i]["Typename"].Equals(typename))
                {
                    MessageBox.Show("类型名称不能重复", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    allownewrow = 0;

                }
            }
                if (allownewrow==1)
                {
                    DataRow newTypeRow = readertypeDataSet11.Tables["Readertype"].NewRow();
                    newTypeRow["Typename"] = typename;
                    newTypeRow["BookDays"] = day;

                    readertypeDataSet11.Tables["Readertype"].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(readertypeDataSet11);
                    SetModifyMode(false);
                    /*if (readertypeDataSet11.GetChanges() != null)
                    {
                        try
                        {
                            sqlDataAdapter1.Update(readertypeDataSet11);
                            SetModifyMode(false);
                        }
                        catch (Exception express)
                        {
                            MessageBox.Show(express.ToString(), "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                            readertypeDataSet11.RejectChanges();
                        }
                    }
                    return;*/
                }
        }

        private void textBox1_TextChanged(object sender, EventArgs e)
        {

        }

        private void label2_Click(object sender, EventArgs e)
        {

        }
        //
        //撤销
        //
        private void toolStripButton4_Click(object sender, EventArgs e)
        {
            try
            {
                cmOrders.CancelCurrentEdit();  //取消编辑
                SetModifyMode(false);
            }
            catch (Exception express)
            {
                MessageBox.Show(express.ToString(), "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
            return;
        }

     /*  private void button1_Click(object sender, EventArgs e)
        {
            Int32 selectedRowCount =
        dataGridView1.Rows.GetRowCount(DataGridViewElementStates.Selected);
            if (selectedRowCount > 0)
            {
                System.Text.StringBuilder sb = new System.Text.StringBuilder();

                for (int i = 0; i < selectedRowCount; i++)
                {
                    sb.Append("Row: ");
                    sb.Append(dataGridView1.SelectedRows[i].Index.ToString());
                    sb.Append(Environment.NewLine);
                }

                sb.Append("Total: " + selectedRowCount.ToString());
                MessageBox.Show(sb.ToString(), "Selected Rows");
            }

        }*/	
        
    }
}