示例#1
0
        public void SQLServerEntitiesCreate()
        {
            using (var db = new DapperExContext())
            {
                string      sql              = string.Format(@"SELECT
		                                        A.TABLE_NAME AS TableName,
		                                        H.TableDec AS TableDec,
		                                        A.COLUMN_NAME AS ColumnName,
		                                        H.ColumnDec AS ColumnDec,
		                                        A.COLUMN_DEFAULT AS DefaultValue,
		                                        CASE
			                                        WHEN A.IS_NULLABLE = 'YES' THEN 'true'
			                                        WHEN A.IS_NULLABLE = 'NO'	 THEN 'false'
		                                        END AS IsNullable,
		                                        A.DATA_TYPE AS ColumnType,
		                                        A.CHARACTER_MAXIMUM_LENGTH AS Length,
		                                        CASE
			                                        WHEN B.COLUMN_NAME IS NULL THEN 'false'
			                                        WHEN B.COLUMN_NAME IS NOT NULL THEN 'true'
		                                        END AS IsPrimaryKey
	                                        FROM
		                                        INFORMATION_SCHEMA.COLUMNS A
	                                        LEFT JOIN INFORMATION_SCHEMA.KEY_COLUMN_USAGE B ON B.COLUMN_NAME = A.COLUMN_NAME AND B.TABLE_NAME = A.TABLE_NAME
	                                        LEFT JOIN (
			                                        SELECT
				                                        D.name AS TableName,
				                                        E.name AS ColumnName,
				                                        F.VALUE AS ColumnDec,
				                                        G.VALUE AS TableDec
			                                        FROM
				                                        sys.tables D
			                                        INNER JOIN sys.columns E ON E.object_id = D.object_id
			                                        LEFT JOIN sys.extended_properties F ON F.major_id = E.object_id	AND F.minor_id = E.column_id
			                                        LEFT JOIN sys.extended_properties G ON G.major_id = E.object_id AND G.minor_id = '0'
	                                        ) H ON H.TableName = A.TABLE_NAME AND H.ColumnName = A.COLUMN_NAME
                                            WHERE A.TABLE_NAME = 'sys_server_info_mst'
	                                        ORDER BY A.TABLE_NAME ASC"    );
                var         result           = db.Query <TableSchema>(sql).ToList();
                var         resultDictionary = result.GroupBy(x => x.TableName).ToDictionary(k => k.Key, v => v.ToList());
                CultureInfo cultureInfo      = new CultureInfo("en", false);
                string      content          = string.Empty;

                foreach (KeyValuePair <String, List <TableSchema> > item in resultDictionary)
                {
                    // 表名去下划线 & 驼峰
                    string[] tableNameArray = item.Key.ToLower().Split('_');
                    string   nTableName     = string.Empty;
                    foreach (string n in tableNameArray)
                    {
                        nTableName += cultureInfo.TextInfo.ToTitleCase(n);
                    }

                    Directory.CreateDirectory("D:\\DapperEntities\\");
                    using (FileStream fs = new FileStream("D:\\DapperEntities\\" + nTableName + ".cs", FileMode.Create))
                    {
                        using (StreamWriter sw = new StreamWriter(fs, Encoding.UTF8))
                        {
                            content = string.Format(
                                @"/* 由DapperEntitiesCreate生成 */
using System;
using WCFServer.Data.DapperEx.Attributies;
namespace WCFServer.Data.DapperEx.Entities
{{
    /// <summary>
    /// {0} 【{1}】
    /// </summary>
    [Table(""{2}"")]
    public class {3}
    {{", nTableName, item.Value.FirstOrDefault().TableDec, item.Key, nTableName);

                            sw.WriteLine(content);

                            foreach (TableSchema colItem in item.Value)
                            {
                                string colType = string.Empty;
                                if (colItem.ColumnType.ToLower() == "nvarchar" || colItem.ColumnType.ToLower() == "nchar" || colItem.ColumnType.ToLower() == "varchar" || colItem.ColumnType.ToLower() == "text")
                                {
                                    colType = "string";
                                }
                                if (colItem.ColumnType.ToLower() == "int" || colItem.ColumnType.ToLower() == "smallint" || colItem.ColumnType.ToLower() == "tinyint")
                                {
                                    colType = "int";
                                }
                                if (colItem.ColumnType.ToLower() == "decimal" || colItem.ColumnType.ToLower() == "float")
                                {
                                    colType = "double";
                                }
                                if (colItem.ColumnType.ToLower() == "datetime" || colItem.ColumnType.ToLower() == "date")
                                {
                                    colType = "DateTime";
                                }

                                string[] colNameArray = colItem.ColumnName.ToLower().Split('_');
                                string   nColName     = string.Empty;
                                foreach (string n in colNameArray)
                                {
                                    nColName += cultureInfo.TextInfo.ToTitleCase(n);
                                }

                                content = string.Format(
                                    @"
        /// <summary>
        /// {0} 【{1}】
        /// </summary>", nColName, colItem.ColumnDec);
                                sw.WriteLine(content);

                                content = string.Format(
                                    @"        [{0}Column(""{1}"")]
        public {2} {3} {{ get; set; }}", colItem.IsPrimaryKey ? "Key, " : "", colItem.ColumnName, colType, nColName);
                                sw.WriteLine(content);
                            }
                            sw.WriteLine(
                                @"      }
}");
                        }
                    }
                }
            }
        }
示例#2
0
        /// <summary>
        /// 服务接口提供器
        /// </summary>
        /// <returns></returns>
        public List <ServiceInfo> ServiceProvider()
        {
            List <ServiceInfo> serviceInfoList = new List <ServiceInfo>();

            #region 0.默认数据
            string ip       = "localhost";
            int    port     = 1028;
            string endpoint = "json";
            #endregion

            #region 1.获取所有的服务接口及其实现类
            Dictionary <Type, Type> pairs = new Dictionary <Type, Type>();
            var  types = TypeHelper.GetIntfChildrens(typeof(IBaseContract));
            bool isPair = true;
            Type type1 = null, type2 = null;
            foreach (var type in types)
            {
                if (isPair)
                {
                    type1  = type;
                    isPair = false;
                }
                else
                {
                    type2 = type;
                    pairs.Add(type1, type2);
                    isPair = true;
                }
            }
            #endregion

            #region 2.本地与数据库融合
            using (var db = new DapperExContext())
            {
                var data = db.Query <SysServerInfoMst>().ToList();

                // 【删除】找出DB中存在,实际接口不存在的数据,并删除DB的该条记录
                foreach (var item in data)
                {
                    if (pairs.Count(x => x.Key.Name == item.IntfName && x.Value.Name == item.ImplName) == 0)
                    {
                        var delete = db.Delete <SysServerInfoMst>(x => x.IntfName == item.IntfName && x.ImplName == item.ImplName);
                    }
                }

                // 【新增】数据到DB、【设置】DB数据到本地
                foreach (var item in pairs)
                {
                    ServiceInfo serviceInfo = new ServiceInfo
                    {
                        IntfType  = item.Key,
                        ImplType  = item.Value,
                        LogAction = Console.WriteLine
                    };

                    var tmpPairs = data.Where(x => x.IntfName == item.Key.Name && x.ImplName == item.Value.Name).ToList();
                    if (tmpPairs.Count != 0)
                    {
                        serviceInfo.Config = new ServiceConfig
                        {
                            IP          = tmpPairs.FirstOrDefault().Ip,
                            Port        = tmpPairs.FirstOrDefault().Port.ToString(),
                            Endpoint    = tmpPairs.FirstOrDefault().Endpoint,
                            ServiceName = tmpPairs.FirstOrDefault().ServiceName
                        };
                    }
                    else
                    {
                        serviceInfo.Config = new ServiceConfig
                        {
                            IP          = ip,
                            Port        = port.ToString(),
                            Endpoint    = endpoint,
                            ServiceName = item.Value.Name + "服务接口"
                        };

                        SysServerInfoMst sysServerInfo = new SysServerInfoMst
                        {
                            IntfName    = item.Key.Name,
                            ImplName    = item.Value.Name,
                            ServiceName = item.Value.Name + "服务接口",
                            RowVersion  = 1,
                            Status      = "1",
                            CreateUser  = "******",
                            UpdateUser  = "******",
                            CreateTime  = DateTime.Now,
                            UpdateTime  = DateTime.Now,
                            Ip          = "localhost",
                            Port        = 1028,
                            Endpoint    = "json"
                        };
                        var insert = db.Insert <SysServerInfoMst>(sysServerInfo);
                    }
                    serviceInfoList.Add(serviceInfo);
                }
            }
            #endregion

            return(serviceInfoList);
        }