泛微OA 常用操作

by

查询有问题的流程 select t1.requestid,t1.requestmark,t1.createdate, t1.createtime,t1.creater, t1.creatertype, t1.workflowid, t1.requestname, t1.requestnamenew, t1.status,t1.requestlevel,t1.currentnodeid, t2.viewtype,t2.userid,t2.receivedate,t2.receivetime,t2.isremark,t2.nodeid,t2.agentorbyagentid, t2.agenttype,t2.isprocessed,t2.usertype,t1.deleted,t2.takisremark,t2.islasttimes,t1.currentstatus from workflow_requestbase t1,workflow_currentoperator t2 where (t1.deleted <> 1 or t1.deleted is null or t1.deleted=”) and t1. requestid = t2.requestid and t2.userid = 3774 and t2.usertype=0 and (t1.deleted=0 or t1.deleted is null) and ((t2.isremark=0 and (t2.takisremark is null or t2.takisremark=0 )) or t2.isremark in(‘1′,’5′,’8′,’9′,’7′)) and … Read more

sql server 增加索引

by

SELECT TOP 30 [Total Cost] = ROUND(avg_total_user_cost * avg_user_impact * (user_seeks + user_scans),0) , avg_user_impact , TableName = statement , [EqualityUsage] = equality_columns , [InequalityUsage] = inequality_columns , [Include Cloumns] = included_columns FROM sys.dm_db_missing_index_groups g INNER JOIN sys.dm_db_missing_index_group_stats s ON s.group_handle = g.index_group_handle INNER JOIN sys.dm_db_missing_index_details d ON d.index_handle = g.index_handle ORDER BY [Total Cost] … Read more

not in 优化 not exists

by

–not in 优化 select RIGHT(MATNR,11) as MATNR,QUNTY,PLNMG,ERDAT from (select MATNR,QUNTY,PLNMG,ERDAT from ZZMAST union all select MATNR,QUNTY,PLNMG,ERDAT from ZMANT t1 –where MATNR NOT IN (SELECT MATNR from ZZMAST) where not exists (select t1.MATNR,t1.QUNTY,t1.PLNMG,t1.ERDAT from ZZMAST t2 where t1.MATNR=t2.MATNR) ) as a WHERE ISNUMERIC(MATNR)=1

[泛微OA]字段查流程 表名查流程

by

根据字段查流程 select c.id,c.workflowname,b.indexdesc,a.fieldname from workflow_billfield a, HtmlLabelIndex b ,workflow_base c where b.id = a.fieldlabel and a.billid = c.formid and b.indexdesc like ‘%订单号%’ 表名查流程 –表名查流程 select a.workflowname,a.formid from workflow_base a, workflow_bill b where a.formid = b.id and b.tablename=’formtable_main_333′

优化SQL必备

by

优化SQL必备： SELECT TOP 1000 ST. TEXT AS ‘执行的SQL语句’, QS.execution_count AS ‘执行次数’, QS.total_elapsed_time AS ‘耗时’, QS.total_logical_reads AS ‘逻辑读取次数’, QS.total_logical_writes AS ‘逻辑写入次数’, QS.total_physical_reads AS ‘物理读取次数’, QS.creation_time AS ‘执行时间’ FROM sys.dm_exec_query_stats QS CROSS APPLY sys.dm_exec_sql_text (QS.sql_handle) ST WHERE QS.creation_time BETWEEN ‘2019-10-10 15:00:00.000’ AND ‘2019-10-22 18:00:00.000’ ORDER BY QS.total_elapsed_time DESC;

[泛微OA]明细表、子表， 数据删除后，再添加行，JS添加的数据不起作用的问题

by

泛微明细表、子表， 数据删除后，再添加行，JS添加的数据不起作用的问题 function changeReq(){ var v = cus_getFieldValue(‘field11022’); var els0 = $(‘input[name^=field11173_]’) // 获取子表，从0开始，此处为明细表1 var len0 = els0.length // 获取子表行数 for (var i = 0; i < len0; i++) { // 子表数据 if(v==1){ setUnReq(els0.eq(i).attr(‘name’)) }else{ setReq(els0.eq(i).attr(‘name’)) } } }

[泛微OA]顶部菜单，菜单排序

by

—— 顶部菜单，菜单排序 SELECT c.labelname,a.* FROM HrmUserMenuStatictics a,LeftMenuInfo b,HtmlLabelInfo c WHERE a.menuid=b.id and b.labelid=c.indexid and c.languageid=7 and a.userid=123 order by clickCnt desc, menuid update HrmUserMenuStatictics set clickcnt =600 where id = 22 –1 update HrmUserMenuStatictics set clickcnt =500 where id = 81 –2 update HrmUserMenuStatictics set clickcnt =400 where id = 176 –4 update HrmUserMenuStatictics set … Read more