private void btnSelect_Click_1(object sender, EventArgs e) { string strCondition = null; strCondition = " SELECT 1 排序, * FROM BTSKBM WHERE fdate='" + this.dateTimePicker1.Value.ToShortDateString() + "' AND 收银员 LIKE '%" + this.textBox1.Text.Trim() + "%' "; strCondition += " UNION ALL "; strCondition += " SELECT 2 排序, fdate, NULL 收银员, '合计' 市场,NULL K3代码,NULL 客户名称,SUM(ISNULL(前日累欠,0))前日累欠, "; strCondition += " SUM(ISNULL(礼券,0))礼券 ,SUM(ISNULL(现金收款,0))现金收款,SUM(ISNULL(银行存款,0))银行存款, "; strCondition += " SUM(ISNULL([余额(不含当天销售)],0)) [余额(不含当天销售)],SUM(ISNULL(差额,0))差额, "; strCondition += " SUM(ISNULL(头数1,0))头数1,SUM(ISNULL(重量1,0))重量1,SUM(ISNULL(金额1,0))金额1, "; strCondition += " SUM(ISNULL(头数2,0))头数2,SUM(ISNULL(重量2,0))重量2,SUM(ISNULL(金额2,0))金额2, "; strCondition += " SUM(ISNULL(头数3,0))头数3,SUM(ISNULL(重量3,0))重量3,SUM(ISNULL(金额3,0))金额3, "; strCondition += " SUM(ISNULL(头数4,0))头数4,SUM(ISNULL(重量4,0))重量4,SUM(ISNULL(金额4,0))金额4, "; strCondition += " SUM(ISNULL(头数5,0))头数5,SUM(ISNULL(重量5,0))重量5,SUM(ISNULL(金额5,0))金额5, "; strCondition += " SUM(ISNULL(折让金额,0))折让金额,SUM(ISNULL(当日应付,0))当日应付,SUM(ISNULL(次日实收现金,0))次日实收现金,SUM(ISNULL(累计余额,0))累计余额, "; strCondition += " NULL 欠款确认签名,NULL 内码,NULL 标记,NULL 账套 "; strCondition += " FROM BTSKBM WHERE fdate='" + this.dateTimePicker1.Value.ToShortDateString() + "' "; strCondition += " AND 收银员 LIKE '%" + this.textBox1.Text.Trim() + "%' "; strCondition += " AND 标记='明细' GROUP BY fdate"; strCondition += " ORDER BY 排序,K3代码,市场,标记"; dt = db.GetDataTable(strCondition, "exceltab"); if (this.radioButton1.Checked == true) { crystalReportViewer1.ReportSource = commUse.CrystalReports("btpfsk.rpt", strCondition, "BTSKBM"); } if (this.radioButton2.Checked == true) { crystalReportViewer1.ReportSource = commUse.CrystalReports("Btsk_d_new.rpt", strCondition, "BTSKBM"); } }
private void btnQuery_Click(object sender, EventArgs e) { string strCondition = null; if (dtpStartDate.Value.Date > dtpEndDate.Value.Date) { MessageBox.Show("开始日期不许大于结束日期", "软件提示"); return; } strCondition = "Select * From SEOutStore Where IsFlag = '1' "; //起始日期 if (dtpStartDate.ShowCheckBox) { if (dtpStartDate.Checked) { strCondition += " and SEOutDate >= '" + dtpStartDate.Value.ToString("yyyy-MM-dd") + "' "; } } //截止日期 if (dtpEndDate.ShowCheckBox) { if (dtpEndDate.Checked) { strCondition += " and SEOutDate <= '" + dtpEndDate.Value.ToString("yyyy-MM-dd") + "' "; } } //客户 if (cbxCustomerCode.SelectedValue != null) { strCondition += " and CustomerCode = '" + cbxCustomerCode.SelectedValue + "' "; } //产品 if (cbxInvenCode.SelectedValue != null) { strCondition += " and InvenCode = '" + cbxInvenCode.SelectedValue + "' "; } crySelCollectReport.ReportSource = commUse.CrystalReports("CrySelCollectReport.rpt", strCondition, "SEOutStore"); }
private void btnQuery_Click(object sender, EventArgs e) { string strCondition = null; if (dtpStartDate.Value.Date > dtpEndDate.Value.Date) { MessageBox.Show("开始日期不许大于结束日期", "软件提示"); return; } strCondition = "Select * From PUInStore Where IsFlag = '1' "; //起始日期 if (dtpStartDate.ShowCheckBox == true) { if (dtpStartDate.Checked == true) { strCondition += " and PUInDate >= '" + dtpStartDate.Value.ToString("yyyy-MM-dd") + "' "; } } //截止日期 if (dtpEndDate.ShowCheckBox == true) { if (dtpEndDate.Checked == true) { strCondition += " and PUInDate <= '" + dtpEndDate.Value.ToString("yyyy-MM-dd") + "' "; } } //供应商 if (cbxSupplierCode.SelectedValue != null) { strCondition += " and SupplierCode = '" + cbxSupplierCode.SelectedValue.ToString() + "' "; } //原材料 if (cbxInvenCode.SelectedValue != null) { strCondition += " and InvenCode = '" + cbxInvenCode.SelectedValue.ToString() + "' "; } cryPurReport.ReportSource = commUse.CrystalReports("CryPurReport.rpt", strCondition, "PUInStore"); }
private void btnQuery_Click(object sender, EventArgs e) { string strCondition = null; strCondition = "( {STStock.Quantity} < {BSInven.SmallStockNum} or {STStock.Quantity} > {BSInven.BigStockNum} )"; //存货 if (cbxStoreCode.SelectedValue != null) { strCondition += " and {STStock.StoreCode} = '" + cbxStoreCode.SelectedValue.ToString() + "' "; } //仓库 if (cbxInvenCode.SelectedValue != null) { strCondition += " and {STStock.InvenCode} = '" + cbxInvenCode.SelectedValue.ToString() + "' "; } cryStockWarnReport.ReportSource = commUse.CrystalReports("CryStockWarnReport.rpt", strCondition); }
private void btnQuery_Click(object sender, EventArgs e) { string strCondition = null;//声明表示SQL语句的字符串 if (dtpStartDate.Value.Date > dtpEndDate.Value.Date) { MessageBox.Show("开始日期不许大于结束日期", "软件提示"); return; } //查询已审核的销售出库单 strCondition = "Select * From SEOutStore Where SEOutStore.IsFlag = '1' "; //起始日期 if (dtpStartDate.ShowCheckBox == true) //在日期控件中显示复选框 { if (dtpStartDate.Checked == true) //选中日期控件中的复选框 { //单据日期大于或等于开始日期 strCondition += " and SEOutStore.SEOutDate >= '" + dtpStartDate.Value.ToString("yyyy-MM-dd") + "' "; } } //截止日期 if (dtpEndDate.ShowCheckBox == true) //在日期控件中显示复选框 { if (dtpEndDate.Checked == true) //选中日期控件中的复选框 { //单据日期小于或等于结束日期 strCondition += " and SEOutStore.SEOutDate <= '" + dtpEndDate.Value.ToString("yyyy-MM-dd") + "' "; } } if (cbxInvenCode.SelectedValue != null) { //指定产品 strCondition += " and SEOutStore.InvenCode = '" + cbxInvenCode.SelectedValue.ToString() + "' "; } //将统计得到的报表绑定到CrystalReportViewer控件 crySelProfitCollectReport.ReportSource = commUse.CrystalReports("CrystalSelProfitCollectReport.rpt", strCondition, "SEOutStore"); }
private void btnSelect_Click(object sender, EventArgs e) { if (this.textBox1.Text.Trim().ToString() == "" && this.textBox2.Text.Trim().ToString() == "") { MessageBox.Show("必须输入客户代码 或客户名称"); return; } //string sqlstr = " SELECT DISTINCT K3代码 FROM BTSKBM WHERE 标记='明细' and fdate BETWEEN '" + this.dateTimePicker1.Value.ToShortDateString() + // "' AND '" + this.dateTimePicker2.Value.ToShortDateString() + "' AND K3代码+客户名称 LIKE '%" + this.textBox1.Text.Trim() + "%'"; //DataSet ds = db.GetDataSet(sqlstr,"tab"); // if (ds.Tables[0].Rows.Count!=1) // { // MessageBox.Show("查询出的客户不是唯一或不存在!"); // return; // } string strCondition = null; if (rg1.Checked == true) { strCondition = " SELECT * FROM BTSKBM WHERE 标记='汇总' and fdate BETWEEN '" + this.dateTimePicker1.Value.ToShortDateString() + "' AND '" + this.dateTimePicker2.Value.ToShortDateString() + "' "; if (textBox1.Text.Trim().Length > 0) { strCondition += " and K3代码='" + textBox1.Text.Trim() + "'"; } if (textBox2.Text.Trim().Length > 0) { strCondition += " and 客户名称='" + textBox2.Text.Trim() + "'"; } strCondition += " ORDER BY fdate "; dt = db.GetDataTable(strCondition, "exceltab"); crystalReportViewer1.ReportSource = commUse.CrystalReports("Btsk_d_dz.rpt", strCondition, "exceltab"); } else if (rg2.Checked == true) { // strCondition = " SELECT * FROM BTSKBM WHERE 标记='明细' and fdate BETWEEN '" + this.dateTimePicker1.Value.ToShortDateString() + //"' AND '" + this.dateTimePicker2.Value.ToShortDateString() + "' AND K3代码+客户名称 LIKE '%" + this.textBox1.Text.Trim() + "%' ORDER BY fdate"; strCondition = " SELECT * FROM BTSKBM WHERE 标记='明细' and fdate BETWEEN '" + this.dateTimePicker1.Value.ToShortDateString() + "' AND '" + this.dateTimePicker2.Value.ToShortDateString() + "' "; if (textBox1.Text.Trim().Length > 0) { strCondition += " and K3代码='" + textBox1.Text.Trim() + "'"; } if (textBox2.Text.Trim().Length > 0) { strCondition += " and 客户名称='" + textBox2.Text.Trim() + "'"; } strCondition += " ORDER BY fdate "; dt = db.GetDataTable(strCondition, "exceltab"); crystalReportViewer1.ReportSource = commUse.CrystalReports("Btsk_d_dz.rpt", strCondition, "exceltab"); } }