private void btnQuery_Click(object sender, EventArgs e)
{
RetailCustomer ro = new RetailCustomer();
if (!chbIsCDNo.Checked) //没有选中光盘号查询
{
string strWhere = "Where (CustomerType = '2' or CustomerType = '3')";
if (!String.IsNullOrEmpty(txtCustomerName.Text.Trim()))
{
strWhere += " and CustomerName like '%" + txtCustomerName.Text.Trim() + "%'";
}
if (!(cbxProvinceCode.SelectedValue == null))
{
strWhere += " and ProvinceCode = '" + cbxProvinceCode.SelectedValue.ToString() + "'";
}
if (!String.IsNullOrEmpty(txtAddress.Text.Trim()))
{
strWhere += " and Address like '%" + txtAddress.Text.Trim() + "%'";
}
if (!String.IsNullOrEmpty(txtPhoneNumber.Text.Trim()))
{
strWhere += " and PhoneNumber like '%" + txtPhoneNumber.Text.Trim() + "%'";
}
if (!String.IsNullOrEmpty(txtURL.Text.Trim()))
{
strWhere += " and URL like '%" + txtURL.Text.Trim() + "%'";
}
dgvRetailCustomer.DataSource = ro.GetDataTable("Customer", strWhere);
}
if (chbIsCDNo.Checked) //选中光盘号查询
{
if (String.IsNullOrEmpty(txtCDNo.Text.Trim()))
{
MessageBox.Show("请输入光盘号！", "软件提示");
txtCDNo.Focus();
return;
}
string strSql = "Select Customer.* From Customer,SaleOrderBill,SaleCDRecord,SaleConsignBill Where SaleCDRecord.SaleConsignBillId = SaleConsignBill.Id and SaleConsignBill.SaleBillNo = SaleOrderBill.SaleBillNo and SaleOrderBill.CustomerId = Customer.CustomerId";
dgvRetailCustomer.DataSource = ro.GetDataTable(strSql);
}
}
private void cbxCustomerId_SelectedIndexChanged(object sender, EventArgs e)
{
if (cbxCustomerId.SelectedValue != null)
{
if (cbxCustomerId.SelectedValue.GetType() == typeof(int))
{
m_CustomerNo = Convert.ToInt32(cbxCustomerId.SelectedValue);
DataTable dt = rc.GetDataTable("V_AgentRecord", " Where CustomerId = " + m_CustomerNo);
cbxProvinceCode.SelectedValue = dt.Rows[0]["ProvinceCode"];
txtAddress.Text = dt.Rows[0]["Address"].ToString();
txtPostalCode.Text = dt.Rows[0]["PostalCode"].ToString();
txtPhoneNumber.Text = dt.Rows[0]["PhoneNumber"].ToString();
txtURL.Text = dt.Rows[0]["URL"].ToString();
txtRemark.Text = dt.Rows[0]["Remark"].ToString();
}
}
}
