《Demo功能介绍》PPT课件.ppt

Demo功能介绍,框架基于CRM2.0框架,技术包括webui、buffalo、pojo等Demo功能描述完成数据模型库表的增删改查,数据模型,数据模型说明,产品实例：客户信息、产品类型、时间信息(创建、起租、停租、竣工)等参与人:记录参与人详细信息产品实例参与人关系：记录参与人与产品实例关系,创建菜单示例SQL,mm_menu(菜单表)insertintomm_menu(MENU_ID,SYSTEM_ID,MENU_CODE,MENU_NAME,ORDER_ID,TARGET_NAME,PARAMETER,OPEN_FLAG,PRIVILEGE_FLAG,VALID_FLAG,MENU_TYPE,MENU_GRADE,SUPER_ID,IMAGE_PATH,COMMENTS,PATH_CODE)values(10289,1,2013140000,员工密码激活,1,/CrmWeb/oaas/manager/PasswordActivation.jsp,0,0,0,1,605,2000000000.2013000000.2013140000);mm_data_privilege(权限表)insertintomm_data_privilege(PRIVILEGE_ID,DATA_PKEY_1,DATA_PKEY_2,DATA_PKEY_3,DATA_PKEY_4)values(345,10289,-1,-1,);,增加静态数据SQL示例,dc_sql（静态数据配置主表）insertintodc_sql(DC_NAME,DC_SQL,DC_DESC)values(COMM_RECORD_STATE,selectp.pkey,p.pnamefromdc_publicpwherep.stype=100001,);dc_public（静态数据配置项表）insertintodc_public(STYPE,PKEY,PCODE,PNAME,COMMENTS)values(100010,0,0,不使用缓存,tfm_services.cache_flag取值);,序列SQL示例,createsequenceSEQ_PROD_INSTminvalue1maxvalue999999999999999startwith1incrementby1cache20;,BO配置SQL,Tfm_services(服务配置主表)insertintotfm_services(SERVICE_NAME,ENV_ID,VERSION,SERVICE_DESC,SERVICE_TYPE,STATE,CACHE_FLAG,MODULE_NAME,IF_LOG)values(MONITORSERVICE,2009-11-27测试buffalo与长研框架结合,1,1,1,);tfm_serv_class_def(javabean配置表)insertintotfm_serv_class_def(SERVICE_NAME,CLASS_NAME)values(A,com.powerise.ibss.framesist.test.itest.A);,perties(Buffalo配置文件),LoginService=com.ztesoft.oaas.service.LoginService,CRM2.0框架调用层次,Browser,DBServer,Browser,Brow