资源描述：
《产成品入库产出明细》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。
1、产成品入库产出明细CREATEPROCEDURESP_CCCP_MX(--条件参数@chrWherevarchar(1000))AS--------------------------产成品入库产出明细chenhui---------------------declare@cbDatenvarchar(10)--开始日期declare@ceDatenvarchar(10)--结束日期declare@cbrkdnvarchar(30)--起始入库单号declare@cerkdnvarchar(30)--结束入库单号Declare@cbdepcodevarchar(20)--起始部门编码D
2、eclare@cedepcodevarchar(20)--结束部门编码Declare@cbeqcodevarchar(20)--起始设备编码Declare@ceeqcodevarchar(20)--结束设备编码Declare@cbinvvarchar(20)--起始存货编码Declare@ceinvvarchar(20)--结束存货编码Declare@cbclcodevarchar(20)--起始材料编码Declare@ceclcodevarchar(20)--结束材料编码declare@chrSqlvarchar(8000)declare@A1int,@A2int,@B1int,@B
3、2int,@C1int,@C2int,@D1int,@D2int,@E1int,@E2int,@F1int,@F2intIF@cbdateisnullSET@cbdate='2005-10-01'IF@cedateisnullSET@cedate='2099-12-31'IF@cbrkdisnullSET@cbrkd=''IF@cerkdisnullSET@cerkd='zzzzzzzzzzzzzzzzzzzzzzzzzzzzzz'IF@cbdepcodeisnullSET@cbdepcode=''IF@cedepcodeisnullSET@cedepcode='zzzzzzzzzzz
4、zzzzzzzzz'IF@cbeqcodeisnullSET@cbeqcode=''IF@ceeqcodeisnullSET@ceeqcode='zzzzzzzzzzzzzzzzzzzz'IF@cbinvisnullSET@cbinv=''IF@ceinvisnullSET@ceinv='zzzzzzzzzzzzzzzzzzzz'IF@cbclcodeisnullSET@cbclcode=''IF@ceclcodeisnullSET@ceclcode='zzzzzzzzzzzzzzzzzzzz'--获取条件IfLtrim(Rtrim(@chrwhere))<>''beginset@ch
5、rWhere=replace(@chrWhere,'cdate>=N','cdate>=')set@chrWhere=replace(@chrWhere,'cdate<=N','cdate<=')set@chrWhere=replace(@chrWhere,'crkd>=N','crkd>=')set@chrWhere=replace(@chrWhere,'crkd<=N','crkd<=')set@chrWhere=replace(@chrWhere,'cdep>=N','cdep>=')set@chrWhere=replace(@chrWhere,'cdep<=N','cdep<=
6、')set@chrWhere=replace(@chrWhere,'ceqcode>=N','ceqcode>=')set@chrWhere=replace(@chrWhere,'ceqcode<=N','ceqcode<=')set@chrWhere=replace(@chrWhere,'cinv>=N','cinv>=')set@chrWhere=replace(@chrWhere,'cinv<=N','cinv<=')set@chrWhere=replace(@chrWhere,'cclcode>=N','cclcode>=')set@chrWhere=replace(@chrW
7、here,'cclcode<=N','cclcode<=')SET@A1=charindex('cdate>=',@chrWhere)+8SET@A2=charindex('cdate<=',@chrWhere)+8SET@B1=charindex('crkd>=',@chrWhere)+7SET@B2=charindex('crkd<=',@chrWhere)+7SET@C1=charindex('cdep>=',@chrWhere)+7SE
