相关联的表,除了主键外其它相关处理(商品信息).a.BillNo=e.SrcBillNo and d.ProductCode=e.ProductCode and d.ProductSortCode=e.ProductSortCode
来源:互联网 发布:jqueryrotate.js 下载 编辑:程序博客网 时间:2024/05/17 20:21
/*------------------------------------------------
创建时间:2007-09-13
创 建 人:szj
参 考:
功 能: 门店订货单执行明细表(仓库调拨单和加盟配送单)
修 改:
具 体:
备 注:
*/-------------------------------------------------
select a.BillNo,a.TheDate,e.*,b.TheName StorageName,b.ShopName,b.StorPlaceName,c.TheName ProductName,c.ConfigName,c.UnitName,
d.ProductCode,d.ProductSortCode,d.Number OrderNumber,d.DeliverDate
from tbSelfOrder a
left outer join tbSelfOrderItem d on a.BillNo=d.BillNo
left outer join
(
--仓库调拨单
select cc.ProductCode,cc.ProductSortCode,SrcBillNo,dd.BillNo RedeployNo,dd.ConfirmDate,dd.TheDate RedeployDate,sum(cc.Number) SureNumber,cc.RedeployInStorage,cc.RedeployInPlace
from tbStorRedeployItem cc
left outer join tbStorRedeploy dd on cc.BillNo = dd.BillNo
where dbo.GetByteToBoolean(dd.TheState,0x0001)=1 and dd.SrcBillSort = 1
group by cc.ProductCode,cc.ProductSortCode,cc.SrcBillNo,dd.BillNo,dd.ConfirmDate,dd.TheDate,cc.RedeployInStorage,cc.RedeployInPlace
union all
--加盟配送单
select cc.ProductCode,cc.ProductSortCode,SrcBillNo,dd.BillNo RedeployNo,dd.ConfirmDate,dd.TheDate RedeployDate,sum(cc.Number) SureNumber,cc.RedeployInStorage,cc.RedeployInPlace
from tbStorRedeployLeagueItem cc
left outer join tbStorRedeployLeague dd on cc.BillNo = dd.BillNo
where dbo.GetByteToBoolean(dd.TheState,0x0001)=1 and dd.SrcBillSort = 1
group by cc.ProductCode,cc.ProductSortCode,cc.SrcBillNo,dd.BillNo,dd.ConfirmDate,dd.TheDate,cc.RedeployInStorage,cc.RedeployInPlace
)e on a.BillNo=e.SrcBillNo and d.ProductCode=e.ProductCode and d.ProductSortCode=e.ProductSortCode
--辅助信息
left outer join vDatumStorPlace b on e.RedeployInStorage = b.TheCode and e.RedeployInPlace = b.StorPlaceCode
left outer join vDatumProduct c on d.ProductCode = c.TheCode and d.ProductSortCode = c.ProductSort
where dbo.GetByteToBoolean(a.TheState,0x0001)=1 and e.RedeployInStorage in {{StorageGroup}} {0}
创建时间:2007-09-13
创 建 人:szj
参 考:
功 能: 门店订货单执行明细表(仓库调拨单和加盟配送单)
修 改:
具 体:
备 注:
*/-------------------------------------------------
select a.BillNo,a.TheDate,e.*,b.TheName StorageName,b.ShopName,b.StorPlaceName,c.TheName ProductName,c.ConfigName,c.UnitName,
d.ProductCode,d.ProductSortCode,d.Number OrderNumber,d.DeliverDate
from tbSelfOrder a
left outer join tbSelfOrderItem d on a.BillNo=d.BillNo
left outer join
(
--仓库调拨单
select cc.ProductCode,cc.ProductSortCode,SrcBillNo,dd.BillNo RedeployNo,dd.ConfirmDate,dd.TheDate RedeployDate,sum(cc.Number) SureNumber,cc.RedeployInStorage,cc.RedeployInPlace
from tbStorRedeployItem cc
left outer join tbStorRedeploy dd on cc.BillNo = dd.BillNo
where dbo.GetByteToBoolean(dd.TheState,0x0001)=1 and dd.SrcBillSort = 1
group by cc.ProductCode,cc.ProductSortCode,cc.SrcBillNo,dd.BillNo,dd.ConfirmDate,dd.TheDate,cc.RedeployInStorage,cc.RedeployInPlace
union all
--加盟配送单
select cc.ProductCode,cc.ProductSortCode,SrcBillNo,dd.BillNo RedeployNo,dd.ConfirmDate,dd.TheDate RedeployDate,sum(cc.Number) SureNumber,cc.RedeployInStorage,cc.RedeployInPlace
from tbStorRedeployLeagueItem cc
left outer join tbStorRedeployLeague dd on cc.BillNo = dd.BillNo
where dbo.GetByteToBoolean(dd.TheState,0x0001)=1 and dd.SrcBillSort = 1
group by cc.ProductCode,cc.ProductSortCode,cc.SrcBillNo,dd.BillNo,dd.ConfirmDate,dd.TheDate,cc.RedeployInStorage,cc.RedeployInPlace
)e on a.BillNo=e.SrcBillNo and d.ProductCode=e.ProductCode and d.ProductSortCode=e.ProductSortCode
--辅助信息
left outer join vDatumStorPlace b on e.RedeployInStorage = b.TheCode and e.RedeployInPlace = b.StorPlaceCode
left outer join vDatumProduct c on d.ProductCode = c.TheCode and d.ProductSortCode = c.ProductSort
where dbo.GetByteToBoolean(a.TheState,0x0001)=1 and e.RedeployInStorage in {{StorageGroup}} {0}
- 相关联的表,除了主键外其它相关处理(商品信息).a.BillNo=e.SrcBillNo and d.ProductCode=e.ProductCode and d.ProductSortCode=e.ProductSortCode
- String s = "a" + "b" + "c" + "d" + "e"对象问题
- String s = a+b+c+d+e;创建了几个对象的详细分析?
- String s = a+b+c+d+e;创建了几个对象的详细分析?
- String s = a+b+c+d+e;创建了几个对象的详细分析?
- String s = a+b+c+d+e;创建了几个对象的详细分析?
- String s = a+b+c+d+e;创建了几个对象的详细分析?
- String s = a+b+c+d+e;创建了几个对象的详细分析?
- D o t N e t 相关资源 [更新中]
- D o t N e t 相关资源
- UVa - 11175 - From D to E and Back
- UVa 11175:From D to E and back(图论)
- Codeforces Round #432 (Div. 2) D. Arpa and a list of numbers E. Arpa and a game with Mojtaba
- Codeforces Round #353 (Div. 2) E. Trains and Statistic(求d[i][j]的和的最小值(1<=i<=n,i+1<=j<=n))
- 用 map 输出一定格式的字符串Plain=w=b~|~t=e~|~e=c~|~r=d~|~q=a
- sql:A表的D字段就是B表的E字段,D字段的值覆盖到E字段,只覆盖E字段为空的
- a w e a s d f
- a[s++] = a[e]
- 外理多值查询,同时相关业务的复杂处理
- 数据驱动在QTP中的运用(四) - 使用SQL数据库
- 众名家谈程序员职业规划
- 作业二
- CLR 调试器和 Visual Studio 调试器之间的一些主要区别
- 相关联的表,除了主键外其它相关处理(商品信息).a.BillNo=e.SrcBillNo and d.ProductCode=e.ProductCode and d.ProductSortCode=e.ProductSortCode
- Windows 中"另存为" 浏览时,文件夹中 默认的排序为倒序(逆序,顺序都反过来了)
- 启用远程调试的方法
- 中间件
- 作业二
- 面向对象
- asp.net与mysql连接
- 结构化方法
- The Inventor Mentor-第十章 处理事件和选择器