JG_TpsLabStudio_LTS/tps/TpsLabStudio/models/VoltAndCurrent.cs

using CommonDevHostApp.Devices;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading;
using System.IO;
using System.Threading.Tasks;
using Tps_LQ_Transmitter.com;
using System.Drawing;

namespace Tps_LQ_Transmitter.models
{
    class VoltAndCurrent: BaseModel
    {

        public VoltAndCurrent()
        {
            TemplateName = "电压及电流测试";
        }
        /// <summary>
        /// 功率及频率稳定度测试
        /// </summary>
        public override bool Run(TestNode parameters)
        {
            object[] TableCell;
            TestParameters result = new TestParameters();
            Random random = new Random();
            //获取仪器

          
            CommonVisaResource DCPower = new CommonVisaResource();
            DCPower.Open(tps.DCPowerAddress);
            TransmitterSerialPort SerialClient = new TransmitterSerialPort();
            OutData Data = new OutData();

            DataType VoltDataPrint = new DataType();
            DataType CurrentDataPrint = new DataType();


            
            if (DCPower == null)
            {
                ShowMessage(MsgType.Error, string.Format("仪器不齐全，{0}/{1}无法运行", parameters.Channel, parameters.Name));
                return false;
            }
            

            OpenExcel("电压及电流", out Spire.Xls.Workbook workbook, out Spire.Xls.Worksheet sheet);
            if (sheet == null)
            {
                ShowMessage(MsgType.Error, "找不到" + tps.TestProject + "模板.xlsx");
                return false;
            }


            ConfigParameter PowerPara = new ConfigParameter();
            PowerPara.ComPort = parameters.Parameters.GetParameter<string>("串口");
            PowerPara.StartFrequency = parameters.Parameters.GetParameter<double>("起始频率");
            PowerPara.StepFrequency = parameters.Parameters.GetParameter<double>("频率步进");
            PowerPara.FrequencyNumber = parameters.Parameters.GetParameter<int>("频点数量");
            PowerPara.StopFrequency = parameters.Parameters.GetParameter<double>("终止频率");
            PowerPara.SPAN = parameters.Parameters.GetParameter<string>("扫描带宽（SPAN）");
            PowerPara.REF = parameters.Parameters.GetParameter<string>("参考电平（REF）");
            PowerPara.RBW = parameters.Parameters.GetParameter<string>("分辨率带宽（RBW）");
            PowerPara.VBW = parameters.Parameters.GetParameter<string>("视频带宽（VBW）");
            PowerPara.ControlDelay = parameters.Parameters.GetParameter<int>("控制延时");
            PowerPara.VoltLower = parameters.Parameters.GetParameter<double>("电压下限");
            PowerPara.VoltUpper= parameters.Parameters.GetParameter<double>("电压上限");
            PowerPara.CurrentLower = parameters.Parameters.GetParameter<double>("电流下限");
            PowerPara.CurrentUpper = parameters.Parameters.GetParameter<double>("电流上限");
            if ((PowerPara.StartFrequency == 0) || ((PowerPara.StepFrequency == 0) && (PowerPara.FrequencyNumber == 0)) || (PowerPara.StopFrequency == 0)
                || (PowerPara.SPAN == null) || (PowerPara.REF == null) || (PowerPara.RBW == null) || (PowerPara.VBW == null) || (PowerPara.VoltLower==0) 
                || (PowerPara.VoltUpper == 0) ||(PowerPara.CurrentLower==0) ||(PowerPara.CurrentUpper==0))
            {
                ShowMessage(MsgType.Error, string.Format("配置文件中频率参数为空，{0}/{1}无法运行", parameters.Channel, parameters.Name));
                return false;
            }
            if (PowerPara.ControlDelay == 0)
            {
                PowerPara.ControlDelay = 10;
            }


            if ((PowerPara.FrequencyNumber != 0) && (PowerPara.FrequencyNumber != 1) && (PowerPara.StepFrequency == 0))
            {
                PowerPara.StepFrequency = ((int)(((PowerPara.StopFrequency - PowerPara.StartFrequency) / (PowerPara.FrequencyNumber - 1)) * 100)) / 100;
            }
            if (PowerPara.StepFrequency != 0)
            {
                PowerPara.FrequencyNumber = ((int)((PowerPara.StopFrequency - PowerPara.StartFrequency) / PowerPara.StepFrequency)) + 1;
            }
            double CenterFreq;
            Data.VoltVal = new string[PowerPara.FrequencyNumber];
            Data.CurrentVal = new string[PowerPara.FrequencyNumber];
            for (int point = 0; ; point++)
            {

                CenterFreq = PowerPara.StartFrequency + PowerPara.StepFrequency * point;
                if (CenterFreq > PowerPara.StopFrequency || (PowerPara.FrequencyNumber == 1 && point == 1))
                {
                    break;
                }
                Thread.Sleep(1000);
                //控制
         //       SerialClient.DUT_Transmitter_Ctrol(PowerPara.ComPort, Convert.ToByte(point + 1));
                Thread.Sleep(PowerPara.ControlDelay);//单位ms
                
                Data.VoltVal[point] = DCPower.Query("MEASure:VOLTage?\n");
           
                Data.CurrentVal[point] = DCPower.Query("MEASure:CURRent?\n");
                

                VoltDataPrint.Test_name = parameters.Channel + "-电压测试-" + CenterFreq.ToString()+"MHz";
                VoltDataPrint.Lower = PowerPara.VoltLower;
                VoltDataPrint.Upper = PowerPara.VoltUpper;
                VoltDataPrint.TestVal = double.Parse(Data.VoltVal[point]);
                //VoltDataPrint.TestVal = random.Next(2500, 3000) / 100.0;//随机数
                if ((VoltDataPrint.TestVal >= VoltDataPrint.Lower) && (VoltDataPrint.TestVal <= VoltDataPrint.Upper))
                {
                    VoltDataPrint.Result = "是";
                }
                else
                {
                    VoltDataPrint.Result = "否";
                }

                CurrentDataPrint.Test_name = parameters.Channel + "-电流测试-" + CenterFreq.ToString() + "MHz";
                CurrentDataPrint.Lower = PowerPara.CurrentLower;
                CurrentDataPrint.Upper = PowerPara.CurrentUpper;
                CurrentDataPrint.TestVal = double.Parse(Data.CurrentVal[point]);
                //CurrentDataPrint.TestVal = random.Next(90, 160) / 100.0;
                if ((CurrentDataPrint.TestVal >= CurrentDataPrint.Lower) && (CurrentDataPrint.TestVal <= CurrentDataPrint.Upper))
                {
                    CurrentDataPrint.Result = "是";
                }
                else
                {
                    CurrentDataPrint.Result = "否";
                }

                tps.TestTableAddCell(CurrentDataPrint.Test_name, CurrentDataPrint.Lower.ToString(), CurrentDataPrint.Upper.ToString(), CurrentDataPrint.TestVal.ToString(), CurrentDataPrint.Result);
                tps.TestTableAddCell(VoltDataPrint.Test_name, VoltDataPrint.Lower.ToString(), VoltDataPrint.Upper.ToString(), VoltDataPrint.TestVal.ToString(), VoltDataPrint.Result);
               
                if (parameters.Channel == "通道1")
                {
                    if (point == 0)
                    {
                        WriteExcelData(sheet, point - 1, 1, "测试名称", "下限", "上限", "测试值", "通过");
                    }

                    WriteExcelData(sheet, point, 1, CurrentDataPrint.Test_name, CurrentDataPrint.Lower.ToString(), CurrentDataPrint.Upper.ToString(), CurrentDataPrint.TestVal.ToString(), CurrentDataPrint.Result);
                    WriteExcelData(sheet, point+ PowerPara.FrequencyNumber, 1, VoltDataPrint.Test_name, VoltDataPrint.Lower.ToString(), VoltDataPrint.Upper.ToString(), VoltDataPrint.TestVal.ToString(), VoltDataPrint.Result);
                    //tps.SetTestTableCellValue(point, 5, VoltDataPrint.Result, VoltDataPrint.TestVal);
                    //tps.SetTestTableCellValue(point, 6, CurrentDataPrint.Result, CurrentDataPrint.TestVal);
                }
                else if (parameters.Channel == "通道2")
                {
                    if (point == 0)
                    {
                        WriteExcelData(sheet, point - 1, 2, "测试名称", "下限", "上限", "测试值", "通过");
                    }
                    WriteExcelData(sheet, point, 2, CurrentDataPrint.Test_name, CurrentDataPrint.Lower.ToString(), CurrentDataPrint.Upper.ToString(), CurrentDataPrint.TestVal.ToString(), CurrentDataPrint.Result);
                    WriteExcelData(sheet, point+ PowerPara.FrequencyNumber, 2, VoltDataPrint.Test_name, VoltDataPrint.Lower.ToString(), VoltDataPrint.Upper.ToString(), VoltDataPrint.TestVal.ToString(), VoltDataPrint.Result);
                    //tps.SetTestTableCellValue(point + 15, 5, VoltDataPrint.Result, VoltDataPrint.TestVal);
                    //tps.SetTestTableCellValue(point + 15, 6, CurrentDataPrint.Result, CurrentDataPrint.TestVal);
                }

            }
            SaveExcel(workbook);
            return true;
        }
        //public void OpenExcel(string sheetname, out Spire.Xls.Workbook workbook,out Spire.Xls.Worksheet sheet )
        //{
        //    string TestFilePath = "F:";
        //    string ModelFile = "F:/Transmitter_model.xlsx";
        //    string subPath = "F:/发射机测试数据/常温测试/";

