تقييم الموضوع :
  • 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
الرد }}}
تم الشكر بواسطة:


المواضيع المحتمل أن تكون متشابهة .
الموضوع : الكاتب الردود : المشاهدات : آخر رد
  برنامج البحث عن لقطة داخل صورة أخرى Taha Okla 4 1,233 أمس, 04:23 PM
آخر رد: عبدالكريم برشدان
  برنامج صانع الاكواد الاصدار المجاني الجديد aljzazy 27 20,083 14-01-24, 12:39 PM
آخر رد: mahmoued2022
Shocked برنامج مواقيت الصلاة ( الاذان ) alsaher1 5 2,531 25-11-23, 02:57 PM
آخر رد: alsaher1
Star [مشروع] برنامج مبيعات مفتوح المصدر 2018 mohammedvego 174 143,573 18-11-23, 03:01 AM
آخر رد: Darweesh
Thumbs Up [VB.NET] برنامج محاسبي مجاني ( مبيعات - مشتريات - مخزون - حسابات ) مفتوح المصدر توب سوفت 3 7,497 06-11-23, 01:36 AM
آخر رد: Ramzigh
  [مشروع] سورس كود برنامج مبيعات لسه مبتدئ 42 34,751 07-10-23, 07:25 PM
آخر رد: حورس2000
  برنامج لادارة الدروس الخصوصية VB.NET2013& Access moaath.khalaf 16 15,790 19-08-23, 12:22 AM
آخر رد: Ramadan alking
  برنامج بنك الأكواد esawy1 4 1,368 28-07-23, 11:53 AM
آخر رد: karmina2012
Music [VB.NET] سورس كود برنامج إذاعي متطور musalem 0 624 25-06-23, 02:06 AM
آخر رد: musalem
Brick [مشروع] سورس كود برنامج إدارة المخزن MStore بلغة VB.NET musalem 1 1,378 17-06-23, 10:03 AM
آخر رد: atefkhalf2004

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


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