/// <summary> /// 更新一条数据 /// </summary> public void Update(DdTksqjlbModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update dd_tksqjlb set "); strSql.Append("ddbh=@ddbh,"); strSql.Append("jylsbh=@jylsbh,"); strSql.Append("tkje=@tkje,"); strSql.Append("sqtksj=@sqtksj,"); strSql.Append("tksj=@tksj,"); strSql.Append("zffs=@zffs,"); strSql.Append("tklsh=@tklsh,"); strSql.Append("trade_no=@trade_no,"); strSql.Append("refund_no=@refund_no,"); strSql.Append("tkyy=@tkyy,"); strSql.Append("tkzt=@tkzt,"); strSql.Append("yybh=@yybh,"); strSql.Append("dwbh=@dwbh,"); strSql.Append("ddje=@ddje"); strSql.Append(" where id=@id"); using (IDbConnection conn = new DapperConnection().DbConnection) { conn.Execute(strSql.ToString(), model); } }
/// <summary> /// 增加一条数据 /// </summary> public void Add(DdTksqjlbModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into dd_tksqjlb("); strSql.Append("ddbh,jylsbh,tkje,sqtksj,tksj,zffs,tklsh,trade_no,refund_no,tkyy,tkzt,yybh,dwbh,ddje)"); strSql.Append(" values ("); strSql.Append("@ddbh,@jylsbh,@tkje,@sqtksj,@tksj,@zffs,@tklsh,@trade_no,@refund_no,@tkyy,@tkzt,@yybh,@dwbh,@ddje)"); using (IDbConnection conn = new DapperConnection().DbConnection) { conn.Execute(strSql.ToString(), model); } }