/// <summary>
/// 新增
/// </summary>
/// <param name="entity">实体</param>
/// <returns></returns>
public bool Insert(JobRiskEntity entity)
{
using (var db = _dbContext.GetIntance())
{
var count = db.Insertable(entity).ExecuteCommand();
result = count > 0 ? true : false;
}
return(result);
}
public ActionResult Edit(JobRiskEntity model)
{
var resultModel = new RespResultCountViewModel();
try
{
#region 验证
if (string.IsNullOrEmpty(model.Id))
{
resultModel.code = -1;
resultModel.msg = "主键不能为空！";
return(Ok(resultModel));
}
if (string.IsNullOrEmpty(model.OrgId) || string.IsNullOrEmpty(model.DepId) || string.IsNullOrEmpty(model.RoleId))
{
resultModel.code = -1;
resultModel.msg = "存在必填项！";
return(Ok(resultModel));
}
if (string.IsNullOrEmpty(model.RiskPointBH) || string.IsNullOrEmpty(model.UserId))
{
resultModel.code = -1;
resultModel.msg = "存在必填项！";
return(Ok(resultModel));
}
if (_jobriskService.IsExist(model.UserId, model.RiskPointBH, model.Id))
{
resultModel.code = -1;
resultModel.msg = "请勿为同一个分配相同的风险点！";
return(Ok(resultModel));
}
#endregion
bool result = _jobriskService.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 Update(JobRiskEntity 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);
}
public ActionResult Create(JobRiskEntity model)
{
var resultModel = new RespResultCountViewModel();
try
{
#region 验证
if (string.IsNullOrEmpty(model.OrgId) || string.IsNullOrEmpty(model.DepId) || string.IsNullOrEmpty(model.RoleId))
{
resultModel.code = -1;
resultModel.msg = "存在必填项！";
return(Ok(resultModel));
}
if (string.IsNullOrEmpty(model.RiskPointBH) || string.IsNullOrEmpty(model.UserId))
{
resultModel.code = -1;
resultModel.msg = "存在必填项！";
return(Ok(resultModel));
}
if (_jobriskService.IsExist(model.UserId, model.RiskPointBH, model.Id))
{
resultModel.code = -1;
resultModel.msg = "请勿为同一个分配相同的风险点！";
return(Ok(resultModel));
}
#endregion
model.Id = ConstDefine.CreateGuid();
model.CreateTime = DateTime.Now;
model.DeleteMark = 1;
bool result = _jobriskService.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));
}
}
/// <summary>
/// 批量删除
/// </summary>
/// <param name="keyValues">主键List</param>
public bool DeleteBatch(List <string> keyValues)
{
if (keyValues.Count() > 0)
{
using (var db = _dbContext.GetIntance())
{
var entity = new JobRiskEntity();
entity.DeleteMark = 0;
//逻辑删除
var counts = db.Updateable(entity).UpdateColumns(it => new { it.DeleteMark })
.Where(it => keyValues.Contains(it.Id)).ExecuteCommand();
result = counts > 0 ? result = true : false;
}
}
else
{
result = false;
}
return(result);
}
/// <summary>
/// 删除
/// </summary>
/// <param name="keyValue">主键</param>
public bool Delete(string keyValue)
{
if (!string.IsNullOrEmpty(keyValue))
{
using (var db = _dbContext.GetIntance())
{
var entity = new JobRiskEntity();
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);
}
