/// <summary> /// 增加一条数据 /// </summary> public bool Add(DataAngineSet.Model.hitrecord_detail model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into hitrecord_detail("); strSql.Append("hit_record_id,user_id,rank,score,remark)"); strSql.Append(" values ("); strSql.Append("@hit_record_id,@user_id,@rank,@score,@remark)"); 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("@remark", MySqlDbType.VarChar, 50) }; 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.remark; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public DataAngineSet.Model.hitrecord_detail DataRowToModel(DataRow row) { DataAngineSet.Model.hitrecord_detail model = new DataAngineSet.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 = decimal.Parse(row["score"].ToString()); } if (row["remark"] != null) { model.remark = row["remark"].ToString(); } } return(model); }
static void hitalertAddTest() { DataAngineSet.BLL.hitalert habll = new DataAngineSet.BLL.hitalert(); DataAngineSet.Model.hitrecord_detail hd1 = new DataAngineSet.Model.hitrecord_detail(); DataAngineSet.Model.hitrecord_detail hd2 = new DataAngineSet.Model.hitrecord_detail(); DataAngineSet.Model.hitalert ha = new DataAngineSet.Model.hitalert(); DataAngineSet.Model.hitrecord hit = new DataAngineSet.Model.hitrecord(); hit.threshold = (Decimal)0.6f; hit.face_query_image_path = "D:/1.jpg"; hit.occur_time = DateTime.Now; hd1.rank = 1; hd1.score = (Decimal)0.867f; hd2.user_id = 1; hd2.rank = 2; hd2.score = (Decimal)0.8f; hd2.user_id = 1; ha.details = new DataAngineSet.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 <DataAngineSet.Model.hitrecord_detail> GetModelByHitUserId(int hitUserId) { List <DataAngineSet.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; DataAngineSet.Model.hitrecord_detail model = new DataAngineSet.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 <DataAngineSet.Model.hitrecord_detail> GetModelByHitrecordId(int HitrecordId) { List <DataAngineSet.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; DataAngineSet.Model.hitrecord_detail model = new DataAngineSet.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 bool Update(DataAngineSet.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("remark=@remark"); 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("@remark", MySqlDbType.VarChar, 50), 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.remark; parameters[5].Value = model.id; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public DataAngineSet.Model.hitrecord_detail GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select id,hit_record_id,user_id,rank,score,remark from hitrecord_detail "); strSql.Append(" where id=@id"); MySqlParameter[] parameters = { new MySqlParameter("@id", MySqlDbType.Int32) }; parameters[0].Value = id; DataAngineSet.Model.hitrecord_detail model = new DataAngineSet.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); } }