华远项目初稿:
炬森VRS内层检验结果上传接口
炬森VRS外层获取datamapping接口
炬森VRS外层检验结果上传接口
AVI获取datamapping接口
AVI检验结果上传接口
电测获取datamapping接口
电测检验结果上传接口
激光割获取datamapping接口
80个文件已修改
1个文件已添加
788 ■■■■■ 已修改文件
BLL/bin/Release/BLL.dll 补丁 | 查看 | 原始文档 | blame | 历史
BLL/bin/Release/BLL.pdb 补丁 | 查看 | 原始文档 | blame | 历史
BLL/bin/Release/DAL.dll 补丁 | 查看 | 原始文档 | blame | 历史
BLL/bin/Release/DAL.pdb 补丁 | 查看 | 原始文档 | blame | 历史
BLL/bin/Release/DBUtility.dll 补丁 | 查看 | 原始文档 | blame | 历史
BLL/bin/Release/DBUtility.pdb 补丁 | 查看 | 原始文档 | blame | 历史
BLL/bin/Release/Model.dll 补丁 | 查看 | 原始文档 | blame | 历史
BLL/bin/Release/Model.pdb 补丁 | 查看 | 原始文档 | blame | 历史
BLL/bin/Release/Pub_Class.dll 补丁 | 查看 | 原始文档 | blame | 历史
BLL/bin/Release/Pub_Class.pdb 补丁 | 查看 | 原始文档 | blame | 历史
BLL/bin/Release/Pub_Control.dll 补丁 | 查看 | 原始文档 | blame | 历史
BLL/bin/Release/Pub_Control.pdb 补丁 | 查看 | 原始文档 | blame | 历史
BLL/bin/Release/SQLHelper.dll 补丁 | 查看 | 原始文档 | blame | 历史
BLL/bin/Release/SQLHelper.pdb 补丁 | 查看 | 原始文档 | blame | 历史
DAL/bin/Release/DAL.dll 补丁 | 查看 | 原始文档 | blame | 历史
DAL/bin/Release/DAL.pdb 补丁 | 查看 | 原始文档 | blame | 历史
DAL/bin/Release/DBUtility.dll 补丁 | 查看 | 原始文档 | blame | 历史
DAL/bin/Release/DBUtility.pdb 补丁 | 查看 | 原始文档 | blame | 历史
DAL/bin/Release/Model.dll 补丁 | 查看 | 原始文档 | blame | 历史
DAL/bin/Release/Model.pdb 补丁 | 查看 | 原始文档 | blame | 历史
DAL/bin/Release/Pub_Class.dll 补丁 | 查看 | 原始文档 | blame | 历史
DAL/bin/Release/Pub_Class.pdb 补丁 | 查看 | 原始文档 | blame | 历史
DAL/bin/Release/Pub_Control.dll 补丁 | 查看 | 原始文档 | blame | 历史
DAL/bin/Release/Pub_Control.pdb 补丁 | 查看 | 原始文档 | blame | 历史
DAL/bin/Release/SQLHelper.dll 补丁 | 查看 | 原始文档 | blame | 历史
DAL/bin/Release/SQLHelper.pdb 补丁 | 查看 | 原始文档 | blame | 历史
DBUtility/bin/Release/DBUtility.dll 补丁 | 查看 | 原始文档 | blame | 历史
DBUtility/bin/Release/DBUtility.pdb 补丁 | 查看 | 原始文档 | blame | 历史
DBUtility/bin/Release/Pub_Class.dll 补丁 | 查看 | 原始文档 | blame | 历史
DBUtility/bin/Release/Pub_Class.pdb 补丁 | 查看 | 原始文档 | blame | 历史
DBUtility/bin/Release/Pub_Control.dll 补丁 | 查看 | 原始文档 | blame | 历史
DBUtility/bin/Release/Pub_Control.pdb 补丁 | 查看 | 原始文档 | blame | 历史
DBUtility/bin/Release/SQLHelper.dll 补丁 | 查看 | 原始文档 | blame | 历史
DBUtility/bin/Release/SQLHelper.pdb 补丁 | 查看 | 原始文档 | blame | 历史
DBUtility/obj/Release/DBUtility.csproj.AssemblyReference.cache 补丁 | 查看 | 原始文档 | blame | 历史
DBUtility/obj/Release/DBUtility.csproj.GenerateResource.Cache 补丁 | 查看 | 原始文档 | blame | 历史
DBUtility/obj/Release/DBUtility.csproj.ResolveComReference.cache 补丁 | 查看 | 原始文档 | blame | 历史
DBUtility/obj/Release/DBUtility.dll 补丁 | 查看 | 原始文档 | blame | 历史
DBUtility/obj/Release/DBUtility.pdb 补丁 | 查看 | 原始文档 | blame | 历史
Model/bin/Release/DBUtility.dll 补丁 | 查看 | 原始文档 | blame | 历史
Model/bin/Release/DBUtility.pdb 补丁 | 查看 | 原始文档 | blame | 历史
Model/bin/Release/Model.dll 补丁 | 查看 | 原始文档 | blame | 历史
Model/bin/Release/Model.pdb 补丁 | 查看 | 原始文档 | blame | 历史
Model/bin/Release/Pub_Class.dll 补丁 | 查看 | 原始文档 | blame | 历史
Model/bin/Release/Pub_Class.pdb 补丁 | 查看 | 原始文档 | blame | 历史
Model/bin/Release/Pub_Control.dll 补丁 | 查看 | 原始文档 | blame | 历史
Model/bin/Release/Pub_Control.pdb 补丁 | 查看 | 原始文档 | blame | 历史
Model/bin/Release/SQLHelper.dll 补丁 | 查看 | 原始文档 | blame | 历史
Model/bin/Release/SQLHelper.pdb 补丁 | 查看 | 原始文档 | blame | 历史
Model/obj/Release/Model.csproj.AssemblyReference.cache 补丁 | 查看 | 原始文档 | blame | 历史
Model/obj/Release/Model.dll 补丁 | 查看 | 原始文档 | blame | 历史
Model/obj/Release/Model.pdb 补丁 | 查看 | 原始文档 | blame | 历史
Pub_Class/bin/Release/Pub_Class.dll 补丁 | 查看 | 原始文档 | blame | 历史
Pub_Class/bin/Release/Pub_Class.pdb 补丁 | 查看 | 原始文档 | blame | 历史
Pub_Control/bin/Release/Pub_Class.dll 补丁 | 查看 | 原始文档 | blame | 历史
Pub_Control/bin/Release/Pub_Class.pdb 补丁 | 查看 | 原始文档 | blame | 历史
Pub_Control/bin/Release/Pub_Control.dll 补丁 | 查看 | 原始文档 | blame | 历史
Pub_Control/bin/Release/Pub_Control.pdb 补丁 | 查看 | 原始文档 | blame | 历史
SQLHelper/bin/Release/Pub_Class.dll 补丁 | 查看 | 原始文档 | blame | 历史
SQLHelper/bin/Release/Pub_Class.pdb 补丁 | 查看 | 原始文档 | blame | 历史
SQLHelper/bin/Release/SQLHelper.dll 补丁 | 查看 | 原始文档 | blame | 历史
SQLHelper/bin/Release/SQLHelper.pdb 补丁 | 查看 | 原始文档 | blame | 历史
SQLHelper/obj/Release/SQLHelper.csproj.AssemblyReference.cache 补丁 | 查看 | 原始文档 | blame | 历史
SQLHelper/obj/Release/SQLHelper.dll 补丁 | 查看 | 原始文档 | blame | 历史
SQLHelper/obj/Release/SQLHelper.pdb 补丁 | 查看 | 原始文档 | blame | 历史
SyntacticSugar/obj/Debug/SyntacticSugar.csproj.AssemblyReference.cache 补丁 | 查看 | 原始文档 | blame | 历史
SyntacticSugar/obj/Debug/SyntacticSugar.csproj.FileListAbsolute.txt 2 ●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebAPI/Controllers/华远datamapping/HY_DataMappingController.cs 725 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebAPI/Properties/PublishProfiles/FolderProfile11.pubxml.user 8 ●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebAPI/Properties/PublishProfiles/FolderProfile2.pubxml.user 46 ●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebAPI/WebAPI.csproj 1 ●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebAPI/WebAPI.csproj.user 4 ●●●● 补丁 | 查看 | 原始文档 | blame | 历史
sdk_dingding/TopSdk/bin/Debug/TopSdk.dll 补丁 | 查看 | 原始文档 | blame | 历史
sdk_dingding/TopSdk/bin/Debug/TopSdk.pdb 补丁 | 查看 | 原始文档 | blame | 历史
sdk_dingding/TopSdk/bin/Release/TopSdk.dll 补丁 | 查看 | 原始文档 | blame | 历史
sdk_dingding/TopSdk/bin/Release/TopSdk.pdb 补丁 | 查看 | 原始文档 | blame | 历史
sdk_dingding/TopSdk/obj/Debug/TopSdk.csproj.FileListAbsolute.txt 2 ●●● 补丁 | 查看 | 原始文档 | blame | 历史
sdk_dingding/TopSdk/obj/Debug/TopSdk.dll 补丁 | 查看 | 原始文档 | blame | 历史
sdk_dingding/TopSdk/obj/Debug/TopSdk.pdb 补丁 | 查看 | 原始文档 | blame | 历史
sdk_dingding/TopSdk/obj/Release/TopSdk.dll 补丁 | 查看 | 原始文档 | blame | 历史
sdk_dingding/TopSdk/obj/Release/TopSdk.pdb 补丁 | 查看 | 原始文档 | blame | 历史
BLL/bin/Release/BLL.dll
Binary files differ
BLL/bin/Release/BLL.pdb
Binary files differ
BLL/bin/Release/DAL.dll
Binary files differ
BLL/bin/Release/DAL.pdb
Binary files differ
BLL/bin/Release/DBUtility.dll
Binary files differ
BLL/bin/Release/DBUtility.pdb
Binary files differ
BLL/bin/Release/Model.dll
Binary files differ
BLL/bin/Release/Model.pdb
Binary files differ
BLL/bin/Release/Pub_Class.dll
Binary files differ
BLL/bin/Release/Pub_Class.pdb
Binary files differ
BLL/bin/Release/Pub_Control.dll
Binary files differ
BLL/bin/Release/Pub_Control.pdb
Binary files differ
BLL/bin/Release/SQLHelper.dll
Binary files differ
BLL/bin/Release/SQLHelper.pdb
Binary files differ
DAL/bin/Release/DAL.dll
Binary files differ
DAL/bin/Release/DAL.pdb
Binary files differ
DAL/bin/Release/DBUtility.dll
Binary files differ
DAL/bin/Release/DBUtility.pdb
Binary files differ
DAL/bin/Release/Model.dll
Binary files differ
DAL/bin/Release/Model.pdb
Binary files differ
DAL/bin/Release/Pub_Class.dll
Binary files differ
DAL/bin/Release/Pub_Class.pdb
Binary files differ
DAL/bin/Release/Pub_Control.dll
Binary files differ
DAL/bin/Release/Pub_Control.pdb
Binary files differ
DAL/bin/Release/SQLHelper.dll
Binary files differ
DAL/bin/Release/SQLHelper.pdb
Binary files differ
DBUtility/bin/Release/DBUtility.dll
Binary files differ
DBUtility/bin/Release/DBUtility.pdb
Binary files differ
DBUtility/bin/Release/Pub_Class.dll
Binary files differ
DBUtility/bin/Release/Pub_Class.pdb
Binary files differ
DBUtility/bin/Release/Pub_Control.dll
Binary files differ
DBUtility/bin/Release/Pub_Control.pdb
Binary files differ
DBUtility/bin/Release/SQLHelper.dll
Binary files differ
DBUtility/bin/Release/SQLHelper.pdb
Binary files differ
DBUtility/obj/Release/DBUtility.csproj.AssemblyReference.cache
Binary files differ
DBUtility/obj/Release/DBUtility.csproj.GenerateResource.Cache
Binary files differ
DBUtility/obj/Release/DBUtility.csproj.ResolveComReference.cache
Binary files differ
DBUtility/obj/Release/DBUtility.dll
Binary files differ
DBUtility/obj/Release/DBUtility.pdb
Binary files differ
Model/bin/Release/DBUtility.dll
Binary files differ
Model/bin/Release/DBUtility.pdb
Binary files differ
Model/bin/Release/Model.dll
Binary files differ
Model/bin/Release/Model.pdb
Binary files differ
Model/bin/Release/Pub_Class.dll
Binary files differ
Model/bin/Release/Pub_Class.pdb
Binary files differ
Model/bin/Release/Pub_Control.dll
Binary files differ
Model/bin/Release/Pub_Control.pdb
Binary files differ
Model/bin/Release/SQLHelper.dll
Binary files differ
Model/bin/Release/SQLHelper.pdb
Binary files differ
Model/obj/Release/Model.csproj.AssemblyReference.cache
Binary files differ
Model/obj/Release/Model.dll
Binary files differ
Model/obj/Release/Model.pdb
Binary files differ
Pub_Class/bin/Release/Pub_Class.dll
Binary files differ
Pub_Class/bin/Release/Pub_Class.pdb
Binary files differ
Pub_Control/bin/Release/Pub_Class.dll
Binary files differ
Pub_Control/bin/Release/Pub_Class.pdb
Binary files differ
Pub_Control/bin/Release/Pub_Control.dll
Binary files differ
Pub_Control/bin/Release/Pub_Control.pdb
Binary files differ
SQLHelper/bin/Release/Pub_Class.dll
Binary files differ
SQLHelper/bin/Release/Pub_Class.pdb
Binary files differ
SQLHelper/bin/Release/SQLHelper.dll
Binary files differ
SQLHelper/bin/Release/SQLHelper.pdb
Binary files differ
SQLHelper/obj/Release/SQLHelper.csproj.AssemblyReference.cache
Binary files differ
SQLHelper/obj/Release/SQLHelper.dll
Binary files differ
SQLHelper/obj/Release/SQLHelper.pdb
Binary files differ
SyntacticSugar/obj/Debug/SyntacticSugar.csproj.AssemblyReference.cache
Binary files differ
SyntacticSugar/obj/Debug/SyntacticSugar.csproj.FileListAbsolute.txt
@@ -1,6 +1,6 @@
D:\网站发布\后端代码\MES-WEB-API\MES-WEB-API\SyntacticSugar\bin\Debug\SyntacticSugar.dll
D:\网站发布\后端代码\MES-WEB-API\MES-WEB-API\SyntacticSugar\bin\Debug\SyntacticSugar.pdb
D:\网站发布\后端代码\MES-WEB-API\MES-WEB-API\SyntacticSugar\obj\Debug\SyntacticSugar.csproj.AssemblyReference.cache
D:\网站发布\后端代码\MES-WEB-API\MES-WEB-API\SyntacticSugar\obj\Debug\SyntacticSugar.csproj.CoreCompileInputs.cache
D:\网站发布\后端代码\MES-WEB-API\MES-WEB-API\SyntacticSugar\obj\Debug\SyntacticSugar.dll
D:\网站发布\后端代码\MES-WEB-API\MES-WEB-API\SyntacticSugar\obj\Debug\SyntacticSugar.pdb
D:\网站发布\后端代码\MES-WEB-API\MES-WEB-API\SyntacticSugar\obj\Debug\SyntacticSugar.csproj.AssemblyReference.cache
WebAPI/Controllers/»ªÔ¶datamapping/HY_DataMappingController.cs
New file
@@ -0,0 +1,725 @@
using Newtonsoft.Json;
using Newtonsoft.Json.Linq;
using Pub_Class;
using System;
using System.Collections;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Net;
using System.Web.Http;
using System.Windows.Forms;
using WebAPI.Models;
namespace WebAPI.Controllers
{
    #region åŽè¿œè¯·æ±‚基础资料
    #region ç‚¬æ£®VRS内层检验结果上传接口 ç›¸å…³æ¨¡åž‹ç±»
    public class VRSInner_saveCheckNote_RequestParams
    {
        public string HMaker;                           //制单人
        public List<VRSInner_saveCheckNote_RequestParams_data> param;
    }
    public class VRSInner_saveCheckNote_RequestParams_data
    {
        public string HBarCode;                         //PNL条码编号
        public string HPCSNo;                           //PCS号
        public int HPosition_x;                         //PCS所在行的索引
        public int HPosition_y;                         //PCS所在列的索引
        public int HPageIndex;                          //正反面(0:正面,1:反面)
        public string HBadReason;                       //不良原因
    }
    public class VRSInner_saveCheckNote_RequestResult
    {
        public string code;
        public string msg;
    }
    #endregion
    #region ç‚¬æ£®VRS外层获取datamapping接口 ç›¸å…³æ¨¡åž‹ç±»
    public class VRSOuter_getDataMapping_RequestParams
    {
        public string HBarCode;                     //PNL条码编号
    }
    public class VRSOuter_getDataMapping_RequestResult
    {
        public string code;
        public string msg;
        public List<VRSOuter_getDataMapping_RequestResult_data> data;
    }
    public class VRSOuter_getDataMapping_RequestResult_data
    {
        public string HBarCode;                         //PNL条码号
        public string HPCSNo;                           //PCS号
        public int HPosition_x;                         //PCS的行索引
        public int HPosition_y;                         //PCS的列索引
    }
    #endregion
    #region ç‚¬æ£®VRS外层检验结果上传接口 ç›¸å…³æ¨¡åž‹ç±»
    public class VRSOuter_saveCheckNote_RequestParams
    {
        public string HMaker;                           //制单人
        public List<VRSOuter_saveCheckNote_RequestParams_data> param;
    }
    public class VRSOuter_saveCheckNote_RequestParams_data
    {
        public string HBarCode;                         //PNL条码编号
        public string HPCSNo;                           //PCS号
        public int HPosition_x;                         //PCS所在行的索引
        public int HPosition_y;                         //PCS所在列的索引
        public int HPageIndex;                          //正反面(0:正面,1:反面)
        public string HBadReason;                       //不良原因
    }
    public class VRSOuter_saveCheckNote_RequestResult
    {
        public string code;
        public string msg;
    }
    #endregion
    #region AVI获取datamapping接口 ç›¸å…³æ¨¡åž‹ç±»
    public class AVI_getDataMapping_RequestParams
    {
        public string HBarCode;                     //PNL条码编号
    }
    public class AVI_getDataMapping_RequestResult
    {
        public string code;
        public string msg;
        public List<AVI_getDataMapping_RequestResult_data> data;
    }
    public class AVI_getDataMapping_RequestResult_data
    {
        public string HBarCode;                         //PNL条码号
        public string HPCSNo;                           //PCS号
        public int HPosition_x;                         //PCS的行索引
        public int HPosition_y;                         //PCS的列索引
    }
    #endregion
    #region AVI检验结果上传接口 ç›¸å…³æ¨¡åž‹ç±»
    public class AVI_saveCheckNote_RequestParams
    {
        public string HMaker;                           //制单人
        public List<AVI_saveCheckNote_RequestParams_data> param;
    }
    public class AVI_saveCheckNote_RequestParams_data
    {
        public string HBarCode;                         //PNL条码编号
        public string HPCSNo;                           //PCS号
        public int HPosition_x;                         //PCS所在行的索引
        public int HPosition_y;                         //PCS所在列的索引
        public int HPageIndex;                          //正反面(0:正面,1:反面)
        public string HBadReason;                       //不良原因
    }
    public class AVI_saveCheckNote_RequestResult
    {
        public string code;
        public string msg;
    }
    #endregion
    #region ç”µæµ‹èŽ·å–datamapping接口 ç›¸å…³æ¨¡åž‹ç±»
    public class DC_getDataMapping_RequestParams
    {
        public string HBarCode;                     //set条码编号
    }
    public class DC_getDataMapping_RequestResult
    {
        public string code;
        public string msg;
        public List<DC_getDataMapping_RequestResult_data> data;
    }
    public class DC_getDataMapping_RequestResult_data
    {
        public string HBarCode;                         //PNL条码号
        public string HPCSNo;                           //PCS号
        public int HPosition_x;                         //PCS的行索引
        public int HPosition_y;                         //PCS的列索引
    }
    #endregion
    #region ç”µæµ‹æ£€éªŒç»“果上传接口 ç›¸å…³æ¨¡åž‹ç±»
    public class DC_saveCheckNote_RequestParams
    {
        public string HMaker;                           //制单人
        public List<DC_saveCheckNote_RequestParams_data> param;
    }
    public class DC_saveCheckNote_RequestParams_data
    {
        public string HBarCode;                         //set条码编号
        public string HPCSNo;                           //PCS号
        public int HPosition_x;                         //PCS所在行的索引
        public int HPosition_y;                         //PCS所在列的索引
        public int HPageIndex;                          //正反面(0:正面,1:反面)
        public string HBadReason;                       //不良原因
    }
    public class DC_saveCheckNote_RequestResult
    {
        public string code;
        public string msg;
    }
    #endregion
    #region æ¿€å…‰å‰²èŽ·å–datamapping接口 ç›¸å…³æ¨¡åž‹ç±»
    public class JGG_getDataMapping_RequestParams
    {
        public string HBarCode;                     //set条码编号
    }
    public class JGG_getDataMapping_RequestResult
    {
        public string code;
        public string msg;
        public List<JGG_getDataMapping_RequestResult_data> data;
    }
    public class JGG_getDataMapping_RequestResult_data
    {
        public string HBarCode;                         //PNL条码号
        public string HPCSNo;                           //PCS号
        public int HPosition_x;                         //PCS的行索引
        public int HPosition_y;                         //PCS的列索引
    }
    #endregion
    #endregion
    public class HY_DataMappingController : ApiController
    {
        //获取系统参数
        Pub_Class.ClsXt_SystemParameter oSystemParameter = new Pub_Class.ClsXt_SystemParameter();
        private json objJsonResult = new json();
        SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
        DataSet ds;
        #region ç‚¬æ£®VRS内层检验结果上传接口
        [Route("VRSInner/VRSInner_saveCheckNote")]
        [HttpPost]
        public VRSInner_saveCheckNote_RequestResult VRSInner_saveCheckNote([FromBody] JObject sMainSub)
        {
            VRSInner_saveCheckNote_RequestResult result = new VRSInner_saveCheckNote_RequestResult();
            string msg_success = "";
            try
            {
                var _value = sMainSub["sMainSub"].ToString();
                string msg1 = _value.ToString();
                string msg2 = "[" + msg1 + "]";
                List<VRSInner_saveCheckNote_RequestParams> vRSInner_SaveCheckNote_RequestParams = Newtonsoft.Json.JsonConvert.DeserializeObject<List<VRSInner_saveCheckNote_RequestParams>>(msg2);
                oCN.BeginTran();
                for (int i = 0; i < vRSInner_SaveCheckNote_RequestParams.Count; i++)
                {
                    string HMaker = vRSInner_SaveCheckNote_RequestParams[i].HMaker;
                    for (int j = 0; j < vRSInner_SaveCheckNote_RequestParams[i].param.Count; j++)
                    {
                        string HBarCode = vRSInner_SaveCheckNote_RequestParams[i].param[j].HBarCode;
                        string HSetNo = "";
                        string HPCSNo = vRSInner_SaveCheckNote_RequestParams[i].param[j].HPCSNo;
                        int HPosition_x = vRSInner_SaveCheckNote_RequestParams[i].param[j].HPosition_x;
                        int HPosition_y = vRSInner_SaveCheckNote_RequestParams[i].param[j].HPosition_y;
                        string HCheckProc = "炬森VRS内层";
                        int HPageIndex = vRSInner_SaveCheckNote_RequestParams[i].param[j].HPageIndex;
                        string HBadReason = vRSInner_SaveCheckNote_RequestParams[i].param[j].HBadReason;
                        //根据PNL条码找到PNL对于的PNL布局信息。然后根据PCS号在PNL布局信息中找到PCS对应的set号
                        string sql_set = "" +
                            "select distinct " +
                            "    b.HSetNo " +
                            "from Gy_PNLInfo as a " +
                            "inner join Gy_PNLInfoSub as b on a.HInterID = b.HInterID " +
                            "where a.HLayOutName in " +
                            "    ( " +
                            "        select HLayOutName from Gy_BarCodeBill_PNL_Temp where HBarCode = '" + HBarCode + "' " +
                            //"        union " +
                            //"        select HLayOutName from Gy_BarCodeBill_PNL_His where HBarCode = '" + HBarCode + "' " +
                            "    ) " +
                            "and b.HPCSNo = '" + HPCSNo + "' ";
                        ds = oCN.RunProcReturn(sql_set, "Gy_PNLInfo");
                        if(ds!=null && ds.Tables.Count>0 && ds.Tables[0].Rows.Count > 0)
                        {
                            HSetNo = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HSetNo"]);
                        }
                        string sql = "insert into QC_CheckNote_PNL_Temp(HBarCode,HSetNo,HPCSNo,HPosition_x,HPosition_y,HCheckProc,HPageIndex,HBadReason,HMaker,HMakeDate) " +
                            "values(" +
                            "'" + HBarCode + "'" +
                            ",'" + HSetNo + "'" +
                            ",'" + HPCSNo + "'" +
                            "," + HPosition_x + "" +
                            "," + HPosition_y + "" +
                            ",'" + HCheckProc + "'" +
                            "," + HPageIndex + "" +
                            ",'" + HBadReason + "'" +
                            ",'" + HMaker + "'" +
                            ",getdate() " +
                            ")";
                        oCN.RunProc(sql);
                        msg_success += JsonConvert.SerializeObject(vRSInner_SaveCheckNote_RequestParams[i].param[j], Formatting.Indented);
                    }
                }
                oCN.Commit();
                result.code = "1";
                result.msg = "上传成功!!" + msg_success;
                return result;
            }
            catch (Exception e)
            {
                oCN.RollBack();
                result.code = "0";
                result.msg = "上传失败!!" + e.Message;
                return result;
            }
        }
        #endregion
        #region ç‚¬æ£®VRS外层获取datamapping数据 æŽ¥å£
        [Route("VRSOuter/VRSOuter_getDataMapping")]
        [HttpGet]
        public VRSOuter_getDataMapping_RequestResult VRSOuter_getDataMapping(string HBarCode)
        {
            VRSOuter_getDataMapping_RequestResult result = new VRSOuter_getDataMapping_RequestResult();
            List<VRSOuter_getDataMapping_RequestResult_data> dataList = new List<VRSOuter_getDataMapping_RequestResult_data>();
            try
            {
                string sql = "" +
                    //"select * from QC_CheckNote_PNL_His where HBarCode = '" + HBarCode + "' " +
                    //"union " +
                    "select * from QC_CheckNote_PNL_Temp where HBarCode = '" + HBarCode + "'";
                ds = oCN.RunProcReturn(sql, "QC_CheckNote_PNL_Temp");
                for(int i = 0; i < ds.Tables[0].Rows.Count; i++)
                {
                    VRSOuter_getDataMapping_RequestResult_data data = new VRSOuter_getDataMapping_RequestResult_data();
                    data.HBarCode = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[i]["HBarCode"]);
                    data.HPCSNo = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[i]["HPCSNo"]);
                    data.HPosition_x = DBUtility.ClsPub.isInt(ds.Tables[0].Rows[i]["HPosition_x"]);
                    data.HPosition_y = DBUtility.ClsPub.isInt(ds.Tables[0].Rows[i]["HPosition_y"]);
                    dataList.Add(data);
                }
                result.code = "1";
                result.msg = "";
                result.data = dataList;
                return result;
            }
            catch (Exception e)
            {
                result.code = "0";
                result.msg = "" + e.Message;
                result.data = null;
                return result;
            }
        }
        #endregion
        #region ç‚¬æ£®VRS外层检验结果上传接口
        [Route("VRSOuter/VRSOuter_saveCheckNote")]
        [HttpPost]
        public VRSOuter_saveCheckNote_RequestResult VRSOuter_saveCheckNote([FromBody] JObject sMainSub)
        {
            VRSOuter_saveCheckNote_RequestResult result = new VRSOuter_saveCheckNote_RequestResult();
            string msg_success = "";
            try
            {
                var _value = sMainSub["sMainSub"].ToString();
                string msg1 = _value.ToString();
                string msg2 = "[" + msg1 + "]";
                List<VRSOuter_saveCheckNote_RequestParams> vRSOuter_SaveCheckNote_RequestParams = Newtonsoft.Json.JsonConvert.DeserializeObject<List<VRSOuter_saveCheckNote_RequestParams>>(msg2);
                oCN.BeginTran();
                for (int i = 0; i < vRSOuter_SaveCheckNote_RequestParams.Count; i++)
                {
                    string HMaker = vRSOuter_SaveCheckNote_RequestParams[i].HMaker;
                    for (int j = 0; j < vRSOuter_SaveCheckNote_RequestParams[i].param.Count; j++)
                    {
                        string HBarCode = vRSOuter_SaveCheckNote_RequestParams[i].param[j].HBarCode;
                        string HSetNo = "";
                        string HPCSNo = vRSOuter_SaveCheckNote_RequestParams[i].param[j].HPCSNo;
                        int HPosition_x = vRSOuter_SaveCheckNote_RequestParams[i].param[j].HPosition_x;
                        int HPosition_y = vRSOuter_SaveCheckNote_RequestParams[i].param[j].HPosition_y;
                        string HCheckProc = "炬森VRS外层";
                        int HPageIndex = vRSOuter_SaveCheckNote_RequestParams[i].param[j].HPageIndex;
                        string HBadReason = vRSOuter_SaveCheckNote_RequestParams[i].param[j].HBadReason;
                        //根据PNL条码找到PNL对于的PNL布局信息。然后根据PCS号在PNL布局信息中找到PCS对应的set号
                        string sql_set = "" +
                            "select distinct " +
                            "    b.HSetNo " +
                            "from Gy_PNLInfo as a " +
                            "inner join Gy_PNLInfoSub as b on a.HInterID = b.HInterID " +
                            "where a.HLayOutName in " +
                            "    ( " +
                            "        select HLayOutName from Gy_BarCodeBill_PNL_Temp where HBarCode = '" + HBarCode + "' " +
                            //"        union " +
                            //"        select HLayOutName from Gy_BarCodeBill_PNL_His where HBarCode = '" + HBarCode + "' " +
                            "    ) " +
                            "and b.HPCSNo = '" + HPCSNo + "' ";
                        ds = oCN.RunProcReturn(sql_set, "Gy_PNLInfo");
                        if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
                        {
                            HSetNo = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HSetNo"]);
                        }
                        string sql = "insert into QC_CheckNote_PNL_Temp(HBarCode,HSetNo,HPCSNo,HPosition_x,HPosition_y,HCheckProc,HPageIndex,HBadReason,HMaker,HMakeDate) " +
                            "values(" +
                            "'" + HBarCode + "'" +
                            ",'" + HSetNo + "'" +
                            ",'" + HPCSNo + "'" +
                            "," + HPosition_x + "" +
                            "," + HPosition_y + "" +
                            ",'" + HCheckProc + "'" +
                            "," + HPageIndex + "" +
                            ",'" + HBadReason + "'" +
                            ",'" + HMaker + "'" +
                            ",getdate() " +
                            ")";
                        oCN.RunProc(sql);
                        msg_success += JsonConvert.SerializeObject(vRSOuter_SaveCheckNote_RequestParams[i].param[j], Formatting.Indented);
                    }
                }
                oCN.Commit();
                result.code = "1";
                result.msg = "上传成功!!" + msg_success;
                return result;
            }
            catch (Exception e)
            {
                oCN.RollBack();
                result.code = "0";
                result.msg = "上传失败!!" + e.Message;
                return result;
            }
        }
        #endregion
        #region AVI获取datamapping数据 æŽ¥å£
        [Route("AVI/AVI_getDataMapping")]
        [HttpGet]
        public AVI_getDataMapping_RequestResult AVI_getDataMapping(string HBarCode)
        {
            AVI_getDataMapping_RequestResult result = new AVI_getDataMapping_RequestResult();
            List<AVI_getDataMapping_RequestResult_data> dataList = new List<AVI_getDataMapping_RequestResult_data>();
            try
            {
                string sql = "" +
                    //"select * from QC_CheckNote_PNL_His where HBarCode = '" + HBarCode + "' " +
                    //"union " +
                    "select * from QC_CheckNote_PNL_Temp where HBarCode = '" + HBarCode + "'";
                ds = oCN.RunProcReturn(sql, "QC_CheckNote_PNL_Temp");
                for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                {
                    AVI_getDataMapping_RequestResult_data data = new AVI_getDataMapping_RequestResult_data();
                    data.HBarCode = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[i]["HBarCode"]);
                    data.HPCSNo = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[i]["HPCSNo"]);
                    data.HPosition_x = DBUtility.ClsPub.isInt(ds.Tables[0].Rows[i]["HPosition_x"]);
                    data.HPosition_y = DBUtility.ClsPub.isInt(ds.Tables[0].Rows[i]["HPosition_y"]);
                    dataList.Add(data);
                }
                result.code = "1";
                result.msg = "";
                result.data = dataList;
                return result;
            }
            catch (Exception e)
            {
                result.code = "0";
                result.msg = "" + e.Message;
                result.data = null;
                return result;
            }
        }
        #endregion
        #region AVI检验结果上传接口
        [Route("AVI/AVI_saveCheckNote")]
        [HttpPost]
        public AVI_saveCheckNote_RequestResult AVI_saveCheckNote([FromBody] JObject sMainSub)
        {
            AVI_saveCheckNote_RequestResult result = new AVI_saveCheckNote_RequestResult();
            string msg_success = "";
            try
            {
                var _value = sMainSub["sMainSub"].ToString();
                string msg1 = _value.ToString();
                string msg2 = "[" + msg1 + "]";
                List<AVI_saveCheckNote_RequestParams> aVI_SaveCheckNote_RequestParams = Newtonsoft.Json.JsonConvert.DeserializeObject<List<AVI_saveCheckNote_RequestParams>>(msg2);
                oCN.BeginTran();
                for (int i = 0; i < aVI_SaveCheckNote_RequestParams.Count; i++)
                {
                    string HMaker = aVI_SaveCheckNote_RequestParams[i].HMaker;
                    for (int j = 0; j < aVI_SaveCheckNote_RequestParams[i].param.Count; j++)
                    {
                        string HBarCode = aVI_SaveCheckNote_RequestParams[i].param[j].HBarCode;
                        string HSetNo = "";
                        string HPCSNo = aVI_SaveCheckNote_RequestParams[i].param[j].HPCSNo;
                        int HPosition_x = aVI_SaveCheckNote_RequestParams[i].param[j].HPosition_x;
                        int HPosition_y = aVI_SaveCheckNote_RequestParams[i].param[j].HPosition_y;
                        string HCheckProc = "AVI";
                        int HPageIndex = aVI_SaveCheckNote_RequestParams[i].param[j].HPageIndex;
                        string HBadReason = aVI_SaveCheckNote_RequestParams[i].param[j].HBadReason;
                        //根据PNL条码找到PNL对于的PNL布局信息。然后根据PCS号在PNL布局信息中找到PCS对应的set号
                        string sql_set = "" +
                            "select distinct " +
                            "    b.HSetNo " +
                            "from Gy_PNLInfo as a " +
                            "inner join Gy_PNLInfoSub as b on a.HInterID = b.HInterID " +
                            "where a.HLayOutName in " +
                            "    ( " +
                            "        select HLayOutName from Gy_BarCodeBill_PNL_Temp where HBarCode = '" + HBarCode + "' " +
                            //"        union " +
                            //"        select HLayOutName from Gy_BarCodeBill_PNL_His where HBarCode = '" + HBarCode + "' " +
                            "    ) " +
                            "and b.HPCSNo = '" + HPCSNo + "' ";
                        ds = oCN.RunProcReturn(sql_set, "Gy_PNLInfo");
                        if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
                        {
                            HSetNo = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HSetNo"]);
                        }
                        string sql = "insert into QC_CheckNote_PNL_Temp(HBarCode,HSetNo,HPCSNo,HPosition_x,HPosition_y,HCheckProc,HPageIndex,HBadReason,HMaker,HMakeDate) " +
                            "values(" +
                            "'" + HBarCode + "'" +
                            ",'" + HSetNo + "'" +
                            ",'" + HPCSNo + "'" +
                            "," + HPosition_x + "" +
                            "," + HPosition_y + "" +
                            ",'" + HCheckProc + "'" +
                            "," + HPageIndex + "" +
                            ",'" + HBadReason + "'" +
                            ",'" + HMaker + "'" +
                            ",getdate() " +
                            ")";
                        oCN.RunProc(sql);
                        msg_success += JsonConvert.SerializeObject(aVI_SaveCheckNote_RequestParams[i].param[j], Formatting.Indented);
                    }
                }
                oCN.Commit();
                result.code = "1";
                result.msg = "上传成功!!" + msg_success;
                return result;
            }
            catch (Exception e)
            {
                oCN.RollBack();
                result.code = "0";
                result.msg = "上传失败!!" + e.Message;
                return result;
            }
        }
        #endregion
        #region ç”µæµ‹èŽ·å–datamapping数据 æŽ¥å£
        [Route("DC/DC_getDataMapping")]
        [HttpGet]
        public DC_getDataMapping_RequestResult DC_getDataMapping(string HBarCode)
        {
            DC_getDataMapping_RequestResult result = new DC_getDataMapping_RequestResult();
            List<DC_getDataMapping_RequestResult_data> dataList = new List<DC_getDataMapping_RequestResult_data>();
            try
            {
                //根据set条码编号,获取set所属的PNL条码编号
                string HBarCode_PNL = "";
                string sql_PNLBarCode = "" +
                    //"select * from Gy_BarCodeBill_Set_His where HBarCode = '" + HBarCode + "' " +
                    //"union " +
                    "select * from Gy_BarCodeBill_Set_Temp where HBarCode = '" + HBarCode + "' ";
                ds = oCN.RunProcReturn(sql_PNLBarCode, "Gy_BarCodeBill_Set_Temp");
                if(ds!=null && ds.Tables.Count>0 && ds.Tables[0].Rows.Count > 0)
                {
                    HBarCode_PNL = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBarCode_PNL"]);
                }
                //根据set条码编号,获取set号。(set条码编号规则:y+ww+五位PNL流水号+两位set号)
                string HSetNo = HBarCode.Substring(HBarCode.Length-2,2);
                //根据PNL条码编号、set号,从PNL检验信息表中获取set对应的检验信息
                string sql = "" +
                    //"select * from QC_CheckNote_PNL_His where HBarCode = '" + HBarCode_PNL + "' and HSetNo = '" + HSetNo + "' " +
                    //"union " +
                    "select * from QC_CheckNote_PNL_Temp where HBarCode = '" + HBarCode_PNL + "' and HSetNo = '" + HSetNo + "' ";
                ds = oCN.RunProcReturn(sql, "QC_CheckNote_PNL_Temp");
                for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                {
                    DC_getDataMapping_RequestResult_data data = new DC_getDataMapping_RequestResult_data();
                    data.HBarCode = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[i]["HBarCode"]);
                    data.HPCSNo = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[i]["HPCSNo"]);
                    data.HPosition_x = DBUtility.ClsPub.isInt(ds.Tables[0].Rows[i]["HPosition_x"]);
                    data.HPosition_y = DBUtility.ClsPub.isInt(ds.Tables[0].Rows[i]["HPosition_y"]);
                    dataList.Add(data);
                }
                result.code = "1";
                result.msg = "";
                result.data = dataList;
                return result;
            }
            catch (Exception e)
            {
                result.code = "0";
                result.msg = "" + e.Message;
                result.data = null;
                return result;
            }
        }
        #endregion
        #region ç”µæµ‹æ£€éªŒç»“果上传接口
        [Route("DC/DC_saveCheckNote")]
        [HttpPost]
        public DC_saveCheckNote_RequestResult DC_saveCheckNote([FromBody] JObject sMainSub)
        {
            DC_saveCheckNote_RequestResult result = new DC_saveCheckNote_RequestResult();
            string msg_success = "";
            try
            {
                var _value = sMainSub["sMainSub"].ToString();
                string msg1 = _value.ToString();
                string msg2 = "[" + msg1 + "]";
                List<DC_saveCheckNote_RequestParams> dC_SaveCheckNote_RequestParams = Newtonsoft.Json.JsonConvert.DeserializeObject<List<DC_saveCheckNote_RequestParams>>(msg2);
                oCN.BeginTran();
                for (int i = 0; i < dC_SaveCheckNote_RequestParams.Count; i++)
                {
                    string HMaker = dC_SaveCheckNote_RequestParams[i].HMaker;
                    for (int j = 0; j < dC_SaveCheckNote_RequestParams[i].param.Count; j++)
                    {
                        string HBarCode = dC_SaveCheckNote_RequestParams[i].param[j].HBarCode;
                        string HBarCode_PNL = "";
                        string HSetNo = HBarCode.Substring(HBarCode.Length-2,2);
                        string HPCSNo = dC_SaveCheckNote_RequestParams[i].param[j].HPCSNo;
                        int HPosition_x = dC_SaveCheckNote_RequestParams[i].param[j].HPosition_x;
                        int HPosition_y = dC_SaveCheckNote_RequestParams[i].param[j].HPosition_y;
                        string HCheckProc = "电测";
                        int HPageIndex = dC_SaveCheckNote_RequestParams[i].param[j].HPageIndex;
                        string HBadReason = dC_SaveCheckNote_RequestParams[i].param[j].HBadReason;
                        //根据set条码编号,获取set所属的PNL条码编号
                        string sql_PNLBarCode = "" +
                            //"select * from Gy_BarCodeBill_Set_His where HBarCode = '" + HBarCode + "' " +
                            //"union " +
                            "select * from Gy_BarCodeBill_Set_Temp where HBarCode = '" + HBarCode + "' ";
                        ds = oCN.RunProcReturn(sql_PNLBarCode, "Gy_BarCodeBill_Set_Temp");
                        if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
                        {
                            HBarCode_PNL = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBarCode_PNL"]);
                        }
                        string sql = "insert into QC_CheckNote_PNL_Temp(HBarCode,HSetNo,HPCSNo,HPosition_x,HPosition_y,HCheckProc,HPageIndex,HBadReason,HMaker,HMakeDate) " +
                            "values(" +
                            "'" + HBarCode_PNL + "'" +
                            ",'" + HSetNo + "'" +
                            ",'" + HPCSNo + "'" +
                            "," + HPosition_x + "" +
                            "," + HPosition_y + "" +
                            ",'" + HCheckProc + "'" +
                            "," + HPageIndex + "" +
                            ",'" + HBadReason + "'" +
                            ",'" + HMaker + "'" +
                            ",getdate() " +
                            ")";
                        oCN.RunProc(sql);
                        msg_success += JsonConvert.SerializeObject(dC_SaveCheckNote_RequestParams[i].param[j], Formatting.Indented);
                    }
                }
                oCN.Commit();
                result.code = "1";
                result.msg = "上传成功!!" + msg_success;
                return result;
            }
            catch (Exception e)
            {
                oCN.RollBack();
                result.code = "0";
                result.msg = "上传失败!!" + e.Message;
                return result;
            }
        }
        #endregion
        #region æ¿€å…‰å‰²èŽ·å–datamapping数据 æŽ¥å£
        [Route("JGG/JGG_getDataMapping")]
        [HttpGet]
        public JGG_getDataMapping_RequestResult JGG_getDataMapping(string HBarCode)
        {
            JGG_getDataMapping_RequestResult result = new JGG_getDataMapping_RequestResult();
            List<JGG_getDataMapping_RequestResult_data> dataList = new List<JGG_getDataMapping_RequestResult_data>();
            try
            {
                //根据set条码编号,获取set所属的PNL条码编号
                string HBarCode_PNL = "";
                string sql_PNLBarCode = "" +
                    //"select * from Gy_BarCodeBill_Set_His where HBarCode = '" + HBarCode + "' " +
                    //"union " +
                    "select * from Gy_BarCodeBill_Set_Temp where HBarCode = '" + HBarCode + "' ";
                ds = oCN.RunProcReturn(sql_PNLBarCode, "Gy_BarCodeBill_Set_Temp");
                if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
                {
                    HBarCode_PNL = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBarCode_PNL"]);
                }
                //根据set条码编号,获取set号。(set条码编号规则:y+ww+五位PNL流水号+两位set号)
                string HSetNo = HBarCode.Substring(HBarCode.Length - 2, 2);
                //根据PNL条码编号、set号,从PNL检验信息表中获取set对应的检验信息
                string sql = "" +
                    //"select * from QC_CheckNote_PNL_His where HBarCode = '" + HBarCode_PNL + "' and HSetNo = '" + HSetNo + "' " +
                    //"union " +
                    "select * from QC_CheckNote_PNL_Temp where HBarCode = '" + HBarCode_PNL + "' and HSetNo = '" + HSetNo + "' ";
                ds = oCN.RunProcReturn(sql, "QC_CheckNote_PNL_Temp");
                for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                {
                    JGG_getDataMapping_RequestResult_data data = new JGG_getDataMapping_RequestResult_data();
                    data.HBarCode = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[i]["HBarCode"]);
                    data.HPCSNo = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[i]["HPCSNo"]);
                    data.HPosition_x = DBUtility.ClsPub.isInt(ds.Tables[0].Rows[i]["HPosition_x"]);
                    data.HPosition_y = DBUtility.ClsPub.isInt(ds.Tables[0].Rows[i]["HPosition_y"]);
                    dataList.Add(data);
                }
                result.code = "1";
                result.msg = "";
                result.data = dataList;
                return result;
            }
            catch (Exception e)
            {
                result.code = "0";
                result.msg = "" + e.Message;
                result.data = null;
                return result;
            }
        }
        #endregion
    }
}
WebAPI/Properties/PublishProfiles/FolderProfile11.pubxml.user
@@ -4,7 +4,7 @@
-->
<Project ToolsVersion="4.0" xmlns="http://schemas.microsoft.com/developer/msbuild/2003">
  <PropertyGroup>
    <History>True|2025-06-04T06:37:33.1938810Z;False|2025-06-04T14:37:01.3631593+08:00;True|2025-06-04T13:26:20.8238933+08:00;False|2025-06-04T13:25:43.1503457+08:00;</History>
    <History>True|2025-06-09T01:28:27.1189869Z;False|2025-06-09T09:27:55.2102771+08:00;True|2025-06-09T09:17:12.8435993+08:00;False|2025-06-09T09:16:38.2325198+08:00;True|2025-06-04T14:37:33.1938810+08:00;False|2025-06-04T14:37:01.3631593+08:00;True|2025-06-04T13:26:20.8238933+08:00;False|2025-06-04T13:25:43.1503457+08:00;</History>
    <_PublishTargetUrl>D:\网站发布\智云MESWMS\LAYAPI</_PublishTargetUrl>
  </PropertyGroup>
  <ItemGroup>
