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