public MetadataModel(int mainId, MetaDataTypeEnum dataType) { SortMainId = mainId; MetaDataType = dataType.ToString(); Metadata = SortMetaDataObject.GetSortMetaDatas(SortMainId, MetaDataTypeEnum); }
public List <SortMetaDataObject> GetSortMetaDatas(int sortMainId, MetaDataTypeEnum metaDataType) { string sql = @" SELECT d.*, s.Title as 'SortTitle' FROM dat_SortMetaData d inner join dat_SortMain s on s.SortMainId = d.SortMainId WHERE d.SortMainId = @SortMainId AND d.MetaDataType = @MetaDataType"; return(Config.Conn.Query <SortMetaDataObject>(sql, new { SortMainId = sortMainId, MetaDataType = metaDataType.ToString() }).ToList()); }