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));
}
}
