UI总体检查

lu

2025-04-21 b8b5785627c262546c296b8586998a5f5447e6a9

 DevApp/Gs.DevApp/ToolBox/UtilityHelper.cs

@@ -1626,7 +1626,17 @@

        public static FilterEntity getFilterEntityWord(string id, string idDec, string val, string type)
        {
            return new FilterEntity(id, idDec + ")", " like ", "包含)", "%" + val + "%", type);
            switch (type)
            {
                case "Bit类型":
                    string _val = (val.ToUpper()== "true".ToUpper() ? "1": "0");
                    return new FilterEntity(id, idDec + ")", "=", "等于)", "" + _val + "", type);
                    break;
                default:
                    return new FilterEntity(id, idDec + ")", "like", "包含)", "%" + val + "%", type);
                    break;
            }
           
        }
        public static List<FilterEntity> GetDilter(GridColumnCollection Columns, GridView gridView1 = null)
        {
@@ -1642,10 +1652,18 @@
                ColumnFilterInfo filter = col.FilterInfo;
                if (string.IsNullOrEmpty(filter.FilterString))
                    continue;
                //  fiList.Add(new FilterEntity("b.FNumber", "使用组织", " like ", "包含", "%" + filter.Value + "%"));
                string[] ddd = filter.FilterString.Replace("Contains", "").Replace("(", "").Replace(")", "").Replace("'", "").Replace("'", "").Split(',');
                //Contains([fSubsidiary], '005')
                fiList.Add(getFilterEntityWord(col.Tag.ToString(), col.Caption.Trim(), ddd[1].Trim(), col.UnboundExpression));
                string _filterString= filter.FilterString.Replace("Contains", "").Replace("(", "").Replace(")", "").Replace("'", "").Replace("'", "");
                string[] ddd= _filterString.Split(',');
                string _val = "";
                if (ddd.Length > 1)
                {
                    _val = ddd[1].Trim();
                }
                else {
                    ddd = _filterString.Split('=');
                    _val = ddd[1].Trim();
                }
                fiList.Add(getFilterEntityWord(col.Tag.ToString(), col.Caption.Trim(), _val, col.UnboundExpression));
            }
            return fiList;
        }
@@ -1676,19 +1694,17 @@
                        case "时间类型":
                            _sbSqlWhere.Append(" and CONVERT(nvarchar(30)," + itm.fileId + ",23)" + itm.fileOper + "'" + itm.fileValue + "'");
                            break;
                        //case "数值类型":
                        //    _sbSqlWhere.Append(" and " + itm.fileId + itm.fileOper + "'" + itm.fileValue + "'");
                        //    break;
                        case "Bit类型":
                            _sbSqlWhere.Append(" and isnull(" + itm.fileId + ",0) =" + itm.fileValue + "");
                            break;
                        default:
                            _sbSqlWhere.Append(" and " + itm.fileId + itm.fileOper + "'" + itm.fileValue + "'");
                            _sbSqlWhere.Append(" and " +itm.fileId + " "+itm.fileOper + " '" + itm.fileValue + "'");
                            break;
                    }
                }
            }
            return _sbSqlWhere.ToString();
        }


        public delegate void DelegateGetModel(string guid);
        public delegate void DelegateGetList(int currentPage);
        /// <summary>