20250108接口新增

chenzx

2025-01-08 a967a0836b90661205ce5ad14ac42cd4281f67dd

20250108接口新增

 .vs/PolicyControl/FileContentIndex/4af96ed6-fd06-4d1c-9845-86bb1cd6244a.vsidx

Binary files differ

 .vs/PolicyControl/FileContentIndex/7704e269-6bb2-4f23-b2e2-bb060ab9f0d7.vsidx

Binary files differ

 .vs/PolicyControl/FileContentIndex/8cefa883-ddd3-476e-89df-1c5e176d70b8.vsidx

Binary files differ

 .vs/PolicyControl/FileContentIndex/cf4238b8-d8b7-4df6-8a20-b3d446af15be.vsidx

Binary files differ

 .vs/PolicyControl/FileContentIndex/d2363be2-5e27-4500-a2ba-0f0fc1a4a778.vsidx

Binary files differ

 GasolineBlend.BLL/MindRouterBLL.cs

New file
@@ -0,0 +1,27 @@
using GasolineBlend.DAL;
using GasolineBlend.Entity;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using static GasolineBlend.Entity.AgentDataPage;

namespace GasolineBlend.BLL
{
    public class MindRouterBLL
    {
        private MindRouterDAL _acc = new MindRouterDAL();

        /// <summary>
        /// 获取用益信托网记录数据
        /// </summary>
        /// <returns></returns>
        public List<MindRouterPage> GetMindRouterList(string Text)
        {
            return _acc.GetMindRouterList(Text);
        }


    }
}

 GasolineBlend.DAL/MindRouterDAL.cs

New file
@@ -0,0 +1,30 @@
using System;
using System.Collections.Generic;
using System.Data;
using System.Drawing.Printing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using CommonHelper;
using Dapper;
using GasolineBlend.Entity;
using Google.Protobuf.WellKnownTypes;
using Microsoft.Office.Interop.Excel;
using MySql.Data.MySqlClient;

namespace GasolineBlend.DAL
{
    public class MindRouterDAL : BaseMySQLDAL
    {

        public List<MindRouterPage> GetMindRouterList(string Text)
        {
            using (IDbConnection connection = new MySqlConnection(connectionString))
            {
                var sql = $"SELECT * from mindrouter where thinking in({Text})";
                return connection.Query<MindRouterPage>(sql).ToList();
            }
        }

    }
}

 GasolineBlend.Entity/MindRouterPage.cs

New file
@@ -0,0 +1,44 @@
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace GasolineBlend.Entity
{
    public class MindRouterPage
    {
        /// <summary>
        /// 序号
        /// </summary>
        public int Id { get; set; }
        /// <summary>
        /// 标题
        /// </summary>
        public string Thinking { get; set; }
        /// <summary>
        /// 提示词
        /// </summary>
        public string Class { get; set; }
        
        /// <summary>
        /// 权限
        /// </summary>
        public string Description { get; set; }
       

        public class PaginatedResult<T>
        {
            public List<T> Data { get; set; }
            public int TotalCount { get; set; }
            public int TotalPages { get; set; }

            public PaginatedResult(List<T> totalData, int totalCount, int totalPages)
            {
                Data = totalData;
                TotalCount = totalCount;
                TotalPages = totalPages;
            }
        }
    }
}

 GasolineBlend/Controllers/MindRouterController.cs

New file
@@ -0,0 +1,37 @@
using CommonHelper;
using GasolineBlend.BLL;
using GasolineBlend.Entity;
using System;
using System.Collections.Generic;
using System.IO;
using System.Linq;
using System.Web;
using System.Web.Mvc;


namespace GasolineBlend.Controllers
{
    public class MindRouterController : BaseController 
    {
        private MindRouterBLL _acc = new MindRouterBLL();
        /// <summary>
        ///获取地区智能体数据
        /// </summary>
        /// <param name="Keyword"></param>
        /// <returns></returns>
        [HttpPost]
         public ActionResult GetMindRouterList(string Text) 
        {
            try
            {
                var list = _acc.GetMindRouterList(Text);
                return SuccessNoShow(data: list);
            }
            catch (Exception e)
            {
                LogHelper.Write(Level.Error, "获取地区列表数据 GetMindRouterList", e, OperatorProvider.Instance.Current == null ? "GuestEx" : OperatorProvider.Instance.Current.LoginName);
                return Error();
            }
        }
    }
}