public void Add(TjFzModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tj_fz(");
strSql.Append("mc,yybh,sfqy,jsmds,tjkssj,tjjssj,cjsj,jstc,dwbh)");
strSql.Append(" values (");
strSql.Append("@mc,@yybh,@sfqy,@jsmds,@tjkssj,@tjjssj,@cjsj,@jstc,@dwbh)");
using (IDbConnection conn = new DapperConnection().DbConnection)
{
conn.Execute(strSql.ToString(), model);
}
}
public void Update(TjFzModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tj_fz set ");
strSql.Append("mc=@mc,");
strSql.Append("yybh=@yybh,");
strSql.Append("sfqy=@sfqy,");
strSql.Append("jsmds=@jsmds,");
strSql.Append("jstc=@jstc,");
strSql.Append("dwbh=@dwbh,");
strSql.Append("tjkssj=@tjkssj,");
strSql.Append("tjjssj=@tjjssj");
strSql.Append(" where id=@id");
using (IDbConnection conn = new DapperConnection().DbConnection)
{
conn.Execute(strSql.ToString(), model);
}
}
