//读取历史数据 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; }