系统定制开发Vue+Node.js+Msyql实现一个简单的毕业设计《体检预约管理系统》

系统定制开发最近接了一个小姐姐的毕业设计，系统定制开发她是要我做一个纯前端的《系统定制开发体检预约管理系统》，系统定制开发我一想前端咋去用node.js系统定制开发访问数据库呀？系统定制开发于是乎去面向百度了一波，系统定制开发终究还是找到了案例代码，系统定制开发然后日夜冥思苦想把这系统定制开发个项目做出来给交付了，系统定制开发废话不多说，开始正题！

系统定制开发话不多说咱们直接开整吧，冲啊！！！冲啊！！！冲啊！！！

系统定制开发开发技术及开发工具

系统定制开发开发工具采用vsCode【系统定制开发前后端代码的编写】、Navicat Premium 15【My的连接】

前端采用Vue、ElementUI

后端采用node.js

系统定制开发数据库采用Mysql

轮播图文件存储是用到了阿里云的OSS对象存储，想了解的直接去看官网的SDK就行，免费可以使用的

阿里云官网地址：

《体检预约管理系统》视频展示，视频前几十秒可能会有些许的模糊，不过也就几十秒

项目整体架构图

前端架构图

后端架构图

Vue.js+ElementUi前端核心页面功能截图

这里就不贴代码了，内容太多了，兄弟们需要源码自行到文尾链接下载

1.首页

2.系统管理（用户管理）

3.系统管理（角色管理）

4.系统管理（菜单管理）

5.项目管理（项目详情）

6.套餐管理（套餐详情）

7.记录管理（预约记录）

8.日志管理（登录日志）

9.轮播图管理（轮播图详情）

10.个人管理（个人信息）

11.登录

 

Node.js后端核心代码（以下为部分代码，整个项目请点击文尾连接下载）

1.设置跨域请求

  1. const express = require('express')
  2. const bodyParser = require('body-parser')
  3. const router = require('./router/router.js')
  4. const app = express()
  5.  
  6. // 跨域请求处理
  7. app.all('*', (req, res, next) => {
  8.   res.header('Access-Control-Allow-Origin', '*')
  9.   res.header('Access-Control-Allow-Headers', 'X-Requested-With')
  10.   res.header('Access-Control-Allow-Headers', 'Content-Type, Content-Length, Authorization, Accept, X-Requested-With, X_Requested_With')
  11.   res.header('Access-Control-Allow-Methods', 'PUT, POST, GET, DELETE, OPTIONS')
  12.   res.header('X-Powered-By', '3.2.1')
  13.   if (req.method == 'OPTIONS') res.send(200)
  14.   /*让options请求快速返回*/ else next()
  15. })
  16.  
  17.  
  18.  
  19. app.use(bodyParser.urlencoded({ extended: false }))
  20. app.use(bodyParser.json())
  21.  
  22.  
  23. app.use(router)
  24.  
  25. app.listen('3000', () => {
  26.   console.log('Server is running');
  27. })

2.数据库连接信息设置

host：连接地址

user：数据库用户名

password：数据库密码

database：数据库名称

创建数据连接的js工具类（以下为部分代码，整个项目请点击文尾连接下载）

  1. var mysql = require('mysql')
  2.  
  3. var mysql_config = {
  4.  
  5.   host: 'localhost',
  6.  
  7.   user: 'root',
  8.  
  9.   password: '123456',
  10.  
  11.   database: 'healthcheck'
  12.  
  13. }
  14.  
  15. function handleDisconnection() {
  16.  
  17.   var dbServer = mysql.createConnection(mysql_config)
  18.  
  19.   dbServer.connect(function (err) {
  20.     console.log('数据库链接成功')
  21.     if (err) {
  22.  
  23.       setTimeout(handleDisconnection, 2000)
  24.  
  25.     }
  26.  
  27.   })
  28.  
  29.   dbServer.on('error', function (err) {
  30.  
  31.     console.log('db error', err)
  32.  
  33.     if (err.code === 'PROTOCOL_CONNECTION_LOST') {
  34.  
  35.       console.log('db error执行重连:' + err.message)
  36.  
  37.       handleDisconnection()
  38.  
  39.     } else {
  40.  
  41.       throw err
  42.  
  43.     }
  44.  
  45.   })
  46.  
  47.   return dbServer //返回一个connection对象，用于调用它的其他方法
  48.  
  49.   exports.dbServer = dbServer
  50.  
  51. }
  52.  
  53. exports.handleDisconnection = handleDisconnection

3.功能接口

