098

Deleting Codes.


[imageUp resizableImageWithCapInsets:UIEdgeInsetsMake(0, 0, 22, 22)];
            [imageDn resizableImageWithCapInsets:UIEdgeInsetsMake(0, 0, 22, 22)];
            
            [btn setBackgroundImage:imageUp forState:UIControlStateNormal];
            [btn setBackgroundImage:imageDn forState:UIControlStateSelected];
            [btn setBackgroundImage:imageDn forState:UIControlStateHighlighted];
            


          NSUInteger row = [indexPath row];
                  UITableViewCell *cell = [tableView dequeueReusableCellWithIdentifier:CellIdentifier];
        
             Configure the cell...
            
             cell바탕색 지정
            [cell.contentView setBackgroundColor:[GlobalVar pastelCellColor]];
             UIImage *imageUp = [UIImage imageNamed:@"cm_checkup.png"];
             UIImage *imageDn = [UIImage imageNamed:@"cm_checkdn.png"];
             UIButton *btn = [[UIButton alloc] initWithFrame:CGRectMake(6, 2, 38, 40)];
             [btn addTarget:self action:@selector(onClickCheck:) forControlEvents:UIControlEventTouchUpInside];
             [btn setBackgroundImage:imageUp forState:UIControlStateNormal];
             [btn setBackgroundImage:imageDn forState:UIControlStateSelected];
             [btn setTag:0];
             [cell.contentView addSubview:btn];
             [btn release];
             
             UILabel *name = [[UILabel alloc] initWithFrame:CGRectMake(50, 2, 70, 40)];
             name.textAlignment = UITextAlignmentLeft;
             name.backgroundColor = [UIColor clearColor];
             name.font = [UIFont systemFontOfSize:14];
             [name setTag:1];
             [cell.contentView addSubview:name];
             [name release];
             
             UILabel *dept = [[UILabel alloc] initWithFrame:CGRectMake(120, 2, 90, 40)];
             dept.textAlignment = UITextAlignmentLeft;
             dept.backgroundColor = [UIColor clearColor];
             dept.font = [UIFont systemFontOfSize:14];
             dept.textColor = [GlobalVar pastelSilverColor];
             [dept setAdjustsFontSizeToFitWidth:YES];
             [dept setTag:2];
             [cell.contentView addSubview:dept];
             [dept release];
             
             
             UILabel *hp = [[UILabel alloc] initWithFrame:CGRectMake(210, 2, 105, 40)];
             hp.textAlignment = UITextAlignmentLeft;
             hp.backgroundColor = [UIColor clearColor];
             hp.font = [UIFont systemFontOfSize:13];
             [hp setTag:3];
             [cell.contentView addSubview:hp];
             [hp release];




SAP Business Suite(ECC6.0. S/4 HANA..)

Oracle E-Business Suite

Oracle Database

SAP HANA Database

IBM DB2 Database


PRAGMA foreign_keys = off;

BEGIN;

ALTER TABLE "DDTBT_DFCT" RENAME TO "_DDTBT_DFCT_old";

CREATE TABLE "DDTBT_DFCT" (
   "id_mbil" number PRIMARY KEY ASC
 , "mode" varchar(2)
 , "id_dfct" number
 , "cd_site" vharchar(6)
 , "cd_hndl_stat" varchar(20)
 , "cd_rcpt_phs" varchar(20)
 , "yn_re_rcpt" varchar(1)
 , "notm_re_rcpt" varchar(6)
 , "dt_rcpt" varchar(8)
 , "id_rcpt_prsn" varchar(20)
 , "cd_dong" varchar(4)
 , "nohs" varchar(5)
 , "cd_loc_clsf" varchar(20)
 , "yn_hosh_comn" varchar(1)
 , "id_loc" number
 , "id_rgon" number
 , "id_dfct_ctyp" number
 , "id_dfct_type" number
 , "id_dfct_caus" number
 , "id_dfct_cl" number
 , "dfct_cnts" varchar(200)
 , "id_wrk_fmer_pic_atch_file" varchar(50)
 , "id_wrk_aftr_pic_atch_file" varchar(50)
 , "yn_re_clsf_rqst" varchar(1)
 , "id_cplt_prsn" varchar(20)
 , "dt_cplt" varchar(8)
 , "notm_vrf_chk" number
 , "dnt_rgst" varchar(8)
 , "id_rgst" varchar(10)
 , "dnt_chg" varchar(8)
 , "id_chg" varchar(10)
 , "cd_re_rcpt_resn" varchar(20)
 , "nm_re_rcpt_resn" varchar(200)
 , "yn_svr_trsm" varchar(1)
 , "search001" number
 , "search002" number
 , "search003" number
 , "cd_cpny" varchar(10)
 , "seq_nipt" varchar(10)
);

