1

zrg

2026-02-27 c8360013932a46ae5094863098ba711e32fc3b4e

1

 Model/»ù´¡×ÊÁÏ/»ù´¡×ÊÁÏ/ClsGy_BadReason_Model.cs

@@ -11,6 +11,7 @@
        public string HDeptNumber;
        public Int64 HProcID;
        public Int64 HBadTypeID;
        public Int64 HMaterTypeID;
        public string HBarCode;
    }
}

 NETERPNoWin/bin/x86/Debug/AlibabaCloud.GatewayDingTalk.dll

Binary files differ

 NETERPNoWin/bin/x86/Debug/AlibabaCloud.GatewaySpi.dll

Binary files differ

 NETERPNoWin/bin/x86/Debug/AlibabaCloud.OpenApiClient.dll

Binary files differ

 NETERPNoWin/bin/x86/Debug/AlibabaCloud.OpenApiUtil.dll

Binary files differ

 NETERPNoWin/bin/x86/Debug/AlibabaCloud.SDK.Dingtalk.dll

Binary files differ

 NETERPNoWin/bin/x86/Debug/AlibabaCloud.TeaUtil.dll

Binary files differ

 NETERPNoWin/bin/x86/Debug/AlibabaCloud.TeaXML.dll

Binary files differ

 NETERPNoWin/bin/x86/Debug/Aliyun.Credentials.dll

Binary files differ

 NETERPNoWin/bin/x86/Debug/AxInterop.grdes6Lib.dll

Binary files differ

 NETERPNoWin/bin/x86/Debug/AxInterop.gregn6Lib.dll

Binary files differ

 NETERPNoWin/bin/x86/Debug/BouncyCastle.Crypto.dll

Binary files differ

 NETERPNoWin/bin/x86/Debug/BouncyCastle.Crypto.xml

File was deleted

 NETERPNoWin/bin/x86/Debug/Dapper.dll

Binary files differ

 NETERPNoWin/bin/x86/Debug/Dapper.xml

File was deleted

 NETERPNoWin/bin/x86/Debug/ICSharpCode.SharpZipLib.dll

Binary files differ

 NETERPNoWin/bin/x86/Debug/ICSharpCode.SharpZipLib.pdb

Binary files differ

 NETERPNoWin/bin/x86/Debug/ICSharpCode.SharpZipLib.xml

File was deleted

 NETERPNoWin/bin/x86/Debug/Kingdee.BOS.WebApi.Client.dll

Binary files differ

 NETERPNoWin/bin/x86/Debug/M2Mqtt.Net.dll

Binary files differ

 NETERPNoWin/bin/x86/Debug/M2Mqtt.Net.pdb

Binary files differ

 NETERPNoWin/bin/x86/Debug/Microsoft.Web.Infrastructure.dll

Binary files differ

 NETERPNoWin/bin/x86/Debug/Models/ClsSc_MouldScrapOutBillMain.cs

File was deleted

 NETERPNoWin/bin/x86/Debug/NPOI.OOXML.dll

Binary files differ

 NETERPNoWin/bin/x86/Debug/NPOI.OOXML.pdb

Binary files differ

 NETERPNoWin/bin/x86/Debug/NPOI.OOXML.xml

File was deleted

 NETERPNoWin/bin/x86/Debug/NPOI.OpenXml4Net.dll

Binary files differ

 NETERPNoWin/bin/x86/Debug/NPOI.OpenXml4Net.pdb

Binary files differ

 NETERPNoWin/bin/x86/Debug/NPOI.OpenXmlFormats.dll

Binary files differ

 NETERPNoWin/bin/x86/Debug/NPOI.OpenXmlFormats.pdb

Binary files differ

 NETERPNoWin/bin/x86/Debug/NPOI.dll

Binary files differ

 NETERPNoWin/bin/x86/Debug/NPOI.pdb

Binary files differ

 NETERPNoWin/bin/x86/Debug/NPOI.xml

File was deleted

 NETERPNoWin/bin/x86/Debug/Newtonsoft.Json.dll

Binary files differ

 NETERPNoWin/bin/x86/Debug/RestSharp.dll

