memorandum.cs

数据库课程设计

using System;
using System.Collections.Generic;
using System.Text;
using Common;
using System.Data;
namespace DataAccess
{
    public class Memorandum
    {
        CommonOperator ComOP = new CommonOperator();
        public DataTable GridViewTickler()
        {
            DataTable BookInfoTable = null;
            string sql = "select TicklerID as '备忘编号', TicklerTime as '备忘时间',ReaderID as '读者编号',TicklerInfo as '备忘信息',RemindTime as '提醒时间' from Tickler";
            string sqlTable = "TicklerInfo";
            try
            {
                ComOP.ConnectDb();
                BookInfoTable = ComOP.Search(sql, sqlTable);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                ComOP.CloseDb();
            }
            return BookInfoTable;
        }
        public void InsertTicklerTable(string TicklerID, string TicklerTime, string ReaderID, string TicklerInfo,string RemindTime)
        {
            try
            {
                string sql = "insert into Tickler values('" + TicklerID + "','" + TicklerTime + "','" + ReaderID + "','" + TicklerInfo + "','" + RemindTime+ "')";
                ComOP.Execute(sql);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                ComOP.CloseDb();
            }
        }

        /// <summary>
        /// 删除备忘表里的一条记录!
        /// 以用户输入的TicklerID为条件
        /// </summary>
        /// <param name="TicklerID"></param>
        public void DeleteTicklerTable(string TicklerID)
        {
            try
            {
                string sql = "delete from Tickler where TicklerID='" + TicklerID + "'";
                ComOP.Execute(sql);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                ComOP.CloseDb();
            }
        }
        /// <summary>
        /// 以用户输入的TicklerID为参数
        /// 进行以TicklerID这一行数据的更新
        /// </summary>
        /// <param name="TicklerID"></param>
        public void UpdateTicklerTable(string TicklerID, string TicklerTime, string ReaderID, string TicklerInfo, string RemindTime)
        {
            try
            {
                string sql = "update Tickler " +
                              "  set TicklerTime='" + TicklerTime + "',ReaderID='" + ReaderID + "',TicklerInfo='"
                    + TicklerInfo + "',RemindTime='" + RemindTime + "'where TicklerID='" + TicklerID + "'";

            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                ComOP.CloseDb();
            }

        }
        //把所有Tickler表中的数据显示到界面的DataGril中
        public DataTable SelectTicklerID()
        {
            DataTable BookInfoTable = null;
            string sql = "select * from Tickler where RemindTime=getdate()";
            string sqlTable = "TicklerInfo";
            try
            {
                ComOP.ConnectDb();
                BookInfoTable = ComOP.Search(sql, sqlTable);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                ComOP.CloseDb();
            }
            return BookInfoTable;
        }
    }
}