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