public bool FillRdField(FillFieldRdColumnModel param) { var result = true; try { LegacyCodeHandler legacyCodeHandler = new LegacyCodeHandler(_legacyCodeHandler); var rd = _dbKyStatic.Queryable <ResultData>().Where(x => x.Id == param.ResultDataId).ToList().FirstOrDefault(); var tableName = rd.TableName; StringBuilder filter = new StringBuilder(); filter.Append($" update dbo.[{tableName}] set [{param.ColumnName}] =@value where "); switch (param.Condition) { case "null": filter.Append($"[{param.ColumnName}] is null and "); break; case "blank": filter.Append($"[{param.ColumnName}] ='' and "); break; case "blankOrNull": filter.Append($"[{param.ColumnName}] is null or [{param.ColumnName}] ='' and "); break; } filter.Append(" 1=1"); var count = _dbResearch.Ado.ExecuteCommand(filter.ToString(), new List <SugarParameter>() { new SugarParameter("@value", param.FieldValue) }); if (count > 0) { var dt = GetOriginalDataFromMySql(tableName); legacyCodeHandler.GenerateColumnDataForSingleColumn(dt, param.ColumnName, param.RdDataColumnId); } } catch (Exception ex) { _logger.LogError("FillRdField:" + ex.ToString()); result = false; } return(result); }
public JsonResult FillRdField(FillFieldRdColumnModel param) { try { _logRepository.Add("数据检查-填充", $"rdResultId:{param.ResultDataId},column Id:{param.RdDataColumnId}"); var result = false; result = _dataManageRepository.FillRdField(param); var msg = "操作成功"; if (!result) { msg = "操作失败"; } return(Json(new { success = result, msg })); } catch (Exception ex) { return(Json(new { success = false, msg = ex.ToString() })); } }