public static bool MyDiaryAddA(MyDiary MyDiary)
{
SqlParameter[] sqlPare = new SqlParameter[]
{
new SqlParameter("@DiaryContent", MyDiary.DiaryContent),
new SqlParameter("@DiaryClassifyId", MyDiary.DiaryClassifyId),
new SqlParameter("@DiaryOvertState", MyDiary.DiaryOvertState),
new SqlParameter("@CreateDate", MyDiary.CreateDate),
new SqlParameter("@UserId", MyDiary.UserId)
};
return(DBHelper.ExecuteCommand("[dbo].[pro_MyDiaryAddA]", sqlPare) > 0);
}
//public static DataTable selectUserInfo(int UserID)
//{
// SqlParameter[] sqlPare = new SqlParameter[]
// {
// new SqlParameter("@UserId",UserID)
// };
// return DBHelper.GetDataSet("[dbo].[pro_UserInfoList]", sqlPare);
//}
public static DataTable getMyDiaryList(MyDiary mydiary, int SelectType)
{
SqlParameter[] sqlPare = new SqlParameter[]
{
new SqlParameter("@UserId", mydiary.UserId),
new SqlParameter("@DiaryClassifyId", mydiary.DiaryClassifyId),
new SqlParameter("@DiaryOvertState", mydiary.DiaryOvertState),
new SqlParameter("@SelectType", SelectType),
new SqlParameter("@RecordCount", SqlDbType.Int)
};
sqlPare[4].Direction = ParameterDirection.Output;
return(DBHelper.GetDataSet("[dbo].[pro_MyDiaryList]", sqlPare));
}
public static bool MyDiaryDelete(MyDiary mydiary, out int Result)
{
SqlParameter[] sqlPare = new SqlParameter[]
{
new SqlParameter("@DiaryId", mydiary.DiaryId),
new SqlParameter("@UserId", mydiary.UserId),
new SqlParameter("@Result", SqlDbType.Int)
};
sqlPare[2].Direction = ParameterDirection.Output;
int count = DBHelper.ExecuteCommand("[dbo].[pro_MyDiaryDelete]", sqlPare);
if (!(count > 0))
{
Result = Convert.ToInt32(sqlPare[2].Value.ToString());
}
else
{
Result = -1;
}
return(count > 0);
}
