类似switch的条件语句ps（case）

最新推荐文章于 2024-08-23 21:52:40 发布

爆炸头666

最新推荐文章于 2024-08-23 21:52:40 发布

阅读量997

点赞数

分类专栏： PeopleSoft

本文链接：https://blog.csdn.net/chun0031/article/details/7712385

版权

PeopleSoft 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

    Evaluate &str_init_db_type
      When "1"
         SQLExec("SELECT TZ_APP_ATTR_STR FROM PS_TZ_APP_ATTR_DHW WHERE TZ_APP_INS_ID = :1 AND TZ_APP_ATTR_ID = :2", &int_app_ins_num, &str_init_field_name, &str_init_field_value);
         Break;
      When "2"
         SQLExec("SELECT TO_CHAR(TZ_APP_ATTR_DATE,'YYYY/MM/DD') FROM PS_TZ_APP_ATTR_DAT WHERE TZ_APP_INS_ID = :1 AND TZ_APP_ATTR_ID = :2", &int_app_ins_num, &str_init_field_name, &str_init_field_value);
         Break;
      When "3"
         SQLExec("SELECT TZ_APP_ATTR_LONG FROM PS_TZ_APP_ATTR_ARE WHERE TZ_APP_INS_ID = :1 AND TZ_APP_ATTR_ID = :2", &int_app_ins_num, &str_init_field_name, &str_init_field_value);
         Break;
      When "4"
         SQLExec("SELECT TZ_APP_ATTR_NUM FROM PS_TZ_APP_ATTR_NUM WHERE TZ_APP_INS_ID = :1 AND TZ_APP_ATTR_ID = :2", &int_app_ins_num, &str_init_field_name, &str_init_field_value);
         Break;
      End-Evaluate;