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