package UIK.UIK05;

import java.sql.SQLException;
import java.text.SimpleDateFormat;
import java.util.*;

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

public class UIK050010 extends CoreIComponent{

	/**
	 * @param args
	 */
	
	public CoreReturnObject DoQueryShang(String zgNum, String zgAr,Boolean flag,String beginTime,String endTime) throws SQLException
	{
			CoreReturnObject cro = new CoreReturnObject();
			
			String str = "SPEC_NO,MEG_FLAG,STAND_ID,ROLL_TYPE,ROLL_ID_UP,ROLL_DIAMETER_UP,ROLL_CROWN_UP,ROLL_ROUGHNESS_UP,ROLL_SHAPE_UP,ROLL_PROPERTY_CLASS,OP_CHOCK_NO_UP,DR_CHOCK_NO_UP,SA1,SA2,SA3,SA4,SA5,SA6,SA7,TO_CHAR(REG_DTIME,'YYYY-MM-DD HH24:MI:SS') REG_DTIME";
			
			if(!flag)
			{
				
					String sqlQuery	=	"select " + str+" from C_TBK05_ROLL_SPEC";
				       
					cro = this.getDao("KgDao").ExcuteQuery(sqlQuery);
					
					return cro;
					
			}
			else
			{
				if(!zgNum.equals("") && !zgAr.equals(""))
				{
					String sqlQuery	=	"select " + str+" from C_TBK05_ROLL_SPEC where STAND_ID = '"+zgNum+"'and ROLL_AREA= '"+zgAr+"' and (TO_CHAR(REG_DTIME,'YYYYMMDDHH24MISS') between '"+beginTime+"' and '"+endTime+"')";
					
					cro = this.getDao("KgDao").ExcuteQuery(sqlQuery);
					return cro;
				}
				else
				{
				if(!zgNum.equals("")&& zgAr.equals(""))
				{
						String sqlQuery	=	"select " + str+" from C_TBK05_ROLL_SPEC where STAND_ID ='"+ zgNum+"' and (TO_CHAR(REG_DTIME,'YYYYMMDDHH24MISS') between '"+beginTime+"' and '"+endTime+"')";
						
						cro = this.getDao("KgDao").ExcuteQuery(sqlQuery);
						return cro;	
				}
					
				if(zgNum.equals("")&& !zgAr.equals("") )
				{
						String sqlQuery	=	"select " + str+" from C_TBK05_ROLL_SPEC where ROLL_AREA ='" + zgAr+"' and (TO_CHAR(REG_DTIME,'YYYYMMDDHH24MISS') between '"+beginTime+"' and '"+endTime+"')";
						
						cro = this.getDao("KgDao").ExcuteQuery(sqlQuery);
						return cro;	
				}
				if(zgNum.equals("")&& zgAr.equals("") )
				{
						String sqlQuery	=	"select  "+str+"  from C_TBK05_ROLL_SPEC where  (TO_CHAR(REG_DTIME,'YYYYMMDDHH24MISS') between '"+beginTime+"' and '"+endTime+"')";
						
						cro = this.getDao("KgDao").ExcuteQuery(sqlQuery);
						return cro;	
				}
				}
				
			}
			
			return cro;
	}
	                        
