public ActionResult ExcelOutput()
        {
            var       repodata     = repo.All();
            var       data         = from s1 in repodata select new { s1.職稱, s1.姓名, s1.Email, s1.手機, s1.電話, s1.客戶資料.客戶名稱 };
            var       l_ExcelClass = new ExcelClass();
            DataTable l_datatable  = l_ExcelClass.ToDataTable(data);
            string    OutputPath   = l_ExcelClass.ExcelOutput(l_datatable, " ContactPerson");

            return(File(Server.MapPath(OutputPath), "application/vnd.ms-excel"));
        }
Example #2
0
        //[HttpPost]
        public ActionResult ExcelOutput()
        {
            var       repodata     = repo.All();
            var       data         = from s1 in repodata select new { s1.客戶名稱, s1.統一編號, s1.電話, s1.傳真, s1.地址, s1.Email };
            var       l_ExcelClass = new ExcelClass();
            DataTable l_datatable  = l_ExcelClass.ToDataTable(data);
            string    OutputPath   = l_ExcelClass.ExcelOutput(l_datatable, "Customer");

            return(File(Server.MapPath(OutputPath), "application/vnd.ms-excel"));
        }
Example #3
0
        public ActionResult ExcelOutput()
        {
            var       repodata     = repo.All();
            var       data         = from s1 in repodata select new { s1.銀行名稱, s1.銀行代碼, s1.分行代碼, s1.帳戶名稱, s1.帳戶號碼, s1.客戶資料.客戶名稱 };
            var       l_ExcelClass = new ExcelClass();
            DataTable l_datatable  = l_ExcelClass.ToDataTable(data);
            string    OutputPath   = l_ExcelClass.ExcelOutput(l_datatable, "CustomerAccount");

            return(File(Server.MapPath(OutputPath), "application/vnd.ms-excel"));
        }