private void CreateTemplates()
{
if (IsGetNewTemplate)
{
Response.Write(GetTemplateContent(new OracleCodeBuilderLibrary.Settings().ToXml(), "Create", "TemplateExec('txtTemplate',1);"));
Response.End();
}
else
{
try
{
OracleCodeBuilderLibrary.Settings st = new OracleCodeBuilderLibrary.Settings();
st = st.FormXml(Content);
string filePath = string.Concat(OracleTemplate.GetSettingsPath(), st.ProjectName);
WorkStudioLibrary.Logging.Files.Log.Info(string.Concat("Create new template:", st.ProjectName));
if (System.IO.File.Exists(filePath))
{
JsonError(string.Concat("Project name \"", st.ProjectName, "\" was existed."));
}
else
{
System.IO.File.WriteAllText(OracleTemplate.GetSettingsPath() + st.ProjectName, st.ToXml());
JsonSuccess();
}
}
catch (Exception ex)
{
JsonError(ex.Message);
}
}
}
public string GetString1()
{
OracleCodeBuilderLibrary.Settings cf = new OracleCodeBuilderLibrary.Settings();
OracleCodeBuilderLibrary.DataObjects.doTables.uoTables tableObj = OracleCodeBuilderLibrary.BusinessObjects.boTables.GetTable(cf.ConnectionString, "USER_TAB_COMMENTS");
OracleCodeBuilderLibrary.DataObjects.doColumns.uoListColumns cs = new OracleCodeBuilderLibrary.DataObjects.doColumns.uoListColumns();
OracleCodeBuilderLibrary.DataObjects.doColumns.uoColumns c = new OracleCodeBuilderLibrary.DataObjects.doColumns.uoColumns();
doPKs.uoListPKs listPks = OracleCodeBuilderLibrary.BusinessObjects.boPks.GetPrimaryKeys(cf.ConnectionString, "spt_values");
doColumns.uoListColumns listColumns = OracleCodeBuilderLibrary.BusinessObjects.boColumns.GetColumns(cf.ConnectionString, "spt_values");
doRemarks.uoListRemarks listRemarks = OracleCodeBuilderLibrary.BusinessObjects.boRemarks.GetRemarks(cf.ConnectionString, "spt_values");
return OracleCodeBuilderLibrary.SQL.CodeScript.GetBusinessObject(cf, tableObj, listColumns, listPks);
}
public static OracleCodeBuilderLibrary.Settings GetSettingsByProjectName(string n)
{
OracleCodeBuilderLibrary.Settings s = new OracleCodeBuilderLibrary.Settings();
s = s.FormXml(System.IO.File.ReadAllText(string.Concat(GetSettingsPath(), n)));
return s;
}
private void EditTemplates()
{
if (IsGetNewTemplate)
{
try { Response.Write(GetTemplateContent(OracleTemplate.GetSettingsByProjectName(ProjectName).ToXml(), "Save", "TemplateExec('txtTemplate',2);")); }
catch (Exception ex) { Response.Write(ex.Message); }
Response.End();
}
else
{
try
{
OracleCodeBuilderLibrary.Settings st = new OracleCodeBuilderLibrary.Settings();
st = st.FormXml(Content);
string filePath = string.Concat(OracleTemplate.GetSettingsPath(), st.ProjectName);
WorkStudioLibrary.Logging.Files.Log.Info(string.Concat("Edit template:", st.ProjectName));
System.IO.File.WriteAllText(OracleTemplate.GetSettingsPath() + st.ProjectName, st.ToXml());
JsonSuccess();
}
catch (Exception ex)
{
JsonError(ex.Message);
}
}
}
