/// <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;
}
