/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(News model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into news(");
strSql.Append("title,type,content,images,main_image,add_time)");
strSql.Append(" values (");
strSql.Append("?title,?type,?content,?images,?main_image,?add_time)");
MySqlParameter[] parameters = {
new MySqlParameter("?title", MySqlDbType.VarChar,50),
new MySqlParameter("?type", MySqlDbType.Enum),
new MySqlParameter("?content", MySqlDbType.Text),
new MySqlParameter("?images", MySqlDbType.Text),
new MySqlParameter("?main_image", MySqlDbType.VarChar,500),
new MySqlParameter("?add_time", MySqlDbType.DateTime)};
parameters[0].Value = model.Title;
parameters[1].Value = model.Type;
parameters[2].Value = model.Content;
parameters[3].Value = model.Images;
parameters[4].Value = model.MainImage;
parameters[5].Value = model.AddTime;
int rows=MysqlHelper.ExecuteNonQuery(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public News DataRowToModel(DataRow row)
{
News model=new News();
if (row != null)
{
foreach (DataColumn col in row.Table.Columns)
{
if (row[col] != null && row[col].ToString() != "")
{
switch (col.ColumnName)
{
case "id":
model.ID = int.Parse(row[col].ToString());
break;
case "title":
model.Title = row[col].ToString();
break;
case "type":
model.Type = row[col].ToString();
break;
case "content":
model.Content = row[col].ToString();
break;
case "images":
model.Images = row[col].ToString();
break;
case "main_image":
model.MainImage = row[col].ToString();
break;
case "add_time":
model.AddTime = DateTime.Parse(row[col].ToString());
break;
}
}
}
}
return model;
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(News model)
{
return dal.Add(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(News model)
{
return dal.Update(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(News model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update news set ");
strSql.Append("title=?title,");
strSql.Append("type=?type,");
strSql.Append("content=?content,");
strSql.Append("images=?images,");
strSql.Append("main_image=?main_image,");
strSql.Append("add_time=?add_time");
strSql.Append(" where id=?id");
MySqlParameter[] parameters = {
new MySqlParameter("?title", MySqlDbType.VarChar,50),
new MySqlParameter("?type", MySqlDbType.Enum),
new MySqlParameter("?content", MySqlDbType.Text),
new MySqlParameter("?images", MySqlDbType.Text),
new MySqlParameter("?main_image", MySqlDbType.VarChar,500),
new MySqlParameter("?add_time", MySqlDbType.DateTime),
new MySqlParameter("?id", MySqlDbType.Int32,10)};
parameters[0].Value = model.Title;
parameters[1].Value = model.Type;
parameters[2].Value = model.Content;
parameters[3].Value = model.Images;
parameters[4].Value = model.MainImage;
parameters[5].Value = model.AddTime;
parameters[6].Value = model.ID;
int rows=MysqlHelper.ExecuteNonQuery(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public News GetModel(int id)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select id,title,type,content,images,main_image,add_time from news ");
strSql.Append(" where id=?id");
MySqlParameter[] parameters = {
new MySqlParameter("?id", MySqlDbType.Int32)
};
parameters[0].Value = id;
News model=new News();
DataSet ds=MysqlHelper.ExecuteDataSet(strSql.ToString(),parameters);
if(ds.Tables[0].Rows.Count>0)
{
return DataRowToModel(ds.Tables[0].Rows[0]);
}
else
{
return null;
}
}