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);
}
