Thanks but I have follow problem:
I have two dataadapter.
If I use your code I can only use the Product datamanager.
But I need the Foreign adaptor ProductType.
$(function () {
window.foreignkeydata = {};
var dataManagerType = ej.DataManager({
url: "/api/ProductType1",
adaptor: new ej.WebApiAdaptor(),
offline: true
});
dataManagerType.ready.done(function (e) {
window.foreignkeydata = e.result;
});
var dataManager = ej.DataManager({
url: "/api/Product",
adaptor: new ej.WebApiAdaptor(),
offline: true
});
dataManager.ready.done(function (e) {
window.foreignkeydata = e.result;
$("#Grid").ejGrid({
dataSource: ej.DataManager({
json: e.result,
adaptor: new ej.remoteSaveAdaptor(),
insertUrl: "/api/Product/Insert",
updateUrl: "/api/Product/Update",
removeUrl: "/api/Product/Remove",
}),
toolbarSettings: {
showToolbar: true,
toolbarItems: ["add", "edit", "printGrid", "search"]
},
editSettings: {
allowEditing: true,
allowAdding: true,
allowDeleting: false,
showDeleteConfirmDialog: true,
editMode: "dialogtemplate",
dialogEditorTemplateID: "#templateForm",
},
isResponsive: true,
enableResponsiveRow: true,
allowSorting: true,
allowSearching: true,
allowFiltering: true,
filterSettings: {
filterType: "excel",
maxFilterChoices: 100,
enableCaseSensitivity: false
},
allowPaging: true,
pageSettings: { pageSize: 100, printMode: ej.Grid.PrintMode.CurrentPage },
templateRefresh: function (args) {
if (args.column.headerText == "Type2") {
var value = window.foreignkeydata.filter(e => e.TypeId == args.data.TypeId); // filter the foreignkey datasource using foreignkey field.
args.cell.innerText = value[0].Name;
}
},
columns: [
{ field: "ProductId", type: 'number', headerText: 'OD-No.', defaultValue: 0, isPrimaryKey: true, isIdentity: true, visible: false },
{ field: "Barcode", type: 'string', headerText: 'P/N', validationRules: { required: true } },
{ field: "ISO", type: 'string', headerText: 'ISO', validationRules: { required: true } },
{ field: "TypeList", headerText: 'Type1', foreignKeyField: "TypeId", foreignKeyValue: "Name", dataSource: dataManagerType, validationRules: { required: true } },
{ field: "SupplierPN", type: 'string', headerText: 'SupplierPN', visible: false },
{ headerText: "Type2", template: "<span></span > " },
],
actionComplete: "complete",
});
});
});
