/// <summary>
/// Jquery树
/// </summary>
/// <param name="val"></param>
/// <param name="NameCn"></param>
/// <returns></returns>
public static string JqTreeNs_Pre_OrganizationID(string val, string NameCn, SoftProjectAreaEntity item)
{
List <SoftProjectAreaEntity> Items = SoftProjectAreaEntityDomain.Pre_Organizations.Where(p => p.LoginCategoryID == item.LoginCategoryID).ToList();
var treeList = new TreeList(Items, "0", "OrganizationName", "Pre_OrganizationID", "ParentPre_OrganizationID", "", "", "Pre_OrganizationID", "", "");
var str = HtmlHelpersProject.JqTreeN(null, "Pre_OrganizationID", treeList, "", 2);
return(str.ToString());
}
/// <summary>
/// Jquery树
/// </summary>
/// <param name="val"></param>
/// <param name="NameCn"></param>
/// <returns></returns>
public static string JqTreeNs_Doc_CategoryID(string val, string NameCn, SoftProjectAreaEntity item)
{
var Pre_Company = HttpContext.Current.Session["LoginInfo"] as SoftProjectAreaEntity;
var Itemst = SoftProjectAreaEntityDomain.Doc_Categorys.Where(p => p.Pre_CompanyID == Pre_Company.CompanyID);
//var Itemst = SoftProjectAreaEntityDomain.Doc_Categorys;
var treeList = new TreeList(Itemst, "0", "DocCategoryName", "Doc_CategoryID", "ParentDoc_CategoryID", "", "", "Doc_CategoryID", "", "");
var str = HtmlHelpersProject.JqTreeN(null, "Doc_CategoryID", treeList, "", 2);
return(str.ToString());
}
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");
}
/// <summary>
/// Jquery树
/// </summary>
/// <param name="val"></param>
/// <param name="NameCn"></param>
/// <returns></returns>
public static string JqTreeNs_P_CategoryID(string paramNameType, string NameCn, SoftProjectAreaEntity item)
{
var TreeQueryType = Convert.ToInt32(paramNameType);
//var Pre_Company = HttpContext.Current.Session["LoginInfo"] as SoftProjectAreaEntity;
//var Itemst = SoftProjectAreaEntityDomain.P_Categorys.Where(p => p.Pre_CompanyID == Pre_Company.CompanyID);
var Itemst = SoftProjectAreaEntityDomain.P_Categorys;
var treeList = new TreeList(Itemst, "0", "PCategoryName", "P_CategoryID", "ParentP_CategoryID", "", "", "P_CategoryID", "", "");
var str = HtmlHelpersProject.JqTreeN(null, "P_CategoryID", treeList, "", TreeQueryType);
return(str.ToString());
//var Itemst = ProjectCache.P_Categorys;
//var treeList = new TreeList(Itemst, "0", "PCategoryName", "P_ProductCategoryID", "ParentProductCategoryID", "", "", "P_ProductCategoryID", "", "");
// var str = JqTreeN(helper, ID, treeList, "", paramNameType);
// return str;
}
