ASP.NET C# 工资管理系统

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ca_emp]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[ca_emp] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[pay]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[pay] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[pbcatcol]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[pbcatcol] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[pbcatedt]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[pbcatedt] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[pbcatfmt]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[pbcatfmt] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[pbcattbl]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[pbcattbl] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[pbcatvld]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[pbcatvld] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[popedom]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[popedom] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[temp]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[temp] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[title]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[title] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[userid]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[userid] GO CREATE TABLE [dbo].[ca_emp] ( [id] [char] (6) COLLATE Chinese_PRC_CI_AS NOT NULL , [china_name] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL , [english_name] [char] (10) COLLATE Chinese_PRC_CI_AS NULL , [age] [char] (2) COLLATE Chinese_PRC_CI_AS NULL , [sex] [char] (4) COLLATE Chinese_PRC_CI_AS NULL , [marry] [char] (4) COLLATE Chinese_PRC_CI_AS NULL , [address] [char] (40) COLLATE Chinese_PRC_CI_AS NULL , [telephone] [char] (15) COLLATE Chinese_PRC_CI_AS NULL , [zipcode] [char] (6) COLLATE Chinese_PRC_CI_AS NULL , [reson] [char] (10) COLLATE Chinese_PRC_CI_AS NULL , [title] [char] (10) COLLATE Chinese_PRC_CI_AS NULL , [plevel] [char] (1) COLLATE Chinese_PRC_CI_AS NULL , [department] [char] (10) COLLATE Chinese_PRC_CI_AS NULL , [status] [char] (10) COLLATE Chinese_PRC_CI_AS NULL , [salary] [money] NULL , [rz_date] [datetime] NULL , [degreeno] [char] (20) COLLATE Chinese_PRC_CI_AS NULL , [bankno] [char] (30) COLLATE Chinese_PRC_CI_AS NULL , [password1] [char] (6) COLLATE Chinese_PRC_CI_AS NULL , [shop_id] [char] (6) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[pay] ( [mdate] [datetime] NULL , [id] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , [cqts] [char] (2) COLLATE Chinese_PRC_CI_AS NULL , [tc] [decimal](8, 2) NULL , [qqj] [decimal](8, 0) NULL , [bt] [decimal](19, 4) NULL , [yxygj] [decimal](19, 4) NULL , [mrzbj] [decimal](19, 4) NULL , [syjy] [decimal](19, 4) NULL , [gytk] [decimal](19, 4) NULL , [jkyk] [decimal](19, 4) NULL , [pdyk] [decimal](19, 4) NULL , [gykk] [decimal](19, 4) NULL , [qtkk] [decimal](19, 4) NULL , [yfdx] [decimal](19, 4) NULL , [yfs] [decimal](19, 4) NULL , [zkk] [decimal](19, 4) NULL , [sfs] [decimal](19, 4) NULL , [zjtk] [decimal](19, 4) NULL , [cbf] [decimal](19, 4) NULL , [shop_id] [char] (6) COLLATE Chinese_PRC_CI_AS NULL , [cbj] [decimal](18, 0) NULL , [zjkk] [decimal](18, 0) NULL , [sb] [decimal](18, 0) NULL , [fk] [decimal](18, 0) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[pbcatcol] ( [pbc_tnam] [char] (129) COLLATE Chinese_PRC_CI_AS NOT NULL , [pbc_tid] [int] NULL , [pbc_ownr] [char] (129) COLLATE Chinese_PRC_CI_AS NOT NULL , [pbc_cnam] [char] (129) COLLATE Chinese_PRC_CI_AS NOT NULL , [pbc_cid] [smallint] NULL , [pbc_labl] [varchar] (254) COLLATE Chinese_PRC_CI_AS NULL , [pbc_lpos] [smallint] NULL , [pbc_hdr] [varchar] (254) COLLATE Chinese_PRC_CI_AS NULL , [pbc_hpos] [smallint] NULL , [pbc_jtfy] [smallint] NULL , [pbc_mask] [varchar] (31) COLLATE Chinese_PRC_CI_AS NULL , [pbc_case] [smallint] NULL , [pbc_hght] [smallint] NULL , [pbc_wdth] [smallint] NULL , [pbc_ptrn] [varchar] (31) COLLATE Chinese_PRC_CI_AS NULL , [pbc_bmap] [char] (1) COLLATE Chinese_PRC_CI_AS NULL , [pbc_init] [varchar] (254) COLLATE Chinese_PRC_CI_AS NULL , [pbc_cmnt] [varchar] (254) COLLATE Chinese_PRC_CI_AS NULL , [pbc_edit] [varchar] (31) COLLATE Chinese_PRC_CI_AS NULL , [pbc_tag] [varchar] (254) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[pbcatedt] ( [pbe_name] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL , [pbe_edit] [varchar] (254) COLLATE Chinese_PRC_CI_AS NULL , [pbe_type] [smallint] NULL , [pbe_cntr] [int] NULL , [pbe_seqn] [smallint] NOT NULL , [pbe_flag] [int] NULL , [pbe_work] [char] (32) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[pbcatfmt] ( [pbf_name] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL , [pbf_frmt] [varchar] (254) COLLATE Chinese_PRC_CI_AS NULL , [pbf_type] [smallint] NULL , [pbf_cntr] [int] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[pbcattbl] ( [pbt_tnam] [char] (129) COLLATE Chinese_PRC_CI_AS NOT NULL , [pbt_tid] [int] NULL , [pbt_ownr] [char] (129) COLLATE Chinese_PRC_CI_AS NOT NULL , [pbd_fhgt] [smallint] NULL , [pbd_fwgt] [smallint] NULL , [pbd_fitl] [char] (1) COLLATE Chinese_PRC_CI_AS NULL , [pbd_funl] [char] (1) COLLATE Chinese_PRC_CI_AS NULL , [pbd_fchr] [smallint] NULL , [pbd_fptc] [smallint] NULL , [pbd_ffce] [char] (18) COLLATE Chinese_PRC_CI_AS NULL , [pbh_fhgt] [smallint] NULL , [pbh_fwgt] [smallint] NULL , [pbh_fitl] [char] (1) COLLATE Chinese_PRC_CI_AS NULL , [pbh_funl] [char] (1) COLLATE Chinese_PRC_CI_AS NULL , [pbh_fchr] [smallint] NULL , [pbh_fptc] [smallint] NULL , [pbh_ffce] [char] (18) COLLATE Chinese_PRC_CI_AS NULL , [pbl_fhgt] [smallint] NULL , [pbl_fwgt] [smallint] NULL , [pbl_fitl] [char] (1) COLLATE Chinese_PRC_CI_AS NULL , [pbl_funl] [char] (1) COLLATE Chinese_PRC_CI_AS NULL , [pbl_fchr] [smallint] NULL , [pbl_fptc] [smallint] NULL , [pbl_ffce] [char] (18) COLLATE Chinese_PRC_CI_AS NULL , [pbt_cmnt] [varchar] (254) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[pbcatvld] ( [pbv_name] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL , [pbv_vald] [varchar] (254) COLLATE Chinese_PRC_CI_AS NULL , [pbv_type] [smallint] NULL , [pbv_cntr] [int] NULL , [pbv_msg] [varchar] (254) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[popedom] ( [id] [char] (6) COLLATE Chinese_PRC_CI_AS NOT NULL , [emp] [char] (1) COLLATE Chinese_PRC_CI_AS NOT NULL , [pay2] [char] (1) COLLATE Chinese_PRC_CI_AS NOT NULL , [title] [char] (1) COLLATE Chinese_PRC_CI_AS NOT NULL , [gzb] [char] (1) COLLATE Chinese_PRC_CI_AS NOT NULL , [password] [char] (1) COLLATE Chinese_PRC_CI_AS NOT NULL , [passwordset] [char] (1) COLLATE Chinese_PRC_CI_AS NOT NULL , [setpopedom] [char] (1) COLLATE Chinese_PRC_CI_AS NOT NULL , [setbackup] [char] (1) COLLATE Chinese_PRC_CI_AS NOT NULL , [comeback] [char] (1) COLLATE Chinese_PRC_CI_AS NOT NULL , [clear] [char] (1) COLLATE Chinese_PRC_CI_AS NOT NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[temp] ( [no] [char] (5) COLLATE Chinese_PRC_CI_AS NULL , [姓名] [char] (8) COLLATE Chinese_PRC_CI_AS NULL , [性别] [char] (2) COLLATE Chinese_PRC_CI_AS NULL , [年龄] [char] (2) COLLATE Chinese_PRC_CI_AS NULL , [籍贯] [char] (12) COLLATE Chinese_PRC_CI_AS NULL , [文化程度] [char] (4) COLLATE Chinese_PRC_CI_AS NULL , [职位] [char] (8) COLLATE Chinese_PRC_CI_AS NULL , [底薪] [decimal