首页 > 代码库 > sharepoint Linq方式的增，删，查，改

sharepoint Linq方式的增，删，查，改

2024-07-15 02:47:18   220人阅读

 

Site9527EntitiesDataContext （重要的类）：连接实体与网站List操作
SPContext.Current.Web.Url：获取当前操作的页面
FirstOrDefault：使用时一定要先引用(Using System.Linq;)
dataContext.SubmitChanges():确保数据更新到List中。


增

  protected void bt_SaveClic(object sender, EventArgs e)       {           using (Site9527EntitiesDataContext dataContext = new Site9527EntitiesDataContext(SPContext.Current.Web.Url))           {               UserInfoItem user = new UserInfoItem();               user.Title = this.tx_Title.Text;               user .UserName = this .tx_UserName.Text;               user.Gender = this.tx_Gender.Text;               user.Adress =this. tx_adress.Text;               dataContext.UserInfo.InsertOnSumbit(user);               dataContext.SubmitChangers();           }           base.Response.Redirect("UserInfoList.aspx");       }

删

  protected void bt_DeleteClick(object sender, EventArgs e)        {            using (Site9527EntitiesDataContext dataContext = new Site9527EntitiesDataContext(SPContext.Current.Web.Url))            {                UserInfoItem user = null;                user = dataContext.UserInfo.FirstOrDefault(i => i.Id ==Convert.ToInt32(tx_Del.Text));                dataContext.UserInfo.DeleteOnSubmit(user);                dataContext.SubmitChanges();            }            tx_Del.Text = "";            bt_SelectClick(sender, e);        }

查

  public void bt_SelectClick(object sender, EventArgs e)        {            StringBuilder html = new StringBuilder();            IQueryable<UserInfoItem> userList=null;            if (!string.IsNullOrEmpty(tb_UserName.Text))            {                 using(Site9527EntitiesDataContext dataContext=new Site9527EntitiesDataContext(SPContext.Current.Web.Url))                {                    userList = dataContext.UserInfo.Where(i => i.UserName.Contains(tb_UserName.Text));                 }            }            else            {                using(Site9527EntitiesDataContext dataContext=new Site9527EntitiesDataContext(SPContext.Current.Web.Url))                {                    userList = dataContext.UserInfo;                 }            }                                      foreach (var user in userList)                {                    html.Append("<tr>");                    html.Append("<td>"+user.Title);                    html.Append("</td>");                    html.Append("<td>" + user.UserName);                    html.Append("</td>");                    html.Append("<td>" + user.Gender);                    html.Append("</td>");                    html.Append("<td>" + user.Tell);                    html.Append("</td>");                    html.Append("<td>" + user.Adress);                    html.Append("</td>");                    html.Append("<td>" + user.ApprovalStatue);                    html.Append("</td>");                    html.Append("<td>" + user.ApprovalBy);                    html.Append("</td>");                    html.Append("<td><a  id=‘a_update‘ onclick=‘Update(" + user.Id.ToString() + ")‘>更新</a>  <a  id=‘a_delete‘ onclick=‘Delete(" + user.Id.ToString() + ")‘>删除</a>");                    html.Append("</td>");                    html.Append("</tr>");                }                        td_Html.Text = html.ToString();        }

改

 protected void bt_SaveClic(object sender, EventArgs e)        {            using (Site9527EntitiesDataContext dataContext = new Site9527EntitiesDataContext(SpContext.Current.Web.Url))            {                UserInfoItem user = null;                user = dataContext.UserInfo.FirstOrDefault(i => i.Id == Convert.ToInt32(Request.QueryString["ID"]));                user.Title = this.tx_Title.Text;                user.UserName = this.tx_UserName.Text;                user.Adress = this.tx_adress.Text;                user.Gender = this.tx_Gender.Text;                user.Tell = this.tx_tell.Text;                dataContext.SubmitChanges(user);                                         }            base.Response.Redirent("UserInfoList.aspx");        }

 


联系
我们