public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
//context.Response.Write("Hello World");
JoinUs_Table getData = new JoinUs_Table()
{
JU_Name = context.Request["Name"],
JU_Sex = context.Request["Sex"],
JU_Address = context.Request["Address"],
JU_Phone = context.Request["Phone"],
JUP_id = Convert.ToInt32(context.Request["Post"]),
JU_SubmitDateTime = DateTime.Now
};
JoinUsTable_BLL insert = new JoinUsTable_BLL();
int n = insert.Insert_JoinUsTableData(getData);
if (n > 0)
{
context.Response.Write("提交成功！");
}
else
{
context.Response.Write("提交失败！");
}
}
/// <summary>
/// 根据ID查询招聘职位信息
/// </summary>
/// <param name="con"></param>
/// <returns></returns>
public JoinUs_Table GetJoinUsTableByConn(string con)
{
JoinUs_Table obj = null;
SqlDataReader dr = DBHerlper.ExecuteReader(
"Select * from JoinUs_Table where JU_id=@JU_id",
CommandType.Text, new SqlParameter[] {
new SqlParameter("@JU_id", con)
});
if (dr.Read())
{
obj = new JoinUs_Table()
{
JUP_id = Convert.ToInt32(dr["JUP_id"]),
JU_id = Convert.ToInt32(dr["JU_id"]),
JU_Name = dr["JU_Name"].ToString(),
JU_Address = dr["JU_Address"].ToString(),
JU_SubmitDateTime = Convert.ToDateTime(dr["JU_SubmitDateTime"]),
JU_Phone = dr["JU_Phone"].ToString(),
JU_Sex = dr["JU_Sex"].ToString()
};
}
dr.Close();
return(obj);
}
/// <summary>
/// 更改招聘
/// </summary>
/// <param name="obj">带入参数</param>
/// <returns></returns>
public int Update_JoinUsTableData(JoinUs_Table obj)
{
return(DBHerlper.ExecuteNonQuery(GetSqlString("Update"),
CommandType.StoredProcedure,
new SqlParameter[] {
new SqlParameter("@JUP_id", obj.JUP_id),
new SqlParameter("@JU_Name", obj.JU_Name),
new SqlParameter("@JU_Phone", obj.JU_Phone),
new SqlParameter("@JU_Sex", obj.JU_Sex),
new SqlParameter("@JU_Address", obj.JU_Address),
new SqlParameter("@JU_SubmitDateTime", obj.JU_SubmitDateTime)
}));
}
/// <summary>
/// 获取全部的招聘
/// </summary>
/// <returns></returns>
public List <JoinUs_Table> GetJoinUsTableAll()
{
List <JoinUs_Table> list = new List <JoinUs_Table>();
SqlDataReader dr = DBHerlper.ExecuteReader(GetSqlString("Select"),
CommandType.StoredProcedure);
while (dr.Read())
{
JoinUs_Table obj = new JoinUs_Table()
{
JUP_id = Convert.ToInt32(dr["JUP_id"]),
JU_id = Convert.ToInt32(dr["JU_id"]),
JU_Name = dr["JU_Name"].ToString(),
JU_Address = dr["JU_Address"].ToString(),
JU_SubmitDateTime = Convert.ToDateTime(dr["JU_SubmitDateTime"]),
JU_Phone = dr["JU_Phone"].ToString(),
JU_Sex = dr["JU_Sex"].ToString()
};
list.Add(obj);
}
dr.Close();
return(list);
}
/// <summary>
/// 更改招聘信息
/// </summary>
/// <param name="obj">带入参数</param>
/// <returns></returns>
public int Update_JoinUsTableData(JoinUs_Table obj)
{
return(relevanceClass.Update_JoinUsTableData(obj));
}
/// <summary>
/// 添加招聘信息
/// </summary>
/// <param name="obj">带入参数</param>
/// <returns></returns>
public int Insert_JoinUsTableData(JoinUs_Table obj)
{
return(relevanceClass.Insert_JoinUsTableData(obj));
}
