App_Code/DAO/ChuqinDAO.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>
/// ChuqinDAO 的摘要说明:员工出勤业务操作
/// </summary>
public class ChuqinDAO
{
    private string errMessage; /*保存业务处理错误信息*/
    public string getErrMessage() {return this.errMessage;}

	// 按条件执行考勤信息的查找
	public DataSet QueryChuqin(string employeeId,string year,string month)
    {
		string sqlStr = "select * from [chuqinView] where employeeId like '%" + employeeId + "%'";
		if (!year.Equals("0"))
			sqlStr += " and year =" + year;
		if (!month.Equals("0"))
			sqlStr += " and month = " + month;
        DataBase db = new DataBase();
        DataSet ds = db.GetDataSet(sqlStr);
		return ds;
	}

	// 向数据库中出勤信息表中插入一条新的记录
	public bool insert(Chuqin chuqin) {
		/* 严整是否存在该员工的信息 */
		String sqlStr = "select * from [employee] where employeeId='" + chuqin.getEmployeeId() + "'";
        DataBase db = new DataBase();
        DataSet ds = db.GetDataSet(sqlStr);
        if(ds.Tables[0].Rows.Count == 0)
        {
            this.errMessage = "不存在该员工信息!";
            return false;
        }
		/* 验证该员工该月份的考勤信息是否已经登记 */
		sqlStr = "select * from [chuqin] where employeeId='"
				+ chuqin.getEmployeeId() + "' and year=" + chuqin.getYear()
				+ " and month=" + chuqin.getMonth();
        ds = db.GetDataSet(sqlStr);
        if(ds.Tables[0].Rows.Count > 0)
        {
            this.errMessage = "该员工该月份的考勤信息已存在!";
            return false;
        }
		/*添加该员工该月份的出勤信息*/
		sqlStr = "insert into chuqin(employeeId,year,month,overHour,chiDao,zaoTui,kuangGong) values ('";
		sqlStr = sqlStr + chuqin.getEmployeeId() + "',";
		sqlStr += chuqin.getYear() + ",";
		sqlStr += chuqin.getMonth() + ",";