public override void exec_batch(string table, string sql, string fields, string where, JToken values) { //加载结构 this.m_table = this.table(table); var field_all = this.m_table.SelectToken("fields"); var field_sel = this.selFields(fields, field_all); var field_cdt = this.selFields(where, field_all); DbHelper db = new DbHelper(); var cmd = db.GetCommand(sql); this.m_pc.create(cmd, field_sel); this.m_pc.create(cmd, field_cdt); cmd.Connection.Open(); cmd.Prepare(); OracleValueSetter pvs = new OracleValueSetter(); //设置条件 foreach (var v in values) { pvs.setVal(cmd, field_sel, v); pvs.setVal(cmd, field_cdt, v); cmd.ExecuteNonQuery(); } cmd.Connection.Close(); }
public override void update_batch(string table, string fields, SqlParam[] ws, JToken values, string predicate = "and") { //加载结构 this.m_table = this.table(table); var field_all = this.m_table.SelectToken("fields"); var field_sel = this.selFields(fields, field_all); var field_cdt = this.selFields(ws, field_all); JObject o = new JObject(); string sql = string.Format("update {0} set {1} where {2}" , table , this.toSqlSeter(fields) , this.toSqlCondition(ws, predicate)); DbHelper db = new DbHelper(); var cmd = db.GetCommand(sql); this.m_pc.create(cmd, field_sel); this.m_pc.create(cmd, field_cdt); cmd.Connection.Open(); cmd.Prepare(); OracleValueSetter pvs = new OracleValueSetter(); //设置条件 foreach (var v in values) { pvs.setVal(cmd, field_sel, v); pvs.setVal(cmd, field_cdt, v); cmd.ExecuteNonQuery(); } cmd.Connection.Close(); }