图书罚款.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 图书馆管理系统
{
    /// <summary>
    /// ［图书罚款］　查询罚款清单　
    /// 交纳罚款时　系统根据提交的现金自动计算是否满足要求　满足就在罚款清单中将该条读者记录中是否提交罚款改为‘是’。
    ///可将罚款清单打印成报表　
    /// </summary>
    public partial class 图书罚款 : Form
    {
        public 图书罚款()
        {
            InitializeComponent();
        }
//－－－－－－－－－－－－－－－－－－－搜索--------
        private void button1_Click(object sender, EventArgs e)
        {
            sqlConnection1.Open();
            switch (comboBox1.SelectedIndex)
            {
                case 0:
                    sqlDataAdapter1.SelectCommand.Parameters[0].Value = "%"+textBox1.Text.Trim()+"%";
                    break;
                case 1:
                    sqlDataAdapter1.SelectCommand.Parameters[1].Value = "%" + textBox1.Text.Trim() + "%";
                    break;
                case 2:
                    sqlDataAdapter1.SelectCommand.Parameters[2].Value = "%" + textBox1.Text.Trim() + "%";
                    break;
                case 3:
                    sqlDataAdapter1.SelectCommand.Parameters[3].Value = "%" + textBox1.Text.Trim() + "%";
                    break;
                case 4:
                    图书罚款_Load(sender, e); break;
            }
            dataSet71.Clear();
            sqlDataAdapter1.Fill(dataSet71);
            sqlConnection1.Close();
        }
     //---------Load－－－－－－－－－
        private void 图书罚款_Load(object sender, EventArgs e)
        {
            sqlDataAdapter1.SelectCommand.Parameters[0].Value = "%%";
            sqlDataAdapter1.SelectCommand.Parameters[1].Value = "%%";
            sqlDataAdapter1.SelectCommand.Parameters[2].Value = "%%";
            sqlDataAdapter1.SelectCommand.Parameters[3].Value = "%%";
            sqlDataAdapter1.Fill(dataSet71);
        }

        private void button2_Click(object sender, EventArgs e)
        {
            if (textBox2.Text == "")
            {
                MessageBox.Show("请输入实收罚款金额！");
                return;
            }
            else
            {
                sqlConnection1.Open();
               // int dataGrid1.CurrentRowIndex;
                SqlCommand com=new SqlCommand ("select 应罚金额  from 图书罚款 where 罚款编号="+dataSet71.Tables[0].Rows[dataGrid1.CurrentRowIndex][0],sqlConnection1);
                object obj = com.ExecuteScalar();
                if (Convert.ToInt32(textBox2.Text) < Convert.ToInt32(obj))
                {

                    MessageBox.Show("应收罚款金额为" + Convert.ToInt32(obj));
                }
                else
                {
                    SqlCommand mycom = new SqlCommand("update 图书罚款 set 实收金额=" + textBox2.Text.ToString() + ",是否交款=true where 罚款编号=" + dataSet71.Tables[0].Rows[dataGrid1.CurrentRowIndex][0] + " and 是否交款=false", sqlConnection1);
                    sqlConnection1.Close();
                }
            }

        }

   
    }
}