private void SelectedDetails(string doorID, string orderNum)
{
TestingResultInformation testingResultInformation = DB_TestingResult.SearchInfoByID(doorID, orderNum);
txt_DoorEdgeResult0.Text = testingResultInformation.DoorEdgeResult0;
txt_DoorEdgeFailedReason0.Text = testingResultInformation.DoorEdgeFailedReason0;
txt_DoorEdgeResult1.Text = testingResultInformation.DoorEdgeResult1;
txt_DoorEdgeFailedReason1.Text = testingResultInformation.DoorEdgeFailedReason1;
txt_DoorEdgeResult2.Text = testingResultInformation.DoorEdgeResult2;
txt_DoorEdgeFailedReason2.Text = testingResultInformation.DoorEdgeFailedReason2;
txt_DoorEdgeResult3.Text = testingResultInformation.DoorEdgeResult3;
txt_DoorEdgeFailedReason3.Text = testingResultInformation.DoorEdgeFailedReason3;
//resultImage1.Source = new BitmapImage(new Uri(testingResultInformation.AroundImagePath, UriKind.Absolute));
//resultImage2.Source = new BitmapImage(new Uri(testingResultInformation.WideLockImagePath, UriKind.Absolute));
//resultImage3.Source = new BitmapImage(new Uri(testingResultInformation.WideHingeImagePath, UriKind.Absolute));
//resultImage4.Source = new BitmapImage(new Uri(testingResultInformation.WideHingeImagePath, UriKind.Absolute));
}
/// <summary>
/// 查询检测详情
/// </summary>
/// <param name="doorID">门ID</param>
/// <param name="orderNum">订单编号</param>
/// <returns>详情信息</returns>
public static TestingResultInformation SearchInfoByID(string doorID, string orderNum)
{
TestingResultInformation testingResultInformation = null;
string sql = DB_SQL.Sel_InfoByID(doorID, orderNum);
SqlConnection conn = null;
SqlCommand cmd = null;
SqlDataReader objSqlReader = null;
try
{
using (conn = new SqlConnection(DB_SQL.conStr))
{
using (cmd = new SqlCommand(sql, conn))
{
conn.Open();
objSqlReader = cmd.ExecuteReader();
while (objSqlReader.Read())
{
testingResultInformation = new TestingResultInformation();
switch (objSqlReader[0].ToString())
{
case "0":
testingResultInformation.DoorEdgeResult0 = "NG";
testingResultInformation.DoorEdgeFailedReason0 = DetailValue(objSqlReader[1].ToString());
break;
case "1":
testingResultInformation.DoorEdgeResult0 = "OK";
testingResultInformation.DoorEdgeFailedReason0 = "-";
break;
}
switch (objSqlReader[2].ToString())
{
case "0":
testingResultInformation.DoorEdgeResult1 = "NG";
testingResultInformation.DoorEdgeFailedReason1 = DetailValue(objSqlReader[3].ToString());
break;
case "1":
testingResultInformation.DoorEdgeResult1 = "OK";
testingResultInformation.DoorEdgeFailedReason1 = "-";
break;
}
switch (objSqlReader[4].ToString())
{
case "0":
testingResultInformation.DoorEdgeResult2 = "NG";
testingResultInformation.DoorEdgeFailedReason2 = DetailValue(objSqlReader[5].ToString());
break;
case "1":
testingResultInformation.DoorEdgeResult2 = "OK";
testingResultInformation.DoorEdgeFailedReason2 = "-";
break;
}
switch (objSqlReader[6].ToString())
{
case "0":
testingResultInformation.DoorEdgeResult3 = "NG";
testingResultInformation.DoorEdgeFailedReason3 = DetailValue(objSqlReader[7].ToString());
break;
case "1":
testingResultInformation.DoorEdgeResult3 = "OK";
testingResultInformation.DoorEdgeFailedReason3 = "-";
break;
}
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString() + "打开数据库失败！");
}
finally
{
if (objSqlReader != null)
{
objSqlReader.Close();
}
if (cmd != null)
{
cmd.Dispose();
}
if (conn != null)
{
conn.Close();
conn.Dispose();
}
}
return(testingResultInformation);
}
