public ActionResult UnitBuildingQualify(ExpertUnitQualifySaveModel model) { ControllerResult result = ControllerResult.SuccResult; try { string erroMsg = string.Empty; result.IsSucc = true; t_D_userTableSH saveModel = new t_D_userTableSH() { unitName = model.unitName, frdb = model.frdb, yyjczz = model.yyjczz, onesjz = model.onesjz, onedbqk = model.onedbqk, twosjz = model.twosjz, twodbqk = model.twodbqk, twodjjcsjz = model.twodjjcsjz, twodjjcdbqk = model.twodjjcdbqk, twodztjgsjz = model.twodztjgsjz, twoztjgdbqk = model.twoztjgdbqk, twojzmqsjz = model.twojzmqsjz, twojzmqdbqk = model.twojzmqdbqk, twogjgsjz = model.twogjgsjz, twogjgdbqk = model.twogjgdbqk, twojzqysjz = model.twojzqysjz, twojzqydbqk = model.twojzqydbqk, threesjz = model.threesjz, threedbqk = model.threedbqk, foursjz = model.foursjz, fourdbqk = model.fourdbqk, shyj = model.shyj, username = model.username, createtime = model.createtime, addtime = DateTime.Now, pid = model.pid }; if (!checkQualifyService.SaveExpertUnitQualify(saveModel, GetCurrentUserId(), out erroMsg)) { result = ControllerResult.FailResult; result.ErroMsg = erroMsg; result.IsSucc = false; } else { LogUserAction("对单位:{0} 进行了[建设工程质量检测机构资质]审批操作".Fmt(model.unitName)); } } catch (Exception ex) { result = ControllerResult.FailResult; result.ErroMsg = ex.Message; result.IsSucc = true; } return(Content(result.ToJson())); }
/// <summary> /// 专家 建设工程质量检测机构审核表 /// </summary> /// <param name="saveModel"></param> /// <param name="userid"></param> /// <param name="errorMsg"></param> /// <returns></returns> public bool SaveExpertUnitQualify(t_D_userTableSH saveModel, int userid, out string errorMsg) { using (var db = dbFactory.Open()) { using (var dbTrans = db.OpenTransaction()) { try { errorMsg = string.Empty; //保存 t_D_userTableSH 建设工程质量检测机构审核表 记录 var id = db.Insert(saveModel, true); //更新状态 db.UpdateOnly(new t_D_UserExpertUnit { status = 1, qualifystatus = 1, qualifychecktime = DateTime.Now, shid = id }, r => new { r.status, r.qualifystatus, r.qualifychecktime, r.shid }, r => r.pid == saveModel.pid && r.userid == userid); //先提交 dbTrans.Commit(); //再查询判断所有专家的审批是否已经完成 int index = 0; int ApprovaledCnt = 0; var ueus = repExp.GetByCondition(r => r.pid == saveModel.pid); foreach (var ueu in ueus) { index++; if (ueu.needUnitBuildingQualify == 1 && ueu.needSpecialQualify == 1) { if (ueu.qualifystatus == 1 && ueu.speicalstatus == 1) { ApprovaledCnt += 1; } } else if (ueu.needUnitBuildingQualify == 1 && ueu.needSpecialQualify == 0) { if (ueu.qualifystatus == 1) { ApprovaledCnt += 1; } } else if (ueu.needUnitBuildingQualify == 0 && ueu.needSpecialQualify == 1) { if (ueu.speicalstatus == 1) { ApprovaledCnt += 1; } } } //审批都已经经完成 if (index == ApprovaledCnt) { db.UpdateOnly(new t_D_UserTableTen { @static = 3 }, r => new { r.@static }, r => r.pid == saveModel.pid); } return(true); } catch (Exception ex) { dbTrans.Rollback(); errorMsg = ex.Message; return(false); } } } }