Views/Tools/CodeTools.ashx

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

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

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

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

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

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

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

        if (!string.IsNullOrEmpty(Action) && !string.IsNullOrEmpty(MID) && !string.IsNullOrEmpty(Fields))
        {
            dynamic json = JToken.Parse(Fields) as dynamic;
            TableName = json["TableName"];

            if (Action.Trim().ToLower() == "insert" && !string.IsNullOrEmpty(TableName))
                flag = GetInsertQuery(TableName.Trim());

            if (Action.Trim().ToLower() == "update" && !string.IsNullOrEmpty(TableName))
                flag = GetUpdateQuery(TableName.Trim());

            if (Action.Trim().ToLower() == "field" && !string.IsNullOrEmpty(TableName))
                flag = GetFieldString(TableName.Trim());
        }
        else
            flag = "出错了请检查URL参数。Check the URL parameters for errors.";

        context.Response.Write(flag);
    }

    /// <summary>
    /// 根据表的字段生成插入语句
    /// </summary>
    /// <param name="TableName"></param>
    /// <returns></returns>
    protected string GetInsertQuery(string TableName)
    {
        string flag = MicroPublic.GetMsg("DenyUrlParaError"), _StringFieldName = string.Empty, _StringPrefixFieldName = string.Empty, _Json = string.Empty, _FieldName = string.Empty, _FieldValue = string.Empty, _SQL = string.Empty, _SP = string.Empty, _SPValue = string.Empty, _dtInsert = string.Empty, _drInsert = string.Empty;

        string _sql = "select * from MicroTables where ParentID in (select TID from MicroTables where TabColName = '" + TableName + "' and ParentID = 0) and InJoinSql=1 order by ParentID,Sort";
        SqlParameter[] _sp = { new SqlParameter("@TableName", SqlDbType.VarChar, 100) };

        DataTable _dt = MsSQLDbHelper.Query(_sql, _sp).Tables[0];

        if (_dt != null && _dt.Rows.Count > 0)
        {
            _Json = "dynamic json = JToken.Parse(Fields) as dynamic; <br/><br/>";