source/HF.Core/HF.Sale.Data/SalePanDianData.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;
namespace HF.Sale.Data
{
    public class SalePanDianData : HF.Business.Common.BaseData
    {
        public SalePanDianData()
        {
            TableName = "Sale_PanDian";
            KeyField = "Id";
            Prefix = "pdian";
            string[] fields = { "Id","EnCode","OrganizeId","StoreId" };
            FieldList = fields.Concat(BaseFieldArray).ToArray();//合并基础列
            DataBaseName = SaleModuleHelper.CfgDataBaseName;
        }

        public string NewEnCode(string organizeId)
        {
            SqlDataItem item = new SqlDataItem();
            item.CommandText = "Sale_PanDianBillCode";
            item.CommandType = CommandType.StoredProcedure.ToString();
            item.DatabaseName = SaleModuleHelper.CfgDataBaseName;
            item.AppendParameter("@dicType", SaleConst.BillType_PanDian);
            item.AppendParameter("@OrganizeId", organizeId);
            ClientDBAgent agent = new ClientDBAgent();
            string r = agent.ExecuteScalar(item);
            return r;
        }
        public static SalePanDianData GetInstance()
        {
            return new SalePanDianData();
        }
        public DataTable GetNoPanDianBillTable(string organizeId,int n=20)
        {
            SqlDataItem sqlItem = new SqlDataItem();
            var strSql = new StringBuilder();
            strSql.Append(@" select top 20 Id,OrganizeId,StoreId,Caption,StoreName from Sale_PanDianView  
                             where AuditFlag=0 and DeleteFlag=0 and EnableFlag=1 and OrganizeId=@OrganizeId ");
            strSql.Append(" order by CreateTime ");
            sqlItem.AppendParameter("@organizeId", organizeId);
            sqlItem.CommandText = strSql.ToString();
            sqlItem.DatabaseName = DataBaseName;
            ClientDBAgent agent = new ClientDBAgent();
            return agent.ExecuteDataTable(sqlItem);
        }
        /// <summary>
        /// 获取库存明细，颜色尺码，盘点准备
        /// </summary>
        /// <param name="stockId">库存Id</param>
        /// <returns>DataTable</returns>
        public DataTable GetStockDetOfPanDian(string stockId)
        {