Binary files differ

 NETERPNoWin/bin/x86/Debug/RestSharp.xml

File was deleted

 NETERPNoWin/bin/x86/Debug/Swashbuckle.Core.dll

Binary files differ

 NETERPNoWin/bin/x86/Debug/System.Net.Http.Formatting.dll

Binary files differ

 NETERPNoWin/bin/x86/Debug/System.Net.Http.Formatting.xml

File was deleted

 NETERPNoWin/bin/x86/Debug/System.Web.Cors.dll

Binary files differ

 NETERPNoWin/bin/x86/Debug/System.Web.Http.Cors.dll

Binary files differ

 NETERPNoWin/bin/x86/Debug/System.Web.Http.Cors.xml

File was deleted

 NETERPNoWin/bin/x86/Debug/System.Web.Http.WebHost.dll

Binary files differ

 NETERPNoWin/bin/x86/Debug/System.Web.Http.dll

Binary files differ

 NETERPNoWin/bin/x86/Debug/System.Web.Http.xml

File was deleted

 NETERPNoWin/bin/x86/Debug/System.Web.Mvc.dll

Binary files differ

 NETERPNoWin/bin/x86/Debug/System.Web.Mvc.xml

File was deleted

 NETERPNoWin/bin/x86/Debug/System.Web.Optimization.dll

Binary files differ

 NETERPNoWin/bin/x86/Debug/System.Web.Optimization.xml

File was deleted

 NETERPNoWin/bin/x86/Debug/System.Web.Razor.dll

Binary files differ

 NETERPNoWin/bin/x86/Debug/System.Web.Razor.xml

File was deleted

 NETERPNoWin/bin/x86/Debug/System.Web.WebPages.Deployment.dll

Binary files differ

 NETERPNoWin/bin/x86/Debug/System.Web.WebPages.Deployment.xml

File was deleted

 NETERPNoWin/bin/x86/Debug/System.Web.WebPages.Razor.dll

Binary files differ

 NETERPNoWin/bin/x86/Debug/System.Web.WebPages.Razor.xml

File was deleted

 NETERPNoWin/bin/x86/Debug/System.Web.WebPages.dll

Binary files differ

 NETERPNoWin/bin/x86/Debug/System.Web.WebPages.xml

File was deleted

 NETERPNoWin/bin/x86/Debug/Tea.dll

Binary files differ

 NETERPNoWin/bin/x86/Debug/WebActivatorEx.dll

Binary files differ

 NETERPNoWin/bin/x86/Debug/grpc_csharp_ext.x64.dll

Binary files differ

 NETERPNoWin/bin/x86/Debug/grpc_csharp_ext.x86.dll

Binary files differ

 NETERPNoWin/bin/x86/Debug/libgrpc_csharp_ext.x64.dylib

Binary files differ

 NETERPNoWin/bin/x86/Debug/libgrpc_csharp_ext.x64.so

Binary files differ

 NETERPNoWin/bin/x86/Debug/zh-Hans/System.Net.Http.Formatting.resources.dll

Binary files differ

 NETERPNoWin/bin/x86/Debug/zh-Hans/System.Web.Http.resources.dll

Binary files differ

 NETERPNoWin/obj/x86/Debug/DesignTimeResolveAssemblyReferencesInput.cache

Binary files differ

 NETERPNoWin/obj/x86/Debug/NETERPNoWin.csproj.FileListAbsolute.txt

