/// <summary>
/// 获取单个实体
/// </summary>
/// <param name="keyValue"></param>
/// <returns></returns>
public ActionResult GetFormJson(string keyValue)
{
try
{
AccountRuleEntity entity = _bll.GetEntity(keyValue);
return(ToJsonResult(entity));
}
catch (Exception ex)
{
return(ToJsonResult(ex));
}
}
public ActionResult SaveForm(string keyValue, AccountRuleEntity entity)
{
Operator user = OperatorProvider.Provider.Current();
WriteLog.AddLog($"用户：{user.UserName} id：{user.UserId}开始编辑积分配置{keyValue} \r\n {JsonConvert.SerializeObject(entity)}", "SafetyScore");
try
{
if (_bll.SaveForm(keyValue, entity))
{
return(Success("操作成功"));
}
else
{
return(Error("操作失败"));
}
}
catch (Exception ex)
{
WriteLog.AddLog($"错误 \r\n用户：{user.UserName} id：{user.UserId}编辑积分配置{keyValue}失败 \r\n 错误信息：{JsonConvert.SerializeObject(ex)}", "SafetyScore");
return(Error(ex.Message));
}
}
/// <summary>
/// 保存数据（新增、修改）
/// </summary>
/// <param name="keyValue"></param>
/// <param name="entity"></param>
/// <returns></returns>
public bool SaveForm(string keyValue, AccountRuleEntity entity)
{
return(_ruleService.SaveForm(keyValue, entity));
}
public ActionResult Import()
{
Operator user = OperatorProvider.Provider.Current();
try
{
if (this.Request.Files.Count == 0)
{
throw new Exception("请上传文件");
}
if (!this.Request.Files[0].FileName.EndsWith(".xlsx"))
{
return(Json(new { success = false, message = "请上传excel文件！" }));
}
var book = new Workbook(this.Request.Files[0].InputStream);
var sheet = book.Worksheets[0];
if (sheet.Cells[1, 0].StringValue != "标准*" || sheet.Cells[1, 1].StringValue != "分值*" || sheet.Cells[1, 2].StringValue != "顺序号" || sheet.Cells[1, 3].StringValue != "备注")
{
return(Json(new { success = false, message = "请使用正确的模板导入！" }));
}
List <AccountRuleEntity> importList = new List <AccountRuleEntity>();
for (int i = 2; i <= sheet.Cells.MaxDataRow; i++)
{
if (string.IsNullOrEmpty(sheet.Cells[i, 0].StringValue))
{
throw new Exception($"行号{i + 1}的”标准“不能为空");
}
if (sheet.Cells[i, 0].StringValue.Length > 512)
{
throw new Exception($"行号{i + 1}的”标准“长度不能超过512");
}
if (string.IsNullOrEmpty(sheet.Cells[i, 1].StringValue))
{
throw new Exception($"行号{i + 1}的”分值“不能为空");
}
decimal score = 0;
int sort = 0;
if (decimal.TryParse(sheet.Cells[i, 1].StringValue, out score))
{
Math.Round(score, 1);
}
else
{
throw new Exception($"行号{i + 1}的”分值“必须为小数");
}
if (score < 0)
{
throw new Exception($"行号{i + 1}的”分值“不能为负数");
}
if (!string.IsNullOrEmpty(sheet.Cells[i, 2].StringValue))
{
if (int.TryParse(sheet.Cells[i, 2].StringValue, out sort))
{
}
}
AccountRuleEntity import = new AccountRuleEntity()
{
Standard = sheet.Cells[i, 0].StringValue,
Score = score,
ScoreType = Enum.GetName(typeof(ScoreType), ScoreType.手动),
Sort = sort,
Remark = sheet.Cells[i, 3].StringValue,
IsOpen = 1,
};
import.Create();
importList.Add(import);
}
if (importList.Count > 0)
{
_bll.Insert(importList);
}
return(Json(new { success = true, message = "导入成功" }));
}
catch (Exception ex)
{
return(Json(new { success = false, message = ex.Message }));
}
}
