2. Construction Permission Technical Consultation(건축허가 기술협의)

!! Important: I recommend that you implement “Construction Permission Whole List” first.

@. ASP

refer ASP: http://www.sappdi.or.kr/manager/performance/06_1.asp?menu_code=tbl_build

0. Storyboard

A. List

1. Data Dictionary

(a)line-no
(b)m-indate
(c)companuy: tbl_build.pcompname: 소속
(d)m-name
(e)m-inquiry
(f)m-answer
(g)building-name: tbl_build.temp3: 건축명
(h)m-file

(a)total-record-cnt
(b)curr-page-no
(c)area-select
(d)start-date
(e)end-date
(f)search-button
(g)clear-search-field
(h)search-word-Input
(i)pagination
(j)line-page

• show view page when click on all point but in specific field of recored lines.

2. Introduction

Construction Permission Technical Consultation sheet has same format of Civil Complaint Consultation sheet. Hence follow naming convention of table minwon.

This is partial items by usage.

1. tbl_build o-< tbl_build_report has 1 to many relationship.
2. tbl_build_report >-o Category table refers usage of buildings.

3. Description

…

B. View & Print (1)

1. Data Dictionary

(a)no need(update)
(b)general-review-sheet: Go to View & Print (2)
(a)list (목록) : go back to list
(b)no need(update)
(c)no-need(delete)
(d)print (출력)

(a)line-no
(b)m-indate
(c)building-name: tbl_build.temp3: 건축명
(d)location: tbl_build.paddr: 위치
(e)partial-gross-area: tbl_build_report.twidth : 당해연면적
(f)usage: Category.name<->tbl_build_report.bused3 : 용도
(g)floor-count
(h)basement: tbl_build_report.floor1: 지하
(i)ground: tbl_build_report.floor2: 지상

2. Introduction

 This is same in all of transaction recode list page

1. No need for create/update/delete
2. Need only view page and print
3. You can use html scaffolding ASP if possible.

3. Description

B. View & Print (2) – General Review Sheet

1. Data Dictionary

(a)add all numbers
(b)concatenate all usage names

(a)today’s yyyy.mm.dd
(b)reg-no: tbl_build_report.dnum : 등록번호
(c)district: tbl_build_report.partname : 지역
(d)m-indate
(e)title
(f)building-name: first(tbl_build_report.bname): 건축명
(g)site location: first(tbl_build_report.addr1): 대지위치
(h)site area: first(tbl_build_report.awidth): 대지면적
(i)zone-area: first(tbl_build_report.jigu): 지역지구
(j)construction-area:first(tbl_build_report.bwidth): 건축면적
(k)floor-count  basement: tbl_build_report.floor1:   지하
     ground: tbl_build_report.floor2: 지상
(l) gross-area : sum(tbl_build_report.bwidth)
(m)usage : concatenate(Category.name) : 용도
(n) structure : first(tbl_build_report.gujo) : 구조
(o) construction category : tbl_build_report.bkind1 : 공사종명
(p) filler : 편의시설 설치 계획 및 검토 보고서

!!! Important : If value of multiple tbl_build_report records are different, throw away empty value and take existing value.
(s)(@)tbl_build_report.temp@ : @-> 1 ~ 19 : Put O if value is 1, Otherwise Empty, zero means empty
(t)(@)tbl_build_report.temp@ : @-> 1~ 19 : Put O if value is 2, Otherwise Empty, zero means empty
(u)(@)tbl_build_report.sul_temp@ : @-> 1 ~ 19
(v)(@)tbl_build_report.bigo_temp@ : @-> 1~ 19