public override void ConfigureColumns(ColumnConfiguration columnConfig)
{
foreach (var col in ColumnsToShowInView)
{
columnConfig.AddStringColumn(col.Value, col.Key);
}
foreach (var col in AdditionalColumns)
{
columnConfig.AddColumn(col);
}
columnConfig.AddLinkColumn("", "Id", "Edit", Id + 1);
columnConfig.AddButtonColumn("", "Id", "X",
new UserConfirmation("Delete " + ItemName + "?")
{
OnConfirmationUIAction = Id + 2
},
new ShowHideColumnSetting()
{
Display = ColumnDisplayType.Show,
Conditions = new List <Condition>()
{
new Condition("CanDelete", Comparison.Equals, "true")
}
}
);
}
public override void ConfigureColumns(ColumnConfiguration columnConfig)
{
columnConfig.AddStringColumn("Name", "Name");
columnConfig.AddLinkColumn("", "Id", "Editions", MenuNumber.ViewEditions);
columnConfig.AddLinkColumn("", "Id", "Edit", MenuNumber.EditModel);
columnConfig.AddButtonColumn("", "Id", "X", new UserConfirmation("Delete model?", MenuNumber.DeleteModel));
}
public override void ConfigureColumns(ColumnConfiguration columnConfig)
{
columnConfig.AddStringColumn("Name", "Name");
columnConfig.AddLinkColumn("", "Id", "Models", MenuNumber.ViewModels);
columnConfig.AddLinkColumn("", "Id", "Edit", MenuNumber.EditManufacturer);
columnConfig.AddButtonColumn("", "Id", "X", new UserConfirmation("Delete manufacturer?", MenuNumber.DeleteManufacturer));
}
public override void ConfigureColumns(ColumnConfiguration columnConfig)
{
columnConfig.AddStringColumn("Name", "Name");
columnConfig.AddStringColumn("Name", "Surname");
columnConfig.AddLinkColumn("", "Id", "Edit", MenuNumber.EditPatient);
columnConfig.AddButtonColumn("", "Id", "X", new UserConfirmation("Delete patient?", MenuNumber.DeletePatient));
}
public override void ConfigureColumns(ColumnConfiguration columnConfig)
{
columnConfig.AddStringColumn("Name", "UserName");
columnConfig.AddStringColumn("Email", "Email");
columnConfig.AddBooleanColumn("Email Confirmed", "EmailConfirmed", "Yes", "No");
columnConfig.AddLinkColumn("", "Id", "Send Confirmation Email", EventNumber.SendConfirmationEmail,
new ShowHideColumnSetting()
{
Display = ColumnDisplayType.Hide,
Conditions = new List <Condition>()
{
new Condition("EmailConfirmed", Comparison.Equals, "true")
}
}
);
columnConfig.AddLinkColumn("", "Id", "Edit", EventNumber.EditUser);
columnConfig.AddButtonColumn("", "Id", "X",
new UserConfirmation("Delete User?")
{
OnConfirmationUIAction = EventNumber.DeleteUser
},
new ShowHideColumnSetting()
{
Display = ColumnDisplayType.Show,
Conditions = new List <Condition>()
{
new Condition("CanDelete", Comparison.Equals, "true")
}
}
);
}
/// <summary>
/// Initializes a new instance of the <see cref="ColumnConfiguration"/>
/// class from an existing instance.
/// </summary>
/// <param name="other">
/// The instance from which to make a copy.
/// </param>
/// <exception cref="System.ArgumentNullException">
/// <paramref name="other"/> is <c>null</c>.
/// </exception>
public ColumnConfiguration(ColumnConfiguration other)
{
Guard.NotNull(other, nameof(other));
this.Metadata = other.Metadata.CloneT();
this.DisplayHints = other.DisplayHints.CloneT();
}
public override void ConfigureColumns(ColumnConfiguration columnConfig)
{
columnConfig.AddStringColumn("Name", "Name");
columnConfig.AddStringColumn("Product Type", "ProductType.Name");
columnConfig.AddLinkColumn("", "Id", "Edit", MenuNumber.EditProduct);
columnConfig.AddButtonColumn("", "Id", "X", new UserConfirmation("Delete product?", MenuNumber.DeleteProduct));
}
public override void ConfigureColumns(ColumnConfiguration columnConfig)
{
columnConfig.AddStringColumn("Id", "Id");
columnConfig.AddStringColumn("PostId", "PostId");
columnConfig.AddStringColumn("Name", "Name");
columnConfig.AddStringColumn("Email", "Email");
columnConfig.AddStringColumn("Body", "Body");
}
public override void ConfigureColumns(ColumnConfiguration columnConfig)
{
columnConfig.AddStringColumn("Name", "Name");
columnConfig.AddStringColumn("Region", "Region.Name");
columnConfig.AddLinkColumn("", "Id", "Edit", MenuNumber.EditCountry);
columnConfig.AddButtonColumn("", "Id", "X", new UserConfirmation("Delete item?", MenuNumber.DeleteCountry));
}
public override void ConfigureColumns(ColumnConfiguration columnConfig)
{
columnConfig.AddStringColumn("Warehouse", "Warehouse.Name");
columnConfig.AddStringColumn("Product", "Product.Name");
columnConfig.AddStringColumn("Quantity", "StockQuantity");
columnConfig.AddLinkColumn("", "Id", "Edit", MenuNumber.EditStock);
columnConfig.AddButtonColumn("", "Id", "X", new UserConfirmation("Delete warehouse stock?", MenuNumber.DeleteStock));
}
public void AddColumn(string dtoFieldName, string dbColumnName = null,
bool isIdentity = false, bool isPrimaryKey = false,
Action <ColumnConfiguration> configColumn = null)
{
var config = new ColumnConfiguration(Table, dtoFieldName, dbColumnName, isIdentity, isPrimaryKey);
configColumn?.Invoke(config);
AddColumn(config);
}
public override void ConfigureColumns(ColumnConfiguration columnConfig)
{
columnConfig.AddStringColumn("Name", "Name");
columnConfig.AddStringColumn("Address", "Address");
columnConfig.AddStringColumn("Company", "Company.Name");
columnConfig.AddLinkColumn("", "Id", "Edit", MenuNumber.EditWarehouse);
columnConfig.AddLinkColumn("", "Id", "Stock", MenuNumber.ViewStocks);
columnConfig.AddButtonColumn("", "Id", "X", new UserConfirmation("Delete warehouse?", MenuNumber.DeleteWarehouse));
}
public override void ConfigureColumns(ColumnConfiguration columnConfig)
{
columnConfig.AddStringColumn("Name", "Name");
columnConfig.AddStringColumn("Email", "Email");
columnConfig.AddStringColumn("Region", "Region.Name");
columnConfig.AddStringColumn("Gender", "Gender");
columnConfig.AddStringColumn("Course Number", "CourseNumber");
columnConfig.AddLinkColumn("Certificate", "Id", "Certificate", MenuNumber.AttendeeCertificate);
}
public override void ConfigureColumns(ColumnConfiguration columnConfig)
{
columnConfig.AddStringColumn("Date", "Date");
columnConfig.AddStringColumn("Task", "Task");
columnConfig.AddStringColumn("Status", "Status", 3);
columnConfig.AddHiddenColumn("Id");
var json = new JsonHelper();
json.Add("type", "status");
columnConfig.AddLinkColumn("", "Id", "Detail", EventNumber.ViewBackgroundDetail, parametersToPass: json.ToString()); //parameters not passing
}
public override void ConfigureColumns(ColumnConfiguration columnConfig)
{
columnConfig.AddStringColumn("Field", "Field");
columnConfig.AddStringColumn("Column Number/s", "Columns");
columnConfig.AddLinkColumn("", "Id", "Edit", EventNumber.EditCsvColumnMapping);
//columnConfig.AddButtonColumn("", "Id", "X", new UserConfirmation("Delete selected item?")
//{
// OnConfirmationUIAction = MobileMenuNumber.DeleteCsvColumnMapping
//});
}
public override void ConfigureColumns(ColumnConfiguration columnConfig)
{
columnConfig.AddStringColumn("Name", "Name");
columnConfig.AddStringColumn("Description", "Description");
columnConfig.AddLinkColumn("", "Id", "Edit", EventNumber.EditUserRole);
columnConfig.AddButtonColumn("", "Id", "X",
new UserConfirmation("Delete User Role?")
{
OnConfirmationUIAction = EventNumber.DeleteUserRole
}
);
}
public override void ConfigureColumns(ColumnConfiguration columnConfig)
{
columnConfig.AddStringColumn("Name", "Name");
columnConfig.AddStringColumn("Email", "Email");
columnConfig.AddStringColumn("Gender", "GenderString");
columnConfig.AddStringColumn("Region", "RegionString");
columnConfig.AddStringColumn("Outcome", "OutcomeString");
columnConfig.AddLinkColumn("", "Id", "Edit", MenuNumber.EditCourseAttendee);
columnConfig.AddButtonColumn("", "Id", "X", new UserConfirmation("Delete selected item?")
{
OnConfirmationUIAction = MenuNumber.DeleteCourseAttendee
});
}
public override void ConfigureColumns(ColumnConfiguration columnConfig)
{
columnConfig.AddStringColumn("Name", "Name");
columnConfig.AddHiddenColumn("Name");
columnConfig.AddStringColumn("Event", "Event");
columnConfig.AddButtonColumn("Sub Menus", "Id", "...", EventNumber.ViewMenus, new ShowHideColumnSetting()
{
Display = ColumnDisplayType.Show,
Conditions = new List <Condition>()
{
new Condition("Event", Comparison.IsNull)
}
}, MenuId);
columnConfig.AddHiddenColumn("Position");
columnConfig.AddButtonColumn("", "Id", "Up", EventNumber.IncrementMenuOrder,
new ShowHideColumnSetting()
{
Display = ColumnDisplayType.Show,
Conditions = new List <Condition>()
{
new Condition("Position", Comparison.GreaterThan, "0")
}
});
columnConfig.AddButtonColumn("", "Id", "Down", EventNumber.DecrementMenuOrder);
//TODO: Would be good to hide the Down button for the last item.
columnConfig.AddLinkColumn("", "Id", "Edit", EventNumber.EditMenu, null);
columnConfig.AddButtonColumn("", "Id", "X",
new UserConfirmation("Delete Menu Item?")
{
OnConfirmationUIAction = EventNumber.DeleteMenu
},
columnSetting: new ShowHideColumnSetting()
{
Display = ColumnDisplayType.Show,
Conditions = new List <Condition>()
{
new Condition("CanDelete", Comparison.Equals, "true")
}
}
);
}
public override void ConfigureColumns(ColumnConfiguration columnConfig)
{
columnConfig.AddStringColumn("Course Type", "CourseType");
columnConfig.AddStringColumn("Presenter", "Presenter");
columnConfig.AddStringColumn("Venue", "Venue");
columnConfig.AddStringColumn("Region", "Region");
columnConfig.AddStringColumn("Country", "Country");
columnConfig.AddDateColumn("Start Date", "StartDate");
columnConfig.AddStringColumn("Course Id", "CourseId");
columnConfig.AddLinkColumn("Attendees", "Id", "Attendees", MenuNumber.ViewAttendees);
columnConfig.AddLinkColumn("", "Id", "Edit", MenuNumber.EditCourse);
columnConfig.AddButtonColumn("", "Id", "X", new UserConfirmation("Delete item?", MenuNumber.DeleteCourse));
}
public override void ConfigureColumns(ColumnConfiguration columnConfig)
{
columnConfig.AddStringColumn("String Value", "StringValue");
columnConfig.AddStringColumn("Number Value", "NumberValue");
columnConfig.AddDateColumn("Date Value", "DateValue");
columnConfig.AddStringColumn("Long Value", "LongTestValue");
columnConfig.AddStringColumn("Category", "Category.Description"); // You can reference sub fields in the column name field
columnConfig.AddLinkColumn("", "Id", "Edit", MenuNumber.SampleEdit);
columnConfig.AddButtonColumn("", "Id", "X",
new UserConfirmation("Delete item?")
{
OnConfirmationUIAction = MenuNumber.SampleDelete
});
}
public override void ConfigureColumns(ColumnConfiguration columnConfig)
{
columnConfig.AddStringColumn("Name", "EditionName");
columnConfig.AddStringColumn("Year", "EditionYear");
columnConfig.AddLinkColumn("", "Id", "Edit", MenuNumber.EditEdition);
columnConfig.AddButtonColumn("Details", "Id", "...", MenuNumber.DetailsEdition, new ShowHideColumnSetting()
{
Display = ColumnDisplayType.Hide,
Conditions = new List <Condition>()
{
new Condition("Category", Comparison.Equals, "Special") // Can be used to hide buttons for certain types of data
}
});
columnConfig.AddButtonColumn("", "Id", "X", new UserConfirmation("Delete edition?", MenuNumber.DeleteEdition));
}
public IEvent GetEventItem(int key)
{
if (!EventList.ContainsKey(key))
{
return(null);
}
var type = EventList[key];
var item = Container.Resolve(type) as IEvent;
if (typeof(IBasicCrudView).IsAssignableFrom(type))
{
var subTypeType = SubTypes[key];
var subType = Container.Resolve(subTypeType) as IBasicCrudMenuItem;
var viewInstance = item as IBasicCrudView;
viewInstance.Id = subType.GetBaseMenuId();
viewInstance.ItemName = subType.GetBaseItemName();
viewInstance.ColumnsToShowInView = subType.GetColumnsToShowInView();
viewInstance.OrderQuery = subType.OrderQueryInternal;
var columnConfig = new ColumnConfiguration();
subType.ConfigureAdditionalColumns(columnConfig);
viewInstance.AdditionalColumns = columnConfig.GetColumns();
}
else if (typeof(IBasicCrudModify).IsAssignableFrom(type))
{
var subTypeType = SubTypes[key];
var subType = Container.Resolve(subTypeType) as IBasicCrudMenuItem;
var modifyInstance = item as IBasicCrudModify;
modifyInstance.Id = subType.GetBaseMenuId() + 1;
modifyInstance.ItemName = subType.GetBaseItemName();
modifyInstance.InputProperties = subType.GetInputProperties();
modifyInstance.UniquePropertyName = subType.UniquePropertyName;
modifyInstance.OnModifyInternal = subType.OnModifyInternal;
}
else if (typeof(IBasicCrudDelete).IsAssignableFrom(type))
{
var subTypeType = SubTypes[key];
var subType = Container.Resolve(subTypeType) as IBasicCrudMenuItem;
var deleteInstance = (IBasicCrudDelete)item;
deleteInstance.Id = subType.GetBaseMenuId() + 2;
deleteInstance.ItemName = subType.GetBaseItemName();
deleteInstance.OnDeleteInternal = subType.OnDeleteInternal;
}
return(item);
}
public void ExtractConfigurationFromDatabase()
{
ConfigurationService configurationService = ConfigurationService.Instance;
SqlServerSchema schema = new SqlServerSchema(configurationService.ApiConfiguration.ConnectionString);
foreach (SqlServerTable table in schema.Tables)
{
string routeConfigurationFilePath = Path.Combine(configurationService.RoutesConfigurationDirectoryPath, table.Name + ".json");
// only write the route configuration file if it does not yet exist
if (!File.Exists(routeConfigurationFilePath))
{
RouteConfiguration routeConfiguration = new RouteConfiguration()
{
Id = Guid.NewGuid(),
Name = table.Name + "Route",
Resource = table.Name,
Schema = table.Schema,
Table = table.Name
};
foreach (SqlServerColumn column in table.Columns)
{
ColumnConfiguration columnConfiguration = new ColumnConfiguration()
{
ColumnName = column.Name,
IsPrimaryKey = column.IsPrimaryKey
};
if (column.IsPrimaryKey)
{
routeConfiguration.PrimaryKeyColumn = column.Name;
routeConfiguration.PrimaryKeyColumnDataType = column.DataType;
}
routeConfiguration.Columns.Add(columnConfiguration);
}
string json = JsonConvert.SerializeObject(routeConfiguration);
File.WriteAllText(routeConfigurationFilePath, json);
}
}
}
public object GetObfuscatedValue(IOxymoronEngine oxymoronEngine, ColumnConfiguration columnConfiguration, IMetaColumn metaColumn, object columnValue)
{
ColumnConfiguration <TObfuscationStrategyConfiguration> _columnConfiguration;
object value;
if ((object)oxymoronEngine == null)
{
throw new ArgumentNullException("oxymoronEngine");
}
if ((object)columnConfiguration == null)
{
throw new ArgumentNullException("columnConfiguration");
}
if ((object)metaColumn == null)
{
throw new ArgumentNullException("metaColumn");
}
if ((object)columnValue == DBNull.Value)
{
columnValue = null;
}
if ((object)columnConfiguration.ObfuscationStrategySpecificConfiguration == null)
{
throw new InvalidOperationException(string.Format("Configuration missing: '{0}'.", "ObfuscationStrategyConfiguration"));
}
_columnConfiguration = new ColumnConfiguration <TObfuscationStrategyConfiguration>(columnConfiguration);
if ((object)_columnConfiguration.ObfuscationStrategySpecificConfiguration == null)
{
throw new InvalidOperationException(string.Format("Configuration missing: '{0}'.", "ObfuscationStrategyConfiguration"));
}
value = this.CoreGetObfuscatedValue(oxymoronEngine, _columnConfiguration, metaColumn, columnValue);
return(value);
}
private void ApplyViewToDocument_MetadataSettings(ObfuscationConfiguration obfuscationConfiguration)
{
if ((object)obfuscationConfiguration == null)
{
throw new ArgumentNullException("obfuscationConfiguration");
}
obfuscationConfiguration.TableConfiguration = obfuscationConfiguration.TableConfiguration ?? new TableConfiguration();
foreach (IMetaColumnSpecListView metaColumnSpecView in this.View.ObfuscationPartialView.MetadataSettingsPartialView.MetaColumnSpecListViews)
{
ColumnConfiguration columnConfiguration;
columnConfiguration = new ColumnConfiguration()
{
ColumnName = metaColumnSpecView.ColumnName ?? string.Empty,
ObfuscationStrategyAqtn = metaColumnSpecView.ObfuscationStrategyAqtn
};
obfuscationConfiguration.TableConfiguration.ColumnConfigurations.Add(columnConfiguration);
}
}
/// <summary>
/// Called when [right click].
/// </summary>
/// <param name="sender">The sender.</param>
/// <param name="e">The <see cref="DataGridViewCellMouseEventArgs" /> instance containing the event data.</param>
public void OnRightClick(object sender, DataGridViewCellMouseEventArgs e)
{
if (e.Button == MouseButtons.Right)
{
try
{
using var _columnConfiguration = new ColumnConfiguration(this);
foreach (DataGridViewColumn c in Columns)
{
_columnConfiguration.ColumnListBox.Items.Add(c.HeaderText, c.Visible);
}
_columnConfiguration.ColumnListBox.Items.Clear();
_columnConfiguration.Location = PointToScreen(new Point(e.X, e.Y));
_columnConfiguration.ShowDialog();
}
catch (Exception ex)
{
Fail(ex);
}
}
}
protected override object CoreGetObfuscatedValue(IOxymoronEngine oxymoronEngine, ColumnConfiguration<ObfuscationStrategyConfiguration> columnConfiguration, IMetaColumn metaColumn, object columnValue)
{
long signHash, valueHash;
object value;
string sharedSecret;
if ((object)columnConfiguration == null)
throw new ArgumentNullException("columnConfiguration");
if ((object)metaColumn == null)
throw new ArgumentNullException("metaColumn");
if ((object)columnConfiguration.ObfuscationStrategySpecificConfiguration == null)
throw new InvalidOperationException(string.Format("Configuration missing: '{0}'.", "ObfuscationStrategyConfiguration"));
signHash = this.GetSignHash(oxymoronEngine, columnValue);
valueHash = this.GetValueHash(oxymoronEngine, null, columnValue);
sharedSecret = ((valueHash <= 0 ? 1 : valueHash) * (signHash % 2 == 0 ? -1 : 1)).ToString("X");
value = GetCipher(sharedSecret, columnValue);
return value;
}
public IEnumerable <Message> ValidateObfuscationStrategySpecificConfiguration(ColumnConfiguration columnConfiguration, int?colummIndex)
{
ColumnConfiguration <TObfuscationStrategyConfiguration> _columnConfiguration;
if ((object)columnConfiguration == null)
{
throw new ArgumentNullException("columnConfiguration");
}
if ((object)columnConfiguration.ObfuscationStrategySpecificConfiguration == null)
{
throw new InvalidOperationException(string.Format("Configuration missing: '{0}'.", "ObfuscationStrategyConfiguration"));
}
_columnConfiguration = new ColumnConfiguration <TObfuscationStrategyConfiguration>(columnConfiguration);
if ((object)_columnConfiguration.ObfuscationStrategySpecificConfiguration == null)
{
throw new InvalidOperationException(string.Format("Configuration missing: '{0}'.", "ObfuscationStrategyConfiguration"));
}
return(_columnConfiguration.ObfuscationStrategySpecificConfiguration.Validate(colummIndex));
}
/// <summary>
/// Called when [right click].
/// </summary>
/// <param name="sender">The sender.</param>
/// <param name="e">The
/// <see cref="MouseEventArgs" />
/// instance containing the event dataRows.</param>
public void OnRightClick(object sender, MouseEventArgs e)
{
if (e.Button == MouseButtons.Right &&
Binder.CurrentRowIndex <= 1)
{
try
{
var _configuration = new ColumnConfiguration(sender as DataGridView);
_configuration?.ColumnListBox?.Items?.Clear();
foreach (var _name in _configuration?.ColumnNames)
{
_configuration?.ColumnListBox?.Items?.Add(_name.SplitPascal(), false);
}
_configuration.Location = PointToScreen(new Point(e.X, e.Y));
_configuration.TopMost = true;
}
catch (Exception ex)
{
Fail(ex);
}
}
}
public override void ConfigureColumns(ColumnConfiguration columnConfig)
{
columnConfig.AddStringColumn("String Value", "StringValue");
columnConfig.AddStringColumn("Number Value", "NumberValue");
columnConfig.AddDateColumn("Date Value", "DateValue");
columnConfig.AddStringColumn("Long Value", "LongTestValue");
columnConfig.AddStringColumn("Category", "Category");
columnConfig.AddLinkColumn("", "Id", "Edit", MenuNumber.AdvancedEdit);
columnConfig.AddButtonColumn("", "Id", "X",
new UserConfirmation("Delete item?")
{
OnConfirmationUIAction = MenuNumber.AdvancedDelete
});
columnConfig.AddButtonColumn("Details", "Id", "...", MenuNumber.AdvancedDetails, new ShowHideColumnSetting()
{
Display = ColumnDisplayType.Hide,
Conditions = new List <Condition>()
{
new Condition("Category", Comparison.Equals, "Special") // Can be used to hide buttons for certain types of data
}
});
}
/// <summary>
/// 初始化数据库
/// </summary>
private void InitializeDatabase(bool rebuild)
{
DbFactory.DbConnectionString = SystemConfig.Current.DbConnectionString;
DbFactory.DefaultDbName = SystemConfig.Current.DefaultDbName;
ColumnConfiguration[] colCfgsObj = new ColumnConfiguration[] {
new ColumnConfiguration( TableString.ObjectFieldId, BlazeDbType.INT4, true ),
new ColumnConfiguration( TableString.ObjectFieldOwner, BlazeDbType.INT4 ),
new ColumnConfiguration( TableString.ObjectFieldParentId, BlazeDbType.INT4 ),
new ColumnConfiguration( TableString.ObjectFieldName, BlazeDbType.STRING),
new ColumnConfiguration( TableString.ObjectFieldComment, BlazeDbType.STRING)
};
ColumnConfiguration[] colCfgsUser = new ColumnConfiguration[] {
new ColumnConfiguration( TableString.UserFieldId, BlazeDbType.INT4, true ),
new ColumnConfiguration( TableString.UserFieldUserName, BlazeDbType.SHORT_STRING, false, true ),
new ColumnConfiguration( TableString.UserFieldRealName, BlazeDbType.SHORT_STRING),
new ColumnConfiguration( TableString.UserFieldPassword, BlazeDbType.STRING)
};
ColumnConfiguration[] colCfgsGroup = new ColumnConfiguration[] {
new ColumnConfiguration( TableString.UserGroupFieldId, BlazeDbType.INT4, true ),
new ColumnConfiguration( TableString.UserGroupFieldGroupName, BlazeDbType.SHORT_STRING, false, true )
};
ColumnConfiguration[] colCfgsUserGroup = new ColumnConfiguration[] {
new ColumnConfiguration( TableString.UserInGroupFieldUserId, BlazeDbType.INT4, true),
new ColumnConfiguration( TableString.UserInGroupFieldGroupId, BlazeDbType.INT4, true ),
new ColumnConfiguration( TableString.UserInGroupFieldEstablishDatetime, BlazeDbType.DATETIME )
};
ColumnConfiguration[] colCfgsAce = new ColumnConfiguration[] {
new ColumnConfiguration( TableString.AceFieldAceId, BlazeDbType.INT4, false,true,true,true,null ),
new ColumnConfiguration( TableString.AceFieldObjectId, BlazeDbType.INT4 ),
new ColumnConfiguration( TableString.AceFieldOperatorId, BlazeDbType.INT4 ),
new ColumnConfiguration( TableString.AceFieldOperation, BlazeDbType.INT4),
};
ColumnConfiguration[] colCfgsGameServer = new ColumnConfiguration[] {
new ColumnConfiguration( TableString.GameServerFieldId, BlazeDbType.INT4, true ),
new ColumnConfiguration( TableString.GameServerFieldNetAddress, BlazeDbType.SHORT_STRING),
new ColumnConfiguration( TableString.GameServerFieldGameDir, BlazeDbType.LONG_STRING),
new ColumnConfiguration( TableString.GameServerFieldLordPort, BlazeDbType.INT4),
new ColumnConfiguration( TableString.GameServerFieldMaxPlayer, BlazeDbType.INT4),
new ColumnConfiguration( TableString.GameServerFieldIntranetMask, BlazeDbType.SHORT_STRING),
new ColumnConfiguration( TableString.GameServerFieldInternetMask, BlazeDbType.SHORT_STRING),
new ColumnConfiguration( TableString.GameServerFieldPaysysIp, BlazeDbType.SHORT_STRING),
new ColumnConfiguration( TableString.GameServerFieldPaysysPort, BlazeDbType.INT4),
new ColumnConfiguration( TableString.GameServerFieldPaysysLoginName, BlazeDbType.SHORT_STRING),
new ColumnConfiguration( TableString.GameServerFieldPaysysLoginPwd, BlazeDbType.LONG_STRING),
new ColumnConfiguration( TableString.GameServerFieldDbHost, BlazeDbType.SHORT_STRING),
new ColumnConfiguration( TableString.GameServerFieldDbName, BlazeDbType.SHORT_STRING),
new ColumnConfiguration( TableString.GameServerFieldDbLoginName, BlazeDbType.SHORT_STRING),
new ColumnConfiguration( TableString.GameServerFieldDbLoginPwd, BlazeDbType.LONG_STRING),
new ColumnConfiguration( TableString.GameServerFieldDbBackupDir, BlazeDbType.LONG_STRING),
new ColumnConfiguration( TableString.GameServerFieldFSEyeIp, BlazeDbType.SHORT_STRING),
new ColumnConfiguration( TableString.GameServerFieldFSEyePort, BlazeDbType.INT4),
new ColumnConfiguration( TableString.GameServerFieldHasBeenConfigGuard, BlazeDbType.INT4),
new ColumnConfiguration( TableString.GameServerFieldServerType, BlazeDbType.INT4),
new ColumnConfiguration( TableString.GameServerFieldCfgString, BlazeDbType.LONG_STRING),
new ColumnConfiguration( TableString.GameServerFieldFtpDownloadServer, BlazeDbType.INT4),
new ColumnConfiguration( TableString.GameServerFieldGmcIp, BlazeDbType.STRING),
new ColumnConfiguration( TableString.GameServerFieldGmcAccount, BlazeDbType.STRING)
};
ColumnConfiguration[] colCfgsServerGroup = new ColumnConfiguration[] {
new ColumnConfiguration( TableString.ServerGroupFieldId, BlazeDbType.INT4, true ),
new ColumnConfiguration( TableString.ServerGroupFieldType, BlazeDbType.INT4),
new ColumnConfiguration( TableString.ServerGroupFieldGroupEnable, BlazeDbType.INT2),
new ColumnConfiguration( TableString.ServerGroupFieldMaxPlayers, BlazeDbType.INT4),
new ColumnConfiguration( TableString.ServerGroupFieldMaxPlayersLogTime, BlazeDbType.DATETIME),
new ColumnConfiguration( TableString.ServerGroupFieldCabinet,BlazeDbType.LONG_STRING),
new ColumnConfiguration( TableString.ServerGroupFieldGroupVersion, BlazeDbType.STRING )
};
ColumnConfiguration[] colCfgsServerRegion = new ColumnConfiguration[] {
new ColumnConfiguration( TableString.ServerRegionFieldId , BlazeDbType.INT4, true ),
new ColumnConfiguration( TableString.ServerRegionFieldMaxPlayers, BlazeDbType.INT4),
new ColumnConfiguration( TableString.ServerRegionFieldMaxPlayersLogTime, BlazeDbType.DATETIME),
new ColumnConfiguration( TableString.ServerRegionFieldRegionName , BlazeDbType.LONG_STRING),
new ColumnConfiguration( TableString.ServerRegionFieldRegionType , BlazeDbType.INT2)
};
ColumnConfiguration[] colCfgsGameLog = new ColumnConfiguration[] {
new ColumnConfiguration( TableString.GameLogFieldId, BlazeDbType.INT4, true ),
new ColumnConfiguration( TableString.GameLogFieldGameServerId, BlazeDbType.INT4 ),
new ColumnConfiguration( TableString.GameLogFieldDate, BlazeDbType.DATE ),
new ColumnConfiguration( TableString.GameLogFieldTotalMoney, BlazeDbType.INT8 ),
new ColumnConfiguration( TableString.GameLogFieldTotalMoneyInBox, BlazeDbType.INT8 )
};
ColumnConfiguration[] colCfgsServerPlugIn = new ColumnConfiguration[] {
new ColumnConfiguration( TableString.ServerPlugInFieldId, BlazeDbType.INT4, true ),
new ColumnConfiguration( TableString.ServerPlugInFieldGameServerId, BlazeDbType.INT4 ),
new ColumnConfiguration( TableString.ServerPlugInFieldPlugInGuid, BlazeDbType.STRING ),
new ColumnConfiguration( TableString.ServerPlugInFieldParameter1,BlazeDbType.INT2),
new ColumnConfiguration( TableString.ServerPlugInFieldParameter2, BlazeDbType.INT2 ),
new ColumnConfiguration( TableString.ServerPlugInFieldParameter3, BlazeDbType.STRING ),
new ColumnConfiguration( TableString.ServerPlugInFieldPlugInName, BlazeDbType.STRING )
};
ColumnConfiguration[] strategy = new ColumnConfiguration[] {
new ColumnConfiguration( TableString.StrategyFieldId, BlazeDbType.INT4, true ),
new ColumnConfiguration( TableString.StrategyFieldEvent, BlazeDbType.INT4),
new ColumnConfiguration( TableString.StrategyFieldAutomation, BlazeDbType.BLOB),
new ColumnConfiguration( TableString.StrategyFieldEnabled, BlazeDbType.INT2)
};
ColumnConfiguration[] scheduledTask = new ColumnConfiguration[] {
new ColumnConfiguration( TableString.ScheduledTaskFieldId, BlazeDbType.INT4, true ),
new ColumnConfiguration( TableString.ScheduledTaskFieldTaskData, BlazeDbType.BLOB)
};
//ColumnConfiguration[] task = new ColumnConfiguration[] {
// new ColumnConfiguration( TableString.TaskFieldId, BlazeDbType.INT4, true ),
// new ColumnConfiguration( TableString.TaskFieldName, BlazeDbType.STRING),
// new ColumnConfiguration( TableString.TaskFieldAutomation, BlazeDbType.BLOB),
// new ColumnConfiguration( TableString.TaskFieldInterval,BlazeDbType.INT4),
// new ColumnConfiguration( TableString.TaskFieldPeriodUnit, BlazeDbType.INT4),
// new ColumnConfiguration( TableString.TaskFieldStart, BlazeDbType.DATETIME),
// new ColumnConfiguration( TableString.TaskFieldEnd, BlazeDbType.DATETIME),
// new ColumnConfiguration( TableString.TaskFieldSelectedDay, BlazeDbType.STRING),
// new ColumnConfiguration( TableString.TaskFieldSelectedMonth, BlazeDbType.STRING),
// new ColumnConfiguration( TableString.TaskFieldRepeatPeriod, BlazeDbType.INT4),
// new ColumnConfiguration( TableString.TaskFieldRepeatPersistenceTime, BlazeDbType.INT4),
// new ColumnConfiguration( TableString.StrategyFieldEnabled, BlazeDbType.INT2)
//};
ColumnConfiguration[] updateServer = new ColumnConfiguration[] {
new ColumnConfiguration( TableString.UpdateServerFieldId, BlazeDbType.INT4, true ),
new ColumnConfiguration( TableString.UpdateServerFieldAddress, BlazeDbType.SHORT_STRING),
new ColumnConfiguration( TableString.UpdateServerFieldPort, BlazeDbType.INT2),
new ColumnConfiguration( TableString.UpdateServerFieldUsername,BlazeDbType.STRING),
new ColumnConfiguration( TableString.UpdateServerFieldPassword,BlazeDbType.STRING),
new ColumnConfiguration( TableString.UpdateServerFieldLiteral,BlazeDbType.STRING),
new ColumnConfiguration( TableString.UpdateServerFieldUpdateServerType,BlazeDbType.INT2)
};
ColumnConfiguration[] playerCount = new ColumnConfiguration[] {
new ColumnConfiguration( TableString.PlayerCountFieldServerId, BlazeDbType.INT4, true ),
new ColumnConfiguration( TableString.PlayerCountFieldRecordTime, BlazeDbType.DATETIME, true),
new ColumnConfiguration( TableString.PlayerCountFieldMaxPlayerCount, BlazeDbType.INT2),
new ColumnConfiguration( TableString.PlayerCountFieldMinPlayerCount, BlazeDbType.INT2),
new ColumnConfiguration( TableString.PlayerCountFieldAveragePlayerCount, BlazeDbType.INT2)
};
ColumnConfiguration[] gmOpLog = new ColumnConfiguration[] {
new ColumnConfiguration( TableString.GMOpLogFieldId, BlazeDbType.INT4, false,true,true,true,null),
new ColumnConfiguration( TableString.GMOpLogFieldUserId,BlazeDbType.INT4),
new ColumnConfiguration( TableString.GMOpLogFieldOperation,BlazeDbType.INT2),
new ColumnConfiguration( TableString.GMOpLogFieldTarget,BlazeDbType.BLOB),
new ColumnConfiguration( TableString.GMOpLogFieldServerId,BlazeDbType.INT4),
new ColumnConfiguration( TableString.GMOpLogFieldDescription,BlazeDbType.BLOB),
new ColumnConfiguration( TableString.GMOpLogFieldLogTime,BlazeDbType.DATETIME),
new ColumnConfiguration( TableString.GMOpLogFieldTargetType,BlazeDbType.INT2)
};
ColumnConfiguration[] accountInfo = new ColumnConfiguration[] {
new ColumnConfiguration( TableString.AccountInfoFieldId, BlazeDbType.INT4, false,true,true,true,null),
new ColumnConfiguration( TableString.AccountInfoFieldName,BlazeDbType.STRING,false,true,false,false,null),
new ColumnConfiguration( TableString.AccountInfoFieldPassword,BlazeDbType.STRING)
};
ColumnConfiguration[] ibShop = new ColumnConfiguration[] {
new ColumnConfiguration( TableString.IbShopFieldId, BlazeDbType.INT4, false,true,true,true,null),
new ColumnConfiguration( TableString.IbShopFieldTimeStamp,BlazeDbType.DATETIME),
new ColumnConfiguration( TableString.IbShopFieldScript,BlazeDbType.BLOB)
};
ColumnConfiguration[] batchTask = new ColumnConfiguration[] {
new ColumnConfiguration( TableString.BatchTaskId, BlazeDbType.INT4,true),
new ColumnConfiguration( TableString.BatchTaskAutomation,BlazeDbType.BLOB),
new ColumnConfiguration( TableString.BatchTaskStep,BlazeDbType.INT4),
new ColumnConfiguration( TableString.BatchTaskServerIds,BlazeDbType.BLOB)
};
ColumnConfiguration[] serverEvent = new ColumnConfiguration[] {
new ColumnConfiguration(TableString.ServerEventFieldServerId, BlazeDbType.INT4, true),
new ColumnConfiguration(TableString.ServerEventFieldEventTime, BlazeDbType.DATETIME, true),
new ColumnConfiguration(TableString.ServerEventFieldEventType, BlazeDbType.INT2)
};
ColumnConfiguration[] serverOperationLog = new ColumnConfiguration[] {
new ColumnConfiguration(TableString.ServerOperationLogFieldId, BlazeDbType.INT8,false,true,true,true,null),
new ColumnConfiguration(TableString.ServerOperationLogFieldOperationId, BlazeDbType.INT8),
new ColumnConfiguration(TableString.ServerOperationLogFieldUserId, BlazeDbType.INT4),
new ColumnConfiguration(TableString.ServerOperationLogFieldServerOrGroup, BlazeDbType.INT2),
new ColumnConfiguration(TableString.ServerOperationLogFieldTargetId, BlazeDbType.INT4),
new ColumnConfiguration(TableString.ServerOperationLogFieldOperationType, BlazeDbType.INT2),
new ColumnConfiguration(TableString.ServerOperationLogFieldOperationResult, BlazeDbType.INT2),
new ColumnConfiguration(TableString.ServerOperationLogFieldDescription, BlazeDbType.LONG_STRING),
new ColumnConfiguration(TableString.ServerOperationLogFieldLogTime, BlazeDbType.DATETIME),
new ColumnConfiguration(TableString.ServerOperationLogFieldFatherRegion, BlazeDbType.LONG_STRING)
};
ColumnConfiguration[] serverMap = new ColumnConfiguration[] {
new ColumnConfiguration( TableString.ServerMapFieldId, BlazeDbType.INT4, true),
new ColumnConfiguration( TableString.ServerMapFieldParentId, BlazeDbType.INT4),
new ColumnConfiguration( TableString.ServerMapFieldName, BlazeDbType.STRING),
new ColumnConfiguration( TableString.ServerMapFieldMapType,BlazeDbType.INT4),
new ColumnConfiguration( TableString.ServerMapFieldIndex,BlazeDbType.INT4),
new ColumnConfiguration( TableString.ServerMapFieldFlag,BlazeDbType.INT4),
new ColumnConfiguration( TableString.ServerMapFieldMapServerId,BlazeDbType.INT4)
};
DbConfiguration dbCfg = new DbConfiguration(
DbFactory.DefaultDbName,
new TableConfiguration[] {
new TableConfiguration(TableString.ObjectTableName, colCfgsObj),
new TableConfiguration(TableString.UserTableName, colCfgsUser),
new TableConfiguration(TableString.UserGroupTableName, colCfgsGroup),
new TableConfiguration(TableString.UserInGroupTableName, colCfgsUserGroup),
new TableConfiguration(TableString.AceTableName, colCfgsAce),
new TableConfiguration(TableString.GameServerTableName, colCfgsGameServer),
new TableConfiguration(TableString.ServerGroupTableName, colCfgsServerGroup),
new TableConfiguration(TableString.ServerRegionTableName, colCfgsServerRegion),
new TableConfiguration(TableString.GameLogTableName, colCfgsGameLog),
new TableConfiguration(TableString.ServerPlugInTableName, colCfgsServerPlugIn),
new TableConfiguration(TableString.StrategyTableName, strategy),
new TableConfiguration(TableString.ScheduledTaskTableName, scheduledTask),
new TableConfiguration(TableString.UpdateServerTableName, updateServer),
new TableConfiguration(TableString.PlayerCountTableName, playerCount),
new TableConfiguration(TableString.GMOpLogTableName,gmOpLog),
new TableConfiguration(TableString.AccountInfoTableName,accountInfo),
new TableConfiguration(TableString.IbShopTableName,ibShop),
new TableConfiguration(TableString.BatchTaskTableName,batchTask),
new TableConfiguration(TableString.ServerEventTableName,serverEvent),
new TableConfiguration(TableString.ServerOperationLogTableName,serverOperationLog),
new TableConfiguration(TableString.ServerMapTableName,serverMap)
}
);
IBlazeDatabase db = DbFactory.GetDatabase();
db.InitDatabase(dbCfg, rebuild);
}
private static XElement SerializeColumns(ColumnConfiguration f)
{
return new XElement("ColumnConfiguration",
Serialization.Serialize(f, Serialization.SerializerType.Xml, null));
}
public ColumnConfiguration GetColumnConfiguration()
{
var cc = new ColumnConfiguration
{
ContainerType = "StreamView",
Title = Title,
Uuid = Uuid,
Width = Width,
Position = Position
};
cc.Mapping.Add("Filter", StreamConfiguration.Filters.Uuid);
return cc;
}
