App_code/News/Consultative/ConsultativeRestore/R_ConsultativeRestore.cs

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

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

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

/// <summary>
/// RConsultativeRestore 的摘要说明
/// </summary>
namespace Consultative
{
    public class RConsultativeRestore:IConsultativeRestore
    {
        public static string ConnectionString = ConfigurationManager.ConnectionStrings["sqlData"].ConnectionString;

        public RConsultativeRestore()
        {
            //
            // TODO: 在此处添加构造函数逻辑
            //
        }

        #region ICorporationRestore 成员
        /// <summary>
        /// 添加资讯评论
        /// </summary>
        /// <param name="conr"></param>
        /// <returns></returns>
        public int Insert(TConsultativeRestore conr)
        {
            SqlParameter[] commandParameters = new SqlParameter[]
            {                
					new SqlParameter("@ConsultativeID", conr.ConsultativeID),
					new SqlParameter("@UserName", conr.UserName),
					new SqlParameter("@Detail", conr.Detail)
             };
            return SqlHelper.ExecuteNonQuery(CommandType.StoredProcedure, "SP_W_ConsultativeRestore_Add", commandParameters);
        }
        /// <summary>
        ///
        /// </summary>
        /// <param name="conr"></param>
        /// <returns></returns>
        public int Update(TConsultativeRestore conr)
        {
            SqlParameter[] commandParameters = new SqlParameter[]
            {
                   new SqlParameter("@ID",conr.ID ),
					new SqlParameter("@ConsultativeID", conr.ConsultativeID),
					new SqlParameter("@UserName", conr.UserName),
					new SqlParameter("@AddDate", conr.AddDate),
					new SqlParameter("@Detail", conr.Detail),
					new SqlParameter("@Shield", conr.Shield)

            };
            return SqlHelper.ExecuteNonQuery(ConnectionString, CommandType.StoredProcedure, "SP_W_ConsultativeRestore_Update", commandParameters);
        }
        /// <summary>
        /// 修改屏蔽信息
        /// </summary>