From e35e12fd728cf2ff1b1b3a0241408571ad7157c7 Mon Sep 17 00:00:00 2001
From: wtt <1985833171@qq.com>
Date: 星期一, 04 八月 2025 22:04:57 +0800
Subject: [PATCH] Merge branch 'master' of http://101.37.171.70:10101/r/MES-WEB-API
---
SyntacticSugar/obj/Debug/DesignTimeResolveAssemblyReferencesInput.cache | 0
NETERPNoWin/obj/Debug/NETERPNoWin.csproj.ResolveComReference.cache | 0
WebAPI/Controllers/仓存管理/条码生成/Sc_BarCodeController.cs | 76 ++++++++++++++++++++------------------
SyntacticSugar/obj/Debug/SyntacticSugar.csproj.AssemblyReference.cache | 0
BaseSet/Properties/Resources.Designer.cs | 2
BaseSet/BaseSet.csproj | 2
sdk_dingding/TopSdk/obj/Debug/DesignTimeResolveAssemblyReferencesInput.cache | 0
7 files changed, 42 insertions(+), 38 deletions(-)
diff --git a/BaseSet/BaseSet.csproj b/BaseSet/BaseSet.csproj
index 7e74db1..520e1fe 100644
--- a/BaseSet/BaseSet.csproj
+++ b/BaseSet/BaseSet.csproj
@@ -10,7 +10,7 @@
<AppDesignerFolder>Properties</AppDesignerFolder>
<RootNamespace>BaseSet</RootNamespace>
<AssemblyName>BaseSet</AssemblyName>
- <TargetFrameworkVersion>v4.5</TargetFrameworkVersion>
+ <TargetFrameworkVersion>v4.8</TargetFrameworkVersion>
<FileUpgradeFlags>
</FileUpgradeFlags>
<UpgradeBackupLocation>
diff --git a/BaseSet/Properties/Resources.Designer.cs b/BaseSet/Properties/Resources.Designer.cs
index 2165ea5..ed7e104 100644
--- a/BaseSet/Properties/Resources.Designer.cs
+++ b/BaseSet/Properties/Resources.Designer.cs
@@ -19,7 +19,7 @@
// 绫婚�氳繃绫讳技浜� ResGen 鎴� Visual Studio 鐨勫伐鍏疯嚜鍔ㄧ敓鎴愮殑銆�
// 鑻ヨ娣诲姞鎴栫Щ闄ゆ垚鍛橈紝璇风紪杈� .ResX 鏂囦欢锛岀劧鍚庨噸鏂拌繍琛� ResGen
// (浠� /str 浣滀负鍛戒护閫夐」)锛屾垨閲嶆柊鐢熸垚 VS 椤圭洰銆�
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Resources.Tools.StronglyTypedResourceBuilder", "16.0.0.0")]
+ [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Resources.Tools.StronglyTypedResourceBuilder", "17.0.0.0")]
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.Runtime.CompilerServices.CompilerGeneratedAttribute()]
internal class Resources {
diff --git a/NETERPNoWin/obj/Debug/NETERPNoWin.csproj.ResolveComReference.cache b/NETERPNoWin/obj/Debug/NETERPNoWin.csproj.ResolveComReference.cache
index 5a3c3a7..8c217ee 100644
--- a/NETERPNoWin/obj/Debug/NETERPNoWin.csproj.ResolveComReference.cache
+++ b/NETERPNoWin/obj/Debug/NETERPNoWin.csproj.ResolveComReference.cache
Binary files differ
diff --git a/SyntacticSugar/obj/Debug/DesignTimeResolveAssemblyReferencesInput.cache b/SyntacticSugar/obj/Debug/DesignTimeResolveAssemblyReferencesInput.cache
new file mode 100644
index 0000000..5dae3dc
--- /dev/null
+++ b/SyntacticSugar/obj/Debug/DesignTimeResolveAssemblyReferencesInput.cache
Binary files differ
diff --git a/SyntacticSugar/obj/Debug/SyntacticSugar.csproj.AssemblyReference.cache b/SyntacticSugar/obj/Debug/SyntacticSugar.csproj.AssemblyReference.cache
index fea44e6..18bc5ef 100644
--- a/SyntacticSugar/obj/Debug/SyntacticSugar.csproj.AssemblyReference.cache
+++ b/SyntacticSugar/obj/Debug/SyntacticSugar.csproj.AssemblyReference.cache
Binary files differ
diff --git "a/WebAPI/Controllers/\344\273\223\345\255\230\347\256\241\347\220\206/\346\235\241\347\240\201\347\224\237\346\210\220/Sc_BarCodeController.cs" "b/WebAPI/Controllers/\344\273\223\345\255\230\347\256\241\347\220\206/\346\235\241\347\240\201\347\224\237\346\210\220/Sc_BarCodeController.cs"
index 1bfb40e..0af2208 100644
--- "a/WebAPI/Controllers/\344\273\223\345\255\230\347\256\241\347\220\206/\346\235\241\347\240\201\347\224\237\346\210\220/Sc_BarCodeController.cs"
+++ "b/WebAPI/Controllers/\344\273\223\345\255\230\347\256\241\347\220\206/\346\235\241\347\240\201\347\224\237\346\210\220/Sc_BarCodeController.cs"
@@ -159,7 +159,7 @@
#region [閫氳繃婧愬崟绫诲瀷鏌ユ壘涓嶉�氬崟鎹俊鎭痌
[Route("Sc_BarCode/ReportFromBillList")]
[HttpGet]
- public object ReportFromBillList(int page, int limit, string sWhere,string HSouceBillType,string HOrgID)
+ public object ReportFromBillList(int page, int limit, string sWhere, string HSouceBillType, string HOrgID)
{
oSystemParameter.ShowBill(ref DBUtility.ClsPub.sExeReturnInfo);
List<object> columnNameList = new List<object>();
@@ -172,7 +172,7 @@
string tabname = "";
if (sWhere == null || sWhere.Equals(""))
{
- sWhere = " where 1=1 and HOrgID='"+HOrgID+"' ";
+ sWhere = " where 1=1 and HOrgID='" + HOrgID + "' ";
}
else
{
@@ -181,8 +181,8 @@
switch (HSouceBillType)
{
case "鐢熶骇璁㈠崟":
- tabname = "h_v_IFCLD_ICMOBillList_Source";
- count = new SQLHelper.ClsCN().RunProcReturn("select * from h_v_IFCLD_ICMOBillList_Source "+sWhere+ " and 浠诲姟鏁伴噺>isnull(鍏ュ簱鏁伴噺,0) and 鐘舵��<>'缁撴' order by 鍗曟嵁鍙�", tabname).Tables[0].Rows.Count;
+ tabname = "h_v_IFCLD_ICMOBillList_Source";
+ count = new SQLHelper.ClsCN().RunProcReturn("select * from h_v_IFCLD_ICMOBillList_Source " + sWhere + " and 浠诲姟鏁伴噺>isnull(鍏ュ簱鏁伴噺,0) and 鐘舵��<>'缁撴' order by 鍗曟嵁鍙�", tabname).Tables[0].Rows.Count;
sql = string.Format(@"select * from(select row_number() over (order by 鍗曟嵁鍙�) as HRowNumber,* from h_v_IFCLD_ICMOBillList_Source " + sWhere + " and 浠诲姟鏁伴噺>isnull(鍏ュ簱鏁伴噺,0) and 鐘舵��<>'缁撴') as A where HRowNumber >" + pageSize + " *(" + pageNum + "-1)");
break;
case "鐢熶骇姹囨姤鍗�":
@@ -343,7 +343,7 @@
List<object> ListRows = new List<object>();
try
{
-
+
msg2 = msg2.Replace("\\", "");
msg2 = msg2.Replace("\n", ""); //\n
List<DBUtility.BillSelect> oList = Newtonsoft.Json.JsonConvert.DeserializeObject<List<DBUtility.BillSelect>>(msg2);
@@ -356,7 +356,7 @@
//寰楀埌淇℃伅
ds = oCN.RunProcReturn("select * from h_v_IFCLD_ICMOList where hmainid=" + oSelectRow.BillMainID + " and hsubid=" + oSelectRow.BillSubID, "h_v_IFCLD_ICMOList");
//鍐欏叆淇℃伅
- ListRows.Add(HSourceOrderList(ds.Tables[0],ordrlist, HBarCodeType));
+ ListRows.Add(HSourceOrderList(ds.Tables[0], ordrlist, HBarCodeType));
break;
case "3711": //鐢熶骇姹囨姤鍗�
//寰楀埌淇℃伅
@@ -389,7 +389,7 @@
ListRows.Add(HSourceOrderList1(ds.Tables[0], ordrlist, HBarCodeType, HSourceBillType));
break;
case "1202": //鐢熶骇鍏ュ簱
- //寰楀埌淇℃伅
+ //寰楀埌淇℃伅
ds = oWebs.getDataSetBySQL("select * from h_v_IF_ProductInBillList_Source where HMainID=" + oSelectRow.BillMainID + " and HSubID=" + oSelectRow.BillSubID, "h_v_IF_ProductInBillList_Source", ref DBUtility.ClsPub.sExeReturnInfo);
//鍐欏叆淇℃伅
ListRows.Add(Sub_WriteInForm_InOut(ds.Tables[0], ordrlist, HBarCodeType, HSourceBillType));
@@ -456,7 +456,7 @@
return objJsonResult;
}
- public object HSourceOrderList(DataTable dt, HSouceOrderList ordrlist,string HBarCodeType)
+ public object HSourceOrderList(DataTable dt, HSouceOrderList ordrlist, string HBarCodeType)
{
oSystemParameter.ShowBill(ref DBUtility.ClsPub.sExeReturnInfo);
for (int i = 0; i < dt.Rows.Count; i++)
@@ -510,7 +510,7 @@
{
ordrlist.HMinQty = dt.Rows[i]["鏈敓鎴愭潯鐮佹暟閲�"].ToString();
}
- else if (HBarCodeType == "浠櫒澶栬喘浠舵潯鐮佹櫘閫氳鍒�"|| HBarCodeType == "浠櫒鎴愬搧鏉＄爜瑙勫垯"|| HBarCodeType == "璇曞墏鎴愬搧鏉＄爜瑙勫垯")
+ else if (HBarCodeType == "浠櫒澶栬喘浠舵潯鐮佹櫘閫氳鍒�" || HBarCodeType == "浠櫒鎴愬搧鏉＄爜瑙勫垯" || HBarCodeType == "璇曞墏鎴愬搧鏉＄爜瑙勫垯")
{
ordrlist.HMinQty = "1";
}
@@ -522,7 +522,7 @@
return ordrlist;
}
- public object HSourceOrderList1(DataTable dt, HSouceOrderList ordrlist, string HBarCodeType,string HSourceBillType)
+ public object HSourceOrderList1(DataTable dt, HSouceOrderList ordrlist, string HBarCodeType, string HSourceBillType)
{
oSystemParameter.ShowBill(ref DBUtility.ClsPub.sExeReturnInfo);
for (int i = 0; i < dt.Rows.Count; i++)
@@ -549,7 +549,7 @@
ordrlist.HRemark = dt.Rows[i]["澶囨敞"].ToString();
ordrlist.HMTONo = dt.Rows[i]["璁″垝璺熻釜鍙�"].ToString();
- if(HSourceBillType == "鏀舵枡閫氱煡鍗�")
+ if (HSourceBillType == "鏀舵枡閫氱煡鍗�")
{
if (oSystemParameter.omodel.WMS_CampanyName != "鐟炰笌绁�")
{
@@ -572,10 +572,10 @@
ordrlist.HMinQty = dt.Rows[i]["鏈�灏忓寘瑁呮暟"].ToString();
}
ordrlist.HMaker = ClsPub.CurUserName;
- if (HSourceBillType== "鏀舵枡閫氱煡鍗�"|| HSourceBillType== "閲囪喘璁㈠崟"|| HSourceBillType=="濮斿璁㈠崟"|| HSourceBillType== "閲囪喘鍏ュ簱鍗�")
+ if (HSourceBillType == "鏀舵枡閫氱煡鍗�" || HSourceBillType == "閲囪喘璁㈠崟" || HSourceBillType == "濮斿璁㈠崟" || HSourceBillType == "閲囪喘鍏ュ簱鍗�")
{
ordrlist.HInnerBillNo = dt.Rows[i]["鍐呴儴閲囪喘璁㈠崟鍙�"].ToString();
- ordrlist.HSupID= dt.Rows[i]["hsupid"].ToString();
+ ordrlist.HSupID = dt.Rows[i]["hsupid"].ToString();
ordrlist.HSupNumber = dt.Rows[i]["渚涘簲鍟嗕唬鐮�"].ToString();
ordrlist.HSupName = dt.Rows[i]["渚涘簲鍟�"].ToString();
if (HSourceBillType == "鏀舵枡閫氱煡鍗�")
@@ -594,7 +594,7 @@
{
ordrlist.HCusID = dt.Rows[i]["HCusID"].ToString();
ordrlist.HCusNumber = dt.Rows[i]["瀹㈡埛浠ｇ爜"].ToString();
- ordrlist.HCusName= dt.Rows[i]["瀹㈡埛"].ToString();
+ ordrlist.HCusName = dt.Rows[i]["瀹㈡埛"].ToString();
}
if (HSourceBillType == "鍏朵粬鍏ュ簱鍗�" || HSourceBillType == "棰嗘枡鍑哄簱鍗�")
{
@@ -605,7 +605,7 @@
ordrlist.HSPNumber = dt.Rows[i]["浠撲綅浠ｇ爜"].ToString();
ordrlist.HSPName = dt.Rows[i]["浠撲綅"].ToString();
}
- if(HSourceBillType == "閿�鍞嚭搴撳崟")
+ if (HSourceBillType == "閿�鍞嚭搴撳崟")
{
ordrlist.HWhID = dt.Rows[i]["HWhID"].ToString();
ordrlist.HWhNumber = dt.Rows[i]["浠撳簱浠ｇ爜"].ToString();
@@ -652,7 +652,7 @@
ordrlist.HSPNumber = dt.Rows[i]["浠撲綅浠ｇ爜"].ToString();
ordrlist.HSPName = dt.Rows[i]["浠撲綅"].ToString();
ordrlist.HMTONo = dt.Rows[i]["璁″垝璺熻釜鍙�"].ToString();
- ordrlist.HDate = dt.Rows[i]["鏃ユ湡"].ToString();
+ ordrlist.HDate = dt.Rows[i]["鏃ユ湡"].ToString();
ordrlist.HShowDate = DateTime.Now.ToString();
}
return ordrlist;
@@ -699,7 +699,7 @@
if (oDs == null && oDs.Tables[0].Rows.Count == 0)
{
objJsonResult.code = "1";
- objJsonResult.Message= "[0000-2-053]鐢熸垚鎵规澶辫触锛�";
+ objJsonResult.Message = "[0000-2-053]鐢熸垚鎵规澶辫触锛�";
return objJsonResult;
}
else if (DBUtility.ClsPub.isStrNull(oDs.Tables[0].Rows[0][0]) == "1")
@@ -716,7 +716,7 @@
if (b == false)
{
objJsonResult.code = "1";
- objJsonResult.Message= "[3899-2-003]娌℃湁闇�瑕佺敓鎴愭壒娆＄殑鏄庣粏琛岋紒";
+ objJsonResult.Message = "[3899-2-003]娌℃湁闇�瑕佺敓鎴愭壒娆＄殑鏄庣粏琛岋紒";
return objJsonResult;
}
else //瀹屽叏灏侀棴
@@ -740,7 +740,7 @@
string HOrgType = sArray[1].ToString();
string HSourceBillTypeName = sArray[2].ToString();
string HSelectBarCodeType = sArray[3].ToString();
- string CampanyName = sArray[4].ToString()=="xxx"?"": sArray[4].ToString();
+ string CampanyName = sArray[4].ToString() == "xxx" ? "" : sArray[4].ToString();
string UserName = sArray[5].ToString();
ClsPub.CurUserName = UserName;
@@ -833,7 +833,7 @@
#endregion
#region[鏉＄爜鐢熸垚鏂规硶]
- private object SaveBarCode(string msg2, string HSelectBarCodeType, string CampanyName,string HSourceBillTypeName)
+ private object SaveBarCode(string msg2, string HSelectBarCodeType, string CampanyName, string HSourceBillTypeName)
{
int LSHlen = 6; //娴佹按鍙烽暱搴�
int SumLen = 10; //鎬婚暱搴�
@@ -954,7 +954,8 @@
//oCn.RunProc("exec h_p_WMS_SetMaxNo '" + sTMNumber + "'");
LSH = ClsPub.isInt(Ds.Tables[0].Rows[0][0]);
}
- else if (CampanyName == "鐟炰笌绁�") {
+ else if (CampanyName == "鐟炰笌绁�")
+ {
var date = DateTime.Now.ToString("yyMMdd");//鏃ユ湡
if (HSourceBillTypeName == "鏀舵枡閫氱煡鍗�")
{
@@ -1133,7 +1134,7 @@
HMinQty = ClsPub.isDoule(ordrlist[j].HMinQty);
HSumQty = ClsPub.isDoule(ordrlist[j].HQty);
n = 0;
-
+
for (int i = k; i < HBQty; i++)
{
if (HSumQty - HMinQty > 0)
@@ -1485,7 +1486,7 @@
{
try
{
- oCN.RunProc("update Gy_BarCodeBill set HPrintQty=isnull(HPrintQty,0)+1 where HitemID in("+msg+")", ref DBUtility.ClsPub.sExeReturnInfo);
+ oCN.RunProc("update Gy_BarCodeBill set HPrintQty=isnull(HPrintQty,0)+1 where HitemID in(" + msg + ")", ref DBUtility.ClsPub.sExeReturnInfo);
objJsonResult.code = "1";
objJsonResult.count = 1;
objJsonResult.Message = "鏇存柊鎵撳嵃娆℃暟鎴愬姛";
@@ -1551,7 +1552,7 @@
}
else
{
-
+
// 鏉＄爜杞瓨
msg2 = msg2.Replace("\\", "");
msg2 = msg2.Replace("\n", ""); //\n
@@ -1560,35 +1561,38 @@
long HSourceInterID = string.IsNullOrEmpty(ordrlist[0].HMainID) == true ? 0 : ClsPub.isLong(ordrlist[0].HMainID);
long HSourceEntryID = string.IsNullOrEmpty(ordrlist[0].HSubID) == true ? 0 : ClsPub.isLong(ordrlist[0].HSubID);
- DataSet ds1 = oCN.RunProcReturn("exec h_p_SC_BarCode_Transfer " +
- "@HBarCodeNo = N'" + barCodeNo + "'" +
+ DataSet ds1 = oCN.RunProcReturn("exec h_p_SC_BarCode_Transfer " +
+ "@HBarCodeNo = N'" + barCodeNo + "'" +
",@HSubID = " + ordrlist[0].HSubID +
- ",@HMaterID = " + ordrlist[0].HMaterID +
+ ",@HMaterID = " + ordrlist[0].HMaterID +
",@HGiveAwayFlag = " + ordrlist[0].HGiveAwayFlag +
",@HQty = " + ordrlist[0].HQty +
",@HUnitID = " + ordrlist[0].HUnitID +
",@HMinQty = " + ordrlist[0].HMinQty +
",@HSupID = " + ordrlist[0].HSupID +
- ",@HBatchNo = N'" + ordrlist[0].HBatchNo + "'" +
+ ",@HBatchNo = N'" + ordrlist[0].HBatchNo + "'" +
",@HMTONO = N'" + ordrlist[0].HMTONo + "'" +
",@HBarCodeDate = N'" + ordrlist[0].HDate + "'" +
- ",@HEmpID = " + ordrlist[0].HEmpID +
- ",@HGroupID = " + ordrlist[0].HGroupID +
- ",@HSourceInterID = " + HSourceInterID +
- ",@HSourceEntryID = " + HSourceEntryID
+ ",@HEmpID = " + ordrlist[0].HEmpID +
+ ",@HGroupID = " + ordrlist[0].HGroupID +
+ ",@HSourceInterID = " + HSourceInterID +
+ ",@HSourceEntryID = " + HSourceEntryID +
+ ",@HBarCodeType = " + HSelectBarCodeType +
+ ",@HSourceBillNo = " + ordrlist[0].HBillNo +
+ ",@HMaker = " + UserName
, "h_p_SC_BarCode_Transfer");
- if((bool)ds1.Tables[0].Rows[0]["returntype"] == true)
+ if ((bool)ds1.Tables[0].Rows[0]["returntype"] == true)
{
objJsonResult.code = "1";
objJsonResult.count = 1;
- objJsonResult.Message = "[0000-1-037]鑾峰彇璧勬簮缁戝畾鏁版嵁鎴愬姛锛�";
+ objJsonResult.Message = ds1.Tables[0].Rows[0]["mesg"].ToString();
}
else
{
throw new Exception(ds1.Tables[0].Rows[0]["mesg"].ToString());
}
-
+
}
}
catch (Exception e)
@@ -1804,7 +1808,7 @@
oCN.RunProc("exec h_p_WMS_SetMaxNo '" + sTMNumber + "'"); //鏇存柊鏈�澶ф祦姘村彿
}
}
- else if(HSelectBarCodeType == "BarCode_Box")
+ else if (HSelectBarCodeType == "BarCode_Box")
{
int HBQty = ClsPub.isInt(ordrlist[i].HBQty); //绠辨暟
diff --git a/sdk_dingding/TopSdk/obj/Debug/DesignTimeResolveAssemblyReferencesInput.cache b/sdk_dingding/TopSdk/obj/Debug/DesignTimeResolveAssemblyReferencesInput.cache
new file mode 100644
index 0000000..a94f9dd
--- /dev/null
+++ b/sdk_dingding/TopSdk/obj/Debug/DesignTimeResolveAssemblyReferencesInput.cache
Binary files differ
--
Gitblit v1.9.1