webservice.cs

visual c# 网络编程技术与实践实例包括几个源码

                myDataAdapter.Fill(myDataSet, "UserInfor");
                //返回该数据
                return myDataSet;
            }
            finally
            {
                //函数结束时关闭连接
                if (conn.State == ConnectionState.Open)
                    conn.Close();
            }
        }

        [WebMethod]
        //更新用户信息
        public int UpdateUser(string[] userInfor)
        {
            //连接数据库
            SqlConnection conn = new SqlConnection(DBconn);
            SqlCommand SqlCmd = conn.CreateCommand();

            SqlCmd.CommandType = CommandType.StoredProcedure;
            SqlCmd.CommandText = "pd_UpdateUser";
            //设置注册的用户默认的组为1  为用户
            //数据库中有默认的用户为0组 为管理员
            SqlParameter parInput1 = SqlCmd.Parameters.Add("@name", SqlDbType.Char);
            parInput1.Direction = ParameterDirection.Input;
            parInput1.Value = userInfor[0].Trim();

            SqlParameter parInput2 = SqlCmd.Parameters.Add("@nick", SqlDbType.Char);
            parInput2.Direction = ParameterDirection.Input;
            parInput2.Value = userInfor[1].Trim();

            SqlParameter parInput3 = SqlCmd.Parameters.Add("@pass", SqlDbType.Char);
            parInput3.Direction = ParameterDirection.Input;
            parInput3.Value = userInfor[2].Trim();

            SqlParameter parInput4 = SqlCmd.Parameters.Add("@email", SqlDbType.VarChar);
            parInput4.Direction = ParameterDirection.Input;
            parInput4.Value = userInfor[3].Trim();

            SqlParameter parInput5 = SqlCmd.Parameters.Add("@mark", SqlDbType.VarChar);
            parInput5.Direction = ParameterDirection.Input;
            parInput5.Value = userInfor[4].Trim();

            SqlParameter parReturn1 = SqlCmd.Parameters.Add("returnvalue", SqlDbType.Int);
            parReturn1.Direction = ParameterDirection.ReturnValue;
            //打开数据库连接
            if (conn.State == ConnectionState.Closed)
            {
                conn.Open();
            }
            int state;
            try
            {
                //执行插入用户信息命令
                SqlCmd.ExecuteNonQuery();
                state = Convert.ToInt32(SqlCmd.Parameters["returnvalue"].Value);
            }
            catch
            {
                state = 0;
            }
            finally
            {
                //关闭数据库
                if (conn.State == ConnectionState.Open)
                    conn.Close();
            }
            return state;
        }

        [WebMethod]
        //获得主题内容
        public DataSet GetTitle(int id)
        {
            SqlConnection conn = new SqlConnection(DBconn);
            //使用pd_GetTitle存储过程
            SqlCommand SqlCmd = conn.CreateCommand();
            SqlCmd.CommandType = CommandType.StoredProcedure;
            SqlCmd.CommandText = "pd_GetTitle";
            //将id作为参数传入
            SqlParameter parInput1 = SqlCmd.Parameters.Add("@id", SqlDbType.Int);
            parInput1.Direction = ParameterDirection.Input;
            parInput1.Value = id;
            //打开数据库连接
            try
            {
                if (conn.State == ConnectionState.Closed)
                    conn.Open();
                //使用SqlDataAdapter把数据填充到DataSet类型中
                SqlDataAdapter myDataAdapter = new SqlDataAdapter(SqlCmd);
                DataSet myDataSet = new DataSet();
                //将表TitleList填写到DataSet类型中
                myDataAdapter.Fill(myDataSet, "TitleList");
                //返回DateSet类型值
                return myDataSet;
            }
            finally
            {
                //关闭数据库
                if (conn.State == ConnectionState.Open)
                    conn.Close();
            }
        }

        [WebMethod]
        //获得主题回复
        public DataSet GetContent(int id)
        {
            SqlConnection conn = new SqlConnection(DBconn);
            SqlCommand SqlCmd = conn.CreateCommand();
            SqlCmd.CommandType = CommandType.StoredProcedure;
            SqlCmd.CommandText = "pd_GetContent";
            //主题Id作为参数传入
            SqlParameter parInput1 = SqlCmd.Parameters.Add("@id", SqlDbType.Int);
            parInput1.Direction = ParameterDirection.Input;
            parInput1.Value = id;
            //打开数据库
            try
            {
                if (conn.State == ConnectionState.Closed)
                    conn.Open();
                //使用SqlDataAdapter把数据填充到DataSet类型中
                SqlDataAdapter myDataAdapter = new SqlDataAdapter(SqlCmd);
                DataSet myDataSet = new DataSet();
                //将表noteContent填写到DataSet类型中
                myDataAdapter.Fill(myDataSet, "noteContent");
                //返回DateSet类型值
                return myDataSet;
            }
            finally
            {
                //关闭数据库
                if (conn.State == ConnectionState.Open)
                    conn.Close();
            }
        }

        [WebMethod]
        //回复主题
        public int AppearRes(int id,string content, string nick, string name)
        {
            SqlConnection conn = new SqlConnection(DBconn);
            SqlCommand SqlCmd = conn.CreateCommand();
            //使用pd_ResNote存储过程
            SqlCmd.CommandType = CommandType.StoredProcedure;
            SqlCmd.CommandText = "pd_ResNote";
            //id
            SqlParameter parInput1 = SqlCmd.Parameters.Add("@id", SqlDbType.Int);
            parInput1.Direction = ParameterDirection.Input;
            parInput1.Value = id;
            SqlParameter parInput2 = SqlCmd.Parameters.Add("@Content", SqlDbType.Text);
            parInput2.Direction = ParameterDirection.Input;
            parInput2.Value = content;
            //使用系统时间作为回复主题时间参数
            SqlParameter parInput3 = SqlCmd.Parameters.Add("@noteTime", SqlDbType.DateTime);
            parInput3.Direction = ParameterDirection.Input;
            parInput3.Value = System.DateTime.Now;
            SqlParameter parInput4 = SqlCmd.Parameters.Add("@userNick", SqlDbType.Char);
            parInput4.Direction = ParameterDirection.Input;
            parInput4.Value = nick;
            SqlParameter parInput5 = SqlCmd.Parameters.Add("@name", SqlDbType.Char);
            parInput5.Direction = ParameterDirection.Input;
            parInput5.Value = name;
            //获得返回值
            SqlParameter parReturn1 = SqlCmd.Parameters.Add("returnvalue", SqlDbType.Int);
            parReturn1.Direction = ParameterDirection.ReturnValue;
            //打开数据库连接
            if (conn.State == ConnectionState.Closed)
            {
                conn.Open();
            }
            int state;
            try
            {
                //执行回复主题命令
                SqlCmd.ExecuteNonQuery();
                state = Convert.ToInt32(SqlCmd.Parameters["returnvalue"].Value);
            }
            catch
            {
                state = 0;
            }
            finally
            {
                //关闭数据库
                if (conn.State == ConnectionState.Open)
                    conn.Close();
            }
            return state;
        }

        [WebMethod]
        //获得用户发表的主题
        public DataSet GetUserTitle(string name, string group)
        {
            SqlConnection conn = new SqlConnection(DBconn);

            SqlCommand SqlCmd = conn.CreateCommand();
            //使用pd_GetUserTitle存储过程
            SqlCmd.CommandType = CommandType.StoredProcedure;
            SqlCmd.CommandText = "pd_GetUserTitle";

            SqlParameter parInput1 = SqlCmd.Parameters.Add("@name", SqlDbType.Char);
            parInput1.Direction = ParameterDirection.Input;
            parInput1.Value = name;

            SqlParameter parInput2 = SqlCmd.Parameters.Add("@group", SqlDbType.Char);
            parInput2.Direction = ParameterDirection.Input;
            parInput2.Value = group;

            try
            {
                if (conn.State == ConnectionState.Closed)
                    conn.Open();

                SqlDataAdapter myDataAdapter = new SqlDataAdapter(SqlCmd);
                DataSet myDataSet = new DataSet();

                myDataAdapter.Fill(myDataSet, "TitleList");

                return myDataSet;
            }
            finally
            {
                //函数结束时关闭连接
                if (conn.State == ConnectionState.Open)
                    conn.Close();
            }
        }

        [WebMethod]
        //获得用户的回复
        public DataSet GetUserRes(string name)
        {
            SqlConnection conn = new SqlConnection(DBconn);

            //使用pd_GetUserRes获得用户回复
            SqlCommand SqlCmd = conn.CreateCommand();
            SqlCmd.CommandType = CommandType.StoredProcedure;
            SqlCmd.CommandText = "pd_GetUserRes";

            SqlParameter parInput1 = SqlCmd.Parameters.Add("@name", SqlDbType.Char);
            parInput1.Direction = ParameterDirection.Input;
            parInput1.Value = name;

            try
            {
                if (conn.State == ConnectionState.Closed)
                    conn.Open();

                SqlDataAdapter myDataAdapter = new SqlDataAdapter(SqlCmd);
                DataSet myDataSet = new DataSet();
                //获得结果填充到myDataSet数据集中并返回
                myDataAdapter.Fill(myDataSet, "NoteContent");
                return myDataSet;
            }
            finally
            {
                //函数结束时关闭连接
                if (conn.State == ConnectionState.Open)
                    conn.Close();
            }
        }

        [WebMethod]
        //修改帖子
        public int AlterNote(int id, string title, string content)
        {
            SqlConnection conn = new SqlConnection(DBconn);
            SqlCommand SqlCmd = conn.CreateCommand();
            SqlCmd.CommandType = CommandType.StoredProcedure;
            SqlCmd.CommandText = "pd_alterNote";
            //将主题id作为参数传入
            SqlParameter parInput1 = SqlCmd.Parameters.Add("@id", SqlDbType.Int);
            parInput1.Direction = ParameterDirection.Input;
            parInput1.Value = id;
            //将主题信息传入
            SqlParameter parInput2 = SqlCmd.Parameters.Add("@Content", SqlDbType.Text);
            parInput2.Direction = ParameterDirection.Input;
            parInput2.Value = content;
            SqlParameter parInput3 = SqlCmd.Parameters.Add("@title", SqlDbType.Text);
            parInput3.Direction = ParameterDirection.Input;
            parInput3.Value = title;
            SqlParameter parReturn1 = SqlCmd.Parameters.Add("returnvalue", SqlDbType.Int);
            parReturn1.Direction = ParameterDirection.ReturnValue;
            //打开数据库连接
            if (conn.State == ConnectionState.Closed)
            {
                conn.Open();
            }
            int state;
            try
            {
                //执行修改主题命令
                SqlCmd.ExecuteNonQuery();
                state = Convert.ToInt32(SqlCmd.Parameters["returnvalue"].Value);
            }
            catch
            {
                state = 0;
            }
            finally
            {
                //关闭数据库
                if (conn.State == ConnectionState.Open)
                    conn.Close();
            }
            return state;