KIS WISE 12.1版本中的多工厂日历过期了怎么办？

KIS WISE 12.1版本中的多工厂日历过期了怎么办？

declare @a int,@Finterid int,@Fdayid int ,@FWeekID int,@FYearID int,@FMonthID int
select @Finterid=max(Finterid),@Fdayid=max(Fdayid) from t_MutiWorkCal
set @a=0
while(@a<4*365)
begin
select @FYearID=(year(MAX ( Convert(datetime,FDay )+1))-year(min(fday)))+1 from t_MutiWorkCal
select @FWeekID=ceiling((MAX (fdayid)-(select MAX (fdayid)from t_MutiWorkCal where FWeekID =1))/7.00+1)from t_MutiWorkCal
select @FMonthID=(year(MAX( Convert(datetime,FDay )+1))-year(min(fday)))*12+MONTH (MAX ( Convert(datetime,FDay )+1)) from t_MutiWorkCal
insert into t_MutiWorkCal(FInterID, FDay, FDayID, FWeekID, FMonthID, FYearID, FCalID, FPreID, FNxtID, FPreDay, FNxtDay)
select @Finterid+1,Convert(datetime,'2017-02-01')+@a,@Fdayid+1,@FWeekID,@FMonthID,@FYearID,999,@Finterid,@Finterid,
Convert(datetime,'2017-02-01')+@a,Convert(datetime,'2017-02-01')+@a
set @a=@a+1 set @Finterid=@Finterid+1 set @Fdayid=@Fdayid+1
end

可以处理的，有需要合作的联系我呀
我的名字即有企鹅号

t_WorkCalendart_MutiWorkCal其中t_MutiWorkCal表确定日期区间，所以只需在后台增加这个表的数据，然后在前台打开工厂日历-->修改-->保存，即可declare @a int,@Finterid int,@Fdayid intselect @Finterid=max(Finterid),@Fdayid=max(Fdayid) from t_MutiWorkCalset @a=0while(@a<4*365)begin insert into t_MutiWorkCal(FInterID, FDay, FDayID, FWeekID, FMonthID, FYearID, FCalID, FPreID, FNxtID, FPreDay, FNxtDay) select @Finterid+1,Convert(datetime,'2011-02-01')+@a,@Fdayid+1,162,37,4,999,@Finterid,@Finterid,Convert(datetime,'2011-02-01')+@a,Convert(datetime,'2011-02-01')+@a set @a=@a+1 set @Finterid=@Finterid+1 set @Fdayid=@Fdayid+1end上面只能修改日期，但周，月，年以及非工作日没有修改到。不知哪位高手指点下