已上传单据搜索功能页签

zzr99

2022-04-01 33de192bcd396abf708fcbc29861482b17b549a2

已上传单据搜索功能页签

 DAL/WMS/ClsKF_PonderationBillMain_Temp_View.cs

@@ -89,7 +89,7 @@
                return Ds;
            }
        }

        //缓存列表已上传列表
        public DataSet GetKf_ICStockBillList(string sHBillType, string sHMaker, Int64 sHOWNERID)
        {
            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
@@ -103,6 +103,20 @@
                return Ds;
            }
        }
        //缓存列表已上传查询
        public DataSet GetKf_ICStockBillQueryList(string BillType,string HBillNo, string HSourceBillNo)
        {
            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
            DataSet Ds = oCn.RunProcReturn("exec h_p_Kf_ICStockBillQueryList '" + BillType + "','" + HBillNo + "','" + HSourceBillNo+"'", "h_p_Kf_ICStockBillQueryList");
            if (Ds == null || Ds.Tables[0].Rows.Count == 0)
            {
                return null;
            }
            else
            {
                return Ds;
            }
        }

        //扫描条码返回出入库条码临时表信息
        public DataSet GetInfoByID_View(long HInterID, string sBillType, string sWhere)

 WebAPI/Controllers/SellOutController.cs

@@ -146,7 +146,43 @@
                return objJsonResult;
            }
        }
        //已上传查询
        [Route("Web/QueryBillUpdateLoad_Json")]
        [HttpGet]
        public object QueryBillUpdateLoad_Json(string BillType, string HBillNo, string HSourceBillNo)
        {
            try
            {
                ds = webserver.GetQueryBillUpdateLoad_Json(BillType, HBillNo, HSourceBillNo);
                if (ds == null || ds.Tables[0].Rows.Count <= 0)
                {

                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "没有返回任何记录！";
                    objJsonResult.data = null;
                    return objJsonResult;
                    //DBUtility.ClsPub.MessageBeep((int)DBUtility.ClsPub.BeepType.Warning);
                }
                else
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 1;
                    objJsonResult.Message = "获取信息成功！";
                    objJsonResult.data = ds.Tables[0];
                    return objJsonResult;
                }
            }
            catch (Exception e)
            {

                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "没有返回任何记录！" + e.ToString();
                objJsonResult.data = null;
                return objJsonResult;
            }
        }


        [Route("SellOut/GetMAXNum")]

 WebAPI/WebServer.cs

@@ -7994,5 +7994,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);
        }

    }
}