public ActionResult Create(CheckPlanEnity model)
{
var resultModel = new RespResultCountViewModel();
try
{
if (_checkplanService.IsExistUserId(model.UserId))
{
resultModel.code = -1;
resultModel.msg = "该人员已有计划 请勿再次添加！";
return(Ok(resultModel));
}
model.Id = ConstDefine.CreateGuid();
model.CreateTime = DateTime.Now;
model.DeleteMark = 1;
bool result = _checkplanService.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 bool GetQRCodeCreat(string id, string userid, string username)
{
using (var db = _dbContext.GetIntance())
{
try
{
db.Ado.BeginTran();
var entity = db.Queryable <CheckTableEntity>()
.Where(it => it.Id == id)
.First();
var palanEntity = db.Queryable <CheckPlanEnity>().Where(it => it.UserId == userid && it.RiskBH.Contains(entity.RiskPointBH)).First();
CheckResultRecordEntity result = new CheckResultRecordEntity()
{
Id = Guid.NewGuid().ToString(),
CheckPlanName = palanEntity.PlanName,
CheckPlanId = palanEntity.Id,
CheckTableId = entity.Id,
RiskPointBH = entity.RiskPointBH,
RiskPointName = entity.RiskPointName,
CreateTime = DateTime.Now,
UserId = userid,
UserName = username,
States = 0,
OrgId = palanEntity.OrgId,
OrgName = palanEntity.OrgName
};
db.Insertable(result).ExecuteCommand();
var checkPlanEntity = db.Queryable <CheckPlanEnity>().Where(it => it.DeleteMark == 1 && it.UserId == userid).First();
var count1 = db.Queryable <CheckTableEntity>().Where(it => it.DeleteMark == 1 && it.UserId == userid && checkPlanEntity.RiskBH.Contains(it.RiskPointBH)).Count();
var count2 = db.Queryable <CheckResultRecordEntity>().Where(it => it.CreateTime.ToString("yyyy-MM-dd") == DateTime.Now.ToString("yyyy-MM-dd") && it.UserId == userid && checkPlanEntity.RiskBH.Contains(it.RiskPointBH)).Count();
if (count1 == count2)
{
CheckPlanEnity updateEntity = new CheckPlanEnity()
{
LastCompleteTime = DateTime.Today
};
db.Updateable(updateEntity)
.UpdateColumns(it => new { it.LastCompleteTime })
.Where(it => it.Id == checkPlanEntity.Id)
.ExecuteCommand();
PlanLogEntity planLogEntity = new PlanLogEntity()
{
Id = Guid.NewGuid().ToString(),
UserId = userid,
CompleteTime = DateTime.Now,
PlanId = palanEntity.Id
};
db.Insertable(planLogEntity).ExecuteCommand();
}
db.Ado.CommitTran();
}
catch (Exception ex)
{
db.Ado.RollbackTran();
return(false);
}
return(true);
}
}
public bool Insert(CheckPlanEnity entity)
{
using (var db = _dbContext.GetIntance())
{
var count = db.Insertable(entity).ExecuteCommand();
result = count > 0 ? true : false;
}
return(result);
}
public CheckPlanEnity GetPlanList(string userid)
{
var list = new CheckPlanEnity();
using (var db = _dbContext.GetIntance())
{
list = db.Queryable <CheckPlanEnity>()
.Where(it => it.DeleteMark == 1 && it.UserId == userid).First();
}
return(list);
}
/// <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 CheckPlanEnity();
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);
}
