breakreport.cs

这是一个图书馆管理用的简化系统

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

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

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

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

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

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

        private void Price_KeyPress(object sender, KeyPressEventArgs e)
        {
            e.Handled = !Check.num(Price,e);
        }

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

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

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

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

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

        private void BreakReport_Load(object sender, EventArgs e)
        {
            BreakRecord.DataSource = Operator.SelectSql("select * from breakbook").Tables[0];
        }

        private void BookId_Leave(object sender, EventArgs e)
        {
            string Sql;
            if (BookId.Text.Trim() == "")
            {
                return;
            }
            Sql = "select * from bookinf where bookid = '" + BookId.Text.Trim() + "';";
            DataSet ds = Operator.SelectSql(Sql);
            if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0 && ds.Tables[0].Rows[0].ItemArray[8].ToString().Trim() == "在库")
            {
                BookId.Text = ds.Tables[0].Rows[0].ItemArray[0].ToString().Trim();
                BookName.Text = ds.Tables[0].Rows[0].ItemArray[2].ToString().Trim();
                Bookpublish.Text = ds.Tables[0].Rows[0].ItemArray[5].ToString().Trim();
                Bookpubdate.Value = Convert.ToDateTime(ds.Tables[0].Rows[0].ItemArray[6].ToString().Trim());
                Writer.Text = ds.Tables[0].Rows[0].ItemArray[4].ToString().Trim();
                Price.Text = ds.Tables[0].Rows[0].ItemArray[7].ToString().Trim();
                BookSort.Text = ds.Tables[0].Rows[0].ItemArray[3].ToString().Trim();
                return;
            }
            else
            {
                MessageBox.Show("输入的图书编号有误或图书未在库,请仔细核对!", "图书报损");
                BookId.Focus();
                BookId.Text = "";
            }
        }

        private void ReaderID_Leave(object sender, EventArgs e)
        {
            string Sql;
            if (ReaderID.Text.Trim() == "")
            {
                return;
            }
            Sql = "select * from brinf where readerid = '" + ReaderID.Text.Trim() + "';";
            DataSet ds = Operator.SelectSql(Sql);
            if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
            {
                Sql = "select readxi,readerbanji from reader where readerid = '"+ReaderID.Text.Trim()+"';";
                ds = Operator.SelectSql(Sql);
                if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
                {
                    readerClass.Text = ds.Tables[0].Rows[0].ItemArray[1].ToString().Trim();
                    readerxi.Text = ds.Tables[0].Rows[0].ItemArray[0].ToString().Trim();
                }
                return;
            }
            else
            {
                MessageBox.Show("输入的读者编号有误,请仔细核对!", "图书报损");
                ReaderID.Focus();
                ReaderID.Text = "";
            }
        }

        private void Submit_Click(object sender, EventArgs e)
        {
            string Sql,Sql1;
            if (BookId.Text.Trim() == "")
            {
                MessageBox.Show("请输入要报损的图书编号!", "图书报损");
                return;
            }
            if (readerxi.Text.Trim() == "")
            {
                MessageBox.Show("请输入读者的系!", "图书报损");
                return;
            }
            if (readerClass.Text.Trim() == "")
            {
                MessageBox.Show("请输入读者的班级!", "图书报损");
                return;
            }
            Sql = "insert into breakbook (Bookid ,Bookname, readerxi, Readerbanji, Bookwriter, Bookpublish,"
                +" Bookpubdate, Bookprice, Booksort, Breakwhy, Addpeople, Addtime";
            Sql1 = " values('" + BookId.Text.Trim() + "','" + BookName.Text.Trim() + "','" + readerxi.Text.Trim() + "','"
                + readerClass.Text.Trim() + "','" + Writer.Text.Trim() + "','" + Bookpublish.Text.Trim() + "','"
                + Bookpubdate.Value.ToString().Substring(0, Bookpubdate.Value.ToString().IndexOf(" "))
                + "'," + Price.Text.Trim() + ",'" + BookSort.Text.Trim() + "','" + breakwhy.Text.Trim() + "','"
                + Value.CurrentLoger1 + "',getdate()";
            if (ReaderID.Text.Trim() != "")
            {
                Sql += ",Readerid)";
                Sql1 += ",'" + ReaderID.Text.Trim() + "');";
            }
            else
            {
                Sql += ")";
                Sql1 += ");";
            }
            Sql += Sql1;
            DialogResult dr = MessageBox.Show("报损信息在添加后无法修改，请仔细检查确认！\n按确定继续，按取消中止!","图书报损",MessageBoxButtons.OKCancel);
            if (dr == DialogResult.Cancel)
            {
                return;
            }
            if(Operator.ExecuteSql(Sql)<=0)
            {
                MessageBox.Show("报损失败!", "图书报损");
            }
            BreakReport_Load(sender, e);
        }
    }
}