App_Handler/CtrlPublicTableField.ashx

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

<%@ WebHandler Language="C#" Class="CtrlPublicTableField" %>

using System;
using System.Web;
using System.Data;
using System.Data.SqlClient;
using MicroDBHelper;
using Newtonsoft.Json.Linq;
using MicroPublicHelper;
using MicroAuthHelper;

public class CtrlPublicTableField : IHttpHandler, System.Web.SessionState.IRequiresSessionState
{

    public void ProcessRequest(HttpContext context)
    {
        context.Response.ContentType = "text/plain";
        MicroAuth.CheckLogin();

        string flag = MicroPublic.GetMsg("SubmitFailed"),
                        Action = context.Server.UrlDecode(context.Request.Form["action"]),
                        MID = context.Server.UrlDecode(context.Request.Form["mid"]),
                        Fields = context.Server.UrlDecode(context.Request.Form["fields"]);

        //Action = "modify";
        //MID = "4";
        //Fields = context.Server.UrlDecode("%7B%22STN%22:%22Overtime%22,%22IDName%22:%22OvertimeID%22,%22IDValue%22:%2228577%22,%22FieldName%22:%22ExceptDaiXiu%22,%22FieldValue%22:%225%22%7D");

        if (!string.IsNullOrEmpty(Action) && !string.IsNullOrEmpty(MID) && !string.IsNullOrEmpty(Fields))
        {
            if (Action.Trim().ToLower() == "modify")
                flag = CtrlModify(MID.Trim(), Fields.Trim());
        }

        context.Response.Write(flag);
    }

    /// <summary>
    /// 修改单个字段值
    /// </summary>
    /// <param name="mid"></param>
    /// <param name="field"></param>
    /// <returns></returns>
    private string CtrlModify(string MID, string Fields)
    {
        string flag = MicroPublic.GetMsg("SaveFailed"), ShortTableName = string.Empty, TableName = string.Empty, IDName = string.Empty, IDValue = string.Empty, FieldName = string.Empty, FieldValue = string.Empty;

        try
        {
            dynamic json = JToken.Parse(Fields) as dynamic;
            ShortTableName = json["STN"];
            IDName = json["IDName"];
            IDValue = json["IDValue"];
            FieldName = json["FieldName"];
            FieldValue = json["FieldValue"];
            if (!string.IsNullOrEmpty(FieldValue))
                FieldValue = FieldValue.Trim();

            TableName = MicroPublic.GetTableName(ShortTableName);