//根据信息插入新的images列
public void InsertImage(ref Image_Data imageData)
{
try
{
Conn.Open();
string sql = "insert into Images (imageName,albumId,descriptions,imageUrl,createDate,imageType)"
+" values(@imageName,@albumId,@descriptions,@imageUrl,@createDate,@imageType)";
//添加图片信息进图片列表
SqlParameter[] parm = this.ConvertImage_DataToParams(ref imageData);
ExecuteNonQuery(sql, parm);
Conn.Close();
}
catch (Exception e)
{
Conn.Close();
throw e;
}
}
public void AddImage(ref Image_Data imageData,string userLoginName, string albumName, FileUpload imageUrlFU)
{
//加入新的图片，包括数据库，根据给出的userLoginName和albumName计算路径
imageData.imageUrl = BASE_PATH + "\\"
+ USER_FILE_PREFIX + userLoginName + "\\"
+ ALBUM_FILE_PREFIX + albumName + "\\"
+ IMAGE_PREFIX + imageData.imageName;
if (imageUrlFU.FileName.Length > 0)
{
string exname = imageUrlFU.FileName.Split('.')[1];
if (exname.ToLower() == "jpg" || exname.ToLower() == "gif" || exname.ToLower() == "png")
{
imageData.imageUrl += "." + exname;
imageUrlFU.SaveAs(MAP_PATH + "\\" + imageData.imageUrl);
}
}
mImageDB.InsertImage(ref imageData);
}
public void AddImage(ref Image_Data imageData)
{
//加入新的图片，包括数据库，设置服务器图片的路径
mImageDB.InsertImage(ref imageData);
}
//转换dataTabel的首行数据至Image_Data结构
//辅助方法
private void ConvertDataTableToImage_Data(DataTable dt, ref Image_Data image_data)
{
if (dt.Rows.Count < 1)
return;
image_data.imageId = Convert.ToInt64(dt.Rows[0]["imageId"]);
image_data.imageName = dt.Rows[0]["imageName"].ToString();
image_data.imageUrl = dt.Rows[0]["imageUrl"].ToString();
image_data.imageType = dt.Rows[0]["imageType"].ToString();
image_data.createDate = dt.Rows[0]["createDate"].ToString();
image_data.descriptions = dt.Rows[0]["descriptions"].ToString();
image_data.albumId = Convert.ToInt64(dt.Rows[0]["albumId"]);
}
//更新操作
public void UpdateImage(ref Image_Data imageData, FileUpload imageUrlFU)
{
string exname;
if (imageUrlFU.FileName.Length > 0)
{
exname = imageUrlFU.FileName.Split('.')[1];
if (exname.ToLower() == "jpg" || exname.ToLower() == "gif" || exname.ToLower() == "png")
{
imageUrlFU.SaveAs(MAP_PATH + "\\" + imageData.imageUrl);
}
}
mImageDB.UpdateImage(ref imageData);
}
//通过图片的id存放图片信息到image_data
public void GetImageByImageId(long imageId, ref Image_Data image_data)
{
DataTable dt = mImageDB.SelectedImageByImageId(imageId);
ConvertDataTableToImage_Data(dt, ref image_data);
}
//将userData结构中的数据转换到sqlparameter中
//辅助方法
private SqlParameter[] ConvertImage_DataToParams(ref Image_Data imageData)
{
SqlParameter[] parm = new SqlParameter[]
{
new SqlParameter ("@imageid",imageData.imageId),
new SqlParameter ("@imageName",imageData.imageName),
new SqlParameter ("@createDate",imageData.createDate),
new SqlParameter ("@albumId",imageData.albumId),
new SqlParameter ("@descriptions",imageData.descriptions),
new SqlParameter ("@imageUrl",imageData.imageUrl),
new SqlParameter ("@imageType",imageData.imageType)
};
return parm;
}
public void UpdateImage(ref Image_Data imageData)
{
try
{
Conn.Open();
string sql = "update Images set imageType = @imageType,imageName = @imageName,descriptions = @descriptions where imageId = @imageId";
//添加用户信息进用户列表
SqlParameter[] parm = this.ConvertImage_DataToParams(ref imageData);
ExecuteNonQuery(sql, parm);
Conn.Close();
}
catch (Exception e)
{
Conn.Close();
throw e;
}
}