@@ -294,13 +294,13 @@
      <publishTime>11/24/2014 19:18:48</publishTime>
    </File>
    <File Include="bin/WebAPI.dll">
      <publishTime>06/04/2025 14:37:26</publishTime>
      <publishTime>06/09/2025 09:28:20</publishTime>
    </File>
    <File Include="bin/WebAPI.pdb">
      <publishTime>06/04/2025 14:37:26</publishTime>
      <publishTime>06/09/2025 09:28:20</publishTime>
    </File>
    <File Include="bin/WebAPI.XmlSerializers.dll">
      <publishTime>06/04/2025 14:37:31</publishTime>
      <publishTime>06/09/2025 09:28:26</publishTime>
    </File>
    <File Include="bin/WebGrease.dll">
      <publishTime>07/18/2013 01:03:52</publishTime>
WebAPI/Properties/PublishProfiles/FolderProfile2.pubxml.user
@@ -5,7 +5,7 @@
<Project ToolsVersion="4.0" xmlns="http://schemas.microsoft.com/developer/msbuild/2003">
  <PropertyGroup>
    <_PublishTargetUrl>D:\网站发布\智云MESWMS\API</_PublishTargetUrl>
    <History>True|2025-01-10T05:10:47.2046185Z;True|2025-01-10T11:11:49.4016910+08:00;True|2025-01-10T10:59:12.3481721+08:00;False|2025-01-10T10:58:24.5033898+08:00;True|2025-01-04T14:35:42.2792864+08:00;</History>
    <History>True|2025-06-09T08:45:52.0865612Z;True|2025-06-09T16:38:47.2182194+08:00;True|2025-06-09T16:17:50.9170601+08:00;False|2025-06-09T16:17:43.0333396+08:00;True|2025-06-09T15:25:17.0429161+08:00;True|2025-06-09T15:00:15.0058791+08:00;True|2025-06-09T14:50:02.1370115+08:00;True|2025-06-09T14:38:10.9037045+08:00;True|2025-06-09T14:34:53.2826267+08:00;True|2025-06-09T14:07:24.5341951+08:00;True|2025-06-09T13:39:17.5042542+08:00;True|2025-06-09T09:30:31.8197114+08:00;True|2025-01-10T13:10:47.2046185+08:00;True|2025-01-10T11:11:49.4016910+08:00;True|2025-01-10T10:59:12.3481721+08:00;False|2025-01-10T10:58:24.5033898+08:00;True|2025-01-04T14:35:42.2792864+08:00;</History>
  </PropertyGroup>
  <ItemGroup>
    <File Include="apiapp.json">
