AccessDAL/Order.cs

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

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

using System;
using System.Collections.Generic;
using System.Data;
using System.Data.OleDb;
using MyShop.IDAL;
using MyShop.Model;
using MyShop.Common;
using MyShop.Config;




namespace MyShop.AccessDAL
{
    public class Order :IOrder
    {
        
        private string tableName = "Ljh_Order";

        public Order()
        {
            if (!string.IsNullOrEmpty(BaseConfig.GetBaseConfig().TablePrefix.Trim()))
                tableName = BaseConfig.GetBaseConfig().TablePrefix + "orders";
        }

        #region IOrder member


        /// <summary>
        /// add  
        /// </summary>
        /// <param name="model"></param>
        /// <returns>返回ID, 如果发生错误则返回-1</returns>
        public int Add(OrderInfo model)
        {
            if (model == null)
            {
                return 0;
            }
            string commandText = "insert into " + this.tableName + "(orderNum,userName,clientId,moneyTotal,moneyGoods,needInvoice,invoiced,remark,inputTime,contacterName,address,zipCode,mobile,phone,email,paymentType,deliverType,[status],presentExp,chargeDeliver,invoiceContent,DeliverStatus,MoneyReceived)  values(@orderNum,@userName,@clientId,@moneyTotal,@moneyGoods,@needInvoice,@invoiced,@remark,@inputTime,@contacterName,@address,@zipCode,@mobile,@phone,@email,@paymentType,@deliverType,@status,@presentExp,@chargeDeliver,@invoiceContent,@DeliverStatus,@MoneyReceived)";
            OleDbParameter[] commandParameters = {
				    Database.MakeInParam("@OrderNum",OleDbType.VarWChar,50,model.OrderNum),
				    Database.MakeInParam("@UserName",OleDbType.VarWChar,20,model.UserName),
				    Database.MakeInParam("@ClientId",OleDbType.Integer,4,model.ClientId),
				    Database.MakeInParam("@MoneyTotal",OleDbType.Currency,4,model.MoneyTotal),
				    Database.MakeInParam("@MoneyGoods",OleDbType.Currency,4,model.MoneyGoods),
				    Database.MakeInParam("@NeedInvoice",OleDbType.UnsignedTinyInt,1,model.NeedInvoice),
				    Database.MakeInParam("@Invoiced",OleDbType.UnsignedTinyInt,1,model.Invoiced),
				    Database.MakeInParam("@Remark",OleDbType.VarWChar,0,model.Remark),
				    Database.MakeInParam("@InputTime",OleDbType.Date,8,model.InputTime),
				    Database.MakeInParam("@ContacterName",OleDbType.VarWChar,50,model.ContacterName),
				    Database.MakeInParam("@Address",OleDbType.VarWChar,255,model.Address),
				    Database.MakeInParam("@ZipCode",OleDbType.VarWChar,10,model.ZipCode),
				    Database.MakeInParam("@Mobile",OleDbType.VarWChar,50,model.Mobile),
				    Database.MakeInParam("@Phone",OleDbType.VarWChar,50,model.Phone),
				    Database.MakeInParam("@Email",OleDbType.VarWChar,50,model.Email),
				    Database.MakeInParam("@PaymentType",OleDbType.Integer,4,model.PaymentType),
				    Database.MakeInParam("@DeliverType",OleDbType.Integer,4,model.DeliverType),
				    Database.MakeInParam("@Status",OleDbType.Integer,4,model.Status),
				    Database.MakeInParam("@PresentExp",OleDbType.Integer,4,model.PresentExp),