private void barButtonItem4_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (this.gridView2.FocusedRowHandle >= 0)
{
FrmAddPowerState frm = new FrmAddPowerState();
frm.Area = this;
frm.Text = "添加记录";
frm.IsCreate = true;
frm.ProjectID = ProjectID;
string f = this.gridView2.GetRowCellValue(this.gridView2.FocusedRowHandle, "Title").ToString();
if (f == "现状")
{
f = "1";
}
else if (f == "规划")
{
f = "2";
}
frm.Flag = f;
PSP_PowerSubstationInfo obj = new PSP_PowerSubstationInfo();
obj.UID = Guid.NewGuid().ToString();
frm.Object = obj;
if (frm.ShowDialog() == DialogResult.OK)
{
frm.Close();
InitGrid1();
}
}
else
{
MessageBox.Show("请先选择规划或现状", "添加", MessageBoxButtons.OK);
}
}
private void barButtonItem5_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (this.gridView1.FocusedRowHandle >= 0)
{
FrmAddPowerState frm = new FrmAddPowerState();
frm.Text = "修改记录";
frm.ProjectID = ProjectID;
string f = this.gridView2.GetRowCellValue(this.gridView2.FocusedRowHandle, "Title").ToString();
if (f == "现状")
{
f = "1";
}
else if (f == "规划")
{
f = "2";
}
frm.Flag = f;
PSP_PowerSubstationInfo obj = this.gridView1.GetRow(this.gridView1.FocusedRowHandle) as PSP_PowerSubstationInfo;
frm.Object = obj;
if (frm.ShowDialog() == DialogResult.OK)
{
frm.Close();
InitGrid1();
}
}
else
{
MessageBox.Show("请先选择一条记录", "修改", MessageBoxButtons.OK);
}
}
private void barButtonItem8_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (this.gridView2.FocusedRowHandle > -1)
{
IList <string> filedList = new List <string>();
IList <string> capList = new List <string>();
for (int i = 0; i < gridView1.Columns.Count; i++)
{
capList.Add(gridView1.Columns[i].Caption);
filedList.Add(gridView1.Columns[i].FieldName);
}
OpenFileDialog op = new OpenFileDialog();
op.Filter = "Excel文件(*.xls)|*.xls";
if (op.ShowDialog() == DialogResult.OK)
{
try
{
DataTable table = OperTable.GetExcel(op.FileName, filedList, capList);
for (int i = 0; i < table.Rows.Count; i++)
{
if (table.Rows[i][0].ToString().IndexOf("合计") > 0 || table.Rows[i][1].ToString().IndexOf("合计") > 0)
{
continue;
}
PSP_PowerSubstationInfo area = new PSP_PowerSubstationInfo();
area.UID = Guid.NewGuid().ToString() + "|" + ProjectID;
area.AreaID = ProjectID;
area.CreateDate = DateTime.Now;
string f = this.gridView2.GetRowCellValue(this.gridView2.FocusedRowHandle, "Title").ToString();
if (f == "现状")
{
f = "1";
}
else if (f == "规划")
{
f = "2";
}
area.Flag = f;
foreach (DataColumn col in table.Columns)
{
area.GetType().GetProperty(col.ColumnName).SetValue(area, table.Rows[i][col].ToString(), null);
}
Common.Services.BaseService.Create <PSP_PowerSubstationInfo>(area);
}
}
catch (Exception a) { MessageBox.Show(a.Message); }
InitGrid1();
}
}
else
{
MessageBox.Show("没有选择规划或现状", "导入EXCEL", MessageBoxButtons.OK);
}
}
public void InitGrid2()
{
IList <PSP_PowerSubstationInfo> list = new List <PSP_PowerSubstationInfo>();
PSP_PowerSubstationInfo info = new PSP_PowerSubstationInfo();
info.Title = "现状";
list.Add(info);
PSP_PowerSubstationInfo info1 = new PSP_PowerSubstationInfo();
info1.Title = "规划";
list.Add(info1);
this.gridControl2.DataSource = list;
}
private void barButtonItem6_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (this.gridView1.FocusedRowHandle >= 0)
{
if (MessageBox.Show("确定删除该记录？", "删除", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
PSP_PowerSubstationInfo data = this.gridView1.GetRow(this.gridView1.FocusedRowHandle) as PSP_PowerSubstationInfo;// new PSP_PowerSubstationInfo();
string conn = "UID='" + data.UID + "'";
Common.Services.BaseService.Update("DeletePSP_PowerSubstationInfoByConn", conn);
}
}
InitGrid1();
}
private void btnOK_Click(object sender, EventArgs e)
{
if (SaveRecord())
{
if (checkEdit1.Checked)
{
area.InitGrid1();
_obj = new PSP_PowerSubstationInfo();
_obj.UID = Guid.NewGuid().ToString();
IList <PSP_PowerSubstationInfo> list1 = new List <PSP_PowerSubstationInfo>();
list1.Add(_obj);
this.vGridControl.DataSource = list1;
}
else
{
DialogResult = DialogResult.OK;
}
}
}
/// <summary>
/// 写入数据
/// </summary>
/// <param name="obj"></param>
/// <param name="IntRow"></param>
private void WriteData(FarPoint.Win.Spread.SheetView obj, int IntRow)
{
PSP_PowerSubstationInfo ppi = null;
for (int i = IntRow; i < (list.Count + IntRow); ++i)
{
ppi = (PSP_PowerSubstationInfo)list[i - IntRow];
for (int j = 0; j < obj.ColumnCount; ++j)
{
switch (j)
{
case 0://序号
obj.SetValue(i, j, (i - IntRow + 1));
break;
case 1://项目名称
obj.SetValue(i, j, ppi.Title);
break;
case 2://类型
obj.SetValue(i, j, ppi.S10);
break;
case 3://容量
obj.SetValue(i, j, ppi.S2);
break;
case 4://接入电压等级
obj.SetValue(i, j, ppi.S1);
break;
case 5://投产时间,2010
if (ppi.S3 == "2010")
{
obj.SetValue(i, j, "是");
}
break;
case 6://投产时间,2011
if (ppi.S3 == "2011")
{
obj.SetValue(i, j, "是");
}
break;
case 7://投产时间,2012
if (ppi.S3 == "2012")
{
obj.SetValue(i, j, "是");
}
break;
case 8://投产时间,2013
if (ppi.S3 == "2013")
{
obj.SetValue(i, j, "是");
}
break;
case 9://投产时间,2014
if (ppi.S3 == "2014")
{
obj.SetValue(i, j, "是");
}
break;
case 10://投产时间,2015
if (ppi.S3 == "2015")
{
obj.SetValue(i, j, "是");
}
break;
default:
break;
}
}
}
}
