sin_return_policy

////////////////////////////////////////////////////////////////////////////////
        String query1 = "select matnr,from_date,to_date ";
        query1 += "from SIN_RETURN_POLICY_DETAIL , SIN_RETURN_POLICY ";
        query1 += "where SIN_RETURN_POLICY_DETAIL.idx=SIN_RETURN_POLICY.idx";       
        ParameterList param1 = new ParameterList();
        param1.setQuery(query1);
        ParameterList res1 = mc.execute(ICode.MSSQL_SQL_QUERY,"",param1,sesUserId);
        if(res1 != null)
        {
            Table table1 = res1.getTable("RESULT");
            int tmpCnt = table1.getNumRow();
            tmpData = new String [tmpCnt][3];
            if(table1 != null)
            {
                int cnt = table1.getNumRow();
                for(int tmpi = 0 ; tmpi < cnt ; tmpi++)
                {
                    Row row1 = table1.getRow(tmpi);
                    //tmpData[tmpi][0] = row1.getValue("idx");
                    tmpData[tmpi][0] = row1.getValue("matnr");
                    tmpData[tmpi][1] = row1.getValue("from_date");
                    tmpData[tmpi][2] = row1.getValue("to_date");
                }
            }
        }
////////////////////////////////////////////////////////////////////////////////
//////////////////////////////////////////////// 값이 같은지 비교해서 해당 row의 설정을 변경
                        Calendar cal1 = Calendar.getInstance();          // 현재 날짜를 지정한 포맷에 맞춰 문자열로 긁어온다.
                        Date currentTime = cal1.getTime();
                        SimpleDateFormat formatter = new SimpleDateFormat("yyyyMMdd");
                        String ndate = formatter.format(currentTime);
                        int int_tmpDate = Integer.parseInt(ndate);          // 긁어온 날짜값을 비교를 위해 int 형으로 변환

                        for(int count = 0 ; count < tmpData.length ; count++ )
                        {
                            int int_fromDate = Integer.parseInt(tmpData[count][1]);    // DB에서 긁어온 문자열값을 비교를 위해 int 형으로 변환시킨다.
                            int int_toDate = Integer.parseInt(tmpData[count][2]);       // 위는 이전날짜 , 아래는 마지막 날짜
                            if(vData[i][0].equals(tmpData[count][0]))                    // 조건이 같을 경우에 날짜끼리의 비교 후. 참이면 컬럼의 설정을 변경.
                            {
                                if(int_fromDate <= int_tmpDate && int_tmpDate <= int_toDate)
                                {
                                    out.write("dss.Row = "+(realCnt+1)+"\n");
                                    out.write("dss.Col = 3\n");
                                    out.write("dss.BackColor = &hffccff\n");
                                    out.write("dss.ForeColor = &hff0000\n");
                                    out.write("dss.BlockMode = false\n");
                                }
                             }
                        }
////////////////////////////////////////////////