public string Excel2Oracle(XSSFSheet sheet, string tableName, int cot, ref string comment, ref string primaryKey)
{
var str = "";
var primarykey = "";
for (int i = 0; i <= cot; i++)
{
excel sFC = new excel();
sFC.name = sheet.GetRow(i).GetCell(1) == null ? "" : sheet.GetRow(i).GetCell(1).ToString();
if (string.IsNullOrEmpty(sFC.name))
{
cot -= 1;
str = str.Remove(str.Length - 3, 2);
continue;
}
str += (sFC.name + " ");
sFC.desc = sheet.GetRow(i).GetCell(2) == null ? "" : sheet.GetRow(i).GetCell(2).ToString();
sFC.type = sheet.GetRow(i).GetCell(3) == null ? "" : sheet.GetRow(i).GetCell(3).ToString();
str += sFC.type;
sFC.isNull = sheet.GetRow(i).GetCell(5) == null ? "" : sheet.GetRow(i).GetCell(5).ToString();
var length = sheet.GetRow(i).GetCell(4) == null ? null : sheet.GetRow(i).GetCell(4).ToString();
sFC.defaultContext = sheet.GetRow(i).GetCell(6) == null ? "" : sheet.GetRow(i).GetCell(6).ToString();
if (sFC.type.ToLower() != "date" && !string.IsNullOrEmpty(length))
{
sFC.length = Convert.ToInt32(length);
str += $"({sFC.length}) ";
}
if (sFC.defaultContext.Length != 0)
{
str += (" DEFAULT " + sFC.defaultContext + " ");
}
if (sFC.name == "ID")
{
primarykey = sheet.GetRow(i).GetCell(7) == null ? "" : sheet.GetRow(i).GetCell(7).ToString();
primaryKey = primarykey;
}
if (sFC.isNull.Length != 0)
{
str += (" NOT NULL ");
}
if (i != cot)
{
str += " ,\n";
}
comment += $"COMMENT ON COLUMN {tableName}.{sFC.name} IS '{sFC.desc}';\r\n";
}
//str += $"CONSTRAINT {primarykey} PRIMARY KEY ( id ) ENABLE\n";
return(str);
}
public string Excel2MysqlMssql(XSSFSheet sheet, int cot, int dbType)
{
var str = "";
for (int i = 1; i <= cot; i++)
{
excel sFC = new excel();
sFC.name = sheet.GetRow(i).GetCell(0) == null ? "" : sheet.GetRow(i).GetCell(0).ToString();
if (sFC.name.Length == 0 || sFC.name == "" || sFC.name == null)
{
cot -= 1;
str = str.Remove(str.Length - 3, 2);
continue;
}
str += (sFC.name + " ");
sFC.desc = sheet.GetRow(i).GetCell(1) == null ? "" : sheet.GetRow(i).GetCell(1).ToString();
sFC.type = sheet.GetRow(i).GetCell(2) == null ? "" : sheet.GetRow(i).GetCell(2).ToString();
str += (sFC.type + " ");
sFC.isNull = sheet.GetRow(i).GetCell(3) == null ? "" : sheet.GetRow(i).GetCell(3).ToString();
sFC.defaultContext = sheet.GetRow(i).GetCell(4) == null ? "" : sheet.GetRow(i).GetCell(4).ToString();
if (sFC.isNull.Length != 0)
{
str += ("NOT NULL ");
}
else
{
str += (" NULL ");
}
if (sFC.defaultContext.Length != 0)
{
str += ("DEFAULT " + sFC.defaultContext + " ");
}
if (sFC.name == "ID")
{
str += "primary key ";
}
if (dbType != 2)
{
str += ("COMMENT '" + sFC.desc + "' ");
}
if (i != cot)
{
str += " ,\n";
}
}
return(str);
}