public void Excel()
{
string outName = "";// table.TableName;
Workbook workBook = new Workbook();
workBook.Worksheets.Clear();
workBook.Worksheets.Add(outName);//New Worksheet是Worksheet的name
Worksheet ws = workBook.Worksheets[0];
workBook.Worksheets[0].AutoFitColumns();
var modulars = ProjectCache.Design_ModularOrFuns.Where(p => p.ParentPremID == 0).ToList();
var k = 0;
for (int i = 0; i < modulars.Count(); i++)
{
k++;
var modular = modulars[i];
#region 主表
//(1)字段
var ttt = HtmlHelpersProject.PageFormEleTypes(modular).Where(p => p.PageFormEleSort != 1 && p.PageFormEleSort != 100 && p.PageFormEleSort != null && p.FormEleType != 8)
.OrderBy(p => p.Page01FormEleSort);
//PageFormEleSort = p.Page01FormEleSort; p.PageFormElePos = p.Page01FormElePos; p.FormEleType
var DispNameCn = string.Join(",", ttt.Select(p => p.NameCn));
//(2)查询条件
var mmm = HtmlHelpersProject.QueryFormEleTypes(modular).Where(p => p.PageFormEleSort != null);
var queryNameCn = string.Join(",", mmm.Select(p => p.NameCn));
//按钮
ws.Cells[k, 0].PutValue(modular.ModularName);
ws.Cells[k, 1].PutValue(DispNameCn);
ws.Cells[k, 2].PutValue(queryNameCn);
#endregion
#region 子模块
var modularsChilds = ProjectCache.Design_ModularOrFuns.Where(p => p.ParentPremID == modular.Design_ModularOrFunID).ToList();
for (var j = 0; j < modularsChilds.Count; j++)
{
k++;
modular = modularsChilds[j];
ttt = HtmlHelpersProject.PageFormEleTypes(modular).Where(p => p.PageFormEleSort != 1 && p.PageFormEleSort != 100 && p.PageFormEleSort != null && p.FormEleType != 8)
.OrderBy(p => p.Page01FormEleSort);
//PageFormEleSort = p.Page01FormEleSort; p.PageFormElePos = p.Page01FormElePos; p.FormEleType
DispNameCn = string.Join(",", ttt.Select(p => p.NameCn));
//(2)查询条件
mmm = HtmlHelpersProject.QueryFormEleTypes(modular).Where(p => p.PageFormEleSort != null);
queryNameCn = string.Join(",", mmm.Select(p => p.NameCn));
//按钮
ws.Cells[k, 0].PutValue(modular.ModularName);
ws.Cells[k, 1].PutValue(DispNameCn);
ws.Cells[k, 2].PutValue(queryNameCn);
}
#endregion
}
workBook.Worksheets[0].AutoFitColumns();
workBook.Save("C:\\aaa.xls");
}
