/// <summary> /// get keyworld content from text file /// </summary> /// <param name="url"></param> /// <returns></returns> public List <KeyWorldEntity> getTextContent(string url) { List <KeyWorldEntity> listkeyWorldEntity = new List <KeyWorldEntity>(); try { if (string.IsNullOrEmpty(url)) { return(null); } IOFileHelper iOFileHelper = new IOFileHelper(); var strContext = iOFileHelper.ReadTxtFile(url); var byteData = strContext.Split('-'); foreach (var item in byteData) { KeyWorldEntity keyWorldEntity = new KeyWorldEntity(); keyWorldEntity.KeyWorld = item.Trim(); listkeyWorldEntity.Add(keyWorldEntity); } return(listkeyWorldEntity); } catch { Debug.WriteLine("KeyWorldService"); } return(listkeyWorldEntity); }
/// <summary> /// search keyworld /// </summary> /// <param name="sqlconn"></param> /// <param name="keyWorldEntity"></param> /// <returns></returns> public List<KeyWorldEntity> SelectSysKeyworld(KeyWorldEntity keyWorldEntity = null) { ISQLConnection iSQLConnection = new MySqlConn(); var sqlconn = iSQLConnection.GetMysqlConn(); List<KeyWorldEntity> listKeyWorldEntity = new List<KeyWorldEntity>(); try { string sql = @"SELECT KeyWorld,HotLeve FROM homefood.sys_key_world where visiable=1"; MySqlCommand cmd = new MySqlCommand(sql, sqlconn); sqlconn.Open(); MySqlDataReader DataReader = cmd.ExecuteReader(); DataTable dataTable = new DataTable(); dataTable.Load(DataReader); foreach (DataRow dataRow in dataTable.Rows) { KeyWorldEntity kwEntity = new KeyWorldEntity(); kwEntity.KeyWorld = Convert.ToString(dataRow["KeyWorld"]); kwEntity.HotLeve = Convert.ToInt32(dataRow["HotLeve"]); listKeyWorldEntity.Add(kwEntity); } return listKeyWorldEntity; } catch (Exception e) { Debug.WriteLine("-------TBKeywordDAL error--------" + e); } return listKeyWorldEntity; }