@@ -45,28 +45,28 @@
      <publishTime>02/22/2013 16:43:40</publishTime>
    </File>
    <File Include="bin/BLL.dll">
      <publishTime>01/10/2025 10:58:37</publishTime>
      <publishTime>06/09/2025 16:45:33</publishTime>
    </File>
    <File Include="bin/BLL.pdb">
      <publishTime>01/10/2025 10:58:37</publishTime>
      <publishTime>06/09/2025 16:45:33</publishTime>
    </File>
    <File Include="bin/BouncyCastle.Crypto.dll">
      <publishTime>12/18/2020 05:32:28</publishTime>
    </File>
    <File Include="bin/DAL.dll">
      <publishTime>01/10/2025 10:58:35</publishTime>
      <publishTime>06/09/2025 16:45:32</publishTime>
    </File>
    <File Include="bin/DAL.pdb">
      <publishTime>01/10/2025 10:58:35</publishTime>
      <publishTime>06/09/2025 16:45:32</publishTime>
    </File>
    <File Include="bin/Dapper.dll">
      <publishTime>07/22/2016 22:52:40</publishTime>
    </File>
    <File Include="bin/DBUtility.dll">
      <publishTime>12/31/2024 13:36:09</publishTime>
      <publishTime>06/09/2025 16:45:27</publishTime>
    </File>
    <File Include="bin/DBUtility.pdb">
      <publishTime>12/31/2024 13:36:09</publishTime>
      <publishTime>06/09/2025 16:45:27</publishTime>
    </File>
    <File Include="bin/Grpc.Core.Api.dll">
      <publishTime>03/22/2022 13:17:26</publishTime>
