private void AddDataToList(DataRow node, IList <PSP_P_Values> list, DataTable dt) { foreach (DataColumn col in dt.Columns) { if (col.ColumnName.IndexOf("年") > 0) { object obj = node[col.ColumnName]; if (obj != DBNull.Value) { if (Convert.ToInt32(col.ColumnName.Replace("年", "")) < forecastReport.StartYear) { continue; } PSP_P_Values v = new PSP_P_Values(); v.Flag2 = Convert.ToInt32(node["Flag2"]); v.TypeID = Convert.ToInt32(node["ID"]); v.Caption = node["Title"].ToString() + "," + v.TypeID; v.Year = Convert.ToInt32(col.ColumnName.Replace("年", "")); v.Value = (double)node[col.ColumnName]; list.Add(v); } } } }
private void InitValues(PSP_Values pv, PSP_P_Values pv1) { pv1.ID = pv.ID; pv1.TypeID = pv.TypeID; pv1.Flag2 = typeFlag2; pv1.Value = pv.Value; pv1.Year = pv.Year; }
//读取数据 private void LoadValues() { PSP_P_Values PSP_P_Values = new PSP_P_Values(); PSP_P_Values.ID = typeFlag2;//用ID字段存放Flag2的值 IList <PSP_P_Values> listValues = Common.Services.BaseService.GetList <PSP_P_Values>("SelectPSP_P_ValuesListByFlag2", PSP_P_Values); foreach (PSP_P_Values value in listValues) { TreeListNode node = treeList1.FindNodeByFieldValue("ID", value.TypeID); if (node != null) { node.SetValue(value.Year + "年", value.Value); } } }
private void barButtonItem1_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { DataRow obj = this.gridView1.GetDataRow(this.gridView1.FocusedRowHandle); if (obj == null) { return; } PSP_P_Values ppv = new PSP_P_Values(); ppv.Flag2 = Convert.ToInt32(obj["ID"]); ppv.TypeID = 80003; li = Services.BaseService.GetList <PSP_P_Values>("SelectPSP_P_ValuesByTypeIDFlag2", ppv); this.DialogResult = DialogResult.OK; }
private bool SaveCellValue(int year, int typeID, double value) { PSP_P_Values psp_values = new PSP_P_Values(); psp_values.TypeID = typeID; psp_values.Value = value; psp_values.Year = year; psp_values.Flag2 = typeFlag2; try { Common.Services.BaseService.Update <PSP_P_Values>(psp_values); } catch (Exception ex) { MsgBox.Show("保存数据出错:" + ex.Message); return(false); } return(true); }
private void barButtonItem5_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (treeList1.FocusedNode == null) { return; } string parentid = treeList1.FocusedNode["ParentID"].ToString(); string flag = treeList1.FocusedNode["flag"].ToString(); if (treeList1.FocusedNode.HasChildren) { MsgBox.Show("此分类下有子分类,请先删除子分类!"); return; } if (!base.DeleteRight) { MsgBox.Show("您没有权限进行此项操作!"); return; } if (MsgBox.ShowYesNo("是否删除分类 " + treeList1.FocusedNode.GetValue("Title") + "?") == DialogResult.Yes) { PSP_P_Types psp_Type = new PSP_P_Types(); Class1.TreeNodeToDataObject <PSP_P_Types>(psp_Type, treeList1.FocusedNode); PSP_P_Values psp_Values = new PSP_P_Values(); psp_Values.TypeID = psp_Type.ID; psp_Values.Flag2 = typeFlag2; try { //DeletePSP_ValuesByType里面删除数据和分类 Common.Services.BaseService.Update("DeletePSP_P_ValuesByType", psp_Values); TreeListNode brotherNode = null; if (treeList1.FocusedNode.ParentNode.Nodes.Count > 1) { brotherNode = treeList1.FocusedNode.PrevNode; if (brotherNode == null) { brotherNode = treeList1.FocusedNode.NextNode; } } treeList1.DeleteNode(treeList1.FocusedNode); //删除后,如果同级还有其它分类,则重新计算此类的所有年份数据 if (brotherNode != null) { foreach (TreeListColumn column in treeList1.Columns) { if (column.FieldName.IndexOf("年") > 0) { CalculateSum(brotherNode, column); } } } } catch (Exception ex) { this.Cursor = Cursors.WaitCursor; treeList1.BeginUpdate(); LoadData(); treeList1.EndUpdate(); this.Cursor = Cursors.Default; } } }
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; }