newsflsp.cs

ASP.NET 2.0动态网站设计实例源代码,本书介绍了ASP.NET2.0的基础知识

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 GetAllNewsFL()
 {
  string strSQL = "SELECT * FROM NewsFriendLink ORDER BY NewsFLID DESC";
  DBTools.CreateStoredProcedure(strSQL);
 }
 [SqlProcedure]
 //获取图片友情链接列表
 public static void GetNewsImageFL()
 {
  string strSQL = "SELECT * FROM NewsFriendLink WHERE NewsFLImage=1";
  DBTools.CreateStoredProcedure(strSQL);
 }
 [SqlProcedure]
 //获取非图片友情链接列表
 public static void GetNewsFLNotImage()
 {
  string strSQL = "SELECT * FROM NewsFriendLink WHERE NewsFLImage=0";
  DBTools.CreateStoredProcedure(strSQL);
 }
 [SqlProcedure]
 //获取指定友情链接信息
 public static void GetNewsFLInfo(int pintNewsFLID)
 {
  string strSQL = "SELECT * FROM NewsFriendLink WHERE NewsFLID=@NewsFLID";
  SqlParameter[] parms = new SqlParameter[1];
  parms[0] = new SqlParameter("@NewsFLID", SqlDbType.Int);
  parms[0].Direction = ParameterDirection.Input;
  parms[0].Value = pintNewsFLID;
  DBTools.CreateStoredProcedure(strSQL, parms);
 }
 [SqlProcedure]
 //设置友情链接信息
 public static void SetNewsFLInfo(int pintNewsFLID, int pintNewsFLImage, string pstrNewsFLTitle, string pstrNewsFLImageURL, string pstrNewsNavigateURL)
 {
  string strSQL = @"UPDATE NewsFriendLink SET NewsFLImage=@NewsFLImage,NewsFLTitle=@NewsFLTitle,NewsFLImageURL=@NewsFLImageURL,NewsNavigateURL=@NewsNavigateURL
                 WHERE NewsFLID=@NewsFLID";
  SqlParameter[] parms = new SqlParameter[5];
  parms[0] = new SqlParameter("@NewsTemplateID", SqlDbType.Int);
  parms[0].Direction = ParameterDirection.Input;
  parms[0].Value = pintNewsFLID;
  parms[1] = new SqlParameter("@NewsFLImage", SqlDbType.Int);
  parms[1].Direction = ParameterDirection.Input;
  parms[1].Value = pintNewsFLImage;
  parms[2] = new SqlParameter("@NewsFLTitle", SqlDbType.NVarChar, 50);
  parms[2].Direction = ParameterDirection.Input;
  parms[2].Value = pstrNewsFLTitle;
  parms[3] = new SqlParameter("@NewsFLImageURL", SqlDbType.NVarChar, 20);
  parms[3].Direction = ParameterDirection.Input;
  parms[3].Value = pstrNewsFLImageURL;
  parms[4] = new SqlParameter("@NewsNavigateURL", SqlDbType.NVarChar, 50);
  parms[4].Direction = ParameterDirection.Input;
  parms[4].Value = pstrNewsNavigateURL;
  DBTools.CreateStoredProcedure(strSQL, parms);
 }
 [SqlProcedure]
 //删除指定ID友情链接
 public static void DeleteNewsFL(int pintNewsFLID)
 {
  string strSQL = "DELETE FROM NewsFriendLink WHERE NewsFLID=@NewsFLID";
  SqlParameter[] parms = new SqlParameter[1];
  parms[0] = new SqlParameter("@NewsFLID", SqlDbType.Int);
  parms[0].Direction = ParameterDirection.Input;
  parms[0].Value = pintNewsFLID;
  DBTools.CreateStoredProcedure(strSQL, parms);
 }
 [SqlProcedure]
 //添加新友情链接
 public static void AddNewsFL(int pintNewsFLImage, string pstrNewsFLTitle,string pstrNewsFlImageURL,string pstrNewsFLNaviagteURL)
 {
  string strSQL = @"INSERT INTO NewsFriendLink (NewsFLImage,NewsFLTitle,NewsFLImageURL,NewsFLNavigateURL) 
                  VALUES(@NewsFLImage,@NewsFLTitle,@NewsFLImageURL,@NewsFLNavigateURL);SELECT @@IDENTITY";
  SqlParameter[] parms = new SqlParameter[4];
  parms[0] = new SqlParameter("@NewsFLImage", SqlDbType.Int);
  parms[0].Direction = ParameterDirection.Input;
  parms[0].Value = pintNewsFLImage;
  parms[1] = new SqlParameter("@NewsFLTitle", SqlDbType.NVarChar, 50);
  parms[1].Direction = ParameterDirection.Input;
  parms[1].Value = pstrNewsFLTitle;
  parms[2] = new SqlParameter("@NewsFLImageURL", SqlDbType.NVarChar, 20);
  parms[2].Direction = ParameterDirection.Input;
  parms[2].Value = pstrNewsFlImageURL;
  parms[3] = new SqlParameter("@NewsFLNavigateURL", SqlDbType.NVarChar, 50);
  parms[3].Direction = ParameterDirection.Input;
  parms[3].Value = pstrNewsFLNaviagteURL;
  DBTools.CreateStoredProcedure(strSQL, parms);
 }
};