NongJiaLe/DAL/Shopping_Order.cs

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

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

using System;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using System.Collections.Generic;


using Shopping.Common;
using Shopping.Data;
using Shopping.Model;

namespace Shopping.DAL
{
    /// <summary>
    ///	订单信息表
    ///	数据层实例化接口类 Shopping_Order
    /// 主要完成对数据库的基本操作
    /// </summary>
    public partial class OrderProvider : SqlDB<OrderProvider>
    {
        #region Method
        /// <summary>
        /// 数据库表名
        /// </summary>
        private static string tableName = "Shopping_Order";
        /// <summary>
        /// 数据库视图名
        /// </summary>
        private static string viewName = "Shopping_View_Order";
        /// <summary>
        /// 数据查询语句(查询全部数据)
        /// </summary>
        private string select_strsql = "Select * from " + viewName;


        /// <summary>
        /// 数据插入语句
        /// </summary>
        private string insert_strsql = "Insert into " + tableName + " (ShipMobile,UserPoint,SavingByCoupon,RealPay,CouponID,CouponNo,PaidTime,ShopID,OrderNo,UserID,TotalPrice,Status,OrderTime,Remark,ShipPeopele,ShipAddress)values(@ShipMobile,@UserPoint,@SavingByCoupon,@RealPay,@CouponID,@CouponNo,@PaidTime,@ShopID,@OrderNo,@UserID,@TotalPrice,@Status,@OrderTime,@Remark,@ShipPeopele,@ShipAddress)";
        /// <summary>
        /// 数据插入语句
        /// </summary>
        private string count_strsql = "Select Count(*) From " + viewName;
        /// <summary>
        /// 数据更新语句
        /// </summary>
        private string update_strsql = "Update  " + tableName + " Set ShipMobile= @ShipMobile ,UserPoint= @UserPoint ,SavingByCoupon= @SavingByCoupon ,RealPay= @RealPay ,CouponID= @CouponID ,CouponNo= @CouponNo ,PaidTime= @PaidTime ,ShopID= @ShopID ,OrderNo= @OrderNo ,UserID= @UserID ,TotalPrice= @TotalPrice ,Status= @Status ,OrderTime= @OrderTime ,Remark= @Remark ,ShipPeopele= @ShipPeopele ,ShipAddress= @ShipAddress   where OrderID=@OrderID  ";
        /// <summary>
        /// 数据删除语句(根据主键删除)
        /// </summary>
        private string delete_strsql = "Delete  From " + tableName + "  where OrderID=@OrderID";


        #region  判断是否存在
        /// <summary>
        /// 根据条件判断是否存在
        /// </summary>
        /// <param name="condition">条件</param>