@@ -111,10 +111,10 @@
      <publishTime>07/25/2012 19:48:56</publishTime>
    </File>
    <File Include="bin/Model.dll">
      <publishTime>12/31/2024 13:36:10</publishTime>
      <publishTime>06/09/2025 16:45:28</publishTime>
    </File>
    <File Include="bin/Model.pdb">
      <publishTime>12/31/2024 13:36:10</publishTime>
      <publishTime>06/09/2025 16:45:28</publishTime>
    </File>
    <File Include="bin/Models/ClsSc_MouldScrapOutBillMain.cs">
      <publishTime>04/06/2023 15:57:02</publishTime>
@@ -147,34 +147,34 @@
      <publishTime>10/23/2021 17:07:54</publishTime>
    </File>
    <File Include="bin/Pub_Class.dll">
      <publishTime>12/31/2024 13:36:07</publishTime>
      <publishTime>06/09/2025 16:45:25</publishTime>
    </File>
    <File Include="bin/Pub_Class.pdb">
      <publishTime>12/31/2024 13:36:07</publishTime>
      <publishTime>06/09/2025 16:45:25</publishTime>
    </File>
    <File Include="bin/Pub_Control.dll">
      <publishTime>12/31/2024 13:36:09</publishTime>
      <publishTime>06/09/2025 16:45:26</publishTime>
    </File>
    <File Include="bin/Pub_Control.pdb">
      <publishTime>12/31/2024 13:36:09</publishTime>
      <publishTime>06/09/2025 16:45:26</publishTime>
    </File>
    <File Include="bin/RestSharp.dll">
      <publishTime>08/31/2012 06:22:50</publishTime>
    </File>
    <File Include="bin/SQLHelper.dll">
      <publishTime>12/31/2024 13:36:09</publishTime>
      <publishTime>06/09/2025 16:45:27</publishTime>
    </File>
    <File Include="bin/SQLHelper.pdb">
      <publishTime>12/31/2024 13:36:09</publishTime>
      <publishTime>06/09/2025 16:45:27</publishTime>
    </File>
    <File Include="bin/Swashbuckle.Core.dll">
      <publishTime>02/16/2015 01:57:08</publishTime>
    </File>
    <File Include="bin/SyntacticSugar.dll">
      <publishTime>12/31/2024 13:36:05</publishTime>
      <publishTime>06/09/2025 16:45:23</publishTime>
    </File>
    <File Include="bin/SyntacticSugar.pdb">
      <publishTime>12/31/2024 13:36:05</publishTime>
      <publishTime>06/09/2025 16:45:23</publishTime>
    </File>
    <File Include="bin/System.Buffers.dll">
      <publishTime>07/19/2017 18:01:28</publishTime>
