Wednesday, May 13, 2015

VB.NET inventory management system Form designing models with report page


Form Designing Models with Report Page                        

  
  The various services incorporated in this project are employee with salary details, expenses, purchase details, sales details, report generation and administration. The stock details handle the changes of the cost add new, details about the stock available in each company, products and its item. It also has the facility to report the damaged product. The Stock deals with billing and service to the customer such as returning the products and damaged items. The employee deals with the employee personal details and salary details   . The administrator is control the overall system has the power to place the order for stock. It also has the privilege like adding a new company, new item, deleting a company and its item.                 

 Loading Form

  

Login Form



















Main Form(MDI)


 


































Report Page Models


















Database MS SQL 2005


USE [soft]

GO
/****** Object:  Table [dbo].[Do_s2_rop112]    Script Date: 03/22/2012 15:22:29 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Do_s2_rop112](
[SR-No] [int] NULL,
[Pro_ID] [nchar](15) NOT NULL,
[particular] [varchar](250) NULL,
[cost] [nchar](10) NULL,
[Stock] [nchar](10) NULL,
 CONSTRAINT [PK_Do_s2_rop112] PRIMARY KEY CLUSTERED 
(
[Pro_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]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[padma_textile]    Script Date: 03/22/2012 15:22:47 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[padma_textile](
[SR-No] [int] NULL,
[Pro_ID] [varchar](150) NOT NULL,
[particular] [varchar](250) NULL,
[cost] [nchar](10) NULL,
[Stock] [nchar](10) NULL,
 CONSTRAINT [PK_padma_textile_1] PRIMARY KEY CLUSTERED 
(
[Pro_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]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Company_Detsils]    Script Date: 03/22/2012 15:22:23 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Company_Detsils](
[Com_ID] [nchar](15) NOT NULL,
[Com_name] [varchar](50) NULL,
[cont_name] [varchar](150) NULL,
[Billing_Addr] [varchar](max) NULL,
[city] [varchar](150) NULL,
[state] [varchar](150) NULL,
[country] [varchar](150) NULL,
[Zip_code] [int] NULL,
[email] [varchar](150) NULL,
[Url] [varchar](150) NULL,
[telp_no] [nchar](15) NULL,
[mobile] [nchar](15) NULL,
[fax] [nchar](15) NULL,
[App_tax] [nchar](10) NULL,
[descr] [varchar](max) NULL,
 CONSTRAINT [PK_Company_Detsils] PRIMARY KEY CLUSTERED 
(
[Com_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]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Suplayer_details]    Script Date: 03/22/2012 15:23:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Suplayer_details](
[Sup_ID] [varchar](50) NOT NULL,
[Com_name] [varchar](100) NULL,
[con_name] [varchar](150) NULL,
[Sup_address] [varchar](max) NULL,
[city] [varchar](150) NULL,
[state] [varchar](150) NULL,
[country] [varchar](150) NULL,
[zip_code] [int] NULL,
[Email] [varchar](150) NULL,
[URL] [varchar](250) NULL,
[Telp_No] [nchar](20) NULL,
[Mobile_no] [nchar](20) NULL,
[Fax] [nchar](20) NULL,
 CONSTRAINT [PK_Suplayer_details] PRIMARY KEY CLUSTERED 
(
[Sup_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]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Damage_Items]    Script Date: 03/22/2012 15:22:27 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Damage_Items](
[No] [nchar](15) NOT NULL,
[Sup_ID] [nvarchar](50) NOT NULL,
[Date] [varchar](150) NULL,
[category] [nchar](15) NULL,
[Cmp_name] [varchar](150) NULL,
[Cont_name] [varchar](100) NULL,
[Mobile_no] [nchar](15) NULL,
[Pro_No] [nchar](20) NULL,
[Pro_name] [varchar](150) NULL,
[cost] [nchar](15) NULL,
[No_damages] [nchar](10) NULL,
[Total_amount] [nchar](10) NULL,
 CONSTRAINT [PK_Damage_Items_1] PRIMARY KEY CLUSTERED 
(
[No] 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
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Employee_details]    Script Date: 03/22/2012 15:22:33 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Employee_details](
[Emp_id] [varchar](50) NOT NULL,
[Emp_Name] [varchar](150) NULL,
[Father_name] [varchar](150) NULL,
[desig] [varchar](100) NULL,
[department] [varchar](150) NULL,
[date_bir] [varchar](50) NULL,
[experi] [nchar](10) NULL,
[sex] [nchar](10) NULL,
[Basic_pay] [varchar](50) NULL,
[Address] [varchar](500) NULL,
[city] [varchar](150) NULL,
[state] [varchar](150) NULL,
[country] [varchar](150) NULL,
[zip_code] [nchar](15) NULL,
[Email] [varchar](150) NULL,
[tel_no] [nchar](15) NULL,
[mobile] [nchar](15) NULL,
 CONSTRAINT [PK_Employee_details] PRIMARY KEY CLUSTERED 
(
[Emp_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]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[expensses_details]    Script Date: 03/22/2012 15:22:36 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[expensses_details](
[Expe_code] [nchar](15) NOT NULL,
[Report_date] [varchar](50) NULL,
[Bs_purpose] [varchar](250) NULL,
[Emp_id] [nchar](15) NULL,
[emp_name] [varchar](150) NULL,
[Mobile] [nchar](15) NULL,
[date] [varchar](50) NULL,
[category] [varchar](50) NULL,
[descri] [varchar](50) NULL,
[Amount] [nchar](10) NULL,
 CONSTRAINT [PK_ecpensses_details] PRIMARY KEY CLUSTERED 
(
[Expe_code] 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
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[purchase_details]    Script Date: 03/22/2012 15:22:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[purchase_details](
[pur_no] [nchar](15) NOT NULL,
[pur_date] [varchar](150) NULL,
[Suplier_id] [nchar](15) NULL,
[Com_name] [varchar](150) NULL,
[Mobile] [nchar](15) NULL,
[Pro_Id] [nchar](15) NULL,
[Pro_name] [varchar](150) NULL,
[cost] [nchar](15) NULL,
[QTY] [nchar](15) NULL,
[Total_amount] [nchar](20) NULL,
 CONSTRAINT [PK_purchase_details] PRIMARY KEY CLUSTERED 
(
[pur_no] 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
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Shipping_details]    Script Date: 03/22/2012 15:22:57 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Shipping_details](
[Ship_Id] [nchar](15) NOT NULL,
[Invoice_id] [nchar](15) NULL,
[date] [datetime] NULL,
[Com_Id] [nchar](15) NULL,
[Com_name] [varchar](150) NULL,
[To_Com] [varchar](max) NULL,
[working_day] [nchar](30) NULL,
[Shi_method] [varchar](50) NULL,
[Pro_Id] [nchar](15) NULL,
[Pro_name] [varchar](250) NULL,
[qty] [nchar](10) NULL,
[Cost] [float] NULL,
[Amount] [float] NULL,
 CONSTRAINT [PK_Shipping_details] PRIMARY KEY CLUSTERED 
(
[Ship_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]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Order_DO2S]    Script Date: 03/22/2012 15:22:42 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Order_DO2S](
[Invoice_og] [nchar](15) NOT NULL,
[date_to] [datetime] NULL,
[Invoice_no] [varchar](50) NULL,
[com_ID] [nchar](15) NULL,
[com_name] [varchar](150) NULL,
[Pro_ID] [varchar](150) NULL,
[proname] [nchar](100) NULL,
[Qty] [int] NULL,
[Rate] [int] NULL,
[Amount] [int] NULL,
 CONSTRAINT [PK_Order_DO2S] PRIMARY KEY CLUSTERED 
(
[Invoice_og] 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
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Purchase_Return]    Script Date: 03/22/2012 15:22:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Purchase_Return](
[Index_no] [nchar](15) NOT NULL,
[Purchse_no] [nchar](20) NULL,
[Purchse_date] [datetime] NULL,
[Issued_date] [datetime] NULL,
[Category] [nchar](20) NULL,
[Sup_ID] [nchar](15) NULL,
[Cmp_name] [varchar](150) NULL,
[Pro_ID] [nchar](15) NULL,
[Pro_name] [varchar](150) NULL,
[cost] [nchar](15) NULL,
[No_damages] [nchar](10) NULL,
[Total_amount] [nchar](15) NULL,
 CONSTRAINT [PK_Purchase_Return] PRIMARY KEY CLUSTERED 
(
[Index_no] 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
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[order_padma]    Script Date: 03/22/2012 15:22:45 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[order_padma](
[invoice_og] [nchar](10) NOT NULL,
[invoice_no] [varchar](50) NULL,
[data_to] [varchar](150) NULL,
[com_ID] [nchar](15) NULL,
[com_name] [varchar](150) NULL,
[Pro_ID] [varchar](150) NULL,
[proname] [nchar](100) NULL,
[Qty] [int] NULL,
[Rate] [int] NULL,
[Amount] [int] NULL,
 CONSTRAINT [PK_order_padma] PRIMARY KEY CLUSTERED 
(
[invoice_og] 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
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[ns1]    Script Date: 03/22/2012 15:22:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ns1](
[nasme] [nchar](10) NULL,
[id] [nchar](10) NOT NULL,
[add] [nchar](10) NULL,
 CONSTRAINT [PK_ns1] PRIMARY KEY CLUSTERED 
(
[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]
GO
/****** Object:  Table [dbo].[ns2]    Script Date: 03/22/2012 15:22:39 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ns2](
[Id] [nchar](10) NOT NULL,
[name] [nchar](10) NULL,
[phone] [nchar](10) NULL,
[bb] [image] NULL,
 CONSTRAINT [PK_ns2] PRIMARY KEY CLUSTERED 
(
[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
/****** Object:  ForeignKey [FK_ns2_ns2]    Script Date: 03/22/2012 15:22:39 ******/
ALTER TABLE [dbo].[ns2]  WITH CHECK ADD  CONSTRAINT [FK_ns2_ns2] FOREIGN KEY([name])
REFERENCES [dbo].[ns1] ([id])
GO
ALTER TABLE [dbo].[ns2] CHECK CONSTRAINT [FK_ns2_ns2]
GO

Posted by at No comments:
Subscribe to: Posts (Atom)