newssystemsp.cs

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

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 GetAllSystemValue()
 {
  string strSQL = "SELECT * FROM NewsSystem";
  DBTools.CreateStoredProcedure(strSQL);
 }

 [Microsoft.SqlServer.Server.SqlProcedure]
 //获取指定键值的系统设定值
 public static void GetSystemValue(string pstrSystemKey)
 {
  string strSQL = "SELECT NewsSystemContent FROM NewsSystem WHERE NewsSystemItem=@NewsSystemItem";
  SqlParameter[] parms = new SqlParameter[1];
  parms[0] = new SqlParameter("@NewsSystemItem", SqlDbType.NVarChar,20);
  parms[0].Direction = ParameterDirection.Input;
  parms[0].Value = pstrSystemKey;
  DBTools.CreateStoredProcedure(strSQL,parms);
 }
 [Microsoft.SqlServer.Server.SqlProcedure]
 //设置指定键值的系统设定值
 public static void SetSystemValue(string pstrSystemKey,string pstrSystemValue)
 {
  string strSQL = @"UPDATE NewsSystem SET NewsSystemContent=@NewsSystemContent
                   WHERE NewsSystemItem=@NewsSystemItem";
  SqlParameter[] parms = new SqlParameter[2];
  parms[0] = new SqlParameter("@NewsSystemItem", SqlDbType.NVarChar, 20);
  parms[0].Direction = ParameterDirection.Input;
  parms[0].Value = pstrSystemKey;
  parms[1] = new SqlParameter("@NewsSystemContent", SqlDbType.NVarChar, 500);
  parms[1].Direction = ParameterDirection.Input;
  parms[1].Value = pstrSystemValue;
  DBTools.CreateStoredProcedure(strSQL, parms);
 }
 [Microsoft.SqlServer.Server.SqlProcedure]
 //添加指定键值的系统设定值
 public static void AddSystemValue(string pstrSystemKey,string pstrSystemValue)
 {
  string strSQL = "INSERT INTO NewsSystem (NewsSystemItem,NewsSystemContent) VALUES (@NewsSystemItem,@NewsSystemContent);SELECT @@IDENTITY";
  SqlParameter[] parms = new SqlParameter[2];
  parms[0] = new SqlParameter("@NewsSystemItem", SqlDbType.NVarChar, 20);
  parms[0].Direction = ParameterDirection.Input;
  parms[0].Value = pstrSystemKey;
  parms[1] = new SqlParameter("@NewsSystemContent", SqlDbType.NVarChar, 500);
  parms[1].Direction = ParameterDirection.Input;
  parms[1].Value = pstrSystemValue;
  DBTools.CreateStoredProcedure(strSQL, parms);
 }

 [SqlProcedure]
 //根据ID获取系统设置
 public static void GetSystemSettingByID(int pintSystemID)
 {
  string strSQL = "SELECT * FROM NewsSystem WHERE NewsSystemID=@SystemID";
  SqlParameter[] parms = new SqlParameter[1];
  parms[0] = new SqlParameter("@SystemID", SqlDbType.Int);
  parms[0].Direction = ParameterDirection.Input;
  parms[0].Value = pintSystemID;
  DBTools.CreateStoredProcedure(strSQL, parms);
 }
};