SQLServerDAL/sql_customer.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

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

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
namespace SQLServerDAL
{
    class sql_customer:IDAL.customerDal
    {
        DBunit.SQLAccess sql = new DBunit.SQLAccess();
        #region customerDal 成员
        /// <summary>
        /// 客户表的添加
        /// </summary>
        /// <param name="customer"></param>
        /// <returns></returns>
        public DataTable CustomerAdd(Model.tab_customers customer)
        {
            StringBuilder strsql = new StringBuilder();
            strsql.Append("insert into tab_customers values (");
            strsql.AppendFormat("'{0}',", customer.customerName);
            strsql.AppendFormat("'{0}',", customer.customerEmail);
            strsql.AppendFormat("'{0}',", customer.customerTel);
            strsql.AppendFormat("'{0}',", customer.customerAddress);
            strsql.AppendFormat("'{0}',", customer.customerPwd);
            strsql.AppendFormat("'{0}'", customer.customerCode);
            strsql.Append(")");
            return sql.ExecuteDataSet(strsql.ToString()).Tables[0];
            
        }
        /// <summary>
        /// 客户表的查找
        /// </summary>
        /// <param name="cus"></param>
        /// <returns></returns>
        public System.Data.DataTable CustomerSelect(Model.tab_customers cus)
        {
             StringBuilder strsql = new StringBuilder();
             strsql.Append("select * from tab_customers where ");
             strsql.AppendFormat("customerID='{0}'", cus.customerID);
             strsql.AppendFormat(" or customerName='{0}'", cus.customerName);
             strsql.AppendFormat(" and customerPwd='{0}'", cus.customerPwd);
             return sql.ExecuteDataSet(strsql.ToString()).Tables[0];
        }
        /// <summary>
        /// 查找所有客户的信息
        /// </summary>
        /// <returns></returns>

        public System.Data.DataTable CustomerSelectAll()
        {
            return sql.ExecuteDataSet("select * from tab_customers").Tables[0];
        }
/// <summary>
/// 删除客户的信息
/// </summary>
/// <param name="customerID"></param>
/// <returns></returns>
        public int Delete(int customerID)
        {
            return sql.ExecuteNonQuery("delete * from tab_customers where customerID=" + customerID);