protected void gvHoaDon_SelectedIndexChanging(object sender, GridViewSelectEventArgs e) { int mahd = int.Parse(gvHoaDon.DataKeys[e.NewSelectedIndex].Value.ToString()); Session["MaHoaDon"] = mahd; HoaDon hd = new HoaDon(); BUS_HoaDon bus = new BUS_HoaDon(); hd = bus.LayThongTinHD(mahd); txtMaHD.Text = hd.MAHD.ToString(); txtTenKH.Text = hd.HOTEN; txtNgayLapHD.Text = hd.NGAYLAPHD; txtNgayGiaoHang.Text = hd.NGAYGIAOHANG; txtDiaChi.Text = hd.DIACHIGIAOHANG; ddlTrangThai.SelectedValue = hd.TRANGTHAI.ToString(); //load chi tiet hoa don DataTable dt = new DataTable(); BUS_CTHD busCTHD = new BUS_CTHD(); dt = busCTHD.LoadCTHD(mahd); gvCTHD.DataSource = dt.DefaultView; gvCTHD.DataBind(); lblThongBao.Text = ""; }
public void LoadDSSP(bool TrangThai) { BUS_HoaDon bus = new BUS_HoaDon(); DataTable dt = new DataTable(); dt = bus.LoadDSHD(TrangThai); gvHoaDon.DataSource = dt.DefaultView; gvHoaDon.DataBind(); }
protected void gvHoaDon_PageIndexChanging(object sender, GridViewPageEventArgs e) { bool trangthai = bool.Parse(ddlHoaDon.SelectedValue); Session["hdPage"] = e.NewPageIndex; BUS_HoaDon bus = new BUS_HoaDon(); DataTable dt = new DataTable(); dt = bus.LoadDSHD(trangthai); gvHoaDon.DataSource = dt.DefaultView; gvHoaDon.PageIndex = e.NewPageIndex; gvHoaDon.DataBind(); }
public void LoadDoanhThu() { BUS_HoaDon bus = new BUS_HoaDon(); DataTable dt = new DataTable(); dt = bus.TinhDoanhThu(); foreach (DataRow row in dt.Rows) { lblTongMua.Text = row["TongMua"].ToString(); lblTongBan.Text = row["TongBan"].ToString(); lblDoanhThu.Text = row["DoanhThu"].ToString(); } }
protected void btnXacNhan_Click(object sender, EventArgs e) { if (Page.IsValid) { if (DateTime.Now.CompareTo(DateTime.Parse(txtNgayGiao.Text.Trim())) > 0) { lblNgayGiaoHang.Text = "Ngày giao hàng nhỏ hơn ngày hiện tại !"; return; } if (Session["Username"] != null && Session["GioHang"] != null) { string uname = (string)Session["Username"]; BUS_KhachHang busKH = new BUS_KhachHang(); int MaKH = busKH.LayMaKH(uname); string ngaylaphd = DateTime.Now.ToShortDateString(); string ngaygiaohang = txtNgayGiao.Text.Trim(); string dc = txtDCNhan.Text.Trim(); // them hoa don BUS_HoaDon busHD = new BUS_HoaDon(); HoaDon hd = new HoaDon(); hd.MAHD = int.Parse(DateTime.Now.Millisecond.ToString() + DateTime.Now.Second.ToString() + DateTime.Now.Minute.ToString()); hd.NGAYLAPHD = ngaylaphd; hd.NGAYGIAOHANG = ngaygiaohang; hd.MAKH = MaKH; hd.DIACHIGIAOHANG = dc; busHD.ThemHD(hd); //them chi tiet hoa don BUS_CTHD busCTHD = new BUS_CTHD(); ArrayList giohang = (ArrayList)Session["GioHang"]; ArrayList chitietHD = new ArrayList(); foreach (SanPham sp in giohang) { CTHD cthd = new CTHD(); cthd.MAHD = hd.MAHD; cthd.MASP = sp.MaSP; cthd.MASIZE = sp.MASIZE; cthd.SOLUONG = sp.SoLuong; cthd.DONGIA = sp.GiaBan; busCTHD.ThemCTHD(cthd); chitietHD.Add(cthd); } Session["chitietHD"] = chitietHD; Session["GioHang"] = null; Response.Redirect("thanhcong.htm"); } } }
protected void btnCapNhat_Click(object sender, EventArgs e) { if (Session["MaHoaDon"] != null) { BUS_HoaDon bus = new BUS_HoaDon(); int mahd = int.Parse(Session["MaHoaDon"].ToString()); HoaDon hd = new HoaDon(); hd.MAHD = mahd; hd.DIACHIGIAOHANG = txtDiaChi.Text; hd.TRANGTHAI = bool.Parse(ddlTrangThai.SelectedValue); bus.CapNhatHD(hd); if (hd.TRANGTHAI.Equals(true)) { foreach (GridViewRow row in gvCTHD.Rows) { int masp = int.Parse(row.Cells[1].Text); bus.CapNhatSoLuong(masp); } } lblThongBao.Text = ""; bool trangthai = bool.Parse(ddlHoaDon.SelectedValue); int page = int.Parse(Session["hdPage"].ToString()); DataTable dt = new DataTable(); dt = bus.LoadDSHD(trangthai); gvHoaDon.DataSource = dt.DefaultView; gvHoaDon.PageIndex = page; gvHoaDon.DataBind(); Session["MaHoaDon"] = null; } else { lblThongBao.Text = "Chưa chọn hóa đơn cần cập nhật."; } }