<%...'GE Confidential 'PAGE DESC: ' This is a Controller for Ajax request. ' 'CREATED BY : Tang Ren 'CREATED DATE : 2007/04/20 'CHANGE DATE CHANGE BY CHANGE REF. CHANGE DESC ' ' ' ' ' %> <!--#include file="ROOT.asp"--> <!--#include file="../include/ASP_BEGIN.asp"--> <!--#include file="include/ASP_PreApp_BEGIN.asp"--> <%...'DEFINE PAGE LEVEL VARIABLE Page_Title ="Blank Template Page"'the title for the page Page_ShowTopMenu =true'Whether show Top Menu or not Page_ShowLeftNav =true'Whether show left Navigation or not Page_ShowOfflineTool =false'Whether show OfflineTool link at top right corner Mod_ID ="00"'Indicate which Menu ID Sub_Mod_ID ="00"'Whether show OfflineTool link at top right corner %> <!--#include file="../include/checkUserRight.asp"--> <%...'LANGUAGE FILE INCLUDE %> <%...'BEGIN ASP CODE IF ANY dim RegionID, ZoneID, ProgramCodeID, sql, rs, handleType,tempcounter,ParentID if request("handleType")<>""then handleType = request("handleType") endif ' handle initDdlRegion BEGIN if handleType="initDdlRegion"then tempcounter =1 sql="select REG_ID,REG_Name from PA_REGIONS" set rs=server.createobject("adodb.recordset") rs.open sql,connpa,1,1 whilenot rs.EOF if tempcounter<>1then Response.Write ";"endif Response.Write rs(0)&","&rs(1) tempcounter =2 rs.MoveNext wend rs.Close connpa.Close set rs=nothing set connpa=nothing endif 'handle initDdlRegion END 'handle init bindDdlZone BEGIN if request("Region")<>""and handleType="bindDdlZone"then tempcounter =1 RegionID = request("Region") sql="select ZONE_ID,ZONE_Name from PA_ZONES where REGION_ID="&RegionID&" and closed=0" set rs=server.createobject("adodb.recordset") rs.open sql,connpa,1,1 whilenot rs.EOF if tempcounter<>1then Response.Write ";"endif Response.Write rs(0)&","&rs(1) tempcounter =2 rs.MoveNext wend rs.Close connpa.Close set rs=nothing set connpa=nothing endif 'handle init bindDdlZone END 'handle init bindDdlProgramCode BEGIN if request("Zone")<>""and handleType="bindDdlProgramCode"then tempcounter =1 ZoneID = request("Zone") sql="select PROG_ID,PROG_CODE from PA_PROGCODE where ZONE_ID="&ZoneID set rs=server.createobject("adodb.recordset") rs.open sql,connpa,1,1 whilenot rs.EOF if tempcounter<>1then Response.Write ";"endif Response.Write rs(0)&","&rs(1) tempcounter =2 rs.MoveNext wend rs.Close connpa.Close set rs=nothing set connpa=nothing endif 'handle init bindDdlProgramCode END 'handle Category BEGIN if handleType ="bindCategorys"then tempcounter =1 if request("ParentID")<>""then tempcounter =1 ParentID = request("ParentID") sql="select id,Category from PA_PSCategory where ParentID="&ParentID else sql="select id,Category from PA_PSCategory where CategoryType='Main' and flag='1' and BusnDBN='"&session("busndbn")&"'" 'Response.Write sql 'Response.End endif set rs=server.createobject("adodb.recordset") rs.open sql,connpa,1,1 whilenot rs.EOF if tempcounter<>1then Response.Write ";"endif Response.Write rs(0)&","&rs(1) tempcounter =2 rs.MoveNext wend rs.Close connpa.Close set rs=nothing set connpa=nothing endif 'handle init Category END 'handle BaseCost BEGIN if handleType ="bindBaseCost"then tempcounter =1 if request("ZONE_ID")<>""then tempcounter =1 ZONE_ID = request("ZONE_ID") sql="select * from PA_DEPTCOSTCENTER where ZONE_ID="&ZONE_ID 'debugprint sql endif set rs=server.createobject("adodb.recordset") rs.open sql,connpa,1,1 whilenot rs.EOF if tempcounter<>1then Response.Write ";"endif Response.Write rs(0)&","&rs(1) tempcounter =2 rs.MoveNext wend rs.Close connpa.Close set rs=nothing set connpa=nothing endif 'handle init BaseCost END %> <%...'END APS CODE IF ANY %>