/// <summary>
/// (DB)依SQL指令取得資料結果(一個字串)
/// </summary>
public string _DB_GetStr(string strSql, bool cache = false, int cacheSeconds = 60)
{
if (cache && cacheSeconds > 0)
{
cacheDatas.RemoveAll(x => x.createTime < DateTime.Now.AddSeconds(cacheSeconds * -1));
var result = cacheDatas.Find(x => x.strSql == strSql);
if (result == null)
{
var str = DBC.GetSQLCmd_Str(strSql);
cacheDatas.Add(new CacheData()
{
strSql = strSql,
resultStr = str,
createTime = DateTime.Now
});
return(str);
}
else
{
return(result.resultStr);
}
}
else
{
return(DBC.GetSQLCmd_Str(strSql));
}
}