/// <summary>
/// 扫描文件导入数据库
/// </summary>
public void ScanDirInfo()
{
String[] drives = Environment.GetLogicalDrives();
if (File.Exists(drives[drives.Length - 1] + "List.lis"))
{
string filecontent = WriteDataToFile.ReadFile(drives[drives.Length - 1] + "List.lis");
filecontent = filecontent.Remove(filecontent.Length - 1);
string[] ct = filecontent.Split(';');
char[] f1 = ct[0].ToArray();
string[] TaskNames = filecontent.Remove(0, 2).Split(';'); //任务名称集合
int num = Convert.ToInt32(f1[0].ToString() + f1[1].ToString()); //预定任务数量
if (num != ct.Length)
{
//错误
num = ct.Length;
WriteDataToFile.UpadataStringOfFile(drives[drives.Length - 1] + "List.lis", 0,
NumCorrection.KeepNum(num.ToString(), 2, HeadOrTail.Head));
}
foreach (var Tn in TaskNames)
{
string taskPath = drives[drives.Length - 1] + Tn;
int hashcode = UseUpanDoWork.LocalUsb.ReadJob(taskPath + "\\" + "Jobtask.dat").Information.GetHashCode();
if (false == WorkingSets.local.rowsIsOfResuly(hashcode.ToString()))
{
Insertdatabyupan inser = new Insertdatabyupan(taskPath);
inser.InsertUpandatatodatabase();
}
else
{
continue;
}
}
}
}
/// <summary>
/// 创建List.lis文件
/// </summary>
/// <param name="path"></param>
/// <param name="Content"></param>
private static void CreateListlis(string path, string Content)
{
string LisContent = string.Empty;
WriteDataToFile.WriteFile(path, Content + ";");
if (File.Exists(path))
{
LisContent = WriteDataToFile.ReadFile(path);
}
string JustLisContent = LisContent.Remove(0, 2);
string[] tempdata = JustLisContent.Split(';');
List <string> list = new List <string>();
list.Clear();
for (int i = 0; i < tempdata.Length - 1; i++) //遍历数组成员
{
if (list.IndexOf(tempdata[i]) == -1) //对每个成员做一次新数组查询如果没有相等的则加到新数组
{
list.Add(tempdata[i]);
}
}
WriteDataToFile.FileBaseDeel(path, MyFileMode.Clear);
string[] tda = list.ToArray();
string outdata = string.Empty;
foreach (string a in tda)
{
outdata += (a + ";");
}
WriteDataToFile.WriteFile(path, NumCorrection.KeepNum(NumCorrection.Ten2Hex(list.Count.ToString()),
2, HeadOrTail.Head) + outdata);
// WriteDataToFile.UpadataStringOfFile(path, 0, NumCorrection.KeepNum(num.ToString(), 2, HeadOrTail.Head));
}
private static DcresistaceUpandata[] ReadDcresisitance(string DcPath)
{
try
{
string[] filenum = Directory.GetFiles(DcPath);
DcresistaceUpandata[] DcresData = new DcresistaceUpandata[filenum.Length];
for (int i = 1; i <= filenum.Length; i++)
{
if (File.Exists(DcPath + "\\" + NumCorrection.KeepNum(i.ToString(), 2, HeadOrTail.Head) + ".ini"))
{
INIFiLE myini = new INIFiLE(DcPath + "\\" + NumCorrection.KeepNum(i.ToString(), 2, HeadOrTail.Head) + ".ini");
DcresData[i - 1].Data = myini.ReadString("result", "Date", "");
DcresData[i - 1].Time = myini.ReadString("result", "Time", "");
DcresData[i - 1].Position = myini.ReadString("result", "试验位置", "");
DcresData[i - 1].Windingconfige = myini.ReadString("result", "绕组类型", "");
DcresData[i - 1].Av = myini.ReadString("result", "VA", "");
DcresData[i - 1].Ai = myini.ReadString("result", "IA", "");
DcresData[i - 1].Ar = myini.ReadString("result", "RA", "");
DcresData[i - 1].Bv = myini.ReadString("result", "VB", "");
DcresData[i - 1].Bi = myini.ReadString("result", "IB", "");
DcresData[i - 1].Br = myini.ReadString("result", "RB", "");
DcresData[i - 1].Cv = myini.ReadString("result", "VC", "");
DcresData[i - 1].Ci = myini.ReadString("result", "IC", "");
DcresData[i - 1].Cr = myini.ReadString("result", "RC", "");
DcresData[i - 1].Error = myini.ReadString("result", "Error", "");
}
}
return(DcresData);
}
catch
{
throw new Exception("直流电阻地址不存在");
}
}
private static CaptanceUpandata[] ReadCaptance(string DciPath)
{
try
{
string[] filenum = Directory.GetFiles(DciPath);
CaptanceUpandata[] DciData = new CaptanceUpandata[filenum.Length];
for (int i = 1; i <= filenum.Length; i++)
{
if (File.Exists(DciPath + "\\" + NumCorrection.KeepNum(i.ToString(), 2, HeadOrTail.Head) + ".ini"))
{
INIFiLE myini = new INIFiLE(DciPath + "\\" + NumCorrection.KeepNum(i.ToString(), 2, HeadOrTail.Head) + ".ini");
DciData[i - 1].Data = myini.ReadString("result", "Date", "");
DciData[i - 1].Time = myini.ReadString("result", "Time", "");
DciData[i - 1].Position = myini.ReadString("result", "试验位置", "");
DciData[i - 1].TestKind = myini.ReadString("result", "试验模式", "");
DciData[i - 1].Volate = myini.ReadString("result", "Vo", "");
DciData[i - 1].Fre = myini.ReadString("result", "Fr", "");
DciData[i - 1].Cx = myini.ReadString("result", "Cx", "");
DciData[i - 1].Tan = myini.ReadString("result", "tan", "");
DciData[i - 1].Error = myini.ReadString("result", "Error", "");
}
}
return(DciData);
}
catch { throw new Exception("介质损耗地址错误"); }
}
private static DcInlutionUpandata[] ReadDcinlution(string DciPath)
{
try
{
string[] filenum = Directory.GetFiles(DciPath);
DcInlutionUpandata[] DciData = new DcInlutionUpandata[filenum.Length];
for (int i = 1; i <= filenum.Length; i++)
{
if (File.Exists(DciPath + "\\" + NumCorrection.KeepNum(i.ToString(), 2, HeadOrTail.Head) + ".ini"))
{
INIFiLE myini = new INIFiLE(DciPath + "\\" + NumCorrection.KeepNum(i.ToString(), 2, HeadOrTail.Head) + ".ini");
DciData[i - 1].Data = myini.ReadString("result", "Date", "");
DciData[i - 1].Time = myini.ReadString("result", "Time", "");
DciData[i - 1].Position = myini.ReadString("result", "试验位置", "");
DciData[i - 1].PreResistance = myini.ReadString("result", "保护阻值", "");
DciData[i - 1].JyxxM = myini.ReadString("result", "绝缘下限", "");
DciData[i - 1].AbsM = myini.ReadString("result", "吸收比下限", "");
DciData[i - 1].Volate = myini.ReadString("result", "Vo", "");
DciData[i - 1].Resistance = myini.ReadString("result", "R", "");
DciData[i - 1]._0_15 = myini.ReadString("result", "0:15", "");
DciData[i - 1]._1_00 = myini.ReadString("result", "1:00", "");
DciData[i - 1].Abs = myini.ReadString("result", "吸收比", "");
DciData[i - 1].Jhzs = myini.ReadString("result", "极化指数", "");
DciData[i - 1].Error = myini.ReadString("result", "Error", "");
}
}
return(DciData);
}
catch { throw new Exception("绝缘电阻地址错误"); }
}
public string CreateTrans(JobList job)
{
TransformerWindingConfigStruct wt = job.Transformer.WindingConfig;
int PhyNum = job.Transformer.PhaseNum;
string TransName = NumCorrection.KeepNumSpace(job.Transformer.SerialNo, 64, HeadOrTail.Tail);
string TransID = NumCorrection.KeepNumSpace(job.Transformer.ID.ToString(), 10, HeadOrTail.Tail);
string PhyNumStr = string.Empty;
if (PhyNum == 2)
{
PhyNumStr = "01";
}
else
{
PhyNumStr = "00";
}
string WindConFig = ParsingWindConfig(job);//2/3
string KindNum = ParsingWingKing(job);
string HTamMessage;
if (job.Transformer.OLTC.WindingPosition == WindingType.HV)
{
HTamMessage = ParsingNum(job.Transformer.OLTC.TapNum) +
ParsingNum(job.Transformer.OLTC.TapMainNum) + "00" +
NumCorrection.DoubleToHexNum(job.Transformer.OLTC.Step);
}
else
{
HTamMessage = "0000000000";
}
string MTamMessage;
if (job.Transformer.OLTC.WindingPosition == WindingType.MV)
{
MTamMessage = ParsingNum(job.Transformer.OLTC.TapNum) +
ParsingNum(job.Transformer.OLTC.TapMainNum) + "00" +
NumCorrection.DoubleToHexNum(job.Transformer.OLTC.Step);
}
else
{
MTamMessage = "0000000000";
}
//job.Transformer.OLTC.Step==0.0124;
string p1 = NumCorrection.Ten2Hex(((job.Transformer.PowerRating.HV) * 1000).ToString());
string p2 = NumCorrection.Ten2Hex(((job.Transformer.PowerRating.MV) * 1000).ToString());
string p3 = NumCorrection.Ten2Hex(((job.Transformer.PowerRating.LV) * 1000).ToString());
string PowerRating = NumCorrection.KeepNum(p1, 8, HeadOrTail.Head) + NumCorrection.KeepNum(p2, 8, HeadOrTail.Head) + NumCorrection.KeepNum(p3, 8, HeadOrTail.Head);
string v1 = NumCorrection.Ten2Hex(((job.Transformer.VoltageRating.HV) * 1000).ToString());
string v2 = NumCorrection.Ten2Hex(((job.Transformer.VoltageRating.MV) * 1000).ToString());
string v3 = NumCorrection.Ten2Hex(((job.Transformer.VoltageRating.LV) * 1000).ToString());
string VoltageRating = NumCorrection.KeepNum(v1, 8, HeadOrTail.Head) + NumCorrection.KeepNum(v2, 8, HeadOrTail.Head) + NumCorrection.KeepNum(v3, 8, HeadOrTail.Head);
return(TransName + TransID + PhyNumStr
+ WindConFig + KindNum + HTamMessage + MTamMessage + PowerRating + VoltageRating);
// string
}
private static OltcUpandata[] ReadOltc(string DciPath)
{
try
{
string[] filenum = Directory.GetFiles(DciPath);
OltcUpandata[] DciData = new OltcUpandata[filenum.Length];
for (int i = 1; i <= filenum.Length; i++)
{
if (File.Exists(DciPath + "\\" + NumCorrection.KeepNum(i.ToString(), 2, HeadOrTail.Head) + ".ini"))
{
INIFiLE myini = new INIFiLE(DciPath + "\\" + NumCorrection.KeepNum(i.ToString(), 2, HeadOrTail.Head) + ".ini");
DciData[i - 1].Data = myini.ReadString("result", "Date", "");
DciData[i - 1].Time = myini.ReadString("result", "Time", "");
DciData[i - 1].Windkind = myini.ReadString("result", "绕组类型", "");
DciData[i - 1].windposition = myini.ReadString("result", "分接位置", "");
DciData[i - 1].Current = myini.ReadString("result", "试验电流", "");
DciData[i - 1].Protectresistance = myini.ReadString("result", "触发电阻", "");
DciData[i - 1].Starttime = myini.ReadString("result", "触发时间", "");
for (int j = 1; j < 25; j++)
{
DciData[i - 1].Awaveform += myini.ReadString("result", "A" +
NumCorrection.KeepNum(j.ToString(), 2, HeadOrTail.Head), "");
}
DciData[i - 1].Awaveform += myini.ReadString("result", "AED", "");
for (int j = 1; j < 25; j++)
{
DciData[i - 1].Bwaveform += myini.ReadString("result", "B" +
NumCorrection.KeepNum(j.ToString(), 2, HeadOrTail.Head), "");
}
DciData[i - 1].Bwaveform += myini.ReadString("result", "BED", "");
for (int j = 1; j < 25; j++)
{
DciData[i - 1].Cwaveform += myini.ReadString("result", "C" +
NumCorrection.KeepNum(j.ToString(), 2, HeadOrTail.Head), "");
}
DciData[i - 1].Cwaveform += myini.ReadString("result", "CED", "");
for (int j = 1; j < 25; j++)
{
DciData[i - 1].Dwaveform += myini.ReadString("result", "D" +
NumCorrection.KeepNum(j.ToString(), 2, HeadOrTail.Head), "");
}
DciData[i - 1].Dwaveform += myini.ReadString("result", "DED", "");
DciData[i - 1].Error = myini.ReadString("result", "Error", "");
}
}
return(DciData);
}
catch { throw new Exception("有载分接地址错误"); }
}
public string CreateTestList()
{
#region Enable
string[] TestNum = new string[8];
if (rc.CaPaNumEnable == true)
{
TestNum[0] = "01";
}
else
{
TestNum[0] = "00";
}
if (rc.DcReNumEnable == true)
{
TestNum[2] = "01";
}
else
{
TestNum[2] = "00";
}
if (rc.DcInNUmEnable == true)
{
TestNum[1] = "01";
}
else
{
TestNum[1] = "00";
}
if (rc.OltcNumEnable == true)
{
TestNum[3] = "01";
}
else
{
TestNum[3] = "00";
}
TestNum[4] = "00";
TestNum[5] = "00";
TestNum[6] = "00";
TestNum[7] = "00";
#endregion
string TestListTask = CreateSortTest();
int TestCount = res.Count + dci.Count + cap.Count + Oltc.Count;
return(NumCorrection.KeepNum(NumCorrection.Ten2Hex(TestCount.ToString()), 2, HeadOrTail.Head) + string.Join("", TestNum) + TestListTask);
}
private string CreateOLTcPra(MeasurementItemStruct mi, JobList job, int oltcnum)
{
string Position = "00";
if (mi.Winding == WindingType.HV)
{
Position = "00";
}
else
{
Position = "01";
}
rc.OltcNum++;
rc.OltcNumEnable = true;
return("00" + Position + NumCorrection.KeepNum(oltcnum.ToString(), 2, HeadOrTail.Head) + "05" + "20");
}
/// <summary>
/// 将四个功能的测量等功能写入文件
/// </summary>
/// <param name="respath"></param>
/// <param name="dcipath"></param>
/// <param name="cappath"></param>
/// <param name="oltcpath"></param>
private static void CreateWorkList(string respath, string dcipath, string cappath, string oltcpath)
{
var result = UseUpanDoWork.LocalUsb.ReturnTestResult();
string dciComman = NumCorrection.KeepNum(NumCorrection.Ten2Hex(result[0].dci.Count().ToString()),
2, HeadOrTail.Head) + string.Join("", result[0].dci);
string resComman = NumCorrection.KeepNum(NumCorrection.Ten2Hex(result[0].res.Count().ToString()),
2, HeadOrTail.Head) + string.Join("", result[0].res);
string capComman = NumCorrection.KeepNum(NumCorrection.Ten2Hex(result[0].cap.Count().ToString()),
2, HeadOrTail.Head) + string.Join("", result[0].cap);
string oltcComman = NumCorrection.KeepNum(NumCorrection.Ten2Hex(result[0].oltc.Count().ToString()),
2, HeadOrTail.Head) + string.Join("", result[0].oltc);
if (dciComman.Length != 2)
{
WriteDataToFile.WriteFile(dcipath, dciComman);
}
else
{
WriteDataToFile.WriteFile(dcipath, "");
}
if (resComman.Length != 2)
{
WriteDataToFile.WriteFile(respath, resComman);
}
else
{
WriteDataToFile.WriteFile(respath, "");
}
if (capComman.Length != 2)
{
WriteDataToFile.WriteFile(cappath, capComman);
}
else
{
WriteDataToFile.WriteFile(cappath, "");
}
if (oltcComman.Length != 2)
{
WriteDataToFile.WriteFile(oltcpath, oltcComman);
}
else
{
WriteDataToFile.WriteFile(oltcpath, "");
}
}
private string CreateOLTcPra(MeasurementItemStruct mi, JobList job, int oltcnum)
{
string Position = GetTapLabel(mi).ToString("X2");
if (mi.Winding == WindingType.HV)
{
Position = "00";
}
else
{
Position = "01";
}
rc.OltcNum++;
rc.OltcNumEnable = true;
return(GetCurrent(GetParameter.GetPraDCResistanceCurrentUpanSpa(mi, job)) +
Position + NumCorrection.KeepNum(oltcnum.ToString(), 2, HeadOrTail.Head) + "05" + "20");
}
//先创建测量数据再创建测量列表
public void StartBuiltTestData(MeasurementItemStruct mi, JobList job)
{
switch (mi.Function)
{
case MeasurementFunction.DCInsulation:
dci.Add(CreateDCInsulationPra(mi, job));
dci1.Add(NumCorrection.KeepNum(NumKind.ToString(), 2, HeadOrTail.Head) + CreateDCInsulationPra(mi, job));
NumKind++;
break;
case MeasurementFunction.BushingDCInsulation:
dci.Add(CreateDCInsulationPra(mi, job));
dci1.Add(NumCorrection.KeepNum(NumKind.ToString(), 2, HeadOrTail.Head) + CreateDCInsulationPra(mi, job));
NumKind++;
break;
case MeasurementFunction.Capacitance:
cap.Add(CreateCapacitancePra(mi, job));
cap1.Add(NumCorrection.KeepNum(NumKind.ToString(), 2, HeadOrTail.Head) + CreateCapacitancePra(mi, job));
NumKind++;
break;
case MeasurementFunction.BushingCapacitance:
cap.Add(CreateCapacitancePra(mi, job));
cap1.Add(NumCorrection.KeepNum(NumKind.ToString(), 2, HeadOrTail.Head) + CreateCapacitancePra(mi, job));
NumKind++;
break;
case MeasurementFunction.DCResistance: //直流电阻
res.Add(CreateDcResistancePra(mi, job));
res1.Add(NumCorrection.KeepNum(NumKind.ToString(), 2, HeadOrTail.Head) + CreateDcResistancePra(mi, job));
NumKind++;
break;
case MeasurementFunction.OLTCSwitchingCharacter:
Oltc.Add(CreateOLTcPra(mi, job, OltcNum));
Oltc1.Add(NumCorrection.KeepNum(NumKind.ToString(), 2, HeadOrTail.Head) + CreateOLTcPra(mi, job, OltcNum));
NumKind++;
OltcNum++;
break;
}
}
public string[] GetTaskName()
{
String[] drives = Environment.GetLogicalDrives();
if (File.Exists(drives[drives.Length - 1] + "List.lis"))
{
string filecontent = WriteDataToFile.ReadFile(drives[drives.Length - 1] + "List.lis");
filecontent = filecontent.Remove(filecontent.Length - 1);
string[] ct = filecontent.Split(';');
char[] f1 = ct[0].ToArray();
string[] TaskNames = filecontent.Remove(0, 2).Split(';'); //任务名称集合
int num = Convert.ToInt32("0x" + f1[0].ToString() + f1[1].ToString(), 16); //预定任务数量
if (num != ct.Length)
{
//错误
num = ct.Length;
WriteDataToFile.UpadataStringOfFile(drives[drives.Length - 1] + "List.lis", 0,
NumCorrection.KeepNum(num.ToString(), 2, HeadOrTail.Head));
}
return(TaskNames);
}
return(null);
}
private string CreateSortTest()
{
string[] NeedSortBuffet = new string[res1.Count + cap1.Count + dci1.Count + Oltc1.Count];
if (res1 != null)
{
for (int i = 0; i < res1.Count; i++)
{
if (NumCorrection.GetNumForstring(res1[i]) >= 0)
{
string TaskKind = "03";
string TaskNum = NumCorrection.KeepNum(NumCorrection.Ten2Hex(i.ToString()), 2, HeadOrTail.Head);//resisitance 对应任务号
string DcresEnable = "01";
NeedSortBuffet[NumCorrection.GetNumForstring(res1[i])] = TaskKind + TaskNum + DcresEnable;
}
}
}
if (cap1 != null)
{
for (int i = 0; i < cap1.Count; i++)
{
if (NumCorrection.GetNumForstring(cap1[i]) >= 0)
{
string TaskKind = "01";
string TaskNum = NumCorrection.KeepNum(NumCorrection.Ten2Hex(i.ToString()), 2, HeadOrTail.Head);//resisitance 对应任务号
string DcresEnable = "01";
NeedSortBuffet[NumCorrection.GetNumForstring(cap1[i])] = TaskKind + TaskNum + DcresEnable;
// NeedSortBuffet[NumCorrection.GetNumForstring(cap1[i])] = cap[i];
}
}
}
if (dci1 != null)
{
for (int i = 0; i < dci1.Count; i++)
{
if (NumCorrection.GetNumForstring(dci1[i]) >= 0)
{
string TaskKind = "02";
string TaskNum = NumCorrection.KeepNum(NumCorrection.Ten2Hex(i.ToString()), 2, HeadOrTail.Head);//resisitance 对应任务号
string DcresEnable = "01";
NeedSortBuffet[NumCorrection.GetNumForstring(dci1[i])] = TaskKind + TaskNum + DcresEnable;
// NeedSortBuffet[NumCorrection.GetNumForstring(dci1[i])] = dci[i];
}
}
}
if (Oltc1 != null)
{
for (int i = 0; i < Oltc1.Count; i++)
{
if (NumCorrection.GetNumForstring(Oltc1[i]) >= 0)
{
string TaskKind = "04";
string TaskNum = NumCorrection.KeepNum(NumCorrection.Ten2Hex(i.ToString()), 2, HeadOrTail.Head);//resisitance 对应任务号
string DcresEnable = "01";
NeedSortBuffet[NumCorrection.GetNumForstring(Oltc1[i])] = TaskKind + TaskNum + DcresEnable;
// NeedSortBuffet[NumCorrection.GetNumForstring(Oltc1[i])] = Oltc[i];
}
}
}
for (int i = 0; i < NeedSortBuffet.Length; i++)
{
if (NeedSortBuffet[i] == null)
{
NeedSortBuffet[i] = "00";
}
}
return(string.Join("", NeedSortBuffet));
}
//介损供体
private string CreateCapacitancePra(MeasurementItemStruct mi, JobList job)
{
if (mi.Terimal == null)
{
string CapacitanceVoltage = "00";
CapacitanceVoltage = GetParameter.GetPraCapacitanceVoltageNum(job);
string Fre = "01";
string Wt = "01";
rc.CaPaNum++;
rc.CaPaNumEnable = true;
return(CapacitanceVoltage + Fre + Wt + NumCorrection.KeepNum(((int)mi.Winding.ToJSstation()).ToString(), 2, HeadOrTail.Head));
}
else
{
Parameter.JSstation Jsposition;
string Windingkind = null;
if (mi.Winding == WindingType.HV)
{
Jsposition = Parameter.JSstation.高压套管A + (((int)mi.Terimal[0] + 3) % 4);
}
else
{
Jsposition = Parameter.JSstation.中压套管A + (((int)mi.Terimal[0] + 3) % 4);
}
switch (Jsposition)
{
case Parameter.JSstation.高压套管A:
Windingkind = "03";
break;
case Parameter.JSstation.高压套管B:
Windingkind = "04";
break;
case Parameter.JSstation.高压套管C:
Windingkind = "05";
break;
case Parameter.JSstation.高压套管0:
Windingkind = "06";
break;
case Parameter.JSstation.中压套管A:
Windingkind = "07";
break;
case Parameter.JSstation.中压套管B:
Windingkind = "08";
break;
case Parameter.JSstation.中压套管C:
Windingkind = "09";
break;
case Parameter.JSstation.中压套管0:
Windingkind = "0A";
break;
default:
Windingkind = "03";
break;
}
string CapacitanceVoltage = GetParameter.GetPraCapacitanceVoltageNum(job);
string Fre = "01";
string Wt = "00";
rc.CaPaNum++;
rc.CaPaNumEnable = true;
return(CapacitanceVoltage + Fre + Wt + Windingkind);
}
}