protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName.ToString().Equals("viewAlbum")) { long i = Convert.ToInt64(e.CommandArgument); Album_Data album_data = new Album_Data(); mAlbum.GetAlbumByAlbumId(i, ref album_data); Response.Redirect("AlbumHome.aspx?albumId=" + Convert.ToString(album_data.albumId), true); } }
//根据信息插入新的users列 public void InsertAlbum(ref Album_Data albumData) { try { Conn.Open(); string sql = "insert into Albums (albumName,userId,descriptions,logoUrl,permission)" +" values(@albumName,@userId,@descriptions,@logoUrl,@permission)"; //添加用户信息进用户列表 SqlParameter[] parm = this.ConvertAlbum_DataToParams(ref albumData); ExecuteNonQuery(sql, parm); Conn.Close(); } catch (Exception e) { Conn.Close(); throw e; } }
public void AddAlbum(ref Album_Data albumData, string userLoginName,FileUpload albumLogoFU) { //创建相册并且创建相册目录 CreateAlbumFile(MAP_PATH+"\\"+BASE_PATH+"\\"+USER_FILE_PREFIX+userLoginName+"\\"+ALBUM_FILE_PREFIX+albumData.albumName); albumData.logoUrl = BASE_PATH + "\\" + USER_FILE_PREFIX + userLoginName + "\\" + ALBUM_FILE_PREFIX + albumData.albumName + "\\" + ALBUM_LOGO_PREFIX + albumData.albumName; string exname; if (albumLogoFU.FileName.Length > 0) { exname = albumLogoFU.FileName.Split('.')[1]; if (exname.ToLower() == "jpg" || exname.ToLower() == "gif" || exname.ToLower() == "png") { albumData.logoUrl += "." + exname; albumLogoFU.SaveAs(MAP_PATH+"\\"+albumData.logoUrl); } } mAlbumDB.InsertAlbum(ref albumData); }
public void AddAlbum(ref Album_Data albumData, string absoluteUrl) { //加入新的相册,包括数据库,创建相册文件夹和设置logo的路径 CreateAlbumFile(absoluteUrl); mAlbumDB.InsertAlbum(ref albumData); }
//转换dataTabel的首行数据至User_Data结构 private void ConvertDataTableToAlbum_Data(DataTable dt, ref Album_Data album_data) { if (dt.Rows.Count < 1) return; album_data.albumId = Convert.ToInt64(dt.Rows[0]["albumId"]); album_data.albumName = dt.Rows[0]["albumName"].ToString(); album_data.descriptions = dt.Rows[0]["descriptions"].ToString(); album_data.logoUrl = dt.Rows[0]["logoUrl"].ToString(); album_data.userId = Convert.ToInt64(dt.Rows[0]["userId"]); album_data.permission = dt.Rows[0]["permission"].ToString(); }
//更新相册 public void UpdateAlbum(ref Album_Data album_data, FileUpload albumLogoFU) { string exname; if (albumLogoFU.FileName.Length > 0) { exname = albumLogoFU.FileName.Split('.')[1]; if (exname.ToLower() == "jpg" || exname.ToLower() == "gif" || exname.ToLower() == "png") { albumLogoFU.SaveAs(MAP_PATH + "\\" + album_data.logoUrl); } } mAlbumDB.UpdateAlbum(ref album_data); }
//通过相册的id存放相册信息到album_data public void GetAlbumByAlbumId(long albumId, ref Album_Data album_data) { DataTable dt = mAlbumDB.SelectedAlbumByAlbumId(albumId); ConvertDataTableToAlbum_Data(dt, ref album_data); }
//将userData结构中的数据转换到sqlparameter中 //辅助方法 private SqlParameter[] ConvertAlbum_DataToParams(ref Album_Data albumData) { SqlParameter[] parm = new SqlParameter[] { new SqlParameter ("@albumId",albumData.albumId), new SqlParameter ("@albumName",albumData.albumName), new SqlParameter ("@userId",albumData.userId), new SqlParameter ("@descriptions",albumData.descriptions), new SqlParameter ("@logoUrl",albumData.logoUrl), new SqlParameter ("@permission",albumData.permission) }; return parm; }
public void UpdateAlbum(ref Album_Data albumData) { try { Conn.Open(); string sql = "update Albums set albumName = @albumName,permission = @permission,descriptions = @descriptions" +" where albumId = @albumId"; //添加用户信息进用户列表 SqlParameter[] parm = this.ConvertAlbum_DataToParams(ref albumData); ExecuteNonQuery(sql, parm); Conn.Close(); } catch (Exception e) { Conn.Close(); throw e; } }