调用DominoAPI连接LOTUS Domino的类代码,CSharp代码库,德仔网

代码语言

代码分类

【CSharp】调用DominoAPI连接LOTUS Domino的类

作者:dezai / 发布于2013/12/27/ 506

using System;
using System.Data;

namespace LotusDbLink
{
 public class LotusDB
 {
 private string _userName;
 private string _password;
 private string _server;
 private string _databaseName;
 private string _lotusView;

 private string _fieldSet;


 public string UserName
 {
 get { return _userName; }
 set { _userName = value; }
 }

 public string Password
 {
 get { return _password; }
 set { _password = value; }
 }

 public string Server
 {
 get { return _server; }
 set { _server = value; }
 }

 public string DatabaseName
 {
 get { return _databaseName; }
 set { _databaseName = value; }
 }

 public string LotusView
 {
 get { return _lotusView; }
 set { _lotusView = value; }
 }

 public string FieldSet
 {
 get { return _fieldSet; }
 set { _fieldSet = value; }
 }


 public DataTable GetDataTable()
 {
 DataTable dataTable = new DataTable(_lotusView);
Domino.NotesSession s = newDomino.NotesSession();

 s.InitializeUsingNotesUserName(_userName, _password);
Domino.NotesDatabase db;
Domino.NotesView vw;
Domino.NotesDocument doc;
 db = s.GetDatabase(_server, _databaseName, false);
 if (db != null)
 {
 vw = db.GetView(_lotusView);
 doc = vw.GetFirstDocument();
 string[] FieldSetTemp = FieldSet.Split(',');
 for (int i = 0; i < FieldSetTemp.Length; i++)
 {
 DataColumn dc = new DataColumn(FieldSetTemp[i], Type.GetType("System.String"));
 dataTable.Columns.Add(dc);
 }

 while (doc != null)
 {
 DataRow dr = dataTable.NewRow();
 for (int i = 0; i < FieldSetTemp.Length; i++)
 {
 dr[FieldSetTemp[i]] = doc.GetFirstItem(FieldSetTemp[i]).Text;
 }
 dataTable.Rows.Add(dr);
 doc = vw.GetNextDocument(doc);
 }
 }

 return dataTable;
 }

 public DataTable GetDataTable(int index, int count)
 {
 DataTable dataTable = new DataTable(_lotusView);
Domino.NotesSession s = newDomino.NotesSession();

 s.InitializeUsingNotesUserName(_userName, _password);
Domino.NotesDatabase db;
Domino.NotesView vw;
Domino.NotesDocument doc;
 db = s.GetDatabase(_server, _databaseName, false);
 if (db != null)
 {
 vw = db.GetView(_lotusView);
 doc = vw.GetFirstDocument();
 string[] FieldSetTemp = FieldSet.Split(',');
 for (int i = 0; i < FieldSetTemp.Length; i++)
 {
 DataColumn dc = new DataColumn(FieldSetTemp[i], Type.GetType("System.String"));
 dataTable.Columns.Add(dc);
 }

 int c = 0;
 while (doc != null)
 {
 if (c < index)
 {
 doc = vw.GetNextDocument(doc);
 continue;
 }
 DataRow dr = dataTable.NewRow();
 for (int i = 0; i < FieldSet.Length; i++)
 {
 dr[FieldSetTemp[i]] = doc.GetFirstItem(FieldSetTemp[i]).Text;
 }
 dataTable.Rows.Add(dr);
 doc = vw.GetNextDocument(doc);
 c++;
 if (c > count) break;
 }
 }

 return dataTable;
 }

 }
}

使用方法（实例为WebService中的方法）

 [WebMethod(Description = "获取视图的方法，返回一个DataTable结构，以下为各参数说明：username = 用户名password = 密码databasename = 文档库名lotusview = 视图名fieldset = 视图字段（用','分割）")]
 public System.Data.DataTable GetLotusTable(string username, string password, string server, string databasename, string lotusview, string fieldset)
 {
 LotusDbLink.LotusDB ldb = new LotusDbLink.LotusDB();
 ldb.UserName = username;
 ldb.Password = password;
 ldb.Server = server;
 ldb.DatabaseName = databasename;
 ldb.LotusView = lotusview;
 ldb.FieldSet = fieldset;
 return ldb.GetDataTable();
 }

 [WebMethod(Description = "获取视图前N项的方法，返回一个DataTable结构，以下为各参数说明：username = 用户名password = 密码databasename = 文档库名lotusview = 视图名fieldset = 视图字段（用','分割）index = 开始索引count = 前N项")]
 public System.Data.DataTable GetLotusTableCount(string username, string password, string server, string databasename, string lotusview, string fieldset, int index, int count)
 {
 LotusDbLink.LotusDB ldb = new LotusDbLink.LotusDB();
 ldb.UserName = username;
 ldb.Password = password;
 ldb.Server = server;
 ldb.DatabaseName = databasename;
 ldb.LotusView = lotusview;
 ldb.FieldSet = fieldset;
 return ldb.GetDataTable(index, count);
 }

评论列表

本站所提供的代码，版权归原作者所有，若有侵犯作者版权，请与我们联系，我们将立即删除或修改。谢谢!
本站所有代码发布及提供者。

试试其它关键字

　DominoAPI　

同语言下

可能有用的

dezai贡献的其它代码(1065)