public DataTable selectParam(string bName, string mNmae, string FileName)
{
SQLiteParameter[] param = null;
DataTable dt = new DataTable();
string sql = "select SeqNo,FileName, Size, LastModified, MonitorName, BucketName,Status from Monitor where BucketName ='" + bName + "' ";
if (!string.IsNullOrEmpty(mNmae))
{
sql += " and MonitorName='" + mNmae + "'";
}
if (!string.IsNullOrEmpty(FileName))
{
sql += " and FileName='" + FileName + "'";
}
sql += "order by LastModified desc";
dt = sqlLiteHelper.ExecuteDataTable(sql, param);
return(dt);
}