BLL/bin/Release/BLL.dllBinary files differ
BLL/bin/Release/BLL.pdbBinary files differ
BLL/bin/Release/DAL.dllBinary files differ
BLL/bin/Release/DAL.pdbBinary files differ
BLL/bin/Release/DBUtility.dllBinary files differ
BLL/bin/Release/DBUtility.pdbBinary files differ
BLL/bin/Release/Model.dllBinary files differ
BLL/bin/Release/Model.pdbBinary files differ
BLL/bin/Release/Pub_Class.dllBinary files differ
BLL/bin/Release/Pub_Class.pdbBinary files differ
BLL/bin/Release/Pub_Control.dllBinary files differ
BLL/bin/Release/Pub_Control.pdbBinary files differ
BLL/bin/Release/SQLHelper.dllBinary files differ
BLL/bin/Release/SQLHelper.pdbBinary files differ
BLL/bin/x86/Release/BLL.dllBinary files differ
BLL/bin/x86/Release/BLL.pdbBinary files differ
BLL/bin/x86/Release/DAL.dllBinary files differ
BLL/bin/x86/Release/DAL.pdbBinary files differ
BLL/bin/x86/Release/DBUtility.dllBinary files differ
BLL/bin/x86/Release/DBUtility.pdbBinary files differ
BLL/bin/x86/Release/Model.dllBinary files differ
BLL/bin/x86/Release/Model.pdbBinary files differ
BLL/bin/x86/Release/Pub_Class.dllBinary files differ
BLL/bin/x86/Release/Pub_Class.pdbBinary files differ
BLL/bin/x86/Release/Pub_Control.dllBinary files differ
BLL/bin/x86/Release/Pub_Control.pdbBinary files differ
BLL/bin/x86/Release/SQLHelper.dllBinary files differ
BLL/bin/x86/Release/SQLHelper.pdbBinary files differ
BLL/bin/x86/Release/TopSdk.dllBinary files differ
BLL/bin/x86/Release/TopSdk.pdbBinary files differ
DAL/DAL.csproj
@@ -86,6 +86,7 @@ <Compile Include="åºç¡èµæ\å ¬ç¨åºç¡èµæ\ClsGy_RepairClass_Ctl.cs" /> <Compile Include="åºç¡èµæ\å ¬ç¨åºç¡èµæ\ClsGy_RepairCheckClass_Ctl.cs" /> <Compile Include="ä»åºç®¡ç\ClsKf_ProductReceiveMaterialBill.cs" /> <Compile Include="æºå\InterFaceæºå\Cls_S_IF_ICMOBillList_CusBarCodeBill_KaiBei.cs" /> <Compile Include="æºå\InterFaceæºå\Cls_S_IF_MoveStockRequestBillList.cs" /> <Compile Include="ç产管ç\ClsSc_ShiftsBeginInfoBill.cs" /> <Compile Include="ClsPay_AbsentBill.cs" /> DAL/bin/Release/DAL.dllBinary files differ
DAL/bin/Release/DAL.pdbBinary files differ
DAL/bin/Release/DBUtility.dllBinary files differ
DAL/bin/Release/DBUtility.pdbBinary files differ
DAL/bin/Release/Model.dllBinary files differ
DAL/bin/Release/Model.pdbBinary files differ
DAL/bin/Release/Pub_Class.dllBinary files differ
DAL/bin/Release/Pub_Class.pdbBinary files differ
DAL/bin/Release/Pub_Control.dllBinary files differ
DAL/bin/Release/Pub_Control.pdbBinary files differ
DAL/bin/Release/SQLHelper.dllBinary files differ
DAL/bin/Release/SQLHelper.pdbBinary files differ
DAL/bin/x86/Release/DAL.dllBinary files differ
DAL/bin/x86/Release/DAL.pdbBinary files differ
DAL/bin/x86/Release/DBUtility.dllBinary files differ
DAL/bin/x86/Release/DBUtility.pdbBinary files differ
DAL/bin/x86/Release/Model.dllBinary files differ
DAL/bin/x86/Release/Model.pdbBinary files differ
DAL/bin/x86/Release/Pub_Class.dllBinary files differ
DAL/bin/x86/Release/Pub_Class.pdbBinary files differ
DAL/bin/x86/Release/Pub_Control.dllBinary files differ
DAL/bin/x86/Release/Pub_Control.pdbBinary files differ
DAL/bin/x86/Release/SQLHelper.dllBinary files differ
DAL/bin/x86/Release/SQLHelper.pdbBinary files differ
DAL/Ô´µ¥/InterFaceÔ´µ¥/Cls_S_IF_ICMOBillList_CusBarCodeBill_KaiBei.cs
New file @@ -0,0 +1,23 @@ using System; using System.Collections.Generic; using System.Text; using SQLHelper; using DBUtility; namespace DAL { public class Cls_S_IF_ICMOBillList_CusBarCodeBill_KaiBei : Cls_S_Xt_BaseBill { public Cls_S_IF_ICMOBillList_CusBarCodeBill_KaiBei() { base.ViewName = "h_v_Sc_ICMOBillList_Source_CusBarCodeBill_KaiBei"; base.mvarReportTitle = "ç产订å"; base.mvarItemKey = "3710"; base.sCondtion = " "; base.sOrderSql = " order by åæ®å· desc,hsubid "; base.sKeyCol = "é¨é¨"; } } } DBUtility/bin/Release/DBUtility.dllBinary files differ
DBUtility/bin/Release/DBUtility.pdbBinary files differ
DBUtility/bin/Release/Pub_Class.dllBinary files differ
DBUtility/bin/Release/Pub_Class.pdbBinary files differ
DBUtility/bin/Release/Pub_Control.dllBinary files differ
DBUtility/bin/Release/Pub_Control.pdbBinary files differ
DBUtility/bin/Release/SQLHelper.dllBinary files differ
DBUtility/bin/Release/SQLHelper.pdbBinary files differ
DBUtility/bin/x86/Release/DBUtility.dllBinary files differ
DBUtility/bin/x86/Release/DBUtility.pdbBinary files differ
DBUtility/bin/x86/Release/Pub_Class.dllBinary files differ
DBUtility/bin/x86/Release/Pub_Class.pdbBinary files differ
DBUtility/bin/x86/Release/Pub_Control.dllBinary files differ
DBUtility/bin/x86/Release/Pub_Control.pdbBinary files differ
DBUtility/bin/x86/Release/SQLHelper.dllBinary files differ
DBUtility/bin/x86/Release/SQLHelper.pdbBinary files differ
DBUtility/obj/Release/DBUtility.csproj.AssemblyReference.cacheBinary files differ
DBUtility/obj/Release/DBUtility.dllBinary files differ
DBUtility/obj/Release/DBUtility.pdbBinary files differ
Model/bin/Release/DBUtility.dllBinary files differ
Model/bin/Release/DBUtility.pdbBinary files differ
Model/bin/Release/Model.dllBinary files differ
Model/bin/Release/Model.pdbBinary files differ
Model/bin/Release/Pub_Class.dllBinary files differ
Model/bin/Release/Pub_Class.pdbBinary files differ
Model/bin/Release/Pub_Control.dllBinary files differ
Model/bin/Release/Pub_Control.pdbBinary files differ
Model/bin/Release/SQLHelper.dllBinary files differ
Model/bin/Release/SQLHelper.pdbBinary files differ
Model/bin/x86/Release/DBUtility.dllBinary files differ
Model/bin/x86/Release/DBUtility.pdbBinary files differ
Model/bin/x86/Release/Model.dllBinary files differ
Model/bin/x86/Release/Model.pdbBinary files differ
Model/bin/x86/Release/Pub_Class.dllBinary files differ
Model/bin/x86/Release/Pub_Class.pdbBinary files differ
Model/bin/x86/Release/Pub_Control.dllBinary files differ
Model/bin/x86/Release/Pub_Control.pdbBinary files differ
Model/bin/x86/Release/SQLHelper.dllBinary files differ
Model/bin/x86/Release/SQLHelper.pdbBinary files differ
Model/obj/Release/Model.csproj.AssemblyReference.cacheBinary files differ
Model/obj/Release/Model.dllBinary files differ
Model/obj/Release/Model.pdbBinary files differ
Model/obj/x86/Release/Model.csproj.AssemblyReference.cacheBinary files differ
Model/obj/x86/Release/Model.dllBinary files differ
Model/obj/x86/Release/Model.pdbBinary files differ
Pub_Class/bin/Release/Pub_Class.dllBinary files differ
Pub_Class/bin/Release/Pub_Class.pdbBinary files differ
Pub_Class/bin/x86/Release/Pub_Class.dllBinary files differ
Pub_Class/bin/x86/Release/Pub_Class.pdbBinary files differ
Pub_Control/bin/Release/Pub_Class.dllBinary files differ
Pub_Control/bin/Release/Pub_Class.pdbBinary files differ
Pub_Control/bin/Release/Pub_Control.dllBinary files differ
Pub_Control/bin/Release/Pub_Control.pdbBinary files differ
Pub_Control/bin/x86/Release/Pub_Class.dllBinary files differ
Pub_Control/bin/x86/Release/Pub_Class.pdbBinary files differ
Pub_Control/bin/x86/Release/Pub_Control.dllBinary files differ
Pub_Control/bin/x86/Release/Pub_Control.pdbBinary files differ
SQLHelper/bin/Release/Pub_Class.dllBinary files differ
SQLHelper/bin/Release/Pub_Class.pdbBinary files differ
SQLHelper/bin/Release/SQLHelper.dllBinary files differ
SQLHelper/bin/Release/SQLHelper.pdbBinary files differ
SQLHelper/bin/x86/Release/Pub_Class.dllBinary files differ
SQLHelper/bin/x86/Release/Pub_Class.pdbBinary files differ
SQLHelper/bin/x86/Release/SQLHelper.dllBinary files differ
SQLHelper/bin/x86/Release/SQLHelper.pdbBinary files differ
SQLHelper/obj/Release/SQLHelper.csproj.AssemblyReference.cacheBinary files differ
SQLHelper/obj/Release/SQLHelper.dllBinary files differ
SQLHelper/obj/Release/SQLHelper.pdbBinary files differ
SQLHelper/obj/x86/Release/SQLHelper.csproj.AssemblyReference.cacheBinary files differ
SQLHelper/obj/x86/Release/SQLHelper.dllBinary files differ
SQLHelper/obj/x86/Release/SQLHelper.pdbBinary files differ
WarM/ÌõÂë´òÓ¡/Gy_CusBarCodeBill_KaiBei.cs
@@ -76,7 +76,6 @@ public int selectRow = 0; public Int64 HInterID = 0; //å ç public Int64 HOrgID = ClsPub.HOrgID; public string HCusModel = "Z"; //åå代ç public string sDate = ""; //æ¥æ public string sYear = ""; //å¹´ï¼2ä½ï¼ public string sYear4 = ""; //å¹´ï¼4ä½ï¼ @@ -89,13 +88,9 @@ //æ¸ ç©ºçé¢ public void Sub_ClearBill() { cmbHBarCodeType.Items.Clear(); cmbSourceBillType.Items.Clear(); //æ¡ç ç±»å cmbHBarCodeType.Items.Add("å ç®±ç "); cmbHBarCodeType.Items.Add("å¤ç®±ç "); //æºåç±»å cmbSourceBillType.Items.Add("çäº§æ±æ¥å"); cmbSourceBillType.Items.Add("ç产订å"); DBUtility.Xt_BaseBillFun.Sub_ClearBill(gbUp); //è·åå½åç»ç» @@ -266,7 +261,7 @@ //å 载客æ·ä¿¡æ¯ private void Sub_AddHCusNameList() { DataSet ds = oCn.RunProcReturn("exec h_p_Gy_CusBarCodeBill_Cus " + HOrgID.ToString(), "h_p_Gy_CusBarCodeBill_Cus"); DataSet ds = oCn.RunProcReturn("exec h_p_Gy_CusBarCodeBill_Cus_KaiBei " + HOrgID.ToString(), "h_p_Gy_CusBarCodeBill_Cus_KaiBei"); if (ds == null || ds.Tables[0].Rows.Count == 0) { cmbHCusName.DataSource = null; @@ -457,54 +452,6 @@ sDay = "0" + ClsPub.isDate(sDate).Day.ToString(); sDay = sDay.Substring(sDay.Length - 2, 2); //================================== switch (sYear) { case "22": sYear = "N"; break; case "23": sYear = "P"; break; case "24": sYear = "Q"; break; case "25": sYear = "R"; break; case "26": sYear = "S"; break; case "27": sYear = "T"; break; case "28": sYear = "U"; break; case "29": sYear = "V"; break; case "30": sYear = "W"; break; case "31": sYear = "X"; break; case "32": sYear = "Y"; break; case "33": sYear = "Z"; break; default: sYear = ""; break; } if (sYear == "") { MessageBox.Show("é误ç年份ï¼"); return false; } switch (sPeriod) { case "01": @@ -561,14 +508,13 @@ double HSourceQty = DBUtility.ClsPub.isDoule(grdMain.Rows[j].Cells[HInitQtyCol].Value); // æºåæ°é double HQty = DBUtility.ClsPub.isDoule(grdMain.Rows[j].Cells[HQtyCol].Value); // æ°é double HMinQty = DBUtility.ClsPub.isDoule(grdMain.Rows[j].Cells[HMinQtyCol].Value); // æå°å è£ æ° string HCusModelName = DBUtility.ClsPub.isStrNull(grdMain.Rows[j].Cells[HCusModelNameCol].Value); // å®¢æ·æå· string HCusModelName = DBUtility.ClsPub.isStrNull(grdMain.Rows[j].Cells[HCusModelNameCol].Value); // 客æ·ç©æç¼ç string HCode1 = DBUtility.ClsPub.isStrNull(grdMain.Rows[j].Cells[HCode1Col].Value); // ç©æç±»å« string HCode2 = DBUtility.ClsPub.isStrNull(grdMain.Rows[j].Cells[HCode2Col].Value); // æ¹æ¬¡ä½ HCode2 = HCode2.ToUpper(); string HCode3 = DBUtility.ClsPub.isStrNull(grdMain.Rows[j].Cells[HCode3Col].Value); // çæ¬å· string HBatchNoNumber = HCode1 + sYear + sPeriod + sDay + HCusModel; // æ¹æ¬¡çæåç¼ HBatchNoNumber = HBatchNoNumber.ToUpper(); string HBarCodeType = DBUtility.ClsPub.isStrNull(cmbHBarCodeType.Text); // æ¡ç ç±»å string HBatchNoNumber = ""; // æ¹æ¬¡çæåç¼ string HBarCodeType = "è¶ èåå æ ç¾"; // æ¡ç ç±»å string HInnerBillNo = DBUtility.ClsPub.isStrNull(grdMain.Rows[j].Cells[HInnerBillNoCol].Value); // 客æ·è®¢åå· if (HMaterID != 0) @@ -586,10 +532,6 @@ } else { grdMain.Rows[j].Cells[HBaNoCol].Value = HCode2; grdMain.Rows[j].Cells[HBatchNoCol].Value = DBUtility.ClsPub.isStrNull(oDsCheck.Tables[0].Rows[0]["HBatchNo"]); grdMain.Rows[j].Cells[HCode2Col].Value = DBUtility.ClsPub.isStrNull(oDsCheck.Tables[0].Rows[0]["HCode2"]); if (DBUtility.ClsPub.isStrNull(grdMain.Rows[j].Cells[HExpiryDateCol].Value) == "") { if (DBUtility.ClsPub.isBool(oDsCheck.Tables[0].Rows[0]["HISKFPERIOD"])) @@ -648,17 +590,16 @@ try { string TM = ""; //æ¡ç int LSHlen = 4; //æµæ°´å·é¿åº¦ int LSHlen = 7; //æµæ°´å·é¿åº¦ double HSumQty = 0; //äº§åæ°é double HMinQty = 0; //æå°å è£ æ° int HBQty = 0; //ç®±æ° int LSH = 0; //å ç®±æµæ°´å· int LWSH = 0; //å¤ç®±æµæ°´å· int LSH = 0; //æµæ°´å· string LSH2 = ""; //æµæ°´å·è½¬æ¢æå符 string HCode1 = ""; //ç©æç±»å« string HCode2 = ""; //æ¹æ¬¡ä½ string HCode3 = ""; //çæ¬å· string sTMNumber = ""; //å¤ç®±æ¡ç åç¼ string sTMNumber = ""; //æ¡ç åç¼ DataSet Ds; Int64 HEntryID = 0; @@ -670,7 +611,7 @@ string HBatchNo = ""; //æ¹æ¬¡ double HQty = 0; //æ°é Int64 HCusID = 0; //客æ·ID string HCusModelName = ""; //å®¢æ·æå· string HCusModelName = ""; //客æ·ç©æç¼ç bool HGiveAwayFlag = false; //èµ åæ è®° string HProduceDate; //çäº§æ¥æï¼ä¿è´¨æç¨ï¼ string HExpiryDate; //ä¿è´¨æè³ï¼ä¿è´¨æç¨ï¼ @@ -684,7 +625,7 @@ string HMTONo = ""; //MTOå· string HRemark = ""; //夿³¨ string HInnerBillNo = ""; //客æ·è®¢åå· string HSno = ""; //æ¹æ¬¡åºåå· string HSno = ""; //æµæ°´å· string HBoxNo = ""; //æ¹æ¬¡çæåç¼ string sHBaNo = ""; //çé¢ä¸è¾å ¥çæ¹æ¬¡ä½ int HSumBQty = 0; //å䏿¹çææ¡ç æ»ç®±æ° @@ -697,27 +638,14 @@ Application.DoEvents(); if (ClsPub.isLong(grdMain.Rows[j].Cells[HMaterIDCol].Value) != 0) { HBatchNo = DBUtility.ClsPub.isStrNull(grdMain.Rows[j].Cells[HBatchNoCol].Value); HCode3 = DBUtility.ClsPub.isStrNull(grdMain.Rows[j].Cells[HCode3Col].Value); string HMaterNumber = DBUtility.ClsPub.isStrNull(grdMain.Rows[j].Cells[HMaterNumberCol].Value); HMaterNumber = HMaterNumber.Substring(HMaterNumber.Length - 3, 3); //åç©æä»£ç åä¸ä½ string sHCusModelName = DBUtility.ClsPub.isStrNull(grdMain.Rows[j].Cells[HCusModelNameCol].Value); //客æ·ä»£ç ï¼åéè¶å®¢æ·ç©æå¯¹åºè¡¨å®¢æ·ç©æç¼ç ï¼ if (cmbHBarCodeType.Text == "å ç®±ç ") { //è·åæå¤§æµæ°´å· LSH = 0; Ds = oCn.RunProcReturn("select top 1 HSno from Gy_BarCodeBill_Cus where HBatchNo='" + HBatchNo + "' order by HSno desc", "Gy_BarCodeBill_Cus"); if (Ds != null && Ds.Tables[0].Rows.Count != 0) { LSH = ClsPub.isInt(Ds.Tables[0].Rows[0][0]); } } //å¤ç®±ç ä¾åºå代ç ï¼æµªæ½®å®ä¹çä¾åºå代ç ï¼+8使¥æï¼ä¾å¦20230905ï¼+5使µæ°´ç ï¼çº¯æ°åï¼ else { //æ¡ç åç¼ = ä¾åºå代ç + å¹´ + æ + æ¥ sTMNumber = HCusModel + sYear + sPeriod + sDay; Ds = oCn.RunProcReturn("exec h_p_WMS_GetMaxNo '" + sTMNumber + "'", "h_p_WMS_GetMaxNo"); //è·åæå¤§æµæ°´å· LWSH = ClsPub.isInt(Ds.Tables[0].Rows[0][0]); } //æ¡ç åç¼ = å¹´ + æ sTMNumber = sYear + sPeriod; Ds = oCn.RunProcReturn("exec h_p_WMS_GetMaxNo '" + sTMNumber + "'", "h_p_WMS_GetMaxNo"); //è·åæå¤§æµæ°´å· LSH = ClsPub.isInt(Ds.Tables[0].Rows[0][0]); HBQty = ClsPub.isInt(grdMain.Rows[j].Cells[HBQtyCol].Value); HMinQty = ClsPub.isDoule(grdMain.Rows[j].Cells[HMinQtyCol].Value); @@ -725,6 +653,7 @@ HSumBQty = HSumBQty + ClsPub.isInt(grdMain.Rows[j].Cells[HBQtyCol].Value); pb1.Maximum = HSumBQty; int nn = 0; //æ¬æ¬¡æµæ°´å·ç´¯è®¡ä½¿ç¨ä¸ªæ° for (int i = 0; i < HBQty; i++) { pb1.Value = n+1; @@ -737,32 +666,23 @@ HMinQty = HSumQty; } // if (cmbHBarCodeType.Text == "å ç®±ç ") LSH = LSH + 1; LSH2 = LSH.ToString(); while (LSH2.Length < LSHlen) //å¦ææµæ°´å·ä½æ°å°äº æµæ°´å·é¿åº¦ åé¢è¡¥0 { LSH = LSH + 1; LSH2 = ConvertToBase(LSH, 36); while (LSH2.Length < LSHlen) //å¦ææµæ°´å·ä½æ°å°äº LSHlen åé¢è¡¥0 { LSH2 = "0" + LSH2; } //æ¡ç ç¼å· = æ¹æ¬¡ + æµæ°´å· + çæ¬å· TM = HBatchNo + LSH2 + HCode3; LSH2 = "0" + LSH2; } //å¤ç®±ç else if (LSH2.Length != 7) { LWSH = LWSH + 1; LSH2 = LWSH.ToString(); while (LSH2.Length < 5) //å¦ææµæ°´å·ä½æ°å°äº 5 åé¢è¡¥0 { LSH2 = "0" + LSH2; } TM = sTMNumber + LSH2; MessageBox.Show("æ¡ç æµæ°´å·ä¸º[" + LSH2 + "]ï¼é¿åº¦ä¸å è®¸è¶ è¿7ä½ï¼"); return; } //è¶ èåæ°åææ¯æéå ¬å¸ æ¡ç ç¼å·ï¼å ±26ä½ï¼ = 代ç ï¼1ä½åºå®âSâï¼ + åå代ç ï¼2ä½åºå®âY3âï¼ + å¹´ï¼2ä½å¹´å两ä½ï¼ + æï¼1ä½10=A,11=B,12=Cï¼ + æµæ°´å·ï¼7ä½ï¼ + 代å·ï¼2ä½åºå®â1Pâï¼ + 客æ·ä»£ç ï¼8ä½åéè¶å®¢æ·ç©æå¯¹åºè¡¨å®¢æ·ç©æç¼ç ï¼ + ç©æçæ¬ï¼3ä½åç©æç¼ç åä¸ä½ï¼ TM = "SY3" + sYear + sPeriod + LSH2 + "1P" + sHCusModelName + HMaterNumber; HEntryID = j + 1; HBarCode = TM.ToUpper(); HBarCodeType = ClsPub.isStrNull(cmbHBarCodeType.Text); HBarCodeType = "è¶ èåå æ ç¾"; HMaterID = ClsPub.isLong(grdMain.Rows[j].Cells[HMaterIDCol].Value); HUnitID = ClsPub.isLong(grdMain.Rows[j].Cells[HUnitIDCol].Value); HAuxPropID = ClsPub.isLong(grdMain.Rows[j].Cells[HAuxPropIDCol].Value); @@ -782,16 +702,11 @@ HRemark = ClsPub.isStrNull(grdMain.Rows[j].Cells[HRemarkCol].Value); HMTONo = ClsPub.isStrNull(grdMain.Rows[j].Cells[HMTONoCol].Value); HInnerBillNo = ClsPub.isStrNull(grdMain.Rows[j].Cells[HInnerBillNoCol].Value); HCode1 = ClsPub.isStrNull(grdMain.Rows[j].Cells[HCode1Col].Value).ToUpper(); HCode2 = ClsPub.isStrNull(grdMain.Rows[j].Cells[HCode2Col].Value).ToUpper(); HCode3 = ClsPub.isStrNull(grdMain.Rows[j].Cells[HCode3Col].Value).ToUpper(); HSno = ClsPub.isStrNull(LSH); HBoxNo = HCode1 + sYear + sPeriod + sDay + HCusModel; HBoxNo = HBoxNo.ToUpper(); HBoxNo = sTMNumber; sHBaNo = ClsPub.isStrNull(grdMain.Rows[j].Cells[HBaNoCol].Value); // çé¢ä¸è¾å ¥çæ¹æ¬¡ä½ //å®¢æ·æå·HCusModelNameãç©æç±»å«HCode1ãæ¹æ¬¡ä½HCode2ãçæ¬å·HCode3ãæ¹æ¬¡åºåå·HSnoãæ¹æ¬¡çæåç¼HBoxNoãåå代ç HCusModel //çé¢ä¸è¾å ¥çæ¹æ¬¡ä½HSupNameã36è¿å¶æ¹æ¬¡åºåå·HSupNumberã客æ·è®¢åå·HInnerBillNo //è¶ èåæ°åææ¯æéå ¬å¸ å®¢æ·ç©æç¼ç HCusModelNameãæµæ°´å·HSnoãæµæ°´å·HSupNumberãæµæ°´å·çæåç¼HBoxNo oCn.RunProc("insert into Gy_BarCodeBill_Cus" + "(HInterID,HEntryID,HBillType,HBarCode,HBarCodeType" + ",HMaterID,HUnitID,HAuxPropID,HBatchNo,HQty" + @@ -807,7 +722,7 @@ ",HCode2,HCode3,HBackDataFlag,HSno,HBoxNo" + ") values (" + HInterID + "," + HEntryID + ",'','" + HBarCode + "','" + HBarCodeType + "'" + "," + HMaterID.ToString() + "," + HUnitID.ToString() + "," + HAuxPropID.ToString() + ",'" + HBatchNo + "'," + HQty.ToString() + "," + HCusID.ToString() + ",'" + HCusModel + "','" + HCusModelName + "','" + sDate + "',''" + "," + HCusID.ToString() + ",'','" + HCusModelName + "','" + sDate + "',''" + "," + DBUtility.ClsPub.BoolToString(HGiveAwayFlag) + "," + DBUtility.ClsPub.BoolToString(HISKFPERIOD) + ",''" + "," + (HProduceDate == "" ? "NULL" : "'" + HProduceDate + "'") + "," + (HExpiryDate == "" ? "NULL" : "'" + HExpiryDate + "'") + "," + HBarcodeQtys.ToString() + "," + HBarcodeNo.ToString() + ",1,0" @@ -818,8 +733,11 @@ + ",'','','" + LSH2 + "','" + sHBaNo + "','" + HCode1 + "'" + ",'" + HCode2 + "','" + HCode3 + "','','" + HSno + "','" + HBoxNo + "')"); n = n + 1; nn = nn + 1; Application.DoEvents(); } //åå¡«æµæ°´å·ä¿¡æ¯ oCn.RunProc("exec h_p_WMS_SetMaxNo_QTY '" + sTMNumber + "'," + nn.ToString() + " "); } } oCn.Commit(); @@ -904,7 +822,7 @@ grdMain.Columns[HMaterNumberCol].HeaderText = "ç©æä»£ç "; grdMain.Columns[HMaterNameCol].HeaderText = "ç©æåç§°"; grdMain.Columns[HMaterModelCol].HeaderText = "è§æ ¼åå·"; grdMain.Columns[HCusModelNameCol].HeaderText = "å®¢æ·æå·"; grdMain.Columns[HCusModelNameCol].HeaderText = "客æ·ç©æç¼ç "; grdMain.Columns[HUnitIDCol].HeaderText = "计éåä½ID"; grdMain.Columns[HUnitNumberCol].HeaderText = "计éåä½ä»£ç "; grdMain.Columns[HUnitNameCol].HeaderText = "计éåä½åç§°"; @@ -945,6 +863,7 @@ grdMain.Columns[HAuxPropNumberCol].Visible = false; grdMain.Columns[HAuxPropNameCol].Visible = false; grdMain.Columns[HBatchManagerCol].Visible = false; grdMain.Columns[HBatchNoCol].Visible = false; grdMain.Columns[HGiveAwayFlagCol].Visible = false; grdMain.Columns[HProduceDateCol].Visible = false; grdMain.Columns[HExpiryDateCol].Visible = false; @@ -962,6 +881,10 @@ grdMain.Columns[HEXPPERIODCol].Visible = false; grdMain.Columns[HLSHCol].Visible = false; grdMain.Columns[HBaNoCol].Visible = false; grdMain.Columns[HCode1Col].Visible = false; grdMain.Columns[HCode2Col].Visible = false; grdMain.Columns[HCode3Col].Visible = false; grdMain.Columns[HInnerBillNoCol].Visible = false; //设置å¯ç¼è¾å string sAllowCol = HQtyCol.ToString()+ @@ -1278,7 +1201,16 @@ private void cmdSourceBillNo_Click(object sender, EventArgs e) { if (cmbSourceBillType.Text.Trim() == "çäº§æ±æ¥å") if (cmbSourceBillType.Text.Trim() == "ç产订å") { string sWhere = " and HOrgID =" + HOrgID.ToString(); DAL.Cls_S_IF_ICMOBillList_CusBarCodeBill_KaiBei oIF_ICMOBillList = new DAL.Cls_S_IF_ICMOBillList_CusBarCodeBill_KaiBei(); if (oIF_ICMOBillList.Refresh(sWhere)) //éæ©åå { FillSelectData(oIF_ICMOBillList.oBillSelectColl); } } else if (cmbSourceBillType.Text.Trim() == "çäº§æ±æ¥å") { string sWhere = " and HOrgID =" + HOrgID.ToString(); DAL.Cls_S_IF_ICMOReportBillList_CusBarCodeBill oIF_ICMOReportBillList = new DAL.Cls_S_IF_ICMOReportBillList_CusBarCodeBill(); @@ -1298,8 +1230,19 @@ foreach (DBUtility.BillSelect oSelectRow in oList) { i = i + 1; //ç产订å if (oSelectRow.BillType == "3710") { grdMain.Rows.Add(); grdMain.Rows[i].Cells[HTagCol].Value = "*"; //å¾å°ä¿¡æ¯ Ds = oCn.RunProcReturn("exec h_p_Gy_CusBarCodeBill_ICMOBillList " + oSelectRow.BillMainID.ToString() + "," + oSelectRow.BillSubID.ToString() + ",'1'", "h_p_Gy_CusBarCodeBill_ICMOBillList"); //åå ¥ä¿¡æ¯ Sub_WriteInForm1(Ds.Tables[0], i); GetCusMatNo(1); } //çäº§æ±æ¥å if (oSelectRow.BillType == "3711") else if (oSelectRow.BillType == "3711") { grdMain.Rows.Add(); grdMain.Rows[i].Cells[HTagCol].Value = "*"; @@ -1388,7 +1331,21 @@ return; } //æ ¹æ®æºåç±»å åæºåå· è·åä¿¡æ¯ if (cmbSourceBillType.Text.Trim() == "çäº§æ±æ¥å") if (cmbSourceBillType.Text.Trim() == "ç产订å") { DAL.Cls_S_IF_ICMOBillList_CusBarCodeBill oIF_ICMOBillList = new DAL.Cls_S_IF_ICMOBillList_CusBarCodeBill(); if (oIF_ICMOBillList.RefreshBySourceBillNo(" Where åæ®å· like '%" + txtHSourceBillNo.Text + "' and HOrgID =" + HOrgID.ToString())) //éæ©åå { FillSelectData(oIF_ICMOBillList.oBillSelectColl); txtHSourceBillNo.Text = ""; } else { MessageBox.Show("æªæ¥è¯¢å°ä»»å¡æ°æ®ï¼è¯·ç¡®è®¤æéç»ç»ãæºåç±»å䏿ºååå·æ¯å¦æ£ç¡®ï¼"); return; } } else if (cmbSourceBillType.Text.Trim() == "çäº§æ±æ¥å") { DAL.Cls_S_IF_ICMOReportBillList_CusBarCodeBill oIF_ICMOReportBillList = new DAL.Cls_S_IF_ICMOReportBillList_CusBarCodeBill(); if (oIF_ICMOReportBillList.RefreshBySourceBillNo(" Where åæ®å· like '%" + txtHSourceBillNo.Text + "' and HOrgID =" + HOrgID.ToString())) //éæ©åå WarM/ÌõÂë´òÓ¡/Gy_CusBarCodeBill_KaiBei.designer.cs
@@ -55,8 +55,6 @@ this.label2 = new System.Windows.Forms.Label(); this.cmbHOrgID = new System.Windows.Forms.ComboBox(); this.label3 = new System.Windows.Forms.Label(); this.cmbHBarCodeType = new System.Windows.Forms.ComboBox(); this.label1 = new System.Windows.Forms.Label(); this.cmdHEmpID = new System.Windows.Forms.Button(); this.cmdSourceBillNo = new System.Windows.Forms.Button(); this.txtHSourceBillNo = new System.Windows.Forms.TextBox(); @@ -325,8 +323,6 @@ this.gbUp.Controls.Add(this.label2); this.gbUp.Controls.Add(this.cmbHOrgID); this.gbUp.Controls.Add(this.label3); this.gbUp.Controls.Add(this.cmbHBarCodeType); this.gbUp.Controls.Add(this.label1); this.gbUp.Controls.Add(this.cmdHEmpID); this.gbUp.Controls.Add(this.cmdSourceBillNo); this.gbUp.Controls.Add(this.txtHSourceBillNo); @@ -397,25 +393,6 @@ this.label3.Size = new System.Drawing.Size(53, 12); this.label3.TabIndex = 84; this.label3.Text = "ç» ç»"; // // cmbHBarCodeType // this.cmbHBarCodeType.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList; this.cmbHBarCodeType.FormattingEnabled = true; this.cmbHBarCodeType.Location = new System.Drawing.Point(676, 46); this.cmbHBarCodeType.Name = "cmbHBarCodeType"; this.cmbHBarCodeType.Size = new System.Drawing.Size(188, 20); this.cmbHBarCodeType.TabIndex = 81; // // label1 // this.label1.AutoSize = true; this.label1.ForeColor = System.Drawing.Color.Black; this.label1.Location = new System.Drawing.Point(609, 50); this.label1.Name = "label1"; this.label1.Size = new System.Drawing.Size(53, 12); this.label1.TabIndex = 80; this.label1.Text = "æ¡ç ç±»å"; // // cmdHEmpID // @@ -923,8 +900,6 @@ private System.Windows.Forms.Panel panel3; private System.Windows.Forms.DataGridView grdSum; private System.Windows.Forms.DataGridView grdPrint; private System.Windows.Forms.ComboBox cmbHBarCodeType; private System.Windows.Forms.Label label1; private System.Windows.Forms.ToolStripButton dy; private System.Windows.Forms.ComboBox cmbHOrgID; private System.Windows.Forms.Label label3; WebAPI/Controllers/»ªÔ¶datamapping/HY_DataMappingController.cs
@@ -601,7 +601,7 @@ objJsonResult.code = "1"; objJsonResult.count = 1; //æåï¼ objJsonResult.Message = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HRemark"]); objJsonResult.data = ds.Tables[0]; objJsonResult.data = ds.Tables[0].Rows[0]["HBarCode"].ToString(); return objJsonResult; } } @@ -772,10 +772,16 @@ } else { List<string> HBarCodeList = new List<string>(); for(int i = 0; i < ds.Tables[0].Rows.Count; i++) { HBarCodeList.Add(ds.Tables[0].Rows[i]["HBarCode"].ToString()); } objJsonResult.code = "1"; objJsonResult.count = 1; //æåï¼ objJsonResult.Message = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HRemark"]); objJsonResult.data = ds.Tables[0]; objJsonResult.data = HBarCodeList; return objJsonResult; } } 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-06-20T05:22:54.5321865Z;False|2025-06-20T13:21:30.8643897+08:00;True|2025-06-20T08:36:32.6695266+08:00;False|2025-06-20T08:35:57.8274069+08:00;True|2025-06-19T08:14:35.0623669+08:00;False|2025-06-19T08:12:57.2451557+08:00;True|2025-06-18T16:56:03.4555368+08:00;True|2025-06-18T16:42:43.2441845+08:00;False|2025-06-18T16:42:02.6907205+08:00;True|2025-06-16T16:13:03.2956026+08:00;False|2025-06-16T16:12:23.8438917+08:00;True|2025-06-16T15:21:32.7370852+08:00;True|2025-06-16T15:08:57.7166003+08:00;True|2025-06-16T14:02:18.4224630+08:00;True|2025-06-16T11:00:03.6375429+08:00;False|2025-06-16T10:59:26.0956296+08:00;True|2025-06-09T16:45:52.0865612+08:00;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> <History>True|2025-06-20T06:33:10.9210583Z;True|2025-06-20T13:22:54.5321865+08:00;False|2025-06-20T13:21:30.8643897+08:00;True|2025-06-20T08:36:32.6695266+08:00;False|2025-06-20T08:35:57.8274069+08:00;True|2025-06-19T08:14:35.0623669+08:00;False|2025-06-19T08:12:57.2451557+08:00;True|2025-06-18T16:56:03.4555368+08:00;True|2025-06-18T16:42:43.2441845+08:00;False|2025-06-18T16:42:02.6907205+08:00;True|2025-06-16T16:13:03.2956026+08:00;False|2025-06-16T16:12:23.8438917+08:00;True|2025-06-16T15:21:32.7370852+08:00;True|2025-06-16T15:08:57.7166003+08:00;True|2025-06-16T14:02:18.4224630+08:00;True|2025-06-16T11:00:03.6375429+08:00;False|2025-06-16T10:59:26.0956296+08:00;True|2025-06-09T16:45:52.0865612+08:00;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>06/20/2025 13:22:41</publishTime> <publishTime>06/20/2025 14:32:56</publishTime> </File> <File Include="bin/BLL.pdb"> <publishTime>06/20/2025 13:22:41</publishTime> <publishTime>06/20/2025 14:32:56</publishTime> </File> <File Include="bin/BouncyCastle.Crypto.dll"> <publishTime>12/18/2020 05:32:28</publishTime> </File> <File Include="bin/DAL.dll"> <publishTime>06/20/2025 13:22:39</publishTime> <publishTime>06/20/2025 14:32:54</publishTime> </File> <File Include="bin/DAL.pdb"> <publishTime>06/20/2025 13:22:39</publishTime> <publishTime>06/20/2025 14:32:54</publishTime> </File> <File Include="bin/Dapper.dll"> <publishTime>07/22/2016 22:52:40</publishTime> </File> <File Include="bin/DBUtility.dll"> <publishTime>06/20/2025 13:22:35</publishTime> <publishTime>06/20/2025 14:32:48</publishTime> </File> <File Include="bin/DBUtility.pdb"> <publishTime>06/20/2025 13:22:35</publishTime> <publishTime>06/20/2025 14:32:48</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>06/20/2025 13:22:36</publishTime> <publishTime>06/20/2025 14:32:49</publishTime> </File> <File Include="bin/Model.pdb"> <publishTime>06/20/2025 13:22:36</publishTime> <publishTime>06/20/2025 14:32:49</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>06/20/2025 13:22:33</publishTime> <publishTime>06/20/2025 14:32:45</publishTime> </File> <File Include="bin/Pub_Class.pdb"> <publishTime>06/20/2025 13:22:33</publishTime> <publishTime>06/20/2025 14:32:45</publishTime> </File> <File Include="bin/Pub_Control.dll"> <publishTime>06/20/2025 13:22:34</publishTime> <publishTime>06/20/2025 14:32:46</publishTime> </File> <File Include="bin/Pub_Control.pdb"> <publishTime>06/20/2025 13:22:34</publishTime> <publishTime>06/20/2025 14:32:46</publishTime> </File> <File Include="bin/RestSharp.dll"> <publishTime>08/31/2012 06:22:50</publishTime> </File> <File Include="bin/SQLHelper.dll"> <publishTime>06/20/2025 13:22:34</publishTime> <publishTime>06/20/2025 14:32:46</publishTime> </File> <File Include="bin/SQLHelper.pdb"> <publishTime>06/20/2025 13:22:34</publishTime> <publishTime>06/20/2025 14:32:46</publishTime> </File> <File Include="bin/Swashbuckle.Core.dll"> <publishTime>02/16/2015 01:57:08</publishTime> </File> <File Include="bin/SyntacticSugar.dll"> <publishTime>06/20/2025 13:20:54</publishTime> <publishTime>06/20/2025 14:32:02</publishTime> </File> <File Include="bin/SyntacticSugar.pdb"> <publishTime>06/20/2025 13:20:54</publishTime> <publishTime>06/20/2025 14:32:02</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>06/20/2025 13:20:58</publishTime> <publishTime>06/20/2025 14:32:08</publishTime> </File> <File Include="bin/TopSdk.pdb"> <publishTime>06/20/2025 13:20:58</publishTime> <publishTime>06/20/2025 14:32:08</publishTime> </File> <File Include="bin/WebActivatorEx.dll"> <publishTime>11/24/2014 19:18:48</publishTime> </File> <File Include="bin/WebAPI.dll"> <publishTime>06/20/2025 13:22:49</publishTime> <publishTime>06/20/2025 14:33:05</publishTime> </File> <File Include="bin/WebAPI.pdb"> <publishTime>06/20/2025 13:22:49</publishTime> <publishTime>06/20/2025 14:33:05</publishTime> </File> <File Include="bin/WebAPI.XmlSerializers.dll"> <publishTime>06/20/2025 13:22:53</publishTime> <publishTime>06/20/2025 14:33:09</publishTime> </File> <File Include="bin/WebGrease.dll"> <publishTime>07/18/2013 01:03:52</publishTime> sdk_dingding/TopSdk/bin/Release/TopSdk.dllBinary files differ
sdk_dingding/TopSdk/bin/Release/TopSdk.pdbBinary files differ
sdk_dingding/TopSdk/obj/Release/TopSdk.dllBinary files differ
sdk_dingding/TopSdk/obj/Release/TopSdk.pdbBinary files differ