DEV Community: Fatih Şahin

ClientExecProc zzzp_invoice_sp

Fatih Şahin — Fri, 17 Oct 2025 11:37:53 +0000

                    <cell colspan="2">
                    <control FieldName="Field1" ControlType="Button" Caption="Sipariş No Yenile"  ServerAttribute="ForeColor=Green;BackColor=Green">
                    <ClientSideEvents Click="function (s,e) {
                    var Deneme=1;
                    ClientExecProc('zzzp_invoice_sp @pDeneme', function (p) { alert('Güncelleme Tamamlandı.'); },Deneme);
                    }"></ClientSideEvents> 
                    </control>
                    </cell>

MainList URL Parametre Gönderme

Fatih Şahin — Thu, 14 Aug 2025 18:40:04 +0000

{@APP_URL}&"/MainList.aspx?CommandName=PayrollCollection.Show&ProcessTypeMode=1&Args='PayrollCollection.Show|And;RegisterId=@RegisterId;PayrollYear=@PayrollYear|@RegisterId="&Replace(CStr({REPORT_TABLE.REGISTER_ID},0),".","")&";@PayrollYear="&Replace(CStr({REPORT_TABLE.PAYROLL_YEAR},0),".","")&"||Id|Id|||Id||1|||'"

XSLT not contains

Fatih Şahin — Wed, 30 Jul 2025 11:36:18 +0000

<xsl:for-each select="//n1:Invoice/cbc:Note"> <xsl:if test="not(contains(., '3065 sayılı')) and not(contains(., 'FTutar')) and . !='' and .!= //n1:Invoice/cac:AccountingCustomerParty/cac:Party/cac:PartyName/cbc:Name"> <xsl:value-of select="." /> <br /> </xsl:if> </xsl:for-each>

Ekran Kontrolü - Postgresql

Fatih Şahin — Wed, 11 Dec 2024 10:48:29 +0000

DECLARE
  FORM_PER_START_DATE date;
  FORM_PER_END_DATE date;
  FORM_QTY numeric;
  WALBIL_SAVED_QTY numeric;
  SCREEN_QTY numeric;
  BEGIN

SELECT
START_DATE, END_DATE INTO FORM_PER_START_DATE, FORM_PER_END_DATE
FROM ZZZT_CAPASITY_REPORT_PER
WHERE
1=1
AND TO_DATE({DocDate} ,'DD.MM.YYYY') BETWEEN TO_DATE(START_DATE,'DD.MM.YYYY')
AND TO_DATE(END_DATE,'DD.MM.YYYY')
AND CAPASITY_REPORT_ID={ZZCapasityReportId};

SELECT
SUM(QTY) INTO FORM_QTY
FROM ZZZT_CAPASITY_REPORT
WHERE
1=1
AND CAPASITY_REPORT_ID={ZZCapasityReportId};

SELECT
SUM(OD.QTY) INTO WALBIL_SAVED_QTY
FROM INVT_ITEM_D OD
INNER JOIN INVT_ITEM_M OM ON OD.ITEM_M_ID = OM.ITEM_M_ID
WHERE
1=1
AND OM.PURCHASE_SALES=2
AND OM.ZZ_CAPASITY_REPORT_ID = {ZZCapasityReportId}
AND OM.ENTITY_ID = {EntityId}
AND OD.ITEM_ID IN (SELECT RI.ITEM_ID FROM ZZZT_CAPASITY_REPORT_ITEM RI WHERE RI.CAPASITY_REPORT_ID = {ZZCapasityReportId})
AND TO_DATE(OM.DOC_DATE,'DD.MM.YYYY') BETWEEN TO_DATE(FORM_PER_START_DATE,'DD.MM.YYYY')
AND TO_DATE(FORM_PER_END_DATE,'DD.MM.YYYY');

