//select EntityID ,EntityCode ,EntityType,SysTableName from pdmEntity
public static PdmTabClrDto ConvertDataRowDto(DataRow row)
{
PdmTabClrDto aDto = new PdmTabClrDto();
aDto.TabId = (System.Int32)row["TabID"];
aDto.TabGroupId = row["TabGroupID"] as System.Int32 ? ;
aDto.TabName = (System.String)row["TabName"];
aDto.TabDescription = row["TabDescription"] as System.String;
aDto.CreatedBy = row["CreatedBy"] as System.Int32 ? ;
aDto.CreateDate = row["CreateDate"] as System.DateTime ? ;
aDto.ModifydBy = row["ModifydBy"] as System.Int32 ? ;
aDto.ModifyDate = row["ModifyDate"] as System.DateTime ? ;
aDto.ManagementLevel = row["ManagementLevel"] as System.Byte ? ;
aDto.InternalCode = row["InternalCode"] as System.String;
aDto.IsTemplateHeaderTab = row["IsTemplateHeaderTab"] as System.Boolean ? ;
aDto.IsProductDependent = row["IsProductDependent"] as System.Boolean ? ;
aDto.IsMasterReferenceHeaderTab = row["IsMasterReferenceHeaderTab"] as System.Boolean ? ;
aDto.ParentId = row["ParentID"] as System.Int32 ? ;
aDto.IsHideMasterHeader = row["IsHideMasterHeader"] as System.Boolean ? ;
aDto.ProductReferenceId = row["ProductReferenceID"] as System.Int32 ? ;
aDto.IsHideTemplateHeader = row["IsHideTemplateHeader"] as System.Boolean ? ;
aDto.IsUsedForUpdate = row["IsUsedForUpdate"] as System.Boolean ? ;
aDto.SearchUpdateRefTxScope = row["SearchUpdateRefTxScope"] as System.Int32 ? ;
aDto.IsUsedForSearch = row["IsUsedForSearch"] as System.Boolean ? ;
aDto.FolderId = (System.Int32)row["FolderID"];
aDto.ProductCopyTabSort = row["ProductCopyTabSort"] as System.Int32 ? ;
aDto.ProductCopyTabRootTabId = row["ProductCopyTabRootTabID"] as System.Int32 ? ;
aDto.SiblingCopyTabId = row["SiblingCopyTabID"] as System.Int32 ? ;
aDto.IsTabHeader = row["IsTabHeader"] as System.Boolean ? ;
aDto.TabHeaderId = row["TabHeaderID"] as System.Int32 ? ;
aDto.IsTemplateHeaderCollpase = row["IsTemplateHeaderCollpase"] as System.Boolean ? ;
aDto.IsMasterRefHeaderCollapse = row["IsMasterRefHeaderCollapse"] as System.Boolean ? ;
aDto.IsTabHeaderCollapse = row["IsTabHeaderCollapse"] as System.Boolean ? ;
aDto.CopyTabValueHolderProductReferenceId = row["CopyTabValueHolderProductReferenceID"] as System.Int32 ? ;
aDto.SystemTimeStamp = (System.Byte[])row["SystemTimeStamp"];
aDto.Uilayout = row["UILayout"] as System.Byte[];
aDto.RowIdentity = row["RowIdentity"] as System.Guid ? ;
aDto.PrintUilayout = row["PrintUILayout"] as System.Byte[];
aDto.PrintTabHight = row["PrintTabHight"] as System.Int32 ? ;
aDto.PrintTabWidth = row["PrintTabWidth"] as System.Int32 ? ;
aDto.IsAllowProductTabCopy = row["IsAllowProductTabCopy"] as System.Boolean ? ;
return(aDto);
}
private static System.Data.DataTable GetTabDataTable(int tabId, string referenceIds, bool isShowLookupitem, bool IsSubItemFullPathName)
{
string[] arrayInputmainReferenceIds = referenceIds.Trim().Replace(System.Environment.NewLine, "").Split(',');
PdmTabClrDto aPdmTabClrDto = PdmCacheManager.DictTabCache[tabId];
List <BlockSubitemClrUserDefineDto> tabSubitemDtoList = PdmCacheManager.GetTabBlockSubitem(tabId);
List <int> subitemIds = tabSubitemDtoList.Select(o => o.SubItemID).ToList();
List <PdmBlockSubItemClrDto> listclrSubitems = PdmCacheManager.GetMutiplePdmBlockSubItemEntityFromCache(subitemIds);
System.Data.DataTable tabFieldResultDataTable = PLMSReferenceValueRetrieveBL.RetrieveDataTableReferenceSimpleDcutValue(arrayInputmainReferenceIds, listclrSubitems, isShowLookupitem);
#region ------------- update Datatable column name by name conversion
Dictionary <string, DataColumn> dictDataColumn = new Dictionary <string, DataColumn>();
foreach (DataColumn dataColumn in tabFieldResultDataTable.Columns)
{
dictDataColumn.Add(dataColumn.ColumnName, dataColumn);
}
if (IsSubItemFullPathName)
{
foreach (var subitemDto in tabSubitemDtoList)
{
if (dictDataColumn.ContainsKey(subitemDto.SubItemID.ToString()))
{
dictDataColumn[subitemDto.SubItemID.ToString()].ColumnName = subitemDto.SubItemFullPathName;
}
}
}
else // it iwll show externa mappimg name
{
var dictSubItemMappng = PdmTabBlockSubItemExtraInfoDal.DictTabSubitemExternapMappingName[tabId];
List <string> noMappingColumnsList = new List <string>();
var productRefereIdSubItemDto = PdmCacheManager.GetPdmBlockSubItemDtoWithInternalCode(BlockRegister.ProductReferenceIdBlock.ProductReferenceId);
string referenceIdExternaName = "";
foreach (int subItemID in dictSubItemMappng.Keys)
{
if (dictDataColumn.ContainsKey(subItemID.ToString()))
{
string exterName = dictSubItemMappng[subItemID];
if (string.IsNullOrEmpty(exterName))
{
exterName = subItemID.ToString() + "_NoMapping";
noMappingColumnsList.Add(exterName);
}
dictDataColumn[subItemID.ToString()].ColumnName = exterName;
if (subItemID == productRefereIdSubItemDto.SubItemId)
{
referenceIdExternaName = exterName;
}
}
}
foreach (string nomappingColumn in noMappingColumnsList)
{
tabFieldResultDataTable.Columns.Remove(nomappingColumn);
}
if (!string.IsNullOrEmpty(referenceIdExternaName))
{
// need to remove hradr coding referenceId
if (tabFieldResultDataTable.Columns.Contains(referenceIdExternaName))
{
tabFieldResultDataTable.Columns.Remove(referenceIdExternaName);
// rename productReferenId as referenceIdExternaName
tabFieldResultDataTable.Columns["ProductReferenceID"].ColumnName = referenceIdExternaName;
}
}
}
#endregion
return(tabFieldResultDataTable);
}
