nothing

王 垚

2022-06-27 59693266674a64233b0aea00e61782e07589b3cb

 WebAPI/WebServer.cs

@@ -54,6 +54,8 @@
            //return dal.GetList(sWhere);
        }

       

        /// <summary>
        /// 获取物料列表
        /// </summary>
@@ -3839,6 +3841,28 @@
            }
        }

        //根据托条码  获取条码档案列表唯一码信息
        public DataSet GetBarCode(string HBarCode)
        {
            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
            //
            try
            {
                DataSet DS = oCn.RunProcReturn("select HBarCode,HQty from Sc_PackUnionBillSub where HBarCode_Pack ='" + HBarCode.ToString() + "'", "Sc_PackUnionBillSub", ref DBUtility.ClsPub.sExeReturnInfo);
                //DataSet DS = oCn.RunProcReturn("Select * from h_v_Sc_AssemblyBill Where HInterID=" + HInterID.ToString() + " and HBillType='" + sBillType + "' " + sWhere, "h_v_Sc_AssemblyBill", ref DBUtility.ClsPub.sExeReturnInfo);
                if (DS.Tables[0].Rows.Count == 0)
                    return null;
                else
                {
                    return DS;
                }
            }
            catch (Exception e)
            {
                throw (e);
            }
        }

        public DataSet GetHBW(long HBadType)
        {
            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
@@ -4048,6 +4072,68 @@
                return false;
            }
        }
        //删除单据临时表信息
        public bool DeleteBill_AN(long HInterID, long HMaterID, long HAuxPropID, string HMTONo, long HSourceInterID, long HSourceEntryID, string sHBillType, ref string sErrMsg)
        {
            //DAL.ClsKF_PonderationBillMain_Temp_Ctl dal = new DAL.ClsKF_PonderationBillMain_Temp_Ctl();
            //if (dal.DeleteByInterIDAndSource(HInterID, HMaterID, HAuxPropID, HMTONo, HSourceInterID, HSourceEntryID, sHBillType))
            //{
            //    sErrMsg = "删除成功！";
            //    return true;
            //}
            //else
            //{
            //    sErrMsg = "删除失败！";
            //    return false;
            //}
            WebS.WebService1 oWebs = new WebS.WebService1();

            if (oWebs.set_DelPonderationBillMain_Temp_InterIDAndSource(HInterID, HMaterID, HAuxPropID, HMTONo, HSourceInterID, HSourceEntryID, sHBillType, ref DBUtility.ClsPub.sErrInfo))
            {
                sErrMsg = "删除成功！";
                return true;
            }
            else
            {
                sErrMsg = "删除失败！";
                return false;
            }

            //if (WebSoBar == null)
            //{
            //    objJsonResult.code = "0";
            //    objJsonResult.count = 0;
            //    objJsonResult.Message = DBUtility.ClsPub.sErrInfo;
            //    objJsonResult.data = null;
            //    return objJsonResult;
            //}
            //else
            //{
            //    objJsonResult.code = "0";
            //    objJsonResult.count = 1;
            //    objJsonResult.Message = DBUtility.ClsPub.sErrInfo;
            //    objJsonResult.data = WebSoBar;
            //    return objJsonResult;
            //}

        }

        //删除单据临时表信息
        public bool DeleteBill(Int64 sHInterID, string HBillNo, string HBillType, string HBarCode, ref string sErrMsg)
        {
            DAL.ClsKF_PonderationBillMain_Temp_Ctl dal = new DAL.ClsKF_PonderationBillMain_Temp_Ctl();
            if (dal.DeleteBill(sHInterID, HBillNo, HBillType, HBarCode))
            {
                sErrMsg = "删除成功！";
                return true;
            }
            else
            {
                sErrMsg = "删除失败！";
                return false;
            }
        }

        //public Model.ClsGy_BarCodeBill_WMS_Model_View get_InfoByBarCode_Source(string sBarCode, Int64 sInterID, ref bool sBool, ref string sErrMsg)
        //{
        //    SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
@@ -4080,7 +4166,7 @@
        //        return null;
        //    }
        //}
 

        #endregion

        #region 外购入库
@@ -4285,6 +4371,19 @@
            return  bll.GetKf_PonderationBillMain_Temp(HInterID, sBillType,sWhere,ref DBUtility.ClsPub.sExeReturnInfo);
            //DAL.ClsKF_PonderationBillMain_Temp_View dal = new DAL.ClsKF_PonderationBillMain_Temp_View();
            //return dal.GetInfoByID_View(HInterID, sBillType, sWhere);
        }

        public bool Get_CheckQtyByBarCode(string sBarcode, long HWHID, long HSPID, long HAuxPropID, string sBatchNo, string HMTONo, double sQty, ref double sRelQty)
        {
            DAL.ClsKF_PonderationBillMain_Temp_View dal = new DAL.ClsKF_PonderationBillMain_Temp_View();
            if (dal.CheckQtyByBarCode(sBarcode, HWHID, HSPID, HAuxPropID, sBatchNo, HMTONo, sQty, ref sRelQty))
            {
                return true;
            }
            else
            {
                return false;
            }
        }

        public DataSet GetSPInfoByIDandHWHIDandOrg(long sItemID, long sHWHID, long HUSEORGID, ref string sErrMsg)
@@ -7847,6 +7946,33 @@
        }
        #endregion

        //返回条码临时表
        /// <summary>
        /// 返回条码临时表
        /// </summary>
        public DataSet GetBarCode_Temp(long HInterID, long HMaterID, Int64 HAuxPropID, string HMTONo, Int64 HWhID, Int64 HSPID, Int64 HSCWhID, Int64 HSCSPID, string HBatchNo, Int64 HSourceInterID, Int64 HSourceEntryID, string sBillType, string sWhere)
        {
            DAL.ClsKF_PonderationBillMain_Temp_View dal = new DAL.ClsKF_PonderationBillMain_Temp_View();
            return dal.GetBarCodeByID_View(HInterID, sBillType, HMaterID, HAuxPropID, HMTONo, HWhID, HSPID, HSCWhID, HSCSPID, HBatchNo, HSourceInterID, HSourceEntryID, sWhere);
        }

        //删除出入库条码临时表(根据条码)
        public bool set_DelPonderationBillMain_Temp_BarCode(long HInterID, string sBarCode, string sHBillType, ref string sErrMsg)
        {
            DAL.ClsKF_PonderationBillMain_Temp_Ctl dal = new DAL.ClsKF_PonderationBillMain_Temp_Ctl();
            if (dal.DeleteByBarCode(HInterID, sBarCode, sHBillType))
            {
                sErrMsg = "删除成功！";
                return true;
            }
            else
            {
                sErrMsg = "删除失败！";
                return false;
            }
        }


        /// <summary>
        /// 返回扫码明细信息
        /// </summary>
@@ -7881,5 +8007,12 @@
            return dal.GetKf_ICStockBillList(sHBillType, HMaker, HOrgID);
        }

        //返回缓存列表查询已上传列表信息
        public DataSet GetQueryBillUpdateLoad_Json(string BillType, string HBillNo, string HSourceBillNo)
        {
            DAL.ClsKF_PonderationBillMain_Temp_View dal = new DAL.ClsKF_PonderationBillMain_Temp_View();
            return dal.GetKf_ICStockBillQueryList(BillType, HBillNo, HSourceBillNo);
        }

    }
}