Month: January 2021

树莓派各类操作系统大全

by

树莓派各类操作系统大全 Raspberry Pi OS（Raspbian） 树莓派官方深度定制的硬件驱动与软件程序，官方推荐系统。如果你第一次使用树莓派，请下载这个。 32 位 Lite 版（无桌面） | 32 位桌面版（推荐使用） | 32 位桌面版（含常用软件） 默认帐号：Username: pi Password: raspberry Ubuntu MATE for the Raspberry Pi Ubuntu MATE 是桌面 Linux 发行，其宗旨是通过 MATE 这个经典、传统的桌面环境来提供 Ubuntu 操作系统的简介和典雅。MATE 是 GNOME 2 桌面环境的继续，曾经作为 Ubuntu 的缺省桌面，Ubuntu MATE 同样适合树莓派新手使用，界面是最好看的，但是在 CPU 优化方面不如官方的系统做得好。 官网 | 下载页面 Arch Linux ARM 著名轻量系统 Arch Linux 在 ARM 架构上的移植。注重对于开发者的简洁，任何可有可无的软件一律不自带。仅有命令行界面，不建议初学者使用。Arch Linux 的软件策略是相当激进的，使用 Arch Linux 能用到最新的软件包，但也需要承担尝鲜可能的风险。 … Read more

阿里云域名优惠口令 优惠口令的获取方法

by

大家可以关注官方：阿里云-优惠口令，关注官方的公众号: 阿里云域名与商标 ，输入关键词“优惠口令”，会自动发放最新的优惠口令。 在微信公众号中回复“优惠口令”后获取到的优惠口令。因不同时间段的活动不相同，获取到的优惠口令仅供参考，具体需要以您实际获取到的优惠口令为准。

[泛微OA]数据库还原后，清理数据库

by

— remove doc task update DocChangeSetting set autoSend=0,autoReceive =0; –remove all webservices truncate table wsregiste; –remove all tasks or update SCHEDULESETTING set cronexpr =’0 0 0 1 1 ?’; delete from SCHEDULESETTING; –change pwd update hrmresource set password=’C4CA4238A0B923820DCC509A6F75849B’; –1 update HrmResourceManager set password=’C4CA4238A0B923820DCC509A6F75849B’ where loginid=’sysadmin’; –1 –change page temp update SystemLoginTemplate set isCurrent =0; update … Read more

泛微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’)) } } }