/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Maticsoft.Model.album model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into album(");
strSql.Append("AlbumId,GenreId,ArtistId,Title,Price,AlbumArtUrl)");
strSql.Append(" values (");
strSql.Append("@AlbumId,@GenreId,@ArtistId,@Title,@Price,@AlbumArtUrl)");
MySqlParameter[] parameters =
{
new MySqlParameter("@AlbumId", MySqlDbType.Int32, 11),
new MySqlParameter("@GenreId", MySqlDbType.Int32, 11),
new MySqlParameter("@ArtistId", MySqlDbType.Int32, 11),
new MySqlParameter("@Title", MySqlDbType.VarChar, 160),
new MySqlParameter("@Price", MySqlDbType.Decimal, 10),
new MySqlParameter("@AlbumArtUrl", MySqlDbType.VarChar, 1024)
};
parameters[0].Value = model.AlbumId;
parameters[1].Value = model.GenreId;
parameters[2].Value = model.ArtistId;
parameters[3].Value = model.Title;
parameters[4].Value = model.Price;
parameters[5].Value = model.AlbumArtUrl;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
public ActionResult Create([Bind(Include = "AlbumId,GenreId,ArtistId,Title,Price,AlbumArtUrl")] Maticsoft.Model.album albummodel)
{
try
{
// TODO: Add insert logic here
bool bflag = albumbll.Add(albummodel);
ViewBag.ArtistList = new SelectList(artistbll.GetModelList("1=1"), "ArtistId", "Name", albummodel.ArtistId);
ViewBag.GenreList = new SelectList(genrebll.GetModelList("1=1"), "GenreId", "Name", albummodel.GenreId);
return(RedirectToAction("Index"));
}
catch (Exception e)
{
return(View(e.Message));
}
}
public ActionResult Edit([Bind(Include = "AlbumId,GenreId,ArtistId,Title,Price,AlbumArtUrl")] Maticsoft.Model.album albummodel)
{
try
{
// TODO: Add update logic here
if (ModelState.IsValid)
{
albumbll.Update(albummodel);
}
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.album DataRowToModel(DataRow row)
{
Maticsoft.Model.album model = new Maticsoft.Model.album();
if (row != null)
{
if (row["AlbumId"] != null && row["AlbumId"].ToString() != "")
{
model.AlbumId = int.Parse(row["AlbumId"].ToString());
}
if (row["GenreId"] != null && row["GenreId"].ToString() != "")
{
model.GenreId = int.Parse(row["GenreId"].ToString());
}
if (row["ArtistId"] != null && row["ArtistId"].ToString() != "")
{
model.ArtistId = int.Parse(row["ArtistId"].ToString());
}
if (row["Title"] != null)
{
model.Title = row["Title"].ToString();
}
if (row["Price"] != null && row["Price"].ToString() != "")
{
model.Price = decimal.Parse(row["Price"].ToString());
}
if (row["AlbumArtUrl"] != null)
{
model.AlbumArtUrl = row["AlbumArtUrl"].ToString();
}
if (row.Table.Columns.Contains("genrename"))
{
if (row["genrename"] != null)
{
model.genrename = row["genrename"].ToString();
}
if (row["artistname"] != null)
{
model.artistname = row["artistname"].ToString();
}
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Maticsoft.Model.album model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update album set ");
strSql.Append("GenreId=@GenreId,");
strSql.Append("ArtistId=@ArtistId,");
strSql.Append("Title=@Title,");
strSql.Append("Price=@Price,");
strSql.Append("AlbumArtUrl=@AlbumArtUrl");
strSql.Append(" where AlbumId=@AlbumId ");
MySqlParameter[] parameters =
{
new MySqlParameter("@GenreId", MySqlDbType.Int32, 11),
new MySqlParameter("@ArtistId", MySqlDbType.Int32, 11),
new MySqlParameter("@Title", MySqlDbType.VarChar, 160),
new MySqlParameter("@Price", MySqlDbType.Decimal, 10),
new MySqlParameter("@AlbumArtUrl", MySqlDbType.VarChar, 1024),
new MySqlParameter("@AlbumId", MySqlDbType.Int32, 11)
};
parameters[0].Value = model.GenreId;
parameters[1].Value = model.ArtistId;
parameters[2].Value = model.Title;
parameters[3].Value = model.Price;
parameters[4].Value = model.AlbumArtUrl;
parameters[5].Value = model.AlbumId;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.album GetModel(int AlbumId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select AlbumId,GenreId,ArtistId,Title,Price,AlbumArtUrl from album ");
strSql.Append(" where AlbumId=@AlbumId ");
MySqlParameter[] parameters =
{
new MySqlParameter("@AlbumId", MySqlDbType.Int32, 11)
};
parameters[0].Value = AlbumId;
Maticsoft.Model.album model = new Maticsoft.Model.album();
DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
