OleDbDAL/relay.cs

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

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

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.OleDb;
using ClothesShop.DBUtility;
namespace ClothesShop.OleDbDAL
{
    public class relay : ClothesShop.IDAL.Irelay
    {
        /// <summary>
        /// 添加一条回复
        /// </summary>
        /// <param name="Relay_Content"></param>
        /// <param name="Messages_ID"></param>
        /// <param name="MUser_ID"></param>
        public int createrelay(String Relay_Content, Int32 Messages_ID, Int32 MUser_ID)
        {
            OleDbParameter[] param = { OleDbHelper.GetParameter("@Relay_Content",OleDbType.Char,1000,"Relay_Content",Relay_Content),
                                   OleDbHelper.GetParameter("@Messages_ID",OleDbType.Integer,4,"Messages_ID",Messages_ID),
                                   OleDbHelper.GetParameter("@MUser_ID",OleDbType.Integer,4,"MUser_ID",MUser_ID)};
            String sql = "Insert into Relay (Relay_Content,Messages_ID,MUser_ID) values (@Relay_Content,@Messages_ID,@MUser_ID)";
            return OleDbHelper.ExecuteSql(sql, param);
        }

        /// <summary>
        /// 更新回复
        /// </summary>
        /// <param name="Messages_ID"></param>
        /// <param name="Relay_Content"></param>
        /// <param name="MUser_ID"></param>
        public int updaterelay(Int32 Messages_ID, String Relay_Content, Int32 MUser_ID)
        {
            OleDbParameter[] param = { 
                                   OleDbHelper.GetParameter("@Relay_Content", OleDbType.Char, 1000, "Relay_Content", Relay_Content),
                                   OleDbHelper.GetParameter("@MUser_ID", OleDbType.Integer, 4, "MUser_ID", MUser_ID),
                                   OleDbHelper.GetParameter("@Messages_ID", OleDbType.Integer, 4, "Messages_ID", Messages_ID),
                                 };
            String sql = "Update Relay set Relay_Content=@Relay_Content,Relay_Time=Now(),MUser_ID=@MUser_ID where Messages_ID=@Messages_ID";
            return OleDbHelper.ExecuteSql(sql, param);
        }

        /// <summary>
        /// 删除一条回复
        /// </summary>
        /// <param name="Relay_ID"></param>
        public int deleterelay(int Relay_ID)
        {
            OleDbParameter[] param = { OleDbHelper.GetParameter("@Relay_ID", OleDbType.Char, 1000, "Relay_ID", Relay_ID) };
            String sql = "delete from Relay where Relay_ID=@Relay_ID";
            return OleDbHelper.ExecuteSql(sql, param);
        }

        /// <summary>
        /// 留言是否有回复
        /// </summary>
        /// <param name="Message_ID"></param>
        /// <returns></returns>
        public bool isRelay(int Message_ID)
        {