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