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;
}
}
