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