private void toolDelete_Click(object sender, EventArgs e)
{
if (dgvBarterConsignBill.RowCount == 0)
{
return;
}
if (GlobalProperty.OperatorCode != dgvBarterConsignBill.CurrentRow.Cells["OperatorCode"].Value.ToString())
{
MessageBox.Show("非本记录的录入人员，不许允许删除！", "软件提示");
return;
}
if (MessageBox.Show("确定要删除吗？", "软件提示", MessageBoxButtons.YesNo, MessageBoxIcon.Exclamation) == DialogResult.Yes)
{
RetailBarterConsignBill rbcb = new RetailBarterConsignBill();
DataGridViewRow dgvr = dgvBarterConsignBill.CurrentRow;
int intId = Convert.ToInt32(dgvr.Cells["Id"].Value);
if (new Useful().IsExistConstraint("BarterConsignBill", intId.ToString()))
{
MessageBox.Show("已发生业务关系，无法删除", "软件提示");
return;
}
String strSql = "Delete From BarterConsignBill Where BarterConsignBill.Id = " + intId;
if (rbcb.Delete(strSql))
{
dgvBarterConsignBill.Rows.Remove(dgvr);
MessageBox.Show("删除成功！", "软件提示");
}
else
{
MessageBox.Show("删除失败！", "软件提示");
}
}
}
private void btnQuery_Click(object sender, EventArgs e)
{
string strSql = String.Empty; //声明string变量并初始化
RetailBarterConsignBill rbcb = new RetailBarterConsignBill();
if (!chbIsCDNo.Checked) //没有选中光盘号查询
{
strSql = rbcb.BarterConsignBillSql + GetQueryInfoString(); //设置基本的Sql语句
}
if (chbIsCDNo.Checked) //选中光盘号查询
{
if (String.IsNullOrEmpty(txtCDNo.Text.Trim()))
{
MessageBox.Show("请输入光盘号！", "软件提示");
txtCDNo.Focus();
return;
}
strSql = rbcb.BarterConsignBill_CDNo_Sql + " and BarterConsignCDRecord.CDNo = '" + txtCDNo.Text.Trim() + "'";
}
formRetailBarterConsignBill.dgvBarterConsignBill.DataSource = rbcb.GetDataTable(strSql);
this.Close();
}
