| public ConvertToNamedParameters ( int indexToStart, object values ) : Sharp.Data.In[] | ||
| indexToStart | int | |
| values | object | |
| return | Sharp.Data.In[] | |
public virtual int InsertSql(string table, string[] columns, object[] values)
{
if (values == null)
{
values = new object[columns.Length];
}
string sql = Dialect.GetInsertSql(table, columns, values);
return(Database.ExecuteSql(sql, Dialect.ConvertToNamedParameters(values)));
}
public virtual int DeleteSql(string table, Filter filter)
{
string sql = Dialect.GetDeleteSql(table);
if (filter != null)
{
string whereSql = Dialect.GetWhereSql(filter, 0);
object[] pars = filter.GetAllValueParameters();
In[] parameters = Dialect.ConvertToNamedParameters(0, pars);
return(Database.ExecuteSql(sql + " " + whereSql, parameters));
}
return(Database.ExecuteSql(sql));
}
public virtual object InsertReturningSql(string table, string columnToReturn, string[] columns, object[] values)
{
var returningPar = new Out {
Name = "returning_" + columnToReturn, Size = 4000
};
string retSql = Dialect.GetInsertReturningColumnSql(table, columns, values, columnToReturn, returningPar.Name);
object[] pars = Dialect.ConvertToNamedParameters(values);
List <object> listPars = pars.ToList();
listPars.Add(returningPar);
Database.ExecuteSql(retSql, listPars.ToArray());
return(returningPar.Value);
}
public virtual int CountSql(string table, Filter filter)
{
string sql = Dialect.GetCountSql(table);
object obj;
if (filter != null)
{
string whereSql = Dialect.GetWhereSql(filter, 0);
object[] pars = filter.GetAllValueParameters();
In[] parameters = Dialect.ConvertToNamedParameters(0, pars);
obj = Database.QueryScalar(sql + " " + whereSql, parameters);
return(Convert.ToInt32(obj));
}
obj = Database.QueryScalar(sql);
return(Convert.ToInt32(obj));
}
public virtual int UpdateSql(string table, string[] columns, object[] values, Filter filter)
{
if (values == null)
{
values = new object[columns.Length];
}
string sql = Dialect.GetUpdateSql(table, columns, values);
In[] parameters = Dialect.ConvertToNamedParameters(values);
if (filter != null)
{
string whereSql = Dialect.GetWhereSql(filter, parameters.Count());
object[] pars = filter.GetAllValueParameters();
In[] filterParameters = Dialect.ConvertToNamedParameters(parameters.Count(), pars);
filterParameters = filterParameters.Where(x => x.Value != null && x.Value != DBNull.Value).ToArray();
parameters = parameters.Concat(filterParameters).ToArray();
sql = sql + " " + whereSql;
}
return(Database.ExecuteSql(sql, parameters));
}