@@ -285,22 +285,22 @@
      <publishTime>05/09/2023 10:43:40</publishTime>
    </File>
    <File Include="bin/TopSdk.dll">
      <publishTime>12/31/2024 13:36:11</publishTime>
      <publishTime>06/09/2025 16:45:28</publishTime>
    </File>
    <File Include="bin/TopSdk.pdb">
      <publishTime>12/31/2024 13:36:11</publishTime>
      <publishTime>06/09/2025 16:45:28</publishTime>
    </File>
    <File Include="bin/WebActivatorEx.dll">
      <publishTime>11/24/2014 19:18:48</publishTime>
    </File>
    <File Include="bin/WebAPI.dll">
      <publishTime>01/10/2025 13:10:41</publishTime>
      <publishTime>06/09/2025 16:45:41</publishTime>
    </File>
    <File Include="bin/WebAPI.pdb">
      <publishTime>01/10/2025 13:10:41</publishTime>
      <publishTime>06/09/2025 16:45:41</publishTime>
    </File>
    <File Include="bin/WebAPI.XmlSerializers.dll">
      <publishTime>01/10/2025 13:10:46</publishTime>
      <publishTime>06/09/2025 16:45:45</publishTime>
    </File>
    <File Include="bin/WebGrease.dll">
      <publishTime>07/18/2013 01:03:52</publishTime>
