/// <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)); } }