金蝶云·星空

金蝶云·星空

1、获取某一张表的自增ID

int[] newIds = Kingdee.BOS.ServiceHelper.DBServiceHelper.GetSequenceInt32(this.Context, "PFIH_t_Cust_Entry100050", 1);

2、K3Cloud DynamicObject数据包操作

K3Cloud DynamicObject数据包操作 - 嘿嘿嘿~ - 博客园

3、服务插件，获取单据体

3.1

Entity entity = this.BusinessInfo.GetEntity("FEntity");
foreach(var dataEntity in e.DataEntity)
{
DynamicObjectCollection rows = entity.DynamicProperty.GetValue(dataEntity) as DynamicObjectCollection;
}

3.2

foreach (DynamicObject obj in e.DataEntitys)
{
    //获取单据头字段信息
    Int32 Id = Convert.ToInt32(obj["Id"]);
}

4、金蝶云星空——新版WebAPI SDK总纲

金蝶云星空——新版OpenAPI SDK总纲

5、单据转换

开发案例分享-单据转换之多单据体转换

开发案例分享-单据转换之多单据体转换

6、菜单列表

/* 功能查询 -菜单列表*/ SELECT L.FNAME, H.FNAME, B.FNAME, E.FNAME FROM T_META_CONSOLESUBFUNC A JOIN T_META_CONSOLESUBFUNC_l B ON A.FSUBFUNCID = B.FSUBFUNCID AND B.FLOCALEID = 2052 JOIN ( SELECT C.FSUBFUNCID, C.FOBJECTID, D.FNAME FROM T_META_CONSOLEDETAIL C JOIN T_META_CONSOLEDETAIL_l D ON C.FDETAILFUNCID = D.FDETAILFUNCID AND D.FLOCALEID = 2052 ) E ON A.FSUBFUNCID = E.FSUBFUNCID JOIN ( SELECT F.FID, G.FNAME, F.FTOPCLASSID FROM T_META_SUBSYSTEM F JOIN T_META_SUBSYSTEM_l G ON F.FID = G.FID AND G.FLOCALEID = 2052 ) H ON A.FSUBSYSTEMID = H.FID JOIN ( SELECT J.FTOPCLASSID, K.FNAME FROM T_META_TOPCLASS J JOIN T_META_TOPCLASS_L K ON J.FTOPCLASSID = K.FTOPCLASSID AND K.FLOCALEID = 2052 ) L ON H.FTOPCLASSID = L.FTOPCLASSID ORDER BY L.FNAME, H.FNAME, B.FNAME, E.FNAME

7、二开案例.表单插件.执行SQL

作者：Jack

来源：金蝶云社区

原文链接：https://vip.kingdee.com/article/119856062978967040

著作权归作者所有。商业转载请联系作者获得授权，非商业转载请注明出处。

单据体值更新

public override void DataChanged(DataChangedEventArgs e)
{
//获取单据体选中行
int entry_row = this.View.Model.GetEntryCurrentRowIndex("FCRMContractEntry");
//获取该选中行，下拉列表的值
var data= this.View.Model.GetValue("F_MenuSources", entry_row);
//获取更新的字段
string key = e.Field.Key.ToUpperInvariant();
//判断该字段值是否改变
if (key == "F_MENUSOURCES")
{
//获取改变后的值
int index2 = Convert.ToInt32(this.View.Model.GetValue("F_MenuSources", this.View.Model.GetEntryCurrentRowIndex ("FCRMContractEntry")));
}
}

表单插件中获取到单据体中选中行的数据

int selectRowIndex = this.View.Model.GetEntryCurrentRowIndex("单据体的key/标识");
EntryEntity data= this.View.BusinessInfo.GetEntryEntity("单据体的key/标识");
DynamicObject selectRowData = this.View.Model.GetEntityDataObject(data, selectRowIndex);