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

yl

2023-02-09 4f18572bce174f7d131e11d3f69156183ff7c71d

 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)
        {