public override DbCommand CreateDbCommand(DbUpdateStatement _query)
{
DB2Command command = ((DB2Connection)DbConnection).CreateCommand();
command.CommandText = _query.ToString();
return(command);
}
public override DbCommand CreateDbCommand(DbUpdateStatement clause)
{
OracleCommand command = ((OracleConnection)DbConnection).CreateCommand();
command.CommandText = clause.ToString();
return(command);
}
public int ExecuteNonQuery(DbUpdateStatement clause)
{
int result = 0;
DbCommand _cmd = CreateDbCommand(clause);
result = _cmd.ExecuteNonQuery();
_cmd.Dispose();
return(result);
}
private DbUpdateStatement GetQuery_UpdateQuery(SaleLine _obj)
{
DbUpdateStatement clause = DbMgr.CreateUpdateClause();
clause
.UpdateColumns(GetFields(_obj))
.From("SaleLines")
.Criteria
.IsEqual("SaleLines", "SaleLineID", _obj.SaleLineID);
return(clause);
}
private DbUpdateStatement GetQuery_UpdateQuery(Currency _obj)
{
DbUpdateStatement clause = DbMgr.CreateUpdateClause();
clause
.UpdateColumns(GetFields(_obj))
.From("Currency")
.Criteria.IsEqual("Currency", "CurrencyID", _obj.CurrencyID);
return(clause);
}
public virtual DbUpdateStatement CreateUpdateClause(string table, Dictionary <string, DbFieldEntry> fields, string fieldname, string fieldvalue)
{
DbUpdateStatement clause = CreateUpdateClause();
clause
.UpdateColumns(fields)
.From(table)
.Criteria
.IsEqual(table, fieldname, fieldvalue);
return(clause);
}
public virtual DbUpdateStatement CreateUpdateClause(string table, Dictionary <string, DbFieldEntry> fields, string fieldname, int?fieldvalue)
{
if (fieldvalue == null)
{
StringBuilder sb = new StringBuilder();
foreach (string key in fields.Keys)
{
sb.AppendFormat("\r\n{0}: {1}", key, fields[key]);
}
throw new NullReferenceException(string.Format("{0} cannot be null before update:\r\n{1}", fieldname, sb.ToString()));
}
DbUpdateStatement clause = CreateUpdateClause();
clause
.UpdateColumns(fields)
.From(table)
.Criteria
.IsEqual(table, fieldname, fieldvalue);
return(clause);
}
public override DbCommand CreateDbCommand(DbUpdateStatement _query)
{
return(new OleDbCommand(_query.ToString(), (OleDbConnection)DbConnection));
}
public abstract DbCommand CreateDbCommand(DbUpdateStatement clause);
public virtual DbUpdateStatement CreateUpdateClause()
{
DbUpdateStatement clause = new DbUpdateStatement(this);
return(clause);
}
public int ExecuteNonQuery(DbUpdateStatement clause)
{
return(DbMgr.ExecuteNonQuery(clause));
}
protected DbCommand CreateDbCommand(DbUpdateStatement clause)
{
return(DbMgr.CreateDbCommand(clause));
}
