المشاركات : 9
المواضيع 3
الإنتساب : Mar 2020
السمعة :
0
الشكر: 32
تم شكره 16 مرات في 7 مشاركات
السلام عليكم و رحمة الله و بركاته
قمت بتصميم منظومة المغسلة ZISCOM LAUNDRY
رابط التنزيل: http://www.mediafire.com/file/t5yjwmzvfq...t.zip/file
المنظومة مفتوحة المصدر يرجى الاستفادة منها لغرض التعلم
اعانكم الله
المشاركات : 223
المواضيع 90
الإنتساب : Feb 2018
السمعة :
1
الشكر: 272
تم شكره 120 مرات في 84 مشاركات
يعطيك الف عافية
بس ممكن سكربت لقاعدة البيانات
المشاركات : 9
المواضيع 3
الإنتساب : Mar 2020
السمعة :
0
الشكر: 32
تم شكره 16 مرات في 7 مشاركات
كود :
USE [master]
GO
/****** Object: Database [C:\USERS\SABRI\DOCUMENTS\ZISCOMDATA\LANDRYDATA.MDF] Script Date: 2020/11/09 21:06:16 ******/
CREATE DATABASE [C:\USERS\SABRI\DOCUMENTS\ZISCOMDATA\LANDRYDATA.MDF]
CONTAINMENT = NONE
ON PRIMARY
( NAME = N'Dtbase', FILENAME = N'C:\USERS\SABRI\DOCUMENTS\ZISCOMDATA\LANDRYDATA.MDF' , SIZE = 8192KB , MAXSIZE = UNLIMITED, FILEGROWTH = 65536KB )
LOG ON
( NAME = N'Dtbase_log', FILENAME = N'C:\USERS\SABRI\DOCUMENTS\ZISCOMDATA\landrydata_log.ldf' , SIZE = 768KB , MAXSIZE = UNLIMITED, FILEGROWTH = 10%)
GO
ALTER DATABASE [C:\USERS\SABRI\DOCUMENTS\ZISCOMDATA\LANDRYDATA.MDF] SET COMPATIBILITY_LEVEL = 130
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [C:\USERS\SABRI\DOCUMENTS\ZISCOMDATA\LANDRYDATA.MDF].[dbo].[sp_fulltext_database] @action = 'enable'
end
GO
ALTER DATABASE [C:\USERS\SABRI\DOCUMENTS\ZISCOMDATA\LANDRYDATA.MDF] SET ANSI_NULL_DEFAULT OFF
GO
ALTER DATABASE [C:\USERS\SABRI\DOCUMENTS\ZISCOMDATA\LANDRYDATA.MDF] SET ANSI_NULLS OFF
GO
ALTER DATABASE [C:\USERS\SABRI\DOCUMENTS\ZISCOMDATA\LANDRYDATA.MDF] SET ANSI_PADDING OFF
GO
ALTER DATABASE [C:\USERS\SABRI\DOCUMENTS\ZISCOMDATA\LANDRYDATA.MDF] SET ANSI_WARNINGS OFF
GO
ALTER DATABASE [C:\USERS\SABRI\DOCUMENTS\ZISCOMDATA\LANDRYDATA.MDF] SET ARITHABORT OFF
GO
ALTER DATABASE [C:\USERS\SABRI\DOCUMENTS\ZISCOMDATA\LANDRYDATA.MDF] SET AUTO_CLOSE ON
GO
ALTER DATABASE [C:\USERS\SABRI\DOCUMENTS\ZISCOMDATA\LANDRYDATA.MDF] SET AUTO_SHRINK ON
GO
ALTER DATABASE [C:\USERS\SABRI\DOCUMENTS\ZISCOMDATA\LANDRYDATA.MDF] SET AUTO_UPDATE_STATISTICS ON
GO
ALTER DATABASE [C:\USERS\SABRI\DOCUMENTS\ZISCOMDATA\LANDRYDATA.MDF] SET CURSOR_CLOSE_ON_COMMIT OFF
GO
ALTER DATABASE [C:\USERS\SABRI\DOCUMENTS\ZISCOMDATA\LANDRYDATA.MDF] SET CURSOR_DEFAULT GLOBAL
GO
ALTER DATABASE [C:\USERS\SABRI\DOCUMENTS\ZISCOMDATA\LANDRYDATA.MDF] SET CONCAT_NULL_YIELDS_NULL OFF
GO
ALTER DATABASE [C:\USERS\SABRI\DOCUMENTS\ZISCOMDATA\LANDRYDATA.MDF] SET NUMERIC_ROUNDABORT OFF
GO
ALTER DATABASE [C:\USERS\SABRI\DOCUMENTS\ZISCOMDATA\LANDRYDATA.MDF] SET QUOTED_IDENTIFIER OFF
GO
ALTER DATABASE [C:\USERS\SABRI\DOCUMENTS\ZISCOMDATA\LANDRYDATA.MDF] SET RECURSIVE_TRIGGERS OFF
GO
ALTER DATABASE [C:\USERS\SABRI\DOCUMENTS\ZISCOMDATA\LANDRYDATA.MDF] SET DISABLE_BROKER
GO
ALTER DATABASE [C:\USERS\SABRI\DOCUMENTS\ZISCOMDATA\LANDRYDATA.MDF] SET AUTO_UPDATE_STATISTICS_ASYNC OFF
GO
ALTER DATABASE [C:\USERS\SABRI\DOCUMENTS\ZISCOMDATA\LANDRYDATA.MDF] SET DATE_CORRELATION_OPTIMIZATION OFF
GO
ALTER DATABASE [C:\USERS\SABRI\DOCUMENTS\ZISCOMDATA\LANDRYDATA.MDF] SET TRUSTWORTHY OFF
GO
ALTER DATABASE [C:\USERS\SABRI\DOCUMENTS\ZISCOMDATA\LANDRYDATA.MDF] SET ALLOW_SNAPSHOT_ISOLATION OFF
GO
ALTER DATABASE [C:\USERS\SABRI\DOCUMENTS\ZISCOMDATA\LANDRYDATA.MDF] SET PARAMETERIZATION SIMPLE
GO
ALTER DATABASE [C:\USERS\SABRI\DOCUMENTS\ZISCOMDATA\LANDRYDATA.MDF] SET READ_COMMITTED_SNAPSHOT OFF
GO
ALTER DATABASE [C:\USERS\SABRI\DOCUMENTS\ZISCOMDATA\LANDRYDATA.MDF] SET HONOR_BROKER_PRIORITY OFF
GO
ALTER DATABASE [C:\USERS\SABRI\DOCUMENTS\ZISCOMDATA\LANDRYDATA.MDF] SET RECOVERY SIMPLE
GO
ALTER DATABASE [C:\USERS\SABRI\DOCUMENTS\ZISCOMDATA\LANDRYDATA.MDF] SET MULTI_USER
GO
ALTER DATABASE [C:\USERS\SABRI\DOCUMENTS\ZISCOMDATA\LANDRYDATA.MDF] SET PAGE_VERIFY CHECKSUM
GO
ALTER DATABASE [C:\USERS\SABRI\DOCUMENTS\ZISCOMDATA\LANDRYDATA.MDF] SET DB_CHAINING OFF
GO
ALTER DATABASE [C:\USERS\SABRI\DOCUMENTS\ZISCOMDATA\LANDRYDATA.MDF] SET FILESTREAM( NON_TRANSACTED_ACCESS = OFF )
GO
ALTER DATABASE [C:\USERS\SABRI\DOCUMENTS\ZISCOMDATA\LANDRYDATA.MDF] SET TARGET_RECOVERY_TIME = 60 SECONDS
GO
ALTER DATABASE [C:\USERS\SABRI\DOCUMENTS\ZISCOMDATA\LANDRYDATA.MDF] SET DELAYED_DURABILITY = DISABLED
GO
ALTER DATABASE [C:\USERS\SABRI\DOCUMENTS\ZISCOMDATA\LANDRYDATA.MDF] SET QUERY_STORE = OFF
GO
USE [C:\USERS\SABRI\DOCUMENTS\ZISCOMDATA\LANDRYDATA.MDF]
GO
ALTER DATABASE SCOPED CONFIGURATION SET LEGACY_CARDINALITY_ESTIMATION = OFF;
GO
ALTER DATABASE SCOPED CONFIGURATION SET MAXDOP = 0;
GO
ALTER DATABASE SCOPED CONFIGURATION SET PARAMETER_SNIFFING = ON;
GO
ALTER DATABASE SCOPED CONFIGURATION SET QUERY_OPTIMIZER_HOTFIXES = OFF;
GO
USE [C:\USERS\SABRI\DOCUMENTS\ZISCOMDATA\LANDRYDATA.MDF]
GO
/****** Object: Table [dbo].[Article] Script Date: 2020/11/09 21:06:17 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Article](
[id] [int] IDENTITY(1,1) NOT NULL,
[ref_article] [nvarchar](50) NOT NULL,
[nom_article_arabe] [nvarchar](50) NULL,
[nom_article_english] [nvarchar](50) NOT NULL,
[ref_unite] [nvarchar](50) NOT NULL,
[type_article] [int] NOT NULL,
CONSTRAINT [PK_Article] PRIMARY KEY CLUSTERED
(
[ref_article] 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].[clients] Script Date: 2020/11/09 21:06:17 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[clients](
[id] [int] IDENTITY(1,1) NOT NULL,
[ref_client] [nvarchar](50) NOT NULL,
[nom_client] [nvarchar](50) NULL,
[max_credit] [real] NULL,
[val] [int] NULL,
[adresse] [nvarchar](50) NULL,
CONSTRAINT [PK_clients] PRIMARY KEY CLUSTERED
(
[ref_client] 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].[factures] Script Date: 2020/11/09 21:06:17 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[factures](
[id] [int] IDENTITY(1,1) NOT NULL,
[ref_fournisseur] [nvarchar](50) NOT NULL,
[num_facture] [bigint] NULL,
[ref_client] [nvarchar](50) NOT NULL,
[ref_kaisse] [nvarchar](50) NULL,
[ref_users] [nvarchar](50) NULL,
[dte_fac] [date] NULL,
[dte_paid] [date] NULL,
[amount] [real] NULL,
[remise] [real] NULL,
[type_fac] [int] NULL,
[notes] [nvarchar](100) NULL,
[val] [bit] NOT NULL,
CONSTRAINT [PK_factures] 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].[fournisseur] Script Date: 2020/11/09 21:06:17 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[fournisseur](
[id] [int] IDENTITY(1,1) NOT NULL,
[ref_fournisseur] [nvarchar](50) NULL,
[nom_fournisseur] [nvarchar](50) NULL,
[max_credit] [real] NULL,
[val] [int] NULL,
[adresse] [nvarchar](50) NULL,
CONSTRAINT [PK_fournisseur] 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].[gestion_article] Script Date: 2020/11/09 21:06:17 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[gestion_article](
[id] [int] IDENTITY(1,1) NOT NULL,
[ref_article] [nvarchar](50) NULL,
[nom_service] [nvarchar](50) NOT NULL,
[prix] [real] NULL,
[qte] [real] NULL,
[note] [nvarchar](100) NOT NULL,
[numfacture] [nvarchar](50) NULL,
[dte] [date] NULL,
[ref_users] [nvarchar](50) NULL,
[ref_fournisseur] [nvarchar](50) NOT NULL,
[ref_client] [nvarchar](50) NOT NULL,
CONSTRAINT [PK_vente_article] 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].[kaisse] Script Date: 2020/11/09 21:06:17 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[kaisse](
[id] [int] IDENTITY(1,1) NOT NULL,
[ref_kaisse] [nvarchar](50) NULL,
[nom_kaisse] [nvarchar](50) NULL,
CONSTRAINT [PK_kaisse] 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].[prix_article] Script Date: 2020/11/09 21:06:17 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[prix_article](
[id] [int] IDENTITY(1,1) NOT NULL,
[ref_article] [nvarchar](50) NOT NULL,
[ref_service] [nvarchar](50) NOT NULL,
[prix] [real] NULL,
[ref_unite] [nvarchar](50) NOT NULL,
CONSTRAINT [PK_prix_article] 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].[Services] Script Date: 2020/11/09 21:06:17 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Services](
[id] [int] IDENTITY(1,1) NOT NULL,
[ref_service] [nvarchar](50) NULL,
[nom_service] [nvarchar](50) NULL,
CONSTRAINT [PK_Services] 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].[unite] Script Date: 2020/11/09 21:06:17 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[unite](
[id] [int] IDENTITY(1,1) NOT NULL,
[ref_unite] [nvarchar](50) NULL,
[nom_unite] [nvarchar](50) NULL,
CONSTRAINT [PK_unite] 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].[users] Script Date: 2020/11/09 21:06:17 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[users](
[id] [int] IDENTITY(1,1) NOT NULL,
[ref_users] [nvarchar](50) NOT NULL,
[nom_users] [nvarchar](50) NULL,
[salaire] [real] NULL,
[dte_travail] [date] NULL,
[val] [int] NULL,
CONSTRAINT [PK_users] PRIMARY KEY CLUSTERED
(
[ref_users] 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].[validite_users] Script Date: 2020/11/09 21:06:17 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[validite_users](
[id] [int] IDENTITY(1,1) NOT NULL,
[name_btn] [nvarchar](50) NULL,
[id_users] [nvarchar](50) NULL,
[val] [bit] NULL,
CONSTRAINT [PK_validite_users] 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
ALTER TABLE [dbo].[Article] ADD CONSTRAINT [DF_Article_nom_article_english] DEFAULT ('') FOR [nom_article_english]
GO
ALTER TABLE [dbo].[Article] ADD CONSTRAINT [DF_Article_ref_unite] DEFAULT ('') FOR [ref_unite]
GO
ALTER TABLE [dbo].[Article] ADD CONSTRAINT [DF_Article_type_article] DEFAULT ((0)) FOR [type_article]
GO
ALTER TABLE [dbo].[factures] ADD CONSTRAINT [DF_factures_ref_fournisseur] DEFAULT ('') FOR [ref_fournisseur]
GO
ALTER TABLE [dbo].[factures] ADD CONSTRAINT [DF_factures_ref_client] DEFAULT ('') FOR [ref_client]
GO
ALTER TABLE [dbo].[factures] ADD CONSTRAINT [DF_factures_val] DEFAULT ((0)) FOR [val]
GO
ALTER TABLE [dbo].[gestion_article] ADD CONSTRAINT [DF_gestion_article_nom_service] DEFAULT ('') FOR [nom_service]
GO
ALTER TABLE [dbo].[gestion_article] ADD CONSTRAINT [DF_gestion_article_note] DEFAULT ('') FOR [note]
GO
ALTER TABLE [dbo].[gestion_article] ADD CONSTRAINT [DF_gestion_article_ref_fournisseur] DEFAULT ('') FOR [ref_fournisseur]
GO
ALTER TABLE [dbo].[gestion_article] ADD CONSTRAINT [DF_gestion_article_ref_client] DEFAULT ('') FOR [ref_client]
GO
ALTER TABLE [dbo].[prix_article] ADD CONSTRAINT [DF_prix_article_ref_service] DEFAULT ('') FOR [ref_service]
GO
ALTER TABLE [dbo].[prix_article] ADD CONSTRAINT [DF_prix_article_ref_unite] DEFAULT ('') FOR [ref_unite]
GO
USE [master]
GO
ALTER DATABASE [C:\USERS\SABRI\DOCUMENTS\ZISCOMDATA\LANDRYDATA.MDF] SET READ_WRITE
GO
|