WMS供应商管理功能SupplierService_proxy.adddaterange-优快云博客

本文链接：https://blog.youkuaiyun.com/xdpcxq/article/details/134331818

该博客展示了供应商管理系统的实现，后端使用C#和SqlSugar，实现了供应商信息的增删改查、导入导出等功能；前端采用VUE框架，包含搜索、新增、修改、删除等操作，以及文件上传和模板下载功能，为供应商管理提供了完整解决方案。

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

using Infrastructure.App;
using Infrastructure.Attribute;
using Model.Dto.WarehouseManagement;
using Model.Page;
using Model.WarehouseManagement;
using Repository;
using Service.Interface.WarehouseManagement;
using Microsoft.AspNetCore.Hosting;
using SqlSugar;

namespace GD.Service.WarehouseManagement
{
[AppService(ServiceType = typeof(ISupplierService), ServiceLifetime = LifeTime.Transient)]
public class SupplierService : BaseService<Supplier>, ISupplierService
{
public long AddSupplier(Supplier supplier, string userName)
{
supplier.Create_by = userName;
supplier.Create_time = DateTime.Now;
return InsertReturnBigIdentity(supplier);
}

public long DeleteBySupplierId(long supplierId)
{
return Delete(supplierId);
}

public (string, string) DownloadImportTemplate()
{
IWebHostEnvironment webHostEnvironment = (IWebHostEnvironment)App.ServiceProvider.GetService(typeof(IWebHostEnvironment));
string sFileName = "供应商信息.xlsx";
string fullPath = Path.Combine(webHostEnvironment.WebRootPath, "ImportTemplate", sFileName);

return (sFileName, fullPath);
}

public long EditSupplier(Supplier supplier, string userName)
{
supplier.Update_by = userName;
supplier.Update_time = DateTime.Now;
return Update(supplier);
}

public PagedInfo<Supplier> GetAllSupplier(SupplierQueryDto supplierQueryDto)
{
var expression = Expressionable.Create<Supplier>()
.AndIF(!string.IsNullOrEmpty(supplierQueryDto.SupplierName), supplier => supplier.SupplierName.Contains(supplierQueryDto.SupplierName))
.AndIF(!string.IsNullOrEmpty(supplierQueryDto.Manager), supplier => supplier.Manager.Contains(supplierQueryDto.Manager))
.AndIF(!string.IsNullOrEmpty(supplierQueryDto.ContactTel), supplier => supplier.ContactTel.Contains(supplierQueryDto.ContactTel))
.AndIF(supplierQueryDto.BeginTime != DateTime.MinValue && supplierQueryDto.BeginTime != null, exp => exp.Create_time >= supplierQueryDto.BeginTime)
.AndIF(supplierQueryDto.EndTime != DateTime.MaxValue && supplierQueryDto.EndTime != null, exp => exp.Create_time <= supplierQueryDto.EndTime);

return Queryable()
.Where(expression.ToExpression())
.ToPage(supplierQueryDto);
}

public List<Supplier> GetAllSupplier()
{
return Queryable()
.ToList();
}

public Supplier GetSupplierById(long supplierId)
{
return Queryable()
.Where(supplier => supplier.SupplierId == supplierId)
.Single();
}

public (string, object) ImportSupplers(List<Supplier> suppliers)
{
var storage = Context.Storageable(suppliers)
.SplitUpdate(it => it.Any()) //存在更新
.SplitInsert(it => true) //否则插入（更新优先级大于插入）
.SplitError(it => string.IsNullOrEmpty(it.Item.SupplierName), "供应商名称不能为空")
.SplitError(it => string.IsNullOrEmpty(it.Item.Manager), "负责人不能为空")
.SplitError(it => string.IsNullOrEmpty(it.Item.Manager), "联系方式不能为空")
.WhereColumns(it => it.SupplierName) //如果不是主键可以这样实现（多字段it=>new{it.x1,it.x2}）
.ToStorage();

storage.AsInsertable.ExecuteCommand(); //插入可插入部分

string msg = string.Format(" 插入{0} 更新{1} 错误{2} 不计算{3} 删除{4} 总共{5}",
storage.InsertList.Count,
storage.UpdateList.Count,
storage.ErrorList.Count,
storage.IgnoreList.Count,
storage.DeleteList.Count,
storage.TotalList.Count);
//输出统计
Console.WriteLine(msg);

//输出错误信息
foreach (var item in storage.ErrorList)
{
Console.WriteLine("userName为" + item.Item.SupplierName + " : " + item.StorageMessage);
}

return (msg, storage.ErrorList);
}

public bool IsOtherUse(long supplierId)
{
throw new NotImplementedException();
}
}
}

