public ConvertToNamedParameters ( int indexToStart, object values ) : Sharp.Data.In[] | ||
indexToStart | int | |
values | object | |
Résultat | 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)); }