amerce.cs

数据库课程设计

using System;
using System.Collections.Generic;
using System.Text;
using Common;
using System.Data;
namespace DataAccess
{
    public class Amerce
    {
        CommonOperator objCommonOperator = new CommonOperator();
        /// <summary>
        /// 插入书籍罚款信息
        /// </summary>
        /// <param name="BookID"></param>
        /// <param name="ReaderID"></param>
        /// <param name="CompensateMoney"></param>
        /// <param name="Amercemoney"></param>
        /// <param name="BookLoseAdmin"></param>
        public void InsertBookAmerce(string BookID, string ReaderID, double CompensateMoney, double Amercemoney, string BookLoseAdmin)
        {
            try
            {
                string sql = "insert into BookAmerce values('" + BookID + "','" + ReaderID + "',getdate()," + CompensateMoney + "," + Amercemoney + ",'" + BookLoseAdmin + "'," + 0 + ",'已交罚款')";
                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 InsertMagazineAmerce(string MagazineID, string ReaderID, double CompensateMoney, double Amercemoney, string BMagazineLoseAdmin)
        {
            try
            {
                string sql = "insert into MagazineAmerce values('" + MagazineID + "','" + ReaderID + "',getdate()," + CompensateMoney + "," + Amercemoney + ",'" + BMagazineLoseAdmin + "'," + 0 + ",'已交罚款')";
                objCommonOperator.Execute(sql);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                objCommonOperator.CloseDb();
            }
        }

        /// <summary>
        /// 删除书籍罚款信息
        /// </summary>
        /// <param name="BookID"></param>
        /// <param name="ReaderID"></param>
        public void delBookAmerce(string BookID, string ReaderID)
        {
            try
            {
                string sql = "DELETE FROM BookAmerce  "
                          + "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 delMagazineAmerce(string MagazineID, string ReaderID)
        {
            try
            {
                string sql = "DELETE FROM MagazineAmerce  "
                          + "WHERE MagazineID  ='" + MagazineID + "' and  ReaderID ='" + ReaderID + "'";
                objCommonOperator.Execute(sql);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                objCommonOperator.CloseDb();
            }
        }
        /// <summary>
        /// 返回书籍罚款信息
        /// </summary>
        /// <returns></returns>
        public DataTable GridViewBookAmerce()
        {
            DataTable BookAmerceTable = null;
            string sql = "select AmerceID    as '罚款ID',BooksID  as '书籍编号', ReaderID  as '读者编号',AmerceTime as '罚款时间',AmerceDeal   as '应付金额',Amercemoney   as '实付金额',"
                + "BookAmerceAdmin   as '操作员', IfMoney  as '是否交款', AmerceRemark  as '备注' from  BookAmerce";
            string sqlTable = "BookInfo";
            try
            {
                objCommonOperator.ConnectDb();
                BookAmerceTable = objCommonOperator.Search(sql, sqlTable);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                objCommonOperator.CloseDb();
            }
            return BookAmerceTable;
        }
        /// <summary>
        /// 根据读者编号对书籍罚款表进行模糊查找
        /// </summary>
        /// <param name="ReaderID"></param>
        /// <returns></returns>
        public DataTable SelectLikeBookAmerce(string ReaderID)
        {
            DataTable BookAmerceTable = null;
            string sql = "select AmerceID    as '罚款ID',BooksID  as '书籍编号', ReaderID  as '读者编号',AmerceTime as '罚款时间',AmerceDeal   as '应付金额',Amercemoney   as '实付金额',"
                + "BookAmerceAdmin   as '操作员', IfMoney  as '是否交款', AmerceRemark  as '备注' from  BookAmerce where ReaderID='" + ReaderID + "'";
            string sqlTable = "BookInfo";
            try
            {
                objCommonOperator.ConnectDb();
                BookAmerceTable = objCommonOperator.Search(sql, sqlTable);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                objCommonOperator.CloseDb();
            }
            return BookAmerceTable;
        }
        /// <summary>
        //返期刊罚款表信息
        /// </summary>
        /// <returns></returns>
        public DataTable GridViewMagazineAmerce()
        {
            DataTable MagazineAmerceTable = null;
            string sql = "select AmerceID    as '罚款ID',MagazineID   as '期刊编号', ReaderID  as '读者编号',AmerceTime as '罚款时间',AmerceDeal   as '应付金额',Amercemoney   as '实付金额',"
                   + "MagazineAmerceAdmin    as '操作员', IfMoney  as '是否交款', AmerceRemark  as '备注' from  MagazineAmerce";
            string sqlTable = "BookInfo";
            try
            {
                objCommonOperator.ConnectDb();
                MagazineAmerceTable = objCommonOperator.Search(sql, sqlTable);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                objCommonOperator.CloseDb();
            }
            return MagazineAmerceTable;
        }
        /// <summary>
        /// 根据读者编号对期刊罚款表进行模糊查找
        /// </summary>
        /// <param name="ReaderID"></param>
        /// <returns></returns>
        public DataTable SelectMagazineAmerce(string ReaderID)
        {
            DataTable MagazineAmerceTable = null;
            string sql = "select AmerceID    as '罚款ID',MagazineID   as '期刊编号', ReaderID  as '读者编号',AmerceTime as '罚款时间',AmerceDeal   as '应付金额',Amercemoney   as '实付金额',"
                   + "MagazineAmerceAdmin    as '操作员', IfMoney  as '是否交款', AmerceRemark  as '备注' from  MagazineAmerce where ReaderID='" + ReaderID + "'";
            string sqlTable = "BookInfo";
            try
            {
                objCommonOperator.ConnectDb();
                MagazineAmerceTable = objCommonOperator.Search(sql, sqlTable);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                objCommonOperator.CloseDb();
            }
            return MagazineAmerceTable;
        }
    }
}