public MsSqlCloudFoundryService(IConfiguration configuration, IDatabaseBuilder databaseBuilder)
{
this.configuration = configuration;
this.databaseBuilder = databaseBuilder;
Service = new MsSqlService();
Id = Service.Id;
}
public MsSqlTests()
{
_loggerMock = new Mock <ILogService>();
_repoMock = new Mock <IMsSqlRepository>();
_msSqlService = new MsSqlService(_loggerMock.Object, _repoMock.Object);
_fixture = new Fixture();
}
private void btn_Refresh_Click(object sender, EventArgs e)
{
btn_Refresh.Enabled = false;
try
{
string connectionString = string.Concat("data source=", txb_Server.Text, ";user id=", txb_Username.Text, ";password=", txb_Password.Text);
IAdoService adoService = new MsSqlService();
cbb_Database.DataSource = adoService.GetAllDatabase(connectionString);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
btn_Refresh.Enabled = true;
}
private void Awake()
{
Debug.Log(Application.persistentDataPath);
Current = this;
StartCoroutine(LoadStyle());
Sql = new MsSqlService();
Image = new ImageService();
Excel = new ExcelService();
Application.logMessageReceived += (string condition, string stackTrace, LogType type) =>
{
if (type == LogType.Error)
{
#if !UNITY_EDITOR
Desktop.OpenNew <DialogForm>().SetDialog(() => Application.Quit(), "系统内部错误", condition);
#endif
}
};
}
public async Task <bool> ContainsAsync(string keyword = "")
{
return(await Task <bool> .Factory.StartNew(() =>
{
lock (_lockerFilter)
{
_filterList = new List <VirtualListItem>();
if (string.IsNullOrEmpty(keyword))
{
return false;
}
var lowerKeyword = keyword.ToLower();
var players = MsSqlService.SearchPlayerForClkTag(lowerKeyword);
foreach (var player in players)
{
if (_list.ContainsKey(player.Id))
{
continue;
}
var rus = $"{player.FirstnameRus} {player.LastnameRus}";
var eng = $"{player.FirstnameEng} {player.LastnameEng}";
var rusTrans = Transliteration.Front(rus);
var sub = GetSubText(rus, lowerKeyword) ?? (GetSubText(eng, lowerKeyword) ?? GetSubText(rusTrans, lowerKeyword));
if (sub == null)
{
return false;
}
var item = new VirtualListItem(player.Id, sub.Value.origin, player);
item.UpdateColorText(sub.Value.left, sub.Value.centr, sub.Value.right);
_filterList.Add(item);
}
return _filterList.Count > 0;
}
}));
}
public async Task <bool> ContainsAsync(string keyword = "")
{
return(await Task <bool> .Factory.StartNew(() =>
{
lock (_lockerFilter)
{
_filterList = new List <VirtualListItem>();
if (string.IsNullOrEmpty(keyword))
{
return false;
}
var lowerKeyword = keyword.ToLower();
var gender = Interlocked.Read(ref _gender);
var teams = MsSqlService.SearchTeamsForClkTag(lowerKeyword, (int)gender);
foreach (var teamData in teams)
{
var rus = teamData.NameRus;
var eng = teamData.NameEng;
var rusTrans = Transliteration.Front(rus);
var sub = GetSubText(rus, lowerKeyword) ?? (GetSubText(eng, lowerKeyword) ?? GetSubText(rusTrans, lowerKeyword));
if (sub == null)
{
continue;
}
var item = new VirtualListItem(teamData.Id, sub.Value.origin, teamData);
item.UpdateColorText(sub.Value.left, sub.Value.centr, sub.Value.right);
_filterList.Add(item);
}
return _filterList.Count > 0;
}
}));
}
public async Task InitAsync()
{
await Task.Factory.StartNew(() =>
{
MsSqlService.GetUserList();
_indexSearchStringList = new SearchStringList(true);
_list = new ConcurrentDictionary <int, VirtualListItem>();
for (var index = 0; index < Uniso.InStat.User.List.Count; index++)
{
Uniso.InStat.User item = Uniso.InStat.User.List[index];
if (!string.IsNullOrEmpty(item.Login))
{
var user = new User(index, item.Login);
_list.TryAdd(index, user);
_indexSearchStringList.Add(user.ToString());
}
}
});
await ContainsAsync();
}
public EnterpriseSql(string _connectionString)
{
_mssqlService = new MsSqlService(_connectionString);
}
static void Main(string[] args)
{
try
{
var argList = ReadArgs(args);
if (argList == null)
{
return;
}
var dbType = GetSwitchInput(argList, "-t", "Database Type:\n1. SQL Server\n2. MySQL\n3. PostgreSQL", new Dictionary <string, string> {
{ "1", _msSql }, { "2", _mySql }, { "3", _postgreSql }
});
var connectionString = GetInput(argList, "-c", "ConnectionString:", optional: true);
var skip = !string.IsNullOrWhiteSpace(connectionString);
var setting = new DatabaseSettingModel
{
ConnectionString = connectionString,
DbType = dbType,
HostString = GetInput(argList, "-s", "Server name or IP address:", skip: skip),
DatabaseName = GetInput(argList, "-d", "Database name:", skip: skip && dbType == _msSql),
UserName = GetInput(argList, "-u", "Username:"******"-p", "Password:"******"Can't get any table info");
}
IExporter exporter = new HtmlExporter();
var stream = exporter.Export(setting, tableInfos);
stream.Seek(0, SeekOrigin.Begin);
using (var fileStream = new FileStream($"{setting.DatabaseName}.html", FileMode.Create))
{
stream.CopyTo(fileStream);
}
}
catch (Exception e)
{
Console.WriteLine(e.ToString());
System.Threading.Thread.Sleep(5000);
}
}
public DoctorsController(MsSqlService service)
{
_service = service;
}
private void cbDatabase_DropDownOpened(object sender, EventArgs e)
{
cbDatabase.ItemsSource = new List <string> {
"<Loading databases>"
};
var sel = Enum.Parse <ConnectionProvider>(cbProvider.SelectedItem.ToString());
try
{
switch (sel)
{
case ConnectionProvider.MsSql:
var conInfo = new MsSqlConnectionInfo
{
Server = txtServer.Text,
Port = Convert.ToInt32(string.IsNullOrWhiteSpace(txtPort.Text) ? "-1" : txtPort.Text),
TrustedConnection = chkIntegratedSecurity.IsChecked.Value,
Username = txtUsername.Text,
Password = txtPassword.Password
};
var mssql = new MsSqlService();
cbDatabase.ItemsSource = mssql.LoadDatabase(conInfo);
break;
case ConnectionProvider.PostgreSql:
var npgInfo = new NpgConnectionInfo
{
Server = txtServer.Text,
Port = Convert.ToInt32(string.IsNullOrWhiteSpace(txtPort.Text) ? "-1" : txtPort.Text),
TrustedConnection = chkIntegratedSecurity.IsChecked.Value,
Username = txtUsername.Text,
Password = txtPassword.Password
};
var npgsql = new NpgService();
cbDatabase.ItemsSource = npgsql.LoadDatabase(npgInfo);
break;
case ConnectionProvider.MySql:
if (chkIntegratedSecurity.IsChecked == true)
{
throw new InvalidOperationException("Integrated Security doesnt supported by MySql Server");
}
var myInfo = new MySqlConnectionInfo
{
Server = txtServer.Text,
Port = Convert.ToInt32(string.IsNullOrWhiteSpace(txtPort.Text) ? "-1" : txtPort.Text),
Username = txtUsername.Text,
Password = txtPassword.Password
};
var mysql = new MySqlService();
cbDatabase.ItemsSource = mysql.LoadDatabase(myInfo);
break;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
