/// <summary>
/// 添加招聘职位
/// </summary>
/// <param name="obj">带入参数</param>
/// <returns></returns>
public int Insert_JoinUsPostTableData(JoinUsPost_Table obj)
{
return(DBHerlper.ExecuteNonQuery(GetSqlString("Insert"),
CommandType.StoredProcedure,
new SqlParameter[] {
new SqlParameter("@JUP_Name", obj.JUP_Name),
new SqlParameter("@JUP_Number", obj.JUP_Number)
}));
}
/// <summary>
/// 获取全部的招聘职位
/// </summary>
/// <returns></returns>
public List <JoinUsPost_Table> GetJoinUsPostTableAll()
{
List <JoinUsPost_Table> list = new List <JoinUsPost_Table>();
SqlDataReader dr = DBHerlper.ExecuteReader(GetSqlString("Select"),
CommandType.StoredProcedure);
while (dr.Read())
{
JoinUsPost_Table obj = new JoinUsPost_Table()
{
JUP_id = (int)dr["JUP_id"],
JUP_Name = dr["JUP_Name"].ToString(),
JUP_Number = (int)dr["JUP_Number"]
};
list.Add(obj);
}
dr.Close();
return(list);
}
/// <summary>
/// 根据ID查询招聘职位信息
/// </summary>
/// <param name="con"></param>
/// <returns></returns>
public JoinUsPost_Table GetJoinUsPostTableByConn(string con)
{
JoinUsPost_Table obj = null;
SqlDataReader dr = DBHerlper.ExecuteReader(
"Select * from JoinUsPost_Table where JUP_id=@JUP_id",
CommandType.Text, new SqlParameter[] {
new SqlParameter("@JUP_id", con)
});
if (dr.Read())
{
obj = new JoinUsPost_Table()
{
JUP_id = (int)dr["JUP_id"],
JUP_Name = dr["JUP_Name"].ToString(),
JUP_Number = (int)dr["JUP_Number"]
};
}
dr.Close();
return(obj);
}
/// <summary>
/// 更改招聘岗位信息
/// </summary>
/// <param name="obj">带入参数</param>
/// <returns></returns>
public int Update_JoinUsPostTableData(JoinUsPost_Table obj)
{
return(relevanceClass.Update_JoinUsPostTableData(obj));
}
/// <summary>
/// 添加招聘岗位信息
/// </summary>
/// <param name="obj">带入参数</param>
/// <returns></returns>
public int Insert_JoinUsPostTableData(JoinUsPost_Table obj)
{
return(relevanceClass.Insert_JoinUsPostTableData(obj));
}
