Medicine issue module website

Question

Medicine issue module website

Baiju EP 121

In my Asp.net+VB+SQL database website. I have a table named Clinic_Medicine

USE [FTH_BLR]
GO

/****** Object:  Table [dbo].[Clinic_Medicine]    Script Date: 3/2/2023 11:18:46 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[Clinic_Medicine](
	[Med_ID] [int] IDENTITY(1,1) NOT NULL,
	[Medicine] [varchar](max) NULL,
	[Type] [varchar](50) NULL,
	[BatchNo] [varchar](50) NULL,
	[Exp_dt] [datetime] NULL,
	[Qty] [varchar](50) NULL,
	[Purchase_Date] [datetime] NULL,
	[Vendor] [varchar](max) NULL,
	[Remarks] [varchar](max) NULL,
	[Operator] [varchar](50) NULL,
	[Eff_Date] [datetime] NULL,
 CONSTRAINT [PK_Clinic_Medicine] PRIMARY KEY CLUSTERED 
(
	[Med_ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

Baiju EP 121 Reputation points

2023-03-02T06:05:44.56+00:00

i have a code to add new medicines into DB as under

sql_ins = "Insert into Clinic_Medicine (Medicine, Type, BatchNo, Exp_dt, Qty,Purchase_Date,Vendor,Remarks,Operator,Eff_Date) values (@a,@aa,@b,@c,@d,@e,@f,@g,@h,@i)"

this code stores the data in my SQL DB
Baiju EP 121 Reputation points

2023-03-03T02:24:31.28+00:00

I have code to add medicine into my DB and its works fine for me. Data is stored correctly in DB

now i have multiple rows for same medicine in DB

but while issuing the data . issue is happening from oldest stock and even though teh stock is 0 its still issuing from that row and it gets in to minus
XuDong Peng-MSFT 4,746 Reputation points Microsoft Vendor

2023-03-03T02:47:34.68+00:00

Hi @Baiju EP,

According to your description, I understand that this problem is the problem of warehouse inbound and outbound. Do you mean that when the stock is 0, it can still achieve the outbound operation, so that the actual data is wrong? If this is the case, I think you have to check the relevant logic code and check whether the current stock allows the outbound operation before the outbound. You can also post some relevant code so that we can better locate the problem.

But if I misunderstand anything, please let me know.

Baiju EP 121 Reputation points

2023-03-02T06:05:44.56+00:00

i have a code to add new medicines into DB as under

sql_ins = "Insert into Clinic_Medicine (Medicine, Type, BatchNo, Exp_dt, Qty,Purchase_Date,Vendor,Remarks,Operator,Eff_Date) values (@a,@aa,@b,@c,@d,@e,@f,@g,@h,@i)"

this code stores the data in my SQL DB
Baiju EP 121 Reputation points

2023-03-03T02:24:31.28+00:00

I have code to add medicine into my DB and its works fine for me. Data is stored correctly in DB

now i have multiple rows for same medicine in DB

but while issuing the data . issue is happening from oldest stock and even though teh stock is 0 its still issuing from that row and it gets in to minus
XuDong Peng-MSFT 4,746 Reputation points Microsoft Vendor

2023-03-03T02:47:34.68+00:00

Hi @Baiju EP,

According to your description, I understand that this problem is the problem of warehouse inbound and outbound. Do you mean that when the stock is 0, it can still achieve the outbound operation, so that the actual data is wrong? If this is the case, I think you have to check the relevant logic code and check whether the current stock allows the outbound operation before the outbound. You can also post some relevant code so that we can better locate the problem.

But if I misunderstand anything, please let me know.

Medicine issue module website

Activity