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);//实例名

            //如果为空，系统默认所有字符串的展示列查询
            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,
    }
}