/// <summary> /// 得到一个对象实体 /// </summary> public DataAngineSet.Model.device GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select id,name,video_address,departmentment_id,longitude,latitude,location_type,type,remark from device "); strSql.Append(" where id=@id"); //strSql.Append("select d.id,d.name,d.video_address,d.departmentment_id,d.longitude,d.latitude,dpt.name as location_type ,d.type,d.remark from device as d INNER JOIN device_placetype as dpt on d.location_type = dpt.id "); //strSql.Append(" where d.id=@id"); MySqlParameter[] parameters = { new MySqlParameter("@id", MySqlDbType.Int32) }; parameters[0].Value = id; DataAngineSet.Model.device model = new DataAngineSet.Model.device(); DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
bool Init(int taskID) { DataAngineSet.Model.surveillance_task task = taskBll.GetModel(taskID); if (null == task) { Log.Debug("检索任务失败"); return(false); } DataAngineSet.Model.device device = deviceBll.GetModel(task.device_id); if (null == device) { Log.Debug("检索设备失败"); return(false); } DataAngineSet.Model.person_dataset person_dataset = datasetBll.GetModel(task.person_dataset_id); if (null == person_dataset) { Log.Debug("检索库失败"); return(false); } InitFRS(); fa.LoadData(person_dataset.id); cap.TaskID = taskID; cap.HitAlertReturnEvent += new Capture.HitAlertCallback(OnHit); int id = -1; try { Log.Debug(device.video_address); id = Convert.ToInt32(device.video_address); } catch { } if (id == -1) { if (cap.Start(device.video_address) != ReturnCode.SUCCESS) { Log.Debug("打开摄像头失败"); return(false); } } else { if (cap.Start(id) != ReturnCode.SUCCESS) { Log.Debug("打开摄像头失败"); return(false); } } return(true); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(DataAngineSet.Model.device model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update device set "); strSql.Append("name=@name,"); strSql.Append("video_address=@video_address,"); strSql.Append("departmentment_id=@departmentment_id,"); strSql.Append("longitude=@longitude,"); strSql.Append("latitude=@latitude,"); strSql.Append("location_type=@location_type,"); strSql.Append("type=@type,"); strSql.Append("remark=@remark"); strSql.Append(" where id=@id"); MySqlParameter[] parameters = { new MySqlParameter("@name", MySqlDbType.VarChar, 50), new MySqlParameter("@video_address", MySqlDbType.VarChar, 200), new MySqlParameter("@departmentment_id", MySqlDbType.VarChar, 50), new MySqlParameter("@longitude", MySqlDbType.Double, 5), new MySqlParameter("@latitude", MySqlDbType.Double, 5), new MySqlParameter("@location_type", MySqlDbType.VarChar, 50), new MySqlParameter("@type", MySqlDbType.VarChar, 50), new MySqlParameter("@remark", MySqlDbType.VarChar, 50), new MySqlParameter("@id", MySqlDbType.Int32, 11) }; parameters[0].Value = model.name; parameters[1].Value = model.video_address; parameters[2].Value = model.departmentment_id; parameters[3].Value = model.longitude; parameters[4].Value = model.latitude; parameters[5].Value = model.location_type; parameters[6].Value = model.type; parameters[7].Value = model.remark; parameters[8].Value = model.id; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public DataAngineSet.Model.device DataRowToModel(DataRow row) { DataAngineSet.Model.device model = new DataAngineSet.Model.device(); if (row != null) { if (row["id"] != null && row["id"].ToString() != "") { model.id = int.Parse(row["id"].ToString()); } if (row["name"] != null) { model.name = row["name"].ToString(); } if (row["video_address"] != null) { model.video_address = row["video_address"].ToString(); } if (row["departmentment_id"] != null) { model.departmentment_id = row["departmentment_id"].ToString(); } if (row["longitude"] != null) { model.longitude = System.Convert.ToDouble(row["longitude"].ToString()); } if (row["latitude"] != null) { model.latitude = System.Convert.ToDouble(row["latitude"].ToString()); } //model.longitude=row["longitude"].ToString(); //model.latitude=row["latitude"].ToString(); if (row["location_type"] != null) { model.location_type = row["location_type"].ToString(); } if (row["type"] != null) { model.type = row["type"].ToString(); } if (row["remark"] != null) { model.remark = row["remark"].ToString(); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(DataAngineSet.Model.device model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into device("); strSql.Append("name,video_address,departmentment_id,longitude,latitude,location_type,type,remark)"); strSql.Append(" values ("); strSql.Append("@name,@video_address,@departmentment_id,@longitude,@latitude,@location_type,@type,@remark)"); MySqlParameter[] parameters = { new MySqlParameter("@name", MySqlDbType.VarChar, 50), new MySqlParameter("@video_address", MySqlDbType.VarChar, 200), new MySqlParameter("@departmentment_id", MySqlDbType.VarChar, 50), new MySqlParameter("@longitude", MySqlDbType.Double, 5), new MySqlParameter("@latitude", MySqlDbType.Double, 5), new MySqlParameter("@location_type", MySqlDbType.VarChar, 50), new MySqlParameter("@type", MySqlDbType.VarChar, 50), new MySqlParameter("@remark", MySqlDbType.VarChar, 50) }; parameters[0].Value = model.name; parameters[1].Value = model.video_address; parameters[2].Value = model.departmentment_id; parameters[3].Value = model.longitude; parameters[4].Value = model.latitude; parameters[5].Value = model.location_type; parameters[6].Value = model.type; parameters[7].Value = model.remark; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }