Ejemplo n.º 1
0
        /// <summary>
        /// 获取一个对象包含的用户自定义字段信息
        /// </summary>
        /// <param name="cate">对象分类</param>
        /// <returns></returns>
        public List <UserDefinedFieldDto> GetUdf(DicEnum.UDF_CATE cate)
        {
            var    dal        = new sys_udf_field_dal();
            var    udfListDal = new sys_udf_list_dal();
            string sql        = dal.QueryStringDeleteFlag($"SELECT id,col_name,col_comment as name,description,data_type_id as data_type,default_value,decimal_length,is_required as required,is_protected FROM sys_udf_field WHERE is_active=1 and delete_time=0 and cate_id = {(int)cate} ORDER BY sort_order");
            var    list       = dal.FindListBySql <UserDefinedFieldDto>(sql);

            foreach (var udf in list)
            {
                if (udf.data_type == (int)DicEnum.UDF_DATA_TYPE.LIST)
                {
                    var valList = udfListDal.FindListBySql <DictionaryEntryDto>(udfListDal.QueryStringDeleteFlag($"SELECT id as 'val',name as 'show',is_default as 'select' FROM sys_udf_list WHERE udf_field_id={udf.id} and delete_time=0 and status_id=0 ORDER BY sort_order"));
                    if (valList != null && valList.Count != 0)
                    {
                        udf.value_list = valList;
                    }
                }
            }

            return(list);
        }