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(); } } }