/// <summary> /// (DB)依SQL指令取得資料結果(回傳DataTable) /// </summary> /// <param name="strSql">SQL</param> /// <returns></returns> public DataTable _DB_GetData(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 dt = DBC.GetSQLCmd_DT(strSql); cacheDatas.Add(new CacheData() { strSql = strSql, dt = dt, createTime = DateTime.Now }); return(dt); } else { return(result.dt); } } else { return(DBC.GetSQLCmd_DT(strSql)); } }
/// <summary> /// (DB)依SQL指令取得資料結果(字串陣列[第n欄]) /// </summary> /// <param name="strSql">SQL</param> /// <param name="n">第n欄(從0開始)</param> public List <string> _DB_GetStrArr(string strSql, int n) { return(DBC.GetSQLCmd_DT(strSql) .AsEnumerable() .Select(row => row.Field <object>(n).ToString()).ToList()); }