感觉跟java的jdbc差不多也是创建连接对象然后再去执行sql语句，最后再获取返回结果（以下为部分代码，整个项目请点击文尾连接下载）

  1. const express = require('express')
  2. const con = require('../modul/db.js')
  3.  
  4. const router = express.Router()
  5.  
  6. let db= con.handleDisconnection()
  7.  
  8. //====================================================================
  9. //====================================================================
  10. //首页当天查询
  11. router.get('/getToay', (req, res) => {
  12.   let sql = "select (select count(*) from record as r where r.cid = c.cid and date(r.time) = curdate()) as count,c.* from combo as c  ";
  13.   db.query({
  14.     sql: sql
  15.   }, (err, results, fields) => {
  16.     res.send(results)
  17.   })
  18. })
  19. //近7天查询
  20. router.get('/getWeek', (req, res) => {
  21.   let sql = "select (select count(*) from record as r where r.cid = c.cid and DATE_SUB(CURDATE(), INTERVAL 7 DAY) <= date(r.time)) as count,c.* from combo as c  ";
  22.   db.query({
  23.     sql: sql
  24.   }, (err, results, fields) => {
  25.     res.send(results)
  26.   })
  27. })
  28. //近30天查询
  29. router.get('/getMonth', (req, res) => {
  30.   let sql = "select (select count(*) from record as r where r.cid = c.cid and DATE_SUB(CURDATE(), INTERVAL 30 DAY) <= date(r.time)) as count,c.* from combo as c   ";
  31.   db.query({
  32.     sql: sql
  33.   }, (err, results, fields) => {
  34.     res.send(results)
  35.   })
  36. })
  37. //今年查询
  38. router.get('/getYear', (req, res) => {
  39.   let sql = "select (select count(*) from record as r where r.cid = c.cid and YEAR(r.time)=YEAR(NOW())) as count,c.* from combo as c  ";
  40.   db.query({
  41.     sql: sql
  42.   }, (err, results, fields) => {
  43.     res.send(results)
  44.   })
  45. })
  46. //====================================================================
  47. //====================================================================
  48.  
  49. //登录
  50. router.get('/login', (req, res) => {
  51.   let account = req.query.account //账号
  52.   let password = req.query.password //密码
  53.   let sql = "select * from `user` where account = '"+account+"' and `password` = '"+password+"';";
  54.   db.query({
  55.     sql: sql
  56.   }, (err, results, fields) => {
  57.     res.send(results)
  58.   })
  59. })
  60.  
  61. //注册用户
  62. router.post('/register', (req, res) => {
  63.   // let dat = new Date
  64.   let sql = "INSERT INTO `user`(account,`password`,`time`,`status`) "+ 
  65.   "VALUES ('"+req.body.account+"', '"+req.body.password+"', '"+req.body.time+"','1')";
  66.  
  67.   db.query(sql, (err, result) => {
  68.     if (err) {
  69.       console.log("错误信息",err)
  70.     } else {
  71.       //获取用户编号
  72.       var uid = result.insertId;
  73.       //新增用户角色表
  74.       let sql = "INSERT INTO `userrole`(rid,uid) VALUES ('3', '"+uid+"')";
  75.       db.query(sql, (err, result) => {
  76.         if (err) {
  77.           console.log("错误信息",err)
  78.         } else {
  79.           res.json({
  80.             code: 200
  81.           })
  82.         }
  83.       })
  84.     }
  85.   })
  86. })
  87.  
  88. //====================================================================
  89. //====================================================================
  90.  
  91. //根据用户编号查询root节点
  92. router.get('/rootMeun', (req, res) => {
  93.   let uid = req.query.uid //用户编号
  94.   let sql = "select * from `user` as u "+
  95.   "inner join userrole as ur on ur.uid = u.uid "+
  96.   "inner join role as r on ur.rid=r.rid "+
  97.   "inner join menurole as mr on mr.rid=r.rid "+
  98.   "inner join menu as m on mr.mid=m.mid "+
  99.   "where u.uid = '"+uid+"' and m.pid = '0'";
  100.   db.query({
  101.     sql: sql,
  102.     nestTables:'_'
  103.   },function(err,result){
  104.     res.send(result)
  105.   })
  106. })
  107. //根据root节点查询子节点
  108. router.get('/childrenMeun', (req, res) => {
  109.   let mid = req.query.mid //root菜单编号
  110.   let sql = "select * from `menu` where pid = '"+mid+"';";
  111.   db.query({
  112.     sql: sql
  113.   }, (err, results, fields) => {
  114.     res.send(results)
  115.   })
  116. })
  117.  
  118. //====================================================================
  119. //====================================================================
  120. //新增用户
  121. router.post('/addUser', (req, res) => {
  122.   let sql = "INSERT INTO `user`(account,`password`,`name`,`number`,`gender`,`phone`,`address`,`age`,`time`,`status`) "+ 
  123.   "VALUES ('"+req.body.account+"', '"+req.body.password+"','"+req.body.name+"','"+req.body.number+"','"+req.body.gender+"','"+req.body.phone+"','"+req.body.address+"','"+req.body.age+"', '"+req.body.time+"','"+req.body.status+"')";
  124.  
  125.   db.query(sql, (err, result) => {
  126.     if (err) {
  127.       console.log("错误信息",err)
  128.     } else {
  129.       //获取用户编号
  130.       var uid = result.insertId;
  131.       //获取角色编号
  132.       var rid = req.body.backup;
  133.       //新增用户角色表
  134.       let sql = "INSERT INTO `userrole`(rid,uid) VALUES ('"+rid+"', '"+uid+"')";
  135.       db.query(sql, (err, result) => {
  136.         if (err) {
  137.           console.log("错误信息",err)
  138.         } else {
  139.           res.json({
  140.             code: 200
  141.           })
  142.         }
  143.       })
  144.     }
  145.   })
  146. })
  147.  
  148. // 删除用户
  149. router.get('/delUser', (req, res) => {
  150.   let uid = req.query.uid;
  151.   let sql = "DELETE FROM `user` WHERE uid = '"+uid+"'";
  152.   db.query(sql, (err, result) => {
  153.     if (err) {
  154.       console.log(err)
  155.     } else {
  156.       res.json({
  157.         code: 200
  158.       })
  159.     }
  160.   })
  161. })
  162. //修改用户
  163. router.post('/updateUser', (req, res) => {
  164.   //获取用户编号
  165.   let uid = req.body.uid;
  166.   //获取角色编号
  167.   let rid = req.body.rid;
  168.   let sql = "UPDATE `user` SET "+
  169.             "account = '"+req.body.account+"',"+
  170.             "password = '"+req.body.password+"',"+
  171.             "name = '"+req.body.name+"',"+
  172.             "number = '"+req.body.number+"',"+
  173.             "gender = '"+req.body.gender+"',"+
  174.             "phone = '"+req.body.phone+"',"+
  175.             "address = '"+req.body.address+"',"+
  176.             "age = '"+req.body.age+"',"+
  177.             "status = '"+req.body.status+"'"+
  178.             "WHERE uid = '"+uid+"'";
  179.   db.query(sql, (err, result) => {
  180.     if (err) {
  181.       console.log("错误信息1",err)
  182.     } else {
  183.       if(''!=rid){
  184.         //修改用户角色表
  185.         let sql = "UPDATE `userrole` SET "+
  186.                   "rid = '"+rid+"'"+
  187.                   "WHERE uid = '"+uid+"'";
  188.         db.query(sql, (err, result) => {
  189.           if (err) {
  190.             console.log("错误信息2",err)
  191.           } else {
  192.             res.json({
  193.               code: 200
  194.             })
  195.           }
  196.         })
  197.       }else{
  198.         res.json({
  199.           code: 200
  200.         })
  201.       }
  202.       
  203.     }
  204.   })
  205. })
  206. //查询所有用户
  207. router.get('/queryUser', (req, res) => {
  208.   let sql = "select r.rname as rname,u.* from `user` as u "+
  209.             "inner join userrole as ur on ur.uid = u.uid "+
  210.             "inner join role as r on ur.rid=r.rid;"
  211.   db.query({
  212.     sql: sql
  213.   }, (err, results, fields) => {
  214.     res.send(results)
  215.   })
  216. })
  217. //分页查询所有用户
  218. router.get('/queryUserPage', (req, res) => {
  219.     //模糊查询用户名称
  220.     let input = req.query.input;
  221.       //模糊查询用户地址
  222.     let address = req.query.address;
  223.     //模糊查询用户角色
  224.     let option = req.query.option;
  225.       //模糊查询用户状态
  226.     let status = req.query.status;
  227.  
  228.   //默认页码
  229.   let currentPage = 1;
  230.   //默认显示数据条数
  231.   let pageSize = 8;
  232.   if(req.query.currentPage){
  233.     currentPage = req.query.currentPage;
  234.   }
  235.   if(req.query.pageSize){
  236.     pageSize = req.query.pageSize;
  237.   }
  238.   //最后一页页码
  239.   let last_page = currentPage-1;
  240.   if(currentPage<=1){
  241.     last_page = 1;
  242.   }
  243.   console.log("当前页",currentPage);
  244.  
  245.   let total = 0;
  246.   //查询总条数
  247.   let sql = "select r.rname as rname,u.* from `user` as u "+
  248.             "inner join userrole as ur on ur.uid = u.uid "+
  249.             "inner join role as r on ur.rid=r.rid where 1=1 "
  250.             if(input!='' && input!=undefined){
  251.               sql += "and u.name like '%"+input+"%' ";
  252.             }
  253.             if(address!='' && address!=undefined){
  254.               sql += "and u.address like '%"+address+"%' ";
  255.             }
  256.             if(option!='' && option!=undefined){
  257.               sql += "and r.rid = '"+option+"' ";
  258.             }
  259.             if(status!='' && status!=undefined){
  260.               sql += "and u.status = '"+status+"' ";
  261.             }
  262.   console.log(sql);
  263.   db.query({
  264.     sql: sql
  265.   }, (err, results, fields) => {
  266.  
  267.     console.log(results.length)
  268.     total = results.length;
  269.     currentPage = (currentPage - 1 ) * pageSize;
  270.     let sql2 = sql+"limit "+currentPage+","+pageSize+"";
  271.     db.query({
  272.       sql: sql2
  273.     }, (err, results, fields) => {
  274.       console.log(results)
  275.       if(results!=''){
  276.         results[0].backup3 = total;
  277.       }
  278.       res.send(results)
  279.     })
  280.   })
  281. })
  282. //根据ID查询用户
  283. router.get('/queryUserById', (req, res) => {
  284.   let uid = req.query.uid;
  285.   let sql = "select r.rname as rname,r.rid as rid,u.* from `user` as u "+
  286.   "inner join userrole as ur on ur.uid = u.uid "+
  287.   "inner join role as r on ur.rid=r.rid where u.uid = '"+uid+"'";
  288.   db.query({
  289.     sql: sql
  290.   }, (err, results, fields) => {
  291.     console.log(results);
  292.     res.send(results)
  293.   })
  294. })
  295. //====================================================================
  296. //====================================================================
  297. //新增角色
  298. router.post('/addRole', (req, res) => {
  299.   let backup = req.body.pid;
  300.   let sql = "INSERT INTO `role`(rname,`desc`) "+ 
  301.   "VALUES ('"+req.body.rname+"', '"+req.body.desc+"')";
  302.  
  303.   db.query(sql, (err, result) => {
  304.     if (err) {
  305.       console.log("错误信息",err)
  306.     } else {
  307.       //判断新增是不是父节点
  308.         res.json({
  309.           code: 200
  310.         })
  311.     }
  312.   })
  313. })
  314. //查询所有角色
  315. router.get('/queryRole', (req, res) => {
  316.   let sql = "select * from `role`;";
  317.   db.query({
  318.     sql: sql
  319.   }, (err, results, fields) => {
  320.     res.send(results)
  321.   })
  322. })
  323. //分页查询所有角色
  324. router.get('/queryRolePage', (req, res) => {
  325.   //默认页码
  326.   let currentPage = 1;
  327.   //默认显示数据条数
  328.   let pageSize = 9;
  329.   if(req.query.currentPage){
  330.     currentPage = req.query.currentPage;
  331.   }
  332.   if(req.query.pageSize){
  333.     pageSize = req.query.pageSize;
  334.   }
  335.   //最后一页页码
  336.   let last_page = currentPage-1;
  337.   if(currentPage<=1){
  338.     last_page = 1;
  339.   }
  340.   console.log("当前页",currentPage);
  341.  
  342.   let total = 0;
  343.   //查询总条数
  344.   let sql = "select * from role";
  345.   console.log(sql);
  346.   db.query({
  347.     sql: sql
  348.   }, (err, results, fields) => {
  349.  
  350.     console.log(results.length)
  351.     total = results.length;
  352.     currentPage = (currentPage - 1 ) * pageSize;
  353.     let sql2 = "select * from role "+
  354.                "limit "+currentPage+","+pageSize+" ";
  355.     db.query({
  356.       sql: sql2
  357.     }, (err, results, fields) => {
  358.       console.log(err);
  359.       console.log("这是sql2",sql2)
  360.       if(results!=''){
  361.         results[0].backup3 = total;
  362.       }
  363.       res.send(results)
  364.     })
  365.   })
  366. })
  367. // 删除角色
  368. router.get('/delRole', (req, res) => {
  369.   let rid = req.query.rid;
  370.   let sql = "DELETE FROM `role` WHERE rid = '"+rid+"'";
  371.   db.query(sql, (err, result) => {
  372.     if (err) {
  373.       console.log(err)
  374.     } else {
  375.       res.json({
  376.         code: 200
  377.       })
  378.     }
  379.   })
  380. })
  381. //修改角色
  382. router.post('/updateRole', (req, res) => {
  383.   //获取角色编号
  384.   let rid = req.body.rid;
  385.   let sql = "UPDATE `role` SET "+
  386.             "rname = '"+req.body.rname+"',"+
  387.             "`desc` = '"+req.body.desc+"' "+
  388.             "WHERE rid = '"+rid+"'";
  389.   db.query(sql, (err, result) => {
  390.     if (err) {
  391.       console.log("错误信息1",err)
  392.     } else {
  393.       res.json({
  394.         code: 200
  395.       })
  396.     }
  397.   })
  398. })
  399. //根据ID查询角色
  400. router.get('/queryRoleById', (req, res) => {
  401.   let rid = req.query.rid;
  402.   let sql = "select * from role "+
  403.   "where rid = '"+rid+"'";
  404.   db.query({
  405.     sql: sql
  406.   }, (err, results, fields) => {
  407.     console.log(results);
  408.     res.send(results)
  409.   })
  410. })
  411. //根据角色编号查询出他所有的父菜单
  412. router.get('/queryMenuByRid', (req, res) => {
  413.   let rid = req.query.rid;
  414.   let sql = "select m.mid as mid from menu as m "+
  415.   "inner join menurole as mr on m.mid=mr.mid  "+
  416.   "where mr.rid = '"+rid+"' and  m.pid = '0' ";
  417.   db.query({
  418.     sql: sql
  419.   }, (err, results, fields) => {
  420.     console.log(results);
  421.     res.send(results)
  422.   })
  423. })
  424. //新增角色对应菜单
  425. router.get('/addRoleMenu', (req, res) => {
  426.   let sql = "INSERT INTO `menurole`(rid,mid) "+ 
  427.   "VALUES ('"+req.query.rid+"', '"+req.query.mid+"' )";
  428.  
  429.   db.query(sql, (err, result) => {
  430.     if (err) {
  431.       console.log("错误信息",err)
  432.     } else {
  433.         res.json({
  434.           code: 200
  435.         })
  436.     }
  437.   })
  438. })
  439. // 删除角色对应菜单
  440. router.get('/delRoleMenu', (req, res) => {
  441.   let rid = req.query.rid;
  442.   let sql = "DELETE FROM `menurole` WHERE rid = '"+rid+"'";
  443.   db.query(sql, (err, result) => {
  444.     if (err) {
  445.       console.log(err)
  446.     } else {
  447.       res.json({
  448.         code: 200
  449.       })
  450.     }
  451.   })
  452. })
  453. //====================================================================
  454. //====================================================================
  455. //新增菜单
  456. router.post('/addMenu', (req, res) => {
  457.   let backup = req.body.pid;
  458.   let sql = "INSERT INTO `menu`(mname,pid,url) "+ 
  459.   "VALUES ('"+req.body.mname+"', '"+req.body.pid+"','"+req.body.url+"' )";
  460.  
  461.   db.query(sql, (err, result) => {
  462.     if (err) {
  463.       console.log("错误信息",err)
  464.     } else {
  465.       //判断新增是不是父节点
  466.         res.json({
  467.           code: 200
  468.         })
  469.     }
  470.   })
  471. })
  472. // 删除菜单
  473. router.get('/delMenu', (req, res) => {
  474.   let mid = req.query.mid;
  475.   let sql = "DELETE FROM `menu` WHERE mid = '"+mid+"'";
  476.   db.query(sql, (err, result) => {
  477.     if (err) {
  478.       console.log(err)
  479.     } else {
  480.       res.json({
  481.         code: 200
  482.       })
  483.     }
  484.   })
  485. })
  486. //修改菜单
  487. router.post('/updateMenu', (req, res) => {
  488.   //获取菜单编号
  489.   let mid = req.body.mid;
  490.   let sql = "UPDATE `menu` SET "+
  491.             "mname = '"+req.body.mname+"',"+
  492.             "url = '"+req.body.url+"' "+
  493.             "WHERE mid = '"+mid+"'";
  494.   db.query(sql, (err, result) => {
  495.     if (err) {
  496.       console.log("错误信息1",err)
  497.     } else {
  498.       res.json({
  499.         code: 200
  500.       })
  501.     }
  502.   })
  503. })
  504. //查询所有父级菜单
  505. router.get('/queryMenu', (req, res) => {
  506.   let sql = "select * from `menu` where pid ='0'";
  507.   db.query({
  508.     sql: sql
  509.   }, (err, results, fields) => {
  510.     res.send(results)
  511.   })
  512. })
  513. //根据ID查询菜单
  514. router.get('/queryMenuById', (req, res) => {
  515.   let mid = req.query.mid;
  516.   let sql = "select * from menu "+
  517.   "where mid = '"+mid+"'";
  518.   db.query({
  519.     sql: sql
  520.   }, (err, results, fields) => {
  521.     console.log(results);
  522.     res.send(results)
  523.   })
  524. })
  525. //分页查询所有菜单
  526. router.get('/queryMenuPage', (req, res) => {
  527.   //默认页码
  528.   let currentPage = 1;
  529.   //默认显示数据条数
  530.   let pageSize = 9;
  531.   if(req.query.currentPage){
  532.     currentPage = req.query.currentPage;
  533.   }
  534.   if(req.query.pageSize){
  535.     pageSize = req.query.pageSize;
  536.   }
  537.   //最后一页页码
  538.   let last_page = currentPage-1;
  539.   if(currentPage<=1){
  540.     last_page = 1;
  541.   }
  542.   console.log("当前页",currentPage);
  543.  
  544.   let total = 0;
  545.   //查询总条数
  546.   let sql = "select * from menu";
  547.   console.log(sql);
  548.   db.query({
  549.     sql: sql
  550.   }, (err, results, fields) => {
  551.  
  552.     console.log(results.length)
  553.     total = results.length;
  554.     currentPage = (currentPage - 1 ) * pageSize;
  555.     let sql2 = "select * from menu "+
  556.                "limit "+currentPage+","+pageSize+" ";
  557.     db.query({
  558.       sql: sql2
  559.     }, (err, results, fields) => {
  560.       console.log(err);
  561.       console.log("这是sql2",sql2)
  562.       if(results!=''){
  563.         results[0].backup3 = total;
  564.       }
  565.       res.send(results)
  566.     })
  567.   })
  568. })
  569. //====================================================================
  570. //====================================================================
  571. //新增项目
  572. router.post('/addProject', (req, res) => {
  573.   let sql = "INSERT INTO `project`(pname,`sage`,`sgender`,`type`,`department`) "+ 
  574.   "VALUES ('"+req.body.pname+"', '"+req.body.sage+"','"+req.body.sgender+"','"+req.body.type+"','"+req.body.department+"')";
  575.  
  576.   db.query(sql, (err, result) => {
  577.     if (err) {
  578.       console.log("错误信息",err)
  579.     } else {
  580.       res.json({
  581.         code: 200
  582.       })
  583.     }
  584.   })
  585. })
  586. // 删除项目
  587. router.get('/delProject', (req, res) => {
  588.   let pid = req.query.pid;
  589.   let sql = "DELETE FROM `project` WHERE pid = '"+pid+"'";
  590.   db.query(sql, (err, result) => {
  591.     if (err) {
  592.       console.log(err)
  593.     } else {
  594.       res.json({
  595.         code: 200
  596.       })
  597.     }
  598.   })
  599. })
  600. //修改项目
  601. router.post('/updateProject', (req, res) => {
  602.   //获取项目编号
  603.   let pid = req.body.pid;
  604.   let sql = "UPDATE `project` SET "+
  605.             "pname = '"+req.body.pname+"',"+
  606.             "sage = '"+req.body.sage+"',"+
  607.             "type = '"+req.body.type+"',"+
  608.             "department = '"+req.body.department+"',"+
  609.             "sgender = '"+req.body.sgender+"' "+
  610.             "WHERE pid = '"+pid+"'";
  611.   db.query(sql, (err, result) => {
  612.     if (err) {
  613.       console.log("错误信息1",err)
  614.     } else {
  615.       res.json({
  616.         code: 200
  617.       })
  618.     }
  619.   })
  620. })
  621. //查询所有项目
  622. router.get('/queryProject', (req, res) => {
  623.   let sql = "select * from project";
  624.   db.query({
  625.     sql: sql
  626.   }, (err, results, fields) => {
  627.     res.send(results)
  628.   })
  629. })
  630. //根据ID查询项目
  631. router.get('/queryProjectById', (req, res) => {
  632.   let pid = req.query.pid;
  633.   let sql = "select * from project "+
  634.   "where pid = '"+pid+"'";
  635.   db.query({
  636.     sql: sql
  637.   }, (err, results, fields) => {
  638.     console.log(results);
  639.     res.send(results)
  640.   })
  641. })
  642. //分页查询所有项目
  643. router.get('/queryProjectPage', (req, res) => {
  644.   //模糊查询项目名称
  645.   let pname = req.query.pname;
  646.   //默认页码
  647.   let currentPage = 1;
  648.   //默认显示数据条数
  649.   let pageSize = 9;
  650.   if(req.query.currentPage){
  651.     currentPage = req.query.currentPage;
  652.   }
  653.   if(req.query.pageSize){
  654.     pageSize = req.query.pageSize;
  655.   }
  656.   //最后一页页码
  657.   let last_page = currentPage-1;
  658.   if(currentPage<=1){
  659.     last_page = 1;
  660.   }
  661.   console.log("当前页",currentPage);
  662.  
  663.   let total = 0;
  664.   //查询总条数
  665.   let sql = "select * from project where 1=1 ";
  666.   if(pname!="" && pname!=undefined){
  667.     sql += "and pname like '%"+pname+"%' ";
  668.   }
  669.   console.log(sql);
  670.   db.query({
  671.     sql: sql
  672.   }, (err, results, fields) => {
  673.  
  674.     console.log(results.length)
  675.     total = results.length;
  676.     currentPage = (currentPage - 1 ) * pageSize;
  677.     let sql2 = "select * from project where 1=1 ";
  678.     if(pname!="" || pname!=undefined || pname!="undefined"){
  679.       sql2 += "and pname like '%"+pname+"%'";
  680.     }
  681.     sql2 += "limit "+currentPage+","+pageSize+" ";
  682.     db.query({
  683.       sql: sql2
  684.     }, (err, results, fields) => {
  685.       console.log(err);
  686.       console.log("这是sql2",sql2)
  687.       if(results!=''){
  688.         results[0].backup3 = total;
  689.       }
  690.       res.send(results)
  691.     })
  692.   })
  693. })
  694.  
  695. //====================================================================
  696. //====================================================================
  697. //新增套餐
  698. router.post('/addCombo', (req, res) => {
  699.   let sql = "INSERT INTO `combo`(`cname`,`sage`,`sgender`,`meaning`,`start`,`stop`)  "+ 
  700.   "VALUES ('"+req.body.cname+"', '"+req.body.sage+"', '"+req.body.sgender+"', '"+req.body.meaning+"', '"+req.body.start+"', '"+req.body.stop+"')";
  701.  
  702.   db.query(sql, (err, result) => {
  703.     if (err) {
  704.       console.log("错误信息",err)
  705.     } else {
  706.         res.json({
  707.           code: 200
  708.         })
  709.     }
  710.   })
  711. })
  712. //查询所有套餐
  713. router.get('/queryCombo', (req, res) => {
  714.   let sql = "select * from `combo`;";
  715.   db.query({
  716.     sql: sql
  717.   }, (err, results, fields) => {
  718.     res.send(results)
  719.   })
  720. })
  721. //分页查询所有套餐
  722. router.get('/queryComboPage', (req, res) => {
  723.   //模糊查询套餐名称
  724.   let input = req.query.input;
  725.     //模糊查询起始结束时间
  726.   let start = req.query.start;
  727.   let stops = req.query.stop;
  728.   //默认页码
  729.   let currentPage = 1;
  730.   //默认显示数据条数
  731.   let pageSize = 9;
  732.   if(req.query.currentPage){
  733.     currentPage = req.query.currentPage;
  734.   }
  735.   if(req.query.pageSize){
  736.     pageSize = req.query.pageSize;
  737.   }
  738.   //最后一页页码
  739.   let last_page = currentPage-1;
  740.   if(currentPage<=1){
  741.     last_page = 1;
  742.   }
  743.   console.log("当前页",currentPage);
  744.  
  745.   let total = 0;
  746.   //查询总条数
  747.   let sql = "select * from combo where 1=1 ";
  748.             if(input!='' && input!=undefined){
  749.               sql += "and cname like '%"+input+"%' ";
  750.             }
  751.             if(start!='' && start!=undefined || stops!='' && stops!=undefined){
  752.               sql += "and `start` Between '"+start+"' AND '"+stops+"' and `stop` Between '"+start+"' AND '"+stops+"' ";
  753.             }
  754.   console.log(sql);
  755.   db.query({
  756.     sql: sql
  757.   }, (err, results, fields) => {
  758.  
  759.     console.log(results.length)
  760.     total = results.length;
  761.     currentPage = (currentPage - 1 ) * pageSize;
  762.     let sql2 = sql+"limit "+currentPage+","+pageSize+" ";
  763.     db.query({
  764.       sql: sql2
  765.     }, (err, results, fields) => {
  766.       console.log(err);
  767.       console.log("这是sql2",sql2)
  768.       if(results!=''){
  769.         results[0].backup3 = total;
  770.       }
  771.       // res.send(results)
  772.       var haha = results;
  773.       for(var i =0;i<results.length;i++){
  774.         var a =0;
  775.           //根据套餐ID查询对应的项目
  776.         var sqlp = "select * from project as p inner join cp on p.pid=cp.pid "+
  777.         "where cp.cid = '"+results[i].cid+"'";
  778.         db.query({
  779.           sql: sqlp
  780.         }, (err, resul, fields) => {
  781.           // haha[i].backup = resul;
  782.           for(var j =0;j<resul.length;j++){
  783.             results[a].backup = resul;
  784.           }
  785.           a++;
  786.         })
  787.       }
  788.       console.log(results);
  789.       res.send(results)
  790.  
  791.       
  792.     })
  793.   })
  794. })
  795. // 删除套餐
  796. router.get('/delCombo', (req, res) => {
  797.   let cid = req.query.cid;
  798.   let sql = "DELETE FROM `combo` WHERE cid = '"+cid+"'";
  799.   db.query(sql, (err, result) => {
  800.     if (err) {
  801.       console.log(err)
  802.     } else {
  803.       res.json({
  804.         code: 200
  805.       })
  806.     }
  807.   })
  808. })
  809. //修改套餐
  810. router.post('/updateCombo', (req, res) => {
  811.   //获取套餐编号
  812.   let cid = req.body.cid;
  813.   let sql = "UPDATE `combo` SET "+
  814.             "cname = '"+req.body.cname+"',"+
  815.             "sage = '"+req.body.sage+"',"+
  816.             "sgender = '"+req.body.sgender+"',"+
  817.             "meaning = '"+req.body.meaning+"',"+
  818.             "start = '"+req.body.start+"',"+
  819.             "`stop` = '"+req.body.stop+"' "+
  820.             "WHERE cid = '"+cid+"'";
  821.   db.query(sql, (err, result) => {
  822.     if (err) {
  823.       console.log("错误信息1",err)
  824.     } else {
  825.       res.json({
  826.         code: 200
  827.       })
  828.     }
  829.   })
  830. })
  831. //根据ID查询套餐
  832. router.get('/queryComboById', (req, res) => {
  833.   let cid = req.query.cid;
  834.   let sql = "select * from combo "+
  835.   "where cid = '"+cid+"'";
  836.   db.query({
  837.     sql: sql
  838.   }, (err, results, fields) => {
  839.     console.log(results);
  840.     res.send(results)
  841.   })
  842. })
  843. //根据套餐编号查询出他所有的项目
  844. router.get('/queryProjectByCid', (req, res) => {
  845.   let cid = req.query.cid;
  846.   let sql = "select p.pid as pid,p.pname as pname from project as p "+
  847.   "inner join cp on cp.pid=p.pid  "+
  848.   "where cp.cid = '"+cid+"' ";
  849.   console.log(sql);
  850.   db.query({
  851.     sql: sql
  852.   }, (err, results, fields) => {
  853.     console.log(results);
  854.     res.send(results)
  855.   })
  856. })
  857. //新增套餐对应项目
  858. router.get('/addcp', (req, res) => {
  859.   let sql = "INSERT INTO `cp`(cid,pid) "+ 
  860.   "VALUES ('"+req.query.cid+"', '"+req.query.pid+"' )";
  861.  
  862.   db.query(sql, (err, result) => {
  863.     if (err) {
  864.       console.log("错误信息",err)
  865.     } else {
  866.         res.json({
  867.           code: 200
  868.         })
  869.     }
  870.   })
  871. })
  872. // 删除套餐对应项目
  873. router.get('/delcp', (req, res) => {
  874.   let cid = req.query.cid;
  875.   let sql = "DELETE FROM `cp` WHERE cid = '"+cid+"'";
  876.   db.query(sql, (err, result) => {
  877.     if (err) {
  878.       console.log(err)
  879.     } else {
  880.       res.json({
  881.         code: 200
  882.       })
  883.     }
  884.   })
  885. })
  886. //====================================================================
  887. //====================================================================
  888. //分页查询所有记录
  889. router.get('/queryRecordPage', (req, res) => {
  890.   //查询记录状态
  891.   let status = req.query.status;
  892.     //模糊查询起始结束时间
  893.   let start = req.query.start;
  894.   let stops = req.query.stop;
  895.   //默认页码
  896.   let currentPage = 1;
  897.   //默认显示数据条数
  898.   let pageSize = 10;
  899.   if(req.query.currentPage){
  900.     currentPage = req.query.currentPage;
  901.   }
  902.   if(req.query.pageSize){
  903.     pageSize = req.query.pageSize;
  904.   }
  905.   //最后一页页码
  906.   let last_page = currentPage-1;
  907.   if(currentPage<=1){
  908.     last_page = 1;
  909.   }
  910.   console.log("当前页",currentPage);
  911.  
  912.   let total = 0;
  913.   //查询总条数
  914.   let sql = "select r.reid as reid,u.uid as uid,u.`name` as uname,u.phone as phone,u.gender as gender,c.cname as cname,c.`start`,c.`stop`,r.`status` as `status`,r.time as time from record as r "+
  915.             "inner join `user` as u on r.uid=u.uid "+
  916.             "inner join combo as c on r.cid=c.cid where 1=1 ";
  917.  
  918.             
  919.             if(status!='' && status!=undefined){
  920.               sql += "and r.status = '"+status+"' ";
  921.             }
  922.             if(start!='' && start!=undefined || stops!='' && stops!=undefined){
  923.               sql += "and r.time Between '"+start+"' AND '"+stops+"' ";
  924.             }
  925.   console.log(sql);
  926.   db.query({
  927.     sql: sql
  928.   }, (err, results, fields) => {
  929.  
  930.     console.log(results.length)
  931.     total = results.length;
  932.     currentPage = (currentPage - 1 ) * pageSize;
  933.     let sql2 = sql +="limit "+currentPage+","+pageSize+" ";
  934.     db.query({
  935.       sql: sql2
  936.     }, (err, results, fields) => {
  937.       console.log(err);
  938.       console.log("这是sql2",sql2)
  939.       if(results!=''){
  940.         results[0].backup3 = total;
  941.       }
  942.       res.send(results)
  943.     })
  944.   })
  945. })
  946. //根据ID查询记录
  947. router.get('/queryRecordById', (req, res) => {
  948.   let reid = req.query.reid;
  949.   let sql = "select r.reid as reid,u.uid as uid,u.`name` as uname,u.phone as phone,u.gender as gender,c.cname as cname,c.`start`,c.`stop`,r.`status` as `status`,r.time as time from record as r "+
  950.             "inner join `user` as u on r.uid=u.uid "+
  951.             "inner join combo as c on r.cid=c.cid "+
  952.             "where r.reid = '"+reid+"'";
  953.   db.query({
  954.     sql: sql
  955.   }, (err, results, fields) => {
  956.     console.log(results);
  957.     res.send(results)
  958.   })
  959. })
  960.  
  961. //根据用户ID查询记录
  962. router.get('/queryRecordById', (req, res) => {
  963.   let uid = req.query.uid;
  964.   let sql = "select r.reid as reid,u.uid as uid,u.`name` as uname,u.phone as phone,u.gender as gender,c.cname as cname,c.`start`,c.`stop`,r.`status` as `status`,r.time as time from record as r "+
  965.             "inner join `user` as u on r.uid=u.uid "+
  966.             "inner join combo as c on r.cid=c.cid "+
  967.             "where u.uid = '"+uid+"'";
  968.   db.query({
  969.     sql: sql
  970.   }, (err, results, fields) => {
  971.     console.log(results);
  972.     res.send(results)
  973.   })
  974. })
  975.  
  976. //修改记录
  977. router.post('/updateRecord', (req, res) => {
  978.   //获取记录编号
  979.   let reid = req.body.reid;
  980.   let sql = "UPDATE `record` SET "+
  981.             "time = '"+req.body.time+"',"+
  982.             "status = '"+req.body.status+"' "+
  983.             "WHERE reid = '"+reid+"'";
  984.   db.query(sql, (err, result) => {
  985.     if (err) {
  986.       console.log("错误信息1",err)
  987.     } else {
  988.       res.json({
  989.         code: 200
  990.       })
  991.     }
  992.   })
  993. })
  994.  
  995. //新增预约记录
  996. router.post('/addRecords', (req, res) => {
  997.   //获取用户编号
  998.   let uid = req.body.uid;
  999.   console.log(uid);
  1000.   let usql = "select * from `user` where uid = '"+uid+"' and `name` <> ''  and `number` <> ''  and `gender` <> ''  and `phone` <> ''  and `address` <> ''  and `age` <> ''";
  1001.  
  1002.  
  1003.   let sql = "INSERT INTO `rotation`(`roname`,`rourl`,`describe`,`status`) "+ 
  1004.   "VALUES ('"+req.body.roname+"', '"+req.body.rourl+"','"+req.body.describe+"','"+req.body.status+"' )";
  1005.  
  1006.  
  1007.   db.query({
  1008.     usql: usql
  1009.   }, (err, results, fields) => {
  1010.     console.log(results);
  1011.     res.send(results)
  1012.   })
  1013.   // db.query(sql, (err, result) => {
  1014.   //   if (err) {
  1015.   //     console.log("错误信息",err)
  1016.   //   } else {
  1017.   //       res.json({
  1018.   //         code: 200
  1019.   //       })
  1020.   //   }
  1021.   // })
  1022. })
  1023. //新增预约记录
  1024. router.get('/addRecord', (req, res) => {
  1025.   //获取用户编号
  1026.   let uid = req.body.uid;
  1027.   //获取套餐编号
  1028.   let cid = req.body.cid;
  1029.   //获取时间
  1030.   let time = req.body.time;
  1031.   let sql = "select * from `user` where uid = '"+uid+"' and `name` <> ''  and `number` <> ''  and `gender` <> ''  and `phone` <> ''  and `address` <> ''  and `age` <> ''";
  1032.   db.query({
  1033.     sql: sql
  1034.   }, (err, results, fields) => {
  1035.     console.log(results);
  1036.     if(results.length<=0){
  1037.       res.send("请先去完善个人信息")
  1038.     }else{
  1039.       let sqls = "INSERT INTO `record`(`uid`,`cid`,`status`,`time`) "+ 
  1040.       "VALUES ('"+uid+"', '"+cid+"', '2', '"+time+"' )";
  1041.     
  1042.       db.query(sqls, (err, result) => {
  1043.         if (err) {
  1044.           console.log("错误信息",err)
  1045.         } else {
  1046.             res.json({
  1047.               code: 200
  1048.             })
  1049.         }
  1050.       })
  1051.     }
  1052.   })
  1053. })
  1054.  
  1055. // 删除记录
  1056. router.get('/delRecord', (req, res) => {
  1057.   let reid = req.query.reid;
  1058.   let sql = "DELETE FROM `record` WHERE reid = '"+reid+"'";
  1059.   db.query(sql, (err, result) => {
  1060.     if (err) {
  1061.       console.log(err)
  1062.     } else {
  1063.       res.json({
  1064.         code: 200
  1065.       })
  1066.     }
  1067.   })
  1068. })
  1069. //====================================================================
  1070. //====================================================================
  1071. //分页查询所有日志
  1072. router.get('/queryLoginLogsPage', (req, res) => {
  1073.   //默认页码
  1074.   let currentPage = 1;
  1075.   //默认显示数据条数
  1076.   let pageSize = 13;
  1077.   if(req.query.currentPage){
  1078.     currentPage = req.query.currentPage;
  1079.   }
  1080.   if(req.query.pageSize){
  1081.     pageSize = req.query.pageSize;
  1082.   }
  1083.   //最后一页页码
  1084.   let last_page = currentPage-1;
  1085.   if(currentPage<=1){
  1086.     last_page = 1;
  1087.   }
  1088.   console.log("当前页",currentPage);
  1089.  
  1090.   let total = 0;
  1091.   //查询总条数
  1092.   let sql = "select u.uid as uid,u.account as account,l.* from `logs` as l "+
  1093.             "inner join `user` as u on l.uid=u.uid"
  1094.   console.log(sql);
  1095.   db.query({
  1096.     sql: sql
  1097.   }, (err, results, fields) => {
  1098.  
  1099.     console.log(results.length)
  1100.     total = results.length;
  1101.     currentPage = (currentPage - 1 ) * pageSize;
  1102.     let sql2 = "select u.uid as uid,u.account as account,l.* from `logs` as l "+
  1103.                "inner join `user` as u on l.uid=u.uid "+
  1104.                "order by l.time desc "+
  1105.                "limit "+currentPage+","+pageSize+" ";
  1106.     db.query({
  1107.       sql: sql2
  1108.     }, (err, results, fields) => {
  1109.       console.log(err);
  1110.       console.log("这是sql2",sql2)
  1111.       if(results!=''){
  1112.         results[0].backup3 = total;
  1113.       }
  1114.       res.send(results)
  1115.     })
  1116.   })
  1117. })
  1118. //新增登入登出登录日志
  1119. router.post('/addLoginLogs', (req, res) => {
  1120.   //获取操作详情(0:登入,1:登出)
  1121.   let details = req.body.details;
  1122.   console.log("草拟吗",details)
  1123.   if(details=="0"){
  1124.     details='登入了系统';
  1125.   }else if(details=="1"){
  1126.     details='登出了系统';
  1127.   }
  1128.   let sql = "INSERT INTO `logs`(`uid`,`ip`,`details`,`time`) "+ 
  1129.   "VALUES ('"+req.body.uid+"', '"+req.body.ip+"','"+details+"','"+req.body.time+"')";
  1130.  
  1131.   db.query(sql, (err, result) => {
  1132.     if (err) {
  1133.       console.log("错误信息",err)
  1134.     } else {
  1135.       res.json({
  1136.         code: 200
  1137.       })
  1138.     }
  1139.   })
  1140. })
  1141.  
  1142. //====================================================================
  1143. //====================================================================
  1144. //新增轮播图
  1145. router.post('/addRotation', (req, res) => {
  1146.   let sql = "INSERT INTO `rotation`(`roname`,`rourl`,`describe`,`status`) "+ 
  1147.   "VALUES ('"+req.body.roname+"', '"+req.body.rourl+"','"+req.body.describe+"','"+req.body.status+"' )";
  1148.  
  1149.   db.query(sql, (err, result) => {
  1150.     if (err) {
  1151.       console.log("错误信息",err)
  1152.     } else {
  1153.         res.json({
  1154.           code: 200
  1155.         })
  1156.     }
  1157.   })
  1158. })
  1159. // 删除轮播图
  1160. router.get('/delRotation', (req, res) => {
  1161.   let roid = req.query.roid;
  1162.   let sql = "DELETE FROM `rotation` WHERE roid = '"+roid+"'";
  1163.   db.query(sql, (err, result) => {
  1164.     if (err) {
  1165.       console.log(err)
  1166.     } else {
  1167.       res.json({
  1168.         code: 200
  1169.       })
  1170.     }
  1171.   })
  1172. })
  1173. //修改轮播图
  1174. router.post('/updateRotation', (req, res) => {
  1175.   //获取轮播图编号
  1176.   let roid = req.body.roid;
  1177.   let sql = "UPDATE `rotation` SET "+
  1178.             "roname = '"+req.body.roname+"',"+
  1179.             "rourl = '"+req.body.rourl+"',"+
  1180.             "`describe` = '"+req.body.describe+"',"+
  1181.             "status = '"+req.body.status+"' "+
  1182.             "WHERE roid = "+roid+" ";
  1183.   db.query(sql, (err, result) => {
  1184.     if (err) {
  1185.       console.log("错误信息1",err)
  1186.     } else {
  1187.       res.json({
  1188.         code: 200
  1189.       })
  1190.     }
  1191.   })
  1192. })
  1193. //根据ID查询轮播图
  1194. router.get('/queryRotationById', (req, res) => {
  1195.   let roid = req.query.roid;
  1196.   let sql = "select * from rotation "+
  1197.   "where roid = '"+roid+"'";
  1198.   db.query({
  1199.     sql: sql
  1200.   }, (err, results, fields) => {
  1201.     console.log(results);
  1202.     res.send(results)
  1203.   })
  1204. })
  1205. //查询所有轮播图
  1206. router.get('/queryRotation', (req, res) => {
  1207.   let sql = "select * from `rotation`;";
  1208.   db.query({
  1209.     sql: sql
  1210.   }, (err, results, fields) => {
  1211.     res.send(results)
  1212.   })
  1213. })
  1214. //分页查询所有轮播图
  1215. router.get('/queryRotationPage', (req, res) => {
  1216.   //默认页码
  1217.   let currentPage = 1;
  1218.   //默认显示数据条数
  1219.   let pageSize = 9;
  1220.   if(req.query.currentPage){
  1221.     currentPage = req.query.currentPage;
  1222.   }
  1223.   if(req.query.pageSize){
  1224.     pageSize = req.query.pageSize;
  1225.   }
  1226.   //最后一页页码
  1227.   let last_page = currentPage-1;
  1228.   if(currentPage<=1){
  1229.     last_page = 1;
  1230.   }
  1231.   console.log("当前页",currentPage);
  1232.  
  1233.   let total = 0;
  1234.   //查询总条数
  1235.   let sql = "select * from menu";
  1236.   console.log(sql);
  1237.   db.query({
  1238.     sql: sql
  1239.   }, (err, results, fields) => {
  1240.  
  1241.     console.log(results.length)
  1242.     total = results.length;
  1243.     currentPage = (currentPage - 1 ) * pageSize;
  1244.     let sql2 = "select * from menu "+
  1245.                "limit "+currentPage+","+pageSize+" ";
  1246.     db.query({
  1247.       sql: sql2
  1248.     }, (err, results, fields) => {
  1249.       console.log(err);
  1250.       console.log("这是sql2",sql2)
  1251.       if(results!=''){
  1252.         results[0].backup3 = total;
  1253.       }
  1254.       res.send(results)
  1255.     })
  1256.   })
  1257. })
  1258. //====================================================================
  1259.  
  1260.  
  1261. module.exports = router

  数据库表详解

