USE [MySaleDB]
GO
/****** 对象: View [dbo].[累计采购商品视图] 脚本日期: 05/25/2007 15:19:13 **5*1*a*spx*/
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'累计采购商品视图'
没有合适的资源?快使用搜索试试~ 我知道了~
商品销售管理系统源码
共120个文件
cs:46个
aspx:45个
sql:14个
3星 · 超过75%的资源 需积分: 16 115 下载量 151 浏览量
2009-07-21
11:27:04
上传
评论 9
收藏 5.67MB RAR 举报
温馨提示
商品销售管理系统源码 功能模块有: 客户管理:供应客户管理 供应客户报表 采购客户管理 采购客户报表 商品管理:商品信息设置 查询入库商品 汇总入库商品 查询出库商品 汇总出库商品 查询库存商品 采购管理:采购入库登记 采购退货登记 支付采购货款 收到采购退款 结转采购货款 销售管理:销售出库登记 销售退货登记 收到销售货款 支付销售退款 结转销售货款 系统管理:登录管理系统 新建操作用户 修改用户信息 修改用户密码 查询用户密码 分配用户权限 公司信息设置 系统帮助信息
资源推荐
资源详情
资源评论
收起资源包目录
商品销售管理系统源码 (120个子文件)
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
BuyPaymentPrint.aspx 4KB
SaleAddPrint.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 10KB
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
SupplierReportPrint.aspx.cs 2KB
SaleRefundmentPrint.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 995B
Logout.aspx.cs 842B
UserInfo.aspx.cs 833B
UserPassword.aspx.cs 476B
PasswordRecovery.aspx.cs 470B
RegisterUser.aspx.cs 468B
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
共 120 条
- 1
- 2
资源评论
- xiamuu2015-10-29可以运行!不过数据库乱码了!!!
- 叫我王小贱2011-12-27代码运行程序都有,很不错的资源
- qq_399114342018-01-02内容损坏,无法打开
- MaplePC2018-01-10是重庆华安纸业有限公司的销售管理系统,登录界面排版错乱,样式老旧,功能好像还挺多,总体不推荐
- lilanggao2014-02-13代码运行程序都有,很不错的资源
ss_geng
- 粉丝: 319
- 资源: 3219
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
最新资源
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功