SQL语法 SELECT"zz_kjkmbmb"."zth","zz_kjkmbmb"."km_code","zz_kjkmbmb"."km_name","zz_kjkmbmb"."kmlb_code","zz_kjkmbmb"."kmxz_code","zz_kjkmbmb"."kmjb","zz_kjkmbmb"."sjkm","zz_kjkmbmb"."yefx_code","zz_kjkmbmb"."mjbj_code","zz_kjkmbmb"."sl_fzhs","zz_kjkmbmb"."sldw","zz_kjkmbmb"."bz_fzhs","zz_kjkmbmb"."dw_fzhs","zz_kjkmbmb"."bm_fzhs","zz_kjkmbmb"."zy_fzhs","zz_kjkmbmb"."sybj_code","zz_kjkmbmb"."tybj_code","zz_kmyeb"."zth","zz_kmyeb"."km_code","zz_kmyeb"."nkjqj","zz_kmyeb"."ykjqj","zz_kmyeb"."qcjfye","zz_kmyeb"."qcdfye","zz_kmyeb"."qcye","zz_kmyeb"."jffse","zz_kmyeb"."dffse","zz_kmyeb"."jflj","zz_kmyeb"."dflj","zz_kmyeb"."qmjfye","zz_kmyeb"."qmdfye","zz_kmyeb"."qmye"
FROM"zz_kjkmbmb","zz_kmyeb"
WHERE("zz_kjkmbmb"."zth"="zz_kmyeb"."zth")and("zz_kjkmbmb"."km_code"="zz_kmyeb"."km_code")and("zz_kjkmbmb"."zth"like:r_zth)AND("zz_k
论文范文http://www.chuibin.com/ myeb"."nkjqj"like:r_nkjqj)AND("zz_kmyeb"."ykjqj">=:r_ykjqj_min)AND("zz_kmyeb"."ykjqj"<=:r_ykjqj_max)AND("zz_kjkmbmb"."km_code"like:r_km_code)AND("zz_kjkmbmb"."km_name"like:r_km_name)AND("zz_kjkmbmb"."kmlb_code"like:r_kmlb_code)AND("zz_kjkmbmb"."mjbj_code"like:r_mjbj_code)AND("zz_kjkmbmb"."kmjb"like:r_kmjb)AND("zz_kjkmbmb"."kmxz_code"like:r_kmxz_code)AND("zz_kjkmbmb"."yefx_code"like:r_yefx_code)AND("zz_kjkmbmb"."sl_fzhs"like:r_sl_fzhs)AND("zz_kjkmbmb"."bz_fzhs"like:r_bz_fzhs)AND("zz_kjkmbmb"."dw_fzhs"like:r_dw_fzhs)AND("zz_kjkmbmb"."bm_fzhs"like:r_bm_fzhs)AND("zz_kjkmbmb"."zy_fzhs"like:r_zy_fzhs)AND("zz_kjkmbmb"."sybj_code"like:r_sybj_code)AND("zz_kjkmbmb"."tybj_code"like:r_tybj_code)AND"zz_kmyeb"."qmye">=:r_qmye_minAND"zz_kmyeb"."qmye"<=:r_qmye_max
列的编
辑属性 所选的下拉数据窗口 显示列 数据列
“zth”列 dw_zz_ztxxb_d ztmc zth
“yefx_code”列 dw_c_zz_yefx_d yefx_name yefx_code
“kmlb_code”列 dw_c_zz_kmlb_d kmlb_name kmlb_code
“kmxz_code”列 dw_c_zz_kmxz_d kmxz_name kmxz_code
“mjbj_code”列 dw_c_zz_mjbj_d mjbj_name mjbj_code
“sjkm”列 dw_zz_kjkmbmb_d kmxx km_code
全局函数说明
1. 创建全局函数gf_kmyebhz ()，如下表2-8-3所示。
表2-8-3 全局函数gf_kmyebhz的说明
项 目 说 明
函数名 gf_kmyebhz
作用 所有会计科目余额表汇总计算，用于会计科目余额初始化计算处理。
参数 名称 说明 类型
r_zth 指定账套号 string
r_nkjqj 指定年会计期间 string
r_ykjqj 指定月会计期间 string
脚本 string r_km_code,r_yefx_code
decimal r_qcye, r_qcjfye,r_qcdfye
//1、汇总一级会计科目余额
declare c1 cursor for
select zz_kmyeb.km_code,yefx_code from zz_kmyeb ,zz_kjkmbmb
where zz_kmyeb.zth=zz_kjkmbmb.zth and zz_kmyeb.km_code=zz_kjkmbmb.km_code
and zz_kmyeb.zth=:r_zth and nkjqj=:r_nkjqj and ykjqj=:r_ykjqj and kmjb=1 and mjbj_code='N' ;
open c1;
fetch c1 into :r_km_code,:r_yefx_code;
do while sqlca.sqlcode=0
select sum(qcjfye), sum(qcdfye) into :r_qcjfye , :r_qcdfye
from zz_kmyeb ,zz_kjkmbmb
where zz_kmyeb.zth=zz_kjkmbmb.zth and zz_kmyeb.km_code=zz_kjkmbmb.km_code
and zz_kmyeb.zth=:r_zth and nkjqj=:r_nkjqj and ykjqj=:r_ykjqj
and substring(zz_kmyeb.km_code,1,3)=:r_km_code and mjbj_code='Y' ;
CHOOSE CASE r_yefx_code
CASE '借'
r_qcye=r_qcjfye - r_qcdfye
上一页 [1] [2] [3] [4] [5] [6] [7] [8] [9] 下一页
账务处理系统会计科目初始余额管理模块 第3页下载如图片无法显示或论文不完整，请联系qq752018766
