IF NOT EXISTS (SELECT * FROM sys.database_principals WHERE name = N'BUILTIN\Administrators')
CREATE USER [BUILTIN\Administrators] FOR LOGIN [BUILTIN\Administrators]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Pr_UpdateProductCount]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[Pr_UpdateProductCount]
(
@ID int
)
AS
UPDATE
[Product]
SET
ViewCount = ViewCount + 1
WHERE
ID = @ID
RETURN @@ROWCOUNT
'
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Pr_UpdateProduct]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[Pr_UpdateProduct]
(
@ID int,
@Name varchar(200),
@Remark text
)
AS
UPDATE
[Product]
SET
Name = @Name,
Remark = @Remark,
LasterDate = GETDATE()
WHERE
ID = @ID
RETURN @@ROWCOUNT
'
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Pr_DeleteProduct]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[Pr_DeleteProduct]
(
@ID int
)
AS
DELETE
[Product]
WHERE
ID = @ID
RETURN @@ROWCOUNT
'
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Pr_GetAttachmentByProduct]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[Pr_GetAttachmentByProduct]
(
@ProductID int
)
AS
SELECT
*
FROM
ProductAttachment
WHERE
ProductID = @ProductID
ORDER BY
Flag DESC
'
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Pr_GetSingleProductAttachment]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[Pr_GetSingleProductAttachment]
(
@ID int
)
AS
SELECT
*
FROM
ProductAttachment
WHERE
ID = @ID
'
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Pr_DeleteProductAttachment]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[Pr_DeleteProductAttachment]
(
@ID int
)
AS
DELETE
ProductAttachment
WHERE
ID = @ID
RETURN @@ROWCOUNT
'
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Pr_AddProductAttachment]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[Pr_AddProductAttachment]
(
@Name varchar(200),
@Type varchar(100),
@Url varchar(255),
@Size int,
@Flag tinyint,
@ProductInfoID int
)
AS
INSERT INTO
ProductAttachment
([Name],Type,Url,[Size],Flag,ProductID)
VALUES
(@Name,@Type,@Url,@Size,@Flag,@ProductInfoID)
RETURN @@Identity
'
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Pr_GetAttachmentByProductType]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[Pr_GetAttachmentByProductType]
(
@ProductID int,
@Flag tinyint
)
AS
SELECT
*
FROM
ProductAttachment
WHERE
ProductID = @ProductID AND Flag = @Flag
'
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Pr_GetAttachmentByProductFlag]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[Pr_GetAttachmentByProductFlag]
(
@ProductID int,
@Flag tinyint
)
AS
SELECT
*
FROM
ProductAttachment
WHERE
�
完全手册ASP.NETAjax实用开发详解(14-15)
需积分: 10 161 浏览量
2009-01-20
16:39:18
上传
评论
收藏 4.42MB RAR 举报
完全手册ASP.NETAjax实用开发详解(14-15) （417个子文件） 
Global.asax 1KB Global.asax 914B ProductAttribute.ascx 922B LoginUC.ascx 409B LogoffUC.ascx 291B AjaxService.asmx 92B AddProduct.aspx 7KB SearchByTime.aspx 6KB SearchByPrice.aspx 6KB ShowProduct.aspx 6KB SearchByKey.aspx 6KB SearchFellow.aspx 6KB UpdateProduct.aspx 4KB UpdateCategory.aspx 4KB AddCategory.aspx 4KB UpdateCaboodle.aspx 4KB AddCaboodle.aspx 4KB Login.aspx 4KB Product.aspx 3KB ViewShoppingCart.aspx 3KB OrderManage.aspx 3KB Category.aspx 3KB AddCaboodleUser.aspx 3KB MyFile.aspx 3KB MyLeaveword.aspx 3KB CaboodleUserManage.aspx 3KB CaboodleManage.aspx 3KB ViewProductByCategoryCount.aspx 3KB ViewProductByCategoryOrder.aspx 3KB ViewProductByCategoryPrice.aspx 3KB ViewProductByCategoryName.aspx 3KB ViewProductByCategoryTime.aspx 3KB Leaveword.aspx 3KB OrderList.aspx 3KB GroupManage.aspx 3KB FellowManage.aspx 3KB AddGroup.aspx 3KB UpdateGroup.aspx 3KB ViewOrder.aspx 2KB MyMessage.aspx 2KB Product.aspx 2KB Fellow.aspx 2KB AddOrder.aspx 2KB ProductComment.aspx 2KB CaboodleMessaging.aspx 2KB Toolbar.aspx 2KB ShowFellowInfo.aspx 2KB ProductPicture.aspx 2KB Messaging.aspx 2KB ShowLeavewordInfo.aspx 2KB AddFellow.aspx 1KB SelectCaboodle.aspx 1KB MoveFellow.aspx 1KB File.aspx 1KB Toolbar.aspx 1KB Manager.aspx 944B Default.aspx 800B Default.aspx 789B Desktop.aspx 698B Category.aspx 592B Login.aspx 469B ProductCompare.aspx 465B OutputToExcel.aspx 464B OutputToTxt.aspx 460B Header.aspx 447B Header.aspx 441B LogOff.aspx 441B ValidateCode.aspx 111B ValidateCode.aspx 111B AjaxEBusinessDB.bak 1.77MB AjaxInstantMessagingDB.bak 1.71MB info.cd 1KB ShoppingCart.cd 756B caboodle.cd 753B group.cd 738B user.cd 734B Category.cd 452B Order.cd 451B product.cd 450B Web.config 6KB Web.config 6KB User.cs 17KB Product.cs 16KB ShoppingCart.cs 12KB Category.cs 10KB Caboodle.cs 9KB Group.cs 9KB Message.cs 7KB ProductAttribute.ascx.cs 7KB Leaveword.cs 5KB CaboodleMessaging.aspx.cs 4KB File.cs 4KB ASPNETAJAXWeb.cs 4KB ASPNETAJAXWeb.cs 4KB ViewShoppingCart.aspx.cs 3KB File.aspx.cs 3KB ProductPicture.aspx.cs 3KB ShowProduct.aspx.cs 3KB OrderManage.aspx.cs 3KB Messaging.aspx.cs 3KB共 417 条
- 1
- 2
- 3
- 4
- 5
资源评论