@@ -492,7 +492,7 @@
      <publishTime>04/06/2023 15:57:02</publishTime>
    </File>
    <File Include="Web.config">
      <publishTime>01/04/2025 14:35:40</publishTime>
      <publishTime>06/09/2025 16:45:51</publishTime>
    </File>
  </ItemGroup>
</Project>
WebAPI/WebAPI.csproj
@@ -464,6 +464,7 @@
    <Compile Include="Controllers\人事管理\人员履历\HR_PersonnelResumeController.cs" />
    <Compile Include="Controllers\仓存管理\Kf_MoveStockBillController.cs" />
    <Compile Include="Controllers\仓存管理\生产领料\Kf_ProductReceiveMaterialBillController.cs" />
    <Compile Include="Controllers\华远datamapping\HY_DataMappingController.cs" />
    <Compile Include="Controllers\品质管理\基础资料\Gy_BaseInformationController.cs" />
    <Compile Include="Controllers\品质管理\环境检测单\QC_EnvironmentTestDotCheckBillController.cs" />
    <Compile Include="Controllers\品质管理\质量月度目标单\QC_MonthTarGetBillController.cs" />
WebAPI/WebAPI.csproj.user
@@ -1,9 +1,9 @@
<?xml version="1.0" encoding="utf-8"?>
<Project ToolsVersion="4.0" xmlns="http://schemas.microsoft.com/developer/msbuild/2003">
  <PropertyGroup>
    <LastActiveSolutionConfig>Debug|Any CPU</LastActiveSolutionConfig>
    <LastActiveSolutionConfig>Release|Any CPU</LastActiveSolutionConfig>
    <NameOfLastUsedPublishProfile>C:\Users\86130\Desktop\智云迈思\MES-WEB-API\WebAPI\Properties\PublishProfiles\FolderProfilewtt.pubxml</NameOfLastUsedPublishProfile>
    <NameOfLastUsedPublishProfile>D:\网站发布\后端代码\MES-WEB-API\MES-WEB-API\WebAPI\Properties\PublishProfiles\FolderProfile11.pubxml</NameOfLastUsedPublishProfile>
    <NameOfLastUsedPublishProfile>D:\网站发布\后端代码\MES-WEB-API\MES-WEB-API\WebAPI\Properties\PublishProfiles\FolderProfile2.pubxml</NameOfLastUsedPublishProfile>
    <UseIISExpress>true</UseIISExpress>
    <Use64BitIISExpress />
    <IISExpressSSLPort />
