addcont.html
dbconnect(); company = database.cursor("SELECT * FROM companies ORDER BY companyname") if(request.fillin) { // This cursor retrieves company info to help // fill in some of the contact information if requested. compinfo = database.cursor("SELECT * FROM companies WHERE companyname = '" + request.companyname + "'") } else { if(request.firstname && request.lastname) { // inserts the contact information into the Contacts table. database.execute("INSERT INTO contacts (firstname, lastname, dear, companyname," + " address, city, stateorprovince, postalcode, country, title," + " workphone, workextension, faxnumber, homephone, pager, " + " mobilephone, emailname, lastmeetingdate, contacttypeid," + " referredby, notes) " + " VALUES ('" + request.firstname + "','" + request.lastname + "','" + request.dear + "','" + request.companyname + "','" + request.address + "','" + request.city + "','" + request.stateorprovince + "','" + request.postalcode + "','" + request.country + "','" + request.title + "', '" + request.workphone + "','" + request.workextension + "','" + request.faxnumber + "','" + request.homephone + "','" + request.pager + "','" + request.mobilephone + "','" + request.emailname + "','" + request.lastmeetingdate + "','" + request.contacttypeid + "','" + request.referredby + "','" + request.notes + "')"); redirect("contact.html?newsearch=contact"); } }
新增客戶資料
if(request.fillin) { // This section of code is executed when the 'Use Defaults' // button is clicked. write("
中文姓名*:
") write("
英文姓名*:
") write("
外號:
") write("
職稱:
") if(compinfo.next()) { // company information is outputted here for the company chosen. write("
公司名稱:
") write("
") write("
" + request.companyname) write("
-----------------") while(company.next()) { write("
" + company.companyname) } write("
") write("
聯絡地址:
") write("
區域號碼:
") //write("
家中地址:
") write("
統一編號:
") write("
公司英文名稱:
") write("
工作電話:
") } } else { // This is the form used to add a contact. There is a button // that lets you use company information as default to fill in basic // contact information. When the 'Use Defaults' button is clicked, the // if section of this if/else statement is executed. write("
中文姓名*:
") write("
英文姓名*:
") write("
") write("
外號:
") write("
職稱:
") write("
") write("
公司名稱:
") write("
") while(company.next()) { write("
" + company.companyname) } write("
") write("
工作地址:
") write("
區域號碼:
") write("
家中地址:
") write("
生日:
") write("
公司英文名稱:
") write("
工作電話:
") }
工作電話分機:
家中電話:
行動電話:
傳真電話:
呼叫器:
電子郵件:
客戶類別:
最後聯絡日期:
介紹人:
備註:
* 表示為必須輸入之欄位