Backup/SQLServerDAL/sql_products.cs

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

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

namespace SQLServerDAL
{
    public class sql_products:IDAL.ProductDal
    {
        DBunit.SQLAccess sql = new DBunit.SQLAccess();
        /// <summary>
        /// 增加一条数据
        /// </summary>
        /// <param name="tab">实体对象</param>
        /// <returns></returns>
        public int Add(Model.tab_products tab)
        {
            StringBuilder str = new StringBuilder();
            str.Append("insert into tab_products(productName,productClassID,productUnitPrice,productCount,productImg,productContent) values(");
            str.AppendFormat("'{0}',", tab.ProductName);
            str.AppendFormat("'{0}',", tab.ProductClassID);
            str.AppendFormat("'{0}',", tab.ProductUnitPrice);
            str.AppendFormat("'{0}',", tab.ProductCount);
            str.AppendFormat("'{0}',", tab.ProductImg);
            str.AppendFormat("'{0}')", tab.ProductContent);
            return sql.ExecuteNonQuery(str.ToString());
        }
        /// <summary>
        /// 删除一条数据
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        public int Delete(int id)
        {
            return sql.ExecuteNonQuery("delete from tab_products where productID=" + id);
            

        }
        /// <summary>
        /// 更新数据
        /// </summary>
        /// <param name="sq"></param>
        /// <returns></returns>
        public int Update(string sq)
        {

            return sql.ExecuteNonQuery(sq);
        }
        /// <summary>
        /// 查询一张表
        /// </summary>
        /// <param name="sq"></param>
        /// <returns></returns>
        public DataTable GetTable(string sq)
        {
            return sql.ExecuteDataSet(sq).Tables[0];
        }
    }
}