@@ -287,123 +287,6 @@
D:\WorkBench\MES-WEB-API\NETERPNoWin\obj\x86\Debug\NETERPNoWin.MESMain.resources
D:\WorkBench\MES-WEB-API\NETERPNoWin\obj\x86\Debug\NETERPNoWin.csproj.GenerateResource.cache
D:\WorkBench\MES-WEB-API\NETERPNoWin\obj\x86\Debug\NETERPNoWin.csproj.CoreCompileInputs.cache
D:\GitHub\MES-WEB-API\NETERPNoWin\bin\x86\Debug\grpc_csharp_ext.x86.dll
D:\GitHub\MES-WEB-API\NETERPNoWin\bin\x86\Debug\grpc_csharp_ext.x64.dll
D:\GitHub\MES-WEB-API\NETERPNoWin\bin\x86\Debug\libgrpc_csharp_ext.x64.so
D:\GitHub\MES-WEB-API\NETERPNoWin\bin\x86\Debug\libgrpc_csharp_ext.x64.dylib
D:\GitHub\MES-WEB-API\NETERPNoWin\bin\x86\Debug\Models\ClsSc_MouldScrapOutBillMain.cs
D:\GitHub\MES-WEB-API\NETERPNoWin\bin\x86\Debug\NETERPNoWin.exe.config
D:\GitHub\MES-WEB-API\NETERPNoWin\bin\x86\Debug\NETERPNoWin.exe
D:\GitHub\MES-WEB-API\NETERPNoWin\bin\x86\Debug\NETERPNoWin.pdb
D:\GitHub\MES-WEB-API\NETERPNoWin\bin\x86\Debug\BaseSet.dll
D:\GitHub\MES-WEB-API\NETERPNoWin\bin\x86\Debug\BLL.dll
D:\GitHub\MES-WEB-API\NETERPNoWin\bin\x86\Debug\DAL.dll
D:\GitHub\MES-WEB-API\NETERPNoWin\bin\x86\Debug\DBUtility.dll
D:\GitHub\MES-WEB-API\NETERPNoWin\bin\x86\Debug\Kanban.dll
D:\GitHub\MES-WEB-API\NETERPNoWin\bin\x86\Debug\Model.dll
D:\GitHub\MES-WEB-API\NETERPNoWin\bin\x86\Debug\OAM.dll
D:\GitHub\MES-WEB-API\NETERPNoWin\bin\x86\Debug\PlanM.dll
D:\GitHub\MES-WEB-API\NETERPNoWin\bin\x86\Debug\Pub_Class.dll
D:\GitHub\MES-WEB-API\NETERPNoWin\bin\x86\Debug\Pub_Control.dll
D:\GitHub\MES-WEB-API\NETERPNoWin\bin\x86\Debug\SQLHelper.dll
D:\GitHub\MES-WEB-API\NETERPNoWin\bin\x86\Debug\WarM.dll
D:\GitHub\MES-WEB-API\NETERPNoWin\bin\x86\Debug\WorkM.dll
D:\GitHub\MES-WEB-API\NETERPNoWin\bin\x86\Debug\AxInterop.gregn6Lib.dll
D:\GitHub\MES-WEB-API\NETERPNoWin\bin\x86\Debug\NPOI.dll
D:\GitHub\MES-WEB-API\NETERPNoWin\bin\x86\Debug\M2Mqtt.Net.dll
D:\GitHub\MES-WEB-API\NETERPNoWin\bin\x86\Debug\NPOI.OOXML.dll
D:\GitHub\MES-WEB-API\NETERPNoWin\bin\x86\Debug\WebAPI.dll
D:\GitHub\MES-WEB-API\NETERPNoWin\bin\x86\Debug\Newtonsoft.Json.dll
D:\GitHub\MES-WEB-API\NETERPNoWin\bin\x86\Debug\AxInterop.grdes6Lib.dll
D:\GitHub\MES-WEB-API\NETERPNoWin\bin\x86\Debug\Interop.gregn6Lib.dll
D:\GitHub\MES-WEB-API\NETERPNoWin\bin\x86\Debug\ICSharpCode.SharpZipLib.dll
D:\GitHub\MES-WEB-API\NETERPNoWin\bin\x86\Debug\BouncyCastle.Crypto.dll
D:\GitHub\MES-WEB-API\NETERPNoWin\bin\x86\Debug\NPOI.OpenXml4Net.dll
D:\GitHub\MES-WEB-API\NETERPNoWin\bin\x86\Debug\NPOI.OpenXmlFormats.dll
D:\GitHub\MES-WEB-API\NETERPNoWin\bin\x86\Debug\WebActivatorEx.dll
D:\GitHub\MES-WEB-API\NETERPNoWin\bin\x86\Debug\System.Web.Optimization.dll
D:\GitHub\MES-WEB-API\NETERPNoWin\bin\x86\Debug\System.Web.Mvc.dll
D:\GitHub\MES-WEB-API\NETERPNoWin\bin\x86\Debug\Swashbuckle.Core.dll
D:\GitHub\MES-WEB-API\NETERPNoWin\bin\x86\Debug\System.Web.Http.dll
D:\GitHub\MES-WEB-API\NETERPNoWin\bin\x86\Debug\System.Web.Http.Cors.dll
D:\GitHub\MES-WEB-API\NETERPNoWin\bin\x86\Debug\RestSharp.dll
D:\GitHub\MES-WEB-API\NETERPNoWin\bin\x86\Debug\Kingdee.BOS.WebApi.Client.dll
D:\GitHub\MES-WEB-API\NETERPNoWin\bin\x86\Debug\AlibabaCloud.SDK.Dingtalk.dll
D:\GitHub\MES-WEB-API\NETERPNoWin\bin\x86\Debug\AlibabaCloud.OpenApiClient.dll
D:\GitHub\MES-WEB-API\NETERPNoWin\bin\x86\Debug\Tea.dll
D:\GitHub\MES-WEB-API\NETERPNoWin\bin\x86\Debug\TopSdk.dll
D:\GitHub\MES-WEB-API\NETERPNoWin\bin\x86\Debug\System.Web.Http.WebHost.dll
D:\GitHub\MES-WEB-API\NETERPNoWin\bin\x86\Debug\System.Net.Http.Formatting.dll
D:\GitHub\MES-WEB-API\NETERPNoWin\bin\x86\Debug\Dapper.dll
D:\GitHub\MES-WEB-API\NETERPNoWin\bin\x86\Debug\AlibabaCloud.TeaUtil.dll
D:\GitHub\MES-WEB-API\NETERPNoWin\bin\x86\Debug\Microsoft.Web.Infrastructure.dll
D:\GitHub\MES-WEB-API\NETERPNoWin\bin\x86\Debug\System.Web.Razor.dll
D:\GitHub\MES-WEB-API\NETERPNoWin\bin\x86\Debug\System.Web.WebPages.Razor.dll
D:\GitHub\MES-WEB-API\NETERPNoWin\bin\x86\Debug\System.Web.WebPages.dll
D:\GitHub\MES-WEB-API\NETERPNoWin\bin\x86\Debug\System.Web.Cors.dll
D:\GitHub\MES-WEB-API\NETERPNoWin\bin\x86\Debug\AlibabaCloud.GatewayDingTalk.dll
D:\GitHub\MES-WEB-API\NETERPNoWin\bin\x86\Debug\AlibabaCloud.GatewaySpi.dll
D:\GitHub\MES-WEB-API\NETERPNoWin\bin\x86\Debug\AlibabaCloud.OpenApiUtil.dll
D:\GitHub\MES-WEB-API\NETERPNoWin\bin\x86\Debug\AlibabaCloud.TeaXML.dll
D:\GitHub\MES-WEB-API\NETERPNoWin\bin\x86\Debug\System.Web.WebPages.Deployment.dll
D:\GitHub\MES-WEB-API\NETERPNoWin\bin\x86\Debug\Aliyun.Credentials.dll
D:\GitHub\MES-WEB-API\NETERPNoWin\bin\x86\Debug\BaseSet.pdb
D:\GitHub\MES-WEB-API\NETERPNoWin\bin\x86\Debug\BLL.pdb
D:\GitHub\MES-WEB-API\NETERPNoWin\bin\x86\Debug\DAL.pdb
D:\GitHub\MES-WEB-API\NETERPNoWin\bin\x86\Debug\DBUtility.pdb
D:\GitHub\MES-WEB-API\NETERPNoWin\bin\x86\Debug\Kanban.pdb
D:\GitHub\MES-WEB-API\NETERPNoWin\bin\x86\Debug\Model.pdb
D:\GitHub\MES-WEB-API\NETERPNoWin\bin\x86\Debug\OAM.pdb
D:\GitHub\MES-WEB-API\NETERPNoWin\bin\x86\Debug\PlanM.pdb
D:\GitHub\MES-WEB-API\NETERPNoWin\bin\x86\Debug\Pub_Class.pdb
D:\GitHub\MES-WEB-API\NETERPNoWin\bin\x86\Debug\Pub_Control.pdb
D:\GitHub\MES-WEB-API\NETERPNoWin\bin\x86\Debug\SQLHelper.pdb
D:\GitHub\MES-WEB-API\NETERPNoWin\bin\x86\Debug\WarM.pdb
D:\GitHub\MES-WEB-API\NETERPNoWin\bin\x86\Debug\WarM.dll.config
D:\GitHub\MES-WEB-API\NETERPNoWin\bin\x86\Debug\WorkM.pdb
D:\GitHub\MES-WEB-API\NETERPNoWin\bin\x86\Debug\NPOI.pdb
D:\GitHub\MES-WEB-API\NETERPNoWin\bin\x86\Debug\NPOI.xml
D:\GitHub\MES-WEB-API\NETERPNoWin\bin\x86\Debug\M2Mqtt.Net.pdb
D:\GitHub\MES-WEB-API\NETERPNoWin\bin\x86\Debug\NPOI.OOXML.pdb
D:\GitHub\MES-WEB-API\NETERPNoWin\bin\x86\Debug\NPOI.OOXML.xml
D:\GitHub\MES-WEB-API\NETERPNoWin\bin\x86\Debug\WebAPI.pdb
D:\GitHub\MES-WEB-API\NETERPNoWin\bin\x86\Debug\WebAPI.dll.config
D:\GitHub\MES-WEB-API\NETERPNoWin\bin\x86\Debug\ICSharpCode.SharpZipLib.pdb
D:\GitHub\MES-WEB-API\NETERPNoWin\bin\x86\Debug\ICSharpCode.SharpZipLib.xml
D:\GitHub\MES-WEB-API\NETERPNoWin\bin\x86\Debug\BouncyCastle.Crypto.xml
D:\GitHub\MES-WEB-API\NETERPNoWin\bin\x86\Debug\NPOI.OpenXml4Net.pdb
D:\GitHub\MES-WEB-API\NETERPNoWin\bin\x86\Debug\NPOI.OpenXmlFormats.pdb
D:\GitHub\MES-WEB-API\NETERPNoWin\bin\x86\Debug\System.Web.Optimization.xml
D:\GitHub\MES-WEB-API\NETERPNoWin\bin\x86\Debug\System.Web.Mvc.xml
D:\GitHub\MES-WEB-API\NETERPNoWin\bin\x86\Debug\System.Web.Http.xml
D:\GitHub\MES-WEB-API\NETERPNoWin\bin\x86\Debug\System.Web.Http.Cors.xml
D:\GitHub\MES-WEB-API\NETERPNoWin\bin\x86\Debug\RestSharp.xml
D:\GitHub\MES-WEB-API\NETERPNoWin\bin\x86\Debug\TopSdk.pdb
D:\GitHub\MES-WEB-API\NETERPNoWin\bin\x86\Debug\System.Net.Http.Formatting.xml
D:\GitHub\MES-WEB-API\NETERPNoWin\bin\x86\Debug\Dapper.xml
D:\GitHub\MES-WEB-API\NETERPNoWin\bin\x86\Debug\System.Web.Razor.xml
D:\GitHub\MES-WEB-API\NETERPNoWin\bin\x86\Debug\System.Web.WebPages.Razor.xml
D:\GitHub\MES-WEB-API\NETERPNoWin\bin\x86\Debug\System.Web.WebPages.xml
D:\GitHub\MES-WEB-API\NETERPNoWin\bin\x86\Debug\System.Web.WebPages.Deployment.xml
D:\GitHub\MES-WEB-API\NETERPNoWin\bin\x86\Debug\zh-Hans\System.Web.Http.resources.dll
D:\GitHub\MES-WEB-API\NETERPNoWin\bin\x86\Debug\zh-Hans\System.Net.Http.Formatting.resources.dll
D:\GitHub\MES-WEB-API\NETERPNoWin\bin\x86\Debug\WebAPI.XmlSerializers.dll
D:\GitHub\MES-WEB-API\NETERPNoWin\obj\x86\Debug\NETERPNoWin.csproj.AssemblyReference.cache
D:\GitHub\MES-WEB-API\NETERPNoWin\obj\x86\Debug\Interop.gregn6Lib.dll
D:\GitHub\MES-WEB-API\NETERPNoWin\obj\x86\Debug\NETERPNoWin.csproj.ResolveComReference.cache
D:\GitHub\MES-WEB-API\NETERPNoWin\obj\x86\Debug\NETERPNoWin.Form1.resources
D:\GitHub\MES-WEB-API\NETERPNoWin\obj\x86\Debug\NETERPNoWin.Frm_MESSetIni.resources
D:\GitHub\MES-WEB-API\NETERPNoWin\obj\x86\Debug\NETERPNoWin.OA_MessageBox.resources
D:\GitHub\MES-WEB-API\NETERPNoWin\obj\x86\Debug\NETERPNoWin.Frm_Show.resources
D:\GitHub\MES-WEB-API\NETERPNoWin\obj\x86\Debug\NETERPNoWin.MDIMain.resources
D:\GitHub\MES-WEB-API\NETERPNoWin\obj\x86\Debug\NETERPNoWin.Properties.Resources.resources
D:\GitHub\MES-WEB-API\NETERPNoWin\obj\x86\Debug\NETERPNoWin.Xt_Wait.resources
D:\GitHub\MES-WEB-API\NETERPNoWin\obj\x86\Debug\NETERPNoWin.MESMain.resources
D:\GitHub\MES-WEB-API\NETERPNoWin\obj\x86\Debug\NETERPNoWin.csproj.GenerateResource.cache
D:\GitHub\MES-WEB-API\NETERPNoWin\obj\x86\Debug\NETERPNoWin.csproj.CoreCompileInputs.cache
D:\GitHub\MES-WEB-API\NETERPNoWin\obj\x86\Debug\NETERPNoWin.csproj.CopyComplete
D:\GitHub\MES-WEB-API\NETERPNoWin\obj\x86\Debug\NETERPNoWin.exe
D:\GitHub\MES-WEB-API\NETERPNoWin\obj\x86\Debug\NETERPNoWin.pdb
D:\WMES\MES-WEB-API\NETERPNoWin\bin\x86\Debug\grpc_csharp_ext.x86.dll
D:\WMES\MES-WEB-API\NETERPNoWin\bin\x86\Debug\grpc_csharp_ext.x64.dll
D:\WMES\MES-WEB-API\NETERPNoWin\bin\x86\Debug\libgrpc_csharp_ext.x64.so

 WebAPI/Controllers/BaseSet/Gy_BadReasonController.cs

