public List <CreateSqlObject> GetCreateOracleSql(string tableSpace = null)
{
StringBuilder sb = new StringBuilder("create or replace view ");
sb.Append(view_name);
sb.AppendLine(" as");
sb.Append(text);
CreateSqlObject obj = new CreateSqlObject(sb.ToString(), "创建视图" + view_name);
return(new List <CreateSqlObject>()
{
obj
});
}
private void FrmNormalView_Load(object sender, EventArgs e)
{
IGetAttribute attri = _object as IGetAttribute;
if (attri != null)
{
this.dgvNormal.DataSource = NameAliasValue.ToDataTable(attri.GetAttributes());
}
ICreateSql creatsql = _object as ICreateSql;
if (creatsql != null)
{
CreateSqlDelegate action = MyDbHelper.GetCreateSqlFunction(creatsql, _dbClass.GetClassDbType());
if (action != null)
{
List <CreateSqlObject> csos = action(_dbClass.GetCurrentTableSpaceName());
tbSql.Text = CreateSqlObject.ToCollectionSqls(csos);
}
}
}
private void LoadSql()
{
StringBuilder sb = new StringBuilder();
sb.AppendLine(CreateSqlObject.ToCollectionSqls(MyDbHelper.GetCreateSqlFunction(_table, _dbClass.GetClassDbType())(null)));
List <IConstraintClass> ccs = _dbClass.GetConstraints(_table.TableName);
foreach (IConstraintClass item in ccs)
{
sb.AppendLine(CreateSqlObject.ToCollectionSqls(
MyDbHelper.GetCreateSqlFunction(item, _dbClass.GetClassDbType())(null)
));
}
List <IIndexClass> ics = _dbClass.GetIndexs(_table.TableName);
foreach (IIndexClass item in ics)
{
sb.AppendLine(CreateSqlObject.ToCollectionSqls(
MyDbHelper.GetCreateSqlFunction(item, _dbClass.GetClassDbType())(null)
));
}
tbSql.Text = sb.ToString().TrimEnd('\r', '\n');
}
public List <CreateSqlObject> GetCreateOracleSql(string tableSpace = null)
{
StringBuilder sb = new StringBuilder("declare job number;\r\n");
// CreateSqlObject obj1 = new CreateSqlObject(sb.ToString(), "定义事务变量");
//sb.Clear();
sb.AppendLine("begin");
sb.AppendLine(" sys.dbms_job.submit(job => job,");
sb.AppendLine(" what => '" + what + "',");
DateTime dt = (DateTime)next_date;
sb.AppendLine(" next_date => to_date('" + dt.ToString("dd-MM-yyyy ") + next_sec + "', 'dd-mm-yyyy hh24:mi:ss'),");
sb.AppendLine(" interval => '" + interval + "');");
sb.AppendLine(" commit;");
sb.AppendLine("end;");
CreateSqlObject obj2 = new CreateSqlObject(sb.ToString(), "创建事务" + job);
return(new List <CreateSqlObject>()
{
obj2
});
}
public List<CreateSqlObject> GetCreateOracleSql(string tableSpace = null)
{
StringBuilder sb = new StringBuilder("declare job number;\r\n");
// CreateSqlObject obj1 = new CreateSqlObject(sb.ToString(), "定义事务变量");
//sb.Clear();
sb.AppendLine("begin");
sb.AppendLine(" sys.dbms_job.submit(job => job,");
sb.AppendLine(" what => '" + what + "',");
DateTime dt = (DateTime)next_date;
sb.AppendLine(" next_date => to_date('" + dt.ToString("dd-MM-yyyy ") + next_sec + "', 'dd-mm-yyyy hh24:mi:ss'),");
sb.AppendLine(" interval => '" + interval + "');");
sb.AppendLine(" commit;");
sb.AppendLine("end;");
CreateSqlObject obj2 = new CreateSqlObject(sb.ToString(), "创建事务" + job);
return new List<CreateSqlObject>() { obj2 };
}
public List<CreateSqlObject> GetCreateOracleSql(string tableSpace = null)
{
StringBuilder sb = new StringBuilder("create or replace view ");
sb.Append(view_name);
sb.AppendLine(" as");
sb.Append(text);
CreateSqlObject obj = new CreateSqlObject(sb.ToString(), "创建视图" + view_name);
return new List<CreateSqlObject>() { obj };
}
