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

A. List

1. Data Dictionary

(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.

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 – General Review Sheet

1. Data Dictionary

(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

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