USE [MyAssetsDB]
GO
/****** 对象: View [dbo].[累计折旧查询视图] 脚本日期: 05/19/2007 10:57:29 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[累计折旧查询视图]
AS
SELECT TOP (100) PERCENT dbo.基本档案.使用部门, dbo.基本档案.所属类别,
dbo.基本档案.资产编号, dbo.基本档案.资产名称, dbo.基本档案.资产原值,
dbo.基本档案.折旧方法, dbo.基本档案.月度折旧额, dbo.累计折旧表.折旧年份,
dbo.累计折旧表.折旧月份
FROM dbo.基本档案 INNER JOIN
dbo.累计折旧表 ON dbo.基本档案.资产编号 = dbo.累计折旧表.资产编号
ORDER BY 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 = 223
Right = 179
End
DisplayFlags = 280
TopColumn = 0
End
Begin Table = "累计折旧表"
Begin Extent =
Top = 6
Left = 217
Bottom = 219
Right = 358
End
DisplayFlags = 280
TopColumn = 0
End
End
End
Begin SQLPane =
End
Begin DataPane =
Begin ParameterDefaults = ""
End
End
Begin CriteriaPane =
Begin ColumnWidths = 11
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#固定资产管理系统.rar
共112个文件
cs:42个
aspx:41个
sql:15个
需积分: 10 4 下载量 61 浏览量
2009-01-21
09:18:51
上传
评论
收藏 2.85MB RAR 举报
温馨提示
一套固定资产管理系统源码,转自51aspx
资源推荐
资源详情
资源评论
收起资源包目录
C#固定资产管理系统.rar (112个子文件)
OperatorForm.aspx 24KB
MyAssetsForm.aspx 19KB
RepairedForm.aspx 14KB
RepairForm.aspx 13KB
ReturnForm.aspx 12KB
SubtractForm.aspx 12KB
LeaseForm.aspx 12KB
RegisterUser.aspx 11KB
PasswordRecovery.aspx 10KB
MyFittingsForm.aspx 9KB
UserPassword.aspx 9KB
ComputeForm.aspx 8KB
ReportCardPrint.aspx 8KB
ReportCardForm.aspx 7KB
CompanyForm.aspx 7KB
DepartmentForm.aspx 6KB
QueryDepreciationForm.aspx 6KB
Login.aspx 5KB
ReportDepreciationForm.aspx 4KB
UserInfo.aspx 4KB
ReportTypePrint.aspx 4KB
SumDepreciationForm.aspx 4KB
ReportDepartmentPrint.aspx 4KB
ReportDepreciationPrint.aspx 3KB
QueryReturnPrint.aspx 3KB
QueryLeasePrint.aspx 3KB
QueryRepairedPrint.aspx 3KB
QueryRepairPrint.aspx 3KB
QuerySubtractPrint.aspx 3KB
ReportDepartmentForm.aspx 3KB
SumDepreciationPrint.aspx 2KB
ReportTypeForm.aspx 2KB
AllErrorHelp.aspx 2KB
QueryDepreciationPrint.aspx 2KB
QueryRepairedForm.aspx 2KB
QuerySubtractForm.aspx 2KB
QueryRepairForm.aspx 2KB
QueryReturnForm.aspx 2KB
QueryLeaseForm.aspx 2KB
Logout.aspx 2KB
Default.aspx 429B
web.config 938B
ComputeForm.aspx.cs 6KB
Login.aspx.cs 5KB
OperatorForm.aspx.cs 4KB
ReportCardPrint.aspx.cs 4KB
MyAssetsForm.aspx.cs 4KB
QuerySubtractForm.aspx.cs 3KB
QueryRepairForm.aspx.cs 3KB
SumDepreciationForm.aspx.cs 3KB
QueryRepairedForm.aspx.cs 3KB
QueryLeaseForm.aspx.cs 3KB
QueryReturnForm.aspx.cs 3KB
ReportDepreciationForm.aspx.cs 3KB
MyFittingsForm.aspx.cs 3KB
ReportCardForm.aspx.cs 3KB
SubtractForm.aspx.cs 2KB
LeaseForm.aspx.cs 2KB
RepairForm.aspx.cs 2KB
RepairedForm.aspx.cs 2KB
MasterPage.master.cs 2KB
ReportTypeForm.aspx.cs 2KB
ReportDepartmentForm.aspx.cs 2KB
ReturnForm.aspx.cs 2KB
QueryDepreciationPrint.aspx.cs 2KB
SumDepreciationPrint.aspx.cs 2KB
ReportDepreciationPrint.aspx.cs 2KB
ReportDepartmentPrint.aspx.cs 2KB
DepartmentForm.aspx.cs 2KB
QueryDepreciationForm.aspx.cs 2KB
QuerySubtractPrint.aspx.cs 2KB
QueryRepairedPrint.aspx.cs 2KB
ReportTypePrint.aspx.cs 2KB
QueryRepairPrint.aspx.cs 2KB
QueryReturnPrint.aspx.cs 2KB
QueryLeasePrint.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
OLongHome.JPG 34KB
HuaAnHome.JPG 26KB
BottomLine.JPG 2KB
MyThinLine.JPG 2KB
OLongLogo.JPG 2KB
MyBoldLine.JPG 2KB
HuaAnLogo.JPG 2KB
MyAssetsDB_log.LDF 832KB
aspnetdb_log.ldf 504KB
MasterPage.master 4KB
MyAssetsDB.mdf 30MB
ASPNETDB.MDF 10MB
Web.sitemap 4KB
累计折旧查询视图.sql 7KB
可用固定资产视图.sql 7KB
操作用户数据表.sql 5KB
共 112 条
- 1
- 2
资源评论
xzqy_soul
- 粉丝: 5
- 资源: 82
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功