/// <summary>
/// 获取简历的总数量
/// </summary>
/// <returns></returns>
public static int GetResumeCount()
{
DBAccess db = new DBAccess();
return (int)db.ExecuteScalar("JobsDb_Resumes_GetCount");
}
public static int GetJobPostingCount()
{
DBAccess db = new DBAccess();
return (int)db.ExecuteScalar("JobsDb_JobPostings_GetCount");
}
public static string GetExperienceLevelName(int id)
{
DBAccess db = new DBAccess();
db.AddParameter("@iExperienceLevelID", id);
return db.ExecuteScalar("JobsDb_ExperienceLevels_GetLevelName").ToString();
}
public static string GetStateName(int id)
{
DBAccess db = new DBAccess();
db.AddParameter("@iStateID", id);
return db.ExecuteScalar("JobsDb_States_GetStateName").ToString();
}
public static string GetCompanyName(int companyid)
{
DBAccess db = new DBAccess();
db.AddParameter("@iCompanyID", companyid);
return (string)db.ExecuteScalar("JobsDb_Companies_SelectName");
}
public static int GetCompanyCount()
{
DBAccess db = new DBAccess();
return (int)db.ExecuteScalar("JobsDb_Companies_GetCount");
}
public static string GetCountryName(int id)
{
DBAccess db = new DBAccess();
db.AddParameter("@iCountryID", id);
return db.ExecuteScalar("JobsDb_Countries_GetCountryName").ToString();
}