/// <summary> /// 同步商品到易扫购,以修改方式 /// </summary> /// <param name="url">商品修改地址</param> /// <param name="merchantId">商户编号</param> /// <param name="customerId">商户角色编号</param> /// <param name="key">商户密钥</param> /// <param name="model">商品实体</param> /// <returns></returns> /// <remarks>2016-05-18 杨浩 创建</remarks> public Result AsynProductUpdate(string merchantId, string goodsId, string key, ParaProductSearchFilter model, int dealerSysNo) { var result = new Result() { Status = true }; var wareHouseInfo = BLL.Distribution.DsDealerWharehouseBo.Instance.GetByDsUserSysNo(dealerSysNo); if (wareHouseInfo == null) { result.Status = false; result.Message = "没有绑定仓库"; return(result); } string url = "https://mall.ehking.com/api/goods/modify"; //PdProductStock productStock = PdProductStockBo.Instance.GetEntityByWP(wareHouseInfo.WarehouseSysNo, 0); var pager = new Pager <CBPdProductDetail>(); var condition = new ParaProductFilter(); condition.DealerSysNo = dealerSysNo; pager.PageSize = int.MaxValue; pager.CurrentPage = 1; BLL.Distribution.DsSpecialPriceBo.Instance.GetSpecialPriceProductList(ref pager, condition); foreach (var row in pager.Rows) { } var product = new MEProductUpdate(); product.merchantId = merchantId; product.goodsId = goodsId; product.goodsName = model.ProductName; product.goodsCode = model.ErpCode; product.goodsAmount = (int)(model.Price * 100); product.goodsType = goodsType["其他"]; decimal inventoryCount = 0; //if (productStock != null) //{ // inventoryCount = productStock.StockQuantity; //} product.inventoryCount = (int)inventoryCount; product.status = model.Status; product.goodsDescribe = model.ProductSummary; IList <PdProductImage> imageList = new List <PdProductImage>(); imageList = PdProductImageBo.Instance.GetProductImg(model.SysNo).Take(12).ToList(); StringBuilder imageJsonArray = new StringBuilder(); product.pictureList = new List <MEProductUpdatePicture>(); int orderNum = 1; foreach (PdProductImage imageItem in imageList) { string filePath = imageItem.ImageUrl.Replace('/', '\\'); filePath = string.Format(filePath, @"E:\StaticFiles\SG\Images\", "Base"); MEProductUpdatePicture picture = new MEProductUpdatePicture(); picture.baseCode = imageToBase64(filePath); picture.orderNum = orderNum++; picture.fileType = getExtensionName(filePath); product.pictureList.Add(picture); } string hmac = product.merchantId + product.goodsId + product.goodsName + product.goodsCode + product.goodsAmount + product.goodsType + product.inventoryCount + product.status; product.hmac = Security.HmacSign(hmac, key); string param = LitJson.JsonMapper.ToJson(product); string jsonString = Send(url, param); if (jsonString.Contains(@"""status"":""ERROR""")) { result.Status = false; result.Message = jsonString; } else { result.Status = true; } return(result); }
/// <summary> /// 获取商品详细信息列表 /// </summary> /// <param name="pager">商品详细信息查询列表</param> /// <param name="dealerMallSysNo">分销商商城系统编号</param> /// <param name="condition">动态条件,CBPdProductDetail里不包含的条件</param> /// <returns></returns> /// <remarks>2015-12-10 王耀发 创建</remarks> public abstract void GetDealerMallProductList(ref Pager <CBPdProductDetail> pager, int dealerMallSysNo, ParaProductFilter condition);
/// <summary> /// 获取商品详细信息列表 /// </summary> /// <param name="pager">商品详细信息查询列表</param> /// <param name="dealerMallSysNo">分销商商城系统编号</param> /// <param name="condition">动态条件,CBPdProductDetail里不包含的条件</param> /// <returns></returns> /// <remarks>2015-12-10 王耀发 创建</remarks> public void GetSpecialPriceProductList(ref Pager <CBPdProductDetail> pager, ParaProductFilter condition) { IDsSpecialPriceDao.Instance.GetSpecialPriceProductList(ref pager, condition); }
/// <summary> /// 获取商品详细信息列表 /// </summary> /// <param name="pager">商品详细信息查询列表</param> /// <param name="dealerMallSysNo">分销商商城系统编号</param> /// <param name="condition">动态条件,CBPdProductDetail里不包含的条件</param> /// <returns></returns> /// <remarks> /// 2015-12-10 王耀发 创建 /// 2016-6-27 杨浩 增加产品价格只查有效的(PdPrice + Status=1) /// </remarks> public override void GetSpecialPriceProductList(ref Pager <CBPdProductDetail> pager, ParaProductFilter condition) { //List<DBKey> keyList = new List<DBKey>(); //keyList.Add(new DBKey() { KeyName = "WholesalePrice", Type = "decimal(18, 2)" }); //CheckKeyExcel(keyList); using (var _context = Context.UseSharedConnection(true)) { //只能看到总部和分销商对应自己创建的商品 //var sqlWhere = " 1=1 and p.Status <> 2 and (p.DealerSysNo = 0 or p.DealerSysNo = " + condition.SelectedDealerSysNo + ")"; var sqlWhere = " 1=1 and p.Status <> 2 "; if (condition.IsFrontDisplay >= 0) { sqlWhere += " and p.IsFrontDisplay=@IsFrontDisplay"; } if (condition.MainStatus >= 0) { sqlWhere += " and p.Status=@MainStatus"; } if (condition.Status >= 0) { sqlWhere += " and isnull(sp.Status,0)=@Status"; } if (condition.SysNo > 0) { sqlWhere += " and p.Sysno=@Sysno"; } if (!string.IsNullOrEmpty(condition.ErpCode) && condition.ErpCode != "") { sqlWhere += " and p.ErpCode=@ErpCode"; } if (!string.IsNullOrEmpty(condition.Barcode) && condition.Barcode != "") { sqlWhere += " and p.Barcode=@Barcode"; } if (condition.ProductType > 0) { sqlWhere += " and p.ProductType=@ProductType"; } if (!string.IsNullOrEmpty(condition.ProductName) && condition.ProductName != "") { sqlWhere += " and (p.EasName like @name1 or p.ErpCode = @name or p.Barcode=@name)"; } if (condition.StartTime != null) { sqlWhere += " and p.LastUpdateDate >= @StartTime"; } if (condition.EndTime != null) { sqlWhere += " and p.LastUpdateDate <= @EndTime"; } if (condition.CreateStartTime != null) { sqlWhere += " and p.CreatedDate >= @CreateStartTime"; } if (condition.CreateEndTime != null) { sqlWhere += " and p.CreatedDate <= @CreateEndTime"; } if (condition.ProductCategorySysno > 0) { sqlWhere += " and SysNos like '%," + condition.ProductCategorySysno + ",%' "; } if (condition.HasChangePrice.HasValue && condition.HasChangePrice == 1) { sqlWhere += " and case d.IsWholeSaler when 1 then p.TradePrice else price1.Price end<>sp.Price "; } if (condition.HasChangePrice.HasValue && condition.HasChangePrice == 2) { sqlWhere += " and case d.IsWholeSaler when 1 then p.TradePrice else price1.Price end=sp.Price "; } //获取当前分销商的订单和当前用户对应所有分销商订单 string sqlWhere2 = "1=1"; //判断是否绑定所有分销商 if (!condition.IsBindAllDealer) { //判断是否绑定分销商 if (condition.IsBindDealer) { sqlWhere2 += " and sp.DealerSysNo = @DealerSysNo"; } else { sqlWhere2 += " and sp.DealerSysNo in (select SysNo from DsDealer where CreatedBy = @DealerCreatedBy) "; } } if (condition.SelectedDealerSysNo != -1) { sqlWhere2 += " and sp.DealerSysNo = @SelectedDealerSysNo"; } pager.Rows = _context.Select <CBPdProductDetail>(@"p.barcode ,p.ProductName,p.SalesMeasurementUnit, sp.SysNo as SpecialPriceSysNo,p.SysNo,p.ErpCode,p.EasName,p.ProductType,p.CanFrontEndOrder,p.Status as MainStatus,isnull(sp.Status,0) as Status, c.categoryname as ProductCategoryName, c.sysno as ProductCategorySysno, price.Price as BasicPrice, case d.IsWholeSaler when 1 then p.TradePrice else price1.Price end as SalesPrice,sp.Price as spSalesPrice,sp.DealerSysNo,d.DealerName,sp.ShopPrice as spShopPrice,sp.WholesalePrice as spWholesalePrice") .From(@"PdProduct p left join (select productsysno,categorysysno from PdCategoryAssociation where IsMaster=@IsMaster) ca on ca.productsysno = p.sysno left join PdCategory c on ca.categorysysno = c.sysno left join (select * from PdPrice where PriceSource =@PriceSource and SourceSysNo =@SourceSysNo and Status=1) price on price.productsysno = p.sysno left join (select * from PdPrice where PriceSource =@PriceSource1 and SourceSysNo =@SourceSysNo1 and Status=1) price1 on price1.productsysno = p.sysno left join DsSpecialPrice sp on p.SysNo = sp.ProductSysNo and " + sqlWhere2 + " left join DsDealer d on sp.DealerSysNo = d.SysNo") .Where(sqlWhere) .Parameter("IsMaster", (int)ProductStatus.是否是主分类.是) .Parameter("PriceSource", (int)ProductStatus.产品价格来源.基础价格) .Parameter("PriceSource1", (int)ProductStatus.产品价格来源.会员等级价) .Parameter("SourceSysNo", 0) //基础价 .Parameter("SourceSysNo1", 1) //会员价 .Parameter("DealerSysNo", condition.DealerSysNo) .Parameter("DealerCreatedBy", condition.DealerCreatedBy) .Parameter("SelectedDealerSysNo", condition.SelectedDealerSysNo) .Parameter("IsFrontDisplay", condition.IsFrontDisplay) .Parameter("MainStatus", condition.MainStatus) .Parameter("Status", condition.Status) .Parameter("name", condition.ProductName) .Parameter("name1", "%" + condition.ProductName + "%") .Parameter("Sysno", condition.SysNo) .Parameter("ErpCode", condition.ErpCode) .Parameter("Barcode", condition.Barcode) .Parameter("ProductType", condition.ProductType) .Parameter("StartTime", condition.StartTime) .Parameter("EndTime", (condition.EndTime == null) ? condition.EndTime : ((DateTime)condition.EndTime).AddDays(1)) .Parameter("CreateStartTime", condition.CreateStartTime) .Parameter("CreateEndTime", (condition.CreateEndTime == null) ? condition.CreateEndTime : ((DateTime)condition.CreateEndTime).AddDays(1)) .Parameter("CanFrontEndOrder", condition.CanFrontEndOrder) .OrderBy("sp.DealerSysNo desc , sp.sysno desc ") .Paging(pager.CurrentPage, pager.PageSize) .QueryMany(); pager.TotalRows = _context.Select <int>("count(1)") .From(@"PdProduct p left join (select productsysno,categorysysno from PdCategoryAssociation where IsMaster=@IsMaster) ca on ca.productsysno = p.sysno left join PdCategory c on ca.categorysysno = c.sysno left join (select * from PdPrice where PriceSource =@PriceSource and SourceSysNo =@SourceSysNo and Status=1) price on price.productsysno = p.sysno left join (select * from PdPrice where PriceSource =@PriceSource1 and SourceSysNo =@SourceSysNo1 and Status=1) price1 on price1.productsysno = p.sysno left join DsSpecialPrice sp on p.SysNo = sp.ProductSysNo and " + sqlWhere2 + " left join DsDealer d on sp.DealerSysNo = d.SysNo") .Where(sqlWhere) .Parameter("IsMaster", (int)ProductStatus.是否是主分类.是) .Parameter("PriceSource", (int)ProductStatus.产品价格来源.基础价格) .Parameter("PriceSource1", (int)ProductStatus.产品价格来源.会员等级价) .Parameter("SourceSysNo", 0) //基础价 .Parameter("SourceSysNo1", 1) //会员价 .Parameter("DealerSysNo", condition.DealerSysNo) .Parameter("DealerCreatedBy", condition.DealerCreatedBy) .Parameter("SelectedDealerSysNo", condition.SelectedDealerSysNo) .Parameter("IsFrontDisplay", condition.IsFrontDisplay) .Parameter("MainStatus", condition.MainStatus) .Parameter("Status", condition.Status) .Parameter("name", condition.ProductName) .Parameter("name1", "%" + condition.ProductName + "%") .Parameter("Sysno", condition.SysNo) .Parameter("ErpCode", condition.ErpCode) .Parameter("Barcode", condition.Barcode) .Parameter("ProductType", condition.ProductType) .Parameter("StartTime", condition.StartTime) .Parameter("EndTime", (condition.EndTime == null) ? condition.EndTime : ((DateTime)condition.EndTime).AddDays(1)) .Parameter("CreateStartTime", condition.CreateStartTime) .Parameter("CreateEndTime", (condition.CreateEndTime == null) ? condition.CreateEndTime : ((DateTime)condition.CreateEndTime).AddDays(1)) .Parameter("CanFrontEndOrder", condition.CanFrontEndOrder) .QuerySingle(); pager.IdRows = _context.Select <int>(@"sp.SysNo as SpecialPriceSysNo") .From(@"PdProduct p left join (select productsysno,categorysysno from PdCategoryAssociation where IsMaster=@IsMaster) ca on ca.productsysno = p.sysno left join PdCategory c on ca.categorysysno = c.sysno left join (select * from PdPrice where PriceSource =@PriceSource and SourceSysNo =@SourceSysNo and Status=1) price on price.productsysno = p.sysno left join (select * from PdPrice where PriceSource =@PriceSource1 and SourceSysNo =@SourceSysNo1 and Status=1) price1 on price1.productsysno = p.sysno left join DsSpecialPrice sp on p.SysNo = sp.ProductSysNo and " + sqlWhere2 + " left join DsDealer d on sp.DealerSysNo = d.SysNo") .Where(sqlWhere) .Parameter("IsMaster", (int)ProductStatus.是否是主分类.是) .Parameter("PriceSource", (int)ProductStatus.产品价格来源.基础价格) .Parameter("PriceSource1", (int)ProductStatus.产品价格来源.会员等级价) .Parameter("SourceSysNo", 0) //基础价 .Parameter("SourceSysNo1", 1) //会员价 .Parameter("DealerSysNo", condition.DealerSysNo) .Parameter("DealerCreatedBy", condition.DealerCreatedBy) .Parameter("SelectedDealerSysNo", condition.SelectedDealerSysNo) .Parameter("IsFrontDisplay", condition.IsFrontDisplay) .Parameter("MainStatus", 1) .Parameter("Status", 1) .Parameter("name", condition.ProductName) .Parameter("name1", "%" + condition.ProductName + "%") .Parameter("Sysno", condition.SysNo) .Parameter("ErpCode", condition.ErpCode) .Parameter("Barcode", condition.Barcode) .Parameter("ProductType", condition.ProductType) .Parameter("StartTime", condition.StartTime) .Parameter("EndTime", (condition.EndTime == null) ? condition.EndTime : ((DateTime)condition.EndTime).AddDays(1)) .Parameter("CreateStartTime", condition.CreateStartTime) .Parameter("CreateEndTime", (condition.CreateEndTime == null) ? condition.CreateEndTime : ((DateTime)condition.CreateEndTime).AddDays(1)) .Parameter("CanFrontEndOrder", condition.CanFrontEndOrder) .QueryMany(); } }
/// <summary> /// 获取商品详细信息列表 /// </summary> /// <param name="pager">商品详细信息查询列表</param> /// <param name="dealerMallSysNo">分销商商城系统编号</param> /// <param name="condition">动态条件,CBPdProductDetail里不包含的条件</param> /// <returns></returns> /// <remarks>2015-12-10 王耀发 创建</remarks> public void GetDealerMallProductList(ref Pager <CBPdProductDetail> pager, int dealerMallSysNo, ParaProductFilter condition) { IDsProductAssociationDao.Instance.GetDealerMallProductList(ref pager, dealerMallSysNo, condition); }
/// <summary> /// 获取商品详细信息列表 /// </summary> /// <param name="pager">商品详细信息查询列表</param> /// <param name="dealerMallSysNo">分销商商城系统编号</param> /// <param name="condition">动态条件,CBPdProductDetail里不包含的条件</param> /// <returns></returns> /// <remarks>2015-12-10 王耀发 创建</remarks> public abstract void GetSpecialPriceProductList(ref Pager <CBPdProductDetail> pager, ParaProductFilter condition);
/// <summary> /// 查询导出商品列表(无净重,商品简介) /// </summary> /// <param name="sysNos"></param> /// <param name="productDetail"></param> /// <returns></returns> public abstract List <CBOutputPdProductsExcel> GetExportProductListExcel(List <int> sysNos, ParaProductFilter productDetail = null);
/// <summary> /// 根据条件获取商品列表 /// </summary> /// <param name="filter">搜索条件</param> /// <returns>商品列表</returns> /// <remarks>2013-06-25 黄波 创建</remarks> public abstract IList <CBPdProduct> GetProducts(ParaProductFilter filter);
/// <summary> /// 商品同步信息 /// </summary> /// <param name="sysNos"></param> /// <returns>2017 010 10 罗勤瑶</returns> public abstract List <CBXinyingSynPdProductsB2B> GetXinYingSynProductList(List <int> sysNos, ParaProductFilter productDetail);
/// <summary> /// 查询导出商品列表(信营) /// </summary> /// <param name="sysNos"></param> /// <returns></returns> public abstract List <CBOutputPdProductsLijia> GetXinYingExportProductListLiJia(List <int> sysNos, ParaProductFilter productDetail);
/// <summary> /// 查询导出商品列表(信营) /// </summary> /// <param name="sysNos"></param> /// <returns></returns> public abstract List <CBXinyingOutputPdProducts> GetXinYingExportProductList(List <int> sysNos, ParaProductFilter productDetail);
/// <summary> /// 查询导出商品列表 /// </summary> /// <param name="sysNos"></param> /// <returns></returns> /// <remarks>2015-12-30 王耀发 创建</remarks> public abstract List <CBOutputPdProductsByYD> GetExportProductListByYD(List <int> sysNos, ParaProductFilter productDetail);
/// <summary> /// 获取导出商品信息 /// </summary> /// <param name="sysNos">商品系统编号集合</param> /// <param name="productDetail">查询条件</param> /// <returns></returns> /// <remarks>2016-11-28 杨浩 创建</remarks> public abstract System.Data.DataTable GetExportProductToDataTable(List <int> sysNos, ParaProductFilter productDetail);
/// <summary> /// 获取商品详细信息列表 /// </summary> /// <param name="pager">商品详细信息查询列表</param> /// <param name="condition">动态条件,CBPdProductDetail里不包含的条件</param> /// <returns></returns> /// <remarks>2013-07-15 唐永勤 创建</remarks> public abstract void GetPdProductDetailList(ref Pager <CBPdProductDetail> pager, ParaProductFilter condition);
/// <summary> /// 获取商品详细信息列表 /// </summary> /// <param name="pager">商品详细信息查询列表</param> /// <param name="dealerMallSysNo">分销商商城系统编号</param> /// <param name="condition">动态条件,CBPdProductDetail里不包含的条件</param> /// <returns></returns> /// <remarks>2015-12-10 王耀发 创建</remarks> public override void GetDealerMallProductList(ref Pager <CBPdProductDetail> pager, int dealerMallSysNo, ParaProductFilter condition) { using (var _context = Context.UseSharedConnection(true)) { pager.Rows = _context.Select <CBPdProductDetail>(" pa.SysNo as PAssociationSysNo,p.SysNo,p.ErpCode,p.EasName,p.ProductType,pa.Status, c.categoryname as ProductCategoryName, c.sysno as ProductCategorySysno, price.Price as BasicPrice, price1.Price as SalesPrice") .From(@"DsProductAssociation pa left join PdProduct p on pa.HytProductSysNo = p.SysNo inner join (select productsysno from PdCategoryAssociation where (@ProductCategorySysno = 0 or categorysysno=@ProductCategorySysno) group by productsysno ) ca1 on ca1.productsysno = p.sysno left join (select productsysno,categorysysno from PdCategoryAssociation where IsMaster=@IsMaster) ca on ca.productsysno = p.sysno left join PdCategory c on ca.categorysysno = c.sysno left join (select * from PdPrice where PriceSource =@PriceSource and (@SourceSysno =0 or sourcesysno=@sourcesysno)) price on price.productsysno = p.sysno left join (select * from PdPrice where PriceSource =@PriceSource1 and (@SourceSysno =0 or sourcesysno=@sourcesysno)) price1 on price1.productsysno = p.sysno") .Where(@"(pa.DealerMallSysNo = @DealerMallSysNo) and (@Status = -1 or pa.Status=@Status) and (@name is null or (p.EasName like @name1 or p.ErpCode = @name)) and (@Sysno = 0 or p.Sysno=@Sysno) and (@ErpCode is null or p.ErpCode=@ErpCode) and (@StartTime is null or p.LastUpdateDate >= @StartTime) and (@EndTime is null or p.LastUpdateDate <= @EndTime) and (@CreateStartTime is null or p.CreatedDate >= @CreateStartTime) and (@CreateEndTime is null or p.CreatedDate <= @CreateEndTime) and (@CanFrontEndOrder = -1 or CanFrontEndOrder = @CanFrontEndOrder) ") .Parameter("ProductCategorySysno", condition.ProductCategorySysno) .Parameter("IsMaster", (int)ProductStatus.是否是主分类.是) .Parameter("PriceSource", (int)ProductStatus.产品价格来源.基础价格) .Parameter("PriceSource1", (int)ProductStatus.产品价格来源.会员等级价) .Parameter("SourceSysno", condition.PriceSourceSysNo) .Parameter("DealerMallSysNo", dealerMallSysNo) .Parameter("Status", condition.Status) .Parameter("name", condition.ProductName) .Parameter("name1", "%" + condition.ProductName + "%") .Parameter("Sysno", condition.SysNo) .Parameter("ErpCode", condition.ErpCode) .Parameter("StartTime", condition.StartTime) .Parameter("EndTime", (condition.EndTime == null) ? condition.EndTime : ((DateTime)condition.EndTime).AddDays(1)) .Parameter("CreateStartTime", condition.CreateStartTime) .Parameter("CreateEndTime", (condition.CreateEndTime == null) ? condition.CreateEndTime : ((DateTime)condition.CreateEndTime).AddDays(1)) .Parameter("CanFrontEndOrder", condition.CanFrontEndOrder) .OrderBy("pa.Status desc, pa.sysno desc ") .Paging(pager.CurrentPage, pager.PageSize) .QueryMany(); pager.TotalRows = _context.Select <int>("count(1)") .From(@"DsProductAssociation pa left join PdProduct p on pa.HytProductSysNo = p.SysNo inner join (select productsysno from PdCategoryAssociation where (@ProductCategorySysno = 0 or categorysysno=@ProductCategorySysno) group by productsysno ) ca1 on ca1.productsysno = p.sysno left join (select productsysno,categorysysno from PdCategoryAssociation where IsMaster=@IsMaster) ca on ca.productsysno = p.sysno left join PdCategory c on ca.categorysysno = c.sysno left join (select * from PdPrice where PriceSource =@PriceSource and (@SourceSysno =0 or sourcesysno=@sourcesysno)) price on price.productsysno = p.sysno left join (select * from PdPrice where PriceSource =@PriceSource1 and (@SourceSysno =0 or sourcesysno=@sourcesysno)) price1 on price1.productsysno = p.sysno") .Where(@"(pa.DealerMallSysNo = @DealerMallSysNo) and (@Status = -1 or pa.Status=@Status) and (@name is null or (p.EasName like @name1 or p.ErpCode = @name)) and (@Sysno = 0 or p.Sysno=@Sysno) and (@ErpCode is null or p.ErpCode=@ErpCode) and (@StartTime is null or p.LastUpdateDate >= @StartTime) and (@EndTime is null or p.LastUpdateDate <= @EndTime) and (@CreateStartTime is null or p.CreatedDate >= @CreateStartTime) and (@CreateEndTime is null or p.CreatedDate <= @CreateEndTime) and (@CanFrontEndOrder = -1 or CanFrontEndOrder = @CanFrontEndOrder) ") .Parameter("ProductCategorySysno", condition.ProductCategorySysno) .Parameter("IsMaster", (int)ProductStatus.是否是主分类.是) .Parameter("PriceSource", (int)ProductStatus.产品价格来源.基础价格) .Parameter("PriceSource1", (int)ProductStatus.产品价格来源.会员等级价) .Parameter("SourceSysno", condition.PriceSourceSysNo) .Parameter("DealerMallSysNo", dealerMallSysNo) .Parameter("Status", condition.Status) .Parameter("name", condition.ProductName) .Parameter("name1", "%" + condition.ProductName + "%") .Parameter("Sysno", condition.SysNo) .Parameter("ErpCode", condition.ErpCode) .Parameter("StartTime", condition.StartTime) .Parameter("EndTime", (condition.EndTime == null) ? condition.EndTime : ((DateTime)condition.EndTime).AddDays(1)) .Parameter("CreateStartTime", condition.CreateStartTime) .Parameter("CreateEndTime", (condition.CreateEndTime == null) ? condition.CreateEndTime : ((DateTime)condition.CreateEndTime).AddDays(1)) .Parameter("CanFrontEndOrder", condition.CanFrontEndOrder) .QuerySingle(); } }