private void barButtonItem3_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (this.gridView2.FocusedRowHandle >= 0)
{
if (MessageBox.Show("确定删除该类型？", "删除", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
PS_Table_Area_TYPE data = this.gridView2.GetRow(this.gridView2.FocusedRowHandle) as PS_Table_Area_TYPE;// new Ps_Table_GDP();
Common.Services.BaseService.Delete <PS_Table_Area_TYPE>(data);
}
}
InitGrid2();
}
private void barButtonItem8_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
IList <string> filedList = new List <string>();
IList <string> capList = new List <string>();
for (int i = 0; i < gridView2.Columns.Count; i++)
{
if (gridView2.Columns[i].Visible == true)
{
capList.Add(gridView2.Columns[i].Caption);
filedList.Add(gridView2.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)
{
continue;
}
PS_Table_Area_TYPE area = new PS_Table_Area_TYPE();
area.ID += "|" + ProjectID;
area.ProjectID = ProjectID;
foreach (DataColumn col in table.Columns)
{
if (col.ColumnName == "Yearf")
{
area.GetType().GetProperty(col.ColumnName).SetValue(area, int.Parse(table.Rows[i][col].ToString()), null);
}
else
{
area.GetType().GetProperty(col.ColumnName).SetValue(area, table.Rows[i][col].ToString(), null);
}
}
Common.Services.BaseService.Create <PS_Table_Area_TYPE>(area);
}
}
catch { }
InitGrid2();
}
}
//添加类型
private void barButtonItem1_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
FrmAddPN_TYPE frm = new FrmAddPN_TYPE();
frm.SetFrmName = "添加类型";
frm.SetLabelName = "类型名称";
if (frm.ShowDialog() == DialogResult.OK)
{
PS_Table_Area_TYPE data = new PS_Table_Area_TYPE();
data.ID += "|" + ProjectID;
data.ProjectID = ProjectID;
data.Title = frm.ParentName;
data.Col1 = frm.Col1;
Common.Services.BaseService.Create <PS_Table_Area_TYPE>(data);
}
InitGrid2();
}
private void barButtonItem2_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (this.gridView2.FocusedRowHandle >= 0)
{
FrmAddPN_TYPE frm = new FrmAddPN_TYPE();
frm.SetFrmName = "添加类型";
frm.SetLabelName = "类型名称";
frm.ParentName = this.gridView2.GetRowCellValue(this.gridView2.FocusedRowHandle, "Title").ToString();
if (frm.ShowDialog() == DialogResult.OK)
{
PS_Table_Area_TYPE data = this.gridView2.GetRow(this.gridView2.FocusedRowHandle) as PS_Table_Area_TYPE;// new Ps_Table_GDP();
data.Title = frm.ParentName;
data.Col1 = frm.Col1;
Common.Services.BaseService.Update <PS_Table_Area_TYPE>(data);
}
}
InitGrid2();
}
