工序流转卡 功能更新

yangle

2022-06-02 8c59c2302ab3c82ee94f7af51d1cfad2a70b1ec6

 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();
@@ -4049,7 +4073,53 @@
            }
        }
        //删除单据临时表信息
        public bool DeleteBill(Int64 sHInterID,string HBillNo,string HBillType,string HBarCode, ref string sErrMsg)
        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))
@@ -4301,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)
@@ -7924,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);
        }

    }
}