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);
}
