SQLServerDAL/sql_Orders.cs

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

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

using System;
using System.Collections.Generic;
using System.Text;
//该源码首发自www.51aspx.com(５１ａsｐｘ．ｃｏｍ)

namespace SQLServerDAL
{
    class sql_Orders:IDAL.OrdersDal
    {
        #region OrdersDal 成员
        DBunit.SQLAccess sql = new DBunit.SQLAccess();
        /// <summary>
        /// 获取最大值
        /// </summary>
        /// <returns></returns>
        public int getMax()
        {
            object x = sql.ExecuteSc("select top 1 orderID from tab_orders order by orderID desc");
            return Convert.ToInt32(x) + 1;
        }

        public System.Data.DataTable GetAll()
        {
            return sql.ExecuteDataSet("select * from tab_orders").Tables[0];
        }

        public System.Data.DataTable GetAny(string sq)
        {
            return sql.ExecuteDataSet(sq).Tables[0];
        }

        public int Add(Model.tab_orders m_order)
        {
            StringBuilder strsql = new StringBuilder();
            strsql.Append("insert into tab_orders(customerID,customerName,customerTel,customerAddress,customerCode,orderInfo) values");
            strsql.AppendFormat("('{0}',", m_order.CustomerID);
            strsql.AppendFormat("'{0}',", m_order.CustomerName);
            strsql.AppendFormat("'{0}',", m_order.CustomerTel);
            strsql.AppendFormat("'{0}',", m_order.CustomerAddress);
            strsql.AppendFormat("'{0}',", m_order.CustomerCode);
            strsql.AppendFormat("'{0}')", m_order.OrderInfo);
            //strsql.AppendFormat("'{0}')", m_order.OrderDate);
            return sql.ExecuteNonQuery(strsql.ToString());
        }

        public int Update(Model.tab_orders m_order)
       {
           StringBuilder strsql = new StringBuilder();
           strsql.Append("update tab_orders set");
           strsql.AppendFormat(" CustomerID='{0}'", m_order.CustomerID);
           strsql.AppendFormat("OrderDetID='{0}'", m_order.OrderDetID);
       
           strsql.AppendFormat("where OrderID='{0}'", m_order.OrderID);
           return sql.ExecuteNonQuery(strsql.ToString());
       }

        public System.Data.DataSet getOrderInfo(string sq, string sqlx)
        {
            return sql.ExecuteDataSet(sq,sqlx);
        }