게시판을 이용해 주셔서 감사합니다.
다음양식에 맞게 입력해주세요.
* 고객시스템명 : lgi-jit hub
* GAUCE 버전 : max
* WAS 종류(WebLogic 등등) : weblogic
* DB 종류 : oracle
* 문의 유형(질문/요청/참조) :
* 내용 : Grid 에서 수정 시 DisplayFormat 옵션을 주면 Edit 가 않됨니다. 답변 바랍니다
--> Value={DisplayFormat(qtCall,"#,##0")}
1.수정 필드
movpurch
movsales
movsalesl
fixpurch
fixsales
fixsalesl
2. Header------------------->
ds_grid Header:chk:STRING(1):NORMALTYPE:NORMALKEY,cdSoldto:STRING(6):NORMALTYPE:NORMALKEY,nmSoldto:STRING(4000):NORMALTYPE:NORMALKEY,noInvoice:STRING(25):NORMALTYPE:NORMALKEY,noPo:STRING(25):NORMALTYPE:NORMALKEY,noPart:STRING(25):NORMALTYPE:NORMALKEY,qtInv:DECIMAL(16.2):NORMALTYPE:NORMALKEY,qtCall:DECIMAL(7.3):NORMALTYPE:NORMALKEY,dtEtdPtLoad:STRING(8):NORMALTYPE:NORMALKEY,dtAtdPtLoad:STRING(8):NORMALTYPE:NORMALKEY,dtEtaPtDest:STRING(8):NORMALTYPE:NORMALKEY,dtAtaPtDest:STRING(8):NORMALTYPE:NORMALKEY,dtEtdPtDest:STRING(8):NORMALTYPE:NORMALKEY,dtAtdPtDest:STRING(8):NORMALTYPE:NORMALKEY,dtHubEta:STRING(8):NORMALTYPE:NORMALKEY,dtHubAta:STRING(8):NORMALTYPE:NORMALKEY,movpurch:DECIMAL(7.3):NORMALTYPE:NORMALKEY,movsales:DECIMAL(7.3):NORMALTYPE:NORMALKEY,movsalesl:DECIMAL(7.3):NORMALTYPE:NORMALKEY,diffprice:DECIMAL(7.3):NORMALTYPE:NORMALKEY,fixpurch:DECIMAL(7.3):NORMALTYPE:NORMALKEY,fixsales:DECIMAL(7.3):NORMALTYPE:NORMALKEY,fixsalesl:DECIMAL(7.3):NORMALTYPE:NORMALKEY,addinterpri:DECIMAL(7.3):NORMALTYPE:NORMALKEY,addinteramt:DECIMAL(7.3):NORMALTYPE:NORMALKEY,dtCalloffDead:STRING(8):NORMALTYPE:NORMALKEY,dtHubout:STRING(8):NORMALTYPE:NORMALKEY,dtaddhubout:STRING(8):NORMALTYPE:NORMALKEY,invoiceno:STRING(1):NORMALTYPE:NORMALKEY,libo:DECIMAL(7.3):NORMALTYPE:NORMALKEY,rtdelay:DECIMAL(7.3):NORMALTYPE:NORMALKEY,dtsolddue:STRING(8):NORMALTYPE:NORMALKEY,dtPaySoldto:STRING(8):NORMALTYPE:NORMALKEY,orisoldamt:DECIMAL(7.3):NORMALTYPE:NORMALKEY,soldamt:DECIMAL(7.3):NORMALTYPE:NORMALKEY,creditnote:DECIMAL(7.3):NORMALTYPE:NORMALKEY,dtsoldover:DECIMAL(7.3):NORMALTYPE:NORMALKEY,extrainter:DECIMAL(7.3):NORMALTYPE:NORMALKEY,dtPayBranch:STRING(8):NORMALTYPE:NORMALKEY,orgibranchamt:DECIMAL(7.3):NORMALTYPE:NORMALKEY,branchamt:DECIMAL(7.3):NORMALTYPE:NORMALKEY,dtbranchover:DECIMAL(7.3):NORMALTYPE:NORMALKEY,dtvendordue:STRING(8):NORMALTYPE:NORMALKEY,dtPayVendor:STRING(8):NORMALTYPE:NORMALKEY,orgivendoramt:DECIMAL(7.3):NORMALTYPE:NORMALKEY,vendoramt:DECIMAL(7.3):NORMALTYPE:NORMALKEY,dtvendorover:DECIMAL(7.3):NORMALTYPE:NORMALKEY,cdCust:STRING(6):NORMALTYPE:NORMALKEY,sqInvItem:STRING(3):NORMALTYPE:NORMALKEY,sqPoItem:STRING(3):NORMALTYPE:NORMALKEY,sqItem:STRING(3):NORMALTYPE:NORMALKEY,cdVender:STRING(6):NORMALTYPE:NORMALKEY,tempPo:STRING(20):NORMALTYPE:NORMALKEY,dtOutVender:STRING(8):NORMALTYPE:NORMALKEY
3. Grid 내용 입니다 ------------------->
<object id="gr_grid" classid="<%=LGauceId.GRID %>" class="comn" style="width:100%;height:330px;"
validFeatures="ignoreStatus=no"
validExp="">
<param name="DataID" value="ds_grid">
<Param name="AutoResizing" value=true>
<param name="ColSizing" value=true>
<Param name="DragDropEnable" value=True>
<param name="AddSelectRows" value=True>
<Param name="SortView" value="right">
<param name="TitleHeight" value="20">
<param name=ViewSummary value="1">
<param name="Editable" value=True>
<param name="UsingOneClick" value=1>
<param name="Format"
value='
<FC>id="seq" name="Seq" align="center" width="30" Edit="none" Value={CurRow} </C>
<FC>id="cdSoldto" name="SoldTo Cd" align="left" width="70" Edit="none" show="false" </C>
<FC>id="nmSoldto" name="SoldTo" align="left" width="70" Edit="none" show="true" </C>
<FC>id="noInvoice" name="Invoice No" align="left" width="90" Edit="none" show="true" </C>
<FC>id="noPo" name="LGI PO" align="left" width="120" Edit="none" show="true" suppress=4 sumtext="합 계"</C>
<FC>id="noPart" name="Part No" align="left" width="80" Edit="none" show="true" suppress=3</C>
<C> id="sqPoItem" name="PO Item Sq" align="right" width="70" Edit="none" show="false" suppress=2</C>
<G> name="Qty"
<C> id="qtInv" name="PO" align="right" width="70" Edit="none" show="true" sumtext="@sum", sumbgcolor="#f8be12" suppress=1 </C>
<C> id="qtCall" name="Hub Out" align="right" width="70" Edit="none" show="true" sumtext="@sum", sumbgcolor="#f8be12" Value={DisplayFormat(qtCall,"#,##0")}</C>
</G>
<G> name="Port Departure"
<C> id="dtEtdPtLoad" name="ETD" align="center" width="70" Edit="none" show="true" Mask="XXXX-XX-XX"</C>
<C> id="dtAtdPtLoad" name="ATD" align="center" width="70" Edit="none" show="true" Mask="XXXX-XX-XX"</C>
</G>
<G> name="Port Destination"
<C> id="dtEtaPtDest" name="ETA" align="center" width="70" Edit="none" show="true" Mask="XXXX-XX-XX"</C>
<C> id="dtAtaPtDest" name="ATA" align="center" width="70" Edit="none" show="true" Mask="XXXX-XX-XX"</C>
<C> id="dtEtdPtDest" name="ETD" align="center" width="70" Edit="none" show="true" Mask="XXXX-XX-XX"</C>
<C> id="dtAtdPtDest" name="ATD" align="center" width="70" Edit="none" show="true" Mask="XXXX-XX-XX"</C>
</G>
<G> name="HUB Arrive"
<C> id="dtHubEta" name="ETA" align="center" width="70" Edit="none" show="true" Mask="XXXX-XX-XX"</C>
<C> id="dtHubAta" name="ATA" align="center" width="70" Edit="none" show="true" Mask="XXXX-XX-XX"</C>
</G>
<G> name="Moving Price"
<C> id="movPurch" name="Vendor" align="right" width="70" show="true" </C>
<C> id="movSales" name="LGI" align="right" width="70" show="true" </C>
<C> id="movSalesl" name="SoldTo" align="right" width="70" Edit="AlphaNum" show="true" Value={DisplayFormat(movSalesl,"#,##0")}</C>
</G>
<C> id="diffPrice" name="Diff Price" align="right" width="70" Edit="none" show="true" Value={fixSalesl - movSalesl}</C>
<G> name="Fixed Price"
<C> id="fixPurch" name="Vendor" align="right" width="70" Edit="AlphaNum" show="true" Value={DisplayFormat(fixPurch,"#,##0")}</C>
<C> id="fixSales" name="LGI" align="right" width="70" Edit="AlphaNum" show="true" Value={DisplayFormat(fixSales,"#,##0")}</C>
<C> id="fixSalesl" name="SoldTo" align="right" width="70" Edit="AlphaNum" show="true" Value={DisplayFormat(fixSalesl,"#,##0")}</C>
</G>
<G> name="Add Interest"
<C> id="addInterPri" name="Unit Price" align="right" width="70" Edit="none" show="true" Value={DisplayFormat(addInterPri,"#,##0")}</C>
<C> id="addInterAmt" name="Amount" align="right" width="70" Edit="none" show="true" Value={DisplayFormat(addInterAmt,"#,##0")} sumtext=@sum, sumbgcolor="#f8be12"</C>
</G>
<G> name="Call Off"
<C> id="dtCalloffDead" name="Deadline Date" align="center" width="100" Edit="none" show="true" Mask="XXXX-XX-XX"</C>
<C> id="dtHubout" name="Date" align="center" width="70" Edit="none" show="true" Mask="XXXX-XX-XX"</C>
<C> id="dtAddHubout" name="Date + 30" align="center" width="70" Edit="none" show="true" Mask="XXXX-XX-XX"</C>
<C> id="invoiceNo" name="Invoice No" align="right" width="70" Edit="none" show="true" </C>
</G>
<C> id="libo" name="Libo" align="right" width="70" Edit="none" show="true" </C>
<C> id="rtDelay" name="Delay Inter" align="right" width="70" Edit="none" show="true" </C>
</G>
<G> name="SoldTo Payment"
<C> id="dtSoldDue" name="Due Date" align="center" width="70" Edit="none" show="true" Mask="XXXX-XX-XX"</C>
<C> id="dtPaySoldto" name="Pay Date" align="center" width="70" Edit="none" show="true" Mask="XXXX-XX-XX"</C>
<C> id="oriSoldAmt" name="Ori Amount" align="right" width="70" Edit="none" show="true" Value={DisplayFormat(oriSoldAmt,"#,##0")} sumtext=@sum, sumbgcolor="#f8be12"</C>
<C> id="SoldAmt" name="Amount" align="right" width="70" Edit="none" show="true" Value={DisplayFormat(SoldAmt,"#,##0")}</C>
<C> id="CreditNote" name="Credit Note" align="right" width="70" Edit="none" show="true" Value={DisplayFormat(CreditNote,"#,##0")}</C>
<C> id="dtSoldOver" name="Over Date" align="right" width="70" Edit="none" show="true" Value={DisplayFormat(dtSoldOver,"#,##0")}</C>
<C> id="extraInter" name="Ext Inter" align="right" width="70" Edit="none" show="true" Value={DisplayFormat(extraInter,"#,##0")} sumtext=@sum, sumbgcolor="#f8be12"</C>
</G>
<G> name="LGI Payment"
<C> id="dtPayBranch" name="Date" align="center" width="70" Edit="none" show="true" Mask="XXXX-XX-XX"</C>
<C> id="orgiBranchAmt" name="Ori Amount" align="right" width="70" Edit="none" show="true" Value={DisplayFormat(orgiBranchAmt,"#,##0")} sumtext=@sum, sumbgcolor="#f8be12"</C>
<C> id="BranchAmt" name="Amount" align="right" width="70" Edit="none" show="true" Value={DisplayFormat(BranchAmt,"#,##0")}</C>
<C> id="dtBranchOver" name="Over Date" align="right" width="70" Edit="none" show="true" Value={DisplayFormat(dtBranchOver,"#,##0")}</C>
</G>
<G> name="Vendor Payment"
<C> id="dtPayVendor" name="Due Date" align="center" width="70" Edit="none" show="true" Mask="XXXX-XX-XX"</C>
<C> id="orgiVendorAmt" name="Ori Amount" align="right" width="70" Edit="none" show="true" Value={DisplayFormat(orgiVendorAmt,"#,##0")} sumtext=@sum, sumbgcolor="#f8be12"</C>
<C> id="VendorAmt" name="Amount" align="right" width="70" Edit="none" show="true" Value={DisplayFormat(VendorAmt,"#,##0")}</C>
<C> id="dtVendorOver" name="Over Date" align="right" width="70" Edit="none" show="true" Value={DisplayFormat(dtVendorOver,"#,##0")}</C>
</G>
<C> id="cdCust" name="Cust Cd" align="right" width="70" Edit="none" show="false" </C>
<C> id="sqInvItem" name="Inv Item Sq" align="right" width="70" Edit="none" show="false" </C>
<C> id="sqItem" name="Call Item Sq" align="right" width="70" Edit="none" show="false" </C>
'>