string deviceCode=dt.Rows[i]["code"].ToString();
string sql_logtime = @"select  stuff((
select ','+CONVERT(Nvarchar,l2.logtime, 20)  from logs_signIn l2 where CONVERT(Nvarchar,l2.logtime, 23)='" + DateTime.Now.ToString("yyyy-MM-dd") + @"'  
order by l2.logtime desc 
FOR XML PATH(''))
,1,1,'') logtimes ";
object obj = DbHelperSQL.GetSingle(sql_logtime);

 

posted on 2021-06-04 15:14  十行道人  阅读(590)  评论(0编辑  收藏  举报