combo：套餐表
cp：套餐项目中间表
logs：日志表
project：项目表
menu：菜单表
menurole：菜单角色中间表
role：角色表
record：预约记录表
rotation：轮播图表
user：用户表
userrole：用户角色表

源码+项目部署

数据库还有源码一起都打包再下边的地址里了，下载开箱即用，跟springboot一样，嘻嘻嘻！

 源码地址：

链接：
提取码：7sn7

嗯嗯嗯......终于到了激动人心的时候了，我来帮你搞定一切，帝王般的服务你值得拥有，免费的哟，记得备注下：曹家的小仙女 / 小哥哥，微信：NIKE2022888

最后附上

一寸光阴一寸金，寸金难买寸光阴。请珍惜现在美好的青春，咱们一起努力奋斗，创造美好未来

拜托拜托！！！拜托拜托！！！拜托拜托！！！

​

网站建设定制开发 软件系统开发定制 定制软件开发 软件开发定制 定制app开发 app开发定制 app开发定制公司 电商商城定制开发 定制小程序开发 定制开发小程序 客户管理系统开发定制 定制网站 定制开发 crm开发定制 开发公司 小程序开发定制 定制软件 收款定制开发 企业网站定制开发 定制化开发 android系统定制开发 定制小程序开发费用 定制设计 专注app软件定制开发 软件开发定制定制 知名网站建设定制 软件定制开发供应商 应用系统定制开发 软件系统定制开发 企业管理系统定制开发 系统定制开发