public GetUpdateSql ( string table, string columns, object values ) : string | ||
table | string | |
columns | string | |
values | object | |
리턴 | string |
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)); }