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);
}
