public static List <PdmClrEntitySimpleStructureDto> GetEntityAndColumnStrcutureInfoList(List <int> entityIDs) { List <PdmClrEntitySimpleStructureDto> listPdmEntityDto = new List <PdmClrEntitySimpleStructureDto>(); if (entityIDs != null && entityIDs.Count > 0) { string entityQuery = "select distinct EntityID ,EntityCode ,EntityType,SysTableName from pdmEntity "; string entityIdInClause = DataAcessHelper.GenerateColumnInClauseWithAndCondition(entityIDs, "EntityID", false); entityQuery = entityQuery + " where " + entityIdInClause; using (SqlConnection conn = new SqlConnection(PLMConstantString.PLM_APP_ConnectionString)) { conn.Open(); DataTable entityDataTable = DataAcessHelper.GetDataTableQueryResult(conn, entityQuery); foreach (DataRow row in entityDataTable.Rows) { listPdmEntityDto.Add(PLMDataRowConverter.ConvertRowToPdmEntityDto(row)); } string queryColumn = @" select UserDefineEntityColumnID, EntityId, ColumnName,DataType,UsedByDropDownList,DataRowSort,IsPrimaryKey,IsIdentity,SystemTableColumnName,UicontrolType,Nbdecimal,FkentityId from PdmUserDefineEntityColumn " + " where " + entityIdInClause; DataTable columnDataTable = DataAcessHelper.GetDataTableQueryResult(conn, queryColumn); List <PdmEntityColumnClrUserDefineDto> allColumnDto = new List <PdmEntityColumnClrUserDefineDto>(); foreach (DataRow row in columnDataTable.Rows) { allColumnDto.Add(PLMDataRowConverter.ConvertUserDefineEntityColumnDataRowToPdmEntityColumnDto(row)); } foreach (var entityDto in listPdmEntityDto) { entityDto.Columns = allColumnDto.Where(o => o.EntityId == entityDto.EntityId).ToList(); } } } return(listPdmEntityDto); }