private void btnXoa_ItemClick(object sender, ItemClickEventArgs e) { if (comDonVi.Text != "" || comHangHoa.Text != "" || comKH.Text != "" || comKho.Text != "" || comNhom.Text != "" || comNPP.Text != "") { if (stateEvent == "HangHoa") { SQL_tblHangHoa temp = new SQL_tblHangHoa(); EC_tblHangHoa value = new EC_tblHangHoa(); value.HHMa = con.GetValue("select HHMa from tblHangHoa where HHTen like N'" + comHangHoa.Text + "'", 0); temp.XoaDuLieu(value); DateTime currentTime = DateTime.Now; con.ThucThiCauLenhSQL("insert into tblNhatKi (NKTen,NKTacVu,NKNgay,NKUser) values (N'Hàng Hóa',N'Xóa','" + string.Format("{0:yyyy/MM/dd HH:mm:ss}", currentTime) + "',N'" + lbNameUser + "')"); } else if (stateEvent == "DonVi") { SQL_tblDonVi temp = new SQL_tblDonVi(); EC_tblDonVi value = new EC_tblDonVi(); value.DVTen = comDonVi.Text; temp.XoaDuLieu(value); DateTime currentTime = DateTime.Now; con.ThucThiCauLenhSQL("insert into tblNhatKi (NKTen,NKTacVu,NKNgay,NKUser) values (N'Đơn Vị',N'Xóa','" + string.Format("{0:yyyy/MM/dd HH:mm:ss}", currentTime) + "',N'" + lbNameUser + "')"); } else if (stateEvent == "KhachHang") { SQL_tblKhachHang temp = new SQL_tblKhachHang(); EC_tblKhachHang value = new EC_tblKhachHang(); value.KHTen = comKH.Text; temp.XoaDuLieu(value); DateTime currentTime = DateTime.Now; con.ThucThiCauLenhSQL("insert into tblNhatKi (NKTen,NKTacVu,NKNgay,NKUser) values (N'Khách Hàng',N'Xóa','" + string.Format("{0:yyyy/MM/dd HH:mm:ss}", currentTime) + "',N'" + lbNameUser + "')"); } else if (stateEvent == "NPP") { SQL_NPP temp = new SQL_NPP(); EC_tblNPP value = new EC_tblNPP(); value.NPPTen = comNPP.Text; temp.XoaDuLieu(value); DateTime currentTime = DateTime.Now; con.ThucThiCauLenhSQL("insert into tblNhatKi (NKTen,NKTacVu,NKNgay,NKUser) values (N'Nhà Phân Phối',N'Xóa','" + string.Format("{0:yyyy/MM/dd HH:mm:ss}", currentTime) + "',N'" + lbNameUser + "')"); } else if (stateEvent == "Nhom") { SQL_Nhom temp = new SQL_Nhom(); EC_tblNhom value = new EC_tblNhom(); value.NTen = comNhom.Text; temp.XoaDuLieu(value); DateTime currentTime = DateTime.Now; con.ThucThiCauLenhSQL("insert into tblNhatKi (NKTen,NKTacVu,NKNgay,NKUser) values (N'Nhóm',N'Xóa','" + string.Format("{0:yyyy/MM/dd HH:mm:ss}", currentTime) + "',N'" + lbNameUser + "')"); } else if (stateEvent == "Kho") { SQL_Kho temp = new SQL_Kho(); EC_tblKho value = new EC_tblKho(); value.KTen = comKho.Text; temp.XoaDuLieu(value); DateTime currentTime = DateTime.Now; con.ThucThiCauLenhSQL("insert into tblNhatKi (NKTen,NKTacVu,NKNgay,NKUser) values (N'Kho',N'Xóa','" + string.Format("{0:yyyy/MM/dd HH:mm:ss}", currentTime) + "',N'" + lbNameUser + "')"); } XtraMessageBox.Show("Đã Xóa!", "Thông báo"); Them_Load(sender, e); } else { MessageBox.Show("Chưa chọn", "Thông báo"); } }