使用Office XP Developer 开发 Solution.pptVIP

议程 MOD 概要 产品历史 MOD XP 功能概要 工作流和数字化仪表板 演示 – SQL Workflow and Dashboard Workflow Designer 使用策略 开发管理 Questions? Product History 新功能 VBA 增强工具 代码库 同开发环境集成 多代码库 Import/export 功能 增强的语言支持 (4 more languages) Korean Chinese (Traditional Simplified) Spanish Italian 基于团队应用的协作功能 其他新功能 开发平台 Exchange Dev/Test Limited license Full product SQLServer2000 Personal Edition Full toolset Enterprise Manager Query Analyzer Full online help Books Online Plus: 免费的 MSDE2000! What is workflow? 工作流策略 简化工作流应用的开发 SQL Server Exchange 2000 Server No special-purpose clients 基于Server的工作流 No client-specific code required Used with any environment with access to SQL Server data or Exchange data 面向团队自动化 Approval, Review, Routing, Tracking Workflow Designer Design Tool Visual Designer for defining workflow processes Create flow visually Add script to workflow process Specify workflow permissions Activate/deactivate workflow process Statement Completion on workflow objects 工作流运行时架构 What is a Digital Dashboard? Solution开发步骤 Diagram Workflow Process Use designer in environment Add script to customize Create UI for workflow Use familiar tools Create a Dashboard Create web parts (HTML, XML, VBS, JS) Demo 工作流的几个重要概念 Workflow Concepts The Three Key Concepts: State The current status of a workflow item. Action An operation applied to a workflow item. Transition A special type of action, that changes the state of a workflow item. Workflow Action Table Table of valid state-transitions Conditions and actions are VB Scripts WF Engine evaluates conditions WF Engine executes actions Action/Event Description Security Use SQL 7.0/2K in NT or Mixed Authentication Mode Native features: database, table, column security NTFS permissions on application Web Designer provides: workflow action security Administration Workflow Templates Application Blueprint Contain the database schema Files from the Web Location Can add user defined files Exist as a .TPL file Stored on the Workflow Server for later use Ready to