using gdbg.Models;
|
using gdbg.Services;
|
using Microsoft.AspNetCore.Mvc;
|
using Oracle.ManagedDataAccess.Client;
|
using System.Collections.Generic;
|
using System.Text.RegularExpressions;
|
using System.Threading.Tasks;
|
|
namespace gdbg.Controllers
|
{
|
[ApiController]
|
[Route("api/[controller]")]
|
public class PrintController : ControllerBase
|
{
|
private readonly OracleDbService _oracleDbService;
|
|
public PrintController(OracleDbService oracleDbService)
|
{
|
_oracleDbService = oracleDbService;
|
}
|
[HttpGet("printHistory")]
|
public async Task<IActionResult> GetPrintHistory(string orderNo)
|
{
|
try
|
{
|
// 修改 SQL 查询以返回更多字段
|
string query =
|
|
" SELECT a.ITEM_BARCODE, TO_CHAR(a.CREATE_DATE, 'YYYY-MM-DD HH24:MI:SS') AS PRINT_DATE, bgr.bgr, a.quantity " +
|
" FROM MES_INV_ITEM_BARCODES a left join(select case when sta.STAFF_NAME is null then a.CREATE_BY else sta.STAFF_NAME end bgr,a.ITEM_BARCODE " +
|
" from MES_WORK_PROD_C_DETAILS a left join mes_staff sta on a.CREATE_BY = sta.STAFF_NO) bgr on bgr.ITEM_BARCODE = a.ITEM_BARCODE " +
|
" left join MES_STAFF b on a.CREATE_BY = b.STAFF_NO " +
|
"WHERE BILL_NO = :orderNo and TO_CHAR(a.CREATE_DATE, 'YYYY-MM-DD')<=to_char(SYSDATE,'YYYY-MM-DD') and TO_CHAR(a.CREATE_DATE, 'YYYY-MM-DD')>=to_char(SYSDATE-2,'YYYY-MM-DD') " +
|
"order by a.CREATE_DATE desc";
|
|
|
var parameters = new List<OracleParameter>
|
{
|
new OracleParameter("orderNo", orderNo)
|
};
|
|
var historyRecords = await _oracleDbService.GetAsync(query, reader => new
|
{
|
ItemBarcode = reader.GetString(0), // 打印条码
|
PrintDate = reader.GetString(1), // 打印时间 (字符串格式)
|
PrintedBy = reader.IsDBNull(2) ? "" : reader.GetString(2) , // 打印人
|
quantity= reader.GetString(3)
|
}, parameters);
|
|
|
return Ok(new { historyRecords });
|
}
|
catch (Exception ex)
|
{
|
return StatusCode(500, new { message = "An error occurred while fetching print history.", error = ex.Message });
|
}
|
}
|
|
[HttpPost]
|
public async Task<IActionResult> PrintAndUpdate([FromBody] PrintRequest request)
|
{
|
try
|
{
|
// 调用存储过程的 SQL
|
string procedureCall = "BEGIN PrintAndUpdate(:p_orderNo,:p_person, :p_itemId, :p_barcodeValue, :p_quantity); END;";
|
|
// 参数列表
|
var parameters = new List<OracleParameter>
|
{
|
new OracleParameter("p_orderNo", request.OrderNo),
|
new OracleParameter("p_person", request.p_person),
|
// new OracleParameter("p_reportedQuantity", request.ReportedQuantity),
|
new OracleParameter("p_itemId", request.ItemId),
|
new OracleParameter("p_barcodeValue", request.UniqueValue),
|
// new OracleParameter("p_itemCode", request.ItemCode),
|
// new OracleParameter("p_itemName", request.ItemName),
|
// new OracleParameter("p_itemSpec", request.ItemSpec),
|
new OracleParameter("p_quantity", request.Quantity),
|
|
};
|
|
// 调用存储过程
|
await _oracleDbService.ExecuteProcedureAsync(procedureCall, parameters);
|
|
return Ok(new { message = "Print and update successful." });
|
}
|
catch (OracleException ex)
|
{
|
if (ex.Number == -20002)
|
{
|
string cleanMessage = ExtractErrorMessage(ex.Message);
|
return BadRequest(new { message = cleanMessage });
|
}
|
// 其他 Oracle 错误
|
return StatusCode(500, new
|
{
|
// message = "数据库错误：" + ex.Message
|
message = ExtractErrorMessage(ex.Message)
|
});
|
}
|
catch (Exception ex)
|
{
|
return StatusCode(500, new { message = "An error occurred during printing and updating.", error = ex.Message });
|
}
|
|
}
|
|
/* private static string ExtractErrorMessage(string oracleMessage)
|
{
|
// 匹配 "ORA-20002:" 后的具体错误信息
|
string pattern = @"ORA-20002:.*?:\s(.*?)(\n|$)";
|
var match = System.Text.RegularExpressions.Regex.Match(oracleMessage, pattern);
|
|
if (match.Success)
|
{
|
return match.Groups[1].Value.Trim(); // 提取核心中文错误部分
|
}
|
|
// 如果无法匹配，则返回完整错误信息
|
return oracleMessage;
|
}*/
|
/* private static string ExtractErrorMessage(string oracleMessage)
|
{
|
// 匹配多个 ORA-20002: 后的段落，提取最后一个
|
var matches = System.Text.RegularExpressions.Regex.Matches(
|
oracleMessage,
|
@"ORA-20002:(.*?)(?=ORA-\d{5}:|$)"
|
);
|
|
if (matches.Count > 0)
|
{
|
// 提取最后一个匹配项，去除换行和多余空格
|
return matches[matches.Count - 1].Groups[1].Value.Trim();
|
}
|
|
// 默认返回原始错误
|
return oracleMessage;
|
}*/
|
|
|
private static string ExtractErrorMessage(string oracleMessage)
|
{
|
// 匹配所有 ORA-20002: 错误段
|
var matches = Regex.Matches(oracleMessage, @"ORA-20002:\s*(.*?)(?=(ORA-\d{5}:|$))", RegexOptions.Singleline);
|
|
if (matches.Count > 0)
|
{
|
// 返回最里面一条（最后一个）
|
string raw = matches[matches.Count - 1].Groups[1].Value;
|
|
// 去掉类似 "Error in PrintAndUpdate procedure:" 开头
|
string cleaned = Regex.Replace(raw, @"^Error.*?:", "", RegexOptions.IgnoreCase).Trim();
|
|
return string.IsNullOrWhiteSpace(cleaned) ? raw.Trim() : cleaned;
|
}
|
|
return oracleMessage; // fallback
|
}
|
|
|
|
|
}
|
}
|
