protected override void OnOK() { if (this.condition == null) { condition = new ConditionF(); } condition.StartDate = this.dateEditStartDate.DateTime; condition.EndDate = this.dateEditEndDate.DateTime; if (this.kind == global::Helper.CompanyKind.Supplier) { condition.StartId = (this.nccCustomerStart.EditValue as Model.Supplier) == null ? null : (this.nccCustomerStart.EditValue as Model.Supplier).Id; condition.EndId = (this.nccCustomerEnd.EditValue as Model.Supplier) == null ? null : (this.nccCustomerEnd.EditValue as Model.Supplier).Id; condition.StartChuHuoId = string.Empty; condition.EndChuHuoId = string.Empty; foreach (string str in comboBoxSupplierCategory.Properties.Items.GetCheckedValues()) { condition.CategoryId += '"' + str + '"' + ','; } } else { condition.StartId = (this.nccCustomerStart.EditValue as Model.Customer) == null ? null : (this.nccCustomerStart.EditValue as Model.Customer).Id; condition.EndId = (this.nccCustomerEnd.EditValue as Model.Customer) == null ? null : (this.nccCustomerEnd.EditValue as Model.Customer).Id; condition.StartChuHuoId = (this.nccCustomerChuHuoStart.EditValue as Model.Customer) == null ? "" : (this.nccCustomerChuHuoStart.EditValue as Model.Customer).Id; condition.EndChuHuoId = (this.nccCustomerChuHuoEnd.EditValue as Model.Customer) == null ? "" : (this.nccCustomerChuHuoEnd.EditValue as Model.Customer).Id; } }
//构造 public Q33(ConditionF condition) { InitializeComponent(); this.condition = condition; this.xrLabelDateRange.Text = string.Format(Properties.Resources.DateRange, condition.StartDate.ToString("yyyy-MM-dd"), condition.EndDate.ToString("yyyy-MM-dd")); this.xrLabelReportName.Text = Properties.Resources.SKCXRBB; }
/// <summary> /// 构造函数,初始化 /// </summary> /// <param name="conditioon"></param> public Q30(ConditionF conditioon) { InitializeComponent(); this.detailManager = new Book.BL.InvoiceDetail01Manager(); this.xrLabelReportName.Text = Properties.Resources.YSZKTJB; this.xrLabelDateRange.Text = string.Format(Properties.Resources.DateRange, conditioon.StartDate.ToString("yyyy-MM-dd"), conditioon.EndDate.ToString("yyyy-MM-dd")); System.Collections.Generic.IList <Model.InvoiceDetail01> list = this.detailManager.Select1(conditioon.StartDate, conditioon.EndDate, conditioon.StartId, conditioon.EndId, Helper.CompanyKind.Customer); if (list == null || list.Count <= 0) { throw new Helper.InvalidValueException(); } this.bindingSource1.DataSource = list; this.xrTableCellCustomId.DataBindings.Add("Text", this.DataSource, Model.InvoiceDetail01.PROPERTY_COMPANYID); this.xrTableCellTax.DataBindings.Add("Text", this.DataSource, Model.InvoiceDetail01.PROPERTY_INVOICETAX, "{0:0}"); this.xrTableCellZre.DataBindings.Add("Text", this.DataSource, Model.InvoiceDetail01.PROPERTY_INVOICEZRE, "{0:0}"); this.xrTableCellZS.DataBindings.Add("Text", this.DataSource, Model.InvoiceDetail01.PROPERTY_INVOICEZSE, "{0:0}"); //this.xrTableCustomName.DataBindings.Add("Text", this.DataSource, "Company." + Model.Company.PROPERTY_COMPANYNAME1, "{0:0}"); this.xrTableCellYiShou.DataBindings.Add("Text", this.DataSource, Model.InvoiceDetail01.PROPERTY_YISHOU, "{0:0}"); this.xrTableCellYingShou.DataBindings.Add("Text", this.DataSource, Model.InvoiceDetail01.PROPERTY_INVOICEOWED, "{0:0}"); this.xrTableCellTotalTax.Summary.FormatString = "{0:0}"; this.xrTableCellTotalYingShou.Summary.FormatString = "{0:0}"; this.xrTableCellTotalYiShou.Summary.FormatString = "{0:0}"; this.xrTableCellTotalZse.Summary.FormatString = "{0:0}"; this.xrTableCellTotalZre.Summary.FormatString = "{0:0}"; this.xrTableCellTotalTax.Summary.Func = SummaryFunc.Sum; this.xrTableCellTotalYingShou.Summary.Func = SummaryFunc.Sum; this.xrTableCellTotalYiShou.Summary.Func = SummaryFunc.Sum; this.xrTableCellTotalZse.Summary.Func = SummaryFunc.Sum; this.xrTableCellTotalZre.Summary.Func = SummaryFunc.Sum; this.xrTableCellTotalTax.Summary.IgnoreNullValues = true; this.xrTableCellTotalYingShou.Summary.IgnoreNullValues = true; this.xrTableCellTotalYiShou.Summary.IgnoreNullValues = true; this.xrTableCellTotalZse.Summary.IgnoreNullValues = true; this.xrTableCellTotalZre.Summary.IgnoreNullValues = true; this.xrTableCellTotalTax.Summary.Running = SummaryRunning.Report; this.xrTableCellTotalYingShou.Summary.Running = SummaryRunning.Report; this.xrTableCellTotalYiShou.Summary.Running = SummaryRunning.Report; this.xrTableCellTotalZse.Summary.Running = SummaryRunning.Report; this.xrTableCellTotalZre.Summary.Running = SummaryRunning.Report; this.xrTableCellTotalTax.DataBindings.Add("Text", this.DataSource, Model.InvoiceDetail01.PROPERTY_INVOICETAX, "{0:0}"); this.xrTableCellTotalYingShou.DataBindings.Add("Text", this.DataSource, Model.InvoiceDetail01.PROPERTY_INVOICEOWED, "{0:0}"); this.xrTableCellTotalYiShou.DataBindings.Add("Text", this.DataSource, Model.InvoiceDetail01.PROPERTY_YISHOU, "{0:0}"); this.xrTableCellTotalZse.DataBindings.Add("Text", this.DataSource, Model.InvoiceDetail01.PROPERTY_INVOICEZSE, "{0:0}"); this.xrTableCellTotalZre.DataBindings.Add("Text", this.DataSource, Model.InvoiceDetail01.PROPERTY_INVOICEZRE, "{0:0}"); }
public CustomerTransactionsRank(ConditionF condition) { InitializeComponent(); this.xrLabelReportName.Text = Properties.Resources.KHJYPH; this.xrLabelDateRange.Text = string.Format(Properties.Resources.DateRange, condition.StartDate.ToString("yyyy-MM-dd"), condition.EndDate.ToString("yyyy-MM-dd")); this.xrLabelIdreanger.Text = string.Format("{0}-{1}", condition.StartId, condition.EndId); System.Data.DataTable list = this.miscDateManager.SelectForCustomerTransactionRank(condition.StartDate, condition.EndDate, condition.StartId, condition.EndId, condition.StartChuHuoId, condition.EndChuHuoId); if (list == null || list.Rows.Count <= 0) { throw new Helper.InvalidValueException(); } this.bindingSource1.DataSource = list; this.DataSource = this.bindingSource1.DataSource; this.TCChangShangbianHao.DataBindings.Add("Text", this.DataSource, "Id"); this.TCgongsimingcheng.DataBindings.Add("Text", this.DataSource, "CustomerFullName"); this.TCjinhuojine.DataBindings.Add("Text", this.DataSource, "JinHuoJinE", "{0:0}"); this.TCno.DataBindings.Add("Text", this.DataSource, "SortId"); this.TCshijinjine.DataBindings.Add("Text", this.DataSource, "ShiJinJinE", "{0:0}"); this.TCtuihuojine.DataBindings.Add("Text", this.DataSource, "TuiHuoJinE", "{0:0}"); this.TCzherangjine.DataBindings.Add("Text", this.DataSource, "ZheRangJinE", "{0:0}"); this.TCsumJHJE.Summary.FormatString = "{0:0}"; this.TCsumJHJE.Summary.Func = SummaryFunc.Sum; this.TCsumJHJE.Summary.IgnoreNullValues = true; this.TCsumJHJE.Summary.Running = SummaryRunning.Report; this.TCsumJHJE.DataBindings.Add("Text", this.DataSource, "JinHuoJinE", "{0:0}"); this.TCsumSJJE.Summary.FormatString = "{0:0}"; this.TCsumSJJE.Summary.Func = SummaryFunc.Sum; this.TCsumSJJE.Summary.IgnoreNullValues = true; this.TCsumSJJE.Summary.Running = SummaryRunning.Report; this.TCsumSJJE.DataBindings.Add("Text", this.DataSource, "ShiJinJinE", "{0:0}"); this.TCsumTHJE.Summary.FormatString = "{0:0}"; this.TCsumTHJE.Summary.Func = SummaryFunc.Sum; this.TCsumTHJE.Summary.IgnoreNullValues = true; this.TCsumTHJE.Summary.Running = SummaryRunning.Report; this.TCsumTHJE.DataBindings.Add("Text", this.DataSource, "TuiHuoJinE", "{0:0}"); this.TCsumZRJE.Summary.FormatString = "{0:0}"; this.TCsumZRJE.Summary.Func = SummaryFunc.Sum; this.TCsumZRJE.Summary.IgnoreNullValues = true; this.TCsumZRJE.Summary.Running = SummaryRunning.Report; this.TCsumZRJE.DataBindings.Add("Text", this.DataSource, "ZheRangJinE", "{0:0}"); }
/// <summary> /// 构造函数 /// </summary> /// <param name="condition"></param> public Q34(ConditionF condition) { this.condition = condition; InitializeComponent(); this.xrLabelReportName.Text = Properties.Resources.FKCXRBB; this.xrLabelDateRange.Text = string.Format(Properties.Resources.DateRange, condition.StartDate.ToString("yyyy-MM-dd"), condition.EndDate.ToString("yyyy-MM-dd")); //System.Collections.Generic.IList<Model.Company> list = this.companyManager.Select(condition.StartId, condition.EndId, Helper.CompanyKind.Supplier); //if (list == null || list.Count <= 0) // throw new Helper.InvalidValueException(); //this.bindingSource1.DataSource = list; //this.xrTableCellCompanyId.DataBindings.Add("Text", this.DataSource, Model.Company.PROPERTY_COMPANYID); //this.xrTableCellCompanyName.DataBindings.Add("Text", this.DataSource, Model.Company.PROPERTY_COMPANYNAME1); //this.GroupHeader1.GroupFields.Add(new GroupField(Model.Company.PROPERTY_COMPANYID)); //this.xrSubreport1.ReportSource = new Q34_1(); }
/// <summary> /// 一参构造 /// </summary> /// <param name="conditioon"></param> public Q28(ConditionF conditioon) { InitializeComponent(); this.xrLabelReportName.Text = Properties.Resources.YFZKDetail; this.xrLabelDateRange.Text = string.Format(Properties.Resources.DateRange, conditioon.StartDate.ToString("yyyy-MM-dd"), conditioon.EndDate.ToString("yyyy-MM-dd")); this.xrLableAddress.Text = BL.Settings.CompanyAddress1; this.xrLabelCpyFax.Text = string.Format("Fax:{0}", BL.Settings.CompanyFax); this.xrLabelCpyTel.Text = string.Format("Tel:{0}", BL.Settings.CompanyPhone); System.Collections.Generic.IList <Model.InvoiceCG> list = this.invoiceManager.Select(conditioon.StartDate, conditioon.EndDate, conditioon.StartId, conditioon.EndId); if (list == null || list.Count <= 0) { throw new global::Helper.InvalidValueException("無數據"); } this.bindingSource1.DataSource = list; this.xrLabelCustomId.DataBindings.Add("Text", this.DataSource, Model.InvoiceCG.PRO_SupplierId); //this.xrLabelCustomName.DataBindings.Add("Text", this.DataSource, "Company." + Model.Company.PROPERTY_COMPANYNAME1); //this.xrLabelFax.DataBindings.Add("Text", this.DataSource, "Company." + Model.Company.PROPERTY_COMPANYFAX); //this.xrLabelLinkMan.DataBindings.Add("Text", this.DataSource, "Company." + Model.Company.PROPERTY_COMPANYCONTACT); //this.xrLabelTel.DataBindings.Add("Text", this.DataSource, "Company." + Model.Company.PROPERTY_COMPANYPHONE); //this.xrLabelToYiBianHao.DataBindings.Add("Text", this.DataSource, "Company." + Model.Company.PROPERTY_COMPANYNUMBER); //this.xrTableCellFphm.DataBindings.Add("Text", this.DataSource, Model.InvoiceCG.PROPERTY_INVOICEFPBH); this.xrTableCellInvoiceDate.DataBindings.Add("Text", this.DataSource, Model.InvoiceCG.PROPERTY_INVOICEDATE, "{0:yyyy-MM-dd}"); this.xrTableCellInvoiceId.DataBindings.Add("Text", this.DataSource, Model.InvoiceCG.PROPERTY_INVOICEID); this.xrTableCellKind.DataBindings.Add("Text", this.DataSource, Model.InvoiceCG.PROPERTY_KIND); //this.xrTableCellProductId.DataBindings.Add("Text", this.DataSource, Model.InvoiceCGDetail.PRO_Id); //this.xrTableCellProductName.DataBindings.Add("Text", this.DataSource, "Product." + Model.Product.PRO_ProductName); //this.xrTableCellQuantity.DataBindings.Add("Text", this.DataSource, Model.InvoiceCGDetail.PROPERTY_INVOICEDETAILQUANTITY); //this.xrTableCellUnit.DataBindings.Add("Text", this.DataSource, "Product." + Model.Product.PROPERTY_PRODUCTBASEUNIT); //this.xrTableCellUnitPrice.DataBindings.Add("Text", this.DataSource, Model.InvoiceCGDetail.PROPERTY_INVOICEDETAILPRICE, "{0:0}"); //this.xrTableCell1TotalMoney.DataBindings.Add("Text", this.DataSource, Model.InvoiceCGDetail.PROPERTY_INVOICEDETAILMONEY0, "{0:0}"); this.xrLabelZRE.Summary.FormatString = "{0:0}"; this.xrLabelZSE.Summary.FormatString = "{0:0}"; this.xrLabelYiShou.Summary.FormatString = "{0:0}"; this.xrLabelBeqiHeJi.Summary.FormatString = "{0:0}"; this.xrLabelBenQiZongJi.Summary.FormatString = "{0:0}"; this.xrLabelTax.Summary.FormatString = "{0:0}"; this.xrLabelZRE.Summary.Func = SummaryFunc.Sum; this.xrLabelZSE.Summary.Func = SummaryFunc.Sum; this.xrLabelYiShou.Summary.Func = SummaryFunc.Sum; this.xrLabelBeqiHeJi.Summary.Func = SummaryFunc.Sum; this.xrLabelBenQiZongJi.Summary.Func = SummaryFunc.Sum; this.xrLabelTax.Summary.Func = SummaryFunc.Sum; this.xrLabelZRE.Summary.IgnoreNullValues = true; this.xrLabelZSE.Summary.IgnoreNullValues = true; this.xrLabelYiShou.Summary.IgnoreNullValues = true; this.xrLabelBeqiHeJi.Summary.IgnoreNullValues = true; this.xrLabelBenQiZongJi.Summary.IgnoreNullValues = true; this.xrLabelTax.Summary.IgnoreNullValues = true; this.xrLabelZRE.Summary.Running = SummaryRunning.Group; this.xrLabelZSE.Summary.Running = SummaryRunning.Group; this.xrLabelYiShou.Summary.Running = SummaryRunning.Group; this.xrLabelBeqiHeJi.Summary.Running = SummaryRunning.Group; this.xrLabelBenQiZongJi.Summary.Running = SummaryRunning.Group; this.xrLabelTax.Summary.Running = SummaryRunning.Group; //this.xrLabelZRE.DataBindings.Add("Text", this.DataSource, Model.InvoiceCG.PROPERTY_INVOICEZRE, "{0:0}"); //this.xrLabelZSE.DataBindings.Add("Text", this.DataSource, Model.InvoiceCG.PROPERTY_INVOICEZSE, "{0:0}"); this.xrLabelYiShou.DataBindings.Add("Text", this.DataSource, Model.InvoiceCG.PROPERTY_YIFU, "{0:0}"); //this.xrLabelBeqiHeJi.DataBindings.Add("Text", this.DataSource, Model.InvoiceCG.PROPERTY_INVOICEHEJI, "{0:0}"); //this.xrLabelBenQiZongJi.DataBindings.Add("Text", this.DataSource, Model.InvoiceCG.PROPERTY_INVOICEZONGJI, "{0:0}"); //this.xrLabelTax.DataBindings.Add("Text", this.DataSource, Model.InvoiceCG.PROPERTY_INVOICETAX, "{0:0}"); this.GroupHeader1.GroupFields.Add(new GroupField("Company." + Model.InvoiceCG.PRO_SupplierId)); }
public Q26(ConditionF condition) { InitializeComponent(); this.xrLabelReportName.Text = Properties.Resources.YFZKJYB; this.xrLabelDateRange.Text = string.Format(Properties.Resources.DateRange, condition.StartDate.ToString("yyyy-MM-dd"), condition.EndDate.ToString("yyyy-MM-dd")); System.Collections.Generic.IList <Model.InvoiceCG> list = this.invoiceManager.Select(condition.StartDate, condition.EndDate, condition.StartId, condition.EndId); if (list == null || list.Count <= 0) { throw new global::Helper.InvalidValueException(); } this.bindingSource1.DataSource = list; this.xrLabelCompanyId.DataBindings.Add("Text", this.DataSource, Model.InvoiceCG.PRO_SupplierId); //this.xrLabelCompanyName.DataBindings.Add("Text", this.DataSource, "Company." + Model.Company.PROPERTY_COMPANYNAME1); this.xrTableCellKind.DataBindings.Add("Text", this.DataSource, Model.InvoiceCG.PROPERTY_KIND); //this.xrTableCellFPHM.DataBindings.Add("Text", this.DataSource, Model.InvoiceCG.PROPERTY_INVOICEFPBH); this.xrTableCellInvoiceDate.DataBindings.Add("Text", this.DataSource, Model.InvoiceCG.PROPERTY_INVOICEDATE, "{0:yyyy-MM-dd}"); //this.xrTableCellInvoiceHeJi.DataBindings.Add("Text", this.DataSource, Model.InvoiceCG.PROPERTY_INVOICEHEJI, "{0:0}"); this.xrTableCellInvoiceId.DataBindings.Add("Text", this.DataSource, Model.InvoiceCG.PROPERTY_INVOICEID); //this.xrTableCellInvoiceZongJi.DataBindings.Add("Text", this.DataSource, Model.InvoiceCG.PROPERTY_INVOICEZONGJI, "{0:0}"); //this.xrTableCellTax.DataBindings.Add("Text", this.DataSource, Model.InvoiceCG.PROPERTY_INVOICETAX, "{0:0}"); //this.xrTableCellWeiFu.DataBindings.Add("Text", this.DataSource, Model.InvoiceCG.PROPERTY_INVOICEOWED, "{0:0}"); this.xrTableCellYiShou.DataBindings.Add("Text", this.DataSource, Model.InvoiceCG.PROPERTY_YIFU, "{0:0}"); //this.xrTableCellZre.DataBindings.Add("Text", this.DataSource, Model.InvoiceCG.PROPERTY_INVOICEZRE, "{0:0}"); this.xrLabelBenQiHeji.Summary.FormatString = "{0:0}"; this.xrLabelBenQiZongJi.Summary.FormatString = "{0:0}"; this.xrLabelZRE.Summary.FormatString = "{0:0}"; this.xrLabelZSE.Summary.FormatString = "{0:0}"; this.xrLabelTax.Summary.FormatString = "{0:0}"; this.xrLabelYiShou.Summary.FormatString = "{0:0}"; this.xrLabelZSE.Summary.Func = SummaryFunc.Sum; this.xrLabelZRE.Summary.Func = SummaryFunc.Sum; this.xrLabelBenQiZongJi.Summary.Func = SummaryFunc.Sum; this.xrLabelBenQiHeji.Summary.Func = SummaryFunc.Sum; this.xrLabelTax.Summary.Func = SummaryFunc.Sum; this.xrLabelYiShou.Summary.Func = SummaryFunc.Sum; this.xrLabelBenQiHeji.Summary.IgnoreNullValues = true; this.xrLabelBenQiZongJi.Summary.IgnoreNullValues = true; this.xrLabelZRE.Summary.IgnoreNullValues = true; this.xrLabelZSE.Summary.IgnoreNullValues = true; this.xrLabelTax.Summary.IgnoreNullValues = true; this.xrLabelYiShou.Summary.IgnoreNullValues = true; this.xrLabelZSE.Summary.Running = SummaryRunning.Group; this.xrLabelZRE.Summary.Running = SummaryRunning.Group; this.xrLabelBenQiZongJi.Summary.Running = SummaryRunning.Group; this.xrLabelBenQiHeji.Summary.Running = SummaryRunning.Group; this.xrLabelTax.Summary.Running = SummaryRunning.Group; this.xrLabelYiShou.Summary.Running = SummaryRunning.Group; //this.xrLabelBenQiHeji.DataBindings.Add("Text", this.DataSource, Model.InvoiceCG.PROPERTY_INVOICEHEJI, "{0:0}"); //this.xrLabelBenQiZongJi.DataBindings.Add("Text", this.DataSource, Model.InvoiceCG.PROPERTY_INVOICEZONGJI, "{0:0}"); //this.xrLabelZRE.DataBindings.Add("Text", this.DataSource, Model.InvoiceCG.PROPERTY_INVOICEZRE, "{0:0}"); //this.xrLabelZSE.DataBindings.Add("Text", this.DataSource, Model.InvoiceCG.PROPERTY_INVOICEZSE, "{0:0}"); //this.xrLabelTax.DataBindings.Add("Text", this.DataSource, Model.InvoiceCG.PROPERTY_INVOICETAX, "{0:0}"); this.xrLabelYiShou.DataBindings.Add("Text", this.DataSource, Model.InvoiceCG.PROPERTY_YIFU, "{0:0}"); //this.GroupHeader1.GroupFields.Add(new GroupField("Company." + Model.Company.PROPERTY_COMPANYID)); }