World Of ιζσεα.

The Dark Time Will Pass

 

最新评论

共3页: 1 2 3 下一页 
EntLibVersion 微软企业库的版本V2或V3 这一项,如果你的项目是基于.NET 2.0的,就不要选V4的企业库,不然部署的时候会出现一些莫名其妙的错误,比如一些库文件找不到等等。究其根本,是因为V4的企业库调用到.NET 3.5的一些特性,而部署的网站采用.NET 2.0,所以会出错。 如果基于.NET 2.0,最好选用V3的企业库
我配置的时候没留意到有这个。。。说实话,之前项目紧,根本没找到有什么合适的文档学习。。。现在才看到楼主这个。 之前我都是直接用微软的企业库来调用存储过程的,也比较方便,比较通用。
Re:NetTiers学习笔记06---使用场景比较 拓荒者2 2009-07-21 15:57  
这篇可是字字珠玑呀。可惜没有看懂,希望举个例子来描述一下“场景”。谢谢。
re: subsonic 与 oracle.client 性能比较 Ψιζσεα. 2009-06-24 19:07  
@Dav
每一页的耗时, 其实都是累加的耗时
总耗时貌似就是最后一页的耗用时间吧
俺也没有弄出来,谁弄出来了,给俺发个demo,谢谢了
想想曾经奋斗的自己,应该是颇多感慨的吧,这些技术贴反应你的努力,相信也会激励你更勇敢地往前走的。
一转眼都2年了..
哎,看不太懂......
这个是哪个版本的nettiers呢?
适当方式大幅
用getpaged(0,10) 可以实现分页, 乱序的话, 试试写在order by中
各位高手,有个表要做些简单的编程,请高手们帮忙.
re: NetTiers学习笔记01---调用Data层操作数据 乄.菜心虫ㄣ 2009-04-20 16:51  
楼主,请问SQL 语句:select top 10 * from Table
order by newId()
用nettiers该怎么写?
re: subsonic 与 oracle.client 性能比较 上不了岸的鱼{ttzhang} 2009-03-27 13:03  
路过。。。嘿嘿
SqlFilterBuilder<ContractColumn> filter = new SqlFilterBuilder<ContractColumn>(); //test SqlFilterBuilder

filter.Junction = SqlUtil.AND;

filter.Append(ContractColumn.FContractPerson, "Jack , Ban , Tom"); //or jack or ban or tom

filter.Append(ContractColumn.FName, "*-02-01"); // like

filter.AppendIsNotNull(ContractColumn.FName); //is not null

filter.BeginGroup(SqlUtil.AND); //开始一个分组

filter.Junction = String.Empty; //"("后面没有and

filter.AppendIn(ContractColumn.FHouseId, "1,2,3,4");
filter.Junction = SqlUtil.OR;

string begindate = new DateTime(2005, 1, 1).ToString();
string enddate = DateTime.Now.ToString();

filter.AppendRange(ContractColumn.FDate, begindate,enddate); //范围

filter.EndGroup(); //结束分组

string result = filter.ToString();

DataRepository.UsersProvider.Find(result );

为什么报错报错:Unable to use this part of the where clause in this version of Find: uppermoduleid>2

还有你上面提到的“ (find 不支持直接写sql,用 TModuleQuery对象 的append xxx 来添加条件,最后调用 query 的GetParameters() 来获find需要查询条件)”
我不是份理解。你能不能针对我提出来的问题举个例来说明一下怎么给Find添加SQL语句,
能给个详细点的关于给FIND添加SQL语句的例子吗?
在线等 谢谢!


没说明白嘛,反正我是没有弄出来
楼主请帮忙,我在这篇博文中,作者使用nettiers 的tableprovider类,
http://www.cnblogs.com/eaglet/archive/2007/07/26/832427.html
可是我用 nettiers 2.3.0.788版本,随codesmith 5.0.5 带来的,生成代码后没有发现Data.DataRepository.TableProvider这个类怎么回事?

