protected void btnsubmit_Click(object sender, EventArgs e) { if (txtpassword2.Text == "" || txtpassword1.Text == "") { message.Visible = true; message.Text = "請輸入密碼"; } else { if (txtpassword1.Text == txtpassword2.Text) { logincheckDataContext lc = new logincheckDataContext(); var Accounttable = from row in lc.Account where row.account1.Equals(Session[CDictionary.SESSION_COMPANYACCOUNT].ToString()) select row; foreach (Account cust in Accounttable) { cust.password = txtpassword1.Text; } lc.SubmitChanges(); } else { message.Visible = true; message.Text = "新密碼與確認密碼不相符"; } } Response.Write("<script>alert('更改密碼成功!請使用新密碼再重新登入,謝謝!')</script>"); Response.Write("<script>location.href='../Sign.aspx'</script>"); //Response.Redirect("~/Sign.aspx"); }
private void excuteNonQuery() { logincheckDataContext lc = new logincheckDataContext(); Promotions news_add = new Promotions(); news_add.title = titleInput.Text; news_add.classifyID = classifyID; news_add.startDate = Convert.ToDateTime(startDate.Text); news_add.endDate = Convert.ToDateTime(endDate.Text); news_add.onShelfDate = DateTime.Now.ToUniversalTime().AddHours(8); news_add.picPath = path.ToString(); news_add.content = txtNewsContent.Text; news_add.statusID = 1; news_add.companyID = "C0001"; news_add.comment = null; lc.Promotions.InsertOnSubmit(news_add); lc.SubmitChanges(); }