public ROInvoiceXSlistBiao(ConditionX condition) : this() { this.xrLabelReportName.Text = "Schedule of accounts receivable"; this.lblCustomerName.Text = condition.Customer1 == null ? "" : condition.Customer1.ToString(); this.lblDateRange.Text = " Date range:" + condition.StartDate.ToString("yyyy-MM-dd") + " ~ " + condition.EndDate.ToString("yyyy-MM-dd"); //bind //this.DataSource = this.detailManager.SelectbyConditionX(condition.StartDate, condition.EndDate, condition.Yjri1, condition.Yjri2, condition.Customer1, condition.Customer2, condition.XOId1, condition.XOId2, condition.Product, condition.Product2, condition.CusXOId, condition.OrderColumn, condition.OrderType); if ((bool)condition.Special) { this.DataSource = this.detailManager.SelectbyConditionXBiao(condition.StartDate, condition.EndDate, condition.Yjri1, condition.Yjri2, condition.Customer1, condition.Customer2, condition.XOId1, condition.XOId2, condition.Product, condition.Product2, condition.CusXOId, condition.OrderColumn, condition.OrderType, false); dt = this.detailManager.SelectbyConditionXBiao(condition.StartDate, condition.EndDate, condition.Yjri1, condition.Yjri2, condition.Customer1, condition.Customer2, condition.XOId1, condition.XOId2, condition.Product, condition.Product2, condition.CusXOId, condition.OrderColumn, condition.OrderType, condition.Special); } else { this.DataSource = this.detailManager.SelectbyConditionXBiao(condition.StartDate, condition.EndDate, condition.Yjri1, condition.Yjri2, condition.Customer1, condition.Customer2, condition.XOId1, condition.XOId2, condition.Product, condition.Product2, condition.CusXOId, condition.OrderColumn, condition.OrderType, null); } //if (this.DataSource == null || (this.DataSource as IList<Model.InvoiceXSDetail>).Count == 0) if ((this.DataSource == null || (this.DataSource as System.Data.DataTable).Rows.Count == 0) && dt.Rows.Count == 0) { throw new global::Helper.InvalidValueException("No data"); } this.tcCHDH.DataBindings.Add("Text", this.DataSource, "CHDH"); this.tcCHRQ.DataBindings.Add("Text", this.DataSource, "CHRQ", "{0:yyyy-MM-dd}"); this.tcProductName.DataBindings.Add("Text", this.DataSource, "ProductName"); this.tcKHDDBH.DataBindings.Add("Text", this.DataSource, "KHDDBH"); //this.tcDDSL.DataBindings.Add("Text", this.DataSource, ""); this.tcBCCHSL.DataBindings.Add("Text", this.DataSource, "BCCHSL", global::Helper.DateTimeParse.GetFormatA(BL.V.SetDataFormat.XSSLXiao.Value)); this.tcDW.DataBindings.Add("Text", this.DataSource, "DanWei"); this.tcDJ.DataBindings.Add("Text", this.DataSource, "DanJia", global::Helper.DateTimeParse.GetFormatA(BL.V.SetDataFormat.CGDJXiao.Value)); this.tcZheRang.DataBindings.Add("Text", this.DataSource, "ZheRang", global::Helper.DateTimeParse.GetFormatA(BL.V.SetDataFormat.CGJEXiao.Value)); this.tcJinE.DataBindings.Add("Text", this.DataSource, "JinE"); this.tcShuiE.DataBindings.Add("Text", this.DataSource, "ShuiE", "{0:0}"); this.tcYingShou.DataBindings.Add("Text", this.DataSource, "YingShou"); if (dt.Rows.Count > 0) { this.xrSubreport1.ReportSource = new ROInvoiceXSlistBiaoSub(dt); } this.TCZHeJi.Summary.FormatString = "{0:0}"; this.TCZHeJi.Summary.Func = SummaryFunc.Sum; this.TCZHeJi.Summary.IgnoreNullValues = true; this.TCZHeJi.Summary.Running = SummaryRunning.Report; this.TCZHeJi.DataBindings.Add("Text", this.DataSource, "JinE"); this.TCZShuiE.Summary.FormatString = "{0:0}"; this.TCZShuiE.Summary.Func = SummaryFunc.Sum; this.TCZShuiE.Summary.IgnoreNullValues = true; this.TCZShuiE.Summary.Running = SummaryRunning.Report; this.TCZShuiE.DataBindings.Add("Text", this.DataSource, "ShuiE"); this.TCZZongJi.Summary.FormatString = "{0:0}"; this.TCZZongJi.Summary.Func = SummaryFunc.Sum; this.TCZZongJi.Summary.IgnoreNullValues = true; this.TCZZongJi.Summary.Running = SummaryRunning.Report; this.TCZZongJi.DataBindings.Add("Text", this.DataSource, "YingShou"); }
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, string reportName) : 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 = reportName; 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 ROInvoiceXO(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.InvoiceXO> Details = 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); if (Details == null || Details.Count <= 0) { throw new global::Helper.InvalidValueException(); } this.bindingSource1.DataSource = Details; this.lblInvoiceId.DataBindings.Add("Text", this.DataSource, Model.Invoice.PROPERTY_INVOICEID); this.lblInvoiceDate.DataBindings.Add("Text", this.DataSource, Model.Invoice.PROPERTY_INVOICEDATE, "{0:yyyy-MM-dd}"); this.lblCustomer.DataBindings.Add("Text", this.DataSource, "Customer." + Model.Customer.PRO_CustomerFullName); this.lblLotNumber.DataBindings.Add("Text", this.DataSource, Model.InvoiceXO.PRO_CustomerLotNumber); // this.xrLabelEmp0.DataBindings.Add("Text", this.DataSource, "Employee0." + Model.Employee.PROPERTY_EMPLOYEENAME); this.xrLabelEmpCheck.DataBindings.Add("Text", this.DataSource, "Employee0." + Model.Employee.PROPERTY_EMPLOYEENAME); this.lblYJRQ.DataBindings.Add("Text", this.DataSource, Model.InvoiceXO.PRO_InvoiceYjrq, "{0:yyyy-MM-dd}"); this.lblChuHuoCustomer.DataBindings.Add("Text", this.DataSource, "xocustomer." + Model.Customer.PRO_CustomerShortName); this.lblInvoiceHeji.DataBindings.Add("Text", this.DataSource, Model.InvoiceXO.PRO_InvoiceHeji, "{0:0}"); this.lblInvoiceTax.DataBindings.Add("Text", this.DataSource, Model.InvoiceXO.PRO_InvoiceTax, "{0:0}"); this.lblInvoiceTotal.DataBindings.Add("Text", this.DataSource, Model.InvoiceXO.PRO_InvoiceTotal, "{0:0}"); this.lblCustomerInvoiceXOID.DataBindings.Add("Text", this.DataSource, Model.InvoiceXO.PRO_CustomerInvoiceXOId); this.xrLabelTotalHeJi.Summary.FormatString = "{0:0}"; this.xrLabelTotalHeJi.Summary.Func = SummaryFunc.Sum; this.xrLabelTotalHeJi.Summary.IgnoreNullValues = true; this.xrLabelTotalHeJi.Summary.Running = SummaryRunning.Report; this.xrLabelTotalHeJi.DataBindings.Add("Text", this.DataSource, Model.InvoiceXS.PRO_InvoiceHeji, "{0:0}"); this.xrLabelTotalTax.Summary.FormatString = "{0:0}"; this.xrLabelTotalTax.Summary.Func = SummaryFunc.Sum; this.xrLabelTotalTax.Summary.IgnoreNullValues = true; this.xrLabelTotalTax.Summary.Running = SummaryRunning.Report; this.xrLabelTotalTax.DataBindings.Add("Text", this.DataSource, Model.InvoiceXS.PRO_InvoiceTax, "{0:0}"); this.xrLabelTotalZongJi.Summary.FormatString = "{0:0}"; this.xrLabelTotalZongJi.Summary.Func = SummaryFunc.Sum; this.xrLabelTotalZongJi.Summary.IgnoreNullValues = true; this.xrLabelTotalZongJi.Summary.Running = SummaryRunning.Report; this.xrLabelTotalZongJi.DataBindings.Add("Text", this.DataSource, Model.InvoiceXS.PRO_InvoiceTotal, "{0:0}"); this.xrSubreport1.ReportSource = new ROInvoiceXO_1(condition); }
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); }
public Q20(ConditionX condition) : this() { DateTime start = condition.StartDate; DateTime end = condition.EndDate; this.xrLabelReportName.Text = Properties.Resources.CHDetail; this.xrLabelDateRange.Text = string.Format(Properties.Resources.DateRange, start.ToString("yyyy-MM-dd"), end.ToString("yyyy/MM/dd")); this.bindingSource1.DataSource = this.invoiceManager.SelectDateRangAndWhere(condition.Customer1, condition.StartDate, condition.EndDate, condition.CusXOId, condition.Product, null, null, null); if (this.bindingSource1.DataSource == null) { throw new global::Helper.InvalidValueException("無數據"); } this.xrLabelInvoiceId.DataBindings.Add("Text", this.DataSource, Model.Invoice.PROPERTY_INVOICEID); this.xrLabelInvoiceDate.DataBindings.Add("Text", this.DataSource, Model.Invoice.PROPERTY_INVOICEDATE, "{0:yyyy-MM-dd}"); this.xrLabelSupplier.DataBindings.Add("Text", this.DataSource, "Customer." + Model.Customer.PRO_CustomerFullName); this.xrLabelDepot.DataBindings.Add("Text", this.DataSource, "Depot." + Model.Depot.PRO_DepotName); this.xrLabelEmp0.DataBindings.Add("Text", this.DataSource, "Employee0." + Model.Employee.PROPERTY_EMPLOYEENAME); this.xrLabelEmpCheck.DataBindings.Add("Text", this.DataSource, "Employee1." + Model.Employee.PROPERTY_EMPLOYEENAME); this.xrLabelCGDate.DataBindings.Add("Text", this.DataSource, Model.Invoice.PROPERTY_INVOICEDATE, "{0:yyyy-MM-dd}"); this.xrLabelChuHuoCustomer.DataBindings.Add("Text", this.DataSource, "XSCustomer." + Model.Customer.PRO_CustomerFullName); this.xrLabelTotalHeJi.Summary.FormatString = "{0:0}"; this.xrLabelTotalHeJi.Summary.Func = SummaryFunc.Sum; this.xrLabelTotalHeJi.Summary.IgnoreNullValues = true; this.xrLabelTotalHeJi.Summary.Running = SummaryRunning.Report; this.xrLabelTotalHeJi.DataBindings.Add("Text", this.DataSource, Model.InvoiceXS.PRO_InvoiceHeji, "{0:0}"); this.xrLabelTotalTax.Summary.FormatString = "{0:0}"; this.xrLabelTotalTax.Summary.Func = SummaryFunc.Sum; this.xrLabelTotalTax.Summary.IgnoreNullValues = true; this.xrLabelTotalTax.Summary.Running = SummaryRunning.Report; this.xrLabelTotalTax.DataBindings.Add("Text", this.DataSource, Model.InvoiceXS.PRO_InvoiceTax, "{0:0}"); this.xrLabelTotalZongJi.Summary.FormatString = "{0:0}"; this.xrLabelTotalZongJi.Summary.Func = SummaryFunc.Sum; this.xrLabelTotalZongJi.Summary.IgnoreNullValues = true; this.xrLabelTotalZongJi.Summary.Running = SummaryRunning.Report; this.xrLabelTotalZongJi.DataBindings.Add("Text", this.DataSource, Model.InvoiceXS.PRO_InvoiceTotal, "{0:0}"); this.xrSubreport1.ReportSource = new Q20_1(condition); }
public ROInvoiceXO_1(ConditionX cond) { InitializeComponent(); this.condition = cond; this.xrTableCellProductId.DataBindings.Add("Text", this.DataSource, Model.InvoiceXODetail.PRO_Inumber); this.xrTableCellProductName.DataBindings.Add("Text", this.DataSource, "Product." + Model.Product.PRO_ProductName); this.xrTableCusPro.DataBindings.Add("Text", this.DataSource, "Product." + Model.Product.PRO_CustomerProductName); this.xrTablePrice.DataBindings.Add("Text", this.DataSource, Model.InvoiceXODetail.PRO_InvoiceXODetailPrice, "{0:0.###}"); this.xrTableHeJi.DataBindings.Add("Text", this.DataSource, Model.InvoiceXODetail.PRO_InvoiceXODetailMoney, "{0:0.###}"); this.xrTableOrderQuantity.DataBindings.Add("Text", this.DataSource, Model.InvoiceXODetail.PRO_InvoiceXODetailQuantity, "{0:0.###}"); this.xrTableNoXGQuantity.DataBindings.Add("Text", this.DataSource, Model.InvoiceXODetail.PRO_InvoiceXODetailQuantity0, "{0:0.###}"); this.xrTableZR.DataBindings.Add("Text", this.DataSource, Model.InvoiceXODetail.PRO_InvoiceAllowance, "{0:0.###}"); this.xrTableUnit.DataBindings.Add("Text", this.DataSource, Model.InvoiceXODetail.PRO_InvoiceProductUnit); this.xrCheckBoxZS.DataBindings.Add("Checked", this.DataSource, Model.InvoiceXODetail.PRO_Islargess); //this.xrTableZS.DataBindings.Add("Text", this.DataSource, Model.InvoiceXODetail.PRO_Islargess); //this.xrTableTransferQuantity.DataBindings.Add("Text", this.DataSource, Model.InvoiceCGDetail.PRO_ProduceTransferQuantity, "{0:0.###}"); //this.xrTableTax.DataBindings.Add("Text", this.DataSource, Model.InvoiceXODetail.PRO_InvoiceXODetailTax, "{0:0.###}"); //this.xrTableTaxTotal.DataBindings.Add("Text", this.DataSource, Model.InvoiceXODetail.PRO_InvoiceXOSDetailTaxMoney, "{0:0.###}"); //this.xrTableTaxPrice.DataBindings.Add("Text", this.DataSource, Model.InvoiceXODetail.PRO_InvoiceXODetailTaxPrice, "{0:0.###}"); // this.xrTableCellProductQuantity.DataBindings.Add("Text", this.DataSource, Model.InvoiceXSDetail.PRO_InvoiceXSDetailQuantity); }
public ROInvoiceXSlistBiaoNew(ConditionX condition) { InitializeComponent(); this.lbl_CompanyName.Text = BL.Settings.CompanyChineseName; this.lbl_ReportName.Text = "應收賬款明細表"; this.lbl_ReportDate.Text += DateTime.Now.ToString("yyyy-MM-dd"); this.lbl_DataRange.Text += condition.StartDate.ToString("yyyy-MM-dd") + " ~ " + condition.EndDate.ToString("yyyy-MM-dd"); dt = this.detailManager.SelectbyConditionXBiao(condition.StartDate, condition.EndDate, condition.Yjri1, condition.Yjri2, condition.Customer1, condition.Customer2, condition.Employee1, condition.Employee2, condition.XOId1, condition.XOId2, condition.Product, condition.Product2, condition.CusXOId, condition.OrderColumn, condition.OrderType, null, condition.Product_Id, condition.ProductCategoryId, condition.Currency); if (dt == null || dt.Rows.Count == 0) { throw new global::Helper.InvalidValueException("無記錄"); } var group = dt.AsEnumerable().GroupBy(r => r.Field <string>("CustomerFullName")).Select(S => S.Key).ToList <string>(); this.DataSource = group; this.xrSubreport1.ReportSource = new ROInvoiceXSlistBiaoNewSub(); }
//public Q20_1(IList<Model.CustomerProducts> customerProduct) // : this() //{ // this.customerProduct = customerProduct; // tag = 1; //xsdetail = this.detailManager.Select(invoice); //if (xsdetail != null) //{ // foreach (Model.InvoiceXSDetail detail in xsdetail) // { // foreach (Model.CustomerProducts product in this.customerProduct) // { // if (detail.PrimaryKeyId == product.PrimaryKeyId) // { // xsdetails.Add(detail); // } // } // } //} //} public Q20_1(ConditionX cond) { InitializeComponent(); this.condition = cond; this.xrTableCellProductId.DataBindings.Add("Text", this.DataSource, Model.InvoiceXSDetail.PRO_Inumber); this.xrTableCellProductName.DataBindings.Add("Text", this.DataSource, "Product." + Model.Product.PRO_ProductName); this.xrTableCellProductGuige.DataBindings.Add("Text", this.DataSource, "Product." + Model.Product.PRO_ProductSpecification); this.xrTableCellProductQuantity.DataBindings.Add("Text", this.DataSource, Model.InvoiceXSDetail.PRO_InvoiceXSDetailQuantity); this.xrTablePrice.DataBindings.Add("Text", this.DataSource, Model.InvoiceXSDetail.PRO_InvoiceXSDetailPrice, "{0:0.###}"); this.xrTableTaxPrice.DataBindings.Add("Text", this.DataSource, Model.InvoiceXSDetail.PRO_InvoiceXSDetailTaxPrice, "{0:0.###}"); this.xrTableHeJi.DataBindings.Add("Text", this.DataSource, Model.InvoiceXSDetail.PRO_InvoiceXSDetailMoney, "{0:0.###}"); this.xrTableTax.DataBindings.Add("Text", this.DataSource, Model.InvoiceXSDetail.PRO_InvoiceXSDetailTax, "{0:0.###}"); this.xrTableTaxTotal.DataBindings.Add("Text", this.DataSource, Model.InvoiceXSDetail.PRO_InvoiceXSDetailTaxMoney, "{0:0.###}"); this.xrTableOrderQuantity.DataBindings.Add("Text", this.DataSource, "InvoiceXODetail." + Model.InvoiceXODetail.PRO_InvoiceXODetailQuantity, "{0:0.###}"); this.xrTableNoXGQuantity.DataBindings.Add("Text", this.DataSource, "InvoiceXODetail." + Model.InvoiceXODetail.PRO_InvoiceXODetailQuantity0, "{0:0.###}"); this.xrTableZS.DataBindings.Add("Text", this.DataSource, Model.InvoiceCGDetail.PRO_InvoiceCGDetaiInQuantity, "{0:0.###}"); //this.xrTableTransferQuantity.DataBindings.Add("Text", this.DataSource, Model.InvoiceCGDetail.PRO_ProduceTransferQuantity, "{0:0.###}"); this.xrTableZR.DataBindings.Add("Text", this.DataSource, Model.InvoiceXSDetail.PRO_InvoiceAllowance, "{0:0.###}"); this.xrTableUnit.DataBindings.Add("Text", this.DataSource, Model.InvoiceXSDetail.PRO_InvoiceProductUnit); this.xrCheckBoxZS.DataBindings.Add("Checked", this.DataSource, Model.InvoiceXSDetail.PRO_Donatetowards); this.xrTableCellXOId.DataBindings.Add("Text", this.DataSource, "InvoiceXO" + Model.InvoiceXO.PRO_CustomerInvoiceXOId); this.xrTableInvoiceXSDetailFPQuantity.DataBindings.Add("Text", this.DataSource, Model.InvoiceXSDetail.PRO_InvoiceXSDetailFPQuantity); }
protected override void OnOK() { if (this.condition == null) { this.condition = new ConditionX(); } if (global::Helper.DateTimeParse.DateTimeEquls(this.dateEditStartDate.DateTime, new DateTime())) { this.condition.StartDate = global::Helper.DateTimeParse.NullDate; } else { this.condition.StartDate = this.dateEditStartDate.DateTime; } if (global::Helper.DateTimeParse.DateTimeEquls(this.dateEditEndDate.DateTime, new DateTime())) { this.condition.EndDate = global::Helper.DateTimeParse.EndDate; } else { this.condition.EndDate = this.dateEditEndDate.DateTime; } if (global::Helper.DateTimeParse.DateTimeEquls(this.dateEditJHDate1.DateTime, new DateTime())) { this.condition.Yjri1 = global::Helper.DateTimeParse.NullDate; } else { this.condition.Yjri1 = this.dateEditJHDate1.DateTime; } if (global::Helper.DateTimeParse.DateTimeEquls(this.dateEditJHDate2.DateTime, new DateTime())) { this.condition.Yjri2 = global::Helper.DateTimeParse.EndDate; } else { this.condition.Yjri2 = this.dateEditJHDate2.DateTime; } this.condition.Product = this.buttonEditPro.EditValue as Model.Product; this.condition.Product2 = this.buttonEditPro2.EditValue as Model.Product; this.condition.CusXOId = this.textEditCusXOId.Text == "" ? null : this.textEditCusXOId.Text; this.condition.Customer1 = this.newChooseCustomer.EditValue as Model.Customer; this.condition.Customer2 = this.newChooseCustomer2.EditValue as Model.Customer; this.condition.Employee1 = this.newChooseEmp1.EditValue as Model.Employee; this.condition.Employee2 = this.newChooseEmp2.EditValue as Model.Employee; this.condition.IsClose = this.ceisclose.Checked; this.condition.XOId1 = this.textEditCOID1.Text; this.condition.XOId2 = this.textEditCOID2.Text; this.condition.OrderColumn = this.ComboxOrderColumn.SelectedIndex == -1 ? 0 : this.ComboxOrderColumn.SelectedIndex; this.condition.OrderType = this.ComboxOrderType.SelectedIndex == -1 ? 0 : this.ComboxOrderType.SelectedIndex; this.condition.DetailFlag = this.checkEditDetailFlag.Checked; this.condition.FreightedCompanyId = this.lookUpEdit1.EditValue == null ? null : this.lookUpEdit1.Text; this.condition.ConveyanceMethodId = this.lookUpEdit2.EditValue == null ? null : this.lookUpEdit2.EditValue.ToString(); this.condition.Special = this.checkEditSpecial.Checked; this.condition.XOCustomerId1 = this.ncc_XOCustomer1.EditValue as Model.Customer; this.condition.XOCustomerId2 = this.ncc_XOCustomer2.EditValue as Model.Customer; if (btn_Category.EditValue != null) { this.condition.ProductCategoryId = (btn_Category.EditValue as Model.ProductCategory).ProductCategoryId; } if (nccSupplier.EditValue != null) { this.condition.SupplierId = (nccSupplier.EditValue as Model.Supplier).SupplierId; } }
public ROInvoiceXSlist2(ConditionX condition) : this() { DateTime start = condition.StartDate; DateTime end = condition.EndDate; this.lblCompanyName.Text = BL.Settings.CompanyChineseName; this.lblReportName.Text = Properties.Resources.CHDetail; this.lblReportdate.Text += DateTime.Now.ToShortDateString(); //PrintCondition this.lblReprotCondition.Text += "\t單據日期區間:" + condition.StartDate.ToString("yyyy-MM-dd") + "~" + condition.EndDate.AddDays(1).ToString("yyyy-MM-dd"); if (condition.Yjri1 != Helper.DateTimeParse.NullDate && condition.Yjri2 != Helper.DateTimeParse.EndDate) { this.lblReprotCondition.Text += "\t預交日期:" + condition.Yjri1.ToString("yyyy-MM-dd") + "~" + condition.Yjri2.AddDays(1).ToString("yyyy-MM-dd"); } if (condition.Customer1 != null && condition.Customer2 != null) { if (condition.Customer1.CustomerId == condition.Customer2.CustomerId) { this.lblReprotCondition.Text += "\t客戶區間:" + condition.Customer1.ToString(); } else { this.lblReprotCondition.Text += "\t客戶區間:" + condition.Customer1.ToString() + "~" + condition.Customer2.ToString(); } } if (!string.IsNullOrEmpty(condition.XOId1) && !string.IsNullOrEmpty(condition.XOId2)) { this.lblReprotCondition.Text += "\t出貨單編號:" + condition.XOId1 + "~" + condition.XOId1; } if (!string.IsNullOrEmpty(condition.CusXOId)) { this.lblReprotCondition.Text += "\t客戶訂單編號:" + condition.CusXOId; } if (condition.Product != null && condition.Product != null) { if (condition.Product.ProductId == condition.Product2.ProductId) { this.lblReprotCondition.Text += "\t商品:" + condition.Product.ToString(); } else { this.lblReprotCondition.Text += "\t商品:" + condition.Product.ToString() + "~" + condition.Product2.ToString(); } } //bind this.DataSource = this.detailManager.SelectbyConditionX(condition.StartDate, condition.EndDate, condition.Yjri1, condition.Yjri2, condition.Customer1, condition.Customer2, condition.XOId1, condition.XOId2, condition.Product, condition.Product2, condition.CusXOId, condition.OrderColumn, condition.OrderType); if (this.DataSource == null) { throw new global::Helper.InvalidValueException("無記錄"); } this.xrTableXSid.DataBindings.Add("Text", this.DataSource, Model.InvoiceXSDetail.PRO_InvoiceId); this.xrTableXSDate.DataBindings.Add("Text", this.DataSource, "Invoice." + Model.InvoiceXS.PROPERTY_INVOICEDATE, "{0:yyyy/MM/dd}"); this.TCXOCustomer.DataBindings.Add("Text", this.DataSource, "Invoice.XSCustomer." + Model.Customer.PRO_CustomerFullName); this.TCYJDate.DataBindings.Add("Text", this.DataSource, "InvoiceXO." + Model.InvoiceXO.PRO_InvoiceYjrq, "{0:yyyy/MM/dd}"); this.xrTableCellProductName.DataBindings.Add("Text", this.DataSource, "Product." + Model.Product.PRO_ProductName); //this.xrTableCellProductGuige.DataBindings.Add("Text", this.DataSource, "Product." + Model.Product.PRO_ProductSpecification); this.TCCustomerProductName.DataBindings.Add("Text", this.DataSource, "Product." + Model.Product.PRO_CustomerProductName); this.xrTableCellProductQuantity.DataBindings.Add("Text", this.DataSource, Model.InvoiceXSDetail.PRO_InvoiceXSDetailQuantity); this.xrTablePrice.DataBindings.Add("Text", this.DataSource, Model.InvoiceXSDetail.PRO_InvoiceXSDetailPrice, "{0:0.###}"); //this.xrTableTaxPrice.DataBindings.Add("Text", this.DataSource, Model.InvoiceXSDetail.PRO_InvoiceXSDetailTaxPrice, "{0:0.###}"); this.xrTableHeJi.DataBindings.Add("Text", this.DataSource, Model.InvoiceXSDetail.PRO_InvoiceXSDetailMoney, "{0:0.###}"); //this.xrTableTax.DataBindings.Add("Text", this.DataSource, Model.InvoiceXSDetail.PRO_InvoiceXSDetailTax, "{0:0.###}"); //this.xrTableTaxTotal.DataBindings.Add("Text", this.DataSource, Model.InvoiceXSDetail.PRO_InvoiceXSDetailTaxMoney, "{0:0.###}"); //this.xrTableOrderQuantity.DataBindings.Add("Text", this.DataSource, "InvoiceXODetail." + Model.InvoiceXODetail.PRO_InvoiceXODetailQuantity, "{0:0.###}"); this.xrTableNoXGQuantity.DataBindings.Add("Text", this.DataSource, "InvoiceXODetail." + Model.InvoiceXODetail.PRO_InvoiceXODetailQuantity0, "{0:0.###}"); //this.xrTableZS.DataBindings.Add("Text", this.DataSource, Model.InvoiceCGDetail.PRO_InvoiceCGDetaiInQuantity, "{0:0.###}"); //this.xrTableTransferQuantity.DataBindings.Add("Text", this.DataSource, Model.InvoiceCGDetail.PRO_ProduceTransferQuantity, "{0:0.###}"); //this.xrTableZR.DataBindings.Add("Text", this.DataSource, Model.InvoiceXSDetail.PRO_InvoiceAllowance, "{0:0.###}"); this.xrTableUnit.DataBindings.Add("Text", this.DataSource, Model.InvoiceXSDetail.PRO_InvoiceProductUnit); //this.xrCheckBoxZS.DataBindings.Add("Checked", this.DataSource, Model.InvoiceXSDetail.PRO_Donatetowards); this.xrTableCellXOId.DataBindings.Add("Text", this.DataSource, "InvoiceXO." + Model.InvoiceXO.PRO_CustomerInvoiceXOId); //this.xrTableInvoiceXSDetailFPQuantity.DataBindings.Add("Text", this.DataSource, Model.InvoiceXSDetail.PRO_InvoiceXSDetailFPQuantity); 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.InvoiceXSDetail.PRO_InvoiceXSDetailQuantity); this.xrlblTotalShuiE.Summary.FormatString = "{0:0}"; this.xrlblTotalShuiE.Summary.Func = SummaryFunc.Sum; this.xrlblTotalShuiE.Summary.IgnoreNullValues = true; this.xrlblTotalShuiE.Summary.Running = SummaryRunning.Report; this.xrlblTotalShuiE.DataBindings.Add("Text", this.DataSource, Model.InvoiceXSDetail.PRO_InvoiceXSDetailTax, "{0:0}"); 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.InvoiceXSDetail.PRO_InvoiceXSDetailMoney, "{0:0}"); this.xrlblTotalHeJi.Summary.FormatString = "{0:0}"; this.xrlblTotalHeJi.Summary.Func = SummaryFunc.Sum; this.xrlblTotalHeJi.Summary.IgnoreNullValues = true; this.xrlblTotalHeJi.Summary.Running = SummaryRunning.Report; this.xrlblTotalHeJi.DataBindings.Add("Text", this.DataSource, Model.InvoiceXSDetail.PRO_InvoiceXSDetailTaxMoney, "{0:0}"); }
protected override void OnOK() { if (this.condition == null) { this.condition = new ConditionX(); } if (global::Helper.DateTimeParse.DateTimeEquls(this.dateEditStartDate.DateTime, new DateTime())) { this.condition.StartDate = global::Helper.DateTimeParse.NullDate; } else { this.condition.StartDate = this.dateEditStartDate.DateTime; } if (global::Helper.DateTimeParse.DateTimeEquls(this.dateEditEndDate.DateTime, new DateTime())) { this.condition.EndDate = global::Helper.DateTimeParse.EndDate; } else { this.condition.EndDate = this.dateEditEndDate.DateTime; } if (global::Helper.DateTimeParse.DateTimeEquls(this.dateEditJHDate1.DateTime, new DateTime())) { this.condition.Yjri1 = global::Helper.DateTimeParse.NullDate; } else { this.condition.Yjri1 = this.dateEditJHDate1.DateTime; } if (global::Helper.DateTimeParse.DateTimeEquls(this.dateEditJHDate2.DateTime, new DateTime())) { this.condition.Yjri2 = global::Helper.DateTimeParse.EndDate; } else { this.condition.Yjri2 = this.dateEditJHDate2.DateTime; } this.condition.Product = this.buttonEditPro.EditValue as Model.Product; this.condition.Product2 = this.buttonEditPro2.EditValue as Model.Product; this.condition.CusXOId = this.textEditCusXOId.Text == "" ? null : this.textEditCusXOId.Text; this.condition.Customer1 = this.newChooseCustomer.EditValue as Model.Customer; this.condition.Customer2 = this.newChooseCustomer2.EditValue as Model.Customer; this.condition.Employee1 = this.newChooseEmp1.EditValue as Model.Employee; this.condition.Employee2 = this.newChooseEmp2.EditValue as Model.Employee; this.condition.IsClose = this.ceisclose.Checked; this.condition.XOId1 = this.textEditCOID1.Text; this.condition.XOId2 = this.textEditCOID2.Text; this.condition.OrderColumn = this.ComboxOrderColumn.SelectedIndex == -1 ? 0 : this.ComboxOrderColumn.SelectedIndex; this.condition.OrderType = this.ComboxOrderType.SelectedIndex == -1 ? 0 : this.ComboxOrderType.SelectedIndex; this.condition.DetailFlag = this.checkEditDetailFlag.Checked; this.condition.DepotId = this.lue_Depot.EditValue == null ? null : this.lue_Depot.EditValue.ToString(); //this.condition.HandBookId = this.cob_HandBookId.Text; if (!string.IsNullOrEmpty(this.cob_HandBookId.Text)) { string bgHandBookId = ""; string[] bgHandBookIds = this.cob_HandBookId.Text.Split(','); foreach (var item in bgHandBookIds) { bgHandBookId += "'" + item.Trim() + "',"; } bgHandBookId = bgHandBookId.TrimEnd(','); this.condition.HandBookId = bgHandBookId; } }
public ROInvoiceXSlistBiao(ConditionX condition) : this() { this.xrLabelReportName.Text = "‘ªÊÕÙ~¿îÃ÷¼š±í"; this.lblCustomerName.Text = condition.Customer1 == null ? "" : condition.Customer1.ToString(); this.lblDateRange.Text = " •rég…^ég:" + condition.StartDate.ToString("yyyy-MM-dd") + " ~ " + condition.EndDate.ToString("yyyy-MM-dd"); //bind //this.DataSource = this.detailManager.SelectbyConditionX(condition.StartDate, condition.EndDate, condition.Yjri1, condition.Yjri2, condition.Customer1, condition.Customer2, condition.XOId1, condition.XOId2, condition.Product, condition.Product2, condition.CusXOId, condition.OrderColumn, condition.OrderType); //if ((bool)condition.Special) //{ // this.DataSource = this.detailManager.SelectbyConditionXBiao(condition.StartDate, condition.EndDate, condition.Yjri1, condition.Yjri2, condition.Customer1, condition.Customer2, condition.XOId1, condition.XOId2, condition.Product, condition.Product2, condition.CusXOId, condition.OrderColumn, condition.OrderType, false, condition.Product_Id,condition.ProductCategoryId); // dt = this.detailManager.SelectbyConditionXBiao(condition.StartDate, condition.EndDate, condition.Yjri1, condition.Yjri2, condition.Customer1, condition.Customer2, condition.XOId1, condition.XOId2, condition.Product, condition.Product2, condition.CusXOId, condition.OrderColumn, condition.OrderType, condition.Special, condition.Product_Id, condition.ProductCategoryId); //} //else this.DataSource = this.detailManager.SelectbyConditionXBiao(condition.StartDate, condition.EndDate, condition.Yjri1, condition.Yjri2, condition.Customer1, condition.Customer2, condition.Employee1, condition.Employee2, condition.XOId1, condition.XOId2, condition.Product, condition.Product2, condition.CusXOId, condition.OrderColumn, condition.OrderType, null, condition.Product_Id, condition.ProductCategoryId, condition.Currency); //if (this.DataSource == null || (this.DataSource as IList<Model.InvoiceXSDetail>).Count == 0) if ((this.DataSource == null || (this.DataSource as System.Data.DataTable).Rows.Count == 0)) { throw new global::Helper.InvalidValueException("ŸoÓ›ä›"); } this.tcCHDH.DataBindings.Add("Text", this.DataSource, "CHDH"); this.tcCHRQ.DataBindings.Add("Text", this.DataSource, "CHRQ", "{0:yyyy-MM-dd}"); this.tcProductName.DataBindings.Add("Text", this.DataSource, "ProductName"); this.tcKHDDBH.DataBindings.Add("Text", this.DataSource, "KHDDBH"); //this.tcDDSL.DataBindings.Add("Text", this.DataSource, ""); this.tcBCCHSL.DataBindings.Add("Text", this.DataSource, "BCCHSL", global::Helper.DateTimeParse.GetFormatA(BL.V.SetDataFormat.XSSLXiao.Value)); this.tcDW.DataBindings.Add("Text", this.DataSource, "DanWei"); this.tcDJ.DataBindings.Add("Text", this.DataSource, "DanJia", global::Helper.DateTimeParse.GetFormatA(BL.V.SetDataFormat.CGDJXiao.Value)); this.tcZheRang.DataBindings.Add("Text", this.DataSource, "ZheRang", global::Helper.DateTimeParse.GetFormatA(BL.V.SetDataFormat.CGJEXiao.Value)); this.tcJinE.DataBindings.Add("Text", this.DataSource, "JinE"); this.tcShuiE.DataBindings.Add("Text", this.DataSource, "ShuiE", "{0:0}"); this.tcYingShou.DataBindings.Add("Text", this.DataSource, "YingShou", global::Helper.DateTimeParse.GetFormatA(BL.V.SetDataFormat.CGDJXiao.Value)); this.TCCurrency.DataBindings.Add("Text", this.DataSource, "Currency"); this.TCCurrencyTotal.DataBindings.Add("Text", this.DataSource, "TaibiTotal", global::Helper.DateTimeParse.GetFormatA(BL.V.SetDataFormat.CGDJXiao.Value)); this.TCZHeJi.Summary.FormatString = "{0:0}"; this.TCZHeJi.Summary.Func = SummaryFunc.Sum; this.TCZHeJi.Summary.IgnoreNullValues = true; this.TCZHeJi.Summary.Running = SummaryRunning.Report; this.TCZHeJi.DataBindings.Add("Text", this.DataSource, "JinE"); this.TCZShuiE.Summary.FormatString = "{0:0}"; this.TCZShuiE.Summary.Func = SummaryFunc.Sum; this.TCZShuiE.Summary.IgnoreNullValues = true; this.TCZShuiE.Summary.Running = SummaryRunning.Report; this.TCZShuiE.DataBindings.Add("Text", this.DataSource, "ShuiE"); this.TCZZongJi.Summary.FormatString = "{0:0}"; this.TCZZongJi.Summary.Func = SummaryFunc.Sum; this.TCZZongJi.Summary.IgnoreNullValues = true; this.TCZZongJi.Summary.Running = SummaryRunning.Report; this.TCZZongJi.DataBindings.Add("Text", this.DataSource, "YingShou"); this.lbTaibiTotal.Summary.FormatString = "{0:0}"; this.lbTaibiTotal.Summary.Func = SummaryFunc.Sum; this.lbTaibiTotal.Summary.IgnoreNullValues = true; this.lbTaibiTotal.Summary.Running = SummaryRunning.Report; this.lbTaibiTotal.DataBindings.Add("Text", this.DataSource, "TaibiTotal"); }