sharepoint学习草稿

来源：互联网发布：php权限管理设计编辑：程序博客网时间：2024/05/20 16:34

-9SQL

--移除回车符

update master_location
SET street_number = REPLACE(street_number, CHAR(13), '')

--移除换行符

update master_location
SET street_number = REPLACE(street_number, CHAR(10), '')

-8 急速模式

-7 win8 激活命令

slmgr -upk
slmgr -ipk 48JN7-M6M2J-PKR4Q-3JX3R-TVF92

-8数据库

a.Version=(select MAX(bb.Version) from (select aa.ProjectId,aa.Version from ProjectFileManagement aa where aa.VersionState='发布' and aa.ProjectId=a.ProjectId group by aa.ProjectId,Version) as bb)

-7：window.close干掉提示框

-6：ID pID 加前缀

/// <summary>
        /// 集合转table
        /// </summary>
        /// <param name="modelist"></param>
        /// <returns></returns>
        public void SetDataTable(int parentId, List<Temp> modelist, string profix)
        {
            var result = modelist.Where(x => x.PID == parentId);

            profix += "        ";
            string pf = profix;

            foreach (Temp mode in modelist)
            {
                mode.TaskName = profix + mode.TaskName;
                SetDataTable(mode.TaskID, modelist, profix);
                profix = pf;
            }
        }

-5:HTML获取父页面的dom元素对象

比如在A页面调用了window.open() 打开B页面在B页面需要使用A页面的东西就要使用window.opener.document.getElementById("form_commentlist_div").outerHTML

window.opener就是获取上个的打开页面也就是A页面

常用的地方是用来做打印在B页面输出A页面打印的东西

document.write(window.opener.document.getElementById("form_commentlist_div").outerHTML);

-4：DataTable的Compute方法，用来计算字符串表达式

DataTable dt = new DataTable();

table.Compute("1+1", "false");

输出2

参考资料

http://blog.csdn.net/smartsmile2012/article/details/8309664

https://msdn.microsoft.com/zh-cn/library/system.data.datacolumn.expression(VS.80).aspx

-3，sharepoint登陆界面样式修改在iis 80的login文件下面修改，修改defualt.aspx就好了

-2 搜索“sharepoint去掉我的设置和加上切换”

C:\Program Files\Common Files\microsoft shared\Web Server Extensions\15\TEMPLATE\CONTROLTEMPLATES地址下找到welcome.aspx

<%@ Register Tagprefix="SharePoint" Namespace="Microsoft.SharePoint.WebControls" Assembly="Microsoft.SharePoint, Version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %> <%@ Register Tagprefix="Utilities" Namespace="Microsoft.SharePoint.Utilities" Assembly="Microsoft.SharePoint, Version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %> <%@ Import Namespace="Microsoft.SharePoint" %> <%@ Assembly Name="Microsoft.Web.CommandUI, Version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %><%@ Control Language="C#" Inherits="Microsoft.SharePoint.WebControls.Welcome,Microsoft.SharePoint,Version=15.0.0.0,Culture=neutral,PublicKeyToken=71e9bce111e9429c"   AutoEventWireup="false" compilationMode="Always" %>  <SharePoint:PersonalActions accesskey="<%$Resources:wss,personalactions_menu_ak15%>" ToolTip="<%$Resources:wss,open_menu%>" runat="server" id="ExplicitLogout" MenuAlignment="Right" Visible="false"><CustomTemplate> <SharePoint:FeatureMenuTemplate runat="server" FeatureScope="Site" Location="Microsoft.SharePoint.StandardMenu" GroupId="PersonalActions" id="ID_PersonalActionMenu" UseShortId="true" > <SharePoint:MenuItemTemplate runat="server" id="ID_RequestAccess" Text="<%$Resources:wss,personalactions_requestaccess%>" Description="<%$Resources:wss,personalactions_requestaccessdescription%>" MenuGroupId="100" UseShortId="true" Sequence="300" /> <SharePoint:MenuItemTemplate runat="server" id="ID_Logout" Text="<%$Resources:wss,personalactions_logout%>" Description="<%$Resources:wss,personalactions_logoutdescription%>" MenuGroupId="100" Sequence="400" UseShortId="true" /> <SharePoint:MenuItemTemplate runat="server" id="ID_SwitchView" MenuGroupId="200" Sequence="200" UseShortId="true" /> <SharePoint:MenuItemTemplate runat="server" id="MSOMenu_RestoreDefaults" Text="<%$Resources:wss,personalactions_restorepagedefaults%>" Description="<%$Resources:wss,personalactions_restorepagedefaultsdescription%>" ClientOnClickNavigateUrl="javascript:SP.SOD.execute('browserScript', 'MSOWebPartPage_RestorePageDefault')" MenuGroupId="200" Sequence="300" UseShortId="true" />               <SharePoint:MenuItemTemplate runat="server" ID="ID_LoginAsDifferentUser" Text="<%$Resources:wss,personalactions_loginasdifferentuser%>" Description="<%$Resources:wss,personalactions_loginasdifferentuserdescription%>" MenuGroupId="100" Sequence="100" UseShortId="true"/> </SharePoint:FeatureMenuTemplate></CustomTemplate></SharePoint:PersonalActions><SharePoint:ApplicationPageLink runat="server" id="ExplicitLogin"ApplicationPageFileName="Authenticate.aspx" AppendCurrentPageUrl=trueText="<%$Resources:wss,login_pagetitle%>" style="display:none" Visible="false" />

