// public static void SaveopcXML() { try { string sPath = "D:/OpcXML/data.xml"; ZipFile(sPath); FileStream fs = new FileStream("D:/OpcXML/data.zip", FileMode.Open); BinaryReader br = new BinaryReader(fs); Byte[] byData = br.ReadBytes((int)fs.Length); string sData = System.Text.Encoding.UTF8.GetString(byData); DateTime dt_value = DateTime.Now; string sCreateTime = dt_value.Year.ToString("000#") + dt_value.Month.ToString("0#") + dt_value.Day.ToString("0#") + dt_value.Hour.ToString("0#") + dt_value.Minute.ToString("0#") + dt_value.Second.ToString("0#"); //rawtohex() fs.Dispose();//释放资源 DeleteFile("D:/OpcXML/data.zip"); OdbcHelper.OracleExeQuery("update U_WIPPROCDATA set FILE_DATA=:zp, CREATE_TIME=" + sCreateTime + ",CREATE_USER_ID='1111' where FACTORY ='15车间' AND LOT_ID ='1'", byData); fs.Close(); } catch (Exception e) { Console.WriteLine(e.Message); return; } }