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