declare @OrderNo nvarchar(30) =''
declare @InvoiceDetailID int =0
declare @BOMHeaderID int =275963select sdc.InvoiceDetailID,isn1.DoorParm_72 as OrderNo,isnull(sdc.DoorFrameCount,0) DoorFrameCount,isnull(sdc.DoorFanCount,0) DoorFanCount,isnull(sdc.DoorWaist,0) DoorWaist
,isnull(sdc.DoorFitting,0) DoorFitting,isnull(sdc.DoorGlass,0) DoorGlass
,(isnull(sdc.DoorFrameCount,0) + isnull(sdc.DoorFanCount,0) + isnull(sdc.DoorWaist,0) + isnull(sdc.DoorFitting,0) + isnull(sdc.DoorGlass,0) ) TotalCount
from SMInvoiceDetailCustom AS sdc
left join (select isn.InvoiceDetailID,isn.BOMHeaderID,mpcv.DoorParm_72
from IMSN AS isn inner join MMBOMHeaderParmColumnValue as mpcv on isn.BOMHeaderID=mpcv.BOMHeaderID
where isn.SNProjectID = 4) AS isn1 on isn1.InvoiceDetailID = sdc.InvoiceDetailID
where (0=(case when isnull(@OrderNo,'') !='' then 1 else 0 end) or isn1.DoorParm_72 = @OrderNo)
and (0=(case when isnull(@InvoiceDetailID,0) !=0 then 1 else 0 end) or sdc.InvoiceDetailID = @InvoiceDetailID)
and (0=(case when isnull(@BOMHeaderID,0) !=0 then 1 else 0 end) or isn1.BOMHeaderID = @BOMHeaderID)group by sdc.InvoiceDetailID,isn1.BOMHeaderID,isn1.DoorParm_72
,isnull(sdc.DoorFrameCount,0),isnull(sdc.DoorFanCount,0),isnull(sdc.DoorWaist,0),isnull(sdc.DoorFitting,0),isnull(sdc.DoorGlass,0)
绑定上去时,直接报错误:难道说,一个变量,只能绑定一个位置?多个位置不允许绑定啊,无语
解决方案 »
- winform程序部署之后一运行就出现控制台窗口
- 统计题,高手请出手
- 数据库的一个空集问题
- VS2005制作的水晶报表条码,39码可以扫描,128条码扫描不了,晕死
- 哪里有C#写的论坛源代码下载,最好菜单是树型控件那种,如天涯论坛或者是网易论坛
- 二个datalist控件嵌套问题?
- 为什么继承到第一层就继承不了上一层的方法!!!<简单示例>在线等……
- 如何在两个Access数据库的两个表之间创建查询?
- 弱弱的问一下,2005里面怎么建ASP.NET Web的应用程序啊?2003里直接有这个
- 请教一个问题,关于如何区分T和List<T>
- devExpress button 控件修改text属性为中文,整个vs 软件就崩溃
- WinForm窗体包含DataGridView继承后不能修改吗
问题已经解决了,是脚本写的有点问题。既然写了别名,就肯定会以别名为主的,关键问题是,我想了解一下:(0=(case when isnull(@OrderNo,'') !='' then 1 else 0 end) or isn1.DoorParm_72 = @OrderNo)类似于这样的脚本,变量存在多处位置,能不能用SqlParameter[] 参数代入。我不太明白其原理,还请求教