public ROInvoiceXOlist(ConditionX condition) : this() { DateTime start = condition.StartDate; DateTime end = condition.EndDate; this.xrLabelCompanyInfoName.Text = BL.Settings.CompanyChineseName; this.lbl_ReportDate.Text = string.Format(Properties.Resources.Book_UI_Query_BaseReport_InvoiceDate, DateTime.Now.ToString("yyyy-MM-dd")); this.lbl_ReportName.Text = Properties.Resources.InvoiceXODetail; this.xrLabelDateRange.Text = string.Format(Properties.Resources.DateRange, start.ToString("yyyy-MM-dd"), end.ToString("yyyy/MM/dd")); IList <Model.InvoiceXODetail> Details = invoicexoDetailManager.Select(condition.Customer1, condition.Customer2, condition.StartDate, condition.EndDate, condition.Yjri1, condition.Yjri2, condition.Employee1, condition.Employee2, condition.XOId1, condition.XOId2, condition.CusXOId, condition.Product, condition.Product2, condition.IsClose, false, condition.OrderColumn, condition.OrderType, condition.DetailFlag, condition.DepotId, condition.HandBookId); if (Details == null || Details.Count == 0) { throw new Helper.InvalidValueException("無記錄"); } this.DataSource = Details; this.TCDepot.DataBindings.Add("Text", this.DataSource, "DepotName"); this.TCkhddbh.DataBindings.Add("Text", this.DataSource, Model.InvoiceXODetail.PRO_CustomerInvoiceXOId); this.TCdanjia.DataBindings.Add("Text", this.DataSource, Model.InvoiceXODetail.PRO_InvoiceXODetailPrice, "{0:000}"); this.TCjinge.DataBindings.Add("Text", this.DataSource, Model.InvoiceXODetail.PRO_InvoiceXODetailMoney, "{0:0}"); this.TCkh.DataBindings.Add("Text", this.DataSource, Model.InvoiceXODetail.PRO_CustomerName); this.TCchkh.DataBindings.Add("Text", this.DataSource, Model.InvoiceXODetail.PRO_XOCustomerName); this.TCProId.DataBindings.Add("Text", this.DataSource, Model.InvoiceXODetail.PRO_PId); this.TCcpxh.DataBindings.Add("Text", this.DataSource, Model.InvoiceXODetail.PRO_ProductName); this.TCkhxh.DataBindings.Add("Text", this.DataSource, Model.InvoiceXODetail.PRO_CustomerProductName); this.TCriqi.DataBindings.Add("Text", this.DataSource, Model.InvoiceXODetail.PRO_InvoiceDate, "{0:yyyy/MM/dd}"); //this.TCyjrq.DataBindings.Add("Text", this.DataSource, Model.InvoiceXODetail.PRO_InvoiceYjrq, "{0:yyyy/MM/dd}"); this.TCyjrq.DataBindings.Add("Text", this.DataSource, Model.InvoiceXODetail.PRO_InvoiceXSDate, "{0:yyyy/MM/dd}"); this.TCshuliang.DataBindings.Add("Text", this.DataSource, Model.InvoiceXODetail.PRO_InvoiceXODetailQuantity); this.TCInvoiceXODetailBeenQuantity.DataBindings.Add("Text", this.DataSource, Model.InvoiceXODetail.PRO_InvoiceXODetailBeenQuantity); this.TCInvoiceXTDetailQuantity.DataBindings.Add("Text", this.DataSource, Model.InvoiceXODetail.PRO_InvoiceXTDetailQuantity); this.TC_ShouceHao.DataBindings.Add("Text", this.DataSource, Model.InvoiceXODetail.PRO_HandbookId); this.TC_Xianghao.DataBindings.Add("Text", this.DataSource, Model.InvoiceXODetail.PRO_HandbookProductId); this.xrlblTotalShuliang.Summary.FormatString = "{0:0}"; this.xrlblTotalShuliang.Summary.Func = SummaryFunc.Sum; this.xrlblTotalShuliang.Summary.IgnoreNullValues = true; this.xrlblTotalShuliang.Summary.Running = SummaryRunning.Report; this.xrlblTotalShuliang.DataBindings.Add("Text", this.DataSource, Model.InvoiceXODetail.PRO_InvoiceXODetailQuantity); this.xrlblTotalJinE.Summary.FormatString = "{0:0}"; this.xrlblTotalJinE.Summary.Func = SummaryFunc.Sum; this.xrlblTotalJinE.Summary.IgnoreNullValues = true; this.xrlblTotalJinE.Summary.Running = SummaryRunning.Report; this.xrlblTotalJinE.DataBindings.Add("Text", this.DataSource, Model.InvoiceXODetail.PRO_InvoiceXODetailMoney); }
public ROInvoiceXOlist_BackUp(ConditionX condition) : this() { DateTime start = condition.StartDate; DateTime end = condition.EndDate; this.xrLabelReportName.Text = Properties.Resources.InvoiceXODetail; this.xrLabelDateRange.Text = string.Format(Properties.Resources.DateRange, start.ToString("yyyy-MM-dd"), end.ToString("yyyy/MM/dd")); IList <Model.InvoiceXODetail> Details = invoicexoDetailManager.Select(condition.Customer1, condition.Customer2, condition.StartDate, condition.EndDate, condition.Yjri1, condition.Yjri2, condition.Employee1, condition.Employee2, condition.XOId1, condition.XOId2, condition.CusXOId, condition.Product, condition.Product2, condition.IsClose, false, condition.OrderColumn, condition.OrderType, condition.DetailFlag, condition.DepotId, condition.HandBookId); if (Details == null || Details.Count == 0) { throw new Helper.InvalidValueException("ŸoÓ›ä›"); } this.DataSource = Details; //this.TCchkh.DataBindings.Add("Text", this.DataSource, "Invoice.xocustomer." + Model.Customer.PRO_CustomerShortName); //this.TCcpxh.DataBindings.Add("Text", this.DataSource, "Product." + Model.Product.PRO_ProductName); //this.TCdanjia.DataBindings.Add("Text", this.DataSource, Model.InvoiceXODetail.PRO_InvoiceXODetailPrice, "{0:000}"); //this.TCdingdanbianhao.DataBindings.Add("Text", this.DataSource, "Invoice." + Model.InvoiceXO.PROPERTY_INVOICEID); //this.TCjinge.DataBindings.Add("Text", this.DataSource, Model.InvoiceXODetail.PRO_InvoiceXODetailMoney, "{0:0}"); //this.TCkh.DataBindings.Add("Text", this.DataSource, "Invoice.Customer." + Model.Customer.PRO_CustomerShortName); //this.TCkhddbh.DataBindings.Add("Text", this.DataSource, "Invoice." + Model.InvoiceXO.PRO_CustomerInvoiceXOId); //this.TCkhxh.DataBindings.Add("Text", this.DataSource, "Product." + Model.Product.PRO_CustomerProductName); //this.TCriqi.DataBindings.Add("Text", this.DataSource, "Invoice." + Model.InvoiceXO.PROPERTY_INVOICEDATE, "{0:yyyy/MM/dd}"); //this.TCshuliang.DataBindings.Add("Text", this.DataSource, Model.InvoiceXODetail.PRO_InvoiceXODetailQuantity); //this.TCyjrq.DataBindings.Add("Text", this.DataSource, "Invoice." + Model.InvoiceXO.PRO_InvoiceYjrq, "{0:yyyy/MM/dd}"); //this.TCInvoiceXODetailBeenQuantity.DataBindings.Add("Text", this.DataSource, Model.InvoiceXODetail.PRO_InvoiceXODetailBeenQuantity); //this.TCInvoiceXTDetailQuantity.DataBindings.Add("Text", this.DataSource, Model.InvoiceXODetail.PRO_InvoiceXTDetailQuantity); this.TCDepot.DataBindings.Add("Text", this.DataSource, "DepotName"); this.TCkhddbh.DataBindings.Add("Text", this.DataSource, Model.InvoiceXODetail.PRO_CustomerInvoiceXOId); this.TCdanjia.DataBindings.Add("Text", this.DataSource, Model.InvoiceXODetail.PRO_InvoiceXODetailPrice, "{0:000}"); this.TCjinge.DataBindings.Add("Text", this.DataSource, Model.InvoiceXODetail.PRO_InvoiceXODetailMoney, "{0:0}"); this.TCkh.DataBindings.Add("Text", this.DataSource, Model.InvoiceXODetail.PRO_CustomerName); this.TCchkh.DataBindings.Add("Text", this.DataSource, Model.InvoiceXODetail.PRO_XOCustomerName); this.TCcpxh.DataBindings.Add("Text", this.DataSource, Model.InvoiceXODetail.PRO_ProductName); this.TCkhxh.DataBindings.Add("Text", this.DataSource, Model.InvoiceXODetail.PRO_CustomerProductName); this.TCriqi.DataBindings.Add("Text", this.DataSource, Model.InvoiceXODetail.PRO_InvoiceDate, "{0:yyyy/MM/dd}"); this.TCyjrq.DataBindings.Add("Text", this.DataSource, Model.InvoiceXODetail.PRO_InvoiceYjrq, "{0:yyyy/MM/dd}"); this.TCshuliang.DataBindings.Add("Text", this.DataSource, Model.InvoiceXODetail.PRO_InvoiceXODetailQuantity); this.TCInvoiceXODetailBeenQuantity.DataBindings.Add("Text", this.DataSource, Model.InvoiceXODetail.PRO_InvoiceXODetailBeenQuantity); this.TCInvoiceXTDetailQuantity.DataBindings.Add("Text", this.DataSource, Model.InvoiceXODetail.PRO_InvoiceXTDetailQuantity); this.xrlblTotalShuliang.Summary.FormatString = "{0:0}"; this.xrlblTotalShuliang.Summary.Func = SummaryFunc.Sum; this.xrlblTotalShuliang.Summary.IgnoreNullValues = true; this.xrlblTotalShuliang.Summary.Running = SummaryRunning.Report; this.xrlblTotalShuliang.DataBindings.Add("Text", this.DataSource, Model.InvoiceXODetail.PRO_InvoiceXODetailQuantity); this.xrlblTotalJinE.Summary.FormatString = "{0:0}"; this.xrlblTotalJinE.Summary.Func = SummaryFunc.Sum; this.xrlblTotalJinE.Summary.IgnoreNullValues = true; this.xrlblTotalJinE.Summary.Running = SummaryRunning.Report; this.xrlblTotalJinE.DataBindings.Add("Text", this.DataSource, Model.InvoiceXODetail.PRO_InvoiceXODetailMoney); }
public ROInvoiceXOlist(ConditionX condition) : this() { DateTime start = condition.StartDate; DateTime end = condition.EndDate; this.lblCompanyName.Text = BL.Settings.CompanyChineseName; this.lbl_ReportName.Text = "客戶訂單明細表"; this.lbl_ReportDate.Text += string.Format("{0} ~ {1}", start.ToString("yyyy-MM-dd"), end.ToString("yyyy/MM/dd")); IList <Model.InvoiceXODetail> Details = invoicexoDetailManager.Select(condition.Customer1, condition.Customer2, condition.StartDate, condition.EndDate, condition.Yjri1, condition.Yjri2, condition.Employee1, condition.Employee2, condition.XOId1, condition.XOId2, condition.CusXOId, condition.Product, condition.Product2, condition.IsClose, false, condition.OrderColumn, condition.OrderType, condition.DetailFlag, condition.Product_Id, condition.ProductCategoryId); if (Details == null || Details.Count == 0) { throw new Helper.InvalidValueException("無記錄"); } this.DataSource = Details; this.TCdingdanbianhao.DataBindings.Add("Text", this.DataSource, Model.InvoiceXODetail.PRO_InvoiceId); this.TCkhddbh.DataBindings.Add("Text", this.DataSource, Model.InvoiceXODetail.PRO_CustomerInvoiceXOId); this.TCkh.DataBindings.Add("Text", this.DataSource, Model.InvoiceXODetail.PRO_CustomerName); this.TCcpxh.DataBindings.Add("Text", this.DataSource, Model.InvoiceXODetail.PRO_ProductName); this.TCkhxh.DataBindings.Add("Text", this.DataSource, Model.InvoiceXODetail.PRO_CustomerProductName); this.TCriqi.DataBindings.Add("Text", this.DataSource, Model.InvoiceXODetail.PRO_InvoiceDate, "{0:yy/MM/dd}"); this.TCshuliang.DataBindings.Add("Text", this.DataSource, Model.InvoiceXODetail.PRO_InvoiceXODetailQuantity); this.TCjinge.DataBindings.Add("Text", this.DataSource, Model.InvoiceXODetail.PRO_InvoiceXODetailMoney, "{0:0.##}"); this.TC_TaibiMoney.DataBindings.Add("Text", this.DataSource, Model.InvoiceXODetail.PRO_TaibiMoney, "{0:0.##}"); this.TotalQty.Summary.FormatString = "{0:0.#}"; this.TotalQty.Summary.Func = SummaryFunc.Sum; this.TotalQty.Summary.IgnoreNullValues = true; this.TotalQty.Summary.Running = SummaryRunning.Report; this.TotalQty.DataBindings.Add("Text", this.DataSource, Model.InvoiceXODetail.PRO_InvoiceXODetailQuantity); this.lbl_TotalMoney.Summary.FormatString = "{0:0.#}"; this.lbl_TotalMoney.Summary.Func = SummaryFunc.Sum; this.lbl_TotalMoney.Summary.IgnoreNullValues = true; this.lbl_TotalMoney.Summary.Running = SummaryRunning.Report; this.lbl_TotalMoney.DataBindings.Add("Text", this.DataSource, Model.InvoiceXODetail.PRO_InvoiceXODetailMoney); this.lbl_TotalTaibiMoney.Summary.FormatString = "{0:0.#}"; this.lbl_TotalTaibiMoney.Summary.Func = SummaryFunc.Sum; this.lbl_TotalTaibiMoney.Summary.IgnoreNullValues = true; this.lbl_TotalTaibiMoney.Summary.Running = SummaryRunning.Report; this.lbl_TotalTaibiMoney.DataBindings.Add("Text", this.DataSource, Model.InvoiceXODetail.PRO_TaibiMoney); }
protected override void ShowSearchForm() { Query.ConditionXChooseForm f = new Query.ConditionXChooseForm(); if (f.ShowDialog(this) == DialogResult.OK) { Query.ConditionX condition = f.Condition as Query.ConditionX; //this.bindingSource1.DataSource = ((BL.InvoiceXOManager)this.invoiceManager).SelectByYJRQCustomEmpCusXOId(condition.Customer1, condition.Customer2, condition.StartDate, condition.EndDate, condition.Yjri1, condition.Yjri2, condition.Employee1, condition.Employee2, condition.XOId1, condition.XOId2, condition.CusXOId, condition.Product, condition.Product2, condition.IsClose, false, false); this.bindingSource1.DataSource = invoicexoDetailManager.Select(condition.Customer1, condition.Customer2, condition.StartDate, condition.EndDate, condition.Yjri1, condition.Yjri2, condition.Employee1, condition.Employee2, condition.XOId1, condition.XOId2, condition.CusXOId, condition.Product, condition.Product2, condition.IsClose, false, condition.OrderColumn, condition.OrderType, condition.DetailFlag, condition.Product_Id, condition.ProductCategoryId); this.StartDate = condition.StartDate; this.EndDate = condition.EndDate; } f.Dispose(); GC.Collect(); this.barStaticItem1.Caption = string.Format("{0}Ïî", this.bindingSource1.Count); }
private void XSDetailForm_Load(object sender, EventArgs e) { this.bindingSourceXSID.DataSource = xsManager.Select(invoicexo); this.bindingSourceXODetail.DataSource = xoDetailManager.Select(this.invoicexo, false); }