public ActionResult Edit(RiskClassIficationEntity model)
{
var resultModel = new RespResultCountViewModel();
try
{
#region 验证
if (string.IsNullOrEmpty(model.OrgId) || string.IsNullOrEmpty(model.RiskPointBH))
{
resultModel.code = -1;
resultModel.msg = "存在必填项！";
return(Ok(resultModel));
}
//if (_riskclassificationService.IsExist(model.OrgId, model.RiskPointBH, model.Id))
//{
// resultModel.code = -1;
// resultModel.msg = "请勿重复添加风险点编号！";
// return Ok(resultModel);
//}
#endregion
model.RiskR = model.SeverityS * model.PossibleL;
if (model.RiskR >= 12 && model.RiskR <= 20)
{
model.RiskLevel = "1";
}
if (model.RiskR >= 8 && model.RiskR <= 10)
{
model.RiskLevel = "2";
}
if (model.RiskR >= 4 && model.RiskR <= 6)
{
model.RiskLevel = "3";
}
if (model.RiskR < 4)
{
model.RiskLevel = "4";
}
bool result = _riskclassificationService.Update(model);
if (result)
{
resultModel.code = 0;
resultModel.msg = "修改成功";
resultModel.data = null;
}
else
{
resultModel.code = -1;
resultModel.msg = "修改失败";
resultModel.data = null;
}
return(Ok(resultModel));
}
catch (Exception ex)
{
resultModel.code = -1;
resultModel.msg = "操作失败:" + ex.Message;
resultModel.data = null;
return(Ok(resultModel));
}
}
/// <summary>
/// 新增
/// </summary>
/// <param name="entity">实体</param>
/// <returns></returns>
public bool Insert(RiskClassIficationEntity entity)
{
using (var db = _dbContext.GetIntance())
{
var count = db.Insertable(entity).ExecuteCommand();
result = count > 0 ? true : false;
}
return(result);
}
/// <summary>
/// 修改
/// </summary>
/// <param name="entity">实体</param>
/// <returns></returns>
public bool Update(RiskClassIficationEntity entity)
{
using (var db = _dbContext.GetIntance())
{
var count = db.Updateable(entity)
.IgnoreColumns(it => new { it.DeleteMark, it.CreateTime })
.Where(it => it.Id == entity.Id)
.ExecuteCommand();
result = count > 0 ? true : false;
}
return(result);
}
/// <summary>
/// 修改
/// </summary>
/// <param name="entity">实体</param>
/// <returns></returns>
public bool Update(RiskPointEntity entity)
{
using (var db = _dbContext.GetIntance())
{
try
{
db.Ado.BeginTran();
var updatalist = db.Queryable <RiskPointEntity>().Where(it => it.Id == entity.Id).First();
if (db.Queryable <RiskClassIficationEntity>().Any(it => it.RiskPointBH == updatalist.RiskPointBH && it.OrgId == updatalist.OrgId))
{
RiskClassIficationEntity classEntity = new RiskClassIficationEntity()
{
RiskPointBH = entity.RiskPointBH,
RiskPointName = entity.Name
};
db.Updateable(classEntity).UpdateColumns(it => new { it.RiskPointBH, it.RiskPointName })
.Where(it => it.RiskPointBH == updatalist.RiskPointBH).ExecuteCommand();
}
if (db.Queryable <JobRiskEntity>().Any(it => it.RiskPointBH == updatalist.RiskPointBH && it.OrgId == updatalist.OrgId))
{
JobRiskEntity jobriskEntity = new JobRiskEntity()
{
RiskPointBH = entity.RiskPointBH,
RiskPointName = entity.Name
};
db.Updateable(jobriskEntity).UpdateColumns(it => new { it.RiskPointBH, it.RiskPointName })
.Where(it => it.RiskPointBH == updatalist.RiskPointBH).ExecuteCommand();
}
/* if (db.Queryable<CheckTableEntity>().Any(it => it.RiskPointBH == updatalist.RiskPointBH))
* {
* CheckTableEntity checkTableEntity = new CheckTableEntity()
* {
* RiskPointBH = entity.RiskPointBH,
* RiskPointName = entity.Name
* };
* db.Updateable(checkTableEntity).UpdateColumns(it => new { it.RiskPointBH, it.RiskPointName })
* .Where(it => it.RiskPointBH == updatalist.RiskPointBH).ExecuteCommand();
* }*/
db.Updateable(entity).IgnoreColumns(it => new { it.DeleteMark, it.CreateTime }).Where(it => it.Id == entity.Id).ExecuteCommand();
db.Ado.CommitTran();
}
catch (Exception ex)
{
db.Ado.RollbackTran();
return(false);
}
}
return(true);
}
/// <summary>
/// 删除
/// </summary>
/// <param name="keyValue">主键</param>
public bool Delete(string keyValue)
{
if (!string.IsNullOrEmpty(keyValue))
{
using (var db = _dbContext.GetIntance())
{
var entity = new RiskClassIficationEntity();
entity.DeleteMark = 0;
//逻辑删除
var count = db.Updateable(entity).UpdateColumns(it => new { it.DeleteMark })
.Where(it => it.Id == keyValue)
.ExecuteCommand();
return(count > 0 ? true : false);
}
}
else
{
result = false;
}
return(result);
}
public ActionResult Create(RiskClassIficationEntity model)
{
var resultModel = new RespResultCountViewModel();
var testid = User.GetCurrentUserOrganizeId().ToString();
try
{
#region 验证
if (string.IsNullOrEmpty(model.OrgId) || string.IsNullOrEmpty(model.RiskPointBH))
{
resultModel.code = -1;
resultModel.msg = "存在必填项！";
return(Ok(resultModel));
}
//if (_riskclassificationService.IsExist(model.OrgId, model.RiskPointBH, model.Id))
//{
// resultModel.code = -1;
// resultModel.msg = "请勿重复添加风险点编号！";
// return Ok(resultModel);
//}
#endregion
model.Id = ConstDefine.CreateGuid();
model.CreateTime = DateTime.Now;
model.DeleteMark = 1;
model.RiskR = model.SeverityS * model.PossibleL;
if (model.RiskR >= 12 && model.RiskR <= 20)
{
model.RiskLevel = "1";
}
if (model.RiskR >= 8 && model.RiskR <= 10)
{
model.RiskLevel = "2";
}
if (model.RiskR >= 4 && model.RiskR <= 6)
{
model.RiskLevel = "3";
}
if (model.RiskR < 4)
{
model.RiskLevel = "4";
}
bool result = _riskclassificationService.Insert(model);
if (result)
{
resultModel.code = 0;
resultModel.msg = "新增成功";
}
else
{
resultModel.code = -1;
resultModel.msg = "新增失败";
}
return(Ok(resultModel));
}
catch (Exception ex)
{
resultModel.code = -1;
resultModel.msg = "操作失败:" + ex.Message;
return(Ok(resultModel));
}
}
