如何在jqgrid中填充mysql的select下拉列表

s4n0splo  于 2021-09-29  发布在  Java
关注(0)|答案(0)|浏览(284)

**>你好,我是一个初学者开发人员。

选择“largecategoryzone”时,使用ASCICODE将其分隔,以从db中检索值。
我想把这些值放在“smallcategoryzone”中。下面的内容是我的代码。请检查并回答我**

  1. $(document).ready(function () {
  2. $("#AdminCheckJqGrid").jqGrid({
  3. url: "../barcode/barcodeAdminCheckInquiry/1",
  4. datatype: "json",
  5. loadtext: "loading...",
  6. method: "GET",
  7. postData: {
  8. "certificateNumber": $("#certificateNumber").val()
  9. },
  10. colNames: ['sku', 'label', 'qty', 'realQty', 'palletType', 'palletBarcode','largeCategoryZone','middleCategoryZone','smallCategoryZone', 'remark'],
  11. colModel: [
  12. {label: 'sku', name: 'sku', width: '30', align: 'center'},
  13. {label: 'label', name: 'label', width: '60', align: 'center'},
  14. {label: 'qty', name: 'qty', width: '20', align: 'center'},
  15. {label: 'realQty', name: 'realQty', width: 30,align: 'center', sortable: false, editable: true},
  16. {label: 'palletType', name: 'palletType', width: 40, align: 'center', editable: true, edittype: 'select', editoptions: {dataUrl: '../code/palletType', buildSelect: setSelect}},
  17. {label: 'palletBarcode', name: 'palletBarcode', width: 40, align: 'center', editable: true, edittype: 'select', editoptions: {dataUrl: '../code/palletBarcode', buildSelect: palletBarcodeSelect}},
  18. {label: 'largeCategoryZone', name: 'largeCategoryZone', width: 40, align: 'center', editable: true, edittype: 'select', editoptions: {dataUrl: '../code/largeCategoryZone', buildSelect:setSelect ,
  19. dataEvents: [{
  20. type: 'change',
  21. fn: function (e) {
  22. var selectedData = e.currentTarget.value;
  23. var dataFrist = selectedData.substr(0,1);
  24. var dataAscii = dataFrist.charCodeAt();
  25. $.ajax({
  26. url: '../code/largeCategoryZone/' + dataAscii,
  27. type: 'GET',
  28. success: function (data) {
  29. var jdata = jQuery.parseJSON(data).result;
  30. var selectHtml = "";
  31. for(var i=0; i < jdata.length; i++){
  32. selectHtml += "<option value='" + jdata[i].subcode + "'>" + jdata[i].codename + "</option>";
  33. }
  34. if ($(e.target).is('.FormElement')) {
  35. var form = $(e.target).closest('form.FormGrid');
  36. console.log("form"+form);
  37. $("select#smallCategoryZone.FormElement", form[0]).html(selectHtml);
  38. } else {
  39. var row = $(e.target).closest('tr.jqgrow');
  40. var rowId = row.attr('id');
  41. var rowId = jQuery("#AdminCheckJqGrid").jqGrid('getGridParam','selrow');
  42. jQuery("select#" + rowId + "_smallCategoryZone").append(selectHtml);
  43. }
  44. }
  45. });
  46. }}]}},
  47. {label: 'middleCategoryZone', name: 'middleCategoryZone', width: 40, align: 'center', editable: true, edittype: 'select', editoptions: {dataUrl: '../code/largeCategoryZone', buildSelect: setSelect}},
  48. {label: 'smallCategoryZone', name: 'smallCategoryZone', width: 40, align: 'center', editable: true, edittype: 'select',editoptions: { } },
  49. {label: 'remark', name: 'remark', width: 50, sortable: false, editable: true, align: 'center', editoptions: {autocomplete: "off"}},
  50. ],
  51. });
  52. });

暂无答案!

目前还没有任何答案,快来回答吧!

相关问题