ASP.NETÖг£ÓõĴ洢¹ý³Ì

1.²éѯ¹¦ÄÜ£º
ÃèÊö£ºÍ¨³£ÔÚÍøÒ³Éϸù¾Ýµã»÷²éѯ°´Å¥»ñµÃËùÒª½á¹û
Àý£º
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
-- =============================================
-- Author:±ù˪
-- Create date: 2009-09-04
-- Description:²éѯ
-- =============================================
Alter PROCEDURE [dbo].[KDF_PackageMeetingRoom_Examine]
(
@HotelID varchar(20),
@State int,
@StartDate varchar(30),
@EndDate varchar(30)
)
as
DECLARE @MainStr VARCHAR(1000)
set @MainStr='select * from PackageMeetingRoom where ID=ID '
if(@HotelID<>'')
set @MainStr=@MainStr+'and HotelID like'+''''+'%'+@HotelID+'%'+''''
if (@State <> '-1')
set @MainStr=@MainStr+'and State='+''''+convert(varchar(20),@State)+''''
if(@StartDate<>'' or @EndDate<>'')
set @MainStr=@MainStr+'and Dtedate between'''+@StartDate+''''+'and'''+@EndDate+''''
set @MainStr=@MainStr+'order by Dtedate desc'
exec (@MainStr)
 
ºÜ²»ºÃÒâ˼,×î½üÓеãæ,ÏÖÔÚ°ÑһЩ³£ÓõĴ洢¹ý³ÌÌù³öÀ´,ÒÔºóÕûÀí
2,²åÈëÔö¼Ó
ALTER PROCEDURE [dbo].[KDF_AccountRecord_Add]
(
@AcNumOrder varchar(50),
@UserID varchar(50),
@TransactionType varchar(20),
@AmountPaid int,
@AmountReceived int
)
AS
insert into AccountRecord
(
AcNumOrder,
UserID,
TransactionType,
AmountPaid,
AmountReceived
)
values
(
@AcNumOrder,
@UserID,
@TransactionType,
@AmountPaid,
@AmountReceived
)
return @@IDENTITY
3.ɾ³ý
ALTER PROCEDURE [dbo].[KDF_AccountRecord_Del]
(
@ID int
)
AS
delete from AccountRecord
    where ID= @ID
4,²éѯ
ALTER PROCEDURE [dbo].[KDF_AccountRecord_ExamineByID]
(
@ID int
)
as
select * from AccountRecord where @ID=ID
Õâ¸öÒÔ¿ÉÒÔ×Ô¼ºÐ´Ò»Ð©Òª²éѯµÄÄÚÈÝ,²»ÍƼöÓÃ*
5.怬
ALTER PROCEDURE [dbo].[KDF_Admin_Login]
(
@AdminName varchar(50),
@AdminPwd varchar(50)
)
AS
if exists
(
SELECT AdminName
from Admin
WHERE AdminName = @AdminName AND AdminPwd = @AdminPwd
)
-- µÇ¼³É¹¦
RETURN 0
if exists
(
SELECT AdminName
from Admin
WHERE AdminName = @AdminName
)