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); }
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); }