public int buildSQL(DatabaseConnection dbConn, int index, StringBuilder b) { if (!string.IsNullOrEmpty(searchFieldName) && !string.IsNullOrEmpty(selectQueryOrItemList)) { b.Append(searchFieldName).Append(" IN (").Append(selectQueryOrItemList); if (filter != null) { b.Append(" ").Append(filter.getWhereClause(dbConn, true, index, out index)); } b.Append(")"); } return(index); }
public int buildSQL(DatabaseConnection dbConn, int index, StringBuilder b) { if (notExist) { b.Append(" NOT"); } b.Append(" EXISTS (SELECT ").Append(selectFieldList).Append(" FROM ").Append(tableName); int out_index = 0; if (filter != null) { b.Append(filter.getWhereClause(dbConn, true, index, out out_index)); b.Append(filter.getGroupCluase()); } b.Append(")"); return(out_index); }
public DbCommand CreateDeleteCommand(string DeleteQueryHeader, DBFilter dbFilter) { int commandIndex = 1; int buildSQLIndex = 1; string query = DeleteQueryHeader; DbCommand command = CreateCommand(); command.CommandType = CommandType.Text; if (dbFilter != null) { query += dbFilter.getWhereClause(this, false, buildSQLIndex, out buildSQLIndex); dbFilter.setParams(commandIndex, command); } command.CommandText = query; return(command); }
public DbCommand CreateSelectCommand(string SelectQueryWithoutConstraint, DBFilter dbFilter, ListInfo info) { int commandIndex = 1; int buildSQLIndex = 1; string query = SelectQueryWithoutConstraint; DbCommand command = CreateCommand(); command.CommandType = CommandType.Text; if (dbFilter != null) { query += dbFilter.getWhereClause(this, false, buildSQLIndex, out buildSQLIndex); query += dbFilter.getGroupCluase(); query += dbFilter.getOrderClause(info); dbFilter.setParams(commandIndex, command); } command.CommandText = query; return(command); }
//public DbCommand CreateSelectCommand(string FieldList, string TableList, DBFilter dbFilter) //{ // string query = "SELECT " + FieldList + " FROM " + TableList; // return CreateSelectCommand(query, dbFilter, null); //} private DbCommand CreateUpdateCommand(string tablename, DBObject obj, ICollection <DBField> dbFieldList, DBFilter dbFilter) { int commandIndex = 1; int buildSQLIndex = 1; DbCommand command = CreateCommand(); command.CommandType = CommandType.Text; string updateField = string.Empty; foreach (DBField dbField in dbFieldList) { if (!dbField.isAuto) { if (obj.isModified(dbField.name)) { object value = dbField.property.GetValue(obj, null); if (value is string) { value = ((string)value).Trim(); } if (dbField.transcoder != null) { value = dbField.transcoder.toDB(value); } string fieldParameterName = getQueryValueParameterName(buildSQLIndex.ToString()); buildSQLIndex++; string valueParameterName = "@" + commandIndex++; string assignValue = dbField.columnName + " = " + fieldParameterName; if (updateField.Equals(string.Empty)) { updateField = " SET " + assignValue; } else { updateField += ", " + assignValue; } SetUpdateCommandDBParameter(command, valueParameterName, value); } } } if (!string.IsNullOrEmpty(updateField)) { string query = "UPDATE " + tablename + updateField; if (dbFilter != null) { query += dbFilter.getWhereClause(this, false, buildSQLIndex, out buildSQLIndex); dbFilter.setParams(commandIndex, command); } command.CommandText = query; return(command); } else { return(null); } }