From a619299816f2f632c7c6ba3a1bb869e2c212797d Mon Sep 17 00:00:00 2001
From: fcx <2246384483@qq.com>
Date: 星期五, 19 十二月 2025 14:12:33 +0800
Subject: [PATCH] 对添加巡检单物料编码进行去重
---
StandardPda/MES.Service/service/QC/LljService.cs | 1509 +++++++++++++++++++++++++++++++++++++++++++++++----------
1 files changed, 1,245 insertions(+), 264 deletions(-)
diff --git a/StandardPda/MES.Service/service/QC/LljService.cs b/StandardPda/MES.Service/service/QC/LljService.cs
index e5e979e..6deba4d 100644
--- a/StandardPda/MES.Service/service/QC/LljService.cs
+++ b/StandardPda/MES.Service/service/QC/LljService.cs
@@ -1,23 +1,18 @@
-锘縰sing Masuit.Tools;
+锘縰sing Dm.Config;
+using Masuit.Tools;
using MES.Service.DB;
using MES.Service.Dto.service;
using MES.Service.Modes;
using MES.Service.util;
-using MySqlConnector;
+using Microsoft.Extensions.Configuration;
using Newtonsoft.Json;
-using RestSharp;
-using SharpCompress.Factories;
+using Oracle.ManagedDataAccess.Client;
using SqlSugar;
-using System.ComponentModel;
using System.Data;
-using System.Xml.Linq;
-using ZstdSharp.Unsafe;
-using System.Net.Http;
-using static Microsoft.EntityFrameworkCore.DbLoggerCategory.Database;
-using DbType = System.Data.DbType;
-using System.Text;
using System.Security.Cryptography;
-using AngleSharp.Io;
+using System.Text;
+using System.Text.Json.Serialization;
+using DbType = System.Data.DbType;
namespace MES.Service.service.QC;
@@ -25,6 +20,10 @@
public class LljService
{
private static readonly HttpClient client = new();
+ private static IConfiguration configuration = new ConfigurationBuilder()
+ .SetBasePath(Directory.GetCurrentDirectory())
+ .AddJsonFile("appsettings.json", optional: true, reloadOnChange: true)
+ .Build();
public (List<LtsLlj> item, int TotalCount) GetPage(XJPageResult queryObj)
{
@@ -40,14 +39,16 @@
var pageList = db
.Queryable<LtsLlj, IqcBefore, VMesQaItemsDetect01, SysUser,
- IqcBeforeFrom, SysUser, InspectorChangeLog, SysUser>((a, b, d, e, f, g,h,i) =>
+ IqcBeforeFrom, SysUser, InspectorChangeLog, SysUser>((a, b, d,
+ e, f, g, h, i) =>
new JoinQueryInfos(JoinType.Left, a.ItemId == b.ItemId,
JoinType.Inner, a.Id == d.Id,
JoinType.Left, a.CreateBy == e.Fcode,
JoinType.Left, f.Id == b.PID,
JoinType.Left, f.Sid == g.Fid,
- JoinType.Left,a.ReleaseNo==h.InspectionNo && h.IsValid=="Y",
- JoinType.Left,i.Fcode==h.Inspector
+ JoinType.Left,
+ a.ReleaseNo == h.InspectionNo && h.IsValid == "Y",
+ JoinType.Left, i.Fcode == h.Inspector
))
.WhereIF(
StringUtil.IsNotNullOrEmpty(queryObj.result) &&
@@ -61,6 +62,7 @@
// itemIds is { Length: > 0 },
// (a, b, c) => itemIds.Contains(a.ItemId))
.WhereIF(id > 0, (a, b, d) => a.Id == id)
+ .WhereIF(queryObj.arrivalFilter >= 0, (a, b, d) => a.IsArrival == queryObj.arrivalFilter)
.WhereIF(queryObj.createUser!="PL017"&& queryObj.UserIndex=="0", (a, b, d, e, f, g,h, i) => (g.Fcode == queryObj.createUser || i.Fcode == queryObj.createUser))//鍒ゆ柇姝ゅ崟鐨勬楠屽憳锛屾垨鑰呮楠屼负绌哄氨鏄剧ず姝ゅ崟鎹�
//鍔犵瓫閫夋潯浠�,鏍规嵁渚涘簲鍟嗭紝鐗╂枡缂栫爜锛岀墿鏂欏悕绉帮紝椤圭洰鎼滅储
//.WhereIF(queryObj.SearchValue != null && queryObj.SearchValue != "",
@@ -79,11 +81,11 @@
.WhereIF(queryObj.result == "宸插畬鎴�" && queryObj.state!= "鎵�鏈夌姸鎬�",(a, b, d, e) => (a.FcheckResu == queryObj.state))
// .WhereIF(queryObj.result == "鏈畬鎴�" && queryObj.SearchValue != null && queryObj.SearchValue != "", (a, b, d, e) => (e.Fname.ToLower().Contains(queryObj.SearchValue.ToLower())))
//.OrderByDescending((a, b, d) => a.Id)
- .Select((a, b, d, e, f, g,h,i) => new LtsLlj
+ .Select((a, b, d, e, f, g, h, i) => new LtsLlj
{
//UserName = g.Fname,
//UserName = (i.Fname!=null ||i.Fname!="") ? i.Fname : g.Fname,
- UserName = (i.Fname!=null ||i.Fname!="") ? i.Fname : g.Fname,
+ UserName = i.Fname != null || i.Fname != "" ? i.Fname : g.Fname,
FIRST = d.First,
CreateUserName = e.Fname,
NewFngDesc = d.NewFngDesc,
@@ -214,7 +216,7 @@
/// <summary>
- /// 璋冪敤瀛樺偍杩囩▼锛岄噸鏂拌幏鍙栨楠岄」鐩�
+ /// 璋冪敤瀛樺偍杩囩▼锛岄噸鏂拌幏鍙栨楠岄」鐩�
/// </summary>
/// <param name="itemNo"></param>
/// <param name="quantity"></param>
@@ -236,9 +238,9 @@
var parameters = new List<SugarParameter>
{
new("P_RELEASE_NO", releaseNo,
- DbType.String, ParameterDirection.Input),
- outputResult,
- outputMessage
+ DbType.String, ParameterDirection.Input),
+ outputResult,
+ outputMessage
};
var db = SqlSugarHelper.GetInstance();
@@ -251,24 +253,22 @@
// 鑾峰彇杈撳嚭鍙傛暟鐨勫��
var resultValue = outputResult.Value?.ToString();
var messageValue = outputMessage.Value?.ToString();
- string[] msg = new string[2];
+ var msg = new string[2];
msg[0] = resultValue;
msg[1] = messageValue;
return msg;
-
}
-
-
/// <summary>
- /// 淇濆瓨鏂版楠屽憳
+ /// 淇濆瓨鏂版楠屽憳
/// </summary>
/// <param name="NewStaffUserID">鏂版楠屽憳ID</param>
/// <param name="userID">淇敼浜�</param>
/// <param name="releaseNo">妫�楠屽崟鍙�</param>
/// <returns></returns>
- public string[] SaveCheckBy(string NewStaffUserID, string userID, string releaseNo)
+ public string[] SaveCheckBy(string NewStaffUserID, string userID,
+ string releaseNo)
{
// 瀹氫箟杈撳嚭鍙傛暟
var outputResult = new SugarParameter("o_Result", null,
@@ -283,14 +283,14 @@
var parameters = new List<SugarParameter>
{
new("P_FCHECK_BY", NewStaffUserID,
- DbType.String, ParameterDirection.Input),
- new("p_Release_No", releaseNo,
- DbType.String, ParameterDirection.Input),
+ DbType.String, ParameterDirection.Input),
+ new("p_Release_No", releaseNo,
+ DbType.String, ParameterDirection.Input),
new("p_User", userID,
- DbType.String, ParameterDirection.Input),
-
- outputResult,
- outputMessage
+ DbType.String, ParameterDirection.Input),
+
+ outputResult,
+ outputMessage
};
var db = SqlSugarHelper.GetInstance();
@@ -303,13 +303,11 @@
// 鑾峰彇杈撳嚭鍙傛暟鐨勫��
var resultValue = outputResult.Value?.ToString();
var messageValue = outputMessage.Value?.ToString();
- string[] msg = new string[2];
+ var msg = new string[2];
msg[0] = resultValue;
msg[1] = messageValue;
return msg;
-
}
-
public string[] SaveSysSubmit(SysSubmit sysSubmit)
@@ -327,91 +325,99 @@
var parameters = new List<SugarParameter>
{
new("PI_BILLNO", sysSubmit.PI_BILLNO,
- DbType.String, ParameterDirection.Input),
- new("PI_USER", sysSubmit.PI_USER,
- DbType.String, ParameterDirection.Input),
- new("PI_SAMPLE_STATUS", sysSubmit.PI_SAMPLE_STATUS,
- DbType.String, ParameterDirection.Input),
- new("PI_SAMPLE_TYPE", sysSubmit.PI_SAMPLE_TYPE,
- DbType.String, ParameterDirection.Input),
- new("PI_SAMPLE_REASON", sysSubmit.PI_SAMPLE_REASON,
- DbType.String, ParameterDirection.Input),
- new("PI_INSPECT_TYPE", sysSubmit.PI_INSPECT_TYPE,
- DbType.String, ParameterDirection.Input),
- new("PI_SAMPLE_PREPARATION", sysSubmit.PI_SAMPLE_PREPARATION,
- DbType.String, ParameterDirection.Input),
- new("PI_URGENCY", sysSubmit.PI_URGENCY,
- DbType.String, ParameterDirection.Input),
- new("PI_FIRMWAREVERSION", sysSubmit.PI_FIRMWAREVERSION,
- DbType.String, ParameterDirection.Input),
- new("PI_HARDWAREVERSION", sysSubmit.PI_HARDWAREVERSION,
- DbType.String, ParameterDirection.Input),
- new("PI_REMARK", sysSubmit.PI_REMARK,
- DbType.String, ParameterDirection.Input),
+ DbType.String, ParameterDirection.Input),
+ new("PI_USER", sysSubmit.PI_USER,
+ DbType.String, ParameterDirection.Input),
+ new("PI_SAMPLE_STATUS", sysSubmit.PI_SAMPLE_STATUS,
+ DbType.String, ParameterDirection.Input),
+ new("PI_SAMPLE_TYPE", sysSubmit.PI_SAMPLE_TYPE,
+ DbType.String, ParameterDirection.Input),
+ new("PI_SAMPLE_REASON", sysSubmit.PI_SAMPLE_REASON,
+ DbType.String, ParameterDirection.Input),
+ new("PI_INSPECT_TYPE", sysSubmit.PI_INSPECT_TYPE,
+ DbType.String, ParameterDirection.Input),
+ new("PI_SAMPLE_PREPARATION", sysSubmit.PI_SAMPLE_PREPARATION,
+ DbType.String, ParameterDirection.Input),
+ new("PI_URGENCY", sysSubmit.PI_URGENCY,
+ DbType.String, ParameterDirection.Input),
+ new("PI_FIRMWAREVERSION", sysSubmit.PI_FIRMWAREVERSION,
+ DbType.String, ParameterDirection.Input),
+ new("PI_HARDWAREVERSION", sysSubmit.PI_HARDWAREVERSION,
+ DbType.String, ParameterDirection.Input),
+ new("PI_REMARK", sysSubmit.PI_REMARK,
+ DbType.String, ParameterDirection.Input),
+ new("PI_SAMPLE_QTY", sysSubmit.PI_SAMPLE_QTY,
+ DbType.String, ParameterDirection.Input),
outputResult,
outputMessage
- };
+ };
var db = SqlSugarHelper.GetInstance();
// 浣跨敤 SqlSugar 鎵ц瀛樺偍杩囩▼
db.Ado.ExecuteCommand(
- "BEGIN PRC_MES_IQC_QC_SYSSUBMIT(:PI_BILLNO,:PI_USER,:PI_SAMPLE_STATUS,:PI_SAMPLE_TYPE,:PI_SAMPLE_REASON,:PI_INSPECT_TYPE,:PI_SAMPLE_PREPARATION,:PI_URGENCY,:PI_FIRMWAREVERSION,:PI_HARDWAREVERSION,:PI_REMARK, :o_Result, :o_Msg); END;",
+ "BEGIN PRC_MES_IQC_QC_SYSSUBMIT(:PI_BILLNO,:PI_USER,:PI_SAMPLE_STATUS,:PI_SAMPLE_TYPE,:PI_SAMPLE_REASON,:PI_INSPECT_TYPE,:PI_SAMPLE_PREPARATION,:PI_URGENCY,:PI_FIRMWAREVERSION,:PI_HARDWAREVERSION,:PI_REMARK,:PI_SAMPLE_QTY, :o_Result, :o_Msg); END;",
parameters.ToArray());
// 鑾峰彇杈撳嚭鍙傛暟鐨勫��
var resultValue = outputResult.Value?.ToString();
var messageValue = outputMessage.Value?.ToString();
- string[] msg = new string[2];
+ var msg = new string[2];
msg[0] = resultValue;
msg[1] = messageValue;
return msg;
-
}
- public class DataAcquisitionConfiguration
+ public string[] SaveYCCZSubmit(YCCZSubmit sysSubmit)
{
- //娴嬭瘯鐜
- public const string TEST_COMPANY_CODE = "55958795";
- public const string TEST_APP_KEY = "ab2d86b6dffabcc81dca6855c727c246";
- public const string TEST_APP_SECRET = "01b17babe2a96d5ebd802e67709f33d1";
- public const string TEST_ERP_CODE = "Z106";
+ // 瀹氫箟杈撳嚭鍙傛暟
+ var outputResult = new SugarParameter("o_Result", null,
+ DbType.Int32, ParameterDirection.Output,
+ 4000);
- //姝ｅ紡鐜
- public const string COMPANY_CODE = "72505985";
- public const string APP_KEY = "a2866f03bb7f76387bfb1a98001f0e31";
- public const string APP_SECRET = "f13bd1bcb130f0090ed92dc021e5f4e1";
- public const string ERP_CODE = "Z106";
+ var outputMessage = new SugarParameter("o_Msg", null,
+ DbType.String,
+ ParameterDirection.Output, 4000);
+
+ // 瀹氫箟杈撳叆鍙傛暟
+ var parameters = new List<SugarParameter>
+ {
+ new("PI_BILLNO", sysSubmit.PI_BILLNO,
+ DbType.String, ParameterDirection.Input),
+ new("PI_USER", sysSubmit.PI_USER,
+ DbType.String, ParameterDirection.Input),
+ new("PTOTAL_QTY", sysSubmit.PI_QTY,
+ DbType.String, ParameterDirection.Input),
+ new("PNG_QTY", sysSubmit.PI_BADQTY,
+ DbType.String, ParameterDirection.Input),
+
+ outputResult,
+ outputMessage
+ };
+
+ var db = SqlSugarHelper.GetInstance();
+
+ // 浣跨敤 SqlSugar 鎵ц瀛樺偍杩囩▼
+ db.Ado.ExecuteCommand(
+ "BEGIN PRC_MES_IQC_QC_YCCZ(:PI_BILLNO,:PI_USER,:PTOTAL_QTY,:PNG_QTY,:o_Result, :o_Msg); END;",
+ parameters.ToArray());
+
+ // 鑾峰彇杈撳嚭鍙傛暟鐨勫��
+ var resultValue = outputResult.Value?.ToString();
+ var messageValue = outputMessage.Value?.ToString();
+ var msg = new string[2];
+ msg[0] = resultValue;
+ msg[1] = messageValue;
+ return msg;
}
- [Serializable]
- public class ApiCommonParam
- {
- //鍙戞斁缁欑敤鎴风殑Key
- public string appKey { get; set; }
- //鎺ュ彛鐗堟湰
- public string version { get; set; }
- //鏁版嵁鎵�灞炲叕鍙哥紪鐮�
- public string ownerCompanyCode { get; set; }
- //鎿嶄綔鑰呮墍灞炲叕鍙哥紪鐮�
- public string operateCompanyCode { get; set; }
- //绛惧悕
- public string sign { get; set; }
- //鏃堕棿鎴�
- public long? timestamps { get; set; }
- ////鎵╁睍瀛楁
- //public object Reserver { get; set; }
- }
- [Serializable]
- public class BodyParam
- {
- public string erpCode { get; set; }
- public string dnXkNo { get; set; }
- }
+
public static string BuildCurrentSign(string paramJson, string appSecret)
{
var commonDict = new Dictionary<string, string>();
- var jsonDict = JsonConvert.DeserializeObject<Dictionary<string, object>>(paramJson);
+ var jsonDict =
+ JsonConvert
+ .DeserializeObject<Dictionary<string, object>>(paramJson);
var keyList = new List<string>();
foreach (var entry in jsonDict)
@@ -429,60 +435,21 @@
// 鎷兼帴绛惧悕瀛楃涓�
var sb = new StringBuilder();
- foreach (var key in keyList)
- {
- sb.Append(commonDict[key]).Append(":");
- }
+ foreach (var key in keyList) sb.Append(commonDict[key]).Append(":");
sb.Append(appSecret);
// 璁＄畻MD5
using var md5 = MD5.Create();
- byte[] hashBytes = md5.ComputeHash(Encoding.UTF8.GetBytes(sb.ToString()));
+ var hashBytes = md5.ComputeHash(Encoding.UTF8.GetBytes(sb.ToString()));
return BitConverter.ToString(hashBytes)
- .Replace("-", "")
- .ToLowerInvariant();
- }
- public class XkyCommonParam
- {
- public ApiCommonParam commonParam { get; set; }
- public BodyParam body { get; set; }
-
- public static XkyCommonParam GetInit()
- {
- var apiParam = new ApiCommonParam
- {
- // 鍙戞惡瀹簯鎻愪緵鐨刟ppKey
- appKey = DataAcquisitionConfiguration.APP_KEY,
- // 鎺ュ彛鐗堟湰
- version = "1.0",
- // 鎿嶄綔鑰呮墍灞炲叕鍙哥紪鐮�
- operateCompanyCode = DataAcquisitionConfiguration.COMPANY_CODE,
- // 鏁版嵁鎵�灞炲叕鍙哥紪鐮侊紝闈為泦鍥㈠叕鍙搁粯璁よ祴鍊间负鎿嶄綔鍏徃
- ownerCompanyCode = DataAcquisitionConfiguration.COMPANY_CODE,
- // 褰撳墠鏃堕棿瀵瑰簲鐨勬椂闂存埑锛堢鏁帮級
- timestamps = DateTimeOffset.UtcNow.ToUnixTimeSeconds()
- };
-
-
- string appSecret = DataAcquisitionConfiguration.APP_SECRET;
-
- // 鐢熸垚绛惧悕
- string sign = BuildCurrentSign(
- JsonConvert.SerializeObject(apiParam),
- appSecret);
- apiParam.sign = sign;
-
- return new XkyCommonParam
- {
- commonParam = apiParam
- };
- }
+ .Replace("-", "")
+ .ToLowerInvariant();
}
public async Task<string[]> SignDelivery(string id)
{
- string[] msg = new string[2];
+ var msg = new string[2];
//鍙戣捣璇锋眰锛岀鏀堕�佽揣鍗�
try
@@ -495,27 +462,30 @@
};
// 搴忓垪鍖栦负JSON
- string json = JsonConvert.SerializeObject(requestData);
+ var json = JsonConvert.SerializeObject(requestData);
- using (var client = new HttpClient())
- {
- // 璁剧疆璇锋眰鍐呭
- var content = new StringContent(json, Encoding.UTF8, "application/json");
- // 鍙戦�丳OST璇锋眰
- HttpResponseMessage response = await client.PostAsync(
- "https://openapi.xiekeyun.com/delivery/updateDeliveryStatus.json",
- content);
- // 澶勭悊鍝嶅簲
- if (response.IsSuccessStatusCode)
+ using (var client = new HttpClient())
{
- string responseBody = await response.Content.ReadAsStringAsync();
+ // 璁剧疆璇锋眰鍐呭
+ var content = new StringContent(json, Encoding.UTF8,
+ "application/json");
+ // 鍙戦�丳OST璇锋眰
+ var response = await client.PostAsync(
+ "https://openapi.xiekeyun.com/delivery/updateDeliveryStatus.json",
+ content);
+ // 澶勭悊鍝嶅簲
+ if (response.IsSuccessStatusCode)
+ {
+ var responseBody =
+ await response.Content.ReadAsStringAsync();
var result =
- JsonConvert.DeserializeObject<XKYApiResponse>(responseBody);
+ JsonConvert.DeserializeObject<XKYApiResponse>(
+ responseBody);
//鎴愬姛鍚庢墜鍔ㄤ笅鎺ㄥ埌璐у崟
- if (result.Result == 1) {
-
+ if (result.Result == 1)
+ {
// 瀹氫箟杈撳嚭鍙傛暟
-
+
var outputMessage = new SugarParameter("C_RESULT", null,
DbType.String,
ParameterDirection.Output, 4000);
@@ -523,8 +493,8 @@
// 瀹氫箟杈撳叆鍙傛暟
var parameters = new List<SugarParameter>
{
- new("C_IN_STR", "閫佽揣鍗曠鏀禰BTNOK[PL017["+id,
- DbType.String, ParameterDirection.Input),
+ new("C_IN_STR", "閫佽揣鍗曠鏀禰BTNOK[PL017[" + id,
+ DbType.String, ParameterDirection.Input),
outputMessage
};
@@ -537,7 +507,7 @@
// 鑾峰彇杈撳嚭鍙傛暟鐨勫��
-
+
var messageValue = outputMessage.Value?.ToString();
msg[0] = "0";
@@ -545,21 +515,22 @@
}
else
{
- if (result.ErrorMsg== "鍑鸿揣鍗曟嵁涓嶆槸宸查�佽揣鐘舵�侊紒")
+ if (result.ErrorMsg == "鍑鸿揣鍗曟嵁涓嶆槸宸查�佽揣鐘舵�侊紒")
{
// 瀹氫箟杈撳嚭鍙傛暟
- var outputMessage = new SugarParameter("C_RESULT", null,
+ var outputMessage = new SugarParameter("C_RESULT",
+ null,
DbType.String,
ParameterDirection.Output, 4000);
// 瀹氫箟杈撳叆鍙傛暟
var parameters = new List<SugarParameter>
- {
- new("C_IN_STR", "閫佽揣鍗曠鏀禰BTNOK[PL017["+id,
- DbType.String, ParameterDirection.Input),
- outputMessage
- };
+ {
+ new("C_IN_STR", "閫佽揣鍗曠鏀禰BTNOK[PL017[" + id,
+ DbType.String, ParameterDirection.Input),
+ outputMessage
+ };
var db = SqlSugarHelper.GetInstance();
@@ -581,21 +552,17 @@
msg[0] = "1";
msg[1] = "002[" + id + "绛炬敹澶辫触锛�" + result.ErrorMsg;
}
-
}
-
}
- else
- {
-
+ else
+ {
msg[0] = "1";
msg[1] = $"002[{id}绛炬敹澶辫触锛岃姹傚け璐ワ紝鐘舵�佺爜锛歿response.StatusCode}";
+ }
}
}
- }
catch (Exception ex)
{
-
msg[0] = "1";
msg[1] = $"002[璇锋眰澶辫触锛岀姸鎬佺爜锛歿ex.Message}";
}
@@ -604,10 +571,495 @@
//msg[0] = "1";
//msg[1] = responseBody;
return msg;
+ }
+ public async Task<string[]> SignDelivery2(string id,string c_user)
+ {
+ var msg = new string[2];
+ //鍙戣捣璇锋眰锛岀鏀堕�佽揣鍗�
+ try
+ {
+ var requestData = XkyCommonParam.GetInit();
+ requestData.body = new BodyParam
+ {
+ erpCode = "Z106",
+ dnXkNo = id
+ };
+
+ // 搴忓垪鍖栦负JSON
+ var json = JsonConvert.SerializeObject(requestData);
+
+ using (var client = new HttpClient())
+ {
+ // 璁剧疆璇锋眰鍐呭
+ var content = new StringContent(json, Encoding.UTF8,
+ "application/json");
+ // 鍙戦�丳OST璇锋眰
+ var response = await client.PostAsync(
+ "https://openapi.xiekeyun.com/delivery/updateDeliveryStatus.json",
+ content);
+ // 澶勭悊鍝嶅簲
+ if (response.IsSuccessStatusCode)
+ {
+ var responseBody =
+ await response.Content.ReadAsStringAsync();
+ var result =
+ JsonConvert.DeserializeObject<XKYApiResponse>(
+ responseBody);
+ //鎴愬姛鍚庢墜鍔ㄤ笅鎺ㄥ埌璐у崟
+ if (result.Result == 1)
+ {
+ // 瀹氫箟杈撳嚭鍙傛暟
+
+ var outputMessage = new SugarParameter("C_RESULT", null,
+ DbType.String,
+ ParameterDirection.Output, 4000);
+
+ // 瀹氫箟杈撳叆鍙傛暟
+ var parameters = new List<SugarParameter>
+ {
+ new("C_IN_STR", "閫佽揣鍗曠鏀禰BTNOK["+c_user+"[" + id,
+ DbType.String, ParameterDirection.Input),
+ outputMessage
+ };
+
+ var db = SqlSugarHelper.GetInstance();
+
+ // 浣跨敤 SqlSugar 鎵ц瀛樺偍杩囩▼
+ db.Ado.ExecuteCommand(
+ "BEGIN PRC_RF_PDA_RECEIPT_BTN(:C_IN_STR,:C_RESULT); END;",
+ parameters.ToArray());
+
+
+ // 鑾峰彇杈撳嚭鍙傛暟鐨勫��
+
+ var messageValue = outputMessage.Value?.ToString();
+
+ msg[0] = "0";
+ msg[1] = messageValue;
+ }
+ else
+ {
+ if (result.ErrorMsg == "鍑鸿揣鍗曟嵁涓嶆槸宸查�佽揣鐘舵�侊紒")
+ {
+ // 瀹氫箟杈撳嚭鍙傛暟
+
+ var outputMessage = new SugarParameter("C_RESULT",
+ null,
+ DbType.String,
+ ParameterDirection.Output, 4000);
+
+ // 瀹氫箟杈撳叆鍙傛暟
+ var parameters = new List<SugarParameter>
+ {
+ new("C_IN_STR", "閫佽揣鍗曠鏀禰BTNOK["+c_user+"[" + id,
+ DbType.String, ParameterDirection.Input),
+ outputMessage
+ };
+
+ var db = SqlSugarHelper.GetInstance();
+
+ // 浣跨敤 SqlSugar 鎵ц瀛樺偍杩囩▼
+ db.Ado.ExecuteCommand(
+ "BEGIN PRC_RF_PDA_RECEIPT_BTN(:C_IN_STR,:C_RESULT); END;",
+ parameters.ToArray());
+
+
+ // 鑾峰彇杈撳嚭鍙傛暟鐨勫��
+
+ var messageValue = outputMessage.Value?.ToString();
+
+ msg[0] = "0";
+ msg[1] = messageValue;
+ }
+ else
+ {
+ msg[0] = "1";
+ msg[1] = "002[" + id + "绛炬敹澶辫触锛�" + result.ErrorMsg;
+ }
+ }
+ }
+ else
+ {
+ msg[0] = "1";
+ msg[1] = $"002[{id}绛炬敹澶辫触锛岃姹傚け璐ワ紝鐘舵�佺爜锛歿response.StatusCode}";
+ }
+ }
+ }
+ catch (Exception ex)
+ {
+ msg[0] = "1";
+ msg[1] = $"002[璇锋眰澶辫触锛岀姸鎬佺爜锛歿ex.Message}";
+ }
+
+
+ //msg[0] = "1";
+ //msg[1] = responseBody;
+ return msg;
+ }
+ public async Task<string[]> getTestXKYSign()
+ {
+ var msg = new string[2];
+ //鍙戣捣璇锋眰锛岀鏀堕�佽揣鍗�
+
+ try
+ {
+ var requestData = XkyCommonParam.GetTestInit();
+
+ msg[0] = "0";
+ msg[1] = requestData.ToJsonString();
+
+ }
+ catch (Exception ex)
+ {
+ msg[0] = "1";
+ msg[1] = $"002[璇锋眰澶辫触锛岀姸鎬佺爜锛歿ex.Message}";
+ }
+
+
+ //msg[0] = "1";
+ //msg[1] = responseBody;
+ return msg;
+ }
+ /// <summary>
+ /// 鍙戝竷鎼哄浜戞敼鍠勬姤鍛�
+ /// </summary>
+ /// <param name="id"></param>
+ /// <returns></returns>
+ public async Task<string[]> SaveXkyImproveReport(string id)
+ {
+ var msg = new string[2];
+ try
+ {
+ //琛ㄥご鏁版嵁
+ string MianSql= "select " +
+ "B.SUPP_NO," +
+ "CASE WHEN REPORTTYPE = '鍑嗗叆璇勪及鏀瑰杽' THEN '1' WHEN REPORTTYPE = '鐗╂枡鍑嗗叆鏀瑰杽' THEN '2' WHEN REPORTTYPE = '缁╂晥鏀瑰杽' THEN '3' WHEN REPORTTYPE = '杩濈害浜嬮」鏀瑰杽' THEN '4' ELSE '3' END AS DEFECT_LEVEL," +
+ "(REQUIRED_DATE - TO_DATE('1970-01-01 08:00:00', 'yyyy-mm-dd hh24:mi:ss')) * 86400000 AS timestamp from MES_IQC_ABNORMAL_FEEDBACK A left join MES_SUPPLIER B on A.SUPPLIER_ID=B.ID " +
+ "where A.id = '"+id+"'";
+ //琛ㄨ韩鏁版嵁
+ string DetailSql = "select " +
+ "DEFECT_ANALYSIS," +
+ "CASE WHEN DEFECT_LEVEL = '杞诲井缂洪櫡' THEN 0 WHEN DEFECT_LEVEL = '涓ラ噸缂洪櫡' THEN 1 WHEN DEFECT_LEVEL = '鑷村懡缂洪櫡' THEN 2 ELSE 0 END AS DEFECT_LEVEL from MES_IQC_ABNORMAL_FEEDBACK_DETS " +
+ "where FID='"+id+"' order by id asc";
+ OracleSQLHelper SQLHelper = new();
+
+ DataTable MianDB= SQLHelper.ExecuteQuery(MianSql);
+ DataTable DetailDB = SQLHelper.ExecuteQuery(DetailSql);
+
+ var requestData = XkyinnerVendorParam.GetInit();
+
+ requestData.body = new BodyImproveReport
+ {
+ erpCode = "C003",
+ innerVendorCode = MianDB.Rows[0]["SUPP_NO"].ToString(),
+ reportType= int.Parse(MianDB.Rows[0]["DEFECT_LEVEL"].ToString()),
+ completionDate= Convert.ToInt64(MianDB.Rows[0]["timestamp"]) ,
+ lineList= new List<LineItem>(),
+ isPublish=1
+ };
+ for (int i = 0; i < DetailDB.Rows.Count; i++)
+ {
+ requestData.body.lineList.Add(new LineItem
+ {
+ questionDesc = DetailDB.Rows[i]["DEFECT_ANALYSIS"].ToString(),
+ questionGrade = Convert.ToInt32(DetailDB.Rows[i]["DEFECT_LEVEL"])
+ });
+ }
+ // 搴忓垪鍖栦负JSON
+ var json = JsonConvert.SerializeObject(requestData);
+
+ using (var client = new HttpClient())
+ {
+ // 璁剧疆璇锋眰鍐呭
+ var content = new StringContent(json, Encoding.UTF8,
+ "application/json");
+ // 鍙戦�丳OST璇锋眰
+ var response = await client.PostAsync(
+ "https://openapi.xiekeyun.com/improveReport/save.json",
+ content);
+ // 澶勭悊鍝嶅簲
+ if (response.IsSuccessStatusCode)
+ {
+ var responseBody =
+ await response.Content.ReadAsStringAsync();
+ var result =
+ JsonConvert.DeserializeObject<XKYApiResponse>(
+ responseBody);
+ //鎴愬姛鍚庤繑鍥炵粨鏋滐紝鍓嶅彴鍝嶅簲
+ if (result.Result == 1)
+ {
+ string updateSql = "update MES_IQC_ABNORMAL_FEEDBACK set SRM_IMPROVE_NO='"+ result.Data.irXkNo + "',REPORT_RELEASE=1 where ID='"+id+"'";
+ SQLHelper.ExecuteQuery(updateSql);
+ // 瀹氫箟杈撳嚭鍙傛暟
+ msg[0] = "0";
+ msg[1] = $"鍙戝竷鎴愬姛锛�";
+
+ }
+ else
+ {
+ // 瀹氫箟杈撳嚭鍙傛暟
+ msg[0] = "1";
+ msg[1] = $"鍙戝竷澶辫触锛亄result.ErrorMsg}";
+ }
+ }
+ else
+ {
+ msg[0] = "1";
+ msg[1] = $"{id}鍙戝竷澶辫触锛岃姹傚け璐ワ紝鐘舵�佺爜锛歿response.StatusCode}";
+ }
+ }
+ }
+ catch (Exception ex)
+ {
+ msg[0] = "1";
+ msg[1] = $"璇锋眰澶辫触锛岀姸鎬佺爜锛歿ex.Message}";
+ }
+
+ return msg;
}
+
+ /// <summary>
+ /// 鍒锋柊鎼哄浜戞敼鍠勬姤鍛婏紝鏇存柊渚涘簲鍟嗗洖澶嶄俊鎭�
+ /// </summary>
+ /// <param name="id"></param>
+ /// <returns></returns>
+ public async Task<string[]> FlushedXkyImproveReport(string id)
+ {
+ var msg = new string[2];
+ try
+ {
+ string MianSql = "";
+ if (id!=null &&id!="")
+ {
+ //鏌ヨ娌℃湁渚涘簲鍟嗗洖澶嶇殑鏀瑰杽鎶ュ憡
+ MianSql = "select SRM_IMPROVE_NO from MES_IQC_ABNORMAL_FEEDBACK where REPORT_RELEASE=1 and SRM_IMPROVE_NO is not null and SUPPLIER_REPLY_RELEASE=0 and SRM_IMPROVE_NO="+id+"";
+ }
+ else
+ {
+ //鏌ヨ娌℃湁渚涘簲鍟嗗洖澶嶇殑鏀瑰杽鎶ュ憡
+ MianSql = "select SRM_IMPROVE_NO from MES_IQC_ABNORMAL_FEEDBACK where REPORT_RELEASE=1 and SRM_IMPROVE_NO is not null and SUPPLIER_REPLY_RELEASE=0";
+ }
+
+
+ OracleSQLHelper SQLHelper = new();
+
+ DataTable MianDB = SQLHelper.ExecuteQuery(MianSql);
+ // 瀹氫箟杈撳嚭鍙傛暟
+ msg[0] = "0";
+ msg[1] = $"鍒锋柊鎴愬姛锛�";
+ for (int i = 0; i < MianDB.Rows.Count; i++)
+ {
+ var requestData = XkyFlushedrVendorParam.GetInit();
+
+ requestData.body = new BodyFlushedImproveReport
+ {
+ erpCode = "C003",
+ irXkNo = MianDB.Rows[i]["SRM_IMPROVE_NO"].ToString()
+ };
+
+ // 搴忓垪鍖栦负JSON
+ var json = JsonConvert.SerializeObject(requestData);
+
+ using (var client = new HttpClient())
+ {
+ // 璁剧疆璇锋眰鍐呭
+ var content = new StringContent(json, Encoding.UTF8,
+ "application/json");
+ // 鍙戦�丳OST璇锋眰
+ var response = await client.PostAsync(
+ "https://openapi.xiekeyun.com/improveReport/details.json",
+ content);
+ // 澶勭悊鍝嶅簲
+ if (response.IsSuccessStatusCode)
+ {
+ var responseBody =
+ await response.Content.ReadAsStringAsync();
+ var result =
+ JsonConvert.DeserializeObject<XKYApiResponse>(
+ responseBody);
+ //鎴愬姛鍚庤繑鍥炵粨鏋滐紝鍓嶅彴鍝嶅簲
+ int resultCode = 0;
+ if (result.Result == 1)
+ {
+ //鏌ヨmes绯荤粺瀵瑰簲鎼哄浜戞敼鍠勬姤鍛婄殑ID
+ string xkyIDSql = "select B.id from MES_IQC_ABNORMAL_FEEDBACK A left join MES_IQC_ABNORMAL_FEEDBACK_DETS B on A.id = B.FID where SRM_IMPROVE_NO = '"+ MianDB.Rows[i]["SRM_IMPROVE_NO"].ToString() + "' order by B.id asc";
+ string updateSql = "";
+ DataTable xkyIDDB = SQLHelper.ExecuteQuery(xkyIDSql);
+ for (int j = 0; j < result.Data.lineList.Count; j++)
+ {
+ if (result.Data.lineList[j].reasonAnalyze!=null && result.Data.lineList[j].reasonAnalyze != "")
+ {
+
+ if (resultCode==0)
+ {
+ //鏀逛緵搴斿晢鍥炲鐘舵��
+ updateSql = "update MES_IQC_ABNORMAL_FEEDBACK set SUPPLIER_REPLY_RELEASE=1 where SRM_IMPROVE_NO='"+ MianDB.Rows[i]["SRM_IMPROVE_NO"].ToString() + "'";
+ resultCode++;
+ SQLHelper.ExecuteQuery(updateSql);
+ }
+
+ //鏀规槑缁�
+ updateSql = "update MES_IQC_ABNORMAL_FEEDBACK_DETS set " +
+ "ROOT_CAUSE_ANALYSIS='"+ result.Data.lineList[j].reasonAnalyze + "'," +
+ "IMPROVEMENT_ACTION='"+ result.Data.lineList[j].correctPreventMeasure + "'," +
+ "ESTIMATED_DATE=to_date('" + ParseUnixTimestamp(result.Data.lineList[j].expectedFinishTime) + "','MM/DD/YYYY HH24:MI:SS') where id='" + xkyIDDB.Rows[j]["id"].ToString() + "'";
+ SQLHelper.ExecuteQuery(updateSql);
+ }
+ }
+
+ // 瀹氫箟杈撳嚭鍙傛暟
+ msg[0] = "0";
+ msg[1] = $"鍒锋柊鎴愬姛锛�";
+
+ }
+ else
+ {
+ // 瀹氫箟杈撳嚭鍙傛暟
+ msg[0] = "1";
+ msg[1] = $"鍒锋柊澶辫触锛亄result.ErrorMsg}";
+ }
+ }
+ else
+ {
+ msg[0] = "1";
+ msg[1] = $"{id}鍒锋柊澶辫触锛岃姹傚け璐ワ紝鐘舵�佺爜锛歿response.StatusCode}";
+ }
+ }
+ }
+
+
+ }
+ catch (Exception ex)
+ {
+ msg[0] = "1";
+ msg[1] = $"璇锋眰澶辫触锛岀姸鎬佺爜锛歿ex.Message}";
+ }
+
+ return msg;
+ }
+
+
+
+ /// <summary>
+ /// 瀹℃牳鎼哄浜戞敼鍠勬姤鍛�
+ /// </summary>
+ /// <param name="id"></param>
+ /// <returns></returns>
+ public async Task<string[]> AuditXkyImproveReport(string id)
+ {
+ var msg = new string[2];
+ try
+ {
+ string MianSql = "";
+ MianSql = "select SRM_IMPROVE_NO,CASE WHEN JUDGMENT_RESULT = '宸查��鍥�' THEN 4 WHEN JUDGMENT_RESULT = '涓嶅悎鏍�' THEN 5 WHEN JUDGMENT_RESULT = '缁撴' THEN 6 END AS status from MES_IQC_ABNORMAL_FEEDBACK where SRM_IMPROVE_NO=" + id + "";
+ //琛ㄨ韩鏁版嵁
+ string DetailSql = "select VERIFICATION_DESC, CASE WHEN VERIFICATION_RESULT = '鍚堟牸' THEN 0 WHEN VERIFICATION_RESULT = '涓嶅悎鏍�' THEN 1 END AS DEFECT_LEVEL from MES_IQC_ABNORMAL_FEEDBACK A left join MES_IQC_ABNORMAL_FEEDBACK_DETS b on A.id=B.FID where SRM_IMPROVE_NO= '" + id+"'";
+ OracleSQLHelper SQLHelper = new();
+
+ DataTable MianDB = SQLHelper.ExecuteQuery(MianSql);
+ DataTable DetailDB = SQLHelper.ExecuteQuery(DetailSql);
+ var requestData = XkyAuditVendorParam.GetInit();
+
+ requestData.body = new BodyAuditImproveReport
+ {
+ erpCode = "C003",
+ irXkNo = MianDB.Rows[0]["SRM_IMPROVE_NO"].ToString(),
+ status= Convert.ToInt32(MianDB.Rows[0]["status"]),
+ lineList=new List<AuditLineItem>()
+ };
+ for (int i = 0; i < DetailDB.Rows.Count; i++)
+ {
+ requestData.body.lineList.Add(new AuditLineItem
+ {
+ lineNo = i+1,
+ checkStatus = Convert.ToInt32(DetailDB.Rows[i]["DEFECT_LEVEL"]),
+ checkPeopleNumber = "031",
+ checkExplain = DetailDB.Rows[i]["VERIFICATION_DESC"].ToString()
+
+ });
+ }
+
+ // 搴忓垪鍖栦负JSON
+ var json = JsonConvert.SerializeObject(requestData);
+
+ using (var client = new HttpClient())
+ {
+ // 璁剧疆璇锋眰鍐呭
+ var content = new StringContent(json, Encoding.UTF8,
+ "application/json");
+ // 鍙戦�丳OST璇锋眰
+ var response = await client.PostAsync(
+ "https://openapi.xiekeyun.com/improveReport/audit.json",
+ content);
+ // 澶勭悊鍝嶅簲
+ if (response.IsSuccessStatusCode)
+ {
+ var responseBody =
+ await response.Content.ReadAsStringAsync();
+ var result =
+ JsonConvert.DeserializeObject<XKYApiResponse>(
+ responseBody);
+ //鎴愬姛鍚庤繑鍥炵粨鏋滐紝鍓嶅彴鍝嶅簲
+ int resultCode = 0;
+ if (result.Result == 1)
+ {
+
+
+ //鏀圭姸鎬�,鏀逛负瀹岀粨鐘舵��
+ string updateSql = "update MES_IQC_ABNORMAL_FEEDBACK set CLOSURE_STATUS=1,CLOSED_DATE=sysdate where SRM_IMPROVE_NO='" + id + "'";
+ SQLHelper.ExecuteQuery(updateSql);
+
+ // 瀹氫箟杈撳嚭鍙傛暟
+ msg[0] = "0";
+ msg[1] = $"瀹℃牳鎴愬姛锛�";
+
+ }
+ else
+ {
+ // 瀹氫箟杈撳嚭鍙傛暟
+ msg[0] = "1";
+ msg[1] = $"瀹℃牳澶辫触锛亄result.ErrorMsg}";
+ }
+ }
+ else
+ {
+ msg[0] = "1";
+ msg[1] = $"{id}瀹℃牳澶辫触锛岃姹傚け璐ワ紝鐘舵�佺爜锛歿response.StatusCode}";
+ }
+ }
+
+ }
+ catch (Exception ex)
+ {
+ msg[0] = "1";
+ msg[1] = $"璇锋眰澶辫触锛岀姸鎬佺爜锛歿ex.Message}";
+ }
+
+ return msg;
+ }
+
+
+
+ static DateTime ParseUnixTimestamp(string timestampStr)
+ {
+ // 灏濊瘯瑙ｆ瀽涓洪暱鏁村瀷
+ if (long.TryParse(timestampStr, out long timestamp))
+ {
+ // 鏍规嵁浣嶆暟鍒ゆ柇鍗曚綅锛堢鎴栨绉掞級
+ if (timestampStr.Length <= 10) // 绉掔骇 (10浣嶆垨鏇村皯)
+ {
+ return DateTimeOffset.FromUnixTimeSeconds(timestamp).UtcDateTime;
+ }
+ else // 姣绾�
+ {
+ return DateTimeOffset.FromUnixTimeMilliseconds(timestamp).UtcDateTime;
+ }
+ }
+ throw new FormatException("鏃犳晥鐨勬椂闂存埑鏍煎紡");
+ }
private string ExtractSubstring(string input, char startChar, char endChar)
{
@@ -677,11 +1129,19 @@
public List<MesQaItemsDetectDetail5> GetItems(string? releaseNo,
decimal? id)
{
+
+ OracleSQLHelper SQLHelper = new();
+ var sql =
+ @"update MES_QA_ITEMS_DETECT_01 set FCHECK_BEGIN_DATE=sysdate where RELEASE_NO='"+ releaseNo + "' and FCHECK_BEGIN_DATE is null";
+ SQLHelper.ExecuteQuery(sql);
+
+
var db = SqlSugarHelper.GetInstance();
- return db.Queryable<MesQaItemsDetectDetail5, MesQaItemsDetectDetail12>(
- (a, b) =>
- new JoinQueryInfos(JoinType.Left, a.Id == b.MainId))
+ return db
+ .Queryable<MesQaItemsDetectDetail5,
+ MesQaItemsDetectDetail12>((a, b) =>
+ new JoinQueryInfos(JoinType.Left, a.Id == b.MainId))
.Where((a, b) => a.ReleaseNo == releaseNo)
// .WhereIF(id > 0, (a, b) => a.Id == id)
.OrderByDescending((a, b) => a.FcheckItem)
@@ -726,12 +1186,12 @@
}
-
public DataTable getAllInspectors()
{
- OracleSQLHelper SQLHelper = new();
- var sql =string.Format(@"select a.USER_NAME label,U.FCODE value from IQC_BEFORE_FROM a JOIN SYS_USER U ON U.FID=A.SID");
- return SQLHelper.ExecuteQuery(sql);
+ OracleSQLHelper SQLHelper = new();
+ var sql =
+ @"select a.USER_NAME label,U.FCODE value from IQC_BEFORE_FROM a JOIN SYS_USER U ON U.FID=A.SID";
+ return SQLHelper.ExecuteQuery(sql);
}
@@ -800,8 +1260,8 @@
// result = "涓嶅悎鏍�";
else if (noCount >= QsItemOqcItem.FreQty)
result = "涓嶅悎鏍�";
- var useTransactionWithOracle = SqlSugarHelper.UseTransactionWithOracle(
- db =>
+ var useTransactionWithOracle =
+ SqlSugarHelper.UseTransactionWithOracle(db =>
{
var commit = 0;
commit += db.Updateable<MesQaItemsDetectDetail5>()
@@ -942,71 +1402,84 @@
public DataTable getFromInfo(string BarCode)
{
OracleSQLHelper SQLHelper = new();
- var sql = string.Format(@"select b.ID,b.LOT_NO,b.RELEASE_NO,b.FSUBMIT from MES_INV_ITEM_BARCODES A
+ var sql = string.Format(
+ @"select b.ID,b.LOT_NO,b.RELEASE_NO,b.FSUBMIT from MES_INV_ITEM_BARCODES A
left join MES_QA_ITEMS_DETECT_01 B on A.BILL_NO=b.LOT_NO and A.ITEM_ID=b.ITEM_ID
- where ITEM_BARCODE='"+ BarCode + "'");
+ where ITEM_BARCODE='" + BarCode + "'and b.ID is not null");
return SQLHelper.ExecuteQuery(sql);
}
+ public int getFromMJCount(string BarCode)
+ {
+ OracleSQLHelper SQLHelper = new();
+ var sql = string.Format(
+ @"select count(*) count from MES_INV_ITEM_BARCODES A
+ left join MES_INV_ITEM_ARN_DETAIL B on A.BILL_NO=b.CBILL_NO and A.ITEM_ID=b.ITEM_ID
+ where ITEM_BARCODE='"+ BarCode + "' and CHECK_STATES='鍏嶆'");
+ return Convert.ToInt32(SQLHelper.ExecuteQuery(sql).Rows[0]["count"]);
+ }
+
public DataTable getImgBDlist(string id)
{
OracleSQLHelper SQLHelper = new();
- var sql = string.Format(@"select id,FID,IMAGE_DATA from MES_QS_IMAGE where FID="+id+"");
+ var sql =
+ string.Format(
+ @"select id,FID,IMAGE_DATA from MES_QS_IMAGE where FID=" + id +
+ "");
return SQLHelper.ExecuteQuery(sql);
}
- /// <summary>
- /// 涓�鑷存�ч」鐩�
- /// </summary>
- public class Component
- {
- public string Name { get; set; }
- public List<string> Specs { get; set; }
- public List<string> Manufacturers { get; set; }
- public List<string> Id { get; set; }
- public int SelectedSpec { get; set; }
- public int SelectedMfg { get; set; }
- }
+
public List<Component> getYzxBDlist(string id)
{
OracleSQLHelper SQLHelper = new();
//鏌ュ厓鍣ㄤ欢
- var sql1 = string.Format(@"select ITEMNAME from MES_IQC_CONSISTENCY_ck where PID='"+id+"' group by ITEMNAME order by ITEMNAME");
+ //var sql1 =
+ // string.Format(
+ // @"select ITEMNAME from MES_IQC_CONSISTENCY_ck where PID='" +
+ // id + "' group by ITEMNAME order by ITEMNAME");
+
+ var sql1 =
+ string.Format(
+ @"select CASE WHEN max(MULTI_SELECT) is null THEN ''ELSE '銆�'||max(MULTI_SELECT)||'銆�' END as A,ITEMNAME as ITEMNAME from MES_IQC_CONSISTENCY_ck where PID='"+id+"' group by ITEMNAME order by ITEMNAME");
//鏌ユ槑缁�
- var sql2 = string.Format(@"select * from MES_IQC_CONSISTENCY_ck where PID='"+id+"' order by ITEMNAME,ITEMMODE,SUPPNAME");
- DataTable dataTable1= SQLHelper.ExecuteQuery(sql1);
- DataTable dataTable2 = SQLHelper.ExecuteQuery(sql2);
- List<Component> Components = new List<Component>();
+ var sql2 =
+ string.Format(@"select * from MES_IQC_CONSISTENCY_ck where PID='" +
+ id + "' order by ITEMNAME,ITEMMODE,SUPPNAME");
+ var dataTable1 = SQLHelper.ExecuteQuery(sql1);
+ var dataTable2 = SQLHelper.ExecuteQuery(sql2);
+ var Components = new List<Component>();
-
- for (int i = 0; i <dataTable1.Rows.Count; i++)
+ for (var i = 0; i < dataTable1.Rows.Count; i++)
{
- Component component = new Component();
- component.Name= dataTable1.Rows[i]["ITEMNAME"].ToString();
- component.Specs= new List<string>();
+ var component = new Component();
+ component.Name = dataTable1.Rows[i]["A"].ToString()+ dataTable1.Rows[i]["ITEMNAME"].ToString();
+ component.Specs = new List<string>();
component.Manufacturers = new List<string>();
component.Id = new List<string>();
component.SelectedSpec = -1;
component.SelectedMfg = -1;
- int index = 0;
- for (int j = 0; j < dataTable2.Rows.Count; j++)
- {
-
- if (dataTable2.Rows[j]["ITEMNAME"].ToString()== dataTable1.Rows[i]["ITEMNAME"].ToString())
+ var index = 0;
+ for (var j = 0; j < dataTable2.Rows.Count; j++)
+ if (dataTable2.Rows[j]["ITEMNAME"].ToString() ==
+ dataTable1.Rows[i]["ITEMNAME"].ToString())
{
- component.Specs.Add(dataTable2.Rows[j]["ITEMMODE"].ToString());
- component.Manufacturers.Add(dataTable2.Rows[j]["SUPPNAME"].ToString());
+ component.Specs.Add(dataTable2.Rows[j]["ITEMMODE"]
+ .ToString());
+ component.Manufacturers.Add(dataTable2.Rows[j]["SUPPNAME"]
+ .ToString());
component.Id.Add(dataTable2.Rows[j]["ID"].ToString());
- if (dataTable2.Rows[j]["ISCHACK"].ToString()=="1")
+ if (dataTable2.Rows[j]["ISCHACK"].ToString() == "1")
{
component.SelectedSpec = index;
component.SelectedMfg = index;
}
+
index++;
}
- }
Components.Add(component);
}
+
return Components;
}
@@ -1014,66 +1487,150 @@
{
OracleSQLHelper SQLHelper = new();
//鏌ヤ笉鑹弿杩�
- var sql1 = string.Format(@"select DEFECT_NAME
+ var sql1 = @"select DEFECT_NAME
from MES_DEFECT_CODE A
- left join MES_DEFECT_TYPE X ON X.TYPE_NO = A.DEFECT_SORT AND X.COMPANY = A.COMPANY AND X.FACTORY = A.FACTORY");
-
+ left join MES_DEFECT_TYPE X ON X.TYPE_NO = A.DEFECT_SORT AND X.COMPANY = A.COMPANY AND X.FACTORY = A.FACTORY";
+
return SQLHelper.ExecuteQuery(sql1);
}
+
public DataTable getBlmsItem(string id)
{
OracleSQLHelper SQLHelper = new();
//鏌ヤ笉鑹弿杩�
- var sql1 = string.Format(@"select FCHECK_ITEM,FUNIT from mes_qa_items_detect_detail5 f where RELEASE_NO='"+id+"' and FUNIT is not null order by FCHECK_ITEM");
+ var sql1 = string.Format(
+ @"select FCHECK_ITEM,FUNIT from mes_qa_items_detect_detail5 f where RELEASE_NO='" +
+ id + "' and FUNIT is not null order by FCHECK_ITEM");
return SQLHelper.ExecuteQuery(sql1);
}
- public void saveYzxBDlist(string id,DataTable DB)
+
+ //public void saveYzxBDlist(string id, DataTable DB)
+ //{
+ // OracleSQLHelper SQLHelper = new();
+ // //鍏堟妸缁撴灉娓呯┖
+ // var sql1 =
+ // string.Format(
+ // @"update MES_IQC_CONSISTENCY_ck set ISCHACK=0 where PID='" +
+ // id + "' ");
+ // SQLHelper.ExecuteQuery(sql1);
+ // var rowId = "";
+ // for (var i = 0; i < DB.Rows.Count; i++)
+ // rowId += "'" + DB.Rows[i]["id"] + "',";
+ // rowId = rowId.Substring(0, rowId.Length - 1);
+
+
+ // //淇敼缁撴灉
+ // var sql2 =
+ // string.Format(
+ // @"update MES_IQC_CONSISTENCY_ck set ISCHACK=1 where PID='" +
+ // id + "'and id in(" + rowId + ") ");
+ // SQLHelper.ExecuteQuery(sql2);
+ //}
+
+ public void saveYzxBDlist(string id, DataTable DB)
{
- OracleSQLHelper SQLHelper = new();
- //鍏堟妸缁撴灉娓呯┖
- var sql1 = string.Format(@"update MES_IQC_CONSISTENCY_ck set ISCHACK=0 where PID='"+ id + "' ");
- SQLHelper.ExecuteQuery(sql1);
- string rowId = "";
- for (int i = 0; i < DB.Rows.Count; i++)
+ var sqlHelper = new OracleSQLHelper();
+
+ using (var connection = new OracleConnection(AppsettingsUtility.Settings.DataBaseConn))
{
- rowId += "'" + DB.Rows[i]["id"] + "',";
+ connection.Open();
+ using (var transaction = connection.BeginTransaction())
+ {
+ try
+ {
+ // 1. 娓呯┖ ISCHACK
+ var sql1 = @"UPDATE MES_IQC_CONSISTENCY_ck
+ SET ISCHACK = 0
+ WHERE PID = :pid";
+
+ using (var cmd1 = new OracleCommand(sql1, connection))
+ {
+ cmd1.Transaction = transaction;
+ cmd1.Parameters.Add(new OracleParameter(":pid", id));
+ cmd1.ExecuteNonQuery();
+ }
+
+ // 2. 濡傛灉 DataTable 閲屾湁瑕佹洿鏂扮殑 id
+ if (DB != null && DB.Rows.Count > 0)
+ {
+ // 鎷兼帴 in 鏉′欢锛堝弬鏁板寲锛�
+ var inParams = new List<string>();
+ var parameters = new List<OracleParameter>
+ {
+ new OracleParameter(":pid", id)
+ };
+
+ for (int i = 0; i < DB.Rows.Count; i++)
+ {
+ string paramName = ":id" + i;
+ inParams.Add(paramName);
+ parameters.Add(new OracleParameter(paramName, DB.Rows[i]["id"]));
+ }
+
+ var sql2 = $@"
+ UPDATE MES_IQC_CONSISTENCY_ck
+ SET ISCHACK = 1
+ WHERE PID = :pid
+ AND id IN ({string.Join(",", inParams)})";
+
+ using (var cmd2 = new OracleCommand(sql2, connection))
+ {
+ cmd2.Transaction = transaction;
+ cmd2.Parameters.AddRange(parameters.ToArray());
+ cmd2.ExecuteNonQuery();
+ }
+ }
+
+ // 鍏ㄩ儴鎴愬姛锛屾彁浜�
+ transaction.Commit();
+ }
+ catch (Exception ex)
+ {
+ // 鍑洪敊鍥炴粴
+ transaction.Rollback();
+ throw new Exception("鎵ц saveYzxBDlist 鍑洪敊: " + ex.Message, ex);
+ }
+ }
}
- rowId = rowId.Substring(0, rowId.Length - 1);
-
-
- //淇敼缁撴灉
- var sql2 = string.Format(@"update MES_IQC_CONSISTENCY_ck set ISCHACK=1 where PID='" + id + "'and id in("+ rowId + ") ");
- SQLHelper.ExecuteQuery(sql2);
-
}
+
public string[] YzxImgVerify(string id)
{
- string[] msgStr = new string[2];
-
+ var msgStr = new string[2];
+
OracleSQLHelper SQLHelper = new();
//淇敼缁撴灉
- var sql2 = string.Format(@"select A.ITEMNAME from ( select 888||min(id) id,ITEMNAME from MES_IQC_CONSISTENCY_CK where pid='"+ id + "' group by ITEMNAME) A " +
- "left join MES_QS_IMAGE b on a.id=b.fid where B.id is null order by ITEMNAME");
- DataTable db= SQLHelper.ExecuteQuery(sql2);
+ //var sql2 = string.Format(
+ // @"select A.ITEMNAME from ( select 888||min(id) id,ITEMNAME from MES_IQC_CONSISTENCY_CK where pid='" +
+ // id + "' group by ITEMNAME) A " +
+ // "left join MES_QS_IMAGE b on a.id=b.fid where B.id is null order by ITEMNAME");
+
+
+ var sql2 = string.Format(
+ @"select A.ITEMNAME from ( select 888||min(id) id,ITEMNAME from MES_IQC_CONSISTENCY_CK where pid='"+id.ToString()+ "' and ITEMNAME not in(select ITEMNAME from MES_IQC_CONSISTENCY_CK where PID='"+id.ToString()+"' and MULTI_SELECT is not null)" +
+ "group by ITEMNAME) A" +
+ " left join MES_QS_IMAGE b on a.id=b.fid where B.id is null" +
+ " union" +
+ " select '鍒嗙粍锛�' || MULTI_SELECT as ITEMNAME from MES_IQC_CONSISTENCY_CK where pid = '"+id.ToString()+ "' and MULTI_SELECT is not null and MULTI_SELECT not in(select A.MULTI_SELECT as ITEMNAME from (select 888 || min(id) id, MULTI_SELECT from MES_IQC_CONSISTENCY_CK where pid = '"+id.ToString()+ "' and MULTI_SELECT is not null group by MULTI_SELECT,ITEMNAME) A left join MES_QS_IMAGE b on a.id = b.fid where B.id is not null) group by MULTI_SELECT");
+
+ var db = SQLHelper.ExecuteQuery(sql2);
if (db.Rows.Count > 0)
{
msgStr[1] = "鍏冨櫒浠讹細";
- for (int i = 0; i < db.Rows.Count; i++)
- {
- msgStr[1] += db.Rows[i]["ITEMNAME"]+ ",";
- }
+ for (var i = 0; i < db.Rows.Count; i++)
+ msgStr[1] += db.Rows[i]["ITEMNAME"] + ",";
msgStr[1] += "鏈畬鎴愬浘鐗囦笂浼狅紝璇蜂笂浼狅紒";
msgStr[0] = "1";
}
- else
+ else
{
msgStr[0] = "0";
msgStr[1] = "ok";
}
- return msgStr;
+ return msgStr;
}
public int UpdateQSItemDetail(MesQaItemsDetectDetail12 detail)
@@ -1142,8 +1699,8 @@
return SqlSugarHelper.UseTransactionWithOracle(db =>
{
return db.Updateable<MesQaItemsDetectDetail5>()
- .SetColumns(it =>
- it.Funit == dto.Remarks) //SetColumns鏄彲浠ュ彔鍔犵殑 鍐�2涓氨2涓瓧娈佃祴鍊�
+ .SetColumns(it =>
+ it.Funit == dto.Remarks) //SetColumns鏄彲浠ュ彔鍔犵殑 鍐�2涓氨2涓瓧娈佃祴鍊�
.Where(it => it.Id == dto.pid)
.ExecuteCommand();
});
@@ -1212,11 +1769,10 @@
// 鑾峰彇杈撳嚭鍙傛暟鐨勫��
var resultValue = outputResult.Value?.ToString();
var messageValue = outputMessage.Value?.ToString();
- string[] msg = new string[2];
+ var msg = new string[2];
msg[0] = resultValue;
msg[1] = messageValue;
return msg;
-
}
catch (Exception ex)
{
@@ -1254,6 +1810,381 @@
}
/// <summary>
+ /// 鎼哄浜戝瘑閽�
+ /// </summary>
+ public class DataAcquisitionConfiguration
+ {
+ //娴嬭瘯鐜
+ public const string TEST_COMPANY_CODE = "55958795";
+ public const string TEST_APP_KEY = "ab2d86b6dffabcc81dca6855c727c246";
+
+ public const string TEST_APP_SECRET =
+ "01b17babe2a96d5ebd802e67709f33d1";
+
+ public const string TEST_ERP_CODE = "Z106";
+
+ //姝ｅ紡鐜
+ public const string COMPANY_CODE = "72505985";
+ public const string APP_KEY = "a2866f03bb7f76387bfb1a98001f0e31";
+ public const string APP_SECRET = "f13bd1bcb130f0090ed92dc021e5f4e1";
+ public const string ERP_CODE = "Z106";
+ }
+
+ [Serializable]
+ public class ApiCommonParam
+ {
+ //鍙戞斁缁欑敤鎴风殑Key
+ public string appKey { get; set; }
+
+ //鎺ュ彛鐗堟湰
+ public string version { get; set; }
+
+ //鏁版嵁鎵�灞炲叕鍙哥紪鐮�
+ public string ownerCompanyCode { get; set; }
+
+ //鎿嶄綔鑰呮墍灞炲叕鍙哥紪鐮�
+ public string operateCompanyCode { get; set; }
+
+ //绛惧悕
+ public string sign { get; set; }
+
+ //鏃堕棿鎴�
+ public long? timestamps { get; set; }
+ ////鎵╁睍瀛楁
+ //public object Reserver { get; set; }
+ }
+
+ [Serializable]
+ public class BodyParam
+ {
+ public string erpCode { get; set; }
+ public string dnXkNo { get; set; }
+ }
+ [Serializable]
+ public class BodyFlushedImproveReport
+ {
+ public string erpCode { get; set; }
+ public string irXkNo { get; set; }
+ }
+ [Serializable]
+ public class BodyAuditImproveReport
+ {
+ public string erpCode { get; set; }
+ public string irXkNo { get; set; }
+ public int status { get; set; }
+ /// <summary>
+ /// 鍗曡韩鍒楄〃
+ /// </summary>
+ public List<AuditLineItem> lineList { get; set; }
+
+ }
+ public class AuditLineItem
+ {
+ /// <summary>
+ /// 椤规
+ /// </summary>
+ public int lineNo { get; set; }
+ /// <summary>
+ /// 妫�鏍哥粨鏋� 0:鍚堟牸,1:涓嶅悎鏍�
+ /// </summary>
+ public int checkStatus { get; set; }
+ /// <summary>
+ /// 妫�鏍镐汉宸ュ彿
+ /// </summary>
+ public string checkExplain { get; set; }
+ /// <summary>
+ /// 妫�鏍歌鏄�
+ /// </summary>
+ public string checkPeopleNumber { get; set; }
+ }
+
+ [Serializable]
+ public class BodyImproveReport
+ {
+ /// <summary>
+ /// 璇锋眰鑰呯敤鎴稥RP甯愬彿
+ /// </summary>
+ public string erpCode { get; set; }
+ /// <summary>
+ /// 鍐呴儴渚涘簲鍟嗙紪鐮�
+ /// </summary>
+ public string innerVendorCode { get; set; }
+ /// <summary>
+ /// 鎶ュ憡绫诲瀷:1 鍑嗗叆璇勪及鏀瑰杽,2 鐗╂枡鍑嗗叆鏀瑰杽,3 缁╂晥鏀瑰杽,4 杩濈害浜嬮」鏀瑰杽
+ /// </summary>
+ public int reportType { get; set; } // 鏍规嵁JSON鍊间娇鐢╥nt
+ /// <summary>
+ /// 瀹屾垚鏃ユ湡(姣鏃堕棿鎴�)
+ /// </summary>
+ public long completionDate { get; set; }
+
+ // 鏃ユ湡鎵╁睍瀛楁锛堝瓧绗︿覆鏍煎紡锛�
+ public string platformExtendN01 { get; set; }
+
+ public string platformExtendN02 { get; set; }
+
+ public string platformExtendN03 { get; set; }
+ /// <summary>
+ /// 鏄惁鑷姩鍙戝竷 0:鍚� 1:鏄� 榛樿锛氬惁
+ /// </summary>
+ public int isPublish { get; set; } // 鏍规嵁JSON鍊间娇鐢╥nt
+ /// <summary>
+ /// 鍒╂鼎涓績/宸ュ巶缂栫爜
+ /// </summary>
+ public string profitCenterCode { get; set; }
+ /// <summary>
+ /// 鍒╂鼎涓績/宸ュ巶鍚嶇О
+ /// </summary>
+ public string profitCenterName { get; set; }
+ /// <summary>
+ /// 鍗曡韩鍒楄〃
+ /// </summary>
+ public List<LineItem> lineList { get; set; }
+ }
+
+ [Serializable]
+ public class LineItem
+ {
+ /// <summary>
+ /// 闂鎻忚堪
+ /// </summary>
+ public string questionDesc { get; set; }
+ /// <summary>
+ /// 闂绛夌骇 0:娆¤,1:閲嶈,2:鑷村懡
+ /// </summary>
+ public int questionGrade { get; set; } // 鏍规嵁JSON鍊间娇鐢╥nt
+ }
+ public class XkyCommonParam
+ {
+ public ApiCommonParam commonParam { get; set; }
+ public BodyParam body { get; set; }
+
+ public static XkyCommonParam GetInit()
+ {
+ var apiParam = new ApiCommonParam
+ {
+ //// 鍙戞惡瀹簯鎻愪緵鐨刟ppKey
+ appKey = (configuration["AppSettings:XKYamgylchedd"] == "1") ? DataAcquisitionConfiguration.APP_KEY : DataAcquisitionConfiguration.TEST_APP_KEY,
+ // 鎺ュ彛鐗堟湰
+ version = "1.0",
+ // 鎿嶄綔鑰呮墍灞炲叕鍙哥紪鐮�
+ operateCompanyCode = (configuration["AppSettings:XKYamgylchedd"] == "1") ? DataAcquisitionConfiguration.COMPANY_CODE : DataAcquisitionConfiguration.TEST_COMPANY_CODE,
+ // 鏁版嵁鎵�灞炲叕鍙哥紪鐮侊紝闈為泦鍥㈠叕鍙搁粯璁よ祴鍊间负鎿嶄綔鍏徃
+ ownerCompanyCode = (configuration["AppSettings:XKYamgylchedd"] == "1") ? DataAcquisitionConfiguration.COMPANY_CODE : DataAcquisitionConfiguration.TEST_COMPANY_CODE,
+ // 褰撳墠鏃堕棿瀵瑰簲鐨勬椂闂存埑锛堢鏁帮級
+ timestamps = DateTimeOffset.UtcNow.ToUnixTimeSeconds()
+ };
+
+
+ var appSecret = DataAcquisitionConfiguration.APP_SECRET;
+
+ // 鐢熸垚绛惧悕
+ var sign = BuildCurrentSign(
+ JsonConvert.SerializeObject(apiParam),
+ appSecret);
+ apiParam.sign = sign;
+
+ return new XkyCommonParam
+ {
+ commonParam = apiParam
+ };
+ }
+ public static XkyCommonParam GetTestInit()
+ {
+ var apiParam = new ApiCommonParam
+ {
+ //// 鍙戞惡瀹簯鎻愪緵鐨刟ppKey
+ appKey = (configuration["AppSettings:XKYamgylchedd"] == "1") ? DataAcquisitionConfiguration.APP_KEY : DataAcquisitionConfiguration.TEST_APP_KEY,
+ // 鎺ュ彛鐗堟湰
+ version = "1.0",
+ // 鎿嶄綔鑰呮墍灞炲叕鍙哥紪鐮�
+ operateCompanyCode = (configuration["AppSettings:XKYamgylchedd"] == "1") ? DataAcquisitionConfiguration.COMPANY_CODE : DataAcquisitionConfiguration.TEST_COMPANY_CODE,
+ // 鏁版嵁鎵�灞炲叕鍙哥紪鐮侊紝闈為泦鍥㈠叕鍙搁粯璁よ祴鍊间负鎿嶄綔鍏徃
+ ownerCompanyCode = (configuration["AppSettings:XKYamgylchedd"] == "1") ? DataAcquisitionConfiguration.COMPANY_CODE : DataAcquisitionConfiguration.TEST_COMPANY_CODE,
+ // 褰撳墠鏃堕棿瀵瑰簲鐨勬椂闂存埑锛堢鏁帮級
+ timestamps = DateTimeOffset.UtcNow.ToUnixTimeSeconds()
+ };
+
+
+ var appSecret = DataAcquisitionConfiguration.TEST_APP_SECRET;
+
+ // 鐢熸垚绛惧悕
+ var sign = BuildCurrentSign(
+ JsonConvert.SerializeObject(apiParam),
+ appSecret);
+ apiParam.sign = sign;
+
+ return new XkyCommonParam
+ {
+ commonParam = apiParam
+ };
+ }
+ }
+
+ public class XkyinnerVendorParam
+ {
+ public ApiCommonParam commonParam { get; set; }
+ public BodyImproveReport body { get; set; }
+
+ public static XkyinnerVendorParam GetInit()
+ {
+
+ var apiParam = new ApiCommonParam
+ {
+
+ //// 鍙戞惡瀹簯鎻愪緵鐨刟ppKey
+ appKey = (configuration["AppSettings:XKYamgylchedd"]=="1")?DataAcquisitionConfiguration.APP_KEY: DataAcquisitionConfiguration.TEST_APP_KEY,
+ // 鎺ュ彛鐗堟湰
+ version = "1.0",
+ // 鎿嶄綔鑰呮墍灞炲叕鍙哥紪鐮�
+ operateCompanyCode = (configuration["AppSettings:XKYamgylchedd"] == "1")?DataAcquisitionConfiguration.COMPANY_CODE:DataAcquisitionConfiguration.TEST_COMPANY_CODE,
+ // 鏁版嵁鎵�灞炲叕鍙哥紪鐮侊紝闈為泦鍥㈠叕鍙搁粯璁よ祴鍊间负鎿嶄綔鍏徃
+ ownerCompanyCode = (configuration["AppSettings:XKYamgylchedd"] == "1")?DataAcquisitionConfiguration.COMPANY_CODE: DataAcquisitionConfiguration.TEST_COMPANY_CODE,
+ // 褰撳墠鏃堕棿瀵瑰簲鐨勬椂闂存埑锛堢鏁帮級
+ timestamps = DateTimeOffset.UtcNow.ToUnixTimeSeconds()
+
+ // 鍙戞惡瀹簯鎻愪緵鐨刟ppKey
+ //appKey = DataAcquisitionConfiguration.TEST_APP_KEY,
+ //// 鎺ュ彛鐗堟湰
+ //version = "1.0",
+ //// 鎿嶄綔鑰呮墍灞炲叕鍙哥紪鐮�
+ //operateCompanyCode = DataAcquisitionConfiguration.TEST_COMPANY_CODE,
+ //// 鏁版嵁鎵�灞炲叕鍙哥紪鐮侊紝闈為泦鍥㈠叕鍙搁粯璁よ祴鍊间负鎿嶄綔鍏徃
+ //ownerCompanyCode = DataAcquisitionConfiguration.TEST_COMPANY_CODE,
+ //// 褰撳墠鏃堕棿瀵瑰簲鐨勬椂闂存埑锛堢鏁帮級
+ //timestamps = DateTimeOffset.UtcNow.ToUnixTimeSeconds()
+ };
+
+
+ // var appSecret = DataAcquisitionConfiguration.APP_SECRET;
+ var appSecret = DataAcquisitionConfiguration.TEST_APP_SECRET;
+
+ // 鐢熸垚绛惧悕
+ var sign = BuildCurrentSign(
+ JsonConvert.SerializeObject(apiParam),
+ appSecret);
+ apiParam.sign = sign;
+
+ return new XkyinnerVendorParam
+ {
+ commonParam = apiParam
+ };
+ }
+
+ }
+ public class XkyFlushedrVendorParam
+ {
+ public ApiCommonParam commonParam { get; set; }
+ public BodyFlushedImproveReport body { get; set; }
+
+ public static XkyFlushedrVendorParam GetInit()
+ {
+ var apiParam = new ApiCommonParam
+ {
+ //// 鍙戞惡瀹簯鎻愪緵鐨刟ppKey
+ appKey = (configuration["AppSettings:XKYamgylchedd"] == "1") ? DataAcquisitionConfiguration.APP_KEY : DataAcquisitionConfiguration.TEST_APP_KEY,
+ // 鎺ュ彛鐗堟湰
+ version = "1.0",
+ // 鎿嶄綔鑰呮墍灞炲叕鍙哥紪鐮�
+ operateCompanyCode = (configuration["AppSettings:XKYamgylchedd"] == "1") ? DataAcquisitionConfiguration.COMPANY_CODE : DataAcquisitionConfiguration.TEST_COMPANY_CODE,
+ // 鏁版嵁鎵�灞炲叕鍙哥紪鐮侊紝闈為泦鍥㈠叕鍙搁粯璁よ祴鍊间负鎿嶄綔鍏徃
+ ownerCompanyCode = (configuration["AppSettings:XKYamgylchedd"] == "1") ? DataAcquisitionConfiguration.COMPANY_CODE : DataAcquisitionConfiguration.TEST_COMPANY_CODE,
+ // 褰撳墠鏃堕棿瀵瑰簲鐨勬椂闂存埑锛堢鏁帮級
+ timestamps = DateTimeOffset.UtcNow.ToUnixTimeSeconds()
+
+ // 鍙戞惡瀹簯鎻愪緵鐨刟ppKey
+ //appKey = DataAcquisitionConfiguration.TEST_APP_KEY,
+ //// 鎺ュ彛鐗堟湰
+ //version = "1.0",
+ //// 鎿嶄綔鑰呮墍灞炲叕鍙哥紪鐮�
+ //operateCompanyCode = DataAcquisitionConfiguration.TEST_COMPANY_CODE,
+ //// 鏁版嵁鎵�灞炲叕鍙哥紪鐮侊紝闈為泦鍥㈠叕鍙搁粯璁よ祴鍊间负鎿嶄綔鍏徃
+ //ownerCompanyCode = DataAcquisitionConfiguration.TEST_COMPANY_CODE,
+ //// 褰撳墠鏃堕棿瀵瑰簲鐨勬椂闂存埑锛堢鏁帮級
+ //timestamps = DateTimeOffset.UtcNow.ToUnixTimeSeconds()
+ };
+
+
+ // var appSecret = DataAcquisitionConfiguration.APP_SECRET;
+ var appSecret = DataAcquisitionConfiguration.TEST_APP_SECRET;
+
+ // 鐢熸垚绛惧悕
+ var sign = BuildCurrentSign(
+ JsonConvert.SerializeObject(apiParam),
+ appSecret);
+ apiParam.sign = sign;
+
+ return new XkyFlushedrVendorParam
+ {
+ commonParam = apiParam
+ };
+ }
+
+ }
+ public class XkyAuditVendorParam
+ {
+ public ApiCommonParam commonParam { get; set; }
+ public BodyAuditImproveReport body { get; set; }
+
+ public static XkyAuditVendorParam GetInit()
+ {
+ var apiParam = new ApiCommonParam
+ {
+ //// 鍙戞惡瀹簯鎻愪緵鐨刟ppKey
+ appKey = (configuration["AppSettings:XKYamgylchedd"] == "1") ? DataAcquisitionConfiguration.APP_KEY : DataAcquisitionConfiguration.TEST_APP_KEY,
+ // 鎺ュ彛鐗堟湰
+ version = "1.0",
+ // 鎿嶄綔鑰呮墍灞炲叕鍙哥紪鐮�
+ operateCompanyCode = (configuration["AppSettings:XKYamgylchedd"] == "1") ? DataAcquisitionConfiguration.COMPANY_CODE : DataAcquisitionConfiguration.TEST_COMPANY_CODE,
+ // 鏁版嵁鎵�灞炲叕鍙哥紪鐮侊紝闈為泦鍥㈠叕鍙搁粯璁よ祴鍊间负鎿嶄綔鍏徃
+ ownerCompanyCode = (configuration["AppSettings:XKYamgylchedd"] == "1") ? DataAcquisitionConfiguration.COMPANY_CODE : DataAcquisitionConfiguration.TEST_COMPANY_CODE,
+ // 褰撳墠鏃堕棿瀵瑰簲鐨勬椂闂存埑锛堢鏁帮級
+ timestamps = DateTimeOffset.UtcNow.ToUnixTimeSeconds()
+
+ // 鍙戞惡瀹簯鎻愪緵鐨刟ppKey
+ //appKey = DataAcquisitionConfiguration.TEST_APP_KEY,
+ //// 鎺ュ彛鐗堟湰
+ //version = "1.0",
+ //// 鎿嶄綔鑰呮墍灞炲叕鍙哥紪鐮�
+ //operateCompanyCode = DataAcquisitionConfiguration.TEST_COMPANY_CODE,
+ //// 鏁版嵁鎵�灞炲叕鍙哥紪鐮侊紝闈為泦鍥㈠叕鍙搁粯璁よ祴鍊间负鎿嶄綔鍏徃
+ //ownerCompanyCode = DataAcquisitionConfiguration.TEST_COMPANY_CODE,
+ //// 褰撳墠鏃堕棿瀵瑰簲鐨勬椂闂存埑锛堢鏁帮級
+ //timestamps = DateTimeOffset.UtcNow.ToUnixTimeSeconds()
+ };
+
+
+ // var appSecret = DataAcquisitionConfiguration.APP_SECRET;
+ var appSecret = DataAcquisitionConfiguration.TEST_APP_SECRET;
+
+ // 鐢熸垚绛惧悕
+ var sign = BuildCurrentSign(
+ JsonConvert.SerializeObject(apiParam),
+ appSecret);
+ apiParam.sign = sign;
+
+ return new XkyAuditVendorParam
+ {
+ commonParam = apiParam
+ };
+ }
+
+ }
+
+ /// <summary>
+ /// 涓�鑷存�ч」鐩�
+ /// </summary>
+ public class Component
+ {
+ public string Name { get; set; }
+ public List<string> Specs { get; set; }
+ public List<string> Manufacturers { get; set; }
+ public List<string> Id { get; set; }
+ public int SelectedSpec { get; set; }
+ public int SelectedMfg { get; set; }
+ }
+
+ /// <summary>
/// 鏂欏彿鍥剧焊鎺ュ彛杩斿洖瀵硅薄
/// </summary>
public class ApiResponse
@@ -1266,27 +2197,77 @@
[JsonProperty("totalCount")] public int TotalCount { get; set; }
}
+
/// <summary>
- /// 鎼哄浜戞帴鍙ｈ繑鍥炲璞�
+ /// 鎼哄浜戞帴鍙ｈ繑鍥炲璞�
/// </summary>
public class XKYApiResponse
{
- [JsonProperty("errorCode")]
- public string ErrorCode { get; set; }
+ [JsonProperty("errorCode")] public string ErrorCode { get; set; }
- [JsonProperty("errorMsg")]
- public string ErrorMsg { get; set; }
+ [JsonProperty("errorMsg")] public string ErrorMsg { get; set; }
- [JsonProperty("result")]
- public int Result { get; set; }
+ [JsonProperty("result")] public int Result { get; set; }
- [JsonProperty("data")]
- public object Data { get; set; }
+ [JsonProperty("data")] public Root Data { get; set; }
- [JsonProperty("curServerTime")]
- public long CurServerTime { get; set; }
+ [JsonProperty("curServerTime")] public long CurServerTime { get; set; }
// 濡傛灉闇�瑕佹椂闂磋浆鎹㈠彲浠ユ坊鍔犺繖涓睘鎬�
- public DateTime ServerTime => DateTimeOffset.FromUnixTimeMilliseconds(CurServerTime).DateTime;
+ public DateTime ServerTime => DateTimeOffset
+ .FromUnixTimeMilliseconds(CurServerTime).DateTime;
+ }
+ public class Root
+ {
+ /// <summary>
+ ///
+ /// </summary>
+ public string irXkNo { get; set; }
+
+ public List<LineListItem> lineList { get; set; }
+
+ }
+ public class LineListItem
+ {
+ /// <summary>
+ /// 椤规鍙�
+ /// </summary>
+ public int lineNo { get; set; }
+ /// <summary>
+ /// 闂鎻忚堪
+ /// </summary>
+ public string questionDesc { get; set; }
+ /// <summary>
+ /// 闂绛夌骇 0:娆¤,1:閲嶈,2:鑷村懡
+ /// </summary>
+ public int questionGrade { get; set; }
+ /// <summary>
+ /// 鍘熷洜鍒嗘瀽
+ /// </summary>
+ public string reasonAnalyze { get; set; }
+ /// <summary>
+ /// 绾犳棰勯槻鎺柦
+ /// </summary>
+ public string correctPreventMeasure { get; set; }
+ /// <summary>
+ /// 璐熻矗浜�
+ /// </summary>
+ public string principal { get; set; }
+ /// <summary>
+ /// 棰勮瀹屾垚鏃堕棿瀵瑰簲鐨勬椂闂存埑
+ /// </summary>
+ public string expectedFinishTime { get; set; }
+ /// <summary>
+ /// 妫�鏍歌鏄�
+ /// </summary>
+ public string checkExplain { get; set; }
+ /// <summary>
+ /// 妫�鏍镐汉濮撳悕
+ /// </summary>
+ public string checkPeopleName { get; set; }
+ /// <summary>
+ /// 妫�鏍哥粨鏋� 0:鍚堟牸,1:涓嶅悎鏍�
+ /// </summary>
+ public string checkStatus { get; set; }
}
}
\ No newline at end of file
--
Gitblit v1.9.3