newsadsp.cs

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

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]
 //获取广告列表
 public static void GetAllNewsAD()
 {
  string strSQL = "SELECT * FROM NewsAd ORDER BY NewsAdID";
  DBTools.CreateStoredProcedure(strSQL);
 }
 [SqlProcedure]
 //获取指定广告信息
 public static void GetNewsAdInfo(int pintAdID)
 {
  string strSQL = "SELECT * FROM NewsAd WHERE NewsAdID=@NewsAdID";
  SqlParameter[] parms = new SqlParameter[1];
  parms[0] = new SqlParameter("@NewsAdID", SqlDbType.Int);
  parms[0].Direction = ParameterDirection.Input;
  parms[0].Value = pintAdID;
  DBTools.CreateStoredProcedure(strSQL, parms);
 }
 [SqlProcedure]
 //设置广告信息
 public static void SetNewsAdInfo(int pintAdID, string pstrAdType,string pstrAdTitle,int pintShowAtHome,string pstrAdURL)
 {
  string strSQL = @"UPDATE NewsItem SET NewsAdType=@NewsAdType,NewsAdTitle=@NewsAdTitle,NewsShowAtHome=@NewsShowAthome,NewsAdURL=@NewsAdURL
                 WHERE NewsAdID=@NewsAdID";
  SqlParameter[] parms = new SqlParameter[5];
  parms[0] = new SqlParameter("@NewsAdID", SqlDbType.Int);
  parms[0].Direction = ParameterDirection.Input;
  parms[0].Value = pintAdID;
  parms[1] = new SqlParameter("@NewsAdType", SqlDbType.NVarChar, 5);
  parms[1].Direction = ParameterDirection.Input;
  parms[1].Value = pstrAdType;
  parms[2] = new SqlParameter("@NewsAdTitle", SqlDbType.NVarChar, 20);
  parms[2].Direction = ParameterDirection.Input;
  parms[2].Value = pstrAdTitle;
  parms[3] = new SqlParameter("@NewsShowAthome", SqlDbType.Int);
  parms[3].Direction = ParameterDirection.Input;
  parms[3].Value = pintShowAtHome;
  parms[4] = new SqlParameter("@NewsAdURL", SqlDbType.NVarChar, 50);
  parms[4].Direction = ParameterDirection.Input;
  parms[4].Value = pstrAdURL;
  DBTools.CreateStoredProcedure(strSQL, parms);
 }
 [SqlProcedure]
 //删除指定ID广告
 public static void DeleteNewsAd(int pintAdID)
 {
  string strSQL = "DELETE FROM NewsAd WHERE NewsAdID=@NewsAdID";
  SqlParameter[] parms = new SqlParameter[1];
  parms[0] = new SqlParameter("@NewsAdID", SqlDbType.Int);
  parms[0].Direction = ParameterDirection.Input;
  parms[0].Value = pintAdID;
  DBTools.CreateStoredProcedure(strSQL, parms);
 }
 [SqlProcedure]
 //添加新广告
 public static void AddNewsAd(string pstrAdType,string pstrAdTitle,int pintShowAtHome,string pstrAdURL)
 {
  string strSQL = @"INSERT INTO NewsAd (NewsAdType,NewsAdTitle,NewsAdShowAtHome,NewsAdURL) 
                  VALUES(@NewsAdType,@NewsAdTitle,@NewsAdShowAtHome,@NewsAdURL);SELECT @@IDENTITY";
  SqlParameter[] parms = new SqlParameter[4];
  parms[0] = new SqlParameter("@NewsAdType", SqlDbType.NVarChar, 5);
  parms[0].Direction = ParameterDirection.Input;
  parms[0].Value = pstrAdType;
  parms[1] = new SqlParameter("@NewsAdTitle", SqlDbType.NVarChar, 20);
  parms[1].Direction = ParameterDirection.Input;
  parms[1].Value = pstrAdTitle;
  parms[2] = new SqlParameter("@NewsAdShowAtHome", SqlDbType.Int);
  parms[2].Direction = ParameterDirection.Input;
  parms[2].Value = pintShowAtHome;
  parms[3] = new SqlParameter("@NewsAdURL", SqlDbType.NVarChar, 50);
  parms[3].Direction = ParameterDirection.Input;
  parms[3].Value = pstrAdURL;
  DBTools.CreateStoredProcedure(strSQL, parms);
 }
}