/// <summary>
/// 新增
/// </summary>
/// <param name="entity">实体</param>
/// <returns></returns>
public bool Insert(RiskUnitEntity 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(RiskUnitEntity 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);
}
public ActionResult Create(RiskUnitEntity model)
{
var resultModel = new RespResultCountViewModel();
try
{
#region 验证
if (string.IsNullOrEmpty(model.OrgId))
{
resultModel.code = -1;
resultModel.msg = "存在必填项！";
return(Ok(resultModel));
}
model.UnitBH = model.UnitOneCode + "/" + model.UnitTwoCode + "/" + model.UnitThreeCode;
model.UnitName = model.UnitOneName + "/" + model.UnitTwoName + "/" + model.UnitThreeName;
if (_riskunitmanageService.IsExist(model.OrgId, model.UnitBH, model.Id))
{
resultModel.code = -1;
resultModel.msg = "请勿重复添加风险单元编号！";
return(Ok(resultModel));
}
#endregion
model.Id = ConstDefine.CreateGuid();
model.CreateTime = DateTime.Now;
model.DeleteMark = 1;
bool result = _riskunitmanageService.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));
}
}
public ActionResult Edit(RiskUnitEntity model)
{
var resultModel = new RespResultCountViewModel();
try
{
model.UnitBH = model.UnitOneCode + "/" + model.UnitTwoCode + "/" + model.UnitThreeCode;
model.UnitName = model.UnitOneName + "/" + model.UnitTwoName + "/" + model.UnitThreeName;
#region 验证
if (string.IsNullOrEmpty(model.OrgId) || string.IsNullOrEmpty(model.UnitBH))
{
resultModel.code = -1;
resultModel.msg = "存在必填项！";
return(Ok(resultModel));
}
if (_riskunitmanageService.IsExist(model.OrgId, model.UnitBH, model.Id))
{
resultModel.code = -1;
resultModel.msg = "风险单元编号已存在！";
return(Ok(resultModel));
}
#endregion
bool result = _riskunitmanageService.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="keyValues">主键List</param>
public bool DeleteBatch(List <string> keyValues)
{
if (keyValues.Count() > 0)
{
using (var db = _dbContext.GetIntance())
{
var entity = new RiskUnitEntity();
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 RiskUnitEntity();
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);
}