private void button8_Click(object sender, EventArgs e)
{
//文件选择有错，直接取消并返回
Dictionary <string, string> files = new Dictionary <string, string>();
files.Add("Business", getFilename(tbBusiness));
if (this.DialogResult == DialogResult.Cancel)
{
MessageBox.Show("文件选择错误！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
string result = "";
foreach (KeyValuePair <string, string> kv in files)
{
DTD.DTDParameter parameter = new DTD.DTDParameter();
DTD.IXlsTDb dtd = null;
if (kv.Value == "")
{
continue;
}
if (kv.Key.IndexOf("House") >= 0)//House1,House2的类名是House
{
dtd = (DTD.IXlsTDb)Assembly.Load("DXD.DTD").CreateInstance("DXD.DTD." + kv.Key.Substring(0, 5));
}
else
{
dtd = (DTD.IXlsTDb)Assembly.Load("DXD.DTD").CreateInstance("DXD.DTD." + kv.Key);
}
parameter.filename = kv.Value;
parameter.list_id = list_id;
result = dtd.FileToDb(parameter);
if (result != "导入成功！")
{
MessageBox.Show(result, "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.DialogResult = DialogResult.Abort;
return;
}
}
if (result == "")
{
this.DialogResult = DialogResult.Abort;
MessageBox.Show("必须选择文件！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
this.DialogResult = DialogResult.OK;
MessageBox.Show("导入成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
private void button2_Click(object sender, EventArgs e)
{
//文件选择有错，直接取消并返回
if (tbFilename.Text == "")
{
this.DialogResult = DialogResult.Cancel;
return;
}
if (!File.Exists(tbFilename.Text))
{
this.DialogResult = DialogResult.Cancel;
return;
}
string extension = Path.GetExtension(tbFilename.Text).ToLower();
if (extension != ".xls" && extension != ".xlsx")
{
this.DialogResult = DialogResult.Cancel;
return;
}
DTD.query_detail dtd = new DTD.query_detail();
DTD.DTDParameter parameter = new DTD.DTDParameter();
parameter.filename = tbFilename.Text;
parameter.list_id = list_id;
string resultstr = dtd.FileToDb(parameter);
MessageBox.Show(resultstr, "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
if (resultstr == "导入成功！")
{
this.DialogResult = DialogResult.OK;
}
else
{
this.DialogResult = DialogResult.Cancel;
}
}
