验证javascript中的结果集 [英] Validation for resultset in javascript

问题描述

大家好，

我正在通过JavaScript调用网络服务.当结果集为null时，我已经编写了验证，但是当存储过程中的选择不返回任何行时，它将以{"Table":[]}的形式获取结果变量中的数据.
这是我的onSucess函数:

 onSuccessBindWidgetInvoice(result)函数{
    调试器；
    如果(结果！= 空){
        如果(pgrInvoices == 空&& pgrInvoices ==未定义){
            widgetId = '  widgetInvoices';

             var  loadedResult = Sys.Serialization.JavaScriptSerializer.deserialize(result);
            如果(loadedResult.Table.length >   0 ){
                widgetTitle = loadedResult.Table [ 0 ].ItemType;
                 var  getWidgetHtmlMarkup = getWidgetHtml(widgetId，widgetTitle);
                如果($ get(widgetId)！= 空&& $ get(widgetId)！=未定义){
                     var  htmlMarkup = getWidgetHtmlMarkup + createRows(loadedResult.Table.length，loadedResult.Table，widgetId);
                     var  htmlMarkup = htmlMarkup + createPager(widgetId);
                    $ get(widgetId).innerHTML = htmlMarkup;
                    pgrInvoices = $ create(GEP.Scripts.Pager，{'  ImagePath': ../images/'}，空，$ get('  dvPager _' + widgetId) );
                    pgrInvoices.set_WebServiceFn(bindWidgetInvoice);
                    pgrInvoices._ddlPageSize.值 =  10 ;
                    pgrInvoices.set_StartIndex( 1 );
                    pgrInvoices.set_PageSize( 5 );
                    pgrInvoices.set_TotalCount(loadedResult.Table [ 0 ].TotalCount);
                }
                其他
                    alert(' 无法附加' + widgetId)；
            }

        }
        其他 {
            widgetId = '  widgetInvoices';
             var  loadedResult = Sys.Serialization.JavaScriptSerializer.deserialize(result);
            如果(loadedResult.Table.length >   0 ){
                widgetTitle = loadedResult.Table [ 0 ].ItemType;
                如果($ get(widgetId)！= 空&& $ get(widgetId)！=未定义){
                     var  htmlRowMarkup = ' ';
                    htmlRowMarkup = createRows(loadedResult.Table.length，loadedResult.Table，widgetId);
                    $ get('  placedivAttContent _' + widgetId).innerHTML = htmlRowMarkup;
                    pgrInvoices.set_TotalCount(loadedResult.Table [ 0 ].TotalCount);
                }
                其他
                    alert(' 无法附加' + widgetId)；
            }
        }
    }
    changeLoadingImgVisibility();
    $(document).ready(function(){
        //  $('#widgetOrders').hide(); 
        $(' #widgetInvoices').fadeIn( 900 );
    });
} 

解决方案

get(widgetId)！= 空&&

get(widgetId)！=未定义){ var htmlMarkup = getWidgetHtmlMarkup + createRows(loadedResult.Table.length，loadedResult.Table，widgetId); var htmlMarkup = htmlMarkup + createPager(widgetId);

get(widgetId).innerHTML = htmlMarkup; pgrInvoices =

Hi All,

I am calling webservice via my javascript. I have written validation when my resultset will be null, but when the select from my stored procedure will return no rows,it gets the data in my result variable as {"Table":[]} How do i validate this?
Here''s my onSucess function:

function onSuccessBindWidgetInvoice(result) {
    debugger;
    if (result != null) {
        if (pgrInvoices == null && pgrInvoices == undefined) {
            widgetId = 'widgetInvoices';        

            var loadedResult = Sys.Serialization.JavaScriptSerializer.deserialize(result);
            if (loadedResult.Table.length > 0) {
                widgetTitle = loadedResult.Table[0].ItemType;
                var getWidgetHtmlMarkup = getWidgetHtml(widgetId, widgetTitle);
                if ($get(widgetId) != null && $get(widgetId) != undefined) {
                    var htmlMarkup = getWidgetHtmlMarkup + createRows(loadedResult.Table.length, loadedResult.Table, widgetId);
                    var htmlMarkup = htmlMarkup + createPager(widgetId);
                    $get(widgetId).innerHTML = htmlMarkup;
                    pgrInvoices = $create(GEP.Scripts.Pager, { 'ImagePath': '../images/' }, null, null, $get('dvPager_' + widgetId));
                    pgrInvoices.set_WebServiceFn(bindWidgetInvoice);
                    pgrInvoices._ddlPageSize.value = 10;
                    pgrInvoices.set_StartIndex(1);
                    pgrInvoices.set_PageSize(5);
                    pgrInvoices.set_TotalCount(loadedResult.Table[0].TotalCount);
                }
                else
                    alert('Unable to attach ' + widgetId);
            }

        }
        else {
            widgetId = 'widgetInvoices';        
            var loadedResult = Sys.Serialization.JavaScriptSerializer.deserialize(result);
            if (loadedResult.Table.length > 0) {
                widgetTitle = loadedResult.Table[0].ItemType;
                if ($get(widgetId) != null && $get(widgetId) != undefined) {
                    var htmlRowMarkup = '';
                    htmlRowMarkup = createRows(loadedResult.Table.length, loadedResult.Table, widgetId);
                    $get('placedivAttContent_' + widgetId).innerHTML = htmlRowMarkup;
                    pgrInvoices.set_TotalCount(loadedResult.Table[0].TotalCount);
                }
                else
                    alert('Unable to attach ' + widgetId);
            }
        }
    }
    changeLoadingImgVisibility();
    $(document).ready(function () {
        //$('#widgetOrders').hide();
        $('#widgetInvoices').fadeIn(900);
    });
}

解决方案

get(widgetId) != null &&

get(widgetId) != undefined) { var htmlMarkup = getWidgetHtmlMarkup + createRows(loadedResult.Table.length, loadedResult.Table, widgetId); var htmlMarkup = htmlMarkup + createPager(widgetId);

get(widgetId).innerHTML = htmlMarkup; pgrInvoices =

这篇关于验证javascript中的结果集的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！