private void btnDel_Click(object sender, EventArgs e)
{
List <int> listids = new List <int>();
string ids = ",";
foreach (DataGridViewRow x in dataGridView1.Rows)
{
DataGridViewCheckBoxCell cell = (DataGridViewCheckBoxCell)x.Cells[0];
Boolean flag = Convert.ToBoolean(cell.Value);
if (flag)
{
ids += x.Cells["id"].Value.ToString() + ",";
listids.Add(Convert.ToInt32(x.Cells["id"].Value.ToString()));
}
}
if (listids.Count <= 0)
{
MessageBox.Show(string.Format("请选择要删除的数据"), "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
if (MessageBox.Show(string.Format("您将要删除复选框选中的 【{0}】 条专题库", listids.Count), "确认删除", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning) == System.Windows.Forms.DialogResult.OK)
{
ids = ids.Trim(',');
if (ZTHelper.DelZTDB(ids))
{
bind();
}
}
}
public void bind()
{
DataTable dt = ZTHelper.GetZTList();
this.dataGridView1.DataSource = dt;
this.dataGridView1.ClearSelection();
}
private void 除ToolStripMenuItem_Click(object sender, EventArgs e)
{
if (dataGridView1.SelectedRows.Count == 0)
{
MessageBox.Show(string.Format("请选择要删除的数据"), "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
DataGridViewRow datarow = dataGridView1.SelectedRows[0];
string name = (datarow.Cells["name"].Value == null ? "" : datarow.Cells["name"].Value.ToString());
string des = (datarow.Cells["des"].Value == null ? "" : datarow.Cells["des"].Value.ToString());
string type = (datarow.Cells["type"].Value == null ? "CPRS" : datarow.Cells["type"].Value.ToString());
if (MessageBox.Show("您确定要删除专题库 【" + name + "】 吗?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == System.Windows.Forms.DialogResult.Yes)
{
try
{
if (ZTHelper.DelZTDB(datarow.Cells["Id"].Value.ToString(), name))
{
bind();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "错误");
}
}
}
private void 除ToolStripMenuItem_Click(object sender, EventArgs e)
{
DataGridViewRow datarow = dataGridView1.SelectedRows[0];
string name = (datarow.Cells["name"].Value == null ? "" : datarow.Cells["name"].Value.ToString());
string des = (datarow.Cells["des"].Value == null ? "" : datarow.Cells["des"].Value.ToString());
string type = (datarow.Cells["type"].Value == null ? "CPRS" : datarow.Cells["type"].Value.ToString());
if (MessageBox.Show("您确定要删除专题库 【" + name + "】 吗?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == System.Windows.Forms.DialogResult.Yes)
{
if (ZTHelper.DelZTDB(datarow.Cells["id"].Value.ToString()))
{
bind();
}
}
}
private void txtName_Leave(object sender, EventArgs e)
{
if (this.txtName.Text.Trim() == "")
{
this.errorProvider1.SetError(this.txtName, "专题库名称不能为空");
return;
}
if ((this.Text == "修改专题库" && this.ztname != this.txtName.Text.Trim()) || this.Text == "新建专题库")
{
if (ZTHelper.ExistZTDB(this.txtName.Text.Trim()))
{
this.errorProvider1.SetError(this.txtName, "专题库名称已经存在");
MessageBox.Show("专题库名称已经存在！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
this.errorProvider1.Clear();
}
}
}
private void btnSubMit_Click(object sender, EventArgs e)
{
bool haserror = false;
if (this.txtName.Text.Trim() == "")
{
haserror = true;
this.errorProvider1.SetError(this.txtName, "专题库名称不能为空");
}
if (this.txtDesc.Text.Trim() == "")
{
haserror = true;
this.errorProvider1.SetError(this.txtDesc, "专题库描述不能为空");
}
if (haserror)
{
return;
}
if ((this.Text == "修改专题库" && this.ztname != this.txtName.Text.Trim()) || this.Text == "新建专题库")
{
if (ZTHelper.ExistZTDB(this.txtName.Text.Trim()))
{
haserror = true;
this.errorProvider1.SetError(this.txtName, "专题库名称已经存在");
MessageBox.Show("专题库名称已经存在！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
if (haserror)
{
return;
}
this.errorProvider1.Clear();
bool res;
string type = "";
foreach (var x in this.Controls)
{
if (x.GetType() == typeof(RadioButton))
{
var rb = x as RadioButton;
if (rb.Checked == true)
{
type = rb.Text;
}
}
}
if (this.Text == "修改专题库")
{
res = ZTHelper.EditZTDB(id, this.txtName.Text.Trim(), this.txtDesc.Text.Trim(), type);
}
else
{
res = ZTHelper.AddZTDB(this.txtName.Text.Trim(), this.txtDesc.Text.Trim(), type);
}
if (res)
{
MessageBox.Show(sucess_message + "成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.txtDesc.Text = "";
this.txtName.Text = "";
this.DialogResult = System.Windows.Forms.DialogResult.OK;
}
else
{
MessageBox.Show(sucess_message + "失败！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
