returnm.cs

用C#与SQL2005写的一个简单的图书管理系统.主要功能:图书及学生信息的添加修改与删除 图书的借出与归还 图书信息的模糊查询.

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 BooksM.SystemInforQuery
{
    public partial class ReturnM : Form
    {
        public ReturnM()
        {
            InitializeComponent();
        }
       public static int i=0;
        private void ReturnM_Load(object sender, EventArgs e)
        {
            textBox6.Text = DateTime.Now.ToString();
        }

        private void button3_Click(object sender, EventArgs e)
        {
            if (textBox1.Text.Trim().Length == 0)
            {
                MessageBox.Show("输入的读者编号不能为空！", "提示");
                textBox1.Focus();
                return;
            }
            if (textBox2.Text.Trim().Length == 0)
            {
                MessageBox.Show("输入的图书编号不能为空！", "提示");
                textBox2.Focus();
                return;
            }
            MyClass.ConnData myConnData = new BooksM.MyClass.ConnData();
            DataSet myDataSet = new DataSet();
            string str = "select * from LoanInfor "
                + "where ReaderID='"
                +textBox1.Text.ToString()
                + "' and BookID='"+textBox2.Text.ToString()+"'"
                + " and LoanNum!=0";
            try
            {
               myDataSet = myConnData.MyDataSet(str);
                this.comboBox1.DataSource = myDataSet.Tables[0];
                this.comboBox1.DisplayMember = "loanDate";
                this.comboBox1.ValueMember= "loanDate";
                textBox3.Text = myDataSet.Tables[0].Rows[0][2].ToString();
                textBox5.Text = myDataSet.Tables[0].Rows[0][4].ToString();
                textBox7.Text = myDataSet.Tables[0].Rows[0][6].ToString(); 
                 MessageBox.Show("此借阅记录存在！");
                 i = 1;
           }
            catch
            {
                MessageBox.Show("此借阅记录不存在，或此书已经还过！");
                textBox1.Text = "";
                textBox1.Focus();
            }
            return;
        }

        private void button1_Click(object sender, EventArgs e)
        {
            if (textBox1.Text.Trim().Length == 0)
            {
                MessageBox.Show("输入的读者编号不能为空！", "提示");
                textBox1.Focus();
                return;
            }
            if (textBox2.Text.Trim().Length == 0)
            {
                MessageBox.Show("输入的图书编号不能为空！", "提示");
                textBox2.Focus();
                return;
            }
            string r = comboBox1.SelectedValue.ToString(); 
            DateTime dte = Convert.ToDateTime(comboBox1.SelectedValue);
                MyClass.ConnData myConnData = new BooksM.MyClass.ConnData();
                string temp = "exec LoanInfor_return '"
                + textBox1.Text.ToString().Trim() + "','"
                + textBox2.Text.ToString().Trim() + "','"
                + Convert.ToDateTime(textBox6.Text.Trim()) + "',"
                + Convert.ToInt32(textBox3.Text.Trim()) + ",'"
                + Convert.ToDateTime(comboBox1.SelectedValue) + "'";
            if (myConnData.Command(temp))
            {
                string str1 = "update BookCardInfor set "
                    + "ActualNum=ActualNum+1,LoanNum=LoanNum-1 where"
                    + "BookID='" + textBox2.Text.ToString() + "'";
              try
              {
                if (myConnData.Command(str1))
                 MessageBox.Show("还书成功！");
               }
                catch
                {
                    MessageBox.Show("还书失败！");
                    return;
                }
                DataSet myDataSet = new DataSet();
                string str = "select * from LoanInfor "
                    + "where ReaderID='"
                    + textBox1.Text.ToString()
                    + "' and BookID='" + textBox2.Text.ToString() + "'"
                    + " and LoanNum!=0";
                try
                {
                    myDataSet = myConnData.MyDataSet(str);
                    this.comboBox1.DataSource = myDataSet.Tables[0];
                    this.comboBox1.DisplayMember = "loanDate";
                    textBox3.Text = myDataSet.Tables[0].Rows[0][2].ToString();
                    textBox5.Text = myDataSet.Tables[0].Rows[0][4].ToString();
                    textBox7.Text = myDataSet.Tables[0].Rows[0][6].ToString();
                }
                catch
                {
                    MessageBox.Show("这本书已经还过！");
                    textBox3.Text = "";
                    comboBox1.DisplayMember = "";
                    textBox5.Text = "";
                    textBox6.Text =DateTime.Now.ToString();
                    textBox7.Text = "";
                    textBox1.Focus();
                }
                textBox6.Text = DateTime.Now.ToString();
                comboBox1.Focus();
            }
            else
                MessageBox.Show("还书失败！");
            i = 1;
            return;
        }

        private void button2_Click(object sender, EventArgs e)
        {
            Close();
        }

        private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
        {
            if (i > 0)
            {
                if (textBox1.Text.Trim().Length == 0)
                {
                    MessageBox.Show("输入的读者编号不能为空！", "提示");
                    textBox1.Focus();
                    return;
                }
                if (textBox2.Text.Trim().Length == 0)
                {
                    MessageBox.Show("输入的图书编号不能为空！", "提示");
                    textBox2.Focus();
                    return;
                }
                MyClass.ConnData myConnData = new BooksM.MyClass.ConnData();
                DataSet myDataSet = new DataSet();
                string str = "select * from LoanInfor "
                    + "where ReaderID='"
                    + textBox1.Text.ToString()
                    + "' and BookID='" + textBox2.Text.ToString() + "'"
                    + " and loanDate='" + Convert.ToDateTime(comboBox1.SelectedValue)+"'";
                try
                {
                    myDataSet = myConnData.MyDataSet(str);
                    textBox3.Text = myDataSet.Tables[0].Rows[0][2].ToString();
                    textBox5.Text = myDataSet.Tables[0].Rows[0][4].ToString();
                    textBox7.Text = myDataSet.Tables[0].Rows[0][6].ToString();
                    //MessageBox.Show("此借阅记录存在！");
                }
                catch
                {
                    MessageBox.Show("此借阅记录不存在，或此书已经还过！");
                    textBox1.Focus();
                }
                return;
            }
            else return;
        }
    }
}