/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(TwitterSpamDetection.Model.t_ind_trainingtime model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update t_ind_trainingtime set ");
strSql.Append("Algorithm=@Algorithm,");
strSql.Append("TrainingTimeOne=@TrainingTimeOne,");
strSql.Append("TrainingTimeTwo=@TrainingTimeTwo,");
strSql.Append("TrainingTimeThree=@TrainingTimeThree,");
strSql.Append("TrainingTimeFour=@TrainingTimeFour,");
strSql.Append("TrainingTimeFive=@TrainingTimeFive");
strSql.Append(" where ID=@ID ");
MySqlParameter[] parameters =
{
new MySqlParameter("@Algorithm", MySqlDbType.VarChar, 100),
new MySqlParameter("@TrainingTimeOne", MySqlDbType.VarChar, 45),
new MySqlParameter("@TrainingTimeTwo", MySqlDbType.VarChar, 45),
new MySqlParameter("@TrainingTimeThree", MySqlDbType.VarChar, 45),
new MySqlParameter("@TrainingTimeFour", MySqlDbType.VarChar, 45),
new MySqlParameter("@TrainingTimeFive", MySqlDbType.VarChar, 45),
new MySqlParameter("@ID", MySqlDbType.VarChar, 36)
};
parameters[0].Value = model.Algorithm;
parameters[1].Value = model.TrainingTimeOne;
parameters[2].Value = model.TrainingTimeTwo;
parameters[3].Value = model.TrainingTimeThree;
parameters[4].Value = model.TrainingTimeFour;
parameters[5].Value = model.TrainingTimeFive;
parameters[6].Value = model.ID;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(TwitterSpamDetection.Model.t_ind_trainingtime model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into t_ind_trainingtime(");
strSql.Append("ID,Algorithm,TrainingTimeOne,TrainingTimeTwo,TrainingTimeThree,TrainingTimeFour,TrainingTimeFive)");
strSql.Append(" values (");
strSql.Append("@ID,@Algorithm,@TrainingTimeOne,@TrainingTimeTwo,@TrainingTimeThree,@TrainingTimeFour,@TrainingTimeFive)");
MySqlParameter[] parameters =
{
new MySqlParameter("@ID", MySqlDbType.VarChar, 36),
new MySqlParameter("@Algorithm", MySqlDbType.VarChar, 100),
new MySqlParameter("@TrainingTimeOne", MySqlDbType.VarChar, 45),
new MySqlParameter("@TrainingTimeTwo", MySqlDbType.VarChar, 45),
new MySqlParameter("@TrainingTimeThree", MySqlDbType.VarChar, 45),
new MySqlParameter("@TrainingTimeFour", MySqlDbType.VarChar, 45),
new MySqlParameter("@TrainingTimeFive", MySqlDbType.VarChar, 45)
};
parameters[0].Value = model.ID;
parameters[1].Value = model.Algorithm;
parameters[2].Value = model.TrainingTimeOne;
parameters[3].Value = model.TrainingTimeTwo;
parameters[4].Value = model.TrainingTimeThree;
parameters[5].Value = model.TrainingTimeFour;
parameters[6].Value = model.TrainingTimeFive;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public TwitterSpamDetection.Model.t_ind_trainingtime DataRowToModel(DataRow row)
{
TwitterSpamDetection.Model.t_ind_trainingtime model = new TwitterSpamDetection.Model.t_ind_trainingtime();
if (row != null)
{
if (row["ID"] != null)
{
model.ID = row["ID"].ToString();
}
if (row["Algorithm"] != null)
{
model.Algorithm = row["Algorithm"].ToString();
}
if (row["TrainingTimeOne"] != null)
{
model.TrainingTimeOne = row["TrainingTimeOne"].ToString();
}
if (row["TrainingTimeTwo"] != null)
{
model.TrainingTimeTwo = row["TrainingTimeTwo"].ToString();
}
if (row["TrainingTimeThree"] != null)
{
model.TrainingTimeThree = row["TrainingTimeThree"].ToString();
}
if (row["TrainingTimeFour"] != null)
{
model.TrainingTimeFour = row["TrainingTimeFour"].ToString();
}
if (row["TrainingTimeFive"] != null)
{
model.TrainingTimeFive = row["TrainingTimeFive"].ToString();
}
}
return(model);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public TwitterSpamDetection.Model.t_ind_trainingtime GetModel(string ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ID,Algorithm,TrainingTimeOne,TrainingTimeTwo,TrainingTimeThree,TrainingTimeFour,TrainingTimeFive from t_ind_trainingtime ");
strSql.Append(" where ID=@ID ");
MySqlParameter[] parameters =
{
new MySqlParameter("@ID", MySqlDbType.VarChar, 36)
};
parameters[0].Value = ID;
TwitterSpamDetection.Model.t_ind_trainingtime model = new TwitterSpamDetection.Model.t_ind_trainingtime();
DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
