福州某火锅城餐饮收费系统查询代码_火锅店收费程序设计与实现的代码-优快云博客

本文链接：https://blog.youkuaiyun.com/cyz1980/article/details/563299

博客给出福州某火锅城餐饮收费系统的查询代码，包含消费说明、消费明细中间代码、消费明细及消费综合查询等代码，通过多个表的连接操作，如 consumption、emp、site 等表的 JOIN 操作，实现对餐饮消费信息的查询。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

福州某火锅城餐饮收费系统查询代码

SELECT consumption.consumptionid AS 消费单号,
      consumption.checkindatetime AS 日始时间, consumption.begindatetime AS 开台时间,
      consumption.enddatetime AS 结帐时间, consumption.number AS 用餐人数,
      emp.empdes AS 开台员工, emp.empdes AS 收银员, site.sitedesc AS 房台
FROM consumption INNER JOIN
      emp ON consumption.empid = emp.empid INNER JOIN
      site ON consumption.siteid = site.siteid   /*消费说明*/

SELECT consumptionid, menuid, SUM(menunumber) AS sum_menunumber
FROM (SELECT consumptionid, menuid, menunumber
        FROM consumptionmenu
        UNION ALL
        SELECT consumptionid, menuid, menunumber
        FROM consumption_addmenu) consume
GROUP BY consumptionid, menuid /*消费明细中间代码*/

SELECT group_consume.consumptionid AS 消费单号, group_consume.menuid,
      isnull(group_consume.sum_menunumber - consumptioncancel.menunumber,group_consume.sum_menunumber) AS 数量,
      menu.menudesc AS 名称, menu.price AS 原价, menu.discount AS 折扣
FROM (SELECT consumptionid, menuid, SUM(menunumber) AS sum_menunumber
        FROM (SELECT consumptionid, menuid, menunumber
                FROM consumptionmenu
                UNION ALL
                SELECT consumptionid, menuid, menunumber
                FROM consumption_addmenu) consume
        GROUP BY consumptionid, menuid) group_consume left outer JOIN
      consumptioncancel ON
      group_consume.consumptionid = consumptioncancel.consumptionid AND
      group_consume.menuid = consumptioncancel.menuid INNER JOIN
      menu ON group_consume.menuid = menu.menuid /*消费明细*/

SELECT 消费说明.房台, 消费说明.日始时间, 消费说明.消费单号, 消费说明.用餐人数,
      消费说明.开台员工, 消费说明.开台时间, 消费说明.结帐时间, 消费说明.收银员,
      消费明细.名称, 消费明细.数量, 消费明细.原价, 消费明细.折扣
FROM (SELECT group_consume.consumptionid AS 消费单号, group_consume.menuid,
      isnull(group_consume.sum_menunumber - consumptioncancel.menunumber,group_consume.sum_menunumber) AS 数量,
      menu.menudesc AS 名称, menu.price AS 原价, menu.discount AS 折扣
FROM (SELECT consumptionid, menuid, SUM(menunumber) AS sum_menunumber
        FROM (SELECT consumptionid, menuid, menunumber
                FROM consumptionmenu
                UNION ALL
                SELECT consumptionid, menuid, menunumber
                FROM consumption_addmenu) consume
        GROUP BY consumptionid, menuid) group_consume left outer JOIN
      consumptioncancel ON
      group_consume.consumptionid = consumptioncancel.consumptionid AND
      group_consume.menuid = consumptioncancel.menuid INNER JOIN
      menu ON group_consume.menuid = menu.menuid) 消费明细 INNER JOIN
          (SELECT consumption.consumptionid AS 消费单号,
               consumption.checkindatetime AS 日始时间,
               consumption.begindatetime AS 开台时间,
               consumption.enddatetime AS 结帐时间, consumption.number AS 用餐人数,
               emp.empdes AS 开台员工, emp.empdes AS 收银员,
               site.sitedesc AS 房台
         FROM consumption INNER JOIN
               emp ON consumption.empid = emp.empid INNER JOIN
               site ON consumption.siteid = site.siteid) 消费说明 ON
      消费明细.消费单号 = 消费说明.消费单号 /*消费综合查询*/