public static DataTable GetPublicDataTable(string sql, SqlTextType type) { switch (type) { case SqlTextType.Text: return(GetPublicText(sql)); default: return(GetPublicProcedure(sql)); } }
public SqlBuilder(Type tableType, ProviderType type, SqlTextType sqlType = SqlTextType.Query) { _type = type; _sqlType = sqlType; _sql = GetAdapter(); _tableType = tableType; _tables.Add(new SqlTableMappingEntity(tableType)); sortType = SqlOrderByType.ASC; partType = SqlPartType.Where; pageNumber = 1; pageSize = 10; }
private void SetBuilder <T>(SqlTextType type, SqlPartType partType = SqlPartType.None) { this.resolveType = typeof(T); if (type != SqlTextType.None) { builder.SqlType = type; } if (partType != SqlPartType.None) { builder.PartType = partType; } }
public static ArrayList GetComboBoxItems(ParamCaches pcs, string sql, SqlTextType type, string colname) { string pt = ConfigurationManager.AppSettings[PublicConsts.PC_ParamType]; if (!String.IsNullOrEmpty(pt) && (pt.ToLower() == "mem")) { if (pcs == null) { return(new ArrayList()); } return(pcs[sql].Items); } else { return(CtrlHelper.DataTableToItems(GetPublicDataTable(sql, type), colname)); } }
public void Clear() { _sqlType = SqlTextType.Query; sortType = SqlOrderByType.ASC; partType = SqlPartType.Where; functionType = SqlFunctionType.NONE; pageNumber = 1; pageSize = 10; distinct = false; topString = string.Empty; _useKey = false; _insertWithQuery = false; _tables.Clear(); _tables.Add(new SqlTableMappingEntity(_tableType)); _joins.Clear(); _conditions.Clear(); _selections.Clear(); _sorts.Clear(); _groupings.Clear(); _havings.Clear(); _parameters.Clear(); parameters.Clear(); }
public static ArrayList GetComboBoxItems(string sql, SqlTextType type, string colname) { return(CtrlHelper.DataTableToItems(GetPublicDataTable(sql, type), colname)); }