protected void Page_Load(object sender, EventArgs e) { TUsers model = DbSession.Default.Get <TUsers>(TUsers._.UserName == UserLoginInfo.UserName); if (model == null) { Response.Redirect("/"); } string tmp = CommonManager.Web.Request("params", ""); if (!string.IsNullOrEmpty(tmp) && CommonManager.String.IsInteger(tmp)) { pic = DbSession.Default.Get <Web_UserAlbum>(Web_UserAlbum._.ID == tmp); } if (!IsPostBack) { ColumnList = DbSession.Default.From <Web_UserAlbumColumn>().Select(Web_UserAlbumColumn._.ID, Web_UserAlbumColumn._.AlbumName).Where(Web_UserAlbumColumn._.UserID == model.UserID).OrderBy(Web_UserAlbumColumn._.OrderID.Desc && Web_UserAlbumColumn._.InputTime.Desc).ToDataTable(); if (ColumnList.Rows.Count <= 0) { Response.Write("<script>alert('您还没有创建相册!');location.href='AlbumWrite.aspx';</script>"); return; } } }
protected void Page_Load(object sender, EventArgs e) { TUsers model = DbSession.Default.Get<TUsers>(TUsers._.UserName == UserLoginInfo.UserName); if (model == null) { Response.Redirect("/"); } string tmp = CommonManager.Web.Request("params", ""); if (!string.IsNullOrEmpty(tmp) && CommonManager.String.IsInteger(tmp)) { pic = DbSession.Default.Get<Web_UserAlbum>(Web_UserAlbum._.ID == tmp); } if (!IsPostBack) { ColumnList = DbSession.Default.From<Web_UserAlbumColumn>().Select(Web_UserAlbumColumn._.ID, Web_UserAlbumColumn._.AlbumName).Where(Web_UserAlbumColumn._.UserID == model.UserID).OrderBy(Web_UserAlbumColumn._.OrderID.Desc && Web_UserAlbumColumn._.InputTime.Desc).ToDataTable(); if (ColumnList.Rows.Count <= 0) { Response.Write("<script>alert('����û�д�����ᣡ');location.href='AlbumWrite.aspx';</script>"); return; } } }
/// <summary> /// 删除 /// </summary> /// <param name="rid"></param> private void Del(string rid) { //sqlConnection sqlconn = new sqlConnection(); //sqlconn.sql_Exec( "delete * from Web_UserAlbum where id=" + rid ); Web_UserAlbum model = DbSession.Default.Get <Web_UserAlbum>(Web_UserAlbum._.ID == rid); if (model == null) { Response.Redirect(Request.Url.AbsolutePath, true); } if (File.Exists(Server.MapPath(model.PicPath))) { File.Delete(Server.MapPath(model.PicPath)); } DbSession.Default.Delete <Web_UserAlbum>(Web_UserAlbum._.ID == rid); Response.Redirect(Request.Url.AbsolutePath, true); }
/// <summary> /// 删除一张照片 /// </summary> private void DelPic() { string aid = CommonManager.Web.Request("id", ""); string type = CommonManager.Web.Request("type", "0"); #region 校验 if (string.IsNullOrEmpty(aid) || !CommonManager.String.IsInteger(aid)) { Response.Write("请不要尝试非法操作。"); return; } if (!DbSession.Default.Exists <Web_UserAlbum>(Web_UserAlbum._.ID == aid)) { Response.Write("请不要尝试非法操作。"); return; } if (!UserLoginInfo.IsLogin) { Response.Write("您尚未登录。"); return; } TUsers model = DbSession.Default.Get <TUsers>(TUsers._.UserName == UserLoginInfo.UserName); if (model == null) { Response.Write("您尚未登录。"); return; } #endregion Web_UserAlbum album = DbSession.Default.Get <Web_UserAlbum>(Web_UserAlbum._.ID == aid); CommonManager.File.DeleteFile(album.PicPath); if (type == "1") { DbSession.Default.Delete <Web_UserAlbum>(album); } else if (type == "0") { DbSession.Default.Update <Web_UserAlbum>(Web_UserAlbum._.PicPath, "", Web_UserAlbum._.ID == aid); } Response.Write("success"); }
/// <summary> /// 设置某张照片为相册封面 /// </summary> private void SetToCover() { if (!UserLoginInfo.IsLogin) { Response.Write("请先登录。"); return; } TUsers user = DbSession.Default.Get <TUsers>(TUsers._.UserID == UserLoginInfo.UserID); if (user == null) { Response.Write("请先登录。"); return; } string aid = CommonManager.Web.Request("id", ""); if (string.IsNullOrEmpty(aid) || !CommonManager.String.IsInteger(aid)) { Response.Write("请不要尝试非法操作。"); return; } Web_UserAlbum pic = DbSession.Default.Get <Web_UserAlbum>(Web_UserAlbum._.ID == aid && Web_UserAlbum._.UserID == user.UserID); if (pic == null) { Response.Write("请不要尝试非法操作。"); return; } Web_UserAlbumColumn column = DbSession.Default.Get <Web_UserAlbumColumn>(Web_UserAlbumColumn._.ID == pic.ColumnID); column.Cover = pic.PicPath; column.Attach(); DbSession.Default.Save <Web_UserAlbumColumn>(column); Response.Write("success"); }
/// <summary> /// ��ӻ���һ����Ƭ /// </summary> private void AddPic() { if (!UserLoginInfo.IsLogin) { Response.Write("����δ��¼��<a href='javascript:history.back();'>��˷�����һҳ</a>"); return; } TUsers model = DbSession.Default.Get<TUsers>(TUsers._.UserName == UserLoginInfo.UserName); if (model == null) { Response.Write("����δ��¼��<a href='javascript:history.back();'>��˷�����һҳ</a>"); return; } //��ȡ���ֵ string lcover = ""; //�ж��Ƿ������ string columnid = CommonManager.Web.RequestForm("selColumnId", ""); if (string.IsNullOrEmpty(columnid) || !CommonManager.String.IsInteger(columnid)) { Response.Write("û����ᣬ���ȴ�����ᡣ<a href='/Manage/AlbumWrite.aspx'>����������</a>"); return; } if (Request.Files.Count > 0) { try { if (!CommonManager.File.UploadFile(Request.Files["filePicPath"], 100 * 1024, new string[] { "jpg", "jpeg", "gif", "bmp", "png" }, "/Upload/Photo/" + model.UserID.ToString(), FileOperator.RenameType.��ˮ��, out lcover)) { lcover = ""; } } catch (Exception ex) { Response.Write("�ļ��ϴ�����" + ex.Message + "<a href='javascript:history.back();'>��˷�����һҳ</a>"); return; } } string pname = Server.HtmlEncode(CommonManager.Web.RequestForm("txtPicName", "")); string pdes = Server.HtmlEncode(CommonManager.Web.RequestForm("txtPicDescription", "")); string shortnum = CommonManager.Web.RequestForm("txtShortNum", "1"); string id = CommonManager.Web.Request("id", ""); //У�� if (string.IsNullOrEmpty(id) || !CommonManager.String.IsInteger(id)) { if (string.IsNullOrEmpty(lcover)) { Response.Write("���ϴ�������Ƭ��<a href='javascript:history.back();'>��˷�����һҳ</a>"); return; } } if (string.IsNullOrEmpty(pname) && !string.IsNullOrEmpty(lcover)) { pname = lcover.Substring(lcover.LastIndexOf('/') + 1); } //�������ݿ� Web_UserAlbum pic; if (string.IsNullOrEmpty(id) || !CommonManager.String.IsInteger(id)) { pic = new Web_UserAlbum(); pic.InputTime = DateTime.Now; pic.UserID = model.UserID; pic.Enable = Library.EnableState.δ����.ToString(); } else { pic = DbSession.Default.Get<Web_UserAlbum>(Web_UserAlbum._.ID == id); pic.Attach(); } pic.ColumnID = int.Parse(columnid); pic.PicDescription = pdes; pic.PicName = pname; pic.PicPath = string.IsNullOrEmpty(pic.PicPath) ? lcover : pic.PicPath; pic.ShortNum = (string.IsNullOrEmpty(shortnum) || !CommonManager.String.IsInteger(shortnum)) ? 1 : int.Parse(shortnum); DbSession.Default.Save<Web_UserAlbum>(pic); //���� Response.Write("<script>location.href='PicList.aspx';</script>"); }
/// <summary> /// 添加或修改一张照片 /// </summary> private void AddPic() { if (!UserLoginInfo.IsLogin) { Response.Write("您尚未登录。<a href='javascript:history.back();'>点此返回上一页</a>"); return; } TUsers model = DbSession.Default.Get <TUsers>(TUsers._.UserName == UserLoginInfo.UserName); if (model == null) { Response.Write("您尚未登录。<a href='javascript:history.back();'>点此返回上一页</a>"); return; } //获取表单值 string lcover = ""; //判断是否有相册 string columnid = CommonManager.Web.RequestForm("selColumnId", ""); if (string.IsNullOrEmpty(columnid) || !CommonManager.String.IsInteger(columnid)) { Response.Write("没有相册,请先创建相册。<a href='/Manage/AlbumWrite.aspx'>点击创建相册</a>"); return; } if (Request.Files.Count > 0) { try { if (!CommonManager.File.UploadFile(Request.Files["filePicPath"], 100 * 1024, new string[] { "jpg", "jpeg", "gif", "bmp", "png" }, "/Upload/Photo/" + model.UserID.ToString(), FileOperator.RenameType.流水号, out lcover)) { lcover = ""; } } catch (Exception ex) { Response.Write("文件上传错误:" + ex.Message + "<a href='javascript:history.back();'>点此返回上一页</a>"); return; } } string pname = Server.HtmlEncode(CommonManager.Web.RequestForm("txtPicName", "")); string pdes = Server.HtmlEncode(CommonManager.Web.RequestForm("txtPicDescription", "")); string shortnum = CommonManager.Web.RequestForm("txtShortNum", "1"); string id = CommonManager.Web.Request("id", ""); //校验 if (string.IsNullOrEmpty(id) || !CommonManager.String.IsInteger(id)) { if (string.IsNullOrEmpty(lcover)) { Response.Write("请上传您的照片。<a href='javascript:history.back();'>点此返回上一页</a>"); return; } } if (string.IsNullOrEmpty(pname) && !string.IsNullOrEmpty(lcover)) { pname = lcover.Substring(lcover.LastIndexOf('/') + 1); } //存入数据库 Web_UserAlbum pic; if (string.IsNullOrEmpty(id) || !CommonManager.String.IsInteger(id)) { pic = new Web_UserAlbum(); pic.InputTime = DateTime.Now; pic.UserID = model.UserID; pic.Enable = Library.EnableState.未处理.ToString(); } else { pic = DbSession.Default.Get <Web_UserAlbum>(Web_UserAlbum._.ID == id); pic.Attach(); } pic.ColumnID = int.Parse(columnid); pic.PicDescription = pdes; pic.PicName = pname; pic.PicPath = string.IsNullOrEmpty(pic.PicPath) ? lcover : pic.PicPath; pic.ShortNum = (string.IsNullOrEmpty(shortnum) || !CommonManager.String.IsInteger(shortnum)) ? 1 : int.Parse(shortnum); DbSession.Default.Save <Web_UserAlbum>(pic); //反馈 Response.Write("<script>location.href='PicList.aspx';</script>"); }