private void LoadData1(int id) { if (dataTable != null) { dataTable.Columns.Clear(); treeList1.Columns.Clear(); } ((System.ComponentModel.ISupportInitialize)(this.treeList1)).BeginInit(); AddFixColumn(); for (int i = startyear; i <= endyear; i++) { AddColumn(i); } ((System.ComponentModel.ISupportInitialize)(this.treeList1)).EndInit(); Ps_History psp_Type = new Ps_History(); psp_Type.Forecast = id; psp_Type.Col4 = pid; IList <Ps_History> listTypes = Common.Services.BaseService.GetList <Ps_History>("SelectPs_HistoryByForecast", psp_Type); dataTable = Itop.Common.DataConverter.ToDataTable((IList)listTypes, typeof(Ps_History)); treeList1.DataSource = dataTable; treeList1.Columns["Sort"].SortOrder = SortOrder.Ascending; treeList1.Columns["Title"].Caption = "分类名"; treeList1.Columns["Title"].Width = 180; treeList1.Columns["Title"].OptionsColumn.AllowEdit = false; treeList1.Columns["Title"].OptionsColumn.AllowSort = false; Application.DoEvents(); treeList1.CollapseAll(); //LoadValues1(htt); //treeList1.Nodes[0].Expanded = true; //treeList1.ExpandAll(); }
/// <summary> /// 显示数据 /// </summary> private void ViewSheet2_1Data(FarPoint.Win.Spread.SheetView obj, string Title, Itop.Client.Base.FormBase FB, int FistYear, int IntRow, int IntCol, string SingleTitle) { string Temp = "y" + FistYear.ToString(); Ps_History psp_Type = new Ps_History(); psp_Type.Forecast = IntType; psp_Type.Col4 = FB.ProjectUID; //IList<Ps_History> listTypes = Itop.Client.Common.Services.BaseService.GetList<Ps_History>("SelectPs_HistoryByForecast", psp_Type); //dataTable = Itop.Common.DataConverter.ToDataTable((IList)listTypes, typeof(Ps_History)); // for (int i = 0; i < YearCount ; i++) // { // if (dataTable.Columns[i].Caption == Temp) // MessageBox.Show(listTypes[i]=Temp); // } string con = null; Ps_History GDP1 = null; //if (Title != "年末总人口(万人)" && Title != "城镇化率(%)") //{ if ((Title == "一产") || (Title == "二产") || (Title == "三产")) { //con = "Title='" + SingleTitle + "'AND Col4='" + FB.ProjectUID + "'AND Forecast='" + IntType + "'"; //GDP1 = (Ps_History)Services.BaseService.GetObject("SelectPs_HistoryByCondition", con); //TwoParentID = GDP1.ID; //if (Title == "一产") //{ // resualt.Add(SingleTitle, GDP1); //} //con = "Title='" + Title + "'AND Col4='" + FB.ProjectUID + "'AND Forecast='" + IntType + "'"; //con += "AND ParentID='" + TwoParentID + "'"; //GDP1 = (Ps_History)Services.BaseService.GetObject("SelectPs_HistoryByCondition", con); //resualt.Add(Title, GDP1); } else { con = "Title='" + Title + "'AND Col4='" + FB.ProjectUID + "'AND Forecast='" + IntType + "'"; GDP1 = (Ps_History)Services.BaseService.GetObject("SelectPs_HistoryByCondition", con); resualt.Add(Title, GDP1); } ////判断是否年份中有数字,没有就不显示 //if (Gethistroyvalue<Ps_History>(resualt[Title], Temp) > 0.0000 || Gethistroyvalue<Ps_History>(resualt[Title], Temp) <0.0000) if (FistYear != 2001 && FistYear != 2002 && FistYear != 2003 && FistYear != 2004) { if ((Title == "一产") || (Title == "二产") || (Title == "三产")) { floatSum[4] = SumTertiaryIndustry(SingleTitle, FB, Temp, Title); obj.SetValue(IntRow, IntCol, ((PF.Gethistroyvalue <Ps_History>(resualt[Title], Temp)) / floatSum[4])); } else { obj.SetValue(IntRow, IntCol, PF.Gethistroyvalue <Ps_History>(resualt[Title], Temp)); } } //} }
/// <summary> /// 添加一产二产三产值 /// </summary> /// <param name="Title"></param> private void Add(Itop.Client.Base.FormBase FB, string Title) { Ps_History GDP1 = null; string con = null; con = "Title='" + Title + "'AND Col4='" + FB.ProjectUID + "'AND Forecast='" + IntType + "'"; con += "AND ParentID='" + TwoParentID + "'"; GDP1 = (Ps_History)Services.BaseService.GetObject("SelectPs_HistoryByCondition", con); resualt.Add(Title, GDP1); }
/// <summary> /// 返回记录集 /// </summary> public void ReturnRecordSet(Itop.Client.Base.FormBase FB, string Year, string Title) { //string Temp1 = "y" + Year; Ps_History GDP1 = null; string con = null; con = "Title='" + Title + "'AND Col4='" + FB.ProjectUID + "'AND Forecast='" + IntType + "'"; GDP1 = (Ps_History)Services.BaseService.GetObject("SelectPs_HistoryByCondition", con); resualt.Add(Title, GDP1); }
private void DealTreelist(InDataClass idc) { SetYear(idc.YearFlag); AddFixColumn(); Ps_History psp_Type = new Ps_History(); psp_Type.Forecast = idc.IType; psp_Type.Col4 = ProjectUID; IList <Ps_History> listTypes = Common.Services.BaseService.GetList <Ps_History>("SelectPs_HistoryByForecast", psp_Type); treeList1.DataSource = listTypes; }
/// <summary> /// 返回上级目录的id /// </summary> /// <returns></returns> private Ps_History ReturnStrID(Itop.Client.Base.FormBase FB, string strTitle) { string sql = "col4='" + FB.ProjectUID + "' and Title='" + strTitle + "'"; Ps_History ph = null; try { ph = (Ps_History)Services.BaseService.GetObject("SelectPs_HistoryByCondition", sql); } catch (System.Exception e) { MessageBox.Show(e.Message); } return(ph); }
/// <summary> /// 人均GDP /// </summary> /// <param name="obj">SheetView object</param> /// <param name="Title">title</param> /// <param name="Years">current year</param> /// <param name="IntRow">current row</param> /// <param name="IntCol">current column</param> private void PerCapitaGDP(FarPoint.Win.Spread.SheetView obj, Itop.Client.Base.FormBase FB, string Title, int Years, int IntRow, int IntCol) { float Temp = 0; string Temp1 = "y" + Years.ToString(); Ps_History GDP1 = null; string con = null; con = "Title='" + "全地区GDP(亿元)" + "'AND Col4='" + FB.ProjectUID + "'AND Forecast='" + IntType + "'"; GDP1 = (Ps_History)Services.BaseService.GetObject("SelectPs_HistoryByCondition", con); resualt.Add("全地区GDP(亿元)", GDP1); Temp = (float)PF.Gethistroyvalue <Ps_History>(resualt["全地区GDP(亿元)"], Temp1); obj.SetValue(IntRow, IntCol, Temp / StrToFloat(obj.GetValue((IntRow), IntCol - 1).ToString())); //PF.SetRowHight(obj,IntRow, IntCol, Temp / StrToFloat(obj.GetValue((IntRow), IntCol - 1).ToString())); }
/// <summary> /// 查询当前数据 /// </summary> /// <param name="FB"></param> /// <param name="CurrentYear"></param> /// <param name="RowTitle"></param> private object SelectCurrentData(Itop.Client.Base.FormBase FB, string CurrentYear, string RowTitle, Ps_History ps1, Ps_History ps2, Ps_History ps3) { string sql = null; object value = 0; string strTemp = "y" + CurrentYear; Ps_History ph = null; if (RowTitle == "全社会用电总计") { RowTitle = "全社会用电量(亿kWh)"; } if (RowTitle == "全行业用电合计" || RowTitle == "居民生活用电合计") { sql = " select " + strTemp + " from ps_History where Title='" + RowTitle + "' and col4='" + FB.ProjectUID + "' and ParentID='" + ps1.ID + "'"; } else if (RowTitle == "第一产业" || RowTitle == "第二产业" || RowTitle == "第三产业") { sql = " select " + strTemp + " from ps_History where Title='" + RowTitle + "' and col4='" + FB.ProjectUID + "' and ParentID='" + ps2.ID + "'"; } else if (RowTitle == "农、林、牧、渔业" || RowTitle == "工业" || RowTitle == "建筑业" || RowTitle == "交通运输、仓储、邮政业" || RowTitle == "信息传输、计算机服务和软件业" || RowTitle == "商业、住宿和餐饮业" || RowTitle == "金融、房地产、商务及居民服务业" || RowTitle == "公共事业及管理组织") { sql = " select " + strTemp + " from ps_History where Title='" + RowTitle + "' and col4='" + FB.ProjectUID + "' and ParentID='" + ps3.ID + "'"; } else { sql = " select " + strTemp + " from ps_History where Title='" + RowTitle + "' and col4='" + FB.ProjectUID + "'"; } try { value = (double)Services.BaseService.GetObject("SelectPs_HistoryPopulationByCondition", sql); } catch (Exception e) { MessageBox.Show("错误,错误原因:" + e.Message, "提示错误", MessageBoxButtons.OK, MessageBoxIcon.Information); } return(value); }
private void CalculateSum(TreeListNode node, TreeListColumn column) { Ps_History v = Services.BaseService.GetOneByKey <Ps_History>(node["ID"].ToString()); TreeNodeToDataObject <Ps_History>(v, node); Common.Services.BaseService.Update <Ps_History>(v); TreeListNode parentNode = node.ParentNode; if (parentNode == null) { return; } double sum = 0; foreach (TreeListNode nd in parentNode.Nodes) { object value = nd.GetValue(column.FieldName); if (value != null && value != DBNull.Value) { sum += Convert.ToDouble(value); } } if (sum != 0) { parentNode.SetValue(column.FieldName, sum); v = Services.BaseService.GetOneByKey <Ps_History>(parentNode["ID"].ToString()); TreeNodeToDataObject <Ps_History>(v, parentNode); Common.Services.BaseService.Update <Ps_History>(v); } else { parentNode.SetValue(column.FieldName, 0); } CalculateSum(parentNode, column); }
private void simpleButton1_Click(object sender, EventArgs e) { double Tavg = 0.0; //求其多年的年平均温度的平均温度 Ps_History wend = new Ps_History(); for (int j = 0; j < fucol.Count; j++) { if (fucol[j].Title.Contains("平均温度")) { wend = fucol[j]; for (int i = firstyear; i <= endyear; i++) { Tavg += Convert.ToDouble(fucol[j].GetType().GetProperty("y" + i.ToString()).GetValue(fucol[j], null)); } } } Tavg /= endyear - firstyear + 1; foreach (Ps_History ph in fucol) { if (!ph.Title.Contains("平均温度")) { for (int i = firstyear; i <= endyear; i++) { double tmax = Convert.ToDouble(wend.GetType().GetProperty("y" + i).GetValue(wend, null)); if (tmax < Tavg) { double sz = Convert.ToDouble(ph.GetType().GetProperty("y" + i).GetValue(ph, null)) * (1 + (Tavg - tmax) * temk1); ph.GetType().GetProperty("y" + i).SetValue(ph, sz, null); } else if (tmax > Tavg) { double sz = Convert.ToDouble(ph.GetType().GetProperty("y" + i).GetValue(ph, null)) * (1 + (Tavg - tmax) * temk2); ph.GetType().GetProperty("y" + i).SetValue(ph, sz, null); } } } } this.DialogResult = DialogResult.OK; }
/// <summary> /// 计算三产的和 /// </summary> /// <returns></returns> private float SumTertiaryIndustry(string SingleTitle, Itop.Client.Base.FormBase FB, string years, string Title) { Ps_History GDP1 = null; string con = null; con = "Title='" + SingleTitle + "'AND Col4='" + FB.ProjectUID + "'AND Forecast='" + IntType + "'"; GDP1 = (Ps_History)Services.BaseService.GetObject("SelectPs_HistoryByCondition", con); TwoParentID = GDP1.ID; if (Title == "一产") { Add(FB, "一产"); Add(FB, "二产"); Add(FB, "三产"); } floatSum[0] = (float)PF.Gethistroyvalue <Ps_History>(resualt["一产"], years); floatSum[1] = (float)PF.Gethistroyvalue <Ps_History>(resualt["二产"], years); floatSum[2] = (float)PF.Gethistroyvalue <Ps_History>(resualt["三产"], years); floatSum[3] = floatSum[0] + floatSum[1] + floatSum[2]; return(floatSum[3]); }
/// <summary> /// 返回记录集 /// </summary> private void ReturnRecordSet(Itop.Client.Base.FormBase FB, string Year, string Title) { string Temp1 = "y" + Year; Ps_History GDP1 = null; string con = null; if (Title == "一产" || Title == "二产" || Title == "三产") { con = "Title='" + Title + "'AND Col4='" + FB.ProjectUID + "'AND Forecast='" + IntType + "'"; con = con + "AND ParentID='" + ParentId + "'"; } else { con = "Title='" + Title + "'AND Col4='" + FB.ProjectUID + "'AND Forecast='" + IntType + "'"; } GDP1 = (Ps_History)Services.BaseService.GetObject("SelectPs_HistoryByCondition", con); if (Title == "全地区GDP(亿元)") { ParentId = GDP1.ID; } resualt.Add(Title, GDP1); }
private void InitData() { Ps_YearRange py = new Ps_YearRange(); py.Col4 = yearflag; py.Col5 = projectUID; IList <Ps_YearRange> li = Itop.Client.Common.Services.BaseService.GetList <Ps_YearRange>("SelectPs_YearRangeByCol5andCol4", py); if (li.Count > 0) { firstyear = li[0].StartYear; endyear = li[0].FinishYear; } else { firstyear = 2000; endyear = 2008; py.BeginYear = 1990; py.FinishYear = endyear; py.StartYear = firstyear; py.EndYear = 2060; py.ID = Guid.NewGuid().ToString(); Itop.Client.Common.Services.BaseService.Create <Ps_YearRange>(py); } DataTable dt = new DataTable(); dt.Columns.Add("ID"); dt.Columns.Add("Year"); dt.Columns.Add("GDP", typeof(double)); dt.Columns.Add("A", typeof(double)); Ps_History psp_Type = new Ps_History(); psp_Type.Forecast = pstype; psp_Type.Col4 = projectUID; IList <Ps_History> listTypes = Common.Services.BaseService.GetList <Ps_History>("SelectPs_HistoryByForecast", psp_Type); DataTable dataTable = Itop.Common.DataConverter.ToDataTable((IList)listTypes, typeof(Ps_History)); DataRow[] rows1 = dataTable.Select("Title like '全地区GDP%'"); DataRow[] rows2 = dataTable.Select("Title like '年末总人口%'"); //找不到数据时给出提示 if (rows1.Length == 0 || rows2.Length == 0) { MessageBox.Show("缺少‘全地区GDP’或‘年末总人口’ 数据,无法进行统计!"); this.Close(); return; } string pid = rows1[0]["ID"].ToString(); DataRow[] rows3 = dataTable.Select("ParentID='" + pid + "'"); int m = -1; for (int k = 0; k < rows3.Length; k++) { m++; dt.Columns.Add("m" + m, typeof(double)); dt.Columns.Add("n" + m, typeof(double)); GridColumn gridColumn = new GridColumn(); gridColumn.Caption = rows3[k]["Title"].ToString(); gridColumn.FieldName = "m" + m; gridColumn.Visible = true; gridColumn.VisibleIndex = 2 * m + 10; gridColumn.DisplayFormat.FormatString = "n2"; gridColumn.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric; gridColumn.Width = 70; this.gridView1.Columns.Add(gridColumn); GridColumn gridColumn1 = new GridColumn(); gridColumn1.Caption = "比例(%)"; gridColumn1.FieldName = "n" + m; gridColumn1.Visible = true; gridColumn1.VisibleIndex = 2 * m + 11; gridColumn1.DisplayFormat.FormatString = "n0"; gridColumn1.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric; gridColumn1.Width = 80; this.gridView1.Columns.Add(gridColumn1); } GridColumn gridColumn2 = new GridColumn(); gridColumn2.Caption = "人口(万人)"; gridColumn2.FieldName = "RK"; gridColumn2.Visible = true; gridColumn2.VisibleIndex = 2 * m + 12; gridColumn2.DisplayFormat.FormatString = "n2"; gridColumn2.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric; gridColumn2.Width = 90; dt.Columns.Add("RK", typeof(double)); this.gridView1.Columns.Add(gridColumn2); GridColumn gridColumn3 = new GridColumn(); gridColumn3.Caption = "人均GDP(万元/人)"; gridColumn3.FieldName = "RJGDP"; gridColumn3.Visible = true; gridColumn3.VisibleIndex = 2 * m + 13; gridColumn3.DisplayFormat.FormatString = "n4"; gridColumn3.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric; gridColumn3.Width = 120; dt.Columns.Add("RJGDP", typeof(double)); this.gridView1.Columns.Add(gridColumn3); double sum1 = 0; for (int i = firstyear; i <= endyear; i++) { if (!ht.ContainsValue(i)) { continue; } DataRow row = dt.NewRow(); row["ID"] = Guid.NewGuid().ToString(); row["Year"] = i; double sum = 0; try { sum = Convert.ToDouble(rows1[0]["y" + i]); } catch { } row["GDP"] = sum.ToString(); if (i == firstyear) { sum1 = sum; } if (sum1 != 0) { sum1 = sum * 100 / sum1; } row["A"] = sum1.ToString("n2"); sum1 = sum; for (int j = 0; j <= m; j++) { double s = 0; double y = 0; try { s = Convert.ToDouble(rows3[j]["y" + i]); } catch { } row["m" + j] = s.ToString(); if (sum != 0) { y = s * 100 / sum; } row["n" + j] = detel_jd(y, 2); } double rk = 0; double rjgdp = 0; try { rk = Convert.ToDouble(rows2[0]["y" + i]); } catch { } row["RK"] = rk.ToString(); if (rk != 0) { rjgdp = sum / rk; } row["RJGDP"] = detel_jd(rjgdp, 4); dt.Rows.Add(row); } this.gridControl1.DataSource = dt; }
private void InitData() { Ps_YearRange py = new Ps_YearRange(); py.Col4 = yearflag; py.Col5 = projectUID; IList <Ps_YearRange> li = Itop.Client.Common.Services.BaseService.GetList <Ps_YearRange>("SelectPs_YearRangeByCol5andCol4", py); if (li.Count > 0) { firstyear = li[0].StartYear; endyear = li[0].FinishYear; } else { firstyear = 1990; endyear = 2020; py.BeginYear = 1990; py.FinishYear = endyear; py.StartYear = firstyear; py.EndYear = 2060; py.ID = Guid.NewGuid().ToString(); Itop.Client.Common.Services.BaseService.Create <Ps_YearRange>(py); } DataTable dt = new DataTable(); dt.Columns.Add("ID"); dt.Columns.Add("Title"); Ps_History psp_Type = new Ps_History(); psp_Type.Forecast = pstype; psp_Type.Col4 = projectUID; IList <Ps_History> listTypes = Common.Services.BaseService.GetList <Ps_History>("SelectPs_HistoryByForecast", psp_Type); DataTable dataTable = Itop.Common.DataConverter.ToDataTable((IList)listTypes, typeof(Ps_History)); DataRow[] rows1 = dataTable.Select("Title like '全地区GDP%'"); // DataRow[] rows2 = dataTable.Select("Title like '全社会供电量%'"); DataRow[] rows4 = dataTable.Select("Title like '全社会用电量%'"); //DataRow[] rows5 = dataTable.Select("Title like '全社会最大负荷%'"); DataRow[] rows7 = dataTable.Select("Title like '年末总人口%'"); DataRow[] rows8 = dataTable.Select("Title='居民用电'"); if (rows1.Length == 0) { MessageBox.Show("缺少全地区GDP数据!"); this.Close(); return; } //if (rows2.Length == 0) //{ // MessageBox.Show("缺少全社会供电量数据!"); // this.Close(); //} if (rows4.Length == 0) { MessageBox.Show("缺少全社会用电量数据!"); this.Close(); return; } //if (rows5.Length == 0) //{ // MessageBox.Show("缺少全社会最大负荷数据!"); // this.Close(); //} if (rows7.Length == 0) { MessageBox.Show("缺少年末总人口数据!"); this.Close(); return; } GDPUnits = Historytool.FindUnits(rows1[0]["Title"].ToString()); //全社会供电量单位 //AGdlUnits = Historytool.FindUnits(rows2[0]["Title"].ToString()); //全社会用电量单位 AYdlUnits = Historytool.FindUnits(rows4[0]["Title"].ToString()); //全社会最大负荷单位 // AMaxFhUnits = Historytool.FindUnits(rows5[0]["Title"].ToString()); //年末总人口单位 NMARkUnits = Historytool.FindUnits(rows7[0]["Title"].ToString()); string pid = rows1[0]["ID"].ToString(); string sid = rows4[0]["ID"].ToString(); ///全地区GDP子类 DataRow[] rows3 = dataTable.Select("ParentID='" + pid + "'"); ///会社会用电量子类 DataRow[] rows6 = dataTable.Select("ParentID='" + sid + "'"); int m = -1; this.gridControl1.BeginInit(); this.gridControl1.BeginUpdate(); for (int i = firstyear; i <= endyear; i++) { dt.Columns.Add("y" + i, typeof(double)); if (!ht.ContainsValue(i)) { continue; } if (IsFist) { RealFistYear = i; IsFist = false; } m++; //dt.Columns.Add("y" + i, typeof(double)); GridColumn gridColumn = new GridColumn(); gridColumn.Caption = i + "年"; gridColumn.FieldName = "y" + i; gridColumn.Visible = true; gridColumn.VisibleIndex = 2 * m + 10; gridColumn.Width = 70; gridColumn.DisplayFormat.FormatString = "n2"; gridColumn.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric; gridView1.Columns.Add(gridColumn); if (ht1.ContainsValue(i)) { gridColumn = new GridColumn(); gridColumn.Caption = "年均增长率(%)"; gridColumn.FieldName = "m" + i; gridColumn.Visible = true; gridColumn.Width = 130; gridColumn.VisibleIndex = 2 * m + 11; gridColumn.DisplayFormat.FormatString = "n2"; gridColumn.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric; gridView1.Columns.Add(gridColumn); dt.Columns.Add("m" + i, typeof(double)); } if (ht2.ContainsValue(i)) { gridColumn = new GridColumn(); gridColumn.Caption = "逐年增长率(%)"; gridColumn.FieldName = "n" + i; gridColumn.Visible = true; gridColumn.Width = 130; gridColumn.VisibleIndex = 2 * m + 12; gridColumn.DisplayFormat.FormatString = "n2"; gridColumn.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric; gridView1.Columns.Add(gridColumn); dt.Columns.Add("n" + i, typeof(double)); } } this.gridControl1.EndUpdate(); this.gridControl1.EndInit(); double sum = 0; // 全地区GDP数据 try { sum = Convert.ToDouble(rows1[0]["y" + firstyear]); } catch { } double sum51 = 0; // 全社会用电量数据 try { sum51 = Convert.ToDouble(rows4[0]["y" + firstyear]); } catch { } double sum52 = 0; double sum53 = 0; double sum1 = 0; double sum2 = 0; double sum3 = 0; double sum4 = 0; double sum5 = 0; double sum6 = 0; double sum7 = 0; double sum8 = 0; double sum9 = 0; double sum10 = 0; double sum11 = 0; double sum12 = 0; double sum13 = 0; DataRow row = dt.NewRow(); DataRow row3 = dt.NewRow(); DataRow row4 = dt.NewRow(); DataRow row5 = dt.NewRow(); DataRow row6 = dt.NewRow(); DataRow row7 = dt.NewRow(); DataRow row8 = dt.NewRow(); DataRow row9 = dt.NewRow(); DataRow row10 = dt.NewRow(); DataRow row11 = dt.NewRow(); row["ID"] = Guid.NewGuid().ToString(); row["Title"] = "一、地区生产总值(GDP," + GDPUnits + ")"; m = firstyear; for (int j = firstyear; j <= endyear; j++) { //if (!ht.ContainsValue(j)) lyh // continue; try { sum1 = Convert.ToDouble(rows1[0]["y" + j]); } catch { } row["y" + j] = sum1; try { sum51 = Convert.ToDouble(rows4[0]["y" + j]); } catch { } if (m != firstyear) //表示不是第一年,以后的年份要算增长 { try { sum2 = Convert.ToDouble(rows1[0]["y" + (j - 1)]); } catch { } try { sum52 = Convert.ToDouble(rows4[0]["y" + (j - 1)]); } catch { } if (sum52 != 0) { sum53 = sum51 * 100 / sum52 - 100; //用电量增长 } if (sum2 != 0) { sum3 = sum1 * 100 / sum2 - 100; //GDP增长 } row3["y" + j] = sum3; } else { row3["y" + j] = 1; } try { sum4 = Convert.ToDouble(rows4[0]["y" + j]); } catch { } row4["y" + j] = sum4; //用电量 //try { sum5 = Convert.ToDouble(rows5[0]["y" + j]); } //catch { } //row5["y" + j] = sum5;//最大负荷 //if (sum5 != 0) // sum6 = sum4 * 10000 / sum5; //row6["y" + j] = sum6;// 计算全社会最大负荷利用小时数 //try { sum7 = Convert.ToDouble(rows2[0]["y" + j]); } //catch { } if (m != firstyear) { //if (sum53 != 0) // sum8 = sum3 / sum53; //row7["y" + j] = sum8;//原计算 if (sum3 != 0) { sum8 = sum53 / sum3; } row7["y" + j] = sum8; //弹性系数,电力消费增长速度与国民经济增长的比值lgm } else { row7["y" + j] = 1; } try { sum9 = Convert.ToDouble(rows7[0]["y" + j]); } //年末人口 catch { } if (sum9 != 0) { if (AYdlUnits.Contains("亿") && NMARkUnits.Contains("万人")) //亿kWh 万人 { sum10 = sum51 * 10000 / sum9; //人均用电量 } else if (AYdlUnits.Contains("万") && NMARkUnits.Contains("万人")) //万kWh 万人 { sum10 = sum51 / sum9; //人均用电量 } else { MessageBox.Show("全社会用电量或年末总人口的单位错误!请用默认类别管理较对!(亿kWh,万kWh,万人)"); this.Close(); return; } } row8["y" + j] = sum10; if (sum1 != 0) { if (AYdlUnits.Contains("亿") && GDPUnits.Contains("亿元")) //亿kWh 亿元 { sum11 = sum4 * 10000 / sum1; //单产耗能 } else if (AYdlUnits.Contains("万") && GDPUnits.Contains("亿元")) //万kWh 亿元 { sum11 = sum4 / sum1; //单产耗能 } else { MessageBox.Show("全社会用电量或全地区GDP的单位错误!请用默认类别管理较对!(亿kWh,万kWh,亿元)"); this.Close(); return; } } row9["y" + j] = sum11; //单产耗能 if (rows8.Length > 0) { try { sum12 = Convert.ToDouble(rows8[0]["y" + j]); } catch { } row11["y" + j] = sum12; if (sum9 != 0) { if (AYdlUnits.Contains("亿") && NMARkUnits.Contains("万人")) //亿kWh 万人 { sum13 = sum12 * 10000 / sum9; //居民用电 } else if (AYdlUnits.Contains("万") && NMARkUnits.Contains("万人")) //万kWh 万人 { sum13 = sum12 / sum9; //居民用电 } else { MessageBox.Show("全社会用电量或年末总人口的单位错误!请用默认类别管理较对!(亿kWh,万kWh,万人)"); this.Close(); return; } } row10["y" + j] = sum13; } else { row10["y" + j] = sum13; } m++; } dt.Rows.Add(row); for (int k = 0; k < rows3.Length; k++) { double su1 = 0; double su2 = 0; double su3 = 0; DataRow ro1 = dt.NewRow(); ro1["ID"] = Guid.NewGuid().ToString(); ro1["Title"] = rows3[k]["Title"].ToString(); DataRow ro2 = dt.NewRow(); ro2["ID"] = Guid.NewGuid().ToString(); ro2["Title"] = "比例(%)"; for (int j = firstyear; j <= endyear; j++) { if (!ht.ContainsValue(j)) { continue; } try { su1 = Convert.ToDouble(rows1[0]["y" + j]); } catch { } su2 = 0; su3 = 0; try { su2 = Convert.ToDouble(rows3[k]["y" + j]); } catch { } ro1["y" + j] = su2; if (su1 != 0) { su3 = su2 * 100 / su1; } ro2["y" + j] = su3; } dt.Rows.Add(ro1); dt.Rows.Add(ro2); } row3["ID"] = Guid.NewGuid().ToString(); row3["Title"] = "地区生产总值增长率(%)"; dt.Rows.Add(row3); row4["ID"] = Guid.NewGuid().ToString(); row4["Title"] = "二、全社会用电量(" + AYdlUnits + ")"; dt.Rows.Add(row4); //row5["ID"] = Guid.NewGuid().ToString(); //row5["Title"] = "最大负荷(万千瓦)"; //dt.Rows.Add(row5); //row6["ID"] = Guid.NewGuid().ToString(); //row6["Title"] = "最大负荷利用小时数(小时)"; //dt.Rows.Add(row6); for (int k = 0; k < rows6.Length; k++) { double su1 = 0; double su2 = 0; double su3 = 0; DataRow ro1 = dt.NewRow(); ro1["ID"] = Guid.NewGuid().ToString(); ro1["Title"] = rows6[k]["Title"].ToString(); DataRow ro2 = dt.NewRow(); ro2["ID"] = Guid.NewGuid().ToString(); ro2["Title"] = "比例(%)"; for (int j = firstyear; j <= endyear; j++) { if (!ht.ContainsValue(j)) { continue; } try { su1 = Convert.ToDouble(rows4[0]["y" + j]); } catch { } su2 = 0; su3 = 0; try { su2 = Convert.ToDouble(rows6[k]["y" + j]); } catch { } ro1["y" + j] = su2; if (su1 != 0) { su3 = su2 * 100 / su1; } ro2["y" + j] = su3; } dt.Rows.Add(ro1); dt.Rows.Add(ro2); } row7["ID"] = Guid.NewGuid().ToString(); row7["Title"] = "弹性系数"; dt.Rows.Add(row7); row8["ID"] = Guid.NewGuid().ToString(); row8["Title"] = "人均用电量(千瓦时/人)"; dt.Rows.Add(row8); row9["ID"] = Guid.NewGuid().ToString(); row9["Title"] = "GDP单耗(千瓦时/万元)"; dt.Rows.Add(row9); for (int k = 0; k < rows6.Length; k++) { double su1 = 0; double su2 = 0; double su3 = 0; DataRow ro1 = dt.NewRow(); ro1["ID"] = Guid.NewGuid().ToString(); ro1["Title"] = rows6[k]["Title"].ToString(); for (int j = firstyear; j <= endyear; j++) { if (!ht.ContainsValue(j)) { continue; } su1 = 0; su2 = 0; su3 = 0; try { su1 = Convert.ToDouble(rows6[k]["y" + j]); } catch { } try { su2 = Convert.ToDouble(rows3[k]["y" + j]); } catch { } if (su2 != 0) { su3 = su1 * 10000 / su2; } else { su3 = su1; } ro1["y" + j] = su3; } if (rows6[k]["Title"].ToString().IndexOf("居民") >= 0) { continue; } dt.Rows.Add(ro1); } row10["ID"] = Guid.NewGuid().ToString(); row10["Title"] = "居民用电(千瓦时/人)"; dt.Rows.Add(row10); double d = 0; //年均增长率 foreach (DataRow drw1 in dt.Rows) { foreach (DataColumn dc in dt.Columns) { if (dc.ColumnName.IndexOf("m") >= 0) { string s = dc.ColumnName.Replace("m", ""); int y1 = int.Parse(s); double d1 = 0; try { d1 = (double)drw1["y" + s]; } catch { } int peryear = 0; for (int i = y1 - 1; i > 0; i--) { if (ht.ContainsValue(i)) { peryear = i; break; } } try { d = (double)drw1["y" + peryear]; } catch { } double sss = Math.Round(Math.Pow(d1 / d, 1.0 / (y1 - peryear)) - 1, 4); sss *= 100; if (sss.ToString() == "非数字" || sss.ToString() == "正无穷大") { sss = 0; } drw1["m" + s] = sss; } } } //逐年增长率 double dd = 0; foreach (DataRow drw1 in dt.Rows) { foreach (DataColumn dc in dt.Columns) { if (dc.ColumnName.IndexOf("n") >= 0) { string s = dc.ColumnName.Replace("n", ""); int y1 = int.Parse(s); double d1 = 0; try { d1 = (double)drw1["y" + s]; } catch { } try { dd = (double)drw1["y" + (y1 - 1)]; } catch { } double sss = Math.Round(Math.Pow(d1 / dd, 1.0 / 1) - 1, 4); sss *= 100; if (sss.ToString() == "非数字" || sss.ToString() == "正无穷大") { sss = 0; } drw1["n" + s] = sss; } } } this.gridControl1.DataSource = dt; }
/// <summary> /// 设置左侧标题,写入数据 /// </summary> /// <param name="obj"></param> private void SetLeftTitle(Itop.Client.Base.FormBase FB, FarPoint.Win.Spread.SheetView obj, int IntRow) { int temp = 1; Ps_History ph = null; SelectData(FB); obj.RowCount = list.Count + IntRow; for (int i = IntRow; i < obj.RowCount; ++i) { ph = (Ps_History)list[i - IntRow]; for (int j = 0; j < obj.ColumnCount; ++j) { switch (j) { case 0: //序号 if (i != obj.RowCount - 1) { obj.SetValue(i, j, temp); } else { obj.SetValue(i, j, "合计"); } break; case 1: //项目名称 if (i != obj.RowCount - 1) { obj.SetValue(i, j, ph.Title); } break; case 2: //项目性质 if (i != obj.RowCount - 1) { obj.SetValue(i, j, ph.Col13); } break; case 3: //计划开工时间 if (i != obj.RowCount - 1) { obj.SetValue(i, j, ph.Col11.Substring(0, 5)); } break; case 4: //计划投产时间 if (i != obj.RowCount - 1) { obj.SetValue(i, j, ph.Col12.Substring(0, 5)); } break; case 5: //用电量 if (i != obj.RowCount - 1) { obj.SetValue(i, j, ph.y1990); } else { obj.Cells[i, j].Formula = "Sum(F" + (1 + IntRow) + ":F" + i + ")"; obj.Cells[i, j].CellType = PC; } break; case 6: //最大用电负荷 if (i != obj.RowCount - 1) { obj.SetValue(i, j, ph.y1991); } else { obj.Cells[i, j].Formula = "Sum(G" + (IntRow + 1) + ":G" + i + ")"; obj.Cells[i, j].CellType = PC; } break; case 7: //所属分区 if (i != obj.RowCount - 1) { obj.SetValue(i, j, ReturnArea(FB, ph.Title)); } break; case 8: //备注 if (i != obj.RowCount - 1) { obj.SetValue(i, j, ph.Col6); } break; default: break; } } temp++; } PF.Sheet_GridandCenter(obj);//画边线,居中 }
/// <summary> /// 写入数据 /// </summary> /// <param name="FB"></param> /// <param name="obj"></param> private void WriteData(Itop.Client.Base.FormBase FB, FarPoint.Win.Spread.SheetView obj, int IntRow) { string strRowTitle = null; string strColTitle = null; Ps_History ps1 = null; //全社会用电总计 Ps_History ps2 = null; //全行业用电合计 Ps_History ps3 = null; //全行业用电分类 ps1 = ReturnStrID(FB, "全社会用电量(亿kWh)"); //全社会用电总计 ps2 = ReturnStrID(FB, "全行业用电合计"); //全行业用电合计 ps3 = ReturnStrID(FB, "全行业用电分类"); //全行业用电分类 for (int i = IntRow; i < obj.RowCount; ++i) { strRowTitle = PF.ReturnStr(obj, (i), 1).ToString(); for (int j = 2; j < obj.ColumnCount; ++j) { strColTitle = obj.GetValue((4), j).ToString(); if (strColTitle == "“十五”年均增长率" || strColTitle == "“十一五”年均增长率" || strColTitle == "“十二五”年均增长率" || strColTitle == "“十三五”年均增长率") { if (strColTitle == "“十五”年均增长率") { if (strRowTitle != "所占百分比(%)") { obj.Cells[i, j].Formula = "POWER(" + PF.GetColumnTitle(j - 1) + (i + 1) + "/" + PF.GetColumnTitle(j - 6) + (i + 1) + ",1/5)-1"; } } else { obj.Cells[i, j].Formula = "POWER(" + PF.GetColumnTitle(j - 1) + (i + 1) + "/" + PF.GetColumnTitle(j - 5) + (i + 1) + ",1/5)-1"; } obj.Cells[i, j].CellType = PC;//% } else { if (strRowTitle == "所占百分比(%)") { obj.Cells[i, j].Formula = PF.GetColumnTitle(j) + (i) + "/" + PF.GetColumnTitle(j) + (8); obj.Cells[i, j].CellType = PC;//% } else if (strRowTitle == "合计") { obj.Cells[i, j].Formula = "SUM(" + PF.GetColumnTitle(j) + (14) + "," + PF.GetColumnTitle(j) + (16) + "," + PF.GetColumnTitle(j) + (18) + "," + PF.GetColumnTitle(j) + (20) + "," + PF.GetColumnTitle(j) + (22) + "," + PF.GetColumnTitle(j) + (24) + "," + PF.GetColumnTitle(j) + (26) + "," + PF.GetColumnTitle(j) + (28) + ")"; } else if (strRowTitle == "公共事业及管理组织") { obj.Cells[i, j].Formula = PF.GetColumnTitle(j) + (8) + "-" + PF.GetColumnTitle(j) + (14) + "-" + PF.GetColumnTitle(j) + (16) + "-" + PF.GetColumnTitle(j) + (18) + "-" + PF.GetColumnTitle(j) + (20) + "-" + PF.GetColumnTitle(j) + (22) + "-" + PF.GetColumnTitle(j) + (24) + "-" + PF.GetColumnTitle(j) + (26); } else { obj.SetValue(i, j, SelectCurrentData(FB, strColTitle, strRowTitle, ps1, ps2, ps3)); } } } } }
private bool InsertdataHistory(InDataClass idc, string filename) { bool result = false; string columnname = ""; DealTreelist(idc); DataTable dts = GetExcel(filename); IList <Ps_History> lii = new List <Ps_History>(); DateTime s8 = DateTime.Now; int x = 0; WaitDialogForm wait = new WaitDialogForm("", "正在导入" + idc.Name + "数据, 请稍候..."); try { for (int i = 0; i < dts.Rows.Count; i++) { this.Cursor = Cursors.WaitCursor; Ps_History l1 = new Ps_History(); foreach (DataColumn dc in dts.Columns) { columnname = dc.ColumnName; if (dts.Rows[i][dc.ColumnName].ToString() == "") { continue; } switch (l1.GetType().GetProperty(dc.ColumnName).PropertyType.Name) { case "Double": if (dts.Rows[i][dc.ColumnName] == null || dts.Rows[i][dc.ColumnName] == DBNull.Value || dts.Rows[i][dc.ColumnName].ToString() == "") { l1.GetType().GetProperty(dc.ColumnName).SetValue(l1, 0, null); break; } l1.GetType().GetProperty(dc.ColumnName).SetValue(l1, Convert.ToDouble(dts.Rows[i][dc.ColumnName]), null); break; case "Int32": if (dts.Rows[i][dc.ColumnName] == null || dts.Rows[i][dc.ColumnName] == DBNull.Value || dts.Rows[i][dc.ColumnName].ToString() == "") { l1.GetType().GetProperty(dc.ColumnName).SetValue(l1, 0, null); break; } l1.GetType().GetProperty(dc.ColumnName).SetValue(l1, Convert.ToInt32(dts.Rows[i][dc.ColumnName]), null); break; default: l1.GetType().GetProperty(dc.ColumnName).SetValue(l1, dts.Rows[i][dc.ColumnName], null); break; } } l1.Forecast = idc.IType; l1.Col4 = ProjectUID; l1.ForecastID = idc.SType; lii.Add(l1); } int parenti = -4; Ps_History psl1; for (int i = 0; i < lii.Count; i++) { psl1 = lii[i]; psl1.Sort = i; string con = "Col4='" + ProjectUID + "' and Title='" + psl1.Title + "' and Forecast='" + idc.SType + "' and ParentID='" + psl1.ParentID + "'"; object obj = Services.BaseService.GetObject("SelectPs_HistoryByCondition", con); if (obj != null) { psl1.ID = ((Ps_History)obj).ID; if (psl1.ParentID.Contains("-")) { psl1.ParentID = ((Ps_History)obj).ParentID; } Services.BaseService.Update <Ps_History>(psl1); } else { psl1.ID = Guid.NewGuid().ToString() + "|" + ProjectUID; Services.BaseService.Create <Ps_History>(psl1); } for (int j = i + 1; j < lii.Count; j++) { if (lii[j].ParentID == parenti.ToString()) { lii[j].ParentID = psl1.ID; } } parenti--; } DealTreelist(idc); wait.Close(); wait = new WaitDialogForm("", "正在重新计算" + idc.Name + "数据, 请稍候..."); for (int i = 0; i < lii.Count; i++) { TreeListNode nd = treeList1.FindNodeByKeyID(lii[i].ID); if (nd != null) { foreach (TreeListColumn tr in treeList1.Columns) { if (tr.FieldName.IndexOf("y") >= 0) { CalculateSum(nd, tr); } } } } this.Cursor = Cursors.Default; wait.Caption = "已成功导入" + idc.Name + "数据!"; wait.Close(); result = true; return(result); } catch (Exception ex) { this.Cursor = Cursors.Default; wait.Close(); MsgBox.Show(columnname + ex.Message); MsgBox.Show("导入格式不正确!"); return(result); } }
private void RefreshChart() { IList <FORBaseColor> list = Services.BaseService.GetList <FORBaseColor>("SelectFORBaseColorByWhere", "Remark='电力发展实绩-" + Itop.Client.MIS.ProgUID + "-1'"); IList <FORBaseColor> li = new List <FORBaseColor>(); bool bl = false; ArrayList ht = new ArrayList(); ht.Add(Color.Red); ht.Add(Color.Blue); ht.Add(Color.Green); ht.Add(Color.Yellow); ht.Add(Color.HotPink); ht.Add(Color.LawnGreen); ht.Add(Color.Khaki); ht.Add(Color.LightSlateGray); ht.Add(Color.LightSeaGreen); ht.Add(Color.Lime); ArrayList hs = new ArrayList(); int m = 0; ArrayList aldatablr = new ArrayList(); foreach (DataRow row in dataTable.Rows) { aldatablr.Add(row["ID"].ToString()); } foreach (DataRow row in dataTable.Rows) { if (aldatablr.Contains(row["ParentID"].ToString())) { continue; } bl = false; foreach (FORBaseColor bc in list) { if (row["Title"].ToString() == bc.Title) { m++; bl = true; FORBaseColor bc1 = new FORBaseColor(); Color cl = (Color)ht[m % 10]; bc1.Color1 = cl; //bc1.Color = cl.ToArgb(); //bc1.Color1 = Color.Blue; ////bc1.Color = 0; ////bc1.Color1 = bc.Color1; //bc1.Color1 = ColorTranslator.FromOle(bc.Color); //CopyBaseColor(bc1, bc); li.Add(bc1); } } if (!bl) { FORBaseColor bc1 = new FORBaseColor(); bc1.UID = Guid.NewGuid().ToString(); //bc1.Remark = "电力发展实绩" + "-" + ProjectUID + "-0"; bc1.Remark = "电力发展实绩-" + Itop.Client.MIS.ProgUID + "-1"; bc1.Title = row["Title"].ToString(); //bc1.Color = 16711680; //bc1.Color1 = Color.Blue; Color cl = (Color)ht[m % 10]; bc1.Color = 0; bc1.Color1 = Color.Black; Services.BaseService.Create <FORBaseColor>(bc1); li.Add(bc1); m++; } } foreach (FORBaseColor bc2 in li) { //bc2.Color1 = Color.Black; hs.Add(bc2.Color1); } List <Ps_History> listValues = new List <Ps_History>(); for (int i = 0; i < treeList1.Nodes.Count; i++) { TreeListNode row = treeList1.Nodes[i]; foreach (TreeListColumn col in treeList1.Columns) { if (col.FieldName.IndexOf("y") > -1) { object obj = row[col.FieldName]; if (obj != DBNull.Value) { Ps_History v = new Ps_History(); v.ForecastID = type1; v.ID = (string)row["ID"]; v.Title = (i + 1).ToString() + "." + row["Title"].ToString(); v.Sort = Convert.ToInt32(col.FieldName.Replace("y", "")); v.y1990 = (double)row[col.FieldName]; listValues.Add(v); } } } } chart1.Series.Clear(); chart1.DataBindCrossTab(listValues, "Title", "Sort", "y1990", ""); for (int i = 0; i < chart1.Series.Count; i++) { //chart1.Series[i].Color = (Color)hs[i]; //chart1.Series[i].Name = (i + 1).ToString() + "." + chart1.Series[i].Name; //chart1.Series[i].Type = Dundas.Charting.WinControl.SeriesChartType.Line; //chart1.Series[i].MarkerSize = 7; //chart1.Series[i].MarkerStyle = (Dundas.Charting.WinControl.MarkerStyle)(2); chart1.Series[i].Color = (Color)hs[i]; chart1.Series[i].Name = chart1.Series[i].Name; chart1.Series[i].Type = Dundas.Charting.WinControl.SeriesChartType.Line; chart1.Series[i].MarkerSize = 7; chart1.Series[i].MarkerStyle = (Dundas.Charting.WinControl.MarkerStyle)(2); //chart1.Series[i].XValueIndexed = true; } }
//此处为动态添加数据方法 private void Sheet_AddData(FarPoint.Win.Spread.SheetView obj_sheet) { int[] TableYearsAry = TC.GetTableYears(this.GetType().Name); int startrow = 2; int itemlength = 9; string sqlwhere = " ProjectID='" + Tcommon.ProjectID + "'"; IList <PS_Table_AreaWH> ptalist = Services.BaseService.GetList <PS_Table_AreaWH>("SelectPS_Table_AreaWHByConn", sqlwhere); //重新设定行数 obj_sheet.RowCount = startrow + (ptalist.Count + 1) * itemlength; string sqlwheretemp = " ForecastID='4' and Col4='" + Tcommon.ProjectID + "'"; IList phlisttemp = Services.BaseService.GetList("SelectPs_HistoryBYconnstr", sqlwheretemp); DataTable dttemp = DataConverter.ToDataTable(phlisttemp, typeof(Ps_History)); Ps_History AllRk = new Ps_History(); Ps_History CZrk = new Ps_History(); DataRow RowAllrk = dttemp.NewRow();; DataRow RowCZrk = dttemp.NewRow(); RowAllrk = DataConverter.ObjectToRow(AllRk, RowAllrk); RowCZrk = DataConverter.ObjectToRow(CZrk, RowCZrk); for (int i = 0; i < ptalist.Count; i++) { AddItems(obj_sheet, ptalist[i].Title, startrow + i * itemlength); string sqlwhere2 = " ForecastID='4' and Col4='" + Tcommon.ProjectID + "' and Title='" + ptalist[i].Title + "'"; IList <Ps_History> phlist = Services.BaseService.GetList <Ps_History>("SelectPs_HistoryBYconnstr", sqlwhere2); if (phlist.Count > 0) { string sqlwhere3 = " ForecastID='4' and Col4='" + Tcommon.ProjectID + "' and ParentID='" + phlist[0].ID + "'"; IList phlist3 = Services.BaseService.GetList("SelectPs_HistoryBYconnstr", sqlwhere3); DataTable dt = DataConverter.ToDataTable(phlist3, typeof(Ps_History)); DataRow[] rows1 = dt.Select("Title like '一产%'"); DataRow[] rows2 = dt.Select("Title like '二产%'"); DataRow[] rows3 = dt.Select("Title like '三产%'"); DataRow[] rows4 = dt.Select("Title like '人口%'"); DataRow[] rows7 = null; DataRow[] rows8 = null; if (rows4.Length != 0) { string sqlwhere4 = " ForecastID='4' and Col4='" + Tcommon.ProjectID + "' and ParentID='" + rows4[0]["ID"] + "'"; IList phlist4 = Services.BaseService.GetList("SelectPs_HistoryBYconnstr", sqlwhere4); DataTable dt2 = DataConverter.ToDataTable(phlist4, typeof(Ps_History)); rows7 = dt2.Select("Title like '城镇人口%'"); rows8 = dt2.Select("Title like '乡村人口%'"); } DataRow[] rows5 = dt.Select("Title like '行政面积%'"); DataRow[] rows6 = dt.Select("Title like '建成区面积%'"); //国内生产总值(亿元)=一产+二产+三产 TC.Sheet_WriteFormula_RowSum(obj_sheet, startrow + i * itemlength + 1, 2, 3, 1, startrow + i * itemlength, 2, TableYearsAry.Length); //人均GDP(万元)=国内生产总值(亿元)/人口; TC.Sheet_WriteFormula_OneRow_AnoterRow_nopercent(obj_sheet, startrow + i * itemlength + 4, 2, startrow + i * itemlength, startrow + i * itemlength + 5, TableYearsAry.Length); for (int j = 0; j < TableYearsAry.Length; j++) { int m = 0; //一产 string yearstr = "y" + TableYearsAry[j].ToString(); m++; if (rows1.Length != 0) { obj_sheet.SetValue(startrow + i * itemlength + m, 2 + j, rows1[0][yearstr]); } else { TC.WriteQuestion(title, ptalist[i].Title + "无一产数据", "查询 分区供电实绩,看是否有该区一产数据", ""); } //二产 m++; if (rows2.Length != 0) { obj_sheet.SetValue(startrow + i * itemlength + m, 2 + j, rows2[0][yearstr]); } else { TC.WriteQuestion(title, ptalist[i].Title + "无二产数据", "查询 分区供电实绩,看是否有该区二产数据", ""); } //三产 m++; if (rows3.Length != 0) { obj_sheet.SetValue(startrow + i * itemlength + m, 2 + j, rows3[0][yearstr]); } else { TC.WriteQuestion(title, ptalist[i].Title + "无三产数据", "查询 分区供电实绩,看是否有该区三产数据", ""); } //人口 m++; if (rows4.Length != 0) { obj_sheet.SetValue(startrow + i * itemlength + m, 2 + j, rows4[0][yearstr]); } else { TC.WriteQuestion(title, ptalist[i].Title + "无人口数据", "查询 分区供电实绩,看是否有该区人口数据", ""); } m++; //行政面积(平方千米) m++; if (rows5.Length != 0) { obj_sheet.SetValue(startrow + i * itemlength + m, 2 + j, rows5[0][yearstr]); } else { TC.WriteQuestion(title, ptalist[i].Title + "无行政面积数据", "查询 分区供电实绩,看是否有该区行政面积数据", ""); } //建成区面积(平方千米) m++; if (rows6.Length != 0) { obj_sheet.SetValue(startrow + i * itemlength + m, 2 + j, rows6[0][yearstr]); } else { TC.WriteQuestion(title, ptalist[i].Title + "无建成区面积数据", "查询 分区供电实绩,看是否有该区建成区面积数据", ""); } //城镇化率(%) m++; if (rows7 != null && rows4.Length != 0) { obj_sheet.SetValue(startrow + i * itemlength + m, 2 + j, Convert.ToDouble(rows7[0][yearstr]) / Convert.ToDouble(rows4[0][yearstr])); FarPoint.Win.Spread.CellType.PercentCellType newcelltype = new FarPoint.Win.Spread.CellType.PercentCellType(); newcelltype.DecimalPlaces = 2; obj_sheet.Cells[startrow + i * itemlength + m, 2 + j].CellType = newcelltype; RowAllrk[yearstr] = Convert.ToDouble(RowAllrk[yearstr]) + Convert.ToDouble(rows4[0][yearstr]); RowCZrk[yearstr] = Convert.ToDouble(RowCZrk[yearstr]) + Convert.ToDouble(rows7[0][yearstr]); } else { TC.WriteQuestion(title, ptalist[i].Title + "无城镇人口或总人口数据", "查询 分区供电实绩,看是否有该区城镇人口或总人口数据", ""); } } } } AddItems(obj_sheet, "全市", startrow + ptalist.Count * itemlength); TC.Sheet_WriteFormula_RowSum2(obj_sheet, startrow, 2, ptalist.Count, itemlength, startrow + ptalist.Count * itemlength, 2, 1, 3, TableYearsAry.Length); TC.Sheet_WriteFormula_RowSum2(obj_sheet, startrow, 2, ptalist.Count, itemlength, startrow + ptalist.Count * itemlength, 2, 6, 2, TableYearsAry.Length); //国内生产总值(亿元)=一产+二产+三产 TC.Sheet_WriteFormula_RowSum(obj_sheet, startrow + ptalist.Count * itemlength + 1, 2, 3, 1, startrow + ptalist.Count * itemlength, 2, TableYearsAry.Length); //人均GDP(万元)=国内生产总值(亿元)/人口; TC.Sheet_WriteFormula_OneRow_AnoterRow_nopercent(obj_sheet, startrow + ptalist.Count * itemlength + 4, 2, startrow + ptalist.Count * itemlength, startrow + ptalist.Count * itemlength + 5, TableYearsAry.Length); //最后城镇化率 for (int k = 0; k < TableYearsAry.Length; k++) { string yearstr = "y" + TableYearsAry[k].ToString(); obj_sheet.SetValue(startrow + ptalist.Count * itemlength + 8, 2 + k, Convert.ToDouble(RowCZrk[yearstr]) / Convert.ToDouble(RowAllrk[yearstr])); FarPoint.Win.Spread.CellType.PercentCellType newcelltype = new FarPoint.Win.Spread.CellType.PercentCellType(); newcelltype.DecimalPlaces = 2; obj_sheet.Cells[startrow + ptalist.Count * itemlength + 8, 2 + k].CellType = newcelltype; } //几何年平均增长率 for (int l = 0; l < (ptalist.Count + 1) * itemlength; l++) { obj_sheet.Cells[startrow + l, 2 + TableYearsAry.Length].Formula = " Power(R" + (startrow + l + 1) + "C" + (2 + TableYearsAry.Length) + "/R" + (startrow + l + 1) + "C" + 3 + "," + (1.000 / TableYearsAry.Length) + ")-1"; FarPoint.Win.Spread.CellType.PercentCellType newcelltype = new FarPoint.Win.Spread.CellType.PercentCellType(); newcelltype.DecimalPlaces = 2; obj_sheet.Cells[startrow + l, 2 + TableYearsAry.Length].CellType = newcelltype; } }
private void barButtonItem2_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { TreeListMultiSelection tm = treeList1.Selection; if (tm.Count == 0) { return; } DataRow dr = this.gridView1.GetDataRow(this.gridView1.FocusedRowHandle); if (dr == null) { return; } int id1 = (int)dr["ID"]; hs.Clear(); li.Clear(); if (Flag == "1")//旧版分区县供电实绩 { if (id1 != 4) { foreach (TreeListNode tln in tm) { Ps_History pt1 = new Ps_History(); Ps_History pt = Services.BaseService.GetOneByKey <Ps_History>((string)tln["ID"]); if (tln["Title"].ToString() == "常规用电量" || tln["Title"].ToString() == "常规负荷") { pt.Title = pt.Title + "-" + tln.ParentNode["Title"]; } else if (!tln["Title"].ToString().Contains("电量") && !tln["Title"].ToString().Contains("负荷")) { if (id1 == 2) { pt.Title = pt.Title + "电量"; } else if (id1 == 3) { pt.Title = pt.Title + "负荷"; } } if (!hs.ContainsValue(pt)) { hs.Add(Guid.NewGuid().ToString(), pt); } } } else { foreach (TreeListNode tln in tm) { PSP_Types pt = Services.BaseService.GetOneByKey <PSP_Types>((int)tln["ID"]); if (!hs.ContainsValue(pt)) { hs.Add(Guid.NewGuid().ToString(), pt); } } } } else//新版分区县供电实绩 { foreach (TreeListNode tln in tm) { Ps_History pt1 = new Ps_History(); Ps_History pt = Services.BaseService.GetOneByKey <Ps_History>((string)tln["ID"]); if (tln["Title"].ToString() == "常规用电量" || tln["Title"].ToString() == "常规负荷") { pt.Title = pt.Title + "-" + tln.ParentNode["Title"]; } else if (!tln["Title"].ToString().Contains("电量") && !tln["Title"].ToString().Contains("负荷")) { if (id1 == 2) { pt.Title = pt.Title + "电量"; } else if (id1 == 3) { pt.Title = pt.Title + "负荷"; } } if (!hs.ContainsValue(pt)) { hs.Add(Guid.NewGuid().ToString(), pt); } } } if (hs.Count > 0) { this.DialogResult = DialogResult.OK; } }
private void InitData() { Ps_YearRange py = new Ps_YearRange(); py.Col4 = yearflag; py.Col5 = projectUID; IList <Ps_YearRange> li = Itop.Client.Common.Services.BaseService.GetList <Ps_YearRange>("SelectPs_YearRangeByCol5andCol4", py); if (li.Count > 0) { firstyear = li[0].StartYear; endyear = li[0].FinishYear; } else { firstyear = 2000; endyear = 2008; py.BeginYear = 1990; py.FinishYear = endyear; py.StartYear = firstyear; py.EndYear = 2060; py.ID = Guid.NewGuid().ToString(); Itop.Client.Common.Services.BaseService.Create <Ps_YearRange>(py); } DataTable dt = new DataTable(); dt.Columns.Add("ID"); dt.Columns.Add("Title"); Ps_History psp_Type = new Ps_History(); psp_Type.Forecast = pstype; psp_Type.Col4 = projectUID; IList <Ps_History> listTypes = Common.Services.BaseService.GetList <Ps_History>("SelectPs_HistoryByForecast", psp_Type); DataTable dataTable = Itop.Common.DataConverter.ToDataTable((IList)listTypes, typeof(Ps_History)); DataRow[] rows1 = dataTable.Select("Title like '全社会用电量%'"); if (rows1.Length == 0) { MessageBox.Show("缺少‘全社会用电量’ 数据,无法进行统计!"); this.Close(); return; } string pid = rows1[0]["ID"].ToString(); string tempTite = rows1[0]["Title"].ToString(); //取出标题中的单位 Untis = Historytool.FindUnits(tempTite); DataRow[] rows3 = dataTable.Select("ParentID='" + pid + "'"); if (rows3.Length == 0) { MessageBox.Show("缺少‘全社会用电量’下的分行业用电数据,无法进行统计!"); this.Close(); return; } int m = -1; for (int i = firstyear; i <= endyear; i++) { if (!ht.ContainsValue(i)) { continue; } m++; dt.Columns.Add("y" + i, typeof(double)); dt.Columns.Add("n" + i, typeof(double)); GridBand gb = new GridBand(); gb.Caption = i + "年"; gb.AppearanceHeader.Options.UseTextOptions = true; gb.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center; this.bandedGridView1.Bands.Add(gb); GridBand gb1 = new GridBand(); if (Untis.Length > 0) { gb1.Caption = "用电量(" + Untis + ")"; } else { gb1.Caption = "用电量"; } gb1.AppearanceHeader.Options.UseTextOptions = true; gb1.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center; gb.Children.Add(gb1); GridBand gb2 = new GridBand(); gb2.Caption = "百分比"; gb2.AppearanceHeader.Options.UseTextOptions = true; gb2.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center; gb.Children.Add(gb2); BandedGridColumn gridColumn = new BandedGridColumn(); gridColumn.Caption = i + "年用电量"; gridColumn.FieldName = "y" + i; gridColumn.Visible = true; gridColumn.VisibleIndex = 2 * m + 10; gridColumn.DisplayFormat.FormatString = "n2"; gridColumn.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric; gridColumn.Width = 95; gb1.Columns.Add(gridColumn); BandedGridColumn gridColumn1 = new BandedGridColumn(); gridColumn1.Caption = i + "年百分比"; gridColumn1.FieldName = "n" + i; gridColumn1.Visible = true; gridColumn1.VisibleIndex = 2 * m + 11; gridColumn1.DisplayFormat.FormatString = "n2"; gridColumn1.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric; gridColumn1.Width = 80; gb2.Columns.Add(gridColumn1); } double sum = 0; try { sum = Convert.ToDouble(rows1[0]["y" + firstyear]); } catch { } DataRow row1 = dt.NewRow(); row1["ID"] = Guid.NewGuid().ToString(); row1["Title"] = "用电量总计"; //rows1[0]["Title"].ToString(); for (int k = 0; k < rows3.Length; k++) { DataRow row = dt.NewRow(); row["ID"] = Guid.NewGuid().ToString(); row["Title"] = rows3[k]["Title"].ToString(); for (int j = firstyear; j <= endyear; j++) { if (!ht.ContainsValue(j)) { continue; } sum = 0; try { sum = Convert.ToDouble(rows1[0]["y" + j]); } catch { } row1["y" + j] = sum; row1["n" + j] = 1; double sum1 = 0; double sum2 = 0; try { sum1 = Convert.ToDouble(rows3[k]["y" + j]); } catch { } row["y" + j] = sum1; if (sum != 0) { sum2 = sum1 / sum; } row["n" + j] = sum2; } dt.Rows.Add(row); } dt.Rows.Add(row1); this.gridControl1.DataSource = dt; }
private void InitData() { Ps_YearRange py = new Ps_YearRange(); py.Col4 = yearflag; py.Col5 = projectUID; IList <Ps_YearRange> li = Itop.Client.Common.Services.BaseService.GetList <Ps_YearRange>("SelectPs_YearRangeByCol5andCol4", py); if (li.Count > 0) { firstyear = li[0].StartYear; endyear = li[0].FinishYear; } else { firstyear = 1990; endyear = 2020; py.BeginYear = 1990; py.FinishYear = endyear; py.StartYear = firstyear; py.EndYear = 2060; py.ID = Guid.NewGuid().ToString(); Itop.Client.Common.Services.BaseService.Create <Ps_YearRange>(py); } DataTable dt = new DataTable(); dt.Columns.Add("ID"); dt.Columns.Add("Title"); Ps_History psp_Type = new Ps_History(); psp_Type.Forecast = pstype; psp_Type.Col4 = projectUID; IList <Ps_History> listTypes = Common.Services.BaseService.GetList <Ps_History>("SelectPs_HistoryByForecast", psp_Type); DataTable dataTable = Itop.Common.DataConverter.ToDataTable((IList)listTypes, typeof(Ps_History)); int m = -1; this.gridControl1.BeginInit(); this.gridControl1.BeginUpdate(); bool isfirst = true; for (int i = firstyear; i <= endyear; i++) { if (!ht.ContainsValue(i)) { continue; } if (IsFist) { RealFistYear = i; IsFist = false; } m++; GridColumn gridColumn = new GridColumn(); gridColumn.Caption = i + "年"; gridColumn.FieldName = "y" + i; gridColumn.Visible = true; gridColumn.VisibleIndex = 2 * m + 10; gridColumn.Width = 70; gridColumn.DisplayFormat.FormatString = "n2"; gridColumn.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric; gridView1.Columns.Add(gridColumn); if (ht1.ContainsValue(i)) { if (isfirst) { isfirst = false; } else { gridColumn = new GridColumn(); gridColumn.Caption = "年均增长率(%)"; gridColumn.FieldName = "mm" + i; gridColumn.Visible = true; gridColumn.Width = 130; gridColumn.VisibleIndex = 2 * m + 11; gridColumn.DisplayFormat.FormatString = "n2"; gridColumn.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric; gridView1.Columns.Add(gridColumn); dataTable.Columns.Add("mm" + i, typeof(double)); } } if (ht2.ContainsValue(i)) { gridColumn = new GridColumn(); gridColumn.Caption = "逐年增长率(%)"; gridColumn.FieldName = "nn" + i; gridColumn.Visible = true; gridColumn.Width = 130; gridColumn.VisibleIndex = 2 * m + 12; gridColumn.DisplayFormat.FormatString = "n2"; gridColumn.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric; gridView1.Columns.Add(gridColumn); dataTable.Columns.Add("nn" + i, typeof(double)); } } this.gridControl1.EndUpdate(); this.gridControl1.EndInit(); double d = 0; //年均增长率 foreach (DataRow drw1 in dataTable.Rows) { foreach (DataColumn dc in dataTable.Columns) { if (dc.ColumnName.IndexOf("mm") >= 0) { string s = dc.ColumnName.Replace("mm", ""); int y1 = int.Parse(s); double d1 = 0; try { d1 = (double)drw1["y" + s]; } catch { } int peryear = 0; for (int i = y1 - 1; i > 0; i--) { if (ht1.ContainsValue(i)) { peryear = i; break; } } try { d = (double)drw1["y" + peryear]; } catch { } double sss = Math.Round(Math.Pow(d1 / d, 1.0 / (y1 - peryear)) - 1, 4); sss *= 100; if (sss.ToString() == "非数字" || sss.ToString() == "正无穷大") { sss = 0; } drw1["mm" + s] = sss; } } } //逐年增长率 double dd = 0; foreach (DataRow drw1 in dataTable.Rows) { foreach (DataColumn dc in dataTable.Columns) { if (dc.ColumnName.IndexOf("nn") >= 0) { string s = dc.ColumnName.Replace("nn", ""); int y1 = int.Parse(s); double d1 = 0; try { d1 = (double)drw1["y" + s]; } catch { } try { dd = (double)drw1["y" + (y1 - 1)]; } catch { } double sss = Math.Round(Math.Pow(d1 / dd, 1.0 / 1) - 1, 4); sss *= 100; if (sss.ToString() == "非数字" || sss.ToString() == "正无穷大") { sss = 0; } drw1["nn" + s] = sss; } } } this.gridControl1.DataSource = dataTable; }
//设置GDP值 private void simpleButton7_Click(object sender, EventArgs e) { FormSetGDP frm = new FormSetGDP(); frm.forecastReport = forecastReport; frm.Text = "设置GDP值"; frm.type = type; DataRow[] rowsoldGDP = dataTable.Select("Title like '全地区GDP%'"); if (frm.ShowDialog() == DialogResult.OK) { if (frm.GetGDP) { //读取GDP历史值 if (rowsoldGDP.Length > 0) { DataRow oldrow = rowsoldGDP[0]; //新经济数据 Ps_History psp_Type = new Ps_History(); psp_Type.Forecast = 5; psp_Type.Col4 = Itop.Client.MIS.ProgUID; IList <Ps_History> listTypes = Common.Services.BaseService.GetList <Ps_History>("SelectPs_HistoryByForecast", psp_Type); DataTable dataTable2 = Itop.Common.DataConverter.ToDataTable((IList)listTypes, typeof(Ps_History)); DataRow[] rows1 = dataTable2.Select("Title like '全地区GDP%'"); for (int i = forecastReport.StartYear; i <= forecastReport.EndYear; i++) { double s1 = 0; try { s1 = Convert.ToDouble(rows1[0]["y" + i]); } catch { } oldrow["y" + i] = s1; commonhelp.ResetValue(oldrow["ID"].ToString(), "y" + i); } Ps_Forecast_Math pfm = DataConverter.RowToObject <Ps_Forecast_Math>(oldrow); Services.BaseService.Update <Ps_Forecast_Math>(pfm); } } DataRow[] rowsgdp = dataTable.Select("Title like '全地区GDP%'"); if (rowsgdp.Length > 0) { DataRow oldrow = rowsgdp[0]; Ps_Calc pcs = new Ps_Calc(); pcs.Forecast = type; pcs.ForecastID = forecastReport.ID; IList <Ps_Calc> list1 = Services.BaseService.GetList <Ps_Calc>("SelectPs_CalcByForecast", pcs); Hashtable hs = new Hashtable(); foreach (Ps_Calc pcl1 in list1) { if (!hs.ContainsKey(pcl1.Year)) { hs.Add(pcl1.Year, pcl1.Value2); } } for (int j = forecastReport.YcStartYear; j <= forecastReport.YcEndYear; j++) { double increasenum = double.Parse(hs[j].ToString()); double basenum = double.Parse(oldrow["y" + (j - 1)].ToString()); oldrow["y" + j] = basenum * (1 + increasenum); } Ps_Forecast_Math pfm = DataConverter.RowToObject <Ps_Forecast_Math>(oldrow); Services.BaseService.Update <Ps_Forecast_Math>(pfm); } JS(); } }
private void FormForecastCalcTX_Load(object sender, EventArgs e) { #region 电力发展实绩 ArrayList al = new ArrayList(); IList <Base_Data> li1 = Common.Services.BaseService.GetStrongList <Base_Data>(); foreach (Base_Data bd in li1) { al.Add(bd.Title); } Ps_History psp_Type1 = new Ps_History(); psp_Type1.Forecast = 1; psp_Type1.Col4 = Itop.Client.MIS.ProgUID; IList <Ps_History> listTypes1 = Common.Services.BaseService.GetList <Ps_History>("SelectPs_HistoryByForecast", psp_Type1); for (int c = 0; c < al.Count; c++) { bool bl = true; foreach (Ps_History ph in listTypes1) { if (al[c].ToString() == ph.Title) { bl = false; } } if (bl) { Ps_History pf = new Ps_History(); pf.ID = Guid.NewGuid().ToString() + "|" + Itop.Client.MIS.ProgUID; pf.Forecast = 1; pf.ForecastID = "1"; pf.Title = al[c].ToString(); pf.Col4 = Itop.Client.MIS.ProgUID; Services.BaseService.Create <Ps_History>(pf); listTypes1.Add(pf); } } Ps_YearRange py = new Ps_YearRange(); py.Col4 = "电力发展实绩"; py.Col5 = Itop.Client.MIS.ProgUID; IList <Ps_YearRange> li2 = Services.BaseService.GetList <Ps_YearRange>("SelectPs_YearRangeByCol5andCol4", py); if (li2.Count > 0) { firstyear1 = li2[0].StartYear; endyear1 = li2[0].FinishYear; } Ps_History psp_Type = new Ps_History(); psp_Type.Forecast = 1; psp_Type.Col4 = Itop.Client.MIS.ProgUID; IList <Ps_History> listTypes = Common.Services.BaseService.GetList <Ps_History>("SelectPs_HistoryByForecast", psp_Type); DataTable dataTable = Itop.Common.DataConverter.ToDataTable((IList)listTypes, typeof(Ps_History)); DataRow[] rows1 = dataTable.Select("Title='全地区GDP(亿元)'"); DataRow[] rows4 = dataTable.Select("Title='全社会用电量(亿kWh)'"); #endregion Ps_Forecast_Setup pfs = new Ps_Forecast_Setup(); pfs.Forecast = type; pfs.ForecastID = forecastReport.ID; //IList<Ps_Forecast_Setup> li = Services.BaseService.GetList<Ps_Forecast_Setup>("SelectPs_Forecast_SetupByForecast", pfs); //if (li.Count != 0) //{ // firstyear = li[0].StartYear; // endyear = li[0].EndYear; //} Ps_Calc pcs = new Ps_Calc(); pcs.Forecast = type; pcs.ForecastID = forecastReport.ID; list1 = Services.BaseService.GetList <Ps_Calc>("SelectPs_CalcByForecast", pcs); HideToolBarButton(); dt = new DataTable(); dt.Columns.Add("ID"); dt.Columns.Add("Name"); newrow1 = dt.NewRow(); newrow1["ID"] = "ID"; newrow1["Name"] = "弹性系数"; newrow2 = dt.NewRow(); newrow2["Name"] = "GDP增长率"; for (int i = firstyear; i <= forecastReport.EndYear; i++) { dt.Columns.Add(i.ToString(), typeof(double)); DevExpress.XtraVerticalGrid.Rows.EditorRow editorRow = new DevExpress.XtraVerticalGrid.Rows.EditorRow(); editorRow.Properties.FieldName = i.ToString().Trim(); editorRow.Properties.Caption = i.ToString().Trim(); editorRow.Height = 20; editorRow.Properties.RowEdit = this.repositoryItemCalcEdit4; this.vGridControl2.Rows.AddRange(new DevExpress.XtraVerticalGrid.Rows.BaseRow[] { editorRow }); double s1 = 0; double s2 = 0; double s3 = 0; double s4 = 0; double s5 = 0; double s6 = 0; double s7 = 0; try { s1 = Convert.ToDouble(rows1[0]["y" + i]); } catch { } try { s2 = Convert.ToDouble(rows1[0]["y" + (i - 1)]); } catch { } try { s3 = Convert.ToDouble(rows4[0]["y" + i]); } catch { } try { s4 = Convert.ToDouble(rows4[0]["y" + (i - 1)]); } catch { } if (s2 != 0) { s5 = (s1 - s2) / s2; } if (s4 != 0) { s6 = (s3 - s4) / s4; } if (s5 != 0) { s7 = s6 / s5; } newrow1[i.ToString()] = Math.Round(s7, 3); newrow2[i.ToString()] = Math.Round(s5, 3); foreach (Ps_Calc pcs2 in list1) { if (i == pcs2.Year) { newrow1[i.ToString()] = Math.Round(pcs2.Value1, 3); newrow2[i.ToString()] = Math.Round(pcs2.Value2, 3); } } } dt.Rows.Add(newrow1); dt.Rows.Add(newrow2); vGridControl2.DataSource = dt; }
private void FormForecastCalc4_Load(object sender, EventArgs e) { #region 电力发展实绩 Ps_YearRange py = new Ps_YearRange(); py.Col4 = "电力发展实绩经济"; py.Col5 = Itop.Client.MIS.ProgUID; IList <Ps_YearRange> li2 = Services.BaseService.GetList <Ps_YearRange>("SelectPs_YearRangeByCol5andCol4", py); if (li2.Count > 0) { firstyear1 = li2[0].StartYear; endyear1 = li2[0].FinishYear; } //新经济数据 Ps_History psp_Type = new Ps_History(); psp_Type.Forecast = 5; psp_Type.Col4 = Itop.Client.MIS.ProgUID; IList <Ps_History> listTypes = Common.Services.BaseService.GetList <Ps_History>("SelectPs_HistoryByForecast", psp_Type); DataTable dataTable = Itop.Common.DataConverter.ToDataTable((IList)listTypes, typeof(Ps_History)); DataRow[] rows1 = dataTable.Select("Title like '全地区GDP%'"); //新电量数据 Ps_History psp_Type2 = new Ps_History(); psp_Type2.Forecast = 6; psp_Type2.Col4 = Itop.Client.MIS.ProgUID; IList <Ps_History> listTypes2 = Common.Services.BaseService.GetList <Ps_History>("SelectPs_HistoryByForecast", psp_Type2); DataTable dataTable2 = Itop.Common.DataConverter.ToDataTable((IList)listTypes2, typeof(Ps_History)); DataRow[] rows4 = dataTable2.Select("Title like '全社会用电量%'"); if (rows1.Length == 0 || rows4.Length == 0) { MessageBox.Show("经济数据中缺少‘全地区GDP’或电量数据中缺少‘全社会用电量’数据!"); this.Close(); return; } #endregion Ps_Forecast_Setup pfs = new Ps_Forecast_Setup(); pfs.Forecast = type; pfs.ForecastID = forecastReport.ID; IList <Ps_Forecast_Setup> li = Services.BaseService.GetList <Ps_Forecast_Setup>("SelectPs_Forecast_SetupByForecast", pfs); if (li.Count != 0) { firstyear = li[0].StartYear; endyear = li[0].EndYear; } Ps_Calc pcs = new Ps_Calc(); pcs.Forecast = type; pcs.ForecastID = forecastReport.ID; list1 = Services.BaseService.GetList <Ps_Calc>("SelectPs_CalcByForecast", pcs); HideToolBarButton(); dt = new DataTable(); dt.Columns.Add("ID"); dt.Columns.Add("Name"); newrow1 = dt.NewRow(); newrow1["ID"] = "ID"; newrow1["Name"] = "弹性系数"; newrow2 = dt.NewRow(); newrow2["Name"] = "GDP增长率"; for (int i = firstyear; i <= forecastReport.EndYear; i++) { dt.Columns.Add(i.ToString(), typeof(double)); DevExpress.XtraVerticalGrid.Rows.EditorRow editorRow = new DevExpress.XtraVerticalGrid.Rows.EditorRow(); editorRow.Properties.FieldName = i.ToString().Trim(); editorRow.Properties.Caption = i.ToString().Trim(); editorRow.Height = 20; editorRow.Properties.RowEdit = this.repositoryItemCalcEdit4; this.vGridControl2.Rows.AddRange(new DevExpress.XtraVerticalGrid.Rows.BaseRow[] { editorRow }); double s1 = 0; double s2 = 0; double s3 = 0; double s4 = 0; double s5 = 0; double s6 = 0; double s7 = 0; try { s1 = Convert.ToDouble(rows1[0]["y" + i]); } catch { } try { s2 = Convert.ToDouble(rows1[0]["y" + (i - 1)]); } catch { } try { s3 = Convert.ToDouble(rows4[0]["y" + i]); } catch { } try { s4 = Convert.ToDouble(rows4[0]["y" + (i - 1)]); } catch { } if (s2 != 0) { s5 = (s1 - s2) / s2; } if (s4 != 0) { s6 = (s3 - s4) / s4; } if (s5 != 0) { s7 = s6 / s5; } newrow1[i.ToString()] = Math.Round(s7, 3); newrow2[i.ToString()] = Math.Round(s5, 3); foreach (Ps_Calc pcs2 in list1) { if (i == pcs2.Year) { newrow1[i.ToString()] = Math.Round(pcs2.Value1, 3); newrow2[i.ToString()] = Math.Round(pcs2.Value2, 3); } } } dt.Rows.Add(newrow1); dt.Rows.Add(newrow2); // gridControl1.DataSource = dt; vGridControl2.DataSource = dt; }