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