private void ShowContactBookData()
{
DStudent student = new DStudent((new Person()).people_id);
//Step 1:取得ContactBook Data
DataLayer dl = new DataLayer();
DataRow rowBook = dl.GetTop1ContentBook(txtDate.Text, student.GradeID, "true");
//如果txtDate.Text為空，會自動去抓取最新一筆聯絡簿資料
if (rowBook == null)
{
My.WebForm.doJavaScript("alert('無聯絡簿資料！');");
return;
}
description.Text = My.WebForm.TXT2HTML(rowBook["description"].ToString());
//Step 2:取得StudentContactBook 資料
//根據contactBook_id 與people_id 取得StudentContactBook 資料
EasyDataProvide StudentContactBook = new EasyDataProvide("StudentContactBook");
StudentContactBook.AddParameter("contactBook_id", rowBook["id"].ToString());
StudentContactBook.AddParameter("people_id", (new Person()).people_id);
DataRow rowStudentBook = StudentContactBook.GetSingleRow("contactBook_id=@contactBook_id and people_id=@people_id");
if (rowStudentBook == null)
{
return;
}
//如果聯絡簿資料已經上傳就不可以再編輯
if (rowStudentBook["checkUpload"].ToString() == "1")
{
Panel1.Visible = false;
}
//Step 3:取得StudentContactBookMessage 資料
//如果有資料則撈回學生個別聯絡事項資料
EasyDataProvide StudentContactBookMessage = new EasyDataProvide("StudentContactBookMessage");
StudentContactBookMessage.AddParameter("student_id", (new Person()).people_id);
StudentContactBookMessage.AddParameter("studentContactBook_id", rowStudentBook["id"].ToString());
//DataRow rowMessage = StudentContactBookMessage.FillContentPlaceHolderControls("student_id=@student_id and studentContactBook_id=@studentContactBook_id");
//txtArticle.Text = rowMessage["article"].ToString();
ViewState["date"] = rowBook["date"].ToString();
ViewState["contactBook_id"] = rowStudentBook["id"].ToString();
}