        //    if (false == System.IO.Directory.Exists(subPath))
        //    {
        //        System.IO.Directory.CreateDirectory(subPath);
        //    }
        //    workbook = new Spire.Xls.Workbook();
        //    string FileName = subPath + tps.Serial + ".xlsx";
        //    if (File.Exists(FileName))
        //    {
        //        workbook.LoadFromFile(FileName);
        //        //sheet = workbook.Worksheets[sheetname];
        //    }
        //    else if (File.Exists(ModelFile))
        //    {
        //        workbook.LoadFromFile(ModelFile);
        //        //sheet = workbook.Worksheets[sheetname];
        //    }
        //    sheet = workbook.Worksheets[sheetname];
        //    if (!File.Exists(ModelFile))
        //    {
        //       sheet = null;
        //    }

        //}
        
        //public void WriteExcelData(Spire.Xls.Worksheet sheet, int row,int channel,string name,double lower,double upper,double val,string result)
        //{
        //    int column = (channel - 1) * 6;

        //    sheet.Range[row+2, 1 + column].Value2 = name;
        //    sheet.Range[row+2, 2 + column].Value2 = lower.ToString();
        //    sheet.Range[row+2, 3 + column].Value2 = upper.ToString();
        //    sheet.Range[row+2, 4 + column].Value2 = val.ToString();
        //    sheet.Range[row+2, 5 + column].Value2 = result;
           

