/// <summary> /// 得到一个对象实体 /// </summary> public entity_ImageList DataRowToModel(DataRow row) { entity_ImageList model = new entity_ImageList(); if (row != null) { if (row["sid"] != null) { model.sid = row["sid"].ToString(); } if (row["name"] != null) { model.name = row["name"].ToString(); } if (row["url"] != null) { model.url = row["url"].ToString(); } if (row["bookName"] != null) { model.bookName = row["bookName"].ToString(); } if (row["type"] != null) { model.Type = row["type"].ToString(); } if (row["pid"] != null) { model.Pid = row["pid"].ToString(); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(entity_ImageList model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into ImageList("); strSql.Append("sid,name,url,bookName,type,pid)"); strSql.Append(" values ("); strSql.Append("@sid,@name,@url,@bookName,@type,@pid)"); SqlParameter[] parameters = { new SqlParameter("@sid", SqlDbType.NVarChar, 50), new SqlParameter("@name", SqlDbType.NVarChar, 50), new SqlParameter("@url", SqlDbType.NVarChar, 500), new SqlParameter("@bookName", SqlDbType.NVarChar, 50), new SqlParameter("@type", SqlDbType.NVarChar, 50), new SqlParameter("@pid", SqlDbType.NVarChar, 50) }; parameters[0].Value = model.sid; parameters[1].Value = model.name; parameters[2].Value = model.url; parameters[3].Value = model.bookName; parameters[4].Value = model.Type; parameters[5].Value = model.Pid; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
protected void upload_Click(object sender, EventArgs e) { if (this.FileUpload.FileName.Equals("")) { this.Page.ClientScript.RegisterStartupScript(this.Page.GetType(), "", "alert('请选择图片');", true); return; } if (!Common.fileUpHelper.CheckFileType(this.FileUpload.FileName)) { this.Page.ClientScript.RegisterStartupScript(this.Page.GetType(), "", "alert('上传文件不是图片');", true); return; } entity_ImageList imgs = new entity_ImageList(); string ImagePath = "../UpLoad/"; if (!Directory.Exists(Server.MapPath(ImagePath))) { Directory.CreateDirectory(Server.MapPath(ImagePath)); } imgs.sid = Guid.NewGuid().ToString(); imgs.name = DateTime.Now.ToString("yyyyMMddhhmmssfff") + Path.GetExtension(this.FileUpload.FileName); imgs.url = ImagePath + imgs.name; //ImagePath = imgs.url; imgs.bookName = ""; imgs.Pid = ViewState["sid"].ToString(); imgs.Type = ""; this.FileUpload.SaveAs(Server.MapPath(imgs.url)); img.Add(imgs); //todo:把图片显示在页面上 this.Image.ImageUrl = ImagePath + imgs.name; this.Panel.Visible = true; }
private void getImage() { bool isImage = false; isImage = img.ImgExists(sid); if (isImage) { this.Panel.Visible = true; entity_ImageList imgs = img.imgGetModel(sid); this.Image.ImageUrl = imgs.url; } else { this.Panel.Visible = false; } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(entity_ImageList model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update ImageList set "); strSql.Append("name=@name,"); strSql.Append("url=@url,"); strSql.Append("bookName=@bookName,"); strSql.Append("type=@type,"); strSql.Append("pid=@pid"); strSql.Append(" where sid=@sid "); SqlParameter[] parameters = { new SqlParameter("@name", SqlDbType.NVarChar, 50), new SqlParameter("@url", SqlDbType.NVarChar, 500), new SqlParameter("@bookName", SqlDbType.NVarChar, 50), new SqlParameter("@sid", SqlDbType.NVarChar, 50), new SqlParameter("@type", SqlDbType.NVarChar, 50), new SqlParameter("@pid", SqlDbType.NVarChar, 50) }; parameters[0].Value = model.name; parameters[1].Value = model.url; parameters[2].Value = model.bookName; parameters[3].Value = model.sid; parameters[4].Value = model.Type; parameters[5].Value = model.Pid; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public entity_ImageList imgGetModel(string sid) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 sid,name,url,bookName,type,pid from ImageList "); strSql.Append(" where pid=@sid "); SqlParameter[] parameters = { new SqlParameter("@sid", SqlDbType.NVarChar, 50) }; parameters[0].Value = sid; entity_ImageList model = new entity_ImageList(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(entity_ImageList model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(entity_ImageList model) { return(dal.Add(model)); }