newscommendsp.cs

来自「ASP.NET 2.0动态网站设计实例源代码,本书介绍了ASP.NET2.0的基」· CS 代码 · 共 67 行

using System;
using System.Data;
using System.Data.SqlClient;
using System.Data.SqlTypes;
using Microsoft.SqlServer.Server;
using tsingjun.NewsSQL;

public partial class StoredProcedures
{
 [Microsoft.SqlServer.Server.SqlProcedure]
 //根据新闻ID获取评论列表
 public static void NewsCommendList(int pintNewsID)
 {
  string strSQL = "SELECT * FROM NewsCommend WHERE NewsID=@NewsID";
  SqlParameter[] parms = new SqlParameter[1];
  parms[0] = new SqlParameter("@NewsID", SqlDbType.Int);
  parms[0].Direction = ParameterDirection.Input;
  parms[0].Value = pintNewsID;
  DBTools.CreateStoredProcedure(strSQL, parms);
 }
 [Microsoft.SqlServer.Server.SqlProcedure]
 //添加评论
 public static void AddNewCommend(int pintNewsID,string pstrCommender,string pstrContent,string pstrFrom)
 {
  string strSQL = @"INSERT INTO NewsCommend (NewsID,NewsCommender,NewsCommendContent,NewsCommendFrom)
                  VALUES (@NewsID,@NewsCommender,@NewsCommendContent,@NewsCommendFrom);";
  SqlParameter[] parms = new SqlParameter[4];
  parms[0] = new SqlParameter("@NewsID", SqlDbType.Int);
  parms[0].Direction = ParameterDirection.Input;
  parms[0].Value = pintNewsID;
  parms[1] = new SqlParameter("@NewsCommender", SqlDbType.NVarChar,50);
  parms[1].Direction = ParameterDirection.Input;
  parms[1].Value = pstrCommender;
  parms[2] = new SqlParameter("@NewsCommendContent", SqlDbType.NVarChar, 200);
  parms[2].Direction = ParameterDirection.Input;
  parms[2].Value = pstrContent;
  parms[2].IsNullable = true;
  parms[3] = new SqlParameter("@NewsCommendFrom", SqlDbType.NVarChar, 15);
  parms[3].Direction = ParameterDirection.Input;
  parms[3].Value = pstrFrom;
  DBTools.CreateStoredProcedure(strSQL, parms);
 }
 [Microsoft.SqlServer.Server.SqlProcedure]
 //根据新闻ID获取评论列表
 public static void DeleteCommend(int pintCommendID)
 {
  string strSQL = "DELETE FROM NewsCommend WHERE NewsCommendID=@NewsCommendID";
  SqlParameter[] parms = new SqlParameter[1];
  parms[0] = new SqlParameter("@NewsCommendID", SqlDbType.Int);
  parms[0].Direction = ParameterDirection.Input;
  parms[0].Value = pintCommendID;
  DBTools.CreateStoredProcedure(strSQL, parms);
 }

 [SqlProcedure]
 //判断指定ID评论是否存在
 public static void IsCommendIDExist(int pintCommendID)
 {
  string strSQL = "SELECT NewsCommendID FROM NewsCommend WHERE NewsCommendID=@NewsCommendID";
  SqlParameter[] parms = new SqlParameter[1];
  parms[0] = new SqlParameter("@NewsCommendID", SqlDbType.Int);
  parms[0].Direction = ParameterDirection.Input;
  parms[0].Value = pintCommendID;
  DBTools.CreateStoredProcedure(strSQL, parms);
 }
};