attachmentsp.cs

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

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


public partial class StoredProcedures
{
 //根据ID获取附件URL
 [Microsoft.SqlServer.Server.SqlProcedure]
 public static void GetAttachmentByID(int pAttachmentID)
 {
  string SQL = @"SELECT [AttachmentURL]
                 FROM [Attachment]
                 WHERE [AttachmentID]=@AttachmentID";
  SqlParameter[] parms = new SqlParameter[1];
  parms[0] = new SqlParameter("@AttachmentID", SqlDbType.Int);
  parms[0].Value = pAttachmentID;
  DBTools.CreateStoredProcedure(SQL,parms);
 }
 //添加附件
 [SqlProcedure]
 public static void AddAttachment(string pAttachmentURL)
 {
  string SQL = @"INSERT INTO [Attachment]
                       ([AttachmentURL])
                 VALUES
                       (@AttachmentURL);
                 SELECT @@IDENTITY";
  SqlParameter[] parms = new SqlParameter[1];
  parms[0] = new SqlParameter("@AttachmentURL", SqlDbType.NVarChar, 150);
  parms[0].Value = pAttachmentURL;
  DBTools.CreateStoredProcedure(SQL,parms);
 }
 //删除附件
 [SqlProcedure]
 public static void DeleteAttachmentByID(int pAttachmentID)
 {
  string SQL = @"DELETE FROM [Attachment]
                 WHERE [AttachmentID]=@AttachmentID";
  SqlParameter[] parms = new SqlParameter[1];

  parms[0] = new SqlParameter("@AttachmentID", SqlDbType.Int);
  parms[0].Value = pAttachmentID;

  DBTools.CreateStoredProcedure(SQL);
 }
};