chuanyin-group-project.git

工作分工
组织架构  图片
工作职责
工作内容

菜单  行政管理=》工作分工   10
工作分工=》工作职责   /Pages/work/GongzuozhizeList.aspx  02

新增工作职责  case_addModel
批量删除   case_onAllDeleteList
修改   case_CarEdit
删除   case_Shanchu

工作分工=》工作内容分类   /Pages/work/GongzuoneirongCateList.aspx  04

新增工作内容分类  case_addModel
批量删除   case_onAllDeleteList
修改   case_CarEdit
删除   case_CarDele

工作分工=》工作内容   /Pages/work/GongzuoneirongList.aspx  03

新增工作内容  case_addModel
批量删除   case_onAllDeleteList
修改   case_CarEdit
删除   case_Shanchu

工作分工=》 组织架构  /Pages/work/Gongzuozuzhijiagou.aspx  01

USE [ECTEST_NEW]
GO

/****** Object:  Table [dbo].[OA_Gongzuozhize]    Script Date: 2025/11/18 8:59:55 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[OA_Gongzuozhize](
 [Keyid] [int] IDENTITY(1,1) NOT NULL,
 [MemberId] [uniqueidentifier] NULL,
 [Gongzuozhize] [nvarchar](500) NULL,
 [Zerenren] [int] NULL,
 [ZerenrenName] [nvarchar](20) NULL,
 [CreateTime] [datetime] NULL,
 [Creator] [nvarchar](20) NULL,
 [LastUpdateTime] [datetime] NULL,
 [Updator] [nvarchar](20) NULL,
 CONSTRAINT [PK_OA_Gongzuozhize] PRIMARY KEY CLUSTERED
(
 [Keyid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

USE [ECTEST_NEW]
GO

/****** Object:  Table [dbo].[OA_GongzuoneirongCate]    Script Date: 2025/11/20 9:20:55 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[OA_GongzuoneirongCate](
 [Keyid] [int] IDENTITY(1,1) NOT NULL,
 [MemberId] [uniqueidentifier] NULL,
 [Name] [nvarchar](500) NULL,
 [Status] [int] NULL,
 [LastUpdateTime] [datetime] NULL,
 [Operator] [varchar](20) NULL,
 [Remark] [varchar](200) NULL,
 CONSTRAINT [PK_OA_GongzuoneirongCate] PRIMARY KEY CLUSTERED
(
 [Keyid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

USE [ECTEST_NEW]
GO

/****** Object:  Table [dbo].[OA_Gongzuoneirong]    Script Date: 2025/11/18 8:59:55 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[OA_Gongzuoneirong](
 [Keyid] [int] IDENTITY(1,1) NOT NULL,
 [MemberId] [uniqueidentifier] NULL,
 [Gongzuozhize] [nvarchar](500) NULL,
 [Zerenren] [int] NULL,
 [ZerenrenName] [nvarchar](20) NULL,
 [CreateTime] [datetime] NULL,
 [Creator] [nvarchar](20) NULL,
 [LastUpdateTime] [datetime] NULL,
 [Updator] [nvarchar](20) NULL,
 CONSTRAINT [PK_OA_Gongzuoneirong] PRIMARY KEY CLUSTERED
(
 [Keyid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO