/// <summary>更新一条数据
///
/// </summary>
public bool Update(Niunan.CaiPiao.Model.Wanfa model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update wanfa set ");
strSql.Append("createtime=@createtime, wfname=@wfname, remark=@remark, czid=@czid, basemoney=@basemoney, groupname=@groupname, peilv=@peilv, isshow=@isshow, shortname=@shortname, sort=@sort, bigname=@bigname, tesu=@tesu, tesu_peilv=@tesu_peilv, tesu_je=@tesu_je ");
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.CaiPiao.Model.Wanfa GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select * from wanfa ");
strSql.Append(" where id=@id ");
Niunan.CaiPiao.Model.Wanfa model = null;
using (var connection = ConnectionFactory.GetOpenConnection(ConnStr))
{
model = connection.QuerySingleOrDefault <Niunan.CaiPiao.Model.Wanfa>(strSql.ToString(), new { id = id });
}
return(model);
}
/// <summary>增加一条数据
///
/// </summary>
public int Add(Niunan.CaiPiao.Model.Wanfa model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into wanfa(");
strSql.Append("createtime, wfname, remark, czid, basemoney, groupname, peilv, isshow, shortname, sort, bigname, tesu, tesu_peilv, tesu_je )");
strSql.Append(" values (");
strSql.Append("@createtime, @wfname, @remark, @czid, @basemoney, @groupname, @peilv, @isshow, @shortname, @sort, @bigname, @tesu, @tesu_peilv, @tesu_je ) returning id;");
using (var connection = ConnectionFactory.GetOpenConnection(ConnStr))
{
int i = connection.QueryFirst <int>(strSql.ToString(), model);
return(i);
}
}
/// <summary>根据条件得到一个对象实体
///
/// </summary>
public Niunan.CaiPiao.Model.Wanfa GetModelByCond(string cond)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select * from wanfa ");
if (!string.IsNullOrEmpty(cond))
{
strSql.Append(" where " + cond);
}
strSql.Append(" limit 1");
Niunan.CaiPiao.Model.Wanfa model = null;
using (var connection = ConnectionFactory.GetOpenConnection(ConnStr))
{
model = connection.QuerySingleOrDefault <Niunan.CaiPiao.Model.Wanfa>(strSql.ToString());
}
return(model);
}
