From b7a82bbc4b305f0323be93030842c1b82c824337 Mon Sep 17 00:00:00 2001
From: schangxiang@126.com <schangxiang@126.com>
Date: 周五, 09 5月 2025 10:06:36 +0800
Subject: [PATCH] 优化查询列
---
Weben_CMS专用代码生成器/Code/Utility/ListHelper.cs | 120 ++++++++++++++++++++++++-----------------------------------
1 files changed, 49 insertions(+), 71 deletions(-)
diff --git "a/Weben_CMS\344\270\223\347\224\250\344\273\243\347\240\201\347\224\237\346\210\220\345\231\250/Code/Utility/ListHelper.cs" "b/Weben_CMS\344\270\223\347\224\250\344\273\243\347\240\201\347\224\237\346\210\220\345\231\250/Code/Utility/ListHelper.cs"
index 6758b4b..495bde1 100644
--- "a/Weben_CMS\344\270\223\347\224\250\344\273\243\347\240\201\347\224\237\346\210\220\345\231\250/Code/Utility/ListHelper.cs"
+++ "b/Weben_CMS\344\270\223\347\224\250\344\273\243\347\240\201\347\224\237\346\210\220\345\231\250/Code/Utility/ListHelper.cs"
@@ -58,7 +58,9 @@
#region 銆愰〉闈€�戝垪琛ㄧ晫闈�
/// <summary>
- /// 椤甸潰琛ㄦ牸灞曠ず鐨� 瀛楁鍒楄〃
+ /// 1銆侀〉闈㈣〃鏍煎睍绀虹殑 瀛楁鍒楄〃
+ /// 2銆侀〉闈㈠鍑哄垪琛�
+ /// 3銆侀珮绾ф煡璇㈠垪
/// </summary>
/// <param name="columnNameList"></param>
/// <returns></returns>
@@ -70,6 +72,7 @@
{
columnModel = columnNameList[i];
if (
+
columnModel.ColumnName.ToUpper() == SystemCommonVar.c_CreateId.ToUpper()
//|| columnModel.ColumnName.ToUpper() == SystemCommonVar.c_creator.ToUpper()
//|| columnModel.ColumnName.ToUpper() == SystemCommonVar.c_createTime.ToUpper()
@@ -102,51 +105,53 @@
#endregion
- #region 銆愰〉闈€�戦珮绾ф煡璇㈡樉绀虹殑鍒�
-
- /// <summary>
- /// 銆愰〉闈€�戦珮绾ф煡璇㈡樉绀虹殑鍒�
- /// </summary>
- /// <param name="columnNameList"></param>
- /// <returns></returns>
- public static List<ColumnModel> RemoveAttrForQueryMode(List<ColumnModel> columnNameList)
- {
- List<ColumnModel> newList = new List<ColumnModel>();
- ColumnModel columnModel = null;
- for (int i = 0; i < columnNameList.Count; i++)
- {
- columnModel = columnNameList[i];
- if (
- columnModel.ColumnName.ToUpper() == SystemCommonVar.c_CreateId.ToUpper()
- //|| columnModel.ColumnName.ToUpper() == SystemCommonVar.c_creator.ToUpper()
- //|| columnModel.ColumnName.ToUpper() == SystemCommonVar.c_createTime.ToUpper()
-
- || columnModel.ColumnName.ToUpper() == SystemCommonVar.c_ModifyId.ToUpper()
- //|| columnModel.ColumnName.ToUpper() == SystemCommonVar.c_lastModifier.ToUpper()
- //|| columnModel.ColumnName.ToUpper() == SystemCommonVar.c_lastModifyTime.ToUpper()
-
- || columnModel.ColumnName.ToUpper() == SystemCommonVar.c_Id.ToUpper()
-
- || columnModel.ColumnName.ToUpper() == SystemCommonVar.c_ExtraProperties.ToUpper()
- || columnModel.ColumnName.ToUpper() == SystemCommonVar.c_ConcurrencyStamp.ToUpper()
-
- || columnModel.ColumnName.ToUpper() == SystemCommonVar.c_DeleterId.ToUpper()
- || columnModel.ColumnName.ToUpper() == SystemCommonVar.c_delFlag.ToUpper()
- || columnModel.ColumnName.ToUpper() == SystemCommonVar.c_DeletionTime.ToUpper()
- || columnModel.ColumnName.ToUpper() == SystemCommonVar.c_Sort.ToUpper()
- || SystemCommonVar.c_Extend.Contains(columnModel.ColumnName.ToUpper())
- )
- {
- continue;
- }
- newList.Add(columnModel);
- }
- return newList;
- }
+ //#region 銆愰〉闈€�戦珮绾ф煡璇㈡樉绀虹殑鍒�
- #endregion
+ ///// <summary>
+ ///// 銆愰〉闈€�戦珮绾ф煡璇㈡樉绀虹殑鍒�
+ ///// </summary>
+ ///// <param name="columnNameList"></param>
+ ///// <returns></returns>
+ //public static List<ColumnModel> RemoveAttrForQueryMode(List<ColumnModel> columnNameList)
+ //{
+ // List<ColumnModel> newList = new List<ColumnModel>();
+ // ColumnModel columnModel = null;
+ // for (int i = 0; i < columnNameList.Count; i++)
+ // {
+ // columnModel = columnNameList[i];
+ // if (
+ // columnModel.ColumnName.ToUpper() == SystemCommonVar.c_CreateId.ToUpper()
+ // //|| columnModel.ColumnName.ToUpper() == SystemCommonVar.c_creator.ToUpper()
+ // //|| columnModel.ColumnName.ToUpper() == SystemCommonVar.c_createTime.ToUpper()
+
+ // || columnModel.ColumnName.ToUpper() == SystemCommonVar.c_ModifyId.ToUpper()
+ // //|| columnModel.ColumnName.ToUpper() == SystemCommonVar.c_lastModifier.ToUpper()
+ // //|| columnModel.ColumnName.ToUpper() == SystemCommonVar.c_lastModifyTime.ToUpper()
+
+ // || columnModel.ColumnName.ToUpper() == SystemCommonVar.c_Id.ToUpper()
+
+ // || columnModel.ColumnName.ToUpper() == SystemCommonVar.c_ExtraProperties.ToUpper()
+ // || columnModel.ColumnName.ToUpper() == SystemCommonVar.c_ConcurrencyStamp.ToUpper()
+
+ // || columnModel.ColumnName.ToUpper() == SystemCommonVar.c_DeleterId.ToUpper()
+ // || columnModel.ColumnName.ToUpper() == SystemCommonVar.c_delFlag.ToUpper()
+ // || columnModel.ColumnName.ToUpper() == SystemCommonVar.c_DeletionTime.ToUpper()
+
+
+ // || columnModel.ColumnName.ToUpper() == SystemCommonVar.c_Sort.ToUpper()
+ // || SystemCommonVar.c_Extend.Contains(columnModel.ColumnName.ToUpper())
+ // )
+ // {
+ // continue;
+ // }
+ // newList.Add(columnModel);
+ // }
+ // return newList;
+ //}
+
+ //#endregion
/// <summary>
/// 鑾峰彇鏈�鏂扮殑鍒桳ist闆嗗悎(鍘绘帀 creator鍜宑reateTime)
@@ -426,36 +431,9 @@
return newList;
}
- public static List<ColumnModel> RemoveAttrForExport(List<ColumnModel> columnNameList)
- {
- List<ColumnModel> newList = new List<ColumnModel>();
- ColumnModel columnModel = null;
- for (int i = 0; i < columnNameList.Count; i++)
- {
- columnModel = columnNameList[i];
- if (columnModel.ColumnName.ToUpper() == SystemCommonVar.c_creator.ToUpper()
- || columnModel.ColumnName.ToUpper() == SystemCommonVar.c_createTime.ToUpper()
- || columnModel.ColumnName.ToUpper() == SystemCommonVar.c_lastModifier.ToUpper()
- || columnModel.ColumnName.ToUpper() == SystemCommonVar.c_lastModifyTime.ToUpper()
- || columnModel.ColumnName.ToUpper() == SystemCommonVar.c_Id.ToUpper()
- || columnModel.ColumnName.ToUpper() == SystemCommonVar.c_ExtraProperties.ToUpper()
- || columnModel.ColumnName.ToUpper() == SystemCommonVar.c_ConcurrencyStamp.ToUpper()
- || columnModel.ColumnName.ToUpper() == SystemCommonVar.c_DeleterId.ToUpper()
- || columnModel.ColumnName.ToUpper() == SystemCommonVar.c_delFlag.ToUpper()
- || columnModel.ColumnName.ToUpper() == SystemCommonVar.c_CreateId.ToUpper()
- || columnModel.ColumnName.ToUpper() == SystemCommonVar.c_ModifyId.ToUpper()
-
- )
- {
- continue;
- }
- newList.Add(columnModel);
- }
- return newList;
- }
-
+
/// <summary>
/// 鑾峰彇鏈�鏂扮殑鍒桳ist闆嗗悎(鍘绘帀 ID)
--
Gitblit v1.9.3