@@ -89,6 +89,73 @@
                return objJsonResult;
            }
        }
        #region ä¸è‰¯åŽŸå› å­˜å‚¨è¿‡ç¨‹
        /// <summary>
        /// è¿”回不良原因列表
        /// </summary>
        [Route("Gy_BadReason/list_1")]
        [HttpGet]
        public object list_1(string sWhere, string user,int HMaterID,string HBillType,string OrgID)
        {
            try
            {
                List<object> columnNameList = new List<object>();
                //查看权限
                if (!DBUtility.ClsPub.Security_Log("Gy_BadReason_Query", 1, false, user))
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "无查看权限！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }

                if (sWhere == null || sWhere.Equals(""))
                {
                    sWhere = "and 1=1";
                }
                else
                    sWhere = sWhere.Replace("'","''");
                ds = oCN.RunProcReturn("exec h_p_IF_BadReasonList " + HMaterID +",'"+ HBillType + "',"  + OrgID + ",'" + sWhere +"'"+ "  ", "h_p_IF_BadReasonList");

               

                //添加列名
                foreach (DataColumn col in ds.Tables[0].Columns)
                {
                    Type dataType = col.DataType;
                    string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}";
                    columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//获取到DataColumn列对象的列名
                }

                //if (ds.Tables[0].Rows.Count != 0 || ds != null)
                //{
                objJsonResult.code = "1";
                objJsonResult.count = 1;
                objJsonResult.Message = "Sucess！";
                objJsonResult.data = ds.Tables[0];
                objJsonResult.list = columnNameList;
                return objJsonResult;
                //}
                //else
                //{
                //objJsonResult.code = "0";
                //objJsonResult.count = 0;
                //objJsonResult.Message = "无数据";
                //objJsonResult.data = null;
                //return objJsonResult;
                //}
            }
            catch (Exception e)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "Exception！" + e.ToString();
                objJsonResult.data = null;
                return objJsonResult;
            }
        }
        #endregion

        #region ä¸è‰¯åŽŸå› å®¡æ ¸ã€åå®¡æ ¸
        /// <summary>

 WebAPI/Controllers/³É±¾¹ÜÀí/CB_ItemMoneyBillController.cs

