python 根据条件改变单据列表某个字段颜色原创
独眼兽
40人赞赏了该文章
3748次浏览
编辑于2024年02月29日 20:54:05
#引入clr运行库
import clr
#添加对cloud插件开发的常用组件的引用
clr.AddReference('System')
clr.AddReference('System.Data')
clr.AddReference('Kingdee.BOS')
clr.AddReference('Kingdee.BOS.Core')
clr.AddReference('Kingdee.BOS.App')
clr.AddReference('Kingdee.BOS.ServiceHelper')
#导入cloud基础库中的常用实体对象（分命名空间导入，不会递归导入）
from Kingdee.BOS import *
from Kingdee.BOS.Core import *
from Kingdee.BOS.Core.Bill import *
from Kingdee.BOS.Core.DynamicForm.PlugIn import *
from Kingdee.BOS.Core.DynamicForm.PlugIn.ControlModel import *
from System import *
from System.Data import *
from Kingdee.BOS.App.Data import *
from System.Collections.Generic import List
from Kingdee.BOS.ServiceHelper import *
def OnFormatRowConditions(args):
if(args.DataRow.DynamicObject.DynamicObjectType.Properties.ContainsKey("FCloseStatus")):
FCloseStatus=str(args.DataRow["FCloseStatus"]);
if(FCloseStatus=="A"):
fc=FormatCondition();
#fc.ForeColor="#FFFF9B98";#前景色
fc.BackColor="#FFFF00";#背景色
fc.ColorField = "FCloseStatus";#颜色字段
args.FormatConditions.Add(fc);
if(args.DataRow.DynamicObject.DynamicObjectType.Properties.ContainsKey("FMRPCloseStatus")):
FMRPCloseStatus=str(args.DataRow["FMRPCloseStatus"]);
if(FMRPCloseStatus=="B"):
fc=FormatCondition();
#fc.ForeColor="#FFFF9B98";#前景色
fc.BackColor="#FF0000";#背景色
fc.ColorField = "FMRPCloseStatus";#颜色字段
args.FormatConditions.Add(fc);