//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()
{
DataAngine.BLL.hitrecord habll = new DataAngine.BLL.hitrecord();
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;
habll.Add(hit);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(DataAngine.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(" 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("@id", MySqlDbType.Int32, 11)
};
parameters[0].Value = model.face_query_image_path;
parameters[1].Value = model.threshold;
parameters[2].Value = model.occur_time;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
//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(" where id=:id");
//OracleParameter[] parameters = {
// new OracleParameter(":face_query_image_path", OracleType.VarChar,200),
// new OracleParameter(":threshold", OracleType.Float),
// new OracleParameter(":occur_time", OracleType.DateTime),
// new OracleParameter(":id", OracleType.Int32)};
//parameters[0].Value = model.face_query_image_path;
//parameters[1].Value = model.threshold;
//parameters[2].Value = model.occur_time;
//parameters[3].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 model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into hitrecord(");
strSql.Append("face_query_image_path,threshold,occur_time)");
strSql.Append(" values (");
strSql.Append("@face_query_image_path,@threshold,@occur_time)");
MySqlParameter[] parameters =
{
new MySqlParameter("@face_query_image_path", MySqlDbType.VarChar, 200),
new MySqlParameter("@threshold", MySqlDbType.Float),
new MySqlParameter("@occur_time", MySqlDbType.DateTime)
};
parameters[0].Value = model.face_query_image_path;
parameters[1].Value = model.threshold;
parameters[2].Value = model.occur_time;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
//strSql.Append("insert into TH_FACE_HITRECORD(");
//strSql.Append("face_query_image_path,threshold,occur_time)");
//strSql.Append(" values (");
//strSql.Append(":face_query_image_path,:threshold,:occur_time)");
//OracleParameter[] parameters = {
// new OracleParameter(":face_query_image_path",OracleType.VarChar,200),
// new OracleParameter(":threshold", OracleType.Float),
// new OracleParameter(":occur_time", OracleType.DateTime)};
//parameters[0].Value = model.face_query_image_path;
//parameters[1].Value = model.threshold;
//parameters[2].Value = model.occur_time;
//int rows = DbHelperOracle.ExecuteNonQuery(CommandType.Text,strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public DataAngine.Model.hitrecord GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select id,face_query_image_path,threshold,occur_time from hitrecord ");
strSql.Append(" where id=@id");
MySqlParameter[] parameters =
{
new MySqlParameter("@id", MySqlDbType.Int32)
};
parameters[0].Value = id;
DataAngine.Model.hitrecord model = new DataAngine.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);
}
//strSql.Append("select id,face_query_image_path,threshold,occur_time from hitrecord ");
//strSql.Append(" where id=:id");
//OracleParameter[] parameters = {
// new OracleParameter(":id", OracleType.Int32)
//};
//parameters[0].Value = id;
//DataAngine.Model.hitrecord model = new DataAngine.Model.hitrecord();
//DataSet ds = DbHelperOracle.ExecuteDataSet(CommandType.Text, strSql.ToString(), parameters);
//if (ds.Tables[0].Rows.Count > 0)
//{
// return DataRowToModel(ds.Tables[0].Rows[0]);
//}
//else
//{
// return null;
//}
}
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);
}
/// <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;
DataAngine.Model.hitrecord model = new DataAngine.Model.hitrecord();
DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters);
return(ds);
}
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>
public DataAngine.Model.hitrecord DataRowToModel(DataRow row)
{
DataAngine.Model.hitrecord model = new DataAngine.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 = float.Parse(row["threshold"].ToString());
}
if (row["occur_time"] != null && row["occur_time"].ToString() != "")
{
model.occur_time = DateTime.Parse(row["occur_time"].ToString());
}
}
return(model);
}
