private void RenderSheet(StackOutSheet sheet) { this.reportViewer1.LocalReport.SetParameters(new ReportParameter("CompanyName", UserSettings.Current.CompanyName)); this.reportViewer1.LocalReport.SetParameters(new ReportParameter("ForeignName", UserSettings.Current.ForeignName)); this.reportViewer1.LocalReport.SetParameters(new ReportParameter("MyAddress", UserSettings.Current.Address)); this.reportViewer1.LocalReport.SetParameters(new ReportParameter("MyTelphone", UserSettings.Current.TelPhone)); this.reportViewer1.LocalReport.SetParameters(new ReportParameter("MyFax", UserSettings.Current.Fax)); this.reportViewer1.LocalReport.SetParameters(new ReportParameter("MyWeb", UserSettings.Current.Website)); this.reportViewer1.LocalReport.SetParameters(new ReportParameter("SheetNo", sheet.ID)); this.reportViewer1.LocalReport.SetParameters(new ReportParameter("ShipDate", sheet.LastActiveDate.ToString("yyyy年MM月dd日"))); CompanyInfo customer = (new CompanyBLL(AppSettings.Current.ConnStr)).GetByID(sheet.CustomerID).QueryObject; this.reportViewer1.LocalReport.SetParameters(new ReportParameter("Customer", customer != null ? customer.Name : sheet.CustomerID)); this.reportViewer1.LocalReport.SetParameters(new ReportParameter("Linker", sheet.Linker)); this.reportViewer1.LocalReport.SetParameters(new ReportParameter("LinkerPhone", sheet.LinkerPhoneCall)); this.reportViewer1.LocalReport.SetParameters(new ReportParameter("Address", sheet.Address)); StackOutRecordSearchCondition con = new StackOutRecordSearchCondition(); con.SheetNo = new List <string>(); con.SheetNo.Add(sheet.ID); List <StackOutRecord> items = (new StackOutSheetBLL(AppSettings.Current.ConnStr)).GetDeliveryRecords(con).QueryObjects; items.ForEach(item => { item.Price = item.Price.Trim(); item.Count = item.Count.Trim(); item.Amount = item.Amount.Trim(); }); ReportDataSource sr = new ReportDataSource(); sr.Name = "Items"; sr.Value = items; this.reportViewer1.LocalReport.DataSources.Clear(); this.reportViewer1.LocalReport.DataSources.Add(sr); this.reportViewer1.RefreshReport(); //设置打印布局模式,显示物理页面大小 this.reportViewer1.SetDisplayMode(Microsoft.Reporting.WinForms.DisplayMode.PrintLayout); //缩放模式为百分比,以100%方式显示 this.reportViewer1.ZoomMode = Microsoft.Reporting.WinForms.ZoomMode.FullPage; }
protected override void ShowItemInGridViewRow(DataGridViewRow row, object item) { StackOutSheet sheet = item as StackOutSheet; row.Tag = sheet; row.Cells["colSheetNo"].Value = sheet.ID; row.Cells["colClass"].Value = sheet.DocumentType; CompanyInfo customer = customerTree1.GetCustomer(sheet.CustomerID); row.Cells["colCustomer"].Value = customer != null ? customer.Name : string.Empty; WareHouse ws = (_Warehouses != null && _Warehouses.Count > 0) ? _Warehouses.SingleOrDefault(it => it.ID == sheet.WareHouseID) : null; row.Cells["colWareHouse"].Value = ws != null ? ws.Name : string.Empty; row.Cells["colState"].Value = SheetStateDescription.GetDescription(sheet.State); row.Cells["colShipDate"].Value = sheet.State == SheetState.Shipped ? sheet.LastActiveDate.ToString("yyyy-MM-dd") : null; row.Cells["colLinker"].Value = sheet.Linker; row.Cells["colTelphone"].Value = sheet.LinkerPhoneCall; row.Cells["colAddress"].Value = sheet.Address; row.Cells["colMemo"].Value = sheet.Memo; if (sheet.State == SheetState.Canceled) { row.DefaultCellStyle.ForeColor = Color.Red; row.DefaultCellStyle.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Strikeout, System.Drawing.GraphicsUnit.Point, ((byte)(134))); } if (!_Sheets.Exists(it => it.ID == sheet.ID)) { _Sheets.Add(sheet); } }
private void ShowSheet(StackOutSheet item) { if (!string.IsNullOrEmpty(item.ID)) { this.txtSheetNo.Text = item.ID; this.txtSheetNo.Enabled = false; } Customer = (new CompanyBLL(AppSettings.Current.ConnStr)).GetByID(item.CustomerID).QueryObject; this.txtCustomer.Text = Customer != null ? Customer.Name : string.Empty; if (item.ClassID == StackOutSheetType.DeliverySheet) { this.cmbSheetType.SelectedIndex = 0; } if (item.ClassID == StackOutSheetType.CustomerBorrow) { this.cmbSheetType.SelectedIndex = 1; } this.cmbSheetType.Enabled = false; WareHouse = (new WareHouseBLL(AppSettings.Current.ConnStr)).GetByID(item.WareHouseID).QueryObject; this.txtWareHouse.Text = WareHouse != null ? WareHouse.Name : string.Empty; dtSheetDate.Value = item.SheetDate; this.txtLinker.Text = item.Linker; this.txtLinkerPhone.Text = item.LinkerPhoneCall; this.txtAddress.Text = item.Address; this.txtMemo.Text = item.Memo; ShowDeliveryItemsOnGrid(item.Items); ShowOperations(item.ID, item.DocumentType, dataGridView1); ShowAttachmentHeaders(item.ID, item.DocumentType, this.gridAttachment); }
private void mnu_AttachmentAdd_Click(object sender, EventArgs e) { StackOutSheet item = UpdatingItem as StackOutSheet; if (item != null) { PerformAddAttach(item.ID, item.DocumentType, gridAttachment); } }
protected override void ItemShowing() { StackOutSheet sheet = UpdatingItem as StackOutSheet; if (sheet != null) { ShowSheet(sheet); } }
private void btnPrint_Click(object sender, EventArgs e) { StackOutSheet sheet = UpdatingItem as StackOutSheet; if (sheet != null) { Print.FrmDeliverySheetPrint frm = new Print.FrmDeliverySheetPrint(); frm.Sheet = sheet; frm.ShowDialog(); } }
protected override object GetItemFromInput() { StackOutSheet sheet = UpdatingItem as StackOutSheet; if (sheet == null) { sheet = new StackOutSheet(); sheet.ID = txtSheetNo.Text == "自动创建" ? string.Empty : this.txtSheetNo.Text; sheet.ClassID = StackOutSheetType.DeliverySheet; } else { sheet = UpdatingItem as StackOutSheet; } sheet.CustomerID = Customer != null ? Customer.ID : null; if (cmbSheetType.SelectedIndex == 0) { sheet.ClassID = StackOutSheetType.DeliverySheet; } if (cmbSheetType.SelectedIndex == 1) { sheet.ClassID = StackOutSheetType.CustomerBorrow; } sheet.WareHouseID = WareHouse != null ? WareHouse.ID : null; sheet.SheetDate = dtSheetDate.Value; sheet.Linker = txtLinker.Text.Trim(); sheet.LinkerPhoneCall = txtLinkerPhone.Text.Trim(); sheet.Address = txtAddress.Text.Trim(); sheet.Memo = txtMemo.Text; sheet.Items = new List <StackOutItem>(); foreach (DataGridViewRow row in ItemsGrid.Rows) { if (row.Tag != null) { StackOutItem item = row.Tag as StackOutItem; item.SheetNo = sheet.ID; sheet.Items.Add(item); } } return(sheet); }