protected void Page_Load(object sender, EventArgs e) { UserBll.CheckIsLogin(); UserModel = UserBll.GetUser(UserBll.GetCookie().LogName); B_UserSpace.IsActive(UserModel.UserID, 1); if (!string.IsNullOrEmpty(Request.QueryString["PhotoId"])) { try { PhotoId = Convert.ToInt32(Request.QueryString["PhotoId"]); } catch { } } if (!string.IsNullOrEmpty(Request.QueryString["AlbumId"])) { try { AlbumId = Convert.ToInt32(Request.QueryString["AlbumId"]); } catch { } } if (PhotoId <= 0) { Function.ShowMsg(0,"<li>此照片不存在,或已经被删除</li><li><a href='javascript:history.back();'>返回上一级</a></li>"); } PhotoModel = PhotoBll.GetPhotoByPhotoId(PhotoId); //if (txtPhoto.Text.Trim() != "") imgView.ImageUrl = Param.ApplicationRootPath + "/user/upload/" + "" + txtPhoto.Text.Trim(); if (!IsPostBack) { ddlAlbumBind(); ShowInfo(PhotoId); } }
public void AddPhoto(M_UserPhoto model) { SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("@AlbumId", SqlDbType.Int, 4), new SqlParameter("@FileName", SqlDbType.NVarChar), new SqlParameter("@FilePath", SqlDbType.NVarChar), new SqlParameter("@Description", SqlDbType.NVarChar), new SqlParameter("@PostTime", SqlDbType.NVarChar), new SqlParameter("@UserId", SqlDbType.Int, 4), new SqlParameter("@UserName", SqlDbType.NVarChar), new SqlParameter("@PhotoId", SqlDbType.Int, 4), new SqlParameter("@VisitNum", SqlDbType.Int, 4), new SqlParameter("@FileSize", SqlDbType.Int, 4) }; commandParameters[0].Value = model.AlbumId; commandParameters[1].Value = model.FileName; commandParameters[2].Value = model.FilePath; commandParameters[3].Value = model.Description; commandParameters[4].Value = model.PostTime; commandParameters[5].Value = model.UserId; commandParameters[6].Value = model.UserName; commandParameters[7].Value = model.PhotoId; commandParameters[8].Value = model.VisitNum; commandParameters[9].Value = model.FileSize; SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringKy, CommandType.StoredProcedure, "Up_UserPhoto_Set", commandParameters); }
public M_UserPhoto GetPhotoByPhotoId(int Id) { SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("@PhotoId", Id) }; DataTable table = SqlHelper.ExecuteTable(SqlHelper.ConnectionStringKy, CommandType.StoredProcedure, "Up_UserPhoto_GetByPhotoId", commandParameters); M_UserPhoto photo = new M_UserPhoto(); if (table.Rows.Count > 0) { photo.FileName = table.Rows[0]["FileName"].ToString(); photo.FilePath = table.Rows[0]["FilePath"].ToString(); photo.PhotoId = int.Parse(table.Rows[0]["PhotoId"].ToString()); photo.PostTime = table.Rows[0]["PostTime"].ToString(); photo.UserId = int.Parse(table.Rows[0]["UserId"].ToString()); photo.UserName = table.Rows[0]["UserName"].ToString(); photo.AlbumId = int.Parse(table.Rows[0]["AlbumId"].ToString()); photo.Description = table.Rows[0]["Description"].ToString(); photo.VisitNum = int.Parse(table.Rows[0]["VisitNum"].ToString()); return photo; } return null; }
public void UpdatePhoto(M_UserPhoto model) { this.AddPhoto(model); }
protected void ShowInfo(int PhotoId) { PhotoModel=PhotoBll.GetPhotoByPhotoId(PhotoId); txtPhotoName.Text = PhotoModel.FileName; txtDescription.Text = PhotoModel.Description; txtPhoto.Text = PhotoModel.FilePath; txtPhoto.Text = PhotoModel.FilePath; imgView.ImageUrl = Param.ApplicationRootPath + "/user/upload/" + "" + txtPhoto.Text.Trim(); }
public void AddPhoto(M_UserPhoto model) { this.IUP.AddPhoto(model); }