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

yl

2023-02-09 d734833a8520aad070ea4ad9fe7f768c2effe7f1

 VueWebApi/DLL/DAL/PurchaseOrderDAL.cs

@@ -80,12 +80,44 @@
                            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 = "查询成功!";
                mes.count = total;
                mes.data = data.ToList();
            }
            catch (Exception e)
            {
                mes.code = "300";
                mes.count = 0;
                mes.Message = e.Message;
                mes.data = null;
            }
            return mes;
        }
        #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)
            {
@@ -106,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 } });