有没有办法修改模板,直接由data.DataRepository.entityprovider 在输出返回TList<> 方法的同时,也输出返回datatable的方法?
re: NetTiers学习笔记07---查询类的使用 Ψιζσεα. 2009-02-06 10:14  
@金成

主要是在web.config中添加多个nettiers的节点, 发一个config给你参考下

<?xml version="1.0"?>
<configuration>
<configSections>
<!--pet shop-->
<!--<section name="Stars.PetShop.Data" type="Stars.PetShop.Data.Bases.NetTiersServiceSection, Stars.PetShop.Data" allowDefinition="MachineToApplication" restartOnExternalChanges="true" />-->
<!--SerialNumber-->
<!--<section name="Stars.SerialNumber.Data" type="Stars.SerialNumber.Data.Bases.NetTiersServiceSection, Stars.SerialNumber.Data" allowDefinition="MachineToApplication" restartOnExternalChanges="true" />-->
<!--Rbac-->
<section name="Stars.Rbac.Data" type="Stars.Rbac.Data.Bases.NetTiersServiceSection, Stars.Rbac.Data" allowDefinition="MachineToApplication" restartOnExternalChanges="true"/>
<!--CMS-->
<section name="Stars.CMS.Data" type="Stars.CMS.Data.Bases.NetTiersServiceSection, Stars.CMS.Data" allowDefinition="MachineToApplication" restartOnExternalChanges="true"/>
<!--HRM-->
<section name="Stars.HRM.Data" type="Stars.HRM.Data.Bases.NetTiersServiceSection, Stars.HRM.Data" allowDefinition="MachineToApplication" restartOnExternalChanges="true"/>
<!--Configuration-->
<section name="Stars.Configuration.Data" type="Stars.Configuration.Data.Bases.NetTiersServiceSection, Stars.Configuration.Data" allowDefinition="MachineToApplication" restartOnExternalChanges="true"/>
<!--3rd party-->
<!--<section name="RewriterConfig" type="URLRewriter.Config.RewriterConfigSerializerSectionHandler, URLRewriter" />-->
<sectionGroup name="DCWeb">
<section name="HttpCompress" type="DC.Web.HttpCompress.Configuration, DC.Web.HttpCompress"/>
</sectionGroup>
<!--entlib-->
<section name="enterpriseLibrary.ConfigurationSource" type="Microsoft.Practices.EnterpriseLibrary.Common.Configuration.ConfigurationSourceSection, Microsoft.Practices.EnterpriseLibrary.Common, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
<!--microsoft-->
<sectionGroup name="system.web.extensions" type="System.Web.Configuration.SystemWebExtensionsSectionGroup, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35">
<sectionGroup name="scripting" type="System.Web.Configuration.ScriptingSectionGroup, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35">
<section name="scriptResourceHandler" type="System.Web.Configuration.ScriptingScriptResourceHandlerSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="MachineToApplication"/>
<sectionGroup name="webServices" type="System.Web.Configuration.ScriptingWebServicesSectionGroup, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35">
<section name="jsonSerialization" type="System.Web.Configuration.ScriptingJsonSerializationSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="Everywhere"/>
<section name="profileService" type="System.Web.Configuration.ScriptingProfileServiceSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="MachineToApplication"/>
<section name="authenticationService" type="System.Web.Configuration.ScriptingAuthenticationServiceSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="MachineToApplication"/>
<section name="roleService" type="System.Web.Configuration.ScriptingRoleServiceSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="MachineToApplication"/>
</sectionGroup>
</sectionGroup>
</sectionGroup>
</configSections>
<DCWeb>
<HttpCompress compressionType="GZip">
<CacheSettings cacheFiles="true" path="cache"/>
<PathSettings jsPath="Script" cssPath="Style"/>
<IncludedMimeTypes>
<add mime="text/html"/>
</IncludedMimeTypes>
<!--
<ExcludedMimeTypes>
<add mime="text/html" />
</ExcludedMimeTypes>
-->
<!--<ExcludedPaths>

