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

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

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Threading.Tasks;
using HF.DataAccess.SqlDataContract;
using HF.DataAccess.DBAgent;
using HF.Business.Common;
using HF.Framework;
using Newtonsoft.Json.Linq;
namespace HF.Sale.Data
{
    public class SaleStockData:BaseData
    {
        public SaleStockData()
        {
            TableName = "Sale_Stock";
            KeyField = "StockId";
            TableViewName = "Sale_GoodsStockView";
            Prefix = "stock";
            string[] fields = { "StockId","OrganizeId","GoodsId","StoreId","Quantity" ,"YuZhanQuantity","KeYongQuantity",
                                "Layer" ,"OrderNum","DeleteFlag","EnableFlag","Description"};
            FieldList = fields.ToArray();//合并基础列
            DataBaseName = SaleModuleHelper.CfgDataBaseName;
        }
       
        public static SaleStockData GetInstance()
        {
            return new SaleStockData();
        }
        public override DataTable GetListTableById(string organizeId, string cateId, string queryJson, int pageindex, int pagesize, string sort)
        {
            return GetListTableByKeys(organizeId, "cateId", cateId, pageindex, pagesize, sort);
        }
        //public DataTable GetTableByCateId(string cateId,string organizeId, string pageindex, string pagesize, string sort)
        //{
        //    return GetListTableByKeys(organizeId, "cateId", cateId, pageindex, pagesize, sort);
        //}
        /// <summary>
        /// 获取分类下的库存台帐信息
        /// </summary>
        /// <param name="cateId">商品分类Id</param>
        /// <param name="organizeId">所属组织Id</param>
        /// <param name="pageindex">页码</param>
        /// <param name="pagesize">每页条数</param>
        /// <param name="sort">排序</param>
        /// <returns></returns>
        public DataTable GetTzTableByCateId(string cateId, string organizeId, string pageindex, string pagesize, string sort)
        {
            return GetSaleStockTzTable(organizeId, "{\"CateId\":\""+ cateId+"\"}", pageindex, pagesize, sort);
        }
        /// <summary>
        /// 通用的库存查询,选择库存时使用，不分页，只返回前n条
        /// </summary>
        /// <param name="organizeId">所属公司id</param>
        /// <param name="condition">条件字段名</param>
        /// <param name="keyword">条件值</param>
        /// <param name="n">条数</param>
        /// <param name="sort">排序</param>