form1.cs

c#开发的批量图片入库oracle的程序

                                        ada.Update(dsJAVA, tableName);

                                        dsJAVA.Clear();
                                    }

                                    index++;
                                    pgbInput.Value = (int)(index / filesSum);

                                }

                                ///////////////////////////////////////////////////////////////////////////////////////////////


                            }
                        }


                    }
                    partitionNumber++;
                }
                //txtRowId.Text = (Environment.TickCount - timeOut) / 1000 + "秒";
            }
            // txtRowId.Text = (Environment.TickCount - timeOut) / 1000 / 60 + "分";
        }

*/
        private void 入库ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            //ThreadPool.QueueUserWorkItem(new WaitCallback(ThreadProc));
            //Thread.Sleep(1000);

           timeOut = Environment.TickCount;
            if (fbdFindData.ShowDialog() == DialogResult.OK)
            {
                lastLocation = fbdFindData.SelectedPath.LastIndexOf("\\");
                TABLE2 = fbdFindData.SelectedPath.ToUpper().Substring(lastLocation + 1);
            foreach (string ChildDirectory in Directory.GetDirectories(fbdFindData.SelectedPath))
            //foreach (string ChildDirectory in Directory.GetDirectories("D:\\beijing"))
            {
                lastLocation = ChildDirectory.LastIndexOf("\\");
                tableName = TABLE2 + ChildDirectory.Substring(lastLocation + 1);

                ///////////////////////////////////////////////////////////////////////////////////////////////
                //strSql = "SELECT * from ";
                //strSql = strSql + tableName + " WHERE ID = -1";
                //ada = new OracleDataAdapter(strSql, cn);
                //dsJAVA = new DataSet("JAVA");
                //ada.Fill(dsJAVA, tableName);
                //dtTemp = dsJAVA.Tables[tableName];

                ///////////////////////////////////////////////////////////////////////////////////////////////
                foreach (string ChildDirectoryNext in Directory.GetDirectories(ChildDirectory))
                {

                    lastLocation = ChildDirectoryNext.LastIndexOf("\\");
                    Array.Resize(ref partitionName, partitionName.Length + 1);
                    partitionName[partitionNumber] = ChildDirectoryNext.Substring(lastLocation + 1);

                    DirectoryInfo di = new DirectoryInfo(ChildDirectoryNext);
                    if (di.GetFiles().Length != 0)
                    {
                        int i = 0;
                        foreach (FileInfo fi in di.GetFiles())
                        {
                            i++;
                            extendLocation = fi.Name.LastIndexOf(".");
                            lastLocation = fi.Name.LastIndexOf("_");
                            if (lastLocation != -1)
                            {
                                fnNumber = "1" + fi.Name.Substring(0, lastLocation) + fi.Name.Substring(lastLocation + 1, extendLocation - lastLocation - 1);
                                id = Convert.ToInt64(fnNumber);
                                //maxLength = di.GetFiles().Length + id - 1;

                                ///////////////////////////////////////////////////////////////////////////////////////////////
                                //drCurrent = dtTemp.NewRow();
                                //drCurrent["ID"] = id;
                                //drCurrent["NAME"] = fi.Name.Substring(0, fi.Name.Length);
                                //drCurrent["SHAPE"] = Rtf(fi.FullName);
                                //dtTemp.Rows.Add(drCurrent);
                                //drCurrent = dtTemp.NewRow();

                              　if ((i == di.GetFiles().Length||i == di.GetFiles().Length - 1) && Math.IEEERemainder(i, 10) != 0)
                                {
                                    //objCommandBuilder = new OracleCommandBuilder(ada);
                                    //ada.Update(dsJAVA, tableName);

                                    //dsJAVA.Clear();
                                }
                                else if (Math.IEEERemainder(i, 10) == 0)
                                {
                                    
                                    //objCommandBuilder = new OracleCommandBuilder(ada);
                                    //ada.Update(dsJAVA, tableName);

                                    //dsJAVA.Clear();
                                }

                                //objCommandBuilder = new OracleCommandBuilder(ada);
                                //ada.Update(dsJAVA, tableName);

                                //dsJAVA.Clear();


                                index++;
                                pgbInput.Value = (int)((index*100/2125));
                                Thread.Sleep(10);
                            }

                            ///////////////////////////////////////////////////////////////////////////////////////////////


                        }
                    }


                }
                partitionNumber++;
            }
            txtTimeOut.Text = (Environment.TickCount - timeOut) / 1000 + "秒";
            }
            txtTimeOut.Text = (Environment.TickCount - timeOut) / 1000 / 60 + "分";

        }

        private void 创建表空间ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            string createTableSpace = "CREATE TABLESPACE " + TableSpace 
   + " LOGGING" 
   + " DATAFILE"+ " '" + TablePath + TableName + "'" + " SIZE 5M"
   + " AUTOEXTEND"
   + " ON NEXT  100M MAXSIZE  2048M EXTENT MANAGEMENT LOCAL SEGMENT" 
   + " SPACE MANAGEMENT  AUTO";
            OracleCommand command = new OracleCommand(createTableSpace, cn);
            command.ExecuteNonQuery();

        }

        private void 增加数据文件ToolStripMenuItem_Click(object sender, EventArgs e)
        {

            string addDataFile = "ALTER TABLESPACE TABSPACE ADD DATAFILE 'E:\\ORACLE\\ORADATA\\GLOBE\\TABSPACE1.ora'  SIZE  5M  AUTOEXTEND ON NEXT  100M MAXSIZE  2048M";
            OracleCommand command = new OracleCommand(addDataFile, cn);
            command.ExecuteNonQuery();

        }

        private void toolStripMenuItem2_Click(object sender, EventArgs e)
        {
            string addDataFile = "ALTER TABLESPACE TABSPACE ADD DATAFILE 'E:\\ORACLE\\ORADATA\\GLOBE\\TABSPACE2.ora'  SIZE  5M  AUTOEXTEND ON NEXT  100M MAXSIZE  2048M";
            OracleCommand command = new OracleCommand(addDataFile, cn);
            command.ExecuteNonQuery();
        }

        private void toolStripMenuItem3_Click(object sender, EventArgs e)
        {
            string addDataFile = "ALTER TABLESPACE TABSPACE ADD DATAFILE 'E:\\ORACLE\\ORADATA\\GLOBE\\TABSPACE3.ora'  SIZE  5M  AUTOEXTEND ON NEXT  100M MAXSIZE  2048M";
            OracleCommand command = new OracleCommand(addDataFile, cn);
            command.ExecuteNonQuery();
        }

        private void toolStripMenuItem4_Click(object sender, EventArgs e)
        {
            string addDataFile = "ALTER TABLESPACE TABSPACE ADD DATAFILE 'E:\\ORACLE\\ORADATA\\GLOBE\\TABSPACE4.ora'  SIZE  5M  AUTOEXTEND ON NEXT  100M MAXSIZE  2048M";
            OracleCommand command = new OracleCommand(addDataFile, cn);
            command.ExecuteNonQuery();
        }

        private void toolStripMenuItem5_Click(object sender, EventArgs e)
        {
            string addDataFile = "ALTER TABLESPACE TABSPACE ADD DATAFILE 'E:\\ORACLE\\ORADATA\\GLOBE\\TABSPACE5.ora'  SIZE  5M  AUTOEXTEND ON NEXT  100M MAXSIZE  2048M";
            OracleCommand command = new OracleCommand(addDataFile, cn);
            command.ExecuteNonQuery();
        }

        private void toolStripMenuItem6_Click(object sender, EventArgs e)
        {
            string addDataFile = "ALTER TABLESPACE TABSPACE ADD DATAFILE 'E:\\ORACLE\\ORADATA\\GLOBE\\TABSPACE6.ora'  SIZE  5M  AUTOEXTEND ON NEXT  100M MAXSIZE  2048M";
            OracleCommand command = new OracleCommand(addDataFile, cn);
            command.ExecuteNonQuery();
        }
         private void toolStripMenuItem7_Click(object sender, EventArgs e)
         {
             string addDataFile = "ALTER TABLESPACE TABSPACE ADD DATAFILE 'E:\\ORACLE\\ORADATA\\GLOBE\\TABSPACE7.ora'  SIZE  5M  AUTOEXTEND ON NEXT  100M MAXSIZE  2048M";
             OracleCommand command = new OracleCommand(addDataFile, cn);
             command.ExecuteNonQuery();

        }

        private void toolStripMenuItem8_Click(object sender, EventArgs e)
        {
            string addDataFile = "ALTER TABLESPACE TABSPACE ADD DATAFILE 'E:\\ORACLE\\ORADATA\\GLOBE\\TABSPACE8.ora'  SIZE  5M  AUTOEXTEND ON NEXT  100M MAXSIZE  2048M";
            OracleCommand command = new OracleCommand(addDataFile, cn);
            command.ExecuteNonQuery();
        }

        private void 输入表空间ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            TableSpace ts = new TableSpace();
            ts.Show();
        }

        private void processToolStripMenuItem_Click(object sender, EventArgs e)
        {
            pgbInput.Value = 10;
        }       
    }
}