/// <summary>
/// 保存记录中的自定义字段值，并记录日志
/// </summary>
/// <param name="cate">客户、联系人等类别</param>
/// <param name="userId">操作用户id</param>
/// <param name="objId">记录的id</param>
/// <param name="fields">自定义字段信息</param>
/// <param name="value">自定义字段值</param>
/// <param name="oper_log_cate"></param>
/// <returns></returns>
public bool SaveUdfValue(DicEnum.UDF_CATE cate, long userId, long objId, List <UserDefinedFieldDto> fields, List <UserDefinedFieldValue> value, DicEnum.OPER_LOG_OBJ_CATE oper_log_cate)
{
// 无自定义字段信息
if (value == null)
{
value = new List <UserDefinedFieldValue>();
}
StringBuilder select = new StringBuilder();
StringBuilder values = new StringBuilder();
Dictionary <string, object> dict = new Dictionary <string, object>();
foreach (var val in value)
{
var field = fields.FindAll(s => s.id == val.id);
if (field == null || field.Count == 0)
{
continue;
}
string fieldName = field.First().col_name;
if (val.value != null)
{
select.Append(",").Append(fieldName);
string v = val.value.ToString().Replace("'", "''"); // 转义单引号
values.Append(",'").Append(v).Append("'");
dict.Add(fieldName, val.value);
}
}
string table = GetTableName(cate);
var dal = new sys_udf_field_dal();
string insert = $"INSERT INTO {table} (id,parent_id{select.ToString()}) VALUES ({dal.GetNextIdCom()},{objId}{values.ToString()})";
try
{
int rslt = dal.ExecuteSQL(insert);
if (rslt <= 0)
{
return(false);
}
var user = new sys_resource_dal().FindById(userId);
sys_oper_log log = new sys_oper_log()
{
user_cate = "用户",
user_id = user.id,
name = user.name,
phone = user.mobile_phone == null ? "" : user.mobile_phone,
oper_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now),
oper_object_cate_id = (int)oper_log_cate,
oper_object_id = objId, // 操作对象id
oper_type_id = (int)DicEnum.OPER_LOG_TYPE.ADD,
oper_description = new Tools.Serialize().SerializeJson(dict),
remark = "新增自定义字段值"
}; // 创建日志
new sys_oper_log_dal().Insert(log); // 插入日志
}
catch
{
return(false); // TODO: 异常处理
}
return(true);
}
/// <summary>
/// 增加自定义字段
/// </summary>
/// <param name="cate"></param>
/// <param name="udf"></param>
/// <returns></returns>
public bool AddUdf(DicEnum.UDF_CATE cate, UserDefinedFieldDto udf, long userId)
{
string table = GetTableName(cate);
var dal = new sys_udf_field_dal();
var field = new sys_udf_field();
field.id = dal.GetNextIdCom();
field.col_name = GetNextColName();
field.col_comment = udf.name;
field.description = udf.description;
field.cate_id = udf.cate;
field.data_type_id = udf.data_type;
field.default_value = udf.default_value;
field.is_protected = udf.is_protected;
field.is_required = udf.required;
field.is_encrypted = udf.is_encrypted;
field.is_visible_in_portal = udf.is_visible_in_portal;
field.crm_to_project_udf_id = udf.crm_to_project;
field.sort_order = udf.sort_order;
field.is_active = udf.is_active;
field.display_format_id = udf.display_format;
field.decimal_length = udf.decimal_length;
field.create_user_id = userId;
field.update_user_id = userId;
field.create_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now);
field.update_time = field.create_time;
dal.Insert(field);
OperLogBLL.OperLogAdd <sys_udf_field>(field, field.id, userId, DicEnum.OPER_LOG_OBJ_CATE.SYS_UDF_FILED, "新增自定义字段");
if (udf.data_type == (int)DicEnum.UDF_DATA_TYPE.LIST) // 字段为列表类型，保存列表值
{
if (udf.list != null && udf.list.Count > 0)
{
var listDal = new sys_udf_list_dal();
foreach (var listVal in udf.list)
{
sys_udf_list val = new sys_udf_list();
val.id = listDal.GetNextIdCom();
val.is_default = listVal.is_default;
val.name = listVal.name;
val.sort_order = listVal.sort_order;
val.udf_field_id = field.id;
val.status_id = 0;
val.create_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now);
val.update_time = val.create_time;
val.create_user_id = field.create_user_id;
val.update_user_id = val.create_user_id;
listDal.Insert(val);
OperLogBLL.OperLogAdd <sys_udf_list>(val, val.id, userId, DicEnum.OPER_LOG_OBJ_CATE.SYS_UDF_FILED_LIST, "新增自定义字段值");
}
}
}
string sql = $"alter table {table} add {field.col_name} varchar(";
if (field.data_type_id == (int)DicEnum.UDF_DATA_TYPE.SINGLE_TEXT)
{
sql += "200)";
}
else if (field.data_type_id == (int)DicEnum.UDF_DATA_TYPE.MUILTI_TEXT)
{
sql += "2000)";
}
else
{
sql += "20)";
}
dal.ExecuteSQL(sql);
if (field.cate_id == (int)DicEnum.UDF_CATE.TICKETS)
{
table = GetTableName(DicEnum.UDF_CATE.FORM_RECTICKET);
sql = $"alter table {table} add {field.col_name} varchar(";
if (field.data_type_id == (int)DicEnum.UDF_DATA_TYPE.SINGLE_TEXT)
{
sql += "200)";
}
else if (field.data_type_id == (int)DicEnum.UDF_DATA_TYPE.MUILTI_TEXT)
{
sql += "2000)";
}
else
{
sql += "20)";
}
dal.ExecuteSQL(sql);
table = GetTableName(DicEnum.UDF_CATE.FORM_TICKET);
sql = $"alter table {table} add {field.col_name} varchar(";
if (field.data_type_id == (int)DicEnum.UDF_DATA_TYPE.SINGLE_TEXT)
{
sql += "200)";
}
else if (field.data_type_id == (int)DicEnum.UDF_DATA_TYPE.MUILTI_TEXT)
{
sql += "2000)";
}
else
{
sql += "20)";
}
dal.ExecuteSQL(sql);
}
return(true);
}
