App_Code/DAO/SalaryDAO.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>
    /// SalaryDAO 的摘要说明:关于工资管理的业务处理
    /// </summary>
    public class SalaryDAO
    {
        private string errMessage = "";           //保存出错信息
        public string getErrMessage() { return this.errMessage; }

        //按条件执行工资信息的查找
        public DataSet QuerySalaryInfo(string searchYear, string searchMonth, string employeeId, string departmentId)
        {  //用于执行按条件查询

            string sqlStr = "select * from [salaryView] where employeeId like '%" + employeeId + "%'";
            if (!searchYear.Equals("0"))
                sqlStr += " and year=" + searchYear;
            if (!searchMonth.Equals("0"))
                sqlStr += " and month=" + searchMonth;
            if (!departmentId.Equals("0"))
                sqlStr += " and departmentId=" + departmentId;
            DataBase db = new DataBase();
            DataSet ds = db.GetDataSet(sqlStr);
            return ds;
        }



        //删除编号为salaryId的工资信息
        public bool DeleteSalary(int salaryId)
        {
            string sqlStr = "delete from salary where salaryId =" + salaryId;
            DataBase db = new DataBase();
            if (db.InsertOrUpdate(sqlStr) > 0)
                return true;
            return false;
        }

        public bool MakeSalary(int year, int month)
        {

            
           return true;
        }


        private bool IsAllEmployeeChuqinWrited(int year,int month)