采购订单存储过程修改、采购订单明细接口

yl

2023-02-09 4f18572bce174f7d131e11d3f69156183ff7c71d

 VueWebApi/DLL/BLL/ProductModelBLL.cs

@@ -1,5 +1,6 @@
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Web;
using VueWebApi.DLL.DAL;
@@ -69,6 +70,13 @@
        }
        #endregion

        #region[单位下拉列表查询]
        public static ToMessage UomSelect()
        {
            return ProductModelDAL.UomSelect();
        }
        #endregion

        #region[存货档案查询]
        public static ToMessage InventoryFileSelect(string partcode, string partname, string partspec, string stocktypecode, string materialtypecode, string storehousecode, int startNum, int endNum, string prop, string order)
        {
@@ -77,9 +85,9 @@
        #endregion

        #region[存货档案新增编辑]
        public static ToMessage AddUpdateInventoryFile(string materialid, string materialcode, string materialname, string materialspec, string uomcode, string warehousecode, string stocktypecode, string materialtypecode, string minstockqty, string maxstockqty, string username, string operType)
        public static ToMessage AddUpdateInventoryFile(string materialid, string materialcode, string materialname, string materialspec, string uomcode, string warehousecode, string stocktypecode, string materialtypecode, string minstockqty, string maxstockqty,string is_batchno,string is_fifo,string is_incheck,string is_outcheck, string username, string operType)
        {
            return ProductModelDAL.AddUpdateInventoryFile(materialid, materialcode, materialname, materialspec, uomcode, warehousecode, stocktypecode, materialtypecode, minstockqty, maxstockqty, username, operType);
            return ProductModelDAL.AddUpdateInventoryFile(materialid, materialcode, materialname, materialspec, uomcode, warehousecode, stocktypecode, materialtypecode, minstockqty, maxstockqty, is_batchno, is_fifo, is_incheck, is_outcheck, username, operType);
        }
        #endregion

@@ -98,15 +106,58 @@
        #endregion

        #region[存货档案关联工艺路线提交]
        public static ToMessage SaveInventoryFile(string partcode,string username, List<ObjectData> json)
        public static ToMessage SaveInventoryFile(string partcode,string defaultroute_code, string username, List<ObjectData> json)
        {
            return ProductModelDAL.SaveInventoryFile(partcode, username, json);
            return ProductModelDAL.SaveInventoryFile(partcode, defaultroute_code, username, json);
        }
        #endregion



        #region[物料清单主列表查询]
        public static ToMessage BoIventorySelect(string parentpartcode, string parentpartname,string parentpartspec,string parttype, string status, string version, string createusername, string createopendate, string createclosedate, int startNum, int endNum, string prop, string order)
        {
            return ProductModelDAL.BoIventorySelect(parentpartcode, parentpartname, parentpartspec, parttype, status, version, createusername, createopendate, createclosedate, startNum, endNum, prop, order);
        }
        #endregion

        #region[物料清单新增时获取最大版本号]
        public static ToMessage MaterielDetailedVsion(string parentpartcode)
        {
            return ProductModelDAL.MaterielDetailedVsion(parentpartcode);
        }
        #endregion

        #region[物料清单新增/编辑提交]
        public static ToMessage AddUpdateBoIventory(string bomid,string parentpartcode, string parentpartname, string parentpartspec, string status, string uomcode, string quantity, string startdate, string version, string username, string opertype, List<BomSub> objs)
        {
            return ProductModelDAL.AddUpdateBoIventory(bomid,parentpartcode, parentpartname, parentpartspec, status, uomcode, quantity, startdate, version, username, opertype, objs);
        }
        #endregion

        #region[物料清单编辑显示及预览]
        public static ToMessage BoIventorySelectView(string bomid)
        {
            return ProductModelDAL.BoIventorySelectView(bomid);
        }
        #endregion

        #region[物料清单删除]
        public static ToMessage DeleteBoIventory(string bomid)
        {
            return ProductModelDAL.DeleteBoIventory(bomid);
        }
        #endregion




        #region[工序下拉查询接口]
        public static ToMessage StepSelect()
        {
            return ProductModelDAL.StepSelect();
        }
        #endregion

        #region[工艺路线查询]
        public static ToMessage RouteSearch(string routecode, string routename, string description, string createuser, int startNum, int endNum, string prop, string order)
@@ -172,5 +223,79 @@
            return ProductModelDAL.SaveStepAssociationEqp(stepcode,username,json);
        }
        #endregion

        #region[工序关联缺陷查询]
        public static ToMessage StepAssociationDefect(string stepcode)
        {
            return ProductModelDAL.StepAssociationDefect(stepcode);
        }
        #endregion

        #region[工序关联缺陷提交]
        public static ToMessage SaveStepAssociationDefect(string stepcode, string username, List<ObjectData> json)
        {
            return ProductModelDAL.SaveStepAssociationDefect(stepcode,username,json);
        }
        #endregion





        #region[产品信息下拉框查询]
        public static ToMessage PartSelect()
        {
            return ProductModelDAL.PartSelect();
        }
        #endregion

        #region[产品编码查找工艺路线下拉框]
        public static ToMessage PartSelectRpute(string partcode)
        {
            return ProductModelDAL.PartSelectRpute(partcode);
        }
        #endregion

        #region[根据工艺路线编码查找关联工序集合]
        public static ToMessage RouteSelectStep(string routecode)
        {
            return ProductModelDAL.RouteSelectStep(routecode);
        }
        #endregion

        #region[根据工序线编码查找关联设备下拉框集合]
        public static ToMessage StepSelectEqp(string stepcode)
        {
            return ProductModelDAL.StepSelectEqp(stepcode);
        }
        #endregion

        #region[根据工序线编码查找关联设备集合]
        public static ToMessage StepSelectEqpList(string partcode, string routecode, string stepcode, int startNum, int endNum, string prop, string order)
        {
            return ProductModelDAL.StepSelectEqpList(partcode, routecode, stepcode, startNum, endNum, prop, order);
        }
        #endregion

        #region[节拍工价查询]
        public static ToMessage BeatRateSearch(string partcode,string routecode, string stepcode, string eqpcode,int startNum, int endNum, string prop, string order)
        {
            return ProductModelDAL.BeatRateSearch(partcode,routecode, stepcode, eqpcode, startNum, endNum, prop, order);
        }
        #endregion

        #region[节拍工价提交]
        public static ToMessage SaveBeatRate(string partcode, string routecode, string stepcode, string eqpcode, string wkshopcode, string eqp_value, string stand_value, string cavity_qty, string unprice, string username)
        {
            return ProductModelDAL.SaveBeatRate(partcode, routecode, stepcode, eqpcode, wkshopcode, eqp_value, stand_value, cavity_qty, unprice, username);
        }
        #endregion

        #region[节拍工价删除]
        public static ToMessage DeleteBeatRate(string partcode, string routecode, string stepcode, string eqpcode)
        {
            return ProductModelDAL.SaveBeatRate(partcode,routecode,stepcode,eqpcode);
        }
        #endregion
    }
}