public Form10Forecast(PSP_ForecastReports fr, int tf)
{
InitializeComponent();
forecastReport = fr;
typeFlag = tf;
Text = fr.Title;
}
private void Form8_Load(object sender, EventArgs e)
{
HideToolBarButton();
PSP_ForecastReports report = new PSP_ForecastReports();
report.Flag = typeFlag;
IList listReports = Common.Services.BaseService.GetList("SelectPSP_ForecastReportsByFlag", report);
dataTable = Itop.Common.DataConverter.ToDataTable(listReports, typeof(PSP_ForecastReports));
gridView1.BeginUpdate();
gridControl1.DataSource = dataTable;
gridView1.Columns["ID"].Visible = false;
gridView1.Columns["ID"].OptionsColumn.ShowInCustomizationForm = false;
gridView1.Columns["Flag"].Visible = false;
gridView1.Columns["Flag"].OptionsColumn.ShowInCustomizationForm = false;
gridView1.Columns["Title"].Caption = "预测名称";
gridView1.Columns["Title"].Width = 300;
gridView1.Columns["StartYear"].Caption = "起始年份";
//gridView1.Columns["StartYear"].Width = 150;
gridView1.Columns["EndYear"].Caption = "结束年份";
//gridView1.Columns["EndYear"].Width = 150;
gridView1.Columns["HistoryYears"].Caption = "历史年数";
//gridView1.Columns["HistoryYears"].Width = 150;
gridView1.EndUpdate();
}
private void EditReport()
{
if (gridView1.FocusedRowHandle < 0)
{
return;
}
if (!base.EditRight)
{
MsgBox.Show("您没有权限进行此项操作！");
return;
}
PSP_ForecastReports report = Itop.Common.DataConverter.RowToObject <PSP_ForecastReports>(gridView1.GetDataRow(gridView1.FocusedRowHandle));
FormForecastReport frm = new FormForecastReport();
frm.IsEdit = true;
frm.Psp_ForecastReport = report;
frm.Text = "修改预测";
if (frm.ShowDialog() == DialogResult.OK)
{
Itop.Common.DataConverter.ObjectToRow(frm.Psp_ForecastReport, gridView1.GetDataRow(gridView1.FocusedRowHandle));
}
}
/// <summary>
/// 添加对象
/// </summary>
public void AddObject()
{
//检查对象链表是否已经加载
if (ObjectList == null)
{
return;
}
//新建对象
PSP_ForecastReports obj = new PSP_ForecastReports();
//执行添加操作
using (FrmPSP_ForecastReportsDialog dlg = new FrmPSP_ForecastReportsDialog())
{
dlg.IsCreate = true; //设置新建标志
dlg.Object = obj;
if (dlg.ShowDialog() != DialogResult.OK)
{
return;
}
}
//将新对象加入到链表中
ObjectList.Add(obj);
//刷新表格，并将焦点行定位到新对象上。
gridControl.RefreshDataSource();
GridHelper.FocuseRow(this.gridView, obj);
}
private void OpenForecast()
{
if (gridView1.FocusedRowHandle < 0)
{
return;
}
PSP_ForecastReports report = Itop.Common.DataConverter.RowToObject <PSP_ForecastReports>(gridView1.GetDataRow(gridView1.FocusedRowHandle));
Form10Forecast frm = new Form10Forecast(report, typeFlag);
frm.CanEdit = base.EditRight;
frm.CanPrint = base.PrintRight;
frm.IsSelect = IsSelect;
DialogResult dr = frm.ShowDialog();
if (IsSelect && dr == DialogResult.OK)
{
Gcontrol = frm.gridControl1;
Unit = "单位：万千瓦";
Title = report.Title;
DialogResult = DialogResult.OK;
}
}
/// <summary>
/// 修改焦点对象
/// </summary>
public void UpdateObject()
{
//获取焦点对象
PSP_ForecastReports obj = FocusedObject;
if (obj == null)
{
return;
}
//创建对象的一个副本
PSP_ForecastReports objCopy = new PSP_ForecastReports();
DataConverter.CopyTo <PSP_ForecastReports>(obj, objCopy);
//执行修改操作
using (FrmPSP_ForecastReportsDialog dlg = new FrmPSP_ForecastReportsDialog())
{
dlg.Object = objCopy; //绑定副本
if (dlg.ShowDialog() != DialogResult.OK)
{
return;
}
}
//用副本更新焦点对象
DataConverter.CopyTo <PSP_ForecastReports>(objCopy, obj);
//刷新表格
gridControl.RefreshDataSource();
}
private void ShowDetails()
{
if (gridView1.FocusedRowHandle < 0)
{
return;
}
PSP_ForecastReports report = Itop.Common.DataConverter.RowToObject <PSP_ForecastReports>(gridView1.GetDataRow(gridView1.FocusedRowHandle));
try
{
FrmXiaoshi frm = new FrmXiaoshi(report, typeFlag);
frm.CanPrint = base.PrintRight;
frm.CanEdit = base.EditRight;
frm.PRintRight = PrintRight;
frm.EDitRight = EditRight;
frm.ADdRight = AddRight;
frm.DEleteRight = DeleteRight;
//frm.IsSelect = IsSelect;
DialogResult dr = frm.ShowDialog();
if (IsSelect && dr == DialogResult.OK)
{
//Title = report.Title;
//Unit = "单位：万千瓦时";
//Gcontrol = frm.GridControl;
DialogResult = DialogResult.OK;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
private void ShowDetails()
{
if (gridView1.FocusedRowHandle < 0)
{
return;
}
PSP_ForecastReports report = Itop.Common.DataConverter.RowToObject <PSP_ForecastReports>(gridView1.GetDataRow(gridView1.FocusedRowHandle));
Form8Forecast frm = new Form8Forecast(report, typeFlag);
frm.CanPrint = base.PrintRight;
frm.CanEdit = base.EditRight;
frm.IsSelect = IsSelect;
frm.ADdRight = AddRight;
frm.DEleteRight = DeleteRight;
DialogResult dr = frm.ShowDialog();
if (IsSelect && dr == DialogResult.OK)
{
Title = report.Title;
Unit = "单位：万千瓦时";
Gcontrol = frm.GridControl;
DialogResult = DialogResult.OK;
}
}
private void barButtonItem3_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (gridView1.FocusedRowHandle < 0)
{
return;
}
if (!base.DeleteRight)
{
MsgBox.Show("您没有权限进行此项操作！");
return;
}
if (MsgBox.ShowYesNo("是否删除 " + gridView1.GetDataRow(gridView1.FocusedRowHandle)["Title"])
== DialogResult.No)
{
return;
}
PSP_ForecastReports report = Itop.Common.DataConverter.RowToObject <PSP_ForecastReports>(gridView1.GetDataRow(gridView1.FocusedRowHandle));
try
{
Common.Services.BaseService.Delete <PSP_ForecastReports>(report);
gridView1.DeleteRow(gridView1.FocusedRowHandle);
}
catch (Exception ex)
{
MsgBox.Show("删除出错：" + ex.Message);
}
}
private void simpleButton1_Click(object sender, EventArgs e)
{
if (textEdit1.Text == string.Empty)
{
MsgBox.Show("请输入预测名称！");
return;
}
if (_isEdit)//修改
{
}
else//新建
{
psp_ForecastReport = new PSP_ForecastReports();
psp_ForecastReport.Flag = _typeFlag;
psp_ForecastReport.ProjectID = _projectid;
}
psp_ForecastReport.Title = textEdit1.Text;
psp_ForecastReport.StartYear = (int)spinEdit1.Value;
psp_ForecastReport.EndYear = (int)spinEdit2.Value;
psp_ForecastReport.HistoryYears = (int)spinEdit3.Value;
if (psp_ForecastReport.EndYear < psp_ForecastReport.StartYear + 1)
{
MsgBox.Show("结束年份应该大于起始年份至少1年！");
return;
}
if (_isEdit)
{
try
{
Common.Services.BaseService.Update <PSP_ForecastReports>(psp_ForecastReport);
}
catch
{
MsgBox.Show("修改预测出错！");
return;
}
}
else
{
try
{
psp_ForecastReport.ID = (int)Common.Services.BaseService.Create <PSP_ForecastReports>(psp_ForecastReport);
}
catch
{
MsgBox.Show("新建预测出错！");
return;
}
}
DialogResult = DialogResult.OK;
}
void GridView_FocusedRowChanged(object sender, DevExpress.XtraGrid.Views.Base.FocusedRowChangedEventArgs e)
{
PSP_ForecastReports ct = (PSP_ForecastReports)this.ctrlPSP_ForecastReports1.GridView.GetRow(this.ctrlPSP_ForecastReports1.GridView.FocusedRowHandle);
typeFlag2 = ct.ID;
Application.DoEvents();
this.Cursor = Cursors.WaitCursor;
treeList1.BeginUpdate();
LoadData();
treeList1.EndUpdate();
this.Cursor = Cursors.Default;
}
//读取数据
private void LoadValues()
{
PSP_ForecastReports pf = Services.BaseService.GetOneByKey <PSP_ForecastReports>(typeFlag2);
string str = " TypeID in(80001,80002,80003) 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);
}
}
}
}
/// <summary>
/// 删除焦点对象
/// </summary>
public void DeleteObject()
{
//获取焦点对象
PSP_ForecastReports obj = FocusedObject;
if (obj == null)
{
return;
}
//请求确认
if (MsgBox.ShowYesNo(Strings.SubmitDelete) != DialogResult.Yes)
{
return;
}
//执行删除操作
try
{
Services.BaseService.Delete <PSP_ForecastReports>(obj);
}
catch (Exception exc)
{
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 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 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;
}
public FrmXiaoshi_jgbijiao(PSP_ForecastReports fr)
{
InitializeComponent();
forecastReport = fr;
}
public Form9Forecast_Profess(int flag2, PSP_ForecastReports fr)
{
typeFlag2 = flag2;
forecastReport = fr;
InitializeComponent();
}
private void LoadData()
{
if (dataTable != null)
{
dataTable.Columns.Clear();
treeList1.Columns.Clear();
}
//PSP_P_Types psp_Type = new PSP_P_Types();
//psp_Type.Flag2 = typeFlag2;
//IList listTypes = Common.Services.BaseService.GetList("SelectPSP_P_TypesByFlag2", psp_Type);
//dataTable = Itop.Common.DataConverter.ToDataTable(listTypes, typeof(PSP_P_Types));
//////string str = " Flag!='" + typeFlag + "' and Flag2='" + typeFlag2+ "' ";
//////IList listTypes = Common.Services.BaseService.GetList("SelectPSP_P_TypesByWhere", str);
//////dataTable = Itop.Common.DataConverter.ToDataTable(listTypes, typeof(PSP_P_Types));
PSP_P_Types psp_Type = new PSP_P_Types();
psp_Type.Flag2 = typeFlag2;
IList listTypes = Common.Services.BaseService.GetList("SelectPSP_P_TypesByFlag2", psp_Type);
dataTable = Itop.Common.DataConverter.ToDataTable(listTypes, typeof(PSP_P_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;
PSP_ForecastReports pf = Services.BaseService.GetOneByKey <PSP_ForecastReports>(typeFlag2);
//string str1 = " flag=" + typeFlag2;
//IList<PSP_P_Years> listyears = Common.Services.BaseService.GetList<PSP_P_Years>("SelectPSP_P_YearsByWhere", str1);
//foreach (PSP_P_Years pppy in listyears)
//{
// if (pppy.Year <= pf.EndYear)
// {
// AddColumn(pppy.Year);
// }
//}
for (int i = pf.StartYear; i <= pf.EndYear; i++)
{
AddColumn(i);
}
Application.DoEvents();
try
{
LoadValues();
}
catch { }
treeList1.ExpandAll();
}
public FormProfessionalMethod_kim(int flag2, PSP_ForecastReports fr)
{
typeFlag2 = flag2;
forecastReport = fr;
InitializeComponent();
}
