private void button1_Click(object sender, EventArgs e)
{
//BLL.query_list bll = new BLL.query_list();
//Model.query_list model = new Model.query_list();
//model.query_title = "查询对象批次4";
//model.batch = "2018[04]号";
//model.client = "市林业局";
//model.entrust_date = DateTime.Today;
//model.add_user = "******";
//model.add_time = DateTime.Now;
//bll.Add(model
OpenFileDialog fileDialog = new OpenFileDialog();
if (fileDialog.ShowDialog() == DialogResult.OK)
{
DXD.DTD.query_detail query_detail = new DTD.query_detail();
}
}
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;
}
}
