public CreateDataSqlParams GetCreateOracleSql()
{
if (_tableDataRow == null)
{
return(null);
}
StringBuilder t1 = new StringBuilder();
StringBuilder t2 = new StringBuilder();
OracleParameter[] parms = new OracleParameter[_tableDataRow.tableColumnNames.Length];
for (int i = 0; i < _tableDataRow.tableColumnNames.Length; i++)
{
Type dataType = _tableDataRow.tableColumnTypes[i];
string culn = OracleTableClass.GetOracleColumnName(_tableDataRow.tableColumnNames[i]);
t1.Append(culn + ",");
t2.Append(":" + culn + ",");
parms[i] = new OracleParameter(":" + culn, _tableDataRow.TableValues[i]);
}
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into " + _tableDataRow.tableName + "(");
strSql.Append(t1.ToString().TrimEnd(','));
strSql.Append(")");
strSql.Append(" values (");
strSql.Append(t2.ToString().TrimEnd(','));
strSql.Append(")");
CreateDataSqlParams sqlp = new CreateDataSqlParams();
sqlp.sql = strSql.ToString();
sqlp.sql_params = parms;
return(sqlp);
}
public CreateDataSqlParams GetCreateOracleSql()
{
if (_tableDataRow == null)
{
return null;
}
StringBuilder t1 = new StringBuilder();
StringBuilder t2 = new StringBuilder();
OracleParameter[] parms = new OracleParameter[_tableDataRow.tableColumnNames.Length];
for (int i = 0; i < _tableDataRow.tableColumnNames.Length; i++)
{
Type dataType = _tableDataRow.tableColumnTypes[i];
string culn = OracleTableClass.GetOracleColumnName(_tableDataRow.tableColumnNames[i]);
t1.Append(culn + ",");
t2.Append(":" + culn + ",");
parms[i] = new OracleParameter(":" + culn, _tableDataRow.TableValues[i]);
}
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into " + _tableDataRow.tableName + "(");
strSql.Append(t1.ToString().TrimEnd(','));
strSql.Append(")");
strSql.Append(" values (");
strSql.Append(t2.ToString().TrimEnd(','));
strSql.Append(")");
CreateDataSqlParams sqlp = new CreateDataSqlParams();
sqlp.sql = strSql.ToString();
sqlp.sql_params = parms;
return sqlp;
}
public void ReadToDb(IDbClass dbClass, ReadToDbExceptionHandle exceptionHandle = null,
bool isReadTables = true,
bool isReadConstraints = true,
bool isReadSequences = true,
bool isReadTriggers = true,
bool isReadIndexes = true,
bool isReadFunctions = true,
bool isReadProcedures = true,
bool isReadJavaSources = true,
bool isReadDatas = true)
{
int process_start = 0;
int process_end = 3;
#region 配置文件打开预加载
SetPro(process_start, "开始导入数据库文件...");
if (_dbtFile == null)
{
SetPro(100, "数据库配置不正确！");
return;
}
process_start = 1;
SetPro(process_start, "数据库配置：" + _dbtFile.ToString());
if (_dbDefine == null)
{
SetPro(process_start, "开始读取数据库文件定义...");
ReadDbDefinition();
}
process_start = 2;
SetPro(process_start);
if (_dbDefine == null)
{
SetPro(100, "数据库文件定义不正确！");
return;
}
#endregion
SetPro(process_end, "读取到数据库定义:" + _dbDefine.ToString());
process_start = process_end;
process_end = 4;
#region 获取当前表空间
SetPro(process_start, "开始获取当前表空间...");
string tableSpaceName = null;
try
{
tableSpaceName = dbClass.GetCurrentTableSpaceName();
}
catch (Exception ex)
{
if (!DoProToDbException("读取表空间异常", exceptionHandle, ex))
{
return;
}
}
SetPro(process_end, "获取到当前表空间:" + tableSpaceName);
#endregion
SetPro(process_end);
process_start = process_end;
process_end = 20;
#region 导入表
if (isReadTables)
{
SetPro(process_start, "待导入表的数目:" + _dbDefine.Tables.Count);
if (_dbDefine.Tables.Count > 0)
{
SetPro(process_start, "开始导入表定义...");
float dd = (process_end - process_start) / (float)_dbDefine.Tables.Count;
int dtcount = 0;
foreach (ITableClass item in _dbDefine.Tables)
{
dtcount++;
int pro = process_start + (int)(dtcount * dd);
SetPro(pro, "开始导入表:" + item.TableName);
CreateSqlDelegate action = MyDbHelper.GetCreateSqlFunction(item, dbClass.GetClassDbType());
List <CreateSqlObject> sqlObjs = action(tableSpaceName);
foreach (CreateSqlObject sql in sqlObjs)
{
try
{
dbClass.GetDbHelper().ExecuteSql(sql.sql);
}
catch (System.Exception ex)
{
if (!DoProToDbException("导入表错误", exceptionHandle, ex, "执行的SQL:" + sql.sql))
{
return;
}
}
}
}
}
}
#endregion
SetPro(process_end);
process_start = process_end;
process_end = 60;
#region 导入数据
if (isReadDatas)
{
DbData data = this.GetNextDataRow();
int tablesCount = _dbDefine.Tables.Count == 0 ? 1 : _dbDefine.Tables.Count;
float dd = (process_end - process_start) / (float)tablesCount;
int dtcount = 0;
if (data != null)
{
SetPro(20, "开始导入数据...");
int count = -1;
string tablename = null;
while (data != null)
{
if (count == -1)
{
int add = (int)(dtcount * dd);
if (add > process_end)
{
add = process_end;
}
dtcount++;
tablename = data.TableDataRow.tableName;
SetPro(process_start + add, "开始导入表：" + tablename + " 的数据...待导入数目:" + curTableDataCount);
count = 0;
}
else if (data.TableDataRow.tableName != tablename)
{
int add = (int)(dtcount * dd);
if (add > process_end)
{
add = process_end;
}
SetPro(process_start + add, "导入表：" + tablename + " 的数据个数为：" + count);
tablename = data.TableDataRow.tableName;
SetPro(process_start + add, "开始导入表：" + tablename + " 的数据...待导入数目:" + curTableDataCount);
count = 0;
dtcount++;
}
CreateDataSqlDelegate action = MyDbHelper.GetCreateSqlFunction(data, dbClass.GetClassDbType());
CreateDataSqlParams sqlpram = action();
try
{
dbClass.GetDbHelper().ExecuteSql(sqlpram.sql, sqlpram.sql_params);
}
catch (Exception ex)
{
if (!DoProToDbException("导入数据错误", exceptionHandle, ex, "执行的SQL:" + sqlpram.sql + "\r\n数据：" + Newtonsoft.Json.JsonConvert.SerializeObject(data.TableDataRow.base64TableValues)))
{
return;
}
}
count++;
data = this.GetNextDataRow();
}
SetPro(process_end, "导入表：" + tablename + " 的数据个数为：" + count);
SetPro(process_end, "导入数据结束.");
}
}
#endregion
SetPro(process_end);
process_start = process_end;
process_end = 70;
#region 导入索引
if (isReadIndexes)
{
SetPro(process_start, "待导入索引个数：" + _dbDefine.Indexes.Count);
if (_dbDefine.Indexes.Count > 0)
{
SetPro(process_start, "开始导入索引...");
float dd = (process_end - process_start) / (float)_dbDefine.Indexes.Count;
int dtcount = 0;
foreach (IIndexClass item in _dbDefine.Indexes)
{
dtcount++;
SetPro(process_start + (int)(dtcount * dd), "开始导入表:" + item.Table_Name + " 的索引:" + item.Name);
CreateSqlDelegate action = MyDbHelper.GetCreateSqlFunction(item, dbClass.GetClassDbType());
List <CreateSqlObject> sqlObjs = action(tableSpaceName);
foreach (CreateSqlObject sql in sqlObjs)
{
try
{
dbClass.GetDbHelper().ExecuteSql(sql.sql);
}
catch (System.Exception ex)
{
if (!DoProToDbException("导入索引错误", exceptionHandle, ex, "执行的SQL:" + sql.sql))
{
return;
}
}
}
}
SetPro(process_end, "导入索引结束.");
}
}
#endregion
SetPro(process_end);
process_start = process_end;
process_end = 80;
#region 导入约束
if (isReadConstraints)
{
SetPro(process_start, "待导入表的约束个数：" + _dbDefine.Constraints.Count);
if (_dbDefine.Constraints.Count > 0)
{
SetPro(process_start, "开始导入表约束...");
float dd = (process_end - process_start) / (float)_dbDefine.Constraints.Count;
int dtcount = 0;
IOrderedEnumerable <IConstraintClass> ordered = _dbDefine.Constraints.OrderBy(m => m.Level);
foreach (IConstraintClass item in ordered)
{
dtcount++;
int pro = process_start + (int)(dtcount * dd);
SetPro(pro, "开始导入表:" + item.Table_Name + " 的约束:" + item.Name);
CreateSqlDelegate action = MyDbHelper.GetCreateSqlFunction(item, dbClass.GetClassDbType());
List <CreateSqlObject> sqlObjs = action(tableSpaceName);
foreach (CreateSqlObject sql in sqlObjs)
{
try
{
dbClass.GetDbHelper().ExecuteSql(sql.sql);
}
catch (System.Exception ex)
{
if (!DoProToDbException("导入约束错误", exceptionHandle, ex, "执行的SQL:" + sql.sql))
{
return;
}
}
}
}
SetPro(process_end, "导入约束结束.");
}
}
#endregion
SetPro(process_end);
process_start = process_end;
process_end = 85;
#region 导入序列
if (isReadSequences)
{
SetPro(process_start, "待导入序列个数：" + _dbDefine.Sequences.Count);
if (_dbDefine.Sequences.Count > 0)
{
SetPro(process_start, "开始导入序列...");
float dd = (process_end - process_start) / (float)_dbDefine.Sequences.Count;
int dtcount = 0;
foreach (ISequenceClass item in _dbDefine.Sequences)
{
dtcount++;
SetPro(process_start + (int)(dtcount * dd), "开始导入序列:" + item.SequenceName);
CreateSqlDelegate action = MyDbHelper.GetCreateSqlFunction(item, dbClass.GetClassDbType());
List <CreateSqlObject> sqlObjs = action(tableSpaceName);
foreach (CreateSqlObject sql in sqlObjs)
{
try
{
dbClass.GetDbHelper().ExecuteSql(sql.sql);
}
catch (Exception ex)
{
if (!DoProToDbException("导入序列错误", exceptionHandle, ex, "执行的SQL:" + sql.sql))
{
return;
}
}
}
}
SetPro(process_end, "导入序列结束.");
}
}
#endregion
SetPro(process_end);
process_start = process_end;
process_end = 90;
#region 导入触发器
if (isReadTriggers)
{
SetPro(process_start, "待导入触发器个数：" + _dbDefine.Triggers.Count);
if (_dbDefine.Triggers.Count > 0)
{
float dd = (process_end - process_start) / (float)_dbDefine.Triggers.Count;
int dtcount = 0;
SetPro(80, "开始导入触发器...");
foreach (ITriggerClass item in _dbDefine.Triggers)
{
dtcount++;
SetPro(process_start + (int)(dtcount * dd), "开始导入表:" + item.Table_Name + " 的触发器:" + item.Name);
CreateSqlDelegate action = MyDbHelper.GetCreateSqlFunction(item, dbClass.GetClassDbType());
List <CreateSqlObject> sqlObjs = action(tableSpaceName);
foreach (CreateSqlObject sql in sqlObjs)
{
try
{
dbClass.GetDbHelper().ExecuteSql(sql.sql);
}
catch (System.Exception ex)
{
if (!DoProToDbException("导入触发器错误", exceptionHandle, ex, "执行的SQL:" + sql.sql))
{
return;
}
}
}
}
}
SetPro(process_end, "导入触发器结束.");
}
#endregion
SetPro(process_end);
process_start = process_end;
process_end = 95;
#region 导入过程
if (isReadProcedures)
{
SetPro(process_start, "待导入存储过程个数：" + _dbDefine.Procedures.Count);
if (_dbDefine.Procedures.Count > 0)
{
float dd = (process_end - process_start) / (float)_dbDefine.Procedures.Count;
int dtcount = 0;
SetPro(process_start, "开始导入存储过程...");
foreach (IProcedureClass item in _dbDefine.Procedures)
{
dtcount++;
SetPro(process_start + (int)(dtcount * dd), "开始导入存储过程:" + item.Name);
CreateSqlDelegate action = MyDbHelper.GetCreateSqlFunction(item, dbClass.GetClassDbType());
List <CreateSqlObject> sqlObjs = action(tableSpaceName);
foreach (CreateSqlObject sql in sqlObjs)
{
try
{
dbClass.GetDbHelper().ExecuteSql(sql.sql);
}
catch (System.Exception ex)
{
if (!DoProToDbException("导入存储过程错误", exceptionHandle, ex, "执行的SQL:" + sql.sql))
{
return;
}
}
}
}
SetPro(process_end, "导入过程结束.");
}
}
#endregion
SetPro(process_end);
process_start = process_end;
process_end = 97;
#region 导入函数
if (isReadFunctions)
{
SetPro(process_start, "待导入函数个数：" + _dbDefine.Functions.Count);
if (_dbDefine.Functions.Count > 0)
{
float dd = (process_end - process_start) / (float)_dbDefine.Functions.Count;
int dtcount = 0;
SetPro(process_start, "开始导入函数...");
foreach (IFunctionClass item in _dbDefine.Functions)
{
dtcount++;
SetPro(process_start + (int)(dtcount * dd), "开始导入函数:" + item.Name);
CreateSqlDelegate action = MyDbHelper.GetCreateSqlFunction(item, dbClass.GetClassDbType());
List <CreateSqlObject> sqlObjs = action(tableSpaceName);
foreach (CreateSqlObject sql in sqlObjs)
{
try
{
dbClass.GetDbHelper().ExecuteSql(sql.sql);
}
catch (System.Exception ex)
{
if (!DoProToDbException("导入函数错误", exceptionHandle, ex, "执行的SQL:" + sql.sql))
{
return;
}
}
}
}
SetPro(process_end, "导入函数结束.");
}
}
#endregion
SetPro(process_end);
process_start = process_end;
process_end = 100;
#region 导入java资源
if (isReadJavaSources)
{
SetPro(process_start, "待导入Java资源个数：" + _dbDefine.JavaSources.Count);
if (_dbDefine.JavaSources.Count > 0)
{
float dd = (process_end - process_start) / (float)_dbDefine.JavaSources.Count;
int dtcount = 0;
SetPro(95, "开始导入Java资源...");
foreach (IJavaSourceClass item in _dbDefine.JavaSources)
{
dtcount++;
SetPro(95 + (int)(dtcount * dd), "开始导入java资源:" + item.Name);
CreateSqlDelegate action = MyDbHelper.GetCreateSqlFunction(item, dbClass.GetClassDbType());
List <CreateSqlObject> sqlObjs = action(tableSpaceName);
foreach (CreateSqlObject sql in sqlObjs)
{
try
{
dbClass.GetDbHelper().ExecuteSql(sql.sql);
}
catch (System.Exception ex)
{
if (!DoProToDbException("导入Java资源错误", exceptionHandle, ex, "执行的SQL:" + sql.sql))
{
return;
}
}
}
}
SetPro(process_end, "导入Java资源结束.");
}
}
#endregion
SetPro(process_end, "导入结束.");
}