private void btnQuery_Click(object sender, EventArgs e) { RetailUntreadRefundBill rurb = new RetailUntreadRefundBill(); 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 (!String.IsNullOrEmpty(txtUntreadBillNo.Text.Trim())) { strSql += " and UntreadRefundBill.UntreadBillNo like '%" + txtUntreadBillNo.Text.Trim() + "%'"; } if (!(cbxPayTypeCode.SelectedValue == null)) { strSql += " and UntreadRefundBill.PayTypeCode = '" + cbxPayTypeCode.SelectedValue.ToString() + "'"; } if (!(cbxEmployeeCode3.SelectedValue == null)) { strSql += " and UntreadRefundBill.EmployeeCode3 = '" + cbxEmployeeCode3.SelectedValue.ToString() + "'"; } if (dtpUntreadMoneyDate.Checked) { strSql += " and UntreadRefundBill.UntreadMoneyDate = '" + dtpUntreadMoneyDate.Value.Date + "'"; } if (dtpAppendDate.Checked) { strSql += " and UntreadRefundBill.AppendDate = '" + dtpAppendDate.Value.Date + "'"; } strSql = rurb.UntreadRefundBillSql + strSql; } if (chbIsCDNo.Checked) //选中光盘号查询 { strSql = rurb.UntreadRefundBill_CDNo_Sql + " and UntreadCDRecord.CDNo = '" + txtCDNo.Text.Trim() + "'"; } formRetailUntreadRefundBill.dgvUntreadRefundBill.DataSource = rurb.GetDataTable(strSql); this.Close(); }
public void GetUntreadGatherBillInfo(string strUntreadBillNo) { string strSql = "Select UntreadGatherBill.* From UntreadGatherBill Where UntreadBillNo = '" + strUntreadBillNo + "'"; DataTable dt = rurb.GetDataTable(strSql); if (dt.Rows.Count > 0) { if (dt.Rows[0]["IsComplete"].ToString() == "0") { rbIsComplete0.Checked = true; } else { rbIsComplete1.Checked = true; } if (dt.Rows[0]["IsReturnInvoice"].ToString() == "0") { rbIsReturnInvoice0.Checked = true; } else { rbIsReturnInvoice1.Checked = true; } if (dt.Rows[0]["IsShatter"].ToString() == "0") { rbIsShatter0.Checked = true; } else { rbIsShatter1.Checked = true; } txtRemark2.Text = dt.Rows[0]["Remark2"].ToString(); cbxEmployeeCode2.SelectedValue = dt.Rows[0]["EmployeeCode2"]; dtpSignDate2.Value = Convert.ToDateTime(dt.Rows[0]["SignDate2"]); } }