using MES.Service.DB;
|
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;
|
using Newtonsoft.Json.Linq;
|
using System.Collections.Generic;
|
using System.Data;
|
using System.Dynamic;
|
|
namespace MESApplication.Controllers.QC;
|
|
[Route("api/[controller]")]
|
[ApiController]
|
public class SJController : ControllerBase
|
{
|
[HttpPost("GetMaxBillNo")]
|
public ResponseResult GetMaxBillNo()
|
{
|
try
|
{
|
dynamic resultInfos = new ExpandoObject();
|
var tbBillList =
|
new SJService().getMaxBillNo();
|
resultInfos.tbBillList = tbBillList;
|
return new ResponseResult
|
{
|
status = 0,
|
message = "OK",
|
data = resultInfos
|
};
|
}
|
catch (Exception ex)
|
{
|
return ResponseResult.ResponseError(ex);
|
}
|
}
|
|
|
[HttpPost("GetPage")]
|
public ResponseResult GetPage([FromBody] SJPageResult queryObj)
|
{
|
try
|
{
|
dynamic resultInfos = new ExpandoObject();
|
var (item, totalCount) = new SJService().getPage(queryObj);
|
resultInfos.tbBillList = item;
|
return new ResponseResult
|
{
|
status = 0,
|
message = "OK",
|
data = resultInfos,
|
TotalCount = totalCount
|
};
|
}
|
catch (Exception ex)
|
{
|
return ResponseResult.ResponseError(ex);
|
}
|
}
|
|
|
//SetQSItems
|
[HttpPost("SetQSItems")]
|
public ResponseResult SetQSItems([FromBody] JObject data)
|
{
|
var itemNo = data["itemNo"].ToString();
|
try
|
{
|
dynamic resultInfos = new ExpandoObject();
|
var tbBillList = new SJService();
|
var detail021 = tbBillList.SetQSItems(itemNo);
|
resultInfos.tbBillList = detail021;
|
return new ResponseResult
|
{
|
status = 0,
|
message = "OK",
|
data = resultInfos
|
};
|
}
|
catch (Exception ex)
|
{
|
return ResponseResult.ResponseError(ex);
|
}
|
}
|
|
[HttpPost("Save")]
|
public ResponseResult Save([FromBody] QsItem item)
|
{
|
try
|
{
|
dynamic resultInfos = new ExpandoObject();
|
var tbBillList = new SJService();
|
var detail021 = tbBillList.Save(item);
|
resultInfos.tbBillList = detail021;
|
return new ResponseResult
|
{
|
status = 0,
|
message = "OK",
|
data = resultInfos
|
};
|
}
|
catch (Exception ex)
|
{
|
return ResponseResult.ResponseError(ex);
|
}
|
}
|
|
//SaveItem
|
[HttpPost("SaveItem")]
|
public ResponseResult SaveItem([FromBody] QsItem item)
|
{
|
try
|
{
|
dynamic resultInfos = new ExpandoObject();
|
var tbBillList = new SJService();
|
var detail021 = tbBillList.SaveItem(item);
|
resultInfos.tbBillList = detail021;
|
return new ResponseResult
|
{
|
status = 0,
|
message = "OK",
|
data = resultInfos
|
};
|
}
|
catch (Exception ex)
|
{
|
return ResponseResult.ResponseError(ex);
|
}
|
}
|
|
//getQSItems
|
[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 SJService();
|
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("SetQSItemDetail")]
|
public ResponseResult SetQSItemDetail([FromBody] QsItemIpiItemDetail detail)
|
{
|
try
|
{
|
dynamic resultInfos = new ExpandoObject();
|
var tbBillList = new SJService();
|
var detail021 = tbBillList.SetQSItemDetail(detail);
|
resultInfos.tbBillList = detail021;
|
return new ResponseResult
|
{
|
status = 0,
|
message = "OK",
|
data = resultInfos
|
};
|
}
|
catch (Exception ex)
|
{
|
return ResponseResult.ResponseError(ex);
|
}
|
}
|
|
|
[HttpPost("getQSItemDetail")]
|
public ResponseResult getQSItemDetail([FromBody] JObject data)
|
{
|
var pid = data["pid"]?.ToString();
|
var gid = data["gid"]?.ToString();
|
|
try
|
{
|
dynamic resultInfos = new ExpandoObject();
|
var tbBillList = new SJService();
|
var detail021 = tbBillList.getQSItemDetail(Convert.ToDecimal(pid),
|
Convert.ToDecimal(gid));
|
resultInfos.tbBillList = detail021;
|
return new ResponseResult
|
{
|
status = 0,
|
message = "OK",
|
data = resultInfos
|
};
|
}
|
catch (Exception ex)
|
{
|
return ResponseResult.ResponseError(ex);
|
}
|
}
|
|
|
[HttpPost("UpdateQSItemDetail")]
|
public ResponseResult UpdateQSItemDetail(
|
[FromBody] QsItemIpiItemDetail detail)
|
{
|
try
|
{
|
dynamic resultInfos = new ExpandoObject();
|
var tbBillList = new SJService();
|
var detail021 = tbBillList.UpdateQSItemDetail(detail);
|
resultInfos.tbBillList = detail021;
|
return new ResponseResult
|
{
|
status = 0,
|
message = "OK",
|
data = resultInfos
|
};
|
}
|
catch (Exception ex)
|
{
|
return ResponseResult.ResponseError(ex);
|
}
|
}
|
|
//saveRemarksGid
|
[HttpPost("saveRemarksGid")]
|
public ResponseResult saveRemarksGid([FromBody] QsItem rkjDto)
|
{
|
try
|
{
|
dynamic resultInfos = new ExpandoObject();
|
var tbBillList =
|
new SJService().saveRemarksGid(rkjDto);
|
resultInfos.tbBillList = tbBillList;
|
return new ResponseResult
|
{
|
status = 0,
|
message = "OK",
|
data = resultInfos
|
};
|
}
|
catch (Exception ex)
|
{
|
return ResponseResult.ResponseError(ex);
|
}
|
}
|
|
//saveRemarksPid
|
[HttpPost("saveRemarksPid")]
|
public ResponseResult saveRemarksPid([FromBody] QsItem rkjDto)
|
{
|
try
|
{
|
dynamic resultInfos = new ExpandoObject();
|
var tbBillList =
|
new SJService().saveRemarksPid(rkjDto);
|
resultInfos.tbBillList = tbBillList;
|
return new ResponseResult
|
{
|
status = 0,
|
message = "OK",
|
data = resultInfos
|
};
|
}
|
catch (Exception ex)
|
{
|
return ResponseResult.ResponseError(ex);
|
}
|
}
|
|
//saveRemarksById
|
[HttpPost("saveRemarksById")]
|
public ResponseResult saveRemarksById([FromBody] QsItem rkjDto)
|
{
|
try
|
{
|
dynamic resultInfos = new ExpandoObject();
|
var tbBillList =
|
new SJService().saveRemarksById(rkjDto);
|
resultInfos.tbBillList = tbBillList;
|
return new ResponseResult
|
{
|
status = 0,
|
message = "OK",
|
data = resultInfos
|
};
|
}
|
catch (Exception ex)
|
{
|
return ResponseResult.ResponseError(ex);
|
}
|
}
|
|
//removeSJ
|
[HttpPost("removeSJ")]
|
public ResponseResult removeSJ([FromBody] JObject data)
|
{
|
var id = data["id"]?.ToString();
|
try
|
{
|
dynamic resultInfos = new ExpandoObject();
|
var tbBillList =
|
new SJService().removeXJ(Convert.ToDecimal(id));
|
resultInfos.tbBillList = tbBillList;
|
return new ResponseResult
|
{
|
status = 0,
|
message = "OK",
|
data = resultInfos
|
};
|
}
|
catch (Exception ex)
|
{
|
return ResponseResult.ResponseError(ex);
|
}
|
}
|
|
//IqcQaSubmit
|
[HttpPost("SJQaSubmit")]
|
public ResponseResult SJQaSubmit(LLJDto rkjDto)
|
{
|
try
|
{
|
OracleSQLHelper SQLHelper = new();
|
var sql1 =
|
string.Format(
|
@"select SCAN_ITEM from ZMZ_TEST.MES_SJ_SCAN_ITEM_CK where mid='" + rkjDto.gid + "' and sn_no is null");
|
var dataTable1 = SQLHelper.ExecuteQuery(sql1);
|
string msg = "";
|
for (var i = 0; i < dataTable1.Rows.Count; i++)
|
{
|
msg = msg + "【"+dataTable1.Rows[i]["SCAN_ITEM"].ToString()+"】";
|
}
|
if (msg != null && msg != "")
|
{
|
return new ResponseResult
|
{
|
status = 1,
|
message = msg+"未进行SN扫码确认!",
|
data = ""
|
};
|
}
|
var msg1 = new SJService().YzxImgVerify(rkjDto.gid.ToString());
|
if (msg1[0]=="1")
|
{
|
return new ResponseResult
|
{
|
status = int.Parse(msg1[0]),
|
message = msg1[1],
|
data = ""
|
};
|
}
|
dynamic resultInfos = new ExpandoObject();
|
var tbBillList =
|
new SJService().SJQaSubmit(rkjDto);
|
resultInfos.tbBillList = tbBillList;
|
return new ResponseResult
|
{
|
status = 0,
|
message = "OK",
|
data = resultInfos
|
};
|
}
|
catch (Exception ex)
|
{
|
return ResponseResult.ResponseError(ex);
|
}
|
}
|
|
/// <summary>
|
/// 获取一致性核对项目
|
/// </summary>
|
/// <param name="data"></param>
|
/// <returns></returns>
|
[HttpPost("getYzxItem")]
|
public ResponseResult getYzxItem([FromBody] JObject data)
|
{
|
var id = data["id"]?.ToString();
|
try
|
{
|
var tbBillList = new SJService().getYzxBDlist(id);
|
|
return new ResponseResult
|
{
|
status = 0,
|
message = "OK",
|
data = tbBillList
|
};
|
}
|
catch (Exception ex)
|
{
|
return ResponseResult.ResponseError(ex);
|
}
|
}
|
|
/// <summary>
|
/// 保存一致性核对项目
|
/// </summary>
|
/// <param name="data"></param>
|
/// <returns></returns>
|
[HttpPost("saveYzxItem")]
|
public ResponseResult saveYzxItem([FromBody] JObject data)
|
{
|
var id = data["id"]?.ToString();
|
var dataDt = data["data"]?.ToString();
|
var dt = JsonConvert.DeserializeObject<DataTable>(dataDt);
|
try
|
{
|
if (!dt.Columns.Contains("id"))
|
{
|
return new ResponseResult
|
{
|
status = 1,
|
message = "请先选择数据再保存！",
|
data = "请先选择数据再保存！"
|
};
|
}
|
new SJService().saveYzxBDlist(id, dt);
|
var msg = new SJService().YzxImgVerify(id);
|
|
return new ResponseResult
|
{
|
status = int.Parse(msg[0]),
|
message = msg[1],
|
data = ""
|
};
|
}
|
catch (Exception ex)
|
{
|
return ResponseResult.ResponseError(ex);
|
}
|
}
|
/// <summary>
|
/// 扫码项目获取
|
/// </summary>
|
/// <param name="mid"></param>
|
/// <returns></returns>
|
[HttpPost("GetList")]
|
public ResponseResult GetList([FromBody] JObject data)
|
{
|
var mid = data["mid"];
|
var db = SqlSugarHelper.GetInstance();
|
var list = db.Queryable<MES_SJ_SCAN_ITEM_CK>()
|
.Where(x => x.MID == (long)mid)
|
.Select(x => new {
|
id = x.ID,
|
scanItem = x.SCAN_ITEM,
|
snNo = x.SN_NO
|
})
|
.ToList();
|
|
return new ResponseResult
|
{
|
status = int.Parse("0"),
|
message = "0",
|
data = list
|
};
|
|
}
|
/// <summary>
|
/// 扫码项目保存
|
/// </summary>
|
/// <param name="dto"></param>
|
/// <returns></returns>
|
[HttpPost("SaveSn")]
|
public ResponseResult SaveSn([FromBody] ScanItemSaveDto dto)
|
{
|
var db = SqlSugarHelper.GetInstance();
|
foreach (var item in dto.Items)
|
{
|
db.Updateable<MES_SJ_SCAN_ITEM_CK>()
|
.SetColumns(x => x.SN_NO == item.SnNo)
|
.Where(x => x.ID == item.Id)
|
.ExecuteCommand();
|
}
|
return new ResponseResult
|
{
|
status = int.Parse("0"),
|
message = "ok",
|
data = ""
|
};
|
|
}
|
|
public class ScanItemSaveDto
|
{
|
public decimal Mid { get; set; }
|
public List<ScanItemDto> Items { get; set; }
|
}
|
|
public class ScanItemDto
|
{
|
public decimal Id { get; set; }
|
public string SnNo { get; set; }
|
}
|
|
/// <summary>
|
/// 获取所有检验员信息
|
/// </summary>
|
/// <param name="data"></param>
|
/// <returns></returns>
|
[HttpPost("getAllInspectors")]
|
public ResponseResult getAllInspectors([FromBody] JObject data)
|
{
|
try
|
{
|
var tbBillList = new SJService().getAllInspectors();
|
return new ResponseResult
|
{
|
status = 0,
|
message = "OK",
|
data = tbBillList
|
};
|
}
|
catch (Exception ex)
|
{
|
return ResponseResult.ResponseError(ex);
|
}
|
}
|
|
|
|
|
[HttpPost("SaveCheckBy")]
|
public ResponseResult SaveCheckBy([FromBody] JObject data)
|
{
|
try
|
{
|
var NewStaffName = data["NewStaffName"].ToString();
|
var userID = data["userID"].ToString();
|
var releaseNo = data["releaseNo"].ToString();
|
var NewStaffUserID = data["NewStaffUserID"].ToString();
|
|
var msg =
|
new SJService().SaveCheckBy(NewStaffUserID, userID, releaseNo);
|
|
|
return new ResponseResult
|
{
|
status = int.Parse(msg[0]),
|
message = msg[1],
|
data = msg[1]
|
};
|
}
|
catch (Exception ex)
|
{
|
return ResponseResult.ResponseError(ex);
|
}
|
}
|
|
}
|
