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();
 }