private void barButtonItem9_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (MsgBox.ShowYesNo("该操作将清除所有数据，清除数据以后无法恢复,可能对其他用户的数据产生影响，请谨慎操作，你确定继续吗？") == DialogResult.No)
{
return;
}
PSP_Types psp_Type = new PSP_Types();
PSP_Values psp_Values = new PSP_Values();
foreach (DataRow dr in dataTable.Rows)
{
if (dr["Title"].ToString().Contains("全社会"))
{
continue;
}
// Class1.TreeNodeToDataObject<PSP_Types>(psp_Type, treeList1.FocusedNode);
psp_Values.TypeID = Convert.ToInt32(dr["id"]);
//DeletePSP_ValuesByType里面删除数据和分类
Common.Services.BaseService.Update("DeletePSP_ValuesByType", psp_Values);
}
Application.DoEvents();
SetValuesTo0();
this.Cursor = Cursors.WaitCursor;
treeList1.BeginUpdate();
LoadData();
treeList1.EndUpdate();
this.Cursor = Cursors.Default;
}
private void LoadData1(int id)
{
if (dataTable != null)
{
dataTable.Columns.Clear();
treeList1.Columns.Clear();
}
switch (id)
{
case 999999:
typeFlag2 = 1;
break;
case 888888:
typeFlag2 = 2;
break;
}
PSP_Types psp_Type = new PSP_Types();
psp_Type.Flag2 = typeFlag2;
psp_Type.ProjectID = Itop.Client.MIS.ProgUID;
IList listTypes = Common.Services.BaseService.GetList("SelectPSP_TypesByFlag2AndProjectID", psp_Type);
dataTable = Itop.Common.DataConverter.ToDataTable(listTypes, typeof(PSP_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["ProjectID"].VisibleIndex = -1;
treeList1.Columns["ProjectID"].OptionsColumn.ShowInCustomizationForm = false;
treeList1.Columns["Flag"].VisibleIndex = -1;
treeList1.Columns["Flag"].OptionsColumn.ShowInCustomizationForm = false;
treeList1.Columns["Flag2"].VisibleIndex = -1;
treeList1.Columns["Flag2"].OptionsColumn.ShowInCustomizationForm = false;
PSP_Years psp_Year = new PSP_Years();
psp_Year.Flag = typeFlag2;
IList <PSP_Years> listYears = Common.Services.BaseService.GetList <PSP_Years>("SelectPSP_YearsListByFlag", psp_Year);
Hashtable htt = new Hashtable();
foreach (PSP_Years item in listYears)
{
if (!htt.ContainsValue(item.Year))
{
htt.Add(Guid.NewGuid().ToString(), item.Year);
}
AddColumn1(item.Year);
}
Application.DoEvents();
LoadValues1(htt);
treeList1.ExpandAll();
}
private void barButtonItem8_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
FormTypeTitle frm = new FormTypeTitle();
frm.Text = "增加分类";
if (frm.ShowDialog() == DialogResult.OK)
{
PSP_Types psp_Type = new PSP_Types();
psp_Type.Title = frm.TypeTitle;
psp_Type.Flag2 = typeFlag2;
psp_Type.ProjectID = ProjectUID;
try
{
psp_Type.ID = (int)Common.Services.BaseService.Create("InsertPSP_Types", psp_Type);
dataTable.Rows.Add(Itop.Common.DataConverter.ObjectToRow(psp_Type, dataTable.NewRow()));
}
catch (Exception ex)
{
MsgBox.Show("增加分类出错：" + ex.Message);
}
}
}
private void barButtonItem8_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (!base.AddRight)
{
MsgBox.Show("您没有权限进行此项操作！");
return;
}
int cou = treeList1.Nodes.Count;
FormTypeTitle frm = new FormTypeTitle();
frm.Text = "增加分类";
if (frm.ShowDialog() == DialogResult.OK)
{
PSP_Types psp_Type = new PSP_Types();
psp_Type.Title = frm.TypeTitle;
psp_Type.Flag = cou + 1;
psp_Type.Flag2 = typeFlag2;
psp_Type.ParentID = 0;
try
{
psp_Type.ID = (int)Common.Services.BaseService.Create("InsertPSP_Types", psp_Type);
dataTable.Rows.Add(Itop.Common.DataConverter.ObjectToRow(psp_Type, dataTable.NewRow()));
}
catch (Exception ex)
{
MsgBox.Show("增加分类出错：" + ex.Message);
}
}
}
private void LoadData()
{
string baseyear = "";
if (dataTable != null)
{
dataTable.Columns.Clear();
treeList1.Columns.Clear();
}
PSP_Types psp_Type = new PSP_Types();
psp_Type.Flag2 = typeFlag2;
IList listTypes = Common.Services.BaseService.GetList("SelectPSP_TypesByFlag2", psp_Type);
dataTable = Itop.Common.DataConverter.ToDataTable(listTypes, typeof(PSP_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;
baseyear = EnsureBaseYear(baseyear);
PSP_Years psp_Year = new PSP_Years();
IList <PSP_Years> listYears;
if (baseyear != "")
{
psp_Year.Flag = typeFlag2;
psp_Year.Year = Convert.ToInt32(baseyear);
listYears = Common.Services.BaseService.GetList <PSP_Years>("SelectPSP_YearsListByFlagAndYear", psp_Year);
}
else
{
psp_Year.Flag = typeFlag2;
listYears = Common.Services.BaseService.GetList <PSP_Years>("SelectPSP_YearsListByFlag", psp_Year);
}
foreach (PSP_Years item in listYears)
{
AddColumn(item.Year);
}
Application.DoEvents();
LoadValues(true);
treeList1.ExpandAll();
if (baseyear != "")
{
treeList1.Columns[3].AppearanceCell.BackColor = Color.GreenYellow;
this.Cursor = Cursors.Default;
}
}
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 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 barButtonItem2_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (treeList1.FocusedNode == null)
{
return;
}
//if (treeList1.FocusedNode.ParentNode == null)
//{
// MsgBox.Show("一级分类名称不能修改！");
// return;
//}
string parentid = treeList1.FocusedNode["ParentID"].ToString();
string flag = treeList1.FocusedNode["flag"].ToString();
//if (parentid == "0" && (flag == "2" || flag == "3" || flag == "5" || flag == "7"))
//{
// MsgBox.Show("固定分类，不能修改！");
// return;
//}
//if (treeList1.FocusedNode["Title"].ToString().IndexOf("居民") > -1 && parentid == "233")
//{
// MsgBox.Show("固定分类，不能修改！");
// return;
//}
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_Types psp_Type = new PSP_Types();
Class1.TreeNodeToDataObject <PSP_Types>(psp_Type, treeList1.FocusedNode);
psp_Type.Title = frm.TypeTitle;
try
{
Common.Services.BaseService.Update <PSP_Types>(psp_Type);
treeList1.FocusedNode.SetValue("Title", frm.TypeTitle);
}
catch (Exception ex)
{
MsgBox.Show("修改出错：" + ex.Message);
}
}
}
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 LoadData()
{
if (dataTable != null)
{
dataTable.Columns.Clear();
treeList1.Columns.Clear();
}
PSP_Types psp_Type = new PSP_Types();
//psp_Type.Flag = 4;
psp_Type.ID = 32;
//IList listTypes = Common.Services.BaseService.GetList("SelectPSP_TypesByFlag", psp_Type);
IList listTypes = Common.Services.BaseService.GetList("SelectPSP_TypesByFlag3", psp_Type);
dataTable = Itop.Common.DataConverter.ToDataTable(listTypes, typeof(PSP_Types));
psp_Type.Flag = 5;
listTypes = Common.Services.BaseService.GetList("SelectPSP_TypesByFlag", psp_Type);
DataTable dt = Itop.Common.DataConverter.ToDataTable(listTypes, typeof(PSP_Types));
foreach (DataRow dr in dt.Rows)
{
DataRow newRow = dataTable.NewRow();
newRow.ItemArray = dr.ItemArray;
dataTable.Rows.Add(newRow);
}
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 AddColumn(int year)
{
int nInsertIndex = GetInsertIndex(year);
dataTable.Columns.Add(year + "年", typeof(double));
TreeListColumn column = treeList1.Columns.Insert(nInsertIndex);
column.FieldName = year + "年";
column.Tag = year;
column.Caption = year + "年";
column.Width = 70;
column.OptionsColumn.AllowSort = false;
column.VisibleIndex = nInsertIndex - 2;//有两列隐藏列
column.ColumnEdit = repositoryItemTextEdit1;
//treeList1.RefreshDataSource();
PSP_Types psp_Type = new PSP_Types();
psp_Type.Flag2 = typeFlag2;
IList listTypes = Common.Services.BaseService.GetList("SelectPSP_TypesByFlag2", psp_Type);
foreach (PSP_Types psp_Typetemp in listTypes)
{
PSP_BaseYearRate psp_Yeartemp = new PSP_BaseYearRate();
psp_Yeartemp.BaseYear = year.ToString();
psp_Yeartemp.TypeID = psp_Typetemp.ID;
try
{
IList <PSP_BaseYearRate> list1 = Common.Services.BaseService.GetList <PSP_BaseYearRate>("SelectPSP_BaseYearRateByYear", psp_Yeartemp);
if (list1.Count == 0)
{
try
{
psp_Yeartemp.UID = Guid.NewGuid().ToString();
psp_Yeartemp.YearRate = "0";
Common.Services.BaseService.Create <PSP_BaseYearRate>(psp_Yeartemp);
this.DialogResult = DialogResult.OK;
}
catch (Exception ex)
{
MsgBox.Show("出错啦：" + ex.Message);
}
}
}
catch (Exception ex)
{
MsgBox.Show(ex.ToString());
}
}
}
private void barButtonItem8_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_Types psp_Type = new PSP_Types();
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
{
psp_Type.ID = (int)Common.Services.BaseService.Create("InsertPSP_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_Types psp_Type = new PSP_Types();
psp_Type.Flag2 = typeFlag2;
psp_Type.ProjectID = ProjectUID;
IList listTypes = Common.Services.BaseService.GetList("SelectPSP_TypesByFlag2AndProjectID", psp_Type);
dataTable = Itop.Common.DataConverter.ToDataTable(listTypes, typeof(PSP_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;
treeList1.Columns["ProjectID"].VisibleIndex = -1;
treeList1.Columns["ProjectID"].OptionsColumn.ShowInCustomizationForm = false;
//treeList1.Columns["ParentID"].VisibleIndex = -1;
//treeList1.Columns["ParentID"].OptionsColumn.ShowInCustomizationForm = false;
PSP_Years psp_Year = new PSP_Years();
psp_Year.Flag = typeFlag2;
IList <PSP_Years> listYears = Common.Services.BaseService.GetList <PSP_Years>("SelectPSP_YearsListByFlag", psp_Year);
foreach (PSP_Years item in listYears)
{
AddColumn(item.Year);
}
Application.DoEvents();
LoadValues();
//foreach (PSP_Years item in listYears)
//{
// ComputeXianSun(item.Year);
// // ComputeXianSun1(item.Year,treeList1.Nodes[0],treeList1.Nodes[1],treeList1.Nodes[2]);
//}
treeList1.ExpandAll();
}
private void barButtonItem1_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_Types psp_Type = new PSP_Types();
psp_Type.Title = frm.TypeTitle;
psp_Type.Flag = (int)focusedNode["Flag"];
psp_Type.Flag2 = typeFlag2;
psp_Type.ParentID = (int)focusedNode.GetValue("TypeID");
try
{
psp_Type.ID = (int)Common.Services.BaseService.Create("InsertPSP_Types", psp_Type);
treeList1.BeginUpdate();
int year = (int)focusedNode.GetValue("Year");
foreach (TreeListNode nd in treeList1.Nodes)
{
AddChildRegion(nd, psp_Type.Title, psp_Type.ParentID, psp_Type.ID, psp_Type.Flag);
}
treeList1.EndUpdate();
DataRow newRegionRow = dtRegion.NewRow();
Itop.Common.DataConverter.ObjectToRow(psp_Type, newRegionRow);
dtRegion.Rows.Add(newRegionRow);
}
catch (Exception ex)
{
MsgBox.Show("增加下级地区出错：" + ex.Message);
}
}
}
private void Get(PSP_Types pt, IList <PSP_P_Types> li, Hashtable hs)
{
IList <PSP_Types> li1 = Services.BaseService.GetList <PSP_Types>("SelectPSP_TypesByParentID", pt);
foreach (PSP_Types pt1 in li1)
{
if (hs.ContainsValue(pt1))
{
continue;
}
hs.Add(Guid.NewGuid().ToString(), pt1);
//PSP_P_Types ppt=new PSP_P_Types();
//UpdateData(pt1,ppt);
//li.Add(ppt);
Get(pt1, li, hs);
}
}
private void barButtonItem1_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
TreeListNode focusedNode = treeList1.FocusedNode;
if (focusedNode == null)
{
return;
}
if (!base.AddRight)
{
MsgBox.Show("您没有权限进行此项操作！");
return;
}
if (focusedNode.GetValue("Title").ToString() == "线损")
{
MsgBox.Show("此行不允许添加子分类！");
return;
}
FormTypeTitle frm = new FormTypeTitle();
frm.Text = "增加" + focusedNode.GetValue("Title") + "的子分类";
if (frm.ShowDialog() == DialogResult.OK)
{
PSP_Types psp_Type = new PSP_Types();
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");
psp_Type.ProjectID = ProjectUID;
try
{
psp_Type.ID = (int)Common.Services.BaseService.Create("InsertPSP_Types", psp_Type);
dataTable.Rows.Add(Itop.Common.DataConverter.ObjectToRow(psp_Type, dataTable.NewRow()));
}
catch (Exception ex)
{
MsgBox.Show("增加子分类出错：" + ex.Message);
}
}
}
private void barButtonItem2_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (treeList1.FocusedNode == null)
{
return;
}
if (!base.EditRight)
{
MsgBox.Show("您没有权限进行此项操作！");
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)
{
PSP_Types psp_Type = new PSP_Types();
Class1.TreeNodeToDataObject <PSP_Types>(psp_Type, treeList1.FocusedNode);
psp_Type.Title = frm.TypeTitle;
try
{
Common.Services.BaseService.Update <PSP_Types>(psp_Type);
treeList1.FocusedNode.SetValue("Title", frm.TypeTitle);
}
catch (Exception ex)
{
MsgBox.Show("修改出错：" + ex.Message);
}
}
}
private void Insertdata()
{
//LayoutList ll1 = this.ctrlLayoutList1.FocusedObject;
//if (ll1 == null)
// return;
string columnname = "";
DataTable dts = new DataTable();
OpenFileDialog op = new OpenFileDialog();
op.Filter = "Excel文件(*.xls)|*.xls";
if (op.ShowDialog() == DialogResult.OK)
{
WaitDialogForm wait = new WaitDialogForm("", "正在导入数据, 请稍候...");
try
{
dts = GetExcel(op.FileName);
IList <PSP_Types> lii = new List <PSP_Types>();
IList <PSP_Values> liiValues = new List <PSP_Values>();
DateTime s8 = DateTime.Now;
PSP_Values psp_Values = new PSP_Values();
int x = 0;
for (int i = 0; i < dts.Rows.Count; i++)
{
this.Cursor = Cursors.WaitCursor;
PSP_Types l1 = new PSP_Types();
l1.ID = i;
l1.Flag2 = typeFlag2;
l1.ProjectID = ProjectUID;
foreach (DataColumn dc in dts.Columns)
{
columnname = dc.ColumnName;
//if (dts.Rows[i][dc.ColumnName].ToString() == "")
// continue;
psp_Values = new PSP_Values();
switch (dc.ColumnName)
{
case "Title":
l1.GetType().GetProperty(dc.ColumnName).SetValue(l1, dts.Rows[i][dc.ColumnName], null);
break;
case "ParentID":
if (dts.Rows[i][dc.ColumnName] == null || dts.Rows[i][dc.ColumnName].ToString() == "" || dts.Rows[i][dc.ColumnName] == DBNull.Value)
{
l1.GetType().GetProperty(dc.ColumnName).SetValue(l1, 0, null);
break;
}
l1.GetType().GetProperty(dc.ColumnName).SetValue(l1, Convert.ToInt32(dts.Rows[i][dc.ColumnName]), null);
break;
default:
if (dts.Rows[i][dc.ColumnName] == null || dts.Rows[i][dc.ColumnName].ToString() == "" || dts.Rows[i][dc.ColumnName] == DBNull.Value)
{
psp_Values.Value = 0;
}
else
{
psp_Values.Value = Convert.ToDouble(dts.Rows[i][dc.ColumnName]);
}
psp_Values.Year = Convert.ToInt32(dc.ColumnName.Replace("年", ""));
psp_Values.TypeID = i;
psp_Values.ID = typeFlag2;
liiValues.Add(psp_Values);
break;
}
}
lii.Add(l1);
}
int parenti = -4;
//foreach (Ps_History l1 in lii)
PSP_Types psl1;
PSP_Values psp_values;
int ti = 0;
for (int i = 0, j = 0; i < lii.Count; i++)
{
psl1 = lii[i];
ti = psl1.ID;
string con = "Flag2='" + typeFlag2 + "' and Title='" + psl1.Title + "'and ParentID ='" + psl1.ParentID + "' and ProjectID='" + ProjectUID + "'";
object obj = Services.BaseService.GetObject("SelectPSP_TypesByWhere", con);
if (obj != null)
{
psl1.ID = ((PSP_Types)obj).ID;
if (psl1.ParentID < 0)
{
psl1.ParentID = ((PSP_Types)obj).ParentID;
psl1.Flag = ((PSP_Types)obj).Flag;
}
Services.BaseService.Update <PSP_Types>(psl1);
}
else
{
Services.BaseService.Create <PSP_Types>(psl1);
obj = Services.BaseService.GetObject("SelectPSP_TypesByWhere", con);
if (obj != null)
{
psl1.ID = ((PSP_Types)obj).ID;
}
}
for (int jtemp = i + 1; jtemp < lii.Count; jtemp++)
{
if (lii[jtemp].ParentID == parenti)
{
lii[jtemp].ParentID = psl1.ID;
lii[jtemp].Flag = psl1.Flag;
}
}
for (; j < liiValues.Count; j++)
{
psp_values = liiValues[j];
if (psp_values.TypeID > ti)
{
break;
}
con = "TypeID='" + psl1.ID + "' and Year='" + psp_values.Year + "'";
obj = Services.BaseService.GetObject("SelectPSP_ValuesByWhere", con);
psp_values.TypeID = psl1.ID;
if (obj != null)
{
psp_values.ID = ((PSP_Values)obj).ID;
Services.BaseService.Update <PSP_Values>(psp_values);
}
else
{
Services.BaseService.Create <PSP_Values>(psp_values);
}
}
parenti--;
}
this.Cursor = Cursors.Default;
wait.Close();
treeList1.BeginUpdate();
LoadData();
treeList1.EndUpdate();
MsgBox.Show("导入成功！");
}
catch (Exception ex)
{
this.Cursor = Cursors.Default;
wait.Close();
MsgBox.Show(columnname + ex.Message); MsgBox.Show("导入格式不正确！");
}
}
}
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 Form7_BaseYearRate_Load(object sender, EventArgs e)
{
if (dt1 != null)
{
dt1.Columns.Clear();
treeList1.Columns.Clear();
}
//this.gridColumn2.ColumnEdit = this.repositoryItemTextEdit1;
PSP_Types psp_Type = new PSP_Types();
psp_Type.Flag2 = typeFlag2;
IList listTypes = Common.Services.BaseService.GetList("SelectPSP_TypesByFlag2", psp_Type);
dt1 = Itop.Common.DataConverter.ToDataTable(listTypes, typeof(PSP_Types));
treeList1.DataSource = dt1;
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;
string baseyear = "";
baseyear = EnsureBaseYear(baseyear);
PSP_Years psp_Year = new PSP_Years();
IList <PSP_Years> listYears;
if (baseyear != "")
{
psp_Year.Flag = typeFlag2;
psp_Year.Year = Convert.ToInt32(baseyear);
listYears = Common.Services.BaseService.GetList <PSP_Years>("SelectPSP_YearsListByFlagAndYear", psp_Year);
}
else
{
MsgBox.Show("没有添加基准年，请添加后再操作！");
return;
}
if (listYears.Count > 1)
{
endyear = listYears[listYears.Count - 1].Year;
}
else
{
MsgBox.Show("没有添加预测年，请添加后再操作！");
this.DialogResult = DialogResult.OK;
return;
}
foreach (PSP_Years item in listYears)
{
if (item.Year.ToString() == baseyear)
{
continue;
}
AddColumn(item.Year);
PSP_BaseYearRate psp_Yeartemp = new PSP_BaseYearRate();
foreach (PSP_Types psp_Typetemp in listTypes)
{
psp_Yeartemp.BaseYear = item.Year.ToString();
psp_Yeartemp.TypeID = psp_Typetemp.ID;
try
{
IList <PSP_BaseYearRate> list1 = Common.Services.BaseService.GetList <PSP_BaseYearRate>("SelectPSP_BaseYearRateByYear", psp_Yeartemp);
if (list1.Count == 1)
{
TreeListNode node = treeList1.FindNodeByFieldValue("ID", Convert.ToInt32(list1[0].TypeID));
if (node != null)
{
if (list1[0].YearRate != "")
{
node.SetValue(list1[0].BaseYear + "年", Convert.ToDouble(list1[0].YearRate));
}
else
{
node.SetValue(psp_Yeartemp.BaseYear + "年", "0");
}
}
}
else if (list1.Count == 0)
{
try
{
psp_Yeartemp.UID = Guid.NewGuid().ToString();
psp_Yeartemp.YearRate = "0";
Common.Services.BaseService.Create <PSP_BaseYearRate>(psp_Yeartemp);
TreeListNode node = treeList1.FindNodeByFieldValue("ID", psp_Yeartemp.TypeID);
if (node != null)
{
node.SetValue(psp_Yeartemp.BaseYear + "年", "0");
}
}
catch (Exception ex)
{
// MsgBox.Show("出错啦：" + ex.Message);
}
}
}
catch (Exception ex)
{
// MsgBox.Show(ex.ToString());
}
}
}
treeList1.ExpandAll();
}
private void barButtonItem2_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
TreeListMultiSelection tm = treeList1.Selection;
if (tm.Count == 0)
{
return;
}
DataRow dr = this.gridView1.GetDataRow(this.gridView1.FocusedRowHandle);
if (dr == null)
{
return;
}
int id1 = (int)dr["ID"];
hs.Clear();
li.Clear();
if (Flag == "1")//旧版分区县供电实绩
{
if (id1 != 4)
{
foreach (TreeListNode tln in tm)
{
Ps_History pt1 = new Ps_History();
Ps_History pt = Services.BaseService.GetOneByKey <Ps_History>((string)tln["ID"]);
if (tln["Title"].ToString() == "常规用电量" || tln["Title"].ToString() == "常规负荷")
{
pt.Title = pt.Title + "-" + tln.ParentNode["Title"];
}
else
if (!tln["Title"].ToString().Contains("电量") && !tln["Title"].ToString().Contains("负荷"))
{
if (id1 == 2)
{
pt.Title = pt.Title + "电量";
}
else if (id1 == 3)
{
pt.Title = pt.Title + "负荷";
}
}
if (!hs.ContainsValue(pt))
{
hs.Add(Guid.NewGuid().ToString(), pt);
}
}
}
else
{
foreach (TreeListNode tln in tm)
{
PSP_Types pt = Services.BaseService.GetOneByKey <PSP_Types>((int)tln["ID"]);
if (!hs.ContainsValue(pt))
{
hs.Add(Guid.NewGuid().ToString(), pt);
}
}
}
}
else//新版分区县供电实绩
{
foreach (TreeListNode tln in tm)
{
Ps_History pt1 = new Ps_History();
Ps_History pt = Services.BaseService.GetOneByKey <Ps_History>((string)tln["ID"]);
if (tln["Title"].ToString() == "常规用电量" || tln["Title"].ToString() == "常规负荷")
{
pt.Title = pt.Title + "-" + tln.ParentNode["Title"];
}
else
if (!tln["Title"].ToString().Contains("电量") && !tln["Title"].ToString().Contains("负荷"))
{
if (id1 == 2)
{
pt.Title = pt.Title + "电量";
}
else if (id1 == 3)
{
pt.Title = pt.Title + "负荷";
}
}
if (!hs.ContainsValue(pt))
{
hs.Add(Guid.NewGuid().ToString(), pt);
}
}
}
if (hs.Count > 0)
{
this.DialogResult = DialogResult.OK;
}
}
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_Types psp_Type = new PSP_Types();
Class1.TreeNodeToDataObject <PSP_Types>(psp_Type, treeList1.FocusedNode);
PSP_Values psp_Values = new PSP_Values();
psp_Values.TypeID = psp_Type.ID;
try
{
//DeletePSP_ValuesByType里面删除数据和分类
Common.Services.BaseService.Update("DeletePSP_ValuesByType", psp_Values);
TreeListNode brotherNode = null;
if (treeList1.FocusedNode.ParentNode != 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)
{
MsgBox.Show("删除出错：" + ex.Message);
}
}
}
private void barButtonItem2_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
TreeListNode focusedNode = treeList1.FocusedNode;
if (focusedNode == null)
{
return;
}
if (!base.EditRight)
{
MsgBox.Show("您没有权限进行此项操作！");
return;
}
if (focusedNode.ParentNode == null)
{
MsgBox.Show("全地区名称不能修改！");
return;
}
FormTypeTitle frm = new FormTypeTitle();
frm.TypeTitle = focusedNode.GetValue("Title").ToString();
frm.Text = "修改地区名称";
if (frm.ShowDialog() == DialogResult.OK)
{
PSP_Types psp_Type = new PSP_Types();
psp_Type.Flag = (int)focusedNode["Flag"];
psp_Type.Flag2 = typeFlag2;
psp_Type.ParentID = Convert.ToInt32(focusedNode.GetValue("ParentID").ToString().Remove(0, focusedNode.GetValue("Year").ToString().Length));
psp_Type.Title = frm.TypeTitle;
psp_Type.ID = (int)focusedNode.GetValue("TypeID");
try
{
Common.Services.BaseService.Update <PSP_Types>(psp_Type);
treeList1.BeginUpdate();
foreach (TreeListNode nd in treeList1.Nodes)
{
UpdateNodeText(nd, psp_Type.Title, psp_Type.ID);
}
treeList1.EndUpdate();
foreach (DataRow dr in dtRegion.Rows)
{
if ((int)dr["ID"] == psp_Type.ID)
{
dr["Title"] = psp_Type.Title;
break;
}
}
}
catch (Exception ex)
{
MsgBox.Show("修改出错：" + ex.Message);
}
}
}
private void LoadData()
{
_isLoadingData = true;
this.Cursor = Cursors.WaitCursor;
treeList1.BeginUpdate();
if (dataTable != null)
{
treeList1.Columns.Clear();
}
PSP_Types psp_Type = new PSP_Types();
psp_Type.Flag2 = typeFlag2;
IList listTypes = Common.Services.BaseService.GetList("SelectPSP_TypesByFlag2", psp_Type);
if (listTypes == null || listTypes.Count == 0)
{
MsgBox.Show("地区分类不存在，程序无法继续执行！");
Application.ExitThread();
return;
}
dtRegion = Itop.Common.DataConverter.ToDataTable(listTypes, typeof(PSP_Types));
dtRegion.PrimaryKey = new DataColumn[] { dtRegion.Columns["ID"] };
dataTable = new DataTable();
dataTable.Columns.Add("ID", typeof(string)); //ID.ToString()+Year.ToString()
dataTable.Columns.Add("ParentID", typeof(string)); //ParentID.ToString()+Year.ToString()
dataTable.Columns.Add("Year", typeof(int));
dataTable.Columns.Add("TypeID", typeof(int));
dataTable.Columns.Add("Flag", typeof(int));
dataTable.Columns.Add("Title", typeof(string));
for (int i = 1; i <= maxCols; i++)
{
dataTable.Columns.Add("Col" + i, typeof(double));
}
treeList1.DataSource = dataTable;
treeList1.Columns["Year"].VisibleIndex = -1;
treeList1.Columns["Year"].OptionsColumn.ShowInCustomizationForm = false;
treeList1.Columns["TypeID"].VisibleIndex = -1;
treeList1.Columns["TypeID"].OptionsColumn.ShowInCustomizationForm = false;
treeList1.Columns["Flag"].VisibleIndex = -1;
treeList1.Columns["Flag"].OptionsColumn.ShowInCustomizationForm = false;
treeList1.Columns["Title"].Caption = "";
treeList1.Columns["Title"].OptionsColumn.AllowEdit = false;
treeList1.Columns["Title"].OptionsColumn.AllowSort = false;
treeList1.Columns["Col1"].Caption = "最高负荷";
treeList1.Columns["Col1"].Width = 80;
treeList1.Columns["Col2"].Caption = "220kV直供35/10kV容量";
treeList1.Columns["Col2"].Width = 140;
treeList1.Columns["Col3"].Caption = "35kV及以下装机";
treeList1.Columns["Col3"].Width = 100;
treeList1.Columns["Col4"].Caption = "需110kV变电容量";
treeList1.Columns["Col4"].Width = 110;
treeList1.Columns["Col5"].Caption = "本年已有变电容量";
treeList1.Columns["Col5"].Width = 110;
treeList1.Columns["Col6"].Caption = "本年已有变电项目";
treeList1.Columns["Col6"].Width = 110;
treeList1.Columns["Col7"].Caption = "需新增变电容量";
treeList1.Columns["Col7"].Width = 100;
treeList1.Columns["Col8"].Caption = "新增项目";
treeList1.Columns["Col8"].Width = 70;
treeList1.Columns["Title"].Width = 160;
for (int i = 1; i <= maxCols; i++)
{
treeList1.Columns["Col" + i].OptionsColumn.AllowSort = false;
treeList1.Columns["Col" + i].ColumnEdit = repositoryItemTextEdit1;
}
treeList1.Columns["Year"].SortOrder = SortOrder.Ascending;
Application.DoEvents();
LoadValues();
treeList1.ExpandAll();
treeList1.EndUpdate();
this.Cursor = Cursors.Default;
_isLoadingData = false;
}
