mes-client/MaterialPrint/ReadTestInfo.cs

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Diagnostics;
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();

        string ms_id = "";

        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 string exec(string exePath, string parameters)
        {
            Process process = new Process();
            process.StartInfo.FileName = exePath;
            process.StartInfo.UseShellExecute = false;
            process.StartInfo.RedirectStandardInput = true;
            process.StartInfo.RedirectStandardOutput = true;
            process.StartInfo.CreateNoWindow = true;
            process.StartInfo.RedirectStandardError = true;//重定向标准错误输出
            process.Start();
            process.StandardInput.WriteLine(parameters);

            process.StandardInput.Close();   //运行完毕关闭控制台输入
            string add = process.StandardOutput.ReadToEnd(); //读取输出的信息
            Console.WriteLine(add);
            process.Close();
            return add;
        }

        public void GetAgingInfo(string FilePath)
        {
            //C:\Users\callm\Desktop\iNet
            FilePath = @"C:\Users\callm\Desktop\iNet\RunIn.Log";
            StreamReader sr = new StreamReader(FilePath);
            
            string StartTime = "";
            string EndTime = "";
            while (!sr.EndOfStream)
            {
                string str = sr.ReadLine();
                if (str.Contains("Video Start"))
                {
                    StartTime = Regex.Match(str, @"\d{2}/\d{2}/\d{4} \d{2}:\d{2}:\d{2}").Value;
                }
                if (str.Contains("Video PASS"))
                {
                    EndTime = Regex.Match(str, @"\d{2}/\d{2}/\d{4} \d{2}:\d{2}:\d{2}").Value;
                }
            }
            dh.ExecuteSql("update makeserial set ms_starttime=to_date('" + StartTime + "','dd/mm/yyyy hh24:mi:ss'),ms_endtime=to_date('" + EndTime + "','dd/mm/yyyy hh24:mi:ss') where ms_id='" + ms_id + "'", "select");
        }

        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");
            dt.Columns.Add("SN");
            dt.Columns.Add("BIOS");
            dt.Columns.Add("PK");
            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);
                }
            }
            string SerialNumber = Regex.Match(exec("cmd.exe", " wmic os get SerialNumber /value"), @"SerialNumber=\S+").Value.Replace("SerialNumber=", "");
            string BIOS = Regex.Match(exec("cmd.exe", " wmic bios get SMBIOSBIOSVersion / value"), @"SMBIOSBIOSVersion=\S+").Value.Replace("SMBIOSBIOSVersion=", "");
            string PK = Regex.Match(exec("CheckupKey.exe", ""), @"The PKID is: \S+").Value.Replace("The PKID is: ", "");
            //判断KEY是否被使用过
            string keysn = dh.getFieldDataByCondition("makeserial", "ms_sncode", "ms_id<>" + ms_id + " and ms_key='" + PK + "'").ToString();
            bool TestOK = true;
            //if (SerialNumber != SN.Text)
            //{
            //    MessageBox.Show("扫描序列号:" + SN.Text + "和本机读取序列号:" + SerialNumber + "不一致");
            //    TestOK = false;
            //}
            if (keysn != "")
            {
                MessageBox.Show("KEY:" + PK + "已被序列号:" + keysn + "使用");
                TestOK = false;
            }
            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;
                dr["SN"] = SerialNumber;
                dr["BIOS"] = BIOS;
                dr["PK"] = PK;
                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 + "')";
                //测试OK才上传数据
                if (TestOK)
                    dh.ExecuteSql(sql, "insert");
            }
            if (TestOK)
            {
                dh.ExecuteSql("update makeserial set ms_key='" + PK + "' where ms_id=" + ms_id, "update");
                MessageBox.Show("测试记录保存成功");
            }
        }

        private void SN_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyData == Keys.Enter)
            {
                ms_id = dh.getFieldDataByCondition("makeserial", "max(ms_id)", "ms_sncode='" + SN.Text + "' or ms_firstsn='" + SN.Text + "'").ToString();
                if (ms_id != "")
                {
                    GetAgingInfo("");
                    //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;
                        }
                    }
                }
            }
        }
    }
}