private void AddDataToList(DataRow node, IList<PSP_ForecastValues> list, DataTable dt)
{
foreach (DataColumn col in dt.Columns)
{
if (col.ColumnName.IndexOf("��") > 0)
{
object obj = node[col.ColumnName];
if (obj != DBNull.Value)
{
PSP_ForecastValues v = new PSP_ForecastValues();
v.ForecastID = forecastReport.ID;
v.TypeID = Convert.ToInt32(node["ID"]);
v.Caption = node["Title"].ToString() + "," + v.TypeID;
v.Year = Convert.ToInt32(col.ColumnName.Replace("��", ""));
v.Value = (double)node[col.ColumnName];
list.Add(v);
}
}
}
}
//��ȡ����
private void LoadValues()
{
PSP_ForecastValues psp_Value = new PSP_ForecastValues();
psp_Value.ForecastID = forecastReport.ID;
IList<PSP_ForecastValues> listValues = Common.Services.BaseService.GetList<PSP_ForecastValues>("SelectPSP_ForecastValuesByForecastID", psp_Value);
foreach (PSP_ForecastValues value in listValues)
{
TreeListNode node = treeList1.FindNodeByFieldValue("ID", value.TypeID);
if (node != null && value.Year >= forecastReport.StartYear && value.Year <= forecastReport.EndYear)
{
node.SetValue(value.Year + "��", value.Value);
}
}
}
//�ѽڵ����ݴ�ŵ������У������List
private void AddNodeDataToList(TreeListNode node, IList<PSP_ForecastValues> list)
{
foreach (TreeListColumn col in treeList1.Columns)
{
if (col.FieldName.IndexOf("��") > 0)
{
object obj = node.GetValue(col.FieldName);
if (obj != DBNull.Value)
{
PSP_ForecastValues v = new PSP_ForecastValues();
v.ForecastID = forecastReport.ID;
v.TypeID = (int)node.GetValue("ID");
v.Caption = node.GetValue("Title").ToString() + "," + v.TypeID;
v.Year = Convert.ToInt32(col.FieldName.Replace("��", ""));
v.Value = (double)node.GetValue(col.FieldName);
list.Add(v);
}
}
}
foreach (TreeListNode nd in node.Nodes)
{
AddNodeDataToList(nd, list);
}
}
//��ȡ����
private void LoadValues()
{
PSP_ForecastReports pf = Services.BaseService.GetOneByKey<PSP_ForecastReports>(typeFlag2);
PSP_ForecastValues psp_Value = new PSP_ForecastValues();
psp_Value.ForecastID = typeFlag2;
IList<PSP_ForecastValues> listValues = Common.Services.BaseService.GetList<PSP_ForecastValues>("SelectPSP_ForecastValuesByForecastID", psp_Value);
foreach (PSP_ForecastValues value in listValues)
{
TreeListNode node = treeList1.FindNodeByFieldValue("ID", value.TypeID);
if (node != null && value.Year >= pf.StartYear && value.Year <= pf.EndYear)
{
node.SetValue(value.Year + "��", value.Value);
}
}
////////PSP_ForecastReports pf = Services.BaseService.GetOneByKey<PSP_ForecastReports>(typeFlag2);
////////string str = " TypeID not in(80001,80002,80003,80004,80005,80006) and Flag2=" + typeFlag2;
////////IList<PSP_P_Values> listValues = Common.Services.BaseService.GetList<PSP_P_Values>("SelectPSP_P_ValuesByWhere", str);
////////foreach (PSP_P_Values value in listValues)
////////{
//////// TreeListNode node = treeList1.FindNodeByFieldValue("ID", value.TypeID);
//////// if (node != null)
//////// {
//////// if (value.Year <= pf.EndYear)
//////// {
//////// value.Value = Math.Round(value.Value);
//////// node.SetValue(value.Year + "��", value.Value);
//////// }
//////// }
////////}
}
//��ȡ����
private void LoadValues()
{
//PSP_P_Values PSP_P_Values = new PSP_P_Values();
//PSP_P_Values.ID = typeFlag2;//��ID�ֶδ��Flag2��ֵ
//IList<PSP_P_Values> listValues = Common.Services.BaseService.GetList<PSP_P_Values>("SelectPSP_P_ValuesListByFlag2", PSP_P_Values);
string str = " TypeID in(80001,80002,80003,80004,80005,80006) and Flag2=" + typeFlag2;
IList<PSP_P_Values> listValues = Common.Services.BaseService.GetList<PSP_P_Values>("SelectPSP_P_ValuesByWhere", str);
foreach (PSP_P_Values value in listValues)
{
TreeListNode node = treeList1.FindNodeByFieldValue("ID", value.TypeID);
if (node != null)
{
node.SetValue(value.Year + "��", value.Value);
}
}
PSP_ForecastValues psp_Value = new PSP_ForecastValues();
psp_Value.ForecastID = typeFlag2;
IList<PSP_ForecastValues> listValues1 = Common.Services.BaseService.GetList<PSP_ForecastValues>("SelectPSP_ForecastValuesByForecastID", psp_Value);
foreach (PSP_ForecastValues value in listValues1)
{
try
{
TreeListNode node = treeList1.FindNodeByFieldValue("ID", value.TypeID);
if (node != null && value.Year >= forecastReport.StartYear && value.Year <= forecastReport.EndYear)
{
node.SetValue(value.Year + "��", value.Value);
}
}
catch { }
}
}
//�ѽڵ����ݴ�ŵ������У������List
private void AddNodeDataToList(TreeListNode node, IList<PSP_ForecastValues> list, bool allCol)
{
for (int i = 1; i < (allCol ? 16 : 13); i++)
{
object obj = node.GetValue(i.ToString() + "��");
double value = 0.0;
if (obj != DBNull.Value)
{
value = (double)obj;
}
PSP_ForecastValues v = new PSP_ForecastValues();
v.ForecastID = forecastReport.ID;
v.TypeID = (int)node.GetValue("TypeID");
v.Caption = node.GetValue("Title").ToString();
v.Year = i;
v.Value = value;
list.Add(v);
}
foreach (TreeListNode nd in node.Nodes)
{
AddNodeDataToList(nd, list, allCol);
}
}
//��ȡ����
private void LoadValues()
{
PSP_ForecastValues psp_Value = new PSP_ForecastValues();
psp_Value.ForecastID = forecastReport.ID;
IList<PSP_ForecastValues> listValues = Common.Services.BaseService.GetList<PSP_ForecastValues>("SelectPSP_ForecastValuesByForecastID", psp_Value);
if (listValues.Count == 0)
{
BurdenMonth bm1 = new BurdenMonth();
bm1.BurdenYear = forecastReport.StartYear;
BurdenMonth bm = (BurdenMonth)Common.Services.BaseService.GetObject("SelectBurdenMonthByBurdenYear", bm1);
if (bm != null)
{
//TreeListNode node = treeList1.FindNodeByFieldValue("TypeID", value.TypeID);
//if (node != null)
//{
// node.SetValue(value.Year + "��", value.Value);
//}
treeList1.MoveFirst();
TreeListNode node = treeList1.FocusedNode;
node.SetValue("1��", bm.Month1);
node.SetValue("2��", bm.Month2);
node.SetValue("3��", bm.Month3);
node.SetValue("4��", bm.Month4);
node.SetValue("5��", bm.Month5);
node.SetValue("6��", bm.Month6);
node.SetValue("7��", bm.Month7);
node.SetValue("8��", bm.Month8);
node.SetValue("9��", bm.Month9);
node.SetValue("10��", bm.Month10);
node.SetValue("11��", bm.Month11);
node.SetValue("12��", bm.Month12);
double bmsum=bm.Month1+bm.Month2+bm.Month3+bm.Month4+bm.Month5+bm.Month6;
bmsum+=bm.Month7+bm.Month8+bm.Month9+bm.Month10+bm.Month11+bm.Month12;
double bmmax = Math.Max(bm.Month1, bm.Month2);
bmmax = Math.Max(bmmax, bm.Month3);
bmmax = Math.Max(bmmax, bm.Month4);
bmmax = Math.Max(bmmax, bm.Month5);
bmmax = Math.Max(bmmax, bm.Month6);
bmmax = Math.Max(bmmax, bm.Month7);
bmmax = Math.Max(bmmax, bm.Month8);
bmmax = Math.Max(bmmax, bm.Month9);
bmmax = Math.Max(bmmax, bm.Month10);
bmmax = Math.Max(bmmax, bm.Month11);
bmmax = Math.Max(bmmax, bm.Month12);
node.SetValue("13��", bmsum);
node.SetValue("14��", bmmax);
node.SetValue("15��", bmsum / (bmmax*12));
}
}
else
{
foreach (PSP_ForecastValues value in listValues)
{
TreeListNode node = treeList1.FindNodeByFieldValue("TypeID", value.TypeID);
if (node != null)
{
node.SetValue(value.Year + "��", value.Value);
}
}
}
}
//读取数据
private void LoadValues()
{
if (!formselect)
{
PSP_ForecastValues psp_Value = new PSP_ForecastValues();
psp_Value.ForecastID = forecastReport.ID;
IList<PSP_ForecastValues> listValues = Common.Services.BaseService.GetList<PSP_ForecastValues>("SelectPSP_ForecastValuesByForecastID", psp_Value);
foreach (PSP_ForecastValues value in listValues)
{
TreeListNode node = treeList2.FindNodeByFieldValue("ID", value.TypeID);
if (node != null && value.Year >= forecastReport.StartYear && value.Year <= forecastReport.EndYear)
{
node.SetValue(value.Year + "年", value.Value);
}
}
}
else
{
string str = "Flag2=" + forecastReport.ID;
IList<PSP_P_Values> listValues = Common.Services.BaseService.GetList<PSP_P_Values>("SelectPSP_P_ValuesByWhere", str);
foreach (PSP_P_Values value in listValues)
{
TreeListNode node = treeList2.FindNodeByFieldValue("ID", value.TypeID);
if (node != null && value.Year >= forecastReport.StartYear && value.Year <= forecastReport.EndYear)
{
node.SetValue(value.Year + "年", value.Value);
}
}
}
}
