using CY_API;
using Microsoft
.AspNetCore
.Http;
using Microsoft
.AspNetCore
.Mvc;
using Model
.cxbd;
using Model
.hospital_model;
using Model
.sys_model;
using System
.Reflection;
namespace APP_API
.Controllers
.hController
{
[Route("api/[controller]")]
[ApiController]
[Authorize]
[ApiExplorerSettings(GroupName = "base_data")]
public class stautsController : BaseApiController
{
public stautsController(IFreeSql fsql) : base(fsql) { }
/// <summary>
/// 下拉
/// </summary>
/// <param name="table_name"></param>
/// <param name="colum_name"></param>
/// <param name="search">名字关键字</param>
/// <param name="public_query">筛选条件，例如：status:active;type:admin</param>
/// <returns></returns>
[HttpGet("select_one")]
public IActionResult select(string table_name, string colum_name, string? search, int? take, string? public_query)
{
var
assembly =
Assembly.Load("sys_stauts");
var type =
assembly.GetTypes
().FirstOrDefault(e => e
.Name
.ToLower
() == table_name
.ToLower
());
if (type == null)
{
throw new ServiceException("表名
出错");
}
var enums = enum_list
.base_list
();
// 解析 public_query 字符串
var publicQueryList = string
.IsNullOrWhiteSpace(public_query)
? Array
.Empty<(string Key, string Value)>
()
: public_query
.Split(';', StringSplitOptions
.RemoveEmptyEntries)
.Select(pair =>
{
var parts = pair
.Split(':', 2, StringSplitOptions
.RemoveEmptyEntries);
if (parts
.Length != 2) throw new ServiceException($"Invalid public_query format: {pair}");
return (Key: parts[0], Value: parts[1]);
})
.ToArray
();
var list = CommandHelp
.GetSelect(type, enums, _fsql, colum_name, search, publicQueryList)
.ToList
();
if (take
.HasValue)
{
list = list
.Take(take
.Value)
.ToList
();
}
return Ok(list
.GetRetEnumerable
());
}
/// <summary>
/// 获取这个表格全部的下拉
/// </summary>
/// <param name="table_name"></param>
/// <param name="search"></param>
/// <returns></returns>
/// <exception cref="ServiceException"></exception>
[HttpGet("select_all")]
public IActionResult select(string table_name, string? search, int? take)
{
var
assembly =
Assembly.Load("v");
var type =
assembly.GetTypes
().FirstOrDefault(e => e
.Name
.ToLower
() == table_name
.ToLower
());
if (type == null)
{
throw new ServiceException("表名
出错");
}
var enums = enum_list
.base_list
();
if (take
.HasValue)
{
var data = CommandHelp
.GetSelect(type, enums, _fsql, search)
.Take(take
.Value)
.ToList
();
return Ok(data
.GetRetObject
());
}
else
{
var data = CommandHelp
.GetSelect(type, enums, _fsql, search)
.ToList
();
return Ok(data
.GetRetObject
());
}
}
/// <summary>
/// 新增
/// </summary>
/// <param name="m"></param>
/// <returns></returns>
[HttpPost]
public IActionResult Insert([FromBody] sys_stauts m)
{
_fsql
.Insert(m)
.Insert
();
return this
.ReturnOk
();
}
}
}
如何写状态表的下拉
本文探讨了在使用反射机制时遇到的Assembly.Load报错问题，并分析了两种常见原因：程序集名称错误及DLL文件缺失。提供了检查命名空间和管理DLL文件的具体解决方案。
扫一扫
231
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
