السلام عليكم و رحمة اله و بركاته

 

إخواني لو تتكرمون أنا لم أفهم كيف أحدث كميات مختلف الأصناف في المخزن في حالة البيع (قطعة و جملة) أو الشراء (قطعة و جملة) و جزاكم الله خيراً

 

إليكم بعض الجداول :  

USE [sTOREINVENTORY]
GO

/****** Object:  Table [dbo].[Categories]    Script Date: 09/08/2016 11:44:02 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[Categories](
	[CatID] [int] NOT NULL,
	[CatName] [nvarchar](50) NULL,
	[Obs] [nvarchar](max) NULL,
 CONSTRAINT [PK_Categories] PRIMARY KEY CLUSTERED 
(
	[CatID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  

= ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO


/****** Object:  Table [dbo].[Products]    Script Date: 09/08/2016 11:39:08 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[Products](
	[ProdID] [int] NOT NULL,
	[barcode] [nvarchar](50) NOT NULL,
	[ProdNom] [nvarchar](50) NOT NULL,
	[ProdDesc] [nvarchar](max) NULL,
	[CatID] [int] NOT NULL,
	[unitID] [int] NULL,
	[initialStock] [int] NULL,
	[stockAlert] [int] NULL,
	[unitPriceSale] [float] NULL,
	[unitPricePurchase] [float] NULL,
	[WholeSalePrice] [float] NULL,
 CONSTRAINT [PK_Products] PRIMARY KEY CLUSTERED 
(
	[ProdID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  

= ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO



/****** Object:  Table [dbo].[Prod_Units]    Script Date: 09/08/2016 11:42:18 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[Prod_Units](
	[unitID] [int] NOT NULL,
	[unitName] [nvarchar](50) NULL,
	[ProdID] [nvarchar](50) NULL,
	[unitSize] [int] NULL,
 CONSTRAINT [PK_Prod_Units] PRIMARY KEY CLUSTERED 
(
	[unitID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  

= ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO



/****** Object:  Table [dbo].[stocks]    Script Date: 09/08/2016 11:43:24 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[stocks](
	[stockID] [int] NOT NULL,
	[ProdID] [int] NULL,
	[storeID] [int] NULL,
	[QtyInStock] [int] NULL,
 CONSTRAINT [PK_Stocks] PRIMARY KEY CLUSTERED 
(
	[stockID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  

= ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO



/****** Object:  Table [dbo].[stores]    Script Date: 09/08/2016 11:43:46 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[stores](
	[storeID] [int] NOT NULL,
	[storeName] [nvarchar](50) NULL,
 CONSTRAINT [PK_Shops] PRIMARY KEY CLUSTERED 
(
	[storeID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  

= ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO



/****** Object:  Table [dbo].[Ventes]    Script Date: 09/08/2016 11:45:36 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[Orders](
	[OrdersID] [int] NOT NULL,
	[OrdersDate] [date] NULL,
	[ClientID] [int] NULL,
	[userID] [nvarchar](50) NULL,
 CONSTRAINT [PK_Orders] PRIMARY KEY CLUSTERED 
(
	[OrdersID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  

= ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO



/****** Object:  Table [dbo].[DetailVentes]    Script Date: 09/08/2016 11:46:58 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[OrderDetails](
	[OrderDetailsID] [int] NOT NULL,
	[OrderID] [int] NULL,
	[FactID] [int] NULL,
	[ProdID] [nvarchar](50) NULL,
	[unitPrice] [float] NULL,
	[QtyOrdered] [int] NULL,
	[Discount] [float] NULL,
	[Amount] [float] NULL,
	[Total] [float] NULL,
 CONSTRAINT [PK_OrderDetails] PRIMARY KEY CLUSTERED 
(
	[OrderDetailsID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  

= ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

لا تتم الطريقة هكذا ..

يجب عليك شرح مشكلتك بالتفصيل مزوداً بالأكواد التي تحتاج معاجلتها

فمن أجل  تحديث كميات الأصناف في المخزن

يفترض أن يكون لديك جدول الكميات أو الحركة يحتوي علي (رقم الصنف ، كمية مورده ، كمية منصرف ، تاريخ الحركة)

 

فمثلاً

عند ايداع كمية 12 من الصنف رقم 112371 الى المخزن نرسل البيانات التالية لجدول الحركة ( 112371 ، 21 , 0 , 12/05/2015)

عند صرف كمية 8 من الصنف رقم 112371 من المخزن نرسل البيانات التالية لجدول الحركة ( 112371 ، 0 , 8 , 12/07/2015)

 

* لاحظ اضافتنا رقم (0) للكمية المنصرفة عند الايداع ورقم (0) للكمية الموردة عند الصرف 

 

وبذلك يكون الرصيد الفعلي من الصنف 112371 هو أجمالي المرود - إجمال يالمنصرف = (12-8) = 4 

 

 

بإمكانك في أي وقت شرح الطريقة التي أعتمدت عليها وسيتم إفادتك إن شاء الله تعالى ..

 

بالتوفيق

السلام عليكم و رحمة الله و بركاته أخي بارك الله فيك على إجابتك الممتازة و ‘نشاء الله سأجربها شكراً جزيلاً