private void barButtonItem3_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
string columnname = "";
try
{
DataTable dts = new DataTable();
OpenFileDialog op = new OpenFileDialog();
op.Filter = "Excel文件(*.xls)|*.xls";
if (op.ShowDialog() == DialogResult.OK)
{
dts = GetExcel(op.FileName);
IList <PSP_PlanTable_HuaiBei> lii = new List <PSP_PlanTable_HuaiBei>();
DateTime dt = DateTime.Now;
for (int i = 0; i < dts.Rows.Count; i++)
{
PSP_PlanTable_HuaiBei li = new PSP_PlanTable_HuaiBei();
// li.Title = dts.Rows[i][0].ToString();
li.Flag = typeflag;
li.UID = Guid.NewGuid().ToString();
li.CreateDate = dt.AddSeconds(i);
li.ParentID = ctrlItemPlanTable_HuaiBei1.FocusedObject.DY;
// li.S1 = dts.Rows[i][1].ToString();
foreach (DataColumn dc in dts.Columns)
{
columnname = dc.ColumnName;
if (dts.Rows[i][dc.ColumnName].ToString() == "")
{
continue;
}
string LL2 = "";
try
{
LL2 = dts.Rows[i][dc.ColumnName].ToString();
}
catch { }
li.GetType().GetProperty(dc.ColumnName).SetValue(li, LL2, null);
}
lii.Add(li);
}
foreach (PSP_PlanTable_HuaiBei lll in lii)
{
Services.BaseService.Create <PSP_PlanTable_HuaiBei>(lll);
}
this.ctrlItemPlanTable_HuaiBei1.RefreshData1();
}
}
catch { MessageBox.Show(columnname + "导入格式不正确！"); }
}
private void gridControl_Validating(object sender, CancelEventArgs e)
{
PSP_PlanTable_HuaiBei obj = FocusedObject;
if (obj == null)
{
return;
}
}
/// <summary>
/// 删除焦点对象
/// </summary>
public void DeleteObject()
{
//获取焦点对象
PSP_PlanTable_HuaiBei obj = FocusedObject;
if (obj == null)
{
return;
}
if (obj.KeyFlag == "time1" || obj.KeyFlag == "time2" || obj.KeyFlag == "time3" || obj.KeyFlag == "220" || obj.KeyFlag == "110" || obj.KeyFlag == "kuojian" || obj.KeyFlag == "220千伏" || obj.KeyFlag == "110千伏")
{
MsgBox.Show("此行为固定行不允许删除！");
return;
}
//请求确认
if (MsgBox.ShowYesNo(Strings.SubmitDelete) != DialogResult.Yes)
{
return;
}
//执行删除操作
try
{
// Services.BaseService.Delete<PSP_PowerSubstationInfo>(obj);
Services.BaseService.Delete <PSP_PlanTable_HuaiBei>(obj);
}
catch (Exception exc)
{
Debug.Fail(exc.Message);
HandleException.TryCatch(exc);
return;
}
this.bandedGridView1.BeginUpdate();
//记住当前焦点行索引
int iOldHandle = this.bandedGridView1.FocusedRowHandle;
//从链表中删除
ObjectList.Remove(obj);
//刷新表格
gridControl.RefreshDataSource();
//设置新的焦点行索引
GridHelper.FocuseRowAfterDelete(this.bandedGridView1, iOldHandle);
RefreshData1();
this.bandedGridView1.EndUpdate();
}
/// <summary>
/// 修改焦点对象
/// </summary>
public void UpdateObject()
{
//获取焦点对象
PSP_PlanTable_HuaiBei obj = FocusedObject;
if (obj == null)
{
return;
}
//创建对象的一个副本
PSP_PlanTable_HuaiBei objCopy = new PSP_PlanTable_HuaiBei();
DataConverter.CopyTo <PSP_PlanTable_HuaiBei>(obj, objCopy);
//执行修改操作
using (FrmPSP_PlanTable_HuaiBeiDialog dlg = new FrmPSP_PlanTable_HuaiBeiDialog())
{
dlg.IsSelect = isselect;
dlg.Type = types1;
dlg.Flag = flags1;
dlg.Type2 = types2;
dlg.Text = "修改项目计划表";
//// dlg.ctrlPSP_PowerSubstationInfo = this;
//int[] a = this.GridView.SetFocusedRowCellValue(.GetSelectedRows(); //传递实体类过去 获取选中的行
//LAA.AssetGuid = this.GridView.GetRowCellValue(a[0], ).ToString();//获取选中行的内容
dlg.Object = objCopy; //绑定副本
if (dlg.ShowDialog() != DialogResult.OK)
{
return;
}
}
//用副本更新焦点对象
DataConverter.CopyTo <PSP_PlanTable_HuaiBei>(objCopy, obj);
//刷新表格
RefreshData1();
gridControl.RefreshDataSource();
}
//private IList<PSP_PlanTable_HuaiBei> tablelist(DataSet ds)
//{
// PSP_PlanTable_HuaiBei t = default(PSP_PlanTable_HuaiBei);
// ds.Tables[0].TableName = typeof(T).Name;
// string str = ds.GetXml();
// XmlDocument xd = new XmlDocument();
// xd.LoadXml(str);
// XmlNodeList xls = xd.SelectNodes("/" + typeof(PSP_PlanTable_HuaiBei).Name.ToString() + "s/" + typeof(PSP_PlanTable_HuaiBei).Name.ToString());
// IList<PSP_PlanTable_HuaiBei> ts = new List<PSP_PlanTable_HuaiBei>();
// foreach (XmlNode xn in xls)
// {
// string str1 = xn.OuterXml;
// System.Xml.Serialization.XmlSerializer xms = new XmlSerializer(typeof(PSP_PlanTable_HuaiBei));
// System.IO.MemoryStream m = new System.IO.MemoryStream();
// System.IO.StreamWriter sw = new System.IO.StreamWriter(m);
// sw.Write(str1);
// sw.Flush();
// m.Position = 0;
// t = (PSP_PlanTable_HuaiBei)xms.Deserialize(m);
// ts.Add(t);
// }
// if (null != ts)
// return ts;
// else
// return null;
//}
/// <summary>
/// 添加对象
/// </summary>
public void AddObject(string flag)
{
// 检查对象链表是否已经加载
if (ObjectList == null)
{
return;
}
//新建对象
PSP_PlanTable_HuaiBei obj = new PSP_PlanTable_HuaiBei();
obj.Flag2 = flags1;
obj.CreateDate = DateTime.Now;
//执行添加操作
using (FrmPSP_PlanTable_HuaiBeiDialog dlg = new FrmPSP_PlanTable_HuaiBeiDialog())
{
dlg.Type = types1;
dlg.Flag = flags1;
dlg.Type2 = types2;
//// dlg.ctrlPSP_PowerSubstationInfo = this;
dlg.Text = "添加项目计划表";
dlg.IsCreate = true; //设置新建标志
dlg.Object = obj;
if (dlg.ShowDialog() != DialogResult.OK)
{
return;
}
}
//将新对象加入到链表中
ObjectList.Add(obj);
//刷新表格，并将焦点行定位到新对象上。
gridControl.RefreshDataSource();
RefreshData1();
GridHelper.FocuseRow(this.bandedGridView1, obj);
}
private void simpleButton1_Click(object sender, EventArgs e)
{
if (textEdit1.Text == string.Empty)
{
MsgBox.Show("请输入计划表名称！");
return;
}
if (_isEdit)//修改
{
}
else//新建
{
psp_ForecastReport = new PowerEachList();
psp_ForecastReport.Types = _typeFlag;
}
psp_ForecastReport.ListName = textEdit1.Text;
DateTime dt = DateTime.Now;
if (dateEdit1.Text == null || dateEdit1.Text == "")
{
dateEdit1.Text = dt.ToString();
}
if (Convert.ToDateTime(dateEdit1.Text) > dt)
{
psp_ForecastReport.CreateDate = dt;
}
else
{
psp_ForecastReport.CreateDate = Convert.ToDateTime(dateEdit1.Text);
}
psp_ForecastReport.Remark = memoEdit1.Text;
if (_isEdit)
{
try
{
Common.Services.BaseService.Update <PowerEachList>(psp_ForecastReport);
}
catch
{
MsgBox.Show("修改计划表出错！");
return;
}
}
else
{
try
{ PSP_PlanTable_HuaiBei plan = new PSP_PlanTable_HuaiBei();
PowerEachList obj = (PowerEachList)Common.Services.BaseService.GetObject("SelectPowerEachListListByTypesAndListName", psp_ForecastReport);
if (obj != null)
{
MsgBox.Show("已经存在此项目表名称！");
return;
}
Common.Services.BaseService.Create <PowerEachList>(psp_ForecastReport);
PowerEachList oo = (PowerEachList)Common.Services.BaseService.GetObject("SelectPowerEachListListByTypesAndListName", psp_ForecastReport);
DateTime dtt = new DateTime();
dtt = DateTime.Now;
plan.UID = Guid.NewGuid().ToString();
plan.Title = "时间间隔";
plan.Flag2 = oo.UID;
plan.ParentID = "0";
plan.KeyFlag = "time1";
plan.ItemSB = "0";
plan.ItemPF = "0";
plan.KYWC = "0";
plan.KYPS = "0";
plan.PSYJ = "0";
// plan.CSSC = "0";
// plan.JSGFSSB = "0";
// plan.ZBSB = "0";
// plan.ZBSHDateTime = "0";
////plan.CSSC = DateTime.Now;
////plan.JSGFSSB = DateTime.Now;
////plan.ZBSB = DateTime.Now;
////plan.ZBSHDateTime = DateTime.Now;
plan.XZYJS = "0";
plan.HPPF = "0";
plan.TDYS = "0";
plan.SBHZSQ = "0";
plan.XMHZ = "0";
plan.JHKSDateTime = "0";
plan.JHTCDateTime = "0";
//plan.JHTCDateTime_GuiHua = DateTime.Now;
plan.CreateDate = dtt.AddSeconds(1);
Common.Services.BaseService.Create <PSP_PlanTable_HuaiBei>(plan);
plan.UID = Guid.NewGuid().ToString();
plan.Title = "220千伏输变电工程";
plan.Flag2 = oo.UID;
plan.ParentID = "0";
plan.KeyFlag = "220";
plan.ItemSB = "";
plan.ItemPF = "";
plan.KYWC = "";
plan.KYPS = "";
plan.PSYJ = "";
//plan.CSSC = DateTime.Now;
//plan.JSGFSSB = DateTime.Now;
//plan.ZBSB = DateTime.Now;
//plan.ZBSHDateTime = DateTime.Now;
plan.XZYJS = "";
plan.HPPF = "";
plan.TDYS = "";
plan.SBHZSQ = "";
plan.XMHZ = "";
plan.JHKSDateTime = "";
plan.JHTCDateTime = "";
plan.JHTCDateTime_GuiHua = DateTime.Now;
plan.CreateDate = dtt.AddSeconds(2);
Common.Services.BaseService.Create <PSP_PlanTable_HuaiBei>(plan);
plan.UID = Guid.NewGuid().ToString();
plan.Title = "时间间隔";
plan.Flag2 = oo.UID;
plan.ParentID = "0";
plan.KeyFlag = "time2";
plan.ItemSB = "0";
plan.ItemPF = "0";
plan.KYWC = "0";
plan.KYPS = "0";
plan.PSYJ = "0";
//plan.CSSC = DateTime.Now;
//plan.JSGFSSB = DateTime.Now;
//plan.ZBSB = DateTime.Now;
//plan.ZBSHDateTime = DateTime.Now;
plan.XZYJS = "0";
plan.HPPF = "0";
plan.TDYS = "0";
plan.SBHZSQ = "0";
plan.XMHZ = "0";
plan.JHKSDateTime = "0";
plan.JHTCDateTime = "0";
plan.JHTCDateTime_GuiHua = null;
plan.CreateDate = dtt.AddSeconds(3);
Common.Services.BaseService.Create <PSP_PlanTable_HuaiBei>(plan);
plan.UID = Guid.NewGuid().ToString();
plan.Title = "110千伏输变电工程";
plan.Flag2 = oo.UID;
plan.ParentID = "0";
plan.KeyFlag = "110";
plan.ItemSB = "";
plan.ItemPF = "";
plan.KYWC = "";
plan.KYPS = "";
plan.PSYJ = "";
//plan.CSSC = DateTime.Now;
//plan.JSGFSSB = DateTime.Now;
//plan.ZBSB = DateTime.Now;
//plan.ZBSHDateTime = DateTime.Now;
plan.XZYJS = "";
plan.HPPF = "";
plan.TDYS = "";
plan.SBHZSQ = "";
plan.XMHZ = "";
plan.JHKSDateTime = "";
plan.JHTCDateTime = "";
plan.JHTCDateTime_GuiHua = DateTime.Now;
plan.CreateDate = dtt.AddSeconds(4);
Common.Services.BaseService.Create <PSP_PlanTable_HuaiBei>(plan);
plan.UID = Guid.NewGuid().ToString();
plan.Title = "时间间隔";
plan.Flag2 = oo.UID;
plan.ParentID = "0";
plan.KeyFlag = "time3";
plan.ItemSB = "0";
plan.ItemPF = "0";
plan.KYWC = "0";
plan.KYPS = "0";
plan.PSYJ = "0";
//plan.CSSC = DateTime.Now;
//plan.JSGFSSB = DateTime.Now;
//plan.ZBSB = DateTime.Now;
//plan.ZBSHDateTime = DateTime.Now;
plan.XZYJS = "0";
plan.HPPF = "0";
plan.TDYS = "0";
plan.SBHZSQ = "0";
plan.XMHZ = "0";
plan.JHKSDateTime = "0";
plan.JHTCDateTime = "0";
plan.JHTCDateTime_GuiHua = null;
plan.CreateDate = dtt.AddSeconds(5);
Common.Services.BaseService.Create <PSP_PlanTable_HuaiBei>(plan);
plan.UID = Guid.NewGuid().ToString();
plan.Title = "扩建工程";
plan.Flag2 = oo.UID;
plan.ParentID = "0";
plan.KeyFlag = "kuojian";
plan.ItemSB = "";
plan.ItemPF = "";
plan.KYWC = "";
plan.KYPS = "";
plan.PSYJ = "";
//plan.CSSC = DateTime.Now;
//plan.JSGFSSB = DateTime.Now;
//plan.ZBSB = DateTime.Now;
//plan.ZBSHDateTime = DateTime.Now;
plan.XZYJS = "";
plan.HPPF = "";
plan.TDYS = "";
plan.SBHZSQ = "";
plan.XMHZ = "";
plan.JHKSDateTime = "";
plan.JHTCDateTime = "";
plan.JHTCDateTime_GuiHua = DateTime.Now;
plan.CreateDate = dtt.AddSeconds(6);
Common.Services.BaseService.Create <PSP_PlanTable_HuaiBei>(plan);
plan.UID = Guid.NewGuid().ToString();
plan.Title = "220千伏部分";
plan.Flag2 = oo.UID;
plan.ParentID = "0";
plan.KeyFlag = "220千伏";
plan.ItemSB = "";
plan.ItemPF = "";
plan.KYWC = "";
plan.KYPS = "";
plan.PSYJ = "";
//plan.CSSC = DateTime.Now;
//plan.JSGFSSB = DateTime.Now;
//plan.ZBSB = DateTime.Now;
//plan.ZBSHDateTime = DateTime.Now;
plan.XZYJS = "";
plan.HPPF = "";
plan.TDYS = "";
plan.SBHZSQ = "";
plan.XMHZ = "";
plan.JHKSDateTime = "";
plan.JHTCDateTime = "";
plan.JHTCDateTime_GuiHua = null;
plan.CreateDate = dtt.AddSeconds(7);
Common.Services.BaseService.Create <PSP_PlanTable_HuaiBei>(plan);
plan.UID = Guid.NewGuid().ToString();
plan.Title = "110千伏部分";
plan.Flag2 = oo.UID;
plan.ParentID = "0";
plan.KeyFlag = "110千伏";
plan.ItemSB = "";
plan.ItemPF = "";
plan.KYWC = "";
plan.KYPS = "";
plan.PSYJ = "";
//plan.CSSC = DateTime.Now;
//plan.JSGFSSB = DateTime.Now;
//plan.ZBSB = DateTime.Now;
//plan.ZBSHDateTime = DateTime.Now;
plan.XZYJS = "";
plan.HPPF = "";
plan.TDYS = "";
plan.SBHZSQ = "";
plan.XMHZ = "";
plan.JHKSDateTime = "";
plan.JHTCDateTime = "";
plan.JHTCDateTime_GuiHua = null;
plan.CreateDate = dtt.AddSeconds(8);
Common.Services.BaseService.Create <PSP_PlanTable_HuaiBei>(plan); }
catch
{
MsgBox.Show("新建计划表出错！");
return;
}
}
DialogResult = DialogResult.OK;
}
private void barDel1_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
GridColumn gc = this.ctrlItemPlanTable_HuaiBei1.GridView.FocusedColumn;
if (gc == null)
{
return;
}
if (gc.FieldName.Substring(0, 1) != "S")
{
MsgBox.Show("不能删除固定列");
return;
}
bool bl = false;
for (int i = 0; i < ctrlItemPlanTable_HuaiBei1.GridView.VisibleColumns.Count; i++)
{
if (gc.Caption == ctrlItemPlanTable_HuaiBei1.GridView.VisibleColumns[i].Caption)
{
if (MsgBox.ShowYesNo("是否删除 " + gc.Caption + " 的所有数据？") != DialogResult.Yes)
{
return;
}
bl = true;
break;
}
else
{
bl = false;
}
}
if (bl == true)
{
int colIndex = ctrlItemPlanTable_HuaiBei1.GridView.FocusedColumn.VisibleIndex;
foreach (GridBand gc1 in ctrlItemPlanTable_HuaiBei1.bandedGridView1.Bands)
{
try
{
if (gc1.Columns[0].Name == gc.Name)
{
gc1.Visible = false;
}
}
catch { }
}
gc.Visible = false;
gc.OptionsColumn.ShowInCustomizationForm = false;
PSP_PlanTable_HuaiBei si = new PSP_PlanTable_HuaiBei();
si.Title = gc.FieldName + "=''";
si.Flag2 = flag;
Itop.Client.Common.Services.BaseService.Update("UpdatePSP_PlanTable_HuaiBeiByFlag", si);
PowerSubstationLine psl = new PowerSubstationLine();
psl.ClassType = gc.FieldName;
psl.Flag = flag;
psl.Type = type;
psl.Title = gc.Caption;
psl.Type2 = "PlanTable";
Itop.Client.Common.Services.BaseService.Update("DeletePowerSubstationLineByAll", psl);
if (colIndex >= ctrlItemPlanTable_HuaiBei1.GridView.VisibleColumns.Count)
{
colIndex--;
}
ctrlItemPlanTable_HuaiBei1.GridView.FocusedColumn = ctrlItemPlanTable_HuaiBei1.GridView.VisibleColumns[colIndex];
}
else
{
return;
}
}
/// <summary>
/// 刷新表格中的数据
/// </summary>
/// <returns>ture:成功 false:失败</returns>
public bool RefreshData1()
{
IList list1 = new ArrayList();
IList list2 = new ArrayList();
IList list3 = new ArrayList();
try
{
IList <PSP_PlanTable_HuaiBei> listTypes = Services.BaseService.GetList <PSP_PlanTable_HuaiBei>("SelectPSP_PlanTable_HuaiBeiByFlag2", flags1);
listTypes.RemoveAt(listTypes.Count - 1);
//list1 = Common.Services.BaseService.GetList("SelectPSP_PlanTable_HuaiBeiByFlag2", flags1);
//list1.RemoveAt(listTypes.Count - 1);
listTypes[6].XuHao = "一";
for (int j = 0; j < 6; j = j + 2)
{
DateTime date = new DateTime();
listTypes[j + 1].XuHao = "1";
try
{
//if (listTypes[j].JHTCDateTime_GuiHua == null || listTypes[j].JHTCDateTime_GuiHua == "")
// listTypes[j].JHTCDateTime_GuiHua = "0";
listTypes[j + 1].JHTCDateTime_GuiHua = listTypes[j + 1].JHTCDateTime_GuiHua;
// date = Convert.ToDateTime(listTypes[j + 1].JHTCDateTime_GuiHua).AddMonths(-int.Parse(listTypes[j].JHTCDateTime_GuiHua));
//if (listTypes[j + 1].JHTCDateTime_GuiHua == null )
listTypes[j + 1].JHTCDateTime = Convert.ToDateTime(listTypes[j + 1].JHTCDateTime_GuiHua).ToString("yyyy年MM月");
}
catch { }
try
{
date = Convert.ToDateTime(listTypes[j + 1].JHTCDateTime).AddMonths(-int.Parse(listTypes[j].JHTCDateTime));
listTypes[j + 1].JHKSDateTime = date.ToString("yyyy年MM月");
}
catch { }
try
{
date = Convert.ToDateTime(listTypes[j + 1].JHKSDateTime).AddMonths(-int.Parse(listTypes[j].JHKSDateTime));
listTypes[j + 1].XMHZ = date.ToString("yyyy年MM月");
}
catch { }
try
{
date = Convert.ToDateTime(listTypes[j + 1].XMHZ).AddMonths(-int.Parse(listTypes[j].XMHZ));
listTypes[j + 1].SBHZSQ = date.ToString("yyyy年MM月");
}
catch { }
try
{
date = Convert.ToDateTime(listTypes[j + 1].SBHZSQ).AddMonths(-int.Parse(listTypes[j].SBHZSQ));
listTypes[j + 1].TDYS = date.ToString("yyyy年MM月");
}
catch { }
try
{
date = Convert.ToDateTime(listTypes[j + 1].TDYS).AddMonths(-int.Parse(listTypes[j].TDYS));
listTypes[j + 1].HPPF = date.ToString("yyyy年MM月");
}
catch { }
try
{
date = Convert.ToDateTime(listTypes[j + 1].HPPF).AddMonths(-int.Parse(listTypes[j].HPPF));
listTypes[j + 1].XZYJS = date.ToString("yyyy年MM月");
}
catch { }
/////////////////////////////////////////////
//try
//{
// date = Convert.ToDateTime(listTypes[j + 1].CSSC);
// listTypes[j + 1].CSSC = date.ToString("yyyy年MM月dd日");
//}
//catch { }
//try
//{
// date = Convert.ToDateTime(listTypes[j + 1].JSGFSSB);
// listTypes[j + 1].JSGFSSB = date.ToString("yyyy年MM月dd日");
//}
//catch { }
//try
//{
// date = Convert.ToDateTime(listTypes[j + 1].ZBSB);
// listTypes[j + 1].ZBSB = date.ToString("yyyy年MM月dd日");
//}
//catch { }
//try
//{
// date = Convert.ToDateTime(listTypes[j + 1].ZBSHDateTime);
// listTypes[j + 1].ZBSHDateTime = date.ToString("yyyy年MM月dd日");
//}
//catch { }
//中间空出4个，无计算过程
try
{
date = Convert.ToDateTime(listTypes[j + 1].XZYJS).AddMonths(-int.Parse(listTypes[j].XZYJS));
listTypes[j + 1].PSYJ = date.ToString("yyyy年MM月");
}
catch { }
try
{
date = Convert.ToDateTime(listTypes[j + 1].PSYJ).AddMonths(-int.Parse(listTypes[j].PSYJ));
listTypes[j + 1].KYPS = date.ToString("yyyy年MM月");
}
catch { }
try
{
date = Convert.ToDateTime(listTypes[j + 1].KYPS).AddMonths(-int.Parse(listTypes[j].KYPS));
listTypes[j + 1].KYWC = date.ToString("yyyy年MM月");
}
catch { }
try
{
date = Convert.ToDateTime(listTypes[j + 1].KYWC).AddMonths(-int.Parse(listTypes[j].KYWC));
listTypes[j + 1].ItemPF = date.ToString("yyyy年MM月");
}
catch { }
try
{
date = Convert.ToDateTime(listTypes[j + 1].ItemPF).AddMonths(-int.Parse(listTypes[j].ItemPF));
listTypes[j + 1].ItemSB = date.ToString("yyyy年MM月");
}
catch { }
}
//220千伏部分
//list2 = Common.Services.BaseService.GetList("SelectPSP_PlanTable_HuaiBeiByFlag2AND220", flags1);
IList <PSP_PlanTable_HuaiBei> listTypes1 = Services.BaseService.GetList <PSP_PlanTable_HuaiBei>("SelectPSP_PlanTable_HuaiBeiByFlag2AND220", flags1);
for (int k = 0; k < listTypes1.Count; k++)
{
DateTime date = new DateTime();
try
{
//if (listTypes[0].JHTCDateTime_GuiHua == null || listTypes[0].JHTCDateTime_GuiHua == "")
// listTypes[0].JHTCDateTime_GuiHua = "0";
listTypes1[k].JHTCDateTime_GuiHua = listTypes1[k].JHTCDateTime_GuiHua;
//date = Convert.ToDateTime(listTypes1[k].JHTCDateTime_GuiHua).AddMonths(-int.Parse(listTypes[0].JHTCDateTime_GuiHua));
// if (listTypes1[k].JHTCDateTime_GuiHua == null )
listTypes1[k].JHTCDateTime = Convert.ToDateTime(listTypes1[k].JHTCDateTime_GuiHua).ToString("yyyy年MM月");
//if (DateTime.Now.Month >= DateTime.Parse(listTypes1[k].JHTCDateTime).Month)
//{
//}
}
catch { }
try
{
date = Convert.ToDateTime(listTypes1[k].JHTCDateTime).AddMonths(-int.Parse(listTypes[0].JHTCDateTime));
listTypes1[k].JHKSDateTime = date.ToString("yyyy年MM月");
}
catch { }
try
{
date = Convert.ToDateTime(listTypes1[k].JHKSDateTime).AddMonths(-int.Parse(listTypes[0].JHKSDateTime));
listTypes1[k].XMHZ = date.ToString("yyyy年MM月");
}
catch { }
try
{
date = Convert.ToDateTime(listTypes1[k].XMHZ).AddMonths(-int.Parse(listTypes[0].XMHZ));
listTypes1[k].SBHZSQ = date.ToString("yyyy年MM月");
}
catch { }
try
{
date = Convert.ToDateTime(listTypes1[k].SBHZSQ).AddMonths(-int.Parse(listTypes[0].SBHZSQ));
listTypes1[k].TDYS = date.ToString("yyyy年MM月");
}
catch { }
try
{
date = Convert.ToDateTime(listTypes1[k].TDYS).AddMonths(-int.Parse(listTypes[0].TDYS));
listTypes1[k].HPPF = date.ToString("yyyy年MM月");
}
catch { }
try
{
date = Convert.ToDateTime(listTypes1[k].HPPF).AddMonths(-int.Parse(listTypes[0].HPPF));
listTypes1[k].XZYJS = date.ToString("yyyy年MM月");
}
catch { }
/////////////////////////////////////////////
////try
////{
//// date = Convert.ToDateTime(listTypes1[k].CSSC);
//// listTypes1[k].CSSC = date.ToString("yyyy年MM月dd日");
////}
////catch { }
////try
////{
//// date = Convert.ToDateTime(listTypes1[k].JSGFSSB);
//// listTypes1[k].JSGFSSB = date.ToString("yyyy年MM月dd日");
////}
////catch { }
////try
////{
//// date = Convert.ToDateTime(listTypes1[k].ZBSB);
//// listTypes1[k].ZBSB = date.ToString("yyyy年MM月dd日");
////}
////catch { }
////try
////{
//// date = Convert.ToDateTime(listTypes1[k].ZBSHDateTime);
//// listTypes1[k].ZBSHDateTime = date.ToString("yyyy年MM月dd日");
////}
////catch { }
//中间空出4个，无计算过程
try
{
date = Convert.ToDateTime(listTypes1[k].XZYJS).AddMonths(-int.Parse(listTypes[0].XZYJS));
listTypes1[k].PSYJ = date.ToString("yyyy年MM月");
}
catch { }
try
{
date = Convert.ToDateTime(listTypes1[k].PSYJ).AddMonths(-int.Parse(listTypes[0].PSYJ));
listTypes1[k].KYPS = date.ToString("yyyy年MM月");
}
catch { }
try
{
date = Convert.ToDateTime(listTypes1[k].KYPS).AddMonths(-int.Parse(listTypes[0].KYPS));
listTypes1[k].KYWC = date.ToString("yyyy年MM月");
}
catch { }
try
{
date = Convert.ToDateTime(listTypes1[k].KYWC).AddMonths(-int.Parse(listTypes[0].KYWC));
listTypes1[k].ItemPF = date.ToString("yyyy年MM月");
}
catch { }
try
{
date = Convert.ToDateTime(listTypes1[k].ItemPF).AddMonths(-int.Parse(listTypes[0].ItemPF));
listTypes1[k].ItemSB = date.ToString("yyyy年MM月");
}
catch { }
}
//计算220千伏部分某几列的合计值
double sum = 0;
double sum1 = 0;
double sum2 = 0;
for (int kk = 0; kk < listTypes1.Count; kk++)
{
if (listTypes1[kk].Line220 == null || listTypes1[kk].Line220 == "")
{
listTypes1[kk].Line220 = "0";
}
sum = sum + double.Parse(listTypes1[kk].Line220);
listTypes[6].Line220 = sum.ToString();
if (listTypes1[kk].BD220 == null || listTypes1[kk].BD220 == "")
{
listTypes1[kk].BD220 = "0";
}
sum1 = sum1 + double.Parse(listTypes1[kk].BD220);
listTypes[6].BD220 = sum1.ToString();
if (listTypes1[kk].TZGM == null || listTypes1[kk].TZGM == "")
{
listTypes1[kk].TZGM = "0";
}
sum2 = sum2 + double.Parse(listTypes1[kk].TZGM);
listTypes[6].TZGM = sum2.ToString();
}
int xuhao = 0;
foreach (PSP_PlanTable_HuaiBei psp in listTypes1)
{
xuhao++;
psp.XuHao = xuhao.ToString();
listTypes.Add(psp);
}
foreach (PSP_PlanTable_HuaiBei psp in list2)
{
list1.Add(psp);
}
//110千伏部分
//list3 = Services.BaseService.GetList("SelectPSP_PlanTable_HuaiBeiByFlag2AND110", flags1);
IList <PSP_PlanTable_HuaiBei> listTypes2 = Services.BaseService.GetList <PSP_PlanTable_HuaiBei>("SelectPSP_PlanTable_HuaiBeiByFlag2AND110", flags1);
PSP_PlanTable_HuaiBei obb = (PSP_PlanTable_HuaiBei)Common.Services.BaseService.GetObject("SelectPSP_PlanTable_HuaiBeiByFlag2ANDKeyFlag", flags1);
for (int k2 = 0; k2 < listTypes2.Count; k2++)
{
DateTime date = new DateTime();
try
{
//if (listTypes[0].JHTCDateTime_GuiHua == null || listTypes[0].JHTCDateTime_GuiHua == "")
// listTypes[0].JHTCDateTime_GuiHua = "0";
listTypes2[k2].JHTCDateTime_GuiHua = listTypes2[k2].JHTCDateTime_GuiHua;
// date = Convert.ToDateTime(listTypes2[k2].JHTCDateTime_GuiHua).AddMonths(-int.Parse(listTypes[2].JHTCDateTime_GuiHua));
// if (listTypes2[k2].JHTCDateTime_GuiHua == null )
listTypes2[k2].JHTCDateTime = Convert.ToDateTime(listTypes2[k2].JHTCDateTime_GuiHua).ToString("yyyy年MM月");
}
catch { }
try
{
date = Convert.ToDateTime(listTypes2[k2].JHTCDateTime).AddMonths(-int.Parse(listTypes[2].JHTCDateTime));
listTypes2[k2].JHKSDateTime = date.ToString("yyyy年MM月");
}
catch { }
try
{
date = Convert.ToDateTime(listTypes2[k2].JHKSDateTime).AddMonths(-int.Parse(listTypes[2].JHKSDateTime));
listTypes2[k2].XMHZ = date.ToString("yyyy年MM月");
}
catch { }
try
{
date = Convert.ToDateTime(listTypes2[k2].XMHZ).AddMonths(-int.Parse(listTypes[2].XMHZ));
listTypes2[k2].SBHZSQ = date.ToString("yyyy年MM月");
}
catch { }
try
{
date = Convert.ToDateTime(listTypes2[k2].SBHZSQ).AddMonths(-int.Parse(listTypes[2].SBHZSQ));
listTypes2[k2].TDYS = date.ToString("yyyy年MM月");
}
catch { }
try
{
date = Convert.ToDateTime(listTypes2[k2].TDYS).AddMonths(-int.Parse(listTypes[2].TDYS));
listTypes2[k2].HPPF = date.ToString("yyyy年MM月");
}
catch { }
try
{
date = Convert.ToDateTime(listTypes2[k2].HPPF).AddMonths(-int.Parse(listTypes[2].HPPF));
listTypes2[k2].XZYJS = date.ToString("yyyy年MM月");
}
catch { }
/////////////////////////////////////////////
////try
////{
//// date = Convert.ToDateTime(listTypes2[k2].CSSC);
//// listTypes2[k2].CSSC = date.ToString("yyyy年MM月dd日");
////}
////catch { }
////try
////{
//// date = Convert.ToDateTime(listTypes2[k2].JSGFSSB);
//// listTypes2[k2].JSGFSSB = date.ToString("yyyy年MM月dd日");
////}
////catch { }
////try
////{
//// date = Convert.ToDateTime(listTypes2[k2].ZBSB);
//// listTypes2[k2].ZBSB = date.ToString("yyyy年MM月dd日");
////}
////catch { }
////try
////{
//// date = Convert.ToDateTime(listTypes2[k2].ZBSHDateTime);
//// listTypes2[k2].ZBSHDateTime = date.ToString("yyyy年MM月dd日");
////}
////catch { }
//中间空出4个，无计算过程
try
{
date = Convert.ToDateTime(listTypes2[k2].XZYJS).AddMonths(-int.Parse(listTypes[2].XZYJS));
listTypes2[k2].PSYJ = date.ToString("yyyy年MM月");
}
catch { }
try
{
date = Convert.ToDateTime(listTypes2[k2].PSYJ).AddMonths(-int.Parse(listTypes[2].PSYJ));
listTypes2[k2].KYPS = date.ToString("yyyy年MM月");
}
catch { }
try
{
date = Convert.ToDateTime(listTypes2[k2].KYPS).AddMonths(-int.Parse(listTypes[2].KYPS));
listTypes2[k2].KYWC = date.ToString("yyyy年MM月");
}
catch { }
try
{
date = Convert.ToDateTime(listTypes2[k2].KYWC).AddMonths(-int.Parse(listTypes[2].KYWC));
listTypes2[k2].ItemPF = date.ToString("yyyy年MM月");
}
catch { }
try
{
date = Convert.ToDateTime(listTypes2[k2].ItemPF).AddMonths(-int.Parse(listTypes[2].ItemPF));
listTypes2[k2].ItemSB = date.ToString("yyyy年MM月");
}
catch { }
}
//计算110千伏部分某几列的合计值
sum = 0;
sum1 = 0;
sum2 = 0;
for (int m = 0; m < listTypes2.Count; m++)
{
if (listTypes2[m].Line110 == null || listTypes2[m].Line110 == "")
{
listTypes2[m].Line110 = "0";
}
sum = sum + double.Parse(listTypes2[m].Line110);
obb.Line110 = sum.ToString();
if (listTypes2[m].BD110 == null || listTypes2[m].BD110 == "")
{
listTypes2[m].BD110 = "0";
}
sum1 = sum1 + double.Parse(listTypes2[m].BD110);
obb.BD110 = sum1.ToString();
if (listTypes2[m].TZGM == null || listTypes2[m].TZGM == "")
{
listTypes2[m].TZGM = "0";
}
sum2 = sum2 + double.Parse(listTypes2[m].TZGM);
obb.TZGM = sum2.ToString();
}
obb.XuHao = "二";
listTypes.Add(obb);
//list1.Add(obb);
xuhao = 0;
foreach (PSP_PlanTable_HuaiBei psp in listTypes2)
{
xuhao++;
psp.XuHao = xuhao.ToString();
listTypes.Add(psp);
}
foreach (PSP_PlanTable_HuaiBei psp in listTypes)
{
list1.Add(psp);
}
////设置计划投产时间（规划）的格式
//listTypes[1].JHTCDateTime_GuiHua = listTypes[1].JHTCDateTime_GuiHua.ToString("yyyy年MM月");
//listTypes[n].JHTCDateTime_GuiHua = listTypes[n].JHTCDateTime_GuiHua.ToString("yyyy年MM月");
//listTypes[n].JHTCDateTime_GuiHua = listTypes[n].JHTCDateTime_GuiHua.ToString("yyyy年MM月");
//for (int n = 7; n < listTypes.Count; n++)
//{
// listTypes[n].JHTCDateTime_GuiHua=listTypes[n].JHTCDateTime_GuiHua.ToString("yyyy年MM月");
//}
this.gridControl.DataSource = listTypes;
//mn=DT.Rows[0][0].ToString();
dt = Itop.Common.DataConverter.ToDataTable(list1, typeof(PSP_PlanTable_HuaiBei));
al.Clear();
for (int h = 0; h < dt.Columns.Count; h++)
{
al.Add(dt.Columns[h].ColumnName);
}
//for (int I = 0; I < bandedGridView1.VisibleColumns.Count; I++)
bandedGridView1.GetVisibleColumn(1).AppearanceCell.ForeColor = Color.Red;
//bandedGridView1.GetRowCellValue(1, aaa);
//PSP_PlanTable_HuaiBei dd = bandedGridView1.GetRow() as PSP_PlanTable_HuaiBei;
}
catch (Exception exc)
{
Debug.Fail(exc.Message);
HandleException.TryCatch(exc);
return(false);
}
return(true);
}
