SQLServerDAL/Order.cs

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

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

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



namespace MyShop.SQLServerDAL
{
    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 -1;
            }
            SqlParameter[] prams = {
				Database.MakeInParam("@OrderNum",SqlDbType.NVarChar,50,model.OrderNum),
				Database.MakeInParam("@UserName",SqlDbType.NVarChar,20,model.UserName),
				Database.MakeInParam("@ClientId",SqlDbType.Int,4,model.ClientId),
				Database.MakeInParam("@MoneyTotal",SqlDbType.Money,4,model.MoneyTotal),
				Database.MakeInParam("@MoneyGoods",SqlDbType.Money,4,model.MoneyGoods),
				Database.MakeInParam("@NeedInvoice",SqlDbType.TinyInt,1,model.NeedInvoice),
				Database.MakeInParam("@Invoiced",SqlDbType.TinyInt,1,model.Invoiced),
				Database.MakeInParam("@Remark",SqlDbType.NText,0,model.Remark),
				Database.MakeInParam("@InputTime",SqlDbType.DateTime,8,model.InputTime),
				Database.MakeInParam("@ContacterName",SqlDbType.NVarChar,50,model.ContacterName),
				Database.MakeInParam("@Address",SqlDbType.NVarChar,255,model.Address),
				Database.MakeInParam("@ZipCode",SqlDbType.NVarChar,10,model.ZipCode),
				Database.MakeInParam("@Mobile",SqlDbType.NVarChar,50,model.Mobile),
				Database.MakeInParam("@Phone",SqlDbType.NVarChar,50,model.Phone),
				Database.MakeInParam("@Email",SqlDbType.NVarChar,50,model.Email),
				Database.MakeInParam("@PaymentType",SqlDbType.Int,4,model.PaymentType),
				Database.MakeInParam("@DeliverType",SqlDbType.Int,4,model.DeliverType),
				Database.MakeInParam("@Status",SqlDbType.Int,4,model.Status),
				Database.MakeInParam("@PresentExp",SqlDbType.Int,4,model.PresentExp),
				Database.MakeInParam("@ChargeDeliver",SqlDbType.Money,2,model.ChargeDeliver),
				Database.MakeInParam("@InvoiceContent",SqlDbType.NText,0,model.InvoiceContent),