private void barButtonItem5_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (treeList1.FocusedNode == null)
{
return;
}
if (!base.DeleteRight)
{
MsgBox.Show("您没有权限进行此项操作！");
return;
}
if (MsgBox.ShowYesNo("是否删除 " + treeList1.FocusedNode["Year"] + " 及该年的所有数据？") != DialogResult.Yes)
{
return;
}
PSP_CapBalance psp_value = new PSP_CapBalance();
psp_value.Year = (int)treeList1.FocusedNode["Year"];
psp_value.Flag = flag;
try
{
//DeletePSP_ValuesByYear删除数据和年份
Common.Services.BaseService.Update("DeletePSP_CapBalanceByYear", psp_value);
treeList1.Nodes.Remove(treeList1.FocusedNode.RootNode);
}
catch (Exception ex)
{
MsgBox.Show("删除出错：" + ex.Message);
}
}
//读取数据
private void LoadValues()
{
PSP_CapBalance psp_Values = new PSP_CapBalance();
psp_Values.Flag = flag;
IList <PSP_CapBalance> listValues = Common.Services.BaseService.GetList <PSP_CapBalance>("SelectPSP_CapBalanceByFlag", psp_Values);
foreach (PSP_CapBalance value in listValues)
{
//
if (treeList1.FindNodeByFieldValue("Year", value.Year) == null)
{
foreach (DataRow dr in dtRegion.Rows)
{
DataRow newRow = dataTable.NewRow();
newRow["ID"] = value.Year.ToString() + dr["ID"];
newRow["ParentID"] = value.Year.ToString() + dr["ParentID"];
newRow["Year"] = value.Year;
newRow["TypeID"] = dr["ID"];
newRow["Flag"] = dr["Flag"];
if ((int)dr["ParentID"] == 0)
{
newRow["Title"] = value.Year + "年" + dr["Title"];
}
else
{
newRow["Title"] = dr["Title"];
}
dataTable.Rows.Add(newRow);
}
}
}
foreach (PSP_CapBalance value in listValues)
{
TreeListNode node = treeList1.FindNodeByKeyID(value.Year.ToString() + value.TypeID);
node.SetValue("Col1", value.Col1);
node["Col2"] = value.Col2;
node["Col3"] = value.Col3;
node["Col4"] = value.Col4;
node["Col5"] = value.Col5;
node["Col6"] = value.Col6;
node["Col7"] = value.Col7;
}
}
private bool SaveNodeValue(TreeListNode node)
{
PSP_CapBalance psp_value = new PSP_CapBalance();
TreeNodeToDataObject <PSP_CapBalance>(psp_value, node);
psp_value.Flag = flag;
psp_value.TypeID = (int)node["TypeID"];
psp_value.Year = (int)node["Year"];
try
{
Common.Services.BaseService.Update <PSP_CapBalance>(psp_value);
}
catch
{
return(false);
}
return(true);
}
//删除地区
private void barButtonItem3_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (treeList1.FocusedNode == null)
{
return;
}
if (!base.DeleteRight)
{
MsgBox.Show("您没有权限进行此项操作！");
return;
}
if (treeList1.FocusedNode.ParentNode == null)
{
MsgBox.Show("一级地区为固定内容，不能删除！");
return;
}
if (treeList1.FocusedNode.HasChildren)
{
MsgBox.Show("此地区还有下级地区，请先删除下级地区！");
return;
}
if (MsgBox.ShowYesNo("是否删除 " + treeList1.FocusedNode.GetValue("Title") + " 及此地区的所有数据？") == DialogResult.Yes)
{
PSP_CapBalance psp_value = new PSP_CapBalance();
psp_value.TypeID = (int)treeList1.FocusedNode["TypeID"];
psp_value.Flag = flag;
try
{
//DeletePSP_CapBalanceByTypeID里面删除数据和分类
Common.Services.BaseService.Update("DeletePSP_CapBalanceByTypeID", psp_value);
treeList1.BeginUpdate();
Cursor = Cursors.WaitCursor;
//删除时，从后面开始删除
for (int i = treeList1.Nodes.Count - 1; i > -1; i--)
{
DeleteNode(treeList1.Nodes[i], psp_value.TypeID);
}
foreach (DataRow dr in dtRegion.Rows)
{
if ((int)dr["ID"] == psp_value.TypeID)
{
dtRegion.Rows.Remove(dr);
break;
}
}
treeList1.EndUpdate();
Cursor = Cursors.Default;
}
catch (Exception ex)
{
MsgBox.Show("删除出错：" + ex.Message);
}
}
}
