public static List <GridColumnClrUserDefineDto> GetGridColumnIDAndName(int gridID) { List <GridColumnClrUserDefineDto> aGridColumns = new List <GridColumnClrUserDefineDto>(); using (SqlConnection conn = new SqlConnection(PLMConstantString.PLM_APP_ConnectionString)) { conn.Open(); // call udf function RetriveProductTabCopyRootTabID string qeuryGridColumn = string.Format(@"SELECT PdmGridMetaColumn.GridColumnID, PdmGridMetaColumn.ColumnName, PdmGridMetaColumn.ColumnTypeID , pdmEntity.EntityCode, pdmEntity.EntityID, pdmEntity.SysTableName FROM PdmGridMetaColumn LEFT OUTER JOIN pdmEntity ON PdmGridMetaColumn.EntityID = pdmEntity.EntityID WHERE GridID={0} ", gridID); SqlCommand cmd = new SqlCommand(qeuryGridColumn, conn); SqlDataAdapter adapter = new SqlDataAdapter(cmd); System.Data.DataTable resultTabel = new DataTable(); adapter.Fill(resultTabel); foreach (DataRow aRow in resultTabel.Rows) { int aColumnID = (int)aRow["GridColumnID"]; string colName = DataTableUtility.FilterSQLDBInvalidChar(aRow["ColumnName"].ToString() + "_" + aColumnID); int? entityID = aRow["EntityID"] as int?; string entityCode = DataTableUtility.FilterSQLDBInvalidChar(aRow["EntityCode"].ToString()); string systemTable = aRow["SysTableName"].ToString(); if (entityID.HasValue) { PdmEntityBlClrDto aEntityBlClrDto = PdmCacheManager.DictPdmEntityBlEntity[entityID.Value]; if (aEntityBlClrDto.EntityType == (int)EmEntityType.UserDefineTable) { colName += "_FK_" + PLMConstantString.PLM_DW_UserDefineTablePrefix + entityCode + "_" + entityID; } else { colName += "_FK_" + systemTable; } } int controlType = int.Parse(aRow["ColumnTypeID"].ToString()); GridColumnClrUserDefineDto aDto = new GridColumnClrUserDefineDto(); aDto.GridColumnID = aColumnID; aDto.ColumnName = colName; aDto.EntityID = entityID; aDto.ColumnTypeId = controlType; aGridColumns.Add(aDto); } } return(aGridColumns); }
private static List <GridColumnClrUserDefineDto> GetTabGridBlockColumnAliasName(int tabId, PdmBlockClrDto dmBlockClrDto) { int gridId = dmBlockClrDto.BlockPdmGridDto.GridId; List <GridColumnClrUserDefineDto> printColumnListDto = PLMSDWScriptGenerator.GetGridColumnIDAndName(int.Parse(gridId.ToString())); Dictionary <int, GridColumnClrUserDefineDto> dictAllGridColumnClrDto = printColumnListDto.ToDictionary(o => o.GridColumnID, o => o); List <GridColumnClrUserDefineDto> selectGridColumnClrDto = new List <GridColumnClrUserDefineDto>(); // need to check pdmgridmatacolumn string queryPdmTabGridMetaColumn = @" SELECT distinct dbo.pdmTabGridMetaColumn.GridColumnID, dbo.pdmTabGridMetaColumn.Visible, dbo.pdmTabGridMetaColumn.AliasName, dbo.pdmTabGridMetaColumn.BlockID AS GridBlockID FROM dbo.pdmBlockSubItem INNER JOIN dbo.PdmTabBlock ON dbo.pdmBlockSubItem.BlockID = dbo.PdmTabBlock.BlockID LEFT OUTER JOIN dbo.pdmTabGridMetaColumn ON dbo.PdmTabBlock.BlockID = dbo.pdmTabGridMetaColumn.BlockID AND dbo.PdmTabBlock.TabID = dbo.pdmTabGridMetaColumn.TabID WHERE (dbo.pdmBlockSubItem.ControlType = @ControlType) AND (dbo.PdmTabBlock.TabID = @TabID ) AND (dbo.pdmTabGridMetaColumn.BlockID = @GridBlockID)"; // List <SqlParameter> listParamtetrs = new List <SqlParameter>(); SqlParameter ControlTypePara = new SqlParameter("@ControlType", (int)EmControlType.Grid); SqlParameter TabIDPara = new SqlParameter("@TabID", tabId); SqlParameter GridBlockIDpara = new SqlParameter("@GridBlockID", dmBlockClrDto.BlockId); listParamtetrs.Add(ControlTypePara); listParamtetrs.Add(TabIDPara); listParamtetrs.Add(GridBlockIDpara); DataTable TabGridColumnResult; using (SqlConnection conn = new SqlConnection(PLMConstantString.PLM_APP_ConnectionString)) { conn.Open(); TabGridColumnResult = DataAcessHelper.GetDataTableQueryResult(conn, queryPdmTabGridMetaColumn, listParamtetrs); } // CLROutput.SendDataTable(TabGridColumnResult); if (TabGridColumnResult.Rows.Count > 0) { foreach (DataRow aRow in TabGridColumnResult.Rows) { int GridColumnID = (int)aRow["GridColumnID"]; bool? isVisalbe = aRow["Visible"] as bool?; string AliasName = aRow["AliasName"] as string; if (isVisalbe.HasValue && isVisalbe.Value) { GridColumnClrUserDefineDto aGridColumnClrDto = dictAllGridColumnClrDto[GridColumnID]; if (!string.IsNullOrEmpty(AliasName)) { string aName = AliasName.Trim(); if (aName.Length > 0) { aGridColumnClrDto.ColumnName = AliasName; } } selectGridColumnClrDto.Add(aGridColumnClrDto); } } printColumnListDto = selectGridColumnClrDto; } return(printColumnListDto); }