USE [MyPersonnelDB]
GO
/****** 对象: View [dbo].[全部考勤视图] 脚本日期: 05/15/2007 08:08:31 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[全部考勤视图]
AS
SELECT dbo.考勤记录.员工编号, dbo.在职员工视图.所属部门, dbo.在职员工视图.姓名,
dbo.考勤记录.C1, dbo.考勤记录.C2, dbo.考勤记录.C3, dbo.考勤记录.C4,
dbo.考勤记录.C5, dbo.考勤记录.C6, dbo.考勤记录.C7, dbo.考勤记录.C8,
dbo.考勤记录.C9, dbo.考勤记录.C10, dbo.考勤记录.C11, dbo.考勤记录.C12,
dbo.考勤记录.C13, dbo.考勤记录.C14, dbo.考勤记录.C15, dbo.考勤记录.C16,
dbo.考勤记录.C17, dbo.考勤记录.C18, dbo.考勤记录.C19, dbo.考勤记录.C20,
dbo.考勤记录.C21, dbo.考勤记录.C22, dbo.考勤记录.C23, dbo.考勤记录.C24,
dbo.考勤记录.C25, dbo.考勤记录.C26, dbo.考勤记录.C27, dbo.考勤记录.C28,
dbo.考勤记录.C29, dbo.考勤记录.C30, dbo.考勤记录.C31, dbo.考勤记录.考勤年份,
dbo.考勤记录.考勤月份
FROM dbo.考勤记录 INNER JOIN
dbo.在职员工视图 ON 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[58] 4[14] 2[10] 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 = 335
Right = 173
End
DisplayFlags = 280
TopColumn = 1
End
Begin Table = "在职员工视图"
Begin Extent =
Top = 6
Left = 211
Bottom = 332
Right = 364
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 �
没有合适的资源?快使用搜索试试~ 我知道了~
资源推荐
资源详情
资源评论
收起资源包目录
asp.net2管理系统源码(上) (338个子文件)
MonthCheckForm.aspx 52KB
OperatorForm.aspx 27KB
OperatorForm.aspx 24KB
QueryMemberForm.aspx 23KB
PersonnelForm.aspx 22KB
OperatorForm.aspx 22KB
MyAssetsForm.aspx 19KB
RepairedForm.aspx 14KB
RepairForm.aspx 13KB
ReturnForm.aspx 12KB
SubtractForm.aspx 12KB
LeaseForm.aspx 12KB
FamilyForm.aspx 12KB
RegisterForm.aspx 11KB
TrainingForm.aspx 11KB
FromBookToRegisterForm.aspx 11KB
QueryGuestForm.aspx 11KB
RegisterUser.aspx 11KB
RegisterUser.aspx 11KB
RegisterUser.aspx 11KB
RewardsForm.aspx 10KB
ResumeForm.aspx 10KB
PasswordRecovery.aspx 10KB
PasswordRecovery.aspx 10KB
PasswordRecovery.aspx 10KB
BookForm.aspx 9KB
MyFittingsForm.aspx 9KB
YearCheckForm.aspx 9KB
UserPassword.aspx 9KB
UserPassword.aspx 9KB
UserPassword.aspx 9KB
ComputeForm.aspx 9KB
LeaveForm.aspx 9KB
ArchievementForm.aspx 9KB
PayForm.aspx 9KB
QueryCheckForm.aspx 8KB
ComputeForm.aspx 8KB
QuerySalaryForm.aspx 8KB
ReportCardPrint.aspx 8KB
RoomForm.aspx 8KB
QueryMemberPrint.aspx 8KB
CompanyForm.aspx 8KB
ReportCardForm.aspx 7KB
PrintPrint.aspx 7KB
CheckOutPrint.aspx 7KB
ChangeForm.aspx 7KB
CompanyForm.aspx 7KB
CompanyForm.aspx 7KB
PrintForm.aspx 7KB
DepartmentForm.aspx 7KB
QueryDepartmentForm.aspx 7KB
DepositPrint.aspx 6KB
GoodsForm.aspx 6KB
DepartmentForm.aspx 6KB
QueryDepreciationForm.aspx 6KB
Login.aspx 5KB
Login.aspx 5KB
RegisterPrint.aspx 5KB
Login.aspx 5KB
CheckOutForm.aspx 5KB
DepositForm.aspx 5KB
ReportRegisterForm.aspx 5KB
ReportCheckoutForm.aspx 4KB
ConsumeForm.aspx 4KB
RoomStatusForm.aspx 4KB
BookPrint.aspx 4KB
EatingForm.aspx 4KB
TelephoneForm.aspx 4KB
ReportDepreciationForm.aspx 4KB
UserInfo.aspx 4KB
UserInfo.aspx 4KB
UserInfo.aspx 4KB
ReportConsumeForm.aspx 4KB
ReportEatingForm.aspx 4KB
ReportTypePrint.aspx 4KB
ReportTelephoneForm.aspx 4KB
SumDepreciationForm.aspx 4KB
QueryConsumeForm.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
AllErrorHelp.aspx 2KB
QueryDepreciationPrint.aspx 2KB
AllErrorHelp.aspx 2KB
QuerySalaryPrint.aspx 2KB
QueryRepairedForm.aspx 2KB
QuerySubtractForm.aspx 2KB
QueryRepairForm.aspx 2KB
QueryReturnForm.aspx 2KB
QueryLeaseForm.aspx 2KB
QueryCheckPrint.aspx 2KB
QueryDepositForm.aspx 2KB
共 338 条
- 1
- 2
- 3
- 4
资源评论
windbarry
- 粉丝: 0
- 资源: 14
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功