public async Task <bool> Update(ErpBomDto erpBom)
{
try
{
using (var conn = DapperFactory.GetConnection(erpBom.ConnectionString))
{
var query = " update {0} set MODIFY_FLAG=1 where {1}=:{1} and {2}=:{2}";
query = string.Format(query, erpBom.CurenetTableName, nameof(erpBom.THROW_DATE), nameof(erpBom.EXG_NO));
return(await conn.ExecuteAsync(query, new { erpBom.THROW_DATE, erpBom.EXG_NO }, commandType : System.Data.CommandType.Text) == 1);
}
}
catch (Exception ex)
{
throw ex;
}
}
public async Task <List <INNERASESHJMY_ERPBOM> > Get_ERPBOMNum(ErpBomDto erpBom)
{
IEnumerable <INNERASESHJMY_ERPBOM> result = new List <INNERASESHJMY_ERPBOM>();
try
{
using (var conn = DapperFactory.GetConnection(erpBom.ConnectionString))
{
var query = "select {0},{1} from {2} where MODIFY_FLAG=0 group by {0},{1}";
query = string.Format(query, nameof(erpBom.THROW_DATE), nameof(erpBom.EXG_NO), erpBom.CurenetTableName);
result = await conn.QueryAsync <INNERASESHJMY_ERPBOM>(query);
}
}
catch (Exception ex)
{
throw ex;
}
return(result.ToList());
}
public async Task <List <INNERASESHJMY_ERPBOM> > Get_ERPBOMList(ErpBomDto erpBom)
{
IEnumerable <INNERASESHJMY_ERPBOM> result = new List <INNERASESHJMY_ERPBOM>();
try
{
var dyParam = new OracleDynamicParameters();
using (var conn = DapperFactory.GetConnection(erpBom.ConnectionString))
{
var query = "select * from {0} where {1}=:{1} AND {2}=:{2}";
query = string.Format(query, erpBom.CurenetTableName, nameof(erpBom.THROW_DATE), nameof(erpBom.EXG_NO));
result = await conn.QueryAsync <INNERASESHJMY_ERPBOM>(query, new { erpBom.THROW_DATE, erpBom.EXG_NO });
}
}
catch (Exception ex)
{
throw ex;
}
return(result.ToList());
}
public async Task <IHttpActionResult> UpdateJmyErpBom(ErpBomDto erpBomDto)
{
try
{
_logger.Info($"UpdateJmyErpBom param:{JsonConvert.SerializeObject(erpBomDto)}");
bool result = await _jmyErpBomRepository.Update(erpBomDto);
return(Json(new ReturnResult <List <INNERASESHJMY_ERPBOM> >()
{
Success = result
}));
}
catch (System.Exception ex)
{
_logger.Error($"UpdateJmyErpBom 异常:{ex}");
return(Json(new ReturnResult <object>()
{
Messge = ex.Message, Success = false
}));
}
}
public async Task <IHttpActionResult> GetJmyErpBomByNo(ErpBomDto erpBomDto)
{
try
{
_logger.Info($"GetJmyErpBomByNo param:{JsonConvert.SerializeObject(erpBomDto)}");
var result = await _jmyErpBomRepository.Get_ERPBOMList(erpBomDto);
_logger.Info($"获取的结果:{JsonConvert.SerializeObject(result)}");
return(Json(new ReturnResult <List <INNERASESHJMY_ERPBOM> >()
{
Data = result, Success = true
}));
}
catch (System.Exception ex)
{
_logger.Error($"GetJmyErpBomByNo 异常:{ex}");
return(Json(new ReturnResult <object>()
{
Messge = ex.Message, Success = false
}));
}
}
public async Task <IHttpActionResult> GetJmyErpBom(ErpBomDto erpBomDto)
{
try
{
_logger.Info($"GetJmyErpBom param:{JsonConvert.SerializeObject(erpBomDto)}");
var result = await _jmyErpBomRepository.Get_ERPBOMNum(erpBomDto);
_logger.Info($"获取的结果:{JsonConvert.SerializeObject(result)}");
return(Json(new ReturnResult <object>()
{
Data = result.Select(x => new { x.THROW_DATE, x.EXG_NO }).ToList(), Success = true
}));
}
catch (System.Exception ex)
{
_logger.Error($"GetJmyErpBom 异常:{ex}");
return(Json(new ReturnResult <object>()
{
Messge = ex.Message, Success = false
}));
}
}
