CREATE PROCEDURE [pr_zs_reprint]
@dzhm varchar(9)
AS
SET NOCOUNT ON
DECLARE @sqlstr varchar(3000),@khmc varchar(30),@khdm varchar(9)
SELECT @err=0
SELECT @khdm= '(SELECT kh_dm FROM dzd WHERE dz_hm=@dzhm)'
SELECT @khmc= '(SELECT kh_mc FROM khdm WHERE kh_dm=@khdm)'
SELECT @sqlstr='SELECT md_dm,zs_rq,fp_hm,yw_rq,sum(jj_je) AS jh_je,sum(jj_sj) AS jh_sj INTO #'+ @dzhm +' FROM pludz WHERE dz_hm='''+@dzhm+''' GROUP BY md_dm,zs_rq,fp_hm,yw_rq
SELECT a.md_dm,b.kh_mc as md_mc,a.zs_rq,a.fp_hm,a.yw_rq,a.jh_je,a.jh_sj,'''+@khdm+''' as kh_dm,'''+@khmc+''' as kh_mc FROM #'+ @dzhm +' AS a LEFT OUTER JOIN khdm as b ON a.md_dm=b.kh_dm ORDER BY a.md_dm,a.zs_rq,a.fp_hm,a.yw_rq'
-- 此储存过程执行重新打印已打印的对帐单功能
-- @dzhm 需要打印的对帐单号码
CREATE PROCEDURE [pr_zs_reprint]
@dzhm varchar(9)
AS
SET NOCOUNT ON
DECLARE @sqlstr varchar(300),@khmc varchar(30),@khdm varchar(9)
SELECT @err=0
SELECT @sqlstr='SELECT md_dm,zs_rq,fp_hm,yw_rq,sum(jj_je) AS jh_je,sum(jj_sj) AS jh_sj INTO #'+ @dzhm +' FROM pludz WHERE dz_hm='''+@dzhm+''' GROUP BY md_dm,zs_rq,fp_hm,yw_rq'
EXEC (@sqlstr)
SELECT @khdm= (SELECT kh_dm FROM dzd WHERE dz_hm=@dzhm)
SELECT @khmc= (SELECT kh_mc FROM khdm WHERE kh_dm=@khdm)
SELECT @sqlstr='SELECT a.md_dm,b.kh_mc as md_mc,a.zs_rq,a.fp_hm,a.yw_rq,a.jh_je,a.jh_sj,'''+@khdm+''' as kh_dm,'''+@khmc+''' as kh_mc FROM #'+ @dzhm +' AS a LEFT OUTER JOIN khdm as b ON a.md_dm=b.kh_dm ORDER BY a.md_dm,a.zs_rq,a.fp_hm,a.yw_rq'
EXEC (@sqlstr)
END