-1：强命名错误

http://blog.csdn.net/qq873113580/article/details/13408067

0 sharepoint导入project文件

http://blog.csdn.net/qq873113580/article/details/42915759

1、安装配置

http://www.veryhuo.com/a/view/57916.html

sharepoint 2012安装步骤说明文档

http://download.csdn.net/detail/qq873113580/7071043

2、多列表查询

http://www.cnblogs.com/jinho/archive/2011/03/15/1985448.html

3、CAML查询语法

http://www.cnblogs.com/OceanEyes/archive/2013/09/01/sharepoint-caml-in-action-2.html

http://blog.csdn.net/hotnet522/article/details/6862211

http://wenku.baidu.com/view/6932cb1659eef8c75fbfb359.html

4、sharepoint 分页

http://blog.csdn.net/qq873113580/article/details/21017833

5、sharepoint 操作人类型,人类型控件的使用

http://blog.csdn.net/qq873113580/article/details/21123777

6、使用UpdatePanle的时候里面控件事件失效

http://blog.csdn.net/qq873113580/article/details/21168875

7、模式化窗体

http://blog.csdn.net/qq873113580/article/details/21169753

8、sharepoint配置错误页面

http://blog.csdn.net/qq873113580/article/details/21243667

9、TimeJob

http://blog.csdn.net/qq873113580/article/details/22300645

10,值不在预期范围内，代码提权

http://blog.csdn.net/qq873113580/article/details/22589461

11、代码创建列表

http://blog.csdn.net/qq873113580/article/details/22668833

12、另类Ajax

http://blog.csdn.net/qq873113580/article/details/22675845

13,使用应用程序模板页的时候可能会出现多余的投只需要设置应用为custom.master 然后再页面后面加参数&IsDlg=1

14,使用Excel导出的之后解决页面假死，在PageLoad里面加上这些代码

protected void Page_Load(object sender, EventArgs e)
        {
            string script = "_spOriginalFormAction = document.forms[0].action;\n_spSuppressFormOnSubmitWrapper = true;";
            this.ClientScript.RegisterClientScriptBlock(this.GetType(), "script", script, true);

        }

15,自定义JS消息弹出框

http://blog.csdn.net/qq873113580/article/details/23948595

16,Excel导出

http://blog.csdn.net/qq873113580/article/details/24426061

17上传文件

http://blog.csdn.net/qq873113580/article/details/24714011

18上传文件到文档库

http://blog.csdn.net/qq873113580/article/details/25297145

19Net导出文本

http://blog.csdn.net/qq873113580/article/details/26473387

20,屏蔽右键

document.oncontextmenu = function(e) {
    if ( e && e.button == 2 && e.preventDefault )
        e.preventDefault();
    else
        window.event.returnValue = false;
}

21,域账户显示在线状态

<img style="border: 0px;" width="12" height="12" src="/_layouts/images/blank.gif"
id="img_1" onload='IMNRC("xxxxxxx@xxxxx")' alt="Presence bubble">xxxx

22,字符串转JSON

globalData.Rows = eval('(' + data + ')');

23,sharepoint数据类型转换

http://blog.csdn.net/qq873113580/article/details/27659339

24解决部署不了的问题

卸载 stsadm -o uninstallfeature -id a564ac30-8357-4dc2-94e9-4a21fd2f43ee -force

Get-SPTimerJob | Where {$_.Title -eq "PlanWarn Timer Job"} | ft id,name

删除 stsadm.exe -o deleteconfigurationobject -id a564ac30-8357-4dc2-94e9-4a21fd2f43ee

MVC 分离控制器

http://www.cnblogs.com/naoguazi/p/MVC_View_Controller.html

Session存数据库中

http://www.cnblogs.com/withoutaword/archive/2013/01/08/2851157.html

Net Cookie用法

写入

                    //写入cookie 创建带有子键的cookie
                    HttpCookie userCookie = new HttpCookie("User");
                    //Md5加密
                    userCookie.Values["Mobile"] = MD5Helper.GetCookiePhoneEncrypt(phoneNum);
                    userCookie.Expires = DateTime.Now.AddMonths(2);
                    Response.Cookies.Add(userCookie);

读取

Request.Cookies["User"]["Mobile"].ToString()

C#内存映射读取大文件

http://www.cnblogs.com/criedshy/archive/2010/06/13/1757826.html

16 0