Revert "进站单 出战单列表"

ouyangqing

2021-01-20 28dd4b8174c87b0576422db3a366d5c12c146c80

 WebAPI/Service/YqnQbService.cs

@@ -91,8 +91,6 @@
        {
            WebS.WebService1 oWebs = new WebS.WebService1();
            string sErrMsg = string.Empty;
            oMain.HYear = 2021;
            oMain.HPeriod = 1;
            var result = oWebs.set_SaveStationInBill(oMain, ref  sErrMsg);
            if (!result)
            {
@@ -106,51 +104,11 @@
        public static ApiResult SetStationOutBill(StationOutBillView omodel)
        {
            WebS.WebService1 oWebs = new WebS.WebService1();
            omodel.HYear = 2021;
            omodel.HPeriod = 1;
            string sErrMsg = string.Empty;
            var result = SetOutBill(omodel);
            return result;
        }
        /// <summary>
        /// 获取进站单列表
        /// </summary>
        /// <param name="sWhere"></param>
        /// <returns></returns>
        public static ApiResult<DataSet> GetStationInBillList(string sWhere)
        {
            var dataSet = GetStationInBill(sWhere);
            if (dataSet == null || dataSet.Tables[0].Rows.Count == 0)
                return new ApiResult<DataSet> { code = -1, msg = "未查询到数据" };
            return new ApiResult<DataSet> { code = 1, msg = "查询成功", data = dataSet };
        }
        /// <summary>
        /// 获取出站单列表
        /// </summary>
        /// <param name="sWhere"></param>
        /// <returns></returns>
        public static ApiResult<DataSet> GetStationOutBillList(string sWhere)
        {
            var dataSet = GetStationOutBill(sWhere);
            if (dataSet == null || dataSet.Tables[0].Rows.Count == 0)
                return new ApiResult<DataSet> { code = -1, msg = "未查询到数据" };
            return new ApiResult<DataSet> { code = 1, msg = "查询成功", data = dataSet };
        }
        #region sql语句
        public static DataSet GetStationOutBill(string strWhere)
        {
            var sql = "Select top 5000 * from h_v_MES_StationOutBillList Where 1=1 " + strWhere;
            SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
            var dataSet = oCN.RunProcReturn(sql, "h_v_MES_StationOutBillList");
            return dataSet;
        }
        public static DataSet GetStationInBill(string strWhere)
        {
            var sql = "Select top 5000 * from h_v_MES_StationInBillList Where 1=1 " + strWhere;
            SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
            var dataSet= oCN.RunProcReturn(sql, "h_v_MES_StationInBillList");
            return dataSet;
        }
        public static DataSet GetBarCodeDb(string billBarCode)
        {
            SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();