private void simpleButton1_Click(object sender, EventArgs e)
{
PSP_Years psp_Year = new PSP_Years();
psp_Year.Flag = flag2;
yearValue = psp_Year.Year = (int)spinEdit1.Value;
if(_getYearOnly)
{
this.DialogResult = DialogResult.OK;
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 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;
}
}
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 InitYears(PSP_Years pv, PSP_P_Years pv1)
{
pv1.ID = pv.ID;
pv1.Flag = typeFlag2;
pv1.Year = pv.Year;
}
private void LoadData()
{
try
{
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;
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();
treeList1.ExpandAll();
}
catch (Exception ex)
{
MsgBox.Show(ex.Message);
}
}
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;
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;
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 LoadHistoryValue()
{
PSP_Years psp_Year = new PSP_Years();
psp_Year.Flag = 1;
IList<PSP_Years> listYears = Common.Services.BaseService.GetList<PSP_Years>("SelectPSP_YearsListByFlag", psp_Year);
Hashtable ht = new Hashtable();
foreach (PSP_Years item in listYears)
{
dataTable.Columns.Add(item.Year + "Y", typeof(double));
TreeListColumn column = treeList1.Columns.Add();
column.FieldName = item.Year + "Y";
column.Tag = item.Year;
column.VisibleIndex = -1;
if (!ht.ContainsKey(item.Year + "Y"))
ht.Add(item.Year + "Y", "");
}
PSP_Values psp_Values = new PSP_Values();
foreach (DataRow dr in dataTable.Rows)
{
psp_Values.TypeID = (int)dr["ID"];
IList<PSP_Values> listValues = Common.Services.BaseService.GetList<PSP_Values>("SelectPSP_ValuesList", psp_Values);
foreach (PSP_Values value in listValues)
{
TreeListNode node = treeList1.FindNodeByFieldValue("ID", value.TypeID);
if (node != null)
{
if (!ht.ContainsKey(value.Year + "Y"))
{
dataTable.Columns.Add(value.Year + "Y", typeof(double));
TreeListColumn column = treeList1.Columns.Add();
column.FieldName = value.Year + "Y";
column.Tag = value.Year;
column.VisibleIndex = -1;
ht.Add(value.Year + "Y", "");
}
node.SetValue(value.Year + "Y", value.Value);
if (value.Year == forecastReport.StartYear)
{
node.SetValue(value.Year + "��", value.Value);
}
}
}
}
}
private void LoadData2()
{
//��ʾ�ɰ�����ع���ʵ�����������һ��
if (dataTable != null)
{
dataTable.Columns.Clear();
treeList1.Columns.Clear();
}
PSP_Types psp_Type = new PSP_Types();
psp_Type.Flag2 = 2;
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;
//treeList1.Columns["ParentID"].VisibleIndex = -1;
//treeList1.Columns["ParentID"].OptionsColumn.ShowInCustomizationForm = false;
PSP_Years psp_Year = new PSP_Years();
psp_Year.Flag = 2;
IList<PSP_Years> listYears = Common.Services.BaseService.GetList<PSP_Years>("SelectPSP_YearsListByFlag", psp_Year);
foreach (PSP_Years item in listYears)
{
AddColumn2(item.Year);
}
Application.DoEvents();
LoadValues();
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);//行高
}
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 { }
}
}
}
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(TreeListNode nd)
{
List<PSP_Types> Ilisttemp = new List<PSP_Types>();
if(dataTable != null)
{
dataTable.Columns.Clear();
treeList1.Columns.Clear();
}
PSP_Types psp_Type = new PSP_Types();
psp_Type.Flag2 = typeFlag2;
psp_Type.ID =Convert.ToInt32( nd["ID"]) ;
IList listTypes = Common.Services.BaseService.GetList("SelectPSP_TypesByParentID", psp_Type);
foreach (PSP_Types psp_Typetemp in listTypes)
Ilisttemp.Add(psp_Typetemp);
foreach (PSP_Types psp_Typetemp in listTypes)
{
psp_Type.Flag2 = typeFlag2;
psp_Type.ID = psp_Typetemp.ID;
IList<PSP_Types> listTypestemp = Common.Services.BaseService.GetList<PSP_Types>("SelectPSP_TypesByParentID", psp_Type);
foreach (PSP_Types psp_Typetemp2 in listTypestemp)
Ilisttemp.Add(psp_Typetemp2);
}
dataTable = Itop.Common.DataConverter.ToDataTable(Ilisttemp, typeof(PSP_Types));
treeList1.DataSource = dataTable;
treeList1.Columns["Title"].Caption = "分类名";
treeList1.Columns["Title"].Width = 250;
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;
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();
treeList1.ExpandAll();
}
//统计
private void barButtonItem6_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
FormChooseYears frm = new FormChooseYears();
foreach (TreeListColumn column in treeList1.Columns)
{
if (column.FieldName.IndexOf("年") > 0)
{
frm.ListYearsForChoose.Add((int)column.Tag);
}
}
frm.NoIncreaseRate = true;
DataTable dt = new DataTable();
PSP_Types psp_Type = new PSP_Types();
psp_Type.Flag2 = typeFlag2;
IList listTypes = Common.Services.BaseService.GetList("SelectPSP_TypesByFlag2", psp_Type);
dt = Itop.Common.DataConverter.ToDataTable(listTypes, typeof(PSP_Types));
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)
{
dt.Columns.Add(item.Year + "年", typeof(double));
}
PSP_Values psp_Values = new PSP_Values();
psp_Values.ID = typeFlag2;//用ID字段存放Flag2的值
IList<PSP_Values> listValues = Common.Services.BaseService.GetList<PSP_Values>("SelectPSP_ValuesListByFlag2", psp_Values);
foreach (PSP_Values psptemp in listValues)
{
foreach (DataRow dttemp in dt.Rows)
{
if (Convert.ToInt32(dttemp["ID"].ToString()) == psptemp.TypeID)
dttemp[psptemp.Year + "年"] = psptemp.Value;
}
}
if(frm.ShowDialog() == DialogResult.OK)
{
FrmBalanceOfPowerRegionPrint frma = new FrmBalanceOfPowerRegionPrint();
frma.IsSelect = _isSelect;
frma.HASH = hash;
frma.HASH2 = hash2;
frma.Text = "南北区电力平衡表";
frma.GridDataTable = ResultDataTable(dt, frm.ListChoosedYears);
frma.ISPrint = PrintRight;
if (frma.ShowDialog() == DialogResult.OK && _isSelect)
{
DialogResult = DialogResult.OK;
}
}
}
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 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();
}
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);//行高
}
