HelloHongfu

CRM2011 linq 查询

摘要： // *****************************************************************************************************************// LNQ Retrieving related entity columns (for 1 to N relationships)// *****************************************************************************************************************S 阅读全文

posted @ 2011-05-13 17:48 HelloHongfu 阅读(181) 评论(0) 推荐(0) 编辑

JS 得到 URL的各个部分

摘要：设置或获取对象指定的文件名或路径。<script>alert(window.location.pathname)</script> 设置或获取整个 URL 为字符串。<script> alert(window.location.href);</script>设置或获取与 URL 关联的端口号码。<script>alert(window.location.port)</script> 设置或获取 URL 的协议部分。<script>alert(window.location.protocol)</scrip 阅读全文

posted @ 2011-04-25 17:47 HelloHongfu 阅读(246) 评论(0) 推荐(0) 编辑

CRM 2011 设置LookUp属性

摘要： Please put this in the onload event of the CRM Form. document.getElementById("parentcustomerid").setAttribute("lookuptypes", "1"); it is also an unsupported way. 阅读全文

posted @ 2011-04-25 09:44 HelloHongfu 阅读(189) 评论(0) 推荐(0) 编辑

SQL脚本备件

摘要： SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOALTER Proc [dbo].[P_Sohu_ExportProc] ( @Filter nvarchar(200) =null/**//*查询条件例如 where 1=1 */ ) /**//* Create By 王红福备份存储过程，函数，触发器等，可直接运行 */ As Begin if @Filter is null Set @Filter = '' Declare @Text varchar(8000), @Name nvarchar(100), @XType nvarc 阅读全文

posted @ 2011-04-18 14:00 HelloHongfu 阅读(178) 评论(0) 推荐(0) 编辑

CRM4.0读取附件文本文件

摘要： string sql = "select top 1 Documentbody from Annotation where ObjectId like '%" + thePrintTempalteGuid.ToString() + "%' and MimeType like '%htm%' order by CreatedOn desc"; DataTable theAnnotation = new BaseSql().ExecuteReturnDataTable(sql); if (theAnnotation.R... 阅读全文

posted @ 2011-04-13 17:02 HelloHongfu 阅读(352) 评论(0) 推荐(0) 编辑

触发器记录日志变更

摘要： USE [MSCRM_MSCRM]GO/****** Object: Trigger [dbo].[T_Sohu_Update_New_personaltaskExtensionBase] Script Date: 03/24/2011 20:26:43 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO-- =============================================-- Author: Jeff-- Create date: 2011.03.24-- Description: 更新销售任务(个人)时插入变更阅读全文

posted @ 2011-03-28 14:46 HelloHongfu 阅读(536) 评论(0) 推荐(0) 编辑

JavaScript读取URL参数代码

摘要： function request(paras) { var url = location.href; var paraString = url.substring(url.indexOf("?") + 1, url.length).split("&"); var paraObj = {} for (i = 0; j = paraString[i]; i++) { paraObj[j.substring(0, j.indexOf("=")).toLowerCase()] = j.substring(j.indexOf(& 阅读全文

posted @ 2011-02-12 18:16 HelloHongfu 阅读(268) 评论(0) 推荐(0) 编辑

CRM 表单上隐藏相关实体的按纽行

摘要： //隐藏整个按钮行HideAssociatedViewButtonsBar = function(loadAreaId){ var navElement = document.getElementById('nav_' + loadAreaId); if (navElement != null) { navElement.onclick = function() { loadArea(loadAreaId); HideViewButtonsBar(document.getElementById(loadAreaId + 'Frame')); } 阅读全文

posted @ 2011-02-11 17:24 HelloHongfu 阅读(252) 评论(0) 推荐(0) 编辑

CRM 根据属性获取相应类型的值

摘要： /// /// 结束属性类型，并将属性值返回 /// /// /// private string GetPropertyValue(Property property) { try { Type theType ... 阅读全文

posted @ 2011-02-10 10:04 HelloHongfu 阅读(277) 评论(0) 推荐(0) 编辑

针对CRM 多对多开发的的自定义页面在CRM 上调用

摘要： function CustomLookup() { var returnStr = window.showModalDialog("/" + ORG_UNIQUE_NAME + "/ISV/Sohugift/web/AddChildEntities.aspx?theEntity=new_appmkt", "","dialogWidth:1024px;dialogHeight:550px;scroll:no"); if(returnStr==null||returnStr=="cancle" ){return;} var lookupItems=returnStr.split('|') ; if 阅读全文

posted @ 2011-01-29 18:45 HelloHongfu 阅读(334) 评论(0) 推荐(0) 编辑