系统分析与设计
CommandType.Text);
if (res > 0) {
flag = true; }
return flag; }
///
/// 判断该类别是否存在 ///
/// ///
public bool IsExists(string caName) {
bool flag = false;
string sql = \ +
caName + \;
DataTabledt=sqlhelper.ExecuteQuery(sql,CommandType.Text); if (dt.Rows.Count > 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 CommentDAO {
private SQLHelper sqlhelper;
11
系统分析与设计
public CommentDAO() {
sqlhelper = new SQLHelper(); }
///
/// 根据招聘信息ID取出所有针对该信息的询问记录 ///
/// ///
public DataTable SelectByNewsId(string newsId) {
DataTable dt = new DataTable();
string sql = \comment where newsId=@newsId\; SqlParameter[] paras = new SqlParameter[] {
new SqlParameter(\,newsId) }; dt = sqlhelper.ExecuteQuery(sql, paras,CommandType.Text); return dt; }
///
/// 根据用户信息ID取出所有针对该用户的询问记录 ///
///
public DataTable SelectByUserId(string userId) {
DataTable dt = new DataTable();
string sql = \comment where userId=@userId\; SqlParameter[] paras = new SqlParameter[] {
new SqlParameter(\,userId) }; dt = sqlhelper.ExecuteQuery(sql, paras,CommandType.Text); return dt; }
///
///
12
系统分析与设计
///
public bool Insert(Comment xw) {
bool flag = false; string sql = \into comment([content],createTime,userId,newsId) values(@content,@createTime,@userId,@newsId)\;
SqlParameter[] paras = new SqlParameter[] {
new SqlParameter(\,xw.Content),
new SqlParameter(\,xw.CreateTime), new SqlParameter(\,xw.UserId), new SqlParameter(\,xw.NewsId), }; int res = sqlhelper.ExecuteNonQuery(sql, paras,CommandType.Text); if (res > 0) {
flag = true; }
return flag; }
///
///
public bool Delete(string id) {
bool flag = false;
string sql = \; SqlParameter[] paras = new SqlParameter[] {
new SqlParameter(\,id) }; int res = sqlhelper.ExecuteNonQuery(sql, paras,CommandType.Text); if (res > 0) {
flag = true; }
13
系统分析与设计
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 CompanyManageDAO {
private SQLHelper sqlhelper = null; public CompanyManageDAO() {
sqlhelper = new SQLHelper(); }
///
///
public bool Insert(CompanyManage gs) {
bool flag = false; string sql = \companyManage([name],[address],[content],phone) values(@gsName,@gsAddress,@gsContent,@gsPhone)\;
SqlParameter[] paras = new SqlParameter[]{ new SqlParameter(\,gs.Id),
14
into
系统分析与设计
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; }
///
/// 删除公司（连同该公司所有的招聘信息及招聘信息的询问一起删除）
///
///
public bool Delete(string id) {
bool flag = false; string sql = \from companyManage where id = @gsid\; SqlParameter[] paras = new SqlParameter[]{ new SqlParameter(\,id) }; int res = sqlhelper.ExecuteNonQuery(sql, paras,CommandType.Text); if (res > 0) {
flag = true; }
return flag; }
///
///
public bool Update(CompanyManage gs) {
bool flag = false; string sql = \companyManage set
15