App_Code/MicroXmSelectHelper.cs

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

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

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Linq;
using System.Web;
using System.Data;
using System.Data.SqlClient;
using MicroDBHelper;
using MicroDTHelper;
using MicroUserHelper;

namespace MicroXmSelectHelper
{

    /// <summary>MicroXmSelectHelper
    /// MicroXmSelectHelper 的摘要说明
    /// </summary>
    public class MicroXmSelect
    {

        /// <summary>
        /// 获取适用于XmSelect的数据
        /// </summary>
        /// <param name="TableName">数据来源表名</param>
        /// <param name="DisplayNameField">显示字段</param>
        /// <param name="DisplayValueField">值字段</param>
        /// <param name="DefaultValue">默认值</param>
        /// <returns></returns>
        public static string GetXmSelect(string TableName, string DisplayNameField, string DisplayValueField, string IsApprovalForm, string FormID = "", string DefaultValue = "")
        {
            string flag = string.Empty;
            try
            {
                var getTableAttr = MicroDataTable.GetTableAttr(TableName);
                DataTable MicroDT = getTableAttr.MicroDT; //获取存放在MicroTables的数据，该表是存放每个表的表名和字段
                string PrimaryKeyName = getTableAttr.PrimaryKeyName;  //获得主键字段名称
                string SortFieldName = getTableAttr.SortFieldName;  //获得排序字段名称
                string OrderBy = getTableAttr.OrderBy;  //获得order by 命令字符串
                Boolean MainSub = getTableAttr.MainSub;  //用于判断是否开启父子项
                Boolean IsPage = getTableAttr.IsPage; //是否开启分页

                string _FormID = string.Empty;

                if (IsApprovalForm.toBoolean())
                {
                    if (!string.IsNullOrEmpty(FormID) && MsSQLDbHelper.ColumnExists(TableName, "FormID"))
                        _FormID = " and FormID = " + FormID.toInt();
                }

                string Invalid = " and Invalid=0 ";
                if (MicroUserInfo.CheckUserRole("Administrators"))
                    Invalid = " ";

                string _sql = "select * from " + TableName + " where Del=0 " + Invalid + _FormID + " " + OrderBy;
                DataTable _dt = MsSQLDbHelper.Query(_sql).Tables[0];
                if (_dt != null && _dt.Rows.Count > 0)
                {
                    if (MainSub)
                        flag = GetMain(_dt, DisplayNameField, DisplayValueField, SortFieldName, DefaultValue);
                    else