private void btView_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { //IList<PJ_clcrkd> datalist = gridView1.DataSource as IList<PJ_clcrkd>; 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.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) //{ ExportSCTZEdit etdjh = new ExportSCTZEdit(); etdjh.ExportExcel(datalist); //} }
private void SubmitButton_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { frmModleSubmit fm = new frmModleSubmit(); fm.RecordWorkFlowData = WorkFlowData; fm.CurrRecord = currRecord; if (currRecord.Status == "申报") fm.Status = "add"; else fm.Status = "edit"; fm.Kind = currRecord.Kind; frmProjectSelect fys = new frmProjectSelect(); fys.strType = " and (type = '工程材料出库单' ) "; fys.StrSQL = "select distinct ssgc from PJ_clcrkd where (type = '工程材料出库单' ) "; if (fys.ShowDialog() == DialogResult.OK) { ExportCLCKEdit export = new ExportCLCKEdit(); export.CurrRecord = currRecord; export.IsWorkflowCall = isWorkflowCall; export.ParentTemple = parentTemple; export.RecordWorkFlowData = WorkFlowData; export.ExportExcelSubmit(ref parentTemple, "", fys.strProject, fys.strFenproject, false); fm.ParentTemple = parentTemple; if (fm.ShowDialog() == DialogResult.OK) { if (fjly == null) fjly = new frmModleFjly(); fjly.btn_Submit_Click(sender, e); if (MainHelper.UserOrg.OrgName.IndexOf("局") == -1) export.ExportExceljhbAllSubmitToWF_ModleRecordWorkTaskIns("", fys.strProject, fys.strFenproject); else export.ExportExceljhbAllSubmitToWF_ModleRecordWorkTaskIns("", fys.strProject, fys.strFenproject); gridControl1.FindForm().Close(); } } }
private void barExplorYear_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { frmProjectSelect fys = new frmProjectSelect(); fys.strType = " and (type = '工程材料出库单' ) "; fys.StrSQL = "select distinct ssgc from PJ_clcrkd where (type = '工程材料出库单') "; if (fys.ShowDialog() == DialogResult.OK) { ExportCLCKEdit etdjh = new ExportCLCKEdit(); etdjh.ExportExcelProjectCKD("", fys.strProject, fys.strFenproject); } }
private void btView_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { //IList<PJ_clrkysd> datalist = gridView1.DataSource as IList<PJ_clrkysd>; frmProjectSelect fys = new frmProjectSelect(); fys.strType = " and 1=1"; fys.StrSQL = "select distinct ssgc from PJ_clrkysd where 1=1"; if (fys.ShowDialog() == DialogResult.OK) { ExportCLRKYSEdit etdjh = new ExportCLRKYSEdit(); etdjh.ExportExcelProjectCKD(parentID,fys.strProject,fys.strFenproject); } }