前端VUE

<el-row :gutter="10">
<el-col :span="1.5">
<el-button type="primary" plain icon="plus" @click="handleAdd">新增</el-button>
</el-col>
<el-col :span="1.5">
<el-button type="success" plain icon="upload" @click="handleImport">导入</el-button>
</el-col>
<el-col :span="1.5">
<el-button type="warning" plain icon="download" @click="handleExport">导出</el-button>
</el-col>
<right-toolbar v-model:showSearch="showSearch" @queryTable="getList" :columns="columns"></right-toolbar>
</el-row>

<el-table v-loading="loading" :data="supplierList" highlight-current-row>
<el-table-column label="供应商名称" prop="supplierName" align="center" v-if="columns.showColumn('supplierName')" />
<el-table-column label="所在城市" prop="city" align="center" v-if="columns.showColumn('city')" />
<el-table-column label="详细地址" prop="address" align="center" v-if="columns.showColumn('address')" />
<el-table-column label="负责人" prop="manager" align="center" v-if="columns.showColumn('manager')" />
<el-table-column label="Email" prop="email" align="center" v-if="columns.showColumn('email')" />
<el-table-column label="联系方式" prop="contactTel" align="center" v-if="columns.showColumn('contactTel')" />
<el-table-column label="创建人" prop="createBy" align="center" v-if="columns.showColumn('createBy')" />
<el-table-column label="创建时间" prop="createTime" align="center" width="170"
v-if="columns.showColumn('createTime')" />
<el-table-column label="最后更新时间" prop="updateTime" align="center" width="170"
v-if="columns.showColumn('updateTime')" />

<el-table-column label="操作" align="center" width="120" v-if="columns.showColumn('operate')">
<template #default="scope">
<div>
<el-button text icon="edit" title="编辑" @click.stop="handleUpdate(scope.row)">
</el-button>
<el-button text icon="delete" title="删除" @click.stop="handleDelete(scope.row)">
</el-button>
</div>
</template>
</el-table-column>
</el-table>

<pagination v-show="total > 0" :total="total" v-model:page="queryParams.pageNum" v-model:limit="queryParams.pageSize"
@pagination="getList" />

<el-dialog :title="title" v-model="open" width="500px" :show-close="false" :draggable="true">
<el-form :model="form" :rules="rules" ref="supplierRef" label-width="100px">
<el-form-item label="供应商名称" prop="supplierName">
<el-input v-model="form.supplierName" placeholder="请输入供应商名称" />
</el-form-item>
<el-form-item label="所在城市" prop="city">
<el-input v-model="form.city" placeholder="请输入所在城市" />
</el-form-item>
<el-form-item label="详细地址" prop="address">
<el-input v-model="form.address" placeholder="请输入详细地址" />
</el-form-item>
<el-form-item label="负责人" prop="manager">
<el-input v-model="form.manager" placeholder="请输入负责人" />
</el-form-item>
<el-form-item label="Email" prop="email">
<el-input v-model="form.email" placeholder="请输入Email" />
</el-form-item>
<el-form-item label="联系方式" prop="contactTel">
<el-input v-model="form.contactTel" placeholder="请输入联系方式" />
</el-form-item>
</el-form>

