![](https://img-blog.csdnimg.cn/20201014180756923.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
泛微
文章平均质量分 92
woobol
非主流业余码农
展开
-
泛微OA-提交前检查字段值是0.5的倍数才能提交;否则显示背景色为黄色
// #field12345自行修改为真实字段名,yellow修改为想要的背景颜色jQuery(document).ready(function(){checkCustomize = function() { var ret = true; if (ret) { var a1 = jQuery("#field12345").val(); if (a1 % 0.5 == 0) { ...原创 2019-04-16 08:30:11 · 19327 阅读 · 3 评论 -
泛微OA-测试环境更新所有密码为1
password为md5加密,可以根据自己实际需要修改update hrmresource set password= 'C4CA4238A0B923820DCC509A6F75849B'原创 2019-04-16 14:30:24 · 20034 阅读 · 0 评论 -
泛微OA-年份浏览框增加年份值
INSERT INTO WORKFLOW_FIELDYEAR(YEARID, YEARNAME) SELECT MAX(YEARID)+1 AS YEARID, MAX(YEARID)+1 AS YEARNAME FROM WORKFLOW_FIELDYEAR原创 2019-04-16 14:38:15 · 18096 阅读 · 1 评论 -
泛微OA-根据值定位值所在的表
--SQL server--根据值查询弄个表DECLARE @what varchar(800)SET @what='XXXXXXX' --要搜索的字符串DECLARE @sql varchar(8000)DECLARE TableCursor CURSOR LOCAL FORSELECT sql='IF EXISTS ( SELECT 1 FROM ['+o.name+'] WHER...原创 2019-04-16 15:48:55 · 17850 阅读 · 0 评论 -
泛微OA-流程统计
--按月统计每月流程数--最近6个月数据统计select TOP 6 CONVERT(VARCHAR(7),receivedate,120),COUNT(requestid) from workflow_currentoperatorgroup by CONVERT(VARCHAR(7),receivedate,120)order by CONVERT(VARCHAR(7),receiv...原创 2019-04-16 15:52:15 · 16566 阅读 · 1 评论 -
泛微OA-重装修改盘符
update SystemSet set filesystem = replace(filesystem, 'E:\', 'D:\'), filesystembackup = replace(filesystembackup, 'E:\', 'D:\'), picturePath = replace(picturePath, 'E:\', 'D:\'), emlPath = replace(e...原创 2019-04-16 15:54:56 · 12734 阅读 · 0 评论 -
泛微OA-测试机更改sysadmin密码为1
update HrmResourceManager set password = 'C4CA4238A0B923820DCC509A6F75849B' where loginid = 'sysadmin'原创 2019-04-19 10:01:02 · 19993 阅读 · 0 评论 -
Ecology8门户集成FineReport10.0(ajax error修改版)
1、部署FR10.0参考文档http://help.finereport.com/doc-view-765.html本文中的访问路径均为http://localhost:8080/webroot/decision,在集成时需要进行修改在部署完成以后,需要登录平台,并修改安全认证选项,如图:2、同步用户2.1 放置MD5加密包将附件“decision.zip”解压以后,直接放到工程的w...原创 2019-05-20 13:28:26 · 4433 阅读 · 2 评论