Tonyyang - 博客园

[原] Sql Server 获取某年某月有多少个工作日(仅不包含星期日)

摘要： --獲取某年某月有多少周日（不包含周六）CREATE FUNCTION f_getnums ( @year_month VARCHAR(8) )RETURNS INTAS BEGIN DECLARE @bdt DATETIME , @edt DATETIME , @i INT SET @i = 0 SET @bdt = CAST(@year_month + '-01' AS DATETIME) SET @edt = DATEADD(d, -1, ... 阅读全文

posted @ 2013-01-12 11:50 Tonyyang 阅读(681) 评论(0) 推荐(0)

[原] XAF 如何恢复已删除的记录

摘要： How to restore deleted objects (records)http://www.devexpress.com/Support/Center/ViewKBIssue.aspx?kbid=A753简单的说GCRecord的值不为空为标志删除，如果要恢复删除就需要将其改为空值(Null)即可！阅读全文

posted @ 2012-12-29 15:44 Tonyyang 阅读(590) 评论(0) 推荐(0)

[原] XAF自動綁定分析數據功能

摘要：功能簡單直接上代碼：public partial class ListViewAnalyzViewController : ViewController { public ListViewAnalyzViewController() { InitializeComponent(); RegisterActions(components); TargetViewId = "Analysis_DetailView"; } protected override void OnActivated() { base.OnActivated(); View.ControlsCreate 阅读全文

posted @ 2012-12-27 10:03 Tonyyang 阅读(486) 评论(0) 推荐(0)

[原] XAF 收发信息模块(收到信息会弹出通知)

摘要： 1.源代码：/Files/Tonyyang/XAF Modules/MessageNotifyModules.rar 阅读全文

posted @ 2012-08-28 11:25 Tonyyang 阅读(883) 评论(3) 推荐(1)

Sql Server 问题之between and 使用注意事项

摘要：今天也遇到了下面问题。以后使用Between 都要注意了，最好不用！1.问题：有五条数据如下：2010-12-01 12:16:10.0002010-12-02 13:11:28.0002010-12-03 13:49:15.0002010-12-04 13:52:28.0002010-12-05 13:52:28.000我使用select * from table where [time] between '2010-12-1' and '2010-12-6' 能显示出这五条如果我使用select * from sk_SmsSee where [time] 阅读全文

posted @ 2012-07-04 16:25 Tonyyang 阅读(938) 评论(0) 推荐(0)

[原] XAF 如何使用Top

摘要： 1.代碼如下：publicclassS35430:ViewController<ListView>{protectedoverridevoidOnActivated(){base.OnActivated();CustomizeCollectionSource(View.CollectionSource);View.CollectionSource.CollectionChanged+=newEventHandler(CollectionSource_CollectionChanged);}protectedoverridevoidOnDeactivated(){View.Colle 阅读全文

posted @ 2012-07-04 09:25 Tonyyang 阅读(537) 评论(0) 推荐(0)

[原] XAF 国家-省-县联动实现

摘要： 1.国家-省-县联动实现2.XPO Data ModelDesigner GUI3.代码：/Files/Tonyyang/XAF Samples/CountryProvinceCounty.rar 阅读全文

posted @ 2012-06-15 11:47 Tonyyang 阅读(1041) 评论(0) 推荐(0)

[原] XAF 实现支持多数据库

摘要：方式1.http://www.devexpress.com/Support/Center/p/K18123.aspx 方式2.http://www.expandframework.com/forum/11-news/2495-module-decoupling-from-core-functionality.html#2508 阅读全文

posted @ 2012-06-11 15:58 Tonyyang 阅读(628) 评论(0) 推荐(0)

[原] XAF Try an XAF application that uses the Entity Framework as an ORM layer

摘要： Try an XAF application that uses the Entity Framework as an ORM layer http://www.devexpress.com/Support/Center/Question/Details/KA18571 阅读全文

posted @ 2012-06-07 13:54 Tonyyang 阅读(337) 评论(0) 推荐(0)

[原] XAF DateTime 取服务器端时间

摘要：问题：由于用户可以自行更改客户端电脑时间，造成取DateTime.Now日期时间不准确。解决方案：取服务器端的日期时间。实现方法： Sessionsession=newSession();CriteriaOperatorfuncNow=newFunctionOperator(FunctionOperatorType.Now);DateTimeserverTime=(DateTime)session.Evaluate(typeof(XPObjectType),funcNow,null);Console.WriteLine("Servertime:{0}",serverTime 阅读全文

posted @ 2012-06-01 10:35 Tonyyang 阅读(652) 评论(0) 推荐(0)

XAF 如何从ListView中直接选择数据用Analysis功能分析数据

摘要： How to analyze selected data directly from a view - In place Analysis如何从ListView中直接选择数据用Analysis功能分析数据http://www.devexpress.com/Support/Center/p/E964.aspx 阅读全文

posted @ 2012-04-21 10:42 Tonyyang 阅读(448) 评论(0) 推荐(0)

XAF Study Recources

摘要： dennisgaravsky.blogspot.hk 阅读全文

posted @ 2012-03-06 11:05 Tonyyang 阅读(354) 评论(0) 推荐(0)

XAF Delta Replication Module for Devexpress eXpressApp Framework

摘要： Delta Replication Module for Devexpress eXpressApp Framework一个实现了异步复制XAF模块为分布式XAF应用程序。http://xafdelta.narod.ru/http://xafdelta.codeplex.com/https://www.youtube.com/user/xafdeltaXafDelta 功能特点:•Provides a system of asynchronous heterogeneous replication for WinForms and ASP.NET XAF applications. Suppo 阅读全文

posted @ 2012-01-09 13:30 Tonyyang 阅读(676) 评论(0) 推荐(0)

BDD 入门

摘要：使用 SpecFlow 和 WatiN 进行行为驱动开发 Brandon Satrom http://msdn.microsoft.com/zh-cn/magazine/gg490346.aspx下载示例代码随着自动化单元测试在软件开发中变得越来越普遍，对各种“测试优先”方法的采用也呈现出相同的趋势。这些实践为开发团队既带来了难得的机遇，也带来了独特的挑战，但所有这些机遇和挑战都是为了帮助从业人员建立“根据设计进行测试”的思路。但是在“测试优先”时代的大多数时间，用于表达用户行为的方法一直贯穿于使用系统语言（一种与用户的语言不相关的语言）编写的单元测试。随着行为驱动开发 (BDD) 技阅读全文

posted @ 2012-01-04 09:12 Tonyyang 阅读(2215) 评论(0) 推荐(0)

XAF 用户双击ListView记录时禁止显示DetailView

摘要： How to prevent a DetailView from being shown when a User double clicks or presses the Enter key on a record in a ListView http://www.devexpress.com/Support/Center/kb/p/K18038.aspx 阅读全文

posted @ 2011-12-24 09:36 Tonyyang 阅读(619) 评论(0) 推荐(0)

XAF Using Domain Components (DC) in XAF (DevExpress): Part I: The Basics

摘要： XAF Using Domain Components (DC) in XAF (DevExpress): Part I: The Basicshttp://www.codeproject.com/KB/ThirdParty/DomainComponentsInXAF_1.aspx相关XAF资源：http://conchcoderepublic.com/Screencasts/eXpandScreencasts.aspxhttp://www.distel.nl/index.php/en/xafexperts-uk/whatxaf-ukhttp://www.expressapp.ru/viewf 阅读全文

posted @ 2011-12-07 13:50 Tonyyang 阅读(414) 评论(0) 推荐(0)

[原] XAF 一个字段的值改变则另一个字段值也改变的实现

摘要：方法一：protectedoverridevoidOnChanged(stringpropertyName,objectoldValue,objectnewValue){base.OnChanged(propertyName,oldValue,newValue);if((!IsLoading)&&(!IsDeleted)&&(oldValue!=newValue)){if(propertyName=="ItemA"){//todo}}}方法二：publicpartialclassMyViewController:ViewController{ 阅读全文

posted @ 2011-12-07 11:57 Tonyyang 阅读(827) 评论(0) 推荐(0)

[原] XAF 11.2权限扩展之角色按钮权限控制

摘要：扩展XAF 11.2权限之按钮权限控制1. 需求：XAF系统本身已经带了比较好用权限管理：Object-Level,Class-Level,Member-Level；但是没有对自定义按钮按角色分配的权限控制，因此需实现对自定义按钮的角色权限控制2. 控制方式：角色按钮控制(角色、按钮多对多关系)3. 系统权限类型为SecurityStrategyComplex, AuthenticationStandard(需选择自定义的MySecurityUser和MySecurityRole)4. 需要区分自定义按钮和XAF系统本身自带按钮5. 此按钮权限控制不控制XAF系统自带按钮，也可以通过简单修. 阅读全文

posted @ 2011-12-06 15:48 Tonyyang 阅读(1666) 评论(8) 推荐(2)

XAF How to enable LayoutView mode in the GridControl in List Views

摘要： http://www.devexpress.com/Support/Center/p/E1486.aspxIMPORTANT NOTES1. The LayoutViewListEditor class implemented in this example is not a complete solution, but rather a starting point for creating a custom List Editor based on the XtraGrid's LayoutView and providing similar features as a stand 阅读全文

posted @ 2011-11-24 08:52 Tonyyang 阅读(552) 评论(0) 推荐(0)

Access 报表打印之分组页码实现(轉)

摘要： /Files/Tonyyang/报表分组页码V1.2.rarOptionCompareDatabaseOptionExplicit'^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^'分组报表显示分组页码和页数类模块(方法一)''功能:在有分组的报表的每一页上显示组页码和组页数，在预'览时改变页面设置后仍能正确显示。'作者:t小雨(tcl013@126.com)(t小宝)'版本:1.1'创建日期:2008-05-??'整理日期:20 阅读全文

posted @ 2011-11-21 10:43 Tonyyang 阅读(1623) 评论(0) 推荐(0)

XAF Store Model Differences in Database Using Complex Security

摘要： http://www.devexpress.com/Support/Center/p/Q341530.aspxhttp://www.devexpress.com/Support/Center/p/S38032.aspx系統管理工具：管理用戶UI設置，匯入、匯出、復位。http://www.devexpress.com/example=E968結合下面代碼一起使用效果更佳。publicclassImportExportUserDifferencesController:WindowController{privateSimpleActionexportDifferencesAction;priv 阅读全文

posted @ 2011-10-21 11:39 Tonyyang 阅读(530) 评论(0) 推荐(0)

XAF How to set size of a popup detail view

摘要： How to set size of a popup detail viewhttp://community.devexpress.com/forums/p/105313/356765.aspx#356765privatevoidApplication_CustomizeTemplate(objectsender,CustomizeTemplateEventArgse){this.Application.CustomizeTemplate-=this.Application_CustomizeTemplate;(e.TemplateasForm).Size=newSize(440,260);} 阅读全文

posted @ 2011-10-17 11:40 Tonyyang 阅读(490) 评论(0) 推荐(0)

XAF How to: Show a New Object Detail View via the Navigation Control

摘要： http://documentation.devexpress.com/#Xaf/CustomDocument2920 阅读全文

posted @ 2011-08-30 08:03 Tonyyang 阅读(517) 评论(0) 推荐(0)

XAF 顯示 UnInplace Report(設置自定義條件顯示報表，不是根據選擇ListView記錄條件顯示報表)

摘要： usingSystem;usingSystem.Collections.Generic;usingSystem.Text;usingDevExpress.ExpressApp;usingDevExpress.ExpressApp.Actions;usingDevExpress.ExpressApp.Reports;usingDevExpress.Data.Filtering;usingSystem.Collections;usingDevExpress.Persistent.Base;usingDevExpress.Utils;usingDevExpress.ExpressApp.Utils; 阅读全文

posted @ 2011-08-24 17:24 Tonyyang 阅读(706) 评论(0) 推荐(0)

打开网页全屏显示

摘要：打开网页全屏显示 2010-06-09 11:19（1）打开全屏窗口方法如下：一：将下面的代码放在<HEAD>与</HEAD>之间 <script language="JavaScript"> <!-- function call(htmlurl) { var newwin=window.open(htmlurl,"airWin","top=0,left=0,toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=y 阅读全文

posted @ 2011-08-08 16:19 Tonyyang 阅读(2406) 评论(1) 推荐(1)

c#中的DateTime(显示出各种事件，本周，本月，本年，本周第一天...)

摘要：大家在做报表或查询的时候都会有给用户预设一些可选的日期范围//如本年度销售额、本季度利润、本月新增客户//C#里内置的DateTime基本上都可以实现这些功能，巧用DateTime会使你处理这些事来变轻松多了//今天DateTime.Now.Date.ToShortDateString();//昨天，就是今天的日期减一DateTime.Now.AddDays(-1).ToShortDateString();//明天，同理，加一DateTime.Now.AddDays(1).ToShortDateString();//本周(要知道本周的第一天就得先知道今天是星期几，从而得知本周的第一天就是几天前阅读全文

posted @ 2011-07-26 17:14 Tonyyang 阅读(675) 评论(0) 推荐(0)

XAF 如何自定义PivotGrid单元格显示文本？

摘要：参考资料：http://www.devexpress.com/Support/Center/p/Q326025.aspxusingSystem;usingSystem.Collections.Generic;usingDevExpress.ExpressApp;usingDevExpress.XtraPivotGrid;usingDevExpress.ExpressApp.PivotGrid.Win;usingDevExpress.ExpressApp.Model;namespaceDXExample.Module{publicclassQ326025Controller:ViewContro 阅读全文

posted @ 2011-07-24 09:53 Tonyyang 阅读(932) 评论(0) 推荐(0)

XAF 模块Inventive XafAddOn Module介绍

摘要： 1.主要包括保存查询条件和几个属性编辑(WinPropertyEditor_DropdownPickList, WinPropertyEditor_CheckedComboBox, WinPropertyEditor_RadioButtonInteger)2.更新到XAF v10.2.6 SourceCode:/Files/Tonyyang/XAF Modules/Inventive.XafAddOn.rar http://www.inventivesoftware.net/Products/DeveloperTools.aspx3.效果阅读全文

posted @ 2011-06-16 11:39 Tonyyang 阅读(512) 评论(0) 推荐(0)

UP V2

摘要： usingSystem;usingSystem.Collections.Generic;usingSystem.Linq;usingSystem.ComponentModel;usingDevExpress.ExpressApp;usingDevExpress.ExpressApp.Win.Editors;usingDevExpress.ExpressApp.Model;usingDevExpress.XtraEditors;usingSystem.Reflection;usingDevExpress.XtraEditors.Controls;publicclassWinCustomDataS 阅读全文

posted @ 2011-05-24 15:27 Tonyyang 阅读(448) 评论(0) 推荐(0)

XAF 字符串属性ComboBox的数据源DataSourcePropertyAttribute提供动态选择的键和值

摘要： privatestring_ActionId;[DataSourceProperty("list")][Custom("PropertyEditorType","MemberLevelSecurityDemo.Module.WinStringArrayValueComboPropertyEditor")]publicstringActionId{get{return_ActionId;}set{SetPropertyValue("ActionId",ref_ActionId,value);}}publicList& 阅读全文

posted @ 2011-05-22 16:29 Tonyyang 阅读(649) 评论(0) 推荐(0)

XAF 字段级权限扩展-根据对象选择属性

摘要：需要参考：http://www.cnblogs.com/Tonyyang/archive/2011/05/21/2052627.html//DeveloperExpressCodeCentralExample://HowtoimplementtheMemberLevelsecuritymanually(forexample,todenythe'Read'accessfordeclaredpropertiesofsomebusinessclass,andallowaccessfortheinheritedproperties)////Hello,////Thissampledem 阅读全文

posted @ 2011-05-21 10:46 Tonyyang 阅读(980) 评论(0) 推荐(0)

XAF 字符串属性ComboBox的数据源DataSourcePropertyAttribute提供动态选择的值

摘要： 1.CodenamespaceMemberLevelSecurityDemo.Module{#region"Copyright(c)2007to2010ExtrasoftLtd"////********************************************************************//TheentirecontentsofthisfileisprotectedbyUKand//InternationalCopyrightLaws.Unauthorizedreproduction,//reverse-engineering,anddis 阅读全文

posted @ 2011-05-21 10:36 Tonyyang 阅读(777) 评论(0) 推荐(0)

XAF 如何实现ListView首行新增按ENTER后重新聚焦首行

摘要： ///<summary>///首行新增，按ENTER,FocusedNewItemRow///Tonyyang///2011-05-18///</summary>publicclassFocusedNewItemRowListViewControler:ViewController{publicFocusedNewItemRowListViewControler(){//InitializeComponent();//RegisterActions(components);this.TargetViewType=ViewType.ListView;this.Activa 阅读全文

posted @ 2011-05-17 13:18 Tonyyang 阅读(569) 评论(0) 推荐(0)

XAF 如何实现两个ListView联动

摘要：例如：有部门和员工两个ListView1. 首先用模型编辑器添加一个DashboardView12. 然后再给DashboardView1添加两个Item：Department_ListView 和 Employee_ListView;3. 代码usingSystem;usingDevExpress.ExpressApp;usingDevExpress.ExpressApp.Editors;usingSystem.Collections;usingDevExpress.Data.Filtering;namespaceEasyTestTool.Module{publicpartialclassE 阅读全文

posted @ 2011-05-04 14:20 Tonyyang 阅读(1279) 评论(1) 推荐(0)

XAF 如何布局详细视图上的按钮

摘要： http://community.devexpress.com/blogs/garyshort/archive/2010/08/11/xaf-actions-in-detail-view-layout-v2010-vol-2.aspx 阅读全文

posted @ 2011-04-29 09:58 Tonyyang 阅读(772) 评论(0) 推荐(0)

XAF 帮助文档翻译 EasyTest Basics(基础)

摘要： EasyTest Basics(基础)eXpressApp Framework > Concepts > Functional Testing > EasyTest 基础 The eXpressApp Framework includes its own functional testing engine - EasyTest. All you need to know to use it is a set of commands allowed by test scripts. Using a custom script language has strong advant 阅读全文

posted @ 2011-04-26 14:07 Tonyyang 阅读(1170) 评论(0) 推荐(0)

XAF 如何显示一个提示面板

摘要： How to show a hint panel in an XAF Windows Forms applicationhttp://www.devexpress.com/Support/Center/CodeCentral/ViewExample.aspx?exampleId=E1148 阅读全文

posted @ 2011-04-25 16:54 Tonyyang 阅读(496) 评论(0) 推荐(0)

XAF Excel Importer

摘要： XAF 用Excel导入数据模块Here's a video on how it works: http://mdworkstuff.blogspot.com/2011/05/excel-import-wizard-demo-from.htmland a post on how to include it into an existing XAF project http://mdworkstuff.blogspot.com/2011/05/how-to-include-expandframework-module.htmlOne more common situation when 阅读全文

posted @ 2011-04-23 17:24 Tonyyang 阅读(972) 评论(0) 推荐(0)

XAF TimeSpan Editor

摘要： Here's a simple solution for entering TimeSpan data in a casual style : " 1 day 39 hours 78 min"The Solutions is to create a prpoperty editor that hosts simple Text editor, with some custom logic undeneath, that parses the string and converts it to TimeSpan after entering the string. A 阅读全文

posted @ 2011-04-23 14:28 Tonyyang 阅读(511) 评论(0) 推荐(0)

XAF 官方汉化

摘要： http://www.devexpress.com/Support/Center/p/A421.aspx 阅读全文

posted @ 2011-04-22 12:21 Tonyyang 阅读(972) 评论(0) 推荐(0)

.NET 學習

公告