1.采购到货接口修改 2.停用设备过滤

yl

2023-04-12 01b5ef474e1a5d8dc682b64312f23bdbb0fdf3a7

 VueWebApi/DLL/DAL/PurchaseOrderDAL.cs

@@ -74,8 +74,7 @@
                }
                // --------------查询指定数据--------------
                var total = 0; //总条数
                var sql = @"select case when A.status='NEW' then '新订单' when A.status='CHECK' then '已审核' when A.status='CLOSED' then '已关闭'  end as status,
                            A.orderdate,A.ordercode,T.org_name as deptname,C.name as customername,A.saleorderCode,A.acceptdate,A.lm_user,A.lm_date,U.username as auditoruser,A.auditordate  
                var sql = @"select  A.status,A.orderdate,A.ordercode,T.org_name as deptname,C.name as customername,A.saleorderCode,A.acceptdate,A.lm_user,A.lm_date,U.username as auditoruser,A.auditordate  
                            from T_PurchaseOrder A
                            left join TOrganization T on  A.departmentcode=T.org_code 
                            left join TCustomer C on A.customercode=C.code 
@@ -106,13 +105,13 @@
            try
            {
                //获取采购订单物料信息
                sql = @"select M.partcode,M.partname,M.partspec,T.name as uomname,A.quantity,A.countarrivalquantity,A.countInquantity,
                sql = @"select M.partcode,M.partname,M.partspec,T.name as uomname,A.quantity,A.countarrivalquantity,A.countInquantity,A.countreturnquantity,
                        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";
                        where A.purchaseorder_code=@purodercode";
                dynamicParams.Add("@purodercode", purodercode);
                var data = DapperHelper.selectdata(sql, dynamicParams);
                mes.code = "200";
@@ -232,8 +231,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 = @"update T_PurchaseOrder set auditorusercode=@username,auditordate=@lm_date  where ordercode=@po";
                list.Add(new { str = sql, parm = new { username="",po = po, lm_date ="" } });
@@ -264,5 +273,43 @@
            return mes;
        }
        #endregion

        #region[采购订单关闭]
        public static ToMessage ClosedPurchaseOrder(string po, string username)
        {
            var sql = "";
            List<object> list = new List<object>();
            var dynamicParams = new DynamicParameters();
            try
            {
                //更新采购订单状态
                sql = @"update T_PurchaseOrder set status='CLOSED'  where ordercode=@po";
                list.Add(new { str = sql, parm = new { po = po} });
                bool aa = DapperHelper.DoTransaction(list);
                if (aa)
                {
                    mes.code = "200";
                    mes.count = 0;
                    mes.Message = "操作成功!";
                    mes.data = null;
                }
                else
                {
                    mes.code = "300";
                    mes.count = 0;
                    mes.Message = "操作失败!";
                    mes.data = null;
                }
            }
            catch (Exception e)
            {
                mes.code = "300";
                mes.count = 0;
                mes.Message = e.Message;
                mes.data = null;
            }
            return mes;
        }
        #endregion
    }
}