Example #1
0
        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);
        }