下拉框的初始化

最新推荐文章于 2024-05-11 15:15:10 发布

ti_baby_hu

最新推荐文章于 2024-05-11 15:15:10 发布

阅读量1.3k

点赞数

分类专栏： Easyui Javascript

本文链接：https://blog.csdn.net/ti_baby_hu/article/details/51725519

版权

Javascript 同时被 2 个专栏收录

3 篇文章 0 订阅

订阅专栏

Easyui

2 篇文章 0 订阅

订阅专栏

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);

ti_baby_hu

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
下拉框的初始化

initOptionItems("enable","USER","ENABLE",false);function initOptionItems(controlId,module,optionCode,flag){ var jsonObject = {}; jsonObject.module=module; jsonObject.optionCode=optionCode;
复制链接

扫一扫

专栏目录