departmentdao.cs

小型ERP系统源码,修改版本

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 DLOA.DALFactory;
using System.Text;

/// <summary>
/// DepartmentDAO 的摘要说明
/// </summary>
namespace DLOA.DAO
{
    public class DepartmentDAO
    {
        public DepartmentDAO()
        {

        }

        /// <summary>
        /// 获得部门信息
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable GetList(string strWhere)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select id,name,leadership1,leadership2,jurisdiction ");
            strSql.Append(" FROM Department ");
            if (strWhere.Trim() != "")
            {
                strSql.Append(" where " + strWhere);
            }
            return DbHelperSQL.QueryBySql(strSql.ToString());
        }
    }
}