private void barButtonItem1_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
DataRow obj = this.gridView1.GetDataRow(this.gridView1.FocusedRowHandle);
if (obj == null)
return;
PSP_P_Values ppv = new PSP_P_Values();
ppv.Flag2 = Convert.ToInt32(obj["ID"]);
ppv.TypeID =80003;
li = Services.BaseService.GetList<PSP_P_Values>("SelectPSP_P_ValuesByTypeIDFlag2", ppv);
this.DialogResult = DialogResult.OK;
}
private void GetFFData(int sid,string type,string title)
{
FormXiaoshi_Fs ffs = new FormXiaoshi_Fs();
ffs.Type = type;
ffs.ForecastReports = forecastReport;
if (ffs.ShowDialog() != DialogResult.OK)
return;
Hashtable hs = ffs.HS;
if (hs.Count != 3)
return;
int uid = (int)hs["H1"];
TreeListNode tn = (TreeListNode)hs["H2"];
bool bool1 = (bool)hs["H3"];
PSP_P_Types pt=new PSP_P_Types();
if (bool1)
{
PSP_Types pt1 = Services.BaseService.GetOneByKey<PSP_Types>(uid);
InitTypes(pt1, pt);
}
else
{
pt = Services.BaseService.GetOneByKey<PSP_P_Types>(uid);
}
#region �趨types
string str2 = " ID=" + sid + " and Flag='" + typeFlag + "' and Flag2='" + forecastReport.ID + "' ";
IList listTypes = Common.Services.BaseService.GetList("SelectPSP_P_TypesByWhere", str2);
if (listTypes.Count != 0)
{
PSP_P_Values ppvvv = new PSP_P_Values();
ppvvv.TypeID = sid;
ppvvv.Flag2 = forecastReport.ID;
Services.BaseService.Update("DeletePSP_P_ValuesByType", ppvvv);
}
pt.ID = sid;
pt.Flag2 = forecastReport.ID;
pt.Flag = typeFlag;
pt.Title = title;
Services.BaseService.Create<PSP_P_Types>(pt);
#endregion
#region �趨year value
Hashtable hta = new Hashtable();
ArrayList al = new ArrayList();
foreach (TreeListColumn tlc in tn.TreeList.Columns)
{
if (tlc.FieldName.IndexOf("��") >= 0)
{
int year = 0;
try
{
year=int.Parse(tlc.FieldName.Replace("��", ""));
}
catch { }
if (year != 0 && year > forecastReport.EndYear)
continue;
hta.Add(Guid.NewGuid().ToString(), year);
try
{
PSP_P_Values pv = new PSP_P_Values();
pv.Year=year;
pv.TypeID=sid;
try
{
pv.Value = double.Parse(tn[tlc.FieldName].ToString());
}
catch { }
pv.Flag2 = forecastReport.ID;
Services.BaseService.Create<PSP_P_Values>(pv);
}
catch { }
try
{
PSP_P_Years ppy = new PSP_P_Years();
ppy.Flag = forecastReport.ID;
ppy.Flag2 = typeFlag;
ppy.Year = year;
Services.BaseService.Create<PSP_P_Years>(ppy);
}
catch (Exception ex)
{
//MessageBox.Show(ex.Message);
}
}
}
for (int m = forecastReport.StartYear; m <= forecastReport.EndYear; m++)
{
if (!hta.ContainsValue(m))
{
try
{
PSP_P_Years ppy = new PSP_P_Years();
ppy.Flag = forecastReport.ID;
ppy.Flag2 = typeFlag;
ppy.Year = m;
Services.BaseService.Create<PSP_P_Years>(ppy);
}
catch (Exception ex)
{ //MessageBox.Show(ex.Message);
}
}
}
#endregion
Application.DoEvents();
this.Cursor = Cursors.WaitCursor;
treeList1.BeginUpdate();
LoadData();
treeList1.EndUpdate();
this.Cursor = Cursors.Default;
Compute();
RefreshChart();
}
private void barButtonItem13_ItemClick_1(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_P_Values psp_Values = new PSP_P_Values();
psp_Values.ID = forecastReport.ID;//����ID���Դ��Flag2
psp_Values.Year = (int)treeList1.FocusedColumn.Tag;
try
{
//DeletePSP_ValuesByYearɾ�����ݺ����
int colIndex = treeList1.FocusedColumn.AbsoluteIndex;
Common.Services.BaseService.Update("DeletePSP_P_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];
RefreshChart();
}
catch (Exception ex)
{
MsgBox.Show("ɾ�������" + ex.Message);
}
}
//�ѽڵ����ݴ�ŵ������У������List
private void AddNodeDataToList(TreeListNode node, IList<PSP_P_Values> list)
{
foreach (TreeListColumn col in treeList1.Columns)
{
if (col.FieldName.IndexOf("��") > 0)
{
object obj = node.GetValue(col.FieldName);
if (obj != DBNull.Value)
{
PSP_P_Values v = new PSP_P_Values();
v.Flag2 = 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);
}
}
}
}
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 Compute()
{
int year=0;
double d1=0;
double d2=0;
double d3=0;
double d4=0;
foreach (DataColumn dc in dataTable.Columns)
{
if (dc.ColumnName.IndexOf("��") >= 0)
{
try
{
year = int.Parse(dc.ColumnName.Replace("��", ""));
if (year <= forecastReport.StartYear)
{
//try
//{d1 = (double)dataTable.Rows[0][dc.ColumnName];}
//catch { }
if (dataTable.Rows[0][dc.ColumnName] != DBNull.Value && dataTable.Rows[0][dc.ColumnName] != null)
if (dataTable.Rows[0][dc.ColumnName].ToString() == "")
d1 = 0;
else
d1 = Convert.ToInt32(dataTable.Rows[0][dc.ColumnName]);
//try
//{d3 = (double)dataTable.Rows[2][dc.ColumnName];}
//catch { }
if (dataTable.Rows[2][dc.ColumnName] != DBNull.Value && dataTable.Rows[2][dc.ColumnName] != null)
if (dataTable.Rows[2][dc.ColumnName].ToString() == "")
d3 = 0;
else
d3 = Convert.ToInt32(dataTable.Rows[2][dc.ColumnName]);
if (d3 != 0)
{
PSP_P_Values value = new PSP_P_Values();
value.Year = year;
value.TypeID = 80005;
value.Flag2 = forecastReport.ID;
value.Value = Math.Round(d1 / d3);
Services.BaseService.Update<PSP_P_Values>(value);
if(dataTable.Rows.Count>3)
dataTable.Rows[3][dc.ColumnName] = Math.Round(d1 / d3);
}
//try
//{
// if (d3 != 0)
// {
// PSP_P_Values value = new PSP_P_Values();
// value.Year = year;
// value.TypeID = 80005;
// value.Flag2 = forecastReport.ID;
// value.Value = Math.Round(d1 / d3);
// Services.BaseService.Update<PSP_P_Values>(value);
// dataTable.Rows[3][dc.ColumnName] = Math.Round(d1 / d3);
// }
//}
//catch { }
}
else
{
//try
//{d1 = (double)dataTable.Rows[0][dc.ColumnName];}
//catch { }
if (dataTable.Rows[0][dc.ColumnName] != DBNull.Value && dataTable.Rows[0][dc.ColumnName] != null)
if (dataTable.Rows[0][dc.ColumnName].ToString() == "")
d1 = 0;
else
d1 = Convert.ToInt32(dataTable.Rows[0][dc.ColumnName]);
if (dataTable.Rows.Count > 3)
{
if (dataTable.Rows[3][dc.ColumnName] != DBNull.Value && dataTable.Rows[3][dc.ColumnName] != null)
if (dataTable.Rows[3][dc.ColumnName].ToString() == "")
d3 = 0;
else
d3 = Convert.ToInt32(dataTable.Rows[3][dc.ColumnName]);
}
else
d3 = 0;
//try
//{d3 = (double)dataTable.Rows[3][dc.ColumnName];}
//catch { d3 = 0; }
//try
//{
// if (d3 != 0)
// dataTable.Rows[2][dc.ColumnName] = Math.Round( d1 / d3);
//}
//catch { }
if (d3 != 0)
{
dataTable.Rows[2][dc.ColumnName] = Math.Round(d1 / d3);
}
}
}
catch { }
}
}
}
//��ȡ����
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);
foreach (PSP_P_Values value in listValues)
{
TreeListNode node = treeList1.FindNodeByFieldValue("ID", value.TypeID);
if (node != null)
{
node.SetValue(value.Year + "��", value.Value);
}
}
}
