App_Code/MicroFormHelper.cs

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

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data;
using System.Data.SqlClient;
using MicroDBHelper;
using MicroDTHelper;
using MicroPublicHelper;
using MicroWorkFlowHelper;
using Newtonsoft.Json.Linq;
using MicroUserHelper;
using MicroXmSelectHelper;
using MicroAuthHelper;
using MicroPrivateHelper;

namespace MicroFormHelper
{
    /// <summary>
    /// 表单操作方法
    /// </summary>
    public class MicroForm
    {

        /// <summary>
        /// 生成Checkbox的Script脚本的Templet插入HTML页面，被Layui DataTable调用转为Switch开关
        /// </summary>
        /// <param name="ShortTableName">传入的表名</param>
        /// <returns>返回数据库字段为bit的script脚本</returns>
        public static string GetLayCheckBoxTpl(string ShortTableName)
        {
            string flag = string.Empty;
            string TableName = MicroPublic.GetTableName(ShortTableName);
            try
            {

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

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

                if (_dt != null && _dt.Rows.Count > 0)
                {
                    //查找主键名称
                    DataRow[] _rows = _dt.Select("DataType='int' and PrimaryKey=1", "ParentID,Sort");
                    if (_rows.Length > 0)
                    {
                        //得到主键名称
                        string IDName = _rows[0]["TabColName"].ToString();

                        DataRow[] _rows2 = _dt.Select("DataType='bit'", "ParentID,Sort");
                        foreach (DataRow _dr2 in _rows2)
                        {
                            flag += "<script type=\"text/html\" id=\"sw" + _dr2["TabColName"].ToString() + "\" >";
                            flag += "<input type=\"checkbox\" name=\"" + _dr2["TabColName"].ToString() + "\" value=\"{{ d." + IDName + "}}\" lay-skin=\"switch\" lay-text=\"是|否\" lay-filter=\"" + _dr2["TabColName"].ToString() + "\" {{ d." + _dr2["TabColName"].ToString() + " == 'True' ? 'checked' : '' }} >";
                            flag += "</script>";
                        }