一天多次请假设置：1、修改明细表（PleaseIll_Detail）主键，原来主键为EmpNo,YYMMDD修改为ID,EmpNo,YYMMDD另外几张明细表也修改一下如PleaseIll_Detail_B_L,PleaseIll_Detail_L,PleaseIll_Detail_B2、修改请假资料保存之前过程（EMHR_GetPleaseIll_Info），修改这个原因为同一天多次请假会提示‘请假已超出范围不允许录入’等，修改过程为CREATEPROCEDUREEMHR_GetPleaseIll_Info@IDvarchar(20),@BDsmalldatetime,@EDsmalldatetime,@BTvarchar(5),@ETvarchar(5),@EmpNovarchar(20),@LeaveTypevarchar(10),@WorkTypeIDvarchar(20),@infovarchar(100)outputASDECLARE@Old_IDvarchar(20)select@Old_ID=IDfromPleaseIll_MasterwhereEmpNo=@EmpNoandID<>@IDand((BD<=@BDandED>=@BDand(BT<=@BTandET>=@BTorBT<=@ETandET>=@ETor@BT<=BTand@ET>=ET))or(BD<=@EDandED>=@EDand(BT<=@BTandET>=@BTorBT<=@ETandET>=@ETor@BT<=BTand@ET>=ET))or(@BD<=BDand@ED>=EDand(BT<=@BTandET>=@BTorBT<=@ETandET>=@ETor@BT<=BTand@ET>=ET)))if@Old_IDisnotnullset@info='NoteㄩTheDataIsHasRepetitionㄛPleaseCheckIDㄩ'+@Old_ID+'﹝AreyouContinueSaveDataˋ'elseset@info=null3、修改请假明细产生过程EMHR_PleaseIll_Process1中以下内容--4，数据保存与执行考勤存储过程；if@ID<>'TEST'beginset@sSQL='ifnotexists(select*from'+@TableName+'whereYYMMDD='''+convert(varchar(8),@YYMMDD,112)+'''andEmpNo='''+@EmpNo+''')''''+convert(varchar(8),@YYMMDD,112)+''','''+@EmpNo+''',2'exec(@sSQL)end把这里的判断是否存在条件中的where后面添加ID='''+@ID+'''and4、考勤过程中取请假资料的语句修改SELECT@KQ_illTime=D.Times,@PleaseIll_AddWorkTimes=D.AddWorkTimes,@KQ_illType=M.LeaveType,@PleaseIll_SID=W.SID,@PleaseIll_Bt=casewhenM.BD=@YYMMDDthencast(left(M.Bt,2)*60assmallint)+cast(right(M.Bt,2)assmallint)else-1end,@PleaseIll_Et=casewhenM.ED=@YYMMDDthencast(left(M.Et,2)*60assmallint)+cast(right(M.Et,2)assmallint)else-1endFROMPleaseIll_DetailDLEFTOUTERJOINPleaseIll_MasterMOND.Id=M.IdLEFTOUTERJOINWorkTypeWONM.WorkTypeId=W.WorkTypeIDwhereD.YYMMDD=@YYMMDDandHYPERLINK"mailto:D.EmpNo=@EmpNo"D.EmpNo=@EmpNo下面添加重新取得请假时数和请假类别的语句：select@KQ_illTime=sum(IsNull(Times,0))fromPleaseIll_DetailwhereYYMMDD=@YYMMDDandEmpNo=@EmpNo--取请假时数if@KQ_illTime>0beginset@KQ_illType=''select@KQ_illType=@KQ_illType+M.LeaveType+''fromPleaseIll_DetailDLEFTOUTERJOINPleaseIll_Mast