采购订单删除判断是否生成到货单

yl

2023-02-09 d734833a8520aad070ea4ad9fe7f768c2effe7f1

 VueWebApi/DLL/DAL/PurchaseOrderDAL.cs

@@ -138,6 +138,18 @@
            var dynamicParams = new DynamicParameters();
            try
            {
                //判断是否生成了采购到货单
                sql = @"select *  from T_PurchaseArrivalOrder where hsourcebillno=@po";
                dynamicParams.Add("@po", po);
                var data = DapperHelper.selectdata(sql, dynamicParams);
                if (data.Rows.Count > 0)
                {
                    mes.code = "300";
                    mes.count = 0;
                    mes.Message = "当前采购订单已生成到货单!";
                    mes.data = null;
                    return mes;
                }
                //删除采购订单主表
                sql = @"delete T_PurchaseOrder  where ordercode=@po";
                list.Add(new { str = sql, parm = new { po = po } });