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);
}
