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 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 InitYears(PSP_Years pv, PSP_P_Years pv1) { pv1.ID = pv.ID; pv1.Flag = typeFlag2; pv1.Year = pv.Year; }
//��ȡ��ʷ���� private void LoadHistoryValue() { PSP_P_Years psp_Year = new PSP_P_Years(); psp_Year.Flag = forecastReport.ID; IList<PSP_P_Years> listYears = Common.Services.BaseService.GetList<PSP_P_Years>("SelectPSP_P_YearsListByFlag", psp_Year); foreach (PSP_P_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; } 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 = treeList1.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 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 LoadHistoryValue() { PSP_P_Years psp_Year = new PSP_P_Years(); psp_Year.Flag = forecastReport.ID; IList<PSP_P_Years> listYears = Common.Services.BaseService.GetList<PSP_P_Years>("SelectPSP_P_YearsListByFlag", psp_Year); //Hashtable hs = new Hashtable(); //foreach (TreeListColumn tlc in treeList1.Columns) //{ // if (!hs.ContainsKey(tlc.FieldName)) // hs.Add(tlc.FieldName, ""); //} Hashtable ht = new Hashtable(); foreach (PSP_P_Years item in listYears) { //if (hs.ContainsKey(item.Year + "Y")) // continue; 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(); 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 = 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); } } } }