package integrate;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;

public class DBinput {
	public int invCheck(Structure inputFile) {
		// TODO Auto-generated method stub
		System.out.println("Step 3: write into DB");
		try{
			
			//initialize
	
	/*	
			//*******************************************************************************
	        Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
	        Connection conn = DriverManager.getConnection("jdbc:sqlserver://"
	                + "10.3.30.30:1433;User=xxk;;DatabaseName=TH_ASRS");
	        
	        Statement stmt = conn.createStatement();
	        //      *******************************************************************************
	*/
	        int WorkType=10;
	        int Aisle=1;
	    
	        int Srow=2;
	        int Trow=2;
	        int Slayer, Tlayer, SRank, TRank;
	        
	        String PalletID="\'0\'";
	        String Status="\'0\'";
	    
	        for (int i=0; i<=inputFile.unitNum; i++){
	        	
	        	Slayer=inputFile.unitList[i].layer;
	        	SRank=inputFile.unitList[i].rank;
	        	Tlayer=Slayer;
	        	TRank=SRank;
	        	
	        	String s = "insert into T_work (WorkType, Aisle, Slayer, SRank, SRow, TLayer, TRank, TRow, Palletid, status) values (";
	        
		//		edit the operational order        
		        s+=WorkType;
		        s+=",";
		        s+=Aisle;
		        s+=",";
		        s+=Slayer;
		        s+=",";
		        s+=SRank;
		        s+=",";
		        s+=Srow;
		        s+=",";
		        s+=Tlayer;
		        s+=",";
		        s+=TRank;
		        s+=",";
		        s+=Trow;
		        s+=",";
		        s+=PalletID;
		        s+=",";
		        s+=Status;
		        s+=")";
		        
		        
		        System.out.println(s);
		/*        
		    	//*******************************************************************************	        
		        int n = stmt.executeUpdate(s);
		    	//*******************************************************************************
		*/
	        } 
	        return 1;
		}catch(Exception e){
			
			System.out.println(e.toString());
			return -1;
		}
	}
	public int commonCheck(){
		System.out.println("Step 3: write into DB");
		try{
			
			//initialize
	
		/*	
			//*******************************************************************************
	        Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
	        Connection conn = DriverManager.getConnection("jdbc:sqlserver://"
	                + "10.3.30.30:1433;User=xxk;;DatabaseName=TH_ASRS");
	        
	        Statement stmt = conn.createStatement();
	        //      *******************************************************************************
		*/
	        int WorkType=11;
	        int Aisle=1;
	    
	        int Srow=2;
	        int Trow=2;
	        int Slayer, Tlayer, SRank, TRank;
	        
	        Slayer=1;
	        Tlayer=1;
	        SRank=0;
	        TRank=0;
	        
	        String PalletID="\'0\'";
	        String Status="\'0\'";
	    
	       
	        	
	     
	        	String s = "insert into T_work (WorkType, Aisle, Slayer, SRank, SRow, TLayer, TRank, TRow, Palletid, status) values (";
	        
		//		edit the operational order        
		        s+=WorkType;
		        s+=",";
		        s+=Aisle;
		        s+=",";
		        s+=Slayer;
		        s+=",";
		        s+=SRank;
		        s+=",";
		        s+=Srow;
		        s+=",";
		        s+=Tlayer;
		        s+=",";
		        s+=TRank;
		        s+=",";
		        s+=Trow;
		        s+=",";
		        s+=PalletID;
		        s+=",";
		        s+=Status;
		        s+=")";
		        
		        
		        System.out.println(s);
		        
		        /*
		    	//*******************************************************************************	        
		        int n = stmt.executeUpdate(s);
		    	//*******************************************************************************
	*/
	        
	        return 1;
		}catch(Exception e){
			
			System.out.println(e.toString());
			return -1;
		}
	}

}