function btn_query_onclick(){
var sql ="";
sql += "select distinct gem01,gem03 from ( ";
sql += "SELECT gem01,gem03 FROM "+dbs+".gem_file WHERE gem05=? AND gemacti=? ";
sql += "union all ";
sql += "SELECT gem01,gem03 FROM "+dbs+".gem_file WHERE gem05=? AND gemacti=? ";
sql += "union all ";
sql += "SELECT gem01,gem03 FROM "+dbs+".gem_file WHERE gem05=? AND gemacti=? ";
sql += " ) ";
sql += " where gem01 like ? ";
var fieldName = "OpenWinForReturn";
var labelArray = new Array("部門編號","部門名稱");
var returnId = new Array("pnu033");
var databaseCfgId = "LocalConnection_for_TIPTOP";
var sqlClaused =sql;
var params = new Array("Y","Y","Y","Y","Y","Y","%");
var types = new Array("SQLTypes.VARCHAR","SQLTypes.VARCHAR","SQLTypes.VARCHAR","SQLTypes.VARCHAR","SQLTypes.VARCHAR","SQLTypes.VARCHAR","SQLTypes.VARCHAR");
var setIds= new Array("gem01","gem03");
openWind(fieldName,labelArray,returnId,databaseCfgId,sqlClaused,params,types,setIds);
}
請先 登入 以發表留言。