<add path="~/Default.aspx" />
<add path="~/Login.aspx" />
<add path="~/oa/Desktop/Desktop.aspx" />
<add path="~/ftm/ImportAirway/ImportAirwayList.aspx" />

</ExcludedPaths>-->
</HttpCompress>
</DCWeb>
<appSettings>
<add key="HEADER_PREFIX" value="S.T.A.R.S CMS :: {0}"/>
<!--单用户登入-->
<add key="SINGLE_USER" value="0"/>
<!--Configuration-->
<add key="SYSTEM_CODE" value="21f49b64-e2fd-4c6b-bda4-9aca012eda81"/>
<!--CMS-->
<add key="OUTPUT_PATH" value="D:\S.T.A.R.S\Web-Root\PetShopSite"/>
<add key="RELATIVE_PATH" value=""/>
<add key="FILE_EXT" value="htm"/>
<add key="MAX_THREAD" value="10"/>
<!-- 1-5 -->
<add key="THREAD_LEVEL" value="3"/>
<add key="USE_CAPTCHA" value="0"/>
</appSettings>
<connectionStrings>
<!--petshop-->
<add name="Stars.PetShop.Data.ConnectionString" connectionString="Data Source=.\SQLEXPRESS;Initial Catalog=PetShop;user=sa;pwd=111;Connect Timeout=30;"/>
<!--SerialNumber-->
<add name="Stars.SerialNumber.Data.ConnectionString" connectionString="Data Source=.\SQLEXPRESS;Initial Catalog=SerialNumber;user=sa;pwd=111;Connect Timeout=30;"/>
<!--rbac-->
<add name="Stars.Rbac.Data.ConnectionString" connectionString="Data Source=.\SQLEXPRESS;Initial Catalog=rbac;user=sa;pwd=111;Connect Timeout=30;"/>
<!--CMS-->
<add name="Stars.CMS.Data.ConnectionString" connectionString="Data Source=.\SQLEXPRESS;Initial Catalog=CMS;user=sa;pwd=111;Connect Timeout=30;"/>
<!--HRM-->
<add name="Stars.HRM.Data.ConnectionString" connectionString="Data Source=.\SQLEXPRESS;Initial Catalog=CMS;user=sa;pwd=111;Connect Timeout=30;"/>
<!--Configuration-->
<add name="Stars.Configuration.Data.ConnectionString" connectionString="Data Source=.\SQLEXPRESS;Initial Catalog=Configuration;user=sa;pwd=111;Connect Timeout=30;"/>
</connectionStrings>
<!--PetShop-->
<!--<Stars.CMS.Data>
<providers>
<add name="SqlNetTiersProvider" type="Stars.PetShop.Data.SqlClient.SqlNetTiersProvider, Stars.PetShop.Data.SqlClient" connectionStringName="Stars.PetShop.Data.ConnectionString" providerInvariantName="System.Data.SqlClient" entityFactoryType="Stars.PetShop.Entities.EntityFactory" useEntityFactory="true" enableEntityTracking="true" enableMethodAuthorization="false" useStoredProcedure="false" defaultCommandTimeout="30" />
</providers>
</Stars.CMS.Data>-->
<!--SerialNumber-->
<!--<Stars.SerialNumber.Data defaultProvider="SqlNetTiersProvider">
<providers>
<add name="SqlNetTiersProvider" type="Stars.SerialNumber.Data.SqlClient.SqlNetTiersProvider, Stars.SerialNumber.Data.SqlClient" connectionStringName="Stars.SerialNumber.Data.ConnectionString" providerInvariantName="System.Data.SqlClient" entityFactoryType="Stars.SerialNumber.Entities.EntityFactory" useEntityFactory="true" enableEntityTracking="true" enableMethodAuthorization="false" useStoredProcedure="false" defaultCommandTimeout="30" />
</providers>
</Stars.SerialNumber.Data>-->
<!--Rbac-->
<Stars.Rbac.Data defaultProvider="SqlNetTiersProvider">
<providers>
<add name="SqlNetTiersProvider" type="Stars.Rbac.Data.SqlClient.SqlNetTiersProvider, Stars.Rbac.Data.SqlClient" connectionStringName="Stars.Rbac.Data.ConnectionString" providerInvariantName="System.Data.SqlClient" entityFactoryType="Stars.Rbac.Entities.EntityFactory" useEntityFactory="true" enableEntityTracking="true" enableMethodAuthorization="false" useStoredProcedure="false" defaultCommandTimeout="30"/>
</providers>
</Stars.Rbac.Data>
<!--CMS-->
<Stars.CMS.Data defaultProvider="SqlNetTiersProvider">
<providers>
<add name="SqlNetTiersProvider" type="Stars.CMS.Data.SqlClient.SqlNetTiersProvider, Stars.CMS.Data.SqlClient" connectionStringName="Stars.CMS.Data.ConnectionString" providerInvariantName="System.Data.SqlClient" entityFactoryType="Stars.CMS.Entities.EntityFactory" useEntityFactory="false" enableEntityTracking="false" enableMethodAuthorization="false" useStoredProcedure="false" defaultCommandTimeout="30"/>
</providers>
</Stars.CMS.Data>
<!--HRM-->
<Stars.HRM.Data defaultProvider="SqlNetTiersProvider">
<providers>
<add name="SqlNetTiersProvider" type="Stars.HRM.Data.SqlClient.SqlNetTiersProvider, Stars.HRM.Data.SqlClient" connectionStringName="Stars.HRM.Data.ConnectionString" providerInvariantName="System.Data.SqlClient" entityFactoryType="Stars.HRM.Entities.EntityFactory" useEntityFactory="false" enableEntityTracking="true" enableMethodAuthorization="false" useStoredProcedure="false" defaultCommandTimeout="30"/>
</providers>
</Stars.HRM.Data>
<!--Configuration-->
<Stars.Configuration.Data defaultProvider="SqlNetTiersProvider">
<providers>
<add name="SqlNetTiersProvider" type="Stars.Configuration.Data.SqlClient.SqlNetTiersProvider, Stars.Configuration.Data.SqlClient" connectionStringName="Stars.Configuration.Data.ConnectionString" providerInvariantName="System.Data.SqlClient" entityFactoryType="Stars.Configuration.Entities.EntityFactory" useEntityFactory="true" enableEntityTracking="true" enableMethodAuthorization="false" useStoredProcedure="false" defaultCommandTimeout="30"/>
</providers>
</Stars.Configuration.Data>
<system.web>
<machineKey validationKey="F398AE70C98A10D6611D7F78DD2F94CA36FA7097" decryptionKey="15DAF21530C667300905EFF62C5F8FD0FD0E016C80EDE1B7" decryption="3DES" validation="SHA1"/>
<httpModules>
<!--PetShop-->
<!--<add name="PetShop.EntityTransactionModule" type="Stars.CMS.Web.Data.EntityTransactionModule, Stars.CMS.Web" />-->
<!--SerialNumber-->
<!-- <add name="SerialNumber.EntityTransactionModule" type="Stars.SerialNumber.Web.Data.EntityTransactionModule" />-->
<!--Rbac-->
<!--<add name="EntityTransactionModule" type="Stars.Rbac.Web.Data.EntityTransactionModule" />-->
<!--CMS-->
<add name="EntityTransactionModule" type="Stars.CMS.Web.Data.EntityTransactionModule"/>
<!--Configuration-->
<!--<add name="EntityTransactionModule" type="Stars.Configuration.Web.Data.EntityTransactionModule" />-->
<!--3rd party-->
<!--<add name="QueryStringUrlRemapper" type="Stars.Web.HttpModule.UrlRemapper, Stars.Web.HttpModule"/>-->
<!--<add name="ModuleRewriter" type="URLRewriter.ModuleRewriter, URLRewriter" />-->
<!--microsoft ajax-->
<add name="ScriptModule" type="System.Web.Handlers.ScriptModule, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
</httpModules>
<compilation debug="true">
<assemblies>
<add assembly="System.Core, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>
<add assembly="System.Data.DataSetExtensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>
<add assembly="System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
<add assembly="System.Xml.Linq, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>
<add assembly="System.Design, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>
</assemblies>
</compilation>
<!--<authentication mode="Windows" />-->
<authentication mode="Forms">
<forms name=".Stars.PetShop" defaultUrl="Default.aspx" loginUrl="Login.aspx" protection="All" timeout="30" path="/" requireSSL="false" slidingExpiration="true" enableCrossAppRedirects="false" cookieless="AutoDetect"></forms>
</authentication>
<authorization>
<deny users="?"/>
</authorization>
<customErrors mode="Off" defaultRedirect="GenericErrorPage.htm">
<error statusCode="403" redirect="NoAccess.htm"/>
<error statusCode="404" redirect="FileNotFound.htm"/>
</customErrors>
<trace enabled="false" pageOutput="true" traceMode="SortByCategory" localOnly="true" mostRecent="true" writeToDiagnosticsTrace="true"/>
<globalization requestEncoding="utf-8" responseEncoding="utf-8"/>
<pages theme="default" pageBaseType="Stars.Web.UI.PageBase" userControlBaseType="Stars.Web.UI.UserControlBase" maintainScrollPositionOnPostBack="true" masterPageFile="~/MasterPage.Master" validateRequest="false" enableViewStateMac="true">
<controls>
<!--user controls-->
<add tagPrefix="stars" src="~/Hrms/UserInfo.ascx" tagName="UserInfo"/>
<add tagPrefix="stars" src="~/Debug/DebugInfo.ascx" tagName="DebugInfo"/>
<add tagPrefix="stars" src="~/Help/Tags.ascx" tagName="UcTags"/>
<add tagPrefix="stars" namespace="Stars.Web.UI" assembly="Stars.Web.UI"/>
<!--pet shop-->
<!--<add tagPrefix="stars" namespace="Stars.CMS.Web.Data" assembly="Stars.CMS.Web" />
<add tagPrefix="stars" namespace="Stars.CMS.Web.UI" assembly="Stars.CMS.Web" />-->
<!--SerialNumber-->
<!-- <add tagPrefix="stars" namespace="Stars.SerialNumber.Web.Data" assembly="Stars.SerialNumber.Web" />
<add tagPrefix="stars" namespace="Stars.SerialNumber.Web.UI" assembly="Stars.SerialNumber.Web" />-->
<!--Rbac-->
<!--<add tagPrefix="stars" namespace="Stars.Rbac.Web.Data" assembly="Stars.Rbac.Web" />
<add tagPrefix="stars" namespace="Stars.Rbac.Web.UI" assembly="Stars.Rbac.Web" />-->
<!--CMS-->
<add tagPrefix="cms" namespace="Stars.CMS.Web.Data" assembly="Stars.CMS.Web"/>
<add tagPrefix="cms" namespace="Stars.CMS.Web.UI" assembly="Stars.CMS.Web"/>
<!--HRM-->
<add tagPrefix="hrm" namespace="Stars.HRM.Web.Data" assembly="Stars.HRM.Web"/>
<add tagPrefix="hrm" namespace="Stars.HRM.Web.UI" assembly="Stars.HRM.Web"/>
<!--Configuration-->
<add tagPrefix="config" namespace="Stars.Configuration.Web.Data" assembly="Stars.Configuration.Web"/>
<add tagPrefix="config" namespace="Stars.Configuration.Web.UI" assembly="Stars.Configuration.Web"/>
<!--3rd party-->
<add tagPrefix="Ext" namespace="Coolite.Ext.Web" assembly="Coolite.Ext.Web"/>
<add tagPrefix="Captcha" namespace="WebControlCaptcha" assembly="WebControlCaptcha"/>
<!--microsoft-->
<add tagPrefix="asp" namespace="System.Web.UI" assembly="System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
<add tagPrefix="asp" namespace="System.Web.UI.WebControls" assembly="System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
</controls>
</pages>
<httpHandlers>
<remove path="*.asmx" verb="*"/>
<!--CaptchaImage-->
<add verb="GET" path="CaptchaImage.axd" type="WebControlCaptcha.CaptchaImageHandler, WebControlCaptcha"/>
<!--3rd party-->
<add path="*/coolite.axd" verb="*" type="Coolite.Ext.Web.ResourceManager, Coolite.Ext.Web" validate="false"/>
<!--microsoft-->
<add path="*.asmx" verb="*" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" validate="false"/>
<add path="*_AppService.axd" verb="*" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" validate="false"/>
<add path="ScriptResource.axd" verb="GET,HEAD" type="System.Web.Handlers.ScriptResourceHandler, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" validate="false"/>
</httpHandlers>
<sessionState mode="InProc" stateConnectionString="tcpip=127.0.0.1:42424" sqlConnectionString="data source=127.0.0.1;Trusted_Connection=yes" cookieless="AutoDetect" timeout="20"/>
<!--<sessionState mode="SQLServer" sqlConnectionString="Data Source=.\SQLEXPRESS;user=sa;pwd=111;" timeout="30" cookieName=".CMS" cookieless="AutoDetect" />-->
<!--upload files limit 10mb-->
<httpRuntime maxRequestLength="10240"/>
</system.web>
<!--security config-->
<location path="Javascript">
<system.web>
<authorization>
<allow users="?"/>
</authorization>
</system.web>
</location>
<location path="Images">
<system.web>
<authorization>
<allow users="?"/>
</authorization>
</system.web>
</location>
<!--<location path="ig_common">
<system.web>
<authorization>
<allow users="?" />
</authorization>
</system.web>
</location>-->
<!--<location path="App_Themes">
<system.web>
<authorization>
<allow users="?" />
</authorization>
</system.web>
</location>-->
<!--<location path="css">
<system.web>
<authorization>
<allow users="?" />
</authorization>
</system.web>
</location>-->
<!--<location path="RadControls">
<system.web>
<authorization>
<allow users="?" />
</authorization>
</system.web>
</location>-->
<!--<location path="MasterPages">
<system.web>
<authorization>
<allow users="?" />
</authorization>
</system.web>
</location>-->
<!--<location path="Logs">
<system.web>
<authorization>
<allow users="?" />
</authorization>
</system.web>
</location>-->
<location path="Templete">
<system.web>
<authorization>
<allow users="?"/>
</authorization>
</system.web>
</location>
<location path="css">
<system.web>
<authorization>
<allow users="?"/>
</authorization>
</system.web>
</location>
<!--<location path="Script">
<system.web>
<authorization>
<allow users="?" />
</authorization>
</system.web>
</location>-->
<location path="CaptchaImage.axd">
<system.web>
<authorization>
<allow users="?"/>
</authorization>
</system.web>
</location>
<!--ent lib-->
<enterpriseLibrary.ConfigurationSource selectedSource="File Configuration Source">
<sources>
<add name="File Configuration Source" type="Microsoft.Practices.EnterpriseLibrary.Common.Configuration.FileConfigurationSource, Microsoft.Practices.EnterpriseLibrary.Common, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" filePath="entlib.config"/>
</sources>
</enterpriseLibrary.ConfigurationSource>
<!--<RewriterConfig>
<Rules>-->
<!-- Rules for Product Lister -->
<!--
-->
<!--<RewriterRule>
<LookFor>~/([^/]*)/([^/.]*)</LookFor>
<SendTo>~/$1.aspx$2</SendTo>
</RewriterRule>
<RewriterRule>
<LookFor>~/([^/]*)/([^/]*)/([^/.]*)</LookFor>
<SendTo>~/$1/$2.aspx$3</SendTo>
</RewriterRule>
<RewriterRule>
<LookFor>~/([^/]*)/([^/]*)/([^/]*)/([^/.]*)</LookFor>
<SendTo>~/$1/$2/$3.aspx$4</SendTo>
</RewriterRule>-->
<!--</Rules>
</RewriterConfig>-->
<system.codedom>
<compilers>
<compiler language="c#;cs;csharp" extension=".cs" warningLevel="4" type="Microsoft.CSharp.CSharpCodeProvider,System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">
<providerOption name="CompilerVersion" value="v3.5"/>
<providerOption name="WarnAsError" value="false"/>
</compiler>
</compilers>
</system.codedom>
<!--
IIS 7.0
-->
<system.webServer>
<validation validateIntegratedModeConfiguration="false"/>
<modules>
<remove name="ScriptModule"/>
<add name="ScriptModule" preCondition="managedHandler" type="System.Web.Handlers.ScriptModule, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
</modules>
<handlers>
<remove name="WebServiceHandlerFactory-Integrated"/>
<remove name="ScriptHandlerFactory"/>
<remove name="ScriptHandlerFactoryAppServices"/>
<remove name="ScriptResource"/>
<add name="ScriptHandlerFactory" verb="*" path="*.asmx" preCondition="integratedMode" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
<add name="ScriptHandlerFactoryAppServices" verb="*" path="*_AppService.axd" preCondition="integratedMode" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
<add name="ScriptResource" preCondition="integratedMode" verb="GET,HEAD" path="ScriptResource.axd" type="System.Web.Handlers.ScriptResourceHandler, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
</handlers>
</system.webServer>
<runtime>
<assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
<dependentAssembly>
<assemblyIdentity name="System.Web.Extensions" publicKeyToken="31bf3856ad364e35"/>
<bindingRedirect oldVersion="1.0.0.0-1.1.0.0" newVersion="3.5.0.0"/>
</dependentAssembly>
<dependentAssembly>
<assemblyIdentity name="System.Web.Extensions.Design" publicKeyToken="31bf3856ad364e35"/>
<bindingRedirect oldVersion="1.0.0.0-1.1.0.0" newVersion="3.5.0.0"/>
</dependentAssembly>
</assemblyBinding>
</runtime>
</configuration>
问一下连接多个数据库的具体配置方法
可以, 需要用codesmith生成2次, 然后配置web.config
有问题请教
.nettiers是否可以连接多数据库,如果可以应该如何设置
re: NetTiers学习笔记07---查询类的使用 Ψιζσεα. 2008-11-29 16:45  
re: NetTiers学习笔记07---查询类的使用 Patrick Zhu 2008-11-29 13:43  
还有一个问题,读取分页的数据是否需要指定页数,每页记录数?
re: NetTiers学习笔记07---查询类的使用 Patrick Zhu 2008-11-29 13:31  
多谢。

