<div dir="ltr"><div>$B$3$s$K$A$O!"(Btaknb2nch$B$G$9!#(B</div><div><br></div><div>$B;d$b$I$l$,@52r$+$H8@$o$l$k$H<+?.$,$"$j$^$;$s$,!"(B</div><div>$B$3$A$i$K$b$"$j$^$9$h$&$K!"(B</div><div><a href="http://dbflute.net.sandbox.seasar.org/ja/introduction/index.html#methodinit">http://dbflute.net.sandbox.seasar.org/ja/introduction/index.html#methodinit</a></div> <div>$B!V30$@$7(BSQL$B$N%Q%i%a!<%?%3%a%s%H>e$G$N%W%m%Q%F%#$N;2>H$O(B...$BCm0U$,I,MW$G$9!#!W(B</div><div>$B$H=q$+$l$F$"$j$^$9!#(B</div><div><br></div><div>$B$^$?(BParameterBean$B$NDj5A$K$D$$$F$O!"(B</div><div><a href="https://www.seasar.org/svn/sandbox/dbflute.net/trunk/dfnet-basic-example/source/DfExample/DBFlute/ExBhv/">https://www.seasar.org/svn/sandbox/dbflute.net/trunk/dfnet-basic-example/source/DfExample/DBFlute/ExBhv/</a></div> <div>$B$N%5%s%W%k!J(Bsql$B%U%!%$%k!K$r8+$F$_$^$9$H!"(B</div><div>$B%U%#!<%k%I!J%a%s%PJQ?t!K$N$h$&$K@hF,$O>.J8;z$GDj5A$5$l$F$$$^$9!#(B</div><div><br></div><div>$B$G$9$N$G;d$O!"(B</div><div>ParameterBean$B$NDj5A$O@hF,>.J8;z!"(B</div><div>ParameterBean$B$N%W%m%Q%F%#$r;2>H$9$kItJ,$O@hF,BgJ8;z!"(B</div><div>$B$r;HMQ$7$F$$$^$9!#(B</div><div><br></div> </div><div class="gmail_extra"><br><br><div class="gmail_quote">2013$BG/(B10$B7n(B24$BF|(B 19:23 $B;V?e@59,(B <span dir="ltr"><<a href="mailto:ie2m-smz@asahi-net.or.jp" target="_blank">ie2m-smz@asahi-net.or.jp</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"> $B$3$s$K$A$O!#$*@$OC$K$J$C$F$$$^$9!#(B<br> $B;V?e$H?=$7$^$9!#(B<br> <br> 2WaySQL$B$N5-=RJ}K!$J$N$G$9$,!"(B<br> $B$h$/!"@bL@$bFI$^$:$K:n$C$F$7$^$C$?;d$b0-$$$N$G$9$,!"(B<br> DBFLUTE$B$N!V%Q%i%a!<%?%3%a%s%H!W$G$O!"N>J}$H$b>.J8;z$J$s$G$9$h$M!A!#(B<br> $B$7$+$7JL$N=q$-J}$G$bF0$/$s$G$9!#(B<br> $B$G$b!"$9$3$7=q$-J}$,0c$&$HF0$+$J$$>l9g$b$"$k$s$G$9!#(B<br> $B2?$,@5<0$J5-=RJ}K!$J$N$+!"$h$/$o$+$i$J$/$J$C$F$7$^$$$^$7$?!#(B<br> $B$^$!F0$$$F$$$k$C$]$$$N$G%$%$$H8@$($P$=$l$^$G$J$s$G$9$,!&!&!&(B<br> $B$J$s$+5$;}$A0-$$$N$G!"65$($F$/$@$5$$!#(B<br> <br> $B0J2<$N!c;29M(BSQL$B!d!JE,Ev$J(BSQL$B$J$N$G9=J8$*$+$7$$$+$b!K$h$&$J5-=R$r$7$F<B9T$7$?$H$3$m!"(B<br> $B>r7oItJ,$N!V(Bpmb.misecd$B!W$KCM$rF~$l$F$$$F$bL5;k$5$l$F$$$k>uBV$K$J$j$^$7$?!#(B<br> $B!!!d!d(B/*IF pmb.misecd != null*/T_SIWAKE.misecd_cd = /*pmb.misecd*/'110001'/*END*/<br> $BL5;k$5$l$F$$$k$N$G$*$+$7$$$H;W$$!"0J2<$N$h$&$KB>$N>r7o$HF1$8$h$&$K(Bpmb$BJQ?t$NF,J8;z$rBgJ8;z$K(B<br> $BJQ99$7$?$H$3$mG'<1$5$l$k$h$&$K$J$j$^$7$?!#(B<br> $B!!!d!d(B/*IF pmb.Misecd != null*/T_SIWAKE.misecd_cd = /*pmb.Misecd*/'110001'/*END*/<br> <br> $B$^$?!"JL$N(BSQL$B$G$O!"(B<br> $B2<5-$N$h$&$K@k8@ItJ,$N(Bpmb$BJQ?t$NF,J8;z$bBgJ8;z$G!"3n$D(B<br> SQL$BFb$N(Bpmb$BJQ?t$NF,J8;z$bBgJ8;z$N>l9g$b$&$^$/F0:n$7$F$$$^$9!#(B<br> -- !df:pmb extends Paging!<br> -- !!String Misecd!!<br> -- !!String Syubetucd!!<br> -- !!String Nendo!!<br> <br> <br> $B!c7kO@!d(B<br> $B!&@k8@ItJ,$O!"F,J8;z$OBgJ8;z$G$b>.J8;z$G$b4X78$J$7(B<br> $B!&(BSQL$B>r7oFb$O!"F,J8;z$OBgJ8;z$b$7$/$O>.J8;z$G$=$m$($J$$$H%@%a(B<br> $B!!(B⇒SQL$B>r7oFb$G:.:_$O%@%a(B<br> $B!&@k8@ItJ,$N(Bpmb$BJQ?t$NF,J8;z$,>.J8;z$G$b(BSQL$B>r7oFb$G$N(Bpmb$BJQ?t$OBgJ8;z$G$b(BOK$B!#(B<br>  $B$3$s$J46$8$@$H;W$&$N$G$9$,!"$I$&$G$7$g$&$+!)(B<br> <br> $B0J>e!"59$7$/$*4j$$$7$^$9!#(B<br> <br> *--$B!c;29M(BSQL$B!d(B---------------------------------------------------------------------------*<br> -- #xxxxxxxxSQL#<br> <br> -- !df:pmb extends Paging!<br> -- !!String misecd!!<br> -- !!String syubetucd!!<br> -- !!String nendo!!<br> <br> SELECT T_XXXXX.misecd, SUM(NVL(T_XXXXX.KIN,0)) AS KIN, SUM(NVL(T_XXXXX.TAX,0)) AS TAX<br> ,TRUNC(T_XXXXX.TOROKU_YMD,'MM') AS TOROKU_YMD<br>  FROM T_XXXXX<br> /*BEGIN*/WHERE<br> /*IF pmb.misecd != null*/T_SIWAKE.misecd_cd = /*pmb.misecd*/'110001'/*END*/<br> /*IF pmb.Syubetucd != null*/AND T_XXXXX.kaikei_cd = /*pmb.Syubetucd*/'03'/*END*/<br> /*IF pmb.Nendo != null*/AND T_XXXXX.nendo = /*pmb.Nendo*/'2013'/*END*/<br> /*END*/<br> GROUP BY T_XXXXX.misecd,TRUNC(T_XXXXX.TOROKU_YMD,'MM')<br> ORDER BY T_XXXXX.misecd,TRUNC(T_XXXXX.TOROKU_YMD,'MM')<br> <br> _______________________________________________<br> seasar-dotnet mailing list<br> <a href="mailto:seasar-dotnet@ml.seasar.org">seasar-dotnet@ml.seasar.org</a><br> <a href="https://ml.seasar.org/mailman/listinfo/seasar-dotnet" target="_blank">https://ml.seasar.org/mailman/listinfo/seasar-dotnet</a><br> </blockquote></div><br></div>