private void barExplorYear_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (gridtable == null) return;
IList<PJ_wgclcrkd> datalist = new List<PJ_wgclcrkd>();
foreach (DataRow dr in gridtable.Rows)
{
PJ_wgclcrkd pc = new PJ_wgclcrkd();
foreach (DataColumn dc in gridtable.Columns)
{
if (dc.ColumnName.IndexOf("wpjz") < 0 && dc.ColumnName.IndexOf("xh") < 0 && dr[dc.ColumnName].ToString() != string.Empty)
pc.GetType().GetProperty(dc.ColumnName).SetValue(pc, dr[dc.ColumnName], null);
}
datalist.Add(pc);
}
//fys.strType = " and (type = '工程材料入库单' or type = '工程材料入库单原始库存') ";
//fys.StrSQL = "select distinct ssgc from PJ_wgclcrkd where (type = '工程材料入库单' or type = '工程材料入库单原始库存') ";
//if (fys.ShowDialog() == DialogResult.OK)
//{
ExportWGSCTZEdit etdjh = new ExportWGSCTZEdit();
etdjh.ExportExcel(datalist);
//}
}
private void btView_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) {
//IList<PJ_wgclcrkd> datalist = gridView1.DataSource as IList<PJ_wgclcrkd>;
if (gridtable == null) return;
IList<PJ_wgclcrkd> datalist = new List<PJ_wgclcrkd>();
foreach (DataRow dr in gridtable.Rows)
{
PJ_wgclcrkd pc = new PJ_wgclcrkd();
foreach (DataColumn dc in gridtable.Columns)
{
if (dc.DataType.FullName.IndexOf("wpjz") < 0)
pc.GetType().GetProperty(dc.ColumnName).SetValue(pc, dr[dc.ColumnName], null);
}
datalist.Add(pc);
}
frmProjectSelect fys = new frmProjectSelect();
//fys.strType = " and (type = '工程材料入库单' or type = '工程材料入库单原始库存') ";
//fys.StrSQL = "select distinct ssgc from PJ_wgclcrkd where (type = '工程材料入库单' or type = '工程材料入库单原始库存') ";
//if (fys.ShowDialog() == DialogResult.OK)
//{
ExportWGSCTZEdit etdjh = new ExportWGSCTZEdit();
etdjh.ExportExcel(datalist);
//}
}