	public CoreReturnObject DoQueryXia(String zgNum, String zgAr,Boolean flag,String beginTime,String endTime) throws SQLException
	{
			CoreReturnObject cro = new CoreReturnObject();
			String str ="SPEC_NO,REG_ID,TO_CHAR(REG_DTIME,'YYYY-MM-DD HH24:MI:SS') REG_DTIME,STAND_ID,ROLL_TYPE,ROLL_ID_LO,ROLL_DIAMETER_LO,ROLL_CROWN_LO,ROLL_ROUGHNESS_LO,ROLL_SHAPE_LO,ROLL_PROPERTY_CLASS_LO,OP_CHOCK_NO_LO,DR_CHOCK_NO_LO,XA1,XA2,XA3,XA4,XA5,XA6,XA7";
			
			if(!flag)
			{
				
				String sqlQuery	=	"select " + str+" from C_TBK05_ROLL_SPEC";
			       
				cro = this.getDao("KgDao").ExcuteQuery(sqlQuery );
				return cro;
				
			}
			
			else
			{
				if(!zgNum.equals("") && !zgAr.equals(""))
				{
					String sqlQuery	=	"select " + str+" from C_TBK05_ROLL_SPEC where STAND_ID = '"+zgNum+"' and ROLL_AREA= '"+zgAr+"'and (TO_CHAR(REG_DTIME,'YYYYMMDDHH24MISS') between '"+beginTime+"' and '"+endTime+"')";
					
					cro = this.getDao("KgDao").ExcuteQuery(sqlQuery);
					return cro;
				}
				else
				{
					if(!zgNum.equals("") && zgAr.equals(""))
					{
						String sqlQuery	=	"select " + str+" from C_TBK05_ROLL_SPEC where STAND_ID ='" + zgNum+"'and (TO_CHAR(REG_DTIME,'YYYYMMDDHH24MISS') between '"+beginTime+"' and '"+endTime+"')";
						
						cro = this.getDao("KgDao").ExcuteQuery(sqlQuery);
						return cro;	
					}
					
					if(zgNum.equals("")&& !zgAr.equals(""))
					{
						String sqlQuery	=	"select " + str+" from C_TBK05_ROLL_SPEC where ROLL_AREA ='" + zgAr+"'and (TO_CHAR(REG_DTIME,'YYYYMMDDHH24MISS') between '"+beginTime+"' and '"+endTime+"')";
						
						cro = this.getDao("KgDao").ExcuteQuery(sqlQuery);
						return cro;	
					}
					if(zgNum.equals("")&& zgAr.equals("") )
					{
							String sqlQuery	=	"select  "+str+"  from C_TBK05_ROLL_SPEC where  (TO_CHAR(REG_DTIME,'YYYYMMDDHH24MISS') between '"+beginTime+"' and '"+endTime+"')";
							
							cro = this.getDao("KgDao").ExcuteQuery(sqlQuery);
							return cro;	
					}
				}
			}
			
			return cro;
	}
	   
	public CoreReturnObject PlanAdd(String sand_Id, String roll_Type,String roll_Area,String spec_No,String roll_Id_up, String roll_Id_lo, String reg_Id, String reg_Dtime, String updia, String lodia,String shangtu, String xiatu ,String sshap,String xshap,String scai,String xcai) throws SQLException
	{
		CoreReturnObject cro = new CoreReturnObject();
		
//		String addSql = "insert into C_TBK05_ROLL_SPEC(STAND_ID,ROLL_TYPE,ROLL_AREA,SPEC_NO,ROLL_ID_UP,ROLL_ID_LO,REG_ID,REG_DTIME)values('"+ sand_Id +"','"+roll_Type+"','"+roll_Area+"','"+spec_No+"','"+roll_Id_up+"','"+roll_Id_lo+"','"+reg_Id+"','"+reg_Dtime+"')";
		String addSql = "insert into C_TBK05_ROLL_SPEC(STAND_ID,ROLL_TYPE,ROLL_AREA,SPEC_NO,ROLL_ID_UP,ROLL_ID_LO,REG_ID,REG_DTIME,ROLL_DIAMETER_UP,ROLL_DIAMETER_LO,ROLL_CROWN_UP,ROLL_CROWN_LO,ROLL_SHAPE_UP,ROLL_SHAPE_LO,ROLL_ROUGHNESS_UP,ROLL_PROPERTY_CLASS_LO,MEG_FLAG)values(?,?,?,?,?,?,?,TO_DATE('"+reg_Dtime+"','yyyy-mm-dd hh24:mi:ss'),?,?,?,?,?,?,?,?,'·ٌ')";
		
		cro = this.getDao("KgDao").ExcuteNonQuery(addSql,new Object[]{sand_Id, roll_Type, roll_Area, spec_No, roll_Id_up, roll_Id_lo, reg_Id, updia, lodia,shangtu, xiatu ,sshap,xshap,scai,xcai});
		return cro;
	 
	}
	
