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("删除失败！", "软件提示");
}
}
}
