public FileResult CommonExportNewport(string Title, string Columns, string Data) { string ChildCategoryTableID = ""; if (Request.Form["ChildCategoryTableID"] != null) { ChildCategoryTableID = Request.Form["ChildCategoryTableID"]; } string CategoryTableID = ""; if (Request.Form["CategoryTableID"] != null) { CategoryTableID = Request.Form["CategoryTableID"]; } DataTable _datatable = new DataTable(); if (Request.Form["dataGetter"] != null) { _datatable = JsonConvert.DeserializeObject <DataTable>(Request.Form["dataGetter"]); } var sqlc2 = MainAssociationSet.SelectAll().Where(MainAssociationSet.CategoryTableID.Equal(CategoryTableID).And(MainAssociationSet.ChildCategoryTableID.Equal(ChildCategoryTableID))); var newmodle = Mabiz.GetEntity(sqlc2); var sqlc = VcorrelateColumnsSet.SelectAll().Where(VcorrelateColumnsSet.MainAssociationID.Equal(newmodle.ID)); var dic = Vcbiz.GetEntities(sqlc); var ddsql = CategoryTableSet.SelectAll().Where(CategoryTableSet.ID.Equal(ChildCategoryTableID)); var CategoryTablemodle = OPBiz.GetEntity(ddsql); var list = CCBiz.ExecuteSqlToOwnList("select * from ColumnCharts where CategoryTableID='" + ChildCategoryTableID + "' and IsEnable=1 and MergeHeader<>1 and (title<>'ck') ORDER BY SortNo"); DataTable dt2 = new DataTable(); dt2.Columns.Add("ID"); for (int i = 0; i < list.Count; i++) { dt2.Columns.Add(list[i].field); } UniteDataTable(_datatable, dt2, dic); string filename = Guid.NewGuid().ToString() + ".xlsx"; var ff = Exporter.NewInstance(Server.MapPath("~/temp/" + filename), dt2, CategoryTablemodle.ChineseName).Download(); return(File(Server.MapPath("~/temp/" + filename), "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", string.Format("{0}.xlsx", Title))); // return File(ff, "application/ms-excel", string.Format("{0}.xls", "czc")); }
public void Init() { _FakeUOW_CDsDB = new FakeUOW_CDsDB(); _FakeUOW_CDsDB.CCs = CCs(); _servicio = new CCBiz(_FakeUOW_CDsDB); }