sdk_dingding/TopSdk/bin/Debug/TopSdk.dll
Binary files differ
sdk_dingding/TopSdk/bin/Debug/TopSdk.pdb
Binary files differ
sdk_dingding/TopSdk/bin/Release/TopSdk.dll
Binary files differ
sdk_dingding/TopSdk/bin/Release/TopSdk.pdb
Binary files differ
sdk_dingding/TopSdk/obj/Debug/TopSdk.csproj.FileListAbsolute.txt
@@ -1,6 +1,6 @@
D:\网站发布\后端代码\MES-WEB-API\MES-WEB-API\sdk_dingding\TopSdk\bin\Debug\TopSdk.dll
D:\网站发布\后端代码\MES-WEB-API\MES-WEB-API\sdk_dingding\TopSdk\bin\Debug\TopSdk.pdb
D:\网站发布\后端代码\MES-WEB-API\MES-WEB-API\sdk_dingding\TopSdk\obj\Debug\TopSdk.csproj.AssemblyReference.cache
D:\网站发布\后端代码\MES-WEB-API\MES-WEB-API\sdk_dingding\TopSdk\obj\Debug\TopSdk.csproj.CoreCompileInputs.cache
D:\网站发布\后端代码\MES-WEB-API\MES-WEB-API\sdk_dingding\TopSdk\obj\Debug\TopSdk.dll
D:\网站发布\后端代码\MES-WEB-API\MES-WEB-API\sdk_dingding\TopSdk\obj\Debug\TopSdk.pdb
D:\网站发布\后端代码\MES-WEB-API\MES-WEB-API\sdk_dingding\TopSdk\obj\Debug\TopSdk.csproj.AssemblyReference.cache
sdk_dingding/TopSdk/obj/Debug/TopSdk.dll
Binary files differ
sdk_dingding/TopSdk/obj/Debug/TopSdk.pdb
Binary files differ
sdk_dingding/TopSdk/obj/Release/TopSdk.dll
Binary files differ
sdk_dingding/TopSdk/obj/Release/TopSdk.pdb
Binary files differ