Backup/CreateSQLSentence/OrdersDetSentence.cs

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

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

namespace CreateSQLSentence
{
    public class OrdersDetSentence:I_OdersDetManage
    {
        SQLAccess sqlManager = new SQLAccess();

        #region I_OdersDetManage 成员
        /// <summary>
        /// 添加定单
        /// </summary>
        /// <param name="newOrder">定单对象</param>
        /// <returns>INT类型返回值</returns>
        int I_OdersDetManage.AddOrderDet(OrderDet newOrder)
        {
            StringBuilder sqlSentence = new StringBuilder();
            sqlSentence.Append("insert into Tab_OrderDet(ProductID,ProductCount,OrderID,productUnitPrice)");
            sqlSentence.AppendFormat(" values('{0}','{1}','{2}','{3}')", newOrder.ProductID1, newOrder.ProductCount1, newOrder.OrderID1, newOrder.ProductUnitPrice);
            return sqlManager.ExecuteNonQuery(sqlSentence.ToString());
        }

        #endregion
    }
}