博主真是一个热心人。有没有人建个QQ群,用来讨论.nettiers的?
re: NetTiers学习笔记07---查询类的使用 Ψιζσεα. 2008-11-29 11:55  
1. TPmtRegisterTermQuery filter = new TPmtRegisterTermQuery();

filter.AppendEquals(TPmtRegisterTermColumn.Companyid, "1");
DataRepository.TPmtRegisterTermProvider.Find(filter.GetParameters(), "", 0, 100, out count);


2. 不能指定字段, 查询结果就是一个对象, 绑定下拉菜单的话, 设置下拉菜单的datatextfield ,datavaluefield

3. 级联的话跟数据源没什么关系吧, 该怎么做还是怎么做
re: NetTiers学习笔记07---查询类的使用 Patrick Zhu 2008-11-29 11:19  
请教几个问题:

1, 如何按照条件select记录?

2, select时可以指定只要指定的字段么?比如用于填充下拉列表的时候

3, 下拉列表的级联,第二级怎么写?

多谢。
不知道怎么感谢你
真的谢谢~~ 问题解决了!
re: NetTiers学习笔记07---查询类的使用 Ψιζσεα. 2008-11-25 11:23  
find 不支持直接写sql
用 TModuleQuery对象 的append xxx 来添加条件

最后调用 query 的GetParameters() 来获find需要查询条件


