系统分析与设计
[name]=@gsName,[address]=@gsAddress,[content]=@gsContent,[phone]=@gsPhone where id = @gsid\;
SqlParameter[] paras = new SqlParameter[]{ new SqlParameter(\,gs.Id), new SqlParameter(\,gs.Name),
new SqlParameter(\,gs.Address), new SqlParameter(\,gs.Content), new SqlParameter(\,gs.Phone) }; int res = sqlhelper.ExecuteNonQuery(sql, paras,CommandType.Text); if (res > 0) {
flag = true; }
return flag; } } } /*
*招聘信息管理表的操作类 *王溢文 */
using System;
using System.Collections.Generic; using System.Linq; using System.Text; using System.Data;
using System.Data.SqlClient; using Model;
namespace DAL {
public class ManageDAO {
private SQLHelper sqlhelper = null; public ManageDAO() {
sqlhelper = new SQLHelper(); }
///
/// 取出最新10条招聘信息（所属分类，所属职位，所属公司，发布时间）
///
16
系统分析与设计
///
public DataTable SelectNewNews() {
return
sqlhelper.ExecuteQuery(\,CommandType.StoredProcedure); }
///
/// 根据行业类别ID取出该行业下所有的招聘信息 ///
/// ///
public DataTable SelectByCaId(string caid) {
DataTable dt = new DataTable();
string procName = \; SqlParameter[] paras = new SqlParameter[] {
new SqlParameter(\,caid) }; dt = sqlhelper.ExecuteQuery(procName,paras,CommandType.StoredProcedure);
return dt; }
///
/// 根据招聘信息ID取出该条信息下的招聘主题内容 ///
///
public Manage SekectById(string id) {
Manage n = new Manage();
DataTable dt = new DataTable();
string cmdText = \; SqlParameter[] paras = new SqlParameter[] {
new SqlParameter(\,id) }; dt = sqlhelper.ExecuteQuery(cmdText, paras, CommandType.StoredProcedure);
17
系统分析与设计
n.Id = id;
n.NameId = dt.Rows[0][\].ToString(); n.Title = dt.Rows[0][\].ToString(); n.Content = dt.Rows[0][\].ToString();
n.CreateTime = dt.Rows[0][\].ToString(); n.CaId = dt.Rows[0][\].ToString(); return n; }
///
/// 根据招聘信职位取出该条信息下的招聘信息 ///
/// ///
public DataTable SelectByTitle(string title) {
DataTable dt = new DataTable();
string cmdText = \; SqlParameter[] paras = new SqlParameter[] {
new SqlParameter(\,title) }; dt = sqlhelper.ExecuteQuery(cmdText, CommandType.StoredProcedure); return dt; }
///
/// ///
public bool Insert(Manage n) {
bool flag = false;
DataTable dt = new DataTable(); string cmdText = \;
SqlParameter[] paras = new SqlParameter[] {
new SqlParameter(\,n.Title), new SqlParameter(\,n.Content), new SqlParameter(\,n.CaId), };
18
paras, 系统分析与设计
int res = sqlhelper.ExecuteNonQuery(cmdText, paras, CommandType.StoredProcedure); if (res > 0) {
flag = true; }
return flag; }
///
/// ///
public bool Update(Manage n) {
bool flag = false;
string cmdText = \;
SqlParameter[] paras = new SqlParameter[] {
new SqlParameter(\,n.Id),
new SqlParameter(\,n.Title), new SqlParameter(\,n.Content), new SqlParameter(\,n.CaId), };
int res = sqlhelper.ExecuteNonQuery(cmdText, CommandType.StoredProcedure); if (res > 0) {
flag = true; }
return flag; }
//删除信息（连同招聘信息询问一起删除） public bool Delete(string id) {
bool flag = false;
string cmdText = \;
SqlParameter[] paras = new SqlParameter[] {
new SqlParameter(\,id), };
19
paras, 系统分析与设计
int res = sqlhelper.ExecuteNonQuery(cmdText, paras, CommandType.StoredProcedure); if (res > 0) {
flag = true; }
return flag; } } } /*
*注册用户管理表的操作类 *王溢文 */
using System;
using System.Collections.Generic; using System.Linq; using System.Text; using System.Data;
using System.Data.SqlClient; using Model;
namespace DAL {
///
/// 注册用户管理表的操作类 ///
public class UserManageDAO {
private SQLHelper sqlhelper = null; public UserManageDAO() {
sqlhelper = new SQLHelper(); }
///
///
public bool Insert(UserManage yh) {
bool flag = false;
string sql = \into 20
userManage values