2018-09-05

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

select * from ChargeForCertainDocInfo where ExcutionNumber='HSJDA6U1T4X7'

select * from ChargeForCertainDocDetails where ExcutionNumber='HSJDA6U1T4X7'

select * from CustomerConsumptionInfo where ExcutionNumber='HSJDA6U1T4X7'

select * from FinanceTotal where DocInfoCode='HSJDA6U1T4X7'

select * from CertainDocDetailsTotalRecord a inner join FinanceTotal b on a.CertainProjectID=b.CertainProjectID where b.DocInfoCode='HSJDA6U1T4X7' and a.DocType=0

update a set Date='2018-07-10 17:14:17.045' from CertainDocDetailsTotalRecord a inner join FinanceTotal b on a.CertainProjectID=b.CertainProjectID where a.DocType=0 and b.DocInfoCode='HSJDA6U1T4X7'

select * from CustomerBaseInfo where ID='H9A674HKRC'

select * from DictMaster

select * from DictDetail

 

select sum(a.mSKTotal) c,a.sZXYS,b.sName from H_FrontSK a inner join H_Employee b on a.sZXYS=b.sEmpNo where dDT>'2018-09-01 00:00:00.000' and dDT<'2018-09-30 00:00:00.000' group by a.sZXYS,b.sName order by c DESC