public async Task <List <MiniProguamComponentDTO> > GetMainModule(MiniProgramMainModuleInput input)
{
return(await _mini_programMain.GetMainModuleComponentDTO(input));
}
/// <summary>
/// 小程序接口数据
/// </summary>
/// <param name="input"></param>
/// <returns></returns>
public async Task <List <MiniProguamComponentDTO> > GetMainModuleComponentDTO(MiniProgramMainModuleInput input)
{
var sql = @"SELECT
t2.Component_Id,
t3.Description,
t3.Tag,
t3.Parent_Component_Id,
t4.Component_Code AS component_type,
t4.Component_Name,
t5.Type,
t5.Tittle,
t5.Image AS src,
t5.Value AS skuid
FROM
mini_page_type t0
INNER JOIN mini_page t1 ON t1.Page_Type_Id = t0.Id
INNER JOIN mini_project t11 ON t1.Project_Id = t11.Id
INNER JOIN mini_page_component t2 ON t2.Page_Id = t1.Id
INNER JOIN mini_component t3 ON t3.Id = t2.Component_Id
INNER JOIN mini_component_type t4 ON t4.Id = t3.Sys_Component_Id
LEFT JOIN mini_component_swiper t5 ON t5.Component_Id = t3.Id
WHERE
t0.Deleted = 0
AND t1.Deleted = 0
AND t11.Deleted = 0
AND t2.Deleted = 0
AND t3.Deleted = 0
AND t4.Deleted = 0
AND t11.Project_Code = @Project_Code
AND t0.Type_Code = @Type_Code
ORDER BY
t3.Sort
";
//首页组件
var moduleComponentList = await Db.GetListBySqlAsync <Mini_ProguamComponent>(sql,
("@Project_Code", input.Project_Code),
("@Type_Code", input.Page_TypeCode));
var data = moduleComponentList
.GroupBy(g => new { g.component_id, g.component_type, g.component_name, g.description, g.tag, g.parent_component_id })
.Select(group => new MiniProguamComponentDTO()
{
component_id = group.Key.component_id,
component_type = group.Key.component_type,
component_name = group.Key.component_name,
description = group.Key.description,
parent_component_id = group.Key.parent_component_id,
tag = group.Key.tag,
cons = group.Select(x => new ProductsInfo()
{
Type = x.Type,
tittle = x.tittle,
src = x.src,
skuid = x.skuid
}).ToList()
}).ToList();
//嵌套数据
data.ForEach(item =>
{
item.coms = data.FindAll(d => item.component_id == d.parent_component_id);
});
var newdata = data.FindAll(x => x.parent_component_id == null);
return(newdata.ToList());
}
