Backup/AccessDal/mes.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.OleDb;
using Model;
namespace AccessDal
{
    public class Mes
    {
        /// <summary>
        /// 添加一条留言
        /// </summary>
        /// <param name="qname">留言者姓名</param>
        /// <param name="qtitle">问题标题</param>
        /// <param name="qcontent">问题内容</param>
        /// <param name="qtime">提问时间</param>
        /// <param name="aname">回复者</param>
        /// <param name="acontent">回复内容</param>
        /// <param name="atime">回复时间</param>
        /// <returns> 返回Int，表示是否成功</returns>
        public static int Add(string qname, string qtitle, string qcontent, DateTime qtime, string aname, string acontent, DateTime atime)
        {
            string sql = "INSERT INTO MsgInfo ( [QName] ,[QTitle] ,[QContent] ,[QTime] ,[AName] ,[AContent] ,[ATime] ) VALUES (@QName,@QTitle,@QContent,'" + qtime + "',@AName,@AContent,'" + atime + "')";
            OleDbParameter[] p = new OleDbParameter[] 
            {
                new OleDbParameter("@QName", qname), 
                new OleDbParameter("@QTitle", qtitle),
                new OleDbParameter("@QContent", qcontent), 
             
                new OleDbParameter("@AName", aname),
                new OleDbParameter("@AContent", acontent), 
              };
            return OleHelper.ExecuteNonQuery(OleHelper.connString, CommandType.Text, sql, p);
        }
       /// <summary>
       /// 对某一留言进行回复
       /// </summary>
       /// <param name="aname">回复者姓名</param>
       /// <param name="acontent">回复内容</param>
       /// <param name="atime">回复时间</param>
       /// <param name="islook">是否回复</param>
       /// <param name="id">留言ID</param>
        /// <returns> 返回Int，表示是否成功</returns>
        public static int Update(string aname, string acontent, DateTime atime, bool islook, int id)
        {
            string sql = "update MsgInfo set [AName] = @AName,[AContent] = @AContent,[ATime] = '"+atime+"',[IsLook] = @IsLook where [ID]=@ID";
            OleDbParameter[] p = new OleDbParameter[] 
            {
                new OleDbParameter("@AName", aname), 
                new OleDbParameter("@AContent", acontent), 
               
                new OleDbParameter("@IsLook", islook),
                new OleDbParameter("@ID", id) 
            };
            return OleHelper.ExecuteNonQuery(OleHelper.connString, CommandType.Text, sql, p);
        }
       /// <summary>
       /// 对某一留言进行删除
       /// </summary>