Jqgrid edit dialog onchange show value to another textbox[Answered] RSS

• • Reply
  micnie2020

  Member

  124 Points

  791 Posts

  Jqgrid edit dialog onchange show value to another textbox

  Dec 02, 2019 05:55 AM|micnie2020|LINK

  Hi All,

  I have 

  Option 1:

  var gbp = 0.00;
function GbpValSet(val) {
var thisval = val;
var f = $("#Curr").val();
$.post('@Url.Content("~/Agreement/getCurrencyRate")',
{ "Curr": f, "__RequestVerificationToken": '@GetAntiXsrfRequestToken()' },
function (data) {
gbp=((1/parseFloat(data)) * parseFloat(thisval)).toFixed(2);
}).done(function () {
alert(gbp);
$("#AmountGbp").attr("value", gbp);
});
}

  Option 2:

  var gbp = 0.00;
function GbpValSet(val, e) {
var thisval = val;
var f = $("#Curr").val();
$.post('@Url.Content("~/Agreement/getCurrencyRate")',
{ "Curr": f, "__RequestVerificationToken": '@GetAntiXsrfRequestToken()' },
function (data) {
gbp=((1/parseFloat(data)) * parseFloat(thisval)).toFixed(2);
}).done(function () {


// populate descriptionEditHtml in the "description" edit cell
if ($(e.target).is('.FormElement')) {
// form editing
var form = $(e.target).closest('form.FormGrid');
alert("A");
$("#AmountGbp.FormElement",form[0]).html(gbp);
} else {
// inline editing
var row = $(e.target).closest('tr.jqgrow');
var rowId = row.attr('Id');
alert("B");
debugger;
$("#"+rowId+"_AmountGbp",row[0]).html(gbp);
}
});
}

  JQGRID Code

  {
name: 'Amount',
index: 'Amount',
label: 'Amount',
width: 130,
formatter: 'currency',
align: 'right',
editable: true,
editrules: {
edithidden: false,
number: true,
required: false
},
editoptions: {
dataEvents: [{ type: 'change', fn: function (e) { GbpValSet(this.value); } }]
},
formoptions: {
elmsuffix: '<font color="red">*</font>'
},
formoptions: {
rowpos: 6,
colpos: 2
},
sortable: false,
search: false
},

  {
name: 'AmountGbp',
index: 'AmountGbp',
label: 'Amount GBP',
width: 130,
formatter: 'currency',
align: 'right',
editable: true,
editrules: {
edithidden: false,
number: true,
required: false
},
formoptions: {
rowpos: 11,
colpos: 2
},
sortable: false,
search: true,
searchoptions: {
defaultValue: getValueoffilter(filters, "AmountGbp"),
sopt: ['ge','le','gt','lt','eq','ne']
}
},

  When I press on F12, I saw the code:-

  <input name="AmountGbp" class="FormElement ui-widget-content ui-corner-all" id="AmountGbp" role="textbox" type="text" value="0.07"> OR

  <input name="AmountGbp" class="FormElement ui-widget-content ui-corner-all" id="AmountGbp" role="textbox" type="text">0.07</input>

  But the Edit Dialog, The field AmountGbp doesn't show up the value as 0.07. It's still showing original value as 0.00

  Please advise.

  Thanks

  Regards,

  Micheale

• • Reply
  micnie2020

  Member

  124 Points

  791 Posts

  Re: Jqgrid edit dialog onchange show value to another textbox

  Dec 02, 2019 06:21 AM|micnie2020|LINK

  Hi All,

  Sorry. Issue resolved.

  Solution:

  function GbpValSet(val, e) {
  var thisval = val;
  var f = $("#Curr").val();
  $.post('@Url.Content("~/Agreement/getCurrencyRate")',
  { "Curr": f, "__RequestVerificationToken": '@GetAntiXsrfRequestToken()' },
  function (data) {
  gbp=((1/parseFloat(data)) * parseFloat(thisval)).toFixed(2);
  }).done(function () {
  
  // populate descriptionEditHtml in the "description" edit cell
  if ($(e.target).is('.FormElement')) {
  // form editing
  var form = $(e.target).closest('form.FormGrid');
  $("#AmountGbp.FormElement", form[0])[0].value = gbp;
  } else {
  // inline editing
  var row = $(e.target).closest('tr.jqgrow');
  var rowId = row.attr('Id');
  $("#"+rowId+"_AmountGbp",row[0])[0].value = gbp;
  }
  });
  }

  :

  editoptions: {
  dataEvents: [
  {
  type: 'blur',
  fn: function (e) {
  GbpValSet(this.value, e);
  }
  }]
  },

  Thanks.

  Regards,

  Micheale