# ************************************************************
# Sequel Pro SQL dump
# Version 4541
#
# http://www.sequelpro.com/
# https://github.com/sequelpro/sequelpro
#
# Host: 127.0.0.1 (MySQL 5.6.30)
# Database: cms
# Generation Time: 2018-03-14 03:56:05 +0000
# ************************************************************


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;


# Dump of table app_info
# ------------------------------------------------------------

DROP TABLE IF EXISTS `app_info`;

CREATE TABLE `app_info` (
  `APPID` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '系统编号',
  `APPNAME` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '子系统名称',
  `Subject` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '应用科目',
  `SortNo` varchar(12) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '排序号',
  `ISINUSE` varchar(1) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '是否可用',
  `workbench` varchar(1) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '工作台显示',
  `LOGO` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '是否可用',
  `MINLOGO` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '小图标',
  `URL` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '连接地址',
  `thumbnail` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`APPID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

LOCK TABLES `app_info` WRITE;
/*!40000 ALTER TABLE `app_info` DISABLE KEYS */;

INSERT INTO `app_info` (`APPID`, `APPNAME`, `Subject`, `SortNo`, `ISINUSE`, `workbench`, `LOGO`, `MINLOGO`, `URL`, `thumbnail`)
VALUES
	('ContentManage','内容管理','SystemManage','0040','1',' ','','','',NULL),
	('CustomerGrade','客户评级','CustomerManage','0020','0','1','','','',NULL),
	('CustomerManage','客户管理','CustomerManage','0010','1',NULL,'','','',NULL),
	('Customize','个性化定制','SystemManage','0020','1',NULL,'','','',NULL),
	('DataMiningMgr','数据挖掘','NewsCenter','0010','1','1','','','http://www.tudou.com',NULL),
	('EMailManage','邮件管理','SystemManage','0030','1','0','','','',NULL),
	('NewsMgr','新闻管理','NewsCenter','0020','1','','','','',NULL),
	('OutOfStorage','出入库管理','StorehouseManage','','1','1','','','datawindow_page.html?pagePath=service.good_access_list.page&inputUserID=${session.user.userID}',NULL),
	('SampleManage','样品管理','SampleManage','0010','1','1','','','datawindow_page.html?pagePath=service.sample_list.page',NULL),
	('SecondDevelop','二次开发','SystemManage','0030','1',NULL,'','','',NULL),
	('StoreHourseSetting','仓库设置','StorehouseManage','0090','1','1','','','datawindow_page.html?pagePath=system.depot_list.page',NULL),
	('SystemManager','系统管理','SystemManage','0010','1',NULL,'','','',NULL),
	('TodayAttendance','今日考勤','AttendanceManage','','1','1','','','todayAttendance.html',NULL),
	('UserManage','用户管理','SystemManage','0010','1',NULL,'','','',NULL);

/*!40000 ALTER TABLE `app_info` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table app_item
# ------------------------------------------------------------

DROP TABLE IF EXISTS `app_item`;

CREATE TABLE `app_item` (
  `ItemID` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '栏目编号',
  `APPID` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '子系统编号',
  `ItemName` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '栏目名称',
  `workbench` varchar(1) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '工作台显示',
  `SortNo` varchar(12) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '排序号',
  `ISINUSE` varchar(1) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '是否可用',
  `TriggerMode` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '触发方式',
  `URL` varchar(200) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '链接地址',
  PRIMARY KEY (`ItemID`,`APPID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

LOCK TABLES `app_item` WRITE;
/*!40000 ALTER TABLE `app_item` DISABLE KEYS */;

INSERT INTO `app_item` (`ItemID`, `APPID`, `ItemName`, `workbench`, `SortNo`, `ISINUSE`, `TriggerMode`, `URL`)
VALUES
	('AccountManage','UserManage','账户管理','','0010','1','javascript','DWControl.OpenDwWindow({id:'accountManage',title:'账户管理',page:'user.user_info_edit.jsp',param:'userID=${session.user.userID}',height:'200',width:'400'});'),
	('AppManager','SystemManager','子系统管理','1','4000','1','openTab','frame/layout.jsp?LayoutID=AppInfoFrame'),
	('CodeManager','SystemManager','代码管理','1','3000','1','openTab','frame/layout.jsp?LayoutID=CodeManager'),
	('ContractManage','ContentManage','电子合同管理','1','0020','1','openTab','system/layout_manage.jsp?LayoutID=ContractManage'),
	('ControlBoard','SystemManager','功能控制台','1','9002','1','openTab','datawindow_page.html?pagePath=system.control_board.page'),
	('CustomerContact','CustomerManage','客户交流','1','0040','0','openTab','datawindow_page.html?pagePath=customer.customer_list.page&inputUserID=${session.user.userID}'),
	('CustomerInfoManage','CustomerManage','客户信息','1','0010','1','openTab','datawindow_page.html?pagePath=customer.customer_list.page&inputUserID=${session.user.userID}'),
	('DataWindow','SystemManager','显示模板管理','1','2000','1','openTab','datawindow_page.html?pagePath=system.dw_catalog_list.jsp'),
	('DataWindowPage','SecondDevelop','模板页面设置','1','0010','1','openTab','datawindow_page.html?pagePath=system.datawindow_page_list.jsp'),
	('ImageManage','ContentManage','云磁盘','1','0010','0','openTab','jqueryPlugin/elfinder/elfinder.jsp'),
	('LayoutManager','SystemManager','布局管理','1','7000','1','openTab','system/layout_manage.jsp?LayoutID=LayoutManager'),
	('MajorCustomerManage','CustomerManage','重大客户','1','0020','0','openTab',''),
	('NewsOnline','NewsMgr','新闻在线','1','0010','1','openTab','datawindow_page.html?pagePath=customer.news_online_list.page'),
	('OrgManager','SystemManager','机构管理','1','6000','1','openTab','system/org_info_tree.jsp'),
	('PasswordManage','UserManage','密码修改','','0020','1','javascript','DWControl.OpenDwWindow({id:'accountManage',title:'密码修改',page:'user.user_password_edit.jsp',param:'userID=${session.user.userID}',height:'250',width:'400'});'),
	('PersonalEmail','EMailManage','个人邮箱','1','0010','1','openTab','frame/layout.jsp?LayoutID=EmailBox'),
	('ProductManager','SystemManager','产品管理','1','2100','1','openTab','datawindow_page.html?pagePath=system.product_item_list.page'),
	('RiskCustomerManage','CustomerManage','风险客户','1','0030','0','openTab',''),
	('RoleManager','SystemManager','角色管理','1','8000','1','openTab','datawindow_page.html?pagePath=system.role_list.jsp'),
	('ServicePage','SecondDevelop','业务页面设置','1','0030','1','openTab','datawindow_page.html?pagePath=system.datawindow_pagetype_list.jsp&pageType=Service'),
	('ShowDefaultMenu','Customize','默认展示菜单',NULL,'0010','1','openTab',''),
	('SystemPage','SecondDevelop','系统页面设置','1','0020','1','openTab','datawindow_page.html?pagePath=system.datawindow_pagetype_list.jsp&pageType=System'),
	('SystemParamManager','SystemManager','系统参数管理','1','9000','1','openTab','datawindow_page.html?pagePath=system.system_param_list.jsp'),
	('TableObject','SystemManager','表对象管理','1','1000','1','openTab','datawindow_page.html?pagePath=system.table_object_list'),
	('TimerTaskManager','SystemManager','定时任务管理','1','9001','1','openTab','datawindow_page.html?pagePath=system.timer_task_list.page'),
	('UserManager','SystemManager','用户管理','1','5000','1','openTab','datawindow_page.html?pagePath=system.user_info_list.jsp');

/*!40000 ALTER TABLE `app_item` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table attachment_info
# ------------------------------------------------------------

DROP TABLE IF EXISTS `attachment_info`;

CREATE TABLE `attachment_info` (
  `id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '附件ID',
  `objectType` varchar(32) COLLATE utf8_bin DEFAULT NULL,
  `objectNo` varchar(32) COLLATE utf8_bin DEFAULT NULL,
  `FileName` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT '附件名称',
  `realName` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `InputUserID` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '登记人',
  `InputDate` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '登记日期',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;



# Dump of table attendance_info
# ------------------------------------------------------------

DROP TABLE IF EXISTS `attendance_info`;

CREATE TABLE `attendance_info` (
  `id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '',
  `userId` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '用户ID',
  `inputDate` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '考勤登记时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

LOCK TABLES `attendance_info` WRITE;
/*!40000 ALTER TABLE `attendance_info` DISABLE KEYS */;

INSERT INTO `attendance_info` (`id`, `userId`, `inputDate`)
VALUES
	('2014080301','admin','2014-08-03 11:28:58'),
	('2014080302','admin','2014-08-03 11:35:07'),
	('2014080303','admin','2014-08-03 11:37:46'),
	('2014080304','admin','2014-08-03 11:40:32'),
	('2014080305','admin','2014-08-03 11:41:31');

/*!40000 ALTER TABLE `attendance_info` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table code_catalog
# ------------------------------------------------------------

DROP TABLE IF EXISTS `code_catalog`;

CREATE TABLE `code_catalog` (
  `CODENO` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '代码编号',
  `SORTNO` varchar(4) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '排序号',
  `CodeType` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '代码类型',
  `CODENAME` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '代码名称',
  `REMARK` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '说明',
  PRIMARY KEY (`CODENO`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

LOCK TABLES `code_catalog` WRITE;
/*!40000 ALTER TABLE `code_catalog` DISABLE KEYS */;

INSERT INTO `code_catalog` (`CODENO`, `SORTNO`, `CodeType`, `CODENAME`, `REMARK`)
VALUES
	('AppInfoSubject','0090','System','系统应用主题',''),
	('AppItemTriggerMode','0080','System','系统栏目触发方式',''),
	('AuthGroup','0220','System','权限组',''),
	('ButtonGroup','0120','System','按钮组',''),
	('CodeType','0017','System','代码类型',''),
	('CommonRegex','0200','System','常用正则',''),
	('ContactType','0016','Service','联系方式',''),
	('CountryCode','1001','System','国家码',''),
	('Currency','0180','System','币种',''),
	('CustomerRating','0017','Service','客户等级',''),
	('CustomerSource','0190','Service','客户来源',''),
	('CustomerType','0180','Service','客户类型',''),
	('DataType','0040','System','数据类型',''),
	('DatagridEvent','0130','System','数据列表事件',''),
	('DisplayStyle','0110','System','显示模板风格',''),
	('EmailConfig','0260','System','Email配置',''),
	('EventType','0100','System','页面事件类型',''),
	('GoodsAccessStatus','','Service','物流状态',''),
	('HTMLSOURCE','0030','System','显示来源类型',NULL),
	('HtmlTag','0020','System','Html标签',''),
	('JsonArrayCode','0210','System','JSON数组',''),
	('NewsCatalog','0060','Service','新闻类别',''),
	('PageLayout','0050','System','页面布局',''),
	('PageType','0150','System','页面类型',''),
	('Region','0060','System','方位布局',''),
	('RegistrationCode','0240','System','环境注册码',''),
	('RoleRelaType','0070','System','角色关联对象类型',''),
	('Sex','0180','System','性别',''),
	('SystemTable','0140','System','系统表',''),
	('TimerTaskClass ','0230','System','定时任务定义类',''),
	('TreeSQLCode','0250','System','树图查询SQL',''),
	('YesNo','0010','System','是否','');

/*!40000 ALTER TABLE `code_catalog` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table code_library
# ------------------------------------------------------------

DROP TABLE IF EXISTS `code_library`;

CREATE TABLE `code_library` (
  `CODENO` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '代码编号',
  `ITEMNO` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '栏目编号',
  `ITEMNAME` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '栏目名称',
  `SORTNO` varchar(4) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '排序号',
  `ISINUSE` varchar(1) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '是否可用',
  `Attr01` varchar(500) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '是否可用',
  PRIMARY KEY (`CODENO`,`ITEMNO`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

LOCK TABLES `code_library` WRITE;
/*!40000 ALTER TABLE `code_library` DISABLE KEYS */;

INSERT INTO `code_library` (`CODENO`, `ITEMNO`, `ITEMNAME`, `SORTNO`, `ISINUSE`, `Attr01`)
VALUES
	('AppInfoSubject','AttendanceManage','考勤管理','0100','1',''),
	('AppInfoSubject','CustomerManage','客户管理','0010','1',''),
	('AppInfoSubject','DocManage','单证管理','0050','1',''),
	('AppInfoSubject','ExportManage','外销管理','0030','1',''),
	('AppInfoSubject','FinanceManage','财务管理','0060','1',''),
	('AppInfoSubject','NewsCenter','消息中心','0090','1',''),
	('AppInfoSubject','PurchaseManage','采购管理','0040','1',''),
	('AppInfoSubject','SampleManage','样品管理','0070','1',''),
	('AppInfoSubject','StorehouseManage','仓库管理','0020','1',''),
	('AppInfoSubject','SystemManage','系统管理','9999','1',''),
	('AppItemTriggerMode','javascript','js事件','0020','1',''),
	('AppItemTriggerMode','openPage','Open页面','0015','1',''),
	('AppItemTriggerMode','openTab','Tab页面','0010','1',''),
	('AuthGroup','Contact_Book_Delete','联系方式删除','0040','1',''),
	('AuthGroup','Contact_Book_Insert','联系方式新增','0020','1',''),
	('AuthGroup','Contact_Book_Query','联系方式查询','0010','1',''),
	('AuthGroup','Contact_Book_Update','联系方式更新','0030','1',''),
	('AuthGroup','SERVICE_CUSTOMER_INFO_DELETE','客户信息删除','9004','1',NULL),
	('AuthGroup','SERVICE_CUSTOMER_INFO_INSERT','客户信息新增','9002','1',NULL),
	('AuthGroup','SERVICE_CUSTOMER_INFO_QUERY','客户信息查询','9001','1',NULL),
	('AuthGroup','SERVICE_CUSTOMER_INFO_UPDATE','客户信息更新','9003','1',NULL),
	('AuthGroup','SMART_ADMINISTRATOR','超级管理员','9005','1',NULL),
	('AuthGroup','SMART_APP_INFO_DELETE','子系统删除','9007','1',NULL),
	('AuthGroup','SMART_APP_INFO_INSERT','子系统新增','9006','1',NULL),
	('AuthGroup','SMART_APP_INFO_QUERY','子系统查询','9008','1',NULL),
	('AuthGroup','SMART_APP_INFO_UPDATE','子系统修改','9009','1',NULL),
	('AuthGroup','SMART_APP_ITEM_DELETE','子系统栏目删除','9011','1',NULL),
	('AuthGroup','SMART_APP_ITEM_INSERT','子系统栏目新增','9010','1',NULL),
	('AuthGroup','SMART_APP_ITEM_QUERY','子系统栏目查询','9012','1',NULL),
	('AuthGroup','SMART_APP_ITEM_UPDATE','子系统栏目修改','9013','1',NULL),
	('AuthGroup','SMART_CODE_CATALOG_DELETE','代码类别删除','9015','1',NULL),
	('AuthGroup','SMART_CODE_CATALOG_INSERT','代码类别新增','9014','1',NULL),
	('AuthGroup','SMART_CODE_CATALOG_QUERY','代码类别查询','9016','1',NULL),
	('AuthGroup','SMART_CODE_CATALOG_UPDATE','代码类别修改','9017','1',NULL),
	('AuthGroup','SMART_CODE_LIBRARY_DELETE','代码删除','9018','1',NULL),
	('AuthGroup','SMART_CODE_LIBRARY_INSERT','代码新增','9021','1',NULL),
	('AuthGroup','SMART_CODE_LIBRARY_QUERY','代码查询','9019','1',NULL),
	('AuthGroup','SMART_CODE_LIBRARY_UPDATE','代码修改','9020','1',NULL),
	('AuthGroup','SMART_CONTRACT_TEMPLATE_DELETE','合同模板删除','9022','1',NULL),
	('AuthGroup','SMART_CONTRACT_TEMPLATE_INSERT','合同模板新增','9025','1',NULL),
	('AuthGroup','SMART_CONTRACT_TEMPLATE_QUERY','合同模板查询','9023','1',NULL),
	('AuthGroup','SMART_CONTRACT_TEMPLATE_UPDATE','合同模板修改','9024','1',NULL),
	('AuthGroup','SMART_DISABLE','禁用','9070','1',NULL),
	('AuthGroup','SMART_DW_CATALOG_DELETE','模板类目删除','9026','1',NULL),
	('AuthGroup','SMART_DW_CATALOG_INSERT','模板类目新增','9029','1',NULL),
	('AuthGroup','SMART_DW_CATALOG_QUERY','模板类目查询 ','9027','1',NULL),
	('AuthGroup','SMART_DW_CATALOG_UPDATE','模板类目修改','9028','1',NULL),
	('AuthGroup','SMART_DW_EVENT_DELETE','模板事件删除','9030','1',NULL),
	('AuthGroup','SMART_DW_EVENT_INSERT','模板事件新增','9033','1',NULL),
	('AuthGroup','SMART_DW_EVENT_QUERY','模板事件查询 ','9031','1',NULL),
	('AuthGroup','SMART_DW_EVENT_UPDATE','模板事件修改','9032','1',NULL),
	('AuthGroup','SMART_DW_LIBRARY_DELETE','模板字段删除','9034','1',NULL),
	('AuthGroup','SMART_DW_LIBRARY_INSERT','模板字段新增','9037','1',NULL),
	('AuthGroup','SMART_DW_LIBRARY_QUERY','模板字段查询 ','9035','1',NULL),
	('AuthGroup','SMART_DW_LIBRARY_UPDATE','模板字段修改','9036','1',NULL),
	('AuthGroup','SMART_LAYOUT_CATALOG_DELETE','布局类目删除','9038','1',NULL),
	('AuthGroup','SMART_LAYOUT_CATALOG_INSERT','布局类目新增','9041','1',NULL),
	('AuthGroup','SMART_LAYOUT_CATALOG_QUERY','布局类目查询 ','9039','1',NULL),
	('AuthGroup','SMART_LAYOUT_CATALOG_UPDATE','布局类目修改','9040','1',NULL),
	('AuthGroup','SMART_LAYOUT_ITEM_DELETE','布局栏目删除','9042','1',NULL),
	('AuthGroup','SMART_LAYOUT_ITEM_INSERT','布局栏目新增','9045','1',NULL),
	('AuthGroup','SMART_LAYOUT_ITEM_QUERY','布局栏目查询 ','9043','1',NULL),
	('AuthGroup','SMART_LAYOUT_ITEM_UPDATE','布局栏目修改','9044','1',NULL),
	('AuthGroup','SMART_ROLE_INFO_DELETE','角色信息删除','9055','1',NULL),
	('AuthGroup','SMART_ROLE_INFO_INSERT','角色信息新增','9054','1',NULL),
	('AuthGroup','SMART_ROLE_INFO_QUERY','角色信息查询 ','9056','1',NULL),
	('AuthGroup','SMART_ROLE_INFO_UPDATE','角色信息修改','9057','1',NULL),
	('AuthGroup','SMART_ROLE_RELATION_DELETE','关联角色删除','9059','1',NULL),
	('AuthGroup','SMART_ROLE_RELATION_INSERT','关联角色新增','9058','1',NULL),
	('AuthGroup','SMART_ROLE_RELATION_QUERY','关联角色查询 ','9060','1',NULL),
	('AuthGroup','SMART_ROLE_RELATION_UPDATE','关联角色修改','9061','1',NULL),
	('AuthGroup','SMART_SYSTEM_PARAM_DELETE','系统参数删除','9063','1',NULL),
	('AuthGroup','SMART_SYSTEM_PARAM_INSERT','系统参数新增','9062','1',NULL),
	('AuthGroup','SMART_SYSTEM_PARAM_QUERY','系统参数查询 ','9064','1',NULL),
	('AuthGroup','SMART_SYSTEM_PARAM_UPDATE','系统参数修改','9065','1',NULL),
	('AuthGroup','SMART_TABLE_OBJECT_DELETE','表对象删除','9047','1',NULL),
	('AuthGroup','SMART_TABLE_OBJECT_INSERT','表对象新增','9046','1',NULL),
	('AuthGroup','SMART_TABLE_OBJECT_QUERY','表对象查询 ','9048','1',NULL),
	('AuthGroup','SMART_TABLE_OBJECT_UPDATE','表对象修改','9049','1',NULL),
	('AuthGroup','SMART_TIME_TASK_DELETE','定时任务删除','9051','1',NULL),
	('AuthGroup','SMART_TIME_TASK_INSERT','定时任务新增','9050','1',NULL),
	('AuthGroup','SMART_TIME_TASK_QUERY','定时任务查询 ','9052','1',NULL),
	('AuthGroup','SMART_TIME_TASK_UPDATE','定时任务修改','9053','1',NULL),
	('AuthGroup','SMART_USER_INFO_DELETE','用户信息删除','9067','1',NULL),
	('AuthGroup','SMART_USER_INFO_INSERT','用户信息新增','9066','1',NULL),
	('AuthGroup','SMART_USER_INFO_QUERY','用户信息查询 ','9068','1',NULL),
	('AuthGroup','SMART_USER_INFO_UPDATE','用户信息修改','9069','1',NULL),
	('ButtonGroup','addEvent','添加事件','0130','1',''),
	('ButtonGroup','attachMgr','附件管理','0210','1',''),
	('ButtonGroup','createDataWindow','自动生成显示模板','0080','1',''),
	('ButtonGroup','doAdd','新增','0030','1',''),
	('ButtonGroup','doClose','关闭','0060','1',''),
	('ButtonGroup','doCopy','复制','0100','1',''),
	('ButtonGroup','doDelete','删除','0040','1',''),
	('ButtonGroup','doEdit','编辑','0050','1',''),
	('ButtonGroup','doPreview','预览','0070','1',''),
	('ButtonGroup','doReturn','返回','0020','1',''),
	('ButtonGroup','doSave','保存','0010','1',''),
	('ButtonGroup','doToggle','切换','0230','1',''),
	('ButtonGroup','doView','查看','0190','1',''),
	('ButtonGroup','editAppItem','维护系统栏目','0140','1',''),
	('ButtonGroup','editCodeItem','代码列表详情','0090','1',''),
	('ButtonGroup','editDwLib','模板详情','0110','1',''),
	('ButtonGroup','editLayoutItem','布局列表详情','0170','1',''),
	('ButtonGroup','editStation','站点维护','0160','1',''),
	('ButtonGroup','exportExcel','导出Excel','0200','1',''),
	('ButtonGroup','publish','发布','0220','1',''),
	('ButtonGroup','refreshAllTable','全量刷新表字段','0180','1',''),
	('ButtonGroup','renameDW','重命名显示模板','0120','1',''),
	('ButtonGroup','roleManager','角色管理','0150','1',''),
	('CodeType','Service','业务代码','0020','1',''),
	('CodeType','System','系统级别','0010','1',''),
	('CommonRegex','email','E-Mail','0010','1','\w+([-+.]\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*'),
	('ContactType','LINE','LINE','0030','1',''),
	('ContactType','MSN','MSN','0010','1',''),
	('ContactType','Skype','Skype','0020','1',''),
	('ContactType','other','其他','0040','1',''),
	('CountryCode','China','中国','0010','1',''),
	('Currency','RMB','人民币','0010','1',''),
	('Currency','dollor','美元','0020','1',''),
	('CustomerRating','0010','潜在单程','0010','1',''),
	('CustomerRating','0020','潜在往返','0020','1',''),
	('CustomerRating','0030','一星级客户','0030','1',''),
	('CustomerRating','0040','二星级客户','0040','1',''),
	('CustomerRating','0050','三星级客户','0050','1',''),
	('CustomerRating','0060','四星级客户','0060','1',''),
	('CustomerRating','0070','五星级客户','0070','1',''),
	('CustomerSource','albb','阿里巴巴网站','0040','1',''),
	('CustomerSource','gjh','广交会','0010','1',''),
	('CustomerSource','hjg','华交会','0020','1',''),
	('CustomerSource','sctg','市场推广','0030','1',''),
	('CustomerType','jxs','经销商','0010','1',''),
	('CustomerType','lxs','零售商','0030','1',''),
	('CustomerType','mdls','门店连锁','0050','1',''),
	('CustomerType','pfss','批发商','0020','1',''),
	('CustomerType','wmgs','外贸公司','9949','1',''),
	('DataType','-1','LONGVARCHAR','0010','1',''),
	('DataType','12','VARCHAR','0020','1',''),
	('DatagridEvent','onClickRow','单击行','0010','1',''),
	('DatagridEvent','onDblClickRow','双击行','0020','1',''),
	('DisplayStyle','Info','Info','0020','1',''),
	('DisplayStyle','List','List','0010','1',''),
	('EmailConfig','163','163邮箱','0010','1','{imap:{host:'imap.163.com',port:'143',ssl:'993'},smtp:{host:'smtp.163.com',port:'25',ssl:'994'},pop3:{host:'pop.163.com',port:'110',ssl:'995'},}'),
	('EmailConfig','qq','QQ邮箱','0020','1','{imap:{host:'imap.qq.com',port:'143',ssl:'993'},smtp:{host:'smtp.qq.com',port:'25',ssl:'465'},pop3:{host:'pop.qq.com',port:'110',ssl:'995'},}'),
	('EventType','onblur','onblur','0050','1',''),
	('EventType','onchange','onchange','0020','1',''),
	('EventType','onclick','onclick','0010','1',''),
	('EventType','onfocus','onfocus','0040','1',''),
	('EventType','onkeypress','onkeypress','0030','1',''),
	('EventType','onmouseover','onmouseover','0060','1',''),
	('GoodsAccessStatus','InDepot','入库','0010','1',''),
	('GoodsAccessStatus','OutDepot','出库','0020','1',''),
	('HTMLSOURCE','Code','代码表','0010','1',''),
	('HTMLSOURCE','Java','Java类','0020','1',''),
	('HTMLSOURCE','JsonArray','JSON数组','0030','1',''),
	('HtmlTag','image','图片','0090','1',''),
	('HtmlTag','input[checkbox]','复选框','0070','1',''),
	('HtmlTag','input[date]','日期选择器','0100','1',''),
	('HtmlTag','input[datetime]','日期时间选择器','0120','1',''),
	('HtmlTag','input[password]','密码输入框','0050','1',''),
	('HtmlTag','input[radio]','单选框','0040','1',NULL),
	('HtmlTag','input[text]','单行文本框','0030','1',NULL),
	('HtmlTag','input[time]','时间选择器','0110','1',''),
	('HtmlTag','richTextArea','富文本框','0080','1',''),
	('HtmlTag','select','下拉单选框','0010','1',NULL),
	('HtmlTag','span','文本','0020','1',NULL),
	('HtmlTag','textarea','多行文本框','0060','1',''),
	('JsonArrayCode','PeriodJsonArray','执行频率单位','0020','1','[{code:'MILLISECONDS',title:'毫秒'},{code:'SECONDS',title:'秒'},{code:'MINUTES',title:'分钟'},{code:'HOURS',title:'小时'},{code:'DAYS',title:'天'}]'),
	('JsonArrayCode','TimerSelectJsonArray','定时类型选择','0010','1','[{code:'no',title:'无'},{code:'1',title:'1分钟'}]'),
	('NewsCatalog','Recommend','推荐','0010','1',''),
	('PageLayout','Accordion','Accordion布局','0020','1','frame/accordion.jsp'),
	('PageLayout','Frame','Frame布局','0010','1','frame/frame.jsp'),
	('PageLayout','Tabs','Tabs布局','0040','1',''),
	('PageLayout','Tree','Tree布局','0030','1','frame/treeFrame.jsp'),
	('PageType','Service','业务级别','0020','1',''),
	('PageType','System','系统级别','0010','1',''),
	('Region','center','中','0050','1',''),
	('Region','east','东','0010','1',''),
	('Region','north','北','0040','1',''),
	('Region','south','南','0020','1',''),
	('Region','west','西','0030','1',''),
	('RegistrationCode','7F-00-00-01','7F-00-00-01 License','0000','1','{"expire":"2018-09-19","user":"zjw","token":"ce6d544c14a4a3a12e2e69df456da65e"}'),
	('RegistrationCode','D4-BE-D9-93-9D-83','D4-BE-D9-93-9D-83 License','0000','1','{"expire":"2015-09-19","token":"87bb5f1af844b0e5ad8a80896a2851c0","user":"zjw"}'),
	('RoleRelaType','AppInfo','系统应用','0010','1',''),
	('Sex','Female','女','0020','1',''),
	('Sex','Male','男','0010','1',''),
	('SystemTable','APP_INFO','应用信息表','0010','1',''),
	('SystemTable','APP_ITEM','应用栏目表','0020','1',''),
	('SystemTable','CODE_CATALOG','代码科目表','0030','1',''),
	('SystemTable','CODE_LIBRARY','代码配置详情表','0040','1',''),
	('SystemTable','DATAOBJECT_CATALOG','显示模板科目表','0050','1',''),
	('SystemTable','DATAOBJECT_EVENT','显示模板事件定义表','0060','1',''),
	('SystemTable','DATAOBJECT_LIBRARY','显示模板配置详情表','0070','1',''),
	('SystemTable','DATAWINDOW_PAGE','显示模板页面定义表','0080','1',''),
	('TimerTaskClass','com.cms.task.IcbcGoldMiningTask','工行黄金采集','0020','1',''),
	('TimerTaskClass','net.vinote.smart.platform.service.timer.CacheRefreshTask','缓存定时刷新','0010','1',''),
	('TimerTaskClass','net.vinote.smart.platform.service.timer.LicenseCheckTask','License检测任务','0030','1',''),
	('TimerTaskClass','net.vinote.smart.platform.timer.SystemMonitorTask','系统资源监控','9998','1',''),
	('TimerTaskClass','net.vinote.smart.platform.timer.SystemTaskMonitorTask','系统定时任务监控','9999','1',''),
	('TreeSQLCode','LayoutCatalog','暂时无用','0040','0','{"id":"","sort":"layoutid","sql":"select * from layout_catalog where layoutstyle=? order by layoutid","attrs":"layoutid","show":"layoutname"}'),
	('TreeSQLCode','OrgInfoTree','机构信息','0020','1','{"id":"","sort":"sortno","sql":"select * from org_info order by sortno","attrs":"sortno","show":"orgname"}'),
	('TreeSQLCode','ProductSelect','产品选择','0030','1','{"id":"","sort":"sortNO","sql":"select * from product_item order by sortno","attrs":"productNo,productName,sortno","show":"productName"}'),
	('TreeSQLCode','RoleInfoSelect','角色信息选择','0010','1','{"id":"roleid","sort":"roleid","sql":"select * from role_info order by roleid","attrs":"roleid,istrunk","show":"rolename"}'),
	('YesNo','0','否','0020','1',NULL),
	('YesNo','1','是','0010','1',NULL);

/*!40000 ALTER TABLE `code_library` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table contact_book
# ------------------------------------------------------------

DROP TABLE IF EXISTS `contact_book`;

CREATE TABLE `contact_book` (
  `SerialNo` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '序列号',
  `RELATIVECUSTOMERID` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '关联客户编号',
  `CUSTOMERNAME` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '联系人姓名',
  `SEX` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '性别',
  `Department` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '部门',
  `Post` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '职务',
  `email` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT 'Email',
  `ADDRESS` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '联系地址',
  `PHONENUMBER` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '座机号码',
  `CELLPHONE` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '手机号码',
  `FAXNUMBER` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '传真号码',
  `ContactType` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '联系方式',
  `ContactNo` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '联系账号',
  PRIMARY KEY (`SerialNo`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

LOCK TABLES `contact_book` WRITE;
/*!40000 ALTER TABLE `contact_book` DISABLE KEYS */;

INSERT INTO `contact_book` (`SerialNo`, `RELATIVECUSTOMERID`, `CUSTOMERNAME`, `SEX`, `Department`, `Post`, `email`, `ADDRESS`, `PHONENUMBER`, `CELLPHONE`, `FAXNUMBER`, `ContactType`, `ContactNo`)
VALUES
	('20131112002','20131112001','11',NULL,'','','s@zz.com','1','1','','','','');

/*!40000 ALTER TABLE `contact_book` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table contract_info
# ------------------------------------------------------------

DROP TABLE IF EXISTS `contract_info`;

CREATE TABLE `contract_info` (
  `id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '合同编号',
  `templateid` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '合同模板编号',
  `content` text COLLATE utf8_bin COMMENT '合同内容',
  `objectid` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '关联对象ID',
  `objecttype` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT '关联对象类型',
  `inputuserid` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '创建者',
  `inputdate` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '创建时间',
  `updateuserid` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '修改者',
  `updatedate` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

LOCK TABLES `contract_info` WRITE;
/*!40000 ALTER TABLE `contract_info` DISABLE KEYS */;

INSERT INTO `contract_info` (`id`, `templateid`, `content`, `objectid`, `objecttype`, `inputuserid`, `inputdate`, `updateuserid`, `updatedate`)
VALUES
	('2015021204','2015020802','{"text_20":"","text_21":"","text_22":"","text_23":"","text_24":"","text_25":"","text_26":"","text_27":"","text_28":"","text_29":"","tenantryid":"asdf","text_33":"","text_34":"","text_31":"","text_32":"","text_37":"","text_38":"","lessor":"asd","text_35":"","text_36":"","text_39":"","text_30":"","text_46":"","text_47":"","lessorid":"sadf","text_48":"","text_49":"","text_42":"","text_43":"","text_44":"","text_45":"","text_1":"fa","tenantry":"asf","text_41":"","text_40":"","text_19":"","text_53":"","text_18":"","text_17":"","text_16":"","text_15":"","text_14":"","text_13":"s","text_12":"a","text_11":"s","text_10":"s","text_7":"d","text_6":"","text_9":"a","text_8":"f","text_3":"sf","text_2":"af","text_5":"sf","text_4":"sf","text_52":"","text_51":"","text_50":""}','2015020901','CustomerInfo','admin','2015-02-12 16:37:37','admin','2015-02-12 20:08:15');

/*!40000 ALTER TABLE `contract_info` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table contract_template
# ------------------------------------------------------------

DROP TABLE IF EXISTS `contract_template`;

CREATE TABLE `contract_template` (
  `id` varchar(32) COLLATE utf8_bin NOT NULL COMMENT '合同模板编号',
  `title` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '合同标题',
  `content` text COLLATE utf8_bin COMMENT '合同模板内容',
  `inputuserid` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '创建者',
  `inputdate` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '创建时间',
  `updateuserid` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '修改者',
  `updatedate` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

LOCK TABLES `contract_template` WRITE;
/*!40000 ALTER TABLE `contract_template` DISABLE KEYS */;

INSERT INTO `contract_template` (`id`, `title`, `content`, `inputuserid`, `inputdate`, `updateuserid`, `updatedate`)
VALUES
	('2015020802','租房合同','<p style="text-align:center"><span style="font-size:22px"><strong>租 房 合 同</strong></span></p> 
<p>　　出租方：<input maxlength="10" name="lessor" type="text">(以下简称甲方)</p> 
<p>　　身份证：<input maxlength="18" name="lessorid" type="text"></p> 
<p>　　承租方：<input maxlength="10" name="tenantry" type="text">(以下简称乙方)</p> 
<p>　　身份证：<input maxlength="18" name="tenantryid" type="text"></p> 
<p>　　根据甲、乙双方在自愿、平等、互利的基础上，经协商一致，为明确双方之间的权利义务关系，就甲方将其合法拥有的房屋出租给乙方使用，乙方承租甲方房屋事宜，订立本合同。</p> 
<p>　　<strong>一、房屋地址：</strong>塘南新村北区120幢401室内的一间单间。用于普通住房。</p> 
<p>　<strong>　二、租赁期限及约定</strong></p> 
<p>　　1、该房屋租赁期共一年。自<input maxlength="4" name="text_1" size="4" type="text">年<input maxlength="2" name="text_1" size="2" type="text">月<input maxlength="2" name="text_2" size="2" type="text">日起至<input maxlength="4" name="text_3" size="4" type="text">年<input maxlength="2" name="text_4" size="2" type="text">月<input maxlength="2" name="text_5" size="2" type="text">日止。</p> 
<p>　　2、房屋租金：每月<input maxlength="5" name="text_6" size="5" type="text">元。按月付款，每月提前五天付款。另付押金<input maxlength="5" name="text_7" size="5" type="text">元，共计<input maxlength="5" name="text_8" size="5" type="text">元.</p> 
<p>　　(大写：<input maxlength="1" name="text_9" size="1" type="text">万<input maxlength="1" name="text_10" size="1" type="text">仟<input maxlength="1" name="text_11" size="1" type="text">佰<input maxlength="1" name="text_12" size="1" type="text">拾<input maxlength="1" name="text_13" size="1" type="text">元整)</p> 
<p>　　房屋终止，甲方验收无误后，将押金退还乙方，不计利息。</p> 
<p>　　3、乙方向甲方承诺，租赁该房屋仅作为普通住房使用。</p> 
<p>　　4、租赁期满，甲方有权收回出租房屋，乙方应如期交还。乙方如要求续租，则必须在租赁期满前一个月内通知甲方，经甲方同意后，重新签订租赁合同。</p> 
<p><strong>　　三、房屋修缮与使用</strong></p> 
<p>　　1、在租赁期内，甲方应保证出租房屋的使用安全。乙方应合理使用其所承租的房屋及其附属设施。如乙方因使用不当造成房屋及设施损坏的，乙方应负责修复或给予经济赔偿。</p> 
<p>　　2、该房屋及所属设施的维修责任除双方在本合同及补充条款中约定外，均由甲方负责(但乙方使用不当除外)。甲方进行维修须提前七天通知乙方，乙方应积极协助配合。</p> 
<p>　　3、乙方因使用需要，在不影响房屋结构的前提下，可以对房屋进行装修装饰，但其设计规模、范围、工艺、用料等方案应事先征得甲方的同意后方可施工。租赁期满后，依附于房屋的装修归甲方所有。对乙方的装修装饰部分甲方不负有修缮的义务。</p> 
<p><strong>　　四、房屋的转让与转租</strong></p> 
<p>　　1、租赁期间，未经甲方书面同意，乙方不得擅自转租、转借承租房屋。</p> 
<p>　　2、甲方同意乙方转租房屋的，应当单独订立补充协议，乙方应当依据与甲方的书面协议转租房屋。</p> 
<p><strong>　　五、乙方违约的处理规定</strong></p> 
<p>　　在租赁期内，乙方有下列行为之一的，甲方有权终止合同，收回该房屋，乙方应向甲方支付合同总租金20%的违约金，若支付的违约金不足弥补甲方损失的，乙方还应负责赔偿直至达到弥补全部损失为止。</p> 
<p>　　(1) 未经甲方书面同意，擅自将房屋转租、转借给他人使用的;</p> 
<p>　　(2) 未经甲方同意，擅自拆改变动房屋结构或损坏房屋，且经甲方通知，在规定期限内仍未纠正并修复的;</p> 
<p>　　(3) 擅自改变本合同规定的租赁用途或利用该房屋进行违法活动的;</p> 
<p>　　(4) 拖欠房租累计一个月以上的。</p> 
<p><strong>　　六</strong>、本协议一式两份，甲.乙各执一份，签字后即行生效。</p> 
<p>　<strong>　七</strong>、其他说明：水电数字由甲乙双方与其他承租方平均分配</p> 
<p>　　(入住时的水电数字：电<input maxlength="4" name="text_14" size="4" type="text">，水<input maxlength="4" name="text_15" size="4" type="text">，)</p> 
<p>　　甲方签字：　　　　　　乙方签字：</p> 
<p>　　联系方式：　　　　　　联系方式：</p> 
<p><strong>　　简单个人<a href="http://yjbys.com/hetongfanben/fangwu/" style="color: rgb(0, 0, 204);" target="_blank"><u>租房合同范本</u></a></strong></p> 
<p>　　出租方：(以下简称甲方)<input maxlength="6" name="text_16" size="6" type="text"></p> 
<p>　　承租方：(以下简称乙方)<input maxlength="6" name="text_17" size="6" type="text"></p> 
<p>　　甲、乙双方就房屋租赁事宜，达成如下协议：</p> 
<p>　　一、甲方将位于<input maxlength="5" name="text_18" size="5" type="text">市<input maxlength="10" name="text_19" size="10" type="text">街道<input maxlength="10" name="text_20" size="10" type="text">小区<input maxlength="10" name="text_21" size="10" type="text">号楼<input maxlength="5" name="text_22" size="5" type="text">号的房屋出租给乙方居住使用，租赁期限自<input maxlength="4" name="text_23" size="4" type="text">年<input maxlength="2" name="text_24" size="2" type="text">月<input maxlength="2" name="text_25" size="2" type="text">日至<input maxlength="4" name="text_26" size="4" type="text">年<input maxlength="2" name="text_27" size="2" type="text">月<input maxlength="2" name="text_28" size="2" type="text">日，计<input maxlength="3" name="text_29" size="3" type="text">个月。</p> 
<p>　　二、本房屋月租金为人民币<input maxlength="4" name="text_30" size="4" type="text">元，按月/季度/年结算。每月<input maxlength="3" name="text_31" size="3" type="text">月初/每季<input maxlength="3" name="text_32" size="3" type="text">季初/每年<input maxlength="3" name="text_33" size="3" type="text">年初<input maxlength="3" name="text_34" size="3" type="text">日内，乙方向甲方支付<input maxlength="4" name="text_35" size="4" type="text">全月/季/年租金。</p> 
<p>　　三、乙方租赁期间，水费、电费、取暖费、燃气费、电话费、物业费以及其它由乙方居住而产生的费用由乙方负担。租赁结束时，乙方须交清欠费。</p> 
<p>　　四、乙方同意预交元作为保证金，合同终止时，当作房租冲抵。</p> 
<p>　　五、房屋租赁期为，从<input maxlength="4" name="text_36" size="4" type="text">年<input maxlength="2" name="text_37" size="2" type="text">月<input maxlength="2" name="text_38" size="2" type="text">日至<input maxlength="4" name="text_39" size="4" type="text">年<input maxlength="2" name="text_40" size="2" type="text">月<input maxlength="2" name="text_41" size="2" type="text">日。在此期间，任何一方要求终止合同，须提前三个月通知对方，并偿付对方总租金<input maxlength="4" name="text_42" size="4" type="text">的违约金;如果甲方转让该房屋，乙方有优先购买权。</p> 
<p>　　六、因租用该房屋所发生的除土地费、大修费以外的其它费用，由乙方承担。</p> 
<p>　　七、在承租期间，未经甲方同意，乙方无权转租或转借该房屋;不得改变房屋结构及其用途，由于乙方人为原因造成该房屋及其配套设施损坏的，由乙方承担赔偿责任。</p> 
<p>　　八、甲方保证该房屋无产权纠纷;乙方因经营需要，要求甲方提供房屋产权证明或其它有关证明材料的，甲方应予以协助。</p> 
<p>　　九、就本合同发生纠纷，双方协商解决，协商不成，任何一方均有权向天津开发区人民法院提起诉讼，请求司法解决。</p> 
<p>　　十、本合同连一式<input maxlength="2" name="text_43" size="2" type="text">份，甲、乙双方各执<input maxlength="2" name="text_44" size="2" type="text">份，自双方签字之日起生效。</p> 
<p>　　甲方：<input name="text_45" type="text">　　电话：<input name="text_46" type="text"></p> 
<p>　　身份证：<input name="text_47" type="text"></p> 
<p>　　乙方：<input name="text_48" type="text">　　电话：<input name="text_49" type="text"></p> 
<p>　　身份证：<input name="text_50" type="text"></p> 
<p>　　<input maxlength="4" name="text_51" size="4" type="text">年<input maxlength="2" name="text_52" size="2" type="text">月<input maxlength="2" name="text_53" size="2" type="text">日</p>','admin','2015-02-08 00:30:19','admin','2015-03-06 20:02:21'),
	('2015021001','义乌鼎创实业有限公司购货合同','<p style="text-align:center"><span style="font-size:18px"><strong>义乌鼎创实业有限公司</strong></span></p> 
<table border="0" cellpadding="1" cellspacing="1" style="line-height:20.7999992370605px; width:649px"> 
 <tbody> 
  <tr> 
   <td style="border-color:rgb(255, 255, 255); height:1px; width:1px">地址：<input maxlength="18" name="text_1" size="18" type="text"></td> 
   <td style="border-color:rgb(255, 255, 255); height:1px; width:1px">邮政编码<input maxlength="10" name="text_2" size="10" type="text"></td> 
   <td style="border-color:rgb(255, 255, 255); height:1px; width:1px">传真<input maxlength="10" name="text_3" size="10" type="text"></td> 
  </tr> 
 </tbody> 
</table> 
<hr> 
<p style="text-align:center"><span style="font-size:18px"><strong>购 &nbsp;货 &nbsp;合 &nbsp;同</strong></span></p> 
<table border="0" cellpadding="1" cellspacing="1" style="width:649px"> 
 <tbody> 
  <tr> 
   <td style="border-color:rgb(255, 255, 255)">供方名称：<input maxlength="10" name="text_4" size="10" type="text">&nbsp;</td> 
   <td style="border-color:rgb(255, 255, 255)">合同负责：<input maxlength="10" name="text_5" size="10" type="text"></td> 
   <td style="border-color:rgb(255, 255, 255)">合同编号：<input maxlength="10" name="text_6" size="10" type="text"></td> 
  </tr> 
  <tr> 
   <td style="border-color:rgb(255, 255, 255)">供方地址：<input maxlength="10" name="text_7" size="10" type="text">&nbsp;</td> 
   <td style="border-color:rgb(255, 255, 255)">电话：<input maxlength="10" name="text_8" size="10" type="text"></td> 
   <td style="border-color:rgb(255, 255, 255)">签订日期：<input maxlength="10" name="text_9" size="10" type="text"></td> 
  </tr> 
  <tr> 
   <td style="border-color:rgb(255, 255, 255)">电话/手机：<input maxlength="10" name="text_10" size="10" type="text"></td> 
   <td style="border-color:rgb(255, 255, 255)">手机：<input maxlength="10" name="text_11" size="10" type="text"></td> 
   <td style="border-color:rgb(255, 255, 255)">&nbsp;</td> 
  </tr> 
 </tbody> 
</table> 
<p>根据《中华人民共和国合同法》的相关规定，经供需双方充分协商一致，达成合同如下：</p> 
<p><strong>一、买卖标的：</strong></p> 
<table border="0" cellpadding="0" cellspacing="0" class="dwInfo" style="width:600px"> 
 <tbody> 
  <tr> 
   <td rowspan="2" style="height:58px; width:56px">客人正唛</td> 
   <td rowspan="2" style="width:56px">我司货号</td> 
   <td rowspan="2" style="width:56px">图片</td> 
   <td rowspan="2" style="width:56px">品名及规格</td> 
   <td colspan="4" style="width:224px">装箱数量要求</td> 
   <td colspan="2" rowspan="2" style="width:112px">数量</td> 
   <td rowspan="2" style="width:56px">单价</td> 
   <td rowspan="2" style="width:56px">总价</td> 
  </tr> 
  <tr> 
   <td colspan="2" style="height:33px">每箱装</td> 
   <td colspan="2">箱数</td> 
  </tr> 
  <tr> 
   <td rowspan="6" style="height:197px">唛头等通知</td> 
   <td>143047</td> 
   <td rowspan="2">　</td> 
   <td>黑色文件架35*27.8*29</td> 
   <td>12</td> 
   <td>pcs</td> 
   <td>40</td> 
   <td>ctn</td> 
   <td>480</td> 
   <td>pcs</td> 
   <td>¥15.00</td> 
   <td>7200</td> 
  </tr> 
  <tr> 
   <td style="height:33px">143047</td> 
   <td>银色文件架35*27.8*29</td> 
   <td>12</td> 
   <td>pcs</td> 
   <td>13</td> 
   <td>ctn</td> 
   <td>156</td> 
   <td>pcs</td> 
   <td>¥15.00</td> 
   <td>2340</td> 
  </tr> 
  <tr> 
   <td style="height:33px">143052</td> 
   <td rowspan="2">　</td> 
   <td>黑色便签盒9.5*9.5*8</td> 
   <td>72</td> 
   <td>pcs</td> 
   <td>4</td> 
   <td>ctn</td> 
   <td>288</td> 
   <td>pcs</td> 
   <td>¥2.30</td> 
   <td>662</td> 
  </tr> 
  <tr> 
   <td style="height:33px">143052</td> 
   <td>银色便签盒9.5*9.5*8</td> 
   <td>72</td> 
   <td>pcs</td> 
   <td>2</td> 
   <td>ctn</td> 
   <td>144</td> 
   <td>pcs</td> 
   <td>¥2.30</td> 
   <td>331</td> 
  </tr> 
  <tr> 
   <td style="height:33px">143064</td> 
   <td rowspan="2">　</td> 
   <td>黑色名片盒12*8*6</td> 
   <td>144</td> 
   <td>pcs</td> 
   <td>3</td> 
   <td>ctn</td> 
   <td>432</td> 
   <td>pcs</td> 
   <td>¥1.55</td> 
   <td>670</td> 
  </tr> 
  <tr> 
   <td style="height:32px">143064</td> 
   <td>银色名片盒12*8*6</td> 
   <td>144</td> 
   <td>pcs</td> 
   <td>2</td> 
   <td>ctn</td> 
   <td>288</td> 
   <td>pcs</td> 
   <td>¥1.55</td> 
   <td>446</td> 
  </tr> 
  <tr> 
   <td style="height:33px">　</td> 
   <td>143037</td> 
   <td rowspan="2">　</td> 
   <td>黑色垃圾桶 24*29.5*34.5</td> 
   <td>20</td> 
   <td>pcs</td> 
   <td>23</td> 
   <td>ctn</td> 
   <td>460</td> 
   <td>pcs</td> 
   <td>¥6.50</td> 
   <td>2990</td> 
  </tr> 
  <tr> 
   <td style="height:33px">　</td> 
   <td>143037</td> 
   <td>银色垃圾桶24*29.5*34.5</td> 
   <td>20</td> 
   <td>pcs</td> 
   <td>8</td> 
   <td>ctn</td> 
   <td>160</td> 
   <td>pcs</td> 
   <td>¥6.50</td> 
   <td>1040</td> 
  </tr> 
  <tr> 
   <td style="height:33px">　</td> 
   <td>143050</td> 
   <td rowspan="2">　</td> 
   <td>黑色笔筒 9*9.8</td> 
   <td>96</td> 
   <td>pcs</td> 
   <td>12</td> 
   <td>ctn</td> 
   <td>1152</td> 
   <td>pcs</td> 
   <td>¥1.30</td> 
   <td>1498</td> 
  </tr> 
  <tr> 
   <td style="height:33px">　</td> 
   <td>143050</td> 
   <td>银色笔筒 9*9.8</td> 
   <td>96</td> 
   <td>pcs</td> 
   <td>4</td> 
   <td>ctn</td> 
   <td>384</td> 
   <td>pcs</td> 
   <td>¥1.30</td> 
   <td>499</td> 
  </tr> 
  <tr> 
   <td style="height:33px">　</td> 
   <td>143071</td> 
   <td rowspan="2">　</td> 
   <td>黑色组合文具20*10*10</td> 
   <td>48</td> 
   <td>pcs</td> 
   <td>12</td> 
   <td>ctn</td> 
   <td>576</td> 
   <td>pcs</td> 
   <td>¥4.20</td> 
   <td>2419</td> 
  </tr> 
  <tr> 
   <td style="height:32px">　</td> 
   <td>143071</td> 
   <td>银色组合文具20*10*10</td> 
   <td>48</td> 
   <td>pcs</td> 
   <td>4</td> 
   <td>ctn</td> 
   <td>192</td> 
   <td>pcs</td> 
   <td>¥4.20</td> 
   <td>806</td> 
  </tr> 
  <tr> 
   <td colspan="11" style="height:54px; width:616px">每款包装都是1pc/塑料袋+1个彩色标签卡+1个条码，做大货前都必须先确认产前样</td> 
   <td style="width:56px">　</td> 
  </tr> 
  <tr> 
   <td style="height:20px">金额合计（大写）：</td> 
   <td>　</td> 
   <td>　</td> 
   <td colspan="7">贰万零玖佰零贰元零角零分</td> 
   <td>整</td> 
   <td>#######</td> 
  </tr> 
 </tbody> 
</table> 
<div style="page-break-after: always">
 <span style="display:none">&nbsp;</span>
</div> 
<p><strong>二、质量要求：</strong><br> ①供方提供的货物质量必须符合双方确认的样品的质量要求。<br> ②确认的样品如由供方提供的，则供方应在本合同签订之日起五日内提供给需方封存。</p> 
<p><strong>三、质量异议：</strong></p> 
<p>需方对供方所交货物质量、数量有异议的，有权在收货后<input maxlength="2" name="text_12" size="2" type="text">日内向供方提出，供方对质量、数量不符合要求的货物承担相应的责任。</p> 
<p><strong>四、交货：</strong><br> 供方在样品确定后开始组织生产，供方应于<input maxlength="4" name="text_13" size="4" type="text">年<input maxlength="2" name="text_14" size="2" type="text">月<input maxlength="2" name="text_15" size="2" type="text">日前交货物送至需方指定地点。</p> 
<p><strong>五、包装要求：</strong></p> 
<p>①出口标准双瓦楞纸箱,唛头见附件(易碎产品请两面正唛加红色易碎标志)；<br> ②所有产品包装上不能有中文字及侵权图案(我司有特殊要求除外)；<br> ③供方不得私自更改外包装，由此导致需方损失的，需方有权要求供方赔偿损失；<br> ④供方私自更改包装数量且出货前未通知我司,由此造成的供方损失,我司不予承担。</p> 
<p><strong>六、货款支付：</strong><br> 凭入库单及购货合同原件，货到验完货确认货物合格无问题后<input maxlength="2" name="text_16" size="2" type="text">天 付余款。</p> 
<p><strong>七、违约责任</strong>：<br> ①供方未能按约定日期保质、保量提供货物的，需方有权单方面解除本合同，同时可要求供方赔偿损失并支付合同总金额30%的违约金；<br> ②供方不能将由需方提供或指定的专用包装产品(如卡头、彩盒等)在各类交易会展出或作为样品分发给其他出口商：否则，需方有权要求需方赔偿损失并支付违约金 &nbsp;10000 &nbsp;元；<br> ③需方未能按约及时支付货款的，供方有权要求需方赔偿损失并支付违约金 &nbsp;10000 &nbsp;元。</p> 
<p><strong>八、争议的解决：</strong><br> 本合同履行过程中如有争议，双方协商解决，协商不成，一方可向需方所在地人民法院起诉。</p> 
<p><strong>九、生效条件：</strong><br> 本协议经双方签字或盖章后生效；本协议一式二份，由双方各执一份。</p> 
<table border="0" cellpadding="1" cellspacing="1" style="width:649px"> 
 <tbody> 
  <tr> 
   <td><strong>供 &nbsp;方</strong></td> 
   <td><strong>需 &nbsp;方</strong></td> 
  </tr> 
  <tr> 
   <td>单位（盖章）</td> 
   <td>单位<strong>（盖章）</strong></td> 
  </tr> 
  <tr> 
   <td>法定代表人<strong>（签名）<input maxlength="10" name="text_17" size="10" type="text"></strong></td> 
   <td>法定代表人<strong>（签名）<input maxlength="10" name="text_18" size="10" type="text"></strong></td> 
  </tr> 
  <tr> 
   <td>委托代理人<strong>（签名）<input maxlength="10" name="text_19" size="10" type="text"></strong></td> 
   <td>委托代理人<strong>（签名）<input maxlength="10" name="text_20" size="10" type="text"></strong></td> 
  </tr> 
 </tbody> 
</table> 
<p><span style="font-size:16px"><strong>注：送货前一周必须告知业务员包装尺寸资料及准备每款2PC出货样。</strong></span></p> 
<p>◆仓库地址：义乌港A区1楼38-41<br> &nbsp; 联系电话：15058679895<br> ◆仓库工作时间：上午：8：30-12：00（周末不休息）◆</p>','admin','2015-02-10 15:09:04','admin','2015-02-10 17:25:26');

/*!40000 ALTER TABLE `contract_template` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table customer_info
# ------------------------------------------------------------

DROP TABLE IF EXISTS `customer_info`;

CREATE TABLE `customer_info` (
  `CUSTOMERID` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '客户编号',
  `CUSTOMERNAME` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '客户编号',
  `CUSTOMERPOST` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '客户职务',
  `CUSTOMERTYPE` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '客户类型',
  `COUNTRY` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '国家',
  `PROVINCE` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '省份',
  `CITY` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '城市',
  `ADDRESS` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '详细地址',
  `ZIPCODE` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '邮编',
  `PHONE` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '号码',
  `FAX` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '传真',
  `CustomerRating` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '用户等级',
  `MainProducts` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '主营产品',
  `CustomerSource` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '客户来源',
  `BusinessType` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '业务类型',
  `HOMEPAGE` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT '主页',
  `PriceArticle` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '价格条款',
  `SettleWay` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '结汇方式',
  `PayTime` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '付款期限',
  `Picture` varchar(150) COLLATE utf8_bin DEFAULT NULL COMMENT '客户照片',
  `INPUTUSERID` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '录入人员',
  `INPUTDATE` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '录入日期',
  PRIMARY KEY (`CUSTOMERID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

LOCK TABLES `customer_info` WRITE;
/*!40000 ALTER TABLE `customer_info` DISABLE KEYS */;

INSERT INTO `customer_info` (`CUSTOMERID`, `CUSTOMERNAME`, `CUSTOMERPOST`, `CUSTOMERTYPE`, `COUNTRY`, `PROVINCE`, `CITY`, `ADDRESS`, `ZIPCODE`, `PHONE`, `FAX`, `CustomerRating`, `MainProducts`, `CustomerSource`, `BusinessType`, `HOMEPAGE`, `PriceArticle`, `SettleWay`, `PayTime`, `Picture`, `INPUTUSERID`, `INPUTDATE`)
VALUES
	('20131112001','测试人员','','哈哈','','','',NULL,'','','','','','','','',NULL,NULL,NULL,NULL,'liuying','2013-11-12 20:27:37'),
	('20140207002','撒旦法','','jxs','China','','','发松岛枫','','','','0020','撒旦法斯蒂芬','hjg','阿斯蒂芬 ','',NULL,NULL,NULL,NULL,'','2014-02-07 22:54:13'),
	('2014042700','12','','jxs','China','','','1212','','','','0010','1212','hjg','1212','','','','','','','2014-04-27 20:54:37'),
	('GJH0000001','asdf','','jxs','China','','','asdf','','','','0010','asdf','gjh','asdf','','','','','','admin','2015-03-06 18:46:02'),
	('GJH0000002','1','','jxs','China','','','1','','','','0010','1','gjh','1','','','','','','liuying','2015-03-07 23:44:27');

/*!40000 ALTER TABLE `customer_info` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table data_miner
# ------------------------------------------------------------

DROP TABLE IF EXISTS `data_miner`;

CREATE TABLE `data_miner` (
  `SerialNo` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '',
  `Content` blob,
  `title` varchar(100) COLLATE utf8_bin DEFAULT NULL,
  `link` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `InputDate` varchar(32) COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`SerialNo`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;



# Dump of table dataobject_catalog
# ------------------------------------------------------------

DROP TABLE IF EXISTS `dataobject_catalog`;

CREATE TABLE `dataobject_catalog` (
  `DONO` varchar(32) COLLATE utf8_bin NOT NULL COMMENT '模板编号',
  `DONAME` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '模板名称',
  `DORemark` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '说明',
  `WHERESQL` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT 'where条件',
  `MAINTABLE` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '主表',
  `UNIONTABLE` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '从表',
  `ORDERBY` varchar(255) COLLATE utf8_bin DEFAULT '' COMMENT '排序',
  `ITEMNUM` varchar(2) COLLATE utf8_bin DEFAULT NULL COMMENT '从表',
  `HANDLER` varchar(80) COLLATE utf8_bin DEFAULT NULL COMMENT 'handler类',
  `KEYSTRATEGY` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT '主键值生成策略',
  PRIMARY KEY (`DONO`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

LOCK TABLES `dataobject_catalog` WRITE;
/*!40000 ALTER TABLE `dataobject_catalog` DISABLE KEYS */;

INSERT INTO `dataobject_catalog` (`DONO`, `DONAME`, `DORemark`, `WHERESQL`, `MAINTABLE`, `UNIONTABLE`, `ORDERBY`, `ITEMNUM`, `HANDLER`, `KEYSTRATEGY`)
VALUES
	('AppDetailInfo','子系统信息列表',NULL,'appID=?','app_info','','','2','net.vinote.smart.platform.service.handler.AppInfoHandler',''),
	('AppInfoList','子系统信息列表',NULL,'subject=? order by subject, sortno','app_info','','','','',NULL),
	('AppItemInfo','子系统栏目列表',NULL,'appID=? and itemID=?','app_item','','','2','net.vinote.smart.platform.service.handler.AppItemHandler',''),
	('AppItemList','子系统栏目列表',NULL,'appID=? order by sortno','app_item','','','','net.vinote.smart.platform.service.handler.AppItemHandler',''),
	('AttendanceList','考勤列表',NULL,'','ATTENDANCE_INFO','','','','',''),
	('CodeCatalogInfo','代码目录详情',NULL,'codeNo=?','code_catalog','','','','net.vinote.smart.platform.service.handler.CodeCatalogHandler',''),
	('CodeCatalogList','代码目录列表',NULL,'1=1','code_catalog','','','','',NULL),
	('CodeCatalogListByType','代码目录列表',NULL,'codeType=? order by sortno','code_catalog','','','','net.vinote.smart.platform.service.handler.CodeCatalogHandler',''),
	('CodeLibraryInfo','代码明细列表',NULL,'CodeNo=? and ItemNo=?','code_library','','','1','net.vinote.smart.platform.service.handler.CodeLibraryHandler',''),
	('CodeLibraryList','代码明细列表',NULL,'CodeNo=? order by sortno','code_library','','','1','net.vinote.smart.platform.service.handler.CodeLibraryHandler',''),
	('CommonRegexSelector','代码明细列表',NULL,'CodeNo='CommonRegex' order by sortno','CODE_LIBRARY','','','1','',''),
	('ContactBookInfo','通讯录列表',NULL,'SerialNo=?','CONTACT_BOOK','','','2','com.cms.customer.handler.ContactBookHandler',NULL),
	('ContactBookList','通讯录列表',NULL,'RELATIVECUSTOMERID=?','CONTACT_BOOK','','','','com.cms.customer.handler.ContactBookHandler',''),
	('ContractTemplateInfo','电子合同模板详情',NULL,'id=?','CONTRACT_TEMPLATE','','','1','net.vinote.smart.platform.service.handler.ContractTemplateHandler',''),
	('ContractTemplateList','电子合同模板列表',NULL,'','CONTRACT_TEMPLATE','','','','',''),
	('ControlBoardInfo','控制面板',NULL,'','V','','','','',''),
	('CustomerInfo','客户信息列表',NULL,'customerID=?','CUSTOMER_INFO','','','2','com.cms.customer.handler.CustomerInfoHander','com.cms.customer.handler.CustomerInfoKeyStrategy'),
	('CustomerList','客户信息列表',NULL,'inputuserid=?','CUSTOMER_INFO','','','','com.cms.customer.handler.CustomerInfoHander',NULL),
	('DWCONFIG','数据窗体详情',NULL,'DONO=? and FieldCode=?','dataobject_library','','','2','net.vinote.smart.platform.service.handler.DataWindowLibraryHandler',''),
	('DataWindowPageInfo','显示模板页面列表',NULL,'pagePath=?','DataWindow_Page','','','','',NULL),
	('DataWindowPageList','显示模板页面列表',NULL,'1=1','DataWindow_Page','','','','',NULL),
	('DataWindowPagebyTypeList','显示模板页面列表',NULL,'pageType=?','DataWindow_Page','','','','',NULL),
	('DepotInfo','仓库信息详情',NULL,'DepotNo=?','DEPOT_INFO','','','','',''),
	('DepotList','仓库信息列表',NULL,'','DEPOT_INFO','','','','',''),
	('DwEditInfo','显示模板目录详情',NULL,'doNo=?','dataobject_catalog','','','','net.vinote.smart.platform.service.handler.DataWindowCatalogHandler',''),
	('DwEditList','数据窗体列表',NULL,'dono not in('DWCONFIG')','dataobject_catalog','','','','net.vinote.smart.platform.service.handler.DataWindowCatalogHandler',''),
	('DwEventInfo','显示模板事件列表',NULL,'doNo=? and fieldCode=? and event=?','DataObject_Event','','','','net.vinote.smart.platform.service.handler.DataWindowEventHandler',''),
	('DwEventList','显示模板事件列表',NULL,'doNo=? and fieldCode=?','DataObject_Event','','','','',NULL),
	('DwLibraryList','数据窗体详情',NULL,'doNo=? order by sortno','dataobject_library','','','','net.vinote.smart.platform.service.handler.DataWindowLibraryHandler',''),
	('ElectronicContractList','电子合同列表',NULL,'O.templateid=CT.id','CONTRACT_INFO','CONTRACT_TEMPLATE CT','','','',''),
	('EmailList','邮件列表',NULL,'1=1','V','','','','net.vinote.smart.platform.service.handler.EmailListVirtualHandler',''),
	('GoodsAccessInfo','货物出入库列表',NULL,'SerialNo=?','GOODS_ACCESS','','','2','',''),
	('GoodsAccessList','货物出入库列表',NULL,'inputUserID=?','GOODS_ACCESS','','','','',''),
	('LayoutCatalogInfo','布局配置定义',NULL,'layoutID=?','layout_catalog','','','','net.vinote.smart.platform.service.handler.LayoutCatalogHandler',''),
	('LayoutCatalogList','布局配置定义',NULL,'subject=? and layoutStyle=?','layout_catalog','','','','net.vinote.smart.platform.service.handler.LayoutCatalogHandler',''),
	('LayoutItemInfo','布局栏目列表',NULL,'layoutID=? and pageID=?','layout_item','','','','net.vinote.smart.platform.service.handler.LayoutItemHandler',''),
	('LayoutItemList','布局栏目列表',NULL,'layoutID=?','layout_item','','','','',NULL),
	('LicenseRegistInfo','许可证注册页面',NULL,'','V','','','','net.vinote.smart.platform.service.handler.LicenseRegistVirtualHandler',''),
	('NewOnlineList','在线新闻列表',NULL,'PUBLISHDate is not null order by PUBLISHDate','NEWS_INFO','','','','',''),
	('NewsDetailInfo','新闻详情',NULL,'SerialNo=?','NEWS_INFO','','','1','',''),
	('OrgDetailInfo','机构信息详情',NULL,'orgid=?','ORG_INFO','','','2','',NULL),
	('ProductItemInfo','产品栏目详情',NULL,'ProductNo=?','PRODUCT_ITEM','','','','',''),
	('ProductItemList','产品栏目列表',NULL,'1=1','PRODUCT_ITEM','','','','',''),
	('RoleInfo','角色详情',NULL,'RoleID=?','Role_Info','','','','net.vinote.smart.platform.service.handler.RoleInfoHandler',''),
	('RoleList','角色列表',NULL,'','Role_Info','','','','net.vinote.smart.platform.service.handler.RoleInfoHandler',''),
	('SampleInfo','样品列表详情',NULL,'SerialNo=?','SAMPLE_INFO','','','2','',''),
	('SampleList','样品列表',NULL,'','SAMPLE_INFO','','','','',''),
	('ServiceContractList','业务合同列表',NULL,'O.templateid=CT.id and O.ObjectType=? and O.ObjectId=?','CONTRACT_INFO','CONTRACT_TEMPLATE CT','','','',''),
	('SystemParamInfo','系统参数列表',NULL,'paramname=?','system_param','','','','net.vinote.smart.platform.service.handler.SystemParamHandler',''),
	('SystemParamList','系统参数列表',NULL,'','system_param','','','','net.vinote.smart.platform.service.handler.SystemParamHandler',''),
	('TableObjectColumnList','表对象列表详情',NULL,'tablename=? order by sortno','table_object','','','','net.vinote.smart.platform.service.handler.TableObjectInfoHandler',NULL),
	('TableObjectInfo','表对象列表详情',NULL,'tableName=? and fieldName=?','table_object','','','','net.vinote.smart.platform.service.handler.TableObjectInfoHandler',NULL),
	('TableObjectList','表对象列表',NULL,'1=1 group by tablename','table_object','','',NULL,'',NULL),
	('TimerTaskInfo','定时任务列表',NULL,'id=?','TIMER_TASK','','','2','net.vinote.smart.platform.service.handler.TimerTaskHandler',''),
	('TimerTaskList','定时任务列表',NULL,'','TIMER_TASK','','','','net.vinote.smart.platform.service.handler.TimerTaskHandler',''),
	('TreeSQLInfo','树图SQL定义视图',NULL,'','V','','','2','net.vinote.smart.platform.service.handler.TreeSQLDefineVirtualHandler',''),
	('UserInfo','用户信息列表',NULL,'UserID=?','user_info','','','2','net.vinote.smart.platform.service.handler.UserInfoHandler',''),
	('UserInfoEdit','用户信息列表',NULL,'UserID=?','user_info','','','','',NULL),
	('UserList','用户信息列表',NULL,'1=1','user_info','','','','net.vinote.smart.platform.service.handler.UserInfoHandler',''),
	('UserPasswordChange','用户密码修改',NULL,'UserID=?','user_info','','','','net.vinote.smart.platform.service.handler.UserPasswordChangeHandler','');

/*!40000 ALTER TABLE `dataobject_catalog` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table dataobject_event
# ------------------------------------------------------------

DROP TABLE IF EXISTS `dataobject_event`;

CREATE TABLE `dataobject_event` (
  `doNo` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '显示模板编号',
  `fieldCode` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '显示模板编号',
  `EVENT` varchar(16) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '显示模板编号',
  `Script` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '事件执行方法',
  `isInUse` varchar(1) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '是否可用',
  PRIMARY KEY (`fieldCode`,`doNo`,`EVENT`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

LOCK TABLES `dataobject_event` WRITE;
/*!40000 ALTER TABLE `dataobject_event` DISABLE KEYS */;

INSERT INTO `dataobject_event` (`doNo`, `fieldCode`, `EVENT`, `Script`, `isInUse`)
VALUES
	('DataWindowPageInfo','DISPLAYSTYLE','onchange','displayToggle();','1'),
	('DataWindowPageInfo','buttons','onmouseover','showTitle(this);','1');

/*!40000 ALTER TABLE `dataobject_event` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table dataobject_library
# ------------------------------------------------------------

DROP TABLE IF EXISTS `dataobject_library`;

CREATE TABLE `dataobject_library` (
  `DONO` varchar(32) COLLATE utf8_bin NOT NULL COMMENT '模板编号',
  `FIELDCODE` varchar(32) COLLATE utf8_bin NOT NULL COMMENT '字段编号',
  `FIELDNAME` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '字段名称',
  `SORTNO` varchar(4) COLLATE utf8_bin DEFAULT NULL COMMENT '排序号',
  `DATAOBJ` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '数据对象',
  `COLFIELD` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '表字段',
  `REGEX` varchar(48) COLLATE utf8_bin DEFAULT NULL COMMENT '数据格式',
  `InvalidMessage` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '无效提示信息',
  `SHOWTAG` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '显示标签',
  `AFTERFIELD` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '显示后缀',
  `ISFILTER` varchar(1) COLLATE utf8_bin DEFAULT NULL COMMENT '是否可查询',
  `ISREQUIRED` varchar(1) COLLATE utf8_bin DEFAULT NULL COMMENT '是否必须',
  `ISVISIBLE` varchar(1) COLLATE utf8_bin DEFAULT NULL COMMENT '是否可见',
  `ISREADONLY` varchar(1) COLLATE utf8_bin DEFAULT NULL COMMENT '是否只读',
  `ISINUSE` varchar(1) COLLATE utf8_bin DEFAULT NULL COMMENT '是否可用',
  `HTMLSTYLE` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '显示样式',
  `HTMLSOURCE` varchar(10) COLLATE utf8_bin DEFAULT NULL COMMENT '显示来源',
  `HTMLVAL` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '显示来源',
  `COLSPAN` varchar(2) COLLATE utf8_bin DEFAULT NULL COMMENT '占用列数',
  `ROWSPAN` varchar(2) COLLATE utf8_bin DEFAULT NULL COMMENT '占用行数',
  PRIMARY KEY (`DONO`,`FIELDCODE`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

LOCK TABLES `dataobject_library` WRITE;
/*!40000 ALTER TABLE `dataobject_library` DISABLE KEYS */;

INSERT INTO `dataobject_library` (`DONO`, `FIELDCODE`, `FIELDNAME`, `SORTNO`, `DATAOBJ`, `COLFIELD`, `REGEX`, `InvalidMessage`, `SHOWTAG`, `AFTERFIELD`, `ISFILTER`, `ISREQUIRED`, `ISVISIBLE`, `ISREADONLY`, `ISINUSE`, `HTMLSTYLE`, `HTMLSOURCE`, `HTMLVAL`, `COLSPAN`, `ROWSPAN`)
VALUES
	('AppDetailInfo','AppID','子系统ID','0010','O','AppID','','','input[text]','',NULL,'1','1','0','1','','','','1','1'),
	('AppDetailInfo','AppName','子系统名称','0020','O','AppName','','','input[text]','',NULL,'1','1','0','1','','','','1','1'),
	('AppDetailInfo','IsInUse','是否可用','0040','O','IsInUse',NULL,NULL,'select','',NULL,NULL,'1','0','1','','Code','YesNo','1','1'),
	('AppDetailInfo','Logo','Logo','0050','O','Logo',NULL,NULL,'input[text]','',NULL,NULL,'1','0','1','','','','1','1'),
	('AppDetailInfo','MinLogo','MinLogo','0060','O','MinLogo',NULL,NULL,'input[text]','',NULL,NULL,'1','0','1','','','','1','1'),
	('AppDetailInfo','SortNo','排序号','0030','O','SortNo',NULL,NULL,'input[text]','',NULL,NULL,'1','0','1','','','','1','1'),
	('AppDetailInfo','Subject','业务模块','0025','O','Subject','','','select','',NULL,'1','1','0','1','','Code','AppInfoSubject','1','1'),
	('AppDetailInfo','URL','URL','0070','O','URL','',NULL,'input[text]','',NULL,NULL,'1','0','1','width:100%','','','2','1'),
	('AppDetailInfo','WorkBench','显示于工作台','0026','O','WorkBench','',NULL,'select','',NULL,NULL,'1','0','1','','Code','YesNo','1','1'),
	('AppInfoList','AppID','子系统ID','0010','O','AppID',NULL,NULL,'input[text]','',NULL,NULL,'1','0','1','','','','1','1'),
	('AppInfoList','AppName','子系统名称','0020','O','AppName','','','input[text]','',NULL,NULL,'1','0','1','','','','1','1'),
	('AppInfoList','SortNo','排序号','0030','O','SortNo',NULL,NULL,'input[text]','',NULL,NULL,'1','0','1','','','','1','1'),
	('AppInfoList','Subject','业务模块','0040','O','Subject',NULL,NULL,'input[text]','','1',NULL,'1','0','1','','Code','AppInfoSubject','1','1'),
	('AppItemInfo','AppID','子系统编号','0020','O','AppID',NULL,NULL,'span','',NULL,NULL,'1','1','1','','','','1','1'),
	('AppItemInfo','IsInUse','是否可用','0050','O','IsInUse','',NULL,'select','',NULL,'1','1','0','1','','Code','YesNo','1','1'),
	('AppItemInfo','ItemID','栏目编号','0010','O','ItemID','',NULL,'input[text]','',NULL,'1','1','0','1','',' ','','1','1'),
	('AppItemInfo','ItemName','栏目名称','0030','O','ItemName','',NULL,'input[text]','',NULL,'1','1','0','1','',' ','','1','1'),
	('AppItemInfo','SortNo','排序号','0040','O','SortNo',NULL,NULL,'input[text]','',NULL,NULL,'1','0','1','','','','1','1'),
	('AppItemInfo','TriggerMode','触发方式','0055','O','TriggerMode',NULL,NULL,'select','',NULL,NULL,'1','0','1','','Code','AppItemTriggerMode','1','1'),
	('AppItemInfo','URL','URL','0060','O','URL','',NULL,'textarea','',NULL,NULL,'1','0','1','width:90%;height:80px;word-wrap:break-word;word-break:break-all','','','2','1'),
	('AppItemInfo','WorkBench','显示于工作台','0035','O','WorkBench','',NULL,'select','',NULL,NULL,'1','0','1','','Code','YesNo','1','1'),
	('AppItemList','AppID','子系统编号','0020','O','AppID',NULL,NULL,'span','',NULL,NULL,'1','1','1','','','','1','1'),
	('AppItemList','IsInUse','是否可用','0050','O','IsInUse',NULL,NULL,'select','',NULL,NULL,'1','0','1','','Code','YesNo','1','1'),
	('AppItemList','ItemID','栏目编号','0010','O','ItemID',NULL,NULL,'input[text]','',NULL,NULL,'1','0','1','','','','1','1'),
	('AppItemList','ItemName','栏目名称','0030','O','ItemName',NULL,NULL,'input[text]','',NULL,NULL,'1','0','1','','','','1','1'),
	('AppItemList','SortNo','排序号','0040','O','SortNo',NULL,NULL,'input[text]','',NULL,NULL,'1','0','1','','','','1','1'),
	('AppItemList','URL','URL','0060','O','URL',NULL,NULL,'input[text]','',NULL,NULL,'1','0','1','','','','1','1'),
	('AttendanceList','ID','序列号','0110','O','ID','','','input[text]','',NULL,NULL,'1','0','1','','','','',''),
	('AttendanceList','INPUTDATE','登记时间','0130','O','INPUTDATE','','','input[text]','',NULL,NULL,'1','0','1','','','','',''),
	('AttendanceList','USERID','登记人','0120','O','USERID','','','input[text]','',NULL,NULL,'1','0','1','','','','',''),
	('CodeCatalogInfo','CodeName','代码名称','0020','O','CodeName','',NULL,'input[text]','',NULL,'1','1','0','1','','','','1','1'),
	('CodeCatalogInfo','CodeNo','代码编号','0010','O','CodeNo',NULL,NULL,'input[text]','',NULL,NULL,'1','0','1','','','','1','1'),
	('CodeCatalogInfo','CodeType','代码类型','0025','O','CodeType','',NULL,'select','',NULL,'1','1','0','1','','Code','CodeType','',''),
	('CodeCatalogInfo','Remark','备注','0040','O','Remark',NULL,NULL,'input[text]','',NULL,NULL,'1','0','1','','','','1','1'),
	('CodeCatalogInfo','SortNo','排序号','0030','O','SortNo',NULL,NULL,'input[text]','',NULL,NULL,'1','0','1','','','','1','1'),
	('CodeCatalogList','CodeName','代码名称','0020','O','CodeName','','','input[text]','','1',NULL,'1','0','1','','','','1','1'),
	('CodeCatalogList','CodeNo','代码编号','0010','O','CodeNo','','','input[text]','','1',NULL,'1','0','1','','','','1','1'),
	('CodeCatalogList','SortNo','排序号','0030','O','SortNo',NULL,NULL,'input[text]','',NULL,NULL,'1','0','1','','','','1','1'),
	('CodeCatalogListByType','CodeName','代码名称','0020','O','CodeName','','','input[text]','','1',NULL,'1','0','1','','','','1','1'),
	('CodeCatalogListByType','CodeNo','代码编号','0010','O','CodeNo','','','input[text]','','1',NULL,'1','0','1','','','','1','1'),
	('CodeCatalogListByType','SortNo','排序号','0030','O','SortNo',NULL,NULL,'input[text]','',NULL,NULL,'1','0','1','','','','1','1'),
	('CodeLibraryInfo','Attr01','属性1','0060','O','Attr01','','','input[text]','',NULL,NULL,'1','0','1','width:100%','','','1','1'),
	('CodeLibraryInfo','CodeNo','代码名称','0010','O','CodeNo',NULL,NULL,'span','',NULL,NULL,'1','0','1','','','','1','1'),
	('CodeLibraryInfo','IsInUse','是否可用','0050','O','IsInUse','',NULL,'select','',NULL,'1','1','0','1','','Code','YesNo','1','1'),
	('CodeLibraryInfo','ItemName','栏目名称','0030','O','ItemName','',NULL,'input[text]','',NULL,'1','1','0','1','','','','1','1'),
	('CodeLibraryInfo','ItemNo','代码栏目号','0020','O','ItemNo','',NULL,'input[text]','',NULL,'1','1','0','1','','','','1','1'),
	('CodeLibraryInfo','SortNo','排序号','0040','O','SortNo','',NULL,'input[text]','',NULL,'1','1','0','1','','','','1','1'),
	('CodeLibraryList','CodeNo','代码名称','0010','O','CodeNo','','','span','','0',NULL,'1','0','1','','','','1','1'),
	('CodeLibraryList','IsInUse','是否可用','0050','O','IsInUse','','','select','','1',NULL,'1','0','1','','Code','YesNo','1','1'),
	('CodeLibraryList','ItemName','栏目名称','0030','O','ItemName','','','input[text]','','1',NULL,'1','0','1','','','','1','1'),
	('CodeLibraryList','ItemNo','代码栏目号','0020','O','ItemNo','','','input[text]','','1',NULL,'1','0','1','','','','1','1'),
	('CodeLibraryList','SortNo','排序号','0040','O','SortNo','','','input[text]','',NULL,NULL,'1','0','1','','','','0','1'),
	('CommonRegexSelector','ATTR01','正则表达式','0040','O','ATTR01','','','','',NULL,NULL,'1','0','1','','','','',''),
	('CommonRegexSelector','CodeNo','代码名称','0010','O','CodeNo','','','span','',NULL,NULL,'0','0','1','','','','1','1'),
	('CommonRegexSelector','ItemName','正则名','0030','O','ItemName','','','input[text]','',NULL,NULL,'1','0','1','','','','1','1'),
	('CommonRegexSelector','ItemNo','代码栏目号','0020','O','ItemNo','','','input[text]','',NULL,NULL,'0','0','1','','','','1','1'),
	('ContactBookInfo','ADDRESS','地址','0060','O','ADDRESS','',NULL,'input[text]','',NULL,'1','1','0','1','width:400px','','','2',''),
	('ContactBookInfo','CELLPHONE','手机号码','0100','O','CELLPHONE','',NULL,'input[text]','',NULL,NULL,'1','0','1','','','','',''),
	('ContactBookInfo','CONTACTNO','联系账号','0130','O','CONTACTNO','',NULL,'input[text]','',NULL,NULL,'1','0','1','','','','',''),
	('ContactBookInfo','CONTACTTYPE','联系方式','0120','O','CONTACTTYPE','',NULL,'select','',NULL,NULL,'1','0','1','','Code','ContactType','',''),
	('ContactBookInfo','CUSTOMERNAME','姓名','0030','O','CUSTOMERNAME','',NULL,'input[text]','',NULL,'1','1','0','1','','','','',''),
	('ContactBookInfo','DEPARTMENT','部门','0070','O','DEPARTMENT','',NULL,'input[text]','',NULL,NULL,'1','0','1','','','','',''),
	('ContactBookInfo','EMAIL','E-mail','0050','O','EMAIL','\w+([-+.]\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*','请输入正确格式的email地址','input[text]','',NULL,'1','1','0','1','width:300px','','','',''),
	('ContactBookInfo','FAXNUMBER','传真号','0110','O','FAXNUMBER','',NULL,'input[text]','',NULL,NULL,'1','0','1','','','','2',''),
	('ContactBookInfo','PHONENUMBER','座机号码','0090','O','PHONENUMBER','',NULL,'input[text]','',NULL,'1','1','0','1','','','','',''),
	('ContactBookInfo','POST','职务','0080','O','POST','',NULL,'input[text]','',NULL,NULL,'1','0','1','','','','',''),
	('ContactBookInfo','RELATIVECUSTOMERID','关联客户编号','0020','O','RELATIVECUSTOMERID','',NULL,'input[text]','',NULL,NULL,'0','0','1','','','','',''),
	('ContactBookInfo','SERIALNO','序列号','0010','O','SERIALNO','',NULL,'input[text]','',NULL,NULL,'0','0','1','','','','',''),
	('ContactBookInfo','SEX','性别','0040','O','SEX','',NULL,'input[radio]','',NULL,NULL,'1','0','1','','Code','Sex','',''),
	('ContactBookList','ADDRESS','地址','0060','O','ADDRESS','',NULL,'input[text]','',NULL,'1','1','0','1','width:400px','','','2',''),
	('ContactBookList','CELLPHONE','手机号码','0100','O','CELLPHONE','',NULL,'input[text]','',NULL,NULL,'1','0','1','','','','',''),
	('ContactBookList','CONTACTNO','联系账号','0130','O','CONTACTNO','',NULL,'input[text]','',NULL,NULL,'1','0','1','','','','',''),
	('ContactBookList','CONTACTTYPE','联系方式','0120','O','CONTACTTYPE','',NULL,'select','',NULL,NULL,'1','0','1','','Code','ContactType','',''),
	('ContactBookList','CUSTOMERNAME','姓名','0030','O','CUSTOMERNAME','','','input[text]','','1','1','1','0','1','','','','',''),
	('ContactBookList','DEPARTMENT','部门','0070','O','DEPARTMENT','',NULL,'input[text]','',NULL,NULL,'1','0','1','','','','',''),
	('ContactBookList','EMAIL','E-mail','0050','O','EMAIL','',NULL,'input[text]','',NULL,'1','1','0','1','width:300px','','','',''),
	('ContactBookList','FAXNUMBER','传真号','0110','O','FAXNUMBER','',NULL,'input[text]','',NULL,NULL,'1','0','1','','','','2',''),
	('ContactBookList','PHONENUMBER','座机号码','0090','O','PHONENUMBER','',NULL,'input[text]','',NULL,'1','1','0','1','','','','',''),
	('ContactBookList','POST','职务','0080','O','POST','',NULL,'input[text]','',NULL,NULL,'1','0','1','','','','',''),
	('ContactBookList','RELATIVECUSTOMERID','关联客户编号','0020','O','RELATIVECUSTOMERID','',NULL,'input[text]','',NULL,NULL,'0','0','1','','','','',''),
	('ContactBookList','SERIALNO','序列号','0010','O','SERIALNO','',NULL,'input[text]','',NULL,NULL,'0','0','1','','','','',''),
	('ContactBookList','SEX','性别','0040','O','SEX','',NULL,'input[radio]','',NULL,NULL,'1','0','1','','Code','Sex','',''),
	('ContractTemplateInfo','CONTENT','正文','0025','O','CONTENT','','','richTextArea','',NULL,NULL,'1','0','1','','','','',''),
	('ContractTemplateInfo','ID','合同模板编号','0010','O','ID','','','span','','1',NULL,'1','0','1','','','','',''),
	('ContractTemplateInfo','INPUTDATE','创建时间','0990','O','INPUTDATE','','','span','',NULL,NULL,'1','0','1','','','','',''),
	('ContractTemplateInfo','INPUTUSERID','创建者','0980','O','INPUTUSERID','','','span','',NULL,NULL,'1','0','1','','','','',''),
	('ContractTemplateInfo','TITLE','合同模板标题','0020','O','TITLE','','','input[text]','','1',NULL,'1','0','1','','','','',''),
	('ContractTemplateInfo','UPDATEDATE','更新日期','0970','O','UPDATEDATE','','','span','',NULL,NULL,'1','0','1','','','','',''),
	('ContractTemplateInfo','UPDATEUSERID','修改者','0960','O','UPDATEUSERID','','','span','',NULL,NULL,'1','0','1','','','','',''),
	('ContractTemplateList','ID','合同模板编号','0010','O','ID','','','input[text]','','1',NULL,'1','0','1','','','','',''),
	('ContractTemplateList','INPUTDATE','创建时间','0990','O','INPUTDATE','','','input[datetime]','',NULL,NULL,'1','0','1','','','','',''),
	('ContractTemplateList','INPUTUSERID','创建者','0980','O','INPUTUSERID','','','input[text]','',NULL,NULL,'1','0','1','','','','',''),
	('ContractTemplateList','TITLE','合同模板标题','0020','O','TITLE','','','input[text]','','1',NULL,'1','0','1','','','','',''),
	('ContractTemplateList','UPDATEDATE','更新日期','0970','O','UPDATEDATE','','','input[text]','',NULL,NULL,'1','0','1','','','','',''),
	('ContractTemplateList','UPDATEUSERID','修改者','0960','O','UPDATEUSERID','','','input[text]','',NULL,NULL,'1','0','1','','','','',''),
	('ControlBoardInfo','ControlBoard','控制面板','0010','','','','','span','',NULL,NULL,'1','0','1','','','','',''),
	('ControlBoardInfo','refreshPermission','刷新权限表','0020','','','','','span','<input type='button' value='刷新权限表' onclick='refreshPermission()'/>',NULL,NULL,'1','0','1','','','','0',''),
	('ControlBoardInfo','refreshTable','刷新表字段','0040','','','','','span','<input type='button' value='刷新表字段' onclick='refreshTable()'/>',NULL,NULL,'1','0','1','','','','0',''),
	('ControlBoardInfo','treeSqlDefine','树图SQL定义','0030','','','','','','<input type='button' value='树图SQL定义' onclick='treeSqlDefine()'/>',NULL,NULL,'1','0','1','','','','0',''),
	('CustomerInfo','ADDRESS','详细地址','0175','O','ADDRESS','',NULL,'input[text]','',NULL,'1','1','0','1','width:350px','','','2',''),
	('CustomerInfo','BusinessType','业务类型','0270','O','BusinessType','',NULL,'input[text]','',NULL,'1','1','0','1','','','','',''),
	('CustomerInfo','CITY','城市','0170','O','CITY','',NULL,'input[text]','',NULL,NULL,'1','0','1','','','','','1'),
	('CustomerInfo','COUNTRY','国家/地区','0150','O','COUNTRY','',NULL,'select','',NULL,'1','1','0','1','','Code','CountryCode','',''),
	('CustomerInfo','CUSTOMERID','客户编号','0100','O','CUSTOMERID','',NULL,'span','',NULL,NULL,'1','1','1','',' ','','',''),
	('CustomerInfo','CUSTOMERNAME','公司名称','0120','O','CUSTOMERNAME','',NULL,'input[text]','',NULL,'1','1','0','1','','','','1','1'),
	('CustomerInfo','CUSTOMERPOST','客户职务','0135','O','CUSTOMERPOST','',NULL,'input[text]','',NULL,NULL,'1','0','1','','','','',''),
	('CustomerInfo','CUSTOMERTYPE','客户类型','0130','O','CUSTOMERTYPE','',NULL,'select','',NULL,'1','1','0','1','','Code','CustomerType','1','1'),
	('CustomerInfo','CustomerRating','客户等级','0125','O','CustomerRating','',NULL,'select','',NULL,'1','1','0','1','','Code','CustomerRating','',''),
	('CustomerInfo','CustomerSource','客户来源','0260','O','CustomerSource','',NULL,'select','',NULL,'1','1','0','1','','Code','CustomerSource','',''),
	('CustomerInfo','FAX','传真','0200','O','FAX','',NULL,'input[text]','',NULL,NULL,'1','0','1','',' ','','',''),
	('CustomerInfo','HOMEPAGE','公司主页','0140','O','HOMEPAGE','',NULL,'input[text]','',NULL,NULL,'1','0','1','width:350px',' ','','2',''),
	('CustomerInfo','INPUTDATE','登记日期','0990','O','INPUTDATE','',NULL,'span','',NULL,NULL,'1','1','1','',' ','','',''),
	('CustomerInfo','INPUTUSERID','登记人','0980','O','INPUTUSERID','',NULL,'input[text]','',NULL,NULL,'0','1','1','',' ','','',''),
	('CustomerInfo','INPUTUSERNAME','登记人','0980','','','','','span','',NULL,NULL,'1','0','1','','Java','net.vinote.smart.platform.service.action.UserInfoAction.getUserName(INPUTUSERID)','',''),
	('CustomerInfo','MainProducts','主营产品','0250','O','MainProducts','',NULL,'input[text]','',NULL,'1','1','0','1','','','','',''),
	('CustomerInfo','PAYTIME','付款期限','0300','O','PAYTIME','',NULL,'input[datetime]','',NULL,NULL,'1','0','1','','','','',''),
	('CustomerInfo','PHONE','号码','0190','O','PHONE','',NULL,'input[text]','',NULL,NULL,'1','0','1','',' ','','',''),
	('CustomerInfo','PICTURE','客户照片','0105','O','PICTURE','',NULL,'image','',NULL,NULL,'1','0','1','height:80px;width:80px','','','1','2'),
	('CustomerInfo','PRICEARTICLE','价格条款','0280','O','PRICEARTICLE','',NULL,'input[text]','',NULL,NULL,'1','0','1','','','','',''),
	('CustomerInfo','PROVINCE','港口','0160','O','PROVINCE','',NULL,'input[text]','',NULL,NULL,'1','0','1','','','','',''),
	('CustomerInfo','SETTLEWAY','结汇方式','0290','O','SETTLEWAY','',NULL,'input[text]','',NULL,NULL,'1','0','1','','','','',''),
	('CustomerInfo','ZIPCODE','邮编','0180','O','ZIPCODE','',NULL,'input[text]','',NULL,NULL,'1','0','1','','','','','1'),
	('CustomerList','CUSTOMERID','客户编号','0011','O','CUSTOMERID','',NULL,'input[text]','','1',NULL,'1','0','1','','','','',''),
	('CustomerList','CUSTOMERNAME','客户名称','0012','O','CUSTOMERNAME','',NULL,'input[text]','','1',NULL,'1','0','1','','','','',''),
	('CustomerList','CUSTOMERSOURCE','客户来源','0050','O','CUSTOMERSOURCE','','','input[checkbox]','','1',NULL,'1','0','1','','Code','CustomerSource','',''),
	('CustomerList','CUSTOMERTYPE','客户类型','0013','O','CUSTOMERTYPE','','','input[checkbox]','','1',NULL,'1','0','1','','Code','CustomerType','',''),
	('CustomerList','CustomerRating','客户等级','0040','O','CustomerRating','','','input[checkbox]','','1',NULL,'1','0','1','','Code','CustomerRating','',''),
	('CustomerList','INPUTDATE','登记日期','0990','O','INPUTDATE','',NULL,'input[datetime]','','1',NULL,'1','0','1','','','','',''),
	('CustomerList','INPUTUSERID','登记人','0014','O','INPUTUSERID','',NULL,'input[text]','',NULL,NULL,'0','0','1','',' ','','',''),
	('CustomerList','INPUTUSERNAME','登记人','0980','','','','','span','',NULL,NULL,'1','0','1','','Java','net.vinote.smart.platform.service.action.UserInfoAction.getUserName(INPUTUSERID)','',''),
	('CustomerList','PHONE','号码','0060','O','PHONE','',NULL,'input[text]','','1',NULL,'1','0','1','','','','',''),
	('DWCONFIG','AFTERFIELD','后缀','0070','O','AFTERFIELD','','','input[text]','',NULL,NULL,'1','0','1','width:90%','','','1','1'),
	('DWCONFIG','COLFIELD','数据表字段名','0050','O','COLFIELD','',NULL,'input[text]','<input type='button' id='doSelect' value='选择'/>',NULL,NULL,'1','0','1','',' ','','1','1'),
	('DWCONFIG','COLSPAN','列宽','0160','O','COLSPAN','[0-5]?','','input[text]','',NULL,NULL,'1','0','1','','','','1','1'),
	('DWCONFIG','DATAOBJ','表对象','0045','O','DATAOBJ',NULL,NULL,'input[text]','',NULL,NULL,'1','0','1','',NULL,NULL,'1','1'),
	('DWCONFIG','DONO','显示模版','0010','O','DONO','',NULL,'span','',NULL,NULL,'1','1','1','','','','2','1'),
	('DWCONFIG','FIELDCODE','字段代码','0020','O','FIELDCODE',NULL,NULL,'input[text]','',NULL,NULL,'1','0','1','',NULL,NULL,'1','1'),
	('DWCONFIG','FIELDNAME','字段名称','0030','O','FIELDNAME',NULL,NULL,'input[text]','',NULL,NULL,'1','0','1','',NULL,NULL,'1','1'),
	('DWCONFIG','HTMLSOURCE','显示来源类型','0120','O','HTMLSOURCE','','','select','',NULL,NULL,'1','0','1','','Code','HTMLSOURCE','1','1'),
	('DWCONFIG','HTMLSTYLE','html样式','0110','O','HTMLSTYLE','',NULL,'textarea','',NULL,NULL,'1','0','1','width:80%;height:160px',' ','','2','1'),
	('DWCONFIG','HTMLVAL','显示来源','0130','O','HTMLVAL','','','input[text]','',NULL,NULL,'1','0','1','width:100%','','','1','1'),
	('DWCONFIG','ISFILTER','是否可过滤','0079','O','ISFILTER','','','input[radio]','',NULL,NULL,'1','0','1','','Code','YesNo','1','1'),
	('DWCONFIG','ISINUSE','是否可用','0100','O','ISINUSE',NULL,NULL,'input[radio]','',NULL,NULL,'1','0','1','','Code','YesNo','1','1'),
	('DWCONFIG','ISREADONLY','是否只读','0090','O','ISREADONLY',NULL,NULL,'input[radio]','',NULL,NULL,'1','0','1','','Code','YesNo','1','1'),
	('DWCONFIG','ISREQUIRED','是否必须','0085','O','ISREQUIRED','',NULL,'input[radio]','',NULL,NULL,'1','0','1','','Code','YesNo','',''),
	('DWCONFIG','ISVISIBLE','是否可见','0080','O','ISVISIBLE',NULL,NULL,'input[radio]','',NULL,NULL,'1','0','1','','Code','YesNo','1','1'),
	('DWCONFIG','InvalidMessage','字段提示信息','0076','O','InvalidMessage','','','input[text]','',NULL,NULL,'1','0','1','','','','2','1'),
	('DWCONFIG','REGEX','数据格式','0075','O','REGEX','.*','','input[text]','<input type='button'  onclick='selectRegex()' value='常用正则'/>',NULL,NULL,'1','0','1','','','','1','1'),
	('DWCONFIG','ROWSPAN','行宽','0170','O','ROWSPAN','[1-5]?','','input[text]','',NULL,NULL,'1','0','1','','','','1','1'),
	('DWCONFIG','SHOWTAG','显示方式','0060','O','SHOWTAG',NULL,NULL,'select','',NULL,NULL,'1','0','1','','Code','HtmlTag','1','1'),
	('DWCONFIG','SORTNO','排序','0050','O','SORTNO','\d{4}',NULL,'input[text]','',NULL,NULL,'1','0','1','','','','1','1'),
	('DataWindowPageInfo','DISPLAYSTYLE','显示风格','0050','O','DISPLAYSTYLE','','','select','',NULL,'0','1','0','1','','Code','DisplayStyle','1','1'),
	('DataWindowPageInfo','DONO','显示模板编号','0030','O','DONO','',NULL,'input[text]','<input type='button'  onclick='selectDW()' value='...'/>',NULL,'1','1','0','1','','','','1','1'),
	('DataWindowPageInfo','DWPARAM','显示模板参数','0040','O','DWPARAM',NULL,NULL,'input[text]','',NULL,NULL,'1','0','1','','','','1','1'),
	('DataWindowPageInfo','DatagridEvent','数据列表事件','0056','O','DatagridEvent',NULL,NULL,'input[checkbox]','',NULL,NULL,'1','0','1','','Code','DatagridEvent','1','1'),
	('DataWindowPageInfo','DatagridScript','事件脚本','0057','O','DatagridScript',NULL,NULL,'input[text]','',NULL,NULL,'1','0','1','width:240px','','','1','1'),
	('DataWindowPageInfo','PAGEPATH','页面路径','0010','O','PAGEPATH','',NULL,'input[text]','',NULL,'1','1','0','1','width:400px','','','1','1'),
	('DataWindowPageInfo','PageName','页面名称','0020','O','PageName','',NULL,'input[text]','',NULL,'1','1','0','1','','','','1','1'),
	('DataWindowPageInfo','PageType','页面类型','0025','O','PageType','',NULL,'select','',NULL,'1','1','0','1','width:180px','Code','PageType','',''),
	('DataWindowPageInfo','Script','js代码','0060','O','Script','','','textarea','',NULL,NULL,'1','0','1','width:90%;height:380px','','','1','1'),
	('DataWindowPageInfo','buttons','按钮组','0055','O','buttons',NULL,NULL,'input[checkbox]','',NULL,NULL,'1','0','1','','Code','ButtonGroup','1','1'),
	('DataWindowPageList','DISPLAYSTYLE','显示风格','0050','O','DISPLAYSTYLE','','','input[radio]','','1',NULL,'1','0','1','','Code','DisplayStyle','1','1'),
	('DataWindowPageList','DONO','显示模板编号','0030','O','DONO',NULL,NULL,'input[text]','',NULL,NULL,'1','0','1','','','','1','1'),
	('DataWindowPageList','DWPARAM','显示模板参数','0040','O','DWPARAM',NULL,NULL,'input[text]','',NULL,NULL,'1','0','1','','','','1','1'),
	('DataWindowPageList','PAGEPATH','页面路径','0010','O','PAGEPATH','',NULL,'input[text]','','1',NULL,'1','0','1','','','','1','1'),
	('DataWindowPageList','PageName','页面名称','0020','O','PageName',NULL,NULL,'span','',NULL,NULL,'1','0','1','','','','1','1'),
	('DataWindowPageList','PageType','页面类型','0025','O','PageType','','','select','','1',NULL,'1','0','1','','Code','PageType','',''),
	('DataWindowPagebyTypeList','DISPLAYSTYLE','显示风格','0050','O','DISPLAYSTYLE','','','input[radio]','','1',NULL,'1','0','1','','Code','DisplayStyle','1','1'),
	('DataWindowPagebyTypeList','DONO','显示模板编号','0030','O','DONO','','','input[text]','','1',NULL,'1','0','1','','','','1','1'),
	('DataWindowPagebyTypeList','DWPARAM','显示模板参数','0040','O','DWPARAM',NULL,NULL,'input[text]','',NULL,NULL,'1','0','1','','','','1','1'),
	('DataWindowPagebyTypeList','PAGEPATH','页面路径','0010','O','PAGEPATH','','','input[text]','','1',NULL,'1','0','1','','','','1','1'),
	('DataWindowPagebyTypeList','PageName','页面名称','0020','O','PageName','','','span','','1',NULL,'1','0','1','','','','1','1'),
	('DataWindowPagebyTypeList','PageType','页面类型','0025','O','PageType','','','select','','1',NULL,'1','0','1','','Code','PageType','',''),
	('DepotInfo','DEPOTADDRESS','仓库地址','0300','O','DEPOTADDRESS','',NULL,'input[text]','',NULL,'1','1','0','1','','','','',''),
	('DepotInfo','DEPOTNAME','仓库名称','0200','O','DEPOTNAME','',NULL,'input[text]','','0','1','1','0','1','','','','',''),
	('DepotInfo','DEPOTNO','仓库编号','0100','O','DEPOTNO','\w+','仓库编号必须为英文字母或数字组成','input[text]','',NULL,'1','1','0','1','','','','1','1'),
	('DepotList','DEPOTADDRESS','仓库地址','0300','O','DEPOTADDRESS','',NULL,'input[text]','',NULL,NULL,'1','0','1','','','','',''),
	('DepotList','DEPOTNAME','仓库名称','0200','O','DEPOTNAME','',NULL,'input[text]','',NULL,NULL,'1','0','1','','','','',''),
	('DepotList','DEPOTNO','仓库编号','0100','O','DEPOTNO','\w+',NULL,'input[text]','',NULL,NULL,'1','0','1','','','','',''),
	('DwEditInfo','DONAME','模板名称','0020','O','DONAME',NULL,NULL,'input[text]','',NULL,NULL,'1','0','1','','','','1','1'),
	('DwEditInfo','DONO','模板编号','0010','O','DONO',NULL,NULL,'input[text]','',NULL,NULL,'1','0','1','','','','1','1'),
	('DwEditInfo','HANDLER','handler类','0070','O','HANDLER',NULL,NULL,'input[text]','',NULL,NULL,'1','0','1','width:400px','','','1','1'),
	('DwEditInfo','ITEMNUM','栏目数','0050','O','ITEMNUM',NULL,NULL,'input[text]','',NULL,NULL,'1','0','1','','','','1','1'),
	('DwEditInfo','KEYSTRATEGY','主键值生成策略','0080','O','KEYSTRATEGY','',NULL,'input[text]','',NULL,NULL,'1','0','1','width:400px','','','',''),
	('DwEditInfo','MAINTABLE','主表','0030','O','MAINTABLE','','','input[text]','<font color=red>虚拟表模板输入:V</font>',NULL,NULL,'1','0','1','','','','1','1'),
	('DwEditInfo','UNIONTABLE','从表','0040','O','UNIONTABLE',NULL,NULL,'input[text]','',NULL,NULL,'1','0','1','','','','1','1'),
	('DwEditInfo','WHERESQL','Where条件','0060','O','WHERESQL',NULL,NULL,'textarea','',NULL,NULL,'1','0','1','width:300px;height:60px','','','1','1'),
	('DwEditList','DONAME','模板名称','0020','O','DONAME','','','input[text]','','1',NULL,'1','0','1','','','','1','1'),
	('DwEditList','DoNo','编号','0010','O','DoNo','',NULL,'input[text]','','1',NULL,'1','0','1','','','','1','1'),
	('DwEditList','HANDLER','Handler类','0060','O','HANDLER','',NULL,'','',NULL,NULL,'1','0','1','','','','',''),
	('DwEditList','ItemNum','显示栏位数','0050','O','ItemNUm',NULL,NULL,'input[text]','',NULL,NULL,'1','0','1','','','','1','1'),
	('DwEditList','MAINTABLE','主表','0030','O','MAINTABLE','','','input[text]','','1',NULL,'1','0','1','','','','1','1'),
	('DwEditList','WhereSQL','查询条件','0040','O','WhereSQL',NULL,NULL,'input[text]','',NULL,NULL,'1','0','1','',NULL,NULL,'1','1'),
	('DwEventInfo','DONO','显示模板编号','0001','O','DONO',NULL,NULL,'span','',NULL,NULL,'1','1','1','','','','1','1'),
	('DwEventInfo','EVENT','事件类型','0003','O','EVENT','','','select','',NULL,'1','1','0','1','','Code','EventType','1','1'),
	('DwEventInfo','FIELDCODE','字段编号','0002','O','FIELDCODE',NULL,NULL,'span','',NULL,NULL,'1','1','1','','','','1','1'),
	('DwEventInfo','ISINUSE','是否可用','0005','O','ISINUSE',NULL,NULL,'input[radio]','',NULL,NULL,'1','0','1','','Code','YesNo','1','1'),
	('DwEventInfo','SCRIPT','事件执行方法','0004','O','SCRIPT',NULL,NULL,'textarea','',NULL,NULL,'1','0','1','width:250px;height:60px','','','1','1'),
	('DwEventList','DONO','显示模板编号','0001','O','DONO',NULL,NULL,'span','',NULL,NULL,'1','0','1','','','','1','1'),
	('DwEventList','EVENT','事件类型','0003','O','EVENT',NULL,NULL,'input[radio]','',NULL,NULL,'1','0','1','','Code','EventType','1','1'),
	('DwEventList','FIELDCODE','字段编号','0002','O','FIELDCODE',NULL,NULL,'span','',NULL,NULL,'1','0','1','','','','1','1'),
	('DwEventList','ISINUSE','是否可用','0005','O','ISINUSE',NULL,NULL,'input[radio]','',NULL,NULL,'1','0','1','','Code','YesNo','1','1'),
	('DwEventList','SCRIPT','事件执行方法','0004','O','SCRIPT',NULL,NULL,'input[text]','',NULL,NULL,'1','0','1','width:180px','','','1','1'),
	('DwLibraryList','AFTERFIELD','后缀','0070','O','AFTERFIELD',NULL,NULL,'input[text]','',NULL,NULL,'1','0','1','',NULL,NULL,'1','1'),
	('DwLibraryList','COLFIELD','数据表字段名','0050','O','COLFIELD',NULL,NULL,'input[text]','',NULL,NULL,'1','0','1','',NULL,NULL,'1','1'),
	('DwLibraryList','DATAOBJ','表对象','0045','O','DATAOBJ',NULL,NULL,'input[text]','',NULL,NULL,'1','0','1','',NULL,NULL,'1','1'),
	('DwLibraryList','DONO','显示模版','0010','O','DONO',NULL,NULL,'span','',NULL,NULL,'1','1','1','',NULL,NULL,'1','1'),
	('DwLibraryList','FIELDCODE','字段代码','0020','O','FIELDCODE',NULL,NULL,'input[text]','',NULL,NULL,'1','0','1','',NULL,NULL,'1','1'),
	('DwLibraryList','FIELDNAME','字段名称','0030','O','FIELDNAME',NULL,NULL,'input[text]','',NULL,NULL,'1','0','1','',NULL,NULL,'1','1'),
	('DwLibraryList','HTMLSOURCE','显示来源类型','0120','O','HTMLSOURCE',NULL,NULL,'select','',NULL,NULL,'1','0','1','','Code','HTMLSOURCE','1','1'),
	('DwLibraryList','HTMLSTYLE','html样式','0110','O','HTMLSTYLE',NULL,NULL,'textarea','',NULL,NULL,'1','0','1','',NULL,NULL,'1','1'),
	('DwLibraryList','HTMLVAL','显示来源','0130','O','HTMLVAL','','','input[text]','',NULL,NULL,'1','0','1','width:100%','','','1','1'),
	('DwLibraryList','ISFILTER','是否可过滤','0075','O','ISFILTER',NULL,NULL,'input[radio]','',NULL,NULL,'1','0','1','','Code','YesNo','1','1'),
	('DwLibraryList','ISINUSE','是否可用','0100','O','ISINUSE',NULL,NULL,'input[radio]','',NULL,NULL,'1','0','1','','Code','YesNo','1','1'),
	('DwLibraryList','ISREADONLY','是否只读','0090','O','ISREADONLY',NULL,NULL,'input[radio]','',NULL,NULL,'1','0','1','','Code','YesNo','1','1'),
	('DwLibraryList','ISREQUIRED','是否必须','0085','O','ISREQUIRED','',NULL,'input[radio]','',NULL,NULL,'1','0','1','','Code','YesNo','',''),
	('DwLibraryList','ISVISIBLE','是否可见','0080','O','ISVISIBLE',NULL,NULL,'input[radio]','',NULL,NULL,'1','0','1','','Code','YesNo','1','1'),
	('DwLibraryList','SHOWTAG','显示方式','0060','O','SHOWTAG',NULL,NULL,'select','',NULL,NULL,'1','0','1','','Code','HtmlTag','1','1'),
	('DwLibraryList','SORTNO','排序','0050','O','SORTNO',NULL,NULL,'input[text]','',NULL,NULL,'1','0','1','',NULL,NULL,'1','1'),
	('ElectronicContractList','ID','合同编号','0030','O','ID','','','input[text]','','1',NULL,'1','0','1','','','','',''),
	('ElectronicContractList','INPUTDATE','创建时间','0990','O','INPUTDATE','','','input[text]','',NULL,NULL,'1','0','1','','','','',''),
	('ElectronicContractList','INPUTUSERID','创建者','0980','O','INPUTUSERID','','','input[text]','',NULL,NULL,'1','0','1','','','','',''),
	('ElectronicContractList','OBJECTID','关联对象ID','0060','O','OBJECTID','','','input[text]','',NULL,NULL,'0','0','1','','','','',''),
	('ElectronicContractList','OBJECTTYPE','关联对象类型','0070','O','OBJECTTYPE','','','input[text]','',NULL,NULL,'0','0','1','','','','',''),
	('ElectronicContractList','TEMPLATEID','合同模板编号','0080','O','TEMPLATEID',NULL,NULL,'input[text]',NULL,NULL,NULL,'1','0','1',NULL,NULL,NULL,NULL,NULL),
	('ElectronicContractList','TITLE','合同标题','0030','CT','TITLE','','','input[text]','','1',NULL,'1','0','1','','','','',''),
	('ElectronicContractList','UPDATEDATE','修改时间','0970','O','UPDATEDATE','','','input[text]','',NULL,NULL,'1','0','1','','','','',''),
	('ElectronicContractList','UPDATEUSERID','修改者','0960','O','UPDATEUSERID','','','input[text]','',NULL,NULL,'1','0','1','','','','',''),
	('EmailList','from','发送方','0000','','','','','','',NULL,NULL,'1','0','1','','','','',''),
	('EmailList','receivedDate','接收日期','0030','','','','','','',NULL,NULL,'1','0','1','','','','',''),
	('EmailList','sentDate','发送日期','0020','','','','','','',NULL,NULL,'1','0','1','','','','',''),
	('EmailList','subject','邮件标题','0010','','','','','','',NULL,NULL,'1','0','1','','','','',''),
	('GoodsAccessInfo','DEPOTNAME','仓库名称','0080','O','DEPOTNAME','',NULL,'input[text]','',NULL,NULL,'1','1','1','','','','1','1'),
	('GoodsAccessInfo','DEPOTNO','仓库编号','0070','O','DEPOTNO','',NULL,'input[text]','<input type='button' value='选择仓库' onclick='selectDepot()'/>',NULL,'1','1','1','1','','','','1','1'),
	('GoodsAccessInfo','GOODSCOUNT','货物数量','0040','O','GOODSCOUNT','\d+','必须为整数','input[text]','',NULL,'1','1','0','1','','','','1','1'),
	('GoodsAccessInfo','GOODSNAME','货物名称','0030','O','GOODSNAME','\S+','货物名称不能为空','input[text]','',NULL,NULL,'1','0','1','','','','1','1'),
	('GoodsAccessInfo','INPUTDATE','登记日期','0990','O','INPUTDATE','',NULL,'span','',NULL,NULL,'1','0','1','','','','1','1'),
	('GoodsAccessInfo','INPUTUSERID','登记人','0980','O','INPUTUSERID','',NULL,'input[text]','',NULL,NULL,'0','0','1','','','','1','1'),
	('GoodsAccessInfo','InputUserName','登记人','0985','','','',NULL,'span','',NULL,NULL,'1','0','1','','Java','net.vinote.smart.platform.service.action.UserInfoAction.getUserName(INPUTUSERID)','1','1'),
	('GoodsAccessInfo','PRODUCTNAME','产品类型','0060','O','PRODUCTNAME','',NULL,'input[text]','',NULL,NULL,'1','1','1','','','','1','1'),
	('GoodsAccessInfo','PRODUCTNO','产品编号','0050','O','PRODUCTNO','',NULL,'input[text]','',NULL,NULL,'1','1','1','','','','1','1'),
	('GoodsAccessInfo','SAMPLENO','样品编号','0020','O','SAMPLENO','',NULL,'input[text]','<input type='button' value='选择样品' onclick='selectSample()'/>',NULL,'1','1','1','1','','','','1','1'),
	('GoodsAccessInfo','SERIALNO','出入库流水号','0010','O','SERIALNO','',NULL,'span','',NULL,'0','1','1','1','','','','1','1'),
	('GoodsAccessInfo','STATUS','物流状态','0090','O','STATUS','',NULL,'select','',NULL,'1','1','0','1','','Code','GoodsAccessStatus','1','1'),
	('GoodsAccessInfo','UPDATEDATE','更新日期','0970','O','UPDATEDATE','',NULL,'input[text]','',NULL,NULL,'1','0','0','','','','1','1'),
	('GoodsAccessInfo','UPDATEUSERID','更新人','0190','O','UPDATEUSERID','',NULL,'input[text]','',NULL,NULL,'1','0','0','','','','1','1'),
	('GoodsAccessList','DEPOTNAME','仓库名称','0080','O','DEPOTNAME','','','input[text]','','1',NULL,'1','1','1','','','','1','1'),
	('GoodsAccessList','DEPOTNO','仓库编号','0070','O','DEPOTNO','',NULL,'input[text]','<input type='button' value='选择仓库' onclick='selectDepot()'/>',NULL,'1','1','1','0','','','','1','1'),
	('GoodsAccessList','GOODSCOUNT','货物数量','0040','O','GOODSCOUNT','',NULL,'input[text]','',NULL,'1','1','0','1','','','','1','1'),
	('GoodsAccessList','GOODSNAME','货物名称','0030','O','GOODSNAME','',NULL,'input[text]','',NULL,NULL,'1','0','1','','','','1','1'),
	('GoodsAccessList','INPUTDATE','登记日期','0990','O','INPUTDATE','',NULL,'span','',NULL,NULL,'1','0','1','','','','1','1'),
	('GoodsAccessList','INPUTUSERID','登记人','0980','O','INPUTUSERID','',NULL,'input[text]','',NULL,NULL,'0','0','1','','','','1','1'),
	('GoodsAccessList','InputUserName','登记人','0985','','','',NULL,'span','',NULL,NULL,'1','0','1','','Java','net.vinote.smart.platform.service.action.UserInfoAction.getUserName(INPUTUSERID)','1','1'),
	('GoodsAccessList','PRODUCTNAME','产品类型','0060','O','PRODUCTNAME','','','input[text]','','1',NULL,'1','1','1','','','','1','1'),
	('GoodsAccessList','PRODUCTNO','产品编号','0050','O','PRODUCTNO','',NULL,'input[text]','',NULL,NULL,'1','1','0','','','','1','1'),
	('GoodsAccessList','SAMPLENO','样品编号','0020','O','SAMPLENO','','','input[text]','<input type='button' value='选择样品' onclick='selectSample()'/>','1','1','1','1','1','','','','1','1'),
	('GoodsAccessList','SERIALNO','出入库流水号','0010','O','SERIALNO','',NULL,'span','',NULL,'0','1','1','1','','','','1','1'),
	('GoodsAccessList','STATUS','物流状态','0090','O','STATUS','','','select','','1','1','1','0','1','','Code','GoodsAccessStatus','1','1'),
	('GoodsAccessList','UPDATEDATE','更新日期','0970','O','UPDATEDATE','',NULL,'input[text]','',NULL,NULL,'1','0','0','','','','1','1'),
	('GoodsAccessList','UPDATEUSERID','更新人','0190','O','UPDATEUSERID','',NULL,'input[text]','',NULL,NULL,'1','0','0','','','','1','1'),
	('LayoutCatalogInfo','LayoutID','布局编号','0010','O','LayoutID','',NULL,'input[text]','',NULL,'1','1','0','1','','','','1','1'),
	('LayoutCatalogInfo','LayoutName','布局名称','0020','O','LayoutName','',NULL,'input[text]','',NULL,'1','1','0','1','','','','1','1'),
	('LayoutCatalogInfo','LayoutStyle','布局样式','0030','O','LayoutStyle','',NULL,'select','',NULL,'1','1','0','1','','Code','PageLayout','1','1'),
	('LayoutCatalogInfo','Subject','应用科目','0040','O','Subject','',NULL,'select','',NULL,'1','1','0','1','','Code','AppInfoSubject','',''),
	('LayoutCatalogList','LayoutID','布局编号','0010','O','LayoutID',NULL,NULL,'input[text]','',NULL,NULL,'1','0','1','','','','1','1'),
	('LayoutCatalogList','LayoutName','布局名称','0020','O','LayoutName',NULL,NULL,'input[text]','',NULL,NULL,'1','0','1','','','','1','1'),
	('LayoutCatalogList','LayoutStyle','布局样式','0030','O','LayoutStyle',NULL,NULL,'select','',NULL,NULL,'1','0','1','','Code','PageLayout','1','1'),
	('LayoutItemInfo','LayoutID','布局编号','0010','O','LayoutID',NULL,NULL,'span','',NULL,NULL,'1','1','1','','','','1','1'),
	('LayoutItemInfo','PageID','页面ID','0020','O','PageID',NULL,NULL,'input[text]','',NULL,NULL,'1','0','1','','','','1','1'),
	('LayoutItemInfo','PageURL','页面路径','0040','O','PageURL','','','input[text]','',NULL,NULL,'1','0','1','width:100%','','','1','1'),
	('LayoutItemInfo','Position','布局方位','0050','O','Position',NULL,NULL,'input[text]','',NULL,NULL,'1','0','1','','Code','Region','1','1'),
	('LayoutItemInfo','Size','页面大小','0070','O','Size',NULL,NULL,'input[text]','',NULL,NULL,'1','0','1','','','','1','1'),
	('LayoutItemInfo','Split','分隔符','0080','O','Split','',NULL,'input[radio]','',NULL,NULL,'1','0','1','','Code','YesNo','',''),
	('LayoutItemInfo','Title','页面标题','0030','O','Title',NULL,NULL,'input[text]','',NULL,NULL,'1','0','1','','','','1','1'),
	('LayoutItemInfo','isInUse','是否可用','0060','O','isInUse',NULL,NULL,'input[radio]','',NULL,NULL,'1','0','1','','Code','YesNo','1','1'),
	('LayoutItemList','LayoutID','布局编号','0010','O','LayoutID',NULL,NULL,'input[text]','',NULL,NULL,'1','1','1','','','','1','1'),
	('LayoutItemList','PageID','页面ID','0020','O','PageID',NULL,NULL,'input[text]','',NULL,NULL,'1','1','1','','','','1','1'),
	('LayoutItemList','PageURL','页面路径','0040','O','PageURL',NULL,NULL,'input[text]','',NULL,NULL,'1','1','1','','','','1','1'),
	('LayoutItemList','Position','布局方位','0050','O','Position',NULL,NULL,'input[text]','',NULL,NULL,'1','1','1','','Code','Region','1','1'),
	('LayoutItemList','Size','页面大小','0070','O','Size',NULL,NULL,'','',NULL,NULL,'1','0','1','','','','1','1'),
	('LayoutItemList','Title','页面标题','0030','O','Title',NULL,NULL,'span','',NULL,NULL,'1','1','1','','','','1','1'),
	('LayoutItemList','isInUse','是否可用','0060','O','isInUse',NULL,NULL,'input[text]','',NULL,NULL,'1','1','1','','Code','YesNo','1','1'),
	('LicenseRegistInfo','license','许可证','0030','','','','','input[text]','',NULL,NULL,'1','0','1','','','','',''),
	('LicenseRegistInfo','machineCode','机器码','0010','','','','','span','',NULL,NULL,'1','0','1','','','','',''),
	('LicenseRegistInfo','registDate','注册时间','0020','','','','','span','',NULL,NULL,'1','0','1','','','','',''),
	('NewOnlineList','DOWNCOMMENT','差评','0070','O','DOWNCOMMENT','','','input[text]','',NULL,NULL,'1','0','1','','','','',''),
	('NewOnlineList','INPUTDATE','新增日期','0990','O','INPUTDATE','','','input[text]','',NULL,NULL,'1','0','1','','','','',''),
	('NewOnlineList','INPUTUSERID','新增人员','0980','O','INPUTUSERID','','','input[text]','',NULL,NULL,'1','0','1','','','','',''),
	('NewOnlineList','NEWSCATALOG','类别','0020','O','NEWSCATALOG','','','input[text]','',NULL,NULL,'1','0','1','','Code','NewsCatalog','',''),
	('NewOnlineList','NEWSTITLE','新闻标题','0040','O','NEWSTITLE','','','span','',NULL,NULL,'1','0','1','','','','',''),
	('NewOnlineList','PUBLISHDATE','发布日期','0050','O','PUBLISHDATE','','','input[text]','',NULL,NULL,'1','0','1','','','','',''),
	('NewOnlineList','SERIALNO','新闻编号','0010','O','SERIALNO','','','input[text]','',NULL,NULL,'1','0','1','','','','',''),
	('NewOnlineList','SOURCESITE','来源','0030','O','SOURCESITE','','','input[text]','',NULL,NULL,'1','0','1','','','','',''),
	('NewOnlineList','UPCOMMENT','好评','0060','O','UPCOMMENT','','','input[text]','',NULL,NULL,'1','0','1','','','','',''),
	('NewOnlineList','UPDATEDATE','更新日期','0970','O','UPDATEDATE','','','input[text]','',NULL,NULL,'1','0','1','','','','',''),
	('NewOnlineList','UPDATEUSERID','更新人员','0960','O','UPDATEUSERID','','','input[text]','',NULL,NULL,'1','0','1','','','','',''),
	('NewsDetailInfo','CONTENT','新闻正文','0090','O','CONTENT','','','richTextArea','',NULL,NULL,'1','0','1','height:800px','','','',''),
	('NewsDetailInfo','DOWNCOMMENT','差评','0080','O','DOWNCOMMENT','','','span','',NULL,NULL,'1','0','1','','','','',''),
	('NewsDetailInfo','INPUTDATE','新增日期','0990','O','INPUTDATE','','','span','',NULL,NULL,'1','0','1','','','','',''),
	('NewsDetailInfo','INPUTUSERID','新增人员','0980','O','INPUTUSERID','','','span','',NULL,NULL,'1','0','1','','','','',''),
	('NewsDetailInfo','NEWSCATALOG','新闻类别','0050','O','NEWSCATALOG','','','input[radio]','',NULL,'1','1','0','1','','Code','NewsCatalog','',''),
	('NewsDetailInfo','NEWSTITLE','新闻标题','0020','O','NEWSTITLE','.*','请输入新闻标题','input[text]','',NULL,'1','1','0','1','','','','',''),
	('NewsDetailInfo','PUBLISHDATE','发布日期','0060','O','PUBLISHDATE','','','input[datetime]','',NULL,NULL,'1','0','1','','','','',''),
	('NewsDetailInfo','SERIALNO','新闻编号','0010','O','SERIALNO','','','span','',NULL,NULL,'1','0','1','','','','',''),
	('NewsDetailInfo','SOURCEHREF','来源网址','0040','O','SOURCEHREF','','','input[text]','',NULL,NULL,'1','0','1','width:700px','','','',''),
	('NewsDetailInfo','SOURCESITE','来源站点','0030','O','SOURCESITE','','','input[text]','',NULL,NULL,'1','0','1','width:300px','','','',''),
	('NewsDetailInfo','UPCOMMENT','好评','0070','O','UPCOMMENT','','','span','',NULL,NULL,'1','0','1','','','','',''),
	('NewsDetailInfo','UPDATEDATE','编辑日期','0970','O','UPDATEDATE','','','span','',NULL,NULL,'1','0','1','','','','',''),
	('NewsDetailInfo','UPDATEUSERID','编辑人员','0960','O','UPDATEUSERID','','','span','',NULL,NULL,'1','0','1','','','','',''),
	('OrgDetailInfo','BELONGORGID',NULL,'0001','O','BELONGORGID',NULL,NULL,'input[text]',NULL,NULL,NULL,'1','0','1',NULL,NULL,NULL,'1','1'),
	('OrgDetailInfo','ISINUSE',NULL,'0002','O','ISINUSE',NULL,NULL,'input[text]',NULL,NULL,NULL,'1','0','1',NULL,NULL,NULL,'1','1'),
	('OrgDetailInfo','ORGID',NULL,'0003','O','ORGID',NULL,NULL,'input[text]',NULL,NULL,NULL,'1','0','1',NULL,NULL,NULL,'1','1'),
	('OrgDetailInfo','ORGLEVEL',NULL,'0004','O','ORGLEVEL',NULL,NULL,'input[text]',NULL,NULL,NULL,'1','0','1',NULL,NULL,NULL,'1','1'),
	('OrgDetailInfo','ORGNAME',NULL,'0005','O','ORGNAME',NULL,NULL,'input[text]',NULL,NULL,NULL,'1','0','1',NULL,NULL,NULL,'1','1'),
	('OrgDetailInfo','SORTNO',NULL,'0006','O','SORTNO',NULL,NULL,'input[text]',NULL,NULL,NULL,'1','0','1',NULL,NULL,NULL,'1','1'),
	('ProductItemInfo','INPUTDATE','登记时间','0500','O','INPUTDATE','',NULL,'span','',NULL,NULL,'1','1','1','','','','',''),
	('ProductItemInfo','INPUTUSERID','登记人','0400','O','INPUTUSERID','',NULL,'input[text]','',NULL,NULL,'0','1','1','','','','',''),
	('ProductItemInfo','InputUserName','登记人','0450','','','',NULL,'span','',NULL,NULL,'1','0','1','','Java','net.vinote.smart.platform.service.action.UserInfoAction.getUserName(INPUTUSERID)','',''),
	('ProductItemInfo','PRODUCTNAME','产品名称','0200','O','PRODUCTNAME','',NULL,'input[text]','',NULL,NULL,'1','0','1','','','','',''),
	('ProductItemInfo','PRODUCTNO','产品编号','0100','O','PRODUCTNO','','','span','',NULL,NULL,'1','0','1','','','','1','1'),
	('ProductItemInfo','SORTNO','排序号','0300','O','SORTNO','',NULL,'input[text]','',NULL,NULL,'1','0','1','','','','',''),
	('ProductItemList','INPUTDATE','登记时间','0500','O','INPUTDATE','',NULL,'input[text]','',NULL,NULL,'1','0','1','','','','',''),
	('ProductItemList','INPUTUSERID','登记人','0400','O','INPUTUSERID','',NULL,'input[text]','',NULL,NULL,'0','0','1','','','','',''),
	('ProductItemList','InputUserName','登记人','0450','','','',NULL,'','',NULL,NULL,'1','0','1','','Java','net.vinote.smart.platform.service.action.UserInfoAction.getUserName(INPUTUSERID)','',''),
	('ProductItemList','PRODUCTNAME','产品名称','0200','O','PRODUCTNAME','',NULL,'input[text]','',NULL,NULL,'1','0','1','','','','',''),
	('ProductItemList','PRODUCTNO','产品编号','0100','O','PRODUCTNO','',NULL,'input[text]','',NULL,NULL,'1','0','1','','','','',''),
	('ProductItemList','SORTNO','排序号','0300','O','SORTNO','',NULL,'input[text]','',NULL,NULL,'1','0','1','','','','',''),
	('RoleInfo','AUTHGROUP','权限组','0030','O','AUTHGROUP','','','input[checkbox]','',NULL,NULL,'1','0','1','','Code','AuthGroup','',''),
	('RoleInfo','RoleID','角色编号','0010','O','RoleID',NULL,NULL,'input[text]','',NULL,NULL,'1','0','1','','','','1','1'),
	('RoleInfo','RoleName','角色名称','0020','O','RoleName',NULL,NULL,'input[text]','',NULL,NULL,'1','0','1','','','','1','1'),
	('RoleList','RoleID','角色编号','0010','O','RoleID',NULL,NULL,'input[text]','',NULL,NULL,'1','0','1','','','','1','1'),
	('RoleList','RoleName','角色名称','0020','O','RoleName',NULL,NULL,'input[text]','',NULL,NULL,'1','0','1','','','','1','1'),
	('SampleInfo','CURRENCY','币种','0060','O','CURRENCY','',NULL,'select','',NULL,'1','1','0','1','','Code','Currency','1','1'),
	('SampleInfo','INPUTDATE','登记日期','0990','O','INPUTDATE','',NULL,'span','',NULL,NULL,'1','0','1','','','','1','1'),
	('SampleInfo','INPUTUSERID','登记人','0980','O','INPUTUSERID','',NULL,'input[text]','',NULL,NULL,'0','0','1','','','','1','1'),
	('SampleInfo','InputUserName','登记人','0985','','','',NULL,'span','',NULL,NULL,'1','0','1','','Java','net.vinote.smart.platform.service.action.UserInfoAction.getUserName(INPUTUSERID)','1','1'),
	('SampleInfo','MANUFACTURER','生产厂商','0080','O','MANUFACTURER','',NULL,'input[text]','',NULL,NULL,'1','0','1','width:90%','','','2','1'),
	('SampleInfo','PRODUCTNO','产品类型','0035','O','PRODUCTNO','',NULL,'input[text]','',NULL,NULL,'0','0','1','','','','1','1'),
	('SampleInfo','ProductName','产品类型','0036','','','',NULL,'input[text]','<input type='button' value='选择' onclick='selectProduct();'/>',NULL,NULL,'1','1','1','','Java','net.vinote.smart.platform.service.action.ProductItemAction.getProductName(PRODUCTNO)','1','1'),
	('SampleInfo','SAMPLEIMAGE','样品图片','0020','O','SAMPLEIMAGE','',NULL,'image','',NULL,NULL,'1','0','1','width:80px;height:80px','','','1','2'),
	('SampleInfo','SAMPLENAME','样品名称','0030','O','SAMPLENAME','',NULL,'input[text]','',NULL,'1','1','0','1','','','','1','1'),
	('SampleInfo','SAMPLEPRICE','样品价格','0050','O','SAMPLEPRICE','[1-9]\d*','价格必须大于0','input[text]','',NULL,'1','1','0','1','','','','1','1'),
	('SampleInfo','SAMPLESPECIFICATION','样品规格','0040','O','SAMPLESPECIFICATION','',NULL,'textarea','',NULL,'1','1','0','1','width:80%;height:100px','','','2','1'),
	('SampleInfo','SERIALNO','样品编号','0010','O','SERIALNO','',NULL,'input[text]','',NULL,NULL,'1','1','1','','','','1','1'),
	('SampleInfo','Supplier','供应商','0070','O','SUPPLIER','',NULL,'input[text]','',NULL,NULL,'1','0','1','width:90%','','','2','1'),
	('SampleInfo','UPDATEDATE','更新日期','0970','O','UPDATEDATE','',NULL,'span','',NULL,NULL,'1','0','0','','','','1','1'),
	('SampleInfo','UPDATEUSERID','更新人员','0960','O','UPDATEUSERID','',NULL,'input[text]','',NULL,NULL,'0','0','0','','','','1','1'),
	('SampleInfo','UpdateUserName','更新人员','0965','','','',NULL,'span','',NULL,NULL,'1','0','0','','','com.zjw.platform.service.action.UserInfoAction.getUserName(UPDATEUSERID)','1','1'),
	('SampleList','CURRENCY','币种','0060','O','CURRENCY','','','select','','1',NULL,'1','0','1','','Code','Currency','1','1'),
	('SampleList','INPUTDATE','登记日期','0100','O','INPUTDATE','',NULL,'input[text]','',NULL,NULL,'1','0','1','','','','1','1'),
	('SampleList','INPUTUSERID','登记人','0090','O','INPUTUSERID','','','input[text]','','0',NULL,'0','0','1','','','','1','1'),
	('SampleList','InputUserName','登记人','0095','','','','','','',NULL,NULL,'1','0','1','','Java','net.vinote.smart.platform.service.action.UserInfoAction.getUserName(INPUTUSERID)','1','1'),
	('SampleList','PRODUCTNAME','产品类型','0045','','','',NULL,'','',NULL,NULL,'1','0','1','','Java','net.vinote.smart.platform.service.action.ProductItemAction.getProductName(PRODUCTNO)','1','1'),
	('SampleList','PRODUCTNO','产品类型','0040','O','PRODUCTNO','',NULL,'','',NULL,NULL,'0','0','1','','','','1','1'),
	('SampleList','SAMPLEIMAGE','样品图片','0040','O','SAMPLEIMAGE','',NULL,'image','',NULL,NULL,'1','0','0','','','','1','1'),
	('SampleList','SAMPLENAME','样品名称','0020','O','SAMPLENAME','',NULL,'input[text]','',NULL,NULL,'1','0','1','','','','1','1'),
	('SampleList','SAMPLEPRICE','样品价格','0050','O','SAMPLEPRICE','',NULL,'input[text]','',NULL,NULL,'1','0','1','','','','1','1'),
	('SampleList','SAMPLESPECIFICATION','样品规格','0030','O','SAMPLESPECIFICATION','',NULL,'input[text]','',NULL,NULL,'1','0','1','','','','1','1'),
	('SampleList','SERIALNO','样品编号','0010','O','SERIALNO','',NULL,'input[text]','',NULL,NULL,'1','0','1','','','','1','1'),
	('SampleList','UPDATEDATE','更新日期','0080','O','UPDATEDATE','',NULL,'input[text]','',NULL,NULL,'1','0','0','','','','1','1'),
	('SampleList','UPDATEUSERID','更新人员','0070','O','UPDATEUSERID','',NULL,'input[text]','',NULL,NULL,'1','0','0','','','','1','1'),
	('ServiceContractList','ID','合同编号','0030','O','ID','','','input[text]','','1',NULL,'1','0','1','','','','',''),
	('ServiceContractList','INPUTDATE','创建时间','0990','O','INPUTDATE','','','input[text]','',NULL,NULL,'1','0','1','','','','',''),
	('ServiceContractList','INPUTUSERID','创建者','0980','O','INPUTUSERID','','','input[text]','',NULL,NULL,'1','0','1','','','','',''),
	('ServiceContractList','OBJECTID','关联对象ID','0060','O','OBJECTID','','','input[text]','',NULL,NULL,'0','0','1','','','','',''),
	('ServiceContractList','OBJECTTYPE','关联对象类型','0070','O','OBJECTTYPE','','','input[text]','',NULL,NULL,'0','0','1','','','','',''),
	('ServiceContractList','TEMPLATEID','合同模板编号','0080','O','TEMPLATEID',NULL,NULL,'input[text]',NULL,NULL,NULL,'1','0','1',NULL,NULL,NULL,NULL,NULL),
	('ServiceContractList','TITLE','合同标题','0030','CT','TITLE','','','input[text]','','1',NULL,'1','0','1','','','','',''),
	('ServiceContractList','UPDATEDATE','修改时间','0970','O','UPDATEDATE','','','input[text]','',NULL,NULL,'1','0','1','','','','',''),
	('ServiceContractList','UPDATEUSERID','修改者','0960','O','UPDATEUSERID','','','input[text]','',NULL,NULL,'1','0','1','','','','',''),
	('SystemParamInfo','RULE','正则校验规则','0040','O','RULE',NULL,NULL,'input[text]','','0',NULL,'1','0','1','','','','1','1'),
	('SystemParamInfo','paramName','参数名称','0010','O','ParamName',NULL,NULL,'input[text]','',NULL,NULL,'1','0','1','','','','1','1'),
	('SystemParamInfo','paramValue','参数值','0020','O','ParamValue',NULL,NULL,'input[text]','',NULL,NULL,'1','0','1','','','','1','1'),
	('SystemParamInfo','remark','参数描述','0030','O','Remark','',NULL,'textarea','',NULL,NULL,'1','0','1','height:80px;width:450px;',' ','','1','1'),
	('SystemParamList','paramName','参数名称','0010','O','ParamName',NULL,NULL,'input[text]','',NULL,NULL,'1','0','1','','','','1','1'),
	('SystemParamList','paramValue','参数值','0020','O','ParamValue',NULL,NULL,'input[text]','',NULL,NULL,'1','0','1','','','','1','1'),
	('SystemParamList','remark','参数描述','0030','O','Remark',NULL,NULL,'textarea','',NULL,NULL,'1','0','1','','','','1','1'),
	('TableObjectColumnList','COLREMARK','备注','0030','O','COLREMARK',NULL,NULL,'input[text]','',NULL,NULL,'1','0','1','','','','1','1'),
	('TableObjectColumnList','DATATYPE','数据类型','0040','O','DATATYPE',NULL,NULL,'select','',NULL,NULL,'1','0','1','','Code','DataType','1','1'),
	('TableObjectColumnList','FieldName','字段名','0020','O','FieldName',NULL,NULL,'input[text]','',NULL,NULL,'1','0','1','','','','1','1'),
	('TableObjectColumnList','IsKey','是否主键','0060','O','IsKey',NULL,NULL,'input[radio]','',NULL,NULL,'1','0','1','','Code','YesNo','1','1'),
	('TableObjectColumnList','SORTNO','排序号','0050','O','SORTNO',NULL,NULL,'input[text]','',NULL,NULL,'1','0','1','','','','1','1'),
	('TableObjectColumnList','TableName','表名','0010','O','TableName',NULL,NULL,'input[text]','',NULL,NULL,'1','0','1','','','','1','1'),
	('TableObjectInfo','COLREMARK','备注','0030','O','COLREMARK','',NULL,'input[text]','',NULL,'1','1','0','1','','','','1','1'),
	('TableObjectInfo','DATATYPE','数据类型','0040','O','DATATYPE','',NULL,'select','',NULL,'1','1','0','1','width:90px','Code','DataType','1','1'),
	('TableObjectInfo','FieldName','字段名','0020','O','FieldName','',NULL,'input[text]','',NULL,'1','1','0','1','','','','1','1'),
	('TableObjectInfo','IsKey','是否主键','0060','O','IsKey','',NULL,'input[radio]','',NULL,'1','1','0','1','','Code','YesNo','1','1'),
	('TableObjectInfo','SORTNO','排序号','0050','O','SORTNO','',NULL,'input[text]','',NULL,'1','1','0','1','','','','1','1'),
	('TableObjectInfo','TableName','表名','0010','O','TableName',NULL,NULL,'input[text]','',NULL,NULL,'1','0','1','','','','1','1'),
	('TableObjectList','FieldNum','字段总数','0040','F','count(*)','','','input[text]','','1',NULL,'1','0','1','','','','1','1'),
	('TableObjectList','TableName','表名','0010','O','TableName','','','input[text]','','1',NULL,'1','0','1','','','','1','1'),
	('TimerTaskInfo','AUTOSTART','是否自启动','0085','O','AUTOSTART','','','input[radio]','',NULL,NULL,'1','0','1','','Code','YesNo','1',''),
	('TimerTaskInfo','FINISHTIME','终止时间','0050','O','FINISHTIME','','','input[datetime]','',NULL,'0','1','0','1','','','','1',''),
	('TimerTaskInfo','ID','定时任务ID','0010','O','ID','','','span','',NULL,NULL,'1','0','1','','','','1',''),
	('TimerTaskInfo','INPUTDATE','登记日期','0990','O','INPUTDATE','','','span','',NULL,NULL,'1','0','1','','','','',''),
	('TimerTaskInfo','INPUTUSERID','登记者','0980','O','INPUTUSERID','','','span','',NULL,NULL,'1','0','1','','','','1','1'),
	('TimerTaskInfo','ISINUSE','是否可用','0080','O','ISINUSE','','','input[radio]','',NULL,NULL,'1','0','1','','Code','YesNo','',''),
	('TimerTaskInfo','PERIOD','执行频率','0060','O','PERIOD','','','input[text]','',NULL,'1','1','0','1','','','','1',''),
	('TimerTaskInfo','PERIODTYPE','频率类型','0070','O','PERIODTYPE','','','select','',NULL,'1','1','0','1','','JsonArray','PeriodJsonArray','0',''),
	('TimerTaskInfo','STARTTIME','启动时间','0040','O','STARTTIME','','','input[datetime]','',NULL,'0','1','0','1','','','','1',''),
	('TimerTaskInfo','Status','状态','0075','','','','','span','',NULL,NULL,'1','0','1','','','','1',''),
	('TimerTaskInfo','TITLE','定时任务标题','0020','O','TITLE','','','input[text]','',NULL,'1','1','0','1','','','','',''),
	('TimerTaskInfo','TRIGGERCLASS','定时任务触发类','0090','O','TRIGGERCLASS','','','input[text]','<input type='button' value='选择定时任务' onclick='selectTask()'/>',NULL,'1','1','1','1','width:80%','Code','TimerTaskClass','2',''),
	('TimerTaskInfo','UPDATEDATE','修改日期','0970','O','UPDATEDATE','','','span','',NULL,NULL,'1','0','1','','','','',''),
	('TimerTaskInfo','UPDATEUSERID','修改者','0960','O','UPDATEUSERID','','','span','',NULL,NULL,'1','0','1','','','','',''),
	('TimerTaskList','AUTOSTART','是否自启动','0080','O','AUTOSTART','','','input[radio]','',NULL,NULL,'1','0','1','','Code','YesNo','',''),
	('TimerTaskList','FINISHTIME','终止时间','0040','O','FINISHTIME','','','input[datetime]','',NULL,NULL,'1','0','1','','','','',''),
	('TimerTaskList','ID','定时任务ID','0010','O','ID',NULL,NULL,'input[text]',NULL,NULL,NULL,'1','0','1',NULL,NULL,NULL,NULL,NULL),
	('TimerTaskList','INPUTDATE','登记日期','0990','O','INPUTDATE','','','input[text]','',NULL,NULL,'1','0','1','','','','',''),
	('TimerTaskList','INPUTUSERID','登记者','0980','O','INPUTUSERID','','','input[text]','',NULL,NULL,'1','0','1','','','','',''),
	('TimerTaskList','ISINUSE','是否可用','0070','O','ISINUSE','','','input[radio]','',NULL,NULL,'1','0','1','','Code','YesNo','',''),
	('TimerTaskList','PERIOD','执行频率','0050','O','PERIOD','','','input[text]','',NULL,NULL,'1','0','1','','','','',''),
	('TimerTaskList','PERIODTYPE','频率类型','0060','O','PERIODTYPE','','','','',NULL,NULL,'1','0','1','','JsonArray','PeriodJsonArray','',''),
	('TimerTaskList','STARTTIME','启动时间','0030','O','STARTTIME','','','input[text]','',NULL,NULL,'1','0','1','','','','',''),
	('TimerTaskList','Status','状态','0025','','','','','span','',NULL,NULL,'1','0','1','','','','',''),
	('TimerTaskList','TITLE','定时任务标题','0020','O','TITLE','','','input[text]','',NULL,NULL,'1','0','1','','','','',''),
	('TimerTaskList','UPDATEDATE','修改日期','0970','O','UPDATEDATE','','','input[text]','',NULL,NULL,'1','0','1','','','','',''),
	('TimerTaskList','UPDATEUSERID','修改者','0960','O','UPDATEUSERID','','','input[text]','',NULL,NULL,'1','0','1','','','','',''),
	('TreeSQLInfo','attrs','节点属性','0040','','','','','','',NULL,NULL,'1','0','1','','','','',''),
	('TreeSQLInfo','id','树节点ID','0020','','','','','input[text]','',NULL,NULL,'1','0','1','','','','',''),
	('TreeSQLInfo','show','显示文案','0030','','','','','input[text]','',NULL,NULL,'1','0','1','','','','',''),
	('TreeSQLInfo','sql','SQL语句','0050','','','','','input[text]','',NULL,NULL,'1','0','1','width:90%','','','2',''),
	('TreeSQLInfo','treeCode','树图代码','0010','','','','','input[text]','',NULL,NULL,'1','0','1','','','','',''),
	('UserInfo','CONFIG','配置信息','0050','O','CONFIG','','','textarea','',NULL,NULL,'1','0','1','width:100%','','','2',''),
	('UserInfo','OrgID','所属机构','0040','O','OrgID',NULL,NULL,'input[text]','',NULL,NULL,'1','0','1','','','','1','1'),
	('UserInfo','Password','密码','0030','O','Password',NULL,NULL,'input[password]','',NULL,NULL,'1','0','1','','','','1','1'),
	('UserInfo','UserID','用户编号','0010','O','UserID',NULL,NULL,'input[text]','',NULL,NULL,'1','0','1','','','','1','1'),
	('UserInfo','UserName','用户名','0020','O','UserName',NULL,NULL,'input[text]','',NULL,NULL,'1','0','1','','','','1','1'),
	('UserInfoEdit','UserID','用户编号','0010','O','UserID',NULL,NULL,'span','',NULL,NULL,'1','0','1','','','','1','1'),
	('UserInfoEdit','UserName','用户名','0020','O','UserName',NULL,NULL,'input[text]','',NULL,NULL,'1','0','1','','','','1','1'),
	('UserList','OrgID','所属机构','0030','O','OrgID','','','input[text]','','1',NULL,'1','0','1','','','','1','1'),
	('UserList','UserID','用户编号','0010','O','UserID','','','input[text]','','1',NULL,'1','0','1','','','','1','1'),
	('UserList','UserName','用户名','0020','O','UserName','','','input[text]','','1',NULL,'1','0','1','','','','1','1'),
	('UserPasswordChange','Password','密码','0030','O','Password',NULL,NULL,'input[password]','',NULL,NULL,'1','0','1','','','','1','1'),
	('UserPasswordChange','UserID','用户编号','0010','O','UserID',NULL,NULL,'span','',NULL,NULL,'1','0','1','','','','1','1'),
	('UserPasswordChange','oldPassword','旧密码','0020','','',NULL,NULL,'input[password]','',NULL,NULL,'1','0','1','','','','1','1');

/*!40000 ALTER TABLE `dataobject_library` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table datawindow_page
# ------------------------------------------------------------

DROP TABLE IF EXISTS `datawindow_page`;

CREATE TABLE `datawindow_page` (
  `PagePath` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '页面路径',
  `PageName` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '页面名称',
  `PageType` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '页面类型',
  `DONO` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '显示模板编号',
  `displayStyle` varchar(16) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '显示风格',
  `dwParam` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '显示模板参数',
  `buttons` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '按钮组',
  `script` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT '按钮组',
  `DatagridEvent` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '数据列表事件',
  `DatagridScript` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '列表事件脚本',
  PRIMARY KEY (`PagePath`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

LOCK TABLES `datawindow_page` WRITE;
/*!40000 ALTER TABLE `datawindow_page` DISABLE KEYS */;

INSERT INTO `datawindow_page` (`PagePath`, `PageName`, `PageType`, `DONO`, `displayStyle`, `dwParam`, `buttons`, `script`, `DatagridEvent`, `DatagridScript`)
VALUES
	('customer.contactbook_info.page','通讯录详情','Service','ContactBookInfo','Info','serialNo','doSave','function doSave(){
DWControl.save();
}',NULL,''),
	('customer.contactbook_list.page','通讯录列表','Service','ContactBookList','List','customerID','doAdd,doDelete,doEdit','function doAdd(){
DWControl.OpenDwWindow({"page":"customer.contactbook_info.page",'title':'新增通讯录',"param":'customerID=${customerID}'},function(){reloadSelf();});
}

function doEdit(){
    var serialNo=getItemValue('#ContactBookList','SerialNO');
    if (serialNo== null) {
        alert("请选择一条记录!");
        return;
    }
DWControl.OpenDwWindow({"page":"customer.contactbook_info.page",'title':'新增通讯录',"param":'serialNo='+serialNo},function(){reloadSelf();});
}

function doDelete(){
    var sReturn=DWControl.Delete('#ContactBookList');
    if(sReturn!=null&&sReturn.length>0){
        reloadSelf();
    }
}','onDblClickRow','doEdit()'),
	('customer.customer_info.page','客户信息详情','Service','CustomerInfo','Info','customerID','doSave,exportExcel','function doSave() {
    DWControl.save(); 
}

function exportExcel(){
DWControl.exportExcel();
}',NULL,'doEdit()'),
	('customer.customer_list.page','客户信息列表','Service','CustomerList','List','inputUserID','doAdd,doDelete,doEdit,exportExcel','function doAdd() {
    var sReturn=DWControl.OpenDwWindow({"id":"customer_info", "title":"客户信息详情","page":"customer.customer_info.page","width":'90%',"height":'80%'},function(){ reloadSelf();});
}
	
function doEdit(){
    var customerID = getItemValue("#CustomerList", "CustomerID");
    if (customerID == null) {
        alert("请选择一条记录!");
        return;
    }
var sReturn=DWControl.Window({'id':'CustomerInfoTreePage',"title":"客户信息详情",'href':'frame/layout.jsp','param':'LayoutID=CustomerInfoTree&customerID='+ customerID+'&objectId='+customerID,"width":'90%',"height":'80%'},function(){reloadSelf('#CustomerList');});
}

function doView(){
    var customerID = getItemValue("dwForm", "CustomerID");
    if (customerID == null) {
        alert("请选择一条记录!");
        return;
    }
    var sReturn=DWControl.OpenDwWindow("customer_info", "客户信息详情","customer.customer_info.page","ReadOnly=true&customerID=" + customerID,function(){ reloadSelf();});
}

	
function doDelete(){
    var sReturn=DWControl.Delete('dwForm');
    if(sReturn!=null&&sReturn.length>0){
        reloadSelf();
    }
}

function exportExcel(){
DWControl.exportExcel();
}','onDblClickRow','doEdit()'),
	('customer.news_online_list.page','在线新闻列表','Service','NewOnlineList','List','','doAdd,doDelete,doEdit,publish','function doAdd() {
    var sReturn=DWControl.OpenDwWindow({"id":"news_info", "title":"新增新闻信息","page":"service.news_detail_info.page"},function(){ reloadSelf();});
}
	

function doEdit(){
  var SerialNo= getItemValue("dwForm", "SerialNo");
   if (SerialNo== null) {
	alert("请选择一条记录!");
	return;
   }
DWControl.OpenDwWindow({page:"service.news_detail_info.page",param:"SerialNo="+SerialNo,title:'新闻详情信息'},function(){reloadSelf();});
}
	
function doDelete(){
    var sReturn=DWControl.Delete('dwForm');
    if(sReturn!=null&&sReturn.length>0){
        reloadSelf();
    }
}

function publish(){
var SerialNo= getItemValue("dwForm", "SerialNo");
   if (SerialNo== null) {
	alert("请选择一条记录!");
	return;
   }
var sReturn=RunJavaMethod("platform.newsInfoAction", "publishNews", {serialNo:SerialNo},true);
if("SUCCESS"==sReturn['result']){
alert("发布成功");
 reloadSelf();
}else{
alert(sReturn['comment']);
}
}','onDblClickRow','doEdit()'),
	('service.attendance_list.page','考勤列表','Service','AttendanceList','List','',NULL,'',NULL,''),
	('service.contract_template_info.page','电子合同模板详情','Service','ContractTemplateInfo','Info','id','doSave','function doSave(){
DWControl.save();
}
$(function(){
 CKEDITOR.replace("CONTENT", { 
    toolbar: [ 
     ['Source','-','NewPage','Preview','-'], 
  ['Cut','Copy','Paste','PasteText','PasteFromWord','-','Print', 'SpellChecker', 'Scayt'], 
  ['Undo','Redo','-','Find','Replace','-','SelectAll','RemoveFormat'], 
  [ 'Checkbox', 'Radio', 'TextField', 'Textarea', 'Select', 'Button', 'ImageButton', 'HiddenField'], 
  '/', 
  ['Bold','Italic','Underline','Strike','-','Subscript','Superscript'], 
  ['NumberedList','BulletedList','-','Outdent','Indent','Blockquote'], 
  ['JustifyLeft','JustifyCenter','JustifyRight','JustifyBlock'], 
  ['Link','Unlink','Anchor'], 
  ['Image','Flash','Table','HorizontalRule','Smiley','SpecialChar','PageBreak'], 
  '/', 
  ['Styles','Format','Font','FontSize'], 
  ['TextColor','BGColor'], 
  ['Maximize', 'ShowBlocks','-','About'] 
    ] 
   }); 

});',NULL,''),
	('service.contract_template_list.page','电子合同模板列表','System','ContractTemplateList','List','','doAdd,doDelete,doEdit','function doAdd() {
DWControl.OpenDwWindow({'id':'ContractTemplateInfoPage',"title":"新增合同模板",'page':'service.contract_template_info.page'},function(){reloadSelf();});
}
	
function doEdit(){
    var id = getItemValue("dwForm", "ID");
    if (id == null) {
        alert("请选择一条记录!");
        return;
    }
DWControl.OpenDwWindow({'id':'ContractTemplateInfoPage',"title":"修改合同模板",'page':'service.contract_template_info.page',param:"id="+id},function(){reloadSelf();});
}
	
function doDelete(){
 DWControl.Delete();
    reloadSelf();
}','onDblClickRow','doEdit()'),
	('service.electronic_contract_list.page','电子合同列表','Service','ElectronicContractList','List','','doAdd,doDelete,doEdit','function doAdd(sReturn){
if(!sReturn){
   DWControl.PopSelectort('ContractTemplateList','',false,'id,title','doAdd');
   return;
}
if(sReturn['id']&&confirm("确定创建合同："+sReturn['title']+"吗?")){
sReturn=RunJavaMethod("platform.electronicContractAction", "doAdd", {templateId:sReturn['id']},true);
if(sReturn&&sReturn['success']){
DWControl.Window({'href':'contract_info.html','param':'id='+sReturn['id'],'title':'编辑合同'},function(){reloadSelf()});
}else{
alert("创建合同失败!");
}
}
}

function doDelete(){
DWControl.Delete();
reloadSelf();
}

function doEdit(){
    var id= getItemValue("dwForm", "ID");
    if (id== null) {
        alert("请选择一条记录!");
        return;
    }
DWControl.Window({'href':'contract_info.html','param':'id='+id,'title':'编辑合同'},function(){reloadSelf()});
}','onDblClickRow','doEdit()'),
	('service.electronic_service_contract_list.page','业务合同列表','Service','ServiceContractList','List','objectType,objectId','doAdd,doDelete,doEdit','function doAdd(sReturn){
if(!sReturn){
   DWControl.PopSelectort('ContractTemplateList','',false,'id,title','doAdd');
   return;
}
if(sReturn['id']&&confirm("确定创建合同："+sReturn['title']+"吗?")){
sReturn=RunJavaMethod("platform.electronicContractAction", "doAdd", {templateId:sReturn['id'],'objectId':'${objectId}','objectType':'${objectType}'},true);
if(sReturn&&sReturn['success']){
DWControl.Window({'href':'contract_info.html','param':'id='+sReturn['id'],'title':'编辑合同'},function(){reloadSelf()});
}else{
alert("创建合同失败!");
}
}
}

function doDelete(){
DWControl.Delete();
reloadSelf();
}

function doEdit(){
    var id= getItemValue("dwForm", "ID");
    if (id== null) {
        alert("请选择一条记录!");
        return;
    }
DWControl.Window({'href':'contract_info.html','param':'id='+id,'title':'编辑合同'},function(){reloadSelf()});
}','onDblClickRow','doEdit()'),
	('service.good_access_info.page','货物出入库列表','Service','GoodsAccessInfo','Info','SerialNo','doSave','function doSave(){
  var sReturn=DWControl.save();
  if("SUCCESS"==sReturn){
        self.returnValue="SUCCESS";
  }
}

function doClose(){
   self.close();
}

function selectSample(){
var sReturn=DWControl.PopSelectort("SampleList",'',false,"SerialNO,SampleName,ProductNo,ProductName","selectSampleCallback");
}
function selectSampleCallback(data){
 if(data==undefined){
    return;
   }else if("_CLEAR_"==data){
setItemValue('dwForm','SampleNO','');   
 setItemValue('dwForm','GOODSNAME','');   
 setItemValue('dwForm','ProductNo',''); 
 setItemValue('dwForm','ProductName',''); 
   }else{
 setItemValue('dwForm','SampleNO',data['SerialNO']);   
 setItemValue('dwForm','GOODSNAME',data['SampleName']);   
 setItemValue('dwForm','ProductNo',data['ProductNo']); 
 setItemValue('dwForm','ProductName',data['ProductName']); 
   }
}
function selectDepot(){
DWControl.PopSelectort("DepotList",'',false,"DEPOTNO,DEPOTNAME","selectDepotCallBack");
}
/**仓库选则事件回调*/
function selectDepotCallBack(data){
if(data==undefined){
    return;
   }else if("_CLEAR_"==data){
setItemValue('dwForm','DEPOTNO','');   
setItemValue('dwForm','DEPOTNAME','');
   }else{
 setItemValue('dwForm','DEPOTNO',data['DEPOTNO']);
 setItemValue('dwForm','DEPOTNAME',data['DEPOTNAME']);
   }
}',NULL,''),
	('service.good_access_list.page','货物出入库列表','Service','GoodsAccessList','List','inputUserID','doAdd,doDelete,doEdit,exportExcel','function doAdd(){
DWControl.OpenDwWindow({page:"service.good_access_info.page",title:'货物出入库详情信息'},function(){reloadSelf();});
}

function doDelete(){
    DWControl.Delete();
    reloadSelf();
}

function doEdit(){
  var SerialNo= getItemValue("dwForm", "SerialNo");
   if (SerialNo== null) {
	alert("请选择一条记录!");
	return;
   }
DWControl.OpenDwWindow({page:"service.good_access_info.page",param:"SerialNo="+SerialNo,title:'货物出入库详情信息'},function(){reloadSelf();});
}

function exportExcel(){
DWControl.exportExcel();
}','onDblClickRow','doEdit()'),
	('service.news_detail_info.page','新闻详情','Service','NewsDetailInfo','Info','SerialNo','doSave','function doSave() {
    var sReturn=DWControl.save();
}',NULL,''),
	('service.sample_info.page','样品列表详情','Service','SampleInfo','Info','SerialNo','doSave','function doSave(){
  var sReturn=DWControl.save();
}

function doClose(){
   self.close();
}

function selectProduct(sReturn){
if(!sReturn){
DWControl.PopTreeSelectort("ProductSelect",false,"ProductName,ProductNo","selectProduct");
return;
}
        if(!sReturn){
        return;
        }
        if('_CLEAR_'==sReturn){
            setItemValue('dwForm','ProductName','');
            setItemValue('dwForm','ProductNo','');
        }else{
            setItemValue('dwForm','ProductName',sReturn['ProductName']);
            setItemValue('dwForm','ProductNo',sReturn['ProductNo']);
        }
    
}',NULL,''),
	('service.sample_list.page','样品列表','Service','SampleList','List','','doAdd,doDelete,doEdit,exportExcel','function doAdd(){
DWControl.OpenDwWindow({page:"service.sample_info.page",title:'样品详情信息'},function(){reloadSelf();});
   // DWControl.PopDwComp("service.sample_info.page","","");
    reloadSelf();
}

function doDelete(){
    DWControl.Delete();
    reloadSelf();
}

function doEdit(){
  var SerialNo= getItemValue("dwForm", "SerialNo");
   if (SerialNo== null) {
	alert("请选择一条记录!");
	return;
   }
DWControl.OpenDwWindow({page:"service.sample_info.page",param:"SerialNo="+SerialNo,title:'样品详情信息'},function(){reloadSelf();});
//    DWControl.PopDwComp("service.sample_info.page","SerialNo="+SerialNo,"");  
    reloadSelf();
}
function exportExcel(){
DWControl.exportExcel();
}','onDblClickRow','doEdit()'),
	('system.app_detail_info.jsp','应用系统详情','System','AppDetailInfo','Info','appID','doSave','function doClose() {
    self.close();
}
	
function doSave() {
    var sReturn=DWControl.save();
    if(!sReturn){
        return;
    }
    if(sReturn!='SUCCESS'){
        alert(sReturn);
        return;
    }
    self.returnValue=sReturn;
    self.close();
}',NULL,''),
	('system.app_info_list.jsp','子系统信息列表','System','AppInfoList','List','subject','doAdd,doDelete,doEdit,editAppItem,roleManager','function doAdd() {
DWControl.OpenDwWindow({'id':'ColumnDetailInfoPage',"title":"新增子系统",'page':'system.app_detail_info.jsp','param':"subject=${subject}","width":800,"height":400},function(){reloadSelf();});
}
	
function doEdit() {
    var appID = getItemValue("dwForm", "APPID");
    if (appID == null) {
        alert("请选择一条记录!");
        return;
    }
DWControl.OpenDwWindow({'id':'ColumnDetailInfoPage',"title":"新增子系统",'page':'system.app_detail_info.jsp','param':"appID=" + appID,"width":800,"height":400},function(){reloadSelf();});
}
	
function editAppItem() {
    var appID = getItemValue("dwForm", "APPID");
    if (appID == null) {
        alert("请选择一条记录!");
        return;
    }
    DWControl.OpenDwWindow({page:"system.app_item_list.jsp",param:"appID=" + appID,title:'子系统信息列表'});
}
	
function doDelete(){
    var appID = getItemValue("dwForm", "APPID");
    if (appID == null) {
        alert("请选择一条记录!");
        return;
    }
    if(confirm("确定删除子系统:"+getItemValue("dwForm", "APPNAME")+" 吗?")){
        var sReturn=RunJavaMethodTrans("platform.appInfoAction","deleteAppInfo",{appID:appID});
        if("SUCCESS"!=sReturn){
            alert("删除失败!");
        }else{
            reloadSelf();
        }
    }
}
	
function roleManager(){
    var appID = getItemValue("dwForm", "APPID");
    if (appID == null) {
        alert("请选择一条记录!");
        return;
    }
DWControl.Window({'id':'ColumnDetailInfoPage',"title":"权限管理",'href':'system/role_rela_manage.jsp','param':"ObjectType=AppInfo&ObjectID=" + appID,"width":'50%',"height":'50%'});
//    var sReturn=DWControl.PopComp("system/role_rela_manage.jsp","ObjectType=AppInfo&ObjectID=" + appID,"dialogWidth=600px;dialogHeight=400px;resizable=no;maximize:no;help:no;status:no;");
//    if(sReturn=='SUCCESS'){
 //       alert("更新成功!");
  //      reloadSelf();
   // }
}','onDblClickRow','editAppItem()'),
	('system.app_item_info.jsp','应用栏目详情','System','AppItemInfo','Info','appID,itemID','doSave','function doSave(){
    var sReturn= DWControl.save();
}
	
function doClose() {
	self.close();
}',NULL,''),
	('system.app_item_list.jsp','应用栏目列表','System','AppItemList','List','appID','doAdd,doDelete,doEdit,roleManager','function doAdd() {
DWControl.OpenDwWindow({'id':'ColumnDetailInfoPage',"title":"新增子系统",'page':'system.app_item_info.jsp','param':"appID=${appID}",'width':850,'height':400},function(){reloadSelf();});
//    DWControl.PopDwComp("system.app_item_info.jsp","appID=${appID}","dialogWidth=850px;dialogHeight=400px;resizable=no;maximize:no;help:no;status:no;");
 //   reloadSelf();
}
	
function doEdit(){
    var itemID = getItemValue("dwForm", "ITEMID");
    if (itemID == null) {
        alert("请选择一条记录!");
        return;
    }
DWControl.OpenDwWindow({'id':'ColumnDetailInfoPage',"title":"编辑子系统",'page':'system.app_item_info.jsp','param':"appID=${appID}&itemID=" + itemID,'width':850,'height':400},function(){reloadSelf();});
    //var sReturn=DWControl.PopDwComp("system.app_item_info.jsp", "appID=${appID}&itemID=" + itemID,"dialogWidth=850px;dialogHeight=400px;resizable=yes;maximize:yes;help:no;status:no;");
    //var sReturn=DWControl.OpenDwWindow({id:'appitemlist',title:'应用栏目列表',page:"system.app_item_info.jsp", param:"appID=${appID}&itemID=" + itemID});
    //reloadSelf();
}
	
function doDelete(){
 DWControl.Delete('dwForm');
 reloadSelf();
}
	

function roleManager(){
    var itemID = getItemValue("dwForm", "ITEMID");
    if (itemID == null) {
        alert("请选择一条记录!");
        return;
    }
DWControl.Window({'id':'ColumnDetailInfoPage',"title":"权限管理",'href':'system/role_rela_manage.jsp','param':"ObjectType=AppItem&ObjectID=" + itemID,'width':600,'height':400},function(){reloadSelf();});

}

function doReturn(){
    history.go(-1);
}','onDblClickRow','doEdit()'),
	('system.attachment_list.page','附件列表','System','AttachmentList','List','objectType,objectNo','doAdd,doDelete,doEdit','','onDblClickRow','doEdit()'),
	('system.code_catalog_bytype_list.page','代码目录列表','System','CodeCatalogListByType','List','codeType','doAdd,doDelete,doEdit,editCodeItem','/**新增代码*/
function doAdd() {
    DWControl.OpenDwWindow({'id':'CodeCatalogInfoPage',"title":"新增代码",'page':'system.code_catalog_info.jsp',"width":600,"height":400},function(){reloadSelf();});	
}
	
/**编辑代码*/
function doEdit() {
     var codeNo = getItemValue("dwForm", "CODENO");
     if (codeNo == null) {
	AWE.Alert("请选择一条记录!");
	return;
     }
DWControl.OpenDwWindow({'id':'CodeCatalogInfoPage',"title":"新增代码",'page':'system.code_catalog_info.jsp',param:"codeNo=" + codeNo,"width":600,"height":400},function(){reloadSelf();});
}
	
/**编辑代码栏目*/
function editCodeItem() {
     var codeNo = getItemValue("dwForm", "CODENO");
     if (codeNo == null) {
	alert("请选择一条记录!");
	return;
     }
DWControl.OpenDwWindow({'id':'CodeCatalogInfoPage',"title":"代码栏目维护",'page':'system.code_library_list.jsp',param:"codeNo=" + codeNo});
//     DWControl.OpenDwComp("system.code_library_list.jsp", "codeNo=" + codeNo);
}
	
function doDelete(){
DWControl.Delete('dwForm');
reloadSelf();
}','onDblClickRow','editCodeItem()'),
	('system.code_catalog_info.jsp','代码科目详情页面','System','CodeCatalogInfo','Info','codeNo','doSave','function doSave(){
    var sReturn=DWControl.save();
    if(sReturn=="SUCCESS"){
        self.returnValue='SUCCESS';
        self.close();
    }
}
',NULL,''),
	('system.code_catalog_list.jsp','代码科目列表','System','CodeCatalogList','List','','doAdd,doDelete,doEdit,editCodeItem','/**新增代码*/
function doAdd() {
     var sReturn=DWControl.PopDwComp("system.code_catalog_info.jsp","","dialogWidth=600px;dialogHeight=400px;resizable=no;maximize:no;help:no;status:no;");
     if(sReturn=="SUCCESS"){
	alert("添加成功!");
	reloadSelf();
    }	
}
	
/**编辑代码*/
function doEdit() {
     var codeNo = getItemValue("dwForm", "CODENO");
     if (codeNo == null) {
	AWE.Alert("请选择一条记录!");
	return;
     }
     var sReturn=DWControl.PopDwComp("system.code_catalog_info.jsp","codeNo=" + codeNo,"dialogWidth=600px;dialogHeight=400px;resizable=no;maximize:no;help:no;status:no;");
     if(sReturn=="SUCCESS"){
	reloadSelf();
     }	
}
	
/**编辑代码栏目*/
function editCodeItem() {
     var codeNo = getItemValue("dwForm", "CODENO");
     if (codeNo == null) {
	alert("请选择一条记录!");
	return;
     }
     DWControl.OpenDwComp("system.code_library_list.jsp", "codeNo=" + codeNo);
}
	
function doDelete(){
     var codeNo = getItemValue("dwForm", "CODENO");
     if (codeNo == null) {
	alert("请选择一条记录!");
	return;
     }
     if(confirm("是否删除代码:"+getItemValue("dwForm", "CODENAME"))){
	var sReturn=RunJavaMethodTrans("com.zjw.sys.action.CodeLibraryAction","deleteCode",{codeNo:codeNo});
	if("SUCCESS" != sReturn) {
	   alert("删除失败!");
                 } else {
	    reloadSelf();
                 }
      }
}','onDblClickRow','editCodeItem()'),
	('system.code_library_info.jsp','代码配置库详情信息','System','CodeLibraryInfo','Info','codeNo,itemNo','doSave','function doSave(){
    var sReturn=DWControl.save();
}

function doClose(){
    self.close();
}',NULL,''),
	('system.code_library_list.jsp','代码配置库列表页面','System','CodeLibraryList','List','codeNo','doAdd,doDelete,doEdit','function doAdd() {
DWControl.OpenDwWindow({'id':'ColumnDetailInfoPage',"title":"代码详情",'page':'system.code_library_info.jsp','param':"codeNo=${codeNo}","width":'80%',"height":'80%'},function(){reloadSelf();});
   // var sReturn=DWControl.PopDwComp("system.code_library_info.jsp","codeNo=${codeNo}","dialogWidth=600px;dialogHeight=400px;resizable=no;maximize:no;help:no;status:no;");
   //    reloadSelf();
}
	
function doEdit(){
    var itemNo = getItemValue("dwForm", "ITEMNO");
    if (itemNo == null) {
        alert("请选择一条记录!");
        return;
    }
var sReturn=DWControl.OpenDwWindow({'id':'ColumnDetailInfoPage',"title":"代码详情",'page':'system.code_library_info.jsp','param':"codeNo=${codeNo}&itemNo=" + itemNo,"width":'80%',"height":'80%'},function(){reloadSelf();});
  //  var sReturn=DWControl.PopDwComp("system.code_library_info.jsp", "codeNo=${codeNo}&itemNo=" + itemNo,"dialogWidth=600px;dialogHeight=400px;resizable=yes;maximize:yes;help:no;status:no;");
   // if(sReturn=='SUCCESS'){
   //    reloadSelf();
   // }
}
	
function doDelete(){
   DWControl.Delete('dwForm');
   reloadSelf();
}

function doReturn(){
    history.back();
}','onDblClickRow','doEdit()'),
	('system.control_board.page','控制面板','System','ControlBoardInfo','Info','',NULL,'function refreshPermission(){
	var sReturn=RunJavaMethodTrans("platform.codeLibraryAction", "refreshPermission");
  	if('SUCCESS'==sReturn){
    	alert("刷新成功!");
    	reloadSelf();
   	}else{
		alert(sReturn);
  	}
}

function treeSqlDefine(){
DWControl.OpenDwWindow({'id':'TreeSQLDefineInfoPage',"title":"树图SQL定义",'page':'system.tree_sql_define.page'});
}

function refreshTable(){
var sReturn=RunJavaMethodTrans("platform.tableObjectAction", "refreshAllTable");
  if('SUCCESS'==sReturn){
     alert("刷新成功!");
    reloadSelf();
   }else{
      alert(sReturn);
  }
}',NULL,''),
	('system.datawindow_page_info.jsp','模板页面配置详情','System','DataWindowPageInfo','Info','PagePath','doSave,doPreview','$(function(){
displayToggle();
});
function doSave(){
  var sReturn=DWControl.save();
  if("SUCCESS"==sReturn){
        self.returnValue="SUCCESS";
   // self.close();
  }
}

function doClose(){
   self.close();
}

function doPreview(){
DWControl.OpenDwWindow({'id':'ColumnDetailInfoPage',"title":"预览",'page':getItemValue("dwForm", "PAGEPATH")});
}

function selectDW(sReturn){
if(!sReturn){
   DWControl.PopSelectort("DwEditlist",'',false,"DONO,DONAME","selectDW");
   return;
}
   if(sReturn==undefined){
    return;
   }else if("_CLEAR_"==sReturn){
    setItemValue('dwForm','DONO','');
   }else{
        var oldDoNo=getItemValue('dwForm','DONO');
        setItemValue('dwForm','DONO',sReturn['DONO']);   
        var pageName=getItemValue('dwForm','PageName');
        if(pageName.length==0||(oldDoNo.length&&oldDoNo!=getItemValue('dwForm','DONO'))){
            setItemValue('dwForm','PageName',sReturn['DONAME']);   
        }
   }
}

function displayToggle(){
    var displayStyle=getItemValue('dwForm','DISPLAYSTYLE');
    if('List'==displayStyle){
    setItemVisible('dwForm','DatagridEvent',true); 
    setItemVisible('dwForm','DatagridScript',true); 
    }else{
    setItemVisible('dwForm','DatagridEvent',false); 
    setItemVisible('dwForm','DatagridScript',false); 
    }
}
function showTitle(curObj){
curObj.title="function "+curObj.value+"()";
}',NULL,''),
	('system.datawindow_page_list.jsp','模板页面配置列表','System','DataWindowPageList','List','','doAdd,doDelete,doEdit,doPreview,doCopy','function doAdd(){
DWControl.OpenDwWindow({'id':'ColumnDetailInfoPage',"title":"新增模板页面",'page':'system.datawindow_page_info.jsp'},function(){reloadSelf();});
 //  var sReturn=DWControl.PopDwComp("system.datawindow_page_info.jsp","","");
  // if(sReturn=="SUCCESS"){
 //      alert("添加成功!");
  //     reloadSelf();
  // }
}

function doDelete(){
    var pagePath= getItemValue("dwForm", "PAGEPATH");
    if (pagePath== null) {
        alert("请选择一条记录!");
        return;
    }
    if(confirm("是否要删除页面:"+pagePath)){
        var sReturn=RunJavaMethod("com.zjw.platform.service.action.DataWindowPageAction","doDelete",{pagePath:pagePath});
        if("SUCCESS"!=sReturn){
            alert("删除失败!");
        }else{
            reloadSelf();
        }
    }
}

function doEdit(){
  var pagePath= getItemValue("dwForm", "PAGEPATH");
		if (pagePath== null) {
			alert("请选择一条记录!");
			return;
		}
DWControl.OpenDwWindow({'id':'ColumnDetailInfoPage',"title":"编辑模板页面",'page':'system.datawindow_page_info.jsp','param':"PagePath="+pagePath},function(){reloadSelf();});
//   var sReturn=DWControl.PopDwComp("system.datawindow_page_info.jsp","PagePath="+pagePath,"");
//  if(sReturn=='SUCCESS'){
//	reloadSelf();
 // }
}

function doCopy(){
    var pagePath= getItemValue("dwForm", "PAGEPATH");
    if (pagePath== null) {
        alert("请选择一条记录!");
        return;
    }
    var sReturn=RunJavaMethod("com.zjw.platform.service.action.DataWindowPageAction","doCopy",{pagePath:pagePath});
    if("SUCCESS"!=sReturn){
         alert("复制失败!");
     }else{
            reloadSelf();
     }
}

function doPreview(){
   DWControl.PopDwComp(getItemValue("dwForm", "PAGEPATH"));
}','onDblClickRow','doEdit()'),
	('system.datawindow_pagetype_list.jsp','显示模板页面列表','System','DataWindowPagebyTypeList','List','pageType','doAdd,doDelete,doEdit,doPreview,doCopy','function doAdd(){
DWControl.OpenDwWindow({'id':'ColumnDetailInfoPage',"title":"新增系统页面",'page':'system.datawindow_page_info.jsp'},function(){reloadSelf();});
  // var sReturn=DWControl.PopDwComp("system.datawindow_page_info.jsp","","");
 //  if(sReturn=="SUCCESS"){
  //     alert("添加成功!");
  //     reloadSelf();
  // }
}

function doDelete(){
    var pagePath= getItemValue("dwForm", "PAGEPATH");
    if (pagePath== null) {
        alert("请选择一条记录!");
        return;
    }
    if(confirm("是否要删除页面:"+pagePath)){
        var sReturn=RunJavaMethod("com.zjw.sys.action.DataWindowPageAction","doDelete",{pagePath:pagePath});
        if("SUCCESS"!=sReturn){
            alert("删除失败!");
        }else{
            reloadSelf();
        }
    }
}

function doEdit(){
  var pagePath= getItemValue("dwForm", "PAGEPATH");
		if (pagePath== null) {
			alert("请选择一条记录!");
			return;
		}
DWControl.OpenDwWindow({'id':'ColumnDetailInfoPage',"title":"编辑系统页面",'page':'system.datawindow_page_info.jsp','param':"PagePath="+pagePath},function(){reloadSelf();});
   //var sReturn=DWControl.PopDwComp("system.datawindow_page_info.jsp","PagePath="+pagePath,"");
//  if(sReturn=='SUCCESS'){
//	reloadSelf();
 // }
}

function doCopy(){
    var pagePath= getItemValue("dwForm", "PAGEPATH");
    if (pagePath== null) {
        alert("请选择一条记录!");
        return;
    }
    var sReturn=RunJavaMethod("com.zjw.sys.action.DataWindowPageAction","doCopy",{pagePath:pagePath});
    if("SUCCESS"!=sReturn){
         alert("复制失败!");
     }else{
            reloadSelf();
     }
}

function doPreview(){
   DWControl.PopDwComp(getItemValue("dwForm", "PAGEPATH"));
}','onDblClickRow','doEdit()'),
	('system.depot_info.page','仓库信息详情','Service','DepotInfo','Info','DepotNo','doSave','function doSave(){
  var sReturn=DWControl.save();
  if("SUCCESS"==sReturn){
        self.returnValue="SUCCESS";
  }
}

function doClose(){
   self.close();
}',NULL,''),
	('system.depot_list.page','仓库信息列表','Service','DepotList','List','','doAdd,doDelete,doEdit','function doAdd(){
DWControl.OpenDwWindow({page:"system.depot_info.page",title:'新增仓库',width:600,height:400},function(){reloadSelf();});
//    DWControl.PopDwComp("system.depot_info.page","","dialogWidth=600px;dialogHeight=400px;resizable=no;maximize:no;help:no;status:no;");
 //   reloadSelf();
}

function doDelete(){
    DWControl.Delete();
    reloadSelf();
}

function doEdit(){
  var DepotNo= getItemValue("dwForm", "DepotNo");
   if (DepotNo== null) {
	alert("请选择一条记录!");
	return;
   }
DWControl.OpenDwWindow({page:"system.depot_info.page",param:"DepotNo="+DepotNo,title:'新增仓库',width:600,height:400},function(){reloadSelf();});
//    DWControl.PopDwComp("system.depot_info.page","DepotNo="+DepotNo,"dialogWidth=600px;dialogHeight=400px;resizable=no;maximize:no;help:no;status:no;");  
 //   reloadSelf();
}','onDblClickRow','doEdit()'),
	('system.dw_catalog_info.jsp','显示模板定义详情','System','DwEditInfo','Info','doNo','doSave','function doSave(){
    var sReturn=DWControl.save();
}
function doClose() {
    self.close();
}',NULL,''),
	('system.dw_catalog_list.jsp','显示模板科目列表','System','DwEditList','List','','doAdd,doDelete,doEdit,doCopy,editDwLib,renameDW,exportExcel','function doAdd() {
DWControl.OpenDwWindow({'id':'ColumnDetailInfoPage',"title":"编辑显示模板",'page':'system.dw_catalog_info.jsp',"width":600,"height":400},function(){reloadSelf();});
   // var sReturn=DWControl.PopDwComp("system.dw_catalog_info.jsp","","dialogWidth=600px;dialogHeight=400px;resizable=no;maximize:no;help:no;status:no;");
    //if(sReturn=='SUCCESS'){
     //   alert("添加成功!");
       // reloadSelf();
    //}
}
	
function doEdit() {
    var doNo = getItemValue("dwForm", "DONO");
    if (doNo == null) {
        alert("请选择一条记录!");
        return;
    }
DWControl.OpenDwWindow({'id':'ColumnDetailInfoPage',"title":"编辑显示模板",'page':'system.dw_catalog_info.jsp','param':"doNo=" + doNo,"width":600,"height":400},function(){reloadSelf();});
    //var sReturn=DWControl.PopDwComp("system.dw_catalog_info.jsp", "doNo=" + doNo,"dialogWidth=600px;dialogHeight=400px;resizable=yes;maximize:yes;help:no;status:no;");
    //reloadSelf();
}
	
function editDwLib() {
    var doNo = getItemValue("dwForm", "DONO");
    if (doNo == null) {
        alert("请选择一条记录!");
        return;
    }
    DWControl.OpenDwComp("system.dw_library_list.jsp", "doNo=" + doNo);
}
	
function doDelete(){
     DWControl.Delete();
    reloadSelf();
}
	
function doCopy(){
    var doNo = getItemValue("dwForm", "DONO");
    if (doNo == null) {
        alert("请选择一条记录!");
        return;
    }
    var sReturn=RunJavaMethodTrans("platform.dataWindowAction","copyDataWindow",{doNo:doNo});
    if("SUCCESS" != sReturn) {
        alert("复制失败!"+sReturn);
    } else {
        alert("复制成功!");
        reloadSelf();
    }
}
	
function renameDW(){
    var doNo = getItemValue("dwForm", "DONO");
    if (doNo == null) {
        alert("请选择一条记录!");
        return;
    }
    var newDoNo=prompt("请输入显示模板名称");
    if(!newDoNo||'undefined'==newDoNo||newDoNo==doNo){
         return;
    }
    var sReturn=RunJavaMethod("platform.dataWindowAction","isExistDoNo",{doNo:newDoNo});
    if("SUCCESS"==sReturn){
        alert("显示模板编号: "+newDoNo+" 已存在!");
        return;
    }
    var sReturn=RunJavaMethodTrans("platform.dataWindowAction","reNameDataWindow",{doNo:doNo,newDoNo:newDoNo});
    if("SUCCESS" != sReturn) {
        alert("重命名失败!"+sReturn);
    } else {
        alert("重命名成功!");
        reloadSelf();
    }
}

function exportExcel(){
DWControl.exportExcel();
}','onDblClickRow','editDwLib()'),
	('system.dw_event_info.jsp','显示模板要素事件详情','System','DwEventInfo','Info','doNo,fieldCode,event','doSave','function doSave(){
   DWControl.save();   
}',NULL,''),
	('system.dw_event_list.jsp','显示模板要素事件列表','System','DwEventList','List','doNo,fieldCode','doAdd,doDelete,doEdit','function doAdd() {
DWControl.OpenDwWindow({'id':'ColumnDetailInfoPage',"title":"新增事件",'page':'system.dw_event_info.jsp','param':"doNo=${doNo}&fieldCode=${fieldCode}","width":600,"height":400},function(){reloadSelf();});
}
	
function doEdit() {
    var event = getItemValue("dwForm", "EVENT");
    if (event == null) {
        alert("请选择一条记录!");
        return;
    }
    DWControl.OpenDwWindow({'id':'ColumnDetailInfoPage',"title":"编辑事件",'page':'system.dw_event_info.jsp','param':"doNo=${doNo}&fieldCode=${fieldCode}&event=" + event,"width":600,"height":400},function(){reloadSelf();});
}
	
function doDelete(){
  var sReturn=DWControl.Delete('dwForm');
    if(sReturn!=null&&sReturn.length>0){
        reloadSelf();
    }
}','onDblClickRow','doEdit()'),
	('system.dw_library_info.jsp','显示模板要素详情页面','System','DWCONFIG','Info','doNo,fieldCode','doSave','function doSave() {
   DWControl.save();
}
	
function doClose(){
    self.close();
}

function selectRegex(){
    var sReturn=DWControl.PopSelectort("CommonRegexSelector","",false,'ATTR01');
    if(sReturn['ATTR01']){
        setItemValue('dwForm','REGEX',sReturn['ATTR01']);
    }else if("_CLEAR_"==sReturn){
        setItemValue('dwForm','REGEX','');
    }
}

function selectColumn(sReturn){
if(!sReturn){
var doNo=getItemValue('dwForm','dono');
        var tableName=RunJavaMethod('platform.dataWindowAction','getMainTableName',{doNo:doNo}).toUpperCase();
        var sReturn=DWControl.PopSelectort("TableObjectColumnList",tableName,false,"FieldName","selectColumn");
return;
}
        if('_CLEAR_'==sReturn){
            setItemValue('dwForm','ColField','');
        }else{
            setItemValue('dwForm','ColField',sReturn['FieldName']);
        }
}
$(function(){
    $('#doSelect').click(function(){
        selectColumn();
    });
});',NULL,''),
	('system.dw_library_list.jsp','显示模板要素列表','System','DwLibraryList','List','doNo','doReturn,doAdd,doDelete,doEdit,addEvent,exportExcel','function doAdd() {
DWControl.OpenDwWindow({'id':'ColumnDetailInfoPage',"title":"新增显示模板",'page':'system.dw_library_info.jsp','param':"doNo=${doNo}"},function(){reloadSelf();});

}
	
function doEdit(){
    var fieldCode = getItemValue("dwForm", "FIELDCODE");
    if (fieldCode == null) {
        alert("请选择一条记录!");
        return;
    }
var sReturn=DWControl.OpenDwWindow({'id':'ColumnDetailInfoPage',"title":"显示模板详情",'page':'system.dw_library_info.jsp','param':"doNo=${doNo}&fieldCode=" + fieldCode},function(){reloadSelf();});
   // var sReturn=DWControl.PopDwComp("system.dw_library_info.jsp", "doNo=${doNo}&fieldCode=" + fieldCode,"");
   // if(sReturn=='SUCCESS'){
   //     reloadSelf();
    //}
//reloadSelf();
}
	
function doDelete(){
 DWControl.Delete();
    reloadSelf();
}

function addEvent(){
    var fieldCode = getItemValue("dwForm", "FIELDCODE");
    if (fieldCode == null) {
        alert("请选择一条记录!");
        return;
    }
    DWControl.OpenDwWindow({'id':'EventListPage',"title":"模板事件列表",'page':'system.dw_event_list.jsp','param':"doNo=${doNo}&fieldCode=" + fieldCode},function(){reloadSelf();});
    //DWControl.PopDwComp("system.dw_event_list.jsp", "doNo=${doNo}&fieldCode=" + fieldCode,"dialogWidth=600px;dialogHeight=600px;resizable=yes;maximize:yes;help:no;status:no;");
 }

function doReturn(){
    history.back();
}
function exportExcel(){
DWControl.exportExcel();
}','onDblClickRow','doEdit()'),
	('system.email_list.page','邮件列表','System','EmailList','List','',NULL,'',NULL,''),
	('system.layout_catalog_info.page','布局配置定义详情','System','LayoutCatalogInfo','Info','layoutID','doSave','function doSave(){
  var sReturn=DWControl.save();
  if("SUCCESS"==sReturn){
      self.returnValue="SUCCESS";
      self.close();
  }
}

function doClose(){
   self.close();
}',NULL,''),
	('system.layout_catalog_list.page','布局配置定义','System','LayoutCatalogList','List','subject,layoutStyle','doAdd,doDelete,doEdit,editLayoutItem','function doAdd() {
DWControl.OpenDwWindow({'id':'layout_catalog','title':'布局配置定义',page:"system.layout_catalog_info.page", "param":"layoutStyle=${layoutStyle}&subject=${subject}",'width':600,'height':400},function(){reloadSelf();});
   // var sReturn=DWControl.PopDwComp("system.layout_catalog_info.page","layoutStyle=${layoutStyle}&subject=${subject}","dialogWidth=800px;dialogHeight=600px;resizable=no;maximize:no;help:no;status:no;");
  //  if(sReturn=='SUCCESS'){
   //     reloadSelf();
   // }
}
	
function doEdit(){
    var layoutID= getItemValue("dwForm", "layoutID");
    if (layoutID== null) {
        alert("请选择一条记录!");
        return;
    }
    DWControl.OpenDwWindow({'id':'layout_catalog','title':'布局配置定义',page:"system.layout_catalog_info.page", "param":"layoutID=" + layoutID,'width':600,'height':400},function(){reloadSelf();});
}
	
function doDelete(){
    var sReturn=DWControl.Delete('dwForm');
    if(sReturn!=null&&sReturn.length>0){
        reloadSelf();
    }
}

function editLayoutItem(){
    var layoutID= getItemValue("dwForm", "layoutID");
    if (layoutID== null) {
        alert("请选择一条记录!");
        return;
    }
   // DWControl.OpenComp("frame/layout.jsp", "LayoutID=LayoutItemFrame&layoutID=" + layoutID);
AWE.OpenLayout('.easyui-layout','center','frame/layout.jsp',"LayoutID=LayoutItemFrame&layoutID=" + layoutID);
}','onDblClickRow','doEdit()'),
	('system.layout_item_info.jsp','布局栏目详情','System','LayoutItemInfo','Info','layoutID,pageID','doSave','function doSave(){
    var sReturn=DWControl.save(null,function(){
      AWE.OpenDwLayout('#LayoutItemFrame_layout','north',"system.layout_item_list.jsp","layoutID=${layoutID}")  
    });
}',NULL,''),
	('system.layout_item_list.jsp','布局栏目列表','System','LayoutItemList','List','layoutID','doAdd,doDelete','function doReturn(){
   DWControl.OpenDwComp("system.layout_catalog_list.page","subject=SystemManage&layoutStyle=Frame",parent);
}

function doAdd() {
//    var sReturn=DWControl.OpenDwComp("system.layout_item_info.jsp","layoutID=${layoutID}",parent.center);
var sReturn=AWE.OpenDwLayout('#LayoutItemFrame_layout','center',"system.layout_item_info.jsp","layoutID=${layoutID}");

    if(sReturn=='SUCCESS'){
        alert("添加成功!");
        reloadSelf();
    }
}
	
function doEdit(){
    var pageID = getItemValue("#LayoutItemList", "PAGEID");
    if (pageID == null||pageID.length==0) {
        alert("请选择一条记录!");
        return;
    }
   // var sReturn=DWControl.OpenDwComp("system.layout_item_info.jsp","layoutID=${layoutID}&pageID="+pageID,parent.center);
    var sReturn=AWE.OpenDwLayout('#LayoutItemFrame_layout','center',"system.layout_item_info.jsp","layoutID=${layoutID}&pageID="+pageID);
}

function doDelete(){
    DWControl.Delete();
    reloadSelf();
    doAdd();
}','onClickRow','doEdit()'),
	('system.license_regist_info.page','许可证注册页面','System','LicenseRegistInfo','Info','','doSave','function doSave() {
    DWControl.save(function(data){
        alert("注册成功,请重新登录");
        location.href='logoff';
    }); 
}',NULL,''),
	('system.product_item_info.page','产品栏目详情','Service','ProductItemInfo','Info','ProductNo','doSave','function doSave(){
  var sReturn=DWControl.save();
  if("SUCCESS"==sReturn){
        self.returnValue="SUCCESS";
  }
}

function doClose(){
   self.close();
}',NULL,''),
	('system.product_item_list.page','产品栏目列表','Service','ProductItemList','List','','doAdd,doDelete,doEdit,exportExcel','function doAdd(){
DWControl.OpenDwWindow({'id':'ColumnDetailInfoPage',"title":"产品详情",'page':'system.product_item_info.page',"width":'80%',"height":'80%'},function(){reloadSelf();});
   // DWControl.PopDwComp("system.product_item_info.page","","dialogWidth=600px;dialogHeight=400px;resizable=no;maximize:no;help:no;status:no;");
   // reloadSelf();
}

function doDelete(){
    DWControl.Delete();
    reloadSelf();
}

function doEdit(){
  var productNo= getItemValue("dwForm", "PRODUCTNO");
   if (productNo== null) {
	alert("请选择一条记录!");
	return;
   }
DWControl.OpenDwWindow({'id':'ColumnDetailInfoPage',"title":"产品详情",'page':'system.product_item_info.page','param':"ProductNo="+productNo,"width":'80%',"height":'80%'},function(){reloadSelf();});
    //DWControl.PopDwComp("system.product_item_info.page","ProductNo="+productNo,"dialogWidth=600px;dialogHeight=400px;resizable=no;maximize:no;help:no;status:no;");  
    //reloadSelf();
}
function exportExcel(){
DWControl.exportExcel();
}','onDblClickRow','doEdit()'),
	('system.role_info.jsp','角色定义详情','System','RoleInfo','Info','roleID','doSave','function doClose() {
    self.close();
}
	
function doSave() {
    DWControl.save();
    self.returnValue="SUCCESS";
    self.close();
}',NULL,''),
	('system.role_list.jsp','角色定义列表','System','RoleList','List','','doAdd,doDelete,doEdit','function doAdd() {
DWControl.OpenDwWindow({'id':'ColumnDetailInfoPage',"title":"新增角色信息",'page':'system.role_info.jsp',"width":600,"height":400},function(){reloadSelf();});
  //  var sReturn=DWControl.PopDwComp("system.role_info.jsp","","dialogWidth=600px;dialogHeight=400px;resizable=no;maximize:no;help:no;status:no;");
   // if(sReturn=="SUCCESS"){
   //     alert("添加成功!");
  //      reloadSelf();
   //}	
}
	
function doEdit() {
    var roleID = getItemValue("dwForm", "ROLEID");
    if (roleID == null) {
        alert("请选择一条记录!");
        return;
    }
DWControl.OpenDwWindow({'id':'ColumnDetailInfoPage',"title":"编辑角色信息",'page':'system.role_info.jsp','param':"roleID=" + roleID,"width":600,"height":400},function(){reloadSelf();});
   // var sReturn=DWControl.PopDwComp("system.role_info.jsp","roleID=" + roleID,"dialogWidth=600px;dialogHeight=400px;resizable=no;maximize:no;help:no;status:no;");
  //  if(sReturn=="SUCCESS"){
   //     alert("更新成功!");
  //      reloadSelf();
    //}
}
	
function doDelete() {
     DWControl.Delete();
 reloadSelf();
}','onDblClickRow','doEdit()'),
	('system.system_param_info.jsp','系统参数详情页面','System','SystemParamInfo','Info','paramName','doSave','function doClose() {
    self.close();
}
	
function doSave() {
  DWControl.save();
}',NULL,''),
	('system.system_param_list.jsp','系统参数列表','System','SystemParamList','List','','doAdd,doDelete,doEdit','function doAdd(){
DWControl.OpenDwWindow({'id':'ColumnDetailInfoPage',"title":"新增系统参数",'page':'system.system_param_info.jsp',"width":600,"height":400},function(){reloadSelf();});
}

function doDelete(){
    DWControl.Delete('dwForm');
    reloadSelf();
}

function doEdit(){
    var paramName = getItemValue("dwForm", "PARAMNAME");
    if (paramName == null) {
        alert("请选择一条记录!");
        return;
    }
DWControl.OpenDwWindow({'id':'ColumnDetailInfoPage',"title":"编辑系统参数",'page':'system.system_param_info.jsp','param':"paramName="+paramName,"width":600,"height":400},function(){reloadSelf();});
}','onDblClickRow','doEdit()'),
	('system.table_detail_list.jsp','数据库表字段列表','System','TableObjectColumnList','List','tableName','doReturn,doView,exportExcel','function doView(){
var tableName = getItemValue("dwForm", "TABLENAME");
    var fieldName = getItemValue("dwForm", "FIELDNAME");
    if (tableName == null||fieldName==null) {
        alert("请选择一条记录!");
        return;
    }
var sReturn=DWControl.OpenDwWindow({'id':'TableFieldInfoPage',"title":"表字段详情",'page':'system.table_object_info.jsp','param':"ReadOnly=true&tableName="+tableName+"&fieldName="+fieldName,"width":'80%',"height":'80%'},function(){reloadSelf();});
}
function doReturn(){
history.back();
}
function exportExcel(){
DWControl.exportExcel();
}','onDblClickRow','doView()'),
	('system.table_object_info.jsp','表字段详情页面','System','TableObjectInfo','Info','tableName,fieldName','doSave','function doSave(){
     DWControl.save();
     self.returnValue="SUCCESS";
     //self.close();
}

function doClose(){
     self.close();
}',NULL,''),
	('system.table_object_list','表对象管理列表','System','TableObjectList','List','','createDataWindow,refreshAllTable,doView','function doView() {
      var tableName = getItemValue("dwForm", "TABLENAME");
      if (tableName == null) {
           alert("请选择一条记录!");
           return;
       }
      DWControl.OpenDwComp("system.table_detail_list.jsp", "tableName=" + tableName);
}

	
function createDataWindow(){
    var tableName = getItemValue("dwForm", "TABLENAME");
    if (tableName == null) {
        alert("请选择一条记录!");
        return;
    }
    AWE.Prompt("请输入显示模板编号",function(value){
        if(value!=null){
            var sReturn=RunJavaMethodTrans("platform.dataWindowAction", "autoCreateDataWindow", {tableName:tableName,doNo:value});
             if("SUCCESS"==sReturn){
                 alert("生成成功!");
             }else{
                 alert(sReturn);
             }
         }
    });
}

function refreshAllTable(){
var sReturn=RunJavaMethodTrans("platform.tableObjectAction", "refreshAllTable");
  if('SUCCESS'==sReturn){
     alert("刷新成功!");
    reloadSelf();
   }else{
      alert(sReturn);
  }
}

function exportExcel(){
DWControl.exportExcel();
}','onDblClickRow','doView()'),
	('system.timer_task_info.page','定时任务列表','System','TimerTaskInfo','Info','id','doSave,doToggle','function doSave() {
   DWControl.save();
   getStatus();
}

function doToggle(){
    var id = getItemValue("dwForm", "id");
    if (id == null) {
        alert("请选择一条记录!");
        return;
    }
var sReturn=RunJavaMethod("platform.timerTaskAction", "toggleStatus", {id:id });
setItemValue("dwForm", "status",sReturn);
}

function getStatus(){
    var id = getItemValue("dwForm", "id");
    if (id == null) {
        alert("请选择一条记录!");
        return;
    }
var sReturn=RunJavaMethod("platform.timerTaskAction", "getStatus", {id:id });
setItemValue("dwForm", "status",sReturn);
}

function selectTask(sReturn){
if(!sReturn){
    DWControl.PopSelectort("CodeLibraryList",'TimerTaskClass',false,"ItemNo,ItemName","selectTask");
return;
}
   if('_CLEAR_'==sReturn){
       setItemValue('dwForm','ItemNo','');
   }else{
       setItemValue('dwForm','TRIGGERCLASS',sReturn['ItemNo']);
       setItemValue('dwForm','title',sReturn['ItemName']);
   }
}
$(document).ready(function(){  
 setInterval(getStatus, 3000);  
});',NULL,''),
	('system.timer_task_list.page','定时任务列表','System','TimerTaskList','List','','doAdd,doDelete,doEdit,doToggle','function doAdd() {
DWControl.OpenDwWindow({'id':'TimerTaskInfoPage',"title":"新增定时任务",'page':'system.timer_task_info.page',"width":'90%',"height":'90%'},function(){reloadSelf();});
}
	
function doEdit(){
    var id = getItemValue("dwForm", "id");
    if (id == null) {
        alert("请选择一条记录!");
        return;
    }
DWControl.OpenDwWindow({'id':'TimerTaskInfoPage',"title":"编辑定时任务",'page':'system.timer_task_info.page','param':'id='+id,"width":'90%',"height":'90%'},function(){reloadSelf();});
}
	
function doDelete(){
var sReturn=DWControl.Delete('dwForm');
    if(sReturn!=null&&sReturn.length>0){
        reloadSelf();
    }
}

function doToggle(){
    var id = getItemValue("dwForm", "id");
    if (id == null) {
        alert("请选择一条记录!");
        return;
    }
var sReturn=RunJavaMethod("platform.timerTaskAction", "toggleStatus", {id:id });
setItemValue("dwForm", "status",sReturn);
}

function getStatus(){
   var rows=$('.dwForm').datagrid('getRows'); 
   if(!rows){
      return
   }
   for(var i=0;i<rows.length;i++){
      var sReturn=RunJavaMethod("platform.timerTaskAction", "getStatus", {id:rows[i]['ID']});
      $('.dwForm').datagrid('updateRow', {index:i,row:{STATUS:sReturn}});
   }
}
$(document).ready(function(){  
 setInterval(getStatus, 3000);  
});','onDblClickRow','doEdit()'),
	('system.tree_sql_define.page','树图SQL定义','System','TreeSQLInfo','Info','','doSave','',NULL,''),
	('system.user_info.jsp','用户详情页面','System','UserInfo','Info','userID','doSave','function doSave() {
   DWControl.save();
}',NULL,''),
	('system.user_info_list.jsp','用户信息列表','System','UserList','List','','doAdd,doDelete,doEdit,roleManager','function doAdd() {
DWControl.OpenDwWindow({'id':'ColumnDetailInfoPage',"title":"新增用户详情",'page':'system.user_info.jsp',"width":900,"height":400},function(){reloadSelf();});
}
	
function doEdit(){
    var userID = getItemValue("dwForm", "USERID");
    if (userID == null) {
        alert("请选择一条记录!");
        return;
    }
DWControl.OpenDwWindow({'id':'ColumnDetailInfoPage',"title":"编辑用户详情",'page':'system.user_info.jsp','param':"userID=" + userID,"width":'80%',"height":'80%'},function(){reloadSelf();});
}
	
function doDelete(){
     DWControl.Delete();
 reloadSelf();
}
	
function roleManager(){
    var userID = getItemValue("dwForm", "USERID");
    if (userID == null) {
        alert("请选择一条记录!");
        return;
    }
DWControl.Window({'id':'ColumnDetailInfoPage',"title":"角色管理",'href':'system/user_role_manage.jsp','param':"userID="+userID,"width":'80%',"height":'80%'});
}','onDblClickRow','doEdit()'),
	('user.user_info_edit.jsp','用户信息列表','System','UserInfoEdit','Info','userID','doSave','function doSave(){
    DWControl.save();
}',NULL,''),
	('user.user_password_edit.jsp','用户密码修改','System','UserPasswordChange','Info','userID','doSave','function doSave(){
    DWControl.save();
}',NULL,'');

/*!40000 ALTER TABLE `datawindow_page` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table depot_info
# ------------------------------------------------------------

DROP TABLE IF EXISTS `depot_info`;

CREATE TABLE `depot_info` (
  `DepotNo` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '仓库编号',
  `DepotName` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '仓库名字',
  `DepotAddress` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT '仓库地址',
  PRIMARY KEY (`DepotNo`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

LOCK TABLES `depot_info` WRITE;
/*!40000 ALTER TABLE `depot_info` DISABLE KEYS */;

INSERT INTO `depot_info` (`DepotNo`, `DepotName`, `DepotAddress`)
VALUES
	('123123','12','12');

/*!40000 ALTER TABLE `depot_info` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table goods_access
# ------------------------------------------------------------

DROP TABLE IF EXISTS `goods_access`;

CREATE TABLE `goods_access` (
  `SerialNo` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '库存编号',
  `SampleNo` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '样品编号',
  `GoodsName` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT '货物名称',
  `GoodsCount` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '货物数量',
  `Status` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '库存状态',
  `ProductNo` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '产品编号',
  `ProductName` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '产品类型',
  `DepotNo` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '关联仓库',
  `DepotName` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT '仓库名称',
  `InputUserID` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '登记人',
  `InputDate` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '登记日期',
  `UpdateUserID` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '更新人员',
  `UpdateDate` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '更新日期',
  PRIMARY KEY (`SerialNo`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

LOCK TABLES `goods_access` WRITE;
/*!40000 ALTER TABLE `goods_access` DISABLE KEYS */;

INSERT INTO `goods_access` (`SerialNo`, `SampleNo`, `GoodsName`, `GoodsCount`, `Status`, `ProductNo`, `ProductName`, `DepotNo`, `DepotName`, `InputUserID`, `InputDate`, `UpdateUserID`, `UpdateDate`)
VALUES
	('2014050501','2014050301','测试','12','InDepot','2014050104','钳子','123123','12','admin','2014-05-05 20:29:54',NULL,NULL),
	('2014062901','2014050301','测试','12','OutDepot','2014050104','钳子','a','a','admin','2014-06-29 17:33:52',NULL,NULL);

/*!40000 ALTER TABLE `goods_access` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table layout_catalog
# ------------------------------------------------------------

DROP TABLE IF EXISTS `layout_catalog`;

CREATE TABLE `layout_catalog` (
  `LayoutID` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '页面布局信息',
  `LayoutName` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '布局名称',
  `LayoutStyle` varchar(12) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '布局方式',
  `Subject` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '系统应用主题',
  PRIMARY KEY (`LayoutID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

LOCK TABLES `layout_catalog` WRITE;
/*!40000 ALTER TABLE `layout_catalog` DISABLE KEYS */;

INSERT INTO `layout_catalog` (`LayoutID`, `LayoutName`, `LayoutStyle`, `Subject`)
VALUES
	('AppInfoFrame','子系统管理布局','Frame','SystemManage'),
	('CodeManager','代码管理','Tree','SystemManage'),
	('ContractManage','电子合同管理','Tree','SystemManage'),
	('CustomerInfoTab','客户信息','Tabs','CustomerManage'),
	('CustomerInfoTree','客户信息','Tree','CustomerManage'),
	('EmailBox','Email邮箱','Tree','SystemManage'),
	('LayoutCatalog','布局目录','Accordion','SystemManage'),
	('LayoutItemFrame','布局栏目布局','Frame','SystemManage'),
	('LayoutManager','布局管理','Frame','SystemManage');

/*!40000 ALTER TABLE `layout_catalog` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table layout_item
# ------------------------------------------------------------

DROP TABLE IF EXISTS `layout_item`;

CREATE TABLE `layout_item` (
  `LayoutID` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '布局ID',
  `PageID` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '组合页面ID',
  `Title` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '页面标题',
  `PageURL` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '页面URL',
  `position` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '页面定位',
  `IsInuse` varchar(1) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '是否可用',
  `size` varchar(19) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '页面大小',
  `split` varchar(1) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '分隔符',
  PRIMARY KEY (`LayoutID`,`PageID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

LOCK TABLES `layout_item` WRITE;
/*!40000 ALTER TABLE `layout_item` DISABLE KEYS */;

INSERT INTO `layout_item` (`LayoutID`, `PageID`, `Title`, `PageURL`, `position`, `IsInuse`, `size`, `split`)
VALUES
	('AppInfoFrame','AppInfoList','子系统信息列表','frame/blank.jsp','center','1','',NULL),
	('AppInfoFrame','appSubjectTree','应用科目树图','system/app_subject_tree.jsp','west','1','200px',NULL),
	('CodeManager','AllCode','所有代码','datawindow_page.html?pagePath=system.code_catalog_list.jsp','0030','1','',NULL),
	('CodeManager','ServiceCode','业务代码','datawindow_page.html?pagePath=system.code_catalog_bytype_list.page&codeType=Service','0020','1','',NULL),
	('CodeManager','SystemCode','系统代码','datawindow_page.html?pagePath=system.code_catalog_bytype_list.page&codeType=System','0010','1','',NULL),
	('ContractManage','E-ContractManage','电子合同管理','datawindow_page.html?pagePath=service.electronic_contract_list.page','0010','1','','1'),
	('ContractManage','TemplateManage','合同模板标题','datawindow_page.html?pagePath=service.contract_template_list.page','0020','1','',NULL),
	('CustomerInfoTree','CustomerInfo','客户详情','datawindow_page.html?pagePath=customer.customer_info.page','0010','1','',NULL),
	('CustomerInfoTree','RelContract','合同管理','datawindow_page.html?pagePath=service.electronic_service_contract_list.page&objectType=CustomerInfo','0030','1','',NULL),
	('CustomerInfoTree','Tst','联系方式','datawindow_page.html?pagePath=customer.contactbook_list.page','0020','1','',NULL),
	('EmailBox','DraftBox','草稿箱','datawindow_page.html?pagePath=system.email_list.page','0030','1','',NULL),
	('EmailBox','ReceiveBox','收件箱','datawindow_page.html?pagePath=system.email_list.page','0010','1','',NULL),
	('EmailBox','SendBox','发件箱','datawindow_page.html?pagePath=system.email_list.page','0020','1','',NULL),
	('EmailBox','TrashBox','垃圾箱','datawindow_page.html?pagePath=system.email_list.page','0040','1','',NULL),
	('LayoutCatalog','Accordion','Accordion页面','system/layout_catalog.jsp?layoutStyle=Accordion','0020','1',NULL,NULL),
	('LayoutCatalog','Frame','Frame页面','system/layout_catalog.jsp?layoutStyle=Frame','0010','1',NULL,NULL),
	('LayoutCatalog','Tabs','Tabs页面','system/layout_catalog.jsp?layoutStyle=Tabs','0040','1','',NULL),
	('LayoutCatalog','Tree','Tree页面','system/layout_catalog.jsp?layoutStyle=Tree','0030','1','',NULL),
	('LayoutItemFrame','center',NULL,'datawindow_page.html?pagePath=system.layout_item_info.jsp','center','1',NULL,NULL),
	('LayoutItemFrame','north',NULL,'datawindow_page.html?pagePath=system.layout_item_list.jsp','north','1',NULL,NULL),
	('LayoutManager','left',NULL,'frame/accordion.jsp?LayoutID=LayoutCatalog','west','1',NULL,NULL),
	('LayoutManager','right','布局详情','frame/blank.jsp','center','1','',NULL);

/*!40000 ALTER TABLE `layout_item` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table news_info
# ------------------------------------------------------------

DROP TABLE IF EXISTS `news_info`;

CREATE TABLE `news_info` (
  `SerialNo` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '',
  `NewsCatalog` varchar(32) COLLATE utf8_bin DEFAULT NULL,
  `SourceHref` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `NewsTitle` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '新闻标题',
  `SourceSite` varchar(100) COLLATE utf8_bin DEFAULT NULL,
  `publishDate` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '发布日期',
  `UpComment` varchar(10) COLLATE utf8_bin DEFAULT NULL,
  `DownComment` varchar(10) COLLATE utf8_bin DEFAULT NULL,
  `Content` blob,
  `InputUserID` varchar(32) COLLATE utf8_bin DEFAULT NULL,
  `InputDate` varchar(32) COLLATE utf8_bin DEFAULT NULL,
  `UpdateUserId` varchar(32) COLLATE utf8_bin DEFAULT NULL,
  `UpdateDate` varchar(32) COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`SerialNo`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

LOCK TABLES `news_info` WRITE;
/*!40000 ALTER TABLE `news_info` DISABLE KEYS */;

INSERT INTO `news_info` (`SerialNo`, `NewsCatalog`, `SourceHref`, `NewsTitle`, `SourceSite`, `publishDate`, `UpComment`, `DownComment`, `Content`, `InputUserID`, `InputDate`, `UpdateUserId`, `UpdateDate`)
VALUES
	('2014071901','Recommend','','阿斯顿','','2015-02-03 02:37:19','','','','','2014-07-19 20:27:40','zjw','2015-03-11 16:13:18');

/*!40000 ALTER TABLE `news_info` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table org_info
# ------------------------------------------------------------

DROP TABLE IF EXISTS `org_info`;

CREATE TABLE `org_info` (
  `orgid` varchar(6) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '机构编号',
  `orgname` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '机构名称',
  `sortno` varchar(6) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '排序号',
  `orglevel` varchar(6) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '机构级别',
  `isinuse` varchar(1) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '是否可用',
  `belongorgid` varchar(6) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '率属机构',
  PRIMARY KEY (`orgid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

LOCK TABLES `org_info` WRITE;
/*!40000 ALTER TABLE `org_info` DISABLE KEYS */;

INSERT INTO `org_info` (`orgid`, `orgname`, `sortno`, `orglevel`, `isinuse`, `belongorgid`)
VALUES
	('01','BridgeChance','01','1','1',NULL),
	('0101','机构1子节点1','0101','1','1',NULL),
	('0102','机构1子节点2','0102','1','1',NULL),
	('010201','机构1子节点21','010201','1','1',NULL),
	('0103','机构1子节点3','0103','1','1',NULL),
	('02','机构2','02','1','1',NULL),
	('0201','机构2子节点1','0201','1','1',NULL),
	('0202','机构2子节点2','0202','1','1',NULL),
	('020201','机构2子节点21','020201','1','1',NULL),
	('0203','机构2子节点3','0203','1','1',NULL);

/*!40000 ALTER TABLE `org_info` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table product_item
# ------------------------------------------------------------

DROP TABLE IF EXISTS `product_item`;

CREATE TABLE `product_item` (
  `ProductNo` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '',
  `ProductName` varchar(32) COLLATE utf8_bin DEFAULT NULL,
  `SortNO` varchar(32) COLLATE utf8_bin DEFAULT NULL,
  `InputUserID` varchar(32) COLLATE utf8_bin DEFAULT NULL,
  `InputDate` varchar(32) COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`ProductNo`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

LOCK TABLES `product_item` WRITE;
/*!40000 ALTER TABLE `product_item` DISABLE KEYS */;

INSERT INTO `product_item` (`ProductNo`, `ProductName`, `SortNO`, `InputUserID`, `InputDate`)
VALUES
	('2014050101','文具类','1','admin','2014-05-01 11:10:12'),
	('2014050102','铅笔','1001','admin','2014-05-01 11:10:32'),
	('2014050103','五金类','2','admin','2014-05-01 11:10:48'),
	('2014050104','钳子','2001','admin','2014-05-01 11:14:00');

/*!40000 ALTER TABLE `product_item` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table role_info
# ------------------------------------------------------------

DROP TABLE IF EXISTS `role_info`;

CREATE TABLE `role_info` (
  `RoleID` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '角色ID',
  `RoleName` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '角色名称',
  `isTrunk` varchar(1) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '是否为主类',
  `authGroup` text COMMENT '权限组',
  PRIMARY KEY (`RoleID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

LOCK TABLES `role_info` WRITE;
/*!40000 ALTER TABLE `role_info` DISABLE KEYS */;

INSERT INTO `role_info` (`RoleID`, `RoleName`, `isTrunk`, `authGroup`)
VALUES
	('1','管理员','1',NULL),
	('1000','超级系统管理员',NULL,'Contact_Book_Query,Contact_Book_Insert,Contact_Book_Update,Contact_Book_Delete,SERVICE_CUSTOMER_INFO_QUERY,SERVICE_CUSTOMER_INFO_INSERT,SERVICE_CUSTOMER_INFO_UPDATE,SERVICE_CUSTOMER_INFO_DELETE,SMART_ADMINISTRATOR,SMART_APP_INFO_INSERT,SMART_APP_INFO_DELETE,SMART_APP_INFO_QUERY,SMART_APP_INFO_UPDATE,SMART_APP_ITEM_INSERT,SMART_APP_ITEM_DELETE,SMART_APP_ITEM_QUERY,SMART_APP_ITEM_UPDATE,SMART_CODE_CATALOG_INSERT,SMART_CODE_CATALOG_DELETE,SMART_CODE_CATALOG_QUERY,SMART_CODE_CATALOG_UPDATE,SMART_CODE_LIBRARY_DELETE,SMART_CODE_LIBRARY_QUERY,SMART_CODE_LIBRARY_UPDATE,SMART_CODE_LIBRARY_INSERT,SMART_CONTRACT_TEMPLATE_DELETE,SMART_CONTRACT_TEMPLATE_QUERY,SMART_CONTRACT_TEMPLATE_UPDATE,SMART_CONTRACT_TEMPLATE_INSERT,SMART_DW_CATALOG_DELETE,SMART_DW_CATALOG_QUERY,SMART_DW_CATALOG_UPDATE,SMART_DW_CATALOG_INSERT,SMART_DW_EVENT_DELETE,SMART_DW_EVENT_QUERY,SMART_DW_EVENT_UPDATE,SMART_DW_EVENT_INSERT,SMART_DW_LIBRARY_DELETE,SMART_DW_LIBRARY_QUERY,SMART_DW_LIBRARY_UPDATE,SMART_DW_LIBRARY_INSERT,SMART_LAYOUT_CATALOG_DELETE,SMART_LAYOUT_CATALOG_QUERY,SMART_LAYOUT_CATALOG_UPDATE,SMART_LAYOUT_CATALOG_INSERT,SMART_LAYOUT_ITEM_DELETE,SMART_LAYOUT_ITEM_QUERY,SMART_LAYOUT_ITEM_UPDATE,SMART_LAYOUT_ITEM_INSERT,SMART_TABLE_OBJECT_INSERT,SMART_TABLE_OBJECT_DELETE,SMART_TABLE_OBJECT_QUERY,SMART_TABLE_OBJECT_UPDATE,SMART_TIME_TASK_INSERT,SMART_TIME_TASK_DELETE,SMART_TIME_TASK_QUERY,SMART_TIME_TASK_UPDATE,SMART_ROLE_INFO_INSERT,SMART_ROLE_INFO_DELETE,SMART_ROLE_INFO_QUERY,SMART_ROLE_INFO_UPDATE,SMART_ROLE_RELATION_INSERT,SMART_ROLE_RELATION_DELETE,SMART_ROLE_RELATION_QUERY,SMART_ROLE_RELATION_UPDATE,SMART_SYSTEM_PARAM_INSERT,SMART_SYSTEM_PARAM_DELETE,SMART_SYSTEM_PARAM_QUERY,SMART_SYSTEM_PARAM_UPDATE,SMART_USER_INFO_INSERT,SMART_USER_INFO_DELETE,SMART_USER_INFO_QUERY,SMART_USER_INFO_UPDATE'),
	('1001','普通管理员',NULL,'Contact_Book_Query,Contact_Book_Insert,Contact_Book_Update,Contact_Book_Delete,SERVICE_CUSTOMER_INFO_QUERY,SERVICE_CUSTOMER_INFO_INSERT,SERVICE_CUSTOMER_INFO_UPDATE,SERVICE_CUSTOMER_INFO_DELETE,SMART_APP_INFO_INSERT,SMART_APP_INFO_DELETE,SMART_APP_INFO_QUERY,SMART_APP_INFO_UPDATE,SMART_APP_ITEM_INSERT,SMART_APP_ITEM_DELETE,SMART_APP_ITEM_QUERY,SMART_APP_ITEM_UPDATE,SMART_CODE_CATALOG_INSERT,SMART_CODE_CATALOG_DELETE,SMART_CODE_CATALOG_QUERY,SMART_CODE_CATALOG_UPDATE,SMART_CODE_LIBRARY_DELETE,SMART_CODE_LIBRARY_QUERY,SMART_CODE_LIBRARY_UPDATE,SMART_CODE_LIBRARY_INSERT,SMART_CONTRACT_TEMPLATE_DELETE,SMART_CONTRACT_TEMPLATE_QUERY,SMART_CONTRACT_TEMPLATE_UPDATE,SMART_CONTRACT_TEMPLATE_INSERT,SMART_DW_CATALOG_DELETE,SMART_DW_CATALOG_QUERY,SMART_DW_CATALOG_UPDATE,SMART_DW_CATALOG_INSERT,SMART_DW_EVENT_DELETE,SMART_DW_EVENT_QUERY,SMART_DW_EVENT_UPDATE,SMART_DW_EVENT_INSERT,SMART_DW_LIBRARY_DELETE,SMART_DW_LIBRARY_QUERY,SMART_DW_LIBRARY_UPDATE,SMART_DW_LIBRARY_INSERT,SMART_LAYOUT_CATALOG_DELETE,SMART_LAYOUT_CATALOG_QUERY,SMART_LAYOUT_CATALOG_UPDATE,SMART_LAYOUT_CATALOG_INSERT,SMART_LAYOUT_ITEM_DELETE,SMART_LAYOUT_ITEM_QUERY,SMART_LAYOUT_ITEM_UPDATE,SMART_LAYOUT_ITEM_INSERT,SMART_TABLE_OBJECT_INSERT,SMART_TABLE_OBJECT_DELETE,SMART_TABLE_OBJECT_QUERY,SMART_TABLE_OBJECT_UPDATE,SMART_TIME_TASK_INSERT,SMART_TIME_TASK_DELETE,SMART_TIME_TASK_QUERY,SMART_TIME_TASK_UPDATE,SMART_ROLE_INFO_INSERT,SMART_ROLE_INFO_DELETE,SMART_ROLE_INFO_QUERY,SMART_ROLE_INFO_UPDATE,SMART_ROLE_RELATION_INSERT,SMART_ROLE_RELATION_DELETE,SMART_ROLE_RELATION_QUERY,SMART_ROLE_RELATION_UPDATE,SMART_SYSTEM_PARAM_INSERT,SMART_SYSTEM_PARAM_DELETE,SMART_SYSTEM_PARAM_QUERY,SMART_SYSTEM_PARAM_UPDATE,SMART_USER_INFO_INSERT,SMART_USER_INFO_DELETE,SMART_USER_INFO_QUERY,SMART_USER_INFO_UPDATE'),
	('2','普通用户','1',NULL),
	('2001','业务员',NULL,'Contact_Book_Query,Contact_Book_Insert,Contact_Book_Update,Contact_Book_Delete,SERVICE_CUSTOMER_INFO_QUERY,SERVICE_CUSTOMER_INFO_INSERT,SERVICE_CUSTOMER_INFO_UPDATE,SERVICE_CUSTOMER_INFO_DELETE,SMART_USER_INFO_QUERY,SMART_USER_INFO_UPDATE'),
	('2002','仓库管理员',NULL,NULL);

/*!40000 ALTER TABLE `role_info` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table role_object_rela
# ------------------------------------------------------------

DROP TABLE IF EXISTS `role_object_rela`;

CREATE TABLE `role_object_rela` (
  `roleID` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '角色编号',
  `objectID` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '关联对象ID',
  `objectType` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '关联对象类型',
  PRIMARY KEY (`roleID`,`objectID`,`objectType`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

LOCK TABLES `role_object_rela` WRITE;
/*!40000 ALTER TABLE `role_object_rela` DISABLE KEYS */;

INSERT INTO `role_object_rela` (`roleID`, `objectID`, `objectType`)
VALUES
	('1000','AccountManage','AppItem'),
	('1000','AppManager','AppItem'),
	('1000','CodeManager','AppItem'),
	('1000','ContentManage','AppInfo'),
	('1000','ContractManage','AppItem'),
	('1000','ControlBoard','AppItem'),
	('1000','CustomerContact','AppItem'),
	('1000','CustomerGrade','AppInfo'),
	('1000','CustomerInfoManage','AppItem'),
	('1000','CustomerManage','AppInfo'),
	('1000','Customize','AppInfo'),
	('1000','DataWindow','AppItem'),
	('1000','DataWindowPage','AppItem'),
	('1000','DepotManage','AppItem'),
	('1000','EMailManage','AppInfo'),
	('1000','ImageManage','AppItem'),
	('1000','LayoutManager','AppItem'),
	('1000','Logoff','AppItem'),
	('1000','OperateMene','AppInfo'),
	('1000','OrderHistory','AppItem'),
	('1000','OrderProcess','AppItem'),
	('1000','OrderQuery','AppItem'),
	('1000','OrgManager','AppItem'),
	('1000','OutOfStorage','AppInfo'),
	('1000','PasswordManage','AppItem'),
	('1000','PersonalEmail','AppItem'),
	('1000','ProcessHistory','AppItem'),
	('1000','ProductManager','AppItem'),
	('1000','RiskCustomerManage','AppItem'),
	('1000','RoleManager','AppItem'),
	('1000','SampleManage','AppInfo'),
	('1000','SecondDevelop','AppInfo'),
	('1000','ServicePage','AppItem'),
	('1000','ShowDefaultMenu','AppItem'),
	('1000','StoreHourseSetting','AppInfo'),
	('1000','SystemManager','AppInfo'),
	('1000','SystemPage','AppItem'),
	('1000','SystemParamManager','AppItem'),
	('1000','TableObject','AppItem'),
	('1000','TestSystem1','AppInfo'),
	('1000','TimerTaskManager','AppItem'),
	('1000','TodayAttendance','AppInfo'),
	('1000','TrainMange','AppItem'),
	('1000','TrainQuery','AppItem'),
	('1000','UserManage','AppInfo'),
	('1000','UserManager','AppItem'),
	('1001','AccountManage','AppItem'),
	('1001','ContractManage','AppItem'),
	('1001','DataWindowPage','AppItem'),
	('1001','DepotManage','AppItem'),
	('1001','LayoutManager','AppItem'),
	('1001','Logoff','AppItem'),
	('1001','OperateMene','AppInfo'),
	('1001','OrderProcess','AppItem'),
	('1001','OrgManager','AppItem'),
	('1001','OutOfStorage','AppInfo'),
	('1001','PasswordManage','AppItem'),
	('1001','ProcessHistory','AppItem'),
	('1001','ProductManager','AppItem'),
	('1001','RoleManager','AppItem'),
	('1001','ShowDefaultMenu','AppItem'),
	('1001','StoreHourseSetting','AppInfo'),
	('1001','SystemManager','AppInfo'),
	('1001','SystemParamManager','AppItem'),
	('1001','TestSystem1','AppInfo'),
	('1001','TimerTaskManager','AppItem'),
	('1001','TodayAttendance','AppInfo'),
	('1001','TrainQuery','AppItem'),
	('1001','UserManage','AppInfo'),
	('1001','UserManager','AppItem'),
	('1002','TrainMange','AppItem'),
	('1002','TrainQuery','AppItem'),
	('2001','AccountManage','AppItem'),
	('2001','ContentManage','AppInfo'),
	('2001','ContractManage','AppItem'),
	('2001','CustomerContact','AppItem'),
	('2001','CustomerInfoManage','AppItem'),
	('2001','CustomerManage','AppInfo'),
	('2001','EMailManage','AppInfo'),
	('2001','ImageManage','AppItem'),
	('2001','Logoff','AppItem'),
	('2001','OrderHistory','AppItem'),
	('2001','OrderQuery','AppItem'),
	('2001','PasswordManage','AppItem'),
	('2001','PersonalEmail','AppItem'),
	('2001','RiskCustomerManage','AppItem'),
	('2001','ShowDefaultMenu','AppItem'),
	('2001','TodayAttendance','AppInfo'),
	('2001','TrainQuery','AppItem'),
	('2001','UserManage','AppInfo'),
	('2002','AccountManage','AppItem'),
	('2002','ContractManage','AppItem'),
	('2002','DepotManage','AppItem'),
	('2002','Logoff','AppItem'),
	('2002','OutOfStorage','AppInfo'),
	('2002','PasswordManage','AppItem'),
	('2002','ProductManager','AppItem'),
	('2002','SampleManage','AppInfo'),
	('2002','ShowDefaultMenu','AppItem'),
	('2002','StoreHourseSetting','AppInfo'),
	('2002','SystemManager','AppInfo'),
	('2002','UserManage','AppInfo'),
	('2003','ContractManage','AppItem'),
	('2003','DataMiningMgr','AppInfo'),
	('2003','NewsMgr','AppInfo'),
	('2003','NewsOnline','AppItem');

/*!40000 ALTER TABLE `role_object_rela` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table sample_info
# ------------------------------------------------------------

DROP TABLE IF EXISTS `sample_info`;

CREATE TABLE `sample_info` (
  `SerialNo` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '样品编号',
  `SampleName` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '样品名称',
  `SamplePrice` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '样品价格',
  `Currency` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '币种',
  `SampleSpecification` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT '样品规格',
  `Supplier` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT '供应商',
  `Manufacturer` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT '生产厂商',
  `SampleImage` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT '样品图片',
  `ProductNo` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '产品编号',
  `UpdateUserID` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '更新人',
  `UpdateDate` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '更新日期',
  `InputUserID` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '登记人',
  `InputDate` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '登记日期',
  PRIMARY KEY (`SerialNo`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

LOCK TABLES `sample_info` WRITE;
/*!40000 ALTER TABLE `sample_info` DISABLE KEYS */;

INSERT INTO `sample_info` (`SerialNo`, `SampleName`, `SamplePrice`, `Currency`, `SampleSpecification`, `Supplier`, `Manufacturer`, `SampleImage`, `ProductNo`, `UpdateUserID`, `UpdateDate`, `InputUserID`, `InputDate`)
VALUES
	('2015030701','asfasdf','1','RMB','sdf','','','','',NULL,NULL,'liuying','2015-03-07 23:22:33');

/*!40000 ALTER TABLE `sample_info` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table system_param
# ------------------------------------------------------------

DROP TABLE IF EXISTS `system_param`;

CREATE TABLE `system_param` (
  `paramname` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '参数名称',
  `paramvalue` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '参数值',
  `remark` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '参数说明',
  `rule` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '参数值规则',
  PRIMARY KEY (`paramname`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

LOCK TABLES `system_param` WRITE;
/*!40000 ALTER TABLE `system_param` DISABLE KEYS */;

INSERT INTO `system_param` (`paramname`, `paramvalue`, `remark`, `rule`)
VALUES
	('aes128Key','smartdmsverygood','Aes128秘钥','\w{16}'),
	('autoLogin','1','是否启用自动登录功能','[0,1]'),
	('blankURL','frame/blank.jsp','空白页面',NULL),
	('defaultLogLevel','7','设置默认的日志级别','[1-7]'),
	('domain','http://www.baidu.com?','CRM系统域地址','.*'),
	('dwInfoMaxItems','5','Info页面单行可配最大栏目数','[1-5]'),
	('firewall','1','是否启用防火墙功能,[0:关闭,1:启用]
启用后会对用户的所有操作进行权限验证','[0,1]'),
	('httpOrHttpsSwitch','1','1:https;0:http','[0,1]'),
	('i18nPath','i18n/Application','国际化文件存放目录','.*'),
	('lockTime','1','锁定账户时长,单位分钟','\d'),
	('loginFailTimes','3','用户运行登录失败次数','\d'),
	('openDwQuery','1','是否启用DataWindow搜索功能','[0,1]'),
	('openRegister','1','是否开放用户注册功能','[0,1]'),
	('openWorkBench','1','是否启用工作台功能','[0,1]'),
	('safeLogin','1','是否启用用户安全登录,若用户登录失败次数超过指定值,则锁定该账户','[0,1]'),
	('serviceCapacity','100','系统默认支持的每天业务量','[1-9]+\d{1,4}'),
	('singleSessionLogin','1','是否单会话登录,若同一用户在两处登录,则先登录的会话将失效','[0,1]'),
	('sysThemes','default','系统主题black、bootstrap、default、gray、metro','(black)|(bootstrap)|(default)|(gray)|(metro)'),
	('systemName','Smart CRM','应用系统名称','.*'),
	('verifyCode','0','是否使用验证码','[0,1]');

/*!40000 ALTER TABLE `system_param` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table table_object
# ------------------------------------------------------------

DROP TABLE IF EXISTS `table_object`;

CREATE TABLE `table_object` (
  `TABLENAME` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '表名',
  `FIELDNAME` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '字段名',
  `COLREMARK` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '备注',
  `DATATYPE` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '数据类型',
  `SORTNO` varchar(4) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '排序号',
  `ISKEY` varchar(1) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '是否主键',
  PRIMARY KEY (`TABLENAME`,`FIELDNAME`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

LOCK TABLES `table_object` WRITE;
/*!40000 ALTER TABLE `table_object` DISABLE KEYS */;

INSERT INTO `table_object` (`TABLENAME`, `FIELDNAME`, `COLREMARK`, `DATATYPE`, `SORTNO`, `ISKEY`)
VALUES
	('APP_INFO','APPID','系统编号','12','0010','1'),
	('APP_INFO','APPNAME','子系统名称','12','0020','0'),
	('APP_INFO','ISINUSE','是否可用','12','0050','0'),
	('APP_INFO','LOGO','是否可用','12','0070','0'),
	('APP_INFO','MINLOGO','小图标','12','0080','0'),
	('APP_INFO','SORTNO','排序号','12','0040','0'),
	('APP_INFO','SUBJECT','应用科目','12','0030','0'),
	('APP_INFO','THUMBNAIL','','12','0100','0'),
	('APP_INFO','URL','连接地址','12','0090','0'),
	('APP_INFO','WORKBENCH','工作台显示','12','0060','0'),
	('APP_ITEM','APPID','子系统编号','12','0020','1'),
	('APP_ITEM','ISINUSE','是否可用','12','0060','0'),
	('APP_ITEM','ITEMID','栏目编号','12','0010','1'),
	('APP_ITEM','ITEMNAME','栏目名称','12','0030','0'),
	('APP_ITEM','SORTNO','排序号','12','0050','0'),
	('APP_ITEM','TRIGGERMODE','触发方式','12','0070','0'),
	('APP_ITEM','URL','链接地址','12','0080','0'),
	('APP_ITEM','WORKBENCH','工作台显示','12','0040','0'),
	('ATTACHMENT_INFO','FILENAME','附件名称','12','0040','0'),
	('ATTACHMENT_INFO','ID','附件ID','12','0010','1'),
	('ATTACHMENT_INFO','INPUTDATE','登记日期','12','0070','0'),
	('ATTACHMENT_INFO','INPUTUSERID','登记人','12','0060','0'),
	('ATTACHMENT_INFO','OBJECTNO','','12','0030','0'),
	('ATTACHMENT_INFO','OBJECTTYPE','','12','0020','0'),
	('ATTACHMENT_INFO','REALNAME','','12','0050','0'),
	('ATTENDANCE_INFO','ID','','12','0010','1'),
	('ATTENDANCE_INFO','INPUTDATE','考勤登记时间','12','0030','0'),
	('ATTENDANCE_INFO','USERID','用户ID','12','0020','0'),
	('CODE_CATALOG','CODENAME','代码名称','12','0040','0'),
	('CODE_CATALOG','CODENO','代码编号','12','0010','1'),
	('CODE_CATALOG','CODETYPE','代码类型','12','0030','0'),
	('CODE_CATALOG','REMARK','说明','12','0050','0'),
	('CODE_CATALOG','SORTNO','排序号','12','0020','0'),
	('CODE_LIBRARY','ATTR01','是否可用','12','0060','0'),
	('CODE_LIBRARY','CODENO','代码编号','12','0010','1'),
	('CODE_LIBRARY','ISINUSE','是否可用','12','0050','0'),
	('CODE_LIBRARY','ITEMNAME','栏目名称','12','0030','0'),
	('CODE_LIBRARY','ITEMNO','栏目编号','12','0020','1'),
	('CODE_LIBRARY','SORTNO','排序号','12','0040','0'),
	('CONTACT_BOOK','ADDRESS','联系地址','12','0080','0'),
	('CONTACT_BOOK','CELLPHONE','手机号码','12','0100','0'),
	('CONTACT_BOOK','CONTACTNO','联系账号','12','0130','0'),
	('CONTACT_BOOK','CONTACTTYPE','联系方式','12','0120','0'),
	('CONTACT_BOOK','CUSTOMERNAME','联系人姓名','12','0030','0'),
	('CONTACT_BOOK','DEPARTMENT','部门','12','0050','0'),
	('CONTACT_BOOK','EMAIL','Email','12','0070','0'),
	('CONTACT_BOOK','FAXNUMBER','传真号码','12','0110','0'),
	('CONTACT_BOOK','PHONENUMBER','座机号码','12','0090','0'),
	('CONTACT_BOOK','POST','职务','12','0060','0'),
	('CONTACT_BOOK','RELATIVECUSTOMERID','关联客户编号','12','0020','0'),
	('CONTACT_BOOK','SERIALNO','序列号','12','0010','1'),
	('CONTACT_BOOK','SEX','性别','12','0040','0'),
	('CONTRACT_INFO','CONTENT','合同内容','-1','0030','0'),
	('CONTRACT_INFO','ID','合同编号','12','0010','1'),
	('CONTRACT_INFO','INPUTDATE','创建时间','12','0070','0'),
	('CONTRACT_INFO','INPUTUSERID','创建者','12','0060','0'),
	('CONTRACT_INFO','OBJECTID','关联对象ID','12','0040','0'),
	('CONTRACT_INFO','OBJECTTYPE','关联对象类型','12','0050','0'),
	('CONTRACT_INFO','TEMPLATEID','合同模板编号','12','0020','0'),
	('CONTRACT_INFO','UPDATEDATE','修改时间','12','0090','0'),
	('CONTRACT_INFO','UPDATEUSERID','修改者','12','0080','0'),
	('CONTRACT_TEMPLATE','CONTENT','合同模板内容','-1','0030','0'),
	('CONTRACT_TEMPLATE','ID','合同模板编号','12','0010','1'),
	('CONTRACT_TEMPLATE','INPUTDATE','创建时间','12','0050','0'),
	('CONTRACT_TEMPLATE','INPUTUSERID','创建者','12','0040','0'),
	('CONTRACT_TEMPLATE','TITLE','合同标题','12','0020','0'),
	('CONTRACT_TEMPLATE','UPDATEDATE','修改时间','12','0070','0'),
	('CONTRACT_TEMPLATE','UPDATEUSERID','修改者','12','0060','0'),
	('CUSTOMER_INFO','ADDRESS','详细地址','12','0080','0'),
	('CUSTOMER_INFO','BUSINESSTYPE','业务类型','12','0150','0'),
	('CUSTOMER_INFO','CITY','城市','12','0070','0'),
	('CUSTOMER_INFO','COUNTRY','国家','12','0050','0'),
	('CUSTOMER_INFO','CUSTOMERID','客户编号','12','0010','1'),
	('CUSTOMER_INFO','CUSTOMERNAME','客户编号','12','0020','0'),
	('CUSTOMER_INFO','CUSTOMERPOST','客户职务','12','0030','0'),
	('CUSTOMER_INFO','CUSTOMERRATING','用户等级','12','0120','0'),
	('CUSTOMER_INFO','CUSTOMERSOURCE','客户来源','12','0140','0'),
	('CUSTOMER_INFO','CUSTOMERTYPE','客户类型','12','0040','0'),
	('CUSTOMER_INFO','FAX','传真','12','0110','0'),
	('CUSTOMER_INFO','HOMEPAGE','主页','12','0160','0'),
	('CUSTOMER_INFO','INPUTDATE','录入日期','12','0220','0'),
	('CUSTOMER_INFO','INPUTUSERID','录入人员','12','0210','0'),
	('CUSTOMER_INFO','MAINPRODUCTS','主营产品','12','0130','0'),
	('CUSTOMER_INFO','PAYTIME','付款期限','12','0190','0'),
	('CUSTOMER_INFO','PHONE','号码','12','0100','0'),
	('CUSTOMER_INFO','PICTURE','客户照片','12','0200','0'),
	('CUSTOMER_INFO','PRICEARTICLE','价格条款','12','0170','0'),
	('CUSTOMER_INFO','PROVINCE','省份','12','0060','0'),
	('CUSTOMER_INFO','SETTLEWAY','结汇方式','12','0180','0'),
	('CUSTOMER_INFO','ZIPCODE','邮编','12','0090','0'),
	('DATAOBJECT_CATALOG','DONAME','模板名称','12','0020','0'),
	('DATAOBJECT_CATALOG','DONO','模板编号','12','0010','1'),
	('DATAOBJECT_CATALOG','DOREMARK','说明','12','0030','0'),
	('DATAOBJECT_CATALOG','HANDLER','handler类','12','0090','0'),
	('DATAOBJECT_CATALOG','ITEMNUM','从表','12','0080','0'),
	('DATAOBJECT_CATALOG','KEYSTRATEGY','主键值生成策略','12','0100','0'),
	('DATAOBJECT_CATALOG','MAINTABLE','主表','12','0050','0'),
	('DATAOBJECT_CATALOG','ORDERBY','排序','12','0070','0'),
	('DATAOBJECT_CATALOG','UNIONTABLE','从表','12','0060','0'),
	('DATAOBJECT_CATALOG','WHERESQL','where条件','12','0040','0'),
	('DATAOBJECT_EVENT','DONO','显示模板编号','12','0010','1'),
	('DATAOBJECT_EVENT','EVENT','显示模板编号','12','0030','1'),
	('DATAOBJECT_EVENT','FIELDCODE','显示模板编号','12','0020','1'),
	('DATAOBJECT_EVENT','ISINUSE','是否可用','12','0050','0'),
	('DATAOBJECT_EVENT','SCRIPT','事件执行方法','12','0040','0'),
	('DATAOBJECT_LIBRARY','AFTERFIELD','显示后缀','12','0100','0'),
	('DATAOBJECT_LIBRARY','COLFIELD','表字段','12','0060','0'),
	('DATAOBJECT_LIBRARY','COLSPAN','占用列数','12','0190','0'),
	('DATAOBJECT_LIBRARY','DATAOBJ','数据对象','12','0050','0'),
	('DATAOBJECT_LIBRARY','DONO','模板编号','12','0010','1'),
	('DATAOBJECT_LIBRARY','FIELDCODE','字段编号','12','0020','1'),
	('DATAOBJECT_LIBRARY','FIELDNAME','字段名称','12','0030','0'),
	('DATAOBJECT_LIBRARY','HTMLSOURCE','显示来源','12','0170','0'),
	('DATAOBJECT_LIBRARY','HTMLSTYLE','显示样式','12','0160','0'),
	('DATAOBJECT_LIBRARY','HTMLVAL','显示来源','12','0180','0'),
	('DATAOBJECT_LIBRARY','INVALIDMESSAGE','无效提示信息','12','0080','0'),
	('DATAOBJECT_LIBRARY','ISFILTER','是否可查询','12','0110','0'),
	('DATAOBJECT_LIBRARY','ISINUSE','是否可用','12','0150','0'),
	('DATAOBJECT_LIBRARY','ISREADONLY','是否只读','12','0140','0'),
	('DATAOBJECT_LIBRARY','ISREQUIRED','是否必须','12','0120','0'),
	('DATAOBJECT_LIBRARY','ISVISIBLE','是否可见','12','0130','0'),
	('DATAOBJECT_LIBRARY','REGEX','数据格式','12','0070','0'),
	('DATAOBJECT_LIBRARY','ROWSPAN','占用行数','12','0200','0'),
	('DATAOBJECT_LIBRARY','SHOWTAG','显示标签','12','0090','0'),
	('DATAOBJECT_LIBRARY','SORTNO','排序号','12','0040','0'),
	('DATAWINDOW_PAGE','BUTTONS','按钮组','12','0070','0'),
	('DATAWINDOW_PAGE','DATAGRIDEVENT','数据列表事件','12','0090','0'),
	('DATAWINDOW_PAGE','DATAGRIDSCRIPT','列表事件脚本','12','0100','0'),
	('DATAWINDOW_PAGE','DISPLAYSTYLE','显示风格','12','0050','0'),
	('DATAWINDOW_PAGE','DONO','显示模板编号','12','0040','0'),
	('DATAWINDOW_PAGE','DWPARAM','显示模板参数','12','0060','0'),
	('DATAWINDOW_PAGE','PAGENAME','页面名称','12','0020','0'),
	('DATAWINDOW_PAGE','PAGEPATH','页面路径','12','0010','1'),
	('DATAWINDOW_PAGE','PAGETYPE','页面类型','12','0030','0'),
	('DATAWINDOW_PAGE','SCRIPT','按钮组','-1','0080','0'),
	('DATA_MINER','CONTENT','','-4','0020','0'),
	('DATA_MINER','INPUTDATE','','12','0050','0'),
	('DATA_MINER','LINK','','12','0040','0'),
	('DATA_MINER','SERIALNO','','12','0010','1'),
	('DATA_MINER','TITLE','','12','0030','0'),
	('DEPOT_INFO','DEPOTADDRESS','仓库地址','12','0030','0'),
	('DEPOT_INFO','DEPOTNAME','仓库名字','12','0020','0'),
	('DEPOT_INFO','DEPOTNO','仓库编号','12','0010','1'),
	('GOODS_ACCESS','DEPOTNAME','仓库名称','12','0090','0'),
	('GOODS_ACCESS','DEPOTNO','关联仓库','12','0080','0'),
	('GOODS_ACCESS','GOODSCOUNT','货物数量','12','0040','0'),
	('GOODS_ACCESS','GOODSNAME','货物名称','12','0030','0'),
	('GOODS_ACCESS','INPUTDATE','登记日期','12','0110','0'),
	('GOODS_ACCESS','INPUTUSERID','登记人','12','0100','0'),
	('GOODS_ACCESS','PRODUCTNAME','产品类型','12','0070','0'),
	('GOODS_ACCESS','PRODUCTNO','产品编号','12','0060','0'),
	('GOODS_ACCESS','SAMPLENO','样品编号','12','0020','0'),
	('GOODS_ACCESS','SERIALNO','库存编号','12','0010','1'),
	('GOODS_ACCESS','STATUS','库存状态','12','0050','0'),
	('GOODS_ACCESS','UPDATEDATE','更新日期','12','0130','0'),
	('GOODS_ACCESS','UPDATEUSERID','更新人员','12','0120','0'),
	('LAYOUT_CATALOG','LAYOUTID','页面布局信息','12','0010','1'),
	('LAYOUT_CATALOG','LAYOUTNAME','布局名称','12','0020','0'),
	('LAYOUT_CATALOG','LAYOUTSTYLE','布局方式','12','0030','0'),
	('LAYOUT_CATALOG','SUBJECT','系统应用主题','12','0040','0'),
	('LAYOUT_ITEM','ISINUSE','是否可用','12','0060','0'),
	('LAYOUT_ITEM','LAYOUTID','布局ID','12','0010','1'),
	('LAYOUT_ITEM','PAGEID','组合页面ID','12','0020','1'),
	('LAYOUT_ITEM','PAGEURL','页面URL','12','0040','0'),
	('LAYOUT_ITEM','POSITION','页面定位','12','0050','0'),
	('LAYOUT_ITEM','SIZE','页面大小','12','0070','0'),
	('LAYOUT_ITEM','SPLIT','分隔符','12','0080','0'),
	('LAYOUT_ITEM','TITLE','页面标题','12','0030','0'),
	('NEWS_INFO','CONTENT','','-4','0090','0'),
	('NEWS_INFO','DOWNCOMMENT','','12','0080','0'),
	('NEWS_INFO','INPUTDATE','','12','0110','0'),
	('NEWS_INFO','INPUTUSERID','','12','0100','0'),
	('NEWS_INFO','NEWSCATALOG','','12','0020','0'),
	('NEWS_INFO','NEWSTITLE','新闻标题','12','0040','0'),
	('NEWS_INFO','PUBLISHDATE','发布日期','12','0060','0'),
	('NEWS_INFO','SERIALNO','','12','0010','1'),
	('NEWS_INFO','SOURCEHREF','','12','0030','0'),
	('NEWS_INFO','SOURCESITE','','12','0050','0'),
	('NEWS_INFO','UPCOMMENT','','12','0070','0'),
	('NEWS_INFO','UPDATEDATE','','12','0130','0'),
	('NEWS_INFO','UPDATEUSERID','','12','0120','0'),
	('ORG_INFO','BELONGORGID','率属机构','12','0060','0'),
	('ORG_INFO','ISINUSE','是否可用','12','0050','0'),
	('ORG_INFO','ORGID','机构编号','12','0010','1'),
	('ORG_INFO','ORGLEVEL','机构级别','12','0040','0'),
	('ORG_INFO','ORGNAME','机构名称','12','0020','0'),
	('ORG_INFO','SORTNO','排序号','12','0030','0'),
	('PRODUCT_ITEM','INPUTDATE','','12','0050','0'),
	('PRODUCT_ITEM','INPUTUSERID','','12','0040','0'),
	('PRODUCT_ITEM','PRODUCTNAME','','12','0020','0'),
	('PRODUCT_ITEM','PRODUCTNO','','12','0010','1'),
	('PRODUCT_ITEM','SORTNO','','12','0030','0'),
	('ROLE_INFO','AUTHGROUP','权限组','-1','0040','0'),
	('ROLE_INFO','ISTRUNK','是否为主类','12','0030','0'),
	('ROLE_INFO','ROLEID','角色ID','12','0010','1'),
	('ROLE_INFO','ROLENAME','角色名称','12','0020','0'),
	('ROLE_OBJECT_RELA','OBJECTID','关联对象ID','12','0020','1'),
	('ROLE_OBJECT_RELA','OBJECTTYPE','关联对象类型','12','0030','1'),
	('ROLE_OBJECT_RELA','ROLEID','角色编号','12','0010','1'),
	('SAMPLE_INFO','CURRENCY','币种','12','0040','0'),
	('SAMPLE_INFO','INPUTDATE','登记日期','12','0130','0'),
	('SAMPLE_INFO','INPUTUSERID','登记人','12','0120','0'),
	('SAMPLE_INFO','MANUFACTURER','生产厂商','12','0070','0'),
	('SAMPLE_INFO','PRODUCTNO','产品编号','12','0090','0'),
	('SAMPLE_INFO','SAMPLEIMAGE','样品图片','12','0080','0'),
	('SAMPLE_INFO','SAMPLENAME','样品名称','12','0020','0'),
	('SAMPLE_INFO','SAMPLEPRICE','样品价格','12','0030','0'),
	('SAMPLE_INFO','SAMPLESPECIFICATION','样品规格','12','0050','0'),
	('SAMPLE_INFO','SERIALNO','样品编号','12','0010','1'),
	('SAMPLE_INFO','SUPPLIER','供应商','12','0060','0'),
	('SAMPLE_INFO','UPDATEDATE','更新日期','12','0110','0'),
	('SAMPLE_INFO','UPDATEUSERID','更新人','12','0100','0'),
	('SYSTEM_PARAM','PARAMNAME','参数名称','12','0010','1'),
	('SYSTEM_PARAM','PARAMVALUE','参数值','12','0020','0'),
	('SYSTEM_PARAM','REMARK','参数说明','12','0030','0'),
	('SYSTEM_PARAM','RULE','参数值规则','12','0040','0'),
	('TABLE_OBJECT','COLREMARK','备注','12','0030','0'),
	('TABLE_OBJECT','DATATYPE','数据类型','12','0040','0'),
	('TABLE_OBJECT','FIELDNAME','字段名','12','0020','1'),
	('TABLE_OBJECT','ISKEY','是否主键','12','0060','0'),
	('TABLE_OBJECT','SORTNO','排序号','12','0050','0'),
	('TABLE_OBJECT','TABLENAME','表名','12','0010','1'),
	('TIMER_TASK','AUTOSTART','是否自动启动','12','0090','0'),
	('TIMER_TASK','FINISHTIME','终止时间','12','0050','0'),
	('TIMER_TASK','ID','定时任务ID','12','0010','1'),
	('TIMER_TASK','INPUTDATE','登记日期','12','0130','0'),
	('TIMER_TASK','INPUTUSERID','登记者','12','0120','0'),
	('TIMER_TASK','ISINUSE','是否可用','12','0080','0'),
	('TIMER_TASK','PERIOD','执行频率','12','0060','0'),
	('TIMER_TASK','PERIODTYPE','频率类型','12','0070','0'),
	('TIMER_TASK','STARTTIME','启动时间','12','0040','0'),
	('TIMER_TASK','TITLE','定时任务标题','12','0020','0'),
	('TIMER_TASK','TRIGGERCLASS','定时任务触发类','12','0030','0'),
	('TIMER_TASK','UPDATEDATE','修改日期','12','0110','0'),
	('TIMER_TASK','UPDATEUSERID','修改者','12','0100','0'),
	('USER_INFO','CONFIG','配置信息','-1','0070','0'),
	('USER_INFO','LASTLOGINTIME','上次登录时间','12','0060','0'),
	('USER_INFO','LOGINERROR','登录错误次数','12','0050','0'),
	('USER_INFO','ORGID','所属机构','12','0040','0'),
	('USER_INFO','PASSWORD','密码','12','0030','0'),
	('USER_INFO','USERID','用户编号','12','0010','1'),
	('USER_INFO','USERNAME','用户名','12','0020','0'),
	('USER_ROLE_RELA','ROLEID','角色编号','12','0020','1'),
	('USER_ROLE_RELA','USERID','用户编号','12','0010','1');

/*!40000 ALTER TABLE `table_object` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table timer_task
# ------------------------------------------------------------

DROP TABLE IF EXISTS `timer_task`;

CREATE TABLE `timer_task` (
  `id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '定时任务ID',
  `title` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT '定时任务标题',
  `triggerclass` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '定时任务触发类',
  `starttime` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '启动时间',
  `finishtime` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '终止时间',
  `period` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '执行频率',
  `periodtype` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '频率类型',
  `isinuse` varchar(1) COLLATE utf8_bin DEFAULT NULL COMMENT '是否可用',
  `autostart` varchar(1) COLLATE utf8_bin DEFAULT NULL COMMENT '是否自动启动',
  `updateuserid` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '修改者',
  `updatedate` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '修改日期',
  `inputuserid` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '登记者',
  `inputdate` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '登记日期',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

LOCK TABLES `timer_task` WRITE;
/*!40000 ALTER TABLE `timer_task` DISABLE KEYS */;

INSERT INTO `timer_task` (`id`, `title`, `triggerclass`, `starttime`, `finishtime`, `period`, `periodtype`, `isinuse`, `autostart`, `updateuserid`, `updatedate`, `inputuserid`, `inputdate`)
VALUES
	('2015022706','系统资源监控','net.vinote.smart.platform.timer.SystemMonitorTask','2015-02-28 14:36:55','2017-02-22 14:47:38','10','SECONDS','1','0','admin','2015-02-28 17:55:53','admin','2015-02-27 19:46:18'),
	('2015022801','系统定时任务监控','net.vinote.smart.platform.timer.SystemTaskMonitorTask','','','30','SECONDS','1','0','admin','2015-03-24 09:37:49','admin','2015-02-28 17:17:53'),
	('2015022802','缓存定时刷新','net.vinote.smart.platform.service.timer.CacheRefreshTask','2015-03-03 18:00:19','2028-06-21 18:05:26','30','MINUTES','1','1','admin','2015-03-11 15:24:16','admin','2015-02-28 17:27:41'),
	('2015030501','工行黄金采集','com.cms.task.IcbcGoldMiningTask','','','10','SECONDS','0','1','admin','2015-03-08 11:37:30','admin','2015-03-05 19:09:14'),
	('2015031001','License检测任务','net.vinote.smart.platform.service.timer.LicenseCheckTask','','','1','DAYS','1','1','admin','2015-03-11 15:23:59','admin','2015-03-10 20:16:42');

/*!40000 ALTER TABLE `timer_task` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table user_info
# ------------------------------------------------------------

DROP TABLE IF EXISTS `user_info`;

CREATE TABLE `user_info` (
  `userid` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '用户编号',
  `username` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '用户名',
  `password` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '密码',
  `orgid` varchar(6) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '所属机构',
  `loginerror` varchar(2) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '登录错误次数',
  `lastlogintime` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '上次登录时间',
  `config` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT '配置信息',
  PRIMARY KEY (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

LOCK TABLES `user_info` WRITE;
/*!40000 ALTER TABLE `user_info` DISABLE KEYS */;

INSERT INTO `user_info` (`userid`, `username`, `password`, `orgid`, `loginerror`, `lastlogintime`, `config`)
VALUES
	('admin','超级管理员','Kd1AyEvQhSxLgvMYOc7HKw==','','0','2018-03-14 11:47:46','{email:{user:'501190241@qq.com',password:'junweiis008',server:'qq',sendSSL:true,send:'smtp',receSSL:true,receive:'imap'}}'),
	('zjw','郑俊伟','OohASFk2YfXk7v/AjYcsBA==','','0','2015-03-11 16:12:50','{email:{user:'zhengjunweimail@163.com',password:'18268134120',server:'163',send:'smtp',receive:'imap'}}');

/*!40000 ALTER TABLE `user_info` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table user_role_rela
# ------------------------------------------------------------

DROP TABLE IF EXISTS `user_role_rela`;

CREATE TABLE `user_role_rela` (
  `userid` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '用户编号',
  `roleid` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '角色编号',
  PRIMARY KEY (`roleid`,`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

LOCK TABLES `user_role_rela` WRITE;
/*!40000 ALTER TABLE `user_role_rela` DISABLE KEYS */;

INSERT INTO `user_role_rela` (`userid`, `roleid`)
VALUES
	('admin','1000'),
	('admin','1001'),
	('admin','2001'),
	('test','2001'),
	('admin','2002'),
	('admin','2003'),
	('zjw','2003');

/*!40000 ALTER TABLE `user_role_rela` ENABLE KEYS */;
UNLOCK TABLES;



/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;