进站单 出战单列表

ouyangqing

2021-01-18 6bed6363d097e27073657e65fefe5c5a306680be

进站单 出战单列表

 WebAPI/Controllers/NewApiController.cs

@@ -69,6 +69,28 @@
            return YqnQbService.GetWorkCenterList(sWhere);
        }
        /// <summary>
        /// 获取进站单列表
        /// </summary>
        /// <param name="sWhere"></param>
        /// <returns></returns>
        [Route("api/newBill/getStationInBillList")]
        [HttpGet]
        public ApiResult<DataSet> GetStationInBillList(string sWhere)
        {
            return YqnQbService.GetStationInBillList(sWhere);
        }
        /// <summary>
        /// 获取出站单列表
        /// </summary>
        /// <param name="sWhere"></param>
        /// <returns></returns>
        [Route("api/newBill/getStationOutBillList")]
        [HttpGet]
        public ApiResult<DataSet> GetStationOutBillList(string sWhere)
        {
            return YqnQbService.GetStationOutBillList(sWhere);
        }
        /// <summary>
        /// 进站接收单
        /// </summary>
        /// <param name="oMain"></param>

 WebAPI/Service/YqnQbService.cs

@@ -91,6 +91,8 @@
        {
            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)
            {
@@ -104,11 +106,51 @@
        public static ApiResult SetStationOutBill(Model.ClsSc_StationOutBillMain 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();

 WebAPI/Web References/WebS/Reference.cs

@@ -30059,11 +30059,11 @@
    }
    
    /// <remarks/>
    [System.CodeDom.Compiler.GeneratedCodeAttribute("System.Xml", "4.8.3752.0")]
    [System.SerializableAttribute()]
    [System.Diagnostics.DebuggerStepThroughAttribute()]
    [System.ComponentModel.DesignerCategoryAttribute("code")]
    [System.Xml.Serialization.XmlTypeAttribute(Namespace="http://tempuri.org/")]
    //[System.CodeDom.Compiler.GeneratedCodeAttribute("System.Xml", "4.8.3752.0")]
    //[System.SerializableAttribute()]
    //[System.Diagnostics.DebuggerStepThroughAttribute()]
    //[System.ComponentModel.DesignerCategoryAttribute("code")]
    //[System.Xml.Serialization.XmlTypeAttribute(Namespace="http://tempuri.org/")]
    public partial class ClsSc_StationInBillMain : ClsXt_BaseBillMain {
        
        private long hPrintQtyField;