SELECT {OrderDCollection.Qty} INTO SCREEN_QTY FROM DUAL;

 OPEN :message FOR
    SELECT (CASE
             WHEN (COALESCE(WALBIL_SAVED_QTY,0)+SCREEN_QTY)>COALESCE(FORM_QTY,0) AND COALESCE(FORM_QTY,0)>0 
             THEN '🆔 150'||Chr(10)||
             '❌ '||{ZZCapasityReportDocNo}||' Belge Numaralı Kapasite Raporu için Max Sevk Limitine Ulaştınız.'||Chr(10)||
             '✅ Önceki: ' ||TO_CHAR(COALESCE(WALBIL_SAVED_QTY,0),'999G999G999')||Chr(10)||
             '✅ Kapasite: '||TO_CHAR(COALESCE(FORM_QTY,0),'999G999G999')||Chr(10)||
             '✅ Toplam Sipariş Miktar: '||TO_CHAR((COALESCE(WALBIL_SAVED_QTY,0)+SCREEN_QTY),'999G999G999')||Chr(10)||
             '✅ Fark:  '||TO_CHAR((COALESCE(FORM_QTY,0)-COALESCE(WALBIL_SAVED_QTY,0)-SCREEN_QTY),'999G999G999')
            ELSE
             ''
           END)
      FROM DUAL;
END;

Oracle KILL SESSION

Fatih Şahin — Fri, 04 Oct 2024 13:47:34 +0000

select
   c.owner,
   c.object_name,
   c.object_type,
   b.sid,
   b.serial#,
   b.status,
   b.osuser,
   b.machine
from
   v$locked_object a,
   v$session b,
   dba_objects c
where
   b.sid = a.session_id
and
   a.object_id = c.object_id;

ALTER SYSTEM KILL SESSION '1141,2197';

Dinamik Popup

Fatih Şahin — Sat, 24 Aug 2024 11:11:01 +0000

Master Detay Update

function SetRequestStatus0()
{
fn_update1();
function fn_update1() {
var Id = GetControlValue('Id');
ClientExecSQL('UPDATE PSMT_OFFER_M SET REQUEST_STATUS = 0 WHERE REQUEST_STATUS  = 3 AND OFFER_M_ID=@Id::integer',
function (p) {
fn_update2();
},
GetUrlParam('ObjectId')
)
}
function fn_update2() {
var pId = GetControlValue('Id');
ClientExecSQL('UPDATE PSMT_OFFER_D SET REQUEST_STATUS = 0 WHERE REQUEST_STATUS  = 3 AND OFFER_M_ID=@Id::integer',
function (p) {
},
GetControlValue('Id')
)
}
}

XSLT

Fatih Şahin — Mon, 15 Jan 2024 17:52:57 +0000

XSLT, Suppress, Multi string

<xsl:for-each select="//n1:DespatchAdvice/cbc:Note">
<xsl:if test="not(contains(., 'Fatura Adresi')) and not(contains(., 'Sevk Adresi'))">
<b>&#160;&#160;&#160;&#160;&#160;&#160;Not: </b>
<xsl:value-of select="."/>
<br/>
</xsl:if>
</xsl:for-each>

JavaScript

Fatih Şahin — Mon, 15 Jan 2024 17:46:38 +0000

function (s,e)
{
var TA=GetControlValue('SourceQty');
var TE =GetControlValue('CreateRowQty');
var Fark =0;
SetControlValue('PackageTraDQty',Fark);
if (TA>TE) {Fark=TA/TE; SetControlValue('PackageTraDQty',Fark);} 
}

Grid

function (s,e)
{
var TA=GetColumnValue('FastCreateBarcodeCollection','ReceivedQuantity');
var TE =GetColumnValue('FastCreateBarcodeCollection','DeliveredQuantity');
var Fark =0;
SetColumnValue('FastCreateBarcodeCollection','OversupplyQuantity',Fark); 
SetColumnValue('FastCreateBarcodeCollection','ShortQuantity',Fark);
if (TA>TE) {Fark=TA-TE; SetColumnValue('FastCreateBarcodeCollection','OversupplyQuantity',Fark); }
if (TE>TA) {Fark=TE-TA; SetColumnValue('FastCreateBarcodeCollection','ShortQuantity',Fark); }
}

