/// <summary>
/// 得到一个对象实体
/// </summary>
public DataAngine.Model.user DataRowToModel(DataRow row)
{
DataAngine.Model.user model = new DataAngine.Model.user();
if (row != null)
{
if (row["id"] != null && row["id"].ToString() != "")
{
model.id = int.Parse(row["id"].ToString());
}
if (row["people_id"] != null)
{
model.people_id = row["people_id"].ToString();
}
if (row["name"] != null)
{
model.name = row["name"].ToString();
}
if (row["gender"] != null)
{
model.gender = row["gender"].ToString();
}
if (row["card_id"] != null)
{
model.card_id = row["card_id"].ToString();
}
if (row["image_id"] != null)
{
model.image_id = row["image_id"].ToString();
}
if (row["face_image_path"] != null)
{
model.face_image_path = row["face_image_path"].ToString();
}
//model.feature_data=row["feature_data"].ToString();
if (row["type"] != null)
{
model.type = row["type"].ToString();
}
if (row["create_time"] != null && row["create_time"].ToString() != "")
{
model.create_time = DateTime.Parse(row["create_time"].ToString());
}
if (row["modified_time"] != null && row["modified_time"].ToString() != "")
{
model.modified_time = DateTime.Parse(row["modified_time"].ToString());
}
if (row["quality_score"] != null && row["quality_score"].ToString() != "")
{
model.quality_score = float.Parse(row["quality_score"].ToString());
}
if (row["feature_data"] != null && row["feature_data"] != System.DBNull.Value)
{
model.feature_data = (byte[])row["feature_data"];
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(DataAngine.Model.user model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update user set ");
strSql.Append("people_id=@people_id,");
strSql.Append("name=@name,");
strSql.Append("gender=@gender,");
strSql.Append("card_id=@card_id,");
strSql.Append("image_id=@image_id,");
strSql.Append("face_image_path=@face_image_path,");
strSql.Append("feature_data=@feature_data,");
strSql.Append("type=@type,");
strSql.Append("create_time=@create_time,");
strSql.Append("modified_time=@modified_time,");
strSql.Append("quality_score=@quality_score");
strSql.Append(" where id=@id");
MySqlParameter[] parameters =
{
new MySqlParameter("@people_id", MySqlDbType.VarChar, 50),
new MySqlParameter("@name", MySqlDbType.VarChar, 50),
new MySqlParameter("@gender", MySqlDbType.VarChar, 5),
new MySqlParameter("@card_id", MySqlDbType.VarChar, 50),
new MySqlParameter("@image_id", MySqlDbType.VarChar, 60),
new MySqlParameter("@face_image_path", MySqlDbType.VarChar, 200),
new MySqlParameter("@feature_data", MySqlDbType.LongBlob),
new MySqlParameter("@type", MySqlDbType.VarChar, 1),
new MySqlParameter("@create_time", MySqlDbType.DateTime),
new MySqlParameter("@modified_time", MySqlDbType.DateTime),
new MySqlParameter("@quality_score", MySqlDbType.Float)
};
parameters[0].Value = model.people_id;
parameters[1].Value = model.name;
parameters[2].Value = model.gender;
parameters[3].Value = model.card_id;
parameters[4].Value = model.image_id;
parameters[5].Value = model.face_image_path;
parameters[6].Value = model.feature_data;
parameters[7].Value = model.type;
parameters[8].Value = model.create_time;
parameters[9].Value = model.modified_time;
parameters[10].Value = model.quality_score;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
static void userAddTest()
{
DataAngine.BLL.user usrbll = new DataAngine.BLL.user();
DataAngine.Model.user usr = new DataAngine.Model.user();
usr.card_id = "32145123451";
usr.face_image_path = "E:/11i.jpg";
usr.feature_data = new byte[2048];
usr.gender = "nan";
usr.people_id = "1";
usr.type = "2";
usr.quality_score = 1.2f;
usrbll.Add(usr);
}
public bool Add(DataAngine.Model.user model, string library)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into user(");
strSql.Append("people_id,name,gender,card_id,image_id,face_image_path,feature_data,type,create_time,modified_time,quality_score)");
strSql.Append(" values (");
strSql.Append("@people_id,@name,@gender,@card_id,@image_id,@face_image_path,@feature_data,@type,@create_time,@modified_time,@quality_score)");
MySqlParameter[] parameters =
{
new MySqlParameter("@people_id", MySqlDbType.VarChar, 50),
new MySqlParameter("@name", MySqlDbType.VarChar, 50),
new MySqlParameter("@gender", MySqlDbType.VarChar, 5),
new MySqlParameter("@card_id", MySqlDbType.VarChar, 50),
new MySqlParameter("@image_id", MySqlDbType.VarChar, 60),
new MySqlParameter("@face_image_path", MySqlDbType.VarChar, 200),
new MySqlParameter("@feature_data", MySqlDbType.LongBlob),
new MySqlParameter("@type", MySqlDbType.VarChar, 1),
new MySqlParameter("@create_time", MySqlDbType.DateTime),
new MySqlParameter("@modified_time", MySqlDbType.DateTime),
new MySqlParameter("@quality_score", MySqlDbType.Float)
};
parameters[0].Value = model.people_id;
parameters[1].Value = model.name;
parameters[2].Value = model.gender;
parameters[3].Value = model.card_id;
parameters[4].Value = model.image_id;
parameters[5].Value = model.face_image_path;
parameters[6].Value = model.feature_data;
parameters[7].Value = model.type;
parameters[8].Value = model.create_time;
parameters[9].Value = model.modified_time;
parameters[10].Value = model.quality_score;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), library, parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public DataAngine.Model.user GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select id,people_id,name,gender,card_id,image_id,face_image_path,feature_data,type,create_time,modified_time,quality_score from user ");
strSql.Append(" where id=@id");
MySqlParameter[] parameters =
{
new MySqlParameter("@id", MySqlDbType.Int32)
};
parameters[0].Value = id;
DataAngine.Model.user model = new DataAngine.Model.user();
DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(DataAngine.Model.user model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into user(");
strSql.Append("people_id,name,gender,card_id,image_id,face_image_path,feature_data,type,create_time,modified_time,quality_score)");
strSql.Append(" values (");
strSql.Append("@people_id,@name,@gender,@card_id,@image_id,@face_image_path,@feature_data,@type,@create_time,@modified_time,@quality_score)");
MySqlParameter[] parameters =
{
new MySqlParameter("@people_id", MySqlDbType.VarChar, 50),
new MySqlParameter("@name", MySqlDbType.VarChar, 50),
new MySqlParameter("@gender", MySqlDbType.VarChar, 5),
new MySqlParameter("@card_id", MySqlDbType.VarChar, 50),
new MySqlParameter("@image_id", MySqlDbType.VarChar, 60),
new MySqlParameter("@face_image_path", MySqlDbType.VarChar, 200),
new MySqlParameter("@feature_data", MySqlDbType.LongBlob),
new MySqlParameter("@type", MySqlDbType.VarChar, 1),
new MySqlParameter("@create_time", MySqlDbType.DateTime),
new MySqlParameter("@modified_time", MySqlDbType.DateTime),
new MySqlParameter("@quality_score", MySqlDbType.Float)
};
parameters[0].Value = model.people_id;
parameters[1].Value = model.name;
parameters[2].Value = model.gender;
parameters[3].Value = model.card_id;
parameters[4].Value = model.image_id;
parameters[5].Value = model.face_image_path;
parameters[6].Value = model.feature_data;
parameters[7].Value = model.type;
parameters[8].Value = model.create_time;
parameters[9].Value = model.modified_time;
parameters[10].Value = model.quality_score;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
/*
* strSql.Append("insert into TH_FACE_USER(");
* strSql.Append("name,gender,id_card,face_image_path,feature_data,type,create_time,modified_time,quality_score)");
* strSql.Append(" values (");
* strSql.Append(":name,:gender,:id_card,:face_image_path,:feature_data,:type,:create_time,:modified_time,:quality_score)");
* OracleParameter[] parameters = {
* new OracleParameter(":name", OracleType.VarChar,50),
* new OracleParameter(":gender", OracleType.VarChar,5),
* new OracleParameter(":id_card", OracleType.VarChar, 50),
* new OracleParameter(":face_image_path", OracleType.VarChar,200),
* new OracleParameter(":feature_data", OracleType.Blob),
* new OracleParameter(":type", OracleType.VarChar,5),
* new OracleParameter(":create_time", OracleType.DateTime),
* new OracleParameter(":modified_time", OracleType.DateTime),
* new OracleParameter(":quality_score", OracleType.Float)};
*
* parameters[0].Value = model.name;
* parameters[1].Value = model.gender;
* parameters[2].Value = model.idCard;
* parameters[3].Value = model.face_image_path ;
* parameters[4].Value = model.feature_data;
* parameters[5].Value = model.type;
* parameters[6].Value = model.create_time;
* parameters[7].Value = model.modified_time;
* parameters[8].Value = model.quality_score;
*
* int rows = DbHelperOracle.ExecuteNonQuery(CommandType.Text,strSql.ToString(), parameters);
*/
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
