/// <summary>更新一条数据
///
/// </summary>
public bool Update(Niunan.Blog.Model.Casevideo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update `casevideo` set ");
strSql.Append("createdate=@createdate, img=@img, url=@url, body=@body, title=@title, showdefault=@showdefault, visitnum=@visitnum, price=@price, keyword=@keyword, descn=@descn, remark=@remark, xsnum=@xsnum, sort=@sort ");
strSql.Append(" where id=@id ");
using (var connection = ConnectionFactory.GetOpenConnection(ConnStr))
{
int i = connection.Execute(strSql.ToString(), model);
return(i > 0);
}
}
/// <summary>得到一个对象实体
///
/// </summary>
public Niunan.Blog.Model.Casevideo GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select * from `casevideo` ");
strSql.Append(" where id=@id ");
Niunan.Blog.Model.Casevideo model = null;
using (var connection = ConnectionFactory.GetOpenConnection(ConnStr))
{
model = connection.QuerySingleOrDefault <Niunan.Blog.Model.Casevideo>(strSql.ToString(), new { id = id });
}
return(model);
}
/// <summary>增加一条数据
///
/// </summary>
public int Add(Niunan.Blog.Model.Casevideo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into `casevideo`(");
strSql.Append("createdate, img, url, body, title, showdefault, visitnum, price, keyword, descn, remark, xsnum, sort )");
strSql.Append(" values (");
strSql.Append("@createdate, @img, @url, @body, @title, @showdefault, @visitnum, @price, @keyword, @descn, @remark, @xsnum, @sort )");
strSql.Append(";select @@IDENTITY");
using (var connection = ConnectionFactory.GetOpenConnection(ConnStr))
{
int i = connection.QuerySingle <int>(strSql.ToString(), model);
return(i);
}
}
/// <summary>根据条件得到一个对象实体
///
/// </summary>
public Niunan.Blog.Model.Casevideo GetModelByCond(string cond)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select * from `casevideo` ");
if (!string.IsNullOrEmpty(cond))
{
strSql.Append(" where " + cond);
}
strSql.Append(" limit 1;");
Niunan.Blog.Model.Casevideo model = null;
using (var connection = ConnectionFactory.GetOpenConnection(ConnStr))
{
model = connection.QuerySingleOrDefault <Niunan.Blog.Model.Casevideo>(strSql.ToString());
}
return(model);
}