ManageAdjustChangeHoliday.java 1.64 KB
Newer Older
TongZuu committed
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46
package com.csc.library.timeattendance;

import java.util.Vector;

import com.csc.library.session.DbInquiry;
import com.csc.library.session.DbRecord;
import com.csc.library.session.InitialInquiry;
import com.csc.library.utilities.MyLog;
import com.csc.library.utilities.UProfile;

public class ManageAdjustChangeHoliday {
private UProfile upf ;
	
	public ManageAdjustChangeHoliday(UProfile upf){
		this.upf = upf;
	}
	
	/* ֧š ҧشѾഷ ͹㹵ҧ Tadjtime0 */
	public Vector getAdjustChangeHolidayData(WorkingShift ws,DbRecord empRec){
		Vector vUpdateData = new Vector();
		try {
			/* ֧¹ѹش Vector */
			StringBuffer filter = new StringBuffer();
			filter.append("employeeid = '").append(empRec.getString("employeeid")).append("' and ");
			filter.append(" (");
			filter.append(" (change_date1 >= '").append(ws.getBeginDate().getYYYYMMDD()).append("' and change_date1 <= '").append(ws.getEndDate().getYYYYMMDD()).append("')"); 
			filter.append(" or "); 
			filter.append(" (change_date2 >= '").append(ws.getBeginDate().getYYYYMMDD()).append("' and change_date2 <= '").append(ws.getEndDate().getYYYYMMDD()).append("')");
			filter.append(" )");
	
			DbInquiry inqChHoliday = new InitialInquiry(this.upf).getDbInquiry("TCHHOLIDAY");
			inqChHoliday.setColumn("*");
			inqChHoliday.setOrderBy("runno");
			inqChHoliday.setFilter(filter.toString());
			inqChHoliday.refresh();
			
			while(inqChHoliday.next()){
				vUpdateData.add(inqChHoliday.getCurrentDbRecord().cloneRecord(false));
			}
			
		}catch(Exception e){
			MyLog.error(this,e);
		}
		return vUpdateData;
	}
}