/// <summary> /// 得到一个对象实体 /// </summary> public DataAngine_Set.Model.surveillancetask DataRowToModel(DataRow row) { DataAngine_Set.Model.surveillancetask model = new DataAngine_Set.Model.surveillancetask(); 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["databaseid"] != null && row["databaseid"].ToString() != "") { model.databaseid = int.Parse(row["databaseid"].ToString()); } if (row["deviceid"] != null && row["deviceid"].ToString() != "") { model.deviceid = int.Parse(row["deviceid"].ToString()); } if (row["type"] != null && row["type"].ToString() != "") { model.type = int.Parse(row["type"].ToString()); } if (row["remark"] != null) { model.remark = row["remark"].ToString(); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(DataAngine_Set.Model.surveillancetask model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into surveillancetask("); strSql.Append("name,databaseid,deviceid,type,remark)"); strSql.Append(" values ("); strSql.Append("@name,@databaseid,@deviceid,@type,@remark)"); MySqlParameter[] parameters = { new MySqlParameter("@name", MySqlDbType.VarChar, 50), new MySqlParameter("@databaseid", MySqlDbType.Int32, 11), new MySqlParameter("@deviceid", MySqlDbType.Int32, 11), new MySqlParameter("@type", MySqlDbType.Int32, 11), new MySqlParameter("@remark", MySqlDbType.VarChar, 50) }; parameters[0].Value = model.name; parameters[1].Value = model.databaseid; parameters[2].Value = model.deviceid; parameters[3].Value = model.type; parameters[4].Value = model.remark; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
bool Init(int taskID) { DataAngine_Set.Model.surveillancetask task = taskBll.GetModel(taskID); if (null == task) { Log.Debug("检索任务失败"); return(false); } DataAngine_Set.Model.device device = deviceBll.GetModel(task.deviceid); if (null == device) { Log.Debug("检索设备失败"); return(false); } DataAngine_Set.Model.dataset dataset = datasetBll.GetModel(task.databaseid); if (null == dataset) { Log.Debug("检索库失败"); return(false); } InitFRS(); fa.LoadData(dataset.datasetname); cap.HitAlertReturnEvent += new Capture.HitAlertCallback(OnHit); int id = -1; try { Log.Debug(device.address); id = Convert.ToInt32(device.address); } catch { } if (id == -1) { if (cap.Start(device.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(DataAngine_Set.Model.surveillancetask model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update surveillancetask set "); strSql.Append("name=@name,"); strSql.Append("databaseid=@databaseid,"); strSql.Append("deviceid=@deviceid,"); strSql.Append("type=@type,"); strSql.Append("remark=@remark"); strSql.Append(" where id=@id"); MySqlParameter[] parameters = { new MySqlParameter("@name", MySqlDbType.VarChar, 50), new MySqlParameter("@databaseid", MySqlDbType.Int32, 11), new MySqlParameter("@deviceid", MySqlDbType.Int32, 11), new MySqlParameter("@type", MySqlDbType.Int32, 11), new MySqlParameter("@remark", MySqlDbType.VarChar, 50), new MySqlParameter("@id", MySqlDbType.Int32, 11) }; parameters[0].Value = model.name; parameters[1].Value = model.databaseid; parameters[2].Value = model.deviceid; parameters[3].Value = model.type; parameters[4].Value = model.remark; parameters[5].Value = model.id; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public DataAngine_Set.Model.surveillancetask GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select id,name,databaseid,deviceid,type,remark from surveillancetask "); strSql.Append(" where id=@id"); MySqlParameter[] parameters = { new MySqlParameter("@id", MySqlDbType.Int32) }; parameters[0].Value = id; DataAngine_Set.Model.surveillancetask model = new DataAngine_Set.Model.surveillancetask(); DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }