Ticket #2 (new 日常维护) — at Version 1
对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]]
Note: See
TracTickets for help on using
tickets.
![(please configure the [header_logo] section in trac.ini)](http://www1.pconline.com.cn/hr/2009/global/images/logo.gif)