private void barButtonItem3_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;
}
string nodestr = treeList1.FocusedNode.GetValue("Title").ToString();
if (nodestr == "B、城乡居民生活用电合计")
{
MsgBox.Show("不允许删除" + treeList1.FocusedNode.GetValue("Title").ToString() + "名称！");
return;
}
if (treeList1.FocusedNode.HasChildren)
{
MsgBox.Show("此分类下有子分类，请先删除子分类！");
return;
}
if (!base.DeleteRight)
{
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.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);
this.Cursor = Cursors.WaitCursor;
treeList1.BeginUpdate();
LoadData();
treeList1.EndUpdate();
this.Cursor = Cursors.Default;
}
}
}
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 LoadHistoryValue()
{
PSP_P_Years psp_Year = new PSP_P_Years();
psp_Year.Flag = forecastReport.ID;
IList<PSP_P_Years> listYears = Common.Services.BaseService.GetList<PSP_P_Years>("SelectPSP_P_YearsListByFlag", psp_Year);
foreach (PSP_P_Years item in listYears)
{
dataTable.Columns.Add(item.Year + "Y", typeof(double));
TreeListColumn column = treeList1.Columns.Add();
column.FieldName = item.Year + "Y";
column.Tag = item.Year;
column.VisibleIndex = -1;
}
PSP_Values psp_Values = new PSP_Values();
psp_Values.ID = forecastReport.ID;//��ID�ֶδ��Flag2��ֵ
IList<PSP_P_Values> listValues = Common.Services.BaseService.GetList<PSP_P_Values>("SelectPSP_P_ValuesListByFlag2", psp_Values);
foreach (PSP_P_Values value in listValues)
{
TreeListNode node = treeList1.FindNodeByFieldValue("ID", value.TypeID);
if (node != null)
{
node.SetValue(value.Year + "Y", value.Value);
if (value.Year == forecastReport.StartYear)
{
node.SetValue(value.Year + "��", value.Value);
}
}
}
}
private void SetValuesTo0()
{
PSP_Values psp_Values = new PSP_Values();
psp_Values.ID = typeFlag2;//用ID字段存放Flag2的值
IList<PSP_Values> listValues = Common.Services.BaseService.GetList<PSP_Values>("SelectPSP_ValuesListByFlag2", psp_Values);
foreach (PSP_Values value in listValues)
{
value.Value = 0;
Common.Services.BaseService.Update<PSP_Values>(value);
}
}
private bool SaveCellValue(int year, int typeID, double value)
{
PSP_Values PowerValues = new PSP_Values();
PowerValues.TypeID = typeID;
PowerValues.Value = value;
PowerValues.Year = year;
try
{
Common.Services.BaseService.Update<PowerValues>(PowerValues);
}
catch(Exception ex)
{
MsgBox.Show("保存数据出错：" + ex.Message);
return false;
}
return true;
}
private void barButtonItem2_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (treeList1.FocusedColumn == null)
{
return;
}
//不是年份列
if (treeList1.FocusedColumn.FieldName.IndexOf("年") == -1)
{
return;
}
if (!base.DeleteRight)
{
MsgBox.Show("您没有权限进行此项操作！");
return;
}
if (MsgBox.ShowYesNo("是否删除 " + treeList1.FocusedColumn.FieldName + " 及该年的所有数据？") != DialogResult.Yes)
{
return;
}
PSP_Values psp_Values = new PSP_Values();
psp_Values.ID = typeFlag2;//借用ID属性存放Flag2
psp_Values.Year = (int)treeList1.FocusedColumn.Tag;
try
{
//DeletePSP_ValuesByYear删除数据和年份
int colIndex = treeList1.FocusedColumn.AbsoluteIndex;
Common.Services.BaseService.Update("DeletePSP_ValuesByYear", psp_Values);
dataTable.Columns.Remove(treeList1.FocusedColumn.FieldName);
treeList1.Columns.Remove(treeList1.FocusedColumn);
if (colIndex >= treeList1.Columns.Count)
{
colIndex--;
}
treeList1.FocusedColumn = treeList1.Columns[colIndex];
}
catch (Exception ex)
{
MsgBox.Show("删除出错：" + ex.Message);
}
}
private void ReLoadData(string baseyear)
{
int year = Convert.ToInt32(baseyear);
if (dataTable != null)
{
dataTable.Columns.Clear();
treeList1.Columns.Clear();
}
PSP_GDPTypes psp_Type = new PSP_GDPTypes();
psp_Type.Flag2 = typeFlag2;
IList listTypes = Common.Services.BaseService.GetList("SelectPSP_GDPTypes", null);
dataTable = Itop.Common.DataConverter.ToDataTable(listTypes, typeof(PSP_GDPTypes));
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_GDPYeas psp_Year = new PSP_GDPYeas();
psp_Year.Flag = typeFlag2;
Hashtable ha = new Hashtable();
ha.Add("Flag", typeFlag2);
ha.Add("Year", year);
IList<PSP_GDPYeas> listYears = Common.Services.BaseService.GetList<PSP_GDPYeas>("SelectPSP_YeasListByFlagAndYear", ha);
al.Clear();
foreach (PSP_GDPYeas item in listYears)
{
al.Add(item.Year);
}
Application.DoEvents();
if (al.Contains(year))
{
PSP_GDPBaseYear byear = new PSP_GDPBaseYear();
byear.BaseYear = baseyear;
Common.Services.BaseService.Update("UpdatePSP_GDPBaseYearbyid", byear);
}
if (!al.Contains(year))
{
MessageBox.Show("数据库中不存在"+year+"年！");
PSP_GDPBaseYear BaseYear = (PSP_GDPBaseYear)Common.Services.BaseService.GetObject("SelectPSP_GDPBaseYearList", null);
if (BaseYear == null)
{
ha.Clear();
ha.Add("Flag", typeFlag2);
ha.Add("Year", "1990");
listYears.Clear();
listYears = Common.Services.BaseService.GetList<PSP_GDPYeas>("SelectPSP_YeasListByFlagAndYear", ha);
year = 1990;
}
else
{
ha.Clear();
ha.Add("Flag", typeFlag2);
ha.Add("Year", BaseYear.BaseYear);
listYears.Clear();
listYears = Common.Services.BaseService.GetList<PSP_GDPYeas>("SelectPSP_YeasListByFlagAndYear", ha);
year = Convert.ToInt32( BaseYear.BaseYear);
}
}
foreach (PSP_GDPYeas item in listYears)
{
AddColumn(item.Year);
}
LoadValues(year);
firstyearValues(year);
foreach (PSP_GDPYeas item in listYears)
{
if (item.Year > year)
{
ComputeValues(item.Year);
}
}
PSP_Types psp_T = new PSP_Types();
psp_T.Flag2 = typeFlag2;
IList<PSP_Types> listT = Common.Services.BaseService.GetList<PSP_Types>("SelectPSP_TypesByFlag2", psp_T);
PSP_Values pspval = new PSP_Values();
pspval.TypeID = -1;
foreach (PSP_Types psp in listT)
{
if (psp.Title == "人口(万人)")
{
pspval.TypeID = psp.ID;
break;
}
}
if (pspval.TypeID != -1)
{
ha.Clear();
ha.Add("TypeID", pspval.TypeID);
// ha.Add("Year", year);
IList<PSP_Values> listvalue = Common.Services.BaseService.GetList<PSP_Values>("SelectPSP_ValuesList", ha);
foreach (PSP_Values it in listvalue)
{
if (al.Contains(it.Year))
{
if (treeList1.Nodes[2][it.Year + "年"].ToString() != "")
{
treeList1.Nodes[3].SetValue(it.Year + "年", Convert.ToDouble(treeList1.Nodes[2].GetValue(it.Year + "年")) / it.Value);
}
}
}
}
foreach (PSP_GDPYeas item in listYears)
{
ComputeBiZhong(item.Year);
}
treeList1.ExpandAll();
}
private void InsertLineData1()
{
string columnname = "";
if (treeList1.Nodes.Count == 0)
{
return;
}
IList<PSP_Values> pvlist = new List<PSP_Values>();
pvlist.Clear();
try
{
DataTable dts = new DataTable();
OpenFileDialog op = new OpenFileDialog();
op.Filter = "Excel文件(*.xls)|*.xls";
if (op.ShowDialog() == DialogResult.OK)
{
dts = GetExcel(op.FileName);
////// string LL2 = "";
////// try
////// {
////// LL2 = dts.Rows[i][dc.ColumnName].ToString();
////// }
////// catch { }
//////m2.GetType().GetProperty(dc.ColumnName).SetValue(m2, LL2, null);
ArrayList al = new ArrayList();
al.Clear();
foreach (TreeListColumn tcl in treeList1.Columns)
{
al.Add(tcl.Caption);
}
foreach (DataColumn dc in dts.Columns)
{
int j = 0;
columnname = dc.ColumnName;
try
{
if (dc.ColumnName.ToString().Substring(4,1)=="年" &&dc.ColumnName.ToString().Length == 5)
{
if (!al.Contains(dc.ColumnName))
{
NewYear(int.Parse(dc.ColumnName.ToString().Substring(0, 4)));
}
foreach (TreeListColumn tcl in treeList1.Columns)
{
try
{
if (tcl.Caption.ToString().Substring(4, 1) == "年" && tcl.Caption.ToString().Length == 5)
{
if (tcl.Caption == dc.ColumnName)
{
if (MessageBox.Show(tcl.Caption + "列已经存在！是否更新此列的数据！", "确认", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
continue;
for (int i = 0; i < dts.Rows.Count; i++)
{
PSP_Values m1 = new PSP_Values();
if (dts.Rows[i][dc.ColumnName].ToString() == null || dts.Rows[i][dc.ColumnName].ToString() == "")
{
m1.Year = int.Parse(dc.ColumnName.ToString().Substring(0, 4));
}
else
{
m1.Value = double.Parse(dts.Rows[i][dc.ColumnName].ToString());
m1.Year = int.Parse(dc.ColumnName.ToString().Substring(0, 4));
}
m1.TypeID = int.Parse(treeList1.Nodes[j]["ID"].ToString());
pvlist.Add(m1);
if (treeList1.Nodes[j].HasChildren == true)
{
for (int m = 0; m < treeList1.Nodes[j].Nodes.Count; m++)
{
CalChildNode1(treeList1.Nodes[j].Nodes[m], ref i, dts, dc, ref pvlist);
}
}
j++;
}
}
}
}
catch { }
}
}
else
{
continue;
}
}
catch { }
}
foreach (PSP_Values pv in pvlist)
Common.Services.BaseService.Update("UpdatePSP_Values", pv);
}
ReLoad();
}
catch { MsgBox.Show("导入格式不正确！"); }
}
private void DeletFixedVoltageRows(TreeListNode node)
{
PSP_Types psp_Type = new PSP_Types();
psp_Type.Flag2 = typeFlag2;
psp_Type.ID = Convert.ToInt32(node["ID"]);
IList listTypes = Common.Services.BaseService.GetList("SelectPSP_TypesByParentID", psp_Type);
try
{
foreach (PSP_Types psp_Typetemp in listTypes)
{
PSP_Values psp_Values = new PSP_Values();
psp_Values.TypeID = psp_Typetemp.ID;
//DeletePSP_ValuesByType里面删除数据和分类
Common.Services.BaseService.Update("DeletePSP_ValuesByType", psp_Values);
PSP_Types psp_Type2 = new PSP_Types();
psp_Type2.Flag2 = typeFlag2;
psp_Type2.ID = psp_Typetemp.ID;
IList listTypes2 = Common.Services.BaseService.GetList("SelectPSP_TypesByParentID", psp_Type2);
foreach (PSP_Types psp_Typetemp2 in listTypes2)
{
psp_Values.TypeID = psp_Typetemp2.ID;
//DeletePSP_ValuesByType里面删除数据和分类
Common.Services.BaseService.Update("DeletePSP_ValuesByType", psp_Values);
}
}
}
catch(Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
private void LoadData( string baseyear )
{
int year = Convert.ToInt32(baseyear);
if (dataTable != null)
{
dataTable.Columns.Clear();
treeList1.Columns.Clear();
}
PSP_GDPTypes psp_Type = new PSP_GDPTypes();
psp_Type.Flag2 = typeFlag2;
IList listTypes = Common.Services.BaseService.GetList("SelectPSP_GDPTypes", null);
dataTable = Itop.Common.DataConverter.ToDataTable(listTypes, typeof(PSP_GDPTypes));
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_GDPYeas psp_Year = new PSP_GDPYeas();
psp_Year.Flag = typeFlag2;
Hashtable ha = new Hashtable();
ha.Add("Flag",typeFlag2);
ha.Add("Year", year);
IList<PSP_GDPYeas> listYears = Common.Services.BaseService.GetList<PSP_GDPYeas>("SelectPSP_YeasListByFlagAndYear", ha);
// PSP_YearVisibleIndex yvi = new PSP_YearVisibleIndex();
// yvi.ModuleFlag = ModuleFlag;
// yvi.Year = year.ToString() ;
// IList<PSP_YearVisibleIndex> yearvisi = Common.Services.BaseService.GetList<PSP_YearVisibleIndex>("SelectPSP_YearVisibleIndexByModuleFlagSort", yvi);
//if (yearvisi.Count == 0)
// {
al.Clear();
foreach (PSP_GDPYeas item in listYears)
{
AddColumn(item.Year);
al.Add(item.Year);
}
// }
// else
//{
// foreach (PSP_YearVisibleIndex item in yearvisi)
// {
// AddColumn(Convert.ToInt32(item.Year),item.VisibleIndex);
// }
// }
Application.DoEvents();
LoadValues(year);
firstyearValues(year);
foreach (PSP_GDPYeas item in listYears)
{
if (item.Year > year)
{
ComputeValues(item.Year);
}
}
PSP_Types psp_T = new PSP_Types();
psp_T.Flag2 = typeFlag2;
IList<PSP_Types> listT = Common.Services.BaseService.GetList<PSP_Types>("SelectPSP_TypesByFlag2", psp_T);
PSP_Values pspval = new PSP_Values();
pspval.TypeID = -1;
foreach (PSP_Types psp in listT)
{
if (psp.Title == "人口(万人)")
{
pspval.TypeID = psp.ID;
break;
}
}
if (pspval.TypeID != -1)
{
ha.Clear();
ha.Add("TypeID", pspval.TypeID);
// ha.Add("Year", year);
IList<PSP_Values> listvalue = Common.Services.BaseService.GetList<PSP_Values>("SelectPSP_ValuesList", ha);
foreach (PSP_Values it in listvalue)
{
if (al.Contains(it.Year))
{
if (treeList1.Nodes[2][it.Year + "年"].ToString() != "")
{
treeList1.Nodes[3].SetValue(it.Year + "年",Convert.ToInt32(Convert.ToDouble(treeList1.Nodes[2].GetValue(it.Year + "年"))/ it.Value));
}
}
}
}
foreach (PSP_GDPYeas item in listYears)
{
ComputeBiZhong(item.Year);
}
LoadValues1();
treeList1.ExpandAll();
}
//统计
private void barButtonItem6_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
FormChooseYears frm = new FormChooseYears();
foreach (TreeListColumn column in treeList1.Columns)
{
if (column.FieldName.IndexOf("年") > 0)
{
frm.ListYearsForChoose.Add((int)column.Tag);
}
}
frm.NoIncreaseRate = true;
DataTable dt = new DataTable();
PSP_Types psp_Type = new PSP_Types();
psp_Type.Flag2 = typeFlag2;
IList listTypes = Common.Services.BaseService.GetList("SelectPSP_TypesByFlag2", psp_Type);
dt = Itop.Common.DataConverter.ToDataTable(listTypes, typeof(PSP_Types));
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)
{
dt.Columns.Add(item.Year + "年", typeof(double));
}
PSP_Values psp_Values = new PSP_Values();
psp_Values.ID = typeFlag2;//用ID字段存放Flag2的值
IList<PSP_Values> listValues = Common.Services.BaseService.GetList<PSP_Values>("SelectPSP_ValuesListByFlag2", psp_Values);
foreach (PSP_Values psptemp in listValues)
{
foreach (DataRow dttemp in dt.Rows)
{
if (Convert.ToInt32(dttemp["ID"].ToString()) == psptemp.TypeID)
dttemp[psptemp.Year + "年"] = psptemp.Value;
}
}
if(frm.ShowDialog() == DialogResult.OK)
{
FrmBalanceOfPowerRegionPrint frma = new FrmBalanceOfPowerRegionPrint();
frma.IsSelect = _isSelect;
frma.HASH = hash;
frma.HASH2 = hash2;
frma.Text = "南北区电力平衡表";
frma.GridDataTable = ResultDataTable(dt, frm.ListChoosedYears);
frma.ISPrint = PrintRight;
if (frma.ShowDialog() == DialogResult.OK && _isSelect)
{
DialogResult = DialogResult.OK;
}
}
}
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 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 NewDemandLata2(ref DataTable datatemp)
{
PSP_Types psp_Type = new PSP_Types();
psp_Type.Flag2 = 1;
IList listTypes = Common.Services.BaseService.GetList("SelectPSP_TypesByFlag2", psp_Type);
foreach (PSP_Types psptemp in listTypes)
{
if (psptemp.Title != "")
if (!psptemp.Title.Contains("ȫ����õ���"))
continue;
IList listTypes2 = Common.Services.BaseService.GetList("SelectPSP_TypesByParentID", psptemp);
foreach (PSP_Types psptemp2 in listTypes2)
{
if (psptemp2.Title.Contains("ȫ��ҵ�õ�ϼ�"))
{
IList listTypes3 = Common.Services.BaseService.GetList("SelectPSP_TypesByParentID", psptemp2);
foreach (PSP_Types psptemp3 in listTypes3)
{
DataRow dt = datatemp.NewRow();
dt["Title"] = psptemp3.Title;
dt["TypeID"] = psptemp3.ID;
datatemp.Rows.Add(dt);
}
}
else if (psptemp2.Title.Contains("������������õ�ϼ�"))
{
DataRow dt = datatemp.NewRow();
dt["Title"] = psptemp2.Title;
dt["TypeID"] = psptemp2.ID;
datatemp.Rows.Add(dt);
}
}
}
PSP_Values psp_Values = new PSP_Values();
psp_Values.ID = 1;//��ID�ֶδ��Flag2��ֵ
IList<PSP_Values> listValues = Common.Services.BaseService.GetList<PSP_Values>("SelectPSP_ValuesListByFlag2", psp_Values);
foreach (PSP_Values value in listValues)
{
DataRow[] drselc = datatemp.Select("TypeID=" + value.TypeID);
if(drselc!=null)
if (drselc.Length == 1)
{
if (datatemp.Columns.Contains(value.Year + "��"))
{
drselc[0][value.Year + "��"] = value.Value;
}
}
}
}
private void barButtonItem3_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (treeList1.FocusedNode == null)
{
return;
}
if (treeList1.FocusedNode.ParentNode == null)
{
MsgBox.Show("һ������Ϊ�̶����ݣ�����ɾ����");
return;
}
if (treeList1.FocusedNode.HasChildren)
{
MsgBox.Show("�˷��������ӷ��࣬����ɾ���ӷ��࣡");
return;
}
if (!base.DeleteRight)
{
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.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 LoadValues1(Hashtable htt)
{
PSP_Values psp_Values = new PSP_Values();
psp_Values.ID = typeFlag2;//��ID�ֶδ��Flag2��ֵ
IList<PSP_Values> listValues = Common.Services.BaseService.GetList<PSP_Values>("SelectPSP_ValuesListByFlag2", psp_Values);
foreach (PSP_Values value in listValues)
{
if (!htt.ContainsValue(value.Year))
continue;
TreeListNode node = treeList1.FindNodeByFieldValue("ID", value.TypeID);
if (node != null)
{
node.SetValue(value.Year + "��", value.Value);
}
}
}
private void barButtonItem5_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
string baseyear = "";
baseyear = EnsureBaseYear(baseyear);
if (treeList1.FocusedColumn == null)
{
return;
}
//���������
if (treeList1.FocusedColumn.FieldName.IndexOf("��") == -1)
{
return;
}
if (treeList1.FocusedColumn.FieldName.Contains(baseyear) && baseyear != "")
{
return;
}
if (!base.DeleteRight)
{
MsgBox.Show("��û��Ȩ���д��������");
return;
}
if (MsgBox.ShowYesNo("�Ƿ�ɾ�� " + treeList1.FocusedColumn.FieldName + " ��������������ݣ�") != DialogResult.Yes)
{
return;
}
PSP_Values psp_Values = new PSP_Values();
psp_Values.ID = typeFlag2;//����ID���Դ��Flag2
psp_Values.Year = (int)treeList1.FocusedColumn.Tag;
try
{
//DeletePSP_ValuesByYearɾ�����ݺ����
int colIndex = treeList1.FocusedColumn.AbsoluteIndex;
Common.Services.BaseService.Update("DeletePSP_ValuesByYear", psp_Values);
dataTable.Columns.Remove(treeList1.FocusedColumn.FieldName);
treeList1.Columns.Remove(treeList1.FocusedColumn);
if (colIndex >= treeList1.Columns.Count)
{
colIndex--;
}
treeList1.FocusedColumn = treeList1.Columns[colIndex];
}
catch (Exception ex)
{
MsgBox.Show("ɾ�������" + ex.Message);
}
}
//读取数据
private void LoadValues()
{
PSP_Values psp_Values = new PSP_Values();
psp_Values.ID = typeFlag2;//用ID字段存放Flag2的值
IList<PSP_Values> listValues = Common.Services.BaseService.GetList<PSP_Values>("SelectPSP_ValuesListByFlag2", psp_Values);
foreach(PSP_Values value in listValues)
{
TreeListNode node = treeList1.FindNodeByFieldValue("ID", value.TypeID);
if(node != null)
{
node.SetValue(value.Year + "年", value.Value);
}
}
}
//��ȡ����
private void LoadValues(bool Isfirstload)
{
string baseyear = "";
baseyear = EnsureBaseYear(baseyear);
PSP_Values psp_Values = new PSP_Values();
IList<PSP_Values> listValues;
if (baseyear == "")
{
psp_Values.ID = typeFlag2;//��ID�ֶδ��Flag2��ֵ
listValues = Common.Services.BaseService.GetList<PSP_Values>("SelectPSP_ValuesListByFlag2", psp_Values);
}
else
{
Hashtable ha = new Hashtable();
ha.Add("ID", typeFlag2);
ha.Add("Year", Convert.ToInt32(baseyear));
listValues = Common.Services.BaseService.GetList<PSP_Values>("SelectPSP_ValuesListByFlag2Year", ha);
}
foreach (PSP_Values value in listValues)
{
TreeListNode node = treeList1.FindNodeByFieldValue("ID", value.TypeID);
if (node != null)
{
if(Isfirstload) node.SetValue(value.Year + "��",Math.Round(value.Value,2));
SetRateYearValue(node, Math.Round(value.Value,2));
}
}
}
private void barButtonItem14_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (treeList1.FocusedNode == null)
{
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_PowerTypes_Liao psp_Type = new PSP_PowerTypes_Liao();
// Class1.TreeNodeToDataObject<PSP_PowerTypes_Liao>(psp_Type, treeList1.FocusedNode);
PSP_Values PowerValues = new PSP_Values();
PowerValues.TypeID = int.Parse(treeList1.FocusedNode["ID"].ToString());
try
{
//DeletePowerValuesByType里面删除数据和分类
Common.Services.BaseService.Update("DeletePSP_ValuesByType", 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);
//删除后，如果同级还有其它分类，则重新计算此类的所有年份数据
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 LoadHistoryValue()
{
IList<PSP_P_Years> listYears;
if (!formselect)
{
PSP_P_Years psp_Year = new PSP_P_Years();
psp_Year.Flag = forecastReport.ID;
listYears = Common.Services.BaseService.GetList<PSP_P_Years>("SelectPSP_P_YearsListByFlag", psp_Year);
}
else
{
PSP_P_Years psp_Year = new PSP_P_Years();
psp_Year.Flag = forecastReport.ID;
psp_Year.Flag2 = typeFlag;
listYears = Common.Services.BaseService.GetList<PSP_P_Years>("SelectPSP_P_YearsListhaveflag2ByFlag", psp_Year);
}
foreach (PSP_P_Years item in listYears)
{
try
{
dataTable2.Columns.Add(item.Year + "Y", typeof(double));
TreeListColumn column = treeList2.Columns.Add();
column.FieldName = item.Year + "Y";
column.Tag = item.Year;
column.VisibleIndex = -1;
}
catch { }
}
PSP_Values psp_Values = new PSP_Values();
psp_Values.ID = forecastReport.ID;//用ID字段存放Flag2的值
IList<PSP_P_Values> listValues = Common.Services.BaseService.GetList<PSP_P_Values>("SelectPSP_P_ValuesListByFlag2", psp_Values);
foreach (PSP_P_Values value in listValues)
{
TreeListNode node = treeList2.FindNodeByFieldValue("ID", value.TypeID);
if (node != null)
{
node.SetValue(value.Year + "Y", value.Value);
if (value.Year == forecastReport.StartYear)
{
node.SetValue(value.Year + "年", value.Value);
}
}
}
}
private void CalChildNode1(TreeListNode node,ref int i,DataTable dt,DataColumn dc, ref IList<PSP_Values> psplist)
{
i++;
PSP_Values m1=new PSP_Values();
if (dt.Rows[i][dc.ColumnName].ToString() == null || dt.Rows[i][dc.ColumnName].ToString() == "")
{
m1.Year = int.Parse(dc.ColumnName.ToString().Substring(0, 4));
}
else
{
m1.Value = double.Parse(dt.Rows[i][dc.ColumnName].ToString());
m1.Year = int.Parse(dc.ColumnName.ToString().Substring(0, 4));
}
m1.TypeID =int.Parse(node["ID"].ToString());
psplist.Add(m1);
for (int m = 0; m < node.Nodes.Count; m++)
{
CalChildNode1(node.Nodes[m], ref i, dt, dc,ref psplist);
}
}
//��ȡ��ʷ����
private void LoadHistoryValue()
{
PSP_Years psp_Year = new PSP_Years();
psp_Year.Flag = 1;
IList<PSP_Years> listYears = Common.Services.BaseService.GetList<PSP_Years>("SelectPSP_YearsListByFlag", psp_Year);
Hashtable ht = new Hashtable();
foreach (PSP_Years item in listYears)
{
dataTable.Columns.Add(item.Year + "Y", typeof(double));
TreeListColumn column = treeList1.Columns.Add();
column.FieldName = item.Year + "Y";
column.Tag = item.Year;
column.VisibleIndex = -1;
if (!ht.ContainsKey(item.Year + "Y"))
ht.Add(item.Year + "Y", "");
}
PSP_Values psp_Values = new PSP_Values();
foreach (DataRow dr in dataTable.Rows)
{
psp_Values.TypeID = (int)dr["ID"];
IList<PSP_Values> listValues = Common.Services.BaseService.GetList<PSP_Values>("SelectPSP_ValuesList", psp_Values);
foreach (PSP_Values value in listValues)
{
TreeListNode node = treeList1.FindNodeByFieldValue("ID", value.TypeID);
if (node != null)
{
if (!ht.ContainsKey(value.Year + "Y"))
{
dataTable.Columns.Add(value.Year + "Y", typeof(double));
TreeListColumn column = treeList1.Columns.Add();
column.FieldName = value.Year + "Y";
column.Tag = value.Year;
column.VisibleIndex = -1;
ht.Add(value.Year + "Y", "");
}
node.SetValue(value.Year + "Y", value.Value);
if (value.Year == forecastReport.StartYear)
{
node.SetValue(value.Year + "��", value.Value);
}
}
}
}
}
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 LoadHistoryValue()
{
PSP_P_Years psp_Year = new PSP_P_Years();
psp_Year.Flag = forecastReport.ID;
IList<PSP_P_Years> listYears = Common.Services.BaseService.GetList<PSP_P_Years>("SelectPSP_P_YearsListByFlag", psp_Year);
//Hashtable hs = new Hashtable();
//foreach (TreeListColumn tlc in treeList1.Columns)
//{
// if (!hs.ContainsKey(tlc.FieldName))
// hs.Add(tlc.FieldName, "");
//}
Hashtable ht = new Hashtable();
foreach (PSP_P_Years item in listYears)
{
//if (hs.ContainsKey(item.Year + "Y"))
// continue;
dataTable.Columns.Add(item.Year + "Y", typeof(double));
TreeListColumn column = treeList1.Columns.Add();
column.FieldName = item.Year + "Y";
column.Tag = item.Year;
column.VisibleIndex = -1;
if (!ht.ContainsKey(item.Year + "Y"))
ht.Add(item.Year + "Y", "");
}
PSP_Values psp_Values = new PSP_Values();
psp_Values.ID = forecastReport.ID;//��ID�ֶδ��Flag2��ֵ
IList<PSP_P_Values> listValues = Common.Services.BaseService.GetList<PSP_P_Values>("SelectPSP_P_ValuesListByFlag2", psp_Values);
foreach (PSP_P_Values value in listValues)
{
TreeListNode node = treeList1.FindNodeByFieldValue("ID", value.TypeID);
if (node != null)
{
if (!ht.ContainsKey(value.Year + "Y"))
{
dataTable.Columns.Add(value.Year + "Y", typeof(double));
TreeListColumn column = treeList1.Columns.Add();
column.FieldName = value.Year + "Y";
column.Tag = value.Year;
column.VisibleIndex = -1;
ht.Add(value.Year + "Y", "");
}
node.SetValue(value.Year + "Y", value.Value);
if (value.Year == forecastReport.StartYear)
{
node.SetValue(value.Year + "��", value.Value);
}
}
}
}