xxt.red 校校通

HttpClient 远程post，获取数据并对数组进行处理

Fri, 24 Jul 2026 15:16:13 +0800

using System.Text.Json;

namespace xxtsoft.Web.Entry.Pages.sysadmins.ansyc
{
    public class teacherModel : PageModel
    {
       
        public async Task<IActionResult> OnGetAsync()
        {

          

            var url = "https://xxx.com/sdata/rest/service/dataapi/rest/0e522301-5fa3-43e2-bff3-a73cc2943305";

            var body = new
            {
                key = "39e8109cc",
                GH= ""

            };

            var json =System.Text.Json.JsonSerializer.Serialize(body);

            using var client = new HttpClient();
            var content = new StringContent(json, Encoding.UTF8, "application/json");

            var response = await client.PostAsync(url, content);
            var result = await response.Content.ReadAsStringAsync();

            using var doc = JsonDocument.Parse(result);

            var resultArray = doc.RootElement.GetProperty("result");


            //for (int i = 0; i < resultArray.GetArrayLength(); i++)
            //{
            //    string DEPT_ID = resultArray[i].GetProperty("DEPT_ID").GetString();
            //    string GH = resultArray[i].GetProperty("GH").GetString();
            //    string DEPT_NAME = resultArray[i].GetProperty("DEPT_NAME").GetString();
            //    string XM = resultArray[i].GetProperty("XM").GetString();
            //    string USER_TYPE = resultArray[i].GetProperty("USER_TYPE").GetString();

            //    string XBMC = "";
            //    if (resultArray[i].TryGetProperty("XBMC", out var xbmcElement))
            //    {
            //        XBMC = xbmcElement.GetString() ?? "";
            //    }

            //    //Log.Information($"部门编码{DEPT_ID}工号{GH}部门名称{DEPT_NAME}姓名{XM}人员类型{USER_TYPE}性别名称{XBMC}");


            //}

            foreach (var item in resultArray.EnumerateArray())
            {
                string DEPT_ID = GetString(item, "DEPT_ID");
                string GH = GetString(item, "GH");
                string DEPT_NAME = GetString(item, "DEPT_NAME");
                string XM = GetString(item, "XM");
                string USER_TYPE = GetString(item, "USER_TYPE");
                string XBMC = GetString(item, "XBMC");

                Log.Information($"部门编码{DEPT_ID} 工号{GH} 部门名称{DEPT_NAME} 姓名{XM} 人员类型{USER_TYPE} 性别名称{XBMC}");
            }

            return Content(result);

        }

        private static string GetString(JsonElement element, string propertyName)
        {
            return element.TryGetProperty(propertyName, out var value)
                ? value.GetString() ?? ""
                : "";
        }


    }

}

asp.net core razor和api 都同时支持登录身份判断属性写法

Tue, 21 Jul 2026 11:08:15 +0800

using Microsoft.AspNetCore.Mvc.Filters;namespace xxtsoft.Application.Filters{
    /// <summary>
    /// 登录验证特性
    /// 同时支持：
    /// 1. Furion DynamicApi / MVC Controller
    /// 2. Razor Page
    /// </summary>
    [AttributeUsage(AttributeTargets.Class | AttributeTargets.Method)]
    public class ApiAuthorizeAttribute : Attribute,        IAsyncActionFilter,        IAsyncPageFilter
    {

        /// <summary>
        /// 检查当前用户是否登录
        /// 这里使用 Session 判断
        /// </summary>
        private bool CheckLogin(HttpContext context)
        {
            var session = context.Session;            var teaid = session.GetString("teaid");            var teaxm = session.GetString("teaxm");            var teabm = session.GetString("teabm");            // 三个关键字段都存在，认为登录有效
            return !string.IsNullOrEmpty(teaid)
                && !string.IsNullOrEmpty(teaxm)
                && !string.IsNullOrEmpty(teabm);        }



        /// <summary>
        /// API / Furion DynamicApi 请求验证
        /// 例如：
        /// [ApiAuthorize]
        /// public class HbExtService : IDynamicApiController
        /// </summary>
        public async Task OnActionExecutionAsync(
            ActionExecutingContext context,            ActionExecutionDelegate next)
        {

            // 未登录
            if (!CheckLogin(context.HttpContext))
            {

                // API 返回 JSON
                context.Result = new JsonResult(new
                {
                    code = 401,
                    msg = "登录已失效，请重新登录"
                });                return;            }


            // 登录有效，继续执行接口方法
            await next();        }

        /// <summary>
        /// Razor Page 请求验证
        /// 例如：
        /// [ApiAuthorize]
        /// public class indexModel : PageModel
        /// </summary>
        public async Task OnPageHandlerExecutionAsync(
            PageHandlerExecutingContext context,            PageHandlerExecutionDelegate next)
        {


            // 未登录
            if (!CheckLogin(context.HttpContext))
            {

                // Razor 页面跳转到登录页
                context.Result = new RedirectToPageResult("/hb/login");                return;            }


            // 登录有效，继续执行 OnGet / OnPost
            await next();        }




        /// <summary>
        /// Razor Page Handler选择阶段
        /// 必须实现，但这里不需要处理
        /// </summary>
        public Task OnPageHandlerSelectionAsync(
            PageHandlerSelectedContext context)
        {
            return Task.CompletedTask;        }
    }}

