using System.Dynamic;
|
using MES.Service.Dto.service;
|
using MES.Service.Modes;
|
using MES.Service.service.QC;
|
using MES.Service.util;
|
using Microsoft.AspNetCore.Mvc;
|
using Newtonsoft.Json.Linq;
|
|
namespace MESApplication.Controllers.QC;
|
|
[Route("api/[controller]")]
|
[ApiController]
|
public class THJController : ControllerBase
|
{
|
[HttpPost("getPage")]
|
public ResponseResult GetPage([FromBody] THJPageResult queryObj)
|
{
|
try
|
{
|
dynamic resultInfos = new ExpandoObject();
|
var tbBillList = new THJService().getPage(queryObj);
|
resultInfos.tbBillList = tbBillList;
|
return new ResponseResult
|
{
|
status = 0,
|
message = "OK",
|
data = resultInfos
|
};
|
}
|
catch (Exception ex)
|
{
|
return ResponseResult.ResponseError(ex);
|
}
|
}
|
|
[HttpPost("getMaxReleaseNo")]
|
public ResponseResult GetMaxReleaseNo()
|
{
|
try
|
{
|
dynamic resultInfos = new ExpandoObject();
|
var tbBillList = new THJService().getMaxReleaseNo();
|
resultInfos.tbBillList = tbBillList;
|
return new ResponseResult
|
{
|
status = 0,
|
message = "OK",
|
data = resultInfos
|
};
|
}
|
catch (Exception ex)
|
{
|
return ResponseResult.ResponseError(ex);
|
}
|
}
|
|
[HttpPost("getQSItems")]
|
public ResponseResult GetQSItems([FromBody] JObject data)
|
{
|
var pid = data["pid"]?.ToString();
|
var id = data["id"]?.ToString();
|
|
try
|
{
|
dynamic resultInfos = new ExpandoObject();
|
var tbBillList = new THJService();
|
var detail021 = tbBillList.getQSItems(Convert.ToDecimal(pid), Convert.ToDecimal(id));
|
resultInfos.tbBillList = detail021;
|
return new ResponseResult
|
{
|
status = 0,
|
message = "OK",
|
data = resultInfos
|
};
|
}
|
catch (Exception ex)
|
{
|
return ResponseResult.ResponseError(ex);
|
}
|
}
|
|
[HttpPost("saveItem")]
|
public ResponseResult SaveItem([FromBody] THJDto thjDto)
|
{
|
try
|
{
|
dynamic resultInfos = new ExpandoObject();
|
var tbBillList = new THJService().saveItem(thjDto);
|
resultInfos.tbBillList = tbBillList;
|
return new ResponseResult
|
{
|
status = 0,
|
message = "OK",
|
data = resultInfos
|
};
|
}
|
catch (Exception ex)
|
{
|
return ResponseResult.ResponseError(ex);
|
}
|
}
|
|
[HttpPost("submitTHJResult")]
|
public ResponseResult SubmitTHJResult([FromBody] JObject data)
|
{
|
try
|
{
|
var gid = Convert.ToDecimal(data["gid"]?.ToString());
|
var userNo = data["userNo"]?.ToString();
|
|
if (gid <= 0)
|
{
|
return new ResponseResult
|
{
|
status = 1,
|
message = "检验单ID不能为空",
|
data = null
|
};
|
}
|
|
if (string.IsNullOrEmpty(userNo))
|
{
|
return new ResponseResult
|
{
|
status = 1,
|
message = "操作人不能为空",
|
data = null
|
};
|
}
|
|
var result = new THJService().SubmitTHJResult(gid, userNo);
|
|
if (result)
|
{
|
dynamic resultInfos = new ExpandoObject();
|
resultInfos.tbBillList = new { success = true, message = "提交成功" };
|
return new ResponseResult
|
{
|
status = 0,
|
message = "提交成功",
|
data = resultInfos
|
};
|
}
|
else
|
{
|
return new ResponseResult
|
{
|
status = 1,
|
message = "提交失败",
|
data = null
|
};
|
}
|
}
|
catch (Exception ex)
|
{
|
return ResponseResult.ResponseError(ex);
|
}
|
}
|
|
[HttpPost("getReturnwareInfo")]
|
public ResponseResult GetReturnwareInfo([FromBody] JObject data)
|
{
|
try
|
{
|
var returnType = data["returnType"]?.ToString();
|
var returnNo = data["returnNo"]?.ToString();
|
|
if (string.IsNullOrEmpty(returnType) || string.IsNullOrEmpty(returnNo))
|
{
|
return new ResponseResult
|
{
|
status = 1,
|
message = "退货单别和退货单号不能为空",
|
data = null
|
};
|
}
|
|
dynamic resultInfos = new ExpandoObject();
|
var tbBillList = new THJService().getReturnwareInfo(returnType, returnNo);
|
resultInfos.tbBillList = tbBillList;
|
return new ResponseResult
|
{
|
status = 0,
|
message = "OK",
|
data = resultInfos
|
};
|
}
|
catch (Exception ex)
|
{
|
return ResponseResult.ResponseError(ex);
|
}
|
}
|
|
[HttpPost("getReturnDetails")]
|
public ResponseResult GetReturnDetails([FromBody] JObject data)
|
{
|
try
|
{
|
var pid = data["pid"]?.ToString();
|
|
if (string.IsNullOrEmpty(pid))
|
{
|
return new ResponseResult
|
{
|
status = 1,
|
message = "检验单ID不能为空",
|
data = null
|
};
|
}
|
|
dynamic resultInfos = new ExpandoObject();
|
var tbBillList = new THJService().getReturnDetails(pid);
|
resultInfos.tbBillList = tbBillList;
|
return new ResponseResult
|
{
|
status = 0,
|
message = "OK",
|
data = resultInfos
|
};
|
}
|
catch (Exception ex)
|
{
|
return ResponseResult.ResponseError(ex);
|
}
|
}
|
|
[HttpPost("setInspectItem")]
|
public ResponseResult SetInspectItem([FromBody] JObject data)
|
{
|
try
|
{
|
var gid = data["gid"]?.ToString();
|
var updateBy = data["updateBy"]?.ToString() ?? "系统";
|
|
if (string.IsNullOrEmpty(gid))
|
{
|
return new ResponseResult
|
{
|
status = 1,
|
message = "检验单ID不能为空",
|
data = null
|
};
|
}
|
|
dynamic resultInfos = new ExpandoObject();
|
var tbBillList = new THJService().setInspectItem(gid, updateBy);
|
resultInfos.tbBillList = tbBillList;
|
return new ResponseResult
|
{
|
status = 0,
|
message = "OK",
|
data = resultInfos
|
};
|
}
|
catch (Exception ex)
|
{
|
return ResponseResult.ResponseError(ex);
|
}
|
}
|
|
/// <summary>
|
/// 测试接口 - 验证基本功能
|
/// </summary>
|
[HttpPost("testConnection")]
|
public ResponseResult TestConnection()
|
{
|
try
|
{
|
return new ResponseResult
|
{
|
status = 0,
|
message = "连接正常",
|
data = new { timestamp = DateTime.Now }
|
};
|
}
|
catch (Exception ex)
|
{
|
return ResponseResult.ResponseError(ex);
|
}
|
}
|
|
/// <summary>
|
/// 根据ID获取检验项目详情
|
/// </summary>
|
[HttpPost("getThjDetail02ById")]
|
public ResponseResult GetThjDetail02ById([FromBody] JObject data)
|
{
|
try
|
{
|
var id = Convert.ToDecimal(data["id"]);
|
var result = new THJService().getThjDetail02ById(id);
|
|
dynamic resultInfos = new ExpandoObject();
|
resultInfos.tbBillList = result;
|
|
return new ResponseResult
|
{
|
status = 0,
|
message = "OK",
|
data = resultInfos
|
};
|
}
|
catch (Exception ex)
|
{
|
return ResponseResult.ResponseError(ex);
|
}
|
}
|
|
/// <summary>
|
/// 设置检验项目详情
|
/// </summary>
|
[HttpPost("SetQSItemDetail")]
|
public ResponseResult SetQSItemDetail([FromBody] JObject data)
|
{
|
try
|
{
|
var pid = Convert.ToDecimal(data["pid"]);
|
var gid = Convert.ToDecimal(data["gid"]);
|
var fstand = data["fstand"]?.ToString();
|
var fcheckResu = data["fcheckResu"]?.ToString();
|
var updateBy = data["updateBy"]?.ToString();
|
var count = Convert.ToInt32(data["count"]);
|
|
var result = new THJService().SetQSItemDetail(pid, gid, fstand, fcheckResu, updateBy, count);
|
|
dynamic resultInfos = new ExpandoObject();
|
resultInfos.tbBillList = result;
|
|
return new ResponseResult
|
{
|
status = 0,
|
message = "OK",
|
data = resultInfos
|
};
|
}
|
catch (Exception ex)
|
{
|
return ResponseResult.ResponseError(ex);
|
}
|
}
|
|
/// <summary>
|
/// 更新检验项目详情
|
/// </summary>
|
[HttpPost("UpdateQSItemDetail")]
|
public ResponseResult UpdateQSItemDetail([FromBody] JObject data)
|
{
|
try
|
{
|
// 安全地转换decimal参数，处理NULL值
|
if (!decimal.TryParse(data["id"]?.ToString(), out decimal id))
|
{
|
return new ResponseResult
|
{
|
status = 1,
|
message = "检验结果ID不能为空或格式不正确",
|
data = null
|
};
|
}
|
|
if (!decimal.TryParse(data["pid"]?.ToString(), out decimal pid))
|
{
|
return new ResponseResult
|
{
|
status = 1,
|
message = "检验项目ID不能为空或格式不正确",
|
data = null
|
};
|
}
|
|
if (!decimal.TryParse(data["gid"]?.ToString(), out decimal gid))
|
{
|
return new ResponseResult
|
{
|
status = 1,
|
message = "检验单ID不能为空或格式不正确",
|
data = null
|
};
|
}
|
|
var fstand = data["fstand"]?.ToString();
|
var fcheckResu = data["fcheckResu"]?.ToString();
|
var updateBy = data["updateBy"]?.ToString();
|
|
var result = new THJService().UpdateQSItemDetail(id, pid, gid, fstand, fcheckResu, updateBy);
|
|
dynamic resultInfos = new ExpandoObject();
|
resultInfos.tbBillList = result;
|
|
return new ResponseResult
|
{
|
status = 0,
|
message = "OK",
|
data = resultInfos
|
};
|
}
|
catch (Exception ex)
|
{
|
return ResponseResult.ResponseError(ex);
|
}
|
}
|
|
/// <summary>
|
/// 保存检验项目备注
|
/// </summary>
|
[HttpPost("saveRemarksPid")]
|
public ResponseResult SaveRemarksPid([FromBody] JObject data)
|
{
|
try
|
{
|
var pid = Convert.ToDecimal(data["pid"]);
|
var remarks = data["remarks"]?.ToString();
|
|
var result = new THJService().saveRemarksPid(pid, remarks);
|
|
dynamic resultInfos = new ExpandoObject();
|
resultInfos.tbBillList = result;
|
|
return new ResponseResult
|
{
|
status = 0,
|
message = "OK",
|
data = resultInfos
|
};
|
}
|
catch (Exception ex)
|
{
|
return ResponseResult.ResponseError(ex);
|
}
|
}
|
|
/// <summary>
|
/// 获取退货单列表
|
/// </summary>
|
[HttpPost("getReturnOrders")]
|
public ResponseResult GetReturnOrders()
|
{
|
try
|
{
|
var result = new THJService().getReturnOrders();
|
|
dynamic resultInfos = new ExpandoObject();
|
resultInfos.tbBillList = result;
|
|
return new ResponseResult
|
{
|
status = 0,
|
message = "OK",
|
data = resultInfos
|
};
|
}
|
catch (Exception ex)
|
{
|
return ResponseResult.ResponseError(ex);
|
}
|
}
|
|
/// <summary>
|
/// 保存退货明细
|
/// </summary>
|
[HttpPost("SaveReturnDetails")]
|
public ResponseResult SaveReturnDetails([FromBody] JObject data)
|
{
|
try
|
{
|
var returnDetails = data["returnDetails"]?.ToString();
|
var result = new THJService().SaveReturnDetails(returnDetails);
|
|
dynamic resultInfos = new ExpandoObject();
|
resultInfos.tbBillList = result;
|
|
return new ResponseResult
|
{
|
status = 0,
|
message = "OK",
|
data = resultInfos
|
};
|
}
|
catch (Exception ex)
|
{
|
return ResponseResult.ResponseError(ex);
|
}
|
}
|
|
/// <summary>
|
/// 保存检验项目
|
/// </summary>
|
[HttpPost("saveInspectItem")]
|
public ResponseResult SaveInspectItem([FromBody] JObject data)
|
{
|
try
|
{
|
var gid = data["gid"]?.ToString();
|
var items = data["items"]?.ToString();
|
var userNo = data["userNo"]?.ToString();
|
|
var result = new THJService().saveInspectItem(gid, items, userNo);
|
|
dynamic resultInfos = new ExpandoObject();
|
resultInfos.tbBillList = result;
|
|
return new ResponseResult
|
{
|
status = 0,
|
message = "OK",
|
data = resultInfos
|
};
|
}
|
catch (Exception ex)
|
{
|
return ResponseResult.ResponseError(ex);
|
}
|
}
|
|
/// <summary>
|
/// 保存检验单备注（不合格描述）
|
/// </summary>
|
[HttpPost("saveRemarksGid")]
|
public ResponseResult SaveRemarksGid([FromBody] JObject data)
|
{
|
try
|
{
|
var gid = Convert.ToDecimal(data["gid"]?.ToString());
|
var remarks = data["remarks"]?.ToString();
|
|
var result = new THJService().saveRemarksGid(gid, remarks);
|
|
dynamic resultInfos = new ExpandoObject();
|
resultInfos.tbBillList = result;
|
|
return new ResponseResult
|
{
|
status = 0,
|
message = "OK",
|
data = resultInfos
|
};
|
}
|
catch (Exception ex)
|
{
|
return ResponseResult.ResponseError(ex);
|
}
|
}
|
|
/// <summary>
|
/// 通过存储过程提交检验结果
|
/// </summary>
|
[HttpPost("submitTHJResultByProcedure")]
|
public ResponseResult SubmitTHJResultByProcedure([FromBody] JObject data)
|
{
|
try
|
{
|
var releaseNo = data["releaseNo"]?.ToString();
|
var userNo = data["userNo"]?.ToString();
|
|
if (string.IsNullOrEmpty(releaseNo))
|
{
|
return new ResponseResult
|
{
|
status = 1,
|
message = "检验单号不能为空",
|
data = null
|
};
|
}
|
|
if (string.IsNullOrEmpty(userNo))
|
{
|
return new ResponseResult
|
{
|
status = 1,
|
message = "操作人不能为空",
|
data = null
|
};
|
}
|
|
var result = new THJService().SubmitTHJResultByProcedure(releaseNo, userNo);
|
|
if (result.success)
|
{
|
dynamic resultInfos = new ExpandoObject();
|
resultInfos.tbBillList = new { success = true, message = result.message };
|
return new ResponseResult
|
{
|
status = 0,
|
message = result.message,
|
data = resultInfos
|
};
|
}
|
else
|
{
|
return new ResponseResult
|
{
|
status = 1,
|
message = result.message,
|
data = null
|
};
|
}
|
}
|
catch (Exception ex)
|
{
|
return ResponseResult.ResponseError(ex);
|
}
|
}
|
|
}
|
