mes-client/MaterialPrint/ReadTestInfo.cs

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.IO;
using System.Linq;
using System.Text;
using System.Text.RegularExpressions;
using System.Windows.Forms;

namespace MaterialPrint
{
    public partial class ReadTestInfo : Form
    {

        DataHelper dh = new DataHelper();

        public ReadTestInfo()
        {
            InitializeComponent();
        }

        Dictionary<string, string> TestItem = new Dictionary<string, string>();
        private void ReadTestInfo_Load(object sender, EventArgs e)
        {
            TestItem.Add("SystemInfo", "系统测试");
            TestItem.Add("Keypad", "按键测试");
            TestItem.Add("Battery", "电池测试");
            TestItem.Add("FrontCameraRec", "前摄像头摄像");
            TestItem.Add("FrontCamera", "前摄像头拍照");
            TestItem.Add("Brightness", "背光测试");
            TestItem.Add("Display", "显示屏测试");
            TestItem.Add("ExtDisplay", "外接显示器");
            TestItem.Add("RemovableDevice", "存储设备");
            TestItem.Add("WiFi", "WIFI测试");
            TestItem.Add("Bluetooth", "BT测试");
            TestItem.Add("Speaker", "扬声器和麦克风测试");
            TestItem.Add("Headset", "耳机和麦克风测试");
            TestItem.Add("Touchpad", "触摸板");
            TestItem.Add("Keyboard", "键盘测试");
            TestItem.Add("SerialPort", "COM接口");
            TestItem.Add("RearCamera", "后摄像头拍照");
            TestItem.Add("RearCameraRec", "后摄像头摄像");
            TestItem.Add("Touch", "触摸屏测试");
            TestItem.Add("Pen", "触控笔测试");
            TestItem.Add("LAN", "RJ45接口");
            TestItem.Add("SIM", "3G/4G测试");
            TestItem.Add("Accelerometer", "G Sensor 重力感应测试");
            TestItem.Add("GPS", "GPS测试");
            TestItem.Add("Gyrometer", "陀螺仪测试");
            TestItem.Add("Light", "光感测试");
            TestItem.Add("Compass", "指南针");

        }


        public void GetWriteInfo(string FilePath)
        {
            Dictionary<string, string> Dic = new Dictionary<string, string>();
            StreamReader sr = new StreamReader(FilePath);
            DataTable dt = new DataTable();
            dt.Columns.Add("itemname");
            dt.Columns.Add("testresult");
            while (!sr.EndOfStream)
            {
                string str = sr.ReadLine();
                string Value = Regex.Match(str, @"\d{4}/\d{2}/\d{2} \d{2}:\d{2}:\d{2}.\d{3}\t\[Info] - (PASS|FAIL)\t\S+").Value;
                if (Value != "")
                {
                    if (Dic.ContainsKey(Value.Split('\t')[2]))
                        Dic.Remove(Value.Split('\t')[2]);
                    Dic.Add(Value.Split('\t')[2], Value);
                }
            }
            ResultView.DataSource = dt;

            foreach (var item in Dic)
            {
                string time = item.Value.Split('\t')[0];
                string result = item.Value.Split('\t')[1].Contains("PASS") ? "PASS" : "FAIL";
                string itemname = TestItem.ContainsKey(item.Key) ? TestItem[item.Key] : item.Key;
                DataRow dr = dt.NewRow();
                dr["itemname"] = itemname;
                dr["testresult"] = item.Value;
                dt.Rows.Add(dr);
                string sql = "insert into steptestdetail (std_id,std_sn,std_date,std_class,std_testresult,std_itemname)values";
                sql += "(steptestdetail_seq.nextval,'" + SN.Text + "',to_timestamp('" + item.Value.Split('\t')[0] + "',";
                sql += "'yyyy-mm-dd hh24:mi:ss.ff6'),'" + item.Key + "','" + result + "','" + itemname + "')";
                dh.ExecuteSql(sql, "insert");
            }
            MessageBox.Show("测试记录保存成功");
        }

        private void SN_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyData == Keys.Enter)
            {
                if (dh.CheckExist("makeserial", "ms_sncode='" + SN.Text + "' or ms_firstsn='" + SN.Text + "'"))
                {
                    GetWriteInfo(@"C:\TEST_TOOL\SFTClassicLog.txt");
                }
                else
                {
                    MessageBox.Show("序列号" + SN.Text + "不存在");
                }
            }
        }

        private void ResultView_CellPainting(object sender, DataGridViewCellPaintingEventArgs e)
        {
            if (e.ColumnIndex >= 0)
            {
                if (ResultView.Columns[e.ColumnIndex].Name == "testresult")
                {
                    if (e.RowIndex >= 0)
                    {
                        if (ResultView.Rows[e.RowIndex].Cells["testresult"].Value != null && (ResultView.Rows[e.RowIndex].Cells["testresult"].Value.ToString().Contains("PASS")))
                        {
                            e.Graphics.FillRectangle(Brushes.ForestGreen, e.CellBounds);
                            Rectangle border = e.CellBounds;
                            border.Width -= 1;
                            e.Graphics.DrawRectangle(Pens.Black, border);
                            e.PaintContent(e.CellBounds);
                            e.Handled = true;
                        }
                        else
                        {
                            e.Graphics.FillRectangle(Brushes.OrangeRed, e.CellBounds);
                            Rectangle border = e.CellBounds;
                            border.Width -= 1;
                            e.Graphics.DrawRectangle(Pens.Black, border);
                            e.PaintContent(e.CellBounds);
                            e.Handled = true;
                        }
                    }
                }
            }
        }
    }
}