/// <summary>
/// 删除
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btn_del_Click(object sender, EventArgs e)
{
string strWhere = string.Empty;
int iSelectedRow = 0;
bool b_DelOK = false;//是否删除过
DialogResult result = MsgBox.Question("确认删除？");
if (result == DialogResult.Cancel)
{
return;
}
int Count = 0;
foreach (DataGridViewRow row in dgv_User.Rows)
{
if (row.Cells[CHK.Name].EditedFormattedValue.ToString() == "True")
{
if (strWhere == string.Empty)
{
strWhere += string.Format("WHERE {0} in ('{1}'", UserID.Name, row.Cells[UserID.Name].Value.ToString());
}
else
{
strWhere += string.Format(",'{0}'", row.Cells[UserID.Name].Value.ToString());
}
Count++;
iSelectedRow++;
if (Count == 20)
{
strWhere += ")";
BLL_SysDatUser.Delete(strWhere);
BLL_SysDatUserMenuMap.Delete(strWhere);
strWhere = string.Empty;
Count = 0;
b_DelOK = true;
}
}
}
if (strWhere != string.Empty)
{
strWhere += ")";
BLL_SysDatUser.Delete(strWhere);
BLL_SysDatUserMenuMap.Delete(strWhere);
b_DelOK = true;
}
if (iSelectedRow == 0)
{
MsgBox.Error("请先选中行！");
return;
}
if (b_DelOK)
{
Query();
new PubUtils().ShowNoteOKMsg("删除成功！");
string MaterialCode = string.Empty;
}
}
