protected void imgbtnsure_Click(object sender, ImageClickEventArgs e) { int id = int.Parse(Request.Params["id"]); EtNet_Models.PictureInfo model = EtNet_BLL.PictureInfoManager.GetModel(id); if (model != null) { model.folderid = int.Parse(this.ddlfolder.SelectedValue); model.cname = this.iptcname.Value; if (this.radshare.SelectedValue == "0") { model.sharecode = 0; model.sharestxt = "私有"; model.viewidlist = ""; model.viewtxtlist = ""; } else { model.sharecode = 1; model.sharestxt = "共享"; model.viewidlist = this.hidplist.Value; model.viewtxtlist = this.iptplist.Value; } EtNet_BLL.PictureInfoManager.Update(model); Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "modify", "<script>alert('修改成功'); window.location = 'PictureShow.aspx';</script>"); } else { Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "modify", "<script>alert('修改失败,图片已删除');window.location = 'PictureShow.aspx'</script>"); } }
/// <summary> /// 增加一条数据 /// </summary> public static bool Add(EtNet_Models.PictureInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into PictureInfo("); strSql.Append("cname,imgpath,size,format,createtime,modifytime,visiblecode,visibletxt,folderid,creater,sharecode,sharestxt,viewidlist,viewtxtlist,editidlist,edittxtlist,delidlist,deltxtlist)"); strSql.Append(" values ("); strSql.Append("@cname,@imgpath,@size,@format,@createtime,@modifytime,@visiblecode,@visibletxt,@folderid,@creater,@sharecode,@sharestxt,@viewidlist,@viewtxtlist,@editidlist,@edittxtlist,@delidlist,@deltxtlist)"); SqlParameter[] parameters = { new SqlParameter("@cname", SqlDbType.VarChar, 40), new SqlParameter("@imgpath", SqlDbType.VarChar, 200), new SqlParameter("@size", SqlDbType.Int, 4), new SqlParameter("@format", SqlDbType.VarChar, 10), new SqlParameter("@createtime", SqlDbType.DateTime), new SqlParameter("@modifytime", SqlDbType.DateTime), new SqlParameter("@visiblecode", SqlDbType.Int, 4), new SqlParameter("@visibletxt", SqlDbType.VarChar, 10), new SqlParameter("@folderid", SqlDbType.Int, 4), new SqlParameter("@creater", SqlDbType.Int, 4), new SqlParameter("@sharecode", SqlDbType.Int, 4), new SqlParameter("@sharestxt", SqlDbType.VarChar, 10), new SqlParameter("@viewidlist", SqlDbType.VarChar, 100), new SqlParameter("@viewtxtlist", SqlDbType.VarChar, 400), new SqlParameter("@editidlist", SqlDbType.VarChar, 100), new SqlParameter("@edittxtlist", SqlDbType.VarChar, 400), new SqlParameter("@delidlist", SqlDbType.VarChar, 100), new SqlParameter("@deltxtlist", SqlDbType.VarChar, 400) }; parameters[0].Value = model.cname; parameters[1].Value = model.imgpath; parameters[2].Value = model.size; parameters[3].Value = model.format; parameters[4].Value = model.createtime; parameters[5].Value = model.modifytime; parameters[6].Value = model.visiblecode; parameters[7].Value = model.visibletxt; parameters[8].Value = model.folderid; parameters[9].Value = model.creater; parameters[10].Value = model.sharecode; parameters[11].Value = model.sharestxt; parameters[12].Value = model.viewidlist; parameters[13].Value = model.viewtxtlist; parameters[14].Value = model.editidlist; parameters[15].Value = model.edittxtlist; parameters[16].Value = model.delidlist; parameters[17].Value = model.deltxtlist; int result = EtNet_DAL.DBHelper.ExecuteCommand(strSql.ToString(), parameters); if (result >= 1) { return(true); } else { return(false); } }
/// <summary> /// 加载需修改的图片 /// </summary> private void LoadPictureData() { if (Request.Params["id"] != "") { int id = int.Parse(Request.Params["id"]); EtNet_Models.PictureInfo model = EtNet_BLL.PictureInfoManager.GetModel(id); if (model != null) { this.iptcname.Value = model.cname; this.ddlfolder.SelectedValue = model.folderid.ToString(); if (model.sharecode == 1) { this.radshare.Items[0].Selected = true; this.iptplist.Value = model.viewtxtlist; this.hidplist.Value = model.viewidlist; } else { this.radshare.Items[1].Selected = true; } } else { this.imgbtnsure.Enabled = false; } } }
/// <summary> /// 删除图片文件 /// </summary> private void DelFile(int id) { EtNet_Models.PictureInfo model = EtNet_BLL.PictureInfoManager.GetModel(id); if (model != null && model.imgpath != "") { File.Delete(Server.MapPath(model.imgpath)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public static EtNet_Models.PictureInfo GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 id,cname,imgpath,size,format,createtime,modifytime,visiblecode,visibletxt,folderid,creater,sharecode,sharestxt,viewidlist,viewtxtlist,editidlist,edittxtlist,delidlist,deltxtlist from PictureInfo "); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = id; EtNet_Models.PictureInfo model = new EtNet_Models.PictureInfo(); DataTable tbl = EtNet_DAL.DBHelper.GetDataSet(strSql.ToString(), parameters); if (tbl.Rows.Count > 0) { model.id = int.Parse(tbl.Rows[0]["id"].ToString()); model.cname = tbl.Rows[0]["cname"].ToString(); model.imgpath = tbl.Rows[0]["imgpath"].ToString(); model.size = int.Parse(tbl.Rows[0]["size"].ToString()); model.format = tbl.Rows[0]["format"].ToString(); model.createtime = DateTime.Parse(tbl.Rows[0]["createtime"].ToString()); model.modifytime = DateTime.Parse(tbl.Rows[0]["modifytime"].ToString()); model.visiblecode = int.Parse(tbl.Rows[0]["visiblecode"].ToString()); model.visibletxt = tbl.Rows[0]["visibletxt"].ToString(); model.folderid = int.Parse(tbl.Rows[0]["folderid"].ToString()); model.creater = int.Parse(tbl.Rows[0]["creater"].ToString()); model.sharecode = int.Parse(tbl.Rows[0]["sharecode"].ToString()); model.sharestxt = tbl.Rows[0]["sharestxt"].ToString(); model.viewidlist = tbl.Rows[0]["viewidlist"].ToString(); model.viewtxtlist = tbl.Rows[0]["viewtxtlist"].ToString(); model.editidlist = tbl.Rows[0]["editidlist"].ToString(); model.edittxtlist = tbl.Rows[0]["edittxtlist"].ToString(); model.delidlist = tbl.Rows[0]["delidlist"].ToString(); model.deltxtlist = tbl.Rows[0]["deltxtlist"].ToString(); return(model); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public static bool Update(EtNet_Models.PictureInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update PictureInfo set "); strSql.Append("cname=@cname,"); strSql.Append("imgpath=@imgpath,"); strSql.Append("size=@size,"); strSql.Append("format=@format,"); strSql.Append("createtime=@createtime,"); strSql.Append("modifytime=@modifytime,"); strSql.Append("visiblecode=@visiblecode,"); strSql.Append("visibletxt=@visibletxt,"); strSql.Append("folderid=@folderid,"); strSql.Append("creater=@creater,"); strSql.Append("sharecode=@sharecode,"); strSql.Append("sharestxt=@sharestxt,"); strSql.Append("viewidlist=@viewidlist,"); strSql.Append("viewtxtlist=@viewtxtlist,"); strSql.Append("editidlist=@editidlist,"); strSql.Append("edittxtlist=@edittxtlist,"); strSql.Append("delidlist=@delidlist,"); strSql.Append("deltxtlist=@deltxtlist"); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@cname", SqlDbType.VarChar, 40), new SqlParameter("@imgpath", SqlDbType.VarChar, 200), new SqlParameter("@size", SqlDbType.Int, 4), new SqlParameter("@format", SqlDbType.VarChar, 10), new SqlParameter("@createtime", SqlDbType.DateTime), new SqlParameter("@modifytime", SqlDbType.DateTime), new SqlParameter("@visiblecode", SqlDbType.Int, 4), new SqlParameter("@visibletxt", SqlDbType.VarChar, 10), new SqlParameter("@folderid", SqlDbType.Int, 4), new SqlParameter("@creater", SqlDbType.Int, 4), new SqlParameter("@sharecode", SqlDbType.Int, 4), new SqlParameter("@sharestxt", SqlDbType.VarChar, 10), new SqlParameter("@viewidlist", SqlDbType.VarChar, 100), new SqlParameter("@viewtxtlist", SqlDbType.VarChar, 400), new SqlParameter("@editidlist", SqlDbType.VarChar, 100), new SqlParameter("@edittxtlist", SqlDbType.VarChar, 400), new SqlParameter("@delidlist", SqlDbType.VarChar, 100), new SqlParameter("@deltxtlist", SqlDbType.VarChar, 400), new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = model.cname; parameters[1].Value = model.imgpath; parameters[2].Value = model.size; parameters[3].Value = model.format; parameters[4].Value = model.createtime; parameters[5].Value = model.modifytime; parameters[6].Value = model.visiblecode; parameters[7].Value = model.visibletxt; parameters[8].Value = model.folderid; parameters[9].Value = model.creater; parameters[10].Value = model.sharecode; parameters[11].Value = model.sharestxt; parameters[12].Value = model.viewidlist; parameters[13].Value = model.viewtxtlist; parameters[14].Value = model.editidlist; parameters[15].Value = model.edittxtlist; parameters[16].Value = model.delidlist; parameters[17].Value = model.deltxtlist; parameters[18].Value = model.id; int result = EtNet_DAL.DBHelper.ExecuteCommand(strSql.ToString(), parameters); if (result >= 1) { return(true); } else { return(false); } }
//保存上传的图片,提示是否上传成功 private void Save() { string saveurl = "../../UploadFile/Picture/"; string filename = ""; string newfile = ""; string format = ""; string result = ""; HttpPostedFile file = null; EtNet_Models.PictureInfo model = null; for (int i = 0; i < Request.Files.Count; i++) { file = Request.Files[i]; filename = file.FileName.Substring(file.FileName.LastIndexOf("\\") + 1); if (file.FileName != "") { if (file.ContentLength <= (1024 * 1024)) { format = file.FileName.Substring(file.FileName.LastIndexOf(".") + 1); newfile = DateTime.Now.ToString("yyyyMMddHHmmss_ffff", DateTimeFormatInfo.InvariantInfo) + filename; file.SaveAs(HttpContext.Current.Server.MapPath(saveurl + newfile)); model = new EtNet_Models.PictureInfo(); model.cname = filename; model.creater = ((EtNet_Models.LoginInfo)Session["login"]).Id; model.createtime = DateTime.Now; model.delidlist = ""; model.deltxtlist = ""; model.editidlist = ""; model.edittxtlist = ""; model.folderid = int.Parse(this.ddlfolder.SelectedValue); model.format = format; model.imgpath = saveurl + newfile; model.modifytime = DateTime.Now; model.sharecode = 0; model.sharestxt = "私有"; model.size = file.ContentLength; model.viewidlist = ""; model.viewtxtlist = ""; model.visiblecode = 1; model.visibletxt = "可见"; EtNet_BLL.PictureInfoManager.Add(model); } else { if (result == "") { result = filename; } else { result += "," + filename; } } } } if (result == "") { Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "add", "<script>alert('图片上传成功'); window.location = 'PictureShow.aspx'</script>", false); } else { result = "<script>alert('括号中的图片超出1M上传失败[" + result + "]')</script>"; Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "add", result, false); } }
/// <summary> /// 更新一条数据 /// </summary> public static bool Update(EtNet_Models.PictureInfo model) { return(EtNet_DAL.PictureInfoService.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public static bool Add(EtNet_Models.PictureInfo model) { return(EtNet_DAL.PictureInfoService.Add(model)); }