public static void selectFolderGrat() { try { CreateTable.CTemporparyTable("temporpary_data"); } catch { } FolderBrowserDialog dialog = new FolderBrowserDialog(); dialog.Description = "请选择文件夹路径"; DataTable table = importGrat.getfileGrat(MainForm.getInstance().GratFolder.Text);//获取DTS文件的路径,时间,将要存储到的表名称。 if (table.Rows.Count != 0) { importDTS.import_temporpary_data(table);//存入数据库 } else { MessageBox.Show("该路径中没有FBG文档"); } MyClass.goTrue(); MainForm.getInstance().FBRimportLable.Visible = false; }
//public static string getStr(DataTable table1,DateTime Time,string name) //{ // string str3, sum3 = null; // for (int h = 0; h < table1.Rows.Count; h++)//依照辛工的要求,修改成具体数值,并修改下面代码 // { // str3 = "('" + Time + "','" + int.Parse(table1.Rows[h][1].ToString()) + "','" + float.Parse(table1.Rows[h][2].ToString()) + "'),";//有几个字段就写几个,行(i)是不变的,列值累加 // sum3 = sum3 + str3; // } // str3 = "insert into " + name + "(RecordTime,Depth,TM) values" + sum3; // str3 = str3.Substring(0, str3.LastIndexOf(","));//获取SQL语句 // return str3; //} //public void getSQL(DataTable table, string filename, DateTime Time,string name,MySqlConnection mycon) //{ // string str, sum = null; // try // { // for (int h = 115; h < 2615; h++)//依照辛工的要求,修改成具体数值,并修改下面代码 // { // string readStr = table.Rows[h][1].ToString(); // string[] strs = readStr.Split(new char[] { ';' }, StringSplitOptions.RemoveEmptyEntries);//将读取的字符串按"制表符/t“和””“分割成数组 // str = "('" + Time + "','" + int.Parse(strs[1]) + "','" + float.Parse(strs[2]) + "'),";//有几个字段就写几个,行(i)是不变的,列值累加 // sum = sum + str; // } // string str1 = "insert into " + name + "(RecordTime,Depth,TM) values" + sum; // string str2 = str1.Substring(0, str1.LastIndexOf(","));//获取SQL语句 // doStrmycon(str2, mycon); // filename = filename.Replace("\\", "\\\\");//为了保存路径到数据库,不许进行的操作。 // string str3 = "insert into alltemporpary_data(folderUrl,folderTime,folderTable) values ('" + filename + "','" + Time + "','" + name + "')"; // doStrmycon(str3, mycon); // } // catch// (Exception se) // { // // writelog.WriteLog("部分文件夹或文件不可读" + se); // } //} public static void selectFolder() { //创建临时表,并将路径信息导入临时表 try { CreateTable.CTemporparyTable("temporpary_data"); } catch//(Exception ex) { //writelog.WriteLog("a"+ex); } DataTable table = importDTS.getDTSFileName(MainForm.getInstance().dataFolder.Text);//获取DTS文件的路径,时间,将要存储到的表名称。 if (table.Rows.Count != 0) { importDTS.import_temporpary_data(table);//存入数据库 } else { MessageBox.Show("该路径中没有DTS文档"); } MyClass.goTrue(); MainForm.getInstance().DTSimportLable.Visible = false; }