	public CoreReturnObject DoUpdate(String reg_Dtime) throws SQLException
	{
			CoreReturnObject cro = new CoreReturnObject();					
/*	String sqlQuery	= "update C_TBK05_ROLL_SPEC set MEG_FLAG = 'تا' where SPEC_NO = '"+spec_no+"' and REG_DTIME ='"+reg_dtime+"'";*/
			String sqlQuery	= "update C_TBK05_ROLL_SPEC set MEG_FLAG = 'تا' where REG_DTIME = TO_DATE('"+reg_Dtime+"','yyyy-mm-dd hh24:mi:ss')";
				       
			cro = this.getDao("KgDao").ExcuteNonQuery(sqlQuery);
				
			return cro;
		
	}

	public CoreReturnObject DoSend(String number,String reg_dtime,String area, String stand_id, String roll_type, String roll_id_up, String roll_id_lo, String up_diameter, String lo_diameter, String lo_crown, String up_crown, String up_shape, String lo_shape, String up_pro, String lo_pro,String uid ) throws SQLException
	{
		
			CoreReturnObject cro = new CoreReturnObject();
			String sql = "insert into TBS02_ROLL_DATA(SEQ_NO,TRANS_DTIME,AREA,STAND_ID,ROLL_TYPE,ROLL_ID_UP,ROLL_ID_LO,ROLL_DIAMETER_UP,ROLL_DIAMETER_LO,ROLL_CROWN_LO,ROLL_CROWN_UP,ROLL_SHAPE_UP,ROLL_SHAPE_LO,ROLL_PROPERTY_CLASS_UP,ROLL_PROPERTY_CLASS_LO,PROC_NAME) values(?,TO_DATE('"+reg_dtime+"','yyyy-mm-dd hh24:mi:ss')"+",?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
			Object[] obj	=	new Object[]{number, area, stand_id, roll_type, roll_id_up, roll_id_lo, up_diameter, lo_diameter, lo_crown, up_crown, up_shape, lo_shape, up_pro, lo_pro, uid };
			cro = this.getDao("KgDao").ExcuteNonQuery(sql , obj);

				return cro;
		
	}
	
	public CoreReturnObject DoSelect(String reg_Dtime) throws SQLException
	{
			CoreReturnObject cro = new CoreReturnObject();
			
				String sqlQuery	= "select SPEC_NO,REG_DTIME,ROLL_AREA,STAND_ID,ROLL_TYPE,ROLL_ID_UP,ROLL_ID_LO,ROLL_DIAMETER_UP,ROLL_DIAMETER_LO,ROLL_CROWN_LO,ROLL_CROWN_UP,ROLL_SHAPE_UP,ROLL_SHAPE_LO,ROLL_PROPERTY_CLASS,ROLL_PROPERTY_CLASS_LO from C_TBK05_ROLL_SPEC where reg_Dtime =TO_DATE('"+reg_Dtime+"','yyyy-mm-dd hh24:mi:ss')";
				       
				cro = this.getDao("KgDao").ExcuteQuery(sqlQuery);
				
				return cro;
			
	}
	public CoreReturnObject DoQueryCoilThick(String coilid) throws SQLException
	{
			CoreReturnObject cro = new CoreReturnObject();
			
				String sqlQuery	= "select COILIDLZ,COILSETTHICK,TO_CHAR(substr(COILTHICK,1,4000)) COILTHICK1,TO_CHAR(substr(COILTHICK,4001)) COILTHICK2,TO_CHAR(COILFLAT) COILFLAT from L2_CALTHKDATA where COILIDLZ LIKE '"+coilid+"%' ";
				  //and (insertdate between '"+beginTime+"' and '"+endTime+"')     
				cro = this.getDao("KgDao").ExcuteQuery(sqlQuery);
				
				return cro;
			
	}
}