62,041
社区成员
发帖
与我相关
我的任务
分享
select count(*) from (
select CONVERT(varchar(12) , Logdate, 111 ) Logdate from Log_Activity where [from]<>0 and user_id=2272
union select CONVERT(varchar(12) , Logdate, 111 ) Logdate from Log_sleep where user_id=2272
) A where Logdate between '2014/07/07' and '2014/07/09'
Users.SQLHelper.CommandText = @"select count(*) from (
select CONVERT(varchar(12) , Logdate, 111 ) Logdate from Log_Activity where [from]<>0 and user_id=@id
union select CONVERT(varchar(12) , Logdate, 111 ) Logdate from Log_sleep where user_id=@id
) A where Logdate between @start and @end";
Users.SQLHelper.ParamCollection.Add(Users.SQLHelper.CreateParameter("@id", userId));
Users.SQLHelper.ParamCollection.Add(Users.SQLHelper.CreateParameter("@start", start.ToString("yyyy/MM/dd")));
Users.SQLHelper.ParamCollection.Add(Users.SQLHelper.CreateParameter("@end", end.ToString("yyyy/MM/dd")));
int count = Users.SQLHelper.ExecuteScalar<int>();