//读取历史数据
private void LoadHistoryValue()
{
IList <PSP_P_Years> listYears;
if (!formselect)
{
PSP_P_Years psp_Year = new PSP_P_Years();
psp_Year.Flag = forecastReport.ID;
listYears = Common.Services.BaseService.GetList <PSP_P_Years>("SelectPSP_P_YearsListByFlag", psp_Year);
}
else
{
PSP_P_Years psp_Year = new PSP_P_Years();
psp_Year.Flag = forecastReport.ID;
psp_Year.Flag2 = typeFlag;
listYears = Common.Services.BaseService.GetList <PSP_P_Years>("SelectPSP_P_YearsListhaveflag2ByFlag", psp_Year);
}
foreach (PSP_P_Years item in listYears)
{
try
{
dataTable2.Columns.Add(item.Year + "Y", typeof(double));
TreeListColumn column = treeList2.Columns.Add();
column.FieldName = item.Year + "Y";
column.Tag = item.Year;
column.VisibleIndex = -1;
}
catch { }
}
PSP_Values psp_Values = new PSP_Values();
psp_Values.ID = forecastReport.ID; //用ID字段存放Flag2的值
IList <PSP_P_Values> listValues = Common.Services.BaseService.GetList <PSP_P_Values>("SelectPSP_P_ValuesListByFlag2", psp_Values);
foreach (PSP_P_Values value in listValues)
{
TreeListNode node = treeList2.FindNodeByFieldValue("ID", value.TypeID);
if (node != null)
{
node.SetValue(value.Year + "Y", value.Value);
if (value.Year == forecastReport.StartYear)
{
node.SetValue(value.Year + "年", value.Value);
}
}
}
}
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 simpleButton1_Click(object sender, EventArgs e)
{
PSP_P_Years psp_Year = new PSP_P_Years();
psp_Year.Flag = flag2;
psp_Year.Flag2 = 10000;
yearValue = psp_Year.Year = (int)spinEdit1.Value;
if (_getYearOnly)
{
this.DialogResult = DialogResult.OK;
return;
}
try
{
if (Common.Services.BaseService.GetObject("SelectPSP_P_YearsByYearFlag", psp_Year) == null)
{
try
{
Common.Services.BaseService.Create <PSP_P_Years>(psp_Year);
this.DialogResult = DialogResult.OK;
}
catch (Exception ex)
{
MsgBox.Show("出错啦：" + ex.Message);
}
}
else
{
MsgBox.Show("此年份已经存在，请重新输入！");
}
}
catch (Exception ex)
{
MsgBox.Show("出错啦：" + ex.Message);
}
}
private void InitYears(PSP_Years pv, PSP_P_Years pv1)
{
pv1.ID = pv.ID;
pv1.Flag = typeFlag2;
pv1.Year = pv.Year;
}
private void barButtonItem1_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
PSP_ForecastReports ct = (PSP_ForecastReports)this.ctrlPSP_ForecastReports1.GridView.GetRow(this.ctrlPSP_ForecastReports1.GridView.FocusedRowHandle);
if (ct == null)
{
return;
}
typeFlag2 = ct.ID;
Form1_Fs ffs = new Form1_Fs();
ffs.Type = type;
if (ffs.ShowDialog() != DialogResult.OK)
{
return;
}
int fl2 = ffs.FL2;
bool bl = ffs.IsJingJi;
Hashtable hs = ffs.HS;
if (hs.Count == 0)
{
return;
}
if (bl)
{
fl2 = 1;
PSP_Years py = new PSP_Years();
py.Flag = fl2;
IList <PSP_Years> listyear = Services.BaseService.GetList <PSP_Years>("SelectPSP_YearsListByFlag", py);
Hashtable hsa = new Hashtable();
foreach (DictionaryEntry de3 in hs)
{
PSP_Types pt = (PSP_Types)de3.Value;
PSP_P_Types ppta = new PSP_P_Types();
ppta.ID = pt.ID;
ppta.Flag2 = typeFlag2;
IList <PSP_P_Types> listppt = Services.BaseService.GetList <PSP_P_Types>("SelectPSP_P_TypesByFlag2ID", ppta);
if (listppt.Count > 0)
{
continue;
}
PSP_P_Types ppt = new PSP_P_Types();
InitTypes(pt, ppt);
Services.BaseService.Create <PSP_P_Types>(ppt);
hsa.Add(Guid.NewGuid().ToString(), "");
PSP_Values pv = new PSP_Values();
pv.TypeID = pt.ID;
IList <PSP_Values> listppt1 = Services.BaseService.GetList <PSP_Values>("SelectPSP_ValuesList", pv);
Hashtable httss = new Hashtable();
foreach (PSP_Values pv1 in listppt1)
{
PSP_P_Values ppv = new PSP_P_Values();
InitValues(pv1, ppv);
try
{
Services.BaseService.Create <PSP_P_Values>(ppv);
}
catch { }
}
}
if (hsa.Count > 0)
{
foreach (PSP_Years py1 in listyear)
{
PSP_P_Years ppy = new PSP_P_Years();
InitYears(py1, ppy);
try
{
Services.BaseService.Create <PSP_P_Years>(ppy);
}
catch { }
}
}
}
else
{
PSP_P_Years py = new PSP_P_Years();
py.Flag = fl2;
IList <PSP_P_Years> listyear = Services.BaseService.GetList <PSP_P_Years>("SelectPSP_P_YearsListByFlag", py);
Hashtable hsa = new Hashtable();
foreach (DictionaryEntry de3 in hs)
{
PSP_P_Types pt = (PSP_P_Types)de3.Value;
pt.Flag2 = typeFlag2;
IList <PSP_P_Types> listppt = Services.BaseService.GetList <PSP_P_Types>("SelectPSP_P_TypesByFlag2ID", pt);
if (listppt.Count > 0)
{
continue;
}
Services.BaseService.Create <PSP_P_Types>(pt);
hsa.Add(Guid.NewGuid().ToString(), "");
PSP_P_Values pv = new PSP_P_Values();
pv.TypeID = pt.ID;
IList <PSP_P_Values> listppt1 = Services.BaseService.GetList <PSP_P_Values>("SelectPSP_P_ValuesList", pv);
foreach (PSP_P_Values pv1 in listppt1)
{
try
{
pv1.Flag2 = typeFlag2;
Services.BaseService.Create <PSP_P_Values>(pv1);
}
catch { }
}
}
if (hsa.Count > 0)
{
foreach (PSP_P_Years py1 in listyear)
{
try
{
py1.Flag = typeFlag2;
Services.BaseService.Create <PSP_P_Years>(py1);
}
catch { }
}
}
}
Application.DoEvents();
this.Cursor = Cursors.WaitCursor;
treeList1.BeginUpdate();
LoadData();
treeList1.EndUpdate();
this.Cursor = Cursors.Default;
}
