/// <summary> /// 增加一条数据 /// </summary> public bool Add(DataAngineSet.Model.hitrecord model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into hitrecord("); strSql.Append("face_query_image_path,threshold,occur_time,task_id,remark)"); strSql.Append(" values ("); strSql.Append("@face_query_image_path,@threshold,@occur_time,@task_id,@remark)"); MySqlParameter[] parameters = { new MySqlParameter("@face_query_image_path", MySqlDbType.VarChar, 200), new MySqlParameter("@threshold", MySqlDbType.Float), new MySqlParameter("@occur_time", MySqlDbType.DateTime), new MySqlParameter("@task_id", MySqlDbType.Int32, 11), new MySqlParameter("@remark", MySqlDbType.VarChar, 50) }; parameters[0].Value = model.face_query_image_path; parameters[1].Value = model.threshold; parameters[2].Value = model.occur_time; parameters[3].Value = model.task_id; 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 DataRowToModel(DataRow row) { DataAngineSet.Model.hitrecord model = new DataAngineSet.Model.hitrecord(); if (row != null) { if (row["id"] != null && row["id"].ToString() != "") { model.id = int.Parse(row["id"].ToString()); } if (row["face_query_image_path"] != null) { model.face_query_image_path = row["face_query_image_path"].ToString(); } if (row["threshold"] != null && row["threshold"].ToString() != "") { model.threshold = decimal.Parse(row["threshold"].ToString()); } if (row["occur_time"] != null && row["occur_time"].ToString() != "") { model.occur_time = DateTime.Parse(row["occur_time"].ToString()); } if (row["task_id"] != null && row["task_id"].ToString() != "") { model.task_id = int.Parse(row["task_id"].ToString()); } if (row["remark"] != null) { model.remark = row["remark"].ToString(); } } return(model); }
//static void libraryAddTest() //{ // DataAngine.BLL.table tablebll = new DataAngine.BLL.table(); // DataAngine.Model.table table = new DataAngine.Model.table(); // table.name = "test"; // tablebll.Add(table); //} static void hitrecordAddTest() { DataAngineSet.BLL.hitrecord habll = new DataAngineSet.BLL.hitrecord(); 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; habll.Add(hit); }
public bool Update(DataAngineSet.Model.hitalert model) { DateTime dateNow = DateTime.Now; DateTime dateStart = new DateTime(dateNow.Year, dateNow.Month, dateNow.Day, 6, 0, 0); DateTime dateEnd = new DateTime(dateNow.Year, dateNow.Month, dateNow.Day, 24, 0, 0); bool addState = true; for (int n = 0; n < model.details.Length; n++) { List <DataAngineSet.Model.hitrecord_detail> hitDetails = hitrecord_detaildal.GetModelByHitUserId(model.details[n].user_id); foreach (DataAngineSet.Model.hitrecord_detail hitDetail in hitDetails) { DataAngineSet.Model.hitrecord hitRecord = hitrecorddal.GetModel(hitDetail.hit_record_id); DateTime occureTime = hitRecord.occur_time; if (occureTime.CompareTo(dateStart) >= 0 && occureTime.CompareTo(dateEnd) <= 0) { hitDetail.rank = model.details[n].rank; hitDetail.score = model.details[n].score; hitrecord_detaildal.Update(hitDetail); addState = true; } } if (false == addState) { break; } } if (addState) { } return(addState); }
/// <summary> /// 通过时间得到对象实体 /// </summary> /// //public List<DataAngine.Model.hitalert> GetModelByTime(DateTime startTime, DateTime endTime) //{ // List<DataAngine.Model.hitalert> modelList = new List<Model.hitalert>(); // StringBuilder strSql = new StringBuilder(); // strSql.Append("select id,face_query_image_path,threshold,occur_time,detail_id,rank,score,user_id,user_name,user_gender,user_face_image_path,user_type,user_create_time,user_modified_time,user_quality_score "); // strSql.Append(" FROM hitalert "); // strSql.Append(" where occur_time between @start_ime and @end_time"); // MySqlParameter[] parameters = { // new MySqlParameter("@start_ime", MySqlDbType.DateTime), // new MySqlParameter("@end_time", MySqlDbType.DateTime) // }; // parameters[0].Value = startTime; // parameters[1].Value = endTime; // DataAngine.Model.hitrecord model = new DataAngine.Model.hitrecord(); // DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters); // DataTable dt = ds.Tables[0]; // List<DataTable> newTables = new List<DataTable>(); // HashSet<int> groupIds = new HashSet<int>(); // foreach (DataRow row in dt.Rows) // { // int groupId = int.Parse(row["id"].ToString()); // if (!groupIds.Contains(groupId)) // { // groupIds.Add(groupId); // DataTable newTable = dt.Clone(); // newTable.TableName = groupId.ToString(); // newTable.ImportRow(row); // newTables.Add(newTable); // } // else // { // DataTable newTable = newTables.Find(x => x.TableName == groupId.ToString()); // newTable.ImportRow(row); // } // } // foreach (var table in newTables) // { // modelList.Add(DataTableToModel(table)); // } // return modelList; //} public DataSet GetModelByTime(DateTime startTime, DateTime endTime) { StringBuilder strSql = new StringBuilder(); strSql.Append("select id,face_query_image_path,threshold,occur_time,detail_id,rank,score,user_id,user_name,user_gender,user_face_image_path,user_type,user_create_time,user_modified_time,user_quality_score "); strSql.Append(" FROM hitalert "); strSql.Append(" where occur_time between @start_ime and @end_time"); MySqlParameter[] parameters = { new MySqlParameter("@start_ime", MySqlDbType.DateTime), new MySqlParameter("@end_time", MySqlDbType.DateTime) }; parameters[0].Value = startTime; parameters[1].Value = endTime; DataAngineSet.Model.hitrecord model = new DataAngineSet.Model.hitrecord(); DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters); return(ds); }
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> /// 更新一条数据 /// </summary> public bool Update(DataAngineSet.Model.hitrecord model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update hitrecord set "); strSql.Append("face_query_image_path=@face_query_image_path,"); strSql.Append("threshold=@threshold,"); strSql.Append("occur_time=@occur_time,"); strSql.Append("task_id=@task_id,"); strSql.Append("remark=@remark"); strSql.Append(" where id=@id"); MySqlParameter[] parameters = { new MySqlParameter("@face_query_image_path", MySqlDbType.VarChar, 200), new MySqlParameter("@threshold", MySqlDbType.Float), new MySqlParameter("@occur_time", MySqlDbType.DateTime), new MySqlParameter("@task_id", MySqlDbType.Int32, 11), new MySqlParameter("@remark", MySqlDbType.VarChar, 50), new MySqlParameter("@id", MySqlDbType.Int32, 11) }; parameters[0].Value = model.face_query_image_path; parameters[1].Value = model.threshold; parameters[2].Value = model.occur_time; parameters[3].Value = model.task_id; 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 GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select id,face_query_image_path,threshold,occur_time,task_id,remark from hitrecord "); strSql.Append(" where id=@id"); MySqlParameter[] parameters = { new MySqlParameter("@id", MySqlDbType.Int32) }; parameters[0].Value = id; DataAngineSet.Model.hitrecord model = new DataAngineSet.Model.hitrecord(); DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }