private void show()
{
EasyDataProvide OutputDate = new EasyDataProvide("OutputDate");
DataRow row = OutputDate.FillPlaceHolderControlsById(Request["ID"]);
coco.Text = Convert.ToDecimal(row["coco"].ToString()).ToString("0");
}
private void Show()
{
TIN.EasyDataProvide OutputDate = new EasyDataProvide("OutputDate");
DataRow row = OutputDate.FillPlaceHolderControlsById(Request["id"]);
coco.Text = Convert.ToInt16(row["coco"]).ToString("C0");
}
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"]);
if (row == null)
{
return;
}
hidzip.Value = row["zip"].ToString();
}
private void show()
{
EasyDataProvide InputData = new EasyDataProvide("InputData");
DataRow row = InputData.FillPlaceHolderControlsById(Request["ID"]);
if (row == null)
{
return;
}
lblaliasName.Text = row["aliasName"].ToString();
coco.Text = Convert.ToDouble(row["coco"]).ToString("0");
}
private void show()
{
string RoleID = Request["ID"].ToString();
EasyDataProvide Role = new EasyDataProvide("Role");
DataRow row = Role.FillPlaceHolderControlsById(RoleID);
PermissionUserControl2.permissionString = row["permission"].ToString();
if (RoleID == "1")
{
roleName.ReadOnly = true;
//btnUpdate.Visible = false;
}
}
private void show()
{
EasyDataProvide ModulePublish = new EasyDataProvide("ModulePublish");
DataRow row = ModulePublish.FillPlaceHolderControlsById(Request["ID"]);
EasyDataProvide ModuleContents = new EasyDataProvide("ModuleContents");
ModuleContents.AddParameter("publishID", Request["ID"]);
DataRow rowArticle = ModuleContents.GetSingleRow("publishID=@publishID");
if (rowArticle != null) article.Text =My.WebForm.TXT2HTML(rowArticle["article"].ToString()) ;
EasyDataProvide ModuleFiles = new EasyDataProvide("ModuleFiles");
ModuleFiles.AddParameter("publishID", Request["ID"].ToString());
DataTable dt = ModuleFiles.GetData("publishID=@publishID", "order by listNum asc");
dlFiles.DataSource = dt;
dlFiles.DataBind();
}
private void show()
{
EasyDataProvide ModulePublish = new EasyDataProvide("ModulePublish");
DataRow row = ModulePublish.FillPlaceHolderControlsById(Request["ID"]);
EasyDataProvide ModuleContents = new EasyDataProvide("ModuleContents");
ModuleContents.AddParameter("publishID", Request["ID"]);
DataRow rowArticle = ModuleContents.GetSingleRow("publishID=@publishID and type is null");
if (rowArticle != null)
{
article.Text = rowArticle["article"].ToString();
ViewState["articleID"] = rowArticle["id"].ToString();
}
}
private void Show()
{
EasyDataProvide people = new EasyDataProvide("People");
DataRow row = people.FillPlaceHolderControlsById(Request["id"]);
if (row == null) return;
myPhoto.ImageUrl = row["myPhoto"].ToString() == "" ? (row["gender"].ToString() == "True" ? "~/images/Male90x85.jpg" : "~/images/FeMale90x85.jpg") : String.Format("{0}/{1}/{2}/M{3}", ConfigurationManager.AppSettings["FileUploadPath"], (new Person()).School_id, row["id"], row["myPhoto"]);
gender.Text = gender.Text.ToScodeGenderName();
DTeacher dTeacher = new DTeacher( Request["id"]);
telephone_id.Text = dTeacher.Phone;
address_id.Text = dTeacher.Address;
rank.Text = dTeacher.Rank;
username.Text = dTeacher.Account;
emailAddress.Text = dTeacher.Email;
schoolName.Text = dTeacher.SchoolName;
enable.Text = enable.Text.ToScodeEnableName();
description.Text = My.WebForm.TXT2HTML(description.Text);
TeacherName.Text = row["name"].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 ModulePublish = new EasyDataProvide("ModulePublish");
DataRow row = ModulePublish.FillPlaceHolderControlsById(Request["ID"]);
ViewState["GUID"] = Request["ID"];
ddlClass1.SelectedValue = row["classID"].ToString();
ddlOrg.SelectedValue = row["OrgID"].ToString();
if (endDate.Text == "2800/1/1")
{
endDate.Text = "";
}
if (string.IsNullOrEmpty(row["picUrl"].ToString()))
{
picUrlLink.Visible = false;
}
else
{
picUrlLink.NavigateUrl = row["picUrl"].ToString().IndexOf("http") == -1 ? "~/UploadFiles/Images/" + row["picUrl"].ToString() : row["picUrl"].ToString();
}
if (string.IsNullOrEmpty(row["fileUrl"].ToString()))
{
fileUrlLink.Visible = false;
}
else
{
fileUrlLink.NavigateUrl = row["fileUrl"].ToString().IndexOf("http") == -1
? "~/UploadFiles/Files/" + row["fileUrl"].ToString()
: row["fileUrl"].ToString();
}
EasyDataProvide ModuleContents = new EasyDataProvide("ModuleContents");
ModuleContents.AddParameter("publishID", Request["ID"]);
DataRow rowArticle = ModuleContents.GetSingleRow("publishID=@publishID and type is null");
if (rowArticle != null)
{
article.Text = rowArticle["article"].ToString();
ViewState["articleID"] = rowArticle["id"].ToString();
}
//if (!DataLayer.IsInRole("admins", User.Identity.Name))
//{
// if (row["beSelect"].ToString() != "0") //不是自己發佈的
// {
// OrgControl.checkBoxList.Enabled = false;
// InsertButton.Visible = false;
// }
// else
// {
// string[] strUserData = ((FormsIdentity)(User.Identity)).Ticket.UserData.Split(new Char[] { ';' });
// for (int i = OrgControl.checkBoxList.Items.Count - 1; i >= 0; i--)
// {
// ListItem item = OrgControl.checkBoxList.Items[i];
// if (item.Value.IndexOf(strUserData[5]) == -1)
// {
// OrgControl.checkBoxList.Items.Remove(item);
// }
// }
// }
//}
}
private void show()
{
DataRow row = _Member.FillPlaceHolderControlsById(Request["ID"]);
PermissionUserControl1.permissionString = row["permission"].ToString();
}
private void Show()
{
_EmailTemplats.FillPlaceHolderControlsById(Request["id"]);
}
private void show()
{
EasyDataProvide ModulePublish = new EasyDataProvide("ModulePublish");
DataRow row = ModulePublish.FillPlaceHolderControlsById(Request["ID"]);
ddlClass1.SelectedValue = row["classID"].ToString();
//ddlOrg.SelectedValue = row["OrgID"].ToString();
if (endDate.Text == "2800/1/1")
{
endDate.Text = "";
}
picUrlLink.NavigateUrl = "~/UploadFiles/Images/" + row["picUrl"].ToString();
fileUrlLink.NavigateUrl = "~/UploadFiles/Files/" + row["fileUrl"].ToString();
EasyDataProvide ModuleContents = new EasyDataProvide("ModuleContents");
ModuleContents.AddParameter("publishID", Request["ID"]);
DataRow rowArticle = ModuleContents.GetSingleRow("publishID=@publishID");
if (rowArticle != null) article.Text = rowArticle["article"].ToString();
//if (!DataLayer.IsInRole("admins", User.Identity.Name))
//{
// if (row["beSelect"].ToString() != "0") //不是自己發佈的
// {
// OrgControl.checkBoxList.Enabled = false;
// InsertButton.Visible = false;
// }
// else
// {
// string[] strUserData = ((FormsIdentity)(User.Identity)).Ticket.UserData.Split(new Char[] { ';' });
// for (int i = OrgControl.checkBoxList.Items.Count - 1; i >= 0; i--)
// {
// ListItem item = OrgControl.checkBoxList.Items[i];
// if (item.Value.IndexOf(strUserData[5]) == -1)
// {
// OrgControl.checkBoxList.Items.Remove(item);
// }
// }
// }
//}
}