客户端回调实现gridView无刷新分页
日期:2007年10月12日 作者: 查看:[ 大字体 中字体 小字体]-
border="0" marginwidth="0" marginheight="0" src="http://www.hackhome.com/gg/web/ff_468.html" frameborder="no" width="468" scrolling="no" height="0"> - <script src="http://pagead2.googlesyndication.com/pagead/show_ads.js" type="text/javascript"> </script> name="google_ads_frame" marginwidth="0" marginheight="0" src="http://pagead2.googlesyndication.com/pagead/ads?client=ca-pub-0692289505803928&dt=1206921467625&lmt=1199876374&format=300x250_as&output=html&correlator=1206921467609&channel=6926205886&url=http%3A%2F%2Fwww.hackhome.com%2FInfoView%2FArticle_151990_2.html&color_bg=FFFFFF&color_text=000000&color_link=000060&color_url=008000&color_border=FFFFFF&ad_type=text_image&ref=http%3A%2F%2Fwww.hackhome.com%2FInfoView%2FArticle_151990.html&frm=0&cc=100&ga_vid=1157469185.1206921468&ga_sid=1206921468&ga_hid=1468868439&flash=9.0.47.0&u_h=768&u_w=1024&u_ah=738&u_aw=1024&u_cd=32&u_tz=480&u_his=1&u_java=true" frameborder="0" width="300" scrolling="no" height="250" allowtransparency="allowtransparency"> end if;
IF p_Operator Is Not Null Then then
v_sql := v_sql 'And operator LIKE ''%' RTRIM(LTRIM(p_Operator))'%''';
end if;v_sql := v_sql ' and (TO_CHAR(time,''YYYYMMDD'') between ''' to_char(p_StartTime, 'YYYYMMDD') ''' and ''' to_char(p_EndTime, 'YYYYMMDD') ''')';
----取记录总数
v_sqlcount := 'select count(*) from (' v_sql ')';
execute immediate v_sqlcount into v_count;
p_RecordCount := v_count;--排序字段
IF p_OrderField IS NOT NULL THEN
v_orderfield:=p_OrderField;
Else
v_orderfield:='ID';
END IF;
--是否降序
IF p_Desc <>0 THEN
v_order:=' ASC';
Else
v_order:=' DESC';
END IF;