private void Refreh_N_Chapter2(string year, Word.Bookmarks W_bkm, string type)
{
int newyear = int.Parse(year) - 1;
string old_value = "����ԭֵ";
string tiaojian = "";
MKData mk_chapter2 = new MKData();
mk_chapter2.ZJname = "�ڶ���";
#region //ȫ���˿���ǩ
BQData CP2_bq1 = new BQData();
CP2_bq1.BQname = "B_M_ceebc1ae_440a_426e_9fc0_1dafd06177d5";
tiaojian = " a.ProjectID='" + ProjID + "' and (a.Area not like '%������%' and a.Area not like '%��' and a.Area not like '%��') and b.Yearf=" + newyear;
if (Services.BaseService.GetObject("SelectAreaDataPopulation_notcity_ByArea", tiaojian) != null)
{
double tempdb = (double)Services.BaseService.GetObject("SelectAreaDataPopulation_notcity_ByArea", tiaojian);
CP2_bq1.BQdata = tempdb.ToString();
}
else
{
CP2_bq1.BQdata = old_value;
}
mk_chapter2.Data.Add(CP2_bq1);
#endregion
#region //ȫ�����
BQData CP2_bq2 = new BQData();
CP2_bq2.BQname = "B_M_bed91ba9_3409_4e17_b47c_23a436748b69";
if (Services.BaseService.GetObject("SelectAreaData_TotalArea_SUM", tiaojian) != null)
{
double tempdb = (double)Services.BaseService.GetObject("SelectAreaData_TotalArea_SUM", tiaojian);
CP2_bq2.BQdata = tempdb.ToString();
}
else
{
CP2_bq2.BQdata = old_value;
}
mk_chapter2.Data.Add(CP2_bq2);
#endregion
#region //�������
BQData CP2_bq3 = new BQData();
CP2_bq3.BQname = "B_M_2a9a2aa4_b843_4060_b660_b3e873988285";
CP2_bq3.BQdata = newyear.ToString();
mk_chapter2.Data.Add(CP2_bq3);
#endregion
#region //ȫ���˿�
BQData CP2_bq4 = new BQData();
CP2_bq4.BQname = "B_M_5fc9d479_a28b_4d50_bcf9_982bdfb570e8";
CP2_bq4.BQdata = CP2_bq1.BQdata;
mk_chapter2.Data.Add(CP2_bq4);
#endregion
//ִ�и��²���
BookMark_RefreaDat(W_bkm, mk_chapter2, type);
}
//���±�ǩֵ�Զ�/�ֶ� type="�Զ�"����"�ֶ�"
private void BookMark_RefreaDat(Word.Bookmarks BM, MKData objMKD,string type)
{
if (objMKD.Data.Count > 0)
{
if (type=="�Զ�")
{
for (int i = 0; i < objMKD.Data.Count; i++)
{
object mkname = objMKD.Data[i].BQname.ToString();
//���ڱ�ǩ��ѡ����ֵ
if ( BM.Exists(mkname.ToString()))
{
Word.Range tmpRng = BM.get_Item(ref mkname).Range;
//����ֵ�����
if (objMKD.Data[i].BQdata.ToString() != "����ԭֵ")
{
tmpRng.Text = objMKD.Data[i].BQdata.ToString();
object oRng = tmpRng;
BM.Add(mkname.ToString(), ref oRng);
}
//û�в鵽��ֵ��ԭֵ���ú�ɫ���
else
{
tmpRng.Font.Color = Word.WdColor.wdColorRed;
}
}
}
//����
SaveData_Word();
//������ǩ��
string conn = "LayoutID='" + LayoutID + "' order by StartP";
IList<LayoutBookMark> marklist = Common.Services.BaseService.GetList<LayoutBookMark>("SelectLayoutBookMarkList", conn);
for (int i = 0; i < marklist.Count; i++)
{
if (BM.Exists(marklist[i].UID.ToString()))
{
object tempid=marklist[i].UID.ToString();
Word.Bookmark tempmk = BM.get_Item(ref tempid);
if (tempmk.Range.Text.Length>200)
{
marklist[i].MarkText = tempmk.Range.Text.Substring(0, 200);
}
else
{
marklist[i].MarkText=tempmk.Range.Text;
}
marklist[i].StartP=tempmk.Start;
//�������ݿ�
Common.Services.BaseService.Update<LayoutBookMark>(marklist[i]);
}
}
}
}
if (type=="�ֶ�")
{
string conn = "LayoutID='" + LayoutID + "' order by StartP";
IList<LayoutBookMark> templist = Common.Services.BaseService.GetList<LayoutBookMark>("SelectLayoutBookMarkList", conn);
if (templist.Count==0)
{
return;
}
Frm_FindandChangeTL fft = new Frm_FindandChangeTL();
fft.W_Bkm = BM;
fft.mkd = objMKD;
fft.layoutID = LayoutID;
fft.ShowDialog();
if (fft.DialogResult==DialogResult.OK)
{
//������ǩ��
string connstr = "LayoutID='" + LayoutID + "' order by StartP";
IList<LayoutBookMark> marklist = Common.Services.BaseService.GetList<LayoutBookMark>("SelectLayoutBookMarkList", connstr);
for (int i = 0; i < marklist.Count; i++)
{
if (BM.Exists(marklist[i].UID.ToString()))
{
object tempid = marklist[i].UID.ToString();
Word.Bookmark tempmk = BM.get_Item(ref tempid);
marklist[i].MarkText = tempmk.Range.Text;
marklist[i].StartP = tempmk.Start;
//�������ݿ�
Common.Services.BaseService.Update<LayoutBookMark>(marklist[i]);
}
}
//����
SaveData_Word();
}
if (MessageBox.Show(objMKD.ZJname + "������ɣ�������ȡ����", "ѯ��", MessageBoxButtons.YesNo) == DialogResult.No)
{
RefFalg = false;
}
}
}
//�����½�ִ����Ӧ�IJ���
private void Change_Data_byChapter(string chapter,string year,Word.Bookmarks W_bkm,string type,string leixing)
{
MKData mk_chaptertemp = new MKData();
if (leixing=="����")
{
switch (chapter)
{
case "��һ��":
Refreh_P_Chapter1(year, W_bkm, type);
break;
case "�ڶ���":
Refreh_P_Chapter2(year, W_bkm, type);
break;
case "3.1":
Refreh_P_Chapter31(year, W_bkm, type);
break;
case "3.2":
Refreh_P_Chapter32(year, W_bkm, type);
break;
case "4.2":
Refreh_P_Chapter42(year, W_bkm, type);
break;
case "4.7":
Refreh_P_Chapter47(year, W_bkm, type);
break;
case "6.2":
Refreh_P_Chapter62(year, W_bkm, type);
break;
case "6.3":
Refreh_P_Chapter63(year, W_bkm, type);
break;
default:
//ִ�и��²���
BookMark_RefreaDat(W_bkm, mk_chaptertemp, type);
break;
}
}
if (leixing == "ũ��")
{
switch (chapter)
{
case "�ڶ���":
Refreh_N_Chapter2(year, W_bkm, type);
break;
case "������":
Refreh_N_Chapter3(year, W_bkm, type);
break;
//case "3.1":
// Refreh_P_Chapter31(year, W_bkm, type);
// break;
//case "3.2":
// Refreh_P_Chapter32(year, W_bkm, type);
// break;
//case "4.2":
// Refreh_P_Chapter42(year, W_bkm, type);
// break;
//case "4.7":
// Refreh_P_Chapter47(year, W_bkm, type);
// break;
//case "6.2":
// Refreh_P_Chapter62(year, W_bkm, type);
// break;
//case "6.3":
// Refreh_P_Chapter63(year, W_bkm, type);
// break;
default:
//ִ�и��²���
BookMark_RefreaDat(W_bkm, mk_chaptertemp, type);
break;
}
}
if (leixing == "����")
{
//ִ�и��²���
BookMark_RefreaDat(W_bkm, mk_chaptertemp, type);
}
}
private void Refreh_P_Chapter62(string year, Word.Bookmarks W_bkm, string type)
{
int newyear = int.Parse(year) - 1;
string old_value = "����ԭֵ";
string tiaojian = "";
MKData mk_chapter62 = new MKData();
mk_chapter62.ZJname = "6.2";
#region //220kv��·���� ����
BQData CP62_bq1 = new BQData();
CP62_bq1.BQname = "B_M_168d0da8_1bc2_4982_b7e8_f53eda0c7cb6";
BQData CP62_bq2 = new BQData();
CP62_bq2.BQname = "B_M_253e55ec_08f5_46ea_8738_a5d8d2af1fe8";
tiaojian = " Type='05' and RateVolt=220 and ProjectID='" + ProjID + "' and year(cast(OperationYear as datetime))<=" + year;
if (Common.Services.BaseService.GetObject("SelectPSPDEV_CountAll", tiaojian) != null)
{
int sum = (int)Common.Services.BaseService.GetObject("SelectPSPDEV_CountAll", tiaojian);
double length = 0; if (Common.Services.BaseService.GetObject("SelectPSPDEV_SUM_Length", tiaojian)!=null) { length = (double)Common.Services.BaseService.GetObject("SelectPSPDEV_SUM_Length", tiaojian);}
CP62_bq1.BQdata = sum.ToString();
CP62_bq2.BQdata = length.ToString();
}
else
{
CP62_bq1.BQdata = old_value;
CP62_bq2.BQdata = old_value;
}
mk_chapter62.Data.Add(CP62_bq1);
mk_chapter62.Data.Add(CP62_bq2);
#endregion
#region //110kv��·���� ����
BQData CP62_bq3 = new BQData();
CP62_bq3.BQname = "B_M_d38de142_d082_433d_ac62_9992fac439fb";
BQData CP62_bq4 = new BQData();
CP62_bq4.BQname = "B_M_d57e726e_e388_4f6d_82e2_6fc75350116d";
tiaojian = " Type='05' and RateVolt=110 and ProjectID='" + ProjID + "' and year(cast(OperationYear as datetime))<=" + year;
if (Common.Services.BaseService.GetObject("SelectPSPDEV_CountAll", tiaojian) != null)
{
int sum = (int)Common.Services.BaseService.GetObject("SelectPSPDEV_CountAll", tiaojian);
double length = 0; if (Common.Services.BaseService.GetObject("SelectPSPDEV_SUM_Length", tiaojian)!=null) { length = (double)Common.Services.BaseService.GetObject("SelectPSPDEV_SUM_Length", tiaojian);}
CP62_bq3.BQdata = sum.ToString();
CP62_bq4.BQdata = length.ToString();
}
else
{
CP62_bq3.BQdata = old_value;
CP62_bq4.BQdata = old_value;
}
mk_chapter62.Data.Add(CP62_bq3);
mk_chapter62.Data.Add(CP62_bq4);
#endregion
#region //110kv������·���� ����
BQData CP62_bq5 = new BQData();
CP62_bq5.BQname = "B_M_427b30dd_eb64_4a09_9494_19d230563b82";
BQData CP62_bq6 = new BQData();
CP62_bq6.BQname = "B_M_52b9d10c_ff36_4661_9a6c_4d796ded934b";
tiaojian = " Type='05' and RateVolt=110 and LineType2='����' and ProjectID='" + ProjID + "' and year(cast(OperationYear as datetime))<=" + year;
if (Common.Services.BaseService.GetObject("SelectPSPDEV_CountAll", tiaojian) != null)
{
int sum = (int)Common.Services.BaseService.GetObject("SelectPSPDEV_CountAll", tiaojian);
double length = 0; if (Common.Services.BaseService.GetObject("SelectPSPDEV_SUM_Length", tiaojian)!=null) { length = (double)Common.Services.BaseService.GetObject("SelectPSPDEV_SUM_Length", tiaojian);}
CP62_bq5.BQdata = sum.ToString();
CP62_bq6.BQdata = length.ToString();
}
else
{
CP62_bq5.BQdata = old_value;
CP62_bq6.BQdata = old_value;
}
mk_chapter62.Data.Add(CP62_bq5);
mk_chapter62.Data.Add(CP62_bq6);
#endregion
//ִ�и��²���
BookMark_RefreaDat(W_bkm, mk_chapter62, type);
}
private void Refreh_P_Chapter63(string year, Word.Bookmarks W_bkm, string type)
{
int newyear = int.Parse(year) - 1;
string old_value = "����ԭֵ";
string tiaojian = "";
MKData mk_chapter63 = new MKData();
mk_chapter63.ZJname = "6.3";
#region //110kv��·����
BQData CP63_bq1 = new BQData();
CP63_bq1.BQname = "B_M_72931049_3544_4999_9d70_6d335036e83a";
tiaojian = " Type='05' and RateVolt=110 and ProjectID='" + ProjID + "' and year(cast(OperationYear as datetime))<=" + year;
if (Common.Services.BaseService.GetObject("SelectPSPDEV_CountAll", tiaojian) != null)
{
int sum = (int)Common.Services.BaseService.GetObject("SelectPSPDEV_CountAll", tiaojian);
CP63_bq1.BQdata = sum.ToString();
}
else
{
CP63_bq1.BQdata = old_value;
}
mk_chapter63.Data.Add(CP63_bq1);
#endregion
#region //110kv���վ���
BQData CP63_bq2 = new BQData();
CP63_bq2.BQname = "B_M_fb52a918_28f8_4477_8d49_4ea35ae83926";
tiaojian = " Flag='1' and L1=110 and AreaID='" + ProjID + "' and cast(S2 as int) between 2006 and " + year;
//�½�110kv���վ����
int tempsum1 = 0;
//����110kv���վ����
double tempsum2 = 0;
//�½�110kv���վ����̨��
int tempsum3 = 0;
//����110kv���վ����̨��
double tempsum4 = 0;
double tempdb1 = 0;
double tempdb2 = 0;
if (Common.Services.BaseService.GetObject("SelectPSP_Substation_InfoCountall", tiaojian) != null)
{
tempsum1 = (int)Common.Services.BaseService.GetObject("SelectPSP_Substation_InfoCountall", tiaojian);
}
tiaojian = " and a.BuildYear between 2006 and " + year + " and a.Col3='����' and a.ProjectID='" + ProjID + "' and a.BianInfo like '%110%'";
if (Common.Services.BaseService.GetObject("SelectTZGSsubnum", tiaojian) != null)
{
tempsum2 = (double)Common.Services.BaseService.GetObject("SelectTZGSsubnum", tiaojian);
}
tiaojian = " Flag='1' and L1=110 and AreaID='" + ProjID + "' and cast(S2 as int) between 2006 and " + year;
if (Common.Services.BaseService.GetObject("SelectPSP_Substation_InfoSUML3", tiaojian) != null)
{
tempsum3 = (int)Common.Services.BaseService.GetObject("SelectPSP_Substation_InfoSUML3", tiaojian);
}
tiaojian = " and a.BuildYear between 2006 and " + year + " and a.Col3='����' and a.ProjectID='" + ProjID + "' and a.BianInfo like '%110%'";
if (Common.Services.BaseService.GetObject("SelectTZGSsubTS", tiaojian) != null)
{
tempsum4 = (double)Common.Services.BaseService.GetObject("SelectTZGSsubTS", tiaojian);
}
tiaojian = " Flag='1' and L1=110 and AreaID='" + ProjID + "' and cast(S2 as int) between 2006 and " + year;
if (Common.Services.BaseService.GetObject("SelectPSP_Substation_InfoSUML2", tiaojian) != null)
{
tempdb1 = (double)Common.Services.BaseService.GetObject("SelectPSP_Substation_InfoSUML2", tiaojian);
}
tiaojian = " and a.BuildYear between 2006 and " + year + " and a.Col3='����' and a.ProjectID='" + ProjID + "' and a.BianInfo like '%110%'";
if (Common.Services.BaseService.GetObject("SelectTZGSsubLL", tiaojian) != null)
{
tempdb2 = (double)Common.Services.BaseService.GetObject("SelectTZGSsubLL", tiaojian);
}
if (tempsum1!=0)
{
CP63_bq2.BQdata="���½�110kV���վ"+tempsum1+"����";
}
if (tempsum2!=0)
{
CP63_bq2.BQdata +="����"+tempsum2+"����";
}
if (tempsum3+tempsum4!=0)
{
CP63_bq2.BQdata += "������ѹ��" + (tempsum3 + tempsum4) + "̨,";
}
if (tempdb1+tempdb2!=0)
{
CP63_bq2.BQdata += "110kV�������"+(tempdb1+tempdb2)+"MVA";
}
if (CP63_bq2.BQdata.ToString().Length==0)
{
CP63_bq2.BQdata=old_value;
}
mk_chapter63.Data.Add(CP63_bq2);
#endregion
#region //110kv��·�������
BQData CP63_bq3 = new BQData();
CP63_bq3.BQname = "B_M_5845a5fa_0ec7_48d2_bf26_2214da5785da";
tiaojian = " Type='05' and RateVolt=110 and ProjectID='" + ProjID + "' and year(cast(OperationYear as datetime)) between 2006 and " + year;
if (Common.Services.BaseService.GetObject("SelectPSPDEV_CountAll", tiaojian) != null)
{
int sum = (int)Common.Services.BaseService.GetObject("SelectPSPDEV_CountAll", tiaojian);
double length = 0; if (Common.Services.BaseService.GetObject("SelectPSPDEV_SUM_Length", tiaojian)!=null) { length = (double)Common.Services.BaseService.GetObject("SelectPSPDEV_SUM_Length", tiaojian);}
CP63_bq3.BQdata = "110kV�����·����" + sum + "��������Լ" + length + "km";
}
else
{
CP63_bq3.BQdata = old_value;
}
mk_chapter63.Data.Add(CP63_bq3);
#endregion
#region //110kv���վ��·���������ר�ó��ȵȣ�
BQData CP63_bq4 = new BQData();
CP63_bq4.BQname = "B_M_b268af20_95ec_4675_87b6_31884a5f92ef";
tiaojian = " Flag='1' and L1=110 and S4='����' and AreaID='" + ProjID + "' and cast(S2 as int)<=" + year;
IList<PSP_Substation_Info> psilist = Common.Services.BaseService.GetList<PSP_Substation_Info>("SelectPSP_Substation_InfoListByWhere", tiaojian);
if (psilist.Count > 0)
{
int sum = 0;
double volum = 0;
for (int i = 0; i < psilist.Count; i++)
{
CP63_bq4.BQdata+= psilist[i].Title+"��";
//������̨����
sum += psilist[i].L3;
//�ܱ������
volum += psilist[i].L2;
}
// 110kV���ñ��������10��������䡢���ű䡢��˳�䡢�������䡢л��¢�䡢���ɱ䡢�����䡢���ű䡢��ľɽ�䡢��ͨ�䣩���ܱ������1003MVA��
CP63_bq4.BQdata="110kV���������"+psilist.Count+"����"+CP63_bq4.BQdata.ToString().Substring(0,CP63_bq4.BQdata.ToString().LastIndexOf("��"))+"),";
CP63_bq4.BQdata+="�ܱ������"+volum+"MVA��";
}
tiaojian = " Type='05' and RateVolt=110 and LineType2='����' and ProjectID='" + ProjID + "' and year(cast(OperationYear as datetime))<=" + year;
if (Common.Services.BaseService.GetObject("SelectPSPDEV_CountAll", tiaojian) != null)
{
int sum = (int)Common.Services.BaseService.GetObject("SelectPSPDEV_CountAll", tiaojian);
if (Common.Services.BaseService.GetObject("SelectPSPDEV_SUM_Length", tiaojian)!=null && sum!=0)
{
double length = 0; if (Common.Services.BaseService.GetObject("SelectPSPDEV_SUM_Length", tiaojian)!=null) { length = (double)Common.Services.BaseService.GetObject("SelectPSPDEV_SUM_Length", tiaojian);}
CP63_bq4.BQdata += "110kV������·" + length + "km��" + sum + "����";
}
}
tiaojian = " Flag='1' and L1=110 and S4='ר��' and AreaID='" + ProjID + "' and cast(S2 as int)<=" + year;
psilist = Common.Services.BaseService.GetList<PSP_Substation_Info>("SelectPSP_Substation_InfoListByWhere", tiaojian);
if (psilist.Count > 0)
{
int sum = 0;
double volum = 0;
string tempstr = "";
for (int i = 0; i < psilist.Count; i++)
{
tempstr += psilist[i].Title + "��";
//������̨����
sum += psilist[i].L3;
//�ܱ������
volum += psilist[i].L2;
}
// 110kV�û������10��(��¡I�䡢��¡II�䡢����I�䡢����II�䡢����䡢�����䡢����ɽ�䡢���α䡢�Ϸ�䡢ͭ��ұ����)����������20̨���ܱ������571kVA��
CP63_bq4.BQdata += "110kV�û������" + psilist.Count + "����" + tempstr.Substring(0, tempstr.LastIndexOf("��")) + "),";
CP63_bq4.BQdata+="��������"+sum+"̨���ܱ������"+volum+"MVA��";
}
tiaojian = " Type='05' and RateVolt=110 and LineType2='ר��' and ProjectID='" + ProjID + "' and year(cast(OperationYear as datetime))<=" + year;
if (Common.Services.BaseService.GetObject("SelectPSPDEV_CountAll", tiaojian) != null)
{
int sum = (int)Common.Services.BaseService.GetObject("SelectPSPDEV_CountAll", tiaojian);
if (Common.Services.BaseService.GetObject("SelectPSPDEV_SUM_Length", tiaojian)!=null&&sum!=0)
{
double length = 0; if (Common.Services.BaseService.GetObject("SelectPSPDEV_SUM_Length", tiaojian)!=null) { length = (double)Common.Services.BaseService.GetObject("SelectPSPDEV_SUM_Length", tiaojian);}
//110kV�û���·84.96km��16����
CP63_bq4.BQdata+="110kV�û���·"+length+"km��"+sum+"����";
}
}
if ( CP63_bq4.BQdata.ToString().Length==0)
{
CP63_bq4.BQdata=old_value;
}
mk_chapter63.Data.Add(CP63_bq4);
#endregion
//ִ�и��²���
BookMark_RefreaDat(W_bkm, mk_chapter63, type);
}
private void Refreh_P_Chapter42(string year, Word.Bookmarks W_bkm, string type)
{
int newyear = int.Parse(year) - 1;
string old_value = "����ԭֵ";
string tiaojian = "";
MKData mk_chapter42 = new MKData();
mk_chapter42.ZJname = "4.2";
#region //110kv���վ���
BQData CP42_bq1 = new BQData();
CP42_bq1.BQname = "B_M_ae7086aa_ac94_4297_99f8_a17923efde59";
tiaojian = " Flag='1' and L1=110 and AreaID='" + ProjID + "' and cast(S2 as int)<=" + year;
IList<PSP_Substation_Info> psilist = Common.Services.BaseService.GetList<PSP_Substation_Info>("SelectPSP_Substation_InfoListByWhere", tiaojian);
if (psilist.Count > 0)
{
CP42_bq1.BQdata = "110KV";
for (int i = 0; i < psilist.Count; i++)
{
CP42_bq1.BQdata += psilist[i].Title + "��";
}
CP42_bq1.BQdata = CP42_bq1.BQdata.ToString().Substring(0, CP42_bq1.BQdata.ToString().LastIndexOf("��"));
}
else
{
CP42_bq1.BQdata=old_value;
}
mk_chapter42.Data.Add(CP42_bq1);
#endregion
#region //35kv���վ���
BQData CP42_bq2 = new BQData();
CP42_bq2.BQname = "B_M_185877a0_ba34_46be_9b1c_cd6219a00afb";
tiaojian = " Flag='1' and L1=35 and AreaID='" + ProjID + "' and cast(S2 as int)<=" + year;
psilist = Common.Services.BaseService.GetList<PSP_Substation_Info>("SelectPSP_Substation_InfoListByWhere", tiaojian);
if (psilist.Count > 0)
{
CP42_bq2.BQdata = "35KV";
for (int i = 0; i < psilist.Count; i++)
{
CP42_bq2.BQdata += psilist[i].Title + "��";
}
CP42_bq2.BQdata = CP42_bq2.BQdata.ToString().Substring(0, CP42_bq2.BQdata.ToString().LastIndexOf("��"));
}
else
{
CP42_bq2.BQdata = old_value;
}
mk_chapter42.Data.Add(CP42_bq2);
#endregion
#region //10kv��·����
BQData CP42_bq3 = new BQData();
CP42_bq3.BQname = "B_M_248dfc47_55fb_4075_8357_7af2851b1ef1";
tiaojian = " Type='05' and RateVolt=10 and ProjectID='" + ProjID + "' and year(cast(OperationYear as datetime))<=" + year;
if (Common.Services.BaseService.GetObject("SelectPSPDEV_CountAll", tiaojian) != null)
{
CP42_bq3.BQdata = Common.Services.BaseService.GetObject("SelectPSPDEV_CountAll", tiaojian).ToString();
}
else
{
CP42_bq3.BQdata = old_value;
}
mk_chapter42.Data.Add(CP42_bq3);
#endregion
#region //6kv��·����
BQData CP42_bq4 = new BQData();
CP42_bq4.BQname = "B_M_70f9daf1_d750_4c0f_ae24_c3c9a245d814";
tiaojian = " Type='05' and RateVolt=6 and ProjectID='" + ProjID + "' and year(cast(OperationYear as datetime))<=" + year;
if (Common.Services.BaseService.GetObject("SelectPSPDEV_CountAll", tiaojian) != null)
{
CP42_bq4.BQdata = Common.Services.BaseService.GetObject("SelectPSPDEV_CountAll", tiaojian).ToString();
}
else
{
CP42_bq4.BQdata = old_value;
}
mk_chapter42.Data.Add(CP42_bq4);
#endregion
#region //10kv����·����
BQData CP42_bq5 = new BQData();
CP42_bq5.BQname = "B_M_3499a257_f935_40eb_b8e9_1571c3ad2f57";
CP42_bq5.BQdata = CP42_bq3.BQdata;
mk_chapter42.Data.Add(CP42_bq5);
#endregion
#region //6kv����·����
BQData CP42_bq6 = new BQData();
CP42_bq6.BQname = "B_M_d1215456_6686_48a3_a236_d081deca2bed";
CP42_bq6.BQdata = CP42_bq4.BQdata;
mk_chapter42.Data.Add(CP42_bq6);
#endregion
#region //10kv������·����
BQData CP42_bq7 = new BQData();
CP42_bq7.BQname = "B_M_bb2a71ce_2a8c_4db8_a20c_6a879419a66c";
tiaojian = " Type='05' and RateVolt=10 and LineType2='����' and ProjectID='" + ProjID + "' and year(cast(OperationYear as datetime))<=" + year;
if (Common.Services.BaseService.GetObject("SelectPSPDEV_CountAll", tiaojian) != null)
{
CP42_bq7.BQdata = Common.Services.BaseService.GetObject("SelectPSPDEV_CountAll", tiaojian).ToString();
}
else
{
CP42_bq7.BQdata = old_value;
}
mk_chapter42.Data.Add(CP42_bq7);
#endregion
#region //10kvר����·����
BQData CP42_bq8 = new BQData();
CP42_bq8.BQname = "B_M_7c3c0e14_3003_426d_825f_472600cf0692";
tiaojian = " Type='05' and RateVolt=10 and LineType2='ר��' and ProjectID='" + ProjID + "' and year(cast(OperationYear as datetime))<=" + year;
if (Common.Services.BaseService.GetObject("SelectPSPDEV_CountAll", tiaojian) != null)
{
CP42_bq8.BQdata = Common.Services.BaseService.GetObject("SelectPSPDEV_CountAll", tiaojian).ToString();
}
else
{
CP42_bq8.BQdata = old_value;
}
mk_chapter42.Data.Add(CP42_bq8);
#endregion
#region //6kvר�û�����·����
BQData CP42_bq9 = new BQData();
CP42_bq9.BQname = "B_M_2ceec984_691d_449a_ac49_5f659d07efa6";
tiaojian = " Type='05' and RateVolt=6 and LineType2='����' and ProjectID='" + ProjID + "' and year(cast(OperationYear as datetime))<=" + year;
if (Common.Services.BaseService.GetObject("SelectPSPDEV_CountAll", tiaojian) != null)
{
int sum = 0;
sum=(int)Common.Services.BaseService.GetObject("SelectPSPDEV_CountAll", tiaojian);
CP42_bq9.BQdata = "6KV������" + sum + "����";
}
tiaojian = " Type='05' and RateVolt=6 and LineType2='ר��' and ProjectID='" + ProjID + "' and year(cast(OperationYear as datetime))<=" + year;
if (Common.Services.BaseService.GetObject("SelectPSPDEV_CountAll", tiaojian) != null)
{
int sum = 0;
sum = (int)Common.Services.BaseService.GetObject("SelectPSPDEV_CountAll", tiaojian);
CP42_bq9.BQdata += "6KVר����" + sum + "����";
}
if ( CP42_bq9.BQdata.ToString().Length==0)
{
CP42_bq9.BQdata = old_value;
}
else
{
CP42_bq9.BQdata = CP42_bq9.BQdata.ToString().Substring(0, CP42_bq9.BQdata.ToString().LastIndexOf("��"));
}
mk_chapter42.Data.Add(CP42_bq9);
#endregion
#region //10kv������·����
BQData CP42_bq10 = new BQData();
CP42_bq10.BQname = "B_M_f27b8979_ed40_4150_ab16_d603d0f4635e";
tiaojian = " Type='05' and RateVolt=10 and LineType2='����' and ProjectID='" + ProjID + "' and year(cast(OperationYear as datetime))<=" + year;
if (Common.Services.BaseService.GetObject("SelectPSPDEV_SUM_Length", tiaojian) != null)
{
CP42_bq10.BQdata = Common.Services.BaseService.GetObject("SelectPSPDEV_SUM_Length", tiaojian).ToString();
}
else
{
CP42_bq10.BQdata = old_value;
}
mk_chapter42.Data.Add(CP42_bq10);
#endregion
#region //10kv������·���³���
BQData CP42_bq11 = new BQData();
CP42_bq11.BQname = "B_M_7fca31a5_4c90_46f7_8238_1b3b59455d10";
tiaojian = " Type='05' and RateVolt=10 and LineType2='����' and ProjectID='" + ProjID + "' and year(cast(OperationYear as datetime))<=" + year;
if (Common.Services.BaseService.GetObject("SelectPSPDEV_SUMLength2", tiaojian) != null)
{
CP42_bq11.BQdata = Common.Services.BaseService.GetObject("SelectPSPDEV_SUMLength2", tiaojian).ToString();
}
else
{
CP42_bq11.BQdata = old_value;
}
mk_chapter42.Data.Add(CP42_bq11);
#endregion
#region //10kvר����·����
BQData CP42_bq12 = new BQData();
CP42_bq12.BQname = "B_M_9d88e171_6073_4f9f_962c_e882f0e13e17";
tiaojian = " Type='05' and RateVolt=10 and LineType2='ר��' and ProjectID='" + ProjID + "' and year(cast(OperationYear as datetime))<=" + year;
if (Common.Services.BaseService.GetObject("SelectPSPDEV_SUM_Length", tiaojian) != null)
{
CP42_bq12.BQdata = Common.Services.BaseService.GetObject("SelectPSPDEV_SUM_Length", tiaojian).ToString();
}
else
{
CP42_bq12.BQdata = old_value;
}
mk_chapter42.Data.Add(CP42_bq12);
#endregion
//ִ�и��²���
BookMark_RefreaDat(W_bkm, mk_chapter42, type);
}
private void Refreh_P_Chapter47(string year, Word.Bookmarks W_bkm, string type)
{
int newyear = int.Parse(year) - 1;
string old_value = "����ԭֵ";
string tiaojian = "";
MKData mk_chapter47 = new MKData();
mk_chapter47.ZJname = "4.7";
#region //35kvc�����ϱ��վ��������������
BQData CP47_bq1 = new BQData();
CP47_bq1.BQname = "B_M_e8e1b809_b903_4dee_8c96_4fc723c2f63d";
tiaojian = " c.L1>=35 and c.AreaID='" + ProjID + "' and cast(c.S2 as int)<=" + year;
if (Common.Services.BaseService.GetObject("SelectPSPDEV_Type09_Count", tiaojian)!=null)
{
CP47_bq1.BQdata = Common.Services.BaseService.GetObject("SelectPSPDEV_Type09_Count", tiaojian).ToString();
}
else
{
CP47_bq1.BQdata = old_value;
}
mk_chapter47.Data.Add(CP47_bq1);
#endregion
#region //35kvc�����ϱ��վ��������������
BQData CP47_bq2 = new BQData();
CP47_bq2.BQname = "B_M_0e82ef75_53c9_4c47_8418_ec1d39bb1efb";
tiaojian = " c.L1>=35 and c.AreaID='" + ProjID + "' and cast(c.S2 as int)<=" + year;
if (Common.Services.BaseService.GetObject("SelectPSPDEV_Type09_sumVolue", tiaojian) != null)
{
CP47_bq2.BQdata = Common.Services.BaseService.GetObject("SelectPSPDEV_Type09_sumVolue", tiaojian).ToString();
}
else
{
CP47_bq2.BQdata = old_value;
}
mk_chapter47.Data.Add(CP47_bq2);
#endregion
#region //220kvc���վ��������������
BQData CP47_bq3 = new BQData();
CP47_bq3.BQname = "B_M_45453852_d69a_4652_a020_53156036c6ad";
tiaojian = " c.L1=220 and c.AreaID='" + ProjID + "' and cast(c.S2 as int)<=" + year;
if (Common.Services.BaseService.GetObject("SelectPSPDEV_Type09_sumVolue", tiaojian) != null)
{
CP47_bq3.BQdata = Common.Services.BaseService.GetObject("SelectPSPDEV_Type09_sumVolue", tiaojian).ToString();
}
else
{
CP47_bq3.BQdata = old_value;
}
mk_chapter47.Data.Add(CP47_bq3);
#endregion
#region //110kvc���վ��������������
BQData CP47_bq4 = new BQData();
CP47_bq4.BQname = "B_M_be65e5a8_49d0_4f59_b226_0d61df758e1c";
tiaojian = " c.L1=110 and c.AreaID='" + ProjID + "' and cast(c.S2 as int)<=" + year;
if (Common.Services.BaseService.GetObject("SelectPSPDEV_Type09_sumVolue", tiaojian) != null)
{
CP47_bq4.BQdata = Common.Services.BaseService.GetObject("SelectPSPDEV_Type09_sumVolue", tiaojian).ToString();
}
else
{
CP47_bq4.BQdata = old_value;
}
mk_chapter47.Data.Add(CP47_bq4);
#endregion
#region //35kvc���վ��������������
BQData CP47_bq5 = new BQData();
CP47_bq5.BQname = "B_M_096ec92e_61f8_464a_86b0_afef046c1443";
tiaojian = " c.L1=35 and c.AreaID='" + ProjID + "' and cast(c.S2 as int)<=" + year;
if (Common.Services.BaseService.GetObject("SelectPSPDEV_Type09_sumVolue", tiaojian) != null)
{
CP47_bq5.BQdata = Common.Services.BaseService.GetObject("SelectPSPDEV_Type09_sumVolue", tiaojian).ToString();
}
else
{
CP47_bq5.BQdata = old_value;
}
mk_chapter47.Data.Add(CP47_bq5);
#endregion
//ִ�и��²���
BookMark_RefreaDat(W_bkm, mk_chapter47, type);
}
private void Refreh_P_Chapter32(string year, Word.Bookmarks W_bkm, string type)
{
int newyear = int.Parse(year) - 1;
string old_value = "����ԭֵ";
string tiaojian = "";
MKData mk_chapter32 = new MKData();
mk_chapter32.ZJname = "3.2";
#region //������ݱ�ǩ
BQData CP32_bq1 = new BQData();
CP32_bq1.BQname = "B_M_da859e24_e3fe_4aef_bf17_44c2de39fb8e";
CP32_bq1.BQdata = year;
mk_chapter32.Data.Add(CP32_bq1);
#endregion
#region //������ݱ�ǩ
BQData CP32_bq2 = new BQData();
CP32_bq2.BQname = "B_M_8e6a49cb_6d9b_44e5_ac97_f75e4b032875";
CP32_bq2.BQdata = year;
mk_chapter32.Data.Add(CP32_bq2);
#endregion
#region //110kv�����ϱ��վ����
BQData CP32_bq3 = new BQData();
CP32_bq3.BQname = "B_M_69e46e67_d89f_4039_9b88_52a4958018a9";
tiaojian = " Flag='1' and L1>=110 and AreaID='" + ProjID + "' and cast(S2 as int)<=" + year;
if (Common.Services.BaseService.GetObject("SelectPSP_Substation_InfoCountall", tiaojian) != null)
{
CP32_bq3.BQdata = Common.Services.BaseService.GetObject("SelectPSP_Substation_InfoCountall", tiaojian).ToString();
}
else
{
CP32_bq3.BQdata = old_value;
}
mk_chapter32.Data.Add(CP32_bq3);
#endregion
#region //110kv�����ϱ��վ������
BQData CP32_bq4 = new BQData();
CP32_bq4.BQname = "B_M_322b0bff_2663_48fa_883a_d188bed02933";
tiaojian = " Flag='1' and L1>=110 and AreaID='" + ProjID + "' and cast(S2 as int)<=" + year;
if (Common.Services.BaseService.GetObject("SelectPSP_Substation_InfoSUML2", tiaojian) != null)
{
CP32_bq4.BQdata = Common.Services.BaseService.GetObject("SelectPSP_Substation_InfoSUML2", tiaojian).ToString();
}
else
{
CP32_bq4.BQdata = old_value;
}
mk_chapter32.Data.Add(CP32_bq4);
#endregion
#region //220kv���վ����
BQData CP32_bq5 = new BQData();
CP32_bq5.BQname = "B_M_3d99ab43_a1fc_4f0d_a68b_52ac29ceeff7";
tiaojian = " Flag='1' and L1=220 and AreaID='" + ProjID + "' and cast(S2 as int)<=" + year;
if (Common.Services.BaseService.GetObject("SelectPSP_Substation_InfoCountall", tiaojian) != null)
{
CP32_bq5.BQdata = Common.Services.BaseService.GetObject("SelectPSP_Substation_InfoCountall", tiaojian).ToString();
}
else
{
CP32_bq5.BQdata = old_value;
}
mk_chapter32.Data.Add(CP32_bq5);
#endregion
#region //220kv���վ���
BQData CP32_bq6 = new BQData();
CP32_bq6.BQname = "B_M_cc006291_3a3a_4379_bd5b_dcc8e4281007";
tiaojian = " Flag='1' and L1=220 and AreaID='" + ProjID + "' and cast(S2 as int)<=" + year;
IList<PSP_Substation_Info> psilist = Common.Services.BaseService.GetList<PSP_Substation_Info>("SelectPSP_Substation_InfoListByWhere", tiaojian);
if (psilist.Count > 0)
{
int sum = 0;
double volum = 0;
CP32_bq6.BQdata = "��";
for (int i = 0; i < psilist.Count; i++)
{
CP32_bq6.BQdata += psilist[i].Title + "(" + psilist[i].L4 + "MVA)��";
//������̨����
sum += psilist[i].L3;
//�ܱ������
volum += psilist[i].L2;
}
CP32_bq6.BQdata = CP32_bq6.BQdata.ToString().Substring(0, CP32_bq6.BQdata.ToString().LastIndexOf("��")) + ",����" + sum + "̨��220ǧ���ܱ������Ϊ" + volum + "MVA��";
}
else
{
CP32_bq6.BQdata = old_value;
}
mk_chapter32.Data.Add(CP32_bq6);
#endregion
#region //110kv���ñ��վ����
BQData CP32_bq7 = new BQData();
CP32_bq7.BQname = "B_M_f6226296_fca6_4b15_a3d4_c971ee93dd4a";
tiaojian = " Flag='1' and L1=110 and S4='����' and AreaID='" + ProjID + "' and cast(S2 as int)<=" + year;
if (Common.Services.BaseService.GetObject("SelectPSP_Substation_InfoCountall", tiaojian) != null)
{
CP32_bq7.BQdata = Common.Services.BaseService.GetObject("SelectPSP_Substation_InfoCountall", tiaojian).ToString();
}
else
{
CP32_bq7.BQdata = old_value;
}
mk_chapter32.Data.Add(CP32_bq7);
#endregion
#region //110kv���ñ��վ���
BQData CP32_bq8 = new BQData();
CP32_bq8.BQname = "B_M_81f3ab93_3e66_4bcb_8a2b_8d026a5eb350";
tiaojian = " Flag='1' and L1=110 and S4='����' and AreaID='" + ProjID + "' and cast(S2 as int)<=" + year;
psilist = Common.Services.BaseService.GetList<PSP_Substation_Info>("SelectPSP_Substation_InfoListByWhere", tiaojian);
if (psilist.Count > 0)
{
int sum = 0;
double volum = 0;
CP32_bq8.BQdata = "��";
for (int i = 0; i < psilist.Count; i++)
{
CP32_bq8.BQdata += psilist[i].Title + "(" + psilist[i].L4 + "MVA)��";
//������̨����
sum += psilist[i].L3;
//�ܱ������
volum += psilist[i].L2;
}
CP32_bq8.BQdata = "����" + sum + "̨������������" + volum + "MVA��" + CP32_bq8.BQdata.ToString().Substring(0, CP32_bq8.BQdata.ToString().LastIndexOf("��")) + ";";
}
else
{
CP32_bq8.BQdata = old_value;
}
mk_chapter32.Data.Add(CP32_bq8);
#endregion
#region //110kvר�ñ��վ���
BQData CP32_bq9 = new BQData();
CP32_bq9.BQname = "B_M_eee02e7b_395d_44ca_bb43_a6841578bf28";
tiaojian = " Flag='1' and L1=110 and S4='ר��' and AreaID='" + ProjID + "' and cast(S2 as int)<=" + year;
psilist = Common.Services.BaseService.GetList<PSP_Substation_Info>("SelectPSP_Substation_InfoListByWhere", tiaojian);
if (psilist.Count > 0)
{
double volum = 0;
for (int i = 0; i < psilist.Count; i++)
{
//�ܱ������
volum += psilist[i].L2;
}
CP32_bq9.BQdata = "�û���" + psilist.Count + "��������������" + volum + "MVA��";
}
else
{
CP32_bq9.BQdata = old_value;
}
mk_chapter32.Data.Add(CP32_bq9);
#endregion
#region //35kv���վ����
BQData CP32_bq10 = new BQData();
CP32_bq10.BQname = "B_M_62b80c14_a114_4990_a819_0787a7c4ddbd";
tiaojian = " Flag='1' and L1=35 and AreaID='" + ProjID + "' and cast(S2 as int)<=" + year;
if (Common.Services.BaseService.GetObject("SelectPSP_Substation_InfoCountall", tiaojian) != null)
{
CP32_bq10.BQdata = Common.Services.BaseService.GetObject("SelectPSP_Substation_InfoCountall", tiaojian).ToString();
}
else
{
CP32_bq10.BQdata = old_value;
}
mk_chapter32.Data.Add(CP32_bq10);
#endregion
#region //35kv���վ���
BQData CP32_bq11 = new BQData();
CP32_bq11.BQname = "B_M_9fc1af03_1e42_499f_9de7_4b9c0622b18b";
tiaojian = " Flag='1' and L1=35 and AreaID='" + ProjID + "' and cast(S2 as int)<=" + year;
psilist = Common.Services.BaseService.GetList<PSP_Substation_Info>("SelectPSP_Substation_InfoListByWhere", tiaojian);
if (psilist.Count > 0)
{
int sum = 0;
double volum = 0;
CP32_bq11.BQdata = "��";
for (int i = 0; i < psilist.Count; i++)
{
CP32_bq11.BQdata += psilist[i].Title + "(" + psilist[i].L4 + "MVA)��";
//������̨����
sum += psilist[i].L3;
//�ܱ������
volum += psilist[i].L2;
}
CP32_bq11.BQdata = sum + "̨���䣬�������" + volum + "MVA��" + CP32_bq11.BQdata.ToString().Substring(0, CP32_bq11.BQdata.ToString().LastIndexOf("��")) + ";";
}
else
{
CP32_bq11.BQdata = old_value;
}
mk_chapter32.Data.Add(CP32_bq11);
#endregion
#region //35kv��·���
BQData CP32_bq12 = new BQData();
CP32_bq12.BQname = "B_M_00fabcf9_0efa_406b_9dfd_0508593877f5";
tiaojian = " Type='05' and RateVolt=35 and ProjectID='" + ProjID + "' and year(cast(OperationYear as datetime))<=" + year;
if (Common.Services.BaseService.GetObject("SelectPSPDEV_CountAll", tiaojian) != null)
{
int sum = (int)Common.Services.BaseService.GetObject("SelectPSPDEV_CountAll", tiaojian);
double length = 0;
if (Common.Services.BaseService.GetObject("SelectPSPDEV_SUM_Length", tiaojian)!=null)
{
length = (double)Common.Services.BaseService.GetObject("SelectPSPDEV_SUM_Length", tiaojian);
}
CP32_bq12.BQdata = "��·" + sum + "��,����" + length + "Km��";
}
else
{
CP32_bq12.BQdata = old_value;
}
mk_chapter32.Data.Add(CP32_bq12);
#endregion
#region //220kv��·���� ����
BQData CP32_bq13 = new BQData();
CP32_bq13.BQname = "B_M_90bb1930_0d33_4aa1_97b1_6b384a66d1f0";
BQData CP32_bq14 = new BQData();
CP32_bq14.BQname = "B_M_c12dd71c_1b79_4033_9e19_d3abea6e1572";
tiaojian = " Type='05' and RateVolt=220 and ProjectID='" + ProjID + "' and year(cast(OperationYear as datetime))<=" + year;
if (Common.Services.BaseService.GetObject("SelectPSPDEV_CountAll", tiaojian) != null)
{
int sum = (int)Common.Services.BaseService.GetObject("SelectPSPDEV_CountAll", tiaojian);
double length = 0; if (Common.Services.BaseService.GetObject("SelectPSPDEV_SUM_Length", tiaojian)!=null) { length = (double)Common.Services.BaseService.GetObject("SelectPSPDEV_SUM_Length", tiaojian);}
CP32_bq13.BQdata = sum.ToString();
CP32_bq14.BQdata = length.ToString();
}
else
{
CP32_bq13.BQdata = old_value;
CP32_bq14.BQdata = old_value;
}
mk_chapter32.Data.Add(CP32_bq13);
mk_chapter32.Data.Add(CP32_bq14);
#endregion
#region //110kv��·���� ���ȣ�����+ר�ã�
BQData CP32_bq15 = new BQData();
CP32_bq15.BQname = "B_M_8197ede3_bd7f_4d25_9973_dfbacb3a06ae";
BQData CP32_bq16 = new BQData();
CP32_bq16.BQname = "B_M_961b8410_5345_4eec_b436_6d81c1ec8064";
tiaojian = " Type='05' and RateVolt=110 and ProjectID='" + ProjID + "' and year(cast(OperationYear as datetime))<=" + year;
if (Common.Services.BaseService.GetObject("SelectPSPDEV_CountAll", tiaojian) != null)
{
int sum = (int)Common.Services.BaseService.GetObject("SelectPSPDEV_CountAll", tiaojian);
double length = 0; if (Common.Services.BaseService.GetObject("SelectPSPDEV_SUM_Length", tiaojian)!=null) { length = (double)Common.Services.BaseService.GetObject("SelectPSPDEV_SUM_Length", tiaojian);}
CP32_bq15.BQdata = sum.ToString();
CP32_bq16.BQdata = length.ToString();
}
else
{
CP32_bq15.BQdata = old_value;
CP32_bq16.BQdata = old_value;
}
mk_chapter32.Data.Add(CP32_bq15);
mk_chapter32.Data.Add(CP32_bq16);
#endregion
#region //110kv������·���� ����
BQData CP32_bq17 = new BQData();
CP32_bq17.BQname = "B_M_95538b84_eb3d_4c47_b4ea_a3ae308f2134";
BQData CP32_bq18 = new BQData();
CP32_bq18.BQname = "B_M_37ab5d85_9d99_44e7_9a3a_f2ddd82e422a";
tiaojian = " Type='05' and RateVolt=110 and LineType2='����' and ProjectID='" + ProjID + "' and year(cast(OperationYear as datetime))<=" + year;
if (Common.Services.BaseService.GetObject("SelectPSPDEV_CountAll", tiaojian) != null)
{
int sum = (int)Common.Services.BaseService.GetObject("SelectPSPDEV_CountAll", tiaojian);
double length=0;
if (Common.Services.BaseService.GetObject("SelectPSPDEV_SUM_Length", tiaojian)!=null)
{
length = (double)Common.Services.BaseService.GetObject("SelectPSPDEV_SUM_Length", tiaojian);
}
CP32_bq17.BQdata = sum.ToString();
CP32_bq18.BQdata = length.ToString();
}
else
{
CP32_bq17.BQdata = old_value;
CP32_bq18.BQdata = old_value;
}
mk_chapter32.Data.Add(CP32_bq17);
mk_chapter32.Data.Add(CP32_bq18);
#endregion
#region //35kv���վ����
BQData CP32_bq19 = new BQData();
CP32_bq19.BQname = "B_M_1617b1d3_b396_4772_a5f0_203f88014359";
CP32_bq19.BQdata = CP32_bq10.BQdata;
mk_chapter32.Data.Add(CP32_bq19);
#endregion
#region //35kv���վ���
BQData CP32_bq20 = new BQData();
CP32_bq20.BQname = "B_M_a6870103_9afc_4c4b_9411_58e604e5fc55";
tiaojian = " Flag='1' and L1=35 and AreaID='" + ProjID + "' and cast(S2 as int)<=" + year;
psilist = Common.Services.BaseService.GetList<PSP_Substation_Info>("SelectPSP_Substation_InfoListByWhere", tiaojian);
if (psilist.Count > 0)
{
int sum = 0;
double volum = 0;
for (int i = 0; i < psilist.Count; i++)
{
//������̨����
sum += psilist[i].L3;
//�ܱ������
volum += psilist[i].L2;
}
CP32_bq20.BQdata = sum + "̨���䣬�������" + volum + "MVA,";
}
else
{
CP32_bq20.BQdata = old_value;
}
mk_chapter32.Data.Add(CP32_bq20);
#endregion
#region //35kv��·���
BQData CP32_bq21 = new BQData();
CP32_bq21.BQname = "B_M_94c21c45_9673_459f_a9bd_07f49b0b87f7";
tiaojian = " Type='05' and RateVolt=35 and ProjectID='" + ProjID + "' and year(cast(OperationYear as datetime))<=" + year;
if (Common.Services.BaseService.GetObject("SelectPSPDEV_CountAll", tiaojian) != null)
{
int sum = (int)Common.Services.BaseService.GetObject("SelectPSPDEV_CountAll", tiaojian);
double length = 0; if (Common.Services.BaseService.GetObject("SelectPSPDEV_SUM_Length", tiaojian)!=null) { length = (double)Common.Services.BaseService.GetObject("SelectPSPDEV_SUM_Length", tiaojian);}
CP32_bq21.BQdata = "��·" + sum + "��,����" + length + "Km��";
}
else
{
CP32_bq21.BQdata = old_value;
}
mk_chapter32.Data.Add(CP32_bq21);
#endregion
#region //������ݱ�ǩ
BQData CP32_bq22 = new BQData();
CP32_bq22.BQname = "B_M_0c81f3a3_d492_4535_aa09_cbe68556d308";
CP32_bq22.BQdata = year;
mk_chapter32.Data.Add(CP32_bq22);
#endregion
#region //35kv-500kv���վ����̨�� ����
BQData CP32_bq23 = new BQData();
CP32_bq23.BQname = "B_M_e719d630_db40_4e0a_b4ea_913eb87545b2";
BQData CP32_bq24 = new BQData();
CP32_bq24.BQname = "B_M_356c1faa_ce1d_4547_8436_70ee84e3a45a";
tiaojian = " Flag='1' and L1 between 35 and 500 and AreaID='" + ProjID + "' and cast(S2 as int)<=" + year;
psilist = Common.Services.BaseService.GetList<PSP_Substation_Info>("SelectPSP_Substation_InfoListByWhere", tiaojian);
if (psilist.Count > 0)
{
int sum = 0;
double volum = 0;
for (int i = 0; i < psilist.Count; i++)
{
//������̨����
sum += psilist[i].L3;
//�ܱ������
volum += psilist[i].L2;
}
CP32_bq23.BQdata = sum.ToString();
CP32_bq24.BQdata = volum.ToString();
}
else
{
CP32_bq23.BQdata = old_value;
CP32_bq24.BQdata = old_value;
}
mk_chapter32.Data.Add(CP32_bq23);
mk_chapter32.Data.Add(CP32_bq24);
#endregion
//ִ�и��²���
BookMark_RefreaDat(W_bkm, mk_chapter32, type);
}
private void Refreh_P_Chapter31(string year, Word.Bookmarks W_bkm, string type)
{
int newyear = int.Parse(year) - 1;
string old_value = "����ԭֵ";
MKData mk_chapter31 = new MKData();
mk_chapter31.ZJname = "3.1";
#region //������ݱ�ǩ
BQData CP31_bq1 = new BQData();
CP31_bq1.BQname = "B_M_53c447f1_da55_407a_8998_ee37a3ebdc94";
CP31_bq1.BQdata = year;
mk_chapter31.Data.Add(CP31_bq1);
#endregion
#region //�½����վ��ǩ
BQData CP31_bq2 = new BQData();
CP31_bq2.BQname = "B_M_d5358e04_92fe_4456_a1c2_170158391e8b";
string tiaojian = "";
tiaojian = " a.ProjectID='" + ProjID + "' and b.Typeqf='sub' and Cast(a.BuildYear as int )>=" + year + " and a.ID=b.ProjectID order by Cast(a.BuildYear as int )";
IList<Ps_Table_TZGS> pttlist = Common.Services.BaseService.GetList<Ps_Table_TZGS>("SelectPs_Table_TZGSListBYwhere", tiaojian);
if (pttlist.Count > 0)
{
for (int i = 0; i < pttlist.Count; i++)
{
CP31_bq2.BQdata += pttlist[i].BuildYear + "��" + pttlist[i].Col3 + pttlist[i].Col1 + ",";
}
if (CP31_bq2.BQdata.ToString().Length > 0)
{
CP31_bq2.BQdata = CP31_bq2.BQdata.ToString().Substring(0, CP31_bq2.BQdata.ToString().LastIndexOf(",") - 1);
CP31_bq2.BQdata += "��";
}
}
else
{
CP31_bq2.BQdata = old_value;
}
mk_chapter31.Data.Add(CP31_bq2);
#endregion
#region //������ݱ�ǩ
BQData CP31_bq3 = new BQData();
CP31_bq3.BQname = "B_M_e238cb33_67fd_48ef_84cc_c8e8fca503d0";
CP31_bq3.BQdata = newyear.ToString();
mk_chapter31.Data.Add(CP31_bq3);
#endregion
//ִ�и��²���
BookMark_RefreaDat(W_bkm, mk_chapter31, type);
}
private void Refreh_P_Chapter2(string year, Word.Bookmarks W_bkm, string type)
{
int newyear = int.Parse(year) - 1;
string old_value = "����ԭֵ";
MKData mk_chapter2 = new MKData();
mk_chapter2.ZJname = "�ڶ���";
#region //���������ǩ
BQData CP2_bq1 = new BQData();
CP2_bq1.BQname = "B_M_7e135441_97ed_46be_9a4b_d2aab0ad3f9b";
string tiaojian = "";
tiaojian = " a.ProjectID='" + ProjID + "' and a.Area='ͭ����' and b.Yearf=" + newyear;
if (Common.Services.BaseService.GetObject("SelectAreaDataCityArea_ByArea", tiaojian) != null)
{
CP2_bq1.BQdata = ((double)Common.Services.BaseService.GetObject("SelectAreaDataCityArea_ByArea", tiaojian)).ToString();
}
else
{
CP2_bq1.BQdata = old_value;
}
mk_chapter2.Data.Add(CP2_bq1);
#endregion
#region //�˿���ݱ�ǩ
BQData CP2_bq2 = new BQData();
CP2_bq2.BQname = "B_M_0aad4d05_6cd0_483c_bc69_ef287b8783da";
CP2_bq2.BQdata = newyear.ToString();
mk_chapter2.Data.Add(CP2_bq2);
#endregion
#region //ȫ���˿ڱ�ǩ
//��ͭ�����˿���Ps_Table_AreaData����
BQData CP2_bq3 = new BQData();
CP2_bq3.BQname = "B_M_e037cd16_95be_43e9_bd33_874cffe66327";
tiaojian = " a.ProjectID='" + ProjID + "' and a.Area='ͭ����' and b.Yearf=" + newyear;
if (Common.Services.BaseService.GetObject("SelectAreaDataPopulation_ByArea", tiaojian) != null)
{
CP2_bq3.BQdata = ((double)Common.Services.BaseService.GetObject("SelectAreaDataPopulation_ByArea", tiaojian)).ToString();
}
else
{
CP2_bq3.BQdata = old_value;
}
mk_chapter2.Data.Add(CP2_bq3);
#endregion
#region //�����˿ڱ�ǩ
//���ͭ�����˿���Ps_Table_AreaData����,�����˿ڼ�ȥ��ͭ�����˿�=�����˿�
BQData CP2_bq4 = new BQData();
CP2_bq4.BQname = "B_M_0a373bd0_619d_4e36_a5b1_0853c4527bbf";
tiaojian = " a.ProjectID='" + ProjID + "' and a.Area!='ͭ����' and a.Area not like '%������' and b.Yearf=" + newyear;
if (Common.Services.BaseService.GetObject("SelectAreaDataPopulation_notcity_ByArea", tiaojian) != null)
{
CP2_bq4.BQdata = ((double)Common.Services.BaseService.GetObject("SelectAreaDataPopulation_notcity_ByArea", tiaojian)).ToString();
}
else
{
CP2_bq4.BQdata = old_value;
}
//���ȫ���˿ڻ������˿���һ��û���������ü���
if (CP2_bq4.BQdata != old_value && CP2_bq3.BQdata != old_value)
{
double tempdb = double.Parse(CP2_bq3.BQdata.ToString()) - double.Parse(CP2_bq4.BQdata.ToString());
CP2_bq4.BQdata = tempdb.ToString();
}
else
{
CP2_bq4.BQdata = old_value;
}
mk_chapter2.Data.Add(CP2_bq4);
#endregion
//
#region //�����˿�ռȫ���˿ڱ���
BQData CP2_bq5 = new BQData();
CP2_bq5.BQname = "B_M_9a4de2ea_1829_4470_8de7_117ed49c2640";
if (CP2_bq4.BQdata != old_value && CP2_bq3.BQdata != old_value)
{
CP2_bq5.BQdata = (double.Parse(CP2_bq4.BQdata.ToString()) / double.Parse(CP2_bq3.BQdata.ToString())) * 100 + "%";
}
else
{
CP2_bq5.BQdata = old_value;
}
mk_chapter2.Data.Add(CP2_bq5);
#endregion
#region //GDP��ݱ�ǩ
BQData CP2_bq6 = new BQData();
CP2_bq6.BQname = "B_M_9afd4b9e_55b9_4d7a_aaa0_6cd6bcd47e74";
CP2_bq6.BQdata = newyear.ToString();
mk_chapter2.Data.Add(CP2_bq6);
#endregion
#region //GDP��ֵ��ǩ
BQData CP2_bq7 = new BQData();
CP2_bq7.BQname = "B_M_e23fa137_4dec_4d2d_b94c_f96016f312ef";
tiaojian = "select y" + newyear.ToString() + " from Ps_History where Title='ȫ����GDP����Ԫ��' and Forecast=1 and Col4='" + ProjID + "'";
if (Common.Services.BaseService.GetObject("SelectPs_HistoryPopulationByCondition", tiaojian) != null)
{
CP2_bq7.BQdata = ((double)Common.Services.BaseService.GetObject("SelectPs_HistoryPopulationByCondition", tiaojian)).ToString();
}
else
{
CP2_bq7.BQdata = old_value;
}
mk_chapter2.Data.Add(CP2_bq7);
#endregion
#region //GDP��ҵֵ��ǩ
BQData CP2_bq8 = new BQData();
CP2_bq8.BQname = "B_M_c1470a2b_ac6e_4d8a_833d_1ffea2ccadc4";
tiaojian = "select b.y" + newyear + " from Ps_History as a ,Ps_History as b where a.Title='ȫ����GDP����Ԫ��' and a.Forecast=1 and a.Col4='" + ProjID + "' and a.ID=b.ParentID and b.Title='����'";
if (Common.Services.BaseService.GetObject("SelectPs_HistoryPopulationByCondition", tiaojian) != null)
{
CP2_bq8.BQdata = ((double)Common.Services.BaseService.GetObject("SelectPs_HistoryPopulationByCondition", tiaojian)).ToString();
}
else
{
CP2_bq8.BQdata = old_value;
}
mk_chapter2.Data.Add(CP2_bq8);
#endregion
#region //GDP��ҵֵռ��GDP�ı��ر�ǩ
BQData CP2_bq9 = new BQData();
CP2_bq9.BQname = "B_M_79eb2370_f77f_4e96_885e_a7a1de9e5dc9";
if (CP2_bq7.BQdata != old_value && CP2_bq8.BQdata != old_value)
{
CP2_bq9.BQdata = Math.Round(100 * double.Parse(CP2_bq8.BQdata.ToString()) / double.Parse(CP2_bq7.BQdata.ToString()), 2) + "%";
}
else
{
CP2_bq9.BQdata = old_value;
}
mk_chapter2.Data.Add(CP2_bq9);
#endregion
#region //��ݱ�ǩ
BQData CP2_bq10 = new BQData();
CP2_bq10.BQname = "B_M_88c7cc6a_9945_4daa_aa71_62bc5a30a7e2";
CP2_bq10.BQdata = newyear.ToString();
mk_chapter2.Data.Add(CP2_bq10);
#endregion
#region //����������ֵ
BQData CP2_bq11 = new BQData();
CP2_bq11.BQname = "B_M_82b09a86_6fb8_44a2_b143_ab6f669dfe95";
CP2_bq11.BQdata = CP2_bq7.BQdata;
mk_chapter2.Data.Add(CP2_bq11);
#endregion
#region //����������ֵ������ͬ������
BQData CP2_bq12 = new BQData();
CP2_bq12.BQname = "B_M_1db524bf_d798_496a_99cb_8dd3c6d9a0af";
tiaojian = "select y" + (newyear - 1) + " from Ps_History where Title='ȫ����GDP����Ԫ��' and Forecast=1 and Col4='" + ProjID + "'";
if (Common.Services.BaseService.GetObject("SelectPs_HistoryPopulationByCondition", tiaojian) != null)
{
double tempdb12 = ((double)Common.Services.BaseService.GetObject("SelectPs_HistoryPopulationByCondition", tiaojian));
if (CP2_bq7.BQdata != old_value)
{
CP2_bq12.BQdata = Math.Round(100 * (double.Parse(CP2_bq7.BQdata.ToString()) - tempdb12) / tempdb12, 2) + "";
}
}
else
{
CP2_bq12.BQdata = old_value;
}
mk_chapter2.Data.Add(CP2_bq12);
#endregion
#region //���
BQData CP2_bq13 = new BQData();
CP2_bq13.BQname = "B_M_863b8846_224e_424c_bc77_cd838e7e8721";
CP2_bq13.BQdata = newyear.ToString();
mk_chapter2.Data.Add(CP2_bq13);
#endregion
#region //���
BQData CP2_bq21 = new BQData();
CP2_bq21.BQname = "B_M_369af6e5_06a0_4e58_b818_1448e2dd5ec7";
CP2_bq21.BQdata = newyear.ToString();
mk_chapter2.Data.Add(CP2_bq21);
#endregion
#region //���
BQData CP2_bq14 = new BQData();
CP2_bq14.BQname = "B_M_18d8b106_2779_4c70_8fbf_3a53c4a46c1c";
CP2_bq14.BQdata = newyear.ToString();
mk_chapter2.Data.Add(CP2_bq14);
#endregion
#region //���
BQData CP2_bq15 = new BQData();
CP2_bq15.BQname = "B_M_faa6c0e3_78d6_4942_88c4_384066f8466a";
CP2_bq15.BQdata = newyear.ToString();
mk_chapter2.Data.Add(CP2_bq15);
#endregion
#region //���
BQData CP2_bq16 = new BQData();
CP2_bq16.BQname = "B_M_745905b2_e72f_4775_9899_695553815690";
CP2_bq16.BQdata = newyear.ToString();
mk_chapter2.Data.Add(CP2_bq16);
#endregion
#region //���
BQData CP2_bq17 = new BQData();
CP2_bq17.BQname = "B_M_211f0bc9_38c3_4149_bd9a_f59c74032f93";
CP2_bq17.BQdata = newyear.ToString();
mk_chapter2.Data.Add(CP2_bq17);
#endregion
#region //���
BQData CP2_bq18 = new BQData();
CP2_bq18.BQname = "B_M_17a059f8_8a86_481d_92cf_d9f6c747a45c";
CP2_bq18.BQdata = newyear.ToString();
mk_chapter2.Data.Add(CP2_bq18);
#endregion
#region //���
BQData CP2_bq19 = new BQData();
CP2_bq19.BQname = "B_M_ab41934d_cfd8_4dca_a29d_5850f6de93b5";
CP2_bq19.BQdata = newyear.ToString();
mk_chapter2.Data.Add(CP2_bq19);
#endregion
#region //���
BQData CP2_bq20 = new BQData();
CP2_bq20.BQname = "B_M_b8a0cb80_8955_478b_bd74_61fb9290ffef";
CP2_bq20.BQdata = newyear.ToString();
mk_chapter2.Data.Add(CP2_bq20);
#endregion
//�½�22
//ִ�и��²���
BookMark_RefreaDat(W_bkm, mk_chapter2, type);
}
private void Refreh_P_Chapter1(string year, Word.Bookmarks W_bkm, string type)
{
string old_value = "����ԭֵ";
MKData mk_chapter1 = new MKData();
mk_chapter1.ZJname = "��һ��";
BQData CP1_data1 = new BQData();
CP1_data1.BQname = "B_M_0853d43c_e721_4a11_806f_992fab74c355";
CP1_data1.BQdata = "����ֵ";
mk_chapter1.Data.Add(CP1_data1);
//ִ�и��²���
BookMark_RefreaDat(W_bkm, mk_chapter1, type);
}
private void Refreh_N_Chapter3(string year, Word.Bookmarks W_bkm, string type)
{
int newyear = int.Parse(year) - 1;
string old_value = "����ԭֵ";
string tiaojian = "";
MKData mk_chapter3 = new MKData();
mk_chapter3.ZJname = "������";
#region //�������
BQData CP3_bq1 = new BQData();
CP3_bq1.BQname = "B_M_3032ef0f_0154_44ab_9c20_120417b6e472";
CP3_bq1.BQdata = newyear.ToString();
mk_chapter3.Data.Add(CP3_bq1);
#endregion
#region //220kv��������
BQData CP3_bq2 = new BQData();
CP3_bq2.BQname = "B_M_b7155a1c_b7c2_4c94_9bbe_dea6b23e903e";
tiaojian = " Flag='1' and L1=220 and AreaID='" + ProjID + "' and cast(S2 as int)<=" + year;
IList<PSP_Substation_Info> psilist = Common.Services.BaseService.GetList<PSP_Substation_Info>("SelectPSP_Substation_InfoListByWhere", tiaojian);
if (psilist.Count > 0)
{
int sum = 0;
double volum = 0;
string tempstr = "";
for (int i = 0; i < psilist.Count; i++)
{
tempstr += psilist[i].Title + "(" + psilist[i].L4 + "MVA)��";
//������̨����
sum += psilist[i].L3;
//�ܱ������
volum += psilist[i].L2;
}
CP3_bq2.BQdata = "220kV�����" + psilist.Count + "���ֱ�Ϊ:" + tempstr.Substring(0, tempstr.LastIndexOf("��")) + ",����" + sum + "̨��������" + volum + "MVA��";
}
else
{
CP3_bq2.BQdata = old_value;
}
mk_chapter3.Data.Add(CP3_bq2);
#endregion
#region //110kv��������
BQData CP3_bq3 = new BQData();
CP3_bq3.BQname = "B_M_2f784b53_d1a3_4799_ad84_3743f012dacf";
tiaojian = " Flag='1' and L1=110 and AreaID='" + ProjID + "' and cast(S2 as int)<=" + year;
psilist = Common.Services.BaseService.GetList<PSP_Substation_Info>("SelectPSP_Substation_InfoListByWhere", tiaojian);
if (psilist.Count > 0)
{
int sum = 0;
double volum = 0;
string tempstr = "";
for (int i = 0; i < psilist.Count; i++)
{
tempstr += psilist[i].Title + "(" + psilist[i].L4 + "MVA)��";
//������̨����
sum += psilist[i].L3;
//�ܱ������
volum += psilist[i].L2;
}
CP3_bq3.BQdata = "110kV�����" + psilist.Count + "���ֱ�Ϊ:" + tempstr.Substring(0, tempstr.LastIndexOf("��")) + ",����" + sum + "̨��������" + volum + "MVA��";
}
else
{
CP3_bq3.BQdata = old_value;
}
mk_chapter3.Data.Add(CP3_bq3);
#endregion
#region //�������
BQData CP3_bq4 = new BQData();
CP3_bq4.BQname = "B_M_23b3f0b7_9471_4d49_8ff3_ded78e94e15c";
CP3_bq4.BQdata = newyear.ToString();
mk_chapter3.Data.Add(CP3_bq4);
#endregion
#region //�ظſ�
//���������
int sumGY_35_Bian = 0;
//��������̨��
int sumGY_35_Tai = 0;
//�������
double volumGY_35 = 0;
//������·����
int sumGY_35_Line = 0;
//������·����
double lengthGY_35_Line = 0;
//�û����������
int sumZY_35_Bian = 0;
//�û�����̨��
int sumZY_35_Tai = 0;
//�û��������
double volumZY_35 = 0;
//�û���·����
int sumZY_35_Line = 0;
//�û���·����
double lengthZY_35_Line = 0;
//��������̨��
int sumGY_10_Tai = 0;
//�������
double volumGY_10 = 0;
//�û�����̨��
int sumZY_10_Tai = 0;
//�û��������
double volumZY_10 = 0;
//10kv������
double volum_10_all = 0;
//������·����
int sum_10_Line = 0;
//������·����
double length_10_Line = 0;
#endregion
#region //35kv��������
BQData CP3_bq5 = new BQData();
CP3_bq5.BQname = "B_M_6837b8e5_b472_4a41_b643_b68b333c86fa";
tiaojian = " Flag='1' and L1=35 and S4='����' and AreaID='" + ProjID + "' and cast(S2 as int)<=" + year;
psilist = Common.Services.BaseService.GetList<PSP_Substation_Info>("SelectPSP_Substation_InfoListByWhere", tiaojian);
if (psilist.Count > 0)
{
sumGY_35_Bian = psilist.Count;
int sum = 0;
double volum = 0;
string tempstr = "";
for (int i = 0; i < psilist.Count; i++)
{
tempstr += psilist[i].Title + "(" + psilist[i].L4 + "MVA)��";
//������̨����
sum += psilist[i].L3;
//�ܱ������
volum += psilist[i].L2;
}
sumGY_10_Tai = sum;
volumGY_35 = volum;
//35kV���ñ��վ12������������20̨���ܱ������131800kVA
CP3_bq5.BQdata = "35kV���ñ��վ" + psilist.Count + "��,��������" + sum + "̨���ܱ������" + volum + "MVA��";
}
else
{
CP3_bq5.BQdata = old_value;
}
mk_chapter3.Data.Add(CP3_bq5);
#endregion
#region //35kv������·���
BQData CP3_bq6 = new BQData();
CP3_bq6.BQname = "B_M_e0cb72b3_6faa_46eb_987f_5373d37e2326";
tiaojian = " Type='05' and RateVolt=35 and LineType2='����' and ProjectID='" + ProjID + "' and year(cast(OperationYear as datetime))<=" + year;
if (Common.Services.BaseService.GetObject("SelectPSPDEV_CountAll", tiaojian) != null)
{
int sum = (int)Common.Services.BaseService.GetObject("SelectPSPDEV_CountAll", tiaojian);
double length = 0; if (Common.Services.BaseService.GetObject("SelectPSPDEV_SUM_Length", tiaojian)!=null) { length = (double)Common.Services.BaseService.GetObject("SelectPSPDEV_SUM_Length", tiaojian);}
CP3_bq6.BQdata = "35kV������·" + sum + "����" + length + "km";
sumGY_35_Line = sum;
lengthGY_35_Line = length;
}
else
{
CP3_bq6.BQdata = old_value;
}
mk_chapter3.Data.Add(CP3_bq6);
#endregion
#region //35kvר�ñ�������
BQData CP3_bq7 = new BQData();
CP3_bq7.BQname = "B_M_6261af63_709a_45f2_abd5_ce827d7b66df";
tiaojian = " Flag='1' and L1=35 and S4='ר��' and AreaID='" + ProjID + "' and cast(S2 as int)<=" + year;
psilist = Common.Services.BaseService.GetList<PSP_Substation_Info>("SelectPSP_Substation_InfoListByWhere", tiaojian);
if (psilist.Count > 0)
{
int sum = 0;
double volum = 0;
string tempstr = "";
for (int i = 0; i < psilist.Count; i++)
{
tempstr += psilist[i].Title + "(" + psilist[i].L4 + "MVA)��";
//������̨����
sum += psilist[i].L3;
//�ܱ������
volum += psilist[i].L2;
}
//35kV�û����վ12������������20̨���ܱ������131800kVA
CP3_bq7.BQdata = "35kV�û����վ" + psilist.Count + "��,��������" + sum + "̨���ܱ������" + volum + "MVA��";
sumZY_35_Bian = psilist.Count;
sumZY_35_Tai = sum;
volumZY_35 = volum;
}
else
{
CP3_bq7.BQdata = old_value;
}
mk_chapter3.Data.Add(CP3_bq7);
#endregion
#region //35kvר����·���
BQData CP3_bq8 = new BQData();
CP3_bq8.BQname = "B_M_b28b0759_f7ee_4fbe_9771_4cd1f730a116";
tiaojian = " Type='05' and RateVolt=35 and LineType2='ר��' and ProjectID='" + ProjID + "' and year(cast(OperationYear as datetime))<=" + year;
if (Common.Services.BaseService.GetObject("SelectPSPDEV_CountAll", tiaojian) != null)
{
int sum = (int)Common.Services.BaseService.GetObject("SelectPSPDEV_CountAll", tiaojian);
double length = 0;
if (Common.Services.BaseService.GetObject("SelectPSPDEV_SUM_Length", tiaojian)!=null)
{
length = (double)Common.Services.BaseService.GetObject("SelectPSPDEV_SUM_Length", tiaojian);
}
CP3_bq8.BQdata = "35kV�û���·" + sum + "����" + length + "km";
sumZY_35_Line = sum;
lengthZY_35_Line = length;
if (sum==0)
{
CP3_bq8.BQdata = old_value;
}
}
else
{
CP3_bq8.BQdata = old_value;
}
mk_chapter3.Data.Add(CP3_bq8);
#endregion
//10kV�������732̨���ܱ������102180kVA���û���740̨, �������149128kVA��������Ϊ251308kVA��10kV��·58 ������808.975km��
#region //10kv���վ��·���
BQData CP3_bq9 = new BQData();
CP3_bq9.BQname = "B_M_10a9f505_2cdb_461d_a239_a34d61d5e3f7";
tiaojian = " Flag='1' and L1=10 and S4='����' and AreaID='" + ProjID + "' and cast(S2 as int)<=" + year;
psilist = Common.Services.BaseService.GetList<PSP_Substation_Info>("SelectPSP_Substation_InfoListByWhere", tiaojian);
double volumall=0;
int sumall = 0;
int sumGY = 0;
double volumGY = 0;
if (psilist.Count > 0)
{
int sum = 0;
double volum = 0;
for (int i = 0; i < psilist.Count; i++)
{
//������̨����
sum += psilist[i].L3;
//�ܱ������
volum += psilist[i].L2;
}
sumGY = sum;
sumGY_10_Tai = sum;
volumGY = volum;
volumGY_10 = volum;
sumall += sum;
volumall += volum;
//35kV�û����վ12������������20̨���ܱ������131800kVA
CP3_bq9.BQdata = "10kV�������" + sum + "̨,�ܱ������" + sum + "̨���ܱ������" + volum + "MVA��";
}
tiaojian = " Flag='1' and L1=10 and S4='ר��' and AreaID='" + ProjID + "' and cast(S2 as int)<=" + year;
psilist = Common.Services.BaseService.GetList<PSP_Substation_Info>("SelectPSP_Substation_InfoListByWhere", tiaojian);
if (psilist.Count > 0)
{
int sum = 0;
double volum = 0;
for (int i = 0; i < psilist.Count; i++)
{
//������̨����
sum += psilist[i].L3;
//�ܱ������
volum += psilist[i].L2;
}
sumall += sum;
sumZY_10_Tai = sum;
volumall+=volum;
volumZY_10 = volum;
volum_10_all = volumGY_10 + volumZY_10;
//35kV�û����վ12������������20̨���ܱ������131800kVA
CP3_bq9.BQdata += "�û���" + sum + "̨,�ܱ������" + sum + "̨���������" + volum + "MVA��������Ϊ" + volumall + "MVA��";
}
tiaojian = " Type='05' and RateVolt=10 and ProjectID='" + ProjID + "' and year(cast(OperationYear as datetime))<=" + year;
if (Common.Services.BaseService.GetObject("SelectPSPDEV_CountAll", tiaojian) != null)
{
int sum = (int)Common.Services.BaseService.GetObject("SelectPSPDEV_CountAll", tiaojian);
double length=0;
if (Common.Services.BaseService.GetObject("SelectPSPDEV_SUM_Length", tiaojian)!=null)
{
length = (double)Common.Services.BaseService.GetObject("SelectPSPDEV_SUM_Length", tiaojian);
}
CP3_bq9.BQdata += "10kV��·" + sum + "������" + length + "km��";
sum_10_Line = sum;
length_10_Line = length;
}
if (CP3_bq9.BQdata.ToString().Length<5)
{
CP3_bq9.BQdata = old_value;
}
mk_chapter3.Data.Add(CP3_bq9);
#endregion
//2008��ף�ͭ���ع�˾��10kV���1469̨���ۼ�����251.3 MVA�����й������732̨���ۼ�����102.18MVA
#region //10kv���վ��·���
BQData CP3_bq10 = new BQData();
CP3_bq10.BQname = "B_M_2f0d9e1f_fac5_4489_ab0d_7a052e35149d";
CP3_bq10.BQdata = newyear + "��ף�ͭ���ع�˾��10kV���" + sumall + "̨���ۼ�����" + volumall + " MVA�����й������" + sumGY + "̨���ۼ�����" + volumGY+"MVA";
if (sumall==0)
{
CP3_bq10.BQdata = old_value;
}
mk_chapter3.Data.Add(CP3_bq10);
#endregion
//��ֹ2008��ף�ͭ���ص�������35kV���ñ��վ12������������20̨���ܱ������138000kVA��
//35kV������·16����81.878km��35kV�û����վ13������������20̨���ܱ������33865kVA��
//35kV�û���·10����26.06km��10kV�������732̨���ܱ������102180kVA���û���740̨,
//�������149128kVA��������Ϊ251308kVA��10kV��·58 ������808.975km��
#region //ũ������
BQData CP3_bq11 = new BQData();
CP3_bq11.BQname = "B_M_1b48d492_5022_4f59_b433_7b19343ae4b1";
CP3_bq11.BQdata = "��ֹ" + newyear + "��ף�ͭ���ص�������";
if (sumGY_35_Bian>0)
{
CP3_bq11.BQdata += "35kV���ñ��վ"+sumGY_35_Bian+"������������"+sumGY_35_Tai+"̨���ܱ������"+volumGY_35+"MVA;";
}
if (sumGY_35_Line>0)
{
CP3_bq11.BQdata += "35kV������·" + sumGY_35_Line + "����" + lengthGY_35_Line + "km��";
}
if (sumZY_35_Bian>0)
{
CP3_bq11.BQdata +="35kV�û����վ" + sumZY_35_Bian + "������������" + sumZY_35_Tai + "̨���ܱ������" + volumZY_35 + "MVA��";
}
if (sumZY_35_Line>0)
{
CP3_bq11.BQdata += "35kV�û���·"+sumZY_35_Line+"����"+lengthZY_35_Line+"km��";
}
if (sumGY_10_Tai>0)
{
CP3_bq11.BQdata +="10kV�������"+sumGY_10_Tai+"̨���ܱ������"+volumGY_10+"MVA��";
}
if (sumZY_10_Tai>0)
{
CP3_bq11.BQdata += "�û���"+sumZY_10_Tai+"̨,�������"+volumZY_10+"MVA��";
}
if (volum_10_all>0)
{
CP3_bq11.BQdata += "������Ϊ"+volum_10_all+"MVA��";
}
if (sum_10_Line>0)
{
CP3_bq11.BQdata += "10kV��·" + sum_10_Line + " ������" + length_10_Line + "km��";
}
if (CP3_bq11.BQdata.ToString()=="��ֹ" + newyear + "��ף�ͭ���ص�������")
{
CP3_bq11.BQdata = old_value;
}
mk_chapter3.Data.Add(CP3_bq11);
#endregion
//ִ�и��²���
BookMark_RefreaDat(W_bkm, mk_chapter3, type);
}