function SetEndDate() {
var SetEndDate= GetControlValue('AccEndDate');
SetControlValue('AssetEndDate',SetEndDate);
SetControlValue('BankEndDate',SetEndDate);
SetControlValue('CadEndDate',SetEndDate);
SetControlValue('CashEndDate',SetEndDate);
SetControlValue('EntityEndDate',SetEndDate);
SetControlValue('BankEndDate',SetEndDate);
SetControlValue('InventoryEndDate',SetEndDate);
SetControlValue('InvoiceEndDate',SetEndDate);
SetControlValue('WaybilEndDate',SetEndDate);
}

var returnValueStr ="\t1027731\tC 01 00149\t\tNOTE1\tNOTE2\tAAA\t120\t120\tTRY\n\t1027731\tC 01 00149\t\tNOTE1\tNOTE2\tAAA\t120\t120\tTRY\n"   

GetControl('PaymentChecklistDCollection').PerformCallback('PasteFromExcel|' + returnValueStr);

Koşullu Renklendirme

Fatih Şahin — Mon, 15 Jan 2024 17:38:08 +0000

{ShippingDate} = {fn_GetDate(2)}
{ShippingDate} = {fn_GetDate(1)}
{ShippingDate} = {fn_GetDate(0)}
{ShippingDate} < {fn_GetDate(0)}

PostgreSQL Log Viewing

Fatih Şahin — Mon, 15 Jan 2024 17:35:50 +0000

 SELECT 
 op_date,
 op,
 op_data ->> 'worder_m_id',
 op_data ->> 'item_attribute1_id',
 op_data ->> 'qty_man'
FROM uyumlog.log
WHERE table_name = 'prdt_worder_m' and op_data ->> 'worder_m_id'   = '4149' 
ORDER BY op_date asc

Links

Fatih Şahin — Mon, 15 Jan 2024 16:34:01 +0000

CustomPrg/XML/PRD_NewObjects_PrdFreeBreakWorder.xml

/reportschedule.aspx

https://codefile.io/

https://ec.europa.eu/taxation_customs/vies/#/vat-validation

/arge.aspx

Call multiple JavaScript functions in onclick event
https://www.geeksforgeeks.org/call-multiple-javascript-functions-in-onclick-event/

Büyük boyutlu TXT Text dosyaları açmak ve anlık log görüntülemek için
https://github.com/snakefoot/snaketail-net/releases

Video Yükleme Link Paylaşma
https://streamable.com/

C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Temporary ASP.NET Files\

XML

Fatih Şahin — Mon, 15 Jan 2024 16:25:33 +0000

SQL BEGIN

<cell colspan="2">
<control FieldName="ZZClientExecSQL1" ControlType="Button" Caption="Eşleme Verileri Yenile" ControlEditEnabled="False" Width="150">
<ClientSideEvents Click="function (s,e) {ClientExecSQL('BEGIN
  DELETE FROM ZZZT_INVOICE_PAID;
  COMMIT;
  INSERT INTO ZZZT_INVOICE_PAID
  SELECT * FROM ZZZW_INVOICE_PAID2;
  COMMIT;
END;',
function (p) {alert('İşlem Başarılı.✅')}
)
}"></ClientSideEvents> 
</control>
</cell>

MoveColumn, Grid Kolon Ayarlama

<MoveColumn FieldName="ItemAttributeCode1"/><MoveColumn FieldName="LotCode"/><MoveColumn FieldName="Qty"/>

Endless Paging - Alt + M Sonsuz Veri Sayfalama ve Kaydırma

Settings-ShowGroupPanel=False;SettingsBehavior-AllowSort=True;Settings-ShowFilterRow=True;SettingsPager-Mode=EndlessPaging;Settings-VerticalScrollableHeight=600

XML FilterValues LIKE

