//导入 private void button2_Click(object sender, EventArgs e) { string filePath = GetFilePath(); if (string.IsNullOrEmpty(filePath)) { return; } try { DataTable dt = GetDataFromExcelByConn(filePath); if (dt == null || dt.Rows.Count == 0) { return; } foreach (DataRow row in dt.Rows) { row.SetAdded(); } PrintDal.SavePrint(dt, "select WH_No from Wh"); button1_Click_1(null, null); } catch (Exception ex) { MessageBox.Show("保存失败===>" + ex.Message); } }
//保存 private void button3_Click(object sender, EventArgs e) { try { this.dataGridView1.EndEdit(); DataTable dt = (DataTable)this.dataGridView1.DataSource; PrintDal.SavePrint(dt); } catch (Exception ex) { MessageBox.Show("保存失败===>" + ex.Message); } }