/// <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 CheckTableEntity(); 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="userRoleEntity">角色用户实体</param> /// <returns></returns> public bool InsertBatch(List <AuthorizedDto> models) { using (var db = _dbContext.GetIntance()) { try { db.Ado.BeginTran(); var entity = new CheckTableEntity(); entity.DeleteMark = 0; for (int i = 0; i < models.Count(); i++) { var riskClassIficationEntity = db.Queryable <RiskClassIficationEntity>().Where(it => it.Id == models[i].classificationid).First(); var jobRiskEntity = db.Queryable <JobRiskEntity>().Where(it => it.Id == models[i].jobriskid).First(); if (riskClassIficationEntity == null) { db.Updateable(entity).UpdateColumns(it => new { it.DeleteMark }).Where(it => it.UserId == jobRiskEntity.UserId).ExecuteCommand(); return(true); //db.Deleteable<CheckTableEntity>().Where(it => it.UserId == jobRiskEntity.UserId).ExecuteCommand(); } else { db.Updateable(entity).UpdateColumns(it => new { it.DeleteMark }).Where(it => it.UserId == jobRiskEntity.UserId && it.RiskPointBH == riskClassIficationEntity.RiskPointBH).ExecuteCommand(); } } for (int i = 0; i < models.Count(); i++) { var riskClassIficationEntity = db.Queryable <RiskClassIficationEntity>().Where(it => it.Id == models[i].classificationid).First(); var jobRiskEntity = db.Queryable <JobRiskEntity>().Where(it => it.Id == models[i].jobriskid).First(); CheckTableEntity checkTableEntitie = new CheckTableEntity() { Id = Guid.NewGuid().ToString(), ClassificationId = models[i].classificationid, CreateTime = DateTime.Now, DeleteMark = 1, JobId = jobRiskEntity.JobId, JobName = jobRiskEntity.JobName, OrgId = jobRiskEntity.OrgId, OrgName = jobRiskEntity.OrgName, RoleId = jobRiskEntity.RoleId, RoleName = jobRiskEntity.RoleName, UserId = jobRiskEntity.UserId, UserName = jobRiskEntity.UserName, RiskFactor = riskClassIficationEntity.RiskFactor, RiskLevel = riskClassIficationEntity.RiskLevel, RiskPointBH = riskClassIficationEntity.RiskPointBH, RiskPointName = riskClassIficationEntity.RiskPointName, TroubleshootingItems = riskClassIficationEntity.TroubleshootingItems, ControlMeasures = riskClassIficationEntity.ControlMeasures, MeasuresType = riskClassIficationEntity.MeasuresType, EmergencyMeasures = riskClassIficationEntity.EmergencyMeasures }; db.Insertable(checkTableEntitie).ExecuteCommand(); } db.Ado.CommitTran(); } catch (Exception ex) { db.Ado.RollbackTran(); throw ex; } return(true); } }