/// <summary>
/// read json file to list
/// </summary>
/// <param name="url"></param>
/// <returns></returns>
public List <BarNameEntity> getJsonContent(string filepath)
{
List <BarNameEntity> listkeyWorldEntity = new List <BarNameEntity>();
try
{
if (string.IsNullOrEmpty(filepath))
{
return(null);
}
IOFileHelper iOFileHelper = new IOFileHelper();
var strContext = iOFileHelper.ReadTxtFile(filepath);
var byteData = strContext.Split('-');
UrlCodeConvert urlCodeConvert = new UrlCodeConvert();
foreach (var item in byteData)
{
BarNameEntity barNameEntity = new BarNameEntity();
barNameEntity.BarName = item.Trim();
barNameEntity.Url = urlCodeConvert.EncodeUrl(item.Trim());
listkeyWorldEntity.Add(barNameEntity);
}
return(listkeyWorldEntity);
}
catch
{
Debug.WriteLine("KeyWorldService");
}
return(listkeyWorldEntity);
}
/// java服务端编写 不安全方法 Visiable修改好
/// <summary>
/// 给mysql查询贴吧名称列表
/// </summary>
/// <param name="brNameEntity"></param>
/// <returns></returns>
public List <BarNameEntity> SelectTBName(string token = null)
{
ISQLConnection iSQLConnection = new MySqlConn();
var sqlconn = iSQLConnection.GetMysqlConn();
List <BarNameEntity> listBarNameEntity = new List <BarNameEntity>();
try
{
string sql = @"SELECT BarName,Url,Type,Hot FROM homefood.bd_bar_name 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)
{
BarNameEntity barNameEntity = new BarNameEntity();
barNameEntity.BarName = Convert.ToString(dataRow["BarName"]);
barNameEntity.Url = Convert.ToString(dataRow["Url"]);
barNameEntity.Type = Convert.ToString(dataRow["Type"]);
barNameEntity.Hot = Convert.ToInt32(dataRow["Hot"]);
listBarNameEntity.Add(barNameEntity);
}
return(listBarNameEntity);
}
catch (Exception e)
{
Debug.WriteLine("-------TBKeywordDAL error--------" + e);
}
return(listBarNameEntity);
}