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

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 = "查询成功!";
@@ -97,5 +97,160 @@
            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)
            {
                mes.code = "300";
                mes.count = 0;
                mes.Message = e.Message;
                mes.data = null;
            }
            return mes;
        }
        #endregion

        #region[采购订单删除]
        public static ToMessage DeletePurchaseOrder(string po)
        {
            var sql = "";
            List<object> list = new List<object>();
            var dynamicParams = new DynamicParameters();
            try
            {
                //删除采购订单主表
                sql = @"delete T_PurchaseOrder  where ordercode=@po";
                list.Add(new { str = sql, parm = new { po = po } });

                //删除采购订单子表
                sql = @"delete T_PurchaseOrder_sub  where purchaseorder_code=@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

        #region[采购订单审核]
        public static ToMessage VerifyPurchaseOrder(string po,string username)
        {
            var sql = "";
            List<object> list = new List<object>();
            var dynamicParams = new DynamicParameters();
            try
            {
                //更新采购订单主表审核人、审核时间
                sql = @"update T_PurchaseOrder set auditorusercode=@username,auditordate=@lm_date  where ordercode=@po";
                list.Add(new { str = sql, parm = new { username= username,po = po, lm_date = DateTime.Now.ToString() } });

                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

        #region[采购订单反审核]
        public static ToMessage ReversVerifyPurchaseOrder(string po, string username)
        {
            var sql = "";
            List<object> list = new List<object>();
            var dynamicParams = new DynamicParameters();
            try
            {
                //判断是否生成采购到货单

                //更新采购订单主表审核人、审核时间
                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 ="" } });

                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
    }
}