confidentialdao.cs

来自「小型ERP系统源码,修改版本」· CS 代码 · 共 46 行

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

namespace DLOA.DAO
{
    /// <summary>
    /// ConfidentialDAO 的摘要说明
    /// </summary>
    public class ConfidentialDAO
    {
        public ConfidentialDAO()
        {
            //
            // TODO: 在此处添加构造函数逻辑
            //
        }

        /// <summary>
        /// 获得数据列表
        /// </summary>
        public DataTable GetList(string strWhere)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select id,rank,name ");
            strSql.Append(" FROM Confidential ");
            if (strWhere.Trim() != "")
            {
                strSql.Append(" where " + strWhere);
            }
            return DbHelperSQL.QueryBySql(strSql.ToString());
        }

       
    }
}