用法：

[ApiAuthorize]public class indexModel : PageModel{

 [ApiAuthorize]
 public class HbExtService : IDynamicApiController, ITransient
 {

sqlite数据库备份

Fri, 17 Jul 2026 16:21:56 +0800

  public IActionResult OnPostBf()
  {
      var db = App.GetService<SqlSugar.ISqlSugarClient>();      var connStr = db.CurrentConnectionConfig.ConnectionString;      var builder = new SqliteConnectionStringBuilder(connStr);      // 原数据库
      var dbFile = builder.DataSource;      //数据库名称
      var dbName = Path.GetFileName(dbFile);      // 数据库密码                       
      var password = builder.Password;      var dbFullPath = Path.Combine(
          App.WebHostEnvironment.ContentRootPath,          dbFile.Replace('/', Path.DirectorySeparatorChar));      // 备份文件
      var backupDir = Path.Combine(
          App.WebHostEnvironment.ContentRootPath,          "App_Data",          "Backup");      Directory.CreateDirectory(backupDir);      var backupFile = Path.Combine(
          backupDir,          $"{Path.GetFileNameWithoutExtension(dbName)}_{DateTime.Now:yyyyMMddHHmmss}.db");      // 源数据库
      var sourceBuilder = new SqliteConnectionStringBuilder()
      {
          DataSource = dbFullPath,
          Password = password,
          Mode = SqliteOpenMode.ReadWrite,
          Cache = SqliteCacheMode.Shared      };      // 目标数据库
      var destBuilder = new SqliteConnectionStringBuilder()
      {
          DataSource = backupFile,
          Password = password
      };      // 创建备份
      using (var source = new SqliteConnection(sourceBuilder.ConnectionString))
      using (var dest = new SqliteConnection(destBuilder.ConnectionString))
      {
          source.Open();          dest.Open();          source.BackupDatabase(dest);          // 强制关闭连接
          dest.Close();          source.Close();      }


      // 清理 SQLite 连接池
      SqliteConnection.ClearAllPools();      // 等待 Windows 释放文件锁
      GC.Collect();      GC.WaitForPendingFinalizers();      // 给 SQLCipher 一点释放时间
      System.Threading.Thread.Sleep(500);      // 下载
      var fileStream = new FileStream(
          backupFile,          FileMode.Open,          FileAccess.Read,          FileShare.ReadWrite,          bufferSize: 1024 * 64,          useAsync: true);      return File(
          fileStream,          "application/octet-stream",          Path.GetFileName(backupFile));  }

element 调用接口返回json中的data-bs-toggle="tooltip" data-bs-title="查阅"

Thu, 16 Jul 2026 15:48:15 +0800

<el-table ref="tableRef">

<el-table-column prop="files" label="操作" :fixed="isMobile ? false : 'right'" min-width="100">
    <template #default="{ row }">
        <span v-html="row.files"></span>
    </template></el-table-column>

const App = {

    data() {
        return {
        }
    },


    mounted() {

        this.initTooltip();

    },


    updated() {

        this.initTooltip();

    },


    methods: {

        initTooltip() {

            document
            .querySelectorAll('[data-bs-toggle="tooltip"]')
            .forEach(el => {

                bootstrap.Tooltip.getOrCreateInstance(el);

            });

        }

    }

};

StringBuilder 简单写法

Thu, 16 Jul 2026 07:47:47 +0800

   public StringBuilder Sb { get; set; } = new();

element 显示后端返回的html json格式

Wed, 15 Jul 2026 21:24:06 +0800

"data": [
        {
            "files": "<a href=\"#\">查看</a>",

<el-table-column label="文件地址" min-width="150">
    <template #default="{ row }">
        <span v-html="row.files"></span>
    </template>
</el-table-column>

element el-switch 默认选择

Wed, 15 Jul 2026 16:40:37 +0800

   mounted() {
       if (this.form.activity == 0) {
           this.form.activity = 1;       }

element puls select 表单验证

Fri, 03 Jul 2026 16:21:03 +0800

后端：

 public record OptionItem(string Label, string Value);
 public List<OptionItem> _datatype { get; set; }

   public async Task<IActionResult> OnGetAsync()
  { 
   #region select下拉框数据
    _datatype = new List<OptionItem>
    {
        new("类型一", "1"),
        new("类型二", "2")
    };
    #endregion
    return Page();

}

前端：

<div class="mt-3 xxt-box">

    <form id="form1" method="post">

        <div class="row mb-3">
            <label class="col-md-2 col-form-label text-md-end">
                英文列名：
                <span class="text-danger">*</span>
            </label>
            <div class="col-md-10">
                <el-input v-model="form.columnname"
                          name="columnname"
                          id="columnname"
                          placeholder="请输入"
                          size="large"
                          clearable
                          required>
                </el-input>
            </div>
        </div>
        <div class="row mb-3">
            <label class="col-md-2 col-form-label text-md-end">
                中文描述：
                <span class="text-danger">*</span>
            </label>
            <div class="col-md-10">
                <el-input v-model="form.columndesc"
                          name="columndesc"
                          id="columndesc"
                          placeholder="请输入"
                          size="large"
                          clearable
                          required>
                </el-input>

               
            </div>
        </div>

        <div class="row mb-3">
            <label class="col-md-2 col-form-label text-md-end">
                数据类型 <span class="text-danger">*</span>
            </label>
            <div class="col-md-10">
                <el-select v-model="form.datatype"                           
                            id="datatype"
                            name="datatype"
                            class="error-waring-select"
                           placeholder="请选择"
                           size="large"
                           clearable>
                    <el-option v-for="item in _datatype"
                               :key="item.Value"
                               :label="item.Label"
                               :value="item.Value" />
                </el-select>
            </div>
        </div>

        <div class="row mb-3">
            <label class="col-md-2 col-form-label text-md-end">
                默认值：
                <span class="text-danger">*</span>
            </label>
            <div class="col-md-10">
                <el-input v-model="form.defaultvalue"
                          name="defaultvalue"
                          id="defaultvalue"
                          placeholder="请输入"
                          size="large"
                          required
                          style="width:50%">
                </el-input>
                时间：now()

            </div>
        </div>
        <div class="row mb-3">
            <label class="col-md-2 col-form-label text-md-end">
                索引：
                <span class="text-danger">*</span>
            </label>
            <div class="col-md-10">
                <el-switch v-model="form.sy"
                           name="sy"
                           id="sy"
                           size="large"
                           active-text="是"
                           inactive-text="否"
                           inline-prompt>
                </el-switch>

               
            </div>
        </div>
        <div class="row mb-3">
            <label class="col-md-2 col-form-label text-md-end">
            </label>
            <div class="col-md-10">
                <input type="hidden" name="fst" id="fst" asp-for="fst">
                <input type="hidden" name="snd" id="snd" asp-for="snd">
                <input type="hidden" name="thd" id="thd" asp-for="thd">

                <div class="d-grid d-md-block">
                    <button type="button" class="btn btn-primary btn-lg" @@click="submit">提交</button>
                </div>
            </div>

        </div>
    </form>
</div>


@section Scripts
{
      <script>
   	const {
   		createApp
   	} = Vue;
   	const ElMessage = ElementPlus.ElMessage;
   	const _datatype = @Html.Raw(System.Text.Json.JsonSerializer.Serialize(Model._datatype));
   	const App = {
   		data() {
   			return {
   				form: {
   				
   				},
   				_datatype: _datatype

   			};
   		},
   		methods: {
   			submit() {
   				// 1. 原生校验
   				const formEl = document.getElementById("form1");
   				const selectEl = document.getElementById("datatype");
   				if (!formEl.reportValidity()) return;

   				// 2. Vue数据校验
   				if (!this.form.datatype) {
   					const el = document.querySelector(".error-waring-select");
   					el?.classList.add("is-error");
   					ElMessage({
   						message: "请选择数据类型",
   						type: "warning",
   						offset: 250
   					});

   					return;
   				}
   				//3. 提交表单（关键）
   				formEl.submit();
   			}
   		},
   		watch: {
   			"form.datatype"(val) {
   				if (val) {
   					const el = document.querySelector(".error-waring-select");
   					el?.classList.remove("is-error");
   				}
   			}
   		}
   	};


   	const app = createApp(App);
   	app.use(ElementPlus);
   	//图标注册
   	for (const [key, comp] of Object.entries(ElementPlusIconsVue)) {
   		app.component(key, comp);
   	}
   	app.mount("#app");
   </script>
</script>

}

sqlite id 设为uuid 默认值

Thu, 02 Jul 2026 15:04:42 +0800

lower(hex(randomblob(16)))

Aspose.Words 插入图片

Thu, 02 Jul 2026 14:13:29 +0800

        #region 创建 Word 文档

        string templatePath = Server.MapPath("template.docx");
        // 只创建一个Document（关键优化）
        Document doc = new Document(templatePath);
        //清空模板内容（如果模板只是占位用）
        doc.RemoveAllChildren();
        //用Builder写入（核心：避免AppendDocument）
        DocumentBuilder builder = new DocumentBuilder(doc);
        #endregion

        #region 数据       
        if (ds.Tables[0].Rows.Count > 0)
        {
            for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
            {
                var row = ds.Tables[0].Rows[i];

                // 获取图片路径
                string xys = getimg1(row["xys"].ToString(), obj);
                string[] pic = Fun.splitstr(xys, "、");

                if (string.IsNullOrEmpty(pic[0]))
                    continue;

                if (pic[0] == "/templates/default/images/icon/pdf.gif")
                    continue;

                if (Fun.GetStrRight(pic[0], 1) == ".")
                    pic[0] = pic[0] + "jpg";

                string imagePath = Server.MapPath(pic[0]);

                // ===== 1. 标题 =====
                builder.ParagraphFormat.Alignment = ParagraphAlignment.Center;
                builder.Font.Size = 16;
                builder.Font.Bold = true;
                builder.Writeln(row["hzqymc"].ToString());

                builder.Font.ClearFormatting();
                builder.ParagraphFormat.ClearFormatting();

                // ===== 2. 图片（限制尺寸避免OOM）=====
                try
                {
                    using (var img = System.Drawing.Image.FromFile(imagePath))
                    {
                        int width = 800;
                        int height = (int)(img.Height * (800.0 / img.Width));

                        using (var bmp = new Bitmap(img, new Size(width, height)))
                        {
                            string temp = Path.Combine(Path.GetTempPath(), Guid.NewGuid() + ".jpg");
                            bmp.Save(temp, System.Drawing.Imaging.ImageFormat.Jpeg);

                            builder.InsertImage(temp, 0, 600);

                            File.Delete(temp);
                        }
                    }

                  
                }
                catch
                {
                    FileObj.FileAdd(Server.MapPath("1.txt"),
                        row["hzqymc"] + "----" + pic[0] + "\r\n");
                }

                // ===== 3. 分页 =====
                if (i < ds.Tables[0].Rows.Count - 1)
                {
                    builder.InsertBreak(BreakType.PageBreak);
                }
            }
        }

        #endregion

        #region 下载

        Response.Clear();
        Response.ContentType = "application/vnd.openxmlformats-officedocument.wordprocessingml.document";
        Response.AddHeader("Content-Disposition", "attachment; filename=协议书.docx");

        using (var ms = new MemoryStream())
        {
            doc.Save(ms, SaveFormat.Docx);

            ms.Position = 0;

            byte[] buffer = new byte[81920]; // 80KB 缓冲（推荐）
            int bytesRead;

            while ((bytesRead = ms.Read(buffer, 0, buffer.Length)) > 0)
            {
                Response.OutputStream.Write(buffer, 0, bytesRead);
            }

            Response.Flush();
            Response.End();
        }


       
        #endregion