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