package UIK.UIK08;

import java.sql.SQLException;

import CoreFS.SA01.CoreIComponent;
import CoreFS.SA06.CoreReturnObject;

public class UIK080010 extends CoreIComponent {
	
public CoreReturnObject DoQuery(String start, String end,String number,Boolean flag)
			throws SQLException {
        
		CoreReturnObject cro = new CoreReturnObject();
        String str = "A.ROLL_SEQ,A.CUR_LOAD_LOC_F,A.CUR_LOAD_LOC_T,A.COIL_NO,A.CR_NO,A.REG_ID,A.REG_DTIME,A.REG_SHIFT,A.REG_GROUP,B.USERNAME,A.REG_USE_DTIME,A.MOVE_TYPE";
		if(!flag){
      
			String sqlQuery="select " + str
			+ " from c_tbk08_coil_move A,core_app_user B where A.REG_ID=B.USERID(+) AND A.COIL_NO='"+number+"'";
	        cro = this.getDao("KgDao").ExcuteQuery(sqlQuery);
				return cro;
		
		}
		else{
			  String sqlQuery = "select " + str
				+ " from c_tbk08_coil_move A,core_app_user B where A.REG_ID=B.USERID(+) AND A.REG_DTIME>='" + start+ "' and REG_DTIME<='" + end + "' ";
		cro = this.getDao("KgDao").ExcuteQuery(sqlQuery);
		      return cro;
        
		} 

		
	}
}