QiFeng.ZWY.Dal/Orders.cs

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

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

using System; 
using System.Collections.Generic;
using System.Text;
using System.Data.SqlClient;
using System.Data;
using QiFeng.LMSD.DBUtility;
using QiFeng.LMSD.Model;
using QiFeng.LMSD.Model.Dto;
using System.Text.RegularExpressions;
using QiFeng.LMSD.Model.EnumModel;
using QiFeng.LMSD.Utility;
using System.Linq;

namespace QiFeng.LMSD.Dal
{
	public partial class OrdersDal : BaseDal<OrdersDal>
    {
        #region 默认方法
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(Orders model)
        {
            var strSql = new StringBuilder();
            strSql.Append("insert into Orders(");
            strSql.Append("OrderNo,ConsumerId,ReceivingAddressId,TotalPrice,AllMoney,Postage,BookingDate,DealStatus,IsReturnGoods,ReturnGoodsStatus,IsDeliverGoods,DeliverGoodDate,ExpressId,LogisticsNum,IsSign,SignDate,PayTotalIntegral,GetTotalIntegral,UpdateAccountId,UpdateDate,Remark,GetMemberPointNum,MemberName,DisCount,BeforeDisCountPrice,IsDelete");
            strSql.Append(") values (");
            strSql.Append("@OrderNo,@ConsumerId,@ReceivingAddressId,@TotalPrice,@AllMoney,@Postage,@BookingDate,@DealStatus,@IsReturnGoods,@ReturnGoodsStatus,@IsDeliverGoods,@DeliverGoodDate,@ExpressId,@LogisticsNum,@IsSign,@SignDate,@PayTotalIntegral,@GetTotalIntegral,@UpdateAccountId,@UpdateDate,@Remark,@GetMemberPointNum,@MemberName,@DisCount,@BeforeDisCountPrice,@IsDelete");
            strSql.Append(") ");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters = {
                        new SqlParameter("@OrderNo", SqlDbType.NVarChar,50) ,
                        new SqlParameter("@ConsumerId", SqlDbType.Int,4) ,
                        new SqlParameter("@ReceivingAddressId", SqlDbType.Int,4) ,
                        new SqlParameter("@TotalPrice", SqlDbType.Decimal,9) ,
                        new SqlParameter("@AllMoney", SqlDbType.Decimal,9) ,
                        new SqlParameter("@Postage", SqlDbType.Decimal,9) ,
                        new SqlParameter("@BookingDate", SqlDbType.DateTime) ,
                        new SqlParameter("@DealStatus", SqlDbType.Int,4) ,
                        new SqlParameter("@IsReturnGoods", SqlDbType.Bit,1) ,
                        new SqlParameter("@ReturnGoodsStatus", SqlDbType.Int,4) ,
                        new SqlParameter("@IsDeliverGoods", SqlDbType.Bit,1) ,
                        new SqlParameter("@DeliverGoodDate", SqlDbType.DateTime) ,
                        new SqlParameter("@ExpressId", SqlDbType.Int,4) ,
                        new SqlParameter("@LogisticsNum", SqlDbType.NVarChar,50) ,
                        new SqlParameter("@IsSign", SqlDbType.Bit,1) ,
                        new SqlParameter("@SignDate", SqlDbType.DateTime) ,
                        new SqlParameter("@PayTotalIntegral", SqlDbType.Int,4) ,
                        new SqlParameter("@GetTotalIntegral", SqlDbType.Int,4) ,
                        new SqlParameter("@UpdateAccountId", SqlDbType.Int,4) ,
                        new SqlParameter("@UpdateDate", SqlDbType.DateTime) ,
                        new SqlParameter("@Remark", SqlDbType.VarChar,500) ,
                        new SqlParameter("@GetMemberPointNum", SqlDbType.Int,4) ,
                        new SqlParameter("@MemberName", SqlDbType.NVarChar,50) ,
                        new SqlParameter("@DisCount", SqlDbType.Decimal,5) ,
                        new SqlParameter("@BeforeDisCountPrice", SqlDbType.Decimal,9) ,
                        new SqlParameter("@IsDelete", SqlDbType.Bit,1)

            };