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 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; } }
private void toolDelete_Click(object sender, EventArgs e) { if (dgvBarterBaseBill.RowCount == 0) { return; } if (GlobalProperty.OperatorCode != dgvBarterBaseBill.CurrentRow.Cells["OperatorCode"].Value.ToString()) { MessageBox.Show("非本记录的录入人员,不许允许删除!", "软件提示"); return; } if (MessageBox.Show("确定要删除吗?", "软件提示", MessageBoxButtons.YesNo, MessageBoxIcon.Exclamation) == DialogResult.Yes) { List <string> strSqls = new List <string>(); RetailBarterBaseBill rbbb = new RetailBarterBaseBill(); DataGridViewRow dgvr = dgvBarterBaseBill.CurrentRow; if (new Useful().IsExistConstraint("BarterBaseBill", dgvr.Cells["BarterBillNo"].Value.ToString())) { MessageBox.Show("已发生业务关系,无法删除", "软件提示"); return; } //string strBarterBaseCDRecordSql = "Delete From BarterBaseCDRecord Where BarterBillNo = '" + dgvr.Cells["BarterBillNo"].Value.ToString() + "'"; //strSqls.Add(strBarterBaseCDRecordSql); string strBarterBaseBillSql = "Delete From BarterBaseBill Where BarterBillNo = '" + dgvr.Cells["BarterBillNo"].Value.ToString() + "'"; strSqls.Add(strBarterBaseBillSql); if (rbbb.Delete(strSqls)) { dgvBarterBaseBill.Rows.Remove(dgvr); MessageBox.Show("删除成功!", "软件提示"); } else { MessageBox.Show("删除失败!", "软件提示"); } } }