pagectlsql.properties

来自「J2EE客户关系管理系统!!!!!!!!!!!!!!!!!!!!」· PROPERTIES 代码 · 共 24 行

empviewkey = select a.*, b.dname from emp a,  dept b where a.deptno*=b.deptno
empviewkey1 = select * from sal_chance where 1=1 and chc_status <=2
empviewkey2 = select * from sal_chance where 1=1  and chc_status>=2
cst_lost = select lst_cust_name,lst_cust_manager_name,lst_lost_date,lst_reason from cst_lost where 1=1
cst_service = select svr_type,coun1=count(*) from cst_service where 1=1 
cstcst_customer = 
orders_linecst_customer =
user_roledqq = select * from sys_user where 1=1 and user_status=1


empselect = select * from emp
cst_customer=select * from cst_customer where cust_status <'3'
orders=select * from orders where 1 = 1
linkman=select * from cst_linkman where 1=1
active=select * from cst_activity where 1=1
lostsql=select * from cst_lost where 1=1
selectdict=select * from bas_dict where 1=1


service=select * from cst_service where 1=1
empselect0 = select * form cst_service
product=select * from product where 1=1
storage=select a.*, b.prod_name from storage a,product b where a.stk_prod_id=b.prod_id
dict=select * from bas_dict where 1=1