Filter="ItemCode=@ItemCode" FilterValues="@ItemCode%=00 7"

        <GridColumn FieldName="ItemCode" Caption="Stok Kodu" ControlType="ButtonEdit">
        <DataSource SourceType="Command" Source="ItemCollection.Show" ProcessTypeMode="1" ReturnProperties="Id;ItemCode;ItemName" ReturnedProperties="ItemId;ItemCode;ItemName" Filter="ItemCode=@ItemCode" FilterValues="@ItemCode%=00 7">
        </DataSource>
        </GridColumn>

XML Warning

<cell colspan="1">
 <control FieldName="lblWarning" Caption=" *Sadece Bugüne Ait Üretim Hareketleri Listelenir." Width="900" ControlType="Label" ServerAttribute="ForeColor=Red;Font-Size=8;Font-Bold=True"></control>
</cell>

ServerAttribute

ServerAttribute="Font-Bold=True;Font-Size=15;ForeColor=Green;BackColor=#d5f5e3"

Font-Bold=True;Font-Size=10;Image-Url=~/images/ButtonIco/icons8-save-close-24.png

GetUrlParam('ObjectId')

function IscardAcc1()
{
ClientExecSQL('UPDATE FIND_CARD_INTG SET ISCARD_ACC = 1 WHERE CARD_INTG_ID=@Id::integer',
function (p) {
alert('İşlem Başarılı.');location.reload();
},
GetUrlParam('ObjectId'),
)
}

SetControlValue

SetControlValue('SourceApp','Fatura')
function zNote1() {
var zNote1= GetControlValue('ItemAccIntgDesc'); SetControlValue('Description',zNote1);
}

GetControl('OrderDCollection').GetEditor('UnitPriceTra').SetEnabled(false);

XML Source Dynamic Parameter

<row>
<cell>
<control FieldName="Note3" MaxLength="100" ControlType="ButtonEdit" Caption="Açıklama3" Width="330" Incomplate="True">
<DataSource FilterValues="@DynamicParameterId=5" Source="DynamicParameterDCollection.Show" ReturnedProperties="Note3" ReturnProperties="Note1" Filter="DynamicParameterId=@DynamicParameterId" ListPropertyName="Note1"/>
</control>
</cell>
</row>

Mainlist Yazdır

function OpenReport()
{
var accMId=myListPage.GetRowKey(myListPage.GetFocusedRowIndex());
var prmKeys = ["CurrentIdentity", "AccMId"];
var prmValues = ["12345",accMId];
OpenReportPDF('1547', prmKeys, prmValues);
}

Yazdır Buton

<cell colspan="3">
<control FieldName="FieldName2"
ControlType="Button"
CaptionVisible="True"
ToolTip="Irsaliye"
Caption="Ap İrsaliye Yazdır"
Width="25" Height="25"

CustomAttribute="onmouseover=BiggerImage(this, event, 'Kimlik Bilgileri')"
ServerAttribute="Image-Url=https://gallery.mailchimp.com/754a5064cb12ce106fca9e2c7/images/d5269d56-0049-4421-91f2-67d5886edfe7.png">
<ClientSideEvents Click="function(s, e) {
var offerId =GetControlValue('Id');
var prmKeys = ['CurrentIdentity', 'ItemMId'];
var prmValues = ['12345',offerId];

OpenReportPDF('11000145', prmKeys, prmValues);

}"/>
</control>
</cell>

MultiSet

<GridColumn FieldName="ZZInvoiceMId" ControlType="ButtonEdit" Caption="Fatura Id (Ödemesi Gerçekleşen)">
<DataSource SourceType="Command" 
Source="ZZZFinInvoicePayCollection.Show" 
Filter="EntityId=@EntityId" 
FilterValues="@EntityId=GetColumnValue(FinDcardId)"
ReturnProperties="Id;Description"
ReturnedProperties="ZZInvoiceMId"
ListPropertyName="Id"
ProcessTypeMode="2"
CustomReturnJs="MultiSet">
</DataSource>
</GridColumn>

