private string EnsureBaseYear(string baseyear)
{
PSP_BaseYearRate BaseYearrate = (PSP_BaseYearRate)Common.Services.BaseService.GetObject("SelectPSP_BaseYearRateByKey", baseyearFlag);
if (BaseYearrate == null)
{
BaseYearrate = new PSP_BaseYearRate();
BaseYearrate.UID = "4132ae36-36b3-47ed-a9b9-163a6479d5d3";
BaseYearrate.BaseYear = "1990";
BaseYearrate.YearRate = "0";
Services.BaseService.Create <PSP_BaseYearRate>(BaseYearrate);
//
}
if (BaseYearrate.BaseYear != "0")
{
Hashtable ha = new Hashtable();
ha.Add("Flag", typeFlag2);
ha.Add("Year", Convert.ToInt32(BaseYearrate.BaseYear));
PSP_Years baseyearlistYears = (PSP_Years)Common.Services.BaseService.GetObject("SelectPSP_YearsByYearFlag", ha);
if (baseyearlistYears != null)
{
baseyear = baseyearlistYears.Year.ToString();
}
}
return(baseyear);
}
private void LoadData1(int id)
{
if (dataTable != null)
{
dataTable.Columns.Clear();
treeList1.Columns.Clear();
}
switch (id)
{
case 999999:
typeFlag2 = 1;
break;
case 888888:
typeFlag2 = 2;
break;
}
PSP_Types psp_Type = new PSP_Types();
psp_Type.Flag2 = typeFlag2;
psp_Type.ProjectID = Itop.Client.MIS.ProgUID;
IList listTypes = Common.Services.BaseService.GetList("SelectPSP_TypesByFlag2AndProjectID", psp_Type);
dataTable = Itop.Common.DataConverter.ToDataTable(listTypes, typeof(PSP_Types));
treeList1.DataSource = dataTable;
treeList1.Columns["Title"].Caption = "分类名";
treeList1.Columns["Title"].Width = 180;
treeList1.Columns["Title"].OptionsColumn.AllowEdit = false;
treeList1.Columns["Title"].OptionsColumn.AllowSort = false;
treeList1.Columns["ProjectID"].VisibleIndex = -1;
treeList1.Columns["ProjectID"].OptionsColumn.ShowInCustomizationForm = false;
treeList1.Columns["Flag"].VisibleIndex = -1;
treeList1.Columns["Flag"].OptionsColumn.ShowInCustomizationForm = false;
treeList1.Columns["Flag2"].VisibleIndex = -1;
treeList1.Columns["Flag2"].OptionsColumn.ShowInCustomizationForm = false;
PSP_Years psp_Year = new PSP_Years();
psp_Year.Flag = typeFlag2;
IList <PSP_Years> listYears = Common.Services.BaseService.GetList <PSP_Years>("SelectPSP_YearsListByFlag", psp_Year);
Hashtable htt = new Hashtable();
foreach (PSP_Years item in listYears)
{
if (!htt.ContainsValue(item.Year))
{
htt.Add(Guid.NewGuid().ToString(), item.Year);
}
AddColumn1(item.Year);
}
Application.DoEvents();
LoadValues1(htt);
treeList1.ExpandAll();
}
private void simpleButton2_Click(object sender, EventArgs e)
{
if (spinEdit1.Text == "")
{
Itop.Common.MsgBox.Show("请选择指定的年份！");
return;
}
PSP_Years psp_Year = new PSP_Years();
psp_Year.Flag = typeFlag2;
Hashtable ha = new Hashtable();
ha.Add("Flag", typeFlag2);
ha.Add("Year", Convert.ToInt32(spinEdit1.Text));
PSP_Years listYears = (PSP_Years)Common.Services.BaseService.GetObject("SelectPSP_YearsByYearFlag", ha);
if (listYears == null)
{
MsgBox.Show("年份数据中不存在此记录，请添加后再操作！");
return;
}
else
{
_baseyear = spinEdit1.Text;
DialogResult = DialogResult.OK;
}
}
private void LoadData()
{
string baseyear = "";
if (dataTable != null)
{
dataTable.Columns.Clear();
treeList1.Columns.Clear();
}
PSP_Types psp_Type = new PSP_Types();
psp_Type.Flag2 = typeFlag2;
IList listTypes = Common.Services.BaseService.GetList("SelectPSP_TypesByFlag2", psp_Type);
dataTable = Itop.Common.DataConverter.ToDataTable(listTypes, typeof(PSP_Types));
treeList1.DataSource = dataTable;
treeList1.Columns["Title"].Caption = "分类名";
treeList1.Columns["Title"].Width = 180;
treeList1.Columns["Title"].OptionsColumn.AllowEdit = false;
treeList1.Columns["Title"].OptionsColumn.AllowSort = false;
treeList1.Columns["Flag"].VisibleIndex = -1;
treeList1.Columns["Flag"].OptionsColumn.ShowInCustomizationForm = false;
treeList1.Columns["Flag2"].VisibleIndex = -1;
treeList1.Columns["Flag2"].OptionsColumn.ShowInCustomizationForm = false;
baseyear = EnsureBaseYear(baseyear);
PSP_Years psp_Year = new PSP_Years();
IList <PSP_Years> listYears;
if (baseyear != "")
{
psp_Year.Flag = typeFlag2;
psp_Year.Year = Convert.ToInt32(baseyear);
listYears = Common.Services.BaseService.GetList <PSP_Years>("SelectPSP_YearsListByFlagAndYear", psp_Year);
}
else
{
psp_Year.Flag = typeFlag2;
listYears = Common.Services.BaseService.GetList <PSP_Years>("SelectPSP_YearsListByFlag", psp_Year);
}
foreach (PSP_Years item in listYears)
{
AddColumn(item.Year);
}
Application.DoEvents();
LoadValues(true);
treeList1.ExpandAll();
if (baseyear != "")
{
treeList1.Columns[3].AppearanceCell.BackColor = Color.GreenYellow;
this.Cursor = Cursors.Default;
}
}
private void LoadData()
{
if (dataTable != null)
{
dataTable.Columns.Clear();
treeList1.Columns.Clear();
}
PSP_Types psp_Type = new PSP_Types();
psp_Type.Flag2 = typeFlag2;
psp_Type.ProjectID = ProjectUID;
IList listTypes = Common.Services.BaseService.GetList("SelectPSP_TypesByFlag2AndProjectID", psp_Type);
dataTable = Itop.Common.DataConverter.ToDataTable(listTypes, typeof(PSP_Types));
treeList1.DataSource = dataTable;
treeList1.Columns["Title"].Caption = "分类名";
treeList1.Columns["Title"].Width = 180;
treeList1.Columns["Title"].OptionsColumn.AllowEdit = false;
treeList1.Columns["Title"].OptionsColumn.AllowSort = false;
treeList1.Columns["Flag"].VisibleIndex = -1;
treeList1.Columns["Flag"].OptionsColumn.ShowInCustomizationForm = false;
treeList1.Columns["Flag2"].VisibleIndex = -1;
treeList1.Columns["Flag2"].OptionsColumn.ShowInCustomizationForm = false;
treeList1.Columns["ProjectID"].VisibleIndex = -1;
treeList1.Columns["ProjectID"].OptionsColumn.ShowInCustomizationForm = false;
//treeList1.Columns["ParentID"].VisibleIndex = -1;
//treeList1.Columns["ParentID"].OptionsColumn.ShowInCustomizationForm = false;
PSP_Years psp_Year = new PSP_Years();
psp_Year.Flag = typeFlag2;
IList <PSP_Years> listYears = Common.Services.BaseService.GetList <PSP_Years>("SelectPSP_YearsListByFlag", psp_Year);
foreach (PSP_Years item in listYears)
{
AddColumn(item.Year);
}
Application.DoEvents();
LoadValues();
//foreach (PSP_Years item in listYears)
//{
// ComputeXianSun(item.Year);
// // ComputeXianSun1(item.Year,treeList1.Nodes[0],treeList1.Nodes[1],treeList1.Nodes[2]);
//}
treeList1.ExpandAll();
}
private string EnsureBaseYear(string baseyear)
{
PSP_BaseYearRate BaseYearrate = (PSP_BaseYearRate)Common.Services.BaseService.GetObject("SelectPSP_BaseYearRateByKey", baseyearFlag);
if (BaseYearrate.BaseYear != "0")
{
Hashtable ha = new Hashtable();
ha.Add("Flag", typeFlag2);
ha.Add("Year", Convert.ToInt32(BaseYearrate.BaseYear));
PSP_Years baseyearlistYears = (PSP_Years)Common.Services.BaseService.GetObject("SelectPSP_YearsByYearFlag", ha);
if (baseyearlistYears != null)
{
baseyear = baseyearlistYears.Year.ToString();
}
}
return(baseyear);
}
/// <summary>
/// 初始化存放年份的数组
/// </summary>
private void InitArray(int year)
{
int index = 0;
sc.py = new PSP_Years[year];
PSP_Years listI = null;
for (int i = 0; i < (listYear.Count); ++i)
{
listI = (PSP_Years)listYear[i];
if (listI.Year < 2001 || listI.Year > 2004)
{
sc.py[index] = listI;
index++;
}
}
}
private void SetRateYearValue(TreeListNode node, double sum)
{
string baseyear = "";
baseyear = EnsureBaseYear(baseyear);
if (baseyear != "")
{
double rate = 0;
double sumtemp = sum;
int yeartemp = 0;
PSP_Years psp_Year = new PSP_Years();
psp_Year.Flag = typeFlag2;
psp_Year.Year = Convert.ToInt32(baseyear);
IList <PSP_Years> listYears = Common.Services.BaseService.GetList <PSP_Years>("SelectPSP_YearsListByFlagAndYear", psp_Year);
yeartemp = Convert.ToInt32(baseyear);
foreach (PSP_Years yearvalue in listYears)
{
if (yearvalue.Year == Convert.ToInt32(baseyear))
{
continue;
}
try
{
PSP_BaseYearRate yearvaluetemp = new PSP_BaseYearRate();
yearvaluetemp.BaseYear = yearvalue.Year.ToString();
yearvaluetemp.TypeID = Convert.ToInt32(node.GetValue("ID"));
IList <PSP_BaseYearRate> list1 = Common.Services.BaseService.GetList <PSP_BaseYearRate>("SelectPSP_BaseYearRateByYear", yearvaluetemp);
if (list1.Count == 1)
{
rate = Convert.ToDouble(list1[0].YearRate);
}
sumtemp = sumtemp * Math.Pow(1 + rate, yearvalue.Year - yeartemp);
node.SetValue(yearvalue.Year + "年", Math.Round(sumtemp, 2));
yeartemp = yearvalue.Year;
SaveCellValue((int)yearvalue.Year, (int)node.GetValue("ID"), Convert.ToDouble(sumtemp));
}
catch { }
}
}
}
public void AddYear()
{
PSP_Years psp_Year = new PSP_Years();
psp_Year.Flag = int.Parse(flag2);
psp_Year.Year = yearValue;
if (_getYearOnly)
{
this.DialogResult = DialogResult.OK;
return;
}
if (al.Contains(yearValue + "年") == true)
{
MsgBox.Show("已经存在此年份，要想添加，请先删除已存在的" + yearValue + "年!");
return;
}
try
{
if (Common.Services.BaseService.GetObject("SelectPSP_YearsByYearFlag", psp_Year) == null)
{
try
{
Common.Services.BaseService.Create <PSP_Years>(psp_Year);
this.DialogResult = DialogResult.OK;
}
catch (Exception ex)
{
MsgBox.Show("出错啦：" + ex.Message);
}
}
else
{
MsgBox.Show("此年份已经存在，请重新输入！");
}
}
catch (Exception ex)
{
MsgBox.Show("出错啦：" + ex.Message);
}
}
private void simpleButton1_Click(object sender, EventArgs e)
{
PSP_Years psp_Year = new PSP_Years();
psp_Year.Flag = int.Parse(flag2);
yearValue = psp_Year.Year = (int)spinEdit1.Value;
if (_getYearOnly)
{
this.DialogResult = DialogResult.OK;
return;
}
if (al.Contains(yearValue + "年") == true)
{
MsgBox.Show("已经存在此年份，要想添加，请先删除已存在的" + yearValue + "年!");
return;
}
try
{
if (Common.Services.BaseService.GetObject("SelectPSP_YearsByYearFlag", psp_Year) == null)
{
try
{
Common.Services.BaseService.Create <PSP_Years>(psp_Year);
this.DialogResult = DialogResult.OK;
}
catch (Exception ex)
{
MsgBox.Show("出错啦：" + ex.Message);
}
}
else
{
MsgBox.Show("此年份已经存在，请重新输入！");
}
}
catch (Exception ex)
{
MsgBox.Show("出错啦：" + ex.Message);
}
}
private void InitYears(PSP_Years pv, PSP_P_Years pv1)
{
pv1.ID = pv.ID;
pv1.Flag = typeFlag2;
pv1.Year = pv.Year;
}
private void barButtonItem1_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
PSP_ForecastReports ct = (PSP_ForecastReports)this.ctrlPSP_ForecastReports1.GridView.GetRow(this.ctrlPSP_ForecastReports1.GridView.FocusedRowHandle);
if (ct == null)
{
return;
}
typeFlag2 = ct.ID;
Form1_Fs ffs = new Form1_Fs();
ffs.Type = type;
if (ffs.ShowDialog() != DialogResult.OK)
{
return;
}
int fl2 = ffs.FL2;
bool bl = ffs.IsJingJi;
Hashtable hs = ffs.HS;
if (hs.Count == 0)
{
return;
}
if (bl)
{
fl2 = 1;
PSP_Years py = new PSP_Years();
py.Flag = fl2;
IList <PSP_Years> listyear = Services.BaseService.GetList <PSP_Years>("SelectPSP_YearsListByFlag", py);
Hashtable hsa = new Hashtable();
foreach (DictionaryEntry de3 in hs)
{
PSP_Types pt = (PSP_Types)de3.Value;
PSP_P_Types ppta = new PSP_P_Types();
ppta.ID = pt.ID;
ppta.Flag2 = typeFlag2;
IList <PSP_P_Types> listppt = Services.BaseService.GetList <PSP_P_Types>("SelectPSP_P_TypesByFlag2ID", ppta);
if (listppt.Count > 0)
{
continue;
}
PSP_P_Types ppt = new PSP_P_Types();
InitTypes(pt, ppt);
Services.BaseService.Create <PSP_P_Types>(ppt);
hsa.Add(Guid.NewGuid().ToString(), "");
PSP_Values pv = new PSP_Values();
pv.TypeID = pt.ID;
IList <PSP_Values> listppt1 = Services.BaseService.GetList <PSP_Values>("SelectPSP_ValuesList", pv);
Hashtable httss = new Hashtable();
foreach (PSP_Values pv1 in listppt1)
{
PSP_P_Values ppv = new PSP_P_Values();
InitValues(pv1, ppv);
try
{
Services.BaseService.Create <PSP_P_Values>(ppv);
}
catch { }
}
}
if (hsa.Count > 0)
{
foreach (PSP_Years py1 in listyear)
{
PSP_P_Years ppy = new PSP_P_Years();
InitYears(py1, ppy);
try
{
Services.BaseService.Create <PSP_P_Years>(ppy);
}
catch { }
}
}
}
else
{
PSP_P_Years py = new PSP_P_Years();
py.Flag = fl2;
IList <PSP_P_Years> listyear = Services.BaseService.GetList <PSP_P_Years>("SelectPSP_P_YearsListByFlag", py);
Hashtable hsa = new Hashtable();
foreach (DictionaryEntry de3 in hs)
{
PSP_P_Types pt = (PSP_P_Types)de3.Value;
pt.Flag2 = typeFlag2;
IList <PSP_P_Types> listppt = Services.BaseService.GetList <PSP_P_Types>("SelectPSP_P_TypesByFlag2ID", pt);
if (listppt.Count > 0)
{
continue;
}
Services.BaseService.Create <PSP_P_Types>(pt);
hsa.Add(Guid.NewGuid().ToString(), "");
PSP_P_Values pv = new PSP_P_Values();
pv.TypeID = pt.ID;
IList <PSP_P_Values> listppt1 = Services.BaseService.GetList <PSP_P_Values>("SelectPSP_P_ValuesList", pv);
foreach (PSP_P_Values pv1 in listppt1)
{
try
{
pv1.Flag2 = typeFlag2;
Services.BaseService.Create <PSP_P_Values>(pv1);
}
catch { }
}
}
if (hsa.Count > 0)
{
foreach (PSP_P_Years py1 in listyear)
{
try
{
py1.Flag = typeFlag2;
Services.BaseService.Create <PSP_P_Years>(py1);
}
catch { }
}
}
}
Application.DoEvents();
this.Cursor = Cursors.WaitCursor;
treeList1.BeginUpdate();
LoadData();
treeList1.EndUpdate();
this.Cursor = Cursors.Default;
}
private void Form7_BaseYearRate_Load(object sender, EventArgs e)
{
if (dt1 != null)
{
dt1.Columns.Clear();
treeList1.Columns.Clear();
}
//this.gridColumn2.ColumnEdit = this.repositoryItemTextEdit1;
PSP_Types psp_Type = new PSP_Types();
psp_Type.Flag2 = typeFlag2;
IList listTypes = Common.Services.BaseService.GetList("SelectPSP_TypesByFlag2", psp_Type);
dt1 = Itop.Common.DataConverter.ToDataTable(listTypes, typeof(PSP_Types));
treeList1.DataSource = dt1;
treeList1.Columns["Title"].Caption = "分类名";
treeList1.Columns["Title"].Width = 180;
treeList1.Columns["Title"].OptionsColumn.AllowEdit = false;
treeList1.Columns["Title"].OptionsColumn.AllowSort = false;
treeList1.Columns["Flag"].VisibleIndex = -1;
treeList1.Columns["Flag"].OptionsColumn.ShowInCustomizationForm = false;
treeList1.Columns["Flag2"].VisibleIndex = -1;
treeList1.Columns["Flag2"].OptionsColumn.ShowInCustomizationForm = false;
string baseyear = "";
baseyear = EnsureBaseYear(baseyear);
PSP_Years psp_Year = new PSP_Years();
IList <PSP_Years> listYears;
if (baseyear != "")
{
psp_Year.Flag = typeFlag2;
psp_Year.Year = Convert.ToInt32(baseyear);
listYears = Common.Services.BaseService.GetList <PSP_Years>("SelectPSP_YearsListByFlagAndYear", psp_Year);
}
else
{
MsgBox.Show("没有添加基准年，请添加后再操作！");
return;
}
if (listYears.Count > 1)
{
endyear = listYears[listYears.Count - 1].Year;
}
else
{
MsgBox.Show("没有添加预测年，请添加后再操作！");
this.DialogResult = DialogResult.OK;
return;
}
foreach (PSP_Years item in listYears)
{
if (item.Year.ToString() == baseyear)
{
continue;
}
AddColumn(item.Year);
PSP_BaseYearRate psp_Yeartemp = new PSP_BaseYearRate();
foreach (PSP_Types psp_Typetemp in listTypes)
{
psp_Yeartemp.BaseYear = item.Year.ToString();
psp_Yeartemp.TypeID = psp_Typetemp.ID;
try
{
IList <PSP_BaseYearRate> list1 = Common.Services.BaseService.GetList <PSP_BaseYearRate>("SelectPSP_BaseYearRateByYear", psp_Yeartemp);
if (list1.Count == 1)
{
TreeListNode node = treeList1.FindNodeByFieldValue("ID", Convert.ToInt32(list1[0].TypeID));
if (node != null)
{
if (list1[0].YearRate != "")
{
node.SetValue(list1[0].BaseYear + "年", Convert.ToDouble(list1[0].YearRate));
}
else
{
node.SetValue(psp_Yeartemp.BaseYear + "年", "0");
}
}
}
else if (list1.Count == 0)
{
try
{
psp_Yeartemp.UID = Guid.NewGuid().ToString();
psp_Yeartemp.YearRate = "0";
Common.Services.BaseService.Create <PSP_BaseYearRate>(psp_Yeartemp);
TreeListNode node = treeList1.FindNodeByFieldValue("ID", psp_Yeartemp.TypeID);
if (node != null)
{
node.SetValue(psp_Yeartemp.BaseYear + "年", "0");
}
}
catch (Exception ex)
{
// MsgBox.Show("出错啦：" + ex.Message);
}
}
}
catch (Exception ex)
{
// MsgBox.Show(ex.ToString());
}
}
}
treeList1.ExpandAll();
}
/// <summary>
/// 加载10_1表头
/// </summary>
/// <param name="obj"></param>
/// <param name="Title"></param>
public void SetSheet4_1_1Title(Itop.Client.Base.FormBase FB, FarPoint.Win.Spread.SheetView obj, string Title)
{
PSP_Years[] listI = new PSP_Years[2];
InitTitle();
this.SelectYear(); //查询年份
SelectDQ(FB, sc.strTitle[0]); //查询地区
SelectDQ(FB, sc.strTitle[1]);
listI[0] = (PSP_Years)listYear[0];
listI[1] = (PSP_Years)listYear[listYear.Count - 1];
yearCount = listYear.Count - 4 + 2; //年份=程序中现实的年份-4年（2001年到2004年）+2是有两行固定标题
int IntColCount = 18;
int IntRowCount = (City.Count + County.Count) * (yearCount) + 4 + 3; //标题占3行，类型占4行，(yearCount+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 += 2, IntCol, strTitle);
PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle);
strTitle = " 分 区 ";
PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow -= 2, IntCol += 1, strTitle);
PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle);
strTitle = " 名 称";
PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow += 2, IntCol, strTitle);
PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle);
strTitle = " 年 份";
PF.CreateSheetView(obj, NextRowMerge += 2, NextColMerge, IntRow -= 2, IntCol += 1, strTitle);
PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle);
strTitle = "全 社 会 ";
PF.CreateSheetView(obj, NextRowMerge -= 3, NextColMerge += 1, IntRow, IntCol += 1, 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 -= 1, IntRow += 1, IntCol, strTitle);
PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle);
strTitle = " (MW) ";
PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow += 1, IntCol, strTitle);
//PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle);
strTitle = " 增长率 ";
PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow -= 1, IntCol += 1, strTitle);
PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle);
strTitle = "(%)";
PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow += 1, IntCol, strTitle);
//PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle);
for (int i = 0; i < 3; ++i)
{
if (i == 0)
{
strTitle = " 网供最大负荷";
}
if (i == 1)
{
strTitle = " 供电量";
}
if (i == 2)
{
strTitle = " 全社会用电量";
}
PF.CreateSheetView(obj, NextRowMerge += 1, NextColMerge += 1, IntRow -= 3, IntCol += 1, strTitle);
PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle);
strTitle = " 规 模 ";
PF.CreateSheetView(obj, NextRowMerge -= 1, NextColMerge -= 1, IntRow += 2, IntCol, strTitle);
PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle);
strTitle = " (MW) ";
PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow += 1, IntCol, strTitle);
//PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle);
strTitle = " 增长率 ";
PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow -= 1, IntCol += 1, 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 += 3, IntRow -= 3, IntCol += 1, strTitle);
PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle);
strTitle = "(亿kWh) ";
PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow += 1, IntCol, strTitle);
PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle);
strTitle = "一 产";
PF.CreateSheetView(obj, NextRowMerge += 1, NextColMerge -= 3, IntRow += 1, IntCol, 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 -= 2, IntCol += 1, strTitle);
PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle);
strTitle = "(kWh/人)";
PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow += 2, IntCol, strTitle);
//PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle);
strTitle = "人均生活用电量";
PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow -= 2, IntCol += 1, strTitle);
PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle);
strTitle = "(kWh/人)";
PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow += 2, IntCol, strTitle);
//PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle);
strTitle = "农村居民人均生活用电量";
PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow -= 2, IntCol += 1, strTitle);
PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle);
strTitle = "(kWh/人)";
PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow += 2, IntCol, strTitle);
//PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle);
NextRowMerge = 1;
NextColMerge = 1;
IntRow = 7;
IntCol = 1;
//if (listI[0].Year > 2000 || listI[1].Year < 2009)
//{
// MessageBox.Show("“在分区县供电实绩中”选择年份必须小于等于2000年和大于等于2009年！！！");
// return;
//}
//else
//{
InitArray(yearCount - 2);
SetLeftTitle(obj, IntRow, IntCol, listI[1].Year); //左侧标题
WriteData(obj, IntRow, IntCol, listI[1].Year); //数据
//}
PF.SetWholeRowHeight(obj, obj.Rows.Count, obj.Columns.Count); //行高
}
public void SetSheet4_1Title(Itop.Client.Base.FormBase FB, FarPoint.Win.Spread.SheetView obj, string Title)
{
strTitle1[0] = "市辖供电区";
strTitle1[1] = "县级供电区";
projectId = FB.ProjectUID;
PSP_Years[] listI = new PSP_Years[2];
//SelectYear();//查询年份
//SelectDQ(FB, strTitle1[0]);//查询地区
//SelectDQ(FB, strTitle1[1]);
//listI[0] = (PSP_Years)listYear[0];
//listI[1] = (PSP_Years)listYear[listYear.Count - 1];
//yearCount = listYear.Count - 4 + 2;//年份=程序中现实的年份-4年（2001年到2004年）+2是有两行固定标题
yearCount = 9;
int IntColCount = 17;
int IntRowCount = 3 * yearCount + 2 + 3;//标题占3行，类型占2行，3个供电区总共占用的行数
obj.SheetName = Title;
//obj.ColumnCount = 20;
//obj.RowCount = 100;
obj.Columns.Count = IntColCount;
obj.Rows.Count = IntRowCount;
IntCol = obj.Columns.Count;
S10_1.ColReadOnly(obj, IntColCount);
PF.Sheet_GridandCenter(obj);
#region 合并单元格
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);
//PF.SetRowHight(obj,IntRow,IntCol,strTitle);
strTitle = " 年 份 ";
PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow, IntCol += 1, strTitle);
PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle);
//PF.SetRowHight(obj, IntRow, IntCol, strTitle);
strTitle = "全社会最大用电负荷";
PF.CreateSheetView(obj, NextRowMerge -= 1, NextColMerge += 1, IntRow, IntCol += 1, strTitle);
//PF.SetRowHight(obj, IntRow, IntCol, strTitle);
strTitle = "规模（MW）";
PF.CreateSheetView(obj, NextRowMerge, NextColMerge -= 1, IntRow += 1, IntCol, strTitle);
PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle);
//PF.SetRowHight(obj, IntRow, IntCol, strTitle);
strTitle = "增长率（%）";
PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow, IntCol += 1, strTitle);
PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle);
//PF.SetRowHight(obj, IntRow, IntCol, strTitle);
strTitle = "网供最大负荷";
PF.CreateSheetView(obj, NextRowMerge, NextColMerge += 1, IntRow -= 1, IntCol += 1, strTitle);
//PF.SetRowHight(obj, IntRow, IntCol, strTitle);
strTitle = "规模（MW）";
PF.CreateSheetView(obj, NextRowMerge, NextColMerge -= 1, IntRow += 1, IntCol, strTitle);
PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle);
//PF.SetRowHight(obj, IntRow, IntCol, strTitle);
strTitle = "增长率（%）";
PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow, IntCol += 1, strTitle);
PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle);
//PF.SetRowHight(obj, IntRow, IntCol, strTitle);
strTitle = "供电量";
PF.CreateSheetView(obj, NextRowMerge, NextColMerge += 1, IntRow -= 1, IntCol += 1, strTitle);
strTitle = "规模（亿kWh）";
PF.CreateSheetView(obj, NextRowMerge, NextColMerge -= 1, IntRow += 1, IntCol, 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 += 1, IntRow -= 1, IntCol += 1, strTitle);
strTitle = "规模（亿kWh）";
PF.CreateSheetView(obj, NextRowMerge, NextColMerge -= 1, IntRow += 1, IntCol, strTitle);
PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle);
strTitle = "增长率（%）";
PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow, IntCol += 1, strTitle);
PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle);
//PF.SetRowHight(obj, IntRow, IntCol, strTitle);
strTitle = "三产及居民用电量（亿kWh）";
PF.CreateSheetView(obj, NextRowMerge, NextColMerge = 4, IntRow -= 1, IntCol += 1, strTitle);
PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle);
//PF.SetRowHight(obj, IntRow, IntCol, strTitle);
strTitle = " 一 产 ";
PF.CreateSheetView(obj, NextRowMerge, NextColMerge -= 4, IntRow += 1, IntCol, 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 = "人均用电量（kWh/人）";
PF.CreateSheetView(obj, NextRowMerge += 1, NextColMerge, IntRow -= 1, IntCol += 1, strTitle);
PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle);
//PF.SetRowHight(obj, IntRow, IntCol, strTitle);
strTitle = "人均生活用电量（kWh/人）";
PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow, IntCol += 1, strTitle);
PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle);
//PF.SetRowHight(obj, IntRow, IntCol, strTitle);
strTitle = "农村居民人均生活用电量（kWh/人）";
PF.CreateSheetView(obj, NextRowMerge, NextColMerge, IntRow, IntCol += 1, strTitle);
PF.SetSheetViewColumnsWidth(obj, IntCol, strTitle);
//PF.SetRowHight(obj, IntRow, IntCol, strTitle);
NextRowMerge = 1;
NextColMerge = 1;
#endregion
IntRow = 5;
IntCol = 1;
//InitArray(yearCount - 2);
//SetLeftTitle(obj, IntRow, IntCol, listI[1].Year);//左侧标题
SetLeftTitleNew(obj, IntRow, IntCol); //左侧标题
WriteData(obj, IntRow, IntCol); //数据
PF.SetWholeRowHeight(obj, obj.Rows.Count, obj.Columns.Count); //行高
}
