using GenerateCode_GEBrilliantFactory.Model;
|
using System;
|
using System.Collections.Generic;
|
using System.Linq;
|
using System.Text;
|
using System.Threading.Tasks;
|
|
namespace GenerateCode_GEBrilliantFactory
|
{
|
public class ListHelper
|
{
|
/// <summary>
|
/// 获取最新的列List集合(去掉 creator和createTime)
|
/// </summary>
|
/// <param name="columnNameList"></param>
|
/// <returns></returns>
|
public static List<ColumnModel> RemoveCreator(List<ColumnModel> columnNameList)
|
{
|
//构造新的List
|
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())
|
{
|
continue;
|
}
|
newList.Add(columnModel);
|
}
|
return newList;
|
}
|
|
|
/// <summary>
|
/// 获取最新的列List集合(移除全部)
|
/// </summary>
|
/// <param name="columnNameList"></param>
|
/// <returns></returns>
|
public static List<ColumnModel> RemoveAll(List<ColumnModel> columnNameList)
|
{
|
//构造新的List
|
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_ModifyTime.ToUpper()
|
|| columnModel.ColumnName.ToUpper() == SystemCommonVar.c_lastModifier.ToUpper()
|
|| columnModel.ColumnName.ToUpper() == SystemCommonVar.c_lastModifyTime.ToUpper()
|
|| columnModel.ColumnName.ToUpper() == SystemCommonVar.c_delFlag.ToUpper()
|
|| columnModel.ColumnName.ToUpper() == SystemCommonVar.c_Id.ToUpper()
|
)
|
{
|
continue;
|
}
|
newList.Add(columnModel);
|
}
|
return newList;
|
}
|
|
/// <summary>
|
/// 获取最新的列List集合(CreatedTime、UpdatedTime、CreatedUserId、CreatedUserName、UpdatedUserId、UpdatedUserName)
|
/// </summary>
|
/// <param name="columnNameList"></param>
|
/// <returns></returns>
|
public static List<ColumnModel> RemoveCreatedTimeUpdatedTimeCreatedUserIdCreatedUserNameUpdatedUserIdUpdatedUserName(List<ColumnModel> columnNameList)
|
{
|
//构造新的List
|
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_ModifyTime.ToUpper()
|
|| columnModel.ColumnName.ToUpper() == SystemCommonVar.c_ModifyId.ToUpper()
|
|| columnModel.ColumnName.ToUpper() == SystemCommonVar.c_lastModifier.ToUpper()
|
|| columnModel.ColumnName.ToUpper() == SystemCommonVar.c_lastModifyTime.ToUpper()
|
)
|
{
|
continue;
|
}
|
newList.Add(columnModel);
|
}
|
return newList;
|
}
|
|
/// <summary>
|
/// 获取最新的列List集合(去掉 delFlag、creator、createTime、lastModifier、lastModifyTime)
|
/// </summary>
|
/// <param name="columnNameList"></param>
|
/// <returns></returns>
|
public static List<ColumnModel> RemoveDelFlagCreatorModifier(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_ModifyTime.ToUpper()
|
|| columnModel.ColumnName.ToUpper() == SystemCommonVar.c_lastModifyTime.ToUpper()
|
|| columnModel.ColumnName.ToUpper() == SystemCommonVar.c_delFlag.ToUpper()
|
)
|
{
|
continue;
|
}
|
newList.Add(columnModel);
|
}
|
return newList;
|
}
|
|
/// <summary>
|
/// 获取最新的列List集合(去掉 Id，OperationRemark、CreateId，ModifyId)
|
/// </summary>
|
/// <param name="columnNameList"></param>
|
/// <returns></returns>
|
public static List<ColumnModel> RemoveIdOperationRemarkCreateIdModifyId(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_Id.ToUpper()
|
|| columnModel.ColumnName.ToUpper() == "OperationRemark".ToUpper()
|
|| columnModel.ColumnName.ToUpper() == SystemCommonVar.c_CreateId.ToUpper()
|
|| columnModel.ColumnName.ToUpper() == SystemCommonVar.c_ModifyId.ToUpper()
|
)
|
{
|
continue;
|
}
|
newList.Add(columnModel);
|
}
|
return newList;
|
}
|
|
|
/// <summary>
|
/// 前端页面（新增、修改表单的选项筛选专用）
|
/// </summary>
|
/// <param name="columnNameList"></param>
|
/// <returns></returns>
|
public static List<ColumnModel> RemoveForPageAddFormAttributes(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_ModifyTime.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()
|
|| columnModel.ColumnName.ToUpper() == SystemCommonVar.c_Sort.ToUpper()
|
|
)
|
{
|
continue;
|
}
|
newList.Add(columnModel);
|
}
|
return newList;
|
}
|
|
/// <summary>
|
/// 获取最新的列List集合(去掉 Id，CreateId，ModifyId)
|
/// </summary>
|
/// <param name="columnNameList"></param>
|
/// <returns></returns>
|
public static List<ColumnModel> RemoveIdCreateIdModifyId(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_Id.ToUpper()
|
|| columnModel.ColumnName.ToUpper() == SystemCommonVar.c_CreateId.ToUpper()
|
|| columnModel.ColumnName.ToUpper() == SystemCommonVar.c_ModifyId.ToUpper()
|
)
|
{
|
continue;
|
}
|
newList.Add(columnModel);
|
}
|
return newList;
|
}
|
|
/// <summary>
|
/// 获取最新的列List集合(去掉 Id，CreateId，ModifyId,DelFlag)
|
/// </summary>
|
/// <param name="columnNameList"></param>
|
/// <returns></returns>
|
public static List<ColumnModel> RemoveIdCreateIdModifyIdDelFlag(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_Id.ToUpper()
|
|| columnModel.ColumnName.ToUpper() == SystemCommonVar.c_CreateId.ToUpper()
|
|| columnModel.ColumnName.ToUpper() == SystemCommonVar.c_ModifyId.ToUpper()
|
|| columnModel.ColumnName.ToUpper() == SystemCommonVar.c_delFlag.ToUpper()
|
)
|
{
|
continue;
|
}
|
newList.Add(columnModel);
|
}
|
return newList;
|
}
|
|
/// <summary>
|
/// 获取最新的列List集合(只保留 字符串类型的字段)
|
/// </summary>
|
/// <param name="columnNameList"></param>
|
/// <returns></returns>
|
public static List<ColumnModel> OnlyStringProValue(List<ColumnModel> columnNameList)
|
{
|
List<ColumnModel> newList = new List<ColumnModel>();
|
ColumnModel columnModel = null;
|
for (int i = 0; i < columnNameList.Count; i++)
|
{
|
columnModel = columnNameList[i];
|
//获取数据类型
|
DataTypeEnum enumDT = (DataTypeEnum)Enum.Parse(typeof(DataTypeEnum), "dt_" + columnModel.DataType.ToString());
|
switch (enumDT)
|
{
|
case DataTypeEnum.dt_char:
|
case DataTypeEnum.dt_varchar:
|
case DataTypeEnum.dt_Varchar_Desc:
|
case DataTypeEnum.dt_uniqueidentifier:
|
case DataTypeEnum.dt_Varchar_Ext_Link:
|
case DataTypeEnum.dt_nvarchar:
|
newList.Add(columnModel);
|
break;
|
}
|
}
|
return newList;
|
}
|
|
|
/// <summary>
|
/// 获取最新的列List集合(去掉 id、creator、createTime、lastModifier、lastModifyTime)
|
/// </summary>
|
/// <param name="columnNameList"></param>
|
/// <returns></returns>
|
public static List<ColumnModel> RemoveIdCreatorModifier(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_ModifyTime.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()
|
)
|
{
|
continue;
|
}
|
newList.Add(columnModel);
|
}
|
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_ModifyTime.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>
|
/// 过滤，更新实体类时专用
|
/// </summary>
|
/// <param name="columnNameList"></param>
|
/// <returns></returns>
|
public static List<ColumnModel> RemoveAttrForUpdateMode(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_ModifyTime.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()
|
|| columnModel.ColumnName.ToUpper() == SystemCommonVar.c_Sort.ToUpper()
|
|
)
|
{
|
continue;
|
}
|
newList.Add(columnModel);
|
}
|
return newList;
|
}
|
|
/// <summary>
|
/// 获取最新的列List集合(去掉 ID)
|
/// </summary>
|
/// <param name="columnNameList"></param>
|
/// <returns></returns>
|
public static List<ColumnModel> OnlyRemoveId(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_Id.ToUpper())
|
{
|
continue;
|
}
|
newList.Add(columnModel);
|
}
|
return newList;
|
}
|
|
}
|
}
|
