private void LoadData()
{
if (dataTable != null)
{
dataTable.Columns.Clear();
treeList1.Columns.Clear();
}
bLoadingData = true;
string[,] ia = new string[6, 2];
ia[0, 0] = "80001";
ia[1, 0] = "80002";
ia[2, 0] = "80003";
ia[3, 0] = "80004";
ia[4, 0] = "80005";
ia[5, 0] = "80006";
ia[0, 1] = "ȫ����õ���";
ia[1, 1] = lb+ "�õ���";
ia[2, 1] = "ȫ������";
ia[3, 1] = lb + "���";
ia[4, 1] = "ȫ����������Сʱ";
ia[5, 1] = lb + "�������Сʱ";
for (int i = 0; i < 6;i++ )
{
string str2 = " ID=" + int.Parse(ia[i, 0]) + " and Flag='" + typeFlag + "' and Flag2='" + forecastReport.ID + "' ";
IList listTypes1 = Common.Services.BaseService.GetList("SelectPSP_P_TypesByWhere", str2);
if (listTypes1.Count == 0)
{
PSP_P_Types ppttt = new PSP_P_Types();
ppttt.ID = int.Parse(ia[i, 0]);
ppttt.Flag2 = forecastReport.ID;
ppttt.Flag = typeFlag;
ppttt.Title = ia[i, 1];
Services.BaseService.Create<PSP_P_Types>(ppttt);
}
}
PSP_P_Types psp_Type = new PSP_P_Types();
psp_Type.Flag = typeFlag;
string str = " Flag='" + typeFlag + "' and Flag2='" + forecastReport.ID + "' ";
IList listTypes = Common.Services.BaseService.GetList("SelectPSP_P_TypesByWhere", str);
dataTable = Itop.Common.DataConverter.ToDataTable(listTypes, typeof(PSP_P_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;
string str1 = " flag2=10000 and flag=" + forecastReport.ID;
IList<PSP_P_Years> listyears = Common.Services.BaseService.GetList<PSP_P_Years>("SelectPSP_P_YearsByWhere", str1);
foreach (PSP_P_Years pppy in listyears)
{
AddColumn(pppy.Year);
}
Application.DoEvents();
LoadValues();
treeList1.ExpandAll();
bLoadingData = false;
}
private void GetFFData(int sid,string type,string title)
{
FormXiaoshi_Fs ffs = new FormXiaoshi_Fs();
ffs.Type = type;
ffs.ForecastReports = forecastReport;
if (ffs.ShowDialog() != DialogResult.OK)
return;
Hashtable hs = ffs.HS;
if (hs.Count != 3)
return;
int uid = (int)hs["H1"];
TreeListNode tn = (TreeListNode)hs["H2"];
bool bool1 = (bool)hs["H3"];
PSP_P_Types pt=new PSP_P_Types();
if (bool1)
{
PSP_Types pt1 = Services.BaseService.GetOneByKey<PSP_Types>(uid);
InitTypes(pt1, pt);
}
else
{
pt = Services.BaseService.GetOneByKey<PSP_P_Types>(uid);
}
#region �趨types
string str2 = " ID=" + sid + " and Flag='" + typeFlag + "' and Flag2='" + forecastReport.ID + "' ";
IList listTypes = Common.Services.BaseService.GetList("SelectPSP_P_TypesByWhere", str2);
if (listTypes.Count != 0)
{
PSP_P_Values ppvvv = new PSP_P_Values();
ppvvv.TypeID = sid;
ppvvv.Flag2 = forecastReport.ID;
Services.BaseService.Update("DeletePSP_P_ValuesByType", ppvvv);
}
pt.ID = sid;
pt.Flag2 = forecastReport.ID;
pt.Flag = typeFlag;
pt.Title = title;
Services.BaseService.Create<PSP_P_Types>(pt);
#endregion
#region �趨year value
Hashtable hta = new Hashtable();
ArrayList al = new ArrayList();
foreach (TreeListColumn tlc in tn.TreeList.Columns)
{
if (tlc.FieldName.IndexOf("��") >= 0)
{
int year = 0;
try
{
year=int.Parse(tlc.FieldName.Replace("��", ""));
}
catch { }
if (year != 0 && year > forecastReport.EndYear)
continue;
hta.Add(Guid.NewGuid().ToString(), year);
try
{
PSP_P_Values pv = new PSP_P_Values();
pv.Year=year;
pv.TypeID=sid;
try
{
pv.Value = double.Parse(tn[tlc.FieldName].ToString());
}
catch { }
pv.Flag2 = forecastReport.ID;
Services.BaseService.Create<PSP_P_Values>(pv);
}
catch { }
try
{
PSP_P_Years ppy = new PSP_P_Years();
ppy.Flag = forecastReport.ID;
ppy.Flag2 = typeFlag;
ppy.Year = year;
Services.BaseService.Create<PSP_P_Years>(ppy);
}
catch (Exception ex)
{
//MessageBox.Show(ex.Message);
}
}
}
for (int m = forecastReport.StartYear; m <= forecastReport.EndYear; m++)
{
if (!hta.ContainsValue(m))
{
try
{
PSP_P_Years ppy = new PSP_P_Years();
ppy.Flag = forecastReport.ID;
ppy.Flag2 = typeFlag;
ppy.Year = m;
Services.BaseService.Create<PSP_P_Years>(ppy);
}
catch (Exception ex)
{ //MessageBox.Show(ex.Message);
}
}
}
#endregion
Application.DoEvents();
this.Cursor = Cursors.WaitCursor;
treeList1.BeginUpdate();
LoadData();
treeList1.EndUpdate();
this.Cursor = Cursors.Default;
Compute();
RefreshChart();
}
private void LoadData()
{
bLoadingData = true;
if (dataTable != null)
{
dataTable.Columns.Clear();
treeList1.Columns.Clear();
}
PSP_P_Types psp_Type = new PSP_P_Types();
psp_Type.Flag2 = forecastReport.ID;
IList listTypes = Common.Services.BaseService.GetList("SelectPSP_P_TypesByFlag2", psp_Type);
dataTable = Itop.Common.DataConverter.ToDataTable(listTypes, typeof(PSP_P_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;
for (int i = forecastReport.StartYear; i <= forecastReport.EndYear; i++)
{
AddColumn(i);
}
Application.DoEvents();
LoadValues();
LoadHistoryValue();
treeList1.ExpandAll();
bLoadingData = false;
}
private void InitTypes(PSP_Types pv, PSP_P_Types pv1)
{
pv1.ID = pv.ID;
pv1.Flag = pv.Flag;
pv1.Flag2 = typeFlag2;
pv1.ParentID = pv.ParentID;
pv1.Title = pv.Title;
}
private void LoadData()
{
if (dataTable != null)
{
dataTable.Columns.Clear();
treeList1.Columns.Clear();
}
//PSP_P_Types psp_Type = new PSP_P_Types();
//psp_Type.Flag2 = typeFlag2;
//IList listTypes = Common.Services.BaseService.GetList("SelectPSP_P_TypesByFlag2", psp_Type);
//dataTable = Itop.Common.DataConverter.ToDataTable(listTypes, typeof(PSP_P_Types));
//////string str = " Flag!='" + typeFlag + "' and Flag2='" + typeFlag2+ "' ";
//////IList listTypes = Common.Services.BaseService.GetList("SelectPSP_P_TypesByWhere", str);
//////dataTable = Itop.Common.DataConverter.ToDataTable(listTypes, typeof(PSP_P_Types));
PSP_P_Types psp_Type = new PSP_P_Types();
psp_Type.Flag2 = typeFlag2;
IList listTypes = Common.Services.BaseService.GetList("SelectPSP_P_TypesByFlag2", psp_Type);
dataTable = Itop.Common.DataConverter.ToDataTable(listTypes, typeof(PSP_P_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_ForecastReports pf = Services.BaseService.GetOneByKey<PSP_ForecastReports>(typeFlag2);
//string str1 = " flag=" + typeFlag2;
//IList<PSP_P_Years> listyears = Common.Services.BaseService.GetList<PSP_P_Years>("SelectPSP_P_YearsByWhere", str1);
//foreach (PSP_P_Years pppy in listyears)
//{
// if (pppy.Year <= pf.EndYear)
// {
// AddColumn(pppy.Year);
// }
//}
for (int i = pf.StartYear; i <= pf.EndYear; i++)
{
AddColumn(i);
}
Application.DoEvents();
try
{
LoadValues();
}
catch { }
treeList1.ExpandAll();
}
private void UpdateData(PSP_Types pt, PSP_P_Types pt1)
{
pt1.Flag = pt.Flag;
pt1.Flag2 = pt.Flag2;
pt1.ID = pt.ID;
pt1.ParentID = pt.ParentID;
pt1.Title = pt.Title;
}
private void Get1(PSP_P_Types pt, IList<PSP_P_Types> li, Hashtable hs)
{
IList<PSP_P_Types> li1 = Services.BaseService.GetList<PSP_P_Types>("SelectPSP_P_TypesByParentID", pt);
foreach (PSP_P_Types pt1 in li1)
{
if (hs.ContainsValue(pt1))
continue;
hs.Add(Guid.NewGuid().ToString(), pt1);
//li.Add(pt1);
Get1(pt1, li, hs);
}
}
private void LoadData()
{
if (dataTable != null)
{
dataTable.Columns.Clear();
treeList1.Columns.Clear();
}
PSP_P_Types psp_Type = new PSP_P_Types();
psp_Type.Flag2 = typeFlag2;
IList listTypes = Common.Services.BaseService.GetList("SelectPSP_P_TypesByFlag2", psp_Type);
dataTable = Itop.Common.DataConverter.ToDataTable(listTypes, typeof(PSP_P_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_P_Years psp_Year = new PSP_P_Years();
psp_Year.Flag = typeFlag2;
IList<PSP_P_Years> listYears = Common.Services.BaseService.GetList<PSP_P_Years>("SelectPSP_P_YearsListByFlag", psp_Year);
foreach (PSP_P_Years item in listYears)
{
try
{
AddColumn(item.Year);
}
catch { }
}
Application.DoEvents();
try
{
LoadValues();
}
catch { }
treeList1.ExpandAll();
}
private void barButtonItem2_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
TreeListMultiSelection tm = treeList1.Selection;
if (tm.Count == 0)
return;
// TreeListNode tln = treeList1.FocusedNode;
//if (tln == null)
// return;
DataRow dr = this.gridView1.GetDataRow(this.gridView1.FocusedRowHandle);
if (dr == null)
return;
int id1 = (int)dr["ID"];
fl2 = id1;
hs.Clear();
li.Clear();
foreach (TreeListNode tln in tm)
{
PSP_P_Types pt1 = new PSP_P_Types();
if (id1 == 999999 || id1==888888)
{
IsJingJi = true;
PSP_Types pt = Services.BaseService.GetOneByKey<PSP_Types>((int)tln["ID"]);
if (!hs.ContainsValue(pt))
hs.Add(Guid.NewGuid().ToString(), pt);
//UpdateData(pt, pt1);
//li.Add(pt1);
////////Get(pt, li, hs);
}
else
{
pt1 = Services.BaseService.GetOneByKey<PSP_P_Types>((int)tln["ID"]);
if (!hs.ContainsValue(pt1))
hs.Add(Guid.NewGuid().ToString(), pt1);
//li.Add(pt1);
////////////Get1(pt1, li, hs);
}
}
if (hs.Count > 0)
this.DialogResult = DialogResult.OK;
}
private void LoadData()
{
if (dataTable != null)
{
dataTable.Columns.Clear();
treeList1.Columns.Clear();
}
PSP_P_Types psp_Type = new PSP_P_Types();
psp_Type.Flag2 = forecastReport.ID;
IList listTypes = Common.Services.BaseService.GetList("SelectPSP_P_TypesByFlag2", psp_Type);
dataTable = Itop.Common.DataConverter.ToDataTable(listTypes, typeof(PSP_P_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;
for (int i = forecastReport.StartYear + 1; i <= forecastReport.EndYear; i++)
{
AddColumn(i);
}
foreach (TreeListNode nd in treeList1.Nodes)
{
SetDefaultValues(nd);
}
treeList1.ExpandAll();
}
private void LoadData()
{
if (dataTable != null)
{
dataTable.Columns.Clear();
treeList1.Columns.Clear();
}
PSP_P_Types psp_Type = new PSP_P_Types();
IList listTypes =null;
if (!formselect)
{
psp_Type.Flag2 = forecastReport.ID;
listTypes = Common.Services.BaseService.GetList("SelectPSP_P_TypesByFlag2", psp_Type);
dataTable = Itop.Common.DataConverter.ToDataTable(listTypes, typeof(PSP_P_Types));
treeList1.DataSource = dataTable;
}
else
{
string str = " Flag='" + typeFlag + "' and Flag2='" + forecastReport.ID + "' " + " and ID in(80001,80002,80003) ";
listTypes = Common.Services.BaseService.GetList("SelectPSP_P_TypesByWhere", str);
dataTable = Itop.Common.DataConverter.ToDataTable(listTypes, typeof(PSP_P_Types));
//DataView datemp = dataTable.DefaultView;
//datemp.RowFilter = "ID in(80001,80002,80003,80004)";
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_PowerProject_ProfessValues psp_profess = new PSP_PowerProject_ProfessValues();
for (int i = forecastReport.StartYear + 1; i <= forecastReport.EndYear; i++)
{
AddColumn(i);
foreach (PSP_P_Types psp_Typetemp in listTypes)
{
psp_profess.TypeID = psp_Typetemp.ID;
psp_profess.Value=0.1;
psp_profess.Year = i;
psp_profess.Flag2 = psp_Typetemp.Flag2;
try
{
Common.Services.BaseService.Update("CreatPSP_PowerProject_ProfessValues", psp_profess);
}
catch (Exception ex)
{
MsgBox.Show("加载数据出错：" + ex.Message);
}
}
}
//foreach (TreeListNode nd in treeList1.Nodes)
//{
// SetDefaultValues(nd);
//}
LoadValueData();
treeList1.ExpandAll();
}