        //}
        //public void SaveExcel(Spire.Xls.Workbook workbook)
        //{
        //    string subPath = "F:/发射机测试数据/常温测试/";
        //    string FileName = subPath + tps.Serial + ".xlsx";
        //    workbook.SaveToFile(FileName);
        //}
        public class ConfigParameter
        {
            /// <summary>
            /// 串口
            /// </summary>
            public string ComPort { set; get; }        
            /// <summary>
            /// 产品测试的起始频率
            /// </summary>
            public double StartFrequency { set; get; }
            /// <summary>
            /// 产品测试的频率步进
            /// </summary>
            public double StepFrequency { set; get; }
            /// <summary>
            /// 产品测试的频点数量
            /// </summary>
            public int FrequencyNumber { set; get; }
            /// <summary>
            /// 产品的工作频带上限(终止频率)
            /// 功能：用于判断从起始频率按一定的步进测试是否超出产品工作频段上限
            /// </summary>
            public double StopFrequency { set; get; }
            /// <summary>
            ///设置频谱仪的SPAN
            /// </summary>
            public string SPAN { set; get; }
            /// <summary>
            /// 设置参考电平
            /// </summary>
            public string REF { set; get; }
            /// <summary>
            /// 设置RBW
            /// </summary>
            public string RBW { set; get; }
            /// <summary>
            /// 设置VBW
            /// </summary>
            public string VBW { set; get; }
            /// <summary>
            /// 控制延时
            /// </summary>
            public int ControlDelay { set; get; }
            /// <summary>
            /// 电压下限
            /// </summary>
            public double VoltLower {set;get;}
            /// <summary>
            /// 电压上限
            /// </summary>
            public double VoltUpper { set; get; }
            /// <summary>
            /// 电流下限
            /// </summary>
            public double CurrentLower { set; get; }
            /// <summary>
            /// 电流上限
            /// </summary>
            public double CurrentUpper { set; get; }
  

        }

        public class OutData
        {
           
            /// <summary>
            /// 读电压值
            /// </summary>
            public string[] VoltVal { set; get; }
            /// <summary>
            /// 读电流值
            /// </summary>
            public string[] CurrentVal { set; get; }
        }

        //public class DataType
        //{

        //    /// <summary>
        //    /// 测试名称
        //    /// </summary>
        //    public string Test_name { set; get; }
        //    /// <summary>
        //    /// 指标下限
        //    /// </summary>
        //    public double Lower { set; get; }
        //    /// <summary>
        //    /// 指标上限
        //    /// </summary>
        //    public double Upper { set; get; }         
        //    /// <summary>
        //    /// 测试值
        //    /// </summary>
        //    public double TestVal { set; get; }
        //    /// <summary>
        //    /// 判断结果
        //    /// </summary>
        //    public string Result { set; get; }


        //}
    }
}