Monthly Report - May 2007

返工 每月報告

Period: 1 May 2007 - 31 May 2007

Task Performed

1. CMS Website Documentation

2. Student Report 成績表 (C#)

3. Hotel Room Rate Web Service (PHP)

---

1. Cap screen 

主要都係point form, step by step, 加screen cap (先貼落小畫家, 然後再攞要嘅部份)

---

2. 轉用老細買的Flex Grid Control

http://www.grid2000.com/
唔記得有咩好, 總之比C#個grid好啲啦

---

 3. nusoap

用open source library. 不過搵唔到點樣做login, 連WSDL都要protect. 而家寫到由URL入username同password (query string), server先會答個WSDL.

---

 ASP.NET 用grid view出Excel

1. 在aspx個markup個<%@ Page入面, 加
EnableEventValidation="false"

2. 之後就加個gridview啦. 然後做好啲column

3. 到戲肉, 寫code
Dim attachment As String = "attachment; filename=stat.xls"
Response.ClearContent()
Response.AddHeader("content-disposition", attachment)
Response.ContentType = "application/ms-excel"
Dim sw As New StringWriter()
Dim htw As New HtmlTextWriter(sw)

gvStat.DataSourceID = Nothing

gvStat.DataSource = dTable
gvStat.DataBind()

gvStat.RenderControl(htw)
Response.Write(sw.ToString)
Response.End()

*dTable係一個DataTable, 之前query左的.

---

 PHP HTML 出 PDF

 搵到PEAR都有個出pdf, 但見好未成熟, documentation又無. 所以搵左FPDF, 跟住發現有人寫左由HTML用FPDF個library, 直出PDF (HTML2PDF), 實在太好了. 最後又到出中文UTF8問題, 好在forum有有心人寫functions做, 雖然UTF8做唔到, 但出到Big5,同GB, 希望收貨啦.

http://www.fpdf.org/phorum/read.php?f=1&i=31006&t=5142#31006

 

---

 

PHP 出 Excel

 PEAR個Spreadsheet_Excel_Writer. 雖然仲beta緊, 但啲document好齊, 又有sample, 又出到utf8. 夠用了.

---

嘆左兩三個星期, 跟住有兩個新project, 一齊, 一個超趕 (兩個星期嘅嘢要一個星期寫完加試完). 都係"盡做啦".