有邮件提醒..所以回得快
public TList<TModule> SelectModelByUpID(int id)
{
return DataRepository.TModuleProvider.Find("UpperModuleID>" + id);
}
报错:Unable to use this part of the where clause in this version of Find: uppermoduleid>2
Find有很多版本么?
谢谢,没想到博主这么快回消息!
re: NetTiers学习笔记07---查询类的使用 Ψιζσεα. 2008-11-25 10:03  
@金成
代码
请问生成的这个查询串是使用 Find来查询时使用的么?
为什么我在使用有( 、> 和<的查询时都会报错,似乎是只能查询等号的情况.
为什么啊?

CodeSmith 5.0
.netTiers v2.3.0.764
哦,我明白了,总觉得这样不是太好
re: NetTiers学习笔记07---查询类的使用 Ψιζσεα. 2008-10-13 13:35  
@namefree
的确是这样的, 不过 sql 会尝试将 string 转 int 的
可是生成的SQL语句却加上了'号的
re: NetTiers学习笔记07---查询类的使用 Ψιζσεα. 2008-10-13 01:29  
直接用string 就可以了, 包括datetime int guid 之类的 都是传string
这个类型是自动判断的吗,我看了下代码,好象不是的,它有一个encode的属性,可有的就没有这个属性,那就一律加上了'号
您回复的很快,

那我还有一个问题,怎么添加这样的 id=9的条件,貌似没有int的类型
re: NetTiers学习笔记07---查询类的使用 Ψιζσεα. 2008-10-12 21:03  
例子找不到了, [表名]Column 是一个枚举类型, 里面有该表中所有的列
您好,您的这个例子能不能给我一个完整的例子,我对ContractColumn的构造不理解,谢谢你了,时常关注您的文章.
如果需要
select * from tAAA where Field1 > Field2 这样的查询
要怎么实现?
Field1 Field2都是 tAAA 表的一个字段
非常感谢,学到了很多东西
很好,看了之后明白多了,谢谢!
最新版本(cm5.0)的吗?
非常感谢
re: NetTiers学习笔记07---查询类的使用 Ψιζσεα. 2008-09-09 18:03  
类似于 "where a.id=b.id" 的查询条件, 用视图的方法比较容易实现

建一个视图, 生成后, 会有[视图名]的新对象
查询的方法跟表的一样
我碰到的问题就是类似
select b.* from a,b where a.id=b.id

不知道在nettires里怎么写
re: NetTiers学习笔记07---查询类的使用 Ψιζσεα. 2008-09-09 17:20  
是情况而定吧, 表比较少的, 可以用deepload, 关系复杂的可以用视图
如果是做一个列表(只是用于绑定grid), 用视图比较好
共3页: 1 2 3 下一页 

导航

统计

公告

昵称:Ψιζσεα.
园龄:5年2个月
粉丝:5
关注:1

搜索

 
 

常用链接

最新随笔

我的标签

随笔分类(50)

随笔档案(17)

相册

积分与排名

最新评论

阅读排行榜

评论排行榜

推荐排行榜