private async void Button_SaveSettings_Click(object sender, Windows.UI.Xaml.RoutedEventArgs e)
{
try
{
Progress.IsActive = true;
var settingModel = new SettingsModel()
{
Notification = this.toggleNot.IsOn,
NotificationVibration = this.ToggleNotVibration.IsOn,
NotificationSound = this.ToggleNotSound.IsOn
};
await DataSyncHelper.SaveSettingsInOneDrive(settingModel);
InfoText.Text = "Settings Saved in OneDrive";
}
catch (Exception ex)
{
InfoText.Text = $"OOPS! An error ocurred: {ex.GetMessage()}";
}
finally
{
Progress.IsActive = false;
}
}
public void UpdateSql()
{
DataSyncHelper objDataSyncHelper = new DataSyncHelper("OpenConnectionString");
string updateQuery = objDataSyncHelper.CreateSyncQuery("Sys_Module", "ModuleTypeID='" + ModuleID + "'", "", true);
string SqlFileName = "Seven" + DateTime.Now.ToString("yyyy-MM-dd-hh") + ".sql";
Response.ContentEncoding = System.Text.Encoding.UTF8;
Response.AppendHeader("Content-Disposition", "attachment;filename=" + SqlFileName);
Response.Write(updateQuery);
Response.End();
}
protected override async Task ExecuteAsync(CancellationToken stoppingToken)
{
if (string.IsNullOrEmpty(_Worker36Model.Worker36))
{
return;
}
while (!stoppingToken.IsCancellationRequested)
{
try
{
await DataSyncHelper.Sync(_Worker36Model.MasterDB, _Worker36Model.Worker36);
}
catch (Exception ex)
{
_logger.LogError(ex.Message);
}
_logger.LogInformation($"{typeof(Worker36)} running at: {DateTime.Now}");
await Task.Delay(_Worker36Model.Interval, stoppingToken);
}
}
private async void Page_Loading(FrameworkElement sender, object args)
{
try
{
Progress.IsActive = true;
var settingModel = await DataSyncHelper.GetSettingsInOneDrive();
this.toggleNot.IsOn = settingModel.Notification;
this.ToggleNotVibration.IsOn = settingModel.NotificationVibration;
this.ToggleNotSound.IsOn = settingModel.NotificationSound;
InfoText.Text = "Settings Loaded from OneDrive";
}
catch (Exception ex)
{
InfoText.Text = $"OOPS! An error ocurred: {ex.GetMessage()}";
}
finally
{
Progress.IsActive = false;
}
}
private void BtnSync_Click(object sender, EventArgs e)
{
string sourceconnstr = GetSourceConnStr;
string destconnstr = GetDestConnStr;
string soucretable = GetSourceTBName;
string[] fields = GetDestFields;
string keyfield = GetKeyField;
//prefix = "";
string desttable = GetDestTBName;
//DataSyncHelper.Clear(sourceconnstr, soucretable, destconnstr,desttable,redisconnstr);
Stopwatch sw = new Stopwatch();
sw.Start();
try
{
using (SqlConnection conn = new SqlConnection(GetSourceConnStr))
{
using (var cmd = conn.CreateCommand())
{
conn.Open();
cmd.CommandType = CommandType.Text;
cmd.CommandText = GetKeyColumnsSql;
cmd.Parameters.Add(new SqlParameter("@TABLE_NAME", GetSourceTBName));
using (var reader = cmd.ExecuteReader())
{
int readcont = 0;
while (reader.Read())
{
var colname = (string)reader.GetValue(0);
if (colname != GetKeyField)
{
throw new Exception($"{GetKeyField}不是主键");
}
readcont++;
}
if (readcont == 0)
{
throw new Exception($"{GetKeyField}不是主键");
}
}
}
}
var col = GetByCol;
if (col.TypeName.IndexOf("timestamp", StringComparison.OrdinalIgnoreCase) > -1)
{
var boo = DataSyncHelper.SyncSQLDBDataByTimeStamp(sourceconnstr, soucretable, fields, col.Name
, keyfield, destconnstr, desttable, 0);
}
else if (col.TypeName.IndexOf("datetime", StringComparison.OrdinalIgnoreCase) > -1)
{
var boo = DataSyncHelper.SyncSQLDBDataByTime(sourceconnstr, soucretable, fields, col.Name
, keyfield, destconnstr, desttable, 0);
}
else if (col.TypeName.IndexOf("int", StringComparison.OrdinalIgnoreCase) > -1)
{
var boo = DataSyncHelper.SyncSQLDBDataByNumberCol(sourceconnstr, soucretable, fields, col.Name
, keyfield, destconnstr, desttable, 0);
}
else
{
var boo = DataSyncHelper.SyncSQLDBDataByStrCol(sourceconnstr, soucretable, fields, col.Name
, keyfield, destconnstr, desttable, 0);
}
MessageBox.Show("同步成功");
}
catch (Exception ex)
{
Trace.TraceError(ex.ToString());
MessageBox.Show("出错:" + ex.Message);
}
sw.Stop();
}
