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