-9SQL
--移除回车符
update master_location
SET street_number = REPLACE(street_number, CHAR(13), '')
--移除换行符
update master_location
SET street_number = REPLACE(street_number, CHAR(10), '')
-8 急速模式
<meta http-equiv="X-UA-Compatible" content="IE=edge" />
-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干掉提示框
function goHome(){
var isIE = navigator.appName == "Microsoft Internet Explorer";
//alert(isIE);
if(isIE){
window.opener = "";
window.open("","_self");
window.close();
}
else{
/*FF 还要在 about:config 允许脚本脚本关闭窗口*/
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=true
Text="<%$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" οnlοad='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