C# winform应用
需求:导入Excel文件时需要执行其他操作,实现如果取消导入就不执行其他操作
C#代码实现
private bool DLimport0(string tablename, string datebasename, string buttonname)
{
string xxx = "";
string Tag = "";
string connString = "server=192.168.1.110;uid=sa;pwd=xyz@0123456...;database=" + datebasename;
System.Windows.Forms.OpenFileDialog fd = new OpenFileDialog();
fd.Multiselect = true;
if (fd.ShowDialog() == DialogResult.OK)
{
foreach (string file in fd.FileNames)
{
xxx += file + "\n";
}
DialogResult dr = MessageBox.Show("是否将以下文件导入到【" + buttonname + "】\n" + xxx, "导入文件确认", MessageBoxButtons.OKCancel, MessageBoxIcon.Question);
if (dr == DialogResult.OK)
{
richTextBox1.Text = null;
richTextBox2.Text = null;
DL(connString, tablename);
foreach (string file in fd.FileNames)
{
richTextBox2.AppendText(DateTime.Now.ToString("HH:mm:ss ") + System.IO.Path.GetFileName(file) + "数据读取中...\n");
Tag = TransferData(file, tablename, connString);
richTextBox2.AppendText("--------------------\n");
richTextBox1.ScrollToCaret();
richTextBox2.ScrollToCaret();
}
if (Tag == "TAG") { MessageBox.Show("导入完成!"); }
else MessageBox.Show("导入失败!");
return true;
}
}
return false;
}
private bool NODLimport0(string tablename, string datebasename, string buttonname)
{
bool fileImported = false;
string xxx = "";
string Tag = "";
string connString = "server=192.168.1.110;uid=sa;pwd=xyz@0123456...;database=" + datebasename;
System.Windows.Forms.OpenFileDialog fd = new OpenFileDialog();
fd.Multiselect = true;
DialogResult fdResult = fd.ShowDialog();
if (fdResult == DialogResult.OK)
{
foreach (string file in fd.FileNames)
{
xxx += file + "\n";
}
DialogResult dr = MessageBox.Show("是否将以下文件导入到【" + buttonname + "】\n" + xxx, "导入文件确认", MessageBoxButtons.OKCancel, MessageBoxIcon.Question);
if (dr == DialogResult.OK)
{
richTextBox1.Text = null;
richTextBox2.Text = null;
foreach (string file in fd.FileNames)
{
richTextBox2.AppendText(DateTime.Now.ToString("HH:mm:ss ") + System.IO.Path.GetFileName(file) + "数据读取中...\n");
Tag = TransferData(file, tablename, connString);
richTextBox2.AppendText("--------------------\n");
richTextBox1.ScrollToCaret();
richTextBox2.ScrollToCaret();
}
if (Tag == "TAG")
{
MessageBox.Show("导入完成!");
fileImported = true;
}
else
{
MessageBox.Show("导入失败!");
fileImported = false;
}
}
}
return fileImported;
}
public void noQuery(string sql)
{
string connString = "server=192.168.1.110;uid=sa;pwd=xyz@0123456...;database=RB";
SqlConnection conn = new SqlConnection(connString);
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.CommandTimeout = 1000;
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
}
private void button60_Click(object sender, EventArgs e)
{
DLimport0("cs", "RB", "派发清空导入" + button60.Text);
}
效果图
![在这里插入图片描述](https://i-blog.csdnimg.cn/blog_migrate/6c1019cdb04601f00aeede94ce6e5804.png)