图书归还.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 图书归还 : Form
    {
        public 图书归还()
        {
            InitializeComponent();
        }
 //搜索－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－
        private void button1_Click(object sender, EventArgs e)
        {

             sqlConnection1.Open();
            sqlDataAdapter1.SelectCommand.Parameters[0].Value = "%%";
            sqlDataAdapter1.SelectCommand.Parameters[1].Value = "%%";
            sqlDataAdapter1.SelectCommand.Parameters[2].Value = "%%";
            sqlDataAdapter1.SelectCommand.Parameters[3].Value = "%%";
            
            switch (comboBox1.SelectedIndex)
            {
                case 0:
                    sqlDataAdapter1.SelectCommand.Parameters[0].Value = "%" + textBox1.Text + "%";
                    break;
                case 1:
                    sqlDataAdapter1.SelectCommand.Parameters[1].Value = "%" + textBox1.Text + "%";
                    break;
                case 3:
                    sqlDataAdapter1.SelectCommand.Parameters[2].Value = "%" + textBox1.Text + "%";
                    break;
                case 2:
                    sqlDataAdapter1.SelectCommand.Parameters[3].Value = "%" + textBox1.Text + "%";
                    break;
                case 4:
                    sqlDataAdapter1.SelectCommand.Parameters[0].Value = "%%";
                    break;

            }
            dataSet51.图书信息.Clear();
            sqlDataAdapter1.Fill(dataSet51);
            sqlConnection1.Close();
        }

        private void 图书归还_Load(object sender, EventArgs e)
        {
            //sqlDataAdapter1属性中的selectcommand下的paramenter属性－－－－（象查询索引的作用）－－－－在配制数据适配器时注意书写筛选器
            sqlDataAdapter1.SelectCommand.Parameters[0].Value = "%%";
            sqlDataAdapter1.SelectCommand.Parameters[1].Value = "%%";
            sqlDataAdapter1.SelectCommand.Parameters[2].Value = "%%";
            sqlDataAdapter1.SelectCommand.Parameters[3].Value = "%%";
            sqlDataAdapter1.Fill(dataSet51);
          
        }
        //------------------------------------归还图书------------------------------------------
        private void button2_Click(object sender, EventArgs e)
        {
            int N = dataGrid1.CurrentCell.RowNumber;//得到行号
            string jieyueID= dataGrid1[N, 0].ToString().Trim();//获取借阅编号
            DateTime returnTime = Convert.ToDateTime(dataGrid1[N, 6]);
            decimal fakuan = 0;
            if (returnTime < System.DateTime.Now)
            {
                fakuan=jisuanFK(returnTime);
            }
            if (fakuan != 0)
            {
                string msg = "该图书应于"+returnTime+"归还、超过期限必须支付过期罚金"+fakuan.ToString()+"元";
                MessageBox.Show(msg,"提示图书过期",MessageBoxButtons.OK,MessageBoxIcon.Information);
            }
            sqlConnection1.Open();
            SqlCommand mycom = new SqlCommand("exec sf_图书归还 "+jieyueID+","+fakuan.ToString()+"", sqlConnection1);
            mycom.ExecuteNonQuery();
            dataSet51.Clear();
            sqlDataAdapter1.Fill(dataSet51);
            sqlConnection1.Close();
        }
        //-------------
        private decimal jisuanFK(DateTime T)
        {
            int overDay = 365 * (System.DateTime.Now.Year - T.Year) + System.DateTime.Now.DayOfYear - T.DayOfYear;
            decimal fee = (decimal)0.1 * overDay;
            return (fee);
        }
    }
}