App_Code/DAO/EmployeeDAO.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

using Salary.DB;
using Salary.Model;

/// <summary>
/// EmployeeDAO 的摘要说明
/// </summary>
public class EmployeeDAO
{
	//按条件执行员工的查找
	public DataSet QueryEmployeeInfo(string searchZiduan,string keyword,string departmentId)
    {  
		//根据不同条件构造不同的sql查询字符串
		string sqlStr = "select * from [employeeInfoView] where 1=1";
		if(searchZiduan.Equals("0"))
			sqlStr += " and (employeeId like '%" + keyword + "%' or name like '%" + keyword + "%')";
		else
			sqlStr += " and " + searchZiduan + " like '%" + keyword + "%'";
		if(!departmentId.Equals("0"))
			sqlStr += " and department.departmentId=" + departmentId;
        DataBase db = new DataBase();
        return db.GetDataSet(sqlStr);
	}

  //向数据库中员工表中插入一条新的记录
	public bool AddEmployee(Employee employee){
		String editTime;
        editTime = System.DateTime.Now.ToString();
		string sqlStr = "insert into employee values ('";
		sqlStr = sqlStr + employee.getEmployeeId() + "','";
		sqlStr = sqlStr + employee.getName() + "','";
	    sqlStr = sqlStr + employee.getCardNumber() + "','";
	    sqlStr = sqlStr + employee.getNation() + "','";
	    sqlStr = sqlStr + employee.getSex() + "','";
	    sqlStr = sqlStr + employee.getBirthday() + "','";
	    sqlStr = sqlStr + employee.getGraduateSchool() + "','";
	    sqlStr = sqlStr + employee.getSchoolRecord() + "',";
	    sqlStr = sqlStr + employee.getDepartmentId() + ",";
	    sqlStr = sqlStr + employee.getPositionId() + ",'";
	    sqlStr = sqlStr + employee.getTelephone() + "','";
	    sqlStr = sqlStr + employee.getEmail() + "','";
	    sqlStr = sqlStr + editTime + "','";
	    sqlStr = sqlStr + employee.getMemo() + "')";
        DataBase db = new DataBase();
        if (db.InsertOrUpdate(sqlStr) <= 0)
            return false;
        return true;
		
	}

    //更新员工表中的一条记录