/// <summary> /// 得到一个对象实体 /// </summary> public DataAngine.Model.hitrecord_detail DataRowToModel(DataRow row) { DataAngine.Model.hitrecord_detail model = new DataAngine.Model.hitrecord_detail(); if (row != null) { if (row["id"] != null && row["id"].ToString() != "") { model.id = int.Parse(row["id"].ToString()); } if (row["hit_record_id"] != null && row["hit_record_id"].ToString() != "") { model.hit_record_id = int.Parse(row["hit_record_id"].ToString()); } if (row["user_id"] != null && row["user_id"].ToString() != "") { model.user_id = int.Parse(row["user_id"].ToString()); } if (row["rank"] != null && row["rank"].ToString() != "") { model.rank = int.Parse(row["rank"].ToString()); } if (row["score"] != null && row["score"].ToString() != "") { model.score = float.Parse(row["score"].ToString()); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool UpdateByUserId(DataAngine.Model.hitrecord_detail model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update hitrecord_detail set "); strSql.Append("hit_record_id=:hit_record_id,"); strSql.Append("rank=:rank,"); strSql.Append("score=:score"); strSql.Append(" where user_id=:user_id"); OracleParameter[] parameters = { new OracleParameter(":hit_record_id", OracleType.Int32), new OracleParameter(":user_id", OracleType.Int32), new OracleParameter(":rank", OracleType.Int32), new OracleParameter(":score", OracleType.Float), new OracleParameter(":id", OracleType.Int32) }; parameters[0].Value = model.hit_record_id; parameters[1].Value = model.user_id; parameters[2].Value = model.rank; parameters[3].Value = model.score; parameters[4].Value = model.id; int rows = DbHelperOracle.ExecuteNonQuery(CommandType.Text, strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(DataAngine.Model.hitrecord_detail model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update hitrecord_detail set "); strSql.Append("hit_record_id=@hit_record_id,"); strSql.Append("user_id=@user_id,"); strSql.Append("rank=@rank,"); strSql.Append("score=@score"); strSql.Append(" where id=@id"); MySqlParameter[] parameters = { new MySqlParameter("@hit_record_id", MySqlDbType.Int32, 11), new MySqlParameter("@user_id", MySqlDbType.Int32, 11), new MySqlParameter("@rank", MySqlDbType.Int32, 11), new MySqlParameter("@score", MySqlDbType.Float), new MySqlParameter("@id", MySqlDbType.Int32, 11) }; parameters[0].Value = model.hit_record_id; parameters[1].Value = model.user_id; parameters[2].Value = model.rank; parameters[3].Value = model.score; parameters[4].Value = model.id; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); //strSql.Append("update hitrecord_detail set "); //strSql.Append("hit_record_id=:hit_record_id,"); //strSql.Append("user_id=:user_id,"); //strSql.Append("rank=:rank,"); //strSql.Append("score=:score"); //strSql.Append(" where id=:id"); //OracleParameter[] parameters = { // new OracleParameter(":hit_record_id", OracleType.Int32), // new OracleParameter(":user_id", OracleType.Int32), // new OracleParameter(":rank", OracleType.Int32), // new OracleParameter(":score", OracleType.Float), // new OracleParameter(":id", OracleType.Int32)}; //parameters[0].Value = model.hit_record_id; //parameters[1].Value = model.user_id; //parameters[2].Value = model.rank; //parameters[3].Value = model.score; //parameters[4].Value = model.id; //int rows = DbHelperOracle.ExecuteNonQuery(CommandType.Text, strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(DataAngine.Model.hitrecord_detail model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into hitrecord_detail("); strSql.Append("hit_record_id,user_id,rank,score)"); strSql.Append(" values ("); strSql.Append("@hit_record_id,@user_id,@rank,@score)"); MySqlParameter[] parameters = { new MySqlParameter("@hit_record_id", MySqlDbType.Int32, 11), new MySqlParameter("@user_id", MySqlDbType.Int32, 11), new MySqlParameter("@rank", MySqlDbType.Int32, 11), new MySqlParameter("@score", MySqlDbType.Float) }; parameters[0].Value = model.hit_record_id; parameters[1].Value = model.user_id; parameters[2].Value = model.rank; parameters[3].Value = model.score; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); //strSql.Append("insert into TH_FACE_HITRECORD_DETAIL("); //strSql.Append("hit_record_id,user_id,rank,score)"); //strSql.Append(" values ("); //strSql.Append(":hit_record_id,:user_id,:rank,:score)"); //OracleParameter[] parameters = { // new OracleParameter(":hit_record_id", OracleType.Int32), // new OracleParameter(":user_id", OracleType.Int32), // new OracleParameter(":rank", OracleType.Int32), // new OracleParameter(":score", OracleType.Float)}; //parameters[0].Value = model.hit_record_id; //parameters[1].Value = model.user_id; //parameters[2].Value = model.rank; //parameters[3].Value = model.score; //int rows = DbHelperOracle.ExecuteNonQuery(CommandType.Text, strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
static void hitalertAddTest() { DataAngine.BLL.hitalert habll = new DataAngine.BLL.hitalert(); DataAngine.Model.hitrecord_detail hd1 = new DataAngine.Model.hitrecord_detail(); DataAngine.Model.hitrecord_detail hd2 = new DataAngine.Model.hitrecord_detail(); DataAngine.Model.hitalert ha = new DataAngine.Model.hitalert(); DataAngine.Model.hitrecord hit = new DataAngine.Model.hitrecord(); hit.threshold = 0.6f; hit.face_query_image_path = "D:/1.jpg"; hit.occur_time = DateTime.Now; hd1.rank = 1; hd1.score = 0.867f; hd2.user_id = 1; hd2.rank = 2; hd2.score = 0.8f; hd2.user_id = 1; ha.details = new DataAngine.Model.hitrecord_detail[2]; ha.details[0] = hd1; ha.details[1] = hd2; ha.hit = hit; habll.Add(ha); }
/// <summary> /// 根据HitrecordId 获得 hitrecord_detail /// </summary> /// <param name="HitrecordId"></param> /// <returns></returns> public List <DataAngine.Model.hitrecord_detail> GetModelByHitUserId(int hitUserId) { List <DataAngine.Model.hitrecord_detail> modelList = new List <Model.hitrecord_detail>(); StringBuilder strSql = new StringBuilder(); strSql.Append("select id,hit_record_id,user_id,rank,score from hitrecord_detail "); strSql.Append(" where user_id=@user_id"); OracleParameter[] parameters = { new OracleParameter("@user_id", OracleType.Int32) }; parameters[0].Value = hitUserId; DataAngine.Model.hitrecord_detail model = new DataAngine.Model.hitrecord_detail(); DataSet ds = DbHelperOracle.ExecuteDataSet(CommandType.Text, strSql.ToString(), parameters); foreach (var row in ds.Tables[0].Rows) { modelList.Add(DataRowToModel((DataRow)row)); } return(modelList); }
/// <summary> /// 根据HitrecordId 获得 hitrecord_detail /// </summary> /// <param name="HitrecordId"></param> /// <returns></returns> public List <DataAngine.Model.hitrecord_detail> GetModelByHitrecordId(int HitrecordId) { List <DataAngine.Model.hitrecord_detail> modelList = new List <Model.hitrecord_detail>(); StringBuilder strSql = new StringBuilder(); strSql.Append("select id,hit_record_id,user_id,rank,score from hitrecord_detail "); strSql.Append(" where hit_record_id=@hit_record_id"); MySqlParameter[] parameters = { new MySqlParameter("@hit_record_id", MySqlDbType.Int32) }; parameters[0].Value = HitrecordId; DataAngine.Model.hitrecord_detail model = new DataAngine.Model.hitrecord_detail(); DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters); foreach (var row in ds.Tables[0].Rows) { modelList.Add(DataRowToModel((DataRow)row)); } return(modelList); }
/// <summary> /// 得到一个对象实体 /// </summary> public DataAngine.Model.hitrecord_detail GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select id,hit_record_id,user_id,rank,score from hitrecord_detail "); strSql.Append(" where id=@id"); MySqlParameter[] parameters = { new MySqlParameter("@id", MySqlDbType.Int32) }; parameters[0].Value = id; DataAngine.Model.hitrecord_detail model = new DataAngine.Model.hitrecord_detail(); DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }