public async Task <bool> Update(WorkBomDto erpBom) { try { using (var conn = DapperFactory.GetConnection(erpBom.ConnectionString)) { var query = " update {0} set MODIFY_FLAG=1 where {1}=:{2}"; query = string.Format(query, erpBom.CurenetTableName, nameof(erpBom.CONTROL_NO), nameof(erpBom.CONTROL_NO)); return(await conn.ExecuteAsync(query, new { erpBom.CONTROL_NO }, commandType : System.Data.CommandType.Text) == 1); } } catch (Exception ex) { throw ex; } }
public async Task <List <INNERASESHJMY_WORKBOM> > Get_WorkBOMNum(WorkBomDto erpBom) { IEnumerable <INNERASESHJMY_WORKBOM> result = new List <INNERASESHJMY_WORKBOM>(); try { using (var conn = DapperFactory.GetConnection(erpBom.ConnectionString)) { var query = "select {0} from {1} where MODIFY_FLAG=0 group by {2}"; query = string.Format(query, nameof(erpBom.CONTROL_NO), erpBom.CurenetTableName, nameof(erpBom.CONTROL_NO)); result = await conn.QueryAsync <INNERASESHJMY_WORKBOM>(query); } } catch (Exception ex) { throw ex; } return(result.ToList()); }
public async Task <IHttpActionResult> UpdateJmyWorkBom(WorkBomDto workBomDto) { try { bool result = await _jmyWorkBomRepository.Update(workBomDto); return(Json(new ReturnResult <List <INNERASESHJMY_WORKBOM> >() { Success = result })); } catch (System.Exception ex) { _logger.Error($"UpdateJmyWorkBom 异常:{ex}"); return(Json(new ReturnResult <object>() { Messge = ex.Message, Success = false })); } }
public async Task <List <INNERASESHJMY_WORKBOM> > Get_WorkBOMList(WorkBomDto erpBom) { IEnumerable <INNERASESHJMY_WORKBOM> result = new List <INNERASESHJMY_WORKBOM>(); try { var dyParam = new OracleDynamicParameters(); using (var conn = DapperFactory.GetConnection(erpBom.ConnectionString)) { var query = "select * from {0} where {1}=:{2}"; query = string.Format(query, erpBom.CurenetTableName, nameof(erpBom.CONTROL_NO), nameof(erpBom.CONTROL_NO)); result = await conn.QueryAsync <INNERASESHJMY_WORKBOM>(query, new { erpBom.CONTROL_NO }); } } catch (Exception ex) { throw ex; } return(result.ToList()); }
public async Task <IHttpActionResult> GetJmyWorkBomByNo(WorkBomDto workBomDto) { try { var result = await _jmyWorkBomRepository.Get_WorkBOMList(workBomDto); _logger.Info($"获取的结果:{JsonConvert.SerializeObject(result)}"); return(Json(new ReturnResult <List <INNERASESHJMY_WORKBOM> >() { Data = result, Success = true })); } catch (System.Exception ex) { _logger.Error($"GetJmyWorkBomByNo 异常:{ex.ToString()}"); return(Json(new ReturnResult <object>() { Messge = ex.Message, Success = false })); } }
public async Task <IHttpActionResult> GetJmyWorkBom(WorkBomDto workBomDto) { try { var result = await _jmyWorkBomRepository.Get_WorkBOMNum(workBomDto); _logger.Info($"获取的结果:{JsonConvert.SerializeObject(result)}"); return(Json(new ReturnResult <object>() { Data = result.Select(x => new { x.CONTROL_NO }).ToList(), Success = true })); } catch (System.Exception ex) { _logger.Error($"GetJmyWorkBom 异常:{ex.ToString()}"); return(Json(new ReturnResult <object>() { Messge = ex.Message, Success = false })); } }