protected void xuathd_Click(object sender, EventArgs e) { if (Request.QueryString["mapn"] != null) { int ma = int.Parse(Request.QueryString["mapn"].ToString()); Redirect rd = new Redirect(); rd.ChuyenTrang("inhoadon.aspx?xuatpn=" + ma, "_blank", ""); } }
protected void btnLuu_Click(object sender, EventArgs e) { if (Session["cthd"] != null) { string sql = "select MaKH from KhachHang where SDT='" + Session["sdt"].ToString() + "'"; DataTable dt; dt = kn.GetData(sql); if (dt.Rows.Count > 0) { int makh = int.Parse(dt.Rows[0][0].ToString()); try { kn.Execute("update KhachHang set TenKH=N'" + Session["tenkh"].ToString().Trim() + "' where MaKH=" + makh); themHD_CTHD(dt); string sqlHD = "select Max(MaHD) from R_HoaDon where SDT='" + Session["sdt"].ToString() + "'"; dt = kn.GetData(sqlHD); if (dt.Rows.Count > 0) { gvCTHD.Visible = false; btnHuy.Visible = false; btncapnhat.Visible = false; btnLuu.Visible = false; lbltc.Visible = false; lblthanhtien.Visible = false; txtmakh.Enabled = true; txttenkh.Enabled = true; txttenkh.Text = ""; txtmakh.Text = ""; Redirect rd = new Redirect(); // rd.ChuyenTrang("themhoadon.aspx", "", ""); rd.ChuyenTrang("inhoadon.aspx?xuathd=" + int.Parse(dt.Rows[0][0].ToString()), "_blank", ""); } } catch { Response.Write("<script> alert('Đã xảy ra lỗi. Vui lòng kiểm tra lại.') </script>"); } } else { try { SqlConnection conKH = new SqlConnection(kn.chuoiketnoi); conKH.Open(); SqlCommand cmdKH = new SqlCommand(); cmdKH.Connection = conKH; cmdKH.CommandType = CommandType.StoredProcedure; cmdKH.CommandText = "Proc_ThemKH"; cmdKH.Parameters.Add("@TenKH", SqlDbType.NVarChar, 50).Value = Session["tenkh"].ToString().Trim(); cmdKH.Parameters.Add("@SDT", SqlDbType.VarChar, 10).Value = Session["sdt"].ToString().Trim(); cmdKH.Parameters.Add("@Email", SqlDbType.VarChar, 100).Value = ""; cmdKH.ExecuteNonQuery(); conKH.Close(); dt = kn.GetData(sql); themHD_CTHD(dt); string sqlHD = "select Max(MaHD) from R_HoaDon where SDT='" + Session["sdt"].ToString() + "'"; dt = kn.GetData(sqlHD); if (dt.Rows.Count > 0) { Redirect rd = new Redirect(); // rd.ChuyenTrang("themhoadon.aspx", "", ""); rd.ChuyenTrang("inhoadon.aspx?xuathd=" + int.Parse(dt.Rows[0][0].ToString()), "_blank", ""); } } catch { Response.Write("<script> alert('Đã xảy ra lỗi. Vui lòng kiểm tra lại.') </script>"); } } } else { Response.Redirect("themhoadon.aspx"); } Session["cthd"] = null; }