时间: 2021-03-22 10:35:31,138 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: select cast('2021/03/18' as varchar(50)) as 发生日期, CAST('增加' AS VARCHAR(20)) as 操作类型,CAST('上期余额' AS VARCHAR(50)) as 单据类型 , cast('' as varCHAR(max)) as 对应单位 ,cast('' as varCHAR(max)) as 对应单位简称,cast('' as varCHAR(max)) as 单号,cast('' as varCHAR(max)) as 手工单号, cast('' as varCHAR(max)) as 备注,cast('' AS VARCHAR(50)) 销售类型,cast('' AS VARCHAR(50)) 零售订单号, cast('' AS VARCHAR(50)) 预售零售订单号,c.goods_no as 货号,goods.goods_name as 品名,CAST(c.colorid AS VARCHAR(20)) as 颜色, vGoodsColor.color as 颜色说明,CAST(c.long AS VARCHAR(20)) as 内长 , SUM(c.[S1]) AS [S1] , SUM(ISNULL(c.[S1], 0)) AS [数量] INTO ##243acfb843c845cfa127a731ed2501f4 from [Hcstock#20210318#Z007] c left join [goods] on c.goods_no = goods.goods_no left join vGoodsColor on c.Goods_No = vGoodsColor.Goods_No AND c.colorid = vGoodsColor.colorid where c.goods_no = '2023049' group by c.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long 时间: 2021-03-22 10:35:31,161 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##243acfb843c845cfa127a731ed2501f4 select convert(VARCHAR(20),a.Tin_date,120) as 发生日期, CAST('增加' AS VARCHAR(20)) as 操作类型, CAST('店铺收货' AS VARCHAR(20)) as 单据类型, CAST(a.fmwarehouse_no AS VARCHAR(50)) as 对应单位, CAST(w.Warehouse_Na AS VARCHAR(50)) AS 对应单位简称,a.ShopTinid as 单号, CAST(a.manual_id AS VARCHAR(50)) as 手工单号,cast(a.Remark as varchar(max)) as 备注,cast('' AS VARCHAR(50)) 销售类型, cast('' AS VARCHAR(50)) 零售订单号,cast('' AS VARCHAR(50)) 预售零售订单号,b.goods_no as 货号,goods.goods_name as 品名, CAST(c.colorid AS VARCHAR(20)) as 颜色,vGoodsColor.color as 颜色说明,CAST(c.long AS VARCHAR(20)) as 内长, SUM(c.[S1]) AS [S1] , SUM(ISNULL(c.[S1], 0)) AS [数量] from ShopTin as a left join ShopTingoods as b on a.ShopTinid=b.ShopTinid left join ShopTindetail as c on b.ShopTingoodsid=c.ShopTingoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Warehouse w ON w.Warehouse_No = a.fmwarehouse_no where a.type=1 and a.posted=1 and a.tinshop = 'Z007' and b.goods_No = '2023049' and a.tin_date > '2021/03/18' and a.tin_date < '2021/3/19 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long,a.fmwarehouse_no, w.Warehouse_Na,a.ShopTinid,a.manual_id,a.tin_date,cast(a.Remark as varchar(max)) 时间: 2021-03-22 10:35:31,175 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##243acfb843c845cfa127a731ed2501f4 select convert(VARCHAR(20),a.Tin_date,120) as 发生日期,'增加' as 操作类型,'店铺调入' as 单据类型,a.toutshop as 对应单位, co.Abbrev AS 对应单位简称,a.ShopTinid as 单号, a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号,goods.goods_name as 品名,c.colorid as 颜色, vGoodsColor.color as 颜色说明,c.long as 内长, SUM(c.[S1]) AS [S1] , SUM(ISNULL(c.[S1], 0)) AS [数量] from ShopTin as a left join ShopTingoods as b on a.ShopTinid=b.ShopTinid left join ShopTindetail as c on b.ShopTingoodsid=c.ShopTingoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Customer co ON co.Customer_ID = a.TOutShop where a.type=2 and a.posted=1 and a.tinshop = 'Z007' and b.goods_No = '2023049' and a.tin_date > '2021/03/18' and a.tin_date < '2021/3/19 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long,a.toutshop,co.Abbrev,a.ShopTinid,a.manual_id,a.tin_date,cast(a.Remark as varchar(max)) 时间: 2021-03-22 10:35:31,188 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##243acfb843c845cfa127a731ed2501f4 select convert(VARCHAR(20),a.Tin_date,120) as 发生日期,'增加' as 操作类型,'店铺采购收货' as 单据类型,a.supply_no as 对应单位, s.Supply_Abv AS 对应单位简称,a.ShopTinid as 单号, a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号,goods.goods_name as 品名,c.colorid as 颜色,vGoodsColor.color as 颜色说明, c.long as 内长, SUM(c.[S1]) AS [S1] , SUM(ISNULL(c.[S1], 0)) AS [数量] from ShopTin as a left join ShopTingoods as b on a.ShopTinid=b.ShopTinid left join ShopTindetail as c on b.ShopTingoodsid=c.ShopTingoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Supply s ON s.Supply_No = a.Supply_No where a.type=3 and a.posted=1 and a.tinshop = 'Z007' and b.goods_No = '2023049' and a.tin_date > '2021/03/18' and a.tin_date < '2021/3/19 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long, a.supply_no, s.Supply_Abv,a.ShopTinid,a.manual_id,a.tin_date,cast(a.Remark as varchar(max)) 时间: 2021-03-22 10:35:31,200 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##243acfb843c845cfa127a731ed2501f4 select convert(VARCHAR(20),a.return_date,120) as 发生日期,'减少' as 操作类型,'店铺退货' as 单据类型,a.warehouse_no as 对应单位, w.Warehouse_Na AS 对应单位简称,a.Dealereturnid as 单号,a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号, goods.goods_name as 品名,c.colorid as 颜色,vGoodsColor.color as 颜色说明,c.long as 内长, SUM(-c.[S1]) AS [S1], (-1)*SUM(ISNULL(c.[S1], 0)) AS [数量] from Dealereturn as a left join Dealereturngoods as b on a.Dealereturnid=b.Dealereturnid left join Dealereturndetail as c on b.Dealereturngoodsid=c.Dealereturngoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Warehouse w ON w.Warehouse_No = a.Warehouse_No where a.posted=1 AND (ISNULL(a.Type,'')='' OR a.Type=1) and a.customer_ID = 'Z007' and b.goods_No = '2023049' and a.return_date > '2021/03/18' and a.return_date < '2021/3/19 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long,a.warehouse_no,w.Warehouse_Na,a.Dealereturnid, a.manual_id,a.return_date,cast(a.Remark as varchar(max)) 时间: 2021-03-22 10:35:31,212 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##243acfb843c845cfa127a731ed2501f4 select convert(VARCHAR(20),a.return_date,120) as 发生日期,'减少' as 操作类型,'店铺采购退货' as 单据类型,a.supply_no as 对应单位, s.Supply_Abv AS 对应单位简称,a.Dealereturnid as 单号,a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号, goods.goods_name as 品名,c.colorid as 颜色,vGoodsColor.color as 颜色说明,c.long as 内长, SUM(-c.[S1]) AS [S1], (-1)*SUM(ISNULL(c.[S1], 0)) AS [数量] from Dealereturn as a left join Dealereturngoods as b on a.Dealereturnid=b.Dealereturnid left join Dealereturndetail as c on b.Dealereturngoodsid=c.Dealereturngoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Supply s ON s.Supply_No = a.Supply_No where a.posted=1 AND (a.Type=2) and a.customer_ID = 'Z007' and b.goods_No = '2023049' and a.return_date > '2021/03/18' and a.return_date < '2021/3/19 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long,a.supply_no,s.Supply_Abv,a.Dealereturnid,a.manual_id,a.return_date,cast(a.Remark as varchar(max)) 时间: 2021-03-22 10:35:31,224 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT CONVERT(VARCHAR(20),a.CheckDate,120) CheckDate ,'减少' HandleType,'店铺零售' DocType ,a.Customer_ID, ct.Abbrev,a.CheckID, a.Manual_ID,CAST(b.SaleTypeID AS VARCHAR) 销售类型,a.RetailOrderID 零售订单号,b.RetailOrderID 预售零售订单号,b.Status 销售状态,cast(a.Remark as varchar(max)) as 备注, b.Goods_No,goods.Goods_Name,c.ColorID,vGoodsColor.color,c.long, SUM(-c.[S1]) AS [S1], (-1)*SUM(ISNULL(c.[S1], 0)) AS [Quantity] into ##4e85e26a42744531984bbaab80c7e5b4 from [vn_Check] as a left join vn_checkgoods as b on a.checkid=b.checkid left join vn_checkdetail as c on b.checkgoodsid=c.checkgoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Customer ct ON ct.Customer_ID = a.Customer_ID where a.posted=1 AND NOT EXISTS(SELECT 1 FROM DictSaleType WHERE ID=ISNULL(b.SaleTypeID,0) AND IsAdjustStock=0) and a.customer_ID = 'Z007' and a.customer_id in (select customer_id from customer where mathod='自营' or mathod='专柜' or mathod='加盟' or mathod='代理') and b.goods_No = '2023049' and a.Checkdate > '2021/03/18' and a.Checkdate < '2021/3/19 0:00:00' group by b.Status,b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long, a.customer_id,ct.Abbrev,a.checkid,a.manual_id,a.checkdate, b.SaleTypeID,a.RetailOrderID,b.RetailOrderID ,cast(a.Remark as varchar(max)) 时间: 2021-03-22 10:35:31,251 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET A.零售订单号='' FROM ##4e85e26a42744531984bbaab80c7e5b4 A WHERE 销售状态='退货' AND EXISTS(SELECT 1 FROM KS2_RetailOrder WHERE RetailOrderID=A.零售订单号 AND ISNULL(SaleTypeID,0) IN (1,2)) 时间: 2021-03-22 10:35:31,255 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##243acfb843c845cfa127a731ed2501f4 SELECT CheckDate,HandleType,DocType ,Customer_ID, Abbrev,CheckID,Manual_ID,备注,销售类型,零售订单号,预售零售订单号,Goods_No,Goods_Name,ColorID,color,long, SUM(c.[S1]) AS [S1], sum(Quantity) FROM ##4e85e26a42744531984bbaab80c7e5b4 c GROUP BY CheckDate,HandleType,DocType ,Customer_ID, Abbrev,CheckID,Manual_ID,销售类型,零售订单号,预售零售订单号,备注,Goods_No,Goods_Name,ColorID,color,long 时间: 2021-03-22 10:35:31,260 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##243acfb843c845cfa127a731ed2501f4 select convert(VARCHAR(20),a.tout_date,120) as 发生日期,'减少' as 操作类型,'店铺调出' as 单据类型,a.tinshop as 对应单位, cti.Abbrev AS 对应单位简称,a.shoptoutid as 单号,a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号, goods.goods_name as 品名,c.colorid as 颜色,vGoodsColor.color as 颜色说明,c.long as 内长, SUM(-c.[S1]) AS [S1], (-1)*SUM(ISNULL(c.[S1], 0)) AS [数量] from shoptout as a left join shoptoutgoods as b on a.shoptoutid=b.shoptoutid left join shoptoutdetail as c on b.shoptoutgoodsid=c.shoptoutgoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Customer cti ON cti.Customer_ID = a.TinShop where a.posted=1 and a.toutshop = 'Z007' and b.goods_No = '2023049' and a.tout_date > '2021/03/18' and a.tout_date < '2021/3/19 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long, a.tinshop,cti.Abbrev,a.shoptoutid,a.manual_id,a.tout_date,cast(a.Remark as varchar(max)) 时间: 2021-03-22 10:35:31,272 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##243acfb843c845cfa127a731ed2501f4 select convert(VARCHAR(20),a.balance_date,120) as 发生日期,'减少' as 操作类型,'店铺损益' as 单据类型,a.customer_id as 对应单位, ct.Abbrev AS 对应单位简称, a.balanceid as 单号,a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号,goods.goods_name as 品名,c.colorid as 颜色, vGoodsColor.color as 颜色说明,c.long as 内长, SUM(-c.[S1]) AS [S1], (-1)*SUM(ISNULL(c.[S1], 0)) AS [数量] from balance as a left join balancegoods as b on a.balanceid=b.balanceid left join balancedetail as c on b.balancegoodsid=c.balancegoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Customer ct ON ct.Customer_ID = a.customer_id where a.posted=1 and a.type=2 and a.customer_ID = 'Z007' and b.goods_No = '2023049' and a.balance_date > '2021/03/18' and a.balance_date < '2021/3/19 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long,a.customer_id, ct.Abbrev,a.balanceid,a.manual_id,a.balance_date,cast(a.Remark as varchar(max)) 时间: 2021-03-22 10:35:31,284 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##243acfb843c845cfa127a731ed2501f4 SET 销售类型=ISNULL(销售类型,'') 时间: 2021-03-22 10:35:31,286 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.销售类型=b.SaleType FROM ##243acfb843c845cfa127a731ed2501f4 a INNER JOIN DictSaleType b ON a.销售类型=CAST(b.ID AS VARCHAR) WHERE a.单据类型 IN('店铺零售','加盟店铺零售') 时间: 2021-03-22 10:35:31,290 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##243acfb843c845cfa127a731ed2501f4 SET 销售类型='线上发货' WHERE 单据类型 IN('店铺零售','加盟店铺零售') AND 零售订单号 IS NOT NULL AND 零售订单号 <> '' 时间: 2021-03-22 10:35:31,292 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##243acfb843c845cfa127a731ed2501f4 SET 销售类型='正常销售' WHERE 单据类型 IN('店铺零售','加盟店铺零售') AND 销售类型 NOT IN ('预售自提','预售直发','线上发货') 时间: 2021-03-22 10:35:31,293 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: DELETE a FROM ##243acfb843c845cfa127a731ed2501f4 a WHERE 单据类型 IN('店铺零售','加盟店铺零售') AND a.销售类型 NOT IN('正常销售','预售直发','预售自提') 时间: 2021-03-22 10:35:31,294 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber ,A.* INTO tempdb.dbo.[8a8ecf8e-0660-491d-9e39-b3626f22622a] FROM ##243acfb843c845cfa127a731ed2501f4 A INNER JOIN Goods g ON a.货号 = g.Goods_No 时间: 2021-03-22 10:35:42,195 线程ID: 89 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: select cast('2021/03/18' as varchar(50)) as 发生日期, CAST('增加' AS VARCHAR(20)) as 操作类型,CAST('上期余额' AS VARCHAR(50)) as 单据类型 , cast('' as varCHAR(max)) as 对应单位 ,cast('' as varCHAR(max)) as 对应单位简称,cast('' as varCHAR(max)) as 单号,cast('' as varCHAR(max)) as 手工单号, cast('' as varCHAR(max)) as 备注,cast('' AS VARCHAR(50)) 销售类型,cast('' AS VARCHAR(50)) 零售订单号, cast('' AS VARCHAR(50)) 预售零售订单号,c.goods_no as 货号,goods.goods_name as 品名,CAST(c.colorid AS VARCHAR(20)) as 颜色, vGoodsColor.color as 颜色说明,CAST(c.long AS VARCHAR(20)) as 内长 , SUM(c.[S1]) AS [S1] , SUM(ISNULL(c.[S1], 0)) AS [数量] INTO ##152c54cbee42403da37351460d7b7ffb from [Hcstock#20210318#Z007] c left join [goods] on c.goods_no = goods.goods_no left join vGoodsColor on c.Goods_No = vGoodsColor.Goods_No AND c.colorid = vGoodsColor.colorid where c.goods_no = '2023049' group by c.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long 时间: 2021-03-22 10:35:42,204 线程ID: 89 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##152c54cbee42403da37351460d7b7ffb select convert(VARCHAR(20),a.Tin_date,120) as 发生日期, CAST('增加' AS VARCHAR(20)) as 操作类型, CAST('店铺收货' AS VARCHAR(20)) as 单据类型, CAST(a.fmwarehouse_no AS VARCHAR(50)) as 对应单位, CAST(w.Warehouse_Na AS VARCHAR(50)) AS 对应单位简称,a.ShopTinid as 单号, CAST(a.manual_id AS VARCHAR(50)) as 手工单号,cast(a.Remark as varchar(max)) as 备注,cast('' AS VARCHAR(50)) 销售类型, cast('' AS VARCHAR(50)) 零售订单号,cast('' AS VARCHAR(50)) 预售零售订单号,b.goods_no as 货号,goods.goods_name as 品名, CAST(c.colorid AS VARCHAR(20)) as 颜色,vGoodsColor.color as 颜色说明,CAST(c.long AS VARCHAR(20)) as 内长, SUM(c.[S1]) AS [S1] , SUM(ISNULL(c.[S1], 0)) AS [数量] from ShopTin as a left join ShopTingoods as b on a.ShopTinid=b.ShopTinid left join ShopTindetail as c on b.ShopTingoodsid=c.ShopTingoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Warehouse w ON w.Warehouse_No = a.fmwarehouse_no where a.type=1 and a.posted=1 and a.tinshop = 'Z007' and b.goods_No = '2023049' and a.tin_date > '2021/03/18' and a.tin_date < '2021/3/19 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long,a.fmwarehouse_no, w.Warehouse_Na,a.ShopTinid,a.manual_id,a.tin_date,cast(a.Remark as varchar(max)) 时间: 2021-03-22 10:35:42,216 线程ID: 89 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##152c54cbee42403da37351460d7b7ffb select convert(VARCHAR(20),a.Tin_date,120) as 发生日期,'增加' as 操作类型,'店铺调入' as 单据类型,a.toutshop as 对应单位, co.Abbrev AS 对应单位简称,a.ShopTinid as 单号, a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号,goods.goods_name as 品名,c.colorid as 颜色, vGoodsColor.color as 颜色说明,c.long as 内长, SUM(c.[S1]) AS [S1] , SUM(ISNULL(c.[S1], 0)) AS [数量] from ShopTin as a left join ShopTingoods as b on a.ShopTinid=b.ShopTinid left join ShopTindetail as c on b.ShopTingoodsid=c.ShopTingoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Customer co ON co.Customer_ID = a.TOutShop where a.type=2 and a.posted=1 and a.tinshop = 'Z007' and b.goods_No = '2023049' and a.tin_date > '2021/03/18' and a.tin_date < '2021/3/19 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long,a.toutshop,co.Abbrev,a.ShopTinid,a.manual_id,a.tin_date,cast(a.Remark as varchar(max)) 时间: 2021-03-22 10:35:42,228 线程ID: 89 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##152c54cbee42403da37351460d7b7ffb select convert(VARCHAR(20),a.Tin_date,120) as 发生日期,'增加' as 操作类型,'店铺采购收货' as 单据类型,a.supply_no as 对应单位, s.Supply_Abv AS 对应单位简称,a.ShopTinid as 单号, a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号,goods.goods_name as 品名,c.colorid as 颜色,vGoodsColor.color as 颜色说明, c.long as 内长, SUM(c.[S1]) AS [S1] , SUM(ISNULL(c.[S1], 0)) AS [数量] from ShopTin as a left join ShopTingoods as b on a.ShopTinid=b.ShopTinid left join ShopTindetail as c on b.ShopTingoodsid=c.ShopTingoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Supply s ON s.Supply_No = a.Supply_No where a.type=3 and a.posted=1 and a.tinshop = 'Z007' and b.goods_No = '2023049' and a.tin_date > '2021/03/18' and a.tin_date < '2021/3/19 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long, a.supply_no, s.Supply_Abv,a.ShopTinid,a.manual_id,a.tin_date,cast(a.Remark as varchar(max)) 时间: 2021-03-22 10:35:42,240 线程ID: 89 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##152c54cbee42403da37351460d7b7ffb select convert(VARCHAR(20),a.return_date,120) as 发生日期,'减少' as 操作类型,'店铺退货' as 单据类型,a.warehouse_no as 对应单位, w.Warehouse_Na AS 对应单位简称,a.Dealereturnid as 单号,a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号, goods.goods_name as 品名,c.colorid as 颜色,vGoodsColor.color as 颜色说明,c.long as 内长, SUM(-c.[S1]) AS [S1], (-1)*SUM(ISNULL(c.[S1], 0)) AS [数量] from Dealereturn as a left join Dealereturngoods as b on a.Dealereturnid=b.Dealereturnid left join Dealereturndetail as c on b.Dealereturngoodsid=c.Dealereturngoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Warehouse w ON w.Warehouse_No = a.Warehouse_No where a.posted=1 AND (ISNULL(a.Type,'')='' OR a.Type=1) and a.customer_ID = 'Z007' and b.goods_No = '2023049' and a.return_date > '2021/03/18' and a.return_date < '2021/3/19 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long,a.warehouse_no,w.Warehouse_Na,a.Dealereturnid, a.manual_id,a.return_date,cast(a.Remark as varchar(max)) 时间: 2021-03-22 10:35:42,253 线程ID: 89 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##152c54cbee42403da37351460d7b7ffb select convert(VARCHAR(20),a.return_date,120) as 发生日期,'减少' as 操作类型,'店铺采购退货' as 单据类型,a.supply_no as 对应单位, s.Supply_Abv AS 对应单位简称,a.Dealereturnid as 单号,a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号, goods.goods_name as 品名,c.colorid as 颜色,vGoodsColor.color as 颜色说明,c.long as 内长, SUM(-c.[S1]) AS [S1], (-1)*SUM(ISNULL(c.[S1], 0)) AS [数量] from Dealereturn as a left join Dealereturngoods as b on a.Dealereturnid=b.Dealereturnid left join Dealereturndetail as c on b.Dealereturngoodsid=c.Dealereturngoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Supply s ON s.Supply_No = a.Supply_No where a.posted=1 AND (a.Type=2) and a.customer_ID = 'Z007' and b.goods_No = '2023049' and a.return_date > '2021/03/18' and a.return_date < '2021/3/19 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long,a.supply_no,s.Supply_Abv,a.Dealereturnid,a.manual_id,a.return_date,cast(a.Remark as varchar(max)) 时间: 2021-03-22 10:35:42,263 线程ID: 89 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT CONVERT(VARCHAR(20),a.CheckDate,120) CheckDate ,'减少' HandleType,'店铺零售' DocType ,a.Customer_ID, ct.Abbrev,a.CheckID, a.Manual_ID,CAST(b.SaleTypeID AS VARCHAR) 销售类型,a.RetailOrderID 零售订单号,b.RetailOrderID 预售零售订单号,b.Status 销售状态,cast(a.Remark as varchar(max)) as 备注, b.Goods_No,goods.Goods_Name,c.ColorID,vGoodsColor.color,c.long, SUM(-c.[S1]) AS [S1], (-1)*SUM(ISNULL(c.[S1], 0)) AS [Quantity] into ##474521bcaa834d1584f1c734abf1cc98 from [vn_Check] as a left join vn_checkgoods as b on a.checkid=b.checkid left join vn_checkdetail as c on b.checkgoodsid=c.checkgoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Customer ct ON ct.Customer_ID = a.Customer_ID where a.posted=1 AND NOT EXISTS(SELECT 1 FROM DictSaleType WHERE ID=ISNULL(b.SaleTypeID,0) AND IsAdjustStock=0) and a.customer_ID = 'Z007' and a.customer_id in (select customer_id from customer where mathod='自营' or mathod='专柜' or mathod='加盟' or mathod='代理') and b.goods_No = '2023049' and a.Checkdate > '2021/03/18' and a.Checkdate < '2021/3/19 0:00:00' group by b.Status,b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long, a.customer_id,ct.Abbrev,a.checkid,a.manual_id,a.checkdate, b.SaleTypeID,a.RetailOrderID,b.RetailOrderID ,cast(a.Remark as varchar(max)) 时间: 2021-03-22 10:35:42,287 线程ID: 89 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET A.零售订单号='' FROM ##474521bcaa834d1584f1c734abf1cc98 A WHERE 销售状态='退货' AND EXISTS(SELECT 1 FROM KS2_RetailOrder WHERE RetailOrderID=A.零售订单号 AND ISNULL(SaleTypeID,0) IN (1,2)) 时间: 2021-03-22 10:35:42,292 线程ID: 89 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##152c54cbee42403da37351460d7b7ffb SELECT CheckDate,HandleType,DocType ,Customer_ID, Abbrev,CheckID,Manual_ID,备注,销售类型,零售订单号,预售零售订单号,Goods_No,Goods_Name,ColorID,color,long, SUM(c.[S1]) AS [S1], sum(Quantity) FROM ##474521bcaa834d1584f1c734abf1cc98 c GROUP BY CheckDate,HandleType,DocType ,Customer_ID, Abbrev,CheckID,Manual_ID,销售类型,零售订单号,预售零售订单号,备注,Goods_No,Goods_Name,ColorID,color,long 时间: 2021-03-22 10:35:42,296 线程ID: 89 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##152c54cbee42403da37351460d7b7ffb select convert(VARCHAR(20),a.tout_date,120) as 发生日期,'减少' as 操作类型,'店铺调出' as 单据类型,a.tinshop as 对应单位, cti.Abbrev AS 对应单位简称,a.shoptoutid as 单号,a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号, goods.goods_name as 品名,c.colorid as 颜色,vGoodsColor.color as 颜色说明,c.long as 内长, SUM(-c.[S1]) AS [S1], (-1)*SUM(ISNULL(c.[S1], 0)) AS [数量] from shoptout as a left join shoptoutgoods as b on a.shoptoutid=b.shoptoutid left join shoptoutdetail as c on b.shoptoutgoodsid=c.shoptoutgoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Customer cti ON cti.Customer_ID = a.TinShop where a.posted=1 and a.toutshop = 'Z007' and b.goods_No = '2023049' and a.tout_date > '2021/03/18' and a.tout_date < '2021/3/19 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long, a.tinshop,cti.Abbrev,a.shoptoutid,a.manual_id,a.tout_date,cast(a.Remark as varchar(max)) 时间: 2021-03-22 10:35:42,309 线程ID: 89 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##152c54cbee42403da37351460d7b7ffb select convert(VARCHAR(20),a.balance_date,120) as 发生日期,'减少' as 操作类型,'店铺损益' as 单据类型,a.customer_id as 对应单位, ct.Abbrev AS 对应单位简称, a.balanceid as 单号,a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号,goods.goods_name as 品名,c.colorid as 颜色, vGoodsColor.color as 颜色说明,c.long as 内长, SUM(-c.[S1]) AS [S1], (-1)*SUM(ISNULL(c.[S1], 0)) AS [数量] from balance as a left join balancegoods as b on a.balanceid=b.balanceid left join balancedetail as c on b.balancegoodsid=c.balancegoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Customer ct ON ct.Customer_ID = a.customer_id where a.posted=1 and a.type=2 and a.customer_ID = 'Z007' and b.goods_No = '2023049' and a.balance_date > '2021/03/18' and a.balance_date < '2021/3/19 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long,a.customer_id, ct.Abbrev,a.balanceid,a.manual_id,a.balance_date,cast(a.Remark as varchar(max)) 时间: 2021-03-22 10:35:42,320 线程ID: 89 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##152c54cbee42403da37351460d7b7ffb SET 销售类型=ISNULL(销售类型,'') 时间: 2021-03-22 10:35:42,322 线程ID: 89 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.销售类型=b.SaleType FROM ##152c54cbee42403da37351460d7b7ffb a INNER JOIN DictSaleType b ON a.销售类型=CAST(b.ID AS VARCHAR) WHERE a.单据类型 IN('店铺零售','加盟店铺零售') 时间: 2021-03-22 10:35:42,327 线程ID: 89 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##152c54cbee42403da37351460d7b7ffb SET 销售类型='线上发货' WHERE 单据类型 IN('店铺零售','加盟店铺零售') AND 零售订单号 IS NOT NULL AND 零售订单号 <> '' 时间: 2021-03-22 10:35:42,329 线程ID: 89 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##152c54cbee42403da37351460d7b7ffb SET 销售类型='正常销售' WHERE 单据类型 IN('店铺零售','加盟店铺零售') AND 销售类型 NOT IN ('预售自提','预售直发','线上发货') 时间: 2021-03-22 10:35:42,330 线程ID: 89 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: DELETE a FROM ##152c54cbee42403da37351460d7b7ffb a WHERE 单据类型 IN('店铺零售','加盟店铺零售') AND a.销售类型 NOT IN('正常销售','预售直发','预售自提') 时间: 2021-03-22 10:35:42,332 线程ID: 89 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber ,A.* INTO tempdb.dbo.[8a8ecf8e-0660-491d-9e39-b3626f22622a] FROM ##152c54cbee42403da37351460d7b7ffb A INNER JOIN Goods g ON a.货号 = g.Goods_No 时间: 2021-03-22 10:35:50,553 线程ID: 12 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: select cast('2021/03/18' as varchar(50)) as 发生日期, CAST('增加' AS VARCHAR(20)) as 操作类型,CAST('上期余额' AS VARCHAR(50)) as 单据类型 , cast('' as varCHAR(max)) as 对应单位 ,cast('' as varCHAR(max)) as 对应单位简称,cast('' as varCHAR(max)) as 单号,cast('' as varCHAR(max)) as 手工单号, cast('' as varCHAR(max)) as 备注,cast('' AS VARCHAR(50)) 销售类型,cast('' AS VARCHAR(50)) 零售订单号, cast('' AS VARCHAR(50)) 预售零售订单号,c.goods_no as 货号,goods.goods_name as 品名,CAST(c.colorid AS VARCHAR(20)) as 颜色, vGoodsColor.color as 颜色说明,CAST(c.long AS VARCHAR(20)) as 内长 , SUM(c.[S1]) AS [S1] , SUM(ISNULL(c.[S1], 0)) AS [数量] INTO ##d5296f1f49e142d1920192b76051696a from [Hcstock#20210318#Z007] c left join [goods] on c.goods_no = goods.goods_no left join vGoodsColor on c.Goods_No = vGoodsColor.Goods_No AND c.colorid = vGoodsColor.colorid where c.goods_no = '2023049' group by c.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long 时间: 2021-03-22 10:35:50,563 线程ID: 12 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##d5296f1f49e142d1920192b76051696a select convert(VARCHAR(20),a.Tin_date,120) as 发生日期, CAST('增加' AS VARCHAR(20)) as 操作类型, CAST('店铺收货' AS VARCHAR(20)) as 单据类型, CAST(a.fmwarehouse_no AS VARCHAR(50)) as 对应单位, CAST(w.Warehouse_Na AS VARCHAR(50)) AS 对应单位简称,a.ShopTinid as 单号, CAST(a.manual_id AS VARCHAR(50)) as 手工单号,cast(a.Remark as varchar(max)) as 备注,cast('' AS VARCHAR(50)) 销售类型, cast('' AS VARCHAR(50)) 零售订单号,cast('' AS VARCHAR(50)) 预售零售订单号,b.goods_no as 货号,goods.goods_name as 品名, CAST(c.colorid AS VARCHAR(20)) as 颜色,vGoodsColor.color as 颜色说明,CAST(c.long AS VARCHAR(20)) as 内长, SUM(c.[S1]) AS [S1] , SUM(ISNULL(c.[S1], 0)) AS [数量] from ShopTin as a left join ShopTingoods as b on a.ShopTinid=b.ShopTinid left join ShopTindetail as c on b.ShopTingoodsid=c.ShopTingoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Warehouse w ON w.Warehouse_No = a.fmwarehouse_no where a.type=1 and a.posted=1 and a.tinshop = 'Z007' and b.goods_No = '2023049' and a.tin_date > '2021/03/18' and a.tin_date < '2021/3/19 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long,a.fmwarehouse_no, w.Warehouse_Na,a.ShopTinid,a.manual_id,a.tin_date,cast(a.Remark as varchar(max)) 时间: 2021-03-22 10:35:50,575 线程ID: 12 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##d5296f1f49e142d1920192b76051696a select convert(VARCHAR(20),a.Tin_date,120) as 发生日期,'增加' as 操作类型,'店铺调入' as 单据类型,a.toutshop as 对应单位, co.Abbrev AS 对应单位简称,a.ShopTinid as 单号, a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号,goods.goods_name as 品名,c.colorid as 颜色, vGoodsColor.color as 颜色说明,c.long as 内长, SUM(c.[S1]) AS [S1] , SUM(ISNULL(c.[S1], 0)) AS [数量] from ShopTin as a left join ShopTingoods as b on a.ShopTinid=b.ShopTinid left join ShopTindetail as c on b.ShopTingoodsid=c.ShopTingoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Customer co ON co.Customer_ID = a.TOutShop where a.type=2 and a.posted=1 and a.tinshop = 'Z007' and b.goods_No = '2023049' and a.tin_date > '2021/03/18' and a.tin_date < '2021/3/19 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long,a.toutshop,co.Abbrev,a.ShopTinid,a.manual_id,a.tin_date,cast(a.Remark as varchar(max)) 时间: 2021-03-22 10:35:50,586 线程ID: 12 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##d5296f1f49e142d1920192b76051696a select convert(VARCHAR(20),a.Tin_date,120) as 发生日期,'增加' as 操作类型,'店铺采购收货' as 单据类型,a.supply_no as 对应单位, s.Supply_Abv AS 对应单位简称,a.ShopTinid as 单号, a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号,goods.goods_name as 品名,c.colorid as 颜色,vGoodsColor.color as 颜色说明, c.long as 内长, SUM(c.[S1]) AS [S1] , SUM(ISNULL(c.[S1], 0)) AS [数量] from ShopTin as a left join ShopTingoods as b on a.ShopTinid=b.ShopTinid left join ShopTindetail as c on b.ShopTingoodsid=c.ShopTingoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Supply s ON s.Supply_No = a.Supply_No where a.type=3 and a.posted=1 and a.tinshop = 'Z007' and b.goods_No = '2023049' and a.tin_date > '2021/03/18' and a.tin_date < '2021/3/19 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long, a.supply_no, s.Supply_Abv,a.ShopTinid,a.manual_id,a.tin_date,cast(a.Remark as varchar(max)) 时间: 2021-03-22 10:35:50,601 线程ID: 12 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##d5296f1f49e142d1920192b76051696a select convert(VARCHAR(20),a.return_date,120) as 发生日期,'减少' as 操作类型,'店铺退货' as 单据类型,a.warehouse_no as 对应单位, w.Warehouse_Na AS 对应单位简称,a.Dealereturnid as 单号,a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号, goods.goods_name as 品名,c.colorid as 颜色,vGoodsColor.color as 颜色说明,c.long as 内长, SUM(-c.[S1]) AS [S1], (-1)*SUM(ISNULL(c.[S1], 0)) AS [数量] from Dealereturn as a left join Dealereturngoods as b on a.Dealereturnid=b.Dealereturnid left join Dealereturndetail as c on b.Dealereturngoodsid=c.Dealereturngoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Warehouse w ON w.Warehouse_No = a.Warehouse_No where a.posted=1 AND (ISNULL(a.Type,'')='' OR a.Type=1) and a.customer_ID = 'Z007' and b.goods_No = '2023049' and a.return_date > '2021/03/18' and a.return_date < '2021/3/19 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long,a.warehouse_no,w.Warehouse_Na,a.Dealereturnid, a.manual_id,a.return_date,cast(a.Remark as varchar(max)) 时间: 2021-03-22 10:35:50,612 线程ID: 12 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##d5296f1f49e142d1920192b76051696a select convert(VARCHAR(20),a.return_date,120) as 发生日期,'减少' as 操作类型,'店铺采购退货' as 单据类型,a.supply_no as 对应单位, s.Supply_Abv AS 对应单位简称,a.Dealereturnid as 单号,a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号, goods.goods_name as 品名,c.colorid as 颜色,vGoodsColor.color as 颜色说明,c.long as 内长, SUM(-c.[S1]) AS [S1], (-1)*SUM(ISNULL(c.[S1], 0)) AS [数量] from Dealereturn as a left join Dealereturngoods as b on a.Dealereturnid=b.Dealereturnid left join Dealereturndetail as c on b.Dealereturngoodsid=c.Dealereturngoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Supply s ON s.Supply_No = a.Supply_No where a.posted=1 AND (a.Type=2) and a.customer_ID = 'Z007' and b.goods_No = '2023049' and a.return_date > '2021/03/18' and a.return_date < '2021/3/19 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long,a.supply_no,s.Supply_Abv,a.Dealereturnid,a.manual_id,a.return_date,cast(a.Remark as varchar(max)) 时间: 2021-03-22 10:35:50,623 线程ID: 12 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT CONVERT(VARCHAR(20),a.CheckDate,120) CheckDate ,'减少' HandleType,'店铺零售' DocType ,a.Customer_ID, ct.Abbrev,a.CheckID, a.Manual_ID,CAST(b.SaleTypeID AS VARCHAR) 销售类型,a.RetailOrderID 零售订单号,b.RetailOrderID 预售零售订单号,b.Status 销售状态,cast(a.Remark as varchar(max)) as 备注, b.Goods_No,goods.Goods_Name,c.ColorID,vGoodsColor.color,c.long, SUM(-c.[S1]) AS [S1], (-1)*SUM(ISNULL(c.[S1], 0)) AS [Quantity] into ##c296f8c4fec44509861c91f507679add from [vn_Check] as a left join vn_checkgoods as b on a.checkid=b.checkid left join vn_checkdetail as c on b.checkgoodsid=c.checkgoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Customer ct ON ct.Customer_ID = a.Customer_ID where a.posted=1 AND NOT EXISTS(SELECT 1 FROM DictSaleType WHERE ID=ISNULL(b.SaleTypeID,0) AND IsAdjustStock=0) and a.customer_ID = 'Z007' and a.customer_id in (select customer_id from customer where mathod='自营' or mathod='专柜' or mathod='加盟' or mathod='代理') and b.goods_No = '2023049' and a.Checkdate > '2021/03/18' and a.Checkdate < '2021/3/19 0:00:00' group by b.Status,b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long, a.customer_id,ct.Abbrev,a.checkid,a.manual_id,a.checkdate, b.SaleTypeID,a.RetailOrderID,b.RetailOrderID ,cast(a.Remark as varchar(max)) 时间: 2021-03-22 10:35:50,646 线程ID: 12 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET A.零售订单号='' FROM ##c296f8c4fec44509861c91f507679add A WHERE 销售状态='退货' AND EXISTS(SELECT 1 FROM KS2_RetailOrder WHERE RetailOrderID=A.零售订单号 AND ISNULL(SaleTypeID,0) IN (1,2)) 时间: 2021-03-22 10:35:50,651 线程ID: 12 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##d5296f1f49e142d1920192b76051696a SELECT CheckDate,HandleType,DocType ,Customer_ID, Abbrev,CheckID,Manual_ID,备注,销售类型,零售订单号,预售零售订单号,Goods_No,Goods_Name,ColorID,color,long, SUM(c.[S1]) AS [S1], sum(Quantity) FROM ##c296f8c4fec44509861c91f507679add c GROUP BY CheckDate,HandleType,DocType ,Customer_ID, Abbrev,CheckID,Manual_ID,销售类型,零售订单号,预售零售订单号,备注,Goods_No,Goods_Name,ColorID,color,long 时间: 2021-03-22 10:35:50,655 线程ID: 12 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##d5296f1f49e142d1920192b76051696a select convert(VARCHAR(20),a.tout_date,120) as 发生日期,'减少' as 操作类型,'店铺调出' as 单据类型,a.tinshop as 对应单位, cti.Abbrev AS 对应单位简称,a.shoptoutid as 单号,a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号, goods.goods_name as 品名,c.colorid as 颜色,vGoodsColor.color as 颜色说明,c.long as 内长, SUM(-c.[S1]) AS [S1], (-1)*SUM(ISNULL(c.[S1], 0)) AS [数量] from shoptout as a left join shoptoutgoods as b on a.shoptoutid=b.shoptoutid left join shoptoutdetail as c on b.shoptoutgoodsid=c.shoptoutgoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Customer cti ON cti.Customer_ID = a.TinShop where a.posted=1 and a.toutshop = 'Z007' and b.goods_No = '2023049' and a.tout_date > '2021/03/18' and a.tout_date < '2021/3/19 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long, a.tinshop,cti.Abbrev,a.shoptoutid,a.manual_id,a.tout_date,cast(a.Remark as varchar(max)) 时间: 2021-03-22 10:35:50,669 线程ID: 12 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##d5296f1f49e142d1920192b76051696a select convert(VARCHAR(20),a.balance_date,120) as 发生日期,'减少' as 操作类型,'店铺损益' as 单据类型,a.customer_id as 对应单位, ct.Abbrev AS 对应单位简称, a.balanceid as 单号,a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号,goods.goods_name as 品名,c.colorid as 颜色, vGoodsColor.color as 颜色说明,c.long as 内长, SUM(-c.[S1]) AS [S1], (-1)*SUM(ISNULL(c.[S1], 0)) AS [数量] from balance as a left join balancegoods as b on a.balanceid=b.balanceid left join balancedetail as c on b.balancegoodsid=c.balancegoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Customer ct ON ct.Customer_ID = a.customer_id where a.posted=1 and a.type=2 and a.customer_ID = 'Z007' and b.goods_No = '2023049' and a.balance_date > '2021/03/18' and a.balance_date < '2021/3/19 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long,a.customer_id, ct.Abbrev,a.balanceid,a.manual_id,a.balance_date,cast(a.Remark as varchar(max)) 时间: 2021-03-22 10:35:50,680 线程ID: 12 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##d5296f1f49e142d1920192b76051696a SET 销售类型=ISNULL(销售类型,'') 时间: 2021-03-22 10:35:50,682 线程ID: 12 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.销售类型=b.SaleType FROM ##d5296f1f49e142d1920192b76051696a a INNER JOIN DictSaleType b ON a.销售类型=CAST(b.ID AS VARCHAR) WHERE a.单据类型 IN('店铺零售','加盟店铺零售') 时间: 2021-03-22 10:35:50,686 线程ID: 12 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##d5296f1f49e142d1920192b76051696a SET 销售类型='线上发货' WHERE 单据类型 IN('店铺零售','加盟店铺零售') AND 零售订单号 IS NOT NULL AND 零售订单号 <> '' 时间: 2021-03-22 10:35:50,689 线程ID: 12 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##d5296f1f49e142d1920192b76051696a SET 销售类型='正常销售' WHERE 单据类型 IN('店铺零售','加盟店铺零售') AND 销售类型 NOT IN ('预售自提','预售直发','线上发货') 时间: 2021-03-22 10:35:50,690 线程ID: 12 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: DELETE a FROM ##d5296f1f49e142d1920192b76051696a a WHERE 单据类型 IN('店铺零售','加盟店铺零售') AND a.销售类型 NOT IN('正常销售','预售直发','预售自提') 时间: 2021-03-22 10:35:50,691 线程ID: 12 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber ,A.* INTO tempdb.dbo.[8a8ecf8e-0660-491d-9e39-b3626f22622a] FROM ##d5296f1f49e142d1920192b76051696a A INNER JOIN Goods g ON a.货号 = g.Goods_No 时间: 2021-03-22 10:36:34,434 线程ID: 9 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: select top 0 cast('' as varchar(50)) as 发生日期, CAST('' AS VARCHAR(20)) as 操作类型,CAST('' AS VARCHAR(50)) as 单据类型 , cast('' as varCHAR(max)) as 对应单位 ,cast('' as varCHAR(max)) as 对应单位简称,cast('' as varCHAR(max)) as 单号,cast('' as varCHAR(max)) as 手工单号, cast('' as varCHAR(max)) as 备注,cast('' AS VARCHAR(50)) 销售类型,cast('' AS VARCHAR(50)) 零售订单号, cast('' AS VARCHAR(50)) 预售零售订单号,cast('' AS VARCHAR(50)) 货号,cast('' AS VARCHAR(50)) 品名,CAST('' AS VARCHAR(20)) as 颜色, cast('' AS VARCHAR(50)) as 颜色说明,CAST('' AS VARCHAR(20)) as 内长 , CAST(0 AS INT) AS [S1] , CAST('' AS INT) AS 数量 INTO ##32af41622d9b4e868739530a8e59872c from Goods 时间: 2021-03-22 10:36:34,437 线程ID: 9 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##32af41622d9b4e868739530a8e59872c select convert(VARCHAR(20),a.Tin_date,120) as 发生日期, CAST('增加' AS VARCHAR(20)) as 操作类型, CAST('店铺收货' AS VARCHAR(20)) as 单据类型, CAST(a.fmwarehouse_no AS VARCHAR(50)) as 对应单位, CAST(w.Warehouse_Na AS VARCHAR(50)) AS 对应单位简称,a.ShopTinid as 单号, CAST(a.manual_id AS VARCHAR(50)) as 手工单号,cast(a.Remark as varchar(max)) as 备注,cast('' AS VARCHAR(50)) 销售类型, cast('' AS VARCHAR(50)) 零售订单号,cast('' AS VARCHAR(50)) 预售零售订单号,b.goods_no as 货号,goods.goods_name as 品名, CAST(c.colorid AS VARCHAR(20)) as 颜色,vGoodsColor.color as 颜色说明,CAST(c.long AS VARCHAR(20)) as 内长, SUM(c.[S1]) AS [S1] , SUM(ISNULL(c.[S1], 0)) AS [数量] from ShopTin as a left join ShopTingoods as b on a.ShopTinid=b.ShopTinid left join ShopTindetail as c on b.ShopTingoodsid=c.ShopTingoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Warehouse w ON w.Warehouse_No = a.fmwarehouse_no where a.type=1 and a.posted=1 and a.tinshop = 'Z007' and b.goods_No = '[货号:2023049]' and a.tin_date < '2021/3/23 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long,a.fmwarehouse_no, w.Warehouse_Na,a.ShopTinid,a.manual_id,a.tin_date,cast(a.Remark as varchar(max)) 时间: 2021-03-22 10:36:34,449 线程ID: 9 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##32af41622d9b4e868739530a8e59872c select convert(VARCHAR(20),a.Tin_date,120) as 发生日期,'增加' as 操作类型,'店铺调入' as 单据类型,a.toutshop as 对应单位, co.Abbrev AS 对应单位简称,a.ShopTinid as 单号, a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号,goods.goods_name as 品名,c.colorid as 颜色, vGoodsColor.color as 颜色说明,c.long as 内长, SUM(c.[S1]) AS [S1] , SUM(ISNULL(c.[S1], 0)) AS [数量] from ShopTin as a left join ShopTingoods as b on a.ShopTinid=b.ShopTinid left join ShopTindetail as c on b.ShopTingoodsid=c.ShopTingoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Customer co ON co.Customer_ID = a.TOutShop where a.type=2 and a.posted=1 and a.tinshop = 'Z007' and b.goods_No = '[货号:2023049]' and a.tin_date < '2021/3/23 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long,a.toutshop,co.Abbrev,a.ShopTinid,a.manual_id,a.tin_date,cast(a.Remark as varchar(max)) 时间: 2021-03-22 10:36:34,464 线程ID: 9 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##32af41622d9b4e868739530a8e59872c select convert(VARCHAR(20),a.Tin_date,120) as 发生日期,'增加' as 操作类型,'店铺采购收货' as 单据类型,a.supply_no as 对应单位, s.Supply_Abv AS 对应单位简称,a.ShopTinid as 单号, a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号,goods.goods_name as 品名,c.colorid as 颜色,vGoodsColor.color as 颜色说明, c.long as 内长, SUM(c.[S1]) AS [S1] , SUM(ISNULL(c.[S1], 0)) AS [数量] from ShopTin as a left join ShopTingoods as b on a.ShopTinid=b.ShopTinid left join ShopTindetail as c on b.ShopTingoodsid=c.ShopTingoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Supply s ON s.Supply_No = a.Supply_No where a.type=3 and a.posted=1 and a.tinshop = 'Z007' and b.goods_No = '[货号:2023049]' and a.tin_date < '2021/3/23 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long, a.supply_no, s.Supply_Abv,a.ShopTinid,a.manual_id,a.tin_date,cast(a.Remark as varchar(max)) 时间: 2021-03-22 10:36:34,476 线程ID: 9 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##32af41622d9b4e868739530a8e59872c select convert(VARCHAR(20),a.return_date,120) as 发生日期,'减少' as 操作类型,'店铺退货' as 单据类型,a.warehouse_no as 对应单位, w.Warehouse_Na AS 对应单位简称,a.Dealereturnid as 单号,a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号, goods.goods_name as 品名,c.colorid as 颜色,vGoodsColor.color as 颜色说明,c.long as 内长, SUM(-c.[S1]) AS [S1], (-1)*SUM(ISNULL(c.[S1], 0)) AS [数量] from Dealereturn as a left join Dealereturngoods as b on a.Dealereturnid=b.Dealereturnid left join Dealereturndetail as c on b.Dealereturngoodsid=c.Dealereturngoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Warehouse w ON w.Warehouse_No = a.Warehouse_No where a.posted=1 AND (ISNULL(a.Type,'')='' OR a.Type=1) and a.customer_ID = 'Z007' and b.goods_No = '[货号:2023049]' and a.return_date < '2021/3/23 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long,a.warehouse_no,w.Warehouse_Na,a.Dealereturnid, a.manual_id,a.return_date,cast(a.Remark as varchar(max)) 时间: 2021-03-22 10:36:34,488 线程ID: 9 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##32af41622d9b4e868739530a8e59872c select convert(VARCHAR(20),a.return_date,120) as 发生日期,'减少' as 操作类型,'店铺采购退货' as 单据类型,a.supply_no as 对应单位, s.Supply_Abv AS 对应单位简称,a.Dealereturnid as 单号,a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号, goods.goods_name as 品名,c.colorid as 颜色,vGoodsColor.color as 颜色说明,c.long as 内长, SUM(-c.[S1]) AS [S1], (-1)*SUM(ISNULL(c.[S1], 0)) AS [数量] from Dealereturn as a left join Dealereturngoods as b on a.Dealereturnid=b.Dealereturnid left join Dealereturndetail as c on b.Dealereturngoodsid=c.Dealereturngoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Supply s ON s.Supply_No = a.Supply_No where a.posted=1 AND (a.Type=2) and a.customer_ID = 'Z007' and b.goods_No = '[货号:2023049]' and a.return_date < '2021/3/23 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long,a.supply_no,s.Supply_Abv,a.Dealereturnid,a.manual_id,a.return_date,cast(a.Remark as varchar(max)) 时间: 2021-03-22 10:36:34,499 线程ID: 9 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT CONVERT(VARCHAR(20),a.CheckDate,120) CheckDate ,'减少' HandleType,'店铺零售' DocType ,a.Customer_ID, ct.Abbrev,a.CheckID, a.Manual_ID,CAST(b.SaleTypeID AS VARCHAR) 销售类型,a.RetailOrderID 零售订单号,b.RetailOrderID 预售零售订单号,b.Status 销售状态,cast(a.Remark as varchar(max)) as 备注, b.Goods_No,goods.Goods_Name,c.ColorID,vGoodsColor.color,c.long, SUM(-c.[S1]) AS [S1], (-1)*SUM(ISNULL(c.[S1], 0)) AS [Quantity] into ##e5368efffcfd4839ad6e7bd994d3c8ab from [vn_Check] as a left join vn_checkgoods as b on a.checkid=b.checkid left join vn_checkdetail as c on b.checkgoodsid=c.checkgoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Customer ct ON ct.Customer_ID = a.Customer_ID where a.posted=1 AND NOT EXISTS(SELECT 1 FROM DictSaleType WHERE ID=ISNULL(b.SaleTypeID,0) AND IsAdjustStock=0) and a.customer_ID = 'Z007' and a.customer_id in (select customer_id from customer where mathod='自营' or mathod='专柜' or mathod='加盟' or mathod='代理') and b.goods_No = '[货号:2023049]' and a.Checkdate < '2021/3/23 0:00:00' group by b.Status,b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long, a.customer_id,ct.Abbrev,a.checkid,a.manual_id,a.checkdate, b.SaleTypeID,a.RetailOrderID,b.RetailOrderID ,cast(a.Remark as varchar(max)) 时间: 2021-03-22 10:36:34,524 线程ID: 9 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET A.零售订单号='' FROM ##e5368efffcfd4839ad6e7bd994d3c8ab A WHERE 销售状态='退货' AND EXISTS(SELECT 1 FROM KS2_RetailOrder WHERE RetailOrderID=A.零售订单号 AND ISNULL(SaleTypeID,0) IN (1,2)) 时间: 2021-03-22 10:36:34,528 线程ID: 9 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##32af41622d9b4e868739530a8e59872c SELECT CheckDate,HandleType,DocType ,Customer_ID, Abbrev,CheckID,Manual_ID,备注,销售类型,零售订单号,预售零售订单号,Goods_No,Goods_Name,ColorID,color,long, SUM(c.[S1]) AS [S1], sum(Quantity) FROM ##e5368efffcfd4839ad6e7bd994d3c8ab c GROUP BY CheckDate,HandleType,DocType ,Customer_ID, Abbrev,CheckID,Manual_ID,销售类型,零售订单号,预售零售订单号,备注,Goods_No,Goods_Name,ColorID,color,long 时间: 2021-03-22 10:36:34,532 线程ID: 9 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##32af41622d9b4e868739530a8e59872c select convert(VARCHAR(20),a.tout_date,120) as 发生日期,'减少' as 操作类型,'店铺调出' as 单据类型,a.tinshop as 对应单位, cti.Abbrev AS 对应单位简称,a.shoptoutid as 单号,a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号, goods.goods_name as 品名,c.colorid as 颜色,vGoodsColor.color as 颜色说明,c.long as 内长, SUM(-c.[S1]) AS [S1], (-1)*SUM(ISNULL(c.[S1], 0)) AS [数量] from shoptout as a left join shoptoutgoods as b on a.shoptoutid=b.shoptoutid left join shoptoutdetail as c on b.shoptoutgoodsid=c.shoptoutgoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Customer cti ON cti.Customer_ID = a.TinShop where a.posted=1 and a.toutshop = 'Z007' and b.goods_No = '[货号:2023049]' and a.tout_date < '2021/3/23 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long, a.tinshop,cti.Abbrev,a.shoptoutid,a.manual_id,a.tout_date,cast(a.Remark as varchar(max)) 时间: 2021-03-22 10:36:34,545 线程ID: 9 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##32af41622d9b4e868739530a8e59872c select convert(VARCHAR(20),a.balance_date,120) as 发生日期,'减少' as 操作类型,'店铺损益' as 单据类型,a.customer_id as 对应单位, ct.Abbrev AS 对应单位简称, a.balanceid as 单号,a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号,goods.goods_name as 品名,c.colorid as 颜色, vGoodsColor.color as 颜色说明,c.long as 内长, SUM(-c.[S1]) AS [S1], (-1)*SUM(ISNULL(c.[S1], 0)) AS [数量] from balance as a left join balancegoods as b on a.balanceid=b.balanceid left join balancedetail as c on b.balancegoodsid=c.balancegoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Customer ct ON ct.Customer_ID = a.customer_id where a.posted=1 and a.type=2 and a.customer_ID = 'Z007' and b.goods_No = '[货号:2023049]' and a.balance_date < '2021/3/23 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long,a.customer_id, ct.Abbrev,a.balanceid,a.manual_id,a.balance_date,cast(a.Remark as varchar(max)) 时间: 2021-03-22 10:36:34,557 线程ID: 9 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##32af41622d9b4e868739530a8e59872c SET 销售类型=ISNULL(销售类型,'') 时间: 2021-03-22 10:36:34,559 线程ID: 9 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.销售类型=b.SaleType FROM ##32af41622d9b4e868739530a8e59872c a INNER JOIN DictSaleType b ON a.销售类型=CAST(b.ID AS VARCHAR) WHERE a.单据类型 IN('店铺零售','加盟店铺零售') 时间: 2021-03-22 10:36:34,563 线程ID: 9 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##32af41622d9b4e868739530a8e59872c SET 销售类型='线上发货' WHERE 单据类型 IN('店铺零售','加盟店铺零售') AND 零售订单号 IS NOT NULL AND 零售订单号 <> '' 时间: 2021-03-22 10:36:34,564 线程ID: 9 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##32af41622d9b4e868739530a8e59872c SET 销售类型='正常销售' WHERE 单据类型 IN('店铺零售','加盟店铺零售') AND 销售类型 NOT IN ('预售自提','预售直发','线上发货') 时间: 2021-03-22 10:36:34,566 线程ID: 9 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: DELETE a FROM ##32af41622d9b4e868739530a8e59872c a WHERE 单据类型 IN('店铺零售','加盟店铺零售') AND a.销售类型 NOT IN('正常销售','预售直发','预售自提') 时间: 2021-03-22 10:36:34,567 线程ID: 9 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber ,A.* INTO tempdb.dbo.[164ce9bf-5ae0-4fab-b3ae-cd2eb3a40062] FROM ##32af41622d9b4e868739530a8e59872c A INNER JOIN Goods g ON a.货号 = g.Goods_No 时间: 2021-03-22 10:36:41,839 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: select cast('2021/03/18' as varchar(50)) as 发生日期, CAST('增加' AS VARCHAR(20)) as 操作类型,CAST('上期余额' AS VARCHAR(50)) as 单据类型 , cast('' as varCHAR(max)) as 对应单位 ,cast('' as varCHAR(max)) as 对应单位简称,cast('' as varCHAR(max)) as 单号,cast('' as varCHAR(max)) as 手工单号, cast('' as varCHAR(max)) as 备注,cast('' AS VARCHAR(50)) 销售类型,cast('' AS VARCHAR(50)) 零售订单号, cast('' AS VARCHAR(50)) 预售零售订单号,c.goods_no as 货号,goods.goods_name as 品名,CAST(c.colorid AS VARCHAR(20)) as 颜色, vGoodsColor.color as 颜色说明,CAST(c.long AS VARCHAR(20)) as 内长 , SUM(c.[S1]) AS [S1] , SUM(ISNULL(c.[S1], 0)) AS [数量] INTO ##06c6c656ba104e1c8fe12be446d1adad from [Hcstock#20210318#Z007] c left join [goods] on c.goods_no = goods.goods_no left join vGoodsColor on c.Goods_No = vGoodsColor.Goods_No AND c.colorid = vGoodsColor.colorid where c.goods_no = '[货号:2023049]' group by c.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long 时间: 2021-03-22 10:36:41,849 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##06c6c656ba104e1c8fe12be446d1adad select convert(VARCHAR(20),a.Tin_date,120) as 发生日期, CAST('增加' AS VARCHAR(20)) as 操作类型, CAST('店铺收货' AS VARCHAR(20)) as 单据类型, CAST(a.fmwarehouse_no AS VARCHAR(50)) as 对应单位, CAST(w.Warehouse_Na AS VARCHAR(50)) AS 对应单位简称,a.ShopTinid as 单号, CAST(a.manual_id AS VARCHAR(50)) as 手工单号,cast(a.Remark as varchar(max)) as 备注,cast('' AS VARCHAR(50)) 销售类型, cast('' AS VARCHAR(50)) 零售订单号,cast('' AS VARCHAR(50)) 预售零售订单号,b.goods_no as 货号,goods.goods_name as 品名, CAST(c.colorid AS VARCHAR(20)) as 颜色,vGoodsColor.color as 颜色说明,CAST(c.long AS VARCHAR(20)) as 内长, SUM(c.[S1]) AS [S1] , SUM(ISNULL(c.[S1], 0)) AS [数量] from ShopTin as a left join ShopTingoods as b on a.ShopTinid=b.ShopTinid left join ShopTindetail as c on b.ShopTingoodsid=c.ShopTingoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Warehouse w ON w.Warehouse_No = a.fmwarehouse_no where a.type=1 and a.posted=1 and a.tinshop = 'Z007' and b.goods_No = '[货号:2023049]' and a.tin_date > '2021/03/18' and a.tin_date < '2021/3/23 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long,a.fmwarehouse_no, w.Warehouse_Na,a.ShopTinid,a.manual_id,a.tin_date,cast(a.Remark as varchar(max)) 时间: 2021-03-22 10:36:41,861 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##06c6c656ba104e1c8fe12be446d1adad select convert(VARCHAR(20),a.Tin_date,120) as 发生日期,'增加' as 操作类型,'店铺调入' as 单据类型,a.toutshop as 对应单位, co.Abbrev AS 对应单位简称,a.ShopTinid as 单号, a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号,goods.goods_name as 品名,c.colorid as 颜色, vGoodsColor.color as 颜色说明,c.long as 内长, SUM(c.[S1]) AS [S1] , SUM(ISNULL(c.[S1], 0)) AS [数量] from ShopTin as a left join ShopTingoods as b on a.ShopTinid=b.ShopTinid left join ShopTindetail as c on b.ShopTingoodsid=c.ShopTingoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Customer co ON co.Customer_ID = a.TOutShop where a.type=2 and a.posted=1 and a.tinshop = 'Z007' and b.goods_No = '[货号:2023049]' and a.tin_date > '2021/03/18' and a.tin_date < '2021/3/23 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long,a.toutshop,co.Abbrev,a.ShopTinid,a.manual_id,a.tin_date,cast(a.Remark as varchar(max)) 时间: 2021-03-22 10:36:41,874 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##06c6c656ba104e1c8fe12be446d1adad select convert(VARCHAR(20),a.Tin_date,120) as 发生日期,'增加' as 操作类型,'店铺采购收货' as 单据类型,a.supply_no as 对应单位, s.Supply_Abv AS 对应单位简称,a.ShopTinid as 单号, a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号,goods.goods_name as 品名,c.colorid as 颜色,vGoodsColor.color as 颜色说明, c.long as 内长, SUM(c.[S1]) AS [S1] , SUM(ISNULL(c.[S1], 0)) AS [数量] from ShopTin as a left join ShopTingoods as b on a.ShopTinid=b.ShopTinid left join ShopTindetail as c on b.ShopTingoodsid=c.ShopTingoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Supply s ON s.Supply_No = a.Supply_No where a.type=3 and a.posted=1 and a.tinshop = 'Z007' and b.goods_No = '[货号:2023049]' and a.tin_date > '2021/03/18' and a.tin_date < '2021/3/23 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long, a.supply_no, s.Supply_Abv,a.ShopTinid,a.manual_id,a.tin_date,cast(a.Remark as varchar(max)) 时间: 2021-03-22 10:36:41,887 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##06c6c656ba104e1c8fe12be446d1adad select convert(VARCHAR(20),a.return_date,120) as 发生日期,'减少' as 操作类型,'店铺退货' as 单据类型,a.warehouse_no as 对应单位, w.Warehouse_Na AS 对应单位简称,a.Dealereturnid as 单号,a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号, goods.goods_name as 品名,c.colorid as 颜色,vGoodsColor.color as 颜色说明,c.long as 内长, SUM(-c.[S1]) AS [S1], (-1)*SUM(ISNULL(c.[S1], 0)) AS [数量] from Dealereturn as a left join Dealereturngoods as b on a.Dealereturnid=b.Dealereturnid left join Dealereturndetail as c on b.Dealereturngoodsid=c.Dealereturngoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Warehouse w ON w.Warehouse_No = a.Warehouse_No where a.posted=1 AND (ISNULL(a.Type,'')='' OR a.Type=1) and a.customer_ID = 'Z007' and b.goods_No = '[货号:2023049]' and a.return_date > '2021/03/18' and a.return_date < '2021/3/23 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long,a.warehouse_no,w.Warehouse_Na,a.Dealereturnid, a.manual_id,a.return_date,cast(a.Remark as varchar(max)) 时间: 2021-03-22 10:36:41,898 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##06c6c656ba104e1c8fe12be446d1adad select convert(VARCHAR(20),a.return_date,120) as 发生日期,'减少' as 操作类型,'店铺采购退货' as 单据类型,a.supply_no as 对应单位, s.Supply_Abv AS 对应单位简称,a.Dealereturnid as 单号,a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号, goods.goods_name as 品名,c.colorid as 颜色,vGoodsColor.color as 颜色说明,c.long as 内长, SUM(-c.[S1]) AS [S1], (-1)*SUM(ISNULL(c.[S1], 0)) AS [数量] from Dealereturn as a left join Dealereturngoods as b on a.Dealereturnid=b.Dealereturnid left join Dealereturndetail as c on b.Dealereturngoodsid=c.Dealereturngoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Supply s ON s.Supply_No = a.Supply_No where a.posted=1 AND (a.Type=2) and a.customer_ID = 'Z007' and b.goods_No = '[货号:2023049]' and a.return_date > '2021/03/18' and a.return_date < '2021/3/23 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long,a.supply_no,s.Supply_Abv,a.Dealereturnid,a.manual_id,a.return_date,cast(a.Remark as varchar(max)) 时间: 2021-03-22 10:36:41,911 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT CONVERT(VARCHAR(20),a.CheckDate,120) CheckDate ,'减少' HandleType,'店铺零售' DocType ,a.Customer_ID, ct.Abbrev,a.CheckID, a.Manual_ID,CAST(b.SaleTypeID AS VARCHAR) 销售类型,a.RetailOrderID 零售订单号,b.RetailOrderID 预售零售订单号,b.Status 销售状态,cast(a.Remark as varchar(max)) as 备注, b.Goods_No,goods.Goods_Name,c.ColorID,vGoodsColor.color,c.long, SUM(-c.[S1]) AS [S1], (-1)*SUM(ISNULL(c.[S1], 0)) AS [Quantity] into ##a27025993677415a8e67f4dd16c17b70 from [vn_Check] as a left join vn_checkgoods as b on a.checkid=b.checkid left join vn_checkdetail as c on b.checkgoodsid=c.checkgoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Customer ct ON ct.Customer_ID = a.Customer_ID where a.posted=1 AND NOT EXISTS(SELECT 1 FROM DictSaleType WHERE ID=ISNULL(b.SaleTypeID,0) AND IsAdjustStock=0) and a.customer_ID = 'Z007' and a.customer_id in (select customer_id from customer where mathod='自营' or mathod='专柜' or mathod='加盟' or mathod='代理') and b.goods_No = '[货号:2023049]' and a.Checkdate > '2021/03/18' and a.Checkdate < '2021/3/23 0:00:00' group by b.Status,b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long, a.customer_id,ct.Abbrev,a.checkid,a.manual_id,a.checkdate, b.SaleTypeID,a.RetailOrderID,b.RetailOrderID ,cast(a.Remark as varchar(max)) 时间: 2021-03-22 10:36:41,933 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET A.零售订单号='' FROM ##a27025993677415a8e67f4dd16c17b70 A WHERE 销售状态='退货' AND EXISTS(SELECT 1 FROM KS2_RetailOrder WHERE RetailOrderID=A.零售订单号 AND ISNULL(SaleTypeID,0) IN (1,2)) 时间: 2021-03-22 10:36:41,938 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##06c6c656ba104e1c8fe12be446d1adad SELECT CheckDate,HandleType,DocType ,Customer_ID, Abbrev,CheckID,Manual_ID,备注,销售类型,零售订单号,预售零售订单号,Goods_No,Goods_Name,ColorID,color,long, SUM(c.[S1]) AS [S1], sum(Quantity) FROM ##a27025993677415a8e67f4dd16c17b70 c GROUP BY CheckDate,HandleType,DocType ,Customer_ID, Abbrev,CheckID,Manual_ID,销售类型,零售订单号,预售零售订单号,备注,Goods_No,Goods_Name,ColorID,color,long 时间: 2021-03-22 10:36:41,942 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##06c6c656ba104e1c8fe12be446d1adad select convert(VARCHAR(20),a.tout_date,120) as 发生日期,'减少' as 操作类型,'店铺调出' as 单据类型,a.tinshop as 对应单位, cti.Abbrev AS 对应单位简称,a.shoptoutid as 单号,a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号, goods.goods_name as 品名,c.colorid as 颜色,vGoodsColor.color as 颜色说明,c.long as 内长, SUM(-c.[S1]) AS [S1], (-1)*SUM(ISNULL(c.[S1], 0)) AS [数量] from shoptout as a left join shoptoutgoods as b on a.shoptoutid=b.shoptoutid left join shoptoutdetail as c on b.shoptoutgoodsid=c.shoptoutgoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Customer cti ON cti.Customer_ID = a.TinShop where a.posted=1 and a.toutshop = 'Z007' and b.goods_No = '[货号:2023049]' and a.tout_date > '2021/03/18' and a.tout_date < '2021/3/23 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long, a.tinshop,cti.Abbrev,a.shoptoutid,a.manual_id,a.tout_date,cast(a.Remark as varchar(max)) 时间: 2021-03-22 10:36:41,955 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##06c6c656ba104e1c8fe12be446d1adad select convert(VARCHAR(20),a.balance_date,120) as 发生日期,'减少' as 操作类型,'店铺损益' as 单据类型,a.customer_id as 对应单位, ct.Abbrev AS 对应单位简称, a.balanceid as 单号,a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号,goods.goods_name as 品名,c.colorid as 颜色, vGoodsColor.color as 颜色说明,c.long as 内长, SUM(-c.[S1]) AS [S1], (-1)*SUM(ISNULL(c.[S1], 0)) AS [数量] from balance as a left join balancegoods as b on a.balanceid=b.balanceid left join balancedetail as c on b.balancegoodsid=c.balancegoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Customer ct ON ct.Customer_ID = a.customer_id where a.posted=1 and a.type=2 and a.customer_ID = 'Z007' and b.goods_No = '[货号:2023049]' and a.balance_date > '2021/03/18' and a.balance_date < '2021/3/23 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long,a.customer_id, ct.Abbrev,a.balanceid,a.manual_id,a.balance_date,cast(a.Remark as varchar(max)) 时间: 2021-03-22 10:36:41,965 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##06c6c656ba104e1c8fe12be446d1adad SET 销售类型=ISNULL(销售类型,'') 时间: 2021-03-22 10:36:41,966 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.销售类型=b.SaleType FROM ##06c6c656ba104e1c8fe12be446d1adad a INNER JOIN DictSaleType b ON a.销售类型=CAST(b.ID AS VARCHAR) WHERE a.单据类型 IN('店铺零售','加盟店铺零售') 时间: 2021-03-22 10:36:41,969 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##06c6c656ba104e1c8fe12be446d1adad SET 销售类型='线上发货' WHERE 单据类型 IN('店铺零售','加盟店铺零售') AND 零售订单号 IS NOT NULL AND 零售订单号 <> '' 时间: 2021-03-22 10:36:41,971 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##06c6c656ba104e1c8fe12be446d1adad SET 销售类型='正常销售' WHERE 单据类型 IN('店铺零售','加盟店铺零售') AND 销售类型 NOT IN ('预售自提','预售直发','线上发货') 时间: 2021-03-22 10:36:41,972 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: DELETE a FROM ##06c6c656ba104e1c8fe12be446d1adad a WHERE 单据类型 IN('店铺零售','加盟店铺零售') AND a.销售类型 NOT IN('正常销售','预售直发','预售自提') 时间: 2021-03-22 10:36:41,973 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber ,A.* INTO tempdb.dbo.[164ce9bf-5ae0-4fab-b3ae-cd2eb3a40062] FROM ##06c6c656ba104e1c8fe12be446d1adad A INNER JOIN Goods g ON a.货号 = g.Goods_No 时间: 2021-03-22 10:36:55,229 线程ID: 95 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: select top 0 cast('' as varchar(50)) as 发生日期, CAST('' AS VARCHAR(20)) as 操作类型,CAST('' AS VARCHAR(50)) as 单据类型 , cast('' as varCHAR(max)) as 对应单位 ,cast('' as varCHAR(max)) as 对应单位简称,cast('' as varCHAR(max)) as 单号,cast('' as varCHAR(max)) as 手工单号, cast('' as varCHAR(max)) as 备注,cast('' AS VARCHAR(50)) 销售类型,cast('' AS VARCHAR(50)) 零售订单号, cast('' AS VARCHAR(50)) 预售零售订单号,cast('' AS VARCHAR(50)) 货号,cast('' AS VARCHAR(50)) 品名,CAST('' AS VARCHAR(20)) as 颜色, cast('' AS VARCHAR(50)) as 颜色说明,CAST('' AS VARCHAR(20)) as 内长 , CAST(0 AS INT) AS [S1] , CAST('' AS INT) AS 数量 INTO ##42760abbbcec47e88de598cbd5400e57 from Goods 时间: 2021-03-22 10:36:55,232 线程ID: 95 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##42760abbbcec47e88de598cbd5400e57 select convert(VARCHAR(20),a.Tin_date,120) as 发生日期, CAST('增加' AS VARCHAR(20)) as 操作类型, CAST('店铺收货' AS VARCHAR(20)) as 单据类型, CAST(a.fmwarehouse_no AS VARCHAR(50)) as 对应单位, CAST(w.Warehouse_Na AS VARCHAR(50)) AS 对应单位简称,a.ShopTinid as 单号, CAST(a.manual_id AS VARCHAR(50)) as 手工单号,cast(a.Remark as varchar(max)) as 备注,cast('' AS VARCHAR(50)) 销售类型, cast('' AS VARCHAR(50)) 零售订单号,cast('' AS VARCHAR(50)) 预售零售订单号,b.goods_no as 货号,goods.goods_name as 品名, CAST(c.colorid AS VARCHAR(20)) as 颜色,vGoodsColor.color as 颜色说明,CAST(c.long AS VARCHAR(20)) as 内长, SUM(c.[S1]) AS [S1] , SUM(ISNULL(c.[S1], 0)) AS [数量] from ShopTin as a left join ShopTingoods as b on a.ShopTinid=b.ShopTinid left join ShopTindetail as c on b.ShopTingoodsid=c.ShopTingoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Warehouse w ON w.Warehouse_No = a.fmwarehouse_no where a.type=1 and a.posted=1 and a.tinshop = 'Z007' and b.goods_No = '2023049' and a.tin_date < '2021/3/23 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long,a.fmwarehouse_no, w.Warehouse_Na,a.ShopTinid,a.manual_id,a.tin_date,cast(a.Remark as varchar(max)) 时间: 2021-03-22 10:36:55,245 线程ID: 95 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##42760abbbcec47e88de598cbd5400e57 select convert(VARCHAR(20),a.Tin_date,120) as 发生日期,'增加' as 操作类型,'店铺调入' as 单据类型,a.toutshop as 对应单位, co.Abbrev AS 对应单位简称,a.ShopTinid as 单号, a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号,goods.goods_name as 品名,c.colorid as 颜色, vGoodsColor.color as 颜色说明,c.long as 内长, SUM(c.[S1]) AS [S1] , SUM(ISNULL(c.[S1], 0)) AS [数量] from ShopTin as a left join ShopTingoods as b on a.ShopTinid=b.ShopTinid left join ShopTindetail as c on b.ShopTingoodsid=c.ShopTingoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Customer co ON co.Customer_ID = a.TOutShop where a.type=2 and a.posted=1 and a.tinshop = 'Z007' and b.goods_No = '2023049' and a.tin_date < '2021/3/23 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long,a.toutshop,co.Abbrev,a.ShopTinid,a.manual_id,a.tin_date,cast(a.Remark as varchar(max)) 时间: 2021-03-22 10:36:55,258 线程ID: 95 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##42760abbbcec47e88de598cbd5400e57 select convert(VARCHAR(20),a.Tin_date,120) as 发生日期,'增加' as 操作类型,'店铺采购收货' as 单据类型,a.supply_no as 对应单位, s.Supply_Abv AS 对应单位简称,a.ShopTinid as 单号, a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号,goods.goods_name as 品名,c.colorid as 颜色,vGoodsColor.color as 颜色说明, c.long as 内长, SUM(c.[S1]) AS [S1] , SUM(ISNULL(c.[S1], 0)) AS [数量] from ShopTin as a left join ShopTingoods as b on a.ShopTinid=b.ShopTinid left join ShopTindetail as c on b.ShopTingoodsid=c.ShopTingoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Supply s ON s.Supply_No = a.Supply_No where a.type=3 and a.posted=1 and a.tinshop = 'Z007' and b.goods_No = '2023049' and a.tin_date < '2021/3/23 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long, a.supply_no, s.Supply_Abv,a.ShopTinid,a.manual_id,a.tin_date,cast(a.Remark as varchar(max)) 时间: 2021-03-22 10:36:55,268 线程ID: 95 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##42760abbbcec47e88de598cbd5400e57 select convert(VARCHAR(20),a.return_date,120) as 发生日期,'减少' as 操作类型,'店铺退货' as 单据类型,a.warehouse_no as 对应单位, w.Warehouse_Na AS 对应单位简称,a.Dealereturnid as 单号,a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号, goods.goods_name as 品名,c.colorid as 颜色,vGoodsColor.color as 颜色说明,c.long as 内长, SUM(-c.[S1]) AS [S1], (-1)*SUM(ISNULL(c.[S1], 0)) AS [数量] from Dealereturn as a left join Dealereturngoods as b on a.Dealereturnid=b.Dealereturnid left join Dealereturndetail as c on b.Dealereturngoodsid=c.Dealereturngoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Warehouse w ON w.Warehouse_No = a.Warehouse_No where a.posted=1 AND (ISNULL(a.Type,'')='' OR a.Type=1) and a.customer_ID = 'Z007' and b.goods_No = '2023049' and a.return_date < '2021/3/23 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long,a.warehouse_no,w.Warehouse_Na,a.Dealereturnid, a.manual_id,a.return_date,cast(a.Remark as varchar(max)) 时间: 2021-03-22 10:36:55,282 线程ID: 95 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##42760abbbcec47e88de598cbd5400e57 select convert(VARCHAR(20),a.return_date,120) as 发生日期,'减少' as 操作类型,'店铺采购退货' as 单据类型,a.supply_no as 对应单位, s.Supply_Abv AS 对应单位简称,a.Dealereturnid as 单号,a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号, goods.goods_name as 品名,c.colorid as 颜色,vGoodsColor.color as 颜色说明,c.long as 内长, SUM(-c.[S1]) AS [S1], (-1)*SUM(ISNULL(c.[S1], 0)) AS [数量] from Dealereturn as a left join Dealereturngoods as b on a.Dealereturnid=b.Dealereturnid left join Dealereturndetail as c on b.Dealereturngoodsid=c.Dealereturngoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Supply s ON s.Supply_No = a.Supply_No where a.posted=1 AND (a.Type=2) and a.customer_ID = 'Z007' and b.goods_No = '2023049' and a.return_date < '2021/3/23 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long,a.supply_no,s.Supply_Abv,a.Dealereturnid,a.manual_id,a.return_date,cast(a.Remark as varchar(max)) 时间: 2021-03-22 10:36:55,293 线程ID: 95 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT CONVERT(VARCHAR(20),a.CheckDate,120) CheckDate ,'减少' HandleType,'店铺零售' DocType ,a.Customer_ID, ct.Abbrev,a.CheckID, a.Manual_ID,CAST(b.SaleTypeID AS VARCHAR) 销售类型,a.RetailOrderID 零售订单号,b.RetailOrderID 预售零售订单号,b.Status 销售状态,cast(a.Remark as varchar(max)) as 备注, b.Goods_No,goods.Goods_Name,c.ColorID,vGoodsColor.color,c.long, SUM(-c.[S1]) AS [S1], (-1)*SUM(ISNULL(c.[S1], 0)) AS [Quantity] into ##657ec6f9ad0143f48a27da595c3df67c from [vn_Check] as a left join vn_checkgoods as b on a.checkid=b.checkid left join vn_checkdetail as c on b.checkgoodsid=c.checkgoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Customer ct ON ct.Customer_ID = a.Customer_ID where a.posted=1 AND NOT EXISTS(SELECT 1 FROM DictSaleType WHERE ID=ISNULL(b.SaleTypeID,0) AND IsAdjustStock=0) and a.customer_ID = 'Z007' and a.customer_id in (select customer_id from customer where mathod='自营' or mathod='专柜' or mathod='加盟' or mathod='代理') and b.goods_No = '2023049' and a.Checkdate < '2021/3/23 0:00:00' group by b.Status,b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long, a.customer_id,ct.Abbrev,a.checkid,a.manual_id,a.checkdate, b.SaleTypeID,a.RetailOrderID,b.RetailOrderID ,cast(a.Remark as varchar(max)) 时间: 2021-03-22 10:36:55,317 线程ID: 95 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET A.零售订单号='' FROM ##657ec6f9ad0143f48a27da595c3df67c A WHERE 销售状态='退货' AND EXISTS(SELECT 1 FROM KS2_RetailOrder WHERE RetailOrderID=A.零售订单号 AND ISNULL(SaleTypeID,0) IN (1,2)) 时间: 2021-03-22 10:36:55,322 线程ID: 95 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##42760abbbcec47e88de598cbd5400e57 SELECT CheckDate,HandleType,DocType ,Customer_ID, Abbrev,CheckID,Manual_ID,备注,销售类型,零售订单号,预售零售订单号,Goods_No,Goods_Name,ColorID,color,long, SUM(c.[S1]) AS [S1], sum(Quantity) FROM ##657ec6f9ad0143f48a27da595c3df67c c GROUP BY CheckDate,HandleType,DocType ,Customer_ID, Abbrev,CheckID,Manual_ID,销售类型,零售订单号,预售零售订单号,备注,Goods_No,Goods_Name,ColorID,color,long 时间: 2021-03-22 10:36:55,333 线程ID: 95 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##42760abbbcec47e88de598cbd5400e57 select convert(VARCHAR(20),a.tout_date,120) as 发生日期,'减少' as 操作类型,'店铺调出' as 单据类型,a.tinshop as 对应单位, cti.Abbrev AS 对应单位简称,a.shoptoutid as 单号,a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号, goods.goods_name as 品名,c.colorid as 颜色,vGoodsColor.color as 颜色说明,c.long as 内长, SUM(-c.[S1]) AS [S1], (-1)*SUM(ISNULL(c.[S1], 0)) AS [数量] from shoptout as a left join shoptoutgoods as b on a.shoptoutid=b.shoptoutid left join shoptoutdetail as c on b.shoptoutgoodsid=c.shoptoutgoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Customer cti ON cti.Customer_ID = a.TinShop where a.posted=1 and a.toutshop = 'Z007' and b.goods_No = '2023049' and a.tout_date < '2021/3/23 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long, a.tinshop,cti.Abbrev,a.shoptoutid,a.manual_id,a.tout_date,cast(a.Remark as varchar(max)) 时间: 2021-03-22 10:36:55,347 线程ID: 95 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##42760abbbcec47e88de598cbd5400e57 select convert(VARCHAR(20),a.balance_date,120) as 发生日期,'减少' as 操作类型,'店铺损益' as 单据类型,a.customer_id as 对应单位, ct.Abbrev AS 对应单位简称, a.balanceid as 单号,a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号,goods.goods_name as 品名,c.colorid as 颜色, vGoodsColor.color as 颜色说明,c.long as 内长, SUM(-c.[S1]) AS [S1], (-1)*SUM(ISNULL(c.[S1], 0)) AS [数量] from balance as a left join balancegoods as b on a.balanceid=b.balanceid left join balancedetail as c on b.balancegoodsid=c.balancegoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Customer ct ON ct.Customer_ID = a.customer_id where a.posted=1 and a.type=2 and a.customer_ID = 'Z007' and b.goods_No = '2023049' and a.balance_date < '2021/3/23 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long,a.customer_id, ct.Abbrev,a.balanceid,a.manual_id,a.balance_date,cast(a.Remark as varchar(max)) 时间: 2021-03-22 10:36:55,358 线程ID: 95 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##42760abbbcec47e88de598cbd5400e57 SET 销售类型=ISNULL(销售类型,'') 时间: 2021-03-22 10:36:55,359 线程ID: 95 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.销售类型=b.SaleType FROM ##42760abbbcec47e88de598cbd5400e57 a INNER JOIN DictSaleType b ON a.销售类型=CAST(b.ID AS VARCHAR) WHERE a.单据类型 IN('店铺零售','加盟店铺零售') 时间: 2021-03-22 10:36:55,363 线程ID: 95 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##42760abbbcec47e88de598cbd5400e57 SET 销售类型='线上发货' WHERE 单据类型 IN('店铺零售','加盟店铺零售') AND 零售订单号 IS NOT NULL AND 零售订单号 <> '' 时间: 2021-03-22 10:36:55,365 线程ID: 95 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##42760abbbcec47e88de598cbd5400e57 SET 销售类型='正常销售' WHERE 单据类型 IN('店铺零售','加盟店铺零售') AND 销售类型 NOT IN ('预售自提','预售直发','线上发货') 时间: 2021-03-22 10:36:55,367 线程ID: 95 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: DELETE a FROM ##42760abbbcec47e88de598cbd5400e57 a WHERE 单据类型 IN('店铺零售','加盟店铺零售') AND a.销售类型 NOT IN('正常销售','预售直发','预售自提') 时间: 2021-03-22 10:36:55,368 线程ID: 95 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber ,A.* INTO tempdb.dbo.[164ce9bf-5ae0-4fab-b3ae-cd2eb3a40062] FROM ##42760abbbcec47e88de598cbd5400e57 A INNER JOIN Goods g ON a.货号 = g.Goods_No 时间: 2021-03-22 10:37:07,685 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: select cast('2021/03/18' as varchar(50)) as 发生日期, CAST('增加' AS VARCHAR(20)) as 操作类型,CAST('上期余额' AS VARCHAR(50)) as 单据类型 , cast('' as varCHAR(max)) as 对应单位 ,cast('' as varCHAR(max)) as 对应单位简称,cast('' as varCHAR(max)) as 单号,cast('' as varCHAR(max)) as 手工单号, cast('' as varCHAR(max)) as 备注,cast('' AS VARCHAR(50)) 销售类型,cast('' AS VARCHAR(50)) 零售订单号, cast('' AS VARCHAR(50)) 预售零售订单号,c.goods_no as 货号,goods.goods_name as 品名,CAST(c.colorid AS VARCHAR(20)) as 颜色, vGoodsColor.color as 颜色说明,CAST(c.long AS VARCHAR(20)) as 内长 , SUM(c.[S1]) AS [S1] , SUM(ISNULL(c.[S1], 0)) AS [数量] INTO ##a9493bf3bd114a48aec781a3e403f2d6 from [Hcstock#20210318#Z007] c left join [goods] on c.goods_no = goods.goods_no left join vGoodsColor on c.Goods_No = vGoodsColor.Goods_No AND c.colorid = vGoodsColor.colorid where c.goods_no = '2023049' group by c.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long 时间: 2021-03-22 10:37:07,692 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##a9493bf3bd114a48aec781a3e403f2d6 select convert(VARCHAR(20),a.Tin_date,120) as 发生日期, CAST('增加' AS VARCHAR(20)) as 操作类型, CAST('店铺收货' AS VARCHAR(20)) as 单据类型, CAST(a.fmwarehouse_no AS VARCHAR(50)) as 对应单位, CAST(w.Warehouse_Na AS VARCHAR(50)) AS 对应单位简称,a.ShopTinid as 单号, CAST(a.manual_id AS VARCHAR(50)) as 手工单号,cast(a.Remark as varchar(max)) as 备注,cast('' AS VARCHAR(50)) 销售类型, cast('' AS VARCHAR(50)) 零售订单号,cast('' AS VARCHAR(50)) 预售零售订单号,b.goods_no as 货号,goods.goods_name as 品名, CAST(c.colorid AS VARCHAR(20)) as 颜色,vGoodsColor.color as 颜色说明,CAST(c.long AS VARCHAR(20)) as 内长, SUM(c.[S1]) AS [S1] , SUM(ISNULL(c.[S1], 0)) AS [数量] from ShopTin as a left join ShopTingoods as b on a.ShopTinid=b.ShopTinid left join ShopTindetail as c on b.ShopTingoodsid=c.ShopTingoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Warehouse w ON w.Warehouse_No = a.fmwarehouse_no where a.type=1 and a.posted=1 and a.tinshop = 'Z007' and b.goods_No = '2023049' and a.tin_date > '2021/03/18' and a.tin_date < '2021/3/23 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long,a.fmwarehouse_no, w.Warehouse_Na,a.ShopTinid,a.manual_id,a.tin_date,cast(a.Remark as varchar(max)) 时间: 2021-03-22 10:37:07,707 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##a9493bf3bd114a48aec781a3e403f2d6 select convert(VARCHAR(20),a.Tin_date,120) as 发生日期,'增加' as 操作类型,'店铺调入' as 单据类型,a.toutshop as 对应单位, co.Abbrev AS 对应单位简称,a.ShopTinid as 单号, a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号,goods.goods_name as 品名,c.colorid as 颜色, vGoodsColor.color as 颜色说明,c.long as 内长, SUM(c.[S1]) AS [S1] , SUM(ISNULL(c.[S1], 0)) AS [数量] from ShopTin as a left join ShopTingoods as b on a.ShopTinid=b.ShopTinid left join ShopTindetail as c on b.ShopTingoodsid=c.ShopTingoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Customer co ON co.Customer_ID = a.TOutShop where a.type=2 and a.posted=1 and a.tinshop = 'Z007' and b.goods_No = '2023049' and a.tin_date > '2021/03/18' and a.tin_date < '2021/3/23 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long,a.toutshop,co.Abbrev,a.ShopTinid,a.manual_id,a.tin_date,cast(a.Remark as varchar(max)) 时间: 2021-03-22 10:37:07,721 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##a9493bf3bd114a48aec781a3e403f2d6 select convert(VARCHAR(20),a.Tin_date,120) as 发生日期,'增加' as 操作类型,'店铺采购收货' as 单据类型,a.supply_no as 对应单位, s.Supply_Abv AS 对应单位简称,a.ShopTinid as 单号, a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号,goods.goods_name as 品名,c.colorid as 颜色,vGoodsColor.color as 颜色说明, c.long as 内长, SUM(c.[S1]) AS [S1] , SUM(ISNULL(c.[S1], 0)) AS [数量] from ShopTin as a left join ShopTingoods as b on a.ShopTinid=b.ShopTinid left join ShopTindetail as c on b.ShopTingoodsid=c.ShopTingoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Supply s ON s.Supply_No = a.Supply_No where a.type=3 and a.posted=1 and a.tinshop = 'Z007' and b.goods_No = '2023049' and a.tin_date > '2021/03/18' and a.tin_date < '2021/3/23 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long, a.supply_no, s.Supply_Abv,a.ShopTinid,a.manual_id,a.tin_date,cast(a.Remark as varchar(max)) 时间: 2021-03-22 10:37:07,732 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##a9493bf3bd114a48aec781a3e403f2d6 select convert(VARCHAR(20),a.return_date,120) as 发生日期,'减少' as 操作类型,'店铺退货' as 单据类型,a.warehouse_no as 对应单位, w.Warehouse_Na AS 对应单位简称,a.Dealereturnid as 单号,a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号, goods.goods_name as 品名,c.colorid as 颜色,vGoodsColor.color as 颜色说明,c.long as 内长, SUM(-c.[S1]) AS [S1], (-1)*SUM(ISNULL(c.[S1], 0)) AS [数量] from Dealereturn as a left join Dealereturngoods as b on a.Dealereturnid=b.Dealereturnid left join Dealereturndetail as c on b.Dealereturngoodsid=c.Dealereturngoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Warehouse w ON w.Warehouse_No = a.Warehouse_No where a.posted=1 AND (ISNULL(a.Type,'')='' OR a.Type=1) and a.customer_ID = 'Z007' and b.goods_No = '2023049' and a.return_date > '2021/03/18' and a.return_date < '2021/3/23 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long,a.warehouse_no,w.Warehouse_Na,a.Dealereturnid, a.manual_id,a.return_date,cast(a.Remark as varchar(max)) 时间: 2021-03-22 10:37:07,744 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##a9493bf3bd114a48aec781a3e403f2d6 select convert(VARCHAR(20),a.return_date,120) as 发生日期,'减少' as 操作类型,'店铺采购退货' as 单据类型,a.supply_no as 对应单位, s.Supply_Abv AS 对应单位简称,a.Dealereturnid as 单号,a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号, goods.goods_name as 品名,c.colorid as 颜色,vGoodsColor.color as 颜色说明,c.long as 内长, SUM(-c.[S1]) AS [S1], (-1)*SUM(ISNULL(c.[S1], 0)) AS [数量] from Dealereturn as a left join Dealereturngoods as b on a.Dealereturnid=b.Dealereturnid left join Dealereturndetail as c on b.Dealereturngoodsid=c.Dealereturngoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Supply s ON s.Supply_No = a.Supply_No where a.posted=1 AND (a.Type=2) and a.customer_ID = 'Z007' and b.goods_No = '2023049' and a.return_date > '2021/03/18' and a.return_date < '2021/3/23 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long,a.supply_no,s.Supply_Abv,a.Dealereturnid,a.manual_id,a.return_date,cast(a.Remark as varchar(max)) 时间: 2021-03-22 10:37:07,755 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT CONVERT(VARCHAR(20),a.CheckDate,120) CheckDate ,'减少' HandleType,'店铺零售' DocType ,a.Customer_ID, ct.Abbrev,a.CheckID, a.Manual_ID,CAST(b.SaleTypeID AS VARCHAR) 销售类型,a.RetailOrderID 零售订单号,b.RetailOrderID 预售零售订单号,b.Status 销售状态,cast(a.Remark as varchar(max)) as 备注, b.Goods_No,goods.Goods_Name,c.ColorID,vGoodsColor.color,c.long, SUM(-c.[S1]) AS [S1], (-1)*SUM(ISNULL(c.[S1], 0)) AS [Quantity] into ##fe3470a042f2427299bf341a07296fa0 from [vn_Check] as a left join vn_checkgoods as b on a.checkid=b.checkid left join vn_checkdetail as c on b.checkgoodsid=c.checkgoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Customer ct ON ct.Customer_ID = a.Customer_ID where a.posted=1 AND NOT EXISTS(SELECT 1 FROM DictSaleType WHERE ID=ISNULL(b.SaleTypeID,0) AND IsAdjustStock=0) and a.customer_ID = 'Z007' and a.customer_id in (select customer_id from customer where mathod='自营' or mathod='专柜' or mathod='加盟' or mathod='代理') and b.goods_No = '2023049' and a.Checkdate > '2021/03/18' and a.Checkdate < '2021/3/23 0:00:00' group by b.Status,b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long, a.customer_id,ct.Abbrev,a.checkid,a.manual_id,a.checkdate, b.SaleTypeID,a.RetailOrderID,b.RetailOrderID ,cast(a.Remark as varchar(max)) 时间: 2021-03-22 10:37:07,778 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET A.零售订单号='' FROM ##fe3470a042f2427299bf341a07296fa0 A WHERE 销售状态='退货' AND EXISTS(SELECT 1 FROM KS2_RetailOrder WHERE RetailOrderID=A.零售订单号 AND ISNULL(SaleTypeID,0) IN (1,2)) 时间: 2021-03-22 10:37:07,782 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##a9493bf3bd114a48aec781a3e403f2d6 SELECT CheckDate,HandleType,DocType ,Customer_ID, Abbrev,CheckID,Manual_ID,备注,销售类型,零售订单号,预售零售订单号,Goods_No,Goods_Name,ColorID,color,long, SUM(c.[S1]) AS [S1], sum(Quantity) FROM ##fe3470a042f2427299bf341a07296fa0 c GROUP BY CheckDate,HandleType,DocType ,Customer_ID, Abbrev,CheckID,Manual_ID,销售类型,零售订单号,预售零售订单号,备注,Goods_No,Goods_Name,ColorID,color,long 时间: 2021-03-22 10:37:07,786 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##a9493bf3bd114a48aec781a3e403f2d6 select convert(VARCHAR(20),a.tout_date,120) as 发生日期,'减少' as 操作类型,'店铺调出' as 单据类型,a.tinshop as 对应单位, cti.Abbrev AS 对应单位简称,a.shoptoutid as 单号,a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号, goods.goods_name as 品名,c.colorid as 颜色,vGoodsColor.color as 颜色说明,c.long as 内长, SUM(-c.[S1]) AS [S1], (-1)*SUM(ISNULL(c.[S1], 0)) AS [数量] from shoptout as a left join shoptoutgoods as b on a.shoptoutid=b.shoptoutid left join shoptoutdetail as c on b.shoptoutgoodsid=c.shoptoutgoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Customer cti ON cti.Customer_ID = a.TinShop where a.posted=1 and a.toutshop = 'Z007' and b.goods_No = '2023049' and a.tout_date > '2021/03/18' and a.tout_date < '2021/3/23 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long, a.tinshop,cti.Abbrev,a.shoptoutid,a.manual_id,a.tout_date,cast(a.Remark as varchar(max)) 时间: 2021-03-22 10:37:07,798 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##a9493bf3bd114a48aec781a3e403f2d6 select convert(VARCHAR(20),a.balance_date,120) as 发生日期,'减少' as 操作类型,'店铺损益' as 单据类型,a.customer_id as 对应单位, ct.Abbrev AS 对应单位简称, a.balanceid as 单号,a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号,goods.goods_name as 品名,c.colorid as 颜色, vGoodsColor.color as 颜色说明,c.long as 内长, SUM(-c.[S1]) AS [S1], (-1)*SUM(ISNULL(c.[S1], 0)) AS [数量] from balance as a left join balancegoods as b on a.balanceid=b.balanceid left join balancedetail as c on b.balancegoodsid=c.balancegoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Customer ct ON ct.Customer_ID = a.customer_id where a.posted=1 and a.type=2 and a.customer_ID = 'Z007' and b.goods_No = '2023049' and a.balance_date > '2021/03/18' and a.balance_date < '2021/3/23 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long,a.customer_id, ct.Abbrev,a.balanceid,a.manual_id,a.balance_date,cast(a.Remark as varchar(max)) 时间: 2021-03-22 10:37:07,810 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##a9493bf3bd114a48aec781a3e403f2d6 SET 销售类型=ISNULL(销售类型,'') 时间: 2021-03-22 10:37:07,811 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.销售类型=b.SaleType FROM ##a9493bf3bd114a48aec781a3e403f2d6 a INNER JOIN DictSaleType b ON a.销售类型=CAST(b.ID AS VARCHAR) WHERE a.单据类型 IN('店铺零售','加盟店铺零售') 时间: 2021-03-22 10:37:07,815 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##a9493bf3bd114a48aec781a3e403f2d6 SET 销售类型='线上发货' WHERE 单据类型 IN('店铺零售','加盟店铺零售') AND 零售订单号 IS NOT NULL AND 零售订单号 <> '' 时间: 2021-03-22 10:37:07,816 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##a9493bf3bd114a48aec781a3e403f2d6 SET 销售类型='正常销售' WHERE 单据类型 IN('店铺零售','加盟店铺零售') AND 销售类型 NOT IN ('预售自提','预售直发','线上发货') 时间: 2021-03-22 10:37:07,819 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: DELETE a FROM ##a9493bf3bd114a48aec781a3e403f2d6 a WHERE 单据类型 IN('店铺零售','加盟店铺零售') AND a.销售类型 NOT IN('正常销售','预售直发','预售自提') 时间: 2021-03-22 10:37:07,820 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber ,A.* INTO tempdb.dbo.[164ce9bf-5ae0-4fab-b3ae-cd2eb3a40062] FROM ##a9493bf3bd114a48aec781a3e403f2d6 A INNER JOIN Goods g ON a.货号 = g.Goods_No 时间: 2021-03-22 10:57:29,206 线程ID: 95 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: select cast('2021/02/18' as varchar(50)) as 发生日期, CAST('增加' AS VARCHAR(20)) as 操作类型,CAST('上期余额' AS VARCHAR(50)) as 单据类型 , cast('' as varCHAR(max)) as 对应单位 ,cast('' as varCHAR(max)) as 对应单位简称,cast('' as varCHAR(max)) as 单号,cast('' as varCHAR(max)) as 手工单号, cast('' as varCHAR(max)) as 备注,cast('' AS VARCHAR(50)) 销售类型,cast('' AS VARCHAR(50)) 零售订单号, cast('' AS VARCHAR(50)) 预售零售订单号,c.goods_no as 货号,goods.goods_name as 品名,CAST(c.colorid AS VARCHAR(20)) as 颜色, vGoodsColor.color as 颜色说明,CAST(c.long AS VARCHAR(20)) as 内长 , SUM(c.[S1]) AS [S1] , SUM(ISNULL(c.[S1], 0)) AS [数量] INTO ##414000cc6dad4d4c8bb37454832f393d from [Hcstock#20210218#Z007] c left join [goods] on c.goods_no = goods.goods_no left join vGoodsColor on c.Goods_No = vGoodsColor.Goods_No AND c.colorid = vGoodsColor.colorid where c.goods_no = '2023049' group by c.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long 时间: 2021-03-22 10:57:29,214 线程ID: 95 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##414000cc6dad4d4c8bb37454832f393d select convert(VARCHAR(20),a.Tin_date,120) as 发生日期, CAST('增加' AS VARCHAR(20)) as 操作类型, CAST('店铺收货' AS VARCHAR(20)) as 单据类型, CAST(a.fmwarehouse_no AS VARCHAR(50)) as 对应单位, CAST(w.Warehouse_Na AS VARCHAR(50)) AS 对应单位简称,a.ShopTinid as 单号, CAST(a.manual_id AS VARCHAR(50)) as 手工单号,cast(a.Remark as varchar(max)) as 备注,cast('' AS VARCHAR(50)) 销售类型, cast('' AS VARCHAR(50)) 零售订单号,cast('' AS VARCHAR(50)) 预售零售订单号,b.goods_no as 货号,goods.goods_name as 品名, CAST(c.colorid AS VARCHAR(20)) as 颜色,vGoodsColor.color as 颜色说明,CAST(c.long AS VARCHAR(20)) as 内长, SUM(c.[S1]) AS [S1] , SUM(ISNULL(c.[S1], 0)) AS [数量] from ShopTin as a left join ShopTingoods as b on a.ShopTinid=b.ShopTinid left join ShopTindetail as c on b.ShopTingoodsid=c.ShopTingoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Warehouse w ON w.Warehouse_No = a.fmwarehouse_no where a.type=1 and a.posted=1 and a.tinshop = 'Z007' and b.goods_No = '2023049' and a.tin_date > '2021/02/18' and a.tin_date < '2021/3/23 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long,a.fmwarehouse_no, w.Warehouse_Na,a.ShopTinid,a.manual_id,a.tin_date,cast(a.Remark as varchar(max)) 时间: 2021-03-22 10:57:29,227 线程ID: 95 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##414000cc6dad4d4c8bb37454832f393d select convert(VARCHAR(20),a.Tin_date,120) as 发生日期,'增加' as 操作类型,'店铺调入' as 单据类型,a.toutshop as 对应单位, co.Abbrev AS 对应单位简称,a.ShopTinid as 单号, a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号,goods.goods_name as 品名,c.colorid as 颜色, vGoodsColor.color as 颜色说明,c.long as 内长, SUM(c.[S1]) AS [S1] , SUM(ISNULL(c.[S1], 0)) AS [数量] from ShopTin as a left join ShopTingoods as b on a.ShopTinid=b.ShopTinid left join ShopTindetail as c on b.ShopTingoodsid=c.ShopTingoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Customer co ON co.Customer_ID = a.TOutShop where a.type=2 and a.posted=1 and a.tinshop = 'Z007' and b.goods_No = '2023049' and a.tin_date > '2021/02/18' and a.tin_date < '2021/3/23 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long,a.toutshop,co.Abbrev,a.ShopTinid,a.manual_id,a.tin_date,cast(a.Remark as varchar(max)) 时间: 2021-03-22 10:57:29,240 线程ID: 95 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##414000cc6dad4d4c8bb37454832f393d select convert(VARCHAR(20),a.Tin_date,120) as 发生日期,'增加' as 操作类型,'店铺采购收货' as 单据类型,a.supply_no as 对应单位, s.Supply_Abv AS 对应单位简称,a.ShopTinid as 单号, a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号,goods.goods_name as 品名,c.colorid as 颜色,vGoodsColor.color as 颜色说明, c.long as 内长, SUM(c.[S1]) AS [S1] , SUM(ISNULL(c.[S1], 0)) AS [数量] from ShopTin as a left join ShopTingoods as b on a.ShopTinid=b.ShopTinid left join ShopTindetail as c on b.ShopTingoodsid=c.ShopTingoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Supply s ON s.Supply_No = a.Supply_No where a.type=3 and a.posted=1 and a.tinshop = 'Z007' and b.goods_No = '2023049' and a.tin_date > '2021/02/18' and a.tin_date < '2021/3/23 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long, a.supply_no, s.Supply_Abv,a.ShopTinid,a.manual_id,a.tin_date,cast(a.Remark as varchar(max)) 时间: 2021-03-22 10:57:29,253 线程ID: 95 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##414000cc6dad4d4c8bb37454832f393d select convert(VARCHAR(20),a.return_date,120) as 发生日期,'减少' as 操作类型,'店铺退货' as 单据类型,a.warehouse_no as 对应单位, w.Warehouse_Na AS 对应单位简称,a.Dealereturnid as 单号,a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号, goods.goods_name as 品名,c.colorid as 颜色,vGoodsColor.color as 颜色说明,c.long as 内长, SUM(-c.[S1]) AS [S1], (-1)*SUM(ISNULL(c.[S1], 0)) AS [数量] from Dealereturn as a left join Dealereturngoods as b on a.Dealereturnid=b.Dealereturnid left join Dealereturndetail as c on b.Dealereturngoodsid=c.Dealereturngoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Warehouse w ON w.Warehouse_No = a.Warehouse_No where a.posted=1 AND (ISNULL(a.Type,'')='' OR a.Type=1) and a.customer_ID = 'Z007' and b.goods_No = '2023049' and a.return_date > '2021/02/18' and a.return_date < '2021/3/23 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long,a.warehouse_no,w.Warehouse_Na,a.Dealereturnid, a.manual_id,a.return_date,cast(a.Remark as varchar(max)) 时间: 2021-03-22 10:57:29,265 线程ID: 95 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##414000cc6dad4d4c8bb37454832f393d select convert(VARCHAR(20),a.return_date,120) as 发生日期,'减少' as 操作类型,'店铺采购退货' as 单据类型,a.supply_no as 对应单位, s.Supply_Abv AS 对应单位简称,a.Dealereturnid as 单号,a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号, goods.goods_name as 品名,c.colorid as 颜色,vGoodsColor.color as 颜色说明,c.long as 内长, SUM(-c.[S1]) AS [S1], (-1)*SUM(ISNULL(c.[S1], 0)) AS [数量] from Dealereturn as a left join Dealereturngoods as b on a.Dealereturnid=b.Dealereturnid left join Dealereturndetail as c on b.Dealereturngoodsid=c.Dealereturngoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Supply s ON s.Supply_No = a.Supply_No where a.posted=1 AND (a.Type=2) and a.customer_ID = 'Z007' and b.goods_No = '2023049' and a.return_date > '2021/02/18' and a.return_date < '2021/3/23 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long,a.supply_no,s.Supply_Abv,a.Dealereturnid,a.manual_id,a.return_date,cast(a.Remark as varchar(max)) 时间: 2021-03-22 10:57:29,276 线程ID: 95 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT CONVERT(VARCHAR(20),a.CheckDate,120) CheckDate ,'减少' HandleType,'店铺零售' DocType ,a.Customer_ID, ct.Abbrev,a.CheckID, a.Manual_ID,CAST(b.SaleTypeID AS VARCHAR) 销售类型,a.RetailOrderID 零售订单号,b.RetailOrderID 预售零售订单号,b.Status 销售状态,cast(a.Remark as varchar(max)) as 备注, b.Goods_No,goods.Goods_Name,c.ColorID,vGoodsColor.color,c.long, SUM(-c.[S1]) AS [S1], (-1)*SUM(ISNULL(c.[S1], 0)) AS [Quantity] into ##ce138986cc8d499987777627bb248186 from [vn_Check] as a left join vn_checkgoods as b on a.checkid=b.checkid left join vn_checkdetail as c on b.checkgoodsid=c.checkgoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Customer ct ON ct.Customer_ID = a.Customer_ID where a.posted=1 AND NOT EXISTS(SELECT 1 FROM DictSaleType WHERE ID=ISNULL(b.SaleTypeID,0) AND IsAdjustStock=0) and a.customer_ID = 'Z007' and a.customer_id in (select customer_id from customer where mathod='自营' or mathod='专柜' or mathod='加盟' or mathod='代理') and b.goods_No = '2023049' and a.Checkdate > '2021/02/18' and a.Checkdate < '2021/3/23 0:00:00' group by b.Status,b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long, a.customer_id,ct.Abbrev,a.checkid,a.manual_id,a.checkdate, b.SaleTypeID,a.RetailOrderID,b.RetailOrderID ,cast(a.Remark as varchar(max)) 时间: 2021-03-22 10:57:29,301 线程ID: 95 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET A.零售订单号='' FROM ##ce138986cc8d499987777627bb248186 A WHERE 销售状态='退货' AND EXISTS(SELECT 1 FROM KS2_RetailOrder WHERE RetailOrderID=A.零售订单号 AND ISNULL(SaleTypeID,0) IN (1,2)) 时间: 2021-03-22 10:57:29,307 线程ID: 95 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##414000cc6dad4d4c8bb37454832f393d SELECT CheckDate,HandleType,DocType ,Customer_ID, Abbrev,CheckID,Manual_ID,备注,销售类型,零售订单号,预售零售订单号,Goods_No,Goods_Name,ColorID,color,long, SUM(c.[S1]) AS [S1], sum(Quantity) FROM ##ce138986cc8d499987777627bb248186 c GROUP BY CheckDate,HandleType,DocType ,Customer_ID, Abbrev,CheckID,Manual_ID,销售类型,零售订单号,预售零售订单号,备注,Goods_No,Goods_Name,ColorID,color,long 时间: 2021-03-22 10:57:29,318 线程ID: 95 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##414000cc6dad4d4c8bb37454832f393d select convert(VARCHAR(20),a.tout_date,120) as 发生日期,'减少' as 操作类型,'店铺调出' as 单据类型,a.tinshop as 对应单位, cti.Abbrev AS 对应单位简称,a.shoptoutid as 单号,a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号, goods.goods_name as 品名,c.colorid as 颜色,vGoodsColor.color as 颜色说明,c.long as 内长, SUM(-c.[S1]) AS [S1], (-1)*SUM(ISNULL(c.[S1], 0)) AS [数量] from shoptout as a left join shoptoutgoods as b on a.shoptoutid=b.shoptoutid left join shoptoutdetail as c on b.shoptoutgoodsid=c.shoptoutgoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Customer cti ON cti.Customer_ID = a.TinShop where a.posted=1 and a.toutshop = 'Z007' and b.goods_No = '2023049' and a.tout_date > '2021/02/18' and a.tout_date < '2021/3/23 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long, a.tinshop,cti.Abbrev,a.shoptoutid,a.manual_id,a.tout_date,cast(a.Remark as varchar(max)) 时间: 2021-03-22 10:57:29,331 线程ID: 95 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##414000cc6dad4d4c8bb37454832f393d select convert(VARCHAR(20),a.balance_date,120) as 发生日期,'减少' as 操作类型,'店铺损益' as 单据类型,a.customer_id as 对应单位, ct.Abbrev AS 对应单位简称, a.balanceid as 单号,a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号,goods.goods_name as 品名,c.colorid as 颜色, vGoodsColor.color as 颜色说明,c.long as 内长, SUM(-c.[S1]) AS [S1], (-1)*SUM(ISNULL(c.[S1], 0)) AS [数量] from balance as a left join balancegoods as b on a.balanceid=b.balanceid left join balancedetail as c on b.balancegoodsid=c.balancegoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Customer ct ON ct.Customer_ID = a.customer_id where a.posted=1 and a.type=2 and a.customer_ID = 'Z007' and b.goods_No = '2023049' and a.balance_date > '2021/02/18' and a.balance_date < '2021/3/23 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long,a.customer_id, ct.Abbrev,a.balanceid,a.manual_id,a.balance_date,cast(a.Remark as varchar(max)) 时间: 2021-03-22 10:57:29,341 线程ID: 95 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##414000cc6dad4d4c8bb37454832f393d SET 销售类型=ISNULL(销售类型,'') 时间: 2021-03-22 10:57:29,342 线程ID: 95 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.销售类型=b.SaleType FROM ##414000cc6dad4d4c8bb37454832f393d a INNER JOIN DictSaleType b ON a.销售类型=CAST(b.ID AS VARCHAR) WHERE a.单据类型 IN('店铺零售','加盟店铺零售') 时间: 2021-03-22 10:57:29,347 线程ID: 95 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##414000cc6dad4d4c8bb37454832f393d SET 销售类型='线上发货' WHERE 单据类型 IN('店铺零售','加盟店铺零售') AND 零售订单号 IS NOT NULL AND 零售订单号 <> '' 时间: 2021-03-22 10:57:29,349 线程ID: 95 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##414000cc6dad4d4c8bb37454832f393d SET 销售类型='正常销售' WHERE 单据类型 IN('店铺零售','加盟店铺零售') AND 销售类型 NOT IN ('预售自提','预售直发','线上发货') 时间: 2021-03-22 10:57:29,351 线程ID: 95 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: DELETE a FROM ##414000cc6dad4d4c8bb37454832f393d a WHERE 单据类型 IN('店铺零售','加盟店铺零售') AND a.销售类型 NOT IN('正常销售','预售直发','预售自提') 时间: 2021-03-22 10:57:29,352 线程ID: 95 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber ,A.* INTO tempdb.dbo.[164ce9bf-5ae0-4fab-b3ae-cd2eb3a40062] FROM ##414000cc6dad4d4c8bb37454832f393d A INNER JOIN Goods g ON a.货号 = g.Goods_No 时间: 2021-03-22 17:56:12,901 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌] ,Category AS [一级类别], Category2 AS [二级类别] ,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权] ,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价] ,GoodsDate [货期], [GoodsRemark] [备注], ShutOut [停用] INTO tempdb.dbo.[5a551f02-bc0c-4546-8b51-6f4707894d35] FROM [##d9bd8ffbabd34e54a48dbbd246720874] ORDER BY Goods_no 时间: 2021-03-22 17:56:17,622 线程ID: 13 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌] ,Category AS [一级类别], Category2 AS [二级类别] ,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权] ,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价] ,GoodsDate [货期], [GoodsRemark] [备注], ShutOut [停用] INTO tempdb.dbo.[5a551f02-bc0c-4546-8b51-6f4707894d35] FROM [##080b6b9d6a16492981c1bae0ba06fd00] ORDER BY Goods_no 时间: 2021-03-22 18:03:49,709 线程ID: 89 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌] ,Category AS [一级类别], Category2 AS [二级类别] ,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权] ,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价] ,GoodsDate [货期], [GoodsRemark] [备注], ShutOut [停用] INTO tempdb.dbo.[5a551f02-bc0c-4546-8b51-6f4707894d35] FROM [##2fd8ed389baf47e0b91e2ec51d698d02] ORDER BY Goods_no 时间: 2021-03-22 18:03:50,767 线程ID: 88 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌] ,Category AS [一级类别], Category2 AS [二级类别] ,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权] ,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价] ,GoodsDate [货期], [GoodsRemark] [备注], ShutOut [停用] INTO tempdb.dbo.[5a551f02-bc0c-4546-8b51-6f4707894d35] FROM [##ddea54b9c6864591b50a7868a489cb6f] ORDER BY Goods_no 时间: 2021-03-22 18:03:50,920 线程ID: 89 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌] ,Category AS [一级类别], Category2 AS [二级类别] ,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权] ,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价] ,GoodsDate [货期], [GoodsRemark] [备注], ShutOut [停用] INTO tempdb.dbo.[5a551f02-bc0c-4546-8b51-6f4707894d35] FROM [##9b8d5b88ca0b4ce4b8baf8222ae276b1] ORDER BY Goods_no 时间: 2021-03-22 18:03:51,096 线程ID: 78 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌] ,Category AS [一级类别], Category2 AS [二级类别] ,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权] ,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价] ,GoodsDate [货期], [GoodsRemark] [备注], ShutOut [停用] INTO tempdb.dbo.[5a551f02-bc0c-4546-8b51-6f4707894d35] FROM [##97f3cf3e8d7a4121b313cd26e6d0d15a] ORDER BY Goods_no 时间: 2021-03-22 18:03:55,080 线程ID: 88 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌] ,Category AS [一级类别], Category2 AS [二级类别] ,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权] ,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价] ,GoodsDate [货期], [GoodsRemark] [备注], ShutOut [停用] INTO tempdb.dbo.[5a551f02-bc0c-4546-8b51-6f4707894d35] FROM [##322dd1a44e0d4ae99e5be78a9cf6b942] ORDER BY Goods_no 时间: 2021-03-22 18:03:57,239 线程ID: 88 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌] ,Category AS [一级类别], Category2 AS [二级类别] ,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权] ,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价] ,GoodsDate [货期], [GoodsRemark] [备注], ShutOut [停用] INTO tempdb.dbo.[5a551f02-bc0c-4546-8b51-6f4707894d35] FROM [##d28a4502ff0a463e848e476fc1c6409d] ORDER BY Goods_no 时间: 2021-03-22 18:03:57,386 线程ID: 91 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌] ,Category AS [一级类别], Category2 AS [二级类别] ,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权] ,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价] ,GoodsDate [货期], [GoodsRemark] [备注], ShutOut [停用] INTO tempdb.dbo.[5a551f02-bc0c-4546-8b51-6f4707894d35] FROM [##6b0ef98d4a714efebdbd39e80bc171c3] ORDER BY Goods_no 时间: 2021-03-22 18:04:10,027 线程ID: 87 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌] ,Category AS [一级类别], Category2 AS [二级类别] ,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权] ,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价] ,GoodsDate [货期], [GoodsRemark] [备注], ShutOut [停用] INTO tempdb.dbo.[5a551f02-bc0c-4546-8b51-6f4707894d35] FROM [##6cb7465030ad4c8c95ecd2de1aa65fe3] ORDER BY Goods_no 时间: 2021-03-22 18:04:12,428 线程ID: 89 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌] ,Category AS [一级类别], Category2 AS [二级类别] ,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权] ,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价] ,GoodsDate [货期], [GoodsRemark] [备注], ShutOut [停用] INTO tempdb.dbo.[5a551f02-bc0c-4546-8b51-6f4707894d35] FROM [##b9fd2d6af17e417f9ca073e836cf9953] ORDER BY Goods_no 时间: 2021-03-22 18:04:12,571 线程ID: 88 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌] ,Category AS [一级类别], Category2 AS [二级类别] ,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权] ,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价] ,GoodsDate [货期], [GoodsRemark] [备注], ShutOut [停用] INTO tempdb.dbo.[5a551f02-bc0c-4546-8b51-6f4707894d35] FROM [##390f03c430114569b0f07b0fd0755031] ORDER BY Goods_no 时间: 2021-03-22 18:09:42,217 线程ID: 9 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌] ,Category AS [一级类别], Category2 AS [二级类别] ,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权] ,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价] ,GoodsDate [货期], [GoodsRemark] [备注], ShutOut [停用] INTO tempdb.dbo.[5a551f02-bc0c-4546-8b51-6f4707894d35] FROM [##df519a8e781a4e1f886ed74d85f185f2] ORDER BY Goods_no 时间: 2021-03-22 18:31:55,795 线程ID: 89 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌] ,Category AS [一级类别], Category2 AS [二级类别] ,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权] ,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价] ,GoodsDate [货期], [GoodsRemark] [备注], ShutOut [停用] INTO tempdb.dbo.[5a551f02-bc0c-4546-8b51-6f4707894d35] FROM [##8c25f1d5ebb2413ab342848b815dbfdc] ORDER BY Goods_no