工資管理系統的設計與實現數據庫原理及應用課程設計報告(編輯修改稿)

　

【文章內容簡介】 evel1name=N39。tb_pay39。, @level2type=N39。COLUMN39。, @level2name=N39。Yquanqin39。GOEXEC @name=N39。MS_Description39。, @value=N39。加班工資39。 ,@level0type=N39。SCHEMA39。, @level0name=N39。dbo39。, @level1type=N39。TABLE39。, @level1name=N39。tb_pay39。, @level2type=N39。COLUMN39。, @level2name=N39。Yjiaban39。GOEXEC @name=N39。MS_Description39。, @value=N39。應發工資39。 ,@level0type=N39。SCHEMA39。, @level0name=N39。dbo39。, @level1type=N39。TABLE39。, @level1name=N39。tb_pay39。, @level2type=N39。COLUMN39。, @level2name=N39。Yyingfa39。GOEXEC @name=N39。MS_Description39。, @value=N39。個人所得稅39。 ,@level0type=N39。SCHEMA39。, @level0name=N39。dbo39。, @level1type=N39。TABLE39。, @level1name=N39。tb_pay39。, @level2type=N39。COLUMN39。, @level2name=N39。Ygeren39。GOEXEC @name=N39。MS_Description39。, @value=N39。實發工資39。 ,@level0type=N39。SCHEMA39。, @level0name=N39。dbo39。, @level1type=N39。TABLE39。, @level1name=N39。tb_pay39。, @level2type=N39。COLUMN39。, @level2name=N39。Ypay39。GOEXEC @name=N39。MS_Description39。, @value=N39。工資月份39。 ,@level0type=N39。SCHEMA39。, @level0name=N39。dbo39。, @level1type=N39。TABLE39。, @level1name=N39。tb_pay39。, @level2type=N39。COLUMN39。, @level2name=N39。YMonth39。（6）創建員工獎懲表/*==============================================================*//* Table: tb_prize，員工獎懲表*//*==============================================================*/CREATE TABLE [dbo].[tb_prize]( [ID] [int] IDENTITY(1,1) NOT NULL, [UserID] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [UserName] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [UserDep] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [UserJF] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [UserJFcontent] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [UserJLMoney] [decimal](18, 2) NULL CONSTRAINT [DF_tb_prize_UserJLMoney] DEFAULT (), [UserFKMoney] [decimal](18, 2) NULL CONSTRAINT [DF_tb_prize_UserFKMoney] DEFAULT (), [UserJFDate] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [UserCXDate] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, CONSTRAINT [PK_tb_prize] PRIMARY KEY CLUSTERED ( [ID] ASC)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]) ON [PRIMARY]GOSET ANSI_PADDING OFFGOEXEC @name=N39。MS_Description39。, @value=N39。員工編號39。 ,@level0type=N39。SCHEMA39。, @level0name=N39。dbo39。, @level1type=N39。TABLE39。, @level1name=N39。tb_prize39。, @level2type=N39。COLUMN39。, @level2name=N39。UserID39。GOEXEC @name=N39。MS_Description39。, @value=N39。姓名39。 ,@level0type=N39。SCHEMA39。, @level0name=N39。dbo39。, @level1type=N39。TABLE39。, @level1name=N39。tb_prize39。, @level2type=N39。COLUMN39。, @level2name=N39。UserName39。GOEXEC @name=N39。MS_Description39。, @value=N39。部門39。 ,@level0type=N39。SCHEMA39。, @level0name=N39。dbo39。, @level1type=N39。TABLE39。, @level1name=N39。tb_prize39。, @level2type=N39。COLUMN39。, @level2name=N39。UserDep39。GOEXEC @name=N39。MS_Description39。, @value=N39。判斷是獎還是罰39。 ,@level0type=N39。SCHEMA39。, @level0name=N39。dbo39。, @level1type=N39。TABLE39。, @level1name=N39。tb_prize39。, @level2type=N39。COLUMN39。, @level2name=N39。UserJF39。GOEXEC @name=N39。MS_Description39。, @value=N39。獎罰內容39。 ,@level0type=N39。SCHEMA39。, @level0name=N39。dbo39。, @level1type=N39。TABLE39。, @level1name=N39。tb_prize39。, @level2type=N39。COLUMN39。, @level2name=N39。UserJFcontent39。GOEXEC @name=N39。MS_Description39。, @value=N39。獎勵金額39。 ,@level0type=N39。SCHEMA39。, @level0name=N39。dbo39。, @level1type=N39。TABLE39。, @level1name=N39。tb_prize39。, @level2type=N39。COLUMN39。, @level2name=N39。UserJLMoney39。GOEXEC @name=N39。MS_Description39。, @value=N39。罰款金額39。 ,@level0type=N39。SCHEMA39。, @level0name=N39。dbo39。, @level1type=N39。TABLE39。, @level1name=N39。tb_prize39。, @level2type=N39。COLUMN39。, @level2name=N39。UserFKMoney39。GOEXEC @name=N39。MS_Description39。, @value=N39。獎罰日期39。 ,@level0type=N39。SCHEMA39。, @level0name=N39。dbo39。, @level1type=N39。TABLE39。, @level1name=N39。tb_prize39。, @level2type=N39。COLUMN39。, @level2name=N39。UserJFDate39。GOEXEC @name=N39。MS_Description39。, @value=N39。撤銷日期39。 ,@level0type=N39。SCHEMA39。, @level0name=N39。dbo39。, @level1type=N39。TABLE39。, @level1name=N39。tb_prize39。, @level2type=N39。COLUMN39。, @level2name=N39。UserCXDate39。（7）創建權限用戶ID屬性索引/*==============================================================*//* Index: Relationship_3_FK:在用戶權限表用戶ID屬性上創建索引 *//*==============================================================*/create index Relationship_1_FK on tb_User (Id)Go（8）創建用戶權限表/*==============================================================*//* Table: tb_User，用戶權限表 *//*==============================================================*/CREATE TABLE [dbo].[tb_User]( [ID] [int] IDENTITY(1,1) NOT NULL, [UserName] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [UserPwd] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [UserPower] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [LoginTime] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, CONSTRAINT [PK_tb_User] PRIMARY KEY CLUSTERED ( [ID] ASC)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]) ON [PRIMARY]GOSET ANSI_PADDING OFF（9）創建工作崗位表/*==============================================================*//* Table: tb_userJob，工作崗位表 *//*==============================================================*/CREATE TABLE [dbo].[tb_userJob]( [ID] [int] IDENTITY(1,1) NOT NULL, [JobName] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, CONSTRAINT [PK_tb_userJob] PRIMARY KEY CLUSTERED ( [ID] ASC)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]) ON [PRIMARY]GOSET ANSI_PADDING OFF第八章 系統測試對本系統進行測試，寫出測試輸出結果。登陸界面如圖81所示。圖81 系統登陸界面界面代碼如下： public partial class frmLogin : Form { public frmLogin() { InitializeComponent()。 } DBOperate operate = new DBOperate()。//創建操作數據庫對象 private void btnLogin_Click(object sender, EventArgs e) { //try //{ if ( == || == ) { (用戶名或密碼不能為空！, 提示, , )。 return。 } else { string name = ()。//移除用戶名前部和后部的空格