//导入 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); } }
//查询 private void button1_Click_1(object sender, EventArgs e) { string cond = ""; if (!string.IsNullOrEmpty(txtNo.Text.Trim())) { cond += " and WH_No like '%" + txtNo.Text.Trim() + "%'"; } if (!string.IsNullOrEmpty(txtName.Text.Trim())) { cond += " and WH_Name like '%" + txtName.Text.Trim() + "%'"; } if (!string.IsNullOrEmpty(txtMan.Text.Trim())) { cond += " and WH_Man like '%" + txtMan.Text.Trim() + "%'"; } WH.WhDataTable table = PrintDal.GetPrint(cond); this.dataGridView1.DataSource = table; }