private void btnAdd_Click(object sender, EventArgs e)
{
if (txtName.Text == "" || txtExplain.Text == "")
{
MessageBox.Show("请输入内容");
}
else
{
Dbcontrol dbHelper = new Dbcontrol();
if (rdoSingle.Checked)
{
string strEx = "insert into [sheet1$] (名称,解释) VALUES('" + txtName.Text.Trim() + "','" + txtExplain.Text.Trim() + "')";
MessageBox.Show(dbHelper.ReExNum(strEx) > 0 ? "添加成功！" : "添加失败！");
}
else
{
string[] charSplit = { "\n" };
char entrySeparator = txtName.Text[0];
string[] entries = txtExplain.Text.Trim().Replace("\r", "").Split(charSplit, StringSplitOptions.None);
int succeedCount = 0;
foreach (var item in entries)
{
string[] data = item.Split(entrySeparator);
if (data.Length < 2)
{
continue;
}
succeedCount += dbHelper.ReExNum(string.Format("insert into [sheet1$] (名称,解释) VALUES('{0}','{1}');", data[0], data[1]));
}
MessageBox.Show("成功添加了【" + succeedCount + "】条记录。", "成功提示");
}
ClearForm();
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
string name = lsbSearchName.Text.Trim();
if (string.IsNullOrEmpty(name))
{
MessageBox.Show("选择的字符值为空白");
return;
}
//UPDATE sheet1$ SET NAME = NULL, DeptName= NULL WHERE DeptId = 1;
string excelSqlStr = "UPDATE [sheet1$] set 名称='',解释='' where 名称 ='" + name + "'";
if (_dbc01.ReExNum(excelSqlStr) > 0)
{
LoadDefault();
}
else
{
MessageBox.Show("删除失败");
UpdateStatusMessage("删除失败");
}
}
