public DataTable TraCuuKhachHang(string tenKH, string diachi) { string sql = ""; if (tenKH.CompareTo("") != 0 && diachi.CompareTo("") != 0) { sql = "select * where TenKH LIKE @tenKH AND DChi LIKE @diachi"; } else { if (tenKH.CompareTo("") != 0) { sql = "select * from Tb_KhachHang where TenKH LIKE @tenKH"; } else { sql = "select * from Tb_KhachHang where DChi LIKE @diachi"; } } SqlParameter[] thamso = { new SqlParameter("@tenKH", "%" + tenKH + "%"), new SqlParameter("@diachi", "%" + diachi + "%") }; DataTable d = ConnectToDB.Truyvan_TraVe_Table_co_Thamso(sql, thamso); da = ConnectToDB.Truyvan_TraVe_DataAdapter_co_Thamso(sql, thamso); return(d); }
//Tra cuu nhan vien public DataTable TraCuuNhanVien(string LoaiNV, string TenTV) { string sql = ""; if (LoaiNV.CompareTo("") != 0 && TenTV.CompareTo("") != 0) { sql = "select * from Tb_ThongTinNhanVien where MaLoaiNV=@MaLoaiNV AND TenNV LIKE @TenNV"; } else { if (LoaiNV.CompareTo("") != 0) { sql = "select * from Tb_ThongTinNhanVien where MaLoaiNV=@MaLoaiNV"; } else { sql = "select * from Tb_ThongTinNhanVien where TenNV LIKE @TenNV"; } } SqlParameter[] thamso = { new SqlParameter("@MaLoaiNV", LoaiNV), new SqlParameter("@TenNV", "%" + TenTV + "%") }; DataTable DT_DSNhanVien = ConnectToDB.Truyvan_TraVe_Table_co_Thamso(sql, thamso); return(DT_DSNhanVien); }
//Truy Van Lay ra thanh vien cham cong vao thang nam public DataTable LayRaChamCongThanhVien(string MaNV, int Thang, int Nam) { string sql = "select * from Tb_ChamCong where MaNV=@MaNV AND Thang=@Thang AND Nam=@Nam"; SqlParameter[] thamso = { new SqlParameter("@MaNV", MaNV), new SqlParameter("@Thang", Thang), new SqlParameter("@Nam", Nam) }; return(ConnectToDB.Truyvan_TraVe_Table_co_Thamso(sql, thamso)); }