private void barExplorYear_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (gridtable == null) return; IList<PJ_clcrkd> datalist = new List<PJ_clcrkd>(); foreach (DataRow dr in gridtable.Rows) { PJ_clcrkd pc = new PJ_clcrkd(); 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_clcrkd where (type = '工程材料入库单' or type = '工程材料入库单原始库存') "; //if (fys.ShowDialog() == DialogResult.OK) //{ ExportCJSCTZEdit etdjh = new ExportCJSCTZEdit(); etdjh.ExportExcel(datalist); //} }
private void btView_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { //IList<PJ_clcrkd> datalist = gridView1.DataSource as IList<PJ_clcrkd>; IList<PJ_clcrkd> datalist =new List<PJ_clcrkd>(); foreach(DataRow dr in gridtable.Rows) { PJ_clcrkd pc =new PJ_clcrkd (); 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_clcrkd where (type = '工程材料入库单' or type = '工程材料入库单原始库存') "; //if (fys.ShowDialog() == DialogResult.OK) //{ ExportCJSCTZEdit etdjh = new ExportCJSCTZEdit(); etdjh.ExportExcel(datalist); //} }