INSERT INTO "DDTBT_DFCT" (
   "id_mbil"
 , "mode"
 , "id_dfct"
 , "cd_site"
 , "cd_hndl_stat"
 , "cd_rcpt_phs"
 , "yn_re_rcpt"
 , "notm_re_rcpt"
 , "dt_rcpt"
 , "id_rcpt_prsn"
 , "cd_dong"
 , "nohs"
 , "cd_loc_clsf"
 , "yn_hosh_comn"
 , "id_loc"
 , "id_rgon"
 , "id_dfct_ctyp"
 , "id_dfct_type"
 , "id_dfct_caus"
 , "id_dfct_cl"
 , "dfct_cnts"
 , "id_wrk_fmer_pic_atch_file"
 , "id_wrk_aftr_pic_atch_file"
 , "yn_re_clsf_rqst"
 , "id_cplt_prsn"
 , "dt_cplt"
 , "notm_vrf_chk"
 , "dnt_rgst"
 , "id_rgst"
 , "dnt_chg"
 , "id_chg"
 , "cd_re_rcpt_resn"
 , "nm_re_rcpt_resn"
 , "yn_svr_trsm"
 , "search001"
 , "search002"
 , "search003"
 , "cd_cpny"
)
SELECT
   "id_mbil"
 , "mode"
 , "id_dfct"
 , "cd_site"
 , "cd_hndl_stat"
 , "cd_rcpt_phs"
 , "yn_re_rcpt"
 , "notm_re_rcpt"
 , "dt_rcpt"
 , "id_rcpt_prsn"
 , "cd_dong"
 , "nohs"
 , "cd_loc_clsf"
 , "yn_hosh_comn"
 , "id_loc"
 , "id_rgon"
 , "id_dfct_ctyp"
 , "id_dfct_type"
 , "id_dfct_caus"
 , "id_dfct_cl"
 , "dfct_cnts"
 , "id_wrk_fmer_pic_atch_file"
 , "id_wrk_aftr_pic_atch_file"
 , "yn_re_clsf_rqst"
 , "id_cplt_prsn"
 , "dt_cplt"
 , "notm_vrf_chk"
 , "dnt_rgst"
 , "id_rgst"
 , "dnt_chg"
 , "id_chg"
 , "cd_re_rcpt_resn"
 , "nm_re_rcpt_resn"
 , "yn_svr_trsm"
 , "search001"
 , "search002"
 , "search003"
 , "cd_cpny"
FROM "_DDTBT_DFCT_old";

DROP TABLE "_DDTBT_DFCT_old";

COMMIT;

PRAGMA foreign_keys = ON;

other link flag
-framework KakaoCommon
-framework KakaoNewtoneSpeech

-force_load $(SRCROOT)/

