public Departments()
{
if (DbLoader.IsDepartmentsEmpty())
{
DbLoader.AddDefaultDepartments();
}
}
public async Task LoadModel(MetadataViewModelBase obj, DbEntityEnum type)
{
Root.DbLoader.Connection.InitialCatalog = obj.Model.DataBaseName;
try
{
if (Root.IsConnected)
{
if (type == DbEntityEnum.All)
{
await DbLoader.LoadChildren(obj.Model);
}
else
{
await DbLoader.LoadChildren(obj.Model, type);
}
}
}
catch (DbException d)
{
MessageBox.Show(d.Message, "Error", MessageBoxButton.OK, MessageBoxImage.Error);
}
catch (Exception e)
{
MessageBox.Show(e.Message, "Error", MessageBoxButton.OK, MessageBoxImage.Error);
}
finally
{
if (Root.IsDefaultDatabase)
{
Root.DbLoader.Connection.InitialCatalog = string.Empty;
}
}
}
public static NewBoilerplateResult Process(NewOptions options)
{
NewBoilerplateResult result = null;
//NewBoilerplateContenxt ctx = new NewBoilerplateContenxt();
//ctx.Boilerplate = options.Boilerplate;
var provider = Providers.FirstOrDefault(p => p.Name == options.Boilerplate);
if (provider != null)
{
//ctx.BoilerplatPath = DbLoader.CombinePathWithAppDirectory(@"\Boilerplats\"+ ctx.Boilerplate);
//ctx.ProjectName = options.Project;
//ctx.ProjectOutputPath = DbLoader.CombinePathWithAppDirectory(@"\generate\" + ctx.ProjectName);
//result = provider.Process(ctx);
string config = DbLoader.CombinePathWithAppDirectory(@"Boilerplats\" + options.Boilerplate + @"\config.xml");
NewBoilerplateManage.DoGen(config, options.Project, options.NameSpace, options.PrefixFilter, options.OnlyGenTable);
string genDir = DbLoader.CombinePathWithAppDirectory(@"generate\" + options.Boilerplate);
LogStatic("Starting copy resource to generate directory ......");
LogStatic("Generate directory : " + genDir);
string resourceDir = DbLoader.CombinePathWithAppDirectory(@"Boilerplats\" + options.Boilerplate + @"\resource");
var dirs = Directory.GetDirectories(resourceDir, "*", SearchOption.TopDirectoryOnly);
CurrentGenerateContext.ProjectName = options.Project;
foreach (var dir in dirs)
{
var dirInfo = new DirectoryInfo(dir);
var dirname = dirInfo.Name;// Path.GetDirectoryName(dir);
string realDirName = FormatSimpleTemplate(dirname);
string toDir = Path.Combine(genDir, realDirName);
LogStatic("Copy directory resource " + dirname + " to " + toDir);
CopyDirectory(dir, toDir);
LogStatic("Finish copy directory.");
}
LogStatic("Finish copy resource to generate directory !");
}
else
{
LogStatic("Not find Boilerplate [" + options.Boilerplate + "] !", null, MessageType.Error);
}
return(result);
}
IEnumerator WaitForStats()
{
string username = GameObject.Find("GameController").GetComponent <GameController>().selectedProfile;
DbLoader db = GameObject.Find("DbLoader").GetComponent <DbLoader>();
yield return(db.GetUserScore(username));
yield return(db.GetUserDeath(username));
yield return(db.GetUserLabdone(username));
statsScore.text = db.score.ToString();
statsDeath.text = db.death.ToString();
statsLabdone.text = db.labdone.ToString();
}
void OnInitialize()
{
LuaManager.InitStart();
LuaBehaviour.initialize = true;
LuaManager.DoFile("Main"); //加载游戏
//LuaManager.DoFile("Logic/Network"); //加载网络
//NetManager.OnInit(); //初始化网络
Util.CallMethod("Main", "main"); //初始化完成
// 初始化数据db
DbLoader.init();
// 初始化mgr
gameObject.AddComponent <MgrScene>();
gameObject.AddComponent <MgrPanel>();
gameObject.AddComponent <MgrTimer>();
}
// Use this for initialization
IEnumerator Start()
{
newUserBtn.onClick.AddListener(delegate { StartCoroutine(NewUserBtnClicked()); });
db = GameObject.Find("DbLoader").GetComponent <DbLoader>();
yield return(db.GetAllUsers());
foreach (string item in db.userList)
{
int btnIndex = nbrButton;
GameObject button;
button = Instantiate(profileBtnPrefab, GameObject.Find("ProfileListContent").transform);
button.transform.GetChild(0).GetComponent <Text>().text = item;
button.GetComponent <Button>().onClick.AddListener(delegate { ButtonClicked(btnIndex); });
btnList.Add(button);
nbrButton++;
}
}
public Engine(INetworkServer server,
IPolicyServer policyServer,
TServer thriftServer,
DbLoader dbLoader,
IPlayerSelectorFactory playerSelector,
IPlayersRemoverFactory playersRemoverFactory,
IStrongholdManager strongholdManager,
IBarbarianTribeManager barbarianTribeManager,
IWorld world,
SystemVariablesUpdater systemVariablesUpdater,
IScheduler scheduler,
IDbManager dbManager,
StrongholdActivationChecker strongholdActivationChecker,
StrongholdChecker strongholdChecker,
BarbarianTribeChecker barbarianTribeChecker,
ICityChannel cityChannel,
IStrongholdManagerLogger strongholdManagerLogger,
StoreSync storeSync,
IQueueListener queueListener,
MapDataExport mapDataExport)
{
this.server = server;
this.policyServer = policyServer;
this.thriftServer = thriftServer;
this.dbLoader = dbLoader;
this.playerSelector = playerSelector;
this.playersRemoverFactory = playersRemoverFactory;
this.strongholdManager = strongholdManager;
this.barbarianTribeManager = barbarianTribeManager;
this.world = world;
this.systemVariablesUpdater = systemVariablesUpdater;
this.scheduler = scheduler;
this.dbManager = dbManager;
this.strongholdActivationChecker = strongholdActivationChecker;
this.strongholdChecker = strongholdChecker;
this.barbarianTribeChecker = barbarianTribeChecker;
this.cityChannel = cityChannel;
this.strongholdManagerLogger = strongholdManagerLogger;
this.storeSync = storeSync;
this.queueListener = queueListener;
this.mapDataExport = mapDataExport;
}
public IEnumerator Win()
{
Debug.Log("Win!");
Cursor.visible = true;
Cursor.lockState = CursorLockMode.None;
DbLoader db = GameObject.Find("DbLoader").GetComponent <DbLoader>();
yield return(db.GetUserScore(selectedProfile));
yield return(db.GetUserLabdone(selectedProfile));
yield return(db.UpdateScore(selectedProfile, db.score + 100));
yield return(db.UpdateLabDone(selectedProfile, db.labdone + 1));
menuInstance.ShowMenu();
menuInstance.DisplayWin();
Destroy(labyrinthInstance.gameObject);
foreach (Transform child in GameObject.Find("LabyrinthObjects").transform)
{
Destroy(child.gameObject);
}
}
public static string Process(DocOptions options)
{
string result = "";
try
{
var config = ConfigHelpers.GetDefaultConfig(options.Config);
IDatabase database = new Database(config, LogHelpers.LogStatic, option => {
//option.CodeGenProjectName = projectName;
//option.CodeGenNameSpace = nameSpace;
//option.CodeGenTableFilter = tablePrefixFilter;
//option.AutoMigrateOnContainTable = onlyTable;
});
string type = options.Type;
var projectConfig = DbLoader.ConvertDatabaseConfigToProjectConfig(database);
LogHelpers.LogStatic(projectConfig.ToString());
string msg = "";
var tables = DbLoader.GetTableInfos(database, projectConfig, null, null, out msg);
LogHelpers.LogStatic(msg);
string docName = projectConfig.DatabaseName;
OutputContext _OutputContext = new OutputContext();
_OutputContext.Tables = tables;
// context.Mappers = mapperDict;
_OutputContext.ProjectConfig = projectConfig;
//context.ParserConfig = _parseConfig;
string FileName = docName + "数据库设计文档." + type;
string RealOutputFileName = System.IO.Path.Combine(DbLoader.GetProjectDirectory(projectConfig), FileName);
if (type == "html")
{
string templatePath = DbLoader.MapPath("~/DocGen/dicthtml.cshtml");
if (System.IO.File.Exists(templatePath))
{
string tempalteContent = FileHelper.ReadFile(templatePath);
string key = "exportdicthtml";
var templateEngine = DbLoader.CreateTemplateEngine();
var generateResult = templateEngine.Parse <OutputContext>(tempalteContent, key, _OutputContext);
string content = generateResult;
templateEngine.OutputResult(RealOutputFileName, content);
//return File(RealOutputFileName, "application/zip-x-compressed", FileName);
}
}
else
{
//Other types
string tmppath = DbLoader.MapPath("~/DocGen/dict.dot"); // System.IO.Path.Combine(path, "Template", "template.dot");
Aspose.Words.Document doc = new Aspose.Words.Document(tmppath); //载入模板
Aspose.Words.DocumentBuilder builder = new Aspose.Words.DocumentBuilder(doc);
string dbName = docName;
if (string.IsNullOrEmpty(dbName))
{
dbName = _OutputContext.ProjectConfig.Name;
}
doc.Range.Replace("{$.DBName}", dbName, false, false);
Aspose.Words.Tables.Table tabletemp = (Aspose.Words.Tables.Table)doc.GetChild(Aspose.Words.NodeType.Table, 0, true);
Aspose.Words.Tables.Table tableClone = (Aspose.Words.Tables.Table)tabletemp.Clone(true);
for (int k = 0; k < _OutputContext.Tables.Count; k++)
{
Aspose.Words.Tables.Table table = (Aspose.Words.Tables.Table)doc.GetChild(Aspose.Words.NodeType.Table, k, true);
var tb = _OutputContext.Tables[k];
//添加表头标题
var par = table.ParentNode.InsertBefore(new Aspose.Words.Paragraph(doc), table);
builder.MoveTo(par);
builder.ParagraphFormat.StyleIdentifier = Aspose.Words.StyleIdentifier.Heading1;
builder.Font.Size = 11;
builder.Write(tb.Comment + "(" + tb.Name + ")");
Aspose.Words.Tables.Cell cellh = table.FirstRow.Cells[1];
cellh.RemoveAllChildren();
builder.MoveToCell(k, 0, 1, 0);
builder.Write(tb.Name);
Aspose.Words.Tables.Cell cellh3 = table.FirstRow.Cells[3];
cellh3.RemoveAllChildren();
builder.MoveToCell(k, 0, 3, 0);
builder.Write(tb.Comment != null ? tb.Comment : "");
for (int i = 0; i < tb.Columns.Count; i++)
{
for (int j = 0; j < table.LastRow.Cells.Count; j++)
{
Aspose.Words.Tables.Cell cell = table.LastRow.Cells[j];
cell.RemoveAllChildren();
builder.MoveToCell(k, table.Rows.Count - 1, j, 0);
switch (j)
{
case 0:
builder.Write(tb.Columns[i].Comment != null ? tb.Columns[i].Comment : "");
break;
case 1:
builder.Write(tb.Columns[i].Name);
break;
case 2:
builder.Write(tb.Columns[i].RawType);
break;
case 3:
builder.Write(tb.Columns[i].Length.ToString());
break;
case 4:
builder.Write(tb.Columns[i].Scale.ToString());
break;
case 5:
builder.Write(tb.Columns[i].IsPK ? "Y" : "");
break;
case 6:
builder.Write(tb.Columns[i].IsNullable ? "Y" : "");
break;
case 7:
builder.Write(tb.Columns[i].IsAutoIncrement ? "Y" : "");
break;
case 8:
builder.Write(tb.Columns[i].DefaultValue == null ? "" : tb.Columns[i].DefaultValue.ToString());
break;
default:
break;
}
}
if (i < tb.Columns.Count - 1)
{
Aspose.Words.Tables.Row clonedRow = (Aspose.Words.Tables.Row)table.LastRow.Clone(true);
table.AppendChild(clonedRow);
}
}
if (k < _OutputContext.Tables.Count - 1)
{
Aspose.Words.Tables.Table tbClone = (Aspose.Words.Tables.Table)tableClone.Clone(true);
table.ParentNode.InsertAfter(tbClone, table);
}
}
doc.UpdateFields();
doc.Range.Replace("{$.NowDateTime}", DateTime.Now.ToString(), false, false);
Aspose.Words.SaveFormat sformat = Aspose.Words.SaveFormat.Doc;
switch (type)
{
case "doc":
sformat = Aspose.Words.SaveFormat.Doc;
break;
case "docx":
sformat = Aspose.Words.SaveFormat.Docx;
break;
//case "html":
// sformat = Aspose.Words.SaveFormat.Html;
// break;
case "odt":
sformat = Aspose.Words.SaveFormat.Odt;
break;
case "pdf":
sformat = Aspose.Words.SaveFormat.Pdf;
break;
case "png":
sformat = Aspose.Words.SaveFormat.Png;
break;
case "tiff":
sformat = Aspose.Words.SaveFormat.Tiff;
break;
case "text":
sformat = Aspose.Words.SaveFormat.Text;
break;
case "epub":
sformat = Aspose.Words.SaveFormat.Epub;
break;
default:
break;
}
doc.Save(RealOutputFileName, sformat);
//return File(RealOutputFileName, "application/zip-x-compressed", FileName);
}
if (options.Zip)
{
var zipDir = RealOutputFileName;
string zipedName = docName + "-" + System.DateTime.Now.ToString("yyyyMMddHHmmss") + ".zip";
string zipOutFileName = System.IO.Path.Combine(DbLoader.GetDataDirectory(), zipedName);
//ZipHelper.ZipDir(zipDir, zipOutFileName, 9);
//ZipHelper.ZipManyFilesOrDictorys(zipDir, zipOutFileName, "");
ZipHelper.ZipFile(zipDir, zipOutFileName);
RealOutputFileName = zipOutFileName;
}
LogHelpers.LogStatic("生成数据库字典成功：" + RealOutputFileName);
ConfigHelpers.OpenDir(RealOutputFileName);
}
catch (Exception ex)
{
LogHelpers.LogStatic("DocGenerator 生成数据库字典出错！", ex, Pure.Data.MessageType.Error);
}
return(result);
}
