private void RetrieveUntreadBaseBillInfo(string strUntreadBillNo) { RetailUntreadBaseBill rurb = new RetailUntreadBaseBill(); String strSql = "Select UntreadBaseBill.*,SaleOrderBill.*,Customer.* From UntreadBaseBill,SaleOrderBill,Customer "; strSql += "Where UntreadBaseBill.SaleBillNo = SaleOrderBill.SaleBillNo and UntreadBaseBill.CustomerId = Customer.CustomerId and UntreadBaseBill.UntreadBillNo = '" + strUntreadBillNo + "'"; DataTable dt = rurb.GetDataTable(strSql); if (dt.Rows.Count > 0) { SetUntreadBaseBillInfo(dt.Rows[0]); } else { MessageBox.Show("该退货单不存在!", "软件提示"); txtUntreadBillNo.Focus(); return; } }
private void btnQuery_Click(object sender, EventArgs e) { RetailUntreadBaseBill rubb = new RetailUntreadBaseBill(); string strSql = null; if (!chbIsCDNo.Checked) //没有选中光盘号查询 { if (!String.IsNullOrEmpty(txtCustomerName.Text.Trim())) { strSql += " and CustomerName like '%" + txtCustomerName.Text.Trim() + "%'"; } if (!(cbxProvinceCode.SelectedValue == null)) { strSql += " and ProvinceCode = '" + cbxProvinceCode.SelectedValue.ToString() + "'"; } if (!String.IsNullOrEmpty(txtAddress.Text.Trim())) { strSql += " and Address like '%" + txtAddress.Text.Trim() + "%'"; } if (!String.IsNullOrEmpty(txtPhoneNumber.Text.Trim())) { strSql += " and PhoneNumber like '%" + txtPhoneNumber.Text.Trim() + "%'"; } if (!(cbxGoodsTypeCode.SelectedValue == null)) { strSql += " and UntreadBaseBill.GoodsTypeCode = '" + cbxGoodsTypeCode.SelectedValue.ToString() + "'"; } if (!(cbxGoodsSeriesCode.SelectedValue == null)) { strSql += " and UntreadBaseBill.GoodsSeriesCode = '" + cbxGoodsSeriesCode.SelectedValue.ToString() + "'"; } if (dtpUntreadBillDate.Checked) { strSql += " and UntreadBillDate = '" + dtpUntreadBillDate.Value.Date + "'"; } if (chbIsGather.Visible) { if (chbIsGather.Checked) { strSql += " and UntreadBaseBill.UntreadBillNo not in(Select UntreadGatherBill.UntreadBillNo From UntreadGatherBill) "; //是否可以改进 } } if (chbIsRefund.Visible) { if (chbIsRefund.Checked) { strSql += " and UntreadBaseBill.UntreadBillNo not in(Select UntreadRefundBill.UntreadBillNo From UntreadRefundBill) "; //是否可以改进 } } strSql = rubb.UntreadBaseBillSql + strSql; } if (chbIsCDNo.Checked) //选中光盘号查询 { if (String.IsNullOrEmpty(txtCDNo.Text.Trim())) { MessageBox.Show("请输入光盘号!", "软件提示"); txtCDNo.Focus(); return; } strSql = rubb.UntreadBaseBill_CDNo_Sql + " and UntreadCDRecord.CDNo = '" + txtCDNo.Text.Trim() + "'"; } //设置DataTable主键,并为dgvRetailSaleOrderBill设置数据源 DataTable dt = rubb.GetDataTable(strSql); dt.PrimaryKey = new DataColumn[] { dt.Columns["UntreadBillNo"] }; dgvUntreadBaseBill.DataSource = dt; }
private void btnQuery_Click(object sender, EventArgs e) { RetailUntreadBaseBill rubb = new RetailUntreadBaseBill(); string strSql = null; if (!chbIsCDNo.Checked) //没有选中光盘号查询 { strSql = "Select UntreadBaseBill.* From UntreadBaseBill,Customer " + "Where UntreadBaseBill.CustomerId = Customer.CustomerId "; if (!String.IsNullOrEmpty(txtCustomerName.Text.Trim())) { strSql += " and CustomerName like '%" + txtCustomerName.Text.Trim() + "%'"; } if (!(cbxProvinceCode.SelectedValue == null)) { strSql += " and ProvinceCode = '" + cbxProvinceCode.SelectedValue.ToString() + "'"; } if (!String.IsNullOrEmpty(txtAddress.Text.Trim())) { strSql += " and Address like '%" + txtAddress.Text.Trim() + "%'"; } if (!String.IsNullOrEmpty(txtPhoneNumber.Text.Trim())) { strSql += " and PhoneNumber like '%" + txtPhoneNumber.Text.Trim() + "%'"; } if (!String.IsNullOrEmpty(txtUntreadBillNo.Text.Trim())) { strSql += " and UntreadBillNo like '%" + txtUntreadBillNo.Text.Trim() + "%'"; } if (!(cbxGoodsTypeCode.SelectedValue == null)) { strSql += " and GoodsTypeCode = '" + cbxGoodsTypeCode.SelectedValue.ToString() + "'"; } if (!(cbxGoodsSeriesCode.SelectedValue == null)) { strSql += " and GoodsSeriesCode = '" + cbxGoodsSeriesCode.SelectedValue.ToString() + "'"; } if (dtpUntreadBillDate.Checked) { strSql += " and UntreadBillDate = '" + dtpUntreadBillDate.Value.Date + "'"; } if (dtpAppendDate.Checked) { strSql += " and UntreadBaseBill.AppendDate = '" + dtpAppendDate.Value.Date + "'"; } } if (chbIsCDNo.Checked) //选中光盘号查询 { if (String.IsNullOrEmpty(txtCDNo.Text.Trim())) { MessageBox.Show("请输入光盘号!", "软件提示"); txtCDNo.Focus(); return; } strSql = "Select UntreadBaseBill.* From UntreadCDRecord, UntreadBaseBill,Customer " + "Where UntreadCDRecord.UntreadBillNo = UntreadBaseBill.UntreadBillNo and UntreadBaseBill.CustomerId = Customer.CustomerId "; } formRetailUntreadBaseBill.bsUntreadBaseBill.DataSource = rubb.GetDataTable(strSql); formRetailUntreadBaseBill.dgvUntreadBaseBill.DataSource = formRetailUntreadBaseBill.bsUntreadBaseBill; this.Close(); }