private void button2_Click(object sender, EventArgs e)
{
if (textBox1.Text == "")
{
MessageBox.Show("请选择文件！");
}
else
{
DataSet dataset = new DataSet();
dataset = _excel.getDataSetFromExcel(textBox1.Text, _excel.GetFirstSheetName(textBox1.Text));
_dba.ExecuteCommand("delete remedy7");
_dba.InsertDataToDB(dataset, "remedy7");
MessageBox.Show("Successed!");
}
}
private void button15_Click(object sender, EventArgs e)
{
string weekday = dateTimePicker1.Value.DayOfWeek.ToString();
if (weekday == "Monday")
{
ExcelBus excelbiz = new ExcelBus();
string sheetName = excelbiz.GetFirstSheetName(textBox3.Text);
DataSet dsRemedy7 = excelbiz.getDataSetFromExcel(textBox3.Text, sheetName);
_dba.ExecuteCommand("truncate table " + "CorpRemedy");
_dba.InsertDataToDB(dsRemedy7, "CorpRemedy");
MessageBox.Show("Insert CorpRemdy Successed!");
}
else
{
MessageBox.Show("请选择正确日期！");
}
}
private void button15_Click(object sender, EventArgs e)
{
string weekday = dateTimePicker1.Value.DayOfWeek.ToString();
if (weekday == "Monday")
{
ExcelBus excelbiz = new ExcelBus();
string sheetName = excelbiz.GetFirstSheetName(textBox3.Text);
DataSet dsRemedy7 = excelbiz.getDataSetFromExcel(textBox3.Text, sheetName);
_dba.ExecuteCommand("truncate table " + "CorpRemedy");
_dba.InsertDataToDB(dsRemedy7, "CorpRemedy");
MessageBox.Show("Insert CorpRemdy Successed!");
}
else
{
MessageBox.Show("请选择正确日期！");
}
}
