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 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 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('密碼已經寄到您註冊的信箱!')");
}