Views/Set/System/AddMicroDataTableColumn.ashx

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

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

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

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

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

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

        string flag = "提交失败，请检查URL参数<br/>The submission failed. Check the URL parameters",
                        Action = HttpUtility.UrlEncode(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))
        {
            if (Action.Trim().ToLower() == "addcol")
                flag = AddColumn(MID.Trim(), Fields.Trim());
        }

        context.Response.Write(flag);

    }

    /// <summary>
    /// 向表添加列
    /// </summary>
    /// <param name="mid"></param>
    /// <param name="field"></param>
    /// <returns></returns>
    protected string AddColumn(string MID, string Fields)
    {
        string flag = "添加失败<br/>Add failure", TableName = string.Empty, ParentID = string.Empty, TabColName = string.Empty, Title = string.Empty, DataType = string.Empty, _DataType = string.Empty, FieldLength = string.Empty, AllowNull = string.Empty, DefaultValue = string.Empty, _DefaultValue=string.Empty, Description = string.Empty, colAlign = "center", colEdit = string.Empty, ctlTitle = string.Empty, ctlTypes = string.Empty, ctlPrefix = string.Empty, ctlStyle = string.Empty, ctlCheckboxSkin = string.Empty, ctlDescription = string.Empty, ctlValue=string.Empty, ctlDefaultValue = string.Empty, ctlCharLength = string.Empty, ctlSourceTable = string.Empty, ctlTextName = string.Empty, ctlTextValue = string.Empty, ctlExtendJSCode = string.Empty, ctlFilter = string.Empty, ctlVerify = string.Empty, ctlVerify2 = string.Empty, ctlInputInline = "layui-input-inline";

        //用于生成Layui数据表时显示自定义字段，如用户所属部门保存的是用户ID，想要显示的是部门名称而该值正是这个要显示的字段
        //该值与“ctlSourceTable”“ctlTextName”“ctlTextValue”相配合使用，这三个值不为空时该字段默认赋值为“ctlTextName”
        string colCustomField = string.Empty;

        try
        {
            dynamic json = JToken.Parse(Fields) as dynamic;

            ParentID = json["selTableName"];
            TableName = json["txtTableName"]; TableName = TableName.toStringTrim();
            TabColName = json["txtTabColName"];TabColName = TabColName.toStringTrim();
            //Title = TabColName;
            DataType = json["selDataType"];  //DataType =  nvarchar(200) 
            _DataType = DataType; // nvarchar 
            FieldLength = json["txtFieldLength"]; FieldLength = FieldLength.toStringTrim();

            DefaultValue = json["txtDefaultValue"]; DefaultValue = DefaultValue.toStringTrim();
            _DefaultValue = DefaultValue;