lose.cs

数据库课程设计

using System;
using System.Collections.Generic;
using System.Text;
using Common;
using System.Data;
namespace DataAccess
{
    public class Lose
    {
        CommonOperator objCommonOperator = new CommonOperator();
        /// <summary>
        //书籍丢失罚款
        /// </summary>
        /// <param name="BookID">图书编号</param>
        /// <param name="ReaderID">读者编号</param>
        /// <param name="CompensateMoney">罚款金额</param>
        /// 
        public void InsertBookLose(string BookID, string ReaderID, double CompensateMoney,string BookLoseAdmin)
        {
            try
            {
                string sql = "insert into BookLose values('" + BookID + "','" + ReaderID + "'," + CompensateMoney + ",getdate(),'" + BookLoseAdmin + "')";
                objCommonOperator.Execute(sql);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                objCommonOperator.CloseDb();
            }
        }
        /// <summary>
        /// 插入期刊丢失信息
        /// </summary>
        /// <param name="MagazineID"></param>
        /// <param name="ReaderID"></param>
        /// <param name="CompensateMoney"></param>
        /// <param name="BMagazineLoseAdmin"></param>
        public void InsertMagazineLose(string MagazineID, string ReaderID, double CompensateMoney, string BMagazineLoseAdmin)
        {
            try
            {
                string sql = "insert into MagazineLose values('" + MagazineID + "','" + ReaderID + "'," + CompensateMoney + ",getdate(),'" + BMagazineLoseAdmin + "')";
                objCommonOperator.Execute(sql);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                objCommonOperator.CloseDb();
            }
        }
        /// <summary>
        /// 删除书籍丢失表信息
        /// </summary>
        /// <param name="BookID"></param>
        /// <param name="ReaderID"></param>

        public void delBookLose(string BookID, string ReaderID)
        {
            try
            {
                string sql = "DELETE FROM BookLose  "
                          + "WHERE BooksID ='" + BookID + "' and  ReaderID ='" + ReaderID + "'";
                objCommonOperator.Execute(sql);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                objCommonOperator.CloseDb();
            }
        }
        /// <summary>
        /// 删除期刊丢失表的信息
        /// </summary>
        /// <param name="MagazineID"></param>
        /// <param name="ReaderID"></param>
        public void delMagazineLose(string MagazineID, string ReaderID)
        {
            try
            {
                string sql = "DELETE FROM MagazineLose  "
                          + "WHERE MagazineID  ='" + MagazineID + "' and  ReaderID ='" + ReaderID + "'";
                objCommonOperator.Execute(sql);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                objCommonOperator.CloseDb();
            }
        }

        public DataTable GridViewBookLose()
        {
            DataTable BookLoseTable = null;
            string sql = "select LoseID    as '丢失ID',BooksID  as '书籍编号', ReaderID  as '读者编号',CompensateMoney  as '赔偿金额',OperateTime  as '操作时间',"
                + "BookLoseAdmin  as '操作员' from  BookLose";
            string sqlTable = "BookInfo";
            try
            {
                objCommonOperator.ConnectDb();
                BookLoseTable = objCommonOperator.Search(sql, sqlTable);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                objCommonOperator.CloseDb();
            }
            return BookLoseTable;
        }
        /// <summary>
        /// 根据读者编号对书籍丢失表进行模糊查找
        /// 
        /// </summary>
        /// <param name="ReaderID"></param>
        /// <returns></returns>
        public DataTable SelectLikeBookLose(string ReaderID)
        {
            DataTable BookLoseTable = null;
            string sql = "select LoseID    as '丢失ID',BooksID  as '书籍编号', ReaderID  as '读者编号',CompensateMoney  as '赔偿金额',OperateTime  as '操作时间',"
                + "BookLoseAdmin  as '操作员' from  BookLose where ReaderID='" + ReaderID + "'";
            string sqlTable = "BookInfo";
            try
            {
                objCommonOperator.ConnectDb();
                BookLoseTable = objCommonOperator.Search(sql, sqlTable);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                objCommonOperator.CloseDb();
            }
            return BookLoseTable;
        }
        /// <summary>
        //返期刊丢失表信息
        /// </summary>
        /// <returns></returns>
        public DataTable GridViewMagazineLose()
        {
            DataTable MagazineLoseTable = null;
            string sql = "select LoseID    as '丢失ID',MagazineID   as '期刊编号', ReaderID  as '读者编号',CompensateMoney  as '赔偿金额',OperateTime  as '操作时间',"
                + "BMagazineLoseAdmin   as '操作员' from  MagazineLose";
            string sqlTable = "BookInfo";
            try
            {
                objCommonOperator.ConnectDb();
                MagazineLoseTable = objCommonOperator.Search(sql, sqlTable);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                objCommonOperator.CloseDb();
            }
            return MagazineLoseTable;
        }
        /// <summary>
        /// 根据读者编号进行对期刊丢失表进行模糊查找
        /// </summary>
        /// <param name="ReaderID"></param>
        /// <returns></returns>
        public DataTable SelectLikeMagazineLose(string ReaderID)
        {
            DataTable MagazineLoseTable = null;
            string sql = "select LoseID    as '丢失ID',MagazineID   as '期刊编号', ReaderID  as '读者编号',CompensateMoney  as '赔偿金额',OperateTime  as '操作时间',"
                + "BMagazineLoseAdmin   as '操作员' from  MagazineLose where ReaderID='" + ReaderID + "'";
            string sqlTable = "BookInfo";
            try
            {
                objCommonOperator.ConnectDb();
                MagazineLoseTable = objCommonOperator.Search(sql, sqlTable);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                objCommonOperator.CloseDb();
            }
            return MagazineLoseTable;
        }
        /// <summary>
        /// 书籍过期归还100天罚款
        /// </summary>
        /// <param name="price"></param>
        /// <param name="ReaderID"></param>

        public void ReaderBooksMony(double price, string ReaderID)
        {
            try
            {
                string sql = "update Reader "
                             + "set  ReaderMoney = ReaderMoney+" + price + "where [ReaderID]='" + ReaderID + "'";
                objCommonOperator.Execute(sql);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                objCommonOperator.CloseDb();
            }
        }

    }
}