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

yl

2023-02-09 4f18572bce174f7d131e11d3f69156183ff7c71d

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

 .vs/VueWebApi/v16/.suo

Binary files differ

 VueWebApi/Controllers/ProductModelController.cs

@@ -245,7 +245,7 @@
            string maxstockqty = obj["maxstockqty"].ToString(); //最大库存
            string is_batchno = obj["is_batchno"].ToString();   //是否批次管理
            string is_fifo = obj["is_fifo"].ToString();         //是否先进先出
            string is_incheck = obj["is_incheck"].ToString();   //是否入库检验
            string is_incheck = obj["is_incheck"].ToString();   //是否入厂检验
            string is_outcheck = obj["is_outcheck"].ToString(); //是否出厂检验
            var username = HttpContext.Current.Request.Cookies["admin"].Value.ToString(); //操作人员
            string OperType = obj["OperType"].ToString();  //操作类型

 VueWebApi/Controllers/PurchaseOrderController.cs

@@ -61,6 +61,16 @@
        }
        #endregion

        #region[采购订单明细]
        [Route(template: "PurchaseOrderSubSearch")]
        [HttpGet]
        public HttpResponseMessage PurchaseOrderSubSearch(string purodercode)
        {
            mes = PurchaseOrderBLL.PurchaseOrderSubSearch(purodercode);
            return TJson.toJson(mes);
        }
        #endregion

        #region[采购订单删除]
        /// <summary>
        /// 采购订单删除

 VueWebApi/DLL/BLL/PurchaseOrderBLL.cs

@@ -16,6 +16,13 @@
        }
        #endregion

        #region[采购订单明细]
        public static ToMessage PurchaseOrderSubSearch(string purodercode)
        {
            return PurchaseOrderDAL.PurchaseOrderSubSearch(purodercode);
        }
        #endregion

        #region[采购订单删除]
        public static ToMessage DeletePurchaseOrder(string po)
        {

 VueWebApi/DLL/DAL/PurchaseOrderDAL.cs

@@ -80,7 +80,7 @@
                            left join TOrganization T on  A.departmentcode=T.org_code 
                            left join TCustomer C on A.customercode=C.code 
                            left join TUser U on A.auditorusercode=U.usercode
                            where  T.description='D' and C.mtype='WG' " + search;
                            where  1=1 " + search;
                var data = DapperHelper.GetPageList<object>(sql, dynamicParams, prop, order, startNum, endNum, out total);
                mes.code = "200";
                mes.Message = "查询成功!";
@@ -98,6 +98,38 @@
        }
        #endregion

        #region[采购订单明细]
        public static ToMessage PurchaseOrderSubSearch(string purodercode)
        {
            string sql = "";
            var dynamicParams = new DynamicParameters();
            try
            {
                //获取采购订单物料信息
                sql = @"select M.partcode,M.partname,M.partspec,T.name as uomname,A.quantity,A.countarrivalquantity,A.countInquantity,
                        A.acceptdate,S.name as housename,M.is_incheck
                        from T_PurchaseOrder_sub A
                        left join TMateriel_Info M on A.materiel_code=M.partcode
                        left join TUom T on M.uom_code=T.code
                        left join T_Sec_Stck S on A.warehousecode=S.code
                        where A.purchaesorder_code=@purodercode";
                dynamicParams.Add("@purodercode", purodercode);
                var data = DapperHelper.selectdata(sql, dynamicParams);
                mes.code = "200";
                mes.Message = "查询成功!";
                mes.data = data;
            }
            catch (Exception e)
            {
                mes.code = "300";
                mes.count = 0;
                mes.Message = e.Message;
                mes.data = null;
            }
            return mes;
        }
        #endregion

        #region[采购订单删除]
        public static ToMessage DeletePurchaseOrder(string po)
        {