private void ShowContactBookMessage()
{
EasyDataProvide ContactBook = new EasyDataProvide("ContactBook");
//如果有資料則撈回學生個別聯絡事項資料
EasyDataProvide StudentContactBook = new EasyDataProvide("StudentContactBook");
StudentContactBook.AddParameter("contactBook_id", Request["contactBook_id"]);
StudentContactBook.AddParameter("people_id", Request["people_id"]);
DataRow rowSbook = StudentContactBook.GetSingleRow("people_id=@people_id and contactBook_id=@contactBook_id");
if(rowSbook==null)
{
return;
}
EasyDataProvide StudentContactBookMessage = new EasyDataProvide("StudentContactBookMessage");
StudentContactBookMessage.AddParameter("student_id", Request["people_id"]);
StudentContactBookMessage.AddParameter("studentContactBook_id", rowSbook["id"].ToString());
StudentContactBookMessage.FillContentPlaceHolderControls("student_id=@student_id and studentContactBook_id=@studentContactBook_id and Role=0");
DataRow row= ContactBook.FillPlaceHolderControlsById(Request["contactBook_id"]);
if(row["activity"].ToString()=="True")
{
InsertButton.Visible = false;
}
ViewState["date"] = row["date"].ToString();
ViewState["contactBook_id"] = rowSbook["id"].ToString();
}
private void Show()
{
//DataRow row = _Customer.FillPlaceHolderControlsById(Request["id"]);
_Customer.AddParameter("id", User.Identity.Name);
DataRow row = _Customer.FillContentPlaceHolderControls("id=@id");
if (row == null)
{
return;
}
hidzip.Value = row["zip"].ToString();
}
private void Show()
{
DataRow rowPublish = _ModulePublish.FillPlaceHolderControlsById(Request["id"]);
if (rowPublish == null)
{
Response.Redirect("index.aspx");
}
this.Title = " " + rowPublish["title"].ToString();
EasyDataProvide ModuleFiles = new EasyDataProvide("ModuleFiles");
ModuleFiles.AddParameter("publishID", Request["id"]);
DataTable dtFile = ModuleFiles.GetData("publishID=@publishID order by listNum Asc");
dlFile.DataSource = dtFile;
dlFile.DataBind();
if (dlFile.Items.Count == 0)
{
h2file.Visible = false;
}
//EasyDataProvide ModulePictures = new EasyDataProvide("ModulePictures");
//ModulePictures.AddParameter("publishID", Request["id"]);
//DataTable dtImages = ModulePictures.GetData("publishID=@publishID order by listNum Asc");
//dlImages.DataSource = dtImages;
//dlImages.DataBind();
//EasyDataProvide ModuleLinks = new EasyDataProvide("ModuleLinks");
//ModuleLinks.AddParameter("publishID", Request["id"]);
//DataTable dtLinks = ModuleLinks.GetData("publishID=@publishID order by listNum Asc");
//repLinks.DataSource = dtLinks;
//repLinks.DataBind();
_ModuleContents.AddParameter("publishID", Request["id"]);
DataRow rowContent = _ModuleContents.FillContentPlaceHolderControls("publishID=@publishID and type is null");
article.Text = rowContent["article"].ToString();
DataTable dtReply = _ModuleContents.GetData("publishID=@publishID and type=1", "order by initDate desc");
repReply.DataSource = dtReply;
repReply.DataBind();
DataLayer dl = new DataLayer();
dl.ModulePublish_UpdateCountsPlus(Request["ID"]);
if (!User.Identity.IsAuthenticated)
{
txtReply.Visible = false;
lblMessage.Visible = true;
btnReply.Visible = false;
btnOpenReply.Visible = false;
}
else
{
string strUserData = ((FormsIdentity)(HttpContext.Current.User.Identity)).Ticket.UserData;
if (strUserData.Length > 20)
{
FormsAuthentication.SignOut();
Response.Redirect(Request.Url.ToString());
}
txtReply.Visible = true;
lblMessage.Visible = false;
btnReply.Visible = true;
btnOpenReply.Visible = true;
}
}
private void show()
{
EasyDataProvide ModuleContents = new EasyDataProvide("ModuleContents");
ModuleContents.AddParameter("publishID", Request["ID"]);
ModuleContents.FillContentPlaceHolderControls("publishID=@publishID");
}
private void ShowContactBookData()
{
DStudent student = new DStudent(Request["people_id"]);
//Step 1:取得ContactBook Data
DataLayer dl = new DataLayer();
//如果txtDate.Text為空，會自動去抓取最新一筆聯絡簿資料
DataRow rowBook = dl.GetTop1ContentBook(txtDate.Text, student.GradeID, "true");
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", Request["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", Request["people_id"]);
StudentContactBookMessage.AddParameter("studentContactBook_id", rowStudentBook["id"].ToString());
StudentContactBookMessage.FillContentPlaceHolderControls("student_id=@student_id and studentContactBook_id=@studentContactBook_id and Role=0");
ViewState["date"] = rowBook["date"].ToString();
ViewState["studentContactBook_id"] = rowStudentBook["id"].ToString();
}