<el-dialog :title="upload.title" v-model="upload.open" width="500px" :show-close="false" :draggable="true">
<el-upload name="file" ref="uploadRef" :limit="1" accept=".xlsx,.xls" :headers="upload.headers" :action="upload.url"
:on-progress="handleFileUploadProgress" :on-success="handleFileSuccess" :auto-upload="false" drag>
<el-icon class="el-icon--upload">
<upload-filled />
</el-icon>
<div class="el-upload__text">将文件拖到此处，或<em>点击上传</em></div>
<template #tip>
<div class="el-upload__tip text-center">
<span>仅允许导入xls、xlsx格式文件。</span>
<el-link type="primary" :underline="false" style="font-size: 12px; vertical-align: baseline"
@click="importTemplate">下载模板</el-link>
</div>
</template>
</el-upload>

/**
* 重置操作表单
*/
function reset() {
form.value = {
supplierId: undefined,
supplierName: undefined,
city: undefined,
address: undefined,
manager: undefined,
email: undefined,
contactTel: undefined,
};
proxy.resetForm('supplierRef')
}

/**
* 获取列表
*/
function getList() {
loading.value = true;
let params = proxy.addDateRange(queryParams.value, dateRange.value);
getAll(params).then(res => {
loading.value = false
supplierList.value = res.data.result
total.value = res.data.totalNum
})
}

/**
* 搜索按钮操作
*/
function handleQuery() {
queryParams.pageNum = 1;
getList();
}

/**
* 重置按钮操作
*/
function resetQuery() {
dateRange.value = [];
proxy.resetForm("queryRef");
handleQuery();
}

/**
* 新增按钮操作
*/
function handleAdd() {
reset()
open.value = true;
title.value = "新增供应商信息";
}

/**
* 导入按钮操作
*/
function handleImport() {
upload.title = "供应商导入";
upload.open = true;
}

/**
* 导出按钮操作
*/
function handleExport() {
proxy
.$modal
.confirm('是否确认导出所有供应商数据项?', '警告', {
confirmButtonText: '确定',
cancelButtonText: '取消',
type: 'warning'
})
.then(async () => {
await exportSupplier()
})
}

/**
* 提交按钮
*/
function submitForm() {
proxy.$refs["supplierRef"].validate((valid) => {
if (valid) {
if (form.value.supplierId != undefined) {
editSupplierInfo(form.value.supplierId, form.value).then(res => {
proxy.$modal.msgSuccess('修改成功')
open.value = false
getList()
})
} else {
addSupplierInfo(form.value).then(res => {
proxy.$modal.msgSuccess('新增成功')
open.value = false
getList()
})
}
}
});
}

/**
* 取消按钮
*/
function cancel() {
reset();
open.value = false;
}

/**
* 修改按钮操作
* @param {行数据} row
*/
function handleUpdate(row) {
reset()
const supplierId = row.supplierId
getSupplierInfo(supplierId).then(response => {
form.value = response.data
open.value = true
title.value = '修改供应商'
})
open.value = true
}

/**
* 删除按钮操作
* @param {行数据} row
*/
function handleDelete(row) {
const supplierId = row.supplierId
proxy
.$modal
.confirm('是否确认删除用户编号为"' + row.supplierName + '"的数据项？')
.then(() => {
return deleteById(supplierId)
})
.then(() => {
getList()
proxy.$modal.msgSuccess('删除成功')
})
.catch(() => { })
}

/**
* 文件上传中处理
* @param {事件} event
* @param {文件} file
* @param {文件列表} fileList
*/
function handleFileUploadProgress(event, file, fileList) {
upload.isUploading = true;
}

/**
* 文件上传成功处理
* @param {响应内容} response
* @param {文件} file
* @param {文件列表} fileList
*/
function handleFileSuccess(response, file, fileList) {
const { code, msg, data } = response;
upload.open = false;
upload.isUploading = false;
proxy.$refs["uploadRef"].clearFiles();
proxy
.$modal
.confirm('导入结果:' + data.item1)
.then(() => {
getList();
})
}