USE [MySaleDB]
GO
/****** 对象: View [dbo].[累计采购商品视图] 脚本日期: 05/25/2007 15:19:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[累计采购商品视图]
AS
SELECT dbo.商品信息.商品编号, dbo.商品信息.商品名称, dbo.商品信息.规格型号,
dbo.商品信息.计量单位, dbo.商品信息.累计采购量, SUM(dbo.采购明细.采购金额)
AS 累计采购金额
FROM dbo.采购明细 INNER JOIN
dbo.商品信息 ON dbo.采购明细.商品编号 = dbo.商品信息.商品编号
GROUP BY dbo.商品信息.商品编号, dbo.商品信息.商品名称, dbo.商品信息.规格型号,
dbo.商品信息.计量单位, dbo.商品信息.累计采购量
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties =
Begin PaneConfigurations =
Begin PaneConfiguration = 0
NumPanes = 4
Configuration = "(H (1[40] 4[20] 2[20] 3) )"
End
Begin PaneConfiguration = 1
NumPanes = 3
Configuration = "(H (1 [50] 4 [25] 3))"
End
Begin PaneConfiguration = 2
NumPanes = 3
Configuration = "(H (1 [50] 2 [25] 3))"
End
Begin PaneConfiguration = 3
NumPanes = 3
Configuration = "(H (4 [30] 2 [40] 3))"
End
Begin PaneConfiguration = 4
NumPanes = 2
Configuration = "(H (1 [56] 3))"
End
Begin PaneConfiguration = 5
NumPanes = 2
Configuration = "(H (2 [66] 3))"
End
Begin PaneConfiguration = 6
NumPanes = 2
Configuration = "(H (4 [50] 3))"
End
Begin PaneConfiguration = 7
NumPanes = 1
Configuration = "(V (3))"
End
Begin PaneConfiguration = 8
NumPanes = 3
Configuration = "(H (1[56] 4[18] 2) )"
End
Begin PaneConfiguration = 9
NumPanes = 2
Configuration = "(H (1 [75] 4))"
End
Begin PaneConfiguration = 10
NumPanes = 2
Configuration = "(H (1[66] 2) )"
End
Begin PaneConfiguration = 11
NumPanes = 2
Configuration = "(H (4 [60] 2))"
End
Begin PaneConfiguration = 12
NumPanes = 1
Configuration = "(H (1) )"
End
Begin PaneConfiguration = 13
NumPanes = 1
Configuration = "(V (4))"
End
Begin PaneConfiguration = 14
NumPanes = 1
Configuration = "(V (2))"
End
ActivePaneConfig = 0
End
Begin DiagramPane =
Begin Origin =
Top = 0
Left = 0
End
Begin Tables =
Begin Table = "采购明细"
Begin Extent =
Top = 6
Left = 38
Bottom = 116
Right = 189
End
DisplayFlags = 280
TopColumn = 0
End
Begin Table = "商品信息"
Begin Extent =
Top = 6
Left = 227
Bottom = 116
Right = 384
End
DisplayFlags = 280
TopColumn = 0
End
End
End
Begin SQLPane =
End
Begin DataPane =
Begin ParameterDefaults = ""
End
End
Begin CriteriaPane =
Begin ColumnWidths = 12
Column = 1440
Alias = 900
Table = 1170
Output = 720
Append = 1400
NewValue = 1170
SortType = 1350
SortOrder = 1410
GroupBy = 1350
Filter = 1350
Or = 1350
Or = 1350
Or = 1350
End
End
End
' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'VIEW', @level1name=N'累计采购商品视图'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'VIEW', @level1name=N'累计采购商品视图'
没有合适的资源?快使用搜索试试~ 我知道了~
资源推荐
资源详情
资源评论
收起资源包目录
商品销售管理系统(C#源码 MySQL) (119个子文件)
OperatorForm.aspx 25KB
RegisterUser.aspx 11KB
PasswordRecovery.aspx 10KB
MerchandiseForm.aspx 10KB
BuyReduceForm.aspx 10KB
SaleReduceForm.aspx 10KB
SupplierForm.aspx 9KB
BuyerForm.aspx 9KB
UserPassword.aspx 9KB
BuyAddForm.aspx 8KB
SaleAddForm.aspx 8KB
CompanyForm.aspx 7KB
Login.aspx 5KB
SaleRefundmentForm.aspx 5KB
BuyRefundmentForm.aspx 5KB
SaleGatheringForm.aspx 5KB
BuyPaymentForm.aspx 5KB
SaleRefundmentPrint.aspx 5KB
BuyRefundmentPrint.aspx 5KB
SaleGatheringPrint.aspx 5KB
SaleReducePrint.aspx 5KB
QueryWarehouseNowPrint.aspx 5KB
SumWarehouseOutPrint.aspx 5KB
SaleTransferForm.aspx 5KB
BuyTransferForm.aspx 5KB
BuyReducePrint.aspx 4KB
SaleAddPrint.aspx 4KB
BuyPaymentPrint.aspx 4KB
SumWarehouseInPrint.aspx 4KB
QueryWarehouseOutPrint.aspx 4KB
QueryWarehouseInPrint.aspx 4KB
UserInfo.aspx 4KB
BuyerReportPrint.aspx 4KB
BuyAddPrint.aspx 4KB
SupplierReportPrint.aspx 4KB
SupplierReportForm.aspx 3KB
QueryWarehouseOutForm.aspx 3KB
QueryWarehouseInForm.aspx 3KB
BuyerReportForm.aspx 3KB
AllErrorHelp.aspx 2KB
QueryWarehouseNowForm.aspx 2KB
SumWarehouseOutForm.aspx 2KB
SumWarehouseInForm.aspx 2KB
Logout.aspx 2KB
Default.aspx 429B
web.config 934B
BuyAddForm.aspx.cs 9KB
SaleReduceForm.aspx.cs 9KB
BuyReduceForm.aspx.cs 9KB
SaleAddForm.aspx.cs 9KB
SaleRefundmentForm.aspx.cs 6KB
BuyRefundmentForm.aspx.cs 6KB
SaleGatheringForm.aspx.cs 6KB
BuyPaymentForm.aspx.cs 6KB
Login.aspx.cs 5KB
OperatorForm.aspx.cs 5KB
BuyAddPrint.aspx.cs 4KB
SaleTransferForm.aspx.cs 4KB
BuyTransferForm.aspx.cs 4KB
QueryWarehouseInForm.aspx.cs 4KB
QueryWarehouseOutForm.aspx.cs 4KB
SupplierReportForm.aspx.cs 4KB
BuyerReportForm.aspx.cs 4KB
BuyReducePrint.aspx.cs 3KB
SaleReducePrint.aspx.cs 3KB
SaleAddPrint.aspx.cs 3KB
QueryWarehouseNowForm.aspx.cs 2KB
SumWarehouseOutForm.aspx.cs 2KB
SumWarehouseInForm.aspx.cs 2KB
MerchandiseForm.aspx.cs 2KB
MasterPage.master.cs 2KB
SupplierForm.aspx.cs 2KB
BuyerForm.aspx.cs 2KB
QueryWarehouseOutPrint.aspx.cs 2KB
QueryWarehouseNowPrint.aspx.cs 2KB
QueryWarehouseInPrint.aspx.cs 2KB
SumWarehouseOutPrint.aspx.cs 2KB
SaleRefundmentPrint.aspx.cs 2KB
SupplierReportPrint.aspx.cs 2KB
SumWarehouseInPrint.aspx.cs 2KB
BuyRefundmentPrint.aspx.cs 2KB
BuyerReportPrint.aspx.cs 2KB
SaleGatheringPrint.aspx.cs 2KB
BuyPaymentPrint.aspx.cs 2KB
Default.aspx.cs 2KB
CompanyForm.aspx.cs 982B
Logout.aspx.cs 842B
UserInfo.aspx.cs 833B
PasswordRecovery.aspx.cs 470B
RegisterUser.aspx.cs 468B
UserPassword.aspx.cs 462B
AllErrorHelp.aspx.cs 459B
ShuangXiHome.JPG 76KB
HuaAnHome.JPG 24KB
BottomLine.JPG 2KB
MyThinLine.JPG 2KB
MyBoldLine.JPG 2KB
ShuangXiLogo.JPG 1KB
HuaAnLogo.JPG 1KB
MySaleDB_log.LDF 832KB
共 119 条
- 1
- 2
anbruce
- 粉丝: 53
- 资源: 93
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功
- 1
- 2
- 3
- 4
- 5
- 6
前往页