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
view storyboard in pptx
A. List
1. Data Dictionary
data components(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.
- tbl_build o-< tbl_build_report has 1 to many relationship.
- tbl_build_report >-o Category table refers usage of buildings.
3. Description
…
B. View & Print (1)
1. Data Dictionary
functional components(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
- No need for create/update/delete
- Need only view page and print
- You can use html scaffolding ASP if possible.
3. Description
B. View & Print (2) – General Review Sheet
1. Data Dictionary
functional components(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