/// <summary>
/// 从IVH的CSV文件fileName读取信息，并将头部信息填充到header，将扫描项填充到列表entries
/// 若成功则返回TRUE，
/// 若出现文件被破坏（格式），或者读文件异常，转换异常等，则返回FALSE
/// </summary>
/// <param name="entries"></param>
/// <param name="header"></param>
/// <returns></returns>
internal static bool Read_Csv_IVH(string fileName, out List <CsvReport_IVH_Entry> entries, out CsvReport_PIVH_Header header)
{
int v, ln;
string sLine;
char[] chars;
string[] sArray;
CsvReport_IVH_Entry ivh_entry;
StreamReader sr = null;
//文件损坏指示
bool bCrashed = false;
try
{
//构造CSV文件的头部对象
header = new CsvReport_PIVH_Header();
//建立流
sr = new StreamReader(fileName, Encoding.ASCII);
//略过第一行
sr.ReadLine();
//读取第二行的日期与时间值
header.Date_Time = sr.ReadLine();
//略过第三、四行
sr.ReadLine();
sr.ReadLine();
//读取第五行，测试参数
//从左到右，以params开头，每个参数项以空格隔开
//依次为扫描类型指示字、互调方案指示字、扫描点数、扫描参考值
chars = new char[1];
chars[0] = ' ';
sArray = sr.ReadLine().Split(chars);
v = int.Parse(sArray[1]);
if (v == 0)
{
header.Swp_Type = SweepType.Time_Sweep;
}
else
{
header.Swp_Type = SweepType.Freq_Sweep;
}
v = int.Parse(sArray[2]);
if (v == 0)
{
header.Im_Schema = ImSchema.REV;
}
else
{
header.Im_Schema = ImSchema.FWD;
}
header.Im_Order = (ImOrder)Enum.Parse(typeof(ImOrder),
Enum.GetName(typeof(ImOrder), int.Parse(sArray[3])));
header.Sweep_Start = float.Parse(sArray[4]);
header.Sweep_Stop = float.Parse(sArray[5]);
header.Point_Num = int.Parse(sArray[6]);
header.Limit_Value = float.Parse(sArray[7]);
header.Y_Max_RL = float.Parse(sArray[8]);
header.Y_Min_RL = float.Parse(sArray[9]);
header.Y_Max_VSWR = float.Parse(sArray[10]);
header.Y_Min_VSWR = float.Parse(sArray[11]);
//略过第六、七行
sr.ReadLine();
sr.ReadLine();
//一行文本包含的扫描项数量
ln = 6;
chars[0] = ',';
entries = new List <CsvReport_IVH_Entry>();
//从第八行开始，读取扫描项数据
sLine = sr.ReadLine();
while (!String.IsNullOrEmpty(sLine))
{
sArray = sLine.Split(chars);
if (sArray.Length != ln)
{
bCrashed = true;
break;
}
ivh_entry = new CsvReport_IVH_Entry();
ivh_entry.No = int.Parse(sArray[0]);
ivh_entry.P = float.Parse(sArray[1]);
ivh_entry.F = float.Parse(sArray[2]);
ivh_entry.IVH_Value = float.Parse(sArray[3]);
ivh_entry.Noise = float.Parse(sArray[4]);
ivh_entry.Rl = float.Parse(sArray[5]);
entries.Add(ivh_entry);
//读取下一行，直到文件结束
sLine = sr.ReadLine();
}
sr.Close();
sr.Dispose();
}
catch
{
entries = null;
header = null;
bCrashed = true;
if (sr != null)
{
sr.Close();
sr.Dispose();
}
}
//返回值
return(!bCrashed);
}
public static bool SaveTxt(string path, CsvReport_Pim_Entry[] entries, CsvReport_PIVH_Header header, bool isdbm)
{
string col = "Instrument Date Time Content Test Description Model Number Serial Number Operator Carrier 1 Freq MHz Carrier 2 Freq, MHz Carrier 1 Power Carrier 2 Power Carrier Power Units Carrier 1 Offset Carrier 2 Offset Carrier Offset Units ALC Averaging Settling Time, msec IM Measurement Stimulus Port IM Order IM Freq, MHz IM Power Reference Value IM Peak Power IM Units";
string val = " 26/07/2016 12:16:28 PM Swept IM [Enter Test Description] [Enter Model Number] [Enter Operator] 925.0 960.0 OFF OFF dBm 0.0 0.0 dB ON Normal 0 REV Port 1 3rd 890.0 -111.3 -119.000000 -135.380000 dBm";
double limit = header.Limit_Value;
string unit = "dBm";
float max = float.MinValue;
for (int i = 0; i < entries.Length; i++)
{
if (max <= entries[i].Im_V)
{
max = entries[i].Im_V;
}
}
//if (!isdbm)
//{
// unit = "dBc";
// max = max - cjt.pow1;
//}
string mesure = "REV";
string port = "Port 1";
if (header.Im_Schema == ImSchema.FWD)
{
mesure = "FWD";
port = "Port 2";
}
if (!Directory.Exists(App_Configure.Cnfgs.Path_Rpt_Pim + "\\csv"))
{
Directory.CreateDirectory(App_Configure.Cnfgs.Path_Rpt_Pim + "\\csv");
}
bool exists = File.Exists(path + ".txt");
FileStream fs = new FileStream(path + ".txt", FileMode.Append, FileAccess.Write);
StreamWriter sw = new StreamWriter(fs);
bool result = true;
try
{
// sw.WriteLine("Instrument Date Time Content Test Description Model Number Serial Number Operator" +
//" Carrier 1 Freq, MHz Carrier 2 Freq, MHz Carrier 1 Power Carrier 2 Power Carrier Power Units Carrier 1 Offset Carrier 2 Offset" +
//" Carrier Offset Units ALC Averaging Settling Time, msec IM Measurement Stimulus Port IM Order IM Freq, MHz IM Power Reference Value IM Peak Power IM Units");
sw.WriteLine(
"Instrument" + "\t" +
"Date " + "\t" +
"Time" + "\t" +
"Content" + "\t" +
"Test Description" + "\t" +
"Model Number" + "\t" +
"Serial Number" + "\t" +
"Operator" + "\t" +
"Carrier 1 Freq, MHz" + "\t" +
"Carrier 2 Freq, MHz" + "\t" +
"Carrier 1 Power" + "\t" +
"Carrier 2 Power" + "\t" +
"Carrier Power Units" + "\t" +
"Carrier 1 Offset" + "\t" +
"Carrier 2 Offset" + "\t" +
"Carrier Offset Units" + "\t" +
"ALC" + "\t" +
"Averaging" + "\t" +
"Settling Time, msec" + "\t" +
"IM Measurement" + "\t" +
"Stimulus Port" + "\t" +
"IM Order" + "\t" +
"IM Freq, MHz" + "\t" +
"IM Power" + "\t" +
"Reference Value" + "\t" +
"IM Peak Power" + "\t" +
"IM Units");
string blank = "\t";
for (int i = 0; i < entries.Length; i++)
{
string s =
//Instrument
//"[Enter Instrument]" + blank +
"" + blank +
//Date
DateTime.Now.ToString("yyyy-MM-dd") + blank +
//Time
DateTime.Now.ToString("HH:mm:ss") + blank +
//Content
"Swept IM" + blank +
//Test Description
"[Enter Test Description]" + blank +
//Model Number
"[Enter Model Number]" + blank +
//Serial Number
"" + blank +
//Operator
"[Enter Operator]" + blank +
//Carrier 1 Freq, MHz
entries[i].F1.ToString("0.0") + blank +
//Carrier 2 Freq, MHz
entries[i].F2.ToString("0.0") + blank +
//Carrier 1 Power
//"ON" + blank + //功率1
entries[i].P1.ToString("0.0") + blank + //功率1
//Carrier 2 Power
//"ON" + blank +//功率2
entries[i].P2.ToString("0.0") + blank + //功率1
//Carrier Power Units
"dBm" + blank +
//Carrier 1 Offset
"0.0" + blank +
//Carrier 2 Offset
"0.0" + blank +
//Carrier Offset Uints
"dB" + blank +
//ALC
"ON" + blank +
//Averaging
"Normal" + blank +
//Settling Time, msec
"0" + blank +
//IM Measurement
mesure + blank +
//Stimulus Port
port + blank +
//IM Oder
((int)header.Im_Order).ToString() + "rd" + blank +
//IM Freq, MHz
entries[i].Im_F.ToString("0.0") + blank +
//IM Power
entries[i].Im_V.ToString("0.0") + blank +
//Reference Value
limit.ToString("0.000000") + blank +
//IM Peak Power
max.ToString("0.000000") + blank +
//IM units
unit;
sw.WriteLine(s);
}
}
catch (Exception ex)
{
result = false;
}
finally
{
sw.Close();
fs.Close();
}
return(result);
}
/// <summary>
/// 将IVH扫描参数header，扫描项列表entries保存到文件fileName
/// </summary>
/// <param name="fileName"></param>
/// <param name="entries"></param>
/// <param name="header"></param>
internal static void Save_Csv_IVH(string fileName, CsvReport_IVH_Entry[] entries, CsvReport_PIVH_Header header)
{
StreamWriter sw = null;
try
{
sw = new StreamWriter(fileName, false, Encoding.ASCII);
string s1;
if (header.Swp_Type == SweepType.Freq_Sweep)
{
s1 = "Frequency Sweep ";
}
else
{
s1 = "Time Sweep ";
}
string s2 = "Start " + header.Sweep_Start.ToString("0.#") + " " +
"Stop " + header.Sweep_Stop.ToString("0.#") + " " +
"Point Number " + header.Point_Num.ToString() + " " +
"Limit Value " + header.Limit_Value.ToString("0.#");
string sparams = "params " +
((int)header.Swp_Type).ToString() + " " +
"0 " +
"3 " +
header.Sweep_Start.ToString("0.#") + " " +
header.Sweep_Stop.ToString("0.#") + " " +
header.Point_Num.ToString() + " " +
header.Limit_Value.ToString("0.#") + " " +
header.Y_Max_RL.ToString("0.#") + " " +
header.Y_Min_RL.ToString("0.#") + " " +
header.Y_Max_VSWR.ToString("0.#") + " " +
header.Y_Min_VSWR.ToString("0.#");
sw.WriteLine(header.Mac_Desc);
sw.WriteLine(header.Date_Time);
sw.WriteLine(s1);
sw.WriteLine(s2);
sw.WriteLine(sparams);
sw.WriteLine("Tx Out(dbm) Im Value(dbc) Frequency(MHz)");
sw.WriteLine("NO., P, F, Value, Noise, RL");
string s3;
for (int i = 0; i < entries.Length; i++)
{
s3 = entries[i].No.ToString() + ", " +
entries[i].P.ToString("0.0000000") + ", " +
entries[i].F.ToString("0.0000000") + ", " +
entries[i].IVH_Value.ToString("0.0000000") + ", " +
entries[i].Noise.ToString("0.0000000") + ", " +
entries[i].Rl.ToString("0.0000000");
sw.WriteLine(s3);
}
sw.Flush();
sw.Close();
sw.Dispose();
} catch {
if (sw != null)
{
sw.Close();
sw.Dispose();
}
}
}
/// <summary>
/// 将互调扫描参数header，互调扫描项列表entries保存到文件fileName
/// </summary>
/// <param name="fileName"></param>
/// <param name="entries"></param>
/// <param name="header"></param>
internal static void Save_Csv_Pim(string fileName, CsvReport_Pim_Entry[] entries, CsvReport_PIVH_Header header)
{
StreamWriter sw = null;
try
{
sw = new StreamWriter(fileName, false, Encoding.ASCII);
string s1;
if (header.Swp_Type == SweepType.Freq_Sweep)
{
s1 = "Frequency Sweep ";
}
else
{
s1 = "Time Sweep ";
}
string s2;
if (header.Im_Schema == ImSchema.FWD)
{
s2 = "FWD ";
}
else
{
s2 = "REV ";
}
string s3 = "Start " + header.Sweep_Start.ToString("0.#") + " " +
"Stop " + header.Sweep_Stop.ToString("0.#") + " " +
"Point Number " + header.Point_Num.ToString() + " " +
"Limit Value " + header.Limit_Value.ToString("0.#");
string sparams = "params " +
((int)header.Swp_Type).ToString() + " " +
((int)header.Im_Schema).ToString() + " " +
((int)header.Im_Order).ToString() + " " +
header.Sweep_Start.ToString("0.#") + " " +
header.Sweep_Stop.ToString("0.#") + " " +
header.Point_Num.ToString() + " " +
header.Limit_Value.ToString("0.#") + " " +
header.N.ToString();
sw.WriteLine(header.Mac_Desc);
sw.WriteLine(header.Date_Time);
sw.WriteLine(s1 + s2 + "Im Order " + ((int)header.Im_Order).ToString());
sw.WriteLine(s3);
sw.WriteLine(sparams);
sw.WriteLine("Tx Out(dbm) Im Value(dbc) Frequency(MHz)");
sw.WriteLine("NO., P1, F1, P2, F2, Im_V, Im_F");
string s4;
for (int i = 0; i < entries.Length; i++)
{
s4 = entries[i].No.ToString() + ", " +
entries[i].P1.ToString("0.0000000") + ", " +
entries[i].F1.ToString("0.0000000") + ", " +
entries[i].P2.ToString("0.0000000") + ", " +
entries[i].F2.ToString("0.0000000") + ", " +
entries[i].Im_V.ToString("0.0000000") + ", " +
entries[i].Im_F.ToString("0.0000000");
sw.WriteLine(s4);
}
sw.Flush();
sw.Close();
sw.Dispose();
} catch {
if (sw != null)
{
sw.Close();
sw.Dispose();
}
}
}