修改提醒

最新推荐文章于 2022-03-04 11:14:29 发布

转载最新推荐文章于 2022-03-04 11:14:29 发布 · 99 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/dwuge/p/5291916.html

本文详细阐述了如何使用特定存储过程删除供应商信息，并通过数据库操作确保数据一致性。

ALTER PROCEDURE [dbo].[R_Supplier_DeleteSupplierName]
@PID Nvarchar(400)
AS
BEGIN
DECLARE @SupplierName Nvarchar(400),@SupplierID Nvarchar(400)
SELECT @SupplierName=SupplierName FROM V_Supplier_Warehouse_ShipVIA WHERE ID=@PID
SELECT @SupplierID=ID FROM Supplier WHERE SupplierName=@SupplierName

declare @ProductID int,@OrderID int
select @ProductID=ID FROM Supplier_Product where SupplierID = @SupplierID
select @OrderID=ID from Supplier_Order where SupplierID = @SupplierID
if(@ProductID>0 or @OrderID>0)
begin
select 'The Supplier cannot be deleted'
end
else
begin
select 'Delete the success'
DELETE FROM Supplier_Warehouse WHERE SupplierID=@SupplierID
DELETE FROM Supplier_ShipVIA WHERE SupplierID=@SupplierID
DELETE FROM Supplier WHERE ID=@SupplierID
end
END

List<IDataParameter> pList = new List<IDataParameter>();
pList.Add(DataProvider.Instance().NewParameter("@PID", DbType.String, 400, id));
DataSet ds = DataProvider.Instance().ExecProcedure("R_Supplier_DeleteSupplierName", pList);
GridPanel1.Reload();
string Mes = ds.Tables[0].Rows[0][0].ToString();
X.Msg.Show(new MessageBoxConfig
{
Title = "",
Message = Mes,
Icon = Ext.Net.MessageBox.Icon.INFO,
Buttons = Ext.Net.MessageBox.Button.OK
});

转载于:https://www.cnblogs.com/dwuge/p/5291916.html