关于爱索

1、如何修改考勤时间

UPDATE [AsiaCardServer].[dbo].[Tab_S_ClockData]
SET  [ClockDate] = '2015-12-07 07:43:42'
WHERE [A_Accounts]=609 and id=

id查询方式

SELECT *   FROM [AsiaCardServer].[dbo].[Tab_S_ClockData]   where  [A_Accounts]=609

计次明细查询

select TranAll.A_Accounts as 账号, A_Number as 编号, A_Name as 姓名, D_Name as 部门,Dg_Name as 身份, W_Name as 工作站, Pos_ID as 终端机, T_Money, T_LastMoney, T_Date as 消费时间 , AccountDay as 记账时间, flag, SecFlag = Case When TranAll.Flag = 34 then 1 else 0 end,TransFlag, SecMoneyFlag = case (TransFlag & 8) when 0 then 0 else 1 end, OfflineFlag = Case (TransFlag & 2) When 0 then 0 else 1 end  
FROM  ((Select * from Tab_S_Transaction201802)) as TranAll LEFT OUTER JOIN Tab_S_Accounts ON Tab_S_Accounts.A_Accounts= TranAll.A_Accounts LEFT OUTER JOIN Tab_S_Degree ON Tab_S_Accounts.DG_ID =  Tab_S_Degree.Dg_ID LEFT OUTER JOIN Tab_S_Department ON Tab_S_Department.D_ID =  Tab_S_Accounts.D_ID LEFT OUTER JOIN Tab_S_WorkStation ON Tab_S_WorkStation.W_ID =  TranAll.W_ID 
where (AccountDay >= '2018-2-1') and (AccountDay < '2018-2-28') and (TranAll.W_ID = 1) and ((TranAll.Pos_ID = 1) or (TranAll.Pos_ID = 5)) and ((TranAll.Flag = 33) or (TranAll.Flag = 34))
order by D_Name, A_Number