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)); }