基于net+vue+mysql的小型超市商品管理系统

项目介绍

小型超市商品管理系统是一款针对小型超市日常运营需求设计的软件解决方案。该系统主要内容有商品类别管理、商品库存管理、入库信息管理、销售订单管理等功能，实现了对超市商品的全面管理。它简化了商品管理流程，提高了工作效率，有助于超市管理者实时掌握商品动态，优化库存结构，降低运营成本。

本论文将总体分析小型超市商品需求，再从不同角度分析具体功能需求，运用Java相关技术，采用MySQL数据库，讨论如何设计并实现一个小型超市商品管理系统。分析和设计主要从管理员、采购员和销售员三个角色上展开研究，介绍了各个功能模块的实现，并通过系统测试对小型超市商品管理系统进行调试，将各个功能的测试结果与期望设计进行逐一比对，找出BUG和欠缺之处，从而进一步优化改进系统。

本套基于Java的小型超市商品管理系统的设计与实现，希望能让用户通过互联网得到方便而快捷的系统管理体验，在此基础的同时提高工作效益。

开发环境

编程语言：Net
数据库 ：Mysql
系统架构：B/S
前端技术：Vue
运行工具：Visual Studio
支持定做：java/php/python/android/小程序vue/爬虫/c#/asp.net

系统截图

核心代码

using SqlSugar;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;
using Microsoft.AspNetCore.Authorization;
using Microsoft.AspNetCore.Mvc;
using Xiezn.Core.Business.Services;
using Xiezn.Core.Common.Helpers;
using Xiezn.Core.Models;
using Xiezn.Core.Models.DbModel;
using Newtonsoft.Json.Linq;
using System.Net.Mail;
using System.Text;
using System.Net;
using NETCore.MailKit.Core;
using Microsoft.AspNetCore.Http;
using System.IO;
using Microsoft.AspNetCore.Hosting;
using NPOI.SS.UserModel;
using NPOI.XSSF.UserModel;
using NPOI.HSSF.UserModel;
using Alipay.AopSdk.Core;
using Xiezn.Core.Models.ConfModel;
using Alipay.AopSdk.Core.Domain;
using Alipay.AopSdk.Core.Request;
using AlibabaCloud.SDK.Dysmsapi20170525.Models;
using Xiezn.Core.Models.ViewModel;
using Newtonsoft.Json;
using System.Net.Http;
using System.Web;
using StackExchange.Redis;


namespace Xiezn.Core.Controllers
{
   
    /// <summary>
    /// 商品类别相关接口
    /// </summary>
    [Route("[controller]/[action]")]
    public class ShangpinleibieController : Controller
    {
   
        private readonly IHostingEnvironment _hostingEnvironment;
        private readonly string _savePath;
        private readonly long _uid;
        private readonly string _role;
        private readonly ShangpinleibieService _bll;
        private readonly IEmailService _EmailService;
        private readonly ConfigService _configBLL;

        /// <summary>
        /// 构造函数
        /// </summary>
        public ShangpinleibieController(IHostingEnvironment hostingEnvironment, IEmailService emailService)
        {
   
            try
            {
   
                _hostingEnvironment = hostingEnvironment;
                _savePath = _hostingEnvironment.WebRootPath + Path.DirectorySeparatorChar + ConfigHelper.GetConfig("SchemaName") + Path.DirectorySeparatorChar + "upload" + Path.DirectorySeparatorChar;
                if (CacheHelper.TokenModel != null)
                {
   
                    _uid = CacheHelper.TokenModel.Uid;
                    _role = CacheHelper.TokenModel.Role;
                }

                _EmailService = emailService;
                _configBLL = new ConfigService();
            }
            catch
            {
   
                _uid = 0;
                _role = "游客";
            }

            _hostingEnvironment = hostingEnvironment;
            _savePath = _hostingEnvironment.WebRootPath + Path.DirectorySeparatorChar + ConfigHelper.GetConfig("SchemaName") + Path.DirectorySeparatorChar + "upload" + Path.DirectorySeparatorChar;
            _bll = new ShangpinleibieService();
        }


        /// <summary>
        /// 分页接口
        /// </summary>
        /// <param name="page">当前页</param>
        /// <param name="limit">每页记录的长度</param>
        /// <param name="sort">排序字段</param>
        /// <param name="order">升序（默认asc）</param>
        /// <returns></returns>
        [HttpGet]
        [Authorize(Roles = "Admin,Client")]
        public JsonResult Page(int page = 1, int limit = 10, string sort = "id", string order = "asc")
        {
   
            try
            {
   
            	List<IConditionalModel> conModels = new List<IConditionalModel>();
                List<String> jujianList = new List<string>();

                var shangpinleibie = HttpContext.Request.Query["shangpinleibie"].ToString();
                if (!string.IsNullOrEmpty(shangpinleibie))
                {
   
                    if (shangpinleibie.Contains("%"))
                    {
   
                        conModels.Add(new ConditionalModel() {
    FieldName = "shangpinleibie", ConditionalType = ConditionalType.Like, FieldValue = shangpinleibie });
                    }
                    else
                    {
   
                        conModels.Add(new ConditionalModel() {
    FieldName = "shangpinleibie", ConditionalType = ConditionalType.Equal, FieldValue = shangpinleibie });
                    }
                }

                foreach (var queryString in HttpContext.Request.Query)
                {
   
                    var key = queryString.Key;
                    var values = queryString