public IActionResult GetPlanDetail(string id = null) { if (string.IsNullOrEmpty(id)) { return(toResponse(StatusCodeType.Error, "id不允许为空!")); } using (SqlSugarClient db = Core.DbContext.CurrentDB) { Biz_Contract_PlanAuditor plan = db.Queryable <Biz_Contract_PlanAuditor>().First(m => m.ID == id); if (plan == null) { return(toResponse(StatusCodeType.Error, "查询不到相关项目信息,请核对!")); } //已编制的任务信息 AuditorDrawUpdateDto plandata = Api.Common.Helpers.ComHelper.Mapper <AuditorDrawUpdateDto, Biz_Contract_PlanAuditor>(plan); //审核员项目列表 plandata.ContractsubitemList = db.Queryable <Biz_Contract_PlanAuditor_Item>().Where(m => m.PlanAuditorID == plandata.ID).ToList(); //编制计划列表信息 plandata.PlanAuditorDrawList = db.Queryable <Biz_Contract_PlanAuditor_Draw>().Where(m => m.PlanAuditorID == plandata.ID).ToList(); //附件信息 plandata.ContractsubitemFileList = db.Queryable <Biz_ContractItem_Sub_File>().Where(m => m.PlanAuditorID == plandata.ID).ToList(); return(toResponse(plandata)); } }
public IActionResult RegisterPlan([FromBody] AuditorDrawUpdateDto parm) { var userinfo = _tokenManager.GetSessionInfo(); using (SqlSugarClient db = Core.DbContext.CurrentDB) { Core.DbContext.BeginTran(); try { List <SugarParameter> parameters = new List <SugarParameter>(); parameters.Add(new SugarParameter("UserID", userinfo.UserID)); parameters.Add(new SugarParameter("UserName", userinfo.UserName)); //if (db.Ado.GetScalar("select 1 from Biz_Contract_PlanAuditor_Item where status > 40000 and PlanAuditorItemID = @id", new { id = parm.ID }) != null) //{ // throw new Exception("当前计划已经提交编制,请核对!"); //} //修改计划任务信息 List <Biz_Contract_PlanAuditor_Draw> PlanDrawList_update = parm.PlanAuditorDrawList_update; //更新 List <Biz_Contract_PlanAuditor_Draw> PlanDrawList_insert = parm.PlanAuditorDrawList_insert; //插入 List <Biz_Contract_PlanAuditor_Draw> PlanDrawList_delete = parm.PlanAuditorDrawList_delete; //删除 //删除计划任务 string[] drawids = PlanDrawList_delete.Where(x => !string.IsNullOrEmpty(x.ID)).Select(x => x.ID).ToArray(); db.Deleteable <Biz_Contract_PlanAuditor_Draw>().Where(m => drawids.Contains(m.ID)).ExecuteCommand(); if (PlanDrawList_update != null) //更新数据 { foreach (var draw in PlanDrawList_update) { db.Updateable <Biz_Contract_PlanAuditor_Draw>().SetColumns(m => new Biz_Contract_PlanAuditor_Draw() { DrawStartTime = draw.DrawStartTime, DrawEndTime = draw.DrawEndTime, Department = draw.Department, DrawContent = draw.DrawContent, DrawClause = draw.DrawClause, }).Where(m => m.ID == draw.ID).ExecuteCommand(); } } if (PlanDrawList_insert != null) { foreach (var draw in PlanDrawList_insert) { var ret = draw.ToCreate <Biz_Contract_PlanAuditor_Draw>(userinfo); db.Insertable <Biz_Contract_PlanAuditor_Draw>(ret).ExecuteCommand(); } } Core.DbContext.CommitTran(); return(toResponse(parm.ID)); } catch (Exception ex) { Core.DbContext.RollbackTran(); return(toResponse(StatusCodeType.Error, ex.Message)); } } }
public IActionResult SaveProblem([FromBody] AuditorDrawUpdateDto parm) { var userinfo = _tokenManager.GetSessionInfo(); using (SqlSugarClient db = Core.DbContext.CurrentDB) { Core.DbContext.BeginTran(); try { List <SugarParameter> parameters = new List <SugarParameter>(); parameters.Add(new SugarParameter("UserID", userinfo.UserID)); parameters.Add(new SugarParameter("UserName", userinfo.UserName)); //修改评定问题信息 List <Biz_Contract_Plan_EvaluationProblem> ProblemList = parm.EvaluationProblemList; //更新 if (ProblemList != null) //更新数据 { foreach (var problem in ProblemList) { db.Updateable <Biz_Contract_Plan_EvaluationProblem>().SetColumns(m => new Biz_Contract_Plan_EvaluationProblem() { ProblemRespond = problem.ProblemRespond, UpdateTime = DateTime.Now }).Where(m => m.ID == problem.ID).ExecuteCommand(); } } Core.DbContext.CommitTran(); return(toResponse(parm.ID)); } catch (Exception ex) { Core.DbContext.RollbackTran(); return(toResponse(StatusCodeType.Error, ex.Message)); } } }