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; } } } }