webservice 的使用问题

最新推荐文章于 2020-06-22 13:49:53 发布

原创最新推荐文章于 2020-06-22 13:49:53 发布 · 517 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#webservice #string #object #class #iis #cmd

本文介绍了一种通过WebService实现药品信息添加的方法。首先确保安装IIS并创建WebService接口，然后在客户端通过引用WebService来调用服务端定义的存储过程，完成药品数据的添加。

要使用webservice就必须要安装好iis，然后写好webservice中的方法，在程序的目录出右击，选择“添加web 引用“，然后在页面引用webserver类就可以了调用webserver中的方法了。

页面使用：

using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;

public partial class ViewPage_DrugInformationForm : System.Web.UI.UserControl
{
    WebService ws = new WebService();    //引用webservice
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void btnSave_Click(object sender, EventArgs e)
    {
        string MID = txtDrugID.Text.ToString();
        string MName = txtDrugName.Text.ToString();
        string MPrice = txtDrugPrice.Text.ToString();
        string MEfficacy = txtEfficacy.Text.ToString();
        string MProduce = txtProduce.Text.ToString();
        string MUnit= txtUnit.Text.ToString();
        DateTime MValidity = Convert.ToDateTime(txtValidity.Text.ToString());
        int MCount = Convert.ToInt32(txtCount.Text.ToString());
        int MClasser = Convert.ToInt32(txtClasser.Text.ToString());
        bool addYesOrNo =ws .addDrugInforWeb(MID, MName, MPrice, MCount, MClasser, MUnit, MProduce, MValidity, MEfficacy, "AddDrugInfor");
    }
}

webservice 中的方法是：

public class WebService : System.Web.Services.WebService
{
classConn greenconn = new classConn();
public string str;

      [WebMethod]
    public bool addDrugInforWeb(string MID, string MName, string Mprice,int MCount,int MClasser,string MUnit,string MProduce, DateTime MValidity, string MEfficacy, string AddDrugInfor)
    {
        str = greenconn.Greensqlcon();
        SqlConnection con = new SqlConnection(str);
        con.Open();
        SqlCommand cmd = new SqlCommand(AddDrugInfor, con);  //AddDrugInfor是储存过程名
        cmd.CommandType = CommandType.StoredProcedure;
         SqlParameter id = new SqlParameter("@DrugID", DbType.String);
         SqlParameter name= new SqlParameter("@DrugName", DbType.String);
         SqlParameter price = new SqlParameter("@DrugPrice", DbType.String);
         SqlParameter count = new SqlParameter("@DrugCount", DbType.Int32 );
         SqlParameter classer = new SqlParameter("@DrugClasser", DbType.Int32 );
         SqlParameter Drugunit = new SqlParameter("@DrugUnit", DbType.String);
         SqlParameter producer=new SqlParameter ("@Producer",DbType.String );
         SqlParameter data = new SqlParameter("@ValidityData", DbType.DateTime);
         SqlParameter efficacy = new SqlParameter("@ProduceEfficacy", DbType.String);
         id.Value = MID;
         name.Value = MName;
         price.Value = Mprice;
         count.Value = MCount;
         classer.Value = MClasser;
         Drugunit.Value = MUnit;
         producer.Value = MProduce;
         data.Value = MValidity;
         efficacy.Value = MEfficacy;

         cmd.Parameters.Add(id);
         cmd.Parameters.Add(name);
         cmd.Parameters.Add(price);
         cmd.Parameters.Add(count);
         cmd.Parameters.Add(classer);
         cmd.Parameters.Add(Drugunit);
         cmd.Parameters.Add(producer);
         cmd.Parameters.Add(data);
         cmd.Parameters.Add(efficacy);
         if (cmd.ExecuteNonQuery()== 1)
         { return true; }
         else
         { return false; }
    ｝
}