Backup/CreateSQLSentence/CustomersSentence.cs

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using DAL;
using IDAL;

namespace CreateSQLSentence
{
    public class CustomersSentence:I_CustomersManage
    {
        StringBuilder sqlSentence=new StringBuilder();
        SQLAccess sqlManager = new SQLAccess();
        #region I_CustomersManage 成员
        /// <summary>
        /// 顾客信息的查询
        /// </summary>
        /// <param name="sql_where">查询条件</param>
        /// <returns>查询到的结果</returns>
        public DataSet Select(string sql_where)
        {
            sqlSentence.Append("select * from Tab_Customers ");
            if (sql_where.Length > 0)
            {
                sqlSentence.AppendFormat("where {0}", sql_where);
            }
            return sqlManager.ExecuteDataSet(sqlSentence.ToString());
        }

        #endregion
    }
}