1

沈泽

2021-09-22 32eca634074e0fa7bd11d4f6f415c0d4cee1b6cb

 WebAPI/Controllers/Sc_CheckToolsRepairWorkBillListController.cs

@@ -4209,7 +4209,7 @@

        #region 器具改制入库单据维护列表

        [Route("Sc_MouldRepairInBillList/GetMouldRepairInBillList")]
        [Route("Sc_CheckToolsRepairWorkBillList/GetMouldRepairInBillList")]
        [HttpGet]
        public object GetMouldRepairInBillList(string sWhere)
        {
@@ -4526,6 +4526,23 @@
                objJsonResult.data = null;
                return objJsonResult;
            }
        }
        #endregion

        #region[模具改制入库单编辑时获取表头数据]
        [Route("Sc_CheckToolsRepairWorkBillList/Sc_MouldRepairInHouseBillListCheckDetai")]
        [HttpGet]
        public ApiResult<DataSet> Sc_MouldRepairInHouseBillListCheckDetai(string HID)
        {
            if (string.IsNullOrEmpty(HID))
                return new ApiResult<DataSet> { code = -1, msg = "ID不能为空" };
            SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();

            var dataSet = oCN.RunProcReturn("select top 1 * from h_v_Sc_MouldProdInHouseBillList  where hmainid= " + HID + " ", "h_v_Sc_MouldProdInHouseBillList");
            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 };
        }
        #endregion

@@ -4936,7 +4953,7 @@
        //                                                   HSecUnitID, 辅助计量单位代码 HSecUnitCode, 辅助计量单位 HSecUnitName,换算率 HSecUnitRate,
        //                                                   HUnitID, 计量单位代码 HUnitCode, 计量单位 HUnitName,
        //                                                   设计寿命 HDesignLife, 原剩余寿命 HLeaveLife, 新剩余寿命 HNewLife,表体备注 HRemark 
          //                                                FROM h_v_Sc_MouldLifeChangeBillList_Edit"), "h_v_Sc_MouldLifeChangeBillList_Edit");
        //                                                FROM h_v_Sc_MouldLifeChangeBillList_Edit"), "h_v_Sc_MouldLifeChangeBillList_Edit");

        //            objJsonResult.code = "0";
        //            objJsonResult.count = 1;
@@ -4951,7 +4968,7 @@
        //                                          HSecUnitID, 辅助计量单位代码 HSecUnitCode, 辅助计量单位 HSecUnitName,换算率 HSecUnitRate,
        //                                          HUnitID, 计量单位代码 HUnitCode, 计量单位 HUnitName,
        //                                          设计寿命 HDesignLife, 原剩余寿命 HLeaveLife, 新剩余寿命 HNewLife,表体备注 HRemark 
          //                                       FROM h_v_Sc_MouldLifeChangeBillList_Edit where 1 = 1 ");
        //                                       FROM h_v_Sc_MouldLifeChangeBillList_Edit where 1 = 1 ");
        //            string sql = sql1 + sqlWhere;
        //            ds = oCN.RunProcReturn(sql, "h_v_Sc_MouldLifeChangeBillList_Edit");