2018-07-05

2018 年 7 月 5 日2018 年 7 月 5 日 by 沧海之树 In 工作

--退费用户的项目不能执行，把CustomerConsumptionDetails设置成不能执行 2018-07-05
update a set CanExecute=0,ReturnMoneyStatus=2 from CustomerConsumptionDetails a inner join ReturnMoneyForCertainDoc b
on a.ExcutionNumber=b.ExcutionNumber and a.ItemID=b.ItemID

--更新客户现场咨询信息2018-07-05

with t
as
(
select c.Now as cNow, a.sZXGW,b.sName,d.Now as dNow from YUN_HIS20180705.dbo.H_TMK a
inner join YUN_HIS20180705.dbo.H_EMPLOYEE b on b.sEmpNo=a.sZXGW
inner join bh20180529.dbo.EmployeeID c on c.Original=b.sEmpNo
inner join bh20180529.dbo.CustomerBaseInfoID d on d.Original=a.FID
where a.sZXGW='1856'
)
update a set SceneEmployee=t.cNow from bh20180529.dbo.CustomerBaseInfo a inner join t on a.ID=t.dNow

select * from YUN_HIS20180705.dbo.H_TMK where sZXGW='1856' and FID not in (select dNow from t)

 

--增加新员工

insert into EmployeeID(Original,Now) values('1856','00446')