App_code/Member/User/Message/R_Message.cs

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

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

using System;
using System.Data;
using System.Data.SqlClient;
using Message;
using SqlOperate;
using System.Configuration;

namespace Message
{
    /// <summary>
    /// R_Message 的摘要说明
    /// </summary>
    public class RMessage : IMessage
    {
        public static string ConnectionString = ConfigurationManager.ConnectionStrings["sqlData"].ConnectionString;

        #region IMessage 成员
        /// <summary>
        /// 添加留言信息
        /// </summary>
        /// <param name="eui">留言对象</param>
        /// <returns></returns>
        public int Insert(TMessage eui)
        {
            SqlParameter[] commandParameters = new SqlParameter[]
            {                
               
                  
					new SqlParameter("@ReceiveUserID", eui.ReceiveUserID.ToString()),
					new SqlParameter("@Title", eui.Title),
					new SqlParameter("@Info", eui.Info),
					new SqlParameter("@Date", eui.Date),
				    new SqlParameter("@Nature", eui.Nature),
					new SqlParameter("@SendUserID", eui.SendUserID)

             };
            return SqlHelper.ExecuteNonQuery(CommandType.StoredProcedure, "SP_C_Message_Add", commandParameters);
        }

        /// <summary>
        /// 批量留言
        /// </summary>
        /// <param name="eui">留言对象</param>
        /// <param name="strReceiveUserID">留言对象</param>
        /// <returns></returns>
        public int Insert(TMessage eui, string strReceiveUserID)
        {
            SqlParameter[] commandParameters = new SqlParameter[] {                                 
				new SqlParameter("@ReceiveUserID", strReceiveUserID),
				new SqlParameter("@Title", eui.Title),
				new SqlParameter("@Info", eui.Info),
				new SqlParameter("@Date", eui.Date),
			    new SqlParameter("@Nature", eui.Nature),
				new SqlParameter("@SendUserID", eui.SendUserID)
             };
            return SqlHelper.ExecuteNonQuery(CommandType.StoredProcedure, "SP_C_Message_Add", commandParameters);
        }


        /// <summary>