把sharepoint list转化成DateTable
来源:互联网 发布:小红书真假知乎 编辑:程序博客网 时间:2024/05/17 08:44
/// <summary>
/// 把sharepoint list 转化成DataTable
/// </summary>
/// <returns></returns>
private DataTable ListToDataTable()
{
//构造表头
DataTable _sourceDataTable;
_sourceDataTable = this.ColumnNameDataTable();
//SPList sourceList = pSourceSPWeb.Lists[this._sourceSPListName];
//SPListItemCollection caseItems = sourceList.Items;
SPSite site = new SPSite(siteurl);
SPWeb web = site.OpenWeb();
SPList treeList = web.Lists[sourceTreeList];
DataTable dt = new DataTable();
SPListItemCollection caseItems = treeList.Items;
foreach (SPListItem caseItem in caseItems)
{
try
{
DataRow rowNew = _sourceDataTable.NewRow();
for (int intI = 0; intI < this.pSourceSPListFields.Length; intI++)
{
if (caseItem[pSourceSPListFields[intI]] != null)
{
if (treeList.Fields[this.pSourceSPListFields[intI]].FieldValueType.ToString() == "Microsoft.SharePoint.SPFieldUserValue")
{
string createrUserName = caseItem[this.pSourceSPListFields[intI]].ToString();
int index = createrUserName.IndexOf(';');
int createrUserID = Convert.ToInt32(createrUserName.Substring(0, index));
SPUser createrUser = web.AllUsers.GetByID(createrUserID);
rowNew[pSourceSPListFields[intI]] = createrUser.Name;
}
else
{
Object columnType = _sourceDataTable.Columns[this.pSourceSPListFields[intI]].DataType;
rowNew[pSourceSPListFields[intI]] = caseItem[pSourceSPListFields[intI]];
}
}
}
_sourceDataTable.Rows.Add(rowNew);
}
catch
{
}
}
return _sourceDataTable;
}
/// <summary>
/// 根据sharepoint列表创建DataTable字段
/// </summary>
/// <returns></returns>
public DataTable ColumnNameDataTable()
{
SPSite site = new SPSite(siteurl);
SPWeb web = site.OpenWeb();
SPList treeList = web.Lists[sourceTreeList];
DataTable dt = new DataTable();
SPListItemCollection caseItems = treeList.Items;
for (int intI = 0; intI < pSourceSPListFields.Length; intI++)
{
DataColumn columnNew = new DataColumn();
columnNew.ColumnName = pSourceSPListFields[intI];
dt.Columns.Add(columnNew);
}
return dt;
}
- 把sharepoint list转化成DateTable
- 把java数组转化成List
- 把LIST转化成数组
- DateTable转换为List泛型
- fastJSON把json转化成map,并转化成list,list如何装化为数组
- java把实体对象转化成list和map
- 利用Gson把json转化成Java List异常问题
- C#把list转化为Datatable
- C#把list转化为Datatable
- 如何从Excel中把数据导入到SharePoint List(Import Excel data to SharePoint List)
- 如何从Excel中把数据导入到SharePoint List(Import Excel data to SharePoint List)
- 实体类转换成DateTable,
- datable转化成list
- 把list数据转化成easy ui树标签能够识别的json字符串
- c# 将实体类集合转化为datetable格式案例
- Import CSV into Sharepoint List 把csv导入到sharepoint列表
- 把仇人转化成恩人
- 把人民币转化成大写
- nginx源码分析(18)-基础设施(1)
- 挥挥手,告别越狱,告别期待越狱的日子
- 如何优化网站关键字?
- ERROR LNK2005
- Java常见面试题集- -
- 把sharepoint list转化成DateTable
- 运行在easyboot下的IMG文件的制作方法
- 常见邮件发送失败原因分析以及解决方法
- C语言编译过程详解
- 主流邮箱可靠性测试
- 如何修改Windows特殊文件夹的路径/修改Windows桌面的路径/修改我的文档路
- haowenzhang
- 手机隐藏功能
- JDBC连接Oracle数据库之十大技巧(转载的,不是自己写的!)