金蝶云星空-ip段.txt

54.222.58.0/2854.239.0.144/2852.80.0.0/1654.222.0.0/1954.222.58.48/28140.179.0.0/1654.223.0.0/1615.230.49.0/24150.222.89.0/2454.222.32.0/2252.81.0.0/1654.222.52.0/2254.222.128.0/17150.222.88.0/2454.222.59.0/2454.222.76.0/2254.222.66.0/2354.222.57.0/2454.222.70.0/2454.222.64.0/2354.222.36.0/2252.95.255.144/2854.222.48.0/2215.230.41.0/2454.222.58.32/2852.80.198.0/2552.80.197.0/2552.80.197.128/255...

金蝶云星空-python语句.txt

importclrclr.AddReference(Kingdee.BOS.Core)clr.AddReference(Kingdee.BOS.DataEntity)clr.AddReference(Kingdee.K3.FIN.CN.App.Core)fromKingdee.BOS.DataEntityimport*fromKingdee.BOS.Core.Metadata.FieldElementimport*fromKingdee.K3.FIN.CN.App.Coreimport*#addbyyldefAfterConvert(e):headEntity=e.Result.FindByEntityKey(FBillHead)accountFld=e.TargetBusinessInfo.GetField(FPURPOSEID)foriteminheadEntity:cl=item[PAYBILLENTRY]fordyincl:dy[PURPOSEID_ID]=20018obj=CNCommonFunction.GetDynamicObjectByID(e.Context,20018,accountFld)dy[PURPOSEID]=obj

金蝶云星空-参考附件.txt

ifFDetailID==0else/.join(filter(lambdax:(x.find(费用项目)<0),FlexFormat(FDetailID,Type:Code,Name,/)[0].GetString(2052).split(/)))

金蝶云星空-插件内容.txt

importclrclr.AddReference(Kingdee.BOS.Core)clr.AddReference(Kingdee.BOS.DataEntity)fromKingdee.BOS.DataEntityimport*fromKingdee.BOS.Core.Metadata.FieldElementimport*defAfterConvert(e):headEntity=e.Result.FindByEntityKey(FBillHead)foriteminheadEntity:data=item[PAYBILLENTRY]src=item[PAYBILLSRCENTRY]iflen(data)!=len(src):continueforindexinrange(len(data)):data[index][F_PAPB_Assistant_SRC_E_ID]=src...

金蝶云星空-索引优化(1).txt

SETANSI_NULLSONSETQUOTED_IDENTIFIERONDECLARE@sqlVARCHAR(max)SET@sql=SELECT@sql=@sql+dbccdbreindex([+name+]);+char(13)+char(10)FROMsys.tablesWHEREnameNOTLIKETMP%ANDNAMENOTLIKEZ[_]%EXEC(@sql)

金蝶云星空-备份并清除许可.txt

--1备份SELECT*INTOT_BD_PRODUCTMODEL_BAKFROMT_BD_PRODUCTMODEL;--2清除DELETET_BD_PRODUCTMODELWHEREFIDNOTIN(1D69BBE3-DAE4-40F7-BCBE-D0943D9364AE,Kingdee);

金蝶云星空-附件公式.txt

ifFDetailID==0elseFlexFormat(FDetailID,Type:Code,Name,/)[0].GetString(2052).split(/)[0]

金蝶s-HR-脚本执行例子.txt

StringBuffertStrSql=newStringBuffer();tStrSql.append(selecta.FCostCenterIdfromT_BC_BizAccountBillEntrya);tStrSql.append(wherea.FBillID=+billid+);com.kingdee.jdbc.rowset.IRowSetrowSet=com.kingdee.eas.util.app.DbUtil.executeQuery(__bosContext,tStrSql.toString());if(rowSet!=null){while(rowSet.next()){tFCostCenterId=rowSet.getString(1);}}

金蝶s-HR-API接口开发配置.txt

API鎺ュ彛寮彂閰嶇疆锛��1銆亄EAS-HOME}\eas\Server\server\deploy\portal.ear\portal.war\WEB-INF\web.xml涓厤缃畇ervlet锛�<!--webApiservlet--><servlet><servlet-name>APIACCESS</servlet-name><servlet-class>com.kingdee.shr.servlet.APIServlet</servlet-class><load-on-startup>5</load-on-startup></servlet><servlet-mapping><servlet-name>APIACCESS</servlet-name><url-pattern>/api/apiaccess</url-pattern><...

金蝶s-HR-源合同视图.txt

<fieldname=entrys.sourceContract.contractLimitTypelabel=源合同期限类型readonly=true/><fieldname=entrys.sourceContract.recordDatelabel=源合同签订日期readonly=true/><fieldname=entrys.sourceContract.hrOrgUnitlabel=合同签订组织dataType=F7readonly=true/><fieldname=entrys.sourceContract.labContractFirstPartylabel=劳动合同主体required=truereadonly=true/><fieldname=entrys.sourceContract.delegatePersonl...