XML if (GetControlValue

<root MainCode="" Caption="Kredi ve Ödeme Listesi">
<script ScriptCode="
AddLoadList('FirstLoad()');

        FirstLoad=function()
        {
            GetControl('pDocDateL').SetVisible(false);
        } 

"></script>
    <tabcontrol Visibility="True">
        <tabpage Caption="Kriterler">
            <section Caption="" CaptionVisibility="False" Visibility="True" ColumnCount="6">
                <row>
                    <cell colspan="2">
                        <control FieldName="CoCode" ControlType="ButtonEdit" Caption="Firma" DefaultValue="Session(CoCode)" ControlRequired="True">
                            <DataSource SourceType="Command" Source="CompanyCollection.Show" Filter="" FilterValues="" OrderByProperty="" ReturnProperties="CoCode" ReturnedProperties="CoCode" RelatedProperty="" ProcessTypeMode="1" ListPropertyName="CoCode"></DataSource>
                        </control>
                    </cell>
                </row>

                <row>
                    <cell colspan="1">
                        <control FieldName = "Yerlesim" 
                     ControlType = "ComboEdit" 
                     ControlEnabled="True" 
                     DefaultValue="Ödenecek" 
                     MaxLength = "50" 
                     ControlRequired = "True" 
                     Caption = "Liste Tipi" 
                     ControlVisible="True">
                            <DataSource  SourceType="TextAndValue" Text="Ödenecek;Ödenen;Reel Kur" Value="Ödenecek;Ödenen;Reel Kur"></DataSource>
                                          <ClientSideEvents ValueChanged="function(s,e)
                                                { 
                                                    if (GetControlValue('Yerlesim') == 'Ödenen')
                                                    {
                                                        GetControl('pDocDateL').SetVisible(true);
                                                    }
                                                    else if (GetControlValue('Yerlesim') == 'Reel Kur')
                                                    {
                                                        GetControl('pDocDateL').SetVisible(true);
                                                    }
                                                     else 

                                                     {
                                                     GetControl('pDocDateL').SetVisible(false);
                                                     }

                                                }">
                </ClientSideEvents>
                        </control>
                    </cell>
                </row>

                <row>
                    <cell colspan="2">
                        <control FieldName="pDocDateF" ControlType="DateEdit" ControlRequired="True" Caption="Tarih" ControlEnabled="true" DefaultValue=""></control>
                    </cell>
            <cell colspan="1">
            <control FieldName="pDocDateL" ControlType="DateEdit" CaptionVisible="False" DefaultValue="">
            </control>
            </cell>
                </row>


            </section>
        </tabpage>
    </tabcontrol>
</root>

Button Zorunlu Alan Mesajı
control
ClientSideEvents
Click

function (s,e)
{
    var resultValidation = ASPxClientEdit.ValidateGroup('valid1', true);

    if (resultValidation == false) {
        UyumMessage(LangErr.GNL.FillRequiredFields);
        return false;
    }
}

Dinamik Pop-Up SetEnabled
function SetLoansRefNo() { GetControl('LoansRefNo').SetEnabled(true); }

Dinamik XML, veri alanındaki boşluğu kaldırma
<ClientSideEvents ValueCahnged="function(s, e) { if (s.GetValue()) { s.SetValue(s.GetValue().trim()); } }"> </ClientSideEvents>

<GridColumn FieldName="ZZContainerNo" ControlType="TextEdit" Caption="Konteyner No" ControlRequired="False" ControlEnabled="True" ControlVisible="True" ControlSingleLine="true" Width="150">
<ClientSideEvents ValueChanged="function(s, e) 
{
if (s.GetValue())
{
s.SetValue(s.GetValue().trim());
}
}">
</ClientSideEvents>
</GridColumn>

Dinamik XML Button, Update

<cell colspan="2">
<control FieldName="LoansRefNoEnabled" ControlType="Button" Caption="Kredi Ref No Aktif Et" Width="150">
<ClientSideEvents Click="function(s, e) {GetControl('LoansRefNo').SetEnabled(true);}"></ClientSideEvents>
</control>
</cell>

<cell colspan="2">
<control FieldName="LoansRefNoUpdate" ControlType="Button" Caption="Kredi Ref No Değiştir" Width="150">
<ClientSideEvents Click="function fn_YeniRefNo() {

var LoansRefNo = GetControlValue('LoansRefNo');

ClientExecSQL('UPDATE FIND_LOANS_M M SET M.LOANS_REF_NO = @pLoansRefNo WHERE M.LOANS_M_ID=@Id',
function (p) {

alert('İşlem Başarılı.!');location.reload();
},
LoansRefNo,
GetControlValue('Id')
)
}"></ClientSideEvents>
</control>
</cell>

