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