public static void Run() { //DCM数据上传测试 LogHelper.InfoLog("开始执行DCMTranslator"); try { DCMFileOperator dCMFileOperator = new DCMFileOperator(); dCMFileOperator.OperateFiles(); DataSet ds = dCMFileOperator.DCMData; SqlOper sqlo = new SqlOper(); string info = ""; foreach (DataTable dt in ds.Tables) { info = info + dt.TableName + "\t" + dt.Rows.Count.ToString() + "\n"; DCMDB2 db2 = new DCMDB2(dt.TableName); db2.GetData(dt); sqlo.LoadToDB2(db2); } if (!string.IsNullOrEmpty(info)) { LogHelper.InfoLog(info); } } catch (Exception e) { LogHelper.ErrorLog("DCM:\t", e); } LogHelper.InfoLog("DCMTranslator执行完毕"); }
public void LoadToDB2(DCMDB2 db2) { try { sql = string.Format("insert into ISTRPT.EDA_INLINE_DCM values ('{0}',to_date('{1}', 'yyyy/mm/dd HH24:mi:ss'),'{2}','{3}','{4}',{5},'{6}',to_date('{7}', 'yyyy/mm/dd HH24:mi:ss'),'{8}')", db2.Guid, db2.CollectionDateTime, db2.EQP_ID, db2.LotID, db2.Recipe, db2.MeasureDataCount, db2.CoordinateArray, db2.UpdateTime, db2.FileName); SqlHelper sqlHelper = new SqlHelper(); sqlHelper.GetSomeDate(sql); } catch (Exception e) { // throw new Exception(e.Message + "\tFileName:" + db2.FileName + "\tLotID:" + db2.LotID ); LogHelper.ErrorLog(new Exception(e.Message + "\tFileName:" + db2.FileName + "\tLotID:" + db2.LotID)); } }