Python注册,按钮直接执行SQL语句
import clr clr.AddReference('Kingdee.BOS.App') from Kingdee.BOS.App.Data import * def BarItemClick(e): if e.BarItemKey == "TPFN_JR_ZXYJ": sql1 = """/*dialect*/ update T_PLN_PLANORDER_L set FDESCRIPTION='合并' from ( select FBILLNO, t2.fid from T_PLN_PLANORDER t1 left join T_PLN_PLANORDER_L t2 on t1.FID = t2.fid WHERE CONVERT(date, FCREATEDATE) >= CONVERT(date, GETDATE()-3) and FMATERIALID in ( select FMATERIALID from T_BD_MATERIAL where FNUMBER like '3%' ) ) v1 where v1.fid = T_PLN_PLANORDER_L.FID; """ count = DBUtils.Execute(this.Context, sql1) sql2 = """/*dialect*/ update T_PLN_PLANORDER_L set FDESCRIPTION = v1.FBILLNO from ( select FBILLNO, t2.fid from T_PLN_PLANORDER t1 left join T_PLN_PLANORDER_L t2 on t1.FID = t2.fid WHERE CONVERT(date, FCREATEDATE) >= CONVERT(date, GETDATE()-3) and FMATERIALID in ( select FMATERIALID from T_BD_MATERIAL where FNUMBER like '2%' or FNUMBER like '1%' ) ) v1 where v1.fid = T_PLN_PLANORDER_L.FID; """ count = DBUtils.Execute(this.Context, sql2) # this.View.ShowMessage("更新成功,SQL:"+sql+",受影响行数:"+count.ToString())
版权声明
本文仅代表作者观点。
本文系作者授权发表,未经许可,不得转载。
发表评论:
◎欢迎参与讨论,请在这里发表您的看法、交流您的观点。