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