datagridview获取选中行_Dynamics 365为子网格添加按钮并获取选择记录的信息

于 2020-11-27 06:46:10 发布
阅读量288 收藏
点赞数
文章标签： datagridview获取选中行 easyui表单网格列错位 wpf的tabcontrol获取当前选中的名字 获取combox选中的值 获取select2选中的值 获取选中的li的值

我是微软Dynamics 365 & Power Platform方面的工程师/顾问罗勇，也是2015年7月到2018年6月连续三年Dynamics CRM/Business Solutions方面的微软最有价值专家(Microsoft MVP)，欢迎关注我的微信公众号 MSFTDynamics365erLuoYong ，回复426或者20201103可方便获取本文，同时可以在第一间得到我发布的最新博文信息，follow me!

前面的博文 Dynamics 365定制:在实体的列表界面添加按钮 讲述了实体列表界面添加按钮，博文 Dynamics 365中的导出至Excel，批量编辑，导入权限及限制导出至Excel 讲述了修改Application Ribbon来定制命令栏模板以达到修改实体公共按钮的目的，今天我们来讲述下修改子网格(Subgrid)的按钮。

我假设一个需求，如下界面，我想在Sales Order Item实体的子网格命令栏添加一个【Create Invoices】按钮，点击后将选中的Sales Order Items批量插入到下面的Invoices子网格中。

093a0fdc191bc3ed50f213950b370f4e.png

好的，基本的我不解说了，就将设置的内容捡重点说一下。新增一个按钮放到最前面，这个按钮对应的command如下，Custom JavaScript Action对应的 Libray为 $webresource:ly_/scripts/salesorderitem/salesorderitem.js ，Function Name为 LuoYong.SalesOrderItem.CreateInvoiceAction ，传递了PrimaryControl 和 SelectedControl 这两个Crm Parameter 给执行的函数。还关联了一个Enable Rule。

f6cd3943d04c5b9c334a8ac9bc5d4552.png

 这个Enable Rule的定义如下，注意要让这个按钮一直显示的话，记得添加一个 SelectionCountRule. 一般我还会添加一个FormStateRule。

我这里添加了一个Custom Rule，使用的Library还是 $webresource:ly_/scripts/salesorderitem/salesorderitem.js，执行的FunctionName是 LuoYong.SalesOrderItem.CreateInvoiceEnableRule

其实这个Function的功能很简单，看表单对应的实体Sales Order上的statuscode是否为Approved。你会问为啥不直接用 Value Rule，原因是不行啊。

e6fbf098225b25eaf0e51af543597485.png

我这里使用的代码如下：

bc7567b2db79e3247555f8aba6b23ee6.png

