//
public DataSet LocSanPham(ref string err, string search)
{
return(db.ExecuteNonQueryDataSet("spLocSanPham", CommandType.StoredProcedure, ref err,
new SqlParameter("@search", search)));
}
public DataSet SearchNhanVien(ref string err, string search)
{
return(db.ExecuteNonQueryDataSet("spSearchNhanVien", CommandType.StoredProcedure, ref err, new SqlParameter("@search", search)));
}
public DataSet getThongKeTheoLSP(ref string err, string LSP)
{
return(db.ExecuteNonQueryDataSet("SELECT * FROM [dbo].fThongKeTheoLSP(@LSP)", CommandType.Text, ref err,
new SqlParameter("@LSP", LSP)));
}