public List <Project> Load(QueryProjectListReq queryProject)
{
//var result = from d in UnitWork.Find<Button>(null) select d;
var listProject = UnitWork.SqlQuery <Project>("select Id, ProjectId,Name,ParentId,ParentName, CascadeId, Label, Explain, CreateTime, " +
"UpdateTime, Sort,IsAble,IsDel From Project order by Sort desc,CreateTime asc", new object[] { }).ToList();
foreach (var p in listProject)
{
var ListWorkflow = UnitWork.SqlQuery <WorkFlow>(
"select wf.* from ProjectWorkflow pw left join Workflow wf on pw.WorkflowId = wf.Id where pw.ProjectId = @ProjectId",
new object[]
{
new SqlParameter()
{
ParameterName = "@ProjectId",
Value = p.Id,
DbType = DbType.String
}
}).ToList();
p.WorkFlowIds = string.Join(",", ListWorkflow.Select(s => s.Id).ToList());
p.WorkFlowNames = string.Join(",", ListWorkflow.Select(s => s.Name).ToList());
p.WorkFlows = ListWorkflow;
}
return(BindNew(listProject, null));
}
/// <summary>
/// 根据按钮加载列表
/// </summary>
/// <param name="project"></param>
/// <returns></returns>
public TableData Load([FromQuery] QueryProjectListReq project)
{
return(new TableData()
{
message = "success",
data = ProjectManagerApp.Load(project)
});
}