<cell colspan="2">
<control FieldName="CommitmentClosureEnable" ControlType="Button" Caption="Alanları Aktif Et" Width="150" Height="10" ControlEditEnabled="False">
<ClientSideEvents Click="function(s, e) {GetControl('CommitmentClosureAmt').SetEnabled(true);GetControl('CommitmentClosureCurCode').SetEnabled(true);GetControl('CommitmentClosureDate').SetEnabled(true);}"></ClientSideEvents>
</control>
</cell>

<cell colspan="2">
<control FieldName="CommitmentClosureUpdate" ControlType="Button" Caption="Güncelle" Width="150">
<ClientSideEvents Click="function fn_Update() {

var pCommitmentClosureAmt = ConvertDecimalToStr(GetControlValue('CommitmentClosureAmt'));
var pCommitmentClosureCurId = GetControlValue('CommitmentClosureCurId');
var pCommitmentClosureDate = GetControlValue('CommitmentClosureDate');

ClientExecSQL('UPDATE FIND_LOANS_M M SET M.COMMITMENT_CLOSURE_AMT = @pCommitmentClosureAmt, M.COMMITMENT_CLOSURE_CUR_ID = @pCommitmentClosureCurId, M.COMMITMENT_CLOSURE_DATE = @pCommitmentClosureDate WHERE M.LOANS_M_ID=@Id',

function (p) {alert('İşlem Başarılı.!');location.reload();},
pCommitmentClosureAmt,
pCommitmentClosureCurId,
pCommitmentClosureDate,
GetControlValue('Id')
)
}"></ClientSideEvents>
</control>
</cell>

var pCommitmentClosureAmt = ConvertDecimalToStr(GetControlValue('CommitmentClosureAmt'));

<tabpage Caption="İhracat Taahütü">
<section Visibility="false" ColumnCount="12">
<row>
<cell colspan="5">
<section Visibility="false">
<row>
<cell>
<control FieldName="ZZCommitmentClosureAmt" ControlType="SpinEdit" Caption="Taahüt Kapama Tutarı / Para Birimi" DecimalPlaces="Tutar" DefaultValue="0" CaptionSize="210"> </control>
</cell>
<cell>
<control FieldName="ZZCommitmentClosCurCode" ControlType="ButtonEdit" MaxLength="50" Width="90" Caption="Para Birimi" CaptionVisible="false">
<DataSource ReturnProperties="Id;CurCode" ReturnedProperties="ZZCommitmentClosureCurId;ZZCommitmentClosCurCode" Filter="" FilterValues="" ListPropertyName="CurCode" Source="CurrencyCollection.Show"> </DataSource>
</control>
</cell>


<cell colspan="2">
<control FieldName="CommitmentClosureEnable" ControlType="Button" Caption="Alanları Aktif Et" Width="150" Height="10" ControlEditEnabled="False">
<ClientSideEvents Click="function(s, e) {GetControl('ZZCommitmentClosureAmt').SetEnabled(true);GetControl('ZZCommitmentClosCurCode').SetEnabled(true);GetControl('ZZCommitmentClosureDate').SetEnabled(true);}"></ClientSideEvents>
</control>
</cell>

<cell colspan="2">
<control FieldName="CommitmentClosureUpdate" ControlType="Button" Caption="Güncelle" ControlEditEnabled="False" Width="150">
<ClientSideEvents Click="function fn_Update() {

