예제 #1
0
        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);
        }
예제 #2
0
        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);
        }