日期:2012-03-21  浏览次数:20511 次

public int AddMessage(int moduleId, int fatherId, String userName, String title, String body, String face) {

            if (userName.Length < 1) {
                userName = "unknown";
            }

            // Create Instance of Connection and Command Object
            SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["connectionString"]);
            SqlCommand myCommand = new SqlCommand("up_PostTopic", myConnection);

            // Mark the Command as a SPROC
            myCommand.CommandType = CommandType.StoredProcedure;

            // Add Parameters to SPROC
            SqlParameter parameterItemID = new SqlParameter("@ItemID", SqlDbType.Int, 4);
            parameterItemID.Direction = ParameterDirection.Output;
            myCommand.Parameters.Add(parameterItemID);

        SqlParameter parameterFatherId = new SqlParameter("@FatherID", SqlDbType.Int, 4);
            parameterFatherId.Value = fatherId;
            myCommand.Parameters.Add(parameterFatherId);

        SqlParameter parameterModuleID = new SqlParameter("@ModuleID", SqlDbType.Int, 4);
            parameterModuleID.Value = moduleId;
            myCommand.Parameters.Add(parameterModuleID);

        SqlParameter parameterUserName = new SqlParameter("@CreatedByUser", SqlDbType.NVarChar, 100);
            parameterUserName.Value = userName;
            myCommand.Parameters.Add(parameterUserName);

            SqlParameter parameterTitle = new SqlParameter("@Title", SqlDbType.NVarChar, 100);
            parameterTitle.Value = title;
            myCommand.Parameters.Add(parameterTitle);

            SqlParameter parameterBody = new SqlParameter("@Content", SqlDbType.NVarChar, 4000);
            parameterBody.Value = body;
            myCommand.Parameters.Add(parameterBody);

        SqlParameter parameterFace = new SqlParameter("@Face", SqlDbType.NVarChar, 100);
            parameterFace.Value = face;
            myCommand.Parameters.Add(paramete