private void btnQuery_Click(object sender, EventArgs e) { DifferentMonth.DifferentMonthDataTable dmdt = null; ControlBindDataSource cbds = new ControlBindDataSource(); //判断月份是否合理 if (dtpStartMonth.Value >= dtpEndMonth.Value) { MessageBox.Show("开始月份不许大于或等于结束月份!", "软件提示"); return; } string strWhere = " Where 1 = 1 "; dmdt = this.GetDifferentMonthInfo(strWhere) as DifferentMonth.DifferentMonthDataTable; ReportDocument rd = cbds.CrystalReports(@"\UI\ChartAnalyse\CryReprot\CryDifferentMonthSaleAnalyse.rpt", dmdt); crvCollect.ReportSource = rd; TextObject txtNumValue = rd.ReportDefinition.ReportObjects["txtNumValue"] as TextObject; if (rbQuantity.Checked) { txtNumValue.Text = "销售数量(套)"; } else { txtNumValue.Text = "销售金额(元)"; } TextObject toDateRange = rd.ReportDefinition.ReportObjects["itoDateRange"] as TextObject; toDateRange.Text = "( " + dtpStartMonth.Value.Year.ToString() + "-" + dtpStartMonth.Value.Month.ToString() + " 至 " + dtpEndMonth.Value.Year.ToString() + "-" + dtpEndMonth.Value.Month.ToString() + " )"; }
private void btnQuery_Click(object sender, EventArgs e) { AllKinds.AllKindsDataTable akdt = null; ControlBindDataSource cbds = new ControlBindDataSource(); //判断日期是否合理 if (dtpStartDate.Value.Date > dtpEndDate.Value.Date) { MessageBox.Show("开始日期不许大于结束日期!", "软件提示"); return; } string strWhere = " Where 1 = 1 "; akdt = this.GetAllKindsInfo(strWhere) as AllKinds.AllKindsDataTable; ReportDocument rd = cbds.CrystalReports(@"\UI\ChartAnalyse\CryReprot\CryAllkindsSometimeSaleAnalyse.rpt", akdt); crvCollect.ReportSource = rd; TextObject txtNumValue = rd.ReportDefinition.ReportObjects["txtNumValue"] as TextObject; if (rbQuantity.Checked) { txtNumValue.Text = "销售数量(套)"; } else { txtNumValue.Text = "销售金额(元)"; } TextObject toDateRange = rd.ReportDefinition.ReportObjects["itoDateRange"] as TextObject; toDateRange.Text = "( " + dtpStartDate.Value.Year.ToString() + "-" + dtpStartDate.Value.Month.ToString() + "-" + dtpStartDate.Value.Day.ToString() + " 至 " + dtpEndDate.Value.Year.ToString() + "-" + dtpEndDate.Value.Month.ToString() + "-" + dtpEndDate.Value.Day.ToString() + " )"; }
private void btnQuery_Click(object sender, EventArgs e) { string strWhere = String.Empty; OperationCollect.OperationCollectDataTable dtCollect = null; ControlBindDataSource cbds = new ControlBindDataSource(); //判断日期是否合理 if (dtpStartDate.Value.Date > dtpEndDate.Value.Date) { MessageBox.Show("开始日期不许大于结束日期!", "软件提示"); return; } //判断是否选择用户类型 if (!chbAgent.Checked && !chbNoAgent.Checked) { MessageBox.Show("请选择一种用户类型!", "软件提示"); return; } //只选择代理 if (chbAgent.Checked && !chbNoAgent.Checked) { strWhere = " Where Customer.CustomerType = '1' "; } //只选择普通 if (!chbAgent.Checked && chbNoAgent.Checked) { strWhere = " Where (Customer.CustomerType = '2' or Customer.CustomerType = '3') "; } //同时选中代理和普通 if (chbAgent.Checked && chbNoAgent.Checked) { strWhere = " Where (Customer.CustomerType = '1' or Customer.CustomerType = '2' or Customer.CustomerType = '3') "; } dtCollect = this.GetCollectInfo(strWhere) as OperationCollect.OperationCollectDataTable; ReportDocument rd = cbds.CrystalReports(@"\UI\DataReport\CryReprot\CryOperationCollect.rpt", dtCollect); crvCollect.ReportSource = rd; TextObject toDateRange = rd.ReportDefinition.ReportObjects["itoDateRange"] as TextObject; TextObject toPrintDate = rd.ReportDefinition.ReportObjects["itoPrintDate"] as TextObject; TextObject toTile = rd.ReportDefinition.ReportObjects["itoTitle"] as TextObject; toDateRange.Text = "( " + dtpStartDate.Value.Year.ToString() + "-" + dtpStartDate.Value.Month.ToString() + "-" + dtpStartDate.Value.Day.ToString() + " 至 " + dtpEndDate.Value.Year.ToString() + "-" + dtpEndDate.Value.Month.ToString() + "-" + dtpEndDate.Value.Day.ToString() + " )"; toPrintDate.Text = GlobalProperty.DBTime.Date.ToString("yyy-MM-dd"); foreach (Control con in gbCollectType.Controls) { if (con.GetType() == typeof(RadioButton)) { if (((RadioButton)con).Checked) { toTile.Text = "编程词典" + ((RadioButton)con).Text + "表"; } } } }
private void btnQuery_Click(object sender, EventArgs e) { string strCondition = null; string strWhere = null; string strReportFileName = null; string strTableName = null; ControlBindDataSource cbds = new ControlBindDataSource(); //判断日期是否合理 if (dtpStartDate.Value.Date > dtpEndDate.Value.Date) { MessageBox.Show("开始日期不许大于结束日期!", "软件提示"); return; } //判断是否选择用户类型 if (!chbAgent.Checked && !chbNoAgent.Checked) { MessageBox.Show("请选择一种用户类型!", "软件提示"); return; } //只选择代理 if (chbAgent.Checked && !chbNoAgent.Checked) { strWhere = " Where Customer.CustomerType = '1' "; } //只选择普通 if (!chbAgent.Checked && chbNoAgent.Checked) { strWhere = " Where (Customer.CustomerType = '2' or Customer.CustomerType = '3') "; } //同时选中代理和普通 if (chbAgent.Checked && chbNoAgent.Checked) { strWhere = " Where (Customer.CustomerType = '1' or Customer.CustomerType = '2' or Customer.CustomerType = '3') "; } //销售 if (rbSale.Checked) { strCondition = "Select SaleOrderBill.* From SaleOrderBill,Customer " + strWhere + " and SaleOrderBill.CustomerId = Customer.CustomerId and SaleOrderBill.SaleBillNo in (Select SaleTradeBill.SaleBillNo From SaleTradeBill) "; if (dtpStartDate.Checked) { strCondition += " and SaleOrderBill.BillDate >= '" + dtpStartDate.Value.ToString("yyyy-MM-dd") + "' "; } if (dtpStartDate.Checked) { strCondition += " and SaleOrderBill.BillDate <= '" + dtpEndDate.Value.ToString("yyyy-MM-dd") + "' "; } strReportFileName = "CrySaleList.rpt"; strTableName = "SaleOrderBill"; } //退货 if (rbUntread.Checked) { strCondition = "Select UntreadBaseBill.* From UntreadBaseBill,Customer " + strWhere + " and UntreadBaseBill.CustomerId = Customer.CustomerId "; if (dtpStartDate.Checked) { strCondition += " and UntreadBaseBill.UntreadBillDate >= '" + dtpStartDate.Value.ToString("yyyy-MM-dd") + "' "; } if (dtpStartDate.Checked) { strCondition += " and UntreadBaseBill.UntreadBillDate <= '" + dtpEndDate.Value.ToString("yyyy-MM-dd") + "' "; } strReportFileName = "CryUntreadList.rpt"; strTableName = "UntreadBaseBill"; } //调货 if (rbBarter.Checked) { strCondition = "Select BarterBaseBill.* From BarterBaseBill,Customer " + strWhere + " and BarterBaseBill.CustomerId = Customer.CustomerId "; if (dtpStartDate.Checked) { strCondition += " and BarterBaseBill.BarterBillDate >= '" + dtpStartDate.Value.ToString("yyyy-MM-dd") + "' "; } if (dtpStartDate.Checked) { strCondition += " and BarterBaseBill.BarterBillDate <= '" + dtpEndDate.Value.ToString("yyyy-MM-dd") + "' "; } strReportFileName = "CryBarterList.rpt"; strTableName = "BarterBaseBill"; } ReportDocument rd = cbds.CrystalReports(@"\UI\DataReport\CryReprot\" + strReportFileName, strCondition, strTableName); crvList.ReportSource = rd; //显示数据 TextObject toDateRange = rd.ReportDefinition.ReportObjects["itoDateRange"] as TextObject; TextObject toPrintDate = rd.ReportDefinition.ReportObjects["itoPrintDate"] as TextObject; toDateRange.Text = "( " + dtpStartDate.Value.Year.ToString() + "-" + dtpStartDate.Value.Month.ToString() + "-" + dtpStartDate.Value.Day.ToString() + " 至 " + dtpEndDate.Value.Year.ToString() + "-" + dtpEndDate.Value.Month.ToString() + "-" + dtpEndDate.Value.Day.ToString() + " )"; toPrintDate.Text = GlobalProperty.DBTime.Date.ToString("yyy-MM-dd"); }