sharepoint 列表的基本操作

最新推荐文章于 2023-02-22 21:41:00 发布

曹振华

最新推荐文章于 2023-02-22 21:41:00 发布

阅读量1.3k

点赞数

分类专栏： sharepoint 文章标签： sharepoint server asp textbox string exception

本文链接：https://blog.csdn.net/chadcao/article/details/5987859

版权

sharepoint 专栏收录该内容

19 篇文章 0 订阅

订阅专栏

moss 列表的基本操作，以下是对列表中字段的数据进行简单的添、删、改、查。

1)前台代码如下:

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="ListOperate._Default" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

</form>
</body>
</html>

2)后台代码如下：

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using Microsoft.SharePoint;
using System.Data;

namespace ListOperate
{
    public partial class _Default : System.Web.UI.Page
    {
        string url = "http://ds01:6020/";
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                BindListStudent();//绑定student列表
                BindListSchool(dropSchool); //绑定school列表
                BindListSchool(dropUpdateSchool);//绑定school列表
            }
        }
        protected void btnAdd_Click(object sender, EventArgs e)
        {
            string id = txtId.Text.Trim();//学号
            string name = txtName.Text.Trim();//姓名
            int schoolId = Convert.ToInt32(dropSchool.SelectedValue);//学校编号
            AddStudent(id, name, schoolId);//添加学生
        }
        protected void btnUpdate_Click(object sender, EventArgs e)
        {
            int ID = Convert.ToInt32(lblID.Text);//标示
            string id = txtUpdateId.Text.Trim();//学号
            string name = txtUpdateName.Text.Trim();//姓名
            int schoolId = Convert.ToInt32(dropUpdateSchool.SelectedValue);//学校编号
            UpdateStudent(ID, id, name, schoolId);//修改学生
        }
        protected void rptStudent_ItemCommand(object source, RepeaterCommandEventArgs e)
        {
            if (e.CommandName == "delete")
            {
                int id=Convert .ToInt32(e.CommandArgument.ToString());
                DelStudent(id); //删除学生
                BindListStudent();
            }
            if (e.CommandName == "get")
            {
                int id=Convert .ToInt32(e.CommandArgument.ToString());
                SPListItem sPListItem = GetStudentByID(id);
                lblID.Text=sPListItem.ID.ToString();
                txtUpdateId.Text = sPListItem["Title"].ToString();
                txtUpdateName.Text = sPListItem["Name"].ToString();
                dropUpdateSchool.SelectedValue = sPListItem["School"].ToString().Split(';')[0];
            }
        }
        //根据ID获取学生信息
        private SPListItem GetStudentByID(int id)
        {
            SPListItem sPListItem = null;
            using (SPWeb sPWeb = new SPSite(url).OpenWeb())
            {
                //SPQuery query = new SPQuery();
                //query.Query = "<Where>" +
                //                        "<Eq>" +
                //                            "<FieldRef Name='ID'/>" +
                //                            "<Value Type='Counter'>" + id + "</Value>" +
                //                        "</Eq>" +
                //                      "</Where>";
                SPList sPList = sPWeb.Lists["Student"];
                //sPListItem = sPList.GetItems(query)[0];
                sPListItem = sPList.GetItemById(id);
            }
            return sPListItem;
        }
        //删除学生
        private void DelStudent(int id)
        {
            using (SPWeb sPWeb = new SPSite(url).OpenWeb())
            {
                sPWeb.AllowUnsafeUpdates = true;
                SPList sPList = sPWeb.Lists["Student"];
                try
                {
                    sPList.Items.DeleteItemById(id);
                }
                catch (Exception ex)
                {
                    lblMessage.Text = ex.ToString();
                }
            }
        }
        //添加学生
        private void AddStudent(string id,string name,int schoolId)
        {
            using (SPWeb sPWeb = new SPSite(url).OpenWeb())
            {
                sPWeb.AllowUnsafeUpdates = true;
                SPList sPList = sPWeb.Lists["Student"];
                SPListItem sPListItem = sPList.Items.Add();
                sPListItem["Title"] = id;
                sPListItem["Name"] = name;
                sPListItem["School"] = schoolId;
                try
                {
                    sPListItem.Update();
                }
                catch (Exception ex)
                {
                    lblMessage.Text = ex.ToString();
                }
            }
            BindListStudent();
        }
        //修改学生
        private void UpdateStudent(int ID, string id, string name, int schoolId)
        {
            using (SPWeb sPWeb = new SPSite(url).OpenWeb())
            {
                sPWeb.AllowUnsafeUpdates = true;
                SPList sPList = sPWeb.Lists["Student"];
                SPListItem sPListItem = sPList.GetItemById(ID);
                sPListItem["Title"] = id;
                sPListItem["Name"] = name;
                sPListItem["School"] = schoolId;
                try
                {
                    sPListItem.Update();
                }
                catch (Exception ex)
                {
                    lblMessage.Text = ex.ToString();
                }
            }
            BindListStudent();
        }
        //绑定school列表
        private void BindListSchool(DropDownList dropItem)
        {
            dropItem.DataSource = GetListSchool();
            dropItem.DataTextField = "Title";
            dropItem.DataValueField = "ID";
            dropItem.DataBind();
        }
        //获取school列表
        private DataTable GetListSchool()
        {
            DataTable dtSchool = null;
            using (SPWeb sPWeb = new SPSite(url).OpenWeb())
            {
                SPList sPList = sPWeb.Lists["School"];
                dtSchool = sPList.Items.GetDataTable();
            }
            return dtSchool;
        }
        //绑定student列表
        private void BindListStudent()
        {
            rptStudent.DataSource = GetListStudent();
            rptStudent.DataBind();
        }
        //获取student列表
        private DataTable GetListStudent()
        {
            DataTable dtSudent = null;
            using (SPWeb sPWeb = new SPSite(url).OpenWeb())
            {
                SPList sPList = sPWeb.Lists["Student"];
               dtSudent = sPList.Items.GetDataTable();
            }
            return dtSudent;
        }