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