Auroraʵ¼ù
Ŀ¼
Ŀ¼ ...................................................................... 1 1µäÐͽçÃæ ................................................................ 3 1.1 Ò»¸ö¼òµ¥µÄFORM-GRID³ÌÐò¸ÅÀÀ ...................................... 3
1.1.1 ÒÔ¡°ÏµÍ³ÃèÊö¡±ÎªÀý ................................................. 3 1.1.2 ¼òÎöFORM ......................................................... 3 1.1.3ÖØÒªÊôÐÔBINDTARGET ................................................ 4 1.1.4¼òÎöGRID .......................................................... 5 1.1.5¼òÊöBM ............................................................ 7 1.1.6²éѯ¹ý³Ì .......................................................... 8 1.1.7ÐÂÔöºÍÐÞ¸ÄÊý¾ÝµÄ±£´æ .............................................. 9 1.2µ¥FORM¼Èë ........................................................... 9 1.3GRID¶à¼¶Áª¶¯ .......................................................... 9 1.3.1½éÉÜGRIDµÄ¶à¼¶Áª¶¯ ............................................... 9 1.3.2GRID¶à¼¶Áª¶¯µÄ²éѯ ............................................... 12 1.3.3Í·Ðб£´æµÄSVCд·¨ ............................................... 13 1.3.4Í·Ðб£´æµÄBMд·¨ ................................................ 15 1.4 FORM+GRID£¬Í·ÐÐÒ»Æð±£´æ ............................................. 16 2¿Í»§¶ËÂß¼ ............................................................. 17 2.1Ò³ÃæÔªËØµÄÒþ²ØÓëÏÔʾ ................................................. 17 2.1.1´¿JS·½·¨Òþ²ØÒ»¸ö×é¼þ ............................................ 17 2.1.2Òþ²ØºÍÏÔʾGRIDÖеÄijһÁÐ ........................................ 17 2.1.3¸ù¾ÝÌØ¶¨²ÎÊý¾ö¶¨ ................................................. 17 2.2¿É±ä±à¼Æ÷(GRID EDITORFUNCTION) ...................................... 18 2.3¿ÉÊä״̬ ............................................................. 18 2.3.1Ó²±àÂ뷽ʽµÄ¿ÉÊäÈë״̬ ........................................... 18 2.3.2ͨ¹ýJS¿ØÖÆ¿ÉÊäÈë״̬ ............................................ 19 2.4±ØÊä״̬ ............................................................. 19 2.4.1Ó²±àÂ뷽ʽµÄ±ØÊä״̬ ............................................. 19 2.4.2ͨ¹ýJS¿ØÖƵıØÊä״̬ ............................................ 19 2.5 COMBO BOX¶þ¼¶Áª¶¯ ................................................... 19 2.6¶¯Ì¬ÉèÖÃLOVÌØÐÔ ..................................................... 19 2.6.1ÉèÖÃLOVÀ´Ô´ ..................................................... 19 2.6.2ÉèÖÃLOV²ÎÊý ..................................................... 20 2.7¶ÔDATASETÑ»·²Ù×÷ ................................................... 20 2.7.1È¡RECORDÊý×éµÄ·½·¨ .............................................. 20 2.7.2´¦ÀíRECORDÊý×é .................................................. 20 3УÑé ................................................................... 21 3.1³£¹æ¿Í»§¶ËУÑé ....................................................... 21
1
3.1.1±ØÊä×Ö¶ÎУÑé ..................................................... 21 3.1.2ʹÓÃÑéÖ¤Æ÷УÑé ................................................... 21 3.1.3¸ù¾ÝÍ·×Ö¶ÎУÑéÐÐ×Ö¶Î ............................................. 21 3.1.4¸ù¾ÝÐÐ×Ö¶ÎУÑéÍ·×Ö¶Î ............................................. 21 3.1.5ͨ¹ýAJAXÖ´ÐÐSERVER¶ËУÑéÖ¤ ..................................... 21 4 BMÌØÐÔ ................................................................ 25 4.1²éѯ ................................................................. 25
4.1.1ͨ¹ýBASETABELºÍFIELDS×Ô¶¯Éú³ÉµÄ²éѯ ............................ 25 4.1.2ͨ¹ýÔÚBMÖж¨Òå
2
1µäÐͽçÃæ
ÔÚ½éÉÜʵ¼ùÄÚÈÝ֮ǰ£¬Ê×Ïȼòµ¥½éÉÜÒ»ÏÂAurora¿ò¼ÜµÄºËÐÄ˼Ï룺
ÔÚwebÓ¦ÓÃÖУ¬ÎÞÂÛÊÇÓû§Ïò·þÎñÆ÷Ìá½»µÄÊý¾Ý£¬»¹ÊÇ·þÎñÆ÷ÏòÓû§·µ»ØµÄÊý¾Ý£¬¶¼ÊǾßÓÐÒ»¶¨º¬ÒåµÄÊý¾ÝµÄ¼¯ºÏ¡£ÀýÈçÓû§×¢²áʱ¿ÉÄÜÒªÌîд¸öÈ˵Ļù±¾ÐÅÏ¢¡¢Ìîд¼òÀúʱÐèÒªÌîд¹¤×÷¾Àú¡¢ÅàѵÀú³ÌµÈ£¬·þÎñÆ÷ÏòÓû§·µ»Ø²éѯµÄº½°àÐÅÏ¢µÈµÈ£¬¶¼ÊǾßÓÐÒ»¶¨µÄº¬ÒåµÄ¡£ÕâÖÖÊý¾ÝµÄ¼¯ºÏÔÚAurora¿ò¼ÜÖгéÏóΪDataSet¡£ÔÚAurora¿ò¼ÜÖУ¬DataSetÊÇwebǰ¶ËÓë·þÎñÆ÷Ö±½Ó½øÐÐÊý¾Ý½»»»µÄ½éÖÊ£¬ÊÇAurora¿ò¼Üǰ¶ËAuroraUIÖÐ×îºËÐĵIJ¿·Ö¡£
DataSetÌṩÁ˶ÔÊý¾ÝµÄ²Ù×÷ºÍµ¼º½£¬¶ÔÊý¾ÝµÄ²Ù×÷»á´¥·¢ÏàÓ¦µÄʼþ(event)£¬ËùÓаó¶¨(bind)µ½DataSetÓÐUI×é¼þ»á¸ù¾Ýʼþ×ö³öÏìÓ¦¡£
1.1 Ò»¸ö¼òµ¥µÄform-grid³ÌÐò¸ÅÀÀ
1.1.1 ÒÔ¡°ÏµÍ³ÃèÊö¡±ÎªÀý
ÔÚHAPϵͳÖУ¬ÎÒÃÇ¿ÉÒԲο¼Ò»Ï¡°ÏµÍ³ÃèÊö¡±¹¦ÄÜ¡££¨ÏêÇéÇë²Î¼ûÏÂÁÐÇåµ¥£©
Ò»¡¢ ¹¦ÄܼòÊö£ºÓÃÓÚ³ÌÐòÒ³ÃæµÄ¶àÓïÑÔ£¬±ÈÈ磬µ±Ò³ÃæÉÏÓÐÒ»ÌõÌáʾ¡°²éѯÌõ¼þ¡±£¬
ʵ¼ÊÔÚ±àÂëʱдÈëÆä¶ÔÓ¦µÄ´úÂë¡°HAP_QUERY_TITLE¡±£¬ÔÚʵ¼ÊÔËÐÐʱ£¬»á¸ù¾Ýµ±Ç°Óû§Ñ¡ÔñµÄlocal²¢ÅäºÏ³ÌÐòÖеÄcodeÀ´Î¨Ò»È·¶¨Ò»ÌõÃèÊöÐÅÏ¢ ¶þ¡¢ Óõ½µÄÒ³ÃæÎļþ£¨screenÎļþ£©£ºsys_prompt.screen Èý¡¢ Óõ½µÄÒµÎñÄ£ÐÍÎļþ£¨bmÎļþ£©£ºsys_prompts.bm ËÄ¡¢ Óõ½µÄÊý¾Ý¿â±í£ºsys_prompts
Îå¡¢ Óõ½µÄÊý¾Ý¿â¶ÔÏó£ºsys_prompts_s(ÐòÁÐ)
1.1.2 ¼òÎöform
3
ÄÜÁ¦£¬Ê¹ÓÃformºó£¬¿ò¼Ü½âÎöºóÉú³ÉµÄ½çÃæÀàËÆÏÂͼ£º
Form³£¼ûÊôÐÔ£º
? column £º±íʾÁË¸Ã±íµ¥Ã¿ÐÐÓжàÉÙÁУ¬formÖеÄ×é¼þµ±ÅÅÂúÒ»Ðкó»á×Ô¶¯»»ÐÐÖÁÏÂ
Ò»ÁС£ ? width £º±íʾÁË¸Ã±íµ¥µÄ¿í¶È£¬´ËÊôÐÔ¿ÉÄÜ»áÓ°Ïì±íµ¥ÄڿؼþµÄÍâ¹Û£¬µ±¿í¶È½ÏµÍʱ£¬
»á²úÉúÒâÍâµÄ½á¹û¡£
? title£ºÈçͼÖÐtitleËùʾ¡£
? δÌáµ½µÄÊôÐÔÐÅÏ¢£¬Çë²ÎÔÄ¡°Aurora Tag Documentation¡±Îĵµ
1.1.3ÖØÒªÊôÐÔbindTarget
ÔÚÌáµ½bindTargetÊôÐÔʱ£¬Ê×ÏÈÏȽéÉÜÒ»ÏÂAurora¿ò¼ÜÒ³Ãæ¶ËµÄ»ù±¾±à³Ì¸ÅÄî¡£AuroraÒ³Ãæ¶Ë²ÉÓÃÊý¾ÝºÍ±íʾ·ÖÀëµÄ˼Ï룬¼ÈÒ³Ãæ¶ËËùÓеÄÊý¾Ý¾ù´æ·ÅÔÚDataset£¨Êµ¼ÊΪһ¸öjs¶ÔÏó£©ÖС£DatasetÖмȴæ·ÅÓÐÊý¾Ý£¬ÓÖÓиÃÊý¾ÝµÄ¸½¼ÓÐÅÏ¢£¬Èç¶ÔÓ¦×Ö¶ÎÊÇ·ñ±ØÊ䣬ÊÇ·ñÖ»¶Á£¬»¹ÓÐÄÚÖõÄһЩ¶ÔÊý¾ÝµÄ²Ù×÷·½·¨¡£
DatasetÖпÉÒÔÓÐÒ»ÌõÊý¾ÝÒ²¿ÉÒÔÓжàÌõÊý¾Ý£¬ÕâЩÊý¾ÝµÄ´æÔÚÐÎʽÀàËÆÓÚÊý¾Ý±í£¬¿ÉÒÔÈÏΪdatasetÖÐÓÐÒ»ÕÅÊý¾Ý±í£¬±íÖпÉÒÔÓÐÒ»Ðлò¶àÐмǼ£¬ÕâЩ¼Ç¼±»³Æ×÷record¡£
Ò³ÃæÖеÄÐí¶àÊý¾ÝÔªËØÒªºÍÒ»¸ödataSet½øÐа󶨡£±ÈÈ磬ÔÚÒ»¸öformÖÐÊäÈë²éѯÌõ¼þ£¬²éѯÌõ¼þµÄÊäÈë¿Ø¼þÓÖºÍÒ»¸ödataset°ó¶¨£¬ÄÇô£¬Õâ¸ö²éѯÌõ¼þ¾Í»áÒÔ¸ÃÊäÈë×é¼þµÄnameÊôÐÔΪkey£¬ÊäÈëֵΪvalue°ó¶¨µ½´Ë±à¼Æ÷Ö¸¶¨µÄdataSetÉÏ£¨×¼È·µÄ˵ÊǸÃdatasetµ±Ç°µÄrecordÉÏ£©¡£sys_prompt.screenÖжÔÓ¦²éѯµÄdataSet´úÂëÇåµ¥ÈçÏ£º
¸ÃdatasetµÄÉùÃ÷½ÏΪ¼òµ¥£¬ÕâÀïÄãÖ»ÐèÒªÖªµÀformÖеIJéѯ¿Ø¼þÊǰ󶨵½¸ÃdatasetÉϼ´¿É¡£
ÔÙÀ´¿´grid¿Ø¼þ°ó¶¨µÄ½á¹ûdataset
? autoQuery£ºÖµÈ¡booleanÀàÐÍ£¬Ä¬ÈÏΪfalse¡£ÒâΪÔÚÒ³Ãæ¼ÓÔØÍê±ÏºóÊÇ·ñ×Ô¶¯½øÐÐ
Ò»´Îajax·½Ê½µÄ²éѯ¶¯×÷¡£
? selectable£º±íʾ²éѯ½á¹ûÊÇ·ñ¿ÉÒÔ±»Ñ¡ÖÐ
4
? fetchAll£º±íʾÊÇ·ñÒ»´Î¼ÓÔØÈ«²¿Êý¾Ý£¨²»·ÖÒ³£© ? pageSize£ºÈç¹û·ÖÒ³£¬Ã¿Ò³µÄÊý¾ÝÁ¿ ? autoCount£ºÏÔʾ½á¹û¼ÆÊý
? queryDataSet£ºÖØÒªÊôÐÔ£¬Ö¸Ê¾²éѯʱ£¬Óû§¿ÉÊäÈëµÄ²éѯÌõ¼þÀ´Ô´¡£±ÈÈçÔÚ´ËÀýÖУ¬
²éѯÌõ¼þ°ó¶¨µÄdataset³ÆÎªA£¬½á¹ûgrid°ó¶¨µÄdataset³ÆÎªB£¬Èç¹ûBµÄqueryDataSetÊôÐÔΪAµÄID£¬ÄÇô£¬µ±Bµ÷ÓÃÆä²éѯ·½·¨µÄʱºò£¬»á½«AÖеÄÊý¾ÝÈ¡³ö×÷Ϊ¸½¼ÓµÄ²éѯÌõ¼þ¡£
? queryUrl£ºÖ¸¶¨Á˵±Ç°dataset²éѯÊý¾ÝʱµÄurl£¬ÆäÒ»°ã¸ñʽΪ£º
${/request/@context_path}/autocrud/test.testbm/query?contractno=${/parameter/@contractno}
ÆäÒ»°ã¿É·Ö³ÉËIJ¿·Ö£º${/request/@context_path}£¬È¡µ±Ç°webÓ¦Óõĸù·¾¶£¬±ÈÈçÏîÄ¿ÃûÅäÖÃΪHAP£¬ÄÇô½âÎöºó±ã³ÉΪ/HAP£»autocrud£¬¿ò¼ÜÄÚÖ㬵÷Óÿò¼Ü´¦ÀíÔöɾ¸Ä²éµÄ»úÖÆ£»test.testbm£ºÇ°ÃæµÄtestָʾbmµÄÎļþĿ¼£¬´Óweb-inf/classes/¿ªÊ¼¼ÆË㣬±¾ÀýÖм´Îªweb-inf/classes/test/testbm.bm£»query£ºÖ¸Ê¾¸Ãurl¶ÔÓ¦µÄÐÐΪ£¬Ä¿Ç°×ܹ²ÓÐ5¸ö¿ÉÓã¬query¶ÔÓ¦²éѯ£¬insert¶ÔÓ¦ÐÂÔö£¬update¶ÔÓ¦¸üУ¬batch_update¶ÔÑ»·Ó¦Ôöɾ¸Ä£¬delete¶ÔӦɾ³ý£¬execute¿ÉÖ´ÐÐÒ»¸öpl sql¿é¡£ ? model £º´ËÊôÐÔ¾ßÓжàÖØ×÷Óá£Ê×ÏÈ£¬¸ÃÊôÐÔÖµ±ØÐëÊÇÒ»¸öbmÎļþ·¾¶£¨ÓйØbmÎÄ
¼þµÄÏêϸ½²½âÄÚÈÝ£¬Çë²Î¼û±¾ÎĵµÖнéÉÜbmµÄ²¿·Ö£¬ÕâÀïÖ»ÊÇÏÈ×ö¼òµ¥½éÉÜ£©£¬Ò³Ãæ½âÎöʱ£¬»á¶Ô¸ø¶¨Â·¾¶½øÐÐÑϸñ¼ì²é¡£µ±datasetÖÐÎÞqueryUrlʱ£¬Èç¹ûµ÷ÓøÃdatasetµÄquery()£¬ÄÇô»á³¢ÊÔ´ÓÖ¸¶¨bmÎļþ×Ô¶¯Éú³É²éѯÓï¾ä£»µ±datasetÖÐÎÞsubmitUrlʱ£¬Èç¹ûµ÷ÓøÃdatasetµÄsubmit()£¬ÄÇô»á³¢ÊÔ´ÓÖ¸¶¨µÄbmÎļþ×Ô¶¯Éú³Éinsert¡¢update¡¢deleteÓï¾ä¡£
? ÆäÓàδÁгöµÄÊôÐÔ¼û±¾ÎĵµDataSetÏêϸ½éÉÜÒ»½ÚÒÔ¼°Çë²ÎÔÄ¡°Aurora Tag
Documentation¡±Îĵµ
´ËÀýÖÐÉæ¼°µ½µÄgridÖеÄ×Ó½Úµã½éÉÜÈçÏ£º
? fields£º field½ÚµãÊǶÔdatasetÖеÄ×ֶεÄÐÞÊΡ£ÔÚÉÏÊö´úÂëÖУ¬×Ö¶Îprompt_code
±»ÉùÃ÷Ϊ¡°±ØÌîÏ£¬µ±°ó¶¨ÔÚdatasetÉϵĿؼþÓÐname=¡±prompt_code¡± ʱ£¬¸Ã¿Ø¼þ¼ÈΪ±ØÌîÏͬÀí£¬Ö»¶Á¿ØÖÆºÍÆäËû¿ØÖƾùÐèÔÚfieldÖÐÉùÃ÷¡£
1.1.4¼òÎögrid
editorFunction=\/>
? bindTarget£ºËµÃ÷Æä°ó¶¨µÄdataset¡£
? marginWidth¡¢marginHeight£ºÓëÒ³Ãæ²¼¾ÖÓйصÄÊôÐÔ£¬ÏêϸÇë²éÔÄHTML±ê×¼¡£ ? δÌáµ½µÄÊôÐÔÐÅÏ¢£¬Çë²ÎÔÄ¡°Aurora Tag Documentation¡±Îĵµ
´ËÀýÖÐÉæ¼°µ½µÄgridÖеÄ×Ó½Úµã½éÉÜÈçÏ£º
? toolbar£º¹¤¾ßÌõ£¬³£ÓõÄÓÐÔö¼Ó¡¢±£´æ¡¢É¾³ý¡£´ËÈý°´Å¥Èç¹û½ö½öÉùÃ÷typeÊôÐÔ£¬
ÔòĬÈÏÐÐΪΪµ÷Óðó¶¨datasetµÄ¶ÔÓ¦ÐÐΪ¡£ ? columns£ºÊý¾ÝÁУ¬ËµÃ÷ÒªÏÔʾµÄ½á¹ûÁС£
? name:ÏÔʾµÄÁÐÃû¡£±ÈÈçµ±Óнá¹ûÃûΪuserʱ£¬Èôname=¡±user¡±£¬Ôò½«ÖµÏÔʾ
ÔÚ´ËÁС£
? sortable£º±íÃ÷¿ÉÒÔ°´´ËÁÐÅÅÐò£¨µ±Êó±êµã»÷¸ÃÁеıêÌâʱ½øÐÐÅÅÐò£©¡£µ±´ËÁÐ
Êý¾ÝΪ×Ó²éѯ½á¹ûʱ²»¿ÉÓ㬷ñÔò»áÒý·¢Òì³£¡£
? editorFunction£ºÖ¸¶¨Ò»¸ö´¦Àíº¯Êý£¬¿ÉÒÔ¶ÔÊý¾ÝµÄ¿É±à¼ÐÔ½øÐпØÖÆ¡£±ÈÈçÔÚ
´ËÀýÖУ¬ÒµÎñÒªÇóÊǵ±½¨Á¢ÁËÒ»¸öprompt¼Ç¼µÄʱºò£¬ÆäcodeºÍÓïÑÔÀàÐ;ù²»¿ÉÔÙ±»±à¼¡£´ËÊôÐÔ¶ÔÓ¦µÄÊÇÒ»¸öjsº¯ÊýÃû£¬µ±ÒµÎñÂß¼ÔÊÐí¸ÃÁÐÐÞ¸ÄÊý¾Ýʱ£¬¿ÉÒÔÔÚjsÖзµ»ØÒ»¸ö±à¼Æ÷µÄID£¬Èç¹û²»ÔÊÐíÐ޸쬷µ»Ø¿Õ¼´¿É¡£ function promptCodeEditFunction(record, name) { if (record.get('prompt_id')) { 6
return ''; } else { return 'sys_prompt_result_grid_upper_tf'; } } ? editors£º±à¼Æ÷¡£Æä×Ó½ÚµãµÄÀàÐÍÖ¸¶¨±à¼Æ÷µÄÀàÐÍ£¬idΪ¸Ã±à¼Æ÷µÄid
1.1.5¼òÊöbm
BmÎļþÖ÷Òª¸ºÔðºÍÊý¾Ý¿âµÄ½»»¥£¬¼È¿ÉÒÔÊÇÀàËÆÓÚhibernateÒ»Ñù¶ÔÊý¾Ý¿â½á¹¹½øÐÐÓ³É䣬´ÓÓ³ÉäÖг¢ÊÔ×Ô¶¯Éú³ÉÔöɾ¸Ä²éÓï¾ä£¬Ò²¿ÉÒÔ×Ô¼ºÐ´Ôöɾ¸Ä²é¡£Ò»¾ä»°£¬bmÎļþÖ÷ÒªÊǸºÔðÓëÊý¾Ý¿â½»»¥£¬Ôöɾ¸Ä²éºÍAjaxÇëÇó£¨ÐèÒªºÍÊý¾Ý¿â½»»¥£©¶¼ÒªÔÚbmÖж¨Òå¡£¾ßÌåÐÅÏ¢£¬Çë²ÎÔÄbmÏê½âÒ»½Ú¡£
ÎÒÃÇÏȰѱ¾ÀýÖеÄbmÎļþÌù³öÀ´
±¾ÀýÖеÄbmÎļþ£¬ÊǶÔÒ»ÕÅÊý¾Ý±íµÄÓ³É䣬´Ó¿ªÍ·µÄbaseTable=\alias=\¿ÉÒÔ¿´³öÀ´£¬¶ÔÓ¦µÄÊÇsys_prompts±í£¬Í¬Ê±È¡±í±ðÃûΪ¡±f¡±¡£
prompt_codeºÍquery-fieldÖеÄÒ»¸öfield¶ÔÓ¦£¬ÄÇô£¬¾Í»á°´ÕÕºóÃæqueryOperatorµÄ¹æÔòÆ´½ÓÌõ¼þ×Ӿ䡣ҪעÒ⣬Èç¹ûquery-fieldÖÐÉùÃ÷µÄÊôÐÔÊÇ field£¬ÄÇô±ØÐëÔÚÉÏÎÄÖÐµÄ name=\/>½Úµã¡£Èç¹û´«µÝ¹ýÀ´µÄ²ÎÊýÊÇÐèҪƴ½ÓÒ»¸ö×Ô¼º¶¨ÒåµÄ²éѯÌõ¼þ£¬ÐèÒª½«query-fieldÉùÃ÷ΪÈçÏÂÐÎʽ£º BmÎļþ¿ÉÒÔ³¢ÊÔÉú³É¶ÔÓ¦ÇëÇóµÄ²Ù×÷£¬±ÈÈçÈç¹û¹ýÀ´Ò»¸öqueryÇëÇó£¬bm¿ÉÒÔ¸ù¾Ý¶¨ÒåµÄfieldÀ´³¢ÊÔÉú³ÉqueryÓï¾ä£¬ÔÚ´ËÀýÖУ¬Èç¹ûÒ³Ãæ·¢À´Ò»¸öqueryÇëÇ󣬲¢ÇÒЯ´øÒ»¸ö²ÎÊýprompt_code£¬²ÎÊýֵΪ¡°HAP_QUERY¡±Éú³ÉµÄqueryÓï¾äΪ select f.prompt_id, f.prompt_code, f.language, decode(f.language, 'U', 'English', '¼òÌåÖÐÎÄ') as language_display, f.description from sys_prompts f where f.prompt_code = 'HAP_QUERY' 1.1.6²éѯ¹ý³Ì ´ËÀýÖУ¬²éѯµÄ¹ý³Ì¼òÒª·ÖÎöÈçÏ£º Ê×ÏÈ£¬Èç¹ûÓû§ÔÚ²éѯÌõ¼þÖÐÊäÈëÖµ£¬±ÈÈçÔÚ¡°ÃèÊö×ֶΡ±ÖÐÊäÈ롱HAP_QUERY¡±£¬ 8 È»ºóµã»÷¡°²éѯ¡±¡£²éѯ°´Å¥°ó¶¨µÄº¯ÊýΪ function queryPrompt() { $('sys_prompt_result_ds').query(); } ¼´£ºÈ¡µ½¸ºÔðÏÔʾ½á¹ûµÄdataset£¬È»ºóµ÷ÓÃÆäÄÚÖõÄquery·½·¨¡£×¢ÒâÕâÀïÊǵ÷ÓøºÔðÏÔʾ½á¹ûµÄdataset£¬¶ø²»ÊDzéѯÌõ¼þËù°ó¶¨µÄdataset¡£½«´Ó²éѯdatasetÖÐÈ¡³öÓû§ÌîдµÄÖµ£¬¼´Îªprompt_code£º¡¯HAP_QUERY¡¯,×÷Ϊ¸½¼ÓµÄ²éѯÌõ¼þ¡£Í¬Ê±£¬Èç¹ûdatasetûÓÐÖ¸¶¨queryUrl£¨Æäʵ¼ÊµØÖ·ÊÇÇëÇóÒ»¸öbmµÄqueryÐÐΪ£©£¬ÄÇô»á³¢ÊÔ´ÓÖ¸¶¨µÄmodelÖÐÉú³ÉÒ»¸ö²éѯÓï¾ä£»Èç¹ûÖ¸¶¨ÁË£¬Ôò°´ÕÕÖ¸¶¨urlÌá½»²éѯÇëÇó£¬queryUrlµÄÓÅÏȼ¶¸ßÓÚ´ÓmodelÖÐÉú³É¡£Í¬Ê±½«È¡µ½µÄ²éѯ²ÎÊý´«µÝ¹ýÈ¥¡£BmÎļþ½Óµ½²éѯÇëÇóºó£¬³¢ÊÔ´Ófield¶¨ÒåÖÐÉú³É²éѯÓï¾ä£¬²éѯÍê±Ïºó£¬»áÒÔjson¸ñʽ½«²éѯ½á¹û×é×°ºÃ£¬·¢ÖÁÒ³Ãæ¶Ë£¬dataset½ÓÊÕÊý¾Ýºó¼´Í¨Öª°ó¶¨×é¼þ½øÐÐÊý¾ÝÏÔʾ¡£ÖÁ´ËÕû¸ö²éѯ¹ý³ÌÍê±Ï¡£ 1.1.7ÐÂÔöºÍÐÞ¸ÄÊý¾ÝµÄ±£´æ ÔÚ±¾ÀýÖУ¬µ¥»÷Ò³ÃæÉϵġ°ÐÂÔö¡±°´Å¥£¬¼´ÔÚgridÖÐÐÂÔöÁËÒ»ÐмǼ£¬ÌîдÍê±Ïºóµ¥»÷¡°±£´æ¡±£¬¼´µ÷ÓÃdatasetµÄsubmit()·½·¨£¬½«Ò³ÃæÉϸü¸Ä¹ýµÄÐУ¨°üÀ¨ÐÂÔöµÄ£©ÒÔjson¸ñʽ´«µÝµ½bmÖУ¬bmÎļþ¿ÉÒÔ¸ù¾ÝÿÐеÄ״̬À´Éú³ÉÏàÓ¦µÄsqlÓï¾ä¡£ÕâÀïÀàËÆÓÚ²éѯ£¬µ±datasetÖÐÉùÃ÷ÁËsubmitUrlʱ£¬µ÷ÓÃdatasetµÄsubmit·½·¨ÊÇÒÔ´ËurlΪÌá½»µØÖ·£»Èç¹ûûÓÐÉùÃ÷£¬Ôò³¢ÊÔ´ÓmodelÊôÐÔÖ¸¶¨µÄµØÖ·À´Éú³Éurl¡£ 1.2µ¥form¼Èë ˼·£ºformÖÐ×é¼þ°ó¶¨Ò»¸ödataset£¬ÔÚ¸ÃdatasetÖÐÉùÃ÷Ò»¸ösubmitUrl£¬ÔÚдÍêÏàÓ¦Êý¾Ýºó£¬µã»÷±£´æ°´Å¥£¬µ÷ÓÃdatasetµÄsubmit()¼´¿É¡£¾ßÌå¿É²Î¿¼HAPϵͳÖС°ÏµÍ³ÉèÖá±Ï¡°Óû§¶¨Ò塱Öеġ°Óû§ÐÂÔö¡±¡£ 1.3grid¶à¼¶Áª¶¯ ÔÚʵ¼ÊÐèÇóÖУ¬Ò²ÓÐÒ»ÖÖºÜÖØÒªµÄ½á¹¹£¬¼´Í·Ðнṹ¡£¾ÍÊÇ»ã×ÜÐÅÏ¢´æÔÚÍ·±í£¬Ã÷ϸÐÅÏ¢´æÔÚÐÐ±í¡£±ÈÈçHAPϵͳÖÐÓС°´úÂëά»¤¡±Ó¦ÓᣱÈÈçÏÖÔÚϵͳÖÐÓÐÒ»´úÂë¡°COMPANY_TYPE¡±£¨¹«Ë¾ÀàÐÍ£©£¬ÆäÏÂÓÐËÄÖÖÀàÐÍ£ºÒµÎñʵÌå¡¢»ã×ܹ«Ë¾¡¢ºÏ²¢¹«Ë¾¡¢µ÷Õû¹«Ë¾¡£ÔòÀàÐÍ´úÂëÊÇ´æÔÚsys_codes±íÖУ¬¸Ã´úÂëϵľßÌåÖµ´æ·ÅÔÚsys_code_values±íÖС£ÎÒÃÇÏÖÔÚ¾ÍÒÔ¸ÃÓ¦ÓÃΪÀý£¬½²½âÒ»ÏÂÈçºÎ±àдͷÐнṹµÄÔöɾ¸Ä²é¡£ 1.3.1½éÉÜgridµÄ¶à¼¶Áª¶¯ ÎÒÃÇÏÈÀ´¿´Ò»Ï³ÌÐòÔËÐеĽçÃæ£º 9 µ±ÎÒÃÇÑ¡ÖÐÍ·±í¼Ç¼Öеġ°¿ÆÄ¿ÀàÐÍ¡±µÄʱºò£¬Ðбí×Ô¶¯Ë¢ÐÂÊý¾Ý 10 ÎÒÃÇÏÈÀ´¿´ÕâÊÇÔõô×öµ½µÄ¡£ fetchAll=\ queryUrl=\FIELD=code_value\> 1.3.2Grid¶à¼¶Áª¶¯µÄ²éѯ ÔÚÍ·datasetÉÏ£¬ÎÒÃÇÉùÃ÷ÁËÊý¾ÝÀ´Ô´£º 12 queryUrl=\£¬±íÃ÷Êý¾Ý´Ósys_codesÕâ¸öbmÖлñµÃ£¬ÐÐdatasetÉÏ£¬ÎÒÃÇÉùÃ÷ÁË queryUrl=\ode_value\£¬±íÃ÷ÁËÊý¾Ý´Ósys_code_valuesÕâ¸öbmÖлñµÃ¡£µ±ÐÐdatasetÉÏÉùÃ÷ÁËbandTarget=¡±sys_code_ref_ds¡±ºó£¬µ±Í·datasetÖб»Ñ¡ÖеÄrecordµÄindex·¢Éú¸Ä±äʱ£¨ÔÚ´ËÓ¦ÓÃÖпÉÒÔʹ¼òµ¥µÄµ¥»÷ÆäËûÐУ©£¬»á×Ô¶¯½«Í·µÄµ±Ç°recordÖеÄËùÓÐÊý¾Ýµ±×öÐÐdatasetµÄ²éѯÊý¾Ý£¬½øÐÐÒ»´ÎÐбíµÄ²éѯ¡£ÕâÑù£¬Ö»ÒªÐбíbmÖÐÓжÔӦͷ¼Ç¼µÄIDµÄÌõ¼þ×Ó¾äʱ£¬¾Í¿ÉÒÔÕýÈ·Æ´³ö²éѯsql¡£ 1.3.3Í·Ðб£´æµÄsvcд·¨ ½«Í·datasetµÄsubmitUrlÉùÃ÷Ϊһ¸ösvcÎļþ£¬ÔÚ´ËÀýÖУ¬svcÎļþÈçÏ£º µã»÷¡°±£´æ¡±ºóµÄÇëÇó²ÎÊý£¨Òѱ»¸ñʽ»¯£©£º _request_data : { \ : [ { \ : \, \ : \, \ : \, \ : \EmersonµÄ²âÊÔcode\, \ : [ { \ : \, \ : \ÓÅ\, \ : \, \ : 1064, \ : \ }, { \ : \, \ : \Á¼\, \ : \, \ : 1065, \ : \ }, { \ : \, \ : \ÖÐ\, \ : \, \ : 1066, \ : \ }, { 14 \ : \, \ : \²î\, \ : \, \ : 1067, \ : \ } ], \ : 1063, \ : \ } ] } ¿ÉÒÔ·¢ÏÖ£¬ÎÒÃÇÌá½»¹ýÈ¥µÄ²ÎÊýÖÐÓÖ³öÏÖÁ˸öÃûΪresult_dsµÄjsonÊý×飬ÆäÖÐÕýÊÇÎÒÃÇÔÚÐбíÖÐÌîдµÄÏî¡£Ãû×ÖÕýÊÇÎÒÃÇÔÚÐÐdatasetÖÐÉùÃ÷µÄbindName¡£ ×ÜÌå²½ÖèÊÇ£º 1¡¢ ÔÚÒ³ÃæÉÏдÁ½¸ödataset£¬Á½¸ögrid·Ö±ð°ó¶¨ÉÏÈ¥£» 2¡¢ ÔÚÐÐdatasetÉÏдÊôÐÔbindTarget=¡°Í·datasetµÄID¡±£»bindName×ÔÐÐÈ·¶¨£» 3¡¢ ½«Í·datasetµÄsubmitUrlÖ¸ÏòÒ»¸ösvcÎļþ£¨ÇмÇÌύʱÊÇÌύͷdataset£©£» 4¡¢ ÔÚsvcÎļþÖÐÖ¸Ã÷Í·Êý¾ÝµÄÑ»·¸ù·¾¶£» 5¡¢ ÔÚsvcÎļþÖÐÖ¸Ã÷ÐÐÊý¾ÝµÄÑ»·¸ù·¾¶£» 6¡¢ ÔÚÐÐbmÖУ¬±£´æÍ·±í¼Ç¼IDµÄ×ֶΣ¬¼ÓÈëÊôÐÔinsertExpression insertExpression=\Í·±íID×Ö¶ÎÃû} Ïêϸ´úÂëÇë²Î¼û¡°HAP¡±ÏµÍ³Öеġ°´úÂëά»¤¡±¹¦ÄÜ¡£ 1.3.4Í·Ðб£´æµÄbmд·¨ ÔÚBMÖУ¬Í¨¹ý ±êÇ©£¬¿ÉÉèÖò㼶¸üУ¬ÀýÈ磺 15 ÕâÑù£¬ÔÚ¶ÔDEPT±í½øÐÐÅúÁ¿¸üÐÂʱ£¬Ã¿ÌõDEPTÖ÷¼Ç¼¸üÐÂÍê±Ïºó£¬»áÕÒµ±Ç°Ö÷¼Ç¼ÖÐÃûΪ EMPLOYEE-LISTµÄϼ¶¼Ç¼¼¯£¬²¢ÒÔtestcase.HR.EMPΪ»ù´¡BM£¬¶ÔEMP±í½øÐÐÅúÁ¿¸üС£ÊäÈë²ÎÊýµÄÊý¾Ý½á¹¹ÀàËÆÓÚ£º Èç¹ûÒª¶Ô¶à¸ödetail±í½øÐиüУ¬ÄÇôÔÚcascade-operationsÏÂÃæÉèÖöàÌõcascade-operation±ê¼Ç¾Í¿ÉÒÔÁË£¬Ã»Ìõ¶ÔÓ¦Ò»¸ödetail±í¡£ cascade-operationµÄÊôÐÔ£º ÊôÐÔ ËµÃ÷ inputPath detail¼Ç¼ÔÚÖ÷¼Ç¼ÖеķÃÎÊ·¾¶ model detail¼Ç¼¶ÔÓ¦µÄBM operations detail¼Ç¼ÔÊÐíµÄ²Ù×÷£¬Èçinsert,update,delete,executeµÈ£¬ÓöººÅ·Ö¸ô 1.4 Form+Grid£¬Í·ÐÐÒ»Æð±£´æ ·½·¨ÆäʵºÍ1.3ÖÐÏàͬ£¬Ö»²»¹ýǰһÖÖµÄÍ·datasetÖÐÓжàÌõÊý¾Ý£¬´ËÖÖÇé¿öÖÐÍ·datasetÖÐÖ»ÓÐÒ»ÌõÊý¾Ý¶øÒÑ¡£¾ßÌå¿É²Î¿¼1.3½Ú¡£ 16 2¿Í»§¶ËÂß¼ 2.1Ò³ÃæÔªËØµÄÒþ²ØÓëÏÔʾ 2.1.1´¿js·½·¨Òþ²ØÒ»¸ö×é¼þ ¿ÉÔÚÐèÒªÒþ²ØµÄÔªËØÉÏÉùÃ÷id£¬ÔÙʹÓÃdocument.getElementById(id)È¡µÃ×é¼þ£¬È»ºóÉèÖÃstyleÊôÐÔdisplay£¬noneΪÒþ²Ø£¬blockΪÏÔʾ¡£´úÂëʾÀýÈçÏ function hidetest() { var input = document.getElementById(\); input.style.display = \;// hide this element input.style.display = \;// } 2.1.2Òþ²ØºÍÏÔʾgridÖеÄijһÁÐ È¡µÃgrid£¨Í¨¹ýid£©£¬È»ºóµ÷ÓÃgridµÄhideColumn(columnÃû)Òþ²ØÁУ¬Í¨¹ýshowColumn(columnÃû)ÏÔʾÁУº var grid = $(\); grid.hideColumn('testColumnName'); grid.showColumn('testColumnName'); 2.1.3¸ù¾ÝÌØ¶¨²ÎÊý¾ö¶¨ µ±ÐèÒª¸ù¾ÝijÒÔ²ÎÊý¾ö¶¨ÏÔʾÓë·ñµÄʱºò£¬²ÉÓÃÈçϽṹ¡£ 17 2.2¿É±ä±à¼Æ÷(grid editorFunction) µ±ÓÐÌØÊâÐèÇóʱ£¬±ÈÈçÔÚgridÖУ¬µ±Ç°ÐÐΪÐÂÔöÐÐʱ£¬ÐÐÉϵÄusernameÁпÉÒԱ༣¬µ±±£´æºó±ã²»¿É±à¼£¬ÊµÏÖ²½ÖèÈçÏ£º 1¡¢ÔÚgridµÄeditors½ÚµãÖмÓÈëÒ»¸ö±à¼Æ÷£¬ÒÔtextFieldΪÀý 2¡¢ÔÚÄ¿±êcolumnÉÏÉùÃ÷ÊôÐÔeditorFunction£¬Ö¸Ã÷Ò»¸öº¯Êý: 2.3.1Ó²±àÂ뷽ʽµÄ¿ÉÊäÈë״̬ ±ÈÈçÔÚdataset dsÖÐÓаó¶¨Óпؼþusername£¬Ôڲ鿴½çÃæÖÐÊDz»¿É±à¼µÄ£¬²Ù×÷²½ÖèΪ£º 1¡¢ÔÚdsÖеÄfieldsÖÐÉùÃ÷×Ó½Úµãfield£¬ÔÚfieldÖÐÉùÃ÷ÊôÐÔ readOnly=¡±true¡± 2.3.2ͨ¹ýjs¿ØÖÆ¿ÉÊäÈë״̬ ÔÚʵ¼ÊÐèÇóÖУ¬Ò²¾³£ÓÐij×ֶθù¾ÝһЩÌõ¼þÀ´µ÷ÕûÆä¿ÉÊäÈëÓë·ñµÄÌØÐÔ¡£ÕâÖÖ¿ÉÒÔͨ¹ýjs´úÂëÀ´¿ØÖÆ£º var usernameField = record.getMeta().getField(\); usernameField.setReadOnly(true); ÆäÖУ¬recordÊǵ±Ç°ÕýÔÚ²Ù×÷µÄrecord£¨Èç¹ûÊÇform£¬¿ÉÒÔÈÏΪÊÇfromÖÐÔªËØ°ó¶¨µÄdatasetµÄµÚÒ»Ìõrecord£»Èç¹ûÊÇgrid£¬ÔòÊǸßÁÁÏÔʾµÄÐУ¬Ä¬ÈÏÑ¡ÖеÚÒ»ÐУ¬È»ºóËæÓû§µÄ²Ù×÷¸Ä±ä£©¡£ 2.4±ØÊä״̬ 2.4.1Ó²±àÂ뷽ʽµÄ±ØÊä״̬ ͬ¿ÉÊäÈë״̬һÑù£¬¿ÉÔÚ¶ÔÓ¦fieldÉÏÉùÃ÷required=¡±true¡±¡£ 2.4.2ͨ¹ýjs¿ØÖƵıØÊä״̬ ͬ¿ÉÊäÈë״̬һÑù£¬µ±È¡µÃ×ֶζÔÓ¦µÄfield¶ÔÏóºó£¬µ÷ÓÃsetRequired(true)¼´¿É¡£ var usernameField = record.getMeta().getField(\); usernameField.setRequired(true); 2.5 combo box¶þ¼¶Áª¶¯ 2.6¶¯Ì¬ÉèÖÃLOVÌØÐÔ 2.6.1ÉèÖÃlovÀ´Ô´ Ê×ÏÈÈ¡µÃlov¶ÔÓ¦µÄfield¶ÔÏó£º var lovField = record.getMeta().getField(\); È»ºóÓÐÈýÖÖÉèÖÃlovµÄ·½Ê½ lovField.setLovModel(\modelλÖÃ\); lovField.setLovService(\bmÎļþλÖÃ\); lovField.setLovUrl(\screenλÖÃ\); 19 2.6.2ÉèÖÃlov²ÎÊý Ê×ÏÈÏÈÈ¡µÃlov¶ÔÓ¦µÄfield¶ÔÏó£º var lovField = record.getMeta().getField(\); È»ºóͨ¹ý lovField.setLovPara('company_id', \); ÕâÀï¾Í½«lovÖÐÉèÖÃÁËÒ»¸öĬÈϵIJÎÊýcompany_id£¬µ±µã¿ªlovʱ£¬´Ë²ÎÊý×Ô¶¯´«Èëºǫ́²ÎÊý²ÎÓë²éѯ¡£´Ë·½·¨Ö÷ÒªÓÃÓÚlovµÄÁª¶¯£¬±ÈÈçÔÚ»ãÂʶ¨ÒåÖУ¬µ±Óû§Ñ¡ÔñÁ˱¾±Òºó£¬ÔÚÑ¡ÔñÍâ±ÒʱҪ½«±¾±ÒÅųýÔÚ½á¹ûÁбíÍâ¡£ 2.7¶ÔdatasetÑ»·²Ù×÷ µ±Óöµ½Ä³Ð©Çé¿öÐèÒª¶ÔdatasetÄÚµÄËùÓÐÊý¾Ý½øÐвÙ×÷ʱ£¬¾ÍÒªÓõ½¶ÔdatasetÄÚÈݵÄÑ»·²Ù×÷¡£ºËÐÄ˼ÏëÊǽ«datasetÖеÄËùÓÐrecordÈ¡³ö£¬Ñ»·´¦ÀíÿÌõrecord¡£ 2.7.1È¡recordÊý×éµÄ·½·¨ ³£ÓõÄÓÐÁ½ÖÖ·½·¨£¬¼ÙÈçÎÒÃÇÏÖÔÚҪȡÃûΪds µÄdatasetÖеÄrecordÊý×飺 var records=ds.getAll(); //È¡µÃ¸ÃdatasetϵÄËùÓÐrecord£¬·µ»ØÒ»¸öjs array¶ÔÏó¡£ var records=ds.getSelected();//È¡µÃËùÓÐÓû§Ñ¡ÖеļǼ£¬·µ»ØÒ»¸öjs array¶ÔÏó¡£ 2.7.2´¦ÀírecordÊý×é ʹÓÃforÑ»·±éÀú´¦Àí¼´¿É¡£±ÈÈçÒªÔÚÿ¸öÑ¡ÖеÄrecordÖвåÈëtemp×ֶεÄÖµ¡±Y¡±£¬´¦Àí¹ý³ÌÈçÏ£º function test() { var ds = $(\);// È¡µÃdataset¶ÔÏó var records = ds.getSelected();// È¡µÃrecordÊý×é for ( var i = 0; i < records.length; i++) { records[i].set(\, \); } } 20 3УÑé 3.1³£¹æ¿Í»§¶ËУÑé 3.1.1±ØÊä×Ö¶ÎУÑé µ±ÔÚÃûΪdsµÄdatasetÖÐÓбØÊä×Ö¶Îʱ£¬Èç¹ûÒª¶ÔÓû§ÊäÈë½øÐÐÑéÖ¤£¬¼Èµ÷ÓÃdsµÄvalidate()·½·¨£¬¼´»á¶Ô±ØÊäÏî½øÐÐУÑé¡£×¢Ò⣬¸Ã·½·¨·µ»ØÒ»¸öbooleanÖµ£¬Èç¹ûÓÐδÌîÏî£¬Ò³ÃæÉÏ»áÌáʾ¡°Ð£Ñ鲻ͨ¹ý¡±À´±íʾÓÐδÌîÏ²¢·µ»Øfalse£¬Çë¸ù¾Ý·µ»ØÖµ×ö½øÒ»²½´¦Àí¡£ 3.1.2ʹÓÃÑéÖ¤Æ÷УÑé 3.1.3¸ù¾ÝÍ·×Ö¶ÎУÑéÐÐ×Ö¶Î 3.1.4¸ù¾ÝÐÐ×Ö¶ÎУÑéÍ·×Ö¶Î 3.1.5ͨ¹ýAJAXÖ´ÐÐserver¶ËУÑéÖ¤ ÕâÊDZ¾¿ò¼ÜÖнÏÎªÖØÒªµÄÒ»¸ö¼¼ÄÜ£¬ÏÂÃæ½«Ïêϸ½éÉÜÈçºÎ½øÐÐÒ»´ÎajaxУÑé Ê×ÏÈ£¬½éÉÜÒ»¸öÖØÒªµÄ¿ò¼ÜÄÚÖÃjs·½·¨£ºAurora.request¡£ Aurora.request({ url : url, params : para, opts : opts, success : function(response, options) { }, failure : function(response, options) { }, scope : scope }); ²ÎÊý½²½â£º ? ? ? ? url£º´¦ÀíÇëÇóµÄurl£¬Í¨³£ÊÇÒ»¸öbmµØÖ· params£ºÐ¯´øµÄ²ÎÊý£¬ÐèΪjson¸ñʽÊý¾Ý opts£ºÃ»Óùý success£º³É¹¦ºóµÄ»Øµ÷·½·¨£¬½ÓÊÜÁ½¸ö²ÎÊý£¬Ò»¸öÊÇ·µ»ØµÄjson¶ÔÏó£¬ÁíÒ»¸öÊÇ 21 ? failure£ºÊ§°ÜºóµÄ»Øµ÷·½·¨ ? scope£º×÷ÓÃÓò url²ÎÊýÓÐЩ½²¾¿£¬ÎÒÃÇÏÈÀ´·ÖÎöÒ»ÏÂurlµÄ½á¹¹£¬Ò»¸öµäÐ͵ÄurlÈçÏ£º ${/request/@context_path}/autocrud/sys.sys_testbm/execute ´Ëurl¿ÉÒÔ²ð·Ö³ÉÈçϼ¸²¿·Ö£º ? ${/request/@context_path}£ºÈ¡µÃÓ¦ÓõÄweb¸ù·¾¶ ? autocrud: ? sys.sys_testbm£º±íʾbmÎļþµÄλÖ㬴ÓwebÓ¦ÓõÄweb-inf/classesÏ¿ªÊ¼²éÕÒ£¬Ä¿Â¼ÒÔ¡°.¡±·Ö ¸î£¬ÔÚ´ËÀýÖУ¬¸ÃbmµÄλÖÃÊÇ£ºweb-inf/classes/sys/sys_testbm.bm¡£ ? execute£ºµ÷ÓÃbmµÄÐÐΪ¡£µ±ÒªÖ´ÐÐÒ»¶Îpl sql¿éʱ£¬ÕâÀï¾ÍÉùÃ÷Ϊexecute¡£Í¬Ê±£¬bmÖÐÒªÓÐÈç Ͻṹ£º ³ýÁËexecute£¬»¹ÓÐupdate¡£ÕâÀïÏêϸ˵һÏÂÕâЩ²ÎÊýÓ¦¸ÃÔÚʲôʱºòʹÓ㺠¿ò¼ÜÄÚÖõÄÒ»ÖÖ»úÖÆ£¬µ±datasetÖÐÐÂÔöÒ»Ìõrecordʱ£¨µ÷ÓÃdsµÄadd·½·¨£©£¬»á×Ô¶¯½«recordÖеÄÒ»¸ö_statusÊôÐÔÉèÖÃΪinsert£»Í¬Àí£¬µ±ÓÐÒ»ÌõÊý¾Ý¸ü¸Äʱ£¬»á½«ÆäÉèÖÃΪupdate¡£±ÈÈçµ±ÐÂÔöÒ»Ìõ¼Ç¼ºó£¬Êý¾ÝÌá½»¸øbmʱ£¬Èç¹ûurl×îºóÉùÃ÷Ϊinsert£¬Ôò ÎÒÃÇÏÖÔÚÀ´ÒÔ¡°×¢²áÐÂÓû§Ê±Óû§ÃûÊÇ·ñÖØ¸´¡±ÕâÒ»¼ÙÉèÀ´½²½âÈçºÎÓÃajax·½Ê½½øÐÐУÑé¡£ ¼ÙÉèËØ²Ä£º Ò³Ãæ£ºsys_user_new.screen BmÎļþ£ºsys_user_check.bm£¨ÔÚsysĿ¼Ï£© Pl sql°ü£ºsys_user_pkg 22 °üÄÚÓõ½µÄ¹ý³Ì£ºcheck_username( p_username varchar2 , p_resultcd out varcahr2); Ê×ÏÈ£¬ÔÚscreenÎļþÖУ¬Í¨¹ýAurora.request·½·¨½øÐÐajaxµ÷Ó㺠Aurora.request({ url : \, params : { user_name : 'AA' }, opts : opts, success : function(response, options) { var result_cd = response.result.result_cd; if (result_cd == 0) { //ÒµÎñÂß¼Éϳö´í } else { } }, failure : function(response, options) { }, scope : scope }); //ÒµÎñÂß¼µÄ³É¹¦ ÕâÀïµÄÓû§ÃûÎÒÃǼÙÉèΪAA£¬Êµ¼ÊÓ¦ÓÃÖÐÎÒÃÇÓ¦µ±´ÓÓû§µÄʵ¼ÊÊäÈë»ñÈ¡¡£µ±Ö´Ðе½´Ëjs´úÂëʱ£¬ä¯ÀÀÆ÷¼´Ïò·þÎñÆ÷·¢ËÍÒ»¸öÇëÇó¡£µØÖ·ÎªurlÖÐÉùÃ÷µÄµØÖ·£¬²ÎÊýΪparams¡£ ÎÒÃÇÔÙÀ´¿´bm¶Ë Ê×ÏÈbmÖÐµÄ ÔÚÕâÀïÎÒÃǸù¾Ý·µ»ØµÄ״̬À´×ö½øÒ»²½´¦Àí£¬Õâ¾ÍÊÇÕû¸öµÄУÑé¹ý³Ì¡£ 24 4 bmÌØÐÔ BmÎļþ¼È¿ÉÒÔÊǶÔÊý¾Ý±íµÄÓ³É䣬Ҳ¿ÉÒÔ¶¨ÒåÊý¾Ý¿â²Ù×÷¡£ËüÊÇ¿ò¼Ü×Ô¶¨ÒåÃüÃû¿Õ¼äÊôÐÔµÄxmlÎļþ£¬»ùÓÚµ¥ÕÅÊý¾Ý¿â±íµÄ£¬Í¨¹ý¿ò¼Ü×Ô¶¨ÒåµÄһЩ½ÚµãºÍtag£¬À´¶¨ÒåÒ»°ã±í´ïÒµÎñÂß¼µÄÂß¼µÄÎļþ¡£ 4.1²éѯ Ò»¸öbmÎļþÊǶÔÒ»ÕÅÊý¾Ý±í½øÐÐÓ³Éäʱ£¨¼´ÌصãÊǸù½ÚµãÖÐÉùÃ÷ÓÐbaseTableÊôÐÔ£¬Í¬Ê±ÔÚbmÎļþÄÚÉùÃ÷ÓÐfields½Úµã£©£¬ÎÒÃÇÔÝʱ¼ÙÉè´ËbmÎļþÃûΪtestbm.bm£¬ËùÔÚλÖÃÊÇweb-inf/classes/test/testbm.bm£¬Í¬Ê±£¬µ±Ò³Ãæ·¢³öÒ»¸ö²éѯÇëÇóʱ£¨²»´øÈκβéѯ²ÎÊý£© URL£º${/request/@context_path}/autocrud/test.testbm/query} ´Ó´Ëurl¿´³ö£¬ÇëÇóµÄÊǸÃbmµÄquery·½·¨¡£ 4.1.1ͨ¹ýbaseTabelºÍfields×Ô¶¯Éú³ÉµÄ²éѯ Èç¹û¸ÃbmÊǶÔÒ»ÕÅÊý¾Ý±í£¨»ò¶àÕÅ±í£¬ÒÔÆäÖÐÒ»ÕűíΪÖ÷±í£¬Í¨¹ýbmÖйØÁªÆäËûÊý¾Ý±íµÄ·½·¨×éÖ¯ÆðÀ´£©µÄÓ³É䣬ÄÇô¿ò¼Ü»á³¢ÊÔ´ÓÓ³Éä¹ØÏµÖÐÉú³É²éѯÓï¾ä ÓÐʱºò×Ô¶¯Éú³ÉµÄqueryÓï¾äÎÞ·¨Âú×ãÐèÇ󣨱ÈÈçÓÐunion×Ó¾äʱ£©£¬Õâʱ¾ÍÐèÒª×ÔÐÐдqueryÓï¾ä¡£¾ßÌå·½·¨ÈçÏ£º ? operation name=\£ºÕâÀï±ØÐ뽫nameµÄֵдΪquery£¬µ±Ò»¸ö²éѯÇëÇó¹ýÀ´Ê±£¬²ÅÄÜÕýÈ·ÕÒµ½ÎÒÃÇдµÄsql ? #WHERE_CLAUSE#£ºÕâÀïÊÇΪÁ˺Íquery-fieldÅäºÏʹÓ㬵±Óи½¼Ó²éѯÌõ¼þ¹ýÀ´Ê±£¬Èç¹ûºÍ query-fieldÖеÄÄÜÆ¥ÅäÉÏ£¬ÔòÒªÔÚsqlÓï¾äÆ´½ÓÌõ¼þ×Ӿ䡣ÓÉÓÚÕâʱÎÒÃÇ×Ô¼º±àдµÄ²éѯ£¬Òª¸ø¿ò¼ÜÖ¸Ã÷Ìõ¼þ×Ó¾äҪƴ½Óµ½Ê²Ã´µØ·½¡£ ? ¼þ×Ӿ䣬±ÈÈçÎÒÃÇÔÚexpression ÖÐд¡±1=1¡±£¬ÄÇôÎÞÂÛÇ°ÃæµÄsqlÈçºÎ£¬×îÖÕÐγɵÄsqlÓï¾äÖÐÒ»¶¨ÓÐ (and) 1=1 ¡£ Èç¹ûÔÚûÓÐÈκθ½¼Ó²éѯÌõ¼þµÄÇé¿öÏ£¬ÎÒÃÇ×Ô¼ºµÄsql±¾Éí¾Íº¬ÓÐwhere×Ӿ䣨Èç±íÁ¬½Ó£¬Ä¬ÈϲéѯÌõ¼þµÈ£©£¬ÐèÒªÌØÊâ×¢Òâһϣ¬ÎÒÃDz»ÄÜдΪÈçÏÂÐÎʽ£º #WHERE_CLAUSE# ]]> ½â¾ö°ì·¨ÓÐÁ½ÖÖ£º ? ½«Ä¬ÈϾÍÓеÄwhere×Ó¾äдÔÚdata-filterÀ ? ½«×Ô¼ºÐ´µÄ²éѯÓï¾ä×öǶÌ×£¬ÈçÉÏÀý£¬ÎÒÃǸÄÔì³ÉÈçÏÂÐÎʽ£º Èç¹ûÔÚͬһ¸öbmÖм´·ûºÏ¿ÉÒÔ×Ô¶¯Éú³É²éѯsqlµÄÌõ¼þ£¬ÓÖÓÐ×Ô¼ºÊéдµÄsql£¬ÄÇô£¬Ö»»áÖ´ÐÐ×ÔÐÐÊéдµÄbm¡£ 4.2insert¡¢update¡¢delete 4.2.1ͨ¹ý¿ò¼Ü×Ô¶¯Éú³É Èç¹ûÒ»¸öbm¶ÔÓ¦Ò»ÕÅÊý¾Ý±í£¬ÄÇô£¬¿ÉÒÔ×Ô¶¯Éú³É¶ÔÓ¦µÄÔöɾ¸ÄÓï¾ä¡£±ÈÈçÔÚHAPϵͳµÄ¡°ÏµÍ³ÃèÊö¡±¹¦ÄÜÖУ¬µ±µã»÷gridÖеÄÐÂÔö°´Å¥Ê±£¬»á¶à³öÒ»ÐУ¬µ±Óû§Ìîдºóµã±£´æ£¬»á½«Êý¾Ý´«Èëbm£¬bmÉú³ÉinsertÓï¾ä¡£ 28 4.2.2ͨ¹ýÔÚbmÖж¨Òå ÀàËÆÓÚ²éѯ£¬Í¬Ñù¿ÉÒÔÔÚbmÎļþÖбàд×Ô¼ºµÄinsertÓï¾ä¡£ÕâÀï¾Í²»ÔÙ׸Êöϸ½Ú²¿·Ö£¬ºÍ²éѯÐÎʽÀàËÆ¡£ 4.2.3ʹÓÃinsert¡¢update¡¢deleteÐèҪעÒâµÄÄÚÈÝ Èç¹ûÄãÏ£Íû²»¹Üʲôʱºò¶¼Äܹ»ÕýÈ·µ÷ÓÃÄã×ÔÐÐÊéдµÄsqlʱ£¬ÒªÊ±¿Ì½÷¼ÇÒÔÏÂÄÚÈÝ£º Ö®ËùÒÔÊý¾ÝÌá½»µ½ºǫ́£¬¿ò¼ÜÄܹ»×Ô¶¯Ê¶±ðµ½µ×ÊÇÐÂÔö»¹ÊÇÐ޸ϹÊÇɾ³ý£¬Ö÷ÒªÊÇÓÐÒ»¸öÒþ²ØµÄ²ÎÊýÀ´¾ö¶¨£º_status¡£µ±ÔÚdatasetÉϵ÷ÓÃadd()·½·¨ÐÂÔöÒ»ÐÐÊý¾Ýʱ£¨µã¡°ÐÂÔö°´Å¥¡±Êµ¼ÊÒ²Êǵ÷Óô˷½·¨£©£¬»áÔÚÐÂÉú³ÉµÄrecordÖÐ×Ô¶¯¼Ç¼һ¸öÊôÐÔÖµ _status:insert¡£µ±Ò»Ìõ¼Ç¼ÓÐÐÞ¸Äʱ£¬»á×Ô¶¯Ð޸ĴËÊôÐÔΪupdate¡£µ±´Ë¼Ç¼´«µÝµ½bm¶Ëʱ£¬bm¿¿´Ë±ê¼ÇÀ´È·¶¨µ½µ×Ó¦¸Ãµ÷ÓÃʲôÐÐΪ¡£ËùÒÔ£¬Èç¹ûÄãµÄdatasetÖÐûÓÐÐÂÔöµÄÐУ¬ÄÇô½«Êý¾Ý´«Ë͵½bm¶Ëʱ²»»áÖ´ÐÐinsert²Ù×÷ÖеÄÄÚÈÝ£»Í¬Àí¿É¼ûupdateºÍdelete¡£ 4.2.4¶Ôbatch_updateµÄ½âÊÍ µ±ÄãµÄdatasetÖÐÓжàÌõÊý¾ÝÓÐÐ޸ĻòÐÂÔöʱ£¬×îºóµã»÷¡°±£´æ¡±°´Å¥£¬»áµ÷ÓÃdatasetµÄsubmit()·½·¨¡£È»ºó¿ò¼Ü½«datasetÖÐËùÓÐÐ޸Ĺý£¨°üÀ¨ÐÂÔö£©µÄrecordµÄÊý¾Ý×é×°³Éjson¸ñʽ´«µÝµ½bm£¬submitUrlÈçÏ£º /hclc/autocrud/sys.sys_service/batch_update ¾¹ý²¶»ñ£¬ÎÒÃÇÁ˽⵽´«Êä²ÎÊýµÄ½á¹¹´óÖÂÈçÏ£¨ÒѾ¾¹ý¸ñʽ»¯£©£º { \ : [ { \ : 2202, \ : \, \ : \, \ : \, \ : \, \ : \, \ : \ÇëÎð555\, \ : 1022, \ : \ }, { \ : \, \ : \, \ : \, \ : \, \ : \, \ : \, \ : 1024, 29 \ : \ }, { \ : \¶þ¶ñ\, \ : \, \ : \, \ : \, \ : \, \ : \ÐÄiol\, \ : 1025, \ : \ } ] } ¿ÉÒÔ¿´³ö£¬´«Êä¹ýÈ¥µÄjson¸ñʽµÄÊý¾ÝÖÐÓÐÈý×éÊý¾Ý£¬Ò»Ìõupdate£¬Á½Ìõinsert¡£ Batch_updateÊÇ¿ò¼ÜÖеÄÒ»ÖÖʵÏÖ»úÖÆ£¬Ê¹ºǫ́Äܹ»Ñ»·´¦ÀíÿÌõ´«µÝ¹ýÀ´µÄÊý¾Ý£¬²¢ÇÒ¸ù¾Ý_statusÀ´ÅжϸÃÈçºÎ´¦ÀíÿÌõÊý¾Ý¡£ 4.3×Ô¶¨ÒåBMµÄSQL³ö´íÐÅÏ¢ ÔÚbmÀï¿ÉÒÔ²¶»ñÖ±½Ó²¶»ñÊý¾Ý¿âÅ׳öµÄÒì³£ÐÅÏ¢£¬±ÈÈçÔÚbmÖвåÈëÊý¾ÝµÄÖ÷¼üÖØ¸´Òì³£¡£ ×ö·¨ÈçÏ£º 1. ÔÚbmµÄ¸ù½ÚµãÉùÃ÷ÃüÃû¿Õ¼ä¡£xmlns:e=\2. ÔÚbmÖÐÔö¼ÓÈçÏÂ×ÓÔªËØ¡£ handleClass=\ Code£º´ú±íÊý¾Ý¿âÅ׳öµÄÒì³£´úÂë¡£ÈçÖ÷¼üÖØ¸´´úÂëORA-00001,д³É1. Message£ºÕë¶Ô¸Ã´íÎóµÄÌáʾÐÅÏ¢ ¡£ÈçÖ÷¼üÖØ¸´¡£Ð´³É¡°»úÐÍÖØ¸´¡±¡£ 4.4 ¶àÓïÑÔ 4.5 Standard who ÿ¸ö±í¶¼ÓÐËĸö×ֶΣº´´½¨ÈË£¬´´½¨Ê±¼ä£¬¸üÐÂÈË£¬¸üÐÂʱ¼ä¡£Óиýڵãºó£¬¿ò¼Ü»á×Ô¶¯Î¬»¤ÕâËĸö×ֶεÄÐÅÏ¢¡£Ç°ÌâÊÇËùÓеÄdml²Ù×÷¶¼ÊÇ·Ç×Ô¶¨ÒåµÄ¡£Èç¹ûÊÇ×Ô¼º¶¨ÒåµÄ²Ù×÷,ÈçдµÄplsql¹ý³Ì¡£ÄÇôÔÚplsql¹ý³ÌÀï¾ÍÒª×Ô¼ºÎ¬»¤ÁË¡£ 30 4.6Lookup code ±íʾ¸ÃÊôÐÔµÄÖµÐèҪͨ¹ýÆäËû×Ö¶ÎÐÅÏ¢À´ÃèÊö. ÈçstatusÓÐÁ½¸öÖµ£¬1ºÍ-1£¬ÎÒÃÇÐèÒª±íʾ³ÉÕý³£ºÍ²»Õý³£¡£StatusµÄlookupCodeÖµÊÇstatus_code.ÄÇô¸ÃÊôÐÔֵдÉÏlookupCode=¡±status_code¡±¾ÍÐÐÁË¡£Status_codeµÄÖµÊDZíʾÕý³£ºÍ²»Õý³£µÄ´úÂë¡£ÕæÕýµÄÕý³£ºÍ²»Õý³£µÄÖµµÄ±íʾ»¹ÐèÒªÅä¸ölookupFieldÊôÐÔ, lookupField=¡± Status_code_description 4.7Ö´Ðж¯Ì¬SQL ¶¯Ì¬sql£¬¾ÍÊǸù¾Ý´«ÈëµÄÌõ¼þµÄ²»Í¬£¬Ö´Ðв»Í¬µÄsqlÓï¾äµÃµ½²»Í¬µÄsql½á¹û¡£ Óï·¨:excute immediate <¶¯Ì¬sql> into <Êä³ö²ÎÊý>¡£ ÈçÏÂÀý×Ó£º begin --Ö´ÐÐÐÐͷУÑ飬³ö´íÍ˳ö³ÌÐò for i in 1 .. 21 loop v_sql := ' select a.attribute_' || i || ' from fnd_interface_lines a where a.line_id = ' || xxx || ' order by a.header_id desc, a.line_id asc'; execute immediate v_sql into sss(i); end loop; exception when others then null; end ; ±¾ÀýÊDzéѯ¶à¸öÖµ·Åµ½Êý×ésss(i)ÖС£SssµÄ¶¨ÒåÕâÀïÊ¡ÂÔ¡£Xxx´ú±í±äÁ¿²ÎÊý¡£ ÔÚbmµÄ×Ô¶¨ÒåµÄ²Ù×÷ÖУ¬¼´¾ÍÊÇÔÚoperation½ÚµãÖÐÐèÒªÖ´Ðж¯Ì¬sqlÀ´Íê³ÉÄãµÄÂß¼¡£¿É·ÂÕÕ´ËÀý¡£ 31 5¸÷ÖÖ×é¼þ ×¢£ºÕ¹Ê¾×é¼þÐèÒª·Åµ½view±êÇ©ÖС£ 5.1 vbox£¬hbox 5.1.1vbox box×é¼þÀàËÆÓÚhtmlÖеÄdiv±êÇ©£¬ÔÚÒ³ÃæÉϲ»×öÏÔʾ£¬ÓÃÓÚ¿ØÖÆÆäËû×é¼þµÄλÖã¬Ï൱ÓÚÒ»¸ö²¼¾ÖÈÝÆ÷¡£ vBox×é¼þÔÚbox×é¼þµÄ»ù´¡ÉÏÌí¼ÓÁËÊúÏòÅÅÁеÄÏÞÖÆ£¬ÔÚvBoxÖеÄ×é¼þÈ«²¿×ÝÏòÅÅÁУ¬Ï൱ÓÚcolumnºãµÈÓÚ1£¬Òò´Ë²»ÐèÒªÉèÖÃcolumnÊôÐÔÏÞÖÆÁÐÊý¡£ ÀýÈ磺ÔÚscreenÎļþÖÐÓÐÈçÏ´úÂ룺 hBoxÔÚbox×é¼þµÄ»ù´¡ÉÏÌí¼ÓÁ˺áÏòÅÅÁеÄÏÞÖÆ£¬ÔÚhBoxÖеÄ×é¼þÈ«²¿ºáÏòÅÅÁУ¬Ï൱ÓÚrowÊôÐÔºãµÈÓÚ1£¬Òò´Ë²»ÐèÒªÉèÖÃrowÊôÐÔ£¬ÀýÈçÓÐÈçÏ´úÂ룺 32 5.2 form²¼¾Ö 5.2.1 formµÄÏÔʾЧ¹û formÔÚboxµÄ»ù´¡É϶àÌṩÁËÒ»¸ötitle£¬´úÂëÈçÏ£º 5.2.2 formµÄ³£ÓÃÊôÐÔ formµÄ³£ÓÃÊôÐÔ³ýÁËtitleÍ⣬»¹ÓÐwidth(¿í)£¬height(¸ß),column(ÁÐÊý)£¬row(ÐÐÊý)ÊôÐÔ£¬ÏÂÃæµÄ´úÂ뽫´´½¨Ò»¸ö¿í300£¬¸ß120£¬2ÐУ¬2ÁеÄform¡£ÈçͼÏ£º 5.3 Auto Complete 5.4 ͨ¹ýÈÎÒâhtmlÄ£°å²¼¾Ö 5.5 tree 5.5.1 treeµÄ¹¹½¨·½·¨ treeÓÃÓÚ¹¹½¨Ò»¸öÊ÷¶ÔÏó£¬Í¨³£ÓÃÓÚ¹¹½¨²Ëµ¥£¬»òÕ߸´ÔӵĻú¹¹²ã´Î£¬ÏÔʾЧ¹ûÈçÏ£º 33 Ê÷ÖеÄÿ¸ö½Úµã¶¼ÊÇËù°ó¶¨µÄÊý¾Ý¼¯(dataset)ÖÐÿһÌõ¼Ç¼(record) ½ÚµãÓë½ÚµãÖ®¼äµÄ²ã´Î¹ØÏµÊÇͨ¹ýtree±êÇ©µÄÊôÐÔidFieldºÍparenFeildÀ´ÁªÏµµÄ£¬idFieldÊôÐÔÖ¸¶¨µÄÊÇrecordÖÐÓÃÀ´±íʾ¸Ã½ÚµãµÄΨһ±êʶ(ID)µÄ×Ö¶Î(field)Ãû£¬parentFieldÊôÐÔÖ¸¶¨µÄrecordÖÐÓÃÀ´±íʾ¸Ã½ÚµãµÄ¸¸½ÚµãµÄIDºÍfieldÃû¡£ Tree±êÇ©µÄÊôÐÔdisplayFieldÖ¸¶¨µÄrecordÖÐÓÃÀ´±íʾ½ÚµãÎı¾ÐÅÏ¢µÄfieldÃû¡£ ÏÂÃæµÄ´úÂ뽫¹¹½¨Ò»¸ö¼òµ¥µÄÊ÷¡£ 5.5.2 treeµÄÊ÷½ÚµãäÖȾ ͨ¹ý½ÚµãäÖȾ£¬ÎÒÃÇ¿ÉÒÔΪÊ÷½ÚµãÌí¼Ó³¬Á´½Ó¡£ÔÚtree±êÇ©ÖÐÖ¸¶¨rendereräÖȾº¯ÊýʵÏÖ¡£ ´úÂëÈçÏ£º 34 ½ÚµãµÄÑÕÉ«±äΪ³¬Á´½ÓµÄÑÕÉ«£¬µã»÷ºó¿ÉÒÔÁ¬½Óµ½ÏàÓ¦µÄurlÒ³Ãæ¡£ 5.6treeGrid 5.6.1 treeGridµÄ¹¹½¨·½·¨ ºÍtreeÀàËÆ£¬treeGridÐèÒªÖ¸¶¨¸¸½Úµã£¬ÏÔʾµÄ×ֶΣ¬ºÍµ±Ç°½ÚµãID¡£µ«Í¬Ê±Ò²¼¯³ÉÁËgridµÄÒ»Ð©ÌØÐÔ£¬¿ÉÒÔͨ¹ýcolumns±êǩָ¶¨¶à¸öÏÔʾÓò£¬ÊµÀý´úÂëÈçÏ£º 5.6.2 treeGrid½ÚµãäÖȾ·½·¨ treeGridͨ¹ýʹÓÃeditors±êÇ©äÖȾ½Úµã£¬Ð޸ĴúÂëÈçÏ£º 5.6 gridÁÐËø¶¨(lock)£¬¸´ºÏ±íÍ· ÔÚʵ¼ÊÐèÇóÖУ¬ÓÐʱºòÐèÒªÔÚgridµÄÏÔʾÉÏ×öÒ»Ð©ÌØÊâµÄ´¦Àí£¬Ä¿Ç°ÎÒÃÇÒÑÖªµÄÓÐÁ½ÖÖÌØÊâµÄÐèÇó£ºËø¶¨gridÖеÄijһÁУ¬ÒÔ±ãÔÚÍ϶¯gridÉϵĺáÏò¹ö¶¯Ìõ£¨Èç¹û´æÔÚ£©Ê±£¬±»Ëø¶¨µÄÁÐʼÖÕ±£³Ö¹Ì¶¨ÔÚÁбíµÄ×î×ó²à£»ÁíÒ»ÖÖÊǽ«Ò»ÐбíÍ··ÖΪ¶àÐУ¬ÒÔÆðµ½ºÏ²¢Í¬ÀàÏîµÄЧ¹û 5.6.1Ëø¶¨ÁÐ ÎÒÃÇÊ×ÏÈÀ´¿´Ò»ÏÂËø¶¨ÁеÄЧ¹û£¬ÈçÏÂͼ£¬ÎÒÃÇÔÚ²éѯ½á¹ûÖÐËø¶¨¡°¸ÅËãÊé±àºÅ¡±ÕâÒ»ÁУ¬ÆäÓàÁв»×öÌØÊâ´¦Àí£¬Ð§¹ûÈçͼ£º 36 1Ëø¶¨ÁÐЧ¹û1 2Ëø¶¨ÁÐЧ¹û2 ʵÏÖ·½·¨£º ÔÚÐèÒªËø¶¨µÄcolumnÉϼÓÈëlock=¡±true¡±ÊôÐÔ¡£ 5.6.2¸´ºÏ±íÍ· ÈôҪʵÏÖÈçÏÂÐÎʽµÄ±íÍ· ¿ÉÒÔ½«ÐèÒª×éºÏµÄÁÐÓÃcolumn×éºÏ 5.7 ¸÷ÖÖÌáʾ(showmessage,showconfirm) 5.7.1 showmessageºÍshowconfirm ´úÂëÈçÏ£¬showmessageÖ»ÓÐÒ»¸öÈ·Èϰ´Å¥£¬¶øshowconfirm¿ÉÒÔÑ¡ÔñÈ·¶¨»òÕßÈ¡Ïû£¬µã»÷°´Å¥ºó¿ÉÒÔÖ´ÐвÎÊýÏàÓ¦µÄ»Øµ÷º¯Êý¡£ function drop(){ if(true){ Aurora.showMessage('title','messages'); }else{ Var fc=Aurora.showConfirm('±êÌâ','ÏûÏ¢ÄÚÈÝ',function(){ 38 Aelrt(¡®1¡¯); Fc.close();}); } } ÏÔʾЧ¹ûÈçÏ£º ShowmessageµÄÏÔʾЧ¹û showConfirmµÄÏÔʾЧ¹û µã»÷È·¶¨ºóÏÔʾ£º ÐèҪעÒâµÄÊÇ£¬¿ò¼ÜÖеÄshowconfirmºÍ»ù±¾jsµÄconfirm²»Í¬£¬¿ò¼ÜÖеÄÈ·ÈÏ¿òÆð²»µ½×èÈû×÷Ó㬶ø»ù±¾js¿ÉÒÔ¡£Ê¾ÀýÈçÏ£º function testConfirm() { var result = false; var comfirm = Aurora.showConfirm('title', 'È·¶¨Ìá½»£¿', function() { //µã¡°ÊÇ¡±ºóµÄ»Øµ÷ result = true; }, function() { //µã¡°·ñ¡±ºóµÄ»Øµ÷ 39 result = false; }, null, 100); return result; } ÏÖ¸ø³öÇé¾°ÈçÏ£º³öÏÖÈ·ÈÏ¿òºó£¬µ±Óû§µã»÷¡°ÊÇ¡±µÄʱºò£¬ÇëÅжϸú¯Êý·µ»ØµÄ½á¹ûÊÇtrue»¹ÊÇfalse£¿ Èç¹ûÓû§ÎÞ·¨ÓñȳÌÐò˳ÐòÖ´ÐеÄËÙ¶È»¹Òª¿ìµÄËÙ¶ÈÈ¥µã»÷¡°ÊÇ¡±µÄ»°£¬ÄÇô²»ÂÛÓû§µãʲô°´Å¥£¬Ê¼ÖÕ·µ»ØµÄÊÇfalse¡£ ÒòΪ¿ò¼ÜÖеÄÈ·ÈÏ¿òÊÇ·Ç×èÈûÐԵģ¬ÔÚ¸ø³öÈ·ÈÏ¿òµÄͬʱ£¬³ÌÐò˳ÐòÖ´Ðе½ÏÂÒ»²½£¬¼´return½á¹û¡£ 5.8 tabµÄÓ÷¨ 5.8.1 tabµÄʹÓà ÔÚscreenÎļþÖÐÎÒÃÇͨ¹ý Èçδָ¶¨selectedÊôÐÔ£¬ÔòĬÈÏΪµÚÒ»¸ötabҳΪѡÖÐ״̬¡£ 41