Ticket #2 (new 日常维护) — at Version 1

Opened 14 years ago

Last modified 14 years ago

对working_date增加2012年数据

Reported by: xiejing Owned by: xiejing
Priority: major Milestone:
Component: MIS系统 Version:
Keywords: Cc:
Due Date:

Description (last modified by xiejing) (diff)

working_date表的用途:

主要用于在预订资源计算预订单的有效工作日。
没有足够的天数的话就无法预订资源。所以在每一年年末需要将下一年的数据插入到该表中。

添加步骤

1.先确定测试环境和正式环境中,该表的主键是否一致。如果不一致,将测试环境的序列的开始数据修改为正式环境该表主键+1。
2.修改cn.com.pc.mis.data_convert.handy报中的InitWorkingDate文件。
1)修改基本信息

    //这里需要将area表中所有数据id都写进来,用","隔开[[BR]]
    static int[] areaId ={727,767,839,840,856,864,867,11,928,908,828,834,837,849,854,863,865,866,887,929,[[BR]]
                          931,932,933,939,940,829,830,836,841,843,850,860,862,869,871,930,935,938,527,588,608,647,[[BR]]                        671,672,687,688,689,690,707,427,450,451,452,447,448,449,507,508,509,668,1,2,3,4,5,6,7,8,[[BR]]                         9,10,227,247,287,307,347,348,367,387,388,389,407,408,428,487,547,548,567,568,569,587,589,[[BR]]                          590,591,627,667,669,670,467,607,609,827,831,832,835,838,842,844,845,846,847,851,852,853,[[BR]]                         855,857,858,859,868,747,787,807,833,848,861,870,909,934,936,937,941};[[BR]]
    //插入数据的开始年份和结束年份
    static int fromYear = 2012;[[BR]]
    static int toYear = 2012;[[BR]]

Change History

comment:1 Changed 14 years ago by xiejing

  • Description modified (diff)
Note: See TracTickets for help on using tickets.