글 수 7,449
조회 수 : 79344
2006.10.25 (00:12:54)
잘 됩니다.
빠른 답변 감사 드립니다.
수고 하세요.
>게시판을 이용해 주셔서 감사합니다.
>다음양식에 맞게 입력해주세요.
>
>* 고객시스템명 : LG CNS
>* GAUCE 버전 : 3.5
>* WAS 종류(WebLogic 등등) : 8.x
>* DB 종류 : Oracle 9i
>* 문의 유형(질문/요청/참조) : 질문
>* 내용 : 수제건과 같이 SubSumText 를 subsum 라인별 표현하고 싶습니다.
>
>아래는 소스이고 소스가 너무길어 필요 부분만 첨부 합니다.
>
>=== 아 래 ===
>
>function f_gridHeaderSet() {
> var currentMonth = eme_currentMonth.text.substring(4,6);
> gr_inventoryTurnoverRatio.format = ''
> +'<fc> id=branchName name="LG Office" sort=true width=78 align=center HeadBgColor=#F7F7EF, HeadColor=Black, suppress="7", SubSumText="Sub Total", SumText="Grand Total", SumColor="Black", SumBgColor="#F7F7EF"</fc>'
> +'<fc> id=agentName name="Agent" sort=true width=70 align=center HeadBgColor=#F7F7EF, HeadColor=Black, suppress="6", SubSumText="", SumColor="Black", SumBgColor="#F7F7EF"</fc>'
> +'<fc> id=product name="Product" sort=true width=80 align=left HeadBgColor=#F7F7EF, HeadColor=Black, suppress="5", SubSumText="", value={decode(product,""," ",product)}, SumColor="Black", SumBgColor="#F7F7EF"</fc>'
> +'<fc> id=productLine name="Product;Line" sort=true width=80 align=left HeadBgColor=#F7F7EF, HeadColor=Black, suppress="4", SubSumText="", value={decode(productLine,""," ",productLine)} show=false, SumColor="Black", SumBgColor="#F7F7EF"</fc>'
> +'<fc> id=shipFrom name="Ship;From" sort=true width=55 align=left HeadBgColor=#F7F7EF, HeadColor=Black, suppress="3", SubSumText="", value={decode(shipFrom,""," ",shipFrom)} show=false, SumColor="Black", SumBgColor="#F7F7EF"</fc>'
> +'<fc> id=gblModelAndGblSuffix name="Global Model.Suffix" sort=true width=140 align=left HeadBgColor=#F7F7EF, HeadColor=Black, suppress="2", SubSumText="", SumColor="Black", SumBgColor="#F7F7EF"</fc>'
> +'<fc> id=agentModel name="Agent Model" sort=true width=100 align=left HeadBgColor=#F7F7EF, HeadColor=Black, suppress="1", SubSumText="", SumColor="Black", SumBgColor="#F7F7EF"</fc>'
> +'<fc> id=monthCurrent name="Current("'+currentMonth+'")" width=80 align=reight HeadBgColor=#F7F7EF, HeadColor=Black, dec=0 gte_columntype="number:0:true", SumColor="Black", SumBgColor="#F7F7EF", SumText=@sum</fc>'
> +'<c> id=month01 name=1M width=50 align=reight HeadBgColor=#F7F7EF, HeadColor=Black, dec=0 gte_columntype="number:0:true", SumColor="Black", SumBgColor="#F7F7EF", SumText=@sum</c>'
> +'<c> id=month02 name=2M width=50 align=reight HeadBgColor=#F7F7EF, HeadColor=Black, dec=0 gte_columntype="number:0:true", SumColor="Black", SumBgColor="#F7F7EF", SumText=@sum</c>'
> +'<c> id=month03 name=3M width=50 align=reight HeadBgColor=#F7F7EF, HeadColor=Black, dec=0 gte_columntype="number:0:true", SumColor="Black", SumBgColor="#F7F7EF", SumText=@sum</c>'
> +'<c> id=month04 name=4M width=50 align=reight HeadBgColor=#F7F7EF, HeadColor=Black, dec=0 gte_columntype="number:0:true", SumColor="Black", SumBgColor="#F7F7EF", SumText=@sum</c>'
> +'<c> id=month05 name=5M width=50 align=reight HeadBgColor=#F7F7EF, HeadColor=Black, dec=0 gte_columntype="number:0:true", SumColor="Black", SumBgColor="#F7F7EF", SumText=@sum</c>'
> +'<c> id=month06 name=6M width=50 align=reight HeadBgColor=#F7F7EF, HeadColor=Black, dec=0 gte_columntype="number:0:true", SumColor="Black", SumBgColor="#F7F7EF", SumText=@sum</c>'
> +'<c> id=month09 name=9M width=50 align=reight HeadBgColor=#F7F7EF, HeadColor=Black, dec=0 gte_columntype="number:0:true", SumColor="Black", SumBgColor="#F7F7EF", SumText=@sum</c>'
> +'<c> id=month12 name=12M width=50 align=reight HeadBgColor=#F7F7EF, HeadColor=Black, dec=0 gte_columntype="number:0:true", SumColor="Black", SumBgColor="#F7F7EF", SumText=@sum</c>'
> +'<c> id=month12Over name="12M ~" width=50 align=reight HeadBgColor=#F7F7EF, HeadColor=Black, dec=0 gte_columntype="number:0:true", SumColor="Black", SumBgColor="#F7F7EF", SumText=@sum</c>';
> +'<h> id=modelMapId name="ModelMapId" width=50 align=left HeadBgColor=#F7F7EF, HeadColor=Black, SumColor="Black", SumBgColor="#F7F7EF"</h>'
> gr_inventoryTurnoverRatio.dataid = "ds_inventoryAsing";
>}
>
><!-----------------------------------------------------------------------------
> Dataset Components Declaration
>------------------------------------------------------------------------------>
><!-- 재고 월 DataSet -->
><object id="ds_inventoryAsing" classid="<%=LGauceId.DATASET%>">
> <param name=SubsumExpr value="3:branchName,2:agentName,1:product">
> <param name=SyncLoad value=true >
></object>
>
>위의 소스에서 grid 컴포넌트에서 데이터를 보여줄때 SubsumExpr의 value 값에서 3, 2, 1 의 값을 알아내어
>'<fc> id=branchName name="LG Office" sort=true width=78 align=center HeadBgColor=#F7F7EF, HeadColor=Black, suppress="7", SubSumText={decode(???,3,"Sub Total","") , SumText="Grand Total", SumColor="Black", SumBgColor="#F7F7EF"</fc>'
>이런식으로 현현하고 싶습니다. 물론 ???는 제가 모르는 것이기에 물음표 처리 하였습니다.
>
빠른 답변 감사 드립니다.
수고 하세요.
>게시판을 이용해 주셔서 감사합니다.
>다음양식에 맞게 입력해주세요.
>
>* 고객시스템명 : LG CNS
>* GAUCE 버전 : 3.5
>* WAS 종류(WebLogic 등등) : 8.x
>* DB 종류 : Oracle 9i
>* 문의 유형(질문/요청/참조) : 질문
>* 내용 : 수제건과 같이 SubSumText 를 subsum 라인별 표현하고 싶습니다.
>
>아래는 소스이고 소스가 너무길어 필요 부분만 첨부 합니다.
>
>=== 아 래 ===
>
>function f_gridHeaderSet() {
> var currentMonth = eme_currentMonth.text.substring(4,6);
> gr_inventoryTurnoverRatio.format = ''
> +'<fc> id=branchName name="LG Office" sort=true width=78 align=center HeadBgColor=#F7F7EF, HeadColor=Black, suppress="7", SubSumText="Sub Total", SumText="Grand Total", SumColor="Black", SumBgColor="#F7F7EF"</fc>'
> +'<fc> id=agentName name="Agent" sort=true width=70 align=center HeadBgColor=#F7F7EF, HeadColor=Black, suppress="6", SubSumText="", SumColor="Black", SumBgColor="#F7F7EF"</fc>'
> +'<fc> id=product name="Product" sort=true width=80 align=left HeadBgColor=#F7F7EF, HeadColor=Black, suppress="5", SubSumText="", value={decode(product,""," ",product)}, SumColor="Black", SumBgColor="#F7F7EF"</fc>'
> +'<fc> id=productLine name="Product;Line" sort=true width=80 align=left HeadBgColor=#F7F7EF, HeadColor=Black, suppress="4", SubSumText="", value={decode(productLine,""," ",productLine)} show=false, SumColor="Black", SumBgColor="#F7F7EF"</fc>'
> +'<fc> id=shipFrom name="Ship;From" sort=true width=55 align=left HeadBgColor=#F7F7EF, HeadColor=Black, suppress="3", SubSumText="", value={decode(shipFrom,""," ",shipFrom)} show=false, SumColor="Black", SumBgColor="#F7F7EF"</fc>'
> +'<fc> id=gblModelAndGblSuffix name="Global Model.Suffix" sort=true width=140 align=left HeadBgColor=#F7F7EF, HeadColor=Black, suppress="2", SubSumText="", SumColor="Black", SumBgColor="#F7F7EF"</fc>'
> +'<fc> id=agentModel name="Agent Model" sort=true width=100 align=left HeadBgColor=#F7F7EF, HeadColor=Black, suppress="1", SubSumText="", SumColor="Black", SumBgColor="#F7F7EF"</fc>'
> +'<fc> id=monthCurrent name="Current("'+currentMonth+'")" width=80 align=reight HeadBgColor=#F7F7EF, HeadColor=Black, dec=0 gte_columntype="number:0:true", SumColor="Black", SumBgColor="#F7F7EF", SumText=@sum</fc>'
> +'<c> id=month01 name=1M width=50 align=reight HeadBgColor=#F7F7EF, HeadColor=Black, dec=0 gte_columntype="number:0:true", SumColor="Black", SumBgColor="#F7F7EF", SumText=@sum</c>'
> +'<c> id=month02 name=2M width=50 align=reight HeadBgColor=#F7F7EF, HeadColor=Black, dec=0 gte_columntype="number:0:true", SumColor="Black", SumBgColor="#F7F7EF", SumText=@sum</c>'
> +'<c> id=month03 name=3M width=50 align=reight HeadBgColor=#F7F7EF, HeadColor=Black, dec=0 gte_columntype="number:0:true", SumColor="Black", SumBgColor="#F7F7EF", SumText=@sum</c>'
> +'<c> id=month04 name=4M width=50 align=reight HeadBgColor=#F7F7EF, HeadColor=Black, dec=0 gte_columntype="number:0:true", SumColor="Black", SumBgColor="#F7F7EF", SumText=@sum</c>'
> +'<c> id=month05 name=5M width=50 align=reight HeadBgColor=#F7F7EF, HeadColor=Black, dec=0 gte_columntype="number:0:true", SumColor="Black", SumBgColor="#F7F7EF", SumText=@sum</c>'
> +'<c> id=month06 name=6M width=50 align=reight HeadBgColor=#F7F7EF, HeadColor=Black, dec=0 gte_columntype="number:0:true", SumColor="Black", SumBgColor="#F7F7EF", SumText=@sum</c>'
> +'<c> id=month09 name=9M width=50 align=reight HeadBgColor=#F7F7EF, HeadColor=Black, dec=0 gte_columntype="number:0:true", SumColor="Black", SumBgColor="#F7F7EF", SumText=@sum</c>'
> +'<c> id=month12 name=12M width=50 align=reight HeadBgColor=#F7F7EF, HeadColor=Black, dec=0 gte_columntype="number:0:true", SumColor="Black", SumBgColor="#F7F7EF", SumText=@sum</c>'
> +'<c> id=month12Over name="12M ~" width=50 align=reight HeadBgColor=#F7F7EF, HeadColor=Black, dec=0 gte_columntype="number:0:true", SumColor="Black", SumBgColor="#F7F7EF", SumText=@sum</c>';
> +'<h> id=modelMapId name="ModelMapId" width=50 align=left HeadBgColor=#F7F7EF, HeadColor=Black, SumColor="Black", SumBgColor="#F7F7EF"</h>'
> gr_inventoryTurnoverRatio.dataid = "ds_inventoryAsing";
>}
>
><!-----------------------------------------------------------------------------
> Dataset Components Declaration
>------------------------------------------------------------------------------>
><!-- 재고 월 DataSet -->
><object id="ds_inventoryAsing" classid="<%=LGauceId.DATASET%>">
> <param name=SubsumExpr value="3:branchName,2:agentName,1:product">
> <param name=SyncLoad value=true >
></object>
>
>위의 소스에서 grid 컴포넌트에서 데이터를 보여줄때 SubsumExpr의 value 값에서 3, 2, 1 의 값을 알아내어
>'<fc> id=branchName name="LG Office" sort=true width=78 align=center HeadBgColor=#F7F7EF, HeadColor=Black, suppress="7", SubSumText={decode(???,3,"Sub Total","") , SumText="Grand Total", SumColor="Black", SumBgColor="#F7F7EF"</fc>'
>이런식으로 현현하고 싶습니다. 물론 ???는 제가 모르는 것이기에 물음표 처리 하였습니다.
>
http://member.shift.co.kr/index.php?document_srl=233259
(*.247.145.11)
|
|
