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); } }