magazinepenalty.cs

数据库课程设计

using System;
using System.Collections.Generic;
using System.Text;
using Common;

namespace DataAccess
{
    public class MagazinePenalty
    {
         CommonOperator objCommonOperator = new CommonOperator();
        /// <summary>
        /// 将罚款纪录添加到罚款表里
        /// </summary>
        /// <param name="BookID">期刊编号</param>
        /// <param name="ReaderID">读者编号</param>
        /// <param name="Remark">备注信息</param>
        /// <param name="money">罚款金额</param>
        public void MagazineAmerce(string MagazineID, string ReaderID, string AmerceTime, double money, string Yes, int shifou)
        {
            try
            {
                string sql = "insert into MagazineAmerce values('" + MagazineID + "','" + ReaderID + "',getdate()," + money + ",'" + Yes + "','" + shifou + "')";
                objCommonOperator.Execute(sql);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                objCommonOperator.CloseDb();
            }
        }
    }
}