public static DataTable GetDataSanPham()
{
try
{
DataTable dt = new DataTable();
string sql = "select MaSP,TenSP from SanPham ";
conn = ConectToSQL_Datvd.Connect();
SqlDataAdapter da = new SqlDataAdapter(sql, conn);
da.Fill(dt);
conn.Close();
return(dt);
}
catch
{
conn.Close();
return(null);
}
}
public static DataTable GetData(string s)
{
try
{
DataTable dt = new DataTable();
string sql = "select s.TenSP,p.SoLuong,p.ChungLoai from PhieuXuatChiTiet p right join SanPham s on p.MaSP=s.MaSP where p.MaPX ='" + s + "'";
conn = ConectToSQL_Datvd.Connect();
SqlDataAdapter da = new SqlDataAdapter(sql, conn);
da.Fill(dt);
conn.Close();
return(dt);
}
catch
{
conn.Close();
return(null);
}
}
public static DataTable GetDataNhanVien()
{
try
{
DataTable dt = new DataTable();
string sql = "select MaNV,TenNV from NhanVien ";
conn = ConectToSQL_Datvd.Connect();
SqlDataAdapter da = new SqlDataAdapter(sql, conn);
da.Fill(dt);
conn.Close();
return(dt);
}
catch
{
conn.Close();
return(null);
}
}
public static DataTable GetDataKhachHang()
{
try
{
DataTable dt = new DataTable();
string sql = " select MaKH,TenkH from KhachHang";
conn = ConectToSQL_Datvd.Connect();
SqlDataAdapter da = new SqlDataAdapter(sql, conn);
da.Fill(dt);
conn.Close();
return(dt);
}
catch
{
conn.Close();
return(null);
}
}
public static DataTable GetData()
{
try
{
DataTable dt = new DataTable();
string sql = " select a.MaPX,a.NgayXuat,a.TenNV,k.TenKH from KhachHang k right join (select p.MaPX,p.NgayXuat,n.TenNV,p.MaKH from PhieuXuat p left join NhanVien n on p.MaNV=n.MaNV) a on a.MaKH=k.MaKH";
conn = ConectToSQL_Datvd.Connect();
SqlDataAdapter da = new SqlDataAdapter(sql, conn);
da.Fill(dt);
conn.Close();
return(dt);
}
catch
{
conn.Close();
return(null);
}
}
