remindaccess.cs

酒店管理系统,您酒店物业管理的好帮手

using System;
using System.Collections.Generic;
using System.Text;
using Hotel.DAO;
using System.Data;

namespace Hotel.Operation
{
    public class RemindAccess
    {
        GetDatabase objGetDatabase = null;
        public RemindAccess()
        {
            objGetDatabase = new GetDatabase();
        }
        //添加
        public int AddRemind(string dt,string st,string re)
        {
            string sql = "insert Remind values('"+dt+"','"+st+"','"+re+"')";
            int k = objGetDatabase.ExecuteSql(sql);
            return k;
 
        }
        //显示所有提醒事件
        public DataSet GetAllRemind()
        {
            string sql = "select 编号=RemindID,时间=remindTime,状态=state,事件=Remark from Remind";
            DataSet ds = new DataSet();
            ds = objGetDatabase.GetDataSet(sql, "Remind");
            return ds;
        }
        //显示启用的提醒事件
        public DataSet GetStardRemind()
        {
            string sql = "select 编号=RemindID,时间=remindTime,事件=Remark from Remind where state='启用'";
            DataSet ds = new DataSet();
            ds = objGetDatabase.GetDataSet(sql, "Remind");
            return ds;
        }
        //删除
        public int DeleteRemind(int num)
        {
            string sql = "delete from remind where remindID="+num;
            int k = 0;
            k = objGetDatabase.ExecuteSql(sql);
            return k;
        }
        //修改
        public int ModifiRemind(int num,string dt, string st, string re)
        {
            string sql = "update Remind set remindTime='"+dt+"',state='"+st+"', Remark='"+re+"' where RemindID="+num;
            int k = 0;
            k = objGetDatabase.ExecuteSql(sql);
            return k;
        }
     }
}