快速,持续,稳定,傻瓜式
支持Mysql,Sqlserver数据同步

进销存数据库设计ForMysQL

请联系QQ:1793040 索取软件

CREATE TABLE user( User_Id
varchar(6), User_Pwd varchar(8)
NULL, Again_Pwd varchar(8)
NULL, Bel_Group varchar(3)
NULL, Div_Type varchar(1) NULL,
User_Auth varchar(1) NULL, Auth_Type varchar(1)
NULL, User_Status varchar(1)
NULL, Create_User varchar(6)
NULL, Create_Date varchar(7)
NULL, Create_Time varchar(6)
NULL, Appr_User varchar(6)
NULL, Appr_Date varchar(7)
NULL, Appr_Time varchar(6)
NULL, Pwd_Date varchar(7) NULL,
Err_Count float NULL, Use_eJCIC varchar(1)
NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE Supplier (
Supplier_ID
int
AUTO_INCREMENT PRIMARY
KEY NOT NULL,

Name
varchar(250)
NOT NULL,
Address
varchar(250)
NOT NULL,
Phone
varchar(25)
NULL,

Fax
varchar(25)
NULL,

PostalCode
varchar(10)
NULL,
ConstactPerson
varchar(20)
NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE Customer
(
Customer_ID
int
AUTO_INCREMENT PRIMARY
KEY
NOT NULL,
Name
varchar(250)
NOT NULL,
Address
varchar(250)
NOT NULL,
Phone
varchar(25)
NULL,

Fax
varchar(25)
NULL,

PostalCode
varchar(10)
NULL,
ConstactPerson
varchar(20)
NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE
Dept
(
Dept_ID
int AUTO_INCREMENT PRIMARY
KEY
NOT NULL,
Name
varchar(30)
NOT NULL,
Remark
varchar(250)
NOT NULL ) ENGINE=InnoDB DEFAULT
CHARSET=utf8;

CREATE TABLE Dept_Supplier (
Dept_ID
int
NOT NULL,
Supplier_ID
int
NOT NULL )
ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE Dept_Customer (
Dept_ID
int
NOT NULL,
Customer_ID
int
NOT NULL ) ENGINE=InnoDB
DEFAULT CHARSET=utf8;

CREATE TABLE StoreHouse
(
StoreHouse_ID
int AUTO_INCREMENT PRIMARY
KEY
NOT NULL,
Address
varchar(250)
NOT NULL,
Phone
varchar(25)
NULL,

Employee_ID
INT
NOT NULL,
CreateDate
datetime
NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE ProductClass
( ProductClass_ID
int
AUTO_INCREMENT PRIMARY
KEY
NOT NULL,
Name
varchar(30)
NOT NULL,
Employee_ID
INT
NOT NULL,
CreateDate
datetime
NULL,

Remark
varchar(250)
NULL ) ENGINE=InnoDB DEFAULT
CHARSET=utf8;

CREATE TABLE ProductList (
ProductClass_ID
INT
NOT NULL,
ProductList_ID int
AUTO_INCREMENT PRIMARY
KEY
NOT NULL,
Name
varchar(30)
NOT NULL,
Employee_ID
INT
NOT NULL,
CreateDate
datetime
NULL,

Remark
varchar(250)
NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE ProductSpec (
ProductSpec_ID INT
AUTO_INCREMENT PRIMARY
KEY
NOT NULL,
Name
varchar(30)
NOT NULL,
Employee_ID
INT
NOT NULL,
CreateDate
datetime
NULL,

Remark
varchar(250)
NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE ProductUnit (
ProductUnit_ID INT
AUTO_INCREMENT PRIMARY
KEY
NOT NULL,
Name
varchar(30)
NOT NULL,
Employee_ID
INT
NOT NULL,
CreateDate
datetime
NULL,

Remark
varchar(250)
NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE
Product
(
ProductList_ID
int
NOT NULL,
Product_ID
INT AUTO_INCREMENT PRIMARY
KEY
NOT NULL,
Name
varchar(30)
NOT NULL,
ProductSpec_ID
INT
NOT NULL,
ProductUnit_ID
INT
NOT NULL,
Price
DECIMAL(12,4)
NULL,

Employee_ID
INT
NOT NULL,
CreateDate
datetime
NULL,

Remark
varchar(250)
NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE Product_Supplier
(
Product_ID
INT
NOT NULL,
Supplier_ID
INT
NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE Employee
(
Employee_ID
INT AUTO_INCREMENT PRIMARY
KEY
NOT NULL,
Dept_ID
INT
NOT NULL,
Name
varchar(30)
NOT NULL,
Duty
varchar(20)
NOT NULL,
Gender
varchar(6)
NOT NULL,
BirthDate
datetime
NOT NULL,
HireDate
datetime
NULL,

MatureDate
datetime
NULL,

IdentityCard
varchar(20)
NULL,

Address
varchar(250)
NULL,

Phone
varchar(25)
NULL,

Email
varchar(30)
NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE
BuyOrder
(
BuyOrder_ID
INT AUTO_INCREMENT PRIMARY
KEY
NOT NULL,
WriteDate
datetime
NOT NULL,
InsureDate
datetime
NOT NULL,
EndDate
datetime
NOT NULL,
Dept_ID
INT
NOT NULL,
Supplier_ID
INT
NOT NULL,
Employee_ID
INT
NOT NULL ) ENGINE=InnoDB
DEFAULT CHARSET=utf8;

CREATE TABLE BuyOrder_Detail
(
BuyOrder_ID
INT
NOT NULL,
Product_ID
INT
NOT NULL,
Quantity
float
NOT NULL,
Price
DECIMAL(12,4)
NOT NULL )
ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE
EnterStock
(
EnterStock_ID
INT AUTO_INCREMENT PRIMARY
KEY
NOT NULL,
EnterDate
datetime
NOT NULL,
Dept_ID
INT
NOT NULL,
StoreHouse_ID
INT
NOT NULL,
Employee_ID
INT
NOT NULL )
ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE EnterStock_Detail
(
EnterStock_ID
INT
NOT NULL,
Product_ID
INT
NOT NULL,
Quantity
float
NOT NULL,
Price
DECIMAL(12,4)
NULL,

HaveInvoice
bit
not null,
InvoiceNum
varchar(30)
NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE BackStock (
BackStock_ID
INT AUTO_INCREMENT PRIMARY
KEY
NOT NULL,
BackDate
datetime
NOT NULL,
Dept_ID
INT
NOT NULL,
StoreHouse_ID
INT
NOT NULL,
Employee_ID
INT
NOT NULL,
Remark
varchar(250)
NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE BackStock_Detail
(
BackStock_ID
INT
NOT NULL,
Product_ID
INT
NOT NULL,
Quantity
float
NOT NULL,
Price
DECIMAL(12,4)
NULL
) ENGINE=InnoDB DEFAULT
CHARSET=utf8;

CREATE TABLE LeaveStock (
LeaveStock_ID
INT AUTO_INCREMENT PRIMARY
KEY
NOT NULL,
LeaveDate
datetime
NOT NULL,
Dept_ID
INT
NOT NULL,
StoreHouse_ID
INT
NOT NULL,
ToStoreHouse_ID
INT
NOT NULL,
Employee_ID
INT
NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE LeaveStock_Detail
(
LeaveStock_ID
INT
NOT NULL,
Product_ID
INT
NOT NULL,
Quantity
float
NOT NULL,
Price
DECIMAL(12,4)
NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE BackSale (
BackSale_ID
INT AUTO_INCREMENT PRIMARY
KEY
NOT NULL,
BackDate
datetime
NOT NULL,
Dept_ID
INT
NOT NULL,
StoreHouse_ID
INT
NOT NULL,
Employee_ID
INT
NOT NULL,
Remark
varchar(250)
NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE BackSale_Detail
(
BackSale_ID
INT
NOT NULL,
Product_ID
INT
NOT NULL,
Quantity
float
NOT NULL,
Price
DECIMAL(12,4)
NULL
)
ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE
SaleOrder
(
SaleOrder_ID
INT AUTO_INCREMENT PRIMARY
KEY
NOT NULL,
WriteDate
datetime
NOT NULL,
InsureDate
datetime
NOT NULL,
EndDate
datetime
NOT NULL,
Dept_ID
INT
NOT NULL,
Customer_ID
INT
NOT NULL,
Employee_ID
INT
NOT NULL )
ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE SaleOrder_Detail
(
SaleOrder_ID
INT
NOT NULL,
Product_ID
INT
NOT NULL,
Quantity
float
not null,
Price
DECIMAL(12,4)
null
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE
Buy
(
Buy_ID
INT AUTO_INCREMENT PRIMARY
KEY
NOT NULL,
ComeDate
datetime
NOT NULL,
Dept_ID
INT
NOT NULL,
Employee_ID
INT
NOT NULL ) ENGINE=InnoDB
DEFAULT CHARSET=utf8;

CREATE TABLE Buy_Detail
(
Buy_ID
INT
NOT NULL,
Product_ID
INT
NOT NULL,
BuyOrder_ID
INT
NULL,

Quantity
float
not null,
Price
DECIMAL(12,4)
null

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE Sale
(
Sale_ID
INT AUTO_INCREMENT PRIMARY
KEY
NOT NULL,
SaleDate
datetime
not null,
Dept_ID
INT
NOT NULL,
Employee_ID
INT
NOT NULL )
ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE Sale_Detail
(
Sale_ID
INT
NOT NULL,
Product_ID
INT
NOT NULL,

SaleOrder_ID
INT
NULL,

Quantity
float
not null,
Price
DECIMAL(12,4)
not null,
Discount
int
null

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE StockPile
(
StockPile_ID
INT AUTO_INCREMENT PRIMARY
KEY
NOT NULL,
Dept_ID
INT
NOT NULL,
StoreHouse_ID
INT
NOT NULL,

Product_ID
INT
NOT NULL,

FirstEnterDate
datetime
not null,
LastLeaveDate
datetime
null,

Quantity
float
not null,
Price
DECIMAL(12,4)
not null )
ENGINE=InnoDB DEFAULT CHARSET=utf8;

ALTER TABLE `Dept_Supplier`
ADD CONSTRAINT `FK_Dept_Supplier_Dept` FOREIGN KEY (`Dept_ID`)
REFERENCES `Dept` (`Dept_ID`);

ALTER TABLE `Dept_Supplier`
ADD CONSTRAINT `FK_Dept_Supplier_Supplier` FOREIGN KEY
(`Supplier_ID`) REFERENCES `Supplier` (`Supplier_ID`);

ALTER TABLE `Dept_Customer`
ADD CONSTRAINT `FK_Dept_Customer_Dept` FOREIGN KEY (`Dept_ID`)
REFERENCES `Dept` (`Dept_ID`);

ALTER TABLE `Dept_Customer`
ADD CONSTRAINT `FK_Dept_Customer_Customer` FOREIGN KEY
(`Customer_ID`) REFERENCES `Customer` (`Customer_ID`);

ALTER TABLE `StoreHouse`
ADD CONSTRAINT `FK_StoreHouse_Employee` FOREIGN KEY (`Employee_ID`)
REFERENCES `Employee` (`Employee_ID`);

ALTER TABLE `ProductClass`
ADD CONSTRAINT `FK_ProductClass_Employee` FOREIGN KEY
(`Employee_ID`) REFERENCES `Employee` (`Employee_ID`);

ALTER TABLE `ProductList`
ADD CONSTRAINT `FK_ProductList_ProductClass` FOREIGN KEY
(`ProductClass_ID`) REFERENCES `ProductClass`
(`ProductClass_ID`);

ALTER TABLE `ProductList`
ADD CONSTRAINT `FK_ProductList_Employee` FOREIGN KEY
(`Employee_ID`) REFERENCES `Employee` (`Employee_ID`);

ALTER TABLE `ProductSpec`
ADD CONSTRAINT `FK_ProductSpec_Employee` FOREIGN KEY
(`Employee_ID`) REFERENCES `Employee` (`Employee_ID`);

ALTER TABLE `ProductUnit`
ADD CONSTRAINT `FK_ProductUnit_Employee` FOREIGN KEY
(`Employee_ID`) REFERENCES `Employee` (`Employee_ID`);

ALTER TABLE `Product`
ADD CONSTRAINT `FK_Product_ProductList` FOREIGN KEY
(`ProductList_ID`) REFERENCES `ProductList`
(`ProductClass_ID`);

ALTER TABLE `Product`
ADD CONSTRAINT `FK_Product_ProductSpec` FOREIGN KEY
(`ProductSpec_ID`) REFERENCES `ProductSpec`
(`ProductSpec_ID`);

ALTER TABLE `Product`
ADD CONSTRAINT `FK_Product_ProductUnit` FOREIGN KEY
(`ProductUnit_ID`) REFERENCES `ProductUnit`
(`ProductUnit_ID`);

ALTER TABLE `Product`
ADD CONSTRAINT `FK_Product_Employee` FOREIGN KEY (`Employee_ID`)
REFERENCES `Employee` (`Employee_ID`);

ALTER TABLE `Product_Supplier`
ADD CONSTRAINT `FK_Product_Supplier_Product` FOREIGN KEY
(`Product_ID`) REFERENCES `Product` (`Product_ID`);

ALTER TABLE `Product_Supplier`
ADD CONSTRAINT `FK_Product_Supplier_Supplier` FOREIGN KEY
(`Supplier_ID`) REFERENCES `Supplier` (`Supplier_ID`);

ALTER TABLE `BuyOrder`
ADD CONSTRAINT `FK_BuyOrder_Dept` FOREIGN KEY (`Dept_ID`)
REFERENCES `Dept` (`Dept_ID`);

ALTER TABLE `BuyOrder`
ADD CONSTRAINT `FK_BuyOrder_Supplier` FOREIGN KEY (`Supplier_ID`)
REFERENCES `Supplier` (`Supplier_ID`);

ALTER TABLE `BuyOrder`
ADD CONSTRAINT `FK_BuyOrder_Employee` FOREIGN KEY (`Employee_ID`)
REFERENCES `Employee` (`Employee_ID`);

ALTER TABLE `BuyOrder_Detail`
ADD CONSTRAINT `FK_BuyOrder_Detail_BuyOrder` FOREIGN KEY
(`BuyOrder_ID`) REFERENCES `BuyOrder` (`BuyOrder_ID`);

ALTER TABLE `BuyOrder_Detail`
ADD CONSTRAINT `FK_BuyOrder_Detail_Product` FOREIGN KEY
(`Product_ID`) REFERENCES `Product` (`Product_ID`);

ALTER TABLE `EnterStock`
ADD CONSTRAINT `FK_EnterStock_Dept` FOREIGN KEY (`Dept_ID`)
REFERENCES `Dept` (`Dept_ID`);

ALTER TABLE `EnterStock`
ADD CONSTRAINT `FK_EnterStock_StoreHouse` FOREIGN KEY
(`StoreHouse_ID`) REFERENCES `StoreHouse` (`StoreHouse_ID`);

ALTER TABLE `EnterStock`
ADD CONSTRAINT `FK_EnterStock_Employee` FOREIGN KEY (`Employee_ID`)
REFERENCES `Employee` (`Employee_ID`);

ALTER TABLE `EnterStock_Detail`
ADD CONSTRAINT `FK_EnterStock_Detail_EnterStock` FOREIGN KEY
(`EnterStock_ID`) REFERENCES `EnterStock` (`EnterStock_ID`);

ALTER TABLE `EnterStock_Detail`
ADD CONSTRAINT `FK_EnterStock_Detail_Product` FOREIGN KEY
(`Product_ID`) REFERENCES `Product` (`Product_ID`);

ALTER TABLE `BackStock`
ADD CONSTRAINT `FK_BackStock_Dept` FOREIGN KEY (`Dept_ID`)
REFERENCES `Dept` (`Dept_ID`);

ALTER TABLE `BackStock`
ADD CONSTRAINT `FK_BackStock_StoreHouse` FOREIGN KEY
(`StoreHouse_ID`) REFERENCES `StoreHouse` (`StoreHouse_ID`);

ALTER TABLE `BackStock`
ADD CONSTRAINT `FK_BackStock_Employee` FOREIGN KEY (`Employee_ID`)
REFERENCES `Employee` (`Employee_ID`);

ALTER TABLE `BackStock_Detail`
ADD CONSTRAINT `FK_BackStock_Detail_BackStock` FOREIGN KEY
(`BackStock_ID`) REFERENCES `BackStock` (`BackStock_ID`);

ALTER TABLE `BackStock_Detail`
ADD CONSTRAINT `FK_BackStock_Detail_Product` FOREIGN KEY
(`Product_ID`) REFERENCES `Product` (`Product_ID`);

ALTER TABLE `LeaveStock`
ADD CONSTRAINT `FK_LeaveStock_Dept` FOREIGN KEY (`Dept_ID`)
REFERENCES `Dept` (`Dept_ID`);

ALTER TABLE `LeaveStock`
ADD CONSTRAINT `FK_LeaveStock_StockHouse` FOREIGN KEY
(`StoreHouse_ID`) REFERENCES `StoreHouse` (`StoreHouse_ID`);

ALTER TABLE `LeaveStock`
ADD CONSTRAINT `FK_LeaveStock_StockHouse_to` FOREIGN KEY
(`ToStoreHouse_ID`) REFERENCES `StoreHouse`
(`StoreHouse_ID`);

ALTER TABLE `LeaveStock`
ADD CONSTRAINT `FK_LeaveStock_Employee` FOREIGN KEY (`Employee_ID`)
REFERENCES `Employee` (`Employee_ID`);

ALTER TABLE `LeaveStock_Detail`
ADD CONSTRAINT `FK_LeaveStock_Detai_LeaveStock` FOREIGN KEY
(`LeaveStock_ID`) REFERENCES `LeaveStock` (`LeaveStock_ID`);

ALTER TABLE `LeaveStock_Detail`
ADD CONSTRAINT `FK_LeaveStock_Detai_Product` FOREIGN KEY
(`Product_ID`) REFERENCES `Product` (`Product_ID`);

ALTER TABLE `BackSale`
ADD CONSTRAINT `FK_BackSale_Dept` FOREIGN KEY (`Dept_ID`)
REFERENCES `Dept` (`Dept_ID`);

ALTER TABLE `BackSale`
ADD CONSTRAINT `FK_BackSale_StoreHouse` FOREIGN KEY
(`StoreHouse_ID`) REFERENCES `StoreHouse` (`StoreHouse_ID`);

ALTER TABLE `BackSale`
ADD CONSTRAINT `FK_BackSale_Employee` FOREIGN KEY (`Employee_ID`)
REFERENCES `Employee` (`Employee_ID`);

ALTER TABLE `BackSale_Detail`
ADD CONSTRAINT `FK_BackSale_Detail_BackSale` FOREIGN KEY
(`BackSale_ID`) REFERENCES `BackSale` (`BackSale_ID`);

ALTER TABLE `BackSale_Detail`
ADD CONSTRAINT `FK_BackSale_Detail_Product` FOREIGN KEY
(`Product_ID`) REFERENCES `Product` (`Product_ID`);

ALTER TABLE `SaleOrder`
ADD CONSTRAINT `FK_SaleOrder_Dept` FOREIGN KEY (`Dept_ID`)
REFERENCES `Dept` (`Dept_ID`);

ALTER TABLE `SaleOrder`
ADD CONSTRAINT `FK_SaleOrder_Customer` FOREIGN KEY (`Customer_ID`)
REFERENCES `Customer` (`Customer_ID`);

ALTER TABLE `SaleOrder`
ADD CONSTRAINT `FK_SaleOrder_Employee` FOREIGN KEY (`Employee_ID`)
REFERENCES `Employee` (`Employee_ID`);

ALTER TABLE `SaleOrder_Detail`
ADD CONSTRAINT `FK_SaleOrder_Detail_SaleOrder` FOREIGN KEY
(`SaleOrder_ID`) REFERENCES `SaleOrder` (`SaleOrder_ID`);

ALTER TABLE `SaleOrder_Detail`
ADD CONSTRAINT `FK_SaleOrder_Detail_Product` FOREIGN KEY
(`Product_ID`) REFERENCES `Product` (`Product_ID`);

ALTER TABLE `Buy`
ADD CONSTRAINT `FK_Buy_Dept` FOREIGN KEY (`Dept_ID`) REFERENCES
`Dept` (`Dept_ID`);

ALTER TABLE `Buy`
ADD CONSTRAINT `FK_Buy_Employee` FOREIGN KEY (`Employee_ID`)
REFERENCES `Employee` (`Employee_ID`);

ALTER TABLE `Buy_Detail`
ADD CONSTRAINT `FK_Buy_Detail_Buy` FOREIGN KEY (`Buy_ID`)
REFERENCES `Buy` (`Buy_ID`);

ALTER TABLE `Buy_Detail`
ADD CONSTRAINT `FK_Buy_Detail_Product` FOREIGN KEY (`Product_ID`)
REFERENCES `Product` (`Product_ID`);

ALTER TABLE `Buy_Detail`
ADD CONSTRAINT `FK_Buy_Detail_BuyOrder` FOREIGN KEY (`BuyOrder_ID`)
REFERENCES `BuyOrder` (`BuyOrder_ID`);

ALTER TABLE `Sale`
ADD CONSTRAINT `FK_Sale_Dept` FOREIGN KEY (`Dept_ID`) REFERENCES
`Dept` (`Dept_ID`);

ALTER TABLE `Sale`
ADD CONSTRAINT `FK_Sale_Employee` FOREIGN KEY (`Employee_ID`)
REFERENCES `Employee` (`Employee_ID`);

ALTER TABLE `Sale_Detail`
ADD CONSTRAINT `FK_Sale_Detail_Sale` FOREIGN KEY (`Sale_ID`)
REFERENCES `Sale` (`Sale_ID`);

ALTER TABLE `Sale_Detail`
ADD CONSTRAINT `FK_Sale_Detail_Product` FOREIGN KEY (`Product_ID`)
REFERENCES `Product` (`Product_ID`);

ALTER TABLE `Sale_Detail`
ADD CONSTRAINT `FK_Sale_Detail_SaleOrder` FOREIGN KEY
(`SaleOrder_ID`) REFERENCES `SaleOrder` (`SaleOrder_ID`);

ALTER TABLE `StockPile`
ADD CONSTRAINT `FK_StockPile_Dept` FOREIGN KEY (`Dept_ID`)
REFERENCES `Dept` (`Dept_ID`);

ALTER TABLE `StockPile`
ADD CONSTRAINT `FK_StockPile_StockHouse` FOREIGN KEY
(`StoreHouse_ID`) REFERENCES `StoreHouse` (`StoreHouse_ID`);

ALTER TABLE `StockPile`
ADD CONSTRAINT `FK_StockPile_Product` FOREIGN KEY (`Product_ID`)
REFERENCES `Product` (`Product_ID`);

相关推荐

咨询软件
 
QQ在线咨询
售前咨询热线
QQ1793040