//导入
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;
}
