c#編寫webservice服務引用實例分享

2020-01-24 02:59:29

字體：大中小

來源：轉載

供稿：網友

首先在新建了一個web服務文件。

public SqlWhhWebService1()
        {
            InitializeComponent();
        }
        #region Component Designer generated code

//Required by the Web Services Designer
private IContainer components = null;

        /// <summary>
        /// Required method for Designer support - do not modify
        /// the contents of this method with the code editor.
        /// </summary>
        private void InitializeComponent()
        {
        }

        /// <summary>
        /// Clean up any resources being used.
        /// </summary>
        protected override void Dispose(bool disposing)
        {
            if (disposing && components != null)
            {
                components.Dispose();
            }
            base.Dispose(disposing);
        }

#endregion

然后自己調用自己的sqlhelper類中的方法，實現對數據的基本操作，其實和我們在bll中的調用一樣，只不過通過[WebMethod]把自己所定義的方法暴露出來供外部調用，[WebMethod(Description="添加操作")]中的Description屬性標注了對改方法的作用，同時在weiservice頁面中顯示出來。

復制代碼代碼如下:

[WebMethod(Description="添加操作")]
        public ResultModel AddData(string sql, SqlParameter[] sp)
        {
            return WhhSqlHelper.Intersql(sql, sp);
        }
        /// <summary>
        /// 執行更新操作
        /// </summary>
        /// <param name="sql"></param>
        /// <param name="sp"></param>
        /// <returns></returns>
         [WebMethod(Description = "修改操作")]
        public ResultModel Updata(string sql,SqlParameter[] sp)
        {
            return WhhSqlHelper.UpdateSql(sql, sp);
        }
        [WebMethod(Description = "查詢操作")]
        public ResultModel selectSQL(string sql,SqlParameter[]sp)
        {
            return WhhSqlHelper.SingSelectSql(sql, sp);
        }
        [WebMethod(Description = "刪除操作")]
        public ResultModel Delete(string sql,SqlParameter[] sp)
        {
            return WhhSqlHelper.DeleteSql(sql,sp);
        }
        [WebMethod(Description = "是否存在操作")]
        public ResultModel IsExistent(string sql, SqlParameter[] sp)
        {
            return WhhSqlHelper.IsExistent(sql, sp);
        }