protected void bt_up_Click(object sender, EventArgs e) { object[] obj4 = new object[6]; obj4[0] = Session["masanpham1"]; obj4[1] = txt_tensp.Text; obj4[2] = Convert.ToInt32(drp_nhomhang.SelectedValue); obj4[3] = Convert.ToInt32(txt_soluong.Text); obj4[4] = txt_chitiet.Text; obj4[5] = Convert.ToDouble(txt_dongia.Text); SupportDb.ExecuteProcdure("capnhatsanpham1", obj4); lbl_thongbao.Text = "Cập nhật thành công !"; txt_tensp.Text = ""; txt_soluong.Text = ""; txt_chitiet.Text = ""; txt_dongia.Text = ""; ful_anhsp.Enabled = true; bt_them.Enabled = true; bt_up.Visible = false; object[] obj011 = new object[1]; obj011[0] = Session["manh01"]; DataSet dsa = new DataSet(); dsa = SupportDb.ReturnDataSet("timsptheomanh", obj011); grv_sp.DataSource = dsa; grv_sp.DataBind(); Panel2.Visible = false; Panel1.Visible = true; }
protected void bt_sua_Click(object sender, EventArgs e) { string mnh = ""; string maloai = ""; string tennhom = ""; foreach (GridViewRow row in grv_nhomhang.Rows) { CheckBox chk = (CheckBox)row.FindControl("chk_Check"); if (chk != null && chk.Checked) { int manhom = Convert.ToInt32(grv_nhomhang.DataKeys[row.RowIndex].Value); Session["manhomh"] = manhom; object[] obj3 = new object[1]; obj3[0] = manhom; DataSet dsnhm = new DataSet(); dsnhm = SupportDb.ReturnDataSet("timnhomhangtheoma", obj3); for (int i = 0; i < dsnhm.Tables[0].Rows.Count; i++) { DataRow dr = dsnhm.Tables[0].Rows[i]; mnh = dr["MANH"].ToString(); maloai = dr["MALOAI"].ToString(); tennhom = dr["TENNH"].ToString(); } } } txt_tennhomhang.Text = tennhom; drp_loaihang.SelectedValue = maloai; bt_capnhat.Visible = true; lbl_thanhcong.Text = ""; Hienthinhomhang(); }
protected void Page_Load(object sender, EventArgs e) { Title = "Tìm kiếm"; Session["TenNSX"] = ""; if (!Page.IsPostBack) { if (Request.QueryString["TenSP"] != null) { string tukhoa = Request.QueryString["TenSP"].ToString(); object[] obj = new object[1]; obj[0] = tukhoa; DataSet ds = new DataSet(); ds = SupportDb.ReturnDataSet("TimTheoTenSP", obj); DataList1.DataSource = ds; DataList1.DataBind(); string str = (string)Session["TenNSX"]; if (str == "") { m.Edit_DataList(DataList1, "TimTheoTenSP N'" + tukhoa + "' "); } else { m.Edit_DataList(DataList1, "HienThiSanPhamTheoNSX" + str + ""); } } } }
protected void Page_Load(object sender, EventArgs e) { Title = "Sản phẩm"; Session["TenNSX"] = ""; if (!IsPostBack) { if (Request.QueryString["TenLoai"] != null) { string loai = Request.QueryString["TenLoai"].ToString(); Global.Currentpage = 0; object[] obj = new object[1]; obj[0] = loai; DataSet ds = new DataSet(); ds = SupportDb.ReturnDataSet("HienThiSanPhamTheoLoai", obj); DataList1.DataSource = ds; DataList1.DataBind(); ViewState["ds"] = ds; //BindList(); // string str = (string)Session["TenNSX"]; if (str == "") { m.Edit_DataList(DataList1, "HienThiSanPhamTheoLoai N'" + loai + "'"); } else { m.Edit_DataList(DataList1, "HienThiSanPhamTheoNSX" + str + ""); } } } }
protected void Page_Load(object sender, EventArgs e) { if (Session["quyen"].ToString() != "1") { Response.Redirect("~/Dangnhap.aspx"); } else { lbl_xinchao.Text = "Xin chào: " + Session["hoten"].ToString(); } if (!IsPostBack) { Hienthisanpham(); } object[] objlh = new object[0]; DataSet dsnh = new DataSet(); dsnh = SupportDb.ReturnDataSet("hienthinhomhang", objlh); if (dsnh.Tables[0].Rows.Count > 0) { SupportDb.BindFromDataSetToCombo(dsnh, drp_nhomhang, "MANH", "TENNH"); } object[] objlh1 = new object[0]; DataSet dsnh1 = new DataSet(); dsnh1 = SupportDb.ReturnDataSet("hienthinhomhang", objlh1); if (dsnh1.Tables[0].Rows.Count > 0) { SupportDb.BindFromDataSetToCombo(dsnh1, drp_manh, "MANH", "TENNH"); } }
protected void Page_Load(object sender, EventArgs e) { Title = "Thêm sản phẩm"; if (!Page.IsPostBack) { //goi thu tuc lay tat ca kenh du lieu object[] obj = new object[0]; DataSet dsloai = new DataSet(); dsloai = SupportDb.ReturnDataSet("HienThiLoai", obj); if (dsloai.Tables[0].Rows.Count > 0) { //goi ham de nap du lieu vao dropdownlist SupportDb.BindFromDataSetToCombo(dsloai, drpLoai, "IDLoai", "TenLoai"); } //goi thu tuc lay tat ca kenh du lieu object[] obj1 = new object[0]; DataSet dsnsx = new DataSet(); dsnsx = SupportDb.ReturnDataSet("HienThiNSX", obj); if (dsnsx.Tables[0].Rows.Count > 0) { //goi ham de nap du lieu vao dropdownlist SupportDb.BindFromDataSetToCombo(dsnsx, drpNSX, "IDNhaSX", "TenNSX"); } } }
protected void btLogin_Click(object sender, EventArgs e) { object[] obj = new object[2]; obj[0] = txtUser.Text; obj[1] = md5.maHoa(txtPass.Text); DataSet dsuser = new DataSet(); dsuser = SupportDb.ReturnDataSet("KiemtraDangNhap", obj); if (dsuser.Tables[0].Rows.Count > 0) { DataRow dr = dsuser.Tables[0].Rows[0]; //dang nhap thanh cong lbl_thongbao.Visible = false; Session["TenDangNhap"] = dr["TenDangNhap"].ToString(); Session["MatKhau"] = dr["MatKhau"].ToString(); Session["Quyen"] = dr["TenQuyen"].ToString(); Session["HoTen"] = dr["HoTen"].ToString(); Session["IDKhachHang"] = dr["IDKhachHang"].ToString(); Session["DiaChi"] = dr["DiaChi"].ToString(); Session["Email"] = dr["Email"].ToString(); Session["SDT"] = dr["SDT"].ToString(); DangNhap.Visible = false; //lbl_tennguoidung.Text = "Chào " + Session["TenNguoiDung"].ToString(); Response.Redirect(Request.ApplicationPath + "/Default.aspx"); } else { lbl_thongbao.Visible = true; lbl_thongbao.Text = "Vui lòng kiểm tra lại tên đăng nhập hoặc mật khẩu!"; } }
protected void bt_capnhat_Click(object sender, EventArgs e) { if (txt_mkmoi.Text.Length >= 6) { try { DataSet dsNd = new DataSet(); object[] obj = new object[2]; obj[0] = Session["taikhoan"].ToString(); obj[1] = md5.hmweb_Encrypt("thuy", txt_mkcu.Text); dsNd = SupportDb.ReturnDataSet("kiemtramatkhau", obj); if (dsNd.Tables[0].Rows.Count > 0) { obj[0] = Session["taikhoan"].ToString(); obj[1] = md5.hmweb_Encrypt("thuy", txt_mkmoi.Text); SupportDb.ExecuteProcdure("capnhatmatkhau", obj); lbl_thanhcong.Text = "Cập nhật Thành công!"; txt_mkcu.Text = ""; txt_mkmoi.Text = ""; txt_ktramkmoi.Text = ""; } } catch { lbl_thanhcong.Text = "Đã xảy ra lỗi trong quá trình đổi mật khẩu!"; } } else { lbl_thanhcong.Text = "Mật khẩu mới của bạn quá ngắn (< 6 kí tự)"; } }
protected void bt_dangky_Click(object sender, EventArgs e) { if (chk_dongy.Checked == true) { if (txt_matkhau.Text.Length >= 6) { try { object[] obj2 = new object[2]; obj2[0] = txt_tendangnhap.Text; obj2[1] = txt_email.Text; DataSet ds = new DataSet(); ds = SupportDb.ReturnDataSet("ktratendangnhapvaemail", obj2); if (ds.Tables[0].Rows.Count > 0) { lbl_thongbao.Text = "Tên tài khoản đã có người đăng kí.Vui lòng nhập vào tên khác !"; } else { if (ds.Tables[1].Rows.Count > 0) { lbl_thongbao.Text = "Email này đã đăng kí. Vui lòng nhập email khác ! "; } else { object[] obj5 = new object[7]; obj5[0] = Convert.ToInt32(drp_quyen.SelectedValue); obj5[1] = txt_tendangnhap.Text; obj5[2] = md5.hmweb_Encrypt("thuy", txt_matkhau.Text); obj5[3] = txt_hoten.Text; obj5[4] = txt_diachi.Text; obj5[5] = txt_dienthoai.Text; obj5[6] = txt_email.Text; SupportDb.ExecuteProcdure("nguoidungdangky", obj5); lbl_thongbao.Text = "Thêm người dùng thành công !"; txt_tendangnhap.Text = ""; txt_matkhau.Text = ""; txt_hoten.Text = ""; txt_diachi.Text = ""; txt_dienthoai.Text = ""; txt_email.Text = ""; } } } catch { lbl_thongbao.Text = "Có lỗi trong quá trình thêm người dùng. Bạn vui lòng kiểm tra lại !"; } } else { lbl_thongbao.Text = "Mật khẩu quá ngắn (< 6 kí tự)"; } } Hienthinguoidung(); Panel1.Visible = true; Panel2.Visible = false; txt_ten.Text = ""; }
protected void bt_s1_Click(object sender, EventArgs e) { bt_capnhat.Enabled = true; string tenkhach = ""; string diachi = ""; string sdt = ""; string email = ""; string ngaydathang = ""; string chuky = ""; string tongtien = ""; string pttt = ""; string ptvc = ""; string tinhtrang = ""; string ghichu = ""; foreach (GridViewRow row in grv_timkiem.Rows) { CheckBox chk = (CheckBox)row.FindControl("chk_Check0"); if (chk != null && chk.Checked) { int madonhang1 = Convert.ToInt32(grv_timkiem.DataKeys[row.RowIndex].Value); Session["madonhang"] = madonhang1; object[] obj33 = new object[1]; obj33[0] = madonhang1; DataSet dsdh = new DataSet(); dsdh = SupportDb.ReturnDataSet("timdonhangtheoma", obj33); for (int i = 0; i < dsdh.Tables[0].Rows.Count; i++) { DataRow dr = dsdh.Tables[0].Rows[i]; tenkhach = dr["HOTEN"].ToString(); diachi = dr["DIACHI"].ToString(); sdt = dr["SDT"].ToString(); email = dr["EMAIL"].ToString(); ngaydathang = dr["NGAYDATHANG"].ToString(); chuky = dr["CHUKY"].ToString(); tongtien = dr["TONGTIEN"].ToString(); pttt = dr["PTTT"].ToString(); ptvc = dr["PTVC"].ToString(); tinhtrang = dr["TINHTRANG"].ToString(); ghichu = dr["GHICHU"].ToString(); } } } txt_tenkhach.Text = tenkhach; txt_diachi.Text = diachi; txt_sdt.Text = sdt; txt_email.Text = email; txt_ngaydathang.Text = ngaydathang; txt_chuky.Text = chuky; txt_tongtien.Text = tongtien; txt_pttt.Text = pttt; txt_ptvc.Text = ptvc; drp_tinhtrang.SelectedValue = tinhtrang; drp_ghichu.SelectedValue = ghichu; hienthitimkiem(); Panel1.Visible = false; Panel2.Visible = true; }
private void Hienthinguoidung() { object[] obj0 = new object[0]; DataSet dsnd = new DataSet(); dsnd = SupportDb.ReturnDataSet("hienthinguoidung", obj0); grv_nguoidung.DataSource = dsnd; grv_nguoidung.DataBind(); }
private void Hienthisanpham() { object[] obj0 = new object[0]; DataSet ds = new DataSet(); ds = SupportDb.ReturnDataSet("laytatcasp", obj0); grv_sanpham.DataSource = ds; grv_sanpham.DataBind(); }
private void Hienthiquangcao() { object[] obj0 = new object[0]; DataSet dsqc = new DataSet(); dsqc = SupportDb.ReturnDataSet("hienthiquangcao", obj0); grv_quangcao.DataSource = dsqc; grv_quangcao.DataBind(); }
private void Hienthidonhang() { object[] obj0 = new object[0]; DataSet ds = new DataSet(); ds = SupportDb.ReturnDataSet("hienthidonhang2", obj0); grv_donhang.DataSource = ds; grv_donhang.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { DataSet ds = new DataSet(); object[] obj = new object[0]; ds = SupportDb.ReturnDataSet("SanPhamMoi", obj); DataList1.DataSource = ds; DataList1.DataBind(); }
private void Hienthihoadon() { object[] objtt = new object[0]; DataSet dsa = new DataSet(); dsa = SupportDb.ReturnDataSet("hienthichitietdonhang", objtt); grv_chitietdh.DataSource = dsa; grv_chitietdh.DataBind(); }
private void Hienthihangcon() { object[] obj0 = new object[0]; DataSet ds = new DataSet(); ds = SupportDb.ReturnDataSet("thongkehangcontheonhom", obj0); grv_hangcon.DataSource = ds; grv_hangcon.DataBind(); }
private void Hienthisoluongban() { object[] objtt = new object[0]; DataSet dssl = new DataSet(); dssl = SupportDb.ReturnDataSet("thongkesoluonghangban", objtt); grv_slban.DataSource = dssl; grv_slban.DataBind(); }
private void Hienthichitietdh() { object[] obj3 = new object[1]; obj3[0] = Convert.ToInt32(Session["madh1"]); DataSet dsctdh = new DataSet(); dsctdh = SupportDb.ReturnDataSet("hienthichitietdonhang2", obj3); grv_chitietdh.DataSource = dsctdh; grv_chitietdh.DataBind(); }
private void timnguoidungtheoten() { object[] objtim = new object[1]; objtim[0] = txt_ten.Text; DataSet dskqnd = new DataSet(); dskqnd = SupportDb.ReturnDataSet("timnguoidungtheoten", objtim); grv_kqnguoidung.DataSource = dskqnd; grv_kqnguoidung.DataBind(); }
void PhanTrangDataList_CollectionPaper() { object[] objPrint = new object[0]; DataSet dsPrint = new DataSet(); dsPrint = SupportDb.ReturnDataSet("HienThiTatCaSanPham", objPrint); clpPhantrang.DataSource = dsPrint.Tables[0].DefaultView; clpPhantrang.BindToControl = DataList1; DataList1.DataSource = clpPhantrang.DataSourcePaged; }
private void timsp() { object[] obj01 = new object[1]; obj01[0] = Convert.ToInt32(drp_manh.SelectedValue); Session["manh01"] = Convert.ToInt32(drp_manh.SelectedValue); DataSet dsa = new DataSet(); dsa = SupportDb.ReturnDataSet("timsptheomanh", obj01); grv_sp.DataSource = dsa; grv_sp.DataBind(); }
private void hienthitimkiem() { object[] obja = new object[2]; obja[0] = txt_tenkhach1.Text; obja[1] = Convert.ToInt32(drp_thang.SelectedValue); DataSet ds1 = new DataSet(); ds1 = SupportDb.ReturnDataSet("timdonhangtheotenkhachvathang", obja); grv_timkiem.DataSource = ds1; grv_timkiem.DataBind(); }
private void soluongbantheothang() { object[] objk = new object[1]; objk[0] = Convert.ToInt32(drp_thang.SelectedValue); Session["slthang"] = Convert.ToInt32(drp_thang.SelectedValue); DataSet ds1 = new DataSet(); ds1 = SupportDb.ReturnDataSet("thongkesoluongbanduoc", objk); grv_slbantheothang.DataSource = ds1; grv_slbantheothang.DataBind(); }
protected void grv_sp_PageIndexChanging(object sender, GridViewPageEventArgs e) { grv_sp.PageIndex = e.NewPageIndex; object[] obj011 = new object[1]; obj011[0] = Session["manh01"]; DataSet dsa = new DataSet(); dsa = SupportDb.ReturnDataSet("timsptheomanh", obj011); grv_sp.DataSource = dsa; grv_sp.DataBind(); }
protected void grv_ctdh_PageIndexChanging(object sender, GridViewPageEventArgs e) { grv_ctdh.PageIndex = e.NewPageIndex; object[] obj02 = new object[1]; obj02[0] = Session["dhthang"]; DataSet ds11 = new DataSet(); ds11 = SupportDb.ReturnDataSet("layhoadontrongthang", obj02); grv_ctdh.DataSource = ds11; grv_ctdh.DataBind(); }
private void laydhthang() { object[] obj0 = new object[1]; obj0[0] = Convert.ToInt32(drp_thang.SelectedValue); Session["dhthang"] = Convert.ToInt32(drp_thang.SelectedValue); DataSet ds1 = new DataSet(); ds1 = SupportDb.ReturnDataSet("layhoadontrongthang", obj0); grv_ctdh.DataSource = ds1; grv_ctdh.DataBind(); }
void HienthiVanChuyen() { object[] obj = new object[0]; DataSet ds = new DataSet(); ds = SupportDb.ReturnDataSet("HienThiVanChuyen", obj); if (ds.Tables[0].Rows.Count > 0) { //goi ham de nap du lieu vao dropdownlist SupportDb.BindFromDataSetToCombo(ds, DrpVanChuyen, "IDVanChuyen", "TenVanChuyen"); } }
void HienthiThanhToan() { object[] obj = new object[0]; DataSet ds1 = new DataSet(); ds1 = SupportDb.ReturnDataSet("HienThiThanhToan", obj); if (ds1.Tables[0].Rows.Count > 0) { //goi ham de nap du lieu vao dropdownlist SupportDb.BindFromDataSetToCombo(ds1, DrpThanhToan, "IDThanhToan", "TenThanhToan"); } }
protected void Page_Load(object sender, EventArgs e) { Title = "Quản Lý Khách Hàng"; //goi thu tuc lay tat ca kenh du lieu object[] obj = new object[0]; DataSet dsquyen = new DataSet(); dsquyen = SupportDb.ReturnDataSet("HienThiQuyen", obj); if (dsquyen.Tables[0].Rows.Count > 0) { //goi ham de nap du lieu vao dropdownlist SupportDb.BindFromDataSetToCombo(dsquyen, drpQuyen, "IDQuyen", "TenQuyen"); } }