App_Code/DAO/LeaveDAO.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;


namespace Salary.DAO
{
}
/// <summary>
/// LeaveDAO 的摘要说明:关于请假的业务处理逻辑
/// </summary>
public class LeaveDAO
{

	private string errMessage = ""; // 保存出错信息
    public string getErrMessage()
    {
        return this.errMessage;
    }

	// 按条件执行请假信息的查找
	public DataSet QueryLeaveInfo(string searchZiduan,string keyword) { // 用于执行按条件查询
		string sqlStr = "select * from [leaveView] where 1=1"; // 根据不同条件构造不同的sql查询字符串
		if (!searchZiduan.Equals("0")) {
			sqlStr = sqlStr + " and " + searchZiduan + " like '%" + keyword
					+ "%'";
		}
        DataBase db = new DataBase();
        DataSet ds = db.GetDataSet(sqlStr);
		return ds;
	}

	// 向数据库中假条信息表中插入一条新的记录
	public bool AddLeaveInfo(Leave leave){
		/*首先验证在系统中是否存在该员工的信息*/
		String sql = "select * from [employee] where employeeId='" + leave.getEmployeeId() + "'";
		DataBase db = new DataBase();
        DataSet ds = db.GetDataSet(sql);
        if(ds.Tables[0].Rows.Count == 0)
        {
            this.errMessage = "不存在改员工信息!";
            return false;
        }
		string editTime = System.DateTime.Now.ToString();
		string sqlStr = "insert into leave(employeeId,startTime,day,reason,approvePerson,editTime,memo) values ('";
		sqlStr = sqlStr + leave.getEmployeeId()
				+ "','";
		sqlStr = sqlStr + leave.getStartTime()
				+ "','";
		sqlStr = sqlStr + leave.getDay() + "','";
		sqlStr = sqlStr + leave.getReason() + "','";