sqlserver數(shù)據(jù)庫原理課程設(shè)計工資管理系統(tǒng)設(shè)計(已改無錯字)
2023-05-08 06:40:26 本頁面
【正文】 tment_ID_1 varchar(4))as declare@Department_ID varchar(4)。begin set @Department_ID=@Department_ID_1。 if @Department_ID=39。39。 select *from Department_Info。 else select *from Department_Info where Department_ID = @Department_ID。 end3. 增加獎罰記錄USE SalaryGOCREATE PROCEDURE insert_Reward_pun(@Record_ID bigint,@Emp_ID varchar(15),@Emp_Name varchar(8),@Record_date datetime,@Record_type varchar(2),@Record_content varchar(30),@Record_reason varchar(30),@Allow_unit varchar(20),@Remark varchar(200))AS INSERT INTO Reward_pun(Record_ID,Emp_ID,Emp_Name,Record_date,Record_type,Record_content,Record_reason,Allow_unit,Remark)VALUES(@Record_ID,@Emp_ID,@Emp_Name,@Record_date,@Record_type,@Record_content,@Record_reason,@Allow_unit,@Remark)。4. 按員工編號 月份 更新出勤信息Use SalaryGOCREATE PROCEDURE update_Allowance(@Emp_ID Varchar(15),@Emp_Name varchar(8),@Months_ID varchar(10),@Months_days int,@Holidays int,@Work_days int,@Business_days int,@Absent_days int,@Leave_days int,@Late_days int,@Leave_early_times int)AS UPDATE Attendance_infoset Emp_ID = @Emp_ID, Emp_Name = @Emp_Name, Months_ID = @Months_ID, Months_days = @Months_days, Holidays = @Holidays, Work_days = @Work_days, Business_days = @Business_days, Absent_days = @Absent_days, Leave_days = @Leave_days, Late_days =@Late_days, Leave_early_times =@Leave_early_timesWhere Emp_ID = @Emp_ID and Months_ID = @Months_ID。5. 插入工資 基本工資根據(jù)員工職務(wù)插入 津貼根據(jù)員工ID和月份查找 再插入 Use SalaryGOCREATE PROCEDURE insert_Emp_Salary(@Emp_ID Varchar(15),@House_Allowance Float,@Trade_union_fee Float,@Utilities_fee Float,@House_fund Float,@Endownment_insutance Float,@Rewards_punishment Float,@Total_salary Float,@Ine_tax Float,@Duty Varchar(10),@Month_ID Varchar(10))AS DECLARE@Base_Salary float,@Allowance_Salary float, @Base_Salary_c CURSOR SELECT , from Base_Salary b,Allowance a where = @Month_ID and = @Emp_ID and = @DutyBEGINOPEN @BASE_SALARY_cfetch next from @Base_Salary_c into @Base_Salary,@Allowance_Salary INSERT INTO Emp_Salary (Emp_ID, Base_Salary, House_Allowance, Allowance_Salary, Trade_union_fee, Utilities_fee, House_fund, Endownment_insutance, Rewards_punishment, Total_salary, Ine_tax, Duty, Month_ID) VALUES(@Emp_ID, @Base_Salary, @House_Allowance, @Allowance_Salary, @Trade_union_fee, @Utilities_fee, @House_fund, @Endownment_insutance, @Rewards_punishment, @Total_salary, @Ine_tax, @Duty, @Month_ID)CLOSE @Base_Salary_c。DEALLOCATE @Base_Salary_c。END6. 按部門編號刪除部門信息USE SalaryGO create PROCEDURE delete_Department_Info(@Department_ID VARCHAR(4))AS DECLARE@Department_ID_1 varchar(4),@Department_ID_cursor CURSORSELECT Department_ID from Department_InfoOPEN @Department_ID_cursorfetch next from @Department_ID_cursor into @Department_ID_1if(@Department_ID_1 = @Department_ID) begin DELETE FROM Department_Info WHERE Department_ID = @Department_ID。 print39。刪除成功39。 endelse begin print39。部門信息不存在39。 endclose @Department_ID_cursor。deallocate @Department_ID_cursor。7. 按記錄編號刪除獎罰記錄USE SalaryGO create PROCEDURE delete_Reward_pun(@Record_ID bigint)as declare@Record_ID_1 bigint,@Record_ID_cursor cursorselect Record_ID from Reward_punopen @Record_ID_cursorfetch next from @Record_ID_cursor into @Record_ID_1if @Record_ID_1 = @Record_IDbegindelete from Reward_pun where Record_ID = @Record_ID。print39。刪除成功39。endelsebeginprint39。記錄不存在39。endclose @Record_ID_cursor。deallocate @Record_ID_cursor。 創(chuàng)建觸發(fā)器 1. 刪除一條員工信息 一并刪除相關(guān)員工信息crea
公司管理相關(guān)推薦
鄂ICP備17016276號-1