讓Desktop程式設計人員快速上雲端(範例一)

以框架開發出第一個員工資料管理系統
第一步 : module 命名
module=employee
開啟 employee 資料夾
並建立 index.php



$maintable = 'EMPLOYEE';
$mainkey = 'EMPLOYEE_ID';
$mainkey_value = $employee_id;
$columns = array(EMPLOYEE_ID,EMPLOYEE_NAME,DEPART_ID,DEPART_NAME,EMAIL,MOBILE_PHONE,TEL,MSN,SKYPHONE,ADDRESS,JOB_TITLE,PASS_WD,ORG_ID,ORG_NAME,CHG_DATETIME,CHG_USER,WUID);
$displays = array('員工代號','員工名稱','部門代號','部門名稱','電子信箱','行動電話','電話','MSN','SKYPE','地址','職稱','密碼','組織層級','層級名稱','異動日期','異動人員','WUID');
$action = 'browse';
if (isset($_REQUEST['action'])){
$action = $_REQUEST['action'];
}
if (isset($_REQUEST['ordcol'])){
$ordcol = $_REQUEST['ordcol'];
} else {
$ordcol = $mainkey;
}
if ($action=='confdelete'){
$query1 = new adoquery();
$query1->connection($db);
$query1->sql = "delete from ".$maintable." where $mainkey = '".$mainkey_value."'";
$query1->execute();
}

switch ($action) {
case ($action=='browse' || $action=='confdelete' || $action==''):
$sql = "select * from ".$maintable." ;
$query1 = new adoquery();
$query1->connection($db);
sql = "delete from ".$maintable." where $mainkey = '".$mainkey_value."'";
$query1->execute();
}

switch ($action) {
case ($action=='browse' || $action=='confdelete' || $action==''):
/**begin**/
$sql = "select * from ".$maintable."
$query1 = new adoquery();
$query1->connection($db);
$query1->sql = $sql;
$query1->open();
$total_count = $query1->recordcount();
$query1->sql = "select * from ".$maintable."
$query1->SelectLimit($page_size,$skip);
$rs = $query1->rs();

$grid1 = new dbgrid();
$grid1->datasource($rs);

$grid1->addcolumn[0] = 'EMPLOYEE_ID,編號';
$grid1->addcolumn[1] = 'EMPLOYEE_NAME,名稱';
$grid1->addcolumn[2] = 'DEPART_ID,部門代號';
$grid1->addcolumn[3] = 'DEPART_NAME,部門名稱';

$grid1->mainkey = $mainkey;
$grid1->showsearch='true';
$grid1->show();

$sub_pages=10;
$pageCurrent=$_GET["p"];
if(!$pageCurrent){ $pageCurrent=1;}
$subPages=new SubPages($page_size,$total_count,$pageCurrent,$sub_pages,$_SERVER["PHP_SELF"]."?module=$module&sys=$sys&action=browse$urlwhere&p=",0);
echo '
'. $subPages->subPageCss1();
echo ''. $subPages->subPageCombo();
/**end**/

break;

case 'delete':
include_once('insert.php');
break;

case 'insert':
include_once('insert.php');
break;
case 'edit':
include_once('insert.php');
break;

case 'post':
include_once('insert.php');
break;
default:

}


瀏覽頁完成如圖


接下來新增 insert.php


if ($action=='post'){
//存檔程序處理----
}
//讀取資料
$adoquery1 = new adoquery();
$adoquery1->connection($db);
$adoquery1->sql="select * from $maintable where $mainkey ='".$mainkey_value."'";
$adoquery1->open();
$rs=$adoquery1->rs();
for($i=0; $i < $rs->FieldCount(); $i++) {
$fields = $rs->FetchField($i);
$columns[] = $fields->name;
}

for ($i=0;$ifields[$columns[$i]];
}



" method="post" id="myform" enctype="multipart/form-data">

編輯項目

$input = new input();
$input->label = '員工編號';
$input->name = 'employee_id';
$input->id="employee_id";
$input->value = $employee_id;
$input->size = '10';
if ($action=='edit'){
$input->readonly=true;
}
$input->show();

$input = new input();
$input->label = '員工姓名';
$input->name = 'employee_name';
$input->id="employee_name";
$input->value = $employee_name;
$input->size = '30';
$input->show();
nextline(); //換行

$input = new input();
$input->label = '部門代號';
$input->name = 'depart_id';
$input->id = 'depart_id';
$input->value = $depart_id;
$input->size = '10';
$input->show();

$input = new input();
$input->label = '部門名稱';
$input->name = 'depart_name';
$input->id = 'depart_name';
$input->value = $depart_name;
$input->size = '20';
$input->searchmodule = 'depart';
$input->show();
nextline();

$input = new input();
$input->label = '電子信箱';
$input->name = 'email';
$input->id = 'email';
$input->value = $email;
$input->size = '70';
$input->show();

$input = new input();
$input->label = '行動電話';
$input->name = 'mobile_phone';
$input->id = 'mobile_phone';
$input->value = $mobile_phone;
$input->size = '20';
$input->show();

$input = new input();
$input->label = '聯絡電話';
$input->name = 'tel';
$input->id = 'tel';
$input->value = $tel;
$input->size = '20';
$input->show();

$input = new input();
$input->label = 'MSN';
$input->name = 'msn';
$input->id = 'msn';
$input->value = $msn;
$input->size = '50';
$input->show();

$input = new input();
$input->label = 'SKYPE';
$input->name = 'skyphone';
$input->id = 'skyphone';
$input->value = $skyphone;
$input->size = '50';
$input->show();

$input = new input();
$input->label = '地址';
$input->name = 'address';
$input->id = 'address';
$input->value = $address;
$input->size = '70';
$input->show();

$input = new input();
$input->label = '職稱';
$input->name = 'job_title';
$input->id = 'job_title';
$input->value = $job_title;
$input->size = '50';
$input->show();

$input = new input();
$input->label = '密碼';
$input->name = 'pass_wd';
$input->id = 'pass_wd';
$input->value = $pass_wd;
$input->size = '10';
$input->show();

$combobox1 = new combobox();
$combobox1->label = '組織層級';
$combobox1->id = 'org_id';
$combobox1->name = 'org_id';
$query1 = new adoquery();
$query1->connection($db);
$query1->sql="SELECT ORG_ID, ORG_NAME FROM ORG_ITEM order by ORG_ID "; $query1->open();
$rs1 = $query1->rs();
$iCurr=0;
$i=0;
while (!$rs1->EOF) {
$combobox1->items[] = $rs1->fields['ORG_NAME']."".$rs1->fields['ORG_ID']."]";
$combobox1->values[] = $rs1->fields['ORG_ID'];
if ($rs1->fields['ORG_ID']== $org_id ) {
$iCurr = $i;
}
$i=$i+1;
$rs1->MoveNext();
}
$combobox1->itemindex = $iCurr;
$combobox1->show();
?>



完成輸入畫面


$input->searchmodule = 'depart'; 的部分產生關聯查詢按鈕
效過如下