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 }; }