/// <summary> /// 添加一条数据 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool Add(DataAngine.Model.hitalert model) { if (!hitrecorddal.Add(model.hit)) { return(false); } int hit_record_id = hitrecorddal.GetMaxId() - 1; bool addState = true; for (int n = 0; n < model.details.Length; n++) { model.details[n].hit_record_id = hit_record_id; model.details[n].rank = n; addState = hitrecord_detaildal.Add(model.details[n]); if (false == addState) { break; } } return(addState); /* * int rows = 0; * * StringBuilder strSql = new StringBuilder(); * 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)}; * * for (int n = 0; n < model.details.Length; n++) * { * parameters[0].Value = hit_record_id; * parameters[1].Value = model.details[n].user_id; * parameters[2].Value = n; * parameters[3].Value = model.details[n].score; * * rows += DbHelperOracle.ExecuteNonQuery(CommandType.Text, strSql.ToString(), parameters); * } * * if (rows > 0) * { * return true; * } * else * { * return false; * } */ }
public bool Update(DataAngine.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 <DataAngine.Model.hitrecord_detail> hitDetails = hitrecord_detaildal.GetModelByHitUserId(model.details[n].user_id); foreach (DataAngine.Model.hitrecord_detail hitDetail in hitDetails) { DataAngine.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); }
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> /// 更新一条数据 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool Update(DataAngine.Model.hitalert model) { return(dal.Update(model)); }
/// <summary> /// 添加一条数据 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool Add(DataAngine.Model.hitalert model) { return(dal.Add(model)); }