using GenerateCode_GEBrilliantFactory.Model;
|
using GenerateCode_WeiBen_WMS.Model;
|
using System;
|
using System.Collections.Generic;
|
using System.Configuration;
|
using System.Data;
|
using System.Data.SqlClient;
|
using System.Linq;
|
using System.Text;
|
|
namespace GenerateCode_GEBrilliantFactory
|
{
|
/// <summary>
|
/// 公共类
|
/// </summary>
|
public class CommonHelper
|
{
|
/// <summary>
|
/// 获取 我的数据类型分类枚举
|
/// </summary>
|
/// <param name="enumDT"></param>
|
/// <returns></returns>
|
public static MyDataTypeCategorizeEnum GetMyDataTypeCategorizeEnum(DataTypeEnum enumDT)
|
{
|
//处理高级select查询
|
switch (enumDT)
|
{
|
case DataTypeEnum.dt_bit:
|
case DataTypeEnum.dt_tinyint:
|
return MyDataTypeCategorizeEnum.布尔类;
|
case DataTypeEnum.dt_int:
|
case DataTypeEnum.dt_bigint:
|
case DataTypeEnum.dt_decimal:
|
case DataTypeEnum.dt_float:
|
return MyDataTypeCategorizeEnum.数字类;
|
case DataTypeEnum.dt_datetime:
|
case DataTypeEnum.dt_datetime2:
|
case DataTypeEnum.dt_datetimeoffset:
|
return MyDataTypeCategorizeEnum.日期类;
|
default://剩余的一律认为是 字符串
|
return MyDataTypeCategorizeEnum.字符串类;
|
}
|
}
|
|
/// <summary>
|
/// 是否忽略该列
|
/// </summary>
|
/// <param name="columnName"></param>
|
/// <returns></returns>
|
public static bool IsIgnore(string columnName)
|
{
|
if (columnName.ToUpper() == SystemCommonVar.c_ExtraProperties.ToUpper()
|
|| columnName.ToUpper() == SystemCommonVar.c_ConcurrencyStamp.ToUpper()
|
)
|
{
|
return true;
|
}
|
return false;
|
}
|
|
/// <summary>
|
/// 通用替换字符串
|
/// </summary>
|
/// <param name="param"></param>
|
/// <param name="str"></param>
|
public static void CommonReplaceStr(GenerateCodeParam param, ref string str)
|
{
|
str = str.Replace("$NameSpacePath$", param.NameSpacePath);//命名空间
|
str = str.Replace("$ChinaComment$", param.ChinaComment);//中文注释
|
str = str.Replace("$PageMenuName$", param.PageMenuName);//中文注释
|
str = str.Replace("$PageMenuInstanceName$", param.PageMenuInstanceName);//中文注释
|
str = str.Replace("$EntityName$", param.EntityName);//实体类名
|
str = str.Replace("$Modulelogo$", param.Modulelogo);//模块简写
|
str = str.Replace("$EntityInstanceName$", param.EntityInstanceName);//实例名
|
str = str.Replace("$TableName$", param.TableName);//表名
|
|
//如果为空，系统默认所有字符串的展示列查询
|
var str_LikeQueryAttrs = param.LikeQueryAttrs;
|
var str_LikeQueryAttrsName = param.LikeQueryAttrsName;
|
if (string.IsNullOrEmpty(param.LikeQueryAttrs))
|
{
|
str_LikeQueryAttrs = StructStrHelper.Get_LikeQueryAttrs(param.ColumnNameList, param);
|
str_LikeQueryAttrsName = StructStrHelper.Get_LikeQueryAttrsName(param.ColumnNameList, param);
|
}
|
str = str.Replace("$LikeQueryAttrs$", str_LikeQueryAttrs);
|
str = str.Replace("$LikeQueryAttrsName$", str_LikeQueryAttrsName);
|
|
str = str.Replace("$ValidateRepeatName$", param.ValidateRepeatName);
|
str = str.Replace("$DeleteAlertAttr$", param.DeleteAlertAttr);
|
str = str.Replace("$OrderBy$", param.OrderBy);
|
|
}
|
|
/// <summary>
|
/// 首字母小写
|
/// </summary>
|
/// <param name="str"></param>
|
/// <returns></returns>
|
public static string FirstLowercase(string str)
|
{
|
if (string.IsNullOrEmpty(str))
|
{
|
return str;
|
}
|
str = str.Substring(0, 1).ToLower() + str.Substring(1);
|
return str;
|
}
|
|
|
/// <summary>
|
/// 获取存储过程名
|
/// </summary>
|
/// <param name="moduleName"></param>
|
/// <returns></returns>
|
public static ProcName GetProcName(string moduleName)
|
{
|
string procPrefix = "uspWip_";
|
ProcName procName = new ProcName()
|
{
|
AddProc = procPrefix + "Add" + moduleName,
|
UpdateProc = procPrefix + "Update" + moduleName,
|
GetSingleProc = procPrefix + "GetSingle" + moduleName,
|
ListProc = procPrefix + "Get" + moduleName + "List",
|
PageListProc = procPrefix + "Get" + moduleName + "PageList",
|
};
|
return procName;
|
}
|
|
/// <summary>
|
/// 回车符
|
/// </summary>
|
public const string enterStr = "\n";
|
|
/// <summary>
|
/// 单个回车符的字符串
|
/// </summary>
|
/// <param name="content"></param>
|
/// <returns></returns>
|
public static string GetSinleEnterStr(string content)
|
{
|
return content + enterStr;
|
}
|
/// <summary>
|
/// 两个回车符的字符串
|
/// </summary>
|
/// <param name="content"></param>
|
/// <returns></returns>
|
public static string GetDoubleEnterStr(string content)
|
{
|
return content + enterStr + enterStr;
|
}
|
|
/// <summary>
|
/// 当前时间字符串
|
/// </summary>
|
/// <returns></returns>
|
public static string GetCurDate()
|
{
|
return DateTime.Now.Year + "-" + DateTime.Now.Month + "-" + DateTime.Now.Day
|
+ " "
|
+ DateTime.Now.Hour + ":" + DateTime.Now.Minute + ":" + DateTime.Now.Second;
|
}
|
|
/// <summary>
|
/// 首字母大写
|
/// </summary>
|
/// <param name="str"></param>
|
/// <returns></returns>
|
public static string TitleToUpper(string str)
|
{
|
if (string.IsNullOrWhiteSpace(str))
|
return string.Empty;
|
|
char[] s = str.ToCharArray();
|
char c = s[0];
|
|
if ('a' <= c && c <= 'z')
|
c = (char)(c & ~0x20);
|
|
s[0] = c;
|
|
return new string(s);
|
}
|
/// <summary>
|
/// 首字母小写
|
/// </summary>
|
/// <param name="str"></param>
|
/// <returns></returns>
|
public static string TitleToLower(string str)
|
{
|
if (string.IsNullOrWhiteSpace(str))
|
return string.Empty;
|
|
char[] s = str.ToCharArray();
|
char c = s[0];
|
|
if ('A' <= c && c <= 'Z')
|
c = char.ToLower(c);
|
|
|
s[0] = c;
|
|
return new string(s);
|
}
|
|
/// <summary>
|
/// 获取数据库连接字符串列表
|
/// </summary>
|
/// <returns></returns>
|
public static List<ListItem> GetDataSources()
|
{
|
List<ListItem> list = new List<ListItem>();
|
ConnectionStringSettingsCollection conn = ConfigurationManager.ConnectionStrings;
|
foreach (ConnectionStringSettings item in conn)
|
{
|
if (item.Name == "LocalSqlServer")
|
continue;
|
ListItem listItem = new ListItem()
|
{
|
Text = item.Name,
|
Value = item.ConnectionString
|
};
|
list.Add(listItem);
|
}
|
return list;
|
}
|
|
/// <summary>
|
/// 获取数据库类型列表
|
/// </summary>
|
/// <returns></returns>
|
public static List<ListItem> GetDataBase()
|
{
|
List<ListItem> list = new List<ListItem>();
|
|
|
ListItem listItem = new ListItem()
|
{
|
Text = DataBaseEnum.MySql.ToString(),
|
Value = DataBaseEnum.MySql.ToString()
|
};
|
list.Add(listItem);
|
listItem = new ListItem()
|
{
|
Text = DataBaseEnum.SqlServer.ToString(),
|
Value = DataBaseEnum.SqlServer.ToString()
|
};
|
list.Add(listItem);
|
|
return list;
|
}
|
|
}
|
|
/// <summary>
|
/// 文件类型
|
/// </summary>
|
public enum FileType
|
{
|
/// <summary>
|
/// 实体类文件
|
/// </summary>
|
Model = 0,
|
/// <summary>
|
/// DAO文件
|
/// </summary>
|
DAO = 1,
|
/// <summary>
|
/// IBLL文件
|
/// </summary>
|
IBLL = 2,
|
/// <summary>
|
/// BLL文件
|
/// </summary>
|
BLL = 3,
|
/// <summary>
|
/// Controller文件
|
/// </summary>
|
Controller = 4,
|
/// <summary>
|
/// JS文件
|
/// </summary>
|
JS = 5,
|
/// <summary>
|
/// 列表页面
|
/// </summary>
|
CSHTML_List = 6,
|
/// <summary>
|
/// XML文件
|
/// </summary>
|
XML = 7,
|
/// <summary>
|
/// 详情页面
|
/// </summary>
|
CSHTML_Detail = 8,
|
/// <summary>
|
/// 存储过程文件
|
/// </summary>
|
Proc = 9,
|
/// <summary>
|
/// DAL 文件
|
/// </summary>
|
DAL = 10,
|
/// <summary>
|
/// InputModel
|
/// </summary>
|
InputModel = 11,
|
/// <summary>
|
/// WCF接口文件
|
/// </summary>
|
WCF_InterFace = 12,
|
/// <summary>
|
/// WCF接口实现文件
|
/// </summary>
|
WCF_InterFaceRealize = 13,
|
/// <summary>
|
/// InsertSQL
|
/// </summary>
|
SQL_Insert = 14,
|
/// <summary>
|
/// VUE方法配置
|
/// </summary>
|
VUE_FunConfig = 15,
|
/// <summary>
|
/// VUE文件
|
/// </summary>
|
VUEFile = 16,
|
/// <summary>
|
/// 新增实体参数类
|
/// </summary>
|
AddModelParam = 17,
|
|
/// <summary>
|
/// OutputModel
|
/// </summary>
|
OutputModel = 18,
|
}
|
}
|
