/// <summary> /// 获取一个未使用的字段名 /// </summary> /// <returns></returns> private string GetNextColName() { var dal = new sys_udf_field_dal(); var field = dal.FindSignleBySql <sys_udf_field>($"SELECT * FROM sys_udf_field ORDER BY id DESC LIMIT 1"); if (field == null) { return("col001"); } int index = int.Parse(field.col_name.Remove(0, 3)); ++index; return("col" + index.ToString().PadLeft(3, '0')); }
/// <summary> /// 获取自定义字段信息 /// </summary> /// <param name="id"></param> /// <returns></returns> public UserDefinedFieldDto GetUdfInfo(long id) { var dal = new sys_udf_field_dal(); var dto = dal.FindSignleBySql <UserDefinedFieldDto>($"select *,col_comment as `name`,cate_id as cate,data_type_id as data_type,is_required as required from sys_udf_field where id={id} and delete_time=0"); if (dto == null) { return(null); } if (dto.data_type == (int)DicEnum.UDF_DATA_TYPE.LIST) { dto.list = dal.FindListBySql <sys_udf_list>($"select * from sys_udf_list where udf_field_id={dto.id} and status_id=0 and delete_time=0"); } return(dto); }