MES_Client/TGMES/Core.StlMes.Client.Sale.Common/Script/Model Development.txt

-- 定义字段
select 'private   ' || case
         when a.data_type like '%CHAR%' then
          'string'
         when a.data_type like '%DATE%' then
          'DateTime'
   when a.data_type like '%TIME%' then
          'DateTime'
         when a.data_type like '%NUM%' then
          'double'
   when a.data_type like '%LONG%' then
          'double'
         else
          'string'
       end || '   _' || a.column_name ||';'
from   user_tab_columns a
where  a.table_name = 'SEL_FUND_CUST_FUNDINOUT'
order  by a.column_id asc;

-- 定义字段
select 'public static string ' || '' || a.column_name ||'= "'||a.COLUMN_NAME ||'";'
from   user_tab_columns a
where  a.table_name = 'SLM_BASE_REGION_T'
order  by a.column_id asc;

-- 设置属性值
select  'public   ' || case
         when a.data_type like '%CHAR%' then
          'string'
         when a.data_type like '%DATE%' then
          'DateTime'
   when a.data_type like '%TIME%' then
          'DateTime'
         when a.data_type like '%NUM%' then
          'double'
   when a.data_type like '%LONG%' then
          'double'
         else
          'string'
       end || '   ' || a.column_name || '' || ' { get { return this._' ||
       a.column_name || ';}' || ' set {this._' || a.column_name ||
       ' = value;}}'

from   user_tab_columns a
where  a.table_name = 'SEL_FUND_CUST_FUNDINOUT'
order  by a.column_id asc;


-- 给字段赋值,可参看类Core.LgMes.Client.LgModel.LgPlan.JH2_STEEL_HEAT
select 'try{ fund.' || a.column_name || ' = ' || '' || case
         when a.data_type like '%CHAR%' then
          'Convert.ToString'
         when a.data_type like '%DATE%' then
          'Convert.ToString'
         when a.data_type like '%TIME%' then
          'Convert.ToString'
         when a.data_type like '%NUM%' then
          'Convert.ToDouble'
         when a.data_type like '%LONG%' then
          'Convert.ToDouble'
         else
          'Convert.ToString'
       end || '(' || 'dr[' || '"' || a.column_name || '"' || ']);' || '}' ||
       '   catch {}'
from   user_tab_columns a
where  a.table_name = 'SEL_FUND_CUST_FUNDINOUT'
order  by a.column_id asc

select 'private   ' || case
         when a.data_type like '%CHAR%' then
          'String'
         when a.data_type like '%DATE%' then
          'java.util.Date'
   when a.data_type like '%TIME%' then
          'java.util.Date'
         when a.data_type like '%NUM%' then
          'Double'
   when a.data_type like '%LONG%' then
          'Double'
         else
          'String'
       end || '  ' ||upper(substr(a.COLUMN_NAME,1,1))|| lower(substr( a.column_name,2)) ||';'
from   user_tab_columns a
where  a.table_name = 'SLM_BASE_CUSTOMER'
order  by a.column_id asc;

select 'bean.set' || upper(substr(a.COLUMN_NAME, 1, 1)) ||
       lower(substr(a.column_name, 2)) || '('|| '('||  case
         when a.data_type like '%CHAR%' then
          'String'
         when a.data_type like '%DATE%' then
          'java.util.Date'
         when a.data_type like '%TIME%' then
          'java.util.Date'
         when a.data_type like '%NUM%' then
          'Double'
         when a.data_type like '%LONG%' then
          'Double'
         else
          'String'
       end ||')' ||'hs.get(' || '"' ||
       a.COLUMN_NAME || '"' || ')'||') ;'
       ,
       'private   ' || case
         when a.data_type like '%CHAR%' then
          'String'
         when a.data_type like '%DATE%' then
          'java.util.Date'
         when a.data_type like '%TIME%' then
          'java.util.Date'
         when a.data_type like '%NUM%' then
          'Double'
         when a.data_type like '%LONG%' then
          'Double'
         else
          'String'
       end || '  ' || upper(substr(a.COLUMN_NAME, 1, 1)) ||
       lower(substr(a.column_name, 2)) || ';'
  from user_tab_columns a
 where a.table_name = 'SLM_BASE_CUSTOMER'
 order by a.column_id asc;
 
 select 'try {' ||'bean.set' || upper(substr(a.COLUMN_NAME, 1, 1)) ||
       lower(substr(a.column_name, 2)) || '('|| '('||  case
         when a.data_type like '%CHAR%' then
          'String'
         when a.data_type like '%DATE%' then
          'java.util.Date'
         when a.data_type like '%TIME%' then
          'java.util.Date'
         when a.data_type like '%NUM%' then
          'Double'
         when a.data_type like '%LONG%' then
          'Double'
         else
          'String'
       end ||')' ||'hs.get(' || '"' ||
       a.COLUMN_NAME || '"' || ')'||') ;'||' } catch(java.lang.Exception ex ) {}' hstb
       , 'try {' ||'bean.set' || upper(substr(a.COLUMN_NAME, 1, 1)) ||
       lower(substr(a.column_name, 2)) || '('|| '('||  case
         when a.data_type like '%CHAR%' then
          'String'
         when a.data_type like '%DATE%' then
          'java.util.Date'
         when a.data_type like '%TIME%' then
          'java.util.Date'
         when a.data_type like '%NUM%' then
          'Double'
         when a.data_type like '%LONG%' then
          'Double'
         else
          'String'
       end ||')' ||'set.getObject(' || '"' ||
       a.COLUMN_NAME || '"' || ')'||') ;'||' } catch(java.lang.Exception ex ) {}' hsset
       , 
       'private   ' || case
         when a.data_type like '%CHAR%' then
          'String'
         when a.data_type like '%DATE%' then
          'java.util.Date'
         when a.data_type like '%TIME%' then
          'java.util.Date'
         when a.data_type like '%NUM%' then
          'Double'
         when a.data_type like '%LONG%' then
          'Double'
         else
          'String'
       end || '  ' || upper(substr(a.COLUMN_NAME, 1, 1)) ||
       lower(substr(a.column_name, 2)) || ';'  col
  from user_tab_columns a
 where a.table_name = 'SLM_BASE_CUSTOMER'
 order by a.column_id asc;