public static void CheckHasFixValue(Hashtable ht, DataTable dt, string ForecastID, int type)
{
foreach (string key in ht.Keys)
{
bool have = false;
foreach (DataRow row in dt.Rows)
{
if (key==row["Title"].ToString())
{
have = true;
break;
}
}
if (!have)
{
try
{
Ps_Forecast_Math pfm = new Ps_Forecast_Math();
pfm.ID = Guid.NewGuid().ToString();
pfm.Title = key;
pfm.Forecast = type;
pfm.ForecastID = ForecastID;
object obj = Common.Services.BaseService.GetObject("SelectPs_Forecast_MathMaxID", null);
if (obj != null)
pfm.Sort = ((int)obj) + 1;
else
pfm.Sort = 1;
Common.Services.BaseService.Create<Ps_Forecast_Math>(pfm);
}
catch (Exception)
{
}
}
}
}
private void LoadData()
{
treeList1.DataSource = null;
bLoadingData = true;
if (dataTable != null)
{
dataTable.Columns.Clear();
this.treeList1.Columns.Clear();
//treeList1.Columns.Clear();
}
//((System.ComponentModel.ISupportInitialize)(this.treeList1)).BeginInit();
AddFixColumn();
for (int i = forecastReport.StartYear; i <= forecastReport.YcEndYear; i++)
{
AddColumn(i);
}
//((System.ComponentModel.ISupportInitialize)(this.treeList1)).EndInit();
Ps_Forecast_Math psp_Type = new Ps_Forecast_Math();
psp_Type.ForecastID = forecastReport.ID;
psp_Type.Forecast = type;
IList listTypes = Common.Services.BaseService.GetList("SelectPs_Forecast_MathByForecastIDAndForecast", psp_Type);
if (listTypes.Count != 3 || ((Ps_Forecast_Math)listTypes[0]).Col1 != "mh")
{
try
{ //删除数据
for (int i = 0; i < listTypes.Count; i++)
{
Common.Services.BaseService.Delete<Ps_Forecast_Math>((Ps_Forecast_Math)listTypes[i]);
}
}
catch
{
}
List<Ps_Forecast_Math> newlist = new List<Ps_Forecast_Math>() ;
Ps_Forecast_Math psp_Type1 = new Ps_Forecast_Math();
psp_Type1.ID = Guid.NewGuid().ToString();
psp_Type1.ForecastID = forecastReport.ID;
psp_Type1.Forecast = type;
psp_Type1.Title = "全社会用电量（亿kWh）";
psp_Type1.Sort = 1;
psp_Type1.Col1 = "mh";
Common.Services.BaseService.Create<Ps_Forecast_Math>(psp_Type1);
newlist.Add(psp_Type1);
Ps_Forecast_Math psp_Type2 = new Ps_Forecast_Math();
psp_Type2.ID = Guid.NewGuid().ToString();
psp_Type2.ForecastID = forecastReport.ID;
psp_Type2.Forecast = type;
psp_Type2.Title = "全社会最大负荷（MW）";
psp_Type2.Sort = 2;
psp_Type2.Col1 = "mh";
Common.Services.BaseService.Create<Ps_Forecast_Math>(psp_Type2);
newlist.Add(psp_Type2);
Ps_Forecast_Math psp_Type3 = new Ps_Forecast_Math();
psp_Type3.ID = Guid.NewGuid().ToString();
psp_Type3.ForecastID = forecastReport.ID;
psp_Type3.Forecast = type;
psp_Type3.Title = "最大小时数(时)";
psp_Type3.Sort = 3;
psp_Type3.Col1 = "mh";
Common.Services.BaseService.Create<Ps_Forecast_Math>(psp_Type3);
newlist.Add(psp_Type3);
dataTable = Itop.Common.DataConverter.ToDataTable(newlist);
}
else
{
dataTable = Itop.Common.DataConverter.ToDataTable(listTypes, typeof(Ps_Forecast_Math));
for (int i = 0; i < listTypes.Count; i++)
{
Ps_Forecast_Math currtenpfm = (Ps_Forecast_Math)listTypes[i];
//更新换算单位
if (currtenpfm.Sort == 1)
{
CheckUnit(currtenpfm.Title.ToString());
}
break;
}
}
this.treeList1.DataSource = dataTable;
Application.DoEvents();
bLoadingData = false;
RefreshChart();
}
/// <summary>
/// ����Ƚ�
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void barButtonItem29_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
//dataTable
ArrayList a1 = new ArrayList();
ArrayList a2 = new ArrayList();
ArrayList a3 = new ArrayList();
ArrayList a4 = new ArrayList();
DataTable dt3 = new DataTable();
dt3.Columns.Add("A", typeof(int));
dt3.Columns.Add("B",typeof(bool));
dt3.Columns.Add("C", typeof(bool));
for (int i = forecastReport.StartYear; i <= forecastReport.EndYear; i++)
{
DataRow dr = dt3.NewRow();
dr["A"] = i;
//dr["B"] = true;
//dr["C"] = false;
dt3.Rows.Add(dr);
}
FormXuanZhe form = new FormXuanZhe();
//form.Text = this.Text + "- ����Ƚ�����";
form.DT2 = dataTable;
form.DT3 = dt3;
form.ReportForecastID = forecastReport.ID;
form.ForecastReport = forecastReport;
if (form.ShowDialog() != DialogResult.OK)
return;
a1 = form.A1;
a2 = form.A2;
a3 = form.A3;
a4 = form.A4;
DataTable dt = new DataTable();
foreach (DataColumn dc in dataTable.Columns)
{
dt.Columns.Add(dc.ColumnName, dc.DataType);
}
IList<Ps_Forecast_Math> li = new List<Ps_Forecast_Math>();
ArrayList al = new ArrayList();
foreach (DataRow dr in dataTable.Rows)
{
if (!(bool)dr["B"])
continue;
string id = dr["ID"].ToString();
Ps_Forecast_Math pfvalue = new Ps_Forecast_Math();//ƽ��ֵ
pfvalue.Title = dr["Title"].ToString() + "<ƽ��ֵ>";
pfvalue.Title = pfvalue.Title.Replace("�����õ���-", "");
pfvalue.ID = "999|" + Itop.Client.MIS.ProgUID;
pfvalue.ForecastID = forecastReport.ID;
pfvalue.Forecast = Convert.ToInt32(dr["Forecast"]);
int icount = 0;
for (int i = 0; i < a1.Count; i++)
{
int m = Convert.ToInt32(a1[i]);
Ps_Forecast_Math pf2 = Services.BaseService.GetOneByKey<Ps_Forecast_Math>(id);
Ps_Forecast_Math pf1 = new Ps_Forecast_Math();
Ps_Forecast_Math pf = new Ps_Forecast_Math();
//pf.Col4 = pid;
pf.Col1 = id;
pf.ForecastID = forecastReport.ID;
pf.Forecast = m;
IList<Ps_Forecast_Math> li2 = Services.BaseService.GetList<Ps_Forecast_Math>("SelectPs_Forecast_MathByCol1", pf);
if (li2.Count == 0)
{
pf1 = pf2;
pf1.Forecast = m;
pf1.ID = Guid.NewGuid().ToString();
}
else
{
pf1 = li2[0];
}
string str = "";
switch (m)
{
case 1:
str = "�������ʷ�";
break;
case 2:
str = "���Ʒ�";
break;
case 3:
str = "��ط�";
break;
case 4:
str = "����ϵ����";
break;
case 5:
str = "ָ��ƽ����";
break;
case 6:
str = "��ɫģ�ͷ�";
break;
case 7:
str = "ר�Ҿ��߷�";
break;
case 20:
str = "�����㷨";
break;
case 10:
str = "��Ȩ���ϵ����";
break;
case 11:
str = "����������-���û�Ԥ�ⷨ";
break;
}
//if (m != 11)
//{
// if ( pf1.Title.Contains("-") && pf1.Title.Contains("����"))
// {
// continue;
// }
pf1.Title = pf1.Title + "<" + str + ">";
for (int j = forecastReport.StartYear; j <= forecastReport.EndYear; j++)
{
double value2 = Math.Round(Convert.ToDouble(pfvalue.GetType().GetProperty("y" + j.ToString()).GetValue(pfvalue, null)), 2);
double value = Math.Round(Convert.ToDouble(pf1.GetType().GetProperty("y" + j.ToString()).GetValue(pf1, null)), 2);
value = Math.Round((value + value2), 2);
pfvalue.GetType().GetProperty("y" + j.ToString()).SetValue(pfvalue, value, null);
}
pf1.Sort = li.Count;
icount++;
al.Add(pf1.Title);
li.Add(pf1);
}
//else
//{
// if (pf1.Title.Contains("-")||true)
// {
// IList<Ps_forecast_list> listReports = Common.Services.BaseService.GetList<Ps_forecast_list>("SelectPs_forecast_listByWhere", "UserID='" + Itop.Client.MIS.ProgUID + "' and Col1='2' and Title='" + forecastReport.Title + "'");
// if (listReports.Count > 0)
// {
// pf1.Title = dr["Title"].ToString();
// string[] strtemp = new string [2];
// if (pf1.Title.Contains("����"))
// {
// strtemp[0] = "����";
// strtemp[1] = pf1.Title;
// if(pf1.Title.Substring(pf1.Title.Length-2,2)=="����")
// strtemp[1] = pf1.Title.Substring(0, pf1.Title.Length - 2);
// }
// else if (pf1.Title.Contains("����"))
// {
// strtemp[0] = "����";
// strtemp[1] = pf1.Title;
// if (pf1.Title.Substring(pf1.Title.Length - 2, 2) == "����")
// strtemp[1] = pf1.Title.Substring(0, pf1.Title.Length - 2);
// }
// int typetemp = 0;
// if (strtemp[0].Contains("����"))
// typetemp = 2;
// else
// typetemp = 3;
// if (typetemp == 2)
// {
// str = "����";
// }
// else
// {
// str = "����";
// }
// //if (strtemp[1].Contains("ȫ���"))
// //{
// // IList<Ps_Forecast_Math> li3 = Common.Services.BaseService.GetList<Ps_Forecast_Math>("SelectPs_Forecast_MathByWhere",
// // "Forecast='" + typetemp + "' and ForecastID='" + listReports[0].ID + "' and Title like 'ȫ���%'");
// // foreach (Ps_Forecast_Math ps in li3)
// // {
// // ps.Title = ps.Title + str + "<����������-���û�Ԥ�ⷨ>";
// // if (al.Contains(ps.Title))
// // continue;
// // for (int j = forecastReport.StartYear; j <= forecastReport.EndYear; j++)
// // {
// // double value2 =Math.Round(Convert.ToDouble(pfvalue.GetType().GetProperty("y" + j.ToString()).GetValue(pfvalue, null)),2 );
// // double value = Math.Round(Convert.ToDouble(ps.GetType().GetProperty("y" + j.ToString()).GetValue(ps, null)), 2);
// // value = Math.Round((value + value2) , 2);
// // pfvalue.GetType().GetProperty("y" +j.ToString()).SetValue(pfvalue, value, null);
// // }
// // icount++;
// // ps.Sort = li.Count;
// // al.Add(ps.Title);
// // li.Add(ps);
// // }
// //}
// //else
// {
// object obj = Common.Services.BaseService.GetObject("SelectPs_Forecast_MathByWhere",
// "Forecast='" + typetemp + "' and ForecastID='" + listReports[0].ID + "' and Title='" + strtemp[1] + "'");
// if (obj == null)
// continue;
// pf1 = obj as Ps_Forecast_Math;
// pf1.ParentID = "";
// pf1.Title = pf1.Title + str + "<����������-���û�Ԥ�ⷨ>";
// if (al.Contains(pf1.Title))
// continue;
// for (int j = forecastReport.StartYear; j <= forecastReport.EndYear; j++)
// {
// double value2 =Math.Round(Convert.ToDouble(pfvalue.GetType().GetProperty("y" + j.ToString()).GetValue(pfvalue, null)),2 );
// double value =Math.Round(Convert.ToDouble(pf1.GetType().GetProperty("y" + j.ToString()).GetValue(pf1, null)),2 );
// value = Math.Round((value + value2) , 2);
// pfvalue.GetType().GetProperty("y" + j.ToString()).SetValue(pfvalue, value, null);
// }
// icount++;
// pf1.Sort = li.Count;
// li.Add(pf1);
// }
// }
// }
//}
for (int j = forecastReport.StartYear; j <= forecastReport.EndYear; j++)
{
double value = Math.Round(Convert.ToDouble(pfvalue.GetType().GetProperty("y" + j.ToString()).GetValue(pfvalue, null)), 2);
value = Math.Round((value / icount), 2);
pfvalue.GetType().GetProperty("y" + j.ToString()).SetValue(pfvalue, value, null);
}
li.Add(pfvalue);
}
FormForecastJG ffjg = new FormForecastJG();
ffjg.Text = this.Text + "- ����Ƚ�";
ffjg.CanEdit = CanEdit;
ffjg.LI = li;
ffjg.A1 = a3;
ffjg.A2 = a4;
ffjg.PFL = forecastReport;
ffjg.ShowDialog();
}
private void barButtonItem23_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
TreeListNode row = this.treeList1.FocusedNode;
if (row == null)
{
return;
}
string parentid = row["ParentID"].ToString();
FormTypeTitle frm = new FormTypeTitle();
frm.TypeTitle = row["Title"].ToString();
frm.Text = "�ķ�����";
if (frm.ShowDialog() == DialogResult.OK)
{
Ps_Forecast_Math psp_Type = new Ps_Forecast_Math();
ForecastClass1.TreeNodeToDataObject(psp_Type, row);
//psp_Type = Itop.Common.DataConverter.RowToObject<Ps_Forecast_Math>(row);
psp_Type.Title = frm.TypeTitle;
try
{
Common.Services.BaseService.Update<Ps_Forecast_Math>(psp_Type);
row.SetValue("Title",frm.TypeTitle);
}
catch (Exception ex)
{
MsgBox.Show("�ij����" + ex.Message);
}
RefreshChart();
}
}
/// <summary>
/// ��������
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void barButtonItem14_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
FormForecastLoadData2 ffs = new FormForecastLoadData2();
// ffs.Type = type;
ffs.PID = pid;
ffs.StartYear = forecastReport.StartYear;
ffs.EndYear = forecastReport.EndYear;
if (ffs.ShowDialog() != DialogResult.OK)
return;
Hashtable hs = ffs.HS;
if (hs.Count == 0)
return;
string id = Guid.NewGuid().ToString();
if (New_Flag)
{
foreach (Ps_History de3 in hs.Values)
{
Ps_Forecast_Math py = new Ps_Forecast_Math();
py.Col1 = de3.ID;
py.Forecast = 0;
py.ForecastID = forecastReport.ID;
py = (Ps_Forecast_Math)Services.BaseService.GetObject("SelectPs_Forecast_MathByCol1", py);
if (py == null)
{
Ps_Forecast_Math ForecastMath = new Ps_Forecast_Math();
ForecastMath.Title = de3.Title;
for (int i = forecastReport.StartYear; i <= forecastReport.EndYear; i++)
{
ForecastMath.GetType().GetProperty("y" + i).SetValue(ForecastMath, de3.GetType().GetProperty("y" + i).GetValue(de3, null), null);
}
id = id.Substring(0, 8);
ForecastMath.Col1 = de3.ID;
ForecastMath.ID = id + "|" + de3.ID;
ForecastMath.ParentID = id + "|" + de3.ParentID;
ForecastMath.Forecast = 0;
ForecastMath.ForecastID = forecastReport.ID;
ForecastMath.Sort = de3.Sort;
Services.BaseService.Create("InsertPs_Forecast_MathbyPs_History", ForecastMath);
}
else
{
for (int i = forecastReport.StartYear; i <= forecastReport.EndYear; i++)
{
py.GetType().GetProperty("y" + i).SetValue(py, de3.GetType().GetProperty("y" + i).GetValue(de3, null), null);
}
Services.BaseService.Update<Ps_Forecast_Math>(py);
}
}
}
else
{
if (ffs.Selectid != "4")
{
foreach (Ps_History de3 in hs.Values)
{
Ps_Forecast_Math py = new Ps_Forecast_Math();
py.Col1 = de3.ID;
py.Forecast = 0;
py.ForecastID = forecastReport.ID;
py = (Ps_Forecast_Math)Services.BaseService.GetObject("SelectPs_Forecast_MathByCol1", py);
if (py == null)
{
Ps_Forecast_Math ForecastMath = new Ps_Forecast_Math();
ForecastMath.Title = de3.Title;
for (int i = forecastReport.StartYear; i <= forecastReport.EndYear; i++)
{
ForecastMath.GetType().GetProperty("y" + i).SetValue(ForecastMath, de3.GetType().GetProperty("y" + i).GetValue(de3, null), null);
}
id = id.Substring(0, 8);
ForecastMath.Col1 = de3.ID;
ForecastMath.ID = id + "|" + de3.ID;
ForecastMath.ParentID = id + "|" + de3.ParentID;
ForecastMath.Forecast = 0;
ForecastMath.ForecastID = forecastReport.ID;
ForecastMath.Sort = de3.Sort;
Services.BaseService.Create("InsertPs_Forecast_MathbyPs_History", ForecastMath);
}
else
{
for (int i = forecastReport.StartYear; i <= forecastReport.EndYear; i++)
{
py.GetType().GetProperty("y" + i).SetValue(py, de3.GetType().GetProperty("y" + i).GetValue(de3, null), null);
}
Services.BaseService.Update<Ps_Forecast_Math>(py);
}
}
}
else if (ffs.Selectid == "4")
{
foreach (PSP_Types de3 in hs.Values)
{
Ps_Forecast_Math py = new Ps_Forecast_Math();
//py = (Ps_Forecast_Math)Services.BaseService.GetObject("SelectPs_Forecast_MathByWhere", "Title='" + de3.Title + "'" + " and Forecast='0' and ForecastID='" + forecastReport.ID + "' and Col1='"+de3.ID+"'");
py = (Ps_Forecast_Math)Services.BaseService.GetObject("SelectPs_Forecast_MathByWhere", " Forecast='0' and ForecastID='" + forecastReport.ID + "' and Col1='" + de3.ID + "'");
if (py == null)
{
Ps_Forecast_Math ForecastMath = new Ps_Forecast_Math();
IList<PSP_Values> listValues = Common.Services.BaseService.GetList<PSP_Values>("SelectPSP_ValuesByWhere", "TypeID='" + de3.ID + "'");
foreach (PSP_Values value in listValues)
{
ForecastMath.GetType().GetProperty("y" + value.Year).SetValue(ForecastMath, value.Value, null);
}
id = id.Substring(0, 8);
ForecastMath.Title = de3.Title;
ForecastMath.Col1 = de3.ID.ToString();
ForecastMath.ID = id + "|" + de3.ID;
ForecastMath.ParentID = id + "|" + de3.ParentID;
ForecastMath.Forecast = 0;
ForecastMath.ForecastID = forecastReport.ID;
object obj = Services.BaseService.GetObject("SelectPs_Forecast_MathMaxID", null);
if (obj != null)
ForecastMath.Sort = ((int)obj) + 1;
else
ForecastMath.Sort = 1;
Services.BaseService.Create("InsertPs_Forecast_MathbyPs_History", ForecastMath);
}
else
{
IList<PSP_Values> listValues = Common.Services.BaseService.GetList<PSP_Values>("SelectPSP_ValuesByWhere", " TypeID='" + de3.ID + "'");
foreach (PSP_Values value in listValues)
{
py.GetType().GetProperty("y" + value.Year).SetValue(py, value.Value, null);
}
Services.BaseService.Update<Ps_Forecast_Math>(py);
}
}
}
}
LoadData();
//ArrayList al = M1();
//for (int i = 0; i < al.Count; i++)
//{
// TreeListNode tlnn = (TreeListNode)al[i];
// aaa(tlnn);
//}
this.chart_user1.All_Select(true);
RefreshChart();
}
/*
private void RefreshChart()
{
IList<FORBaseColor> list = Services.BaseService.GetList<FORBaseColor>("SelectFORBaseColorByWhere", "Remark='" + this.forecastReport.ID.ToString() + "-" + typeFlag + "'");
IList<FORBaseColor> li = new List<FORBaseColor>();
bool bl = false;
ArrayList aldatablr = new ArrayList();
foreach (DataRow row in dataTable.Rows)
{
aldatablr.Add(row["ID"].ToString());
}
foreach (DataRow row in dataTable.Rows)
{
if (aldatablr.Contains(row["ParentID"].ToString()))
continue;
bl = false;
foreach (FORBaseColor bc in list)
{
if (row["Title"].ToString() == bc.Title && row["ParentID"]!=DBNull.Value)
{
bl = true;
FORBaseColor bc1 = new FORBaseColor();
bc1.Color1 = Color.Blue;
CopyBaseColor(bc1, bc);
li.Add(bc1);
}
}
if (!bl)
{
FORBaseColor bc1 = new FORBaseColor();
bc1.UID = Guid.NewGuid().ToString();
bc1.Remark = this.forecastReport.ID.ToString() + "-" + typeFlag;
bc1.Title = row["Title"].ToString();
bc1.Color = 16711680;
bc1.Color1 = Color.Blue;
Services.BaseService.Create<FORBaseColor>(bc1);
li.Add(bc1);
}
}
ArrayList hs = new ArrayList();
foreach (FORBaseColor bc2 in li)
{
hs.Add(bc2.Color1);
}
List<Ps_Forecast_Math> listValues = new List<Ps_Forecast_Math>();
for (int i = 0; i < treeList1.Nodes.Count; i++)
{
TreeListNode row = treeList1.Nodes[i];
foreach (TreeListColumn col in treeList1.Columns)
{
if (col.FieldName.IndexOf("y") > -1)
{
object obj = row[col.FieldName];
if (obj != DBNull.Value)
{
Ps_Forecast_Math v = new Ps_Forecast_Math();
v.ForecastID = forecastReport.ID;
v.ID = (string)row["ID"];
v.Title = (i + 1).ToString() + "." + row["Title"].ToString();
v.Sort = Convert.ToInt32(col.FieldName.Replace("y", ""));
v.y1990 = (double)row[col.FieldName];
listValues.Add(v);
}
}
}
}
chart1.Series.Clear();
ArrayList al = new ArrayList();
al.Add(Application.StartupPath+"/img/1.ico");
al.Add(Application.StartupPath + "/img/2.ico");
al.Add(Application.StartupPath + "/img/3.ico");
al.Add(Application.StartupPath + "/img/4.ico");
al.Add(Application.StartupPath + "/img/5.ico");
al.Add(Application.StartupPath + "/img/6.ico");
al.Add(Application.StartupPath + "/img/7.ico");
//al.Add("img/8.ico");
//al.Add("img/9.ico");
//al.Add("img/10.ico");
LegendItem legendItem;
LegendCell legendCell1;
LegendCell legendCell2;
LegendCell legendCell3;
Legend legend = new Legend();
legend.AutoFitText = false;
chart1.DataBindCrossTab(listValues, "Title", "Sort", "y1990", "");
for (int i = 0; i < chart1.Series.Count; i++)
{
legendItem = new Dundas.Charting.WinControl.LegendItem();
legendCell1 = new Dundas.Charting.WinControl.LegendCell();
legendCell1.CellType = Dundas.Charting.WinControl.LegendCellType.Image;
legendCell1.Name = "Cell1";
legendCell2 = new Dundas.Charting.WinControl.LegendCell();
legendCell3 = new Dundas.Charting.WinControl.LegendCell();
legendCell2.CellType = Dundas.Charting.WinControl.LegendCellType.Image;
legendCell2.Name = "Cell2";
legendCell3.Alignment = System.Drawing.ContentAlignment.MiddleLeft;
legendCell3.Name = "Cell3";
legendCell3.Text = chart1.Series[i].Name;
legendCell3.TextColor = (Color)hs[i];
/*Ĭ������״ͼ����������DZ��line
// chart1.Series[i].Color = (Color)hs[i];
// chart1.Series[i].Name =chart1.Series[i].Name;
// chart1.Series[i].Type = Dundas.Charting.WinControl.SeriesChartType.Line;
// chart1.Series[i].MarkerImage = al[i % 7].ToString();
// chart1.Series[i].MarkerSize = 7;
// chart1.Series[i].MarkerStyle = (Dundas.Charting.WinControl.MarkerStyle)(2);
//// chart1.Series[i].XValueIndexed = true;
chart1.Series[i].Color = (Color)hs[i];
chart1.Series[i].Name = (i + 1).ToString() + "." + chart1.Series[i].Name;
chart1.Series[i].Type = Dundas.Charting.WinControl.SeriesChartType.Line;
chart1.Series[i].MarkerImage = al[i % 7].ToString();
chart1.Series[i].MarkerSize = 7;
chart1.Series[i].MarkerStyle = (Dundas.Charting.WinControl.MarkerStyle)(2);
chart1.Series[i].ShowInLegend = false;
legendItem.Cells.Add(legendCell1);
legendItem.Cells.Add(legendCell3);
legendItem.Tag = chart1.Series[i];
if (checkBox1.Checked)
{
legendItem.Cells[0].Image = string.Format(Application.StartupPath + @"/img/chk_checked.png");
}
else
{
legendItem.Cells[0].Image = string.Format(Application.StartupPath + @"/img/chk_unchecked.png");
}
legend.CustomItems.Add(legendItem);
chart1.Series[i].Enabled = checkBox1.Checked;
}
chart1.ChartAreas["Default"].AxisX.MinorGrid.Enabled = false;
chart1.ChartAreas["Default"].AxisY.MinorGrid.Enabled = true;
chart1.ChartAreas["Default"].AxisY.MinorGrid.LineStyle = ChartDashStyle.Dash;
chart1.ChartAreas["Default"].AxisY.MinorGrid.LineColor = Color.Gray;
legend.Name = "Default";
chart1.Legends.Add(legend);
}
*/
private void RefreshChart()
{
ArrayList ht = new ArrayList();
ht.Add(Color.Red);
ht.Add(Color.Blue);
ht.Add(Color.Green);
ht.Add(Color.Yellow);
ht.Add(Color.HotPink);
ht.Add(Color.LawnGreen);
ht.Add(Color.Khaki);
ht.Add(Color.LightSlateGray);
ht.Add(Color.LightSeaGreen);
ht.Add(Color.Lime);
ht.Add(Color.Black);
ht.Add(Color.Brown);
ht.Add(Color.Crimson);
int m = 0;
IList<FORBaseColor> list = Services.BaseService.GetList<FORBaseColor>("SelectFORBaseColorByWhere", "Remark='" + this.forecastReport.ID.ToString() + "-" + typeFlag + "'");
IList<FORBaseColor> li = new List<FORBaseColor>();
bool bl = false;
ArrayList aldatablr = new ArrayList();
foreach (DataRow row in dataTable.Rows)
{
aldatablr.Add(row["ID"].ToString());
}
foreach (DataRow row in dataTable.Rows)
{
if (aldatablr.Contains(row["ParentID"].ToString()))
continue;
bl = false;
foreach (FORBaseColor bc in list)
{
if (row["Title"].ToString() == bc.Title && row["ParentID"] != DBNull.Value)
{
bl = true;
FORBaseColor bc1 = new FORBaseColor();
bc1.Color1 = bc.Color1;
//bc1.Color1 = Color.Blue;
CopyBaseColor(bc1, bc);
li.Add(bc1);
}
}
if (!bl)
{
FORBaseColor bc1 = new FORBaseColor();
bc1.UID = Guid.NewGuid().ToString();
bc1.Remark = this.forecastReport.ID.ToString() + "-" + typeFlag;
bc1.Title = row["Title"].ToString();
//bc1.Color = 16711680;
if (m == 0)
{
Random rd = new Random();
m = rd.Next(100);
}
Color cl = (Color)ht[m % 13];
bc1.Color = ColorTranslator.ToOle(cl);
bc1.Color1 =cl;
//bc1.Color1 = Color.Blue;
Services.BaseService.Create<FORBaseColor>(bc1);
li.Add(bc1);
}
m++;
}
ArrayList hs = new ArrayList();
foreach (FORBaseColor bc2 in li)
{
hs.Add(bc2.Color1);
}
List<Ps_Forecast_Math> listValues = new List<Ps_Forecast_Math>();
for (int i = 0; i < treeList1.Nodes.Count; i++)
{
TreeListNode row = treeList1.Nodes[i];
foreach (TreeListColumn col in treeList1.Columns)
{
if (col.FieldName.IndexOf("y") > -1)
{
object obj = row[col.FieldName];
if (obj != DBNull.Value)
{
Ps_Forecast_Math v = new Ps_Forecast_Math();
v.ForecastID = forecastReport.ID;
v.ID = (string)row["ID"];
v.Title = row["Title"].ToString();
v.Sort = Convert.ToInt32(col.FieldName.Replace("y", ""));
v.y1990 = (double)row[col.FieldName];
listValues.Add(v);
}
}
}
}
this.chart_user1.RefreshChart(listValues, "Title", "Sort", "y1990", hs);
}
private void InitMenu()
{
barButtonItem1.ImageIndex = -1;
barButtonItem25.ImageIndex = -1;
barButtonItem3.ImageIndex = -1;
barButtonItem2.ImageIndex = -1;
barButtonItem8.ImageIndex = -1;
barButtonItem4.ImageIndex = -1;
barButtonItem19.ImageIndex = -1;
//barButtonItem12.ImageIndex = -1;
//barButtonItem16.ImageIndex = -1;
//barButtonItem19.ImageIndex = -1;
barButtonItem30.ImageIndex = -1;
Ps_Forecast_Math psp_Typen = new Ps_Forecast_Math();
psp_Typen.ForecastID = forecastReport.ID;
psp_Typen.Forecast = 1;
IList listTypesn = Common.Services.BaseService.GetList("SelectPs_Forecast_MathByForecastIDAndForecast", psp_Typen);
if (listTypesn.Count > 0)
barButtonItem1.ImageIndex = 0;
psp_Typen.Forecast = 2;
listTypesn = Common.Services.BaseService.GetList("SelectPs_Forecast_MathByForecastIDAndForecast", psp_Typen);
if (listTypesn.Count > 0)
barButtonItem25.ImageIndex = 0;
psp_Typen.Forecast = 3;
listTypesn = Common.Services.BaseService.GetList("SelectPs_Forecast_MathByForecastIDAndForecast", psp_Typen);
if (listTypesn.Count > 0)
barButtonItem3.ImageIndex = 0;
psp_Typen.Forecast = 4;
listTypesn = Common.Services.BaseService.GetList("SelectPs_Forecast_MathByForecastIDAndForecast", psp_Typen);
if (listTypesn.Count > 0)
barButtonItem2.ImageIndex = 0;
psp_Typen.Forecast = 5;
listTypesn = Common.Services.BaseService.GetList("SelectPs_Forecast_MathByForecastIDAndForecast", psp_Typen);
if (listTypesn.Count > 0)
barButtonItem8.ImageIndex = 0;
psp_Typen.Forecast = 6;
listTypesn = Common.Services.BaseService.GetList("SelectPs_Forecast_MathByForecastIDAndForecast", psp_Typen);
if (listTypesn.Count > 0)
barButtonItem4.ImageIndex = 0;
psp_Typen.Forecast = 7;
listTypesn = Common.Services.BaseService.GetList("SelectPs_Forecast_MathByForecastIDAndForecast", psp_Typen);
if (listTypesn.Count > 0)
barButtonItem19.ImageIndex = 0;
psp_Typen.Forecast = 12;
listTypesn = Common.Services.BaseService.GetList("SelectPs_Forecast_MathByForecastIDAndForecast", psp_Typen);
if (listTypesn.Count > 0)
barButtonItem30.ImageIndex = 0;
psp_Typen.Forecast = 17;
listTypesn = Common.Services.BaseService.GetList("SelectPs_Forecast_MathByForecastIDAndForecast", psp_Typen);
if (listTypesn.Count > 0)
barButtonItem35.ImageIndex = 0;
}
private void LoadData()
{
treeList1.DataSource = null;
bLoadingData = true;
if (dataTable2 != null)
{
dataTable1.Columns.Clear();
dataTable2.Columns.Clear();
treeList2.Columns.Clear();
treeList1.Columns.Clear();
}
if (dataTable2 != null)
{
treeList3.Columns.Clear();
}
if (dataTable1 != null)
{
dataTable1.Columns.Clear();
}
AddFixColumn();
AddFixColumn2();
AddFixColumn3();
for (int i = forecastReport.StartYear; i <= forecastReport.EndYear; i++)
{
AddColumn(i);
}
for (int i = forecastReport.StartYear; i <=forecastReport.EndYear; i++)
{
AddColumn2(i);
}
for (int i = forecastReport.StartYear; i <= forecastReport.EndYear; i++)
{
AddColumn3(i);
}
Ps_Forecast_Math psp_Type = new Ps_Forecast_Math();
psp_Type.ForecastID = forecastReport.ID;
psp_Type.Forecast = type;
IList<Ps_Forecast_Math> listTypes = Common.Services.BaseService.GetList<Ps_Forecast_Math>("SelectPs_Forecast_MathByForecastIDAndForecast", psp_Type);
dataTable2 = Itop.Common.DataConverter.ToDataTable((IList)listTypes, typeof(Ps_Forecast_Math));
treeList2.DataSource = dataTable2;
Hashtable ht = new Hashtable();
IList<Ps_BadData> list = new List<Ps_BadData>();
foreach (Ps_Forecast_Math pfm in listTypes)
{
Ps_BadData pb1 = new Ps_BadData();
pb1.ForecastID = pfm.ForecastID;
pb1.Forecast = type;
pb1.Col1 = pfm.ID;
Ps_BadData pb = new Ps_BadData();
IList<Ps_BadData> li = Common.Services.BaseService.GetList<Ps_BadData>("SelectPs_BadDataByCol1", pb1);
if (li.Count == 0)
{
pb = new Ps_BadData();
pb.ID = pfm.ID+"|m|"+type;
pb.Title = pfm.Title;
pb.ForecastID = pfm.ForecastID;
pb.Forecast = type;
pb.Col1 = pfm.ID;
pb.ParentID = pfm.ParentID + "|m|" + type;
Services.BaseService.Create<Ps_BadData>(pb);
}
else
pb = li[0];
list.Add(pb);
}
dataTable1 = Itop.Common.DataConverter.ToDataTable((IList)list, typeof(Ps_BadData));
treeList2.Columns["Title"].OptionsColumn.AllowEdit = false;
treeList1.DataSource = dataTable1;
Application.DoEvents();
bLoadingData = false;
}
private void LoadData()
{
this.splitContainerControl1.SplitterPosition = (2 * this.splitterControl1.Width) / 3;
this.splitContainerControl2.SplitterPosition = splitContainerControl2.Height / 2;
treeList1.DataSource = null;
bLoadingData = true;
if (dataTable != null)
{
dataTable.Columns.Clear();
treeList1.Columns.Clear();
}
AddFixColumn();
for (int i = forecastReport.StartYear; i <= forecastReport.EndYear; i++)
{
AddColumn(i);
}
Ps_Forecast_Math psp_Type = new Ps_Forecast_Math();
psp_Type.ForecastID = forecastReport.ID;
psp_Type.Forecast = type;
IList listTypes = Common.Services.BaseService.GetList("SelectPs_Forecast_MathByForecastIDAndForecast", psp_Type);
dataTable = Itop.Common.DataConverter.ToDataTable(listTypes, typeof(Ps_Forecast_Math));
treeList1.DataSource = dataTable;
treeList1.Columns["Title"].OptionsColumn.AllowEdit = false;
Ps_Calc pcs = new Ps_Calc();
pcs.Forecast = 5;
pcs.ForecastID = forecastReport.ID;
IList<Ps_Calc> list1 = Services.BaseService.GetList<Ps_Calc>("SelectPs_CalcByForecast", pcs);
if (list1.Count > 0)
{
spinEdit1.Value = (decimal)list1[0].Value1;
}
Application.DoEvents();
bLoadingData = false;
}
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
if (comboBox1.SelectedItem==null)
{
return;
}
if (comboBox1.SelectedItem.ToString() == "���Ʒ�")
{
if (!comboBox6.Items.Contains("���Ʒ�(�������ʷ�)"))
{
comboBox6.Items.Clear();
comboBox6.Items.Add("���Ʒ�(�������ʷ�)");
comboBox6.Items.Add("���Ʒ�(ֱ��)");
comboBox6.Items.Add("���Ʒ�(������)");
comboBox6.Items.Add("���Ʒ�(����)");
comboBox6.Items.Add("���Ʒ�(ָ��)");
comboBox6.Items.Add("���Ʒ�(��������)");
}
comboBox6.Visible = true;
comboBox6.Enabled = true;
label6.Visible = true;
label6.Enabled = true;
}
else if (comboBox1.SelectedItem.ToString() == "��ط�")
{
if (!comboBox6.Items.Contains("��ط�(ֱ��)"))
{
comboBox6.Items.Clear();
comboBox6.Items.Add("��ط�(ֱ��)");
comboBox6.Items.Add("��ط�(������)");
comboBox6.Items.Add("��ط�(����)");
comboBox6.Items.Add("��ط�(ָ��)");
comboBox6.Items.Add("��ط�(��������)");
}
comboBox6.Visible = true;
comboBox6.Enabled = true;
label6.Visible = true;
label6.Enabled = true;
}
else if (comboBox1.SelectedItem.ToString() == "ָ��ƽ����")
{
Ps_Calc pcs = new Ps_Calc();
pcs.Forecast = 5;
pcs.ForecastID = forecastReport.ID;
IList<Ps_Calc> list1 = Services.BaseService.GetList<Ps_Calc>("SelectPs_CalcByForecast", pcs);
if (list1.Count < 1)
{
MessageBox.Show("ƽ������δ���ã�����Ĭ��ֵ0.1����");
}
comboBox6.Visible = false;
comboBox6.Enabled = false;
label6.Visible = false;
label6.Enabled = false;
}
else if (comboBox1.SelectedItem.ToString() == "ר�Ҿ��߷�")
{
Ps_Forecast_Math psp_Type = new Ps_Forecast_Math();
psp_Type.ForecastID = forecastReport.ID;
psp_Type.Forecast = 7;
IList listTypes = Common.Services.BaseService.GetList("SelectPs_Forecast_MathByForecastIDAndForecast", psp_Type);
if (listTypes.Count<1)
{
MessageBox.Show("ר�Ҿ��߷�û�����ݣ�ѡ��ʧ��");
comboBox1.SelectedIndex = -1;
}
}
else
{
comboBox6.Visible = false;
comboBox6.Enabled = false;
label6.Visible = false;
label6.Enabled = false;
}
}
private void FormForecastCalc4_Load(object sender, EventArgs e)
{
#region ������չʵ��
Ps_YearRange py = new Ps_YearRange();
py.Col4 = "������չʵ������";
py.Col5 = Itop.Client.MIS.ProgUID;
IList<Ps_YearRange> li2 = Services.BaseService.GetList<Ps_YearRange>("SelectPs_YearRangeByCol5andCol4", py);
if (li2.Count > 0)
{
firstyear1 = li2[0].StartYear;
endyear1 = li2[0].FinishYear;
}
//�¾�������
//Ps_History psp_Type = new Ps_History();
//psp_Type.Forecast = 5;
//psp_Type.Col4 = Itop.Client.MIS.ProgUID;
//IList<Ps_History> listTypes = Common.Services.BaseService.GetList<Ps_History>("SelectPs_HistoryByForecast", psp_Type);
//DataTable dataTable = Itop.Common.DataConverter.ToDataTable((IList)listTypes, typeof(Ps_History));
//DataRow[] rows1 = dataTable.Select("Title like 'ȫ����GDP%'");
Ps_Forecast_Math psp_Type = new Ps_Forecast_Math();
psp_Type.ForecastID = forecastReport.ID;
psp_Type.Forecast = type;
IList listTypes = Common.Services.BaseService.GetList("SelectPs_Forecast_MathByForecastIDAndForecast", psp_Type);
dataTable = Itop.Common.DataConverter.ToDataTable(listTypes, typeof(Ps_Forecast_Math));
DataRow[] rows1 = dataTable.Select("Title like 'ȫ����GDP%'");
DataRow[] rows4 = dataTable.Select("Title like 'ȫ����õ���%'");
//�µ�������
//Ps_History psp_Type2 = new Ps_History();
//psp_Type2.Forecast = 6;
//psp_Type2.Col4 = Itop.Client.MIS.ProgUID;
//IList<Ps_History> listTypes2 = Common.Services.BaseService.GetList<Ps_History>("SelectPs_HistoryByForecast", psp_Type2);
//DataTable dataTable2 = Itop.Common.DataConverter.ToDataTable((IList)listTypes2, typeof(Ps_History));
//DataRow[] rows4 = dataTable2.Select("Title like 'ȫ����õ���%'");
if (rows1.Length == 0 )
{
MessageBox.Show("ȱ�١�ȫ����GDP�����ݣ�");
this.Close();
return;
}
if (rows4.Length==0)
{
MessageBox.Show("����������ȱ�١�ȫ����õ��������ݣ�");
this.Close();
return;
}
#endregion
Ps_Forecast_Setup pfs = new Ps_Forecast_Setup();
pfs.Forecast = type;
pfs.ForecastID = forecastReport.ID;
IList<Ps_Forecast_Setup> li = Services.BaseService.GetList<Ps_Forecast_Setup>("SelectPs_Forecast_SetupByForecast", pfs);
if (li.Count != 0)
{
firstyear = li[0].StartYear;
endyear = li[0].EndYear;
}
Ps_Calc pcs = new Ps_Calc();
pcs.Forecast = type;
pcs.ForecastID = forecastReport.ID;
list1 = Services.BaseService.GetList<Ps_Calc>("SelectPs_CalcByForecast", pcs);
HideToolBarButton();
dt = new DataTable();
dt.Columns.Add("ID");
dt.Columns.Add("Name");
newrow1 = dt.NewRow();
newrow1["ID"] = "ID";
newrow1["Name"] = "����ϵ��";
//newrow2 = dt.NewRow();
//newrow2["Name"] = "GDP������";
for (int i = firstyear; i <= forecastReport.YcEndYear; i++)
{
dt.Columns.Add(i.ToString(), typeof(double));
DevExpress.XtraVerticalGrid.Rows.EditorRow editorRow = new DevExpress.XtraVerticalGrid.Rows.EditorRow();
editorRow.Properties.FieldName = i.ToString().Trim();
editorRow.Properties.Caption =i.ToString().Trim();
editorRow.Height = 20;
editorRow.Properties.RowEdit = this.repositoryItemCalcEdit4;
this.vGridControl2.Rows.AddRange(new DevExpress.XtraVerticalGrid.Rows.BaseRow[] { editorRow });
double s1 = 0;
double s2 = 0;
double s3 = 0;
double s4 = 0;
double s5 = 0;
double s6 = 0;
double s7 = 0;
try { s1 = Convert.ToDouble(rows1[0]["y" + i]); }
catch { }
try { s2 = Convert.ToDouble(rows1[0]["y" + (i-1)]); }
catch { }
try { s3 = Convert.ToDouble(rows4[0]["y" + i]); }
catch { }
try { s4 = Convert.ToDouble(rows4[0]["y" + (i - 1)]); }
catch { }
if (s2 != 0)
s5 = (s1 - s2) / s2;
if (s4 != 0)
s6 = (s3 - s4) / s4;
if (s5 != 0)
s7 = s6 / s5;
newrow1[i.ToString()] = Math.Round(s7,3);
//newrow2[i.ToString()] =Math.Round( s5,3);
if (i>=forecastReport.YcStartYear)
{
foreach (Ps_Calc pcs2 in list1)
{
if (i == pcs2.Year)
{
newrow1[i.ToString()] = Math.Round(pcs2.Value1, 3);
}
}
}
}
dt.Rows.Add(newrow1);
//dt.Rows.Add(newrow2);
// gridControl1.DataSource = dt;
vGridControl2.DataSource = dt;
}
private void LoadData()
{
treeList1.DataSource = null;
bLoadingData = true;
if (dataTable != null)
{
dataTable.Columns.Clear();
this.treeList1.Columns.Clear();
}
AddFixColumn();
for (int i = forecastReport.StartYear; i <= forecastReport.YcEndYear; i++)
{
AddColumn(i);
}
Ps_Forecast_Math psp_Type = new Ps_Forecast_Math();
psp_Type.ForecastID = forecastReport.ID;
psp_Type.Forecast = type;
IList listTypes = Common.Services.BaseService.GetList("SelectPs_Forecast_MathByForecastIDAndForecast", psp_Type);
dataTable = Itop.Common.DataConverter.ToDataTable(listTypes, typeof(Ps_Forecast_Math));
this.treeList1.DataSource = dataTable;
Application.DoEvents();
bLoadingData = false;
this.chart_user1.All_Select(true);
RefreshChart();
}
private void GetResult()
{
string sql = " Col4='yes' and (Forecast=1 or Forecast=2 or Forecast=5 or Forecast=6 or Forecast=7 or Forecast=13 or Forecast=15 or Forecast=20) and ParentID=''";
sql += " and ForecastID='" + forecastReport.ID + "'";
htable.Clear();
IList<Ps_Forecast_Math> list = Common.Services.BaseService.GetList<Ps_Forecast_Math>("SelectPs_Forecast_MathByWhere",sql);
foreach (Ps_Forecast_Math pfm in list)
{
if (!htable.ContainsKey(pfm.Title))
{
htable.Add(pfm.Title, pfm.Title);
}
}
foreach (string key in htable.Keys)
{
resulttable.Clear();
Ps_Forecast_Math pfm = new Ps_Forecast_Math();
pfm.ID = Guid.NewGuid().ToString();
pfm.Title = key.ToString()+"-推荐值";
pfm.Forecast = type;
pfm.ForecastID = forecastReport.ID;
Common.Services.BaseService.Create<Ps_Forecast_Math>(pfm);
string sqlr = " Col4='yes' and (Forecast=1 or Forecast=2 or Forecast=5 or Forecast=6 or Forecast=7 or Forecast=13 or Forecast=15 or Forecast=20) and ParentID=''";
sqlr += " and ForecastID='" + forecastReport.ID + "' and Title='" + key.ToString() + "'";
IList<Ps_Forecast_Math> listresult = Common.Services.BaseService.GetList<Ps_Forecast_Math>("SelectPs_Forecast_MathByWhere", sqlr);
foreach (Ps_Forecast_Math pfmr in listresult)
{
string title = string.Empty;
if (GetMetheod(pfmr.Forecast, out title))
{
pfmr.ID = Guid.NewGuid().ToString();
pfmr.Forecast = type;
pfmr.Title = title;
pfmr.ParentID = pfm.ID;
pfmr.Col2 = "0";
pfmr.Col4 = "";
Common.Services.BaseService.Create<Ps_Forecast_Math>(pfmr);
}
}
}
}
/// <summary>
/// ��Ӧ���û�����
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void barButtonItem1_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
IList<Ps_forecast_list> listReports = Common.Services.BaseService.GetList<Ps_forecast_list>("SelectPs_forecast_listByWhere", "UserID='" + Itop.Client.MIS.ProgUID + "' and Col1='2' and Title='" + forecastReport.Title + "'");
if (listReports.Count > 0)
{
WaitDialogForm wait = new WaitDialogForm("", "���ڸ�������, ���Ժ�...");
DataRow[] drlist = dataTable.Select("Title like '%-%'");
int typetemp = 0;
foreach (DataRow dr in drlist)
{
Ps_Forecast_Math psp_TypePan = new Ps_Forecast_Math();
string[] str = dr["Title"].ToString().Split('-');
if (str[0].Contains("����"))
typetemp = 2;
else
typetemp = 3;
//psp_Type.Forecast = 2;
//psp_Type.ForecastID = listReports[0].ID;
//psp_Type.Title=str[1];
object obj = Common.Services.BaseService.GetObject("SelectPs_Forecast_MathByWhere",
"Forecast='" + typetemp + "' and ForecastID='" + listReports[0].ID + "' and Title='" + str[1] + "'");
if (obj == null)
continue;
Ps_Forecast_Math psp_Type = obj as Ps_Forecast_Math;
psp_TypePan = obj as Ps_Forecast_Math;
obj = Common.Services.BaseService.GetObject("SelectPs_Forecast_MathByWhere",
"Forecast='" + typetemp + "' and ForecastID='" + listReports[0].ID + "' and ParentID='" + psp_Type.ID + "'" + " and Title='" + str[0] + "'");
if (obj == null)
continue;
psp_Type = obj as Ps_Forecast_Math;
Ps_Forecast_Math v = DataConverter.RowToObject<Ps_Forecast_Math>(dr);
v.ID = psp_Type.ID;
v.ParentID = psp_Type.ParentID;
v.Forecast = psp_Type.Forecast;
v.ForecastID = psp_Type.ForecastID;
v.Sort = psp_Type.Sort;
v.Title = psp_Type.Title;
v.Col1 = psp_Type.Col1;
v.Col2 = psp_Type.Col2;
v.Col3 = psp_Type.Col3;
v.Col4 = psp_Type.Col4;
Common.Services.BaseService.Update<Ps_Forecast_Math>(v);
updateAllPan(psp_TypePan, listReports[0]);
//////////////����
//string strtemp = "";
//if (typetemp==2)
//{
// strtemp = " and Title!='ͬʱ��'";
//}
//else
// if (typetemp == 3)
// {
// strtemp = "";
// }
//IList<Ps_Forecast_Math> mathlist = Common.Services.BaseService.GetList<Ps_Forecast_Math>("SelectPs_Forecast_MathByWhere",
// "Forecast='" + typetemp + "' and ForecastID='" + listReports[0].ID + "' and ParentID='" + psp_TypePan.ID + "'" + strtemp);
//double value = 0;
//for (int i = listReports[0].StartYear; i < listReports[0].EndYear; i++)
//{
// value = 0;
// foreach (Ps_Forecast_Math mat in mathlist)
// {
// if (mat.Title=="ͬʱ��")
// value*= (double)mat.GetType().GetProperty("y" + i.ToString()).GetValue(mat, null);
// else
// value += (double)mat.GetType().GetProperty("y" + i.ToString()).GetValue(mat, null);
// }
// psp_TypePan.GetType().GetProperty("y" + i.ToString()).SetValue(psp_TypePan, value, null);
// Common.Services.BaseService.Update<Ps_Forecast_Math>(psp_TypePan);
//}
}
wait.Close();
MessageBox.Show("���³ɹ���");
}
}
private void updateAllPan(Ps_Forecast_Math psp_TypePan, Ps_forecast_list listReports)
{
string strtemp = "";
if (psp_TypePan.Forecast == 2)
{
strtemp = " and Title!='ͬʱ��'";
}
else
if (psp_TypePan.Forecast == 3)
{
strtemp = "";
}
IList<Ps_Forecast_Math> mathlist = Common.Services.BaseService.GetList<Ps_Forecast_Math>("SelectPs_Forecast_MathByWhere",
"Forecast='" + psp_TypePan.Forecast + "' and ForecastID='" + psp_TypePan.ForecastID + "' and ParentID='" + psp_TypePan.ID + "'" + strtemp+" order by sort desc");
Ps_Forecast_Math matcgui ;
Ps_Forecast_Math matdyh;
Ps_Forecast_Math mattsl;
//if (psp_TypePan.Title.Contains("���غϼ�"))
//{
matcgui = new Ps_Forecast_Math();//����
matdyh = new Ps_Forecast_Math();//���û�
mattsl = new Ps_Forecast_Math();//ͬʱ��
//}
double value = 0;
double value2 = 0;
for (int i = listReports.StartYear; i <= listReports.EndYear; i++)
{
value = 0;
value2 = 0;
foreach (Ps_Forecast_Math mat in mathlist)
{
if (psp_TypePan.Title.Contains("���غϼ�") && (mat.Title.Contains("����") || mat.Title.Contains("���û�") || mat.Title.Contains("ͬʱ��")))
{
if (mat.Title.Contains("����"))
{
matcgui = mat;
}
else
if (mat.Title.Contains("���û�"))
{
matdyh = mat;
}
else
if (mat.Title.Contains("ͬʱ��"))
{
mattsl = mat;
}
if (!mat.Title.Contains("ͬʱ��"))
continue;
}
if (mat.Title == "ͬʱ��")
value2 = value2 * Math.Round(Convert.ToDouble( mat.GetType().GetProperty("y" + i.ToString()).GetValue(mat, null)),2);
else
value2 += Math.Round(Convert.ToDouble(mat.GetType().GetProperty("y" + i.ToString()).GetValue(mat, null)), 2);
}
value += value2;
psp_TypePan.GetType().GetProperty("y" + i.ToString()).SetValue(psp_TypePan, value, null);
Common.Services.BaseService.Update<Ps_Forecast_Math>(psp_TypePan);
}
if (psp_TypePan.ParentID != "")
{
psp_TypePan = Common.Services.BaseService.GetOneByKey<Ps_Forecast_Math>(psp_TypePan.ParentID);
updateAllPan(psp_TypePan, listReports);
}
else
if (psp_TypePan.Title.Contains("���غϼ�"))
{
value = 0;
value2 = 0;
for (int i = listReports.StartYear; i <= listReports.EndYear; i++)
{
value2 = Math.Round(Convert.ToDouble(mattsl.GetType().GetProperty("y" + i.ToString()).GetValue(mattsl, null)),2);
if ( psp_TypePan.Forecast==3)
{
if(value2 != 0 )
{
value2=Math.Round(Convert.ToDouble(psp_TypePan.GetType().GetProperty("y" + i.ToString()).GetValue(psp_TypePan, null)),2)/value2;
value=value2-Math.Round(Convert.ToDouble(matdyh.GetType().GetProperty("y" + i.ToString()).GetValue(matdyh, null)),2);
matcgui.GetType().GetProperty("y" + i.ToString()).SetValue(matcgui, value, null);
Common.Services.BaseService.Update<Ps_Forecast_Math>(matcgui);
}
}
else
if (psp_TypePan.Forecast == 2)
{
value2 =Math.Round(Convert.ToDouble(psp_TypePan.GetType().GetProperty("y" + i.ToString()).GetValue(psp_TypePan, null)),2 );
value = value2 -Math.Round( Convert.ToDouble(matdyh.GetType().GetProperty("y" + i.ToString()).GetValue(matdyh, null)),2);
matcgui.GetType().GetProperty("y" + i.ToString()).SetValue(matcgui, value, null);
Common.Services.BaseService.Update<Ps_Forecast_Math>(matcgui);
}
}
}
}
private void SelectData()
{
object row = this.gridView1.GetRow(this.gridView1.FocusedRowHandle);
if (row == null)
return;
Ps_forecast_list pf = row as Ps_forecast_list;
string id = pf.ID;
int m = 1;
switch (barEditItem1.EditValue.ToString())
{
case "�������ʷ�":
m = 1;
break;
case "���Ʒ�":
m = 2;
break;
case "ָ��ƽ����":
m = 3;
break;
case "����ϵ����":
m = 4;
break;
case "��ֵ���ķ�":
m = 17;
break;
case "��ɫ���۷�":
m = 6;
break;
case "ר�Ҿ��߷�":
m = 7;
break;
case "�����㷨":
m = 9;
break;
case "�Ƽ�ֵ":
m = 30;
break;
}
DataTable dataTable = new DataTable();
bool bLoadingData = true;
if (dataTable != null)
{
dataTable.Columns.Clear();
this.gridView2.Columns.Clear();
}
AddFixColumn();
for (int i = pf.StartYear; i <= pf.YcEndYear; i++)
{
AddColumn(i);
}
if (m == 30)
{
string sql2 = " Col4='yes' and Forecast=" + m + " and ParentID='' and ForecastID='" + id + "'";
IList list = Common.Services.BaseService.GetList("SelectPs_Forecast_MathByWhere", sql2);
dataTable = Itop.Common.DataConverter.ToDataTable(list, typeof(Ps_Forecast_Math));
}
else
{
Ps_Forecast_Math psp_Type = new Ps_Forecast_Math();
psp_Type.ForecastID = id;
psp_Type.Forecast = m;
IList listTypes = Common.Services.BaseService.GetList("SelectPs_Forecast_MathByForecastIDAndForecast", psp_Type);
dataTable = Itop.Common.DataConverter.ToDataTable(listTypes, typeof(Ps_Forecast_Math));
}
this.gridControl2.DataSource = dataTable;
Application.DoEvents();
bLoadingData = false;
}
private void barButtonItem1_ItemClick_1(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
Ps_Forecast_Math psp_Type = new Ps_Forecast_Math();
psp_Type.ForecastID = forecastReport.ID;
psp_Type.Forecast = type;
Common.Services.BaseService.Update("DeletePs_Forecast_MathForecastIDAndForecast", psp_Type);
psp_Type.Forecast = type;
IList listTypes = Common.Services.BaseService.GetList("SelectPs_Forecast_MathByForecastIDAndForecast", psp_Type);
foreach (Ps_Forecast_Math psp_Typetemp in listTypes)
{
psp_Type = new Ps_Forecast_Math();
psp_Type = psp_Typetemp;
psp_Type.ID = Guid.NewGuid().ToString();
psp_Type.Forecast = type;
Common.Services.BaseService.Create<Ps_Forecast_Math>(psp_Type);
}
LoadData();
RefreshChart();
}
private void RefreshChart(int syear, int eyear)
{
IList<FORBaseColor> list = Services.BaseService.GetList<FORBaseColor>("SelectFORBaseColorByWhere", "Remark='" + this.forecastReport.ID.ToString() + "-" + type + "'");
IList<FORBaseColor> li = new List<FORBaseColor>();
bool bl = false;
foreach (DataRow row in dataTable.Rows)
{
bl = false;
foreach (FORBaseColor bc in list)
{
if (row["Title"].ToString() == bc.Title)
{
bl = true;
FORBaseColor bc1 = new FORBaseColor();
bc1.Color1 = Color.Blue;
CopyBaseColor(bc1, bc);
li.Add(bc1);
}
}
if (!bl)
{
FORBaseColor bc1 = new FORBaseColor();
bc1.UID = Guid.NewGuid().ToString();
bc1.Remark = this.forecastReport.ID.ToString() + "-" + type;
bc1.Title = row["Title"].ToString();
bc1.Color = 16711680;
bc1.Color1 = Color.Blue;
Services.BaseService.Create<FORBaseColor>(bc1);
li.Add(bc1);
}
}
ArrayList hs = new ArrayList();
foreach (FORBaseColor bc2 in li)
{
hs.Add(bc2.Color1);
}
List<Ps_Forecast_Math> listValues = new List<Ps_Forecast_Math>();
for (int i = 0; i < this.treeList1.Nodes.Count; i++)
{
TreeListNode row = treeList1.Nodes[i];
foreach (TreeListColumn col in treeList1.Columns)
{
if (col.FieldName.IndexOf("y") > -1)
{
int yyear = int.Parse(col.FieldName.Replace("y", ""));
if (yyear >= syear && yyear <= eyear)
{
object obj = row[col.FieldName];
if (obj != DBNull.Value)
{
Ps_Forecast_Math v = new Ps_Forecast_Math();
v.ForecastID = forecastReport.ID;
v.ID = (string)row["ID"];
v.Title = row["Title"].ToString();
v.Sort = Convert.ToInt32(col.FieldName.Replace("y", ""));
v.y1990 = (double)row[col.FieldName];
listValues.Add(v);
}
}
}
}
}
chart1.Series.Clear();
chart1.DataBindCrossTab(listValues, "Title", "Sort", "y1990", "");
//for (int i = 0; i < chart1.Series.Count; i++)
//{
// chart1.Series[i].Color = (Color)hs[i];
// chart1.Series[i].Name = (i + 1).ToString() + "." + chart1.Series[i].Name;
// chart1.Series[i].Type = Dundas.Charting.WinControl.SeriesChartType.Line;
// chart1.Series[i].MarkerSize = 7;
// chart1.Series[i].MarkerStyle = (Dundas.Charting.WinControl.MarkerStyle)(2);
//}
m_pf.SetChart(chart1, checkBox1, hs, null);
}
private void RefreshChart()
{
IList<FORBaseColor> list = Services.BaseService.GetList<FORBaseColor>("SelectFORBaseColorByWhere", "Remark='" + this.forecastReport.ID.ToString() + "-1" + type + "'");
IList<FORBaseColor> li = new List<FORBaseColor>();
bool bl = false;
foreach (DataRow row in dataTable2.Rows)
{
bl = false;
foreach (FORBaseColor bc in list)
{
if (row["Title"].ToString() == bc.Title)
{
bl = true;
FORBaseColor bc1 = new FORBaseColor();
bc1.Color1 = Color.Blue;
CopyBaseColor(bc1, bc);
li.Add(bc1);
}
}
if (!bl)
{
FORBaseColor bc1 = new FORBaseColor();
bc1.UID = Guid.NewGuid().ToString();
bc1.Remark = this.forecastReport.ID.ToString() + "-1" + type;
bc1.Title = row["Title"].ToString();
bc1.Color = 16711680;
bc1.Color1 = Color.Blue;
Services.BaseService.Create<FORBaseColor>(bc1);
li.Add(bc1);
}
}
ArrayList hs = new ArrayList();
foreach (FORBaseColor bc2 in li)
{
hs.Add(bc2.Color1);
}
List<Ps_Forecast_Math> listValues = new List<Ps_Forecast_Math>();
for (int i = 0; i < treeList2.Nodes.Count; i++)
{
TreeListNode row = treeList2.Nodes[i];
TreeListNode row1 = treeList1.Nodes[i];
foreach (TreeListColumn col in treeList1.Columns)
{
if (col.FieldName.IndexOf("y") > -1)
{
object obj = row[col.FieldName];
if (obj != DBNull.Value)
{
Ps_Forecast_Math v = new Ps_Forecast_Math();
v.ForecastID = forecastReport.ID;
v.ID = (string)row["ID"];
v.Title = (i + 1).ToString() + "." + row["Title"].ToString();
v.Sort = Convert.ToInt32(col.FieldName.Replace("y", ""));
v.y1990 = (double)row[col.FieldName]+(double)row1[col.FieldName];
listValues.Add(v);
}
}
}
}
chart1.Series.Clear();
ArrayList al = new ArrayList();
al.Add(Application.StartupPath + "/img/1.ico");
al.Add(Application.StartupPath + "/img/2.ico");
al.Add(Application.StartupPath + "/img/3.ico");
al.Add(Application.StartupPath + "/img/4.ico");
al.Add(Application.StartupPath + "/img/5.ico");
al.Add(Application.StartupPath + "/img/6.ico");
al.Add(Application.StartupPath + "/img/7.ico");
chart1.DataBindCrossTab(listValues, "Title", "Sort", "y1990", "");
for (int i = 0; i < chart1.Series.Count; i++)
{
chart1.Series[i].Color = (Color)hs[i];
chart1.Series[i].Name = chart1.Series[i].Name;
chart1.Series[i].Type = Dundas.Charting.WinControl.SeriesChartType.Line;
chart1.Series[i].MarkerImage = al[i % 7].ToString();
chart1.Series[i].MarkerSize = 7;
chart1.Series[i].MarkerStyle = (Dundas.Charting.WinControl.MarkerStyle)(2);
}
}
private void RefreshChart(int syear, int eyear)
{
IList<FORBaseColor> list = Services.BaseService.GetList<FORBaseColor>("SelectFORBaseColorByWhere", "Remark='" + this.forecastReport.ID.ToString() + "-" + type + "'");
IList<FORBaseColor> li = new List<FORBaseColor>();
bool bl = false;
foreach (DataRow row in dataTable.Rows)
{
bl = false;
foreach (FORBaseColor bc in list)
{
if (row["Title"].ToString() == bc.Title)
{
bl = true;
FORBaseColor bc1 = new FORBaseColor();
bc1.Color1 = Color.Blue;
CopyBaseColor(bc1, bc);
li.Add(bc1);
}
}
if (!bl)
{
FORBaseColor bc1 = new FORBaseColor();
bc1.UID = Guid.NewGuid().ToString();
bc1.Remark = this.forecastReport.ID.ToString() + "-" + type;
bc1.Title = row["Title"].ToString();
bc1.Color = 16711680;
bc1.Color1 = Color.Blue;
Services.BaseService.Create<FORBaseColor>(bc1);
li.Add(bc1);
}
}
ArrayList hs = new ArrayList();
foreach (FORBaseColor bc2 in li)
{
hs.Add(bc2.Color1);
}
List<Ps_Forecast_Math> listValues = new List<Ps_Forecast_Math>();
for (int i = 0; i < this.treeList1.Nodes.Count; i++)
{
TreeListNode row = treeList1.Nodes[i];
foreach (TreeListColumn col in treeList1.Columns)
{
if (col.FieldName.IndexOf("y") > -1)
{
int yyear = int.Parse(col.FieldName.Replace("y", ""));
if (yyear >= syear && yyear <= eyear)
{
object obj = row[col.FieldName];
if (obj != DBNull.Value)
{
Ps_Forecast_Math v = new Ps_Forecast_Math();
v.ForecastID = forecastReport.ID;
v.ID = (string)row["ID"];
v.Title = row["Title"].ToString();
v.Sort = Convert.ToInt32(col.FieldName.Replace("y", ""));
v.y1990 = (double)row[col.FieldName];
listValues.Add(v);
}
}
}
}
}
this.chart_user1.RefreshChart(listValues, "Title", "Sort", "y1990", hs);
}
private void LoadData()
{
treeList1.DataSource = null;
bLoadingData = true;
if (dataTable != null)
{
dataTable.Columns.Clear();
this.treeList1.Columns.Clear();
//treeList1.Columns.Clear();
}
//((System.ComponentModel.ISupportInitialize)(this.treeList1)).BeginInit();
AddFixColumn();
for (int i = forecastReport.StartYear; i <= forecastReport.EndYear; i++)
{
AddColumn(i);
}
//((System.ComponentModel.ISupportInitialize)(this.treeList1)).EndInit();
Ps_Forecast_Math psp_Type = new Ps_Forecast_Math();
psp_Type.ForecastID = forecastReport.ID;
psp_Type.Forecast = 0;
IList listTypes = Common.Services.BaseService.GetList("SelectPs_Forecast_MathByForecastIDAndForecast", psp_Type);
dataTable = Itop.Common.DataConverter.ToDataTable(listTypes, typeof(Ps_Forecast_Math));
this.treeList1.DataSource = dataTable;
Application.DoEvents();
bLoadingData = false;
InitMenu();
}
private void Save()
{
//����
foreach (DataRow dataRow in dataTable.Rows)
{
TreeListNode row = treeList1.FindNodeByKeyID(dataRow["ID"]);
//for (int i = 0; i < this.treeList1.Nodes.Count; i++)
//{
// TreeListNode row = this.treeList1.Nodes[i];
Ps_Forecast_Math v = new Ps_Forecast_Math();
v.ID = row["ID"].ToString();
foreach (TreeListColumn col in this.treeList1.Columns)
{
if (col.FieldName.IndexOf("y") > -1)
{
object obj = row[col.FieldName];
if (obj != DBNull.Value)
{
v.GetType().GetProperty(col.FieldName).SetValue(v, obj, null);
}
}
}
v.Col4 = "yes";
try
{
Services.BaseService.Update("UpdatePs_Forecast_MathByID", v);
}
catch { }
}
MsgBox.Show("����ɹ���");
}
private void treeList1_CellValueChanged(object sender, DevExpress.XtraTreeList.CellValueChangedEventArgs e)
{
TreeListNode row = this.treeList1.FocusedNode;
if (row == null)
return;
Ps_Forecast_Math pf = new Ps_Forecast_Math();
ForecastClass1.TreeNodeToDataObject<Ps_Forecast_Math>(pf,row);
Services.BaseService.Update<Ps_Forecast_Math>(pf);
CalculateSum2(row);
//aaa(row);
RefreshChart();
}
private void barButtonItem14_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
FormForecastLoadData2 ffs = new FormForecastLoadData2();
ffs.PID = MIS.ProgUID;
ffs.StartYear = forecastReport.StartYear;
ffs.EndYear = forecastReport.EndYear;
if (ffs.ShowDialog() != DialogResult.OK)
return;
Hashtable hs = ffs.HS;
if (hs.Count == 0)
return;
string id = Guid.NewGuid().ToString();
foreach (Ps_History de3 in hs.Values)
{
if (OldHt.ContainsKey(de3.Title))
{
Ps_Forecast_Math py = Common.Services.BaseService.GetOneByKey<Ps_Forecast_Math>(OldHt[de3.Title]);
for (int i = forecastReport.StartYear; i <= forecastReport.EndYear; i++)
{
commonhelp.ResetValue(py.ID, "y" + i);
py.GetType().GetProperty("y" + i).SetValue(py, de3.GetType().GetProperty("y" + i).GetValue(de3, null), null);
}
Services.BaseService.Update<Ps_Forecast_Math>(py);
}
else
{
Ps_Forecast_Math ForecastMath = new Ps_Forecast_Math();
ForecastMath.Title = de3.Title;
for (int i = forecastReport.StartYear; i <= forecastReport.EndYear; i++)
{
ForecastMath.GetType().GetProperty("y" + i).SetValue(ForecastMath, de3.GetType().GetProperty("y" + i).GetValue(de3, null), null);
}
id = id.Substring(0, 8);
ForecastMath.Col1 = de3.ID;
ForecastMath.ID = id + "|" + de3.ID;
if (de3.ParentID == "")
{
ForecastMath.ParentID = "";
}
else
{
ForecastMath.ParentID = id + "|" + de3.ParentID;
}
ForecastMath.Forecast = type;
ForecastMath.ForecastID = forecastReport.ID;
ForecastMath.Sort = de3.Sort;
Services.BaseService.Create("InsertPs_Forecast_MathbyPs_History", ForecastMath);
}
}
LoadData();
this.chart_user1.All_Select(true);
RefreshChart();
}
private void barButtonItem15_ItemClick_1(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
TreeListNode row = this.treeList1.FocusedNode;
if (row == null)
{
return;
}
FormTypeTitle frm = new FormTypeTitle();
frm.Text = "�����ӷ���";
if (frm.ShowDialog() == DialogResult.OK)
{
Ps_Forecast_Math psp_Type = new Ps_Forecast_Math();
psp_Type.ParentID = row["ID"].ToString();
psp_Type.ID = Guid.NewGuid().ToString();
psp_Type.Forecast = 0;
psp_Type.ForecastID = forecastReport.ID;
psp_Type.Title = frm.TypeTitle;
object obj = Services.BaseService.GetObject("SelectPs_Forecast_MathMaxID", null);
if (obj != null)
psp_Type.Sort = ((int)obj) + 1;
else
psp_Type.Sort = 1;
try
{
Common.Services.BaseService.Create<Ps_Forecast_Math>(psp_Type);
//psp_Type.ID = (int)Common.Services.BaseService.Create("InsertPSP_P_Types", psp_Type);
dataTable.Rows.Add(Itop.Common.DataConverter.ObjectToRow(psp_Type, dataTable.NewRow()));
}
catch (Exception ex)
{
MsgBox.Show("���ӷ�������" + ex.Message);
}
RefreshChart();
}
}
private void barButtonItem5_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
Hashtable temphs = new Hashtable();
Ps_Forecast_Math psp_Type = new Ps_Forecast_Math();
psp_Type.ForecastID = forecastReport.ID;
psp_Type.Forecast = type;
Common.Services.BaseService.Update("DeletePs_Forecast_MathForecastIDAndForecast", psp_Type);
psp_Type.Forecast = 0;
IList listTypes = Common.Services.BaseService.GetList("SelectPs_Forecast_MathByForecastIDAndForecast", psp_Type);
//foreach (Ps_Forecast_Math psp_Typetemp in listTypes)
//{
// temphs.Add(psp_Typetemp.ID, Guid.NewGuid().ToString());
//}
foreach (Ps_Forecast_Math psp_Typetemp in listTypes)
{
string id = psp_Typetemp.ID;
psp_Type = new Ps_Forecast_Math();
psp_Type = psp_Typetemp;
psp_Type.ID = Guid.NewGuid().ToString();
psp_Type.Col1 =id;
psp_Type.Forecast = type;
if (psp_Type.ParentID != "")
{
if (temphs.ContainsKey(psp_Type.ParentID))
{
psp_Type.ParentID = temphs[psp_Type.ParentID].ToString();
}
}
Common.Services.BaseService.Create<Ps_Forecast_Math>(psp_Type);
}
LoadData();
this.chart_user1.All_Select(true);
RefreshChart();
}
private void barButtonItem24_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
TreeListNode row = this.treeList1.FocusedNode;
if (row == null)
{
return;
}
if (row.Nodes.Count > 0)
{
MsgBox.Show("���¼����࣬����ɾ��");
return;
}
string parentid = row["ParentID"].ToString();
if (MsgBox.ShowYesNo("�Ƿ�ɾ������ " + row["Title"].ToString() + "��") == DialogResult.Yes)
{
Ps_Forecast_Math psp_Type = new Ps_Forecast_Math();
ForecastClass1.TreeNodeToDataObject(psp_Type, row);
//psp_Type = Itop.Common.DataConverter.RowToObject<Ps_Forecast_Math>(row);
Ps_Forecast_Math psp_Values = new Ps_Forecast_Math();
psp_Values.ID = psp_Type.ID;
try
{
//DeletePSP_ValuesByType����ɾ�����ݺͷ���
Common.Services.BaseService.Delete<Ps_Forecast_Math>(psp_Values);
FORBaseColor bc1 = new FORBaseColor();
bc1.Remark = forecastReport.ID+ "-" + typeFlag;
bc1.Title = row["Title"].ToString();
Common.Services.BaseService.Update("DeleteFORBaseColorByTitleRemark", bc1);
this.treeList1.Nodes.Remove(row);
}
catch (Exception ex)
{
this.Cursor = Cursors.WaitCursor;
LoadData();
this.Cursor = Cursors.Default;
}
RefreshChart();
}
}
private void checkfixedvalue()
{
ht.Clear();
if (forecastReport.Col1 == "1")
{
ht.Add("ȫ�����ɣ�MW��", 1);
}
else
{
ht.Add("ȫ����õ�������kWh��", 1);
}
Ps_Forecast_Math psp_Type = new Ps_Forecast_Math();
psp_Type.ForecastID = forecastReport.ID;
psp_Type.Forecast = type;
IList listTypes = Common.Services.BaseService.GetList("SelectPs_Forecast_MathByForecastIDAndForecast", psp_Type);
dataTable = Itop.Common.DataConverter.ToDataTable(listTypes, typeof(Ps_Forecast_Math));
commonhelp.CheckHasFixValue(ht, dataTable, forecastReport.ID, type);
}
private void barButtonItem32_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
Ps_Forecast_Math psp_Type = new Ps_Forecast_Math();
psp_Type.ForecastID = forecastReport.ID;
psp_Type.Forecast = 0;
IList listTypes = Common.Services.BaseService.GetList("SelectPs_Forecast_MathByForecastIDAndForecast", psp_Type);
IList<Ps_History> fhcol = new List<Ps_History>();
bool flag = false; //�ж���û�� ����������� ����ƽ���¶�
foreach (Ps_Forecast_Math pm in listTypes)
{
if (pm.Title.Contains("���"))
{
Ps_History ph = new Ps_History();
ph.ID = pm.Col1;
ph = (Ps_History)Services.BaseService.GetObject("SelectPs_HistoryByKey", ph);
if (ph!=null)
{
flag = true;
Ps_History pr = new Ps_History();
pr.ID = ph.ParentID;
pr = (Ps_History)Services.BaseService.GetObject("SelectPs_HistoryByKey", pr);
if (pr!=null)
{
ph.Title = pr.Title + ph.Title;
}
fhcol.Add(ph);
}
}
}
if (!flag)
{
MsgBox.Show("Ԥ�������в����ڸ������ݣ��뵼�����ݺ��ٲ�����");
return;
}
//string con = "Title='��ƽ���¶�' AND Col4='" + ProjectUID + "'AND Forecast='1'";
Ps_History wd = (Ps_History)Services.BaseService.GetObject("SelectPs_HistoryByCondition", "Title like'%��ƽ���¶�%' AND Col4='" + Itop.Client.MIS.ProgUID + "'AND Forecast='1'");
if (wd!=null)
{
fhcol.Add(wd);
}
else
{
MsgBox.Show("�ڵ�����չʵ�������趨��ƽ���¶ȣ�");
return;
}
FormForecastWDXS wdxs = new FormForecastWDXS(fhcol);
wdxs.temk1 = temtk1;
wdxs.temk2 = temtk2;
if (wdxs.ShowDialog()==DialogResult.OK)
{
foreach(Ps_History de3 in wdxs.fucol)
{
temtk1 = wdxs.temk1;
temtk2 = wdxs.temk2;
Ps_Forecast_Math py = new Ps_Forecast_Math();
py.Col1 = de3.ID;
py.Forecast = 0;
py.ForecastID = forecastReport.ID;
py = (Ps_Forecast_Math)Services.BaseService.GetObject("SelectPs_Forecast_MathByCol1", py);
if (py != null)
{
for (int i = forecastReport.StartYear; i <= forecastReport.EndYear; i++)
{
py.GetType().GetProperty("y" + i).SetValue(py, de3.GetType().GetProperty("y" + i).GetValue(de3, null), null);
}
Services.BaseService.Update<Ps_Forecast_Math>(py);
}
}
}
LoadData();
RefreshChart();
}
private void LoadData()
{
checkfixedvalue();
treeList1.DataSource = null;
bLoadingData = true;
if (dataTable != null)
{
dataTable.Columns.Clear();
treeList1.Columns.Clear();
}
AddFixColumn();
for (int i = forecastReport.StartYear; i <= forecastReport.YcEndYear; i++)
{
AddColumn(i);
}
Ps_Forecast_Math psp_Type = new Ps_Forecast_Math();
psp_Type.ForecastID = forecastReport.ID;
psp_Type.Forecast = type;
IList listTypes = Common.Services.BaseService.GetList("SelectPs_Forecast_MathByForecastIDAndForecast", psp_Type);
dataTable = Itop.Common.DataConverter.ToDataTable(listTypes, typeof(Ps_Forecast_Math));
treeList1.DataSource = dataTable;
OldHt.Clear();
foreach (DataRow row in dataTable.Rows)
{
if (!OldHt.ContainsKey(row["Title"].ToString()))
{
OldHt.Add(row["Title"].ToString(), row["ID"].ToString());
}
}
treeList1.Columns["Title"].OptionsColumn.AllowEdit = false;
Application.DoEvents();
bLoadingData = false;
}