select b.ClaimNo, a.Department,a.Master,a.TreatTime,casewhen a.DiningPlan =1then'早餐'when a.DiningPlan =2then'午餐'when a.DiningPlan =3then'晚餐'when a.DiningPlan =4then'其他'end,
a.OtherDiningPlan,casewhen a.TreatType =1then'商务招待'when a.TreatType =2then'外事招待'when a.TreatType =3then'其他公务招待'end,
a.Guest,a.TreatCause,a.TotalCost,a.DiningPlace,a.PeopleNumber,a.NBPeopleNumber,a.PerMoney,a.DrinksCost,a.SpecialNote
from dbo.ClaimChildTravel AS a LEFTOUTERJOIN
ClaimApply as b on a.FormID=b.FormID
LEFTOUTERJOIN
bpmdb.dbo.BPMI_TOKENLAST AS c ON c.TaskID = b.TaskId
where c.TokenName='结束'and b.CostType=10and b.Contents notlike'%业务招待费%'and a.IsDel=0
case when a.DiningPlan =1 then '早餐' when a.DiningPlan =2 then '午餐' when a.DiningPlan =3 then '晚餐' when a.DiningPlan =4 then '其他' end ,select b.ClaimNo, a.Department,a.Master,a.TreatTime,case when a.DiningPlan =1 then '早餐' when a.DiningPlan =2 then '午餐'