public static void importGratReal(DataTable table, string filename)
{
MySqlConnection mycon = getMycon();
DateTime dt = Convert.ToDateTime(table.Rows[0][0]);
//判断是否已经导入数据库
string Str = "select folderTime from allGrat_data where folderTime='" + dt + "'";//如果等于‘1’下面的代码不执行。
MySqlCommand mycmd = new MySqlCommand(Str, mycon);
object count = mycmd.ExecuteScalar();
if (count != null)
{
}
else
{
//DateTime dt = Convert.ToDateTime(table.Rows[0][0]);
// = DateTime.ParseExact(Str, "yyyyMMddHHmmss", System.Globalization.CultureInfo.CurrentCulture);
string name = CreateTable.getGratTableName(dt, "fbr"); //获取文件将要存入的表名称
CreateTable.CDataTable(name); //创建表
string str, sum = null;
try
{
for (int h = 0; h < table.Rows.Count; h++) //依照辛工的要求，修改成具体数值，并修改下面代码
{
str = "('" + dt + "','" + int.Parse(table.Rows[h][1].ToString()) + "','" + float.Parse(table.Rows[h][2].ToString()) + "'),"; //有几个字段就写几个，行（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 allgrat_data(folderUrl,folderTime,folderTable) values ('" + filename + "','" + dt + "','" + name + "')";
doStrmycon(str3, mycon);
}
catch //(Exception se)
{
// writelog.WriteLog("部分文件夹或文件不可读" + se);
}
}
mycon.Close();
mycon.Dispose();
}
public static DataTable table = importDTS.gettable();//实例化表
/*针对于Grat数据，把路径信息，时间信息，以及要存入的表格信息*/
public static DataTable getfileGrat(string foldPath)
{
DirectoryInfo TheFolder = new DirectoryInfo(foldPath);
//遍历文件夹
try
{
foreach (DirectoryInfo NextFolder in TheFolder.GetDirectories())
{
getfileGrat(NextFolder.FullName);
}
//遍历文件
foreach (FileInfo NextFile in TheFolder.GetFiles())
{
if (NextFile.Extension == ".fbr")//判断文件的后缀是否是所需要的
{
string filename = NextFile.FullName;
string timestr = filename.Substring(filename.LastIndexOf("\\") + 1, filename.LastIndexOf(".") - (filename.LastIndexOf("\\") + 1)); //去除后缀
string str = timestr.Remove(0, timestr.Length - 14); //取去除后缀的文件名称的后14位数据。
DateTime dt = DateTime.ParseExact(str, "yyyyMMddHHmmss", System.Globalization.CultureInfo.CurrentCulture);
DataRow dr = table.NewRow(); //创建数据行
dr["fa"] = NextFile.FullName; //路径
dr["fb"] = dt; //时间
dr["fc"] = CreateTable.getGratTableName(dt, "fbr"); //获取文件将要存入的表名称
table.Rows.Add(dr); //将创建的数据行添加到table中
}
else
{
continue;
}
}
}
catch //(Exception ex)
{
//writelog.WriteLog("部分文件夹或文件不可读" + ex);
}
return(table);
}