//根据信息插入新的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; } }