Ejemplo n.º 1
0
        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);
            //}
           
           
           
        }
Ejemplo n.º 2
0
        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();
                }
            }
        }
Ejemplo n.º 3
0
 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);
     }
 }
Ejemplo n.º 4
0
        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);
            }
           
           
           
        }