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 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 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 barButtonItem3_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
TreeListNode focusedNode = treeList1.FocusedNode;
if (focusedNode == null)
{
return;
}
if (!base.AddRight)
{
MsgBox.Show("您没有权限进行此项操作！");
return;
}
FormTypeTitle frm = new FormTypeTitle();
frm.Text = "增加" + focusedNode.GetValue("Title") + "的子分类";
if (frm.ShowDialog() == DialogResult.OK)
{
PSP_P_Types psp_Type = new PSP_P_Types();
object obj = Services.BaseService.GetObject("SelectPSP_P_TypesMaxID", null);
if (obj != null)
{
psp_Type.ID = ((int)obj) + 1;
}
else
{
psp_Type.ID = 1;
}
psp_Type.Title = frm.TypeTitle;
psp_Type.Flag = (int)focusedNode.GetValue("Flag");
psp_Type.Flag2 = (int)focusedNode.GetValue("Flag2");
psp_Type.ParentID = (int)focusedNode.GetValue("ID");
try
{
Services.BaseService.Create("InsertPSP_P_Types", psp_Type);
//psp_Type.ID = (int)Common.Services.BaseService.Create("InsertPSP_P_Types", psp_Type);
dataTable.Rows.Add(Itop.Common.DataConverter.ObjectToRow(psp_Type, dataTable.NewRow()));
}
catch (Exception ex)
{
MsgBox.Show("增加子分类出错：" + ex.Message);
}
}
}
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 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 barButtonItem4_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 (!base.EditRight)
{
MsgBox.Show("您没有权限进行此项操作！");
return;
}
FormTypeTitle frm = new FormTypeTitle();
frm.TypeTitle = treeList1.FocusedNode.GetValue("Title").ToString();
frm.Text = "修改分类名";
if (frm.ShowDialog() == DialogResult.OK)
{
PSP_P_Types psp_Type = new PSP_P_Types();
Class1.TreeNodeToDataObject <PSP_P_Types>(psp_Type, treeList1.FocusedNode);
psp_Type.Title = frm.TypeTitle;
try
{
Common.Services.BaseService.Update <PSP_P_Types>(psp_Type);
treeList1.FocusedNode.SetValue("Title", frm.TypeTitle);
}
catch (Exception ex)
{
MsgBox.Show("修改出错：" + ex.Message);
}
}
}
private void LoadData2()
{
//bLoadingData = true;
if (dataTable2 != null)
{
dataTable2.Columns.Clear();
treeList2.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);
dataTable2 = Itop.Common.DataConverter.ToDataTable(listTypes, typeof(PSP_P_Types));
treeList2.DataSource = dataTable2;
treeList2.Columns["Title"].Caption = "分类名";
treeList2.Columns["Title"].Width = 180;
treeList2.Columns["Title"].OptionsColumn.AllowEdit = false;
treeList2.Columns["Title"].OptionsColumn.AllowSort = false;
treeList2.Columns["Flag"].VisibleIndex = -1;
treeList2.Columns["Flag"].OptionsColumn.ShowInCustomizationForm = false;
treeList2.Columns["Flag2"].VisibleIndex = -1;
treeList2.Columns["Flag2"].OptionsColumn.ShowInCustomizationForm = false;
for (int i = forecastReport.StartYear; i <= forecastReport.EndYear; i++)
{
AddColumn2(i);
}
Application.DoEvents();
LoadValues();
LoadHistoryValue();
treeList2.ExpandAll();
//bLoadingData = false;
}
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 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;
}
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 barButtonItem2_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
//if (!base.AddRight)
//{
// MsgBox.Show("您没有权限进行此项操作！");
// return;
//}
TreeListNode focusedNode = treeList1.FocusedNode;
if (focusedNode == null)
{
return;
}
FormTypeTitle frm = new FormTypeTitle();
frm.Text = "增加分类";
if (frm.ShowDialog() == DialogResult.OK)
{
PSP_P_Types psp_Type = new PSP_P_Types();
object obj = Services.BaseService.GetObject("SelectPSP_P_TypesMaxID", null);
if (obj != null)
{
psp_Type.ID = ((int)obj) + 1;
}
else
{
psp_Type.ID = 1;
}
psp_Type.Title = frm.TypeTitle;
int flag = psp_Type.ID + 1;
if (focusedNode != null)
{
flag = (int)focusedNode.GetValue("Flag");
}
psp_Type.Flag = flag;
psp_Type.Flag2 = typeFlag2;
psp_Type.ParentID = 0;
try
{
Common.Services.BaseService.Create("InsertPSP_P_Types", psp_Type);
//psp_Type.ID = (int)Common.Services.BaseService.Create("InsertPSP_P_Types", psp_Type);
dataTable.Rows.Add(Itop.Common.DataConverter.ObjectToRow(psp_Type, dataTable.NewRow()));
this.Cursor = Cursors.WaitCursor;
treeList1.BeginUpdate();
LoadData();
treeList1.EndUpdate();
this.Cursor = Cursors.Default;
}
catch (Exception ex)
{
MsgBox.Show("增加分类出错：" + ex.Message);
}
}
}
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();
}
