自定义一个web Service,在这个web service中自定义函数,实现业务需求的数据,这个过程就可以调用对像模型帮忙处理数据了。开发好后,将这个web service部置到moss服务器上。这时,客户端就可以引用web service的方式,实现客户端与服务器端的数据交互。
具体的实现过程如下:
一:建立Webservice项目
1.使用vs2008建立一个webserivce项目来实现我们的webservice,如下图所示:
为workflowRemind.asmx编写代码如下:
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Services;
using System.Web.Services.Protocols;
using System.Xml.Linq;
using Microsoft.SharePoint;
namespace MossWS
{
/// <summary>
/// WorkflowRemind 的摘要说明
/// </summary>
[WebService(Namespace = "http://tempuri.org/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
[ToolboxItem(false)]
// 若要允许使用 ASP.NET AJAX 从脚本中调用此 Web 服务,请取消对下行的注释。
// [System.Web.Script.Services.ScriptService]
public class WorkflowRemind : System.Web.Services.WebService
{
[WebMethod]
public string HelloWorld()
{
return "Hello World";
}
public SPUser GetSPUser(string UserName, string Domain, string SiteUrl)
{
SPUser user = null;
using (SPSite siteColl = new SPSite(SiteUrl))
{
Domain = Context.User.Identity.Name.Split('\\')[0];
user = siteColl.RootWeb.AllUsers[Domain + "\\" + UserName];
}
return user;
}
[WebMethod]
public int getWorkflowApproveCount(string UserName, string Password, string Domain, string SiteUrl)
{
SPUser user = GetSPUser(UserName, Domain, SiteUrl);
int returnCount = 0;
using (SPSite siteColl = new SPSite(SiteUrl))
{
SPWeb web = siteColl.OpenWeb("/workflowmodule");
string query = "<Where>"
+ " <And>"
+ " <Eq>"
+ " <FieldRef Name=\"_x5f53__x524d__x5ba1__x6279__x4e\" LookupId=\"TRUE\"/>"
+ " <Value Type=\"User\">" + user.ID + "</Value>"
+ " </Eq>"
+ " <Eq>"
+ " <FieldRef Name=\"_x72b6__x6001_\" />"
+ " <Value Type=\"Choice\">未启动</Value>"
+ " </Eq>"
+ " </And>"
+ " </Where>";
SPQuery spq = new SPQuery();
spq.Query = query;
SPListItemCollection items = web.Lists["workflowRecord"].GetItems(spq);
returnCount = items.Count;
}
return returnCount;
}
}
}
(1).copy webservice生成的bin到要部署的sharepoint 网站的虚拟目录bin下
(2).打开layouts目录(layouts地址C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\LAYOUTS),拷贝webservice下的.asmx文件到layouts下
(3).开始--运行,输入cmd,转向layouts目录,运行
1.将WorkflowRemind.disco和WorkflowRemind.wsdl文件中的<?xml version="1.0" encoding="utf-8"?>该语句替换为以下语句:
<%@ Assembly Name="Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %>
<%@ Import Namespace="Microsoft.SharePoint.Utilities" %>
<%@ Import Namespace="Microsoft.SharePoint" %>
<% Response.ContentType = "text/xml"; %>
<soap address="http://moss/_layouts/WorkflowRemind.asmx" xmlns:q1="http://tempuri.org/" binding="q1:WorkflowRemindSoap" xmlns="http://schemas.xmlsoap.org/disco/soap/" />
<soap address="http://moss/_layouts/WorkflowRemind.asmx" xmlns:q2="http://tempuri.org/" binding="q2:WorkflowRemindSoap12" xmlns="http://schemas.xmlsoap.org/disco/soap/" />
<soap address=<% SPHttpUtility.AddQuote(SPHttpUtility.HtmlEncode(SPWeb.OriginalBaseUrl(Request)),Response.Output); %> xmlns:q1="http://tempuri.org/" binding="q1:HelloWorld" xmlns="http://schemas.xmlsoap.org/disco/soap/" />
<soap address=<% SPHttpUtility.AddQuote(SPHttpUtility.HtmlEncode(SPWeb.OriginalBaseUrl(Request)),Response.Output); %> xmlns:q2="http://tempuri.org/" binding="q2:ServiceSoap12" xmlns="http://schemas.xmlsoap.org/disco/soap/" />
3.将WorkflowRemind.wsdl中的
<soap:address location="http://moss/_layouts/WorkflowRemind.asmx" />和
<soap:address location=<% SPHttpUtility.AddQuote(SPHttpUtility.HtmlEncode(SPWeb.OriginalBaseUrl(Request)),Response.Output); %> />
和
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Net;
namespace WindowsForms
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void Form1_Load(object sender, EventArgs e)
{
string UserName = "gaoyan";
string Password = "111111";
string Domain ="gsmn.com";
string SiteUrl = "http://moss";
moss.WorkflowRemind remind = new moss.WorkflowRemind();
remind.Credentials = new NetworkCredential(UserName, Password, Domain);
int wfCount = remind.getWorkflowApproveCount(UserName,Password, Domain, SiteUrl);
label2.Text = wfCount.ToString();
}
}
}