var pZZCommitmentClosureAmt = ConvertDecimalToStr(GetControlValue('ZZCommitmentClosureAmt'));
var pZZCommitmentClosureCurId = GetControlValue('ZZCommitmentClosureCurId');
var pZZCommitmentClosureDate = GetControlValue('ZZCommitmentClosureDate');

ClientExecSQL('UPDATE FINT_ROTATING_LOANS M SET M.ZZ_COMMITMENT_CLOS_AMT = @pZZCommitmentClosureAmt, M.ZZ_COMMITMENT_CLOS_CUR_ID = @pZZCommitmentClosureCurId, M.ZZ_COMMITMENT_CLOS_DATE = @pZZCommitmentClosureDate WHERE M.ROTATING_LOANS_ID=@Id',

function (p) {alert('İşlem Başarılı.!');location.reload();},
pZZCommitmentClosureAmt,
pZZCommitmentClosureCurId,
pZZCommitmentClosureDate,
GetControlValue('Id')
)
}"></ClientSideEvents>
</control>
</cell>


<cell colspan="1">
<control FieldName="ZZCommitmentClosureCurId" ControlType="TextEdit" ControlVisible="false" CaptionVisible="false" ControlEnabled="false"></control>
</cell>
</row>
<row>
<cell>
<control FieldName="ZZCommitmentClosureDate" ControlType="DateEdit" Caption="Taahüt Kapama Tarihi" CaptionSize="210"> </control>
</cell>
</row>
</section>
</cell>
</row>
</section>
</tabpage>

2 table update

<cell colspan="2">
<control FieldName="eInvoiceMIdUpdate" ControlType="Button" ControlEditEnabled="true" Caption="Güncelle" ServerAttribute="Font-Bold=True;ForeColor=Green">
<ClientSideEvents Click="function (s,e)
{
fn_update1();
function fn_update1() {
var peInvoiceMId = GetControlValue('eInvoiceMId');
ClientExecSQL('UPDATE PSMT_INVOICE_M SET E_INVOICE_M_ID = @peInvoiceMId::integer WHERE INVOICE_M_ID=@Id::integer',
function (p) {
fn_update2();
},
peInvoiceMId,
GetUrlParam('ObjectId')
)
}
function fn_update2() {
var pId = GetControlValue('Id');
var peInvoiceMId = GetControlValue('eInvoiceMId');
ClientExecSQL('UPDATE PSMT_EINVOICE_M SET INVOICE_M_ID = @pId::integer WHERE EINVOICE_M_ID=@eInvoiceMId::integer',
function (p) {
},
pId,
peInvoiceMId,
GetControlValue('Id')
)
}
}"></ClientSideEvents>
</control>
</cell>

postgresql

<cell colspan="2">
<control FieldName="CommitmentClosureEnable" ControlType="Button" Caption="Etkinleştir" Width="150" Height="10" ControlEditEnabled="False">
<ClientSideEvents Click="function(s, e) {GetControl('CommitmentClosureAmt').SetEnabled(true);GetControl('CommitmentClosureCurCode').SetEnabled(true);GetControl('CommitmentClosureDate').SetEnabled(true);}"></ClientSideEvents>
</control>
</cell>

<cell colspan="2">
<control FieldName="CommitmentClosureUpdate" ControlType="Button" Caption="Güncelle" ControlEditEnabled="False" Width="150">
<ClientSideEvents Click="function fn_Update() {

var pCommitmentClosureAmt = GetControlValue('CommitmentClosureAmt');
var pCommitmentClosureCurId = GetControlValue('CommitmentClosureCurId');
var pCommitmentClosureDate = GetControlValue('CommitmentClosureDate');

ClientExecSQL('UPDATE FIND_LOANS_M SET COMMITMENT_CLOSURE_AMT = @pCommitmentClosureAmt::decimal, COMMITMENT_CLOSURE_CUR_ID = @pCommitmentClosureCurId::integer, COMMITMENT_CLOSURE_DATE = @pCommitmentClosureDate::date WHERE LOANS_M_ID=@Id::integer',

function (p) {alert('İşlem Başarılı.!');location.reload();},
pCommitmentClosureAmt,
pCommitmentClosureCurId,
pCommitmentClosureDate,
GetControlValue('Id')
)
}"></ClientSideEvents>
</control>
</cell>

