日期:2014-05-20 浏览次数:20800 次
DataSet ds = new DataSet();
string explorerdata = @"SELECT TMPLOGID,
APP,
FILENAME,
OPERATOR,
FILESIZE,
AUTHOR,
LOGTIME,
OTHER,
LOGSEQUENCE,
ISANALYSIS
FROM TB_TMPLOG
WHERE 1=1 and LogTime>='{0}' and LogTime<='{1}' and Author='{2}' and app='explorer.exe' and decode(isanalysis,null,0,1)=0";
explorerdata = string.Format(explorerdata, beginDate, endDate, userid);
ds = getDataSetBySQL(explorerdata);//获取临时日志表数据
DataTable dt = ds.Tables[0];
//DataRow rowT = t.Rows[0];