protected void gridNhomKhachHang_RowDeleting(object sender, DevExpress.Web.Data.ASPxDataDeletingEventArgs e) { string ID = e.Keys[0].ToString(); data = new dtNhomKhachHang(); data.XoaNhomKhachHang(Int32.Parse(ID)); e.Cancel = true; gridNhomKhachHang.CancelEdit(); LoadGrid(); }
protected void gridNhomKhachHang_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e) { string TenNhomKhachHang = e.NewValues["TenNhomKhachHang"].ToString(); string GhiChu = e.NewValues["GhiChu"] == null ? "" : e.NewValues["GhiChu"].ToString(); data = new dtNhomKhachHang(); data.ThemNhomNhomHangMoi(TenNhomKhachHang, GhiChu); e.Cancel = true; gridNhomKhachHang.CancelEdit(); LoadGrid(); }
protected void gridNhomKhachHang_RowDeleting(object sender, DevExpress.Web.Data.ASPxDataDeletingEventArgs e) { string ID = e.Keys[0].ToString(); data = new dtNhomKhachHang(); data.XoaNhomKhachHang(Int32.Parse(ID)); e.Cancel = true; gridNhomKhachHang.CancelEdit(); LoadGrid(); dtLichSuTruyCap.ThemLichSu(Session["IDNhanVien"].ToString(), Session["IDNhom"].ToString(), "Nhóm Khách Hàng:" + ID, Session["IDKho"].ToString(), "Danh Mục", "Xóa"); }
protected void gridNhomKhachHang_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e) { string TenNhomKhachHang = e.NewValues["TenNhomKhachHang"].ToString(); string GhiChu = e.NewValues["GhiChu"] == null ? "" : e.NewValues["GhiChu"].ToString(); data = new dtNhomKhachHang(); data.ThemNhomNhomHangMoi(TenNhomKhachHang, GhiChu, Session["IDKho"].ToString()); e.Cancel = true; gridNhomKhachHang.CancelEdit(); LoadGrid(); dtLichSuTruyCap.ThemLichSu(Session["IDNhanVien"].ToString(), Session["IDNhom"].ToString(), "Nhóm Khách Hàng:" + TenNhomKhachHang, Session["IDKho"].ToString(), "Danh Mục", "Thêm"); }
private void Import_Temp(DataTable datatable) { int intRow = datatable.Rows.Count; if (intRow != 0) { for (int i = 0; i <= intRow - 1; i++) { DataRow dr = datatable.Rows[i]; DateTime date = DateTime.Now; string sDate = date.ToString("MMddyyyy"); int MaKh = 0; Random rdom = new Random(); while (MaKh == 0) { int sR = rdom.Next(10000, 99999); int kt = data.KiemTraMaKhachHang(sDate + sR); if (kt == 0) { MaKh = sR; } } string maKHang = sDate + MaKh; dtNhomKhachHang dtNhomKH = new dtNhomKhachHang(); int IDNhomKhachHang = dtNhomKH.LayIDNhomKhachHang_Ten("Nhóm khách hàng"); string TenKhachHang = dr["Tên khách hàng"].ToString(); string NgaySinh = dr["Ngày sinh"] == null ? "" : dr["Ngày sinh"].ToString(); string CMND = dr["CMND"] == null ? "" : dr["CMND"].ToString(); string DiaChi = dr["Địa chỉ"] == null ? "" : dr["Địa chỉ"].ToString(); string DienThoai = dr["SĐT"].ToString(); string GhiChu = dr["Ghi chú"] == null ? "" : dr["Ghi chú"].ToString(); data = new dtKhachHang(); data.ThemKhachHang_Temp(IDNhomKhachHang, maKHang, TenKhachHang, DateTime.Parse(NgaySinh), CMND, DiaChi, DienThoai, GhiChu); LoadGrid(); } } }
public void LoadGrid() { data = new dtNhomKhachHang(); gridNhomKhachHang.DataSource = data.LayDanhNhomKhachHang(Session["IDKho"].ToString()); gridNhomKhachHang.DataBind(); }
public void LoadGrid() { data = new dtNhomKhachHang(); gridNhomKhachHang.DataSource = data.LayDanhNhomKhachHang(); gridNhomKhachHang.DataBind(); }