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 �
没有合适的资源?快使用搜索试试~ 我知道了~
资源推荐
资源详情
资源评论
收起资源包目录
人事工资管理系统.rar (99个子文件)
第2章 人事工资管理系统
Default.aspx 417B
Images
HuaAnHome.JPG 32KB
OLongLogo.jpg 3KB
MyThinLine.JPG 2KB
BottomLine.JPG 2KB
OLongHome.JPG 24KB
MyBoldLine.JPG 2KB
HuaAnLogo.JPG 2KB
CheckManage
YearCheckPrint.aspx 2KB
MonthCheckForm.aspx 51KB
MonthCheckPrint.aspx.vb 2KB
YearCheckPrint.aspx.vb 2KB
YearCheckForm.aspx 9KB
YearCheckForm.aspx.vb 2KB
MonthCheckPrint.aspx 2KB
MonthCheckForm.aspx.vb 5KB
MasterPage.master.vb 2KB
App_Data
MyPersonnelDB.mdf 30MB
ASPNETDB.MDF 10MB
aspnetdb_log.ldf 504KB
MyPersonnelDB_log.LDF 832KB
MasterPage.master 4KB
Default.aspx.vb 1KB
SystemManage
DepartmentForm.aspx 7KB
OperatorForm.aspx.vb 5KB
RegisterUser.aspx.vb 121B
Logout.aspx 2KB
UserInfo.aspx.vb 561B
Login.aspx.vb 4KB
DepartmentForm.aspx.vb 2KB
PasswordRecovery.aspx 10KB
Logout.aspx.vb 800B
PasswordRecovery.aspx.vb 129B
RegisterUser.aspx 11KB
UserPassword.aspx 9KB
AllErrorHelp.aspx 2KB
AllErrorHelp.aspx.vb 121B
UserInfo.aspx 4KB
CompanyForm.aspx 7KB
Login.aspx 5KB
CompanyForm.aspx.vb 826B
UserPassword.aspx.vb 121B
OperatorForm.aspx 22KB
MySQL
基本档案数据表.sql 4KB
考勤记录数据表.sql 5KB
操作用户数据表.sql 4KB
在职员工视图.sql 7KB
公司信息数据表.sql 2KB
工作简历数据表.sql 2KB
工资核算表数据表.sql 2KB
全部考勤视图.sql 8KB
离职管理数据表.sql 2KB
工作业绩数据表.sql 2KB
MyPersonnelDB数据库.sql 5KB
家庭成员数据表.sql 2KB
公司部门数据表.sql 1KB
培训记录数据表.sql 2KB
工资发放表数据表.sql 3KB
奖惩记录数据表.sql 2KB
SalaryManage
PayPrint.aspx.vb 2KB
PayForm.aspx.vb 2KB
ComputePrint.aspx.vb 2KB
PayPrint.aspx 2KB
ComputeForm.aspx 9KB
PayForm.aspx 9KB
ComputePrint.aspx 2KB
ComputeForm.aspx.vb 11KB
QueryManage
QueryDepartmentForm.aspx 7KB
QueryMemberPrint.aspx 8KB
QueryDepartmentPrint.aspx.vb 2KB
QueryMemberPrint.aspx.vb 5KB
QueryDepartmentForm.aspx.vb 2KB
QueryCheckForm.aspx 8KB
QueryDepartmentPrint.aspx 2KB
QueryMemberForm.aspx.vb 722B
QuerySalaryPrint.aspx 2KB
QueryMemberForm.aspx 23KB
QuerySalaryForm.aspx 8KB
QuerySalaryForm.aspx.vb 4KB
QueryCheckPrint.aspx.vb 2KB
QueryCheckForm.aspx.vb 2KB
QueryCheckPrint.aspx 2KB
QuerySalaryPrint.aspx.vb 2KB
FileManage
ArchievementForm.aspx.vb 2KB
FamilyForm.aspx 11KB
ResumeForm.aspx.vb 2KB
TrainingForm.aspx.vb 2KB
ArchievementForm.aspx 9KB
ResumeForm.aspx 10KB
FamilyForm.aspx.vb 2KB
RewardsForm.aspx 10KB
LeaveForm.aspx 9KB
RewardsForm.aspx.vb 2KB
TrainingForm.aspx 11KB
LeaveForm.aspx.vb 2KB
PersonnelForm.aspx.vb 4KB
PersonnelForm.aspx 22KB
Web.sitemap 4KB
web.config 4KB
共 99 条
- 1
s116121123
- 粉丝: 2
- 资源: 2
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功
- 1
- 2
前往页