/// <summary>
/// 新增
/// </summary>
/// <param name="entity">实体</param>
/// <returns></returns>
public bool Insert(RiskPointEntity 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(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="keyValues">主键List</param>
public bool DeleteBatch(List <string> keyValues)
{
if (keyValues.Count() > 0)
{
using (var db = _dbContext.GetIntance())
{
var entity = new RiskPointEntity();
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 RiskPointEntity();
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(RiskPointEntity model)
{
var resultModel = new RespResultCountViewModel();
try
{
#region 验证
if (string.IsNullOrEmpty(model.OrgId))
{
resultModel.code = -1;
resultModel.msg = "机构Id不能为空！";
return(Ok(resultModel));
}
if (string.IsNullOrEmpty(model.BH))
{
resultModel.code = -1;
resultModel.msg = "编号不能为空！";
return(Ok(resultModel));
}
model.RiskPointBH = model.RiskUnitBH + "-" + model.BH;
if (_riskmanageService.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;
//创建目录
string activeDir = XYDbContext.QRPath;
string newPath = activeDir + "/" + model.OrgName;
if (!Directory.Exists(newPath))//如果不存在就创建 dir 文件夹
{
Directory.CreateDirectory(newPath);
}
#region 生成二维码
RiskPointDto riskPointDto = new RiskPointDto();
riskPointDto.RiskBH = model.RiskPointBH;
riskPointDto.RiskName = model.Name;
riskPointDto.OrgId = model.OrgId;
riskPointDto.OrgName = model.OrgName;
string jsonStr = JsonConvert.SerializeObject(riskPointDto);
var bitmap = _qrcodeService.GetQRCode(jsonStr, 10);
var QRUrl = "/" + Guid.NewGuid().ToString() + ".bmp";
var path = newPath + QRUrl;
#endregion
model.QRCodeUrl = path;
bool result = _riskmanageService.Insert(model);
if (result)
{
bitmap.Save(path, System.Drawing.Imaging.ImageFormat.Bmp);
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(RiskPointEntity model)
{
var resultModel = new RespResultCountViewModel();
try
{
#region 验证
if (string.IsNullOrEmpty(model.OrgId))
{
resultModel.code = -1;
resultModel.msg = "机构Id不能为空！";
return(Ok(resultModel));
}
if (string.IsNullOrEmpty(model.BH))
{
resultModel.code = -1;
resultModel.msg = "编号不能为空！";
return(Ok(resultModel));
}
model.RiskPointBH = model.RiskUnitBH + "-" + model.BH;
if (_riskmanageService.IsExist(model.OrgId, model.RiskPointBH, model.Id))
{
resultModel.code = -1;
resultModel.msg = "请勿重复添加风险点编号！";
return(Ok(resultModel));
}
#endregion
string activeDir = XYDbContext.QRPath;
string newPath = activeDir + "/" + model.OrgName;
#region 生成二维码 先删除原来的二维码
RiskPointDto riskPointDto = new RiskPointDto();
riskPointDto.RiskBH = model.RiskPointBH;
riskPointDto.RiskName = model.Name;
riskPointDto.OrgId = model.OrgId;
riskPointDto.OrgName = model.OrgName;
string jsonStr = JsonConvert.SerializeObject(riskPointDto);
var bitmap = _qrcodeService.GetQRCode(jsonStr, 10);
var QRUrl = "/" + Guid.NewGuid().ToString() + ".bmp";
var path = newPath + QRUrl;
#endregion
model.QRCodeUrl = path;
var delePath = _riskmanageService.GetQRCodeUrl(model.Id); //获取修改前的编号 记录并删除二维码
bool result = _riskmanageService.Update(model);
if (result)
{
if (System.IO.File.Exists(delePath))
{
System.IO.File.Delete(delePath);
}
bitmap.Save(path, System.Drawing.Imaging.ImageFormat.Bmp);
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));
}
}
