/// <summary>
/// 得到一个对象实体
/// </summary>
public MyBlogs.Model.Blogphoto DataRowToModel(DataRow row)
{
MyBlogs.Model.Blogphoto model=new MyBlogs.Model.Blogphoto();
if (row != null)
{
if(row["Id"]!=null && row["Id"].ToString()!="")
{
model.Id=int.Parse(row["Id"].ToString());
}
if(row["AuthorId"]!=null && row["AuthorId"].ToString()!="")
{
model.AuthorId=int.Parse(row["AuthorId"].ToString());
}
if(row["Album"]!=null && row["Album"].ToString()!="")
{
model.Album=int.Parse(row["Album"].ToString());
}
if(row["TItle"]!=null)
{
model.TItle=row["TItle"].ToString();
}
if(row["Remark"]!=null)
{
model.Remark=row["Remark"].ToString();
}
if(row["Src"]!=null)
{
model.Src=row["Src"].ToString();
}
if(row["Status"]!=null && row["Status"].ToString()!="")
{
model.Status=int.Parse(row["Status"].ToString());
}
if(row["AddTime"]!=null && row["AddTime"].ToString()!="")
{
model.AddTime=DateTime.Parse(row["AddTime"].ToString());
}
if(row["IsDel"]!=null && row["IsDel"].ToString()!="")
{
if((row["IsDel"].ToString()=="1")||(row["IsDel"].ToString().ToLower()=="true"))
{
model.IsDel=true;
}
else
{
model.IsDel=false;
}
}
}
return model;
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public MyBlogs.Model.Blogphoto GetModel(int Id)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select Id,AuthorId,Album,TItle,Remark,Src,Status,AddTime,IsDel from blogphoto ");
strSql.Append(" where Id=@Id ");
MySqlParameter[] parameters = {
new MySqlParameter("@Id", MySqlDbType.Int32,11) };
parameters[0].Value = Id;
MyBlogs.Model.Blogphoto model=new MyBlogs.Model.Blogphoto();
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 Update(MyBlogs.Model.Blogphoto model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update blogphoto set ");
strSql.Append("AuthorId=@AuthorId,");
strSql.Append("Album=@Album,");
strSql.Append("TItle=@TItle,");
strSql.Append("Remark=@Remark,");
strSql.Append("Src=@Src,");
strSql.Append("Status=@Status,");
strSql.Append("IsDel=@IsDel");
strSql.Append(" where Id=@Id ");
MySqlParameter[] parameters = {
new MySqlParameter("@AuthorId", MySqlDbType.Int32,11),
new MySqlParameter("@Album", MySqlDbType.Int32,11),
new MySqlParameter("@TItle", MySqlDbType.VarChar,50),
new MySqlParameter("@Remark", MySqlDbType.VarChar,255),
new MySqlParameter("@Src", MySqlDbType.VarChar,255),
new MySqlParameter("@Status", MySqlDbType.Int32,11),
new MySqlParameter("@IsDel", MySqlDbType.Bit),
new MySqlParameter("@Id", MySqlDbType.Int32,11)};
parameters[0].Value = model.AuthorId;
parameters[1].Value = model.Album;
parameters[2].Value = model.TItle;
parameters[3].Value = model.Remark;
parameters[4].Value = model.Src;
parameters[5].Value = model.Status;
parameters[6].Value = model.IsDel;
parameters[7].Value = model.Id;
int rows=DbHelperMySQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(MyBlogs.Model.Blogphoto model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into blogphoto(");
strSql.Append("Id,AuthorId,Album,TItle,Remark,Src,Status,AddTime,IsDel)");
strSql.Append(" values (");
strSql.Append("@Id,@AuthorId,@Album,@TItle,@Remark,@Src,@Status,@AddTime,@IsDel)");
MySqlParameter[] parameters = {
new MySqlParameter("@Id", MySqlDbType.Int32,11),
new MySqlParameter("@AuthorId", MySqlDbType.Int32,11),
new MySqlParameter("@Album", MySqlDbType.Int32,11),
new MySqlParameter("@TItle", MySqlDbType.VarChar,50),
new MySqlParameter("@Remark", MySqlDbType.VarChar,255),
new MySqlParameter("@Src", MySqlDbType.VarChar,255),
new MySqlParameter("@Status", MySqlDbType.Int32,11),
new MySqlParameter("@AddTime", MySqlDbType.Timestamp),
new MySqlParameter("@IsDel", MySqlDbType.Bit)};
parameters[0].Value = model.Id;
parameters[1].Value = model.AuthorId;
parameters[2].Value = model.Album;
parameters[3].Value = model.TItle;
parameters[4].Value = model.Remark;
parameters[5].Value = model.Src;
parameters[6].Value = model.Status;
parameters[7].Value = model.AddTime;
parameters[8].Value = model.IsDel;
int rows=DbHelperMySQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}