From 10b3f91902107815a16e5ff0528e3880ff100b60 Mon Sep 17 00:00:00 2001 From: zrg <z18737863051@163.com> Date: 星期二, 30 四月 2024 17:34:23 +0800 Subject: [PATCH] 1.调拨申请单 增加审核,反审核,关闭,反关闭,作废,反作废,修复编辑数据不能回显,无法编辑,保存失败功能 2.发货通知单 新增编辑 页面 初始化 主管 部门 业务员,修复多条数据 反写 销售订单 失败 3.销售订单列表 增加字段名,用于选单号 赋值表头信息 4.销售出库单 保存时增加 选着源单 发货通知单 后,查询源单是否存在 --- WebAPI/Controllers/XSGL/Xs_ReceivableBillController.cs | 30 +++++++++++++----------------- 1 files changed, 13 insertions(+), 17 deletions(-) diff --git a/WebAPI/Controllers/XSGL/Xs_ReceivableBillController.cs b/WebAPI/Controllers/XSGL/Xs_ReceivableBillController.cs index 128b977..abc342f 100644 --- a/WebAPI/Controllers/XSGL/Xs_ReceivableBillController.cs +++ b/WebAPI/Controllers/XSGL/Xs_ReceivableBillController.cs @@ -363,24 +363,20 @@ oCN.BeginTran(); - //ds = oCN.RunProcReturn("select * from h_v_Xs_ReceivableBillList_Query where hmainid=" + HInterID, "h_v_Xs_ReceivableBillList_Query"); - //foreach (DataRow row in ds.Tables[0].Rows) - //{ - // // 鑾峰彇褰撳墠琛岀殑 HSourceBillType 鍊� - // string hSourceBillType = row["HSourceBillType"].ToString(); + ds = oCN.RunProcReturn("select * from h_v_Xs_ReceivableBillList_Query where hmainid=" + HInterID, "h_v_Xs_ReceivableBillList_Query"); + string hSourceBillType = ds.Tables[0].Rows[0]["HSourceBillType"].ToString(); + if (hSourceBillType == "1401") + { + //搴旀敹鍗� 鍒犻櫎鍥炲~ 閿�鍞鍗� 鍏宠仈鏁伴噺 + oCN.RunProc("exec h_p_Xs_UpDateRelation_SeOrderToPOStockIn_Del " + HInterID); + } + else if (hSourceBillType == "1205") + { + //搴旀敹鍗� 鍒犻櫎鍥炲~ 閿�鍞嚭搴撳崟 鍏宠仈鏁伴噺 + oCN.RunProc("exec h_p_Xs_UpDateRelation_ICStockoPOStockIn_Del " + HInterID); + } - // if (hSourceBillType == "1401") - // { - // //搴旀敹鍗� 鍒犻櫎鍥炲~ 閿�鍞鍗� 鍏宠仈鏁伴噺 - // oCN.RunProc("exec h_p_Xs_UpDateRelation_SeOrderToPOStockIn_Del " + HInterID); - // } - // else if (hSourceBillType == "1205") - // { - // //搴旀敹鍗� 鍒犻櫎鍥炲~ 閿�鍞嚭搴撳崟 鍏宠仈鏁伴噺 - // oCN.RunProc("exec h_p_Xs_UpDateRelation_ICStockoPOStockIn_Del " + HInterID); - // } - //} - + oCN.RunProc("delete from Xs_ReceivableBillMain where HInterID = " + HInterID); oCN.RunProc("delete from Xs_ReceivableBillSub where HInterID= " + HInterID); -- Gitblit v1.9.1