带有edittype select且为true时，select框未加载数据 [英] With edittype select and multiple true, select box is not loading data
问题描述
我在jqGrid中具有选择框，并使用dataUrl加载数据m.一切工作正常，但是当我将multiple设置为true时，数据没有显示在网格中，而是在控制台中打印了数据. Google搜索了很多，但是找不到解决方案.
I have select box in jqGrid and to load data m using dataUrl. Everything is working fine but when I put multiple as true then data is not getting displayed in the grid but in the console its printing the data. Googled a lot but couldn't find solution.
$(document).ready(function () {
var lastsel;
var skip = 0;
jQuery("#list").jqGrid({
url: 'SomeActionClass.do?option=LOAD',
datatype: "json",
colNames: [],
colModel: [
{ name: 'generalised_skill_id', index: 'generalised_skill_id',
width: 120, formoptions: { rowpos: 2, colpos: 1 },
editable: true, edittype: "select",
editoptions: {
dataEvents: [
{
type: 'change',
fn: function (e) {
var Value = $(this).val();
if (Value == "CreateNew") {
addSkill(Value);
}
}
}],
dataUrl: 'PopulatePrimarySkillData.do?nd=' + Math.random()
}
},
{ name: 'primary_skill_ids', index: 'primary_skill_ids', width: 120,
formoptions: { rowpos: 2, colpos: 2 },
editable: true, editrules: { required: true }, edittype: "select",
editoptions: {
dataEvents: [
{
type: 'change',
fn: function (e) {
var Value = $(this).val();
if (Value == "CreateNew") {
addSkill(Value);
}
}
}],
value: "", multiple: true, size: 3,
dataUrl: 'PopulatePrimarySkillData.do?nd=' + Math.random()
}
},
],
rowNum: 25,
rowList: [25, 50, 75, 100],
pager: '#pager',
rowTotal: 10000,
sortname: 'rgs_id',
viewrecords: true,
height: 600,
sortorder: "asc",
multiselect: true,
mtype: "POST",
gridview: true,
ignoreCase: true,
loadonce: true,
loadComplete: function () {
$('#list').setGridParam({ datatype: "json" });
$('#list').trigger("filterToolbar");
$('#list').trigger("reloadGrid");
},
ondblClickRow: function (id) {
if (id && id !== lastsel) {
data = jQuery('#list').getRowData(id);
var str = data['status'];
if (str == "Fulfilled" || str == "Canceled") {
alert('Fulfilled and Cancelled demands can not be edited');
} else {
jQuery('#list').jqGrid('restoreRow', lastsel);
jQuery('#list').jqGrid('editRow', id, true, pickdates);
lastsel = id;
}
}
},
editurl: 'SomeActionClass.do?option=EDITorADD'
});
});
对于一般技能，它会加载选择框，但对于主要技能，它不加载任何内容.但是，如果我从主要技能中删除了multiple:true，那么它将加载数据.
For generalised skill its loading the select box but for primary skill its not loading anything. However if I remove multiple:true from primary skill then its loading the data.
任何帮助将不胜感激.
以下是我的PopulatePrimarySkillData类.
Following is my PopulatePrimarySkillData class.
// In this function query to fetch all the skills from database is written.
ArrayList primarySkillList = fetchPrimarySkills();
StringBuilder htmlSelectString = new StringBuilder("<select> ");
for (int i = 0; i < primarySkillList.size(); i++) {
SkillsetBean sb = (SkillsetBean) primarySkillList.get(i);
htmlSelectString.append("<option value='");
htmlSelectString.append(sb.getPrimarySkillId());
htmlSelectString.append("'>");
htmlSelectString.append(sb.getPrimarySkillDesc());
htmlSelectString.append("</option>");
}
htmlSelectString
.append("<option value='CreateNew'>Create New</option> ");
htmlSelectString.append("</select> ");
PrintWriter out = response.getWriter();
System.out.println("The SELECT String is : "
+ htmlSelectString.toString());
out.println(htmlSelectString.toString());
return null;
此功能在控制台中打印以下结果.
This Function prints following result in the console.
<select> <option value='1'>.Net</option>
<option value='2'>Appl packaging</option>
<option value='3'>BOXI</option>
<option value='4'>Business Analyst</option>
<option value='5'>C++</option>
<option value='6'>CNG</option>
<option value='7'>DB2</option>
<option value='8'>Flash</option>
<option value='9'>IIS Admin</option>
<option value='10'>Informatica</option>
<option value='11'>Java / J2EE</option>
<option value='12'>Java Flex</option>
<option value='13'>MS Access</option>
<option value='14'>Mainframe</option>
<option value='15'>NAT/ADABAS</option>
<option value='16'>Oracle</option>
<option value='17'>Oracle DBA</option>
<option value='18'>Others</option>
</select>
我认为，在服务器端，删除"multiple:true"数据正在加载时没有问题.
I think on server side there is no problem cause when I remove "multiple:true" data is getting loaded.
这是示例JSON数据.我希望这会有所帮助.
Here is the sample JSON data. I hope this is helpfull.
{"id":"166","cell":["Business Analyst","BOXI,C++"]}
{"id":"167","cell":["C++",".Net,C++"]}
{"id":"168","cell":[".Net",".Net,CNG"]}
{"id":"169","cell":["Business Analyst","Appl packaging,Business Analyst"]}
{"id":"170","cell":["Business Analyst,C++","CICS,Cobol"]}
{"id":"171","cell":[,"Appl packaging",".Net,Business Analyst"]}
{"id":"172","cell":["CNG","BOXI,Appl packaging"]}
{"id":"173","cell":["Business Analyst","Business Analyst,BOXI"]}
推荐答案
您遇到了一部分问题(jqGrid错误)，我在向jqGrid开发人员提交的错误报告.错误仍未修复，因此您尝试在Internet Explorer中重现您的问题演示:
You have a part of problems (jqGrid bugs) which I described in the answer and which I posted as the bug report to the developer of jqGrid. The bugs are still not fixed so you my attempts to reproduces your problem in Internet Explorer the demo:
我使用IE9进行测试.如果您从
修复jquery.jqGrid.src.js(版本4.1.2)的8217行
I used IE9 for the test. If you fix the line 8217 of the jquery.jqGrid.src.js (version 4.1.2) from
if(cm[i].edittype == "select" && cm[i].editoptions.multiple===true && $.browser.msie) {
到
if(cm[i].edittype === "select" && typeof(cm[i].editoptions)!=="undefined" && cm[i].editoptions.multiple===true && typeof(cm[i].editoptions.dataUrl)==="undefined" && $.browser.msie) {
问题将得到解决，您将有
the problem will be fixed and you will have
(请参见相同的演示，但使用固定jquery.jqGrid.src.js).
(See the same demo, but which use the fixed jquery.jqGrid.src.js).
此外，我在评论中给您写信，该尝试会生成dataUrl中使用的唯一URL，
Moreover I wrote you in the comment that the attempt generate unique URL used in dataUrl with
dataUrl: 'PopulatePrimarySkillData.do?nd=' + Math.random()
生成一个网址，如
PopulatePrimarySkillData.do?nd=0.30184902572188804
如果您将使用dataUrl: 'PopulatePrimarySkillData.do并且将使用附加参数ajaxSelectOptions: { cache: false }，则将要使用的dataUrl将会非常独特，例如
If you would use dataUrl: 'PopulatePrimarySkillData.do and will use additional parameter ajaxSelectOptions: { cache: false } the dataUrl which will be used will be really unique like
PopulatePrimarySkillData.do?_=1312564872215
PopulatePrimarySkillData.do?_=1312564872217
PopulatePrimarySkillData.do?_=1312564891288
...
这篇关于带有edittype select且为true时，select框未加载数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
