From 831e6cd4b5835082695a72da13926e5624605b84 Mon Sep 17 00:00:00 2001
From: wtt <1985833171@qq.com>
Date: 星期二, 25 六月 2024 12:47:01 +0800
Subject: [PATCH] 1

---
 WebAPI/Controllers/条码管理/WEBSController.cs |  171 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++
 1 files changed, 171 insertions(+), 0 deletions(-)

diff --git "a/WebAPI/Controllers/\346\235\241\347\240\201\347\256\241\347\220\206/WEBSController.cs" "b/WebAPI/Controllers/\346\235\241\347\240\201\347\256\241\347\220\206/WEBSController.cs"
index d9ca5fa..e2524f9 100644
--- "a/WebAPI/Controllers/\346\235\241\347\240\201\347\256\241\347\220\206/WEBSController.cs"
+++ "b/WebAPI/Controllers/\346\235\241\347\240\201\347\256\241\347\220\206/WEBSController.cs"
@@ -5980,6 +5980,177 @@
         {
             try
             {
+                ds = oCn.RunProcReturn("select * from Gy_BarCodeBill where HBarcode='" + HBarCode + "'", "Gy_BarCodeBill");
+                if (ds.Tables[0].Rows.Count == 0) {
+                    DAL.ClsGy_BarCodeBill_View dal = new DAL.ClsGy_BarCodeBill_View();
+                    string sErrMsg = "";
+                    oSystemParameter.ShowBill(ref sErrMsg);
+
+                    if (oSystemParameter.omodel.WMS_CampanyName == "鏉窞鏂帿灏�")
+                    {
+                        if (!dal.GetInfoByNumber(HBarCode))
+                        {
+                            //鏉$爜瑙f瀽
+                            string[] str = HBarCode.Split('@');
+
+                            if (str[0] != "CMR" && str[0] != "SRM")
+                            {
+                                objJsonResult.code = "0";
+                                objJsonResult.count = 0;
+                                objJsonResult.Message = "鏉$爜瑙f瀽澶辫触,璇风‘璁ゆ潯鐮佹槸鍚︽纭�!";
+                                objJsonResult.data = null;
+                                return objJsonResult;
+                            }
+
+                            int HOrgIDs = 0;
+                            //鏌ヨ缁勭粐
+                            DataSet ds = oCn.RunProcReturn("select * from Xt_ORGANIZATIONS where HNumber='" + str[1] + "' ", "Xt_ORGANIZATIONS");
+                            if (ds.Tables[0].Rows.Count == 0)
+                            {
+                                objJsonResult.code = "0";
+                                objJsonResult.count = 0;
+                                objJsonResult.Message = "鏉$爜瑙f瀽澶辫触,璇风‘璁ゆ潯鐮佺粍缁囨槸鍚︽纭�!";
+                                objJsonResult.data = null;
+                                return objJsonResult;
+                            }
+                            else
+                            {
+                                HOrgIDs = int.Parse(ds.Tables[0].Rows[0]["HItemID"].ToString());
+                            }
+
+                            string HMaterNames = "";
+                            string HMaterModels = "";
+                            string HMaterIDs = "0";
+                            //鏌ヨ鐗╂枡
+                            ds = oCn.RunProcReturn("select  * from Gy_Material where HNumber='" + str[4] + "' and HUSEORGID=" + HOrgIDs, "Gy_Material");
+
+
+                            if (ds.Tables[0].Rows.Count == 0)
+                            {
+                                objJsonResult.code = "0";
+                                objJsonResult.count = 0;
+                                objJsonResult.Message = "鏉$爜瑙f瀽澶辫触,璇风‘璁ゆ潯鐮佺墿鏂欐槸鍚︽纭�!";
+                                objJsonResult.data = null;
+                                return objJsonResult;
+                            }
+                            else
+                            {
+                                HMaterIDs = ds.Tables[0].Rows[0]["HItemID"].ToString();
+                                HMaterNames = ds.Tables[0].Rows[0]["HName"].ToString();
+                                HMaterModels = ds.Tables[0].Rows[0]["HModel"].ToString();
+
+                            }
+                            string HSupIDs = "0";
+                            //鏌ヨ渚涘簲鍟�
+                            ds = oCn.RunProcReturn("select * from Gy_Supplier where HNumber='" + str[2] + "' and HUSEORGID=" + HOrgIDs, "Gy_Supplier");
+                            if (ds.Tables[0].Rows.Count == 0)
+                            {
+                                //sErrMsg = "鏉$爜瑙f瀽澶辫触,璇风‘璁ゆ潯鐮佷緵搴斿晢鏄惁姝g‘!";
+                                //return null;
+                            }
+                            else
+                            {
+                                HSupIDs = ds.Tables[0].Rows[0]["HItemID"].ToString();
+                            }
+
+                            string HSourceInterIDs = "0";
+                            string HSourceEntryIDs = "0";
+                            string HSourceBillNos = "0";
+                            string HUnitIDs = "0";
+                            //鏌ヨ閲囪喘璁㈠崟
+                            ds = oCn.RunProcReturn(@"select  a.HInterID,b.HEntryID,a.HBillNo,b.HUnitID from Cg_POOrderBillMain a
+inner join Cg_POOrderBillSub b on a.HInterID = b.HInterID where HBillNo='" + str[3] + "' and b.HMaterID=" + HMaterIDs, "Cg_POOrderBillMain");
+                            if (ds.Tables[0].Rows.Count == 0)
+                            {
+                                //sErrMsg = "鏉$爜瑙f瀽澶辫触,璇风‘璁ゆ潯鐮侀噰璐鍗曟槸鍚︽纭�!";
+                                //return null;
+                            }
+                            else
+                            {
+                                HSourceInterIDs = ds.Tables[0].Rows[0]["HInterID"].ToString();
+                                HSourceEntryIDs = ds.Tables[0].Rows[0]["HEntryID"].ToString();
+                                HSourceBillNos = ds.Tables[0].Rows[0]["HBillNo"].ToString();
+                                HUnitIDs = ds.Tables[0].Rows[0]["HUnitID"].ToString();
+                            }
+
+                            string HInnerBillNos = "";
+                            //鏌ヨ鍐呴儴閲囪喘璁㈠崟鍙�
+                            ds = oCn.RunProcReturn(@" select * from h_v_IF_POInStockList where 閲囪喘璁㈠崟鍙�= '" + str[3] + "' ", "h_v_IF_POInStockList");
+                            if (ds.Tables[0].Rows.Count == 0)
+                            {
+                                //sErrMsg = "鏉$爜瑙f瀽澶辫触,璇风‘璁ゆ潯鐮佸唴閮ㄩ噰璐鍗曞彿鏄惁姝g‘!";
+                                //return null;
+                                HInnerBillNos = str[3];
+                            }
+                            else
+                            {
+                                HInnerBillNos = ds.Tables[0].Rows[0]["鍐呴儴閲囪喘璁㈠崟鍙�"].ToString();
+                            }
+                            double HQty = double.Parse(str[6]);
+
+                            //鏃ユ湡鑾峰彇鏂瑰紡
+                            string sDate = DateTime.Now.ToString();
+                            string HWei = "0";      //灏炬暟
+                            string HBarCodeType = "鎵规鏉$爜";
+                            Int64 HMaterID = int.Parse(HMaterIDs);
+                            Int64 HAuxPropID = 0;
+                            Int64 HUnitID = int.Parse(HUnitIDs);
+                            double HQty2 = HQty;
+                            string HBatchNo2 = str[5];
+                            Int64 HSupID = int.Parse(HSupIDs);
+                            Int64 HGroupID = 0;
+                            int HPrintQty = 0;
+                            Int64 HSourceInterID = int.Parse(HSourceInterIDs);
+                            Int64 HSourceEntryID = int.Parse(HSourceEntryIDs);
+                            string HSourceBillNo = HSourceBillNos;
+                            //HSourceBillType = "1102";
+                            Int64 HBarcodeNo = 0;       //鎵樺彿
+                            Int64 HBarcodeQtys = 0;     //鎬绘墭鏁�
+                            Int64 HDeptID = 0;
+                            //Int64 HWhID = 0;
+                            //Int64 HSPID = 0;
+                            string HRemark = "鏉$爜瑙f瀽";
+                            string HMaterName = HMaterNames;
+                            string HMaterModel = HMaterModels;
+                            string HPinfan = "";
+                            string HMTONo = "";
+                            Int64 HCusID = 0;
+                            string HCusType = "";
+                            DateTime HEndDate = DateTime.Now;
+                            string HWorkLineName = "";
+                            string HSeOrderBillNo = "";
+                            string HInnerBillNo = HInnerBillNos;
+                            bool HGiveAwayFlag = false;
+                            Int64 HEntryID = 1;
+                            Int64 HInterIDs = DBUtility.ClsPub.CreateBillID_Prod("85", ref DBUtility.ClsPub.sExeReturnInfo);
+                            int HOrgID = HOrgIDs;
+                            string HSourceBillType = "";
+
+
+                            oCn.RunProc("insert into Gy_BarCodeBill (HBarCode,HBarCodeType,HMaterID,HUnitID,HQty" +
+                                               ",HBatchNo,HSupID,HGroupID,HMaker,HMakeDate,HPrintQty,HinitQty" +
+                                               ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HEndQty " +
+                                               ",HBarcodeQtys,HBarcodeNo,HDeptID,HWhID,HSPID,HRemark " +
+                                               ",HCusID,HCusType,HEndDate,HWorkLineName,HBarCodeDate " +
+                                               ",HSTOCKORGID,HOWNERID,HSeOrderBillNo,HInterID,HEntryID " +
+                                               ",HGiveAwayFlag " +
+                                               ",HMaterName,HMaterModel,HPinfan,HAuxPropID,HMTONo,HInnerBillNo" +
+                                               ",HProduceDate,HExpiryDate " +
+                                               ") values ("
+                                               + "'" + HBarCode + "','" + HBarCodeType + "'," + HMaterID.ToString() + "," + HUnitID.ToString() + "," + HQty2.ToString()
+                                               + ",'" + HBatchNo2 + "'," + HSupID.ToString() + "," + HGroupID.ToString() + ",'',getdate()," + HPrintQty.ToString() + "," + HQty2.ToString()
+                                               + ", " + HSourceInterID.ToString() + "," + HSourceEntryID.ToString() + ",'" + HSourceBillNo + "','" + HSourceBillType + "','" + HWei + "'"
+                                               + ", " + HBarcodeQtys.ToString() + "," + HBarcodeNo.ToString() + "," + HDeptID.ToString() + ",0,0,'" + HRemark + "'"
+                                               + ", " + HCusID.ToString() + ",'" + HCusType + "','" + HEndDate.ToShortDateString() + "','" + HWorkLineName + "','" + sDate + "'"
+                                               + ", " + HOrgID.ToString() + "," + HOrgID.ToString() + ",'" + HSeOrderBillNo + "'," + HInterIDs.ToString() + "," + HEntryID.ToString() + ""
+                                               + ", " + DBUtility.ClsPub.BoolToString(HGiveAwayFlag)
+                                               + ",'" + HMaterName + "','" + HMaterModel + "','" + HPinfan + "'," + HAuxPropID.ToString() + ",'" + HMTONo + "','" + HInnerBillNo + "','','')");
+
+
+                        }
+                    }
+                }
+
                 ds = oCn.RunProcReturn("exec h_p_WMS_AddBarCode_MaterToSource " + HInterID.ToString() + ",'" + HBillNo + "','" + HBillType + "','" + HBarCode + "','" + HMaker + "'", "h_p_WMS_AddBarCode_MaterToSource");
                 if (ds == null || ds.Tables[0].Rows.Count == 0)
                 {

--
Gitblit v1.9.1