private void bbExportHistory_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
XtraFolderBrowserDialog dialog = new XtraFolderBrowserDialog();
if (dialog.ShowDialog() != DialogResult.OK)
{
return;
}
GridControl gc = new GridControl();
GridView view = new GridView();
gc.ViewCollection.Add(view);
gc.MainView = view;
gc.DataSource = new BindingSource()
{
DataSource = typeof(DependencyArbitrageHistoryItem)
};
gc.BindingContext = new BindingContext();
gc.ForceInitialize();
view.PopulateColumns();
ArbitrageHelper.Items.ForEach(i => i.SaveHistory());
ArbitrageHelper.Items.ForEach(i => {
StatisticalArbitrageStrategy info = new StatisticalArbitrageStrategy();
info.Assign(i);
info.LoadHistory();
gc.DataSource = info.History;
gc.ExportToXlsx(dialog.SelectedPath + "\\" + info.GetExportFileName() + ".xlsx");
});
System.Diagnostics.Process.Start(dialog.SelectedPath);
}
private void OpenFileBtn_ItemClick(object sender, ItemClickEventArgs e)
{
XtraFolderBrowserDialog OpenFolder = new XtraFolderBrowserDialog();
OpenFolder.ShowNewFolderButton = false;
OpenFolder.UseParentFormIcon = true;
OpenFolder.ShowDragDropConfirmation = true;
//OpenFolder.SelectedPath = @"C:\Users\Administrator\Desktop\JGZC\ZDLP\ZDLP\bin\Release\RecvData";
if (OpenFolder.ShowDialog() == DialogResult.OK)
{
string path = OpenFolder.SelectedPath;
DirectoryInfo fi = new DirectoryInfo(path);
if (!fi.Exists)
{
return;
}
mainAccordionGroup.Elements.Clear();
List <AccordionControlElement> ac = new List <AccordionControlElement>();
foreach (FileInfo file in fi.GetFiles())
{
if (file.Extension == ".dat")
{
AccordionControlElement tmp = new AccordionControlElement(DevExpress.XtraBars.Navigation.ElementStyle.Item);
tmp.Text = file.Name;
tmp.Tag = file.FullName;
tmp.Click += new System.EventHandler(this.tmp_Click);;
ac.Add(tmp);
}
}
AccordionControlElement[] acArray = ac.ToArray();
mainAccordionGroup.Elements.AddRange(ac.ToArray());
}
}
private void MapDataToReport(DataLibrary.Models.ReportModels.AnalysisRequestReportModel reportModel)
{
//Show a message if no results are validated for the analysis request.
if (reportModel is null)
{
XtraMessageBox.Show("No results validated for the selected analysis request.\nCannot generate report.");
DisposeMe();
return;
}
//ReportTemplates[0] The ZERO need to be handled dynamically to be truly extensible
var xtraReport = _reportExtensions.ReportTemplates[0]
.Execute((ReportTemplate)_cinAndReportId.ReportIndex, GetReportDatasource(reportModel));
xtraReport.RequestParameters = false;
xtraReport.DisplayName = $"{Tag}_{RemoveInvalidCharactersForExport(reportModel.Patient.Fullname)} ({RemoveInvalidCharactersForExport(reportModel.Patient.NidPp)}";
#if DEBUG
xtraReport.DrawWatermark = true;
#endif
if (_cinAndReportId.Action == ReportActionModel.Export)
{
var settings = new Properties.Settings();
string exportDirectoryStructure = $"{DateTime.Today:yyyy}\\{DateTime.Today:MMMM}\\{DateTime.Today:dd}\\{reportModel.SampleSite.Trim()}";
var exportDirPath = $"{settings.ReportExportBasePath}\\{exportDirectoryStructure}";
try
{
ExportReport(xtraReport, exportDirPath);
}
catch (Exception ex)
{
XtraMessageBox.Show($"Error exporting report. Please fing the details below.\n{ex.Message}\n{ex.StackTrace}\nExport path: {exportDirPath}");
//prompt for user to select a temp export path
var folderBrowserDialog = new XtraFolderBrowserDialog();
// Show the FolderBrowserDialog.
DialogResult result = folderBrowserDialog.ShowDialog();
if (result == DialogResult.OK)
{
exportDirPath = $"{folderBrowserDialog.SelectedPath}\\{exportDirectoryStructure}";
ExportReport(xtraReport, exportDirPath);
}
}
}
if (_cinAndReportId.Action == ReportActionModel.Print)
{
xtraReport.PrinterName = "DocumentPrinter";
xtraReport.CreateDocument();
xtraReport.Print();
}
//Close this form
DisposeMe();
}
private void btnRuta_Click(object sender, EventArgs e)
{
XtraFolderBrowserDialog saveFileDialog = new XtraFolderBrowserDialog();
if (saveFileDialog.ShowDialog() == DialogResult.OK)
{
txtRutaArchivos.Text = saveFileDialog.SelectedPath;
}
}
private async void btnOpenFolder_Click(object sender, EventArgs e)
{
var folderBrowserDialog1 = new XtraFolderBrowserDialog();
folderBrowserDialog1.SelectedPath = SelectedPath;
if (DialogResult.OK == folderBrowserDialog1.ShowDialog(this))
{
SelectedPath = folderBrowserDialog1.SelectedPath;
await PopulateFolders(SelectedPath, DataProvider);
}
}
private DialogResult SetWorkingFolderDialogHelper()
{
//string defaultFilePath = System.Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments);
XtraFolderBrowserDialog dialog = this.xtraFolderBrowserDialog1;
dialog.SelectedPath = this.DefaultPath;
this.dialogResult = dialog.ShowDialog();
if (this.dialogResult == DialogResult.OK)
{
this.DefaultPath = dialog.SelectedPath;
}
return(this.dialogResult);
}
/// <summary>
/// 선택된 디렉토리를 기본 디렉토리로 지정한다.
/// 그외 기본 디렉토리를 자동 생성한다.
/// 빈 디렉토리가 아니면 모두 삭제 후 LISP , PLH, PLD 디렉토리를 자동 생성한다.
/// </summary>
public void SetProjectDir()
{
string dirPath = "";
XtraFolderBrowserDialog folderDlg1 = new XtraFolderBrowserDialog();
folderDlg1.DialogStyle = DevExpress.Utils.CommonDialogs.FolderBrowserDialogStyle.Wide;
if (folderDlg1.ShowDialog() == DialogResult.OK)
{
m_strFullPath = folderDlg1.SelectedPath;
SaveProjectDir(m_strFullPath);
}
}
private void barButtonItemThuMuc_ItemClick(object sender, ItemClickEventArgs e)
{
XtraFolderBrowserDialog folderBrowserDialog = new XtraFolderBrowserDialog();
folderBrowserDialog.DialogStyle = FolderBrowserDialogStyle.Wide;
folderBrowserDialog.SelectedPath = PathForInvoicePrinting;
if (folderBrowserDialog.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
WritePathToFile(folderBrowserDialog.SelectedPath);
}
}
private void SetWorkingFolderDialogHelper()
{
//string defaultFilePath = System.Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments);
XtraFolderBrowserDialog dialog = this.xtraFolderBrowserDialog1;
//using( XtraFolderBrowserDialog dialog = new DevExpress.XtraEditors.XtraFolderBrowserDialog( ) )
//{
dialog.SelectedPath = this.DefaultPath;
if (dialog.ShowDialog() == DialogResult.OK)
{
this.DefaultPath = dialog.SelectedPath;
}
//}
}
private void btnExcel_Click(object sender, EventArgs e)
{
XtraFolderBrowserDialog fbd = new XtraFolderBrowserDialog();
if (fbd.ShowDialog() == DialogResult.OK)
{
D_GIAODICH gdb = new D_GIAODICH();
bool isok = false;
int n = lstDaiLy.CheckedItems.Count;
for (int i = 0; i < n; i++)
{
O_DAILY dl = lstDaiLy.GetItem(lstDaiLy.CheckedIndices[0]) as O_DAILY;
string daily = string.Format("{0}", dl.ID);
List <O_GIAODICH> lstCongNo = gdb.LayDanhSachCN((DateTime)dtpTuNgay.EditValue, (DateTime)dtpDenNgay.EditValue, daily, true);
if (lstCongNo.Count > 1)
{
gridCTCongNo.Refresh();
isok = true;
CTGiaoDichDindingSource.DataSource = lstCongNo;
// Xuất excel
string strFile = fbd.SelectedPath + @"\" + dl.Ten + " - " + ((DateTime)dtpTuNgay.EditValue).ToString("dd_MM_yyyy") + " - " + ((DateTime)dtpDenNgay.EditValue).ToString("dd_MM_yyyy") + ".xlsx";
XlsxExportOptionsEx opt = new XlsxExportOptionsEx();
opt.CustomizeCell += op_CustomizeCell;
opt.SheetName = "Bản Công Nợ";
gridCTCongNo.ForceInitialize();
grvCTCongNo.Columns["LuyKe"].Width = 90;
grvCTCongNo.Columns["GiaThu"].Width = 90;
grvCTCongNo.Columns["GiaHeThong"].Width = 90;
grvCTCongNo.Columns["TaiKhoanCo"].Width = 90;
grvCTCongNo.Columns["TenKhach"].Width = 400;
grvCTCongNo.OptionsPrint.AutoWidth = false;
grvCTCongNo.OptionsView.ColumnAutoWidth = false;
gridCTCongNo.ExportToXlsx(strFile, opt);
int index = lstDaiLy.FindItem(0, true, delegate(ListBoxFindItemArgs ei) { ei.IsFound = object.Equals(dl.ID, ei.ItemValue); });
lstDaiLy.SetItemChecked(index, false);
}
}
if (isok)
{
XuLyGiaoDien.Alert("Xuất file thành công!", Form_Alert.enmType.Success);
}
else
{
XuLyGiaoDien.Alert("Không có thông tin", Form_Alert.enmType.Info);
}
}
}
private void btnSaveDirectory_ButtonPressed(object sender, ButtonPressedEventArgs e)
{
var buttonEdit = sender as ButtonEdit;
if (e.Button.Kind == ButtonPredefines.Delete)
{
buttonEdit.EditValue = null;
return;
}
if (string.IsNullOrWhiteSpace(txtIPAddress.Text) && !checkIsThisPC.Checked)
{
txtIPAddress.Focus();
}
else
{
if (checkIsThisPC.Checked)
{
using (var xtraFolderBrowserDialog = new XtraFolderBrowserDialog())
{
xtraFolderBrowserDialog.DialogStyle = FolderBrowserDialogStyle.Wide;
if (xtraFolderBrowserDialog.ShowDialog() == DialogResult.OK)
{
buttonEdit.EditValue = xtraFolderBrowserDialog.SelectedPath;
}
}
}
else
{
var networkStream = GetNetworkStream(txtIPAddress.Text, 15000);
if (networkStream is null)
{
return;
}
var form = new MyExplorerForm(networkStream);
form.ShowDialog();
if (!string.IsNullOrWhiteSpace(form.Path))
{
buttonEdit.EditValue = form.Path;
}
}
}
}
private void btnExportarExcel_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (dtgValVentaExistencia.RowCount > 0)
{
XtraFolderBrowserDialog saveFileDialog = new XtraFolderBrowserDialog();
if (saveFileDialog.ShowDialog() == DialogResult.OK)
{
string Cadena = saveFileDialog.SelectedPath;
XtraInputBoxArgs args = new XtraInputBoxArgs();
// set required Input Box options
args.Caption = "Ingrese Nombre del Archivo Excel";
args.Prompt = "Nombre Archivo";
args.DefaultButtonIndex = 0;
//args.Showing += Args_Showing;
// initialize a DateEdit editor with custom settings
TextEdit editor = new TextEdit();
args.Editor = editor;
// a default DateEdit value
args.DefaultResponse = "Nombre_Archivo_Excel";
// display an Input Box with the custom editor
string result = string.Empty;
result = XtraInputBox.Show(args).ToString();
if (result != string.Empty)
{
string path = Cadena + "\\" + result + ".xls";
dtgVentaExistencia.ExportToXlsx(path, new DevExpress.XtraPrinting.XlsxExportOptionsEx
{
AllowGrouping = DefaultBoolean.False,
AllowFixedColumnHeaderPanel = DefaultBoolean.False
});
System.Diagnostics.Process.Start(path);
}
else
{
XtraMessageBox.Show("No se ingreso Nombre para el Archivo a exportar");
}
}
}
else
{
XtraMessageBox.Show("No existen registros para exportar");
}
}
private void SetupEventsHandlers()
{
sbtnFolderProbingBrowse.Click += (s, e) =>
{
using XtraFolderBrowserDialog folderDlg = new XtraFolderBrowserDialog
{
ShowNewFolderButton = false
};
// Show the FolderBrowserDialog.
DialogResult result = folderDlg.ShowDialog();
if (result == DialogResult.OK)
{
teFoldersProbing.Text = folderDlg.SelectedPath;
}
};
sbtnFolderProbingAdd.Click += (s, e) =>
{
if (string.IsNullOrEmpty(teFoldersProbing.Text))
{
return;
}
listBoxFoldersProbing.Items.Add(teFoldersProbing.Text);
Settings.AdditionalProbingLocations.Add(teFoldersProbing.Text);
};
sbtnDeleteFolderProbing.Click += (s, e) =>
{
if (listBoxFoldersProbing.SelectedItem != null)
{
Settings.AdditionalProbingLocations.Remove(listBoxFoldersProbing.SelectedItem.ToString());
listBoxFoldersProbing.Items.Remove(listBoxFoldersProbing.SelectedItem);
}
};
}
public static string ShowFolderBrowseDialog(Form owner, string description)
{
using XtraFolderBrowserDialog folderBrowser = new XtraFolderBrowserDialog { Description = description, ShowNewFolderButton = true };
return(folderBrowser.ShowDialog(owner) == DialogResult.OK ? folderBrowser.SelectedPath : null);
}
/// <summary>
/// 확장자 존재 유무에 따라 디렉토리 처리여부를 판단한다.
/// 선택 디렉토리에 전달된 확장자가 존재한다면 모두 삭제되는걸 경고해줌
/// </summary>
/// <param name="strExt"></param>
public static string CheckExistExt(string strExt)
{
string dirPath = "";
Boolean bExtention = false; //확장자 존재여부
using (XtraFolderBrowserDialog FolderDlg = new XtraFolderBrowserDialog())
{
int nFileCnt = 0;;
if (FolderDlg.ShowDialog() == DialogResult.OK)
{
dirPath = FolderDlg.SelectedPath;
//디렉토리 존재유무를 확인한다.
if (Directory.Exists(dirPath) == true)
{
DirectoryInfo di = new DirectoryInfo(dirPath);
foreach (var item in di.GetFiles())
{
bExtention = true;
break;
#if false
//확장자가 PLH 이면
if (item.Extension == strExt)
{
bExtention = true;
break;
}
#endif
}
//만약 디렉토리내에 해당 확장자를 가진 파일이 존재한다면 물어보자
if (bExtention == true)
{
if (MessageBox.Show(" 기존 파일이 존재합니다. 계속 진행하면 기존 파일 삭제 후 진행합니다. " + "[" + dirPath + "]", " 확인", MessageBoxButtons.OKCancel) == DialogResult.Cancel)
{
//cancel 하면
MessageBox.Show("취소 되었습니다.");
return(null);
}
else
{
//디렉토리를 날려버리고 새로 만든다.
if (MessageBox.Show("선택한 디렉토리 하위 파일들이 모두 지워집니다.", " 삭제", MessageBoxButtons.OKCancel) == DialogResult.OK)
{
foreach (string filenm in Directory.GetFiles(dirPath))
{
FileInfo fInfo = new FileInfo(filenm);
fInfo.Delete();
#if false
//순수 확장자가 파일명의 끝에 있는지 체크해서 카운트.
if (filenm.EndsWith("PLH"))
{
FileInfo fInfo = new FileInfo(filenm);
fInfo.Delete();
}
#endif
}
}
else
{
XtraMessageBox.Show("취소 되었습니다.");
return(null);
}
}
}
}
}
}
return(dirPath);
} // end of CheckExistExt