@@ -1319,7 +1319,7 @@
                    {
                        // æ’入主表（每组插入一次）
                        insertSql.AppendLine($"INSERT INTO CB_ItemMoneyBillMain  ([HInterID], [HBillNo], [HDate], [HYear], [HPeriod], [HBillType], [HBillSubType], [HBillStatus], [HCheckItemNowID], [HCheckItemNextID], [HCheckFlowID], [HRemark], [HBacker], [HBackDate], [HBackRemark], [HChecker], [HCheckDate], [HMaker], [HMakeDate], [HUpDater], [HUpDateDate], [HCloseMan], [HCloseDate], [HCloseType], [HDeleteMan], [HDeleteDate], [HMainSourceBillType], [HMainSourceInterID], [HMainSourceEntryID], [HMainSourceBillNo], [HPrintQty],  [HEmpID], [HDeptID], [HICMOInterID], [HMaterID], [HICMOBillNo], [HExplanation], [HInnerBillNo], [HBeginDate], [HEndDate], [HOrgID]) VALUES (");
                        insertSql.AppendLine($"'{HInterID}', '{HBillNo}', '{DateTime.Now}', {DateTime.Now.Year}, {DateTime.Now.Month}, {"1802"}, '{"1802"}', '{"1"}',  '{"0"}', '{"0"}', '{"0"}', '{"excel导入"}', '{""}', '{DateTime.Now}', '{""}', '{""}', '{DateTime.Now}', '{""}', '{DateTime.Now}', '{""}', '{DateTime.Now}', '{""}', '{DateTime.Now}', '{"0"}', '{""}', '{DateTime.Now}', '{""}', '{"0"}', '{"0"}', '{""}', '{"0"}', '{EmpID}', '{HSupplierID}', '{ICMOInterID}','{0}','{ICMO}','{""}','{"0"}','{DateTime.Now}','{DateTime.Now}','{"100038"}');");
                        insertSql.AppendLine($"'{HInterID}', '{HBillNo}', '{DateTime.Now}', {list[0]["年份"]}, {list[0]["月份"]}, {"1802"}, '{"1802"}', '{"1"}',  '{"0"}', '{"0"}', '{"0"}', '{"excel导入"}', '{""}', '{DateTime.Now}', '{""}', '{""}', '{DateTime.Now}', '{""}', '{DateTime.Now}', '{""}', '{DateTime.Now}', '{""}', '{DateTime.Now}', '{"0"}', '{""}', '{DateTime.Now}', '{""}', '{"0"}', '{"0"}', '{""}', '{"0"}', '{EmpID}', '{HSupplierID}', '{ICMOInterID}','{0}','{ICMO}','{""}','{"0"}','{DateTime.Now}','{DateTime.Now}','{"100038"}');");

                        // æ’入子表（组内每个物料插入一次）
                        int HEntryID = 1;

 WebAPI/Controllers/³É±¾¹ÜÀí/CB_WipProcessTableController.cs

@@ -228,7 +228,7 @@


                    insertSql.AppendLine($"INSERT INTO CB_WipProcessTable  ([HYear], [HPeriod], [HDay], [HProcName], [HCusName], [HPartNumber], [HWIPQty], [HInProcessWIPQty], [HPanelQty], [HLot], [HOrderTime], [HStartTime], [HOutputTime], [HProductionTime], [HStatus], [HStayTime], [HChecker], [HCheckDate], [HMaker], [HMakeDate], [HUpDater], [HUpDateDate], [HCloseMan], [HCloseDate], [HCloseType], [HDeleteMan], [HDeleteDate], [HReamrk]) VALUES (");
                    insertSql.AppendLine($" {DateTime.Now.Year}, {DateTime.Now.Month}, {DateTime.Now.Day}, '{item["产出工序"]}', '{item["客户"]}',  '{item["成品料号"]}', '{item["WIP数量"]}', '{item["在制WIP数量"]}', '{item["拼版数"]}', '{item["LOT"]}', '{item["下单时间"]}', '{item["投产时间"]}', '{item["产出时间"]}', '{item["生产时间"]}', '{item["状态"]}', '{item["停留时间(分钟)"]}', '{""}', '{""}', '{user}', '{DateTime.Now}', '{""}', '{DateTime.Now}', '{""}', '{""}', '{"0"}', '{""}', '{""}', '{"excel导入"}');");
                    insertSql.AppendLine($" {item["年份"]}, {item["月份"]}, {DateTime.Now.Day}, '{item["产出工序"]}', '{item["客户"]}',  '{item["成品料号"]}', '{item["WIP数量"]}', '{item["在制WIP数量"]}', '{item["拼版数"]}', '{item["LOT"]}', '{item["下单时间"]}', '{item["投产时间"]}', '{item["产出时间"]}', '{item["生产时间"]}', '{item["状态"]}', '{item["停留时间(分钟)"]}', '{""}', '{""}', '{user}', '{DateTime.Now}', '{""}', '{DateTime.Now}', '{""}', '{""}', '{"0"}', '{""}', '{""}', '{"excel导入"}');");
                }

                if (errorMessage.Length > 0)

 WebAPI/DLL/ClsGy_BadReason_Ctl.cs

