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();
}
