C#TMS系统学习（BaseCity页面） BaseCity （Base C#TMS 系统学习 City TMS 页面 C#
C#TMS系统代码-基础页面BaseCity学习
本人纯新手，刚进公司跟领导报道，我说我是java全栈，他问我会不会C#，我说大学学过，他说这个TMS系统就给你来管了。外包已经把代码给我了，这几天先把增删改查的代码背一下，说不定后面就要赶鸭子上架了
Service页面
//using => import 导入
using Microsoft.AspNetCore.Mvc;
using SHZY.BaseData.Entitys.TMS.Dto.City;
using SHZY.BaseData.Interfaces.TMS;
......
//声明命名空间
namespace SHZY.BaseData.TMS {
//接口调用记录
[ApiDescriptionSettings(Tag = "BaseData", Name = "TmsBaseCity", Order = 200)]
//路由匹配
[Route("api/TMS/BaseData/[controller]")]
// : => implements 实现多接口
public class TmsBaseCityService : ITmsBaseCityService, IDynamicApiController, ITransient {
//Dao
private readonly ISqlSugarRepository<TmsBaseCityEntity> _repository;//city的各种方法
private readonly ITenant _db;//数据库事务
private readonly IUserManager _userManager;//用户管理
......
//初始化新实例
public TmsBaseCityService(
ISqlSugarRepository<TmsBaseCityEntity> tmsBaseCityRepository,
ISqlSugarClient context,
IUserManager userManager,
ISqlSugarRepository<TmsBaseCityEntity> cityRepository) {
_repository = tmsBaseCityRepository;
_db = context.AsTenant();
_userManager = userManager;
}
//各种方法
......
}
}
查询单个City
//get请求，id做参数
[HttpGet("{id}")]
//async-异步请求? Task-等待任务 dynamic-可变类型
public async Task<dynamic> GetInfo(string id)
{
//await-等待这行完成 FirstOrDefaultAsync-返回结果集第一个,后面匿名函数查询规则id匹配 Adapt-转类型
//链式写法，我不知道后面怎么打断点调试
return (await _repository.FirstOrDefaultAsync(x => x.Id == id)).Adapt<TmsBaseCityInfoOutput>();
}
查询City分页List
[HttpGet("")]
//[FromQuery]-请求查询字符串参数,JSON格式(一般用于get)
public async Task<dynamic> GetList([FromQuery] TmsBaseCityListQueryInput input)
{
//开查
var queryable = _repository.Context.Queryable<TmsBaseCityEntity>()
//判断查询参数是否为空，不为空用Contains判断是否包含(有多个也能满足)
.WhereIF(!string.IsNullOrEmpty(input.name), it => it.Name.Contains(input.name))
.......
//直接where里面的条件
.Where(it => it.DeleteMark == null)
//把结果集数据转成要输出的类
//似乎每种业务场景都会有变种类,这个是查询List的输出类 这是TMS系统的格式要求？
.Select(it => new TmsBaseCityListOutput
{
id = it.Id,
countryNo = it.CountryNo,
......
})
//两个或多个表的行合并到一个结果集中
.MergeTable();
//判断排序，为什么不用OrderByIF连着写算了
if (!string.IsNullOrEmpty(input.sidx))
{
queryable.OrderBy(input.sidx + " " + input.sort);
}
else
{
queryable.OrderBy(it => it.id);
}
//带上页数和条数转分页 如果不分页直接ToListAsync()返回
var data = await queryable.ToPagedListAsync(input.currentPage, input.pageSize);
//转PageResult分页类型
return PageResult<TmsBaseCityListOutput>.SqlSugarPageResult(data);
}
新增City
[HttpPost("")]
//[FromBody]-请求正文,JSON格式(一般用于post)
public async Task Create([FromBody] TmsBaseCityCrInput input)
{
//AnyAsync判断有没有满足条件的结果(即数据库已有要新增的对象)
if (await _repository.AnyAsync(it => it.CountryNo == input.countryNo && it.ProvinceNo == input.provinceNo && it.ProvinceName == input.provinceName && it.No == input.no && it.Name == input.name && it.DeleteMark == null))
//抛出错误,ErrorCode是枚举,里面有各种报错信息
throw Oops.Oh(ErrorCode.COM1004);
var entity = input.Adapt<TmsBaseCityEntity>();
//Insertable-插入数据 IgnoreColumns-忽略为null的列 CallEntityMethod-在插入数据库之前，对实体类的某个方法进行调用 ExecuteCommandAsync-执行
var isOk = await _repository.Context.Insertable(entity).IgnoreColumns(ignoreNullColumn: true).CallEntityMethod(it => it.Creator()).ExecuteCommandAsync();
//如果isOk不大于0，抛出错误
if (!(isOk > 0)) throw Oops.Oh(ErrorCode.COM1000);
}
更新City
//put请求，id做参
[HttpPut("{id}")]
public async Task Update(string id, [FromBody] TmsBaseCityUpInput input)
{
//AnyAsync判断有没有满足条件的结果(数据库id不同其他数据相同)
if (await _repository.AnyAsync(it => it.CountryNo == input.countryNo && it.ProvinceNo == input.provinceNo && it.ProvinceName == input.provinceName && it.No == input.no && it.Name == input.name && it.DeleteMark == null && it.Id != input.id))
throw Oops.Oh(ErrorCode.COM1004);
//Adapt转一下类型
var entity = input.Adapt<TmsBaseCityEntity>();
//Updateable-修改数据 UpdateColumns-修改那些数据列 ExecuteCommandAsync-执行
var isOk = await _repository.Context.Updateable(entity).UpdateColumns(it => new
{
it.CountryNo,
......
}).ExecuteCommandAsync();
if (!(isOk > 0)) throw Oops.Oh(ErrorCode.COM1001);
}
删除City
//Delete请求
[HttpDelete("{id}")]
public async Task Delete(string id)
{
//没有删掉，只是更改DeleteMark，这里的写法类似写sql了
//ExecuteCommandHasChangeAsync-返回一个布尔值表示是否有变更
var isOk = await _repository.Context.Updateable<TmsBaseCityEntity>().SetColumns(it => new TmsBaseCityEntity()
{
DeleteTime = DateTime.Now,
DeleteMark = 1,
DeleteUserId = _userManager.UserId
}).Where(it => it.Id.Equals(id)).ExecuteCommandHasChangeAsync();
if (!isOk) throw Oops.Oh(ErrorCode.COM1002);
}
批量删除City
//这里为啥不用Delete?
[HttpPost("batchRemove")]
public async Task BatchRemove([FromBody] List<string> ids)
{
//In(it => it.Id, ids) 把数据全部先查出来
var entitys = await _repository.Context.Queryable<TmsBaseCityEntity>().In(it => it.Id, ids).ToListAsync();
if (entitys.Count > 0)
{
try
{
//开启事务
_db.BeginTran();
//批量删除城市信息维护，这边用的Where(it => ids.Contains(it.Id))
var isOk = await _repository.Context.Updateable<TmsBaseCityEntity>().SetColumns(it => new TmsBaseCityEntity()
{
DeleteTime = DateTime.Now,
DeleteMark = 1,
DeleteUserId = _userManager.UserId
}).Where(it => ids.Contains(it.Id)).ExecuteCommandHasChangeAsync();
//关闭事务
_db.CommitTran();
}
catch (Exception)
{
//回滚事务
_db.RollbackTran();
throw Oops.Oh(ErrorCode.COM1002);
}
}
}
导出
[HttpGet("Actions/Export")]
public async Task<dynamic> Export([FromQuery] TmsBaseCityListQueryInput input)
{
var exportData = new List<TmsBaseCityListOutput>();
//导出全部或者当前数据
if (input.dataType == 0)
//创建粘土对象转List<TmsBaseCityListOutput>
exportData = Clay.Object(await GetList(input)).Solidify<PageResult<TmsBaseCityListOutput>>().list;
else
exportData = await GetNoPagingList(input);
//导出数据列，JSON格式字符串直接ToList<ParamsModel>()手工转
List<ParamsModel> paramList = "[{\"value\":\"国家代码\",\"field\":\"countryNo\"},{\"value\":\"省份代码\",\"field\":\"provinceNo\"},{\"value\":\"省份名称\",\"field\":\"provinceName\"},{\"value\":\"城市代码\",\"field\":\"no\"},{\"value\":\"城市名称\",\"field\":\"name\"},{\"value\":\"有效标志\",\"field\":\"enabledMark\"},]".ToList<ParamsModel>();
//配置ExcelConfig
ExcelConfig excelconfig = new ExcelConfig();
excelconfig.FileName = "城市信息维护.xls";
excelconfig.HeadFont = "微软雅黑";
excelconfig.HeadPoint = 10;
excelconfig.IsAllSizeColumn = true;
excelconfig.ColumnModel = new List<ExcelColumnModel>();
//selectKey=>用户选中的数据列
foreach (var item in input.selectKey.Split(',').ToList())
{
var isExist = paramList.Find(p => p.field == item);
//找到之后加入ColumnModel
if (isExist != null)
excelconfig.ColumnModel.Add(new ExcelColumnModel() { Column = isExist.field, ExcelColumn = isExist.value });
}
//临时文件储存路径
var addPath = FileVariable.TemporaryFilePath + excelconfig.FileName;
//导出
ExcelExportHelper<TmsBaseCityListOutput>.Export(exportData, excelconfig, addPath);
//excel文件路径
var fileName = _userManager.UserId + "|" + addPath + "|xls";
return new
{
//文件名
name = excelconfig.FileName,
//加密
url = "/api/File/Download?encryption=" + DESCEncryption.Encrypt(fileName, "SHZY")
};
}