initOptionItems("enable","USER","ENABLE",false);
function initOptionItems(controlId,module,optionCode,flag){
var jsonObject = {};
jsonObject.module=module;
jsonObject.optionCode=optionCode;
$.ajax({
url:"/ccs/common/initOptionsItem",
async:flag,
data:jsonObject,
dataType:"json",
success:function(data){
if(data.result != 'E'){
var content = "";
$.each(data,function(index,item){
content += "<option value=\""+item.itemKey+"\">" +item.itemName+"</option>" ;
});
$("#"+controlId).html(content);
}else{
$.messager.show({
title:'提示',
msg:data.errorMsg,
timeout:3000,
showType:'fade',
style:{
right:'',
bottom:''
}
});
}
}
});
};
表格字段如下
/*
Navicat MySQL Data Transfer
Source Server : ccs
Source Server Version : 50051
Source Host : 192.168.0.7:3306
Source Database : ccs
Target Server Type : MYSQL
Target Server Version : 50051
File Encoding : 65001
Date: 2016-06-21 10:31:43
*/
SET FOREIGN_KEY_CHECKS=0;
– Table structure for shrg_os_parameter_option_t
DROP TABLE IF EXISTS shrg_os_parameter_option_t
;
CREATE TABLE shrg_os_parameter_option_t
(
id
int(20) NOT NULL auto_increment,
option_code
varchar(50) default NULL COMMENT ‘选项组code’,
option_description
varchar(200) default NULL COMMENT ‘选项组描述’,
module
varchar(10) default NULL COMMENT ‘模块’,
enable_flag
char(1) default NULL COMMENT ‘是否启用’,
created_by
int(10) default NULL COMMENT ‘创建人’,
creation_date
datetime default NULL COMMENT ‘创建日期’,
last_update_by
int(10) default NULL COMMENT ‘最后更新人’,
last_update_date
datetime default NULL COMMENT ‘最后更新时间’,
attribute1
varchar(150) default NULL,
attribute2
varchar(150) default NULL,
attribute3
varchar(150) default NULL,
attribute4
varchar(150) default NULL,
attribute5
varchar(150) default NULL,
PRIMARY KEY (id
),
UNIQUE KEY shlg_os_parameter_option_01
USING BTREE (option_code
)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;
– Records of shrg_os_parameter_option_t
INSERT INTO shrg_os_parameter_option_t
VALUES (‘1’, ‘HANDLE_TYPE’, ‘处理方式’, ‘TER’, ‘Y’, null, null, null, null, null, null, null, null, null);
INSERT INTO shrg_os_parameter_option_t
VALUES (‘2’, ‘SHOT_SCREEN’, ‘截屏’, ‘TER’, ‘Y’, null, null, null, null, null, null, null, null, null);
INSERT INTO shrg_os_parameter_option_t
VALUES (‘3’, ‘SEND_FLAG’, ‘发送标志’, ‘TER’, ‘Y’, null, null, null, null, null, null, null, null, null);
INSERT INTO shrg_os_parameter_option_t
VALUES (‘4’, ‘SEX’, ‘性别’, ‘USER’, ‘Y’, null, null, null, null, null, null, null, null, null);
INSERT INTO shrg_os_parameter_option_t
VALUES (‘5’, ‘ENABLE’, ‘是否启用’, ‘USER’, ‘Y’, null, null, null, null, null, null, null, null, null);
INSERT INTO shrg_os_parameter_option_t
VALUES (‘6’, ‘VOLUME’, ‘音量’, ‘TER’, ‘Y’, null, null, null, null, null, null, null, null, null);
INSERT INTO shrg_os_parameter_option_t
VALUES (‘7’, ‘SWITCH_MACHINE’, ‘开关机’, ‘TER’, ‘Y’, null, null, null, null, null, null, null, null, null);
INSERT INTO shrg_os_parameter_option_t
VALUES (‘8’, ‘TERMINAL_TYPE’, ‘终端类型’, ‘TER’, ‘Y’, null, null, null, null, null, null, null, null, null);
INSERT INTO shrg_os_parameter_option_t
VALUES (‘9’, ‘TERMINAL_PASSWORD’, ‘终端密码’, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO shrg_os_parameter_option_t
VALUES (‘10’, ‘PAD_CLASS’, ‘年级’, ‘PAD’, ‘Y’, null, null, null, null, null, null, null, null, null);
INSERT INTO shrg_os_parameter_option_t
VALUES (‘11’, ‘CALL_ACTION’, ‘动作’, ‘TER’, ‘Y’, null, null, null, null, null, null, null, null, null);
/*
Navicat MySQL Data Transfer
Source Server : ccs
Source Server Version : 50051
Source Host : 192.168.0.7:3306
Source Database : ccs
Target Server Type : MYSQL
Target Server Version : 50051
File Encoding : 65001
Date: 2016-06-21 10:31:49
*/
SET FOREIGN_KEY_CHECKS=0;
– Table structure for shrg_os_option_item_tl
DROP TABLE IF EXISTS shrg_os_option_item_tl
;
CREATE TABLE shrg_os_option_item_tl
(
id
int(10) NOT NULL auto_increment,
option_id
int(10) default NULL COMMENT ‘选择组ID’,
item_key
varchar(50) default NULL COMMENT ‘选择key值,这个用于存数据库’,
item_name
varchar(200) default NULL COMMENT ‘选择名称’,
order_number
int(5) default NULL,
enable_flag
char(1) default NULL,
language
varchar(10) default NULL COMMENT ‘语言’,
created_by
int(10) default NULL COMMENT ‘创建人’,
creation_date
datetime default NULL COMMENT ‘创建日期’,
last_update_by
int(10) default NULL COMMENT ‘最后更新人’,
last_update_date
datetime default NULL COMMENT ‘最后更新时间’,
attribute1
varchar(200) default NULL,
attribute2
varchar(200) default NULL,
PRIMARY KEY (id
),
UNIQUE KEY shrg_os_option_unique
(item_key
)
) ENGINE=MyISAM AUTO_INCREMENT=29 DEFAULT CHARSET=utf8;
– Records of shrg_os_option_item_tl
INSERT INTO shrg_os_option_item_tl
VALUES (‘1’, ‘1’, ‘PC’, ‘客户端’, ‘1’, ‘Y’, ‘zh_CN’, null, null, null, null, null, null);
INSERT INTO shrg_os_option_item_tl
VALUES (‘2’, ‘1’, ‘COM’, ‘串口’, ‘2’, ‘Y’, ‘zh_CN’, null, null, null, null, null, null);
INSERT INTO shrg_os_option_item_tl
VALUES (‘19’, ‘3’, ‘SENDING’, ‘发送中’, ‘3’, ‘Y’, ‘zh_CN’, null, null, null, null, null, null);
INSERT INTO shrg_os_option_item_tl
VALUES (‘3’, ‘2’, ‘REAL_SHOT_SCREEN’, ‘实时截屏’, ‘1’, ‘Y’, ‘zh_CN’, null, null, null, null, null, null);
INSERT INTO shrg_os_option_item_tl
VALUES (‘4’, ‘2’, ‘TIMING_SHOT_SCREEN’, ‘定时截屏’, ‘2’, ‘Y’, ‘zh_CN’, null, null, null, null, null, null);
INSERT INTO shrg_os_option_item_tl
VALUES (‘5’, ‘2’, ‘STOP_SHOT_SCREEN’, ‘停止截屏’, ‘3’, ‘Y’, ‘zh_CN’, null, null, null, null, null, null);
INSERT INTO shrg_os_option_item_tl
VALUES (‘6’, ‘3’, ‘S’, ‘发送成功’, ‘1’, ‘Y’, ‘zh_CN’, null, null, null, null, null, null);
INSERT INTO shrg_os_option_item_tl
VALUES (‘7’, ‘3’, ‘E’, ‘发送失败’, ‘2’, ‘Y’, ‘zh_CN’, null, null, null, null, null, null);
INSERT INTO shrg_os_option_item_tl
VALUES (‘8’, ‘4’, ‘MALE’, ‘男’, ‘1’, ‘Y’, ‘zh_CN’, null, null, null, null, null, null);
INSERT INTO shrg_os_option_item_tl
VALUES (‘9’, ‘4’, ‘FEMALE’, ‘女’, ‘2’, ‘Y’, ‘zh_CN’, null, null, null, null, null, null);
INSERT INTO shrg_os_option_item_tl
VALUES (‘10’, ‘5’, ‘Y’, ‘是’, ‘1’, ‘Y’, ‘zh_CN’, null, null, null, null, null, null);
INSERT INTO shrg_os_option_item_tl
VALUES (‘11’, ‘5’, ‘N’, ‘否’, ‘2’, ‘Y’, ‘zh_CN’, null, null, null, null, null, null);
INSERT INTO shrg_os_option_item_tl
VALUES (‘12’, ‘6’, ‘0A’, ‘10’, ‘1’, ‘Y’, ‘zh_CN’, null, null, null, null, null, null);
INSERT INTO shrg_os_option_item_tl
VALUES (‘13’, ‘6’, ‘10’, ‘16’, ‘2’, ‘Y’, ‘zh_CN’, null, null, null, null, null, null);
INSERT INTO shrg_os_option_item_tl
VALUES (‘14’, ‘6’, ‘1E’, ‘30’, ‘3’, ‘Y’, ‘zh_CN’, null, null, null, null, null, null);
INSERT INTO shrg_os_option_item_tl
VALUES (‘15’, ‘7’, ‘MACHINE_OPEN’, ‘开机’, ‘1’, ‘Y’, ‘zh_CN’, null, null, null, null, null, null);
INSERT INTO shrg_os_option_item_tl
VALUES (‘16’, ‘7’, ‘MACHINE_CLOSE’, ‘关机’, ‘2’, ‘Y’, ‘zh_CN’, null, null, null, null, null, null);
INSERT INTO shrg_os_option_item_tl
VALUES (‘17’, ‘8’, ‘TER_GROUP’, ‘群组’, ‘1’, ‘Y’, ‘zh_CN’, null, null, null, null, null, null);
INSERT INTO shrg_os_option_item_tl
VALUES (‘18’, ‘8’, ‘TER_PC’, ‘PC’, ‘2’, ‘Y’, ‘zh_CN’, null, null, null, null, null, null);
INSERT INTO shrg_os_option_item_tl
VALUES (‘20’, ‘9’, ‘TERMINAL_PASSWORD’, ‘终端密码’, ‘1’, ‘Y’, ‘zh_CN’, null, null, null, null, null, null);
INSERT INTO shrg_os_option_item_tl
VALUES (‘21’, ‘10’, ‘PAD_CLASS_1’, ‘一年级’, ‘1’, ‘Y’, ‘zh_CN’, null, null, null, null, null, null);
INSERT INTO shrg_os_option_item_tl
VALUES (‘22’, ‘10’, ‘PAD_CLASS_2’, ‘二年级’, ‘2’, ‘Y’, ‘zh_CN’, null, null, null, null, null, null);
INSERT INTO shrg_os_option_item_tl
VALUES (‘23’, ‘10’, ‘PAD_CLASS_3’, ‘三年级’, ‘3’, ‘Y’, ‘zh_CN’, null, null, null, null, null, null);
INSERT INTO shrg_os_option_item_tl
VALUES (‘24’, ‘10’, ‘PAD_CLASS_4’, ‘四年级’, ‘4’, ‘Y’, ‘zh_CN’, null, null, null, null, null, null);
INSERT INTO shrg_os_option_item_tl
VALUES (‘25’, ‘10’, ‘PAD_CLASS_5’, ‘五年级’, ‘5’, ‘Y’, ‘zh_CN’, null, null, null, null, null, null);
INSERT INTO shrg_os_option_item_tl
VALUES (‘26’, ‘10’, ‘PAD_CLASS_6’, ‘六年级’, ‘6’, ‘Y’, ‘zh_CN’, null, null, null, null, null, null);
INSERT INTO shrg_os_option_item_tl
VALUES (‘27’, ‘11’, ‘1’, ‘主动’, ‘1’, ‘Y’, ‘zh_CN’, null, null, null, null, null, null);
INSERT INTO shrg_os_option_item_tl
VALUES (‘28’, ‘11’, ‘0’, ‘被动’, ‘2’, ‘Y’, ‘zh_CN’, null, null, null, null, null, null);