Program.cs 1.4 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152
  1. using OASystem.Domain.Entities;
  2. using OASystem.Domain.Entities.Customer;
  3. using OASystem.Domain.Entities.System;
  4. using SqlSugar;
  5. var db = new SqlSugarClient(new ConnectionConfig()
  6. {
  7. ConnectionString = "server=132.232.92.186;uid=sa;pwd=Yjx@158291;database=OA2023DB;",
  8. DbType = SqlSugar.DbType.SqlServer,
  9. IsAutoCloseConnection = true,
  10. InitKeyType = InitKeyType.Attribute
  11. });
  12. #region Aop
  13. //db.Aop.OnLogExecuting = (sql, pars) =>
  14. //{
  15. // Console.WriteLine(sql + "" + Db.Utilities.SerializeObject
  16. // (pars.ToDictionary(it => it.ParameterName, it => it.Value)));
  17. // Console.WriteLine();
  18. //};
  19. #endregion
  20. #region 对话框
  21. Console.WriteLine("是否确定同步数据库表结构?(同名数据表将会被备份,生产环境慎用,回车确认)");
  22. var str = Console.ReadKey();
  23. if (str.Key == ConsoleKey.Enter)
  24. {
  25. Console.WriteLine("同步中,请稍后...");
  26. }
  27. else
  28. {
  29. Console.WriteLine("\r\n输入错误,已退出...");
  30. return;
  31. }
  32. #endregion
  33. //同步数据表结构
  34. db.DbMaintenance.CreateDatabase();
  35. db.CodeFirst.SetStringDefaultLength(50).BackupTable().InitTables(new Type[]
  36. {
  37. //typeof(Sys_PageFunctionPermission)
  38. //,typeof(Sys_SystemMenuAndFunction)
  39. //,typeof(Sys_SystemMenuPermission)
  40. //,typeof (Sys_JobPostAuthority)
  41. //,typeof(Sys_UserAuthority)
  42. typeof(Crm_CustomerCert),
  43. typeof(Crm_CustomerCompany),
  44. typeof(Crm_CustomerFile),
  45. typeof(Crm_DeleClient)
  46. });
  47. Console.WriteLine("数据库结构同步完成!");