r;
    [btn setSelected:data.isCheck];
    
    

    if (tableView == mTableViewDong) {
        DDTBT_DONG *data = [mListDong objectAtIndex:indexPath.row];

        SqlUtils *db = [[SqlUtils alloc] init];
        [db selectFlor:mListFlor withDongCd:data.cd_dong isAll:mIsAll];

        [mTableViewFlor reloadData];

        if ([mListFlor count] > 0) {
            [mTableViewFlor selectRowAtIndexPath:[NSIndexPath indexPathForRow:0 inSection:0] animated:NO scrollPosition:UITableViewScrollPositionTop];

            DDTBT_FLOR *data1 = [mListFlor objectAtIndex:0];
            [db selectHosh:mListHosh withDongCd:data1.cd_dong florCd:data1.cd_flor isAll:mIsAll];
            [mTableViewHosh reloadData];

            if ([mListHosh count] > 0) {
                [mTableViewHosh selectRowAtIndexPath:[NSIndexPath indexPathForRow:0 inSection:0] animated:NO scrollPosition:UITableViewScrollPositionTop];
            }
        }

    }
    else if (tableView == mTableViewFlor) {
        DDTBT_FLOR *data = [mListFlor objectAtIndex:indexPath.row];

        SqlUtils *db = [[SqlUtils alloc] init];
        [db selectHosh:mListHosh withDongCd:data.cd_dong florCd:data.cd_flor isAll:mIsAll];

        [mTableViewHosh reloadData];

        if ([mListHosh count] > 0) {
            [mTableViewHosh selectRowAtIndexPath:[NSIndexPath indexPathForRow:0 inSection:0] animated:NO scrollPosition:UITableViewScrollPositionTop];
        }
    }
    else if (tableView == mTableViewHosh) {

    } else { //I am adding the list.
        //        hjhDefectList *data = [mList objectAtIndex:indexPath.row];
        //
        //        DCH_BsQtChkEdtg *v = [[DCH_BsQtChkEdtg alloc] initWithNibName:@"DCH_BsQtChkEdtg" bundle:[NSBundle mainBundle]];
        //        self.title = @"";
        //        v.mMbilId = data.id_mbil;
        //        v.delegate = self;
        //        //[v initializeData];
        //        [self.navigationController pushViewController:v animated:NO];
        //
        //        [tableView deselectRowAtIndexPath:indexPath animated:NO];
        NSLog(@"calling DefectSelector");

        DefectSelector *v = [[DefectSelector alloc] initWithNibName:@"DefectSelector" bundle:[NSBundle mainBundle]];
        self.title = @"";
        v.mDongCd = mDongCd;
        v.mNohs = mNohs;
        v.delegate = self;
        v.mCanYouseeThisSword = mCanYouSeeThisSword;
        GlobalVar.globalVar.globalCanYouSeeThisSword = mCanYouSeeThisSword;
        NSLog(@"calling mutableArray4DefectList %ld", (long)indexPath.row);
        DFCT_LIST *data = [mutableArray4DefectList objectAtIndex:indexPath.row];
        v.mBilID = data.id_mbil; //2020113
        NSLog(@"MBILID = %ld", (long)data.id_mbil);
        [self.navigationController pushViewController:v animated:NO];

        return;
    }

    if (nil == [mTableViewDong indexPathForSelectedRow]) {
        [lblHosh setTitle:@"" forState:UIControlStateNormal];
        return;
    }
    if (nil == [mTableViewFlor indexPathForSelectedRow]) {
        [lblHosh setTitle:@"" forState:UIControlStateNormal];
        return;
    }
    if (nil == [mTableViewHosh indexPathForSelectedRow]) {
        [lblHosh setTitle:@"" forState:UIControlStateNormal];
        return;
    }

    // 선택될때마다.
    // 등호수정보로 추가정보 가져오기.
    DDTBT_DONG *data = [mListDong objectAtIndex:[[mTableViewDong indexPathForSelectedRow] row]];
    DDTBT_FLOR *data1 = [mListFlor objectAtIndex:[[mTableViewFlor indexPathForSelectedRow] row]];
    DDTBT_HOSH *data2 = [mListHosh objectAtIndex:[[mTableViewHosh indexPathForSelectedRow] row]];

    if (NO == [data1.cd_flor isEqualToString:@""]) {
        if (NO == [data2.nohs isEqualToString:@""]) {
            [self setHoshInfo:data.cd_dong dongNm:data.nm_dong nohs:data2.nohs];
        }
        else {
            [self setHoshInfo:data.cd_dong dongNm:data.nm_dong nohs:data1.cd_flor];
        }
    }
    else {
        [self setHoshInfo:data.cd_dong dongNm:data.nm_dong nohs:data2.nohs];
    }

[logging] table ddtbt_dfct has no column named seq_nipt in "insert into ddtbt_dfct(id_mbil,mode,cd_site,cd_hndl_stat,cd_rcpt_phs,yn_re_rcpt,notm_re_rcpt,dt_rcpt,id_rcpt_prsn,cd_dong,nohs,cd_loc_clsf,yn_hosh_comn,id_loc,id_rgon,id_dfct_ctyp,id_dfct_type,id_dfct_caus,id_dfct_cl,dfct_cnts,yn_re_clsf_rqst,dnt_rgst,id_rgst,dnt_chg,id_chg,yn_svr_trsm,id_wrk_fmer_pic_atch_file,id_wrk_aftr_pic_atch_file, cd_cpny, seq_nipt)                  values(3,'I','010956','B','I00','N',0,'20200303','C2000005','0301','2101','H','',12442,42,34,86,8,7,'별매품) Flgkgkgk / 기본) 주방상판/주방벽  _ 임페리얼 그레이','N','20200303','C2000005','20200303','C2000005','N','','', '(null)', '(null)')"

DB 업데이트 메소드 수정요.