memoranduminfo.cs

数据库课程设计

using System;
using System.Collections.Generic;
using System.Text;
using DataAccess;
using System.Data;
namespace Bussiness
{
     public class MemorandumInfo
    {
         /// <summary>
         /// 查询所有备忘信息
         /// </summary>
         Memorandum objMemorandum = new Memorandum();
         public DataTable GridViewTicklerTable()
         {
             DataTable ReaderInfoTable = null;
             try
             {
                 ReaderInfoTable = objMemorandum.GridViewTickler() ;
             }
             catch (Exception ex)
             {
                 throw ex;
             }
             return ReaderInfoTable;
         }
         /// <summary>
         /// 插入一条备忘信息
         /// 
         /// </summary>
         /// <param name="TicklerID"></param>
         /// <param name="TicklerTime"></param>
         /// <param name="ReaderID"></param>
         /// <param name="TicklerInfo"></param>
         /// <param name="RemindTime"></param>
         public void InsertTicklerTable(string TicklerID, string TicklerTime, string ReaderID, string TicklerInfo, string RemindTime)
         {
             try
             {
                 objMemorandum.InsertTicklerTable(TicklerID, TicklerTime, ReaderID, TicklerInfo, RemindTime);
             }
             catch (Exception ex)
             {
                 throw ex;
             }
         }
         /// <summary>
         /// 删除备忘表的信息
         /// 以用户输入的TicklerID为条件传参数
         /// </summary>
         /// <param name="TicklerID"></param>

         public void DeleteTicklerTable(string TicklerID)
         {
             try
             {
                 objMemorandum.DeleteTicklerTable(TicklerID);


             }
             catch (Exception ex)
             {
                 throw ex;
             }
         }
         /// <summary>
         /// 更新用户输入的TicklerID编号的信息
         /// </summary>
         /// <param name="TicklerID"></param>
         /// <param name="TicklerTime"></param>
         /// <param name="ReaderID"></param>
         /// <param name="TicklerInfo"></param>
         /// <param name="RemindTime"></param>
         public void UpDateTicklerTable(string TicklerID, string TicklerTime, string ReaderID, string TicklerInfo, string RemindTime)
         {
             try
             {


                 objMemorandum.UpdateTicklerTable(TicklerID, TicklerTime, ReaderID, TicklerInfo, RemindTime);

             }
             catch (Exception ex)
             {
                 throw ex;
             }

         }
         /// <summary>
         /// 查询备忘提醒！！
         /// </summary>
         /// <returns></returns>
         public DataTable SelectTicklerID()
         {
             DataTable ReaderInfoTable = null;
             try
             {
                 ReaderInfoTable = objMemorandum.SelectTicklerID();
             }
             catch (Exception ex)
             {
                 throw ex;
             }
             return ReaderInfoTable;
         }
    }
}