/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Bookhole_blog.Model.tell model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tell set ");
strSql.Append("Tell_blogid=@Tell_blogid,");
strSql.Append("Tell_userid=@Tell_userid,");
strSql.Append("Tell_text=@Tell_text,");
strSql.Append("Tell_time=@Tell_time");
strSql.Append(" where Tell_id=@Tell_id ");
MySqlParameter[] parameters =
{
new MySqlParameter("@Tell_blogid", MySqlDbType.Int32, 11),
new MySqlParameter("@Tell_userid", MySqlDbType.Double, 11),
new MySqlParameter("@Tell_text", MySqlDbType.VarChar, 255),
new MySqlParameter("@Tell_time", MySqlDbType.VarChar, 255),
new MySqlParameter("@Tell_id", MySqlDbType.Int32, 11)
};
parameters[0].Value = model.Tell_blogid;
parameters[1].Value = model.Tell_userid;
parameters[2].Value = model.Tell_text;
parameters[3].Value = model.Tell_time;
parameters[4].Value = model.Tell_id;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Bookhole_blog.Model.tell DataRowToModel(DataRow row)
{
Bookhole_blog.Model.tell model = new Bookhole_blog.Model.tell();
if (row != null)
{
if (row["Tell_blogid"] != null && row["Tell_blogid"].ToString() != "")
{
model.Tell_blogid = int.Parse(row["Tell_blogid"].ToString());
}
if (row["Tell_userid"] != null)
{
model.Tell_userid = double.Parse(row["Tell_userid"].ToString());
}
if (row["Tell_text"] != null)
{
model.Tell_text = row["Tell_text"].ToString();
}
if (row["Tell_time"] != null)
{
model.Tell_time = row["Tell_time"].ToString();
}
if (row["Tell_id"] != null && row["Tell_id"].ToString() != "")
{
model.Tell_id = int.Parse(row["Tell_id"].ToString());
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Bookhole_blog.Model.tell model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tell(");
strSql.Append("Tell_blogid,Tell_userid,Tell_text,Tell_time,Tell_id)");
strSql.Append(" values (");
strSql.Append("@Tell_blogid,@Tell_userid,@Tell_text,@Tell_time,@Tell_id)");
MySqlParameter[] parameters =
{
new MySqlParameter("@Tell_blogid", MySqlDbType.Int32, 11),
new MySqlParameter("@Tell_userid", MySqlDbType.Int32, 11),
new MySqlParameter("@Tell_text", MySqlDbType.VarChar, 255),
new MySqlParameter("@Tell_time", MySqlDbType.VarChar, 255),
new MySqlParameter("@Tell_id", MySqlDbType.Int32, 11)
};
parameters[0].Value = model.Tell_blogid;
parameters[1].Value = model.Tell_userid;
parameters[2].Value = model.Tell_text;
parameters[3].Value = model.Tell_time;
parameters[4].Value = model.Tell_id;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Bookhole_blog.Model.tell GetModel(int Tell_id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select Tell_blogid,Tell_userid,Tell_text,Tell_time,Tell_id from tell ");
strSql.Append(" where Tell_id=@Tell_id ");
MySqlParameter[] parameters =
{
new MySqlParameter("@Tell_id", MySqlDbType.Int32, 11)
};
parameters[0].Value = Tell_id;
Bookhole_blog.Model.tell model = new Bookhole_blog.Model.tell();
DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
