新增了AGV配送单扫码 提交方法

ch

2022-06-12 ba7e5319a81ba10a12bb1461c7377057e45bc53b

新增了AGV配送单扫码 提交方法

 CLOUDWEB/CLOUDWEB.csproj

@@ -61,9 +61,8 @@
      <HintPath>..\DLL\Kingdee.BOS.WebApi.ServicesStub.dll</HintPath>
    </Reference>
    <Reference Include="Microsoft.CSharp" />
    <Reference Include="Model, Version=1.0.0.0, Culture=neutral, processorArchitecture=x86">
      <SpecificVersion>False</SpecificVersion>
      <HintPath>..\DLL\Model.dll</HintPath>
    <Reference Include="Model">
      <HintPath>C:\Users\37327\Desktop\MES源代码\NETERP\bin\x86\Debug\Model.dll</HintPath>
    </Reference>
    <Reference Include="Newtonsoft.Json, Version=4.5.0.0, Culture=neutral, PublicKeyToken=30ad4fe6b2a6aeed, processorArchitecture=MSIL">
      <SpecificVersion>False</SpecificVersion>

 CLOUDWEB/WebService1.asmx.cs

@@ -23454,6 +23454,9 @@
            }
        }


        

        /// <summary>
        /// 产品入库单
        /// </summary>
@@ -23603,6 +23606,88 @@

        #endregion

        [WebMethod]
        //根据物料条码 返回物料信息  规格型号  数量
        public bool GetInfoByBarCode(string sBarCode, ref string sMaterName, ref string sMaterNumber, ref long sMaterID, ref string sMaterModel, ref long sUnitID, ref string sUnitName, ref double sQty)
        {
            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
            DataSet Ds = oCn.RunProcReturn("exec h_p_GetInfoByBarCode_AGV '" + sBarCode + "'", "h_p_GetInfoByBarCode_AGV");
            if (Ds == null || Ds.Tables[0].Rows.Count == 0)
            {
                return false;
            }
            else
            {
                sMaterName = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HMaterName"]);
                sMaterNumber = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HMaterNumber"]);
                sMaterID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HMaterID"]);
                sMaterModel = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HMaterModel"]);
                sUnitID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HUnitID"]);
                sUnitName = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HUnitName"]);
                sQty = DBUtility.ClsPub.isDoule(Ds.Tables[0].Rows[0]["HQty"]);
            }
            return true;
        }

        [WebMethod]
        public bool set_SaveKf_AGVRequestBill(Model.ClsKf_AGVRequestBillMain oMain, ref string sErrMsg)
        {
            if (SaveKf_AGVRequestBill(oMain, ref sErrMsg))
            {
                //"保存成功！";
                sErrMsg = "保存成功！" + oMain.HBillNo;
                return true;
            }
            else
            {
                //"保存失败！";
                sErrMsg = sErrMsg;
                return false;
            }
        }



        /// <summary>
        /// AGV配送单
        /// </summary>
        /// <param name="oMain"></param>
        /// <param name="sErrMsg"></param>
        /// <returns></returns>
        public bool SaveKf_AGVRequestBill(Model.ClsKf_AGVRequestBillMain oMain, ref string sErrMsg)
        {
            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
            try
            {
                //插入子表
                oCn.RunProc("Insert Into Kf_AGVRequestBillMain   " +
                "(HBillType,HBillSubType,HInterID,HBillNo,HDate,HMainSourceBillType" +
                ",HYear,HPeriod,HRemark,HMaker,HMakeDate" +
                ",HSPID,HWHID,HSCWHID,HSCSPID,HOWNERID" +
                ") " +
                " values('1299','1299'," + oMain.HInterID.ToString() + ",'" + oMain.HBillNo + "',convert(varchar(10),getdate(),120),''" +
                ",2012,1,'" + oMain.HRemark + "','" + oMain.HMaker + "',convert(varchar(10),getdate(),120)" +
                ", " + oMain.HSPID.ToString() + "," + oMain.HWHID.ToString() + "," + oMain.HSCWHID.ToString() + "," + oMain.HSCSPID.ToString() + "," + oMain.HOrgID.ToString() +
                ") ");
                //插入主表
                oCn.RunProc("Insert Into Kf_AGVRequestBillSub   " +
                "(HBillType,HBillSubType,HInterID,HBillNo,HDate,HMainSourceBillType" +
                ",HYear,HPeriod,HRemark,HMaker,HMakeDate" +
                 ",HSPID,HWHID,HSCWHID,HSCSPID,HQty,HMaterID,HOWNERID" +
                ") " +
                 " values('1299','1299'," + oMain.HInterID.ToString() + ",'" + oMain.HBillNo + "',convert(varchar(10),getdate(),120),''" +
                ",2012,1,'" + oMain.HRemark + "','" + oMain.HMaker + "',convert(varchar(10),getdate(),120)" +
                ", " + oMain.HSPID.ToString() + "," + oMain.HWHID.ToString() + "," + oMain.HSCWHID.ToString() + "," + oMain.HSCSPID.ToString() + "," + oMain.HQty.ToString() + "," + oMain.HMaterID.ToString() + "," + oMain.HOrgID.ToString() +
                ") ");
                return true;
            }
            catch (Exception e)
            {
                sErrMsg = "AGV配送单失败！" + e.Message;
                return false;
            }
        }

        #region 产品退库    产品入库（红字）   *旧

        //生成产品退库单

 DLL/Model.dll

Binary files differ

 DLL/Model.rar

Binary files differ