3. Construction Permission Whole List(건축허가 전체목록)
@. ASP
refer ASP: http://www.sappdi.or.kr/manager/performance/06_1_build.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)building-name: tbl_build_report.bname: 건축명
(d)location: tbl_build_report.addr1: 위치
(d)partial-gross-area: tbl_build_report.twidth : 당해연면적
(e)usage: Category.name : 용도
(o) construction category : tbl_build_report.bkind1 : 공사종명
(h)floor-count basement: tbl_build_report.floor1: 지하
ground: tbl_build_report.floor2: 지상
(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 – General Review Sheet
1. Data Dictionary
data components(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 : 편의시설 설치 계획 및 검토 보고서
(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
(a)list (리스트) : go back to list
(b)no need(update)
(c)no-need(delete)
(d)print (출력)
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.