protected void Add_OK_Click(object sender, EventArgs e)
{
if (FileUpload1.HasFile)
{
string path = "~/UploadFiles/ExcelData/";
string filename = DateTime.Now.ToString("yyyyMMddhhmmss") + FileUpload1.FileName;
path += filename;
if (Path.GetExtension(filename) == ".xls")
{
try
{
FileUpload1.PostedFile.SaveAs(Server.MapPath(path));
string excelResult = ExcelManager.CheckExcelData(Server.MapPath(path));
if (excelResult == "NullData")
{
string myscript = @"alert('数据导入失败！');window.location.href='EQState.aspx';";
Page.ClientScript.RegisterStartupScript(this.GetType(), "myscript", myscript, true);
}
else
{
string splitflag = ".";
string[] resultinfo = excelResult.Split(splitflag.ToCharArray(), System.StringSplitOptions.RemoveEmptyEntries);
string insertsql = "Insert Into [EQ State] ([shortdate],[filepath]) values ('" + resultinfo[1] + "','" + path + "')";
if (resultinfo[0] == "ExistData")
{
insertsql = "Update [EQ State] Set [filepath]='" + path + "' where [shortdate]='" + resultinfo[1] + "'";
}
try
{
DbManager.ExecuteNonQuery(insertsql);
string myscript = @"alert('数据导入成功！');window.location.href='EQState.aspx';";
Page.ClientScript.RegisterStartupScript(this.GetType(), "myscript", myscript, true);
}
catch
{
string myscript = @"alert('数据库操作失败！');window.location.href='EQState.aspx';";
Page.ClientScript.RegisterStartupScript(this.GetType(), "myscript", myscript, true);
}
}
}
catch
{
string myscript = @"alert('文件上传失败！');window.location.href='EQState.aspx';";
Page.ClientScript.RegisterStartupScript(this.GetType(), "myscript", myscript, true);
}
}
else
{
ToolTips.Text = "文档格式必须为'.xls'！";
Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script> ShowDialog('Add_Dialog');</script>");
}
}
else
{
ToolTips.Text = "请选择数据文件！";
Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script> ShowDialog('Add_Dialog');</script>");
}
}