ClientExecProc

---
function Denemex()
{
var Id =GetUrlParam('ObjectId');
  ClientExecProc('xrpp_barcodecreate2 @pId', function (p) { alert(p+' '+Id ); }, Id );
}



function Denemex()
 {
GetControl('ItemDCollection').GetRowValues(GetControl('ItemDCollection').GetFocusedRowIndex(),'Id',Denemex1);
}
function Denemex1(Id) {

  ClientExecProc('xrpp_barcodecreate @pId', function (p) { alert(p); }, Id);
}

Dinamik XML, Grid Update Enter

function (s,e)
  {
var pDueDay=parseInt(s.GetValue());
GetControl('ItemDCollection').GetRowValues(GetControl('ItemDCollection').GetFocusedRowIndex(),'Id;DueDay',fn_DueDay);
function fn_DueDay(values) {
pId=values[0];
ClientExecSQL('UPDATE INVT_ITEM_D A SET A.DUE_DAY = @pDueDay WHERE ITEM_D_ID=@pId',
function (p) {
alert('İşlem Başarılı.') ;
},
pDueDay,
pId,
)
}
}

<GridColumn FieldName="DueDay" ControlType="SpinEdit" Caption="Vade Gün" > </GridColumn>

DataTemplate = True

Birden Fazla ClientExecSQL

function (s,e)
{

var pDueDay=parseInt(s.GetValue());

GetControl('ItemDCollection').GetRowValues(GetControl('ItemDCollection').GetFocusedRowIndex(),'Id;DueDay',fn_DueDay);
GetControl('ItemDCollection').GetRowValues(GetControl('ItemDCollection').GetFocusedRowIndex(),'Id;DueDay',fn_DueDayM);

function fn_DueDay(values) {
pId=values[0];
ClientExecSQL('UPDATE INVT_ITEM_D A SET A.DUE_DAY = @pDueDay WHERE ITEM_D_ID=@pId',
function (p) {

fn_DueDayM();

},
pDueDay,
pId,
)
}

function fn_DueDayM(values) {
ClientExecSQL('UPDATE INVT_ITEM_M A SET A.DUE_DAY = @pDueDay WHERE A.ITEM_M_ID IN (SELECT DD.ITEM_M_ID FROM INVT_ITEM_D DD WHERE DD.ITEM_D_ID=@pId)',
function (p) {
},
pDueDay,
pId,
)
}
alert('İşlem Başarılı.');
}

Tarih alanı

<row>
<cell>
<control FieldName="ZZRevisionPrdDate" Caption="Revize Üretim Tarih" ControlType="DateEdit">
</control>
</cell>
<cell colspan="2">
<control FieldName="ZZRevisionPrdDateEnable" ControlType="Button" Caption="Etkinleştir" Width="150" Height="10" ControlEditEnabled="False">
<ClientSideEvents Click="function(s,e) {GetControl('ZZRevisionPrdDate').SetEnabled(true);}"></ClientSideEvents>
</control>
</cell>

<cell colspan="2">
<control FieldName="ZZRevisionPrdDateUpdate" ControlType="Button" Caption="Güncelle" ControlEditEnabled="False" Width="150">
<ClientSideEvents Click="function(s,e) {

var pZZRevisionPrdDate = GetControlValue('ZZRevisionPrdDate');

ClientExecSQL('UPDATE INVD_PACKAGE_M SET ZZ_REVISION_PRD_DATE = TO_DATE(@pZZRevisionPrdDate, @prm2) WHERE PACKAGE_ID=@Id::integer',

function (p) {alert('İşlem Başarılı.!');location.reload();},
pZZRevisionPrdDate,
'dd.mm.yyyy',
GetControlValue('Id')
)
}"></ClientSideEvents>
</control>
</cell>
</row>