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"])); }