private void barButtonItem13_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (treeList1.FocusedNode == null)
{
return;
}
//if (treeList1.FocusedNode.ParentNode == null)
//{
// MsgBox.Show("一级分类名称不能修改！");
// return;
//}
FormTypeTitle frm = new FormTypeTitle();
frm.TypeTitle = treeList1.FocusedNode.GetValue("Title").ToString();
frm.Text = "修改项目名";
if (frm.ShowDialog() == DialogResult.OK)
{
try
{
PowerStuffTypes psp_Type = Services.BaseService.GetOneByKey <PowerStuffTypes>(treeList1.FocusedNode["ID"].ToString());
psp_Type.Title = frm.TypeTitle;
Common.Services.BaseService.Update <PowerStuffTypes>(psp_Type);
treeList1.FocusedNode.SetValue("Title", frm.TypeTitle);
}
catch (Exception ex)
{
MsgBox.Show("修改出错：" + ex.Message);
}
}
}
private void barButtonItem11_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
FormTypeTitle frm = new FormTypeTitle();
frm.Text = "增加项目";
if (frm.ShowDialog() == DialogResult.OK)
{
PowerStuffTypes psp_Type = new PowerStuffTypes();
psp_Type.Title = frm.TypeTitle;
psp_Type.Flag = 0;
psp_Type.Flag2 = typeFlag2;
psp_Type.ParentID = 0;
try
{
psp_Type.ID = (int)Common.Services.BaseService.Create("InsertPowerStuffTypes", psp_Type);
dataTable.Rows.Add(Itop.Common.DataConverter.ObjectToRow(psp_Type, dataTable.NewRow()));
}
catch (Exception ex)
{
MsgBox.Show("增加项目出错：" + ex.Message);
}
}
}
private void barButtonItem12_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
TreeListNode focusedNode = treeList1.FocusedNode;
if (focusedNode == null)
{
return;
}
FormTypeTitle frm = new FormTypeTitle();
frm.Text = "增加" + focusedNode.GetValue("Title") + "的子项目";
if (frm.ShowDialog() == DialogResult.OK)
{
PowerStuffTypes psp_Type = new PowerStuffTypes();
psp_Type.Title = frm.TypeTitle;
psp_Type.Flag = (int)focusedNode.GetValue("Flag");
psp_Type.Flag2 = (string)focusedNode.GetValue("Flag2");
psp_Type.ParentID = (int)focusedNode.GetValue("ID");
try
{
psp_Type.ID = (int)Common.Services.BaseService.Create("InsertPowerStuffTypes", psp_Type);
dataTable.Rows.Add(Itop.Common.DataConverter.ObjectToRow(psp_Type, dataTable.NewRow()));
}
catch (Exception ex)
{
MsgBox.Show("增加子项目出错：" + ex.Message);
}
}
}
//加载设备情况表列字段
private void LoadData()
{
try
{
if (dataTable != null)
{
dataTable.Columns.Clear();
treeList1.Columns.Clear();
}
PowerStuffTypes psp_Type = new PowerStuffTypes();
psp_Type.Flag2 = typeFlag2;
IList listTypes = new ArrayList();
try
{
listTypes = Common.Services.BaseService.GetList("SelectPowerStuffTypesByFlag2", psp_Type);
}
catch (Exception ex)
{ MsgBox.Show(ex.Message); }
dataTable = Itop.Common.DataConverter.ToDataTable(listTypes, typeof(PowerStuffTypes));
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;
PowerStuffYears psp_Year = new PowerStuffYears();
psp_Year.Flag = typeFlag2;
IList <PowerStuffYears> listYears = Common.Services.BaseService.GetList <PowerStuffYears>("SelectPowerStuffYearsListByFlag", psp_Year);
foreach (PowerStuffYears item in listYears)
{
AddColumn(item.Year);
}
AddColumn1();
Application.DoEvents();
LoadValues();
treeList1.ExpandAll();
}
catch
{
}
}
private void barButtonItem14_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (treeList1.FocusedNode == null)
{
return;
}
if (treeList1.FocusedNode.HasChildren)
{
MsgBox.Show("此项目下有子项目，请先删除子项目！");
return;
}
if (MsgBox.ShowYesNo("是否删除项目 " + treeList1.FocusedNode.GetValue("Title") + "？") == DialogResult.Yes)
{
PowerStuffTypes psp_Type = Services.BaseService.GetOneByKey <PowerStuffTypes>(treeList1.FocusedNode["ID"].ToString());
PowerStuffValues PowerValues = new PowerStuffValues();
PowerValues.TypeID = psp_Type.ID;
try
{
//DeletePowerValuesByType里面删除数据和分类
Common.Services.BaseService.Update("DeletePowerStuffValuesByType", PowerValues);
TreeListNode brotherNode = null;
try
{
if (treeList1.FocusedNode.ParentNode.Nodes.Count > 1)
{
brotherNode = treeList1.FocusedNode.PrevNode;
if (brotherNode == null)
{
brotherNode = treeList1.FocusedNode.NextNode;
}
}
}
catch { }
treeList1.DeleteNode(treeList1.FocusedNode);
LoadData();
}
catch //(Exception ex)
{
//MsgBox.Show("删除出错：" + ex.Message);
}
}
}
private bool SaveRemarkValue(int typeID, string value)
{
PowerStuffTypes ps = Services.BaseService.GetOneByKey <PowerStuffTypes>(typeID);
ps.Remark = value;
//PowerStuffValues PowerValues = new PowerStuffValues();
//PowerValues.TypeID = typeID;
//PowerValues.Value = value;
//PowerValues.Year = year;
try
{
Common.Services.BaseService.Update <PowerStuffTypes>(ps);
}
catch (Exception ex)
{
MsgBox.Show("保存数据出错：" + ex.Message);
return(false);
}
return(true);
}
/// <summary>
/// 删除焦点对象
/// </summary>
public void DeleteObject(string lb)
{
//获取焦点对象
PowerEachList obj = FocusedObject;
if (obj == null)
{
bl = false;
return;
}
int coun = 0;
switch (lb)
{
case "xuqiu":
PowerTypes pt = new PowerTypes();
pt.Flag2 = obj.UID;
IList <PowerTypes> li = Services.BaseService.GetList <PowerTypes>("SelectPowerTypesByFlag2", pt);
coun = li.Count;
break;
case "xihua":
PowerProjectTypes pt1 = new PowerProjectTypes();
pt1.Flag2 = obj.UID;
IList <PowerProjectTypes> li1 = Services.BaseService.GetList <PowerProjectTypes>("SelectPowerProjectTypesByFlag2", pt1);
coun = li1.Count;
break;
case "shebei":
PowerStuffTypes pt2 = new PowerStuffTypes();
pt2.Flag2 = obj.UID;
IList <PowerStuffTypes> li2 = Services.BaseService.GetList <PowerStuffTypes>("SelectPowerStuffTypesByFlag2", pt2);
coun = li2.Count;
break;
case "fanwei":
PowersTypes pt3 = new PowersTypes();
pt3.Flag2 = obj.UID;
IList <PowersTypes> li3 = Services.BaseService.GetList <PowersTypes>("SelectPowersTypesByFlag2", pt3);
coun = li3.Count;
break;
case "sb":
PowerProTypes pt4 = new PowerProTypes();
pt4.Flag2 = obj.UID;
IList <PowerProTypes> li4 = Services.BaseService.GetList <PowerProTypes>("SelectPowerProTypesByFlag2INParent", pt4);
coun = li4.Count;
break;
case "gusuan":
PSP_PowerProValues_LangFang pt5 = new PSP_PowerProValues_LangFang();
pt5.Flag2 = obj.UID;
IList <PSP_PowerProValues_LangFang> li5 = Services.BaseService.GetList <PSP_PowerProValues_LangFang>("SelectPSP_PowerProValues_LangFangByFlag2INParent", pt5);
coun = li5.Count;
break;
}
if (coun > 0)
{
MsgBox.Show("该分类下面有记录，无法删除");
bl = false;
return;
}
//请求确认
if (MsgBox.ShowYesNo(Strings.SubmitDelete) != DialogResult.Yes)
{
bl = false;
return;
}
//执行删除操作
try
{
Services.BaseService.Delete <PowerEachList>(obj);
if (lb == "sb")
{
Services.BaseService.Update("DeletePowerPicSelect1", obj.UID);
Services.BaseService.Update("DeletePowerProTypesInFlag2", obj.UID);
}
if (lb == "gusuan")
{
Services.BaseService.Update("DeletePowerPicSelect1", obj.UID);
Services.BaseService.Update("DeletePowerProTypesInFlag2", obj.UID);
}
}
catch
{
//Debug.Fail(exc.Message);
//HandleException.TryCatch(exc);
return;
}
this.gridView.BeginUpdate();
//记住当前焦点行索引
int iOldHandle = this.gridView.FocusedRowHandle;
//从链表中删除
ObjectList.Remove(obj);
//刷新表格
gridControl.RefreshDataSource();
//设置新的焦点行索引
GridHelper.FocuseRowAfterDelete(this.gridView, iOldHandle);
this.gridView.EndUpdate();
}
private void simpleButton1_Click(object sender, EventArgs e)
{
type = psp_Year.Year = spinEdit1.Text;
if (type.ToString() == "")
{
MsgBox.Show("类别名称不能为空");
return;
}
try
{
if (!IsUpdate)
{
if (Common.Services.BaseService.GetObject("SelectPowerStuffYearsByYearFlag", psp_Year) == null)
{
try
{
Common.Services.BaseService.Create <PowerStuffYears>(psp_Year);
this.DialogResult = DialogResult.OK;
}
catch (Exception ex)
{
MsgBox.Show("出错啦：" + ex.Message);
}
}
else
{
MsgBox.Show("此分类已经存在，请重新输入！");
}
}
else
{
try
{
PowerStuffTypes psp_Type = new PowerStuffTypes();
psp_Type.Flag2 = type1;
IList <PowerStuffTypes> listTypes = new List <PowerStuffTypes>();
try
{
listTypes = Common.Services.BaseService.GetList <PowerStuffTypes>("SelectPowerStuffTypesByFlag2", psp_Type);
}
catch (Exception ex)
{ MsgBox.Show(ex.Message); }
foreach (PowerStuffTypes pstt in listTypes)
{
PowerStuffValues psv = new PowerStuffValues();
psv.ID = pstt.ID;
psv.Year = psp_Year.Year;
psv.Value = year2;
Common.Services.BaseService.Update("UpdatePowerStuffValuesByYear", psv);
}
Common.Services.BaseService.Update <PowerStuffYears>(psp_Year);
this.DialogResult = DialogResult.OK;
}
catch (Exception ex)
{
MsgBox.Show("出错啦：" + ex.Message);
}
}
}
catch (Exception ex)
{
MsgBox.Show("出错啦：" + ex.Message);
}
}
