ATNYLASalesInvoiceDP_Extension

Rumman Ansari   2023-10-20   Developer   c programming language > ATNYLASalesInvoiceDP_Extension   250 Share 
<span class="pln">
SELECT TOP </span><span class="lit">1</span><span class="pln"> </span><span class="pun">*</span><span class="pln">
FROM tmpTaxWorkTrans
WHERE </span><span class="typ">SourceRecId</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> </span><span class="lit">@RecId</span><span class="pln">
  AND </span><span class="typ">SourceTableId</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> </span><span class="lit">@TableId</span><span class="pln">
  AND </span><span class="typ">TaxCode</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> </span><span class="str">'IdtTireFee'</span><span class="pun">;</span><span class="pln">
</span>
<span class="pln">
display </span><span class="typ">AmountCur</span><span class="pln"> displaySourceRegulateAmountCur</span><span class="pun">()</span><span class="pln">
</span><span class="pun">{</span><span class="pln">
    </span><span class="typ">TaxWorkTrans</span><span class="pln"> tmpTaxWorkTrans</span><span class="pun">;</span><span class="pln">
    </span><span class="typ">SalesLine</span><span class="pln"> salesLine</span><span class="pun">;</span><span class="pln">
    
    </span><span class="kwd">select</span><span class="pln"> firstOnly </span><span class="pun">*</span><span class="pln"> </span><span class="kwd">from</span><span class="pln"> tmpTaxWorkTrans
        </span><span class="kwd">where</span><span class="pln"> tmpTaxWorkTrans</span><span class="pun">.</span><span class="typ">SourceRecId</span><span class="pln"> </span><span class="pun">==</span><span class="pln"> </span><span class="kwd">this</span><span class="pun">.</span><span class="typ">RecId</span><span class="pln"> </span><span class="pun">&amp;&amp;</span><span class="pln">
              tmpTaxWorkTrans</span><span class="pun">.</span><span class="typ">SourceTableId</span><span class="pln"> </span><span class="pun">==</span><span class="pln"> </span><span class="kwd">this</span><span class="pun">.</span><span class="typ">TableId</span><span class="pln"> </span><span class="pun">&amp;&amp;</span><span class="pln">
              tmpTaxWorkTrans</span><span class="pun">.</span><span class="typ">TaxCode</span><span class="pln"> </span><span class="pun">==</span><span class="pln"> </span><span class="str">'IdtTireFee'</span><span class="pun">;</span><span class="pln">
    
    </span><span class="kwd">if</span><span class="pln"> </span><span class="pun">(</span><span class="pln">tmpTaxWorkTrans</span><span class="pun">)</span><span class="pln">
    </span><span class="pun">{</span><span class="pln">
        </span><span class="kwd">return</span><span class="pln"> tmpTaxWorkTrans</span><span class="pun">.</span><span class="typ">SourceRegulateAmountCur</span><span class="pun">;</span><span class="pln">
    </span><span class="pun">}</span><span class="pln">
    
    </span><span class="kwd">return</span><span class="pln"> </span><span class="lit">0</span><span class="pun">;</span><span class="pln">
</span><span class="pun">}</span><span class="pln">
</span>
<span class="pln">
</span><span class="kwd">static</span><span class="pln"> </span><span class="kwd">void</span><span class="pln"> </span><span class="typ">JoinThreeTablesExample</span><span class="pun">(</span><span class="typ">Args</span><span class="pln"> _args</span><span class="pun">)</span><span class="pln">
</span><span class="pun">{</span><span class="pln">
    </span><span class="typ">SalesTable</span><span class="pln"> salesTable</span><span class="pun">;</span><span class="pln">
    </span><span class="typ">SalesLine</span><span class="pln"> salesLine</span><span class="pun">;</span><span class="pln">
    </span><span class="typ">TmpTaxWorkTrans</span><span class="pln"> tmpTaxWorkTrans</span><span class="pun">;</span><span class="pln">

    </span><span class="kwd">while</span><span class="pln"> </span><span class="kwd">select</span><span class="pln"> </span><span class="pun">*</span><span class="pln"> </span><span class="kwd">from</span><span class="pln"> salesTable
        </span><span class="kwd">join</span><span class="pln"> salesLine
            </span><span class="kwd">where</span><span class="pln"> salesTable</span><span class="pun">.</span><span class="typ">SalesId</span><span class="pln"> </span><span class="pun">==</span><span class="pln"> salesLine</span><span class="pun">.</span><span class="typ">SalesId</span><span class="pln">
    </span><span class="pun">{</span><span class="pln">
        info</span><span class="pun">(</span><span class="str">"SalesTable: "</span><span class="pln"> </span><span class="pun">+</span><span class="pln"> salesTable</span><span class="pun">.</span><span class="typ">SalesId</span><span class="pun">);</span><span class="pln">

        </span><span class="kwd">while</span><span class="pln"> </span><span class="kwd">select</span><span class="pln"> </span><span class="pun">*</span><span class="pln"> </span><span class="kwd">from</span><span class="pln"> tmpTaxWorkTrans
            </span><span class="kwd">where</span><span class="pln"> tmpTaxWorkTrans</span><span class="pun">.</span><span class="typ">SourceTableId</span><span class="pln"> </span><span class="pun">==</span><span class="pln"> salesLine</span><span class="pun">.</span><span class="typ">TableId</span><span class="pln"> </span><span class="pun">&amp;&amp;</span><span class="pln">
                  tmpTaxWorkTrans</span><span class="pun">.</span><span class="typ">SourceRecId</span><span class="pln"> </span><span class="pun">==</span><span class="pln"> salesLine</span><span class="pun">.</span><span class="typ">RecId</span><span class="pln">
        </span><span class="pun">{</span><span class="pln">
            info</span><span class="pun">(</span><span class="str">"TmpTaxWorkTrans: "</span><span class="pln"> </span><span class="pun">+</span><span class="pln"> tmpTaxWorkTrans</span><span class="pun">.</span><span class="typ">SourceRegulateAmountCur</span><span class="pun">);</span><span class="pln">
        </span><span class="pun">}</span><span class="pln">
    </span><span class="pun">}</span><span class="pln">
</span><span class="pun">}</span><span class="pln">
</span>
<span class="pln">
</span><span class="kwd">public</span><span class="pln"> </span><span class="typ">SourceRegulateAmountCur</span><span class="pln"> ansari</span><span class="pun">()</span><span class="pln">
</span><span class="pun">{</span><span class="pln">
    </span><span class="typ">TmpTaxWorkTrans</span><span class="pln"> tmpTaxWorkTrans</span><span class="pun">;</span><span class="pln">
    </span><span class="typ">SalesTable</span><span class="pln"> localSalesTable </span><span class="pun">=</span><span class="pln"> element</span><span class="pun">.</span><span class="pln">args</span><span class="pun">().</span><span class="pln">record</span><span class="pun">();</span><span class="pln">
    </span><span class="typ">SalesLine</span><span class="pln"> localSalesLine</span><span class="pun">;</span><span class="pln">

    </span><span class="kwd">select</span><span class="pln"> </span><span class="typ">TableId</span><span class="pun">,</span><span class="pln"> </span><span class="typ">RecId</span><span class="pln"> </span><span class="kwd">from</span><span class="pln"> localSalesLine
        </span><span class="kwd">where</span><span class="pln"> localSalesLine</span><span class="pun">.</span><span class="typ">SalesId</span><span class="pln"> </span><span class="pun">==</span><span class="pln"> localSalesTable</span><span class="pun">.</span><span class="typ">SalesId</span><span class="pln">
    </span><span class="kwd">join</span><span class="pln"> </span><span class="typ">SourceRegulateAmountCur</span><span class="pun">,</span><span class="pln"> </span><span class="typ">TaxCode</span><span class="pun">,</span><span class="pln"> </span><span class="typ">TransTableId</span><span class="pun">,</span><span class="pln"> </span><span class="typ">TransRecId</span><span class="pln"> </span><span class="kwd">from</span><span class="pln"> tmpTaxWorkTrans
        </span><span class="kwd">where</span><span class="pln"> tmpTaxWorkTrans</span><span class="pun">.</span><span class="typ">TransTableId</span><span class="pln"> </span><span class="pun">==</span><span class="pln"> localSalesLine</span><span class="pun">.</span><span class="typ">TableId</span><span class="pln"> </span><span class="pun">&amp;&amp;</span><span class="pln"> tmpTaxWorkTrans</span><span class="pun">.</span><span class="typ">TransRecId</span><span class="pln"> </span><span class="pun">==</span><span class="pln"> localSalesLine</span><span class="pun">.</span><span class="typ">RecId</span><span class="pln"> </span><span class="pun">&amp;&amp;</span><span class="pln"> tmpTaxWorkTrans</span><span class="pun">.</span><span class="typ">TaxCode</span><span class="pln"> </span><span class="pun">==</span><span class="pln"> </span><span class="str">'IdtTireFee'</span><span class="pun">;</span><span class="pln">

    </span><span class="kwd">if</span><span class="pln"> </span><span class="pun">(</span><span class="pln">tmpTaxWorkTrans</span><span class="pun">)</span><span class="pln">
    </span><span class="pun">{</span><span class="pln">
        </span><span class="kwd">return</span><span class="pln"> tmpTaxWorkTrans</span><span class="pun">.</span><span class="typ">SourceRegulateAmountCur</span><span class="pun">;</span><span class="pln">
    </span><span class="pun">}</span><span class="pln">

    </span><span class="com">// Handle the case when no record is found</span><span class="pln">
    </span><span class="kwd">return</span><span class="pln"> </span><span class="lit">0.0</span><span class="pun">;</span><span class="pln"> </span><span class="com">// Change the default value as needed</span><span class="pln">
</span><span class="pun">}</span><span class="pln">
</span>
Share this Post: