/// <summary> /// Warning: this method uses System.Windows.Forms.MessageBox. /// </summary> /// <param name="element"></param> static public void GetTableElementDictionary(this TableElement element) { element.conversionElements.Clear(); // ac_table element.conversionElements.Add("TableType", element.DbType); element.conversionElements.Add("tabletype", string.Format("{0}", element.DbType).ToLower()); // see the primary key related tags below element.conversionElements.Add("PK", element.PrimaryKey); element.conversionElements.Add("pk", element.PrimaryKey == null ? string.Empty : element.PrimaryKey.ToLower()); element.conversionElements.Add("PrimaryKey", element.PrimaryKey == null ? string.Empty : element.PrimaryKey); element.conversionElements.Add("PrimaryKeyCleanC", element.PrimaryKey == null ? string.Empty : element.PrimaryKey.ToStringCapitolize().Clean()); element.conversionElements.Add("primarykey", element.PrimaryKey == null ? string.Empty : element.PrimaryKey.ToLower()); // element.conversionElements.Add("Table", element.Name.Replace("-", "_")); // element.conversionElements.Add("TableName", element.Name); element.conversionElements.Add("tablename", element.Name.ToLower()); // element.conversionElements.Add("TableNameC", element.Name.ToStringCapitolize()); element.conversionElements.Add("TableNameClean", element.FriendlyName); element.conversionElements.Add("tablenameclean", element.FriendlyName.ToLower()); element.conversionElements.Add("TableNameCClean", element.FriendlyName.ToStringCapitolize()); // element.conversionElements.Add("TableCleanName", element.Name.Clean()); element.conversionElements.Add("TableCleanNameC", element.Name.Clean().ToStringCapitolize()); // element.conversionElements.Add("AdapterNs", element.NsAdapter); element.conversionElements.Add("AdapterT", element.TAdapter); element.conversionElements.Add("AdapterNsT", element.TypeAdapter); // element.conversionElements.Add("CommandNs", element.NsCommand); element.conversionElements.Add("CommandT", element.TCommand); element.conversionElements.Add("CommandNsT", element.TypeCommand); // element.conversionElements.Add("ConnectionNs", element.NsConnection); element.conversionElements.Add("ConnectionT", element.TConnection); element.conversionElements.Add("ConnectionNsT", element.TypeConnection); // element.conversionElements.Add("ParameterT", element.TParameter); // element.conversionElements.Add("ReaderNs", element.NsReader); element.conversionElements.Add("ReaderT", element.TReader); element.conversionElements.Add("ReaderNsT", element.TypeReader); // element.conversionElements.Add("Date", DateTime.Now.ToString("MM/dd/yyyy")); element.conversionElements.Add("Time", DateTime.Now.ToString("hh:mm.ss tt")); element.conversionElements.Add("DateTime", string.Format("{0:MM/dd/yyyy} {1:hh:mm.ss tt}", DateTime.Now, DateTime.Now)); // if (element.PrimaryKey == null) { System.Windows.Forms.MessageBox.Show("Table must provide a primary key", "Please check the table."); return; } else if (element.PrimaryKey != string.Empty) { element.conversionElements.Add("PKDataName", element.PrimaryKeyElement.DataName); element.conversionElements.Add("PKDataType", element.PrimaryKeyElement.DataType); element.conversionElements.Add("PKDataTypeNative", element.PrimaryKeyElement.DataTypeNative); element.conversionElements.Add("PKNativeNullType", NullableTypeUtility.GetNativeNullType(element.PrimaryKeyElement["Native"].ToString())); element.conversionElements.Add("PKNativeNullValue", NullableTypeUtility.IsNativeNullable(element.PrimaryKeyElement["Native"].ToString()) ? ".Value" : ""); // Add("PKDataTypeNative", PrimaryKeyElement.DataTypeNative); element.conversionElements.Add("PKDescription", element.PrimaryKeyElement.Description); // element.conversionElements.Add("PKDataNameC", element.PrimaryKeyElement.DataName.ToStringCapitolize()); element.conversionElements.Add("PKCleanName", element.PrimaryKeyElement.DataName.Replace("-", "_")); element.conversionElements.Add("PKCleanName,Nodash", element.PrimaryKeyElement.DataName.Clean()); element.conversionElements.Add("PKFriendlyName", element.PrimaryKeyElement.DataName.Clean()); element.conversionElements.Add("PKFriendlyNameC", element.PrimaryKeyElement.DataName.Clean().ToStringCapitolize()); } else { Global.statR(ResourceUtil.ResourceManager.GetString("TableElement_PrimaryKeyNotFound"), element.Name); } }
virtual public void InitializeDictionary() { conversionElements.Clear(); // ac_table // #region Table Type Add(StrKeys.TableType, DbType); Add(StrKeys.tabletype, string.Format("{0}", DbType).ToLower()); #endregion // #region Primary Key // see the primary key related tags below Add(StrKeys.PK, PrimaryKey); Add(StrKeys.pk, PrimaryKey == null ? string.Empty : PrimaryKey.ToLower()); Add(StrKeys.PrimaryKey, PrimaryKey ?? string.Empty); Add(StrKeys.PrimaryKeyCleanC, PrimaryKey == null ? string.Empty : PrimaryKey.ToStringCapitolize().Clean()); Add(StrKeys.primarykey, PrimaryKey == null ? string.Empty : PrimaryKey.ToLower()); #endregion // #region TableName // Add(StrKeys.Name, Name); Add(StrKeys.Table, Name.Replace("-", "_")); try { Add(StrKeys.TableAlias, View != null ? View.Alias : Link != null ? Link.Alias : Name); Add(StrKeys._TableAlias, View != null ? View.Alias : Link != null ? Link.Alias : Name.Replace("-", "_")); Add(StrKeys.tablealias, (conversionElements[StrKeys.TableAlias] as string).ToLower()); // Add(StrKeys.TableAliasC, conversionElements[StrKeys.TableAlias].ToStringCapitolize()); Add(StrKeys.FriendlyTableAlias, (conversionElements[StrKeys.TableAlias] as string).Clean()); Add(StrKeys.TableAliasClean, conversionElements[StrKeys.FriendlyTableAlias]); Add(StrKeys.tablealiasclean, (conversionElements[StrKeys.TableAlias] as string).ToLower()); Add(StrKeys.TableAliasCClean, conversionElements[StrKeys.TableAlias].ToStringCapitolize()); Add(StrKeys.TABLEALIASCLEAN, (conversionElements[StrKeys.TableAlias] as string).ToUpper()); // // Add("AliasCClean", conversionElements["FriendlyAlias"].ToStringCapitolize()); // Add(StrKeys.TableAliasCName, (conversionElements[StrKeys.TableAlias] as string).Clean()); Add(StrKeys.TableAliasCNameC, (conversionElements[StrKeys.TableAliasCName] as string).ToStringCapitolize()); } catch (Exception error) { Logger.Warn("Parse Exception", error.Message); } // Add(StrKeys.TableName, Name); Add(StrKeys.tablename, Name.ToLower()); // Add(StrKeys.TableNameC, Name.ToStringCapitolize()); Add(StrKeys.TableNameClean, FriendlyName); Add(StrKeys.tablenameclean, FriendlyName.ToLower()); Add(StrKeys.TableNameCClean, FriendlyName.ToStringCapitolize()); // Add(StrKeys.TableCleanName, Name.Clean()); Add(StrKeys.TableCleanNameC, Name.Clean().ToStringCapitolize()); #endregion // #region Namespace Types Add(StrKeys.AdapterNs, NsAdapter); Add(StrKeys.AdapterT, TAdapter); Add(StrKeys.AdapterNsT, TypeAdapter); // Add(StrKeys.CommandNs, NsCommand); Add(StrKeys.CommandT, TCommand); Add(StrKeys.CommandNsT, TypeCommand); // Add(StrKeys.ConnectionNs, NsConnection); Add(StrKeys.ConnectionT, TConnection); Add(StrKeys.ConnectionNsT, TypeConnection); // Add(StrKeys.ParameterT, TParameter); // Add(StrKeys.ReaderNs, NsReader); Add(StrKeys.ReaderT, TReader); Add(StrKeys.ReaderNsT, TypeReader); #endregion // GeneratorTypeProvider.GetTypes <GeneratorDateTimeFieldProvider>(conversionElements); #region Primary Key Automated Reference (NOT FOR VIEWS) // if (PrimaryKey == null) { ErrorMessage.Show("Table must provide a primary key", "Please check the table."); return; } else if (PrimaryKey != string.Empty && PrimaryKey != "%PKUNKNOWN%") { Add(StrKeys.PKDataName, PrimaryKeyElement.DataName); Add(StrKeys.PKDataType, PrimaryKeyElement.DataType); Add(StrKeys.PKDataTypeNative, PrimaryKeyElement.DataTypeNative); Add(StrKeys.PKNativeNullType, NullableTypeUtility.GetNativeNullType(PrimaryKeyElement[StrKeys.Native].ToString())); Add(StrKeys.PKNativeIsNullable, PrimaryKeyElement.IsNullable); Add(StrKeys.PKNativeNullValue, NullableTypeUtility.IsNativeNullable(PrimaryKeyElement[StrKeys.Native].ToString()) ? ".Value" : ""); Add(StrKeys.PKNativeNullValueGo, PrimaryKeyElement.Params[StrKeys.NativeNullTypeGo].ToString()); Add(StrKeys.PKNativeNullValueGoAddress, PrimaryKeyElement.IsNullable ? "&" : string.Empty); Add(StrKeys.PKNativeNullValueGoPointer, PrimaryKeyElement.IsNullable ? "*" : string.Empty); // Add("PKDataTypeNative",PrimaryKeyElement.DataTypeNative); Add(StrKeys.PKDescription, PrimaryKeyElement.Description); // Add(StrKeys.PKDataNameC, PrimaryKeyElement.DataName.ToStringCapitolize()); Add(StrKeys.PKCleanName, PrimaryKeyElement.DataName.Replace("-", "_")); Add(StrKeys.PKCleanName_Nodash, PrimaryKeyElement.DataName.Clean()); Add(StrKeys.PKFriendlyName, PrimaryKeyElement.DataName.Clean()); Add(StrKeys.PKFriendlyNameC, PrimaryKeyElement.DataName.Clean().ToStringCapitolize()); } else { Logger.Warn("TableElement.InitializeDictionary", Gen.Messages.TableElement_PrimaryKeyNotFound, Name); } #endregion if (Transform != null) { Transform(conversionElements); } }