private void createBackup()
{
ReportsSetting reportSetting = ReportsSettingController.instance().getByProgramName("DBBackup");
if (reportSetting.NextDateCreated == null)
{
return;
}
DateTime nextDate = (DateTime)reportSetting.NextDateCreated;
DateTime current = DateTime.Now;
if (current < nextDate)
{
return;
}
try
{
DataBase.Backup(reportSetting.ReportPath);
reportSetting.save();
}
catch (Exception ex)
{
Log.WriteError("В ходе создания резервной копии произошли ошибки!\n" + ex.Message);
}
}
protected override void populate(SQLiteDataReader reader)
{
ReportsSetting reportsSetting = new ReportsSetting();
reportsSetting.Id = reader.GetInt32(0);
reportsSetting.ProgramName = reader.GetString(1);
reportsSetting.ReportName = reader.GetString(2);
if (!reader.IsDBNull(3))
{
reportsSetting.ReportPath = reader.GetString(3);
}
if (!reader.IsDBNull(4))
{
reportsSetting.Period = reader.GetString(4);
}
if (!reader.IsDBNull(5))
{
reportsSetting.Day = reader.GetInt32(5);
}
if (!reader.IsDBNull(6))
{
reportsSetting.Time = reader.GetString(6);
}
if (!reader.IsDBNull(7))
{
reportsSetting.NextDateCreated = reader.GetDateTime(7);
}
add(reportsSetting);
}
private void createWriteoffReportPeriod()
{
ReportsSetting reportSetting = ReportsSettingController.instance().getByProgramName("WriteoffReport");
if (reportSetting.NextDateCreated == null)
{
return;
}
DateTime nextDate = (DateTime)reportSetting.NextDateCreated;
DateTime current = DateTime.Now;
if (current < nextDate)
{
return;
}
DateTime prev = new DateTime(current.Year, current.Month, 1, 0, 0, 0);
Reports.WriteoffReport report = new Reports.WriteoffReport();
report.Postfix = "сформирован автоматически, " + current.ToString("dd.MM.yyyy HH_mm_ss");
report.H1 = "Журнал списания с " + prev.ToString("dd.MM.yyyy") + " по " + nextDate.ToString("dd.MM.yyyy") + " (сформирован автоматически, " + current.ToString("dd.MM.yyyy HH:mm:ss") + ")";
if (report.Save(prev, nextDate))
{
reportSetting.save();
}
}
private void cbxWeekDay_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
System.Windows.Controls.ComboBox comboBox = sender as System.Windows.Controls.ComboBox;
if (comboBox == null)
{
return;
}
DataGridRow dgrow = FindItem.FindParentItem <DataGridRow>(comboBox);
if (dgrow == null)
{
return;
}
ReportsSetting reportsSetting = (ReportsSetting)dgrow.Item;
if (reportsSetting == null)
{
return;
}
if (comboBox.SelectedValue == null)
{
return;
}
if (reportsSetting.Period == comboBox.SelectedValue.ToString())
{
return;
}
reportsSetting.Day = Int32.Parse(comboBox.SelectedValue.ToString());
reportsSetting.Time = "";
}
private void Button_Click(object sender, RoutedEventArgs e)
{
System.Windows.Controls.Button button = sender as System.Windows.Controls.Button;
if (button == null)
{
return;
}
DataGridRow dgrow = FindItem.FindParentItem <DataGridRow>(button);
if (dgrow == null)
{
return;
}
ReportsSetting reportsSetting = (ReportsSetting)dgrow.Item;
if (reportsSetting == null)
{
return;
}
var dlg = new System.Windows.Forms.FolderBrowserDialog();
System.Windows.Forms.DialogResult result = dlg.ShowDialog(this.GetIWin32Window());
if (result == System.Windows.Forms.DialogResult.OK)
{
reportsSetting.ReportPath = dlg.SelectedPath;
//reportsSetting.save();
}
}
public string getPathByProgramName(string program_name)
{
ReportsSetting reportsSetting = _collection.Where(x => x.ProgramName == program_name).FirstOrDefault();
if (reportsSetting != null)
{
return(reportsSetting.ReportPath);
}
return("");
}
public bool add <T>(T model)
{
try
{
ReportsSetting reportsSetting = model as ReportsSetting;
_collection.Add(reportsSetting);
return(true);
}
catch (Exception ex)
{
Log.WriteError(ex.Message);
return(false);
}
}
public bool remove <T>(T model)
{
try
{
ReportsSetting reportsSetting = model as ReportsSetting;
if (_collection.Contains(reportsSetting))
{
_collection.Remove(reportsSetting);
}
return(true);
}
catch (Exception ex)
{
Log.WriteError(ex.Message);
return(false);
}
}
private void tbxTime_ValueChanged(object sender, RoutedPropertyChangedEventArgs <object> e)
{
TimePicker timePicker = sender as TimePicker;
if (timePicker == null)
{
return;
}
DataGridRow dgrow = FindItem.FindParentItem <DataGridRow>(timePicker);
if (dgrow == null)
{
return;
}
ReportsSetting reportsSetting = (ReportsSetting)dgrow.Item;
if (reportsSetting == null)
{
return;
}
reportsSetting.Time = timePicker.Text;
}
private void createAvailabilityReportPeriod()
{
ReportsSetting reportSetting = ReportsSettingController.instance().getByProgramName("AvailabilityReport");
if (reportSetting.NextDateCreated == null)
{
return;
}
DateTime nextDate = (DateTime)reportSetting.NextDateCreated;
DateTime current = DateTime.Now;
if (current < nextDate)
{
return;
}
Reports.AvailabilityReport report = new Reports.AvailabilityReport();
report.Postfix = "сформирован автоматически";
report.H1 = "Отчет наличия на " + nextDate.ToString("dd.MM.yyyy") + " (сформирован автоматически, " + current.ToString("dd.MM.yyyy HH:mm:ss") + ")";
if (report.Save())
{
reportSetting.save();
}
}
private void Button_Click_1(object sender, RoutedEventArgs e)
{
System.Windows.Controls.Button button = sender as System.Windows.Controls.Button;
if (button == null)
{
return;
}
DataGridRow dgrow = FindItem.FindParentItem <DataGridRow>(button);
if (dgrow == null)
{
return;
}
ReportsSetting reportsSetting = (ReportsSetting)dgrow.Item;
if (reportsSetting == null)
{
return;
}
if (!reportsSetting.save())
{
System.Windows.MessageBox.Show("Не удалось сохранить настройку отчета. Подробности см. в логе ошибок!");
}
else
{
if (reportsSetting.NextDateCreated != null)
{
System.Windows.MessageBox.Show("Настройка выгрузки сохранена.\nСледующая дата выгрузки " + ((DateTime)reportsSetting.NextDateCreated).ToString());
}
else
{
System.Windows.MessageBox.Show("Настройка выгрузки сохранена.\nСледующая дата выгрузки - не установлено.");
}
}
}
