/// <summary> /// 根据商机获取相应项目的值 /// </summary> public void GetPorUdfByOpp(HttpContext context, long oppo_id) { var thisOpp = new crm_opportunity_dal().FindNoDeleteById(oppo_id); if (thisOpp != null) { var projectUdfList = new UserDefinedFieldsBLL().GetUdf(DicEnum.UDF_CATE.PROJECTS); var oppoUdfList = new UserDefinedFieldsBLL().GetUdf(DicEnum.UDF_CATE.OPPORTUNITY); var oppoValueList = new UserDefinedFieldsBLL().GetUdfValue(DicEnum.UDF_CATE.OPPORTUNITY, thisOpp.id, oppoUdfList); if (projectUdfList != null && projectUdfList.Count > 0) { StringBuilder udfHtml = new StringBuilder(); var sufDal = new sys_udf_field_dal(); foreach (var thisProUdf in projectUdfList) { var thisSysProFile = sufDal.FindNoDeleteById(thisProUdf.id); if (thisSysProFile != null && thisSysProFile.crm_to_project_udf_id != null) { var thisSysOppFile = sufDal.FindNoDeleteById((long)thisSysProFile.crm_to_project_udf_id); var oppoValue = oppoValueList.FirstOrDefault(_ => _.id == thisSysProFile.crm_to_project_udf_id); if (oppoValue != null && thisSysOppFile != null && !string.IsNullOrEmpty(oppoValue.value.ToString())) { udfHtml.Append($"<tr height='21'><td id ='txtBlack8'>{thisSysProFile.col_comment}</td><td> {thisSysOppFile.col_comment} </td><td>{oppoValue.value.ToString()}<input type='hidden' name='{thisProUdf.id.ToString()}' id='{thisProUdf.id.ToString()}' value='{oppoValue.value.ToString()}' /></ td></ tr>"); } } } context.Response.Write(udfHtml.ToString()); } } }
/// <summary> /// 删除自定义字段 /// </summary> /// <param name="id"></param> /// <param name="userId"></param> /// <returns></returns> public bool DeleteUdf(long id, long userId) { var dal = new sys_udf_field_dal(); var udf = dal.FindNoDeleteById(id); if (udf == null) { return(false); } udf.delete_time = Tools.Date.DateHelper.ToUniversalTimeStamp(); udf.delete_user_id = userId; dal.Update(udf); return(true); }
/// <summary> /// 激活/取消激活自定义字段 /// </summary> /// <param name="id"></param> /// <param name="active"></param> /// <returns></returns> public bool UpdateUdfStatus(long id, bool active, long userId) { var dal = new sys_udf_field_dal(); var udf = dal.FindNoDeleteById(id); if (udf == null) { return(false); } if (active) { udf.is_active = 1; } else { udf.is_active = 0; } udf.update_time = Tools.Date.DateHelper.ToUniversalTimeStamp(); udf.update_user_id = userId; dal.Update(udf); return(true); }
/// <summary> /// 新增编辑自定义字段 /// </summary> /// <param name="cate"></param> /// <param name="udf"></param> /// <param name="userId"></param> /// <returns></returns> public bool EditUdf(DicEnum.UDF_CATE cate, UserDefinedFieldDto udf, long userId) { if (udf.id == 0) { return(AddUdf(cate, udf, userId)); } var dal = new sys_udf_field_dal(); var field = dal.FindNoDeleteById(udf.id); if (field == null) { return(false); } field.col_comment = udf.name; field.description = udf.description; 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.update_user_id = userId; field.update_time = Tools.Date.DateHelper.ToUniversalTimeStamp(); var fieldOld = dal.FindById(field.id); var desc = OperLogBLL.CompareValue <sys_udf_field>(fieldOld, field); if (!string.IsNullOrEmpty(desc)) { dal.Update(field); OperLogBLL.OperLogUpdate(desc, field.id, userId, DicEnum.OPER_LOG_OBJ_CATE.SYS_UDF_FILED, "编辑自定义字段"); } var listDal = new sys_udf_list_dal(); var list = dal.FindListBySql <sys_udf_list>($"select * from sys_udf_list where udf_field_id={field.id} and status_id=0 and delete_time=0"); //var find=udf.list.Find(_=>_.is_default==1) foreach (var ufv in udf.list) { var find = list.Find(_ => _.id == ufv.id); if (find == null) { sys_udf_list val = new sys_udf_list(); val.id = listDal.GetNextIdCom(); val.is_default = ufv.is_default; val.name = ufv.name; val.sort_order = ufv.sort_order; val.udf_field_id = udf.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, "新增自定义字段值"); } else { if (find.is_default != ufv.is_default) { find.is_default = ufv.is_default; find.update_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now); find.update_user_id = userId; var old = listDal.FindById(find.id); listDal.Update(find); OperLogBLL.OperLogUpdate(OperLogBLL.CompareValue <sys_udf_list>(old, find), find.id, userId, DicEnum.OPER_LOG_OBJ_CATE.SYS_UDF_FILED_LIST, "编辑自定义字段值"); } list.Remove(find); } } foreach (var ufv in list) { ufv.delete_time = Tools.Date.DateHelper.ToUniversalTimeStamp(); ufv.delete_user_id = userId; listDal.Update(ufv); OperLogBLL.OperLogDelete <sys_udf_list>(ufv, ufv.id, userId, DicEnum.OPER_LOG_OBJ_CATE.SYS_UDF_FILED_LIST, "删除自定义字段值"); } return(true); }