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;
|
|
/// <summary>
|
/// 超期检验控制器
|
/// </summary>
|
[Route("api/[controller]")]
|
[ApiController]
|
public class CqjController : ControllerBase
|
{
|
/// <summary>
|
/// 获取超期检验列表（分页）
|
/// </summary>
|
/// <param name="queryObj">查询参数</param>
|
/// <returns>分页数据</returns>
|
[HttpPost("getPage")]
|
public ResponseResult getPage([FromBody] XJPageResult queryObj)
|
{
|
try
|
{
|
dynamic resultInfos = new ExpandoObject();
|
var (item, totalCount) = new CqjService().GetPage(queryObj);
|
resultInfos.tbBillList = item;
|
return new ResponseResult
|
{
|
status = 0,
|
message = "OK",
|
data = resultInfos,
|
TotalCount = totalCount
|
};
|
}
|
catch (Exception ex)
|
{
|
return ResponseResult.ResponseError(ex);
|
}
|
}
|
|
/// <summary>
|
/// 调用存储过程，获取检验项目
|
/// </summary>
|
/// <param name="data">包含itemNo、quantity、releaseNo</param>
|
/// <returns>执行结果</returns>
|
[HttpPost("setJYItem")]
|
public ResponseResult setJYItem([FromBody] JObject data)
|
{
|
var itemNo = Convert.ToDecimal(data["itemNo"].ToString());
|
var quantity = Convert.ToDecimal(data["quantity"].ToString());
|
var releaseNo = data["releaseNo"].ToString();
|
try
|
{
|
dynamic resultInfos = new ExpandoObject();
|
var result = new CqjService().SetItems(itemNo, quantity, releaseNo);
|
resultInfos.tbBillList = result;
|
|
// 根据存储过程返回结果判断是否成功
|
var resultCode = result[0];
|
var resultMessage = result[1];
|
|
if (resultCode == "0")
|
{
|
return new ResponseResult
|
{
|
status = 0,
|
message = resultMessage,
|
data = resultInfos
|
};
|
}
|
else
|
{
|
return new ResponseResult
|
{
|
status = 1,
|
message = resultMessage,
|
data = resultInfos
|
};
|
}
|
}
|
catch (Exception ex)
|
{
|
return ResponseResult.ResponseError(ex);
|
}
|
}
|
|
/// <summary>
|
/// 获取检验项目列表
|
/// </summary>
|
/// <param name="data">包含releaseNo、id</param>
|
/// <returns>检验项目列表</returns>
|
[HttpPost("getJYItem")]
|
public ResponseResult getJYItem([FromBody] JObject data)
|
{
|
var id = data["id"]?.ToString();
|
var releaseNo = data["releaseNo"]?.ToString();
|
try
|
{
|
dynamic resultInfos = new ExpandoObject();
|
var tbBillList = new CqjService().GetItems(releaseNo,
|
string.IsNullOrEmpty(id) ? null : Convert.ToDecimal(id));
|
resultInfos.tbBillList = tbBillList;
|
return new ResponseResult
|
{
|
status = 0,
|
message = "OK",
|
data = resultInfos
|
};
|
}
|
catch (Exception ex)
|
{
|
return ResponseResult.ResponseError(ex);
|
}
|
}
|
|
/// <summary>
|
/// 删除超期检验单
|
/// </summary>
|
/// <param name="data">包含releaseNo</param>
|
/// <returns>执行结果</returns>
|
[HttpPost("removeCqj")]
|
public ResponseResult removeCqj([FromBody] JObject data)
|
{
|
var releaseNo = data["releaseNo"]?.ToString();
|
try
|
{
|
dynamic resultInfos = new ExpandoObject();
|
var tbBillList = new CqjService().RemoveCqj(releaseNo);
|
resultInfos.tbBillList = tbBillList;
|
return new ResponseResult
|
{
|
status = 0,
|
message = "OK",
|
data = resultInfos
|
};
|
}
|
catch (Exception ex)
|
{
|
return ResponseResult.ResponseError(ex);
|
}
|
}
|
|
/// <summary>
|
/// 保存不良描述到主表
|
/// </summary>
|
/// <param name="data">包含gid、releaseNo、fngDesc</param>
|
/// <returns>执行结果</returns>
|
[HttpPost("saveRemarksGid")]
|
public ResponseResult saveRemarksGid([FromBody] JObject data)
|
{
|
var gid = Convert.ToDecimal(data["gid"].ToString());
|
var releaseNo = data["releaseNo"]?.ToString();
|
var fngDesc = data["fngDesc"]?.ToString();
|
try
|
{
|
dynamic resultInfos = new ExpandoObject();
|
var tbBillList = new CqjService().SaveRemarksGid(gid, releaseNo, fngDesc);
|
resultInfos.tbBillList = tbBillList;
|
return new ResponseResult
|
{
|
status = 0,
|
message = "OK",
|
data = resultInfos
|
};
|
}
|
catch (Exception ex)
|
{
|
return ResponseResult.ResponseError(ex);
|
}
|
}
|
|
/// <summary>
|
/// 保存备注到主表
|
/// </summary>
|
/// <param name="data">包含gid、releaseNo、lotNo1</param>
|
/// <returns>执行结果</returns>
|
[HttpPost("saveLotNo1")]
|
public ResponseResult saveLotNo1([FromBody] JObject data)
|
{
|
var gid = Convert.ToDecimal(data["gid"].ToString());
|
var releaseNo = data["releaseNo"]?.ToString();
|
var lotNo1 = data["lotNo1"]?.ToString();
|
try
|
{
|
dynamic resultInfos = new ExpandoObject();
|
var tbBillList = new CqjService().SaveLotNo1(gid, releaseNo, lotNo1);
|
resultInfos.tbBillList = tbBillList;
|
return new ResponseResult
|
{
|
status = 0,
|
message = "OK",
|
data = resultInfos
|
};
|
}
|
catch (Exception ex)
|
{
|
return ResponseResult.ResponseError(ex);
|
}
|
}
|
|
/// <summary>
|
/// 保存不良描述到子表
|
/// </summary>
|
/// <param name="data">包含pid、funit</param>
|
/// <returns>执行结果</returns>
|
[HttpPost("saveRemarksPid")]
|
public ResponseResult saveRemarksPid([FromBody] JObject data)
|
{
|
var pid = Convert.ToDecimal(data["pid"].ToString());
|
var funit = data["funit"]?.ToString();
|
try
|
{
|
dynamic resultInfos = new ExpandoObject();
|
var tbBillList = new CqjService().SaveRemarksPid(pid, funit);
|
resultInfos.tbBillList = tbBillList;
|
return new ResponseResult
|
{
|
status = 0,
|
message = "OK",
|
data = resultInfos
|
};
|
}
|
catch (Exception ex)
|
{
|
return ResponseResult.ResponseError(ex);
|
}
|
}
|
|
/// <summary>
|
/// 保存备注到子表
|
/// </summary>
|
/// <param name="data">包含pid、meom</param>
|
/// <returns>执行结果</returns>
|
[HttpPost("saveMeom")]
|
public ResponseResult saveMeom([FromBody] JObject data)
|
{
|
var pid = Convert.ToDecimal(data["pid"].ToString());
|
var meom = data["meom"]?.ToString();
|
try
|
{
|
dynamic resultInfos = new ExpandoObject();
|
var tbBillList = new CqjService().SaveMeom(pid, meom);
|
resultInfos.tbBillList = tbBillList;
|
return new ResponseResult
|
{
|
status = 0,
|
message = "OK",
|
data = resultInfos
|
};
|
}
|
catch (Exception ex)
|
{
|
return ResponseResult.ResponseError(ex);
|
}
|
}
|
|
/// <summary>
|
/// 新增/查询检验详情记录
|
/// </summary>
|
/// <param name="data">包含mainId、releaseNo、fstand、fcheckResu、LastupdateBy、count（新增时）或id、releaseNo（查询时）</param>
|
/// <returns>执行结果</returns>
|
[HttpPost("SetQSItemDetail")]
|
public ResponseResult SetQSItemDetail([FromBody] JObject data)
|
{
|
try
|
{
|
dynamic resultInfos = new ExpandoObject();
|
|
// 判断是新增还是查询
|
if (data.ContainsKey("fcheckResu") && data["fcheckResu"] != null)
|
{
|
// 新增操作 - 按照LLJ模式，使用对象接收参数
|
var detail = new MesCqItemsDetectDetail12
|
{
|
MainId = Convert.ToDecimal(data["mainId"].ToString()),
|
ReleaseNo = data["releaseNo"]?.ToString(),
|
Fstand = data["fstand"]?.ToString(),
|
FcheckResu = data["fcheckResu"]?.ToString(),
|
LastupdateBy = data["LastupdateBy"]?.ToString(), // 使用LastupdateBy而不createBy
|
count = data.ContainsKey("count") && data["count"] != null
|
? Convert.ToInt32(data["count"].ToString())
|
: 1 // 默认为1
|
};
|
|
var tbBillList = new CqjService().SetQSItemDetail(detail);
|
resultInfos.tbBillList = tbBillList;
|
}
|
else
|
{
|
// 查询操作
|
var id = Convert.ToDecimal(data["id"].ToString());
|
var releaseNo = data["releaseNo"]?.ToString();
|
|
var tbBillList = new CqjService().GetQSItemDetail(id, releaseNo);
|
resultInfos.tbBillList = tbBillList;
|
}
|
|
return new ResponseResult
|
{
|
status = 0,
|
message = "OK",
|
data = resultInfos
|
};
|
}
|
catch (Exception ex)
|
{
|
return ResponseResult.ResponseError(ex);
|
}
|
}
|
|
/// <summary>
|
/// 更新检验详情记录
|
/// </summary>
|
/// <param name="data">包含id、mainId、releaseNo、fstand、fcheckResu、updateBy</param>
|
/// <returns>执行结果</returns>
|
[HttpPost("UpdateQSItemDetail")]
|
public ResponseResult UpdateQSItemDetail([FromBody] JObject data)
|
{
|
var id = Convert.ToDecimal(data["id"].ToString());
|
var mainId = Convert.ToDecimal(data["mainId"].ToString());
|
var releaseNo = data["releaseNo"]?.ToString();
|
var fstand = data["fstand"]?.ToString();
|
var fcheckResu = data["fcheckResu"]?.ToString();
|
var updateBy = data["updateBy"]?.ToString();
|
try
|
{
|
dynamic resultInfos = new ExpandoObject();
|
var tbBillList = new CqjService().UpdateQSItemDetail(id, mainId, releaseNo, fstand, fcheckResu, updateBy);
|
resultInfos.tbBillList = tbBillList;
|
return new ResponseResult
|
{
|
status = 0,
|
message = "OK",
|
data = resultInfos
|
};
|
}
|
catch (Exception ex)
|
{
|
return ResponseResult.ResponseError(ex);
|
}
|
}
|
|
/// <summary>
|
/// 检验提交
|
/// </summary>
|
/// <param name="data">包含userNo、releaseNo</param>
|
/// <returns>执行结果</returns>
|
[HttpPost("submitInspection")]
|
public ResponseResult submitInspection([FromBody] JObject data)
|
{
|
var userNo = data["userNo"]?.ToString();
|
var releaseNo = data["releaseNo"]?.ToString();
|
try
|
{
|
dynamic resultInfos = new ExpandoObject();
|
var result = new CqjService().SubmitInspection(userNo, releaseNo);
|
resultInfos.tbBillList = result;
|
|
// 根据存储过程返回结果判断是否成功
|
var resultCode = result[0];
|
var resultMessage = result[1];
|
|
if (resultCode == "0")
|
{
|
return new ResponseResult
|
{
|
status = 0,
|
message = resultMessage,
|
data = resultInfos
|
};
|
}
|
else
|
{
|
return new ResponseResult
|
{
|
status = 1,
|
message = resultMessage,
|
data = resultInfos
|
};
|
}
|
}
|
catch (Exception ex)
|
{
|
return ResponseResult.ResponseError(ex);
|
}
|
}
|
|
/// <summary>
|
/// 处理OPTIONS请求（用于跨域预检）
|
/// </summary>
|
[HttpOptions("{**any}")]
|
public IActionResult HandleOptions()
|
{
|
return Ok();
|
}
|
}
|
