viewcont.html
if(request.log) { redirect("comframe.html?contactid=" + request.id); } dbconnect(); contact = database.cursor("SELECT * FROM contacts WHERE contactid = " + request.id) company = database.cursor("SELECT * FROM companies ORDER BY companyname") //Performs an update on the contact information if the user clicks update. if(request.up) { database.execute("UPDATE contacts SET Firstname='" + request.firstname + "', lastname='" + request.lastname + "', dear='" + request.dear + "', companyname='" + request.companyname + "', address='" + request.address + "', city='" + request.city + "', stateorprovince='" + request.stateorprovince + "', postalcode='" + request.postalcode + "', country='" + request.country + "', title='" + request.title + "', workphone='" + request.workphone + "', workextension='" + request.workextension + "', faxNumber='" + request.faxnumber + "', homePhone='" + request.homephone + "', pager='" + request.pager + "', mobilePhone='" + request.mobilephone + "', emailname='" + request.emailname + "', lastmeetingdate='" + request.lastmeetingdate + "', contacttypeid='" + request.contacttypeid + "', referredby='" + request.referredby + "', notes='" + request.notes + "' WHERE contactid = " + request.id) redirect("contact.html"); } //Performs a delete if the user clicks delete. if(request.del) { database.execute("DELETE FROM contacts WHERE contactid =" + request.id) redirect("contact.html") }
if(client.search1) { write("
") } if(client.search2) { write("
") } write("
") write("
")
客戶資料查詢/維護
//Outputs detailed contact info. if(contact.next()) { write("
中文姓名*
") write("
英文姓名*
") write("
職稱
") write("
外號
") write("
公司名稱
") write("
" + contact.companyname) write("
-------------------") while(company.next()) { write("
" + company.companyname) } write("
") write("
工作地址
") write("
區域號碼
") write("
公司英文名稱
") write("
家中地址
") write("
生日
") write("
工作電話
") write("
工作電話分機
") write("
家中電話
") write("
呼叫器
") write("
行動電話
") write("
傳真號碼
") write("
電子郵件
") write("
介紹人
") write("
客戶類別
") write("
最後聯絡日期
") write("
備註
" + contact.notes + "
") write("
") }
* 表示為必須輸入之欄位