/// <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);
}
