销售退货单和采购退料单 查询

杨乐

2021-12-28 04ce10a6a6a75da1c2498af21f8538719cb4c33c

 WebAPI/Controllers/XSGL/Xs_SeOutStockBackBillController.cs

@@ -19,7 +19,7 @@
        SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
        DataSet ds;


        #region 返回退货通知单列表
        /// <summary>
        /// 返回退货通知单列表
        ///参数：string sql。
@@ -67,9 +67,41 @@
                return objJsonResult;
            }
        }
        #endregion
        #region 删除功能
        /// <summary>
        ///删除功能
        /// </summary>
        /// <returns></returns>
        [Route("Xs_SeOutStockBackBill/DeltetSeOutStockBackBill")]
        [HttpGet]
        public object DeltetSeOutStockBackBill(string HInterID)
        {
            try
            {
                oCN.BeginTran();
                oCN.RunProc("Delete From Xs_SeOutStockBackBillMain where HInterID = " + HInterID);
                oCN.RunProc("Delete From Xs_SeOutStockBackBillSub where HInterID = " + HInterID);
                oCN.Commit();
                objJsonResult.code = "1";
                objJsonResult.count = 1;
                objJsonResult.Message = "删除成功！";
                objJsonResult.data = null;
                return objJsonResult;
            }
            catch (Exception e)
            {
                oCN.RollBack();
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "Exception！" + e.ToString();
                objJsonResult.data = null;
                return objJsonResult;
            }
        }
        #endregion



        //
    }
}