private ExcelSheetDiffConfig CreateDiffConfig(FileSetting srcFileSetting, FileSetting dstFileSetting, bool isStartup)
{
var config = new ExcelSheetDiffConfig();
config.SrcSheetIndex = SrcSheetCombobox.SelectedIndex;
config.DstSheetIndex = DstSheetCombobox.SelectedIndex;
if (srcFileSetting != null)
{
if (isStartup)
{
config.SrcSheetIndex = GetSheetIndex(srcFileSetting, SrcSheetCombobox.Items);
}
config.SrcHeaderIndex = srcFileSetting.ColumnHeaderIndex;
}
if (dstFileSetting != null)
{
if (isStartup)
{
config.DstSheetIndex = GetSheetIndex(dstFileSetting, DstSheetCombobox.Items);
}
config.DstHeaderIndex = dstFileSetting.ColumnHeaderIndex;
}
return(config);
}
private void OpenEditorWindow(FileSetting fileSetting)
{
if (fileSetting == null)
{
fileSetting = new FileSetting();
}
var vm = new FileSettingEditorWindowViewModel(fileSetting, FileSettings);
var window = new FileSettingEditorWindow()
{
DataContext = vm
};
window.ShowDialog();
if (!vm.IsDone || fileSetting.Equals(vm.FileSetting))
{
return;
}
var index = FileSettings.IndexOf(fileSetting);
if (index >= 0)
{
RemoveFileSetting(fileSetting);
FileSettings.Insert(index, vm.FileSetting);
}
else
{
FileSettings.Add(vm.FileSetting);
}
IsDirty = true;
UpdateView();
}
private Tuple <FileSetting, FileSetting> FindFileSettings(bool isStartup)
{
FileSetting srcSetting = null;
FileSetting dstSetting = null;
var srcPath = SrcPathTextBox.Text;
var dstPath = DstPathTextBox.Text;
if (!IgnoreFileSettingCheckbox.IsChecked.Value)
{
srcSetting =
FindFilseSetting(Path.GetFileName(srcPath), SrcSheetCombobox.SelectedIndex, SrcSheetCombobox.SelectedItem.ToString(), isStartup);
dstSetting =
FindFilseSetting(Path.GetFileName(dstPath), DstSheetCombobox.SelectedIndex, DstSheetCombobox.SelectedItem.ToString(), isStartup);
diffConfig = CreateDiffConfig(srcSetting, dstSetting, isStartup);
}
else
{
diffConfig = new ExcelSheetDiffConfig();
diffConfig.SrcSheetIndex = Math.Max(SrcSheetCombobox.SelectedIndex, 0);
diffConfig.DstSheetIndex = Math.Max(DstSheetCombobox.SelectedIndex, 0);
}
return(Tuple.Create(srcSetting, dstSetting));
}
public void OnFileSettingUpdated(DiffViewEventArgs <FastGridControl> e, FileSetting fileSetting)
{
if (e.Sender != e.Container.Resolve <FastGridControl>(Key))
{
return;
}
if (fileSetting != null)
{
var model = e.Sender.Model as DiffGridModel;
if (model != null)
{
model.SetColumnHeader(fileSetting.ColumnHeaderIndex);
if (string.IsNullOrEmpty(fileSetting.RowHeaderName))
{
model.SetRowHeader(fileSetting.RowHeaderIndex);
}
else
{
model.SetRowHeader(fileSetting.RowHeaderName);
}
}
e.Sender.MaxRowHeaderWidth = fileSetting.MaxRowHeaderWidth;
}
}
public void ExportAndImportBinary()
{
var name = $"test.{Constants.Binary.Extension}";
var setting = new FileSetting {
Location = _path, Name = name
};
var data = new Dictionary <string, object>();
data.Add("string", "test-data");
data.Add("int", 123);
// act & assert export
var result = _io.Exporter(Constants.Binary.Key)
.Setup(setting)
.Build(data)
.Export();
Assert.IsNotNull(result, "binary export failed");
// act & assert import
var importedData = _io.Importer(Constants.Binary.Key)
.Setup(setting)
.Import()
.As <Dictionary <string, object> >();
Assert.AreEqual(data["string"], importedData["string"], "binary import string key failed");
Assert.AreEqual(data["int"], importedData["int"], "binary import int key failed");
Log.Info("binary success", this);
}
private void EditSelectedFiles(DataGrid grid)
{
var index = grid.SelectedIndex;
if (index >= 0 && index < _SelectedFiles.Count)
{
FileSetting fileSetting = _SelectedFiles[index];
var cloneFileSetting = (FileSetting)fileSetting.Clone();
if (fileSetting != null)
{
FileWindow window = new FileWindow(fileSetting)
{
Owner = this
};
var result = window.ShowDialog();
if (result == true)
{
RefreshGrid();
}
else
{
_SelectedFiles[index] = cloneFileSetting;
}
}
}
}
public ActionResult DeleteConfirmed(string id)
{
FileSetting fileSetting = db.FileSettings.Find(id);
db.FileSettings.Remove(fileSetting);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public FileWindow(FileSetting fileSetting)
{
InitializeComponent();
FileSetting = fileSetting ?? new FileSetting();
if (FileSetting.Output == null)
{
FileSetting.Output = new List <OutputColumn>();
}
InitUI();
}
/// <summary>
/// Reads a file item from the configuration node and returns a new instance of FileSetting.
/// </summary>
/// <param name="node">The XmlNode to read from.</param>
/// <returns>A FileSetting initialized with values read from the node.</returns>
protected FileSetting ReadFileItem(XmlNode node)
{
// Create a FileSetting instance.
FileSetting Item = new FileSetting();
// Read the typical attributes.
ReadChildItem(node, Item);
return(Item);
}
public ActionResult Edit([Bind(Include = "Id,IsImage,Path,ImgSmallPath,ImgBigPath,Size,Format,Name,ImgWidth,ImgHeight,ImgPreviewWidth,ImgPreviewHeight,ImgPreviewRatio,X1,Y1,X2,Y2,W,H,ImgX1,ImgY1,ImgX2,ImgY2,ImgCropWidth,ImgCropHeight,Title,ViewType,DownloadCount,ViewCount,Description")] FileSetting fileSetting)
{
if (ModelState.IsValid)
{
db.Entry(fileSetting).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(fileSetting));
}
public FileSettingEditorWindowViewModel(FileSetting fileSetting, List <FileSetting> fileSettings)
{
this.fileSettings = fileSettings;
this.originalName = fileSetting.Name;
FileSetting = fileSetting.Clone();
CancelCommand = new DelegateCommand <Window>(Cancel);
ApplyCommand = new DelegateCommand <Window>(Apply);
}
/// <summary>
/// modify fileSetting
/// </summary>
/// <param name="fileSetting">fileSetting</param>
/// <returns></returns>
public bool ModifyFileSetting(FileSetting fileSetting)
{
var sql = @"UPDATE public.filesettings
SET keyname=@keyname, filename=@filename, filepath=@filepath, fileencoding=@fileencoding, validate=@validate
WHERE id=@id;" ;
using (var con = new NpgsqlConnection(_connectionString))
{
return(con.Execute(sql, fileSetting) > 0);
}
}
/// <summary>
/// add emailSetting
/// </summary>
/// <param name="fileSetting">fileSetting</param>
/// <returns></returns>
public bool AddFileSetting(FileSetting fileSetting)
{
var sql = @"INSERT INTO public.filesettings(keyname, filename, filepath, fileencoding, validate,createon)
VALUES (@keyname, @filename, @filepath, @fileencoding, @validate,@createon);" ;
using (var con = new NpgsqlConnection(_connectionString))
{
fileSetting.CreateOn = DateTime.Now;
return(con.Execute(sql, fileSetting) > 0);
}
}
public static IFileManager CreateFileManager(FileInfo fileInfo, FileSetting fileConfig, FileType fileType)
{
if (fileType == FileType.Excel)
{
return(new ExcelFileManager(fileInfo, fileConfig));
}
else
{
return(new CsvFileManager(fileInfo, fileConfig));
}
}
// -- methods
public IImportable Setup(SettingsBase setting)
{
if (setting is FileSetting)
{
_setting = setting as FileSetting;
}
else
{
Log.Error($"The setting has the wrong type and was not accepted.", this);
}
return(this);
}
public void AddToSetting(FileSetting fileSetting)
{
var querySettings = fileSettings.FindAll(x => string.Equals(x.Extension, fileSetting.Extension));
if (querySettings != null && querySettings.Count > 0)
{
querySettings.FirstOrDefault().DirectoryPath = fileSetting.DirectoryPath;
}
else
{
fileSettings.Add(fileSetting);
}
}
public IActionResult ModifyFileSetting([FromBody] FileSetting FileSetting)
{
try
{
_logger.LogInformation($"modify Filesetting,keyname={FileSetting.KeyName}");
return(new JsonResult(new { result = true, data = _fileProvider.ModifyFileSetting(FileSetting) }));
}
catch (Exception exc)
{
_logger.LogCritical(exc, exc.Message);
return(new JsonResult(new { result = false, message = exc.Message }));
}
}
// GET: FileSettings/Delete/5
public ActionResult Delete(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
FileSetting fileSetting = db.FileSettings.Find(id);
if (fileSetting == null)
{
return(HttpNotFound());
}
return(View(fileSetting));
}
public QlikViewSetup(
IEnumerable <QlikViewServiceInfo> serviceInfos,
DirectorySetting userDocDirectory,
DirectorySetting qvsLogDirectory,
FileSetting qvsEventLogFile,
FileSetting qvsSessionLogFile,
DirectorySetting qdsDirectory)
{
ServiceInfos = serviceInfos.ToArray();
UserDocDirectory = userDocDirectory;
QvsLogDirectory = qvsLogDirectory;
QvsEventLogFile = qvsEventLogFile;
QvsSessionLogFile = qvsSessionLogFile;
QdsDirectory = qdsDirectory;
}
/// <summary>
/// send email
/// </summary>
/// <param name="content">email content</param>
/// <param name="emailSetting">email setting</param>
/// <returns></returns>
bool SendEmail(string content, FileSetting fileSetting)
{
try
{
var file = Path.Combine(string.IsNullOrEmpty(fileSetting.FilePath) ? Path.GetDirectoryName(Process.GetCurrentProcess().MainModule.FileName) : fileSetting.FilePath, fileSetting.FileName);
File.WriteAllText(file, content, Encoding.GetEncoding(fileSetting.FileEncoding));
_logger.LogInformation($"sava file success");
return(true);
}
catch (Exception exc)
{
_logger.LogCritical(exc, $"sava file failure");
return(false);
}
}
public static bool Contains(this FileSettings settings, FileSetting comparer)
{
if (settings == null)
{
return(false);
}
foreach (var setting in settings.Settings)
{
if (setting.RoleId == comparer.RoleId)
{
return(true);
}
}
return(false);
}
public ColumnWindow(FileSetting setting)
{
InitializeComponent();
Settings = setting;
var items = Helper.GetEncodingList();
comboBoxEncoding.ItemsSource = items;
if (Settings != null)
{
comboBoxEncoding.SelectedValue = items.FirstOrDefault(x => x.ID == Settings.FileEncoding).ID;
var row = Settings.GetRow();
if (row != null)
{
Columns = row.Select(x => new ColumnSetting()
{
Column = x,
Export = true,
Key = false
}).ToArray();
bool excelIndex = checkBoxExcelIndex.IsChecked == true;
for (int i = 0; i < Columns.Length; i++)
{
Columns[i].Index = i;
Columns[i].ColumnIndex = (excelIndex) ? Helper.GetExcelColumnName(i + 1).PadRight(5) : (i + 1).ToString().PadRight(5);
if (Settings.Output != null && Settings.Output.Any())
{
if (Settings.KeyColumn.SourceNumber == i)
{
Columns[i].Key = true;
}
var col = Settings.Output.FirstOrDefault(x => x.SourceNumber == i);
Columns[i].Export = col != null;
Columns[i].ColumnName = col?.Name;
Columns[i].EmptyTest = col?.IsEmptyTest == true;
}
}
if (Columns != null && Columns.Any() && !Columns.Any(x => x.Key))
{
Columns[0].Key = true;
}
}
}
CheckSelectAll();
RefreshGrid();
}
private void btnConfirm_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(tbExtension.Text) && !string.IsNullOrEmpty(tbTargetDirectory.Text))
{
FileSetting fileSetting = new FileSetting()
{
DirectoryPath = tbTargetDirectory.Text,
Extension = tbExtension.Text,
};
AddToSetting(fileSetting);
SetListBoxShow();
}
else
{
MessageBox.Show("請輸入正確副檔名及檔案預儲存位置");
}
}
private FileSetting FindFileSettings(bool isStartup, string filePath)
{
FileSetting fileSetting = null;
if (!IgnoreFileSettingCheckbox.IsChecked.Value)
{
fileSetting =
FindFilseSetting(Path.GetFileName(filePath), SrcSheetCombobox.SelectedIndex, SrcSheetCombobox.SelectedItem.ToString(), isStartup);
}
else
{
diffConfig = new ExcelSheetDiffConfig();
diffConfig.SrcSheetIndex = Math.Max(SrcSheetCombobox.SelectedIndex, 0);
diffConfig.DstSheetIndex = Math.Max(DstSheetCombobox.SelectedIndex, 0);
}
return(fileSetting);
}
public void Close()
{
if (MainClass.Workspace != null)
{
if (MainClass.Workspace.WorkspaceUserSetting.FilesSetting == null)
{
MainClass.Workspace.WorkspaceUserSetting.FilesSetting = new List <FileSetting>();
}
//FileSetting fs = MainClass.Workspace.WorkspaceUserSetting.FilesSetting.Find(x=> x.FileName == fileName);
if (fileSeting != null)
{
MainClass.Workspace.WorkspaceUserSetting.FilesSetting.Remove(fileSeting);
}
fileSeting = new FileSetting(fileName);
foreach (FoldSegment fold in this.editor.Document.FoldSegments)
{
SettingValue sv = new SettingValue(fold.IsFolded.ToString(), fold.Offset.ToString());
fileSeting.Folding.Add(sv);
}
fileSeting.Bookmarks2 = new List <MyBookmark>(); //new List<int>();
foreach (LineSegment ls in this.editor.Document.Lines)
{
if (ls.IsBookmarked)
{
int lineNumber = this.editor.Document.OffsetToLineNumber(ls.Offset);
string text = this.editor.Document.GetTextBetween(ls.Offset, ls.EndOffset);
fileSeting.Bookmarks2.Add(new MyBookmark(lineNumber, text.Trim()));
}
}
MainClass.Workspace.WorkspaceUserSetting.FilesSetting.Add(fileSeting);
//this.editor.IconMargin.
}
}
private int GetSheetIndex(FileSetting fileSetting, ItemCollection sheetNames)
{
if (fileSetting == null)
{
return(-1);
}
var index = fileSetting.SheetIndex;
if (!string.IsNullOrEmpty(fileSetting.SheetName))
{
index = sheetNames.IndexOf(fileSetting.SheetName);
}
if (index < 0 || index >= sheetNames.Count)
{
MessageBox.Show(Properties.Resources.Msg_OutofSheetRange);
index = 0;
}
return(index);
}
public bool Load(string fileName)
{
try
{
fileSetting.Load(fileName);
// メンバーの更新と View の更新
// これもっと良いやり方ないだろうか？
fileSetting = FileSetting.Instance;
Repository = fileSetting.Repository;
ShaHash = fileSetting.ShaHash;
InputFile = fileSetting.InputFile;
OutputFile = fileSetting.OutputFile;
return(true);
}
catch (Exception e)
{
logger.Error(e);
return(false);
}
}
private FileSetting AddToSelectedFiles(DataSet item, FileType type)
{
if (item != null)
{
if (_SelectedFiles == null)
{
_SelectedFiles = new List <FileSetting>();
}
if (!_SelectedFiles.Any(x => x.Source == item.Source && x.FileName == item.FileName))
{
var fileitem = new FileSetting()
{
Source = item.Source,
FileName = item.FileName,
Type = type,
};
_SelectedFiles.Add(fileitem);
return(fileitem);
}
}
return(null);
}
public IActionResult FileRead(int id, int lang = 1)
{
FileStream stream = null;
//string str = "Persist Security Info=False;User ID=sa;Initial Catalog=INTODB;Data Source=192.168.100.63";
//string str = "Persist Security Info=False;User ID=sa;Initial Catalog=INTODB;Data Source=TOSHIBA";
var files = FileDB.GetFile(id, lang = 1, GetConfiguration().GetConnectionString(DEFAULT_CONNECTION));
var file = files.Data.First();
if (System.IO.File.Exists(file.Path))
{
stream = new FileStream(file.Path, FileMode.Open);
byte[] m_Bytes = ReadToEnd(stream);
string pdfBase64 = Convert.ToBase64String(m_Bytes);
stream.Close();
int dot = file.Name.LastIndexOf(".");
int length = file.Name.Length - dot;
string type = file.Name.Substring(dot + 1, length - 1);
FileSetting opFile = new FileSetting();
opFile.Base64 = pdfBase64;
opFile.TypeOfFile = type;
return(Json(opFile));
}
return(Json("File Not found"));
}
public CsvFileManager(FileInfo fileInfo, FileSetting config)
{
_fileInfo = fileInfo;
_fileSetting = config;
}
