private PdfOutputSetting GetInputedValues() { var setting = new PdfOutputSetting { CompanyId = Login.CompanyId, CreateBy = Login.UserId, UpdateBy = Login.UserId, }; if (ReturnScreen is PC1501) { setting.ReportType = (int)PdfOutputSettingReportType.Invoice; } else if (ReturnScreen is PI0401) { setting.ReportType = (int)PdfOutputSettingReportType.Reminder; } if (rdoAllInOne.Checked) { setting.OutputUnit = (int)PdfOutputSettingOutputUnit.AllInOne; return(setting); } setting.OutputUnit = (int)PdfOutputSettingOutputUnit.ByReport; setting.FileName = txtFileName.Text.Trim(); setting.UseCompression = cbxUseCompression.Checked ? 1 : 0; setting.MaximumSize = nmbMaxSize.Value; return(setting); }
private void Print() { ClearStatusMessage(); if (!ValidateInputValueForPrint()) { return; } try { var path = string.Empty; PdfSetting = GetPdfOutputSetting(); if (!PdfSetting.IsAllInOne) { var serverPath = GetServerPath(); var selectedPath = string.Empty; var rootBrowserPath = new List <string>(); if (!LimitAccessFolder ? !ShowFolderBrowserDialog(serverPath, out selectedPath) : !ShowRootFolderBrowserDialog(ApplicationControl.RootPath, out rootBrowserPath, FolderBrowserType.SelectFolder)) { DispStatusMessage(MsgInfProcessCanceled); return; } path = (!LimitAccessFolder ? selectedPath : rootBrowserPath.First()); } if (!PdfSetting.IsAllInOne && !ShowConfirmDialog(MsgQstConfirmOutput)) { DispStatusMessage(MsgInfProcessCanceled); return; } if (!ReminderSummary.Any()) { ShowWarningDialog(MsgWngPrintDataNotExist, "出力"); return; } grdReminder.CommitEdit(); Task task = null; if (!UseDestinationSummarized) { task = PrintSummarized(path); } else { task = PrintDestinationSummarized(path); } ProgressDialog.Start(ParentForm, task, false, SessionKey); } catch (Exception ex) { Debug.Fail(ex.ToString()); NLogHandler.WriteErrorLog(this, ex, SessionKey); ShowWarningDialog(MsgErrExportError); } }
private async Task <PdfOutputSetting> SavePdfOutputSetting(PdfOutputSetting setting) => await ServiceProxyFactory.DoAsync(async (PdfOutputSettingMasterClient client) => { var result = await client.SaveAsync(SessionKey, setting); if (result == null || result.ProcessResult == null || !result.ProcessResult.Result) { return(null); } return(result.PdfOutputSetting); });
public Task <PdfOutputSetting> SaveAsync(PdfOutputSetting setting, CancellationToken token = default(CancellationToken)) { var query = @" MERGE INTO PdfOutputSetting AS target USING ( SELECT @CompanyId AS CompanyId ,@ReportType AS ReportType ) AS source ON ( target.CompanyId = source.CompanyId AND target.ReportType = source.ReportType ) WHEN MATCHED THEN UPDATE SET OutputUnit = @OutputUnit ,FileName = @FileName ,UseCompression = @UseCompression ,MaximumSize = @MaximumSize ,UpdateBy = @UpdateBy ,UpdateAt = GETDATE() WHEN NOT MATCHED THEN INSERT ( CompanyId ,ReportType ,OutputUnit ,FileName ,UseCompression ,MaximumSize ,CreateBy ,CreateAt ,UpdateBy ,UpdateAt ) VALUES ( @CompanyId ,@ReportType ,@OutputUnit ,@FileName ,@UseCompression ,@MaximumSize ,@CreateBy ,GETDATE() ,@UpdateBy ,GETDATE() ) OUTPUT inserted.*; "; return(dbHelper.ExecuteAsync <PdfOutputSetting>(query, setting, token)); }
public async Task <PdfOutputSettingResult> SaveAsync(string SessionKey, PdfOutputSetting Setting) { return(await authorizationProcessor.DoAuthorizeAsync(SessionKey, async token => { var result = await pdfOutputSettingProcessor.SaveAsync(Setting, token); return new PdfOutputSettingResult { ProcessResult = new ProcessResult { Result = true }, PdfOutputSetting = result, }; }, logger)); }
private void SetOdfOutputSetting(PdfOutputSetting setting) { if (setting.IsAllInOne) { SetAllInOne(); Modified = false; rdoAllInOne.Select(); return; } rdoByReport.Checked = true; txtFileName.Text = setting.FileName; cbxUseCompression.Checked = setting.UseZip; nmbMaxSize.Value = setting.MaximumSize; Modified = false; rdoByReport.Select(); }
public async Task <PdfOutputSetting> GetAsync(int CompanyId, int ReportType, int UserId, CancellationToken token = default(CancellationToken)) { var setting = await pdfOutputSettingQueryProcessor.GetAsync(CompanyId, ReportType, token); if (setting != null) { return(setting); } var defaultSetting = new PdfOutputSetting { CompanyId = CompanyId, ReportType = ReportType, OutputUnit = (int)PdfOutputSettingOutputUnit.AllInOne, CreateBy = UserId, UpdateBy = UserId }; return(await addPdfOutputSettingQueryProcessor.SaveAsync(defaultSetting, token)); }
public static ReminderReport CreateReminderReport(IEnumerable <ReminderBilling> source, ReminderCommonSetting ReminderCommonSetting, List <ReminderSummarySetting> ReminderSummarySetting, ReminderTemplateSetting template, Company Company, List <ColumnNameSetting> ColumnNameSetting, DateTime outputAt, PdfOutputSetting pdfSetting) { var reminderReport = new ReminderReport(); reminderReport.Template = template; reminderReport.txtOutputAtHeader.Text = outputAt.ToString("yyyy年MM月dd日"); reminderReport.txtOutputAtDetail.Text = outputAt.ToString("yyyy年MM月dd日"); var rd = source.FirstOrDefault(); var isDestination = rd.DestinationId.HasValue && rd.DestinationId != 0; reminderReport.txtCustomerPostalCode.Text = isDestination ? rd.DestinationPostalCode : rd.CustomerPostalCode; reminderReport.txtCustomerAddress1.Text = isDestination ? rd.DestinationAddress1 : rd.CustomerAddress1; reminderReport.txtCustomerAddress2.Text = isDestination ? rd.DestinationAddress2 : rd.CustomerAddress2; reminderReport.txtCustomerName.Text = !string.IsNullOrEmpty(rd.DestinationName) ? rd.DestinationName : rd.CustomerName; if (isDestination) { var isNullDepartment = string.IsNullOrEmpty(rd.DestinationDepartmentName); var isNullAddressee = string.IsNullOrEmpty(rd.DestinationAddressee); if (isNullDepartment && isNullAddressee) { reminderReport.txtCustomerName.Text += rd.DestinationHonorific; } else if (!isNullDepartment && isNullAddressee) { reminderReport.txtDestinationDepartmentName.Text = rd.DestinationDepartmentName + " " + rd.DestinationHonorific; reminderReport.txtDestinationAddressee.Text = ""; } else if (isNullDepartment && !isNullAddressee) { reminderReport.txtDestinationDepartmentName.Text = rd.DestinationAddressee + " " + rd.DestinationHonorific; reminderReport.txtDestinationAddressee.Text = ""; } else { reminderReport.txtDestinationDepartmentName.Text = rd.DestinationDepartmentName; reminderReport.txtDestinationAddressee.Text = rd.DestinationAddressee + " " + rd.DestinationHonorific; } } else { var isNullDepartment = string.IsNullOrEmpty(rd.DestinationDepartmentName); var isNullAddressee = string.IsNullOrEmpty(rd.DestinationAddressee); var destinationHonorific = rd.DestinationHonorific; if (isNullDepartment && isNullAddressee) { reminderReport.txtCustomerName.Text += destinationHonorific; reminderReport.txtDestinationDepartmentName.Text = ""; reminderReport.txtDestinationAddressee.Text = ""; } else if (!isNullDepartment && isNullAddressee) { reminderReport.txtDestinationDepartmentName.Text = rd.DestinationDepartmentName + destinationHonorific; reminderReport.txtDestinationAddressee.Text = ""; } else if (isNullDepartment && !isNullAddressee) { reminderReport.txtDestinationDepartmentName.Text = rd.DestinationAddressee + destinationHonorific; reminderReport.txtDestinationAddressee.Text = ""; } else { reminderReport.txtDestinationDepartmentName.Text = rd.DestinationDepartmentName; reminderReport.txtDestinationAddressee.Text = rd.DestinationAddressee + destinationHonorific; } } reminderReport.DataSource = new BindingSource(source, null); reminderReport.txtCompanyPostalCode.Text = "〒" + Company.PostalCode; reminderReport.txtCompanyAddress1.Text = Company.Address1; reminderReport.txtCompanyAddress2.Text = Company.Address2; reminderReport.txtCompanyName.Text = Company.Name; reminderReport.txtOwnDepartmentName.Text = ReminderCommonSetting.OwnDepartmentName; reminderReport.txtAccountingStaffName.Text = ReminderCommonSetting.AccountingStaffName; if (ReminderCommonSetting.OutputDetail == 1) { reminderReport.lblNote.Text = ColumnNameSetting.First(x => x.ColumnName == ReminderCommonSetting.OutputDetailItem).DisplayColumnName; reminderReport.txtNote.DataField = ReminderCommonSetting.OutputDetailItem; } if (!ReminderSummarySetting.Any(x => x.ColumnName == "Staff" && x.Available == 1)) { reminderReport.txtStaffName.Visible = false; reminderReport.lblTel.Visible = false; reminderReport.txtStaffTel.Visible = false; reminderReport.lblFax.Visible = false; reminderReport.txtStaffFax.Visible = false; } reminderReport.txtAccountName.Text = Company.BankAccountName; var rb = source.First(); if (pdfSetting.IsAllInOne) { reminderReport.Name = $"督促状{outputAt.ToString("yyyyMMdd")}"; } else { var name = pdfSetting.FileName.Replace("[CODE]", rb.CustomerCode); name = name.Replace("[NAME]", rb.CustomerName); name = name.Replace("[NO]", rb.OutputNo.ToString("000000")); name = name.Replace("[DATE]", outputAt.ToString("yyyyMMdd")); reminderReport.Name = name; } reminderReport.CustomerReceiveAccount1 = rb.CustomerReceiveAccount1 == 1; reminderReport.CustomerReceiveAccount2 = rb.CustomerReceiveAccount2 == 1; reminderReport.CustomerReceiveAccount3 = rb.CustomerReceiveAccount3 == 1; reminderReport.CompanyBankAccount1 = $"{Company.BankName1} {Company.BranchName1} {Company.AccountType1} {Company.AccountNumber1}"; reminderReport.CompanyBankAccount2 = $"{Company.BankName2} {Company.BranchName2} {Company.AccountType2} {Company.AccountNumber2}"; reminderReport.CompanyBankAccount3 = $"{Company.BankName3} {Company.BranchName3} {Company.AccountType3} {Company.AccountNumber3}"; reminderReport.TotalAmountPrintHandler += (customerId) => { reminderReport.txtTotalAmount.Text = source.Where(x => x.CustomerId == customerId) .Sum(x => x.RemainAmount).ToString("#,##0"); }; if (ReminderCommonSetting.OutputDetail == 0) { reminderReport.HideDetail(); } if (!source.Any(x => x.OutputNo > 0)) { reminderReport.HideOutputNo(); } reminderReport.Run(false); return(reminderReport); }
private void grdReminder_CellClick(object sender, CellEventArgs e) { if (e.RowIndex < 0) { return; } if (e.CellName != CellName("Preview")) { return; } grdReminder.CommitEdit(); try { string serverPath = GetServerPath(); var summary = grdReminder.Rows[e.RowIndex].DataBoundItem as ReminderSummary; if (UseDestinationSummarized) { var option = new DestinationSearch(); option.CompanyId = CompanyId; option.CustomerId = summary.CustomerId; var taskDestination = GetDestinationsAsync(option); ProgressDialog.Start(ParentForm, taskDestination, false, SessionKey); var destinations = taskDestination.Result; var destinationIds = new List <ReminderSummary>(); var inputCode = string.Empty; var cell = grdReminder.Rows[e.RowIndex].Cells[CellName(nameof(Web.Models.ReminderSummary.DestinationCode))]; if (IsCellEmpty(cell)) { summary.DestinationIdInput = null; } else { inputCode = cell.Value.ToString().PadLeft(2, '0'); if (!destinations.Any(x => x.Code == inputCode)) { ShowWarningDialog(MsgWngMasterNotExist, "送付先", inputCode); return; } summary.DestinationIdInput = destinations.FirstOrDefault(x => x.Code == inputCode).Id; } var qry = from row in grdReminder.Rows where (string)(row.Cells[CellName(nameof(Web.Models.ReminderSummary.CustomerCode))].Value) == summary.CustomerCode select row; foreach (var row in qry) { var bsd = row.DataBoundItem as ReminderSummary; var code = Convert.ToString(row.Cells[CellName(nameof(Web.Models.ReminderSummary.DestinationCode))].Value); if (code == inputCode) { if (bsd.DestinationId.HasValue) { destinationIds.Add(bsd); } else { summary.NoDestination = true; } } } summary.CompanyId = CompanyId; summary.CustomerIds = new int[] { summary.CustomerId }; summary.DestinationIds = destinationIds.Select(x => x.DestinationId.Value).Distinct().ToArray(); } var summaryList = new List <ReminderSummary>(); summaryList.Add(summary); var task = UseDestinationSummarized ? GetReminderBillingForSummaryPrintByDestinationCodeAsync(summaryList) : GetReminderBillingForSummaryPrintAsync(ReminderSummary.Select(x => x.CustomerId).ToArray()); ProgressDialog.Start(ParentForm, task, false, SessionKey); if (!task.Result.ProcessResult.Result) { ShowWarningDialog(MsgErrCreateReportError); return; } var reminderBillings = task.Result.ReminderBilling; var template = ReminderTemplateSetting.First(x => x.Id == summary.TemplateId); PdfSetting = GetPdfOutputSetting(); var report = UtilReminder.CreateReminderReport(reminderBillings, ReminderCommonSetting, ReminderSummarySetting, template, Company, ColumnNameSettingInfo, DateTime.Now, PdfSetting); ShowDialogPreview(ParentForm, report, serverPath); } catch (Exception ex) { Debug.Fail(ex.ToString()); NLogHandler.WriteErrorLog(this, ex, SessionKey); ShowWarningDialog(MsgErrCreateReportError); } }
public async Task <ActionResult <PdfOutputSetting> > Save(PdfOutputSetting setting, CancellationToken token) => await pdfOutputSettingProcessor.SaveAsync(setting, token);
public async Task <ActionResult <PdfOutputSetting> > Get(PdfOutputSetting setting, CancellationToken token) => await pdfOutputSettingProcessor.GetAsync(setting.CompanyId, setting.ReportType, setting.UpdateBy, token);
public async Task <PdfOutputSetting> SaveAsync(PdfOutputSetting setting, CancellationToken token = default(CancellationToken)) => await addPdfOutputSettingQueryProcessor.SaveAsync(setting, token);