source/HF.Core/HF.Sale.Data/SaleCartData.cs

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

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using HF.DataAccess.SqlDataContract;
using HF.DataAccess.DBAgent;
using HF.Business.Common;
using HF.Framework;
using System.Data;

namespace HF.Sale.Data
{
  public  class SaleCartData: BaseData
    {
        public SaleCartData()
        {
            TableName = "Sale_Cart";
            KeyField = "Id";
            Prefix = "cart";
            string[] fields = { "Id","EnCode","CustId","CustCaption","OrganizeId",
                                "GoodsCount","OwnerId","OwnerName" ,"BillMoney","DiscountMoney","YingShouMoney",
                               };
            FieldList = fields.Concat(BaseFieldArray).ToArray();//合并基础列
            DataBaseName = SaleModuleHelper.CfgDataBaseName;
        }
        public static SaleCartData GetInstance()
        {
            return new SaleCartData();
        }
        /// <summary>
        /// 获取购物车主表
        /// </summary>
        /// <param name="userId">当前操作用户Id</param>
        /// <returns></returns>
        public DataRow GetCartByUserId(string organizeId, string userId)
        {
            //return GetDataRow("Sale_Cart", "Id", userId);
            string tmpStr = @"select *  from Sale_Cart
                              where  Id=@BillId and organizeId=@organizeId  order by CreateTime desc";
            SqlDataItem sqlItem = new SqlDataItem();
            sqlItem.CommandText = tmpStr;
            sqlItem.DatabaseName = DataBaseName;
            sqlItem.AppendParameter("@BillId", userId);
            sqlItem.AppendParameter("@organizeId", organizeId);
            ClientDBAgent agent = new ClientDBAgent();
            DataTable dt= agent.ExecuteDataTable(sqlItem);
            if (!dt.IsEmpty())
                return dt.Rows[0];
            else
                return null;
        }
        /// <summary>
        /// 获取购物车明细
        /// </summary>
        /// <param name="billId"></param>
        /// <returns></returns>
        public DataTable GetCartDetTable(string organizeId,string billId)
        {
            string tmpStr = @"select *, case IsChecked when '0' then 'false' else 'true' end checked
                              from Sale_CartDetView