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())); } }
/// <summary> /// 对象实体绑定数据 /// </summary> public TB_EXCEL ReaderBind(IDataReader dataReader) { TB_EXCEL model = new TB_EXCEL(); object ojb; ojb = dataReader["Id"]; if (ojb != null && ojb != DBNull.Value) { model.Id = (int)ojb; } model.Name = dataReader["Name"].ToString(); model.Table_Name = dataReader["Table_Name"].ToString(); ojb = dataReader["CreateTime"]; if (ojb != null && ojb != DBNull.Value) { model.CreateTime = (DateTime)ojb; model.Name += "-[" + model.CreateTime.ToShortDateString() + "]"; } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(TB_EXCEL model) { StringBuilder strSql = new StringBuilder(); StringBuilder strSql1 = new StringBuilder(); StringBuilder strSql2 = new StringBuilder(); if (model.Name != null) { strSql1.Append("Name,"); strSql2.Append("'" + model.Name + "',"); } if (model.Table_Name != null) { strSql1.Append("Table_Name,"); strSql2.Append("'" + model.Table_Name + "',"); } if (model.SheetName != null) { strSql1.Append("SheetName,"); strSql2.Append("'" + model.SheetName + "',"); } if (model.UserName != null) { strSql1.Append("UserName,"); strSql2.Append("'" + model.UserName + "',"); } strSql1.Append("CreateTime,"); strSql2.Append("getdate(),"); if (model.UpState != null) { strSql1.Append("UpState,"); strSql2.Append("1,"); } if (model.Remark != null) { strSql1.Append("Remark,"); strSql2.Append("'" + model.Remark + "',"); } if (model.FileName != null) { strSql1.Append("FileName,"); strSql2.Append("'" + model.FileName + "',"); } if (model.FileType != null) { strSql1.Append("FileType,"); strSql2.Append("'" + model.FileType + "',"); } strSql1.Append("IsParent,"); strSql2.Append("" + model.IsParent + ","); strSql.Append("insert into [ExcelData].[dbo].TB_EXCEL("); strSql.Append(strSql1.ToString().Remove(strSql1.Length - 1)); strSql.Append(")"); strSql.Append(" values ("); strSql.Append(strSql2.ToString().Remove(strSql2.Length - 1)); strSql.Append(")"); strSql.Append(";select @@IDENTITY"); object obj = DBHelp.ExeScalar(strSql.ToString()); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
public TB_EXCEL TopQueryMainExcel(string strWhere) { TB_EXCEL model = new TB_EXCEL(); StringBuilder strSql = new StringBuilder(); strSql.Append("select Top 1 Name,Id,CreateTime,Table_Name,SheetName,UpState,Remark,FileName,UserName,FileType"); strSql.Append(" FROM [ExcelData].[dbo].[TB_EXCEL] "); if (strWhere.Trim() != "") { strSql.Append(" where " + strWhere); } strSql.Append(" order by Id desc "); using (SqlConnection conn = DBHelp.getConn()) { conn.Open(); SqlCommand objCommand = new SqlCommand(strSql.ToString(), conn); using (SqlDataReader objReader = objCommand.ExecuteReader()) { if (objReader.Read()) { object ojb; ojb = objReader["Id"]; if (ojb != null && ojb != DBNull.Value) { model.Id = (int)ojb; } model.Name = objReader["Name"].ToString(); model.Table_Name = objReader["Table_Name"].ToString(); model.UserName = objReader["UserName"].ToString(); model.UpState = (int)objReader["UpState"]; ojb = objReader["SheetName"]; if (ojb != null && ojb != DBNull.Value) { model.SheetName = (string)ojb; } ojb = objReader["FileName"]; if (ojb != null && ojb != DBNull.Value) { model.FileName = (string)ojb; } ojb = objReader["FileType"]; if (ojb != null && ojb != DBNull.Value) { model.FileType = (string)ojb; } ojb = objReader["Remark"]; if (ojb != null && ojb != DBNull.Value) { model.Remark = (string)ojb; } ojb = objReader["CreateTime"]; if (ojb != null && ojb != DBNull.Value) { model.CreateTime = (DateTime)ojb; } } } } return(model); }