App_Code/DAO/SellDAO.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>
/// SellDAO 的摘要说明
/// </summary>
public class SellDAO
{
    private string errMessage; /*保存业务处理错误信息*/
    public string getErrMessage() { return this.errMessage; }
	// 按条件执行业绩信息的查找
	public DataSet QuerySellInfo(string sellYear,string sellMonth,string employeeId) 
    { 
        // 用于执行按条件查询
		string sqlStr = "select * from [sellView] where employeeId like '%" + employeeId + "%'";
		if (!sellYear.Equals("0"))
			sqlStr += " and sellYear =" + sellYear;
		if (!sellMonth.Equals("0"))
			sqlStr += " and sellMonth = " + sellMonth;
        DataBase db = new DataBase();
        return db.GetDataSet(sqlStr);
	}

	// 向数据库中销售业绩信息表中插入一条新的记录
	public bool AddSellInfo(Sell sell)  {
		/* 验证是否存在该员工的信息 */
		string sqlStr = "select * from [employee] where employeeId='" + sell.getEmployeeId() + "'";
		DataBase db = new DataBase();
        DataSet ds = db.GetDataSet(sqlStr);
        if(ds.Tables[0].Rows.Count == 0)
        {
            this.errMessage = "不存在该员工信息";
            return false;
        }
		/* 验证该员工该月份的销售业绩信息是否已经登记 */
		sqlStr = "select * from [sell] where employeeId='"
				+ sell.getEmployeeId() + "' and sellYear=" + sell.getSellYear()
				+ " and sellMonth=" + sell.getSellMonth();
        ds = db.GetDataSet(sqlStr);
        if(ds.Tables[0].Rows.Count > 0)
        {
            this.errMessage = "该员工该月份的销售业绩信息已存在!";
            return false;
        }
		
		sqlStr = "insert into sell(employeeId,sellYear,sellMonth,sellMoney) values ('";
		sqlStr = sqlStr + sell.getEmployeeId() + "',";
		sqlStr += sell.getSellYear() + ",";
		sqlStr += sell.getSellMonth() + ",";
		sqlStr += sell.getSellMoney() + ")";