//遍历文件夹，更新数据
private void UpdateData()
{
while (true)
{
Thread.Sleep(1000*60);
try
{
OleDbConnection cn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\\Windows\\System32\\data\\data.mdb;");
cn.Open();
DataTable dt = new DataTable();
OleDbDataAdapter da = new OleDbDataAdapter("SELECT * FROM [data]", cn);
da.Fill(dt);
string sqls = "";
foreach (DataRow row in dt.Rows)
{
CarData data = new CarData();
data.boxid = row["boxid"].ToString();
data.truckNo = row["truckNo"].ToString();
data.startTime = row["startTime"].ToString();
data.stationID = int.Parse(row["startstationid"].ToString());
data.type = int.Parse(row["type"].ToString());
data.endTime = row["endTime"].ToString();
data.allWeight = double.Parse(row["allWeight"].ToString());
data.carWeight = double.Parse(row["downWeight"].ToString());
data.downTime = row["downTime"].ToString();
data.uplist = row["upList"].ToString();
data.downTime = row["downList"].ToString();
string sql = "EXEC center_updatedata '" + data.boxid + "','"
+ data.truckNo + "','" + data.parseData(1) + "',"
+ data.stationID + "," + data.type + "," + CommonData.stationID + ",'" + data.parseData(0)
+ "'," + (data.allWeight - data.carWeight) + ",'"
+ data.picPath + "',@status=" + 0 + ",@allWeight="
+ data.allWeight + ",@downWeight=" + data.carWeight + ",@downTime='"
+ data.downTime + "',@uplist='" + data.uplist + "',@downlist='" + data.downlist + "'";
BaseOperate op = new BaseOperate();
if (!op.getcom(sql))
continue;
sql = "DELETE FROM [data] WHERE ID = " + int.Parse(row["id"].ToString());
OleDbCommand cmd = new OleDbCommand(sql, cn);
cmd.ExecuteNonQuery();
}
cn.Close();
}
catch (Exception ex) { LogWriter.WriteLog(ex.Message + "\n" + ex.StackTrace); }
}
}
