物料码信息添加联动

dengjunjie

2025-01-13 1367287c9b6e56ba187eba9e5bc30eef4e744a5c

物料码信息添加联动

 ´úÂë¹ÜÀí/WMS/WIDESEA_WMSClient/src/extension/basic/materielCodeInfo.js

@@ -14,8 +14,42 @@
  tableAction: '', //指定某张表的权限(这里填写表名,默认不用填写)
  buttons: { view: [], box: [], detail: [] }, //扩展的按钮
  methods: {
    //获取表单配置
    getOption(field) {
      let option;
      this.editFormOptions.forEach(x => {
        x.forEach(item => {
          if (item.field == field) {
            option = item;
          }
        })
      })
      return option;
    },
    //下面这些方法可以保留也可以删除
    onInit() {  //框架初始化配置前，
      let materielCodeOption = this.getOption("materielCode");
      let purchaseOrderNoOption = this.getOption("purchaseOrderNo");
      materielCodeOption.onChange = (val, option) => {
        this.editFormFields.purchaseOrderNo = "";
        purchaseOrderNoOption.data = [];
        if (val == null || val == 0) {
          return this.$error("请选择物料编号！")
        }
        // console.log(val)
        // console.log(option)
        this.http.post("/api/PurchaseOrderDetail/GetPurchaseOrderInfo?materielCode=" + val, {}, true).then(
          source => {
            if (!source.status) return this.$error(source.message);
            for (let i = 0; i < source.data.length; i++) {
              purchaseOrderNoOption.data.push({ key: i, value: source.data[i] })
            }
            // this.editFormFields.InputOder_itemname = source.data.itemName;
            // this.$success(source.data.itemName);
            this.refresh();
          })
      }

      this.columns.push({
        field: '操作',
        title: '操作',

 ´úÂë¹ÜÀí/WMS/WIDESEA_WMSClient/src/views/basic/materielCodeInfo.vue

@@ -26,13 +26,17 @@
      url: "/MaterielCodeInfo/",
      sortName: "id",
    });
    const editFormFields = ref({});
    const editFormFields = ref({
      purchaseOrderNo:""
    });
    const editFormOptions = ref([
      [
        {
          title: "物料编码",
          field: "materielCode",
          required: true,
          type: "select",
          dataKey: "MaterielCodes",
          data: [],
        },
        {
          title: "批次号",
@@ -44,6 +48,9 @@
        {
          title: "采购单号",
          field: "purchaseOrderNo",
          type:"select",
          // dataKey: "purchaseOrderNos",
          data: [],
          required: true,
        },
        {
@@ -56,13 +63,13 @@
        {
          title: "生产日期",
          field: "productionDate",
          type:"date",
          type: "date",
          required: true,
        },
        {
          title: "有效期",
          field: "effectiveDate",
          type:"date",
          type: "date",
          required: true,
        },
      ],
@@ -148,7 +155,7 @@
        title: "修改人",
        type: "string",
        width: 100,
        hidden:true,
        hidden: true,
        align: "left",
      },
      {
@@ -157,7 +164,7 @@
        type: "datetime",
        width: 160,
        align: "left",
        hidden:true,
        hidden: true,
        sort: true,
      },
    ]);

 ´úÂë¹ÜÀí/WMS/WIDESEA_WMSServer/WIDESEA_IInboundService/IPurchaseOrderDetailService.cs

@@ -3,6 +3,7 @@
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using WIDESEA_Core;
using WIDESEA_Core.BaseServices;
using WIDESEA_IInboundRepository;
using WIDESEA_Model.Models;
@@ -11,6 +12,6 @@
{
    public interface IPurchaseOrderDetailService : IService<Dt_PurchaseOrderDetail>
    {

        WebResponseContent GetPurchaseOrderInfo(string materielCode);
    }
}

 ´úÂë¹ÜÀí/WMS/WIDESEA_WMSServer/WIDESEA_InboundService/PurchaseOrderDetailService.cs

@@ -3,6 +3,7 @@
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using WIDESEA_Core;
using WIDESEA_Core.BaseServices;
using WIDESEA_Core.Enums;
using WIDESEA_Core.Helper;
@@ -12,12 +13,28 @@

namespace WIDESEA_InboundService
{
    public class PurchaseOrderDetailService : ServiceBase<Dt_PurchaseOrderDetail, IPurchaseOrderDetailRepository>,IPurchaseOrderDetailService
    public class PurchaseOrderDetailService : ServiceBase<Dt_PurchaseOrderDetail, IPurchaseOrderDetailRepository>, IPurchaseOrderDetailService
    {
        public IPurchaseOrderDetailRepository Repository => BaseDal;

        public PurchaseOrderDetailService(IPurchaseOrderDetailRepository BaseDal) : base(BaseDal)
        {
        }

        public WebResponseContent GetPurchaseOrderInfo(string materielCode)
        {
            try
            {
                List<Dt_PurchaseOrderDetail> purchaseOrderDetails = BaseDal.QueryData(x => x.MaterielCode == materielCode);
                List<int> ids = purchaseOrderDetails.Select(x => x.PurchaseOrderId).ToList();
                List<Dt_PurchaseOrder> purchaseOrders = Db.Queryable<Dt_PurchaseOrder>().Where(x => ids.Contains(x.Id)).ToList();
                List<string> PurchaseOrderNos = purchaseOrders.Select(x => x.PurchaseOrderNo).ToList();
                return WebResponseContent.Instance.OK(data: PurchaseOrderNos);
            }
            catch (Exception ex)
            {
                return WebResponseContent.Instance.Error(ex.Message);
            }
        }
    }
}

 ´úÂë¹ÜÀí/WMS/WIDESEA_WMSServer/WIDESEA_WMSServer/Controllers/Inbound/PurchaseOrderDetailController.cs

@@ -1,5 +1,7 @@
using Microsoft.AspNetCore.Http;
using Microsoft.AspNetCore.Authorization;
using Microsoft.AspNetCore.Http;
using Microsoft.AspNetCore.Mvc;
using WIDESEA_Core;
using WIDESEA_Core.BaseController;
using WIDESEA_IInboundService;
using WIDESEA_Model.Models;
@@ -16,5 +18,10 @@
        public PurchaseOrderDetailController(IPurchaseOrderDetailService service) : base(service)
        {
        }
        [HttpPost, HttpGet, Route("GetPurchaseOrderInfo"), AllowAnonymous]
        public WebResponseContent GetPurchaseOrderInfo(string materielCode)
        {
            return Service.GetPurchaseOrderInfo(materielCode);
        }
    }
}