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

代码语言
代码分类
【CSharp】 C#调用DominoAPI连接LOTUS Domino的类
作者:dezai / 发布于2014/4/16/ 468
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 = new Domino.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 = new Domino.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);
   }
评论列表
本站所提供的代码，版权归原作者所有，若有侵犯作者版权，请与我们联系，我们将立即删除或修改。谢谢!
本站所有代码发布及提供者。
试试其它关键字
　LOTUS　　Domino　
同语言下
可能有用的
dezai贡献的其它代码(1065)