TestRecordData TestDataUploadMES_CheckInputData(string SN, string MODEL, string TESTTIME, string STATE, string STATION, string CELL, string OPERATOR, string ERROR_CODE)
{
TestRecordData testRecord = new TestRecordData();
testRecord.SN = SN;
testRecord.MODEL = MODEL;
testRecord.TESTTIME = TESTTIME;
testRecord.STATE = STATE;
testRecord.STATION = STATION;
testRecord.CELL = CELL;
testRecord.OPERATOR = OPERATOR;
testRecord.ERROR_CODE = ERROR_CODE;
return(testRecord);
}
public void TestReaderGetRecordWithoutFieldHeadersOrPropertyMappingsNestedObject()
{
using (var stream = new MemoryStream())
using (var writer = new StreamWriter(stream))
using (var reader = new StreamReader(stream))
using (var dtReader = new DelimitedTextReader(reader))
{
writer.Write("value1,100,true,\"12/31/2016\", 25.76\r\n");
writer.Flush();
stream.Position = 0;
dtReader.FirstRowIsHeader = false;
dtReader.Read();
TestRecordData trecord = dtReader.GetRecord <TestRecordData>();
Assert.NotNull(trecord);
Assert.Equal("value1", trecord.Data1);
Assert.Equal(100, trecord.Data2);
Assert.True(trecord.Data4);
}
}
public MESServiceRes TestDataUploadMES(string SN, string MODEL, string TESTTIME, string STATE, string STATION,
string CELL, string OPERATOR, string ERROR_CODE)
{
//Sql注入;
TestRecordData testRecord = new TestRecordData();
#region DataCheck;
try
{
testRecord = TestDataUploadMES_CheckInputData(SN, MODEL, TESTTIME, STATE, STATION, CELL, OPERATOR,
ERROR_CODE);
}
catch (Exception e)
{
resObj.Statusvalue = (int)StatusValue.fail;
resObj.MessageCode = "MES00001";
resObj.Message = "输入参数错误:" + e.ToString();
return(resObj);
}
#endregion
OleExec DB = new OleExec("VERTIVTESTDB", true);
T_C_TEMES_STATION_MAPPING cTeMesStationMappingControl = new T_C_TEMES_STATION_MAPPING(DB,
DB_TYPE_ENUM.Oracle);
T_R_TEST_RECORD rTestRecordControl = new T_R_TEST_RECORD(DB, DB_TYPE_ENUM.Oracle);
T_R_TEST_DETAIL_VERTIV rTestDetailVertivControl = new T_R_TEST_DETAIL_VERTIV(DB, DB_TYPE_ENUM.Oracle);
T_R_SN rSnControl = new T_R_SN(DB, DB_TYPE_ENUM.Oracle);
Row_R_TEST_RECORD rowRTestRecord = (Row_R_TEST_RECORD)rTestRecordControl.NewRow();
Row_R_TEST_DETAIL_VERTIV rowRTestDetailVertiv = (Row_R_TEST_DETAIL_VERTIV)rTestDetailVertivControl.NewRow();
try
{
C_TEMES_STATION_MAPPING cTeMesStationMapping = cTeMesStationMappingControl.GetTeMesStationMapping(DB,
STATION, "A");
if (cTeMesStationMapping == null)
{
resObj.Statusvalue = (int)StatusValue.fail;
resObj.MessageCode = "MES000017";
resObj.Message = $@"上傳失敗:未在MES系統找到Te-Station:{STATION}對應的工站,請聯繫IT配置!";
return(resObj);
}
R_SN rSn = rSnControl.LoadSN(SN, DB);
//RTestRecord
rowRTestRecord.ID = cTeMesStationMappingControl.GetNewID("VERTIV", DB);
rowRTestRecord.R_SN_ID = rSn?.ID;
rowRTestRecord.SN = testRecord.SN;
rowRTestRecord.ENDTIME = DateTime.Parse(testRecord.TESTTIME);
rowRTestRecord.STARTTIME = DateTime.Parse(testRecord.TESTTIME);
rowRTestRecord.STATE = testRecord.STATE;
rowRTestRecord.TEGROUP = "A";
rowRTestRecord.TESTATION = testRecord.STATION;
rowRTestRecord.MESSTATION = cTeMesStationMapping?.MES_STATION;
rowRTestRecord.DETAILTABLE = "R_TEST_DETAIL_VERTIV";
//RTestDetailVertiv
rowRTestDetailVertiv.ID = rTestDetailVertivControl.GetNewID("VERTIV", DB);
rowRTestDetailVertiv.R_TEST_RECORD_ID = rowRTestRecord.ID;
rowRTestDetailVertiv.SN = testRecord.SN;
rowRTestDetailVertiv.SKUNO = testRecord.MODEL;
rowRTestDetailVertiv.CREATETIME = DateTime.Parse(testRecord.TESTTIME);
rowRTestDetailVertiv.STATE = testRecord.STATE;
rowRTestDetailVertiv.STATION = testRecord.STATION;
rowRTestDetailVertiv.CELL = testRecord.CELL;
rowRTestDetailVertiv.OPERATOR = testRecord.OPERATOR;
rowRTestDetailVertiv.ERROR_CODE = testRecord.ERROR_CODE;
}
catch (Exception e)
{
resObj.Statusvalue = (int)StatusValue.fail;
resObj.MessageCode = "MES00003";
resObj.Message = "MESDB异常:" + e.ToString();
return(resObj);
}
try
{
DB.BeginTrain();
DB.ExecSQL(rowRTestDetailVertiv.GetInsertString(DB_TYPE_ENUM.Oracle));
DB.ExecSQL(rowRTestRecord.GetInsertString(DB_TYPE_ENUM.Oracle));
DB.CommitTrain();
resObj.Statusvalue = (int)StatusValue.success;
resObj.MessageCode = "";
resObj.Message = "Upload Success!";
}
catch (Exception e)
{
DB.RollbackTrain();
resObj.Statusvalue = (int)StatusValue.fail;
resObj.MessageCode = "MES00002";
resObj.Message = "写入MESERR:" + e.ToString();
}
finally
{
DB.FreeMe();
}
return(resObj);
}
