随笔-97
评论-105
文章-46
trackbacks-1
| Konimeter的Blog主站 | Email： | koni@21cn.com | |
| Konimeter@Solartimes | QQ： | 670955 | |
| Konimeter@ShangXun | MSN： | konimeter@hotmail.com |
2005年10月20日
DeletePicture
public override void DeletePicture(int sectionID, int threadID)
{
using( SqlConnection myConnection = GetSqlConnection() ) 
{ SqlCommand myCommand = new SqlCommand(databaseOwner + ".cs_Thread_Delete", myConnection); // Mark the Command as a SPROC myCommand.CommandType = CommandType.StoredProcedure; // Add Parameters to SPROC myCommand.Parameters.Add("@SectionID", SqlDbType.Int, 4).Value = sectionID; //15 //氯胺酮的相册 myCommand.Parameters.Add("@ThreadID", SqlDbType.Int, 4).Value = threadID; //27 //关于E欣欣4的主题 myCommand.Parameters.Add(this.SettingsIDParameter()); // Execute the command myConnection.Open(); myCommand.ExecuteNonQuery(); myConnection.Close();
}
}DeletePictureDatapublic override void DeletePictureData(int postID){ using( SqlConnection connection = GetSqlConnection() ) { SqlCommand myCommand = new SqlCommand(databaseOwner + ".cs_PostAttachment_Delete", connection); myCommand.CommandType = CommandType.StoredProcedure; // Add parameters // myCommand.Parameters.Add("@PostID", SqlDbType.Int).Value = postID; //30 //E欣欣4，指定需要删除的相片 connection.Open(); myCommand.ExecuteNonQuery(); connection.Close(); }}GetPicturepublic override Picture GetPicture(int postID, int userID){ // Create Instance of Connection and Command Object using( SqlConnection myConnection = GetSqlConnection() ) { SqlCommand myCommand = new SqlCommand(databaseOwner + ".cs_forums_Post", myConnection); // Mark the Command as a SPROC myCommand.CommandType = CommandType.StoredProcedure; // Add Parameters to SPROC myCommand.Parameters.Add("@PostID", SqlDbType.Int).Value = postID; //30 //表示E欣欣4的相片的记录（不包括相片图片） myCommand.Parameters.Add("@UserID", SqlDbType.Int).Value = userID; //2105 //不是数据库User的那个GUID的UserID myCommand.Parameters.Add("@TrackViews", SqlDbType.Bit).Value = false; //false myCommand.Parameters.Add(this.SettingsIDParameter()); // Execute the command myConnection.Open(); SqlDataReader dr = myCommand.ExecuteReader(); if (!dr.Read()) //此function的目的在于获取指定相片的记录，如果获取不成功，证明没有该相片，因此返回错误 { dr.Close(); myConnection.Close(); // we did not get back a post throw new CSException(CSExceptionType.PostNotFound, postID.ToString()); } Picture p = PopulatePictureFromIDataReader(dr); //如果获取指定相片的记录正常，那么根据记录获取一个Picture类型的自定义对象变量 dr.Close(); myConnection.Close(); // we have a post to work with return p; }}