Backup/CreateSQLSentence/OrderSentence.cs

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

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

using System;
using System.Collections.Generic;
using System.Text;
using Model;
using DAL;
using System.Data.SqlClient;
using System.Data.Sql;
using System.Data;
using IDAL;


namespace CreateSQLSentence
{
    public class OrderSentence : I_OrdersManage
    {
        SQLAccess sqlManager = new SQLAccess();
        StringBuilder sqlSentence;
        #region I_OrdersManage 成员
        /// <summary>
        /// 删除定单
        /// </summary>
        /// <param name="OrderObject">定单对象</param>
        /// <returns>INT类型返回</returns>
        public int DeleteOrder(Order OrderObject)
        {
            sqlSentence = new StringBuilder();
            sqlSentence.Append("delete from  Tab_Orders where ");
            sqlSentence.AppendFormat("OrderID='{0}' ",OrderObject.OrderID1);
            return sqlManager.ExecuteNonQuery(sqlSentence.ToString());
        }
        /// <summary>
        /// 模糊查询
        /// </summary>
        /// <param name="info">查询条件</param>
        /// <returns></returns>
        public DataSet SelectOrders(string info)
        {
            sqlSentence = new StringBuilder();
            sqlSentence.Append("select * from Tab_Orders where ");
            sqlSentence.AppendFormat(" OrderDate like %'{0}'% or ReceiveName like %'{1}'% or ReceiveAddress like %'{2}'%");
            return sqlManager.ExecuteDataSet(sqlSentence.ToString());
        }
        /// <summary>
        /// 整表查询
        /// </summary>
        /// <returns></returns>
        public DataSet SelectOrders()
        {
            sqlSentence = new StringBuilder();
            sqlSentence.Append("select * from Tab_Orders join Tab_Customers on Tab_Customers.CustomerID=Tab_Orders.CustomerID");
            return sqlManager.ExecuteDataSet(sqlSentence.ToString());
        }
        /// <summary>
        /// 添加定单
        /// </summary>
        /// <param name="newOrder">定单对象</param>
        /// <returns>INT类型返回值,定单号</returns>
        int I_OrdersManage.AddOrder(Order newOrder)
        {
            sqlSentence=new StringBuilder();