public void Allshort(string projectSUID, string projectid, int dulutype, double ratecaplity)
{
int cishu = 0; //��¼�ڶ��ٴγ����ڴ�����
try
{
if (!CheckDL(projectSUID, projectid, ratecaplity))
{
return;
}
System.Windows.Forms.Clipboard.Clear();
Dictionary<int, double> nodeshorti = new Dictionary<int, double>(); //��¼ĸ����û�н��й���·
KeyValuePair<int, double> maxshorti = new KeyValuePair<int, double>(); //ȡ����·������·����
string con = ",PSP_ELCDEVICE WHERE PSPDEV.SUID = PSP_ELCDEVICE.DeviceSUID AND PSP_ELCDEVICE.ProjectSUID = '" + projectSUID + "'AND PSPDEV.type='01'AND PSPDEV.KSwitchStatus = '0' order by PSPDEV.number";
PSPDEV pspDev = new PSPDEV();
IList list1 = UCDeviceBase.DataService.GetList("SelectPSPDEVByCondition", con);
PSPDEV psp = new PSPDEV();
string data = System.DateTime.Now.ToString("d");
string time = System.DateTime.Now.ToString("T");
string duanResult = null;
duanResult += "��·�������" + "\r\n" + "\r\n";
duanResult += "��·��ҵ�ţ�1" + "\r\n";
duanResult += "��·�������ڣ�" + data + " " + "ʱ�䣺" + time + "\r\n";
duanResult += "���kA" + "\r\n";
string dianYaResult = null;
dianYaResult += "ĸ�ߵ�ѹ���" + "\r\n" + "\r\n";
dianYaResult += "��·��ҵ�ţ�1" + "\r\n";
dianYaResult += "��·�������ڣ�" + data + " " + "ʱ�䣺" + time + "\r\n";
dianYaResult += "��λ����ֵ( p.u. ) �Ƕ�(deg.)" + "\r\n";
string dianLiuResult = null;
dianLiuResult += "֧·�������" + "\r\n" + "\r\n";
dianLiuResult += "��·��ҵ�ţ�1" + "\r\n";
dianLiuResult += "��·�������ڣ�" + data + " " + "ʱ�䣺" + time + "\r\n";
dianLiuResult += "��λ����ֵ( p.u. ) �Ƕ�(deg.)" + "\r\n";
int intshorti = 0; //��һ�м�¼��ΪҪ����·����������˵��
bool shortiflag = false;
int muxiannum = 0; //��¼һ��ĸ�߶�·�� �ж��ٸ���¼ĸ�ߵ�ѹ
int linenum = 0; //��¼һ��ĸ�߶�· �ж��ٸ���·����
shortbuscir shortCutCal = new shortbuscir(Compuflag);
for (int i = 0; i < list1.Count; i++)
{
cishu++;
pspDev = list1[i] as PSPDEV;
bool flag = false;
string dlr = null;
con = " ,PSP_ELCDEVICE WHERE PSPDEV.SUID = PSP_ELCDEVICE.DeviceSUID AND PSP_ELCDEVICE.ProjectSUID = '" + projectSUID + "'AND PSPDEV.type='05'AND(PSPDEV.IName='" + pspDev.Name + "'OR PSPDEV.JName='" + pspDev.Name + "') AND PSPDEV.KSwitchStatus = '0'order by PSPDEV.number";
IList list2 = UCDeviceBase.DataService.GetList("SelectPSPDEVByCondition", con);
for (int j = 0; j < list2.Count; j++)
{
psp = list2[j] as PSPDEV;
con = " WHERE Name='" + psp.ISwitch + "' AND ProjectID = '" + projectid + "'" + "AND Type='07'";
IList listiswitch = UCDeviceBase.DataService.GetList("SelectPSPDEVByCondition", con);
con = " WHERE Name='" + psp.JSwitch + "' AND ProjectID = '" + projectid + "'" + "AND Type='07'";
IList listjswitch = UCDeviceBase.DataService.GetList("SelectPSPDEVByCondition", con);
PSPDEV pspiswitch = (PSPDEV)listiswitch[0];
PSPDEV pspjswitch = (PSPDEV)listjswitch[0];
if (pspDev.Number == psp.FirstNode && pspiswitch.KSwitchStatus == "0" && pspjswitch.KSwitchStatus == "0")
{
flag = true;
dlr = "0" + " " + psp.FirstNode + " " + psp.LastNode + " " + psp.Number + " " + "0 " + " " + dulutype;
}
if (pspDev.Number == psp.LastNode && pspiswitch.KSwitchStatus == "0" && pspjswitch.KSwitchStatus == "0")
{
flag = true;
dlr = "0" + " " + psp.FirstNode + " " + psp.LastNode + " " + psp.Number + " " + "1 " + " " + dulutype;
}
if (File.Exists(System.Windows.Forms.Application.StartupPath + "\\fault.txt"))
{
File.Delete(System.Windows.Forms.Application.StartupPath + "\\fault.txt");
}
if (flag)
{
break; //������ѭ�� ����ĸ�ߵ�����һ��ĸ�߶�·
}
if (!flag)
continue;
//������
}
//�����һ����·��û�������������н���
if (!flag)
{
con = " ,PSP_ELCDEVICE WHERE PSPDEV.SUID = PSP_ELCDEVICE.DeviceSUID AND PSP_ELCDEVICE.ProjectSUID = '" + projectSUID + "'AND PSPDEV.type='02'AND PSPDEV.KSwitchStatus = '0'and (PSPDEV.IName='" + pspDev.Name + "'OR PSPDEV.JName='" + pspDev.Name + "') order by PSPDEV.number";
IList list3 = UCDeviceBase.DataService.GetList("SelectPSPDEVByCondition", con);
for (int j = 0; j < list3.Count; j++)
{
dlr = null;
psp = list3[j] as PSPDEV;
//PSPDEV devFirst = new PSPDEV();
//con = " WHERE Name='" + psp.IName + "' AND ProjectID = '" + projectid + "'" + "AND Type='01'";
//devFirst = (PSPDEV)UCDeviceBase.DataService.GetObject("SelectPSPDEVByCondition", con);
//PSPDEV devLast = new PSPDEV();
//con = " WHERE Name='" + psp.JName + "' AND ProjectID = '" + projectid + "'" + "AND Type='01'";
//devLast = (PSPDEV)UCDeviceBase.DataService.GetObject("SelectPSPDEVByCondition", con);
con = " WHERE Name='" + psp.ISwitch + "' AND ProjectID = '" + projectid + "'" + "AND Type='07'";
IList listiswitch = UCDeviceBase.DataService.GetList("SelectPSPDEVByCondition", con);
con = " WHERE Name='" + psp.JSwitch + "' AND ProjectID = '" + projectid + "'" + "AND Type='07'";
IList listjswitch = UCDeviceBase.DataService.GetList("SelectPSPDEVByCondition", con);
PSPDEV pspiswitch = (PSPDEV)listiswitch[0];
PSPDEV pspjswitch = (PSPDEV)listjswitch[0];
if (pspDev.Number == psp.FirstNode && pspiswitch.KSwitchStatus == "0" && pspjswitch.KSwitchStatus == "0")
{
flag = true;
dlr = "0" + " " + psp.FirstNode + " " + psp.LastNode + " " + psp.Number + " " + "0" + " " + dulutype;
}
if (pspDev.Number == psp.LastNode && pspiswitch.KSwitchStatus == "0" && pspjswitch.KSwitchStatus == "0")
{
flag = true;
dlr = "0" + " " + psp.FirstNode + " " + psp.LastNode + " " + psp.Number + " " + "1" + " " + dulutype;
}
if (flag)
{
break; //������ѭ�� ����ĸ�ߵ�����һ��ĸ�߶�·
}
if (!flag)
continue;
//������
}
}
if (!flag)
{
con = " ,PSP_ELCDEVICE WHERE PSPDEV.SUID = PSP_ELCDEVICE.DeviceSUID AND PSP_ELCDEVICE.ProjectSUID = '" + projectSUID + "'AND PSPDEV.type='03'AND(PSPDEV.IName='" + pspDev.Name + "'OR PSPDEV.JName='" + pspDev.Name + "'OR PSPDEV.KName='" + pspDev.Name + "')AND PSPDEV.KSwitchStatus = '0' order by PSPDEV.number";
IList list4 = UCDeviceBase.DataService.GetList("SelectPSPDEVByCondition", con);
for (int j = 0; j < list4.Count; j++)
{
dlr = null;
psp = list4[j] as PSPDEV;
//PSPDEV devINode = new PSPDEV();
//con = " WHERE Name='" + psp.IName + "' AND ProjectID = '" + projectid + "'" + "AND Type='01'";
//devINode = (PSPDEV)UCDeviceBase.DataService.GetObject("SelectPSPDEVByCondition", con);
//PSPDEV devJNode = new PSPDEV();
//con = " WHERE Name='" + psp.JName + "' AND ProjectID = '" + projectid + "'" + "AND Type='01'";
//devJNode = (PSPDEV)UCDeviceBase.DataService.GetObject("SelectPSPDEVByCondition", con);
//PSPDEV devKNode = new PSPDEV();
//con = " WHERE Name='" + psp.KName + "' AND ProjectID = '" + projectid + "'" + "AND Type='01'";
//devKNode = (PSPDEV)UCDeviceBase.DataService.GetObject("SelectPSPDEVByCondition", con);
con = " WHERE Name='" + psp.ISwitch + "' AND ProjectID = '" + projectid + "'" + "AND Type='07'";
IList listiswitch = UCDeviceBase.DataService.GetList("SelectPSPDEVByCondition", con);
con = " WHERE Name='" + psp.JSwitch + "' AND ProjectID = '" + projectid + "'" + "AND Type='07'";
IList listjswitch = UCDeviceBase.DataService.GetList("SelectPSPDEVByCondition", con);
con = " WHERE Name='" + psp.HuganLine1 + "' AND ProjectID = '" + projectid + "'" + "AND Type='07'";
IList listkswitch = UCDeviceBase.DataService.GetList("SelectPSPDEVByCondition", con);
PSPDEV pspiswitch = (PSPDEV)listiswitch[0];
PSPDEV pspjswitch = (PSPDEV)listjswitch[0];
PSPDEV pspkswitch = (PSPDEV)listkswitch[0];
if (pspDev.Number == psp.FirstNode && pspiswitch.KSwitchStatus == "0" && pspjswitch.KSwitchStatus == "0" && pspkswitch.KSwitchStatus == "0")
{
flag = true;
dlr = "0" + " " + psp.FirstNode + " " + psp.LastNode + " " + psp.Number + " " + "0" + " " + dulutype;
}
if (pspDev.Number == psp.LastNode && pspiswitch.KSwitchStatus == "0" && pspjswitch.KSwitchStatus == "0" && pspkswitch.KSwitchStatus == "0")
{
flag = true;
dlr = "0" + " " + psp.FirstNode + " " + psp.LastNode + " " + psp.Number + " " + "1" + " " + dulutype;
}
if (pspDev.Number == psp.Flag && pspiswitch.KSwitchStatus == "0" && pspjswitch.KSwitchStatus == "0" && pspkswitch.KSwitchStatus == "0")
{
flag = true;
dlr = "0" + " " + psp.FirstNode + " " + psp.Flag + " " + psp.Number + " " + "1" + " " + dulutype;
}
if (flag)
{
break; //������ѭ�� ����ĸ�ߵ�����һ��ĸ�߶�·
}
if (!flag)
continue;
//������
}
}
if (flag)
{
FileStream VK = new FileStream((System.Windows.Forms.Application.StartupPath + "\\fault.txt"), FileMode.OpenOrCreate);
StreamWriter str11 = new StreamWriter(VK);
str11.Write(dlr);
str11.Close();
if (File.Exists(System.Windows.Forms.Application.StartupPath + "\\ShortcuitI.txt"))
{
File.Delete(System.Windows.Forms.Application.StartupPath + "\\ShortcuitI.txt");
}
if (File.Exists(System.Windows.Forms.Application.StartupPath + "\\Sxdianliu.txt"))
{
File.Delete(System.Windows.Forms.Application.StartupPath + "\\Sxdianliu.txt");
}
if (File.Exists(System.Windows.Forms.Application.StartupPath + "\\Sxdianya.txt"))
{
File.Delete(System.Windows.Forms.Application.StartupPath + "\\Sxdianya.txt");
}
shortCutCal.Show_shortcir(Compuflag, OutType, 1);
GC.Collect();
//bool matrixflag=true; //�����ж��Ƿ��ɾ����������Ƿ���������
string matrixstr = null;
if (File.Exists(System.Windows.Forms.Application.StartupPath + "\\Zmatrixcheck.txt"))
{
matrixstr = "�����ɾ���";
// matrixflag = false;
}
if (File.Exists(System.Windows.Forms.Application.StartupPath + "\\Fmatrixcheck.txt"))
{
// matrixflag = false;
matrixstr += "�����ɾ���";
}
if (File.Exists(System.Windows.Forms.Application.StartupPath + "\\Lmatrixcheck.txt"))
{
//matrixflag = false;
matrixstr += "�����ɾ���";
}
if (matrixstr != null)
{
System.Windows.Forms.MessageBox.Show(matrixstr + "�����������������������ٽ��м��㣡", "��ʾ", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Information);
return;
}
if (File.Exists(System.Windows.Forms.Application.StartupPath + "\\ShortcuitI.txt"))
{
}
else
{
return;
}
FileStream shorcuit = new FileStream(System.Windows.Forms.Application.StartupPath + "\\ShortcuitI.txt", FileMode.Open);
StreamReader readLineGU = new StreamReader(shorcuit, System.Text.Encoding.Default);
string strLineGU;
string[] arrayGU;
char[] charSplitGU = new char[] { ' ' };
intshorti = 0;
while ((strLineGU = readLineGU.ReadLine()) != null)
{
arrayGU = strLineGU.Split(charSplitGU);
string[] shorti = new string[4];
shorti.Initialize();
int m = 0;
foreach (string str in arrayGU)
{
if (str != "")
{
shorti[m++] = str.ToString();
}
}
if (intshorti == 0)
{
if (!shortiflag)
{
duanResult += shorti[0] + "," + shorti[1] + "," + shorti[3] + "\r\n";
shortiflag = true;
}
}
else
duanResult += shorti[0] + "," + shorti[1] + "," + Convert.ToDouble(shorti[3]) * ratecaplity / (Math.Sqrt(3) * pspDev.ReferenceVolt) + "\r\n";
intshorti++;
}
readLineGU.Close();
if (OutType == 0)
{
//**��ȡ�����ѹ��ֵ
if (File.Exists(System.Windows.Forms.Application.StartupPath + "\\Sxdianya.txt"))
{
}
else
{
return;
}
FileStream dianYa = new FileStream(System.Windows.Forms.Application.StartupPath + "\\Sxdianya.txt", FileMode.Open);
StreamReader readLineDY = new StreamReader(dianYa, System.Text.Encoding.Default);
string strLineDY;
string[] arrayDY;
char[] charSplitDY = new char[] { ' ' };
strLineDY = readLineDY.ReadLine();
int j = 0;
muxiannum = 0;
while (strLineDY != null)
{
arrayDY = strLineDY.Split(charSplitDY);
int m = 0;
string[] dev = new string[14];
dev.Initialize();
foreach (string str in arrayDY)
{
if (str != "")
{
dev[m++] = str;
}
}
if (j == 0)
{
dianYaResult += "\r\n" + "����ĸ�ߣ�" + pspDev.Name + "\r\n";
dianYaResult += dev[0] + "," + dev[1] + "," + dev[2] + "," + dev[3] + "," + dev[4] + "," + dev[5] + "," + dev[6] + "," + dev[7] + "," + dev[8] + "," +
dev[9] + "," + dev[10] + "," + dev[11] + "," + dev[12] + "," + dev[13] + "\r\n";
}
else
{
bool dianyaflag = true; //�жϴ�ĸ���Ƕ�·��ĸ����һ���ĸ��
PSPDEV CR = new PSPDEV();
if (dev[1] != "du")
{
con = " WHERE Name='" + dev[1] + "' AND ProjectID = '" + projectid + "'" + "AND Type='01'";
CR = (PSPDEV)UCDeviceBase.DataService.GetObject("SelectPSPDEVByCondition", con);
if (CR == null)
{
dianyaflag = false;
}
}
//else
//{
// dianyaflag = false;
// CR.Name = duanluname;
// CR = (PSPDEV)UCDeviceBase.DataService.GetObject("SelectPSPDEVByNameANDSVG", CR);
//}
if (dianyaflag)
dianYaResult += dev[0] + "," + dev[1] + "," + Convert.ToDouble(dev[2]) * CR.ReferenceVolt + "," + dev[3] + "," + Convert.ToDouble(dev[4]) * CR.ReferenceVolt + "," + dev[5] + "," + Convert.ToDouble(dev[6]) * CR.ReferenceVolt + "," + dev[7] + "," + Convert.ToDouble(dev[8]) * CR.ReferenceVolt + "," +
dev[9] + "," + Convert.ToDouble(dev[10]) * CR.ReferenceVolt + "," + dev[11] + "," + Convert.ToDouble(dev[12]) * CR.ReferenceVolt + "," + dev[13] + "\r\n";
//else
// dianYaResult += dev[0] + "," + duanluname + "�϶�·��" + "," + Convert.ToDouble(dev[2]) * CR.ReferenceVolt + "," + dev[3] + "," + Convert.ToDouble(dev[4]) * CR.ReferenceVolt + "," + dev[5] + "," + Convert.ToDouble(dev[6]) * CR.ReferenceVolt + "," + dev[7] + "," + Convert.ToDouble(dev[8]) * CR.ReferenceVolt + "," +
// dev[9] + "," + Convert.ToDouble(dev[10]) * CR.ReferenceVolt + "," + dev[11] + Convert.ToDouble(dev[12]) * CR.ReferenceVolt + "," + dev[13] + "\r\n";
}
strLineDY = readLineDY.ReadLine();
muxiannum++;
j++;
}
readLineDY.Close();
//**��ȡ���������ֵ
if (File.Exists(System.Windows.Forms.Application.StartupPath + "\\Sxdianliu.txt"))
{
}
else
{
return;
}
FileStream dianLiu = new FileStream(System.Windows.Forms.Application.StartupPath + "\\Sxdianliu.txt", FileMode.Open);
StreamReader readLineDL = new StreamReader(dianLiu, System.Text.Encoding.Default);
string strLineDL;
string[] arrayDL;
char[] charSplitDL = new char[] { ' ' };
strLineDL = readLineDL.ReadLine();
j = 0;
linenum = 0;
while (strLineDL != null)
{
arrayDL = strLineDL.Split(charSplitDL);
int m = 0;
string[] dev = new string[15];
dev.Initialize();
foreach (string str in arrayDL)
{
if (str != "")
{
dev[m++] = str;
}
}
if (j == 0)
{
dianLiuResult += "\r\n" + "����ĸ�ߣ�" + pspDev.Name + "\r\n";
dianLiuResult += dev[0] + "," + dev[1] + "," + dev[2] + "," + dev[3] + "," + dev[4] + "," + dev[5] + "," + dev[6] + "," + dev[7] + "," + dev[8] + "," +
dev[9] + "," + dev[10] + "," + dev[11] + "," + dev[12] + "," + dev[13] + "," + dev[14] + "\r\n";
}
else
{
//��Ϊ����·�������ʱ����һ����·�ĵ��������������������·�ĵ������нӵص������͵翹���ĵ��������ֻ���������������
PSPDEV CR = new PSPDEV();
if (dev[0] != "du")
{
con = " WHERE Name='" + dev[0] + "' AND ProjectID = '" + projectid + "'" + "AND Type='01'";
}
else
con = " WHERE Name='" + dev[1] + "' AND ProjectID = '" + projectid + "'" + "AND Type='01'";
CR = (PSPDEV)UCDeviceBase.DataService.GetObject("SelectPSPDEVByCondition", con);
dianLiuResult += dev[0] + "," + dev[1] + "," + dev[2] + "," + Convert.ToDouble(dev[3]) * ratecaplity / (Math.Sqrt(3) * CR.ReferenceVolt) + "," + dev[4] + "," + Convert.ToDouble(dev[5]) * ratecaplity / (Math.Sqrt(3) * CR.ReferenceVolt) + "," + dev[6] + "," + Convert.ToDouble(dev[7]) * ratecaplity / (Math.Sqrt(3) * CR.ReferenceVolt) + "," + dev[8] + "," +
Convert.ToDouble(dev[9]) * ratecaplity / (Math.Sqrt(3) * CR.ReferenceVolt) + "," + dev[10] + "," + Convert.ToDouble(dev[11]) * ratecaplity / (Math.Sqrt(3) * CR.ReferenceVolt) + "," + dev[12] + "," + Convert.ToDouble(dev[13]) * ratecaplity / (Math.Sqrt(3) * CR.ReferenceVolt) + "," + dev[14] + "\r\n";
}
strLineDL = readLineDL.ReadLine();
j++;
linenum++;
}
readLineDL.Close();
}
}
}
//д�뱨����
if (File.Exists(System.Windows.Forms.Application.StartupPath + "\\result.csv"))
{
File.Delete(System.Windows.Forms.Application.StartupPath + "\\result.csv");
}
FileStream tempGU = new FileStream((System.Windows.Forms.Application.StartupPath + "\\result.csv"), FileMode.OpenOrCreate);
StreamWriter strGU = new StreamWriter(tempGU, Encoding.Default);
strGU.Write(duanResult);
strGU.Close();
if (File.Exists(System.Windows.Forms.Application.StartupPath + "\\result1.csv"))
{
File.Delete(System.Windows.Forms.Application.StartupPath + "\\result1.csv");
}
FileStream tempDY = new FileStream((System.Windows.Forms.Application.StartupPath + "\\result1.csv"), FileMode.OpenOrCreate);
StreamWriter strDY = new StreamWriter(tempDY, Encoding.Default);
strDY.Write(dianYaResult);
strDY.Close();
if (File.Exists(System.Windows.Forms.Application.StartupPath + "\\result2.csv"))
{
File.Delete(System.Windows.Forms.Application.StartupPath + "\\result2.csv");
}
FileStream tempDL = new FileStream((System.Windows.Forms.Application.StartupPath + "\\result2.csv"), FileMode.OpenOrCreate);
StreamWriter strDL = new StreamWriter(tempDL, Encoding.Default);
strDL.Write(dianLiuResult);
strDL.Close();
PSP_ELCPROJECT psproject = new PSP_ELCPROJECT();
psproject.ID = projectSUID;
psproject = (PSP_ELCPROJECT)UCDeviceBase.DataService.GetObject("SelectPSP_ELCPROJECTByKey", psproject);
if (File.Exists(System.Windows.Forms.Application.StartupPath + "\\" + psproject.Name + "ȫ����·������.xls"))
{
File.Delete(System.Windows.Forms.Application.StartupPath + "\\" + psproject.Name + "ȫ����·������.xls");
}
Excel.Application ex;
Excel.Worksheet xSheet;
Excel.Application result1;
Excel.Application result2;
Excel.Worksheet tempSheet;
Excel.Worksheet tempSheet1;
Excel.Worksheet newWorksheet;
Excel.Worksheet newWorkSheet1;
object oMissing = System.Reflection.Missing.Value;
ex = new Excel.Application();
ex.Application.Workbooks.Add(System.Windows.Forms.Application.StartupPath + "\\result.csv");
xSheet = (Excel.Worksheet)ex.Worksheets[1];
ex.Worksheets.Add(System.Reflection.Missing.Value, xSheet, 1, System.Reflection.Missing.Value);
xSheet = (Excel.Worksheet)ex.Worksheets[2];
ex.Worksheets.Add(System.Reflection.Missing.Value, xSheet, 1, System.Reflection.Missing.Value);
xSheet = (Excel.Worksheet)ex.Worksheets[1];
result1 = new Excel.Application();
result1.Application.Workbooks.Add(System.Windows.Forms.Application.StartupPath + "\\result1.csv");
result2 = new Excel.Application();
result2.Application.Workbooks.Add(System.Windows.Forms.Application.StartupPath + "\\result2.csv");
tempSheet = (Excel.Worksheet)result1.Worksheets.get_Item(1);
tempSheet1 = (Excel.Worksheet)result2.Worksheets.get_Item(1);
newWorksheet = (Excel.Worksheet)ex.Worksheets.get_Item(2);
newWorkSheet1 = (Excel.Worksheet)ex.Worksheets.get_Item(3);
newWorksheet.Name = "ĸ�ߵ�ѹ";
newWorkSheet1.Name = "֧·����";
xSheet.Name = "��·����";
ex.Visible = true;
tempSheet.Cells.Select();
tempSheet.Cells.Copy(System.Reflection.Missing.Value);
newWorksheet.Paste(System.Reflection.Missing.Value, System.Reflection.Missing.Value);
tempSheet1.Cells.Select();
tempSheet1.Cells.Copy(System.Reflection.Missing.Value);
newWorkSheet1.Paste(System.Reflection.Missing.Value, System.Reflection.Missing.Value);
xSheet.UsedRange.Font.Name = "����_GB2312";
newWorksheet.UsedRange.Font.Name = "����_GB2312";
newWorkSheet1.UsedRange.Font.Name = "����_GB2312";
//��¼��Ϊ��·������ʽ
xSheet.get_Range(xSheet.Cells[1, 1], xSheet.Cells[1, 3]).MergeCells = true;
xSheet.get_Range(xSheet.Cells[1, 1], xSheet.Cells[1, 1]).Font.Size = 20;
xSheet.get_Range(xSheet.Cells[1, 1], xSheet.Cells[1, 1]).Font.Name = "����";
xSheet.get_Range(xSheet.Cells[1, 1], xSheet.Cells[1, 1]).HorizontalAlignment = Excel.XlHAlign.xlHAlignCenter;
xSheet.get_Range(xSheet.Cells[6, 1], xSheet.Cells[6, 3]).Interior.ColorIndex = 45;
xSheet.get_Range(xSheet.Cells[7, 1], xSheet.Cells[xSheet.UsedRange.Rows.Count, 1]).Interior.ColorIndex = 6;
xSheet.get_Range(xSheet.Cells[4, 3], xSheet.Cells[xSheet.UsedRange.Rows.Count, 13]).NumberFormat = "0.0000_ ";
//ĸ�ߵ�ѹ��ʾ��ʽ
newWorksheet.get_Range(newWorksheet.Cells[1, 1], newWorksheet.Cells[1, 14]).MergeCells = true;
newWorksheet.get_Range(newWorksheet.Cells[1, 1], newWorksheet.Cells[1, 1]).Font.Size = 20;
newWorksheet.get_Range(newWorksheet.Cells[1, 1], newWorksheet.Cells[1, 1]).Font.Name = "����";
newWorksheet.get_Range(newWorksheet.Cells[1, 1], newWorksheet.Cells[1, 1]).HorizontalAlignment = Excel.XlHAlign.xlHAlignCenter;
if (OutType == 0)
{
for (int m = 0; m < muxiannum - 1; m++)
{
newWorksheet.get_Range(newWorksheet.Cells[m * (muxiannum + 2) + 8, 1], newWorksheet.Cells[m * (muxiannum + 2) + 8, 14]).Interior.ColorIndex = 45;
newWorksheet.get_Range(newWorksheet.Cells[m * (muxiannum + 2) + 9, 1], newWorksheet.Cells[m * (muxiannum + 2) + 8 + muxiannum - 1, 1]).Interior.ColorIndex = 6;
newWorksheet.get_Range(newWorksheet.Cells[m * (muxiannum + 2) + 9, 3], newWorksheet.Cells[m * (muxiannum + 2) + 8 + muxiannum - 1, 13]).NumberFormat = "0.0000_ ";
}
}
//��·�����������ʾ��ʽ
newWorkSheet1.get_Range(newWorkSheet1.Cells[1, 1], newWorkSheet1.Cells[1, 15]).MergeCells = true;
newWorkSheet1.get_Range(newWorkSheet1.Cells[1, 1], newWorkSheet1.Cells[1, 1]).Font.Size = 20;
newWorkSheet1.get_Range(newWorkSheet1.Cells[1, 1], newWorkSheet1.Cells[1, 1]).Font.Name = "����";
newWorkSheet1.get_Range(newWorkSheet1.Cells[1, 1], newWorkSheet1.Cells[1, 1]).HorizontalAlignment = Excel.XlHAlign.xlHAlignCenter;
if (OutType == 0)
{
for (int m = 0; m < muxiannum - 1; m++)
{
newWorkSheet1.get_Range(newWorkSheet1.Cells[m * (linenum + 2) + 8, 1], newWorkSheet1.Cells[m * (linenum + 2) + 8, 15]).Interior.ColorIndex = 45;
newWorkSheet1.get_Range(newWorkSheet1.Cells[m * (linenum + 2) + 9, 1], newWorkSheet1.Cells[m * (linenum + 2) + 8 + linenum - 1, 1]).Interior.ColorIndex = 6;
newWorkSheet1.get_Range(newWorkSheet1.Cells[m * (linenum + 2) + 9, 2], newWorkSheet1.Cells[m * (linenum + 2) + 8 + linenum - 1, 2]).Interior.ColorIndex = 6;
newWorkSheet1.get_Range(newWorkSheet1.Cells[m * (linenum + 2) + 9, 3], newWorkSheet1.Cells[m * (linenum + 2) + 8 + linenum - 1, 3]).Interior.ColorIndex = 6;
newWorkSheet1.get_Range(newWorkSheet1.Cells[m * (linenum + 2) + 9, 4], newWorkSheet1.Cells[m * (linenum + 2) + 8 + linenum - 1, 14]).NumberFormat = "0.0000_ ";
}
}
xSheet.Rows.AutoFit();
xSheet.Columns.AutoFit();
newWorksheet.Rows.AutoFit();
newWorksheet.Columns.AutoFit();
newWorkSheet1.Rows.AutoFit();
newWorkSheet1.Columns.AutoFit();
newWorksheet.SaveAs(System.Windows.Forms.Application.StartupPath + "\\" + psproject.Name + "ȫ����·������.xls", Excel.XlFileFormat.xlXMLSpreadsheet, null, null, false, false, false, null, null, null);
System.Windows.Forms.Clipboard.Clear();
result1.Workbooks.Close();
result1.Quit();
result2.Workbooks.Close();
result2.Quit();
}
catch (System.Exception ex)
{
MessageBox.Show("���ݴ���������������ȫ���ٲ���", "��ʾ", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
}
//根据操作的次序依次显示
private void Allshortcheck(int caozuoi)
{
if (!addcheck())
{
return;
}
ElectricShorti elc = new ElectricShorti();
if (!elc.CheckDL(tlVectorControl1.SVGDocument.SvgdataUid,this.ProjectUID,100))
{
return;
}
Dictionary<int, double> nodeshorti = new Dictionary<int, double>(); //记录母线有没有进行过短路
KeyValuePair<int, double> maxshorti = new KeyValuePair<int, double>(); //取出短路的最大短路电流
string con = ",PSP_ELCDEVICE WHERE PSPDEV.SUID = PSP_ELCDEVICE.DeviceSUID AND PSP_ELCDEVICE.ProjectSUID = '" +tlVectorControl1.SVGDocument.SvgdataUid + "'AND PSPDEV.type='01'AND PSPDEV.KSwitchStatus = '0' order by PSPDEV.number";
PSPDEV pspDev = new PSPDEV();
IList list1 = Services.BaseService.GetList("SelectPSPDEVByCondition", con);
con = " ,PSP_ELCDEVICE WHERE PSPDEV.SUID = PSP_ELCDEVICE.DeviceSUID AND PSP_ELCDEVICE.ProjectSUID = '" + tlVectorControl1.SVGDocument.SvgdataUid+ "'AND PSPDEV.type='05'AND PSPDEV.KSwitchStatus = '0'order by PSPDEV.number";
PSPDEV psp = new PSPDEV();
IList list2 = Services.BaseService.GetList("SelectPSPDEVByCondition", con);
shortbuscir shortCutCal = new shortbuscir(0);
for (int i = 0; i < list1.Count; i++)
{
pspDev = list1[i] as PSPDEV;
bool flag = false;
string dlr = null;
for (int j = 0; j < list2.Count; j++)
{
psp = list2[j] as PSPDEV;
con = " WHERE Name='" + psp.ISwitch + "' AND ProjectID = '" +this.ProjectUID + "'" + "AND Type='07'";
IList listiswitch = Services.BaseService.GetList("SelectPSPDEVByCondition", con);
con = " WHERE Name='" + psp.JSwitch + "' AND ProjectID = '" + this.ProjectUID + "'" + "AND Type='07'";
IList listjswitch = Services.BaseService.GetList("SelectPSPDEVByCondition", con);
PSPDEV pspiswitch = (PSPDEV)listiswitch[0];
PSPDEV pspjswitch = (PSPDEV)listjswitch[0];
if (pspDev.Number == psp.FirstNode && pspiswitch.KSwitchStatus == "0" && pspjswitch.KSwitchStatus == "0")
{
flag = true;
dlr = "0" + " " + psp.FirstNode + " " + psp.LastNode + " " + psp.Number + " " + "0 " + " " + "0 ";
}
if (pspDev.Number == psp.LastNode && pspiswitch.KSwitchStatus == "0" && pspjswitch.KSwitchStatus == "0")
{
flag = true;
dlr = "0" + " " + psp.FirstNode + " " + psp.LastNode + " " + psp.Number + " " + "1 " + " " + "0 ";
}
if (File.Exists(System.Windows.Forms.Application.StartupPath + "\\fault.txt"))
{
File.Delete(System.Windows.Forms.Application.StartupPath + "\\fault.txt");
}
if (flag)
{
FileStream VK = new FileStream((System.Windows.Forms.Application.StartupPath + "\\fault.txt"), FileMode.OpenOrCreate);
StreamWriter str11 = new StreamWriter(VK);
str11.Write(dlr);
str11.Close();
if (File.Exists(System.Windows.Forms.Application.StartupPath + "\\ShortcuitI.txt"))
{
File.Delete(System.Windows.Forms.Application.StartupPath + "\\ShortcuitI.txt");
}
// shortcir shortCutCal = new shortcir();
shortCutCal.Show_shortcir(0,0,1);
//bool matrixflag=true; //用来判断是否导纳矩阵的逆矩阵是否存在逆矩阵
string matrixstr = null;
if (File.Exists(System.Windows.Forms.Application.StartupPath + "\\Zmatrixcheck.txt"))
{
matrixstr = "正序导纳矩阵";
// matrixflag = false;
}
if (File.Exists(System.Windows.Forms.Application.StartupPath + "\\Fmatrixcheck.txt"))
{
// matrixflag = false;
matrixstr += "负序导纳矩阵";
}
if (File.Exists(System.Windows.Forms.Application.StartupPath + "\\Lmatrixcheck.txt"))
{
//matrixflag = false;
matrixstr += "零序导纳矩阵";
}
if (matrixstr != null)
{
MessageBox.Show(matrixstr + "不存在逆矩阵，请调整参数后再进行计算！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
if (File.Exists(System.Windows.Forms.Application.StartupPath + "\\ShortcuitI.txt"))
{
}
else
{
return;
}
FileStream shorcuit = new FileStream(System.Windows.Forms.Application.StartupPath + "\\ShortcuitI.txt", FileMode.Open);
StreamReader readLineGU = new StreamReader(shorcuit, System.Text.Encoding.Default);
string strLineGU;
string[] arrayGU;
char[] charSplitGU = new char[] { ' ' };
while ((strLineGU = readLineGU.ReadLine()) != null)
{
while ((strLineGU = readLineGU.ReadLine()) != null)
{
arrayGU = strLineGU.Split(charSplitGU);
string[] shorti = new string[4];
shorti.Initialize();
int m = 0;
foreach (string str in arrayGU)
{
if (str != "")
{
shorti[m++] = str.ToString();
}
}
nodeshorti[pspDev.Number] = Convert.ToDouble(shorti[3]) * 100 / (Math.Sqrt(3) * pspDev.ReferenceVolt);
}
}
readLineGU.Close();
break; //跳出本循环 进行母线的另外一个母线短路
}
if (!flag)
continue;
//写入错误中
}
//如果在一般线路中没有则在两绕组中进行
if (!flag)
{
con = " ,PSP_ELCDEVICE WHERE PSPDEV.SUID = PSP_ELCDEVICE.DeviceSUID AND PSP_ELCDEVICE.ProjectSUID = '" + tlVectorControl1.SVGDocument.SvgdataUid + "'AND PSPDEV.type='02'AND PSPDEV.KSwitchStatus = '0' order by PSPDEV.number";
IList list3 = Services.BaseService.GetList("SelectPSPDEVByCondition", con);
for (int j = 0; j < list3.Count; j++)
{
dlr = null;
psp = list3[j] as PSPDEV;
PSPDEV devFirst = new PSPDEV();
con = " WHERE Name='" + psp.IName + "' AND ProjectID = '" + this.ProjectUID + "'" + "AND Type='01'";
devFirst = (PSPDEV)Services.BaseService.GetObject("SelectPSPDEVByCondition", con);
PSPDEV devLast = new PSPDEV();
con = " WHERE Name='" + psp.JName + "' AND ProjectID = '" + this.ProjectUID + "'" + "AND Type='01'";
devLast = (PSPDEV)Services.BaseService.GetObject("SelectPSPDEVByCondition", con);
con = " WHERE Name='" + psp.ISwitch + "' AND ProjectID = '" + this.ProjectUID + "'" + "AND Type='07'";
IList listiswitch = Services.BaseService.GetList("SelectPSPDEVByCondition", con);
con = " WHERE Name='" + psp.JSwitch + "' AND ProjectID = '" + this.ProjectUID + "'" + "AND Type='07'";
IList listjswitch = Services.BaseService.GetList("SelectPSPDEVByCondition", con);
PSPDEV pspiswitch = (PSPDEV)listiswitch[0];
PSPDEV pspjswitch = (PSPDEV)listjswitch[0];
if (pspDev.Number == devFirst.Number && pspiswitch.KSwitchStatus == "0" && pspjswitch.KSwitchStatus == "0")
{
flag = true;
dlr = "0" + " " + devFirst.Number + " " + devLast.Number + " " + psp.Number + " " + "0" + " " + "0";
}
if (pspDev.Number == devLast.Number && pspiswitch.KSwitchStatus == "0" && pspjswitch.KSwitchStatus == "0")
{
flag = true;
dlr = "0" + " " + devFirst.Number + " " + devLast.Number + " " + psp.Number + " " + "1" + " " + "0";
}
if (flag)
{
FileStream VK = new FileStream((System.Windows.Forms.Application.StartupPath + "\\fault.txt"), FileMode.OpenOrCreate);
StreamWriter str11 = new StreamWriter(VK);
str11.Write(dlr);
str11.Close();
if (File.Exists(System.Windows.Forms.Application.StartupPath + "\\ShortcuitI.txt"))
{
File.Delete(System.Windows.Forms.Application.StartupPath + "\\ShortcuitI.txt");
}
// shortcir shortCutCal = new shortcir();
shortCutCal.Show_shortcir(0,0,1);
//bool matrixflag=true; //用来判断是否导纳矩阵的逆矩阵是否存在逆矩阵
string matrixstr = null;
if (File.Exists(System.Windows.Forms.Application.StartupPath + "\\Zmatrixcheck.txt"))
{
matrixstr = "正序导纳矩阵";
// matrixflag = false;
}
if (File.Exists(System.Windows.Forms.Application.StartupPath + "\\Fmatrixcheck.txt"))
{
// matrixflag = false;
matrixstr += "负序导纳矩阵";
}
if (File.Exists(System.Windows.Forms.Application.StartupPath + "\\Lmatrixcheck.txt"))
{
//matrixflag = false;
matrixstr += "零序导纳矩阵";
}
if (matrixstr != null)
{
MessageBox.Show(matrixstr + "不存在逆矩阵，请调整参数后再进行计算！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
if (File.Exists(System.Windows.Forms.Application.StartupPath + "\\ShortcuitI.txt"))
{
}
else
{
return;
}
FileStream shorcuit = new FileStream(System.Windows.Forms.Application.StartupPath + "\\ShortcuitI.txt", FileMode.Open);
StreamReader readLineGU = new StreamReader(shorcuit, System.Text.Encoding.Default);
string strLineGU;
string[] arrayGU;
char[] charSplitGU = new char[] { ' ' };
while ((strLineGU = readLineGU.ReadLine()) != null)
{
while ((strLineGU = readLineGU.ReadLine()) != null)
{
arrayGU = strLineGU.Split(charSplitGU);
string[] shorti = new string[4];
shorti.Initialize();
int m = 0;
foreach (string str in arrayGU)
{
if (str != "")
{
shorti[m++] = str.ToString();
}
}
nodeshorti[pspDev.Number] = Convert.ToDouble(shorti[3]) * 100 / (Math.Sqrt(3) * pspDev.ReferenceVolt);
}
}
readLineGU.Close();
break; //跳出本循环 进行母线的另外一个母线短路
}
if (!flag)
continue;
//写入错误中
}
}
if (!flag)
{
con = " ,PSP_ELCDEVICE WHERE PSPDEV.SUID = PSP_ELCDEVICE.DeviceSUID AND PSP_ELCDEVICE.ProjectSUID = '" + tlVectorControl1.SVGDocument.SvgdataUid + "'AND PSPDEV.type='03'AND PSPDEV.KSwitchStatus = '0' order by PSPDEV.number";
IList list4 = Services.BaseService.GetList("SelectPSPDEVByCondition", con);
for (int j = 0; j < list4.Count; j++)
{
dlr = null;
psp = list4[j] as PSPDEV;
PSPDEV devINode = new PSPDEV();
con = " WHERE Name='" + psp.IName + "' AND ProjectID = '" + this.ProjectUID+ "'" + "AND Type='01'";
devINode = (PSPDEV)Services.BaseService.GetObject("SelectPSPDEVByCondition", con);
PSPDEV devJNode = new PSPDEV();
con = " WHERE Name='" + psp.JName + "' AND ProjectID = '" + this.ProjectUID + "'" + "AND Type='01'";
devJNode = (PSPDEV)Services.BaseService.GetObject("SelectPSPDEVByCondition", con);
PSPDEV devKNode = new PSPDEV();
con = " WHERE Name='" + psp.KName + "' AND ProjectID = '" + this.ProjectUID + "'" + "AND Type='01'";
devKNode = (PSPDEV)Services.BaseService.GetObject("SelectPSPDEVByCondition", con);
con = " WHERE Name='" + psp.ISwitch + "' AND ProjectID = '" + this.ProjectUID + "'" + "AND Type='07'";
IList listiswitch = Services.BaseService.GetList("SelectPSPDEVByCondition", con);
con = " WHERE Name='" + psp.JSwitch + "' AND ProjectID = '" + this.ProjectUID + "'" + "AND Type='07'";
IList listjswitch = Services.BaseService.GetList("SelectPSPDEVByCondition", con);
con = " WHERE Name='" + psp.HuganLine1 + "' AND ProjectID = '" + this.ProjectUID + "'" + "AND Type='07'";
IList listkswitch = Services.BaseService.GetList("SelectPSPDEVByCondition", con);
PSPDEV pspiswitch = (PSPDEV)listiswitch[0];
PSPDEV pspjswitch = (PSPDEV)listjswitch[0];
PSPDEV pspkswitch = (PSPDEV)listkswitch[0];
if (pspDev.Number == devINode.Number && pspiswitch.KSwitchStatus == "0" && pspjswitch.KSwitchStatus == "0" && pspkswitch.KSwitchStatus == "0")
{
flag = true;
dlr = "0" + " " + devINode.Number + " " + devJNode.Number + " " + psp.Number + " " + "0" + " " + "0";
}
if (pspDev.Number == devJNode.Number && pspiswitch.KSwitchStatus == "0" && pspjswitch.KSwitchStatus == "0" && pspkswitch.KSwitchStatus == "0")
{
flag = true;
dlr = "0" + " " + devINode.Number + " " + devJNode.Number + " " + psp.Number + " " + "1" + " " + "0";
}
if (pspDev.Number == devKNode.Number && pspiswitch.KSwitchStatus == "0" && pspjswitch.KSwitchStatus == "0" && pspkswitch.KSwitchStatus == "0")
{
flag = true;
dlr = "0" + " " + devINode.Number + " " + devKNode.Number + " " + psp.Number + " " + "1" + " " + "0";
}
if (flag)
{
FileStream VK = new FileStream((System.Windows.Forms.Application.StartupPath + "\\fault.txt"), FileMode.OpenOrCreate);
StreamWriter str11 = new StreamWriter(VK);
str11.Write(dlr);
str11.Close();
if (File.Exists(System.Windows.Forms.Application.StartupPath + "\\ShortcuitI.txt"))
{
File.Delete(System.Windows.Forms.Application.StartupPath + "\\ShortcuitI.txt");
}
// shortcir shortCutCal = new shortcir();
shortCutCal.Show_shortcir(0,0,1);
//bool matrixflag=true; //用来判断是否导纳矩阵的逆矩阵是否存在逆矩阵
string matrixstr = null;
if (File.Exists(System.Windows.Forms.Application.StartupPath + "\\Zmatrixcheck.txt"))
{
matrixstr = "正序导纳矩阵";
// matrixflag = false;
}
if (File.Exists(System.Windows.Forms.Application.StartupPath + "\\Fmatrixcheck.txt"))
{
// matrixflag = false;
matrixstr += "负序导纳矩阵";
}
if (File.Exists(System.Windows.Forms.Application.StartupPath + "\\Lmatrixcheck.txt"))
{
//matrixflag = false;
matrixstr += "零序导纳矩阵";
}
if (matrixstr != null)
{
MessageBox.Show(matrixstr + "不存在逆矩阵，请调整参数后再进行计算！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
if (File.Exists(System.Windows.Forms.Application.StartupPath + "\\ShortcuitI.txt"))
{
}
else
{
return;
}
FileStream shorcuit = new FileStream(System.Windows.Forms.Application.StartupPath + "\\ShortcuitI.txt", FileMode.Open);
StreamReader readLineGU = new StreamReader(shorcuit, System.Text.Encoding.Default);
string strLineGU;
string[] arrayGU;
char[] charSplitGU = new char[] { ' ' };
while ((strLineGU = readLineGU.ReadLine()) != null)
{
while ((strLineGU = readLineGU.ReadLine()) != null)
{
arrayGU = strLineGU.Split(charSplitGU);
string[] shorti = new string[4];
shorti.Initialize();
int m = 0;
foreach (string str in arrayGU)
{
if (str != "")
{
shorti[m++] = str.ToString();
}
}
nodeshorti[pspDev.Number] = Convert.ToDouble(shorti[3]) * 100 / (Math.Sqrt(3) * pspDev.ReferenceVolt);
}
}
readLineGU.Close();
break; //跳出本循环 进行母线的另外一个母线短路
}
if (!flag)
continue;
//写入错误中
}
}
}
//找出短路电流最大的值
//maxshorti.Key = 1;
//maxshorti.Value = nodeshorti[1];
foreach (KeyValuePair<int, double> keyvalue in nodeshorti)
{
if (keyvalue.Value > maxshorti.Value)
{
maxshorti = keyvalue;
}
}
//首先取出断路器 判断它的母线在不在 如果不在就将其删除 然后与额定电压进行比较
con = " ,PSP_ELCDEVICE WHERE PSPDEV.SUID = PSP_ELCDEVICE.DeviceSUID AND PSP_ELCDEVICE.ProjectSUID = '" + tlVectorControl1.SVGDocument.SvgdataUid + "'AND PSPDEV.type='06'AND PSPDEV.KSwitchStatus = '0' order by PSPDEV.number";
IList list = Services.BaseService.GetList("SelectPSPDEVByCondition", con);
for (int i = 0; i < list.Count; i++)
{
bool flag = false;
pspDev = list[i] as PSPDEV;
for (int j = 0; j < list1.Count; j++)
{
psp = list1[j] as PSPDEV;
if (pspDev.IName == psp.Name)
flag = true;
}
if (!flag)
{
Services.BaseService.Delete<PSPDEV>(pspDev);
}
}
con = " ,PSP_ELCDEVICE WHERE PSPDEV.SUID = PSP_ELCDEVICE.DeviceSUID AND PSP_ELCDEVICE.ProjectSUID = '" + tlVectorControl1.SVGDocument.SvgdataUid + "'AND PSPDEV.type='06'AND PSPDEV.KSwitchStatus = '0' order by PSPDEV.number";
list = Services.BaseService.GetList("SelectPSPDEVByCondition", con);
for (int i = 0; i < list.Count; i++)
{
pspDev = list[i] as PSPDEV;
pspDev.HuganLine3 = "";
pspDev.KName = "";
if (pspDev.KSwitchStatus == "0")
{
pspDev.OutP = maxshorti.Value;
if (maxshorti.Value > pspDev.HuganTQ1)
{
pspDev.HuganLine3 = "不合格";
}
else
{
pspDev.HuganLine3 = "合格";
}
pspDev.HuganLine4 = "";
if (pspDev.HuganLine3 == "合格")
{
pspDev.KName = "合格";
}
else
pspDev.KName = "不合格";
}
Services.BaseService.Update<PSPDEV>(pspDev);
}
switch (caozuoi)
{
case 1: //全部短路检验
{
pspDev.SvgUID = tlVectorControl1.SVGDocument.SvgdataUid;
pspDev.Type = "06";
DlqiCheckform dlqicheckform = new DlqiCheckform(pspDev);
dlqicheckform.getusercltr.gridView.GroupPanelText = "断路器开断能力评估初步结果表";
dlqicheckform.ShowDialog();
break;
}
case 2: //最大短路检验
{
con = " ,PSP_ELCDEVICE WHERE PSPDEV.SUID = PSP_ELCDEVICE.DeviceSUID AND PSP_ELCDEVICE.ProjectSUID = '" + tlVectorControl1.SVGDocument.SvgdataUid + "'AND PSPDEV.type='06'AND PSPDEV.KSwitchStatus = '0' order by PSPDEV.number";
list = Services.BaseService.GetList("SelectPSPDEVByCondition", con);
for (int i = 0; i < list.Count; i++)
{
pspDev = list[i] as PSPDEV;
if (pspDev.KSwitchStatus == "0")
{
con = ",PSP_ELCDEVICE WHERE PSPDEV.SUID = PSP_ELCDEVICE.DeviceSUID AND PSP_ELCDEVICE.ProjectSUID = '" + tlVectorControl1.SVGDocument.SvgdataUid+ "'AND PSPDEV.type='01'AND PSPDEV.KSwitchStatus = '0'AND PSPDEV.Name='"+pspDev.IName+"'";
IList list4 = Services.BaseService.GetList("SelectPSPDEVByCondition", con);
psp = list4[0] as PSPDEV;
try
{
pspDev.OutQ = nodeshorti[psp.Number];
if (pspDev.HuganLine3 == "不合格")
{
if (pspDev.OutQ <= pspDev.HuganTQ1)
{
pspDev.HuganLine3 = "合格";
}
}
pspDev.HuganLine4 = "";
if (pspDev.HuganLine3 == "合格")
{
pspDev.KName = "合格";
}
else
pspDev.KName = "不合格";
Services.BaseService.Update<PSPDEV>(pspDev);
}
catch (System.Exception ex)
{
MessageBox.Show("短路数据不完整");
}
}
}
pspDev.SvgUID = tlVectorControl1.SVGDocument.SvgdataUid;
pspDev.Type = "06";
DlqiCheckform dlqicheckform = new DlqiCheckform(pspDev);
dlqicheckform.getusercltr.gridView.GroupPanelText = "最大短路校核结果表";
dlqicheckform.ShowDialog();
break;
}
case 3: //断路器直流检验
{
con = " ,PSP_ELCDEVICE WHERE PSPDEV.SUID = PSP_ELCDEVICE.DeviceSUID AND PSP_ELCDEVICE.ProjectSUID = '" + tlVectorControl1.SVGDocument.SvgdataUid + "'AND PSPDEV.type='06'AND PSPDEV.KSwitchStatus = '0' order by PSPDEV.number";
list = Services.BaseService.GetList("SelectPSPDEVByCondition", con);
for (int i = 0; i < list.Count; i++)
{
pspDev = list[i] as PSPDEV;
if (pspDev.KSwitchStatus == "0")
{
double tx = 0.0;
if (pspDev.HuganLine2 == "自脱扣断路器")
{
tx = 0.0;
}
else if (pspDev.HuganLine2 == "辅助动力脱扣的断路器")
{
tx = 10;
}
pspDev.HuganTQ4 = (pspDev.OutP / pspDev.HuganTQ1) * Math.Exp((-pspDev.HuganTQ2 - tx) / 45) * 100;
pspDev.HuganTQ5 = (pspDev.OutQ / pspDev.HuganTQ1) * Math.Exp((-pspDev.HuganTQ2 - tx) / 45) * 100;
if (pspDev.HuganTQ3 >= pspDev.HuganTQ4)
{
pspDev.HuganLine4 = "合格";
}
if (pspDev.HuganTQ3 >= pspDev.HuganTQ5)
{
pspDev.HuganLine4 = "合格";
}
else if (pspDev.HuganTQ3 < pspDev.HuganTQ5)
{
pspDev.HuganLine4 = "不合格";
}
if (pspDev.HuganLine3 == "合格" && pspDev.HuganLine4 == "合格")
{
pspDev.KName = "合格";
}
else
{
pspDev.KName = "不合格";
}
Services.BaseService.Update<PSPDEV>(pspDev);
}
}
pspDev.SvgUID = tlVectorControl1.SVGDocument.SvgdataUid;
pspDev.Type = "06";
DlqiCheckform dlqicheckform = new DlqiCheckform(pspDev);
dlqicheckform.getusercltr.gridView.GroupPanelText = "断路器开端能力最终评估表";
dlqicheckform.ShowDialog();
break;
}
}
}
public void AllShortWJ(string projectSUID, string projectid, int dulutype, double ratecaplity, WaitDialogForm wf)
{
try
{
OutType = 1;
if (Compuflag == 1)
{
ElectricLoadCal elcc = new ElectricLoadCal();
elcc.LFCS(projectSUID, 1, (float)ratecaplity);
if (!CheckDLL(projectSUID, projectid, ratecaplity))
{
return;
}
}
else
{
if (!CheckDL(projectSUID, projectid, ratecaplity))
{
return;
}
}
System.Windows.Forms.Clipboard.Clear();
Dictionary<int, double> nodeshorti = new Dictionary<int, double>(); //��¼ĸ����û�н��й���·
KeyValuePair<int, double> maxshorti = new KeyValuePair<int, double>(); //ȡ����·������·����
string con = ",PSP_ELCDEVICE WHERE PSPDEV.SUID = PSP_ELCDEVICE.DeviceSUID AND PSP_ELCDEVICE.ProjectSUID = '" + projectSUID + "'AND PSPDEV.type='01'AND PSPDEV.KSwitchStatus = '0' order by PSPDEV.number";
PSPDEV pspDev = new PSPDEV();
IList list1 = UCDeviceBase.DataService.GetList("SelectPSPDEVByCondition", con);
con = " ,PSP_ELCDEVICE WHERE PSPDEV.SUID = PSP_ELCDEVICE.DeviceSUID AND PSP_ELCDEVICE.ProjectSUID = '" + projectSUID + "'AND PSPDEV.type in ('05','03','02') AND PSPDEV.KSwitchStatus = '0'order by PSPDEV.number";
IList list2 = UCDeviceBase.DataService.GetList("SelectPSPDEVByCondition", con);
PSPDEV psp = new PSPDEV();
psp = list2[0] as PSPDEV;
string data = System.DateTime.Now.ToString("d");
string time = System.DateTime.Now.ToString("T");
StringBuilder duanResult = new StringBuilder();
duanResult.Append("��·�������" + "\r\n" + "\r\n");
duanResult.Append("��·��ҵ�ţ�1" + "\r\n");
duanResult.Append("��·�������ڣ�" + data + " " + "ʱ�䣺" + time + "\r\n");
duanResult.Append("���kA" + "\r\n");
StringBuilder dianYaResult = new StringBuilder();
dianYaResult.Append("ĸ�ߵ�ѹ���" + "\r\n" + "\r\n");
dianYaResult.Append("��·��ҵ�ţ�1" + "\r\n");
dianYaResult.Append("��·�������ڣ�" + data + " " + "ʱ�䣺" + time + "\r\n");
dianYaResult.Append("��λ����ֵ( p.u. ) �Ƕ�(deg.)" + "\r\n");
StringBuilder dianLiuResult = new StringBuilder();
dianLiuResult.Append("֧·�������" + "\r\n" + "\r\n");
dianLiuResult.Append("��·��ҵ�ţ�1" + "\r\n");
dianLiuResult.Append("��·�������ڣ�" + data + " " + "ʱ�䣺" + time + "\r\n");
dianLiuResult.Append("��λ����ֵ( p.u. ) �Ƕ�(deg.)" + "\r\n");
int intshorti = 0; //��һ�м�¼��ΪҪ����·����������˵��
bool shortiflag = false;
int muxiannum = 0; //��¼һ��ĸ�߶�·�� �ж��ٸ���¼ĸ�ߵ�ѹ
int linenum = 0; //��¼һ��ĸ�߶�· �ж��ٸ���·����
shortbuscir shortCutCal = new shortbuscir(Compuflag);
string dlr = null;
if (File.Exists(System.Windows.Forms.Application.StartupPath + "\\fault.txt"))
{
File.Delete(System.Windows.Forms.Application.StartupPath + "\\fault.txt");
}
if (psp != null)
{
dlr = "0" + " " + psp.FirstNode + " " + psp.LastNode + " " + psp.Number + " " + "0 " + " " + dulutype;
}
else
{
return;
}
FileStream VK = new FileStream((System.Windows.Forms.Application.StartupPath + "\\fault.txt"), FileMode.OpenOrCreate);
StreamWriter str11 = new StreamWriter(VK);
str11.Write(dlr);
str11.Close();
if (File.Exists(System.Windows.Forms.Application.StartupPath + "\\ShortcuitI.txt"))
{
File.Delete(System.Windows.Forms.Application.StartupPath + "\\ShortcuitI.txt");
}
if (File.Exists(System.Windows.Forms.Application.StartupPath + "\\Sxdianliu.txt"))
{
File.Delete(System.Windows.Forms.Application.StartupPath + "\\Sxdianliu.txt");
}
if (File.Exists(System.Windows.Forms.Application.StartupPath + "\\Sxdianya.txt"))
{
File.Delete(System.Windows.Forms.Application.StartupPath + "\\Sxdianya.txt");
}
shortCutCal.Show_shortcir(Compuflag, OutType, 0);
string matrixstr = null;
if (File.Exists(System.Windows.Forms.Application.StartupPath + "\\Zmatrixcheck.txt"))
{
matrixstr = "�����ɾ���";
// matrixflag = false;
}
if (File.Exists(System.Windows.Forms.Application.StartupPath + "\\Fmatrixcheck.txt"))
{
// matrixflag = false;
matrixstr += "�����ɾ���";
}
if (File.Exists(System.Windows.Forms.Application.StartupPath + "\\Lmatrixcheck.txt"))
{
//matrixflag = false;
matrixstr += "�����ɾ���";
}
if (matrixstr != null)
{
System.Windows.Forms.MessageBox.Show(matrixstr + "�����������������������ٽ��м��㣡", "��ʾ", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Information);
return;
}
}
catch (System.Exception ex)
{
}
}
public void ALLShortThread(string projectSUID, string projectid, int dulutype, double ratecaplity, WaitDialogForm wf)
{
try
{
if (!CheckDL(projectSUID, projectid, ratecaplity))
{
return;
}
System.Windows.Forms.Clipboard.Clear();
Dictionary<int, double> nodeshorti = new Dictionary<int, double>(); //��¼ĸ����û�н��й���·
KeyValuePair<int, double> maxshorti = new KeyValuePair<int, double>(); //ȡ����·������·����
string con = ",PSP_ELCDEVICE WHERE PSPDEV.SUID = PSP_ELCDEVICE.DeviceSUID AND PSP_ELCDEVICE.ProjectSUID = '" + projectSUID + "'AND PSPDEV.type='01'AND PSPDEV.KSwitchStatus = '0' order by PSPDEV.number";
PSPDEV pspDev = new PSPDEV();
IList list1 = UCDeviceBase.DataService.GetList("SelectPSPDEVByCondition", con);
con = " ,PSP_ELCDEVICE WHERE PSPDEV.SUID = PSP_ELCDEVICE.DeviceSUID AND PSP_ELCDEVICE.ProjectSUID = '" + projectSUID + "'AND PSPDEV.type in ('05','03','02') AND PSPDEV.KSwitchStatus = '0'order by PSPDEV.number";
IList list2 = UCDeviceBase.DataService.GetList("SelectPSPDEVByCondition", con);
PSPDEV psp = new PSPDEV();
psp = list2[0] as PSPDEV;
string data = System.DateTime.Now.ToString("d");
string time = System.DateTime.Now.ToString("T");
string[,] dataDianliu = new string[65536, 15];
StringBuilder duanResult = new StringBuilder();
duanResult.Append("��·�������" + "\r\n" + "\r\n");
duanResult.Append("��·��ҵ�ţ�1" + "\r\n");
duanResult.Append("��·�������ڣ�" + data + " " + "ʱ�䣺" + time + "\r\n");
duanResult.Append("���kA" + "\r\n");
StringBuilder dianYaResult = new StringBuilder();
dianYaResult.Append("ĸ�ߵ�ѹ���" + "\r\n" + "\r\n");
dianYaResult.Append("��·��ҵ�ţ�1" + "\r\n");
dianYaResult.Append("��·�������ڣ�" + data + " " + "ʱ�䣺" + time + "\r\n");
dianYaResult.Append("��λ����ֵ( p.u. ) �Ƕ�(deg.)" + "\r\n");
StringBuilder dianLiuResult = new StringBuilder();
dianLiuResult.Append("֧·�������" + "\r\n" + "\r\n");
dianLiuResult.Append("��·��ҵ�ţ�1" + "\r\n");
dianLiuResult.Append("��·�������ڣ�" + data + " " + "ʱ�䣺" + time + "\r\n");
dianLiuResult.Append("��λ����ֵ( p.u. ) �Ƕ�(deg.)" + "\r\n");
int intshorti = 0; //��һ�м�¼��ΪҪ����·����������˵��
bool shortiflag = false;
int muxiannum = 0; //��¼һ��ĸ�߶�·�� �ж��ٸ���¼ĸ�ߵ�ѹ
int linenum = 0; //��¼һ��ĸ�߶�· �ж��ٸ���·����
shortbuscir shortCutCal = new shortbuscir(Compuflag);
string dlr = null;
if (psp != null)
{
dlr = "0" + " " + psp.FirstNode + " " + psp.LastNode + " " + psp.Number + " " + "0 " + " " + dulutype;
}
else
{
return;
}
FileStream VK = new FileStream((System.Windows.Forms.Application.StartupPath + "\\fault.txt"), FileMode.OpenOrCreate);
StreamWriter str11 = new StreamWriter(VK);
str11.Write(dlr);
str11.Close();
if (File.Exists(System.Windows.Forms.Application.StartupPath + "\\ShortcuitI.txt"))
{
File.Delete(System.Windows.Forms.Application.StartupPath + "\\ShortcuitI.txt");
}
if (File.Exists(System.Windows.Forms.Application.StartupPath + "\\Sxdianliu.txt"))
{
File.Delete(System.Windows.Forms.Application.StartupPath + "\\Sxdianliu.txt");
}
if (File.Exists(System.Windows.Forms.Application.StartupPath + "\\Sxdianya.txt"))
{
File.Delete(System.Windows.Forms.Application.StartupPath + "\\Sxdianya.txt");
}
shortCutCal.Show_shortcir(Compuflag, OutType, 0);
string matrixstr = null;
if (File.Exists(System.Windows.Forms.Application.StartupPath + "\\Zmatrixcheck.txt"))
{
matrixstr = "�����ɾ���";
// matrixflag = false;
}
if (File.Exists(System.Windows.Forms.Application.StartupPath + "\\Fmatrixcheck.txt"))
{
// matrixflag = false;
matrixstr += "�����ɾ���";
}
if (File.Exists(System.Windows.Forms.Application.StartupPath + "\\Lmatrixcheck.txt"))
{
//matrixflag = false;
matrixstr += "�����ɾ���";
}
if (matrixstr != null)
{
System.Windows.Forms.MessageBox.Show(matrixstr + "�����������������������ٽ��м��㣡", "��ʾ", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Information);
return;
}
if (File.Exists(System.Windows.Forms.Application.StartupPath + "\\ShortcuitI.txt"))
{
}
else
{
return;
}
ArrayList al = new ArrayList();
FileReadV fv = new FileReadV(projectSUID, projectid, dulutype, ratecaplity, wf, shortiflag, duanResult);
FileReadDLL fdl = new FileReadDLL(projectSUID, projectid, dulutype, ratecaplity, wf, con, dataDianliu);
FileReadDV fdv = new FileReadDV(projectSUID, projectid, dulutype, ratecaplity, wf, con, dianYaResult);
Thread shori = new Thread(new ThreadStart(fv.str));
Thread dianya = new Thread(new ThreadStart(fdv.str));
Thread dianliu = new Thread(new ThreadStart(fdl.str));
shori.Start();
if (OutType == 0)
{
dianya.Start();
dianliu.Start();
}
//д�뱨����
if (File.Exists(System.Windows.Forms.Application.StartupPath + "\\result.csv"))
{
File.Delete(System.Windows.Forms.Application.StartupPath + "\\result.csv");
}
FileStream tempGU = new FileStream((System.Windows.Forms.Application.StartupPath + "\\result.csv"), FileMode.OpenOrCreate);
StreamWriter strGU = new StreamWriter(tempGU, Encoding.Default);
strGU.Write(duanResult.ToString());
strGU.Close();
if (File.Exists(System.Windows.Forms.Application.StartupPath + "\\result1.csv"))
{
File.Delete(System.Windows.Forms.Application.StartupPath + "\\result1.csv");
}
FileStream tempDY = new FileStream((System.Windows.Forms.Application.StartupPath + "\\result1.csv"), FileMode.OpenOrCreate);
StreamWriter strDY = new StreamWriter(tempDY, Encoding.Default);
strDY.Write(dianYaResult.ToString());
strDY.Close();
if (File.Exists(System.Windows.Forms.Application.StartupPath + "\\result2.csv"))
{
File.Delete(System.Windows.Forms.Application.StartupPath + "\\result2.csv");
}
FileStream tempDL = new FileStream((System.Windows.Forms.Application.StartupPath + "\\result2.csv"), FileMode.OpenOrCreate);
StreamWriter strDL = new StreamWriter(tempDL, Encoding.Default);
strDL.Write(dianLiuResult);
strDL.Close();
PSP_ELCPROJECT psproject = new PSP_ELCPROJECT();
psproject.ID = projectSUID;
psproject = (PSP_ELCPROJECT)UCDeviceBase.DataService.GetObject("SelectPSP_ELCPROJECTByKey", psproject);
if (File.Exists(System.Windows.Forms.Application.StartupPath + "\\" + psproject.Name + "ȫ����·������.xls"))
{
File.Delete(System.Windows.Forms.Application.StartupPath + "\\" + psproject.Name + "ȫ����·������.xls");
}
Excel.Application ex;
Excel.Worksheet xSheet;
Excel.Application result1;
Excel.Application result2;
Excel.Worksheet tempSheet;
Excel.Worksheet tempSheet1;
Excel.Worksheet newWorksheet;
Excel.Worksheet newWorkSheet1;
object oMissing = System.Reflection.Missing.Value;
ex = new Excel.Application();
ex.Application.Workbooks.Add(System.Windows.Forms.Application.StartupPath + "\\result.csv");
xSheet = (Excel.Worksheet)ex.Worksheets[1];
ex.Worksheets.Add(System.Reflection.Missing.Value, xSheet, 1, System.Reflection.Missing.Value);
xSheet = (Excel.Worksheet)ex.Worksheets[2];
ex.Worksheets.Add(System.Reflection.Missing.Value, xSheet, 1, System.Reflection.Missing.Value);
xSheet = (Excel.Worksheet)ex.Worksheets[1];
result1 = new Excel.Application();
result1.Application.Workbooks.Add(System.Windows.Forms.Application.StartupPath + "\\result1.csv");
result2 = new Excel.Application();
result2.Application.Workbooks.Add(System.Windows.Forms.Application.StartupPath + "\\result2.csv");
tempSheet = (Excel.Worksheet)result1.Worksheets.get_Item(1);
tempSheet1 = (Excel.Worksheet)result2.Worksheets.get_Item(1);
newWorksheet = (Excel.Worksheet)ex.Worksheets.get_Item(2);
newWorkSheet1 = (Excel.Worksheet)ex.Worksheets.get_Item(3);
newWorksheet.Name = "ĸ�ߵ�ѹ";
newWorkSheet1.Name = "֧·����";
xSheet.Name = "��·����";
ex.Visible = true;
tempSheet.Cells.Select();
tempSheet.Cells.Copy(System.Reflection.Missing.Value);
newWorksheet.Paste(System.Reflection.Missing.Value, System.Reflection.Missing.Value);
tempSheet1.Cells.Select();
tempSheet1.Cells.Copy(System.Reflection.Missing.Value);
newWorkSheet1.Paste(System.Reflection.Missing.Value, System.Reflection.Missing.Value);
while (shori.IsAlive || dianya.IsAlive || dianliu.IsAlive)
{
newWorksheet.get_Range(newWorksheet.Cells[1, 1], newWorksheet.Cells[65536, 20]).Clear();
newWorksheet.get_Range(newWorksheet.Cells[1, 1], newWorksheet.Cells[65536, 20]).Value2 = dataDianliu;
}
xSheet.UsedRange.Font.Name = "����_GB2312";
newWorksheet.UsedRange.Font.Name = "����_GB2312";
newWorkSheet1.UsedRange.Font.Name = "����_GB2312";
//��¼��Ϊ��·������ʽ
xSheet.get_Range(xSheet.Cells[1, 1], xSheet.Cells[1, 3]).MergeCells = true;
xSheet.get_Range(xSheet.Cells[1, 1], xSheet.Cells[1, 1]).Font.Size = 20;
xSheet.get_Range(xSheet.Cells[1, 1], xSheet.Cells[1, 1]).Font.Name = "����";
xSheet.get_Range(xSheet.Cells[1, 1], xSheet.Cells[1, 1]).HorizontalAlignment = Excel.XlHAlign.xlHAlignCenter;
xSheet.get_Range(xSheet.Cells[6, 1], xSheet.Cells[6, 3]).Interior.ColorIndex = 45;
xSheet.get_Range(xSheet.Cells[7, 1], xSheet.Cells[xSheet.UsedRange.Rows.Count, 1]).Interior.ColorIndex = 6;
xSheet.get_Range(xSheet.Cells[4, 3], xSheet.Cells[xSheet.UsedRange.Rows.Count, 13]).NumberFormat = "0.0000_ ";
//ĸ�ߵ�ѹ��ʾ��ʽ
newWorksheet.get_Range(newWorksheet.Cells[1, 1], newWorksheet.Cells[1, 14]).MergeCells = true;
newWorksheet.get_Range(newWorksheet.Cells[1, 1], newWorksheet.Cells[1, 1]).Font.Size = 20;
newWorksheet.get_Range(newWorksheet.Cells[1, 1], newWorksheet.Cells[1, 1]).Font.Name = "����";
newWorksheet.get_Range(newWorksheet.Cells[1, 1], newWorksheet.Cells[1, 1]).HorizontalAlignment = Excel.XlHAlign.xlHAlignCenter;
if (OutType == 0)
{
for (int m = 0; m < muxiannum - 1; m++)
{
newWorksheet.get_Range(newWorksheet.Cells[m * (muxiannum + 2) + 8, 1], newWorksheet.Cells[m * (muxiannum + 2) + 8, 14]).Interior.ColorIndex = 45;
newWorksheet.get_Range(newWorksheet.Cells[m * (muxiannum + 2) + 9, 1], newWorksheet.Cells[m * (muxiannum + 2) + 8 + muxiannum - 1, 1]).Interior.ColorIndex = 6;
newWorksheet.get_Range(newWorksheet.Cells[m * (muxiannum + 2) + 9, 3], newWorksheet.Cells[m * (muxiannum + 2) + 8 + muxiannum - 1, 13]).NumberFormat = "0.0000_ ";
}
}
//��·�����������ʾ��ʽ
newWorkSheet1.get_Range(newWorkSheet1.Cells[1, 1], newWorkSheet1.Cells[1, 15]).MergeCells = true;
newWorkSheet1.get_Range(newWorkSheet1.Cells[1, 1], newWorkSheet1.Cells[1, 1]).Font.Size = 20;
newWorkSheet1.get_Range(newWorkSheet1.Cells[1, 1], newWorkSheet1.Cells[1, 1]).Font.Name = "����";
newWorkSheet1.get_Range(newWorkSheet1.Cells[1, 1], newWorkSheet1.Cells[1, 1]).HorizontalAlignment = Excel.XlHAlign.xlHAlignCenter;
if (OutType == 0)
{
for (int m = 0; m < muxiannum - 1; m++)
{
newWorkSheet1.get_Range(newWorkSheet1.Cells[m * (linenum + 2) + 8, 1], newWorkSheet1.Cells[m * (linenum + 2) + 8, 15]).Interior.ColorIndex = 45;
newWorkSheet1.get_Range(newWorkSheet1.Cells[m * (linenum + 2) + 9, 1], newWorkSheet1.Cells[m * (linenum + 2) + 8 + linenum - 1, 1]).Interior.ColorIndex = 6;
newWorkSheet1.get_Range(newWorkSheet1.Cells[m * (linenum + 2) + 9, 2], newWorkSheet1.Cells[m * (linenum + 2) + 8 + linenum - 1, 2]).Interior.ColorIndex = 6;
newWorkSheet1.get_Range(newWorkSheet1.Cells[m * (linenum + 2) + 9, 3], newWorkSheet1.Cells[m * (linenum + 2) + 8 + linenum - 1, 3]).Interior.ColorIndex = 6;
newWorkSheet1.get_Range(newWorkSheet1.Cells[m * (linenum + 2) + 9, 4], newWorkSheet1.Cells[m * (linenum + 2) + 8 + linenum - 1, 14]).NumberFormat = "0.0000_ ";
}
}
xSheet.Rows.AutoFit();
xSheet.Columns.AutoFit();
newWorksheet.Rows.AutoFit();
newWorksheet.Columns.AutoFit();
newWorkSheet1.Rows.AutoFit();
newWorkSheet1.Columns.AutoFit();
newWorksheet.SaveAs(System.Windows.Forms.Application.StartupPath + "\\" + psproject.Name + "ȫ����·������.xls", Excel.XlFileFormat.xlXMLSpreadsheet, null, null, false, false, false, null, null, null);
System.Windows.Forms.Clipboard.Clear();
result1.Workbooks.Close();
result1.Quit();
result2.Workbooks.Close();
result2.Quit();
GC.Collect();
}
catch (System.Exception ex)
{
}
}
//�����еĶ�·�������в���
public void AllShorti(string projectSUID, string projectid, int dulutype, double ratecaplity, Dictionary<string, double> shortcap)
{
try
{
//OutType = 1;
if (Compuflag == 1)
{
ElectricLoadCal elcc = new ElectricLoadCal();
elcc.LFCS(projectSUID, 1, (float)ratecaplity);
if (!CheckDLL(projectSUID, projectid, ratecaplity))
{
return;
}
}
else
{
if (!CheckDL(projectSUID, projectid, ratecaplity))
{
return;
}
}
System.Windows.Forms.Clipboard.Clear();
Dictionary<int, double> nodeshorti = new Dictionary<int, double>(); //��¼ĸ����û�н��й���·
KeyValuePair<int, double> maxshorti = new KeyValuePair<int, double>(); //ȡ����·������·����
string con = ",PSP_ELCDEVICE WHERE PSPDEV.SUID = PSP_ELCDEVICE.DeviceSUID AND PSP_ELCDEVICE.ProjectSUID = '" + projectSUID + "'AND PSPDEV.type='01'AND PSPDEV.KSwitchStatus = '0' order by PSPDEV.number";
PSPDEV pspDev = new PSPDEV();
IList list1 = UCDeviceBase.DataService.GetList("SelectPSPDEVByCondition", con);
con = " ,PSP_ELCDEVICE WHERE PSPDEV.SUID = PSP_ELCDEVICE.DeviceSUID AND PSP_ELCDEVICE.ProjectSUID = '" + projectSUID + "'AND PSPDEV.type in ('05','03','02') AND PSPDEV.KSwitchStatus = '0'order by PSPDEV.number";
IList list2 = UCDeviceBase.DataService.GetList("SelectPSPDEVByCondition", con);
PSPDEV psp = new PSPDEV();
psp = list2[0] as PSPDEV;
string data = System.DateTime.Now.ToString("d");
string time = System.DateTime.Now.ToString("T");
int intshorti = 0; //��һ�м�¼��ΪҪ����·����������˵��
bool shortiflag = false;
int muxiannum = 0; //��¼һ��ĸ�߶�·�� �ж��ٸ���¼ĸ�ߵ�ѹ
int linenum = 0; //��¼һ��ĸ�߶�· �ж��ٸ���·����
shortbuscir shortCutCal = new shortbuscir(Compuflag);
string dlr = null;
if (psp != null)
{
dlr = "0" + " " + psp.FirstNode + " " + psp.LastNode + " " + psp.Number + " " + "0 " + " " + dulutype;
}
else
{
return;
}
FileStream VK = new FileStream((System.Windows.Forms.Application.StartupPath + "\\fault.txt"), FileMode.OpenOrCreate);
StreamWriter str11 = new StreamWriter(VK);
str11.Write(dlr);
str11.Close();
if (File.Exists(System.Windows.Forms.Application.StartupPath + "\\ShortcuitI.txt"))
{
File.Delete(System.Windows.Forms.Application.StartupPath + "\\ShortcuitI.txt");
}
if (File.Exists(System.Windows.Forms.Application.StartupPath + "\\Sxdianliu.txt"))
{
File.Delete(System.Windows.Forms.Application.StartupPath + "\\Sxdianliu.txt");
}
if (File.Exists(System.Windows.Forms.Application.StartupPath + "\\Sxdianya.txt"))
{
File.Delete(System.Windows.Forms.Application.StartupPath + "\\Sxdianya.txt");
}
shortCutCal.Show_shortcir(Compuflag, OutType, 0);
string matrixstr = null;
if (File.Exists(System.Windows.Forms.Application.StartupPath + "\\Zmatrixcheck.txt"))
{
matrixstr = "�����ɾ���";
// matrixflag = false;
}
if (File.Exists(System.Windows.Forms.Application.StartupPath + "\\Fmatrixcheck.txt"))
{
// matrixflag = false;
matrixstr += "�����ɾ���";
}
if (File.Exists(System.Windows.Forms.Application.StartupPath + "\\Lmatrixcheck.txt"))
{
//matrixflag = false;
matrixstr += "�����ɾ���";
}
if (matrixstr != null)
{
System.Windows.Forms.MessageBox.Show(matrixstr + "�����������������������ٽ��м��㣡", "��ʾ", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Information);
return;
}
if (File.Exists(System.Windows.Forms.Application.StartupPath + "\\ShortcuitI.txt"))
{
}
else
{
return;
}
FileStream shorcuit = new FileStream(System.Windows.Forms.Application.StartupPath + "\\ShortcuitI.txt", FileMode.Open);
StreamReader readLineGU = new StreamReader(shorcuit, System.Text.Encoding.Default);
string strLineGU;
string[] arrayGU;
char[] charSplitGU = new char[] { ' ' };
intshorti = 0;
while ((strLineGU = readLineGU.ReadLine()) != null)
{
arrayGU = strLineGU.Split(charSplitGU, StringSplitOptions.RemoveEmptyEntries);
string[] shorti = arrayGU;
shorti.Initialize();
//int m = 0;
//foreach (string str in arrayGU)
//{
// if (str != "")
// {
// shorti[m++] = str.ToString();
// }
//}
if (intshorti == 0)
{
if (!shortiflag)
{
//duanResult.Append(shorti[0] + "," + shorti[1] + "," + shorti[3] + "\r\n");
shortiflag = true;
}
}
else
shortcap[shorti[1]] = Convert.ToDouble(shorti[3]);
intshorti++;
//wf.SetCaption(intshorti.ToString());
}
readLineGU.Close();
}
catch (System.Exception ex)
{
MessageBox.Show("��·���ݴ������⣬�迹�����ڻ��ߴ��ڹ����ڵ㣬���֤���ٽ��У�");
}
}
//���ݲ����Ĵ���������ʾ
public void AllshortcheckYL(string projectSUID, string projectid, double ratecaplity, int caozuoi)
{
try
{
if (!CheckDL(projectSUID, projectid, ratecaplity))
{
return;
}
Dictionary<int, double> nodeshorti = new Dictionary<int, double>(); //��¼ĸ����û�н��й���·
KeyValuePair<int, double> maxshorti = new KeyValuePair<int, double>(); //ȡ����·������·����
string con = ",PSP_ELCDEVICE WHERE PSPDEV.SUID = PSP_ELCDEVICE.DeviceSUID AND PSP_ELCDEVICE.ProjectSUID = '" + projectSUID + "'AND PSPDEV.type='01'AND PSPDEV.KSwitchStatus = '0' order by PSPDEV.number";
PSPDEV pspDev = new PSPDEV();
IList list1 = UCDeviceBase.DataService.GetList("SelectPSPDEVByCondition", con);
PSPDEV psp = new PSPDEV();
shortbuscir shortCutCal = new shortbuscir(Compuflag);
for (int i = 0; i < list1.Count; i++)
{
pspDev = list1[i] as PSPDEV;
bool flag = false;
string dlr = null;
con = " ,PSP_ELCDEVICE WHERE PSPDEV.SUID = PSP_ELCDEVICE.DeviceSUID AND PSP_ELCDEVICE.ProjectSUID = '" + projectSUID + "'AND PSPDEV.type='05'AND PSPDEV.KSwitchStatus = '0'AND (PSPDEV.IName='" + pspDev.Name + "'OR PSPDEV.JName='" + pspDev.Name + "')order by PSPDEV.number";
IList list2 = UCDeviceBase.DataService.GetList("SelectPSPDEVByCondition", con);
for (int j = 0; j < list2.Count; j++)
{
psp = list2[j] as PSPDEV;
con = " WHERE Name='" + psp.ISwitch + "' AND ProjectID = '" + projectid + "'" + "AND Type='07'";
IList listiswitch = UCDeviceBase.DataService.GetList("SelectPSPDEVByCondition", con);
con = " WHERE Name='" + psp.JSwitch + "' AND ProjectID = '" + projectid + "'" + "AND Type='07'";
IList listjswitch = UCDeviceBase.DataService.GetList("SelectPSPDEVByCondition", con);
PSPDEV pspiswitch = (PSPDEV)listiswitch[0];
PSPDEV pspjswitch = (PSPDEV)listjswitch[0];
if (pspDev.Number == psp.FirstNode && pspiswitch.KSwitchStatus == "0" && pspjswitch.KSwitchStatus == "0")
{
flag = true;
dlr = "0" + " " + psp.FirstNode + " " + psp.LastNode + " " + psp.Number + " " + "0 " + " " + "0 ";
}
if (pspDev.Number == psp.LastNode && pspiswitch.KSwitchStatus == "0" && pspjswitch.KSwitchStatus == "0")
{
flag = true;
dlr = "0" + " " + psp.FirstNode + " " + psp.LastNode + " " + psp.Number + " " + "1 " + " " + "0 ";
}
if (File.Exists(System.Windows.Forms.Application.StartupPath + "\\fault.txt"))
{
File.Delete(System.Windows.Forms.Application.StartupPath + "\\fault.txt");
}
if (flag)
{
FileStream VK = new FileStream((System.Windows.Forms.Application.StartupPath + "\\fault.txt"), FileMode.OpenOrCreate);
StreamWriter str11 = new StreamWriter(VK);
str11.Write(dlr);
str11.Close();
if (File.Exists(System.Windows.Forms.Application.StartupPath + "\\ShortcuitI.txt"))
{
File.Delete(System.Windows.Forms.Application.StartupPath + "\\ShortcuitI.txt");
}
//shortcir shortCutCal = new shortcir();
shortCutCal.Show_shortcir(0, 0, 1);
//bool matrixflag=true; //�����ж��Ƿ��ɾ����������Ƿ���������
string matrixstr = null;
if (File.Exists(System.Windows.Forms.Application.StartupPath + "\\Zmatrixcheck.txt"))
{
matrixstr = "�����ɾ���";
// matrixflag = false;
}
if (File.Exists(System.Windows.Forms.Application.StartupPath + "\\Fmatrixcheck.txt"))
{
// matrixflag = false;
matrixstr += "�����ɾ���";
}
if (File.Exists(System.Windows.Forms.Application.StartupPath + "\\Lmatrixcheck.txt"))
{
//matrixflag = false;
matrixstr += "�����ɾ���";
}
if (matrixstr != null)
{
MessageBox.Show(matrixstr + "�����������������������ٽ��м��㣡", "��ʾ", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
if (File.Exists(System.Windows.Forms.Application.StartupPath + "\\ShortcuitI.txt"))
{
}
else
{
return;
}
FileStream shorcuit = new FileStream(System.Windows.Forms.Application.StartupPath + "\\ShortcuitI.txt", FileMode.Open);
StreamReader readLineGU = new StreamReader(shorcuit, System.Text.Encoding.Default);
string strLineGU;
string[] arrayGU;
char[] charSplitGU = new char[] { ' ' };
while ((strLineGU = readLineGU.ReadLine()) != null)
{
while ((strLineGU = readLineGU.ReadLine()) != null)
{
arrayGU = strLineGU.Split(charSplitGU);
string[] shorti = new string[4];
shorti.Initialize();
int m = 0;
foreach (string str in arrayGU)
{
if (str != "")
{
shorti[m++] = str.ToString();
}
}
nodeshorti[pspDev.Number] = Convert.ToDouble(shorti[3]) * 100 / (Math.Sqrt(3) * pspDev.ReferenceVolt);
}
}
readLineGU.Close();
break; //������ѭ�� ����ĸ�ߵ�����һ��ĸ�߶�·
}
if (!flag)
continue;
//������
}
//�����һ����·��û�������������н���
if (!flag)
{
con = " ,PSP_ELCDEVICE WHERE PSPDEV.SUID = PSP_ELCDEVICE.DeviceSUID AND PSP_ELCDEVICE.ProjectSUID = '" + projectSUID + "'AND PSPDEV.type='02'AND PSPDEV.KSwitchStatus = '0'AND(PSPDEV.IName='" + pspDev.Name + "'OR PSPDEV.JName='" + pspDev.Name + "') order by PSPDEV.number";
IList list3 = UCDeviceBase.DataService.GetList("SelectPSPDEVByCondition", con);
for (int j = 0; j < list3.Count; j++)
{
dlr = null;
psp = list3[j] as PSPDEV;
//PSPDEV devFirst = new PSPDEV();
//con = " WHERE Name='" + psp.IName + "' AND ProjectID = '" + projectid + "'" + "AND Type='01'";
//devFirst = (PSPDEV)UCDeviceBase.DataService.GetObject("SelectPSPDEVByCondition", con);
//PSPDEV devLast = new PSPDEV();
//con = " WHERE Name='" + psp.JName + "' AND ProjectID = '" + projectid + "'" + "AND Type='01'";
//devLast = (PSPDEV)UCDeviceBase.DataService.GetObject("SelectPSPDEVByCondition", con);
con = " WHERE Name='" + psp.ISwitch + "' AND ProjectID = '" + projectid + "'" + "AND Type='07'";
IList listiswitch = UCDeviceBase.DataService.GetList("SelectPSPDEVByCondition", con);
con = " WHERE Name='" + psp.JSwitch + "' AND ProjectID = '" + projectid + "'" + "AND Type='07'";
IList listjswitch = UCDeviceBase.DataService.GetList("SelectPSPDEVByCondition", con);
PSPDEV pspiswitch = (PSPDEV)listiswitch[0];
PSPDEV pspjswitch = (PSPDEV)listjswitch[0];
if (pspDev.Number == psp.FirstNode && pspiswitch.KSwitchStatus == "0" && pspjswitch.KSwitchStatus == "0")
{
flag = true;
dlr = "0" + " " + psp.FirstNode + " " + psp.LastNode + " " + psp.Number + " " + "0" + " " + "0";
}
if (pspDev.Number == psp.LastNode && pspiswitch.KSwitchStatus == "0" && pspjswitch.KSwitchStatus == "0")
{
flag = true;
dlr = "0" + " " + psp.FirstNode + " " + psp.LastNode + " " + psp.Number + " " + "1" + " " + "0";
}
if (flag)
{
FileStream VK = new FileStream((System.Windows.Forms.Application.StartupPath + "\\fault.txt"), FileMode.OpenOrCreate);
StreamWriter str11 = new StreamWriter(VK);
str11.Write(dlr);
str11.Close();
if (File.Exists(System.Windows.Forms.Application.StartupPath + "\\ShortcuitI.txt"))
{
File.Delete(System.Windows.Forms.Application.StartupPath + "\\ShortcuitI.txt");
}
// shortcir shortCutCal = new shortcir();
shortCutCal.Show_shortcir(0, 0, 1);
//bool matrixflag=true; //�����ж��Ƿ��ɾ����������Ƿ���������
string matrixstr = null;
if (File.Exists(System.Windows.Forms.Application.StartupPath + "\\Zmatrixcheck.txt"))
{
matrixstr = "�����ɾ���";
// matrixflag = false;
}
if (File.Exists(System.Windows.Forms.Application.StartupPath + "\\Fmatrixcheck.txt"))
{
// matrixflag = false;
matrixstr += "�����ɾ���";
}
if (File.Exists(System.Windows.Forms.Application.StartupPath + "\\Lmatrixcheck.txt"))
{
//matrixflag = false;
matrixstr += "�����ɾ���";
}
if (matrixstr != null)
{
MessageBox.Show(matrixstr + "�����������������������ٽ��м��㣡", "��ʾ", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
if (File.Exists(System.Windows.Forms.Application.StartupPath + "\\ShortcuitI.txt"))
{
}
else
{
return;
}
FileStream shorcuit = new FileStream(System.Windows.Forms.Application.StartupPath + "\\ShortcuitI.txt", FileMode.Open);
StreamReader readLineGU = new StreamReader(shorcuit, System.Text.Encoding.Default);
string strLineGU;
string[] arrayGU;
char[] charSplitGU = new char[] { ' ' };
while ((strLineGU = readLineGU.ReadLine()) != null)
{
while ((strLineGU = readLineGU.ReadLine()) != null)
{
arrayGU = strLineGU.Split(charSplitGU);
string[] shorti = new string[4];
shorti.Initialize();
int m = 0;
foreach (string str in arrayGU)
{
if (str != "")
{
shorti[m++] = str.ToString();
}
}
nodeshorti[pspDev.Number] = Convert.ToDouble(shorti[3]) * 100 / (Math.Sqrt(3) * pspDev.ReferenceVolt);
}
}
readLineGU.Close();
break; //������ѭ�� ����ĸ�ߵ�����һ��ĸ�߶�·
}
if (!flag)
continue;
//������
}
}
if (!flag)
{
con = " ,PSP_ELCDEVICE WHERE PSPDEV.SUID = PSP_ELCDEVICE.DeviceSUID AND PSP_ELCDEVICE.ProjectSUID = '" + projectSUID + "'AND PSPDEV.type='03'AND PSPDEV.KSwitchStatus = '0' AND(PSPDEV.IName='" + pspDev.Name + "'OR PSPDEV.JName='" + pspDev.Name + "'OR PSPDEV.KName='" + pspDev.Name + "') order by PSPDEV.number";
IList list4 = UCDeviceBase.DataService.GetList("SelectPSPDEVByCondition", con);
for (int j = 0; j < list4.Count; j++)
{
dlr = null;
psp = list4[j] as PSPDEV;
//PSPDEV devINode = new PSPDEV();
//con = " WHERE Name='" + psp.IName + "' AND ProjectID = '" + projectid + "'" + "AND Type='01'";
//devINode = (PSPDEV)UCDeviceBase.DataService.GetObject("SelectPSPDEVByCondition", con);
//PSPDEV devJNode = new PSPDEV();
//con = " WHERE Name='" + psp.JName + "' AND ProjectID = '" + projectid + "'" + "AND Type='01'";
//devJNode = (PSPDEV)UCDeviceBase.DataService.GetObject("SelectPSPDEVByCondition", con);
//PSPDEV devKNode = new PSPDEV();
//con = " WHERE Name='" + psp.KName + "' AND ProjectID = '" + projectid + "'" + "AND Type='01'";
//devKNode = (PSPDEV)UCDeviceBase.DataService.GetObject("SelectPSPDEVByCondition", con);
con = " WHERE Name='" + psp.ISwitch + "' AND ProjectID = '" + projectid + "'" + "AND Type='07'";
IList listiswitch = UCDeviceBase.DataService.GetList("SelectPSPDEVByCondition", con);
con = " WHERE Name='" + psp.JSwitch + "' AND ProjectID = '" + projectid + "'" + "AND Type='07'";
IList listjswitch = UCDeviceBase.DataService.GetList("SelectPSPDEVByCondition", con);
con = " WHERE Name='" + psp.HuganLine1 + "' AND ProjectID = '" + projectid + "'" + "AND Type='07'";
IList listkswitch = UCDeviceBase.DataService.GetList("SelectPSPDEVByCondition", con);
PSPDEV pspiswitch = (PSPDEV)listiswitch[0];
PSPDEV pspjswitch = (PSPDEV)listjswitch[0];
PSPDEV pspkswitch = (PSPDEV)listkswitch[0];
if (pspDev.Number == psp.FirstNode & pspiswitch.KSwitchStatus == "0" && pspjswitch.KSwitchStatus == "0" && pspkswitch.KSwitchStatus == "0")
{
flag = true;
dlr = "0" + " " + psp.FirstNode + " " + psp.LastNode + " " + psp.Number + " " + "0" + " " + "0";
}
if (pspDev.Number == psp.LastNode && pspiswitch.KSwitchStatus == "0" && pspjswitch.KSwitchStatus == "0" && pspkswitch.KSwitchStatus == "0")
{
flag = true;
dlr = "0" + " " + psp.FirstNode + " " + psp.LastNode + " " + psp.Number + " " + "1" + " " + "0";
}
if (pspDev.Number == psp.Flag && pspiswitch.KSwitchStatus == "0" && pspjswitch.KSwitchStatus == "0" && pspkswitch.KSwitchStatus == "0")
{
flag = true;
dlr = "0" + " " + psp.FirstNode + " " + psp.Flag + " " + psp.Number + " " + "1" + " " + "0";
}
if (flag)
{
FileStream VK = new FileStream((System.Windows.Forms.Application.StartupPath + "\\fault.txt"), FileMode.OpenOrCreate);
StreamWriter str11 = new StreamWriter(VK);
str11.Write(dlr);
str11.Close();
if (File.Exists(System.Windows.Forms.Application.StartupPath + "\\ShortcuitI.txt"))
{
File.Delete(System.Windows.Forms.Application.StartupPath + "\\ShortcuitI.txt");
}
//shortcir shortCutCal = new shortcir();
shortCutCal.Show_shortcir(0, 0, 1);
//bool matrixflag=true; //�����ж��Ƿ��ɾ����������Ƿ���������
string matrixstr = null;
if (File.Exists(System.Windows.Forms.Application.StartupPath + "\\Zmatrixcheck.txt"))
{
matrixstr = "�����ɾ���";
// matrixflag = false;
}
if (File.Exists(System.Windows.Forms.Application.StartupPath + "\\Fmatrixcheck.txt"))
{
// matrixflag = false;
matrixstr += "�����ɾ���";
}
if (File.Exists(System.Windows.Forms.Application.StartupPath + "\\Lmatrixcheck.txt"))
{
//matrixflag = false;
matrixstr += "�����ɾ���";
}
if (matrixstr != null)
{
MessageBox.Show(matrixstr + "�����������������������ٽ��м��㣡", "��ʾ", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
if (File.Exists(System.Windows.Forms.Application.StartupPath + "\\ShortcuitI.txt"))
{
}
else
{
return;
}
FileStream shorcuit = new FileStream(System.Windows.Forms.Application.StartupPath + "\\ShortcuitI.txt", FileMode.Open);
StreamReader readLineGU = new StreamReader(shorcuit, System.Text.Encoding.Default);
string strLineGU;
string[] arrayGU;
char[] charSplitGU = new char[] { ' ' };
while ((strLineGU = readLineGU.ReadLine()) != null)
{
while ((strLineGU = readLineGU.ReadLine()) != null)
{
arrayGU = strLineGU.Split(charSplitGU);
string[] shorti = new string[4];
shorti.Initialize();
int m = 0;
foreach (string str in arrayGU)
{
if (str != "")
{
shorti[m++] = str.ToString();
}
}
nodeshorti[pspDev.Number] = Convert.ToDouble(shorti[3]) * 100 / (Math.Sqrt(3) * pspDev.ReferenceVolt);
}
}
readLineGU.Close();
break; //������ѭ�� ����ĸ�ߵ�����һ��ĸ�߶�·
}
if (!flag)
continue;
//������
}
}
}
//�ҳ���·��������ֵ
//maxshorti.Key = 1;
//maxshorti.Value = nodeshorti[1];
foreach (KeyValuePair<int, double> keyvalue in nodeshorti)
{
if (keyvalue.Value > maxshorti.Value)
{
maxshorti = keyvalue;
}
}
//����ȡ����·�� �ж�����ĸ���ڲ��� ������ھͽ���ɾ�� Ȼ������ѹ���бȽ�
con = " ,PSP_ELCDEVICE WHERE PSPDEV.SUID = PSP_ELCDEVICE.DeviceSUID AND PSP_ELCDEVICE.ProjectSUID = '" + projectSUID + "'AND PSPDEV.type='06'AND PSPDEV.KSwitchStatus = '0' order by PSPDEV.number";
IList list = UCDeviceBase.DataService.GetList("SelectPSPDEVByCondition", con);
for (int i = 0; i < list.Count; i++)
{
bool flag = false;
pspDev = list[i] as PSPDEV;
for (int j = 0; j < list1.Count; j++)
{
psp = list1[j] as PSPDEV;
if (pspDev.IName == psp.Name)
flag = true;
}
if (!flag)
{
UCDeviceBase.DataService.Delete<PSPDEV>(pspDev);
}
}
con = " ,PSP_ELCDEVICE WHERE PSPDEV.SUID = PSP_ELCDEVICE.DeviceSUID AND PSP_ELCDEVICE.ProjectSUID = '" + projectSUID + "'AND PSPDEV.type='06'AND PSPDEV.KSwitchStatus = '0' order by PSPDEV.number";
list = UCDeviceBase.DataService.GetList("SelectPSPDEVByCondition", con);
for (int i = 0; i < list.Count; i++)
{
pspDev = list[i] as PSPDEV;
pspDev.HuganLine3 = "";
pspDev.KName = "";
if (pspDev.KSwitchStatus == "0")
{
pspDev.OutP = maxshorti.Value;
if (maxshorti.Value > pspDev.HuganTQ1)
{
pspDev.HuganLine3 = "���ϸ�";
}
else
{
pspDev.HuganLine3 = "�ϸ�";
}
pspDev.HuganLine4 = "";
if (pspDev.HuganLine3 == "�ϸ�")
{
pspDev.KName = "�ϸ�";
}
else
pspDev.KName = "���ϸ�";
}
UCDeviceBase.DataService.Update<PSPDEV>(pspDev);
}
switch (caozuoi)
{
case 1: //ȫ����·����
{
pspDev.SvgUID = projectSUID;
pspDev.Type = "06";
DlqiCheckform dlqicheckform = new DlqiCheckform(pspDev);
dlqicheckform.getusercltr.gridView.GroupPanelText = "��·�����������������������";
dlqicheckform.ShowDialog();
break;
}
case 2: //����·����
{
con = " ,PSP_ELCDEVICE WHERE PSPDEV.SUID = PSP_ELCDEVICE.DeviceSUID AND PSP_ELCDEVICE.ProjectSUID = '" + projectSUID + "'AND PSPDEV.type='06'AND PSPDEV.KSwitchStatus = '0' order by PSPDEV.number";
list = UCDeviceBase.DataService.GetList("SelectPSPDEVByCondition", con);
for (int i = 0; i < list.Count; i++)
{
pspDev = list[i] as PSPDEV;
if (pspDev.KSwitchStatus == "0")
{
con = ",PSP_ELCDEVICE WHERE PSPDEV.SUID = PSP_ELCDEVICE.DeviceSUID AND PSP_ELCDEVICE.ProjectSUID = '" + projectSUID + "'AND PSPDEV.type='01'AND PSPDEV.KSwitchStatus = '0'AND PSPDEV.Name='" + pspDev.IName + "'";
IList list4 = UCDeviceBase.DataService.GetList("SelectPSPDEVByCondition", con);
psp = list4[0] as PSPDEV;
try
{
pspDev.OutQ = nodeshorti[psp.Number];
if (pspDev.HuganLine3 == "���ϸ�")
{
if (pspDev.OutQ <= pspDev.HuganTQ1)
{
pspDev.HuganLine3 = "�ϸ�";
}
}
pspDev.HuganLine4 = "";
if (pspDev.HuganLine3 == "�ϸ�")
{
pspDev.KName = "�ϸ�";
}
else
pspDev.KName = "���ϸ�";
UCDeviceBase.DataService.Update<PSPDEV>(pspDev);
}
catch (System.Exception ex)
{
MessageBox.Show("��·���ݲ�����");
}
}
}
pspDev.SvgUID = projectSUID;
pspDev.Type = "06";
DlqiCheckform dlqicheckform = new DlqiCheckform(pspDev);
dlqicheckform.getusercltr.gridView.GroupPanelText = "����·У�˽����";
dlqicheckform.ShowDialog();
break;
}
case 3: //��·��ֱ������
{
con = " ,PSP_ELCDEVICE WHERE PSPDEV.SUID = PSP_ELCDEVICE.DeviceSUID AND PSP_ELCDEVICE.ProjectSUID = '" + projectSUID + "'AND PSPDEV.type='06'AND PSPDEV.KSwitchStatus = '0' order by PSPDEV.number";
list = UCDeviceBase.DataService.GetList("SelectPSPDEVByCondition", con);
for (int i = 0; i < list.Count; i++)
{
pspDev = list[i] as PSPDEV;
if (pspDev.KSwitchStatus == "0")
{
double tx = 0.0;
if (pspDev.HuganLine2 == "���ѿ۶�·��")
{
tx = 0.0;
}
else if (pspDev.HuganLine2 == "���������ѿ۵Ķ�·��")
{
tx = 10;
}
pspDev.HuganTQ4 = (pspDev.OutP / pspDev.HuganTQ1) * Math.Exp((-pspDev.HuganTQ2 - tx) / 45) * 100;
pspDev.HuganTQ5 = (pspDev.OutQ / pspDev.HuganTQ1) * Math.Exp((-pspDev.HuganTQ2 - tx) / 45) * 100;
if (pspDev.HuganTQ3 >= pspDev.HuganTQ4)
{
pspDev.HuganLine4 = "�ϸ�";
}
if (pspDev.HuganTQ3 >= pspDev.HuganTQ5)
{
pspDev.HuganLine4 = "�ϸ�";
}
else if (pspDev.HuganTQ3 < pspDev.HuganTQ5)
{
pspDev.HuganLine4 = "���ϸ�";
}
if (pspDev.HuganLine3 == "�ϸ�" && pspDev.HuganLine4 == "�ϸ�")
{
pspDev.KName = "�ϸ�";
}
else
{
pspDev.KName = "���ϸ�";
}
UCDeviceBase.DataService.Update<PSPDEV>(pspDev);
}
}
pspDev.SvgUID = projectSUID;
pspDev.Type = "06";
DlqiCheckform dlqicheckform = new DlqiCheckform(pspDev);
dlqicheckform.getusercltr.gridView.GroupPanelText = "��·��������������������";
dlqicheckform.ShowDialog();
break;
}
}
}
catch (System.Exception ex)
{
MessageBox.Show("��·����������������·�����Ƿ��ܽ��У�");
}
}
public void AllShort(string projectSUID, string projectid, int dulutype, double ratecaplity, frnReport wFrom)
{
try
{
wFrom.ShowText += "\r\n��ʼ����·��������\t" + System.DateTime.Now.ToString();
//OutType = 1;
if (Compuflag == 1)
{
ElectricLoadCal elcc = new ElectricLoadCal();
elcc.LFCS(projectSUID, 1, (float)ratecaplity);
if (!CheckDLL(projectSUID, projectid, ratecaplity))
{
return;
}
}
else
{
if (!CheckDL(projectSUID, projectid, ratecaplity))
{
return;
}
}
System.Windows.Forms.Clipboard.Clear();
Dictionary<int, double> nodeshorti = new Dictionary<int, double>(); //��¼ĸ����û�н��й���·
KeyValuePair<int, double> maxshorti = new KeyValuePair<int, double>(); //ȡ����·������·����
string con = ",PSP_ELCDEVICE WHERE PSPDEV.SUID = PSP_ELCDEVICE.DeviceSUID AND PSP_ELCDEVICE.ProjectSUID = '" + projectSUID + "'AND PSPDEV.type='01'AND PSPDEV.KSwitchStatus = '0' order by PSPDEV.number";
PSPDEV pspDev = new PSPDEV();
IList list1 = UCDeviceBase.DataService.GetList("SelectPSPDEVByCondition", con);
con = " ,PSP_ELCDEVICE WHERE PSPDEV.SUID = PSP_ELCDEVICE.DeviceSUID AND PSP_ELCDEVICE.ProjectSUID = '" + projectSUID + "'AND PSPDEV.type in ('05','03','02') AND PSPDEV.KSwitchStatus = '0'order by PSPDEV.number";
IList list2 = UCDeviceBase.DataService.GetList("SelectPSPDEVByCondition", con);
PSPDEV psp = new PSPDEV();
psp = list2[0] as PSPDEV;
string data = System.DateTime.Now.ToString("d");
string time = System.DateTime.Now.ToString("T");
StringBuilder duanResult = new StringBuilder();
duanResult.Append("��·�������" + "\r\n" + "\r\n");
duanResult.Append("��·��ҵ�ţ�1" + "\r\n");
duanResult.Append("��·�������ڣ�" + data + " " + "ʱ�䣺" + time + "\r\n");
duanResult.Append("���kA" + "\r\n");
StringBuilder dianYaResult = new StringBuilder();
dianYaResult.Append("ĸ�ߵ�ѹ���" + "\r\n" + "\r\n");
dianYaResult.Append("��·��ҵ�ţ�1" + "\r\n");
dianYaResult.Append("��·�������ڣ�" + data + " " + "ʱ�䣺" + time + "\r\n");
dianYaResult.Append("��λ����ֵ( p.u. ) �Ƕ�(deg.)" + "\r\n");
StringBuilder dianLiuResult = new StringBuilder();
dianLiuResult.Append("֧·�������" + "\r\n" + "\r\n");
dianLiuResult.Append("��·��ҵ�ţ�1" + "\r\n");
dianLiuResult.Append("��·�������ڣ�" + data + " " + "ʱ�䣺" + time + "\r\n");
dianLiuResult.Append("��λ����ֵ( p.u. ) �Ƕ�(deg.)" + "\r\n");
int intshorti = 0; //��һ�м�¼��ΪҪ����·����������˵��
bool shortiflag = false;
int muxiannum = 0; //��¼һ��ĸ�߶�·�� �ж��ٸ���¼ĸ�ߵ�ѹ
int linenum = 0; //��¼һ��ĸ�߶�· �ж��ٸ���·����
shortbuscir shortCutCal = new shortbuscir(Compuflag);
if (File.Exists(System.Windows.Forms.Application.StartupPath + "\\fault.txt"))
{
File.Delete(System.Windows.Forms.Application.StartupPath + "\\fault.txt");
}
string dlr = null;
if (psp != null)
{
dlr = "0" + " " + psp.FirstNode + " " + psp.LastNode + " " + psp.Number + " " + "0 " + " " + dulutype;
}
else
{
return;
}
FileStream VK = new FileStream((System.Windows.Forms.Application.StartupPath + "\\fault.txt"), FileMode.OpenOrCreate);
StreamWriter str11 = new StreamWriter(VK);
str11.Write(dlr);
str11.Close();
if (File.Exists(System.Windows.Forms.Application.StartupPath + "\\ShortcuitI.txt"))
{
File.Delete(System.Windows.Forms.Application.StartupPath + "\\ShortcuitI.txt");
}
if (File.Exists(System.Windows.Forms.Application.StartupPath + "\\Sxdianliu.txt"))
{
File.Delete(System.Windows.Forms.Application.StartupPath + "\\Sxdianliu.txt");
}
if (File.Exists(System.Windows.Forms.Application.StartupPath + "\\Sxdianya.txt"))
{
File.Delete(System.Windows.Forms.Application.StartupPath + "\\Sxdianya.txt");
}
wFrom.ShowText += "\r\n��ʼ���ж�·����\t" + System.DateTime.Now.ToString();
shortCutCal.Show_shortcir(Compuflag, OutType, 0);
string matrixstr = null;
if (File.Exists(System.Windows.Forms.Application.StartupPath + "\\Zmatrixcheck.txt"))
{
matrixstr = "�����ɾ���";
// matrixflag = false;
}
if (File.Exists(System.Windows.Forms.Application.StartupPath + "\\Fmatrixcheck.txt"))
{
// matrixflag = false;
matrixstr += "�����ɾ���";
}
if (File.Exists(System.Windows.Forms.Application.StartupPath + "\\Lmatrixcheck.txt"))
{
//matrixflag = false;
matrixstr += "�����ɾ���";
}
if (matrixstr != null)
{
System.Windows.Forms.MessageBox.Show(matrixstr + "�����������������������ٽ��м��㣡", "��ʾ", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Information);
return;
}
if (File.Exists(System.Windows.Forms.Application.StartupPath + "\\ShortcuitI.txt"))
{
}
else
{
wFrom.ShowText += "\r\n��·����ʧ��\t" + System.DateTime.Now.ToString();
return;
}
wFrom.ShowText += "\r\n��ʼ�����·������\t" + System.DateTime.Now.ToString();
FileStream shorcuit = new FileStream(System.Windows.Forms.Application.StartupPath + "\\ShortcuitI.txt", FileMode.Open);
StreamReader readLineGU = new StreamReader(shorcuit, System.Text.Encoding.Default);
string strLineGU;
string[] arrayGU;
char[] charSplitGU = new char[] { ' ' };
intshorti = 0;
while ((strLineGU = readLineGU.ReadLine()) != null)
{
arrayGU = strLineGU.Split(charSplitGU, StringSplitOptions.RemoveEmptyEntries);
string[] shorti = arrayGU;
shorti.Initialize();
//int m = 0;
//foreach (string str in arrayGU)
//{
// if (str != "")
// {
// shorti[m++] = str.ToString();
// }
//}
if (intshorti == 0)
{
if (!shortiflag)
{
duanResult.Append(shorti[0] + "," + shorti[1] + "," + shorti[3] + "\r\n");
shortiflag = true;
}
}
else
duanResult.Append(shorti[0] + "," + shorti[1] + "," + Convert.ToDouble(shorti[3]) + "\r\n");
intshorti++;
// wf.SetCaption(intshorti.ToString());
}
readLineGU.Close();
if (OutType == 0)
{
//**��ȡ�����ѹ��ֵ
if (File.Exists(System.Windows.Forms.Application.StartupPath + "\\Sxdianya.txt"))
{
}
else
{
wFrom.ShowText += "\r\n��·����ʧ��\t" + System.DateTime.Now.ToString();
return;
}
FileStream dianYa = new FileStream(System.Windows.Forms.Application.StartupPath + "\\Sxdianya.txt", FileMode.Open);
StreamReader readLineDY = new StreamReader(dianYa, System.Text.Encoding.Default);
string strLineDY;
string[] arrayDY;
char[] charSplitDY = new char[] { ' ' };
strLineDY = readLineDY.ReadLine();
int j = 0;
muxiannum = 0;
while (strLineDY != null)
{
arrayDY = strLineDY.Split(charSplitDY, StringSplitOptions.RemoveEmptyEntries);
//int m = 0;
string[] dev = arrayDY;
//dev.Initialize();
//foreach (string str in arrayDY)
//{
// if (str != "")
// {
// dev[m++] = str;
// }
//}
if (j == 0)
{
//dianYaResult += "\r\n" + "����ĸ�ߣ�" + pspDev.Name + "\r\n";
dianYaResult.Append(dev[0] + "," + dev[1] + "," + dev[2] + "," + dev[3] + "," + dev[4] + "," + dev[5] + "," + dev[6] + "," + dev[7] + "," + dev[8] + "," +
dev[9] + "," + dev[10] + "," + dev[11] + "," + dev[12] + "," + dev[13] + "\r\n");
}
else
{
if (dev[0] == "����ĸ��")
{
dianYaResult.Append("\r\n" + "����ĸ�ߣ�" + dev[1] + "\r\n");
muxiannum++;
}
else
{
bool dianyaflag = true; //�жϴ�ĸ���Ƕ�·��ĸ����һ���ĸ��
PSPDEV CR = new PSPDEV();
if (dev[1] != "du")
{
con = ",PSP_ELCDEVICE WHERE PSPDEV.SUID = PSP_ELCDEVICE.DeviceSUID AND PSP_ELCDEVICE.ProjectSUID = '" + projectSUID + "'AND PSPDEV.type='01'AND PSPDEV.Name='" + dev[1] + "'";
//con = " WHERE Name='" + dev[1] + "' AND ProjectID = '" + projectid + "'" + "AND Type='01'";
CR = (PSPDEV)UCDeviceBase.DataService.GetObject("SelectPSPDEVByCondition", con);
if (CR == null)
{
dianyaflag = false;
}
}
//else
//{
// dianyaflag = false;
// CR.Name = duanluname;
// CR = (PSPDEV)UCDeviceBase.DataService.GetObject("SelectPSPDEVByNameANDSVG", CR);
//}
if (dianyaflag)
dianYaResult.Append(dev[0] + "," + dev[1] + "," + Convert.ToDouble(dev[2]) * CR.ReferenceVolt + "," + dev[3] + "," + Convert.ToDouble(dev[4]) * CR.ReferenceVolt + "," + dev[5] + "," + Convert.ToDouble(dev[6]) * CR.ReferenceVolt + "," + dev[7] + "," + Convert.ToDouble(dev[8]) * CR.ReferenceVolt + "," +
dev[9] + "," + Convert.ToDouble(dev[10]) * CR.ReferenceVolt + "," + dev[11] + "," + Convert.ToDouble(dev[12]) * CR.ReferenceVolt + "," + dev[13] + "\r\n");
//else
// dianYaResult.Append( dev[0] + "," + duanluname + "�϶�·��" + "," + Convert.ToDouble(dev[2]) * CR.ReferenceVolt + "," + dev[3] + "," + Convert.ToDouble(dev[4]) * CR.ReferenceVolt + "," + dev[5] + "," + Convert.ToDouble(dev[6]) * CR.ReferenceVolt + "," + dev[7] + "," + Convert.ToDouble(dev[8]) * CR.ReferenceVolt + "," +
// dev[9] + "," + Convert.ToDouble(dev[10]) * CR.ReferenceVolt + "," + dev[11] + Convert.ToDouble(dev[12]) * CR.ReferenceVolt + "," + dev[13] + "\r\n";
}
}
strLineDY = readLineDY.ReadLine();
j++;
//wf.SetCaption(muxiannum.ToString());
}
readLineDY.Close();
//**��ȡ���������ֵ
if (File.Exists(System.Windows.Forms.Application.StartupPath + "\\Sxdianliu.txt"))
{
}
else
{
wFrom.ShowText += "\r\n��·����ʧ��\t" + System.DateTime.Now.ToString();
return;
}
FileStream dianLiu = new FileStream(System.Windows.Forms.Application.StartupPath + "\\Sxdianliu.txt", FileMode.Open);
StreamReader readLineDL = new StreamReader(dianLiu, System.Text.Encoding.Default);
string strLineDL;
string[] arrayDL;
char[] charSplitDL = new char[] { ' ' };
strLineDL = readLineDL.ReadLine();
j = 0;
int jxflag = 0; //��¼��һ��ĸ�߶�·ʱ����·����
linenum = 0;
while (strLineDL != null)
{
arrayDL = strLineDL.Split(charSplitDL, StringSplitOptions.RemoveEmptyEntries);
int m = 0;
string[] dev = arrayDL;
//dev.Initialize();
//foreach (string str in arrayDL)
//{
// if (str != "")
// {
// dev[m++] = str;
// }
//}
if (j == 0)
{
//dianLiuResult.Append( "\r\n" + "����ĸ�ߣ�" + pspDev.Name + "\r\n";
dianLiuResult.Append(dev[0] + "," + dev[1] + "," + dev[2] + "," + dev[3] + "," + dev[4] + "," + dev[5] + "," + dev[6] + "," + dev[7] + "," + dev[8] + "," +
dev[9] + "," + dev[10] + "," + dev[11] + "," + dev[12] + "," + dev[13] + "," + dev[14] + "\r\n");
}
else
{
if (dev[0] == "����ĸ��")
{
dianLiuResult.Append("\r\n" + "����ĸ�ߣ�" + dev[1] + "\r\n");
jxflag++;
}
else
{
PSPDEV CR = new PSPDEV();
if (dev[0] != "du")
{
con = ",PSP_ELCDEVICE WHERE PSPDEV.SUID = PSP_ELCDEVICE.DeviceSUID AND PSP_ELCDEVICE.ProjectSUID = '" + projectSUID + "'AND PSPDEV.type='01'AND PSPDEV.Name='" + dev[0] + "'";
//con = " WHERE Name='" + dev[0] + "' AND ProjectID = '" + projectid + "'" + "AND Type='01'";
}
else
con = ",PSP_ELCDEVICE WHERE PSPDEV.SUID = PSP_ELCDEVICE.DeviceSUID AND PSP_ELCDEVICE.ProjectSUID = '" + projectSUID + "'AND PSPDEV.type='01'AND PSPDEV.Name='" + dev[1] + "'";
//con = " WHERE Name='" + dev[1] + "' AND ProjectID = '" + projectid + "'" + "AND Type='01'";
CR = (PSPDEV)UCDeviceBase.DataService.GetObject("SelectPSPDEVByCondition", con);
dianLiuResult.Append(dev[0] + "," + dev[1] + "," + dev[2] + "," + Convert.ToDouble(dev[3]) * ratecaplity / (Math.Sqrt(3) * CR.ReferenceVolt) + "," + dev[4] + "," + Convert.ToDouble(dev[5]) * ratecaplity / (Math.Sqrt(3) * CR.ReferenceVolt) + "," + dev[6] + "," + Convert.ToDouble(dev[7]) * ratecaplity / (Math.Sqrt(3) * CR.ReferenceVolt) + "," + dev[8] + "," +
Convert.ToDouble(dev[9]) * ratecaplity / (Math.Sqrt(3) * CR.ReferenceVolt) + "," + dev[10] + "," + Convert.ToDouble(dev[11]) * ratecaplity / (Math.Sqrt(3) * CR.ReferenceVolt) + "," + dev[12] + "," + Convert.ToDouble(dev[13]) * ratecaplity / (Math.Sqrt(3) * CR.ReferenceVolt) + "," + dev[14] + "\r\n");
}
//��Ϊ����·�������ʱ����һ����·�ĵ��������������������·�ĵ������нӵص������͵翹���ĵ��������ֻ���������������
}
strLineDL = readLineDL.ReadLine();
j++;
if (jxflag==1)
{
linenum++;
}
// wf.SetCaption(linenum.ToString());
}
readLineDL.Close();
}
wFrom.ShowText += "\r\n��ʼ���ɱ���\t" + System.DateTime.Now.ToString();
//д�뱨����
if (File.Exists(System.Windows.Forms.Application.StartupPath + "\\result.csv"))
{
File.Delete(System.Windows.Forms.Application.StartupPath + "\\result.csv");
}
FileStream tempGU = new FileStream((System.Windows.Forms.Application.StartupPath + "\\result.csv"), FileMode.OpenOrCreate);
StreamWriter strGU = new StreamWriter(tempGU, Encoding.Default);
strGU.Write(duanResult.ToString());
strGU.Close();
if (File.Exists(System.Windows.Forms.Application.StartupPath + "\\result1.csv"))
{
File.Delete(System.Windows.Forms.Application.StartupPath + "\\result1.csv");
}
FileStream tempDY = new FileStream((System.Windows.Forms.Application.StartupPath + "\\result1.csv"), FileMode.OpenOrCreate);
StreamWriter strDY = new StreamWriter(tempDY, Encoding.Default);
strDY.Write(dianYaResult.ToString());
strDY.Close();
if (File.Exists(System.Windows.Forms.Application.StartupPath + "\\result2.csv"))
{
File.Delete(System.Windows.Forms.Application.StartupPath + "\\result2.csv");
}
FileStream tempDL = new FileStream((System.Windows.Forms.Application.StartupPath + "\\result2.csv"), FileMode.OpenOrCreate);
StreamWriter strDL = new StreamWriter(tempDL, Encoding.Default);
strDL.Write(dianLiuResult);
strDL.Close();
PSP_ELCPROJECT psproject = new PSP_ELCPROJECT();
psproject.ID = projectSUID;
psproject = (PSP_ELCPROJECT)UCDeviceBase.DataService.GetObject("SelectPSP_ELCPROJECTByKey", psproject);
if (File.Exists(System.Windows.Forms.Application.StartupPath + "\\" + psproject.Name + "ȫ����·������.xls"))
{
File.Delete(System.Windows.Forms.Application.StartupPath + "\\" + psproject.Name + "ȫ����·������.xls");
}
Excel.Application ex;
Excel.Worksheet xSheet;
Excel.Application result1;
Excel.Application result2;
Excel.Worksheet tempSheet;
Excel.Worksheet tempSheet1;
Excel.Worksheet newWorksheet;
Excel.Worksheet newWorkSheet1;
object oMissing = System.Reflection.Missing.Value;
ex = new Excel.Application();
ex.Application.Workbooks.Add(System.Windows.Forms.Application.StartupPath + "\\result.csv");
xSheet = (Excel.Worksheet)ex.Worksheets[1];
xSheet.Name = "��·����";
ex.Visible = true;
xSheet.UsedRange.Font.Name = "����_GB2312";
//��¼��Ϊ��·������ʽ
xSheet.get_Range(xSheet.Cells[1, 1], xSheet.Cells[1, 3]).MergeCells = true;
xSheet.get_Range(xSheet.Cells[1, 1], xSheet.Cells[1, 1]).Font.Size = 20;
xSheet.get_Range(xSheet.Cells[1, 1], xSheet.Cells[1, 1]).Font.Name = "����";
xSheet.get_Range(xSheet.Cells[1, 1], xSheet.Cells[1, 1]).HorizontalAlignment = Excel.XlHAlign.xlHAlignCenter;
xSheet.get_Range(xSheet.Cells[6, 1], xSheet.Cells[6, 3]).Interior.ColorIndex = 45;
xSheet.get_Range(xSheet.Cells[7, 1], xSheet.Cells[xSheet.UsedRange.Rows.Count, 1]).Interior.ColorIndex = 6;
xSheet.get_Range(xSheet.Cells[4, 3], xSheet.Cells[xSheet.UsedRange.Rows.Count, 13]).NumberFormat = "0.0000_ ";
if (muxiannum>50)
{
if (OutType == 0)
{
if (MessageBox.Show("����ʾ�����ѹʱ���ܵ����ݳ����˱���ij��ܷ�Χ��ѡ���Ƿ����?", "��ʾ", MessageBoxButtons.YesNo, MessageBoxIcon.Information) != DialogResult.Yes)
{
OutType=1;
}
}
}
if (OutType == 0)
{
ex.Worksheets.Add(System.Reflection.Missing.Value, xSheet, 1, System.Reflection.Missing.Value);
xSheet = (Excel.Worksheet)ex.Worksheets[2];
ex.Worksheets.Add(System.Reflection.Missing.Value, xSheet, 1, System.Reflection.Missing.Value);
xSheet = (Excel.Worksheet)ex.Worksheets[1];
result1 = new Excel.Application();
result1.Application.Workbooks.Add(System.Windows.Forms.Application.StartupPath + "\\result1.csv");
result2 = new Excel.Application();
result2.Application.Workbooks.Add(System.Windows.Forms.Application.StartupPath + "\\result2.csv");
tempSheet = (Excel.Worksheet)result1.Worksheets.get_Item(1);
tempSheet1 = (Excel.Worksheet)result2.Worksheets.get_Item(1);
newWorksheet = (Excel.Worksheet)ex.Worksheets.get_Item(2);
newWorkSheet1 = (Excel.Worksheet)ex.Worksheets.get_Item(3);
newWorksheet.Name = "ĸ�ߵ�ѹ";
newWorkSheet1.Name = "֧·����";
tempSheet.Cells.Select();
tempSheet.Cells.Copy(System.Reflection.Missing.Value);
newWorksheet.Paste(System.Reflection.Missing.Value, System.Reflection.Missing.Value);
tempSheet1.Cells.Select();
tempSheet1.Cells.Copy(System.Reflection.Missing.Value);
newWorkSheet1.Paste(System.Reflection.Missing.Value, System.Reflection.Missing.Value);
newWorksheet.UsedRange.Font.Name = "����_GB2312";
newWorkSheet1.UsedRange.Font.Name = "����_GB2312";
//ĸ�ߵ�ѹ��ʾ��ʽ
newWorksheet.get_Range(newWorksheet.Cells[1, 1], newWorksheet.Cells[1, 14]).MergeCells = true;
newWorksheet.get_Range(newWorksheet.Cells[1, 1], newWorksheet.Cells[1, 1]).Font.Size = 20;
newWorksheet.get_Range(newWorksheet.Cells[1, 1], newWorksheet.Cells[1, 1]).Font.Name = "����";
newWorksheet.get_Range(newWorksheet.Cells[1, 1], newWorksheet.Cells[1, 1]).HorizontalAlignment = Excel.XlHAlign.xlHAlignCenter;
if (OutType == 0)
{
for (int m = 0; m < muxiannum ; m++)
{
newWorksheet.get_Range(newWorksheet.Cells[m * (muxiannum + 2) + 8, 1], newWorksheet.Cells[m * (muxiannum + 2) + 8, 14]).Interior.ColorIndex = 45;
newWorksheet.get_Range(newWorksheet.Cells[m * (muxiannum + 2) + 9, 1], newWorksheet.Cells[m * (muxiannum + 2) + 8 + muxiannum, 1]).Interior.ColorIndex = 6;
newWorksheet.get_Range(newWorksheet.Cells[m * (muxiannum + 2) + 9, 3], newWorksheet.Cells[m * (muxiannum + 2) + 8 + muxiannum - 1, 13]).NumberFormat = "0.0000_ ";
}
}
////��·�����������ʾ��ʽ
newWorkSheet1.get_Range(newWorkSheet1.Cells[1, 1], newWorkSheet1.Cells[1, 15]).MergeCells = true;
newWorkSheet1.get_Range(newWorkSheet1.Cells[1, 1], newWorkSheet1.Cells[1, 1]).Font.Size = 20;
newWorkSheet1.get_Range(newWorkSheet1.Cells[1, 1], newWorkSheet1.Cells[1, 1]).Font.Name = "����";
newWorkSheet1.get_Range(newWorkSheet1.Cells[1, 1], newWorkSheet1.Cells[1, 1]).HorizontalAlignment = Excel.XlHAlign.xlHAlignCenter;
if (OutType == 0)
{
for (int m = 0; m < muxiannum; m++)
{
newWorkSheet1.get_Range(newWorkSheet1.Cells[m * (linenum-1 + 2) + 8, 1], newWorkSheet1.Cells[m * (linenum-1 + 2) + 8, 15]).Interior.ColorIndex = 45;
newWorkSheet1.get_Range(newWorkSheet1.Cells[m * (linenum - 1 + 2) + 9, 1], newWorkSheet1.Cells[m * (linenum - 1 + 2) + 8 + linenum - 1, 1]).Interior.ColorIndex = 6;
newWorkSheet1.get_Range(newWorkSheet1.Cells[m * (linenum - 1 + 2) + 9, 2], newWorkSheet1.Cells[m * (linenum - 1 + 2) + 8 + linenum - 1, 2]).Interior.ColorIndex = 6;
newWorkSheet1.get_Range(newWorkSheet1.Cells[m * (linenum - 1 + 2) + 9, 3], newWorkSheet1.Cells[m * (linenum - 1 + 2) + 8 + linenum - 1, 3]).Interior.ColorIndex = 6;
newWorkSheet1.get_Range(newWorkSheet1.Cells[m * (linenum - 1 + 2) + 9, 4], newWorkSheet1.Cells[m * (linenum - 1 + 2) + 8 + linenum - 1, 14]).NumberFormat = "0.0000_ ";
}
}
System.Windows.Forms.Clipboard.Clear();
newWorksheet.Rows.AutoFit();
newWorksheet.Columns.AutoFit();
newWorkSheet1.Rows.AutoFit();
newWorkSheet1.Columns.AutoFit();
newWorksheet.SaveAs(System.Windows.Forms.Application.StartupPath + "\\" + psproject.Name + "ȫ����·������.xls", Excel.XlFileFormat.xlXMLSpreadsheet, null, null, false, false, false, null, null, null);
result1.Workbooks.Close();
result1.Quit();
result2.Workbooks.Close();
result2.Quit();
}
xSheet.Rows.AutoFit();
xSheet.Columns.AutoFit();
System.Windows.Forms.Clipboard.Clear();
ex.DisplayAlerts = false;
wFrom.ShowText += "\r\n��·�������\t" + System.DateTime.Now.ToString();
}
catch (System.Exception ex)
{
wFrom.ShowText += "\r\n��·����ʧ��\t" + System.DateTime.Now.ToString();
MessageBox.Show("��·���ݴ������⣬�迹�����ڻ��ߴ��ڹ����ڵ㣬���֤���ٽ��У�");
}
}