/// <summary>
/// 通过单个分机号获取正在等待的分机信息
/// </summary>
/// <returns></returns>
public static void GetChannelsinfo(out List <Channelsinfo> infoes)
{
infoes = new List <Channelsinfo>();
string sql = "SELECT uuid,ExtensionNO,application,application_data from ipvt_channelsinfotable";
MySqlDataReader reader = null;
try
{
reader = CustomMySqlHelper.ExecuteDataReader(sql);
while (reader.Read())
{
Channelsinfo model = new Channelsinfo();
model.Uuid = EvaluationHelper.ObjectToString(reader["uuid"]);
model.ExtNo = EvaluationHelper.ObjectToString(reader["ExtensionNO"]);
model.ApplicationInfo = EvaluationHelper.ObjectToString(reader["application"]);
model.ApplicationDate = EvaluationHelper.ObjectToString(reader["application_data"]);
infoes.Add(model);
}
}
catch (Exception ex)
{
LogHelper.MainLog(ex.Message);
}
finally
{
if (reader != null)
{
reader.Close();
}
}
}
/// <summary>
/// 通过单个分机号获取正在等待的分机信息
/// </summary>
/// <param name="exten">分机号</param>
/// <returns></returns>
public static Channelsinfo GetChannelsinfo(string exten)
{
string sql = "SELECT uuid,ExtensionNO,application,application_data from ipvt_channelsinfotable where ExtensionNO=?extenNo";
var ps = new MySqlParameter[1];
ps[0] = new MySqlParameter("?extenNo", exten);
MySqlDataReader reader = null;
try
{
reader = CustomMySqlHelper.ExecuteDataReader(sql, ps);
while (reader.Read())
{
Channelsinfo model = new Channelsinfo();
model.Uuid = EvaluationHelper.ObjectToString(reader["uuid"]);
model.ExtNo = EvaluationHelper.ObjectToString(reader["ExtensionNO"]);
model.ApplicationInfo = EvaluationHelper.ObjectToString(reader["application"]);
model.ApplicationDate = EvaluationHelper.ObjectToString(reader["application_data"]);
return(model);
}
}
catch (Exception ex)
{
LogHelper.MainLog(ex.Message);
}
finally
{
if (reader != null)
{
reader.Close();
}
}
return(null);
}
