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)
绑定上去时,直接报错误:难道说,一个变量,只能绑定一个位置?多个位置不允许绑定啊,无语
解决方案 »
- c#字符串提取
- 点群分布轴(直)线计算
- 急,tlbimp.exe 使用问题,马上解决,马上给分
- C#做的画图程序刷新时闪得厉害,如何解决
- 异常处理
- 类中方法参数性质提示
- 能否使用Acrobat.dll在IIS容器中进行pdf转图片操作呢
- 用HttpWebRequest post之后得不到回应,帮帮忙。
- 我用VC#编写的源代码调试几次过后、发现代码缩进方式改变还出现了一些乱码、请问该如何修改
- 想问一下大家用C#写win form的有多少,有什么好的书或资料
- devExpress button 控件修改text属性为中文,整个vs 软件就崩溃
- WinForm窗体包含DataGridView继承后不能修改吗
问题已经解决了,是脚本写的有点问题。既然写了别名,就肯定会以别名为主的,关键问题是,我想了解一下:(0=(case when isnull(@OrderNo,'') !='' then 1 else 0 end) or isn1.DoorParm_72 = @OrderNo)类似于这样的脚本,变量存在多处位置,能不能用SqlParameter[] 参数代入。我不太明白其原理,还请求教