protected void btnAdd_Click(object sender, EventArgs e)
{
try
{
if (txtAttName.Text.Trim() == "")
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('请填写文件名称！');</script>");
return;
}
//HttpFileCollection files = HttpContext.Current.Request.Files;
//if (files.Count <= 0)
//{
// base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('请选择一个文件！');</script>");
// return;
//}
TB_EXCEL excel = new TB_EXCEL();
excel.CreateTime = DateTime.Now;
excel.Name = txtAttName.Text;
excel.IsParent = 1;
excel.Remark = txtRemark.Text;
excel.UserName = Session["LoginName"].ToString();
excel.UpState = 1;
excel.FileName = Request["FileName"];
excel.FileType = Request["lastFileName"];
MyExcelService excelMan = new MyExcelService();
int id = excelMan.Add(excel);
if (id > 0)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('添加成功！');</script>");
base.Response.Redirect("~/MyExcels/MainExcelList.aspx");
}
else
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('添加失败！');</script>");
}
}
catch (Exception EX)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, string.Format("<script>alert('{0}');</script>", EX.Message.ToString()));
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!base.IsPostBack)
{
List <MyExcel> invoiceList = new List <MyExcel>();
this.gvList.DataSource = invoiceList;
this.gvList.DataBind();
MyExcelService dal = new MyExcelService();
var dalList = dal.GetMainExcel(" UpState=3 ");
ddlExcel.DataSource = dalList;
ddlExcel.DataBind();
ddlExcel.DataTextField = "Name";
ddlExcel.DataValueField = "Table_Name";
}
}
