protected void btncomplete_Click(object sender, EventArgs e)
        {
            DateTime date          = DateTime.Now;
            string   ngaydich      = DateTime.Parse(date.ToShortDateString()).ToString("dd/MM/yyyy");
            string   maphieu       = lblsophieu.Text;
            string   macongty      = Session["congty"].ToString();
            string   ngonngu       = Session["languege"].ToString();
            string   manguoidung   = Session["user"].ToString();
            string   mucdichdudung = txtMucDich.Text;
            int      Yn            = 4;

            //db.CapNhatPhieuMuaHangDich(maphieu, macongty,txtTieuDe.Text, DateTime.Parse(ngaydich), manguoidung,mucdichdudung, trangthaidich);

            dal.CapNhatPhieuDichTraVe(manguoidung, macongty, maphieu, txtTieuDe.Text.Trim(), txtMucDich.Text.Trim(), date, Yn);
            dalAbcon.CapNhatTrangThaiCuaPhieuCoYKien(maphieu, macongty, Yn, txtNguoiDUyet.Text.Trim());
            Response.Redirect("danhsachphieuchuadichND.aspx");
        }