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; } }