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