CREATE FUNCTION `getGroupCID`(pid varchar(5000)) RETURNS VARCHAR(5000)
DETERMINISTIC
BEGIN
DECLARE children VARCHAR(5000);
SELECT group_concat(id) INTO children FROM group_info WHERE FIND_IN_SET(group_info.pid, pid);
IF children ……
DELIMITER $$
CREATE FUNCTION `getParent`(n INT) RETURNS VARCHAR(255)
BEGIN
DECLARE parent VARCHAR(2555);
SELECT parent_id INTO parent FROM your_table WHERE id = n;
IF parent IS NOT NULL THEN
……
public class EfDbGet<TEntity> : FilterFunction<TEntity> where TEntity : class
{
public PmsContext _context;
public EfDbGet(PmsContext context)
{
_context = context;
}
//获取所有数据
public virtual List<TEntity> GetListAll()
{
IQueryable<TEntity>&n……