public string MicroScopeInfoValidation(MicroScopeInfo microScopeInfo)
{
try
{
}
catch (Exception ex)
{
throw ex;
}
return("");
}
public string InsertMicroscopeProcessData(string sXML)
{
MicroScopeInfo microScopeInfo = new MicroScopeInfo();
sXML = "<TRX><TRX_NAME>InsertMicroscopeProcessData</TRX_NAME><TYPE_ID>IN</TYPE_ID><LOG_ID>17050803.07.11_20170829173900</LOG_ID><DEVICE_ID>IDIM02</DEVICE_ID><USER_ID>T1705016</USER_ID><BARCODE_ID>17050803.07.11</BARCODE_ID><TEST_TIME>2017.03.15 16:51:31</TEST_TIME><TEST_RECIPE_NAME>CGV-CN020-548G30V1-F850-OQC</TEST_RECIPE_NAME><USER_ID>T1705016</USER_ID><BARCODE_ID>170801.01.01</BARCODE_ID><MICROSCOPE><FIG_NAME>0001.JPG</FIG_NAME><COORDINATE_CODE>001</COORDINATE_CODE><COORDINATE_X>-51.569</COORDINATE_X><COORDINATE_Y>1.029</COORDINATE_Y><COORDINATE_R>51.579</COORDINATE_R><COORDINATE_T>178.856</COORDINATE_T><COORDINATE_Z>0.061</COORDINATE_Z><CONE_ANGLE>51.568</CONE_ANGLE><RADIUS>1.028</RADIUS><DIAMETER>51.571</DIAMETER><FLATNESS>178.857</FLATNESS><PERIMETER>0.061</PERIMETER><SPINDLE_X_LENGTH>0.031</SPINDLE_X_LENGTH><SPINDLE_Y_LENGTH>0.063</SPINDLE_Y_LENGTH><AREA>1.123</AREA><STARTING_ANGLE>30.112</STARTING_ANGLE><TERMINATION_ANGLE>40.112</TERMINATION_ANGLE><PROJECTION_DISTANCE_XY>1.012</PROJECTION_DISTANCE_XY><PROJECTION_DISTANCE_YZ>2.123</PROJECTION_DISTANCE_YZ><PROJECTION_DISTANCE_XZ>3.531</PROJECTION_DISTANCE_XZ><INNER_DIAMETER>5.123</INNER_DIAMETER><OUTER_DIAMETER>3.123</OUTER_DIAMETER><INNER_CIRCUMFERENCE>6.087</INNER_CIRCUMFERENCE><OUTER_CIRCUMFERENCE>8.948</OUTER_CIRCUMFERENCE><AVG_THICKNESS>0.054</AVG_THICKNESS><ELEVATION_ANGLE>31.113</ELEVATION_ANGLE><MEASUREMENT_TIME>2017/09/11 16:14:00</MEASUREMENT_TIME></MICROSCOPE><MICROSCOPE><FIG_NAME>0002.JPG</FIG_NAME><COORDINATE_CODE>001</COORDINATE_CODE><COORDINATE_X>-51.569</COORDINATE_X><COORDINATE_Y>1.029</COORDINATE_Y><COORDINATE_R>51.579</COORDINATE_R><COORDINATE_T>178.856</COORDINATE_T><COORDINATE_Z>0.061</COORDINATE_Z><CONE_ANGLE>51.568</CONE_ANGLE><RADIUS>1.028</RADIUS><DIAMETER>51.571</DIAMETER><FLATNESS>178.857</FLATNESS><PERIMETER>0.061</PERIMETER><SPINDLE_X_LENGTH>0.031</SPINDLE_X_LENGTH><SPINDLE_Y_LENGTH>0.063</SPINDLE_Y_LENGTH><AREA>1.123</AREA><STARTING_ANGLE>30.112</STARTING_ANGLE><TERMINATION_ANGLE>40.112</TERMINATION_ANGLE><PROJECTION_DISTANCE_XY>1.012</PROJECTION_DISTANCE_XY><PROJECTION_DISTANCE_YZ>2.123</PROJECTION_DISTANCE_YZ><PROJECTION_DISTANCE_XZ>3.531</PROJECTION_DISTANCE_XZ><INNER_DIAMETER>5.123</INNER_DIAMETER><OUTER_DIAMETER>3.123</OUTER_DIAMETER><INNER_CIRCUMFERENCE>6.087</INNER_CIRCUMFERENCE><OUTER_CIRCUMFERENCE>8.948</OUTER_CIRCUMFERENCE><AVG_THICKNESS>0.054</AVG_THICKNESS><ELEVATION_ANGLE>31.113</ELEVATION_ANGLE><MEASUREMENT_TIME>2017.09.11 16:15:00</MEASUREMENT_TIME></MICROSCOPE></TRX>";
try
{
//microScopeInfo = getMicroScopeInfoFromXML(sXML);
//string strMsg = MicroScopeInfoValidation(microScopeInfo);
//Message message = new Message();
//message.TRX_NAME = microScopeInfo.TRX_NAME;
//message.TYPE_ID = microScopeInfo.TYPE_ID;
//message.LOG_ID = microScopeInfo.LOG_ID;
//message.BARCODE_ID = microScopeInfo.BARCODE_ID;
}
catch (Exception ex)
{
//send email
}
return("test" + "," + sXML);
}
public MicroScopeInfo getMicroScopeInfoFromXML(string strXMLFile)
{
MicroScopeInfo microScopeInfo = new MicroScopeInfo();
DataSet ds = ConvertXMLFileToDataSet(strXMLFile);
try
{
if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
microScopeInfo.TRX_NAME = ds.Tables[0].Rows[0]["TRX_NAME"].ToString();
microScopeInfo.TYPE_ID = ds.Tables[0].Rows[0]["TYPE_ID"].ToString();
microScopeInfo.LOG_ID = ds.Tables[0].Rows[0]["LOG_ID"].ToString();
//microScopeInfo.USER_ID = ds.Tables[0].Rows[0]["USER_ID"].ToString();
microScopeInfo.BARCODE_ID = ds.Tables[0].Rows[0]["BARCODE_ID"].ToString();
microScopeInfo.TEST_TIME = ds.Tables[0].Rows[0]["TEST_TIME"].ToString();
microScopeInfo.TEST_RECIPE_NAME = ds.Tables[0].Rows[0]["TEST_RECIPE_NAME"].ToString();
if (ds.Tables.Count > 1 && ds.Tables[1].Rows.Count > 0)
{
MSMeasureInfo[] lineinfo = new MSMeasureInfo[ds.Tables[1].Rows.Count];
for (int i = 0; i < ds.Tables[1].Rows.Count; i++)
{
lineinfo[i] = new MSMeasureInfo();
lineinfo[i].FIG_NAME = ds.Tables[1].Rows[i]["FIG_NAME"].ToString();
lineinfo[i].COORDINATE_CODE = ds.Tables[1].Rows[i]["COORDINATE_CODE"].ToString();
lineinfo[i].COORDINATE_X = ds.Tables[1].Rows[i]["COORDINATE_X"].ToString();
lineinfo[i].COORDINATE_Y = ds.Tables[1].Rows[i]["COORDINATE_Y"].ToString();
lineinfo[i].COORDINATE_R = ds.Tables[1].Rows[i]["COORDINATE_R"].ToString();
lineinfo[i].COORDINATE_T = ds.Tables[1].Rows[i]["COORDINATE_T"].ToString();
lineinfo[i].COORDINATE_Z = ds.Tables[1].Rows[i]["COORDINATE_Z"].ToString();
lineinfo[i].CONE_ANGLE = ds.Tables[1].Rows[i]["CONE_ANGLE"].ToString();
lineinfo[i].RADIUS = ds.Tables[1].Rows[i]["RADIUS"].ToString();
lineinfo[i].DIAMETER = ds.Tables[1].Rows[i]["DIAMETER"].ToString();
lineinfo[i].FLATNESS = ds.Tables[1].Rows[i]["FLATNESS"].ToString();
lineinfo[i].PERIMETER = ds.Tables[1].Rows[i]["PERIMETER"].ToString();
lineinfo[i].SPINDLE_X_LENGTH = ds.Tables[1].Rows[i]["SPINDLE_X_LENGTH"].ToString();
lineinfo[i].SPINDLE_Y_LENGTH = ds.Tables[1].Rows[i]["SPINDLE_Y_LENGTH"].ToString();
lineinfo[i].SPINDLE_Z_LENGTH = ds.Tables[1].Rows[i]["SPINDLE_Z_LENGTH"].ToString();
lineinfo[i].AREA = ds.Tables[1].Rows[i]["AREA"].ToString();
lineinfo[i].STARTING_ANGLE = ds.Tables[1].Rows[i]["STARTING_ANGLE"].ToString();
lineinfo[i].TERMINATION_ANGLE = ds.Tables[1].Rows[i]["TERMINATION_ANGLE"].ToString();
lineinfo[i].PROJECTION_DISTANCE_XY = ds.Tables[1].Rows[i]["PROJECTION_DISTANCE_XY"].ToString();
lineinfo[i].PROJECTION_DISTANCE_YZ = ds.Tables[1].Rows[i]["PROJECTION_DISTANCE_YZ"].ToString();
lineinfo[i].PROJECTION_DISTANCE_XZ = ds.Tables[1].Rows[i]["PROJECTION_DISTANCE_XZ"].ToString();
lineinfo[i].INNER_DIAMETER = ds.Tables[1].Rows[i]["INNER_DIAMETER"].ToString();
lineinfo[i].OUTER_DIAMETER = ds.Tables[1].Rows[i]["OUTER_DIAMETER"].ToString();
lineinfo[i].INNER_CIRCUMFERENCE = ds.Tables[1].Rows[i]["INNER_CIRCUMFERENCE"].ToString();
lineinfo[i].OUTER_CIRCUMFERENCE = ds.Tables[1].Rows[i]["OUTER_CIRCUMFERENCE"].ToString();
lineinfo[i].AVG_THICKNESS = ds.Tables[1].Rows[i]["AVG_THICKNESS"].ToString();
lineinfo[i].ELEVATION_ANGLE = ds.Tables[1].Rows[i]["ELEVATION_ANGLE"].ToString();
lineinfo[i].MEASUREMENT_TIME = ds.Tables[1].Rows[i]["MEASUREMENT_TIME"].ToString();
}
microScopeInfo.MSLineInfo = lineinfo;
}
else
{
MSMeasureInfo[] lineinfo = new MSMeasureInfo[0];
microScopeInfo.MSLineInfo = lineinfo;
}
}
}
catch (Exception ex)
{
throw ex;
}
return(microScopeInfo);
}
