source/HF.Core/HF.Sale.Data/SaleCuXiaoData.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 HF.Dictionary.Data;
namespace HF.Sale.Data
{
    public class SaleCuXiaoData : BaseData
    {
        public SaleCuXiaoData()
        {
            TableName = "Sale_CuXiao";
            Prefix = "cuxiao";
            KeyField = "Id";
            string[] fields = { "Id", "...",};
            FieldList = fields.Concat(BaseFieldArray).ToArray();//合并基础列
            DataBaseName = SaleModuleHelper.CfgDataBaseName;
        }
        public override string GetNewEnCode(string organizeId)
        {
            return "CX" + DictionaryData.GetMaxNumberWithDate(organizeId, SaleConst.BillType_CuXiao, 4);
            //SqlDataItem item = new SqlDataItem();
            //item.CommandText = "Sale_GetCuXiaoCode";
            //item.CommandType = CommandType.StoredProcedure.ToString();
            //item.DatabaseName = SaleModuleHelper.CfgDataBaseName;
            //item.AppendParameter("@dicType", SaleConst.BillType_CuXiao);
            //item.AppendParameter("@OrganizeId", organizeId);
            //ClientDBAgent agent = new ClientDBAgent();
            //string r = agent.ExecuteScalar(item);
            //return r;
        }
        public static SaleCuXiaoData GetInstance()
        {
            return new SaleCuXiaoData();
        }
        /// <summary>
        /// 获取促销类型下的促销活动信息
        /// </summary>
        /// <param name="cxTypeid">促销类型Id</param>
        /// <param name="organizeId">所属组织Id</param>
        /// <returns></returns>
        //public DataTable GetTableByTypeId(string cxTypeid, string organizeId,string sort)
        //{
        //    if (sort.IsEmpty()) sort = "OrderNum";
        //    string tmpStr = "select * from Sale_CuXiao where  CxTypeId=@CxTypeId and OrganizeId=@OrganizeId order by " + sort;
        //    SqlDataItem sqlItem = new SqlDataItem();
        //    sqlItem.CommandText = tmpStr;
        //    sqlItem.DatabaseName = DataBaseName;
        //    sqlItem.AppendParameter("@cxTypeid", cxTypeid);
        //    sqlItem.AppendParameter("@OrganizeId", organizeId);
        //    ClientDBAgent agent = new ClientDBAgent();
        //    return agent.ExecuteDataTable(sqlItem);
        //}
        public override DataTable GetListTableById(string organizeId, string cateId, string queryJson, int pageindex, int pagesize, string sort)