public void SaveData(FarPoint.Win.Spread.SheetView obj_sheet)
{
save91_52list.Clear();
int startrow = 3+8;
int xjrow = fc.Sheet_Find_Value(obj_sheet, 0, "县级供电区");
for (int row = startrow; row < xjrow; row++)
{
SaveData9152 tempdata = new SaveData9152();
tempdata.DQ = "市辖供电区";
tempdata.AreaName = obj_sheet.Cells[row, 1].Value.ToString();
for (int i = 0; i < 8; i++)
{
for (int j = 0; j < 12; j++)
{
tempdata.data[i,j] = obj_sheet.GetValue(row + i,5 + j);
}
}
save91_52list.Add(tempdata);
row = row + 7;
}
for (int row = xjrow+8; row < obj_sheet.RowCount; row++)
{
SaveData9152 tempdata = new SaveData9152();
tempdata.DQ = "县级供电区";
tempdata.AreaName = obj_sheet.Cells[row, 1].Value.ToString();
for (int i = 0; i < 8; i++)
{
for (int j = 0; j < 12; j++)
{
tempdata.data[i,j] = obj_sheet.GetValue(row + i,5 + j);
}
}
save91_52list.Add(tempdata);
row = row + 7;
}
}
public void SaveData(FarPoint.Win.Spread.SheetView obj_sheet)
{
//清空存放数据列表
SDL318_19.Clear();
//市辖部分的行号
int SXrow = fc.Sheet_Find_Value(obj_sheet, 0, "市辖供电区");
//县级部分的行号
int XJrow = fc.Sheet_Find_Value(obj_sheet, 0, "县级供电区");
//为-1时表示没找到，也就是电压等级为0个
if (SXrow != -1)
{
//市辖供电区中第一行第二列的“合计”部分合并的行数就是电压等级数
//int dysum = obj_sheet.Cells[SXrow, 1].RowSpan;
int dysum = 1;
//存储市辖部分除合计以外的数据
for (int row = SXrow + dysum; row < XJrow; row++)
{
savedata tempdata = new savedata();
tempdata.DQ = "市辖供电区";
tempdata.areaname = fc.Sheet_find_Rownotemptycell(obj_sheet, row, 1);
for (int col = 2; col < 6; col++)
{
tempdata.data[col-2] = obj_sheet.GetValue(row, col);
}
SDL318_19.Add(tempdata);
}
//存储县级部分除合计以外的数据
for (int row = XJrow + dysum; row < obj_sheet.RowCount; row++)
{
savedata tempdata = new savedata();
tempdata.DQ = "县级供电区";
tempdata.areaname = fc.Sheet_find_Rownotemptycell(obj_sheet, row, 1);
for (int col = 2; col < 6; col++)
{
tempdata.data[col - 2] = obj_sheet.GetValue(row, col);
}
SDL318_19.Add(tempdata);
}
}
}
/// <summary>
/// get date
/// </summary>
/// <param name="obj">SheetView object</param>
/// <param name="FB">FormBase object</param>
/// <param name="BE">barEditItem object</param>
public void ConnectionDate(FarPoint.Win.Spread.SheetView obj, Itop.Client.Base.FormBase FB)
{
string year = "y2010";
string title = null;
double Temp = 0.0;
double Temp1 = 0.0;
int IntRow = 6;
//MessageBox.Show(year+"年");
try
{
//计算一产，二产，三产之和++++++++++++++++++++++++++++++++++++++++
ReturnRecordSet(FB, year, T.T4);
ReturnRecordSet(FB, year, T.T5);
ReturnRecordSet(FB, year, T.T6);
SumThree(year,T.T4);
SumThree(year, T.T5);
SumThree(year, T.T6);
//++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
//计算年末总人口（万人）
title = T.T7;//城镇人口
ReturnRecordSet(FB, year, title);
Temp = PF.Gethistroyvalue<Ps_History>(resualt[title], year);
title = T.T8;//乡村人口
ReturnRecordSet(FB, year, title);
Temp1 = PF.Gethistroyvalue<Ps_History>(resualt[title], year);
//地市名称
title = T.T9;
WriteValue(obj, IntRow, 0, title, 0.00);
for (int i = 1; i <=3; i++)//人口，GDP,人均GDP
{
//2010年（万人）
title = T.T1;
ReturnRecordSet(FB, year, title);
if(i==1)
{
WriteValue(obj, IntRow, 1, title,PF.ReturnFormatStr( Temp + Temp1));
}
if(i==2)
{
WriteValue(obj, IntRow, 4, title, PF.ReturnFormatStr(floatSum[3]));
}
if(i==3)
{
obj.Cells[IntRow, 7].Formula = "E" + (IntRow + 1) + "/B" + (IntRow + 1);
}
//2015年（万人）手写
title = T.T2;
//obj.SetValue(IntRow,2,225.13);
//obj.SetValue(IntRow, 5, 225.13);
//obj.SetValue(IntRow, 8, 225.13);
//年均增长率（%）
title = T.T3;
if(i==1)
{
if(obj.GetValue(IntRow,2)==null)
{
obj.SetValue(IntRow, 3, 0);
}
obj.Cells[IntRow, 3].Formula = "POWER(((C" + (IntRow + 1) + ")/(B" + (IntRow + 1) + ")), 0.2) - 1";
//PF.SetRowHight(obj, IntRow, 3, obj.GetValue(IntRow, 3).ToString());
}
if(i==2)
{
if(obj.GetValue(IntRow,5)==null)
{
obj.SetValue(IntRow, 5, 0);
}
obj.Cells[IntRow, 3 * i].Formula = "POWER(F" + (IntRow + 1) + "/E" + (IntRow + 1) + ", 0.2) - 1";
//PF.SetRowHight(obj, IntRow, 3 * i, obj.GetValue(IntRow, 3 * i).ToString());
}
if(i==3)
{
if(obj.GetValue(IntRow,8)==null)
{
obj.SetValue(IntRow,8,0);
}
obj.Cells[IntRow, 3 * i].Formula = "POWER(I" + (IntRow + 1) + "/H" + (IntRow + 1) + ", 0.2) - 1";
//PF.SetRowHight(obj, IntRow, 3 * i, obj.GetValue(IntRow, 3 * i).ToString());
}
}
}
catch (System.Exception e)
{
MessageBox.Show(e.Message);
//MessageBox.Show("数据库没有标题为：" + title + "年份是：" + year + "年的数据");
}
}
/// <summary>
/// 写入数据
/// </summary>
/// <param name="FB"></param>
/// <param name="obj"></param>
/// <param name="strEndYear"></param>
private void WriteData(Itop.Client.Base.FormBase FB, FarPoint.Win.Spread.SheetView obj, string strEndYear,int IntRow)
{
string strRowTitle = "";
string strColTitle = "";
for (int i = IntRow; i < RowBDZList.Count + IntRow; ++i)
{
strRowTitle = (string)PF.ReturnStr(obj, i, 0);
for (int j = 1; j < obj.ColumnCount; ++j)
{
//obj.Cells[i, j].Locked = false;
strColTitle = obj.GetValue((IntRow-2), j).ToString();
obj.SetValue(i, j, selectCount(FB, strEndYear, strRowTitle, strColTitle));
}
}
}
public void SaveData(FarPoint.Win.Spread.SheetView obj_sheet)
{
//清空存放数据列表
SDL317.Clear();
//市辖部分的行号
int SXrow = fc.Sheet_Find_Value(obj_sheet, 0, "1");
//县级部分的行号
int XJrow = fc.Sheet_Find_Value(obj_sheet, 0, "2");
//差为电压等级数
int DYnum = XJrow - SXrow;
//存在电压等级
if (DYnum!=0)
{
//市辖供电区加上县级供电区的四个分区，共有5个分区，加上县级合计有6个分区
for (int row = SXrow; row < obj_sheet.RowCount-DYnum; row++)
{
savedata tempdata = new savedata();
//县级合计部分跳过
if (row==XJrow)
{
row = row + DYnum ;
}
string no = fc.Sheet_find_Rownotemptycell(obj_sheet, row, 0);
string dy = obj_sheet.Cells[row, 2].Value.ToString();
tempdata.no = no;
tempdata.dy = dy;
tempdata.data = obj_sheet.GetValue(row, 6);
SDL317.Add(tempdata);
}
}
}
public void SaveData(FarPoint.Win.Spread.SheetView obj_sheet)
{
SDL33_1.Clear();
//返回县级供电区开始行号
int xjrow = fc.Sheet_Find_Value(obj_sheet, 0, "县级供电区");
for (int row = 3; row < obj_sheet.RowCount; row++)
{
if (row != xjrow)
{
savedata tempdata = new savedata();
tempdata.DQ = fc.Sheet_find_Rownotemptycell(obj_sheet, row, 0);
tempdata.areaname = obj_sheet.Cells[row, 1].Value.ToString();
tempdata.data[0] = obj_sheet.GetValue(row, 2);
tempdata.data[1] = obj_sheet.GetValue(row, 3);
tempdata.data[2] = obj_sheet.GetValue(row, 4);
tempdata.data[3] = obj_sheet.GetValue(row, 5);
tempdata.data[4] = obj_sheet.GetValue(row, 6);
SDL33_1.Add(tempdata);
}
}
}
/// <summary>
/// 通过传入的内容返回内容所在行的值
/// </summary>
/// <param name="strObj"></param>
/// <param name="IntRow">current row</param>
/// <param name="IntCol">要查询内容的列值</param>
/// <param name="YearCount">年份的数量</param>
/// <returns></returns>
public int ReturnRow(FarPoint.Win.Spread.SheetView obj,string strObj,int IntRow,int IntCol)
{
string strTemp = null;
strTemp = obj.GetValue(IntRow , IntCol ).ToString();
if(strTemp==strObj)
{
return IntRow ;
}
else
{
return ReturnRow(obj, strObj, IntRow-=1, IntCol);
}
}
/// <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="Title">标题</param>
/// <param name="obj">sheetView对象</param>
/// <param name="IntRow">起始行</param>
/// <param name="IntCol">起始列</param>
/// <returns>行数</returns>
private int YearRow1(FarPoint.Win.Spread.SheetView obj, string Title, int IntRow, int IntCol)
{
int floor = GolobalYearCount - GolobalYears ;
int TempRow = 0;
string strTemp = null;
for (int i = 1; i < floor; i++)
{
strTemp = obj.GetValue(IntRow + i-1 , IntCol ).ToString();
if (strTemp == Title)
{
TempRow = IntRow + i;//行数从0开始所以不用-1
break;
}
}
return TempRow;
}
/// <summary>
/// 计算城镇化率
/// </summary>
/// <param name="obj">SheetView Object</param>
/// <param name="Years">current year</param>
/// <param name="IntRow">current row</param>
/// <param name="IntCol">current column</param>
private void AccountUrbanizationRate(FarPoint.Win.Spread.SheetView obj, int Years, int IntRow, int IntCol)
{
float Temp = 0;
string Temp1 = "y" + Years.ToString();
Temp = (float)PF.Gethistroyvalue<Ps_History>(resualt["城镇人口（万人）"], Temp1);
obj.SetValue(IntRow, IntCol,PF.ReturnFormatStr( Temp/StrToFloat(obj.GetValue((IntRow ), IntCol-4).ToString())));
}
/// <summary>
/// “十五”年均增长率
/// </summary>
private void FifteenYears(FarPoint.Win.Spread.SheetView obj, int IntRow, int IntCol)
{
string strFirstYear = "";
string strNextYear = "";
double Pitch = 0;
strFirstYear = obj.GetValue(5,0 ).ToString();
strNextYear = obj.GetValue(6,0 ).ToString();
Pitch = (double)PF.YearsPitch(strFirstYear, strNextYear);
Pitch = (double)(1 / Pitch);
//年末总人口（万人）
SetCellType(obj, PC, (IntRow), IntCol + 4);
obj.Cells[IntRow, IntCol + 4].Formula = "POWER(((E" + (7) + ")/E" + (6) + "), " + Pitch + ")-1";
//人均GDP（万元/人）
SetCellType(obj, PC, (IntRow), IntCol + 5);
obj.Cells[IntRow, IntCol + 5].Formula = "POWER(((F" + (7) + ")/F" + (6) + "), " + Pitch + ")-1";
//城镇人口（万人）
SetCellType(obj, PC, (IntRow), IntCol + 6);
obj.Cells[IntRow, IntCol + 6].Formula = "POWER(((G" + (7) + ")/G" + (6) + "), " + Pitch + ")-1";
//乡村人口（万人）
SetCellType(obj, PC, (IntRow), IntCol + 7);
obj.Cells[IntRow, IntCol + 7].Formula = "POWER(((H" + (7) + ")/H" + (6) + "), " + Pitch + ")-1";
}
/// <summary>
/// 写入数据
/// </summary>
/// <param name="obj"></param>
private void WriteData(Itop.Client.Base.FormBase FB, FarPoint.Win.Spread.SheetView obj)
{
string strRowTitle = null;
string strColTitle = null;
for(int i=5;i<obj.RowCount;++i)
{
strRowTitle = (string)PF.ReturnStr(obj, i, 0);
for(int j=1;j<obj.ColumnCount;++j)
{
strColTitle =obj.GetValue(4,j).ToString();
if (strRowTitle == "人均GDP")
{
}
else
{
if (strColTitle == "“十五”年均增速" || strColTitle == "“十一五”年均增速" || strColTitle == "“十二五”年均增速" || strColTitle == "“十三五”年均增速")
{
if (strColTitle == "“十五”年均增速")
{
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 == " 第一产业比重" || strRowTitle == "第二产业比重" || strRowTitle == "第三产业比重")
{
obj.Cells[i, j].CellType = PC;//%
}
obj.SetValue(i, j, SelectCurrentData(FB, strColTitle, strRowTitle));
}
}
}
}
//向人均GDP那行回写数据
for(int j=1; j<obj.ColumnCount;++j)
{
strColTitle = obj.GetValue(4, j).ToString();
if (strColTitle == "“十五”年均增速" || strColTitle == "“十一五”年均增速" || strColTitle == "“十二五”年均增速" || strColTitle == "“十三五”年均增速")
{
obj.Cells[7, j].Formula = "POWER(" + PF.GetColumnTitle(j - 5) + (8) + "/" + PF.GetColumnTitle(j-1) + 8 + ",1/5)-1";
obj.Cells[7, j].CellType = PC;//%
}
else
{
obj.Cells[7, j].Formula = PF.GetColumnTitle(j) + (7) + "/" + PF.GetColumnTitle(j) + (12);
}
}
}
/// <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));
}
}
}
}
}
/// <summary>
/// get date
/// </summary>
/// <param name="obj">SheetView object</param>
/// <param name="FB">FormBase object</param>
/// <param name="BE">barEditItem object</param>
public void ConnectionDate(FarPoint.Win.Spread.SheetView obj,Itop.Client.Base.FormBase FB,DevExpress.XtraBars.BarEditItem BE)
{
string year = "y"+BE.EditValue.ToString();
string title = null;
double Temp = 0.0;
double Temp1 = 0.0;
string strTemp = null;
//MessageBox.Show(year+"年");
try
{
//地市名称
title = T.T9;
WriteValue(obj, 5, 0,title, 0.00);
//土地面积（km2）
title = T.T1;
ReturnRecordSet(FB,year, title);
WriteValue(obj, 5, 1,title, PF.Gethistroyvalue<Ps_History>(resualt[title],year));
//建成区面积（km2）
title = T.T2;
ReturnRecordSet(FB,year, title);
WriteValue(obj, 5, 2,title, PF.Gethistroyvalue<Ps_History>(resualt[title], year));
//GDP（亿元）
title = T.T3;
ReturnRecordSet(FB,year, title);
WriteValue(obj, 5, 3, title,PF.ReturnFormatStr( PF.Gethistroyvalue<Ps_History>(resualt[title], year)));
//计算一产，二产，三产之和++++++++++++++++++++++++++++++++++++++++
title = T.T4;
ReturnRecordSet(FB,year, title);
floatSum[0]=(float)PF.Gethistroyvalue<Ps_History>(resualt[title], year);
title = T.T5;
ReturnRecordSet(FB, year, title);
floatSum[1] = (float)PF.Gethistroyvalue<Ps_History>(resualt[title], year);
title = T.T6;
ReturnRecordSet(FB, year, title);
floatSum[2] =(float) PF.Gethistroyvalue<Ps_History>(resualt[title], year);
floatSum[3] = floatSum[0] + floatSum[1] + floatSum[2];
//++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
//一产
WriteValue(obj, 5, 4, title, floatSum[0]/floatSum[3]);
//PF.SetRowHight(obj, 5, 4, floatSum[0]/floatSum[3]);
//二产
title = T.T5;
WriteValue(obj, 5, 5, title, floatSum[1] / floatSum[3]);
//PF.SetRowHight(obj, 5, 5, floatSum[0]/floatSum[3]);
//三产
title = T.T6;
WriteValue(obj, 5, 6, title, floatSum[2] / floatSum[3]);
//PF.SetRowHight(obj, 5, 6, floatSum[0]/floatSum[3]);
//年末总人口（万人）
title = T.T7;//城镇人口
ReturnRecordSet(FB,year, title);
Temp=PF.Gethistroyvalue<Ps_History>(resualt[title], year);
title = T.T8;//乡村人口
ReturnRecordSet(FB, year, title);
Temp1 = PF.Gethistroyvalue<Ps_History>(resualt[title], year);
title = "年末总人口（万人）";
WriteValue(obj, 5, 7, title, PF.ReturnFormatStr(Temp + Temp1));
//人均GDP（万元/人）
floatSum[4]=S2_N.StrToFloat(obj.GetValue(5,3).ToString());
floatSum[5]=S2_N.StrToFloat(obj.GetValue(5,7).ToString());
WriteValue(obj, 5, 8, title, (floatSum[4]/floatSum[5]));
//PF.SetRowHight(obj, 5, 8, (floatSum[4] / floatSum[5]));
//城镇化率（%）
floatSum[6]=S2_N.StrToFloat(obj.GetValue(5,7).ToString());
WriteValue(obj, 5, 9, title, PF.ReturnFormatStr(Temp / floatSum[6]));
}
catch (System.Exception e)
{
//MessageBox.Show("数据库没有标题为："+title+"年份是："+year+"年的数据");
}
}
/// <summary>
/// 写入数据
/// </summary>
/// <param name="obj"></param>
private void WriteData(Itop.Client.Base.FormBase FB, FarPoint.Win.Spread.SheetView obj,string BeginYear)
{
string strRowTitle = null;
string strColTitle = null;
for (int i = 6; i < obj.RowCount; ++i)
{
strRowTitle = (string)PF.ReturnStr(obj, i, 0);
for (int j = 1; j < obj.ColumnCount; ++j)
{
strColTitle = obj.GetValue(4, j).ToString();
if (strRowTitle == "合计")
{
if (strColTitle == "“十五”年均增速" || strColTitle == "“十一五”年均增速" || strColTitle == "“十二五”年均增速" || strColTitle == "“十三五”年均增速")
{
if (strColTitle == "“十五”年均增速")
{
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
{
obj.Cells[i, j].Formula = "Sum(" + PF.GetColumnTitle(j) + (i) + ":" + PF.GetColumnTitle(j) + (i - AreaList.Count+1 ) + ")";
//obj.Cells[i, j].Formula = "POWER(" + PF.GetColumnTitle(j) + (i) + "/" + PF.GetColumnTitle(j) + (i - AreaList.Count + 1) + ",1/" + AreaList.Count + ")-1";
}
}
else
{
if (strColTitle == "“十五”年均增速" || strColTitle == "“十一五”年均增速" || strColTitle == "“十二五”年均增速" || strColTitle == "“十三五”年均增速")
{
if (strColTitle == "“十五”年均增速")
{
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
{
obj.SetValue(i, j, SelectCurrentData(FB, strColTitle, strRowTitle, BeginYear));
}
}
}
}
}
public void SaveData(FarPoint.Win.Spread.SheetView obj_sheet)
{
SDL3_7_3.Clear();
//用于更新时保存用户数据
for (int row = 5; row < obj_sheet.Rows.Count; row++)
{
if (obj_sheet.Cells[row, 1].Value.ToString() != "合计")
{
savedata tempsd = new savedata(2, 3);
tempsd.DQ = fc.Sheet_find_Rownotemptycell(obj_sheet, row, 0);
tempsd.AreaName = fc.Sheet_find_Rownotemptycell(obj_sheet, row, 1);
if (obj_sheet.Cells[row, 4].Value != null)
{
tempsd.data[0, 0] = obj_sheet.GetValue(row, 4);
}
if (obj_sheet.Cells[row, 7].Value != null)
{
tempsd.data[0, 1] = obj_sheet.GetValue(row, 7);
}
if (obj_sheet.Cells[row, 14].Value != null)
{
tempsd.data[0, 2] = obj_sheet.GetValue(row, 14);
}
if (obj_sheet.Cells[row + 1, 4].Value != null)
{
tempsd.data[1, 0] = obj_sheet.GetValue(row + 1, 4);
}
if (obj_sheet.Cells[row + 1, 7].Value != null)
{
tempsd.data[1, 1] = obj_sheet.GetValue(row + 1, 7);
}
if (obj_sheet.Cells[row + 1, 14].Value != null)
{
tempsd.data[1, 2] = obj_sheet.GetValue(row + 1, 14);
}
SDL3_7_3.Add(tempsd);
}
//行号加一
row++;
}
}
public void SaveData(FarPoint.Win.Spread.SheetView obj_sheet)
{
//清空存放数据列表
SDL320_21.Clear();
//市辖部分的行号
int SXrow = fc.Sheet_Find_Value(obj_sheet, 0, "市辖供电区");
//县级部分的行号
int XJrow = fc.Sheet_Find_Value(obj_sheet, 0, "县级供电区");
//为-1时表示没找到，也就是电压等级为0个
if (SXrow != -1)
{
//市辖供电区中第一行第二列的“合计”部分合并的行数就是电压等级数
int dysum = obj_sheet.Cells[SXrow, 1].RowSpan;
//存储市辖部分除合计以外的所有行的第4列数据
for (int row = SXrow + dysum; row < XJrow; row++)
{
savedata tempdata = new savedata();
tempdata.DQ = "市辖供电区";
tempdata.areaname = fc.Sheet_find_Rownotemptycell(obj_sheet, row, 1);
tempdata.dy = obj_sheet.Cells[row, 2].Value.ToString();
tempdata.data = obj_sheet.GetValue(row, 3);
SDL320_21.Add(tempdata);
}
//存储县级部分除合计以外的所有行的第4列数据
for (int row = XJrow + dysum; row < obj_sheet.RowCount; row++)
{
savedata tempdata = new savedata();
tempdata.DQ = "县级供电区";
tempdata.areaname = fc.Sheet_find_Rownotemptycell(obj_sheet, row, 1);
tempdata.dy = obj_sheet.Cells[row, 2].Value.ToString();
tempdata.data = obj_sheet.GetValue(row, 3);
SDL320_21.Add(tempdata);
}
}
}
/// <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;
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 == "“十五”年均增速")
{
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.SetValue(i, j, SelectCurrentData(FB, strColTitle, strRowTitle));
}
else
{
obj.Cells[i, j].Formula = PF.GetColumnTitle(j) + (i-2) + "/" + PF.GetColumnTitle(j) + (i);
}
}
}
}
}