视频在线学习模块很多功能哦

最新推荐文章于 2022-10-07 11:21:45 发布
最新推荐文章于 2022-10-07 11:21:45 发布
阅读量306 收藏
点赞数
原文链接：https://my.oschina.net/u/3736209/blog/1581364
版权 
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Drawing;
using System.Data;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using DevExpress.XtraGrid.Views.Grid;
using System.IO;
using AxWMPLib;
using DBClenitHandle;
using DevExpress.XtraTab;
using DevExpress.XtraEditors;
using DIFautomaticTool.View.traning_model;

namespace DIFautomaticTool.View
{
    public partial class ctlDIFVideo : UserControl
    {
        public ctlDIFVideo()
        {
            InitializeComponent();
        }

        private void gridControlVideo_DoubleClick(object sender, EventArgs e)
        {
            try
            {
                GridView gvi = sender as GridView;
                int _indexx1 = gridView1.FocusedRowHandle;
                string path = gridView1.GetRowCellValue(_indexx1, "COURSEPATH").ToString();
                string avi = ".avi";
                string pdf = ".pdf";
               
                   
              
                if (path.Contains(pdf))
                {
                    FileInfo file = new FileInfo(path);
                    file.Attributes = FileAttributes.ReadOnly;
                    // System.Diagnostics.Process.Start(sp2);
                    DXPdfView PDF = new DXPdfView(path);
                    PDF.Show();
                }
                else
                {
                    DirectoryInfo thefolder = new DirectoryInfo(path);
                    List<string> filelist = new List<string>();
                    filelist.AddRange(Directory.GetFiles(thefolder.FullName, "*.avi").ToList());
                    List<string> listvideo = new List<string>();
                    foreach (string item in filelist)
                    {
                        listvideo.Add(item.Replace(path, ""));
                    }
                    listBoxControlvideoSelect.Items.Clear();
                    listBoxControlvideoSelect.Items.AddRange(listvideo.ToArray());
                    AxWindowsMediaPlayer player = new AxWindowsMediaPlayer();
                    player.Name = "player";
                    xtraTabPageVideo.Controls.Add(player);
                    player.Dock = DockStyle.Fill;
                }
            }
            catch (Exception ex)
            {

                XtraMessageBox.Show(ex.Message, "格式有错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
            
          
            
           

        }

        private void barButtonItemCMPEE_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
        {
            try
            {

                //string sql = "select * from dif_tool_course t where COURSELEACCTURER like '%" + this.textEdit11.Text.ToString().Trim() + "% ';";
                string sql = string.Format(@"select COURSENAME,COURSEPATH,COURSELEACCTURER,CLASSTYPE from dif_tool_course t where coursetype ='CMPEE'");
                DataTable dt = MFDM10.DBGetSqlTable(sql);
                gridControlVideo.DataSource = dt;
                gridView1.BestFitColumns();
            }
            catch (Exception ex)
            {

                MessageBox.Show(ex.Message);
            }
        }

        private void barButtonItemCMPPE_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
        {
            try
            {

                string sql = string.Format(@"select COURSENAME,COURSEPATH,COURSELEACCTURER,CLASSTYPE from dif_tool_course t where coursetype ='CMPPE'");
                DataTable dt = MFDM10.DBGetSqlTable(sql);
                gridControlVideo.DataSource = dt;
                gridView1.BestFitColumns();
            }
            catch (Exception ex)
            {

                MessageBox.Show(ex.Message);
            }
        }

        private void barButtonItemIMPPE_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
        {
            try
            {

                string sql = string.Format(@"select COURSENAME,COURSEPATH,COURSELEACCTURER,CLASSTYPE from dif_tool_course t where coursetype ='IMPPE'");
                DataTable dt = MFDM10.DBGetSqlTable(sql);
                gridControlVideo.DataSource = dt;
                gridView1.BestFitColumns();
            }
            catch (Exception ex)
            {

                MessageBox.Show(ex.Message);
            }
        }

        private void barButtonItemIMPEE_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
        {
            try
            {

                string sql = string.Format(@"select COURSENAME,COURSEPATH,COURSELEACCTURER,CLASSTYPE from dif_tool_course t where coursetype ='IMPEE'");
                DataTable dt = MFDM10.DBGetSqlTable(sql);
                gridControlVideo.DataSource = dt;
                gridView1.BestFitColumns();
            }
            catch (Exception ex)
            {

                MessageBox.Show(ex.Message);
            }
        }

        private void barButtonItemDIFEE_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
        {
            try
            {

                string sql = string.Format(@"select COURSENAME,COURSEPATH,COURSELEACCTURER,CLASSTYPE from dif_tool_course t where coursetype ='DIFEE'");
                DataTable dt = MFDM10.DBGetSqlTable(sql);
                gridControlVideo.DataSource = dt;
                gridView1.BestFitColumns();
            }
            catch (Exception ex)
            {

                MessageBox.Show(ex.Message);
            }
        }

        private void barButtonItemDIFPE_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
        {
            try
            {

                string sql = string.Format(@"select COURSENAME,COURSEPATH,COURSELEACCTURER,CLASSTYPE from dif_tool_course t where coursetype ='DIFPE'");
                DataTable dt = MFDM10.DBGetSqlTable(sql);
                gridControlVideo.DataSource = dt;
                gridView1.BestFitColumns();
            }
            catch (Exception ex)
            {

                MessageBox.Show(ex.Message);
            }
        }

        private void barButtonItemAllVisible_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
        {
            try
            {

                //string sql = "select * from dif_tool_course t where COURSELEACCTURER like '%" + this.textEdit11.Text.ToString().Trim() + "% ';";
                // string sql = "select * from dif_tool_course t where COURSEVISIBIILITY = ";
                string sql = string.Format(@"select * from dif_tool_course t where coursevisibiility ='AllVisible'");
                DataTable dt = MFDM10.DBGetSqlTable(sql);
                gridControlVideo.DataSource = dt;
                gridView1.BestFitColumns();

            }
            catch (Exception ex)
            {

                MessageBox.Show(ex.Message);
            }
        }

        private void barButtonItemQuery_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
        {
            try
            {
                string sql = string.Format(@"select courseleaccturer,
                                                   coursename,
                                                   coursepath
                                                   from dif_tool_course t where courseleaccturer like  '%" + this.barEditItemQVDIO.EditValue.ToString() + "%'");
                DataTable dt = MFDM10.DBGetSqlTable(sql);
               gridControlVideo.DataSource = dt;
                gridView1.BestFitColumns();
            }
            catch (Exception ex)
            {

                MessageBox.Show(ex.Message);
            }
        }

        private void barButtonItemUpload_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
        {
            //点击按钮后在XtraTag下从新生成新的界面
            string pageName = "UpdateDo";
            if (!TabCtlPageExist(pageName))
            {
                newUploadhaha ctl = new newUploadhaha();
                CreateTabCtlPage(pageName,ctl);
            }
        }
        

        private void ribbonControl1_Click(object sender, EventArgs e)
        {

        }

        private void barButtonItemUploadPPT_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
        {
            string pageName = "UpdatePPT";
            if (!TabCtlPageExist(pageName))
            {
                ctlUploadPPT ctl = new ctlUploadPPT();
                CreateTabCtlPage(pageName,ctl);
            }
        }
#region 在Pagetab下显示新页面
        private bool   TabCtlPageExist(string pageName)
        {
            //生成新界面转换所需代码
            bool result = false;
            try
            {
                if (VideoXtraTab.TabPages.Count > 0)
                {
                    foreach (XtraTabPage xtabPage in VideoXtraTab.TabPages)
                    {
                        if (xtabPage.Name==pageName)
                        {
                            VideoXtraTab.SelectedTabPage = xtabPage;
                            result = true;
                            break;
                        }
                    }
                }
                else
                {
                    result = false;
                }
            }
            catch (Exception ex)
            {
                XtraMessageBox.Show("[TabCtlPageExist( string pageName)] " + ex.Message + ex.StackTrace);
            }
            return result;
        }
        private void CreateTabCtlPage(string pageName, Control ctl)
        {
            //生成新界面转换所需代码
            try
            {
                XtraTabPage tabPagex = new XtraTabPage();
                tabPagex.Text = pageName;
                tabPagex.Name = pageName;
                VideoXtraTab.TabPages.Add(tabPagex);
                VideoXtraTab.SelectedTabPage = tabPagex;
                ctl.Dock = DockStyle.Fill;
                tabPagex.Controls.Add(ctl);
            }
            catch (Exception ex)
            {
                XtraMessageBox.Show("[CreateTabCtlPage(string pageName,Control ctl)] " + ex.Message + ex.StackTrace);
            }
        }
        #endregion

        private void barButtonItemPPTCMPPE_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
        {
            try
            {

                string sql = string.Format(@"select COURSENAME,COURSEPATH,COURSELEACCTURER,CLASSTYPE from dif_tool_courseppt t where coursetype ='CMPPE'");
                DataTable dt = MFDM10.DBGetSqlTable(sql);
                gridControlVideo.DataSource = dt;
                gridView1.BestFitColumns();
            }
            catch (Exception ex)
            {

                MessageBox.Show(ex.Message);
            }
        }

        private void barButtonItemLCMPPE_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
        {
            try
            {

                //string sql = "select * from dif_tool_course t where COURSELEACCTURER like '%" + this.textEdit11.Text.ToString().Trim() + "% ';";
                string sql = string.Format(@"select COURSENAME,COURSEPATH,COURSELEACCTURER,CLASSTYPE from dif_tool_course t where courseleccturer ='CMPPE'");
                DataTable dt = MFDM10.DBGetSqlTable(sql);
                gridControlVideo.DataSource = dt;
                gridView1.BestFitColumns();
            }
            catch (Exception ex)
            {

                MessageBox.Show(ex.Message);
            }
        }

        private void barButtonItemLCMPEE_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
        {
            try
            {

                //string sql = "select * from dif_tool_course t where COURSELEACCTURER like '%" + this.textEdit11.Text.ToString().Trim() + "% ';";
                string sql = string.Format(@"select COURSENAME,COURSEPATH,COURSELEACCTURER,CLASSTYPE from dif_tool_course t where courseleccturer ='CMPEE'");
                DataTable dt = MFDM10.DBGetSqlTable(sql);
                gridControlVideo.DataSource = dt;
                gridView1.BestFitColumns();
            }
            catch (Exception ex)
            {

                MessageBox.Show(ex.Message);
            }
        }

        private void barButtonItemLIMPPE_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
        {
            try
            {

                //string sql = "select * from dif_tool_course t where COURSELEACCTURER like '%" + this.textEdit11.Text.ToString().Trim() + "% ';";
                string sql = string.Format(@"select COURSENAME,COURSEPATH,COURSELEACCTURER,CLASSTYPE from dif_tool_course t where courseleccturer ='IMPPE'");
                DataTable dt = MFDM10.DBGetSqlTable(sql);
                gridControlVideo.DataSource = dt;
                gridView1.BestFitColumns();
            }
            catch (Exception ex)
            {

                MessageBox.Show(ex.Message);
            }
        }

        private void barButtonItemLIMPEE_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
        {
            try
            {

                //string sql = "select * from dif_tool_course t where COURSELEACCTURER like '%" + this.textEdit11.Text.ToString().Trim() + "% ';";
                string sql = string.Format(@"select COURSENAME,COURSEPATH,COURSELEACCTURER,CLASSTYPE from dif_tool_course t where courseleccturer ='IMPEE'");
                DataTable dt = MFDM10.DBGetSqlTable(sql);
                gridControlVideo.DataSource = dt;
                gridView1.BestFitColumns();
            }
            catch (Exception ex)
            {

                MessageBox.Show(ex.Message);
            }
        }

        private void barButtonItemLDIFPE_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
        {
            try
            {

                //string sql = "select * from dif_tool_course t where COURSELEACCTURER like '%" + this.textEdit11.Text.ToString().Trim() + "% ';";
                string sql = string.Format(@"select COURSENAME,COURSEPATH,COURSELEACCTURER,CLASSTYPE from dif_tool_course t where courseleccturer ='DIFPE'");
                DataTable dt = MFDM10.DBGetSqlTable(sql);
                gridControlVideo.DataSource = dt;
                gridView1.BestFitColumns();
            }
            catch (Exception ex)
            {

                MessageBox.Show(ex.Message);
            }
        }

        private void barButtonItemLDIFEE_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
        {
            try
            {

                //string sql = "select * from dif_tool_course t where COURSELEACCTURER like '%" + this.textEdit11.Text.ToString().Trim() + "% ';";
                string sql = string.Format(@"select COURSENAME,COURSEPATH,COURSELEACCTURER,CLASSTYPE from dif_tool_course t where courseleccturer ='DIFEE'");
                DataTable dt = MFDM10.DBGetSqlTable(sql);
                gridControlVideo.DataSource = dt;
                gridView1.BestFitColumns();
            }
            catch (Exception ex)
            {

                MessageBox.Show(ex.Message);
            }
        }

        private void barButtonItemPPTCMPEE_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
        {
            try
            {

                string sql = string.Format(@"select COURSENAME,COURSEPATH,COURSELEACCTURER,CLASSTYPE from dif_tool_courseppt t where coursetype ='CMPEE'");
                DataTable dt = MFDM10.DBGetSqlTable(sql);
                gridControlVideo.DataSource = dt;
                gridView1.BestFitColumns();
            }
            catch (Exception ex)
            {

                MessageBox.Show(ex.Message);
            }
        }

        private void barButtonItemPPTIMPPE_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
        {
            try
            {

                string sql = string.Format(@"select COURSENAME,COURSEPATH,COURSELEACCTURER,CLASSTYPE from dif_tool_courseppt t where coursetype ='IMPPE'");
                DataTable dt = MFDM10.DBGetSqlTable(sql);
                gridControlVideo.DataSource = dt;
                gridView1.BestFitColumns();
            }
            catch (Exception ex)
            {

                MessageBox.Show(ex.Message);
            }
        }

        private void barButtonItemPPTIMPEE_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
        {
            try
            {

                string sql = string.Format(@"select COURSENAME,COURSEPATH,COURSELEACCTURER,CLASSTYPE from dif_tool_courseppt t where coursetype ='IMPEE'");
                DataTable dt = MFDM10.DBGetSqlTable(sql);
                gridControlVideo.DataSource = dt;
                gridView1.BestFitColumns();
            }
            catch (Exception ex)
            {

                MessageBox.Show(ex.Message);
            }
        }

        private void barButtonItemPPTDIFEE_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
        {
            try
            {

                string sql = string.Format(@"select COURSENAME,COURSEPATH,COURSELEACCTURER,CLASSTYPE from dif_tool_courseppt t where coursetype ='DIFEE'");
                DataTable dt = MFDM10.DBGetSqlTable(sql);
                gridControlVideo.DataSource = dt;
                gridView1.BestFitColumns();
            }
            catch (Exception ex)
            {

                MessageBox.Show(ex.Message);
            }
        }

        private void barButtonItemPPTDIFPE_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
        {
            try
            {

                string sql = string.Format(@"select COURSENAME,COURSEPATH,COURSELEACCTURER,CLASSTYPE from dif_tool_courseppt t where coursetype ='DIFPE'");
                DataTable dt = MFDM10.DBGetSqlTable(sql);
                gridControlVideo.DataSource = dt;
                gridView1.BestFitColumns();
            }
            catch (Exception ex)
            {

                MessageBox.Show(ex.Message);
            }
        }

        private void barButtonItemLPPTCMPPE_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
        {
            try
            {

                string sql = string.Format(@"select COURSENAME,COURSEPATH,COURSELEACCTURER,CLASSTYPE from dif_tool_courseppt t where courseleaccturer ='CMPPE'");
                DataTable dt = MFDM10.DBGetSqlTable(sql);
                gridControlVideo.DataSource = dt;
                gridView1.BestFitColumns();
            }
            catch (Exception ex)
            {

                MessageBox.Show(ex.Message);
            }
        }

        private void barButtonItemLPPTCMPEE_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
        {
            try
            {

                string sql = string.Format(@"select COURSENAME,COURSEPATH,COURSELEACCTURER,CLASSTYPE from dif_tool_courseppt t where courseleaccturer ='CMPEE'");
                DataTable dt = MFDM10.DBGetSqlTable(sql);
                gridControlVideo.DataSource = dt;
                gridView1.BestFitColumns();
            }
            catch (Exception ex)
            {

                MessageBox.Show(ex.Message);
            }
        }

        private void barButtonItemLPPTIMPPE_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
        {
            try
            {

                string sql = string.Format(@"select COURSENAME,COURSEPATH,COURSELEACCTURER,CLASSTYPE from dif_tool_courseppt t where courseleaccturer ='IMPPE'");
                DataTable dt = MFDM10.DBGetSqlTable(sql);
                gridControlVideo.DataSource = dt;
                gridView1.BestFitColumns();
            }
            catch (Exception ex)
            {

                MessageBox.Show(ex.Message);
            }
        }

        private void barButtonItemLPPTIMPEE_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
        {
            try
            {

                string sql = string.Format(@"select COURSENAME,COURSEPATH,COURSELEACCTURER,CLASSTYPE from dif_tool_courseppt t where courseleaccturer ='IMPEE'");
                DataTable dt = MFDM10.DBGetSqlTable(sql);
                gridControlVideo.DataSource = dt;
                gridView1.BestFitColumns();
            }
            catch (Exception ex)
            {

                MessageBox.Show(ex.Message);
            }
        }

        private void barButtonItemLPPTDIFPE_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
        {
            try
            {

                string sql = string.Format(@"select COURSENAME,COURSEPATH,COURSELEACCTURER,CLASSTYPE from dif_tool_courseppt t where courseleaccturer ='DIFPE'");
                DataTable dt = MFDM10.DBGetSqlTable(sql);
                gridControlVideo.DataSource = dt;
                gridView1.BestFitColumns();
            }
            catch (Exception ex)
            {

                MessageBox.Show(ex.Message);
            }
        }

        private void barButtonItemLPPTDIFEE_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
        {
            try
            {

                string sql = string.Format(@"select COURSENAME,COURSEPATH,COURSELEACCTURER,CLASSTYPE from dif_tool_courseppt t where courseleaccturer ='DIFEE'");
                DataTable dt = MFDM10.DBGetSqlTable(sql);
                gridControlVideo.DataSource = dt;
                gridView1.BestFitColumns();
            }
            catch (Exception ex)
            {

                MessageBox.Show(ex.Message);
            }
        }
    }
}

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Drawing;
using System.Data;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using DBClenitHandle;
using Word = Microsoft.Office.Interop.Word;
using Excel = Microsoft.Office.Interop.Excel;
using PowerPoint = Microsoft.Office.Interop.PowerPoint;
using Microsoft.Office.Core;
using System.IO;
using DevExpress.XtraEditors;

namespace DIFautomaticTool.View.traning_model
{
    public partial class ctlUploadPPT : UserControl
    {
        public ctlUploadPPT()
        {
            InitializeComponent();
        }

        private void textEditPath_EditValueChanged(object sender, EventArgs e)
        {

        }

        private void textEditPath_Click(object sender, EventArgs e)
        {

            //选择路径
            using (OpenFileDialog dialog = new OpenFileDialog())
            {
                dialog.Multiselect = true;
                if (dialog.ShowDialog() == DialogResult.OK)
                {
                    try
                    {
                        this.textEditPath.Text = dialog.FileName;
                    }
                    catch (Exception ex)
                    {
                        throw (ex);
                    }
                }
            }
        }

        private void simpleButtonUploadPPt_Click(object sender, EventArgs e)
        {
            try
            {
                if (string.IsNullOrWhiteSpace(textEditName.Text))
                {
                    throw new Exception($"文件名不能为空！");

                }
                if (string.IsNullOrWhiteSpace(textEditPath.Text))
                {
                    throw new Exception($"文件路径不能为空！");
                }
                if (string.IsNullOrWhiteSpace(comboBoxEditCourseType.Text))
                {
                    throw new Exception($"课程类型不能为空！");
                }
                if (string.IsNullOrWhiteSpace(textEditLecturer.Text))
                {
                    throw new Exception($"课程讲师不能为空！");
                }
                if (string.IsNullOrWhiteSpace(textEditVisbility.Text))
                {
                    throw new Exception($"课程可见度不能为空！");
                }
                string sql = @"insert into dif_tool_courseppt(coursename,coursepath,courseleaccturer,videotemperature,coursetype)values('" + this.textEditName.Text.ToString() + "','"
                                                                      + this.textEditPath.Text.ToString() + "','"
                                                                      + this.textEditLecturer.Text.ToString() + "','"
                                                                      + this.textEditVisbility.Text.ToString() + "','"
                                                                      + this.comboBoxEditCourseType.Text.ToString() + "')";
                //DataTable dt = MFDM10.DBGetSqlTable(sql);
                
                string result = MFDM10.DBUpdate(sql);
                string sourthPathone = $@"{this.textEditPath.Text.ToString()}";
                string PDFpath =Path.GetDirectoryName(sourthPathone);//获取文件路径
                string PDFfilename = Path.GetFileName(sourthPathone);//获取文件名
                string pathone = @"Z:\training message ppt\";
                string xiegang = @"\";
                string type = $@"{this.comboBoxEditCourseType.Text.ToString()}";
                string sourthPathlast = $"{pathone}{type}{xiegang}{PDFfilename}.pdf";//目的路径文件
                string sourthPathTime = $"{Path.GetTempPath()}{PDFfilename}.pdf";//临时文件夹下的目标文件
                string ppt = ".ppt";
                string excel = ".xls";
                string world = ".doc";
                if (PDFfilename.Contains(ppt))//如果是ppt文件
                {
                    try
                    {
                        PPTConvertToPDF(sourthPathone, sourthPathlast);
                    //PPTConvertToPDF(sourthPathone, sourthPathTime);//将文件存入临时文件夹
                    // FileInfo file = new FileInfo(sourthPathTime);//将文件存到临时文件夹并打开
                    MessageBox.Show("转换成功");
                    FileInfo file = new FileInfo(sourthPathlast);
                    file.Attributes = FileAttributes.ReadOnly;
                    // System.Diagnostics.Process.Start(sp2);
                    DXPdfView PDF = new DXPdfView(sourthPathlast);
                    PDF.Show();
                    }
                    catch (Exception ex)
                    {

                        XtraMessageBox.Show(ex.Message, "对不起，转换失败！ 请将格式改为.xls格式，如果还不可以请联系管理员！", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    }
                    

                         
                            
                     }
                if (PDFfilename.Contains(excel))//如果是excel文件
                {
                    try
                    {
                        XLSConvertToPDF(sourthPathone,sourthPathlast);
                        success(sourthPathlast);
                    }
                    catch (Exception ex)
                    {

                        XtraMessageBox.Show(ex.Message, "对不起，转换失败！ 请将格式改为.xls格式，如果还不可以请联系管理员！", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    }
                }
                if (PDFfilename.Contains(world))//如果是world文件
                {
                    try
                    {
                        DOCConvertToPDF(sourthPathone,sourthPathlast);
                        success(sourthPathlast);
                    }
                    catch (Exception ex)
                    {

                        XtraMessageBox.Show(ex.Message, "对不起，转换失败！ 请将格式改为.xls格式，如果还不可以请联系管理员！", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    }
                }
                
            }
            catch (Exception ex)
            {

                XtraMessageBox.Show(ex.Message,("添加失败请联系管理员"),MessageBoxButtons.OK,MessageBoxIcon.Information);
            }
        }
        #region Word转换成pdf
        ///Word转换成pdf
        ///<summary>
        /// 把Word文件转换成为PDF格式文件
        ///</summary>
        ///<param name="sourcePath">源文件路径</param>
        ///<param name="targetPath">目标文件路径</param> 
        ///<returns>true=转换成功</returns>
        private bool DOCConvertToPDF(string sourcePath, string targetPath)
        {
            bool result = false;
            Word.WdExportFormat exportFormat = Word.WdExportFormat.wdExportFormatPDF;
            object paramMissing = Type.Missing;
            Word.ApplicationClass wordApplication = new Word.ApplicationClass();
            Word.Document wordDocument = null;
            try
            {
                object paramSourceDocPath = sourcePath;
                string paramExportFilePath = targetPath;
                Word.WdExportFormat paramExportFormat = exportFormat;
                bool paramOpenAfterExport = false;
                Word.WdExportOptimizeFor paramExportOptimizeFor = Word.WdExportOptimizeFor.wdExportOptimizeForPrint;
                Word.WdExportRange paramExportRange = Word.WdExportRange.wdExportAllDocument;
                int paramStartPage = 0;
                int paramEndPage = 0;
                Word.WdExportItem paramExportItem = Word.WdExportItem.wdExportDocumentContent;
                bool paramIncludeDocProps = true;
                bool paramKeepIRM = true;
                Word.WdExportCreateBookmarks paramCreateBookmarks = Word.WdExportCreateBookmarks.wdExportCreateWordBookmarks;
                bool paramDocStructureTags = true;
                bool paramBitmapMissingFonts = true;
                bool paramUseISO19005_1 = false;
                wordDocument = wordApplication.Documents.Open(
                ref paramSourceDocPath, ref paramMissing, ref paramMissing,
                ref paramMissing, ref paramMissing, ref paramMissing,
                ref paramMissing, ref paramMissing, ref paramMissing,
                ref paramMissing, ref paramMissing, ref paramMissing,
                ref paramMissing, ref paramMissing, ref paramMissing,
                ref paramMissing);
                if (wordDocument != null)
                    wordDocument.ExportAsFixedFormat(paramExportFilePath,
                    paramExportFormat, paramOpenAfterExport,
                    paramExportOptimizeFor, paramExportRange, paramStartPage,
                    paramEndPage, paramExportItem, paramIncludeDocProps,
                    paramKeepIRM, paramCreateBookmarks, paramDocStructureTags,
                    paramBitmapMissingFonts, paramUseISO19005_1,
                    ref paramMissing);
                result = true;
            }
            catch
            {
                result = false;
            }
            finally
            {
                if (wordDocument != null)
                {
                    wordDocument.Close(ref paramMissing, ref paramMissing, ref paramMissing);
                    wordDocument = null;
                }
                if (wordApplication != null)
                {
                    wordApplication.Quit(ref paramMissing, ref paramMissing, ref paramMissing);
                    wordApplication = null;
                }
                GC.Collect();
                GC.WaitForPendingFinalizers();
                GC.Collect();
                GC.WaitForPendingFinalizers();
            }
            return result;
        }
        #endregion
        #region 把Excel文件转换成PDF格式文件
        ///<summary>
        /// 把Excel文件转换成PDF格式文件
        ///</summary>
        ///<param name="sourcePath">源文件路径</param>
        ///<param name="targetPath">目标文件路径</param> 
        ///<returns>true=转换成功</returns>
        private bool XLSConvertToPDF(string sourcePath, string targetPath)
        {
            bool result = false;
            Excel.XlFixedFormatType targetType = Excel.XlFixedFormatType.xlTypePDF;
            object missing = Type.Missing;
            Excel.ApplicationClass application = null;
            Excel.Workbook workBook = null;
            try
            {
                application = new Excel.ApplicationClass();
                object target = targetPath;
                object type = targetType;
                workBook = application.Workbooks.Open(sourcePath, missing, missing, missing, missing, missing,
                        missing, missing, missing, missing, missing, missing, missing, missing, missing);
                workBook.ExportAsFixedFormat(targetType, target, Excel.XlFixedFormatQuality.xlQualityStandard, true, false, missing, missing, missing, missing);
                result = true;
            }
            catch
            {
                result = false;
            }
            finally
            {
                if (workBook != null)
                {
                    workBook.Close(true, missing, missing);
                    workBook = null;
                }
                if (application != null)
                {
                    application.Quit();
                    application = null;
                }
                GC.Collect();
                GC.WaitForPendingFinalizers();
                GC.Collect();
                GC.WaitForPendingFinalizers();
            }
            return result;
        }
        #endregion

#region 把PowerPoint文件转换成PDF格式文件
        ///<summary>
        /// 把PowerPoint文件转换成PDF格式文件
        ///</summary>
        ///<param name="sourcePath">源文件路径</param>
        ///<param name="targetPath">目标文件路径</param> 
        ///<returns>true=转换成功</returns>
        private bool PPTConvertToPDF(string sourcePath, string targetPath)
        {
            bool result;
            PowerPoint.PpSaveAsFileType targetFileType = PowerPoint.PpSaveAsFileType.ppSaveAsPDF;
            object missing = Type.Missing;
            PowerPoint.ApplicationClass application = null;
            PowerPoint.Presentation persentation = null;
            try
            {
                application = new PowerPoint.ApplicationClass();
                persentation = application.Presentations.Open(sourcePath, MsoTriState.msoTrue, MsoTriState.msoFalse, MsoTriState.msoFalse);
                persentation.SaveAs(targetPath, targetFileType, Microsoft.Office.Core.MsoTriState.msoTrue);
                result = true;
            }
            catch
            {
                result = false;
            }
            finally
            {
                if (persentation != null)
                {
                    persentation.Close();
                    persentation = null;
                }
                if (application != null)
                {
                    application.Quit();
                    application = null;
                }
                GC.Collect();
                GC.WaitForPendingFinalizers();
                GC.Collect();
                GC.WaitForPendingFinalizers();
            }
            return result;
        }
        # endregion

        private bool success(string path)
        {
            bool result=true;
            MessageBox.Show("恭喜您转换成功！");
            FileInfo file = new FileInfo(path);
            file.Attributes = FileAttributes.ReadOnly;
            DXPdfView PDF = new DXPdfView(path);
            PDF.Show();
            return result;
        }
        
    }
}

PDF播放容器

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Linq;
using System.Windows.Forms;
using DevExpress.XtraBars;

namespace DIFautomaticTool.View
{
    public partial class DXPdfView : DevExpress.XtraBars.Ribbon.RibbonForm
    {
        public DXPdfView()
        {
            InitializeComponent();
        }
        public DXPdfView(string filePath):this()
        {
            pdfViewer1.DocumentFilePath = filePath;
        }
    }
}
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Drawing;
using System.Data;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using DBClenitHandle;
using System.IO;
using DevExpress.XtraEditors;
using DIFautomaticTool.common_GUI;

namespace DIFautomaticTool.View
{
    public partial class newUploadhaha : UserControl
    {
        public newUploadhaha()
        {
            InitializeComponent();
        }

        private void simpleButton1_Click(object sender, EventArgs e)
        {
            try
            {
                if (string.IsNullOrWhiteSpace(textEditName.Text))
                {
                    throw new Exception($"文件名不能为空！");
          
                }
                if (string.IsNullOrWhiteSpace(textEditPath.Text))
                {
                    throw new Exception($"文件路径不能为空！");
                }
                if (string.IsNullOrWhiteSpace(comboBoxEditCourseType.Text))
                {
                    throw new Exception($"课程类型不能为空！");
                }
                if (string.IsNullOrWhiteSpace(textEditLecturer.Text))
                {
                    throw new Exception($"课程讲师不能为空！");
                }
                if (string.IsNullOrWhiteSpace(textEditVisbility.Text))
                {
                    throw new Exception($"课程可见度不能为空！");
                }
                string sql = @"insert into dif_tool_course(coursename,coursepath,courseleaccturer,videotemperature,coursetype)values('" + this.textEditName.Text.ToString() + "','"
                                                                  + this.textEditPath.Text.ToString() + "','"
                                                                  + this.textEditLecturer.Text.ToString() + "','"
                                                                  + this.textEditVisbility.Text.ToString() + "','"
                                                                  + this.comboBoxEditCourseType.Text.ToString() + "')";
                string result = MFDM10.DBUpdate(sql);
                //DataTable dt = MFDM10.DBGetSqlTable(sql);
                simpleButtonCopy_Click(null, null);
                XtraMessageBox.Show("上传成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);

            }
            catch (Exception ex)
            {

                XtraMessageBox.Show(ex.Message, "Result", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
        }

        private void textEditPath_DoubleClick(object sender, EventArgs e)
        {
            //选择路径
            using (OpenFileDialog dialog = new OpenFileDialog())
            {
                dialog.Multiselect = true;
                if (dialog.ShowDialog() == DialogResult.OK)
                {
                    try
                    {
                        this.textEditPath.Text = dialog.FileName;
                    }
                    catch (Exception ex)
                    {
                        throw (ex);
                    }
                }
            }
        }

        private void simpleButtonCopy_Click(object sender, EventArgs e)
        {
            WaitingForm wait = new WaitingForm();
         
            wait.Show("正在拼命上传请耐心等待");
            string sourceDir = $@"{this.textEditPath.Text.ToString()}";
            //string path = sourceDir.Substring(0, sourceDir.LastIndexOf(@"\") + 1);//获取文件路径
            //string filename = sourceDir.Substring(sourceDir.LastIndexOf(@"\")+1);//获取文件名
            string path = Path.GetDirectoryName(sourceDir);//获取文件路径
            string filename = Path.GetFileName(sourceDir);//获取文件名
            string Newfilename = @"Z:\training message\" + this.comboBoxEditCourseType.Text.ToString() + @"\" + filename;
            try
            {
                string[] files = Directory.GetFiles(path);
                foreach (string file in files)
                {
                    if (file.Contains(filename))
                    {
                        FileInfo fileinfo = new FileInfo(file);
                        try
                        {
                            string fileName = file.Replace(sourceDir, "");
                            File.Copy(file, Newfilename);

                        }
                        catch (IOException copyError)
                        {
                            Console.WriteLine(copyError.Message);
                        }
                    }

                }
            }
            catch (DirectoryNotFoundException dirNotFound)
            {
                Console.WriteLine(dirNotFound.Message);
            }
            finally
            {
                wait.Close();
            }

        }

    }
}

 

转载于:https://my.oschina.net/u/3736209/blog/1581364

chijian0177
关注
深度学习知识点全面总结
专注大数据与人工智能技术分享，欢迎私信加群互相学习！
01-05 26万+
本文详细介绍深度学习概念及原理，参考网上相关资料汇总，内容包含众多章节，包括神经网络基础及常见深度学习网络结构介绍，用于个人学习总结，适合深度学习初学者学习。同时介绍机器学习常见的分类算法：SVM、神经网络、随机森林、逻辑回归、KNN、贝叶斯。常见的监督学习算法：感知机、SVM、人工神经网络、决策树、逻辑回归.........
在线学习模块
01-07
在线学习，自己写的小模块！
在线学习--online learning
weixin_30500105的博客
04-25 568
在线学习 online learning Online learning并不是一种模型，而是模型的训练方法。能够根据线上反馈数据，实时快速的进行模型调优，使得模型能够及时反映线上的变化，提高线上预测的准确率。 在线模型的评估之--Mistake Bound 假设有一个模型完全预测正确，Mistake Bound表示的就是找到这个模型最多犯错的次数。 用Halving算法来解决这个问...
做视频或者什么模块开发之类的
weixin_30642305的博客
05-18 75
先在本地做测试 1， 排除网络的因素2，更新快 节省文件上传的 请缓存的时间 可以做到即时更新3， 环境干净。。。。。 转载于:https://www.cnblogs.com/qinqiu/p/4512700.html...
SSM在线学习系统毕业设计源码131843
DZBS2000的博客
08-19 2183
在线学习系统主要功能模块包括首页、站点管理（轮播图、公告栏）用户管理（管理员、学生、教师）、内容管理（课程资讯、资讯分类、在线测试）、更多管理（老师信息、学生作业、预约信息、精品课程、上交作业），采取面对对象的开发模式进行软件的开发和硬体的架设，能很好的满足实际使用的需求，完善了对应的软体架设以及程序编码的工作，采取MySQL作为后台数据的主要存储单元，采用ssm框架、Java技术、Ajax技术进行业务系统的编码及其开发，实现了本系统的全部功能. 关键词：SSM技术；MYSQL；在线学习系统
SSM+在线学习系统 毕业设计-附源码131843
yuyuxun的博客
09-08 4518
在线学习系统主要功能模块包括首页、站点管理（轮播图、公告栏）用户管理（管理员、学生、教师）、内容管理（课程资讯、资讯分类、在线测试）、更多管理（老师信息、学生作业、预约信息、精品课程、上交作业），采取面对对象的开发模式进行软件的开发和硬体的架设，能很好的满足实际使用的需求，完善了对应的软体架设以及程序编码的工作，采取MySQL作为后台数据的主要存储单元，采用ssm框架、Java技术、Ajax技术进行业务系统的编码及其开发，实现了本系统的全部功能。本次报告，首先分析了研究的背景、作用、意义，为研究工作的合理性
【单片机/嵌入式】最完整学习路线
热门推荐
qq_40838412的博客
05-08 16万+
一.什么是单片机？什么是嵌入式？它们之间的区别与联系。 关于这个问题我在网上寻找到了相关文章解释得很详细，不了解的同学可以参考一下这篇文章：到底什么是嵌入式？什么是单片机？ - 知乎 二.学习路线 一个人学习是孤独的，如果你是一名学生，建议加入学校的电子社团或者实验室，有老师的帮助和同学的互助能更好去提升自己，多与同学组队参加项目比赛，能收获更多的知识经验。 1.C语言! C语言! C语言! C语言可以说是贯穿整个嵌入式的核心程序语言，想要学好嵌入...
Java基于SpringBootSSM在线学习系统设计与实现
ForFuture
11-28 1万+
Spring+SpringMVC+MyBatis+Bootstrap+Vue开发在线学习系统 本课题的主要内容是开发基于Java EE的在线学习平台，使用MVC经典开发模式、Java EE的框架 SSM（Spring+SpringMVC+Mybatis）等相关技术开发网站系统。 在线演示 ...
Python学习路线（课程大纲+Python视频教程+下载地址）
程序员日常
01-05 16万+
最新Python学习路线+千锋Python课程大纲+Python视频教程+Python学习资料下载地址大合集 目前Python已经成为最受欢迎的程序设计语言之一。Python的设计哲学是“优雅”、“明确”、“简单”。 Python的优点（来自百科） 简单：Python是一种代表简单主义思想的语言。阅读一个良好的Python程序就感觉像是在读英语一样。它使你能够专注于解决问题而不是去搞明白...
易语言-易语言视频监控图片模块
06-29
在“易语言视频监控图片模块”中，我们可以学习到如何使用易语言来处理视频监控和图像捕获的相关技术。 首先，我们要理解这个模块的核心功能：截取窗口位图。在易语言中，`截取窗口位图` 是一个用于获取屏幕上特定...
火山pc视频播放器例子+模块[x64]-易语言
06-14
找了好多视频播放开源库 目前只发现VLC的最简单 类似bass音频库 如果有人写好了其他视频播放器开源库，欢迎分享出来一起...模块太大 包含很多dll文件 不放心可以自己官网去下载 链接https://lanzoux.com/iRnZlkf0kbg
Qt/C++编写安防视频监控系统49-多数据库支持
Qt/C++视频监控/推流/物联网/大屏系统/自定义控件/UI定制/输入法
07-22 4984
一、前言 数据库设置模块，因为很多项目都会用到，索性这期间也将这玩意重新架构了一遍，对应的数据库组件同样重写了一遍，关于数据库的参数无非就6个，数据库类型（sqlite、mysql等）、数据库名称、主机地址、通信端口、用户名称、用户密码。默认提供了视频监控系统的数据库脚本文件（拓展名sql结尾的文件），单击初始化数据按钮可以对整个数据库进行新建和重置，相当于恢复出厂。 系统支持多种数据库，默认sqlite（Qt内置的数据库，无需安装），可选mysql、postgresql等，具体需要Qt对应的数据库插件支持
嵌入式学习中较好的练手项目和课题整理（附代码资料、学习视频和嵌入式学习规划）
HowieXue 薛永浩的博客
08-04 10万+
目录： 0、引言 何为嵌入式？ 1、单片机相关 1.1 基于单片机的智能小车、智能机器人制作 1.2 基于Arduino的3D打印机制作 2、嵌入式Linux相关 2.1 智能扫地机器人 2.2 智能可穿戴类设备：智能安全头盔 2.3 智能可穿戴类设备：面向空巢老人/病人的智能手环 2.4 物联网智能控制系统：家居、农业、医疗 2.5 基于Linux的嵌入式网络视频监控系统 ...
C/C++学习路线总结与分享
dvlinker的技术专栏
10-07 9万+
C/C++学习路线总结与分享
【超强组合】基于淘金优化算法GRO-BP-Adaboost的数据分类预测算法Matlab实现.rar
最新发布
10-08
1.版本：matlab2014/2019a/2024a 2.附赠案例数据可直接运行matlab程序。 3.代码特点：参数化编程、参数可方便更改、代码编程思路清晰、注释明细。 4.适用对象：计算机，电子信息工程、数学等专业的大学生课程设计、期末大作业和毕业设计。 替换数据可以直接使用，注释清楚，适合新手
VMware Workstation Pro 和 VMware Fusion 安装与配置指南
10-08
内容概要：本文档详细指导了如何在不同的主机环境下，通过 VMWare 的两款产品——Workstation Pro 和 Fusion 进行新虚拟机的构建流程以及具体的操作要点说明。 适用人群：希望在单一机器上部署多操作系统的工作环境或学习测试场景的技术人员和学生。 使用场景及目标：旨在帮助初学者搭建属于自己的虚拟机实验平台，从而方便进行软件测试或者研究操作系统相关的新特性等任务，同时也有利于团队间的协作和资源调配。 注意事项：文中涉及的具体操作如下载源文件、配置网络参数时要注意版权合法性问题和技术安全防范。此外还需依据各自电脑的软硬件条件适当增减虚拟机的资源设定。
科研经费管理系统 SSM毕业设计 源码+数据库+论文（JAVA+SpringBoot+Vue.JS）.zip
10-08
科研经费管理系统 SSM毕业设计 源码+数据库+论文（JAVA+SpringBoot+Vue.JS） 启动教程：https://www.bilibili.com/video/BV1GK1iYyE2B
使用Python Matplotlib进行图形输出与保存详解（包含详细的完整的程序和数据）
10-08
内容概要：本文详细介绍了使用 Python 的 Matplotlib 库来输出和保存图形的方法。不仅涉及了基本流程，如生成图表并将之导出成PNG、PDF和SVG等不同格式的内容，还包括高级话题如设置透明度、分辨率以及制作包含图形元素的HTML页面等。文章通过一个具体的示例代码讲解了各个环节的关键细节和技术要点。 适用人群：对数据可视化有兴趣的初学者及具有一定基础想要深入学习 Matplotlib 使用技巧的技术人员。 使用场景及目标：适用于需要掌握 Matplotlib 不同输出选项及其特点的应用场合，尤其是当需要生成用于打印或网页展示的高质量、可自定义外观的图形时。
C/S结构多功能聊天软件实现：语音与视频模块
这个多功能聊天模块的实现不仅提供了实践VC++编程的机会，还涵盖了网络通信、音频视频处理等多个领域的知识，对于提升开发者在即时通信软件开发方面的技能具有很高的价值。完成后的软件将是一个功能完备、运行稳定的...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值