BLL/FrmMain.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using Maticsoft.DBUtility;
using ExportFile;
using Maticsoft.Model;
using System.Windows.Forms;
using DevComponents.DotNetBar.Controls;
using Aspose.Cells;
using Maticsoft.Common;
using System.Collections;

namespace Maticsoft.BLL
{
    public class frmMain
    {
        /// <summary>
        /// 获取预览数据
        /// </summary>
        /// <returns></returns>
        public static DataTable GetYLDB(String strName)
        {
            try
            {
                DataTable dt = DbHelperSQL.Query(string.Format("select top 25 * from {0}", strName)).Tables[0];
                return dt;
            }
            catch
            {
                MessageBox.Show("数据表不存在", "提示");
                return null;
            }
        }

        /// <summary>
        /// 导出报表
        /// </summary>
        /// <param name="obj"></param>
        /// <param name="str"></param>
        public static void Export(Object obj, String str)
        {
            try
            {
                if (Maticsoft.Model.Columns.ary_col.Count <= 0) GetAry(str);
                else GetDt(str);
                export ex = new export();
                ex.Ary = Maticsoft.Model.Columns.ary_col;
                ex.Dt = Maticsoft.Model.Columns.dt;
                ex.Name = Maticsoft.Model.Columns.strName;
                List<export> list = new List<export> { ex };
                if (port.export(list, obj.ToString())) MessageBox.Show("保存完成");
            }
            catch { }
        }

        /// <summary>
        /// 导出报表
        /// </summary>
        /// <param name="obj"></param>