public static bool UpdatePhoto(Model.AlbumsPhotosModel model)
{
string sql = "Update AlbumsPhotos Set PhotoName=@PhotoName,Description=@Description Where ID=@ID";
SqlParameter[] para =
{
new SqlParameter("@PhotoName", model.PhotoName),
new SqlParameter("@Description", model.Description),
new SqlParameter("@ID", model.Id)
};
int count = (int)DBHelper.ExecuteNonQuery(sql, para, CommandType.Text);
if (count == 0)
{
return(false);
}
return(true);
}
public static Model.AlbumsPhotosModel GetPhotoMsg(string Id)
{
Model.AlbumsPhotosModel albModel = new Model.AlbumsPhotosModel();
string sql = "Select * From AlbumsPhotos Where ID=@ID";
SqlParameter[] para =
{
new SqlParameter("@ID", Id)
};
DataTable dt = DBHelper.ExecuteDataTable(sql, para, CommandType.Text);
albModel.Id = Convert.ToInt32(dt.Rows[0]["ID"].ToString());
albModel.Number = dt.Rows[0]["Number"].ToString();
albModel.AlbumsID = Convert.ToInt32(dt.Rows[0]["AlbumsID"].ToString());
albModel.PhotoName = dt.Rows[0]["PhotoName"].ToString();
albModel.Description = dt.Rows[0]["Description"].ToString();
albModel.PhotoPath = dt.Rows[0]["PhotoPath"].ToString();
albModel.Xuhao = Convert.ToInt32(dt.Rows[0]["Xuhao"].ToString());
albModel.UploadDate = Convert.ToDateTime(dt.Rows[0]["UploadDate"].ToString());
albModel.UploadIp = dt.Rows[0]["UploadIp"].ToString();
return(albModel);
}
public static bool AddAlbumsPhotos(Model.AlbumsPhotosModel pModel)
{
string sql = @"Insert Into AlbumsPhotos(number,AlbumsID,PhotoName,Description,PhotoPath,Xuhao,UploadDate,UploadIP)
Values(@number,@AlbumsID,@PhotoName,@Description,@PhotoPath,@Xuhao,@UploadDate,@UploadIP)";
SqlParameter[] para =
{
new SqlParameter("@number", pModel.Number),
new SqlParameter("@AlbumsID", pModel.AlbumsID),
new SqlParameter("@PhotoName", pModel.PhotoName),
new SqlParameter("@Description", pModel.Description),
new SqlParameter("@PhotoPath", pModel.PhotoPath),
new SqlParameter("@Xuhao", pModel.Xuhao),
new SqlParameter("@UploadDate", pModel.UploadDate),
new SqlParameter("@UploadIP", pModel.UploadIp)
};
int count = (int)DAL.DBHelper.ExecuteNonQuery(sql, para, CommandType.Text);
if (count == 0)
{
return(false);
}
return(true);
}
public static bool UpdatePhoto(Model.AlbumsPhotosModel model)
{
return(DAL.PersonalSpace.Message.UpdatePhoto(model));
}
public static bool AddAlbumsPhotos(Model.AlbumsPhotosModel pModel)
{
return(DAL.PersonalSpace.Message.AddAlbumsPhotos(pModel));
}