金蝶s-HR-考勤制度视图.txt

<?xmlversion=1.0encoding=UTF-8?><formname=AttencePolicyFormcol=12><titlevalue=考勤制度/><stylehref=${appPath}/orgnization/web/css/org.css/><stylehref=${appPath}/${appCode}/web/css/shr/ats/attencePolicy.css/><scriptsrc=${appPath}/${appCode}/web/js/shr/ats/AtsMaintainBasicItemEdit.js/><scriptsrc=${appPath}/${appCode}/web/js/shr/ats/attencePolicyEdit.js/><scriptsrc=${appPath}/${appCode}/web/js/shr...

金蝶s-HR-试图修改.txt

将试图中的：改为：

金蝶s-HR-单据加索引.txt

Ifexists(select*fromKSQL_INDEXESwhereKSQL_INDNAME=index_HR_EnrollEntryBillId)dropindexT_HR_EmpEnrollBizBillEntry.index_HR_EnrollEntryBillId;Ifnotexists(select*fromKSQL_INDEXESwhereKSQL_INDNAME=index_HR_EnrollEntryBillId)createindexindex_HR_EnrollEntryBillIdonT_HR_EmpEnrollBizBillEntry(FBillID);Ifexists(select*fromKSQL_INDEXESwhereKSQL_INDNAME=index_HR_HireEntryBillId)dropindexT_HR_EmpHireBizBil...

金蝶s-HR-附件代码行.txt

金蝶s-HR-多附件控件.txt

<attachmentattachmentTitle=材料附件allDownload=true><itemmaxSize=5sorterItems=nameDESC,createTimeASCfileType=ppt,pptx,jpeg,pdf,jpg,png,doc,xls,txt,xmind,xlsx,docxname=简历required=truefield=protocolreadonly=falseonlyone=false/><itemmaxSize=5sorterItems=nameDESC,createTimeASCfileType=ppt,pptx,jpeg,pdf,jpg,png,doc,xls,txt,xmind,xlsx,docxname=应聘人员登记表required=truefield=protocollreadonly=fals...

金蝶s-HR-代码行.txt

金蝶K3WISE-重建索引.txt

DECLARE@DBCCStringNVARCHAR(1000)DECLARE@TableNameVARCHAR(100)DECLARECur_IndexCURSORFORSELECTNameASTblNameFROMsysobjectsWHERExType=UORDERBYTblNameFORREADONLYOPENCur_IndexFETCHNEXTFROMCur_IndexINTO@TableNameWHILE@@FETCH_STATUS=0BEGINPRINT重建表+@TableName+的索引........Start!SET@DBCCString=DBCCDBREINDEX(@TblName,)WITHNO_INFOMSGSEXECSP_EXECUTESQL@DBCCString,N@TblNameVARCHAR(100),@TableNamePRINT重建表+@TableName+的索引........END!FETCHNEXTFROMCur_IndexINTO@TableNameEND

金蝶K3WISE-单独计税年终奖.txt

年终奖计税额=年终奖/12如果年终奖计税额>0且年终奖计税额<=3000则年终奖个税=ROUNDX(年终奖*3%,2)如果完如果年终奖计税额>3000且年终奖计税额<=12000则年终奖个税=ROUNDX(年终奖*10%-210,2)如果完如果年终奖计税额>12000且年终奖计税额<=25000则年终奖个税=ROUNDX(年终奖*20%-1410,2)如果完如果年终奖计税额>25000且年终奖计税额<=35000则年终奖个税=ROUNDX(年终奖*25%-2660,2)如果完如果年终奖计税额>35000且年终奖计税额<=55...

金蝶K3WISE-查看死锁.txt

方法一：SQL2008R2：SELECTXEventData.XEvent.value(@timestamp,datetime2(3)),cast(XEventData.XEvent.value((data/value)[1],varchar(max))asxml)FROM(SELECTCAST(target_dataASXML)ASTargetDataFROMsys.dm_xe_session_targetsstJOINsys.dm_xe_sessionssONs.address=st.event_session_addressWHERE[name]=system_healthANDst.target_name=Nring_buffer)ASDataCROSSAPPLYTargetData.nodes(//RingBufferTarget/event)ASXEventDa...

金蝶K3WISE-BOS单据修改为Ebos单据(1).txt

以下为bos单据和ebos单据属性调整的案例，供参考。将GUI的BOS单据改成支持web的EBOS单据方法如下，以新建”单据200000002”为例：--根据单据名称查询出单据类型ID：200000002SELECTFIDfcontrolFROMICClasstypeWHEREFName_CHSLIKE%单据200000002%--根据单据类型ID更改FControl字段，二进制位8192标识此单据为WEB单据，去掉8192即为GUI单据--查出该单据Fcontrol值：1075775923selectFControlfromICClassTypeWHEREFID=200000002--...