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 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('已經修改成功,下次登入請用新密碼登入')"); }
protected void btnRelation_Click(object sender, EventArgs e) { EasyDataProvide ParentChildren = new EasyDataProvide("ParentChildren"); foreach (GridViewRow row in gvList.Rows) { string ID = gvList.DataKeys[row.RowIndex].Value.ToString(); TextBox txtRelationship = (TextBox)row.FindControl("txtRelationship"); ParentChildren.AddParameter("relationship", txtRelationship.Text); ParentChildren.AddParameter("student_id", ID); ParentChildren.Update("student_id=@student_id"); } Show(); My.WebForm.doJavaScript("alert('儲存成功');"); }
protected void btnSure_Click(object sender, EventArgs e) { EasyDataProvide ModuleContents = new EasyDataProvide("ModuleContents"); ModuleContents.AddParameter("publishID", Request["ID"]); DataRow row = ModuleContents.GetSingleRow("publishID=@publishID"); ModuleContents.SetPlaceHolderFormQuest(); if (row == null) { ModuleContents.Insert(); } else { //DataLayer.setBehaviour("�ʺA�o���t��", "�ק�" + ViewState["title"]); ModuleContents.Update("publishID=@publishID"); } Response.Redirect("_News_Files.aspx?ModuleID=" + Request["ModuleID"] + "&ID=" + Request["ID"]); }
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 btnSure_Click(object sender, EventArgs e) { foreach (GridViewRow row in gvList.Rows) { TextBox txtSeatNumber = (TextBox)row.FindControl("txtSeatNumber"); if (!My.WebForm.IsNumber(txtSeatNumber.Text)) { My.WebForm.doJavaScript("alert('座號請輸入數字')"); return; } } EasyDataProvide GradeStudent = new EasyDataProvide("GradeStudent"); foreach (GridViewRow row in gvList.Rows) { string ID = gvList.DataKeys[row.RowIndex].Value.ToString(); TextBox txtSeatNumber = (TextBox)row.FindControl("txtSeatNumber"); GradeStudent.AddParameter("seatNumber", txtSeatNumber.Text); GradeStudent.Update("student_id='" + ID + "'"); } My.WebForm.doJavaScript("alert('設定成功');location.href='" + Request.Url.ToString() + "'"); }
protected void btnSend_Click(object sender, EventArgs e) { EasyDataProvide Account = new EasyDataProvide("Account"); Account.AddParameter("username",txtAccount.Text); Account.AddParameter("emailAddress", txtEmail.Text); DataRow row = Account.GetSingleRow("username=@username and emailAddress=@emailAddress"); if(row==null) { lblMessage.Text = "填入資料與資料庫不符,請恰尋學校管理者,謝謝"; return; } //取得新密碼 string newPassword = GenerateRandomCode(); Account.RemoveParameter("emailAddress"); Account.AddParameter("password", FormsAuthentication.HashPasswordForStoringInConfigFile(newPassword, "MD5")); Account.Update("username=@username"); //送到信箱 My.WebForm.doJavaScript("alert('密碼已經寄到您註冊的信箱!')"); }
protected void InsertButton_Click(object sender, EventArgs e) { //更新帳號資料 if (!string.IsNullOrEmpty(password.Text)) { _Customer.AddParameter("password", password.Text); } _Customer.AddParameter("name", name.Text); _Customer.AddParameter("gender", gender.SelectedValue); _Customer.AddParameter("emailAddress", emailAddress.Text); _Customer.AddParameter("birthday", birthday.Text); _Customer.AddParameter("areaCode", areaCode.Value); _Customer.AddParameter("numberCode", numberCode.Value); _Customer.AddParameter("cellphone", cellphone.Text); _Customer.AddParameter("city", Request["city"]); _Customer.AddParameter("division", Request["division"]); _Customer.AddParameter("zip", Request["zip"]); _Customer.AddParameter("address", address.Value); _Customer.AddParameter("username", username.Text); _Customer.Update("username=@username"); My.WebForm.doJavaScript("alert('修改成功!');location.href='index.aspx'"); }
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 _people.SetPlaceHolderFormQuest(); _people.AddParameter("address_id", telID); _people.AddParameter("telephone_id", areaID); _people.UpdateById(Request["id"]); //更新Student _student.AddParameter("studentNumber", studentNumber.Text); _student.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"); //更新GradeStudent EasyDataProvide GradeStudent = new EasyDataProvide("GradeStudent"); GradeStudent.AddParameter("student_id", Request["id"]); GradeStudent.AddParameter("grade_id", ddlGrade.SelectedValue); GradeStudent.Update("student_id=@student_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='Student_List.aspx'"); }
//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"])); }
//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) { if (string.IsNullOrEmpty(article.Text)) { My.WebForm.doJavaScript("alert('�Բӻ������i�H�ť�.');"); return; } if (shortDescription.Text.Length >= 500) { My.WebForm.doJavaScript("alert('²�满�����i�H�W�L500�Ӧr.');"); return; } Person person = new Person(); EasyDataProvide ModulePublish = new EasyDataProvide("ModulePublish"); ModulePublish.SetPlaceHolderFormQuest(); //�B�z�W���ɮ� if (ddlFile.SelectedValue == "�ɮפW��" && fuFile.HasFile) { //���o���ɦW string Extension = fuFile.FileName.Split('.')[fuFile.FileName.Split('.').Length - 1]; //�s�ɮצW�� string fileName = String.Format("{0:yyyyMMddhhmmsss}.{1}", DateTime.Now, Extension); fuFile.SaveAs(Server.MapPath(String.Format("~/UploadFiles/Files/{0}", fileName))); ModulePublish.AddParameter("fileUrl", fileName); } //�B�z�W�ǹϤ� if (fuPic.HasFile) { if (fuPic.PostedFile.ContentType.IndexOf("image") == -1) { My.WebForm.doJavaScript("alert('�ɮ��A���~!');"); return; } //���o���ɦW string Extension = fuPic.FileName.Split('.')[fuPic.FileName.Split('.').Length - 1]; //�s�ɮצW�� string fileName = String.Format("{0:yyyyMMddhhmmsss}.{1}", DateTime.Now, Extension); fuPic.SaveAs(Server.MapPath(String.Format("~/UploadFiles/Images/{0}", fileName))); 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()); //�������ɡA�]�w�@��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("News_List.aspx?ModuleID={0}&page={1}", Request["ModuleID"], Request["page"])); }