排班子系統(tǒng)設(shè)計(jì)與實(shí)現(xiàn)-資料下載頁(yè)
2025-06-30 01:48本頁(yè)面
【正文】 num=@orderNum AND route_id=@routeIDIF @orderNum1 IS NOT NULL BEGIN UPDATE routeTime SET order_num = order_num + 1 WHERE order_num (@orderNum1) AND route_id=@routeID ENDINSERT INTO routeTime (route_id,order_num,leave_time) VALUES (@routeID,@orderNum,@leaveTime)ENDGO25觸發(fā)器定義/*插入班次*/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO ============================================= Author: Author,Name Create date: Create Date, Description: Description, =============================================CREATE TRIGGER inster_routeTime ON routeTime INSTEAD OF INSERTAS DECLARE @orderNum intDECLARE @orderNum1 intDECLARE @routeID varchar(10)DECLARE @leaveTime0 datetimeDECLARE @leaveTime1 datetimeDECLARE @leaveTime2 datetime獲取插入線路編號(hào)及班次序號(hào)select @leaveTime0=leave_time,@orderNum = order_num,@routeID = route_id FROM inserted判斷同線路是否已存在該班次序號(hào)select @orderNum1=order_num FROM routeTime WHERE order_num=@orderNum AND route_id=@routeIDIF @orderNum1 IS NOT NULL BEGIN PRINT 39。該線路已經(jīng)存在該班次序號(hào)39。 提示錯(cuò)誤信息 raiserror(39。該線路已經(jīng)存在該班次序號(hào)39。,16,1) print @orderNum print @routeID ROLLBACK TRANSACTION 回滾 ENDELSE BEGIN select @leaveTime1=leave_time FROM routeTime WHERE order_num= @orderNum1 AND route_id=@routeID select @leaveTime2=leave_time FROM routeTime WHERE order_num= @orderNum+1 AND route_id=@routeID IF @leaveTime1 IS NULL BEGIN set @leaveTime1 = @leaveTime0 END IF @leaveTime2 IS NULL BEGIN set @leaveTime2 = @leaveTime0 END IF @leaveTime0 @leaveTime1 OR @leaveTime0 @leaveTime2 BEGIN raiserror(39。發(fā)車(chē)時(shí)間輸入有誤，比上一序號(hào)時(shí)間小或比下一序號(hào)發(fā)車(chē)時(shí)間大39。,16,1) PRINT 39。發(fā)車(chē)時(shí)間輸入有誤，比上一序號(hào)時(shí)間小或比下一序號(hào)發(fā)車(chē)時(shí)間大39。 ROLLBACK TRANSACTION END ELSE BEGIN INSERT INTO routeTime (route_id,order_num,leave_time) VALUES (@routeID,@orderNum,@leaveTime0) END END/*更新班次*/USE [test1]GOSET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE TRIGGER [dbo].[update_routeTime] ON [dbo].[routeTime] AFTER UPDATEAS DECLARE @orderNum intDECLARE @orderNum1 intDECLARE @routeID varchar(10)DECLARE @leaveTime0 datetimeDECLARE @leaveTime1 datetimeDECLARE @leaveTime2 datetime獲取插入線路編號(hào)及班次序號(hào)select @leaveTime0=leave_time,@orderNum = order_num,@routeID = route_id FROM inserted判斷同線路是否已存在該班次序號(hào)select @orderNum1=order_num FROM routeTime WHERE order_num=@orderNum AND route_id=@routeID/*IF @orderNum1 IS NOT NULL BEGIN PRINT 39。該線路已經(jīng)存在該班次序號(hào)39。 提示錯(cuò)誤信息 raiserror(39。該線路已經(jīng)存在該班次序號(hào)39。,16,1) print @orderNum print @routeID ROLLBACK TRANSACTION 回滾 ENDELSE*/ BEGIN select @leaveTime1=leave_time FROM routeTime WHERE order_num= @orderNum1 AND route_id=@routeID select @leaveTime2=leave_time FROM routeTime WHERE order_num= @orderNum+1 AND route_id=@routeID IF @leaveTime1 IS NULL BEGIN set @leaveTime1 = @leaveTime0 END IF @leaveTime2 IS NULL BEGIN set @leaveTime2 = @leaveTime0 END IF @leaveTime0 @leaveTime1 OR @leaveTime0 @leaveTime2 BEGIN raiserror(39。發(fā)車(chē)時(shí)間輸入有誤，比上一序號(hào)時(shí)間小或比下一序號(hào)發(fā)車(chē)時(shí)間大39。,16,1) ROLLBACK TRANSACTION END ENDGO 附錄3 全局ER圖圖3—1全局ER圖 附錄4 系統(tǒng)截圖對(duì)于司機(jī)：：圖1 修改密碼 圖2 查看排班 圖3線路查詢4. 站點(diǎn)查詢5. 圖4站點(diǎn)查詢6. 查詢所有排班圖5查詢所有排班對(duì)于管理員： 修改自己的密碼同附錄圖1 線路查詢同附錄圖3 站點(diǎn)查詢同附錄圖4 排班查詢同附錄圖5 線路更改 圖6 線路更改 線路增加圖7 線路增加 員工錄入 圖8員工錄入 員工刪減圖9員工
化學(xué)相關(guān)推薦
鄂ICP備17016276號(hào)-1