Web_HotelServices_Prod/WebUI/Program.cs

using Aliyun.Api.LogService.Domain.Log;
using COMMON;
using DB_Server;
using Microsoft.AspNetCore.Hosting;
using Microsoft.Extensions.DependencyInjection;
using Microsoft.Extensions.Hosting;
using Microsoft.Extensions.Logging;
using Models;
using Models.Data;
using Models.Models.LOGDB;
using Serilog;
using SERVER;
using SERVER.LIB;
using System;
using System.Diagnostics;
using System.Security.Cryptography;
using System.Text;
using System.Threading.Tasks;
using UtilsSharp;

namespace WebUI
{
    /// <summary>
    /// <20><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>
    /// </summary>
    public class Program
    {
        /// <summary>
        /// <20><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>
        /// </summary>
        /// <param name="args"></param>
        public static  void Main(string[] args)
        {
            
            var host = CreateHostBuilder(args).Build();
            CreateDbIfNotExists(host);
            host.Run();
            
        }
        /// <summary>
        /// <20><>һ<EFBFBD><D2BB><EFBFBD><EFBFBD><EFBFBD>и<EFBFBD>Ӧ<EFBFBD><D3A6>ʱ<EFBFBD><CAB1><EFBFBD>ᴴ<EFBFBD><E1B4B4><EFBFBD><EFBFBD><EFBFBD>ݿⲢʹ<E2B2A2>ò<EFBFBD><C3B2><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ݼ<EFBFBD><DDBC>ظ<EFBFBD><D8B8><EFBFBD><EFBFBD>ݿ⡣ ÿ<><C3BF><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ģ<EFBFBD>ͷ<EFBFBD><CDB7><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ʱ<EFBFBD><CAB1>
        /// ɾ<><C9BE><EFBFBD><EFBFBD><EFBFBD>ݿ⡣
        /// <20><><EFBFBD><EFBFBD> Seed <20><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ʹ<EFBFBD><CAB9><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ݿ<EFBFBD><DDBF><EFBFBD><EFBFBD>¿<EFBFBD>ʼ<EFBFBD><CABC>
        /// </summary>
        /// <param name="host"></param>
        private static void CreateDbIfNotExists(IHost host)
        {
            // <20><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>Ƶ<EFBFBD>   ͬ<><CDAC><EFBFBD><EFBFBD><EFBFBD><EFBFBD>
            Task.Run(() => {
                ASLS sLS = new ASLS();
                sLS.Init_();
                sLS.Init();

                //var logs = new LogInfo();
                //logs.Contents.Add("info", "11");
                //var logs_ = new LogInfo();
                //logs_.Contents.Add("renark", "22");
                //Debug.Write( sLS.write("rucs-eventlogging-db", logs, logs_).Result);
            });

            using (var scope = host.Services.CreateScope())
            {
                var services = scope.ServiceProvider;

                try
                {
                    var context = services.GetRequiredService<HotelServiceContext>();
                    context.Database.EnsureCreated();
                    var log = services.GetRequiredService<LOG_DBContext>();
                    log.Database.EnsureCreated();
                    DbInitializer.Initialize(context);

                    #region <EFBFBD>޸<EFBFBD>mysql <EFBFBD><EFBFBD>datetime  <EFBFBD>ĺ<EFBFBD><EFBFBD><EFBFBD>  <EFBFBD><EFBFBD><EFBFBD><EFBFBD>
                    if (ConfigEntity.Instance.DBTYPE == 2)
                    {
                        var db = new DbHelperSQL(DbHelperSQL.DBSel.BLV_RCU_DB);
                        var data = DataTableHelper.ToEntities<MysqlModel>(db.ExecuteTable(
                             $@"SELECT
                       table_name tablename,
                       column_name columnName,
                       data_type dataType 
                       FROM
                       information_schema.COLUMNS 
                       WHERE
                       table_schema = ( SELECT DATABASE ( ) ) 
                       and DATA_TYPE = 'datetime' 
                       ORDER BY
                       ordinal_position "
                             ));
                        foreach (var item in data)
                        {
                            db.ExecuteSql($"ALTER TABLE {item.tablename} MODIFY {item.columnName} datetime(3)");
                        }

                        var dblog = new DbHelperSQL(DbHelperSQL.DBSel.LogDB);
                        data = DataTableHelper.ToEntities<MysqlModel>(dblog.ExecuteTable(
                          $@"SELECT
                       table_name tablename,
                       column_name columnName,
                       data_type dataType 
                       FROM
                       information_schema.COLUMNS 
                       WHERE
                       table_schema = ( SELECT DATABASE ( ) ) 
                       and DATA_TYPE = 'datetime' 
                       ORDER BY
                       ordinal_position "
                          ));
                        foreach (var item in data)
                        {
                            dblog.ExecuteSql($"ALTER TABLE {item.tablename} MODIFY {item.columnName} datetime(3)");
                        }
                    }
                    #endregion
                    
                    SYNC_DATA.SYNC_DATA_ALL();
                }
                catch (Exception ex)
                {
                    var logger = services.GetRequiredService<ILogger<Program>>();
                    logger.LogError(ex, "An error occurred creating the DB.");
                }
            }
        }
        /// <summary>
        /// <20><><EFBFBD><EFBFBD>web<65><62>Ŀ
        /// </summary>
        /// <param name="args"></param>
        /// <returns></returns>
        public static IHostBuilder CreateHostBuilder(string[] args) =>
            Host.CreateDefaultBuilder(args).UseSerilog()
                .ConfigureWebHostDefaults(webBuilder =>
                {
                    webBuilder.UseStartup<Startup>();
                });
    }
}