تقييم الموضوع :
  • 0 أصوات - بمعدل 0
  • 1
  • 2
  • 3
  • 4
  • 5
برنامج المغسلة
#1
السلام عليكم و رحمة الله و بركاته
قمت بتصميم منظومة المغسلة ZISCOM LAUNDRY 
رابط التنزيل: http://www.mediafire.com/file/t5yjwmzvfq...t.zip/file
المنظومة مفتوحة المصدر يرجى الاستفادة منها لغرض التعلم 
اعانكم الله
الرد
#2
يعطيك الف عافية 
بس ممكن سكربت لقاعدة البيانات
الرد
#3
كود :
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
الرد
تم الشكر بواسطة:


المواضيع المحتمل أن تكون متشابهة .
الموضوع : الكاتب الردود : المشاهدات : آخر رد
Star [مشروع] برنامج مبيعات مفتوح المصدر 2018 mohammedvego 166 96,765 27-04-21, 03:54 PM
آخر رد: alfaiz678
  ودعا للاختراق برنامج حجب بورتات التنصت dasktop 0 96 25-04-21, 07:39 PM
آخر رد: dasktop
  برنامج Cloud protection كشف الاتصالات وتجسس dasktop 1 140 25-04-21, 07:31 PM
آخر رد: dasktop
  برنامج صانع الاكواد الاصدار المجاني الجديد aljzazy 17 5,423 13-04-21, 09:11 AM
آخر رد: sdl00321
Lightbulb سورس كود برنامج صانع الاكواد asemshahen5 55 26,516 02-04-21, 04:30 AM
آخر رد: ibrahematia
Thumbs Up سورس كود برنامج مبيعات ومخازن نورالدين32 4 3,635 18-03-21, 02:54 AM
آخر رد: rashwanic
  السلام عليكم برنامج المشاهدة المجانية 2021 MKsabyTV لمشاهدة القنوات الرياضية والافلام elmoder22 0 240 10-03-21, 05:31 PM
آخر رد: elmoder22
  طلب تجريب برنامج مبيعات nouribenyahia 3 534 05-03-21, 09:08 PM
آخر رد: nouribenyahia
  [مثال] برنامج لحرق مختلف البيانات على قرص BM Data CD Burner asmarsou 0 235 24-02-21, 12:33 PM
آخر رد: asmarsou
  [مشروع] [ليس جديد ] برنامج بحث عن ملفات محددة في مجلدات عمومية معرفة سعود 0 375 01-02-21, 09:22 PM
آخر رد: سعود

التنقل السريع :


يقوم بقرائة الموضوع: بالاضافة الى ( 1 ) ضيف كريم