"use strict";var LuoYong = window.LuoYong || {};
LuoYong.SalesOrderItem = LuoYong.SalesOrderItem || {};
(function () {var getRandomString = function (len, charSet) {
        charSet = charSet || 'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789';var randomString = '';for (var i = 0; i < len; i++) {var randomPoz = Math.floor(Math.random() * charSet.length);
            randomString += charSet.substring(randomPoz, randomPoz + 1);
        }return randomString;
    };var executeBatch = function (clientURL, batchId, requestMsg, successCallback, errorCallback) {var req = new XMLHttpRequest()
        req.open("POST", encodeURI(clientURL + "/api/data/v9.1/$batch", true));//true是异步请求，false是同步请求
        req.setRequestHeader("Content-Type", "multipart/mixed;boundary=batch_" + batchId);
        req.setRequestHeader("Accept", "application/json");
        req.setRequestHeader("OData-MaxVersion", "4.0");
        req.setRequestHeader("OData-Version", "4.0");
        req.onreadystatechange = function () {if (this.readyState == 4) {
                req.onreadystatechange = null;if (this.status == 200) {
                    successCallback(this.responseText);
                }else {
                    errorCallback(this.responseText);
                }
            }
        };
        req.send(requestMsg);
    }this.CreateInvoiceAction = function (primaryControl, selectedControl) {var formContext = primaryControl;
        console.log("当前表单记录的ID=" + formContext.data.entity.getId());var entityId = formContext.data.entity.getId().replace('{', '').replace('}','');var entityPrimaryAttrValue = formContext.data.entity.getPrimaryAttributeValue();//获取子网格选中的记录，最多一次选中250行var selectedRows = selectedControl.getGrid().getSelectedRows();
        console.log("共选择了" + selectedRows.getLength() + "条记录!");if (selectedRows.getLength() === 0) {
            Xrm.Navigation.openErrorDialog({ message: "请选择至少一条记录!" }).then(function (success) {return;
                },function (error) {
                    console.log(error);
                });
        }else {var clientURL = Xrm.Utility.getGlobalContext().getClientUrl();var batchId = getRandomString(12);var changesetId = getRandomString(12);var requestMsg = ["--batch_" + batchId];
            requestMsg.push("Content-Type: multipart/mixed;boundary=changeset_" + changesetId);
            requestMsg.push("");
            selectedRows.forEach(function (row, i) {//通过下面这种方式可以获取到子网格显示的列的值，但是不能获取到子网格没有显示的列的值//如果要获取就要额外自己查询了，或者显示到子网格中
                console.log(row.getData().getEntity().attributes.get("ly_quantity").getValue());//获取选择记录的ID                console.log(row.getData().getEntity().getId());//获取选择记录的实体逻辑名称                console.log(row.getData().getEntity().getEntityName());//获取选择记录的主属性的值                console.log(row.getData().getEntity().getPrimaryAttributeValue());
                requestMsg.push("--changeset_" + changesetId);
                requestMsg.push("Content-Type: application/http");
                requestMsg.push("Content-Transfer-Encoding:binary");
                requestMsg.push("Content-ID: " + (i + 1).toString());
                requestMsg.push("");
                requestMsg.push("POST " + clientURL + "/api/data/v9.1/ly_luoyonginvoices HTTP/1.1");
                requestMsg.push("Content-Type: application/json;type=entry");
                requestMsg.push("");//注意这里要加空行var createData =
                {"ly_name": entityPrimaryAttrValue + "-" + row.getData().getEntity().attributes.get("ly_itemno").getValue(),"ly_quantity": row.getData().getEntity().attributes.get("ly_quantity").getValue(),"ly_totalvalue": row.getData().getEntity().attributes.get("ly_totalvalue").getValue(),"ly_unitprice": row.getData().getEntity().attributes.get("ly_unitprice").getValue(),"ly_salesorderid@odata.bind": "/ly_luoyongsalesorders(" + entityId + ")","ly_salesorderitemid@odata.bind": "/ly_luoyongsalesorderitems(" + row.getData().getEntity().getId().replace('{', '').replace('}', '') + ")",
                };
                requestMsg.push(JSON.stringify(createData));
            });
            requestMsg.push("--changeset_" + changesetId + "--");//changeset结束这里前面不要加空行
            requestMsg.push("");//注意这里要加空行
            requestMsg.push("--batch_" + batchId + "--");//batch结束前面加空行
            executeBatch(clientURL, batchId, requestMsg.join("\n"), function (responseText) {var alertStrings = { confirmButtonLabel: "Yes", text: "Done!", title: "Info" };var alertOptions = { height: 120, width: 260 };
                Xrm.Navigation.openAlertDialog(alertStrings, alertOptions).then(function (success) {//完成后刷新当前子网格，以便取消之前选择的记录，可能还有其他逻辑会让处理的记录不显示                        selectedControl.refresh();//完成后刷新子网格显示新建数据var gridContext = formContext.getControl("subgridInvoices"); 
                        gridContext.refresh();
                    },function (error) {
                        console.log(error.message);
                    }
                );
            }, function (responseText) {
                Xrm.Navigation.openErrorDialog({ message: "Create invoices error. " + responseText});
            });
        }
    };this.CreateInvoiceEnableRule = function (primaryControl) {var formContext = primaryControl;return formContext.getAttribute("statuscode").getValue() === 364750000;
    };
}).call(LuoYong.SalesOrderItem);

bc7567b2db79e3247555f8aba6b23ee6.png

演示下，选择记录后，点击【Create Invoices】按钮。

181e0e56c27fcdac2464945234bac370.png

