//select EntityID ,EntityCode ,EntityType,SysTableName from pdmEntity
public static PdmEntityColumnClrUserDefineDto ConvertErpExchangeDatabaseTableColumnDataRowToPdmEntityColumnDto(DataRow row)
{
PdmEntityColumnClrUserDefineDto aPdmEntityDto = new PdmEntityColumnClrUserDefineDto();
// aPdmEntityDto.UserDefineEntityColumnID = (int)row["UserDefineEntityColumnID"];
// aPdmEntityDto.EntityId = (int)row["EntityID"];
aPdmEntityDto.ColumnName = row["ColumnName"] as string;
aPdmEntityDto.DataBaseDataType = row["DataType"] as string;
aPdmEntityDto.IsPrimaryKey = row["PrimaryKey"] as bool?;
aPdmEntityDto.UicontrolType = PLMDataRowConverter.ConvertDataBaseDataTypeToUicontrolType(aPdmEntityDto.DataBaseDataType);
if (aPdmEntityDto.DataBaseDataType == "float"
|| aPdmEntityDto.DataBaseDataType == "real"
|| aPdmEntityDto.DataBaseDataType == "decimal")
{
aPdmEntityDto.Nbdecimal = row["Scale"] as int?;
}
// aPdmEntityDto.Nbdecimal
//aPdmEntityDto.UicontrolType
// aPdmEntityDto.IsIdentity = row["PrimaryKey"] as bool?;
//aPdmEntityDto.UsedByDropDownList = row["UsedByDropDownList"] as bool?;
//aPdmEntityDto.DataRowSort = row["DataRowSort"] as int?;
//aPdmEntityDto.IsPrimaryKey = row["IsPrimaryKey"] as bool?;
//aPdmEntityDto.IsIdentity = row["IsIdentity"] as bool?;
//aPdmEntityDto.SystemTableColumnName = row["SystemTableColumnName"] as string;
//aPdmEntityDto.FkentityId = row["FkentityId"] as int?;
// aPdmEntityDto.UicontrolType = row["UicontrolType"] as int?;
// aPdmEntityDto.Nbdecimal = row["Nbdecimal"] as int?;
return(aPdmEntityDto);
}
public static List <PdmEntityColumnClrUserDefineDto> GetErpExchangeDatabaseTableColumnDto(SqlConnection conn, string databaseTableName)
{
string query = string.Format(@"SELECT Columns.COLUMN_NAME as ColumnName,Columns.DATA_TYPE as DataType,
Columns.CHARACTER_MAXIMUM_LENGTH as MaxLength, Columns.DATETIME_PRECISION as Precision, Columns.NUMERIC_SCALE as Scale,
cast( (case when PK.COLUMN_NAME Is not null then 1 else 0 end) as bit) as PrimaryKey
FROM information_schema.columns as Columns
left join
(
SELECT column_name
FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE
WHERE OBJECTPROPERTY(OBJECT_ID(constraint_name), 'IsPrimaryKey') = 1
AND table_name = '{0}'
) as PK on Pk.COLUMN_NAME = Columns.COLUMN_NAME
WHERE table_name = '{0}' and
( Columns.DATA_TYPE <> 'timestamp' and Columns.DATA_TYPE <>'image'
and Columns.DATA_TYPE <>'xml'
and Columns.DATA_TYPE <>'varbinary'
)
and Columns.COLUMN_NAME NOT IN ('{1}') ",
databaseTableName,
PLMConstantString.ExchangeRowDataChangeTimeStamp
);
List <PdmEntityColumnClrUserDefineDto> toreturnList = new List <PdmEntityColumnClrUserDefineDto>();
// PLMSDataImport.ExchangeRowDataPLMImportDateTimeColumn
// CLROutput.Output(query);
var result = DataAcessHelper.GetDataTableQueryResult(conn, query);
// CLROutput.SendDataTable(result);
foreach (DataRow arow in result.Rows)
{
PdmEntityColumnClrUserDefineDto fromDataBaseDto = PLMDataRowConverter.ConvertErpExchangeDatabaseTableColumnDataRowToPdmEntityColumnDto(arow);
toreturnList.Add(fromDataBaseDto);
}
var textboxColumn = toreturnList.Where(o => o.UicontrolType == (int)EmControlType.TextBox).FirstOrDefault();
if (textboxColumn != null)
{
textboxColumn.UsedByDropDownList = true;
}
return(toreturnList);
}
//select EntityID ,EntityCode ,EntityType,SysTableName from pdmEntity
public static PdmEntityColumnClrUserDefineDto ConvertUserDefineEntityColumnDataRowToPdmEntityColumnDto(DataRow row)
{
PdmEntityColumnClrUserDefineDto aPdmEntityDto = new PdmEntityColumnClrUserDefineDto();
aPdmEntityDto.UserDefineEntityColumnID = (int)row["UserDefineEntityColumnID"];
aPdmEntityDto.EntityId = (int)row["EntityID"];
aPdmEntityDto.ColumnName = row["ColumnName"] as string;
// aPdmEntityDto.DataType = row["ColumnName"] as int?;
aPdmEntityDto.UsedByDropDownList = row["UsedByDropDownList"] as bool?;
aPdmEntityDto.DataRowSort = row["DataRowSort"] as int?;
aPdmEntityDto.IsPrimaryKey = row["IsPrimaryKey"] as bool?;
aPdmEntityDto.IsIdentity = row["IsIdentity"] as bool?;
aPdmEntityDto.SystemTableColumnName = row["SystemTableColumnName"] as string;
aPdmEntityDto.FkentityId = row["FkentityId"] as int?;
aPdmEntityDto.UicontrolType = row["UicontrolType"] as int?;
aPdmEntityDto.Nbdecimal = row["Nbdecimal"] as int?;
return(aPdmEntityDto);
}
