/// <summary>
/// 获取监所的视频参数
/// </summary>
/// <param name="prisonID">9位的监所编号，即JS_CODE字段</param>
/// <returns></returns>
public List <VideoInfoModel> GetVideoOfPrison(String prisonID, VideoTypeModel.AreaType type)
{
return(videoManager.GetVideoOfPrison(prisonID, type));
}
/// <summary>
/// 获取监所的视频参数
/// </summary>
/// <param name="prisonID">9位的监所编号，即JS_CODE字段</param>
/// <returns></returns>
public List <VideoInfoModel> GetVideoOfPrison(String prisonID, VideoTypeModel.AreaType type)
{
List <VideoInfoModel> list = new List <VideoInfoModel>();
String civil_code = prisonID.Substring(0, 6);
String sql_suffix = null;
switch (type)
{
case VideoTypeModel.AreaType.Detention:
sql_suffix = "'%看守所%'";
break;
case VideoTypeModel.AreaType.DrugAbuse:
sql_suffix = "'%戒毒所%'";
break;
case VideoTypeModel.AreaType.Custody:
sql_suffix = "'%拘留所%'";
break;
default:
break;
}
try
{
using (DbConnection conn = new MySqlConnection(this.KedaConnectString))
{
conn.Open();
String sql = "select gbid, kdid, kddomainid, name, longitude, latitude, channel from tblGbDevice where civilCode is not null and length(civilCode)=8 and substr(civilCode,length(civilCode)-1,2) = '92' and name like ";
if (sql_suffix != null)
{
using (DbCommand cmd = conn.CreateCommand())
{
cmd.CommandText = sql + sql_suffix;
using (DbDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
if (reader.IsDBNull(0) || reader.IsDBNull(1) || reader.IsDBNull(2) ||
reader.IsDBNull(3) || reader.IsDBNull(4))
{
continue;
}
VideoInfoModel v = new VideoInfoModel();
v.Gbid = reader[0].ToString();
v.DeviceId = reader[1].ToString();
v.DomainId = reader[2].ToString();
v.VideoName = reader[3].ToString();
double longitude;
if (Double.TryParse(reader[4].ToString(), out longitude))
{
v.X = longitude;
}
double latitude;
if (Double.TryParse(reader[5].ToString(), out latitude))
{
v.Y = latitude;
}
v.VideoChannel = reader[6].ToString();
list.Add(v);
}
}
}
}
}
}
catch (Exception ex)
{
}
/*using (NpgsqlConnection conn = new NpgsqlConnection(connectString))
* {
* try
* {
* conn.Open();
* if (civil_code == "621023")
* {
* String sql_first = "select kdid55,name,jd,wd from gbid where fzmc like '%华池县监管场所%'";
* NpgsqlCommand cmd_first = new NpgsqlCommand(sql_first, conn);
* NpgsqlDataReader reader_first = cmd_first.ExecuteReader();
* while (reader_first.Read())
* {
* if (reader_first.IsDBNull(0) || reader_first.IsDBNull(1))
* continue;
* VideoInfoModel model = new VideoInfoModel();
* model.VideoChannel = reader_first.GetString(0);
* if (model.VideoChannel == "55000000000000000011113632400000" || model.VideoChannel == "55000000000000000011113632500000")
* {
* continue;
* }
* model.VideoName = reader_first.GetString(1);
* if (reader_first.IsDBNull(2))
* {
* model.X = 0.0;
* }
* else
* {
* model.X = reader_first.GetDouble(2);
* }
*
* if (reader_first.IsDBNull(3))
* {
* model.Y = 0.0;
* }
* else
* {
* model.Y = reader_first.GetDouble(3);
* }
* model.VideoPort = "0";
* model.VideoSource = 2;
* model.FactoryName = "gb";
* list.Add(model);
* }
* }
* else
* {
*
* String sql_first =
* "select kdid55,name,jd,wd from gbid where fzmc like '%监管场所%' and gbid like '" +
* civil_code + "%' and name like " + sql_suffix;
*
* NpgsqlCommand cmd_first = new NpgsqlCommand(sql_first, conn);
* NpgsqlDataReader reader_first = cmd_first.ExecuteReader();
* while (reader_first.Read())
* {
* if (reader_first.IsDBNull(0) || reader_first.IsDBNull(1))
* continue;
* VideoInfoModel model = new VideoInfoModel();
* model.VideoChannel = reader_first.GetString(0);
* model.VideoName = reader_first.GetString(1);
* if (reader_first.IsDBNull(2))
* {
* model.X = 0.0;
* }
* else
* {
* model.X = reader_first.GetDouble(2);
* }
*
* if (reader_first.IsDBNull(3))
* {
* model.Y = 0.0;
* }
* else
* {
* model.Y = reader_first.GetDouble(3);
* }
* model.VideoPort = "0";
* model.VideoSource = 2;
* model.FactoryName = "gb";
* list.Add(model);
* }
* }
* }
* catch (Exception ex)
* {
* LogMgr.Instance.Error("日志记录", ex);
* }
* }*/
return(list);
}