@@ -37,10 +37,10 @@
                oCn.RunProc("Insert into " + MvarItemKey + " " +
                    " (HNumber,HName,HHelpCode,HShortNumber,HParentID" +
                    ",HDeptID,HProcID,HUseFlag,HUSEORGID,HCREATEORGID,HMakeEmp,HMakeTime" +
                    ",HLevel,HEndFlag,HStopflag,HRemark,HBadTypeID) " +
                    ",HLevel,HEndFlag,HStopflag,HRemark,HBadTypeID,HMaterTypeID) " +
                    " Values('" + oModel.HNumber + "','" + oModel.HName + "','" + oModel.HHelpCode + "','" + oModel.HShortNumber + "'," + oModel.HParentID.ToString() +
                    "," + oModel.HDeptID.ToString() + "," + oModel.HProcID.ToString() + ",'" + oModel.HUseFlag.ToString() + "'," + oModel.HUSEORGID.ToString() + "," + oModel.HCREATEORGID.ToString() + ",'" + oModel.HMakeEmp.ToString() + "',getdate()" +
                    "," + oModel.HLevel.ToString() + "," + Convert.ToString(oModel.HEndFlag ? 1 : 0) + "," + Convert.ToString(oModel.HStopflag ? 1 : 0) + ",'" + oModel.HRemark + "',"+oModel.HBadTypeID + ")", ref DBUtility.ClsPub.sExeReturnInfo);
                    "," + oModel.HLevel.ToString() + "," + Convert.ToString(oModel.HEndFlag ? 1 : 0) + "," + Convert.ToString(oModel.HStopflag ? 1 : 0) + ",'" + oModel.HRemark + "',"+oModel.HBadTypeID +","+oModel.HMaterTypeID + ")", ref DBUtility.ClsPub.sExeReturnInfo);
                //修改上级为非末级代码
                oCn.RunProc("Update " + MvarItemKey + " set HEndflag=0 where HItemID=" + oModel.HParentID, ref DBUtility.ClsPub.sExeReturnInfo);

@@ -108,6 +108,7 @@
                    ",HUSEORGID='" + oModel.HUSEORGID + "'" +
                    ",HCREATEORGID='" + oModel.HCREATEORGID + "'" +
                    ",HModifyEmp ='" + oModel.HMakeEmp + "'" +
                    ",HMaterTypeID ='" + oModel.HMaterTypeID + "'" +
                    ",HModifyTime=getdate()" +
                    ",HRemark= '" + oModel.HRemark + "' Where HItemID=" + sItemID, ref DBUtility.ClsPub.sExeReturnInfo);
                //修改子项目代码