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(); }
protected void InsertButton_Click(object sender, EventArgs e) { EasyDataProvide Member = new EasyDataProvide("Member"); Member.SetPlaceHolderFormQuest(); DataRow dataRow = Member.GetSingleRow("account=@account"); if (dataRow != null) { My.WebForm.doJavaScript("alert('帳號已使用!');"); return; } Member.AddParameter("password", FormsAuthentication.HashPasswordForStoringInConfigFile(password.Text, "MD5")); string premissionString = PermissionUserControl1.permissionString; Member.AddParameter("Permission", premissionString); string userID = Member.InsertReturnValue(); if (ddlRole.Items.Count > 0) { EasyDataProvide RoleUserMapping = new EasyDataProvide("RoleUserMapping"); RoleUserMapping.AddParameter("roleID", ddlRole.SelectedValue); RoleUserMapping.AddParameter("userID", userID); RoleUserMapping.Insert(); } Response.Redirect("Account_list.aspx?ModuleID=" + Request["ModuleID"]); }
/// <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 InsertButton_Click(object sender, EventArgs e) { //檢查帳號是否重複 EasyDataProvide Customer = new EasyDataProvide("Customer"); Customer.AddParameter("username", username.Text); DataRow rowCheck = Customer.GetSingleRow("username=@username"); if (rowCheck != null) { My.WebForm.doJavaScript("alert('帳號已經存在')"); return; } //驗證手機號碼格式 //新增會員 Customer.SetPlaceHolderFormQuest(); Customer.AddParameter("password", password.Text); Customer.AddParameter("city", Request["city"]); Customer.AddParameter("division", Request["division"]); Customer.AddParameter("zip", Request["zip"]); Customer.Insert(); My.WebForm.doJavaScript("alert('加入成功!');location.href='index.aspx'"); }
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 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'"); }
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(); }
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"]); }
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) { 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"); } }
private void ShowContactBookData() { DStudent student = new DStudent((new Person()).people_id); //Step 1:取得ContactBook Data DataLayer dl = new DataLayer(); DataRow rowBook = dl.GetTop1ContentBook(txtDate.Text, student.GradeID, "true"); //如果txtDate.Text為空,會自動去抓取最新一筆聯絡簿資料 if (rowBook == null) { My.WebForm.doJavaScript("alert('無聯絡簿資料!');"); return; } description.Text = My.WebForm.TXT2HTML(rowBook["description"].ToString()); //Step 2:取得StudentContactBook 資料 //根據contactBook_id 與people_id 取得StudentContactBook 資料 EasyDataProvide StudentContactBook = new EasyDataProvide("StudentContactBook"); StudentContactBook.AddParameter("contactBook_id", rowBook["id"].ToString()); StudentContactBook.AddParameter("people_id", (new Person()).people_id); DataRow rowStudentBook = StudentContactBook.GetSingleRow("contactBook_id=@contactBook_id and people_id=@people_id"); if (rowStudentBook == null) { return; } //如果聯絡簿資料已經上傳就不可以再編輯 if (rowStudentBook["checkUpload"].ToString() == "1") { Panel1.Visible = false; } //Step 3:取得StudentContactBookMessage 資料 //如果有資料則撈回學生個別聯絡事項資料 EasyDataProvide StudentContactBookMessage = new EasyDataProvide("StudentContactBookMessage"); StudentContactBookMessage.AddParameter("student_id", (new Person()).people_id); StudentContactBookMessage.AddParameter("studentContactBook_id", rowStudentBook["id"].ToString()); //DataRow rowMessage = StudentContactBookMessage.FillContentPlaceHolderControls("student_id=@student_id and studentContactBook_id=@studentContactBook_id"); //txtArticle.Text = rowMessage["article"].ToString(); ViewState["date"] = rowBook["date"].ToString(); ViewState["contactBook_id"] = rowStudentBook["id"].ToString(); }
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 btnLogin_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) { lblErrer.Visible = true; My.WebForm.doJavaScript("alert('登入失敗!')"); return; } else { string UserData = row["aliasName"].ToString(); SetAuthenTicket(UserData, account.Text); Response.Redirect("member_atmbuy.aspx"); } }
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 Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (User.Identity.IsAuthenticated) { string strUserData = ((FormsIdentity)(HttpContext.Current.User.Identity)).Ticket.UserData; if (strUserData.Length > 20) { FormsAuthentication.SignOut(); Response.Redirect(Request.Url.ToString()); } string username = User.Identity.Name; EasyDataProvide Customer = new EasyDataProvide("Customer"); Customer.AddParameter("username", username); DataRow rowCustomer = Customer.GetSingleRow("username=@username"); if (rowCustomer == null) { FormsAuthentication.SignOut(); Response.Redirect("index.aspx"); } allName.Text = rowCustomer["name"].ToString(); gender.SelectedValue = rowCustomer["gender"].ToString(); emailAddress.Text = rowCustomer["emailAddress"].ToString(); phoneNumber.Text = rowCustomer["areaCode"].ToString() + "-" + rowCustomer["numberCode"].ToString(); } //驗證圖片產生 string captchaImageText = GenerateRandomCode(); this.Session["Captcha"] = captchaImageText; ViewState["Captcha"] = captchaImageText; imgMVcode.Src = "../Ashx/JpegImage.ashx";; } }
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); // } // } // } //} }
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); // } // } // } //} }