private void Sheet_AddData(FarPoint.Win.Spread.SheetView obj_sheet, int year, string ProjID, IList <double> obj_DY_List, IList <string> SXareaid_List, IList <string> XJareaid_List)
{
}
//此处为动态添加数据方法
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;
}
}
/// <summary>
/// 清空指定的表
/// </summary>
private void SheetNClear(FarPoint.Win.Spread.SheetView obj)
{
obj.RowCount = 0;
obj.ColumnCount = 0;
}
private void barBtnRefreshData_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
WaitDialogForm newwait = new WaitDialogForm("", "正在更新数据, 请稍候...");
//生成一个空表用来保存当前表
FarPoint.Win.Spread.SheetView obj_sheet = null;
//生成一个空表，行列值都设为0用来做为程序处理时的当前表，这样可以提高处理速度
FarPoint.Win.Spread.SheetView activesheet = new FarPoint.Win.Spread.SheetView();
activesheet.RowCount = 0;
activesheet.ColumnCount = 0;
//添加空表
fpSpread1.Sheets.Add(activesheet);
//保留当前表，以备程序结束后还原当前表
obj_sheet = fpSpread1.ActiveSheet;
//将空表设为当前表
fpSpread1.ActiveSheet = activesheet;
//更新表3-1
sh31.Sheet_AddData(fpSpread1.Sheets[0], year, ProjID, SxXjName);
sh31.CellType(fpSpread1.Sheets[0]);
//更新表3-2
sh32.Sheet_AddData(fpSpread1.Sheets[1], year, ProjID, SxXjName);
sh32.CellType(fpSpread1.Sheets[1]);
//更新表3-3全手写，无需更新
//更新表3-3附表1 分区有可能变化，所以先存数据，重建表，再比对写回数据
sh33_1.SaveData(fpSpread1.Sheets[3]);
fpSpread1.Sheets[3].RowCount = 0;
fpSpread1.Sheets[3].ColumnCount = 0;
sh33_1.Build(fpSpread1.Sheets[3], year, ProjID, area_key_id, SxXjName);
sh33_1.WriteData(fpSpread1.Sheets[3]);
//更新表3-4
fpSpread1.Sheets[4].RowCount = 0;
fpSpread1.Sheets[4].ColumnCount = 0;
sh34.Build(fpSpread1.Sheets[4], year, ProjID, SxXjName);
//更新表3-4附表2
fpSpread1.Sheets[5].RowCount = 0;
fpSpread1.Sheets[5].ColumnCount = 0;
sh34_2.Build(fpSpread1.Sheets[5], year, ProjID,area_key_id,SxXjName);
//清除表格原有数据，这样写入速度快
//更新表3-5
fpSpread1.Sheets[6].RowCount = 0;
fpSpread1.Sheets[6].ColumnCount = 0;
sh35.Build(fpSpread1.Sheets[6],year,ProjID,SxXjName);
//更新表3-6
fpSpread1.Sheets[7].RowCount = 0;
fpSpread1.Sheets[7].ColumnCount = 0;
sh36.Build(fpSpread1.Sheets[7], year, ProjID, SxXjName);
//更新表3-7 有手写数据，只更新动态数据
sh37.Sheet_AddData(fpSpread1.Sheets[8],year,ProjID);
//更新表3-7附表3 有手写，表格是动态
sh37_3.SaveData(fpSpread1.Sheets[9]);
fpSpread1.Sheets[9].RowCount = 0;
fpSpread1.Sheets[9].ColumnCount = 0;
sh37_3.Build(fpSpread1.Sheets[9],year,ProjID,area_key_id,SxXjName);
sh37_3.WriteData(fpSpread1.Sheets[9]);
//更新表3-8
fpSpread1.Sheets[10].RowCount = 0;
fpSpread1.Sheets[10].ColumnCount = 0;
sh38.Build(fpSpread1.Sheets[10], year, ProjID, SxXjName);
//更新表3-8附表8
fpSpread1.Sheets[11].RowCount = 0;
fpSpread1.Sheets[11].ColumnCount = 0;
sh38_8.Build(fpSpread1.Sheets[11], year, ProjID,area_key_name, area_key_id, SxXjName);
//更新表3-9
fpSpread1.Sheets[12].RowCount = 0;
fpSpread1.Sheets[12].ColumnCount = 0;
sh39.Build(fpSpread1.Sheets[12], year, ProjID, SxXjName);
//更新表3-9附表6
fpSpread1.Sheets[13].RowCount = 0;
fpSpread1.Sheets[13].ColumnCount = 0;
sh39_6.Build(fpSpread1.Sheets[13], year, ProjID, area_key_id, SxXjName);
//更新表3-10
fpSpread1.Sheets[14].RowCount = 0;
fpSpread1.Sheets[14].ColumnCount = 0;
sh310.Build(fpSpread1.Sheets[14], year, ProjID, SxXjName);
//更新表3-10附表5
fpSpread1.Sheets[15].RowCount = 0;
fpSpread1.Sheets[15].ColumnCount = 0;
sh310_5.Build(fpSpread1.Sheets[15], year, ProjID, area_key_id, SxXjName);
//更新表3-11
fpSpread1.Sheets[16].RowCount = 0;
fpSpread1.Sheets[16].ColumnCount = 0;
sh311.Build(fpSpread1.Sheets[16], year, ProjID, SxXjName);
//更新表3-11附表9
fpSpread1.Sheets[17].RowCount = 0;
fpSpread1.Sheets[17].ColumnCount = 0;
sh311_9.Build(fpSpread1.Sheets[17], year, ProjID, area_key_id, SxXjName);
//更新表3-12
fpSpread1.Sheets[18].RowCount = 0;
fpSpread1.Sheets[18].ColumnCount = 0;
sh312.Build(fpSpread1.Sheets[18], year, ProjID, SxXjName);
//更新表3-12附表10
fpSpread1.Sheets[19].RowCount = 0;
fpSpread1.Sheets[19].ColumnCount = 0;
sh312_10.Build(fpSpread1.Sheets[19],year,ProjID,area_key_id,SxXjName);
//更新表3-13
fpSpread1.Sheets[20].RowCount = 0;
fpSpread1.Sheets[20].ColumnCount = 0;
sh313.Build(fpSpread1.Sheets[20], year, ProjID, SxXjName);
//更新表3-13附表11
fpSpread1.Sheets[21].RowCount = 0;
fpSpread1.Sheets[21].ColumnCount = 0;
sh313_11.Build(fpSpread1.Sheets[21], year, ProjID, area_key_id, SxXjName);
//更新表3-14
sh314.SaveData(fpSpread1.Sheets[22]);
fpSpread1.Sheets[22].RowCount = 0;
fpSpread1.Sheets[22].ColumnCount = 0;
sh314.Build(fpSpread1.Sheets[22], year, ProjID, SxXjName);
sh314.WriteData(fpSpread1.Sheets[22]);
//更新表3-14附表12
sh314_12.SaveData(fpSpread1.Sheets[23]);
fpSpread1.Sheets[23].RowCount = 0;
fpSpread1.Sheets[23].ColumnCount = 0;
sh314_12.Build(fpSpread1.Sheets[23], year, ProjID, area_key_id, SxXjName);
sh314_12.WriteData(fpSpread1.Sheets[23]);
//更新表3-15
fpSpread1.Sheets[24].RowCount = 0;
fpSpread1.Sheets[24].ColumnCount = 0;
sh315.Build(fpSpread1,fpSpread1.Sheets[24], year, ProjID, SxXjName);
//更新表3-15附表14
fpSpread1.Sheets[25].RowCount = 0;
fpSpread1.Sheets[25].ColumnCount = 0;
sh315_14.Build(fpSpread1.Sheets[25], year, ProjID, area_key_id, SxXjName);
//更新表3-16
fpSpread1.Sheets[26].RowCount = 0;
fpSpread1.Sheets[26].ColumnCount = 0;
sh316.Build(fpSpread1.Sheets[26], year, ProjID, SxXjName);
//更新表3-16附表16
fpSpread1.Sheets[27].RowCount = 0;
fpSpread1.Sheets[27].ColumnCount = 0;
sh316_16.Build(fpSpread1.Sheets[27], year, ProjID, area_key_id, SxXjName);
//更新表3-17
sh317.SaveData(fpSpread1.Sheets[28]);
fpSpread1.Sheets[28].RowCount = 0;
fpSpread1.Sheets[28].ColumnCount = 0;
sh317.Build(fpSpread1.Sheets[28], year, ProjID, SxXjName);
sh317.WriteData(fpSpread1.Sheets[28]);
//更新表3-17附表17
sh317_17.SaveData(fpSpread1.Sheets[29]);
fpSpread1.Sheets[29].RowCount = 0;
fpSpread1.Sheets[29].ColumnCount = 0;
sh317_17.Build(fpSpread1.Sheets[29], year, ProjID, area_key_id, SxXjName);
sh317_17.WriteData(fpSpread1.Sheets[29]);
//更新表3-18全部手写，无电压等级，表格固定无需更新
//表为fpSpread1.Sheets[30]
//更新表3-18附表19(分区有可能更新，所以要保存原数据更新后写回)
sh318_19.SaveData(fpSpread1.Sheets[31]);
fpSpread1.Sheets[31].RowCount = 0;
fpSpread1.Sheets[31].ColumnCount = 0;
sh318_19.Build(fpSpread1.Sheets[31], year, ProjID, area_key_id, SxXjName);
sh318_19.WriteData(fpSpread1.Sheets[31]);
//更新表3-19
fpSpread1.Sheets[32].RowCount = 0;
fpSpread1.Sheets[32].ColumnCount = 0;
sh319.Build(fpSpread1.Sheets[32], year, ProjID, SxXjName);
//更新表3-19附表20
fpSpread1.Sheets[33].RowCount = 0;
fpSpread1.Sheets[33].ColumnCount = 0;
sh319_20.Build(fpSpread1.Sheets[33], year, ProjID, area_key_id, SxXjName);
//更新表3-20全部手写，无电压等级，表格固定无需更新
//表为fpSpread1.Sheets[34]
//更新表3-20附表21(分区有可能更新，所以要保存原数据更新后写回)
sh320_21.SaveData(fpSpread1.Sheets[35]);
fpSpread1.Sheets[35].RowCount = 0;
fpSpread1.Sheets[35].ColumnCount = 0;
sh320_21.Build(fpSpread1.Sheets[35], year, ProjID, area_key_id, SxXjName);
sh320_21.WriteData(fpSpread1.Sheets[35]);
//移除空表
fpSpread1.Sheets.Remove(activesheet);
//还原当前表
fpSpread1.ActiveSheet = obj_sheet;
//设文本自动换行
fc.Sheet_Colautoenter(fpSpread1);
newwait.Close();
MessageBox.Show("更新数据完成！");
}
/// <summary>
/// 添加工作簿
/// </summary>
private void AddSheets()
{
for(int i=0;i<SheetN;++i)
{
fpSpread1_SheetN[i] = new FarPoint.Win.Spread.SheetView();
fpSpread1.Sheets.Add(fpSpread1_SheetN[i]);
}
}
/// <summary>
/// 更新数据
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void barButtonItem2_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
wait = new WaitDialogForm("", "正在更新数据, 请稍候...");
////由于SheetView已经没有了所以移除SheetView
//MessageBox.Show(fpSpread1.Sheets[0].SheetName);
//===================================================
FarPoint.Win.Spread.SheetView obj = null;
//由于更新数据时间太长需要建个空表做初始界面
FarPoint.Win.Spread.SheetView fpSpread1_SheetN = new FarPoint.Win.Spread.SheetView();
fpSpread1.Sheets.Add(fpSpread1_SheetN);
obj = fpSpread1.ActiveSheet;
fpSpread1.ActiveSheet = fpSpread1_SheetN;
//PF.CreateSheet(this, fpSpread1, "kk");
//SheetIndex = fpSpread1.ActiveSheetIndex;//记住当前的SheetView的索引值
//fpSpread1.ActiveSheet=fpSpread1.Sheets[fpSpread1.Sheets.Count-1];//把当前界面给空表
PF.RemoveSheetView(this.fpSpread1, (fpSpread1.Sheets.Count - 1));//清空所有行列
//this.fpSpread1.Sheets.Clear();
IsCreateSheet = false;
LoadData();
//newwait.Close();
IsCreateSheet = true;
fpSpread1.ActiveSheet = fpSpread1.Sheets[SheetIndex];//把以前显示的界面在显示出来
//if (SheetIndex == 2)
//{
// this.barEditItem2.Visibility = DevExpress.XtraBars.BarItemVisibility.Always;
//}
//删除临时SheetView
//fpSpread1.Sheets.Remove(fpSpread1.Sheets[fpSpread1.Sheets.Count - 1]);
fpSpread1.Sheets.Remove(fpSpread1_SheetN);
//MessageBox.Show("更新数据完成！");
wait.Close();
}
/// <summary>
/// 更新数据
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void barButtonItem3_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
wait1 = new WaitDialogForm("", "正在更新数据, 请稍候...");
////由于SheetView已经没有了所以移除SheetView
//MessageBox.Show(fpSpread1.Sheets[0].SheetName);
//===================================================
//由于更新数据时间太长需要建个空表做初始界面
FarPoint.Win.Spread.SheetView obj = null;
FarPoint.Win.Spread.SheetView fpSpread1_SheetN = new FarPoint.Win.Spread.SheetView();
SheetNClear(fpSpread1_SheetN);
fpSpread1.Sheets.Add(fpSpread1_SheetN);
obj = fpSpread1.ActiveSheet;
fpSpread1.ActiveSheet = fpSpread1_SheetN;
S10_10.SaveData(fpSpread1.Sheets[12], 5, 2, 1, 6);
this.fpSpread1.Sheets.Clear();
//PF.CreateSheet(this, fpSpread1, "kk");
//SheetIndex = fpSpread1.ActiveSheetIndex;//记住当前的SheetView的索引值
//fpSpread1.ActiveSheet = fpSpread1.Sheets[fpSpread1.Sheets.Count - 1];//把当前界面给空表
//PF.RemoveSheetView(this.fpSpread1, (fpSpread1.Sheets.Count - 1));//清空所有行列
////由于表10_10是手写所以不用更新，所以不用清除
//for (int i = 0; i < fpSpread1.Sheets.Count - 1; ++i)
//{
// if(i!=12)
// {
// fpSpread1.Sheets[i].RowCount = 0;
// fpSpread1.Sheets[i].ColumnCount = 0;
// }
//}
//this.barEditItem1.Visibility = DevExpress.XtraBars.BarItemVisibility.Never;
IsCreateSheet = false;
Updateing();
IsCreateSheet = true;
fpSpread1.ActiveSheet = fpSpread1.Sheets[SheetIndex];//把以前显示的界面在显示出来
//删除临时SheetView
//fpSpread1.Sheets.Remove(fpSpread1.Sheets[fpSpread1.Sheets.Count - 1]);
fpSpread1.Sheets.Remove(fpSpread1_SheetN);
//if (SheetIndex == fpSpread1.Sheets.Count - 1)
//{
// this.barEditItem1.Visibility = DevExpress.XtraBars.BarItemVisibility.Always ;
//}
//MessageBox.Show("更新数据完成！");
wait1.Close();
}
/// <summary>
/// 设计器支持所需的方法 - 不要
/// 使用代码编辑器修改此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.components = new System.ComponentModel.Container();
System.Resources.ResourceManager resources = new System.Resources.ResourceManager(typeof(ucCardManage));
this.panel1 = new Neusoft.FrameWork.WinForms.Controls.NeuPanel();
this.textBox1 = new Neusoft.FrameWork.WinForms.Controls.NeuTextBox();
this.label1 = new Neusoft.FrameWork.WinForms.Controls.NeuLabel();
this.panel2 = new Neusoft.FrameWork.WinForms.Controls.NeuPanel();
this.fpSpread1 = new FarPoint.Win.Spread.FpSpread();
this.fpSpread1_Sheet1 = new FarPoint.Win.Spread.SheetView();
this.panel1.SuspendLayout();
this.panel2.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.fpSpread1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.fpSpread1_Sheet1)).BeginInit();
this.SuspendLayout();
//
// panel1
//
this.panel1.Controls.Add(this.textBox1);
this.panel1.Controls.Add(this.label1);
this.panel1.Dock = System.Windows.Forms.DockStyle.Top;
this.panel1.Location = new System.Drawing.Point(0, 57);
this.panel1.Name = "panel1";
this.panel1.Size = new System.Drawing.Size(1016, 39);
this.panel1.TabIndex = 1;
this.panel1.Visible = false;
//
// textBox1
//
this.textBox1.Location = new System.Drawing.Point(80, 8);
this.textBox1.Name = "textBox1";
this.textBox1.TabIndex = 1;
this.textBox1.Text = "";
//
// label1
//
this.label1.AutoSize = true;
this.label1.Location = new System.Drawing.Point(32, 8);
this.label1.Name = "label1";
this.label1.Size = new System.Drawing.Size(29, 17);
this.label1.TabIndex = 0;
this.label1.Text = "查询";
this.label1.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
//
// panel2
//
this.panel2.Controls.Add(this.fpSpread1);
this.panel2.Dock = System.Windows.Forms.DockStyle.Fill;
this.panel2.Location = new System.Drawing.Point(0, 96);
this.panel2.Name = "panel2";
this.panel2.Size = new System.Drawing.Size(1016, 645);
this.panel2.TabIndex = 2;
//
// fpSpread1
//
this.fpSpread1.Dock = System.Windows.Forms.DockStyle.Fill;
this.fpSpread1.Location = new System.Drawing.Point(0, 0);
this.fpSpread1.Name = "fpSpread1";
this.fpSpread1.Sheets.AddRange(new FarPoint.Win.Spread.SheetView[] {
this.fpSpread1_Sheet1
});
this.fpSpread1.Size = new System.Drawing.Size(1016, 645);
this.fpSpread1.TabIndex = 0;
this.fpSpread1.CellDoubleClick += new FarPoint.Win.Spread.CellClickEventHandler(this.fpSpread1_CellDoubleClick);
//
// fpSpread1_Sheet1
//
this.fpSpread1_Sheet1.Reset();
//this.fpSpread1_Sheet1.AutoSortColumns = ((FarPoint.Win.Spread.SheetView.SaveAutoSortColumns)(resources.GetObject("fpSpread1_Sheet1.AutoSortColumns")));
this.fpSpread1_Sheet1.OperationMode = FarPoint.Win.Spread.OperationMode.SingleSelect;
this.fpSpread1_Sheet1.RowHeader.Columns.Default.Resizable = false;
this.fpSpread1_Sheet1.SelectionPolicy = FarPoint.Win.Spread.Model.SelectionPolicy.Single;
this.fpSpread1_Sheet1.SelectionUnit = FarPoint.Win.Spread.Model.SelectionUnit.Row;
this.fpSpread1_Sheet1.SheetName = "Sheet1";
//
// frmCardManage
//
this.ClientSize = new System.Drawing.Size(1016, 741);
this.Controls.Add(this.panel2);
this.Controls.Add(this.panel1);
this.Name = "frmCardManage";
this.Text = "病案卡管理";
this.Load += new System.EventHandler(this.frmCardManage_Load);
this.panel1.ResumeLayout(false);
this.panel2.ResumeLayout(false);
((System.ComponentModel.ISupportInitialize)(this.fpSpread1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.fpSpread1_Sheet1)).EndInit();
this.ResumeLayout(false);
}
protected virtual void SetMoneyed(FarPoint.Win.Spread.SheetView sheet, DataView dv)
{
dv.RowFilter = "BALANCE_ITEM='6'";
this.SetFarpointValue(sheet, dv);
}
/// <summary>
/// 增加药品项目
/// </summary>
/// <param name="item"></param>
/// <param name="parms"></param>
public int AddItem(FarPoint.Win.Spread.SheetView sv, int activeRow)
{
return(1);
}
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.components = new System.ComponentModel.Container();
System.Resources.ResourceManager resources = new System.Resources.ResourceManager(typeof(frmQueryPatient));
this.toolBar1 = new System.Windows.Forms.ToolBar();
this.toolBarButton4 = new System.Windows.Forms.ToolBarButton();
this.toolBarButton3 = new System.Windows.Forms.ToolBarButton();
this.toolBarButton1 = new System.Windows.Forms.ToolBarButton();
this.toolBarButton2 = new System.Windows.Forms.ToolBarButton();
this.imageList16 = new System.Windows.Forms.ImageList(this.components);
this.panel1 = new System.Windows.Forms.Panel();
this.panel3 = new System.Windows.Forms.Panel();
this.fpSpread1 = new FarPoint.Win.Spread.FpSpread();
this.fpSpread1_Sheet1 = new FarPoint.Win.Spread.SheetView();
this.splitter1 = new System.Windows.Forms.Splitter();
this.panel2 = new System.Windows.Forms.Panel();
this.txtRefer4 = new System.Windows.Forms.ComboBox();
this.lblRefer4 = new System.Windows.Forms.Label();
this.txtRefer3 = new System.Windows.Forms.ComboBox();
this.txtRefer2 = new System.Windows.Forms.ComboBox();
this.txtRefer1 = new System.Windows.Forms.ComboBox();
this.cmbCondition = new System.Windows.Forms.ComboBox();
this.button1 = new System.Windows.Forms.Button();
this.lblRefer1 = new System.Windows.Forms.Label();
this.lblRefer3 = new System.Windows.Forms.Label();
this.lblRefer2 = new System.Windows.Forms.Label();
this.lblRefer1a = new System.Windows.Forms.Label();
this.panel1.SuspendLayout();
this.panel3.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.fpSpread1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.fpSpread1_Sheet1)).BeginInit();
this.panel2.SuspendLayout();
this.SuspendLayout();
//
// toolBar1
//
this.toolBar1.Appearance = System.Windows.Forms.ToolBarAppearance.Flat;
this.toolBar1.Buttons.AddRange(new System.Windows.Forms.ToolBarButton[] {
this.toolBarButton4,
this.toolBarButton3,
this.toolBarButton1,
this.toolBarButton2
});
this.toolBar1.DropDownArrows = true;
this.toolBar1.ImageList = this.imageList16;
this.toolBar1.Location = new System.Drawing.Point(0, 0);
this.toolBar1.Name = "toolBar1";
this.toolBar1.ShowToolTips = true;
this.toolBar1.Size = new System.Drawing.Size(552, 41);
this.toolBar1.TabIndex = 0;
this.toolBar1.ButtonClick += new System.Windows.Forms.ToolBarButtonClickEventHandler(this.toolBar1_ButtonClick);
//
// toolBarButton4
//
this.toolBarButton4.Style = System.Windows.Forms.ToolBarButtonStyle.Separator;
//
// toolBarButton3
//
this.toolBarButton3.Style = System.Windows.Forms.ToolBarButtonStyle.Separator;
//
// toolBarButton1
//
this.toolBarButton1.ImageIndex = 4;
this.toolBarButton1.Text = "查询";
//
// toolBarButton2
//
this.toolBarButton2.ImageIndex = 14;
this.toolBarButton2.Text = "退出";
//
// imageList16
//
this.imageList16.ColorDepth = System.Windows.Forms.ColorDepth.Depth32Bit;
this.imageList16.ImageSize = new System.Drawing.Size(16, 16);
this.imageList16.ImageStream = ((System.Windows.Forms.ImageListStreamer)(resources.GetObject("imageList16.ImageStream")));
this.imageList16.TransparentColor = System.Drawing.Color.Transparent;
//
// panel1
//
this.panel1.Controls.Add(this.panel3);
this.panel1.Controls.Add(this.splitter1);
this.panel1.Controls.Add(this.panel2);
this.panel1.Dock = System.Windows.Forms.DockStyle.Fill;
this.panel1.Location = new System.Drawing.Point(0, 41);
this.panel1.Name = "panel1";
this.panel1.Size = new System.Drawing.Size(552, 380);
this.panel1.TabIndex = 1;
//
// panel3
//
this.panel3.Controls.Add(this.fpSpread1);
this.panel3.Dock = System.Windows.Forms.DockStyle.Fill;
this.panel3.Location = new System.Drawing.Point(192, 0);
this.panel3.Name = "panel3";
this.panel3.Size = new System.Drawing.Size(360, 380);
this.panel3.TabIndex = 2;
//
// fpSpread1
//
this.fpSpread1.Dock = System.Windows.Forms.DockStyle.Fill;
this.fpSpread1.Location = new System.Drawing.Point(0, 0);
this.fpSpread1.Name = "fpSpread1";
this.fpSpread1.Sheets.AddRange(new FarPoint.Win.Spread.SheetView[] {
this.fpSpread1_Sheet1
});
this.fpSpread1.Size = new System.Drawing.Size(360, 380);
this.fpSpread1.TabIndex = 0;
this.fpSpread1.CellDoubleClick += new FarPoint.Win.Spread.CellClickEventHandler(this.fpSpread1_CellDoubleClick);
//
// fpSpread1_Sheet1
//
this.fpSpread1_Sheet1.Reset();
this.fpSpread1_Sheet1.GrayAreaBackColor = System.Drawing.Color.White;
this.fpSpread1_Sheet1.SheetName = "Sheet1";
//
// splitter1
//
this.splitter1.Location = new System.Drawing.Point(184, 0);
this.splitter1.Name = "splitter1";
this.splitter1.Size = new System.Drawing.Size(8, 380);
this.splitter1.TabIndex = 1;
this.splitter1.TabStop = false;
//
// panel2
//
this.panel2.Controls.Add(this.txtRefer4);
this.panel2.Controls.Add(this.lblRefer4);
this.panel2.Controls.Add(this.txtRefer3);
this.panel2.Controls.Add(this.txtRefer2);
this.panel2.Controls.Add(this.txtRefer1);
this.panel2.Controls.Add(this.cmbCondition);
this.panel2.Controls.Add(this.button1);
this.panel2.Controls.Add(this.lblRefer1);
this.panel2.Controls.Add(this.lblRefer3);
this.panel2.Controls.Add(this.lblRefer2);
this.panel2.Controls.Add(this.lblRefer1a);
this.panel2.Dock = System.Windows.Forms.DockStyle.Left;
this.panel2.Location = new System.Drawing.Point(0, 0);
this.panel2.Name = "panel2";
this.panel2.Size = new System.Drawing.Size(184, 380);
this.panel2.TabIndex = 0;
//
// txtRefer4
//
this.txtRefer4.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Left)
| System.Windows.Forms.AnchorStyles.Right)));
this.txtRefer4.Location = new System.Drawing.Point(53, 170);
this.txtRefer4.Name = "txtRefer4";
this.txtRefer4.Size = new System.Drawing.Size(121, 20);
this.txtRefer4.TabIndex = 14;
this.txtRefer4.Text = "comboBox4";
//
// lblRefer4
//
this.lblRefer4.Location = new System.Drawing.Point(4, 175);
this.lblRefer4.Name = "lblRefer4";
this.lblRefer4.Size = new System.Drawing.Size(40, 16);
this.lblRefer4.TabIndex = 13;
this.lblRefer4.Text = "label3";
//
// txtRefer3
//
this.txtRefer3.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Left)
| System.Windows.Forms.AnchorStyles.Right)));
this.txtRefer3.Location = new System.Drawing.Point(52, 135);
this.txtRefer3.Name = "txtRefer3";
this.txtRefer3.Size = new System.Drawing.Size(121, 20);
this.txtRefer3.TabIndex = 12;
this.txtRefer3.Text = "comboBox4";
//
// txtRefer2
//
this.txtRefer2.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Left)
| System.Windows.Forms.AnchorStyles.Right)));
this.txtRefer2.Location = new System.Drawing.Point(52, 98);
this.txtRefer2.Name = "txtRefer2";
this.txtRefer2.Size = new System.Drawing.Size(121, 20);
this.txtRefer2.TabIndex = 11;
this.txtRefer2.Text = "comboBox3";
//
// txtRefer1
//
this.txtRefer1.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Left)
| System.Windows.Forms.AnchorStyles.Right)));
this.txtRefer1.Location = new System.Drawing.Point(52, 61);
this.txtRefer1.Name = "txtRefer1";
this.txtRefer1.Size = new System.Drawing.Size(121, 20);
this.txtRefer1.TabIndex = 10;
this.txtRefer1.Text = "comboBox2";
//
// cmbCondition
//
this.cmbCondition.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Left)
| System.Windows.Forms.AnchorStyles.Right)));
this.cmbCondition.Location = new System.Drawing.Point(52, 24);
this.cmbCondition.Name = "cmbCondition";
this.cmbCondition.Size = new System.Drawing.Size(121, 20);
this.cmbCondition.TabIndex = 9;
this.cmbCondition.Text = "comboBox1";
this.cmbCondition.SelectedIndexChanged += new System.EventHandler(this.cmbCondition_SelectedIndexChanged);
//
// button1
//
this.button1.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right)));
this.button1.Location = new System.Drawing.Point(72, 226);
this.button1.Name = "button1";
this.button1.TabIndex = 8;
this.button1.Text = "查询";
this.button1.Click += new System.EventHandler(this.btnQuery_Click);
//
// lblRefer1
//
this.lblRefer1.Location = new System.Drawing.Point(3, 64);
this.lblRefer1.Name = "lblRefer1";
this.lblRefer1.Size = new System.Drawing.Size(40, 16);
this.lblRefer1.TabIndex = 6;
this.lblRefer1.Text = "label4";
//
// lblRefer3
//
this.lblRefer3.Location = new System.Drawing.Point(3, 140);
this.lblRefer3.Name = "lblRefer3";
this.lblRefer3.Size = new System.Drawing.Size(40, 16);
this.lblRefer3.TabIndex = 4;
this.lblRefer3.Text = "label3";
//
// lblRefer2
//
this.lblRefer2.Location = new System.Drawing.Point(3, 102);
this.lblRefer2.Name = "lblRefer2";
this.lblRefer2.Size = new System.Drawing.Size(40, 16);
this.lblRefer2.TabIndex = 2;
this.lblRefer2.Text = "label2";
//
// lblRefer1a
//
this.lblRefer1a.Location = new System.Drawing.Point(3, 26);
this.lblRefer1a.Name = "lblRefer1a";
this.lblRefer1a.Size = new System.Drawing.Size(40, 16);
this.lblRefer1a.TabIndex = 0;
this.lblRefer1a.Text = "条件";
//
// frmQueryPatient
//
this.AcceptButton = this.button1;
this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
this.ClientSize = new System.Drawing.Size(552, 421);
this.Controls.Add(this.panel1);
this.Controls.Add(this.toolBar1);
this.Name = "frmQueryPatient";
this.Text = "患者查询";
this.Load += new System.EventHandler(this.frmQueryPatient_Load);
this.panel1.ResumeLayout(false);
this.panel3.ResumeLayout(false);
((System.ComponentModel.ISupportInitialize)(this.fpSpread1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.fpSpread1_Sheet1)).EndInit();
this.panel2.ResumeLayout(false);
this.ResumeLayout(false);
}
//////////////////////////////////////////////////////////////////////////
/// <summary>
/// 填写表头
/// </summary>
/// <param name="obj"></param>
/// <param name="Title"></param>
public void SetSheet_5Title(Itop.Client.Base.FormBase FB, FarPoint.Win.Spread.SheetView obj, string Title)
{
int IntColCount = 11;
int IntRowCount = 6 + 2 + 3;//标题占3行，分区类型占2行
string title = null;
obj.SheetName = Title;
obj.Columns.Count = IntColCount;
obj.Rows.Count = IntRowCount;
IntCol = obj.Columns.Count;
PF.Sheet_GridandCenter(obj);//画边线，居中
m_PF.LockSheets(obj);
string strTitle = "";
IntRow = 3;
strTitle = Title;
PF.CreateSheetView(obj, IntRow, IntCol, 0, 0, Title);
PF.SetSheetViewColumnsWidth(obj, 0, Title);
IntCol = 1;
strTitle = "单位：千伏 万千瓦 万千瓦时 % 小时 公里";
obj.AddSpanCell(IntRow, 0, 1, obj.Columns.Count);
obj.SetValue(IntRow, 0, strTitle);
PF.SetSheetViewColumnsWidth(obj, 0, strTitle);
//右对齐
obj.Rows[IntRow].HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Right;
//列标题
strTitle = "线路名称";
PF.CreateSheetView(obj, NextRowMerge += 1, NextColMerge, IntRow += 1, IntCol -= 1, strTitle);
PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle);
for (int i = 0; i < (IntColCount - 1); ++i)
{
switch (i)
{
case 0:
strTitle = " 电压等级 ";
break;
case 1:
strTitle = " 导线型号 ";
break;
case 2:
strTitle = " 投运年限 ";
break;
case 3:
strTitle = " 线路起讫 ";
break;
case 4:
strTitle = " 线路长度 ";
break;
case 5:
strTitle = " 最大允许输送负荷 ";
break;
case 6:
strTitle = " 最大实际输送负荷 ";
break;
case 7:
strTitle = " 最大实际电量 ";
break;
case 8:
strTitle = " 线路负载率 ";
break;
case 9:
strTitle = " 最大负荷利用小时数 ";
break;
}
PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow, IntCol += 1, strTitle);
PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle);
}
NextRowMerge = 1;
NextColMerge = 1;
IntRow = 5;
IntCol = 0;
//PF.SetWholeRowHeight(obj, obj.Rows.Count, obj.Columns.Count);//行高
}
/// <summary>
/// 加载查询后的数据
/// </summary>
private void LoadData(Itop.Client.Base.FormBase FB, FarPoint.Win.Spread.SheetView obj, int IntRow, string strYear)
{
string BDZname = null;
PSPDEV pv = null;
int RowCount = 0;
if (list != null)
{
RowCount = list.Count;
}
for (int i = 0; i < RowCount; ++i)
{
pv = (PSPDEV)list[i];
for (int j = 0; j < obj.ColumnCount; ++j)
{
switch (j)
{
case 0: //线路名称
obj.SetValue((i + IntRow), j, pv.Name);
break;
case 1: //电压等级
obj.SetValue((i + IntRow), j, pv.RateVolt);
break;
case 2: //导线型号
obj.SetValue((i + IntRow), j, pv.LineType);
break;
case 3: //投运年限
obj.SetValue((i + IntRow), j, pv.OperationYear);
break;
case 4: //线路起讫
BDZname = SelectXLQQ(FB, pv.IName, pv.JName, strYear);
obj.SetValue((i + IntRow), j, BDZname);
break;
case 5: //线路长度
obj.SetValue((i + IntRow), j, (pv.LineLength + pv.Length2));
break;
case 6: //最大允许输送负荷
obj.SetValue((i + IntRow), j, pv.Burthen);
break;
case 7: //最大实际输送负荷
//obj.SetValue((i + IntRow), j, pv.Burthen);
obj.Cells[i + IntRow, j].Locked = false;
break;
case 8: //最大实际电量
obj.Cells[i + IntRow, j].Locked = false;
break;
case 9: //线路负载率
obj.Cells[(i + IntRow), j].Formula = "H" + (i + IntRow + 1) + "/G" + (i + IntRow + 1);
break;
case 10: //最大负荷利用小时数
//obj.Cells[i + IntRow, j].Locked = false;
obj.Cells[(i + IntRow), j].Formula = "I" + (i + IntRow + 1) + "/H" + (i + IntRow + 1);
break;
}
}
}
}
private void barBtnRefrehData_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
WaitDialogForm newwait=new WaitDialogForm("", "正在更新数据, 请稍候...");
//清空原有sheet的数据，但保留sheetname
fc.SpreadClearSheet(fpSpread1);
//生成一个空表用来保存当前表
FarPoint.Win.Spread.SheetView obj_sheet = null;
//生成一个空表，行列值都设为0用来做为程序处理时的当前表，这样可以提高处理速度
FarPoint.Win.Spread.SheetView activesheet = new FarPoint.Win.Spread.SheetView();
activesheet.RowCount = 0;
activesheet.ColumnCount = 0;
//添加空表
fpSpread1.Sheets.Add(activesheet);
//保留当前表，以备程序结束后还原当前表
obj_sheet = fpSpread1.ActiveSheet;
//将空表设为当前表
fpSpread1.ActiveSheet = activesheet;
shjjbyyear = true;
//年增长率法
build_ArverageIncreasing();
//外推法
build_Extrapolation();
//指数平滑
build_ExponentialSmoothing();
//弹性系数
build_CoefficientOfElasticity();
//相关法
build_CorrelationMethod();
//灰色模型
build_GrayModel();
shjjbyyear = false;
fpSpread1.Sheets.Remove(activesheet);
//移除空表
//还原当前表
fpSpread1.ActiveSheet = obj_sheet;
newwait.Close();
MessageBox.Show("更新数据完成！");
}
//////////////////////////////////////////////////////////////////////////
/// <summary>
/// 填写表头
/// </summary>
/// <param name="obj"></param>
/// <param name="Title"></param>
public void SetSheet4_2_1Title(FarPoint.Win.Spread.SheetView obj, string Title)
{
AreaType[0] = "市辖供电区";
AreaType[1] = "县级供电区";
int IntColCount = ColumnCount;
int IntRowCount = 2 + 3;//标题占3行，分区类型占2行，
string title = null;
obj.SheetName = Title;
obj.Columns.Count = IntColCount;
obj.Rows.Count = IntRowCount;
IntCol = obj.Columns.Count;
PF.Sheet_GridandCenter(obj);//画边线，居中
S10_1.ColReadOnly(obj, IntColCount);
//obj.OperationMode = FarPoint.Win.Spread.OperationMode.ReadOnly;
string strTitle = "";
IntRow = 3;
strTitle = Title;
PF.CreateSheetView(obj, IntRow, IntCol, 0, 0, Title);
PF.SetSheetViewColumnsWidth(obj, 0, Title);
IntCol = 1;
strTitle = " 类 型";
PF.CreateSheetView(obj, NextRowMerge += 1, NextColMerge, IntRow, IntCol -= 1, strTitle);
PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle);
strTitle = " 分区名称";
PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow, IntCol += 1, strTitle);
PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle);
strTitle = " 2010年";
PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow, IntCol += 1, strTitle);
PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle);
strTitle = " 2011年 ";
PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow, IntCol += 1, strTitle);
PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle);
strTitle = " 2012年 ";
PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow, IntCol += 1, strTitle);
PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle);
strTitle = " 2013年 ";
PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow, IntCol += 1, strTitle);
PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle);
strTitle = " 2014年 ";
PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow, IntCol += 1, strTitle);
PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle);
strTitle = " 2015年";
PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow, IntCol += 1, strTitle);
PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle);
strTitle = " “十二五”年均增长率";
PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow, IntCol += 1, strTitle);
PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle);
strTitle = " 2020年";
PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow, IntCol += 1, strTitle);
PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle);
strTitle = "“十三五”年均增长率";
PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow, IntCol += 1, strTitle);
PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle);
NextRowMerge = 1;
NextColMerge = 1;
IntRow = 5;
IntCol = 0;
PF.SetWholeRowHeight(obj, obj.Rows.Count, obj.Columns.Count);//行高
}
/// <summary>
/// 获得日结实体
/// </summary>
private void SetDayBalanceData()
{
FarPoint.Win.Spread.SheetView sheet = this.ucClinicDayBalanceReportNew1.neuSpread1_Sheet1;
string strValue = string.Empty;
#region 起止发票号
dayBalance = new Neusoft.Report.Finance.FinOpb.Class.ClinicDayBalanceNew();
dayBalance.InvoiceNO.ID = "A001";
dayBalance.InvoiceNO.Name = "起始结束票据号";
strValue = GetOneCellText(sheet, "A00101");
dayBalance.BegionInvoiceNO = strValue;
strValue = GetOneCellText(sheet, "A00102");
dayBalance.EndInvoiceNo = strValue;
//设置Cell显示数据的Tag和字段名称
dayBalance.SortID = "A00101|EXTENT_FIELD2、A00102|EXTENT_FIELD3";
dayBalance.TypeStr = "5";
this.SetDayBalance();
#endregion
#region 票据总数
strValue = GetOneCellText(sheet, "A002");
this.SetOneCellDayBalance("A002", "票据总数", NConvert.ToDecimal(strValue), "5");
#endregion
#region 效票据
strValue = GetOneCellText(sheet, "A003");
this.SetOneCellDayBalance("A003", "有效票据", NConvert.ToDecimal(strValue), "5");
#endregion
#region 退费票据
dayBalance = new Neusoft.Report.Finance.FinOpb.Class.ClinicDayBalanceNew();
dayBalance.InvoiceNO.ID = "A004";
dayBalance.InvoiceNO.Name = "退费票据";
//票据数
strValue = this.GetOneCellText(sheet, "A00401");
dayBalance.TotCost = NConvert.ToDecimal(strValue);
//票据号
strValue = this.GetOneCellText(sheet, "A00402");
dayBalance.CancelInvoiceNo = strValue;
dayBalance.TypeStr = "5";
dayBalance.SortID = "A00401|TOT_COST、A00402|EXTENT_FIELD5";
this.SetDayBalance();
#endregion
#region 作废票据
dayBalance = new Neusoft.Report.Finance.FinOpb.Class.ClinicDayBalanceNew();
dayBalance.InvoiceNO.ID = "A005";
dayBalance.InvoiceNO.Name = "作废票据";
strValue = this.GetOneCellText(sheet, "A00501");
dayBalance.TotCost = NConvert.ToDecimal(strValue);
strValue = this.GetOneCellText(sheet, "A00502");
dayBalance.FalseInvoiceNo = strValue;
dayBalance.TypeStr = "5";
dayBalance.SortID = "A00501|TOT_COST、A00502|EXTENT_FIELD4";
this.SetDayBalance();
#endregion
#region 退费金额
strValue = GetOneCellText(sheet, "A006");
this.SetOneCellDayBalance("A006", "退费金额", NConvert.ToDecimal(strValue), "5");
#endregion
#region 作废金额
strValue = GetOneCellText(sheet, "A007");
this.SetOneCellDayBalance("A007", "作废金额", NConvert.ToDecimal(strValue), "5");
#endregion
#region 暂时无数据
#region 押金金额
strValue = GetOneCellText(sheet, "A008");
this.SetOneCellDayBalance("A008", "押金金额", NConvert.ToDecimal(strValue), "5");
#endregion
#region 退押金额
strValue = GetOneCellText(sheet, "A009");
this.SetOneCellDayBalance("A009", "退押金额", NConvert.ToDecimal(strValue), "5");
#endregion
#region 减免金额
strValue = GetOneCellText(sheet, "A010");
this.SetOneCellDayBalance("A010", "减免金额", NConvert.ToDecimal(strValue), "5");
#endregion
#endregion
#region 四舍五入
strValue = GetOneCellText(sheet, "A011");
this.SetOneCellDayBalance("A011", "四舍五入", NConvert.ToDecimal(strValue), "5");
#endregion
#region 公费医疗
strValue = this.GetOneCellText(sheet, "A012");
SetOneCellDayBalance("A012", "公费医疗", NConvert.ToDecimal(strValue), "6");
#endregion
#region 公费自付
strValue = this.GetOneCellText(sheet, "A013");
SetOneCellDayBalance("A013", "公费自费", NConvert.ToDecimal(strValue), "6");
#endregion
#region 公费账户
strValue = this.GetOneCellText(sheet, "A026");
SetOneCellDayBalance("A026", "公费账户", NConvert.ToDecimal(strValue), "6");
#endregion
#region 市保自付
strValue = this.GetOneCellText(sheet, "A014");
SetOneCellDayBalance("A014", "市保自费", NConvert.ToDecimal(strValue), "6");
#endregion
#region 市保账户
strValue = this.GetOneCellText(sheet, "A015");
SetOneCellDayBalance("A015", "市保账户", NConvert.ToDecimal(strValue), "6");
#endregion
#region 市保统筹
strValue = this.GetOneCellText(sheet, "A016");
SetOneCellDayBalance("A016", "市保统筹", NConvert.ToDecimal(strValue), "6");
#endregion
#region 市保大额
strValue = this.GetOneCellText(sheet, "A017");
SetOneCellDayBalance("A017", "市保大额", NConvert.ToDecimal(strValue), "6");
#endregion
#region 省保自付
strValue = this.GetOneCellText(sheet, "A018");
SetOneCellDayBalance("A018", "省保自费", NConvert.ToDecimal(strValue), "6");
#endregion
#region 省保账户
strValue = this.GetOneCellText(sheet, "A019");
SetOneCellDayBalance("A019", "省保账户", NConvert.ToDecimal(strValue), "6");
#endregion
#region 省保统筹
strValue = this.GetOneCellText(sheet, "A020");
SetOneCellDayBalance("A020", "省保统筹", NConvert.ToDecimal(strValue), "6");
#endregion
#region 省保大额
strValue = this.GetOneCellText(sheet, "A021");
SetOneCellDayBalance("A021", "省保大额", NConvert.ToDecimal(strValue), "6");
#endregion
#region 省公务员
strValue = this.GetOneCellText(sheet, "A022");
SetOneCellDayBalance("A022", "省公务员", NConvert.ToDecimal(strValue), "6");
#endregion
#region 缴现金额
strValue = this.GetOneCellText(sheet, "A023");
SetOneCellDayBalance("A023", "上缴现金额", NConvert.ToDecimal(strValue), "6");
#endregion
#region 缴支票额
strValue = this.GetOneCellText(sheet, "A024");
SetOneCellDayBalance("A024", "上缴支票额", NConvert.ToDecimal(strValue), "6");
#endregion
#region 缴银联额
strValue = this.GetOneCellText(sheet, "A025");
SetOneCellDayBalance("A025", "上缴银联额", NConvert.ToDecimal(strValue), "6");
#endregion
}
//public string[,,] Amount = null;
//private Dictionary<string, int> resualt = new Dictionary<string, int>();//存放地区的集合
//////////////////////////////////////////////////////////////////////////
/// <summary>
/// 填写表头
/// </summary>
/// <param name="obj"></param>
/// <param name="Title"></param>
public void SetSheet10_1_1Title(FarPoint.Win.Spread.SheetView obj, string Title)
{
int IntColCount = 11;
int IntRowCount = (ReturnArea() + 2) * VPCount + 2 + 3;//标题占3行，分区类型占2行，+2是有两行合并
//Amount=new string[2,City.Count+County.Count,4];//用来保存变电工程，线路工程的和给Sheet10_4_1附表数据
string title = null;
obj.SheetName = Title;
obj.Columns.Count = IntColCount;
obj.Rows.Count = IntRowCount;
IntCol = obj.Columns.Count;
PF.Sheet_GridandCenter(obj);//画线，居中
S10_1.ColReadOnly(obj, IntColCount);
//obj.OperationMode = FarPoint.Win.Spread.OperationMode.ReadOnly;
string strTitle = "";
IntRow = 3;
strTitle = Title;
PF.CreateSheetView(obj, IntRow, IntCol, 0, 0, Title);
PF.SetSheetViewColumnsWidth(obj, 0, Title);
IntCol = 1;
//加载数据
this.WriteData(obj, IntRow + 2, IntCol - 1, Title);
strTitle = " 分区类型 ";
PF.CreateSheetView(obj, NextRowMerge += 1, NextColMerge, IntRow, IntCol -= 1, strTitle);
PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle);
strTitle = " 分区名称";
PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow, IntCol += 1, strTitle);
PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle);
strTitle = " 电压等级";
PF.CreateSheetView(obj, NextRowMerge -= 1, NextColMerge, IntRow, IntCol += 1, strTitle);
PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle);
strTitle = " (kV) ";
PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow += 1, IntCol, strTitle);
PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle);
strTitle = " 项 目";
PF.CreateSheetView(obj, NextRowMerge += 1, NextColMerge, IntRow -= 1, IntCol += 1, strTitle);
PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle);
strTitle = " 2010年";
PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow, IntCol += 1, strTitle);
PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle);
strTitle = " 2011年 ";
PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow, IntCol += 1, strTitle);
PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle);
strTitle = " 2012年 ";
PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow, IntCol += 1, strTitle);
PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle);
strTitle = " 2013年 ";
PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow, IntCol += 1, strTitle);
PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle);
strTitle = " 2014年 ";
PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow, IntCol += 1, strTitle);
PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle);
strTitle = " 2015年";
PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow, IntCol += 1, strTitle);
PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle);
strTitle = " “十二五”合计 ";
PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow, IntCol += 1, strTitle);
PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle);
NextRowMerge = 1;
NextColMerge = 1;
PF.SetWholeRowHeight(obj, obj.Rows.Count, obj.Columns.Count);//行高
}
public void Build_sheet(FarPoint.Win.Spread.SheetView obj_sheet)
{
//表格共行7 列
string con = " ProjectID='" + ProjectID + "|pro" + "' and ParentID='0'";
//查分类数
IList <Ps_Table_BuildPro> listTypes = Common.Services.BaseService.GetList <Ps_Table_BuildPro>("SelectPs_Table_BuildProByConn", con);
//表标题行数
int startrow = 3;
rowcount = startrow;
colcount = 7;
//工作表第一行的标题
//title = CityName+"市高压配电网已开展工程项目列表";
title = TC.GetTableTitle(this.GetType().Name);
sheetname = title;
int[] TableYearsAry = TC.GetTableYears(this.GetType().Name);
//工作表名
//sheetname = CityName + "市高压配电网已开展工程项目列表";
//int[] TableYearsAry = TC.GetTableYears(this.GetType().Name);
//设定工作表行列值及标题和表名
TC.Sheet_RowCol_Title_Name(obj_sheet, rowcount, colcount, title, sheetname);
//设定表格线
TC.Sheet_GridandCenter(obj_sheet);
//设定行列模式，以便写公式使用
TC.Sheet_Referen_R1C1(obj_sheet);
//设定表格列宽度
obj_sheet.Columns[0].Width = 60;
obj_sheet.Columns[1].Width = 190;
obj_sheet.Columns[2].Width = 60;
obj_sheet.Columns[3].Width = 60;
obj_sheet.Columns[4].Width = 90;
obj_sheet.Columns[5].Width = 60;
obj_sheet.Columns[6].Width = 60;
//设定表格行高度
obj_sheet.Rows[0].Height = 20;
obj_sheet.Rows[1].Height = 20;
obj_sheet.Rows[2].Height = 20;
//写标题行内容
//2行标题内容
obj_sheet.AddSpanCell(1, 0, 2, 1);
obj_sheet.SetValue(1, 0, "序号");
obj_sheet.AddSpanCell(1, 1, 2, 1);
obj_sheet.SetValue(1, 1, "项目名称");
obj_sheet.AddSpanCell(1, 2, 1, 2);
obj_sheet.SetValue(1, 2, "建设规模");
obj_sheet.AddSpanCell(1, 4, 2, 1);
obj_sheet.SetValue(1, 4, "所在区（县）");
obj_sheet.AddSpanCell(1, 5, 2, 1);
obj_sheet.SetValue(1, 5, "当前进度");
obj_sheet.AddSpanCell(1, 6, 2, 1);
obj_sheet.SetValue(1, 6, "投产年份");
//3行标题内容
obj_sheet.SetValue(2, 2, "线路长度");
obj_sheet.SetValue(2, 3, "变电容量");
//添加数据
Sheet_AddData(obj_sheet);
TC.Sheet_GridandCenter(obj_sheet);
//锁定表格
TC.Sheet_Locked(obj_sheet);
}
private void Firstadddata()
{
//生成表9-1
FarPoint.Win.Spread.SheetView Sheet91 = new FarPoint.Win.Spread.SheetView();
//生成表9-1附表52
FarPoint.Win.Spread.SheetView Sheet91_52 = new FarPoint.Win.Spread.SheetView();
//添加表9-1
fpSpread1.Sheets.Add(Sheet91);
//添加表9-1附表52
fpSpread1.Sheets.Add(Sheet91_52);
//创建表9-1
sh91.Build(Sheet91,ProjID, SxXjName);
//创建表9-1附表52
sh91_52.Build(Sheet91_52, ProjID);
fc.Sheet_Colautoenter(fpSpread1);
}
private void Firstadddata()
{
//生成表5-1
FarPoint.Win.Spread.SheetView Sheet51 = new FarPoint.Win.Spread.SheetView();
//生成表5-1附表32
FarPoint.Win.Spread.SheetView Sheet51_32 = new FarPoint.Win.Spread.SheetView();
//生成表5-2
FarPoint.Win.Spread.SheetView Sheet52 = new FarPoint.Win.Spread.SheetView();
//添加表5-1
fpSpread1.Sheets.Add(Sheet51);
//添加表5-1附表32
fpSpread1.Sheets.Add(Sheet51_32);
//添加5-2
fpSpread1.Sheets.Add(Sheet52);
//创建表5-1
sh51.Build(Sheet51,ProjID, SxXjName);
//创建表5-1附表32
sh51_32.Build(Sheet51_32, ProjID);
//创建表5-2
sh52.Build(Sheet52, ProjID, SxXjName);
fc.Sheet_Colautoenter(fpSpread1);
}
private void recreatsheetbydt(string title, System.Data.DataTable dt, Dictionary<string, Columqk> viscol, int sheetindex)
{
FarPoint.Win.Spread.SheetView Sheet1 = new FarPoint.Win.Spread.SheetView();
if (fpSpread1.Sheets.Count-1>=sheetindex)
{
Sheet1 = fpSpread1.Sheets[sheetindex];
}
else
{
Sheet1.SheetName = title;
fpSpread1.Sheets.Add(Sheet1);
}
if (Sheet1.Rows.Count>0)
{
Sheet1.RowCount = 0;
Sheet1.ColumnCount = 0;
}
Sheet1.Columns.Count = viscol.Count;
Sheet1.Rows.Count = dt.Rows.Count + 1;
//设表格线和居中
fc.Sheet_GridandCenter(Sheet1);
//设表格模式为R1C1
fc.Sheet_Referen_R1C1(Sheet1);
int visrowcount = 0;
if (dt.Rows.Count > 0)
{
foreach (KeyValuePair<string, Columqk> kp in viscol)
{
for (int j = 0; j < dt.Columns.Count; j++)
{
if (kp.Key == dt.Columns[j].ColumnName)
{
Sheet1.SetValue(0, visrowcount, viscol[dt.Columns[j].ColumnName].colname);
Sheet1.Columns[visrowcount].Width = 70;
if (viscol[dt.Columns[j].ColumnName].CellType == 1)
{
Sheet1.Columns[visrowcount].CellType = new FarPoint.Win.Spread.CellType.PercentCellType();
}
else if (viscol[dt.Columns[j].ColumnName].CellType == 2)
{
FarPoint.Win.Spread.CellType.NumberCellType newcelltype = new FarPoint.Win.Spread.CellType.NumberCellType();
newcelltype.DecimalPlaces = viscol[dt.Columns[j].ColumnName].weishu;
Sheet1.Columns[visrowcount].CellType = newcelltype;
}
for (int k = 0; k < dt.Rows.Count; k++)
{
Sheet1.SetValue(k + 1, visrowcount, dt.Rows[k][j].ToString());
}
visrowcount++;
}
}
}
//for (int i = 0; i < dt.Columns.Count; i++)
//{
// if (viscol.ContainsKey(dt.Columns[i].ColumnName))
// {
// Sheet1.SetValue(0, visrowcount, viscol[dt.Columns[i].ColumnName].colname);
// Sheet1.Columns[visrowcount].Width = 70;
// if (viscol[dt.Columns[i].ColumnName].CellType == 1)
// {
// Sheet1.Columns[visrowcount].CellType = new FarPoint.Win.Spread.CellType.PercentCellType();
// }
// else if (viscol[dt.Columns[i].ColumnName].CellType == 2)
// {
// FarPoint.Win.Spread.CellType.NumberCellType newcelltype = new FarPoint.Win.Spread.CellType.NumberCellType();
// newcelltype.DecimalPlaces = viscol[dt.Columns[i].ColumnName].weishu;
// Sheet1.Columns[visrowcount].CellType = newcelltype;
// }
// for (int j = 0; j < dt.Rows.Count; j++)
// {
// Sheet1.SetValue(j + 1, visrowcount, dt.Rows[j][i].ToString());
// }
// visrowcount++;
// }
//}
Sheet1.Rows[0].CellType = new FarPoint.Win.Spread.CellType.TextCellType();
}
//使表格只读
fc.Sheet_Locked(Sheet1);
}
/// <summary>
/// 设置单元格的类型
/// </summary>
/// <param name="obj"></param>
/// <param name="ICT"></param>
/// <param name="IntRow"></param>
/// <param name="IntCol"></param>
public void SetCellType(FarPoint.Win.Spread.SheetView obj, FarPoint.Win.Spread.CellType.ICellType ICT, int IntRow, int IntCol)
{
obj.Cells[IntRow, IntCol].CellType = ICT;
}
private void barBtnRefreshData_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
WaitDialogForm newwait = new WaitDialogForm("", "正在更新数据, 请稍候...");
//生成一个空表用来保存当前表
FarPoint.Win.Spread.SheetView obj_sheet = null;
//生成一个空表，行列值都设为0用来做为程序处理时的当前表，这样可以提高处理速度
FarPoint.Win.Spread.SheetView activesheet = new FarPoint.Win.Spread.SheetView();
activesheet.RowCount = 0;
activesheet.ColumnCount = 0;
//添加空表
fpSpread1.Sheets.Add(activesheet);
//保留当前表，以备程序结束后还原当前表
obj_sheet = fpSpread1.ActiveSheet;
//将空表设为当前表
fpSpread1.ActiveSheet = activesheet;
//更新表3-1
sh31.Sheet_AddData(fpSpread1.Sheets[0], year, ProjID, SxXjName);
sh31.CellType(fpSpread1.Sheets[0]);
//移除空表
fpSpread1.Sheets.Remove(activesheet);
//还原当前表
fpSpread1.ActiveSheet = obj_sheet;
//设文本自动换行
fc.Sheet_Colautoenter(fpSpread1);
newwait.Close();
MessageBox.Show("更新数据完成！");
}
/// <summary>
/// 设置sheet_1的年份
/// </summary>
/// <param name="obj">对象</param>
/// <param name="firstyear">起始年份</param>
/// <param name="endyear">结束年份</param>
/// <param name="YearsCount">要显示几年的数据</param>
/// <param name="IntRow">要写入的起始行数</param>
/// <param name="IntCol">要写入的起始列数</param>
/// <param name="RowStep">要合并单元格行的数量</param>
/// <param name="ColStep">要合并单元格列的数量</param>
private void SetYearsSheet2_1(Itop.Client.Base.FormBase FB, FarPoint.Win.Spread.SheetView obj, int firstyear, int endyear, int YearsCount, int IntRow, int IntCol, int RowStep, int ColStep)
{
GolobalYears = 0;
string Title = null;
string Title1 = "";
string SingleTitle = "全地区GDP（亿元）";
int TempYear = firstyear;
for (int i = IntRow; i < ((YearsCount + IntRow)); i++)
{
if ((YearsCount + IntRow - 2) == i)
{
Title = "“十五”年均增长率";
PF.CreateSheetView(obj, RowStep, ColStep, ((i - GolobalYears)), IntCol, Title);
//PF.SetRowHight(obj, ((i - GolobalYears)), IntCol, Title);
FifteenYears(obj, (i - GolobalYears), IntCol);
}
else if ((YearsCount + IntRow - 1) == i)
{
if (TempYear < 2011) //这里写2011要注意
{
Title = "2006-2009年均增长率";
ElevenFiveYear(obj, Title, (i - GolobalYears), IntCol);
}
else
{
Title = "“十一五”年均增长率";
ElevenFiveYear(obj, Title, (i - GolobalYears), IntCol);
}
PF.CreateSheetView(obj, RowStep, ColStep, ((i - GolobalYears)), IntCol, Title);
PF.SetSheetViewColumnsWidth(obj, IntCol, Title1);
//PF.SetRowHight(obj, ((i - GolobalYears)), IntCol, Title);
}
else
{
Title = TempYear + " 年";
if (TempYear != 2001 && TempYear != 2002 && TempYear != 2003 && TempYear != 2004)
{
PF.CreateSheetView(obj, RowStep, ColStep, ((i - GolobalYears)), IntCol, Title);
Title1 = "一产";
SingleTitle = "全地区GDP（亿元）";
ViewSheet2_1Data(obj, Title1, FB, TempYear, ((i - GolobalYears)), (IntCol + 1), SingleTitle);
SetCellType(obj, PC, (i - GolobalYears), IntCol + 1);
//PF.SetRowHight(obj, ((i - GolobalYears)), IntCol+1, Title);
Title1 = "二产";
ViewSheet2_1Data(obj, Title1, FB, TempYear, ((i - GolobalYears)), (IntCol + 2), SingleTitle);
SetCellType(obj, PC, (i - GolobalYears), IntCol + 2);
Title1 = "三产";
ViewSheet2_1Data(obj, Title1, FB, TempYear, ((i - GolobalYears)), (IntCol + 3), SingleTitle);
SetCellType(obj, PC, (i - GolobalYears), IntCol + 3);
SingleTitle = "";
Title1 = "城镇人口（万人）";
ViewSheet2_1Data(obj, Title1, FB, TempYear, ((i - GolobalYears)), (IntCol + 6), SingleTitle);
//PF.SetRowHight(obj, ((i - GolobalYears)), (IntCol + 6), Title1);
Title1 = "乡村人口（万人）";
ViewSheet2_1Data(obj, Title1, FB, TempYear, ((i - GolobalYears)), (IntCol + 7), SingleTitle);
//PF.SetRowHight(obj, ((i - GolobalYears)), (IntCol + 6), Title1);
Title1 = "年末总人口（万人）";
AccountPopulation(obj, TempYear, ((i - GolobalYears)), (IntCol + 4));
//PF.SetRowHight(obj, ((i - GolobalYears)), (IntCol + 6), Title1);
Title1 = "人均GDP（万元/人）";
PerCapitaGDP(obj, FB, Title1, TempYear, ((i - GolobalYears)), (IntCol + 5));
//PF.SetRowHight(obj, ((i - GolobalYears)), (IntCol + 6), Title1);
Title1 = "城镇化率（%）";
AccountUrbanizationRate(obj, TempYear, ((i - GolobalYears)), (IntCol + 8));
SetCellType(obj, PC, (i - GolobalYears), IntCol + 8);
//PF.SetRowHight(obj, ((i - GolobalYears)), (IntCol + 8), Title1);
}
else
{
GolobalYears += 1; //年份没有数据的总和
}
resualt.Clear();
++TempYear;
}
}
}
private void barBtnRefrehData_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
WaitDialogForm newwait=new WaitDialogForm("", "正在更新数据, 请稍候...");
//清空原有sheet的数据，但保留sheetname
fc.SpreadClearSheet(fpSpread1);
//生成一个空表用来保存当前表
FarPoint.Win.Spread.SheetView obj_sheet = null;
//生成一个空表，行列值都设为0用来做为程序处理时的当前表，这样可以提高处理速度
FarPoint.Win.Spread.SheetView activesheet = new FarPoint.Win.Spread.SheetView();
activesheet.RowCount = 0;
activesheet.ColumnCount = 0;
//添加空表
fpSpread1.Sheets.Add(activesheet);
//保留当前表，以备程序结束后还原当前表
obj_sheet = fpSpread1.ActiveSheet;
//将空表设为当前表
fpSpread1.ActiveSheet = activesheet;
build_sheet71(fpSpread1.Sheets[0]);
build_Sheet72(fpSpread1.Sheets[1]);
build_Sheet72_36(fpSpread1.Sheets[2]);
build_Sheet73(fpSpread1.Sheets[3]);
build_Sheet73_37(fpSpread1.Sheets[4]);
build_Sheet74(fpSpread1.Sheets[5]);
build_Sheet74_38(fpSpread1.Sheets[6]);
build_Sheet75(fpSpread1.Sheets[7]);
build_Sheet75_39(fpSpread1.Sheets[8]);
build_Sheet76(fpSpread1.Sheets[9]);
build_Sheet76_40(fpSpread1.Sheets[10]);
build_Sheet77(fpSpread1.Sheets[11]);
build_Sheet78(fpSpread1.Sheets[12]);
build_Sheet79(fpSpread1.Sheets[13]);
//移除空表
fpSpread1.Sheets.Remove(activesheet);
//还原当前表
fpSpread1.ActiveSheet = obj_sheet;
newwait.Close();
MessageBox.Show("更新数据完成！");
}
private void Sheet_AddData(FarPoint.Win.Spread.SheetView obj_sheet, string ProjID, IList <string> SXareaid_List, IList <string> XJareaid_List)
{
int startrow = 3;
string tiaojian = "";
string areaname = "";
int xjrow = 0;
int nowrow = startrow;
for (int i = 0; i < SXareaid_List.Count; i++)
{
areaname = SXareaid_List[i].ToString();
tiaojian = " AreaID='" + ProjID + "' and (S10='水电' or S10='煤电') and CAST(S1 as int) between 10 and 110 and S3!='' and S5='市辖供电区' and S9='" + areaname + "'";
IList <PSP_PowerSubstation_Info> GDClist = Services.BaseService.GetList <PSP_PowerSubstation_Info>("SelectPSP_PowerSubstation_InfoListByWhere", tiaojian);
obj_sheet.AddSpanCell(nowrow, 1, GDClist.Count, 1);
obj_sheet.SetValue(nowrow, 1, areaname);
for (int j = 0; j < GDClist.Count; j++)
{
//电厂名称
obj_sheet.SetValue(nowrow, 2, GDClist[j].Title);
//电厂类型
obj_sheet.SetValue(nowrow, 3, GDClist[j].S10);
//并网电压等级(kV)
obj_sheet.SetValue(nowrow, 4, GDClist[j].S1);
int year = 0;
if (GDClist[j].S3 != "")
{
year = int.Parse(GDClist[j].S3);
}
if (year != 0)
{
if (year <= 2010)
{
double ZJRL = 0;
if (GDClist[j].S2 != "")
{
ZJRL = double.Parse(GDClist[j].S2);
}
obj_sheet.SetValue(nowrow, 5, ZJRL);
}
else if (2016 <= year && year <= 2020)
{
double ZJRL = 0;
if (GDClist[j].S2 != "")
{
ZJRL = double.Parse(GDClist[j].S2);
}
obj_sheet.SetValue(nowrow, 11, ZJRL);
}
else
{
double ZJRL = 0;
if (GDClist[j].S2 != "")
{
ZJRL = double.Parse(GDClist[j].S2);
}
obj_sheet.SetValue(nowrow, year - 2005, ZJRL);
}
}
nowrow += 1;
}
}
if (SXareaid_List.Count > 0)
{
obj_sheet.AddSpanCell(startrow, 0, nowrow - startrow, 1);
obj_sheet.SetValue(startrow, 0, "市辖供电区");
}
xjrow = nowrow;;
for (int i = 0; i < XJareaid_List.Count; i++)
{
areaname = XJareaid_List[i].ToString();
tiaojian = " AreaID='" + ProjID + "' and (S10='水电' or S10='煤电') and CAST(S1 as int) between 10 and 110 and S3!='' and S5!='市辖供电区' and S9='" + areaname + "'";
IList <PSP_PowerSubstation_Info> GDClist = Services.BaseService.GetList <PSP_PowerSubstation_Info>("SelectPSP_PowerSubstation_InfoListByWhere", tiaojian);
obj_sheet.AddSpanCell(nowrow, 1, GDClist.Count, 1);
obj_sheet.SetValue(nowrow, 1, areaname);
for (int j = 0; j < GDClist.Count; j++)
{
//电厂名称
obj_sheet.SetValue(nowrow, 2, GDClist[j].Title);
//电厂类型
obj_sheet.SetValue(nowrow, 3, GDClist[j].S10);
//并网电压等级(kV)
obj_sheet.SetValue(nowrow, 4, GDClist[j].S1);
int year = 0;
if (GDClist[j].S3 != "")
{
year = int.Parse(GDClist[j].S3);
}
if (year != 0)
{
if (year <= 2010)
{
double ZJRL = 0;
if (GDClist[j].S2 != "")
{
ZJRL = double.Parse(GDClist[j].S2);
}
obj_sheet.SetValue(nowrow, 5, ZJRL);
}
else if (2016 <= year && year <= 2020)
{
double ZJRL = 0;
if (GDClist[j].S2 != "")
{
ZJRL = double.Parse(GDClist[j].S2);
}
obj_sheet.SetValue(nowrow, 11, ZJRL);
}
else
{
double ZJRL = 0;
if (GDClist[j].S2 != "")
{
ZJRL = double.Parse(GDClist[j].S2);
}
obj_sheet.SetValue(nowrow, year - 2005, ZJRL);
}
}
nowrow += 1;
}
}
if (XJareaid_List.Count > 0)
{
obj_sheet.AddSpanCell(xjrow, 0, nowrow - xjrow, 1);
obj_sheet.SetValue(xjrow, 0, "县级供电区");
}
}
private void Sheet_AddData(FarPoint.Win.Spread.SheetView obj_sheet, int year, string ProjID, List <string[]> SxXjName, IList <double> obj_DY_List)
{
//添加数据
//条件
string GorZ = "";
string tiaojian = "";
int startrow = 3;
int dylenth = obj_DY_List.Count;
int colcount = 7;
for (int i = 0; i < SxXjName.Count; i++)
{
//合计部分不用计算
if (SxXjName[i][2].ToString() != "合计")
{
for (int j = 0; j < obj_DY_List.Count; j++)
{
//一次算公用一次算专用
for (int k = 0; k < 2; k++)
{
if (k == 0)
{
GorZ = "公用";
}
else
{
GorZ = "专用";
}
//配电室内主变台数
tiaojian = " b.OperationYear!='' and year(cast(b.OperationYear as datetime))<=" + year + " and b.ProjectID='" + ProjID + "' and b.Type='50' and a.LineType2='" + GorZ + "' and a.DQ='" + SxXjName[i][2] + "' and b.RateVolt=" + obj_DY_List[j];
int PDsum = 0;
if (Services.BaseService.GetObject("SelectPSPDEV_SUMFlag", tiaojian) != null)
{
PDsum = (int)Services.BaseService.GetObject("SelectPSPDEV_SUMFlag", tiaojian);
}
//箱变座数 柱上变（台）
tiaojian = " b.OperationYear!='' and year(cast(b.OperationYear as datetime))<=" + year + " and b.ProjectID='" + ProjID + "' and (b.Type='51' or b.Type='52') and a.LineType2='" + GorZ + "' and a.DQ='" + SxXjName[i][2] + "' and b.RateVolt=" + obj_DY_List[j];
int XBsum = 0;
if (Services.BaseService.GetObject("SelectPSPDEV_Count_type50-59", tiaojian) != null)
{
XBsum = (int)Services.BaseService.GetObject("SelectPSPDEV_Count_type50-59", tiaojian);
}
//配变台数等于这三个数据和
obj_sheet.SetValue(startrow + i * dylenth + j, 3 + k * 2, PDsum + XBsum);
//配变容量
tiaojian = " b.OperationYear!='' and year(cast(b.OperationYear as datetime))<=" + year + " and b.ProjectID='" + ProjID + "' and (b.Type='50' or b.Type='51' or b.Type='52') and a.LineType2='" + GorZ + "' and a.DQ='" + SxXjName[i][2] + "' and b.RateVolt=" + obj_DY_List[j];
double PBRLsum = 0;
if (Services.BaseService.GetObject("SelectPSPDEV_SUMNum2_type50-59", tiaojian) != null)
{
PBRLsum = (double)Services.BaseService.GetObject("SelectPSPDEV_SUMNum2_type50-59", tiaojian);
}
obj_sheet.SetValue(startrow + i * dylenth + j, 4 + k * 2, PBRLsum);
}
}
}
else
{
//县级合计部分公式
if (i == 1)
{
fc.Sheet_WriteFormula_RowSum(obj_sheet, startrow + (i + 1) * dylenth, 3, 4, dylenth, startrow + i * dylenth, 3, colcount);
}
//全地区合计部分公式
else
{
fc.Sheet_WriteFormula_RowSum(obj_sheet, startrow, 3, 2, dylenth, startrow + i * dylenth, 3, colcount);
}
}
}
}
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.components = new System.ComponentModel.Container();
FarPoint.Win.Spread.TipAppearance tipAppearance1 = new FarPoint.Win.Spread.TipAppearance();
System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(frmQueryMessage));
this.groupBox1 = new System.Windows.Forms.GroupBox();
this.groupBox3 = new System.Windows.Forms.GroupBox();
this.radioButton2 = new System.Windows.Forms.RadioButton();
this.radioButton1 = new System.Windows.Forms.RadioButton();
this.groupBox2 = new System.Windows.Forms.GroupBox();
this.dateTimePicker2 = new System.Windows.Forms.DateTimePicker();
this.dateTimePicker1 = new System.Windows.Forms.DateTimePicker();
this.label1 = new System.Windows.Forms.Label();
this.label3 = new System.Windows.Forms.Label();
this.comboBox1 = new Neusoft.FrameWork.WinForms.Controls.NeuComboBox(this.components);
this.textBox1 = new System.Windows.Forms.TextBox();
this.label4 = new System.Windows.Forms.Label();
this.fpSpread1 = new FarPoint.Win.Spread.FpSpread();
this.fpSpread1_Sheet1 = new FarPoint.Win.Spread.SheetView();
this.toolBar1 = new System.Windows.Forms.ToolBar();
this.toolBarButton1 = new System.Windows.Forms.ToolBarButton();
this.toolBarButton2 = new System.Windows.Forms.ToolBarButton();
this.toolBarButton4 = new System.Windows.Forms.ToolBarButton();
this.toolBarButton3 = new System.Windows.Forms.ToolBarButton();
this.imageList1 = new System.Windows.Forms.ImageList(this.components);
this.groupBox1.SuspendLayout();
this.groupBox2.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.fpSpread1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.fpSpread1_Sheet1)).BeginInit();
this.SuspendLayout();
//
// groupBox1
//
this.groupBox1.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Left)
| System.Windows.Forms.AnchorStyles.Right)));
this.groupBox1.Controls.Add(this.groupBox3);
this.groupBox1.Controls.Add(this.radioButton2);
this.groupBox1.Controls.Add(this.radioButton1);
this.groupBox1.Controls.Add(this.groupBox2);
this.groupBox1.Location = new System.Drawing.Point(8, 40);
this.groupBox1.Name = "groupBox1";
this.groupBox1.Size = new System.Drawing.Size(712, 115);
this.groupBox1.TabIndex = 0;
this.groupBox1.TabStop = false;
//
// groupBox3
//
this.groupBox3.Location = new System.Drawing.Point(363, 18);
this.groupBox3.Name = "groupBox3";
this.groupBox3.Size = new System.Drawing.Size(333, 81);
this.groupBox3.TabIndex = 10;
this.groupBox3.TabStop = false;
this.groupBox3.Text = "本人发通知查询";
//
// radioButton2
//
this.radioButton2.Location = new System.Drawing.Point(347, 22);
this.radioButton2.Name = "radioButton2";
this.radioButton2.Size = new System.Drawing.Size(21, 24);
this.radioButton2.TabIndex = 9;
//
// radioButton1
//
this.radioButton1.Checked = true;
this.radioButton1.Location = new System.Drawing.Point(8, 24);
this.radioButton1.Name = "radioButton1";
this.radioButton1.Size = new System.Drawing.Size(13, 20);
this.radioButton1.TabIndex = 8;
this.radioButton1.TabStop = true;
//
// groupBox2
//
this.groupBox2.Controls.Add(this.dateTimePicker2);
this.groupBox2.Controls.Add(this.dateTimePicker1);
this.groupBox2.Controls.Add(this.label1);
this.groupBox2.Controls.Add(this.label3);
this.groupBox2.Controls.Add(this.comboBox1);
this.groupBox2.Controls.Add(this.textBox1);
this.groupBox2.Location = new System.Drawing.Point(24, 19);
this.groupBox2.Name = "groupBox2";
this.groupBox2.Size = new System.Drawing.Size(306, 80);
this.groupBox2.TabIndex = 7;
this.groupBox2.TabStop = false;
this.groupBox2.Text = "科室统计";
//
// dateTimePicker2
//
this.dateTimePicker2.CustomFormat = "yyyy-MM-dd 23:59:59";
this.dateTimePicker2.Format = System.Windows.Forms.DateTimePickerFormat.Custom;
this.dateTimePicker2.Location = new System.Drawing.Point(200, 16);
this.dateTimePicker2.Name = "dateTimePicker2";
this.dateTimePicker2.Size = new System.Drawing.Size(90, 21);
this.dateTimePicker2.TabIndex = 2;
//
// dateTimePicker1
//
this.dateTimePicker1.CustomFormat = "yyyy-MM-dd 00:00:00";
this.dateTimePicker1.Format = System.Windows.Forms.DateTimePickerFormat.Custom;
this.dateTimePicker1.Location = new System.Drawing.Point(88, 16);
this.dateTimePicker1.Name = "dateTimePicker1";
this.dateTimePicker1.Size = new System.Drawing.Size(88, 21);
this.dateTimePicker1.TabIndex = 1;
//
// label1
//
this.label1.Location = new System.Drawing.Point(8, 24);
this.label1.Name = "label1";
this.label1.Size = new System.Drawing.Size(72, 16);
this.label1.TabIndex = 0;
this.label1.Text = "通知时间：";
//
// label3
//
this.label3.Location = new System.Drawing.Point(13, 47);
this.label3.Name = "label3";
this.label3.Size = new System.Drawing.Size(72, 23);
this.label3.TabIndex = 5;
this.label3.Text = "接收科室：";
//
// comboBox1
//
this.comboBox1.ArrowBackColor = System.Drawing.Color.Silver;
this.comboBox1.IsEnter2Tab = false;
this.comboBox1.IsFlat = false;
this.comboBox1.IsLike = true;
this.comboBox1.Location = new System.Drawing.Point(94, 43);
this.comboBox1.Name = "comboBox1";
this.comboBox1.PopForm = null;
this.comboBox1.ShowCustomerList = false;
this.comboBox1.ShowID = false;
this.comboBox1.Size = new System.Drawing.Size(96, 20);
this.comboBox1.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D;
this.comboBox1.TabIndex = 4;
this.comboBox1.Tag = "";
this.comboBox1.ToolBarUse = false;
this.comboBox1.SelectedIndexChanged += new System.EventHandler(this.comboBox1_SelectedIndexChanged);
//
// textBox1
//
this.textBox1.BackColor = System.Drawing.SystemColors.Control;
this.textBox1.BorderStyle = System.Windows.Forms.BorderStyle.None;
this.textBox1.Font = new System.Drawing.Font("宋体", 15F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
this.textBox1.Location = new System.Drawing.Point(182, 16);
this.textBox1.Name = "textBox1";
this.textBox1.Size = new System.Drawing.Size(20, 23);
this.textBox1.TabIndex = 9;
this.textBox1.Text = "-";
//
// label4
//
this.label4.AutoSize = true;
this.label4.ForeColor = System.Drawing.Color.Red;
this.label4.Location = new System.Drawing.Point(16, 159);
this.label4.Name = "label4";
this.label4.Size = new System.Drawing.Size(137, 12);
this.label4.TabIndex = 6;
this.label4.Text = "粉色代表没有处理的通知";
//
// fpSpread1
//
this.fpSpread1.About = "2.5.2007.2005";
this.fpSpread1.AccessibleDescription = "fpSpread1";
this.fpSpread1.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom)
| System.Windows.Forms.AnchorStyles.Left)
| System.Windows.Forms.AnchorStyles.Right)));
this.fpSpread1.Location = new System.Drawing.Point(8, 176);
this.fpSpread1.Name = "fpSpread1";
this.fpSpread1.Sheets.AddRange(new FarPoint.Win.Spread.SheetView[] {
this.fpSpread1_Sheet1
});
this.fpSpread1.Size = new System.Drawing.Size(704, 232);
this.fpSpread1.TabIndex = 1;
tipAppearance1.BackColor = System.Drawing.SystemColors.Info;
tipAppearance1.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
tipAppearance1.ForeColor = System.Drawing.SystemColors.InfoText;
this.fpSpread1.TextTipAppearance = tipAppearance1;
this.fpSpread1.CellDoubleClick += new FarPoint.Win.Spread.CellClickEventHandler(this.fpSpread1_CellDoubleClick);
this.fpSpread1_Sheet1.Reset();
this.fpSpread1_Sheet1.SheetName = "Sheet1";
// Formulas and custom names must be loaded with R1C1 reference style
this.fpSpread1_Sheet1.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.R1C1;
this.fpSpread1_Sheet1.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.A1;
//
// toolBar1
//
this.toolBar1.Appearance = System.Windows.Forms.ToolBarAppearance.Flat;
this.toolBar1.Buttons.AddRange(new System.Windows.Forms.ToolBarButton[] {
this.toolBarButton1,
this.toolBarButton2,
this.toolBarButton4,
this.toolBarButton3
});
this.toolBar1.DropDownArrows = true;
this.toolBar1.ImageList = this.imageList1;
this.toolBar1.Location = new System.Drawing.Point(0, 0);
this.toolBar1.Name = "toolBar1";
this.toolBar1.ShowToolTips = true;
this.toolBar1.Size = new System.Drawing.Size(720, 41);
this.toolBar1.TabIndex = 2;
this.toolBar1.ButtonClick += new System.Windows.Forms.ToolBarButtonClickEventHandler(this.toolBar1_ButtonClick);
//
// toolBarButton1
//
this.toolBarButton1.ImageIndex = 0;
this.toolBarButton1.Name = "toolBarButton1";
this.toolBarButton1.Text = "查询";
//
// toolBarButton2
//
this.toolBarButton2.ImageIndex = 1;
this.toolBarButton2.Name = "toolBarButton2";
this.toolBarButton2.Style = System.Windows.Forms.ToolBarButtonStyle.Separator;
//
// toolBarButton4
//
this.toolBarButton4.ImageIndex = 0;
this.toolBarButton4.Name = "toolBarButton4";
this.toolBarButton4.Style = System.Windows.Forms.ToolBarButtonStyle.Separator;
//
// toolBarButton3
//
this.toolBarButton3.ImageIndex = 1;
this.toolBarButton3.Name = "toolBarButton3";
this.toolBarButton3.Text = "退出";
//
// imageList1
//
this.imageList1.ImageStream = ((System.Windows.Forms.ImageListStreamer)(resources.GetObject("imageList1.ImageStream")));
this.imageList1.TransparentColor = System.Drawing.Color.Transparent;
this.imageList1.Images.SetKeyName(0, "退出.bmp");
this.imageList1.Images.SetKeyName(1, "查找.bmp");
//
// frmQueryMessage
//
this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
this.BackColor = System.Drawing.Color.White;
this.ClientSize = new System.Drawing.Size(720, 422);
this.Controls.Add(this.toolBar1);
this.Controls.Add(this.fpSpread1);
this.Controls.Add(this.groupBox1);
this.Controls.Add(this.label4);
this.Name = "frmQueryMessage";
this.Text = "查询通知信息";
this.WindowState = System.Windows.Forms.FormWindowState.Maximized;
this.Load += new System.EventHandler(this.QueryMessage_Load);
this.groupBox1.ResumeLayout(false);
this.groupBox2.ResumeLayout(false);
this.groupBox2.PerformLayout();
((System.ComponentModel.ISupportInitialize)(this.fpSpread1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.fpSpread1_Sheet1)).EndInit();
this.ResumeLayout(false);
this.PerformLayout();
}
private void Sheet_AddItem(FarPoint.Win.Spread.SheetView obj_sheet, Hashtable area_key_id, IList <double> obj_DY_List, IList <string> SXareaid_List, IList <string> XJareaid_List)
{
}
//////////////////////////////////////////////////////////////////////////
/// <summary>
/// 填写表头
/// </summary>
/// <param name="obj"></param>
/// <param name="Title"></param>
public void SetSheet_4Title(Itop.Client.Base.FormBase FB, FarPoint.Win.Spread.SheetView obj, string Title)
{
SelectPW(FB, strYear);
int IntColCount = 9;
int IntRowCount = list.Count + 2 + 3;//标题占3行，分区类型占2行，1是其它用
string title = null;
obj.SheetName = Title;
obj.Columns.Count = IntColCount;
obj.Rows.Count = IntRowCount;
IntCol = obj.Columns.Count;
PF.Sheet_GridandCenter(obj);//画边线，居中
S10_1.ColReadOnly(obj, IntColCount);
//obj.OperationMode = FarPoint.Win.Spread.OperationMode.ReadOnly;
string strTitle = "";
IntRow = 3;
strTitle = Title;
PF.CreateSheetView(obj, IntRow, IntCol, 0, 0, Title);
PF.SetSheetViewColumnsWidth(obj, 0, Title);
IntCol = 1;
strTitle = " 序 号";
PF.CreateSheetView(obj, NextRowMerge += 1, NextColMerge, IntRow, IntCol -= 1, strTitle);
PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle);
strTitle = " 电压等级(kV)s";
PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow, IntCol += 1, strTitle);
PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle);
strTitle = " 线路名称";
PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow, IntCol += 1, strTitle);
PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle);
strTitle = " 起点变电站名 ";
PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow, IntCol += 1, strTitle);
PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle);
strTitle = " 终点变电站名 ";
PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow, IntCol += 1, strTitle);
PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle);
strTitle = " 导线型号";
PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow, IntCol += 1, strTitle);
PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle);
strTitle = " 线路长度（km）";
PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow, IntCol += 1, strTitle);
PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle);
strTitle = " 投运时间";
PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow, IntCol += 1, strTitle);
PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle);
strTitle = " 所在分区";
PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow, IntCol += 1, strTitle);
PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle);
NextRowMerge = 1;
NextColMerge = 1;
IntRow = 5;
IntCol = 0;
WriteData(FB, obj, IntRow, IntCol);
PF.SetWholeRowHeight(obj, obj.Rows.Count, obj.Columns.Count);//行高
}
/// <summary>
/// 写入数据
/// </summary>
/// <param name="obj"></param>
/// <param name="IntRow"></param>
/// <param name="IntCol"></param>
private void WriteData(FarPoint.Win.Spread.SheetView obj, int IntRow, int IntCol)
{
string strTitle = null;
string strDQ = null;
for (int i = IntRow; i < obj.RowCount; ++i)
{
strTitle = (string)PF.ReturnStr(obj, i, 0);
strDQ = (string)PF.ReturnStr(obj, i, 1);
for (int j = 2; j < obj.ColumnCount; ++j)
{
switch (j)
{
case 2:
if (strTitle == "县级供电区")
{
obj.SetValue(i, j, SelectData(2010, programID, strDQ, CountyID));
}
if (strTitle == "市辖供电区")
{
obj.SetValue(i, j, SelectData(2010, programID, strDQ, CityID));
}
break;
case 3:
if (strTitle == "县级供电区")
{
obj.SetValue(i, j, SelectData(2011, programID, strDQ, CountyID));
}
if (strTitle == "市辖供电区")
{
obj.SetValue(i, j, SelectData(2011, programID, strDQ, CityID));
}
break;
case 4:
if (strTitle == "县级供电区")
{
obj.SetValue(i, j, SelectData(2012, programID, strDQ, CountyID));
}
if (strTitle == "市辖供电区")
{
obj.SetValue(i, j, SelectData(2012, programID, strDQ, CityID));
}
break;
case 5:
if (strTitle == "县级供电区")
{
obj.SetValue(i, j, SelectData(2013, programID, strDQ, CountyID));
}
if (strTitle == "市辖供电区")
{
obj.SetValue(i, j, SelectData(2013, programID, strDQ, CityID));
}
break;
case 6:
if (strTitle == "县级供电区")
{
obj.SetValue(i, j, SelectData(2014, programID, strDQ, CountyID));
}
if (strTitle == "市辖供电区")
{
obj.SetValue(i, j, SelectData(2014, programID, strDQ, CityID));
}
break;
case 7:
if (strTitle == "县级供电区")
{
obj.SetValue(i, j, SelectData(2015, programID, strDQ, CountyID));
}
if (strTitle == "市辖供电区")
{
obj.SetValue(i, j, SelectData(2015, programID, strDQ, CityID));
}
break;
case 8:
obj.Cells[i, j].Formula = "POWER(H" + (i + 1) + " / C" + (i + 1) + ", 1 / 5) - 1";
break;
case 9:
if (strTitle == "县级供电区")
{
obj.SetValue(i, j, SelectData(2020, programID, strDQ, CountyID));
}
if (strTitle == "市辖供电区")
{
obj.SetValue(i, j, SelectData(2020, programID, strDQ, CityID));
}
break;
case 10:
obj.Cells[i, j].Formula = "POWER(J" + (i + 1) + " / H" + (i + 1) + ", 1 / 5) - 1";
break;
default:
break;
}
}
}
}
/// <summary>
/// 按照起始和结束年份写入列标题
/// </summary>
/// <param name="BeginYear"></param>
/// <param name="EndYear"></param>
public void SetColumnsTitle(Itop.Client.Base.FormBase FB, FarPoint.Win.Spread.SheetView obj, int BeginYear, int EndYear)
{
int intTemp = BeginYear;
Redraw(obj, BeginYear, EndYear);
for (int i = BeginYear; i <= (EndYear + list.Count); ++i)
{
obj.AddSpanCell(4, (i - BeginYear + 1), 2, 1);
//if(i!=EndYear+list.Count)//和下面eles对应
//{
obj.SetValue(4, (i - BeginYear + 1), intTemp);
if (i == 2006)
{
obj.SetValue(4, (i - BeginYear + 1), "“十五”年均增速");
intTemp--;
}
if (i == (2011 + 1))//中间空一行所以加一
{
obj.SetValue(4, (i - BeginYear + 1), "“十一五”年均增速");
intTemp--;
}
if (i == (2016 + 2))
{
obj.SetValue(4, (i - BeginYear + 1), "“十二五”年均增速");
intTemp--;
}
if (i == (2021 + 3))
{
obj.SetValue(4, (i - BeginYear + 1), "“十三五”年均增速");
intTemp--;
}
//}
//else//这是预计的列现在先不用
//{
// if (i != 2006 && i != (2011 + 1) && i != (2016 + 2) && i != (2021 + 3))
// {
// obj.SetValue(4, (i - BeginYear + 1), intTemp + "预计");
// }
// else
// {
// if (i == 2006)
// {
// obj.SetValue(4, (i - BeginYear + 1), "“十五”年均增速");
// intTemp--;
// }
// if (i == (2011 + 1))//中间空一行所以加一
// {
// obj.SetValue(4, (i - BeginYear + 1), "“十一五”年均增速");
// intTemp--;
// }
// if (i == (2016 + 2))
// {
// obj.SetValue(4, (i - BeginYear + 1), "“十二五”年均增速");
// intTemp--;
// }
// if (i == (2021 + 3))
// {
// obj.SetValue(4, (i - BeginYear + 1), "“十三五”年均增速");
// intTemp--;
// }
// }
//}
intTemp++;
}
list.Clear();
WriteData(FB, obj);
}
/// <summary>
/// 写入数据
/// </summary>
private void WriteData(FarPoint.Win.Spread.SheetView obj, int IntRow, int IntCol, string Title)
{
//int CityCount= AreaTitle("市辖供电区");
SA.VoltageClass = new string[VCCount];
for (int i = 0; i < VCCount; ++i)
{
if (i == 0)
{
SA.VoltageClass[i] = "110(66)";
}
if (i == 1)
{
SA.VoltageClass[i] = "35";
}
if (i == 2)
{
SA.VoltageClass[i] = "10(6、20)";
}
}
//MessageBox.Show(obj.RowCount.ToString());
//int CountyCount=AreaTitle("县级供电区");
for (int i = 0; i < 2; ++i) //两个分区类型
{
if (i == 0)
{
PF.CreateSheetView(obj, (SA.CityCount + 1) * VPCount, 1, IntRow + i, IntCol, "市辖供电区");
}
else
{
PF.CreateSheetView(obj, (SA.SumCountyCount + 1) * VPCount, 1, IntRow + i * (SA.CityCount + 1) * VPCount, IntCol, "县级供电区");
}
for (int j = 0; j < (SA.CityCount + 1); ++j) //+2是有两个合计,市
{
for (int c = 0; c < VCCount; ++c)
{
PF.CreateSheetView(obj, 2, 1, (IntRow + c * (VCCount - 1)) + j * VPCount, IntCol + 2, SA.VoltageClass[c]); //电压等级
}
if (i == 0)
{
if (j == 0)
{
PF.CreateSheetView(obj, VPCount, 1, IntRow + j * VPCount, IntCol + 1, "合计"); //分区名称
}
else
{
PF.CreateSheetView(obj, VPCount, 1, IntRow + j * VPCount, IntCol + 1, this.City[j - 1].ToString());
}
}
}
for (int j = 0; j < (SA.SumCountyCount + 1); ++j) //县辖供电区
{
for (int c = 0; c < VCCount; ++c)
{
PF.CreateSheetView(obj, 2, 1, (IntRow + c * (VCCount - 1)) + j * VPCount + (SA.CityCount + 1) * VPCount, IntCol + 2, SA.VoltageClass[c]); //电压等级
}
if (j == 0)
{
PF.CreateSheetView(obj, VPCount, 1, (IntRow + j * VPCount + (SA.CityCount + 1) * VPCount), IntCol + 1, "合计");
}
else
{
PF.CreateSheetView(obj, VPCount, 1, (IntRow + j * VPCount + (SA.CityCount + 1) * VPCount), IntCol + 1, this.County[j - 1].ToString());
}
}
}
int year = 2010;
double Amount = 0;
string strColTitle = null;
string TempDQ = null; //地区
string DQType = null; //地区类型
//写入项目及以后的列
for (int i = 0; i < (SA.SumCountyCount + 1 + (SA.CityCount + 1)); ++i)
{
for (int j = 0; j < VPCount; ++j) //项目
{
year = 2010;
for (int col = 4; col < obj.ColumnCount; ++col) //数据
{
if (i != 0 && i != SA.CityCount + 1)
{
switch (j)
{
case 0: //
PF.CreateSheetView(obj, 1, 1, (IntRow + i * VPCount + j), IntCol + 3, "变电工程");
TempDQ = (ReturnNext0fStr(obj, (IntRow + i * VPCount + j), (IntCol + 1), j + 1, 1));
if (i >= 1 + SA.CityCount) //总体行数减去市辖地区的数量就是县级地区
{
DQType = ReturnNext0fStr(obj, (IntRow + i * VPCount + j), (IntCol), (i * VPCount + j + 1 - SA.CityCount * VPCount), 1);
}
else
{
DQType = ReturnNext0fStr(obj, (IntRow + i * VPCount + j), (IntCol), (i * VPCount + j + 1), 1);
}
Amount = SelectArea(year, ReturnSql(SA.VoltageClass[0]), DQType, TempDQ, "bian");
obj.SetValue((IntRow + i * VPCount + j), (IntCol + col), Amount);
if (col == obj.ColumnCount - 1) //最后一列
{
obj.Cells[(IntRow + i * VPCount + j), (IntCol + col)].Formula = "SUM(F" + (IntRow + i * VPCount + j + 1) + ":J" + (IntRow + i * VPCount + j + 1) + ")";
}
//MessageBox.Show(ReturnNext0fStr(obj, (IntRow + i * VPCount + j), (IntCol + 1), (j+1), 1));
break;
case 1:
PF.CreateSheetView(obj, 1, 1, (IntRow + i * VPCount + j), IntCol + 3, "线路工程");
TempDQ = (ReturnNext0fStr(obj, (IntRow + i * VPCount + j), (IntCol + 1), j + 1, 1));
if (i >= 1 + SA.CityCount) //总体行数减去市辖地区的数量就是县级地区
{
DQType = ReturnNext0fStr(obj, (IntRow + i * VPCount + j), (IntCol), (i * VPCount + j + 1 - SA.CityCount * VPCount), 1);
}
else
{
DQType = ReturnNext0fStr(obj, (IntRow + i * VPCount + j), (IntCol), (i * VPCount + j + 1), 1);
}
Amount = SelectArea(year, ReturnSql(SA.VoltageClass[0]), DQType, TempDQ, "line");
obj.SetValue((IntRow + i * VPCount + j), (IntCol + col), Amount);
if (col == obj.ColumnCount - 1) //最后一列
{
obj.Cells[(IntRow + i * VPCount + j), (IntCol + col)].Formula = "SUM(F" + (IntRow + i * VPCount + j + 1) + ":J" + (IntRow + i * VPCount + j + 1) + ")";
}
break;
case 2:
PF.CreateSheetView(obj, 1, 1, (IntRow + i * VPCount + j), IntCol + 3, "变电工程");
TempDQ = (ReturnNext0fStr(obj, (IntRow + i * VPCount + j), (IntCol + 1), j + 1, 1));
if (i >= 1 + SA.CityCount) //总体行数减去市辖地区的数量就是县级地区
{
DQType = ReturnNext0fStr(obj, (IntRow + i * VPCount + j), (IntCol), (i * VPCount + j + 1 - SA.CityCount * VPCount), 1);
}
else
{
DQType = ReturnNext0fStr(obj, (IntRow + i * VPCount + j), (IntCol), (i * VPCount + j + 1), 1);
}
Amount = SelectArea(year, ReturnSql(SA.VoltageClass[1]), DQType, TempDQ, "bian");
obj.SetValue((IntRow + i * VPCount + j), (IntCol + col), Amount);
if (col == obj.ColumnCount - 1) //最后一列
{
obj.Cells[(IntRow + i * VPCount + j), (IntCol + col)].Formula = "SUM(F" + (IntRow + i * VPCount + j + 1) + ":J" + (IntRow + i * VPCount + j + 1) + ")";
}
break;
case 3:
PF.CreateSheetView(obj, 1, 1, (IntRow + i * VPCount + j), IntCol + 3, "线路工程");
TempDQ = (ReturnNext0fStr(obj, (IntRow + i * VPCount + j), (IntCol + 1), j + 1, 1));
if (i >= 1 + SA.CityCount) //总体行数减去市辖地区的数量就是县级地区
{
DQType = ReturnNext0fStr(obj, (IntRow + i * VPCount + j), (IntCol), (i * VPCount + j + 1 - SA.CityCount * VPCount), 1);
}
else
{
DQType = ReturnNext0fStr(obj, (IntRow + i * VPCount + j), (IntCol), (i * VPCount + j + 1), 1);
}
Amount = SelectArea(year, ReturnSql(SA.VoltageClass[1]), DQType, TempDQ, "line");
obj.SetValue((IntRow + i * VPCount + j), (IntCol + col), Amount);
if (col == obj.ColumnCount - 1) //最后一列
{
obj.Cells[(IntRow + i * VPCount + j), (IntCol + col)].Formula = "SUM(F" + (IntRow + i * VPCount + j + 1) + ":J" + (IntRow + i * VPCount + j + 1) + ")";
}
break;
case 4:
PF.CreateSheetView(obj, 1, 1, (IntRow + i * VPCount + j), IntCol + 3, "配变工程");
TempDQ = (ReturnNext0fStr(obj, (IntRow + i * VPCount + j), (IntCol + 1), j + 1, 1));
if (i >= 1 + SA.CityCount) //总体行数减去市辖地区的数量就是县级地区
{
DQType = ReturnNext0fStr(obj, (IntRow + i * VPCount + j), (IntCol), (i * VPCount + j + 1 - SA.CityCount * VPCount), 1);
}
else
{
DQType = ReturnNext0fStr(obj, (IntRow + i * VPCount + j), (IntCol), (i * VPCount + j + 1), 1);
}
Amount = SelectArea(year, ReturnSql(SA.VoltageClass[2]), DQType, TempDQ, "pw-pb");
obj.SetValue((IntRow + i * VPCount + j), (IntCol + col), Amount);
if (col == obj.ColumnCount - 1) //最后一列
{
obj.Cells[(IntRow + i * VPCount + j), (IntCol + col)].Formula = "SUM(F" + (IntRow + i * VPCount + j + 1) + ":J" + (IntRow + i * VPCount + j + 1) + ")";
}
break;
case 5:
PF.CreateSheetView(obj, 1, 1, (IntRow + i * VPCount + j), IntCol + 3, "线路工程");
TempDQ = (ReturnNext0fStr(obj, (IntRow + i * VPCount + j), (IntCol + 1), j + 1, 1));
if (i >= 1 + SA.CityCount) //总体行数减去市辖地区的数量就是县级地区
{
DQType = ReturnNext0fStr(obj, (IntRow + i * VPCount + j), (IntCol), (i * VPCount + j + 1 - SA.CityCount * VPCount), 1);
}
else
{
DQType = ReturnNext0fStr(obj, (IntRow + i * VPCount + j), (IntCol), (i * VPCount + j + 1), 1);
}
Amount = SelectArea(year, ReturnSql(SA.VoltageClass[2]), DQType, TempDQ, "pw-line");
obj.SetValue((IntRow + i * VPCount + j), (IntCol + col), Amount);
if (col == obj.ColumnCount - 1) //最后一列
{
obj.Cells[(IntRow + i * VPCount + j), (IntCol + col)].Formula = "SUM(F" + (IntRow + i * VPCount + j + 1) + ":J" + (IntRow + i * VPCount + j + 1) + ")";
}
break;
case 6: //手写
PF.CreateSheetView(obj, 1, 1, (IntRow + i * VPCount + j), IntCol + 3, "低压工程");
obj.Cells[(IntRow + i * VPCount + j), (IntCol + col)].Locked = false; //读写
if (col == obj.ColumnCount - 1) //最后一列
{
obj.Cells[(IntRow + i * VPCount + j), (IntCol + col)].Locked = true; //读写
obj.Cells[(IntRow + i * VPCount + j), (IntCol + col)].Formula = "SUM(F" + (IntRow + i * VPCount + j + 1) + ":J" + (IntRow + i * VPCount + j + 1) + ")";
}
break;
case 7: //项目的最后一个项目"分项合计"
PF.CreateSheetView(obj, 1, 1, (IntRow + i * VPCount + j), IntCol + 3, "分项合计");
//MessageBox.Show(ReturnNext0fStr(obj, (IntRow + i * VPCount + j), (IntCol + 1), (j + 1), 1));
switch (col)
{
case 4:
strColTitle = "E";
break;
case 5:
strColTitle = "F";
break;
case 6:
strColTitle = "G";
break;
case 7:
strColTitle = "H";
break;
case 8:
strColTitle = "I";
break;
case 9:
strColTitle = "J";
break;
default:
break;
}
if (col == obj.ColumnCount - 1) //最后一列
{
obj.Cells[(IntRow + i * VPCount + j), (IntCol + col)].Formula = "SUM(F" + (IntRow + i * VPCount + j + 1) + ":J" + (IntRow + i * VPCount + j + 1) + ")";
}
else
{
obj.Cells[(IntRow + i * VPCount + j), (IntCol + col)].Formula = "SUM(" + strColTitle + (IntRow + i * VPCount + j - VPCount + 2) + ":" + strColTitle + (IntRow + i * VPCount + j - 1 + 1) + ")";
}
break;
default:
break;
}
}
else
{
switch (j)
{
case 0:
PF.CreateSheetView(obj, 1, 1, (IntRow + i * VPCount + j), IntCol + 3, "变电工程");
break;
case 1:
PF.CreateSheetView(obj, 1, 1, (IntRow + i * VPCount + j), IntCol + 3, "线路工程");
break;
case 2:
PF.CreateSheetView(obj, 1, 1, (IntRow + i * VPCount + j), IntCol + 3, "变电工程");
break;
case 3:
PF.CreateSheetView(obj, 1, 1, (IntRow + i * VPCount + j), IntCol + 3, "线路工程");
break;
case 4:
PF.CreateSheetView(obj, 1, 1, (IntRow + i * VPCount + j), IntCol + 3, "配变工程");
break;
case 5:
PF.CreateSheetView(obj, 1, 1, (IntRow + i * VPCount + j), IntCol + 3, "线路工程");
break;
case 6:
PF.CreateSheetView(obj, 1, 1, (IntRow + i * VPCount + j), IntCol + 3, "低压工程");
break;
case 7:
PF.CreateSheetView(obj, 1, 1, (IntRow + i * VPCount + j), IntCol + 3, "分项合计 ");
break;
default:
break;
}
}
year++;
}
}
}
//写入合计的数据
string Formula = null;
for (int i = 0; i < (1); ++i) //市 CityCount
{
for (int j = 0; j < VPCount; ++j) //项目
{
for (int col = 4; col < obj.ColumnCount; ++col)
{
switch (col)
{
case 4:
for (int c = 1; c <= SA.CityCount; ++c)
{
if (c == SA.CityCount)
{
Formula += "E" + ((IntRow + i * VPCount + j + 1) + c * VPCount);
obj.Cells[(IntRow + i * VPCount + j), (IntCol + col)].Formula = Formula;
Formula = "";
}
else
{
Formula += "E" + ((IntRow + i * VPCount + j + 1) + c * VPCount) + "+";
}
}
break;
case 5:
for (int c = 1; c <= SA.CityCount; ++c)
{
if (c == SA.CityCount)
{
Formula += "F" + ((IntRow + i * VPCount + j + 1) + c * VPCount);
obj.Cells[(IntRow + i * VPCount + j), (IntCol + col)].Formula = Formula;
Formula = "";
}
else
{
Formula += "F" + ((IntRow + i * VPCount + j + 1) + c * VPCount) + "+";
}
}
break;
case 6:
for (int c = 1; c <= SA.CityCount; ++c)
{
if (c == SA.CityCount)
{
Formula += "G" + ((IntRow + i * VPCount + j + 1) + c * VPCount);
obj.Cells[(IntRow + i * VPCount + j), (IntCol + col)].Formula = Formula;
Formula = "";
}
else
{
Formula += "G" + ((IntRow + i * VPCount + j + 1) + c * VPCount) + "+";
}
}
break;
case 7:
for (int c = 1; c <= SA.CityCount; ++c)
{
if (c == SA.CityCount)
{
Formula += "H" + ((IntRow + i * VPCount + j + 1) + c * VPCount);
obj.Cells[(IntRow + i * VPCount + j), (IntCol + col)].Formula = Formula;
Formula = "";
}
else
{
Formula += "H" + ((IntRow + i * VPCount + j + 1) + c * VPCount) + "+";
}
}
break;
case 8:
for (int c = 1; c <= SA.CityCount; ++c)
{
if (c == SA.CityCount)
{
Formula += "I" + ((IntRow + i * VPCount + j + 1) + c * VPCount);
obj.Cells[(IntRow + i * VPCount + j), (IntCol + col)].Formula = Formula;
Formula = "";
}
else
{
Formula += "I" + ((IntRow + i * VPCount + j + 1) + c * VPCount) + "+";
}
}
break;
case 9:
for (int c = 1; c <= SA.CityCount; ++c)
{
if (c == SA.CityCount)
{
Formula += "J" + ((IntRow + i * VPCount + j + 1) + c * VPCount);
obj.Cells[(IntRow + i * VPCount + j), (IntCol + col)].Formula = Formula;
Formula = "";
}
else
{
Formula += "J" + ((IntRow + i * VPCount + j + 1) + c * VPCount) + "+";
}
}
break;
case 10: //十二五
obj.Cells[(IntRow + i * VPCount + j), (IntCol + col)].Formula = "SUM(F" + (IntRow + i * VPCount + j + 1) + ":J" + (IntRow + i * VPCount + j + 1) + ")";
break;
default:
break;
}
}
}
}
for (int i = 0; i < 1; ++i) //县SA.SumCountyCount
{
for (int j = 0; j < VPCount; ++j) //项目
{
for (int col = 4; col < obj.ColumnCount; ++col)
{
switch (col)
{
case 4:
for (int c = 1; c <= SA.SumCountyCount; ++c)
{
if (c == SA.SumCountyCount)
{
Formula += "E" + ((IntRow + i * VPCount + j + (SA.CityCount + 1) * VPCount + 1) + c * VPCount);
obj.Cells[(IntRow + i * VPCount + j + (SA.CityCount + 1) * VPCount), (IntCol + col)].Formula = Formula;
Formula = "";
}
else
{
Formula += "E" + ((IntRow + i * VPCount + j + (SA.CityCount + 1) * VPCount + 1) + c * VPCount) + "+";
}
}
break;
case 5:
for (int c = 1; c <= SA.SumCountyCount; ++c)
{
if (c == SA.SumCountyCount)
{
Formula += "F" + ((IntRow + i * VPCount + j + (SA.CityCount + 1) * VPCount + 1) + c * VPCount);
obj.Cells[(IntRow + i * VPCount + j + (SA.CityCount + 1) * VPCount), (IntCol + col)].Formula = Formula;
Formula = "";
}
else
{
Formula += "F" + ((IntRow + i * VPCount + j + (SA.CityCount + 1) * VPCount + 1) + c * VPCount) + "+";
}
}
break;
case 6:
for (int c = 1; c <= SA.SumCountyCount; ++c)
{
if (c == SA.SumCountyCount)
{
Formula += "G" + ((IntRow + i * VPCount + j + (SA.CityCount + 1) * VPCount + 1) + c * VPCount);
obj.Cells[(IntRow + i * VPCount + j + (SA.CityCount + 1) * VPCount), (IntCol + col)].Formula = Formula;
Formula = "";
}
else
{
Formula += "G" + ((IntRow + i * VPCount + j + (SA.CityCount + 1) * VPCount + 1) + c * VPCount) + "+";
}
}
break;
case 7:
for (int c = 1; c <= SA.SumCountyCount; ++c)
{
if (c == SA.SumCountyCount)
{
Formula += "H" + ((IntRow + i * VPCount + j + (SA.CityCount + 1) * VPCount + 1) + c * VPCount);
obj.Cells[(IntRow + i * VPCount + j + (SA.CityCount + 1) * VPCount), (IntCol + col)].Formula = Formula;
Formula = "";
}
else
{
Formula += "H" + ((IntRow + i * VPCount + j + (SA.CityCount + 1) * VPCount + 1) + c * VPCount) + "+";
}
}
break;
case 8:
for (int c = 1; c <= SA.SumCountyCount; ++c)
{
if (c == SA.SumCountyCount)
{
Formula += "I" + ((IntRow + i * VPCount + j + (SA.CityCount + 1) * VPCount + 1) + c * VPCount);
obj.Cells[(IntRow + i * VPCount + j + (SA.CityCount + 1) * VPCount), (IntCol + col)].Formula = Formula;
Formula = "";
}
else
{
Formula += "I" + ((IntRow + i * VPCount + j + (SA.CityCount + 1) * VPCount + 1) + c * VPCount) + "+";
}
}
break;
case 9:
for (int c = 1; c <= SA.SumCountyCount; ++c)
{
if (c == SA.SumCountyCount)
{
Formula += "J" + ((IntRow + i * VPCount + j + (SA.CityCount + 1) * VPCount + 1) + c * VPCount);
obj.Cells[(IntRow + i * VPCount + j + (SA.CityCount + 1) * VPCount), (IntCol + col)].Formula = Formula;
Formula = "";
}
else
{
Formula += "J" + ((IntRow + i * VPCount + j + (SA.CityCount + 1) * VPCount + 1) + c * VPCount) + "+";
}
}
break;
case 10: //十二五
obj.Cells[(IntRow + i * VPCount + j + (SA.CityCount + 1) * VPCount), (IntCol + col)].Formula = "SUM(F" + (IntRow + i * VPCount + j + (SA.CityCount + 1) * VPCount + 1) + ":J" + (IntRow + i * VPCount + j + (SA.CityCount + 1) * VPCount + 1) + ")";
break;
default:
break;
}
}
}
}
}
/// <summary>
/// 重绘
/// </summary>
/// <param name="obj"></param>
private void Redraw(FarPoint.Win.Spread.SheetView obj, int BeginYear, int EndYear)
{
//list.Clear();
list = AddColumnTitle(BeginYear, EndYear);
obj.RowCount = 0;
obj.ColumnCount = 0;
obj.ColumnCount = 1 + (EndYear - BeginYear + 1) + list.Count;
int IntRowCount = 7 + 2 + 3;//标题占3行，分区类型占2行，1是其它用
obj.RowCount = IntRowCount;
string strTitle = "";
IntRow = 3;
PF.Sheet_GridandCenter(obj);//画边线，居中
strTitle = "附表1 铜陵县" + BeginYear + "～" + EndYear + "年国民生产总值GDP情况表";
PF.CreateSheetView(obj, IntRow, obj.ColumnCount, 0, 0, strTitle);
PF.SetSheetViewColumnsWidth(obj, 0, strTitle);
IntCol = 1;
strTitle = "单位：万元、万人 万元/人";
obj.AddSpanCell(IntRow, 0, 1, obj.Columns.Count);
obj.SetValue(IntRow, 0, strTitle);
//右对齐
obj.Rows[IntRow].HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Right;
strTitle = " 指 标 名 称";
PF.CreateSheetView(obj, NextRowMerge += 1, NextColMerge, IntRow += 1, IntCol -= 1, strTitle);
PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle);
strTitle = " GDP";
PF.CreateSheetView(obj, NextRowMerge -= 1, NextColMerge, IntRow += 2, IntCol, strTitle);
PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle);
strTitle = "人均GDP";
PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow += 1, IntCol, strTitle);
PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle);
strTitle = " 第一产业比重";
PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow += 1, IntCol, strTitle);
PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle);
strTitle = "第二产业比重";
PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow += 1, IntCol, strTitle);
PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle);
strTitle = "第三产业比重";
PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow += 1, IntCol, strTitle);
PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle);
strTitle = " 总 人 口 ";
PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow += 1, IntCol, strTitle);
PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle);
NextRowMerge = 1;
NextColMerge = 1;
IntRow = 5;
IntCol = 0;
m_PF.LockSheets(obj);
//PF.SetWholeRowHeight(obj, obj.Rows.Count, obj.Columns.Count);//行高
}
private void Firstadddata()
{
//生成表2242zhu
FarPoint.Win.Spread.SheetView sheet2242zhu = new FarPoint.Win.Spread.SheetView();
//生成表Sheet212
FarPoint.Win.Spread.SheetView Sheet212 = new FarPoint.Win.Spread.SheetView();
//添加表2242zhu
fpSpread1.Sheets.Add(sheet2242zhu);
//添加表Sheet212
fpSpread1.Sheets.Add(Sheet212);
//创建表2242zhu
OBJ2242zhu.Build_sheet(sheet2242zhu);
//创建表Sheet212
OBJ212.Build_Sheet(Sheet212);
}
//////////////////////////////////////////////////////////////////////////
/// <summary>
/// 填写表头
/// </summary>
/// <param name="obj"></param>
/// <param name="Title"></param>
public void SetSheet_1Title(Itop.Client.Base.FormBase FB, FarPoint.Win.Spread.SheetView obj, string Title)
{
int IntColCount = 5;
int IntRowCount = 7 + 2 + 3;//标题占3行，分区类型占2行，1是其它用
string title = null;
obj.SheetName = Title;
obj.Columns.Count = IntColCount;
obj.Rows.Count = IntRowCount;
IntCol = obj.Columns.Count;
PF.Sheet_GridandCenter(obj);//画边线，居中
m_PF.LockSheets(obj);
string strTitle = "";
IntRow = 3;
strTitle = Title;
PF.CreateSheetView(obj, IntRow, IntCol, 0, 0, Title);
PF.SetSheetViewColumnsWidth(obj, 0, Title);
IntCol = 1;
strTitle = "单位：万元、万人 万元/人";
obj.AddSpanCell(IntRow, 0, 1, obj.Columns.Count);
obj.SetValue(IntRow, 0, strTitle);
//右对齐
obj.Rows[IntRow].HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Right;
strTitle = " 指 标 名 称";
PF.CreateSheetView(obj, NextRowMerge += 1, NextColMerge, IntRow += 1, IntCol -= 1, strTitle);
PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle);
strTitle = " GDP";
PF.CreateSheetView(obj, NextRowMerge -= 1, NextColMerge, IntRow += 2, IntCol, strTitle);
PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle);
strTitle = "人均GDP";
PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow += 1, IntCol, strTitle);
PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle);
strTitle = " 第一产业比重";
PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow += 1, IntCol, strTitle);
PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle);
strTitle = "第二产业比重";
PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow += 1, IntCol, strTitle);
PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle);
strTitle = "第三产业比重";
PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow += 1, IntCol, strTitle);
PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle);
strTitle = " 总 人 口 ";
PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow += 1, IntCol, strTitle);
PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle);
NextRowMerge = 1;
NextColMerge = 1;
IntRow = 5;
IntCol = 0;
//PF.SetWholeRowHeight(obj, obj.Rows.Count, obj.Columns.Count);//行高
}
private void barButtonItem1_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
//生成一个空表用来保存当前表
FarPoint.Win.Spread.SheetView obj_sheet = null;
//生成一个空表，行列值都设为0用来做为程序处理时的当前表，这样可以提高处理速度
FarPoint.Win.Spread.SheetView activesheet = new FarPoint.Win.Spread.SheetView();
activesheet.RowCount = 0;
activesheet.ColumnCount = 0;
//添加空表
fpSpread1.Sheets.Add(activesheet);
//保留当前表，以备程序结束后还原当前表
obj_sheet = fpSpread1.ActiveSheet;
//将空表设为当前表
fpSpread1.ActiveSheet = activesheet;
WaitDialogForm newwait = new WaitDialogForm("", "正在更新数据, 请稍候...");
sh91_52.SaveData(fpSpread1.Sheets[1]);
fpSpread1.Sheets[1].RowCount = 0;
fpSpread1.Sheets[1].ColumnCount = 0;
sh91_52.Build(fpSpread1.Sheets[1], ProjID);
sh91_52.WriteData(fpSpread1.Sheets[1]);
newwait.Close();
//移除空表
fpSpread1.Sheets.Remove(activesheet);
//还原当前表
fpSpread1.ActiveSheet = obj_sheet;
//设文本自动换行
fc.Sheet_Colautoenter(fpSpread1);
MessageBox.Show("更新数据完成！");
}
/// <summary>
/// 写入行
/// </summary>
///<param name="IntRow">起始行数</param>
///<param name="IntCol">起始列数</param>
///<param name="obj"></param>
///<param name="Title"></param>
private void WriteData(FarPoint.Win.Spread.SheetView obj, int IntRow, int IntCol, string Title)
{
int year = 2010;
int Voltage = 0;
string ColTitle = null;
int RowRI = 0;
//Ps_Table_TZGS BianInfo = null;
double SumAmount = 0.000;
InitDate();
#region 填写除了县级供电区和全地区合计的数据
for (int j = 0; j < TTCount; ++j) //有7个类型
{
PF.CreateSheetView(obj, VPCount, 1, IntRow + j * VPCount, IntCol, Title0[j]); //编号
PF.CreateSheetView(obj, VPCount, 1, IntRow + j * VPCount, IntCol + 1, TitleType[j]); //类型
for (int c = 0; c < VCCount; ++c)
{
PF.CreateSheetView(obj, 2, 1, (IntRow + c * (VCCount - 1)) + j * VPCount, IntCol + 2, VoltageClass[c]); //电压等级
}
for (int i = 0; i < VPCount; ++i) //9个项目
{
if (i < VPCount - 3)
{
PF.CreateSheetView(obj, 1, 1, (IntRow + i) + j * VPCount, IntCol + 3, VoltageProject[i]);//项目
}
else
{
PF.CreateSheetView(obj, 1, 2, (IntRow + i) + j * VPCount, IntCol + 2, VoltageProject[i]);//项目
}
//添加数据从数据库读取的数据
//这个循环是从列等于4开始
year = 2010;
if (i < 2)
{
Voltage = 0;
}
if (i == 2 && i < 4)
{
Voltage = 1;
}
if (i == 4 && i < 6)
{
Voltage = 2;
}
for (int m = 4; m < obj.ColumnCount; ++m) //column
{
if (j != 1 && j != TTCount - 1) //不是县级供电区，全地区合计
{
switch (i)
{
case 0: //变电工程
SumAmount = ReturnVoltageClass(VoltageClass[Voltage], year, TitleType1[j], "bian");
obj.SetValue((IntRow + i) + j * VPCount, IntCol + m, SumAmount);
if (m == obj.ColumnCount - 1) //最后一列
{
obj.Cells[(IntRow + i) + j * VPCount, IntCol + m].Formula = "SUM(F" + ((IntRow + i) + j * VPCount + 1) + ":J" + ((IntRow + i) + j * VPCount + 1) + ")";
}
break;
case 1: //线路工程
SumAmount = ReturnVoltageClass(VoltageClass[Voltage], year, TitleType1[j], "line");
obj.SetValue((IntRow + i) + j * VPCount, IntCol + m, SumAmount);
if (m == obj.ColumnCount - 1) //最后一列
{
obj.Cells[(IntRow + i) + j * VPCount, IntCol + m].Formula = "SUM(F" + ((IntRow + i) + j * VPCount + 1) + ":J" + ((IntRow + i) + j * VPCount + 1) + ")";
}
break;
case 2: //变电工程
SumAmount = ReturnVoltageClass(VoltageClass[Voltage], year, TitleType1[j], "bian");
obj.SetValue((IntRow + i) + j * VPCount, IntCol + m, SumAmount);
if (m == obj.ColumnCount - 1) //最后一列
{
obj.Cells[(IntRow + i) + j * VPCount, IntCol + m].Formula = "SUM(F" + ((IntRow + i) + j * VPCount + 1) + ":J" + ((IntRow + i) + j * VPCount + 1) + ")";
}
break;
case 3: //线路工程
SumAmount = ReturnVoltageClass(VoltageClass[Voltage], year, TitleType1[j], "line");
obj.SetValue((IntRow + i) + j * VPCount, IntCol + m, SumAmount);
if (m == obj.ColumnCount - 1) //最后一列
{
obj.Cells[(IntRow + i) + j * VPCount, IntCol + m].Formula = "SUM(F" + ((IntRow + i) + j * VPCount + 1) + ":J" + ((IntRow + i) + j * VPCount + 1) + ")";
}
break;
case 4: //配变工程
SumAmount = ReturnVoltageClass(VoltageClass[Voltage], year, TitleType1[j], "pw-pb");
obj.SetValue((IntRow + i) + j * VPCount, IntCol + m, SumAmount);
if (m == obj.ColumnCount - 1) //最后一列
{
obj.Cells[(IntRow + i) + j * VPCount, IntCol + m].Formula = "SUM(F" + ((IntRow + i) + j * VPCount + 1) + ":J" + ((IntRow + i) + j * VPCount + 1) + ")";
}
break;
case 5: //线路工程
SumAmount = ReturnVoltageClass(VoltageClass[Voltage], year, TitleType1[j], "pw-line");
obj.SetValue((IntRow + i) + j * VPCount, IntCol + m, SumAmount);
if (m == obj.ColumnCount - 1) //最后一列
{
obj.Cells[(IntRow + i) + j * VPCount, IntCol + m].Formula = "SUM(F" + ((IntRow + i) + j * VPCount + 1) + ":J" + ((IntRow + i) + j * VPCount + 1) + ")";
}
break;
case 6: //低压工程
obj.Cells[(IntRow + i) + j * VPCount, IntCol + m].Locked = false; //可写
if (m == obj.ColumnCount - 1) //最后一列
{
//obj.Cells[(IntRow + i) + j * VPCount, IntCol + m].Formula = "SUM(F" + ((IntRow + i) + j * VPCount + 1) + ":J" + ((IntRow + i) + j * VPCount + 1) + ")";
RowRI = ((IntRow + i) + j * VPCount + 1);
obj.Cells[(IntRow + i) + j * VPCount, IntCol + m].Formula = "F" + RowRI + "+G" + RowRI + "+H" + RowRI + "+I" + RowRI + "+J" + RowRI;
obj.Cells[(IntRow + i) + j * VPCount, IntCol + m].Locked = true; //只读
}
break;
case 7: //其它工程
obj.Cells[(IntRow + i) + j * VPCount, IntCol + m].Locked = false; //可写
if (m == obj.ColumnCount - 1) //最后一列
{
//obj.Cells[(IntRow + i) + j * VPCount, IntCol + m].Formula = "SUM(F" + ((IntRow + i) + j * VPCount + 1) + ":J" + ((IntRow + i) + j * VPCount + 1) + ")";
RowRI = ((IntRow + i) + j * VPCount + 1);
obj.Cells[(IntRow + i) + j * VPCount, IntCol + m].Formula = "F" + RowRI + "+G" + RowRI + "+H" + RowRI + "+I" + RowRI + "+J" + RowRI;
obj.Cells[(IntRow + i) + j * VPCount, IntCol + m].Locked = true; //只读
}
break;
case 8: //合计
switch (m)
{
case 4:
ColTitle = "E";
break;
case 5:
ColTitle = "F";
break;
case 6:
ColTitle = "G";
break;
case 7:
ColTitle = "H";
break;
case 8:
ColTitle = "I";
break;
case 9:
ColTitle = "J";
break;
default:
break;
}
if (m == obj.ColumnCount - 1) //最后一列
{
obj.Cells[(IntRow + i) + j * VPCount, IntCol + m].Locked = true; //只读
obj.Cells[(IntRow + i) + j * VPCount, IntCol + m].Formula = "SUM(F" + ((IntRow + i) + j * VPCount + 1) + ":J" + ((IntRow + i) + j * VPCount + 1) + ")";
}
else
{
obj.Cells[(IntRow + i) + j * VPCount, IntCol + m].Formula = "SUM(" + ColTitle + ((IntRow + i) + j * VPCount - 7) + ":" + ColTitle + ((IntRow + i) + j * VPCount) + ")";
}
break;
default:
break;
}
}
year += 1;
}
}
}
#endregion
//因为先计算出县级一下的数据，所以最后写入县级数据，和全地区数据
#region 填写县级供电区和全地区合计的数据
IntRow = 14;
IntCol = 0;
int RangeRow = 45; //距离要写入的下一行隔着45行
for (int i = 0; i < 2; ++i) //有两个地区最后写数据
{
for (int r = 0; r < VPCount; ++r)
{
for (int j = 4; j < obj.ColumnCount; ++j)
{
switch (j)
{
case 4:
ColTitle = "E";
if (i == 0)
{
obj.Cells[IntRow + r + i * RangeRow, IntCol + j].Formula = ColTitle + (IntRow + r + i * RangeRow + VPCount + 1) + "+" + ColTitle + (IntRow + r + i * RangeRow + VPCount * 2 + 1) + "+" + ColTitle + (IntRow + r + i * RangeRow + VPCount * 3 + 1) + "+" + ColTitle + (IntRow + r + i * RangeRow + VPCount * 4 + 1); //隔着45行在写入数据
}
if (i == 1)
{
obj.Cells[IntRow + r + i * RangeRow, IntCol + j].Formula = ColTitle + (IntRow + r + i * RangeRow - VPCount * 6 + 1) + "+" + ColTitle + (IntRow + r + i * RangeRow - VPCount * 5 + 1);
}
break;
case 5:
ColTitle = "F";
if (i == 0)
{
obj.Cells[IntRow + r + i * RangeRow, IntCol + j].Formula = ColTitle + (IntRow + r + i * RangeRow + VPCount + 1) + "+" + ColTitle + (IntRow + r + i * RangeRow + VPCount * 2 + 1) + "+" + ColTitle + (IntRow + r + i * RangeRow + VPCount * 3 + 1) + "+" + ColTitle + (IntRow + r + i * RangeRow + VPCount * 4 + 1); //隔着45行在写入数据
}
if (i == 1)
{
obj.Cells[IntRow + r + i * RangeRow, IntCol + j].Formula = ColTitle + (IntRow + r + i * RangeRow - VPCount * 6 + 1) + "+" + ColTitle + (IntRow + r + i * RangeRow - VPCount * 5 + 1);
}
break;
case 6:
ColTitle = "G";
if (i == 0)
{
obj.Cells[IntRow + r + i * RangeRow, IntCol + j].Formula = ColTitle + (IntRow + r + i * RangeRow + VPCount + 1) + "+" + ColTitle + (IntRow + r + i * RangeRow + VPCount * 2 + 1) + "+" + ColTitle + (IntRow + r + i * RangeRow + VPCount * 3 + 1) + "+" + ColTitle + (IntRow + r + i * RangeRow + VPCount * 4 + 1); //隔着45行在写入数据
}
if (i == 1)
{
obj.Cells[IntRow + r + i * RangeRow, IntCol + j].Formula = ColTitle + (IntRow + r + i * RangeRow - VPCount * 6 + 1) + "+" + ColTitle + (IntRow + r + i * RangeRow - VPCount * 5 + 1);
}
break;
case 7:
ColTitle = "H";
if (i == 0)
{
obj.Cells[IntRow + r + i * RangeRow, IntCol + j].Formula = ColTitle + (IntRow + r + i * RangeRow + VPCount + 1) + "+" + ColTitle + (IntRow + r + i * RangeRow + VPCount * 2 + 1) + "+" + ColTitle + (IntRow + r + i * RangeRow + VPCount * 3 + 1) + "+" + ColTitle + (IntRow + r + i * RangeRow + VPCount * 4 + 1); //隔着45行在写入数据
}
if (i == 1)
{
obj.Cells[IntRow + r + i * RangeRow, IntCol + j].Formula = ColTitle + (IntRow + r + i * RangeRow - VPCount * 6 + 1) + "+" + ColTitle + (IntRow + r + i * RangeRow - VPCount * 5 + 1);
}
break;
case 8:
ColTitle = "I";
if (i == 0)
{
obj.Cells[IntRow + r + i * RangeRow, IntCol + j].Formula = ColTitle + (IntRow + r + i * RangeRow + VPCount + 1) + "+" + ColTitle + (IntRow + r + i * RangeRow + VPCount * 2 + 1) + "+" + ColTitle + (IntRow + r + i * RangeRow + VPCount * 3 + 1) + "+" + ColTitle + (IntRow + r + i * RangeRow + VPCount * 4 + 1); //隔着45行在写入数据
}
if (i == 1)
{
obj.Cells[IntRow + r + i * RangeRow, IntCol + j].Formula = ColTitle + (IntRow + r + i * RangeRow - VPCount * 6 + 1) + "+" + ColTitle + (IntRow + r + i * RangeRow - VPCount * 5 + 1);
}
break;
case 9:
ColTitle = "J";
if (i == 0)
{
obj.Cells[IntRow + r + i * RangeRow, IntCol + j].Formula = ColTitle + (IntRow + r + i * RangeRow + VPCount + 1) + "+" + ColTitle + (IntRow + r + i * RangeRow + VPCount * 2 + 1) + "+" + ColTitle + (IntRow + r + i * RangeRow + VPCount * 3 + 1) + "+" + ColTitle + (IntRow + r + i * RangeRow + VPCount * 4 + 1); //隔着45行在写入数据
}
if (i == 1)
{
obj.Cells[IntRow + r + i * RangeRow, IntCol + j].Formula = ColTitle + (IntRow + r + i * RangeRow - VPCount * 6 + 1) + "+" + ColTitle + (IntRow + r + i * RangeRow - VPCount * 5 + 1);
}
break;
case 10: //最后一列
RowRI = (IntRow + r + i * RangeRow + 1);
obj.Cells[IntRow + r + i * RangeRow, IntCol + j].Formula = "F" + RowRI + "+G" + RowRI + "+H" + RowRI + "+I" + RowRI + "+J" + RowRI;
break;
default:
break;
}
}
}
#endregion
}
}
private void barBtnRefrehData_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
WaitDialogForm newwait=new WaitDialogForm("", "正在更新数据, 请稍候...");
//清空原有sheet的数据，但保留sheetname
fc.SpreadClearSheet(fpSpread1);
//生成一个空表用来保存当前表
FarPoint.Win.Spread.SheetView obj_sheet = null;
//生成一个空表，行列值都设为0用来做为程序处理时的当前表，这样可以提高处理速度
FarPoint.Win.Spread.SheetView activesheet = new FarPoint.Win.Spread.SheetView();
activesheet.RowCount = 0;
activesheet.ColumnCount = 0;
//添加空表
fpSpread1.Sheets.Add(activesheet);
//保留当前表，以备程序结束后还原当前表
obj_sheet = fpSpread1.ActiveSheet;
//将空表设为当前表
fpSpread1.ActiveSheet = activesheet;
shjjbyyear = true;
//形成基础数据电力发展实绩历年地区生产
build_dlhistoryGDP();
//电力发展实绩分行业统计
build_dlhistoryfhy();
//电力发展实绩社会经济用电情况
build_dlhistoryjjyd();
//分区县供电实绩
build_fqxgdsj();
//分区县用电情况
//全市拟建主要工业项目及用电需求情况表
build_njxmandydl();
//重点建设工业及用电需求表
build_zdjsxm();
//典型日最大负荷
build_dxfh();
//月最大负荷数据
build_monthmax();
//年最大负荷数据
build_YearMAX();
//变电站情况表
build_bdzqk();
//输电线路情况表
build_lineqk();
shjjbyyear = false;
fpSpread1.Sheets.Remove(activesheet);
//移除空表
//还原当前表
fpSpread1.ActiveSheet = obj_sheet;
newwait.Close();
MessageBox.Show("更新数据完成！");
}
/// <summary>
/// 加载10_1表头
/// </summary>
/// <param name="obj"></param>
/// <param name="Title"></param>
public void SetSheet10_1Title(FarPoint.Win.Spread.SheetView obj, string Title)
{
int IntColCount = 11;
int IntRowCount = 64 + 1 + 3;//标题占3行，类型占1行，
string title = null;
obj.SheetName = Title;
obj.Columns.Count = IntColCount;
obj.Rows.Count = IntRowCount;
IntCol = obj.Columns.Count;
PF.Sheet_GridandCenter(obj);//画线，居中
ColReadOnly(obj, IntColCount);
//obj.OperationMode = FarPoint.Win.Spread.OperationMode.ReadOnly;
string strTitle = "";
IntRow = 3;
strTitle = Title;
PF.CreateSheetView(obj, IntRow, IntCol, 0, 0, Title);
PF.SetSheetViewColumnsWidth(obj, 0, Title);
IntCol = 1;
//加载数据
WriteData(obj, IntRow + 2, IntCol - 1, Title);
strTitle = " 编 号 ";
PF.CreateSheetView(obj, NextRowMerge += 1, NextColMerge, IntRow, IntCol -= 1, strTitle);
PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle);
strTitle = " 类 型 ";
PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow, IntCol += 1, strTitle);
PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle);
strTitle = " 电压等级 ";
PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow, IntCol += 1, strTitle);
PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle);
strTitle = " 项 目";
PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow, IntCol += 1, strTitle);
PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle);
strTitle = " 2010年";
PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow, IntCol += 1, strTitle);
PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle);
strTitle = " 2011年 ";
PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow, IntCol += 1, strTitle);
PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle);
strTitle = " 2012年 ";
PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow, IntCol += 1, strTitle);
PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle);
strTitle = " 2013年 ";
PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow, IntCol += 1, strTitle);
PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle);
strTitle = " 2014年 ";
PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow, IntCol += 1, strTitle);
PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle);
strTitle = " 2015年";
PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow, IntCol += 1, strTitle);
PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle);
strTitle = " “十二五”合计 ";
PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow, IntCol += 1, strTitle);
PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle);
NextRowMerge = 1;
NextColMerge = 1;
PF.SetWholeRowHeight(obj, obj.Rows.Count, obj.Columns.Count);//行高
}
private void barBtnRefrehData_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
WaitDialogForm newwait=new WaitDialogForm("", "正在更新数据, 请稍候...");
//清空原有sheet的数据，但保留sheetname
fc.SpreadClearSheet(fpSpread1);
//生成一个空表用来保存当前表
FarPoint.Win.Spread.SheetView obj_sheet = null;
//生成一个空表，行列值都设为0用来做为程序处理时的当前表，这样可以提高处理速度
FarPoint.Win.Spread.SheetView activesheet = new FarPoint.Win.Spread.SheetView();
activesheet.RowCount = 0;
activesheet.ColumnCount = 0;
//添加空表
fpSpread1.Sheets.Add(activesheet);
//保留当前表，以备程序结束后还原当前表
obj_sheet = fpSpread1.ActiveSheet;
//将空表设为当前表
fpSpread1.ActiveSheet = activesheet;
shjjbyyear = true;
//500千伏分区分年电容量计算表
build_500rltj();
//500千伏分区分年容载比计算表
build_500rzbtj();
shjjbyyear = false;
fpSpread1.Sheets.Remove(activesheet);
//移除空表
//还原当前表
fpSpread1.ActiveSheet = obj_sheet;
newwait.Close();
MessageBox.Show("更新数据完成！");
}
public void Sheet_AddData(FarPoint.Win.Spread.SheetView obj_sheet, int year, string ProjID)
{
//将类型存入数组，便于读取
string[] dq = { "市辖供电区", "县级直供直管", "县级控股", "县级参股", "县级代管" };
//存放读出的类型
string dqstr = "";
//存电压条件
string dianya = "";
//存放查询条件
string BDtiaojian = "";
//存放公用还是专用
string GorZ = "";
//数组下标
int index = 0;
for (int row = 3; row < 15; row++)
{
//跳过县级合并部分
if (row == 5)
{
row = row + 2;
}
//使行数与类型的数组标识对应起来
if (row < 5)
{
index = (row - 3) / 2;
}
else
{
index = (row - 5) / 2;
}
dqstr = dq[index];
if (row % 2 == 0)
{
dianya = " and L1=35 ";
}
else
{
dianya = " and (L1=110 or L1=66) ";
}
//计算公用变电站座数
GorZ = "公用";
BDtiaojian = " S2!='' and Cast(substring(S2,1,4) as int)<=" + year + " and AreaID='" + ProjID + "' and DQ='" + dqstr + "' and S4='" + GorZ + "' " + dianya;
int GBDsum = (int)Services.BaseService.GetObject("SelectPSP_Substation_InfoCountall", BDtiaojian);
obj_sheet.SetValue(row, 3, GBDsum);
//计算专用变电站座数
GorZ = "专用";
BDtiaojian = " S2!='' and Cast(substring(S2,1,4) as int)<=" + year + " and AreaID='" + ProjID + "' and DQ='" + dqstr + "' and S4='" + GorZ + "' " + dianya;
int ZBDsum = (int)Services.BaseService.GetObject("SelectPSP_Substation_InfoCountall", BDtiaojian);
obj_sheet.SetValue(row, 5, ZBDsum);
//计算公用主变台数（台）
GorZ = "公用";
BDtiaojian = " S2!='' and Cast(substring(S2,1,4) as int)<=" + year + " and AreaID='" + ProjID + "' and DQ='" + dqstr + "' and S4='" + GorZ + "' " + dianya;
int GZBsum = 0;
if (Services.BaseService.GetObject("SelectPSP_Substation_InfoSUML3", BDtiaojian) != null)
{
GZBsum = (int)Services.BaseService.GetObject("SelectPSP_Substation_InfoSUML3", BDtiaojian);
}
obj_sheet.SetValue(row, 6, GZBsum);
//计算专用主变台数（台）
GorZ = "专用";
BDtiaojian = " S2!='' and Cast(substring(S2,1,4) as int)<=" + year + " and AreaID='" + ProjID + "' and DQ='" + dqstr + "' and S4='" + GorZ + "' " + dianya;
int ZZBsum = 0;
if (Services.BaseService.GetObject("SelectPSP_Substation_InfoSUML3", BDtiaojian) != null)
{
ZZBsum = (int)Services.BaseService.GetObject("SelectPSP_Substation_InfoSUML3", BDtiaojian);
}
obj_sheet.SetValue(row, 8, ZZBsum);
//计算公用变电容量
GorZ = "公用";
BDtiaojian = " S2!='' and Cast(substring(S2,1,4) as int)<=" + year + " and AreaID='" + ProjID + "' and DQ='" + dqstr + "' and S4='" + GorZ + "' " + dianya;
double GBDRLsum = 0;
if (Services.BaseService.GetObject("SelectPSP_Substation_InfoSUML2", BDtiaojian) != null)
{
GBDRLsum = (double)Services.BaseService.GetObject("SelectPSP_Substation_InfoSUML2", BDtiaojian);
}
obj_sheet.SetValue(row, 9, GBDRLsum);
//计算专用变电容量
GorZ = "专用";
BDtiaojian = " S2!='' and Cast(substring(S2,1,4) as int)<=" + year + " and AreaID='" + ProjID + "' and DQ='" + dqstr + "' and S4='" + GorZ + "' " + dianya;
double ZBDRLsum = 0;
if (Services.BaseService.GetObject("SelectPSP_Substation_InfoSUML2", BDtiaojian) != null)
{
ZBDRLsum = (double)Services.BaseService.GetObject("SelectPSP_Substation_InfoSUML2", BDtiaojian);
}
obj_sheet.SetValue(row, 10, ZBDRLsum);
//计算公用10（20）kV出线间隔总数（回）
//GorZ = "公用";
//BDtiaojian = " S2!='' and L13!='' and Cast(substring(S2,1,4) as int)<=" + year + " and AreaID='" + ProjID + "' and DQ='" + dqstr + "' and S4='" + GorZ + "' " + dianya;
//int GCXJGsum = 0;
//if (Services.BaseService.GetObject("SelectPSP_Substation_InfoSUML13", BDtiaojian) != null)
//{
// GCXJGsum = (int)Services.BaseService.GetObject("SelectPSP_Substation_InfoSUML13", BDtiaojian);
//}
//obj_sheet.SetValue(row, 11, GCXJGsum);
//计算公用10（20）已出线间隔总数（回）
//BDtiaojian = " S2!='' and L14!='' and Cast(substring(S2,1,4) as int)<=" + year + " and AreaID='" + ProjID + "' and DQ='" + dqstr + "' and S4='" + GorZ + "' " + dianya;
//int GYCXJGsum = 0;
//if (Services.BaseService.GetObject("SelectPSP_Substation_InfoSUML14", BDtiaojian) != null)
//{
// GYCXJGsum = (int)Services.BaseService.GetObject("SelectPSP_Substation_InfoSUML14", BDtiaojian);
//}
//obj_sheet.SetValue(row, 12, GYCXJGsum);
//计算公用无功补偿容量（Mvar）
BDtiaojian = " S2!='' and L5!='' and Cast(substring(S2,1,4) as int)<=" + year + " and AreaID='" + ProjID + "' and DQ='" + dqstr + "' and S4='" + GorZ + "' " + dianya;
double GWGBCsum = 0;
if (Services.BaseService.GetObject("SelectPSP_Substation_InfoSUML5", BDtiaojian) != null)
{
GWGBCsum = (double)Services.BaseService.GetObject("SelectPSP_Substation_InfoSUML5", BDtiaojian);
}
obj_sheet.SetValue(row, 13, GWGBCsum);
}
}
private void Firstadddata()
{
//生成表
//FarPoint.Win.Spread.SheetView sheet2251 = new FarPoint.Win.Spread.SheetView();
//FarPoint.Win.Spread.SheetView sheet2253 = new FarPoint.Win.Spread.SheetView();
FarPoint.Win.Spread.SheetView sheet2255 = new FarPoint.Win.Spread.SheetView();
//添加表
//fpSpread1.Sheets.Add(sheet2251);
//fpSpread1.Sheets.Add(sheet2253);
fpSpread1.Sheets.Add(sheet2255);
//创建表
//OBJ2251.Build_Sheet(sheet2251);
//OBJ2253.Build_Sheet(sheet2253);
OBJ2255.Build_Sheet(sheet2255);
}
private void Sheet_AddItem(FarPoint.Win.Spread.SheetView obj_sheet)
{
//写标题行内容
//2行标题内容
obj_sheet.AddSpanCell(1, 0, 2, 1);
obj_sheet.SetValue(1, 0, "编号");
obj_sheet.AddSpanCell(1, 1, 2, 1);
obj_sheet.SetValue(1, 1, "类型");
obj_sheet.AddSpanCell(1, 2, 2, 1);
obj_sheet.SetValue(1, 2, "电压等级（kV）");
obj_sheet.AddSpanCell(1, 3, 1, 3);
obj_sheet.SetValue(1, 3, "变电站座数（座）");
obj_sheet.AddSpanCell(1, 6, 1, 3);
obj_sheet.SetValue(1, 6, "主变台数（台）");
obj_sheet.AddSpanCell(1, 9, 1, 2);
obj_sheet.SetValue(1, 9, "变电容量（MVA）");
obj_sheet.SetValue(1, 11, "10（20）kV出线间隔总数（回）");
obj_sheet.SetValue(1, 12, "10（20）已出线间隔总数（回）");
obj_sheet.SetValue(1, 13, "无功补偿容量（Mvar）");
obj_sheet.SetValue(1, 14, "10kV平均供电半径（km）");
//3行标题内容
obj_sheet.SetValue(2, 3, "公用");
obj_sheet.SetValue(2, 4, "其中：单线单变座数");
obj_sheet.SetValue(2, 5, "专用");
obj_sheet.SetValue(2, 6, "公用");
obj_sheet.SetValue(2, 7, "其中：有载调压主变");
obj_sheet.SetValue(2, 8, "专用");
obj_sheet.SetValue(2, 9, "公用");
obj_sheet.SetValue(2, 10, "专用");
obj_sheet.SetValue(2, 11, "公用");
obj_sheet.SetValue(2, 12, "公用");
obj_sheet.SetValue(2, 13, "公用");
obj_sheet.SetValue(2, 14, "公用");
//写标题列内容
//1列标题内容
obj_sheet.AddSpanCell(3, 0, 2, 1);
obj_sheet.SetValue(3, 0, "1");
obj_sheet.AddSpanCell(5, 0, 2, 1);
obj_sheet.SetValue(5, 0, "2");
obj_sheet.AddSpanCell(7, 0, 2, 1);
obj_sheet.SetValue(7, 0, "2.1");
obj_sheet.AddSpanCell(9, 0, 2, 1);
obj_sheet.SetValue(9, 0, "2.2");
obj_sheet.AddSpanCell(11, 0, 2, 1);
obj_sheet.SetValue(11, 0, "2.3");
obj_sheet.AddSpanCell(13, 0, 2, 1);
obj_sheet.SetValue(13, 0, "2.4");
obj_sheet.AddSpanCell(15, 0, 2, 1);
obj_sheet.SetValue(15, 0, "3");
//2列标题内容
obj_sheet.AddSpanCell(3, 1, 2, 1);
obj_sheet.SetValue(3, 1, "市辖供电区");
obj_sheet.AddSpanCell(5, 1, 2, 1);
obj_sheet.SetValue(5, 1, "县级供电区");
obj_sheet.AddSpanCell(7, 1, 2, 1);
obj_sheet.SetValue(7, 1, "其中：直供直管");
obj_sheet.AddSpanCell(9, 1, 2, 1);
obj_sheet.SetValue(9, 1, "控股");
obj_sheet.AddSpanCell(11, 1, 2, 1);
obj_sheet.SetValue(11, 1, "参股");
obj_sheet.AddSpanCell(13, 1, 2, 1);
obj_sheet.SetValue(13, 1, "代管");
obj_sheet.AddSpanCell(15, 1, 2, 1);
obj_sheet.SetValue(15, 1, "全地区");
//3列标题内容
obj_sheet.SetValue(3, 2, "110（66）");
obj_sheet.SetValue(4, 2, "35");
obj_sheet.SetValue(5, 2, "110（66）");
obj_sheet.SetValue(6, 2, "35");
obj_sheet.SetValue(7, 2, "110（66）");
obj_sheet.SetValue(8, 2, "35");
obj_sheet.SetValue(9, 2, "110（66）");
obj_sheet.SetValue(10, 2, "35");
obj_sheet.SetValue(11, 2, "110（66）");
obj_sheet.SetValue(12, 2, "35");
obj_sheet.SetValue(13, 2, "110（66）");
obj_sheet.SetValue(14, 2, "35");
obj_sheet.SetValue(15, 2, "110（66）");
obj_sheet.SetValue(16, 2, "35");
}
private void Firstadddata()
{
//生成表3-1
FarPoint.Win.Spread.SheetView Sheet31 = new FarPoint.Win.Spread.SheetView();
//生成表3-2
FarPoint.Win.Spread.SheetView Sheet32 = new FarPoint.Win.Spread.SheetView();
//生成表3-3
FarPoint.Win.Spread.SheetView Sheet33 = new FarPoint.Win.Spread.SheetView();
//生成表3-3附表1
FarPoint.Win.Spread.SheetView Sheet33_1 = new FarPoint.Win.Spread.SheetView();
//生成表3-4
FarPoint.Win.Spread.SheetView Sheet34 = new FarPoint.Win.Spread.SheetView();
//生成表3-4附表2
FarPoint.Win.Spread.SheetView Sheet34_2 = new FarPoint.Win.Spread.SheetView();
//生成表3-5
FarPoint.Win.Spread.SheetView Sheet35 = new FarPoint.Win.Spread.SheetView();
//生成表3-6
FarPoint.Win.Spread.SheetView Sheet36 = new FarPoint.Win.Spread.SheetView();
//生成表3-7
FarPoint.Win.Spread.SheetView Sheet37 = new FarPoint.Win.Spread.SheetView();
//生成表3-7附表3
FarPoint.Win.Spread.SheetView Sheet37_3 = new FarPoint.Win.Spread.SheetView();
//生成表3-8
FarPoint.Win.Spread.SheetView Sheet38 = new FarPoint.Win.Spread.SheetView();
//生成表3-8附表8
FarPoint.Win.Spread.SheetView Sheet38_8 = new FarPoint.Win.Spread.SheetView();
//生成表3-9
FarPoint.Win.Spread.SheetView Sheet39 = new FarPoint.Win.Spread.SheetView();
//生成表3-9附表6
FarPoint.Win.Spread.SheetView Sheet39_6 = new FarPoint.Win.Spread.SheetView();
//生成表3-10
FarPoint.Win.Spread.SheetView Sheet310 = new FarPoint.Win.Spread.SheetView();
//生成表3-10附表5
FarPoint.Win.Spread.SheetView Sheet310_5 = new FarPoint.Win.Spread.SheetView();
//生成表3-11
FarPoint.Win.Spread.SheetView Sheet311 = new FarPoint.Win.Spread.SheetView();
//生成表3-11附表9
FarPoint.Win.Spread.SheetView Sheet311_9 = new FarPoint.Win.Spread.SheetView();
//生成表3-12
FarPoint.Win.Spread.SheetView Sheet312 = new FarPoint.Win.Spread.SheetView();
//生成表3-12附表10
FarPoint.Win.Spread.SheetView Sheet312_10 = new FarPoint.Win.Spread.SheetView();
//生成表3-13
FarPoint.Win.Spread.SheetView Sheet313 = new FarPoint.Win.Spread.SheetView();
//生成表3-13附表11
FarPoint.Win.Spread.SheetView Sheet313_11 = new FarPoint.Win.Spread.SheetView();
//生成表3-14
FarPoint.Win.Spread.SheetView Sheet314 = new FarPoint.Win.Spread.SheetView();
//生成表3-14附表12
FarPoint.Win.Spread.SheetView Sheet314_12 = new FarPoint.Win.Spread.SheetView();
//生成表3-15
FarPoint.Win.Spread.SheetView Sheet315 = new FarPoint.Win.Spread.SheetView();
//生成表3-15附表14
FarPoint.Win.Spread.SheetView Sheet315_14 = new FarPoint.Win.Spread.SheetView();
//生成表3-16
FarPoint.Win.Spread.SheetView Sheet316 = new FarPoint.Win.Spread.SheetView();
//生成表3-16附表16
FarPoint.Win.Spread.SheetView Sheet316_16 = new FarPoint.Win.Spread.SheetView();
//生成表3-17
FarPoint.Win.Spread.SheetView Sheet317 = new FarPoint.Win.Spread.SheetView();
//生成表3-17附表17
FarPoint.Win.Spread.SheetView Sheet317_17 = new FarPoint.Win.Spread.SheetView();
//生成表3-18
FarPoint.Win.Spread.SheetView Sheet318 = new FarPoint.Win.Spread.SheetView();
//生成表3-18附表19
FarPoint.Win.Spread.SheetView Sheet318_19 = new FarPoint.Win.Spread.SheetView();
//生成表3-19
FarPoint.Win.Spread.SheetView Sheet319 = new FarPoint.Win.Spread.SheetView();
//生成表3-19附表20
FarPoint.Win.Spread.SheetView Sheet319_20 = new FarPoint.Win.Spread.SheetView();
//生成表3-20
FarPoint.Win.Spread.SheetView Sheet320 = new FarPoint.Win.Spread.SheetView();
//生成表3-20附表21
FarPoint.Win.Spread.SheetView Sheet320_21 = new FarPoint.Win.Spread.SheetView();
//添加表3-1
fpSpread1.Sheets.Add(Sheet31);
//添加表3-2
fpSpread1.Sheets.Add(Sheet32);
//添加3-3
fpSpread1.Sheets.Add(Sheet33);
//添加表3-3附表1
fpSpread1.Sheets.Add(Sheet33_1);
//添加表3-4
fpSpread1.Sheets.Add(Sheet34);
//添加表3-4附表2
fpSpread1.Sheets.Add(Sheet34_2);
//添加表35
fpSpread1.Sheets.Add(Sheet35);
//添加表36
fpSpread1.Sheets.Add(Sheet36);
//添加表37
fpSpread1.Sheets.Add(Sheet37);
//添加表37附表3
fpSpread1.Sheets.Add(Sheet37_3);
//添加表38
fpSpread1.Sheets.Add(Sheet38);
//添加表38附表8
fpSpread1.Sheets.Add(Sheet38_8);
//添加表39
fpSpread1.Sheets.Add(Sheet39);
//添加表39附表6
fpSpread1.Sheets.Add(Sheet39_6);
//添加表310
fpSpread1.Sheets.Add(Sheet310);
//添加表310附表5
fpSpread1.Sheets.Add(Sheet310_5);
//添加表311
fpSpread1.Sheets.Add(Sheet311);
//添加表311附表9
fpSpread1.Sheets.Add(Sheet311_9);
//添加表312
fpSpread1.Sheets.Add(Sheet312);
//添加表312附表12
fpSpread1.Sheets.Add(Sheet312_10);
//添加表313
fpSpread1.Sheets.Add(Sheet313);
//添加表313附表11
fpSpread1.Sheets.Add(Sheet313_11);
//添加表314
fpSpread1.Sheets.Add(Sheet314);
//添加表314附表12
fpSpread1.Sheets.Add(Sheet314_12);
//添加表315
fpSpread1.Sheets.Add(Sheet315);
//添加表315附表14
fpSpread1.Sheets.Add(Sheet315_14);
//添加表316
fpSpread1.Sheets.Add(Sheet316);
//添加表316附表16
fpSpread1.Sheets.Add(Sheet316_16);
//添加表317
fpSpread1.Sheets.Add(Sheet317);
//添加表317附表17
fpSpread1.Sheets.Add(Sheet317_17);
//添加表318
fpSpread1.Sheets.Add(Sheet318);
//添加表318附表19
fpSpread1.Sheets.Add(Sheet318_19);
//添加表319
fpSpread1.Sheets.Add(Sheet319);
//添加表319附表20
fpSpread1.Sheets.Add(Sheet319_20);
//添加表320
fpSpread1.Sheets.Add(Sheet320);
//添加表320附表21
fpSpread1.Sheets.Add(Sheet320_21);
//创建表3-1
sh31.Build(Sheet31, year, ProjID, SxXjName);
//创建表3-2
sh32.Build(Sheet32, year, ProjID, SxXjName);
//创建表3-3
sh33.Build(Sheet33, year, ProjID, SxXjName);
//创建表3-3附表1
sh33_1.Build(Sheet33_1, year, ProjID, area_key_id, SxXjName);
//创建表3-4
sh34.Build(Sheet34, year, ProjID, SxXjName);
//创建表3-4附表2
sh34_2.Build(Sheet34_2, year, ProjID, area_key_id, SxXjName);
//创建表35
sh35.Build(Sheet35, year, ProjID, SxXjName);
//创建表36
sh36.Build(Sheet36, year, ProjID, SxXjName);
//创建表37
sh37.Build(Sheet37, year, ProjID, SxXjName);
//创建表37附表3
sh37_3.Build(Sheet37_3, year, ProjID, area_key_id, SxXjName);
//创建表38
sh38.Build(Sheet38, year, ProjID, SxXjName);
//创建表38附表8
sh38_8.Build(Sheet38_8,year, ProjID,area_key_name, area_key_id, SxXjName);
//创建表39
sh39.Build(Sheet39, year, ProjID, SxXjName);
//创建表39附表6
sh39_6.Build(Sheet39_6, year, ProjID, area_key_id, SxXjName);
//创建表310
sh310.Build(Sheet310, year, ProjID, SxXjName);
//创建表39附表6
sh310_5.Build(Sheet310_5, year, ProjID, area_key_id, SxXjName);
//创建表311
sh311.Build(Sheet311, year, ProjID, SxXjName);
//创建表311附表9
sh311_9.Build(Sheet311_9, year, ProjID, area_key_id, SxXjName);
//创建表312
sh312.Build(Sheet312, year, ProjID, SxXjName);
//创建表312附表10
sh312_10.Build(Sheet312_10, year, ProjID, area_key_id, SxXjName);
//创建表313
sh313.Build(Sheet313, year, ProjID, SxXjName);
//创建表313附表11
sh313_11.Build(Sheet313_11, year, ProjID, area_key_id, SxXjName);
//创建表314
sh314.Build(Sheet314, year, ProjID, SxXjName);
//创建表314附表12
sh314_12.Build(Sheet314_12, year, ProjID, area_key_id, SxXjName);
//创建表315
sh315.Build(fpSpread1,Sheet315, year, ProjID, SxXjName);
//创建表315附表14
sh315_14.Build(Sheet315_14, year, ProjID, area_key_id, SxXjName);
//创建表316
sh316.Build(Sheet316, year, ProjID, SxXjName);
//创建表316附表16
sh316_16.Build(Sheet316_16, year, ProjID,area_key_id,SxXjName);
//创建表317
sh317.Build(Sheet317, year, ProjID, SxXjName);
//创建表316附表16
sh317_17.Build(Sheet317_17, year, ProjID, area_key_id, SxXjName);
//创建表318
sh318.Build(Sheet318, year, ProjID, SxXjName);
//创建表316附表16
sh318_19.Build(Sheet318_19, year, ProjID, area_key_id, SxXjName);
//创建表319
sh319.Build(Sheet319, year, ProjID, SxXjName);
//创建表316附表16
sh319_20.Build(Sheet319_20, year, ProjID, area_key_id, SxXjName);
//创建表320
sh320.Build(Sheet320, year, ProjID, SxXjName);
//创建表320附表21
sh320_21.Build(Sheet320_21, year, ProjID, area_key_id, SxXjName);
fc.Sheet_Colautoenter(fpSpread1);
}
/// <summary>
/// 设计器支持所需的方法 - 不要
/// 使用代码编辑器修改此方法的内容。
/// </summary>
private void InitializeComponent()
{
FarPoint.Win.Spread.TipAppearance tipAppearance2 = new FarPoint.Win.Spread.TipAppearance();
this.fpEnter1 = new Neusoft.FrameWork.WinForms.Controls.NeuFpEnter();
this.fpEnter1_Sheet1 = new FarPoint.Win.Spread.SheetView();
this.contextMenu1 = new System.Windows.Forms.ContextMenu();
this.menuItem2 = new System.Windows.Forms.MenuItem();
this.panel1 = new Neusoft.FrameWork.WinForms.Controls.NeuPanel();
this.txtCmethod = new Neusoft.FrameWork.WinForms.Controls.NeuTextBox();
this.txtCmodeid = new Neusoft.FrameWork.WinForms.Controls.NeuTextBox();
this.label29 = new Neusoft.FrameWork.WinForms.Controls.NeuLabel();
this.dtenddate3 = new Neusoft.FrameWork.WinForms.Controls.NeuDateTimePicker();
this.label20 = new Neusoft.FrameWork.WinForms.Controls.NeuLabel();
this.dtbegindate3 = new Neusoft.FrameWork.WinForms.Controls.NeuDateTimePicker();
this.label21 = new Neusoft.FrameWork.WinForms.Controls.NeuLabel();
this.label22 = new Neusoft.FrameWork.WinForms.Controls.NeuLabel();
this.txtday3 = new Neusoft.FrameWork.WinForms.Controls.ValidatedTextBox();
this.label23 = new Neusoft.FrameWork.WinForms.Controls.NeuLabel();
this.txttime3 = new Neusoft.FrameWork.WinForms.Controls.ValidatedTextBox();
this.dtenddate2 = new Neusoft.FrameWork.WinForms.Controls.NeuDateTimePicker();
this.label16 = new Neusoft.FrameWork.WinForms.Controls.NeuLabel();
this.dtbegindate2 = new Neusoft.FrameWork.WinForms.Controls.NeuDateTimePicker();
this.label17 = new Neusoft.FrameWork.WinForms.Controls.NeuLabel();
this.label18 = new Neusoft.FrameWork.WinForms.Controls.NeuLabel();
this.txtday2 = new Neusoft.FrameWork.WinForms.Controls.ValidatedTextBox();
this.label19 = new Neusoft.FrameWork.WinForms.Controls.NeuLabel();
this.txttime2 = new Neusoft.FrameWork.WinForms.Controls.ValidatedTextBox();
this.dtenddate1 = new Neusoft.FrameWork.WinForms.Controls.NeuDateTimePicker();
this.label15 = new Neusoft.FrameWork.WinForms.Controls.NeuLabel();
this.dtbegindate1 = new Neusoft.FrameWork.WinForms.Controls.NeuDateTimePicker();
this.label14 = new Neusoft.FrameWork.WinForms.Controls.NeuLabel();
this.label13 = new Neusoft.FrameWork.WinForms.Controls.NeuLabel();
this.txtday1 = new Neusoft.FrameWork.WinForms.Controls.ValidatedTextBox();
this.label12 = new Neusoft.FrameWork.WinForms.Controls.NeuLabel();
this.txttime1 = new Neusoft.FrameWork.WinForms.Controls.ValidatedTextBox();
this.label11 = new Neusoft.FrameWork.WinForms.Controls.NeuLabel();
this.label8 = new Neusoft.FrameWork.WinForms.Controls.NeuLabel();
this.txtgy3 = new Neusoft.FrameWork.WinForms.Controls.ValidatedTextBox();
this.label6 = new Neusoft.FrameWork.WinForms.Controls.NeuLabel();
this.txtgy2 = new Neusoft.FrameWork.WinForms.Controls.ValidatedTextBox();
this.label7 = new Neusoft.FrameWork.WinForms.Controls.NeuLabel();
this.label5 = new Neusoft.FrameWork.WinForms.Controls.NeuLabel();
this.txtgy1 = new Neusoft.FrameWork.WinForms.Controls.ValidatedTextBox();
this.txtRdeviceid = new Neusoft.FrameWork.WinForms.Controls.NeuTextBox();
this.txtRprocessid = new Neusoft.FrameWork.WinForms.Controls.NeuTextBox();
this.txtRmodeid = new Neusoft.FrameWork.WinForms.Controls.NeuTextBox();
this.label3 = new Neusoft.FrameWork.WinForms.Controls.NeuLabel();
this.label2 = new Neusoft.FrameWork.WinForms.Controls.NeuLabel();
this.label1 = new Neusoft.FrameWork.WinForms.Controls.NeuLabel();
this.label4 = new Neusoft.FrameWork.WinForms.Controls.NeuLabel();
this.label28 = new Neusoft.FrameWork.WinForms.Controls.NeuLabel();
((System.ComponentModel.ISupportInitialize)(this.fpEnter1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.fpEnter1_Sheet1)).BeginInit();
this.panel1.SuspendLayout();
this.SuspendLayout();
//
// fpEnter1
//
this.fpEnter1.About = "2.5.2007.2005";
this.fpEnter1.AccessibleDescription = "";
this.fpEnter1.Dock = System.Windows.Forms.DockStyle.Fill;
this.fpEnter1.EditModePermanent = true;
this.fpEnter1.EditModeReplace = true;
this.fpEnter1.Location = new System.Drawing.Point(0, 168);
this.fpEnter1.Name = "fpEnter1";
this.fpEnter1.SelectNone = false;
this.fpEnter1.Sheets.AddRange(new FarPoint.Win.Spread.SheetView[] {
this.fpEnter1_Sheet1
});
this.fpEnter1.ShowListWhenOfFocus = false;
this.fpEnter1.Size = new System.Drawing.Size(840, 384);
this.fpEnter1.TabIndex = 0;
tipAppearance2.BackColor = System.Drawing.SystemColors.Info;
tipAppearance2.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
tipAppearance2.ForeColor = System.Drawing.SystemColors.InfoText;
this.fpEnter1.TextTipAppearance = tipAppearance2;
//
// fpEnter1_Sheet1
//
this.fpEnter1_Sheet1.Reset();
this.fpEnter1_Sheet1.SheetName = "Sheet1";
// Formulas and custom names must be loaded with R1C1 reference style
this.fpEnter1_Sheet1.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.R1C1;
this.fpEnter1_Sheet1.ColumnCount = 8;
this.fpEnter1_Sheet1.ActiveSkin = new FarPoint.Win.Spread.SheetSkin("CustomSkin1", System.Drawing.SystemColors.Control, System.Drawing.Color.Empty, System.Drawing.Color.Empty, System.Drawing.Color.LightGray, FarPoint.Win.Spread.GridLines.Both, System.Drawing.Color.White, System.Drawing.Color.Empty, System.Drawing.Color.Empty, System.Drawing.Color.Empty, System.Drawing.Color.Empty, System.Drawing.Color.Empty, false, false, true, true, true);
this.fpEnter1_Sheet1.ColumnHeader.Cells.Get(0, 0).Value = "时间";
this.fpEnter1_Sheet1.ColumnHeader.Cells.Get(0, 1).Value = "药物名称";
this.fpEnter1_Sheet1.ColumnHeader.Cells.Get(0, 2).Value = "单位";
this.fpEnter1_Sheet1.ColumnHeader.Cells.Get(0, 3).Value = "疗程";
this.fpEnter1_Sheet1.ColumnHeader.Cells.Get(0, 4).Value = "结果";
this.fpEnter1_Sheet1.ColumnHeader.Cells.Get(0, 5).Value = "用量";
this.fpEnter1_Sheet1.ColumnHeader.Cells.Get(0, 6).Value = "药品编码";
this.fpEnter1_Sheet1.ColumnHeader.Cells.Get(0, 7).Value = "序号";
this.fpEnter1_Sheet1.ColumnHeader.DefaultStyle.BackColor = System.Drawing.Color.White;
this.fpEnter1_Sheet1.ColumnHeader.DefaultStyle.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Bold);
this.fpEnter1_Sheet1.ColumnHeader.DefaultStyle.Locked = false;
this.fpEnter1_Sheet1.ColumnHeader.DefaultStyle.Parent = "HeaderDefault";
this.fpEnter1_Sheet1.Columns.Get(0).Label = "时间";
this.fpEnter1_Sheet1.Columns.Get(0).Width = 65F;
this.fpEnter1_Sheet1.RowHeader.Columns.Default.Resizable = false;
this.fpEnter1_Sheet1.RowHeader.Columns.Get(0).Width = 40F;
this.fpEnter1_Sheet1.RowHeader.DefaultStyle.BackColor = System.Drawing.Color.White;
this.fpEnter1_Sheet1.RowHeader.DefaultStyle.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Bold);
this.fpEnter1_Sheet1.RowHeader.DefaultStyle.Locked = false;
this.fpEnter1_Sheet1.RowHeader.DefaultStyle.Parent = "HeaderDefault";
this.fpEnter1_Sheet1.SheetCornerStyle.BackColor = System.Drawing.Color.White;
this.fpEnter1_Sheet1.SheetCornerStyle.Locked = false;
this.fpEnter1_Sheet1.SheetCornerStyle.Parent = "HeaderDefault";
this.fpEnter1_Sheet1.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.A1;
//
// contextMenu1
//
this.contextMenu1.MenuItems.AddRange(new System.Windows.Forms.MenuItem[] {
this.menuItem2
});
//
// menuItem2
//
this.menuItem2.Index = 0;
this.menuItem2.Text = "删除";
this.menuItem2.Click += new System.EventHandler(this.menuItem2_Click);
//
// panel1
//
this.panel1.BackColor = System.Drawing.Color.Azure;
this.panel1.Controls.Add(this.txtCmethod);
this.panel1.Controls.Add(this.txtCmodeid);
this.panel1.Controls.Add(this.label29);
this.panel1.Controls.Add(this.dtenddate3);
this.panel1.Controls.Add(this.label20);
this.panel1.Controls.Add(this.dtbegindate3);
this.panel1.Controls.Add(this.label21);
this.panel1.Controls.Add(this.label22);
this.panel1.Controls.Add(this.txtday3);
this.panel1.Controls.Add(this.label23);
this.panel1.Controls.Add(this.txttime3);
this.panel1.Controls.Add(this.dtenddate2);
this.panel1.Controls.Add(this.label16);
this.panel1.Controls.Add(this.dtbegindate2);
this.panel1.Controls.Add(this.label17);
this.panel1.Controls.Add(this.label18);
this.panel1.Controls.Add(this.txtday2);
this.panel1.Controls.Add(this.label19);
this.panel1.Controls.Add(this.txttime2);
this.panel1.Controls.Add(this.dtenddate1);
this.panel1.Controls.Add(this.label15);
this.panel1.Controls.Add(this.dtbegindate1);
this.panel1.Controls.Add(this.label14);
this.panel1.Controls.Add(this.label13);
this.panel1.Controls.Add(this.txtday1);
this.panel1.Controls.Add(this.label12);
this.panel1.Controls.Add(this.txttime1);
this.panel1.Controls.Add(this.label11);
this.panel1.Controls.Add(this.label8);
this.panel1.Controls.Add(this.txtgy3);
this.panel1.Controls.Add(this.label6);
this.panel1.Controls.Add(this.txtgy2);
this.panel1.Controls.Add(this.label7);
this.panel1.Controls.Add(this.label5);
this.panel1.Controls.Add(this.txtgy1);
this.panel1.Controls.Add(this.txtRdeviceid);
this.panel1.Controls.Add(this.txtRprocessid);
this.panel1.Controls.Add(this.txtRmodeid);
this.panel1.Controls.Add(this.label3);
this.panel1.Controls.Add(this.label2);
this.panel1.Controls.Add(this.label1);
this.panel1.Controls.Add(this.label4);
this.panel1.Controls.Add(this.label28);
this.panel1.Dock = System.Windows.Forms.DockStyle.Top;
this.panel1.Location = new System.Drawing.Point(0, 0);
this.panel1.Name = "panel1";
this.panel1.Size = new System.Drawing.Size(840, 168);
this.panel1.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D;
this.panel1.TabIndex = 1;
//
// txtCmethod
//
this.txtCmethod.Location = new System.Drawing.Point(304, 136);
this.txtCmethod.MaxLength = 6;
this.txtCmethod.Name = "txtCmethod";
this.txtCmethod.Size = new System.Drawing.Size(100, 21);
this.txtCmethod.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D;
this.txtCmethod.TabIndex = 60;
this.txtCmethod.Enter += new System.EventHandler(this.Cmethod_Enter);
this.txtCmethod.TextChanged += new System.EventHandler(this.Cmethod_TextChanged);
this.txtCmethod.KeyDown += new System.Windows.Forms.KeyEventHandler(this.Cmethod_KeyDown);
//
// txtCmodeid
//
this.txtCmodeid.Location = new System.Drawing.Point(88, 136);
this.txtCmodeid.MaxLength = 6;
this.txtCmodeid.Name = "txtCmodeid";
this.txtCmodeid.Size = new System.Drawing.Size(100, 21);
this.txtCmodeid.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D;
this.txtCmodeid.TabIndex = 52;
this.txtCmodeid.Enter += new System.EventHandler(this.Cmodeid_Enter);
this.txtCmodeid.TextChanged += new System.EventHandler(this.Cmodeid_TextChanged);
this.txtCmodeid.KeyDown += new System.Windows.Forms.KeyEventHandler(this.Cmodeid_KeyDown);
//
// label29
//
this.label29.AutoSize = true;
this.label29.Location = new System.Drawing.Point(232, 136);
this.label29.Name = "label29";
this.label29.Size = new System.Drawing.Size(53, 12);
this.label29.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D;
this.label29.TabIndex = 51;
this.label29.Text = "化疗方法";
this.label29.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
//
// dtenddate3
//
this.dtenddate3.Location = new System.Drawing.Point(576, 104);
this.dtenddate3.Name = "dtenddate3";
this.dtenddate3.Size = new System.Drawing.Size(112, 21);
this.dtenddate3.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D;
this.dtenddate3.TabIndex = 41;
this.dtenddate3.KeyDown += new System.Windows.Forms.KeyEventHandler(this.end_date3_KeyDown);
//
// label20
//
this.label20.Location = new System.Drawing.Point(536, 104);
this.label20.Name = "label20";
this.label20.Size = new System.Drawing.Size(32, 23);
this.label20.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D;
this.label20.TabIndex = 40;
this.label20.Text = "止日";
this.label20.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
//
// dtbegindate3
//
this.dtbegindate3.Location = new System.Drawing.Point(408, 104);
this.dtbegindate3.Name = "dtbegindate3";
this.dtbegindate3.Size = new System.Drawing.Size(112, 21);
this.dtbegindate3.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D;
this.dtbegindate3.TabIndex = 39;
this.dtbegindate3.KeyDown += new System.Windows.Forms.KeyEventHandler(this.begin_date3_KeyDown);
//
// label21
//
this.label21.Location = new System.Drawing.Point(376, 104);
this.label21.Name = "label21";
this.label21.Size = new System.Drawing.Size(32, 23);
this.label21.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D;
this.label21.TabIndex = 38;
this.label21.Text = "起日";
this.label21.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
//
// label22
//
this.label22.Location = new System.Drawing.Point(344, 104);
this.label22.Name = "label22";
this.label22.Size = new System.Drawing.Size(24, 23);
this.label22.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D;
this.label22.TabIndex = 37;
this.label22.Text = "天";
this.label22.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
//
// txtday3
//
this.txtday3.AllowNegative = false;
this.txtday3.AutoPadRightZero = false;
this.txtday3.Location = new System.Drawing.Point(304, 104);
this.txtday3.MaxDigits = 0;
this.txtday3.MaxLength = 6;
this.txtday3.Name = "txtday3";
this.txtday3.Size = new System.Drawing.Size(32, 21);
this.txtday3.TabIndex = 36;
this.txtday3.WillShowError = false;
this.txtday3.KeyDown += new System.Windows.Forms.KeyEventHandler(this.day3_KeyDown);
//
// label23
//
this.label23.Location = new System.Drawing.Point(272, 104);
this.label23.Name = "label23";
this.label23.Size = new System.Drawing.Size(24, 23);
this.label23.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D;
this.label23.TabIndex = 35;
this.label23.Text = "次";
this.label23.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
//
// txttime3
//
this.txttime3.AllowNegative = false;
this.txttime3.AutoPadRightZero = false;
this.txttime3.Location = new System.Drawing.Point(232, 104);
this.txttime3.MaxDigits = 0;
this.txttime3.MaxLength = 6;
this.txttime3.Name = "txttime3";
this.txttime3.Size = new System.Drawing.Size(32, 21);
this.txttime3.TabIndex = 34;
this.txttime3.WillShowError = false;
this.txttime3.KeyDown += new System.Windows.Forms.KeyEventHandler(this.time3_KeyDown);
//
// dtenddate2
//
this.dtenddate2.Location = new System.Drawing.Point(576, 72);
this.dtenddate2.Name = "dtenddate2";
this.dtenddate2.Size = new System.Drawing.Size(112, 21);
this.dtenddate2.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D;
this.dtenddate2.TabIndex = 33;
this.dtenddate2.KeyDown += new System.Windows.Forms.KeyEventHandler(this.end_date2_KeyDown);
//
// label16
//
this.label16.Location = new System.Drawing.Point(536, 72);
this.label16.Name = "label16";
this.label16.Size = new System.Drawing.Size(32, 23);
this.label16.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D;
this.label16.TabIndex = 32;
this.label16.Text = "止日";
this.label16.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
//
// dtbegindate2
//
this.dtbegindate2.Location = new System.Drawing.Point(408, 72);
this.dtbegindate2.Name = "dtbegindate2";
this.dtbegindate2.Size = new System.Drawing.Size(112, 21);
this.dtbegindate2.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D;
this.dtbegindate2.TabIndex = 31;
this.dtbegindate2.KeyDown += new System.Windows.Forms.KeyEventHandler(this.begin_date2_KeyDown);
//
// label17
//
this.label17.Location = new System.Drawing.Point(376, 72);
this.label17.Name = "label17";
this.label17.Size = new System.Drawing.Size(32, 23);
this.label17.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D;
this.label17.TabIndex = 30;
this.label17.Text = "起日";
this.label17.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
//
// label18
//
this.label18.Location = new System.Drawing.Point(344, 72);
this.label18.Name = "label18";
this.label18.Size = new System.Drawing.Size(24, 23);
this.label18.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D;
this.label18.TabIndex = 29;
this.label18.Text = "天";
this.label18.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
//
// txtday2
//
this.txtday2.AllowNegative = false;
this.txtday2.AutoPadRightZero = false;
this.txtday2.Location = new System.Drawing.Point(304, 72);
this.txtday2.MaxDigits = 0;
this.txtday2.MaxLength = 6;
this.txtday2.Name = "txtday2";
this.txtday2.Size = new System.Drawing.Size(32, 21);
this.txtday2.TabIndex = 28;
this.txtday2.WillShowError = false;
this.txtday2.KeyDown += new System.Windows.Forms.KeyEventHandler(this.day2_KeyDown);
//
// label19
//
this.label19.Location = new System.Drawing.Point(272, 72);
this.label19.Name = "label19";
this.label19.Size = new System.Drawing.Size(24, 23);
this.label19.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D;
this.label19.TabIndex = 27;
this.label19.Text = "次";
this.label19.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
//
// txttime2
//
this.txttime2.AllowNegative = false;
this.txttime2.AutoPadRightZero = false;
this.txttime2.Location = new System.Drawing.Point(232, 72);
this.txttime2.MaxDigits = 0;
this.txttime2.MaxLength = 6;
this.txttime2.Name = "txttime2";
this.txttime2.Size = new System.Drawing.Size(32, 21);
this.txttime2.TabIndex = 26;
this.txttime2.WillShowError = false;
this.txttime2.KeyDown += new System.Windows.Forms.KeyEventHandler(this.time2_KeyDown);
//
// dtenddate1
//
this.dtenddate1.Location = new System.Drawing.Point(576, 40);
this.dtenddate1.Name = "dtenddate1";
this.dtenddate1.Size = new System.Drawing.Size(112, 21);
this.dtenddate1.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D;
this.dtenddate1.TabIndex = 25;
this.dtenddate1.KeyDown += new System.Windows.Forms.KeyEventHandler(this.end_date1_KeyDown);
//
// label15
//
this.label15.Location = new System.Drawing.Point(536, 40);
this.label15.Name = "label15";
this.label15.Size = new System.Drawing.Size(32, 23);
this.label15.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D;
this.label15.TabIndex = 24;
this.label15.Text = "止日";
this.label15.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
//
// dtbegindate1
//
this.dtbegindate1.Location = new System.Drawing.Point(408, 40);
this.dtbegindate1.Name = "dtbegindate1";
this.dtbegindate1.Size = new System.Drawing.Size(112, 21);
this.dtbegindate1.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D;
this.dtbegindate1.TabIndex = 23;
this.dtbegindate1.KeyDown += new System.Windows.Forms.KeyEventHandler(this.begin_date1_KeyDown);
//
// label14
//
this.label14.Location = new System.Drawing.Point(376, 40);
this.label14.Name = "label14";
this.label14.Size = new System.Drawing.Size(32, 23);
this.label14.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D;
this.label14.TabIndex = 22;
this.label14.Text = "起日";
this.label14.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
//
// label13
//
this.label13.Location = new System.Drawing.Point(344, 40);
this.label13.Name = "label13";
this.label13.Size = new System.Drawing.Size(24, 23);
this.label13.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D;
this.label13.TabIndex = 21;
this.label13.Text = "天";
this.label13.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
//
// txtday1
//
this.txtday1.AllowNegative = false;
this.txtday1.AutoPadRightZero = false;
this.txtday1.Location = new System.Drawing.Point(304, 40);
this.txtday1.MaxDigits = 0;
this.txtday1.MaxLength = 6;
this.txtday1.Name = "txtday1";
this.txtday1.Size = new System.Drawing.Size(32, 21);
this.txtday1.TabIndex = 20;
this.txtday1.WillShowError = false;
this.txtday1.KeyDown += new System.Windows.Forms.KeyEventHandler(this.day1_KeyDown);
//
// label12
//
this.label12.Location = new System.Drawing.Point(272, 40);
this.label12.Name = "label12";
this.label12.Size = new System.Drawing.Size(24, 23);
this.label12.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D;
this.label12.TabIndex = 19;
this.label12.Text = "次";
this.label12.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
//
// txttime1
//
this.txttime1.AllowNegative = false;
this.txttime1.AutoPadRightZero = false;
this.txttime1.Location = new System.Drawing.Point(232, 40);
this.txttime1.MaxDigits = 0;
this.txttime1.MaxLength = 6;
this.txttime1.Name = "txttime1";
this.txttime1.Size = new System.Drawing.Size(32, 21);
this.txttime1.TabIndex = 18;
this.txttime1.WillShowError = false;
this.txttime1.KeyDown += new System.Windows.Forms.KeyEventHandler(this.time1_KeyDown);
//
// label11
//
this.label11.AutoSize = true;
this.label11.Location = new System.Drawing.Point(16, 104);
this.label11.Name = "label11";
this.label11.Size = new System.Drawing.Size(65, 12);
this.label11.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D;
this.label11.TabIndex = 16;
this.label11.Text = "转移灶计量";
this.label11.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
//
// label8
//
this.label8.Location = new System.Drawing.Point(192, 104);
this.label8.Name = "label8";
this.label8.Size = new System.Drawing.Size(24, 23);
this.label8.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D;
this.label8.TabIndex = 14;
this.label8.Text = "GY";
this.label8.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
//
// txtgy3
//
this.txtgy3.AllowNegative = false;
this.txtgy3.AutoPadRightZero = false;
this.txtgy3.Location = new System.Drawing.Point(88, 104);
this.txtgy3.MaxDigits = 0;
this.txtgy3.MaxLength = 6;
this.txtgy3.Name = "txtgy3";
this.txtgy3.Size = new System.Drawing.Size(100, 21);
this.txtgy3.TabIndex = 12;
this.txtgy3.WillShowError = false;
this.txtgy3.KeyDown += new System.Windows.Forms.KeyEventHandler(this.gy3_KeyDown);
//
// label6
//
this.label6.Location = new System.Drawing.Point(192, 72);
this.label6.Name = "label6";
this.label6.Size = new System.Drawing.Size(24, 23);
this.label6.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D;
this.label6.TabIndex = 11;
this.label6.Text = "GY";
this.label6.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
//
// txtgy2
//
this.txtgy2.AllowNegative = false;
this.txtgy2.AutoPadRightZero = false;
this.txtgy2.Location = new System.Drawing.Point(88, 72);
this.txtgy2.MaxDigits = 0;
this.txtgy2.MaxLength = 6;
this.txtgy2.Name = "txtgy2";
this.txtgy2.Size = new System.Drawing.Size(100, 21);
this.txtgy2.TabIndex = 9;
this.txtgy2.WillShowError = false;
this.txtgy2.KeyDown += new System.Windows.Forms.KeyEventHandler(this.gy2_KeyDown);
//
// label7
//
this.label7.AutoSize = true;
this.label7.Location = new System.Drawing.Point(16, 72);
this.label7.Name = "label7";
this.label7.Size = new System.Drawing.Size(65, 12);
this.label7.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D;
this.label7.TabIndex = 10;
this.label7.Text = "区域淋巴结";
this.label7.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
//
// label5
//
this.label5.Location = new System.Drawing.Point(192, 40);
this.label5.Name = "label5";
this.label5.Size = new System.Drawing.Size(24, 23);
this.label5.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D;
this.label5.TabIndex = 8;
this.label5.Text = "GY";
this.label5.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
//
// txtgy1
//
this.txtgy1.AllowNegative = false;
this.txtgy1.AutoPadRightZero = false;
this.txtgy1.Location = new System.Drawing.Point(88, 40);
this.txtgy1.MaxDigits = 0;
this.txtgy1.MaxLength = 6;
this.txtgy1.Name = "txtgy1";
this.txtgy1.Size = new System.Drawing.Size(100, 21);
this.txtgy1.TabIndex = 6;
this.txtgy1.WillShowError = false;
this.txtgy1.KeyDown += new System.Windows.Forms.KeyEventHandler(this.gy1_KeyDown);
//
// txtRdeviceid
//
this.txtRdeviceid.Location = new System.Drawing.Point(520, 8);
this.txtRdeviceid.MaxLength = 5;
this.txtRdeviceid.Name = "txtRdeviceid";
this.txtRdeviceid.Size = new System.Drawing.Size(100, 21);
this.txtRdeviceid.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D;
this.txtRdeviceid.TabIndex = 5;
this.txtRdeviceid.Enter += new System.EventHandler(this.Rdeviceid_Enter);
this.txtRdeviceid.TextChanged += new System.EventHandler(this.Rdeviceid_TextChanged);
this.txtRdeviceid.KeyDown += new System.Windows.Forms.KeyEventHandler(this.Rdeviceid_KeyDown);
//
// txtRprocessid
//
this.txtRprocessid.Location = new System.Drawing.Point(312, 8);
this.txtRprocessid.MaxLength = 5;
this.txtRprocessid.Name = "txtRprocessid";
this.txtRprocessid.Size = new System.Drawing.Size(100, 21);
this.txtRprocessid.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D;
this.txtRprocessid.TabIndex = 4;
this.txtRprocessid.Enter += new System.EventHandler(this.Rprocessid_Enter);
this.txtRprocessid.TextChanged += new System.EventHandler(this.Rprocessid_TextChanged);
this.txtRprocessid.KeyDown += new System.Windows.Forms.KeyEventHandler(this.Rprocessid_KeyDown);
//
// txtRmodeid
//
this.txtRmodeid.Location = new System.Drawing.Point(88, 8);
this.txtRmodeid.MaxLength = 5;
this.txtRmodeid.Name = "txtRmodeid";
this.txtRmodeid.Size = new System.Drawing.Size(100, 21);
this.txtRmodeid.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D;
this.txtRmodeid.TabIndex = 3;
this.txtRmodeid.Enter += new System.EventHandler(this.Rmodeid_Enter);
this.txtRmodeid.TextChanged += new System.EventHandler(this.Rmodeid_TextChanged);
this.txtRmodeid.KeyDown += new System.Windows.Forms.KeyEventHandler(this.Rmodeid_KeyDown);
//
// label3
//
this.label3.AutoSize = true;
this.label3.Location = new System.Drawing.Point(432, 8);
this.label3.Name = "label3";
this.label3.Size = new System.Drawing.Size(53, 12);
this.label3.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D;
this.label3.TabIndex = 2;
this.label3.Text = "放疗装置";
this.label3.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
//
// label2
//
this.label2.AutoSize = true;
this.label2.Location = new System.Drawing.Point(232, 8);
this.label2.Name = "label2";
this.label2.Size = new System.Drawing.Size(53, 12);
this.label2.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D;
this.label2.TabIndex = 1;
this.label2.Text = "放疗程式";
this.label2.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
//
// label1
//
this.label1.AutoSize = true;
this.label1.Location = new System.Drawing.Point(16, 8);
this.label1.Name = "label1";
this.label1.Size = new System.Drawing.Size(53, 12);
this.label1.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D;
this.label1.TabIndex = 0;
this.label1.Text = "放疗方式";
this.label1.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
//
// label4
//
this.label4.AutoSize = true;
this.label4.Location = new System.Drawing.Point(16, 40);
this.label4.Name = "label4";
this.label4.Size = new System.Drawing.Size(65, 12);
this.label4.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D;
this.label4.TabIndex = 7;
this.label4.Text = "原发灶计量";
this.label4.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
//
// label28
//
this.label28.AutoSize = true;
this.label28.Location = new System.Drawing.Point(16, 136);
this.label28.Name = "label28";
this.label28.Size = new System.Drawing.Size(53, 12);
this.label28.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D;
this.label28.TabIndex = 50;
this.label28.Text = "化疗方式";
this.label28.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
//
// ucTumourCard
//
this.ContextMenu = this.contextMenu1;
this.Controls.Add(this.fpEnter1);
this.Controls.Add(this.panel1);
this.Name = "ucTumourCard";
this.Size = new System.Drawing.Size(840, 552);
this.Load += new System.EventHandler(this.ucTumourCard_Load);
((System.ComponentModel.ISupportInitialize)(this.fpEnter1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.fpEnter1_Sheet1)).EndInit();
this.panel1.ResumeLayout(false);
this.panel1.PerformLayout();
this.ResumeLayout(false);
}
private void Firstadddata()
{
//生成表3-1
FarPoint.Win.Spread.SheetView Sheet31 = new FarPoint.Win.Spread.SheetView();
//添加表3-1
fpSpread1.Sheets.Add(Sheet31);
//创建表3-1
sh31.Build(Sheet31, year, ProjID, SxXjName);
fc.Sheet_Colautoenter(fpSpread1);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void barButtonItem2_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
wait = new WaitDialogForm("", "正在更新数据, 请稍候...");
////由于SheetView已经没有了所以移除SheetView
//MessageBox.Show(fpSpread1.Sheets[0].SheetName);
//===================================================
FarPoint.Win.Spread.SheetView obj = null;
//由于更新数据时间太长需要建个空表做初始界面
FarPoint.Win.Spread.SheetView fpSpread1_SheetN = new FarPoint.Win.Spread.SheetView();
fpSpread1.Sheets.Add(fpSpread1_SheetN);
obj = fpSpread1.ActiveSheet;
fpSpread1.ActiveSheet = fpSpread1_SheetN;
//PF.CreateSheet(this, fpSpread1, "kk");
SheetIndex = fpSpread1.ActiveSheetIndex;//记住当前的SheetView的索引值
//fpSpread1.ActiveSheet=fpSpread1.Sheets[fpSpread1.Sheets.Count-1];//把当前界面给空表
//PF.RemoveSheetView(this.fpSpread1, (fpSpread1.Sheets.Count - 1));//清空所有行列
//this.fpSpread1.Sheets.Clear();
IsCreateSheet = false;
fpSpread1.Sheets[1].RowCount = 0;
fpSpread1.Sheets[1].ColumnCount = 0;
S_15.SetSheet_15Title(this, fpSpread1.Sheets[1], "铜陵县分行业用电历史实绩统计表");
fpSpread1.Sheets[2].RowCount = 0;
fpSpread1.Sheets[2].ColumnCount = 0;
S_16.SetSheet_16Title(this, fpSpread1.Sheets[2], "附表16 铜陵县历年用电量及负荷分区统计");
//fpSpread1.Sheets[3].RowCount = 0;
//fpSpread1.Sheets[3].ColumnCount = 0;
//S_17.SetSheet_17Title(this, fpSpread1.Sheets[3], "附表17 规划年铜陵县经济发展预测结果表");
fpSpread1.Sheets[4].RowCount = 0;
fpSpread1.Sheets[4].ColumnCount = 0;
S_18.SetSheet_18Title(this, fpSpread1.Sheets[4], "附表18 规划年铜陵县大用户统计信息表");
//fpSpread1.Sheets[5].RowCount = 0;
//fpSpread1.Sheets[5].ColumnCount = 0;
//S_19.SetSheet_19Title(this, fpSpread1.Sheets[5], "2010-2020年铜陵县县负荷预测表");
fpSpread1.Sheets[6].RowCount = 0;
fpSpread1.Sheets[6].ColumnCount = 0;
S_20.SetSheet_20Title(this, fpSpread1.Sheets[6], "附表20 规划年铜陵县规划装机进度表");
//newwait.Close();
IsCreateSheet = true;
fpSpread1.ActiveSheet = obj;//fpSpread1.Sheets[SheetIndex];//把以前显示的界面在显示出来
//if (obj.SheetName == "附表10 铜陵县中压线路“N-1”分析" || obj.SheetName == "附表11 铜陵县110kV及35kV变电站主变故障或检修“N-1”通过情况")
//{
// this.barEditItem1.Visibility = DevExpress.XtraBars.BarItemVisibility.Never;
//}
//删除临时SheetView
//fpSpread1.Sheets.Remove(fpSpread1.Sheets[fpSpread1.Sheets.Count - 1]);
fpSpread1.Sheets.Remove(fpSpread1_SheetN);
wait.Close();
MessageBox.Show("更新数据完成！");
}
/// <summary>
/// 更新
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void barButtonItem2_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
wait = new WaitDialogForm("", "正在更新数据, 请稍候...");
////由于SheetView已经没有了所以移除SheetView
//MessageBox.Show(fpSpread1.Sheets[0].SheetName);
//===================================================
FarPoint.Win.Spread.SheetView obj = null;
//由于更新数据时间太长需要建个空表做初始界面
FarPoint.Win.Spread.SheetView fpSpread1_SheetN = new FarPoint.Win.Spread.SheetView();
fpSpread1.Sheets.Add(fpSpread1_SheetN);
obj = fpSpread1.ActiveSheet;
fpSpread1.ActiveSheet = fpSpread1_SheetN;
//PF.CreateSheet(this, fpSpread1, "kk");
SheetIndex = fpSpread1.ActiveSheetIndex;//记住当前的SheetView的索引值
//fpSpread1.ActiveSheet=fpSpread1.Sheets[fpSpread1.Sheets.Count-1];//把当前界面给空表
PF.RemoveSheetView(this.fpSpread1, (fpSpread1.Sheets.Count - 1));//清空所有行列
//this.fpSpread1.Sheets.Clear();
IsCreateSheet = false;
S_30.SetSheet_30Title(this, fpSpread1.Sheets[0], "附表30 本地区“十二五”规划项目资金需求表 ");
//newwait.Close();
IsCreateSheet = true;
fpSpread1.ActiveSheet = obj;//fpSpread1.Sheets[SheetIndex];//把以前显示的界面在显示出来
//if (obj.SheetName == "附表10 铜陵县中压线路“N-1”分析" || obj.SheetName == "附表11 铜陵县110kV及35kV变电站主变故障或检修“N-1”通过情况")
//{
// this.barEditItem1.Visibility = DevExpress.XtraBars.BarItemVisibility.Never;
//}
//删除临时SheetView
//fpSpread1.Sheets.Remove(fpSpread1.Sheets[fpSpread1.Sheets.Count - 1]);
fpSpread1.Sheets.Remove(fpSpread1_SheetN);
//MessageBox.Show("更新数据完成！");
wait.Close();
}
private void Firstadddata()
{
//如果没有文件，则全部表格重写
//新建表7-1
FarPoint.Win.Spread.SheetView Sheet71 = new FarPoint.Win.Spread.SheetView();
//新建表7-2
FarPoint.Win.Spread.SheetView Sheet72 = new FarPoint.Win.Spread.SheetView();
//新建表7-2附表36
FarPoint.Win.Spread.SheetView Sheet72_36 = new FarPoint.Win.Spread.SheetView();
//新建表7-3
FarPoint.Win.Spread.SheetView Sheet73 = new FarPoint.Win.Spread.SheetView();
//新建表7-3附表37
FarPoint.Win.Spread.SheetView Sheet73_37 = new FarPoint.Win.Spread.SheetView();
//新建表7-4
FarPoint.Win.Spread.SheetView Sheet74 = new FarPoint.Win.Spread.SheetView();
//新建表7-4附表38
FarPoint.Win.Spread.SheetView Sheet74_38 = new FarPoint.Win.Spread.SheetView();
//新建表7-5
FarPoint.Win.Spread.SheetView Sheet75 = new FarPoint.Win.Spread.SheetView();
//新建表7-5附表39
FarPoint.Win.Spread.SheetView Sheet75_39 = new FarPoint.Win.Spread.SheetView();
//新建表7-6
FarPoint.Win.Spread.SheetView Sheet76 = new FarPoint.Win.Spread.SheetView();
//新建表7-6附表40
FarPoint.Win.Spread.SheetView Sheet76_40 = new FarPoint.Win.Spread.SheetView();
//新建表7-7
FarPoint.Win.Spread.SheetView Sheet77 = new FarPoint.Win.Spread.SheetView();
//新建表7-8
FarPoint.Win.Spread.SheetView Sheet78 = new FarPoint.Win.Spread.SheetView();
//新建表7-9
FarPoint.Win.Spread.SheetView Sheet79 = new FarPoint.Win.Spread.SheetView();
//根据窗口变化全部添满
fpSpread1.Dock = System.Windows.Forms.DockStyle.Fill;
Sheet71.SheetName = "表7-1";
fpSpread1.Sheets.Add(Sheet71);
Sheet72.SheetName = "表7-2";
fpSpread1.Sheets.Add(Sheet72);
Sheet72_36.SheetName = "表7-2 附表36";
fpSpread1.Sheets.Add(Sheet72_36);
Sheet73.SheetName = "表7-3";
fpSpread1.Sheets.Add(Sheet73);
Sheet73_37.SheetName = "表7-3 附表37";
fpSpread1.Sheets.Add(Sheet73_37);
Sheet74.SheetName = "表7-4 ";
fpSpread1.Sheets.Add(Sheet74);
Sheet74_38.SheetName = "表7-4 附表38";
fpSpread1.Sheets.Add(Sheet74_38);
Sheet75.SheetName = "表7-5";
fpSpread1.Sheets.Add(Sheet75);
Sheet75_39.SheetName = "表7-5 附表39";
fpSpread1.Sheets.Add(Sheet75_39);
Sheet76.SheetName = "表7-6";
fpSpread1.Sheets.Add(Sheet76);
Sheet76_40.SheetName = "表7-6 附表40";
fpSpread1.Sheets.Add(Sheet76_40);
Sheet77.SheetName = "表7-7";
fpSpread1.Sheets.Add(Sheet77);
Sheet78.SheetName = "表7-8";
fpSpread1.Sheets.Add(Sheet78);
Sheet79.SheetName = "表7-9";
fpSpread1.Sheets.Add(Sheet79);
build_sheet71(fpSpread1.Sheets[0]);
build_Sheet72(fpSpread1.Sheets[1]);
build_Sheet72_36(fpSpread1.Sheets[2]);
build_Sheet73(fpSpread1.Sheets[3]);
build_Sheet73_37(fpSpread1.Sheets[4]);
build_Sheet74(fpSpread1.Sheets[5]);
build_Sheet74_38(fpSpread1.Sheets[6]);
build_Sheet75(fpSpread1.Sheets[7]);
build_Sheet75_39(fpSpread1.Sheets[8]);
build_Sheet76(fpSpread1.Sheets[9]);
build_Sheet76_40(fpSpread1.Sheets[10]);
build_Sheet77(fpSpread1.Sheets[11]);
build_Sheet78(fpSpread1.Sheets[12]);
build_Sheet79(fpSpread1.Sheets[13]);
}
