0551-6386-5005 张老师
0551-110 合肥电话
2021-03-13
1-修改存储过程-DataForXmlTYYQ_Attach
2-修改存储过程a_17025_ZZ_dis_AuthSign
3-修改存储过程a_17025_ZZ_dis_SubAddr
4-修改存储过程a_Tree_dis_StaffList_byTreeID
5-修改存储过程a_NLFW_BZFF_dis_CheckNew2
6-修改存储过程a_Doc_dis_List_byNodeType
7-修改存储过程a_17025_JLKZ_dis
8-修改存储过程DataForXml
9-修改存储过程DataForXmlNS
10-修改存储过程a_17025_NS_dis_AuditorDB
11-修改存储过程a_17025_GJ_dis
12-修改存储过程DataForXmlGLPS
13-修改存储过程DataForXmlHC
14-修改存储过程a_NLFW_dis
15-修改存储过程a_17025_Staff_dis_RecordList
16-修改存储过程a_Tree_dis_StaffList_byTreeID
17-修改存储过程e_17025_Records_Main_dis
18-修改存储过程e_17025_Records_Main_new
19-修改存储过程a_TXLC_dis_info_by_TreeID
20-修改存储过程a_TXLC_dis_bySnID_BFHX
21-修改存储过程a_NLFW_SYSZZ_dis_Info
22-修改存储过程DataXmlForNLFW
23- 修改存储过程a_17025_SYSZZ_dis_Item
24- 修改存储过程a_17025_dis_OpLog
25- 修改存储过程a_Tree_dis_Child_byTreeID2
26- 修改存储过程a_17025_GLTX_dis_Goal
27- 修改存储过程d_YWZC_dis_Sample_YPJS
28- 修改存储过程a_NLFW_details_dis
2021-03-15和2021-03-16
insert into tb_Flow_config
(FlowName,FlowType,BeforChar) values
('7.10不符合明细','BFHX','BFHX')
insert into tb_Flow_Branch_config
(MainAID,BranchName,BranchCode,BranchType,ChargeType) values
(10,'关闭审核','2030','排他','群组')
01-修改存储过程a_User_can_Edit
01-修改存储过程a_TXLC_dis_OpLog
02-修改存储过程a_TXLC_new_Flow1
03-修改存储过程a_TXLC_upd_Flow3
04-修改存储过程a_TXLC_upd_FlowB_BFHX_FJSH
05-修改存储过程a_TXLC_upd_Flow4
06-修改存储过程a_TXLC_upd_Flow9
07-修改存储过程a_TXLC_upd_FlowB_BFHX
2021-03-17
01-给表增加字段
Alter table tb_TXLC add Flow10Person varchar(100)
Alter table tb_TXLC add Flow10Date datetime
Alter table tb_TXLC add Flow10Remark varchar(100)
Alter table tb_TXLC add Flow101 varchar(100)
Alter table tb_TXLC add Flow102 varchar(100)
Alter table tb_TXLC add Flow103 varchar(100)
Alter table tb_TXLC add Flow104 varchar(100)
Alter table tb_TXLC add Flow105 varchar(100)
Alter table tb_TXLC add Flow106 varchar(100)
02-创建存储过程-DataForXmlBFHX
03-修改存储过程-a_TXLC_dis_bySnID_BFHX
不知道这个地方的当前责任人需要如何修改
HCCG20210004
update tb_HC_Op set FlowNodePerson='胡立端' where FlowNodePerson='HuLD'
update tb_HC_Op set FlowNodePerson='徐亦恺' where FlowNodePerson='XuYK'
update tb_HC_Op set FlowNodePerson='张清清' where FlowNodePerson='ZhangQQ'
update tb_HC_Op set FlowNodePerson='季娟' where FlowNodePerson='JiJuan'
update tb_HC_Op set FlowNodePerson='贾亚波' where FlowNodePerson='JiaYB'
update tb_HC_Op set FlowNodePerson='徐建军' where FlowNodePerson='XuJJ'
update tb_HC_Op set FlowNodePerson='乐逸,徐建军' where FlowNodePerson='LeYi,XuJJ'
update tb_HC_Op set FlowNodePerson='乐逸,滕怡玫' where FlowNodePerson='LeYi,TengYM'
update tb_HC_Op set FlowNodePerson='杨燕,张盘新' where FlowNodePerson='YangYan,ZhangPX'
update tb_HC_Op set FlowNodePerson='贾亚波' where FlowNodePerson='JiaYB'
update tb_HC_Op set FlowNodePerson='杨珊珊' where FlowNodePerson='YangSS'
update tb_HC_Op set FlowNodePerson='刘登平' where FlowNodePerson='LiuDP'
update tb_HC_Op set FlowNodePerson='刘语嫣' where FlowNodePerson='LiuYY'
update tb_HC_Op set FlowNodePerson='徐栋' where FlowNodePerson='XuDong'
这个地方报错的问题已经修改好,不知道当前责任人是否是也需要变成只显示实际名称
这个当前责任人是否也需要改成显示用户实际的姓名
update te_17025_Record_Main set FlowNodePerson='杨燕,杨燕' where FlowNodePerson='YangYan,YangYan' and
TypeCode='BQDDBAJH'
2021-03-15
1-a_User_can_Edit