private void btnQuery_Click(object sender, EventArgs e)
{
RetailBarterBaseBill rbbb = new RetailBarterBaseBill();
string strSql = null;
if (!chbIsCDNo.Checked) //没有选中光盘号查询
{
strSql = rbbb.BarterBaseBillSql;
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(txtBarterBillNo.Text.Trim()))
{
strSql += " and BarterBaseBill.BarterBillNo like '%" + txtBarterBillNo.Text.Trim() + "%'";
}
if (!(cbxBarterType.SelectedValue == null))
{
strSql += " and BarterBaseBill.BarterType = '" + cbxBarterType.SelectedValue.ToString() + "'";
}
if (!(cbxEmployeeCode1.SelectedValue == null))
{
strSql += " and BarterBaseBill.EmployeeCode1 = '" + cbxEmployeeCode1.SelectedValue.ToString() + "'";
}
if (dtpBarterBillDate.Checked)
{
strSql += " and BarterBaseBill.BarterBillDate = '" + dtpBarterBillDate.Value.Date + "'";
}
if (dtpAppendDate.Checked)
{
strSql += " and BarterBaseBill.AppendDate = '" + dtpAppendDate.Value.Date + "'";
}
}
if (chbIsCDNo.Checked) //选中光盘号查询
{
if (String.IsNullOrEmpty(txtCDNo.Text.Trim()))
{
MessageBox.Show("请输入光盘号！", "软件提示");
txtCDNo.Focus();
return;
}
strSql = rbbb.BarterBaseBill_CDNo_Sql + " and BarterBaseCDRecord.CDNo = '" + txtCDNo.Text.Trim() + "'";
}
formRetailBarterBaseBill.dgvBarterBaseBill.DataSource = rbbb.GetDataTable(strSql);
this.Close();
}
private void GetBarterBaseBillInfo(string strBarterBillNo)
{
string strSql = null;
DataTable dt = null;
RetailSaleOrderBill rsob = new RetailSaleOrderBill();
strSql = "Select BarterBaseBill.*,Customer.* From BarterBaseBill,Customer Where BarterBaseBill.CustomerId = Customer.CustomerId and BarterBillNo = '" + strBarterBillNo + "'";
dt = rbbb.GetDataTable(strSql);
if (dt.Rows.Count > 0)
{
txtBarterBillNo.Text = dt.Rows[0]["BarterBillNo"].ToString();
txtSaleBillNo.Text = dt.Rows[0]["SaleBillNo"].ToString();
txtCustomerName.Text = dt.Rows[0]["CustomerName"].ToString();
this.intCustomerId = Convert.ToInt32(dt.Rows[0]["CustomerId"]);
cbxBarterType.SelectedValue = dt.Rows[0]["BarterType"];
dtpBarterBillDate.Value = Convert.ToDateTime(dt.Rows[0]["BarterBillDate"]);
cbxGoodsTypeCode.SelectedValue = dt.Rows[0]["GoodsTypeCode"];
cbxGoodsSeriesCode.SelectedValue = dt.Rows[0]["GoodsSeriesCode"];
txtUnitPrice.Text = dt.Rows[0]["UnitPrice"].ToString();
cbxGoodsTypeCode1.SelectedValue = dt.Rows[0]["GoodsTypeCode1"];
cbxGoodsSeriesCode1.SelectedValue = dt.Rows[0]["GoodsSeriesCode1"];
txtUnitPrice1.Text = dt.Rows[0]["UnitPrice1"].ToString();
txtBarterQuantity.Text = dt.Rows[0]["BarterQuantity"].ToString();
txtPhoneNumber.Text = dt.Rows[0]["PhoneNumber"].ToString();
if (dt.Rows[0]["IsNeedInvoice"].ToString() == "0")
{
rbIsNeedInvoice0.Checked = true;
}
else
{
rbIsNeedInvoice1.Checked = true;
}
txtAddress.Text = dt.Rows[0]["Address"].ToString();
txtRemark1.Text = dt.Rows[0]["Remark1"].ToString();
cbxEmployeeCode1.SelectedValue = dt.Rows[0]["EmployeeCode1"];
if (Convert.IsDBNull(dt.Rows[0]["SignDate1"]))
{
dtpSignDate1.Checked = false;
}
else
{
dtpSignDate1.Value = Convert.ToDateTime(dt.Rows[0]["SignDate1"]);
}
}
}
private void btnQuery_Click(object sender, EventArgs e)
{
string strSql = String.Empty; //声明string变量并初始化
RetailBarterBaseBill rbbb = new RetailBarterBaseBill();
if (!chbIsCDNo.Checked) //没有选中光盘号查询
{
strSql = rbbb.BarterBaseBillSql + GetQueryInfoString(); //设置基本的Sql语句
}
if (chbIsCDNo.Checked) //选中光盘号查询
{
strSql = rbbb.BarterBaseBill_CDNo_Sql + " and BarterBaseCDRecord.CDNo = '" + txtCDNo.Text.Trim() + "'";
}
dgvBarterBaseBill.DataSource = rbbb.GetDataTable(strSql);
}
private void RetrieveBarterBaseInfo(string strBarterBillNo)
{
string strSql = null;
DataTable dt = null;
RetailBarterBaseBill rbbb = new RetailBarterBaseBill();
strSql = "Select BarterBaseBill.*,Customer.* From BarterBaseBill,Customer Where BarterBaseBill.CustomerId = Customer.CustomerId and BarterBillNo = '" + strBarterBillNo + "'";
dt = rbbb.GetDataTable(strSql);
if (dt.Rows.Count > 0)
{
SetBarterBaseInfo(dt.Rows[0]);
}
else
{
MessageBox.Show("该调货单号不存在！", "软件提示");
txtBarterBillNo.Focus();
return;
}
}
