protected void InsertButton_Click(object sender, EventArgs e)
{
EasyDataProvide ContactBook = new EasyDataProvide("ContactBook");
ContactBook.AddParameter("date", date.Text);
ContactBook.AddParameter("grade_id", grade_id.SelectedValue);
int i = ContactBook.GetRowCount("date=@date and grade_id=@grade_id");
if (i > 0)
{
My.WebForm.doJavaScript("alert('該日該班級以建立聯絡簿，請重新選擇！');");
return;
}
ContactBook.AddParameter("description", description.Text);
string ContactBook_id= ContactBook.InsertReturnValue();
EasyDataProvide GradeStudent = new EasyDataProvide("GradeStudent");
GradeStudent.AddParameter("grade_id",grade_id.SelectedValue);
DataTable dtStudent = GradeStudent.GetData("grade_id=@grade_id");
EasyDataProvide StudentContactBook = new EasyDataProvide("StudentContactBook");
foreach (DataRow row in dtStudent.Rows)
{
StudentContactBook.AddParameter("people_id", row["student_id"].ToString());
StudentContactBook.AddParameter("contactBook_id", ContactBook_id);
StudentContactBook.Insert();
}
My.WebForm.doJavaScript("alert('新增成功');location.href='ContactBook_detail.aspx'");
}
protected void Button1_Click(object sender, EventArgs e)
{
DataLayer dataLayer = new DataLayer();
DataRow row = dataLayer.Login(User.Identity.Name, Password.Text);
if (row == null)
{
My.WebForm.doJavaScript("alert('密碼錯誤')");
return;
}
Person person = new Person();
EasyDataProvide StudentContactBookMessage = new EasyDataProvide("StudentContactBookMessage");
StudentContactBookMessage.AddParameter("studentContactBook_id", ViewState["studentContactBook_id"].ToString());
//先刪除
StudentContactBookMessage.AddParameter("studentContactBook_id", ViewState["studentContactBook_id"].ToString());
StudentContactBookMessage.Delete("studentContactBook_id=@studentContactBook_id and Role=2");
//後新增
StudentContactBookMessage.AddParameter("student_id", Request["people_id"]);
StudentContactBookMessage.AddParameter("people_id", person.people_id);
StudentContactBookMessage.AddParameter("Role", "2");
StudentContactBookMessage.AddParameter("article", txtArticle.Text);
StudentContactBookMessage.AddParameter("contactBookDate", ViewState["date"].ToString());
StudentContactBookMessage.Insert();
EasyDataProvide StudentContactBook = new EasyDataProvide("StudentContactBook");
StudentContactBook.AddParameter("isSign", "true");
StudentContactBook.UpdateById(ViewState["studentContactBook_id"].ToString());
My.WebForm.doJavaScript(String.Format("alert('新增成功');location.href='ContactBook_ForParent.aspx?people_id={0}'", Request["people_id"]));
}
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();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
//驗證身份
Person myPerson = new Person();
if (myPerson.Role == Person.LoginRole.Teacher || myPerson.Role == Person.LoginRole.Student || myPerson.Role == Person.LoginRole.Parent)
{
Response.Redirect("~/Default.aspx");
}
if (myPerson.Role == Person.LoginRole.SchoolAdmin)
{
PublishTab1.isOpenEditTab = true;
//addPan.Visible = true;
gvList.Columns[gvList.Columns.Count - 1].Visible = true;
EasyDataProvide Grade = new EasyDataProvide("Grade");
DataRow row = Grade.GetById(Request["id"]);
if (row == null) return;
ViewState["currentYear"] = row["currentYear"].ToString();
ShowTeacher();
ShowCourseSubject();
}
Show();
}
}
public static string[] GetClassValue(int classId)
{
EasyDataProvide ModuleClass = new EasyDataProvide("ModuleClass");
DataTable dtClass = ModuleClass.GetAllData();
string[] classValues = new string[3];
DataView dv3 = new DataView(dtClass);
dv3.RowFilter = "id=" + classId;
if (dv3.Count > 0)
{
classValues[2] = dv3[0]["id"].ToString();
DataView dv2 = new DataView(dtClass);
dv2.RowFilter = "id=" + dv3[0]["parentID"].ToString();
if (dv2.Count > 0)
{
classValues[1] = dv2[0]["id"].ToString();
DataView dv1 = new DataView(dtClass);
dv1.RowFilter = "id=" + dv2[0]["parentID"].ToString();
if (dv1.Count > 0)
{
classValues[0] = dv1[0]["id"].ToString();
}
}
}
return classValues;
}
private void Show()
{
EasyDataProvide ParentChildren = new EasyDataProvide("ParentChildren");
ParentChildren.AddParameter("student_id",Request["id"]);
DataRow pcRow = ParentChildren.GetSingleRow("student_id=@student_id");
if(pcRow==null)
{
Panel2.Visible = true;
Panel1.Visible = false;
return;
}else
{
Panel1.Visible = true;
Panel2.Visible = false;
}
DataRow row = _people.FillPlaceHolderControlsById(pcRow["parent_id"].ToString());
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 = SCode.ToScodeGenderName(gender.Text);
DParent dParent = new DParent(pcRow["parent_id"].ToString());
telephone_id.Text = dParent.Phone;
address_id.Text = dParent.Address;
occupation.Text = dParent.Occupation;
username.Text = dParent.Account;
emailAddress.Text = dParent.Email;
schoolName.Text = dParent.SchoolName;
enable.Text = enable.Text.ToScodeEnableName();
description.Text = My.WebForm.TXT2HTML(description.Text);
EasyDataProvide people = new EasyDataProvide("People");
DataRow peoplwRow = people.GetById(Request["id"]);
StudentName.Text = peoplwRow["name"].ToString();
}
/// <summary>
/// 取得老師授課所有班級列表
/// </summary>
/// <returns>老師授課所有班級列表</returns>
public DataTable GetGradeList()
{
EasyDataProvide V_Teacher_Grade = new EasyDataProvide("V_Teacher_Grade");
V_Teacher_Grade.AddParameter("teacher_id", _pepoleID.ToString());
DataTable dt = V_Teacher_Grade.GetData("teacher_id=@teacher_id");
return dt;
}
/// <summary>
/// 班級年級、名稱、ID、座號
/// </summary>
public DStudent(string peopleId)
: base(peopleId)
{
EasyDataProvide gradeStudent = new EasyDataProvide("GradeStudent");
gradeStudent.AddParameter("student_id", peopleId);
DataRow gradeStudentRow = gradeStudent.GetSingleRow("student_id=@student_id");
if (gradeStudentRow != null)
{
_gradeID = gradeStudentRow["grade_id"].ToString();
EasyDataProvide Grade = new EasyDataProvide("Grade");
DataRow gradeRow = Grade.GetById(gradeStudentRow["grade_id"].ToString());
if (gradeRow == null) return;
_currentYear = gradeRow["currentYear"].ToString();
_gradeName = gradeRow["name"].ToString();
}
if (gradeStudentRow != null) _seatNumber = gradeStudentRow["seatNumber"].ToString();
EasyDataProvide student = new EasyDataProvide("Student");
student.AddParameter("id", peopleId);
DataRow studentRow = student.GetSingleRow("id=@id");
if (studentRow != null)
{
_studentNumber = studentRow["studentNumber"].ToString();
}
}
protected void btnADD_Click(object sender, EventArgs e)
{
EasyDataProvide ModulePictures = new EasyDataProvide("ModulePictures");
FileUploadSetup fus = new FileUploadSetup();
fus.name = "picUrl";
fus.fileType = FileUploadSetup.UpfileType.Image;
fus.allowNoFile = false;
ThumbnailImage timg = new ThumbnailImage();
timg.suffix = "s";
timg.maxWidth = 142;
timg.MaxHight = 89;
fus.ThumbnailImages.Add(timg);
ModulePictures.FileUploadSetups.Add(fus);
try
{
ModulePictures.SetPageFormQuest();
}
catch (Exception ex1)
{
lblError.Text = ex1.Message;
return;
}
ModulePictures.AddParameter("publishID", Request["publishID"].ToString());
ModulePictures.Insert();
string Publish = "_News_Pictures.aspx?ModuleID=" + Request["ModuleID"] + "&ID=" + Request["publishID"];
My.WebForm.doJavaScript(String.Format("parent.tb_remove();parent.location='{0}';", Publish));
}
protected void gvList_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
EasyDataProvide GradeTeacher = new EasyDataProvide("GradeTeacher");
string ID = gvList.DataKeys[e.RowIndex].Value.ToString();
GradeTeacher.DeleteById(ID);
Show();
}
protected void gvList_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
string strID = gvList.DataKeys[e.RowIndex].Value.ToString();
EasyDataProvide ModulePublish = new EasyDataProvide("ModulePublish");
ModulePublish.DeleteById(strID);
Show();
}
protected void gvList_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
EasyDataProvide GradeStudent = new EasyDataProvide("GradeStudent");
string ID = gvList.DataKeys[e.RowIndex].Value.ToString();
GradeStudent.Delete(String.Format("student_id='{0}'", ID));
Show();
}
private void Show()
{
EasyDataProvide People = new EasyDataProvide("People");
DataRow row = People.FillPageControlsById(Request["id"]);
if (row == null) return;
gender.Text = gender.Text.ToScodeGenderName();
DStudent dStudent = new DStudent(Request["id"]);
telephone_id.Text = dStudent.Phone;
address_id.Text = dStudent.Address;
username.Value = dStudent.Account;
emailAddress.Text = dStudent.Email;
studentNumber.Text = dStudent.StudentNumber;
seatNumber.Text = dStudent.SeatNumber;
hidPeople_id.Value = Request["id"];
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"]);
Person person = new Person();
if (person.Role == Person.LoginRole.Teacher)
{
plPassword.Visible = true;
}
else
{
plPassword.Visible = false;
}
}
protected void InsertButton_Click(object sender, EventArgs e)
{
//新增地址
EasyDataProvide Address = new EasyDataProvide("Address");
Address.AddParameter("city", Request["city"]);
Address.AddParameter("division", Request["division"]);
Address.AddParameter("zip", Request["zip"]);
Address.AddParameter("address", address.Value);
string addressID = Address.InsertReturnValue();
//新增電話
EasyDataProvide Telepone = new EasyDataProvide("Telephone");
Telepone.AddParameter("areaCode", areaCode.Value);
Telepone.AddParameter("numberCode", numberCode.Value);
string telephoneID = Telepone.InsertReturnValue();
//新增學校
EasyDataProvide school = new EasyDataProvide("School");
school.AddParameter("id",id.Text);
int i = school.GetRowCount("id=@id");
if(i>0)
{
My.WebForm.doJavaScript("alert('學校編號已經重複!')");
return;
}
school.RemoveParameter("id");
school.SetPlaceHolderFormQuest();
school.AddParameter("address_id", addressID);
school.AddParameter("telephone_id", telephoneID);
school.Insert();
My.WebForm.doJavaScript("alert('新增成功');location.href='School_List.aspx'");
}
protected void btnADD_Click(object sender, EventArgs e)
{
EasyDataProvide ModuleFiles = new EasyDataProvide("ModuleFiles");
//宣告檔案上傳設定
FileUploadSetup fus = new FileUploadSetup();
fus.name = "fileUrl";
fus.fileType = FileUploadSetup.UpfileType.File;
fus.allowNoFile = false;
ModuleFiles.FileUploadSetups.Add(fus);
try //捕抓自訂錯誤
{
ModuleFiles.SetPageFormQuest();
}
catch (Exception ex1)
{
lblError.Text = ex1.Message;
return;
}
ModuleFiles.AddParameter("publishID", Request["publishID"].ToString());
//處理上傳檔案
if (ddlFile.SelectedValue == "檔案連結")
{
ModuleFiles.AddParameter("fileUrl", fileUrlPath.Text);
}
ModuleFiles.Insert();
string Publish = "_Discusses_Files.aspx?ModuleID=" + Request["ModuleID"] + "&ID=" + Request["publishID"];
My.WebForm.doJavaScript(String.Format("parent.tb_remove();parent.location='{0}';", Publish));
}
protected void InsertButton_Click(object sender, EventArgs e)
{
string areaID = "";
string telID = "";
//新增或修改電話
_telephone.AddParameter("areaCode", areaCode.Value);
_telephone.AddParameter("numberCode", numberCode.Value);
if (string.IsNullOrEmpty(ViewState["tel"].ToString()))
{
telID = _telephone.InsertReturnValue();
}
else
{
_telephone.UpdateById(ViewState["tel"].ToString());
telID = ViewState["tel"].ToString();
}
//新增或修改地址
_address.AddParameter("city", Request["city"]);
_address.AddParameter("division", Request["division"]);
_address.AddParameter("zip", Request["zip"]);
_address.AddParameter("address", address.Value);
if (string.IsNullOrEmpty(ViewState["address"].ToString()))
{
areaID = _address.InsertReturnValue();
}
else
{
_address.UpdateById(ViewState["address"].ToString());
areaID = ViewState["address"].ToString();
}
//更新Pepole
EasyDataProvide People = new EasyDataProvide("People");
People.SetPlaceHolderFormQuest();
People.AddParameter("address_id", telID);
People.AddParameter("telephone_id", areaID);
People.UpdateById(Request["id"]);
//更新teacher
_teacher.AddParameter("rank", rank.SelectedValue);
_teacher.UpdateById(Request["id"]);
//更新People_School
_people_School.AddParameter("people_id", Request["id"]);
_people_School.AddParameter("school_id", ddlSchool.SelectedValue);
_people_School.Update("people_id=@people_id");
//更新帳號
_account.AddParameter("password", FormsAuthentication.HashPasswordForStoringInConfigFile(password.Text, "MD5"));
_account.AddParameter("emailAddress", emailAddress.Text);
_account.AddParameter("people_id", Request["id"]);
_account.UpdateById(Request["id"]);
My.WebForm.doJavaScript("alert('修改成功');location.href='Teacher_List.aspx'");
}
protected void InsertButton_Click(object sender, EventArgs e)
{
//檢查帳號是否重複
EasyDataProvide Account = new EasyDataProvide("Account");
Account.AddParameter("username", username.Text);
DataRow rowCheck = Account.GetSingleRow("username=@username");
if (rowCheck != null)
{
My.WebForm.doJavaScript("alert('帳號已經存在')");
return;
}
string peopleId = Guid.NewGuid().ToString();
//新增地址
EasyDataProvide Address = new EasyDataProvide("Address");
Address.AddParameter("city", Request["city"]);
Address.AddParameter("division", Request["division"]);
Address.AddParameter("zip", Request["zip"]);
Address.AddParameter("address", address.Value);
string addressID = Address.InsertReturnValue();
//新增電話
EasyDataProvide Telepone = new EasyDataProvide("Telephone");
Telepone.AddParameter("areaCode", areaCode.Value);
Telepone.AddParameter("numberCode", numberCode.Value);
string telephoneID = Telepone.InsertReturnValue();
//新增Pepole
EasyDataProvide People = new EasyDataProvide("People");
People.SetPlaceHolderFormQuest();
People.AddParameter("id", peopleId);
People.AddParameter("address_id", addressID);
People.AddParameter("telephone_id", telephoneID);
People.AddParameter("role", "2");
People.Insert();
//新增Parent
EasyDataProvide Parent = new EasyDataProvide("Parent");
Parent.AddParameter("id", peopleId);
Parent.SetPlaceHolderFormQuest();
Parent.Insert();
//新增People_School
EasyDataProvide People_School = new EasyDataProvide("People_School");
People_School.AddParameter("people_id", peopleId);
People_School.AddParameter("school_id", (new Person()).School_id);
People_School.Insert();
//新增帳號
Account.AddParameter("password", FormsAuthentication.HashPasswordForStoringInConfigFile(password.Text, "MD5"));
Account.AddParameter("emailAddress", emailAddress.Text);
Account.AddParameter("people_id", peopleId);
Account.AddParameter("id", Guid.NewGuid().ToString());
Account.Insert();
My.WebForm.doJavaScript("alert('新增成功');location.href='Parent_List.aspx'");
}
protected void gvList_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
string strID = gvList.DataKeys[e.RowIndex].Value.ToString();
EasyDataProvide InputData = new EasyDataProvide("InputData");
InputData.DeleteById(strID);
Show();
}
protected void UpdateButton_Click1(object sender, EventArgs e)
{
EasyDataProvide OutputDate = new EasyDataProvide("OutputDate");
OutputDate.SetPlaceHolderFormQuest();
OutputDate.UpdateById(Request["ID"]);
Response.Redirect("Output_list.aspx?ModuleID=" + Request["ModuleID"]);
}
/// <summary>
/// 利用班級編號取得該班學生人數
/// </summary>
/// <param name="gradeId">班級編號</param>
/// <returns>班級學生人數</returns>
public string GetGradeCountById(int gradeId)
{
EasyDataProvide GradeStudent = new EasyDataProvide("GradeStudent");
GradeStudent.AddParameter("grade_id", gradeId.ToString());
int count = GradeStudent.GetRowCount("grade_id=@grade_id");
return count.ToString();
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
EasyDataProvide RoleUserMapping = new EasyDataProvide("RoleUserMapping");
string strID = GridView1.DataKeys[e.RowIndex].Value.ToString();
RoleUserMapping.DeleteById(strID);
Show();
}
protected void Button1_Click(object sender, EventArgs e)
{
EasyDataProvide Account = new EasyDataProvide("Account");
Account.AddParameter("password", FormsAuthentication.HashPasswordForStoringInConfigFile(password.Text, "MD5"));
Account.AddParameter("people_id", Request["people_id"]);
Account.Update("people_id=@people_id");
My.WebForm.doJavaScript("alert('修改成功');parent.tb_remove()");
}
protected void gvList_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
EasyDataProvide ParentChildren = new EasyDataProvide("ParentChildren");
string ID = gvList.DataKeys[e.RowIndex].Value.ToString();
ParentChildren.AddParameter("student_id", ID);
ParentChildren.Delete("student_id=@student_id");
Show();
}
private void ShowClass1()
{
EasyDataProvide ModuleClass = new EasyDataProvide("ModuleClass");
DataTable dtClass = ModuleClass.GetData(string.Format("moduleID='{0}'", Request["ModuleID"]));
ddlClass1.DataSource = dtClass;
ddlClass1.DataBind();
}
//private void ShowOrg()
//{
// EasyDataProvide UnitName = new EasyDataProvide("UnitName");
// DataTable dt = UnitName.GetAllData();
// ddlOrg.DataSource = dt;
// ddlOrg.DataBind();
//}
protected void InsertButton_Click(object sender, EventArgs e)
{
Person person = new Person();
EasyDataProvide ModulePublish = new EasyDataProvide("ModulePublish");
ModulePublish.SetPlaceHolderFormQuest();
//處理上傳檔案
if (ddlFile.SelectedValue == "檔案上傳" && fuFile.HasFile)
{
//取得副檔名
string Extension = fuFile.FileName.Split('.')[fuFile.FileName.Split('.').Length - 1];
//新檔案名稱
string fileName = String.Format("{0:yyyyMMddhhmmsss}.{1}", DateTime.Now, Extension);
fuFile.SaveAs(Server.MapPath(String.Format("~/UploadFiles/Files/{0}", fileName)));
ModulePublish.AddParameter("fileUrl", fileName);
}
//處理上傳圖片
if (fuPic.HasFile)
{
if (fuPic.PostedFile.ContentType.IndexOf("image") == -1)
{
My.WebForm.doJavaScript("alert('檔案型態錯誤!');");
return;
}
//取得副檔名
string Extension = fuPic.FileName.Split('.')[fuPic.FileName.Split('.').Length - 1];
//新檔案名稱
string fileName = String.Format("{0:yyyyMMddhhmmsss}.{1}", DateTime.Now, Extension);
fuPic.SaveAs(Server.MapPath(String.Format("~/UploadFiles/Images/{0}", fileName)));
My.WebForm.GenerateThumbnailImage(fileName, fuPic.PostedFile.InputStream, Server.MapPath("~/UploadFiles/Images"), "S", 69, 50);
ModulePublish.AddParameter("picUrl", fileName);
}
ModulePublish.AddParameter("classID", ddlClass1.SelectedValue);
//ModulePublish.AddParameter("OrgID", ddlOrg.SelectedValue);
//ModulePublish.AddParameter("OrgNames", ddlOrg.SelectedItem.Text);
//ModulePublish.AddParameter("updater", person.name);
//ModulePublish.AddParameter("updaterUnit", person.organization);
//ModulePublish.AddParameter("lastupdated", DateTime.Now.ToString());
//不填結束日期時，設定一個800年後的日期
if (string.IsNullOrEmpty(endDate.Text))
{
ModulePublish.AddParameter("endDate", "2800/1/1");
}
ModulePublish.UpdateById(Request["ID"]);
EasyDataProvide ModuleContents = new EasyDataProvide("ModuleContents");
ModuleContents.AddParameter("publishID", Request["ID"]);
ModuleContents.AddParameter("article", article.Text);
ModuleContents.Update("publishID=@publishID");
Response.Redirect(String.Format("Discusses_List.aspx?ModuleID={0}&page={1}&grade_id={2}", Request["ModuleID"], Request["page"], Request["grade_id"]));
}
protected void InsertButton_Click(object sender, EventArgs e)
{
EasyDataProvide courseSubject = new EasyDataProvide("CourseSubject");
courseSubject.SetPlaceHolderFormQuest();
courseSubject.AddParameter("school_id",(new Person()).School_id);
courseSubject.Insert();
My.WebForm.doJavaScript("alert('新增成功');location.href='CourseSubject_List.aspx'");
}
protected void btnADD_Click(object sender, EventArgs e)
{
EasyDataProvide ModuleLinks = new EasyDataProvide("ModuleLinks");
ModuleLinks.SetPageFormQuest();
ModuleLinks.AddParameter("publishID", Request["publishID"].ToString());
ModuleLinks.Insert();
string Publish = "_News_Links.aspx?ModuleID=" + Request["ModuleID"] + "&ID=" + Request["publishID"];
My.WebForm.doJavaScript(String.Format("parent.tb_remove();parent.location='{0}';", Publish));
}
private void ShowTemplateMessage()
{
Person person = new Person();
EasyDataProvide TemplateMessage = new EasyDataProvide("TemplateMessage");
TemplateMessage.AddParameter("people_id", person.people_id);
DataTable dt = TemplateMessage.GetData("people_id=@people_id");
Repeater1.DataSource = dt;
Repeater1.DataBind();
}
protected void btnSend_Click(object sender, EventArgs e)
{
EasyDataProvide ContactBook = new EasyDataProvide("ContactBook");
ContactBook.AddParameter("activity", "true");
ContactBook.UpdateById(ViewState["id"].ToString());
ShowContact();
ShowStudents();
My.WebForm.doJavaScript("alert('聯絡簿已經送出！');");
}
protected void Button1_Click(object sender, EventArgs e)
{
Person person = new Person();
EasyDataProvide TemplateMessage = new EasyDataProvide("TemplateMessage");
TemplateMessage.AddParameter("messages", messages.Text);
TemplateMessage.AddParameter("people_id", person.people_id);
TemplateMessage.Insert();
My.WebForm.doJavaScript("parent.tb_remove();parent.location.reload()");
}
//秀出所有學校名單(下拉式選單)
/*
* private void ShowSchools()
{
EasyDataProvide School = new EasyDataProvide("School");
DataTable dt = School.GetData("disable='False'");
school_id.DataTextField ="name";
school_id.DataValueField = "id";
school_id.DataSource = dt;
school_id.DataBind();
}
* */
protected void InsertButton_Click(object sender, EventArgs e)
{
//新增班級
EasyDataProvide grade = new EasyDataProvide("Grade");
grade.SetPlaceHolderFormQuest();
grade.AddParameter("school_id", (new Person()).School_id);
grade.Insert();
My.WebForm.doJavaScript("alert('新增成功');location.href='Grade_List.aspx'");
}
private void Show()
{
DataTable dt = dl.GetStudentList((new Person()).School_id, "-1", "", "", "-1", "-1", Request["ID"], "", "order by StudentNumber asc", 70, 1);
gvList.DataSource = dt;
gvList.DataBind();
EasyDataProvide People = new EasyDataProvide("People");
DataRow row = People.GetById(Request["id"]);
ParentName.Text = row["name"].ToString();
}
protected void repReply_ItemCommand(object source, RepeaterCommandEventArgs e)
{
if (e.CommandName == "Delete")
{
HiddenField hidID = (HiddenField)e.Item.FindControl("hidID");
EasyDataProvide ModuleContents = new EasyDataProvide("ModuleContents");
ModuleContents.DeleteById(hidID.Value);
}
show();
}
private void show()
{
EasyDataProvide ModuleContents = new EasyDataProvide("ModuleContents");
ModuleContents.AddParameter("publishID", Request["ID"]);
DataTable dt = ModuleContents.GetData("publishID=@publishID and type=1", "order by initDate desc");
repReply.DataSource = dt;
repReply.DataBind();
}
protected void DataList1_DeleteCommand(object source, DataListCommandEventArgs e)
{
string id = DataList1.DataKeys[e.Item.ItemIndex].ToString();
EasyDataProvide TimeTable = new EasyDataProvide("TimeTable");
TimeTable.AddParameter("grade_id", Request["id"]);
TimeTable.AddParameter("sectionIndex_id", id);
TimeTable.Delete("grade_id=@grade_id and sectionIndex_id=@sectionIndex_id");
Show();
}
protected void btnAdd_Click(object sender, EventArgs e)
{
EasyDataProvide ModuleClass = new EasyDataProvide("ModuleClass");
ModuleClass.AddParameter("className", txtAdd.Text);
ModuleClass.AddParameter("moduleID", Request["ModuleID"]);
ModuleClass.Insert();
txtAdd.Text = "";
Show();
}
private void ShowCustomer()
{
TIN.EasyDataProvide Customer = new EasyDataProvide("Customer");
DataTable dt = Customer.GetAllData();
ddlCustomer.DataTextField = "aliasName";
ddlCustomer.DataValueField = "id";
ddlCustomer.DataSource = dt;
ddlCustomer.DataBind();
}
protected void InsertButton_Click(object sender, EventArgs e)
{
EasyDataProvide InputData = new EasyDataProvide("InputData");
InputData.SetPlaceHolderFormQuest();
InputData.AddParameter("customerID", ddlCustomer.SelectedValue);
InputData.AddParameter("aliasName", ddlCustomer.SelectedItem.Text);
InputData.Insert();
Response.Redirect("Input_list.aspx?ModuleID=" + Request["ModuleID"]);
}
protected void btnAdd_Click(object sender, EventArgs e)
{
EasyDataProvide ModuleClass = new EasyDataProvide("ModuleClass");
ModuleClass.AddParameter("className", txtAdd.Text);
ModuleClass.AddParameter("moduleID", Request["ModuleID"]);
ModuleClass.Insert();
txtAdd.Text = "";
Show();
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
EasyDataProvide Role = new EasyDataProvide("Role");
Role.SetPlaceHolderFormQuest();
Role.AddParameter("permission", PermissionUserControl2.permissionString);
Role.Insert();
Response.Redirect("Role_list.aspx?ModuleID=A02");
}
protected void btnADD_Click(object sender, EventArgs e)
{
EasyDataProvide ModuleLinks = new EasyDataProvide("ModuleLinks");
ModuleLinks.SetPageFormQuest();
ModuleLinks.AddParameter("publishID", Request["publishID"].ToString());
ModuleLinks.Insert();
string Publish = "_News_Links.aspx?ModuleID=" + Request["ModuleID"] + "&ID=" + Request["publishID"];
My.WebForm.doJavaScript(String.Format("parent.tb_remove();parent.location='{0}';", Publish));
}
private void ShowOrg()
{
EasyDataProvide UnitName = new EasyDataProvide("UnitName");
DataTable dt = UnitName.GetAllData();
ddlOrg.DataSource = dt;
ddlOrg.DataBind();
ListItem item = new ListItem("全部", "");
ddlOrg.Items.Insert(0, item);
}
protected void btnSure_Click(object sender, EventArgs e)
{
EasyDataProvide Member = new EasyDataProvide("Member");
string password = FormsAuthentication.HashPasswordForStoringInConfigFile(txtPassword.Text, "MD5");
string[] strUserData = ((FormsIdentity)(Page.User.Identity)).Ticket.UserData.Split(new Char[] { ';' });
Member.AddParameter("password", password);
Member.AddParameter("account", strUserData[4]);
Member.Update("account=@account");
My.WebForm.doJavaScript("alert('已經修改成功，下次登入請用新密碼登入')");
}
private void ShowClass1()
{
EasyDataProvide ModuleClass = new EasyDataProvide("ModuleClass");
DataTable dtClass = ModuleClass.GetData(string.Format("moduleID='{0}'", Request["ModuleID"]));
ddlClass1.DataSource = dtClass;
ddlClass1.DataBind();
ListItem item = new ListItem("全部", "");
ddlClass1.Items.Insert(0, item);
}
protected void btnADD_Click(object sender, EventArgs e)
{
string RoleID = Request["ID"].ToString();
EasyDataProvide Role = new EasyDataProvide("Role");
Role.SetPlaceHolderFormQuest();
Role.AddParameter("permission", PermissionUserControl2.permissionString);
Role.UpdateById(RoleID);
Response.Redirect("Role_list.aspx?ModuleID=A02");
}
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");
}
protected void InsertButton_Click(object sender, EventArgs e)
{
string strUserData = ((FormsIdentity)(HttpContext.Current.User.Identity)).Ticket.UserData;
EasyDataProvide InputData = new EasyDataProvide("InputData");
InputData.SetPlaceHolderFormQuest();
InputData.AddParameter("customerID", User.Identity.Name);
InputData.AddParameter("aliasName", strUserData);
InputData.Insert();
My.WebForm.doJavaScript("alert('已送出！管理者審核中！');location='index.aspx'");
}
protected void btnReply_Click(object sender, EventArgs e)
{
string strUserData = ((FormsIdentity)(HttpContext.Current.User.Identity)).Ticket.UserData;
EasyDataProvide ModuleContents = new EasyDataProvide("ModuleContents");
ModuleContents.AddParameter("publishID", Request["id"]);
ModuleContents.AddParameter("articleTitle", strUserData);
ModuleContents.AddParameter("article", txtReply.Text);
ModuleContents.AddParameter("type", "1");
ModuleContents.Insert();
Response.Redirect(Request.Url.ToString());
}
protected void BtnAdd2_Click(object sender, EventArgs e)
{
EasyDataProvide RoleUserMapping = new EasyDataProvide("RoleUserMapping");
RoleUserMapping.AddParameter("roleID", Request["RoleID"]);
foreach (GridViewRow row in GridView2.Rows)
{
string strID = GridView2.DataKeys[row.RowIndex].Value.ToString();
RoleUserMapping.AddParameter("userID", strID);
RoleUserMapping.Insert();
}
My.WebForm.doJavaScript(String.Format("parent.tb_remove();parent.location='{0}';", "Role_Mapping.aspx?RoleID=" + Request["RoleID"]));
}
private void ShowCustomer()
{
TIN.EasyDataProvide Customer = new EasyDataProvide("Customer");
DataTable dt = Customer.GetAllData();
ddlCustomer.DataTextField = "aliasName";
ddlCustomer.DataValueField = "id";
ddlCustomer.DataSource = dt;
ddlCustomer.DataBind();
ListItem item = new ListItem("全部", "");
ddlCustomer.Items.Insert(0, item);
}
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 ShowRole()
{
EasyDataProvide role = new EasyDataProvide("Role");
DataTable dtRole = role.GetAllData();
ddlRole.DataTextField = "roleName";
ddlRole.DataValueField = "id";
ddlRole.DataSource = dtRole;
ddlRole.DataBind();
if (ddlRole.Items.Count == 0)
{
trRole.Visible = false;
}
}
protected void btnDelete_Click(object sender, EventArgs e)
{
foreach (GridViewRow row in gvList.Rows)
{
CheckBox CheckBox1 = (CheckBox)row.Cells[0].FindControl("CheckBox1");
if (CheckBox1.Checked)
{
string ID = Convert.ToString(gvList.DataKeys[row.RowIndex].Value);
EasyDataProvide ModulePublish = new EasyDataProvide("ModulePublish");
ModulePublish.DeleteById(ID);
}
}
Show();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
show();
EasyDataProvide ModulePublish = new EasyDataProvide("ModulePublish");
DataRow row = ModulePublish.GetById(Request["ID"].ToString());
//if (!DataLayer.IsInRole("admins", User.Identity.Name))
//{
// if (row["beSelect"].ToString() != "0") //不是自己發佈的
// {
// btnSure.Visible = false;
// }
//}
}
}
private void ShowOrganization()
{
EasyDataProvide UnitName = new EasyDataProvide("UnitName");
DataTable dtUnitName = UnitName.GetAllData("order by listNum");
OrganizationID.DataTextField = "title";
OrganizationID.DataValueField = "id";
OrganizationID.DataSource = dtUnitName;
OrganizationID.DataBind();
ListItem item = new ListItem("未指定", "0");
OrganizationID.Items.Add(item);
if (OrganizationID.Items.Count == 1)
{
trUnit.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 and type is null");
if (rowArticle != null)
{
article.Text = rowArticle["article"].ToString();
ViewState["articleID"] = rowArticle["id"].ToString();
}
}
protected void Button1_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(allName.Text))
{
My.WebForm.doJavaScript("alert('您的姓名尚未填寫!');");
return;
}
if (string.IsNullOrEmpty(emailAddress.Text))
{
My.WebForm.doJavaScript("alert('您的電子郵件尚未填寫!');");
return;
}
if (!My.WebForm.IsValidEmail(emailAddress.Text))
{
My.WebForm.doJavaScript("alert('您的電子郵件格式有誤!');");
return;
}
if (string.IsNullOrEmpty(phoneNumber.Text))
{
My.WebForm.doJavaScript("alert('您的聯絡電話尚未填寫!');");
return;
}
if (string.IsNullOrEmpty(article.Text))
{
My.WebForm.doJavaScript("alert('問題或建議必填!');");
return;
}
if (txtVCode.Text != ViewState["Captcha"].ToString())
{
My.WebForm.doJavaScript("alert('驗證碼輸入錯誤!');");
return;
}
ViewState["GUID"] = Guid.NewGuid().ToString();
EasyDataProvide Contact = new EasyDataProvide("Contact");
Contact.SetPlaceHolderFormQuest();
Contact.AddParameter("id", ViewState["GUID"].ToString());
Contact.AddParameter("questionClass", ddlQuestionClass.SelectedValue);
Contact.Insert();
My.WebForm.doJavaScript("alert('問題已送出，感謝您的意見！');location.href='index.aspx'");
}
protected void Button1_Click(object sender, EventArgs e)
{
TIN.EasyDataProvide Customer = new EasyDataProvide("Customer");
Customer.AddParameter("username", account.Text);
Customer.AddParameter("password", password.Text);
DataRow row = Customer.GetSingleRow("username=@username and password=@password");
if (row == null)
{
My.WebForm.doJavaScript("alert('登入失敗！')");
return;
}
else
{
string UserData = row["aliasName"].ToString();
SetAuthenTicket(UserData, row["id"].ToString());
Response.Redirect("index.aspx");
}
}
protected void SureButton_Click(object sender, EventArgs e)
{
EasyDataProvide Customer = new EasyDataProvide("Customer");
Customer.AddParameter("username", username.Text);
Customer.AddParameter("emailAddress", emailAddress.Text);
DataRow row = Customer.GetSingleRow("username=@username and emailAddress=@emailAddress");
if (row == null)
{
lblMessage.Text = "填入資料與資料庫不符，請恰尋管理者，謝謝";
return;
}
//取得新密碼
string newPassword = GenerateRandomCode();
Customer.RemoveParameter("emailAddress");
Customer.AddParameter("password", newPassword);
Customer.Update("username=@username");
//送到信箱
EasyDataProvide EmailTemplats = new EasyDataProvide("EmailTemplats");
EmailTemplats.AddParameter("number", "ForgetPassword");
DataRow rowEmail = EmailTemplats.GetSingleRow("number=@number");
if (rowEmail != null)
{
string subject = rowEmail["subject"].ToString();
string EmailTemp = rowEmail["article"].ToString();
string mailBody = "";
mailBody = EmailTemp;
mailBody = mailBody.Replace("{account}", username.Text).Replace("{password}", newPassword);
My.WebForm.SystemSendMailCC("*****@*****.**", emailAddress.Text, subject, mailBody);
}
My.WebForm.doJavaScript("alert('密碼已經寄到您註冊的信箱!')");
}
protected void Button1_Click(object sender, EventArgs e)
{
EasyDataProvide Customer = new EasyDataProvide("Customer");
DataTable dtCustomer = Customer.GetData("emailAddress IS NOT NULL AND emailAddress<>''");
string subject = "【雲施團分享】" + title.Text;
string mailBody = article.Text.Replace(@"/UploadFiles/", ConfigurationManager.AppSettings["ServerHost"] + @"/UploadFiles/");
mailBody += "<br />發表人：團長|發表日期：" + DateTime.Now.ToShortDateString();
mailBody += "<br /><br />文章網址：<a href='" + ConfigurationManager.AppSettings["ServerHost"] + "News_Detail.aspx?id=" + ViewState["GUID"].ToString() + "'>" + ConfigurationManager.AppSettings["ServerHost"] + "News_Detail.aspx?id=" + ViewState["GUID"].ToString() + "</a>";
//My.WebForm.SystemSendMailCC("*****@*****.**", "*****@*****.**", subject, mailBody);
foreach (DataRow row in dtCustomer.Rows)
{
My.WebForm.SystemSendMailCC("*****@*****.**", row["emailAddress"].ToString(), subject, mailBody);
}
Response.Redirect(String.Format("News_List.aspx?ModuleID={0}&page={1}", Request["ModuleID"], Request["page"]));
}
