public static string GetSupervisor(Department dept)
{
var dr = JobSQL.getJobSupervisor(dept);
var supervisor = string.Empty;
while (dr.Read())
{
supervisor = Convert.ToString(dr["FirstName"]) + " " + Convert.ToString(dr["MiddleInitial"]) + " " + Convert.ToString(dr["LastName"]);
}
return(supervisor);
}
public static List <Job> getJobsByDept(Department dept)
{
return(JobLists.RePackage(JobSQL.getJobsByDept(dept)));
}
/// <summary>
/// 查看单个
/// </summary>
/// <param name="nID"></param>
/// <returns></returns>
public Job Get_SingJob(int nID)
{
JobSQL jobSQL = new JobSQL();
return(jobSQL.Get_SingJob(nID));
}
public static Job Create(int jobId)
{
return(Repackage(JobSQL.GetJobDetails(jobId)));
}
/// <summary>
/// 查看总数
/// </summary>
/// <returns></returns>
public int Get_JobNum()
{
JobSQL jobSQL = new JobSQL();
return(jobSQL.Get_JobNum());
}
/// <summary>
/// 查看全部
/// </summary>
/// <param name="nstartIndex"></param>
/// <param name="nendIndex"></param>
/// <returns></returns>
public List <Job> Get_Job(int nstartIndex, int nendIndex)
{
JobSQL jobSQL = new JobSQL();
return(jobSQL.Get_Job(nstartIndex, nendIndex));
}
/// <summary>
/// 删除
/// </summary>
/// <param name="nID"></param>
public void Delete_Job(int nID)
{
JobSQL jobSQL = new JobSQL();
jobSQL.Delete_Job(nID);
}
/// <summary>
/// 修改
/// </summary>
/// <param name="job"></param>
public void Update_Job(Job job)
{
JobSQL jobSQL = new JobSQL();
jobSQL.Update_Job(job);
}
/// <summary>
/// 添加
/// </summary>
/// <param name="job"></param>
/// <returns></returns>
public int Add_Job(Job job)
{
JobSQL jobSQL = new JobSQL();
return(jobSQL.Add_Job(job));
}
