jxycms
5/25/2017 - 7:09 AM

get custom table properties value according to item id

get custom table properties value according to item id

// ID : Item ID
// displayField: other customer table properties


public static string GetCustomTableField(string customTableClassName, int ID, string displayField)
{
    try
    {
        string returnvalue = "";

        DataSet data = CacheHelper.Cache(cs => GetCustomTableDSInternal(cs, customTableClassName),
            new CacheSettings(20, "customtabledatasource|" + customTableClassName.ToLower()));

        DataClassInfo customTable = DataClassInfoProvider.GetDataClassInfo(customTableClassName);
        if (!DataHelper.DataSourceIsEmpty(data))
        {
            DataRow[] rows = data.Tables[0].Select("ItemID = " + ID);
            if (rows.Length > 0)
            {
                returnvalue = ValidationHelper.GetString(rows[0][displayField], string.Empty);
            }
        }
        return returnvalue;
    }

    catch (Exception ex)
    {
        EventLogProvider.LogException("BDHelpers", "GetCustomTableField", ex);
        return "";
    }
}