- 博客(13)
- 资源 (3)
- 收藏
- 关注
原创 FineReport——获取控件值和单元格值
设置单元格的值(填报预览)://contentPane.setCellValue(1,0,"abc");//参数面板给单元格赋实际值,即可填报contentPane.curLGP.setCellValue(1, 0, "abc") //报表中控件给报表中单元格赋值获取单元格的值(填报预览,参数面板和报表控件都可以这样写)://contentPane.getCellValue(1,0);contentPane.curLGP.getCellValue(1, 0)var text=contentPa
2020-11-13 16:02:05 2023
原创 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 4535 2
原创 python-TypeError: Object of type ‘Decimal‘ is not JSON serializable 报错
class DecimalEncoder(json.JSONEncoder): def default(self, o): if isinstance(o, decimal.Decimal): return float(o) super(DecimalEncoder, self).default(o)j = json.dum...
2019-04-22 10:04:33 19536 2
原创 python-TypeError: Object of type ‘datetime‘ is not JSON serializable 报错
class CJsonEncoder(json.JSONEncoder): def default(self, obj): if isinstance(obj, datetime.datetime): return obj.strftime('%Y-%m-%d %H:%M:%S') elif isinstance(obj, date)...
2019-04-22 09:55:02 12475
原创 泛微OA-测试机更改sysadmin密码为1
update HrmResourceManager set password = 'C4CA4238A0B923820DCC509A6F75849B' where loginid = 'sysadmin'
2019-04-19 10:01:02 20157
原创 泛微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 12751
原创 泛微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 16669 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 17884
原创 泛微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 18170 1
原创 泛微OA-测试环境更新所有密码为1
password为md5加密,可以根据自己实际需要修改update hrmresource set password= 'C4CA4238A0B923820DCC509A6F75849B'
2019-04-16 14:30:24 20080
原创 泛微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 19354 3
原创 windows倒计时锁屏-python
# 倒计时锁屏import timefrom ctypes import *def closewindows(closetime): while closetime>0: print(closetime) time.sleep(1) closetime-=1 user32 = windll.LoadLibrary('us...
2019-04-15 14:29:51 19429 1
原创 python实现截取屏幕保存文件,删除N天前截图
from PIL import ImageGrabimport timeimport scheduleimport osimport shutilimport datetimedays = -3# 截屏def savepic(): im = ImageGrab.grab() now = time.strftime("%Y_%m_%d_%H_%M_%S", time.loc...
2019-04-15 14:21:18 28688 1
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人