提示操作完成，速度很快的，因为是用web api执行批量操作，一次请求创建多条记录。关于使用Web API执行批量操作请参考我的博文 使用JS通过Web API执行批量操作，多个操作是一个事务！。

b90d083104c0bb138f5c1794832b8507.png

上面的提示点击【Yes】后可以看到两个子网格刷新了，下面的Invoices子网格可以看到新数据了，上面子网格之前选择的记录也不选择了(其实也是刷新了的缘故)。 

7c84bc790d0e638ec85792705bbcd088.png

然后你可能会问，如果我需要不在一个事务中呢？比如我选三条记录来操作，有两条成功就成功，一条失败就失败，不互相影响，我目前找到的方法的代码如下：

bc7567b2db79e3247555f8aba6b23ee6.png

"use strict";var LuoYong = window.LuoYong || {};
LuoYong.SalesOrderItem = LuoYong.SalesOrderItem || {};
(function () {var getRandomString = function (len, charSet) {
        charSet = charSet || 'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789';var randomString = '';for (var i = 0; i < len; i++) {var randomPoz = Math.floor(Math.random() * charSet.length);
            randomString += charSet.substring(randomPoz, randomPoz + 1);
        }return randomString;
    };var executeBatch = function (clientURL, batchId, requestMsg, successCallback, errorCallback) {var req = new XMLHttpRequest()
        req.open("POST", encodeURI(clientURL + "/api/data/v9.1/$batch", true));//true是异步请求，false是同步请求
        req.setRequestHeader("Content-Type", "multipart/mixed;boundary=batch_" + batchId);
        req.setRequestHeader("Accept", "application/json");
        req.setRequestHeader("OData-MaxVersion", "4.0");
        req.setRequestHeader("OData-Version", "4.0");
        req.onreadystatechange = function () {if (this.readyState == 4) {
                req.onreadystatechange = null;if (this.status == 200) {
                    successCallback(this.responseText);
                }else {
                    errorCallback(this.responseText);
                }
            }
        };
        req.send(requestMsg);
    }this.CreateInvoiceAction = function (primaryControl, selectedControl) {var formContext = primaryControl;
        console.log("当前表单记录的ID=" + formContext.data.entity.getId());var entityId = formContext.data.entity.getId().replace('{', '').replace('}', '');var entityPrimaryAttrValue = formContext.data.entity.getPrimaryAttributeValue();//获取子网格选中的记录，最多一次选中250行var selectedRows = selectedControl.getGrid().getSelectedRows();
        console.log("共选择了" + selectedRows.getLength() + "条记录!");if (selectedRows.getLength() === 0) {
            Xrm.Navigation.openErrorDialog({ message: "请选择至少一条记录!" }).then(function (success) {return;
                },function (error) {
                    console.log(error);
                });
        }else {var clientURL = Xrm.Utility.getGlobalContext().getClientUrl();var batchId = getRandomString(12);var changesetId = getRandomString(12);var requestMsg = [];
            selectedRows.forEach(function (row, i) {//通过下面这种方式可以获取到子网格显示的列的值，但是不能获取到子网格没有显示的列的值//如果要获取就要额外自己查询了，或者显示到子网格中
                console.log(row.getData().getEntity().attributes.get("ly_quantity").getValue());//获取选择记录的ID                console.log(row.getData().getEntity().getId());//获取选择记录的实体逻辑名称                console.log(row.getData().getEntity().getEntityName());//获取选择记录的主属性的值                console.log(row.getData().getEntity().getPrimaryAttributeValue());
                requestMsg.push("--batch_" + batchId);
                requestMsg.push("Content-Type: multipart/mixed;boundary=changeset_" + changesetId);
                requestMsg.push("");
                requestMsg.push("--changeset_" + changesetId);
                requestMsg.push("Content-Type: application/http");
                requestMsg.push("Content-Transfer-Encoding:binary");
                requestMsg.push("Content-ID: " + (i + 1).toString());
                requestMsg.push("");
                requestMsg.push("POST " + clientURL + "/api/data/v9.1/ly_luoyonginvoices HTTP/1.1");
                requestMsg.push("Content-Type: application/json;type=entry");
                requestMsg.push("");//注意这里要加空行var createData =
                {"ly_name": entityPrimaryAttrValue + "-" + row.getData().getEntity().attributes.get("ly_itemno").getValue(),"ly_quantity": row.getData().getEntity().attributes.get("ly_quantity").getValue(),"ly_totalvalue": row.getData().getEntity().attributes.get("ly_totalvalue").getValue(),"ly_unitprice": row.getData().getEntity().attributes.get("ly_unitprice").getValue(),"ly_salesorderid@odata.bind": "/ly_luoyongsalesorders(" + entityId + ")","ly_salesorderitemid@odata.bind": "/ly_luoyongsalesorderitems(" + row.getData().getEntity().getId().replace('{', '').replace('}', '') + ")",
                };
                requestMsg.push(JSON.stringify(createData));
                requestMsg.push("--changeset_" + changesetId + "--");//changeset结束这里前面不要加空行
                requestMsg.push("");//注意这里要加空行            });
            requestMsg.push("--batch_" + batchId + "--");//batch结束前面加空行
            executeBatch(clientURL, batchId, requestMsg.join("\n"), function (responseText) {var alertStrings = { confirmButtonLabel: "Yes", text: "Done!", title: "Info" };var alertOptions = { height: 120, width: 260 };
                Xrm.Navigation.openAlertDialog(alertStrings, alertOptions).then(function (success) {//完成后刷新当前子网格，以便取消之前选择的记录，可能还有其他逻辑会让处理的记录不显示                        selectedControl.refresh();//完成后刷新子网格显示新建数据var gridContext = formContext.getControl("subgridInvoices");
                        gridContext.refresh();
                    },function (error) {
                        console.log(error.message);
                    }
                );
            }, function (responseText) {//完成后刷新当前子网格，以便取消之前选择的记录，可能还有其他逻辑会让处理的记录不显示                selectedControl.refresh();//完成后刷新子网格显示新建数据var gridContext = formContext.getControl("subgridInvoices");
                gridContext.refresh();
                Xrm.Navigation.openErrorDialog({ message: "Create invoices error. " + responseText });
            });
        }
    };this.CreateInvoiceEnableRule = function (primaryControl) {var formContext = primaryControl;return formContext.getAttribute("statuscode").getValue() === 364750000;
    };
}).call(LuoYong.SalesOrderItem);

bc7567b2db79e3247555f8aba6b23ee6.png

看到的Network，请求内容如下：

bc7567b2db79e3247555f8aba6b23ee6.png

--batch_cBqy7oDfV2Ok
Content-Type: multipart/mixed;boundary=changeset_t2pUnckorFaC
--changeset_t2pUnckorFaC
Content-Type: application/http
Content-Transfer-Encoding:binary
Content-ID: 1
POST https://org6485af04.crm5.dynamics.com/api/data/v9.1/ly_luoyonginvoices HTTP/1.1
Content-Type: application/json;type=entry
{"ly_name":"ORD-202003-000001-10","ly_quantity":10,"ly_totalvalue":1000,"ly_unitprice":100,"ly_salesorderid@odata.bind":"/ly_luoyongsalesorders(85B7FEF2-DB1D-EB11-A813-000D3AC71539)","ly_salesorderitemid@odata.bind":"/ly_luoyongsalesorderitems(28B60A06-DC1D-EB11-A813-000D3AC71539)"}
--changeset_t2pUnckorFaC--
--batch_cBqy7oDfV2Ok
Content-Type: multipart/mixed;boundary=changeset_t2pUnckorFaC
--changeset_t2pUnckorFaC
Content-Type: application/http
Content-Transfer-Encoding:binary
Content-ID: 2
POST https://org6485af04.crm5.dynamics.com/api/data/v9.1/ly_luoyonginvoices HTTP/1.1
Content-Type: application/json;type=entry
{"ly_name":"ORD-202003-000001-20","ly_quantity":20,"ly_totalvalue":4000,"ly_unitprice":200,"ly_salesorderid@odata.bind":"/ly_luoyongsalesorders(85B7FEF2-DB1D-EB11-A813-000D3AC71539)","ly_salesorderitemid@odata.bind":"/ly_luoyongsalesorderitems(CD75B411-DC1D-EB11-A813-000D3AC71539)"}
--changeset_t2pUnckorFaC--
--batch_cBqy7oDfV2Ok
Content-Type: multipart/mixed;boundary=changeset_t2pUnckorFaC
--changeset_t2pUnckorFaC
Content-Type: application/http
Content-Transfer-Encoding:binary
Content-ID: 3
POST https://org6485af04.crm5.dynamics.com/api/data/v9.1/ly_luoyonginvoices HTTP/1.1
Content-Type: application/json;type=entry
{"ly_name":"ORD-202003-000001-40","ly_quantity":40,"ly_totalvalue":16000,"ly_unitprice":400,"ly_salesorderid@odata.bind":"/ly_luoyongsalesorders(85B7FEF2-DB1D-EB11-A813-000D3AC71539)","ly_salesorderitemid@odata.bind":"/ly_luoyongsalesorderitems(09507D25-DC1D-EB11-A813-000D3AC71539)"}
--changeset_t2pUnckorFaC--
--batch_cBqy7oDfV2Ok--

bc7567b2db79e3247555f8aba6b23ee6.png

如果有报错的记录，返回的内容示例如下，返回的statuscode为400：

bc7567b2db79e3247555f8aba6b23ee6.png

--batchresponse_3ac10a59-4313-4db4-b6f0-ca247e37c5d5
Content-Type: multipart/mixed; boundary=changesetresponse_f7a0e798-8209-4fd5-beb0-869fffc8dc31
--changesetresponse_f7a0e798-8209-4fd5-beb0-869fffc8dc31
Content-Type: application/http
Content-Transfer-Encoding: binary
Content-ID: 1
HTTP/1.1 204 No Content
OData-Version: 4.0
Location: https://org6485af04.crm5.dynamics.com/api/data/v9.1/ly_luoyonginvoices(7a2ed124-f622-eb11-a813-000d3ac71539)
OData-EntityId: https://org6485af04.crm5.dynamics.com/api/data/v9.1/ly_luoyonginvoices(7a2ed124-f622-eb11-a813-000d3ac71539)
--changesetresponse_f7a0e798-8209-4fd5-beb0-869fffc8dc31--
--batchresponse_3ac10a59-4313-4db4-b6f0-ca247e37c5d5
Content-Type: multipart/mixed; boundary=changesetresponse_195a9cce-b6eb-4edc-b5ff-44d5f2dc8870
--changesetresponse_195a9cce-b6eb-4edc-b5ff-44d5f2dc8870
Content-Type: application/http
Content-Transfer-Encoding: binary
Content-ID: 2
HTTP/1.1 204 No Content
OData-Version: 4.0
Location: https://org6485af04.crm5.dynamics.com/api/data/v9.1/ly_luoyonginvoices(7c2ed124-f622-eb11-a813-000d3ac71539)
OData-EntityId: https://org6485af04.crm5.dynamics.com/api/data/v9.1/ly_luoyonginvoices(7c2ed124-f622-eb11-a813-000d3ac71539)
--changesetresponse_195a9cce-b6eb-4edc-b5ff-44d5f2dc8870--
--batchresponse_3ac10a59-4313-4db4-b6f0-ca247e37c5d5
Content-Type: multipart/mixed; boundary=changesetresponse_7cb33294-b5bc-4557-a4a3-78fdd4bfe937
--changesetresponse_7cb33294-b5bc-4557-a4a3-78fdd4bfe937
Content-Type: application/http
Content-Transfer-Encoding: binary
Content-ID: 3
HTTP/1.1 400 Bad Request
REQ_ID: c26fba38-ba4e-427f-9ac6-b01733e7eb70
Content-Type: application/json; odata.metadata=minimal
OData-Version: 4.0
{"error":{"code":"0x80040265","message":"Quantity should not greater than 30!"}}
--changesetresponse_7cb33294-b5bc-4557-a4a3-78fdd4bfe937--
--batchresponse_3ac10a59-4313-4db4-b6f0-ca247e37c5d5--

bc7567b2db79e3247555f8aba6b23ee6.png

weixin_39968823
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值